F12 : xfx A D E H K 1 Problem Data for Problems 1-7 2 Plan B: Chase Aggregate Plan Using Hiring and Firing (no overtime) 510 00 515.00 584.09 $10.00 520.00 5000.00 $450.00 Beginning Number of Employees Units per Worker per Period IT Period 1 4600 Perlod 2 Period 3 Period 4 Period 5 Parlod 4300 7840 5700 6560 4600 Detailed Plan Computatione Demand units) (nel of beg, Inventory) Production per period units Employees needed in period Number to hire Number to fire 280 400 4 CostData 5 Regular time labor cost per hour Overtime labor cost per hour 7 Subcontracting cost per unit (abor only) Holding cost per un period Back-onder cost per unit period 10 Hiring cost per employee 11 Firing cost per employee 12 Capacity Data 13 Beginning workforce (employees) 14 Beginning inventory unit) 15 Labor standard per unit hours) 10 Regular time valable per period our) 17 Overtime avalable per period thoun) 13 Subcontracting maximum per period units) 19 Subcontracting minimum per period funts) 20 Demand Data (units) 21 Period 1 22 Period 2 23 Parod 3 24 Period 4 25 Panod 5 20 Period 27 Total Number of Periods 0 0 0 IT 180 32 1000 300 Cost Calculations for Plan C Regular time labor cost Hiring cost Feng cost Total Com $0 5000 4300 7840 5700 6560 4600 6