Syntha Lab RU

Sales plan by store

One row per store and month: area, traffic, conversion, average ticket, planned revenue and growth over last year.

Layouts for documents 10 columns 4 example rows

Download CSV ↓

What the template is for

Splitting the chain plan by store and checking feasibility on traffic and conversion.

What one row is
one row = store × month

Columns

ColumnCodeTypeRequiredValidation rule
MonthmonthTextyesmonth as YYYY-MM
Store codestoreTextyesa value from the customer and point reference
FormatformatList valueyesmall, street, outlet or shop-in-shop
Sales area, m²areaNumberyesa number not below 0
Traffic, visitorstrafficIntegeryesan integer not below 0
Conversion, %convNumberyesfrom 0 to 100
Average ticket excl. VATticketNumberyesa number not below 0
Planned revenue excl. VATrevenueNumberyescalculated: traffic × conversion ÷ 100 × average ticket
Last year revenue excl. VATlyNumberyesa number not below 0
Growth over last year, %growthNumberyescalculated: (plan ÷ last year − 1) × 100

Example rows

MonthStore codeFormatSales area, m²Traffic, visitorsConversion, %Average ticket excl. VATPlanned revenue excl. VATLast year revenue excl. VATGrowth over last year, %
2027-02ST01mall32024,0007.53,9007,020,0006,350,00010.6
2027-02ST02street18015,50094,3005,998,5005,800,0003.4
2027-03ST01mall32027,50084,0008,800,0008,300,0006
2027-03ST02street18017,0009.54,4007,106,0006,900,0003

The example data is illustrative: an exercise, replace it with your own.

Note

If growth comes only from conversion above its history, flag the store for review: traffic is usually planned more conservatively. For new stores fill the last-year column with an analog actual. The example data is illustrative: an exercise, not a norm or an industry benchmark.

How to open the file

The file is UTF-8 with a BOM, comma separated, with a decimal point. Set the text format for code columns (SKU, article, GTIN) so that long numbers and leading zeros are not distorted. The validation rules are suggested defaults, not norms: your systems and contracts may require something else.

Calculations that use these fields

Documents that need this data

Download CSV ↓ Open interactively →