forecasting-budgetinglisted
Install: claude install-skill hospitalityos/hotel-ai-skills
# HospitalityOS™ Hotel Intelligence Suite
## Forecasting & Budgeting Skill
**Professional hotel revenue and expense forecasting — combining historical performance, market assumptions, and booking pace to deliver monthly reforecasts, rolling 90-day projections, and annual budgets with full variance decomposition.**
---
## Data Acquisition
Reference `../DATA_ACQUISITION_PROTOCOL.md` for the complete tiered approach. This skill needs:
**Essential Data:**
- 12–24 months historical P&L by department (Rooms, F&B, Other)
- Group pace report (definite + tentative blocks, decision dates, lead time)
- Transient booking curve (week-by-week pickup from previous years)
- Confirmed room disruptions (renovations, closure dates) and planned events
- Payroll / labor hour allocation by department
- Current-year budget assumptions (market ADR, mix, occupancy targets)
- Seasonal patterns and outlier events (e.g., natural disaster, brand conversion)
**Tier 1 (Direct API):**
- **Gmail** → Pull accounting emails with P&L attachments, budget uploads, variance reports
- **Google Drive** → Access shared budget models, departmental templates, seasonal assumptions
- **Google Sheets** → Live labor trackers, booking curve data, event calendars
**Tier 2 (Browser Pull):**
- **M3 / ProfitSword** → Income Statement, Budget vs Actual, department-level P&L
- **Delphi / Amadeus** → Group pace report, pipeline by decision date, tentative blocks
- **Opera / Mews PMS** → Forecast report, booking pickup, room