If your store's Count Sheet Completion is not sufficient to make a good IRA sample then it will be substituted and not display on your Retail Analytics Dashboard.

Steps to correct

1. Locate your completion Metric and confirm it's less than 95%
   1. Review Report Email
   2. Charts.pdf attachment
   3. Inventory Accuracy Scorecard (page 3)
   4. Completion Metric (lower left) and historical completion in the graph (green line)
2. Achieve completion of 95% or greater. Operational Level 0 - Completion 

In the example below the Random Count completion (44 counted out of 165) is too low to achieve a statistically significant sample. In this case, IRA is estimated by Mango as indicated by an open diamond (IRA substituted) on the IRA (red) trend line. This can happen when a store stops processing their Count Sheets due to a store remodel, staffing change, etc.

In the example below, there is high enough Completion for a good IRA sample, however, there was a mismatch between the sample counted and its expected value. Mango calculates it own internal IRA (based on the percentage of SKUs rung to negative quantity-on-hand at checkout) and compares it to the Count Sheet sample returned. If the mismatch is big enough then it a substitution alert will show and the store's counted IRA will be substituted with Mango's calculated IRA. The substituted sample(s) will be shown as an open diamond in the red IRA trendline. This behavior helps protect stores from measuring an incorrect IRA caused by lack of quantity-on-hand variance research or, in some cases, lazy (lunchroom counts) or "optimistic" counting to pad IRA. Sometimes a validation alert can be caused by other factors. 

Example Screenshot

How to investigate IRA validation issues

1.  Locate your Review Report Email (sent around the 2nd of each month)
2.  Open the attachment titled "Charts.pdf"
3.  Scroll to the Inventory Accuracy Scorecard (Page 3) and verify the IRA Substituted stamp is present

The most common reason for IRA substitution is due to a high negative QOH percentage coupled with very high reported accuracy. In the example above, the store reported an accuracy of 96% on the 55 Random Count SKU (53 of 55 with no variance) but is experiencing a high negative QOH percentage, 10%. It's very hard to say you're a store that's 96% accurate but also having so many SKUs go negative.

Research Negative QOH

1. Navigate to your Online Report portal and login
2. Download the IRA Validation Excel report available in the store's Excel folder.
3. Look at your Negative QOH worksheet tab and see if there is a rhyme or reason these SKUs went negative last month. SKUs that have gone negative multiple times in the previous month are easier to spot patterns on.

If the negative quantity-on-hand SKUs all look reasonable then continue to the next step. If there is a lot of noise in your negative QOH's then try to resolve the receiving issue or other store procedure causing the negative QOH's.

1. Look at your RC Count Type tab
2. Have another person (other than the person who initially counted) carefully re-count the listed  RC  Count Types from last month. 

Stores struggling with IRA are usually focused too much on counting and "fixing" QOH and focused too little on root accuracy processes such as cashier testing, careful counting and variance research, and high-standards department maintenance. Please review our IRA Checklist and the different steps associated with achieving IRA.