Assortment Planning and Range Management Consulting for Fashion Retail
A range built on evidence: how many options per category, how deep per size and colour, and which markets carry which part of the buy.
Assortment Problems This Consulting Service Solves
Too many options, too little depth per option
The range looks rich on paper and sells thin in store: broken sizes by week four, and no bestseller with stock behind it.
Size and colour splits copied from last season
Curves are inherited rather than calculated, so returns and stock-outs quietly distort every following buy.
One range pushed into very different markets
The same assortment ships to markets with different climates, price expectations and store sizes, and markdown absorbs the difference.
No agreed numbers between buying and finance
Every meeting starts by reconciling two versions of sell-through instead of deciding what to buy.
What Assortment Planning and Range Management Work Includes
Five workstreams, delivered in order, each with a document your team keeps.
Category and range architecture review
Option counts by category, price tier and market, against sell-through and margin history.
Size and colour curve calculation
Curves rebuilt from cleaned sales: returns, stock-outs and promo weeks excluded.
Buy plan and open-to-buy model in Excel
One model your planners maintain: units, cost, margin and phasing by month and market.
In-season range monitoring in Power BI
Weekly sell-through, stock cover and size-integrity view, with agreed definitions.
Handover workshops for buying and planning teams
Two sessions plus written documentation, so the next season runs without me.
Results Clients Get from Assortment Planning Consulting
placeholder figuressell-through on core categories in the first full season
option count, with depth moved into proven sizes and colours
markdown spend across two consecutive seasons
Tools Used in Assortment Planning Projects
Advanced Excel for the buy plan
Open-to-buy, phasing and scenario comparison.
Power BI for in-season monitoring
DAX measures for sell-through, cover and size integrity.
PLM data as the range backbone
Clean category, season and colour attributes behind every count.
Related Case Study: Rebuilding the Womenswear Range Plan for a European Fashion Distributor
Rebuilding the Womenswear Range Plan for a European Fashion Distributor
Option count cut by a fifth, depth moved into proven sizes and colours. Sell-through up, markdown down.
Recommendation from a Fashion Retail Colleague on Assortment Planning Work
Placeholder — real LinkedIn recommendations will be added with permission“Placeholder recommendation text. Two or three sentences from a colleague on the assortment planning project, quoted with permission once the real recommendation is in place.”
Assortment Planning Consulting FAQ
Two seasons at SKU and week level, with stock and returns. One season is workable but the curves carry more uncertainty.
Yes. The model keeps one range architecture and lets depth, size split and phasing differ per market, so each market plan stays comparable.
Your planning team. The model is built in the tools they already use, documented, and handed over in two workshops.
Discuss an Assortment Planning Project with Tatsiana Bandziuk
Placeholder note: send me the category you are least sure about. I will tell you what the data would have to show for the range to be right.
Tatsiana