What is the Ending Inventory quantity for Period 4? What is the Ending Inventory quantity for Period 5? A/ What is the Backlog in Period 2? A/ 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) AutoSave OFT Home Insert Page Layout Formulas Data Review View Arial 14 A- A+ % E Paste B Number I U A- B3 fx o D Management Instructions Lindin vettory target for vid Inackorderimum if posible (ther the first period Regular shift productor employee period The competitilized 25 Maximum over production per period if needed 25 Maximum subtractor productie per period needed 32 Tita inventory Use Overtime before Subcontractors - Aggregate Plan 4 Total Demand 240 2145 235 190 290 13 Employees 13 Production 220 220 220 220 220 1.100 Overtime Subcontractor 1 Producerea 19 Inventory Ending Aver C Recular 45.00 495.00 Subcontractor $50.00 HureLayoff $ 995.00 5 0 00 Beck $ 450.00 Teal Costs 31 14 HW 6 + Ready B3 vf B D 2 3 Management Instructions 41 Ending inventory target for Period 5 Ubackorder 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 5 Use Overtime before Subcontractors 6 10 11 Aggregate Plan 5 Totals 1,200 245 240 235 190 290 12 13 Demand 14 15 Employees 16 17 Production Regular 19 Overtime 20 Subcontractor 21 Production - Forecast 220 220 220 220 220 1,100 23 Inventory 24 Beginning Ending 26 Average 27 Backlog 28 29 Costs Regular 31 Overtime Subcontractor Hire / Layoff Inventory Backlog $ S $ S s $ 445.00 495.00 580.00 995.00 80.00 450.00 37 Total Costs 35 39 What is the Ending Inventory quantity for Period 4? What is the Ending Inventory quantity for Period 5? A/ What is the Backlog in Period 2? A/ 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) AutoSave OFT Home Insert Page Layout Formulas Data Review View Arial 14 A- A+ % E Paste B Number I U A- B3 fx o D Management Instructions Lindin vettory target for vid Inackorderimum if posible (ther the first period Regular shift productor employee period The competitilized 25 Maximum over production per period if needed 25 Maximum subtractor productie per period needed 32 Tita inventory Use Overtime before Subcontractors - Aggregate Plan 4 Total Demand 240 2145 235 190 290 13 Employees 13 Production 220 220 220 220 220 1.100 Overtime Subcontractor 1 Producerea 19 Inventory Ending Aver C Recular 45.00 495.00 Subcontractor $50.00 HureLayoff $ 995.00 5 0 00 Beck $ 450.00 Teal Costs 31 14 HW 6 + Ready B3 vf B D 2 3 Management Instructions 41 Ending inventory target for Period 5 Ubackorder 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 5 Use Overtime before Subcontractors 6 10 11 Aggregate Plan 5 Totals 1,200 245 240 235 190 290 12 13 Demand 14 15 Employees 16 17 Production Regular 19 Overtime 20 Subcontractor 21 Production - Forecast 220 220 220 220 220 1,100 23 Inventory 24 Beginning Ending 26 Average 27 Backlog 28 29 Costs Regular 31 Overtime Subcontractor Hire / Layoff Inventory Backlog $ S $ S s $ 445.00 495.00 580.00 995.00 80.00 450.00 37 Total Costs 35 39
