KPIs for multi-outlet retail: the six numbers to track

A handful of numbers, not fifty

A KPI, short for key performance indicator, is a number you check regularly to see whether the business is on track. Most systems can give you dozens of them. If you run several shops, the useful KPIs for multi-outlet retail fit on one short list, and you can read that list for every outlet in a few minutes.

This post gives six of them: three about sales and three about profit and stock. For each one you get the formula, what it tells you, and whether to compare it between outlets or only with the outlet's own past.

The last part matters more than it sounds. Some numbers are fair to line up across outlets. Others will mislead you if you do.

The sales side: three KPIs

1. Sales against last year. Take this month's sales, subtract the same month last year, and divide by last year. This tells you whether the outlet is growing. Comparing with last year, rather than last month, takes care of most of the seasonal ups and downs.

2. Bills. This is the number of transactions, or receipts, rung up. It is the closest thing most shops have to a count of customers. Count bills, not people, and leave voided bills out.

3. Average bill. Sales divided by the number of bills. It tells you how much each customer spends per visit. Sales always equals bills times average bill, so these two numbers explain almost every movement in sales: either more people came, or each one spent more.

The profit and stock side: three more

4. Gross margin. Sales minus the cost of the goods you sold, divided by sales. It tells you how much of each ringgit you keep after paying for the goods. Sales can rise while gross margin falls, and then the extra sales may be worth very little.

5. Discount share. The ringgit value of discounts given, divided by sales before discount. It shows how much of the outlet's selling is being bought with price cuts. Keep an eye on voids and refunds next to it: a void is a sale cancelled before payment, a refund is money given back after. Neither should grow quietly.

6. Days of stock. Stock on hand at cost, divided by the cost of goods sold per day. It tells you how many days the outlet could keep selling from what is already on its shelves. More days means more cash sitting as stock.

Use one fixed rule for each of these, the same at every outlet and every month. If one outlet counts sales before tax and another after, the comparison is broken before it starts.

Which to compare between outlets

Sales and bills depend heavily on how big the outlet is, how many days it opened and where it sits. A large mall shop will nearly always beat a small neighbourhood one on both. So compare these two mainly with each outlet's own history: this month against the same month last year, this week against the same week last year.

Average bill, gross margin, discount share and days of stock are ratios, one number divided by another. They do not grow just because the outlet is bigger, so they are fair to line up side by side. An outlet whose margin or discount share is well away from the others is the one to look at first.

Even with ratios, compare like with like where you can. Outlets with a different product mix, such as one that sells far more of a low-margin category, will show a different margin for a good reason.

A made-up example: two outlets, one month

Here is a made-up example for a 30-day month.

Outlet A sold RM 90,000 from 3,000 bills, so the average bill is RM 30.00. Last year in the same month it sold RM 84,000, so it is up RM 6,000, which is 7.1% (rounded to 1 decimal). The goods it sold cost RM 58,500, so gross profit is RM 31,500 and gross margin is 35.0%. Before discount its sales would have been RM 93,750; it gave RM 3,750 in discounts, a discount share of 4.0%. It holds RM 39,000 of stock at cost. Cost of goods per day is RM 58,500 / 30 = RM 1,950, so it has 20 days of stock.

Outlet B sold RM 72,000 from 3,000 bills, so the average bill is RM 24.00. Last year it sold RM 75,000, so it is down RM 3,000, which is 4.0%. The goods it sold cost RM 54,000, so gross profit is RM 18,000 and gross margin is 25.0%. Before discount its sales would have been RM 80,000; it gave RM 8,000 in discounts, a discount share of 10.0%. It holds RM 72,000 of stock at cost. Cost of goods per day is RM 54,000 / 30 = RM 1,800, so it has 40 days of stock.

Reading the six together

Both outlets had exactly 3,000 bills, so Outlet B is not short of customers. The gap is in what each customer spends and what B keeps from it.

B's average bill is RM 6 lower. Its discount share is two and a half times A's, its gross margin is 10 points lower, and it carries twice as many days of stock. Taken together, one likely story is an outlet with too much stock that has been cutting prices to move it, which lowers both the bill and the margin.

That is a story to check, not a verdict. Ask which items carried the discounts, whether the extra stock is in a few slow lines, and whether the manager was told to clear something. One KPI alone would not have told you where to look. Six, read side by side, point to the same place.

Ask it in plain words

This is a question you can ask iSenang, your AI data analyst, in plain words, for example "show average bill, gross margin and discounts by outlet for last month". It shows every outlet side by side, the figures are computed by code from your own data with one fixed formula for each KPI, and when a question is not covered by your data, it says so instead of guessing.