4 Problem 13-4 (Algo) The current aggregate demand requirements for a firm are shown below for the next six months. 208 Doints Month Demand May June July Aug Sept Oct 370 350 350 350 380 400 Skipped PpictureClick here for the Excel Data File eBook Hint Print The firm always plans to meet all demand. The firm currently has 370 workers capable of producing 370 units in a month (1 unit/worker). The workforce can be increased (at a cost of $650 per worker) or decreased at a cost of $1,300 per worker). Inventory holding cost is $225 per unit per month. The firm currently has 30 units of inventory on hand, and it would like to have 30 units available at the end of each month Regular production cost is $4,250 per unit. Assume hiring and layoff/firing, if necessary, occur at the beginning of the month References a. What should the aggregate plan be if the inventory holding cost is to be minimized? (Leave no cells blank - be certain to enter "O" wherever required.) a. What should the aggregate plan be if the inventory holding cost is to be minimized? (Leave no cells blank - be certa wherever required.) Month Demand Ending Inventory Regular Production 370 Number of Workers Hire Fire May 370 June 350 350 350 350 350 350 July August September October 380 380 400 400 2.200 2.200 Total 0 0 0 b. What is the cost of this plan? Total cost