![]() ![]() Unfortunately, we are unable to offer refunds for digital products due to their nature. You will get one version of Google Sheets and one MS Excel. ❌ - Will not work in Numbers, Libre Office & Open Office ✅ - For MS Excel Works on Mac & Windows if MS Excel Installed (Version 2016 and above) ✅ - For Google Sheets Works on Web: Mobile, PC, Tablets, iPad, Laptop, Mac & Windows ✅ - Included both Google Sheets and MS Excel Files. □□īelow are the complete features of the product. Whether you're a home cook, professional chef, or managing a bustling restaurant, our Food Cost Calculator empowers you to take control of your finances, helping you create delightful dishes while keeping your budget in check. ![]() The spreadsheet's intuitive interface simplifies the calculation of ingredient expenses, allowing you to make informed decisions about your culinary ventures. Track your food inventory, analyze costs, and streamline your budgeting process with ease. This comprehensive spreadsheet supports a variety of 11 currencies, ensuring global compatibility for all your financial tracking needs. Paula currently works as a Catering Manager in Washington DC.Food Cost Calculator Spreadsheet, available on both Google Sheets and Microsoft Excel platforms! □□️Įffortlessly manage your culinary expenses with this user-friendly tool designed for food enthusiasts, chefs, and restaurateurs alike. Self-taught in database and spreadsheet applications, her mission is to develop sophisticated but user-friendly management tools for chefs and managers currently under-served by recent advances in technology. Paula Scharf is a graduate of the Culinary Institute of America with over three decades of experience in both independent restaurant and corporate dining management. On the second page (tab) you have a printable scaled version (bottom image) based upon the yields you put on tab one.ĭownload the actual Scaling Recipe Template ![]() It automatically recalculates and gives you the new measurements in the correct unit for the scaled recipe. Then, enter the number of portions you want the recipe to yield. On the first page (actually, tab if you are familiar with Excel), you enter your basic recipe for a one times batch (top image) including the yield for a one times batch. This recipe template is excellent for scaling a recipe to the exact number of portions you want it to yield. This template does include macros so you will need to enable macros in Excel for it to work correctly. It is excellent for costing purposes, whether you are creating a single plated dish or a batch recipe, this template helps get accurate food costing for each recipe. This template creates any number of recipe cards you choose. Video Tutorial: How To Make An Excel Recipe Template Scalable This is easy to add to any of the other recipe templates as well. You enter the cost per unit of measure and then the table calculates your totals based upon the quantities entered. This template style has the “Procedures” in the right hand column and has a food cost calculation table. Simply click on “insert rows” in the Excel toolbar. This is the classic recipe template style and has the “Procedures” at the bottom. There is also room at the bottom of the sheet for additional comments or to put “Procedures” if you wish them at the bottom instead. The ingredients are listed in groups based upon which step in the “Procedures” column they match to. This style is for shorthand recipes and has the “Procedures” in the right hand column. A separate article has a special Excel recipe template geared towards plate costing and managing your food cost.īelow are several versions of Excel recipe templates which are available for download. You may also be interested in reading how to organize recipes on your computer. The video below gives a tutorial on how to add formulas to make your Excel recipes scalable. If you know how to do some Excel formulas then this is a big help for scaling your recipes. If a 1 times batch yields 20 servings and you need a 5 times batch for a total of 100 servings, all you need to do is put “5” in the “scale” box and your entire recipe is recalculated to make a 5 times batch. This will overwrite your blank template with all the content from your new recipe.Įach Excel recipe template below has a “scale” feature in the header. Do not open your template, add all the content for your new recipe, and simply click “save”. This will keep your template blank and clear so it will be easy to use repeatedly. Then add all of the content for your new recipe. When you want to create a new recipe, open the “Recipe Template” file and immediately “save as” the name of your new recipe. The best way to use a recipe template is to set it up with all the basic info you want to appear on all your recipes, such as restaurant name, chef’s name, etc.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |