Please complete parts C & D.

Trexoid Inc. makes a popular video game console. Demand varies each month, with highest demand coming in the last quarter of the year. Regular production costs are $370 per unit and inventory carrying cost is $5 per unit per quarter. Overtime production cost is $400 per unit. Assume that the 25 current Trexoid employees can produce a total of 50,000 units per quarter in regular production and can work enough overtime hours to produce the amount required if a chase plan is employed. On the other hand, hiring cost is $6,500 per employee and firing cost is $14.000 per employee. Trexoid currently has zero inventory on hand, and they would like to have zero inventories at the end of the year. Assume hiring and layoff/firing, if necessary, occur at the beginning of the quarter. Forecast demand is as follows: Quarter 1 Quarter 2 Quarter 3 Quarter 4 40,000 units 20,000 units 74,000 units 130,000 units PrictureClick here for the Excel Data File 0. Given the above demand estimate, develop a production plan based on level production (Leave no cells blank - be certain to enter "O" wherever required.) Answer is complete and correct. Hire Fire Level Production Plan Quarter Demand 1 40,000 2 20,000 3 74.000 4 130,000 Total 264,000 0 0 Regular Production 66,000 66,000 66.000 66,000 264,000 0 Ending Inventory 26,000 72.000 64,000 0 162,000 Number of Workers 33 33 33 33 0000 OO 0 0 8 0 0 0 b. Determine the cost of the level production plan. Answer is complete and correct. Total cost 98.542.000 c. Given the planning information, develop a production plan based on chase production (Leave no cells blank - be certain to enter "0" wherever required.) Number of Workers Answer is not complete. Chase Production Plan - Overtime with Stable Workforce Quarter Demand Regular Overtime Ending Production Production Inventory 1 40,000 2 20,000 3 74,000 4 130,000 Total 264,000 0 0 0 Fire Answer is not complete. Chase Production Plan - Changing Workforce Levels Demand Regular Quarter Ending Number of Hire Production Inventory Workers 1 40,000 2 20,000 3 74,000 4 130,000 Total 264,000 0 0 0 3 0 d. Determine the cost of the chase production plan. Total cost if overtime production used Total cost if workforce size adjusted