MarCat

ABC analysis of inventory for a supermarket, step by step

How to do ABC analysis on a supermarket item list: which numbers to use, the Excel formulas, a worked example, and what to do with A, B and C items.

By Swarbhanu Gupta, who has run Banjara supermarket in Ahmedabad since January 2025 (billing on MarCat since April 2026) · 16 November 2026

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:

  1. 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.
  2. 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.
  3. Duplicates. The same biscuit entered twice under two names will split its sales. Merge them first.
  4. 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.

Questions

What is ABC analysis in inventory?
It sorts your items by how much they bring in. A items are the few that make most of your sales value, C items are the many that make very little, and B items sit in between. Each group then gets a different level of attention.
What percentages are used for A, B and C?
There are no fixed cut-offs. A common starting point is A = items that make up the first 80% of sales value, B = the next 15%, C = the last 5%. Adjust them to suit your store.
Should I use sales value or margin for ABC analysis?
Start with sales value, because it is easy to get. Then run it again on gross margin in rupees. In a grocery store the two lists often differ, and the items that are A on both deserve the most care.
How often should a supermarket redo ABC analysis?
Every three months is enough for most stores, and once before a big festival season. Items move between classes as prices, brands and seasons change.
Does MarCat do ABC analysis?
MarCat gives product-wise sales, margin and stock movement reports, and the store can export its data, so the numbers for an ABC sheet are ready. The A/B/C grouping itself is done in the sheet as shown in this guide.