Select a category for the new recipe i use my recipes so it s easy to identify the ones that i entered enter the recipe name. The download includes the main excel file or open office spreadsheet as well as instructions on how to get the most out of the spreadsheet.
Use excel microsoft excel can be used to make this calculator template.
Recipe calculator for excel. Enter ingredient names in column a along with size in ounces and price paid for ingredients. Details to include in the spreadsheet you can include the date dish name estimated sales price the total cost cost margin and net profit of the particular dish. Download the excel calorie counter with recipe calculator.
Recipe cost calculator helps thousands of businesses become more profitable save time and find peace of mind. The file is in excel 2007 format and contains a macro. Recipe formula calculator excel pdf skincare formula calculator.
Next you ll enter the amounts for the first ingredient. Import and export your ingredients to excel. You can calculate the cost of your dish by adding all primary and secondary ingredients then add cost of preparation and utilities.
There are multiple tabs within the file that allow for different brew system parameters recipe inputs water. Update all your ingredients at once. Your data is safe and secure.
Use your recipes in the daily data entry. A pie chart of the cost distribution can even be made. We do off site backups on a nightly basis.
This 1 excel file and 1 page printable formula calculator for natural skincare diy enthusiasts and formulators. Enter the number of servings cell j6 next in the lower section. This will scale your ingredient amounts to match your desired servings and calulate cost.
Once you ve completed the setup for each menu item then all you need to do is to enter current purchase prices for ingredients you buy then watch as each recipe and menu item is automatically updated with current costs. Free recipe cost calculator for excel recipe costing template to calculate recipe costs simply put the total sum of ingredients costs and utility costs. Brewcipher is a free excel spreadsheet that acts as a recipe builder and brew day calculator.
You can download a zipped copy of the excel calorie counter with recipe calculator on the contextures website. This will calculate cost per ounce in column d. Enter the amount of each ingredient used in your recipe in column e.
Divide the total recipe costs by the numbers of servings. Once your recipes are added to the list you can select them in the foodentry worksheet where you enter your daily food choices. For example if total recipe costs are 40 00 and it makes for 8 services mean 40 8 5 00.
The menu recipe cost template is a microsoft excel set of spreadsheets designed to help you prepare an accurate costing for all your menu items and recipes. Select a category for the first ingredient. Recipe cost calculator is intended for providing help in preparation of the accurate cost for any dish of the menu.
Select the ingredient name. The built in calculations and formulas will do all the hard work for you. In columns d e enter the amount required for this recipe and the unit of measurement.
The worksheet records your formulas as percentages and convert that formula into any amount by.