Home > Excel Reports > Vendor Analysis
Vendor Analysis - Workbook
The macro-enabled Excel Vendor Analysis workbook is designed to help stores evaluate its vendors. Metrics such as sales, GMROI and obsolete inventory can help stores decide to invest more or less in a certain vendor.
Online Report Access Help
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.
A - Vendor: the Mfg vendor number. B - Vendor Name: the vendor name assigned in MVR. C - 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). D - Top Dept: the most common department for this vendor based on the active SKUs in your store. E - Sales Rank: 1 = top-ranked or highest sales vendor. Shows the sales rank order for the vendor.
F - SKU Count: shows the number of active vendor SKUs in your store. G - Annual Sales: shows the last twelve months sales dollars. H - Gross Profit: shows the last twelve months gross profit dollars. I - Margin: shows the vendor gross profit margin percentage. J - GMROI: shows gross profit return on inventory (gross profit / average inventory). K - Current Inventory: current inventory dollar value as of the report date. L - Average Inventory: average last twelve months inventory value.
M - Cash Flow - last twelve months sales minus purchases.
N - Shrink - net shrink over the last twelve months
O - Inventory Change - inventory value changes compared to 12 months ago P - Obsolete Inventory: dollar amount of inventory which has not sold in over two years (MEGA Report >> Obsolete Tab) Q - Estimated Order Cost: the estimated amount of your vendor order based on your report date quantity on hand, order point and order multiple. R - MVR P.O. Minimum: the vendor's minimum order amount as set in MVR -> P.O. Minimum. S - Order Cost Above Minimum: the amount which the Estimated Order Cost (Column N) exceed the Vendor Minimum (Column O).