Management Instructions Ending inventory target for Period 5 Backorder maximum If possible (after the first porod) 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 8,850 Initial Inventory 3 Aggregate Plan Demand Employees 1 14,500 2 15,200 4 15,900 5 15,555 Totals 76,055 14,900 7 6 6 Production Regular Overtime Production - Forecast Inventory Beginning Ending Averago Backlog Costs Regular Overtime Hire / Layoff 1 Inventory 2 Backlog 3.00 4.50 $ 900.00 1.00 1.00 nu 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? A/ What is the Beginning Inventory quantity for Period 2? A/ What is the Ending Inventory value for Period 5? A/ 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 inventary Cost In Period 5? (include two decimals) 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? A/ What is the Beginning Inventory quantity for Period 2? A What is the Ending Inventory value for Period 57 1. What is the Average Inventory for Period 3? What is the cost of Hire Layoff in Period 47 [include two decimals), What is the cost of Regular Production in Perlod 52 [include two decimals what is the inventory costin Period 57 (include two decimas)