To calculate store profitability, divide the store's profit for a period by its revenue for the same period and multiply by 100%. This is the store profit margin formula. But before you compare stores, agree on which profit you use: gross profit, store operating profit before head-office costs, or the result after those costs are allocated.
If one store's report includes only rent and payroll, and another's also includes the warehouse, accounting and an area manager, you cannot compare the percentages. The formula is the same. What goes into it is not.
Which profit to use in the formula
For a chain's management report, we define three levels. The content of each level must be the same in every store.
| Level | What we count | Question it answers |
|---|---|---|
| Gross profit | Revenue minus cost of goods sold | How much is left from sales to cover other costs |
| Store operating profit before head-office costs | Gross profit minus the store's direct operating costs | How much the store contributes toward head-office costs |
| Store result after head-office cost allocation | Store operating profit minus the share of head-office costs allocated to the store | What result is left after head-office costs are taken into account |
Here, store operating profit means profit after the store's direct operating costs and before head-office costs are allocated. Head-office costs include, for example, the work of the central management team, accounting and the HR department. Show shared warehouse and delivery costs as separate lines. Do not put them into head-office costs automatically.
The result after head-office allocation is not necessarily net profit. If it does not yet include interest, income tax or other items, say so in the report. This article covers a management comparison of stores. It gives no universal rule for the statutory financial reporting of any country.
You can calculate a share of revenue for each level. For example: store operating profit before head-office costs / revenue × 100%. Label the measure in full. The single word "profitability" in a column header is not enough.
If revenue is zero, this ratio cannot be calculated. In the report, note the reason instead of showing 0%. Return on invested capital and payback period answer different questions. They use a different base.
What data to collect for the month
Take revenue after returns and discounts, cost of goods sold, the stores' direct operating costs, head-office costs and the other shared costs of the chain. Accrued costs and revenue must belong to the same period. Do not compare a month of sales with payments to suppliers that include inventory for the next month.
In its official summary of IAS 2, the IFRS Foundation explains the principle. The cost of inventory sold becomes an expense in the period when the related revenue is recognized. Buying goods that are still in the warehouse is not the same as the cost of goods sold.
For each store you usually need to check rent, utilities, payroll with the related charges, card payment fees, local advertising, consumables and equipment maintenance. The list depends on the business. Shrink and write-offs must also appear in the report, but only once. If they are already included in a line you use, do not subtract them again.
Choose one way to treat indirect taxes (VAT or sales tax). Put revenue and costs on the same basis. For a specific tax regime, a finance specialist should confirm what the report includes. Mark costs that are not yet in the data as incomplete.
Keep a separate payment schedule (cash flow forecast). Positive profit does not mean there is enough cash for the next supplier payment. The article on the cash gap in a store chain (in Russian) covers this question.
Example: higher revenue, lower result
The figures below are in illustrative currency units. This is a teaching calculation for two stores, not data from a real chain.
| Monthly figure | Store A | Store B |
|---|---|---|
| Revenue | 1,000 | 1,600 |
| Cost of goods sold | 700 | 1,280 |
| Gross profit | 300 | 320 |
| Direct operating costs of the store | 220 | 280 |
| Store operating profit before head-office costs | 80 | 40 |
| Store operating margin before head-office costs | 8% | 2.5% |
Store B has higher revenue and slightly more gross profit, but after direct costs it keeps half as much. In this example, start by looking at the mix of products sold and the cost lines. Revenue alone does not show the cause.
Suppose head-office costs are 156 units. There are no other shared costs in this example. To keep it simple, allocate head-office costs in proportion to revenue: 60 goes to store A and 96 to store B. The result after head-office allocation is 20 for store A and minus 56 for store B. The chain total is 20 minus 56, which is minus 36.
This is not a new loss at store B. Head-office costs existed before the allocation. We only assigned shares of them to the stores, so that head-office costs are visible in the report too.
How to allocate head-office costs
Allocating head-office costs in proportion to revenue is convenient, but it does not always explain the workload. For example, stores with the same revenue can need different amounts of work from the central team.
Where you have the data, link head-office costs to their cause. For example, link the HR department's work to the number of store employees. For other shared costs, choose other bases: link delivery to trips or volume, and warehouse handling to operations. Where there is no such link, choose a clear allocation rule and write it down. Compare months using one allocation rule. If the rule changes, mark it in the report.
Show both store operating profit before head-office costs and the result after allocation. If the chain has other shared costs, show them as separate lines too. The results of all stores, after all costs are allocated, must add up to the chain's result. If they do not, look for a line that was missed or assigned twice.
Should you close a store that shows a loss?
Back to store B. Its operating profit before head-office costs is 40 units. After head-office costs are allocated, its result is minus 56. The decision to close depends on which costs will really disappear and what happens to sales.
Suppose that after closing, all of B's revenue, the cost of its goods sold and all its direct costs disappear. The head-office costs of 156 units stay. Then the chain has only A's result: 80 minus 156, which is minus 76. Before the closure it was minus 36. Under these conditions, closing the store makes the monthly result worse by 40.
This is a simplified scenario. A real decision must count these items separately: ending the lease, moving or selling off the inventory, payments to employees, customers who may move to a nearby store, and the change in head-office workload. Not every direct cost disappears at once, and one-off costs must not be left out of the calculation.
Make two forecasts for the same period: keep the store open with specific changes, or close it. In both, state your assumptions and the costs that will remain. A negative number in the column is a reason to do this calculation. It does not replace it.
What to compare store profitability with
Start with earlier comparable periods of the same store and with similar stores in your own chain. Take into account format, the store's life stage and season, and use the same cost method for all of them. A new store with start-up costs and a long-established store need different explanations of their results.
A percentage in the public report of a large company may cover the whole group and include a different mix of income and costs. Without those details, it is not a benchmark for your store. A high percentage on a small profit also does not tell you whether the result is enough for the chain's obligations and plans.
For the next closed month, one check is useful. Collect the same lines for all stores. Show store operating profit before head-office costs and the result after allocation, and reconcile the total with the chain result. Then pick the store with the largest deviation and assign an action with a review date. This way the profitability calculation leads to a decision you can check in the next report.