Decisions · Free calculator · Nothing leaves your computer

Is this group worth taking?

What the group adds after the guests it displaces. Change any figure and the answer updates.

Your figures

Rooms in the hotelTotal rooms availableNightsHow long the group staysGroup rooms a nightRooms the group wants each nightGroup ratePer room, per nightF&B spend a room a nightWhat each group room spends on food and drinkF&B margin %What you keep of each food and drink dollarOccupancy without the group %How full you would be anywayRate those guests would payThe rate the displaced guests would have paidCost per occupied roomCleaning, amenities, laundry

What the group adds
+$4,548
Lowest rate worth taking
$127.10
Rooms displaced a night
22
Room nights in the stay
120

The working

Rooms the group displaces = 120 × 85% + 40 − 120 = 22 a night
Group rooms add = 40 × 3 × ($165.00 − $48.00) = $14,040
Group food and drink adds = 40 × 3 × $60.00 × 35% = $2,520
Displaced guests would have paid = 22 × 3 × ($230.00 − $48.00) = $12,012
Net = $14,040 + $2,520 − $12,012 = +$4,548
Lowest rate worth taking = $48.00 + ($12,012 − $2,520) ÷ (40 × 3) = $127.10