Bring sell-through data together per item
Contribution margin list, household category, 1,240 item numbers, 12 months
Trade
Every category manager calculates the contribution margin differently.Open agent
Enlarge demo
Developed in Germany · Hosted in the EU or on-premises
Delivered together with
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,240
item numbers
That is how many lines the merchandise management system holds in the household category.
3
data sources
Sell-through, purchase terms and stock come from three separate extracts.
4 days
building the spreadsheet
That is how long it takes to factor in markdowns and advertising allowances for each item.
38
delisting candidates
That 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.
The agent brings together sell-through, margin and stock cover for each item; category management decides which items stay listed.
Contribution margin list, household category, 1,240 item numbers, 12 months
47 items with no sales for 26 weeks, 9 of them with a seasonal pattern
sortimentsvorschlag_haushalt_kw34.xlsx, 38 delisting and 22 reorder candidates
It presents the candidates with contribution margin and stock cover. The category head signs off the delisting, and master data management books it.
A key item can stay on the shelf despite a weak margin because customers expect to find it there. Category management makes that call in the assortment review.
The new terms for the household category only apply once they are booked in the ERP. Until then it shows the old value and flags it; category management recalculates once the deal is closed.
Connected systems
Merchandise management
retail ERP
BI reporting
Operations
Deployment model
Data processing
Responsible teams
How quickly is the Assortment Analysis Agent ready to use?
Where is the data processed?
Where does the figure “5 to 15% higher margin” come from?
All agents
3 to 8%
revenue growth
Management, category management
20%
less excess stock
Logistics, purchasing
60%
less preparation time
Executive board, management
60%
less reporting effort
Branch Management, Management
20%
less planning effort
HR department, store management
25%
higher campaign performance
Marketing, e-commerce