Restaurant Food Cost Calculator, Recipe Costing Spreadsheet, Menu Engineering, Plate Cost, Restaurant Inventory, Excel Google Sheets

Restaurant Food Cost Calculator for Microsoft Excel and Google Sheets, instant digital download. Know exactly what every plate costs, what to charge for it and where your food cost is going each week. Perfect for restaurant owners, chefs and kitchen managers. ✨ NOW INCLUDES 4 FILES: Excel + Google Sheets, each in a SAMPLE version (filled in so you can see exactly how it works) and a BLANK version (cleared and ready for your own info). ★ WHAT'S INCLUDED ★ • 11 tabs with a clickable Start Here page and a How To Use guide with FAQ • Dashboard: 8 KPI tiles (food sales, COGS, actual and menu food cost %, waste and more), a month by month table and 3 charts • Ingredient Price List (150 rows): case price, pack size, pack unit and yield %, converted to cost per oz, lb, gram, fl oz, ml or each, plus stock vs. par • Recipe Lines (600 rows): ingredients and amounts for each dish, with unit checks • Recipe Card: pick any dish to see every ingredient, plate cost, food cost %, profit per plate, a suggested price and a price ladder • Menu Items (60 dishes): food cost %, suggested price from your target %, profit per plate • Menu Engineering: stars, plowhorses, puzzles and dogs with a menu matrix and what to do with each dish • Weekly Inventory & COGS (52 weeks): opening, purchases, closing, food cost % vs. target • Waste Log (500 rows): cost of waste by reason ★ PERFECT FOR ★ ✓ Restaurant owners, chefs and kitchen managers ✓ Cafes, food trucks, caterers and bars ★ COMPATIBILITY ★ • Microsoft Excel (desktop, Mac, web) • Google Sheets (upload to Google Drive and open with Google Sheets) • 2 files included: an Excel version + a Google Sheets edition • Not designed for Apple Numbers ★ HOW IT WORKS ★ 1. Download the file right after purchase. 2. Set your target food cost % and add your ingredients with what you pay. 3. Add your dishes and their recipe lines to see plate cost and a suggested price. 4. Each week log purchases, closing inventory, sales and waste. Works in any currency ($, £, €, C$, A$ and more): just change the currency symbol. ★ PLEASE NOTE ★ • This is a digital download. Nothing will be shipped. • Sample data is included so you can see how it works. Delete it when you're ready. • Suggested prices are a starting point, not financial advice. • Because it's a digital file, returns aren't accepted, but if you have any trouble with the file, message me and I'll fix it or help you right away.