Time Left:1:37:12 Brooks Bell: Attempt 1 Question 18 (20 points) Download E 2 (Excel download) and perform the necessary calculations for a Chase (Match) Production Strategy. Then enter selected values below. What is the Backlog quantity for Period 3? What is the Backlog for Period 4? What is the Production - Forecast for Period 1? What is the Ending Inventory quantity for Period 1? What is the Ending Inventory quantity for Perlod 5? What is the Average Inventory for Period 2? What is the cost of Regular Production in Period 2? (whole dollars) What is the cost of Subcontractor Production in Period 47 (include two decimals) What is the cost of Inventory in Period 37 (include two decimals) What is the Backlog Cost for Period S? (include two decimals) 11 A A Wrap Teat Copy General Nama Go BTW A Bad Check Marge & Center % 9 2 9 Conditions Format Om Update To keep up to date with security updates, fins, and improvements, choose Check for Updates DAS Oxfx 1 Management Instructions 50 Ending inventory target for Period 5 500 Backorder 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 1,800 Maximum overtime production per period if needed 700 Maximum subcontractor production per period if needed 947 Initial inventory Use Overtime before Subcontractors Aggregate Plan 13 Demand 67.400 59,000 64,050 61,700 63,300 Totals 315,450 15 Employees 61,000 61,000 61,000 61,000 61,000 305,000 17 Production 18 Regular Overtime Subcontractor 21 Production - Forecast 23 Inventory Beginning Ending Average Backlog 29 Costs Regular $ 196.00 Overtime $ 233.00 Subcontractor $ 224.00 Hire / Layoff $ 1,150.00 Inventory $ 4.00 Backlog $ 95.00 32 Total Costs Exam 1 + Time Left:1:37:12 Brooks Bell: Attempt 1 Question 18 (20 points) Download E 2 (Excel download) and perform the necessary calculations for a Chase (Match) Production Strategy. Then enter selected values below. What is the Backlog quantity for Period 3? What is the Backlog for Period 4? What is the Production - Forecast for Period 1? What is the Ending Inventory quantity for Period 1? What is the Ending Inventory quantity for Perlod 5? What is the Average Inventory for Period 2? What is the cost of Regular Production in Period 2? (whole dollars) What is the cost of Subcontractor Production in Period 47 (include two decimals) What is the cost of Inventory in Period 37 (include two decimals) What is the Backlog Cost for Period S? (include two decimals) 11 A A Wrap Teat Copy General Nama Go BTW A Bad Check Marge & Center % 9 2 9 Conditions Format Om Update To keep up to date with security updates, fins, and improvements, choose Check for Updates DAS Oxfx 1 Management Instructions 50 Ending inventory target for Period 5 500 Backorder 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 1,800 Maximum overtime production per period if needed 700 Maximum subcontractor production per period if needed 947 Initial inventory Use Overtime before Subcontractors Aggregate Plan 13 Demand 67.400 59,000 64,050 61,700 63,300 Totals 315,450 15 Employees 61,000 61,000 61,000 61,000 61,000 305,000 17 Production 18 Regular Overtime Subcontractor 21 Production - Forecast 23 Inventory Beginning Ending Average Backlog 29 Costs Regular $ 196.00 Overtime $ 233.00 Subcontractor $ 224.00 Hire / Layoff $ 1,150.00 Inventory $ 4.00 Backlog $ 95.00 32 Total Costs Exam 1 +