Restaurant Food Cost Spreadsheet for Excel, Recipe Costing Calculator, Menu Engineering, Plate Cost and Food Cost Percentage
Price:$16.99
Here's what's eligible:
- Your order doesn't match the item description or photos
- Your item arrived damaged
- Your item arrived after the estimated arrival window
- Your item didn't arrive or was lost in the mail
You can only make an offer when buying a single item
Highlights
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
More from this shop
Visit shop-
Digital download
Trucking Spreadsheet for Excel, Owner Operator Bookkeeping, Cost Per Mile Calculator, Load and Fuel Tracker, Truck Expense Log
$20.99
-
Digital download
Personal Finance Planner Spreadsheet for Excel, Yearly Budget Plan vs Actual, Savings Goals, Debt Payoff and Net Worth Tracker
$12.99
-
Digital download
Business Expense Tracker Spreadsheet for Excel, Receipt Tracker, Mileage Log, Quarterly Expense Report, Small Business Template
$8.99
-
Digital download
Contractor Job Costing Spreadsheet for Excel, Construction Estimate Template, Job Profit Tracker, Budget vs Actual, Quote Template
$24.99
Be the first to leave a review
-
Digital download
Restaurant Food Cost Calculator Excel, Recipe Costing, Inventory Tracker, Menu Engineering, Profit Spreadsheet
$14.00
-
Digital download
Recipe Cost Calculator for Restaurant & Food | Main and Sub Recipes Costing, Profit Margin | Easy Spreadsheet Template Excel Google Sheets
$14.99
-
Digital download
Restaurant Food Cost Calculator Spreadsheet, Recipe Cost Card, Menu Costing | Excel Google Sheets
Sale Price $16.50
Original Price $22.00
-
Digital download
Pro Recipe Cost Calculator | Food Business Cost Control Tool | Ingredient Management | Editable Excel Template (Instant Download)
$12.29
-
Digital download
Recipe Cost Calculator: Restaurant Menu Pricing Tool (Excel Workbook)
$13.75
-
Digital download
Food Cost Excel Template: Restaurant Recipe Calculator
$14.95
-
Digital download
Food Cost Calculator Excel Template | Recipe Costing & Menu Pricing Spreadsheet | Food Expense Tracker
Sale Price $12.30
Original Price $20.50
-
Digital download
Restaurant Recipe Cost Calculator Spreadsheet | Excel Food Cost & Menu Pricing Template
$12.29
-
Digital download
Restaurant Recipe & Food Cost Calculator Excel and Google Sheets Menu Pricing, Ingredient Costing and Profit Tool for Food Business
$13.99
-
Digital download
Restaurant Accounting Template, Restaurant Profit and Loss, Food Cost Calculator, Menu Costing, Bookkeeping Spreadsheet, Google Sheets Excel
Sale Price $7.50
Original Price $15.00
-
Digital download
Food Cost Calculator Google Sheets Template | Recipe Costing & Menu Pricing Tracker | Restaurant Tool
Sale Price $12.30
Original Price $20.50
-
Digital download
Recipe Cost Profit Calculator, Baking Ingredient Spreadsheet Home Baker Cake Costing Template Bakery Food Costs Excel Baking Pricing Tool
Sale Price $7.97
Original Price $15.95
Shoppers with similar taste loved these
-
Digital download
35 Modern Food & Cafe Instagram Posts | Coffee Shop Social Media Templates For Canva | BREW (I)
Sale Price $10.15
Original Price $33.84
-
Digital download
40 Fine Dining Restaurant Instagram Templates Canva, Editorial Social Media Pack, Gourmet Restaurant Marketing
$10.94
-
Digital download
Cocktail Bar Instagram Template Bundle, Bar Social Media Canva Templates, Restaurant & Lounge Editable Content Kit, Branding
$12.99
-
Digital download
130 Food Business Instagram Post Templates, Restaurant Social Media, Food Shop Canva Templates, Cafe Posts, Bakery Instagram, Food Trucks
Sale Price $4.09
Original Price $10.22
-
Digital download
Bar Social Media Templates Canva | 30 Luxury Cocktail Instagram Posts | Hospitality Content Pack
Sale Price $12.00
Original Price $16.00
-
Digital download
Restaurant Social Media Posts | Italian Dining Canva Templates | Instagram Posts | Minimalist Food Branding Kit
Sale Price $12.00
Original Price $16.00
-
Digital download
230 Restaurant Instagram Post Templates, Canva Editable (230)
$29.22
-
Digital download
Elegant Cocktail Bar Instagram Templates: Canva Editable Design (1080x1350)
$13.76
-
Personalized Wooden Menu Board with Leather Handle, Custom Logo
$10.00
-
Custom Plywood Menu Board, Restaurant Menu Holder with Logo
$10.00
-
Personalized Leather Check Presenter, Cafe Bar Check Holder, Bill Holder, Guest Check Presenter, Guest Check Book, Restaurant Server Book
Sale Price $10.24
Original Price $12.80
-
Bill holder, Leather Bar Check Holder, Custom Leather Receipt Holder, Personalized Check Presenter, Guest Check Book, Restaurant Server Book
Sale Price $11.84
Original Price $14.80