Cocktail & Mocktail Math: Ratios, Dilution, Drink Strength, Batched Recipes & Party Quantities

What you'll build

What you will be able to do

Each lab ends with a concrete result that you build yourself and the checker confirms, cell by cell.

• Turn six recipes written in parts into millilitres, check the sweet-to-sour balance of each one and scale a long drink down to a smaller glass.
• Look up a dilution factor for each mixing method, work out the water from ice and the final volume, check whether each drink fits its glass with headroom and find the largest recipe a glass can take.
• Calculate the alcohol millilitres and the strength of a cocktail after dilution, set its mocktail twin beside it and work out how much extra soda a lighter long version needs.
• Scale a cocktail and its mocktail twin to a party batch, round every ingredient up to whole bottles, add the pre-dilution water and count the serving dispensers.
• Split syrup batches into sugar and water by weight, estimate the yield in millilitres and work out the batch size and sugar bags needed for the party's simple syrup.
• Plan four events from guests, hours and a planning rate: servings to prepare, the alcohol-free and cocktail split, bags of ice and glasses in full racks.
• Turn pack prices into cost per ml, cost every recipe line with XLOOKUP, add up the cost per drink for cocktails and mocktails and set menu prices at a target cost percentage.
• Turn the drinks plan for 230 servings into a shopping list: total ml per ingredient with SUMIFS, whole packs, spend, what is left of the budget and a chart of where the money goes.