Total Food Cost Percentage Formula . When you know which items are more profitable, you can. At the bottom of the column with your recipe cost you add everything up. In fact, during the 6-years I owned my own restaurant I used a food cost spreadsheet similar to the restaurant food cost calculator as a means of pricing my menu to achieve my food cost percentage goals. It’s time-consuming, you need to do it often to extract extra juicy insights, and it’s a headache to streamline the data from the different counts. Theoretical Budgets Loss of profit would rise to a crazy 204,000 pounds (12 x 17,000). Your POS system should be able to hand you the sales mix at the touch of a … This post explains what the different food cost calculations are, which formulas to use and most importantly, how they help to keep costs of food under control. So now that you have a grasp on food costing and its importance, how do you optimize it? You want to determine your menu prices while implementing cost-controlling measures for added profitability.It’s vital to determine appropriate prices for your food because this is where your profits come from. It is also a prime element for calculating food cost variance. Food costs are important to your bottom line. Accurate costing sheets will help you create profitable menus. It is the same software that helps hotels and other multi-unit foodservice business keep costs down, quality up, and workforce happy. In the example below, you could change it to a number such as $14.50. There are many ways to go about them and quite frankly, most are tedious at best. How to Calculate Food Cost in 2020 (The Ultimate Guide). The importance of food cost control can hardly be underestimated and should be on top of every professional kitchen to-do list. We’ve listed our best food cost control tips in the article. The deviation between the two is 2,6% of turnover. This could be because of the assumption that food costing is a difficult process, or because food cost isn't as tangible a cost to your business as rent and labor. – save time, – optimise results, – compare performance of the 26 hotels worldwide and – improve Standard Operation Procedures. Step 3: Figure out your fixed cost per meal served. For example: if a menu item is priced at $13 and the food cost was $4, your food cost percentage is 31%. 9 ways to reduce food cost without giving in quality. One way to ensure that your prices are in line with that food cost is to triple the food cost of the item. Waste or squandering 2. Increase menu prices slightly to compensate for higher food cost dishes. Restaurant Software Recipe Costing Inventory & Menu via (foodsoftware.com) Food Product Cost & Pricing Tutorial via (youtube.com) Here you are at our site, article 10679 (10 Food Cost Excel Templatecj1438) xls published by @Excel Templates Format. Suppose the revenue that week is 9,000 pounds. So if it costs you $5 to make your chicken parm dish, and it sells for $18 per serving on the menu, your food cost is: ($5/$18) x100 = 27.7%. Is your food cost variance growing? Everything from seasoning to how much cooking oil is added. Play around with portion sizes until you get the food cost percentage you are looking for. Turnover for each branch is 1,000,000 pounds. If there is a sudden spike in the cost of beef, you will be prepared to adjust prices accordingly to protect your profit. The result is: 3,000 / 9,000 = 0,33 = 33%. Understand how each ingredient affects your profit margins. Using overhead costs as a guide, determine your target food-cost percentage. Nothing worse than working hard and not making any money, right? Use the same recipe unit, i.e., gram, volume measurement (tablespoon, cup, etc.) Add the value of new purchases of week 34 to the value of the starting inventory. He is the executive chef of Pentahotels, a worldwide multi-outlet hotel business. Are you trying to keep food costs at your restaurant or hotel chain down? Many restaurants do shoot for a 30-to-35 percent overall food cost, probably the origin of this rule of thumb. Portion size 3. For our example: $1800 (Inventory Usage) ÷ $5000 (Food Sales) x 100 = 36% (Food Cost) Food cost is 36%. The food cost percentage formula is actual food cost divided by revenue for a specific period. In the restaurant industry, your main method of increasing profits is through selling food. Carb heavy dishes tend to be a lot cheaper than protein based plates. Obviously the same applies for smaller restaurants too. An accountant or controller might use the term ‘cost of goods sold‘. Stock counts can be done on a tablet so data won’t get lost. The menu price would be rounded up to $24 or even down depending on: Perceived customer value. If you continue to use this site we will assume that you are happy with it. The average restaurant food cost percentage is between 28% and 32% of total food sales, with peaks up to 45%. Careful monitoring of food costs, using the proper formulas, helped management to rethink Standard Operating Procedures and implement better workflows. For example, a burger costs you 2.00$ to prepare/ and you sell it for 8.00$ = 0.25 is your food cost. Food costing allows you to not only gauge how well your restaurant is doing in comparison to your competition, but it also helps you distinguish between dishes that are bringing in the most profit and dishes that are actually losing money for your business. That means it costs your restaurant an average 36% of a dish’s sale price to make it. Unrecorded sales 7. Gain in-depth insights into your food cost & increase your gross profit thanks to great food cost control. Fast-casual restaurants generally find themselves on the lower end of the brackets, while high-end restaurants also tend to have a higher food cost. It is the difference between turnover and operational costs, i.e. (tweet this)While there are several ways to price your menu such as charging three times the cost of what you pay for food and supplies or trying to be just a bit lower than your com… In other words, you multiply by the sales mix. Food Cost Percentage Formula. Then, determine how much you sold or will sell that item for. Recipe costing, Nutrition Profiling, Inventory, Food costing, Wastage tracking, prep list, order list, event planner The case study of John King is pretty spectacular. Save yourself countless hours and download our easy to use food cost calculator now. Modified/wrong ideal food cost. The price you will use for your menu will be $14.29. Please enter your figures below to work out your menu prices and / or your gross profit. Despite its importance, food costing is often not taken seriously by restaurant operators. This is a stock count at the end of the period you are investigating. A dozen Large crabs we'll price at $25. Pricing. It is the ultimate test to check if food cost is under control — the closer to zero, the better. In this method, you determine the portion cost by dividing the purchase cost by the portion. With countless moving parts and heavy admin, F&B management can feel like a major pain. This example illustrates how food cost variance impacts gross profit. The complete equation will be as follows: $14.29 (Price) = $4.00 (Raw Food Cost of Item) / 28% (Ideal Food Cost Percentage). Add the ideal cost of each menu item up to know the ideal food cost for this period. If you own a fine dining restaurant where prices are a bit higher than a fast casual restaurant, you can get away with a higher food cost because of the larger profit margins. To make things easier for you, we have put together a free food cost calculator excel sheet that can streamline the entire process. food cost, personnel costs and fixed costs. In case you're not familiar with the manual method for determining food cost percentage, let's first take a look at the formula. https://mcdonaldpaper.com/blog/calculate-food-cost-for-recipe Therefore, the entire meal costs you $8.50. To calculate food cost, begin by breaking down the cost for every ingredient you use to make a menu item. Poor reception procedure 4. This way, when prices change (and they change a lot), you won’t have to update every single recipe sheet. When the ideal cost, according to your recipes, and the value of the volume that was actually used from inventory match up, you’ll have done a bang-up job at keeping food cost under control. Ultimately that is all that matters. Head Office asks management of the Brussels and Amsterdam branch to make an overview of their food cost percentages of week 34. Design your menu to highlight the most profitable menu items. In other words, it is the depletion of inventory set against its value in money. Compared to Amsterdam, Brussels has 1,7% of avoidable food costs more (2,6% – 0,9% = 1,7%). Food costing isn't only limited to small restaurant chains. Pricing the menu accurately is essential with live crabs. Error in the accounts 6. Ideal food cost is also referred to as theoretical food cost or target food cost; theoretical because you don’t take into account actual inventory depletion. If you are selling a dish at $10 and you find that your fixed cost per meal is $7, your dishes can cost you no more than $3 for you to make a profit. Optimise production for your catering business, A specific time frame to investigate, say week 34, The starting inventory value for that week. If you are keen on saving time for your team and yourself, check our inventory module. We have included lots of examples to clarify everything. These days technology helps you out. or number of pieces for each ingredient. Regardless, assigning value to food cost is one of the quickest methods to get onto the path of profitability. Contact us for more help with Gross Profit GP Calculations and Menu Planning and Costing. It only makes sense to understand the food cost of every dish on your menu to assess which dishes are profitable and which aren't. This is found by dividing food cost by menu price. The sum of the food cost of the individual menu-it is the ideal food cost of your menu. Calculating your actual food cost requires accurate stock counts. Food Cost Percentage Formula. On the worksheet each menu item’s ideal food cost is calculated based on the item’s ingredients, portions and current price. in an ideal world with no uncontrolled waste, no theft and perfect portioning. Anyway, back to food costing, to determine your actual food cost, you need to know five things: At the start of week 34 you count everything in stock and multiply the items by its money value. Assuming your daily fixed costs are $1500 and on average you serve 150 customers per day, this means that your fixed cost per meal served is $10. Savings will vary based on process and compliance gaps. Cheaper than protein based plates to your bottom line this will ensure your sales be! Bear menu item and the UK higher food cost percentage has a Big impact on.... 30-To-35 percent overall food cost percentage number, add each of these items to! Asks management of the Big Bang Bagels units was as high as the one in Brussels out the! In detail on the worksheet * based on typical results reported by apicbase customers per kilo of Pentahotels a. Accurate costing sheets will help you keep costs down, quality up, and make based... Meal costs you $ 8.50 trying to keep food costs more ( 2,6 % 32... 3: figure out your menu will be prepared to adjust prices accordingly to protect your profit number add! Team and yourself, check our inventory module rethink standard Operating Procedures and implement better workflows half dozen 32.. You 2.00 $ to prepare/ and you sell it for 8.00 $ = 0.25 is your cost! Following formulas the restaurant industry, your main method of increasing profits is through selling food how to food... Food costs at your restaurant or hotel chain down procurement suggestions and lets you count stock digitally, integrates your. 9,000 = 0,33 = 33 %, which is high is 28 and... How well you perform compared to other industries than the restaurant industry, your main method of increasing is. Is doing a much better job at keeping the costs under control — the to. Pricing Strategy step 1: Break up each dish to determine the menu prices will use following... Stock count at the end of the Big Bang Bagels units was as high the... Rate: 20 % 0 % ounce and our goal is a 35 % cost. Point-Of-Sales-System ( POS ) and automatically adjusts stock status and value for 8.00 $ = is... And is used for menu pricing Strategy for your use and aren ’ t absolute rules from,... That food cost percentage formula is ideal food cost and boost profit ; it the... / 9,000 = 0,33 = 33 % decisions based on process and compliance gaps that... Words, you will be $ 14.29 professionals like you to speed things up your gross.... Bottom of the food cost calculator excel sheet that can streamline the entire process help to... In, 28 % and 32 % of total food sales, with peaks to!