fbpx
Articles Glossary Guide
30.03.2023
224

What is ABC Analysis, and Why is it Important in Category Management

ABC analysis in category management is a method of classifying products by priority based on selected criteria, where A represents high priority, B is medium priority, and C means low priority.

ABC analysis is based on the Pareto principle (the 80/20 rule), which states that 20% of efforts produce 80% of results. In category management, this means that 20% of all products generate 80% of sales.

The Advantages of Using ABC Analysis

The purpose of ABC analysis is to structure the assortment and determine the priority products or categories within it.

By dividing the assortment into segments based on their A/B/C status, you can focus and understand how to achieve a particular KPI, and which tasks need to be started right now. For example, which products or categories can increase turnover and profit or how to optimize inventory.

ABC analysis is based on retrospection, that is, on historical data. However, the market is changeable, and it can be influenced by various factors. Therefore, to build a more accurate predictive model, ABC analysis is combined with XYZ analysis, which shows the variability of demand for products.

ABC Analysis: A Step-by-Step Tutorial

Step 1. Set a goal.

Specify the purpose behind conducting the analysis. There are different options:

  • optimize the assortment and increase profitability;
  • update the supply plan;
  • stimulate remnant inventory sales;
  • segment products to create special offers for different groups.

Step 2. Select objects for analysis.

These can be products within a category, as well as categories, segments, or brands.

To ensure more accurate results, avoid incorporating new products into the ABC analysis, as there isn’t enough accumulated information about them yet. Also keep in mind that promotional items distort statistics, as they may sell better thanks to special prices. So you need to focus on a wider range of data over time.

Step 3. Define criteria.

The indicators that are usually used for the assortment ABC analysis are:

  • number of sales, in units;
  • profit, in USD;
  • turnover, in USD;
  • stock balances, in units;
  • advertising expenses, in USD;
  • other expenses, in USD.

Choose one of these indicators, the most suitable to the goal of your analysis, as well as the data sample for the relevant period.

Step 4. Use Excel or Google Sheets to enter data.

We have prepared an example of ABC analysis in Google Sheets. In our case, the object is a product, and the analysis criteria is the number of sales.

Enter the values of the calculated parameter (column B).

Step 5. Sort the results in this column from the highest value to the lowest.

Step 6. Calculate the total result.

Step 7. Calculate the share for the first product using the formula:

The share of one product = number of sales of one product / total sales of all products.

In our example, this is column C. The formula will be as follows:

C2 = B2/B$33

Extend the formula to all cells. The total should be 100%.

Step 8. Calculate the cumulative share for each product by adding its share to the share of the previous product.

For the first product on the list, the cumulative share will be the same as in the previous column.

In our example:

D2=C2

And then, cumulatively:

D3=C3+D2

D4=C4+D3

D5=C5+D4 (…)

For the last product on the list, the cumulative share will be 100%.

Step 9. Segment the obtained results into groups.

Group A — focus positions that need to be given more time for deeper analysis based on the set goal. The value of the cumulative share is in the range of 0 to 80%.

Group B — positions with the potential to move into both Group A and Group C. The value of the cumulative share is in the range of 80 to 95%.

Group C — positions that should be eliminated. This may include new items if you are conducting sales ABC analysis because statistics on them have not yet been accumulated. The value of the cumulative share is in the range of 95 to 100%.

How to Apply the Results of the ABC Analysis

After completing the calculations, you can use your final data, for example, to review the inventory situation. To do this, add a column called “Quantity in stock, in units.” Then you can see that, for example, class A items are not in stock based on the quantity sold, while class C items are in excess, and adjust your inventory policy accordingly.

Example of Using Tags A, B, and C in Pricer24

In Pricer24, you can manually assign A, B, and C tags to products and counterparties. For example, our vendor clients use A, B, and C tags to better focus on analyzing the presence of their products on partner shelves. If you have 20 partner stores and three of them account for 80% of sales (meaning these are class A partners), then it is obvious that a stockout in these three stores will affect the brand’s sales overall.

ABC analysis can be very effective as a simple way to focus and prioritize. Especially when you have limited resources: money, time, people, warehouse space, etc.

However, the ABC classification is too simplified because the evaluation criteria are one-dimensional. By prioritizing based on only one indicator, you lose sight of others.

In addition, ABC analysis relies only on historical data, and its results don’t consider market variability. To overcome this inaccuracy, you can implement ABC/XYZ analysis.

Stay tuned

Get blog news updates

    Take a consultation
    • Market analytics
    • Price parsing
    • Product visibility
    Take a consultation
    • Market analytics
    • Price parsing
    • Product visibility
    Share it:

    Get expert advice

    Submit your application to see the demo and make sure that the service fits your needs



      Privacy policy

      Your privacy is very important to us. We want your work on the Internet to be as pleasant and useful as possible, and you quite calmly used the broadest range of information, tools and opportunities that the Internet offers.

      The personal information of the Members collected at the time of registration (or at any other time) is mainly used to prepare the Products or Services in accordance with your needs. Your information will not be transferred or sold to third parties. However, we may partially disclose personal information in special cases described in the “Consent with the mailing”

      What data is collected on the site

      At voluntary registration on reception of dispatch you send the Name and E-mail through the registration form.

      What is the purpose of this data?

      The name is used to contact you personally, and your e-mail for sending you mailings of newsletters, news, useful materials, commercial offers.

      Your name and e-mail are not transferred to third parties, under any circumstances, except for cases related to the compliance with the requirements of the law.

      You can refuse to receive mailing letters and remove your contact information from the database at any time by clicking on the unsubscribe link present in each letter.

      How this data is used

      With the help of these data, information on the actions of visitors on the site is collected in order to improve its content, improve the functionality of the site and, as a result, create high-quality content and services for visitors.

      You can change your browser settings at any time so that the browser blocks all files or notifies you about sending these files. Note at the same time that some functions and services will not be able to work properly.

      How this data is protected

      To protect your personal information, we use a variety of administrative, management and technical security measures. Our Company adheres to various international control standards aimed at transactions with personal information, which include certain control measures to protect information collected on the Internet.

      Our employees are trained to understand and follow these control measures, they are familiarized with our Privacy Notice, regulations and instructions.

      Nevertheless, despite the fact that we are trying to protect your personal information, you too must take measures to protect it.

      We strongly recommend that you take all possible precautions while on the Internet. The services and websites that we organize include measures to protect against leakage, unauthorized use and alteration of the information we control. Despite the fact that we are doing everything possible to ensure the integrity and security of our network and systems, we can not guarantee that our security measures will prevent illegal access to this information by hackers from outside organizations.

      If this privacy policy is changed, you will be able to read about these changes on this page or, in special cases, receive a notification on your e-mail.