Homework Help is Here – Start Your Trial Now!
Business
Operations Management
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. (1) Draw the Bill of Material (BOM) tree for the front and rear wheels. (ii) Referring to table 4(i) and 4(i), complete the Material Requirements Planning (MRP) and determine when to Purchase Orders placed for the spokes. Table 4 (i) 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 The demand of Rear Rim 70 60 80 Table 4 (ii) Part/Component Lead Time Stock on Hand Batch Size Safety Stock Bike 1 160 100 Front wheel 1 110 120 100 Rear wheel 1 80 150 125 Front Rim 2 80 150 100 Rear Rim 200 100 100 Front Hub 1 90 150 50 Rear Hub 1 130 100 50 Spokes 1 9800 3,000 1,100

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. (1) Draw the Bill of Material (BOM) tree for the front and rear wheels. (ii) Referring to table 4(i) and 4(i), complete the Material Requirements Planning (MRP) and determine when to Purchase Orders placed for the spokes. Table 4 (i) 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 The demand of Rear Rim 70 60 80 Table 4 (ii) Part/Component Lead Time Stock on Hand Batch Size Safety Stock Bike 1 160 100 Front wheel 1 110 120 100 Rear wheel 1 80 150 125 Front Rim 2 80 150 100 Rear Rim 200 100 100 Front Hub 1 90 150 50 Rear Hub 1 130 100 50 Spokes 1 9800 3,000 1,100

Practical Management Science
Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
See similar textbooks
icon
Related questions
Question
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. (i) Draw the Bill of Material (BOM) tree for the front and rear wheels. (ii) Referring to table 4(i) and 4(ii), complete the Material Requirements Planning (MRP) and determine when to Purchase Orders placed for the spokes. Table 4 (i) 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 The demand of Rear Rim 70 60 80 Table 4 (ii) Part/Component Lead Time Stock on Hand Batch Size Safety Stock Bike 1 160 100 Front wheel 1 110 120 100 Rear wheel 1 80 150 125 Front Rim 80 150 100 Rear Rim 200 100 100 Front Hub 1 90 150 50 Rear Hub 1 130 100 50 Spokes 1 9800 3,000 1,100
Transcribed Image Text: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. (i) Draw the Bill of Material (BOM) tree for the front and rear wheels. (ii) Referring to table 4(i) and 4(ii), complete the Material Requirements Planning (MRP) and determine when to Purchase Orders placed for the spokes. Table 4 (i) 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 The demand of Rear Rim 70 60 80 Table 4 (ii) Part/Component Lead Time Stock on Hand Batch Size Safety Stock Bike 1 160 100 Front wheel 1 110 120 100 Rear wheel 1 80 150 125 Front Rim 80 150 100 Rear Rim 200 100 100 Front Hub 1 90 150 50 Rear Hub 1 130 100 50 Spokes 1 9800 3,000 1,100
Expert Solution
steps

Step by step

Solved in 2 steps with 4 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.
SEE MORE TEXTBOOKS