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.

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.
Beige cardigans / customer-role overlap
| Cardigan | Opening | Sold | Closing |
|---|---|---|---|
| V-neck | 60 | 30 | 30 |
| Crew-neck | 60 | 18 | 42 |
| Shawl collar | 60 | 12 | 48 |
Similar appearance is a reason to investigate overlap, not proof of substitution.
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.
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
| Evidence | Decision question |
|---|---|
| Availability | Could customers buy the offered sizes? |
| Retained demand | Did a missing option lose a distinct customer? |
| Stock and margin | Was 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.
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.
| Signal | Merchmix workspace | Decision to review |
|---|---|---|
| Customer role | Atlas / evidence | Compare like-priced beige cardigans in the same stores and period. |
| Overlap hypothesis | Core / comparison | A two-option test would commit 120 units rather than 180. |
| Range decision | Atlas / decision review | Atlas 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.
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.