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.