Range Planning in Merchandising: Building Assortments That Actually Sell Through

Range planning is where things stop being theoretical. This is where decisions start tying up cash.

It defines what actually lands in inventory. Not just styles, but sizes, colors, quantities—and where all of it sits across stores and channels.

Merchandise planning sets the guardrails. Demand planning estimates what might sell. Range planning is where you decide what you’re willing to back with capital.

That distinction matters. Because once a SKU enters the range, it’s no longer a plan. It’s inventory. It’s cash sitting on a rack or in a DC.

Every SKU carries two things:

• A demand assumption
• A capital commitment

Get the balance wrong, and the consequences show up fast.

Too much variety spreads demand thin. You get shallow buys, broken size runs, and predictable markdowns. Too little variety, and you simply miss demand—customers walk because the product isn’t there.

This is where teams often misread the role. Range planning isn’t about curating an appealing assortment. It’s about distributing risk across SKUs in a way that protects sell-through, turns, and margin.

If the range is wrong, nothing downstream fixes it. Allocation can’t create demand. Promotions can’t compensate for poor depth. Replenishment won’t rescue a bad initial buy.

Sell-through, inventory turns, markdown exposure—these aren’t just execution outcomes. They’re largely set when the range is built.

The uncomfortable reality: range planning is where you choose your problems. Stockouts or overstock. Higher turns or higher markdowns. There’s no neutral ground.

The Core Trade-Off: Breadth vs Depth

At the center of range planning is a simple trade-off most teams overcomplicate.

Breadth is how many options you carry—styles, categories, variations.
Depth is how much you commit to each—units per SKU, per size.

You don’t get to maximize both.

Push breadth, and depth thins out. Push depth, and assortment narrows. That decision shows up quickly in size availability, conversion, and stock health.

Why Most Retailers Over-Assort

Most retailers lean toward too much choice. It feels safer.

More styles. More colors. More coverage.

In reality, it fragments demand.

You end up with:

• More styles than you can support
• Buys that are too shallow
• Size curves that break early

A typical example: a mid-tier fashion retailer builds a wide denim range. Plenty of fits, washes, and price points. On paper, it looks strong.

Two weeks in, core sizes in top styles are gone. Edge sizes sit. Store teams hear “Do you have this in my size?” more than they close sales.

The issue isn’t demand. It’s dilution.

Too many SKUs, not enough conviction. Sales spread thin. No product reaches its potential. Everything performs… okay.

What Good Range Planning Looks Like

Strong range planning is more opinionated.

Fewer SKUs. Clearer bets.

Depth aligns with how products actually sell—not evenly distributed, but intentionally skewed.

Core products carry depth. These are your volume drivers. You protect size availability because they carry the business.

Trend products stay lighter. They test demand, create interest, and can deliver margin if they hit—but you don’t overcommit upfront.

It also requires accepting imbalance. Not every SKU deserves equal investment.

When this works, you see:

• Higher sell-through on key items
• Fewer size breaks in core
• Less reliance on markdowns
• Stronger GMROI because capital is concentrated

It may look less exciting on a line sheet. It performs better on a P&L.

From Demand Signals to SKU Decisions

Range planning is where data turns into actual buys.

Inputs are familiar:

• Historical sales (ideally at size level)
• Trend direction from design and market signals
• Price architecture
• Customer segmentation by channel or region

But inputs don’t matter unless they translate into SKU-level decisions.

How many styles? How many colors? What size curve? How many units?

That’s the real work.

The SKU Is the Unit of Risk

Every SKU needs to justify its existence.

Shelf space. Working capital. Operational complexity.

One SKU selling 80 units clean is more valuable than three SKUs selling 30 each with leftover inventory.

Key metrics should live at this level:

• Sales per SKU
• Sell-through by variant
• Margin after markdowns

If you stay too high-level, problems stay hidden in the averages.

Option Count Discipline

This is where ranges usually break.

Too many colors. Too many minor variations. Differences that look meaningful in reviews but behave the same in-store.

It creates the illusion of choice without adding demand.

Customers don’t evaluate ten options. They decide quickly: this works, or it doesn’t.

Operationally, the impact is predictable:

• Less depth per option
• Fragile size curves
• Faster stockouts on winners
• Excess on slower variants

Take a footwear example. A sneaker launches in eight colorways. Only two resonate. All eight get bought anyway.

The two winners sell out quickly. The rest linger and get discounted.

Cut that to four options with deeper buys, and outcomes change—better availability, more concentrated sales, lower markdown risk.

Reducing complexity isn’t aesthetic. It’s financial.

The Financial Structure Behind the Range

Range planning isn’t creative first. It’s financial.

Every decision flows into WOS, OTB, and cash sitting in inventory.

Overbuy, and WOS builds. Inventory ages, then gets marked down.
Underbuy, and you stock out early. Full-price sales disappear.

Neither is recoverable in-season.

Core SKUs should carry higher WOS—controlled, not excessive. They’re predictable. You trade some margin for reliability and volume.

Fashion SKUs are different. Lower WOS, higher margin expectations. You only scale depth if early signals support it.

This creates a clear structure:

• Core: deeper, stable, lower risk
• Fashion: lighter, reactive, higher risk

Most retailers blur this—and pay for it. They overbuy fashion and underprotect core.

That’s how margin drivers get marked down, while volume drivers stock out.

Range planning also defines markdown exposure upfront.

A range heavy on low-confidence SKUs behaves very differently from one concentrated in proven products.

CFOs aren’t looking at assortment balance. They’re watching:

• Inventory turns
• GMROI
• Cash conversion

Range decisions drive all three.

You can’t fix weak inventory productivity with better reporting. It has to be built into the range.

Localization: One Range Doesn’t Fit All

Pushing one range across all stores is usually a shortcut—and it shows.

Stores differ. Traffic, customer mix, climate, selling patterns.

Ignore that, and you get:

• Overstock in slower stores
• Stockouts in faster ones
• Poor sell-through in mismatched locations

Store clustering is the practical fix.

Group stores by similar demand patterns, then adjust:

• Depth by store velocity
• SKU inclusion/exclusion
• Size curves based on local demand

Range defines what exists. Allocation decides where it goes.

If the range ignores localization, allocation teams spend the season redistributing inventory instead of executing.

Think outerwear across mixed climates. Same depth everywhere leads to excess in warm regions and stockouts in cold ones. Transfers follow. Margin erodes.

Localization doesn’t eliminate imbalance. It reduces how much you have to fight it.

In-Season Feedback Loops

Range planning doesn’t end when buys are placed. That’s where control is usually lost.

The range needs active management.

Key signals:

• Sell-through by SKU and size
• WOS movement
• Store-level performance
• Rate of sale vs plan

These aren’t just reports—they’re triggers.

If a SKU outperforms, you chase. Replenish, reallocate, protect size availability.

If it underperforms, act early. Cancel receipts where possible. Mark down selectively before inventory builds.

Wait too long, and options narrow. Size breaks hurt conversion. Excess becomes harder to clear without margin loss.

There’s also the substitution effect. Some customers switch when sizes are missing. Many don’t. They leave.

That lost demand doesn’t always show cleanly—but it’s there.

Post-season, all of this feeds forward:

• Where was the range overbuilt?
• Where did size curves fail?
• Which SKUs justified depth?

Option counts tighten. Depth adjusts. Risk gets redistributed.

The best teams treat range planning as a system, not a one-off decision.

They don’t expect perfection upfront. They build the ability to adjust quickly—and learn every cycle.

That’s the difference between managing inventory and constantly reacting to it.