Recipe Cost Calculator Excel Template

Thanks to chef bill williams and cam zahradnik for their work on this template.

Recipe cost calculator excel template. This calculation is something that is necessary especially when you are preparing this with the aim of getting a profit. 8 food cost inventory spreadsheet for microsoft excel. 8 food cost inventory spreadsheet for microsoft excel. Cut out cookies iced cookies how to make cookies cookies et biscuits cupcake cookies sugar cookies cookie favors baking cookies favours.

In this kind of spreadsheet you can track the pricing of. Enter the number of servings from your original recipe in cell d6 and your desired number of servings in cell f5. Worksheet template september 21 2019 18 07. Below you ll find a variety of recipe templates available for download which are created in excel.

You can calculate the cost of your dish by adding all primary and secondary ingredients then add cost of preparation and utilities. This template is able to calculate the cost of the main as well as additional ingredients employed in the preparation of the dish and the actual cost involved of preparation like labor cost and cost of the utilities. An excel recipe template offers not only the opportunity to write a recipe for your staff but also adds the number crunching power which excel is known for making it easy to calculate your costs at the same time as writing the recipe. Enter ingredient names in column a along with size in ounces and price paid for ingredients.

The recipe template below is a fantastic tool for calculating your plate costs. The food cost inventory spreadsheet is a single spreadsheet that displays all the prices and details of all the products that you intend to buy and sell at your place of business. 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. This will scale your recipe up and down.

Krissty foster favorite recipes. Recipe cost calculator is intended for providing help in preparation of the accurate cost for any dish of the menu. Download a free recipe cost calculator for excel which helps when calculating costs of ingredients used in a recipe great for checking profitability of the restaurant menu and estimations of the profit margin. The download version includes both a blank recipe form as well as a sample one.

You can also update spreadsheet with image of your dish and add a short description or instruction of preparation and allergies to create printable recipe specifications cards which you can keep in your food specifications folder. This will calculate cost per ounce in column d. The preparation of nearly any product requires the use of certain products materials as well as physical labor.