Explore BrainMass

Explore BrainMass

    Construct a net material requirements plan

    Not what you're looking for? Search our solutions OR ask your own Custom question.

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    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. Using this information, construct a net material requirements plan using the following on-hand inventory

    Item On-hand inventory

    S 20
    T 20
    U 40
    V 30
    W 30
    X 25
    Y 240
    Z 40

    © BrainMass Inc. brainmass.com March 4, 2021, 6:02 pm ad1c9bdddf
    https://brainmass.com/business/strategy-and-business-analysis/construct-a-net-material-requirements-plan-25036

    Attachments

    Solution Preview

    Find the solution in attched excel sheet.
    -First draw the Bill of materials and understand the hierarchy of items
    -Make material requirements plans ...

    Solution Summary

    Shows how to construct a net material requirements plan using the on-hand inventory

    $2.49

    ADVERTISEMENT