There isn't one markup on groceries, and a store that uses one will be wrong on nearly everything it sells. A grocery prices by department, because the departments lose different amounts to spoilage and cost different amounts of labor. In the made-up neighborhood store below, the markup on cost runs from 33% on beer and wine to 100% in the bakery, and the store as a whole works out at 46%. A markup is also not a margin: a 46% markup is a 31.5% gross margin, and most of that goes on wages, rent and what's thrown away. Below is each department's markup, the two formulas, what shrink does to the number, and a calculator. The margins and shrink are this store's own.
The short version
- Markup is a share of cost. Margin is a share of the price.
- Markup = margin ÷ (1 − margin). A 50% margin is a 100% markup.
- Shelf price = cost ÷ (1 − margin).
- Set a target margin for each department, not one for the store.
- Add shrink to the target before turning it into a markup.
- The departments with the highest markups are the ones that throw the most away.
- TaroStack tracks what each item cost and what was written off. More below.
Markup by department
| Department | Target gross margin | Markup on cost | Example item | Cost | Shelf price |
|---|---|---|---|---|---|
| Grocery: center store | 27% | 37.0% | Can of beans | $0.95 | $1.30 |
| Produce | 40% | 66.7% | Apples, a lb | $1.20 | $2.00 |
| Meat and seafood | 27% | 37.0% | Ground beef, a lb | $4.40 | $6.03 |
| Dairy | 29% | 40.8% | Milk, a gallon | $2.90 | $4.08 |
| Frozen | 30% | 42.9% | Frozen pizza | $4.20 | $6.00 |
| Deli and prepared foods | 48% | 92.3% | Sliced turkey, a lb | $5.20 | $10.00 |
| Bakery | 50% | 100.0% | Loaf of bread | $2.25 | $4.50 |
| Beer and wine | 25% | 33.3% | Six-pack | $8.25 | $11.00 |
| Household, health and beauty | 35% | 53.8% | Laundry detergent | $7.80 | $12.00 |
The store's gross margin across all nine is 31.5%, which is a markup of 46.0%. The same store's sales and profit by department are worked through in grocery store profit margins by department.
The two formulas
Markup on cost = margin ÷ (1 − margin). For the center store: 0.27 ÷ 0.73 = 37.0%.
Shelf price = cost ÷ (1 − margin). A can of beans that costs 95 cents: $0.95 ÷ 0.73 = $1.30.
The two words get mixed up, and the mistake always runs one way. A manager told to "make 40%" who adds 40% to cost has made a 28.6% margin, not 40%. To make a 40% margin the markup is 66.7%. The longer version is in markup vs margin.
Why the markups differ
The can of beans sits on a shelf for months and nobody touches it between the truck and the till. The loaf of bread is baked that morning by someone on the payroll and is day-old tomorrow. A markup has to cover what a department loses and what it costs to run, so the bakery's is nearly three times the center store's.
A single markup gets both ends wrong. At 40% on everything, this store's bread would be $3.15 where it needs $4.50, and its beans would be $1.33 against $1.30, three cents over the price that moves them.
What shrink does
Shrink is what's bought and never sold: spoiled, damaged, stolen, marked down to nothing. It comes straight off the margin.
| Department | Target gross margin | Shrink, of sales | Margin after shrink | Markup on cost | Markup to keep the target after shrink |
|---|---|---|---|---|---|
| Grocery: center store | 27% | 1.0% | 26.0% | 37.0% | 38.9% |
| Produce | 40% | 6.0% | 34.0% | 66.7% | 85.2% |
| Meat and seafood | 27% | 3.5% | 23.5% | 37.0% | 43.9% |
| Dairy | 29% | 2.0% | 27.0% | 40.8% | 44.9% |
| Frozen | 30% | 1.5% | 28.5% | 42.9% | 46.0% |
| Deli and prepared foods | 48% | 8.0% | 40.0% | 92.3% | 127.3% |
| Bakery | 50% | 7.0% | 43.0% | 100.0% | 132.6% |
| Beer and wine | 25% | 0.5% | 24.5% | 33.3% | 34.2% |
| Household, health and beauty | 35% | 1.5% | 33.5% | 53.8% | 57.5% |
Produce is priced for a 40% margin and keeps 34% once 6% of sales is lost to shrink. To actually keep 40%, the markup would have to be 85.2%, not 66.7%: apples at $2.22 a pound, not $2.00.
That's a choice, not an instruction. A store may decide $2.00 is the price its customers will pay and accept 34%. But it should know which it's doing. The last column is the price of the shrink, in markup. Where it comes from and how to bring it down is in grocery store shrink.
Setting your own
- Give each department a target margin, from what it has to cover.
- Measure its shrink: what was written off, at cost, against its sales.
- Decide whether the target is before shrink or after.
- Turn the margin into a markup, and the markup into prices.
- Then look at the shelf. A formula sets a starting price. The prices customers know by heart, milk, eggs, bananas, are set by the store down the road.
A flat doubling of cost is one rule some shops use: see keystone pricing. Stock, ordering and counting for a store are in grocery store inventory management.
Get the calculator
Download the grocery markup calculator. One sheet and a read-me: type each department's target margin, an item's cost and the department's shrink. It works out the markup on cost, the shelf price, the margin after shrink, and the markup that would keep the target once shrink is counted. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers.
Where this stops working
The calculator needs two numbers it can't find for itself. Cost changes with every delivery: the supplier's price for ground beef moved three times this quarter, and the shelf tag was set from the first. Shrink is a figure most stores know for the whole building once a year, after the count, and not for the deli in March. So the markup is right for a cost that's out of date and a shrink that's a guess.
How TaroStack does it
TaroStack keeps cost and write-offs current, item by item.
Receiving records what arrived and what it cost, so each item's cost is what you last paid, not what a price list said.
A price-creep report by supplier shows which costs moved, and when.
Every adjustment carries a reason: spoiled, damaged, expired. Shrink is a number by item and by month.
Stock is held by lot with its date, oldest out first by default, with an alert before a date arrives.
Counting works on a phone with no signal, in the walk-in. A count shows what each difference is worth.
| The number | Calculator | In TaroStack |
|---|---|---|
| What the item costs now | Typed once | From the last delivery |
| Which costs went up | Compare invoices | Price creep, by supplier |
| Shrink, by item | A yearly guess | Adjustments by reason |
| What's close to its date | Walk the cooler | An alert |
TaroStack doesn't print shelf tags or run the tills. It connects to Square. Stock, receiving and counts are on every plan, from $9.99 a month (50 items) or $39 a month (3,000 items). The first 14 days are free, with no credit card. If you'd like a hand setting up, ask, and we'll do it with you.
