Food Cost Excel Template
Recipe Cost Calculator Spreadsheet. Calculate cost of your menu items. Printable sales summary & recipe tables. No installation needed. All in Excel.
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 Food Cost Excel template will help you to evaluate the real cost of the meals 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 Food Cost Calculator template also helps you to evaluate the cost of the meal before you decide to add new recipes to your menu.
In general, all you need to do is update the price of your raw materials with the latest prices regularly and specify the recipes for your meals. Food Cost template in Excel calculates the cost by considering the amounts/units of raw materials of a meal.
Food Cost Excel Template 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. You can also define your currency 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 of this Food Cost template, your next step is going to be a raw material list.
Raw Materials Section:
This is a list where you can enter the price details of all the raw materials. 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, the volume, and lastly the price of the item.
Particularly, you can select one of the units from the dropdown list. This dropdown menus are dynamic according to your setting options.
Later on, the food cost excel 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 also useful for filtering and searching for some specific meal. Our dummy data in this food cost template suggests the category as a type of meal. But you can use it in different ways as well.
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. You should not repeat the meal name or number of portions, and these 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 at the top of the list. Besides, you can use the slider to select a certain meal recipe or a category in our recipe cost excel template.
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 excluding 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.
Food Cost Excel Template 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
FREQUENTLY ASKED QUESTIONS
USER REVIEWS & COMMENTS
Only verified users who have downloaded and used the template may leave a review.
Arbitrage Calculator Excel TemplateRated 4.83 out of 5$0.00 – $49.95
Arbitrage calculation spreadsheet for sure bets. Calculate odds, steaks, profits and loss. Dynamic dashboard with guidance. Ready to use Excel!
Marketing ROI Calculator Excel TemplateRated 5.00 out of 5$0.00 – $69.95
Digital marketing ROI calculator in Excel. Analyze social media campaign metrics. Printable dashboard and charts. Ready for use with on sheet guidance.
Historical Stock Prices Excel TemplateRated 4.00 out of 5$0.00 – $69.95
Excel spreadsheet to fetch historical stock prices. One-click access to data from NASDAQ and NYSE. No installation needed. Ready to use.
Excel Balance Sheet TemplateRated 4.67 out of 5$0.00 – $59.95
Balance Sheet Template in Excel spreadsheet. Automatic dashboard with charts and financial ratios. Easy-to-edit & ready-to-print. Export to PDF.
Cash Flow Statement Excel TemplateRated 4.89 out of 5$0.00 – $59.95
Ready-to-use cash flow statement template. Print form and exclusive dashboard with on sheet instructions. No installation needed. All in Excel.
Trading Journal Excel TemplateRated 4.73 out of 5$0.00 – $299.95
Powerful and easy-to-use Trading Journal Excel Template built for day traders. Supports IRESS Trader and Viewpoint. Works in Mac & Windows.