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: 60 units | |||||||
| Lead Time: 1 week | ||||||||
| Quantity on Hand: 40 | Week | |||||||
| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | |
| Forecast | 20 | 18 | 31 | 31 | 26 | 30 | 31 | 41 |
| Customer orders (booked) | 13 | 17 | 11 | 14 | 7 | 0 | 11 | 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: 60 units | |||||||
| Lead Time: 1 week | ||||||||
| Quantity on Hand: 40 | Week | |||||||
| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | |
| Forecast | 20 | 18 | 31 | 31 | 26 | 30 | 31 | 41 |
| Customer orders (booked) | 13 | 17 | 11 | 14 | 7 | 0 | 11 | 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
