CPA PM Elective study materials
CPA PM Elective study resources

Lakeside Suites: rate architecture, channel mix and a bonus that buys occupancy

CPA PM Elective · Put your knowledge to work in context.

All case studies

Lakeside Suites: rate architecture, channel mix and a bonus that buys occupancy

Lakeside Suites is a 140-room independent hotel in a regional city serving two segments. Business travellers dominate Monday to Thursday; leisure and event guests dominate Friday and Saturday; Sunday is the weakest night. The hotel currently charges a flat rack rate of $215 every night through every channel. Occupancy is 78% Monday to Thursday, 88% Friday and Saturday, and 48% on Sunday. Variable cost per occupied room-night is $42 for housekeeping, laundry and utilities; fixed costs are $3.1 million a year. About 45% of room-nights come through online travel agencies charging 17% commission; the remainder are direct, at an average acquisition cost of $9 per booking. The revenue manager proposes Monday-Thursday at $249, Friday-Saturday at $229, Sunday at $149, plus a non-refundable advance-purchase rate of $139 available every night and capped at 25 rooms a night. The sales director, whose bonus is 60% weighted to occupancy percentage and 40% to total revenue, supports the advance rate because it will 'fill the house'.

1. Using contribution analysis, calculate the break-even occupancy for each of the three proposed rate changes and assess whether each is likely to pay off.

Read the worked answer

Contribution per occupied room-night at $215 = $215 - $42 = $173. For a single-night comparison, ignore channel mix because it applies to every option.

Monday-Thursday at $249 (contribution $207): Current contribution = 140 x 78% x $173 = 109.2 rooms x $173 = $18,892. Break-even rooms = 18,892 / 207 = 91.3 rooms, or 65.2% occupancy. The hotel can lose 17.9 rooms a night (16% of current volume) and still be better off. With weekday corporate demand that is usually contracted and relatively price-insensitive, this is very likely to pay.

Friday-Saturday at $229 (contribution $187): Current = 123.2 rooms x $173 = $21,314. Break-even = 21,314 / 187 = 114.0 rooms, or 81.4% occupancy. It can lose 7.5% of weekend volume against a 6.5% rate rise. Weekend leisure and event demand is often booked around a fixed date, so this is plausible, but the 88% base leaves little slack - monitor the first eight weeks.

Sunday at $149 (contribution $107): Current = 67.2 rooms x $173 = $11,626. Break-even = 11,626 / 107 = 108.6 rooms, or 77.6% occupancy - a 62% volume increase on the weakest night of the week. That requires proven latent demand, not hope.

The general rule: with no variable cost saved when price falls, required volume increase = price reduction % x (1 / contribution margin %). Here the Sunday rate falls 30.7% and unit contribution falls 38.2%, so volume must rise 61.7% just to stand still. Unless Sunday guests bring incremental food and beverage - $45 of spend at 60% margin would lift contribution to about $134 and reduce the break-even to roughly 62% - the Sunday cut destroys value. Recommend holding the Sunday rate and using targeted packages instead.

2. Evaluate the advance-purchase rate and the channel mix from a contribution standpoint, and recommend how both should be restructured.

Read the worked answer

Advance rate at $139. Contribution = $139 - $42 = $97, against $173 at rack: a $76 dilution per room-night. It creates value only where it fills nights that would otherwise be empty. On a Friday at 88% occupancy, 25 rooms at $139 would displace $215 rooms, destroying up to 25 x $76 = $1,900 a night to generate revenue that would largely have arrived anyway. At 48% on Sunday it is genuinely incremental. A single 'every night' cap is therefore the wrong control.

Fencing. Restrict the advance rate to Sunday-Thursday and known low-demand dates, close it automatically when the forecast is above about 75% occupancy, require 14-day advance purchase, and make it non-refundable and non-changeable. Cap by percentage of inventory, not a flat 25 rooms. Report dilution - room-nights sold below the floor rate - monthly.

Channel economics. OTA contribution = $215 x 83% - $42 = $136.45. Direct contribution = $215 - $42 - $9 = $164. The OTA costs $27.55 more per room-night, or $99,000 a year on 3,600 OTA room-nights at current volume.

The break-even direct discount. Direct beats OTA at $215 for any direct rate above $187.45 (since P - $51 = $136.45). A members' direct rate of $205 keeps $154 of contribution - still $17.55 better than the OTA at full rate. That is a far better use of price than a blanket advance rate.

Recommendation: introduce a free-to-join members' rate at $205 bookable direct, invest in the booking engine and email capture, and treat OTAs as a demand-generation channel for shoulder and low-demand nights rather than 45% of the base. Target direct share above 65% over two years, with the cost of acquisition as a percentage of revenue as the tracking measure.

3. Assess the sales director's bonus design and recommend the performance measures and pricing controls Lakeside should adopt.

Read the worked answer

The incentive is misaligned. A 60% weight on occupancy rewards the easiest thing to buy: discount. A 5-point occupancy gain purchased with a 12% rate cut reduces RevPAR and contribution while the bonus rises. The 40% revenue weight partially offsets but still rewards volume at any price, and neither measure captures channel cost, so pushing OTA volume looks neutral when it costs $27.55 a room-night more.

Replace with:

  • RevPAR (occupancy x average daily rate) as the primary measure - it cannot be improved by discounting alone.
  • GOPPAR or departmental profit per available room, so housekeeping cost and channel commission are visible.
  • Channel mix: direct share of room-nights and cost of acquisition as a percentage of room revenue.
  • Rate integrity: average discount to rack and the percentage of room-nights sold below the approved floor rate.
  • Weight the bonus roughly 50% GOPPAR, 30% RevPAR, 20% direct share, with a quality gate (guest satisfaction below threshold cancels the incentive).

Pricing controls:

  1. A written rate architecture with approved floors by season and segment, reviewed quarterly by a revenue committee.
  2. Discount codes issued by the revenue manager only; any override above a set percentage requires documented approval.
  3. Automatic close-out of discounted inventory when forecast occupancy exceeds the threshold - applied in the system, not by discretion.
  4. Weekly forecast-versus-actual review, with the reasons for variance recorded.
  5. Monthly audit of overrides and of below-floor sales, reported to the owner or board with named accountability.
  6. Segregation of duties between setting rates and approving exceptions, so the person with the volume target cannot also authorise the discount.

The advance rate can remain, but only inside these controls - otherwise it is a rate-integrity problem dressed as a marketing initiative.