Food cost variance calculator
Variance = actual food cost − theoretical food cost. Theoretical is what the dishes sold should have cost. Actual is opening stock + purchases − closing stock.
Your result
- Result
- Press "Work it out" to see it here.
These are your own figures. We show no market averages.
Zentaro Serve free calculator: https://serve.zentaro.cloud/tools/food-cost-variance-calculator. Worked out in the browser. The numbers you typed were not sent to us. If you agreed to measurement, we count only that a calculator was used.
The problem this solves
You expected to use a certain amount of food, but you used more or less.
The gap can come from waste, portions, theft or wrong counts.
This shows the gap in rupees and as a share of sales.
How to use it
- Type the cost of the food you expected to use.
- Type the cost of the food you actually used.
- Type your food sales for the same period.
- Press "Work it out" to see the variance.
The formula
Theoretical cost = sum of (dishes sold × plate cost). Actual cost = opening stock + purchases − closing stock. Variance = actual − theoretical. Points = actual food cost % − theoretical food cost %, each over the sales of these dishes.
A worked example (made-up numbers)
- Dish A sold 400 at ₹250 with a plate cost of ₹70. Dish B sold 300 at ₹180 with a plate cost of ₹50.
- Sales = 100,000 + 54,000 = ₹1,54,000. Theoretical cost = 28,000 + 15,000 = ₹43,000, which is 27.92% of sales.
- Stock count: 20,000 + 52,000 − 25,000 = ₹47,000 used. That is 30.52% of sales.
- Variance = 47,000 − 43,000 = ₹4,000 above the recipe figure. That is 2.6 points of sales.
What this does not cover
- The dishes, prices and stock figures are made-up examples. Use your own for the same dates.
- List every dish that used the stock you counted. If you leave dishes out, the gap will look bigger than it is.
- A gap can come from waste, over-portioning, theft, wrong recipes, wrong counts or price changes. The number alone does not say which.
- Staff meals and free dishes sit in actual cost, so they show up as variance.
- A stock count that is wrong gives a variance that is wrong.
Questions about this calculator
What is food cost variance?
It is the gap between what your recipes say you should have spent on food and what your stock count says you did spend.
Is a positive variance bad?
It means you used more food than the recipes explain. Look for waste, portion creep or unrecorded use. A small gap is normal.
How often should I check it?
Weekly if you count stock weekly. Use the same dates for the stock count and the sales.
Why do I need the selling prices?
They give the sales of these dishes, so the gap can also be shown as points of sales.
Is my data saved?
No. The sum runs in your browser. Nothing you type is sent to us, and there is no sign-up.
Keep going
More calculators: Food cost calculator · Recipe cost calculator · Restaurant profit calculator · Break-even calculator · Reorder point calculator · Food wastage calculator · Menu engineering calculator · Labour cost calculator · Delivery order profit calculator
Want these numbers without the typing?
Zentaro Serve launches in 2027. It keeps your sales, stock and recipes in one place. Tell us what you run today and we will get in touch.