My Yahoo Mail Google Mail-Say Google Drive Problem 9-12 One unit of Ais made of three units of B, one unit of C, and two units of D. Bis composed of two units of E and one unit of D. is made of one unit of B and two units of E. Els made of one unit of F Items B, C, E, and F have one week lead times: A and have load times of two weeks Assume that lot-for-lot (L4L) lot sizing is used for items AB, and lots of size 50, 50, and 200 are used for items C, D, and respectively. Items C, E, and F have on-hand (beginning) inventories of 10, 50, and 150, respectively, all other items have zero beginning inventory. We are scheduled to receive 10 units of A in Week 2, 50 units of E in Week 1, and also 50 units of F in Week 1. There are no other scheduled receipts. If 30 units of A are required in Week 8, use the low-level-coded bil-of-materials to find the necessary planned order releases for all components. One unt of Als made of three units of one unit orc, and twento. composed of two units ofE and one intor D. Cade of one unitor and two uns E Els made of one unit off. tems, C, E, and he new lead times and have admes of the we Assume that it-tor-1 (L4L) la atzing is used for Hem AB, and lots of size 50, 50, and 200 are used for Terms C, D, and respectively Meme C, E, and have on-hand (beginning) mentories of 10,50 and 150, respect Weet use the low-coded-of-waterials to the the necessary planned order released for all components Develop an MFP planning schedule thowing grous and met requirements and order release and order receipt dates. (Louve now be cortanto enter where required) 7 0 0 o 0 O 0 Period Gross requirements Scheduled recepti Projected table balance Net requirements Panned order receipts Planned order releases 0 10 0 100 10 o 10 10 em A OH - LT-2 SS=0 Q-L4L 10 10 1910 OTRO ooooo 0 O 20 O 20 10 10 10 40 Item C OH - 10 LT-1 SS=0 Q-50 Gross requirements Scheduled receipts Projected are balance Net requirements Pamed order recipes Planned order releases olol lol OOOOOO 0 0 0 0 0 0 0 0 0 0 30 0 60 0 0 OH-0 LT-1 SS- Q-LAL Gross requirements Scheduled recept Projected wallabie balance Net requirements Punned order receipts Panned order releases 0 50 0 0 30 50 OO OOOOOO OOOOO 0 50 10 o 0 0 Item D OH- LT-2 S5-0 Q-50 Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases 50 0 0 50 50 o 00 0 40 0 00 OO 0 0 0. 0 O 0 0 0 OO 00 OOOOOO 0 50 100 100 0 0 0 220 0 180 130 0 0 100 0 0 0 0 tem OH - 50 LT-1 SS- Q-200 Gross requirements Scheduled receipts Projected available atance Net requirements Planned order receipts Planned order releases 0 0 100 00 0 0 220 0 Oo 180 0 02 0 lololololo OOOO 0 100 400 0 0 OOOOOOOOOOO 400 0. 0 0 0 em F OH - 150 LT-1 55-0 Q-L4L Gross requirements Scheduled receipts Projected valable balance Net requirements Panned order receipts Panned order releases 00 50 200 0. 00 0 00 00 200 0 0 0 0 0 0 200 0. 0 0 0 0 0 Oo 200 200 0 0 0 00 0 0 0