An assortment review for 1,240 item numbers starts with four days of gathering data.
Sell-through figures sit in the merchandise management system, purchase terms in the ERP, stock per store somewhere else again. For the assortment review, category management pulls three extracts and builds a spreadsheet, adding markdowns and advertising allowances by hand. By the time the spreadsheet is ready, half the season has gone, and in the end it is experience that decides which items are slow sellers.
1,240item numbersThat is how many lines the merchandise management system holds in the household category.
3data sourcesSell-through, purchase terms and stock come from three separate extracts.
4 daysbuilding the spreadsheetThat is how long it takes to factor in markdowns and advertising allowances for each item.
38delisting candidatesThat is how many lines are left to decide on once seasonal items are excluded.
Twelve months of sell-through, margin and stock cover sit side by side for every one of the 1,240 items, and the assortment review works from 38 named candidates rather than a hunch, delivering 5 to 15% higher margin.
The 5 to 15% higher margin is this agent's headline figure. The 1,240 item numbers and the four days spent building the spreadsheet reflect a typical assortment review in one category; neither figure comes from an actual count.