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,$On$-$Order,Lead Time,Order Size$],[$B$,-,-,2$ wks$,$lot$-$for$-$fot$],[$C$,60,-,1$ wk$,100],[$D$,150,100($Week $2),2$ wks$,200],[$E$,10,-,1$ wk$,$lot$-$for$-$lot$]]$

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

Week $3$: $50,$ Week $5$: $100$

Week $3$: $30,$ Week $5$: $80$

Week $3$: $50,$ Week $5$: $80$

Week $4$: $50,$ Week $6$: $100$