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.
   • The Guidance: Tracking Absolute Variance must be predominantly focused on. 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).

Pro-Tip: 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.

Final Checkout: Inventory control operating model (KPIs, ownership, audit cadence)

Control Point	Engineering Requirement	Target Goal
Primary KPI	Inventory Record Accuracy (IRA) is calculated and reviewed.	Overall IRA is maintained > 98%.
Cycle Freq	High-value (A) items are prioritized in counting schedules.	Executed regularly (e.g. monthly).
Authority	Segregation of duties is maintained for inventory adjustments.	Finance handles high-value adjustments.
Escalation	Significant financial variances trigger formal investigations.	RCA is documented.
Detection	The ERP manages or flags negative system balances.	Addressed immediately by Materials team.
The Drift	Dock-to-Stock cycle times are monitored.	Goals generally held < 24 hours.