You can create a food cost calculator spreadsheet from scratch but that would usually take up a lot of time that you would rather spend on being on top of your food service business. How to calculate food cost per serving or food cost per menu item food. Download your free, easilycustomizable menu templates today. By using the food cost calculation file and the declining balance worksheet, or your own version of them, you will be able to track your purchases and your theoretical month end food cost. The restaurant food cost calculator uses the last calculated cost as the amount to calculate the portion cost. In our example we will create a simple menu item of a burger with homemade fries. It is an important document as it helps to decipher the level of finance that your business needs, whilst also predicting the viability of business operations. How to calculate restaurant food cost percentage duration. Calculating your cost variance gives you a sense of where you stand and can explain why the numbers came out the way they did. Most common mistakes have been usually made during the creation of ingredient list for each menu item.
Food cost is almost always expressed as a percentage known as food cost. Home bakery business, food truck business, baking business, catering business, catering menu, cake business, wedding catering, coffee business. At its core, food cost is simply the cost incurred by your restaurant on food. This free food cost calculator works out food cost per dish and helps you calculate. Restaurant prime cost calculation restaurant systems pro. In this article, we look at how to determine food costs for a new menu. Food cost calculator for windows 10 free download and.
Start with food costing, build recipes, sub recipes, and do a complete cost breakdown on all menu items. If you want to designate a unit of measurement for the serving size, enter a dash after the size number, followed by the measurement description for the number of pieces in the serving size 4oz, 2each, 3slices, etc. Many restaurateurs have found that menu costing can be very time consuming and complicated, but that is where our free menu costing calculator comes in. Restaurant food cost calculator for portion and menu costing. I dont want to put out a bunch of cost up front until i know it is a go. For example, a steakhouse can run a food cost percentage close to 35 percent, because the cost of its. How to calculate food and portion costs for a restaurant menu. Recipe costing software is the only off the shelf back office suite with its own restaurant point of sale.
At its core, food cost is simply the cost incurred by your restaurant on food after taking into consideration all external and implicit costs. We dont charge huge licensing fees or make you install any dated, bloated desktop software. The 4 financial spreadsheets your restaurant needs. Save yourself countless hours and download our easy to use food cost calculator. Download a free recipe cost calculator for excel, which helps. Learn how to take control of your restaurant and make more money. How much does it cost to open a restaurant checklist sage us. This is a process known as menu costing, food costing, or recipe costing. You can see below simple sheet for food costs calculation. Calculating food costs using cheftec culinary software. Food cost calculator spreadsheet recipe cost calculator. Food costs has a direct impact on your bottom line, but calculating food cost is a timeconsuming job which is often neglected. How to calculate food costs and price your restaurant menu. The average food cost for most restaurants is around 2535%.
Youve got an enterprising mind and passion for food. This comprehensive spreadsheet template will give you an easytouse tool to calculate and maintain the current cost of your menu and recipes. This is useful when you want to combine multiple recipes to create a food menu item. The result of our study concluded, food cost management is a problem facing most restaurants. How to calculate your food cost percentage for pricing your menu. Plate cost how to calculate recipe cost chefs resources. Food cost calculator allows you to calculate recipe cost and selling price according to food cost percentage and yield. Jun 16, 2016 download a free recipe cost calculator for excel, which helps when calculating costs of ingredients used in a recipe, great for checking profitability. Our builtin antivirus scanned this download and rated it as 100% safe. Comes with over 150 common ingredients to start, complete with.
The food cost calculation file is an excellent inventory management forms tool which helps analyze your month to month inventory. In reality, a healthy percentage can vary greatly depending on the products you sell, food cost control, and the the market you serve. A common misconception about food cost percentage is that every restaurant should aim for a perfect number. There are many tools to help in costing a menu that vary incredibly in price and the amount of upkeep required. Thread in professional catering thread starter started by c0ffeemom. Watch the video to learn how to use our food cost calculator. My problem is i am trying to write a business model and need to cost my recipes, i have my baking certificate, but have kind of forgotten some things sice getting it 15 years ago. Recent research within the restaurant industry has shown that approximately 60% of new restaurants fail within the first three years of. The food cost calculation file is an excellent inventory tool to use if you do not have one already. In the short term, knowing precisely how to calculate food and beverage cost is critical when setting menu prices. Note that for most venues 25%40% is a good food cost ratio, and 20%35% is a good beverage cost ratio. Allows you to experiment with various cost percentage targets by entering different. An additional feature of the food cost calculation tool is that it will show you your inventory turns and average inventory for the month.
Calculate your restaurants food costs the right way with. Find the food cost percentage of your menu, add your sales data, and compare to the industry average. Running a restaurant takes up countless hours of planning, organizing, accounting, management, and of course, maintaining that balance between food cost and quality. You can play around with the numbers a bit in this interactive restaurant cost of goods sold calculator. Download a free recipe cost calculator for excel, which helps when calculating costs of ingredients used in a recipe, great for checking profitability of the restaurant menu and estimations of the profit margin. Restaurant food cost calculator bakery food cost calculator. How to calculate and control restaurant food cost variance.
Use our food cost calculator below to calculate your food cost, edible cost, portion cost, menu and plate costs. Food cost is the ratio of a restaurants cost of ingredients food inventory and the revenue that those ingredients generate when the menu items are sold food sales. The calculation strips away the effects of financing, accounting, and capital spending for better comparability between restaurants. This example will show how to use the use as ingredient feature on recipes. What is a good food cost for a restaurant restaurant. Calculate month end inventory, inventory turns, compare and track inventory statistics. In percentage, the food cost is primarily a restaurants total food. Download a free recipe cost calculator for excel, which. Food cost is essentially the total cost of your food net of the existing inventory.
Most of the time, if not always, beverage costs are not included and are counted separately. Running a restaurant, catering service, or culinary school can be an expensive and complex undertaking. I am wondering if there is a free download out there for costing recipes. The actual developer of the free software is restaurant marketing institute. Its all in how you calculate your costs and use them to price your menu. No matter the size of a food service operation, there must be robust food costing analysis carried out or else profits can be easily wiped out. Cost variance actual price x actual quantity standard price x standard quantity the actual parts of. After being given a grant to research the restaurant industry, we conducted a study across 50 restaurants.
Download this app from microsoft store for windows 10, windows 10 team surface hub, hololens. Cost a recipe quick and easy without the hassle of complicated spreadsheets. Restaurant financial plan templates excel downloads. How to determine food costs for a new menu restaurant engine. Food costing is one of the most important indicators of profitability for a restaurant with razor thin margins 35%, the slightest change in the price of goods andor the amount of sales can affect a restaurant s bottom line significantly. All your secret recipes, costing, sales, prices are stored in your own microsoft onedrive and not in our servers. We created costbrain as a restaurant solution, to make everything from recipe costing to invoice entry a much easier process.
David scott peters, food costs, smart systems, the numbers, video blog. This featurepacked, but somewhat unreliable, application aims to help food. Calculate monthend inventory, inventory turns, compare and track inventory statistics. You may do it by your own or use restaurant software that contains food cost calculation. Weve got you covered with the only beverage and food cost formula you need and tips for using it. Food and beverage costs can be your bffs or your biggest enemies. Our food cost calculator runs easily in the web browser of your computer or mobile device, allowing you to track your food cost both at home and on the goabsolutely free. Easily calculate portion costs from purchase invoices, plus recipe costing and food cost percentage with this free online restaurant food cost calculator. How to calculate food cost percentage with examples. But what about the free bread and butter you serve, or maybe the.
How to calculate food cost in a restaurant the ultimate. Food costing is one of the most important indicators of profitability for a restaurant with razor thin margins 35%, the slightest change in the price of goods andor the amount of sales can affect a restaurants bottom line significantly. Food cost is used by restaurant operators to determine how much money they make back on the sale of a dish compared to how much it costs to make that dish. Knowing what each of your menu items costs to prepare is one of the most basic yet overlooked aspects of running a profitable restaurant. The goal is to build in a margin that ensures profitability while being acceptable to guests. Price your restaurant menu accurately with food cost. It takes more than good cooking to run a successful restaurant. To make sure your business stays afloat, you must make regular and accurate calculations of your food. In this video, we build out a roasted chicken brie sandwich with a side salad and a ramekin of sundried tomato ranch dressing. Several free excel food cost calculation tools for download. The recipe cost calculation excel spreadsheet obtains the expense that each dish carries and the margin it would obtain with the final price to be charged. Food cost for a recipe, % also referred to as food cost per serving, food cost per plate, food cost per dish, or food cost per menu item is the ratio of the cost of ingredients you use to prepare a dish and the revenue you receive from selling the dish multiplied by 100. Advanced recipe costing template with yield percentages and ideal food cost. But a number of questions arise when you decide to go for it and start your own restaurant.
The food cost yield calculator is a flexible microsoft excel set of. How to calculate the food cost for a recipe poster pos. Effective food cost control allows managers to establish correct and. The download version includes both a blank recipe form as well as a sample one.