Restaurants operate on razor-thin margins — typically 3-5% net profit. Yet most restaurant owners I've talked to price their menu by gut feeling.
"The burger costs about $4 to make, similar places charge $14, so we'll charge $13." That's not pricing. That's guessing.
The Real Cost of Guessing
Here's what most restaurant owners miss:
1. Yield Loss
You buy 1kg of raw chicken. After trimming, deboning, and cooking, you have ~650g of usable meat. That's a 35% yield loss that most people don't factor into their cost per dish.
2. Waste & Shrinkage
Industry data says restaurants waste 4-10% of purchased food. That's money going straight to the trash — and it's invisible if you're not tracking it.
3. The "Popular But Unprofitable" Trap
Your best-selling dish might be your least profitable. Without calculating exact food cost per dish, you might be promoting items that lose money with every order.
Menu Engineering: A Framework That Works
Menu engineering is a real discipline used by successful restaurant chains. It categorizes every dish into 4 types:
| Category | Popularity | Profitability | Action |
|---|---|---|---|
| Stars | High | High | Promote heavily |
| Plowhorses | High | Low | Raise price or reduce cost |
| Puzzles | Low | High | Better placement, rename |
| Dogs | Low | Low | Remove from menu |
Most independent restaurants have never done this analysis. When they do, it's eye-opening.
What I Built
I created a spreadsheet that does all of this:
Ingredients Database — Enter your ingredients with current costs. When prices change, update once and every recipe recalculates.
Recipe Costing — Break each dish into ingredients with quantities. Includes yield percentage adjustment (raw → cooked weight). Gives you exact cost per serving.
Menu Pricing — Shows food cost % per dish with color-coded alerts:
- Green: under 30% (healthy)
- Yellow: 30-35% (watch it)
- Red: over 35% (losing money)
Plus automatic Star/Plowhorse/Puzzle/Dog categorization.
Waste Tracker — Log daily waste with reasons (expired, overproduction, damaged). See weekly and monthly totals. This single feature helps most restaurants save 2-5% on food costs.
The Numbers That Matter
| Metric | Target | Reality (most restaurants) |
|---|---|---|
| Food cost % | 28-32% | 35-42% |
| Waste % | Under 4% | 6-10% |
| Menu items analyzed | 100% | 0% |
A restaurant doing $500K/year in revenue with 38% food cost instead of 30% is leaving $40,000 on the table annually.
Try It
The spreadsheet is available in English and Portuguese (BR), works in Google Sheets and Excel.
Restaurant Menu Costing Calculator — $25
Includes: ingredient database (20 items pre-filled), recipe costing with yield %, menu engineering matrix, waste tracker, and dashboard.
For a restaurant owner, this pays for itself after catching one week of waste.
If you run a restaurant or food business, what's your current food cost percentage? Do you track it per dish or just overall? Curious to hear from people in the industry.
Top comments (0)