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)
identify al levels parents and componentss.
using the information fro above construct a gross material requirements plan
plase show a work in excel om if possible show me how to ent3r informatio i exccel om