BBampaa

Lessons › Assortment & Category Planning › Decisions

Assortment & Category Planning lesson

Weeks to clear

Divide stock by weekly sales to see how long it takes to clear, then compare with the weeks left in the season.

Try this lesson free →
About 5–10 minutes · no sign-up needed

The idea

Divide stock by weekly sales to see how long it takes to clear, then compare with the weeks left in the season:

Formulas

Stock ÷ Weekly units

Key points

Weeks to clearHow long the stock will take to sell at today's rate.
Work it outDivide the stock by the units sold each week.
Read itMore weeks to clear than weeks left in the season means stock will be left over. Plan the exit now.

Start the exit early: small markdowns now cost less than big ones at the end.

Practice

Try each one in your head first, then open the answer.

1. In E2, work out how many weeks the leather case will take to clear: stock ÷ weekly units.
=B2/C2
2. How many weeks will the car mount take to clear?
250 ÷ 25 = 10 weeks
3. Tap a SKU that won't clear before the season ends.
The leather case (15 weeks) and the car mount (10 weeks).

Learn 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 →
About 5–10 minutes · no sign-up needed