Assume that Product Z is made of two units of A and three units of B. A is made of four 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. Fifty-nine 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. Period: Gross requirements Item: Z Scheduled receipts OH: 0 LT: 2 SS:0 Q:L4L Item: A OH: LT: 1 0 SS:0 Q:L4L Projected available balance Net requirements Planned order receipts Planned order releases Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases Gross requirements Item: B Scheduled receipts OH: 0 LT: 1 SS:0 Q:L4L Item: C OH: 0 LT: 1 SS:0 Q: L4L Item: D OH: 0 LT: 1 SS:0 Q: L4L Projected available balance Net requirements Planned order receipts Planned order releases Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases 1 2 3 4 5 6 7 8 9 10 70 Item: E OH: 0 LT:3 SS:0 Q:L4L Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases