As a chef, I enjoy creating new recipes and working on an artistic presentation. I’ll add a little of this, a little of that, some more of the other, taste it, a few more tweaks, and then “Ahhh! That’s it!” But…writing (documenting) the recipe is always so damn tedious! “Was it 1 tsp or 2? How do I calculate the cost of 1 cup fresh corn kernels? How much does 2 Tbl of fresh tarragon cost?” It is an unfortunate yet necessary exercise. Keeping track of how you did these calculations can save you a huge amount of time and frustration the next time you need to use the same ingredient.
If your company doesn’t have a professional software package which synchronizes current pricing to recipes, then using Excel is a good alternative. The Excel Recipe Template with Inventory file below will allow you to add multiple recipes to one Excel workbook and link all the recipes to one master inventory sheet. To update the pricing on all your recipes, simply update the prices on the inventory tab and all your recipes will be updated with current prices. I suggest that you keep the number of recipes per workbook under about 100, otherwise the file can become so large that it may run slowly.
Some knowledge of using Excel, especially Excel formulas, is helpful. But, the video demo should give you the tools to be able to use the file even if you are unfamiliar with Excel. You will however have to have a copy of Microsoft Excel on your computer in order to open and use this file. But if you are searching for professional inventory software then here is some info to get you started.
- 1:44 using the recipe templates
- 2:35 syncing recipe costs to inventory
- 7:35 editing and working in the inventory list
- 7:44 adding “quick commands” which make using Excel easier
- 13:28 renaming tabs
- 13:39 moving tabs
- 14:10 creating an index with hyperlinks to the recipes
The Inventory & Recipe Template in the tutorial below is available to Premium Subscribers
(get membership info)
Note: Microsoft Excel Required (not included)
To Change Currency
To change the currency from US dollars to any other currency follow this link to a short video.
To Change Units of Measure to Metric
Changing the units of measure is easy. Go to the “Inventory” tab. You will notice that there are multiple columns for “Unit” and “Price”. Simply add your item in the “Item” column, and then type in the units of measure that you want to use. Start with the largest unit first and do the math for each subsequent smaller unit of measure for that specific item.
For example: Mushrooms Porcini Dried, Case $175.00, Kg $35.00, G $1.25
For the recipes simply enter the unit of measure you want to use.
To Unprotect the sheets:
Although the sheets are protected there is no actual password. On the Excel menu bar go to: Format/Unprotect Sheet and click on “Unprotect Sheet”. Leave it blank and just click. You’ll have to do this with each sheet which is protected.
Or, check-out my short video on how to unprotect an Excel sheet.
Comments from before Site Migration