Question: Managing Production - MPS Part a: Complete the following master schedule record: On-hand inventory at end of week 1 = 65 Week 2 3 4
- Managing Production - MPS
Part a: Complete the following master schedule record:
| On-hand inventory at end of week 1 = 65 |
|
|
|
|
|
|
|
|
| Week | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 |
| Forecasted Demand | 45 | 50 | 55 | 60 | 65 | 70 | 75 | 80 |
| Booked Orders | 15 | 100 | 48 | 25 | 72 | 22 | 67 | 10 |
| Projected ending inventory |
|
|
|
|
|
|
|
|
| Master production schedule | 150 |
|
| 200 |
|
| 150 |
|
| Available to promise |
|
|
|
|
|
| 73 |
|
Part b: Suppose marketing books an order for an additional 10 units in week 4. Recalculate projected ending inventory and available-to-promise. How low does the projected ending inventory go? What actions might the company take as a result?
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
