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 5 6 Totals 315,450 67.400 59.000 61,700 Demand 64,050 3 300 Employees 61,000 61,000 61.000 61.000 61.000 305,000 Production Regular Overtime Subcontractor Production - Forecast Inventory Beginning Ending Average Backlog Costs Regular Overtime Subcontractor Hire/Layoff Inventory Backlog 196 233 224 1.150 95 Total Costs 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 Period 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 4? (include two decimals) What is the cost of Inventory in Period 3? (include two decimals) What is the Backlog Cost for Period 5? (include two decimals) 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 5 6 Totals 315,450 67.400 59.000 61,700 Demand 64,050 3 300 Employees 61,000 61,000 61.000 61.000 61.000 305,000 Production Regular Overtime Subcontractor Production - Forecast Inventory Beginning Ending Average Backlog Costs Regular Overtime Subcontractor Hire/Layoff Inventory Backlog 196 233 224 1.150 95 Total Costs 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 Period 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 4? (include two decimals) What is the cost of Inventory in Period 3? (include two decimals) What is the Backlog Cost for Period 5? (include two decimals)
