Decision software for grocery chains

How to calculate GMROI and what a good GMROI is

Last updated: 5 October 20269 min read

Who it is forGrocery chain category management, buying, commercial directors

Category comparison is the hardest question in retail: is the housewares department turning twice a year at a 45 per cent margin better, or the drinks aisle turning forty times at 12 per cent? Look at margin and the first wins; look at turnover and the second does. GMROI is the only meaningful answer because it folds both facts into one number. This guide covers the formula, the second route to it, the target ranges and where GMROI misleads.

What GMROI is and what it measures

GMROI is the return on capital invested in stock. Its question is: how much gross profit did each unit of currency sitting on the shelf produce over the period.

The result is a multiple, not a percentage. A GMROI of 2.45 says ₺1 tied up in stock brought back ₺2.45 of gross profit. The break-even point is 1.00: below it, the category is not generating even as much gross profit as the stock it carries costs.

The strength of the metric is in its denominator. Average inventory at cost shows how much capital the category actually consumes; margin cannot see that, and turnover cannot see profitability.

GMROI
Gross profit ÷ Average inventory at cost
Expanded
(Net sales − COGS) ÷ Average inventory at cost
Equivalent formula
Inventory turnover × Mark-upMark-up = Gross profit ÷ COGS. Mark-up, not margin.

Category comparison: settling the margin-versus-turnover question

Used on their own, margin and turnover contradict each other. The table below ranks four departments in the same store on three measures; the ranking changes in every column.

By margin, housewares is first and drinks last. By turnover, exactly the reverse. GMROI accounts for both and produces a real ranking that resembles neither list.

This table explains why decisions to cut categories so often go wrong: when the low-margin departments are cut, the department producing the highest return on capital is usually the one being removed.

Four departments, three measures, three different rankings
DepartmentGross marginTurnoverMark-upGMROIRank
Housewares and kitchenware45%2.00.821.644th
Personal care38%4.00.612.453rd
Detergents and cleaning30%8.00.433.432nd
Drinks12%40.00.145.451st

The highest-margin department produces the lowest GMROI. Wherever capital is constrained, the decision is made on GMROI, not margin.

What GMROI should be

The target depends on the department and on the cost of capital. The general rule is that GMROI must sit clearly above the alternative return on that capital; otherwise the money tied up in stock would earn more elsewhere.

The ranges below are typical. But the real information in GMROI is not the absolute level: it is the comparison of a category against its own history and against the spread across stores.

Typical GMROI ranges in a grocery chain
ScopeTypical GMROIComment
Grocery chain total3.0 - 6.0Thin margin, very high turnover
Personal care aisle2.5 - 4.0Expiry losses and assortment width pull the result down
Non-food specials1.5 - 2.5High unit cost, low turnover

Four mistakes that break GMROI

Because the formula is short, every error sits in the inputs. Four are common and all four push the result in the same optimistic direction.

  • Taking average inventory from two end points — inflates GMROI in categories carrying holiday and seasonal lines
  • Valuing stock at retail — the denominator swells and GMROI drops by the margin rate, breaking cross-category comparison
  • Leaving markdowns and shrinkage out of gross profit — using initial margin instead of achieved margin keeps GMROI on paper only
  • Excluding in-transit and reserved stock from the denominator — the capital is committed but never counted

Calculate GMROI by category. Total GMROI belongs on a management dashboard but produces no decisions; decisions come from the differences between categories.

What GMROI cannot see: space and labour

GMROI measures only the capital tied up in stock. A department consumes two further resources: shelf space and staff time. When either becomes the binding constraint, GMROI is incomplete.

In space-constrained formats GMROS is used: gross profit divided by the square metres occupied. In grocery, shelf space is a scarcer resource than capital and department decisions are usually made on this measure.

In labour-intensive categories — delicatessen, butchery, bakery — GMROL takes over: gross profit divided by hours worked. A department producing high GMROI may be reducing total profitability because of the staff hours it consumes.

GMROS (return on space)
Gross profit ÷ Selling area occupied (m²)
GMROL (return on labour)
Gross profit ÷ Hours worked

Frequently asked questions

What is GMROI?
GMROI stands for Gross Margin Return on Inventory Investment: the gross profit produced by each unit of capital tied up in stock. It is calculated by dividing gross profit by average inventory at cost and read as a multiple.
How is GMROI calculated?
Divide gross profit by average inventory at cost. In a category with ₺380,000 gross profit and ₺155,000 average inventory at cost, GMROI is 380,000 ÷ 155,000 = 2.45. The second route is multiplying inventory turnover by mark-up, which gives the same answer.
What is a good GMROI?
It varies by department: 3.0-6.0 for a grocery chain as a whole, 2.5-4.0 in the personal care aisle, 1.5-2.5 for non-food specials. Anything below 1.00 is a warning in every department — the category is not producing even as much gross profit as the stock it carries costs.
What is the difference between GMROI and inventory turnover?
Turnover measures only how fast stock depletes and is blind to profitability. GMROI also accounts for margin. The relationship is GMROI = turnover × mark-up, which is why low-margin but fast-moving categories can come out ahead on GMROI.
Should inventory be valued at cost or retail in GMROI?
At cost. When the denominator is valued at retail, GMROI falls by the margin rate and categories with different margins become incomparable. Gross profit on top, cost underneath — that is the rule.
How can GMROI be improved?
Three levers: raise margin, speed up turnover and reduce average inventory. In practice the third works fastest: cut the depth of slow-moving SKUs and the denominator falls, lifting GMROI without touching sales at all.

Let us build this calculation on your data

Knowing the formula is not enough; the data has to sit at the right grain. Our team does the installation. We will go through your current setup together in 30 minutes.