Problem $9-11($Algo$)$

Assume that Product $Z$ is made of two units of A and four units of $B.A$ is made of three units of $C$ and four of $D.D$ is made of two units of $E.$

Lead times for purchase or fabrication of each unit to final assembly are: $Z$ takes two weeks; $A,B,C,$ and $D$ take one week each; and $E$ takes three weeks.

Sixty$-$six units of Product $Z$ are required in Period $10.($Assume that there is currently no inventory on$-$hand of any of these items.$)$

b$.$ Develop an MRP planning schedule showing gross and net requirements and order release and order receipt dates.

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: Z$],[$OH: $0],[$LT: $2],[$SS: $0],[$Q: L$4$L$]],$Gross requirements,,,,,,,,,,$],[$Scheduled receipts,,,,,,,,,,$],[$Projected available balance,,,,,,,,,,$],[\backslash$table$[[$Net requirements$]],,,,,,,,,,],[$Planned order receipts,,,,,,,,,,$],[$Planned order releases,,,,,,,,,,$],[\backslash$table$[[$Item: A$],[$OH: $0],[$LT:$],[$SS: $0],[$Q: L$4$L$]],$Gross requirements,,,,,,,,,,$],[$Scheduled receipts,,,,,,,,,,$],[$Projected available balance,,,,,,,,,,$],[$Net requirements,,,,,,,,,,$],[$Planned order receipts,,,,,,,,,,$],[$Planned order releases,,,,,,,,,,$]]$