Store comparison across the chain
Puts stores side by side: revenue per m² and per employee, rent share, store profit. Shows which stores carry the chain and which lose money.
At a glance
- What question does it answer?
- Which stores carry the chain and which lose money or are too expensive on rent.
- What data is needed?
- For each store for one month: revenue, area, staff, margin, rent and other costs.
- How to read the result?
- Compare revenue per m², per employee, rent share and profit. A loss-making store is not always closed: first check traffic, conversion and lease terms. Example on the default values: Four stores give RUB 12,547,500 of revenue and RUB 2,234,310 of store profit a month; none loses money. Rent exceeds the 15% threshold in three stores and revenue per m² ranges from RUB 20,507 to RUB 45,600 a month. If a store has rent above your threshold and low revenue per m², decide its fate with a separate calculation. Next: “Store indicators: ticket, conversion, space, staff” and “Close the store or keep it”.
Why and how to reason
Comparing stores by revenue is unfair: a large store always gives more. So we reduce everything to a unit: revenue per m² (space efficiency), revenue per employee (staff efficiency), rent share (burden). And we calculate store profit: revenue x margin - rent - other costs.
Each metric answers its own question. Revenue per m² tells whether the space justifies what you pay for it. Rent share shows how much of each rouble goes to the landlord. Store profit is the outcome.
Example. Central mall: revenue RUB 4.095 m on 120 m² = RUB 34,125 per m²; profit 4.095 x 0.52 - 0.65 - 0.70 = RUB 0.78 m. Outlet: RUB 2.871 m on 140 m² = RUB 20,507 per m², but its margin is 40%, so profit is lower. The best store per m² gives RUB 45,600, the weakest RUB 20,507: a gap of 2.2 times.
When to use it
Use it when reviewing the network, before lease renewals, and when deciding on closure or re-layout. Suitable for stores of comparable format. Do not compare an outlet directly with a boutique: different margin and role. Assumption: a month of data is typical. For seasonal stores compare equal periods. For comparability take stores of one format and region. Take data of equal completeness.
How to read the result
First look at “loss-making” and “rent above threshold”: these are queues for review. In the example there are no loss-makers, but three stores have rent above the allowed 15%. Then look at the cause of lag: low revenue per m² (traffic, assortment) or high rent (contract). Store profit is best compared with investments. Decision: for weak stores check rent negotiation, assortment revision or closure; for strong ones replicate the format. Also check whether the network has stores with good revenue per m² but weak margin from discounts: they look strong only on revenue. Then compare with the previous period.
Common mistakes
Comparing by revenue without accounting for area; leaving utilities and acquiring out of other costs; using different periods for different stores; deciding on closure from one month. Also: ignoring a store’s influence on the region’s online sales. Also: comparing stores opened at different times.
What data is needed?
- For each store for one month: revenue, area, staff, margin, rent and other costs.
- The acceptable rent share of revenue.
- Where to take it: revenue, area, headcount and margin by store from the management report by outlet (1C, ERP); rent from lease contracts and landlord invoices; other costs from accounting by division. Use the same month, or a 3–6 month average, for every store.
Inputs
| Field | Unit | Value in the example | Meaning |
|---|---|---|---|
| Acceptable rent share of revenue | % | 15 | Above this level a store is flagged as risky. 15% is an example; there is no single benchmark in Russia, set the threshold from your leases, format and city. |
How it is calculated
| Step | Formula |
|---|---|
| Store profit | Revenue × margin − rent − other costs |
| Per sqm | Revenue ÷ area |
| Rent share | Rent ÷ revenue |
Worked numbers
Default values from the app; in the interactive version you enter your own.
- Chain revenue per month
- 12.5 m ₽
- Store profit per month
- 2.23 m ₽Before income tax and head-office costs.
- Loss-making stores
- 0 of 4
- Rent above the threshold
- 3
- Best revenue per sqm
- 45,600 ₽ · High street
- Weakest revenue per sqm
- 20,507 ₽ · Outlet
Metrics by store
| Store | Per sqm | Per employee | Rent share | Profit | Margin |
|---|---|---|---|---|---|
| Central mall | 34,125 ₽ | 455,000 ₽ | 16 % | 779,400 ₽ | 19 % |
| High street | 45,600 ₽ | 532,000 ₽ | 15 % | 731,760 ₽ | 23 % |
| Suburban mall | 25,153 ₽ | 398,250 ₽ | 18 % | 254,750 ₽ | 11 % |
| Outlet | 20,507 ₽ | 574,200 ₽ | 10 % | 468,400 ₽ | 16 % |
Rent is above the threshold in: Central mall, High street, Suburban mall.
Nuances and limits
- Data is for one month: smooth seasonal peaks with a multi-month average.
- A new store cannot be compared with a mature one: it takes 6–12 months to reach capacity.
- The rent threshold is yours and depends on the format: it differs for a flagship and an outlet; there is no single norm in Russia.