Please solve it in Excel with formulas showing.

The previously provided answer is not correct.

The demand for subassembly S is 100 units in week 7. Each unit of S requires 1 unit of T and 2 units of U. Each unit of requires 1 unit of V,2 units of W, and 1 unit of X. Finally, each init of U requires 2 units of Y and 3 units of Z. One firm manufactures all items. It takes 2 weeks to make S,1 week to make T, 2 weeks to make U,2 weeks to make V,3 weeks to make W,1 week make X,2 weeks to make Y, and 1 week to make Z. ) Construct a product structure. Identify all levels, parents, and components. ) Prepare a time-phased product structure