How the GMROI Calculator works
GMROI (Gross Margin Return on Investment) measures how much gross margin a business earns for every dollar it has tied up in inventory. It is a standard retail and merchandising metric used to compare how efficiently different products, categories, or vendors turn inventory dollars into profit — a fast-moving, low-margin item can outperform a slow-moving, high-margin one once inventory investment is accounted for.
The formula
GMROI = Gross Margin ($) ÷ Average Inventory at Cost ($)
Gross margin is Net Sales − Cost of Goods Sold (COGS). Average inventory at cost is the beginning inventory plus ending inventory, divided by two — both valued at what the business paid for the goods, not at retail selling price. Dividing gross margin by that average inventory investment gives a ratio: how many dollars of gross margin came back for every dollar carried in stock.
Worked example
Take net sales of $500,000, COGS of $300,000, beginning inventory of $80,000, and ending inventory of $100,000. Gross margin is $500,000 − $300,000 = $200,000 (a 40% gross margin). Average inventory at cost is ($80,000 + $100,000) ÷ 2 = $90,000. GMROI is $200,000 ÷ $90,000 ≈ $2.22 — every dollar tied up in inventory returned about $2.22 of gross margin over the period.
Reading the result
A GMROI of $1.00 is breakeven: the gross margin generated exactly equals the cost of the inventory carried to earn it. Below $1.00, the inventory investment did not return its own cost in gross margin. Many retailers use a rough target of $2 to $3, but the right benchmark differs sharply by category — high-turnover, low-margin categories like groceries and slow-turnover, high-margin categories like jewelry or furniture have very different natural GMROI ranges, so comparisons are most meaningful within a similar category or against the same category's own history.
What GMROI does not capture
- Operating costs: gross margin excludes rent, labor, marketing, and overhead, so GMROI measures inventory efficiency, not overall store or company profitability.
- Carrying costs: storage, insurance, shrinkage, and obsolescence are not subtracted, so two categories with the same GMROI can have different true net returns.
- Timing within the period: averaging only the beginning and ending balance can mask large swings from a mid-period bulk purchase or a stockout.