Revenue Management Model
Total Revenue Management Model
Surrey Hotel: Q2 Pilot Programme (Rooms, F&B, Events & Spa)
An integrated revenue and profit model for a hypothetical 250-room hotel covering Rooms, F&B, Events and Spa. Compared Q1 actual performance with a Q2 forecast.
Academic project, University of Surrey; Surrey Hotel is a hypothetical case study.
The Brief
The Brief
Surrey Hotel is a 250-room, four-star city hotel in Guildford. Its revenue comes from four distinct departments: Rooms (accommodation), F&B (restaurant, bar and room service), Events & Banqueting (conference space, weddings, corporate events) and Spa & Wellness (day spa and fitness). Yet the hotel’s revenue management has focused almost entirely on room pricing: monitoring competitor rates, forecasting occupancy and optimising RevPAR.
That reflects the industry’s history. Revenue management began in the 1980s with the idea of selling fixed capacity to the right customer at the right price, and for a long time it stopped at the bedroom door. More recent work argues that hotels must move beyond a rooms-only RevPAR view towards total revenue and profit contribution. The General Manager sees exactly this: the real untapped potential lies in an integrated "Total Revenue Management" (TRevM) approach that manages every revenue stream together.
The task was to design a pilot TRevM model for Q2. I produced this study as an individual academic assignment for the Revenue Management module at the University of Surrey, using TRevPAR and GOPPAR to identify revenue potential, integrate departmental data and support management decisions.
The case data provided was: Q1 actual KPIs (78% occupancy, £96 RevPAR, £122 TRevPAR, £64 GOPPAR), department-level revenue and cost assumptions (Rooms £120 revenue / 30% variable cost, F&B £35 / 50%, Events £20 / 40%, Spa £15 / 45%), and capacity assumptions (250 rooms, 60% of guests dining in F&B, 30% using the spa). The General Manager also believes TRevPAR could reach £150 without growing room inventory, if each department optimises its own yield and cross-selling improves; the Q2 model is assessed against that target. From that starting point, every calculation, table, chart, optimisation recommendation, package idea, the dashboard design and the implementation plan are my own work.
The Measurement Framework
Three KPIs, Three Different Questions
The whole model rests on three metrics, and the distinction between them is the central argument of the study. All three are calculated "per available room", meaning they divide by all 250 rooms the hotel owns rather than only the rooms it sold. That shows what every room earns the business whether occupied or not, and makes periods comparable.
The difference is this: RevPAR asks what the bedrooms alone earn, TRevPAR asks what the whole hotel earns, and GOPPAR asks what is actually left as profit. A hotel can raise TRevPAR while lowering GOPPAR, which means selling more and earning less. That is why the pilot is judged on GOPPAR rather than TRevPAR.
| Metric | How It Is Calculated | The Question It Answers |
|---|---|---|
| RevPAR | Rooms revenue ÷ available rooms | How much revenue do the bedrooms alone generate? |
| TRevPAR | Total hotel revenue (all departments) ÷ available rooms | How much revenue does the whole hotel generate per room? |
| GOPPAR | Gross operating profit ÷ available rooms | What is left of that revenue after variable costs? |
Baseline Assessment
Q1 to Q2: What the Occupancy Gain Means for Profit
The first step was to compare Q1 actual performance with the Q2 forecast on the same basis. In the Q2 scenario occupancy rises from 78% to 85%, which in a 250-room hotel means an average of 212.5 occupied rooms. Each occupied room generates £190 across the four departments (£120 rooms + £35 F&B + £20 events + £15 spa), producing £40,375 of total revenue. Divided across the 250 available rooms, that gives a TRevPAR of £161.5.
TRevPAR therefore clears the General Manager’s £150 target. But the real question was whether that extra revenue converts into profit, and it does: GOPPAR also rises, from £64 to £103.5. The pilot creates profit growth, not just extra turnover. Had GOPPAR stayed flat or fallen, the TRevPAR gain would have been misleading.
The most striking figure, though, is RevPAR, which moves only from £96 to £102. Looking at bedrooms alone, the hotel would record a 6.3% improvement; on the total picture, TRevPAR rises 32.4% and GOPPAR 61.7%. There is no clearer illustration of how a rooms-only view hides the value created by the ancillary departments.
| KPI | Q1 Actual | Q2 Forecast | Change | % Change |
|---|---|---|---|---|
| Occupancy | 78% | 85% | +7 pts | 9.0% |
| RevPAR | £96.0 | £102.0 | +£6.0 | 6.3% |
| TRevPAR | £122.0 | £161.5 | +£39.5 | 32.4% |
| GOPPAR | £64.0 | £103.5 | +£39.5 | 61.7% |
Department Performance
Rooms Is the Main Profit Engine, But Not the Whole Story
Breaking the forecast down by department shows why Rooms still sits at the centre: it produces £25,500 of revenue (63% of turnover) and £17,850 of profit (69% of total departmental profit). That dominance isn’t only about volume, it’s about cost structure. Rooms carry the lowest variable cost ratio at 30%, so every occupied room leaves £84 of gross operating profit. F&B is the most expensive department at a 50% variable cost ratio, where half of its £7,437 revenue goes straight back out in costs.
The table cuts both ways. Room profitability must be protected, because it is the load-bearing column of the model. But F&B, Events and Spa together add £59.5 to TRevPAR, a layer of revenue a rooms-only strategy never sees and one that requires no additional room inventory.
The chart below shows how that layering works: on top of the £102 RevPAR base, F&B adds £29.75, events £17 and spa £12.75, building to a total TRevPAR of £161.5. Industry research (CoStar/STR, 2024) makes the same point, arguing that hotels need a total performance picture spanning both top-line revenue and bottom-line cost. For Surrey Hotel, the right strategy is to protect room profitability while turning F&B, events and spa into a controlled ancillary-spend engine.
| Department | Total Revenue | Variable Cost | Gross Operating Profit | Profit Contribution |
|---|---|---|---|---|
| Rooms | £25,500.0 | £7,650.0 | £17,850.0 | 69.0% |
| F&B | £7,437.5 | £3,718.8 | £3,718.8 | 14.4% |
| Events | £4,250.0 | £1,700.0 | £2,550.0 | 9.9% |
| Spa | £3,187.5 | £1,434.4 | £1,753.1 | 6.8% |
| Total | £40,375.0 | £14,503.1 | £25,871.9 | 100% |
Optimisation Strategy
Department-Level Pricing Initiatives
The numbers show the potential; the next question is how to realise it. For each department I identified two initiatives suited to that department’s own cost structure.
In Rooms, the proposals are demand-led (dynamic) pricing and direct-booking incentives: the first lifts ADR in peak periods, the second reduces OTA commission so the same turnover leaves more profit. Dynamic pricing must be communicated transparently, though, or guests may perceive it as unfair. In F&B the opportunity is clear-cut: 60% of guests already eat in the outlet at least once, making the remaining 40% a direct conversion target. Pre-arrival dining upsells and off-peak offers make sense here, but with a 50% variable cost ratio the focus should be on promoting high-margin items rather than discounting.
Events has a smaller revenue base, but it creates strong total revenue impact when an event is linked to bedrooms, catering and bar spend, hence the weekday corporate packages and minimum-spend private event pricing. The main risk here is operational: unless sales, kitchen, events and revenue management share the same forecast, the result is both service pressure and low-margin business. In Spa, off-peak treatment pricing and stay-and-spa bundles capture growing wellness demand, but peak-time capacity must be protected so hotel guests and local clients don’t compete for the same slots.
All of these share one risk: if packages lean too heavily on discounting or high-cost service delivery, TRevPAR can rise while GOPPAR weakens. Every initiative should therefore be assessed on contribution margin, not guest uptake or revenue volume.
| Department | Initiative 1 | Initiative 2 | Revenue & Profit Logic |
|---|---|---|---|
| Rooms | Demand-led pricing | Direct booking incentives | Lifts ADR in peak periods; reduces commission leakage and discount dependence. |
| F&B | Pre-arrival dining upsell | Off-peak restaurant/bar offers | Increases in-house spend; manages the higher variable cost to protect margin. |
| Events | Weekday corporate packages | Minimum-spend private events | Improves space utilisation; bundles room hire, catering and bar spend. |
| Spa | Off-peak treatment pricing | Stay-and-spa bundles | Grows incremental usage; supports cross-selling with rooms and F&B. |
Cross-Selling Packages
Five Package Ideas, Five Target Segments
Alongside the department-level initiatives, I designed five packages that combine multiple revenue streams into a single sale. The aim isn’t simply to fill rooms; it is to move guest spend out of the bedroom and into the restaurant, the spa and the event space. Each package targets a different segment, because a weekday corporate guest and a weekend wellness guest differ in both what they want and how long they stay.
I assessed each package not only on the revenue it could generate but on the operational risk it carries, since every package is as much a capacity and margin commitment as a revenue opportunity. The Business Traveller Dining Bundle could lift weekday F&B capture, but dining credits will dilute margin unless restricted to selected menu items. The Weekend Wellness Escape fits the demand trend well, yet may strain weekend spa capacity. The Conference Plus Stay Package produces the highest basket value, but is the most dependent on accurate sales, events and kitchen forecasting. Each should therefore be tested by segment, season and GOPPAR impact, not by how often it sells.
| Package | Target Segment | Revenue Streams | Main Risk |
|---|---|---|---|
| Business Traveller Dining Bundle | Weekday corporate travellers | Rooms + F&B | Dining credits may dilute margin. |
| Weekend Wellness Escape | Leisure couples and staycation guests | Rooms + Spa + F&B | Weekend spa capacity pressure. |
| Conference Plus Stay Package | Corporate organisers and meeting guests | Events + Rooms + F&B | Coordination complexity and demand variability. |
| Spa and Afternoon Tea Local Package | Local residents and day visitors | Spa + F&B | Limited room revenue; monitor GOP contribution. |
| Wedding Guest Extension Package | Wedding guests and family groups | Events + Rooms + F&B + Spa | Weekend capacity pressure; needs early coordination. |
Data Integration
Connecting PMS, POS, Events and Spa Data
Every recommendation so far rests on one assumption: that the hotel can see, end to end, what each guest is worth. In Surrey Hotel’s current state it cannot, because the PMS, POS and spa software don’t talk to each other. Data integration is therefore the operating foundation of TRevM, though buying software alone won’t fix it: departments must record information consistently and use the same KPI definitions.
The proposed structure is a central data hub connecting every system around a common guest ID or booking reference. That makes the question "what did this guest actually contribute?" answerable for the first time.
| System | Data It Should Capture | What It Enables |
|---|---|---|
| PMS | Occupancy, ADR, booking channel, lead time, length of stay, guest segment | Demand forecasting and segment-based pricing |
| POS | Restaurant, bar and room-service spend; time of purchase; F&B capture rate | Well-timed F&B upsells and margin tracking |
| Events System | Enquiries, conversion rate, event type, space utilisation, weekday/weekend split | Managing function-space profitability |
| Spa Software | Treatment type, time slot, capacity utilisation, hotel guest vs. local client | Off-peak pricing and capacity protection |
| Finance | Department-level variable cost, margin and GOPPAR | Seeing where profit actually comes from |
| CRM | Preferences, stay purpose, package response | Personalised offers and package targeting |
Organisation
The Data Problem Is Also an Organisational One
Connecting the systems solves only half the problem. In the current structure each department manages its own pricing, forecasting and targets separately, which is why the Revenue Manager role should evolve into a broader "Total Revenue Lead" function working alongside Finance and the Sales, Marketing & Commercial team. That role coordinates pricing, demand generation and profit optimisation across all four departments.
In practice this means a weekly Total Revenue Meeting. Its purpose is not to share updates but to produce joint decisions on pricing, staffing, packaging, forecasting and promotional activity. The critical condition is that F&B, events and spa managers accept GOPPAR as their own responsibility, rather than continuing to optimise only their departmental targets.
Finally, the analytics sequence matters. The literature (Mariani and Wirtz, 2023) argues that hotels should build strong basic analytics before relying on advanced AI-based analytics. Surrey Hotel should therefore establish clean data routines, shared KPI definitions and cross-department coordination first; personalisation and AI can follow.
Performance Measurement
The Q2 Dashboard and Exception-Based Management
Once the data is collected, something has to turn it into management action. The Q2 dashboard I designed brings hotel-level KPIs (occupancy, RevPAR, TRevPAR, GOPPAR) onto one screen alongside department revenue, profit, margin, revenue mix, F&B capture, spa usage, event utilisation and package conversion. Including cost and margin indicators, not just revenue ones, is essential: UK hotels are under cost pressure, and turnover growth alone doesn’t mean profitability.
The dashboard’s real value lies in exception-based management, where managers act on specific deviations rather than reading every number. I defined four practical rules for this.
Strategic Discussion & Implementation
The Biggest Barrier Is Cultural, Not Numerical
Perhaps the most important finding of this study is that the calculations are relatively straightforward, while institutionalising shared accountability is not. Building the model takes days; getting F&B, events and spa managers to stop seeing revenue management as "the rooms team’s job" takes far longer. Four concrete barriers stand out.
The first is departmental silos: all four departments run separate pricing and forecasting routines, so weekly joint meetings and shared package targets are needed. The second is misaligned incentives: if managers are measured only on their own departmental revenue, they will support the pilot in principle while continuing to protect their own budgets in practice, so incentives should include TRevPAR, GOPPAR and package profitability. The third is data capability: simple data-entry standards and staff training are prerequisites for any advanced analytics. The fourth is market uncertainty: economic caution and consumer sensitivity around value for money can affect travel spend, which makes disciplined profit growth more important still.
None of these is solved in one move, so I split the pilot into three phases. The logic is to move from testing, to a repeatable process, to embedded culture.
Recommendation to Management
Conclusion and Recommendation
In conclusion, Surrey Hotel should proceed with the Q2 TRevM pilot. The model shows TRevPAR could rise from £122 to £161.5 and GOPPAR from £64 to £103.5 without growing room inventory, making this a question of serving the existing guest better rather than of new investment. Rooms remains the strongest profit engine, but the strategic opportunity lies in integrating F&B, Events and Spa into a shared revenue model. Management should start with the dashboard, the weekly Total Revenue Meeting, data standards, package testing and shared KPIs.
The main risks are poor data quality, departmental resistance, margin erosion and capacity pressure, particularly in F&B and Spa. These can be managed through phased implementation, staff training and profit-based performance monitoring. The critical point is the measure of success: the pilot should be judged on GOPPAR and lasting cross-department behaviour, not on TRevPAR alone.