Food Cost Variance Calculator

Food cost variance is the gap between what your food should have cost and what it actually cost. Theoretical is what your recipes say you used. Actual is what your stock count says you used. This free food variance calculator works the gap out for one location or a whole group, gives it to you as a percentage of sales and as a cash figure, and then shows you which items it came from.

1. Why Theoretical And Actual Food Cost Never Match

Every kitchen has a variance. You will find plenty of published figures for what an acceptable one looks like, and none of them cite anything. The size of the number is not really the point. The point is whether it is stable from period to period, and whether you can name where it comes from.

Actual food cost is arithmetic you cannot argue with: opening stock plus purchases minus closing stock. Theoretical food cost is a claim: every dish you sold, multiplied by what its recipe should have cost. One is what the shelves say. The other is what the till says.

When the two disagree, stock left the building in a way nobody recorded. In practice that is a short list, and the same two causes account for most of it:

• Portioning drift: the recipe says 180g and the section is plating 220g. Nobody is stealing anything. The dish simply is not the dish you costed, and it surfaces on your three highest-volume items first.
• Receiving and yield: you were billed for 10kg and 9.2kg came through the door, or the recipe was costed on the raw weight of an item that loses a third of itself in prep. Both look identical in the numbers, and both are fixed at the delivery door rather than on the pass.

Wastage, theft and untracked transfers between locations sit behind the same gap. None of them are found by staring at the total. They are found by taking the variance apart item by item, which is what the calculator does with the second half of your inputs.

2. What This Food Variance Calculator Gives You

Enter your sales and your stock movement and you get the headline: variance as a percentage of sales, and the same gap in money for the period and for a year. Then, if you have counts for individual items, add them and the calculator ranks those items by how much of the gap each one is responsible for. The conversation moves from "our variance is bad" to "these four items are the variance". Your figures stay in your browser and we never email you a report. The only thing we keep is the contact detail you enter to unlock the result.

3. The Food Variance Formula, Step By Step

A. Actual food cost. Opening stock + purchases - closing stock. That is what genuinely left your stores. Do not subtract recorded wastage from it: wasted stock is already missing from your closing count, so taking it off again counts it twice and flatters the result.

B. Theoretical food cost. Either the percentage you believe you should be running, applied to sales, or the honest version: every dish sold multiplied by its recipe cost. The second is worth the effort, because it is the only one that can tell you which items are at fault.

C. Coverage. If you enter dishes, the calculator checks what share of your sales those dishes actually represent. Enter 60% of your sales as dishes, then compare their cost against the whole business, and your variance looks roughly three times worse than it is. The calculator scales recipe cost to a blended rate across total sales, and warns you when coverage is too thin to trust.

D. The variance. Variance = actual food cost - theoretical food cost, expressed as a percentage of sales and in money. Because it is a percentage of sales rather than a percentage of cost, it is directly comparable between locations, between periods, and between a coffee shop and a steakhouse.

4. Where The Variance Usually Comes From

Read the item list before you read the total. The calculator ranks items by the money each one contributed, so the top few rows are almost always where the work is.
The causes fall into two groups: things that are genuinely leaking stock, and things that only look like it.

Genuine causes, roughly in the order they turn out to be the answer:

• Portioning: the biggest single cause in most kitchens, and the least dramatic. Weigh the plated portion on your three highest-volume dishes before you investigate anything else.

• Yield and trim: a recipe costed on raw weight, for an item that loses a quarter of itself in prep, produces variance every day it is sold. That is a costing error, not a kitchen one, and no amount of supervision fixes it.
• Receiving: short deliveries and being billed at the wrong price both land here. If one supplier's items cluster at the top of your list, start there rather than with the section chef.

Things that look like variance but are not:

• Untracked transfers: stock that moved to another location, or came from a central kitchen without paperwork, shows as a loss at one end and a gain at the other. Groups see this constantly, and it is the first thing to rule out.
• Count errors and unit mismatches: an item counted in cases at one location and in kilos at another produces a variance figure that means nothing. Fix the unit, then run it again.
• An out of date recipe: if the theoretical cost is stale, the variance is measuring your recipe file rather than your kitchen. Recipes drift faster than most operators expect, especially after a supplier change.

5. One Period Of Variance Tells You Almost Nothing

A single variance number is noise. Counts move, deliveries land either side of a cut-off, and one badly timed count can invent a gap that does not exist. What matters is the trend across periods, and whether the same items keep appearing at the top of the list. Count on the same day, in the same units, before service, and the number starts telling the truth. There is more on that in our guide to cycle counting versus full stocktakes.