What is included
- Ingredient records combine purchase-pack prices, units and usable yield with recipe quantities.
- Menu rows calculate plate cost, food-cost percentage and a price illustration based on your target.
- Unit conversion, ingredient-price changes and menu-category comparisons feed the dashboard.
- Includes Google Sheets and demo/blank Excel files; the script menu and backup/reset buttons are Sheets-only.
Based on the Etsy listing reviewed October 28, 2026. Check the current listing for any later changes.
What to prepare
For the workflow this product is designed around, gather:
- Supplier pack sizes and current pack prices
- Ingredient quantities used by each recipe
- The actual yield or number of servings
A practical way to use your records
Use matching units when comparing a purchased pack with the quantity used. Cost a defined batch, check its yield and review plate costs alongside your menu-price inputs. Update ingredient prices when your supplier records change rather than assuming an old estimate still applies.
A worked example
Fictional example: a cook checks ingredient cost per portion for a batch before considering a menu price.
- Flour used
- 2 kg from a 10 kg pack costing $20
- Other batch ingredients
- $8 in total
- Actual batch yield
- 12 equal portions
- Keep pack quantity and recipe quantity in the same unit before calculating the flour used.
- Add the ingredient costs and divide by the portions actually produced; review other costs separately when considering a selling price.
Result: Flour costs $4 for this batch. Combined ingredients cost $12, or $1 per portion. The example excludes labor, packaging and overhead, so $1 is an ingredient-cost result rather than a recommended menu price.
Fictional figures explain the workflow; they do not represent customer results or guarantee particular template fields. See the included features above and the current Etsy listing.
A closer look at Recipe Cost Calculator & Restaurant Menu Pricing Spreadsheet
Additional previews from this product's Etsy listing. Open any image for a larger view.
Learn the method
Questions about this product
Does the template cover plate costs and menu prices?
Yes. Recipe costs, plate costs, food costing and menu pricing are included.
Can I try a basic recipe calculation first?
The separate free recipe cost calculator on this site shows a simple batch calculation. It is a learning tool, not a copy of this paid spreadsheet.
Which spreadsheet formats are listed?
This product is described for Google Sheets and Excel. Confirm the included files, software requirements and delivery instructions on its current Etsy listing.
