← Back to all work

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.

78% → 85%
Occupancy
£96 → £102
RevPAR (+6.3%)
£122 → £161.5
TRevPAR (+32.4%)
£64 → £103.5
GOPPAR (+61.7%)

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.

MetricHow It Is CalculatedThe Question It Answers
RevPARRooms revenue ÷ available roomsHow much revenue do the bedrooms alone generate?
TRevPARTotal hotel revenue (all departments) ÷ available roomsHow much revenue does the whole hotel generate per room?
GOPPARGross operating profit ÷ available roomsWhat 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.

KPIQ1 ActualQ2 ForecastChange% Change
Occupancy78%85%+7 pts9.0%
RevPAR£96.0£102.0+£6.06.3%
TRevPAR£122.0£161.5+£39.532.4%
GOPPAR£64.0£103.5+£39.561.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.

DepartmentTotal RevenueVariable CostGross Operating ProfitProfit Contribution
Rooms£25,500.0£7,650.0£17,850.069.0%
F&B£7,437.5£3,718.8£3,718.814.4%
Events£4,250.0£1,700.0£2,550.09.9%
Spa£3,187.5£1,434.4£1,753.16.8%
Total£40,375.0£14,503.1£25,871.9100%
£0£50£100£150 £ PER AVAILABLE ROOM £102 RevPAR +£29.75 F&B Contribution +£17 Events Contribution +£12.75 Spa Contribution £161.5 TRevPAR

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.

DepartmentInitiative 1Initiative 2Revenue & Profit Logic
RoomsDemand-led pricingDirect booking incentivesLifts ADR in peak periods; reduces commission leakage and discount dependence.
F&BPre-arrival dining upsellOff-peak restaurant/bar offersIncreases in-house spend; manages the higher variable cost to protect margin.
EventsWeekday corporate packagesMinimum-spend private eventsImproves space utilisation; bundles room hire, catering and bar spend.
SpaOff-peak treatment pricingStay-and-spa bundlesGrows 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.

PackageTarget SegmentRevenue StreamsMain Risk
Business Traveller Dining BundleWeekday corporate travellersRooms + F&BDining credits may dilute margin.
Weekend Wellness EscapeLeisure couples and staycation guestsRooms + Spa + F&BWeekend spa capacity pressure.
Conference Plus Stay PackageCorporate organisers and meeting guestsEvents + Rooms + F&BCoordination complexity and demand variability.
Spa and Afternoon Tea Local PackageLocal residents and day visitorsSpa + F&BLimited room revenue; monitor GOP contribution.
Wedding Guest Extension PackageWedding guests and family groupsEvents + Rooms + F&B + SpaWeekend 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.

SystemData It Should CaptureWhat It Enables
PMSOccupancy, ADR, booking channel, lead time, length of stay, guest segmentDemand forecasting and segment-based pricing
POSRestaurant, bar and room-service spend; time of purchase; F&B capture rateWell-timed F&B upsells and margin tracking
Events SystemEnquiries, conversion rate, event type, space utilisation, weekday/weekend splitManaging function-space profitability
Spa SoftwareTreatment type, time slot, capacity utilisation, hotel guest vs. local clientOff-peak pricing and capacity protection
FinanceDepartment-level variable cost, margin and GOPPARSeeing where profit actually comes from
CRMPreferences, stay purpose, package responsePersonalised 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.

RevPAR rises but TRevPAR is flat: cross-selling isn’t working, so package and upsell action is needed.
TRevPAR rises but GOPPAR falls: packages are over-discounted or too costly, so contribution margin should be reviewed.
F&B capture is low on high-occupancy nights: pre-arrival dining offers should be targeted.
Midweek spa utilisation is low: off-peak wellness offers should be tested.
60%
F&B Capture Rate (current)
30%
Spa Usage Rate (current)
Not tracked
Event Utilisation (data gap)
Medium-High
Cross-Selling Readiness

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.

Short Term (Q2): Build the dashboard, define data standards, start the weekly Total Revenue Meeting and test two or three packages. Target: push TRevPAR above £150 while protecting GOPPAR.
Medium Term: Refine package pricing, improve forecasting, train managers, and use guest segmentation to sharpen the F&B, spa and event offers.
Long Term: Embed TRevM into CRM, budgeting, job descriptions, incentives and performance reviews, so it becomes a way of working rather than a metric.

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.