A firm must plan production for the next six months. Each unit costs $420 to produce and it has an inventory holding cost of $14 per unit per month based on ending inventory levels. The cost to hire a worker is $270, and the cost to fire a worker is $540 per worker. Each worker produces 10 units per month. There are 25 persons on the payroll at the beginning of the first month. The company currently has 150 units of inventory in stock, and it wants to keep at least this many units as safety stock at the end of every month. Assume hiring and layoff/firing, if necessary, occur at the beginning of the month. 1 Month Demand 360 2 360 3 360 4 360 5 410 6 490 PpictureClick here for the Excel Data File a. From the information given above, what level production rate will meet demand for the next six months? Using that rate, complete the level plan below. (Leave no cells blank - be certain to enter "0" wherever required.) Level Plan Ending Month Demand Regular Production Number of Workers Hire Fire Inventory 1 2 360 360 360 360 3 4 5 6 410 490 2,340 Total 0 0 b-1. At that production rate, what is the maximum end-of-period inventory experienced at some time during the six months? Maximum end-of-period inventory units b-2. What would be the cost of a level production plan? Total cost c-1. From the information given above, Develop a chase (Hire and Fire only) Production Plan? (Leave no cells blank - be certain to enter "0" wherever required.) Month Demand Regular Production Ending Inventory Number of Workers Hire Fire 1 2 3 360 360 360 360 4 5 410 6 490 2,340 Total 0 c-1. From the information given above, Develop a chase (Hire and Fire only) Production Plan? (Leave no cells blank - be certain to enter"0" wherever required.) Month Demand Regular Production Ending Inventory Number of Workers Hire Fire 1 2 3 4 5 360 360 360 360 410 490 2,340 6 0 0 Total c-2. What is the total cost of a chase (hire and fire only) production plan? Total cost