What is ABC inventory analysis?
ABC inventory analysis is a method of grouping inventory items according to their relative financial importance. Instead of applying the same level of control to every SKU, the method helps a business focus more attention on the items that contribute the greatest inventory value.
A common ABC analysis uses annual consumption value. This combines how many units are used or sold during a year with the cost of each unit. The items are then ranked from highest to lowest value and separated into A, B and C classes.
- A items: the relatively small group responsible for the largest share of annual consumption value.
- B items: the middle group with moderate financial importance.
- C items: the larger group responsible for the smallest share of annual consumption value.
ABC analysis follows the principle that not every inventory item creates the same financial exposure. However, value should not be the only factor used when operational criticality, safety, expiry or supply risk is important.
ABC analysis formula
Annual consumption value = Annual usage quantity × Unit cost
Annual usage may represent sales, issues, production consumption or another consistent measure of yearly movement. Unit cost should be taken from an approved and consistent valuation source.
Example item
Annual usage: 2,000 units
Unit cost: USD 25
Annual consumption value: 2,000 × USD 25 = USD 50,000
After calculating this value for every item, sort the list from highest to lowest. Then calculate each item’s percentage contribution and cumulative percentage.
Item contribution % = Item annual consumption value ÷ Total annual consumption value × 100
How to perform ABC inventory analysis
Prepare the inventory list
Create one controlled list containing every active SKU to be analyzed. Include the item code, description, annual usage quantity and unit cost. Remove duplicates and clearly identify inactive or obsolete items.
Validate the source data
Confirm that the usage period is consistent and that unit costs use the same valuation method and currency. Match usage units with the unit-cost basis: a cost per carton cannot be multiplied by usage in individual pieces without conversion. Resolve missing or negative values and review zero or unusual values before classification.
Calculate annual consumption value
Multiply each item’s annual usage quantity by its unit cost. This converts movement and cost into one comparable financial measurement.
Sort items from highest to lowest
Rank the items by annual consumption value. The highest-value item should appear first, followed by the remaining items in descending order.
Calculate value contribution
Divide each item’s annual consumption value by the total value of all items and multiply by 100. This shows the percentage contributed by each SKU.
Calculate cumulative percentage
Add the contribution percentages progressively from the top of the ranked list. The cumulative percentage determines where each class ends.
Assign A, B and C classes
Apply the organization’s approved thresholds. Document the classification rules and use them consistently during each analysis cycle.
Review operational exceptions
Identify critical, regulated, expiry-sensitive or difficult-to-source items that may require stronger control even when their annual value is low.
Apply and maintain the results
Use the classification in cycle counting, replenishment, purchasing, slotting and management reporting. Review the classification periodically.
Practical ABC classification example
This fictional dataset totals USD 100,000 in annual consumption value. It uses the same boundary method as the DIXANI Inventory Accuracy Analyzer: assign the class from the cumulative share before adding the current item.
| SKU | Annual value (USD) | Value share | Cumulative before | Cumulative after | Class |
|---|---|---|---|---|---|
| SKU-101 | 50,000 | 50% | 0% | 50% | A |
| SKU-205 | 25,000 | 25% | 50% | 75% | A |
| SKU-118 | 12,000 | 12% | 75% | 87% | A |
| SKU-330 | 7,000 | 7% | 87% | 94% | B |
| SKU-412 | 4,000 | 4% | 94% | 98% | B |
| SKU-509 | 2,000 | 2% | 98% | 100% | C |
On a small screen, scroll the table horizontally to see every column.
- A: cumulative share before the item is below 80%. These three items total USD 87,000 (87%).
- B: cumulative share before the item is at least 80% but below 95%. These two items total USD 11,000 (11%).
- C: cumulative share before the item is at least 95%. The final item totals USD 2,000 (2%).
SKU-118 stays in A because its starting cumulative share is 75%, even though it takes the total to 87%. SKU-412 similarly stays in B and takes the total to 98%. Whole SKUs do not necessarily land exactly on the thresholds.
Another valid documented policy can classify from the cumulative share after each item. That policy would produce A, A, B, B, C, C for this dataset. Do not mix the two policies when comparing results. For equal annual values near a boundary, document a consistent tie rule or review the tied group together.
How to calculate ABC analysis in Excel
For a six-item list in rows 2–7, use columns A–G: SKU, annual usage, unit cost, annual value, value share, cumulative share and class. The formulas below reproduce the example's boundary method.
- In D2, enter
=B2*C2and fill down to D7. - Sort the entire item table by column D, largest to smallest. Sorting only the value column would separate values from their SKUs.
- In E2, enter
=IF(SUM($D$2:$D$7)=0,"",D2/SUM($D$2:$D$7))and fill down. - In F2, enter
=IF(E2="","",SUM($E$2:E2))and fill down. Format E and F as percentages. - In G2, enter
=IF(E2="","Review",IF(SUM($D$2:D2)-D2<80%*SUM($D$2:$D$7),"A",IF(SUM($D$2:D2)-D2<95%*SUM($D$2:$D$7),"B","C")))and fill down.
Change row 7 to your actual last row. Use numeric, non-negative inputs and resolve missing costs or usage before relying on results. These formulas are calculation examples, not input-validation controls. Keep full precision for classification; round only the displayed percentages.
Typical ABC classification ranges
Organizations often begin with ranges similar to the following:
- A items: approximately the first 70–80% of annual consumption value.
- B items: approximately the next 15–25% of annual consumption value.
- C items: approximately the final 5–10% of annual consumption value.
These ranges are a starting point, not a fixed rule. To use them, classify each item from its cumulative percentage of annual consumption value, then compare the resulting group totals with the ranges above and adjust the boundaries to suit your own data.
These are planning references rather than universal rules. The correct thresholds depend on the number of SKUs, value distribution, industry, business risk and how the organization intends to use the classification.
Do not assume that A items must always represent a fixed percentage of the total number of SKUs. The number of A items is determined by the value distribution in the actual dataset.
Annual consumption value is different from stock on hand
Annual usage × unit cost measures value consumed during a period. Current on-hand quantity × unit cost measures a stock snapshot and may produce different classes. Choose the basis that answers your question and label it clearly.
Review zero-usage items separately for inactivity, new-item status or critical spares. If total annual consumption value is zero, there is no meaningful value-share ranking. Missing usage is not the same as confirmed zero usage.
How control can differ by ABC class
ABC classification should lead to practical differences in how inventory is reviewed and managed.
A-class items
- More frequent cycle counts and reconciliation.
- Tighter approval controls for stock adjustments.
- Closer review of demand, lead time and safety stock.
- More frequent supplier and replenishment monitoring.
- Detailed investigation of financial variances.
- Accurate, secure and accessible storage locations.
B-class items
- Moderate cycle-count frequency.
- Regular replenishment and exception review.
- Standard approval and investigation controls.
- Periodic review for movement into A or C class.
C-class items
- Lower count frequency where risk permits.
- Simpler replenishment controls.
- Efficient storage without consuming prime picking locations unnecessarily.
- Review of excessive quantities, inactivity and obsolescence.
Lower financial contribution does not mean that C items should be ignored. A missing low-cost component can still stop production or delay a customer order.
Using ABC analysis for cycle counting
ABC classification is commonly used to set count frequency. A starting schedule might count A items monthly, B items quarterly and C items once or twice per year.
The final frequency should also consider historical accuracy, movement, criticality, expiry, theft risk and transaction complexity. An inaccurate C item may require more frequent counts, while a consistently accurate A item may still remain on a frequent schedule because of its financial exposure.
Use ABC analysis to focus control, but combine value with operational risk before deciding count frequency.
Why value alone is not enough
Traditional ABC analysis focuses on financial value. This is useful, but it can underestimate items with low cost and high operational importance.
Examples include:
- A low-cost spare part that can stop critical equipment.
- A safety item required for regulatory compliance.
- A low-value component with an extremely long lead time.
- An item available from only one approved supplier.
- A temperature-controlled or expiry-sensitive product.
- A packaging material required to dispatch finished products.
These items may require an operational override or a second classification. Some businesses combine ABC value classification with criticality, movement, supply risk or variability analysis.
Any override should be documented. The original ABC class can remain visible while an additional control level reflects the operational risk.
Practical uses of ABC analysis
- Cycle counting: determine where frequent verification produces the greatest value.
- Replenishment: apply closer monitoring to financially important items.
- Purchasing: focus negotiation and supplier management on major spend areas.
- Warehouse slotting: combine value with movement and handling characteristics.
- Inventory reporting: separate high-value exposure from the total SKU population.
- Variance investigation: prioritize discrepancies with greater financial impact.
- Obsolescence review: identify slow-moving value tied up in stock.
- Management attention: direct limited time toward inventory with the greatest impact.
Common ABC analysis mistakes
- Classifying items by unit cost alone instead of annual consumption value.
- Using inconsistent usage periods across different SKUs.
- Mixing currencies or different costing methods.
- Failing to sort items before calculating cumulative percentages.
- Applying arbitrary thresholds without documenting the method.
- Ignoring missing, zero or negative usage and cost values.
- Treating C items as unimportant in every operational situation.
- Ignoring criticality, expiry, supply and service risks.
- Using outdated classification after demand or cost has changed.
- Creating classes without applying different control actions.
How often should ABC classes be reviewed?
Review frequency depends on how quickly demand, cost and the product portfolio change. Many organizations review ABC classifications every six or twelve months. Faster-moving environments may review them quarterly or through a rolling automated process.
An additional review may be required after major price changes, new product introductions, seasonal demand shifts, supplier changes or significant changes in annual usage.
Keep the analysis date, source period, valuation method and thresholds with the results. This allows later classifications to be compared consistently.
Analyze your inventory priorities
Use the free DIXANI Inventory Accuracy Analyzer to calculate ABC classes, measure variance exposure and identify items that may require earlier counting or investigation.
After setting priorities, use the Stock Count Sheet to record counts and the Inventory Variance Investigation guide to follow up differences.
Frequently asked questions
What does ABC mean in inventory management?
ABC divides inventory into three classes based on relative importance. A items normally represent the greatest annual consumption value, B items represent moderate value, and C items represent the smallest share.
How is annual consumption value calculated?
Multiply the annual usage quantity by the unit cost. Use a consistent usage period, currency and costing method across all items.
Is an expensive item automatically an A item?
Not necessarily. ABC classification normally considers both usage and cost. An expensive item with very low annual usage may contribute less annual value than a lower-cost item used in large quantities.
Can a C item still be operationally critical?
Yes. A low-value item may be essential for safety, production, maintenance or customer service. Use a documented operational-risk override or an additional criticality classification where necessary.
How often should ABC analysis be updated?
Many businesses review it every six or twelve months. More frequent reviews may be appropriate when demand, cost, suppliers or the product range change quickly.