Level 0 Problem 2. 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. C is made of one unit of B and two units of E. E is made of one unit of F. 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 F; lots of size 50, 50, and 200 are used for Items C, D, and E, respectively. Items C, E, and F have on-hand (beginning) inventories of 10, 50, and 150 respectively; all other items have zero beginning inventory. We are scheduled to receive 10 units of A in Week 2, 50 units of E in Week 1, and also 50 units of F in Week 1. There are no other scheduled receipts. If 30 units of A are required in Week 8, use the low-leve-coded bill of materials to find the necessary planned order Insert your formula in these blue cells. Period: 21 3 4 5 6 7 8 9 10 Remember that all Item: A Gross requirements 30 formulas begin with : 0 Scheduled receipts LT: 2 Projected available balance SSO Net requirements Q: L4L Planned order receipts Planned order releases OH: on-hand, LT: Lead time, SS: safty stock, Q: Lot sizing Item: C Gross requirements OH:10 Scheduled receipts LT:1 Projected available balance SS:O Net requirements Q: 50 Planned order receipts Planned order releases 1 B/31 2 E 21 EIZI E21 021 3 4 Item: B OH:10 LT: 1 SS:10 Q:L4L Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases Item: B OH:10 LT: 1 SS: 0 Q:L4L Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases Item: D : 0 LT:2 SS: 0 Q: 50 Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases Item: E OH:50 LT: 1 SS: 0 Q: 200 Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases Item: F OH:150 LT: 1 SS: 0 Q: L4L Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases