How do I solve this problem on Excel or Sheets

Problem02: Use the following product structure tree to develop the MRP plan for the components A and B. Finished product X will be shipped 110 quantities at the start of week 6 and 100 quantity at the start the week 7 . One case of A (50 units in one case) is scheduled at week 4,5,6,7 and One case of B ( 30 units in one case) is scheduled at week 5, 6 . There are 30 units of A and 10 units of B now on hand. Lead time for all the components is one week