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
>
PDF Reports
>
Floor Exceptions
>
Hot Shrink
Hot Shrink / Procedure Shrink -
Floor Exceptions
This exception report focuses on SKUs with high shrinkage frequency and high shrink to sales ratios. It is divided into two sections:
Hot Shrink
- shrinkage to regular packaged SKUs likely to be persistent
theft.
SKUs under the Hot Shrink heading are exhibiting a very high shrink to sales ratio. These SKUs are also being reported on your Count Sheets as Count Type
WD HOT
and will continue to be reported until the shrinkage stops.
Steps to process this report
1. Determine if the SKU is being stolen or if there is a store procedure causing shrinkage.
2. If it is persistent theft then attempt to catch the thief, secure the SKU or consider dropping the SKU from your assortment.
If there is a store procedure causing the shrinkage then consider adhering to Ace's inventory best practices to cure the issue. Please
contact us
if you need help!
Procedure Shrink
- shrinkage to bulk and store supply SKUs.
SKUs listed as Procedural Shrink are likely Store Supply and or Bulk SKUs exhibiting persistent shrinkage.
If the SKUs are Store Supplies then consider using a Credit PO to reduce quantity-on-hand instead of using PIP.
If the SKUs are bulk then consider setting their codes to Keep Stock Info = N (Codes tab of Inventory Maintenance) if not using computer suggested orders for these SKUs. If the SKUs rely on
a order
point then consider selling the SKUs at point-of-sale and then issuing a return to the corresponding dump SKU in the same transaction to
net
the sale out. This
behaviour
will allow
you
track sales at the SKU level and will result in better margin and order point reporting.
Please
contact us
if you need help!
Column Help
SHRINK UNITS
: two-year net unit shrink units.
TIMES CHNG
: number of times the SKU
have
been counted over
past
two years.
SALE UNITS
: number of sales units over a two-year period.
TIMES PURCH
: number of times the SKU has been purchased over a two-year period.
SHRINK% UNITS
: this is the percentage of shrinkage units divided by the SKU's sales units. For example, 10% means that the SKU shrinks 1 time for every 10 units sold.
SHRINK RETAIL
: the total retail value of the SKU's shrinkage over the past two years.
Copyright © 2024 Mango Report All Rights Reserved.
{1}
##LOC[OK]##
{1}
##LOC[OK]##
##LOC[Cancel]##
{1}
##LOC[OK]##
##LOC[Cancel]##