ABC (Pareto) analysis for SKUs
Compute annual consumption value per SKU, sort by value, and classify A/B/C by cumulative % (incl. CSV export).
Note: results are not made indexable via URL parameters. Canonical: https://tools.snapsoft.de/en/tools/abc-analyse
Who is this for?
- Ops/buying/category teams that want to prioritize processes around A items
- Marketplace teams with broad assortments that need to identify value drivers fast
- Finance/controlling as a quick check for data-driven assortment discussions
ABC analysis: focus on the SKUs that drive value
ABC analysis is a simple Pareto method: sort SKUs by annual value contribution to see which “A items” account for most of the value.
This tool runs locally in your browser (no login, no storage): paste/upload CSV → annual consumption value → cumulative % → A/B/C classification. Optionally, you can include a margin-based value if your data provides `unitMargin`.
Calculator
Max 6 inputs, clear outputs. Everything runs locally in your browser.
Inputs
Max 6 core inputs — everything runs locally (no API calls, no storage).
Data (CSV/TSV)
Tip: load/copy the template and replace values. Columns: sku, annualUnits, unitCost (optional: unitMargin).
Required columns: sku, annualUnits, unitCost. Optional: unitMargin. You can also upload a file.
Advanced options
Result
How it works
Per SKU we compute annual consumption value: (value = annualUnits \times unitCost\).
We sort descending by value and compute the cumulative sum. Cumulative % = cumulative / total value.
Classification: A up to threshold A (default 80%), B up to threshold B (default 95%), rest = C.
Traffic-light note: if the share of A items (by SKU count) is > 20%, your A segment is “too broad” (A items are typically ~20% or less).
Quick conclusion
- A items are your focus SKUs: operational effort and inventory work usually pays off most here.
- If your A segment is “too broad”, check data quality (units/cost) or adjust thresholds.
- Export the table as CSV to use it as a working list (ops/buying).
Sources & notes
Disclaimer: assumptions, fees and policies can vary and change. Always verify critical values in official sources (marketplace, supplier, payment provider).
FAQ
Which CSV columns do I need?
Required: `sku`, `annualUnits`, `unitCost`. Optional: `unitMargin` (e.g. contribution €/unit) if you want to include a margin-based value.
How exactly are A/B/C calculated?
After sorting by annual consumption value we compute cumulative % of total value. A = up to threshold A, B = up to threshold B, rest = C.
Do you store my CSV data?
No. Everything runs locally in your browser.
What happens with duplicates (multiple rows per SKU)?
Duplicates are aggregated per SKU: annualUnits and annual consumption value are summed. unitCost becomes a weighted average (value/units).
Can I analyze profit drivers instead of revenue/value drivers?
Yes: provide an optional `unitMargin` column (e.g. contribution €/unit) and enable the margin-based value. The tool will then also output an annual margin value.
Turn it into a repricing rule in SnapTrade
If you want to turn A/B/C segments into concrete workflows (reorder focus, monitoring, alerts): SnapTrade can automate those routines.