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.

Changing parameters based on intuition or isolated incidents must be avoided. 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:

  • The Safety Stock must be recalculated.
  • The formula must be ensured to cover the new variance, not just the arithmetic average.
  • If the resulting capital requirement exceeds defined thresholds, formal Finance approval must be sought before updating the system.

When the Supplier Imposes Allocation:

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

When the Minimum Order Quantity (MOQ) exceeds 6 Months of Historical Demand:

  • The item must be flagged for Engineering Review.
  • The financial carrying cost and obsolescence risk of this inventory might justify the Non-Recurring Engineering (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.

A “Parameter Change Log” must be maintained (via system tracking or a controlled document):

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

Pro-Tip: Edit access to the “Order Multiple” field in the ERP must be restricted 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 Material Requirements Planning (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