Download HW 7 (Excel download) and perform the necessary calculations for a Match (Chase) Production Strategy. Then enter selected values below. What is the Backlog quantity for Period 3? What is the Backlog for Period 5? What is the Output - Forecast Quantity for Period 2? What is the Beginning Inventory quantity for Period 2? What is the Beginning Inventory quantity for Period 5? What is the cost of Overtime Production in Period 1? What is the Cost of Inventory for Period 3? What is the Total Cost of Period 4? What is the cost of Backlog for Period 5? What is the Average Inventory in Period 4? Management Instructions - 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 40 Maximum overtime production per period if needed Use Overtime before Subcontractors 10 Maximum subcontractor production per period if needed 32 Initial inventory Aggregate Plan 1 2 3 4 5 Totals Forecast 240 245 235 190 290 Employees Output Regular 220 220 220 220 220 Overtime Subcontractor Output - Forecast Inventory Beginning Ending Average Backlog Costs Regular $298.00 Overtime $347.00 Subcontractor $410.00 Hire / Layoff $885.00 Inventory $65.00 Backlog $75.00 Total Costs