thanks for the help

Problem 14-14 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 (4) 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 Item A: 1 60 2 20 3 50 4 120 5 100 6 50 7 80 8 40 A L4L 0 L4L item Lot size rule Safely stock Beginning inventory D L4L E Multiples FOQ = 500 100 300 0 0 0 0 Part Name Week 1 Week 2 Week 3 Week Week 5 Week Week Week 8 MRP Record Lead time 1 week On hand- Safety stock - 0 Order Quantity: 141 Grass requirements Scheduled receipts Available inventory Net requirements Planned order receipts Planned order releases 60 D 0 0 0 0 Part Name Week 1 Week 2 Weeks Wook Week 5 Week 6 Week Week 8 MRP Record Lead time 1 week On-hand = 0 Safety stock=0 Order quantity: 141 Gross requirements Scheduled receipts Available inventory Net requirements Planned order receipts Planned order releases 80 D D o 0 0 0 Part Name:D Week 1 Week 2 Week 3 Week 4 Weeks Week 6 Week 2 Week 8 MRP Record Lead time - 2 weeks On hand Safely stock = 0 Order quantity: LAL Gross requirements Scheduled recopis Avalable inventory Net requirements Plantiod order receipts Planned order releases 60 100 29 0 DO 0 Part Name! E Week 1 Week 2 Weeks Week 4 Week 5 Week 6 Week 7 Week 8 MRP Record Lead time - 1 week On hand - 300 Safety stock - 100 Order quantity: Multiples FOQ-500 Gross requirements Scheduled receipts Available inventory Net requirements Planned order receipts Planned order releases 500 0 0 0 0 0 0 P