Explore BrainMass
Share

Material Requirements Pan Using MRP Tableau

This content was STOLEN 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 October 25, 2018, 9:59 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
See Also This Related BrainMass Solution

Select a minimum of two industries

Need suggestions/ideas on following -

1. Select a minimum of two industries (or specific companies) and identify how reselling, selling via outlet, salvaging, reconditioning, refurbishing, and remanufacturing can help that company optimize its reverse logistics supply chain.
2. Explain the relationship between optimization of the reverse logistics channel and the overall supply channel.

View Full Posting Details