Syntha Lab RU

GMROI: gross profit per unit of stock

Compares categories by return on stock: gross profit per unit of money invested in stock, and turnover. Shows what earns and what only freezes cash.

Stock and turnover For whom: Buyers and finance directors deciding which category gets a share of budget.

Calculate on your data →

At a glance

What question does it answer?
How much gross profit each unit of money in stock earns by category.
What data is needed?
Revenue excl. VAT, cost of goods sold and average stock at cost by category for one period.
How to read the result?
Compute GMROI for a year. Below 1, gross profit is less than the average money in stock; judge it with costs and the cost of capital. Compare with the goal and turnover: a high GMROI with slow turnover can hide frozen cash. Example on the default values: GMROI is 3.05 at a gross margin of 53% and stock turnover of 2.67: a rouble of stock brings RUB 3.05 of gross profit a year. Footwear (GMROI 1.15 at a margin of 34%) is below the target of 3.0, accessories (6.33) are above: check demand first, then shift stock toward the categories with a high return.

Why and how to reason

Profit in roubles does not tell whether invested money works efficiently. Two stores may each earn a million, but one holds RUB 2 m of stock and the other RUB 10 m. GMROI measures the return: how much gross profit each rouble put into stock brings.

Formula = gross profit / average stock at cost. The denominator is the money frozen in goods, so it is at cost. If the period is not a year, we annualize: x 365 / days.

It splits into margin and turnover: GMROI = margin / (1 - margin) x turnover, where margin is a share of revenue and turnover is measured against cost (cost / average stock). The plain “margin x turnover” is wrong: the denominator is at cost, while margin is taken from revenue. On the example: 0.533 / 0.467 is about 1.14, turnover 56 / 21 is about 2.67, and 1.14 x 2.67 is about 3.05. High margin without turnover (rare expensive items) and high turnover without margin (clearance) give the same effect.

Example. Revenue RUB 120 m, cost RUB 56 m, gross profit RUB 64 m, stock RUB 21 m: GMROI 64 / 21, about 3.05. Accessories (14 - 4.5) / 1.5, about 6.3, footwear (22 - 14.5) / 6.5, about 1.15.

When to use it

Reach for it to compare categories and decide where to direct buying: into categories with high GMROI. Especially useful for retail with large stock. Do not use it as the only measure: a high GMROI can hide a stock shortage. Assumption: stock is a period average. A point-in-time balance in a seasonal business distorts the result. Compare categories in the same period and on the same basis.

How to read the result

The target GMROI depends on the sector; in the example the target is 3. Below 1, a category does not return what was put into stock: gross profit is less than the cash frozen. Compare categories: footwear (1.15) pulls down, accessories (6.3) are better. Look at the cause: margin or turnover. If margin is fine and turnover low, cut stock. If the opposite, revisit price. Decision: shift buying toward categories with high GMROI, but keep in mind the assortment role of footwear. Before deciding look at the category’s assortment role: footwear may hold store traffic, and cutting its stock would hit other sales.

Common mistakes

Taking stock at selling price; not annualizing the period; computing GMROI on revenue instead of gross profit; comparing categories of different nature (accessories and outerwear) without adjustment. Also: cutting stock to the point of shortage. And putting markup into the formula instead of margin: margin is counted on price, markup on cost, and the result comes out different.

What data is needed?

  • Revenue excl. VAT, cost of goods sold and average stock at cost by category for one period.
  • A target GMROI for your format (based on your history).

Inputs

FieldUnitValue in the exampleMeaning
Days in the data perioddays365A year is 365, a season about 182. GMROI and turnover are annualized so they can be compared with the target.
Target annual GMROI×3The value in the example is illustrative: a normal level depends on format and category, take it from your own history. A GMROI below 1 only means gross profit for the year is below the average money in stock; compare it with the category’s costs and the cost of capital. The default is set for apparel; for footwear, accessories and children’s take your own data.

How it is calculated

StepFormula
GMROI(Revenue − cost of goods) ÷ average stock × 365 ÷ days in period
TurnoverCost of goods sold ÷ average stock × 365 ÷ days in period

Worked numbers

Default values from the app; in the interactive version you enter your own.

Total GMROI
3.05×Gross profit ÷ average stock at cost, annualised.
Gross margin
53.3 %
Stock turnover
2.67×Cost of goods sold ÷ average stock, annualised.
Categories below 1.0
0Gross profit for the year is below the average money in stock: compare it with the category’s costs.
Categories: margin and stock turnover
Scatter plot: 5 points30405060702.22.42.62.833.23.4Outerwear: 2.27; 58.3OuterwearKnitwear: 3.25; 53.6KnitwearDresses: 3.29; 55.8Accessories: 3; 67.9AccessoriesFootwear: 2.23; 34.1FootwearStock turnover, times a year↑ Gross margin, %

The higher and further right a point, the larger the GMROI. Dashed: category averages.

Data as a table
Stock turnover, times a yearGross margin, %
2.2758.33Outerwear
3.2553.57Knitwear
3.2955.77Dresses
367.86Accessories
2.2334.09Footwear

By category

CategoryMarginTurnoverGMROIStock
Outerwear58 %2.27×3.18×5.5 m ₽
Knitwear54 %3.25×3.75×4 m ₽
Dresses56 %3.29×4.14×3.5 m ₽
Accessories68 %3×6.33×1.5 m ₽
Footwear34 %2.23×1.15×6.5 m ₽

Below the target 3×: Footwear.

Nuances and limits

  • Revenue and cost must be for the same period and excl. VAT.
  • A low-GMROI category is not always bad: for new styles stock grows before sales do.

Terms used

Calculate on your data →