Excel workbook
Recipe Costing and Menu Pricing Workbook: Cost per Portion and Price for Your Target Food Cost in Excel
Enter what you pay for ingredients and what each recipe uses, then see the cost per portion and the price that reaches your target food cost.
$24 one time · example and blank copies · download link by email
Who it is for
Bakeries, cottage-food sellers, caterers, cafes and food trucks that want to know what each portion costs and what to charge.
Why it is different
- It converts between grams, ounces, pounds, milliliters and fluid ounces for you, and warns when a unit cannot match an ingredient.
- The price comes from your own target, so nothing is assumed about what food cost should be.
- A filled example for an invented bakery and a blank copy with working formulas.
What is inside
- Start Here. What the workbook does and how to fill it in.
- Setup. Your target food cost percentage, optional labor and overhead, and how to round prices.
- Ingredients. A price list that works out the cost per gram, per milliliter or per item, allowing for trim and waste.
- Recipes. Up to ten recipes with unit conversion, a batch size scaler, cost per portion and the price for your target.
- Menu Summary. Every item side by side with its food cost percentage and a flag for items outside your target.
- Checks. Missing prices, mismatched units and zero yields.
A look inside
Example data, real formulas
Get it
Recipe Costing and Menu Pricing Workbook
Want every toolkit? The toolkit membership includes all of them, with a lower rate if you pay yearly.
Delivered as a zip of editable Word files and printable PDFs. For one business, your own use. General information and templates, not legal, tax or accounting advice. Costs are based on the prices you enter. This is not a food-safety, allergen or labeling tool. Not tax, legal or accounting advice. Payment is handled by Stripe. If a file will not open or something looks wrong, reply to your order email and we will make it right.
Free starter
Try a free one-tab version first
A small working Excel file with the same kind of math, filled with made-up example numbers you can type over. We send one confirmation email, and no series follows.
Rather hand it off?
We can keep the books for you each month
If tracking this yourself is more than you want to take on, we do monthly bookkeeping in QuickBooks, Xero or Excel. Tell us what you use and what is behind, and we reply with a written quote after a short review of your books. No obligation.
Get a bookkeeping quote Free books health checkPrefer to keep it yourself but want a hand getting started? Book a 45 minute setup session ($65).
Buy it with the others