เทมเพลต Excel / Google Sheets

Menu Cost & Profit Template

Ingredient unit costs with auto cost per dish
Food cost % over 35% shown in red
Suggested price from target margin
Profit per menu item with charts

฿99Lifetime

About this template

A menu costing file for restaurants and cafes. Enter ingredient prices and each recipe, and the file works out cost per serving, profit and food cost %, with a sales log and a dashboard of your top-earning dishes.

Screenshots from the real file

Who it is for

Restaurants and cafes
Bakeries and drink shops
Anyone opening a shop and setting prices

What you get out of it

Know the true cost of every dish
Price your menu with confidence
See how much profit drops when ingredient prices rise
Know which dishes earn the most

What is inside the file

How to useGetting-started steps, list of tabs and what the colors mean

IngredientsPurchase price, pack size and unit; the price per unit is calculated

RecipesPick a dish and its ingredients and enter amounts per serving; cost is calculated

Menu and profitPrice, cost per serving, profit per serving, food cost %, units sold and total profit

SalesDaily units sold per dish

DashboardTotal sales, gross profit, average food cost, units sold and profit by dish

SettingsUnits and menu categories

How to use it

In "Ingredients", enter purchase prices and pack sizes
In "Recipes", enter the ingredients and amounts for each dish
In "Menu and profit", enter prices and check food cost % (aim for 35% or less)
Enter daily sales and see top earners in "Dashboard"

What you receive

Excel file (.xlsx), 56 KB, ready to download right after payment
A Google Sheets link that makes your own copy in Google Drive, usable on mobile
Sample data on every tab so you can see how to fill it in, then replace it with yours
Built-in formulas, drop-downs and color alerts

Frequently asked questions

Which programs does this template work with?

It works in both Microsoft Excel and Google Sheets. You get the .xlsx file to download plus a link to copy it into your own Google Drive.

Who is Menu Cost & Profit Template for?

Restaurants and cafes; Bakeries and drink shops; Anyone opening a shop and setting prices

What's inside the file?

6 tabs: Ingredients, Recipes, Menu and profit, Sales, Dashboard, Settings, with all formulas built in.

Do I need to be good at Excel?

No. Just type into the marked cells; the file calculates and summarises everything, and includes a how-to sheet.

How do I get the file, and how much is it?

It costs ฿99. Once payment is confirmed, download the file and the Google Sheets link right away from your account page.

Product reviews

No reviews yet