Menu Pricing Calculator
About This Resource
Pricing your menu correctly is the single highest-leverage activity for restaurant profitability. This Excel template takes the guesswork out of pricing with built-in formulas that calculate food cost percentages, contribution margins, and break-even points for every item. The scenario testing feature lets you model price changes before implementing them, and the psychological pricing guide helps you present prices in ways that increase average check size.
What's Included
Who Is This For?
Restaurant owners and managers who want to maximize profitability without guessing. Especially valuable for restaurants with food cost percentages above 30% or those planning a menu redesign.
Quick Start Guide
- 1Enter your ingredient costs in the Cost Calculation tab
- 2The template automatically calculates optimal prices per item
- 3Use the Scenario Testing tab to model different pricing strategies
- 4Apply the Psychological Pricing tips to your menu design
The Resource
The Menu Pricing Formula
Menu Price = Raw Food Cost ÷ Target Food Cost Percentage Example: If a dish costs $4.50 in ingredients and your target food cost is 30%, then: Menu Price = $4.50 ÷ 0.30 = $15.00 This is your starting point — then adjust based on market positioning, perceived value, and competition.
Step 1: Calculate Your Raw Food Cost
- 1List every ingredient in the dish with its purchase cost and unit size (e.g., chicken breast: $3.99/lb)
- 2Calculate the cost per portion (e.g., 8oz portion = $3.99 ÷ 2 = $2.00)
- 3Add all ingredient portions together for the total raw food cost per plate
- 4Include garnishes, sauces, and sides — everything that goes on the plate
- 5Add 5-10% for waste and over-portioning to get your realistic food cost
Target Food Cost by Restaurant Type
| Restaurant Type | Target Food Cost % | Typical Range |
|---|---|---|
| Fine Dining | 28-32% | $35-100+ per entrée |
| Casual Dining | 30-35% | $15-35 per entrée |
| Fast Casual | 28-32% | $10-18 per entrée |
| QSR / Fast Food | 25-30% | $5-12 per entrée |
| Pizzeria | 25-30% | Ingredients are low-cost, high perceived value |
| Bar / Pub | 20-25% (drinks) | Alcohol has the best margins |
Pricing Psychology Techniques
0/7 completed
The Contribution Margin Method
Food cost percentage isn't the only metric. A $30 steak with 40% food cost ($12 cost) gives you $18 contribution margin. A $12 pasta with 25% food cost ($3 cost) gives you only $9 contribution margin. The steak puts more actual dollars in your pocket despite the "worse" food cost percentage. Track both food cost % AND contribution margin for every dish. Promote high contribution margin items, not just low food cost % items.
Pro Tip
Re-cost your top 10 selling items every quarter. Ingredient prices fluctuate — a dish that was 30% food cost 6 months ago might be 36% today. Small creep across many items adds up to thousands in lost margin annually.
Frequently Asked Questions
Yes — the template is compatible with both Microsoft Excel and Google Sheets. Some advanced formulas may display slightly differently in Sheets but all calculations work correctly.
The calculator includes industry benchmarks by restaurant type. Generally, aim for 28-32% for full-service restaurants and 25-28% for fast casual. The template will flag items outside your target range.
Yes — there's a separate tab for beverage pricing with different margin targets and pour cost calculations built in.
Menu Pricing Calculator
Excel Template · 30 min setup
Download coming soon — document is being finalized.
Related Resources
View allCost Control Checklist
Track and manage food costs, labor costs, and overhead systematically.
Menu Engineering Worksheet
Analyze menu items by profitability and popularity to optimize offerings.
Digital Menu Design Guide
Best practices for digital menus that drive orders and enhance UX.