Mango Count Metric Description

  • Years using Mango: # of years using Mango
  • Operational Level:
  • 1. Count Sheet Completed 95% or more
  • 2. IRA 80% or more
  • 3. Dollar Accuracy 95% or more
  • Count Sheet Completion: The % of SKUs counted from your Mango Report over a 3 month average (<95%)
  • IRA 3M Average: Based on the variance results ofMango's RC Counts over a 3 month average.(<80%)
  • Dollar Accuracy: The net dollar variance from all Mango Counts over the past 3 months as a percentage of total dollars counted.(<95%)
  • Shrink: Adjusted shrinkage metricthat excludes bulk, errors, fasteners, closeout, store supply, lumber andlive goods over the past 12 months. This metricshows trailing twelve month (TTM) loss at replacement cost divided by sales for the same period. (<-0.2%)
  • Efficiency %: Shows how much time is spent counting and/or changing quantity on hands in your store over the past 12 months.(<95%)
  • SKUs (TTM) Changed: This metric is related to your Efficiency % and shows the percentage of SKUs which received a manual quantity on hand over the past 12 months. Metrics above 10% indicate an accuracy leak caused by sloppy counting, poor shelf conditioning, poor shelf/back stock maintenanceor cashiering.
  • SKUs (TTM)Counted: This metric is related to your Efficiency % and shows the percentage of SKUs which received a Last Physical Inventory update within the past 12 months. This helps gauge if a store has a regular counting process in place (high percentages).
  • Monthly Changes: This metric shows the percentage of SKUs in your store which receive a quantity on hand variance in a typical month. High numbers indicate a store engagedin regular high-frequencyquantity on hand changing.
  • Swell Percentage: This metric shows the ratio of shrinkage variances (quantity on hand adjusted down) to swell variances (quantity on hand adjusted up). 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.
  • Negative QOH: This is mainly a diagnostic metric used by Mango staff during training toverify a store'sreported IRA.
  • Median Last Physical Yrs.
    This shows how long it has been (in years) since the typical SKU has received a Last Physical Inventory date. This helps gauge the counting frequency of a store.
  • Recovery Potential: This metric for SKUsshowing on hand values but have stopped selling in your store, however, they continue to sell in other stores. High numbers here indicate a more cluttered inventory file. 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 Recovery Potential pool (above) which have been zero and reordered through your monthly Count Sheet processing.
  • Sales (TTM) Recovered: The annual sales attributed to SKUs in the recovery potential pool (above) which have been zeroed and reordered over the past 12 months.
  • Shooting Outs %: This metricshelps your store gauge itsshooting outsprocedures. A SKU must be at zero on hand for 7 (or more) consecutive days to be included as "countable".Your targets are as follows:
  • 0% - 14% - No regular shooting outs procedure
  • 15% - 24% - Monthly or bi monthly shooting outs
  • 25% - 34% - Almost weekly shooting outs
  • 35% - 100% - Weekly andthorough shooting outs
  • Defectives %: This metric shows the percentage of policyA SKUsrung (or PIP'd)as defective divided by your store's policy A purchases.