Hotel room block and attrition calculator
Size a hotel room block night by night, then see how much the attrition clause could cost you if pickup comes in low, before you sign.
Your event and contract
Example valuesSuggested block on the peak night
300 rooms
675 room nights over 3 nights. No attrition owed if you fill at least 540 (80% of the block).
- Break-even pickup
- 80%
- 540 room nights
- Each room night short costs
- $249
- Owed at 70% pickup
- $16,932
- Room revenue at full pickup
- $168,075
Block per night
| Night | Of peak | Rooms | Fill at least |
|---|---|---|---|
| Night 1 | 75% | 225 | 180 |
| Night 2 | 100% | 300 | 240 |
| Night 3 | 50% | 150 | 120 |
Attrition exposure by pickup
| Pickup | Room nights | Short | You'd owe |
|---|---|---|---|
| 50% | 338 | 202 | $50,298 |
| 60% | 405 | 135 | $33,615 |
| 70% | 472 | 68 | $16,932 |
| 80% | 540 | 0 | $0 |
| 90% | 608 | 0 | $0 |
| 100% | 675 | 0 | $0 |
Pickup is the share of the block's room nights actually booked by cutoff. Measured cumulatively across all nights; if your contract checks each night separately, use the per-night minimums above.
The maths runs in your browser and we don't save your inputs. They're kept in the page URL so you can share the result.
When to use software instead
One hotel and one block is fine in a spreadsheet. With several hotels, sub-blocks for staff or VIPs, or pickup you need to track daily before cutoff, housing software does the counting for you. Compare options in our room block software guide.
How it works
The calculator uses the most common attrition clause: a cumulative allowance on total room nights. Contracts differ, so check yours for night-by-night measurement, resale credits and links to food and beverage minimums. The worked examples use the example inputs in US dollars.
Peak-night block
attendees × share who book in the block ÷ guests per room, rounded up
Example: 400 × 75% ÷ 1 = 300 rooms
Rooms each night
peak-night block × that night's share of the peak
Arrival and departure nights are usually lighter than the night before the main day.
Example: night 1: 75% = 225, night 2: 100% = 300, night 3: 50% = 150
Break-even pickup
block room nights × (1 − attrition allowance)
Fill at least this many and you owe nothing.
Example: 675 × (1 − 20%) = 540 room nights
Attrition owed
(minimum room nights − room nights picked up) × group rate × charge % × (1 − share resold)
Example: at 70% pickup: (540 − 472) × $249 × 100% = $16,932
Attrition and cutoff dates, in plain words
The attrition allowance is how far below the block you can fall without paying. The cutoff date, often 21 to 30 days before arrival, is when the hotel takes back unbooked rooms and counts your pickup. Before you sign, ask for a review date when you can reduce the block without penalty, credit for rooms the hotel resells, and credit for attendees who book outside the block at the same hotel.