Food Cost Formula Excel

Restaurant profitability lives or dies by the food cost percentage — the portion of each sale that goes to ingredients. A $20 entree with $6 in ingredients yields 30% food cost, leaving $14 for labor, rent, utilities, and profit. Most restaurants fail because they never calculate this number accurately, pricing menu items by gut feeling rather than hard math.

The formula divides ingredient cost by portion count to find cost per serving, then compares that to your selling price. If your chicken dish costs $3.50 to make and sells for $16.95, your food cost is 20.6% — excellent margins. But if you are eyeballing portions and the actual cost creeps to $5.25, suddenly you are at 31% and profit margins shrink fast.

Portion control makes or breaks this calculation. A recipe designed for 8 servings that actually yields 6 inflates your cost per serving by 33%. This tool assumes consistent portioning — weigh your proteins, measure your sauces, and train staff to serve identical portions every time.

Use this calculator when creating new menu items, reviewing existing recipes for profitability, or adjusting portion sizes to hit cost targets. It works best for items with measurable, consistent ingredients — entrees, appetizers, and sides where you control every component.

This formula does not work for buffet pricing, family-style service, or items where customer consumption varies widely. Variable-portion items like soup refills or bread service require different costing models that account for average consumption rather than fixed portions.

Restaurants consistently underestimate ingredient costs by forgetting about waste, trim loss, and cooking shrinkage. A $12 protein that loses 25% to trimming actually costs $16 per usable pound — your calculations are off by 33% before you start cooking. Include all costs: the expensive herbs that finish the plate, the oil for sautéing, even the lemon wedge garnish.

Owners often calculate food cost on the full recipe batch rather than per portion served. A sauce recipe that costs $8.50 and yields 16 portions costs $0.53 per serving, not $8.50. This mistake inflates apparent food costs by 1,500%, making profitable items look like money losers.

Menu pricing based on competitor analysis ignores your actual costs. Your $18 burger might match the restaurant next door, but if your food cost is 45% while theirs is 25%, you are hemorrhaging money on every sale. Price to your costs first, then adjust for market positioning.

The core formula is Cost Per Serving = Total Ingredient Cost ÷ Number of Portions. If your ingredients cost $24.60 and yield 12 portions, each serving costs $2.05. Food Cost Percentage = (Cost Per Serving ÷ Selling Price) × 100. At a $8.50 menu price, your food cost is 24.1%.

Recommended pricing flips this relationship: Selling Price = Cost Per Serving ÷ (Target Food Cost % ÷ 100). To achieve 30% food cost on a $2.05 dish, price it at $2.05 ÷ 0.30 = $6.83. Round to $6.95 for menu appeal.

Margin calculation reveals profit potential: Gross Profit = Selling Price - Cost Per Serving. That $6.95 item generates $4.90 gross profit per sale. Multiply by covers per day to project revenue. A 40-cover night on this item produces $196 gross profit before labor and overhead costs.

Professional kitchen managers track food cost variance — the difference between theoretical food cost (based on recipes) and actual food cost (based on inventory). A 3-5% variance is normal; anything higher signals portion control breakdown, theft, or spoilage issues. Weekly inventory counts reveal where your calculated costs diverge from reality.