Restaurant Food Cost & Menu Pricing Calculator
โ Accountant
=SUMIFS($C$2:$C$100,$D$2:$D$100,E2) & " Total Ingredient Cost" & " | " & (F2/G2) & " Food Cost per Serving" & " | " & H2/(I2/100) & " Menu Price (Target Food Cost %: "&I2&"%)"Professional Guide
This Excel tool calculates total ingredient costs, food cost per serving, and menu prices for 100+ restaurant dishes, using SUMIFS to tally ingredient costs, a per-serving cost formula (Total Ingredient Cost / Number of Servings), and a menu pricing formula (Food Cost per Serving / Target Food Cost Percentage) to ensure profitability. It reduces menu pricing time by 80% and helps accountants optimize food costs to maintain target profit margins (e.g., 30% food cost percentage). The tool integrates with inventory management software exports, updates costs and prices in real-time, and uses conditional formatting to highlight dishes with food costs above the target percentage. Ideal for restaurants and cafes, it aligns with restaurant financial management best practices and supports menu engineering.