Syntha Lab RU

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.

For retail

Open interactively →

Route steps

  1. 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.
  2. 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.
  3. 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.
  4. 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.
  5. 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.
  6. 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.
  7. 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.
  8. Store economics
    From traffic and conversion to store profit: revenue, break-even, rent share and payback of the investment.
  9. 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.
  10. 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.
  11. 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).
  12. 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.
  13. 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

Other routes for this audience