Skip to content
Guide · MRP

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.

MRP data flow: order, bill of materials, stock and suggestion
In short

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.

Inputs

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.

Formula

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.

Worked example

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².

FeatureGross requirementOn hand + open supplyNet requirement → suggestion
Cabinet (finished · level 0)501040 → Make
Door (semi-finished · level 1)40 × 2 = 804040 → Make
Hinge (raw material · level 2)40 × 2 = 80 (+100 minimum stock)60 + 50 = 11070 → 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.

In EPROX ERP

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
EPROX ERP material requirements plan screen: item, level, net requirement and suggestion
In practice

Five steps for MRP to give the right result

  1. 01

    Keep bills of materials up to date

    Any difference between actual consumption and the bill of materials is carried into every MRP calculation.

  2. 02

    Measure scrap rates

    Use rates based on scrap data from the workshop, not estimates.

  3. 03

    Enter stock immediately

    Record goods receipt with handheld terminals, and output and scrap with workstation terminals, at the source.

  4. 04

    Set minimum stock levels

    Define a safety level for critical materials and those with long lead times.

  5. 05

    Run the plan regularly

    Review the suggestions; turn only the ones you approve into orders and requests.

Frequently 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.

Free demo

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.

Chat on WhatsApp