One unit of A is composed of two units of B and three units of C. 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. Items A, B, and C use lot-for-lot (L4L) as their lot-sizing technique, while D, E, and F require multiples of 62, 120, and 90, respectively, to be purchased. B has scheduled receipts of 15 units in Period 1. No other scheduled receipts exist. Lead times are one period for Items A, B, and D, and two periods for Items C, E, and F. Gross requirements 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 planned order releases for all items. (Leave no cells blank - be certain to enter "0" wherever required.) Period 1 2 3 4 5 6 7 8 Gross requirements 15 12 0 0 0 50 0 50 Item A Scheduled receipts 0 0 0 0 0 0 0 0 OH = 15 Projected available balance 0 0 0 0 0 0 0 0 LT = 1 Net requirements 0 12 0 0 0 50 0 50 SS = 0 Planned order receipts 0 12 0 0 0 50 0 50 Q = L4L Planned order releases 12 0 0 0 50 0 50 0 Gross requirements 24 0 0 0 100 0 100 0 Item B Scheduled receipts 15 0 0 0 0 0 0 OH = 40 Projected available balance 31 31 31 31 0 0 0 LT = 1 Net requirements 0 0 0 0 69 0 100 0 |SS=0 Planned order receipts 0 0 0 0 69 0 100 0 Q = L4L Planned order releases 0 0 0 69 100 0 0 Gross requirements 36 0 0 0 150 0 150 0 Item C Scheduled receipts 0 0 0 0 0 0 0 0 OH = 36 Projected available balance 0 0 0 0 0 0 0 0 LT=2 Net requirements 0 0 0 150 0 150 0 Dlanned order rocointe n n n 150 150 n Gross requirements 36 0 0 0 150 0 150 0 Item C | OH = 36 LT = 2 Scheduled receipts 0 0 0 0 0 0 0 0 Projected available balance 0 0 0 0 0 0 0 Net requirements 0 0 0 150 0150 0 SS = 0 Planned order receipts 0 0 0 150 0150 0 Q = L4L Planned order releases 0 0 150 0 150 0 0 0 Gross requirements 0 150 0 150 0 0 0 Item D OH = 25 |LT = 1 |SS=0 Scheduled receipts Projected available balance Net requirements 0 0 0 0 0 0 0 0 25 25 25 25 0 125 Planned order receipts 0 0 OO 0 0 0 0 0 0 0 0 Q = 62 Planned order releases 0 0 0 0 0 0 Gross requirements 0 150 0 150 0 0 0 Item E Scheduled receipts 0 0 0 0 0 0 0 0 | OH = 0 Projected available balance 0 0 LT = 2 Net requirements 0 0 150 0 0 0 0 SS = 0 Planned order receipts 0 0 0 0 0 Q = 120 Planned order releases 0 0 0 0 0 0 Gross requirements 0 300 69 300 100 0 0 Item F Scheduled receipts 0 0 0 0 0 0 0 0 | OH = 0 Projected available balance 0 0 60 60 81 51 41 41 41 LT=2 SS=0 Net requirements 0 0 300 9 219 49 0 0 Planned order receipts 0 0 360 90 270 90 90 0 0 Q = 90 Planned order releases 360 90 90 270 90 0 0 0 0