Bottle Pricing Spreadsheet

See more General

Update: Since there seems to be some confusion among non-bartender types, this spreadsheet is only for pricing out individual bottle shots. If you’re looking to price out a whole cocktail, please refer to this post for the appropriate spreadsheet.

Hey guys

Jimmy from Florida just wrote in for the VFW hall he’s managing (I’m a sucker for helping out anyone working at a VFW hall, my second bartending job was at the VFW in Eugene, Oregon) and asked if he could use my How to Price a Cocktail Menu spreadsheet to price out shots from individual bottles.

Definitely, but it would be much easier if I just provided you all with a spreadsheet dedicated to just that one task.

So without any fanfare or a long explanation, here’s the file:

If you have any questions feel free to post them in the comments below!

18 Replies to “Bottle Pricing Spreadsheet”

  • Andres says:

    Question, for your spreadsheet are you using retail bottle prices or your actual bottle cost? Perhaps it’s a silly question but the prices on the spreadsheet appear to be retail.

  • David C says:

    It shows in the formula you’re multipling by 33. something. Is this supposed to be the OZ per bottle? For a 750 shouldnt it be 25? Thanks!

  • Craig Stansbury says:

    I just joined a VFW in Omaha, NE last week. I would kill if you were behind the bar making cocktails. None-the-less, I’m glad I joined and hoping to give back to the veteran community that gave me so much!

  • Joey DeVito says:

    I really appreciate the response! Enjoy the weekend! Ill check this out.

  • Joey De Vito says:

    Dude! Thank you!!! This is awesome, and as always thanks for always sharing info! In terms of pricing cocktails with multiple components, i.e. bitters, citrus, base spirit, modifier, etc., what’s the best way to price a cocktail? Do you have a spreadsheet that you use to calculate what the cocktail costs and that determines the price that would be appropriate to charge based on target pour cost? What’s the best way to price a cocktail with multiple ingredients?

  • Philip says:

    Looks like dividing by 3 with extra steps 😉

    • That’s one way to think about it, I suppose. Not all bottles are 750 ml, so that’s customizable. Target pour cost is program-dependent, so that’s customizable. Not all shot pours in all bars are 2 oz, so that’s customizable.

      Those are just a few of the reasons why we use spreadsheets instead of oversimplifying a complex bar program down to “divide by 3 with extra steps”

  • Garrett says:

    This is interesting. You use “Target Pour Cost” which is essentially an inverse of your cost-price markup. The way I see it is that you are specifying the yield of the bottle at which you would breakeven. How is it useful to structure the metric that way? Though, at least in terms of underlying reasoning, it seems to me to be about as clear to do that as it would to say, “I do about a 4x cost markup.” Perhaps you’ve left me yearning for that long explanation you eluded to.

  • Mark says:

    Awesome. Thanks!

  • Mark says:

    Is there a reason the target pour cost varies per bottle??

    • Oh! Yes, I hand adjust sometimes when I think a pour is coming in too low or too high. Sometimes the computer wants me to charge $16 for a whiskey that nobody is going to pay more than $10 for. And other times it’s telling me to price our well liquor at $3 a pour and that won’t work either.

      I’ll probably go in and change the target pour cost to a fixed percentage. Thanks for the reminder.


    You are my hero!

Leave a Reply

Your email address will not be published. Required fields are marked *