This worksheet tab shows the SKUs that make up your store's Productivity Level 2 - Assortment Opportunity metric. Processing this report is straightforward but requires knowledge of your store's current assortment, market, and available shelf space. The worksheet is sorted by Estimated Location (column I) so you can see how many SKUs in a location are available. SKUs are selected because they are highly popular in peer stores (column N) or are carried by a lower percentage of peer stores but sell well for the stores who carry them (sell in a high percentage of stores carrying and sales, units or gross profit are better than the SKU's product group average).

Filtering Tips:

• 1. Filter on Add Type (Column G), click on the down arrow.
  2. Deselect all, then select Add - Popular.
  3. Sort Sales Opp (Column L), largest to smallest.
  4. Consider sorting out Store Closeout = Y.
• 1. Filter on Discovery (Column H), click on the down arrow.
  2. Deselect all, then select your Discovery type.
  3. Sort Sales Opp (Column L), largest to smallest.
  4. OR
  5. Sort Estimated Location (Column I), A to Z.
• 1. Filter on Estimated Location (Column I), click on the down arrow.
  2. Deselect all, then select your desired location.
• 1. Filter on Annual Units (Column K), click on the down arrow.
  2. Select Number Filters.
  3. For A items, select greater than or equal to, enter 76 and click OK.
  4. For B items, select between, enter 26 and 75, then click OK.
     
  5. For C items, select between, enter 9 and 25, then click OK.
     
  6. For D items, select less than or equal to, enter 8 and click OK.
  7. After filtering for a popularity code, sort Sales Opp (Column L), largest to smallest.
  8. Consider sorting out Store Closeout = Y.
• 1. Filter on Newly Reported (Column AB), click on the down arrow.
  2. Deselect all, then select Yes.
  3. Sort Sales Opp (Column L), largest to smallest.
  4. Consider sorting out Store Closeout = Y.

• G - Add Type: Shows the general category for why the Add is recommended.
  

  • Add - Popular: the SKU is carried by 80% or more peer stores (column N).
  • Add: good-selling SKUs carried by less than 80% of your peers.
  • Add - Associated: an associated SKU to one you already carry. Example: you carry the mop but not its refill.  
  • New RSC Item: good-selling SKUs added to your RSC within the past year. These SKUs have a lower Peer Store % threshold (column N).
  • Add - Top PG SKU: the SKU is the #1 ranked SKU in its Product Group based on median annual gross profit dollars. At least 25% of the stores in your peer group need to be selling the SKU and it must sell well at regular retail in all stores who carry the SKU on a regular (month-after-month) basis. 

  H - Discovery: indicates if the SKU is part of Ace's Discovery category. You can filter this column by CON (convenience), COR (core), or SUP (super) to see SKUs in your recommended merchandise sets.

  I - Estimated Location: The SKU's estimated physical location in your store. This column is based on the most common location code for the SKU's product group in your store.

  J - Estimated Cost: lists the approximate incremental inventory investment to carry the SKU. Takes estimated sales and order multiple into account.

  K - Annual Units: estimates the number of units your store will sell annually based on your store's relative sales volume within its Mango peer group.

  L - Sales Opp: lists the SKU's estimated annual sales dollars based on its annual units (J).

  M - Gross Profit Opp: same as L except lists Gross Profit (Sales - Cost).

  N - % Peer Stores: shows the percentage of stores in your peer group that are selling the SKU. 0.6 means 60% of the stores in your Mango peer group are selling the SKU. (can be formatted as a percentage for easier readability).

  O - Chain Carried %: the percentage of stores carrying the SKU (i.e. 3 of 4 stores carry this SKU, 75%.)

  P - Chain Reported %: the percentage of stores where the SKU is recommended to carry (i.e. add this SKU in 2 of 5 stores, 40%.)

  Q - Ship to Trans

  R - Ship to Sales U

  S - Store Closeout: a Yes or No value in this column means the SKU is in your inventory file but is inactive. Yes means the SKU has been explicitly closed out by your store and No if the SKU is inactive for some other reason. Some stores may choose to filter out Y values in this column; however, it's worth a look at these because sometimes a very good selling SKU is inadvertently closed out.

  T - GMROI: the return on the incremental gross profit opportunity (L) divided by the estimated inventory investment (I). You can format this column as a percentage to see traditional ROI% (return on investment). 

  U - OM: the SKU's Order Multiple.

  V - Sugg. Order Point: the SKU's suggested minimum order point when added to your system. Based on peer median order point and Ace's minimum order point listing.

  W - Current Location: the SKU's location if it is currently inactive in your inventory file.

  Y - In Season: shows Yes if the SKU will be considered in-season next month. For example, a Christmas SKU will show as "No" in July.

  Z - Notes: lists the associated SKU you currently carry.

  AB - Newly Reported: indicates Yes if this is the first time the SKU has been reported over a 2-year period.

  AC - Times Reported: shows the number of times over the last 2 years this SKU has been reported on the assortment tab.