Given the BOM and the MPS for end item A, complete the MRP schedule for items A, C, D, and E. (Leave no cells blank - be certain to enter "O" wherever required.) 1 week B (1) 3 weeks C(4) 1 week D (2) 2 weeks E (2) 1 week F(6) 2 weeks E (5) 1 week G (4) 1 week H(1) 3 weeks MPS 3 4 6 8 Item A 1 40 2 25 uw 5 110 7 90 55 135 60 40 pictureClick here for the Excel Data File Item A D. L4L Lot size rule Safety stock Beginning inventory Week 1 scheduled receipts L4L 0 0 L4L 0 0 E Multiples FOQ = 500 100 310 0 40 100 50 2,000 Part Name: A Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Week 7 Week 8 MRP Record Lead time = 1 week On hand = 0 Safety stock = 0 Order quantity: L4L Gross requirements Scheduled receipts Available inventory Net requirements Planned order receipts Planned order releases 40 0 0 0 0 0 0 0 Part Name: C Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Week 7 Week 8 MRP Record Lead time = 1 week On hand = 0 Safety stock = 0 Order quantity: L4L Gross requirements Scheduled receipts Available inventory Net requirements Planned order receipts Planned order releases 100 0 0 0 0 0 0 0 Part Name: D Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Week 7 Week 8 MRP Record Lead time = 2 week On hand = 0 Safety stock = 0 Order quantity: L4L Gross requirements Scheduled receipts Available inventory Net requirements Planned order receipts Planned order releases 50 110 0 0 0 0 0 0 MRP Record Part Name: E Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Week 7 Week 8 Lead time = 2 week On hand = 310 Safety stock = 100 Order quantity: Multiples FOQ = 500 Gross requirements Scheduled receipts Available inventory Net requirements Planned order receipts Planned order releases 2,000 0 0 0 0 0 0 0