Buying and season control in retail
The plan traffic light, the control week, a reorder and sizes by store cluster.
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. - Merchandise plan traffic light
Compares actuals with the plan on key merchandise-plan metrics and colors each green, amber or red by your thresholds. Shows what to look at first. The default thresholds are neutral (“an example”): there is no single Russian benchmark, set them from your own past seasons and targets. - Control week: full-price sell-through
At the control week of the season, separates what sold at full price from what sold on discount, calculates sell-through from the on-hand stock at the start of the season, compares it with your goal and red line, shows the pace to the season goal and suggests: revisit the price-cut schedule, hold or consider a reorder. - First order and reserve for reorders
Calculates what share of the plan to order at once and how much capacity to keep for a reorder after the first sales. Compares the expected profit, leftover and lost sales of a two-stage order with a single large order. The logic is our own: demand is given by scenarios, early sales remove part of the uncertainty, a reorder costs more and is limited by capacity. - Size curve by store cluster and pack composition
Splits the buy across store clusters and sizes using each cluster’s past sales, picks the composition of a ready pack (prepack) for the cluster’s curve, rounds the buy to whole packs and shows how many pieces end up in the wrong sizes. Compares a pack per cluster with one pack for the whole chain, and picking to order with a ready pack.
Documents for this route
- Open-to-buy budget (OTB)
- Multiple regression of sales: demand drivers, advertising and promo contribution, multicollinearity, lags and model checks
- Descriptive statistics for retail: center, spread, outliers, intervals
- Merchandise stock balance
- AI in fashion analytics and content: what can be computed, limits, risks
- Allocation and replenishment
- Management balance sheet
- Business plan of a brand and a retailer: sections, assumptions, presenting to an investor and a bank