What is ABC analysis? Meaning, calculation, and how to run team-based continuous improvement of your measurement

"I want to focus on best sellers, but I only know by gut feel which products are truly important." "I spread inventory and promotion budget evenly across all products, so my resources are scattered." ABC analysis is useful for organizing these concerns. ABC analysis is a method that classifies items into three groups A, B, and C in descending order of a metric such as sales or inventory, and applies differentiated management according to importance.

This article systematically explains ABC analysis from its meaning and the underlying Pareto principle, through a concrete calculation method you can do in Excel, the A/B/C classification criteria, and the situations where it applies along with its cautions. It then goes further into something many explainer articles skip: how to run team-based, continuous improvement of your measurement so you don't "analyze once and stop." By the end, you should be able to run ABC analysis on your own data starting tomorrow.

What is ABC analysis? Clarifying its meaning and purpose

ABC analysis is an analytical method that arranges a metric such as sales, profit, quantity sold, or inventory value in descending order, and classifies items into three ranks A, B, and C according to their cumulative composition ratio. Because it sets management priority in order from the most important, it is also called "priority analysis." It originally arose in the field of inventory management, but is now used in a wide range of scenes such as identifying best sellers, customer management, quality control, and cost analysis.

The purpose of ABC analysis is to concentrate limited resources (people, time, money, sales floor, inventory space) on the items that contribute most to results. Rather than treating all products and customers equally, you change the allocation of management effort and cost according to contribution. The value of ABC analysis lies in being able to show this "selection and concentration" decision axis with data rather than gut feel.

What ABC analysis reveals

When you perform ABC analysis, the following mainly become visible.

Which few important products (Rank A) generate the majority of sales or profit
Which products (Rank C) contribute little relative to the management effort and should be considered for consolidation or reduction
The distinction between items that should be prioritized to hold as inventory and items that can be narrowed down
Where to concentrate resources such as promotion budget, shelf allocation, and order frequency

Situations suited and not suited to ABC analysis

ABC analysis demonstrates its power in situations where "there are many items and contribution varies." Representative examples are retail/EC with many SKUs, wholesale/BtoB with many clients, and inventory management in manufacturing with many SKUs. On the other hand, when there are only a few products, or when all items are equally important strategically, classifying them produces little differentiation and the effect is limited. Also, slicing by a single metric alone tends to undervalue new or seasonal products, so judging the applicable situation is important.

The Pareto principle underlying ABC analysis

Indispensable to understanding ABC analysis is its theoretical foundation, the Pareto principle. The Pareto principle is an empirical rule proposed by the Italian economist Vilfredo Pareto that "most of the overall result is generated by a small portion of the elements," also called the "80:20 rule" or the "2:8 rule."

Applied to business, it can be expressed as "about 80% of sales is generated by roughly the top 20% of all products." On this view, simply managing the top 20% of products intensively lets you effectively address 80% of sales. ABC analysis can be said to be a method that translates this Pareto principle into a form you can operate in practice, drawing the A/B/C boundaries based on cumulative composition ratio to set priorities.

That said, 80:20 is only a guide. In actual data it is not unusual for it to be closer to 70:30 or 90:10. Rather than memorizing the ratio itself, it is important to grasp the essence: "contribution is skewed, and you visualize that skew and use it in management."

How to calculate and perform ABC analysis [5 steps]

ABC analysis can be carried out without special tools as long as you have Excel or a spreadsheet. Here we explain the basic procedure using sales as the metric, in five steps.

Step 1: Decide the analysis target and metric

First, decide "what" to analyze and "by which metric." The target is products, product categories, customers, clients, and so on. Choose the metric according to your purpose: if you want to see sales scale, sales amount; if profitability, gross profit; if inventory efficiency, inventory value or shipment quantity are suitable. Because a mismatch between purpose and metric leads to a wrong conclusion, this initial design is the most important.

Step 2: Sort the targets in descending order of the metric

Sort the targets in descending order by the value of the chosen metric. For example, aggregate the annual sales of each product and arrange the products with larger sales at the top. At this point, the rough trend of which products come at the top begins to emerge.

Step 3: Calculate the composition ratio and cumulative composition ratio

Next, calculate the proportion (composition ratio) that each target's value occupies in the whole. The formula is simple.

Composition ratio (%) = each product's sales / total sales of all products x 100
Cumulative composition ratio (%) = the value obtained by adding up the composition ratios in order from the top down to that product

For example, if the total sales of all products is 10 million yen and a certain product's sales is 2.5 million yen, the composition ratio is 25%. Adding the composition ratios from the top in the sorted order yields the cumulative composition ratio. The cumulative composition ratio always reaches 100% in the end.

Step 4: Classify into A, B, and C ranks

Based on the cumulative composition ratio, classify the targets into three ranks A, B, and C. Commonly used criteria are as follows.

Rank A: the most important group up to a cumulative composition ratio of 0-70% (or 0-80%)
Rank B: the middle group with a cumulative composition ratio of 70-90% (or 80-95%)
Rank C: the lower group with a cumulative composition ratio of 90-100% (or 95-100%)

These boundaries are not a fixed rule; you may adjust them according to industry, product characteristics, and analysis purpose. What matters is to deliberately draw the line for the "range to manage intensively" for your own company.

Step 5: Visualize with a Pareto chart

Finally, visualize the results in a Pareto chart. A Pareto chart overlays, in the same figure, each target's value as a bar chart (descending order) and the cumulative composition ratio as a line graph. The bars let you grasp individual magnitudes, and the line lets you intuitively see how far you cover most of the whole. You can create it with Excel's combo chart feature, and drawing guide lines at the A/B/C boundaries makes it easier to share within the team.

An ABC analysis calculation example: looking concretely at sales data

To deepen understanding, let's follow the calculation flow using the annual sales of 10 products as an example. Assume total sales of 10 million yen and consider them arranged in descending order. Adding up the composition ratios from the top product yields cumulative composition ratios such as the following.

Product 1: composition ratio 30% -> cumulative 30% (Rank A)
Product 2: composition ratio 22% -> cumulative 52% (Rank A)
Product 3: composition ratio 16% -> cumulative 68% (Rank A)
Product 4: composition ratio 10% -> cumulative 78% (Rank B)
Product 5: composition ratio 7% -> cumulative 85% (Rank B)
Product 6: composition ratio 5% -> cumulative 90% (Rank B)
Products 7-10: composition ratio total 10% -> cumulative 100% (Rank C)

In this example, the top 3 products (30% of the whole) account for about 70% of sales, confirming a skew close to the Pareto principle. You can connect this to decisions such as: the 3 Rank A products focus on preventing stockouts and maximizing unit price and units sold, while for the Rank C product group you lower order frequency, reduce inventory, and in some cases reconsider whether to carry them. The strength of ABC analysis is that simply arranging the numbers makes it clear at a glance where to put your effort.

Examples of using ABC analysis: in inventory, sales, and customer management

By changing the metric and target you apply, ABC analysis can be adapted to a variety of tasks. Here are representative use cases.

Inventory management: preventing stockouts and reducing excess inventory

Perform ABC analysis using shipment quantity or sales as the metric, and change the management method for each rank. Because for Rank A stockouts directly translate into lost opportunities, hold a thicker safety stock and manage so as not to run out, taking order lead time into account. For Rank B, tighten the inventory ceiling somewhat, and for Rank C, curb order frequency and inventory volume to prevent excess inventory. This intensive inventory management is also called "ABC control."

Sales and promotion: concentrating resources on priority products

If you use sales or gross profit as the metric, you can use it to decide which products to concentrate promotion budget, shelf allocation, and advertising investment on. You can build initiatives starting from high-contribution products, such as placing Rank A products in prominent positions on the sales floor, or designing cross-sells anchored on Rank A.

Customer and client management: retaining premium customers and improving efficiency

If you classify customers or clients by sales or profit, you can achieve both retention measures for premium customers and efficiency in handling costs. For example, you assign attentive follow-up and loyalty measures to Rank A customers, and standardized, efficient handling to Rank C customers. In the context of customer analysis, combining it with RFM analysis to capture customers from multiple angles increases accuracy.

Cautions and limitations when performing ABC analysis

ABC analysis is simple and powerful, but misusing it distorts your judgment. Let's get a handle on the points to watch in practice.

Bias of a single metric: classifying by sales alone causes you to overlook products with small sales but high profit margins. Choose the metric according to your purpose, and if needed view it from multiple angles with multiple metrics.
Immediately cutting Rank C is dangerous: new products, seasonal products, and related products bought together with Rank A products can be strategically important even if their current numbers are small. Do not mechanically discontinue them based on numbers alone.
Effect of timing and period: short-period data is skewed by the impact of events and sales. Aggregate over an appropriate period such as a year, and consider seasonality.
Don't stop at classifying: ranking is a starting point; true ABC analysis goes all the way to translating it into initiatives, measuring the effect, and revising.

In particular, that last point not stopping at classifying is the biggest reason ABC analysis becomes a mere formality at many sites. In the next chapter, we explain how to proceed so it continuously leads to results.

How to run team-based, continuous improvement of your measurement

The true value of ABC analysis is demonstrated not by a single classification, but by keeping a "classify -> act -> measure -> reclassify" cycle running. Here we explain practical steps for the team to embed the practice and continuously improve results.

Step 1: Decide initiatives and owners for each rank

For each classified rank, decide "what to do" and "who does it" as a set. Put the policy into words and clarify the owner such as Rank A: prevent stockouts and maximize sales; Rank B: lift performance and find candidates for promotion to Rank A; Rank C: improve efficiency and consolidate. The key is to make the rank-to-action correspondence table a shared language of the team so initiatives don't float away unattended.

Step 2: Set the KPIs for measurement in advance

Before launching initiatives, decide the KPIs for what counts as success. This is because tacking on metrics afterward tends to lead to convenient interpretation. Representative KPI examples are as follows.

Rank A: stockout rate, year-over-year Rank A sales, inventory turnover of Rank A products
Rank B: number of "promotions to Rank A" from Rank B, change in the sales composition ratio of all Rank B
Rank C: reduction rate of management workload, reduction amount of excess inventory value, optimization of the number of Rank C products
Overall: trends in total sales and gross profit, change in the sales ratio held by the top 20%

Step 3: Decide the analysis-cycle frequency and make it routine

ABC analysis only has meaning when updated at a steady rhythm. Decide an update frequency that matches your company's speed of change such as monthly for EC and retail with fast product turnover, or quarterly when inventory management is central and build it into your regular meetings. By checking each time the products whose rank changed since last time (dropped from A, rose from C), you can catch signs of change early.

Step 4: Review with rank changes as the starting point

In measurement, what deserves the most attention is the "change" in rank. If there is a product that fell from Rank A, dig into the cause such as competition, price, or stockouts. Conversely, if there is a product promoted from Rank B to Rank A, put the success factors into words and roll them out horizontally to other products. Recording the rank at the time of the previous analysis and making it possible to compare changes in a list streamlines the review.

Step 5: Accumulate knowledge and reflect it in the next classification

Record and share with the team the insights gained in each cycle about "why it ended up in that rank" and "whether the initiative worked." The accumulated knowledge can be applied to revising the next classification criteria (where to draw the boundaries, which metric to use) and to the early evaluation of new products. Preventing dependence on individuals and building a state where anyone can run it with a certain level of accuracy is the destination of continuous improvement.

In this way, designing your operations around measurement evolves ABC analysis from "analysis that explains the current state" into "a mechanism that continuously improves results." Rather than raising the accuracy of classification, keeping the cycle running without stopping is what directly drives long-term results.

Summary: Make ABC analysis "a continuously running improvement mechanism"

ABC analysis is a method that, based on the Pareto principle, classifies targets into A, B, and C by a metric such as sales or inventory, and optimizes resource allocation according to importance. The calculation can be done in Excel, carried out in five steps: find the composition ratio and cumulative composition ratio, rank the items, and visualize with a Pareto chart. Its range of application is broad inventory management, sales initiatives, customer management and if you keep in mind cautions such as bias toward a single metric and the casual cutting of Rank C, it becomes a powerful decision-making weapon.

And most important of all is not to stop at classifying. Decide initiatives and owners for each rank, measure the effect with KPIs, review rank changes in a regular cycle, and apply the knowledge to the next round by keeping this loop running as a team, ABC analysis becomes a mechanism for continuous improvement of results. Start by classifying your own sales data once, and putting the date of the next update on your calendar.