Chech Problem 11-5 (Static) 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 130 engines per month Regular output has a cost of $60 per engine. The beginning inventory is zero engines. Overtime has a cost of $90 per engine 4 Forecast Month 5 125 2 135 120 8 140 12e 125 7 140 115 Total 1,040 Click here for the Excel Data Bile o. 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.) Period Total 5 6 7 8 120 135 140 120 125 125 140 135 1040 Forecast Output Regular Overtime Subcontract 120 135 140 120 125 125 140 135 1,040 Forecast Output Regular Overtime Subcontract Output - Forecast Inventory Beginning Ending Average Backdog Costs Output Regular Overtime Subcontract Inventory Backorder Total b. Compare the costs to a level plan that uses inventory to absorb fluctuations Inventory carrying cost is $2 per engine per month Backlog cost is $90 per engine per month. There should not be a backlog in the last month. 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.) Period 8 Total 120 135 140 120 125 125 140 135 1040 Forecast Output) Regular Overtime Subcontract Output - Forecast Inventory Beginning Ending Average Baddog Costs Output Regular Overtime Subcontract Output - Forecast Inventory Beginning Ending Average Backdog Costs Output Regular Overtime Subcontract Inventory Backorder Total