A supermarket carries thousands of items, and the owner has the same 24 hours as everyone else. ABC analysis is a simple way to decide which items deserve your daily attention and which can be checked once a month.
It needs one report from your stock and inventory management software or your sales records, a spreadsheet, and about an hour.
What ABC analysis means
You sort every item by how much it brings in, biggest first, and cut the list into three groups:
| Class | What it is | Typical share of sales value |
|---|---|---|
| A | The few items that bring in most of the money | First 80% |
| B | The middle | Next 15% |
| C | The long tail of items that sell a little | Last 5% |
The idea is close to the 80/20 rule: a small part of the list makes most of the value. The 80/15/5 cut-offs are only a starting point. There are no fixed thresholds, so set them to suit your store.
Step 1: Pick the period and the number
- Period: the last three months is a good default. One month is too noisy. A full year mixes old prices and items you no longer stock.
- Number: sales value in rupees (net of returns) for each item. Not units: 100 matchboxes and 100 bottles of oil are not the same to your business.
- Watch festival weeks. If the three months include Diwali, dry fruits and sweets will look like A items. That is true for October, not for February.
Step 2: Clean the list before you sort
A grocery item list has traps that a textbook example does not:
- One product, two MRPs. If the same product sits on two stock lines because of an MRP change, add them together. Otherwise it gets split and drops a class.
- Loose items. Loose sugar sold by the kg and a 1 kg packed sugar are different items. Keep them separate, but make sure the loose item's sales are in rupees, not in kg.
- Duplicates. The same biscuit entered twice under two names will split its sales. Merge them first.
- Discontinued items. Leave them out. You are planning for items you still stock.
Step 3: Build the sheet
Put the item list in Excel with sales value in column B, then sort by column B, largest to smallest.
| Column | Header | Formula in row 2 (copy down) |
|---|---|---|
| A | Item | (typed or pasted) |
| B | Sales value (₹) | (pasted from your sales report) |
| C | Share | =B2/SUM($B$2:$B$13) |
| D | Cumulative share | =SUM($B$2:B2)/SUM($B$2:$B$13) |
| E | Class | =IF(D2<=80%,"A",IF(D2<=95%,"B","C")) |
Change $B$13 to the last row of your list. Format columns C and D as percentages.
A worked example
Twelve made-up items, sales over three months, already sorted:
| Item | Sales value (₹) | Share | Cumulative | Class |
|---|---|---|---|---|
| Sunflower oil 1 ltr | 1,80,000 | 30.0% | 30.0% | A |
| Atta 5 kg | 1,50,000 | 25.0% | 55.0% | A |
| Basmati rice 5 kg | 90,000 | 15.0% | 70.0% | A |
| Milk 500 ml | 60,000 | 10.0% | 80.0% | A |
| Toor dal 1 kg | 40,000 | 6.7% | 86.7% | B |
| Detergent powder 1 kg | 30,000 | 5.0% | 91.7% | B |
| Biscuit 200 g | 20,000 | 3.3% | 95.0% | B |
| Tea 250 g | 15,000 | 2.5% | 97.5% | C |
| Shampoo sachet strip | 8,000 | 1.3% | 98.8% | C |
| Matchbox pack of 10 | 4,000 | 0.7% | 99.5% | C |
| Toothbrush | 2,000 | 0.3% | 99.8% | C |
| Agarbatti | 1,000 | 0.2% | 100.0% | C |
| Total | 6,00,000 |
Four items (A) bring in 80% of the money. Five items (C) bring in 5% together. In a real store with thousands of lines, the A group is usually a much smaller part of the list than in this short example, which makes the exercise even more useful.
Step 4: Treat each class differently
| A items | B items | C items | |
|---|---|---|---|
| Out of stock | Never. Check the shelf daily | Rarely. Check weekly | Acceptable for a day or two |
| Reorder | Tight reorder level, frequent smaller orders | Normal reorder level | Larger, less frequent orders, or order only on demand |
| Stock count | Count often, for example weekly | Monthly | Once a quarter, section by section |
| Supplier bill | Check rate and MRP on every bill | Check on most bills | Spot-check |
| Shelf | Easy to reach, never hidden behind other stock | Normal place | Fine on a higher or lower shelf |
For the reorder numbers, see our reorder level formula guide. For C items that have stopped selling altogether, see dead stock in a supermarket.
Run it again on margin
Sales value tells you where the money comes in. It does not tell you where the profit is. In a grocery store, oil and atta often sell a lot but earn a thin margin, while some packaged foods and personal care items earn more on less.
So run the same sheet a second time with gross margin in rupees (sales value minus cost of what was sold) in column B. Then compare:
- A on both lists: your most important items. Never out of stock.
- A on sales, C on margin: traffic builders. Keep them in stock and priced right, but do not pile up extra stock.
- C on sales, A or B on margin: small but worth it. Check that they are on the shelf and easy to find.
What ABC analysis misses in a grocery store
A C item is not always an unimportant item. Salt, matchboxes and a few everyday items bring in very little, but a customer who cannot find them may go elsewhere for the whole basket. Before you cut a C item or let it run out, ask one question: would a regular customer notice it missing?
ABC also looks back, not forward. It tells you what sold. It does not know about a new brand on the shelf or the festival next month. Use it as a map, and use your own eyes on the shelf as well.
Where software helps
The slow part of ABC analysis is not the formula. It is getting clean product-wise sales and margin for three months, with returns taken out and MRP lines put together. When every bill and every purchase already sits in your billing software, that report takes minutes instead of an evening of copying.
How MarCat handles it
We have run Banjara, our own supermarket in Ahmedabad, since January 2025, and it has billed on MarCat since April 2026. MarCat does not label items A, B or C for you. It gives you the numbers for the sheet:
- Reports. Product-wise sales, sales comparison across periods, stock movement, purchase and margin reports.
- Stock that moves on its own. Every sale and every purchase moves stock automatically, with batch, MRP and cost tracking.
- Reorder and dead stock. Reorder suggestions based on what has actually sold, and stock movement reports that surface lines that stopped moving.
- Your data. The store owns its data and can export it whenever it wants.
If you want to see these reports on a real store's data, message us on WhatsApp at +91 96787 65518.
