assembled from three parts, B$,$ C and D$.$ The quantities per of each unit of $B,C$ and $D$ for one unit of A are $2,1$ and $2,$ respectively. Part $B$ is also made from two parts, $E$ and $F,$ with quantities per of $3$ and $1,$ respectively. The current actual inventory level is $900$ units and the lead time for part $D$ is $2$ weeks.

Required:

Generate the Material Requirements Plan for Part D using Lot$-$for$-$Lot MRP logic and use your Materials Requirements Plan to compute the Total of all Planned Orders for the next $9$ weeks. The Total of all Planned Orders for the next $9$ weeks is;

Week

$0$

$1$

$2$

$3$

$4$

$5$

$6$

$7$

$8$

MPS

$150$

$300$

$250$

$250$

$220$

$200$

Week

$0$

$1$

$2$

$3$

$4$

$5$

$6$

$7$

$8$