Ask three shop owners what margin they make on a biscuit and you may get three answers for the same pack. One divides by cost, one divides by MRP, and one forgets the free packs in the carton. All three think they are right.
Supermarket billing software that records cost and selling price on every item can show this margin item by item.
This guide shows how to calculate profit margin in a store that sells mostly MRP goods: the margin calculation for one item, the Excel formulas for your whole item list, the margin of the whole grocery store, and the mistakes that make your margin look better or worse than it is.
Margin and markup: same rupees, different base
Take a pack of biscuits:
- You buy it at ₹40
- You sell it at its MRP, ₹50
- You make ₹10 on each pack
That ₹10 can be shown two ways:
| Formula | Answer | |
|---|---|---|
| Margin | profit / selling price | 10 / 50 = 20% |
| Markup | profit / cost | 10 / 40 = 25% |
Both are correct. They just divide by different numbers. The trouble starts when a distributor says "25% on this" and you hear 25% margin, when it is really 25% on cost, which is 20% on what you sell.
In a supermarket, margin on selling price is the more useful number. Your sales report is in selling price, so margin lets you say: out of every ₹100 sold, this much is mine before expenses.
The formulas in Excel
Set up your item list like this (made-up numbers):
| A: Item | B: Cost (₹) | C: Selling price (₹) | D: Margin % | E: Markup % |
|---|---|---|---|---|
| Glucose biscuit 200 g | 25.50 | 30 | ||
| Toor dal 1 kg | 138 | 160 | ||
| Bath soap 100 g | 37 | 45 |
- In D2:
=(C2-B2)/C2and format the column as Percentage. - In E2:
=(C2-B2)/B2and format as Percentage. - Drag both down.
- Sort by column D, smallest first. The items at the top are the ones earning you least per rupee of sales.
To find the selling price you need for a target margin, use:
=B2/(1-F2)
where F2 holds the margin you want, say 15%. For loose items you price yourself, this is the formula to use. For MRP goods, the price is capped by the MRP printed on the pack, so the formula tells you whether the target is even possible.
Quick table: margin to markup
When someone gives you one, use this to find the other:
| Margin on selling price | Same thing as markup on cost |
|---|---|
| 10% | 11.1% |
| 15% | 17.6% |
| 20% | 25% |
| 25% | 33.3% |
| 30% | 42.9% |
| 50% | 100% |
In Excel: markup = =D2/(1-D2), margin = =E2/(1+E2).
MRP goods: the price is fixed, the cost is not
For packaged goods, the MRP is the highest price you can sell at, and it already includes all taxes. You can sell below it, never above it.
So in a supermarket, margin on packaged goods is mostly decided at the time of buying, not selling. Three things move it:
- The rate on the bill. On a ₹50 MRP item, every ₹1 off or on the cost moves your margin by 2 points.
- Discounts you give. Selling a ₹50 MRP item at ₹47 takes your margin from 20% to 14.9%, not to 17%. Every rupee off comes straight out of your profit.
- Schemes and free goods. This is where most margin numbers go wrong. See below.
Keep both prices on the same basis: either both with GST or both without. Mixing a cost without GST against an MRP with GST makes every item look worse than it is. Your accountant can tell you which basis your books use.
The scheme trap: free goods change your real cost
A distributor offers: buy 12, get 1 free. Bill rate ₹40 a pack.
- You pay: 12 × ₹40 = ₹480
- You receive: 13 packs
- Real cost per pack: 480 / 13 = ₹36.92
| Bill cost | Real cost | |
|---|---|---|
| Cost per pack | ₹40 | ₹36.92 |
| Selling price (MRP) | ₹50 | ₹50 |
| Margin | 20% | 26.2% |
If you enter the free pack at ₹0 as a separate line, that one pack shows 100% margin and the other twelve show 20%. The total is right, but the cost on the item looks like ₹40, and next month a purchase at ₹40 without any scheme looks exactly the same as this one.
The cleaner way: spread the free goods across the paid ones and record ₹36.92 as the cost per unit for that purchase. In Excel:
=(paid quantity × rate) / (paid quantity + free quantity)
The same idea works for a cash discount on the bill or a credit note from the distributor that arrives later. Bring it into the cost of the goods it belongs to, or your margin report will keep showing the bill rate.
Margin traps to watch
- Using the latest cost for old stock. If you bought 50 packs at ₹40 and 50 at ₹42, the margin on the first 50 is on ₹40. A report that uses only the latest rate gets old stock wrong.
- Two MRPs on the same item. When the MRP goes from ₹50 to ₹55, old packs still sell at ₹50. Mixing them hides which stock is earning what.
- Margin % without volume. A 35% margin on an item that sells twice a month earns less than 12% on one that sells every hour. Look at margin rupees too: (selling price - cost) × quantity sold.
- Loose items. Wastage, moisture loss and give-away on loose dal or sugar come out of the margin. Weigh what comes in and what is sold before trusting the number.
Grocery store profit margin: the whole-store number
"What margin does a grocery store make?" has no single answer. It depends on what you sell. Staples like sugar, oil and atta are priced the same in every shop nearby and customers compare, so they usually earn thin margins. Packaged snacks, personal care and home care usually leave more. Two supermarkets with the same sales can have very different margins only because their mix is different.
So work out your own number, and work it out the right way: whole-store margin = total gross profit / total sales. Do not average the item margins.
An example with made-up round numbers (not a benchmark):
| Category | Sales in the month (₹) | Margin % | Gross profit (₹) |
|---|---|---|---|
| Staples | 60,000 | 8% | 4,800 |
| Packaged food | 30,000 | 18% | 5,400 |
| Personal care | 10,000 | 22% | 2,200 |
| Store | 1,00,000 | 12,400 |
The store margin is 12,400 / 1,00,000 = 12.4%. A simple average of 8%, 18% and 22% gives 16%, which is wrong, because staples are most of the sales.
In Excel, with sales in B2:B4 and margin % in C2:C4: =SUMPRODUCT(B2:B4,C2:C4)/SUM(B2:B4).
Two more things to keep straight:
- This is gross margin. Rent, salaries, electricity, wastage and shrinkage come out after it. What is left is your net profit, and that is the number that pays you.
- Watch the mix, not just the rate. If the supermarket margin falls one month while every item's rate stayed the same, check whether low-margin staples took a bigger share of sales.
Where software helps
A margin sheet in Excel is a good start for a small list. It gets hard to keep right when costs change with every bill, schemes come and go, and the same barcode carries two MRPs. Software that records the cost of each purchase with its batch and MRP can show margin on what was actually sold, not on the latest rate.
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. Knowing what each line really earns is part of running any store. This is what MarCat does:
- Cost tracked per purchase. Every sale and every purchase moves stock automatically, with batch, MRP and cost tracking.
- Two MRPs kept apart. Every MRP change asks: keep both prices or replace. Keep both, and old and new stock each keep their own MRP and stock.
- Margin reports. Sales comparison across periods, product-wise sales, stock movement, purchase and margin reports, plus GST-ready reports for your accountant.
If you want to see your margins item by item instead of in a spreadsheet, message us on WhatsApp at +91 96787 65518.
