can you please solve this question clearly and carefully and in a paper not excel sheet.

Q5 (12 pts): The BOMS for products A is shown in Figure 2, and data from the Inventory records are shown in Table 2. The MPS start row for product A calls for 500 units in week 6. The lead time for production of A is two weeks. Develop the material requirements plan for the next 6 weeks for items B, C, and D. (show sample calculations) Table 2 Data category Lot-sizing rule L4L FOQ-2,000 1 weeks Leading time 3 weeks Safety stock 0 Scheduled receipts Non 2,000 (week 1) Beginning inventory 0 200 Figure 2 A D(1) C(1) D(2) LAL 1 weeks 0 Non 0 B(2) C(1) D(2)