Food cost creep
Ingredient prices shift weekly. Without a tracker, a 2% food cost jump hides until the P&L lands — weeks too late.
Six spreadsheet templates and checklists that restaurant and bar operators actually use — built to pair with ProfitToolsLab calculators so you can stop guessing and start tracking.
The problem
Ingredient prices shift weekly. Without a tracker, a 2% food cost jump hides until the P&L lands — weeks too late.
Free-pouring, untracked comps, and draft waste add up to thousands per month. Most bars don't measure until it hurts.
Building the schedule from last week instead of projected sales means you're overstaffed on slow nights and short on busy ones.
What's inside
Each template is a CSV file that opens in Google Sheets, Excel, Numbers, or any spreadsheet app. Pre-built formulas, industry benchmarks, and clear instructions included.
Track beginning/ending inventory, purchases, and food sales weekly. Auto-calculates food cost % with built-in benchmarks for fine dining, casual, fast casual, and bar food.
Pairs with Food Cost CalculatorLog every drink category — bottle cost, pour size, menu price — and compare actual vs. target pour cost. Includes a shrinkage investigation checklist when numbers run hot.
Pairs with Pour Cost CalculatorSchedule every role across seven days with hourly rates. Instant labor cost % against projected revenue. Benchmarks for full-service, fast casual, bar, and cafe formats.
Pairs with Labor Cost CalculatorItemize every ingredient for a dish, calculate plate cost, and set the right menu price based on your target food cost %. Includes margin analysis and quick-reference multipliers.
Pairs with Menu Engineering CalculatorTrack food sales, bar sales, costs, covers, and average check — every day. Auto-calculates food cost %, labor cost %, prime cost %, and profit margin with weekly rollups.
Pairs with Profit Margin Calculator31-item audit across food cost, pour cost, labor, revenue, and operations. Score each item 1–5 to surface your biggest profit leaks and build an action plan.
Pairs with Break-Even CalculatorHow to use it
Run your numbers through our free hospitality calculators to set targets for food cost, pour cost, labor, and margins.
Download the pack, open in your spreadsheet app, and start logging actuals against those targets every week.
When actuals drift from targets, you see it in days instead of months. Use the checklist to diagnose and fix.
Hospitality Profit Pack
CSV files that work in Google Sheets, Excel, Numbers, or LibreOffice. Open, customize, start tracking.
Got the templates? Now get the expert eye.
Fill in the templates, then bring them to a call with an operator who's diagnosed margin leaks across hundreds of venues. We'll tell you what to fix first — no pitch, no obligation, just the math.
Stay sharp
We ship new calculators, spreadsheets, and margin tips every month. Join the list and get them before anyone else. No spam, unsubscribe anytime.
Use these with the pack
Run your numbers live, then log the results in the spreadsheets.