Food Cost Variance Calculator

Enter food sales, your beginning and ending inventory, purchases, and your theoretical food cost percent. You get actual food cost percent, the variance in points, and what that gap cost you in dollars.

Net food sales for the period, after comps and discounts. Leave out beverage if your theoretical is food only.

Dollar value of food on hand at the start of the period. Usually last period's ending count.

Every food invoice that came in during the period, after credits.

Dollar value of food on hand at the end of the period, from a real count.

What food cost should have been from recipe costs and your sales mix. Enter 29 for 29%.

Variance (points)
1

Step 1 done: you have your number. Step 2 of 2:

Email me this result

Keep the numbers for your next manager meeting.

Free. Your report now, then about 1 email a week. Unsubscribe any time. No sales calls, ever.

Dollar value of the variance
$400.00
Actual food cost %
30%
Theoretical food cost %
29%
Actual food cost
$12,000.00

Want this built into your own system? See a custom build

How I use this on a Friday

When food cost is off, I don't just look at the food. I'll walk the shelves and look at our paper products too, because waste doesn't stop at the kitchen. My biggest issue is usually people not being mindful of what things cost: overcooking product we don't need, carelessly using paper products, theft, or somebody hooking up their friends. I also look for ways to control cost before there's a problem. With chicken, I'll order the minimum fresh product I need and supplement it with frozen because frozen costs less. By the time it thaws, we're usually ready for it anyway. The variance tells me something is wrong. It doesn't tell me why. That's why I get out of the office and look. Numbers can point me in the right direction, but what's actually happening in the restaurant usually gives me the answer.

K. Pinckney, restaurant GM and founder of WRI

The math

Actual food cost is beginning inventory plus purchases minus ending inventory. Actual food cost percent is that number divided by food sales, times 100. Variance is actual food cost percent minus theoretical food cost percent, in points. The dollar value is the variance in points divided by 100, times food sales.

Example: Last week food sales were $40,000. Beginning inventory was $8,500, purchases were $12,300, and ending inventory was $8,800. Actual food cost is 8,500 + 12,300 - 8,800 = $12,000. Actual food cost percent is 12,000 / 40,000 = 30%. Your theoretical food cost is 29%. Variance is 30 - 29 = 1 point. One point of $40,000 is $400 of food you paid for and did not sell.

Questions operators ask

What is food cost variance?

The gap between what your food cost actually was and what it should have been. Actual comes from your inventory counts and invoices. Theoretical comes from your recipe costs and what you sold.

Where do I get my theoretical food cost?

From your recipe costs times what you sold of each item. Most POS and inventory systems can run it for you if your recipes are loaded. If not, cost your top sellers and weight them by how many you sold.

How much variance is normal?

A commonly cited range is within about 1 to 2 points. Watch your own trend week to week. A gap that keeps growing matters more than any one week.

What causes food cost variance?

Over-portioning, overcooking product you do not need, waste, theft, comps that never got rung in, and staff taking care of their friends. Bad counts and missed invoices show up here too.

Why is my actual lower than theoretical?

Usually a counting or invoice problem, not great performance. Check for an invoice that was not entered, a count that was too high, or product moved in from another store.

How often should I check variance?

Weekly if you can take a real inventory count every week. Monthly is too long to wait to find out something is wrong in the kitchen.

Custom builds · No sales calls

Like these calculators? I build the whole system.

Send the forms your managers already use. I turn them into the checklist, work order, par or staff-text system your restaurant actually runs on. Scoped in writing.

$4,500 per build · $350/mo after handoff · Unlimited locations

One build, in production now

  • 85work orders tracked end to end
  • 39properties on one system
  • 15business days to deliver