Material Requirements Pan Using MRP Tableau
Not what you're looking for?
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.
Purchase this Solution
Solution Summary
The example shows the computation of material requirement planning and ordering plan using the techniques of Material Requirement Planning (MRP)
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 - ...
Purchase this Solution
Free BrainMass Quizzes
IPOs
This Quiz is compiled of questions that pertain to IPOs (Initial Public Offerings)
Six Sigma for Process Improvement
A high level understanding of Six Sigma and what it is all about. This just gives you a glimpse of Six Sigma which entails more in-depth knowledge of processes and techniques.
Income Streams
In our ever changing world, developing secondary income streams is becoming more important. This quiz provides a brief overview of income sources.
Situational Leadership
This quiz will help you better understand Situational Leadership and its theories.
Writing Business Plans
This quiz will test your understanding of how to write good business plans, the usual components of a good plan, purposes, terms, and writing style tips.