RETAIL · ASSORTMENT & PRIVATE LABEL
A European general retailer had spent eighteen months trying to improve the value of its breakfast aisle : structural margin 2 to 4 points below the category average, 12 to 15 linear meters of shelf space occupied, and little negotiating leverage with national brands.
The project : remove 40 % of SKUs to free 6 linear meters of shelf space for a premium private label. €12 million in investment, more than €8 million in projected annual margin. Commercial leadership would not commit the money without knowing what customers actually do when their product is no longer there.
THE PROBLEM
Assortment rationalization aims to improve clarity, increase rotation, simplify operations and create the space needed for a higher-margin premium private-label range. But not every SKU plays the same role in the shopping missions of the people who buy it.
Two competing retailers had recently redesigned their breakfast aisles. One increased margin without losing traffic. The other triggered a sustained decline in visits across the entire affected store area. The same apparent decision, two outcomes.
Internal customer studies, built on stated panel responses, could not resolve the question : how many shoppers really switch, how many stay with a smaller basket, how many move their purchase to the private label, and how many transfer the frustration to adjacent categories.
WHAT THE DECISION HAD TO SOLVE
A MECHANISM : WHAT PEOPLE SAY IS NOT WHAT THEY DO
68 % of shoppers in the aisle say they would switch retailers if their favorite SKU disappeared. In a 12-week behavioral simulation, 11 % do. The gap is structural : shoppers anticipate a frustration they do not act on, because the real cost of switching retailers exceeds the actual frustration caused by one aisle.
That gap does not eliminate the risk. It shifts where to look for it.
A DISTINCTION : ROTATION VS LOYALTY VALUE
Traditional assortment analysis looks at sales, rotation and margin. It does not show what a SKU does to the shopping mission of the person buying it. Three shopper typologies represent 8 % of aisle customers and 14 % of its revenue : once their SKU is removed, their trajectory remains negative at 12 weeks. The revenue line did not reveal their weight.
WHAT IS TESTED
The 34 configurations tested vary more than one parameter. They combine reduction depth, affected product families, signage, shelf positioning, price gap and deployment sequence.
4,200 synthetic shoppers were interviewed individually in a simulated aisle environment, exposed to the 34 configurations through incremental variations, with follow-up questions at identified tipping points and modeled purchasing trajectories across the 7 adjacent categories.
The reconstructed population covers 2.8 million shoppers at the retailer, calibrated on proprietary data — loyalty cards, anonymized receipts and behavioral panels — and public sector data. No personally identifiable data entered the system.
It is structured into 19 breakfast shopping-behavior typologies combining purchase frequency, price sensitivity, brand attachment, household structure, multi-retailer mix and sensitivity to assortment gaps.
PURCHASE FREQUENCY
2.8 million shoppers at the retailer, from weekly visitors to occasional buyers
PRICE SENSITIVITY
on its own, it does not predict the reaction to a SKU disappearing
BRAND ATTACHMENT
from easy substitution to exclusive loyalty to one specific national brand
HOUSEHOLD STRUCTURE
the same basket can contain multiple preferences within the household
MULTI-RETAILER MIX
some households already shop at several retailers, others at only one
SENSITIVITY TO ASSORTMENT GAPS
population calibrated on loyalty-card data, anonymized receipts and sector panels
These configurations reveal part of the population's heterogeneity. The simulation operates on synthetic individuals, not a handful of persona types.
REACTIONS
STATED INTENT MASSIVELY OVERSTATES SWITCHING
68 % of shoppers say they would switch retailers if their favorite SKU disappeared. In a 12-week behavioral simulation, 11 % actually do. The real cost of changing retailers — habits, distance, coherence of the rest of the shopping trip — exceeds the actual frustration caused by one aisle. The vast majority try the private label, choose an alternative, or adjust their habits.
THE REAL RISK SITS IN THE ADJACENT CATEGORY
Shoppers frustrated in breakfast also reduce their basket across seven adjacent categories — sweet biscuits, hot drinks, spreads, fresh dairy products, packaged pastries, jams and dietary products — for 8 to 12 weeks, with an average 14 % decline in category basket value. The cumulative cross-category loss exceeds the additional margin generated by the premium private label.
DEPLOYMENT SEQUENCE CHANGES THE OUTCOME
An abrupt switch — removal and introduction simultaneously in week 0 — achieves 34 % shopper acceptance. A gradual switch — premium private label in week 0, national brands removed between weeks 4 and 12 — achieves 71 %. A shopper who discovers the private label while established brands are still present can adopt it by choice; one who discovers it only after those brands have been removed experiences it as a constrained choice and transfers frustration to other categories.
SIGNAGE MATTERS MORE THAN A PRICE CUT
Two strategies with equivalent cost to the retailer were compared: a premium private label at −15 % versus national-brand prices without dedicated signage, and the same offer at −5 % with distinctive shelf space, premium-coded packaging, end-cap placement and catalog promotion. The second, despite being more expensive for the shopper, gains an additional 24 points of adoption and 31 points of perceived quality.
THE 19 TYPOLOGIES DO NOT ADAPT AT THE SAME SPEED
Seven typologies — retailer-loyal shoppers, health-led shoppers, families with children — adopt the premium private label within 4 to 6 weeks and increase their category basket. Nine typologies — price shoppers, habit-driven shoppers, seniors — adapt within 8 to 14 weeks with a stable basket. Three typologies — ultra-loyal customers of a specific national brand, occasional shoppers sensitive to assortment gaps, multi-retailer families — lose 22 % of category basket value, with the loss still present at 12 weeks.
A MECHANISM : THE LOSS IS NOT WHERE YOU LOOK FOR IT
A shopper does not come to buy one SKU : they come to do their shopping. Frustration at one point in the journey transfers to the next points. Shoppers frustrated in breakfast reduce their basket by an average of 14 % across seven adjacent categories for 8 to 12 weeks.
The cumulative cross-category loss exceeds the additional margin generated by the premium private label in the original aisle. This finding invalidated the abrupt-switch strategy initially being considered.
A DISTINCTION : NEW OPTION VS FORCED CHOICE
A shopper who discovers the premium private label while established brands are still on the shelf can adopt it by choice. A shopper who discovers it after those brands have been removed experiences it as a forced choice : frustration is then transferred to other categories. The product is identical. Its interpretation is not.
A MECHANISM : SEQUENCE IS A DECISION VARIABLE
34 % shopper acceptance for the abrupt switch, 71 % for the gradual switch over 12 weeks. The final aisle composition is the same. Only the order of operations changes.
The gradual switch also preserves the basket across adjacent categories, where the abrupt switch degrades it.
COMPARISON
Only dimensions for which the case documents measurements carry numerical values. “Not published” is retained rather than replaced by an estimate.
PREMIUM SIGNAGE, −5 %
Recognition adoption : +24 pts adoption, +31 pts perceived quality
PRICE GAP, −15 %
Price promise trade-off : equivalent cost to the retailer, lower adoption
THE STRATEGY SELECTED
The executive committee approved the dominant strategy : a gradual switch over 12 weeks, dedicated premium private-label signage — distinctive shelf space, premium packaging, catalog promotion —, a moderate −5 % price gap instead of the −15 % initially considered, and targeted retention through occasional promotional listing of the three critical national brands identified.
The €12 million budget was maintained, with spending reallocated toward premium packaging and shelf signage instead of the promotional campaigns initially planned. The plan was presented to the retailer's 320 store managers, with three months of field support.
DECISION
PROJECTION, THEN OBSERVATION
Deployment began six months after the decision, once the premium private-label range had been industrialized. Over the first 24 weeks, the commercial trajectory tracked the projections with an average deviation below 6 %. The premium private label captured 42 % of aisle revenue at 6 months, above the 38 % projection.
At 18 months, breakfast-aisle margin had increased by 18 points, above the projected 15 points. The cross-category basket across the 7 adjacent aisles was up 2,8 % over the year. No lasting customer loss was detected : the aisle churn rate was exactly in line with the retailer's average rate. Three episodes of local pushback were recorded in stores where premium signage had not been deployed correctly.
These values describe what was observed after the decision. They do not establish exclusive causality between the strategy selected and each of these movements.
A TIME DYNAMIC : ROUTINES REBUILD SLOWLY
The system simulated routine assortment adjustments after stabilization : removing a low-performing SKU, introducing a new product, changing format. During the 6 months following a major switch, each minor adjustment reactivates the negative cross-category effect for 3 to 5 weeks. Routine assortment rotation therefore needs to be frozen, which runs counter to standard retail management.
TAKEAWAY
The problem was not removing 40 % of SKUs. It was identifying the ones whose removal shifts far more than their own revenue line : three shopper typologies, 8 % of aisle customers and 14 % of its revenue, whose trajectory remains negative at 12 weeks when their brand disappears.
Reducing assortment is a means, not an outcome. The decision should be read through private-label adoption, the basket in adjacent aisles, loyalty and repeat visits — not the number of SKUs removed. Customers do not consume an assortment : they consume routines.
POSSIBLE FUTURES
A
ABRUPT SWITCH
−40 % of SKUs and premium private label on the same day
B
PRICE RATHER THAN SIGNAGE
premium private label at −15 % versus national-brand prices, with no distinctive shelf space
C
GRADUAL, SIGNALED, WITH TARGETED RETENTION
private label in week 0, removals between weeks 4 and 12, dedicated signage, critical brands retained
METHOD
2.8 million synthetic shoppers calibrated on the retailer's proprietary data and sector panels, 19 shopping-behavior typologies, 34 assortment configurations presented to 4,200 shoppers interviewed in a simulated aisle, then projected over 12 weeks : 258 distinct trajectories by category and typology, more than 34,000 combinations evaluated in total, including cross-category effects.
This case adds a mechanism to the library : the value of one element in a system can be indirect. A SKU may account for little in its aisle but matter greatly to the relationship with the retailer. The system simulates its removal, substitution or absence, the new routine, possible switching to another retailer, and the evolution of the overall basket — beyond SKU performance alone.
This case is based on a completed simulation for a European general retailer. The client is not named, no personally identifiable data entered the system, and the detailed results remain the client's property.
The simulation does not choose which SKUs to remove, the composition of the private-label range, or the retailer's pricing policy. It examines the consequences, across different populations, of several assortment architectures and several deployment sequences.
Your next decision
Describe your need. We can point you to the right level of support.
State your decision. See the future it produces.
