Hotel Group Booking Pricing Calculator
Estimate total revenue from a group hotel booking, including room revenue and ancillary spend such as F&B or event services. Useful for sales managers quoting group rates and evaluating deal profitability.
About this calculator
Group bookings combine two distinct revenue streams: room revenue and ancillary revenue from services like catering, meeting rooms, or spa packages. The room revenue component applies a group-size category multiplier to the standard rate, reflecting tiered discounts or premium packages negotiated for the group. Ancillary revenue is discounted to 80% of face value (the 0.8 factor), accounting for group concessions such as complimentary meals or reduced service fees. The full formula is: Total Revenue = (roomsBooked × nights × standardRate × groupSize) + (roomsBooked × additionalRevenuePerRoom × nights × 0.8). The groupSize multiplier is typically a decimal near 1.0 — for example, 0.85 for a group discount or 1.05 for a premium buyout. This model helps sales teams quickly compare the net value of different group configurations before making an offer.
How to use
A corporate group books 20 rooms for 3 nights. The standard rate is $150/night, the group size category multiplier is 0.90 (a 10% discount), and additional ancillary revenue per room per night is $40. Room revenue = 20 × 3 × $150 × 0.90 = $8,100. Ancillary revenue = 20 × $40 × 3 × 0.80 = $1,920. Total group booking revenue = $8,100 + $1,920 = $10,020. The sales manager can compare this figure against the hotel's displacement cost — the revenue foregone by not selling those rooms at full rate — 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. Including an 80% realization factor — as this calculator does — accounts for attrition, no-shows, and complimentary items typically bundled into group contracts.
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.