This template helps you calculate Plate Cost, determine Target Menu Selling Prices, and monitor Gross Profit Margins for your food and beverage operation.
Download Links
📊 Excel Template: Download Recipe_Cost_and_Pricing_Calculator.xlsx
Google Sheet :
Download Links
📊 Excel Template: Download Recipe_Cost_and_Pricing_Calculator.xlsx
Google Sheet :
Google Sheet :
1. Introduction
In the food service and restaurant industry, pricing menu items correctly is essential for maintaining profitability. One of the most fundamental pricing formulas used by chefs, restaurant managers, and culinary professionals is:
Target Menu Selling Price = Ingredient Cost per Portion ÷ Target Food Cost Percentage
Where Plate Cost represents the total raw ingredient expense required to prepare a single menu item portion. If you know how much your raw ingredients cost and have a target food cost percentage in mind (typically between 25% and 35%), this formula tells you exactly what price you should charge on your menu to achieve your desired profit margin.
This Excel template is built to automate these calculations. It eliminates manual spreadsheet errors, helps you standardize recipe portioning, and allows you to audit your menu profitability across categories.
2. Overview of the Excel Workbook
The workbook is structured into two interconnected tabs:
- Tab 1: Recipe Costing — A detailed, ingredient-by-ingredient calculator for a single menu item. It converts bulk purchase pack sizes into individual unit costs, applies portion quantities, adds an optional waste allowance buffer, and calculates the suggested selling price automatically.
- Tab 2: Menu Master Summary — A multi-item dashboard where you can list your entire menu. It compares your actual selling prices against your calculated target prices, calculates gross profit per portion, and flags items that exceed your target cost threshold.
3. Step-by-Step: How to Use the Template
Step 1: Enter Recipe Metadata (Tab 1)
- Open the Recipe Costing tab.
- In the top information block, enter your Item Name (e.g., Gourmet Burger) and Category (e.g., Main Course).
- Set your Target Food Cost % (for example, enter 0.30 for 30%).
- Enter the Yield / Portions produced by the recipe batch.
Step 2: List Your Raw Ingredients (Tab 1)
- In the ingredients table, enter each Ingredient Name used in the recipe.
- Enter the Recipe Qty and unit of measure needed for one batch or portion.
- Enter the purchase Pack Cost ($) and Pack Size Qty from your supplier invoices.
- The sheet automatically calculates:
- Cost per Unit ($): Pack Cost ÷ Pack Size Qty
- Cost per Portion ($): Recipe Qty × Cost per Unit
Step 3: Review Plate Cost & Menu Target Price (Tab 1)
At the bottom of the table, check the Total Plate Cost cell. This sums all individual ingredient expenses. In the summary section below, you can add a waste buffer (default is 5%) and review the calculated Target Selling Price alongside your actual menu price to see your gross profit margin.
Step 4: Audit Your Entire Menu (Tab 2)
- Open the Menu Master Summary tab.
- Enter each menu item along with its calculated Plate Cost ($) and desired Target Food Cost %.
- Input your Actual Selling Price ($).
- The template will automatically calculate the Actual Food Cost Percentage, Gross Profit in dollars, and assign a status label (On Target or High Cost).
4. Key Formula Cheat Sheet
| Metric / Term | Formula | Description |
|---|---|---|
| Unit Cost | Pack Purchase Price ÷ Pack Size Quantity | Finds the cost per individual kilogram, liter, piece, or slice. |
| Ingredient Portion Cost | Recipe Quantity Required × Unit Cost | Calculates the cost of a single ingredient within the recipe. |
| Plate Cost (Raw Expense) | Sum of all Ingredient Portion Costs | The total raw food cost required to build one plate or serving. |
| Target Selling Price | Plate Cost ÷ Target Food Cost % | The minimum menu price required to hit your target cost percentage. |
| Actual Food Cost % | Plate Cost ÷ Actual Menu Selling Price | Your real food cost percentage based on what the customer pays. |
| Gross Profit per Portion | Actual Menu Selling Price − Plate Cost | The dollar amount left over to cover labor, overhead, and net profit. |
5. Frequently Asked Questions (FAQ)
Q1: What is the difference between Plate Cost and Food Cost Percentage?
Plate Cost is a fixed dollar amount representing the cost of raw ingredients on the plate (e.g., $5.00 to make a burger). Food Cost Percentage is a ratio that compares that plate cost to your selling price (e.g., a $5.00 plate cost sold for $16.67 is a 30% food cost).
Q2: What is a standard or "good" Target Food Cost Percentage?
While it varies by restaurant concept, most standard full-service restaurants aim for a total food cost between 28% and 32%. Fine dining establishments may run higher food cost percentages (35%–40%) but make up for it with higher dollar contribution margins. Pizzerias and breakfast spots often run lower food cost percentages (20%–25%).
Q3: Should I include cooking oil, seasoning, and garnishes in my Plate Cost?
Yes! Minor ingredients like cooking oil, salt, finishing herbs, and even takeout packaging add up over hundreds of orders. In our template, you can either list these as small individual quantities or rely on the built-in 5% Waste & Buffer Allowance to capture untracked kitchen consumption.
Q4: Why is my Actual Food Cost Percentage higher than my Target Food Cost Percentage?
If your actual food cost percentage exceeds your target, it means your menu selling price is too low for your current ingredient costs, or your ingredient suppliers have raised prices. You can resolve this by either negotiating better supplier rates, reducing portion sizes, substituting ingredients, or raising the menu selling price.
Q5: Can I use this template for drinks, cocktails, or desserts?
Absolutely. The mathematical formula is identical across all culinary categories. Whether you are costing a steak dinner, a craft coffee, a cocktail, or a slice of cake, simply enter your raw ingredient purchase sizes and portion measurements to find the cost per portion.
6. Best Practices for Menu Costing
- Update supplier prices monthly: Food prices fluctuate seasonally. Regularly updating your pack purchase prices ensures your target pricing remains accurate.
- Account for yield loss (trim waste): When buying whole produce or meats, remember that peeling, trimming, and cooking shrinkage reduce your usable weight. Always price ingredients based on usable yield.
- Balance percentage with cash contribution: Do not rely solely on low food cost percentages. A high-cost steak at 38% food cost might generate $18 in gross profit, whereas a salad at 20% food cost might only generate $8 in gross profit.
Comments
Post a Comment