Hotel Group Booking Pricing Calculator
Estimate the discounted room revenue for a group hotel booking after complimentary rooms, group discount, and a seasonal multiplier. Useful for sales managers quoting group rates.
Last updated: September 2026
Formula below · 1 source (Wikipedia) · Updated Sep 2026
Compare with similar
About this calculator
Group bookings are usually priced off the rack rate with three adjustments: complimentary rooms, a negotiated group discount, and a seasonal adjustment. The formula is: Total Revenue = round((totalRoomNights − floor(totalRoomNights / compRatio)) × rackRate × (1 − groupDiscount / 100) × seasonalMultiplier). The comp ratio gives one free room-night for every compRatio room-nights in the block (1:20, 1:25, 1:30 or 1:50), and floor() counts only whole comps, so a 60-night block at 1:25 earns 2 comps and pays for 58. The remaining paid room-nights are priced at the rack rate less the group discount, then scaled by the season (0.85 low, 1.0 regular, 1.2 peak, 1.4 holiday). The result is room revenue only; banquets, meeting rooms and other ancillary spend are not included.
How to use
A corporate group books 20 rooms for 3 nights (60 room-nights) at a $150 rack rate, with a 10% group discount, a 1:25 complimentary-room ratio, and regular season (1.0). Comp room-nights = floor(60/25) = 2; paid room-nights = 58. Group revenue = round(58 × 150 × 0.90 × 1.0) = $7,830. Compare this against the hotel's displacement cost — the revenue foregone by not selling those rooms to transient guests — to decide whether to accept the booking.
Frequently asked questions
How do hotels calculate group room rate discounts?
Group discounts are typically expressed as a percentage off the Best Available Rate (BAR) and scale with the size and value of the group. Small groups of 10–20 rooms might receive a 5–10% discount, while large convention blocks can negotiate 20–30% reductions plus value-adds like complimentary suites. Hotels balance the discount against the certainty of volume, the group's ancillary spend, and the dates requested — filling slow periods justifies steeper discounts than displacing higher-rated leisure travelers.
What ancillary revenue should hotels include in group booking projections?
Ancillary revenue for group bookings commonly includes food and beverage (banquets, coffee breaks, receptions), audiovisual and meeting room rental, transportation and parking, spa packages, and resort fees. F&B is often the largest ancillary category, sometimes matching or exceeding room revenue for conference groups. This calculator covers room revenue only, so estimate ancillary spend separately; many planners apply a realization factor of about 80% to contracted F&B to allow for attrition, no-shows, and complimentary items.
When is a group hotel booking financially worthwhile compared to transient business?
A group booking is worthwhile when its total net contribution (after discounts and concessions) exceeds the expected revenue from filling those rooms with transient guests at market rates. Groups add value by guaranteeing volume, reducing distribution costs (no OTA commissions), driving ancillary spend, and filling dates with low transient demand. Revenue managers compare the group's total spend per available room-night against the forecasted transient RevPAR for the same period before confirming the block.
Related calculators
Sources & references
Think a result is wrong? Report a problem with this calculator.