Q5 M/S Al Mawela Company manufactures Sports Bike and supplies to the local market. A local sub-contracting company manufactures and supplies wheels to the M/S Al Mawela 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, 18 spokes and a front hub. Rear wheels comprise a rear rim, 24 spokes and a rear hub 3Marks (i)Draw the Bill of Material (BOM) tree for the front and rear wheels (ii) Complete the Material Requirements Planning (MRP) and determine when to 22Marks Purchase Orders placed for the spokes Week 15 16 17 18 Demand for 110 80 90 90 90 120 the bikes Demand of 40 30 40 50 40 40 Front Rim Demand of 70 60 60 70 60 70 Rear Rim Table Q5 (i) Lead Time Stock on Hand Batch SizeSafety Stock 180 Bike 90 140 110 Front wheel 120 130 100 160 Rear wheel 130 Front Rim 2 190 90 160 Front Hub 90 40 110 110 Rear Rim 2 210 Rear Hub 140 110 50 11000 5000 1300 Spokes Table Q5 (ii) Marking Rubrics Bill of Material Tree - 3 Marks, Bike -2Marks, Front Wheel-2 Marks Front Rim 3Marks, Front Hub 2Marks, Rear Wheel - 2Marks, Rear Rinm - 3Marks, Rear Hub -2Marks and Spokes-4 Marks Q5 M/S Al Mawela Company manufactures Sports Bike and supplies to the local market. A local sub-contracting company manufactures and supplies wheels to the M/S Al Mawela 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, 18 spokes and a front hub. Rear wheels comprise a rear rim, 24 spokes and a rear hub 3Marks (i)Draw the Bill of Material (BOM) tree for the front and rear wheels (ii) Complete the Material Requirements Planning (MRP) and determine when to 22Marks Purchase Orders placed for the spokes Week 15 16 17 18 Demand for 110 80 90 90 90 120 the bikes Demand of 40 30 40 50 40 40 Front Rim Demand of 70 60 60 70 60 70 Rear Rim Table Q5 (i) Lead Time Stock on Hand Batch SizeSafety Stock 180 Bike 90 140 110 Front wheel 120 130 100 160 Rear wheel 130 Front Rim 2 190 90 160 Front Hub 90 40 110 110 Rear Rim 2 210 Rear Hub 140 110 50 11000 5000 1300 Spokes Table Q5 (ii) Marking Rubrics Bill of Material Tree - 3 Marks, Bike -2Marks, Front Wheel-2 Marks Front Rim 3Marks, Front Hub 2Marks, Rear Wheel - 2Marks, Rear Rinm - 3Marks, Rear Hub -2Marks and Spokes-4 Marks