BBampaa

Lessons › Assortment & Category Planning › Know your SKUs

Assortment & Category Planning lesson

Margin per store

Shelf space is limited. Margin per store per week shows what each SKU earns for the space it takes.

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

The idea

Shelf space is limited. Margin per store per week shows what each SKU earns for the space it takes:

Formulas

Margin ÷ Stores ÷ 4

Key points

Margin per storeThe margin a SKU earns in each store that carries it, each week. Also called SKU productivity.
Work it outDivide margin dollars by the stores carrying it, then by the number of weeks.
Space is limitedEvery slot on the shelf should earn its keep. The lowest earners are the first to review.

Margin per store tells you which SKUs deserve more space, and which should make room.

Practice

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

1. What does the Fast charger earn per store per week?
$12,960 ÷ 36 stores ÷ 4 weeks = $90
2. In D9, work out the car mount's margin per store per week: margin ÷ stores ÷ 4.
=C9/B9/4
3. Tap the SKU with the lowest margin per store per week.
The car mount: $5.40 per store per week.
4. Your report compares margin per store across the 8 SKUs. Which visual?
Bar chart

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