One unit of A is composed of two units of B and three units ofC. Each B is composed of one unit of F. C is made of one unit of D,one unit of E, and two units of F. Items A, B, C, and D have 15,40, 36, and 25 units of on-hand inventory, respectively. Items A,B, and C use lot-for-lot (L4L) as their lot-sizing technique, whileD, E, and F require multiples of 62, 100, and 90, respectively, tobe purchased. B has scheduled receipts of 15 units in Period 1. Noother scheduled receipts exist. Lead times are one period for ItemsA, B, and D, and two periods for Items C, E, and F. Grossrequirements for A are 15 units in Period 1, 12 units in Period 2,50 units in Period 6, and 50 units in Period 8. Find the plannedorder releases for all items. (Leave no cells blank - be certain toenter "0" wherever required.) Period 1 2 3 4 5 6 7 8 Item A OH = 15LT = 1 SS = 0 Q = L4L Gross requirements Scheduled receiptsProjected available balance Net requirements Planned order receiptsPlanned order releases Item B OH = 40 LT = 1 SS = 0 Q = L4L Grossrequirements Scheduled receipts Projected available balance Netrequirements Planned order receipts Planned order releases Item COH = 36 LT = 2 SS = 0 Q = L4L Gross requirements Scheduled receiptsProjected available balance Net requirements Planned order receiptsPlanned order releases Item D OH = 25 LT = 1 SS = 0 Q = 62 Grossrequirements Scheduled receipts Projected available balance Netrequirements Planned order receipts Planned order releases Item EOH = 0 LT = 2 SS = 0 Q = 100 Gross requirements Scheduled receiptsProjected available balance Net requirements Planned order receiptsPlanned order releases Item F OH = 0 LT = 2 SS = 0 Q = 90 Grossrequirements Scheduled receipts Projected available balance Netrequirements Planned order receipts Planned order releases