Store metric - Shelf alignment index

Definition of shelf alignment index

Shelf alignement index is a simple metric which stores can use to check if the merchandise displayed on their shelves is in alignment with shopper behavior at the store. For example lets say

Input data required to calculate shelf alignment index

1. POS transactions ( SKU, Store, date, um, qty, value )
2. Shelf space audit ( Category, date, shelf area in sq ft, relative share of shelf )

How does one calculate shelf alignment index

1. Rank all categories ( soaps , shampoos , vegetable, ice creams ) based on the relative number of units sold per month.

2. Rank all categories on share of shelf

3. Calculate difference in rank = Rank(Sales)-Rank(Share of shelf)

4.
Example of shelf alignment index


Application of shelf alignment index to optimize store operations