help me with the red cells please

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 E have on-hand inventories of 20, 10, 20, and 10 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) lot sizing is used for Items A and B. Item C requires a minimum lot size of 50 units. D and E are required to be purchased in multiples of 100 and 50, 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 "O" wherever required.) X Answer is complete but not entirely correct. 1 2 3 4 5 6 7 8 0 30 o 0 30 0 0 40 Item A 0 0 0 0 0 0 0 Period Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts OH = 20 20 0 0 0 0 0 LT = 1 0 10 0 0 30 0 0 40 SS = 0 0 10 0 30 0 0 40 Q = L4L Planned order releases 10 0 0 30 0 0 40 0 10 0 0 30 0 0 40 0 Item B 10 0 0 0 0 0 0 0 OH = 0 Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts 0 0 0 0 0 0 0 0 LT = 1 0 0 0 30 0 0 40 0 SS = 0 30 0 40 Q = L4L Planned order releases 0 0 30 0 40 0 0 20 0 0 60 0 0 800 Item C 50 0 0 0 0 0 0 0 OH = 10 Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts 40 40 40 30 30 30 LT = 1 0 0 0 20 0 0 0 | 0-81810 SS = 0 0 0 0 50 0 0 0 Q = 50 Planned order releases 0 0 50 0 0 50 0 Gross requirements 10 0 120 X 20 X 0 120 X 30 X 0 Item C 50 0 0 0 0 0 OH = 10 40 40 40 30 30 30 LT = 1 0 0 20 0 0 ooooo 0|0181810-31 SS = 0 0 0 0 50 0 0 Q = 50 0 0 50 0 0 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 50 10 0 120 X 20 X 0 120 X 30 X 0 Item D 0 0 0 0 0 0 0 0 OH = 20 10 10 10 110 x 110 x 110 X 80 X 80 x LT = 2 0 0 120 X 10 X 0 10 X 0 SS = 0 0 0 120 X 120 X 0 120 X 0 oooo Q = 100 Planned order releases 120 X 120 X 0 120 X 0 0 0 0 0 180 X 0 0 180 X 0 Item E 0 0 0 0 0 0 0 0 OH = 10 Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts 30 40 X 40 X 40 X 40 X 40 X 40 X 40 X LT = 2 0 0 140 0 0 140 0 0 SS = 0 0 0 140 x 0 0 140 X 0 Oo Q = 50 Planned order releases 140 x 0 0 140 0 0 0