Do you want to open a restaurant? Or do you have one already? If you are willing to start your food business, this tool might be the one that you are looking for. Our Menu Items Cost Calculator template will help you to evaluate the real cost of the meals prepared in your kitchen.
There are just a few simple steps to start to calculate the cost of each meal and the sales summary of your restaurant. This tool also helps you to evaluate the cost of the meal before you decide to add new recipes to your menu.
All you need to do is updating the price of your raw materials with the latest prices regularly and specifying the recipes of your meals. Menu Items Cost Calculator template calculates the cost by considering the amounts/units of raw materials are being used to prepare a meal.
Menu Items Cost Calculator Features:
First of all, you should start by updating units that you prefer to use in the menu, for selecting the unit of raw materials that fit your needs. There is an option for you to be able to enter the currency you are using manually. Unless you didn’t change it, you will see the $ sign at the prices’ information on your menu.
Once you finished filling necessary information on the Settings part, your next step is going to be a raw material list.
Raw Materials Section:
This is a list that you can enter the price details of all the raw materials you purchase. Additionally, you can enter the volume and the unit of each material you purchase. So, you can enter the name of the material you purchase, volume, and lastly the price of the item. You can select one of the units from the dropdown list which you are defined before in the settings section.
Later on, the menu items cost calculator will just split the price according to your meals’ recipes. You should not enter values for which the cost of all recipes cannot be calculated in total. In that case, if you are buying a box of tomatoes, you should write the actual weight instead of “a box”.
After you input all your raw materials, go to the “Meals ingredients” which is a list of your recipes.
Meals Ingredients Section:
In this section, you can write up to 400 recipes.
The First 5 columns are where you input the data. Once you input the necessary columns, you will see the output calculations immediately which are colored as grey.
The first column “Category” is optional but can be useful for filtering and searching for some specific meal. Our dummy data suggests the category as a type of meal but you can use it in a different way if you want to. For example, you can enter “vegetarian”, “gluten free”, “contains nuts” or you can specify any other type of category that you may find useful for you.
Except for the first column, all the others are important to fill out. The meal name or number of portions should not be repeated, and they must be in the first row of each recipe. To input the ingredients, you can just choose them from the dropdown list. All ingredients were previously entered in the raw materials section. After your recipe is finished you will see the calculated price per recipe and portion.
Additionally, you will be able to see the total recipe number is being inputted on the top of the list. You can use the slicer to select a certain meal recipe or a category.
The last part of your template is a Sales summary.
You can input all the meals that were ordered within the counted period. You can always add some extras in case some of them were prepared but not sold. There is an additional green table where you can input some raw ingredients that are not included in your recipes. For example, tap water or frying oil. You can also add there some monthly usage of spices like salt etc. if you are not including them in recipes.
You will see the final Total which includes the cost of meals and raw materials. If you would like to add the cost of bills and other expenses, you can fill the optional cells to include those in the final Total. Otherwise, you can leave them empty.
Menu Items Cost Calculator Features Summary:
Calculates the Cost of Menu Items
Full Print Ready
Informational notes included
No installation needed. Ready to use.
Works both on Mac and Windows
Does not include VBA code or Macros
Compatible with Excel 2013 and later versions