LastName.FirstName-Case1.xls - Aggregate Production...

Aggregate Production Planning Cost Total
Costs Per Unit Units
Regular Time Labor Cost $14.00 115080
Overtime/Subcontracting $7.00 84
Beginning Inventory 6600 Inventory Holding Cost $0.00 0
Beginning Workforce 100 Backorders $109.38 1312.5
Labor Standard (units/worker) 14 Hiring $14.00 1200
Layoff $7.00 120
Total Costs
Period January February March April May June July
Demand 150000 160000 170000 180000 190000 200000 190000
Cumulative Demand 150000 310000 480000 660000 850000 1050000 1240000
Net Cumulative Demand 143400 303400 473400 653400 843400 1043400 1233400
Production/Inventory Planning
Production 6600 6600 6600 6600 6600 6600 6600
Cumulative Production 6600 13200 19800 26400 33000 39600 46200
Inventory (Excess Units) 0 0 0 0 0 0 0
Backorders (Units Short) 101 87.8 69.5 134 136 167 101
Capacity Planning
Workers Hired 100 100 100 100 100 100 100
Workers Layed Off 10 10 10 10 10 10 10
Workforce Available 190 280 370 460 550 640 730
Regular Time Capacity (units) 2660 3920 5180 6440 7700 8960 10220
Overtime/Subcontracting (units) 7 7 7 7 7 7 7
Total Production Capacity (units) 2667 3927 5187 6447 7707 8967 10227

Total
Cost
$1,611,120
$588
$0
$143,555
$16,800
$840
$1,772,903
August
180000
1420000
1413400
6600
52800
0
133
100
10
820
11480
7
11487

Aggregate Production Planning Cost Total
Costs Per Unit Units
Regular Time Labor Cost $14.00 115080
Overtime/Subcontracting $7.00 84
Beginning Inventory 23760 Inventory Holding Cost $0.00 0
Beginning Workforce 100 Backorders $388.23 4658.7
Labor Standard (units/worker) 14 Hiring $14.00 1200
Layoff $7.00 120
Total Costs
Period January February March April May June July
Demand 100000 50000 50000 150000 50000 100000 50000
Cumulative Demand 100000 150000 200000 350000 400000 500000 550000
Net Cumulative Demand 76240 126240 176240 326240 376240 476240 526240
Production/Inventory Planning
Production 23760 23760 23760 23760 23760 23760 23760
Cumulative Production 23760 47520 71280 95040 118800 142560 166320
Inventory (Excess Units) 0 0 0 0 0 0 0
Backorders (Units Short) 358.4 310.88 241.1 477.2 479.2 596 358.4
Capacity Planning
Workers Hired 100 100 100 100 100 100 100
Workers Layed Off 10 10 10 10 10 10 10
Workforce Available 190 280 370 460 550 640 730
Regular Time Capacity (units) 2660 3920 5180 6440 7700 8960 10220
Overtime/Subcontracting (units) 7 7 7 7 7 7 7
Total Production Capacity (units) 2667 3927 5187 6447 7707 8967 10227