Inventory Variance

What is Inventory Variance?

Inventory variance is the difference between how much product you actually used, based on your inventory counts, and how much you should have used, based on what you sold.

It's how you find out whether the bar is pouring what the specs say. A bar can price every drink perfectly and still lose money if variance is high.

The Formula

Actual Usage − Theoretical Usage = Inventory Variance

Where:

  • Actual usage = Beginning Inventory + Purchases − Ending Inventory

  • Theoretical usage = what your sales and recipes say you should have used (see Theoretical Usage)

As a percentage:

Inventory Variance ÷ Theoretical Usage = Variance %

A positive variance means you used more than you sold. That's the usual direction, and it's money lost. A negative variance means you used less than you sold, which usually points to a counting or recipe error, not a windfall.

Quick Example

One week of vodka, in 750 ml bottles (25.36 oz each):

  • Beginning inventory: 10 bottles

  • Received: 6 bottles

  • Ending inventory: 7 bottles

  • Actual usage: 10 + 6 − 7 = 9 bottles = 228.2 oz

The POS shows 100 vodka sodas (1.5 oz each) and 30 espresso martinis (2 oz each):

  • Theoretical usage: 150 + 60 = 210 oz

Variance = 228.2 − 210 = 18.2 oz, or 8.7%.

At $1.00 per ounce, that's $18 a week on one product. Over a year, it's about $950, and that's before you look at the rest of the back bar.

Why It Matters

  • It's the only number that shows the gap between what you sold and what you poured.

  • It explains why your actual Pour Cost runs higher than your recipe math says it should.

  • It points you to specific products, so you can fix the problem instead of guessing.

  • Without it, Shrinkage stays invisible until it shows up in your P&L.

What Causes Variance

Most variance is operational, not theft:

  • Overpouring: free pours, heavy-handed jigger use, "a little extra" for regulars

  • Comps and voids: drinks poured but never rung in, or rung in wrong

  • Wrong POS buttons: a premium vodka rung in as well, or a double rung as a single

  • Recipes that don't match the bar: the spec says 1.5 oz, the bartenders pour 2

  • Spills, breakage, and dumped drinks

  • Receiving errors: the invoice says 6 bottles, 5 showed up

  • Counting errors: missed bottles, bad partial-bottle estimates, counting at different times of day

  • Theft: real, but usually the last explanation, not the first

Common Mistakes

Trusting your recipes without checking them Theoretical usage is only as good as your specs. If the bar pours differently than the recipe says, variance will flag a problem that's really a documentation issue.

Inconsistent counts Count at the same time, the same way, with the same units every period. Changing the method changes the result.

Chasing every product Start with your highest-volume and most expensive items. A 10% variance on a bottle you use once a month doesn't matter much.

Ignoring negative variance Using less than you sold sounds good, but it means something in the data is wrong. Find it, or it will hide real losses elsewhere.

Measuring too rarely A monthly variance tells you something went wrong. A weekly variance tells you when.

Inventory Variance vs Shrinkage

  • Inventory variance is the measurement: the gap between actual and theoretical usage.

  • Shrinkage is the loss behind it: product you paid for and didn't sell.

Variance is how you detect shrinkage. Not all variance is shrinkage, though. Some of it is bad recipes or bad counts.

What Good Looks Like

Diageo Bar Academy puts the industry norm at around 1–2%, and notes that many bars run between 5% and 25% (source). Zero isn't realistic in a working bar. What matters is knowing your normal and noticing when it moves.

FAQ

What's a good inventory variance percentage? Around 1–2% is a common target. If you're above 5%, start with your top-selling products and work down.

How often should I calculate variance? Weekly for liquor and your top-selling items. Monthly is too slow to connect a spike to what caused it.

Can inventory variance be negative? Yes. It usually means a counting error, a missed invoice, or a recipe that calls for more than the bar actually pours.

Is variance the same as shrinkage? No. Variance is the measurement; shrinkage is the loss. Variance can also come from bad data rather than lost product.

Do This in Spec

Variance is only as accurate as the counts, invoices, and recipes behind it. Spec handles all three: stock counts organized by your bar's actual layout, invoices that keep product prices current, and exact specs for every recipe and sub-recipe.

Related Terms

Related Guides from Spec

Bottom Line

Inventory variance is the honest check on everything else. Your recipes say what a drink should cost; variance tells you what it actually cost. Track it weekly, start with your biggest products, and fix the process before you blame the people.

Connor Welsh

After working as the bar manager at The Rosecomb and on the distributor side with AOC in Chattanooga, TN, Connor took his experience on both sides of the bar with him to Product Manager at Spec.

https://www.instagram.com/wilconwel/?hl=en
Previous
Previous

Theoretical Usage

Next
Next

Sales Mix