Use excel step by step

6. Given the following product structure diagram, complete the MRP records for parts A, B, and C. A Week 1 2 3 4 Part B 5 6 32 B (2 required) Gross requirements Scheduled receipts Projected available balance Planned order release 20 Q=40; LT = 2; SS=0. Week Week 1 2 6 3 Part C 5 1 2 3 4 5 4 6 5 15 18 00 8 12 22 Part A Gross requirements Scheduled receipts Projected available balance Planned order release Gross requirements Scheduled receipts Projected available balance Planned order release 21 70 Q=20; LT = 1; SS=0. Q=LFL;LT=1: SS = 10