See your Top 3 profit leaks in seconds. Calculate beverage cost %, gross profit, and pricing gaps for your flat whites, brunch, and all-day menu—all in Google Sheets™.
Copy uses Google's standard screen to create a duplicate in your Drive. The original template is read-only.
Report Preview (Top 3)
Flat White · Smashed Avo · Açaí · Brunch
Quick analysis of your cafe menu pricing and beverage costs
Add your drinks and food with prices. Pre-filled with Sydney cafe samples—flat whites, cold brew, smashed avo, açaí bowls, and all-day brunch.
Auto-calculates cost per drink, beverage cost percentage, and gross profit. Includes specialty beans, alternative milks, and brunch ingredient costs.
Instantly identifies your 3 biggest profit improvement opportunities—often brunch specials or avocado-heavy items with hidden costs.
⚠️ Note: This template shows your Top 3 items only—a preview to validate the approach works for your menu. For full menu analysis, install MenuGauge AI.
Get your Top 3 profit improvement opportunities in minutes
Click "View the template" to preview the spreadsheet layout and sample data. No sign-in required to browse.
Click "Copy to your Drive" to create your own copy. Replace sample data with your actual menu items, prices, and ingredient costs.
Check the Report Preview tab to see your Top 3 profit leak items. Ready for full analysis? Install MenuGauge AI.
💡 Sydney tip: Avocado prices swing $2-8/kg seasonally—track your smashed avo cost weekly and consider a seasonal price adjustment or portion control!
5 tabs designed to get you from data entry to insights
Sample data reflects Australia's world-famous cafe culture
Flat white, long black, piccolo
Smashed avo, eggs benny, big brekkie
Açaí bowls, smoothies, granola
Pastries, toasties, salads
📝 Sample data is just a starting point. Replace it with your actual menu—the formulas adapt to your items.
What this template can and cannot do
Go beyond Top 3—get complete menu intelligence in 30 seconds
Analyse 50 items (Plus) or unlimited items (Pro). See every profit opportunity, not just the top 3.
Auto-generated price ranges based on your location and industry. Know where your prices stand.
Re-analyse weekly as costs change. Track priority improvements over time with review scores.
Everything you need to know about this template
View the free template, copy it to your Drive, or install MenuGauge AI for complete analysis.
Copy uses Google's standard screen to create a duplicate in your Drive. The original template is read-only.