Syntha Lab RU

Sales plan by store

Splits the chain’s revenue plan across stores: growth of existing stores, new stores ramping up, closures and partial years. Shows the total against last year and against the target.

Forecast and budget For whom: Chain directors, commercial and finance directors of retailers.

Calculate on your data →

At a glance

What question does it answer?
What revenue plan per store gives the required chain plan and how much it relies on new stores.
What data is needed?
Each existing store’s revenue for last year (annual).
How to read the result?
First look at the total against last year, then at the share of new stores: the higher it is the riskier the plan. The gap to the target shows how much must be added by growth, new stores or range. Take the annual sums per store to the “Annual budget” for a split by month. Example on the default values: Growth of existing stores of 6% and one new store: the chain plan is RUB 132,645,000, 13.4% above the existing stores’ revenue of last year. The new store’s share is 11.0% and the largest store holds 33.6% of the plan. If one store’s share is too large, discuss the concentration risk. Next: enter the annual total into “Annual budget by month” and check “Store comparison across the chain”.

Why and how to reason

A network plan is built by store, because each has its own history. An existing store: last year’s revenue x (1 + growth) x share of the year. A closing one: negative growth and fewer than 12 months of operation. A new store does not start at the mature level: it reaches it gradually, so revenue = mature revenue x ramp-up x months / 12.

Thus three effects add up: growth of what exists, loss of closed points and contribution of new ones. It is convenient to see them separately because reliability differs: growth of existing stores is the most predictable part, a new store the least.

Example. Central 42 x 1.06 = RUB 44.52 m; South closes in September: 18 x 0.9 x 9 / 12 = 12.15; the new store: 30 x 0.65 x 9 / 12 = RUB 14.63 m. The network total is RUB 132.6 m, 13.4% above last year’s existing stores, with a new-store share of 11%.

When to use it

Use it when drawing up the annual plan, especially when the network changes: openings, closures, refurbishments. Assumption: growth is equal unless set individually, and you estimate the new store’s maturity cautiously. It does not account for seasonality within the year, for which use the annual budget by month. For new points draw on data from similar stores. Revise the plan when opening dates change.

How to read the result

Look at where the growth comes from: if the planned increase of 13% rests on the new store (11% of the plan), the risk is higher than with growth of existing stores. Compare with the target: if the plan does not reach it, additional points or revenue growth are needed. The largest store at 33.6% of the plan shows dependence. Decision: check how realistic the new store’s ramp-up is and prepare a fallback scenario in case it starts slower. Break the plan out by month if new stores ramp unevenly, and add a scenario without the new store. You will then see how much the target depends on one decision.

Common mistakes

The usual mistakes: giving a new store mature revenue from the first month; forgetting that a closing store passes part of its sales to neighbors; not including price growth in revenue growth. Also: counting operating months without allowing for refurbishment. Also: treating the ramp-up as linear under strong seasonality.

What data is needed?

  • Each existing store’s revenue for last year (annual).
  • Chain growth and, where available, a store’s own growth; months open in the plan year.
  • For a new store: mature store revenue and the share reached in the first year.
  • Optional: the chain revenue target.
  • Where to take it: last year’s store revenue from the sales report by outlet in 1C or the ERP; growth from the price and traffic plan; months of operation from the opening and closing schedule; for a new store the mature analog’s revenue and its first-year ramp share. The chain goal is optional.

Inputs

FieldUnitValue in the exampleMeaning
Growth of existing stores% versus last year6Applied to stores with no growth of their own.
Chain revenue target (optional)₽0If a target is set you will see the gap between the sum of store plans and the target. Optional. Empty: the field is ignored (counted as zero in sums).

How it is calculated

StepFormula
Existing storeLast year’s revenue × (1 + growth) × months ÷ 12
New storeMature revenue × maturity reached × months ÷ 12

Worked numbers

Default values from the app; in the interactive version you enter your own.

Chain revenue plan
132.6 m ₽
Versus last year of existing stores
13.4 %Includes new stores and closures.
New stores in the plan
11 % · 1The higher the share of new stores the riskier the plan: they often ramp up slower.
Largest store
33.6 % · Central mall

Plan by store

StoreLast yearPlanShare
Central mall42 m ₽44.5 m ₽34 %
North mall31 m ₽33.8 m ₽25 %
High street26 m ₽27.6 m ₽21 %
South mall (closing in September)18 m ₽12.2 m ₽9 %
New store (opening in April)—14.6 m ₽11 %

For seasonality by month use the “Annual budget”: this model gives the annual sum per store that can be entered there as revenue.

Nuances and limits

  • Do not compare a new store with a mature one: in its first year it usually reaches only part of mature revenue.
  • Reduce a closing store by months open, not only by growth.

Terms used

Calculate on your data →