| Room Type | Rooms | Avg Rate | Room Rev | F&B | Spa | Total Folio |
|---|---|---|---|---|---|---|
| Penthouse Suite | 4 | $5,923 | $73,456 | $713 | $955 | $75,382 |
| Ocean View Double | 56 | $1,148 | $302,430 | $22,462 | $18,004 | $352,131 |
| Executive Suite Ocean | 29 | $2,192 | $304,390 | $12,771 | $8,930 | $330,456 |
| Ocean View King | 58 | $935 | $252,880 | $25,130 | $19,697 | $307,303 |
| Grand Suite | 7 | $3,418 | $154,532 | $3,955 | $2,390 | $161,842 |
| Garden View King | 57 | $641 | $170,175 | $27,740 | $15,868 | $221,024 |
| Garden View Double | 54 | $696 | $158,094 | $22,007 | $14,532 | $201,782 |
| Junior Suite Ocean | 26 | $1,431 | $136,214 | $10,415 | $6,053 | $155,366 |
| Pool View King | 34 | $577 | $89,745 | $16,042 | $10,568 | $120,556 |
| Golf View King | 33 | $583 | $91,445 | $12,917 | $9,747 | $119,180 |
Insight: Garden View rooms generate disproportionately high F&B revenue — $27.7K from Garden View King vs. $713 from Penthouses. Lower-rate guests eat on-property more. Opportunity: F&B packages for premium rooms.
| Guest | VIP | Room Type | Rate/Nt | Source | Special Request | Est. Folio |
|---|---|---|---|---|---|---|
| Sophie Martinez | — | Penthouse Suite | $5,758 | Direct Web | — | $17,846 |
| Danielle Lee | — | Penthouse Suite | $5,592 | Direct Phone | — | $57,529 |
| Marcus Chen | SILVER | Grand Suite | $3,436 | Booking.com | Feather-free room | $13,976 |
| Rachel Kim | PLATINUM | Grand Suite | $3,396 | Direct Web | King bed essential | $14,692 |
| Edward Adams | — | Grand Suite | $3,377 | Direct Web | Honeymoon setup | $7,019 |
| Christina Perez | — | Grand Suite | $3,232 | Direct Phone | Honeymoon setup | $13,803 |
| David Okafor | GOLD | Grand Suite | $2,832 | Booking.com | — | $5,997 |
| Thomas Nguyen | SILVER | Exec Suite Ocean | $2,484 | GDS Amadeus | Dietary — vegan | $5,346 |
| Andrew Nguyen | — | Exec Suite Ocean | $2,149 | Direct Web | Honeymoon setup | $13,558 |
| Elena Rossi | SILVER | Exec Suite Ocean | $1,785 | Direct Web | High floor requested | $11,656 |
| Priya Patel | GOLD | Junior Suite Ocean | $1,886 | Direct Web | Hypoallergenic bedding | $10,113 |
| James Wright | PLATINUM | Ocean View Double | $1,435 | Expedia | Champagne on arrival | $3,353 |
| Laura Bennett | PLATINUM | Garden View Double | $597 | Direct Web | Connecting rooms | $4,872 |
| Natalie Cho | PLATINUM | Pool View King | $796 | Direct Phone | Birthday setup | $3,962 |
| Ryan Morrison | SILVER | Garden View King | $595 | Expedia | Birthday setup | $1,496 |
| Sarah Washington | DIAMOND | Golf View King | $741 | Direct Phone | Anniversary — 25 years | $12,783 |
Action Items: 3 honeymoon setups, 2 birthday setups, 1 anniversary (25 years!), 4 dietary restrictions needing F&B alerts, 1 champagne on arrival. All flagged to respective departments at 6:00 AM.
| Outlet | Meal Period | Checks | Avg Check | Food Rev | Bev Rev | Total |
|---|---|---|---|---|---|---|
| The Prime Steakhouse | Dinner | 47 | $651 | $18,160 | $5,920 | $30,582 |
| The Prime Steakhouse | Lunch | 2 | $695 | $901 | $193 | $1,390 |
| The Prime Steakhouse Total | $31,972 | |||||
| The Catch Seafood Bar | Dinner | 28 | $454 | $7,388 | $2,628 | $12,720 |
| The Catch Seafood Bar | Lunch | 26 | $388 | $5,052 | $2,894 | $10,091 |
| The Catch Seafood Bar | Brunch | 16 | $432 | $3,815 | $1,631 | $6,917 |
| Seafood Bar Total | $29,728 | |||||
| The Sunset Bar | Bar | 67 | $174 | $705 | $8,472 | $11,654 |
| Highest volume outlet • 73% beverage | ||||||
| The Terrace Kitchen | Afternoon Tea | 16 | $330 | $2,892 | $1,266 | $5,281 |
| The Terrace Kitchen | Dinner | 10 | $325 | $1,594 | $967 | $3,252 |
| The Terrace Kitchen | Breakfast | 11 | $235 | $1,590 | $443 | $2,583 |
| The Terrace Kitchen | Lunch | 7 | $276 | $1,006 | $514 | $1,931 |
| The Terrace Kitchen | Brunch | 5 | $303 | $972 | $219 | $1,514 |
| The Terrace Kitchen Total | $14,561 | |||||
Insights: The Sunset Bar drove 67 checks (highest volume) but only $174 avg check — opportunity for premium cocktail menu or food pairings. The Terrace Kitchen Afternoon Tea ($330 avg) outperforms The Terrace Kitchen Dinner ($325) — consider expanding afternoon tea capacity on weekends. The Prime Steakhouse dinner was Saturday’s star: 47 covers at $651/check.
Golf — By the Numbers
| Service | Rounds | Avg Green Fee | Total Revenue | Pre-Booked |
|---|---|---|---|---|
| Golf Rounds | 35 | $346 | $36,733 | 100% pre-booked |
Spa — By Service Category
| Service | Appointments | Avg Price | Total Revenue |
|---|---|---|---|
| Massage | 18 | $279 | $8,337 |
| Facial | 10 | $237 | $3,910 |
| Body Treatment | 9 | $242 | $3,436 |
| Nail & Beauty | 10 | $129 | $2,618 |
Opportunity: 36% of spa visits yesterday were walk-ins. Pre-booked guests spend marginally more per visit, but the real win is capturing demand before arrival. 62 guests arriving today — pre-arrival spa emails already triggered. Historical data shows this converts 22% of arrivals to pre-booked spa visits. Projected additional revenue: $5,300+ this week.
Cancellation Reasons Breakdown
| Reason | Count | Revenue Impact | Preventable? |
|---|---|---|---|
| Family emergency | 14 | $14,200+ | No |
| Found lower rate elsewhere | 10 | $9,800+ | YES — Rate parity fix |
| Weather / hurricane concern | 10 | $10,100+ | Partially — weather guarantee |
| Work conflict | 9 | $7,600+ | No |
| No reason provided | 9 | $7,900+ | Maybe — follow up survey |
| Guest request — travel plans changed | 6 | $5,200+ | No |
| Medical emergency | 5 | $4,800+ | No |
| Duplicate reservation | 5 | $4,500+ | YES — Booking dedup |
High-Value No-Shows (Revenue Lost)
| Guest | Room | Rate | Source | Booked In Advance | Folio Lost |
|---|---|---|---|---|---|
| Stephen Evans | Exec Suite Ocean | $1,501 | Direct Phone | 64 days | $1,501 |
| Amanda Anderson | Ocean View Double | $1,144 | Expedia | 9 days | $1,144 |
| Jessica Nelson | Ocean View King | $813 | Hotels.com | 2 days | $813 |
| Andrew Powell | Garden View Double | $707 | Direct Web | 20 days | $707 |
| Mia Harris | Garden View King | $664 | Direct Web | 72 days | $664 |
| Sandra Henderson | Garden View King | $589 | Expedia | 56 days | $589 |
| Catherine Hughes | Pool View King | $563 | Direct Phone | 22 days | $563 |
Pattern Alert: OTA bookings with <10 days advance booking and no special requests have a 3.4x higher no-show rate. SixAM Pulse auto-triggers confirmation sequences 72 hours before arrival for these high-risk bookings. 15 of this week’s 21 no-shows had this exact pattern.
Today’s VIP Arrivals — Requiring Personal Attention
Without SixAM Pulse: Your front desk discovers Michelle Torres’s anniversary when she mentions it at check-in. Too late for a personal touch. With SixAM Pulse, you knew at 6 AM and the champagne is already chilling.
Revenue Alerts — Issues Requiring Your Attention
Expedia: 373 bookings, $1.88M room rev, avg $1,069/nt
Booking.com: 215 bookings, $1.07M room rev, avg $1,050/nt
Hotels.com: 129 bookings, $673K room rev, avg $1,084/nt
Total OTA: 717 bookings at 15–20% = $539K–$719K annual commission. Direct avg rate: $1,026 (lower!). Guests pay more on OTAs.
Direct Web: 15 no-shows (2.7% of 564 bookings)
Expedia: 13 no-shows (3.5% of 373 bookings)
Direct Phone: 12 no-shows (3.7% of 321 bookings)
Booking.com: 8 no-shows (3.7% of 215 bookings)
Hotels.com: 7 no-shows (5.4% of 129 bookings — worst rate)
OTA no-show rate: 3.9% vs Direct: 3.0%. Auto-confirmation triggered for 14 high-risk bookings this week.
Coastal Bay Pro Shop: $9,492 (golf bags, irons leading)
Ocean Gallery: $8,085 (sculpture $3.5K, oil paintings $3.3K)
The Grand Resort Boutique: $7,337 (sunglasses $1.9K, resort wear $1.1K)
No VIP-targeted messaging today. Opportunity: personalized boutique recommendations for incoming Diamond/Platinum guests.
F&B Performance — Yesterday Across All Outlets
Dinner: $651 avg • Lunch: $695 avg
Food: $19,061 • Bev: $6,113
▲ Saturday peak — highest revenue day
Dinner: $454 avg • Brunch: $432 avg
Food: $16,255 • Bev: $7,153
▲ Brunch driving strong bev sales
73% beverage • $8,472 cocktails
Food: $705 only
⚠ Low food attach rate — opportunity
Afternoon Tea: $330 avg (16 checks)
Breakfast: $235 avg • Dinner: $325 avg
▲ Most versatile outlet
Insights: The Sunset Bar food attach rate is only 6% of revenue — a bar snack menu or food pairing promotion could add $2K+/night. The Terrace Kitchen Afternoon Tea at $330/check rivals dinner pricing — consider expanding weekend capacity. Today’s 62 arrivals include 11 VIPs who historically spend 22% more on dining. Reserved tables at The Prime Steakhouse for VIP arrivals checking in before 5 PM.
This Is What You’re Missing Every Day
OTA commissions, cancellations, no-shows, and missed upsell — hiding in your data right now
Pulling reports from PMS, POS, spa booking, and retail systems. Before the first guest complaint.
$440K+ in annual value delivered for less than the cost of 5 room-nights per month
| Category | Annual Impact | How It’s Calculated | SixAM Pulse Fix |
|---|---|---|---|
| OTA Commission Bleed | $539K–$719K | 717 OTA bookings × avg $3,590 folio × 15–20% × annualized | Direct booking incentive engine |
| Cancellation Revenue Loss | $480K–$600K | 183 cancellations/period × avg $941/nt × annualized | Predictive risk scoring + pre-emptive outreach |
| No-Show Revenue Loss | $340K–$420K | 65 no-shows/period × avg $849/nt × annualized | Auto-confirmation sequences 72hr prior |
| Rate Parity Leakage | $180K–$240K | $43/night gap × affected room nights × annualized | Real-time rate parity monitoring & alerts |
| Missed Spa Pre-Book Uplift | $150K–$200K | 22% walk-in rate × 109% spend premium × annualized | Pre-arrival spa email campaigns |
| TOTAL | $1.7M–$2.2M | Conservative estimate from 35 days of actual data, annualized | |
| Task | System | Time | With SixAM Pulse |
|---|---|---|---|
| Pull occupancy & revenue report | Microsoft Dynamics | 8 min | Automated |
| Review VIP arrivals & special requests | Salesforce CRM | 6 min | Automated + action items |
| Check rate parity across OTAs | Channel Manager / Manual | 10 min | Real-time alerts |
| Pull F&B outlet reports | OpenTable + POS | 7 min | Automated |
| Check spa & golf bookings | Spa System / Tee Sheet | 5 min | Automated |
| Cross-reference VIP dining preferences | Salesforce + OpenTable | 6 min | Automated with alerts to F&B |
| Compile & email summary to leadership | Tableau + Excel + Email | 8 min | Auto-delivered at 6 AM |
| TOTAL | ~50 min | 0 min |
And that’s just the morning. Rate parity checks, mid-day revenue pivots, evening VIP prep, and weekly reporting add another 3–4 hours per week. The brief replaces all of it, automatically, with better data than any manual process could produce.
| Value Driver | Conservative Annual Savings | Assumption |
|---|---|---|
| OTA → Direct Shift (5%) | $54,000–$72,000 | Shift 36 bookings/period to direct, eliminate 15–20% commission |
| Cancellation Reduction (10%) | $48,000–$60,000 | Rate parity fixes + proactive outreach prevent 18 cancellations/period |
| No-Show Reduction (20%) | $68,000–$84,000 | Auto-confirmation cuts 13 no-shows/period, mostly OTA last-minute |
| Spa Pre-Booking Uplift | $150,000 | Convert 22% walk-ins to pre-booked at 109% premium |
| Staff Time Savings | $52,000 | 50 min/day × 365 days × $30/hr loaded labor cost |
| TOTAL VALUE | $440,000+ | Conservative — does not include VIP retention, RevPAR lift, or compounding |
Put it this way: SixAM Pulse costs less than 5 room-nights per month at your average rate. It pays for itself if it saves just 3 cancellations and 2 OTA-to-direct conversions per month. Everything else is pure upside. Founding customers lock in $2,500/month for the first 12 months.
Two Ways to Run Tomorrow Morning
Without SixAM Pulse
With SixAM Pulse
Your Data Already Has the Answers
Ask Anything. Instantly.
No more pulling reports from four different systems. Just ask A.R.I.A. — it already knows.