Esoteric Inventory Profitability: What GMROI Reveals

Two product departments can generate identical revenue while tying up very different amounts of inventory. One turns over quickly with little stock on hand. The other generates more margin per sale but requires a large assortment and substantial replenishment orders. Comparing margin percentages alone cannot distinguish their performance.

GMROI offers another perspective: how much gross trading margin has the shop generated for every euro held in average inventory? For an esoteric retailer, this calculation helps allocate limited funds between consumables, accessories, and specialized products. It supplements sales analysis rather than replacing it.

What GMROI measures

The acronym stands for gross margin return on inventory investment. The formula presented in Shopify’s GMROI guide divides gross margin in monetary terms by average inventory at cost. In the resale model used here, the numerator is the gross trading margin: net sales excluding VAT minus the purchase cost of goods sold.

An annual GMROI of 3 means every euro invested in average inventory was associated with 3 € of gross trading margin over the year. It does not mean 3 € of net profit or a financial investment earning 300%. Stock may have been bought, sold, and replaced several times; business overheads still need to be covered.

A comparison that changes how departments are viewed

The following table shows two hypothetical categories over a full year. The labels illustrate different ways a department might operate; the values are not observed averages for incense or accessories. Costs exclude recoverable VAT and consistently include the purchasing expenses used in inventory valuation.

Category B generates more gross margin in euros, while category A generates more margin per euro invested in average inventory. Both statements are true. The decision therefore depends on what limits the business: available capital, space, handling time, or the ability to attract more buyers.

It would be wrong to discontinue B automatically: its 16 000 € may make a substantial contribution to overheads. It would be equally wrong to buy four times as much A and expect its margin to increase proportionally. The ratio describes past performance, not a guaranteed return on additional stock.

Understanding the relationship between margin and turnover

The result can be broken down as follows: GMROI = markup on purchase cost × inventory turnover at cost. Turnover here is the cost of goods sold divided by average inventory at cost. For A, the markup on cost is 100% and turnover is 4, giving 4. For B, markup is 200% and turnover is 1, giving 2.

Be careful with terminology: gross margin as a percentage of sales divides margin by selling price, while markup in this breakdown divides it by purchase cost. Using 50% instead of 100% for A would incorrectly halve the result. Our article on calculating margins explains these distinctions.

Measure representative average inventory

Averaging opening and closing stock provides an approximation. It becomes unrepresentative if the shop built up large inventory midway through the year. Where data is available, an average of daily inventory values better captures fluctuations. Regularly spaced stock snapshots offer an alternative, provided a consistent method is used.

A snapshot after year-end sales may understate the capital held in preparation for them. A snapshot just after a large delivery can have the opposite effect. The indicator should represent inventory actually held throughout the period, not whichever moment makes performance look best.

Inventory must be valued at cost, not the displayed selling price. Samples, damaged items, and unsaleable goods require specific treatment. An accounting write-down can reduce the denominator without improving sales: a resulting rise in the ratio does not by itself prove better business performance.

Clean the data before interpreting the result

Sales must account for discounts and refunds. The cost of goods sold must cover the same products and period. A missing cost value in software does not make merchandise free; it makes the calculation incomplete.

Check units as well: purchasing a carton at a case price but selling items individually requires correct conversion. Supplier pack sizes, point-of-sale products, and stock movements must match. Software does not automatically fix mismatches between them.

The guide to accurate stocktaking provides the groundwork. A reliable indicator for a few categories is more valuable than an apparently precise ranking based on missing cost data.

The limitations of an appealing indicator

GMROI does not directly measure contribution after packing, customer advice, or shipping. A small consumable may show strong inventory returns while requiring substantial handling per euro of margin. A more expensive accessory may tie up more capital but generate an important contribution in a single transaction.

The ratio also does not measure sales lost during stockouts. Keeping too little stock may improve the denominator while preventing purchases. Combine GMROI with availability rates, unfulfilled demand, and total gross margin.

Finally, comparing a favorable quarter with a full year is not valid. Automatically multiplying the quarterly result by four assumes consistency that has not been demonstrated. For a newly launched range, state how long it has been on sale and account for launch costs separately.

Use GMROI to make decisions, not just rankings

A low-GMROI category may call for different responses: lower stock, different replenishment, better presentation, or removal of certain products. Identify the underlying cause before choosing an action. ABC analysis helps locate priorities; GMROI adds the question of tied-up capital.

Then define a measurable test: reduce order quantities without affecting availability, eliminate a duplicate, or reorganize a department. Compare average inventory, gross margin in euros, and stockouts over suitable periods. A higher ratio accompanied by a collapse in total gross margin is not automatically an improvement.

Finally, relate the findings to the purchasing budget and margin calculator. The best assortment is not the one with the most attractive percentages, but the one that uses available capital efficiently while meeting actual customer demand.