Food Costing Tool
This is a valuable food costing tool, why?
It’s all about the profit margin, you can’t guess what you want your prices to be at on your menu. Every ingredient in a specific menu item has a price attached to it. This price is what you paid for it from your purveyor.
First, break down the price per food item.
Example: French fries
- Case price is $30.95
- Bag price is $5.16
- 6 oz. Portion price is $0.38
Portions of the fries are 6 ounces. Each bag of fries weighs 5 pounds. 16 ounces x 5 = 80 ounces per bag. 80/6 = 13.33 portions per bag. The bag price $5.16 divided by 13.33 portions per bag = $.38 a portion. Once you know the breakdown dollar figure of that particular ingredient, enter it in the food costing section of the spreadsheet.
See the example below
Enter a menu item recipe ingredient under ingredients
Click in the recipe unit cell, then click on the drop down box. select either each, oz., gram, liter
cup, tablespoon, teaspoon, milliliter (ml), pint, quart or gallon.
Enter the measurement quantity of the ingredient. Example, French Fries: 6 oz. portion Qty (1). Salt: Teaspoon (.13).
Enter the unit cost. (What you paid for it from your purveyor).
The extension columns will automatically calculate and contains formulas. The extension columns are also protected.
The food cost cell contains formulas. This cell represents the extended grand cost totals.
Enter the actual menu price for that particular menu item.
The dollar difference from the menu price and the extended food cost price
Food Cost Percentage
Extended cost grand total divided by price menu dollar figure.
New Menu Price
Enter a new menu item price
New Food Cost Percent
Enter the projected food cost percentage in this cell. This percentage figure is generally where you want your food percentage to be at for this particular item. Once you enter this percentage in the new food cost percent cell the new menu price cell will automatically calculate a new menu price based on the percentage you have entered.
New Gross Profit
The dollar difference from the new menu price and the extended food cost price located above the old menu price.
Use the adjusted food cost percent cell to generate a new menu price based on the food cost percent that you entered. Example, you entered 25.00% in the adjusted food cost percent cell. The new menu price based on the percentage that you enter is now $1.99.
Use this valuable menu costing tool to get your menu prices in line towards a money making profit. Prices for foods and drinks go up periodically, when this happens your menu prices need to slightly go up in price. This increase is necessary in order to keep that profit margin profitable.
Purchase 6 or more restaurant forms, checklists, training manuals or spreadsheets and receive an automatic 50% off in your cart.
View of of our restaurant forms, checklists, training manuals and spreadsheets.
Workplace Wizards: Restaurant forms & Spreadsheets