WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Blog
  • Free Video Tutorials
  • Courses
  • All In One Bundle
  • Login
Home » Accounting Tutorials » Budgeting Tutorials » ABC Analysis

ABC Analysis

By Madhuri ThakurMadhuri Thakur | Reviewed By Dheeraj VaidyaDheeraj Vaidya, CFA, FRM

What is ABC Analysis?

ABC analysis refers to the inventory management technique that is used to identify items that constitute a significant part of the overall inventory value and categorize them into critical, important and moderately important. The basic premise of ABC analysis is that every single item in an inventory doesn’t have equal value and demand – some items cost much more than the others. In contrast, some items are used more frequently, and the remaining are a mix of both.

How to Perform ABC Analysis?

Typically, companies use the following steps to perform ABC analysis –

Step 1: Firstly, determine the inventory value of all the items by multiplying their price and their consumption volume during the given period. Mathematically,

Inventory Value = Item Cost * Consumption Volume

Step 2: Next, sort all the items according to inventory value from highest to lowest.

Step 3: Next, calculate the value contribution of each item as a percentage of the total inventory value. Mathematically,

Popular Course in this category
Sale
All in One Financial Analyst Bundle (250+ Courses, 40+ Projects)
4.9 (1,067 ratings)
250+ Courses | 40+ Projects | 1000+ Hours | Full Lifetime Access | Certificate of Completion
View Course
Item % of Total Inventory Value = Item’s Inventory Value / Total Inventory Values

Step 4: Finally, group all the items according to their contribution to the overall inventory value. For instance, items that account for 80% of total inventory may be allocated to the category ‘A’ items. In comparison, items that account for the following 15% may be allocated to category ‘B’, and the remaining 5% may be allocated to category ‘C’.

Categories

ABC analysis classifies the inventory into three categories – Category A, Category B, and Category C.

ABC_Analysis

  • Category A: Items in this category are essential and at times, business-critical for a company. Typically, these items either have a high value or large market. Hence, this category requires frequent value analysis.
  • Category B: Items in this category are important, but not as important as those in category A. Typically, these items constitute mid-range in inventory value and have relatively lesser market demand.
  • Category C: Items in this category are marginally important and constitute a tiny portion of the overall inventory value.

It is to be noted that there is no fixed threshold for any of these categories, and hence different value proportions can be used based on the company’s own objectives and criteria.

Example of ABC Analysis

Let us take the example of Susan, who is engaged in the retail sale of handbags. Last year she decided to expand her product offering by including more varieties of sweaters in her inventory. Consequently, she purchased 30 different types of handbags instead of just 10. However, later she realized the demand for the products is seasonal, and she had invested a lot. Hence, she decided to implement the ABC analysis in her business model to streamline the inventory.

So, Susan classified the inventory into category A, B, and C, primarily based on their selling price and demand as mentioned below:

  • Category A: The handbags that are either highly in demand, generate the maximum revenue, or are trending in the current season were classified under this category of items.
  • Category B: The handbags that are essential to the company, but not as much as those in category A. Probably the demand for these handbags are slightly seasonal and not across the entire year. So, during the season, the sales of these items are expected to shoot up. Hence, these set of handbags can’t be neglected and hence category B.
  • Category C: In this category, all those handbags are included that are not of high value to the company. The possible reasons may be a colour combination, pattern, etc. Hence, these handbags are placed in category C.

ABC Analysis Graph

You can download this ABC Analysis Graph Excel Template here – ABC Analysis Graph Excel Template

ABC Analysis Graph

The above graph states that the items in category ‘A’ cover a small portion based on the number of units in the inventory but constitute a significant portion of the inventory value. The items in category ‘B’ have a moderate contribution to both quantity and inventory value. The items in category ‘C’ cover a significant portion of the inventory in terms of quantity but have a tiny contribution to inventory value.

Limitations

  • A large number of items keep changing their category (category A to B or B to C and vice versa) every quarter which makes the analysis unstable and complicated.
  • ABC analysis fails to take cognizance of some basic demand patterns, such as seasonality, novelty effect, etc.
  • The choice of parameters used for ABC analysis is arbitrary in nature.

Importance and Uses

The ABC analysis finds wide application in supply chain management and inventory management, where it used as a cycle counting system. It helps companies in managing their working capital requirement as well as holding costs. Further, it also helps in working out appropriate inventory rules for each item category, such as different safety stock levels and re-ordering points.

Advantages

  • It provides a structured view of the entire inventory in terms of quantity and value.
  • It allows management to implement different control measures for each item category.
  • It helps in continuous monitoring of inventory, which in turn ensures maintenance of optimum stock level.

Disadvantages

  • It requires a significant amount of effort to categorize items in this way.
  • It is only based on the financial value of items, while it completely ignores other factors that may be important for the company.

Recommended Articles

This has been a guide to what is ABC analysis and its meaning. Here we discuss how to perform this analysis with example, graph, limitations, and disadvantages. You may learn more about financing from the following articles –

  • Inventory Conversion Period
  • Inventory Control
  • Inventory Valuation
  • Finished Goods Inventory
0 Shares
Share
Tweet
Share
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

* Please provide your correct email id. Login details for this Free course will be emailed to you

Book Your One Instructor : One Learner Free Class
Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Login

Forgot Password?

WallStreetMojo

Free Accounting Course

You will Learn Basics of Accounting in Just 1 Hour, Guaranteed!

* Please provide your correct email id. Login details for this Free course will be emailed to you

WallStreetMojo

Download ABC Analysis Graph Excel Template

Special Offer - All in One Financial Analyst Bundle (250+ Courses, 40+ Projects) View More