Cafe Menu & Drink Pricing Calculator

You didn't open a cafe to do math. But here's the thing — every drink you sell without knowing your actual cost is a small bet you're making with the business. Sometimes you win. Sometimes you're the busiest broke cafe in town, wondering where it all went.

Pricing by feel, or by what the shop down the street charges, isn't a strategy. This calculator is. You enter your ingredients, your quantities, your margin target — and it tells you exactly what every drink costs to make, what to charge to be profitable, and what you're actually keeping. No guessing. No hoping. Just numbers you can act on.

What's Inside

• Ingredient Costs tab — 20 pre-loaded common cafe ingredients with retail and wholesale cost per unit; update them to your actual supplier prices and everything recalculates automatically. Add your own ingredients anytime.
• Drink Builder tab — 12 pre-built drink recipes with real quantities (lattes — including vanilla, hazelnut, caramel, and lavender oat — plus matcha, chai, cold brew, iced americano, and cappuccino); enter ingredient amounts and your cost of goods calculates instantly. Build unlimited custom drinks.
• Pricing & Margins tab — set your target gross margin %, see the minimum sell price to hit it, then enter your real prices to read gross margin % and food cost % side by side, profit per drink, and estimated daily revenue and profit by item. Traffic-light flags (green / amber / red) show at a glance which drinks clear your target and which need a rethink.
• Instructions tab — step-by-step guide with operator tips from real cafe experience.

🎁 Free bonus included: Price-Increase Scripts & Seasonal Pricing Sheet

Raising prices is the hardest easy money in cafe ownership. This print-ready bonus gives you three fill-in, customer-facing scripts to do it without losing regulars — an in-store sign, a social post, and a line for the counter — plus a seasonal re-pricing checklist that ties straight back to the food-cost targets in your calculator.

What it does for you

• Know what every drink actually costs you
  • COGS calculated automatically as you build each recipe
  • Pre-loaded ingredients mean you're pricing within minutes, not hours
  • Update supplier prices once; every recipe recalculates instantly
• Set prices you can defend — and profit from
  • Your target margin drives the minimum sell price, not guesswork
  • See gross margin % and food cost % together — the number read every way a supplier or partner will read it
  • Traffic-light flags catch the drinks quietly bleeding margin before they cost you a season
• Make smarter menu decisions
  • Compare profitability — plus daily revenue and profit — across your whole drink menu at a glance
  • Identify which items to push, which to rethink, and which to cut
  • Built for pre-launch planning and ongoing menu audits alike

Less than one wasted ingredient order pays for this.

One mispriced signature drink, multiplied by a hundred cups a week, is real money walking out the door. This stops that.

Buy once, get every update free — for life.

We're always improving these tools. When we do, you get the upgraded version free, delivered by email through our store — even if the price has gone up since you bought. This isn't a one-time purchase — it's an investment in you and your business, and it only grows in value over time.

Format: editable Excel workbook (.xlsx), plus a print-ready PDF bonus. Instant download — works on Mac & PC.

Price with confidence, not crossed fingers.

Instant download: your files are available the moment your payment is confirmed. Because these are instant digital downloads, they aren't eligible for returns, exchanges, or cancellations — but if anything's wrong with your order, reach out and we'll make it right.