What is MRP? A guide to material requirements planning
MRP is the method that calculates how much of each material is needed for the products to be made, using bills of materials and stock. We explain its logic, its formula and a worked calculation step by step.
What is MRP (Material Requirements Planning)?
MRP (Material Requirements Planning) is a planning method that starts from customer orders and planned production and calculates how much of each raw material and semi-finished product is needed. The aim is to strike a balance between two extremes: production stopped by missing materials, and unnecessary stock piling up in the warehouse.
At the heart of MRP is the distinction between independent and dependent demand. The cabinet a customer orders is independent demand; its door, hinges and chipboard are dependent demand, arising because the cabinet is going to be made. Dependent demand is not forecast; it is calculated from the bill of materials.
MRP, MRP II and ERP
MRP focuses on material quantities. MRP II (Manufacturing Resource Planning) adds production resources such as capacity, labour and cost. ERP brings the whole business, including sales, purchasing, stock, quality and finance, into the same database. Today MRP runs as a module of ERP software.
The information that goes into the MRP calculation
Independent demand
The unfulfilled remainder of customer orders and planned production.
Bill of materials (BOM)
The semi-finished products and raw materials that make up a product, their quantities and scrap rates; it can be multi-level.
Stock on hand
Available stock; material in quarantine or reserved should not be counted.
Open purchases
Material that has been ordered but not yet arrived, and pending purchase requests.
Open work orders
The remaining quantity of orders in production is supply; the raw material they have not yet consumed counts as demand.
Minimum (safety) stock
The quantity you always want on hand to cover unexpected demand and delays.
From gross requirements to net requirements
Gross requirement = independent demand + dependent demand
Net requirement = gross requirement + minimum stock − (stock on hand + open purchases + open production)
If the net requirement is zero or below, there is no requirement. If an item with a net requirement has a bill of materials and is a manufactured item, it is made and this quantity is passed one level down through the bill of materials; if it has no bill of materials, it is bought. The calculation starts from the finished product and goes down level by level to the raw materials. This is called BOM explosion.
Example: MRP for an order of 50 cabinets
A customer has ordered 50 cabinets. To keep the example simple, we follow only the door branch of the cabinet:
- 1 cabinet = 2 doors (semi-finished, made in the workshop)
- 1 door = 2 hinges (bought) + 0.5 m² of chipboard (bought, 10% cutting scrap)
Stock status: cabinets 10, doors 40, hinges 60 (plus 50 on the way, minimum stock 100), chipboard 30 m².
| Feature | Gross requirement | On hand + open supply | Net requirement → suggestion |
|---|---|---|---|
| Cabinet (finished · level 0) | 50 | 10 | 40 → Make |
| Door (semi-finished · level 1) | 40 × 2 = 80 | 40 | 40 → Make |
| Hinge (raw material · level 2) | 40 × 2 = 80 (+100 minimum stock) | 60 + 50 = 110 | 70 → Buy |
| Chipboard (raw material · level 2) | 40 × 0.5 × 1.10 = 22 m² | 30 m² | 0 → No requirement |
What happened, line by line?
- Cabinet: 50 are required and 10 are ready. 40 will be made.
- Door: Dependent demand is calculated not from the 50 ordered but from the 40 cabinets to be made: 40 × 2 = 80. After deducting the 40 doors on hand, 40 doors will be made.
- Hinge: 40 doors to be made × 2 = 80. Minimum stock of 100 is added, the 60 on hand and the 50 on the way are deducted: 80 + 100 − 110 = 70 are bought.
- Chipboard: 40 doors × 0.5 m² = 20 m²; 22 m² with 10% scrap. The 30 m² on hand is enough; no requirement.
Note: if the scrap rate had been forgotten, the chipboard requirement would have appeared as 20 m²; if the minimum stock had been forgotten, no hinges would have been bought and stock would have fallen below the safety level.
How does MRP work in EPROX ERP?
The Material Requirements Plan screen performs the calculation above with your company's real data. The calculation lives in a shared function and is fed by the sales, purchasing, stock and production screens of the installation.
- Items sorted by BOM level: finished products first, then semi-finished products and raw materials
- Remaining open orders, available stock, minimum stock, open purchases and pending requests, and open work orders are included
- Raw materials not yet consumed by open work orders count as dependent demand
- The scrap rate on the BOM line is added to the requirement
- Suggestions come pre-selected and quantities can be edited; a Purchase Request or Work Order is created in one click
- BOM loops (B inside A, A inside B) are detected and flagged
- Only users authorised to see the screens included in the calculation can see the plan
Five steps for MRP to give the right result
- 01
Keep bills of materials up to date
Any difference between actual consumption and the bill of materials is carried into every MRP calculation.
- 02
Measure scrap rates
Use rates based on scrap data from the workshop, not estimates.
- 03
Enter stock immediately
Record goods receipt with handheld terminals, and output and scrap with workstation terminals, at the source.
- 04
Set minimum stock levels
Define a safety level for critical materials and those with long lead times.
- 05
Run the plan regularly
Review the suggestions; turn only the ones you approve into orders and requests.
Related guides and pages
Production Planning Software
Planned production from order to work order, from workstation load to what actually happens in the workshop.
Learn moreProduction Planning and MRP
Bills of materials, routings, work orders and material requirements plan.
View moduleWhat Is OEE?
Availability × Performance × Quality; a calculation table with a CNC machine example.
Read the guideManufacturing ERP
Every link of production from sales to shipment in the same database.
Learn moreFrequently asked questions about MRP
Are MRP and ERP the same thing?
No. MRP is the method that calculates material requirements; ERP is the whole system covering sales, purchasing, stock, production, quality and costing. In EPROX ERP, MRP runs as a module of the ERP in the same database.
How often should MRP be run?
It depends on how busy order and stock movements are. Most factories run the plan daily or when new orders are confirmed. In EPROX ERP the calculation is done with current data whenever you want.
Are safety stock and minimum stock the same?
In practice they serve the same purpose: the lowest quantity you want to keep on hand against unexpected demand and delays. MRP adds this quantity to the net requirement.
How is lead time used in MRP?
Classic MRP also uses lead time to calculate when an order must be placed so that the material arrives before production. EPROX ERP's MRP screen currently calculates the quantity requirement; it does not give date-based suggestions. You track due dates with the overdue materials list in purchasing.
Can MRP be done in Excel?
For single-level products with few items, yes. When the bill of materials is multi-level and open work orders and orders on the way come into play, manual calculation quickly becomes error-prone, and keeping the data current becomes extra work.
Let's try MRP with your own bills of materials
We take the bill of materials and stock status of one of your products as an example and show the flow from net requirement to work order and purchase request.
- 30–45 minute online or on-site demo
- Sample setup for your industry
- Using your own bills of materials and orders
- No obligation to buy
If you prefer not to fill in the form, call us on +90 212 728 01 03 or message us on WhatsApp.
Demo request
Fields marked with an asterisk are required.