k: Aggregate Planning and Master Schedulin... $($i$)$

Question $1-$ Homework: Aggregate Planning and Master Sc

Help

Prepare a master schedule given this information: It is now the end of week $1$ ; customer orders are $25$ for week $2,16$ for week $3,11$ for week $4,8$ for week $5,$ and $3$ for week $6.$ Use the MPS rule of ordering production when projected on$-$hand inventory would be negative without production. Suppose that there were $64$ pumps in inventory at the beginning of week $1.$ A production lot size of $70$ pumps is used.

Note: 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,25,16,11,8,3,,],[$Projected on$-$hand inventory,,,,,,,,$],[$MPS$,,,,,,,,],[$ATP$,,,,,,,,]]$