Liquor Loss Calculation Formulas
By entering information about your business, you can calculate your current liquor losses. Turn these losses into cost savings by using liquor control equipment and liquor dispensers from Berg Company.
In the following formulas, * means multiply and / means divide.
CostPerCase = your average cost of a case(12 bottles x 1 Liter each) of liquor
The estimated national average losses from spillage, over-pouring, and giveaways is 6 oz.
LostPerL = your estimated oz lost per liter
NumCasesWk = Number of cases of liquor you go through per week
RetailPrice = your average retail price of a drink
The estimated industry average is 3.4 drinks sold per liter that never reach the register
LostSold = Estimate how many drinks were sold per liter but never reached your register
CostPerOz = (CostPerCase / 12) / 33.8
RetailLoss = RetailPrice * LostSold * 12 * NumCasesWk
WholeLossCase = LostPerL * 12
WholeLossWeek = NumCaseWk * WholeLossCase
RetailLossBottle = RetailPrice * LostSold
RetailLossCase = RetailLossBottle * 12
RetailLossWeek = NumCasesWk * RetailLossCase
RetailLossMonth = 4.3 * RetailLossWeek
TotalLossMonth = RetailLossMonth + WholeLossMonth
Your wholesale cost loss per case = WholeLossCase
Your weekly wholesale cost loss = WholeLossWeek
Your Monthly wholesale cost loss = 4.3 * WholeLossWeek
Your retail loss per bottle = RetailLossBottle
Your retail loss per case = RetailLossCase
Your weekly retail loss = RetailLossWeek
Your monthly retail loss = RetailLossMonth
Your total average liquor losses per month = TotalLossMonth
Your total liquor losses per year = 12 * TotalLossMonth
All contents copyright ©1997-2010 Berg Company, LLC. All rights reserved. Berg Company is a Wisconsin Limited Liability Company.