please show on excel

3. Eastern Electronic makes washers and dryers. The production requirements for aggregate units are given in the table below. An employee can produce 10 units per month on regular time and can produce an additional two units per month on overtime. Demand not satisfied in any quarter is lost and incurs a stock out penalty. 5 Month Demand 1 550 2 3 4 540 600 500 470 At the beginning of quarter 1, there are 70 units in inventory. The firm has prepared the following data: Hiring cost per employee = $500 Firing cost per employee = $1,000 Beginning workforce = 50 employees Inventory carrying cost = $30 per unit per month of ending inventory Stock out cost = $200 per unit per period Regular payroll = $2,500 per employee per month Overtime cost = $300 per unit per employee Undertime cost = $10 per unit a) If Eastern Electronic produces exactly enough to meet demand each month, with no inventories at the end of months and no overtime, how much will the company produce each month, and what is the overall cost? b) Calculate production amounts and costs for a level rate of output with no overtime. Back orders are allowed. (Hiring employees are allowed at the beginning of month 1)