inventory whisperer

demand signals · ABC classification · reorder watchlist · demand projection

total skus
4,907
active skus (60d)
3,140
a-class skus
1,036
total revenue
£20,123,377
total orders
992,134
data source UCI Online Retail II · Dr. Daqing Chen, London South Bank University · Dec 2009 – Dec 2011 · UK gift/homeware retailer · 1,067,371 transactions · also on Kaggle
demand projection actual → projected Jan–Mar 2012 · top 8 A-class SKUs · linear trend extrapolation
reorder watchlist high-velocity A/B-class · last 60d
skudescriptionrecentpriortrend
23843 PAPER CRAFT , LITTLE BIRDIE 80995 0 rising
23084 RABBIT NIGHT LIGHT 25215 2426 rising
22197 POPCORN HOLDER 23710 7327 rising
84077 WORLD WAR 2 GLIDERS ASSTD DESIGNS 13021 6330 rising
22086 PAPER CHAIN KIT 50'S CHRISTMAS 12429 3286 rising
85099B JUMBO BAG RED RETROSPOT 9711 10368 stable
84879 ASSORTED COLOUR BIRD ORNAMENT 8731 6149 rising
22578 WOODEN STAR CHRISTMAS SCANDINAVIAN 8428 1685 rising
22952 60 CAKE CASES VINTAGE CHRISTMAS 8274 4744 rising
20668 DISCO BALL CHRISTMAS DECORATION 8161 819 rising
22577 WOODEN HEART CHRISTMAS SCANDINAVIAN 8160 1850 rising
85123A WHITE HANGING HEART T-LIGHT HOLDER 7228 3946 rising
23344 JUMBO BAG 50'S CHRISTMAS 7070 2592 rising
21915 RED HARMONICA IN BOX 6241 5735 stable
22492 MINI PAINT SET VINTAGE 5935 5431 stable
slow movers A/B-class SKUs with dropping demand
skudescriptionrecentpriortrend
21078 SET/20 STRAWBERRY PAPER NAPKINS 5 390 falling
85231G ORANGE SCENTED SET/9 T-LIGHTS 2 173 falling
22035 VINTAGE CARAVAN GREETING CARD 5 149 falling
22291 SPRING DEC , HANGING CHICK CREAM 2 78 falling
23065 LARGE DECO JEWELLERY STAND 5 66 falling
23066 SMALL DECO JEWELLERY STAND 1 66 falling
85116 BLACK CANDELABRA T-LIGHT HOLDER 5 60 falling
22927 GREEN GIANT GARDEN THERMOMETER 1 40 falling
16046 TEATIME PEN CASE & PENS 5 31 falling
85045 GREEN CHRISTMAS TREE STRING 20LIGHT 4 31 falling