Produced and minimum inventories of 4 units to be

This preview shows page 5 - 7 out of 7 pages.

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)

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture