Logistics unit converter
Switch between the units your supply chain speaks.
Data & AnalysisDATA & ANALYSIS
ABC Inventory Analysis Calculator with CSV Import
Classify up to 1,000 SKUs from annual usage and unit cost, with editable cumulative value thresholds and a ranked CSV export.
ABC inventory analysis calculator
Classify up to 1,000 SKUs from annual usage and unit cost, with editable cumulative value thresholds and a ranked CSV export.
YOUR RESULT LIVE CALCULATION
Class A inventory items
2of 8 SKUs
ANNUAL USAGE VALUE- Total annual usage value
- $100,000
- Class A items / value share
- 2 / 80%
- Class B items / value share
- 2 / 15%
- Class C items / value share
- 4 / 5%
The item crossing a cutoff stays in that class. Equal-value items retain CSV order; zero-value items are C. This is a value-based segmentation, not a risk score.
Ranked inventory
8 rows
| SKU | Annual units | Unit cost | Annual value | Value % | Cumulative % | Class |
|---|---|---|---|---|---|---|
| SKU-001 | 1,000 | 50 | 50,000 | 50 | 50 | A |
| SKU-002 | 1,500 | 20 | 30,000 | 30 | 80 | A |
| SKU-003 | 1,000 | 10 | 10,000 | 10 | 90 | B |
| SKU-004 | 500 | 10 | 5,000 | 5 | 95 | B |
| SKU-005 | 300 | 10 | 3,000 | 3 | 98 | C |
| SKU-006 | 100 | 10 | 1,000 | 1 | 99 | C |
| SKU-007 | 100 | 5 | 500 | 0.5 | 99.5 | C |
| SKU-008 | 100 | 5 | 500 | 0.5 | 100 | C |
BEHIND THE NUMBER
How the calculation works
Each row represents one unique SKU. The tool ranks annual usage value from highest to lowest; the item crossing a cutoff stays in that class. Equal-value rows retain their CSV order, so tied boundary items can land in different classes. Zero-value rows are always C. Thresholds are editable planning choices, not universal standards. Use one currency and one annual period throughout.
Annual usage value = annual units × unit cost; rank descending and group by cumulative share of total value
When this calculation helps
ABC ranking identifies which entered SKUs account for most annual usage value. It can focus review effort without imposing the same attention on every low-value item.
Check the interpretation
An item crossing a cumulative boundary remains in the class specified by the model. Equal-value ties retain source order, so boundary labels can change when rows are reordered. Add criticality and supply-risk information before turning a value class into a stocking rule.
ABC value segmentation alone does not capture criticality, lead time, supply risk, or demand variability. CSV processing is local to your browser. Shared links exclude the dataset.
ASCM on ABC and XYZ inventory analysisGood to know
Does the tool send my SKU data to the server?
No. File import, calculation, and export run in your browser. Copy tool link excludes the dataset. The optional calculation API processes only data you explicitly submit to it.
Which columns are required?
Use sku, annual_units, and unit_cost. Headers are case-insensitive, with spaces or hyphens normalized to underscores. Extra columns are ignored. Numbers must not contain currency symbols or thousands separators.