Please help me solve this question. Tq

Question 5: Given the following product tree, develop a material requirements plan for the components. Quantities per are shown in parentheses. The following worksheet shows the present active orders, the available balances, and the lead times. A F 012) 1(2) E Table : Sales Data Low Level Code Weck 1 2 3 3 w 60 70 0 0 Part A Gross Requirements Scheduled Recipes Lead Time I week Projected Available Net Requirements Lot-for-lot Planned Order Receipt Planned Order Release Part F Grass Requirements Scheduled Receipts Lead Time: I weck Projected Available Net Requirements Lot-for-lot Planned Order Receipt Planned Order Release Part B Gross Requirements Scheduled Recipes Led Time: 2 weeks Projected Available 200 Nei Requirements Lot Size: 300 Planned Order Receipt Planned Onder Release 120 300 Parc Gross Requirements Scheduled Receipts Lead Time: 2 wecks Projected Available Net Requirements Lot Size: Lot-for- Planned Order Receipt lor Planned Order Release Part 0 Gross Requirements Scheduled Receipts Lead Time: 2 wocks Projected Available Net Requirements Lot Size: 300 Planned Order Receipe Planned Order Release Part E Gross Requirements Scheduled Receipts Lead Tume 3 weeks Projected Available 400 Net Requirements 101 Size: 500 Planned Order Receipt Planned Order Release