The only thing I need help with would be the tables of question a-1. and b-1. with the 3 spots (total) that need filled. Everything that I filled is correct. For a-1. I need Quarter 1 for Workers Required. b-1. I need Quarter 3 and 4 Workers Required.

Jones Inc. is preparing an aggregate production plan for next year. The company expects demand to be 2,000 units in quarter 1; 3,000 units in quarter 2; 5,000 units in quarter 3; and 4,000 units in quarter 4. The company will have 100 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 = $200 per unit Overtime production cost per unit = $300 Inventory carrying cost = $15/unit/quarter based on quarter-ending inventory Hiring cost = $7,000 per worker Firing/layoff cost = $7,500 per worker Beginning number of workers = 20 Click here for the Excel Data File Each worker can produce 100 units per quarter. a-1. Given the planning information, develop a level production plan and a chase production plan. (Leave no cells blank - be certain to enter "O" wherever required.) Level production plan Quarter Demand Workers Required Hire Fire layoff Overtime/Subcontract Production 0 1 Regular Production 3,500 3,500 3,500 15 0 2 0 Ending Inventory 1,600 2,100 600 100 4,400 35 0 2,000 3,000 5,000 4,000 14,000 0 3 0 35 0 4 3,500 01 35 0 15 0 0 0 Total 14,000 0 a-2. What is the total cost of a level plan? Total cost $ 2,971,000 b-1. Given the planning information, develop a chase production plan utilizing hiring and firing. (Leave no cells blank - be certain to enter "O" wherever required.) Overtime/Subcontract Production Hire Fire layoff Ending Inventory 100 Workers Required 20 0 0 0 Chase Plan - Variable Workforce Regular Quarter Demand Production 1 2,000 2,000 2 3,000 3,000 3 5,000 5,000 4 4,000 4,000 Total 14,000 14,000 0 100 30 10 0 0 100 20 0 0 100 0 10 0 400 30 10 b-2. What is the total cost of a chase plan utilizing hiring and firing? Total cost $ 3,091,000 C-1. Suppose Jones' management is reluctant to constantly change the workforce by hiring and firing. The company decides to hire six 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 "O" wherever required.) Quarter Demand Overtime/Subcontract Production Hire Fire layoff Ending Inventory 700 Workers Required 26 1 2,000 0 6 0 2 0 Regular Production 2,600 2,600 2,600 2,600 10,400 300 26 o 0 3 100 26 0 3,000 5,000 4,000 14,000 0 4 2,200 1,400 3,600 100 26 O 0 Total 1,200 6 0