In many hotel and restaurant groups, the procurement dashboard is really an accounting export: spend by supplier, delivered three weeks after month-end, that nobody can quite explain. The problem is less the layout than the choice of indicators, and the data feeding them.
Here are the 12 procurement KPIs that matter for a multi-site group: definition, formula, what each one reveals and how often to review it. Then an example procurement dashboard, view by view.
Before the KPIs: line-level, complete, comparable data
A procurement KPI is only as good as the data behind it. Three conditions come before any formula:
- The product line, not the invoice total. Almost every KPI below is calculated from unit price and quantity, which classic invoice OCR often fails to capture.
- Harmonised units. A price per case and a price per kilo cannot be compared.
- All spend, counted once. Credit notes deducted, duplicates removed, every site included. A partial scope gives flattering KPIs, and wrong ones.
This is usually where spreadsheets reach their limits.
Spend: what you buy
1. Net purchasing spend
What the group actually bought, excluding VAT, by site, category and supplier.
- Formula: sum of purchase lines excluding VAT − credit notes.
- What it reveals: where the money goes. It is the base for every ratio that follows.
- Frequency: monthly for the group, weekly for each site.
2. Spend variance: price effect and volume effect
Spend is up 6% year on year: are you paying more, or buying more?
- Formula: price effect = Σ (price this year − price last year) × quantity this year; volume effect = Σ (quantity this year − quantity last year) × price last year. On products bought in both years, the two add up to the total variance.
- What it reveals: higher activity is read against covers and occupancy; higher prices get negotiated.
- Frequency: monthly, year on year.
3. Cost per cover or per occupied room
Spend brought back to activity.
- Formula: category spend ÷ covers served, or ÷ occupied rooms for guest amenities, linen and cleaning.
- What it reveals: a 40-room hotel and a 200-room one become comparable. A lasting gap between two similar sites points to a supplier, a product range or waste.
- Frequency: monthly.
Prices: what you pay
4. Purchase price inflation on a fixed basket
How the price of the same basket of products moves, with no volume or range effect.
- Formula: index = Σ (current price × reference quantity) ÷ Σ (reference price × reference quantity) × 100.
- What it reveals: your own inflation, not the national figure. An index of 104 means the same basket costs 4% more — the starting point of any negotiation.
- Frequency: monthly, by category and by supplier.
5. Price spikes
Products whose price paid moves well above their usual price.
- Formula: number of products whose latest price exceeds their reference price (for instance the three-month average) by more than X%; impact by value = unit increase × quantities bought since.
- What it reveals: price drift before it settles in. Rank spikes by value, not by percentage: +30% on fresh herbs can weigh less than +5% on beef fillet.
- Frequency: continuously, as alerts; reviewed weekly.
6. Price gap between sites
For the same product, the gap between what each site pays and the best price in the group.
- Formula: site overspend = Σ (site’s average price − group’s best price) × quantities bought by the site, on a like-for-like unit.
- What it reveals: the site that pays too much, and the one to learn from. A KPI specific to multi-site purchasing, invisible while each site tracks its own purchases.
- Frequency: monthly.
Suppliers: what you negotiated
7. Contract coverage
The share of spend made at negotiated prices: contracts, price lists, fixed prices.
- Formula: spend at negotiated prices ÷ total spend × 100.
- What it reveals: how much of your spend is actually under control. The rest is bought at the going rate, with no safeguard.
- Frequency: quarterly.
8. Contract price compliance
Negotiating is pointless if the price invoiced is not the price agreed.
- Formula: compliance rate = lines invoiced at the negotiated price ÷ lines for products with a negotiated price; gap by value = Σ (invoiced price − negotiated price) × quantity, on lines invoiced above it.
- What it reveals: supplier invoice errors and increases passed on without agreement. The gap by value is what you claim back.
- Frequency: on every invoice, summarised monthly.
9. Supplier concentration
How much your main suppliers weigh in your spend.
- Formula: spend with the top 10 suppliers ÷ total spend, alongside the number of active suppliers over the period.
- What it reveals: your negotiating weight, and your dependency. A long tail of occasional suppliers spreads volumes thin. Track year-end rebate progress alongside it.
- Frequency: quarterly.
Margin, stock and impact
10. Food cost percentage
The share of revenue consumed by ingredients — the flip side of your food gross profit.
- Formula: (opening stock + purchases − closing stock) ÷ matching revenue excluding VAT × 100.
- What it reveals: the link between purchasing and margin. Compared with the theoretical cost of your recipes, it measures waste and portioning. More in how to calculate food cost and actual vs theoretical food cost.
- Frequency: monthly, at every stock take.
11. Stock value and days of stock
What sits in your stores, and for how long.
- Formula: stock value = Σ quantities counted × unit price paid; days of stock = stock value ÷ average daily consumption.
- What it reveals: cash tied up in cold rooms and cellars, and the risk of waste on fresh produce. Valued at list price rather than price paid, stock also distorts food cost: see our restaurant inventory method.
- Frequency: at every stock take, at least monthly.
12. Share of local and seasonal purchases
What your purchases say about your sustainability commitments.
- Formula: spend on locally sourced products (by your own definition: region, distance) ÷ food spend; same calculation for seasonal products.
- What it reveals: the gap between commitments and actual purchases, with figures to back up your ESG reporting.
- Frequency: quarterly, yearly for ESG reporting.
Procurement dashboard example for a multi-site group
Take a fictional group of five hotels with restaurants and three standalone restaurants. Rather than one dashboard stacking all 12 KPIs, build four views on the same data, each limited to what its reader can act on.
| View | For whom | KPIs | Rhythm |
|---|---|---|---|
| Group | Managing director, finance director | Net spend (1), price and volume effects (2), fixed-basket inflation (4), food cost by site (10) | Monthly |
| Purchasing | Head of purchasing | Price spikes (5), price gaps between sites (6), contract coverage (7), contract price compliance (8), concentration and rebates (9) | Weekly |
| Site | General manager, head chef | Spend this week (1), cost per cover or per room (3), the site’s price spikes (5), stock value (11) | Weekly |
| ESG | Sustainability lead | Local and seasonal purchases (12), origins map | Quarterly |
In the group view, three bands are enough:
- At the top, four KPI tiles compared with last year: net spend, price effect, fixed-basket inflation, food cost.
- In the middle, the sites side by side, to spot the one falling behind.
- At the bottom, action lists: the costliest price spikes, contract price gaps to claim back, top suppliers.
And one rule everywhere: every figure must lead to the invoice line that explains it. Otherwise the monthly meeting turns into a debate about whether the number is right, instead of ending in decisions.
Building this procurement analytics without spreadsheets
These KPIs assume every line of every invoice, credit note and delivery note has been extracted, with harmonised units and a link to its source PDF: that is where Eqolux starts.
In Eqolux dashboards, each view is built from widgets you drag, drop and resize: KPI tiles, top suppliers, price spikes, origins map. Dashboards are named and shared, one can be set as the default view for the whole group, and year-on-year comparison works per site and per category, without a line of SQL. Scheduled email reports send widgets at the rhythm you choose. Each team sees its own site; leadership sees everything.
Key takeaways
- A procurement dashboard starts with data: the product line, harmonised units, every item of spend counted once.
- Twelve KPIs cover the essentials: spend, prices, suppliers, then margin, stock and impact.
- Each KPI has its rhythm: price spikes continuously, supplier concentration quarterly.
- One view per reader beats a single dashboard, and every figure should lead back to its source.
Want to see these KPIs calculated on your own invoices? Explore Eqolux dashboards or book a demo on your own data.


