BBampaa

Lessons › Assortment & Category Planning › Know your SKUs

Assortment & Category Planning lesson

SKU productivity

Sales show what sells. 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

Sales show what sells. Margin per store per week shows what each SKU earns for the space it takes:

Formulas

Margin ÷ Sales

Key points

Margin %Margin $ ÷ Sales.
ProductivityMargin $ ÷ Stores ÷ Weeks.
Space is limitedEvery slot on the shelf should earn its keep.

A product can sell well and still earn little. Look at both.

Practice

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

1. In D7, work out the Screen guard's margin %: margin ÷ sales, as a decimal.
=C7/B7
2. Tap the SKU that earns least per store.
The car mount: $5.40 per store per week.
3. 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