Trexold 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 $340 per unit and Inventory carrying cost is $2 per unit per quarter. Overtime production cost is $370 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 $5,000 per employee and firing cost is $12,500 per employee. Trexold 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 30,000 units 20,000 units 68,000 units 138,000 units DpictureClick here for the Excel Data File a. Given the above demand estimate, develop a production plan based on level production. (Leave no cells blank - be certain to enter "0" wherever required.) Level Production Plan Quarter Demand Regular Production Ending Inventory Number of Workers Hire Fire 1 2 3 30.000 20,000 68,000 138,000 256,000 4 Total b. Determine the cost of the level production plan. Total cost c. Given the planning information, develop a production plan based on chase production. (Leave no cells blank - be certain to ent "0" wherever required.) Ending Inventory Number of Workers 1 Chase Production Plan - Overtime with Stable Workforce Quarter Demand Regular Overtime Production Production 30,000 2 20,000 3 68,000 4 138.000 Total 256,000 0 0 0 Number of Workers Hire Fire 1 Chase Production Plan - Changing Workforce Levels Quarter Demand Regular Ending Production Inventory 30,000 2 20,000 3 68,000 4 138,000 Total 256,000 O 0 d. Determine the cost of the chase production plan. Total cost if overtime production used Total cost if workforce size adjusted