S&O Plan: Match Demand Plan Plan Jun Dec Jan Feb Mar Apr May Jul Aug Sep Oct Nov Dec Jan Totals Sales Forecast revenue units 1,105 945 955 910 850 650 550 695 725 1,110 1,200 1,240 1,230 885 Backlog Operations Production units employees Work Days / month 1,105 9 19 10 10 22 20 19 22 21 22 19 22 20 17 21 Inventory Plan 435 units cost Days Supply Employees Hires Layoffs Selected Costs Hiring $ 610.00 Layoffs 310.00 Holding 3.50% Backlog $ 80.00 Totals $ Data $Reveach each $ Cost each each Empl units / day Days Supply Min Deo Ending Inventory 94.49 41.50 7.2 5.0 66.7 Download Match E 5 (Excel download) and perform the necessary calculations for a Chase (Match) Production Strategy. Then enter selected values below. What is the Backlog quantity for April? What is the Production Quantity for April? What is the Production Quantity for September? What is the Inventory quantity for April? What is the Inventory quantity for December? What is the Days Supply value for August? (Keep one decimal place) What is the cost of Inventory for May? (Round to whole dollars) What is the number of Employee Hires for July? What is the number of Employee Layoffs for September? What is the Layoff Cost for October? (Round to whole dollars) S&O Plan: Match Demand Plan Plan Jun Dec Jan Feb Mar Apr May Jul Aug Sep Oct Nov Dec Jan Totals Sales Forecast revenue units 1,105 945 955 910 850 650 550 695 725 1,110 1,200 1,240 1,230 885 Backlog Operations Production units employees Work Days / month 1,105 9 19 10 10 22 20 19 22 21 22 19 22 20 17 21 Inventory Plan 435 units cost Days Supply Employees Hires Layoffs Selected Costs Hiring $ 610.00 Layoffs 310.00 Holding 3.50% Backlog $ 80.00 Totals $ Data $Reveach each $ Cost each each Empl units / day Days Supply Min Deo Ending Inventory 94.49 41.50 7.2 5.0 66.7 Download Match E 5 (Excel download) and perform the necessary calculations for a Chase (Match) Production Strategy. Then enter selected values below. What is the Backlog quantity for April? What is the Production Quantity for April? What is the Production Quantity for September? What is the Inventory quantity for April? What is the Inventory quantity for December? What is the Days Supply value for August? (Keep one decimal place) What is the cost of Inventory for May? (Round to whole dollars) What is the number of Employee Hires for July? What is the number of Employee Layoffs for September? What is the Layoff Cost for October? (Round to whole dollars)