Report this item to Etsy

Restaurant Food Cost Spreadsheet for Excel, Recipe Costing Calculator, Menu Engineering, Plate Cost and Food Cost Percentage

Price:$16.99

Loading
Includes Etsy Purchase Protection

You can only make an offer when buying a single item

Highlights

  • Designed by SteadyBooks
  • Digital download
  • Digital file type(s): 1 ZIP

Know what every plate costs and what your kitchen really spends. Cost each dish from real ingredient prices with trim and waste built in, compare its food cost % with your target and get a suggested menu price. Add units sold to sort the menu into Stars, Plowhorses, Puzzles and Dogs, and track actual weekly food cost from your inventory counts.

WHY YOU WILL LIKE IT
- See the true cost of every plate, including trim and waste.
- Spot dishes above your target food cost and get a suggested price.
- Menu engineering shows which dishes to feature, re-price, promote or drop.
- Track actual weekly food cost % against your target.
- Compare what the menu should cost with what the kitchen really spends.

FEATURES
- Ingredient list for 200 items with usable yield % for trim and waste
- Recipe costing: 60 dishes from 800 ingredient lines with plate cost and food cost %
- Suggested menu price from your target food cost %, rounded up
- Menu engineering: popularity, profit and the Star / Plowhorse / Puzzle / Dog class for every dish
- Weekly actual food cost from opening inventory, purchases and closing inventory against food sales
- Dashboard: menu food cost %, latest and average weekly food cost %, items over target, Stars and Dogs
- 3 automatic charts: weekly food cost vs target, plate cost vs price, profit by menu class
- Row checks for unknown dishes and ingredients, missing prices and missed counts

EXAMPLE (fictional sample data)
In the fictional bistro sample, the classic burger costs $2.26 a plate. The ribeye steak runs at a 35.9% food cost against a 30% target, so the suggested price is $40.75. Actual food cost averaged 31.1% over 10 weeks, and the menu has 3 Stars and 2 Dogs.

WHAT'S INCLUDED
- Restaurant-Food-Cost.xlsx - blank workbook
- Restaurant-Food-Cost-SAMPLE.xlsx - the same workbook with a fictional bistro menu and 10 weeks of counts
- User-Guide.pdf - getting started, how food cost and menu engineering work, Google Sheets steps
- Weekly-Count-Checklist.csv - a weekly inventory and costing routine
- README.txt - quick start

HOW TO USE
1. Download the ZIP after purchase and unzip it.
2. Open Restaurant-Food-Cost.xlsx in Excel (or upload it to Google Drive and save as Google Sheets).
3. Set your target food cost, add ingredients, then dishes and their recipe lines.

COMPATIBILITY
- Microsoft Excel (desktop): tested in Microsoft 365 for Windows. Uses features available since Excel 2013.
- Google Sheets: built only with formulas that Google Sheets also supports; upload the .xlsx to Google Drive and choose File > Save as Google Sheets. Live Google Sheets testing is pending - see the note in the guide.
- Not tested in Apple Numbers, LibreOffice or Excel for Mac.

PLEASE NOTE
This is a digital download - no physical product will be shipped. Please read the description and compatibility notes before purchasing. Sample restaurant, prices and sales are fictional. A costing and planning tool, not accounting or food-safety advice.

FAQ
What is usable yield %?
The share of what you buy that ends up on the plate after trimming, bones, peel or waste - for example 75% for lettuce. The usable cost per unit goes up to cover it.

How is menu engineering worked out?
A dish is popular when its share of units sold is at least 70% of an equal share, and high margin when its gross profit is at least the average profit per unit sold. Both rules are on Settings.

Does plate cost include labor?
No. Plate cost is food only, which is how food cost % is normally measured.

Does it convert units?
No. Portions use the ingredient's own unit - buy in grams, portion in grams.

How many dishes?
Up to 60 dishes, 800 recipe lines, 200 ingredients and 52 weeks.

Will I receive a physical item?
No. This is an instant digital download.

Instant Download

Your files will be available to download once payment is confirmed.  Here's how.

Instant download items don’t accept returns, exchanges or cancellations. Please contact the seller about any problems with your order.

Etsy Purchase Protection
Shop confidently on Etsy knowing if something goes wrong with an order, we've got your back for all eligible purchases — see program terms

You may also like

Shoppers with similar taste loved these

Show more
Show more
Listed on Nov 15, 2026