C Problem 14-14 (Algo) 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.) A 1 week B (1) 3 weeks C (1) 1 week D (2) 2 weeks E (3) 1 week F (6) 2 weeks E (2) 1 week G (4) 1 week H(1) 3 weeks 9 MPS Item A 1 55 2 25 3 35 4 140 5 85 6 70 7 75 8 50 Book EpictureClick here for the Excel Data File Tint Item A D rences L4L LAL L4L Lot size rule Safety stock Beginning inventory Week 1 scheduled receipts Multiples FOQ - 400 120 300 800 55 0 25 8 50 14 Assignment Saved H. Part Name: A Week 2 Week 3 Week 1 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 0 0 55 0 0 0 0 ces