Bar stock variance calculator
Enter opening stock, bottles bought, pegs sold and the counted closing stock for each brand to see the variance in ml and what it cost you.
What it does
- Expected closing = opening + bottles bought × bottle size − pegs sold × peg size
- Variance = counted closing − expected closing; a negative number is a shortage
- Shortage valued at cost per bottle and at the selling price per peg
- Set a threshold to flag the brands that need a closer look
Frequently asked questions
What is bar stock variance?
The difference between what your books say should be on the shelf and what is physically there. Book stock is opening stock plus purchases minus what was sold, converted to ml.
How do I count an open bottle accurately?
Weigh it and convert grams to ml using the empty bottle weight and the liquid’s density, or mark the level on the real bottle shape.