Restaurant break even analysis template: plan against actuals

A restaurant break even analysis template shows the sales and daily covers needed to cover a restaurant's operating costs. Build it from trading days, average check, variable cost assumptions and fixed commitments, then put actual results beside the plan. Copy the worksheet below and replace the example inputs with one location's records for the same month.

Set the boundary before filling the sheet

This worksheet measures monthly operating break-even, including depreciation and excluding financing costs and income taxes. Decide that boundary before importing accounts. The general break-even method explains the underlying relationship; this page concentrates on a restaurant worksheet that can be filled and reviewed.

Use net food and beverage revenue after discounts and refunds. Remove buyer-imposed sales tax that the restaurant collects for the government: the IRS explains that these collections are not income. Keep employee tips outside this revenue measure and reconcile them separately to customer payments and payroll records.

Define a cover as one diner consistently across the sales and guest-count exports. Where takeout orders do not have reliable guest counts, use a separate order-based section or exclude that channel from both the covers and sales inputs. Combining takeout revenue with dining-room covers inflates the average check.

The copyable worksheet layout

Column A holds the row label, B the plan and C the actual. Enter costs as positive numbers. Rates are percentages of net restaurant revenue, and all monetary amounts below are USD.

Keep full precision in calculations. Display sales thresholds to two decimals and round required daily covers upward to a whole diner. If contribution is zero or negative, the division does not produce an attainable sales threshold; flag the assumptions for review.

The SBA's break-even guidance separates fixed, variable and mixed costs. Follow that distinction when deciding whether a restaurant cost belongs in a rate or a fixed row. A ledger heading alone does not determine its behavior.

Fill the inputs from actual records

Start with the point-of-sale export: business date, location, net sales, cover count and sales channel. Tie total net sales to the ledger. Calculate actual average check as total relevant sales divided by total relevant covers, rather than averaging service-level averages.

Next, bring opening inventory, purchases, transfers and closing inventory from the food and beverage records. Purchases alone are not food usage: stock bought for a later service remains inventory. Divide usage for this location and period by its matching sales to fill the actual food rate.

Use payroll detail to separate base staffing from flexible labor. Include the employer labor burden within the chosen categories consistently. A manager's fixed salary must not also sit in the flexible labor percentage. Inspect utilities, cleaning, card charges and delivery commissions separately before assigning them to other costs.

The controller owns these definitions; the general manager confirms whether the planned staffing and covers are workable. For the broader operating process, see restaurant break-even analysis.

Read the actual-versus-plan difference

The average check improved, but lower covers reduced sales to $91,000. Food usage and flexible labor also took a larger share of revenue. The restaurant now retains 41% of sales before fixed costs, against the planned 45%.

The operating profit deterioration reconciles as follows. Use the planned contribution ratio for the sales effect, then the actual revenue for the rate effect.

The actual-cost threshold is a scenario, not evidence that every expense will scale that way indefinitely. Check whether the observed labor ratio includes unusual training, overtime or a minimum shift commitment before using it to set next month's target.

Prove the threshold and test capacity

At the planned threshold, the worksheet must give zero operating profit:

Rounding daily covers upward creates a small cushion. At 161 covers for 26 days and a $24 check, sales are $100,464; contribution is $45,208.80 and operating profit is $208.80. Confirm that the dining room, kitchen and roster can deliver that volume without another cost step.

Cash may still fall at operating break-even because debt principal, equipment purchases and payment dates have different effects. Use the cash-flow break-even template when that is the question.

Where it goes wrong

• Treating all wages as variable. Minimum shifts continue even during quiet services. Separate that commitment before projecting a lower-volume month.
• Mixing purchasing with consumption. A stock build raises purchases without raising the food cost of meals already sold.
• Using one check across changing channels. Delivery commissions and beverage mix can change contribution even when total sales hold steady.
• Exceeding the staffing range. More covers can require another cook or server, moving fixed costs before the target is reached.
• Comparing different calendars. Match trading days, inventory cutoffs and payroll accruals before interpreting a variance.

Compare your restaurant file in Covirage

Bring the worksheet and matching sales, inventory and payroll exports to Covirage. Covirage maps the uploaded columns, and its tools compute and check the supplied figures; the external AI model explains the results with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data.

See Covirage for hospitality teams for the supporting industry context.