Menu Engineering Spreadsheet: Restaurant Menu Pricing & Profit Analysis Template (Excel & Google Sheets)
Which dishes are actually paying the rent?
Put each item's plate cost, price and units sold side by side, and see which dishes earn their spot on your menu. Every item is sorted into Star, Plowhorse, Puzzle or Dog, with a short note on what to do about it. Built by a restaurant owner who uses it every day.
Grand Opening: 25% off through Dec 1, 2026. Use code GRANDOPENING at checkout.
What's inside
✔ Up to 40 menu items with category drop-downs
✔ Calculates food cost %, contribution margin, sales mix % and total margin per item
✔ Classifies items by formula against your averages (standard 70% popularity rule, adjustable)
✔ A "What to do" column for each class, editable in your own words on the Class Guide tab
✔ Summary box: weighted average margin, sales-weighted food cost %, count of each class
✔ Works with any POS item sales report
File you'll download
2 - Menu Pricing Sheet.xlsx
Want all four money tools? The Restaurant Money Tools Bundle adds the Food Cost Calculator, Inventory & Order Sheet and Weekly Labor Schedule: all 4 for $39 instead of $61 separately.
Instant download · print as many as you need
FAQ
What file type is it? An Excel spreadsheet (.xlsx).
Does it work in Google Sheets? Yes. It opens in Excel (Windows or Mac) and Google Sheets. No macros, no add-ins, nothing to install.
How do I use it? Every file opens on a plain-language Instructions tab. Cream cells are for your numbers; white cells calculate on their own. The sample data is made up so you can see how it works. Type over it.
Is anything shipped? No. This is a digital download.
License
For use in your own restaurant(s) only. Please don't resell or share the files.
Disclaimer
This is a planning tool, not legal, tax or accounting advice. Suggested numbers are a starting point. Check wage, overtime, tax and local rules for your own state with your accountant or payroll provider.
Refunds
Digital downloads can't be returned. If a file won't open or something's missing, email us and we'll fix or replace it within 24 hours.