Please help me with this aggregate planning question, I've included the excel and questions related.

1 Management Instructions 41 Ending inventory target for Period 5 - Backorder maximum if possible (after the first period) Regular shift production per employee per period The company's production strategy keeps the regular shift fully utilized 25 Maximum overtime production per period if needed 25 Maximum subcontractor production per period if needed 32 Initial inventory - Use Overtime before Subcontractors 11 Aggregate Plan 3 5 Totals 12 240 245 13 Demand 235 190 290 1,200 15 Employees 220 220 220 220 1,100 17 Production 18 Regular 19 Overtime 20 Subcontractor 21 Production - Forecast 22 24 23 Inventory Beginning 25 Ending 26 Average 27 Backlog 29 Costs 30 Regular $ 31 Overtime $ Subcontractor $ Hire / Layoff $ 34 Inventory $ Backlog $ 445.00 495.00 580.00 995.00 80.00 450.00 33 37 Total Costs What is the Production - Forecast quantity for Period 3? What is the Overtime Production Quantity for Period 3? What is the Subcontractor Production Quantity for Period 5? What is the Ending Inventory quantity for Period 4? What is the Ending Inventory quantity for Period 5? What is the Backlog in Period 2? What is the Average Inventory for Period 2? What is the Cost of Overtime Production in Period 4? (include two decimals) What is the cost of Hire / Layoff in Period 3? (include two decimals) What is the Total Cost for all 5 periods? (include two decimals)