Please include formulas to type in excel. thanks!

Problem 5 (Aggregate Planning1) Demand data for 10 months for a luxury boat maker have been provided. Unit costs for producing the product in regular time, overtime, and via subcontracting are given. Inventory holding cost and backordering cost per period have been provided. The costs of hiring and firing each worker are given. The firm has a productivity of 0.5 units per worker per period. The number of workers employed in the last period of the previous aggregate plan was 45. The beginning inventory in period 1 is 10 units. Make an aggregate plan so that the regular time production doesn't exceed 20 units in any period (capacity constraint) and the total number of units made in all ten months together doesn't exceed 20 units. Find the total cost of your aggregate plan. Try to be cost conscious (i.e. don't waste money if cheaper alternatives exist). Refresh All Stocks Get External Data Geography Sort & Filter Data Tools Outline What if Analysis A23 B D N Problem S. 3 5 7 8 9 1 40 2 20 4 40 6 10 10 20 Total Cost 30 30 30 20 40 Unit Cost $30 $45 $85 11 10 4 Time s Demand - P(Reg) & P(OT) 9 P(Sub) Inv(Beg) Inv(End) Inv(Avg) #W #Hired #Fired Backorders 12 13 $5 15 16 17 $300 $500 $10 TOTALE 19 21 Productivity 22 #Wold 0.5 units/worker/period 45 20 for any period (capacity constraint) 20 Total for the 10 periods 23 P(Reg) s P(OT) s 24 25 26 27