Your Excel Chain Assortment workbook is a chain-specific assortment report based on the sales history of your other store(s). It includes both Ace and non-Ace SKUs and excludes SKUs with average annual sales less than $20. The listed SKUs are not carried in your store but are carried and sold in at least one of your other store(s) in your chain. 

• Column E - Estimated Location: the most likely location for the SKU based on the most popular location in your store for the SKU's product group. 
  
  Column J - Discovery: shows if the SKU is part of Ace's Discovery set. 
  
  Column K - Bulk: indicates if the SKU is considered part of a "bulk" class such as wire, rope, tubing, etc. 
  
  Column L-O - Annual: shows the average annual units, sales, cost and gross profit.
  
  Column P - Percent Stores Selling: shows the percentage of your chain stores selling the SKU. 
  
  Column Q - In Stores: shows the stores in your chain that are selling the SKU.
  
  Column R - Transfer Group: shows your chain's transfer groups (in case some of your stores are spread out geographically) so you can filter this report by transfer group. Please contact us if you would like to establish or change your chain's transfer groups.