Inventory variance calculator · 100% free · no signup
Inventory Variance Calculator
Compare what costs should have been (theoretical, from recipes) to what they actually were (from inventory). The gap is where waste, theft, and over-portioning live. Best operators run under 1%.
Why this matters
Variance is where the actual money is.
Food cost percentage tells you the symptom. Variance tells you the cause. Two operators can have identical 32% food cost — one through perfect execution at a 32% theoretical target, the other through 28% theoretical plus 4% leak.
Same number, completely different businesses. The first is operating at design efficiency. The second is bleeding $X,XXX a month and doesn't know it.
Operators who measure variance see the leak. Operators who measure only food cost % react to a number that has no actionable cause. The variance discipline is what separates well-run kitchens from lucky ones.
Three habits build it: weekly physical inventory at close, POS recipe costs kept current, daily waste log. None require software. All require consistency. Once those three exist, variance falls below 1% within 90 days at most concepts.
Real scenarios
Three variance stories
High variance hides real money. Track it, find it, fix it.
The 7% protein variance
Steakhouse, blended variance 4%. Owner thought it was acceptable. Then split by category: protein variance 7%, dry goods 1%.
Investigation revealed line cook trimming steaks heavy, taking trim home in cooler bag. Plus over-portioning ribeyes (10oz vs spec 8oz) on owner-comp meals.
Locked walk-in after close, installed scale on grill station, audited every comped meal weekly with management.
Protein variance to 1.5% in 6 weeks. $4,800/month margin recovered. Cook left voluntarily after lockdown.
The 9% bar variance
Cocktail bar, beverage variance 9%. Manager blamed inflation.
Variance audit: top 3 spirits accounted for 70% of the gap. Bartender free-pouring, comping shift drinks not in POS. Theoretical was 19%, actual 28%.
Installed measured pour spouts, mandated POS ring-in for every shift drink, reviewed top 5 spirits weekly with bartenders.
Variance to 2% in 8 weeks. Two bartenders left after the discipline arrived. Replacements onboarded clean from day one.
The 0.4% star
Family-owned casual diner, 30 years operating. Owner ran weekly variance. Average 0.4%.
Not luck — habit. Sunday close: physical count. Monday morning: theoretical from POS. Tuesday: variance review with kitchen team. Every week, every year, three decades.
No fix needed. Documented the practice as case study for newer operators.
Restaurant operates at 26% food cost where competitors run 32%. Six points of margin = ~$120K/year on their volume. Pure discipline, zero technology.
FAQ
Common questions
01 What is inventory variance?
Inventory variance is the difference between what your costs SHOULD have been (theoretical, based on recipes and items sold) and what they ACTUALLY were (real inventory consumed). Variance flags waste, over-portioning, theft, comping, and counting errors. Best operators target variance under 1%. Above 3% means real money is leaking.
02 How do you calculate inventory variance?
Variance % = Actual Cost % − Theoretical Cost %. Variance $ = Actual Cost − Theoretical Cost. Theoretical comes from your POS multiplied by recipe costs. Actual comes from inventory math: Opening + Purchases − Closing. The gap between them is variance.
03 What is a good variance?
Best-in-class operators target under 1% variance. 1–3% is acceptable in normal operations. 3–5% needs investigation. Above 5% is a red flag for theft, severe over-portioning, or systematic comping. Sustained variance above 8% usually means inventory counts are unreliable or POS recipe costs are outdated.
04 What causes high variance?
Ranked by frequency: (1) over-portioning — line cooks plating heavy, (2) waste — spoilage, trim, prep errors not tracked, (3) employee meals not rung in, (4) comps not tracked in POS, (5) theft — bartender pouring extra, line cook taking food home, (6) inventory counting errors, (7) outdated recipe costs in POS, (8) supplier short-shipping without invoice adjustment.
05 How do I lower variance?
Start with measurement: install scales on the line, train portion specs, log waste daily. Then process: track comps + employee meals through POS, recount inventory weekly not monthly. Then accountability: review variance with the team weekly, tie to bonus structure if appropriate. Best operators get to under 1% within 90 days of starting the discipline.
06 Is variance the same as shrinkage?
Closely related. Shrinkage is the dollar value of inventory lost to waste, theft, or counting error. Variance is the percentage measure. Both describe the same gap. "We had $1,200 in shrinkage" = "We had 2.4% variance on $50K food sales."
07 Should I track variance by category?
Yes — at minimum split protein, produce, dairy, and dry goods. Protein is usually the largest variance contributor (highest cost per unit, easiest to over-portion or steal). Tracking by category tells you where to focus. A 3% blended variance might be 1% on dry goods and 6% on protein.
08 How often should I run variance?
Weekly. Monthly hides too much, daily is too noisy. Weekly catches drift early enough to fix the next week. The discipline of physical inventory every Sunday at close is the foundation — without that, theoretical numbers don't mean anything.
09 Does this calculator save my data?
No. Nothing is stored, transmitted, or tracked. The calculation runs entirely in your browser and disappears the moment you close the tab. No signup, no email, no account.