produced and minimum inventories of 4 units to be kept for the planning
period.
Complete Table 2 to generate the MPS for the given product.
Double click on the table to open it in Excel file and to complete it
(No need to show the calculations or formulas in Excel or Word
Document.)
Question 3. Product Structure and MRP Processing
13 Marks
Consider the following information regarding a bicycle (e.g., Road Bike). Each
finished bicycle requires 1 set of handlebars, 1 frame assembly, and 1 seat.
In turn, 1 frame assembly requires 2 wheels and 1 frame. At the next level, 1
wheel is produced from 12 spokes and 1 tire rim, and 1 frame requires 5 feet
of aluminum tubing and 1 gallon of paint.
1.
Develop product structure tree for Bicycle.
(2 Marks)

Introduction to Operations Management COMM 205 (Winter 2019)
2.
How many spokes are required to manufacturer 20 Bicycles; given that
you already have
10 finished frame assemblies on hand.
(1 mark)

3.
Complete the MRP tables below based on the given constraints.
(10 marks)
Double click on the table to open it in Excel file and to complete it
(No need to show the calculations or formulas in Excel or Word
Document.)

Introduction to Operations Management COMM 205 (Winter 2019)