Calculated Results
This summary appears below the header and above the form after submission.
| Metric | Value | Meaning |
|---|---|---|
| Cancellation Rate | 0.00% | Cancelled bookings as a share of confirmed bookings |
| No-Show Rate | 0.00% | No-shows as a share of net bookings |
| Inventory Room Nights | 0.00 | Available rooms multiplied by selected days |
| Distribution Cost | $0.00 | Estimated channel or acquisition expense |
Plotly Graph
Booking Rate Calculator
Enter hotel performance inputs below. The form uses a three-column layout on large screens, two columns on smaller screens, and one column on mobile.
Example Data Table
| Property | Inquiries | Confirmed | Cancellations | No-Shows | Rooms/Day | Days | ADR | Avg Stay | Channel Cost | Gross Rate | Net Rate | Occupancy |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Sunrise Stay Suites | 240 | 120 | 18 | 6 | 50 | 7 | $120.00 | 2.0 | 12% | 50.00% | 42.50% | 54.86% |
| Harbor View Lodge | 180 | 72 | 9 | 3 | 36 | 7 | $98.00 | 1.8 | 10% | 40.00% | 35.00% | 42.50% |
| City Garden Hotel | 310 | 155 | 20 | 8 | 60 | 7 | $145.00 | 2.3 | 14% | 50.00% | 43.55% | 67.39% |
Formula Used
Gross Booking Rate = (Confirmed Bookings ÷ Total Inquiries) × 100
Net Booking Rate = ((Confirmed Bookings − Cancellations) ÷ Total Inquiries) × 100
Arrival Rate = ((Confirmed Bookings − Cancellations − No-Shows) ÷ Total Inquiries) × 100
Room Nights Sold = Arrived Bookings × Average Stay Length
Inventory Room Nights = Rooms Available Per Day × Number of Days
Occupancy Rate = (Room Nights Sold ÷ Inventory Room Nights) × 100
Gross Room Revenue = Room Nights Sold × ADR
Net Room Revenue = Gross Room Revenue − Distribution Cost
RevPAR = Gross Room Revenue ÷ Inventory Room Nights
How to Use This Calculator
- Enter the property name and reporting label for easy identification.
- Add total inquiries or qualified booking leads for the chosen period.
- Enter confirmed reservations, then add cancellations and no-shows.
- Provide available rooms per day and the number of reporting days.
- Input ADR, average stay length, and the expected channel cost rate.
- Click Calculate Booking Rate to show results above the form.
- Review the summary cards, detailed table, and Plotly graph for performance insights.
- Use the CSV or PDF buttons to export the current calculation for reporting.
FAQs
1) What does booking rate mean in this calculator?
This calculator treats booking rate as the share of inquiries that become confirmed reservations. It also shows net booking rate after cancellations and arrival rate after no-shows, giving a fuller hotel conversion picture.
2) Why are cancellations separated from no-shows?
Cancellations happen before arrival and can reopen inventory. No-shows happen after a room was expected to be occupied. Tracking them separately helps measure funnel leakage and operational risk more accurately.
3) How is occupancy connected to booking rate?
Booking rate shows conversion from inquiries to reservations. Occupancy shows how much room-night inventory was actually sold. A property can have strong conversion but weak occupancy if lead volume is low.
4) What is RevPAR in this report?
RevPAR means revenue per available room night. It is calculated by dividing gross room revenue by total room-night inventory. It helps compare pricing strength and inventory performance in one value.
5) Should I include complimentary stays in confirmed bookings?
Usually, no. Complimentary stays can distort conversion and revenue metrics. Count them separately unless your internal reporting policy requires them to be treated as sold inventory for performance comparisons.
6) Can this calculator be used for hostels or serviced apartments?
Yes. Replace rooms with your sellable accommodation units, keep the same lead and booking logic, and use the correct average rate and stay length for your property model.
7) Why add channel cost rate?
Channel cost rate estimates commissions, marketplace fees, or agent charges. Including it helps convert gross room revenue into a more realistic net room revenue figure for business decisions.
8) What period should I use for analysis?
Use the period that matches your reporting need. Daily data helps operational control, weekly data helps trend review, and monthly data supports budgeting, pricing, and wider commercial analysis.