Chapter 11a HW 3 View Comments AutoSaveFF AESU Home Insert Draw Page Layout X Arial 14 Posted BIU B F19 xv fx Formulas A A A Data Review = = = E Insert EAY- O Was Text Merge & Center Custom $ % Share 4 Ideas ) to conditional Format Format Sort Filter Sensitivity X Find & Select J K L M N O P Q R 1 Management Instructions Ending Inventory target for Period 5 Backorder maximum if possible (after the first period) 2,000 Regular shift production per employee per period The company's production strategy keeps the regular shift fully utilized 2.000 Maximum overtime production per period if needed 500 Maximum subcontractor production per period if needed 8,850 Initial inventory Use Overtime before Subcontractors 11 Aggregate Plan 14,500 15.200 Totals 76,055 14.900 15,900 15,555 13 Demand 14 15 Employees 14,000 14.000 12,000 12,000 12,000 17 Production 18 Regular 19 Overtime 20 Subcontractor 21 Production - Forecast 22 23 Inventory 24 Beginning 25 Ending 26 Average 27 Backlog 29 Costs 30 Regular $ 31 Overtime $ Subcontractor $ 23 Hire / Layoff $ 34 Inventory $ 35 Backlog $ 36 37 Total Costs 3.90 4.50 5.00 900.00 1.00 1.00 HW 3 + # 3 - 0 + 100% Download HW 3 (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 1? What is the Number of Employees in Period 3? What is the Overtime Production Quantity for Period 4? What is the Production - Forecast quantity for Period 4? What is the Beginning Inventory quantity for Period 2? What is the Ending Inventory value for Period 5? What is the Average Inventory for Period 3? What is the Cost of Hire / Layoff in Period 4? (include two decimals) What is the Cost of Regular Production in Period 5? (include two decimals) What is the Inventory Cost in Period 5? (include two decimals)