Free tool
ABC analysis calculator: classify inventory A, B, C
ABC analysis ranks every SKU by annual value and splits the catalog into class A, the few SKUs carrying about 80% of it, class B, the next 15%, and class C, the long tail, for planners and online sellers deciding where control pays. Paste or type SKUs with annual units and unit cost, or annual revenue, to see each SKU's class; nothing you enter leaves your browser.
- Free to use
- No sign-up
- Formula shown
- Updated as you type
Your SKUs
Type SKUs, or paste rows from a spreadsheet or CSV into any cell: SKU, annual units and unit cost, or SKU and annual value. Copied cells without SKUs, such as one column, fill from the column you paste them into. Nothing you enter leaves your browser.
| SKU | Annual units | Unit cost | Class | Remove |
|---|---|---|---|---|
| A | ||||
| A | ||||
| A | ||||
| B | ||||
| B | ||||
| B | ||||
| C | ||||
| C | ||||
| C | ||||
| C |
Class A share of annual value
81.6%
- Class A: 3 SKUs (30%)
- $204,000 (81.6%)
- Class B: 3 SKUs (30%)
- $34,500 (13.8%)
- Class C: 4 SKUs (40%)
- $11,500 (4.6%)
- Total annual value
- $250,000
| SKU | Annual value | Cumulative | Class |
|---|---|---|---|
| MIXER-5QT | $112,000 | 44.8% | A |
| ESPRESSO-1 | $68,000 | 72% | A |
| KNIFE-SET | $24,000 | 81.6% | A |
| DUTCH-OVEN | $16,000 | 88% | B |
| SKILLET-12 | $11,000 | 92.4% | B |
| BOARD-OAK | $7,500 | 95.4% | B |
| CUPS-SET | $5,000 | 97.4% | C |
| TOWEL-4PK | $3,500 | 98.8% | C |
| SPATULA | $2,000 | 99.6% | C |
| OPENER | $1,000 | 100% | C |
A SKU is class A while the value ranked above it is still under 80%, so the SKU that carries the total past the cut-off is A too. Ties rank by annual units, then by row order.
What is ABC analysis in inventory management?
ABC analysis in inventory management ranks SKUs by annual value and splits them into three classes, A, B and C, so the few items that carry most of the value get the closest control.
It applies the Pareto principle to a catalog: in most businesses a small share of SKUs, often 10% to 20%, carries around 80% of inventory value, and the long tail carries little. Class A gets the tightest control, with frequent counts, a planner's regular review and measured lead times; class B gets standard rules; class C gets the lightest touch that still keeps it on the shelf. In this page's worked example, 3 of 10 SKUs carry 81.6% of the value.
ABC analysis formula and cut-offs
Annual value = annual units × unit cost; rank SKUs from the highest value down, add up the cumulative share, and cut at 80% for class A and 95% for class B.
A stand mixer selling 400 units a year at a $280 unit cost has an annual value of $112,000. Across the example's 10 SKUs the total is $250,000, so the mixer alone is 44.8% of value, and the first three SKUs bring the running total to 81.6%. The third SKU starts at 72%, under the 80% cut-off, so it is class A even though it carries the total past 80%: the SKU that crosses the line belongs to the higher class, which is the rule Skuvelo uses. Some spreadsheets instead put a SKU in A only when its own cumulative % is 80% or less, which would make that third SKU class B. A SKU with no annual value is always class C.
How to use ABC classes for reorder points and cycle counts
Use the class to set how closely you watch a SKU: count class A most often and check its reorder point most carefully, and let class C run on simple rules.
For cycle counts, a common cadence is class A monthly, B quarterly and C twice a year, which is Skuvelo's starting schedule (every 30, 90 and 180 days), with the tightest count tolerance on class A. For reorder points, the class tells you where accuracy pays: an A item's demand and lead-time variability deserve a measured safety stock calculation, while a C item can often run on a min/max. The class is not the service level, though. Choose that from what a stockout costs against what holding a unit costs with the service level calculator, then set the trigger with the reorder point formula.
ABC analysis formula: annual value, cumulative % and cut-offs
Annual value = annual units × unit cost
Share = SKU annual value ÷ total annual value of every SKU
Cumulative % = running total of shares, ranked from the highest annual value down
Class A = the SKUs that make up the first 80% of value; class B = the next 15%, to 95%; class C = the rest
- Annual value
- What a SKU moves in a year at cost (annual dollar usage), or its revenue if you rank on sales. Use one basis for every SKU.
- Cumulative %
- The share of total value held by this SKU and every SKU ranked above it.
- Cut-off
- Where one class ends. A SKU stays in a class while the value ranked above it is still under that class's cut-off, so the SKU that carries the total past 80% is class A.
- Class C
- The long tail, plus every SKU with no annual value.
Worked example
- Each SKU's annual value is annual units × unit cost: MIXER-5QT sells 400 × $280 = $112,000, down to OPENER at 500 × $2 = $1,000. The 10 SKUs total $250,000.
- Ranked from the highest value down, the cumulative share runs 44.8%, 72%, 81.6%, 88%, 92.4%, 95.4%, 97.4%, 98.8%, 99.6%, 100%.
- Class A ends at 80%: MIXER-5QT, ESPRESSO-1, KNIFE-SET, 3 SKUs (30% of them) carrying 81.6% of value. KNIFE-SET starts at 72%, under the cut-off, so it is class A although it carries the total to 81.6%.
- Class B ends at 95%: DUTCH-OVEN, SKILLET-12, BOARD-OAK, with 13.8% of value. The other 4 SKUs are class C with 4.6%, among them CUPS-SET, which sells more units than any other SKU (1,000) but adds only $5,000 of value.
When it applies
- Deciding how often to cycle count each SKU: class A monthly, class C once or twice a year.
- Deciding where a planner's time goes: which SKUs get a weekly review of demand and lead time, and which reorder on simple rules.
- Catalogs from a few dozen to tens of thousands of SKUs where value is concentrated in a few items, the usual case in retail and ecommerce.
When it breaks down
- New products with less than a year of sales: their annual value is understated, so they land in C while they are still ramping up.
- Cheap but critical items, such as a component a best seller cannot ship without: value says C, the business says A. Override the class for those by hand.
- Demand variability: ABC says nothing about how predictable a SKU is. Two class A SKUs can need very different safety stock, which is what an XYZ split by coefficient of variation adds.
Common mistakes
Ranking by units instead of value
The SKU that sells the most units is often a cheap one. In this page's example the measuring cups sell 1,000 units a year, more than any other SKU, and are class C at $5,000 of annual value. Rank on value, not volume.
Giving class A the highest service level by default
ABC measures where the money is, not what a stockout costs. A high-value A item also costs the most to hold, so the cost-optimal service level for it can be lower than for a cheap C item that a customer cannot do without. Set the service level from what a stockout costs against what holding a unit costs, and use the class to decide how closely to watch the item.
Classifying once and never again
The sales mix moves with seasons, launches and price changes, so last year's A list goes stale. Rerun the analysis at least every quarter on a trailing 12 months of data.
Mixing bases or periods
Revenue for some SKUs and cost for others, or 12 months for one SKU and 3 months for another, ranks the inputs rather than the items. Use one basis and one time window for the whole list.
Questions
What does an ABC analysis calculator tell me?
An ABC analysis calculator tells you which SKUs carry most of your inventory value and which make up the long tail. Enter each SKU's annual units and unit cost, or its annual value, and it ranks them from the highest value down, adds up the cumulative share, and puts the SKUs that make up the first 80% of value in class A, the next 15% in class B and the rest in class C. It also shows how many SKUs fall in each class and what share of value each class holds, so you can see how concentrated the catalog is before deciding where to spend counting and planning time.
What are the standard ABC analysis cut-offs?
The common split is 80/15/5 by value: class A ends at 80% of cumulative annual value, class B at 95%, and class C holds the last 5%. Some teams use 70/20/10, and a catalog with a very long tail may end class A at 70%. The numbers are a convention, not a law; what matters is that class A stays a small group you can watch closely. This calculator starts at 80% and 95% and lets you change both.
Should ABC analysis use cost or revenue?
The textbook basis is annual dollar usage at cost: units used in a year times unit cost, which measures the money that moves through the item. Ranking on revenue is common for sellers who know their sales better than their costs, and it gives a similar order unless margins differ a lot between SKUs, because a high-margin SKU ranks higher on revenue than on cost. Pick one basis and use it for every SKU. Skuvelo's count schedule ranks on 12 months of sales value.
What is ABC XYZ analysis?
ABC XYZ analysis adds a second axis for how predictable demand is. ABC ranks by value; XYZ ranks by the coefficient of variation of demand, the standard deviation divided by the mean, with X steady, Y variable and Z erratic or intermittent. An AX item is valuable and predictable, a good fit for a tight reorder point; a CZ item is low value and erratic, often better ordered on demand or held on a simple min/max. This calculator does the ABC half.
How often should I rerun ABC analysis?
Every quarter is a common rhythm, on a trailing 12 months of data so a seasonal peak does not swing classes back and forth. Rerun it sooner after a big catalog change: a launch, a retired line, or a price change that moves a SKU's value. Skuvelo works the classes out again each day from the trailing 12 months of sales (all of your history when that is shorter), so they keep up without a rerun.
What happens to new products with little sales history?
A SKU launched three months ago has three months of sales, so its annual value is understated and it usually lands in class C. Either annualize its sales to date, or hold it out of the ranking until it has a full year and set its counting and review by hand. Skuvelo holds it out: an item ranks only once its sales history covers the whole window, 12 months or all of your sales history when that is shorter, and until then it shows as not ranked yet and is counted on the class C schedule.
Related
- Safety stock calculation: formula & calculator
- Reorder point formula & reorder point calculator
- Inventory service level calculator
- Min/max inventory calculator
- Inventory turnover ratio calculator
- Let Skuvelo tell you what to count
- Reorder points and safety stock
- Skuvelo vs Prediko
- Skuvelo vs Netstock
- How Skuvelo plans inventory
Published by Skuvelo. Results are estimates computed from the figures you enter, not a reading of your own sales or stock.
A calculator answers once. Skuvelo keeps answering.
This tool computes one number from what you type. Skuvelo computes it continuously, for every SKU, from your own sales and stock.