Mango Report
Help Center
Search:
Contents
:
IndexBookmarkPrint

Home > Operational Level > Level 3 - Shrink > Excluded Shrink

Operational Level 3 - Excluded Shrink

Mango will exclude certain categories when measuring your Operational Level 3 - Shrink metric. SKUs classified below will be separated from your adjusted shrink listing and placed in the excluded section of your Shrink Report. 

     Adjusted Shrink vs. Excluded Shrink

Both adjusted and excluded shrink are listed (separately) in your Shrink Report, but the adjusted portion is only used in your Operational Level 3 - Shrink metric.

Print the table below here.

Excluded Shrink Classifications
Category Class Fineline Other Notes
Fasteners 561, 564, 566, 578, 580 - - - - If your store classifies fasteners differently (Class HIL for example) then Mango will not pick these up as Excluded unless there is a SKU match to Ace's catalog.
Store Supply - -  - - Location 1 = STORE SKUs with a Location Code of STORE or where a SKU matches Mango's internal Store Supply database will be treated as Excluded. Consider utilizing Credit PO's (or Keep Stock Info=N) to minimize shrinkage noise.
Coupon - - - - - - SKUs with Coupon signatures are treated as excluded shrink.  SKUs flagged with Coupons signatures are shown in your Exceptions.pdf report (Store Supply and Coupons, usually page 2).
Lumber - -  - - Record Type = L Shrink to L - Lumber SKUs is treated as Excluded due to the amount of noise in this category. Lumber enabled stores can find Record Types in the upper-left corner of Inventory Maintenance.
Live Goods 752 - - - - Live goods can have significant shrinkage which is expected in this category.
Keep Stock = N - -  - - IMU Codes Tab When a SKU's Keep Stock Info status is changed from Yes to No and the SKU had a QOH value, the loss in inventory value is shrink. Your Eagle system will not list the SKU in RPH but Mango will pick up the variance and list it as excluded.
Store Closeout = Y - -  - -  IMU Codes Tab Shrink due to closeout activity is treated as excluded. 
 Rental -- -- Location 1 = RENT Rental SKUs are treated as excluded shrink. 
Bulk - Keys 510 - - - - If your store classifies keys differently (Class KEY for example) then Mango will not pick these up as Excluded unless there is a SKU match to Ace's catalog.
Bulk - Glass 151 - - - - Bulk Goods tend to be noisy and shrink is offset by sales to a corresponding dump SKU.
Bulk - Acrylic 152 - - - -
Bulk - Wire 310 - - - - Bulk Goods tend to be noisy and shrink is offset by sales to a corresponding dump SKU.
Bulk - O-rings 404 - - - -
Bulk - Tubing 466 - - - - Bulk Goods tend to be noisy and shrink is offset by sales to a corresponding dump SKU.
Bulk - Plastic Pipe 478 - - - -
Bulk - Screen Repair 546 - - - - Bulk Goods tend to be noisy and shrink is offset by sales to a corresponding dump SKU.
Bulk - Chain 570 - - - -
Bulk - Nails 573 - - - - Bulk Goods tend to be noisy and shrink is offset by sales to a corresponding dump SKU.
Bulk - Window Screen 575 - - - -
Bulk - Rope 762 - - - - Bulk Goods tend to be noisy and shrink is offset by sales to a corresponding dump SKU.
Loc6:MGOEX - -  - -  Location 6 = MGOEX Setting a SKU's Location 6 to MGOEX will treat all shrink to the SKU as excluded. This setting can be used to classify a range of SKUs in your store if the above classifications are not suitable for your organization.
 Stop Sale - - - - - - SKUs with active recalls or vendor stop sale notices are treated as excluded. Ideally, these items would be removed from inventory via a credit PO since a credit is typically issued from the vendor.


Print the Level 3 Checklist here!
Next Step - Variance Research
Previous Step - Understanding Shrink