The spreadsheet SOP Bonus Problem.xlsx Download SOP Bonus Problem.xlsxdownload shows a Chase strategy for a single product company's production plan over the next 12 months. Construct a spreadsheet that instead uses a Level production plan with the same number of employees over all 12 months and with the beginning and ending inventories both equal to 175,000 units. At the bottom of the spreadsheet, provide answers for these 5 questions:

1. What is the selling price per unit?

2. What is the cost (inventory value) per unit?

3. How many employees are needed for the 12 month Level Production Plan?

4. What is the total cost of hiring, layoffs, and inventory carrying costs for the 12 month Level Production Plan?

5. What are the savings in the total cost of hiring, layoffs, and inventory carrying costs for the 12 month Level Production Plan relative to the 12 Month Chase Production Plan?

Chase Demand Strategy Plan Chase Demand Strategy Plan