Recipe Cost Template Free Step 1: input the original recipe data. place a name for your recipe on the top right portion of the template. you can then start by filling in the data required under the “original recipe” area. input the total recipe yield (in ounces) and the number of servings that the original recipe can serve. Description. recipe cost calculator is intended for providing help in preparation of the accurate cost for any dish of the menu. you can calculate the cost of your dish by adding all primary and secondary ingredients, then add cost of preparation and utilities. you can also update spreadsheet with image of your dish and add a short description.
Excel Recipe Costing Template 1. basic recipe cost template. this basic template is a great option for quickly viewing your recipe costs. you only need to enter the essential parts of your recipe, nothing more, nothing less. some categories include your ingredient list, recipe, quantity, number of servings, and cost per unit. Menu and food costing spreadsheet (.xlsx file) google docs spreadsheet. download our food business startup kit to get more free tools like this. quick reference guide: enter the number of servings from your original recipe in cell d6, and your desired number of servings in cell f5. this will scale your recipe up and down. Use excel – microsoft excel can be used to make this calculator template. details to include in the spreadsheet – you can include the date, dish name, estimated sales price, total cost, cost margin, and net profit of the particular dish. a pie chart of the cost distribution can even be made. primary ingredients – another area on the. The inventory master worksheet is used to automatically convert purchase unit cost to recipe unit cost. holds up to 500 ingredients, 150 menu items and 150 sub recipes. easy to use "drop down" lists eliminate repetitive typing or the need to cut & paste. maintains current recipe cost for each menu item. allows you to experiment with various.
Comments are closed.