1 Problem 11-5 (Algo) 20 points Manager T. C. Downs of Plum Engines, a producer of lawn mowers and leaf blowers, must develop an aggregate plan given the forecast for engine demand shown in the table. The department has a regular output capacity of 136 engines per month. Regular output has a cost of $65 per engine. The beginning inventory is zero engines. Overtime has a cost of $115 per engine. 1 90 2 2 145 3 100 Month 4 5 5 105 115 6 128 7 7 134 8 95 Total 912 Forecast a. Develop a chase plan that matches the forecast and compute the total cost of your plan. Regular production can be less than regular capacity. (Negative amounts should be indicated by a minus sign. Leave no cells blank - be certain to enter "O" wherever required.) Answer is complete and correct. Period 1 2 3 4 5 6 7 8 Total 90 145 100 105 115 128 134 95 912 90 136 100 105 115 128 134 95 903 9 9 0 9 0 0 0 0 0 0 0 Forecast Output Regular Overtime Output - Forecast Costs Output Regular Overtime 0 0 0 0 0 0 0 0 0 $ 5,850 8,840 0 6,500 6,825 7,475 8,320 8.710 6,175 0 lol 1,035 0 0 0 0 0 0 0 Solo $ 58,695 1,035 $ 59,730 OOO Total $ 5,850 9,875 6,500 6,825 7,475 8,320 8,710 6,175 1 20 points b. Compare the costs to a level plan that uses inventory to absorb fluctuations. Inventory carrying cost is $4 per engine per month. Backlog cost is $135 per engine per month. There should not be a backlog in the last month. Set regular production equal to the monthly average of total forecasted demand. Assume that using overtime is not an option. (Negative amounts should be indicated by a minus sign. Leave no cells blank - be certain to enter "0" wherever required. Round average inventory row, Inventory cost row, and Total row values to 1 decimal.) Answer is not complete. Period 1 2 4 5 6 8 Total 90 145 100 105 115 128 134 95 912 Forecast Output 114 114 114 114 912 114 -31 | 114 -1 114 -14 114 19 24 14 9 -20 0 24 0 7 16 15 0 0 Regular Output - Forecast Inventory Beginning Ending Average Backlog Costs Output 0 0 16 24 12.0 0 7 3.5 0 0 15 15.5 0 0 1 1 0 0 0.5 0 X 12.00 0X 11.5 olololol 8|e|e|g 1 8.0 0 0 9|e|e| 0 0.00 0 0 $ 7,410 7,410 7,410 7,410 7,410 7,410 | | 7.410 7,410 $ 59,280 Regular Inventory Backorder 28.0 % 4.0 X 0.0 X 0.0 96.0 % 0 0 0.0 % 0 X 64.0 X 0 0 60.0 % 0 0 Solo 0 0 0 X 0 Total