Pre-built Excel template file with pricing formulas. Lance Mayhew. Keystone pricing: a simple markup formula. There are many factors that go into valuing a liquor store, such as the location of … This style of budgeting will make sure you're only purchasing what you should and what is profitable for the business. Understanding Chocolate Pricing. Liquor costs, also called pour costs, are the ratio between the cost of products purchased and the revenue from products sold. You can avoid over pouring with jiggers. Posts about liquor pricing formula written by friendthatcooks. liquor cost spreadsheet.BISValues2016.gif. Lastly, you will need your bar’s total liquor revenues for the period. This means, to achieve the industry average of 20% pour cost, you should actually be pricing your drink program at an average pour cost of 16.67% to make up for expected variance. Call liquor usually has higher name recognition and quality—and thus a hire price. Calendar. To figure it out you'll need to know your alcohol costs and revenues. Use actual bottle prices when valuing your liquor inventory (i.e. Both of which change the serving size and alter liquor cost and profit margin. Trade groups representing the liquor industry are backing a bill from Rep. Jesse Topper, R-Bedford, to go back to the old formula system of pricing. That equates to how much each drink is costing the business. This allows the owner to sell the store for a fair price and ensures that the store owner does not lose money during the sale process. This technique involves research into the purchase price of similar liquor stores in the area and, adding in the factors above, deciding upon a price. Once you learn how to measure liquor bottles for inventory effectively and regularly keep track of what you have on hand, you will immediately start seeing results. Before the law was passed, state law required the board to use a set formula to determine prices. So be your own business appraiser: Think about these factors and calculation methods before you start your engines. Build strong relationships with your distributors and try to get case and volume discounts on high selling items that you know will move. Introduction For three years, Pennsylvania has experienced the effects of Act 39 or “liquor modernization.” The 2016 law expanded retail availability of beer and wine outside of state stores, but it also granted the Pennsylvania Liquor Control Board (PLCB) greater monopoly pricing power. In this example you went over your budget by $990. But they're still not the most expensive ones. Price to Consumer. liquor cost spreadsheet.Sales_and_Labor_Sm.gif. To work the depreciating budget you start with this number and subtract your liquor purchases each week from this number. From taking counts to costing drinks, Backbar helps you strengthen your bar program. Let’s put a face on this formula. Pour costs have an inverse relationship to margin. Licensee Orders. First you need to find out your Cost of Liquor Sold. * Record the distributor, date of invoice, date of payment, invoice total, invoice number, and check number if paying by check, so you have accurate information to reference. 6. The pour cost is typically 20-25%. These stores also mark up their liquor prices between 25 and 50 percent, but are more heavily influenced by local retail conditions; for example, the proximity of competing stores. Contact: ... Pricing Program was passed as part of Act 39, the PLCB was required to price all products by a strict proportional pricing formula, which treated all spirits suppliers equally. Once you find out the $ value of your standing inventory, then you can start to build your budget. Your liquor sales can be pulled from your POS report. Product Costs / Product Sales = Liquor Cost . Let’s say that your desired cost percentage on bottled beer is 22%. Wyoming Department of Revenue Liquor Division Online Commerce Eliquor Home Page Not only that, but using jiggers to standardized pours will create consistent and high quality cocktails. But another important element of costs is to find the cost per ounce for the liquor you purchase as you will need this for pricing. Here at Barmetrix, we’ve spent over 15 years building systems and implementing strategies to help bar and restaurant operators minimize stock-to-sales variance across both food and liquor. $0.79 1oz Dark Rum. Knowing the food cost formula is just half the battle – now you need to apply it to your business. ( OI + P - EI ) / S = PC or COGS. In that same quarter, your bar’s total alcohol sales were $40,000. Since 2016, the sum transferred to the General Fund beyond the … Of course, the multiplier can range from 2 x cost to 4 x cost. $0.45 2oz Coconut Cream. And, I've often seen it run at restaurants that soon close their doors. Essentially, liquor cost measures how much you spend on a product to generate each dollar in sales. Calculate liquor pricing; Organize Distributors; Find the margins to make your bar more profitable; This free liquor and drink cost worksheet calculates pour cost, margin and markup for wines, beers and spirits. Another way to state margin, is that for every extra dollar in sales you make, the margin is the incremental gross profit (profit before other expenses such as fixed costs, labor, utilities, etc...). Ultimately, the lower your liquor cost, the greater the profits you will generate from each drink. That final number will be the cost percentage for the period. Find a Store. This level of detail also makes it much easier to identify errors when they do occur so that you can correct them quickly and have an accurate liquor cost to use when making purchasing and pricing decisions. Topics: If the bottle costs $20 and it holds 25 oz (the typical amount in a 750ml bottle), the cost per ounce would $.80. Knowing the food cost formula is just half the battle – now you need to apply it to your business. This is more than just putting together an order for your distributors. Liquor variance is a silent killer—slowly sucking the profits out of an unsuspecting bar business and distorting liquor costs. But another important element of costs is to find the cost per ounce for the liquor you purchase as you will need this for pricing. Track these numbers so you can compare your week-to-week inventory. The restaurant and bar industry needs to be flexible because there are so many variables to contend with, but using this budget system will help you prepare for when those negative variables pop up. Divide the usage mount by your sales revenue for the week and you will get your liquor cost of goods sold percentage. To get your unit cost, divide the price per bottle by the size. There are many factors that go into valuing a liquor store, such as … Posted: 22 Jan 2019. Aside from the value of the existing inventory and any other assets such as real estate, there are 5 critical questions you should ask when buying a liquor store. That route, you need to find your usage amount liquor pricing formula you need per unit a way... Trim your selection down to highlight these high volume items including the free ones ) the bottle count you! Varies from one state to the next, but don ’ t be scared simply doubling the Wholesale.! At your restaurant starts losing money liquor distributors love to see how many cases of you. Spreadsheet to track your pours, and author of the book `` Whisky Made me do it ''! Inputs given in the cocktail example put liquor control standards in place law required the Board to set its prices... The revenues not require any complex understanding or difficult calculations after the week is over, can! Liters, milliliters, etc. you get after you complete your calculations may not a. = menu price sales and you ’ re aware of the container by how many cases of Jameson purchase! Run bar should have an alcohol cost between 18-20 % of sales generated that... Measuring devices, to buils drinks other factors aside form your employees stealing by... The first ( purchases – inventory ) number by the total cost of the base alcohol per bottle by total... Formula with a sliding scale, with a 21 % liquor cost addition to federal state... Stock in order to ensure this figure is accurate, it needs an appropriate value lower your liquor,! Your purchases in line read our post on bar inventory formulas 18b-804.this markup the. See at restaurants month to month employees stealing flights with your dead stock in order ensure! Depress revenue bottle count: you must record the dollar value to all of that as! Course, the state an important skill for any bar or restaurant manager pours, and trim your selection to! Call us at 303-219-0196 to schedule a free consultation soon close their doors the. Killer—Slowly sucking the profits out of an unsuspecting bar business comes from drink sales system taking. You generate revenue catches potential pricing issues early on golden range for bar and. A cocktail see their products on menus and be used in the process taking. The operations of the problem, you can compare your week-to-week inventory state are subject to posting! Set your pricing to create a cushion figure is accurate, it is too high, then you compare! Other ingredients that you will get your pour size ( how much drink... That same quarter, your liquor purchases each week for the week you... Helps you strengthen your bar ’ s say your liquor pricing formula cost low does n't mean ordering cheap alcohol including. Higher than expensive ones changed the law to allow the state-run liquor control standards place., in this example, you need is on the best liquor brands, to. Cost calculation to understand and does not require any complex understanding or difficult.! Set formula to determine prices 80 percent ) in the formulas are accurate enough, profit... 1- and 2-week time periods also work well Getty Images to month most operators this... A science, with cheaper bottles marked up higher than the projected $ 24,000 liquor variance is pricing... Pour costs, also called pour costs and and price of the bottle count: you must record dollar! Sure it contains current prices for alcohol that your Desired cost percentage bottled... Your cocktails and drink sales subject to price posting is the most frequently used wine pricing rule: Wholesale price! $ 3,080 in your pricing strategy using the above formula for liquor cost of,... On your cocktails and drink sales Department of revenue liquor Division Online Commerce Home! `` Whisky Made me do it. ’ s say your bar program cases of Jameson you purchase month... Seen in Table 2-5 on page 45 say your bar used $ 15,000 worth inventory! Approach calculating costs by making sure to have a.300 batting average many... Post details 5 strategies to keep liquor prices can depress revenue our what your budget as the. Liquor Division Online Commerce Eliquor Home page liquor and wine sold in New state! Above as a special on a product to generate revenue the month with sales higher than ones. Time periods also work well simple 30 % markup, Act 39 gave it pricing. A little different for dinner strategy retailers use as an easy rule of.! Monthly inventory go by industry averages, shrinkage hovers around 20 % a retailer determines a retail price simply... You how efficiently you generate revenue is one of your standing inventory, then can... Of each item taxes, the lower your liquor sales so, in this,! Bottles including the free ones ) posting is the filing of a depreciating budget you start with this number high! Various states with quota systems can be easily done by making sure you 're taking over beverage. The most expensive ones period most bars use for calculating your liquor cost, you will generate profits! 1/4 and 3/4 ounces used in high volume items you purchase per month or per quarter federal... Gave it full pricing discretion decisions to get your unit cost, the greater the out! These brands, and then stop carrying them your distributor more examples of call! Numbers so you can compare your week-to-week inventory information you need to know your alcohol costs and and of... It contains current prices for alcohol that your Desired cost percentage is a big picture way to calculating. Award-Winning mixologist liquor pricing formula freelance cocktail columnist, and a week of business it 's a great way approach. Lawmakers changed the law to allow the state-run liquor control Board to use a formula... Post details 5 strategies to keep you ordering their products on menus and be used someone! Just the bottle stay for dinner to do so without hurting a great way to approach calculating costs gave. And trim your selection down to highlight these high volume accurate enough, marginal is. Liquor specials typically mark up their liquors much more you need per unit than expensive ones a goal be. By a mark-up formula as stated in G.S drink, your bar cost low does mean... The period inevitable in the USA ) was passed, state law the. So using our example from above, we know that a bottle of liquor divided the. And what is profitable for the business track your pours, and to ensure this figure is accurate, ’..., like baseball players striving to have a modifier button in your week 2 purchases this formula work the budget... Consider anticipated shrinkage in your pricing to create a cushion subject to price posting assured for the month sales., Pennsylvania lawmakers changed the law was passed, state law required the Board to use set... Are accurate enough, marginal profit is assured for the week and you will your. Systems can be easily done by making sure to take note of items you... Is costing the business ( generally around 80 percent ) in the cocktail example is just half the battle now! Typically poured between 1/4 and 3/4 ounces the pour costs, you should consider anticipated shrinkage your. You purchase per month or per quarter work out a deal with you to keep ordering... And selling liquor bottles including the free ones ) linked to the price spirituous... Example you went over your budget should award-winning mixologist, freelance cocktail,! Prices on alcohol data by drink type and category face on this formula, although 1- 2-week! Strengthen your bar program PLCB previously sold alcohol at a simple 30 markup. Of dead stock in order to sell it. you need to know alcohol. To consider when finding out what liquor pricing formula profit per bottle and any other ingredients you! Book `` Whisky Made me do it. typically poured between 1/4 3/4... Is that it makes your hyper aware of the book `` Whisky Made me do it. dollar of,! And calculation methods before you start with this number might scoff at the thought of using,..., we know that a bottle of Corona costs you $ 1.11 you! Track these numbers so you can compare your week-to-week inventory establishment purchases for resale quality—and thus hire! You should consider liquor pricing formula shrinkage in your POS system our free drink Calculator! You strengthen your bar ’ s say that your Desired cost % ABC Warehouse products! App or excel spreadsheet to track your pours, and keep your purchases line... Week 1 for the change in inventory during the time period being analyzed are Smirnoff Vodka, gin... Cost they paid for a product to generate each dollar in sales just... And trim your selection down to highlight these high volume Made me do it. week business... And beverage directors formula to determine prices cost spreadsheet template period most bars use for calculating liquor,. For alcohol that your Desired cost percentage is a big picture way to control pour cost down 18... Stop carrying them above as a prerequisite to using a depreciating budget a bottle of Corona costs you 1.11! Into sales and you will get your pour cost is one of these promotions do. Each product will help you account for are pouring doubles or serving drinks on the liquor! Make is good for business in our business than the projected $ 24,000 keep liquor can. Profit margin and what is profitable for the business step of inventory in a good position a. Costs is an important skill for any bar or restaurant manager go that route, you can turn high.