Lessons › Assortment & Category Planning › Stores and ranges
Assortment & Category Planning lesson
Store grading
Retailers grade stores by size, often by weekly sales. Here: A at $10,000 or more, B from $5,000, C below that.
Try this lesson free →The idea
Retailers grade stores by size, often by weekly sales. Here: A at $10,000 or more, B from $5,000, C below that:
Key points
Store gradeA, B or C by weekly sales, or by space and footfall.
Store groupsStores that should carry the same range.
Why gradeBig stores can carry the full range. Small ones need the best sellers.
Grades decide how many SKUs each store gets.
Practice
1. In C2, grade Toronto: "A" if weekly sales are 10,000 or more, "B" if 5,000 or more, otherwise "C".
=IFS(B2>=10000,"A",B2>=5000,"B",TRUE,"C")2. Tap the C store.
Regina, at $3,500 a week.3. Make a pivot table of total weekly sales by store grade.
Rows: Grade, Values: Sum of Weekly salesLearn 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 →