GMROI by Category: The $3-Return SKUs Hiding in Your Mix

GMROI by Category: The $3-Return SKUs Hiding in Your Mix

Chain-level GMROI of $2.40 hides categories returning $0.80 and categories returning $5.10. How to decompose the number and where the rebalancing math actually lives.

Contents

Why the chain-level GMROI number misleads

Gross Margin Return on Investment is simple math: gross margin dollars divided by average inventory cost. A GMROI of $2.40 means every dollar of inventory investment returned $2.40 in gross margin over the period. Most retailers calculate it at the chain level and report it quarterly.

The chain-level number is the wrong unit of analysis. A $2.40 chain GMROI typically decomposes into categories returning $0.80 and categories returning $5.10. The categories at the top are subsidizing the categories at the bottom, and nobody in the merchandising review notices because the average looks fine.

Decomposed GMROI is the metric that drives reallocation. The chain number is a scorekeeping artifact. The category-level number is an operating signal.

The decomposition

For a mid-market specialty retailer, the decomposition typically looks like this:

  • Top quartile categories: GMROI of $4.50-$6.20. High velocity, healthy margin, fast turns. Usually 25-30% of categories doing 40-50% of margin dollars.
  • Second quartile: GMROI of $2.60-$4.40. Solid contributors, healthy margin, moderate turns. The bulk of the assortment.
  • Third quartile: GMROI of $1.40-$2.50. Acceptable but uninspiring. Frequently the categories that have been in the assortment "forever."
  • Bottom quartile: GMROI of $0.40-$1.30. These categories return less in margin dollars than the working capital they consume. They're net-negative contributors when carrying costs are added.

The math gets uncomfortable in the bottom quartile. A category with $800K in average inventory generating $1.0M in gross margin (GMROI of $1.25) sounds fine. Apply a 24% carrying cost: $192K of working capital cost. Apply allocated markdown and shrink: another $80-120K. Net contribution is $700-730K against a working capital lockup of $800K. The category is barely paying for itself, and it's tying up dollars that could be deployed against $4-5 GMROI categories.

The rebalancing math

Reallocating $200K of inventory investment from a $1.25 GMROI category to a $4.50 GMROI category produces $650K more in annual margin contribution. The retailer didn't grow inventory, didn't add SKUs, didn't expand stores. They shifted capital toward where the math worked.

Most retailers leave $2-4M annually on the table from sub-optimal category allocation because nobody runs the decomposition. The chain-level GMROI is acceptable, the merchandising review is calendar-driven, and the bottom-quartile categories survive on inertia.

SKU-level GMROI within categories

Category-level decomposition is the first cut. The second cut is SKU-level GMROI inside each category. The variance is usually larger than the category-to-category variance.

A category with $3.20 GMROI contains:

  • 10-15% of SKUs at $6+ GMROI. These are the velocity drivers.
  • 40-50% at $2-5 GMROI. The healthy mid-tail.
  • 25-30% at $0.50-$2 GMROI. The slow-turning long tail.
  • 10-15% at sub-$0.50 GMROI. The capital traps.

The capital traps deserve specific attention because they're often the SKUs the buyer is emotionally attached to. The "completeness of assortment" argument keeps them in the mix. The "halo effect" argument keeps them on shelf. The "this customer expects to see this" argument keeps them ordered. None of those arguments survive contact with the GMROI math.

One specialty hardware chain ran the decomposition across their assortment of 14,000 SKUs. They found 1,800 SKUs in the sub-$0.50 GMROI bucket consuming $4.2M in working capital and contributing $1.6M in margin. After accounting for carrying costs and markdowns, the net contribution was approximately $200K. The same working capital deployed against $4+ GMROI SKUs would have contributed $14-16M.

The cleanup wasn't a 1,800-SKU delete. It was a tiered review: 600 SKUs eliminated, 700 reduced to clearance and discontinued, 500 retained for assortment reasons but with stock floor cut by 60%. Working capital recovered: $2.8M. Reallocated to high-GMROI categories. Year-one margin contribution: $11.4M.

The store-level overlay

A category with $3.20 GMROI at the chain level performs at $5.10 in 20 stores and $1.40 in 35 stores. The chain-level decision (carry the category, allocate this much capital) is wrong for both ends of the distribution. The 20 high-performing stores are starved of inventory. The 35 underperforming stores are overstocked on capital that's not turning.

Store-level GMROI variance is most extreme in:

  • Climate-sensitive categories: outdoor goods in northern stores vs southern stores, seasonal swings creating 4-6x GMROI gaps.
  • Demographic-sensitive categories: premium SKUs in income-stratified trade areas. The same SKU returns $7 GMROI in a high-income store and $0.80 in a value-oriented store.
  • Competition-sensitive categories: a category competing with a category killer next door performs at half the GMROI of the same category in non-competed locations.

The retailers running store-cluster GMROI rebuild assortment by cluster. Stores in cluster A get the SKUs that return well there. Stores in cluster B get the SKUs that return well there. The chain assortment becomes a portfolio of cluster assortments, not a single SKU list. Working capital deploys against where each SKU actually performs.

Continuous GMROI monitoring

Most retailers calculate GMROI quarterly. The decomposition exercise happens once or twice a year if at all. By the time the data is decomposed, half of it is stale. Markdown season has passed. New SKUs are in. Demand patterns have shifted.

Continuous monitoring flips the cadence. GMROI is computed weekly at category and SKU level across stores, with variance alerts when any cell drops more than 15% from its 90-day baseline. The merchandising team sees the categories trending toward sub-$2 GMROI before the quarter ends, not after.

The intervention math gets dramatically better. Catching a category drifting from $3.40 to $2.10 in week 3 of a quarter, when there's still 9 weeks to adjust, is fundamentally different from finding it in the quarterly review. The retailer can rebalance allocation, accelerate clearance on the slow tail, or shift promo support to the affected category. None of that is possible at quarterly cadence.

Year-one impact at scale: $3-6M in recovered margin contribution for a $400M retailer, driven by faster identification of underperforming cells and faster reallocation of working capital. The GMROI number itself doesn't change much at the chain level. The composition of the chain GMROI improves substantially.

Key takeaways

  • Chain-level GMROI of $2.40 typically hides categories returning $0.80 and categories returning $5.10. The average is a reporting artifact; the decomposition is an operating signal.
  • Bottom-quartile categories often return less in margin dollars than their working capital and carrying costs consume. Most retailers leave $2-4M annually on the table by not running this decomposition.
  • SKU-level GMROI variance within a category is usually wider than category-to-category variance. 10-15% of SKUs in a typical assortment are capital traps consuming working capital with near-zero contribution.
  • One specialty chain recovered $2.8M in working capital and added $11.4M in margin contribution by eliminating 600 sub-$0.50 GMROI SKUs and reallocating to high-GMROI categories.
  • Store-cluster GMROI variance can be 4-6x for climate, demographic, or competition-sensitive categories. Chain-level assortment decisions are wrong for both ends of the distribution.
  • Quarterly GMROI calculation is too slow. Weekly category-level monitoring with variance alerts catches drift early enough to intervene, typically recovering $3-6M annually for a $400M chain.

See how Ward detects GMROI decomposition

Ward monitors your stores 24/7 and delivers insight cards, not dashboards. First cards in 48 hours.

GMROI KPIs merchandising margin

Your stores are generating data right now.

Ward turns it into decisions. First insight cards in 48 hours.

Get a demo

Find out what your data has been hiding.

Tell us about your operation. We’ll show you the problems Ward catches — and the ones your current tools miss.

Step 1 of 3
What are your goals?
Step 2 of 3
About your operation
Step 3 of 3
Your contact info