Food Cost Calculator
Calculate food cost percentage and recipe costing.
In food service, margins live or die on food cost. This free Food Cost Calculator works out the cost of each dish from its ingredients and shows the food cost percentage against its menu price — so you can price your menu profitably and spot dishes that are quietly losing money.
How to use it: enter each dish's ingredients with quantities and costs, and set the menu price; the calculator shows the dish cost and food cost percentage. Use it to set prices, review your menu, and protect your margins.
Key features
- Calculate dish cost and food cost %
- Ingredients, quantities and costs
- Price menus profitably
- Spot low-margin dishes
- Works in Excel and Google Sheets
This template is designed for professionals and teams working in Hospitality & Tourism who want to manage Restaurant & F&B tasks efficiently in Microsoft Excel — without the need for expensive specialist software.
The Food Cost Calculator is part of our Hospitality & Tourism collection — downloaded 6 times and counting. Built from real-world experience by the ExcelGurukul team and tested across multiple industries and roles.
Frequently asked questions
Is it free?
Yes, free download with no sign-up.
What does it calculate?
Dish cost and food cost percentage against menu price.
Is it good for menu pricing?
Yes, to price profitably and protect margins.
Which currency does it use?
Any — enter amounts in your own currency.