Please enable JavaScript to run this help system!
Mango Report
Help Center
Search:
Contents
Index
Search
Page Properties
Page Keywords
Page Visibility
Preview For Mobile Device
Lightbox Code & Preview
Save
Cancel
Saving...
Welcome
Best Practice Checklist
Monitor / Set Goals
Tools
Onboarding
Month 1
Report Packet
Count Sheets
Track Count Sheet Progress
Master Exception Report
MEGA Report Intro
Month 2
OL & PL Preview
Count Sheets
Track Count Sheet Progress
Office Exceptions Report
Assortment Report
Month 3
Count Sheets
Track Count Sheet Progress
Floor Exceptions Report
Closeout Management
Month 4
Count Sheets
Track Count Sheet Progress
RAD In Stock
Month 5
Count Sheets
Track Count Sheet Progress
Shrink Report
Month 6
Count Sheets
Track Count Sheet Progress
Back Stock Replenishment
Best Practice Checklist
Operational Level
Level 0 - Completion
PIP Overview
Count Sheets
Understanding Completion
Maintaining Inventory Accuracy
Track Count Sheet Progress
How to Count
Level 1 - IRA
Understanding IRA
IC Role
PIP Research
Skills Training
Eagle System Settings
Count Sheets
Shooting Outs
Cashier Testing
Back Stock Purge
Store Floss
Monitor IRA
Full Count
Level 2 - Dollar Accuracy
Understanding Dollar Accuracy
Fix Boundary Issues
Monitor Dollar Accuracy
Level 3 - Shrink
Understanding Shrink
Excluded Shrink
Variance Research
Variance Worksheet
Monitor Shrink
Level 4 - Efficiency
Understanding Efficiency
Monitor Efficiency
Counting Process Review
Productivity Level
Level 0 - Unproductive
Level 1 - In Stock
Level 2 - Assortment
Accuracy Cadence
Jan - Purge Back Stock
Feb - Delete Report
Mar - Cashier Testing
July - Purge Back Stock
Aug - Flossing Your Store
Oct - Cashier Testing
Nov - Top Inventory Review
Retail Analytics Dashboard
In Stock
Ace MOP
MOP Reductions
EOQ (Min/Max)
Assortment
IRA
Back Stock Replenishment
Setup & Maintenance
Processing Back Stock
Report Example - ARMA
Closeout Management
Identify
MIP & Label
Remove
Quick Resources
MEGA Report
COM
Obsolete
Overstock
In Stock
Assortment
OM Variances
UPC x Links
Disc Flag Mismatch
UPC Coverage
Ord Indicator Mismatch
Item Setup Issues
Primary Vendor Mismatch
Unsynced Retail
Invalid UPC
MSU Code Issues
Kit Header Issues
RCIN Issues
RPA Settings
Cost/QOH Errors
Store Supply
Persistent Negative
Canceled Replaced
Ord Not Rep
Ghost Promos
Special Fee Codes
Retail less than Cost
COM Pinned
CS XX Store Closeout Check
Location Exceptions
Misc Issues
Shooting Outs
Eternal Outs
Missed SKUs
Cross Merch Suggest
Promo Residue
BKST - Shelf Capacity
Top Back Stock
AH.COM
Inventory Value Changes
Key Metrics
Cat Diff - Dept Tab
Cat Diff - Class Tab
Cat Diff - Fineline Tab
Cat Diff - Vendor Tab
Cat Diff - SKUs Tab
PDF Reports
Charts
Inventory Dashboard
Executive Summary
Sales
Operational
Productivity
Inventory
Lead Measures
Mango
Inventory Accuracy Scorecard
IRA Substituted
Theft Alert
Boundary Alert
Completion Alert
Shrink & Efficiency Trend
Count Sheets
Floor Exceptions
COM - Remove Label
COM - Remove Product
Eternal Outs
Hot Shrink
Location Code Exceptions
Missing Shelf Capacity
Multi-Location Maintenance
Shooting Outs
Stop Sales
Store Closeout Assortment
Store Closeout Check
Key Metrics
Count Metrics
Master Exceptions
Acenet Direct - UPC Coverage
Alt Vendor Part Number Issue
Class / Fineline Adds
Disc / Ord Ind Mismatch
Invalid UPC
Item Setup Issues
Kit Header Issues
MSU Issues
Multi SKU Items
Ace Catalog - UPC Coverage
OM Variances
Primary Vendor Mismatch
RCIN Issues
RPA Settings
Unsynchronized prices
UPC X-Links
Office Exceptions
Blank QOH
Boundary - Cost/QOH Errors
Boundary - Store Supplies and Coupons
Boundary - Negative Quantity on Hand
Canceled and Replaced
COM - Pinned Closeouts
Duplicate SKUs
EOQ - Shelf Capacity Check
Ghost Promos
Gross Profit Exceptions
High Returns Ratio
In Stock - Ace Min OP Listing
In Stock - Common Transaction
In Stock - Days Zero
Example - Days Zero
In Stock - Order Point Reduction
In Stock - ROP Protect = Y
Low Stock Check
Margin Impact
MDR Store Closeout N
Missing Store Closeout
Ordered but not replenished
Receiving Issues
Retail less than Cost
Placeholder SKUs
PO Season Codes
Special Fee Codes
Store Closeout = U
Top Promotions and Discounts
XX Count Type - Store Closeout Check
Zero Max Stock Level
Shrink Report
Variance Worksheet
Adjusted
Excluded
Totals
Defective
Transfer Report
Excel Reports
Unblock Macros
Chain Assortment
Delete Report
Class
Fineline
Mfg Vend
Elasticity Analysis
Fiscal Shrinkage
IRA Validation
Mango IVA
Master Transfer Report
Non-Ace Product Mix
Product Analysis
Vendor
Location
Class
TTM/Month SKU Detail
Product Mix
Show Buying Report
Deals
SKUs
Videos
Case Study: OL0 & PL0
Count Sheets
Data Import: Location Code Exceptions
Help Center Overview
How to Count
Excel Tips & Tricks
Epicor Level 28 Count Sheet Progress
Epicor Level 28 Integration Setup
Maintaining Inventory Accuracy
Online Reports
Purge Back Stock
RAD - Assortment
RAD Integration Sneak Preview
Store Flossing
Shrink & Efficiency Trend
Show Buying Report - Acenet
Track Count Sheet Progress
What is Mango Report?
Webinars
Closeout Management
Operational Level 0 - Completion
Productivity Level 1 - In Stock
Productivity Level 2 - Assortment
WWS 24 - IRA
WWS 24 - Back Stock Replenishment
WWS 24 - MEGA Report 101
Reference
Mango Report Overview
Mango Report API
Moving API Time
Cashier Testing
Count Sheet Count Types
Common Jargon
Daily Metrics
Location Codes
Back Stock Location 3
Secondary Locations
Printing Bin Labels
Printing Closeout Bin Labels
Placeholder SKU Setup
Scheduling Negative QOH Report
Shooting Outs
Spooler Maintenance
Excluded Shrink
The Stella Report
Time & Difficulty Expectation
Change Log
Search
:
Index
Bookmark
Print
Edit Page
Publish Draft
Delete Draft
Compare Draft
Edit Header
Home
>
Operational Level
>
Level 0 - Completion
>
Understanding Completion
Level 0 - Understanding Completion
Your store's Operational Levels are primarily driven by processing Mango's Count Sheets. Because of this, counting each SKU on your Count Sheets is a prerequisite to getting the most out of Mango. Your Level 0 - Completion metric shows how thoroughly your store has processed its Count Sheets over the last three months. 90% completion means 9 out of 10 SKUs listed were counted. Most stores set a goal of 100% completion and later we will show you how to
nail it every month
. For now, let's focus on what completion means and where we see it measured.
How is Completion measured?
Count Sheet Completion shows the percentage of SKUs listed on your Count Sheets which received a Last Physical Inventory update (were counted). It is a three-month average and you can make up missed counts from a previous month (up to two months back) and your metric will be revised.
SKUs receive a Last Physical Inventory update when entered into PIP and then finalized. The date the SKU was counted (entered into PIP) will be the SKU's Last Physical Date regardless of when PIP is finalized. It is important to make sure PIP is finalized before the end of the month so that Mango knows which SKUs were counted when it takes its data snapshot.
For example, if a store has 400 SKUs on their Count Sheets and they count them all then their completion will be 100% for the month. If they only count 360 SKUs then Completion will be 95%.
Where is Completion measured?
Let's take a look at where completion is measured. Your Inventory Accuracy Scorecard (Review Email, Charts.pdf, Page 3) shows your store's completion Metric at the bottom left. The example store below shows 2% completion, which indicates this store only counted 2% of its Count Sheet SKUs over the past three months.
Completion - Explained
In the chart section of the
Inventory Accuracy Scorecard
, you will see a green line (chart below) showing monthly Completion as a trend line. In the example below, you see a store with completion between 90% and 100% in November - February but then completion falls off the chart below 30% for the remaining months.
In the example below, we see a store consistently hitting 100% completion! Way to go!
Above, we see the green Completion line pegged at 100% month after month. This store like many (a significant majority) stores using Mango achieve high completion on a regular basis.
Tips for achieving 100% Completion
Use and keep Location Codes current
Since your Count Sheets are sorted by Location Code, having current codes associated with your SKUs will dramatically improve the speed & accuracy of your Count Sheet Processing and help with put-away accuracy and customer service too!
Location Code Help
.
Utilize your best counters to process
Count
Sheets
Usually,
the fastest and most accurate inventory counters are not your managers. Managers are distracted too easily and should focus their efforts on directing sales and customer service rather than counting. Finding the right person to process your Count Sheets is a worthwhile endeavor. Some stores have department heads process sheets individually while other stores assign one single person. Regardless of how your store gets it done, it is imperative that
a 2nd
set of eyes (an
inventory coordinator
) review quantity-on-hand
variances to
verify the accuracy of the person counting. If your inventory coordinator can easily correct variances then the person you have
counting
is not doing a careful enough job of looking for items before logging a variance. It is unacceptable to have a careless counter process your Count Sheets as it will cause havoc with your metrics, inventory accuracy, and increase variance research labor. Some people are naturally gifted at counting and others are not. Our recommendation is to not spend a lot of time trying to train someone to be a proficient counter as a person tends to be good or bad at counting naturally. Rather, spend your time finding (and monitoring) the right person to do the job.
Count when the store is "cold"
Try to concentrate your counting efforts in the morning or evening when the store is not busy. This results in better accuracy and better utilization of labor.
Progress Viewer
Load your
Progress Viewer
when you are completed and count any missed SKUs. This guarantees 100% Completion!
When completion is not desired
There are times when counting in a store is not always desirable. Typically this is when a store is undergoing a remodel or a large reset. When this is happening, it is often best to get the store put back together as quickly as possible and then resume counting. If a store wants, it has two months to catch up on any missed counted SKUs.
Print the Level 0 Checklist here!
Next Step -
Maintaining Inventory Accuracy
Previous Step -
Count Sheets
Copyright © 2024 Mango Report All Rights Reserved.
{1}
##LOC[OK]##
{1}
##LOC[OK]##
##LOC[Cancel]##
{1}
##LOC[OK]##
##LOC[Cancel]##