MarCat

How to calculate profit margin in a retail shop: formulas, MRP goods and the scheme trap

How to calculate profit margin in a grocery shop or supermarket: margin formulas in Excel, MRP goods, whole-store margin, and the free-goods trap.

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

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
  1. In D2: =(C2-B2)/C2 and format the column as Percentage.
  2. In E2: =(C2-B2)/B2 and format as Percentage.
  3. Drag both down.
  4. 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:

  1. The rate on the bill. On a ₹50 MRP item, every ₹1 off or on the cost moves your margin by 2 points.
  2. 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.
  3. 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:

  1. 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.
  2. 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.

Questions

What is the formula for margin percentage?
Margin % = (selling price - cost) / selling price x 100. In Excel, with cost in B2 and selling price in C2: =(C2-B2)/C2, formatted as a percentage.
What is the difference between margin and markup?
Both use the same rupee profit. Margin divides it by the selling price. Markup divides it by the cost. So a 25% markup is only a 20% margin.
How do free goods in a scheme change my margin?
Divide the total amount you paid by all the units you received, including the free ones. That is your real cost per unit, and your real margin is higher than the bill rate suggests.
What is a good profit margin for a grocery store?
There is no single right number. It depends on your mix: staples usually earn thin margins, packaged foods and personal care more. Work out your own whole-store margin as total gross profit divided by total sales, then check it category by category.
Can I sell above MRP if my cost went up?
No. MRP is the highest price a packaged item can be sold at, and it includes all taxes. If your cost rises, your margin on that stock falls.