Recipe costing template
A recipe costing template lists each ingredient with its purchase unit, price, quantity used and yield, and adds up the cost per portion and the food cost percentage. In ounces, pounds, fluid ounces and gallons, in USD. We email you an Excel workbook and a PDF, Letter size.
A template from Patrono, the food safety, scheduling and food cost app for US restaurants.
Updated

How the template costs a dish
- 1.Quantity per portion. What goes on the plate, in oz, fl oz, lb, gal or each.
- 2.Yield. The share left after trimming. At 75%, a quarter is cut off, so you buy more than you serve.
- 3.As-purchased quantity. Quantity per portion divided by the yield. The workbook does it for you.
- 4.Price. What you pay your supplier, per lb, per gallon or per piece. Ounces are divided by 16 and fluid ounces by 128.
- 5.Cost per portion and food cost. The costs add up to the cost per portion. Divide it by the menu price, before sales tax, and you have the food cost percentage.
Three worked examples
The workbook has a blank recipe and three worked examples with formulas. The prices are an example.
- Classic cheeseburger at $13.95: $3.04 per portion, a food cost of 21.8% and $10.91 per plate after ingredients.
- Chicken Caesar salad at $14.50: $3.20 per portion, a food cost of 22.1% and $11.30 per plate.
- Margarita at $12.00: $1.91 per drink, a food cost of 15.9% and $10.09 per drink.
The template
One line per ingredient, with the unit, the quantity per portion, the yield, the as-purchased quantity, the price and the cost. We email you an Excel workbook and a PDF, Letter size.
Recipe costing template
The cost per portion and the food cost percentage of one dish, drink or beverage. The grey columns calculate themselves in the workbook.
Dish: ____________________________
Menu price: $____
| Ingredient | Unit | Quantity per portion | Yield % | As purchased | Price $ per lb, gal or each | Cost $ |
|---|---|---|---|---|---|---|
| Ground beef, 80/20 | oz | 6 | 100 | 6 | $4.00 | $1.50 |
| Brioche bun | each | 1 | 100 | 1 | $0.48 | $0.48 |
| Cheddar, sliced | oz | 0.75 | 100 | 0.75 | $5.12 | $0.24 |
| Tomato | oz | 1 | 90 | 1.11 | $2.16 | $0.15 |
| Lettuce, onion and pickles | each | 1 | 100 | 1 | $0.12 | $0.12 |
| French fries, frozen | oz | 4 | 100 | 4 | $1.60 | $0.40 |
| Ketchup, mustard and mayo | fl oz | 1 | 100 | 1 | $19.20 | $0.15 |
The rows are an example: a classic cheeseburger at $13.95, $3.04 per portion, a food cost of 21.8% and a margin of $10.91 per plate.
Costed on: __/__/____
Cost every dish in one app
Patrono costs each recipe from the amount of every ingredient and what you pay for it. When a supplier raises a price, enter it once, and the food cost and margin of every dish that uses that ingredient update at once. Start with 14 days. $0 today, cancel before day 15 and nothing is charged.
Frequently asked questions
What does it cost?
Nothing. Enter your email and we send you the files.
How do you calculate the cost of a recipe?
For each ingredient, divide the quantity per portion by the yield to get the as-purchased quantity, and multiply it by what you pay per lb, per gallon or per piece. The costs add up to the cost per portion. Divided by the menu price, it is the food cost percentage.
What is yield in recipe costing?
The share of what you buy that ends up in the dish after trimming. Romaine at a 75% yield means that for 4 oz on the plate you buy 5.33 oz.
Can I cost recipes in an app?
Yes. Patrono costs each recipe from the amount of every ingredient and what you pay for it. When a supplier raises a price, enter it once, and the food cost and margin of every dish that uses that ingredient update at once.