What Is a Food Cost Spreadsheet?
A food cost spreadsheet is the document restaurant operators use to calculate how much of every revenue dollar is consumed by ingredients. It sits at the core of margin management — if you don't know your food cost percentage, you can't price menus accurately or catch waste before it compounds.
The Core Formula
Food Cost % = (Beginning Inventory + Purchases − Ending Inventory) ÷ Food Sales × 100
Target ranges vary by concept, but most full-service restaurants aim for 28–35%. A percentage consistently above that range signals over-ordering, spoilage, portion drift, or theft.
Key Fields to Include
A reliable food cost spreadsheet should capture:
- Ingredient name & unit (e.g., chicken breast, lb)
- Vendor invoice price per unit — updated each delivery
- Recipe quantity used per portion
- Cost per portion (unit price × quantity)
- Menu selling price
- Theoretical food cost % per dish
- Beginning and ending inventory counts by period
- Actual purchases pulled from invoices
- Actual vs. theoretical variance — the gap that exposes waste or theft
Worked Example
A 6 oz salmon fillet costs $4.20. Plating garnish and sauce add $0.80. Total plate cost = $5.00. If the menu price is $28, theoretical food cost = 17.9%. If your period-end actual cost comes in at 23%, that 5-point gap — roughly $1.40 per cover — is worth investigating immediately.
Why Spreadsheets Break Down
Spreadsheets work until vendor prices change, a prep cook updates a recipe, or someone forgets to log a delivery. Manual entry takes hours each week, and by the time the numbers are in, the problem has already cost you money.
How Hubstaurant Automates This
Hubstaurant reads your vendor invoices automatically, so every price-per-ingredient updates the moment a delivery is recorded — no manual entry. Its food-cost analytics engine calculates actual vs. theoretical variance per dish in real time, and the theft and leakage detection layer flags unusual gaps before they become a margin crisis. You get the same visibility a spreadsheet provides, without the spreadsheet.
If you're still managing food cost in a spreadsheet, [start a free trial of Hubstaurant](#) and see how much time you get back in the first week.