Cocktail & Mocktail Math: Ratios, Dilution, Drink Strength, Batched Recipes & Party Quantities
Mix by the numbers: balanced ratios, dilution from ice, drink strength, batched recipes and how much to buy for a party, with every cell checked as you go.
One-time payment · lifetime access · lessons, labs, exam and certificate included · no subscription.
About this course
This course turns drinks planning into clear spreadsheet steps. You convert recipes written in parts into millilitres, check the sweet-to-sour balance and scale drinks to other glasses. You look up dilution factors for shaken, stirred and built drinks, test whether each drink fits its glass and calculate strength after dilution, always with an alcohol-free twin beside the cocktail. Then you batch recipes with pre-dilution water, round ingredients up to whole bottles, split syrups by weight, plan servings, ice and glasses for events, cost every drink with XLOOKUP and build a shopping list with SUMIFS and a spend chart. Every cell is checked as you go.
Lessons
- Recipe Ratios: Parts to Millilitres, Sweet-to-Sour Balance & Glass Sizes Pro
- Dilution: Shaken, Stirred and Built Drinks and Will It Fit the Glass? Pro
- Drink Strength: Alcohol by Volume Before and After Dilution, Cocktail vs Mocktail Pro
- Batched Recipes: Servings, Pre-Dilution Water, Bottles and Dispensers Pro
- Homemade Syrups by Ratio: Sugar to Water by Weight and the Yield in Millilitres Pro
- Party Quantities: Servings to Prepare, Alcohol-Free Share, Ice and Glasses Pro
- Cost per Drink & Menu Prices: Cost per ml, Recipe Lines and a Target Cost % Pro
- Shopping List & Dashboard: Totals by Ingredient, Packs, Budget and a Spend Chart Pro