16. The plant scheduler at General Avionics has been given the following sales plan for one production line in the factory:

At the beginning of quarter 1, there are 1,000 units in inventory. The firm has prepared the following data:
Hiring cost per employee = $200 Firing cost per employee = $400 Beginning workforce = 60 employees Inventory carrying cost = $2 per unit per quarter of ending inventory Stockout cost = $5 per unit Regular payroll = $1,200 per employee per quarter Overtime cost = $2 per unit Each employee can produce 100 units per quarter. If the plant produces exactly enough to meet demand each quarter, with no inventory at the end of each quarter and no overtime, how much will the plant produce each quarter, and what is the overall cost? (Use a spreadsheet model for the calculations.)

Transcribed Image Text:

Quarter Sales Plan 5,000 10,000 8,000 4 2,000 2 123