Restaurant Menu Margin Calculator

Many menu prices are a guess. Enter what you pay for ingredients and what goes on each plate, and see the real cost, profit and food cost % of every dish.

WHAT'S INCLUDED

• Menu margin calculator — Excel / Google Sheets workbook, 6 tabs (Start Here, Ingredients, Recipes, Menu Analysis, Charts, Price Tester)
• Start Here guide — PDF, 1 page

WHAT YOU CAN DO

• Turns purchase prices into cost per ounce, each or cup
• Costs each dish one ingredient row at a time
• Food cost %, profit per plate and a suggested price for up to 50 dishes
• Sorts dishes into Star, Plowhorse, Puzzle or Dog menu classes
• Charts tab: profit per plate, food cost % vs your target and monthly profit by dish
• Price Tester shows a new price's effect before you change the menu
• Yellow cells to type in, grey cells that calculate for you

HOW IT WORKS

1. Open the workbook and read its Start Here sheet.
2. Enter your ingredient prices, then build each dish in Recipes.
3. Add menu prices and monthly sales in Menu Analysis and set your target food cost %.
4. Check the food cost and menu class columns, then test changes in Price Tester.
5. Update ingredient prices each time your supplier invoice changes.

WHAT YOU NEED

Microsoft Excel or free Google Sheets (also opens in Apple Numbers and LibreOffice).

PLEASE NOTE

• Instant digital download. Nothing physical is shipped.
• Example data in the workbook (a six-dish menu) is made up — replace it with your own.
• Questions? Email hello@gracepathventures.com with your order number.

LICENSE

• Use, edit, print and fill in these files for your own business, your own clients or your own household, as many times as you like.
• If you run more than one business or location, one purchase covers all locations you own.
• Please don't resell, share, give away or upload the files (edited or unedited) for others to download, or claim the design as your own.
• Files are provided as-is. Check every figure and form against your own situation before relying on it.