skip to Main Content

Food Cost Excel Template

4.6 (5 reviews)

Recipe Cost Calculator Spreadsheet. Calculate cost of your menu items. Printable sales summary & recipe tables. No installation needed. All in Excel.

Learn more about License Types


Someka refunds icon

30-Days
Return

Someka one time payment icon

One-Time
Payment

Someka direct download icon

Instant
Download

TEMPLATE DESCRIPTION

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.

Menu-Items-Cost-Calculator-Someka-S01

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:

Dashboard:

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.

Menu-Items-Cost-Calculator-Someka-S07

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.

Menu-Items-Cost-Calculator-Someka-S02

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.

Menu-Items-Cost-Calculator-Someka-S03

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.

Menu-Items-Cost-Calculator-Someka-S04

The last part of your template is a Sales summary.

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.

Menu-Items-Cost-Calculator-Someka-S06

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

Food Cost Calculator is a ready-to-use Excel Template and provided as-is. If you need customization on your reports or need more complex templates, please refer to our custom services.

PRODUCT VIDEO

Watch the video below to see the template in action! Presentantation also includes usage notes, explanations and tips & tricks about the template.

FREQUENTLY ASKED QUESTIONS

USER REVIEWS & COMMENTS

5 reviews for Food Cost Excel Template

  1. Manuel

    easy to use and i loved the posibility to customize it anyway i want. thank you

  2. Alice

    The template is fine but I would like it to have more options to manage my budget. Good work though

    • Someka

      Hi Alice,
      Thank you for your comments. Our developers work hard to include as many useful features as possible while keeping the template solid and easy to use.
      Moreover, don’t forget the template is customizable, meaning you can modify it and add any feature you need to make it suitable for you.

  3. nezih

    nice

  4. anil baga

    good

  5. kapa kugu

    nice

Leave a customer review

Only verified users who have downloaded and used the template may leave a review.

RELATED TEMPLATES