How to solve

Problem $21-13($Algo$)$

One unit of $A$ is made of two units of $B,$ three units of $C,$ and two units of $D.B$ is composed of one unit of $E$ and two units of $F.C$ is made of two units of $F$ and one unit of $D.E$ is made of two units of $D.$ Items $A,C,D,$ and $F$ have oneweek lead times; B and E have lead times of two weeks. Lot$-$for$-$lot $($L$4$L$)$ lot sizing is used for items A$,$ B$,$ C$,$ and D; lots of size $49$ and $156$ are used for items $E$ and $F,$ respectively. Item $C$ has an on$-$hand $($beginning$)$ inventory of $19$; $D$ has an on$-$hand inventory of $62$; all other items have zero beginning inventories. We are scheduled to receive $13$ units of item $E$ in Week $2$; there are no other scheduled receipts.

If $12$ units of A are required in Week $8,$ use the low$-$level$-$coded bill$-$of$-$materials to find the necessary planned$-$order releases for all components.

Note: Leave no cells blank $-$ be certain to enter $\backslash "0\backslash "$ wherever required.

$\backslash \backslash$table$[[,$Period,$1,2,3,4,5,6,7,8],[,$Gross requir$$nts$,,,,,,,,],[$Item A$,$Scheduled receipts,,,,,,,,$],[OH=0,$Projected available balance,,,,,,,,$],[LT=1,$Net requirements,,,,,,,,$],[SS=0,$Planned order receipts,,,,,,,,$],[Q=L4L,$Planned order releases,,,,,,,,$],[$Gross requirements,,,,,,,,$],[$Item B$,$Scheduled receipts,,,,,,,,$],[OH=0,$Projected available balance,,,,,,,,$],[LT=2,$Net requirements,,,,,,,,$],[SS=0,$Planned order receipts,,,,,,,$=,],[Q=L4L,$Planned order releases,,,,,,,,$],[$Gross requirements,,,,,,,,$],[$Item C$,$Scheduled receipts,,,,,,,,$],[OH=19,$Projected available balance,,,,,,,,$],[LT=1,$Net requirements,,,,,,,,$],[SS=0,$Planned order receipts,,,,,,,,$],[Q=L4L,$Planned order releases,,,,,,,,$],[$Gross requirements,,,,,,,,$],[$Item E$,$Scheduled receipts,,,,,,,,$],[OH=0,$Projected available balance,,,,,,,,$],[LT=2,$Net requirements,,,,,,,,$],[SS=0,$Planned order receipts,,,,,,,,$],[Q=49,$Planned order releases,,,,,,,,$],[$Gross requirements,,,,,,,,$],[$Item $F,$Scheduled receipts,,,,,,,,$],[OH=0,$Projected available balance,,,,,,,,$],[LT=1,$Net requirements,,,,,,,,$],[SS=0,$Planned order receipts,,,,,,,,$],[Q=156,$Planned order releases,,,,,,,,$],[$Gross requirements,,,,,,,,$],[$Item D$,$Scheduled receipts,,,,,,,,$],[OH=62,$Projected available balance,,,,,,,,$],[LT=1,$Net requirements,,,,,,,,$],[SS=0,$Planned order receipts,,,,,,,,$],[Q=L4L,$Planned order releases,,,,,,,,$]]$