Calculator input
Use a single reservation or paste several rows. The form stays in one stacked page flow, while inputs shift to three columns on large screens.
Example data table
| Booking date | Check-in date | Rooms | Revenue | Channel | Lead time |
|---|---|---|---|---|---|
| 2026-01-02 | 2026-01-06 | 2 | 480.00 | OTA | 4 days |
| 2026-01-05 | 2026-01-20 | 1 | 210.00 | Direct | 15 days |
| 2026-01-11 | 2026-02-18 | 3 | 870.00 | Corporate | 38 days |
| 2026-01-16 | 2026-04-01 | 2 | 650.00 | OTA | 75 days |
Formula used
Lead Time (days) = Check-in Date − Booking Date
Average Lead Time = Sum of all lead times ÷ Number of bookings
Weighted Average Lead Time = Sum of (Lead Time × Rooms) ÷ Total rooms
Window Share = Bookings in a lead-time window ÷ Total bookings × 100
Hotels use booking lead time to understand how far ahead guests reserve rooms. Short windows often signal last-minute demand, while longer windows support inventory planning, pricing strategy, staffing, and campaign timing.
How to use this calculator
- Enter a booking date and check-in date for one reservation, or paste several reservation rows in the batch dataset area.
- Add optional rooms, revenue, and channel values to enrich weighted averages and channel comparisons.
- Press the calculate button. The results appear immediately above the form and below the header section.
- Review the summary cards, window mix, channel table, and reservation-level output.
- Use the CSV or PDF buttons to export your current result set.
FAQs
1) What does booking lead time measure?
It measures the number of days between the booking date and the guest check-in date. This helps hotels understand reservation behavior, demand timing, and likely booking windows.
2) Why is weighted average lead time useful?
Weighted average lead time gives more influence to reservations with more rooms. It is helpful when group, corporate, or multi-room bookings matter more than single-room reservations.
3) Can I calculate one reservation only?
Yes. Leave the batch dataset empty and complete the single reservation fields. The calculator will return the lead time and summary metrics for that one booking.
4) What happens if I paste multiple rows?
The calculator reads each row as a separate reservation, computes every lead time, and then builds averages, medians, booking window shares, and channel comparisons.
5) Which booking windows are grouped here?
This page groups bookings into four windows: 0–7 days, 8–30 days, 31–90 days, and 91+ days. These groups help reveal short and long demand patterns.
6) Why add revenue and room counts?
Revenue and room counts make the output more actionable. They help show whether high-value reservations arrive earlier, later, or through specific sales channels.
7) Can this help hotel pricing decisions?
Yes. Lead-time trends can support rate planning, promotion timing, stay restrictions, and channel management by showing when guests usually book before arrival.
8) What does the PDF export include?
The PDF export includes summary metrics, booking window shares, channel highlights, and reservation rows. It is useful for reporting, sharing, or archiving analysis.