Please Include the Two Decimals

Download HW 4 (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 5? A/ What is the Regular Production Quantity for Period 2? A/ What is the Overtime Production Quantity for Period 5? A What is the Beginning Inventory quantity for Period 3? A What is the Ending Inventory quantity for Period 4? A/ What is the Cost of Overtime Production in Period 2? (include two decimals) A What is the Cost of Inventory for Period 3? (include two decimals) A What is the cost of Hire / Layoff in Period 4? (include two decimals) A What is the Backlog Cost in Period 3? (include two decimals) A What is the Total Cost for Period 4? (include two decimals) A C44 A B E F G I I J 6 1 Management Instructions 2 Ending inventory target for Period 5 3 144 Backorder maximum if possible after the first period) 4 2,000 Regular shift production per employee per period 5 The company's production strategy keeps the regular shift fully utilized 6 1,500 Maximum overtime production per period if needed Do not use subcontractors unless needed to 7 500 Maximum subcontractor production per period if needed stay below the backorder maximum 8 8,850 Initial inventory 9 10 11 Aggregate Plan 12 1 2 3 4 5 Totals 13 Demand 14,500 15,200 14,900 15,900 15,555 76,055 14 15 Employees 7 6 7 6 7 16 17 Production 18 Regular 19 Overtime 20 Subcontractor 21 Production - Forecast 22 23 Inventory 24 Beginning 25 Ending 26 Average 27 Backlog 28 29 Costs 30 Regular $ 2.90 31 Overtime $ 3.45 32 Subcontractor $ 4.04 33 Hire / Layoff $ 1,250.00 34 Inventory $ 0.55 35 Backlog $ 1.00 36 37 Total Costs 38 39 40 41 02