Short answer: explain the difference in two steps
When room revenue falls below budget, value the change in sold room nights at the budget average rate, then value the rate change at actual room nights. This sequence explains the entire difference without counting an effect twice. The rate step can also reflect room and channel mix; it does not prove that pricing was wrong. For an independent hotel manager, the useful outcome is choosing the next investigation.
This example is entirely fictional. It compares the same closed month, property and currency, using room revenue only. Breakfast, other extras and costs are excluded; both sides are assumed to use the same tax basis. Budget is a target and actuals are the closed period’s results. Future reservations currently on the books do not belong in the actual column.
Prepare four comparable inputs
Collect budget sold room nights and room revenue, followed by actual sold room nights and room revenue. Recalculate each average rate by dividing period room revenue by sold room nights. Use period totals rather than an unweighted average of daily rates, so differing daily volumes retain their weight. If sold room nights are zero, the average rate is undefined: do not force this bridge onto that segment.
Keep the sources distinct: the Oracle OPERA Cloud 25.4 Forecast Reports index lists room nights, room revenue and average rate in its Three Month Forecast description. The separate 25.1 History and Forecast page distinguishes historical statistical data from forecast data. These documents from different versions were reopened on 19 October 2026; they are not presented as release news. The bridge here is an original calculation proposal, not a documented software feature. Similar report names do not make differently scoped outputs comparable.
Fictional example: build the revenue bridge
Budget: 400 sold room nights × TRY 2,000 average rate = TRY 800,000 room revenue. Actual: 360 room nights × TRY 2,100 = TRY 756,000. Total variance is 756,000 − 800,000 = −44,000, or −5.5% against budget. Average rate rose while revenue fell; rate alone cannot explain the result.
Volume effect: (360 − 400) × 2,000 = −TRY 80,000. The intermediate total is 800,000 − 80,000 = TRY 720,000. Rate/mix effect: (2,100 − 2,000) × 360 = +TRY 36,000. Add this to reach TRY 756,000. Check: −80,000 + 36,000 = −44,000, exactly matching the total variance.
Changing the order changes the allocation
The identity is: (actual quantity − budget quantity) × budget rate + (actual rate − budget rate) × actual quantity = actual revenue − budget revenue. Starting with rate at budget volume gives +TRY 40,000; volume must then use actual rate, giving −TRY 84,000. The sum remains −TRY 44,000. Never combine components from different sequences.
This article keeps volume first. The −TRY 4,000 interaction between rate and volume changes is therefore included in the rate/mix step. The two components are not independent causal losses or gains. Record the sequence in your meeting note so next month’s comparison remains meaningful.
Choose the next decision
Here, investigate where the missing 40 room nights occurred. Keep scope consistent while breaking results down by weekday/weekend, room type or channel. Do not announce closures or cancellations as causes without supporting records. Nor should you assume that other dimensions stayed constant: room and channel mix may change together.
The positive TRY 36,000 rate/mix contribution does not mean every room became more expensive; higher-priced room types may have gained share. Do not automatically discount. Compare equivalent segments first, then consider rate, volume and costs separately. A room-revenue bridge is not profit analysis and cannot predict sales at a future rate.
A checklist for the review meeting
Write down stay dates, currency, tax basis and the room-revenue boundary. Retain the four inputs with their source and recalculate both average rates. Value volume at budget rate and rate/mix at actual volume; reconcile their sum to the revenue difference.
Turn the remaining question into an assignment: on which days and room types did the 40 missing room nights occur? Name an owner and review date. If the bridge fails to reconcile, correct scope, rounding or transfer errors first. The related weekday/weekend and booking-window guides can deepen the investigation; breakdowns alone do not prove causation.