1Your hotel and price rules
The guard rails every recommendation must respect. BAR means best available rate: your standard public price for the night.
2The next 30 days
OTB means rooms on the books: rooms already reserved for that night. Copy cells from Excel and paste into any box to fill many at once. Tick Event for concerts, festivals or long weekends.
Copy the rows from Excel or Google Sheets (with or without the heading row) and paste here. Columns in this order if there is no heading: date, OTB, OTB last year, final last year, current BAR, comp 1, comp 2, comp 3, comp 4, event.
Demand calendar
Each square is one night, coloured by demand tier. A yellow dot marks an event. Hover or tap a square for details.
Your rate, the recommendation and the market
Lines are prices (left axis). Grey bars are the forecast occupancy (right axis).
Rate plan
Untick Accept to keep today's rate for a day. The totals above and the export use only the accepted changes.
| Date | Demand | Forecast full | Pace vs last year | Competitor middle | Current BAR | Recommended | Change | Accept | Why |
|---|
How it's calculated
1. Forecast. For each night: pace = rooms on the books now ÷ rooms on the books at the same time last year (limited to between 0.5 and 2). Last year's remaining pickup = last year's final rooms sold minus last year's rooms on the books at the same point. Forecast rooms = OTB + last year's remaining pickup × pace, plus the event boost on ticked days, capped at your capacity. If last year had no bookings yet at this point, pace is taken as 1.
2. Demand tier. The uncapped forecast as a share of capacity sets the tier: Low, Moderate, High or Compression (your thresholds in Step 1). An event moves the night up one tier.
3. Price. Start from the competitor middle price (the median of the rates you entered, so one odd rate does not drag it). Apply your position, then the tier adjustment, then a pace adjustment of 30% of the pace gap (at most ±6%). Target = median × (1 + position) × (1 + tier adjustment) × (1 + pace adjustment). The target is then limited to your biggest change in one go, kept inside the floor and ceiling (these always win), and rounded. Changes smaller than 2% are shown as Hold, so you are not chasing noise. With no competitor rates, the current BAR is used as the starting point.
4. Revenue estimate. Rooms already booked are assumed to stay at the current BAR. Rooms still to be booked respond to price: late bookings × (new rate ÷ current rate)−sensitivity, capped at capacity. Sensitivity is higher on quiet nights (guests shop around) and lower in compression (guests have few choices): 1.5, 1.1, 0.7 and 0.3 for Low to Compression, scaled by your choice in Step 1. ADR (average daily rate) = room revenue ÷ rooms sold. RevPAR (revenue per available room) = room revenue ÷ rooms available.
Limits. This is a rules-based recommender, not a machine-learning model. It does not know about group blocks, length-of-stay patterns, channel costs or rate parity, and the revenue estimate is a guide, not a promise. Always sense-check days with big moves. Your data stays in this browser; nothing is sent anywhere.