please help

1) The demand for subassembly S is 95 units in week 7. Each unit of S requires 1 unit of T and 2 units of U. Each unit of T requires 1 unit 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, 1 week to make T, 2 weeks to make U, 2 weeks to make V. 3 week to make W, 1 week to make X, 2 week to make Y. and 1 week to make Z. Item Item On Hand Inventory On-Hand Item Inventory 20 W On Hand Inventory 30 S T 20 25 U 40 Y 240 V 30 Z 40 Using the information above, a) Determine the quantity for all items required to produce 95 units b) Create a time-phase product structure c) Construct a gross material requirements plan. d) Construct a net material requirements plan using the on-hand inventory. Note: All the plans must be constructed using Microsoft Excel program 1) The demand for subassembly S is 95 units in week 7. Each unit of S requires 1 unit of T and 2 units of U. Each unit of T requires 1 unit 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, 1 week to make T, 2 weeks to make U, 2 weeks to make V. 3 week to make W, 1 week to make X, 2 week to make Y. and 1 week to make Z. Item Item On Hand Inventory On-Hand Item Inventory 20 W On Hand Inventory 30 S T 20 25 U 40 Y 240 V 30 Z 40 Using the information above, a) Determine the quantity for all items required to produce 95 units b) Create a time-phase product structure c) Construct a gross material requirements plan. d) Construct a net material requirements plan using the on-hand inventory. Note: All the plans must be constructed using Microsoft Excel program