• 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. Once logged in you'll see a Data Import folder as well as a listing of all the stores in your organization.

  5. Click on the desired folder and its contents will display.

  

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

  

  7. The PDF folder lists reports that are also emailed to you each month. The Excel folder lists additional analysis reports made monthly.

  8. If you need to navigate back to a different directory, click on the folder icon at the top.

  

  9. To download one or multiple files, select the checkbox next to the file and click the download button in the header.

  

  10. If you want to download entire folders or the root directory, an SFTP program like WinSCP or FileZilla is required. More detailed instructions can be found in the toggle panel below.

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.