Assume that Product Z is made of two units of A and three 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 three 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. $($Leave no cells blank $-$ be certain to enter $"0"$ wherever required.$)$

Period

$1$

$2$

$3$

$4$

$5$

$6$

$7$

$8$

$9$

$10$

Gross requirements

Item Z

Scheduled receipts

OH $=0$

Projected available balance

LT $=2$

Net requirements

SS $=0$

Planned order receipts

Q $=$ L$4$L

Planned order releases

Gross requirements

Item A

Scheduled receipts

OH $=0$

Projected available balance

LT $=1$

Net requirements

SS $=0$

Planned order receipts

Q $=$ L$4$L

Planned order releases

Gross requirements

Item B

Scheduled receipts

OH $=0$

Projected available balance

LT $=1$

Net requirements

SS $=0$

Planned order receipts

Q $=$ L$4$L

Planned order releases

Gross requirements

Item C

Scheduled receipts

OH $=0$

Projected available balance

LT $=1$

Net requirements

SS $=0$

Planned order receipts

Q $=$ L$4$L

Planned order releases

Gross requirements

Item D

Scheduled receipts

OH $=0$

Projected available balance

LT $=1$

Net requirements

SS $=0$

Planned order receipts

Q $=$ L$4$L

Planned order releases

Gross requirements

Item E

Scheduled receipts

OH $=0$

Projected available balance

LT $=3$

Net requirements

SS $=0$

Planned order receipts

Q $=$ L$4$L

Planned order releases