Question : Prepare an MPS table using the following information. The forecast for weeks 1 to 3 is 30 units and from weeks 4 to 7 is 40 units. Projected on hand inventory is 33 units (end of May) and the lot size is 70. Customer orders (committed are):

week 1 : 35

week 2 : 16

week 3 : 11

week 4: 8

week 5 : 3

week 6 :

week 7 :

Create the table