Problem $9-18($Algo$)$

Product $A$ is an end item and is made from two units of $B$ and three of $C.B$ is made of three units of $D$ and four of $E.C$ is made of three units of $F$ and four of $E.$

A has a lead time of one week. B$,$ C$,$ and E have lead times of two weeks, and D and F have lead times of three weeks.

b$.$ If $80$ units of A are required in Week $10,$ develop the MRP planning schedule, specifying when items are to be ordered and received.

There are currently no units of inventory on hand.

Note: Leave the cells blank, whenever zero $(0)$ is required.

$\backslash$table$[[,$Period:,$1,2,3,4,5,6,7,8,9,10],[\backslash$table$[[$Item: A$],[$OH: $0],[$LT: $1],[$SS: $0],[$Q: L$4$L$]],$Gross requirements,,,,,,,,,,$],[$Scheduled receipts,,,,,,,,,,$],[$Projected available balance,,,,,,,,,,$],[$Net requirements,,,,,,,,,,$],[$Planned order receipts,,,,,,,,,,$],[$Planned order releases,,,,,,,,,,$],[\backslash$table$[[$Item: B$],[$OH: $0],[$LT: $2],[$SS: $0],[$Q: L$4$L$]],$Gross requirements,,,,,,,,,,$],[$Scheduled receipts,,,,,,,,,,$],[$Projected available balance,,,,,,,,,,$],[$Net requirements,,,,,,,,,,$],[$Planned order receipts,,,,,,,,,,$],[$Planned order releases,,,,,,,,,,$],[$Gross renuirements,,,,,,,,,$17,]]$