Free liquor inventory spreadsheet This video will walk you through 7 features of Bar-i’s free liquor inventory software. Bar Inventory Spreadsheet: Calculate Liquor Costs for Your Venue To manage your bar efficiently and profitably, it’s vital to understand exactly how much you’re spending—and to learn how to predict how much you’ll bring in. Leave a Reply Cancel reply. Caluculating, Controlling, and Understanding Liquor Pour Cost Controlling the Pour of Liquor is Vital to Maintaining Quality and Cost. In one column, include every specific bottle of liquor being stocked at your store. We'll use all these terms interchangeably through this guide. The liquor inventory templates offer great benefits, it help to ease your burdens. 4+ personal finance spreadsheets 6+ accounting spreadsheet for small business 5+ personal financial spreadsheet. Use the Pour Cost Percentage Worksheet to help you take basic figures (like purchases and gross sales) and determine your pour cost percentage for liquor, wine or beer. So it is basically a list that has some information about the stock of the liquor that your store has, the formats that are usually on this spreadsheet are bar name, liquor type or brand name, units, open bottles, full bottles in bar, full bottles in the storage, cost per bottle, and total cost. The liquor inventory templates offer great benefits, it help to ease your burdens. The recipe cost calculation excel spreadsheet obtains the expense that each dish carries and the margin it would obtain with the final price to be charged.

It is the handy tool available in PDF & word format, these templates offer chances to fill in design.You can also see Food Inventory Template. liquor cost spreadsheet.spreadsheet.jpg. For example, if a bar depleted $5,000 of liquor in January and had liquor sales in January of $25,000, their liquor pour cost for January would be 20% ($5,000 ÷ $25,000).

The Pour Cost Percentage Worksheet is available in the Microsoft Excel (xls) file format. A bar's Achievable Liquor Cost is what their liquor cost would be if they had 0% shrinkage. Tweet Pin It. If you have a store that has liquor as the beverage option, you must need liquor inventory spreadsheet. Award-winning mixologist, freelance cocktail columnist, and author of the book "Whisky Made Me Do It." Written by. Account for the cost of each individual item, or the cost of produce purchased in bulk like lemons and apples, and find out your juice cost in the same manner you find out your liquor cost.

For example, if a bar depleted $5,000 of liquor in January and had liquor sales in January of $25,000, their liquor pour cost for January would be 20% ($5,000 ÷ $25,000). Speed Count Setup 2 – Equipment options; Speed Count Setup 3 – Make the Map; Speed Count Setup 4 – Instructions fill in Product info; Speed Count Setup 5 … Open your spreadsheet software. Lance Mayhew. liquor cost spreadsheet for everyone excel free . Establish Pour Sizes and Pricing . Pre-built Excel template file with pricing formulas. Make the job easy with this a bar inventory template that does the math for you. For example, if 8 pineapples yield 2 quarts of pineapple juice, and each pineapple costs $1.00, then 2 quarts, or 64 oz. Pour cost is calculated by simply adding up the cost of the product used and dividing it by the cost of the product sold. Lance Mayhew. You can find spreadsheet entry jobs by looking on the Internet, or by registering with recruitment and staffing agencies. 16+ Liquor Inventory Templates – Free Sample, Example, Format Download If you have liquor store consider using the liquor inventory template to manage all the assets in proper manner. Liquor cost is also referred to as pour cost and beverage cost. Food Cost Calculator Spreadsheet– Recipe Cost Calculator.