solve it by hand please with full steps.

Q4: M/S XYZ Company Manufactures Sports bikes and supplies them to the local market. A local sub-contracting manufacturer supplies the wheels to the M/S XYZ Company through a purchase contract. The sub-contracting company initially purchases aluminium billets as raw material and manufactures wheels by forming each billet into wheel rims. Both the rims (front and rear) are assembled with spokes, front and rear hubs. Front wheels comprise a front rim, 24 spokes and a front hub Rear wheels comprise a rear rim, 24 spokes and a rear hub. Draw the Bill of Material (BOM) tree for the front and rear wheels. [4 Marks) Referring to table 40) and 4(ii), complete the Material Requirements Planning (MRP) and determine when to Purchase Orders placed for the spokes [26 Marks) Table 4 (1) Week 12 13 14 15 16 17 Demand for the bikes 80 70 90 120 100 85 Demand of Front Rim 50 40 30 125 70 60 The demand of Rear Rim 80 Part/Component Lead Time Stock on Hand Batch Size Safety Stock Bike 1 160 100 0 1 120 Front wheel Rear wheel 120 60 100 125 1 150 Front Rim 2 70 150 100 2 170 100 Rear Rim Front Hub Rear Hub 100 50 1 80 150 100 1 140 50 Spokes 1 8500 3,000 1,100 Table 4 (ii)