Syntha Lab RU

The ramp-up curve of a new store

From the shares of mature sales in the first months of a new store it fits the curve s(t) = 1 − (1 − s₀) × e^(−t/τ): the starting share s₀ and the speed of reaching maturity τ. It shows the month of reaching 90% of mature sales, the break-even month and the monthly forecast with the cumulative result and the payback of investment for a new point based on mature analogs.

Store format, rent and the fate of a store For whom: Network development directors.

Calculate on your data →

At a glance

What question does it answer?
When a new store reaches mature sales and break-even.
What data is needed?
Shares of mature sales for the first months.
How to read the result?
The break-even month matters more than the 90% month; check the fit error. Example on the default values: Starting share s₀: 0.43; Ramp speed τ: 2.2 months; Month of reaching 90% of mature sales: 4.8 months; Break-even month: 3.4 months. The figures are illustrative: enter your own to see your result.

Why and how to reason

A new store does not start at mature sales. The curve over the first seven months gives a starting share of 0.43 and a ramp speed of 2.20 months; 90% is reached in month 4.8. This turns “the store will pay back in a year” into a calendar of months.

When to use it

When planning openings and evaluating pilots.

How to read the result

The break-even month and the fit error; compare the lag behind the curve over the first three months.

Common mistakes

An opening in a low season without subtracting seasonality, rent holidays outside costs, a distant forecast from three points.

What data is needed?

  • Shares of mature sales for the first months.
  • Mature analog sales, margin, costs, investment.

Inputs

FieldUnitValue in the exampleMeaning
Mature sales per month₽8,000,000Revenue excl. VAT per month at a mature analog of the same format and season. The example value is illustrative.
Margin%40Gross margin of revenue excl. VAT by the definition of the metric passport. The example value is illustrative.
Store costs per month₽2,600,000Fixed costs: rent, staff, utilities. In the first months rent holidays lower them: take the average. The example value is illustrative.
Investment into the opening₽12,000,000Fit-out, equipment, the first stock, the deposit. Empty or 0: the payback of the investment is not counted. The example value is illustrative.
Forecast horizonmonths12How many months to show in the forecast and the totals. The example value is illustrative.

How it is calculated

StepFormula
Curves(t) = 1 − (1 − s₀) × e^(−t/τ), t = month − 1
Fita search over s₀ and τ on a grid, the minimum of the sum of squared deviations
Month of reaching share s1 + τ × ln((1 − s₀) ÷ (1 − s))
Break-eventhe required share s* = costs ÷ (mature sales × margin) = 81.3%
Monthly forecastsales = s(t) × mature sales; profit = sales × margin − costs

Worked numbers

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

Starting share s₀
0.43The share of mature sales in the first full month by the curve.
Ramp speed τ
2.2 monthsIn τ months the missing share to maturity falls by e ≈ 2.7 times.
Month of reaching 90% of mature sales
4.8 months
Break-even month
3.4 monthsWhen the store contribution covers its costs.
Fit error
2.2 %Root mean square deviation of the curve from your points, p.p. of the share of mature sales.
Result over the horizon
2.23 m ₽The sum of store profit over the forecast months without the opening investment.
Contribution lost to the ramp-up
4.97 m ₽What the store did not give against a mature one over the horizon.
Payback month of the investment
does not pay back within the horizon
Your points and the curve, % of mature sales
Line chart: Actual: 45 → 100; Curve: 43 → 96.34050607080901001234567Actual, 1: 45Actual, 2: 62Actual, 3: 75Actual, 4: 85Actual, 5: 92Actual, 6: 97Actual, 7: 100Curve, 1: 43Curve, 2: 63.8Curve, 3: 77Curve, 4: 85.4Curve, 5: 90.7Curve, 6: 94.1Curve, 7: 96.3
  • Actual
  • Curve
Data as a table
MeasureActualCurve
14543
26263.8
37577
48585.4
59290.7
69794.1
710096.3
Cumulative result of the new point, m RUB
Line chart: Cumulative total with the investment: −13.2 → −9.8−14−13−12−11−10−9123456789101112Cumulative total with the investment, 1: −13.2Cumulative total with the investment, 2: −13.8Cumulative total with the investment, 3: −13.9Cumulative total with the investment, 4: −13.8Cumulative total with the investment, 5: −13.5Cumulative total with the investment, 6: −13.1Cumulative total with the investment, 7: −12.6Cumulative total with the investment, 8: −12.1Cumulative total with the investment, 9: −11.5Cumulative total with the investment, 10: −10.9Cumulative total with the investment, 11: −10.4Cumulative total with the investment, 12: −9.8
Data as a table
MeasureCumulative total with the investment
1−13.2
2−13.8
3−13.9
4−13.8
5−13.5
6−13.1
7−12.6
8−12.1
9−11.5
10−10.9
11−10.4
12−9.8

Forecast of the new point by the curve

MonthShare of mature salesSalesContributionProfitCumulative total
143 %3.44 m ₽1.38 m ₽−1.22 m ₽−13.2 m ₽
264 %5.11 m ₽2.04 m ₽−557,759 ₽−13.8 m ₽
377 %6.16 m ₽2.47 m ₽−134,872 ₽−13.9 m ₽
485 %6.83 m ₽2.73 m ₽133,550 ₽−13.8 m ₽
591 %7.26 m ₽2.9 m ₽303,927 ₽−13.5 m ₽
694 %7.53 m ₽3.01 m ₽412,072 ₽−13.1 m ₽
796 %7.7 m ₽3.08 m ₽480,715 ₽−12.6 m ₽
898 %7.81 m ₽3.12 m ₽524,286 ₽−12.1 m ₽
998 %7.88 m ₽3.15 m ₽551,941 ₽−11.5 m ₽
1099 %7.92 m ₽3.17 m ₽569,495 ₽−10.9 m ₽
1199 %7.95 m ₽3.18 m ₽580,638 ₽−10.4 m ₽
12100 %7.97 m ₽3.19 m ₽587,710 ₽−9.77 m ₽

What to do with the result: put into the plan of a new store the curve and not the mature revenue; compare the lag behind the curve over the first three months to see a failed point early.

A typical mistake: opening in a low season and counting the ramp by the curve of a high one without subtracting seasonality; ignoring rent holidays in the costs of the first months. The fit runs on a grid (step 0.01 for s₀ and 0.05 months for τ), the month number minus one gives t.

Nuances and limits

  • Opening in a low season without subtracting seasonality.
  • Ignoring rent holidays.
  • Trusting distant months from three points.

Terms used

Calculate on your data →