14.3 The demand for subassembly S is 100 units in week 7. Each unit of S requi

    0

    14.3 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 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 weeks to make W 1 week to make X 2 weeks to make Y and 1 week to make Z.

    a) Construct a product structure. Identify all levels parents and
    components.
    b) Prepare a time-phased product structure.

    14.4 Using the information in Problem 14.3 construct a gross material requirements plan.

    14.5 Using the information in Problem 14.3 construct a net material requirements plan using the following on-hand inventory.

    Item On-Hand Inventory Item On-Hand Inventory S 20 W 30
    T 20 X 25
    U 40 Y 240
    V 30 Z 40

    Please answer the following three questions showing your steps and upload in excel format. Thank you.

                                                                                                                                      Order Now