Question: pictureClick here for the Excel Data File The firm always plans to meet all demand. The firm currently has 190 workers capable of producing 190

pictureClick here for the Excel Data File The firm always plans to meet all demand. The firm currently has 190 workers capable of producing 190 units in a month (1 unit/worker). The workforce can be increased (at a cost of $850 per worker) or decreased (at a cost of $1,700 per worker). Inventory holding cost is $125 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 $3,350 per unit. Assume hiring and layoff/firing, if necessary, occur at the beginning of the month. a. 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.) b. What is the cost of this plan
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
