The template can calculate cost of the main and additional ingredients used in preparation of your dish along with the actual cost of preparation such as labour cost or cost of the utilities. Total recipe cost field tells you the total ingredient cost for your new upscaled recipe.
Recipe cost calculator free spreadsheets.
Recipe cost calculator template free. In red we ve included a recommended retail price field which simply multiplies your total cost per serving by 3 since your raw ingredient cost should be roughly 1 3 of your retail price. Total cost serving field tells you how much each serving will cost. Click a link below to download and print the template.
Recipe cost calculator free. Preparation of almost any product involves use of other products materials and physical labour calculation of which is absolutely vital especially if you preparing it with purpose of gaining profit. For example if total recipe costs are 40 00 and it makes for 8 services mean 40 8 5 00.
Recipe costing template use this template to work out the cost of making a food or drink item and set a suitable selling price to make a profit for your canteen. Free recipe cost calculator for excel recipe costing template to calculate recipe costs simply put the total sum of ingredients costs and utility costs. You can either use the calculator for individual portion costing say a 5 ounce portion of french fries or you can use the calculator to cost a complete recipe or a menu item.
Divide the total recipe costs by the numbers of servings. This free food cost calculator works out food cost per dish and helps you calculate food cost percentage. 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.
Free easy to use food cost calculator for excel. It helps you keep track of allergy and recipe info. 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.