complete and fill in all rows and columns for each item.

One unit of A is made of two units of B and one unit of C. B is made of three units of D and one unit of F. C is composed of three units of B, one unit of D, and four units of E. D is made of one unit of E. Item C has a lead time of one week; Items A, B, E, and F have two-week lead times, and Item D has a lead time of three weeks. Lot-for-lot (L4L) lot sizing is used for Items C, E, and F; lots of size 20, 40, and 160 are used for Items A, B, and D, respectively. Items A, B, D, and E have on-hand (beginning) inventories of 5, 10, 100, and 100, respectively, all other items have zero beginning inventories. We are scheduled to receive 10 units of A in Week 3, 20 units of B in Week 7, 40 units of F in Week 5, and 60 units of E in Week 2, there are no other scheduled receipts. If 20 units of A are required in Week 10, use the low-level-coded bill-of-materials (product structure tree) to find the necessary planned order releases for all components. (Leave no cells blank - be certain to enter "0" wherever required.) 10 Item A OH = 5 LT = 2 SS = 0 Q = 20 Period Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases Item C OH = 0 LT = 1 SS = 0 Q = L4L Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases Item B OH = 10 LT = 2 SS = 0 Q = 40 Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases Item D OH = 100 LT = 3 SS = 0 Q = 160 Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Item B OH = 10 LT = 2 SS = 0 Q = 40 Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases Item D OH = 100 LT = 3 SS=0 Q = 160 Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases Item F OH = 0 LT = 2 SS=0 Q = L4L Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases Item E OH = 100 LT = 2 SS=0 Q=L4L Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases