Food cost variance calculator
On this page
- Food cost variance calculator
- How do you use the variance calculator?
- What is the food cost variance formula?
- What does a worked example look like?
- What should I check when an item is flagged?
- Why is a negative variance a problem too?
- How does Varastiq catch variance automatically?
- Frequently asked questions
- Related free tools
- Catch it during the count, not at month-end
Free tool · no signup · runs in your browser · Last updated: · By the Varastiq team
Key takeaway: Food cost variance is the gap between what you actually used and what your sales say you should have used. Per item: actual usage = beginning count + received − ending count; theoretical usage = dishes sold × recipe quantity. Variance $ = (actual − theoretical) × unit cost. Enter a few items below to see which ones are costing you, in dollars.
Food cost variance calculator
| Item | Unit | $/unit | Begin | Received | End | Dishes sold | Qty per dish | Remove |
|---|---|---|---|---|---|---|---|---|
| Item | Should have used | Actually used | Variance | $ | Flag |
|---|---|---|---|---|---|
| Chicken wings | 126 | 132 | +4.8% | $18.60 | Watch |
| Ribeye 12 oz | 51 | 52 | +2.0% | $14.50 | Within range |
| Fry oil | 32 | 33 | +3.1% | $6.25 | Watch |
Total variance: $39.35 (+3.0% of theoretical $1,330.10)
That's $39.35 of variance on these items. Review item usage and count changes in Varastiq →
Formula: actual usage = begin + received − end. Theoretical = dishes sold × qty per dish. Variance $ = (actual − theoretical) × unit cost. Nothing you type leaves your browser.
How do you use the variance calculator?
- Pick the items worth checking. Start with the ones that carry the most dollars: proteins, seafood, cheese, liquor.
- Set the unit and cost. Use the unit you count in (lb, each, case, bottle) and the latest invoice cost per unit.
- Enter the counts. Beginning count, quantity received from invoices, and ending count for the same period.
- Enter sales usage. How many dishes using that item were sold (from your POS product mix report) and how much of the item each dish uses, from the recipe. If an item goes into several dishes, add up their usage and enter it as dishes sold × 1.
- Adjust the thresholds if you want. The defaults flag ±2% as "watch" and ±5% as "investigate". They're Varastiq's starting points, not an industry standard. Tighten them for expensive items.
What is the food cost variance formula?
Actual usage = Beginning count + Received − Ending count
Theoretical usage = Dishes sold × Recipe quantity per dish
Variance (qty) = Actual usage − Theoretical usage
Variance $ = Variance (qty) × Unit cost
Variance % = Variance (qty) ÷ Theoretical usage × 100
Add up the variance dollars across items and divide by total theoretical dollars to get an overall variance %. At the restaurant level, that's the gap between actual and theoretical food cost.
What does a worked example look like?
A bar and grill checks three items for one week:
| Item | Begin | Received | End | Actual used | Sold × recipe | Theoretical | Variance | $ |
|---|---|---|---|---|---|---|---|---|
| Chicken wings (lb, $3.10) | 40 | 120 | 28 | 132 | 210 × 0.6 lb | 126 | +4.8% | $18.60 |
| Ribeye 12 oz (each, $14.50) | 18 | 48 | 14 | 52 | 51 × 1 | 51 | +1.96% | $14.50 |
| Fry oil (gal, $6.25) | 10 | 35 | 12 | 33 | 640 × 0.05 gal | 32 | +3.1% | $6.25 |
Total theoretical usage is $1,330.10. Total variance is $39.35, or 3.0%. On its own that's small. Over 52 weeks it's about $2,046, from three items. The wings are the biggest dollar gap: 6 lb over recipe in one week. Ribeye is one steak. Check whether it was a comp or a re-fire before anything else.
All figures are an illustrative example, not customer data.
What should I check when an item is flagged?
Work from the most common cause to the least:
- Recount. Most big swings are counting errors: a case entered as each, a shelf missed.
- Invoices. A delivery received but not entered, or a credit not applied.
- Recipe. Does the recipe quantity match how the line actually plates it?
- Waste and comps. Were spoilage, dropped food or re-fires logged?
- Portioning. Watch a few plates, or weigh a few portions.
- Theft or unrung sales. If all the above check out and the same item keeps flagging, look at who has access and when it goes missing.
Why is a negative variance a problem too?
If you used less than theory says, something is off: the recipe overstates the quantity, sales were rung under the wrong item, a delivery was entered twice, or the count is high. Negative variance can hide a real loss elsewhere, so the calculator flags it the same way.
How does Varastiq catch variance automatically?
Varastiq uses recipes, supported sales data, invoices and submitted counts for usage reporting. In the Stiq count screen, a separate guard flags large changes from the previous count so you can check the number before submitting. See variance and count flags.
Frequently asked questions
How do you calculate food cost variance?
For each item, subtract theoretical usage from actual usage and multiply by unit cost. Actual usage is beginning count plus received minus ending count. Theoretical usage is dishes sold times the recipe quantity.
What is a normal food cost variance?
There is no published industry standard we can cite. This tool's defaults flag 2% as worth watching and 5% as worth investigating. Set tighter thresholds for high-cost items.
What causes food cost variance?
Common causes are counting errors, missing invoices, recipe quantities that don't match how dishes are plated, unlogged waste and comps, over-portioning, and theft.
Where do I get dishes sold?
From your POS product mix report, which lists how many of each menu item sold in a period.
Can variance be negative?
Yes. Negative variance means you used less than recipes and sales predict. It usually points to a recipe, sales-entry or counting error and should be checked like a positive one.
Does this calculator save my numbers?
No. Everything runs in your browser and nothing you enter is sent anywhere.
Related free tools
Food cost calculator · Recipe cost calculator · Plate cost calculator · Yield calculator · All tools
Catch it during the count, not at month-end
Varastiq flags variance item by item, while the person who can explain it is still in the walk-in. Varastiq Pro: $149/month for your first location, plus $99/month for each additional location, or $1,639/year (1 month free). Optional $299 guided setup. Money-back guarantee on the software: 14 days on monthly plans, 30 days on annual.