Season and brand through the retailer’s eyes
The season matrix, new and carried-over goods, then the brand’s place at the retailer.
Route steps
- Quick business check: two periods
From basic figures of two periods calculates gross margin, operating profitability, turnover, days of inventory, receivables and payables, the cash cycle, the share of returns and old stock and shows which way each moved. - Average stock for the year and turnover
Calculates average stock from monthly balances, turnover and days of inventory and shows how far a one-date balance distorts the picture in a seasonal business. - Season sell-through pace and leftover risk
From sales so far shows the sold share, stock in weeks, the forecast leftover at season end and the pace needed to reach the target. - Season matrix: product season × sales month and stock against the window
From 12 months of sales in four groups (SS, AW, leftovers of past seasons, core) calculates the share of seasonal goods and leftovers by month and calendar season, how much of its sales each season makes inside its own window and whether the window is enough to sell the stock. - New and carryover: share, return per SKU, sell-through and margin
Compares groups of SKUs of a season, for example new items, carryover (carried over from past seasons) and basics: the share in the range and in sales, sales per SKU, sell-through and margin. Shows which group gives a return above its share in the range. - ABC analysis of the range
Splits styles or groups into A, B and C by contribution to revenue or margin: what feeds the business, the middle, and what can be cut. - A brand inside a multi-brand retailer: share of space and sales, margin and a decision
For brands inside one retailer calculates the share of sales and the share of space, margin including markdown support, sell-through, turnover and GMROI and suggests a decision: expand, keep or cut the brand; gives a space guide by margin share.
Documents for this route
- Management report pack
- Accessories: bags, leather goods, belts, headwear, scarves, jewelry
- Retail math by segment: IMU, MMU, markdowns, sell-through, GMROI, turnover
- Merchandise stock balance
- Trends and the range forecast: from a signal to the trend share in the matrix, the life window, the test batch and the chase order
- Stock turnover and dead stock
- Excel for retail, part I: lookup by key, pivot tables and data validation
- ABC-XYZ and Pareto: calculation, thresholds, link to safety stock and the range