merchmix

Publish Date :

The Overlap Hiding in Your Range

Range overlap becomes a buying problem when several options serve much the same customer need while each carries its own stock commitment. Atlas helps test the evidence and Core turns the chosen range into option and depth assumptions, without assuming that removing one style transfers all its sales to another.

A young buyer comparing three subtly different beige cardigans on a buying-studio rail.
Editorial image: a young buyer comparing three subtly different beige cardigans on a buying-studio rail.

THE MERCHMIX DECISION / Atlas + Core

Three options may answer one customer need

Near-duplicate options deserve a customer-role and availability test before the next range commits stock to all of them again.

Independent retail planning example. Financial amounts are US dollars. Forecasts, quantities and proposals are assumptions for this decision, not customer results.

merchmix.Atlas + Core / Beige cardigans / customer-role overlap
Customer roleCurrent assumptions

Beige cardigans / customer-role overlap

Customer roleDecision comparison
Options3
Opening per option60 units
Observed total sales60 units
V-neck sold
30 units
Crew-neck sold
18 units
Shawl collar sold
12 units
Three options may answer one customer need
CardiganOpeningSoldClosing
V-neck603030
Crew-neck601842
Shawl collar601248
120 units remain across the three options

Similar appearance is a reason to investigate overlap, not proof of substitution.

Three options may answer one customer need

Compare like-priced beige cardigans in the same stores and period.

THE KEY IDEA

Reduce overlap only when the evidence supports the customer choice, retained demand and stock commitment of the smaller range.

Look for duplicated customer roles, not just similar photographs

Three beige cardigans can differ in fit, warmth, neckline and price in ways that matter to customers. A range review should first ask whether they solve different needs. Similar imagery can reveal a review candidate, but it cannot establish that any option is commercially redundant.

Use Atlas to compare the same stores, selling period, price basis and availability. A weak sales record may reflect missing sizes or late arrival. Core provides the range-planning context for the next choice; it should not turn an incomplete comparison into an automatic instruction to remove a product.

Product evidence and planning referencesMerchmix Atlas: product capabilities and workflow context Merchmix Core: product capabilities and workflow context

Read the whole commitment behind the overlapping options

In an independent four-week example, a retailer opens with sixty units each of a V-neck, crew-neck and shawl-collar cardigan. Sales are thirty, eighteen and twelve respectively. Of the 180 units originally available, sixty have sold and 120 remain. There are no receipts or returns in this comparison.

All three cost $32 and sell at $80. Their combined product gross profit is $2,880 on the sixty sales. The remaining stock costs $3,840. These figures identify the scale of the review; they do not prove that the two slower necklines have no customer purpose.

Write down the substitution assumption before cutting an option

A proposed next-season test retains two options with sixty units each. It commits 120 units at $3,840 rather than 180 at $5,760, a $1,920 difference in planned goods commitment. That is a proposed smaller buy, not cash already recovered from existing stock.

The key uncertainty is how much demand survives the removed choice. Some customers may select another neckline, while others may leave. Core can retain the alternative option plan; the retailer must support its demand assumption rather than add all of the removed option’s sales to the remaining styles by default.

THE FIGURES BEHIND THE DECISION

The Overlap Hiding in Your Range: Three-option closing: 180 less 60 = 120. Two-option cost: 120 × $32 = $3,840. At 54 sales, closing is 66 and product gross profit is 54 × $48 = $2,592.
EvidenceDecision question
AvailabilityCould customers buy the offered sizes?
Retained demandDid a missing option lose a distinct customer?
Stock and marginWas the lower commitment worth the trade-off?

Three-option closing: 180 less 60 = 120. Two-option cost: 120 × $32 = $3,840. At 54 sales, closing is 66 and product gross profit is 54 × $48 = $2,592.

Compare the cost of less choice with the lower stock exposure

If the smaller range sells 54 units at $80, closing stock is 66 and product gross profit is $2,592. If it sells only 42, closing is 78 and gross profit is $2,016. Both leave less stock than the original illustration, but both also produce less gross profit than sixty sales.

The comparison excludes operating costs, returns, markdowns and any effect of the altered product mix on unit cost. It shows the trade-off to investigate rather than declaring that fewer options always improve profit. A convincing decision needs the customer role and likely selling outcome as well as the smaller commitment.

THE PLANNING REFERENCERead the assortment planning guide

Use a matched test to challenge the overlap hypothesis

Choose a comparable set of stores or a defined channel test, with an explicit selling window and available sizes. Record which options were offered and which other conditions changed. Atlas can organise the sales, stock and price evidence when those fields are supplied consistently.

A test with different traffic, marketing or availability does not isolate the effect of the removed option. Treat the observed difference as evidence requiring interpretation. Keep customer feedback and substitution observations alongside the numbers, especially where the eliminated neckline serves a fit or occasion that the others do not.

Turn the learning into a specific Core range choice

The outcome should name the retained customer needs, selected options, store scope and depth per option. Core supports range and assortment planning so the decision can be reflected in the next merchandise plan. It is more useful than ending the review with a generic instruction to reduce SKU count.

Existing stock still needs its own plan. A smaller next buy does not remove the 120 units left in the current example. Keep any transfer, later selling opportunity or exit decision separate so projected commitment reduction is not presented as clearance of stock already owned.

SignalMerchmix workspaceDecision to review
Customer roleAtlas / evidenceCompare like-priced beige cardigans in the same stores and period.
Overlap hypothesisCore / comparisonA two-option test would commit 120 units rather than 180.
Range decisionAtlas / decision reviewAtlas supplies the comparison; Core records the selected option and depth assumptions.

Keep a reason for every retained and removed option

Document whether an option was retained for incremental demand, a fit requirement, a price role or a meaningful regional need. If evidence is inconclusive, set a narrower test rather than declare the entire range duplicated. The next review should be able to revisit the assumption.

Atlas supports a comparable evidence view and Core records the range response. The useful result is a deliberate set of choices that customers can buy in the right depth, with the commercial effect measured rather than inferred from a smaller number of product photographs.

BEFORE THE NEXT DECISION

  • Planning owner

    The $32 unit cost is held constant; customer response remains uncertain.

  • Commercial owner

    The example assumes all sales occur at $80 and excludes other expenses.

  • Decision owner

    Atlas supplies the comparison; Core records the selected option and depth assumptions.

Common questions

Does a similar-looking option always duplicate demand?

No. Fit, material, occasion, price and size availability can give visually similar products different roles.

Does the smaller buy save $1,920 immediately?

No. It is a difference between proposed future goods commitments, not a completed saving or recovery of existing stock.

Why test both 54 and 42 sales?

They show how different retained-demand assumptions change gross profit and closing stock in the smaller range.

Can Atlas prove cannibalisation from sales alone?

No. Comparable availability, traffic, offers and test conditions are also needed to interpret the evidence.

What belongs in Core after the review?

The selected options, customer roles, store scope, depth assumptions and a documented reason for the next range choice.

atlas

Compare like-priced beige cardigans in the same stores and period.

Explore
core

A two-option test would commit 120 units rather than 180.

Explore

Continue reading: How range width affects size depth

Read the retail planning glossary

FROM THE ARTICLE TO YOUR OWN RETAIL PLAN

Review the decision.
See the workflow.

Bring your planning questions to a demo, or explore a proof of concept on your own data.

Book a demo Explore the proof of concept