Store: sales, pace and receipts
From splitting sales into factors to the receipt structure and the share of discounts.
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. - Store economics
From traffic and conversion to store profit: revenue, break-even, rent share and payback of the investment. - Sales equation: traffic, conversion, units per receipt, price per unit
Splits the change in a store’s sales between two periods into four causes: how many people entered, what share bought, how many units per receipt and the price per unit. Sales = traffic × conversion × units per receipt (UPT) × price per unit (AUR). Shows what exactly pulls sales up or down. - Plan versus actual by store: pace, period forecast, required daily pace
Compares the actual to date with the plan for the whole period and with the pace-plan for the same number of days, forecasts the end of the period at the current pace and calculates how much must be sold a day to reach the plan. Shows which stores lag behind the pace and by how much. - Receipt structure: ticket bands, average ticket, UPT and contribution to sales
Splits receipts into amount bands: how many receipts and what share of sales fall into each, the average ticket, units per receipt and the price per unit. Shows which receipts the revenue rests on and where the median receipt lies. - Discounted receipts: share, depth and the ticket with a discount versus full price
Shows what share of receipts goes with a discount, the average depth of the discount in those receipts, how discounts eat into the list price and how a discounted receipt differs from a full-price one, including at list price. Helps see which purchases the discounts rest on.
Documents for this route
- Store KPI pack: traffic, conversion, ticket, revenue per m², payroll and shrinkage
- Loss prevention: shrinkage, counting, fraud
- Plan versus actual and profit factor analysis (bridge)
- Merchandise stock balance
- Excel for retail, part I: lookup by key, pivot tables and data validation
- Management balance sheet
- Business plan of a brand and a retailer: sections, assumptions, presenting to an investor and a bank
- Capital: WACC, ROIC, dividends and reinvestment