Use Excel to solve the problem and
submit the file through the eLearning system.
A bracket assembly requires one base,
two springs and four clamps. The base is assembled from one clamp
and two housings. Each clamp has one handle and one casting. Each
housing has two bearings and one shaft. There is no inventory in
hand. The lead times (in weeks) for these components are: bracket
1, base 1, spring 1, clamp 1, housing 2, handle 1, casting 3,
bearing 1 and shaft 1.
Construct a top-down product structure (B.O.M.) showing the
quantities for each item
Develop a time phased product structure
Determine gross quantities needed for 50 bracket assemblies.





