NcmshopsCocktail Batch Calculator

Printable Cocktail Batch Planner

This drinks planner is for parties, gatherings, and any event where you need to figure out how much to serve. Enter the number of guests and the number of hours, and the sheet calculates drinks needed using a simple rule: 2 drinks in the first hour, then 1 drink per guest for each hour after. It includes columns for Guests, Hours, Drinks per guest, Total drinks, Share as cocktails (%), and Cocktail servings, with example rows like 20 guests for 3 hours.

Preview of Printable Cocktail Batch Planner

Free printable · PDF

  • 1 page
  • US Letter — choose “Fit to page” for A4
  • PDF, 71 KB
Download free PDF

Free for personal, family and classroom use.

Need to edit it? The full pack has the editable Excel and Word files plus all 4 sheets — $5.00, one-time.

Use it by filling in your guest count and event length, then review the total drinks and cocktail servings. If you plan to serve some drinks as cocktails and some as other beverages, adjust the cocktail percentage column to match your menu.

Good for

Tip: Print one copy and write in the cocktail percentage before shopping.

4 files · PDF, XLSX, DOCX

Get every sheet: Party Cocktail Batch Pack

This sheet plus 3 more in one download, with the editable Excel and Word files. Printable batch recipe cards for ten classic drinks, a party drinks planner that estimates quantities per guest, a bar shopping list and bottle labels.

$5.00 USD, one-time 4 files · about $1.25 each

7-day money-back guarantee. Full refund within 7 days of purchase, even after you download.

More free printables

Preview of Printable Cocktail Batch RecipesPrintable Cocktail Batch Recipes1 page · free PDFPreview of Printable Party Bar Shopping ListPrintable Party Bar Shopping ListPlan party bar purchases with a simple shopping list for mixers, garnishes, ice, and other supplies before batch cocktail prep.1 page · free PDFPreview of Printable Bottle Labels PDFPrintable Bottle Labels PDFFree printable bottle labels PDF for labeling cocktail batch bottles with clear names, dates, or mix details on one Letter-sized page.1 page · free PDF