Years using Mango

The number of consecutive years your store has been using the Mango system.  This helps gauge how far along a store is in their deployment of Mango. 

Operational Level (level columns are in grey) 
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! 

Completion (3 month average)
Level 0 - shows the percentage of SKUs listed on your store's Count Sheets which received an updated Last Physical Inventory date (SKU was counted).

IRA 3M Average (3 month average)
Level 1 - shows your store's sampled quantity on hand accuracy (or inventory record accuracy, IRA).  Based on the variance results of Mango's RC Count Sheet Count Type.  This metric helps a store gauge the accuracy of their quantity on hands.

Dollar Accuracy (3 month average)
Level 2 - shows the net dollar variance from all Count Sheet Count Types over the past 3 months as a percentage of total dollars counted.  This metric helps a store gauge the accuracy of their Eagle ending inventory (RIV report or Business Advisor). 

Shrink (twelve trailing month average)
Level 3 is Mango's adjusted shrinkage metric that excludes bulk, errors, fasteners, closeout, store supply, lumber and live goods (see shrinkage classification).  With these excluded, your adjusted metric will measure uncontrolled loss which is likely being repurchased.  The metric shows trailing twelve month (TTM) loss at replacement cost divided by sales for the same period.

Efficiency % (twelve month average)
Level 4 - shows how much time is spent counting and/or changing quantity on hands in your store.  Stores who spend too much time devoted to this exercise tend to misplace their accuracy labor.  High counting labor is analogous to high bailing labor (in a boat for example).  That is, we're better off fixing leaks rather than continuously bailing. Many stores engage in full store counting and achieve zero business benefit.  Stores experiencing difficulty with IRA (level 1) generally have misplaced accuracy priorities where high counting frequency (low Efficiency) is preferred over root accuracy processes (Accuracy Cadence, Accuracy Skills).

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. 

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.

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 %
This metrics helps your store gauge its shooting outs procedure, showing the percentage of countable candidate SKUs that were 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 will receive a Last Physical Inventory date update. A listing of countable SKUs not counted in your online Excel-based In Stock report Shooting Outs tab. 
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. 

Negative QOH
This is mainly a diagnostic metric used by Mango staff during training to verify a store's reported IRA.  The lower this metric, the higher a store's IRA.  It is also used internally for count validation.  1% or less indicates an IRA of 90% or better, 2% indicates 80% - 90%, 3% indicates 70% - 80%.  IRA and Negative QOH should match up in this way.  If not then it may indicate a condition in the store where there is an issue with initial count quality and/or variance research.

Defectives %
This metric shows the percentage of policy A SKUs rung (or PIP'ed) as defective divided by your store's policy A purchases.  This metric is helpful to gauge your store's defective experience and processes compared to peer stores.  

​

SKUs (TTM) Changed
This metric is related to your Efficiency metric (Level 4) and shows the percentage of SKUs which received a manual quantity on hand adjustment (variance through PIP or Inventory Maintenance) over the trailing twelve months (TTM).  In a typical scenario, a store will need to adjust 10% of their SKUs' quantity on hand values due to cashier error, theft and receiving/shipping errors.  Metrics above 10% indicate an accuracy leak caused by sloppy counting, shelf/back stock maintenance or cashiering.  Focusing in on Accuracy Skills rather than counting can help move this metric down and accuracy up!

SKUs (TTM) Counted
This metric is related to your Efficiency metric (Level 4) and shows the percentage of SKUs which received a Last Physical Inventory update within the trailing twelve months (TTM).  This helps gauge if a store has a regimented counting process in place (high percentages).  There is not a statistical correlation between accuracy and the number of SKUs counted. 

Monthly Changes
This metric shows the percentage of SKUs in your store which receive a quantity on hand variance in a typical month (median).  High numbers indicate a store engaged in regular high-frequency quantity on hand changing.  

Swell Percentage
This metric shows the ratio of shrinkage variances (quantity on hand adjusted downward as in the case of theft) to swell variances (quantity on hand adjusted upward as in the case when thieves put the stuff back).  The typical ratio is 37%, which means over 1/3 of our variances are from generous customers giving us free stuff or we are correcting for cashiering and counting errors. Corrections within the month are excluded from this metric, for example if a SKU was shrunk but then later found and its QOH adjusted back, as long as this correction did not cross the month end, would not affect this metric.  A store showing a high swell metric indicates a receiving issue (SKUs quantities are being adjusted through PIP/IMU instead of through an order).  Low metrics can be a sign of inadequate variance research/control, professional theft, or (sometimes) a perfect store.  Careful variance research will answer this question!

Median Last Physical Yrs.
This shows how long it has been (in years) since the typical SKU has received a Last Physical Inventory date (how long has it been since the typical SKU in my store has been counted).  This helps gauge the counting frequency of a store.  Caution: there is no correlation between this metric and accuracy, in fact, there is light inverse correlation.  That is, the more a store counts, the less accurate it is (in general).

Recovery Potential

This metric for SKUs showing on hand values but have stopped selling in your store, however, they continue to sell in other stores.  This is the MC Count Sheet Count Type.  It is a gauge of potential sales opportunity if these SKUs were all selling like they should.  High numbers here indicate a more cluttered inventory file (clutter impacting sales) which is great because your staff through Mango is gong to find all these SKUs and get them back selling! Lower numbers indicate a more cleaned-up inventory file.

Recoveries Found
The number of SKUs from the Recovery Potential pool (above) which have been zero and reordered through your monthly Count Sheet processing.

Sales (TTM) Recovered
The annual (trailing twelve months, TTM) sales attributed to SKUs in the recovery potential pool (above) which have been zeroed and reordered.

​