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.
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
| Field | Unit | Value in the example | Meaning |
|---|---|---|---|
| Mature sales per month | ₽ | 8,000,000 | Revenue excl. VAT per month at a mature analog of the same format and season. The example value is illustrative. |
| Margin | % | 40 | Gross margin of revenue excl. VAT by the definition of the metric passport. The example value is illustrative. |
| Store costs per month | ₽ | 2,600,000 | Fixed 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,000 | Fit-out, equipment, the first stock, the deposit. Empty or 0: the payback of the investment is not counted. The example value is illustrative. |
| Forecast horizon | months | 12 | How many months to show in the forecast and the totals. The example value is illustrative. |
How it is calculated
| Step | Formula |
|---|---|
| Curve | s(t) = 1 − (1 − s₀) × e^(−t/τ), t = month − 1 |
| Fit | a search over s₀ and τ on a grid, the minimum of the sum of squared deviations |
| Month of reaching share s | 1 + τ × ln((1 − s₀) ÷ (1 − s)) |
| Break-even | the required share s* = costs ÷ (mature sales × margin) = 81.3% |
| Monthly forecast | sales = 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
- Actual
- Curve
Data as a table
| Measure | Actual | Curve |
|---|---|---|
| 1 | 45 | 43 |
| 2 | 62 | 63.8 |
| 3 | 75 | 77 |
| 4 | 85 | 85.4 |
| 5 | 92 | 90.7 |
| 6 | 97 | 94.1 |
| 7 | 100 | 96.3 |
Data as a table
| Measure | Cumulative 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
| Month | Share of mature sales | Sales | Contribution | Profit | Cumulative total |
|---|---|---|---|---|---|
| 1 | 43 % | 3.44 m ₽ | 1.38 m ₽ | −1.22 m ₽ | −13.2 m ₽ |
| 2 | 64 % | 5.11 m ₽ | 2.04 m ₽ | −557,759 ₽ | −13.8 m ₽ |
| 3 | 77 % | 6.16 m ₽ | 2.47 m ₽ | −134,872 ₽ | −13.9 m ₽ |
| 4 | 85 % | 6.83 m ₽ | 2.73 m ₽ | 133,550 ₽ | −13.8 m ₽ |
| 5 | 91 % | 7.26 m ₽ | 2.9 m ₽ | 303,927 ₽ | −13.5 m ₽ |
| 6 | 94 % | 7.53 m ₽ | 3.01 m ₽ | 412,072 ₽ | −13.1 m ₽ |
| 7 | 96 % | 7.7 m ₽ | 3.08 m ₽ | 480,715 ₽ | −12.6 m ₽ |
| 8 | 98 % | 7.81 m ₽ | 3.12 m ₽ | 524,286 ₽ | −12.1 m ₽ |
| 9 | 98 % | 7.88 m ₽ | 3.15 m ₽ | 551,941 ₽ | −11.5 m ₽ |
| 10 | 99 % | 7.92 m ₽ | 3.17 m ₽ | 569,495 ₽ | −10.9 m ₽ |
| 11 | 99 % | 7.95 m ₽ | 3.18 m ₽ | 580,638 ₽ | −10.4 m ₽ |
| 12 | 100 % | 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.