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$[[,\backslash$table$[[$Customer$]]],[$Week$,$Orders$],[1,48],[2,42],[3,23],[4,12]]$

Use a production lot size of $100$ 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,23,12,0,0,0,0],[$Projected On$-$Hand Inventory,,,$1,,,,,],[$MPS$,,,,,,,,],[$ATP$,,|,,,,,,]]$