This is a supply chain management question

5. The final product A is made by a manufacturer based on the information summarized in Table 2. To meet customer requirements, the manufacturer needs to deliver 50 units of product at the start of week 8. There are 10 units of A item, 15 units of B item, 20 units of C item, 10 units of D item, 10 units of E item, and 5 units of F units on hand. In addition, 10 units of G item will be arrived in week 4, i.e., the scheduled receipts. Please develop the material requirements planning forms for items B, C, D, E, F, and G using the lot-for-lot technique. (9 marks) Table 2. The product information Components Lead Time (weeks) Sub-Components (no. of units) A 1 B(2), C(3) B 2 D(2), E(1), G(2) E(3), F(2) 1 D 3 E 2 F 3 G(1), D(2) G 2