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$-13\mathrm{.}16,$ 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$begin$\{$tabular$\}\{|$l$|$l$|$l$|$l$|$l$|$l$|$l$|$l$|$l$|$l$|$l$|\}$

$\backslash$hline $\backslash$begin$\{$tabular$\}\{$l$\}$

Beg Inv. $\backslash (=\backslash )\backslash \backslash$

SS$=\backslash \backslash$

Lot Sizing:

$\backslash$end$\{$tabular$\}$ & $\backslash$multicolumn$\{6\}\{|$l$|\}\{$ Week or Period $\}\backslash \backslash$

$\backslash$hline & PD & $1$ & $2$ & $3$ & $4$ & $5$ & $6$ & $7$ & $8$ & $\backslash \backslash$

$\backslash$hline Forecast & & & & & & & & & & $\backslash \backslash$

$\backslash$hline Customer Orders & & & & & & & & & & $\backslash \backslash$

$\backslash$hline Gross Requirements & & & & & & & & & $\backslash \backslash$

$\backslash$hline Existing MPS Quantities & & & & & & & & & $\backslash \backslash$

$\backslash$hline Projected On Hand & & & & & & & & & $\backslash \backslash$

$\backslash$hline Net Requirements & & & & & & & & & & $\backslash \backslash$

$\backslash$hline Planned MPS Receipts & & & & & & & & & & $\backslash \backslash$

$\backslash$hline Planned MPS Releases & & & & & & & & & & $\backslash \backslash$

$\backslash$hline Available$-$to$-$Promise & & & & & & & & & & $\backslash \backslash$

$\backslash$hline

$\backslash$end$\{$tabular$\}$

Ch $11\_$Aggregate Planning and Master Scheduling$\_$MPS$\_$Plessey$\_$Pumps 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$-13\mathrm{.}16,$ 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$begin$\{$tabular$\}\{|$l$|$l$|$l$|$l$|$l$|$l$|$l$|$l$|$l$|$l$|$l$|\}$

$\backslash$hline $\backslash$begin$\{$tabular$\}\{$l$\}$

Beg Inv. $\backslash (=\backslash )\backslash \backslash$

SS$=\backslash \backslash$

Lot Sizing:

$\backslash$end$\{$tabular$\}$ & $\backslash$multicolumn$\{6\}\{|$l$|\}\{$ Week or Period $\}\backslash \backslash$

$\backslash$hline & PD & $1$ & $2$ & $3$ & $4$ & $5$ & $6$ & $7$ & $8$ & $\backslash \backslash$

$\backslash$hline Forecast & & & & & & & & & & $\backslash \backslash$

$\backslash$hline Customer Orders & & & & & & & & & & $\backslash \backslash$

$\backslash$hline Gross Requirements & & & & & & & & & $\backslash \backslash$

$\backslash$hline Existing MPS Quantities & & & & & & & & & $\backslash \backslash$

$\backslash$hline Projected On Hand & & & & & & & & & $\backslash \backslash$

$\backslash$hline Net Requirements & & & & & & & & & & $\backslash \backslash$

$\backslash$hline Planned MPS Receipts & & & & & & & & & & $\backslash \backslash$

$\backslash$hline Planned MPS Releases & & & & & & & & & & $\backslash \backslash$

$\backslash$hline Available$-$to$-$Promise & & & & & & & & & & $\backslash \backslash$

$\backslash$hline

$\backslash$end$\{$tabular$\}$

Ch $11\_$Aggregate Planning and Master Scheduling$\_$MPS$\_$Plessey$\_$Pumps 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$-13\mathrm{.}16,$ 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$begin$\{$tabular$\}\{|$l$|$l$|$l$|$l$|$l$|$l$|$l$|$l$|$l$|$l$|$l$|\}$

$\backslash$hline $\backslash$begin$\{$tabular$\}\{$l$\}$

Beg Inv. $\backslash (=\backslash )\backslash \backslash$

SS$=\backslash \backslash$

Lot Sizing:

$\backslash$end$\{$tabular$\}$ & $\backslash$multicolumn$\{6\}\{|$l$|\}\{$ Week or Period $\}\backslash \backslash$

$\backslash$hline & PD & $1$ & $2$ & $3$ & $4$ & $5$ & $6$ & $7$ & $8$ & $\backslash \backslash$

$\backslash$hline Forecast & & & & & & & & & & $\backslash \backslash$

$\backslash$hline Customer Orders & & & & & & & & & & $\backslash \backslash$

$\backslash$hline Gross Requirements & & & & & & & & & $\backslash \backslash$

$\backslash$hline Existing MPS Quantities & & & & & & & & & $\backslash \backslash$

$\backslash$hline Projected On Hand & & & & & & & & & $\backslash \backslash$

$\backslash$hline Net Requirements & & & & & & & & & & $\backslash \backslash$

$\backslash$hline Planned MPS Receipts & & & & & & & & & & $\backslash \backslash$

$\backslash$hline Planned MPS Releases & & & & & & & & & & $\backslash \backslash$

$\backslash$hline Available$-$to$-$Promise & & & & & & & & & & $\backslash \backslash$

$\backslash$hline

$\backslash$end$\{$tabular$\}$

Ch $11\_$Aggregate Planning and Master Scheduling$\_$MPS$\_$Plessey$\_$Pumps