Cash is tighter than your P&L suggests, and inventory is usually why. Gross margin return on inventory investment tells you whether the stock you're holding is earning its keep or just consuming capital. Once you start running this number by SKU and channel, it gets hard to make a purchase order decision without it.

TLDR:

• GMROI = Gross Margin Dollars / Average Inventory at Cost. Above 3.2 is healthy in retail (per widely cited retail industry benchmarks); below 1.0, your inventory destroys capital before overhead enters the picture.

• A blended GMROI hides more than it reveals. The same SKU can run 4.0 on DTC and 1.8 on Amazon after fees.

• GMROI stops at gross profit. A SKU posting 4.0 can still be net negative once fulfillment and carrying costs apply.

• Reduce average inventory first. It's the faster lever and frees working capital you can redeploy into higher-GMROI SKUs and channels.

• Iris Finance replaces the data assembly work entirely, connecting every channel and your accounting system, delivering a daily P&L with an order-level audit trail, and running scenario models on COGS or pricing changes before a purchase order goes out.

What Is GMROI (Gross Margin Return on Inventory Investment)?

GMROI measures how much gross profit you generate for every dollar tied up in inventory. A GMROI of 2.0 means each dollar of inventory at cost returned two dollars in gross margin. A GMROI of 0.8 means you're losing ground.

Revenue tells you what sold. Gross margin tells you what was left after cost of goods. GMROI tells you whether the inventory required to generate that margin was worth the investment. Without it, you can have healthy-looking margins on a product that's quietly draining your working capital by sitting on shelves too long.

As SPS Commerce notes, retailers like Walmart and Amazon use GMROI as a key inventory metric. For smaller brands, it's often the number nobody tracks until cash gets tight, part of a broader pattern where CPG brands can't answer profitability questions.

The GMROI Formula and How It Works

GMROI = Gross Margin Dollars / Average Inventory at Cost

Gross margin dollars is net sales minus cost of goods sold. Average inventory at cost is your beginning inventory plus ending inventory, divided by two, over the same period.

GMROI is a ratio, not a percentage. A result of 1.5 means every dollar of inventory at cost generated $1.50 in gross margin. There is also an expanded form worth knowing: GMROI = Gross Margin % x Inventory Turnover. Both versions produce the same result, and the expanded form shows the two levers you control: margin per sale and how quickly you cycle stock.

One detail that trips people up: inventory must be valued at cost, not at retail. Using retail values understates your inventory investment and inflates your GMROI.

GMROI Calculation: Step-by-Step Example

A brand with $1M in gross margin and $200K average inventory at cost has a GMROI of 5.0. Every dollar tied up in inventory returned five dollars in gross margin. For most retail and CPG businesses, that's a strong result.

The math: $1,000,000 / $200,000 = 5.0.

Brand B sits at 1.5. Same industry, but inventory is working much harder for Brand A. The gap usually comes from thinner margins, slower turns, or both. Brand C is breakeven. Every dollar in stock returned exactly one dollar in margin, leaving nothing to cover operating expenses or generate real profit, a sign that your CPG unit economics model needs attention.

How to Calculate GMROI in Excel

Setting up a GMROI calculator in Excel takes about two minutes. Here's the basic structure:

• A1: "Gross Margin $" | B1: your gross margin dollar input

• A2: "Avg. Inventory at Cost" | B2: your average inventory cost input

• A3: "GMROI" | B3: =B1/B2

For monthly GMROI, use one column per month and calculate average inventory as (beginning + ending) / 2 for that month. This lets you spot seasonal swings where a SKU looks profitable annually but burns capital in Q4.

To go deeper, extend the model by row: one row per SKU or per channel, each with its own gross margin and inventory inputs. A table with 10 SKUs will surface your best and worst performers faster than any blended number will.

What Is a Good GMROI? Interpreting Your Number

A GMROI above 1.0 means you're recovering more in gross margin than you have tied up in inventory cost. Below 1.0, your stock is consuming more capital than it returns in margin, before a single operating expense hits.

The widely cited threshold for healthy retail performance is 3.2 or higher. The table below maps where your number likely stands:

The right target depends on your business model. High-margin, low-velocity categories can hit 4.0 or 5.0. Grocery and commodity categories often run closer to 2.0 by design, especially once you account for food and beverage margin after trade spend. A GMROI of 2.5 in specialty retail is a very different story from 2.5 in wholesale distribution.

GMROI Benchmarks by Industry

Industry benchmarks vary more than most operators expect. Electronics ranges from roughly 2.0 to 5.0+ depending on segment. Legacy appliances sit lower, consumer electronics higher. Food and beverage typically lands between 1.5 and 3.0. Apparel generally falls in the 1.5 to 3.0 range depending on velocity and markdown exposure. Specialty retail sits in the 2.5 to 4.0 range. Health and beauty often reaches 3.0 to 5.0, moving slower but at substantially higher gross margin per unit, making it worth tracking gross margin by SKU in beauty.

In wholesale, GMROI is the most measured inventory metric among distributors, often used to decide which products to discount when inventory runs high. A GMROI of 2.0 in wholesale may reflect strong performance, while the same number in health and beauty signals underperformance.

GMROI in Retail vs. GMROI in Wholesale

Retail and wholesale use GMROI for different decisions, even though the formula is identical.

In retail, GMROI drives assortment choices: which SKUs earn shelf space, which get marked down after returns, and which get cut entirely. A product with a GMROI of 1.2 is occupying floor space that a 4.0 product could fill. That's the framing retail buyers use.

In wholesale distribution, margins are structurally thinner. Distributors operate on smaller spreads, so a GMROI of 2.0 can represent solid performance where a retailer at 2.0 would be concerned. Wholesale GMROI primarily guides purchasing volume and pricing negotiations with suppliers. When inventory runs long, it flags which products to discount first to recover working capital.

A good GMROI in wholesale generally falls between 1.5 and 2.5. Anything above 2.5 is strong given the margin environment. Below 1.5, the product is tying up capital without sufficient return to warrant the carry cost.

GMROI by SKU and Channel: Going Deeper Than a Single Number

A blended GMROI across your entire catalog is a starting point, not a decision-making tool. It averages your best SKUs against your worst and hands you a number that supports doing nothing.

The real work is at the SKU and channel level. A supplement brand might run a blended GMROI of 3.1, but find its hero SKU on DTC at 6.2 while a slow-moving bundle through wholesale sits at 0.9. The blended number hides both stories.

Calculating GMROI at the SKU x retailer x channel level reveals hidden winners and flags cash-draining SKUs. That granularity turns GMROI from a report card into a capital allocation framework: stop asking how inventory is performing and start asking where the next purchase order should go.

GMROI vs. Inventory Turnover: Understanding the Difference

Inventory turnover tells you how fast stock moves. GMROI tells you whether moving it was worth anything.

A product with 12x annual turnover sounds like a win. But if gross margin is 8%, the GMROI on that product is less than 1.0. You're cycling through capital quickly and generating almost no margin for the effort. Conversely, a slow-moving SKU with 3x turns and a 60% margin can produce a GMROI above 1.8, a far better use of working capital than the fast-moving, thin-margin alternative.

The expanded GMROI formula makes this relationship explicit: GMROI = Gross Margin % x Inventory Turnover. High turns with low margin is a treadmill. High margin with low turns ties up capital unnecessarily. You need both levers pulling in the right direction.

The Turn and Earn Index

The Turn and Earn Index is a related ratio some buyers use, calculated as gross margin percentage multiplied by inventory turns. It produces the same output as GMROI and is mostly used in grocery and hardware retail to gauge supplier performance. Different name, same underlying logic.

GMROI vs. GMROF: What Is the Difference?

Gross Margin Return on Footage (GMROF) measures gross margin dollars generated per square foot of floor or shelf space. Where GMROI asks whether your inventory investment is paying off, GMROF asks whether the physical space holding that inventory is earning its keep.

A product can post strong GMROI while quietly underperforming on footage if it occupies disproportionate shelf real estate relative to what it generates. Wholesale distributors and grocery buyers cite GMROF regularly in slotting negotiations.

When Each Metric Applies

• GMROI tells a buyer which products deserve capital. It applies across every retail format, including DTC, marketplace, and ecommerce.

• GMROF tells a store planner which products deserve space. It is only relevant where physical space is a limited resource.

If you operate entirely online, GMROF is not your metric.

Common GMROI Shortcomings and Limitations

GMROI is a gross margin metric. It stops at gross profit and knows nothing about what happens below that line. Rent, labor, shipping, shrinkage, storage fees, the cost of holding slow inventory through a slow quarter: none of it enters the calculation. A SKU can post a GMROI of 4.0 while being net negative after fulfillment and carrying costs are applied.

A few specific gaps worth knowing:

• Carrying costs are excluded. Warehousing, insurance, and obsolescence risk are real costs of holding inventory that GMROI ignores.

• Shrinkage and spoilage are not reflected. A perishable or high-theft SKU may show strong GMROI on paper while actual realized margin is much lower.

• The time value of money is absent. A GMROI of 3.0 achieved in 30 days is not the same as 3.0 achieved over 18 months, but the formula treats them identically.

• Inventory risk is undifferentiated. A seasonal product that must be cleared at a discount and a staple that sells steadily year-round can report the same GMROI while carrying entirely different risk profiles.

Use GMROI as a diagnostic, not a verdict. It tells you which inventory is worth investigating further. The actual capital allocation decision requires layering in contribution margin by channel, carrying cost, and cash flow timing.

How to Improve GMROI: Practical Strategies

Two numbers control your GMROI: gross margin in the numerator and average inventory cost in the denominator. Every meaningful improvement comes from moving one or both.

Reducing average inventory is usually the faster lever. Better inventory planning and demand forecasting tightens purchase orders so you're not carrying 90 days of a SKU that turns in 45. Liquidating deadstock shrinks your average cost basis immediately, even if you take a margin hit on clearance units.

SKU rationalization hits both sides. Cutting low-GMROI SKUs reduces the denominator, and concentrating reorders on proven performers improves blended gross margin. The hard part is that slow SKUs often feel strategically important. GMROI by SKU cuts through that.

On the numerator side, pricing and COGS are your primary tools. Modest price increases on inelastic SKUs lift gross margin without touching inventory levels. Reducing landed COGS through supplier renegotiation or better freight contracts improves margin on every unit you already planned to carry.

Fix overstock first to free working capital. Your cash conversion cycle model can show the timing. Then redeploy it into SKUs and channels where your GMROI data shows the strongest return.

How Iris Finance Helps Consumer Brands Track and Improve GMROI

Tracking GMROI at the SKU and channel level means assembling clean, unified data across every sales channel and your accounting system, and keeping it current enough to act on. That's the work most brands are still doing in spreadsheets or waiting two weeks for books to close to even start.

Iris replaces that stack entirely. It connects directly to Shopify, Amazon, TikTok Shops, QuickBooks, NetSuite, and ad platforms, with no data engineer and no ETL pipeline, and delivers a daily P&L with an order-level audit trail. GMROI by SKU and channel is already calculated and waiting for you, not something you build after the data arrives.

The benchmarking feature pulls anonymized data across roughly 500 brands representing approximately $20B in GMV, the broadest CPG financial benchmark dataset available to brands at this scale. If your inventory GMROI looks fine in isolation but sits below category peers, that gap surfaces automatically. The scenario modeling capability runs the math on a COGS reduction, price change, or channel shift before the purchase order goes out, so you see the GMROI impact without building anything. Iris runs a 97% retention rate, which reflects what happens when brands replace their financial infrastructure instead of adding another tool, consistent with what sets the most profitable brands apart.

Final Thoughts on Tracking and Improving Your GMROI

A blended GMROI across your catalog tells you almost nothing useful. The value comes from pulling it apart by SKU and channel so you know exactly which inventory is earning its keep and which is just occupying space on a shelf or in a warehouse. That granularity turns GMROI from a backward-looking report into a forward-looking capital tool. Talk to Iris if you want that level of detail without the manual work.

FAQ

What is a good GMROI in retail vs. wholesale, and how do the benchmarks differ?

A good GMROI in retail is generally 3.2 or higher, while a good GMROI in wholesale falls between 1.5 and 2.5, with anything above 2.5 considered strong given structurally thinner distributor margins. The same GMROI of 2.0 signals healthy performance in wholesale distribution but underperformance in health and beauty retail, where gross margins are wide enough to push GMROI to 3.0-5.0.

What would be the GMROI if gross margin is $1M and average inventory value is $200K?

The GMROI is 5.0 - calculated as $1,000,000 divided by $200,000. That means every dollar tied up in inventory at cost returned five dollars in gross margin, which is strong performance across most retail and CPG categories.

How do I track GMROI by SKU and channel across Shopify, Amazon, and wholesale without a data engineer?

Most brands get stuck assembling clean gross margin data and inventory costs across every channel in one place. Iris Finance connects directly to Shopify, Amazon, QuickBooks, and NetSuite, delivers a daily P&L with an order-level audit trail, and surfaces GMROI already calculated at the SKU and channel level, with no data warehouse to build and no data engineer to hire.

How do I set up a GMROI formula in Excel?

Put your gross margin dollars in B1, average inventory at cost in B2, and enter =B1/B2 in B3. For monthly GMROI tracking, use one column per month with average inventory calculated as (beginning + ending inventory) / 2, then add one row per SKU to surface your best and worst performers instead of relying on a blended number that masks both.

Is GMROI a percentage or a ratio, and how should I interpret the number?

GMROI is a ratio, not a percentage. A result of 3.0 means each dollar of inventory at cost generated $3.00 in gross margin, and it does not mean 300%. A GMROI below 1.0 means your inventory is consuming more capital than it returns in margin before a single operating expense is counted.