Items B, C, E, and F have one- week lead times, A and Dhave lead times of two weeks. Assume that lot-for-lot (L4L) lot sizing is used for Items A, B, and Filots of size 45, 45, and 175 are used for Items CD and E, respectively, Items C, E, and F have on-hand (beginning) inventories of 10, 50, and 140, respectively, all other items have zero beginning inventory. We are scheduled to receive 12 units of A in Week 2.40 units of Ein Week 1, and also 50 units of Fin Week 1 There are no other scheduled receipts. If 30 units of A are required in Week 8 use the low-level-coded bill of materials to find the necessary planned-order releases for all components Develop an MRP planning schedule showing gross and net requirements and order release and order receipt dates. (Leave the cells blank, whenever zero (0) is required.) ok mit tes 0 0 O 0 0 0 0 0 0 0 0 0 0 Item: OH: 0 LT: 1 SS: OLAL 0 Gross requirements Scheduled receipts Projected available balance Net requirements Plarved order receipts Planned order releases 0 0 0 0 o1 0 0 ol 0 0 0 0 0 tom:D OHO LT:2 SS: D: 45 Gross requirements Scheduled receipts Projected avatable balance Not requirements Planned order receipts Planned order releases 0 0 0 o 0 0 ol 0 0 o 0 0 ol o 0 ol 0 0 D D 0 0 0 0 0 0 TE OH:50 LT: 55:0 Q.175 Groquirements Scheduled recept Projected available balance Notremonto Pinned bedor Foco Pland order toloses O 0 of o 0 0 0 of 0 0 0 D 0 O 0 O ol a O 100 Quement Hent chebuled receipt 140 Projector available banco LTI Nem Q: LC Plan de Panned orders O 0 o