develop MRP matrix

Exercise 3: Products A and B are made according to the bill of materials diagram shown below. Scheduled quantities of the end products are, for A. 95 units in week 4, 150 units in week 6, and 130 units in week 8, and for B, 80 units in week 3, 70 units in week 6. Lead- times: A-2 weeks, B-1 week B (c(2) D(2) E(2) D(2) The table below shows additional data for the items C, D, and E. D *I E Lot size 250 800 L4L Lead-time 2 1 3 Beginning inventory 625 350 85 Scheduled receipts none none 200 week 2 Exercise 4