Please explain how to calculate each vale step by step. Do not give the excel sheet.

Check my work 2 Problem 11-9 (Static) 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. 3 points 1 169 2 2 150 MONTH 3 4 160 180 5 178 6 149 Demand Capacity Regular Overtime Back 150 19 150 10 150 B 150 19 160 18 160 19 Print Cost Per Unit Regular time Overtime Subcontract Inventory holding, per month $58 75 80 References 4 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 "O" wherever required.) Period 1 2 3 4 5 8 Total 160 150 160 180 170 140 960 Forecast Output Regular Overtime Subcontract 150 150 150 920 150 10 0 160 10 160 0 10 0 10 40 0 0 0 0 20 0 0 20 Check my work 2 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 "o" wherever required.) 3 points Period 1 2 3 4 4 5 6 Total eBook 160 150 160 180 170 140 960 Forecast Output Regular Overtime 150 150 150 150 160 920 160 10 Prir: 10 10 0 0 10 0 40 0 0 0 0 20 0 0 20 160 160 150 190 170 140 960 References Subcontract Output - Forecast Inventory Beginning Ending Average Backlog Costs: Regular Overtime Subcontract Inventory Backlog Total