Prepare an MPS table like Figure $12-11$ 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

$1$

Customer Orders

$52$

$35$

$20$

$12$

Use a production lot size of $75$ units and no beginning Inventory. Complete the following table, using the above information. $($Do not leave any empty spaces; input a $"$O$"$ wherever it is required.$)$

June

July

Forecast

Committed

Projected on hand $($min $=0)$

Produce $($lot size $75)$

Available$-$to$-$promise