Chapter 11a HW & Comments AutoSaveFF AESU Home Insert Draw Page Layout Aral 14 Peste BIV A B4 A v fx 32 Formulas A A Data = Review = View ? Insert Wraa Text E Merge & Center Custom $ % EAY- O Share 4 Ideas , alla conditional Format cell Formatting as Table Sensitivity Styles Format Sort Filter X Find & Select J K L M N O P Q R 1 Management Instructions - Ending Inventory target for Period 5 12 Backorder maximum if possible (after the first period) 32 Regular shift production per employee per period The company's production strategy keeps the regular shift fully utilized 100 Maximum overtime production per period if needed 35 Maximum subcontractor production per period if needed 42 Initial inventory Use Overtime before Subcontractors 11 Aggregate Plan 2 Totals 2.820 670 550 550 550 500 13 Demand 14 15 Employees 16 16 18 17 Production 18 Regular 19 Overtime 20 Subcontractor 21 Production - Forecast 23 Inventory 24 Beginning 25 Ending 26 Average 27 Backlog 29 Costs 30 Regular $ 310.00 31 Overtime $ 460.00 Subcontractor $ 560.00 23 Hire / Layoff $ 150.00 Inventory $ 100.00 Backlog $ 18.00 36 37 Total Costs HW8 + # 3 - 0 + 100% Download HW 8 (Excel download) and perform the necessary calculations for a Match (Chase) Production Strategy. Then enter selected values below. What is the Production - Forecast quantity for Period 2? What is the Regular Production Quantity for Period 3? What is the Ending Inventory for Period 3? What is the Beginning Inventory quantity for Period 5? What is the Average Inventory quantity for Period 4? What is the Backlog in Period 1? What is the cost of Subcontractor Production in Period 2? (include two decimals) What is the cost of Hire / Layoff in Period 3? (include two decimals) What is the Cost of Inventory in Period 5? (include two decimals) What is the Total Cost for this plan? (include two decimals)