Available · 2 projects · Q4 2026Independent practice · Montreal
Practical guide · Grocery & convenience stores

Calculating grocery store margin — without fooling yourself.

Margin is the most important number in a food store — and one of the most often miscalculated. Confusing margin with markup leads to pricing too low; outdated costs make you believe in a margin that no longer exists. This guide gives the exact formulas, the three classic pitfalls, and the only real way to win back margin without raising prices: buying better. You won’t find an “industry average margin” here: the only number that matters is yours, calculated on current costs.

The formula that keeps you from pricing too low
cost ÷ (1 − margin)

To hit a 25% margin on a product that costs $3.00: 3.00 ÷ 0.75 = $4.00. Marking up the cost by 25% ($3.75) would have given only a 20% margin.

Margin and markup aren’t the same thing — details below.

The formulas, with examples
01

Gross margin (%)

(Selling price − cost) ÷ selling price × 100. A product bought at $4.25 and sold at $5.49: (5.49 − 4.25) ÷ 5.49 = 22.6%. It’s the share of every sales dollar left over to pay the rent, the payroll — and you.

02

Markup — the other calculation

(Selling price − cost) ÷ cost × 100. The same product: (5.49 − 4.25) ÷ 4.25 = 29.2%. Markup is always bigger than margin — which is why owners think they’re “at 30%” when they’re at 22%. To hit a specific margin: price = cost ÷ (1 − target margin).

03

Dollar margin — the one that pays the rent

Margin % × price × units sold. A product with a 40% margin that sells twice a week brings in less than a 20% product that sells twenty times. Rank your products by dollar margin per week, not by percentage — the ranking changes completely.

04

Weighted margin by department

(Department’s total sales − cost of goods sold) ÷ total sales. It’s the only margin you can compare from one period to the next: it absorbs the real basket — low-margin loss leaders as well as the profitable products. Calculate it by department, every month, on current costs.

The three pitfalls

A margin calculated on an outdated cost isn’t a margin. It’s a memory.

Outdated costs. Every supplier price list not carried over into the POS system skews the margin on dozens of products at once — in the wrong direction, since costs go up more often than they go down. It’s pitfall No. 1, and it can be fixed: the 4 methods for updating supplier prices. Ignored shrink. Breakage, theft, spoilage: actual margin is always below theoretical margin — track the gap between the two instead of ignoring it. Mixed pack sizes. A cost per case of 12 compared with a unit price: the classic mistake that has you “selling at a loss” without knowing it. Always bring cost and price back to the same pack size.

And the forgotten lever: margin is also won when buying. Ordering each product from the cheapest supplier — because you can finally compare — brought margin back on every order at the grocery store in the case study, on top of the $56,000 in time recovered.

The matching templates
Per-product margin calculates itself in the inventory template (free .xlsx, in French) → and the best purchase price stands out in the supplier price comparison template (in French) →
Your real numbers

Your actual margin, on current costs.

In 20 minutes, we look at how your costs get into your POS system and what that skews in your margins — and I tell you what to make reliable first. Free, no obligation.