About 80 percent of the money sitting on your shelves is tied up in roughly 20 percent of your SKUs. The rest — often more than half your product list — accounts for a sliver of your inventory value. If you count, order, and watch every item the same way, you are spending most of your effort on the stock that matters least, while the handful of items that actually drive your cash flow get the same cursory glance as a box of screws.
ABC inventory analysis fixes that mismatch. It ranks every SKU by annual consumption value, splits the list into three bands, and tells you exactly where tight control pays off and where it is wasted effort. This guide walks through the calculation step by step, shows what to do differently for A, B, and C items, and covers the ABC-XYZ upgrade that stops you from overstocking slow, unpredictable sellers.
What ABC Analysis Actually Measures
ABC analysis classifies inventory by annual consumption value: how much money flows through each SKU in a year.
Annual consumption value = annual units sold (or used) × unit costNote that it is unit cost, not selling price. You are measuring how much of your cash is committed to each item, not how much margin it earns. A bottle of premium olive oil that sells 200 units a year at a $14 cost has an annual consumption value of $2,800. A store-brand vinegar that sells 2,000 units at a $1.10 cost has a value of $2,200. Similar numbers — but most product lists are not similar at all. They follow a Pareto pattern:
- A items: roughly the top 10 to 20 percent of SKUs, driving 70 to 80 percent of total consumption value. Few items, big dollars.
- B items: roughly the next 20 to 30 percent of SKUs, driving 15 to 20 percent of value. The middle ground.
- C items: roughly the bottom 50 percent of SKUs, driving about 5 percent of value. Most of your product list, a fraction of your money.
The exact cutoffs are yours to choose — some businesses use 80/15/5 on cumulative value, others use 70/20/10. What matters is that the ranking is by measured consumption value, not gut feel about which products are "important."
How to Run the Calculation in Five Steps
You can do this in a spreadsheet in an afternoon. Pull twelve months of sales or usage history first; a shorter window lets seasonality distort the ranking.
1. List every active SKU with its unit cost
One row per item. Use landed cost (purchase price plus freight, duties, and packaging) rather than the supplier's list price, or imported goods will look cheaper to hold than they are. Include raw materials and components if you manufacture — the method works for inputs as well as finished goods.
2. Compute annual consumption value for each row
Multiply each SKU's annual units by its unit cost. This single column is the entire analysis; everything after it is sorting and arithmetic.
3. Sort descending and add cumulative percentages
Sort the list from highest consumption value to lowest. Then add two running columns: cumulative consumption value and that cumulative total as a percentage of the grand total. The first row might read "4.1% of SKUs, 31% of value" — that steep early climb is the Pareto curve doing its work.
4. Draw the A/B and B/C lines
Walk down the cumulative-value column and cut where it crosses your chosen thresholds. With an 80/15/5 split, every SKU above the 80% cumulative line is an A, everything between 80% and 95% is a B, and the long tail below is a C. Expect the A list to be short enough to print on one page. If it is not, your thresholds may be too loose — or your assortment genuinely is flat, which is itself useful information.
5. Sanity-check the edges
Look at the items sitting right on each boundary. A high-cost spare part you sell twice a year can land in A on unit cost alone; a consumable you sell thousands of can land in C. Both may be correctly classified — but flag anything whose class surprises you and confirm the usage data before you build policies on it.
A ten-SKU example shows the shape. Suppose your ranked list totals $100,000 in annual consumption value: the top two SKUs contribute $52,000 and $21,000 (A items, 73% of value from 20% of SKUs), the next three contribute $9,000, $6,000, and $4,000 (B items, 19%), and the remaining five split the last $8,000 (C items, 8%). Two items deserve daily attention; five deserve almost none. That is the whole point.
What Each Class Means for Daily Operations
Classification without different treatment is trivia. The payoff comes from running three different playbooks.
A items: tight control, frequent review
These SKUs deserve your best forecasting, your tightest reorder discipline, and your fastest response to discrepancies. Practical rules:
- Review stock positions weekly, or continuously if your system supports it.
- Keep safety stock lean but service levels high — a stockout here costs real revenue, so favor frequent small replenishments over bulk buys.
- Negotiate these SKUs hardest with suppliers: lead-time reductions and consignment terms on A items free more cash than any other purchasing work.
- Investigate every count discrepancy immediately. Shrinkage and data errors on A items distort your balance sheet the most.
B items: standard control, periodic review
B items get competent, routine management — nothing heroic, nothing neglected. Monthly reviews, standard reorder points, normal safety stock. This is also the class to watch for migration: a B item climbing toward A on growing demand should be promoted at your next review, not left on autopilot.
C items: simple control, minimal touches
C items should consume as little staff time as possible. Order in bulk once or twice a year where shelf life allows, use visual two-bin systems instead of system-driven reorders, and accept slightly higher days of supply — the carrying cost on 5% of your inventory value is trivial compared with the labor of managing hundreds of SKUs precisely. The classic failure here is spending $40 of staff time to optimize a $30 annual spend.
Turn the Classes Into a Cycle-Count Schedule
Full physical shutdowns exist because businesses never trust their records. ABC analysis plus cycle counting is how you earn that trust back: count a few SKUs every day, weighted by class, instead of everything once a year.
A common starting schedule:
- A items: count monthly, or weekly for the very top SKUs. Resolve discrepancies the same day.
- B items: count quarterly. Resolve discrepancies within the week.
- C items: count once or twice a year. Adjust and move on.
Size the daily workload so one person can finish it in under an hour — take each class count, divide by the number of working days in its cycle, and that is the daily quota. Track accuracy by class, not just overall: 98% overall accuracy can hide 90% accuracy on A items if the C tail is spotless, and it is the A accuracy that protects your financials. Many auditors will accept well-documented cycle counts in place of a wall-to-wall count once accuracy by class stays high for several consecutive cycles.
Turn the Classes Into Reorder Rules
Counting tells you what you have; reorder policy tells you what to buy. Differentiate that too:
- A items: short review cycles with small, frequent orders. Calculate safety stock from actual demand variability and lead-time variability rather than rules of thumb. Consider automated reorder points tied to live sales data.
- B items: periodic review (monthly is typical) with standard lot sizes. Economic order quantity math earns its keep here — moderate value, moderate volume, worth one calculation per SKU per year.
- C items: large, infrequent orders driven by supplier minimums and freight efficiency rather than demand forecasts. For the cheapest consumables, a two-bin system (open the second bin, order a refill of the first) beats any software reorder point.
And then there is the class the textbook politely skips: the D list — SKUs with zero or near-zero consumption that your analysis surfaces at the very bottom of C. Every C tail hides dead stock: discontinued variants, over-ordered seasonal goods, spare parts for equipment you no longer own. Mark them down, bundle them, donate them, or write them off — but stop paying rent to store them. A quarterly clearance review of the bottom of the C list typically frees more warehouse space than any reorganization project.
The ABC-XYZ Upgrade: Add Demand Predictability
Pure ABC analysis has a blind spot: it ranks by value while ignoring variability. A high-value SKU with steady weekly demand and a high-value SKU that sells in random bursts are both "A" — but they need opposite treatment. XYZ analysis adds the second axis:
- X: steady, predictable demand. Forecasts work; lean stock is safe.
- Y: seasonal or moderately variable demand. Forecasts work with buffers.
- Z: erratic, unpredictable demand. Forecasts fail; you choose between buffer stock and stockouts.
Cross the two axes into a nine-cell matrix and the policies write themselves. AX items (valuable, predictable) run lean with high service levels — the ideal just-in-time candidates. AZ items (valuable, erratic) are your highest-risk SKUs: they need management attention, buffer stock or make-to-order treatment, because a surprise spike stockouts your best seller. CX items (cheap, predictable) can be bought in bulk annually and forgotten. CZ items (cheap, unpredictable) are the first candidates for delisting or made-to-order status — low value, high hassle, and every unit of safety stock is a guess.
You do not need fancy statistics to start. For each SKU, divide the standard deviation of monthly demand by its average (the coefficient of variation): low ratios are X, high ratios are Z. Even a rough three-way split on gut feel plus sales history beats ignoring variability entirely.
Mistakes That Quietly Break the Analysis
Classifying by margin or revenue instead of consumption value. A 70%-margin accessory that sells $3,000 a year is not an A item; a 12%-margin staple moving $200,000 of your cash is. Margin matters for pricing decisions, not for inventory control. Run the ranking on cost-based consumption value and keep margin analysis separate.
Running it once and framing the result. Demand shifts, costs change, and new SKUs arrive unclassified. Re-run the full ranking at least annually, and review class boundaries quarterly — promoting climbers and demoting fading items takes minutes once the spreadsheet exists.
Treating C as "unimportant." Low value is not low consequence. A fifty-cent gasket that halts your production line, or the free adapter a customer needs to use your flagship product, can be the most operationally critical SKU you stock. Tag critical-lifeline items explicitly and manage them above their class.
Applying one service level to everything. A blanket 98% availability target over-stocks the C tail enormously. Set service levels by cell of the matrix — 98%+ for AX, lower for CZ — and watch total inventory value fall while availability of what matters stays flat or rises.
Letting new SKUs sit unclassified. Every new product should get a provisional class at launch (usually B, until data says otherwise) and a first real classification after three to six months of history. Unclassified SKUs default to whatever your system's generic policy is, which is how a runaway new seller stocks out in week three.
Keep the Analysis Honest in Your Books
ABC analysis runs on data from your accounting — unit costs, quantities, write-downs — so its output is only as trustworthy as your inventory ledger. Two habits keep it honest. First, book dead-stock write-downs promptly instead of letting obsolete C items sit at full cost; stale carrying values inflate both your balance sheet and the next ranking. In a plain-text ledger the entry is explicit and reviewable:
2026-10-16 * "Write down discontinued SKUs from Q3 C-list review"
Expenses:Inventory-WriteDown 1,840.00 USD
Assets:Inventory:FinishedGoods -1,840.00 USDSecond, keep A-item costs precise. Landed-cost components (freight, duties, packaging) booked to generic expense accounts instead of inventory understate consumption value and can demote a true A into B. If you track inventory in Beancount, the booking documentation covers how to attach these costs to inventory lots so your per-SKU numbers reflect reality.
Your Next Step
Export twelve months of SKU-level sales and costs this week, compute one column of annual consumption values, and sort. Before you build any policy, just look at the top of the list: most owners find one or two A items they have been managing casually and a C tail full of SKUs they have been managing anxiously. Promote the first group to weekly attention, demote the second to bulk simplicity, and schedule the C-list clearance review — the ranking takes an afternoon, and the clarity lasts all year.
