5.2 Inventory control operating model: KPIs, ownership, audit cadence

Inventory represents both financial capital frozen in time and significant operational risk. Without a structured control model, discrepancies between physical floor stock and digital ERP records will naturally occur. Unchecked data drift can lead to phantom inventory, production stoppages, and uncomfortable financial adjustments at year-end. Maintaining data accuracy requires a systematic loop of measurement, detection, and physical correction.

The control loop: KPIs & definitions

Performance indicators that provide clear visibility into operational health must be focused on.

Core KPI architecture

1. Inventory Record Accuracy (IRA): The probability that the digital ERP quantity matches the physical quantity within an acceptable tolerance.
   • The Target: Typically > 99% for A-Items; > 98% overall factory aggregate.
   • The Logic: (Correct Cycle Counts / Total Counts Performed) × 100.
2. Cycle Count Variance (CCV): The financial impact of inventory discrepancies.
   • Absolute Variance: (Sum of absolute $$$ discrepancies). This indicates the total level of operational turbulence.
   • Net Variance: (Sum of +/- $$$ discrepancies). This reflects the net financial balance sheet adjustment.
   • Guidance: Focus predominantly on tracking Absolute Variance. A large positive variance and a large negative variance might balance out financially, but they still point to underlying process instabilities.
3. Dock-to-Stock Time (DTS): The cycle time from materials arriving at the dock to being digitally available for MRP in a bin location.
   • The Target: E.g. < 24 hours for standard flows; < 4 hours for critical shortages.
   • The Risk: Delayed DTS can cause planners to react to phantom shortages and expedite unnecessary orders.
4. Pick Error Rate: The frequency of incorrect part retrievals detected downstream.
   • The Measurement: Often tracked in PPM (Defective Parts Per Million lines picked).

Ownership & segregation of duties

Clear delineation of responsibilities ensures both efficient operation and sound financial checks.

Warehouse manager (the execution owner):

• Responsibilities: Oversees physical material velocity, bin discipline, floor safety, and the daily execution of cycle counts.
• Accountability: Meets Dock-to-Stock SLAs and maintains general warehouse organization.

Materials control lead (the system architect):

• Responsibilities: Manages the cycle count schedule, discrepancy investigations, and formal Root Cause Analysis (RCA).
• Accountability: Drives IRA data accuracy and implements systemic improvements to address recurrent errors.

Site controller / finance (the financial gatekeeper):

• Responsibilities: Reviews and authorizes significant fiscal write-offs and ensures compliance with external audit standards (e.g. SOX).
• Accountability: Verifies that the inventory valuation on the balance sheet reflects physical reality.

Discrepancy & escalation logic

When a physical count does not match the ERP record, a consistent procedure must be followed to confirm the variance.

1. Initial Discrepancy: The operator reports a variance. The ERP flags the location to pause picking activity temporarily.
2. Blind Recount: The system prompts a different operator to recount the bin without revealing the expected system quantity.
   • If the recount matches the system, the initial count was an error.
   • If the recount confirms the variance, proceed to financial reconciliation.
3. Reconciliation Hierarchy:
   • Minor Variance (e.g. < $$$50): System generally auto-adjusts based on standard tolerances.
   • Moderate Variance (e.g. $$$50 – $$$1,000): Requires review and sign-off by the Materials Control Lead.
   • Significant Variance (e.g. > $$$1,000): Requires formal sign-off by Operations Director and/or Finance, often paired with an RCA.

Root cause analysis (RCA)

Instead of simply adjusting balances, the underlying operational cause for significant variances should be identified using standardized reason codes:

• RC-RX: Receiving Error (Incorrect quantity received or mislabeled by vendor).
• RC-PK: Pick / Put-away Error (Placed into or pulled from the wrong bin).
• RC-BM: BOM / Backflush Error (The digital engineering consumption ratios do not match physical reality).
• RC-SC: Unreported Scrap (Parts damaged in production but not properly recorded as scrap).

Common Pitfall

If BOM Errors (RC-BM) account for a significant percentage of variances, this usually points to an engineering data issue rather than a warehouse execution failure. Process Engineering must be engaged to review and correct the consumption logic.

Dashboard specification

A focused “Materials Control” dashboard must be maintained to monitor warehouse health.

Quadrant	Metric Focus	Key Indicators & Alerts
Top Left	Accuracy (Quality)	IRA Trend: 12-week rolling average. Net Variance ($$$): Monthly cumulative financial adjustment.
Top Right	Velocity (Flow)	Dock-to-Stock Avg: Flag instances exceeding 24 hours. Aged WIP: Material staged but not consumed for > 48h.
Bottom Left	Exceptions (Risk)	Negative Balances: SKUs showing < 0 qty (indicates a system timing or data issue). Count Tasks: % of missed count tasks.
Bottom Right	Capacity (Space)	Bin Utilization: Overall physical storage capacity used. Quarantine Age: Average time inventory sits in MRB/Hold.

---

Recap: Inventory Control KPIs, Ownership, and Audit Cadence

Parameter	Requirement	Target / Tolerance	Action / Escalation	Condition / Note
Inventory Record Accuracy (IRA)	Probability ERP matches physical quantity	>99% (A-Items), >98% (Factory Aggregate)	Materials Control Lead accountable for trend	Calculated as (Correct Cycle Counts / Total Counts) × 100
Cycle Count Variance (CCV)	Track financial impact of discrepancies	Focus on Absolute Variance ($) minimization	Materials Control Lead investigates	Net Variance indicates balance sheet adjustment
Dock-to-Stock Time (DTS)	Time from dock arrival to bin availability in ERP	<24 hours (standard), <4 hours (critical shortages)	Warehouse Manager accountable for SLA	Delays cause phantom shortages
Discrepancy Value	Financial threshold for reconciliation	<$50: Auto-adjust $50–$1,000: Materials Control Lead sign-off >$1,000: Ops Director/Finance sign-off + RCA	Formal RCA required for >$1,000	Use standardized RCA reason codes (e.g., RC-RX, RC-PK, RC-BM, RC-SC)
Root Cause Analysis (RCA)	Identify systemic error source	Mandatory for significant variances	Process Engineering engaged for RC-BM (BOM Error) dominance	Prevents recurring errors; not just balance adjustment