food cost calculator free excel

Professional Culinary Costing & Margin Analysis System

This system provides a standardized framework for tracking ingredient procurement costs, calculating plate costs, and determining target menu pricing.

• Purpose: To maintain consistent food margins and track ingredient price fluctuations.
• Scope: Ingredient-level costing, recipe assembly, and markup calculation.
• Update Cadence: Monthly or upon receipt of new vendor invoices.

Ingredient Database & Costing Table

Column Definitions

• Ingredient Name: [Text] - Descriptive name of the raw item.
• Unit of Measure: [Dropdown] - Standardized unit (kg, L, unit, g).
• Purchase Price: [Currency] - Total price paid per bulk package.
• Purchase Qty: [Number] - Total quantity contained in the bulk purchase.
• Cost per Unit: [Formula] - Calculated cost per single unit.
• Recipe Qty: [Number] - Amount required for one serving of the dish.
• Recipe Cost: [Formula] - Total cost contribution of this ingredient to the plate.

Implementation Formulas

Calculate Cost per Unit (Column E):

=IFERROR(C2/D2, 0)

Calculate Recipe Cost (Column G):

=E2*F2

Calculate Total Plate Cost (Sum of Column G):

=SUM(G2:G100)

Calculate Menu Price based on Target Margin (e.g., 30%):

=Plate_Cost/0.30

Data Validation & Formatting Rules

• Data Validation: Apply a dropdown list to the "Unit of Measure" column using the range: kg, g, L, ml, unit, oz, lb.
• Conditional Formatting (High Cost Warning): Highlight cells in the "Recipe Cost" column where value > $2.00 using a Red fill to identify expensive components.
• Conditional Formatting (Data Integrity): Highlight any cell in "Purchase Price" or "Purchase Qty" that is empty or 0 to ensure all inputs are populated.