Prepare an MPS table like that shown in Figure 12-11 for the following situation. The forecast for each of the next four weeks is 70 units. The starting inventory is zero. The MPS rule is to schedule production if the projected inventory on hand will be negative. The production lot size is 100 units. The following table shows customer (committed) orders.

Week	Customer Orders
1	80
2	50
3	30
4	10

Calculate the available-to-promise (ATP) quantities for each period. (Do not leave any empty spaces; input a "0" wherever it is required.)

			June
		1	2	3	4
Forecast		70	70	70	70
Committed
Projected on hand (min = 0)	0
Produce (lot size = 100)
Available-to-promise