A Handy Little Calculator
Here tis!! A handy little drinks quantity and estimated spend calculator (which I’d recommend using on a tablet or computer).
But before you get stuck in, please note: This calculator is to be used as a guide only and is based on an average price per item, and 1 drink per person, per hour. Its goal is to simply give you a ‘rough estimate’ of quantities and spend.
IMPORTANT: Please only edit the purple and red boxes and be sure not to delete or change anything else (otherwise it won’t do its thang properly).
How To Use The Calculator
1. UNDER ‘EVENT DETAILS’: Type your total guests, and then nominate how many of your guests will primarily drink in each category. People will likely switch drinks throughout the event, so treat this as ‘their first preference’.
2. UNDER ‘DRINK PREFERENCES’: Break the previous numbers down into more specific drink types, for each category, and if you aren’t keen on a particular drink type, just leave it blank.
3. THE RED BOXES: Select ‘low’, ‘mid’ or ‘high’ for the wine options. These options will enable the estimated spend to factor in a ‘more budget-friendly’ (low = around $20), ‘middle range’ (mid = around $30) and ‘more boujee’ (high = around $40) per bottle. The ‘shopping list + estimated spend’ section will automatically populate as you fill in the boxes.
4. SEND IT: Click ‘File’, ‘Email this file’ and send it to yourself (please also include: cheers@thebarboy.com)
5. It’s as easy as that! You can now use this list to ‘go shopping’ and select more specific items within each drink category.
And finally, this calculator does not factor in cocktails, but if you need a hand with OR if there are any other drink types you had in mind that aren’t listed below, please let me know! 🥂