Food Inventory Template, Recipe Cost Calculator

$49.00

Personalize with Name or Company Name

Description

Save time tracking your ingredients!

If you are looking for an easy way to track your food products, recipe costs and inventory of the ingredients, this spreadsheet template can help! 

This package includes several pages linked together, to help you save time with data entry, and give the insight you need to know when to restock on ingredients and how to set your prices.

The file is color coded to be easy to use, green cells to enter your data, and grey cells are the formulas that will automatically calculate based on what is entered in the green cells.

Section 1 - Ingredient Conversions and Pricing

In the top section of this page, you can enter your ingredients and materials used.  This includes a place to enter what measurement was used when you bought the ingredients, and what measurements you want to convert the ingredient to when pricing your recipes.  

For example – if you buy 5 pounds of flour, but you measure the flour in cups when using it in recipes.  For this example, you would enter that you bought 5 pounds, and that you want to convert pounds to cups.  

The bottom section consists of 30 boxes to price up to 30 recipes.  In each recipe you can list up to 36 different ingredients.  

You’ll be able to select whether to price the final product in batches.  This is ideal if you are selling items individually, after cooking up an entire batch.  The ingredients for the recipe will be entered for the entire batch, and you can enter the number of cookies it produces, to get a recommended price per cookie. 

*This has also worked well with companies selling different soaps or related products where you measure amounts in batches. 

Section 2 - Recipe Inventory and COGS (Cost of Goods Sold)

The next page in this template is already linked to the first pricing page, so every recipe you enter in the first page, will automatically get populated and listed out here, along with the total cost of ingredients. 

As recipes are made, you would enter the quantity made and sold, to get the counts of items made but not sold, and the cost of goods sold. 

Section 3 - Ingredients Inventory

This page is set up to help keep track of your levels of ingredients that are used up in each recipe.  All you have to do in this page is click a Refresh All button, anytime new recipes or sales are entered in the previous pages.  

The ingredients summary will show the total ingredients used per measurement – so it works best when you enter each ingredient with a consistent measurement. 

Check out the video below to see how the template works:

*You will receive by email an Excel Spreadsheet and PDF with directions. 

*Most of the templates come with the cells with formulas protected, to prevent someone from accidentally deleting or writing over a formula, which could cause the template to not work as described.   Here are the unprotected and unlocked version upgrade options, if you would like to make your own changes.

See more general or handmade product pricing templates here.

See general business templates here.

*You do not have permission to distribute or re-sell the template, so please don’t do it.

Feel free to contact me with any questions.

Additional information

Materials

,

Upgrade Options

Customer Reviews

Based on 1 review
0%
(0)
0%
(0)
100%
(1)
0%
(0)
0%
(0)
D
Diane P
Protected

I am happy overall with this however when I purchase this it will not let me do simple things that I need to do by placing my products ingredient list in ABC order or my recipes in ABC order. What I purchased was a protected excel. In the advertisement that I found online it never said that it was protected I have requested several times for the password because I am not going to redo all of the work that I put on to purchase an unprotected they have offered to give me the unprotected but I think it’s ridiculous that I would have to redo everything if I was good at Excel I won’t be using Product that I purchased from them. I think it’s ridiculous that they put a password on there when you buy it for $49 you should be able to do whatever you want to do changing it you purchased it so there for I should be able to do simple things. Again I have requested the password if they are going to sell this as protected they should state it which it doesn’t.

Thank you for your review! Yes, you are correct that the templates come with certain cells protected and this information is detailed in our Terms page here: https://timesavingtemplates.com/terms/. Typically, the cells with formulas are protected, to prevent someone from accidentally deleting or writing over a formula, which could cause the template to not work as described. We had waived the unprotected formulas version fee ($8) and sent you a copy of this version free of charge. You should be able to copy and paste your information from one version to the other, and we also offered to help you transfer your information for you.

Please note that even in the unprotected formulas version, the templates still come personalized with your name or business name, and this cell remains protected – as it’s the only way we have to discourage the distribution of these templates to others who haven’t paid for them. We do offer a license for the fully unlocked version, and we usually have Independent Consultants purchase the license when they use the template as part of a service to their own clients. Thank you for your understanding!