Key Metrics
 
Column Definitions

YTD Sales
Year to date sales increase (decrease).  If your store has been using Mango for less than a full calendar year then this metric is estimated.

YTD Margin
Year to date margin.  This metric shows your front door margin based on SKU-level sales.  (estimated for stores using Mango for less than a year)

YTD GP$
Year to date gross profit (GP) increase (decrease).  This is the same measurement as YTD Sales but measures the difference between the SKU's sold at price and its average cost in your system.  This is not the same as your financial statement Gross Profit as it does not take shrinkage, trade discounts or other inventory adjustments into account.  However, it represents a good year-over-year change in the store's gross profit and should match your Eagle system closely.  (estimated for stores using Mango for less than a full calendar year)

MTD Sales
Month to date sales increase (decrease) from the same month last year.  Estimated for stores using Mango for less than a full year.

Inv. Change LY (Avg)
Inventory dollar value change from last year (12 months ago) in using average inventory value.

Shrink
Your Operational Level 3 - Shrink metric called out separately because it is such a powerful business metric.  This is Mango's Adjusted shrinkage metric that excludes bulk, errors, fasteners, closeout, store supply, lumber and live goods (Excluded Shrink).  The metric shows trailing twelve months (TTM) loss at replacement cost divided by sales for the same period.
 
Operational Level
Shows your store's current inventory Operational Level:

Level 0 - Completion: target 95% or better, measures Count Sheet processing.
Level 1 - IRA: target 80% or better, measures quantity-on-hand accuracy through sampling.
Level 2 - Dollar Accuracy: target 95% or better, measures inventory value net dollar accuracy.
Level 3 - Shrink: target -0.2% or better, measures theft and breakage.
Level 4 - Efficiency: target 95% or better, measures how efficiently a store can sustain its accuracy.
Level 5 - Achieved all inventory Operational Levels! 

Productivity Level
Shows your store's current inventory Productivity Level:

Level 0 - Unproductive: target 7% or less, measures the amount of obsolete and overstock inventory in your store (as a percentage of overall inventory value).
Level 1 - In Stock: target 1% or less, measures sales opportunity by adding more inventory depth (Ace SKUs only).
Level 2 - Assortment: target 3% or less, measures sales opportunity by adding more inventory selection based on peer store sales (Ace SKUs only).
Level 3 - Achieved all inventory Productivity Levels!

Unproductive Inventory (Productivity Level 0 - Unproductive help)
This carefully filtered and highly actionable metric shows the dollar value (quantity on hand multiplied by average cost) of inventory that has not sold in over two years and with over two years of supply, divided by total inventory value.  SKU-level detail can be found in your MEGA Report (Obsolete and Overstock) tab.  Stores good at managing unproductive inventory will see values below 7%.  

In Stock Opportunity (Productivity Level 1 - In Stock help)
In Stock Opportunity measures annual sales increase potential if your store never ran out of what it sells.  For example, if your metric is 1.1% then your store would see an increase of 1.1% in annual sales if it never sold out of inventory.  This metric is highly actionable through the Retail Analytics Dashboard.  These reports list the SKU-level detail that makes up this metric.  Increasing inventory levels for these SKUs will likely increase sales with very little inventory investment.  As you look over your SKU listing, you will see that the metric excludes outs caused by RSC (retail support center) service level, special orders, in/out promotional items and other kinds of noise.  This is the easiest metric to move because your store already carries the SKU, you just need a little more.

Assortment Opportunity (Productivity Level 2 - Assortment help)
Assortment Opportunity measures your store's incremental annual sales opportunity if it carried everything (Ace SKUs only) that sold well in other peer stores, but are not carried in your store.  Armed with this data, you can gauge additional sales potential by increasing your SKU offering.  SKU-level detail is found in the Retail Analytics Dashboard.  For example, if your store is showing a 3.2% Assortment Opportunity then your could see an annual sales increase of 3.2% if it added more SKUs. This metric does not take similar SKUs into account (we're working on that) so it is unlikely your store would experience the same sales increase, but it is a useful measure to gauge how much opportunity your store has compared to benchmarks and peers.  

Relative Volume
This metric shows how busy your store is compared to the median (typical) store in your peer group.  By comparing sales unit volume in the most commonly sold SKUs we can measure how much more or less of a typical SKU your store will sell compared to the median store (median store is 1.0).  For example, if your metric is 1.2 then your store sells 20% more units of commonly sold SKUs; if it shows 0.8 then your store sells 20% less.  This metric can help you gauge how busy a store is equally compared to other stores.

Relative Inventory
This metric shows how much more (above 1.0) or less (below 1.0) inventory value your store carries.  For example, a store showing 1.2 carries 20% more inventory value than the typical store.  0.8 means 80% less than the typical store.  This metric can be used in conjunction with other metrics (In Stock Opportunity, QOH Greater than 1, OP vs. Reference$)  to determine if a store is under or over-inventoried.

Shooting Outs

Your Shooting Outs metric gauges how thoroughly and frequently your store is shooting outs. Your metric shows the percentage of countable outs that were physically counted during the month. A SKU must be at zero on hand for 7 (or more) consecutive days to be included as "countable".  Assuming a store is shooting outs weekly then (in a perfect world) 100% of countable SKUs would receive a Last Physical Inventory date update. A listing of countable SKUs not counted is available in online In your MEGA Report Shooting Outs tab. Your best practice is to shoot outs thoroughly each week. Targets:  0% - 14% - No regular shooting outs procedure. 15% - 24% - Monthly or bi monthly shooting outs. 25% - 34% - Almost weekly shooting outs. 35% - 100% - Weekly and thorough shooting outs.

COM Fusion

COM (Closeout Management) Fusion measures the percentage of closeout-eligible obsolete SKUs listed in the Retail Analytics Dashboard initiated into your closeout management MIP Macro. If that didn't make any sense then consider employing Mango's Closeout Management system in your store! A high percentage measure means your store is actively using its COM tab to initiate obsolete inventory into Mango's Closeout Management system. Your COM Fusion metric helps you understand if your store is working on its Productivity Level 0 - Unproductive measure. Steps to improve COM Fusion 1. Engage fully in Closeout Management. COM Fusion is the lead measure for Productivity Level 0 - Unproductive.

OP Fusion

OP Fusion measures how thoroughly your store is processing its In-Stock class of reports. It is a composite metric made from your store's In-Stock, Ace Min OP, and Max OP lists.   Steps to improve OP Fusion 1. Monthly -> Increase Minimum Order Points using the Acenet Analytics Dashboard, or with your MEGA report. Click here for help. 2. Annually->  Increase Ace Minimum Order Points with your MEGA report (Ace produces a new list each January). Click here for help. 3. Annually ->  Process you Min/Max located in your MEGA report. Click here for help. ​ In OP Fusion is the lead measure for Productivity Level 1 - In Stock Opportunity.  That is, to impact your Productivity Level 1 metric, which takes several months to respond (a lag measure), you can process and monitor your Mango-recommended minimum and maximum order points: achieving a better OP Fusion will lead to a better Productivity Level 1 - In Stock Opportunity measure.