develop MRP matrix

Exercise 4: There are for 103 units of product A in period 8 and 200 units of product Q in period 7. The on hand inventory levels for each item are A = 18, Q =6, B = 10, C = 20, D = 0 and E = 30. A safety stock of five units is maintained on product A and six on units of product with no safety stock on other components. Additionally, ten units of 18 units on hand of product A are already allocated to particular customers. There are no open orders (scheduled receipts) on any item. The lot size for items A.Q. B. and C is the same as the net requirements (lot-for-lot ordering), while the lot size for D is 200 units and for E is 500 units. I Develop an MRP for product A and Q 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() L=2 E (1) L=1 C(1) L-2 Level 2 D(1) L=1 E (2) D() L=1 L=1 E (2) L=1