Retail Shelf Planner highlighting examples

In the example on the left the top performing products that generate 20% of sales are displayed in green. The worst performing products, in this example also good for 20% of sales, are displayed in red. In this analysis the user can select the variable (sales, profit, movement) as well as the percentages.

• Red: Worst performing products
• Green: Best performing products
• White: Ignored as they do not fit into top 20% or bottom 20%

Optionally one can focus on the top or bottom performing products only.

Using this analysis you can check if the most valuable shelf space (= that at eye-level) has indeed been allocated to the most “important” products.

In this analysis the actual shelf stock is compared with the stock that is required to meet the targets that have been set. Various supply chain variables (supply, restocking, case size) and consumer demand are taken into consideration. The user defines the acceptable margins, after which Retail Shelf Planner colors the products:

• Dark Red: seriously understocked
• Bright Red: lightly understocked
• White: sufficiently stocked
• Bright Green: lightly overstocked
• Darker Green: seriously overstocked

Using this analysis you can reduce Out-of-Stocks (= increased revenues) as well as reduce overstocks (= reduction of costs, less waste due to out-of-date and freeing up space for new products).

In this example the variables Margin and Movement are crossed and the performance of each product is compared with the average of the whole category. The resulting 4 quadrants tell you the following:

• Green: Stars, the best of the assortiment generating high volume with a high margin
• Aqua: Traffic Builders, products with a high volume, with a relatively low margin
• Blue: Profit Generators, products with a relatively low volume, but with a high margin
• Red: Dogs, the problem-products with both low volume and low margin

The user can select from a series of variables and decide whether the comparison has to be made with the category-average, or with a constant.

The insights from this analysis can be used to select items to be delisted, drive margin negotiations and decide where to focus on volume promotions.

This analysis splits the products in 7 equal groups using a user defined variable. The “hottest”, i.e. best performing, products are displayed in fire engine red. The worst-performing products are “ice-cold” dark blue.The user can select to do this analysis on Sales, Profit or Movement.

Effectively a refined version of the Top/Bottom analysis, the user is provided with insights about all products in the category.