Make sure you keep your Excel spreadsheet available because you may have questions using the same tree structure$/$BOM for different parts. Given the following information, develop a material requirements plan for end item A and its components. $50$ and $80$ units of A are needed at the beginning of week $6$ and $8,$ respectively.

$\backslash$table$[[$Item$,$On$-$Hand,On$-$Order,Lead Time$],[$A$,20,-,1$ wk$],[$B$,-,-,2$ wks$],[$C$,60,-,1$ wk$],[$D$,150,$ Week $2),2$ wks$],[$E$,10,-,1$ wk$]]$

B

C$(2)$

E $(2)$

The planned$-$order release for product $A$ is:

Week $6$: $50,$ Week $8$: $80$

Week $5$: $50,$ Week $7$: $80$

Week $5$:$30,$ Week $7$: $80$

Week $6$: $30,$ Week $8$: $80$

Week $5$:$30$

MacBook Pro