ABC Analysis Warehouse: Classification, Calculation, Example

80 items sit in the warehouse. Three of them cause almost 80 percent of the annual consumption value. That exact distribution is what ABC analysis makes visible. It shows which items need tight control, where a standard process is enough, and which positions can cost more to order than the material itself is worth.

A reliable evaluation starts with a clear goal:

• Want to manage capital and procurement effort? Sort by consumption value.
• Want to shorten travel paths in the warehouse? Sort by pick frequency.
• Squeeze both goals into one column and you get a clean table with the wrong decisions anyway.

What is ABC analysis in the warehouse?

ABC analysis ranks items by their relative importance into three classes. For classic stock and procurement control, you usually use the annual consumption value:

An expensive item with low annual consumption can reach the same consumption value as a cheap item that leaves the warehouse every day. That is why unit price alone isn't enough. Current stock value answers a different question too: it shows how much capital sits on the shelf today, not how much value an item moves over a full year.

SAP distinguishes, among other things, consumption value and requirement value in material classification. Oracle NetSuite uses annual consumption value, from annual consumption and unit cost, for its ABC categorization. This guide uses that classic variant.

The Pareto principle behind it

In the late 19th century, Vilfredo Pareto observed that a small share of the Italian population held a large share of the land. That observation grew into the Pareto principle, often called the 80/20 rule.

H. Ford Dickie applied Pareto's logic to inventory in 1951, in an essay titled "ABC Inventory Analysis Shoots for Dollars, not Pennies." ABC analysis was meant to help purchasing and warehouse teams focus their limited time on the items with the biggest economic leverage.

80/20 stays a rule of thumb. An assortment can land at 72/18/10, or a single position can already make up 40 percent of the consumption value. The distribution in your own warehouse decides where sensible boundaries sit.

ABC classes: what A, B, and C items mean

"Share of item positions" is the key phrase here. A describes few distinct item numbers, not necessarily a small consumption quantity. A cheap box can land in A because of a high annual quantity. A rarely sold machine can land in B or C despite a high unit price.

Insight from Christoph's practice

On a repleno customer project, we used exactly this classification to sequence the rollout. A supplier had sent us an item list covering all orders from the last twelve months. The switch range accounted for 31 percent of all important orders, followed by distribution board construction at 23 percent and pipes/conduits at 16 percent. In that exact order, we started rolling out repleno and onboarding the items and stock. The customer had previously struggled with missing parts, so the first improvement needed to be visible quickly. Starting with the most frequently ordered product groups covers most of the daily business with limited effort, and shows fastest whether the new process holds up.

Calculating ABC analysis: six steps

1. Set the target metric

Use consumption value if you want to prioritize procurement, tied-up capital, or planning effort. For assortment decisions, revenue or contribution margin can fit better. For storage locations and picking routes, you need a separate movement-based ABC by picks or withdrawals.

2. Standardize the period and pricing logic

Twelve rolling months is a workable start for many businesses. Use the same price type for every item, for example the average unit cost. Subtract returns cleanly and check one-off project orders, promotions, or bulk orders. Otherwise an outlier can push a normal C item into A for months.

The opposite mistake weighs heavier: an item that was out of stock for months shows artificially low consumption and slides into too low a class. The evaluation then measures the gap, not the actual demand. Check known stockouts separately and correct their quantity to the real demand before you calculate.

3. Calculate the consumption value per item

Multiply annual consumption quantity by unit cost. Then add up all item values to get the total consumption value.

4. Sort items descending

The item with the highest annual consumption value goes on top. Only after this sort can you build meaningful cumulative shares.

5. Cumulate value shares and assign classes

As a starting point, you can set A up to 80 percent, B up to 95 percent, and C for the rest. Decide in advance how you handle an item that straddles a boundary. In the example below, the cumulative value decides after each row: up to and including 80 percent A, up to and including 95 percent B, above that C.

6. Review the result

Flag new items, critical spare parts, perishable goods, bulky parts, and items with long lead times. These traits can call for their own stock rule. Update the classes every six months, or quarterly for seasonal or fast-changing assortments.

Worked example: office supplies online retailer

A small online retailer evaluates ten core items. The "annual quantity" column holds warehouse withdrawals from the last twelve months. All values are based on average unit costs.

Three of ten item positions generate 78.4 percent of the consumption value. That's the economic view. For placement in the warehouse, the picture can look different: notepads might get picked more often than office chairs and belong closer to the packing table despite their C value class. That's why the guide on organizing your warehouse uses a movement-based ABC for shorter travel paths.

ABC analysis in Excel

A spreadsheet is enough to get started. Example with annual quantity in column B, unit cost in C, and consumption value in D:

1. Consumption value in D2: =B2*C2
2. Value share in E2: =D2/SUM($D$2:$D$11)
3. Cumulative share in F2: =SUM($E$2:E2)
4. Class in G2: =IF(F2<=80%,"A",IF(F2<=95%,"B","C"))

Sort column D descending before you drag the cumulative-share formulas down. Format E and F as percentages. With multiple warehouse locations, you also need to decide whether to combine items across all sites or classify per site. The same item can be A at the main warehouse and C in a small branch.

Which stock rules fit A, B, and C

The ABC class determines how much control effort is economically justified. It does not decide order quantity or safety stock on its own.

For A items, overstock ties up a lot of capital. Tighter control and reliable stock data pay off. B items should run on the standard process. For C items, the biggest lever often sits in the process itself: placing an order, approving it, and booking goods receipt can cost more internally than the item itself. The guide on C-parts management breaks down that cost logic in detail.

"C" still doesn't mean unimportant. A two-euro gasket can stop a machine or a job. Such parts need a criticality flag and often a higher safety stock. ABC assesses cash flow. Failure impact stays a second axis.

On a repleno project, I ran the ABC analysis for the customer myself: a supplier had sent us an item list covering all orders from the last twelve months. From the order frequencies, I built an ABC analysis and used it to decide which product groups to digitize first. The rest followed in later phases.

Advantages and limits of ABC analysis

Advantages:

• You see which items carry the biggest economic leverage
• A spreadsheet is enough for the first evaluation
• Purchasing, stocktaking, and planning can scale their effort by class
• Classes make large assortments easier to discuss

Limits:

• The method only ever looks at the chosen target metric
• Wrong prices, missing withdrawals, and one-off bulk orders skew the result
• New items without history quickly land in the wrong class
• Fixed percentage boundaries can create artificial cutoffs in small assortments
• Criticality, demand variability, and lead time are missing

Common mistakes in ABC classification

1. Confusing revenue with consumption value.
   Revenue suits sales or assortment questions. For procurement control, cost-based consumption value is usually more meaningful.
2. Reading current stock as an annual value.
   A high stock value can point to overstock. It doesn't show which items generate the most value consumption over twelve months.
3. Copying boundaries blindly.
   80 and 95 percent are starting values. Check whether two nearly identical items get artificially split right at the boundary.
4. Ignoring C items.
   Low value lowers the economically sensible control effort. Critical parts still need a clear availability rule.
5. Never updating classes.
   Prices, demand, and assortment change. Save the period, pricing basis, and calculation date so later evaluations stay comparable.

Combining ABC analysis and XYZ analysis

XYZ analysis adds regularity of consumption to the value dimension. It's measured via the coefficient of variation: divide the standard deviation of consumption quantities by average consumption. The data basis is monthly consumption quantities over at least twelve months.

These boundary values are common for the classes:

• X: coefficient of variation up to 25 percent, constant, well-planned consumption
• Y: coefficient of variation 25 to 50 percent, fluctuating or seasonal consumption
• Z: coefficient of variation above 50 percent, irregular, hard-to-forecast consumption

In a spreadsheet, you calculate this per item over its twelve monthly values with =STDEV.S(B2:M2)/AVERAGE(B2:M2). Some sources set the boundaries at 50 and 100 percent instead of 25 and 50. Both conventions are in use, but they produce different classes. Set your boundaries once and keep them consistent across every evaluation, otherwise two runs aren't comparable.

An AX item has high consumption value and stable demand. You can plan it tightly and procure it often in smaller quantities. An AZ item ties up a lot of value but is hard to forecast; supplier agreements and a deliberate choice between holding stock and ordering to job matter here. A CX item is cheap and needed regularly. Simple min-max, kanban, or two-bin rules usually fit well. A CZ item needs a case-by-case check before you build up stock.

CZ is the hardest combination. Low value and irregular consumption together mean these items neither forecast well nor ever make it to the top of anyone's review list. That's exactly why both failure modes show up here at once: dead stock on items nobody checks, and a stockout on the one CZ item a job suddenly needs. A fixed per-item rule, such as two-bin or a deliberate decision not to stock at all, is more reliable here than trying to predict consumption.

Putting the result into practice

Start with twelve months of consumption data and a consistent unit cost. Calculate the classes, flag critical exceptions, and give each class two or three concrete rules. After a quarter, check whether stock value, shortages, and order effort have gone down.

For the operational side, the guides on inventory management basics, reorder point vs. min-max, and min-max inventory management can help. Calculate the key warehouse metrics after classification with the inventory KPI calculator.