Restaurant operations are uniquely suited to Excel. The inputs are repetitive (every day, the same ingredients, the same menu, the same labour), the metrics are well defined (food cost, labour cost, prime cost), and the decisions are time-sensitive (a restaurant cannot wait a month for a financial close). The five templates below are the ones the senior ships on every restaurant engagement.
The five templates
Recipe costing with ingredient, quantity, cost, plate cost, and menu price. Daily sales summary with covers, average ticket, sales by category. Inventory tracker with opening, purchases, consumption, closing. Food cost percentage with actual vs target. Labour cost percentage with hours, rate, and cost. The five together cover 90% of restaurant operations. The senior combines them in a single workbook with named ranges, conditional formatting, and a Checks tab.
The four KPIs
The senior-built restaurant dashboard has four KPIs. Revenue (the daily sales total). Covers (the number of customers served). Average ticket (revenue divided by covers). Prime cost (food cost plus labour cost as a percentage of revenue). The four together answer: are we selling enough, at the right price, with the right cost? The senior reports the four KPIs every day, the food cost and labour cost weekly, and the full P&L monthly.
The food cost formula
Food cost % = (Opening Inventory + Purchases - Closing Inventory) / Food Sales. The senior builds a monthly food cost sheet with the four inputs and the formula. The target is 28-32% for most restaurants. Above 35% is a problem that needs investigation - typically waste, theft, or pricing. The senior ships the food cost sheet with conditional formatting that turns red when the percentage crosses 32%.
When to move to a POS system
Excel restaurant operations top out at 3-5 locations. For larger chains, the senior moves to a POS system with built-in reporting (Toast, Square, Lightspeed). The transition is a one-time data migration: the recipes go into the POS, the inventory goes into the POS, the daily sales come from the POS. The Excel workbook becomes the consolidation layer for the multi-location P&L. The senior uses Excel for the single location and the consolidation, POS for the operational layer.
