Lessons › Assortment & Category Planning › Decisions
Assortment & Category Planning lesson
Units needed a week
To clear before the season ends, divide the stock by the weeks left.
Try this lesson free →The idea
To clear before the season ends, divide the stock by the weeks left:
Formulas
Stock ÷ Weeks leftKey points
Units needed a weekHow many must sell each week to clear the stock before the season ends.
Work it outDivide the stock by the weeks left in the season.
Exit toolsIf today's sales are lower, use markdowns, move stock to the stores that sell it, or bundle it.
Compare what's needed with what sells now: the gap tells you how hard to push.
Practice
1. How many leather cases a week must sell to clear the 300 in 6 weeks?
300 ÷ 6 = 50 a week, 2.5 times today's rate2. In E3, work out how many car mounts must sell a week to clear by the end of the season: stock ÷ weeks left.
=B3/D33. Tap the SKU already selling fast enough to clear.
The power bank needs 60 a week and already sells 120.4. The leather case needs 50 a week but sells 20. What's the best first step?
Mark it down, and move stock to the stores where it sells bestLearn it by doing. This lesson is a short hands-on level on Bampaa: see it work, then build and write it yourself, with instant feedback.
Try this lesson free →