Prepare an MPS table like Figure 13-12 using the following information: The forecast for each week of an eight-week schedule is 50 units. The MPS rule is to schedule production if the projected on-hand inventory would be negative without it. Customer orders (committed)
are:

Week                    Customer Orders
1 .....................................    52
2 .....................................    35
3 .....................................    20
4 .....................................    12

Use a production lot size of 75 units and no beginning inventory.

Data from Figure 13-12 

Weeks June July 64 2 3 5 7 Forecast 30 30 30 30 40 40 40 40 Customer orders 33 20 10 (committed) Projected on-hand inventory 31 1 41 11 41 31 61 Planned 70 70 70 70 production Available-to- 11 56 68 70 70 promise inventory (uncommitted) 2.