Totals - help

Mango Report
Help Center

Search:

Contents

Index

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
Operational Level
Productivity Level
Accuracy Cadence
Retail Analytics Dashboard
Back Stock Replenishment
Closeout Management
MEGA Report
PDF Reports
Excel Reports
Videos
Webinars
Reference

IndexBookmarkPrint

Edit Page

Publish Draft

Delete Draft

Compare Draft

Edit Header

Home > PDF Reports > Shrink Report > Totals

Shrink Report - Totals

The totals portion of your Shrink Report shows inventory counts, variances, shrink and completion totals for the month of the report. Note: these are monthly totals, not year-to-date or twelve trailing months. The totals section contains four sections:

1) Shrink and variance totals.

This section shows inventory counts, variances, and shrink totals for the month broken out into adjusted and excluded categories.

SKUs Counted

1 - The number of SKUs receiving a Last Physical Inventory date update (counted) during the month within your adjusted (non-excluded ) SKU population. This is part of your Level 4 - Efficiency metric.
2 - The number of SKUs counted during the month in your excluded SKU population.

Variances

3 - The number of SKUs that received a quantity-on-hand variance during the month within your adjusted SKU population. This is part of your Level 4 - Efficiency metric.
4 - The number of SKUs that received a quantity-on-hand variance during the month within your excluded SKU population.
Down - The number of SKUs that received a downward quantity-on-hand adjustment (usually associated with breakage and theft).
Up - The number of SKUs that received an upward quantity-on-hand adjustment (swell). These are usually associated with errors and error corrections.

Shrink

5 - Net shrink dollars for the month within your adjusted SKU population. This is part of your Operational Level 3 - Shrink metric.
6 - Net shrink dollars for the month within your excluded SKU population.
7 - Total net shrink for the month, also know as your financial shrink.

2) Adjusted shrink and variance attributed to Mango's Count Sheets

This section shows inventory variances and shrink attributed to processing your monthly Mango Count Sheets, adjusted SKU population only. This section is helpful for stores recently onboarding with Mango and experiencing significant shrink attributed to phantom inventory cleanup.

Count Sheet SKUs

1 - The number of variances for the month.
2 - Net shrink dollars for the month.
Ace SKU population.
Non-Ace SKU population.

3) Excluded shrink subtotals

This section subtotals variance and shrink by excluded reason.

1 - The Excluded Reason
2 - The number of variances the excluded reason for the month.
3 - Net shrink dollars for the excluded reason for the month.

4) Operational Level 0 - Completion

This section details Operational Level 0 - Completion (count sheet completion) for the trailing three months.

1 - Shows the Count Sheet month.
2 - Shows the details for the month.
- SKUs Reported - indicates the total number of SKUs reported on the month's Count Sheets.
- SKUs Counted - shows the number of Reported SKUs that were counted for the month.
- SKUs Missed - shows the number of SKUs that were reported but not counted for the month.
- Shows completion for the month (SKUs Counted divided by SKUs Reported).
3 - Breaks out the current month's completion into the Ace SKU population and the Non-Ace SKU population.

Note: up to 46 SKUs Missed (two pages) for the previous month (September - example above) will show on your current month's Count Sheets so your store can make up its missed SKUs. Please see Track Count Sheet Progress for a way to ensure 100% completion month after month.