If you’re considering upgrading your liquor inventory system, it’s important to first think about the goals you would like to achieve out of the inventory process. This will help you narrow down your options to focus on the solutions that address your specific goals.
There are a wide range of sophisticated bar inventory systems available. Each option takes a slightly different approach to the process, and you’ll want to find one that will work effectively in the context of your bar’s business model. That being said, there are certain elements that a good inventory system must possess in order to help you achieve your goals.
There are three different levels of bar inventory, and the specific level you need to strive for will depend on what you’re trying to achieve with your inventory efforts:
Level 1 inventory is the most basic function for this process. You need to make sure you always have enough product on-hand, and counting your inventory will ensure you always know what you need to order. There is no analytics data generated with level 1 inventory. You’re simply making sure you have enough product on-hand.
Level 2 inventory helps you achieve some basic analytics data that will give you a broad understanding of your liquor cost. While this data can allow you to evaluate trends over time, it won’t really provide you with the detailed information necessary to make significant improvements to your bar’s operations.
Level 3 inventory provides the most effective use of your liquor inventory efforts. By precisely comparing what was poured vs. sold for every product you carry, you can identify specific products that are underperforming (either due to overpouring or being given away). This will allow you to make changes to your day-to-day operations that will ensure your staff is selling a higher percentage of everything being poured.
By providing level 3 inventory services, we’re able to help our clients reduce their liquor cost by 3% on average. Over time, this equates to a significant increase in profitability.
If you’re looking to get anything beyond knowing what you need to order out of your liquor inventory efforts, you’re choosing between a system that will provide level 2 vs. level 3 results. You need to make a distinction regarding whether your goal is to do level 2 inventory and simply calculate liquor cost, or whether you want to use this opportunity to take your bar inventory efforts a step further by using them as a tool to increase profits. When choosing a new liquor inventory system, this is an important decision that will dictate which options you should be evaluating.
Level 3 inventory is a more complicated task and has more elements involved in the process. If you’re looking to achieve level 3 inventory, you’ll need to find a system that also provides high levels of precision and robust analytics data.
We’re going to discuss the essential elements that need to be considered for a system providing level 2 inventory. In our next post, we’ll dive into the elements to consider for systems providing level 3 inventory. When you’re evaluating bar inventory systems to use at your bar, think about how each option addresses these elements. This will help you determine the best solution for your bar’s unique needs.
Level 2 inventory isn’t as advanced as Level 3 inventory and as a result, most of the elements you need to evaluate involve the way the system works (as opposed to the data it provides).
Setup
Any inventory system you use is going to require that you enter the items your bar carries into the system. Many systems that don’t use barcode scanners are going to require that you type the name of the product into the system. This is an inefficient way to address setting up your system, and it will provide a poor user experience:
Systems that use barcode scanners provide a much simpler process:
Bar-i’s counting system comes preloaded with the barcodes for over 25,000 items. This provides a fast, accurate and efficient way to set up your system.
Counting
An important part of the inventory process is counting the bottles behind the bar and in your storeroom. It’s important to think about the counting system used by the different inventory options you’re considering.
In order to experience the benefits of level 3 inventory, you’ll need data that is accurate to a much higher level of detail (down to the serving level, which is typically 1.5 oz. for cocktails). This requires the use of a precise measuring device. We feel that scales provide the best method of measuring your products to the level of detail necessary to generate accurate analytics data while also providing a fast and easy user experience.
Pricing
In order to calculate your liquor cost, you need to first determine the value of alcohol being poured during the inventory period. The easiest way to do that is to measure how much alcohol (in dollars) you had at the start of the period, how much (in dollars) you had at the end of the period and take the difference. Figuring out this value involves multiplying the number of bottles you have by the price of a bottle.
You need to have a way to get the price of these bottles entered into your inventory system. Normally this will come from your purchase invoices. With Bar-i’s pro version, you scan these invoices into the system and we update all the prices every time you count your inventory.
Delivery Values
Therefore, you need to have a method for figuring out how many dollars you spent purchasing your products. You need to be able to break up the different items on the invoice to figure out exactly how much of the total dollar value of the purchase was draft beer, bottled beer, liquor and wine.
This task is often handled by accounting platforms such as QuickBooks, but it’s important that you’re able to determine how much was purchased for each of these product categories during the inventory period. When evaluating inventory systems, you’ll need to think about the process used to get those purchase amounts into the system.
Sales by Category
Once you’ve worked out the value of the amount of product poured for each category during the period, you need to divide this figure by the total dollar value of sales. All modern POS systems will split your sales into these categories for you, making it an easy process to determine your total sales by category (draft beer, bottled beer, liquor and wine). Bar-i integrates with over 40 POS systems, allowing you to automate this process.
Ordering
Analytics
Level 2 inventory systems only offer basic analytics data. Mainly, you’re getting your liquor cost broken down by category. This is useful to help you spot trends, such as whether your liquor cost is rising or falling over time.
You may also be able to get a few advanced metrics with level 2 inventory systems. Some of these options will allow you to look up how much inventory you have on-hand as a percentage of what you use each week. From our experience, we’ve found that well-run bars keep less than four times the amount of inventory they use each week on-hand. You should look for a system that provides these types of advanced metrics since it will enable you to run your bar more efficiently.
If you’d like to learn more about how Bar-i can help you streamline your operations and boost profits, please contact us today to schedule a free consultation. We serve bars and restaurants nationwide from our offices in Denver, Colorado.