Question: A partial table for end item B is provided below. Compute the MPS for item B and then the ATP values. Complete the table and
A partial table for end item B is provided below. Compute the MPS for item B and then the ATP values. Complete the table and then answer the multiple-choice questions; you need to complete the table to receive full credit (even if the answers to multiple-choice questions are correct).
| Item B | Lead Time: 1 week | Lot Size:60 units |
| |||
|
| Week |
|
|
|
|
|
| Quantity on Hand: 30 | 1 | 2 | 3 | 4 | 5 | 6 |
| Forecast | 15 | 40 | 10 | 20 | 50 | 30 |
| Customer orders (booked) | 20 | 25 | 10 | 20 | ||
| Projected on Hand |
|
|
|
|
|
|
| MPS quantity |
|
|
|
|
|
|
| MPS start |
|
|
|
|
|
|
| Available-to-promise |
|
|
|
|
|
|
- What is the MPS start quantity in week 4?
- 60 units
- 20 units
- 10 units
- 0 units
- What is the projected on-hand inventory in week 3?
- 0 units
- 10 units
- 30 units
- 60 units
- What is the available-to-promise (ATP) inventory in week 5?
- 0 units
- 10 units
- 30 units
- 60 units
- A distributor of the hand drills places an order for 15 units. What is the appropriate shipping date for the entire order?
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
