Calculator Inputs
Example Data Table
Sample SKU audit lines showing recorded versus counted quantities, plus variance direction.
| SKU | Location | Recorded | Physical | Variance | Status |
|---|---|---|---|---|---|
| VALVE-120 | RACK-A1 | 100 | 98 | -2 | Over in system |
| BOLT-M8 | BIN-B3 | 450 | 465 | +15 | Short in system |
| GASKET-9 | RACK-C2 | 60 | 60 | 0 | Exact match |
| BEARING-22 | BIN-D7 | 35 | 33 | -2 | Over in system |
| SENSOR-TX | CAGE-E1 | 12 | 14 | +2 | Short in system |
| CABLE-5M | RACK-F4 | 80 | 80 | 0 | Exact match |
To compute record accuracy, count how many lines match exactly or within tolerance, then divide by total audited lines.
Formula Used
- Exact Record Accuracy (%) = Exact Matches ÷ Total Records × 100
- Tolerance Record Accuracy (%) = Matches Within Tolerance ÷ Total Records × 100
- Unit Variance = Physical Units − Recorded Units
- Quantity Accuracy (%) = (1 − |Unit Variance| ÷ Denominator) × 100
- Recorded Value = Recorded Units × Unit Cost
- Physical Value = Physical Units × Unit Cost
- Value Accuracy (%) = (1 − |Value Variance| ÷ Value Denominator) × 100
- Composite Data Quality Score = weighted average of record, quantity, and value accuracy.
How to Use This Calculator
- Run a cycle count or audit on a defined scope.
- Sum system quantities and physical quantities for the scope.
- Count audited SKU lines, then tally exact and tolerance matches.
- Enter values, choose a denominator, and calculate results.
- Export CSV or PDF, then compare trends by period.
FAQs
1) What does inventory accuracy measure?
It measures how closely system records match physical reality. Strong accuracy reduces stockouts, excess inventory, and emergency expediting while improving planning confidence and audit readiness.
2) Why include both record and quantity accuracy?
Record accuracy focuses on SKU-line correctness. Quantity accuracy captures total unit variance across the audited scope. Together, they highlight whether issues are widespread or concentrated in a few lines.
3) What is “matches within tolerance”?
It counts SKU lines that meet your acceptance rule, such as ±1 unit or ±2%. This helps when minor handling variance is acceptable, but recurring gaps still require corrective action.
4) Which denominator should I choose?
Use Physical for audit-centered reporting. Use Recorded for system-centered KPIs. Use Max or Average when one quantity is small, because it prevents extreme percentage swings from tiny denominators.
5) How should I interpret a positive unit variance?
Unit variance is physical minus recorded. A positive value means the system is short, often linked to missed receipts, unposted production, or counting scope differences. Investigate transaction timing and controls.
6) How does unit cost affect the results?
Unit cost converts unit variance into value variance. This highlights whether accuracy issues are financially material. High-cost items can justify tighter cycle counts, approvals, and segregation of duties.
7) What audit cadence is recommended?
If the score is under 70, increase cycle counts and tighten adjustments. Between 70 and 85, target problem locations and processes. Above 85, maintain cadence and focus on root-cause prevention.
8) Can this replace a full inventory reconciliation?
No. It supports quick KPI assessment and trend tracking. For reconciliation, you still need SKU-level investigation, transaction traceability, and approvals for adjustments, especially for regulated or serialized items.