Calculate net material requirements using the MRP formula: gross requirements minus on-hand and receipts plus safety stock, offset by lead time.
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.
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. Precise quantification supports benchmarking against industry standards and internal targets, driving accountability and continuous improvement throughout the organization.
Net Requirement = Gross Requirement − On-Hand − Scheduled Receipts + Safety Stock If Net Req > 0: Planned Order = roundUp(Net Req / Lot Size) × Lot Size Order Release = Due Date − Lead Time
Result: Net req = 360, Planned order = 400 units, release 5 days before due
Net Requirement = 500 − 120 − 50 + 30 = 360 units. Rounded up to lot size of 100 = 400 units. The order must be released 5 days before the due date to account for lead time.
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 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.
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.
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.
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.
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.
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.
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.
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.