Blog · Finance metrics and formulas · Hospitality
Compare hotel labor, supplies and overhead with occupied room-nights on a consistent basis. Follow a property example, spreadsheet formulas and a cost bridge that separates activity from changes in spending.
Hospitality cost analysis compares property spending with the activity that incurred it, while keeping fixed expenses visible. For a lodging comparison, divide defined operating costs by occupied room-nights and reconcile the same departments at every property. Then investigate whether a difference comes from service workload, unit spending or the spread of fixed commitments.
Start with a departmental ledger export, payroll detail and daily room activity register for the same accounting period. Retain property, department, cost category, transaction date, amount and source reference. Keep the activity register separate so each expense row does not duplicate the room-night denominator.
The example covers guest-room operating costs: housekeeping labor, room supplies and assigned property overhead. Food and beverage, financing, income taxes and capital projects are outside the comparison. Document the actual account mapping rather than relying on similar department names.
For a broader view of income and operating performance, use hospitality financial analysis. This cost comparison does not measure revenue quality or explain whether a lower-cost property earned enough to support its assets.
Define occupied room-nights consistently. A reservation spanning several nights creates several room-night records; guests sharing a room do not create extra rooms. Decide whether complimentary rooms and staff stays count, and keep the rule stable. Available rooms and occupied rooms answer different questions.
Classify expenses by their expected behavior for the decision period. Supplies may broadly follow serviced room-nights, while leases and contractual fees may remain fixed. Labor can contain scheduled base coverage, overtime and occupancy-related shifts, so do not assume all wages move proportionately.
The worked example treats labor and supplies as occupancy-driven for a comparison, with overhead fixed over the month. That is an explicit simplifying assumption to test against staffing schedules. Fixed versus variable costs explains why a classification depends on the time horizon and the operating constraint.
Keep other departments on suitable activity bases. Banquet covers and restaurant meals should not automatically be spread across room-nights when outside customers generate much of the work. Department managers should approve the cost mapping before finance compares property totals.
A fictional US hotel operator compares two properties for September 2026. Both use the same included accounts and service scope. Expenses are USD, and unit costs are rounded to two decimals after division.
| Property | Occupied room-nights | Labor (USD) | Supplies (USD) | Overhead (USD) | Total (USD) | Labor and supplies/room-night (USD) | Overhead/room-night (USD) | Total/room-night (USD) |
|---|---|---|---|---|---|---|---|---|
| River | 1,800 | 36,000 | 9,000 | 27,000 | 72,000 | 25.00 | 15.00 | 40.00 |
| Airport | 2,400 | 50,400 | 14,400 | 30,000 | 94,800 | 27.00 | 12.50 | 39.50 |
| Combined | 4,200 | 86,400 | 23,400 | 57,000 | 166,800 | 26.14 | 13.57 | 39.71 |
River's total is 36,000 + 9,000 + 27,000 = $72,000, or $40.00 per occupied room-night. Airport's total is 50,400 + 14,400 + 30,000 = $94,800, or $39.50. The combined figure is $166,800 / 4,200 = $39.71, calculated from totals rather than an unweighted property average.
With the headers in row 1 and the columns in the order shown, enter total cost in F2:
=SUM(C2:E2)
Enter labor and supplies per room-night in G2:
=IF(B2=0,"Check activity",SUM(C2:D2)/B2)
Enter overhead per room-night in H2:
=IF(B2=0,"Check activity",E2/B2)
Enter total cost per room-night in I2:
=IF(B2=0,"Check activity",F2/B2)
Fill down for the other property. The total unit rate is =SUM(F2:F3)/SUM(B2:B3). Keep unrounded values for calculations even when the report displays cents.
In an Excel table named Costs with Amount, Property, Department and Period columns, summarize a department as follows:
=SUMIFS(Costs[Amount],Costs[Property],A2,Costs[Department],"Housekeeping",Costs[Period],DATE(2026,9,1))
Microsoft documents SUMIFS as summing amounts that meet multiple criteria. Apply the same period filter to every department and allocation schedule.
In RoomNights, keep one row per property-room-date with Property, Period and Included fields. Count the occupied room-nights covered by the policy:
=COUNTIFS(RoomNights[Property],A2,RoomNights[Period],DATE(2026,9,1),RoomNights[Included],"Yes")
Microsoft's COUNTIFS documentation describes counting rows that meet all the criteria. Remove duplicate property-room-date records before using the formula. Covirage is not affiliated with Microsoft.
Airport has the lower total cost per occupied room-night, although its labor and supplies rate is higher. Its larger denominator spreads overhead more thinly. That observation points to different questions for the operations manager and the property controller.
Use River as a reference, without treating its cost structure as an approved Airport budget:
| Step | Calculation | Cost (USD) |
|---|---|---|
| River actual | Given above | 72,000 |
| Additional room-night activity at River rate | (2,400 - 1,800) × 25.00 | 15,000 |
| Labor and supplies rate difference | 2,400 × (27.00 - 25.00) | 4,800 |
| Overhead difference | 30,000 - 27,000 | 3,000 |
| Airport actual | 72,000 + 15,000 + 4,800 + 3,000 | 94,800 |
This bridge reconciles the entire cost difference. Investigate staffing mix, service standards, supplier prices and property condition before interpreting the $4,800 as avoidable spending. Variance analysis helps turn those questions into separate explanations supported by payroll and purchasing rows.
Reconcile the $166,800 included expense to the ledger, with exclusions documented. Check the 4,200 room-nights against daily property reports, then check that allocated overhead equals the pool assigned. Finance owns the reconciliation; department managers own the operational explanation.
Bring a sample of your own departmental costs and occupied room-night files; Covirage maps the columns, and its tools compute and check the property totals and unit rates. The external AI model explains the result with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data.
See Covirage for hospitality for the property reporting context.
An occupied room-night represents one room occupied for one night under the report's documented policy. Decide how complimentary rooms, day use and staff rooms are treated. Count room-nights consistently across properties rather than substituting reservations, guests or rooms available.
You can show overhead per occupied room-night to understand the burden carried by current activity. Keep the underlying overhead dollars visible because rent and other commitments may remain unchanged when occupancy moves. A lower unit figure does not necessarily indicate an expense reduction.
Use occupied room-nights only when that denominator fits the decision. Restaurants and banquets may serve outside guests, so covers, meals or events can be better activity measures. Show those departments separately before allocating any agreed share to a property-wide room-night comparison.