Rex says
Money math without the spreadsheet headache. Plug in your numbers and I'll show you exactly where the dollars land.
Try a scenario
Click to load — tweak from there.Inputs
Result
Attrition fee owed by group
$4,462.50
Rooms short of threshold
30
Total hotel revenue recovered
$28,962.50
Shortfall vs full block pickup
$6,037.50
Psst — share this and help Rex grow
One click, a permanent link with your numbers baked in.
How to use this
- 1Enter contracted room block.
- 2Enter attrition threshold (%).
- 3Enter actual rooms picked up.
- 4Enter contracted group rate ($).
- 5Enter avoided-cost offset (housekeeping etc.) (%).
- 6Read your attrition fee owed by group on the right — it updates as you type.
- 7Hit Share to keep the scenario or send it to someone.
About this calculator
Group and meeting contracts set an attrition threshold — usually 80-90% of the blocked rooms — below which the group owes damages for rooms they reserved but didn't fill. This calculator compares actual pickup against the block size and threshold, calculates the shortfall, and applies the contracted attrition fee (usually charged at the group rate minus an allowance for costs the hotel avoided, like housekeeping on unsold rooms) to show what the group owes and what the hotel actually recovers versus what full pickup would have generated.
Worked example
Using the values the calculator loads with:
Inputs
- Contracted room block: 200
- Attrition threshold: 85 %
- Actual rooms picked up: 140
- Contracted group rate: 175 $
- Avoided-cost offset (housekeeping etc.): 15 %
Results
- Attrition fee owed by group: $4,462.50
- Rooms short of threshold: 30
- Total hotel revenue recovered: $28,962.50
- Shortfall vs full block pickup: $6,037.50
What each field means
Inputs
- Contracted room block
- The contracted room block used in the calculation. Starts at 200 so you have a working example on load.
- Attrition threshold (%)
- The attrition threshold used in the calculation, measured in %. Starts at 85 % so you have a working example on load. Accepted range: 0–100 %.
- Actual rooms picked up
- The actual rooms picked up used in the calculation. Starts at 140 so you have a working example on load.
- Contracted group rate ($)
- The contracted group rate used in the calculation, measured in $. Starts at 175 $ so you have a working example on load.
- Avoided-cost offset (housekeeping etc.) (%)
- The avoided-cost offset (housekeeping etc.) used in the calculation, measured in %. Starts at 15 % so you have a working example on load. Accepted range: 0–100 %.
Results
- Attrition fee owed by group
- Returned as a money amount in US dollars and shown as the headline result. It recalculates instantly whenever you change an input, so you can compare scenarios without reloading.
- Rooms short of threshold
- Returned as a whole number. It recalculates instantly whenever you change an input, so you can compare scenarios without reloading.
- Total hotel revenue recovered
- Returned as a money amount in US dollars. It recalculates instantly whenever you change an input, so you can compare scenarios without reloading.
- Shortfall vs full block pickup
- Returned as a money amount in US dollars. It recalculates instantly whenever you change an input, so you can compare scenarios without reloading.
FAQ
Why is attrition threshold usually below 100% of the block?
Contracts build in a cushion, typically 80-90% of the block, because a small pickup miss is normal and expected. Groups negotiate this cushion specifically so minor forecasting error doesn't trigger a penalty — the fee only kicks in once the shortfall exceeds that negotiated tolerance.
Why subtract a cost offset from the attrition fee?
Courts and standard hotel contracts generally require the attrition fee to reflect the hotel's actual damages, not a windfall. Since unsold rooms also don't incur housekeeping, amenities, and some utility costs, a 10-20% offset against group rate is standard to approximate those avoided variable costs.
Can the hotel also resell attrition rooms to other guests?
Yes, and many contracts require mitigation — if the hotel resells rooms from the unfulfilled block to other guests at or near the group rate, that resold revenue typically must be credited against the attrition fee owed, reducing what the group ultimately pays.
How should sales teams use this before signing a contract?
Model attrition cost recovery at a realistic worst-case pickup (60-70% of block) before finalizing rate and threshold. If the recovered revenue including the attrition fee still falls meaningfully short of the group rate at full block, it signals the block size may be oversold relative to the group's realistic room need.
Accuracy and limitations
- Results are estimates before tax, fees, and inflation unless an input explicitly covers them.
- Rates are treated as fixed for the whole period — variable-rate products will drift from this projection.
- This is educational maths, not financial advice. Check anything contractual with the lender or your accountant.
Related tools
Hotel RevPAR Calculator
Revenue per available room from occupancy and ADR, or from room revenue directly.
Venue Rental Profit Per Event Calculator
Net profit per booking after staffing, cleanup, and venue overhead allocation.
Hotel Renovation Payback Calculator
Years to recover a renovation's cost from the incremental RevPAR it generates.
Cite this calculator
Writing about this topic? Grab a citation — every link helps keep these tools free.
RevenueLab. (2026). Group Block Attrition Cost Calculator. Retrieved from https://www.revenuelab.fyi/toolbox/group-block-attrition-cost
<p>Source: <a href="https://www.revenuelab.fyi/toolbox/group-block-attrition-cost" target="_blank" rel="noopener">Group Block Attrition Cost Calculator — RevenueLab</a> (2026).</p>
Source: [Group Block Attrition Cost Calculator — RevenueLab](https://www.revenuelab.fyi/toolbox/group-block-attrition-cost) (2026).