Hotel single-night block pickup arithmetic calculator

Calculate pickup rooms at release and unused rooms released with your own figures.

Your numbers

Use the units shown. Results update as you change valid inputs.

Choose the currency for these amounts. Changing it keeps your numbers and does not convert exchange rates.

Use pickup rooms at release and unused rooms released to compare changes to your inputs. The method and limits below explain the scope.

Examples

Examples

Try the starting example

Reserved block rooms (count)
20
Cumulative pickup [ISO date,rooms]; enter JSON
[["2026-11-01",8],["2026-11-05",14]]
Block release date (ISO date)
2026-11-05
Guaranteed pickup fraction
0.8
Attrition fee (USD/room)
100
Pickup rooms at release (count)
14
Unused rooms released (count)
6
Potential attrition charge (USD)
$200.00

Try another scenario

Reserved block rooms (count)
30
Cumulative pickup [ISO date,rooms]; enter JSON
[["2026-11-01",10],["2026-11-05",20]]
Block release date (ISO date)
2026-11-05
Guaranteed pickup fraction
0.75
Attrition fee (USD/room)
120
Pickup rooms at release (count)
20
Unused rooms released (count)
10
Potential attrition charge (USD)
$360.00
Calculation method

Calculation method

Pickup rooms at release (count)

Latest cumulative pickup on or before release; zero if none.

Unused rooms released (count)

max(0,block−pickup at release).

Potential attrition charge (USD)

max(0,ceil(block×guarantee)−pickup at release)×fee.

Symbols and units
a
Reserved block rooms (count)
b
Cumulative pickup [ISO date,rooms]; enter JSON
c
Block release date (ISO date)
d
Guaranteed pickup fraction
e
Attrition fee (USD/room)

Use the units shown. A list keeps the order in which you enter its values. The symbol ^ means “raised to the power of”.

Assumptions & limits

Assumptions & limits

  • One-night group room block; all-in guaranteed pickup fraction and flat attrition per unmet guaranteed room are user policy. Supported limits: All numeric inputs and computed intermediates must remain finite. Supported numeric input magnitude is zero or 1e-12 through 1e12 in absolute value; reject values outside this bounded range. All lists/JSON record tables are limited to 100 records unless a stricter bound is stated; reject malformed record arity and wrong member types. Pickup counts nondecreasing and<=block; dates chronological and valid; one-night block.
Are these inputs private?

These calculations run in your browser. A shared link contains the values you choose to share. Only questions submitted to the separate AI finder are sent to OpenAI.

Share this page
Share this calculator

Leave unchecked to share the page without your entered values.