The purpose of this article is to help you understand and read the range optimizer results grid found in the DotActiv software.
Please note that Range Optimizer is used to optimise a range based on certain variables or rules. Range Optimizer applies rules to a range and the DotActiv software can apply logic to suggest a range. This function is also used when creating a new range.
On the other hand, Range Maintenance holds the current range and allows you to run basic ranges that have no rules. This allows the user to choose between the range created in Range Optimizer or to run the data from where the database is maintained.
Reading The Range Optimizer Results Grid
After opening the DotActiv software, navigate to the ‘Ranging’ tab and select the ‘Optimizer’ icon in the ‘Ranging’ section.
After opening your range, ensure that you are in the ‘Tools’ tab.
Range Optimizer ‘View’ Section
Totals In Header
Below the column headings, there is a row containing the grand totals. You can choose to show this row (i.e turn this row on) by right-clicking and selecting ‘Visible’ from the context menu. Click on ‘Visible’ to deselect this row and to turn it off.
You can also turn it on and off by ticking the checkbox next to ‘Totals In Header’ under the ‘View’ section.
Show Full Screen
You can view it in full screen by pressing on the ‘Show Full Screen’ button in the ‘View’ section.
With Range Optimizer, you can make range decisions on both the summary grid by ticking and unticking the POG indicator or on the planogram view. You also have reporting options that appear in the toolbar at the top of your screen, such as the hierarchy view, impact analysis and transfer of demand report.
Click on ‘Planogram View’ if you wish to see a planogram or planoguide view of the range. You can click on the ‘Show Images’ button if you wish to work with the images.
In this view, you are able to change your range by working on the planogram. You can drag rows from the range and drop them on any shelf to add to the planogram or drag items to the red shelf that you wish to remove from the range.
This view is updatable with the summary grid by clicking the ‘Apply Grid Range’ button. You can also view the planogram as a planoguide if necessary.
If you would like to see where products have been delisted and where there is now space available on the planogram you can right-click on a product and click delist and turn your images off to see the products reflect in red.
If you change the facings by clicking on a product and then selecting a number on your keyboard, these products will reflect in orange.
If you add products to the planogram, these products will appear in green.
The hierarchy view shows the impact of the range changes you have made within the context of the whole product category.
- Levels of the hierarchy that are over ranged appear in red.
- Levels of the hierarchy that fit within the range cap appear in green.
- Levels of the hierarchy that are under ranged appear in yellow.
This is a grid showing the impact of the proposed range changes drilled down to the brand level which is linked to the KPIs you selected in your range settings.
Transfer Of Demand Report
This report provides details of what will happen to the sales of the products being delisted. A portion of the sales that were attributed to the delisted products will be transferred over to the products that remain in the range. The delisted products are detailed in terms of their performance and levels of the hierarchy and brand profile.
This information is used to find the top-performing or best substitute to which the sales will be transferred. A substitute will be provided for each delisted product.
You can click on the product description to see the top ten options based on the brand and product description and select a replacement if you would like an alternative.
Please note that for each delisted product, up to 5 options are provided which consist of ranged products from the same hierarchy group (Sub Category, maybe Segment and Subsegment) and from the same brand ranked by sales and then another 5 products based on the product description.
Transfer of demand is typically worked out based on the brand profile. If products fit the same brand profile then an estimated 100% of the sales will be transferred.
If the products fit slightly different brand profiles (e.g. economy to mid-tier or mid-tier to premium) an estimated 75% of the sales will be transferred to the product(s) remaining in the range.
If the product fits completely different brand profiles (e.g. economy to premium) then an estimated 50% of the sales will be transferred.
Rules are pre set up calculations that give products a points-scoring based on the rules that are linked to them. Your products are then ranked based on specific attributes to address the needs of your customers.
Basic rules include Sales and Units, Time on Shelf, Good Better Best, SKU Size Limiter and many others. If you have a specific rule that influences the weighting of your SKU’s then custom rules can be created for you based on specific scenarios.
You can view the rule information that you’ve applied to your range by clicking on ‘Rules’ in the ‘View’ section.
In the ‘View’ section, you can find ‘Clones’. This function allows you to view the relevant clone information for new products.
Product clones can be used when you have new products in your database with no sales data. To ensure that the Range Optimizer doesn’t recommend delisting the products based on ‘poor performance’, cloning can be used to assign the sales data of a similar or substitute product to the new listing for a period of time.
The product clone feature works on the same logic as the transfer of demand report. This means that it will find the closest, top-performing substitute for the new product and recommend this as the clone.
If the new listing and the clone have the same brand profile, a recommended 100% of the sales will be cloned. If they have slightly different brand profiles (e.g. Economy and Mid-tier), an estimated 75% of the sales will be cloned. If they have completely different brand profiles (e.g. Economy and Premium), 50% of the sales will be cloned.
Please note that if it is greyed out, it means there are no clones.
Columns Displayed On The Grid
- Total Points: Points allocated to each product based on the inputs given. The colours used are also as per the set-up in the highlights section.
- Range Suggestion: The range recommended by the DotActiv software is indicated by a tick, based on the category caps and contribution. The tick boxes can be used to add products to the range.
- Congestion: Indicates the percentage congestion of the suggested range upon the planogram. It is based on the available space.
- Percentage SKU’s Ranged: Contribution of each group in the total range count.
- On Current Plano: Confirms whether the item is currently on planogram or not.
- POG Indicator: Indicates whether an item is currently selected to be part of the range. POG refers to the planogram.
- Supply Indicator: Indicates if there is stock available for supply to the store. The value in brackets indicates the number of stores within the cluster.
- DISC Indicator: If the checkbox is ticked, it indicates that the product has been discontinued.
- Range Cap: Indicates each sub-total row’s respective range cap. For example, if your S.T. is set to Sub Category, it will indicate each sub categories’ cap.
If so desired, you can freeze specific columns into place. Right-click on the column you want frozen and select ‘Freeze’ from the context menu. As you scroll, your chosen column will remain on the screen, as shown below.
Range Optimizer Highlight ‘Legend’
You can turn the ‘Highlights Legend’ on and off. To do this, navigate to the ‘View’ section, and select ‘Legend’. As seen below, a dockable window appears with the various highlights.
Please note that only one highlight can be selected at a time.
- Recommended: These are the products that the DotActiv software recommends that you include.
- Recommended vs Selected: This compares the products recommended by the DotActiv software versus those selected by you, the user.
- Supply vs Selected: This takes the user-selected range into consideration. It indicates the difference between the suggested range and the supply indicator. It also provides a warning, showing that there is still stock on hand but the item is not on the planogram.
- Changes: This indicates the changes made on the grid.
- Changes From Live: Changes that are currently different from what is saved in the database.
- Warnings: This works with the POG and supply indicators, using a 5-week rule check. This is only applied when using the range to POG function. When the POG function is turned off, the DotActiv software will apply the logic.
Please note that you can integrate your ERP system with the DotActiv software if you would like to manage your safety stock to avoid ‘Out Of Stocks’. Learn more about How DotActiv Approaches Integration here.
This function indicates when you exceed cluster or category caps. You can click on ‘Caps’ under the ‘View’ section if you need to see the values you’ve chosen. If too many items are selected, the entire supply column will turn red.
Each sub-total row’s respective range cap is also indicated in the ‘Range Cap’ column. Once ‘Warnings’ are turned on, it will be highlighted in red if the subtotal group has been over-ranged or in yellow if the subtotal group has been under-ranged.
Also found within the ‘Tools’ tab, the ‘Brand Profiles’ function allows you to view the brand profile composition of your ranges.
Within the ‘Brand Profile Composition’ window, you can select a row within the grid to update the pie chart on the right-hand side of the window, as seen below. More specifically, if you would like to view the pie chart of another range you can simply click on that range in the grid and the chart will be updated.
You can export the pie chart by simply right-clicking on the chart and clicking on ‘Export’ and it will export to a PNG file.
Range Optimizer ‘Copy’ Section
Range To POG and Range To Supply
Once you have finished working on the recommended range, you can click on ‘Range To POG’ under the ‘Copy’ section.
It’s recommended that once completed, you should view the Warnings highlight.
If so desired, you can also use the ‘Range to Supply’ indicator. Click ‘Range To Supply’.
Range Optimizer ‘File’ Section
Refresh From DB
If you are unsure about what changes you made, you can click on ‘Refresh From DB’ under the ‘File’ section. This clears all the changes and refers back to the original data in your database.
Then click ‘OK’.
To save your range, you will find ‘Save Range’ in the ‘View’ section. Click ‘OK’ to save the changes.
Once you are happy with your changes, you can save them to your database.
Click ‘Update DB’ in the ‘File’ section. This function will save your DISC, POG, and Supply Indicators. When updating your database, it will also backup your database.
Grid To Excel
To export your grids, click on ‘Grid To Excel’ which is found in the ‘File’ section of the Tools tab. Once you have selected an output directory, give your file a name and click on ‘Save’. You will receive a pop-up window notifying you that it has been completed.
This will export all grids to a single XLS file i.e. the transfer of demand, impact analysis, and the main results grid per cluster. However, if you have the summary grid open, it will export all the ranges together on one tab within the XLS file.
Click on the ‘Update Plano’ button in the ‘File’ section.
The ‘Range Optimizer – Update Planograms’ window will appear as seen below.
Here, you can see the planogram or the directory of planograms you wish to update. You can also select the fields to update. Tick the checkboxes that you want to apply an update to.
You can also:
- Update your existing products,
- Add new ‘POG’ products to a dummy shelf, and
- Remove facings from the product report.
With products not on the POG, you can decide what you want to do:
- Do Nothing,
- Move to Floating Shelf,
- Remove From Shelf, and
- Remove From Product Report.
You can also tick or untick the box next to ‘Keep Cross-Merched SKU’s’.
Click ‘OK’ and ‘OK’ again after viewing the ‘Select Planograms To Update’ window.
Once you have updated your planogram, and selected to move the products that are not on the planogram to a floating shelf, the delisted products will appear on different red floating shelves as it is split by the subtitle field in the grid (i.e. subcategory). Furthermore, the products will be sorted by brand and then height on the shelf itself.
On the other hand, any new products that were added will appear on a green shelf which will also be sorted by brand and then by height, as seen in the example below.
Should the above steps not work, please create a support ticket and the DotActiv support team will assist you in uncovering the issue.