Problem 14-14 (Algo) Given the BOM and the MPS for end item A, complete the MRP schedule for items A, C, enter "O" wherever required.) A 1 week D (2) B (1) 3 weeks C (3) 1 week 2 weeks E (3) 1 week F(6) 2 weeks E (3) 1 week G (4) 1 week H(1) 3 weeks MPS Item A 1 40 2 30 3 50 7 85 8 40 135 85 45 Item c D Lot size rule Safety stock Beginning inventory Week 1 scheduled receipts L4L 0 0 L4L 0 0 E Multiples FOQ = 500 100 310 L4L 0 0 40 90 60 1,500 Part Name: A Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Week 7 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 40 0 0 0 0 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 90 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 01 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 hando Safety stock 0 Order quantity: L4L Gross requirements Scheduled receipts Available inventory Not requirements Planned order receipts Planned order releases 100 0 0 0 0 0 60 0 0 0 0 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 B 1,500 0 0 0 0 0 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 0