Problem 13-7 (Algo) 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 $330 per unit and inventory carrying cost is $6 per unit per quarter Overtime production cost is $360 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 $10.000 per employee and firing cost is $12,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 20,000 units 20.800 units 66,000 units 132.990 units ces Pricture Click here for the Excel Data File 2. Given the above demand estimate develop a production plan based on level production (Leave no cells blank - be certain to enter o" wherever required.) Regular Production Ending Inventory Number of Workers Hire Fire Level Production Plan Quarter Demand 1 20,000 2 20.000 3 86,000 4 182,000 Total 288 000 0 b. Determine the cost of the level production plan, Total c. Given the planning information, develop a production plan based on chase production. (Leave no cells blank - be certain to enter "O" wherever required.) Ending Inventory Number of Workers Chase Production Plan - Overtime with Stable Workforce Quarter Demand Regular Overtime Production Production 1 20,000 2 20,000 3 66,000 4 182.000 Total 288.000 Chase Production Plan - Changing Workforce Levels Quarter Demand Regular Ending Production Inventory 1 20,000 Number of Workers Hire Fire 1 10 points Number of Work Hire Fire eBook Chase Production Plan - Changing Workforce Levels Quarter Demand Regular Ending Production Inventory 1 20,000 2 20,000 3 66,000 4 182,000 Total 288,000 0 Print 0 References d. Determine the cost of the chase production plan, Total cost if overtime production used Total cost if workforce size adjusted