How to Calculate ABC Classification (and the Added Value of XYZ Analysis)

4 minread

Tags: Blog, Inventory management, Tips & Tricks

Peter Drakeley, Head of Global Customer Success, EazyStock

Peter Drakeley   10 June 2019


ABC Classification in Inventory Management

Index

  1. Calculating ABC classification
  2. What is ABC inventory classification?
  3. ABC classification calculation – an example
  4. How to put your data to good use
  5. XYZ analysis
  6. From ABC - XYZ analysis to automation

Calculating ABC classification

In a recent blog post we looked at the importance of ABC analysis in inventory management and it’s benefits and drawbacks.

In this post we’re going to discuss how you can practically classify your inventory into three ABC categories and introduce the concept of XYZ analysis.

But first, here’s a quick reminder of what ABC classification is:

 

What is ABC inventory classification?

ABC inventory classification or ABC analysis is used by inventory management teams to help identify the most important products in their portfolio and ensure they focus on managing them above those less valuable. The ABC classification framework is based on the theory that all inventory is not of equal value. Instead it follows the Pareto Principle, where 20% of stock accounts for 80% of the value to the business. Using ABC classification you can therefore split inventory into three categories, A, B and C.

Category A: this is the smallest category and consists of the most important stock items
Category B: will generally be slightly larger in terms of volumes of SKUs and will usually be made up of products of less value
Category C: this will typically be the largest category where products will contribute the least to your businesses bottom line.

Your inventory’s ‘value’ can be defined based on a number of criteria, such as annual sales revenue, profitability or annual consumption value.

The graph below illustrates how 80% of a company’s sales revenue comes from 20% of their stock items.

 

ABC-Classification-Chart
ABC classification & The Pareto Rule for inventory management

 

Request a live demo of EazyStock
 

ABC classification calculation – an example

Here is a working illustration of how to divide up your inventory, using annual consumption value.

We’re going to use Sam’s Stationery business as the example:

1. Use the formula ‘annual number of units sold x cost per unit’ to calculate the annual consumption value of each item

 

Annual number of units sold (per item) x cost per unit

ABC classification table one
2. List your products in descending order, based on their annual consumption value


ABC classification table two
3. Total up the number of units sold and the annual consumption value

ABC classification table three

4. Calculate the cumulative percentage of items sold and cumulative percentage of the annual consumption values

ABC classification table four

5. Determine the thresholds for splitting the data into A, B and C categories. The threshold for determining the ABC split will be unique to your company and your product mix, but typically it’s close to 80% / 15% / 5%.

ABC classification table five

 

How to put your data to good use

With the calculations complete, you can use your final data to review how you currently manage the inventory in each category. If you find that you’re treating all items the same, in terms of the stock you hold and the purchases you make – regardless of their category – then you’re most likely to have inefficient inventory policies. This means you’re probably over and under ordering on many product lines.

The good news is that there’s plenty of room for improvement! And this will bring about reduced storage, delivery and management costs.

Good practice is to adapt your purchasing and inventory policies for each group. This could include setting up sophisticated ordering processes for all A items, such as checking every purchase order and spending more time discussing lead times with suppliers to guarantee best value and timely deliveries.

In contrast, C items should take up much less of your time and could be ordered automatically to save valuable human resource.

 

XYZ analysis

As discussed in our post the importance of ABC analysis in inventory management, ABC analysis can be very beneficial as a simple way to prioritise your workload and help reduce the hours spent ordering and managing inventory.

However, there are limitations of the model. For starters, ABC classification is arguably over simplistic, due to the categories being static (unless regularly reviewed to allow items to move between groupings) and the evaluation criteria being one-dimensional.

To help overcome these issues it’s possible to introduce XYZ analysis.

XYZ analysis is a framework to classify products based on their variability of demand.

X-items = regular demand

Y-items = strong variability in demand

Z-items = very irregular and difficult to predict demand

This means you can segment items based on their forecastability e.g the likelihood that their demand will vary from their forecast.

Adding another level of insights to your inventory classification model allows you to make more informed ordering and stocking decisions. For example, it makes sense to treat AX items that are valuable and have a constant demand differently to AZ items with erratic demand. If demand is steady and easy to predict (X items), your safety stock levels can be much lower than products where demand is much more volatile (Z items).

Download our eBook for more information on how to combine ABC and XYZ analysis and increase the effectiveness of your inventory classification models.

 

From ABC – XYZ analysis to automation

Whilst XYZ analysis adds more sophistication to the ABC framework, it doesn’t solve the problem of the calculations quickly becoming out of date. Products can rapidly move between categories as their sales rise and fall.

The answer is to use an inventory optimisation tool to automate the process. Software, such as EazyStock will allow you to categorise your inventory based on multi-dimensional criteria including demand, sales frequency, number of picks, and annual consumption value.

By automating your inventory classification process, you can be sure that it stays up-to-date with re-classifications taking place daily, so products are always managed according to the most relevant inventory policy.

For more information on EazyStock or to book a demo click here.

 


Whitepaper - Inventory Classification ABC XYZ Analysis
 

 

Originally published 01 Dec 2014 – updated June 2019