Question: Develop the MPS for the following products (A, B, C). Comment on your findings. Product A: Use EOQ = 300 Week 1 Week 2 Week
Develop the MPS for the following products (A, B, C). Comment on your findings. Product A: Use EOQ = 300
|
|
| Week 1 | Week 2 | Week 3 | Week 4 | Week 5 |
| Forecasted Demand |
| 250 | 250 | 250 | 250 | 250 |
| Booked Orders |
|
|
| 500 |
|
|
| Projected Inventory |
|
|
|
|
|
|
| MPS |
|
|
|
|
|
|
| On Hand | 25 |
|
|
|
|
|
Product B: Use Lot for Lot
|
|
| Week 1 | Week 2 | Week 3 | Week 4 | Week 5 |
| Forecasted Demand |
| 150 | 300 | 200 | 300 | 200 |
| Booked Orders |
| 100 |
|
|
|
|
| Projected Inventory |
|
|
|
|
|
|
| MPS |
|
|
|
|
|
|
| On Hand | 10 |
|
|
|
|
|
Product C: Note that in this case, MPS is provided. Simply find Projected Inventory at the end of each period and comment on your findings.
|
|
| Week 1 | Week 2 | Week 3 | Week 4 | Week 5 |
| Forecasted Demand |
| 200 | 300 | 200 | 200 | 200 |
| Booked Orders |
|
|
| 600 |
|
|
| Projected Inventory |
|
|
|
|
|
|
| MPS |
| 500 |
| 500 |
| 500 |
| On Hand | 10 |
|
|
|
|
|
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
