material requirements planning example pdf

Mastering MRP: Comprehensive Example PDF

By Hannah Clark
AD

Material Requirements Planning (MRP) is an essential business process for manufacturing companies, ensuring they have an optimal amount of inventory at minimum costs. MRP II, an advanced version of MRP, includes financial factors and customer service dimensions, providing a more comprehensive planning approach. Let's delve into an example of MRP using a simple PDF-style representation to illustrate its workings.

To start, consider a manufacturing company producing chairs. The Bill of Materials (BOM) for one chair, as seen in the PDF, contains: 2 legs, 1 seat, and 1 backrest. Each component has its own lead time, reorder point, and safety stock. Now, let's explore the MRP process for this example.

The MRP Process

MRP involves a series of calculations to determine the quantity of each raw material or component required to meet customer demands, while minimizing inventory costs.

AD
Everything You Need to Know About Material Requirements Planning (MRP) | Smartsheet
Everything You Need to Know About Material Requirements Planning (MRP) | Smartsheet
What is Material Requirement Planning (MRP)? A Beginner’s Guide
What is Material Requirement Planning (MRP)? A Beginner’s Guide
Forget Tedious Documentation: How to Prototype Your Requirements Instead
Forget Tedious Documentation: How to Prototype Your Requirements Instead

In our chair manufacturing example, the Master Production Schedule (MPS) might indicate a need for 100 chairs in the next period. Let's break down the MRP process step by step:

Gross Requirements Calculation

The Gross Requirement calculating one back, one seat, and two legs for each chair yields: 100 chairs x 1 backrest = 100 backrests, 100 chairs x 1 seat = 100 seats, and 100 chairs x 2 legs = 200 legs.

the project management process is shown in this graphic above it's main stages, including planning
the project management process is shown in this graphic above it's main stages, including planning
eFinanceManagement
eFinanceManagement
a workbook with instructions to design and use for the product or service, which is also
a workbook with instructions to design and use for the product or service, which is also

The Gross Requirements, displayed in the PDF, form the basis for further calculations in the MRP process.

Less: On Hand Inventory and Planned Receipts

Subtracting the inventory currently available (On Hand) and any planned receipts (items that will arrive before the need date) from the Gross Requirements helps determine the Net Requirements:

AD

Backrest: (100 - 20) - 0 = 80 (The company has 20 backrests on hand, none planned for arrival)

the project design complete training guide is displayed on an iphone screen, with text below it
the project design complete training guide is displayed on an iphone screen, with text below it
How to write a lean PRD (product requirements document) for your next project... | Planio
How to write a lean PRD (product requirements document) for your next project... | Planio
Hesham Fawzy Saad (CISCM) on LinkedIn: Material Requirements Planning (MRP) emerges as a critical tool for…
Hesham Fawzy Saad (CISCM) on LinkedIn: Material Requirements Planning (MRP) emerges as a critical tool for…
Project Quality Plan Template: A Comprehensive Guide - Free Sample, Example & Format Templates
Project Quality Plan Template: A Comprehensive Guide - Free Sample, Example & Format Templates
the ultimate guide to material planner survival guides for tough world of materials [ infographical ]
the ultimate guide to material planner survival guides for tough world of materials [ infographical ]
The only must-have project documents you need (with 9 templates)
The only must-have project documents you need (with 9 templates)

Seat: (100 - 10) - 5 = 85 (The company has 10 seats on hand, 5 are planned for arrival)

Legs: (200 - 50) - 30 = 120 (The company has 50 legs on hand, 30 are planned for arrival)

AD

MRP Calculations for Each Component

Now, let's look at each component's MRP calculations using the Net Requirements determined earlier:

Backrest

The backrest has a Reorder Point of 30 and a Safety Stock of 10. Since the Net Requirement is 80, the company needs to trigger a purchase order (PO) to meet the demand.

Using the Backrest's lead time of 5 days, the recommended order date would be 5 days before the need date (corresponding to the MPS period).

AD

Seat

With a Net Requirement of 85, the company again needs to place a PO. Using the seat's lead time of 3 days, the recommended order date is calculated accordingly.

Legs

The legs have a high Net Requirement of 120, also triggering a PO. Using their lead time of 7 days, the recommended order date is calculated.

By following this comprehensive MRP process, our chair manufacturing company can effectively plan its material requirements to meet production goals efficiently and cost-effectively. Staying informed and adaptable in today's dynamic business environment is crucial, ensuring you're leveraging the full power of MRP for sustained success in your operations.

AD