See your Top 3 profit leaks in seconds. Calculate beverage cost %, gross profit, and pricing gaps for your specialty coffee and wellness drinks—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)
Specialty · Matcha · Cold Press · Pastries
Quick analysis of your cafe menu pricing and beverage costs
Add your drinks and food with prices. Pre-filled with LA cafe samples—single-origin coffee, matcha, cold press juice, and artisan pastries.
Auto-calculates cost per drink, beverage cost percentage, and gross profit. Includes specialty beans, alternative milks, and premium add-ons.
Instantly identifies your 3 biggest profit improvement opportunities—often matcha drinks or cold-pressed juices with hidden ingredient 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.
💡 LA tip: Ceremonial-grade matcha costs 3-5x more than culinary grade—make sure you're tracking which grade you use in each drink!
5 tabs designed to get you from data entry to insights
Sample data reflects typical LA specialty coffee scene pricing
Single-origin, pour-over, espresso
Ceremonial matcha, hojicha lattes
Juice, smoothies, wellness shots
Vegan options, gluten-free treats
📝 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
Analyze 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-analyze 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.