Skip to content

2.4 MRP parameter governance

Material Requirements Planning (MRP) is a deterministic engine. It calculates supply execution directly based on the variables configured in the Item Master. If the Minimum Order Quantity (MOQ) is inaccurate, the system may generate excess stock. If Safety Stock levels are set arbitrarily, the supply chain may oscillate between line-down shortages and excess inventory. Parameters act as the control mechanisms of your supply chain. Uncontrolled modifications by individual planners can destabilize the procurement signal across the enterprise.

To maintain system integrity, write access to specific ERP parameters must be segregated by function. Clear ownership ensures data accuracy.

  • Parameters: MOQ, Order Multiple (Pack Size), Standard Cost.
  • Owner: Sourcing / Procurement.
  • The Source: Vendor Contract or valid Quotation.
  • The Protocol: These values must mirror physical reality. If a vendor sells components in reels of 1,000, setting the ERP Order Multiple to 1 will likely cause receiving discrepancies or rejected POs.

Strategic buffers (internal risk strategy)

Section titled “Strategic buffers (internal risk strategy)”
  • Parameters: Safety Stock (SS), Reorder Point (ROP), Target Days of Supply.
  • Owner: Planning / Supply Chain Manager.
  • The Source: Statistical calculation based on historical demand volatility (σdemand) and measured lead time variance (σLT).
  • The Protocol: These act as financial levers. Significantly increasing Safety Stock requires working capital approval from Finance.
  • Parameters: Order Policy (e.g. Lot-for-Lot vs. Fixed Period Supply), Shrinkage/Yield Factor.
  • Owner: Master Scheduler.
  • The Source: Driven by physical production methodology (e.g. Batch Manufacturing vs. Continuous Flow) and historical yield data.

Avoid changing parameters based on intuition or isolated incidents. Parameter changes should be driven by data.

Significant supply chain parameter changes (e.g. > 10%) should be supported by documented sources.

  • Valid Evidence: A formal Supplier Quote, an Engineering PCN (Product Change Notification), or a proven change in the consumption rate (Rolling Quarterly Average).
  • Invalid Evidence: Unverified assumptions or speculative sales projections not reflected in the formal forecast.

Decision logic: when to trigger a system change

Section titled “Decision logic: when to trigger a system change”

When Demand Volatility Statistically Increases:

  • Recalculate the Safety Stock.
  • Ensure the formula covers the new variance, not just the arithmetic average.
  • If the resulting capital requirement exceeds defined thresholds, seek formal Finance approval before updating the system.

When the Supplier Imposes Allocation:

  • Update the Lead Time and consider switching the Order Policy to “Fixed Period”.
  • Batching small orders into larger scheduled buckets can sometimes secure better production slotting at the vendor’s facility during allocation.

When the MOQ exceeds 6 Months of Historical Demand:

  • Flag the item for Engineering Review.
  • The financial carrying cost and obsolescence risk of this inventory might justify the NRE cost of redesigning the PCBA to use a more readily available component.

Maintaining an audit trail is essential for understanding why specific inventory levels exist.

Maintain a “Parameter Change Log” (via system tracking or a controlled document):

DatePart NumberParameterOld ValueNew ValueReason CodeApprover
10/24RES-0402-1KMOQ5,00010,000Vendor PCN (New Reel Size).J. Doe
10/25MCU-STM32Safety Stock0500New Customer Contract (Risk Buy).S. Smith
11/01CONN-USBOrder PolicyL4LFixed (4 Wks)Freight Consolidation strategy.Director

Pro-Tip: Restrict edit access to the “Order Multiple” field in your ERP to Procurement only. If a part comes on physical reels of 3,000, the system must enforce ordering in those multiples to prevent orphaned inventory errors in the Warehouse Management System (WMS).

Parameter data requires routine reviewing to prevent data rot from impacting MRP accuracy.

  1. Quarterly Review (The “Sweep”):
    • The Action: Compare current ERP MOQ/LT parameters against recent physical receipts.
    • The Logic: If Procurement consistently orders 5,000 units to secure a price break, but the system MOQ is set to 1,000, update the system to 5,000 to align with actual commercial practice.
  2. Annual ABC Re-Classification:
    • The Action: Re-rank all active items based on current trailing 12-month spend and volume.
    • The Logic: An item that was “Class C” last year might be “Class A” today due to volume shifts, requiring its Safety Stock policy to be adjusted accordingly.
Control PointEngineering RequirementTarget Goal
SegregationSourcing owns MOQ; Planning owns Safety Stock.Active Access Control
Physical IntegritySystem multiples match physical Pack Size.Verified periodically
Audit TrailChange Log maintained for significant edits.Maintained
Finance GateTotal Inventory Value Increase Approval.Defined threshold applied
The EvidenceHard data source cited for system change.Required
The CadenceParameter Review executed regularly.E.g. Quarterly