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

Top/Bottom Analysis

In the example on the right the top performing categories that generate 20% of sales are displayed in green. The worst performing categories, in this example good for 10% of sales, are displayed in red. In this analysis the user can select the variable (e.g. sales, profit, movement) as well as the percentages. Optionally one can focus on the top or bottom performing categories only. Using this analysis you can check if the most valuable store space has indeed been allocated to the most "important" categories.

Under & Over Target Analysis

In this analysis the actual performance is compared with a target. This target could be the budget, the performance of a previous period, one or more reference stores, etc. The user defines the acceptable margins, after which Retail floor Planner colors the categories: Bright Red: significantly under target Light Red: lightly under target White: on target Light Green: lightly over target Bright Green: significantly over target Using this analysis you can visualize if there are specific parts of the store that perform better or worse than expected on a range of variables like sales, profit, etc.

Quadrant Analysis

In this example the variables Margin and Movement are crossed and the performance of each category is compared with the average of the whole store. 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, categories with a high volume, but with a relatively low margin Blue: Profit Generators, categories with a relatively low volume, but with a high margin Red: Dogs, the problem-categories with both low volume and low margin The user can optionally select other variables and decide whether the comparison has to be made with the store-average, or with a constant. The insights from this analysis can be used to review the role of categories, drive margin negotiations, decide where to focus on volume promotions, and instruct floor staff on where to pay extra attention.

Hot/Cold Analysis

This analysis splits the categories 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 a range of variables, including Sales/Mtr, Profit/Sq.Ft, Margin and Movement. Effectively a refined version of the Top/Bottom analysis, the user is provided with insights about all categories in the store.

Analysis Sample

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.

Excel reports and analyses

Retail floor 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.