Restaurant Excel Template: Recipe Costing, Food Cost, Inventory
Run the numbers of your restaurant from one Excel workbook: every dish costed from its recipe, every ingredient with its par level, purchases, waste, staff hours and private events, with food cost, labor cost and prime cost as a share of sales worked out for you.
Most restaurants price dishes by feel and find out at the end of the month that food cost ran away. Supplier prices rise quietly, portions drift, waste is never counted and nobody knows which dishes really make money. PlateCost is built for restaurant owners, not for generic small business.
INSIDE (1 workbook, 21 sheets)
- Menu Items: menu price, plate cost, food cost %, profit per plate, price at your target food cost, plates sold, total profit and menu class
- Recipes, Ingredients, Sales, Purchases, Waste Log, Staff Hours and Private Events sheets, plus a dashboard and a charts sheet
14 SERVICES A RESTAURANT OWNER ACTUALLY NEEDS
- Recipe costing from quantities and trimming yields: plate cost and food cost % of every dish
- Menu price that keeps each dish at your target food cost
- Menu engineering: every dish classed Star, Plowhorse, Puzzle or Dog
- Food cost from recipes against what you really bought
- Labor cost % and prime cost % of sales
- Waste log costed by reason
- Par levels and what to order after each stock count
- Printable purchase order and a ready WhatsApp message to the supplier
- Supplier price rise alerts against the prices your recipes were costed at
- Private events and catering: guests, price per guest, deposit, balance and days to the event
- Printable event quote and event agreement
- New dish launch and private event checklists with due dates
- Dish price calculator and break-even guests calculator
- Dashboard: sales, food cost, purchases, labor and prime cost %, waste, dishes over target, reorders, event balances
ROOM FOR REAL WORK: 400 ingredients, 200 dishes, 1,500 recipe lines, 3,000 sales and 3,000 purchase lines, 2,000 waste and staff-hour entries, 500 events.
YOU RECEIVE a ZIP with the workbook in 15 languages (English, Arabic, French, Spanish, German, Italian, Portuguese, Turkish, Dutch, Russian, Persian, Urdu, Hindi, Chinese, Indonesian), plus an English copy filled with sample data to see every feature working. Right-to-left languages are supported. Standard .xlsx files for Microsoft Excel and LibreOffice. No macros, no subscription. Personal licence: one business.