0% found this document useful (0 votes)
81 views11 pages

Recipe Cost and Energy Analysis

The document contains a recipe dataset with 30 recipes. It includes information on the dish number, cost, preparation time, capacity, and ingredients used for each recipe. The key metrics provided are the cost per second (C/s), capacity, maximum potential profit, maximum preparation time needed, and energy cost for each recipe. The energy cost of each main ingredient is also listed. The recipes can be optimized for various objectives such as maximum profit, capacity, or preparation efficiency.
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
81 views11 pages

Recipe Cost and Energy Analysis

The document contains a recipe dataset with 30 recipes. It includes information on the dish number, cost, preparation time, capacity, and ingredients used for each recipe. The key metrics provided are the cost per second (C/s), capacity, maximum potential profit, maximum preparation time needed, and energy cost for each recipe. The energy cost of each main ingredient is also listed. The recipes can be optimized for various objectives such as maximum profit, capacity, or preparation efficiency.
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 11

Recipe

Dish No. Cost time (s) C/s Capacity Pork Cheese Seafood Pepper
1 41 4 10.25 6000 1
2 51 5 10.20 4800 1
3 134 14 9.57 1847 2 1
4 46 4 11.50 5400 1
5 272 29 9.38 912 2 1 3
6 143 15 9.53 1728 1 2
7 115 12 9.58 2160 1 1
8 151 16 9.44 1637 2 1
9 120 12 10.00 2058 1 1
10 254 27 9.41 978 1 1 2 1
11 103 11 9.36 2400
12 155 16 9.69 1601 1
13 265 28 9.46 936 1 1 1
14 172 18 9.56 1440 1
15 82 8 10.25 3000
16 128 13 9.85 1929 1
17 258 27 9.56 961 1 1
18 255 27 9.44 973 1
19 517 55 9.40 481
20 382 40 9.55 649 1 1
21 368 39 9.44 675 2 1
22 425 45 9.44 584 1 1
23 897 96 9.34 277
24 979 104 9.41 254
25 496 53 9.36 500
26 538 57 9.44 462 1
27 2690 288 9.34 93
28 1630 175 9.31 152
29 2110 226 9.34 118 1
30 2380 254 9.37 105
Recipe
Chicken Wheat Veggies Honey Ice Column1 Energy Cost in x100,000
0.000699301 69.93
0.000755858 75.59
0.002517170 251.72
0.000755858 75.59
0.005055064 505.51
0.005161351 516.14
0.001874426 187.44
0.002517170 251.72
0.007654516 765.45
0.003329585 332.96
1 0.001760563 176.06
1 0.001760563 176.06
1 0.003578432 357.84
1 0.002879132 287.91
1 0.001388889 138.89
1 0.002144747 214.47
2 0.003477078 347.71
1 1 0.004268021 426.80
1 2 0.009059833 905.98
1 1 0.005737825 573.78
1 0.006279919 627.99
1 1 0.007284625 728.46
1 5 0.015640043 1564.00
1 1 5 0.017028932 1702.89
1 3 0.012337794 1233.78
1 3 0.013037095 1303.71
1 3 10 0.046304873 4630.49
1 1 7 0.027972147 2797.21
10 0.036216851 3621.69
1 1 5 0.038089937 3808.99
C/E/s C/E Max. Profit Max. time Needed Energy
14657.50 58630.0 246000.0 6.7 4.2
13494.60 67473.0 244800.0 6.7 3.6
3802.46 53234.4 247498.0 7.2 4.6
15214.50 60858.0 248400.0 6.0 4.1
1855.43 53807.4 248064.0 7.3 4.6
1847.06 27705.9 247104.0 7.2 8.9
5112.68 61352.1 248400.0 7.2 4.0
3749.25 59988.0 247187.0 7.3 4.1
1306.42 15677.0 246960.0 6.9 15.8
2825.40 76285.8 248412.0 7.3 3.3
5318.55 58504.0 247200.0 7.3 4.2
5502.50 88040.0 248155.0 7.1 2.8
2644.81 74054.8 248040.0 7.3 3.3
3318.90 59740.2 247680.0 7.2 4.1
7380.00 59040.0 246000.0 6.7 4.2
4590.82 59680.7 246912.0 7.0 4.1
2748.16 74200.2 247938.0 7.2 3.3
2212.84 59746.7 248115.0 7.3 4.2
1037.55 57065.1 248677.0 7.3 4.4
1664.39 66575.8 247918.0 7.2 3.7
1502.55 58599.5 248400.0 7.3 4.2
1296.49 58342.1 248200.0 7.3 4.3
597.42 57352.8 248469.0 7.4 4.3
552.79 57490.4 248666.0 7.3 4.3
758.52 40201.7 248000.0 7.4 6.2
723.98 41266.9 248556.0 7.3 6.0
201.71 58093.2 250170.0 7.4 4.3
332.98 58272.3 247760.0 7.4 4.3
257.79 58260.2 248980.0 7.4 4.3
246.00 62483.7 249900.0 7.4 4.0
Energy/ Ingredient
1 Pork 1430 0.000699300699301
2 Cheese 1160 0.000862068965517
3 Seafood 1323 0.000755857898715
4 Pepper 894 0.001118568232662
5 Chicken 568 0.001760563380282
6 Wheat 720 0.001388888888889
7 Veggies 274 0.003649635036496
8 Honey 417 0.002398082
9 Ice 282 0.00354609929078
10 Hot Sauce 153 0.006535947712418
Recipe
Dish No. Cost time (s) C/s Capacity Pork Cheese Seafood Pepper
9 113 18 6.28 1429 1 1
12 145 23 6.30 1112 1
17 243 38 6.39 667 1 1
13 249 39 6.38 650 1 1 1
10 238 37 6.43 679 1 1 2 1
20 359 57 6.30 451 1 1
2 48 7 6.86 3334 1
23 842 133 6.33 193
27 2520 401 6.28 65
19 486 77 6.31 334
22 399 63 6.33 406 1 1
15 77 12 6.42 2084
21 345 54 6.39 469 2 1
11 97 15 6.47 1667
18 239 38 6.29 676 1
8 142 22 6.45 1137 2 1
14 162 25 6.48 1000 1
16 120 19 6.32 1340 1
1 38 6 6.33 4167 1
7 108 17 6.35 1500 1 1
4 43 6 7.17 3750 1
5 255 40 6.38 633 2 1 3
3 126 20 6.30 1283 2 1
6 135 21 6.43 1200 1 2
Recipe
Chicken Wheat Veggies Honey Ice Column1 Energy Cost in x100,000
0.001602564 160.26
1 0.002358491 235.85
2 0.004638283 463.83
1 0.004895634 489.56
0.004715793 471.58
1 1 0.007331886 733.19
0.001089325 108.93
1 5 0.019426407 1942.64
1 3 10 0.058519071 5851.91
1 2 0.011449400 1144.94
1 1 0.009595834 959.58
1 0.001851852 185.19
1 0.008326668 832.67
1 0.002358491 235.85
1 1 0.005812907 581.29
0.003471723 347.17
1 0.003961055 396.11
1 0.002941176 294.12
0.000934579 93.46
0.002691889 269.19
0.001089325 108.93
0.006988985 698.90
0.003471723 347.17
0.006724104 672.41
C/E/s C/E Max. Profit Max. time Needed Energy
3917.33 70512.0 161477.0 7.1 2.3 1 9
2673.04 61480.0 161240.0 7.1 2.6 4 12
1378.69 52390.1 162081.0 7.0 3.1 2 10
1304.14 50861.6 161850.0 7.0 3.2 9 2
1364.02 50468.7 161602.0 7.0 3.2 15 13
859.02 48964.2 161909.0 7.1 3.3 11 8
6294.86 44064.0 160032.0 6.5 3.6 12 11
325.89 43343.1 162506.0 7.1 3.7 7 1
107.39 43062.9 163800.0 7.2 3.8 16 17
551.27 42447.6 162324.0 7.1 3.8 8 7
660.01 41580.5 161994.0 7.1 3.9 3 4
3465.00 41580.0 160468.0 6.9 3.9 14 20
767.28 41433.1 161805.0 7.0 3.9 17 5
2741.87 41128.0 161699.0 6.9 3.9 10 3
1081.98 41115.4 161564.0 7.1 3.9 13 6
1859.18 40901.9 161454.0 6.9 3.9 18 19
1635.93 40898.2 162000.0 6.9 4.0 6 14
2147.37 40800.0 160800.0 7.1 3.9 5 15
6776.67 40660.0 158346.0 6.9 3.9 20 23
2360.03 40120.5 162000.0 7.1 4.0 21 22
6579.00 39474.0 161250.0 6.3 4.1 22 27
912.15 36486.0 161415.0 7.0 4.4 19 21
1814.66 36293.2 161658.0 7.1 4.5 23 18
956.05 20077.0 162000.0 7.0 8.1 27 16
2.5 1 4 2.5
4.5 2 7 4.5
4.5 3 4 3.5
5 4 3 3.5
6 5 4 4.5
9.5 6 3 4.5
10 7 6 6.5
10 8 1 4.5
10.5 9 13 11
11.5 10 3 6.5
12 11 3 7
12.5 12 19 15.5
12.5 13 3 8
13 14 3 8.5
13.5 15 3 9
14 16 18 17
14.5 17 12 14.5
15 18 5 11.5
15.5 19 23 21
16 20 21 20.5
16.5 21 24 22.5
16.5 22 20 21
16.5 23 16 19.5
18 24 9 16.5
Recipe
Dish No. Cost time (s) C/s Capacity Pork Cheese Seafood Pepper
12 155 16 9.69 1601 1
10 254 27 9.41 978 1 1 2 1
17 258 27 9.56 961 1 1
13 265 28 9.46 936 1 1 1
2 51 5 10.20 4800 1
20 382 40 9.55 649 1 1
30 2380 254 9.37 105
7 115 12 9.58 2160 1 1
4 46 4 11.50 5400 1
8 151 16 9.44 1637 2 1
18 255 27 9.44 973 1
14 172 18 9.56 1440 1
16 128 13 9.85 1929 1
15 82 8 10.25 3000
1 41 4 10.25 6000 1
21 368 39 9.44 675 2 1
11 103 11 9.36 2400
22 425 45 9.44 584 1 1
28 1630 175 9.31 152
29 2110 226 9.34 118 1
27 2690 288 9.34 93
24 979 104 9.41 254
23 897 96 9.34 277
19 517 55 9.40 481
5 272 29 9.38 912 2 1 3
3 134 14 9.57 1847 2 1
26 538 57 9.44 462 1
25 496 53 9.36 500
6 143 15 9.53 1728 1 2
9 120 12 10.00 2058 1 1
Recipe
Chicken Wheat Veggies Honey Ice Column1 Energy Cost in x100,000
1 0.001760563 176.06
0.003329585 332.96
2 0.003477078 347.71
1 0.003578432 357.84
0.000755858 75.59
1 1 0.005737825 573.78
1 1 5 0.038089937 3808.99
0.001874426 187.44
0.000755858 75.59
0.002517170 251.72
1 1 0.004268021 426.80
1 0.002879132 287.91
1 0.002144747 214.47
1 0.001388889 138.89
0.000699301 69.93
1 0.006279919 627.99
1 0.001760563 176.06
1 1 0.007284625 728.46
1 1 7 0.027972147 2797.21
10 0.036216851 3621.69
1 3 10 0.046304873 4630.49
1 1 5 0.017028932 1702.89
1 5 0.015640043 1564.00
1 2 0.009059833 905.98
0.005055064 505.51
0.002517170 251.72
1 3 0.013037095 1303.71
1 3 0.012337794 1233.78
0.005161351 516.14
0.007654516 765.45
C/E/s C/E Max. Profit Max. time Needed Energy
5502.50 88040.0 248155.0 7.1 2.8
2825.40 76285.8 248412.0 7.3 3.3
2748.16 74200.2 247938.0 7.2 3.3
2644.81 74054.8 248040.0 7.3 3.3
13494.60 67473.0 244800.0 6.7 3.6
1664.39 66575.8 247918.0 7.2 3.7
246.00 62483.7 249900.0 7.4 4.0
5112.68 61352.1 248400.0 7.2 4.0
15214.50 60858.0 248400.0 6.0 4.1
3749.25 59988.0 247187.0 7.3 4.1
2212.84 59746.7 248115.0 7.3 4.2
3318.90 59740.2 247680.0 7.2 4.1
4590.82 59680.7 246912.0 7.0 4.1
7380.00 59040.0 246000.0 6.7 4.2
14657.50 58630.0 246000.0 6.7 4.2
1502.55 58599.5 248400.0 7.3 4.2
5318.55 58504.0 247200.0 7.3 4.2
1296.49 58342.1 248200.0 7.3 4.3
332.98 58272.3 247760.0 7.4 4.3
257.79 58260.2 248980.0 7.4 4.3
201.71 58093.2 250170.0 7.4 4.3
552.79 57490.4 248666.0 7.3 4.3
597.42 57352.8 248469.0 7.4 4.3
1037.55 57065.1 248677.0 7.3 4.4
1855.43 53807.4 248064.0 7.3 4.6
3802.46 53234.4 247498.0 7.2 4.6
723.98 41266.9 248556.0 7.3 6.0
758.52 40201.7 248000.0 7.4 6.2
1847.06 27705.9 247104.0 7.2 8.9
1306.42 15677.0 246960.0 6.9 15.8

You might also like