pleas i need the answer for this

this module is introduction to manifacturing systmes

Q9. The Bill of Material (BOM) for a truck rear axle assembly is shown in Figure 3. The number beside the box indicates the quantity of parts required for each parent. For example "Suspension assembly [2x]" means 2 suspension sub-assemblies are required to build each axle assembly. Table 1 shows the lead time, stock on hand and scheduled receipts. Table 2 shows the Master Production Schedule (MPS) for axle assemblies. Complete the attached MRP solution sheet and construct a Material Requirements Plan for brake assemblies. [20 marks] Axle Assembly Differential Suspension sub-assembly X2 Wheel sub-assembly X2 X1 Spring MIO nut MIO bolt wheel Shock absorber Brake assembly Wheel bolt XI X4 X4 XI X1 XI X1 XS Figure 3 : Bill of Materials 1004 Items Axle Assembly Suspension sub-assembly Differential Wheel sub-assembly Spring Shock absorber Wheel Tyre Brake assembly Wheel bolt Lead Time Weekl 1 1 2 1 2 3 2 1 3 1 Stock Lot Scheduled On-hand Size Receipts 300 600 SOO 500 800 800 1200 2000 300 600 1200 1400 350 2000 250 4000 3100 3000 3000 in week 3 2500 5000 Table Lead time. Onhand Balance and scheduled Receipts Week 2 3 4 5 6 9 10 Quantity 1000000 40000 20000 6000 600 Table 2 Meder Production Schedule (MPS) for Axle Assemblies Weeks 5 6 1 2 3 4 7 8 9 10 Gross Requirements (GR) Scheduled Receipts (SR) Stock On Hand (SOH) Net Requirements (NR) Planned Order Receipt Planned Order Release Weeks 5 6 1 2 3 7 8 9 10 Gross Requirements (GR) Scheduled Receipts (SR) Stock On Hand (SOH) Net Requirements (NR) Planned Order Receipt Planned Order Release 1 2 Weeks 5 6 2 3 4 7 8 9 10 Gross Requirements (GR) Scheduled Receipts (SR) Stock On Hand (SOH) Net Requirements (NR) Planned Order Receipt Planned Order Release