BBampaa

Lessons › Assortment & Category Planning › Decisions

Assortment & Category Planning lesson

Exit plans for aged SKUs

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 clearStock ÷ Weekly units.
Units needed a weekStock ÷ Weeks left in the season.
Exit toolsMarkdowns, moving stock to stores that sell it, or bundles.

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.
=B2/C2
2. Tap a SKU that won't clear before the season ends.
The leather case (15 weeks) and the car mount (10 weeks).
3. 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 rate

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