Inventory Management

ABC Analysis — Find Where Your Money Actually Is

ABC Analysis — Find Where Your Money Actually Is

ABC analysis is the fastest way to find out which inventory items deserve your time and which ones are wasting it. It takes 10 minutes with your current sales data. It tells you exactly where 70–80% of your revenue is coming from — and which SKUs you are spending resources on that do not justify the attention.

If you manage more than 20 SKUs and you do not have an ABC classification, you are applying the same level of effort to your worst-performing products as your best. That is not efficiency. That is equal treatment of unequal things.

What ABC Analysis Is and Why It Works

ABC analysis is a categorization method based on the Pareto principle — the observation that roughly 20% of items account for 80% of results. In inventory management, that means a small number of your SKUs are responsible for the majority of your revenue, your profit, or your stock movement.

The classification works like this:

Class% of SKUs% of RevenueManagement Approach
A Items10–20%70–80%Tight controls. Weekly counts. Never stockout.
B Items30%15–25%Moderate controls. Monthly review. Standard reorder.
C Items50–70%5–10%Minimal controls. Quarterly review. Reduce or eliminate.

A items are your business-critical SKUs. They drive almost all of your revenue. A stockout on an A item is a revenue event. C items are the long tail — they exist in your catalog, they take up space, and most of them are not worth the inventory investment they require.

How to Run an ABC Analysis in 10 Minutes

Step 1: Export Your Sales Data

Pull the last 12 months of sales by SKU from your POS, ERP, or inventory system. You need two columns: SKU name and total annual revenue or units sold. That is all.

Step 2: Sort by Revenue — Highest to Lowest

Sort your SKU list from highest to lowest by annual revenue contribution. Do not filter. Do not group. Just sort.

Step 3: Calculate Cumulative Percentage

Add a column for cumulative revenue percentage. Calculate what percentage of total revenue each SKU represents, then add a running total. The SKUs that take you from 0% to 80% of cumulative revenue are your A items.

Step 4: Draw the Lines

Most operations find that their A items are a surprisingly small list. If you have 200 SKUs, your A list might be 15–25 items. Those 25 items are your business. Everything else is supporting cast.

What to Do With Your ABC Classification

For A Items

These get weekly cycle counts. Reorder points reviewed monthly. Safety stock calculated precisely. No guessing on lead times — verify with your supplier every quarter. A stockout on an A item is not acceptable. Build your inventory system around protecting these SKUs first.

For B Items

Standard reorder point management. Monthly review. Safety stock based on average demand variability. These items do not need special attention unless they show signs of moving toward A status — which you should monitor quarterly.

For C Items

This is where most operations leave money on the table. C items accumulate. They sit. They get reordered out of habit. Review your C list quarterly and ask three questions for each item: Is it still selling? Is the margin worth the carrying cost? Would a customer notice if we stopped stocking it?

For items that fail all three, discontinue or liquidate. The carrying cost recovery alone is worth the decision.

ABC Analysis and Carrying Cost

ABC analysis becomes even more powerful when you combine it with carrying cost data. An A item with high carrying cost needs tighter just-in-time ordering. A C item with high carrying cost is a direct drain on your working capital with minimal revenue justification.

Run your ABC analysis first. Then overlay your carrying cost percentage by SKU class. The combination tells you not just which items matter, but which items are expensive to hold relative to the value they generate.

Common Mistakes in ABC Analysis

ABC analysis is not complex. It is a sorted list with lines drawn at 80% and 95% of cumulative revenue. What makes it powerful is what you do after you draw the lines — the differentiated management approach that focuses your best attention on the items that deserve it most.

Use the free Inventory Health Calculator to combine your ABC data with carrying cost and turnover metrics in one dashboard.

Free Supply Chain Tools

Get the free ABC Analysis Template — classify your SKUs in 10 minutes.

A simple template that does the calculation for you. Enter your SKUs and revenue. Get your A, B, C classification instantly.

Share Save to Pinterest Share on Facebook