Free Menu Engineering Matrix for Indian Restaurants
A Google Sheets template pre-built with the Star / Puzzle / Plowhorse / Dog framework. Enter your dish data and the template classifies your menu automatically.
| Dish | Selling Price | Food Cost | Portions/mo | CM | Mix % | Quadrant | Action |
|---|---|---|---|---|---|---|---|
| Dum Biryani | ₹380 | ₹95 | 420 | ₹285 | 18.9% | ⭐ Star | Feature prominently |
| Rogan Josh | ₹420 | ₹100 | 85 | ₹320 | 3.8% | 🧩 Puzzle | Reposition on menu |
| Dal Fry | ₹160 | ₹58 | 380 | ₹102 | 17.1% | 🐴 Plowhorse | Raise price ₹15–20 |
| Fusion Pasta | ₹280 | ₹130 | 28 | ₹150 | 1.3% | 🐕 Dog | Remove or reinvent |
What's in the template
Pre-built Star / Puzzle / Plowhorse / Dog classification — auto-updates as you enter data
Contribution margin calculation per dish (selling price − food cost)
Menu mix % auto-calculated from portions sold
Weighted average contribution margin threshold — set once, used across all dishes
Colour-coded quadrant output — green for Stars, orange for Puzzles, yellow for Plowhorses, red for Dogs
Action recommendation column — what to do with each dish based on its quadrant
Works with any currency — ₹ pre-set for Indian restaurants
No macros, no add-ons — pure Google Sheets formulas
How to use it
Open the template (creates a copy in your Google Drive)
Enter your dish names, selling prices, and food cost per portion
Enter portions sold in the last 30 days from your POS
The template classifies every dish and shows recommended actions
Review the quadrant summary tab for a one-page overview
Want to understand the framework first?
Read: Menu Engineering for Indian Restaurants (full guide) →Get the free template
Google Sheets · No installation · Copy to your Drive
Beyond the template?
MarginMind™ builds and maintains your full menu engineering analysis — automatically updated when ingredient prices change.
Learn about MarginMind™ →