Menu Profit Calculator

Work out food cost and profit for every dish, then sort your menu into Stars, Plowhorses, Puzzles and Dogs, with what to do for each.

Type what you pay for ingredients and what goes into each dish; the file costs every portion and compares it with your food cost target.

What's in the file

  • Start here — step-by-step guide and colour legend
  • Guide — How to read the numbers. Plain explanations of every number, how to read the result and the mistakes to avoid.
  • Settings — Currency, tax and your food cost target. You fill in: Currency, Tax included in menu prices (VAT), Target food cost %.
  • Categories — Menu categories used in the drop-downs. You fill in: Menu categories.
  • Purchase prices — What you pay for each ingredient. You fill in: Ingredient, Unit, Pack size (in units), Pack price. Worked out for you: Cost per unit.
  • Recipes — One row per ingredient of each dish. You fill in: Dish, Ingredient, Quantity in one portion. Worked out for you: Unit, Cost.
  • Menu — Price, cost, sales and what to do with each item. You fill in: Item, Category, Menu price, Own cost (no recipe), Sold per month. Worked out for you: Price without tax, Food cost per portion, Food cost %, Profit per portion, Profit per month, Price for target cost, Menu class, What to do.
  • Analysis — Your menu at a glance. Shows: Items on the menu, Average food cost %, Items over target, Profit per month, a chart.
  • Summary — What the numbers say. Shows: Items on the menu, Average food cost %, Target food cost %, Items over target, Profit per month, Best item (profit per month), Highest food cost %, Star, Dog.
  • Action plan — What you will change next. Write what you will change, why, who owns it and by when; status shows in colour.
  • Checklist — Menu review routine. 9 steps to tick off, with a progress bar.

How to use it

  1. Open Settings: set your currency, the tax included in your menu prices, your food cost target and your menu categories.
  2. In Purchase prices, list ingredients with the pack size and what you pay for the pack.
  3. In Recipes, add one row per ingredient of each dish with the quantity in one portion.
  4. In Menu, type menu prices and monthly sales. Dishes with a recipe get their cost by themselves.

What it does

  • Ingredient prices and recipes: cost per portion is calculated for you
  • Food cost %, profit per portion and the price that hits your target
  • Menu engineering classes with a suggested action
  • Works with prices that include VAT
  • Two files in each language: a blank Template to fill in, and an Example filled with sample data
  • Available in several languages; Arabic files are laid out right-to-left
  • Formulas only, no macros or add-ins
  • Instant download after purchase

Included Files

  • A file in the language you choose
  • Arabic files laid out right-to-left
  • Step-by-step guide
  • Free updates for this version

Works With

  • Microsoft Excel
  • Excel for Mac

Support

Questions about setup? Send us a message from your account page and we reply by email.

Menu Profit Calculator

The video tutorial for this template is coming soon.

No reviews yet. Reviews appear here after customers rate the template.

Write a review
Your rating
FAQ
  • Which language is the file in?

    You get the file in the language you pick at the top of the site. If a template is not available in that language yet, you get the English file. Arabic files are laid out right-to-left.

  • Do I need macros or add-ins?

    No. The templates use formulas and built-in charts only.

  • Can I change the template?

    Yes. Rename columns, add rows, change colours and add your logo.

  • How do I get the files after paying?

    The download link appears on the order page and in your account right after payment.

Personal License

For you, on your own projects and your own company reports.

Team License

Share the files with up to 10 people in your company.

$35.00

$45.00

Free

File language: English

Add To Cart
Mia Ready
39 templates in the shop
View All Templates
  • Last updateNov 17, 2026
  • PublishedNov 15, 2026
  • CategoryHospitality
  • File format.xlsx
  • LanguagesEnglish
  • LayoutLeft-to-right; Arabic right-to-left
  • MacrosNone
  • Works WithMicrosoft Excel, Excel for Mac
  • Tags Excel, Hospitality
Like this template?

Found it useful? Recommend it to other marketers and earn 30% of every sale you bring in.

Become an affiliate