Below is an example to help

Complete the MPS record below for a single item. (Enter your responses as integers. A response of "O" is equivalent to being not applicable.) Item: A January Order Policy: 100 units Lead Time: 1 week February Week Quantity on Hand: 75 1 3 4 5 7 8 2 60 6 45 70 70 50 45 45 55 40 15 85 0 40 70 0 0 Forecast Customer orders (booked) Projected on-hand inventory MPS quantity DO The projected on-hand inventory balance for a week is equal to the previous inventory on-hand minus the projected requirements for the week plus any MPS quantity. The projected requirements for a week are the greater of that week's forecast or customer orders. MPS quantity is scheduled only when needed to prevent the projected on-hand inventory from becoming zero or less, and come in increments according to the order policy. To determine projected on-hand inventory and MPs quantity for week 1, start with the quantity on hand and subtract the week 1 projected requirements. If this value is not negative, enter it as the projected on-hand inventory and enter for the MPS quantity; otherwise, enter 100 (the order policy) into the MPS quantity row and enter the value plus 100 for the projected on-hand inventory. Complete the Projected on-hand inventory row and MPS quantity row for week 1. Item: A Order Policy: 100 units Lead Time: 1 week January February Quantity Week on Hand: 90 5 Forecast 65 45 50 50 45 Customer orders 45 85 (booked) Projected on-hand 25 inventory MPS quantity 1 2 3 4 6 7 8 60 65 45 15 0 35 75 0 0 To determine projected on-hand inventory and MPS quantity for week 2, start with the projected on-hand inventory for week 1 and subtract the week 2 projected requirements. If this value is not negative, enter it as the projected on-hand inventory and enter for the MPS quantity; otherwise, enter 100 (the order policy) into the MPS quantity row and enter the value plus 100 for the projected on-hand inventory. Complete the projected on-hand inventory row and MPS quantity row for week 2. Item: A Order Policy: 100 units Lead Time: 1 week January February Quantity Week on Hand: 90 2 3 4 5 6 7 8 Forecast 60 65 45 45 Customer orders 85 0 35 75 0 (booked) Projected on-hand inventory MPS quantity 0 100 1 65 45 50 50 45 15 0 25 65 Now repeat the process to fill in the remaining columns. Item: A January Quantity on Hand: 90 Order Policy: 100 units Lead Time: 1 week February Week 5 6 7 45 50 50 1 3 4 2 60 8 45 65 65 45 45 15 85 0 35 75 0 0 Forecast Customer orders (booked) Projected on-hand inventory MPS quantity 25 65 80 35 90 15 65 20 0 100 100 0 100 0 100 0