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.
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.
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:
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:
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.
|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: