Home / Free tools / Food Cost & Inventory
Excel · 6 KB
Recipe Costing Calculator
An Excel sheet for costing a single recipe line by line. Enter each ingredient's recipe quantity, unit and cost per unit; the sheet multiplies them into a line cost and totals the plate. Fifteen ingredient rows, six of them pre-labelled as an example.
- Format
- Excel workbook
- Size
- 6 KB
- Price
- Free, no sign-up
- Section
- Food Cost & Inventory
What's in it
- One row per ingredient: quantity, unit, cost per unit and calculated line cost
- Fifteen rows, enough for a composed plate
- An example recipe already filled in as a pattern to follow
- Line costs total into a plate cost you can price against
How to use it
- Use the cost per unit you actually pay, from a current invoice, not list price
- Enter the recipe quantity in the same unit as the cost - ounces against a cost per ounce
- Include every ingredient, oil and seasoning included; they are small and they add up
- Recost the plate whenever a key ingredient's price moves
The guide that explains it
How to Cost Out a Recipe Step by Step — Recipe costing tells you exactly what a dish costs to make so you can price it for profit. Here's the step-by-step method with a worked example.