How much Should you charge guests for breaking glassware?

Glassware Audit Calculator Download

     Each time a guest breaks a glass and your bar needs to buy more, you incur an expense. In his seminar The Cost of a Cocktail Seminar Bobby Heugel suggests adding the cost incurred from glassware breakage to the Cost of the beverage. This calculator automates that process for you and takes it one step further by also calculating the cost of "missing" glassware. These missing glasses can be broken and not accounted for or stolen.

To use:     
     To properly use this calculator, you will need:

• Standardized recipes which determine the particular glass each cocktail is served in
• A log of glasses broken during a set period of time
• A way to access your product mix to determine how many of each drink you have sold.
• Information related to the cost and quantity of glassware you purchase.​

​      Input your glassware costs as well as the # of glasses broken and served and the sheet will tell you the % chance each glass will break when given to a guest, and the dollar amount associated with breaking that glass. It will also summarize the results in a small box on the bottom, telling you how much more you should add to your "Cost" to account for missing and broken glasses. ​
(Note: This spreadsheet assumes you are not buying glassware and putting it in your stock during a set period of time as it is used just as a guide)