Grocery chain KPI set
The same KPI serves a different decision in a different role. This set organises grocery indicators by who acts on them, how often and at what threshold; every indicator sits in the KPI Library with its own calculator.
Daily: store manager
Indicators that can be acted on before the day closes: shelf, till and fresh departments.
- Average transaction value (ATV)
Net sales (excl. VAT) ÷ Number of transactions (receipts) - In-stock rate
(Active store-product combinations − Out-of-stock combinations) ÷ Active store-product combinations × 100 - Fresh food shrink rate
(Disposal + Trimming + Weight variance) at cost ÷ Fresh department net sales × 100 - Price label accuracy rate
Compliant label checks ÷ Total label checks × 100 - Cash variance rate
|Expected takings − Counted takings| ÷ Expected takings × 100
Weekly: area manager
Store-to-store comparison and process deviation: sales growth, labour productivity, shrinkage and counts.
- Like-for-like sales growth (LFL)
(Current-period LFL sales − Same period last year LFL sales) ÷ Same period last year LFL sales × 100 - Sales per labour hour (SPLH)
Net sales (excl. VAT) ÷ Total staff hours actually worked - Labour cost ratio
Total labour cost ÷ Net sales × 100 - Shrinkage rate
Shrinkage cost ÷ Net sales × 100 - Stock count variance rate
(|Negative variance| + |Positive variance|) ÷ Value of stock counted × 100
Weekly: category and buying
Margin, promotions, own brands, stock depth and supplier decisions.
- Gross margin
(Net sales − Cost of goods sold) ÷ Net sales × 100 - Promotional uplift
(Promotion-period sales − Baseline sales) ÷ Baseline sales × 100 - Private label share
Own-brand net sales ÷ Total net sales × 100 - Days of inventory
Average inventory at cost ÷ Annual COGS × 365 - OTIF (on time in full)
Lines delivered both on time and in full ÷ Total order lines × 100 - Forecast accuracy (MAPE)
Σ (|Actual − Forecast| ÷ Actual) ÷ n × 100 - Lost sales rate
(Stockout days × Normal daily sales) ÷ (Actual sales + Stockout days × Normal daily sales) × 100
Monthly: senior management and finance
Profitability of the store network, waste and working capital.
- Sales per square metre
Net sales (excl. VAT) ÷ Selling area (m²) - Break-even sales
Monthly fixed costs ÷ (Gross margin − Shrinkage rate − Variable cost rate) - Food waste to sales ratio
Cost value of disposed food ÷ Food net sales × 100 - Days payable outstanding (supplier payment days)
Trade payables balance ÷ Cost of goods sold × Days in period - Inventory turnover
Cost of goods sold (COGS) ÷ Average inventory at cost - Occupancy cost ratio
(Rent + Service charge) ÷ Net sales × 100
How to build a grocery dashboard: owner, frequency and threshold
A KPI dashboard works when every indicator has a single owner, a tracking frequency and a threshold rule. An indicator with no owner sits in everyone's report but lands on nobody's task list. The set is therefore split into four groups by role and frequency: the store manager looks daily, the area manager and category and buying teams weekly, senior management and finance monthly.
Thresholds are kept tight in grocery because margins are thin. BİM reported a 3.0 per cent net margin for the first quarter of 2026 and Migros 1.6 per cent for 2025. In a business running on net margins at that level, a loss of a few tenths of a per cent of sales is a noticeable part of net profit; a deviation has to be seen in the day or week it forms, not in the monthly report.
For most indicators there is no sourced sector band for Turkey. The threshold is drawn from the store's own last twelve weeks and from the best store cluster in the same format; the rules in the table below are examples. Where an indicator has a legal limit, the threshold comes from the law.
| KPI | Owner | Frequency | Example threshold rule |
|---|---|---|---|
| Fresh food shrink rate | Store manager, fresh department lead | Daily | Twice the product's 4-week average |
| Price label accuracy rate | Store manager | Daily; full check on price-change days | Every non-compliant label becomes a same-day task |
| Cash variance rate | Store manager | Daily | Twice the cashier's 4-week average |
| Stock count variance rate | Area manager | Weekly | Stores above the area average listed in order |
| Promotional uplift | Category manager | Per promotion | Promotions with negative net contribution reported separately |
| Days payable outstanding | Finance | Monthly | Every invoice beyond the Law 6585 Art. 7 limit (30, 45 or 60 days) |
| Food waste to sales ratio | Senior management | Monthly | Monthly share of the annual waste target |
How does Mindpera run this KPI set?
The indicators in the set are calculated from a single data model: POS sales lines, ERP invoices, waste and disposal records, count readings and promotion definitions come together in one model. The database calculates historical figures with defined formulas; the same indicator gives the same number on the store dashboard and on the board dashboard. Forward-looking replenishment and ordering needs come from the demand forecasting model.
Agents find the indicator that crosses its threshold, open a task and assign it to the owner in the table; an item that stays open escalates step by step. A label mismatch on the store dashboard becomes a same-day correction task, and a promotion with negative net contribution on the category dashboard goes onto the category manager's list.
- Mind Ops: daily store scorecard, promotion performance scorecard, checklists and unmatched POS rows.
- Mind Stock: shrinkage with reason codes, count variance against a frozen balance; the shrinkage rate raises an alert when it crosses a threshold.
- Mind Cost: margin under both average and last purchase cost; cost deviation alerts go to the pricing owner.
- Mind Send and Mind Space: replenishment suggestions by rate of sale, productivity per square metre and per shelf metre.
If the indicators' sources sit in separate systems, installation brings them into a single model; dashboards are fed from the same model.
Frequently asked questions
- Which KPIs should a grocery chain track daily?
- The ones that can be acted on before the day closes: average transaction value, in-stock rate, fresh food shrink rate, price label accuracy rate and cash variance rate. Fresh shelf life is a few days and a price change must reach the shelf the same day; tracked weekly, these indicators report loss that has already happened. Each has a single owner in the store.
- How many KPIs should a store manager track?
- In this set the store manager's dashboard has five indicators. The number is kept short on purpose: each indicator is matched to a threshold and an action, and an indicator that crosses its threshold becomes a task for its owner. Indicators the store manager cannot change, such as occupancy cost ratio or supplier payment days, sit on the senior management dashboard.
- How are KPI thresholds set in grocery retail?
- For most indicators there is no sourced sector band for Turkey; the threshold is drawn from the store's own history and from its best store cluster. Where an indicator has a legal limit, the threshold comes from the law: Article 7 of Turkey's Retail Trade Law No. 6585 sets payment ceilings of 30, 45 or 60 days for agricultural and food products, depending on product type and company size.
- What data are grocery KPIs calculated from?
- POS sales lines, ERP purchase and sales invoices, waste and disposal records, count readings, promotion definitions, label check records and the store cost table. When all of them sit in the same data model, a KPI gives the same number on every dashboard. If the sources are spread across different systems, the data model is built first and the dashboard second.