AU & NZ
SG
MY
US
IE
Procure Wizard Evo
Downloadable Restaurant KPI Excel Spreadsheet
Track the six KPIs that connect directly to your margin: Cost of Sales, waste percentage, GP by dish and site, price variance, credit rate and time to resolve issues.
What is inside the calculator?
The calculator covers six KPIs, each on its own tab. Enter your figures in the blue input cells and your result calculates automatically. Every tab includes a benchmark range so you can see straight away how your number compares.
-
Cost of Sales (COS) - what percentage of your revenue is going on ingredients and consumables, updated to reflect current supplier prices.
-
Waste percentage - what proportion of purchased food is being wasted, broken down to cost per cover and annualised total.
-
GP by dish and by site - true gross profit at dish level and across your sites, calculated from recipe costs rather than estimated.
-
Price variance - how much you are paying above contracted rates per unit, and what that is costing you across the full period.
-
Credit rate - credits raised as a percentage of purchases, recovery rate, and the value of any credits still outstanding.
-
Time to resolve issues - average resolution time for delivery and invoice queries, and the percentage still open at period end.
When a spreadsheet is not enough
A calculator like this one is a useful starting point, but it has a natural ceiling. Every number you enter has to come from somewhere, which means someone has to gather it, check it and input it, and by the time that happens, the data is already a few days old at best.
Procure Wizard Evo connects the same six metrics to live procurement, stock and recipe data, so the numbers update as activity happens. COS recalculates when a supplier price changes. Waste percentage updates as mobile captures come in from the kitchen. GP by dish adjusts the moment a recipe cost moves. You get the same visibility this calculator provides, without the manual step in the middle.