Wormwood, Ltd.. produces a variety of furniture products. The planning committee wants to prepare an aggregate plan for the next six months using the following information. Problem MONTH 1 2 3 4 5 6 Demand 160 150 160 180 170 140 Capacity Regular 150 150 150 150 160 Overtime 10 10 0 10 10 160 10 Cost Per Unit Regular time $50 Overtime 75 Subcontract 80 4 Inventory holding, per month Click here for the Excel Data File Subcontracting can handle a maximum of 10 units per month. Beginning inventory is zero. Develop a plan that minimizes total cost. No back orders are allowed. Regular capacity Regular production. (Negative amounts should be indicated by a minus sign. Leave no cells blank - be certain to enter "0" wherever required.) Period Forecast Output Regular Overtime Subcontract Output - Forecast Inventory Beginning Ending Average Backlog Costs: Regular Overtime Subcontract Inventory Backlog Total 1 2 3. 4 5 6 Total 160 150 160 180 170 140 960