Home > Excel Reports > Product Analysis > Location
Product Analysis - Location Rollup
This worksheet lists metrics by location code as assigned in your Eagle system. Metrics are rolled up twelve trailing months (TTM) values and the list is initially sorted by Annual Sales dollars. You can double-click the red underlined location in column A to see significant SKU detail (insignificant SKUs are not be listed).
Location: the location code
Primary Class Name: the most common class for this location based on active SKUs in your store. Primary Dept: the most common fineline for this location based on active SKUs in your store. Sales Rank: 1 = top-ranked or highest sales, 2 = second highest, etc.
SKU Count: shows the number of active SKUs (QOH > 0 or recent sale).
Annual Sales: shows the last twelve months sales dollars. Gross Profit: shows the last twelve months gross profit dollars (average cost). Margin: shows the last twelve months gross profit margin percentage (average cost).
GMROI: shows gross profit return on inventory (gross profit / average inventory).
Current Inventory: current inventory dollar value as of the report date.
Average Inventory: average last twelve months inventory value.
Shrink - net shrink over the last twelve months (replacement cost).
Inventory Change - inventory value dollar change compared to 12 months ago. Obsolete Inventory: dollar amount of inventory which has not sold in over two years (MEGA Report >> Obsolete Tab) A/B/C/D/X: the number of SKUs in each popularity code ranking for the location.