See your Top 3 profit leaks in seconds. Calculate food cost %, gross profit, and pricing gaps for your set meals, bento boxes, and donburi—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)
Teishoku · Bento · Donburi · Sides
Quick analysis of your bento/teishoku menu pricing and food costs
Add your meals and sides with prices. Pre-filled with Tokyo samples—grilled fish teishoku, tonkatsu set, gyudon, karaage bento, and daily specials.
Auto-calculates cost per serving, food cost percentage, and gross profit. Includes main dish, rice, miso soup, and side dish costs.
Instantly identifies your 3 biggest profit improvement opportunities—often premium fish sets or generous meat portions in popular bentos.
⚠️ 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.
💡 Tokyo tip: Rice and miso soup should be your highest-margin items—consider "oomori" (large rice) for ¥50 extra to boost margins on every order!
5 tabs designed to get you from data entry to insights
Sample data reflects Japan's lunch culture
Karaage, tonkatsu, salmon
Grilled fish, ginger pork, saba
Gyudon, katsudon, oyakodon
Salad, egg, extra rice, pickles
📝 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.