Question: Shown below is a partially completed MPS record for ball bearings. a. Develop the MPS for ball bearings. (Enter your responses as integers. A response
Shown below is a partially completed MPS record for ball bearings.
a. Develop the MPS for ball bearings. (Enter your responses as integers. A response of "0" is equivalent to being not applicable.)
| Item: Ball bearings | Order Policy: 500 units | |||||||||
| Lead Time: 1 week | ||||||||||
| Quantity on Hand: 400 | Week | |||||||||
| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | |
| Forecast | 550 | 300 | 400 | 400 | 250 | 300 | 200 | 350 | 400 | 400 |
| Customer orders(booked) | 300 | 350 | 250 | 250 | 200 | 150 | 150 | 100 | 150 | 150 |
| Projected on-hand inventory |
|
|
|
|
|
|
|
|
|
|
| MPS quantity | 500 |
|
|
|
|
|
|
|
|
|
| MPS start |
|
|
|
|
|
|
|
|
|
|
| Available-to- promise (ATP) inventory |
|
|
|
|
|
|
|
|
|
|
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
