ALV GBC
ALV
Rate Calculator
Group & Banquet Pricing Engine
Nights
—
Fetching live OTB data…
Rooms Needed
--
Rooms Needed — E21
= max(0, Target Rooms − OTB Rooms)
= max(0, Target OCC% × Inventory − Rooms OTB)
Jumlah kamar yang masih perlu diisi untuk mencapai target occupancy.
Rec. Group Rate
Rp 0
Rec. Group Rate — E30
= round(ADR Group + (1.8 × 80.000) × 1.21)
ADR Group = Rev. Needed ÷ ((Trans Rooms × ratio) + Grp Rooms)
Tambahan: CPOR markup × 1.8 × 1.21 (service + tax).
Revenue Needed
Rp 0
Revenue Needed — E19
= max(0, Target Revenue − OTB Revenue)
= max(0, Target ADR × Target Rooms − Revenue OTB)
Sisa pendapatan yang perlu dicapai untuk mencapai target.
Failed to load data
01
Group Identity
02
Accommodation Details
Total Room Revenue
Rp 0
—
03
Banquet & F&B
Follows room dates — last event day is day before checkout
Banquet Rev.
Rp 0
—
04
Additional Revenue
Total Misc Revenue
Rp 0
05
Commissions
Commission Amount
− Rp 0
of total revenue
Group Analysis
Room Dept.
Total RevenueRp 0
New ADR ImpactRp 0
New Occupancy0%
Banquet Dept.
Total RevenueRp 0
Pax Count0
Stay Nights--
Validation Checklist
Commission Below 20%
Block Below 60% Inventory
Rate vs. Guideline
Displacement: OK
Contribution: Profit
Total Contract Revenue
Rp 0
— set arrival & departure —
Cost & Yield Master
Configure GOP, Yield, and Ancillary parameters for ALV.
01GOP Cost Parameters
02Segment Share Parameters
Used by yield formula for Room Needed & Revenue Needed allocation.
03Ancillary Rates — Per Pax
From Excel breakdown: CB1, CB2, and Lunch.
04Live DB Connection
OTB Data Source
public.Segmentation_Daily_Snapshot
HOTEL_LOCATION='ALV' · GROUP1='Forecasted'
Target OCC% & ADR
stg.stg_override (subcode='ALV')
Priority: override_occ → rec_occ → 75%
Access Mode
Read-Only (SELECT only)
No writes — safe to query anytime