$4$

Problem $21-18($Algo$)$

oints

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

Skipped

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.

If $120$ 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. $($Leave no cells blank $-$ be certain to enter $"0"$ wherever required.$)$

References

$\backslash$table$[[,$Period,$1,2,3,4,5,6,7,8,9,10],[,$Gross requirements,,,,,,,,,,$],[$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=0,$Projected available balance,,,,,,,,,,$],[LT=2,$Net requirements,,,,,,,,,,$],[SS=0,$Planned order receipts,,,,,,,,,,$],[Q=L4L,$Planned order releases,,,,,,,,,,$],[,$Gross requirements,,,,,,,,,,$],[$Item D$,$Scheduled receipts,,,,,,,,,,$],[OH=0,$Projected available balance,,,,,,,,,,$],[LT=3,$Net requirements,,,,,,,,,,$],[SS=0,$Planned order receipts,,,,,,,,,,$],[Q=$LAL,Planned order releases,,,,,,,,,,$],[[,$Gross requirements,,,,,,,,,,$],[$Item $E,$Scheduled receipts,,,,,,,,,,$],[OH=0,$Projected avaliable balance,,,,,,,,,,$],[LT=2,$Net requirements,,,,,,,,,,$],[SS=0,$Planned order receipts,,,,,,,,,,$],[Q=L4L,$Planned order releases,,,,,,,,,,$],[,$Gross requirements,,,,,,,,,,$],[$Item F$,$Scheduled receipts,,,,,,,,,,$],[OH=0,$Projected available balance,,,,,,,,,,$],[LT=3,$Net requirements,,,,,,,,,,$],[SS=0,$Planned order receipts,,,,,,,,,,$],[Q=L4L,$Planned order releases,,,,,,,,,,$]]$