Share
Explore BrainMass

Material Requirements Pan Using MRP Tableau

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.

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