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.