In Part 1 of this post, we discussed some of the problems associated with calculating liquor cost. In this section, we will provide you with some tips to help you eliminate these problems.
If you experience a bouncing liquor cost, it is a clear sign that one or more problems were encountered in calculating your liquor cost. There are several steps you can take to troubleshoot and eliminate these problems associated with calculating liquor cost.
Follow the same process when selecting dates to be evaluated in your POS system.
Liquor invoices have charges for actual products, delivery fees, and refundable keg deposits (for beer). Since you are only trying to calculate the cost of the product, delivery fees and keg deposits must be excluded.
It is important to split liquor cost into separate categories for draft beer, bottled beer, liquor, wine, and miscellaneous. This will increase accuracy when you are calculating your liquor cost. If you lump all of these figures into one category, it is much harder to identify errors or jumping trends.
For example, if you experience a higher volume of bottled beer sales in a particular period, you might notice a higher cost by assessing these categories together. Keeping these figures separate would make it easier to identify the fact that you experienced a shift in sales, not an increase in cost.
No one likes doing liquor inventory and calculating liquor cost accurately is more challenging than you might think. However, it is still an important task which must be taken seriously. If you try to count inventory late at night at the end of a shift, you will be tired and more likely to rush through the process in order to get home quicker. This increases the likelihood that you will experience errors in your calculations.
It is much more effective to do inventory in the morning when you are fresh, focused, and free of distractions. Mornings are typically slow for most bars, allowing you to give the task your undivided attention. Make sure the person taking inventory is focused on just this task and doesn’t have other responsibilities to handle at the same time.
Also, it is important to complete the entire liquor inventory process in one day. Otherwise, the calculation of your data will be delayed. If an error occurs, this delay will make it much more difficult to identify and correct the errors since many more deliveries will have occurred and more sales will have been entered into your POS system.
Bar-i also recommends that you pick a set day of the week to do liquor inventory. This makes the process consistent and ensures the same person will always be available to perform the task. We typically advise our clients to choose Monday since inventory levels are typically lower after a weekend. As a result, there will be less to count.
It is also best to take inventory once a week rather than once a month. When you only perform this task once a month, you are not taking inventory frequently enough to generate accurate data. If for some reason you feel once a week is too often, then taking inventory bi-weekly provides a happy medium.
Counting inventory must be done on a specific day since you are trying to freeze time, but you can still gather other information in advance. Entering invoices into accounting software and pulling a report telling you what was delivered should be done in the before you start counting and calculating liquor cost.
When inventory changes positions or the same product is stored in multiple locations, you are complicating the task and creating more opportunities for error. Keeping your inventory well organized is one of the best ways to reduce the risk of these errors when calculating liquor cost.
The day before you take inventory, make sure everything is organized properly. All bottles should be arranged and organized in a logical manner, and all boxes should be broken down and thrown out. If you get your bartenders involved in this task, it will go much quicker.
When doing inventory, always count in the same order (top to bottom, left to right, and back to front). If you’re systematic about how you take inventory, you will complete the task faster and reduce errors.
Bar-i has also recently developed a free downloadable liquor inventory tool that provides you with the following benefits:
By following these tips, you can eliminate many of the errors which cause problems calculating liquor cost.
For additional tips on how to streamline your liquor inventory processes or to schedule a free consultation, please contact Bar-i today or call 303-219-0196. We provide services to bars nationwide from our offices in Denver, Colorado.