Home > Onboarding > Month 6 > Count Sheets
Month 6 - Count Sheets
The heart of Mango's Inventory Accuracy system is its monthly Count Sheets. It's important for everyone using Mango to understand this report and process them each month. For many stores, processing Mango's monthly Count Sheets using their mobile Zebra device(s) is more labor efficient. Follow the steps below to take advantage of paperless processing! If you favor paper Count Sheets, that process is outlined near the bottom of the page.
Enable MANGOAPI
Make sure your Eagle MANGOAPI queue is scheduled - the MANGOAPI creates the count sheet list in your Eagle system each month.
Update Eagle Mobile+
Role-Based Security Configuration
For a user to automatically be assigned to the count list they must be assigned to a role with security bit 423 and/or 863 set to YES.
Check which roles have these security bits set to yes.
Now you'll need to verify the person (user) counting is assigned to at least 1 role where the security bit was set to yes
Eagle Options Configuration
The first block of Option IDs below are required and must to be set to the specified value for the Count Sheets to work on your Zebra device. The second block of Option IDs are recommended settings but can be tweaked to a user's preference
Report Location
Action Email -> Office Exceptions.pdf -> usually Page 3
This report lists SKUs that are on your current Count Sheets with Count Type XX, indicating an item with very low sales volume in your store and peers. Many times these SKUs are "phantom inventory" where they exist in your computer system but have not been part of your store's assortment for a long time. Risk: the SKUs in this report are active in your RSC and risk being reordered if zeroed out during Count Sheet processing. SKUs on this report Are on your current Count Sheets to be inventoried as XX Count Types. Have Store Closeout set to N (can be reordered). Are Active or Closeout in your RSC (can be replenished). Are very slow sellers in your store and in peer stores. Are not part of a "collection" (e.g. v-belts, numbered drill bits, paint bases, etc.). Are not Discovery SKUs. Are not COM excluded SKUs (Loc2 = XDR, for stores using COM). Steps to process report: Decide if the SKU should be reordered if zeroed during counting. If the SKU should be reordered then do nothing, skip to the next SKU. if you do not want the SKU reordered then: Display the SKU in Inventory Maintenance. Change to the Codes tab in Inventory Maintenance. Change the Store Closeout flag to "Y" (3rd Column). Press Change.
This report lists SKUs that are on your current Count Sheets with Count Type XX, indicating an item with very low sales volume in your store and peers. Many times these SKUs are "phantom inventory" where they exist in your computer system but have not been part of your store's assortment for a long time. Risk: the SKUs in this report are active in your RSC and risk being reordered if zeroed out during Count Sheet processing.
SKUs on this report
Steps to process report:
It's time to hit the sales floor and begin counting Count Sheets.
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.
Inventory counts entered into PIP from Eagle Mobile+ updates the item’s quantity on hand only after the RPI is run. To create an RPI to finalize the inventory counts, follow the steps below.
Your Count Sheet completion metric is a 3-month average and because of this we allow you to make up missed counts from the previous 2 months and get credit for the work. The steps outlined below use the LISTS feature from Eagle Browser to achieve 100% Count Sheet Completion!
Eagle Browser LISTS
LISTS is a great way to quickly see any remaining Count Sheet SKUs that still need a count. Note: if you follow the steps below but do not see the Mango Count Sheet list then a 1-time setup needs to be performed on your Eagle Server, click here for those instructions. Your Eagle Server needs to be on Level 28 (released in 2018) or higher to use this functionality.
Video Instructions
Mango's Count Types are the reason SKUs are reported on your Count Sheets. Before heading to the sales floor, print out and read through the explanation for each type. Understanding these Count Types will give you clues while out counting. Example: an XX or MC type is less likely to be found than an RC or TI , and TI types might also be in back stock.
Please be sure to review variances in PIP before finalization. Guidance can be found in the PIP Overview module.
Track Count Sheet ProgressBack Stock ReplenishmentBest Practice Checklist