Problem 13-10 (Algo) Jones Inc. is preparing an aggregate production plan for next year. The company expects demand to be 2,900 units in quarter 1; 3,900 units in quarter 2; 5,900 units in quarter 3; and 4,900 units in quarter 4. The company will have 200 units in inventory at the beginning of the year and desires to maintain at least that number at the end of each quarter as safety stock. Assume hiring and layoff/firing, if necessary, occur at the beginning of the quarter. Other information: Regular production labor cost = $180 per unit Overtime production cost per unit = $270 Inventory carrying cost = $25/unit/quarter based on quarter-ending inventory Hiring cost = $4,500 per worker Firing/layoff cost = $8,500 per worker Beginning number of workers = 20 pictureClick here for the Excel Data File Each worker can produce 100 units per quarter. C-1. Suppose Jones' management is reluctant to constantly change the workforce by hiring and firing. The company decides to hire ten additional workers at the beginning of the year. The company will build inventory in low-demand months and use it in high-demand months. In addition, if necessary, overtime will be used to meet demand requirements if there is not sufficient inventory available. (Leave no cells blank - be certain to enter "0" wherever required.) Quarter Demand Regular Production Overtime/Subcontract Production Ending Inventory Workers Required Hire Fire layoff 1 2,900 2 3 This is a numeric cell, so please enter numbers only. 4 Total 17,600 0 0 0 0 C-2. What is the total cost of this plan? Total cost