Beer Assortment Optimization
Optimizing the beer assortment strategy across Carrefour stores in Grand Est, Normandie, and PACA regions.
Business Context
Carrefour, France's largest retailer, needed to optimize its beer category assortment across regional stores. Consumer preferences vary significantly between Grand Est, Normandie, and PACA.
Strategic Problem
How to optimize the beer assortment in Carrefour stores across three distinct French regions (Grand Est, Normandie, PACA) to maximize sales while adapting to local consumer preferences?
Data Sources
Store-level beer sales data, regional consumer preference surveys, SKU performance metrics, shelf space allocation, competitor assortment benchmarks, and demographic data per region.
Methodology
Analyzed sales patterns by region and store format. Identified underperforming SKUs and regional preference gaps. Built an assortment optimization model factoring in local tastes, shelf constraints, and margin targets.
Key Results
Delivered a regionalized assortment strategy with tailored recommendations per geography. Reached finalist stage of the BDD challenge.
Business Impact
Applicable to any retail category management challenge requiring regional customization at scale.