E47 ex fe C D H K L Level Aggregate Plan, Using Inventories and Backorders $10.00 515.00 384.00 $10.00 $20.00 5000.00 $450.00 34000 Production Rate for Level Plan 2100 400 1 Problem Data for Problems 1-7 2 3 4 CostData 5 Regular time labor cost per hour Overtime labor com per hour 7 Subcontrading coal perunt fabor only) 0 Holding cost per un period 3 Backorder cost per un period 10 Hring com per employee 11 Firing cost per employee 12 Capacity Data 13 Beginning we force employees 14 Beginning inventory into) 15 Labor andard perunt Choun) 10 Regular time available per period Prours) 17 Overtime ava per period pour) 10 Subcontracting maximum per periode 10 Subcontracting minimum per period units) 20 Demand Data funita) 21 Period 1 22 Period 2 23 Porod 3 24 Porod 4 25 Periods 26 Penod 27 Total Number of Perlede 28 29 30 31 Compute Level Production Rate Total Demand Les Beginning inventory Total Net Demand Average Demand Per Porod Compute Workforce Needed Units per Employee per Period Wonen needed Numberto Hre Numberto Fire Detailed Plan Computatione 180 22 1000 500 Period 1 4600 Period 2 Period 3 Period 4 Period Period 4300 7840 5700 6500 4800 Totals 33600 o 0 1000 4300 7840 5700 6560 4600 6 Demand units) (not of beg Inventory) Period production unita) Ending Inventory unto) Backorder unit) Cost Calculations for Plan A Regular time labor cost Inventory holding con Backorder cont Hing cost Fing cost Total Cost $0 D 3 1 Problem Data for Problems 1.7 2 $10.00 $15.00 $84.00 310.00 $20.00 SOC0.00 545000 Level Aggregate Plan, Using Inventories and Backorders Compute Level Production Rate Total Demand 34000 Loss Beginning inventory Total Not Demand Average Demand Per Period Producton Hole for Level Plan Compute Workforce Needed Units per loyee per Period Workers needed Numberto Hire Numberto Fire 280 400 CostData Regular time labor cost per hour Overtime borcom per hour Subcontracting cost per unit (abor only) Holding cost per unit period 9 Backorder cost per un period 10 Hiring cost per employee 11 Ping cost per employee 12 Capacity Data 13 Beginning wontece employees) 14 Beginning inventory units) 16 Labor standard porto) 10 Regular mevable per periodo 17 Overtime wallable per period hours) 18 Subcontracting maximum per person 10 Subcontracting minimum per period units) 20 Demand Data units) Perod 22 Period 2 23 Period Period 4 25 Periods 26 Penodo 27 Total Number of Periods 28 29 30 31 100 32 1000 500 Detailed Plan Computations Period 1 4600 Period 2 4300 Periods 7540 Period 4 5700 Periods 6560 Period 4600 Demand) of begin Period production (unit) Ending ventory (unit) Backorders Totals 33600 0 0 0 5000 4300 7840 5700 6560 4600 6 Cost Calculations for Plan A Regular ima labor cost Inventory holding con Back order cost Hiring cost Firing Cou Total Cos