Home > Operational Level > Level 3 - Shrink > Variance Worksheet
Shrink Report - Variance Worksheet The Variance Worksheet highlights top variances from your Shrink Report so that extra research can be performed to find and resolve the root cause. Your Inventory Coordinator should complete the worksheet (he/she should already have knowledge of these variances) and work with his/her manager or owner to resolve personnel, procedural or theft issues.
Quantity-on-hand variance research is the most important accuracy process in your store. PIP research is typically performed by your inventory coordinator where he/she diligently scrutinizes variances in the Physical Inventory Posting (PIP) viewer before variances are finalized. You should set dollar thresholds $15.00 (for example) that trigger mandatory research when the variance dollar amount is exceeded. Stores employing good variance research can quickly find and fix the root cause of inaccuracy. 1. Get a good first count It all starts with a good initial count. Our How to Count video will help your team understand the importance of counting better. Folks giving you frequent bad counts need to be identified and trained! If additional training fails then counting may not be the best task for that individual and their counting responsibility reassigned. 2. Research variances in PIP before RPI is run Variance research is the cornerstone of inventory accuracy. It's how you figure out and fix the process or person causing issues, and once fixed, the accuracy of your store increases. 1) Sort PIP by the Shrinkage column you created in Level 0 - Completion (Step 1), or the Repl Cost Varinace column if it's available in your PIP viewer. 2) Verify each variance over/under your mandatory research policy threshold ($15.00 for example) Recount the SKU Look in nearby bins hooks for the item Look in top stock and back stock Look in return and defective bins. Look in special order shelves Look for multiple locations (clip strips, end caps, etc.) 3) Try to determine the variance root cause Was it a bad count? A count correction? Cashiering error? Receiving error? Theft? 4) If the variance was a result of a cashiering or receiving error then fix it in MPO or POS and delete the entry in PIP. Do not use PIP to correct cashiering or receiving errors as this will skew shrink, purchasing, sales and order points. 3. Perform deep variance research You can follow the Shrink Report - Variance Research help dig even deeper.
Quantity-on-hand variance research is the most important accuracy process in your store. PIP research is typically performed by your inventory coordinator where he/she diligently scrutinizes variances in the Physical Inventory Posting (PIP) viewer before variances are finalized. You should set dollar thresholds $15.00 (for example) that trigger mandatory research when the variance dollar amount is exceeded. Stores employing good variance research can quickly find and fix the root cause of inaccuracy.
1) Sort PIP by the Shrinkage column you created in Level 0 - Completion (Step 1), or the Repl Cost Varinace column if it's available in your PIP viewer.