P D E F G H I J K L M N O Problem 2. One unt of Ais made of three units of B, one unit of C, and two units of D. B is composed of two units of E and one unit of D. C is made of one unit of B and two units of E E is made of one unit of F. Item B, C, E, and F have one-week load times; A and have load times of two weeks. Assume that fol-for- Ot (L4L) fotstring is used for items A, B, and lots of size 50, 50, and 200 are used for Items, and Ecospoctively. Itom C, E, and Fhave on hand (beginning) inventories of 10,50 and 150 respectively, all other some have zero beginning inventory Wo are schoduled to receive 10 units of Ain Wook 2,50 units of Ein Week 1 and also 60 units of Fin Week 1. There are no other scheduled receipts. 30 units of A are required in Week 8, use the low level.coded 6 bill of materials to find the necesLlanned order releases for all components Insert your formula in these blue cells Remember that all formulas begin with a 5 7 10 Level BI 30 0 Period 10 m A Grosseguirements OHO Sched receipt LT: 2 Proiected balance SSO Netruments QUAL Panned or erroca Planned order to 16 Okkond Skoda c Grosseguirements OH 10 SA LT: Riglected available bilance SO Neement 21 0:56 Pandora recept 22 Planned order 23 24 B Grosseguirements OHO Schedad recipes 26 LE Preached available dance 27 SO Net requirements 3 NAARSREERRRRRRRRRRRE F + Parned order 30 21 D OHIO Giormes Scheedfecept Red valabilance Norman Parador der receipts Parved order 05 34 35 35 37 JE OH 50 LT: SS10 c. 200 Grosirements Sched recept Proiected available once Neregements Plan order to Planned order to 41 DUDU OH 150 LT: 550 Q: Googuirments Schede Projected available once Netrecuirements Planned order receipts Planned orders 49 SO