Your job is to prepare a production schedule (considering the constraints and rules of this case in Chp 19), and to determine the operating budget for such a plan.

the Simulation Worksheet where you need to indicate the Actual Production Rate and the Actual Demand columns cells (in reality the actual data would be getting filled in each week as time progresses, but you need to fill all 52 weeks with numbers (simply enter 450 into the Actual Production Rate column (each cell) and then copy the Forecast column into the Actual Demand column). Thanks

Simulation Worksheet Beginning Inventory Qtr Wk Lines Scheduled Scheduled Production Expected Ending Forecast Demand Expected Wooks Actual Production of-Supply Rate (cases/hour) Actual Demand (1,000 Cases) Actual Production Actual Ending Inventory Inventory 10 10 10 10 10 10 10 10 10 10 TU 10 10 10 8 8 Overtime Scheduled (hours) 1 1 1 1 1 1 1 1 1 1 1 200.0 237.4 274.8 312.2 349.6 101 387.0 424.4 461.8 499.2 499.2 536.6 574.0 611.4 8 8 8 8 8 1 2 3 4 5 6 1st 7 8 9 10 TU 11 12 12 13 14 14 15 45 16 40 47 17 40 18 40 19 2nd 20 21 22 23 24 25 26 27 29 28 20 29 20 30 31 32 3rd 33 2 34 35 36 37 38 39 40 41 42 43 44 45 648.8 6488 ARE 686.3 670.0 652 653.8 6278 637.6 6242 621.3 605.1 00 588.9 572.6 556.4 540.2 523.9 8 8 8 8 8 8 9 9 9 9 191.3 191.3 191.3 191.3 191.3 191.3 191.3 191.3 191.3 191.3 191.3 191.3 191.3 1520 153.0 1520 153.0 1990 153.0 4 153.0 520 153.0 462 153.0 153.0 ro 153.0 153.0 153.0 153.0 153.0 153.0 192.4 1920 1920 192.4 402 192.4 402 192.4 100 192.4 4022 192.4 402 192.4 100 192.4 2007 192.4 100 192.4 192.4 1967 192.4 2017 192.4 210.4 10.1 210.4 10 210.4 210.4 210.4 210.4 153.8 153.8 153.8 153.8 153.8 153.8 1.o 153.8 133.0 153.8 153.8 153.8 153.8 153.8 153.8 169.2 180 169.2 460 169.2 460 169.2 100 169.2 4602 169.2 160 169.2 100 169.2 169.2 169.2 169.2 169.2 169.2 192.3 192.3 192.3 4022 192.3 1092 192.3 1992 192.3 102 192.3 192.3 192.3 192.3 192.3 192.3 192.3 203.8 200 203.8 200.0 203.8 1 1 1 1 1 1 1 2 2 2 2 2 2 2 2 2 2 2 2 2 1 1 1 1 1 237.4 274.8 312.2 12:2 349.6 42.0 387.0 0.0 *2*.* 424.4 461.8 401.6 499.2 30.0 536.6 574.0 611.4 648.8 686.3 6700 670.0 653.8 SES aze 637.6 623 621.3 GO 605.1 FO 588.9 572.6 556.4 540.2 523.9 507.7 491.5 475.3 475.3 4754 475.4 AZE 475.5 475.5 AZER 475.6 475.7 4757 475.7 1767 4758 475.8 4720 475.9 475.9 470 * 476.0 110 476.1 476.1 100 482.7 100 489.2 495.7 502.2 508.8 515.3 1.5 1.8 2.0 2.3 2.5 2.8 3.0 3.2 3.4 0.4 3.6 3.7 3.9 4.1 40 4.0 3.9 20 3.8 3.7 2 3.6 3.5 3.4 3.2 3.1 2.9 2.8 2.6 2.5 2.5 2.5 2.5 26 2.5 2.5 25 2.5 2.5 2.4 2.4 2.4 2.4 2.4 2.3 2.4 2.4 2.4 2.5 2.5 2.5 0.0 0.0 0.0 0.0 0.0 0.0 DO 0.0 0.0 0.0 VU 0.0 D. 0.0 0.0 VU 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 00 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 507.7 0.0 0.0 0.0 0.0 0.0 0.0 U. 0.0 V.U 0.0 V. 0.0 0.0 0.0 V. 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 00 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 9 9 9 9 9 9 491.5 475.3 475.3 475.4 475.5 Az 475.5 475.6 Az 475.7 ze 475.7 475.8 475.9 475.9 476.0 *0 476.1 476.1 482.7 1001 489.2 495.7 502.2 508.8 9 9 9 11 11 11 11 11 203.8 203.8 11 203.8 192.5 9 9 O O O O C 9 9 Oo 9 9 32 3rd 33 34 35 36 37 38 39 40 41 42 43 44 45 4th 46 47 48 49 50 51 52 2 2 2 2 2 2 2 2 1 1 1 1 3.3 475.6 475.7 475.7 475.8 475.9 475.9 476.0 476.1 476.1 482.7 489.2 495.7 502.2 508.8 515.3 521.8 528.4 534.9 541.4 547.9 554.5 192.4 192.4 192.4 192.4 192.4 192.4 192.4 192.4 192.4 210.4 210.4 210.4 210.4 210.4 210.4 210.4 210.4 210.4 210.4 210.4 210.4 210.4 9 9 11 11 11 11 11 11 11 11 11 11 11 11 11 2.3 2.5 2.5 2.4 2.4 2.4 2.4 2.4 2.3 2.4 2.4 2.4 2.5 2.5 2.5 2.6 2.7 2.8 475.7 475.7 475.8 475.9 475.9 476.0 476.1 476.1 482.7 489.2 495.7 502.2 508.8 515.3 521.8 528.4 534.9 541.4 547.9 554.5 561.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 1 192.3 192.3 192.3 192.3 192.3 192.3 192.3 192.3 203.8 203.8 203.8 203.8 203.8 203.8 203.8 203.8 203.8 203.8 203.8 203.8 203.8 169.2 169.2 169.2 169.2 169.2 169.2 169.2 169.2 169.2 169.2 169.2 169.2 169.2 1 1 1 1 1 1 1 1 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 2.9 3.0 3.2 3.3 5th Simulation Worksheet Beginning Inventory Qtr Wk Lines Scheduled Scheduled Production Expected Ending Forecast Demand Expected Wooks Actual Production of-Supply Rate (cases/hour) Actual Demand (1,000 Cases) Actual Production Actual Ending Inventory Inventory 10 10 10 10 10 10 10 10 10 10 TU 10 10 10 8 8 Overtime Scheduled (hours) 1 1 1 1 1 1 1 1 1 1 1 200.0 237.4 274.8 312.2 349.6 101 387.0 424.4 461.8 499.2 499.2 536.6 574.0 611.4 8 8 8 8 8 1 2 3 4 5 6 1st 7 8 9 10 TU 11 12 12 13 14 14 15 45 16 40 47 17 40 18 40 19 2nd 20 21 22 23 24 25 26 27 29 28 20 29 20 30 31 32 3rd 33 2 34 35 36 37 38 39 40 41 42 43 44 45 648.8 6488 ARE 686.3 670.0 652 653.8 6278 637.6 6242 621.3 605.1 00 588.9 572.6 556.4 540.2 523.9 8 8 8 8 8 8 9 9 9 9 191.3 191.3 191.3 191.3 191.3 191.3 191.3 191.3 191.3 191.3 191.3 191.3 191.3 1520 153.0 1520 153.0 1990 153.0 4 153.0 520 153.0 462 153.0 153.0 ro 153.0 153.0 153.0 153.0 153.0 153.0 192.4 1920 1920 192.4 402 192.4 402 192.4 100 192.4 4022 192.4 402 192.4 100 192.4 2007 192.4 100 192.4 192.4 1967 192.4 2017 192.4 210.4 10.1 210.4 10 210.4 210.4 210.4 210.4 153.8 153.8 153.8 153.8 153.8 153.8 1.o 153.8 133.0 153.8 153.8 153.8 153.8 153.8 153.8 169.2 180 169.2 460 169.2 460 169.2 100 169.2 4602 169.2 160 169.2 100 169.2 169.2 169.2 169.2 169.2 169.2 192.3 192.3 192.3 4022 192.3 1092 192.3 1992 192.3 102 192.3 192.3 192.3 192.3 192.3 192.3 192.3 203.8 200 203.8 200.0 203.8 1 1 1 1 1 1 1 2 2 2 2 2 2 2 2 2 2 2 2 2 1 1 1 1 1 237.4 274.8 312.2 12:2 349.6 42.0 387.0 0.0 *2*.* 424.4 461.8 401.6 499.2 30.0 536.6 574.0 611.4 648.8 686.3 6700 670.0 653.8 SES aze 637.6 623 621.3 GO 605.1 FO 588.9 572.6 556.4 540.2 523.9 507.7 491.5 475.3 475.3 4754 475.4 AZE 475.5 475.5 AZER 475.6 475.7 4757 475.7 1767 4758 475.8 4720 475.9 475.9 470 * 476.0 110 476.1 476.1 100 482.7 100 489.2 495.7 502.2 508.8 515.3 1.5 1.8 2.0 2.3 2.5 2.8 3.0 3.2 3.4 0.4 3.6 3.7 3.9 4.1 40 4.0 3.9 20 3.8 3.7 2 3.6 3.5 3.4 3.2 3.1 2.9 2.8 2.6 2.5 2.5 2.5 2.5 26 2.5 2.5 25 2.5 2.5 2.4 2.4 2.4 2.4 2.4 2.3 2.4 2.4 2.4 2.5 2.5 2.5 0.0 0.0 0.0 0.0 0.0 0.0 DO 0.0 0.0 0.0 VU 0.0 D. 0.0 0.0 VU 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 00 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 507.7 0.0 0.0 0.0 0.0 0.0 0.0 U. 0.0 V.U 0.0 V. 0.0 0.0 0.0 V. 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 00 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 9 9 9 9 9 9 491.5 475.3 475.3 475.4 475.5 Az 475.5 475.6 Az 475.7 ze 475.7 475.8 475.9 475.9 476.0 *0 476.1 476.1 482.7 1001 489.2 495.7 502.2 508.8 9 9 9 11 11 11 11 11 203.8 203.8 11 203.8 192.5 9 9 O O O O C 9 9 Oo 9 9 32 3rd 33 34 35 36 37 38 39 40 41 42 43 44 45 4th 46 47 48 49 50 51 52 2 2 2 2 2 2 2 2 1 1 1 1 3.3 475.6 475.7 475.7 475.8 475.9 475.9 476.0 476.1 476.1 482.7 489.2 495.7 502.2 508.8 515.3 521.8 528.4 534.9 541.4 547.9 554.5 192.4 192.4 192.4 192.4 192.4 192.4 192.4 192.4 192.4 210.4 210.4 210.4 210.4 210.4 210.4 210.4 210.4 210.4 210.4 210.4 210.4 210.4 9 9 11 11 11 11 11 11 11 11 11 11 11 11 11 2.3 2.5 2.5 2.4 2.4 2.4 2.4 2.4 2.3 2.4 2.4 2.4 2.5 2.5 2.5 2.6 2.7 2.8 475.7 475.7 475.8 475.9 475.9 476.0 476.1 476.1 482.7 489.2 495.7 502.2 508.8 515.3 521.8 528.4 534.9 541.4 547.9 554.5 561.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 1 192.3 192.3 192.3 192.3 192.3 192.3 192.3 192.3 203.8 203.8 203.8 203.8 203.8 203.8 203.8 203.8 203.8 203.8 203.8 203.8 203.8 169.2 169.2 169.2 169.2 169.2 169.2 169.2 169.2 169.2 169.2 169.2 169.2 169.2 1 1 1 1 1 1 1 1 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 2.9 3.0 3.2 3.3 5th