ExcelsiorAsset Management & Advisory

ExpertiseRevenue Management Revenue Management 101

Knowledge · Revenue

Revenue Management 101.

Fifteen lessons for owners and general managers: what to sell, to whom, at what price, and when. Three calculators at the end.

Fifteen lessons

Written from Excelsior’s practice manual, Revenue Management 101 for Engaged Hotel Owners. The full manual and workbook are in the library.

  1. What revenue management is

    Revenue management is selling the right room to the right guest at the right price at the right time, so that a fixed number of rooms earns the most it can over the long term. The definition is Sheryl Kimes’s.

    There are three levers. Price is what you charge. Duration is how long the guest stays, and when. Reach is how and where you sell. Most hotels pull the first and neglect the other two.

    It is not discounting. Across industries Kimes puts the gain from doing it properly at 2 to 5 percent of revenue, most of which reaches profit.

  2. Does it suit your hotel? Six conditions

    • Capacity is relatively fixed
    • Fixed costs are high and variable costs are low
    • Unsold rooms perish every night
    • Guests book in advance, so a request can be accepted or declined
    • Demand varies by season, day and hour
    • Different guests will pay different prices, and you can tell them apart

    Score each from 1 to 5. Above 80 percent of the maximum, run the full discipline. Between 60 and 80, start with duration controls and pricing. Below 60, fix the product first.

  3. The numbers

    ADR is rooms revenue divided by rooms sold. Occupancy is rooms sold divided by rooms available. RevPAR is the two multiplied.

    RevPAR rewards volume bought at any price. Net RevPAR deducts the cost of winning the booking. GOPPAR shows what is left after running the hotel. Report all three together.

    Against competitors, read MPI, ARI and RGI as a set. Hotels priced above their competitive set earn a RevPAR premium on average (Enz, Canina and Lomanno).

    Net RevPAR = (rooms revenue − acquisition cost) ÷ rooms available. RGI = MPI × ARI ÷ 100.

  4. One price leaves money behind

    Take 100 rooms and demand that falls in a straight line, from 100 rooms at a price of zero to none at a price of 100. One price of 50 sells 50 rooms and earns 2,500. Four prices of 80, 60, 40 and 20, each selling 20 rooms, earn 4,000 from the same demand. That is 60 percent more (Hanks, Cross and Noland).

    The gain holds only if a guest who would pay 80 cannot buy at 20. The rules that keep them apart are called fences.

  5. Fences

    Physical
    View, floor, room size, club access.
    Product line
    Good, better, best.
    Controlled availability
    Advance purchase, non-refundable, member rate, book-by date.
    Buyer
    Corporate, government, loyalty tier.

    A good fence rests on something the guest controls: when they book and how firmly they commit. It is clear to the guest and to the reservations agent. The discount is deep enough to attract the guest you want, and the restriction tight enough to keep the others out.

    Build fences at the top as well as the bottom. Paid extras that today’s guests value earn more than new discounts for guests who were not coming.

  6. Fair pricing

    Guests judge a price against a reference price and against the way they expect to buy. They accept that a firm deserves a reasonable profit. They resent a price raised simply because demand is high (Kahneman, Knetsch and Thaler).

    • Show the full rate, so the discount is visible
    • Attach a benefit to every higher price and a restriction to every lower one
    • Frame a difference as a discount: 20 percent off on weekdays reads better than 20 percent more at weekends
    • Quote each night at its own rate
    • Never let the price depend on whether the guest asks
  7. Forecasting

    The forecast comes first. Without one there is no revenue management. With a poor one there is poor revenue management (Kimes).

    Build a booking curve: rooms on the books by days before arrival, for like days. Then add the pickup you normally see between now and arrival. If 55 rooms are booked seven days out and Fridays normally pick up 40 more, forecast 95.

    Forecast what demand would have been, including the guests you turned away on full nights. History taken from sold-out nights understates demand for your best dates for ever.

    Measure the error. Report the weighted error and the bias together. A forecast can be close on average and still wrong in the same direction every week.

    Forecast = rooms on the books + average pickup from this point. Weighted error (WAPE) = sum of absolute errors ÷ sum of actuals.

  8. Hot, warm and cold

    Divide forecast demand by capacity for each night. At 100 percent or more the night is hot. Between 80 and 99 it is warm. Below 80 it is cold (Kimes).

    NightWhat to do
    HotRaise the lowest rate on sale. Close discounts. Require a minimum stay. Protect rooms for late bookers.
    WarmHold the rate. Sell selectively.
    ColdOpen fenced discounts, packages and promotions. Leave the public rate alone.

    Hot means more demand than rooms. A hotel that calls 40 percent occupancy its peak has a product problem, and pricing will not solve it.

  9. Protecting rooms for guests who book late

    The guests who pay most tend to book last. If every room is sold early at a low rate, nothing is left for them. Littlewood’s rule: accept a low-rate booking while the low rate is at least the high rate multiplied by the chance of still selling that room at the high rate.

    With rates of 250 and 200, and late demand averaging 15 rooms with a standard deviation of 5, the rule protects 10 rooms. The calculator below does it for your figures. With several rates the same idea is applied in layers (Belobaba’s EMSR-b).

    Protect y rooms, where the chance that high-rate demand exceeds y equals low rate ÷ high rate.

  10. Length-of-stay controls

    ControlUse it forThe risk
    Minimum stayA peak night followed by a quiet oneA guest who would pay well for one night goes elsewhere
    Maximum stayA discounted rate that must not run into a sold-out nightGuests overstay
    Closed to arrivalExtreme demand, where stayovers fill the nightIt damages the nights that follow

    Use them on hot dates only, and forecast by length of stay before setting them. Stacking many controls has damaged hotels (Kimes).

  11. Overbooking

    Some guests with reservations do not arrive. An empty room costs its contribution. A guest turned away costs the room elsewhere, the transport, the compensation and the goodwill. Overbook one more room while the chance of enough no-shows is at least the walk cost divided by the walk cost plus the empty-room cost.

    Reduce no-shows first, with card guarantees and reminders, and overbook on what remains. Keep separate tables by day of week and by channel. Track walks per 1,000 arrivals beside occupancy.

    Plan the walk in the morning, when it is already visible. Protect stayovers, loyal guests and late arrivals. A manager handles it: a comparable room nearby, a car both ways, and the telephone call.

    Overbook the k-th room while P(no-shows ≥ k) ≥ W ÷ (W + E). W is the cost of a walk, E the contribution of a room.

  12. Groups and displacement

    A group is worth taking when its contribution exceeds the contribution of the guests it displaces. Count only the rooms actually displaced, at the rates those guests would have paid, and add the group’s own food, beverage and room hire.

    A 300-room hotel expects 150 transient guests at 100, with a variable cost of 25 a room. A group asks for 220 rooms. It displaces 70. The break-even group rate is 48.86. That is the floor, and the quote should sit above it.

    Give a corporate account last-room availability only if its rate clears what the last room is worth on your peak nights.

    Break-even rate = variable cost − group ancillary contribution per room + displaced rooms × (transient rate − variable cost) ÷ group rooms.

  13. Distribution

    Rank channels on what you keep, not on what the guest pays. Net ADR is the rate after commission and the fixed cost of the booking. Acquisition cost has risen to between 15 and 25 percent of what guests pay (Kalibri Labs).

    An online travel agent is a paid acquisition channel. The claim that a listing lifts direct bookings is true but small: about 7 percent of shoppers switch to the hotel’s own site. It is no reason to buy volume.

    Keep the public rate in parity. Win direct bookings with member rates and with benefits that only the hotel’s own site carries. The arithmetic is in digital marketing for hotels.

    Net ADR = ADR × (1 − commission) − fixed cost per booking ÷ length of stay.

  14. Total revenue

    Optimise the guest, not the room. A wedding group at a lower room rate with heavy banqueting can be worth more than a full-rate guest who eats elsewhere.

    Departments earn very different margins: rooms about 80 percent, food and beverage 30 to 40, room hire 85 to 95. Rank every enquiry on contribution per unit of the scarce thing: the room-night, the seat-hour, the square foot per session.

  15. The rhythm

    How oftenWhat is doneBy whom
    DailyPickup and pace for 90 nights ahead. Rate tier, fences and minimum stays. Overbooking limit and walk plan.Revenue manager
    Twice a weekRe-forecast.Revenue manager
    WeeklyRevenue meeting: forecast by segment, group decisions on displacement, channel mix, rate check.Director of revenue, with GM and sales
    MonthlyMarket indices, Net RevPAR, forecast error and bias, variance, flow-through.Director of revenue, with finance
    QuarterlySegment contribution ranking, price tests, channel contracts.Director of revenue
    YearlyCorporate rates tested on displacement. Budget by segment. Rate ladder reset.Director of revenue, sales, GM

    Pay the sales team on contribution after displacement, and the general manager on GOPPAR and RGI. A team paid on volume will deliver volume.

Protection level: Littlewood’s rule

How many rooms to hold back for guests who book late at the higher rate.

Protection = mean + standard deviation × z, where z is the normal value for (1 − lower ÷ higher). Rounded down.

Result · example figures until you change them

Lower rate ÷ higher rate—
Protection level, exact—
Most rooms to sell at the lower rate—
Rooms to protect—

Overbooking limit

How many reservations to accept on a sold-out night, weighing an empty room against a walked guest.

Arrivals follow a binomial distribution. The limit is the booking level with the highest expected value. Amounts are in currency units.

Result · example figures until you change them

Critical ratio, W ÷ (W + E)—
Rooms to overbook by—
Expected walks a night—
Expected gain a night—
Reservations to accept—

Group displacement

The lowest rate at which a group pays for the guests it pushes out, for one night.

Displaced = forecast + block − capacity, never more than the block. Run each night of the stay separately.

Result · example figures until you change them

Transient rooms displaced—
Group contribution—
Contribution displaced—
Net gain from taking the group—
Break-even group rate—

Four questions for the owner

  • Is our RevPAR index above 100, and did we get there through rate or through occupancy?
  • What is Net RevPAR, and what did each channel cost us?
  • How accurate was the forecast 14 days out, and in which direction was it wrong?
  • How many groups were quoted below the displacement floor, and who approved them?

Authorities

Kimes; Kimes and Chase; Hanks, Cross and Noland; Littlewood; Belobaba; Enz, Canina and Lomanno; Kahneman, Knetsch and Thaler; Kalibri Labs. Worked examples are theirs where named.

Read next

More from Revenue Management

Paper

Market Segmentation

Segments, sources and channels: the mix that sets a hotel’s rate.

Read →
Course

Digital Marketing for Hotels

The booking journey, channel cost, funnel arithmetic and a launch checklist.

Read →

Contact

A first conversation is with the principal, in confidence.

Tell us the hotel, the question and the date by which you need an answer. Accounts are read only under a signed non-disclosure agreement.

Emailvikram.singh@excelsiorassetmanagement.com
WhatsApp+91 98733 42567
OfficesNew Delhi · Jaipur