Retail Shelf Planner
Professional planograms for everybody
Examples of visual and financial analyses
The examples of visual and financial analyses below give an impression of the capabilities that Retail Shelf Planner offers to support the decision-making process in balancing the available assortment and the available retail space.

Analysis Sample 1

Top/Bottom Analysis

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.

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.

Analysis Sample 2

Inventory Analysis

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
  • Dark 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).

Analysis Sample 3

Quadrant Analysis

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 assortment 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
  • Rood: 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.

Analysis Sample 4

Hot/Cold Analysis

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.

Analysis Sample 5

Using an interactive dialog, the user can create a KPI scorecard for the whole category, or subsets thereof. The analyses can be saved for further use in Excel.

Alternatively, analyses can be copied to the Windows clipboard and pasted in other applications such as Word, Excel, or PowerPoint.

Retail Shelf Planner offers a direct link with Excel allowing you to make professional analyses and reports. By using the templates that come with the software, everybody can create powerful reports. No Excel knowledge is required. Additionally custom templates can be created, or data can be processed in an ad-hoc, manual way.

The Excel analyses/reports below are some samples of templates that can be used with and automatically be populated with data from Retail Shelf Planner:

Analysis Sample 6

Analysis Sample 7

Analysis Sample 8

Analysis Sample 9