Ch$.11$: Aggregate Planning and Master Scheduling$\_$MPS$\_$Plessey Pumps $(5$ Pts$)$

Plessey Pumps manufactures a line of Industrial Pumps. Information for one of their pumps, part number A$-1316,$ is presented below.

Forecast for sales: $50$ per week in each of weeks $1-8$

Lot Sizing: Multiples of $75$ pieces

Firm customer sales order:

Week $1$: $52$

Week $2$: $35$

Week $3$: $20$

Week $4$: $12.$

a$).$ Prepare the Master Production Schedule for part number A$-1316,$ using the template below.

Master Production Schedule for PN A$-1316$

$\backslash$table$[[\backslash$table$[[$Beg Inv. $=],[$SS $=],[$Lot Sizing:$]],$Week or Period$],[$PD$,1,2,3,4,5,6,7,8],[$Forecast$],[$Customer Orders$],[$Gross Requirements$],[$Existing MPS Quantities$],[$Projected On Hand$],[$Net Requirements$],[$Planned MPS Receipts$],[$Planned MPS Releases$],[$Available$-$to$-$Promise,,,,,,,,,$]]$