Explore BrainMass

Explore BrainMass

    Material Requirements Pan Using MRP Tableau

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

    Use the following information and the attached editable MRP tableau worksheet to determine a complete material requirements plan for the 5 week planning horizon. A garden equipment manufacturer has a product that it makes which is represented by the following product structure tree along with other pertinent data:

    Information attached.

    © BrainMass Inc. brainmass.com June 4, 2020, 5:01 am ad1c9bdddf
    https://brainmass.com/business/business-management/material-requirements-pan-using-mrp-tableau-593600

    Attachments

    Solution Preview

    Horizon Period 0 1 2 3 4 5 6 7 8 9

    Item: ABC-51 Lot Size: L4L LT: 1 SS: 0
    Gross Requirements - - - 50 - 75 - - - -
    Scheduled Receipts - - - - - - - - - -
    Projected On Hand 15 15 15 15 - - - - - -
    Net Requirements - - - 35 - 75 - - - -
    Planned-Order Receipts - - - 35 - 75 - - - -
    Planned-Order Releases - - 35 - 75 - - - - -

    Horizon Period 0 1 2 3 4 5 6 7 8 9

    Item: X Lot Size: 40 LT: 2 SS: 0
    Gross Requirements - - 105 - 225 - - - - -
    Scheduled Receipts - - - - - - - - - -
    Projected On Hand - ...

    Solution Summary

    The example shows the computation of material requirement planning and ordering plan using the techniques of Material Requirement Planning (MRP)

    $2.19

    ADVERTISEMENT