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.
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
| Field | Unit | Value in the example | Meaning |
|---|---|---|---|
| Days in the data period | days | 365 | A year is 365, a season about 182. GMROI and turnover are annualized so they can be compared with the target. |
| Target annual GMROI | × | 3 | The 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
| Step | Formula |
|---|---|
| GMROI | (Revenue − cost of goods) ÷ average stock × 365 ÷ days in period |
| Turnover | Cost 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.
The higher and further right a point, the larger the GMROI. Dashed: category averages.
Data as a table
| Stock turnover, times a year | Gross margin, % | |
|---|---|---|
| 2.27 | 58.33 | Outerwear |
| 3.25 | 53.57 | Knitwear |
| 3.29 | 55.77 | Dresses |
| 3 | 67.86 | Accessories |
| 2.23 | 34.09 | Footwear |
By category
| Category | Margin | Turnover | GMROI | Stock |
|---|---|---|---|---|
| Outerwear | 58 % | 2.27× | 3.18× | 5.5 m ₽ |
| Knitwear | 54 % | 3.25× | 3.75× | 4 m ₽ |
| Dresses | 56 % | 3.29× | 4.14× | 3.5 m ₽ |
| Accessories | 68 % | 3× | 6.33× | 1.5 m ₽ |
| Footwear | 34 % | 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.