MRP Calculator

About the MRP Calculator

Material Requirements Planning (MRP) calculates exactly what materials are needed, how many, and when. The core netting logic subtracts on-hand inventory and scheduled receipts from gross requirements, adds safety stock, and offsets the result by lead time to determine when to place orders.

MRP ensures that materials arrive just when they are needed — not too early (which ties up cash in inventory) and not too late (which stops production). The formula is straightforward but powerful: Net Requirement = Gross Requirement − On-Hand − Scheduled Receipts + Safety Stock.

This calculator performs the MRP netting calculation for a single component and determines both the planned order quantity and the planned order release date (gross-to-net plus lead time offset). It is a fundamental building block of manufacturing planning.

Quantifying this parameter enables systematic comparison across time periods, shifts, and production lines, revealing patterns that might otherwise go unnoticed in routine operations.

When This Page Helps

Manual material planning leads to shortages or excess. MRP automates the logic, ensuring every component is ordered in the right quantity at the right time. This calculator teaches and validates the core MRP netting logic.

How to Use the Inputs

1. Enter the gross requirement (total units needed for production).
2. Enter current on-hand inventory for the component.
3. Enter any scheduled receipts (open purchase or production orders).
4. Enter the safety stock level you want to maintain.
5. Enter the lead time in days for the component.
6. Enter a lot size to round up the order quantity.
7. View net requirement, planned order quantity, and order release date.

Example Calculation

Tips & Best Practices

• Always validate on-hand and receipts data before running MRP — garbage in, garbage out.
• Use realistic lead times that include supplier variability, not just quoted lead times.
• Safety stock should reflect demand variability and supply reliability for each component.
• Review MRP output for exceptions: past-due orders, excess inventory, and reschedule recommendations.
• Lot sizing affects order frequency and inventory levels — choose appropriately.
• Run MRP regeneration weekly and net change daily for responsive planning.

MRP Logic Flow

MRP follows a structured process: (1) explode the MPS through the bill of materials to determine component needs, (2) net against inventory and open orders, (3) lot size the net requirements, and (4) offset by lead time to time-phase order releases. This process cascades through every level of the bill of materials.

MRP Inputs and Data Requirements

MRP requires three key inputs: the Master Production Schedule (what to make), the Bill of Materials (what components are needed), and Inventory Status Records (what is on hand and on order). All three must be accurate for MRP to produce valid plans.

Dealing with MRP Nervousness

Small changes in the MPS can cause large downstream MRP changes — a phenomenon called nervousness. Time fences, damping, and firm planned orders help reduce nervousness and provide stability for the shop floor and suppliers.

Frequently Asked Questions

• What is gross-to-net calculation?

  Gross-to-net is the core MRP logic that converts gross requirements (total need) to net requirements (what you actually need to order) by subtracting available inventory and open orders. Consulting relevant industry guidelines or professional resources can provide additional context tailored to your specific circumstances and constraints.

• What is lead time offset?

  Lead time offset takes the date when material is needed and backs up by the lead time to determine when the order must be released. If material is needed on day 20 and lead time is 5 days, order release is day 15.

• How does safety stock affect MRP?

  Safety stock is added to net requirements because MRP treats it as untouchable inventory. Even if on-hand covers gross requirements, MRP will order more if on-hand would drop below safety stock.

• What lot sizing methods are common?

  Common methods include lot-for-lot (order exactly what is needed), fixed lot size, EOQ, and period order quantity. Each balances order frequency against inventory cost differently.

• What happens when MRP data is inaccurate?

  Inaccurate bills of materials, inventory records, or lead times cause MRP to generate wrong orders — leading to shortages of some items and excess of others. Data accuracy above 95% is critical for MRP to work.

• What is the difference between MRP and MRP II?

  MRP focuses on material planning. MRP II (Manufacturing Resource Planning) extends MRP to include capacity planning, financial planning, and shop floor control. Modern ERP systems incorporate MRP II concepts.