Please use the same chart format, thanks!

Problem 21-17 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 10, 10, 40, and 20 units, respectively. Item B has a scheduled receipt of 20 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 C requires a minimum lot size of 75 units. D and E are required to be purchased in multiples of 140 and 80, 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.) Period 1 2 3 4 5 6 7 8 Item A Gross requirements Scheduled receipts Projected available balance Net requirements OH = 10 LT = 1 SS = 0 Planned order receipts Q = L4L Planned order releases Gross requirements Item B Scheduled receipts OH = 0 LT = 1 Projected available balance Net requirements Planned order receipts SS = 0 Q = L4L Planned order releases Gross requirements Item C Scheduled receipts OH = 10 LT = 1 Projected available balance Net requirements Planned order receipts SS = 0 Q = 50 Planned order releases Item D OH = 40 LT = 2 SS = 0 Q = 100 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 Item E OH = 20 LT = 2 SS = 0 Q = 50 Planned order releases