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
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.
Frequently Asked Questions (FAQ)
What is ABC inventory analysis?
It ranks products by annual sales value. Class A items are the most valuable and need tight control, class B items are medium, and class C items are the long tail of low value items.
What do I enter for each product?
The product name and its annual sales value. The tool sorts everything from highest to lowest value and assigns the A, B and C classes itself.
How are the A, B and C classes decided?
Products are sorted from highest to lowest value. The top items up to 80 percent of total value become class A, the next up to 95 percent become class B, and the rest are class C.
Can I try it with sample data?
Yes. Press Load sample data to see a full example analysis before entering your own products.
Can I download the analysis?
Yes. Press Export CSV to download a spreadsheet with every product, its class, value and share of total, ready to open in Excel or Google Sheets.