produced and minimum inventories of 4 units to be kept for the planning
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
Question 3. Product Structure and MRP Processing
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.
Develop product structure tree for Bicycle.