Basic standalone sheet
- Prices are typed into individual recipes.
- The same ingredient can be named or converted differently.
- A new invoice may require finding and editing many formulas.
- Plate, inventory and purchasing work remain separate.
Restaurant recipe costing in Excel
Build a recipe-costing spreadsheet that stays useful after prices change.
A reliable food-cost workbook connects the supplier pack you buy to the usable unit a recipe consumes. This guide walks through that chain—from invoice price and yield to recipe, portion and finished plate cost.
No sign-up requiredBuilt for restaurant kitchensWorks with common weight units
Free worked example
Convert a supplier case price into a usable recipe cost.
Change any field below. This single-ingredient example shows the conversion math clearly; a complete recipe repeats it for every ingredient and adds the line costs.
Calculated result
- Purchased quantity
- 480.00 oz
- Usable quantity after yield
- 432.00 oz
- Cost per usable ounce
- $0.1111
- This ingredient's recipe line cost
- $7.11
- This ingredient's cost per portion
- $0.89
- Ingredient share of selling price
- 6.3%
This percentage covers only the ingredient entered above. Add every ingredient's portion cost before calculating the complete recipe or plate food-cost percentage.
A defensible costing workflow
Seven steps from the invoice to the finished plate.
The arithmetic is simple. The challenge is preserving the relationship between unlike purchase packs, usable yields, recipe units and changing supplier prices.
- 1
Record the actual purchase pack
Start with the invoiced price, the number of units in the case, the size of each unit and the purchase unit. “One case” is not enough information to cost a recipe.
- 2
Normalize the purchase quantity
Convert the pack to a consistent base unit such as ounces, pounds, fluid ounces, milliliters or each. Keep weight and volume separate unless a tested conversion supports the change.
- 3
Apply usable yield
Account for trim, peel, bone, drained weight, cooking loss or other waste. A $48 case with 90% usable yield has a higher usable-unit cost than its purchase-unit cost suggests.
- 4
Match the recipe unit
Convert the usable ingredient cost into the unit the recipe actually uses. This is what allows a case, bottle or bag to become an accurate ounce, pound, milliliter or each cost.
- 5
Calculate every recipe line
Multiply each ingredient's usable-unit cost by its recipe quantity, then add the line costs to find the batch cost.
- 6
Divide by usable portions
Use the number of portions the kitchen can actually serve—not merely the theoretical yield. The result is the recipe cost per portion.
- 7
Build the complete plate
Add every prepared recipe and direct ingredient served on the plate. Divide the finished plate cost by its selling price to calculate the plate food-cost percentage.
Spreadsheet structure
The fields a useful restaurant costing sheet needs.
A recipe name, quantity and price are not enough. These fields preserve the conversion path and make the result reviewable.
| Field | What it records | Why it matters |
|---|---|---|
| Purchase price | The current invoiced price for the case, pack, bottle, bag or each. | Anchors the calculation to what the restaurant actually paid. |
| Pack configuration | Units per case and the size of each unit. | Turns “case” into a measurable purchased quantity. |
| Purchase unit | Case, pack, bottle, bag, pound or each. | Prevents incompatible units from being treated as equivalent. |
| Usable yield | The percentage remaining after trim or process loss. | Calculates the cost of what can actually be served. |
| Recipe quantity and unit | The amount of the ingredient used in the batch. | Connects the ingredient cost to the recipe line. |
| Recipe yield | The usable portions produced by the batch. | Converts the batch total into cost per portion. |
| Selling price | The menu price for one portion or finished plate. | Supports food-cost percentage and contribution analysis. |
From template to operating system
A costing sheet becomes more useful when receiving and recipes share the same ingredient record.
Connected InsightChef Pro workflow
- Receiving captures the current ingredient purchase cost.
- Saved pack profiles preserve vendor-item conversions.
- Recipe and plate costing can refresh from the current ingredient cost.
- Inventory, production, waste, menu analysis and culinary intelligence use the same operating data.
Know the numbers
Recipe cost, portion cost and plate cost are related—but not interchangeable.
Recipe cost
The sum of every ingredient line in one batch. A sauce, bread dough or finished entrée recipe can each have a batch cost.
Cost per portion
The recipe batch cost divided by its usable portions. This is the cost of one consistent serving of that recipe.
Plate cost
The sum of every recipe component and direct ingredient served on one complete menu item.
Food-cost percentage
The complete portion or plate cost divided by selling price, multiplied by 100. Use the full cost—not a single ingredient—to evaluate the menu item.
Restaurant recipe-costing questions
Common questions, answered clearly.
How do you calculate the cost of a restaurant recipe?
Convert every ingredient's purchase price into a cost per usable recipe unit, multiply by the quantity used, and add all line costs. Divide the total recipe cost by the number of usable portions to find cost per portion.
How do you include ingredient yield in recipe costing?
Multiply the purchased quantity by the usable-yield percentage. Divide the purchase cost by that usable quantity—not by the original purchased quantity—to calculate the true cost per usable unit.
What is the difference between recipe cost, portion cost and plate cost?
Recipe cost is the total of every ingredient in one batch. Portion cost is the batch cost divided by usable portions. Plate cost combines every recipe component and direct ingredient served on the finished plate.
Can an Excel recipe-costing workbook update when supplier prices change?
Yes, if ingredient costs and recipe quantities are connected. In InsightChef Pro, a posted receipt updates the ingredient's current cost, and recipe and plate costs can then be refreshed from that current cost.
One connected kitchen workflow
Ready to move beyond disconnected costing sheets?
InsightChef Pro DIY Chef connects receiving, ingredient costs, recipes, plates, inventory, production, waste, labor, reporting and culinary pairing in one Excel workbook for Windows.
View the DIY Chef packageExplore the training
One-time $295 license for one named purchaser and one business location. Microsoft Excel desktop for Windows is required.