Lessons › Assortment & Category Planning
10 free lessons
Assortment & Category Planning lessons
Assortment and category planning: sales velocity, ABC analysis, SKU productivity, store grading, distribution and line reviews, in Excel and Power BI.
Know your SKUs
- Sales velocityUnits per store per week
- ABC analysisThe few SKUs that make most of the sales
- SKU productivityMargin, not just sales
Stores and ranges
- Store gradingA, B and C stores
- Assortment by store gradeThe right range for each store
- Distribution% of stores carrying
Decisions
- Add, remove or expandRange decisions, by rule
- New product performanceKeep, expand or rethink?
- Exit plans for aged SKUsClear stock before the season ends
Put it together