Problem $11-19($Static$)$

Prepare a master production schedule for industrial pumps in the manner of the following table. Use the MPS rule to "schedule production when the projected on$-$hand inventory would be less than $10$ without production." Suppose that there are currently $64$ pumps in inventory and a production lot size of $70$ pumps is used. $($Leave no cells blank $-$ be certain to enter $"0"$ wherever required.$)$

$\backslash$table$[[,$June,July$],[,1,2,3,4,5,6,7,8],[$Forecast$,30,30,30,30,40,40,40,40],[$Customer orders $($committed$),33,20,10,4,2,,,],[$Projected on$-$hand inventory,,,,,,,Z$,],[$MPS$,,,,,,,,],[$ATP$,,,,,,,,]]$