Prepare a master schedule given this information: The forecast for each week of an eight$-$week schedule is $60$ 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$,$Customer Orders$],[1,55],[2,40],[3,25],[4,12]]$

Use a production lot size of $90$ units and no beginning inventory. $($In the ATP row, enter a value of $0($zero$)$ in any periods where ATP should not be calculated. Leave no cells blank $-$ be certain to enter $"$O$"$ wherever required.$)$

$\backslash$table$[[,$June,July$],[,1,2,3,4,5,6,7,8],[$Forecast$,60,60,60,60,60,60,60,60],[$Customer Orders,$55,40,25,12,0,0,0,0],[$Projected On$-$Hand Inventory,,,,,,,,$],[$MPS$,,,,,,,,],[$ATP$,,,,,,,,]]$