Range, stores and the chain format
From the budget, width and price tiers to store format, rent, the fate of a store and a pilot.
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. - Opening stock: stock-to-sales and the monthly buying budget
Sets the planned opening stock of each month as a multiple of planned sales (the stock-to-sales ratio) and then calculates the month’s buying budget: sales plus markdowns plus closing stock minus opening stock minus what is already on order. Catches months where the buy turns negative. - 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. - Width and depth: budget, models and pieces
Turns a buying budget into a number of models (width) and pieces per model and per size-by-color cell (depth). Shows how many models the budget can carry at a minimum depth, what stock will be left at the end of the season and how many weeks of sales sit in stock. - Price tiers: good, better, best
Calculates the average price and unit margin for a split of sales across tiers and shows the effect of shifting part of sales one tier up. Checks whether the step between tiers is noticeable to a customer. - Product classifier check
Shows how fully the required attributes of a product table (group, category, season, size, color, fibre content) are filled, how many duplicates there are and which attributes fall below your target. Without a single classification, analytics does not add up. - Store economics
From traffic and conversion to store profit: revenue, break-even, rent share and payback of the investment. - Store format: flagship, corner, pop-up, outlet
Puts store formats on one scale: monthly contribution, payback, profit over the life of the store and return per unit of money invested. A short-lived pop-up and a five-year flagship are compared by the same rule. - Rent: fixed rate or a percentage of turnover
Compares two ways of paying for a store: a fixed rent and a percentage of turnover with a guaranteed minimum. Finds the turnover at which the payments are equal and the store’s break-even turnover under each option. - Close the store or keep it
A store that loses money on the report may still cover shared costs. The calculation compares the store’s contribution up to the end of the lease with closing it: exit costs and the margin on sales that stay in the network (the website and neighboring stores). - Chain pilot: the effect against control stores
Checks that a new display, seller uniform or price gave an effect rather than the season: compares the change in sales in pilot stores with the change in control stores. Shows the effect in percent, an interval from the spread across stores and the profit of the pilot. - DuPont: return on equity through three levers
Splits return on equity (ROE) into three factors: net profit margin, asset turnover and financial leverage. Compares two periods and shows which lever added or took away points of ROE.
Documents for this route
- Store, channel and marketplace P&L
- Formats by economics: haute couture, luxury, bridge, mass market, off-price, flash sales, travel retail and live shopping
- Property and network: geomarketing, lease structure, formats, pop-ups
- ABC-XYZ and Pareto: calculation, thresholds, link to safety stock and the range
- Assortment matrix and assortment plan
- Sales formats: offline, online and secondary channels
- Investment case: opening a store, a line, IT (NPV, IRR, payback)
- Store KPI pack: traffic, conversion, ticket, revenue per m², payroll and shrinkage