Please use the same chart format in the answer, thanks!

Problem 21-15 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 lot sizing is used for Items C, E, and F; lots of size 18, 45, and 165 are used for Items A, B, and D, respectively. Items A, B, D, and E have on-hand (beginning) inventories of 5, 15, 123, 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, 45 units of F in Week 5, and 65 units of E in Week 2; there are no other scheduled receipts. If 18 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 "O" wherever required.) 1 2 3 4 5 6 7 8 9 10 Item A OH = 5 LT = 2 SS = 0 Q = 20 Item C Period 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 Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts OH = 0 LT = 1 SS = 0 Q = L4L Item B OH = 10 LT = 2 SS = 0 Q = 40 Planned order releases Item D OH = 100 LT = 3 SS = 0 Q = 160 Item F OH = 0 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 Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases LT = 2 SS = 0 Q = L4L Item E OH = 100 LT = 2 SS = 0 Q = L4L