Rebuilding the Womenswear Range Plan for a European Fashion Distributor
Option count cut by a fifth, depth moved into proven sizes and colours, monitored weekly through one Power BI model.
Womenswear Range Planning Challenge
The range had grown season by season: more options every time, less depth behind each one. Stores ran out of core sizes early while fringe colours went to markdown.
Size curves were copied from the previous plan, including the distortions caused by stock-outs.
- Broken size runs by week four in core lines
- Markdown absorbing a growing share of margin
- No shared view of sell-through between buying and finance
What Was Done to Rebuild the Womenswear Range Plan
Range architecture review by category and price tier
Options compared with sell-through and margin history.
Size and colour curves recalculated
Returns, stock-outs and promo weeks removed from the history.
New buy plan and open-to-buy model
Depth moved into proven options, phasing by month.
Weekly range monitoring in Power BI
Sell-through and size integrity tracked against plan.
Womenswear Range Plan Results in Numbers
placeholder figuressell-through on core categories
option count
markdown spend across two seasons
Tools Used in the Range Plan Project
Excel buy plan and open-to-buy
Phasing and scenario comparison.
Power BI range monitoring
Weekly sell-through and size integrity.
Related Service: Assortment Planning and Range Management
Range architecture, size curves, buy plan and in-season monitoring, adapted to your categories and markets.
Fewer options, more depth — the hardest conversation was the first one.
Retail and Fashion Analytics Case Studies
Standardising Product Data Across European and Asian Markets in a PLM System
Multi-market fashion brand. One attribute dictionary replaced many local conventions.
Building a Price Ladder and Margin Report for a Fashion E-commerce Retailer
Entry and exit prices per category, aligned across three markets and monitored weekly in Power BI.
Setting Up a Weekly Retail Trade Report for a Multi-Brand Retailer
One agreed definition set and a Monday report that replaced four competing spreadsheets.