BBampaa

Lessons › Assortment & Category Planning › Put it together

Assortment & Category Planning lesson

Line review

Once a season, the buyer and the retailer review every SKU in the category. You bring the numbers and the recommendations.

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

The idea

Once a season, the buyer and the retailer review every SKU in the category. You bring the numbers and the recommendations:

Key points

Category viewSales by category first: where the money is.
SKU by SKUVelocity, margin, distribution, ABC class.
RecommendExpand, keep, reposition or remove, with a reason.

A good line review is a short list of decisions, each with one number behind it.

Practice

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

1. In I2, total the category's sales. Each answer stays in the report as you go.
=SUM(E2:E9)
2. In I3, total the Audio sales.
=SUMIF(B2:B9,"Audio",E2:E9)
3. In I4, work out Audio's share of sales, rounded to 2 decimal places.
=ROUND(I3/I2,2)
4. In I5, work out the category's margin %, as a decimal.
=SUM(F2:F9)/I2
5. In I6, work out the Fast charger's velocity: units ÷ stores ÷ 4 weeks.
=D4/C4/4

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