FY2026 Board Pack — Revenue Analysis
Purpose
Build a Budget vs Actuals revenue comparison for the March 2026 board pack, and create a clean structured budget table for ongoing use.
Status
🟡 In progress — 2026 budget figures not yet populated
Key Output Files
All in C:\Users\DamienGoBeyond\Claude\workspace\:
| File | Description | Status |
|---|---|---|
State of Play (March 2026).xlsx | Main board pack file — Revenue tab added with Q1 Budget vs Actuals | ✅ Done (pending 2026 budget fix) |
Revenue_Budget_Table.xlsx | Structured flat table: Agent × BusinessType × Country × Year × Month × Amount | 🟡 2025 populated; 2026 blank |
GB_Board_Pack_Mar2026.pptx | March 2026 board pack presentation | Reference only |
2026 Budget.xlsx | Source budget file (Downloads folder, 60MB) | Reference only |
Revenue Tab Structure (State of Play)
Columns: Account | Country | Jan–Mar Actuals | Q1 Actual | Jan–Mar Budget | Q1 Budget | Q1 Var $ | Var %
Sections:
- Kilroy International A/S (covers Jysk + Kilroy programmes combined) — 8 countries
- World Insight ErlebnisReisen — Thailand
- Explore Worldwide Limited — Thailand
- Travel Center & Direct (Thailand National + Vietnam National GL accounts)
Revenue_Budget_Table Structure
- Columns: Agent, BusinessType, Country, Year, Month, Amount
- 31 agent×type×country combos × 12 months × 2 years = 744 rows
- 2025: populated from Rev26 U2:AH35 (combined FIT+Groups per agent/country; sits in B2B FIT rows)
- 2026: blank — next step is to identify correct budget sheet and populate
Next Steps
- Open
2026 Budget.xlsx, identify which sheet has clean 2026 monthly budget figures by agent/country - Populate the 2026 rows in
Revenue_Budget_Table.xlsx - Consider whether to split FIT vs Groups for Jysk/Kilroy (requires Rev25Detail-style breakdown)
- Update Revenue tab in State of Play with corrected 2026 budget figures
Q1 2026 Key Variances (Budget vs Actuals)
See 2026-05-15-board-pack-budget-analysis for full detail.
Positives: Explore +138%, Travel Center TH +141%, Sri Lanka +58%, Laos +181%, World Insight +21% Negatives: India -4% (minor) On budget: Thailand +7%, Vietnam +7%, Nepal +2%