Restaurant break-even: covers per day and months to break even

A restaurant has two break-even questions. The first is how much it must sell in a month to cover its fixed costs, which gives a break-even revenue and a number of covers (guests) per open day. The second is how many months of operating earnings it takes to cover the money spent before opening. This article works through both with an invented cafe, so every figure can be rechecked with a calculator.

All names, prices and quantities below are made up for the example. They are not benchmarks and they are not a forecast.

Step 1: monthly fixed costs

Fixed costs are the costs that do not move with sales in a month. The cafe's are:

Fixed costPer month
Labour, fixed part$9,000
Rent and occupancy$5,500
Utilities$1,100
Marketing$800
Other operating costs$1,600
Total$18,000

Loan payments are not in this list. Break-even here is before loan payments and tax, so a business that must meet a loan payment from cash needs more than the figures below.

Step 2: the contribution margin share

Some costs do move with sales. Two are used here: the weighted food cost % from menu costing and a variable share of labour. Suppose the cafe's menu costing gives a weighted food cost of 30% and variable labour is 10% of revenue.

Contribution margin share = 1 - food cost % - variable labour share = 1 - 0.30 - 0.10 = 0.60

Each dollar of sales leaves 60 cents to pay the fixed costs. With an average check of $25 per cover, each cover leaves 25 x 0.60 = $15.

Step 3: break-even revenue

Break-even revenue per month = monthly fixed costs / contribution margin share = 18,000 / 0.60 = $30,000.

At $30,000 of sales in a month, the margin of 0.60 x 30,000 = $18,000 pays the fixed costs exactly. Above it, each extra dollar of sales leaves 60 cents. Below it, the fixed costs are not covered.

Step 4: break-even covers per month and per open day

Break-even covers per month = break-even revenue / average check = 30,000 / 25 = 1,200 covers. The same figure comes from fixed costs divided by the margin per cover: 18,000 / 15 = 1,200.

To turn a month into open days, count the days the cafe opens. It opens 6 days a week for 50 weeks a year: 6 x 50 / 12 = 25 open days a month.

Break-even covers per open day = 1,200 / 25 = 48.

A cover is one guest, not one plate. If guests order 2.5 items on average, 48 covers are 120 plates.

Step 5: compare with the covers you plan

The figure only means something next to a plan. Suppose the cafe plans 50 covers on each of its 4 Monday to Thursday days, 70 on Friday and 80 on Saturday. That is 4 x 50 + 70 + 80 = 350 covers a week.

Planned covers per month = 350 x 50 / 12 = 1,458.33, or 1,458.33 / 25 = 58.33 covers per open day. That is above the 48 needed to break even.

The plan also needs a room that can seat them. A busiest day of 80 covers fits a 40-seat room only if each seat turns twice: 40 x 2 = 80.

Step 6: months to cumulative break-even

Break-even revenue says when a single month covers its own costs. It does not say when the opening spend is covered. For that, add up the monthly operating earnings (EBITDA, earnings before interest, tax, depreciation and amortisation) from opening day and find the first month in which the running total reaches the total startup costs.

Suppose the cafe's startup costs are $100,000 of itemised spending plus a 20% contingency, a total of $120,000.

At the planned covers, monthly revenue is 1,458.33 x 25 = $36,458.33. Its margin is 0.60 x 36,458.33 = $21,875, and after the $18,000 of fixed costs the month leaves $3,875.

Running total after 30 months: 30 x 3,875 = $116,250, which is short of $120,000. After 31 months: 31 x 3,875 = $120,125, which covers it. The cafe reaches cumulative break-even in month 31.

That simple answer holds only because the example keeps every month the same: full planned covers from month 1, no growth, no cost inflation and no seasonality. A ramp-up, growth or seasonal months change the monthly figures, so the month changes with them. A running total that never reaches the startup costs within 60 months is a real result too.

Step 7: what if the food cost or the check moves

Because break-even depends on the margin share and the average check, a small change in either moves it.

Both are worse than the base case of 48. A grid of such cases, with the average check down one side and the food cost % across the top, shows at a glance which input the break-even is most sensitive to.

Doing it in a spreadsheet

Every step above is a short formula, so a spreadsheet can hold them all and recalculate when an input changes. The part that takes care is keeping the inputs in one place and the figures linked, so that a new menu price or rent flows through to break-even without retyping.

The Break-even sheet of the Restaurant 5-Year Plan & Menu Costing Workbook follows the same steps. It reads the five fixed cost lines from the Assumptions sheet and the weighted food cost % from the Menu costing sheet. It then shows break-even revenue, break-even covers per month, covers per open day and months to cumulative break-even, and a status line that compares planned covers per open day with the break-even figure. A 5 by 5 sensitivity table over average check and food cost % has two step sizes you can change.

Months to cumulative break-even there is read from the 5-year projection, which applies the ramp-up, growth, inflation and seasonality you enter. A result of 0 means the startup costs are not covered within the 60 months, or there are no startup costs to cover. Its break-even figures are before loan payments and tax.

The workbook

The Restaurant 5-Year Plan & Menu Costing Workbook includes a blank template and a worked example for an invented restaurant, and it is described on the product page. The files have not been tested in Excel and have not been tested in Google Sheets. It is a planning tool, not financial, tax, legal or lending advice, and it makes no promise about profit, returns or loan approval.

This article was written with AI assistance by Northgate Enterprises, and its example figures were checked against the workbook's own formulas by an automated test.