This is the data in problem 16:

17. Use the data in problem 16 to calculate production amounts and costs for a level rate of output with no ending inventory. In this case, allow items to be backordered. When this occurs, a $5 penalty is incurred. Mike Blanford, master scheduler at General Avionics, has the following demand forecast for one line in his 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. Demand not satisfied in any quarter is lost and incurs a stockout penalty. If Mike produces exactly enough to meet demand each quarter, with no inventories at the end of quarters and no overtime, how much will he produce each quarter, and what is the overall cost? (Use a spreadsheet model for the calculations.)