Rank up to 100 products by annual usage value with adjustable ABC cutoffs. Import CSV, review value shares and classifications, then print or download the analysis.
ANNUAL USAGE VALUENo account needed · Up to 100 products
Edit the fictional sample or start blank. Enter units used over the same year and each product’s unit cost in one currency. Your draft stays in this tab through a refresh; download or print a copy to keep. Nothing is uploaded.
Analysis inputs
A and B are cumulative value cutoffs, not percentages of products. Equal-value products stay in the same class. The group that crosses a cutoff stays in its starting class.
Import from a spreadsheet
Choose a CSV file, or copy cells from Excel or Google Sheets, including the header row, and paste them below. Columns can include Product, SKU, Annual units and Unit cost; other columns are ignored. Nothing is uploaded.
Paste cells from a spreadsheet first.
Product 1
Product 2
Product 3
Product 4
Product 5
ABC results
Sample annual inventory review
Annual usage value · USD · Cutoffs 80% / 95%
Total annual usage value
$15,000.00
Class A
2 products
Class B
2 products
Class C
1 products
Product / SKU
Annual value
Share
Cumulative
Class
Canvas toteTOTE-011000 × $8.00
$8,000.00
53.33%
53.33%
A
Travel mugMUG-01400 × $10.00
$4,000.00
26.67%
80.00%
A
NotebookNOTE-01500 × $4.00
$2,000.00
13.33%
93.33%
B
Greeting cardCARD-01600 × $1.00
$600.00
4.00%
97.33%
B
Gift bagBAG-01400 × $1.00
$400.00
2.67%
100.00%
C
Annual usage value = annual units used × unit cost. Products are sorted by value, highest first; ties retain input order and stay in one class. A group is A if its starting cumulative share is below 80%, B if below 95%, otherwise C. Zero-value products are C when the total is positive. Percentages shown are rounded.
Use these classes to prioritize review. They do not account for criticality, stockouts, margin or demand variability and do not calculate purchase quantities.
Rank products by annual usage value and see which fall into your A, B and C groups. This free ABC inventory analyzer multiplies annual units used by unit cost, sorts products by that value and applies visible cumulative cutoffs. Enter products directly or import a CSV, then print or download the results.
Prepare your inventory data
Name the analysis and choose one currency for all costs.
Enter up to 100 products, each with a name, optional SKU, annual units used and unit cost. Use the same annual period for every product.
For a spreadsheet list, use the import control to paste or upload CSV columns named Product, SKU, Annual units and Unit cost. Review the imported rows.
Choose the cumulative A and B cutoffs. The defaults are 80% and 95%; A must be above zero, B must be higher than A, and both must be below 100%.
Review the ranked table, shares and classes, then download CSV or text, or print the analysis.
Units can have up to three decimal places and costs up to two. Each value can be between zero and 1,000,000. A SKU is optional, but supplied SKUs must be unique so the same code does not describe multiple rows.
What the ABC analysis measures
Annual usage value = annual units used × unit cost
Value share = product annual usage value ÷ total annual usage value × 100
The ASCM Supply Chain Dictionary describes ABC classification as grouping items after ranking them by annual value or another criterion. This tool uses annual usage at cost. It does not rank sales revenue, gross profit, stock on hand or the consequences of a stockout.
The cutoffs are percentages of cumulative value, not percentages of product count. Setting A to 80% does not mean 80% of your products will be class A.
How boundaries and equal values work
Products are sorted from highest to lowest annual usage value. Equal-value products stay together in one class and retain their input order. Each group is classified using the cumulative share before that group: below the A cutoff is A, below the B cutoff is B, and the remainder is C.
The group that crosses a boundary therefore remains in its starting class. A class can end above its cutoff. This prevents two products with identical annual value receiving different classes simply because of row order.
When the total value is positive, zero-value products are C. If every product has zero annual value, the tool marks all products unclassified because there is no positive total from which to calculate meaningful shares.
Worked example
The sample uses 80% and 95% cutoffs:
Product
Annual units
Unit cost
Annual usage value
Class
Canvas tote
1,000
$8
$8,000
A
Travel mug
400
$10
$4,000
A
Notebook
500
$4
$2,000
B
Greeting card
600
$1
$600
B
Gift bag
400
$1
$400
C
The total is $15,000. The first two products reach exactly 80%. Notebook begins at 80%, so it enters B. Greeting card begins at about 93.33%, below the 95% boundary, and also enters B; together A and B reach about 97.33%. Gift bag begins above 95% and enters C.
Use the result to choose which products deserve closer review, then apply practical knowledge about critical items and unreliable supply. The cycle count planner can turn chosen groups into a dated count schedule. The stocktake tool records actual quantities separately.
Frequently asked questions
Does class A mean the most profitable products?
No. This calculation uses annual units multiplied by cost. A high-cost item can rank highly even when its margin is low. Profitability needs sales and cost information beyond this model.
Can I use a different currency?
Choose from the currencies shown in the form and enter every unit cost in that currency. The selection labels the amounts; it does not convert imported values.
Does it update inventory or keep a permanent analysis?
No inventory records are changed. The draft stays in this browser tab when storage is available. Download or print it before closing the tab or replacing the sample.