Global Supply Chain management Case study
ngstoun
unit_5_assignment_sample.docxANALYTICS EXERCISE: Bradford Manufacturing
|
Aggregate Plan |
Quarter (Week Numbers) |
|||
|
|
1st (1-13) |
2nd (14-26) |
3rd (27-39) |
4th (40-52) |
|
Lines run |
|
|
|
|
|
Overtime hours per day |
|
|
|
|
|
|
|
|
|
|
|
Beginning Inventory |
|
|
|
|
|
Production |
|
|
|
|
|
Expected Demand |
|
|
|
|
|
Ending Inventory |
|
|
|
|
|
|
|
|
|
|
|
Deviation from Inventory Target |
|
|
|
|
|
Employees |
|
|
|
|
|
|
|
|
|
|
|
Cost of Plan |
|
|
|
|
|
Labor Regular Time |
|
|
|
|
|
Labor Overtime |
|
|
|
|
|
Hiring and Training |
|
|
|
|
|
Layoff |
|
|
|
|
|
Inventory Carry Cost |
|
|
|
|
|
Stockout Cost |
|
|
|
|
|
Quarter Budget |
|
|
|
|
|
|
|
|
|
|
|
Total Cost of Plan |
|
The following are a set of production rates and demand that work well:
|
Week |
Production Rate |
Demand |
Week |
Production Rate |
Demand |
|
1 |
|
|
|
|
|
|
2 |
|
|
|
|
|
|
3 |
|
|
|
|
|
|
4 |
|
|
|
|
|
|
5 |
|
|
|
|
|
|
6 |
|
|
|
|
|
|
7 |
|
|
|
|
|
|
8 |
|
|
|
|
|
|
9 |
|
|
|
|
|
|
10 |
|
|
|
|
|
