amework Saved Help Save & E Problem 14-14 (Algo) Check 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 "0" wherever required.) 1 week B (1) 3 weeks C (1) 1 week D (2) 2 weeks E (2) 1 week F(6) 2 weeks E (4) 1 week G (4) 1 week H(1) 3 weeks MPS Ite 2 30 3 55 6 45 35 30 100 50 135 Icem 50 2. 30 3 55 4 135 5 100 6 45 7 70 8 35 pictureClick here for the Excel Data File Item A D Lot size rule Safety stock Beginning inventory Week 1 scheduled receipts L4L 0 0 L4L 0 0 30 L4L 0 0 Multiples FOO - 600 110 310 1,200 1 50 60 nces Part Name: A Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Week Weeks MRP Record Lead time 1 week On hand = 0 Safety stock Order quantity: L4L Gross requirements Scheduled receipts Available inventory Net requirements Planned order receipts Planned order releases 50 0 0 0 0 0 0 W Part Name: Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Woek 7 Weak a 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 30 0 0 0 0 0 0 Part Name: D Week 5 Week 6 Week 4 Week 7 Wook a Week 1 Week 2 Week 3 0 0 0 0 MRP Record Load time = 2 week On hando Safety stock - 0 Order quantity: L4L Gross requirements Scheduled receipts Available inventory Net requirements Planned order receipts Planned order releases 60 110 Part Name: E Week 1 Week 2 Week 3 Wook 4 Week 5 Week 6 Wook Week 8 MRP Record Lead time = 2 week On hand. 310 Safety stock = 110 Order quantity: Multiples FOQ = 600 Gross requirements Scheduled receipts Available inventory Net requirements Planned order receipts Planned order releases 1.200 0 0 0 0 0 0 0