Your Recipe Costing Template
Thank you for purchasing the recipe costing template.
Here is the link to download the template
Right click on the link and select ‘Save Link As’ or ‘Save Target As’
Or copy and paste this url:
You will need to save to your computer.
Once you open up the spreadsheet you will see 3 tabs.
This guides you through the different areas of the spreadsheet. It will show you which cells to complete, and which contain the formulas you need to leave in order for the template to calculate your costings.
This is your Master Template.
You need to copy this sheet, making one sheet per recipe. If your selling prices include tax, check the tax rate for your own country or state and amend BEFORE you copy the master template. If you do this on the master, it will save you having to change for each new recipe.
To copy the Master Template select Edit, then Copy or Move Sheet, select (move to end), tick the box where is says Create Copy, then OK. The new spreadsheet will appear as the last tab, and will be called Master Template (2). Double click on the tab, and the text will appear highlighted. Now type in your new name for the tab e.g. the recipe name.
This is a worked example for a simple recipe.
You may find it useful to keep separate files for each class of recipe e.g. breakfast dishes, starters, entrees, and deserts. In order to create extra files simply open up the spreadsheet, select File, then Save As, and then give it a new name.
This simple template will give you all you need to cost out your recipes and calculate your gross profit margin. You can adjust the tax rate for your own country or state to ensure you get the full selling price.
It will also tell you what gross margin you are achieving at your current selling price.
Having a set recipe ensures consistency and allows you to check you figures before you produce a dish, to ensure it is going to give you the profit return you need to stay in business.