In this guide
ABC analysis in inventory is a selective control method that sorts every stock item into three bands (A, B and C) according to its annual consumption value, so that scarce management attention, tighter counting and closer reorder discipline go to the small group of items that carry most of the money. It answers a simple question every Indian business faces at year end: of the hundreds of lines on the stock sheet, which ones actually deserve daily attention? Rank the items by value, and the answer falls out of the arithmetic.
What is ABC analysis in inventory management?
ABC analysis, also called selective inventory control or always better control in Indian cost accounting texts, groups items by the value they consume in a year rather than by how many pieces sit on the shelf. A handful of high-value items (class A) usually account for the bulk of inventory value, a middle group (class B) sits in between, and a long tail of low-value items (class C) makes up the rest. The point is not to label stock for its own sake but to match control effort to value: count and reorder class A tightly, class B moderately, and class C loosely. It pairs naturally with the way you already run inventory accounting and costing and feeds cleaner numbers into your MIS reporting.
Is ABC analysis the same as Pareto analysis? The 80/20 rule in inventory
ABC analysis is a practical application of Pareto analysis. The 80/20 rule in inventory says that roughly 20 percent of items carry roughly 80 percent of the inventory value, so controlling that top slice controls most of the risk and most of the tied-up cash. Pareto is the underlying principle; ABC is the working method that turns it into three named bands you can act on. The labels change from book to book, but the mechanics never do: rank items by annual consumption value and treat the top band with the most discipline.
What is the formula for ABC analysis?
ABC analysis has no single formula. The one figure that drives it is annual consumption value, which is annual usage quantity multiplied by unit cost. An item used at 2,000 units a year at Rs 500 each records Rs 10,00,000 of consumption value. You compute that figure for every item, rank the list from highest to lowest, then take a running cumulative percentage of the grand total to see where the value concentrates. Note that the driver is consumption value (what you use), not closing-stock value (what is left over), because control effort should follow throughput. Consumption value also links directly to your cost of goods sold, which is why finance and stores should agree the same unit rates.
How to calculate ABC inventory analysis: the steps
The method is short and repeatable. These are the steps of ABC analysis from a raw stock register to a banded list.
- List every item with its annual usage quantity and current unit rate. Clean data matters here; if your books are behind, a round of catch-up bookkeeping before you start saves you from ranking on stale figures.
- Calculate consumption value for each item: annual quantity multiplied by unit rate.
- Sort the list by consumption value, highest to lowest.
- Add a cumulative total and a cumulative percentage (cumulative value divided by grand total).
- Draw the band lines: items up to roughly 70 percent of cumulative value are class A, the next 20 percent class B, and the balance class C.
- Set the control policy for each band (counting frequency, buffer, reorder review).
The bands are a judgement call at the margin, so document where you drew the line and keep it consistent from one review to the next.
How to do ABC analysis in Excel
Excel is all most Indian firms need. Build four columns: item code, annual quantity, unit rate and consumption value (a simple quantity times rate). Sort the consumption value column from high to low, then add a cumulative percentage column that divides the running cumulative total by the grand total. Read the classes straight off the cumulative percentage: class A up to about 70 percent, class B to about 90 percent, class C to 100. A helper IF formula can stamp the A, B or C label automatically once the cumulative column is in place. If you would rather not build it from scratch, the template at the end of this article gives you the exact columns.
Worked example: ranking a Pune trader's stock
Take a Pune trading firm with ten stock lines. We compute consumption value for each, sort high to low, run the cumulative percentage and draw the bands. All figures are illustrative.
| Item | Annual qty | Unit rate (Rs) | Consumption value (Rs) | Cumulative % | Class |
|---|---|---|---|---|---|
| A1 | 2,000 | 500 | 10,00,000 | 41.1% | A |
| A2 | 1,500 | 400 | 6,00,000 | 65.8% | A |
| A3 | 800 | 450 | 3,60,000 | 80.6% | A |
| B1 | 1,200 | 150 | 1,80,000 | 88.0% | B |
| B2 | 900 | 120 | 1,08,000 | 92.5% | B |
| B3 | 3,000 | 30 | 90,000 | 96.2% | B |
| C1 | 5,000 | 10 | 50,000 | 98.3% | C |
| C2 | 4,000 | 6 | 24,000 | 99.2% | C |
| C3 | 2,500 | 5 | 12,500 | 99.8% | C |
| C4 | 1,000 | 6 | 6,000 | 100.0% | C |
The grand total is Rs 24,30,500. Three items (A1 to A3, 30 percent of the lines) carry 80.6 percent of the value, so they are class A. The next three reach 96.2 percent and become class B. The remaining four, though C1 alone shifts 5,000 pieces a year, together carry under 4 percent of value and are class C. Note how C1's high volume does not buy it a high band: consumption value, not piece count, decides. This same ranking is a useful input to variance analysis when you later compare planned against actual usage.
What A, B and C items mean: setting the control policy
The classification only earns its keep when each band gets a different policy. Class A items justify tight control because a stockout or a shrinkage there hurts most; class C items are managed with the lightest touch so you do not waste hours counting low-value stock. C items in ABC analysis are the many low-value lines you deliberately control loosely: bulk order, hold a generous buffer, count once a year.
| Class | Share of value | Share of items | Counting frequency | Reorder approach |
|---|---|---|---|---|
| A | ~70-80% | ~10-20% | Monthly or perpetual | Low buffer, frequent small orders, close review |
| B | ~15-20% | ~30% | Quarterly | Moderate buffer, periodic review |
| C | ~5-10% | ~50-60% | Annually | Large buffer, bulk order, minimal review |
Tight class A discipline also tightens the wider cash cycle. Frequent, close reorder review on class A lines supports cleaner accounts payable scheduling, while faster A-item turnover feeds through to receivables and, ultimately, to your working capital. For manufacturers, the same logic extends into bill of materials costing, where a handful of A-class inputs drive most of the product cost.
How often should you review the ABC classification?
Review the classification at least once every financial year, and quarterly where demand moves fast, such as electronics or pharma distribution. Consumption value shifts when prices or volumes change, so an item that was class C in April can carry class A value by October. Most Indian firms refresh the ranking alongside the year-end physical stock count, which is also when any inventory shrinkage provision is trued up.
Where ABC analysis fits, and where it stops
ABC analysis decides how closely you watch each item; it does not decide how each item is valued or how it is costed. Valuation follows AS 2 (Valuation of Inventories) issued by the ICAI, which requires inventory to be carried at the lower of cost and net realisable value for every item, class A, B or C alike. The cost formula you use (FIFO or weighted average) is a separate choice covered in our note on FIFO, LIFO and weighted average, and the broader costing picture sits in the four methods of costing. Whether you track balances continuously or count periodically is a further separate decision, explained in perpetual versus periodic inventory. ABC simply sits on top of all of these and points your effort. It also has nothing to do with statutory purchase compliance such as Section 194Q TDS on goods, which applies on turnover thresholds regardless of a stock item's band. If you want the classification and the valuation done together and kept current, that is the job of a structured accounting service, and for standard-selection questions the AS vs Ind AS comparison matrix is a quick reference.
Key terms
- Cost of Goods Sold: the direct cost of stock consumed in a period; consumption value used in ABC feeds into it.
- Working Capital: current assets less current liabilities; tight class A control frees cash tied up in stock.
- Inventory Shrinkage Provision: an allowance for stock lost to theft, damage or error, usually reviewed at the annual count.
- Standard Cost Variance: the gap between standard and actual cost, most worth investigating on class A items.
Key takeaways
- Rank items by annual consumption value (quantity times unit rate), not by piece count or price alone.
- Use the cumulative percentage to draw the A, B and C bands; expect a 70/30 or 75/25 split rather than a textbook-perfect 80/20.
- Match control to value: count and reorder class A tightly, class C loosely, and overlay a criticality flag for parts that stop the line.
- Refresh the classification yearly, or quarterly for fast-moving stock, alongside the physical count.
- ABC is a control tool only; AS 2 valuation at lower of cost and net realisable value applies to every item regardless of band.
Decision guide
