This powerful worksheet shows all Obsolete classified SKUs in all your stores. These items have not had any action (add, purchase or sale) in over two years and (along with Overstock SKUs) make up your Unproductive Inventory (Productivity Level 0) metric. This worksheet works in tandem with Mango's Closeout Management system to help you identify and then manage a markdown strategy to intelligently and effectively close out these SKUs inline.
-
Through deep segmentation analysis of Obsolete inventory, a more relevant and actionable SKU mix can be presented on Closeout Management listings by speeding up and slowing down the obsolescence timeline of certain classes. While the baseline of classes still remains at the 24-month mark, a class's obsolete timeline can only be accelerated up to 6 months or delayed up to 12 months based on the table below.
Faster Slower Class Name Class Name 100 FLOOR CARE 155 VACUUM/FLOOR CARE PARTS 103 HOUSEHOLD CLEANERS 161 LIQUID PAINT- NATIONAL 104 QUICK CLEAN PRODUCTS 162 ACE PAINT DIV. PRODUCTS 105 GLASS/PLASTIC CLEANERS 247 ROUTER BITS 106 AIR FRESHENERS/HOUSEHOLD 258 SOCKETS AND ACCESSORIES 107 BATHROOM CLEANERS 278 METAL TOOL BOXES/CHESTS 112 CARPET/UPHOLSTRY CLEANERS 318 SURFACE WIRE CARRY SYSTEM 113 SOAP/DETERGENT/AMMONIA 339 CATEGORY 5 ACCESSORIES 115 COMMERCIAL & JANITORIAL 342 FLUORESCENT FIXTURE ACCS 116 HOME/MAINTENANCE BRUSHES 344 CEILING FANS & ACCESS 117 SPONGES & SCOURING PADS 356 DECORATIVE LIGHT FIXTURES 119 BROOMS/DUST PANS 358 REPLACEMENT GLASS 120 OIL DRI/SWEEPING COMPOUND 359 FUNCTIONAL INDOOR LIGHTIN 121 SQUEEGEES/WINDOW BRUSHES 362 COMPACT FLUOR LIGHT BULBS 122 MOP WRINGER/BUCKETS/PAILS 365 SECURITY LIGHT BULBS 126 PAINTING & PROJECT TAPES 368 TELEPHONES/2-WAY RADIOS 127 GLUES/ADHESIVES/APPLICATR 374 LAWN & GARDEN LIGHTING 128 CAULK/SEALANTS/GLAZING 401 FAUCET PARTS 131 PAINT BRUSHES 404 WASHERS/'O' RINGS/PACKING 134 WIRE BRUSHES 411 BATH ACCENTS AND ACCS 135 PUTTY KNIVES/PAINT SCRAPE 414 VANITIES/TOPS 136 PAINTER TOOLS/PAILS/ACCS 441 WELL/SPRINKLER PUMPS 140 GLASS & ACRYLIC 442 WELL SUPPLIES 144 SOLVENTS/THINNERS 457 WICK/STOVE/HEATER PARTS 146 WALL REPAIR MATERIALS 467 TUB/SHOWER WALL SURROUNDS 148 CEMENTS/PLASTERS 472 BRASS FITTINGS 150 HAND/POWER SANDING ABRASI 473 COPPER FITTINGS 156 WOOD FILLER/PUTTY/STICKS 475 STEEL PIPE 163 SPRAY PAINTS 476 IRON PIPE FITTINGS 171 PAINT ROLLERS/FRAMES/TRAY 477 PLASTIC FITTINGS 193 PAINT PADS 490 PEX FITTINGS 198 WALL PRIMERS 491 PUSH FITTINGS 219 UTILITY KNIVES/BLADES 501 KEYED AUXILIARY LOCKS 229 MARKING TOOLS/TAPES 510 KEYS 232 MEASURING TOOLS/REFILLS 513 WINDOW HARDWARE 233 PRECISION TOOLS 517 CABINET HARDWARE 251 POWER DRILL BIT SETS 545 VENTILATION PRODS 253 PLIERS 546 SCREEN/WNDOW REPAIR PARTS 264 SNIPS/BOLT CUTTERS/HVAC 548 METAL EXTRUSIONS/SHAPES 266 PROPANE KITS/FUEL/ACCS 560 ANCHORS-CARDED 281 MODULAR TOOL STORAGE 561 ANCHORS-BOXED 305 BATTERIES 562 SPECIALTY FASTENERS 307 CORD SETS 564 WASHERS-BOXED 316 STRAPS/STAPLES/CONNECTORS 566 NUTS-BOXED 327 MULTIPLE OUTLET DEVICES 569 LOG & TOW CHAIN/ACCS 345 ELECTRICAL TAPE 573 BULK NAILS/STAPLES 407 WATER SUPPLY LINES 576 DRYWALL/DECK/EXT SCREWS 419 TOILET SEATS 578 SMALL SCREWS-BOXED 428 THERMO COUPLES 579 SMALL SCREWS-CARDED 432 FURNACE FILTERS 580 BOLTS-BOXED 449 PIPE JOINT SEALANTS 584 METAL FRAMING CONNECTORS 450 PIPE WRAP/FAUCET COVER 595 TURNED LUMBER 452 CEMENT/FURNACE REPAIR 596 DOORS & WINDOW 453 DUCT TAPE 598 DECK AND RAILING PRODUCTS 460 FIREPLACES/STOVES/INSERTS 599 FLOOR JACKS 470 DRYER/BATH/RANGE VENTING 611 ELECTRIC SHAVERS 486 DRAIN / SEPTIC CHEMICALS 612 PERSONAL CARE APPLIANCES 488 HOSE/PIPE CLAMPS/HANGERS 616 ELECTRONICS ACCESSORIES 525 HOOK AND LOOP FASTENERS 622 GIFTS/INDOOR DECOR 540 FLOOR PROTECTION 624 AIR PURIFICATION 547 TEMPORARY MOUNTING 625 DINNERWARE 582 CONCRETE/BLACK TOP 657 FLATWARE 610 PORTABLE ELECTRIC HEATERS 670 WATCHES & JEWELRY 655 FOOD WRAP AND BAGS 733 MOWER/TRACTOR ATTACHMENTS 656 PAPER/REUSABLE LAWN-LEAF 757 ELECTRIC BUG KILLERS 658 TRASH BAGS 781 HYDRAULIC HOSE/ACCESS. 673 COOKING THERMOMETERS 819 AUTOMOTIVE SPARK PLUGS 674 LIGHTERS & FUEL 857 TRIKES/WAGONS/SCOOTERS 684 DISPOSABLE GLOVES 859 WATER SPORTS 697 AS SEEN ON TV PRODUCTS 865 OUTDOOR FURNITURE SETS 701 SHOVELS/SPADES/SCOOPS 892 AUTO PNEUMATIC TOOLS/ACCS 702 RAKES & FORKS 899 OUTDOOR DECOR/TREND 703 HANDHELD SOD/TURF TOOLS 935 CHRISTMAS GIFT WRAP & ACC 708 STRIKING TOOLS 937 STORE SUPPLIES (TAXABLE) 709 SMALL HANDLE TOOLS 941 ACE APPAREL 711 PRUNING/GRASS TOOLS 942 HARVEST 714 POWER EQUIPMENT OILS & FU 949 GIFT CARD ACCESSORIES 718 HOSE NOZZLES 954 CHRISTMAS TREES 719 HOSE FITTINGS 956 SEASONAL HOLIDAYS 723 GARDEN HOSE 997 PAINT (TAXABLE) 726 LAWN MOWERS 737 FUEL CONTAINERS/FUNNELS 739 SWEEPERS/ROLLERS/SPREADER 744 FERTILIZERS 746 BAGGED PRODUCTS 747 PLANT FOOD 752 LIVE GOODS 753 WEED CONTROL PRODUCTS 754 RODENT & ANIMAL CONTROL 755 MOISTURE & MILDEW CONTROL 759 GRASS SEED 760 GLOVES/GARDEN APPAREL/ACC 761 PACKAGED ROPE/TWINE 768 SNOW REMOVAL TOOLS 771 ICE MELT 774 TARPS 783 PLASTIC TRASH CANS 803 TOBOGGANS/SLEDS 805 AUTO APPEARANCE CHEMICALS 806 AUTOMOTIVE CLEANING PRODU 808 AUTO MAINT. CHEMICALS 809 MOTOR OIL/TRANS FLUID 810 AUTO & HOUSEHOLD LUBRICAN 811 AUTO BODY REPAIR 818 WINTER AUTOMOTIVE PRODS 822 FIRE EXTINGUISHERS 824 PET/ANIMAL FOOD 856 STRETCH CORDS/TARP STRAPS 870 BBQ FUEL & ACCESSORIES 873 BBQ SAUCES & SEASONINGS 877 BIRD PRODUCTS 888 AUTO ADHESIVES/GASKETS 891 TIRE PRODUCTS 900 WRITING INSTRUMENTS 915 HEALTH & BEAUTY AIDS 927 CANDY AND FOODS 934 WATER AND BEVERAGES 943 OFFICE & PACKAGING TAPES 946 MOVING/MAILING SUPPLIES
-
2 important columns
-
G - Chain Carried %: the percentage of stores carrying the SKU (i.e. 3 of 4 stores carry this SKU, 75%)
-
H - Chain Obsolete %: the percentage of obsolescence in stores carrying the SKU (i.e. SKU obsolete in 1 of 3 stores, 33%)
Using this list for Closeout Management:
If you would like Mango to manage the markdown for these SKU then:- Execute the SKUs from the Closeout Management grid on RAD (Acenet) first.
- For additional SKUs set Eligible (Column Z) = Y
- Set In COM list (Column AA) = N
- Set In Season Next Month (Column AC) = Y
- This is a list of relevant SKUs to add to Closeout Management beyond the COM tab list.
- Follow the steps in Closeout Management -> Identify to add these SKUs.
More information:
Closeout Management-
E - Loc 2: listed if a SKU has a location listed under Location 2 in IMU. MDR means the SKU is being actively closed out by Mango's Closeout Management process, XDR means the SKU has been reviewed by someone in your store who decided to close it out but not mark down its price via Closeout Management.
F - Discovery: Indicates if the SKU is in a Discovery Assortment. Many stores choose not to close these SKUs out in case a discovery level reset would require a repurchase.
G - Chain Carried %: the percentage of stores carrying the SKU (i.e. 3 of 4 stores carry this SKU, 75%).
H - Chain Obsolete %: the percentage of obsolescence in stores carrying the SKU (i.e. SKU obsolete in 1 of 3 stores, 33%).
Q - Ext Avg Cost: This the SKU's quantity on hand or QOH (column G) multiplied by its Average Cost (column K). You can format this column as currency in Excel for better readability. Your list is sorted by this column in descending order to show the most impactful SKUs first.
R - Last Physical: This is the last date the SKU was counted. These SKUs appear as a XX (double X) count type in your monthly Mango Count Sheets. As your store processes its Count Sheets, the physical existence of these SKUs in your store.
S - Collection: indicates if this SKU is part of a collection of SKUs like numbered drill bits, sockets, O-rings, etc. These SKUs may be part of a fixed assortment and therefore may not be good closeout candidates. You can filter on this column to exclude these SKUs.
U - Store Closeout: indicates if the SKU's Store Closeout flag has been set.
V - Discontinued: indicates if the SKU has been discontinued by the warehouse.
W - Promo: shows the SKU's current promotional price.
X- Date Reported: the first time the SKU was reported on the Obsolete list.
Y - Dept: the SKU's department as indicated in your Eagle system.
Z - Eligible: indicates if the SKU is eligible to in the Closeout Management system. Quickly removes ICM, Discovery, Collection, and SKU already in your closeout promotion file.
AB - Injected: indicates if the SKU is a true Obsolete No = no sale, purchase in over two years, or YES = manually injected by entering MDR in a SKU's Location 2 code and setting its Store Closeout flag to Y.
AC - In Season Next Month: lets you know if a SKU is coming into season next month. For example. In October's report, you will see Christmas as "Yes" so you initiate closeout in October (set Loc2 = MDR and Store Closeout = Y) so that the SKU can start its markdown sequence in November.
ICM Section: you can use the ICM columns below to make sure an Obsolete SKU's closeout process does not activate a re-order of a similar SKU (if desired).
AD- ICM SKU: indicates if the SKU has a pending ICM (inventory change management) that may order once the Obsolete SKU sells.
AE - ICM Store Closeout: shows the pending ICM's Store Closeout flag in your Eagle system.
AF - ICM QOH: shows the current quantity-on-hand (QOH) of the pending ICM SKU.
AG- Mfg Vendor Number: shows the manufacturer vendor number and description for the SKU.
AH - Transfer Stores: (multi-store) shows other stores that might be able to take the SKU. The transfer to stores needs to have 12-month sales history and be able to sell through its inventory and the additional transferred inventory in at least two years.
-
-
2 important columns
-
G - Chain Carried %: the percentage of stores carrying the SKU (i.e. 3 of 4 stores carry this SKU, 75%)
-
H - Chain Obsolete %: the percentage of obsolescence in stores carrying the SKU (i.e. SKU obsolete in 1 of 3 stores, 33%)
Using this list for Closeout Management:
If you would like Mango to manage the markdown for these SKU then:- Execute the SKUs from the Closeout Management grid on RAD (Acenet) first.
- For additional SKUs set Eligible (Column Z) = Y
- Set In COM list (Column AA) = N
- Set In Season Next Month (Column AC) = Y
- This is a list of relevant SKUs to add to Closeout Management beyond the COM tab list.
- Follow the steps in Closeout Management -> Identify to add these SKUs.
More information:
Closeout Management-
E - Loc 2: listed if a SKU has a location listed under Location 2 in the Stock & Sell tab of the Products Menu.
F - Discovery: Indicates if the SKU is in a Discovery Assortment. Many stores choose not to close these SKUs out in case a discovery level reset would require a repurchase.
G - Chain Carried %: the percentage of stores carrying the SKU (i.e. 3 of 4 stores carry this SKU, 75%).
H - Chain Obsolete %: the percentage of obsolescence in stores carrying the SKU (i.e. SKU obsolete in 1 of 3 stores, 33%).
Q - Ext Avg Cost: This the SKU's quantity on hand or QOH (column G) multiplied by its Average Cost (column K). You can format this column as currency in Excel for better readability. Your list is sorted by this column in descending order to show the most impactful SKUs first.
R - Last Physical: This is the last date the SKU was counted. These SKUs appear as a XX (double X) count type in your monthly Mango Count Sheets. As your store processes its Count Sheets, the physical existence of these SKUs in your store.
S - Collection: indicates if this SKU is part of a collection of SKUs like numbered drill bits, sockets, O-rings, etc. These SKUs may be part of a fixed assortment and therefore may not be good closeout candidates. You can filter on this column to exclude these SKUs.
U - Store Closeout: indicates if the SKU's Store Closeout flag has been set.
V - Discontinued: indicates if the SKU has been discontinued by the warehouse.
W - Promo: shows the SKU's current promotional price.
X- Date Reported: the first time the SKU was reported on the Obsolete list.
Y - Dept: the SKU's department as indicated in Propello.
Z - Eligible: indicates if the SKU is eligible to in the Closeout Management system. Quickly removes ICM, Discovery, Collection, and SKU already in your closeout promotion file.
AB - Injected: indicates if the SKU is a true Obsolete No = no sale, purchase in over two years, or YES = manually injected by setting the Mango Closeout indicator = Include in COM and setting its Store Closeout flag to Yes.
AC - In Season Next Month: lets you know if a SKU is coming into season next month. For example. In October's report, you will see Christmas as "Yes" so you initiate closeout in October (set Mango Closeout indicator = Include in COM and Store Closeout = Yes) so that the SKU can start its markdown sequence in November.
ICM Section: you can use the ICM columns below to make sure an Obsolete SKU's closeout process does not activate a re-order of a similar SKU (if desired).
AD- ICM SKU: indicates if the SKU has a pending ICM (inventory change management) that may order once the Obsolete SKU sells.
AE - ICM Store Closeout: shows the pending ICM's Store Closeout flag in Propello.
AF - ICM QOH: shows the current quantity-on-hand (QOH) of the pending ICM SKU.
AG- Mfg Vendor Number: shows the manufacturer vendor number and description for the SKU.
AH - Transfer Stores: (multi-store) shows other stores that might be able to take the SKU. The transfer to stores needs to have 12-month sales history and be able to sell through its inventory and the additional transferred inventory in at least two years.
-