Question: A partial table for end item B is provided below. Compute the MPS for item B and then the ATP values. Answer the multiple-choice questions.
A partial table for end item B is provided below. Compute the MPS for item B and then the ATP values. Answer the multiple-choice questions.
| Item B | Lead Time: 1 weeks | Lot Size: 80 units | ||||||
|
| Week | |||||||
| Quantity on Hand: 60 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 |
| Forecast | 50 | 40 | 40 | 40 | 40 | 40 | 35 | 35 |
| Customer orders (booked) | 60 | 20 | 15 | 45 | 10 | 12 | 5 |
|
| Projected on Hand |
|
|
|
|
|
|
|
|
| MPS quantity |
|
|
|
|
|
|
|
|
| MPS start |
|
|
|
|
|
|
|
|
| Available-to-promise |
|
|
|
|
|
|
|
|
- What is the MPS start quantity in week 3?
- 80 units
- 60 units
- 30 units
- 20 units
- What is the projected on-hand inventory in week 6?
- 0 units
- 15 units
- 35 units
- 63 units
- What is the available-to-promise (ATP) inventory in week 5?
- 0 units
- 35 units
- 45 units
- 53 units
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
