ABC Inventory Analysis
Rank your products by annual sales value. Add each product with its yearly value, and the tool classifies them into A, B and C, draws a chart, and lets you export the full analysis as CSV.
Add a product
Products 0
| Product | Annual value | Class | Share of total | |
|---|---|---|---|---|
| No products yet. Add products above or load the sample data. | ||||
Rule used: A = top items covering up to 80% of total value, B = next items up to 95%, C = everything else.
Class summary
Class A — vital few
0 items, 0% of value
Class B — important
0 items, 0% of value
Class C — long tail
0 items, 0% of value
Chart
Bars are colored by class: red = A, amber = B, green = C.
How to use
- Add each product with its total annual sales value (units sold x price).
- The table ranks products and assigns A, B or C automatically.
- Read the class summary and chart to see where your value sits.
- Press Export CSV to download the analysis for Excel or Google Sheets.
Tips
- Class A items deserve tight control: frequent counts, accurate records, careful ordering.
- Class C items need simple rules — review them rarely and avoid stockouts only for critical ones.
- Redo the analysis every 6 to 12 months because product value shifts over time.
- Use annual consumption value, not unit count — one expensive item can outrank many cheap ones.