Blog · Finance metrics and formulas · Hospitality
Calculate restaurant break-even covers and sales from your sales, food cost and payroll exports. Follow a worked monthly example, exact spreadsheet formulas and checks for food waste, capacity and added labor shifts.
Break even analysis for a restaurant divides fixed operating costs by contribution per cover to find the guests needed to cover those costs. You can also divide fixed costs by the contribution margin ratio to find required sales. Calculate both, because a revenue target must translate into a service volume the dining room and kitchen can handle.
Use one location and one month, with a stated number of trading days and a stable menu mix. The fictional US restaurant below measures operating profit before depreciation, interest, income tax and corporate allocations. Add any of those costs explicitly if the review needs a different profit measure.
The SBA's break-even guidance divides fixed costs by unit contribution and distinguishes fixed, variable and mixed costs. The restaurant's unit is a cover: one guest served. A check may pay for several covers, while delivery orders may need a separate per-order calculation.
Contribution per cover = Net sales per cover − Variable cost per cover
Break-even covers = Fixed operating costs / Contribution per cover
Break-even sales = Fixed operating costs / Contribution margin ratio
The general break-even analysis covers the formula. Here the decisions concern food usage, guest counts, opening schedules and labor capacity. For a reusable worksheet structure, see the separate restaurant break-even template.
Start with point-of-sale line items carrying business date, location, sales channel, guest count, net sales, discounts and refunds. Reconcile net sales to the ledger. Exclude sales tax and gratuities passed through to employees; avoid counting stored-value card sales and their later redemptions as two meals.
Join the monthly inventory usage report, payroll by role and shift, payment fees and operating expenses. Food usage is beginning inventory plus purchases less ending inventory, adjusted for documented transfers. It captures waste that a standard recipe cost alone may miss.
Separate fixed opening crews and management payroll from additional hours required by guest volume. Include employer payroll charges consistently. Review shared staff allocations with the restaurant manager before assuming that a past average will apply at a different service level.
In the example, the month has 5,000 covers and $200,000 of net sales. These are illustrative inputs, not an industry average.
| Monthly operating export | Amount (USD) | Treatment |
|---|---|---|
| Net sales | 200,000 | Revenue |
| Food and beverage usage | 60,000 | Variable |
| Volume-related labor and payroll charges | 30,000 | Variable |
| Payment and channel fees | 6,000 | Variable |
| Disposable supplies | 4,000 | Variable |
| Total variable costs | 100,000 | Sum of variable rows |
| Rent and occupancy | 24,000 | Fixed |
| Management and base crew payroll | 28,000 | Fixed |
| Base utilities and insurance | 10,000 | Fixed |
| Administration and licenses | 8,000 | Fixed |
| Other committed operating expenses | 10,000 | Fixed |
| Total fixed costs | 80,000 | Sum of fixed rows |
The variable categories must be mutually exclusive. If a delivery commission already includes payment processing, do not add that processing charge again.
Create this summary in spreadsheet columns A and B, with the header in row 1. Link the cost totals to the underlying rows rather than typing them again in a working file.
| Input | Value (USD where monetary) |
|---|---|
| Covers | 5,000 |
| Net sales (USD) | 200,000 |
| Variable costs (USD) | 100,000 |
| Fixed costs (USD) | 80,000 |
| Trading days | 25 |
Put calculated results in column E, using these formulas. They work from the same period and retain unrounded averages during the calculation.
E2 = B3/B2
E3 = B4/B2
E4 = E2-E3
E5 = (B3-B4)/B3
E6 = IF(E4>0,ROUNDUP(B5/E4,0),NA())
E7 = IF(E5>0,B5/E5,NA())
E8 = E6/B6
E9 = E7/B6
| Step | Calculation | Result (USD where monetary) |
|---|---|---|
| Average sales per cover (USD) | 200,000 / 5,000 | 40 |
| Variable cost per cover (USD) | 100,000 / 5,000 | 20 |
| Contribution per cover (USD) | 40 − 20 | 20 |
| Contribution margin ratio | 100,000 / 200,000 | 50.0% |
| Break-even covers | 80,000 / 20 | 4,000 |
| Break-even sales (USD) | 80,000 / 50.0% | 160,000 |
| Average covers per trading day | 4,000 / 25 | 160 |
| Average daily sales (USD) | 160,000 / 25 | 6,400 |
Round required monthly covers upward when necessary. Daily averages are planning measures: allocate them across actual weekday and weekend demand rather than assuming every service is identical.
Check the target against practical service capacity:
| Capacity measure | Input or calculation | Result |
|---|---|---|
| Seats | Planning input | 100 |
| Available seat turns per trading day | Planning input | 2.5 |
| Trading days | Monthly schedule | 25 |
| Monthly cover capacity | 100 × 2.5 × 25 | 6,250 |
| Capacity needed at break-even | 4,000 / 6,250 | 64.0% |
Confirm that kitchen throughput and staffing can support those turns before relying on the seat calculation.
At 4,000 covers, sales are 4,000 × 40 = $160,000 and variable costs are 4,000 × 20 = $80,000. Subtracting fixed costs of $80,000 leaves zero operating profit. In the actual example month, $200,000 − $100,000 − $80,000 leaves $20,000.
The two proof cells are:
=E6*E4-B5
=E7*E5-B5
Both return zero here. The first can return a small positive amount after whole-cover rounding. A mismatch beyond rounding usually means the average check, contribution ratio or cost population came from different rows.
Suppose food waste adds $1 of variable cost per cover while prices and other inputs stay unchanged:
| Input or result | Base (USD where monetary) | Added waste (USD where monetary) |
|---|---|---|
| Average sales per cover | 40 | 40 |
| Variable cost per cover | 20 | 21 |
| Fixed operating costs | 80,000 | 80,000 |
| Contribution per cover: sales less variable cost | 20 | 19 |
| Required covers: fixed costs / contribution, rounded up | 4,000 | 4,211 |
| Sales at whole-cover target: covers × 40 | 160,000 | 168,440 |
The waste case requires 4,210.53 covers before rounding. Its whole-cover target adds 4,211 − 4,000 = 211 covers and $168,440 − $160,000 = $8,440 of sales.
Track the cause of the food loss rather than assuming every extra purchase feeds paying guests. The EPA's food-service waste tools support recording the amount, type and reason for waste, which helps distinguish over-preparation from other causes.
Now restore the original contribution and test a separate staffing change:
| Input or result | Original month (USD where monetary) | Added crew (USD where monetary) |
|---|---|---|
| Covers | 5,000 | 5,500 |
| Contribution per cover | 20 | 20 |
| Base fixed costs | 80,000 | 80,000 |
| Additional monthly crew cost | 0 | 12,000 |
| Operating profit: covers × contribution − fixed costs − added crew | 20,000 | 18,000 |
The additional 500 covers add 500 × 20 = $10,000 of contribution, below the $12,000 crew cost. More covers produce less profit because staffing moves in a step.
Bring a sample of your own sales, inventory usage, payroll and operating expense files to Covirage. Covirage maps the columns, its tools compute and check contribution and break-even figures, and the external AI model explains the result with every figure traced to its rows. Create a free Covirage account; account creation takes about a minute, then you set up your business and bring your data.
See customer profitability analysis for the supporting overview of comparing revenue with the costs of serving it.
A cover represents a guest served, while a check can pay for several guests. Calculate average sales per cover using recorded guest counts. If you only have checks, build a per-check calculation and label it that way instead of mixing the two measures.
No. Management salaries and minimum opening crews may stay fixed within a service range. Extra shifts or hours may change with demand. Separate those components and include payroll taxes and benefits consistently, so the same labor expense never appears in both categories.
Operating break-even only covers the expenses included in the calculation. Loan principal, equipment purchases, inventory payment timing and tax payments can still use cash. Reconcile the operating result to a separate cash schedule before treating it as an available bank balance.