Food Costing Tool


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

food costing toolMenu Item 
Enter the menu item name

Ingredients
Enter a menu item recipe ingredient under ingredients

Recipe Unit
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.

Quantity
Enter the measurement quantity of the ingredient. Example, French Fries: 6 oz. portion Qty (1). Salt: Teaspoon (.13).

Unit Cost
Enter the unit cost. (What you paid for it from your purveyor).

Extended Cost
The extension columns will automatically calculate and contains formulas. The extension columns are also protected.

Food Cost
The food cost cell contains formulas. This cell represents the extended  grand cost totals.

Menu price
Enter the actual menu price for that particular menu item.

Gross Profit
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

Food Costing Tool

$19.99Add to Cart
View Larger Image
food costing tool

©2012 - 2018 Copyright Workplace Wizards Restaurant Consulting Schim Enterprises LLC

Optimization WordPress Plugins & Solutions by W3 EDGE