ON BAR MANAGEMENT
  • Home
  • Posts
  • Resources
  • Contact

The only batching spreadsheet you'll ever need

11/15/2020

0 Comments

 
Picture

The batching spreadsheet Download

Picture
This sheet eliminates all of the headaches that come with batching. You're going to save so much time and make fewer mistakes compared to doing your calculation by hand.  This sheet can be extremely useful to bars that feature batching in their cocktail programs regularly, or for bars that are batching cocktails for the first time as part of their togo drinks program. . It currently supports drinks with 2-8 ingredients. 
There are 3 built in calculators on this sheet with unique functions.
  • The first calculator is for when you know the final number of bottled cocktails you'd like to make but are unsure how much batch you need for that.
  • The second calculator is for situations that come up when you have a set amount of one product (lets say 500ml) and you want to know how much of every other ingredient you need to add.
  • The last calculator will tell you the batch recipe based on a final ending volume. All are extremely useful in different scenarios and come up all of the time during batching. 
To use:
  1. Copy cells from the "Template" Tab, to the "Your Drinks" tab.
  2. Replace the sample data with the single serve cocktail recipe.
  3. Determine which of the 3 calculators you want to use and plug in your data.

Note: Only edit the yellow cells. Once you are on the google sheets page, you'll need to select File> Make a copy in order to edit the file.
0 Comments

How much Should you charge guests for breaking glassware?

11/13/2020

0 Comments

 
Picture

Glassware Audit Calculator Download

Picture
     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)
0 Comments

HOW MUCH FRUIT DO I NEED to JUICE?​ And other questions answered

11/2/2020

0 Comments

 
Picture

Juice Yield Calculator Download

Picture
How much juice will this fruit make? How much fruit do I need to make a set volume of juice? ​This calculator answers those questions and more.

How it works:
To start off, you can use provided data in Juice Yields in first section, or follow the below steps to estimate the yield of your fruit:

Step 1. Weigh the whole fruit
Step 2. Juice the fruit
Step 3. Measure Juice Volume

The first calculator takes into account the starting weight of the fruit and the volume of juice that fruit yielded. The yield is determined on a per gram basis and multiplied by the provided "Weight of Fruit".

The second calculator, works by dividing "Juice Needed" by the yield calculated in the setup step. 

Remember:
Make yourself a copy of the spreadsheet so you can edit it: File > Make A Copy
Only Edit Yellow Boxes
0 Comments

How much do you stand to gain by reducing waste in your bar?

10/26/2020

0 Comments

 
Picture

Bar Waste Calculator Download

Picture
This spreadsheet shows the financial impact waste has on your bar.
  • Calculates your bar's Juice Pars based on weekly and daily use.
  • Tracks Daily Waste, YTD Waste, and Projects Yearly Fruit Waste, Juice Wasted, and Money Wasted by over producing juice (or any other ingredients) in your bar.
  • Logs YTD pieces of Fruit wasted, $$$ spent on wasted juice, and Volumes of juice not used.
  • Figures out your Juice and Fruit cost
  • Calculates Daily Pars​
See how much you stand to gain by reducing your waste.
0 Comments

Find your most profitable shifts

10/19/2020

0 Comments

 
Picture

Tip Tracker Spreadsheet Download

Picture
How much money have I made this year? Which days do I make the most tips? 
This spreadsheet tracks your YTD earnings, and provides the average tips earned each day of the week. 
​
0 Comments

      ​MAILING LIST

    Join!

    Archives

    December 2020
    November 2020
    October 2020

    Categories

    All
    Batching
    Carbonation
    Earnings
    For Staff
    Glassware
    Home Bartenders
    How-To
    Inventory
    Juice
    Prep
    Spreadsheets

    DON'T MISS OUT!

Subscribe to Newsletter
@OnBarManagement
​© COPYRIGHT 2020. ALL RIGHTS RESERVED.
  • Home
  • Posts
  • Resources
  • Contact