Meta Pixel TrackingABC Inventory Analysis: Calculation & Example | LOTC

ABC Inventory Analysis: Calculation, Example and Control Priorities

What Is ABC Inventory Analysis?

ABC inventory analysis is a method of inventory classification that ranks stock items by their relative value contribution, usually using annual consumption value (annual usage × unit cost). Items are grouped into A, B and C classes so that control effort — review, counting and replenishment attention — is focused where value is most concentrated.

Use ABC inventory analysis to focus inventory-control effort where stock value is most concentrated. A warehouse may hold 5,000 SKUs, but applying the same review frequency, counting effort and management attention to every item wastes control capacity.

ABC analysis provides a practical form of inventory classification by combining usage and unit cost to calculate annual consumption value, ranking items by contribution and assigning them to A, B or C classes.

Those classes can then guide different levels of review, cycle counting and replenishment attention. However, value is only one dimension of inventory importance.

ABC analysis does not tell managers which items matter operationally; it tells them where inventory value is concentrated.

What Is ABC Inventory Analysis and What Does It Actually Classify?

ABC inventory analysis is a method of inventory classification that ranks stock items according to their relative value contribution. In many practical applications, ABC analysis in inventory management uses annual consumption value as the basis:

Annual Consumption Value = Annual Usage Quantity × Unit Cost

Items are then ranked from highest to lowest contribution:

A
A items represent the highest concentration of annual usage value
B
B items account for a moderate share
C
C items contribute the lower-value portion

This mirrors the Pareto principle: A items typically account for a large share of value but a small share of the item count.

The class boundaries are not universal. Organisations may use approximate thresholds, but they should define cut-offs that reflect their own inventory profile and control objectives.

A low-value C item may still be operationally critical if its absence stops production.

That distinction matters for ABC inventory management: the method identifies where inventory value is concentrated, not every form of operational importance.

Here, ABC refers to ABC classification in inventory management, not Activity-Based Costing. It is also one tool within wider stock management, which LOTC's guide to advanced inventory management covers in more depth.

How to Perform ABC Analysis in Inventory Management

Follow these ABC analysis steps to move from raw inventory data to a classification that can support different control priorities.

1

Define the Inventory Scope and Analysis Period

Start by deciding which warehouse, location or inventory population the analysis will cover. Identify the SKUs to include, use a consistent historical period and define the cost basis applied to each item. New, obsolete or recently introduced items may need separate treatment if historical usage is not representative.

One analysis should compare items that managers genuinely need to prioritise against each other.

Combining unrelated inventory populations can produce rankings that are mathematically correct but operationally unhelpful.

2

Calculate Annual Consumption Value

For each SKU, calculate:

Annual Consumption Value = Annual Usage Quantity × Unit Cost

If an item uses 2,000 units per year at £12 each:

2,000 × £12 = £24,000 annual consumption value

This ABC analysis calculation is different from current stock value. Quantity on hand × cost measures what is currently held; annual consumption value measures the value flowing through inventory over the selected period.

3

Rank Items from Highest to Lowest Value

Next:

▸
sort items by annual consumption value in descending order
▸
calculate total annual consumption value
▸
calculate each item's percentage contribution
▸
calculate the cumulative percentage

For example, one SKU might contribute 23% of total value, while the first five items together account for 72%.

In Excel, the same process can be completed using usage × cost, descending sorting and cumulative-percentage formulas.

4

Assign A, B and C Classes Using Defined Cut-Offs

A practical starting point might classify:

A items: the first approximately 70–80% of cumulative value
B items: the next approximately 15–20%
C items: the remaining lower-value contribution

These are working thresholds, not universal rules.

5

Validate the Classification Before Applying Controls

Before changing inventory policies, challenge the result. Check whether a C item is production-critical, whether an A item is becoming obsolete, whether demand has changed materially, whether unit costs remain current and whether new items lack enough history.

ABC classification should guide management attention, not override operational judgement.

ABC Analysis Example: From Consumption Value to A, B and C

Use this ABC analysis example to see how annual usage and unit cost become an A, B or C classification.

Item Usage × Cost Annual value Cum. %
Motor A
A
100 × £400 £40,000 38%
Sensor B
A
500 × £50 £25,000 62%
Valve C
A
1,000 × £15 £15,000 76%
Filter D
B
2,000 × £5 £10,000 86%
Seal E
B
5,000 × £1.50 £7,500 93%
Fastener F
C
10,000 × £0.75 £7,500 100%

In the table, “Annual value” is the annual consumption value and “Cum. %” is the cumulative percentage. The total annual consumption value is £105,000. Start by multiplying annual usage by unit cost for each SKU, then rank the results from highest to lowest. Next, calculate each item’s share of the total value and the running cumulative percentage.

Using illustrative cut-offs, the first three items account for about 76% of annual consumption value and are classified as A. The next two bring the cumulative share to about 93% and fall into B, while the final item is placed in C.

This ABC inventory analysis example also shows why neither movement volume nor unit price should be used alone.

A fast-moving item is not automatically an A item, and a high unit-cost item is not automatically an A item; what matters is its contribution to the chosen value measure.

If your team wants to build this skill, LOTC's Fundamentals of Supply Chain Management course covers ABC analysis alongside inventory-control techniques, reorder points and demand planning.

Turn A, B and C Classes into Inventory Control Priorities

Use ABC inventory control to match management effort with the value concentration identified by the analysis. The classes should influence how closely items are reviewed, counted and monitored rather than remain labels in a spreadsheet.

Class Typical Control Approach
A Close review, high record accuracy, frequent cycle counts and tighter exception monitoring
B Moderate review and counting frequency
C Simpler controls and less frequent review where operational risk permits
A
For A items, apply closer replenishment monitoring, tighter inventory-accuracy requirements, more frequent ABC cycle counting and stronger management attention to shortages, excess stock, demand changes and lead-time variation. Getting inventory and warehouse control right is also one of the practical levers for improving supply chain efficiency.
B
B items can usually follow standard inventory controls with a moderate review frequency. They should still be monitored for movement into A as usage, cost or demand patterns change.
C
For C items, the ABC method of inventory control may justify simpler administration and less frequent counting. Larger ordering batches may also be practical in some cases, but only where lead time, storage cost, obsolescence risk and operational criticality support that decision.

Record accuracy still matters across all classes. LOTC's guide to warehouse management mistakes explains how inaccurate inventory records and weak stock control can undermine wider warehouse performance.

The purpose of ABC classification is not to control some items and ignore others; it is to apply control effort in proportion to value and risk.

When ABC Classification Can Mislead Inventory Decisions

Use ABC classification as one decision input, not as a complete inventory-management model. Because the method often relies on historical usage and cost data, classifications can become misleading when demand, prices or operating conditions change.

A new item may lack enough history to rank reliably, while an obsolete item can remain highly classified because of past consumption. A low-value C item may also be operationally critical if its absence stops production. Lead time, supply risk and service consequences can therefore matter more than value alone for some SKUs.

Data quality is equally important. Inaccurate usage records, outdated unit costs or inconsistent item data will weaken the classification before any control decision is made.

ABC also does not measure demand variability directly. ABC primarily classifies by value contribution; methods such as XYZ address different questions such as demand variability.

ABC analysis answers “where is inventory value concentrated?” It does not answer every question about availability, criticality or demand uncertainty.

Common ABC Analysis Mistakes

The most common ABC analysis errors occur either in the calculation or in how the result is used. Avoid:

1 ranking items by unit price rather than consumption value
2 using current stock value when the chosen method requires usage value
3 failing to sort items before calculating cumulative percentages
4 treating 80/15/5 as a mandatory classification rule
5 assuming C items are unimportant
6 relying on poor or outdated inventory data
7 leaving classifications unchanged as usage and cost patterns evolve
8 assigning A, B and C classes without changing ABC inventory control policies
9 using ABC alone for highly volatile, supply-critical or operationally critical inventory

Good ABC inventory management requires periodic review as well as accurate calculation. The objective is not simply to complete the ABC analysis steps, but to use the resulting classes to direct different levels of management attention.

If A, B and C items receive exactly the same review, counting and control treatment, the classification has produced labels rather than management priorities.

Strengthen Inventory and Supply Chain Control with LOTC

Develop stronger ABC inventory management capability by connecting classification decisions with wider inventory and supply chain control.

Build stronger inventory control capability with LOTC

LOTC’s Fundamentals of Supply Chain Management course covers inventory concepts, holding costs, stockouts, inventory-control techniques, ABC analysis, reorder points and demand planning.

For teams that need to move beyond basic classification into more advanced execution, Advanced Inventory and Warehouse Management develops capability in inventory optimisation, warehouse systems, analytics, process improvement, stock-control risk and technology integration.

To discuss the right training option for your team or organisation, contact LOTC on WhatsApp.

FAQs

What is ABC inventory analysis?

ABC inventory analysis is a method of inventory classification that ranks stock items by their value contribution, usually using annual consumption value. Items are grouped into A, B and C classes so that review, counting and replenishment attention can be focused where value is most concentrated.

How do you calculate ABC analysis?

First, calculate annual consumption value for each SKU by multiplying annual usage quantity by unit cost. Then rank the items from highest to lowest, calculate each item’s percentage of the total and the cumulative percentage, and assign A, B and C classes using defined cut-offs.

What percentages are used for A, B and C items?

A common starting point is to classify the first 70–80% of cumulative value as A, the next 15–20% as B and the remainder as C. These are working thresholds, not universal rules, so organisations should set cut-offs that reflect their own inventory profile.

Are C items unimportant?

Not necessarily. C items contribute less to total inventory value, but a low-value item can still be operationally critical if its absence stops production. ABC analysis shows where value is concentrated, so lead time, supply risk and service consequences should also be considered.

Like what you read? Share with others.