Problem 13-4 (Algo) The current aggregate demand requirements for a firm are shown below for the next six months Month Demand May June July Aug Sep Oct 330 310 310 310 340 360 PrictureClick here for the Excel Data File The firm always plans to meet all demand. The firm currently has 330 workers capable of producing 330 units in a month (1 unit/worker). The workforce can be increased at a cost of $1,000 per worker) or decreased fat a cost of $2,000 per worker). Inventory holding cost is $200 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,050 per unit. Assume hiring and layoff/firing. If necessary, occur at the beginning of the month 9. What should the aggregate plan be if the inventory holding cost is to be minimized? (Leave no cells blank - be certain to enter "0" wherever required.) Month Demand Ending Inventory Number of Workers Hire Fire 330 310 310 May June July August September October Total Regular Production 330 310 310 310 340 360 1.960 310 340 360 1,960 b. What is the cost of this plan? Total cost Problem 13-4 (Algo) The current aggregate demand requirements for a firm are shown below for the next six months Month Demand May June July Aug Sep Oct 330 310 310 310 340 360 PrictureClick here for the Excel Data File The firm always plans to meet all demand. The firm currently has 330 workers capable of producing 330 units in a month (1 unit/worker). The workforce can be increased at a cost of $1,000 per worker) or decreased fat a cost of $2,000 per worker). Inventory holding cost is $200 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,050 per unit. Assume hiring and layoff/firing. If necessary, occur at the beginning of the month 9. What should the aggregate plan be if the inventory holding cost is to be minimized? (Leave no cells blank - be certain to enter "0" wherever required.) Month Demand Ending Inventory Number of Workers Hire Fire 330 310 310 May June July August September October Total Regular Production 330 310 310 310 340 360 1.960 310 340 360 1,960 b. What is the cost of this plan? Total cost