00 Problem 13-10 (Algo) 10 DO look Jones inc. is preparing an aggregate production plan for next year. The company expects demand to be 2700 units in quarter 1, 3,700 units in quarter 2,5700 units in quarter 3, and 4 700 units in quarter 4. The company will have 300 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 layofffiring, in necessary, occur at the beginning of the quarter Other information Regular production labor cost $160 per unit Overtime production cost per unit - $240 Inventory carrying cost = $25/unit/quarter based on quartet-ending Inventory Hiring cost-$7000 per worker Firing/layoff cost $7,500 per worker Beginning number of workers - 20 Dictureclick here for the Excel Dato le Each worker can produce 100 units per quarters :1. Given the planning Information develop a level production plan and a chose production plan (Leave no cells blank - be certain to enter "o" wherever required.) P Dance Overtime subcontract Production Ending Workers Required Production Levni production plan Quarter Demand + 2.700 2 3.700 3 5.700 4 4700 Total 18.00 00 Problem 13-10 (Algo) 10 DO look Jones inc. is preparing an aggregate production plan for next year. The company expects demand to be 2700 units in quarter 1, 3,700 units in quarter 2,5700 units in quarter 3, and 4 700 units in quarter 4. The company will have 300 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 layofffiring, in necessary, occur at the beginning of the quarter Other information Regular production labor cost $160 per unit Overtime production cost per unit - $240 Inventory carrying cost = $25/unit/quarter based on quartet-ending Inventory Hiring cost-$7000 per worker Firing/layoff cost $7,500 per worker Beginning number of workers - 20 Dictureclick here for the Excel Dato le Each worker can produce 100 units per quarters :1. Given the planning Information develop a level production plan and a chose production plan (Leave no cells blank - be certain to enter "o" wherever required.) P Dance Overtime subcontract Production Ending Workers Required Production Levni production plan Quarter Demand + 2.700 2 3.700 3 5.700 4 4700 Total 18.00 Check my 8 a-2. What is the total cost of a level plan? tot 10 points Sook b-1. Given the planning Information develop a chase production plan utilizing hiring and firing. (Leave no cells blank.be certain to enter"0" wherever required.) Print Overtimersubcontract Production Ending Inventory Workers Required Fue layoll oference Chase Plan Vatlable Workforce Quarter Demand Regular Production 1 2.700 2 3.700 3 ,700 4 4,700 Total 16.800 b-2. What is the total cost of a chase plan utilizing hiring and firing? To con Me BE OC 50 points c-1. Suppose Jones' management is reluctant to constantly change the workforce by hiring and firing. The company decides to hire five additional workers at the beginning of the year. The company wil buildinventory 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 Wothers Required Hire Fire tayott Boo 1 2 3 2.700 3.700 5,700 4,700 16,800 Print 4 Total Beerence c-2. What is the total cost of this plan? Total cost