A 62-room boutique hotel tracked RevPAR religiously, celebrating when they hit $180 during peak season. But annual profitability kept declining despite strong occupancy rates.

Benefits of Detailed Analysis

The revenue manager, an introvert who preferred spreadsheets to people, built a day-by-day profitability model spanning three years. She discovered that peak pricing drove away shoulder season regulars who previously booked 8-12 nights annually. These steady guests generated more lifetime value than peak tourists. Her isolated number-crunching revealed that optimizing for RevPAR actually minimized profit. The quiet, focused work identified customer behavior patterns invisible in standard metrics.

Limitations Encountered

The analysis missed qualitative factors. Interviews with former guests might have revealed the pricing issue eighteen months earlier. The manager's comfort with data and discomfort with conversation meant she solved the puzzle slowly. Also, presenting complex findings to ownership was rough. Charts and tables didn't convey urgency as well as a compelling narrative would have.