What Is Inventory Variance?
Inventory variance is the difference between what your records say you should have used and what you actually used. A positive variance means you used more product than expected; a negative variance means less. Either way, a number that drifts outside 2–3% is a signal worth investigating — it directly erodes food cost and gross margin.
The Formula
``` Variance % = ((Theoretical Usage − Actual Usage) ÷ Theoretical Usage) × 100 ```
Theoretical Usage is calculated from your sales mix: units sold × recipe yield per unit. Actual Usage comes from your physical counts: Opening Inventory + Purchases − Closing Inventory.
Worked Example
Your burger recipe calls for 6 oz of ground beef per cover. You sold 400 burgers this week.
- Theoretical usage: 400 × 6 oz = 2,400 oz (150 lbs)
- Actual usage: 160 lbs (opening 40 lbs + purchases 140 lbs − closing 20 lbs)
- Variance: 10 lbs over theoretical
- Variance %: (10 ÷ 150) × 100 = 6.7%
At $6/lb for ground beef, that 10-lb gap costs you $60 per week — over $3,100 annually on one ingredient alone.
Why This Number Matters to Your Margins
Most full-service restaurants run food costs between 28–35%. A consistent 5–7% variance on high-velocity proteins can push you into the red without a single slow night. Variance catches over-portioning, waste, spoilage, and theft before they compound.
How Hubstaurant Automates Inventory Variance Tracking
Spreadsheets work, but they require disciplined manual entry every count cycle. Hubstaurant reads your vendor invoices automatically, updates your cost-per-ingredient in real time, and maps purchases directly to your recipe database. When you log a closing count, the system calculates theoretical usage from your POS sales mix and surfaces variance by item — no formula-building required.
Theft and leakage detection flags items trending outside your acceptable variance threshold so you can investigate a specific station or shift rather than guessing. Standalone inventory apps like MarketMan do this well in isolation; where Hubstaurant adds value is connecting that variance data directly to your vendor purchasing workflow and food-cost analytics in the same platform, so a spike in variance can trigger a reorder review without switching tools.
Stop Chasing Spreadsheets
If you're manually calculating variance today, you're spending time that could be spent on your floor. See how Hubstaurant closes the loop — start your free trial and run your first automated variance report.