The spreadsheet SOP Bonus Problem.xlsx 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? 5 points will be awarded for a correct Level plan spreadsheet, and 1 point will be awarded for each correct answer to the 5 questions. Chase Demand Strategy Plan History Plan Futur October November December Javoury February March April May Junsi July Augast September October November December Jan Salo Plan in million S 13.3 15.4 125 7.1 2 94 10.7 7.9 61 134 14.1 15.3 12.1 on 1000 units) 552 616 500 276 234 328 376 316 344 452 536 564 632 454 Actual in 1,000 units) 538 631 503 Difference oth +14 15 Difference malative T 4 Operations Plan 552 616 500 276 284 in employees) 2,515 2.988 2.380 1,380 1352 328 1,426 376 428 316 344 452 536 564 1.380 1.945 1,436 Number working days 22 20 201 20 21 23 20 22 22 3,440 10 1,965 23 20 2.564 33 632 3,160 454 2420 20 22 20 201 Actual in 1,000 units) 559 645 466 Di minth 4 29 -34 diff, culve 33 Plan 200 200 200 175 175 175 30 30 30 24 26 26 Actual in 1,000 units) 199 212 175 Days of ly 63 8.4 127 12.9 12.1 Employee redactivity Hiring Co $100 per employee Layoff Co $1,000 per employee Layoff 00 27 83 2 98 175 175 175 175 175 175 175 175 125 26 26 26 26 26 26 26 26 26 90 5.1 K9 6.5 68 5.5 72 109 653 0.0 00 00 509.1 313 2003.6 0.0 714 00 396.4 ao 00 1474 00 1164 0.0 7400 avestery crying cost 20% per month (applied to the monthly ending inventory) Maninum story level Beginning or face days of supply employees Cest of Jamary H Layoth $1,000,000 February 50 527619 $32.500 March $36.853 30 $52,500 April $226,957 50 $52.500 May $32.727 50 $52.500 June July Augas September 50 $1,001,KIR 50 $357.391 $509,091 50 $1.474,783 $52,500 $52.500 $52.500 October November December 50 $52,500 50 $299,182 5116364 50 50 $1,953, $740,000 $3,867 $52.500 $52,500 $52.500 5630