Mango Report
Help Center
Search:
Contents
:
IndexBookmarkPrint

Home > Excel Reports > Location and Class Productivity > Multi-Location

Multi-Location - Location and Class Productivity - Excel Workbook

This tab shows SKUs exhibiting increased sales volume when merchandised in multiple locations (cross-merchandised). The worksheet will list relevant SKUs along with the location in your store where they should be additionally displayed. A pdf version is generated every month in your Floor Exception report. 
 

The data for this report is generated from stores who adhere to a location code best practice when merchandising SKUs in multiple locations. If your store doesn't adhere to this policy then please consider using Location 2 to indicate the cross-merchandised location! 

For example - if you merchandise your Great Stuff in its regular location with caulk and additionally cross-merchandise it next to weather stripping, then put the weather stripping's shelf location in the Great Suff's Location 2 field. This will allow our analysis engine to understand that Great Stuff is related to weather stripping.

​

Report Column Definitions

Column E - Current Loc 2: shows the SKU's current Location 2 value.

Column F - Related Class: shows the related location's class name.

Column G - Related 2nd Location: shows the location in your store of the SKUs related class; this is where you should cross-merchandise the SKU.

Column H - Additional Sales Units: the estimated number of additional annual sales units when the SKU is also merchandised in the related location.

Column I - Additional Sales Dollars: the estimated annual sales increase when the SKU is also merchandised in the related location.