The demand fo subassembly is S is 100 units i week 7. Each unite of S requires

The demand fo subassembly is S is 100 units i week 7. Each unite of S requires 1 uit o T and 2 units of U. Each uit of T requires 1 uit of V 2 units of W and
1 uit of X. Finally each unit ofof u requires 2 units of y and 3 units of Z. One firm anufactures all ites. IT taks 2 wees to make v. 3 weeks to make w . 1 wee
to make x 2 weeks to make y and 1 wee to ake Z.

A. construct a product structure identify all level parent and componets (Please do in excel and show work)( do i excel om if possible)

B. Prepare a time phased product stucture ( do both i excel OM if possible and show work)