recipe cost calculator free excel

Professional Culinary Costing & Margin Analysis System

This system provides a standardized framework for tracking ingredient procurement costs, calculating standardized recipe yields, and determining final plate costs. It is designed for chefs and restaurant managers to maintain updated food cost percentages.

Update Cadence: Review and update ingredient purchase prices [Monthly/Quarterly] or whenever supplier invoices reflect a price change of >5%.

Ingredient & Recipe Costing Table

Column Definitions

• Ingredient: [Text] Name of the raw material.
• Unit: [Dropdown] The unit of measure (e.g., kg, L, unit).
• Purchase Price: [Currency] Total cost paid for the bulk container.
• Unit Qty: [Number] Total quantity contained in the purchased unit.
• Qty Used: [Number] Amount required for the specific recipe.
• Cost per Portion: [Currency] Calculated cost of the ingredient used in the recipe.

Implementation Formulas

Calculate Cost per Unit: =(Purchase Price / Unit Qty)

Calculate Cost per Portion: =(Qty Used * (Purchase Price / Unit Qty))

Calculate Total Recipe Cost: =SUM(F2:F10)

Calculate Suggested Menu Price (assuming 30% Food Cost Target): =(Total Recipe Cost / 0.30)

Data Validation & Formatting Rules

• Data Validation (Units): Create a dropdown list in the "Unit" column using: kg, g, L, ml, oz, lb, unit.
• Conditional Formatting (High Cost): Highlight cells in the "Cost per Portion" column where the value exceeds [0.00] using a "Greater Than" rule with a red fill.
• Conditional Formatting (Data Integrity): Apply a "Formula is" rule to the "Purchase Price" column: =ISBLANK(C2) to highlight missing price data in yellow.