Please show how to solve this for part S-Z using excel and showing formulas.

Problem 14.8 Question Help The demand for subassembly S is 100 units in week 7. Each unit of S requires 2 units of Tand 1 unit of U. Each unit of T requires 2 units of V, 2 units of W, and 1 unit of X. Finally, each unit of U requires 2 units of Y and 3 units of Z One firm manufactures all items. It takes 2 weeks to make S, 2 weeks to make T, 2 weeks to make U, 2 weeks to make V, 2 weeks to make W, 1 week to make X2 weeks to make Y, and 2 weeks to make Z. la Click the icon to view the product structure and the time-phased product structure. In addition to 100 units of S, there is also a demand for 20 units of U, which is a component of S. The 20 units of U are needed for maintenance purposes. These units are needed in week 6. Modify the gross material requirements plan to reflect this change (type O if the input box is not used). Week Lead Time 4 (weeks) Gross reg Order release Item 1 2 3 5 6 7 S 2 Enter your answer in the edit fields and then click Check Answet ctivate Windows Go to Settings ops: Clear All Check Answer remaining 7 parts