Why revenue missed budget: price, volume and their interaction

Most hotel managers panic when they see revenue variances but don’t understand what’s driving them. Smart managers use three-component analysis to find the real story.

Example: Hotel with 200 Cr Room Revenue Target

BUDGET: 200 rooms × 365 days = 73,000 room nights
Average rate: ₹27,397 per room
Total revenue: ₹200 Cr

ACTUAL: Sold 78,000 room nights (5,000 more than budget)
Average rate: ₹24,615 per room (₹2,782 less than budget)
Total revenue: ₹192 Cr

VARIANCE: ₹192 Cr - ₹200 Cr = -₹8 Cr

Three-Component Breakdown:

1. PRICE VARIANCE:
73,000 rooms × (₹24,615 - ₹27,397) = -₹20.31 Cr
Translation: Rate cuts cost us ₹20.31 Cr on budgeted occupancy
1. VOLUME VARIANCE:
(78,000 - 73,000) × ₹27,397 = +₹13.70 Cr
Translation: Extra 5,000 rooms generated ₹13.70 Cr at budget rates
1. PRICE-VOLUME INTERACTION:
(-₹2,782) × (5,000) = -₹1.39 Cr
Translation: Lower rates on extra volume cost additional ₹1.39 Cr

CHECK: -₹20.31 + ₹13.70 - ₹1.39 = -₹8 Cr ✓

Management Analysis:

WRONG CONCLUSION: “Revenue team failed - missed budget by 4%”

RIGHT CONCLUSION:

- Occupancy strategy worked: 6.8% increase in room nights
- Pricing strategy failed: 10.2% ADR decline destroyed value
- Net result: Volume gains could not offset rate erosion

Strategic Questions for Management:

- Why did we cut rates so aggressively?
- Can we achieve 95% of current occupancy at higher rates?
- What is driving competitive pricing pressure?
- Should we focus on rate optimization over volume?

Action Plan:

- Conduct competitive rate analysis
- Test price elasticity with 5% rate increases
- Review channel mix and direct booking strategies
- Analyze guest satisfaction scores for pricing insights

Why This Analysis Matters:

Basic variance analysis tells you WHAT happened
Three-component analysis tells you WHY it happened and HOW to fix it

Your revenue story has three chapters - price, volume, and their interaction. Most managers only read the summary.

Excelsior Asset Management helps hotels understand the complete revenue story through sophisticated analysis.