ABC Analysis Calculator

ABC Analysis sorts your inventory by how much value each item contributes, then splits it into three tiers — A, B, and C — so you can focus your limited attention where it matters most. It's a direct application of the Pareto principle: in most inventories, a small share of items accounts for the large majority of value.

Without a tiering system, businesses tend to treat every SKU the same — same cycle count frequency, same service level target, same level of scrutiny on the supplier. That's a poor use of effort. A handful of A-items might represent 80% of your annual inventory value; they deserve tight tracking, frequent counts, and careful reorder planning. The long tail of C-items, individually low-value, can usually be managed with much simpler, looser rules — freeing up real time and attention for what actually moves the needle.

ABC Analysis is used by inventory managers, planners, and procurement teams with any meaningfully large SKU count — it's especially valuable the moment "treat everything the same" stops scaling, which for most businesses is somewhere between a few dozen and a few hundred items.

ABC Analysis isn't a single formula so much as a sorting and bucketing procedure:

1. Sort all items descending by annual value (unit price × annual usage, or however you define "value" for your business).
2. Walk the sorted list, accumulating a running total of value as you go.
3. Classify each item by where its running total lands as a percentage of the grand total:

• A items — cumulative percentage up to 80% (highest value, tightest control)
• B items — cumulative percentage from 80% to 95% (moderate value, normal control)
• C items — cumulative percentage from 95% to 100% (lowest value, loose control)

The 80/95 cutoffs are a common convention, not a law of nature — some organizations use 70/90 or other splits depending on how concentrated their value distribution actually is. What matters is that the tiers meaningfully separate "the few items that matter most" from "the long tail."

Scenario: Four inventory items, total annual value $100,000
Item 1: $50,000  ·  Item 2: $30,000  ·  Item 3: $15,000  ·  Item 4: $5,000

Items 1 and 2 make up just half your item count but 80% of total value — they're your priority for tight inventory control.

Now scale this up to a more realistic retail catalog of 1,000 SKUs. A typical distribution might look like this:

In this catalog, 15% of SKUs (the A items) drive 80% of value — the classic Pareto shape. Those 150 items justify frequent cycle counts and tight reorder discipline; the 600 C-items can likely be checked quarterly with simple min/max rules instead.

ABC Analysis assumes:

• Annual value is a reasonable proxy for business importance
• Value data (price × usage) is accurate and reasonably current
• The distribution is meaningfully skewed — a handful of items driving most of the value

Question the result when:

• Value isn't the only thing that matters — a low-value item that's critical to keep a production line running (a $2 bolt that halts assembly if missing) may need A-item treatment regardless of its dollar value
• Your catalog is small — with only a handful of SKUs, elaborate tiering adds process overhead without much benefit
• Value is highly seasonal — a strict annual-value cutoff can misclassify items that spike briefly but matter enormously during that window

Common mistake: treating ABC classification as permanent. Item value shifts as prices change, products get discontinued, and demand evolves — a classification run once at launch and never refreshed drifts out of date.

Classifying items and then doing nothing differently.The most common mistake by far — running the analysis, printing out the A/B/C labels, and then applying the same cycle count schedule to everything anyway. The whole point is to treat A-items differently: tighter counts, tighter safety stock, closer supplier oversight. If the policy doesn't change, the analysis was just busywork.

Classifying on stale or partial data. Last year's prices, or three months of usage instead of a full representative period, and the tiers come out wrong. Use current pricing and enough history to actually reflect how the item moves.

Ignoring criticality. A two-dollar bolt that halts the assembly line if it's missing doesn't care that it's a C-item by dollar value. Combine ABC with a separate criticality flag for parts where the stockout cost is way out of proportion to the price tag.

Never re-running it. Products get discontinued, prices move, demand shifts — a classification from launch day is stale within a year. Re-run it quarterly, or whenever the catalog changes meaningfully.

Applying the 80/95 cutoffs without checking your own data.Those numbers are a convention, not a law. If your value distribution is flatter than the classic Pareto shape, the standard cutoffs won't separate much of anything — worth checking before you commit to them.

The 1,000-SKU example above (15% of items driving 80% of value) is a textbook Pareto distribution. If your own catalog comes out flatter — say, 40% of items needed to reach 80% of value — that's a useful signal in itself: your inventory value is spread more evenly, and aggressive A-item tiering may deliver less benefit than usual.

Once items are classified, put the tiers to work:

1. Tier your safety stock policy — set tighter service levels for A-items, looser for C-items.
2. Prioritize cycle counts — verify Inventory Accuracy most often on the items with the most value at stake.
3. Scrutinize A-item suppliers more closely — use the Supplier Scorecard to hold critical suppliers to a higher bar.
4. Compare turnover within tiers — an A-item with low turnover deserves more attention than a C-item with the same ratio.

• Inventory AccuracyA-items deserve the most frequent, most accurate cycle counts.
• Safety StockTier your service level target by A/B/C category.
• Supplier ScorecardHold suppliers of A-items to a stricter performance bar.
• Inventory TurnoverCompare turnover within each ABC category, not just overall.

Books:

• Supply Chain Management: Strategy, Planning, and Operationby Sunil Chopra
• Inventory and Production Management in Supply Chains by Edward Silver, David Pyke, and Douglas Thomas

Standards & curricula:

• APICS (ASCM) CSCP certification curriculum

Online courses:

• Coursera: "Supply Chain Management" (Michigan State University)
• edX: "Operations Management Fundamentals"

These are general references for further study, not endorsements — verify course availability and content directly with the provider.