Hotel Break-Even Analysis: Room Nights and Occupancy

Hotel break even analysis divides monthly fixed costs by contribution per occupied room night, then expresses the required room nights as occupancy. A hotel with fixed costs of $192,000 and contribution of $128 per occupied room night needs 1,500 room nights to cover those costs. With 3,000 room nights available, break-even occupancy is 50.0%.

Define what the hotel must cover

Choose the month and the profit measure before extracting data. This example measures property operating profit before depreciation, interest, income tax and corporate allocations. Include those charges in fixed costs if the question is whether the hotel covers them too; label that result separately.

The general break-even analysis explains fixed costs divided by unit contribution. A hotel adds a capacity denominator and guest spending beyond the room. The SBA's break-even guidance uses selling price less variable cost as the contribution available to cover fixed costs.

Break-even occupied room nights = Monthly fixed costs / Contribution per occupied room night

Contribution per occupied room night = Room rate − Variable room cost + Ancillary revenue − Ancillary variable cost

Break-even occupancy = Required occupied room nights / Available room nights

Occupancy counts room nights, not guests. Two guests sharing a room do not create two occupied rooms. A hotel operator's annual report defines occupancy as room nights sold divided by room nights available, and average daily rate as room revenue divided by room nights sold.

Start with the hotel's exports

Use the property-management room-night export, room revenue report, departmental revenue and expense detail, payroll, and monthly general ledger. Retain stay date, room category, booking channel, occupied room nights, net room revenue and service costs. Reconcile room revenue to the ledger before calculating its average rate.

Exclude lodging taxes collected for government from revenue and remove canceled stays. Allocate package revenue consistently between the room and included services. Otherwise breakfast can appear once in room revenue and again in ancillary revenue.

The controller owns cost classification; the revenue manager owns achieved rates and booking mix; operations confirms staffing and room availability. Compare their assumptions before calling the resulting occupancy a target.

For a fictional US hotel, monthly fixed operating costs are:

Variable housekeeping labor belongs in the per-room cost; base payroll above must exclude it. Classify mixed utility bills into a committed portion and an occupancy-related portion rather than counting the entire bill in both places.

Build the room-night calculation

Enter this input table in columns A and B, with its header in row 1. The ancillary figures are averages across all occupied room nights, including guests who buy nothing extra. They are assumptions for this worked example, not hotel industry benchmarks.

Use these formulas in a spreadsheet. Keep the inputs unrounded while calculating; display percentages to one decimal place and round required room nights upward to whole nights.

E2 = B4-B5+B6-B7
E3 = B2*B3
E4 = IF(E2>0,ROUNDUP(B8/E2,0),NA())
E5 = E4/E3
E6 = E4*(B4+B6)

A nonpositive contribution cannot cover positive fixed costs at any occupancy. Return an error for that case rather than presenting a negative room-night target.

Prove the result against costs

At the calculated room nights, revenue less variable and fixed costs must equal zero:

The check in another cell is =E4*E2-B8. A small positive amount is acceptable when whole-night rounding is necessary; a negative result means the target is too low.

An operating month above break-even produces this reconciliation using the same rates and costs:

The independent contribution check is 1,800 × 128 − 192,000 = $38,400.

Recalculate rate, season and service mix

Change the rate and month length separately. Every other assumption stays at its original value:

The reduced-rate calculation gives 1,627.12 nights before rounding. The discount requires 1,628 − 1,500 = 128 additional occupied nights. The shorter month changes capacity rather than contribution; calculate each month separately instead of applying an annual average occupancy to every season.

Keep independent event contribution separate from guest-linked spending. If the restaurant needs its own covers and labor schedule, use restaurant break-even analysis. A comparison of alternative properties needs locational break-even analysis, which compares site cost lines.

Where it goes wrong

• Using gross ancillary sales. Food, parking and other services bring costs as well as revenue. Add their contribution, not their sales alone.
• Ignoring channel mix. Commissions and payment charges can change contribution even when the achieved room rate is unchanged.
• Assuming unlimited labor capacity. An added housekeeping shift creates a cost step. Recalculate within the staffing range that can actually serve the target.
• Changing availability definitions. Keep the room-inventory convention consistent across periods and show operational room outages separately when they constrain sellable nights.
• Calling operating break-even cash sufficiency. Debt principal, capital spending and payment timing need a separate cash-flow break-even calculation.

Calculate the target from your hotel files

Bring a sample of your own room-night export and hotel revenue and cost files to Covirage. Covirage maps the columns, its tools compute and check contribution and occupancy figures, and the external AI model explains the results 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 Covirage for hospitality teams for the supporting industry overview.