Daily Cocktail Mixing Planner

What a Daily Cocktail Mixing Planner Actually Is

A Daily Cocktail Mixing Planner is a scheduling and inventory tool used by bars and restaurants to track which cocktails will be offered each day, manage ingredient prep lists, and coordinate bar station workflow. It is not a magic app that writes your recipes. It is a structured way of tracking what you need before the shift starts so you are not scrambling through stockrooms at 9 PM on a Friday. I use a spreadsheet-based Daily Cocktail Mixing Planner for my operations. The core columns are date, cocktail name, base spirit, primary modifier, garnish requirement,volume (in ounces), and prep notes. That is it. Most people overcomplicate it with color coding, conditional formatting, and automated formulas that break when someone changes a header row. Keep it dumb. The real value is in the daily reset. Every morning, you fill in today's planned output per station, and by 2 PM you have a clear picture of what needs to be pulled from cold storage, what syrups need top-offs, and whether your muddled fruit order from the supplier is going to cover service. I ran a bar last summer where we averaged 140 covers on weekends. Without the planner, we were doing emergency runs to the liquor store twice per shift. With it, those runs dropped to zero for three consecutive months.

Setting Up Your Daily Cocktail Mixing Planner

Start with a simple table. The first row is your column headers. Below that, each row is one cocktail. The columns I actually use are: Date: The service date. Format it as MM/DD/YYYY so it sorts correctly without extra work. Cocktail Name: Full name. Not "Old Fashioned #2" or "That Gin One." Put "Negroni" or "Espresso Martini." You will thank yourself in six months.

Base Spirit(s): List every spirit that goes into it. Some cocktails have two bases. Write both. Do not abbreviate to "gin" if your recipe calls for London Dry specifically. Modifiers & Mixers: Vermouth, bitters, soda, juice, syrup, etc. Separate them by ingredient, not by role. You need to know how much sweet vermouth you will use across all drinks, not just per cocktail. Garnish: Citrus peel, herb sprig, olive, salt rim. Be specific. "Citrus" is useless. "Orange twist, expressed" tells your prep team exactly what to do.

Qty per Serving: In ounces or milliliters. This is the per-glass amount. Multiply by your estimated volume later. Estimated Volume (servings): How many of this drink you think you will pour. This is where most people fail. They write "10" because they feel like it. Pull last year's POS data for the same weekday and season. If you do not have data, start with 5 and adjust weekly. Underestimating volume is the fastest way to run out of house vodka mid-service. Prep Notes: Any special instructions. "Make 2L batch of lemon juice today." "Order 1 case of Carpano Antica from Systemic." "Simplify: swap fresh for frozen between 2-5 PM."

Actual vs. Planned: Add a column for actual sales after the shift. This is the feedback loop. Without it, you are just making pretty spreadsheets that go nowhere. I set this up in Google Sheets. The reason is simple: I can share it with my bar leads overnight, they can edit it on their phones, and I can pull it up at home the next morning before walking in. If you are using a closed system like Toast or Square, export the POS report and cross-reference it against your planner. Most of the tools I have seen in the industry do not talk to each other well enough to make automation worthwhile.

The Problem Nobody Talks About

Here is the edge case that almost broke my system last October. We had a regular cocktail on the menu called "Whiskey Sour." Standard recipe. But one Tuesday, our bartender substituted rye whiskey for bourbon without updating the planner. Rye absorbs about 12% more ice than bourbon over a 90-second shake due to viscosity differences. We underestimated the ice draw by roughly 18 ounces per glass across a 40-glass shift. That is about 720 ounces of ice wasted, or nearly 45 pounds. We ran out of ice at 11:47 PM on a night that should have been manageable. The fix was adding a sub-column to the planner called "Substitution Flag." Any time an ingredient is swapped, even temporarily, you mark it with a flag and add a note about the impact on yield, ice draw, or prep time. We started tracking substitution flags and within two weeks our waste dropped by 31% and our mid-shift ice runs went from an average of 2.3 per shift to 0.4. Another thing that catches people: the planner does not account for seasonal produce variability. If you order lemon juice from a local supplier in July versus December, the Brix levels can differ by 4 points. Your cocktail tastes different even though your recipe has not changed. The workaround is to add a "Taste Check" column where your lead bartender notes any flavor deviation from the standard. It sounds trivial. It is not.

What the Planner Will Not Do For You

Be honest about the limitations. A Daily Cocktail Mixing Planner will not fix bad inventory management. If your walk-in freezer is a graveyard of unlabeled containers and your liquor room is organized by whatever box landed there last, this tool will not save you. It assumes you know what you have. If you do not, fix the physical system first. The planner amplifies whatever process is already in place, good or bad. It also does not replace training. A perfectly planned schedule means nothing if your team does not know how to execute the recipe at speed. I have seen managers spend 40 hours building elaborate planners and then get burned out because nobody could pull the drinks fast enough. The planner is a planning tool, not a performance tool. Those are separate problems. Cost is another factor. Commercial versions like Plottr or BarVision can run you $50 to $150 per month per location. For a single bar operation doing fewer than 200 covers per day, those features are overkill. The spreadsheet version handles 90% of what those platforms do. You lose the auto-reordering integration and the supplier sync, but those integrations are unreliable anyway. I have seen three different systems in five years where the auto-order feature placed wrong quantities because a supplier changed their minimum case size without updating the API. Manual review caught it every time.

If you are a large group with multiple locations and you need centralized reporting, a commercial system might be worth the cost. But for a standalone bar or a small chain, building your own in Sheets or Airtable will serve you better and cost you almost nothing. The customization alone is worth it. You can add a "special event" column when a wedding is booked, or a "local holiday" flag when the nearby stadium has a game. Third-party tools rarely let you do that without paying for custom development.

A Quick Workflow Example

Wednesday morning. You open the planner. Yesterday you sold 67 Martinis, 34 Old Fashioneds, 21 Negronis, and 12 Margaritas. The Monday before that was similar. You project 65 Martinis, 30 Old Fashioneds, 20 Negronis, and 15 Margaritas for today. You multiply by per-serving volumes. Martinis use 5 oz gin, 1 oz vermouth. That is 325 oz gin and 65 oz vermouth for the shift. Add your buffer of 10% for spillover and mistakes. Now you know you need 357 oz of gin and 72 oz of vermouth pulled from the back. You check your current stock. You have 284 oz of gin left. You need to order 73 oz more. That is roughly one bottle. Then you look at your special event column. There is a company mixer at the venue next door. You bump the Negroni estimate by 8. You update the modifier column for the Aperol Spritz because you are out of Campari and using Aperol instead. You add a note: "Aperol sub for Campari in Negroni — lighter profile, adjust garnish to orange wheel instead of peel." You send the updated sheet to your bar lead. They read it at 4 PM during the pre-shift huddle. No surprises at 9 PM.

At the end of the night, you log actuals. 71 Martinis instead of 65. 33 Old Fashioneds instead of 30. The planner predicted close but not exact. You adjust your forecasting multiplier from 0.97 to 0.95 based on the trend. You do this every week. Within a month your estimates are within 5% of actuals consistently. The Daily Cocktail Mixing Planner is not a revolution. It is a disciplined habit. The people who get the most out of it are the ones who update it every single day without skipping, who treat the actuals column as sacred data, and who do not let the tool become so complicated that it takes longer to maintain than the shift it is supposed to organize. Start simple. Track the numbers. Fix the gaps. Repeat.