fbpx
Guide
6.04.2023
2,998

ABC/XYZ Analysis: A Crucial Tool for Inventory Planning

Trade in e-commerce is characterized by high competition and constant expansion of the range of goods. Under such conditions, increasing sales and increasing assortment efficiency directly depend on the correct assessment of each item’s profitability as well as the absence of dependent goods and goods that do not pay off. That is, the category manager must be able to analyze the assortment from the point of view of sales and structure it in such a way as to clearly understand the leaders and outsiders among all product groups. And this is where ABC/XYZ analysis comes to the rescue.

In this article, you will learn how goods are classified in ABC/XYZ analysis, what opportunities it opens up, and why it is indispensable in category management.

Contents:

Objectives of ABC/XYZ Analysis in Category Management

How to Perform ABC/XYZ Analysis

How to Differentiate Product Groups in ABC/XYZ Analysis

ABC/XYZ Analysis in Detail

What Opportunities ABC/XYZ-Analysis Gives to the Category Manager

Conclusions of ABC/XYZ Analysis

FAQ

Objectives of ABC/XYZ Analysis in Category Management

ABC analysis is a method of prioritizing goods based on selected criteria, where A is high priority, B is medium priority, and C is low priority. XYZ analysis allows you to analyze fluctuations in the sale of goods or services over a certain period and assess sales stability.

The most effective in terms of planning any effort is a combination of ABC and XYZ analysis. With the help of ABC analysis, you can evaluate individual products according to their priority, and with the help of XYZ analysis, you can predict sales of these products. That is, instead of three categories, ABC/XYZ analysis provides nine categories for classification, allowing you to make more informed decisions.

How to Perform ABC/XYZ Analysis

To perform an ABC/XYZ analysis, perform each separately. You will find instructions and templates in Excel in our previous materials:

  1. What is ABC Analysis, and Why is it Important in Category Management?
  2. What is XYZ Analysis, and Its Importance in Category Management?

How to Differentiate Product Groups in ABC/XYZ Analysis 

The key concept is to use a two-dimensional matrix to combine the ABC and XYZ categories, resulting in nine categories to classify products based on their sales volumes and demand stability:

  • AX: High sales volumes with stable demand
  • AZ: High sales volumes with very unstable demand
  • CX: Low sales volumes with stable demand
  • CZ: Low sales volumes with very unstable demand.
XYZ
A high volume, stable demandhigh volume, demand fluctuationshigh volume, strong demand fluctuations
B medium volume, stable demandmedium volume, demand fluctuationsmedium volume, strong demand fluctuations
C low volume, stable demandlow volume, demand fluctuationslow volume, strong demand fluctuations

The main purpose of ABC/XYZ analysis is to optimize assortment and inventory management, as it gives you an understanding of which goods you should keep more of, which you should keep fewer of, and which you should remove from your assortment altogether. This understanding reduces the risk of shortages or overstocking and reduces the costs associated with storage of goods. Therefore, you will be able to guarantee that the goods a consumer wants will be available when they’re ready to buy.

Optimizing inventory management based on ABC/XYZ analysis is key to improving the customer experience.

ABC/XYZ Analysis in Detail

Product classes in ABC analysis

1. Category A — The most important goods that bring the greatest result: that is, the 20% of resources that bring 80% of the benefits according to the Pareto principle.

2. Category B — Less important than class A, but still significant goods: 30% of resources that bring 15% of the result.

3. Category C — The least important goods: usually they use 50% of resources but bring only 5% of the benefit.

Product classes in XYZ analysis

1. Category X — Goods characterized by stable demand for a long time, so forecasting demand for them is relatively simple.

2. Category Y — Goods that are characterized by moderate demand variability: demand can fluctuate within a certain range, so forecasting demand is more difficult.

3. Category Z — Goods characterized by high demand variability: simply put, demand is difficult to predict.

What Opportunities Does the ABC/XYZ Analysis Provide to a Category Manager

ABC and XYZ analysis offers several perceptible benefits, such as:

  • boosting the productivity of product and inventory management systems;
  • increasing the share of high-profit goods without violating the basic principles of the assortment policy;
  • identifying priority products that generate the maximum revenue and have stable consumption;
  • redistributing team efforts based on their qualifications and experience;
  • reducing lost sales caused by a shortage of necessary products.

The ABC/XYZ analysis is an effective tool for rationalizing the entire product assortment based on market needs, including those products with unexpected sales. By using this method, you can adjust the optimal ordering rhythm to avoid excessive write-offs and draw valuable insights for future assortment planning.

Conclusions of ABC/XYZ Analysis

Let’s take inventory management as a case in point. You aim to establish a proficient policy for managing inventory and define key performance indicators (KPIs). You have conducted an analysis and can already draw certain conclusions.

To illustrate, it may be feasible to accumulate a larger amount of inventory in category A since its products are essential for the business growth. We can ensure adequate inventory levels for AX goods to meet demands and requirements until the next delivery. However, for AZ items, we must thoroughly examine trends and factors that influence fluctuations.

Group B’s elements follow the same logic.

Regarding group C, you might want to consider keeping the stock levels of both CX and CZ categories at a minimum due to two factors.

  1. For CX items, their impact on the business is negligible, so a lower priority level is feasible. Additionally, their stability allows for even less inventory.
  2. Conversely, CZ items are extremely volatile, sell poorly, and are highly unpredictable. Typically, they are removed from the assortment matrix or replaced. For example, if you position yourself as a mobile phone store that offers all price segments and there are cheap no-name phones that people buy “once a year,” you can look for better-quality analogues of cheap phones.

While there are no hard and fast rules, the key is to strike a balance.

Conclusion

ABC/XYZ analysis is one of the key tools in inventory planning. By classifying products based on both their importance and demand variability, category managers can fully assess the entire product range and understand how to manage certain groups and categories, which products need to be removed from the range, and for which products it is necessary to increase stock.

 

FAQ

What is ABC analysis in the context of inventory management?

ABC analysis is a tool used in inventory management to classify items based on their importance into categories A, B, and C. This classification helps category managers prioritize inventory control activities.

What is XYZ analysis and how is it different from ABC analysis?

XYZ analysis complements ABC analysis. While ABC analysis focuses on the product’s importance, XYZ analysis classifies products based on the variability of their demand.

What are the key advantages of performing XYZ analysis in addition to ABC analysis?

The combination of these two methods allows you to more effectively optimize the company’s assortment and stock. For example, by conducting ABC/XYZ analysis, you will be able to identify: 

  • products that do not bring the expected financial profit and at the same time are characterized by spontaneous demand (СZ) in order to remove them from the assortment or regularly monitor them, since it is from products in this group that illiquid stocks or stocks from which the company suffers losses may arise;
  • those products that are most profitable and have stable demand (AX) so as to ensure their constant availability without creating an excess reserve.
Take a consultation
  • Market analytics
  • Price parsing
  • Product visibility
Take a consultation
  • Market analytics
  • Price parsing
  • Product visibility
Share it:

Get expert advice

Request a demo to see how Pricer24 can meet your needs



    *By submitting this form, you agree to receive marketing emails

    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.