Supply Chain Management Strategy Proposal (2)
MRP_Template_Phase4_IP.docx
MRP – Template for Unit 4 Individual Project (Key Assignment)
|
Month |
-2 |
-1 |
1 |
2 |
3 |
4 |
5 |
6 |
|
Sales forecast by month |
|
|
|
|
|
|
|
|
|
Finished good Inventory Required by end of month: |
|
|
|
|
|
|
|
|
|
Beginning inventory |
|
|
|
|
|
|
|
|
|
Production needed |
|
|
|
|
|
|
|
|
|
Ending Inventory |
|
|
|
|
|
|
|
|
|
How many and when must Bs must be ordered at 2 per finished product; assume no safety stock of Bs are desired |
|
|
|
|
|
|
|
|