Problem 9-11 Assume that Product is made of two of Andree units of B. As made of three units of Cand four of D. Dis made of two units of Lead times for purchase or fabrication of each unit to final assembly we takes two weeks: A, B, C, and the one week each and takes twee weeks. Soy units of Product are required in Period 10. (Assume that there is currently no invertory on hand of any of theses) b. Develop an MP planning schedule showing gross and net requirements and order release and order recept dates (Leave no cells blank.be certain to enter wherever required) Period Orosserome Scheduled recept Pred balance OH LT-2 550 QLL On Scheduled LT=1 Procedence SSD Q-LAL Planned order reces Crossrents LT-1 OHO 550 D OH-0 Parede derece CH LT3 14 Problem 9-11 Assume that Product is made of two units of A and three units of B. A is made of three units of C and four of D. Dis made of two units of E Lead times for purchase or fabrication of each unit to final assembly are: Z takes two weeks: A, B, C, and D take one week each and E takes three weeks. Sixty units of Product Z are required in Period 10. (Assume that there is currently no inventory on hand of any of these items.) b. Develop an MRP planning schedule showing gross and net requirements and order release and order receipt dates. (Leave no cells blank.be certain to enter "0" wherever required) 0 Item z OH = 0 LT = 2 SS=0 Q = L4L Period Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases 0 0 0 Item A OH = 0 LT = 1 SS=0 Q = L4L Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases Item B OH = 0 LT = 1 SS=0 Q=L4L Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases Item C OH = 0 LT = 1 SS = 0 Q = L4L Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases Item D OH = 0 LT = 1 SS = 0 Q = L4L Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases Item E OH = 0 LT = 3 SS=0 Q = L4L Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases