One unit of A is made of three units of B. one unit of C. and two units of D. B is composed of two units of E and one unit of D. Cis made of one unit of B and two units of E. E is made of one unit of Items B, C, E, and F have one week lead times; A and Dhave lead times of two weeks. Assume that lot-for-lot (L4L) lot sizing is used for Items A, B, and lots of size 50, 50, and 175 are used for Items C, D and E. respectively. Items C, E, ond F have on-hand (beginning) Inventories of 10, 50, and 160, respectively, all other items have zero beginning inventory. We are scheduled to receive 10 units of A in Week 2,50 units of in Week 1, and also 40 units of Fin Week 1 There are no other scheduled receipts. If 30 units of A are required in Week 8, use the low-level-coded bill-of-materials to find the necessary planned-order releases for all components. Develop an MRP planning schedule showing gross and net requirements and order release and order receipt dates. (Leave the cells blank, whenever zero (O) is required.) Item : 0 LT 2 SS: 0 Q: L4L Period: Gross requirements Scheduled receipts Projected available balance Not requirements Planned order receipts Planned order releases Item: C OH: 10 LT. 1 SS: 0 Gross requirements Scheduled receipts Projected available balance Net requirements Q: 50 Help Save & Exit Submit Planned order receipts Planned order releases Item: B OH:0 LT: 1 SS: Q: L4L Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases Hem: D OHO LT: 2 SS: 0:50 Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases Item: E OH: 50 LT 1 SS: Q: 175 Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases Gross requirements Planned order receipts Planned order releases Item: F OH: 150 LT 1 SS: 0 Q: LAL Gross requirements Scheduled receipts Projected available balance + Net requirements Planned order receipts Planned order releases