develop MRP matrix

develop mrp matrix

the first is wrong so pls dont mind it, iam asking for second pic, thanksss

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. Production Management Develop an MRP for product A and with the product structures (BOM) given below. What should be the size of the orders for each item, and when should orders released? Level End item A L=4 End item L=2 Level 1 B (1) L = 3 C(2) L=2 E(1) L=1 C(1) L=2 Level 2 D (1) L = 1 E (2) L-1 D (1) L=1 E (2) L=1 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 A B C(2) D(2) E(2) (D(2) D D D The table below shows additional data for the items C, D, and E. I D E Lot size 250 800 L4L Lead-time 2 1 3 Beginning inventory 625 350 85 Scheduled receipts none none 200 week 2