Question: Complete the MPS record below for a single item. (Enter your responses as integers. A response of 0 is equivalent to being not applicable.) Item:
Complete the MPS record below for a single item. (Enter your responses as integers. A response of "0" is equivalent to being not applicable.)
| Item: A | Order Policy: 100 units | |||||||
| Lead Time: 1 week | ||||||||
| January | February | |||||||
| Quantity on Hand: 75 | Week | |||||||
| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | |
| Forecast | 65 | 70 | 60 | 45 | 50 | 45 | 45 | 55 |
| Customer orders (booked) | 45 | 10 | 90 | 0 | 30 | 65 | 0 | 0 |
| Projected on-hand inventory | ||||||||
| MPS quantity | ||||||||
The MPS start row shows when items in the MPS quantity row should begin production or procurement. Since the lead time for item A is 1 week, shift the values from the MPS quantity row back 1 week
| Item: A | Order Policy: 100 units | |||||||
| Lead Time: 1 week | ||||||||
| January | February | |||||||
| Quantity on Hand: 75 | Week | |||||||
| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | |
| Forecast | 65 | 70 | 60 | 45 | 50 | 45 | 45 | 55 |
| Customer orders (booked) | 45 | 10 | 90 | 0 | 30 | 65 | 0 | 0 |
| Projected on-hand inventory | ||||||||
| MPS quantity MPS Start Quantity | ||||||||
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
