Prepare a master schedule given this information: The forecast for each week of an eight$-$week schedule is $75$ units. The MPS rule is to schedule production if the projected on$-$hand inventory would be negative without it$.$ Customer orders $($committed$)$ are as follows:

$\backslash$table$[[$Week$,\backslash$table$[[$Customer$],[$Orders$]]],[1,48],[2,42],[3,37],[4,33]]$

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

Note: In the ATP row, enter a value of O $($zero$)$ in any periods where ATP should not be calculated. Leave no cells blank $-$ be certain to enter $"0"$ wherever required.

$\backslash$table$[[,$June,July$],[,1,2,3,4,5,6,7,8],[$Forecast$,75,75,75,75,75,75,75,75],[$Customer Orders,$48,42,37,33,0,0,0,0],[$Projected On$-$Hand Inventory,$30,(12),54,21,99,21,99,21],[$MPS$,78,0,78,0,78,0,78,0],[$ATP$,30,0,66,0,99,0,99,0]]$