Free Variance Calculator
Calculate your bar inventory variance to identify shrinkage and loss. Compare actual usage against expected sales to spot problems before they become expensive.
Inventory Items
Item Name
Starting (units)
Ending (units)
Sales (units)
Unit Cost ($)
Understanding Variance
Variance is the difference between what you should have used (based on sales) and what you actually used. Industry benchmarks:
- Under 3%: Excellent - tight controls
- 3-5%: Acceptable - normal operations
- 5-10%: High - needs attention
- Over 10%: Critical - investigate immediately
Common causes of variance include over-pouring, theft, waste, spills, and inaccurate counting. Use this calculator to identify which items need investigation.