Need help on the last two sections and how to calculate, thank you!

Each unit of A is composed of one unit of B, two units of C, and one unit of D. C is composed of two units of D and three units of E.Items A, C, D, and have on-hand inventories of 20, 10, 20, and 15 units, respectively. Item B has a scheduled receipt of 10 units in Period 1, and C has a scheduled receipt of 50 units in Period 1. Lot-for-lot (L4L) is used for Items A and B. Item requires a minimum lot size of 50 units. D and E are required to be purchased in multiples of 95 and 55, respectively. Lead times are one period for Items A, B, and C, and two periods for Items D and E. The gross requirements for A are 30 in Period 2, 30 in Period 5, and 40 in Period 8. Find the planned order releases for all items. (Leave no cells blank - be certain to enter "0" wherever required.) 2 3 5. A 30 0 0 30 0 0 40 0 0 0 0 0 0 0 0 Period Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases 0 C 0 Item A OH - 20 LT = 1 SS= Q = L4L 0 0 0 20 0 0 10 0 0 0 40 10 10 0 30 30 0 0 D 30 0 0 0 D 40 0 0 0 40 0 10 D 30 0 40 10 0 0 0 0 0 0 D 0 0 0 0 D 0 Item B OH = 0 LT = 1 SSD Q-L4L Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases 0 0 0 0 0 40 0 30 30 0 40 0 0 D 30 0 0 40 0 0 0 0 60 0 0 80 0 20 50 D 0 0 0 0 0 0 40 40 30 30 0 Item C OH = 10 LT = 1 SS = 0 Q = 50 Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Plannod order releases 30 0 0 50 0 20 0 0 0 0 0 D 0 0 50 0 0 0 50 D 50 0 0 50 0 50 0 0 0 50 0 60 0 0 60 Item D OH = 20 LT = 2 SS=0 Q = 95 0 20 D Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases 150 0 60 130 0 0 50 20 0 0 0 20 0 0 190 200 0 50 140 190 0 0 0 0 190 0 0 0 0 0 0 190 0 0 D 0 0 0 160 0 40 50 0 0 0 20 15 15 Item E OH = 15 LT = 2 SS=0 Q = 55 Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases 0 25 0 D 110 0 25 0 0 120 0 15 95 110 0 0 15 0 0 0 0 0 0 20 145 165 0 0 0 165 0 0 0 0