This macro-enabled workbook is designed to help stores evaluate its vendors, locations, and classes.  Metrics such as sales, gross profit, cash flow and obsolete inventory can help stores decide to invest more or less in a certain vendor or class of product.

• • 

  Steps for retrieving online reports

  1. Locate one of Mango's monthly Action, Review or Excel emails.

  2. You will find the login link, username, and password in the body of the email.

  

  3. Click the link and enter your credentials to log in.

  

  4. On the left-hand navigation window, you'll see a Data Import + Multi-Store folder as well as a listing of all the stores in your organization.

  5. Click on the desired folder and the contents will display on the right-hand side.

  

  6. You may want to change the view to be Detail as it's easier to navigate.

  

  7. If you click on a specific store you'll need to select the Excel or PDF folder depending on what report you're after.

  

  8. The Excel folder houses store-specific workbooks like the Mango_IVA, Location, and Class Productivity, Delete Report, Vendor Analysis, etc.

  

  9. You can either go back on your web browser or on the left-hand side, click the PDF folder.

  

  10. The PDF folder contains that same reports that are emailed each month in the Action, Review, and Excel email.

  

  11. Click on the file you'd like to download, a new page will load and you can click on the "Page icon" or the download button in the upper right.

  

  12. If you'd like to download an entire folder of reports, say Data Import + Multi-Store, click on the root folder and then the download button.

  

  13. And if you want to download EVERYTHING, then click on the highest root folder and then the download button.

  

This worksheet lists metrics by vendor as set up (MVR) and assigned (IMU) in your Eagle system. If a SKU's Mfg vendor is blank, then its Prime Vendor will be used. 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 vendor in Column A to see significant SKU detail (insignificant SKUs are not be listed).

• Vendor: summary of activity for Mfg/Prime numbers assigned in your Eagle system.

  Vendor Name: the vendor name assigned in Eagle MVR.

  RSC Coverage: the percentage of active vendor SKUs carried by your primary vendor's retail support center (warehouse). You can use this column to zero in on drop-ship only vendors (usage example: set a Number Filter to 25% and less to show only those vendors with 25% or less RSC coverage).

  Top Dept: the most common department for this vendor based on the active SKUs in your store.

  Sales Rank: 1 = top-ranked or highest sales vendor, 2 = 2nd to top sales, etc.

  SKU Count: shows the number of active (QOH 0 or recent sales) vendor SKUs in your store.

  Sales +/- YOY: sales increase/decrease from last year (year-over-year).

  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 vendor 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.

  Cash Flow - last twelve months sales minus purchases.

  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)

  Estimated Order Cost: the estimated amount of your vendor order based on your report date quantity on hand, order point and order multiple. Store Closeout Y or Discontinued = Y excluded.

  MVR P.O. Minimum: the vendor's minimum order amount as set in MVR - P.O. Minimum.

  Order Cost Above Minimum: the amount which the Estimated Order Cost exceeds the MVR P.O. Minimum.

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.

This worksheet lists metrics by class as set up (Eagle MCL) and 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 class in column A to see significant SKU detail (insignificant SKUs are not be listed).

• Class: the class.

  Class Name: the class name assigned in MCL.

  Primary Dept: the most common department for this class based on active SKUs in your store.

  Sales Rank: 1 = top-ranked or highest sales class, 2 = second highest, etc.

  SKU Count: shows the number of active SKUs (QOH 0 or recent sale).

  Sales +/- YOY: sales increase/decrease from last year (year-over-year).

  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 changes 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.

  Sales Variance Ace SKUs: shows the sales difference between what your store sells and what the typical store (matched to your store's size) sells. For example $-400 means your store sells $400 less in this class than the typical peer store your exact size.

  Discovery COR Coverage: shows the percentage of Discovery COR SKUs that your store carries in this class.

  Missed Opp COR Sales: shows the likely annual sales of Discovery COR SKUs not carried in your store.

The SKU Detail tabs in this workbook help stores audit and understand inventory value change, sales, and shrink from period to period.  This is especially useful when trying to analyze why reported inventory value went up or down significantly during a period. There are two "value change" worksheet tabs: 

• TTM SKU Detail - this worksheet reports value changes, sales, or shrink compared to 12 months ago (TTM stands for Twelve Trailing Months). To keep worksheet size manageable, only absolute changes of $10 or more are reported. 
   
• Month SKU Detail - this worksheet reports value change, sales, or shrink from last month. To keep worksheet size manageable, only absolute changes of $10 or more are reported. 

Both Value Change tabs will exclude the Boundary Exceptions: Cost/QOH Errors, and Store Supply. However, some negative values may be included in certain circumstances.

• Annual/Monthly Sales: shows the last twelve months/monthly sales dollars.

  TTM/Monthly Gross Profit: shows the last twelve months/monthly gross profit dollars (average cost).

  Margin: shows the last twelve months/monthly vendor gross profit margin percentage (average cost).

  Cash Flow - last twelve months/month sales minus purchases.

  Current Inventory: current inventory dollar value as of the report date.

  QOH: current quantity on hand value (as of report date).

  TTM/Month QOH Change - the change in quantity on hand from the same month last year (month-end to month-end).

  TTM/Month Inventory Change - the dollar change in extended average cost (QOH * avg. cost) from last year.

  Shrink - shows the shrinkage gain/loss (change times average cost) over the last twelve months/month.

  Inflation - shows the impact of average cost change from year to year: current quantity-on-hand times (current avg cost minus last year's average cost).

  TTM/Month Sales Units - the number of units sold over the last twelve months/month.

  TTM/Month Purch Units - the number of units purchased over the last twelve months/month.

  Months of Supply - months of inventory on hand based on the SKU's quantity-on-hand and its average monthly sales units.

  RSC SKU - indicates if the SKU is carried in your Ace RSC.

  Status - (New, Deleted, Can/Rep) indicates if a SKU is newly added (within the last twelve months), was deleted with QOH, or is part of a canceled and replaced pairing.

  Promo Sales Signature - shows if "Promo" if the SKU is currently on a promotion or half or more of its annual sales have been on promo. Shows COM when on Closeout Management.

  Seasonal Signature - shows if the SKU is part of a seasonal class and will likely exhibit sales variability depending on the time of the year.

  Obsolete/Overstock - shows if the SKU is currently on the Obsolete or Overstock listing in your MEGA report.

  Replacement SKU - if the SKU is a canceled/replaced pair then this shows the canceled/replaced SKU.

The last tab in this workbook lists all SKUs in your store which are not assigned a Prime Vend, Mfg number, Location, or Class. Top-selling SKUs should have these assigned so that sales and inventory can be attributed appropriately.