small business food costing calculator excel free download

Professional Culinary Costing and Margin Analysis System

This system provides a standardized framework for calculating the exact cost of menu items, managing ingredient overhead, and determining optimal pricing strategies. It is designed for [Company Name] to maintain profitability through real-time margin tracking.

Update Cadence: Review and update ingredient prices monthly or upon receipt of new supplier invoices.

Core Ingredient Costing Table

Column Definitions

• Ingredient Name: [Text] - Descriptive name of the raw material.
• Unit of Measure: [Text] - The standard unit (kg, L, count) used for calculation.
• Purchase Price: [Currency] - The total price paid for the bulk container.
• Pack Size: [Number] - Total quantity of units contained in the purchase unit.
• Cost per Unit: [Formula] - Calculated cost per single unit.
• Usage Amount: [Number] - Amount required for the specific recipe.
• Item Cost: [Formula] - Total cost contribution of this ingredient to the dish.

Essential Spreadsheet Formulas

Calculate Cost per Unit (Column E):

=C2/D2

Calculate Item Cost (Column G):

=E2*F2

Calculate Total Recipe Cost (Sum of Column G):

=SUM(G2:G10)

Calculate Recommended Menu Price (Assuming 30% Food Cost Target):

=SUM(G2:G10)/0.30

Data Validation and Formatting Rules

• Data Validation (Unit of Measure): Select the "Unit of Measure" column, go to Data > Data Validation, and set to "List" with values: kg, g, L, ml, count, oz, lb.
• Conditional Formatting (High Cost Alert): Select the "Item Cost" column and apply a "Greater Than" rule. If the value is > [__________], set the cell background to light red to identify high-cost ingredients that require menu adjustment.
• Conditional Formatting (Margin Check): Apply a "Color Scale" (Green-Yellow-Red) to the final calculated margin percentage to visually identify dishes that fall below the [__________]% target threshold.