Variance & Root-Cause Analysis
Revenue moved - variance analysis splits the movement into rate, volume and mix, then names the driver behind each piece.
call_splitDecomposing the Gap
Actuals minus budget is the headline: revenue missed by 30,000, or beat forecast by 12. As a single number it is inert - it cannot be managed because it has no parts.
Advanced reporting decomposes it. How much came from rate - the ADR variance? How much from volume - the room nights sold? How much from mix - the shift in segment and channel composition? And how much from the calendar and events - the fair that landed last year but not this one?
Each component has a different owner and a different fix. Rate is a pricing conversation, volume is a demand-generation conversation, mix is a strategy conversation. Treating the gap as one number hides all of them.
compareHeadline vs Decomposed Variance
The same month, told two ways. One version ends the conversation; the other starts it.
looks_oneHeadline Variance
Revenue missed by 30,000. Explained with a shrug - and a promise to try harder next month.
stacked_bar_chartDecomposed Variance
45,000 negative from the corporate wash, 20,000 positive from leisure rate, 5,000 negative from OTA mix shift. Explained with a plan.
checklistSix Analysis Steps
1. Set the Bridge
Frame actual minus budget minus forecast on one page - the gap everyone will now see decomposed.
2. Split Rate and Volume
The first decomposition: how much of the gap is price effect and how much is quantity effect.
3. Layer the Mix
Segment and channel composition shifts quantified - what the change in blend was worth.
4. Isolate Events
One-off causes separated from run-rate causes so the baseline stays honest.
5. Name the Driver
Each component traced to a decision, a market shift or an execution miss.
6. Assign the Response
The follow-up action and its owner attached to each driver - analysis that lands somewhere.
troubleshootDiagnosis, Not Blame
A decomposed variance is not an indictment - it is a map. It shows where performance actually came from, which pieces were controllable, and which hidden wins deserve to be protected and repeated.
Variance Is a Story, Not a Verdict: the purpose is diagnosis, not blame. A decomposed miss often contains a hidden win - that strong leisure rate - beside the visible loss. Report the components honestly and the conversation moves from excuses to adjustments.
translatePenjelasan dalam Bahasa Indonesiaexpand_more
Variance analysis adalah teknik membedah selisih aktual terhadap budget atau forecast menjadi komponen rate, volume, mix, dan kalender, lalu menamai driver di balik tiap komponen. Angka tunggal seperti revenue miss 30.000 tidak bisa dikelola karena tidak punya bagian; dekomposisi menjadikannya peta, bukan vonis.
- check_circleBridge: actual minus budget minus forecast di satu halaman, gap yang sama dipecah di depan semua orang.
- check_circleDekomposisi pertama: berapa efek harga (rate) dan berapa efek kuantitas (room nights terjual).
- check_circleContoh: miss 30.000 terurai menjadi minus 45.000 corporate wash, plus 20.000 leisure rate, minus 5.000 OTA mix.
- check_circleIsolate events memisahkan penyebab sekali-terjadi dari run-rate agar baseline tetap jujur.
- check_circleSetiap komponen punya pemilik dan solusi berbeda: rate bicara pricing, volume bicara demand generation, mix bicara strategi.
- check_circleEnam langkah: set the bridge, split rate-volume, layer mix, isolate events, name the driver, assign the response.
helpPertanyaan Umum (FAQ)
Apa itu variance analysis dalam revenue management?
Variance analysis membedah selisih revenue aktual terhadap budget atau forecast menjadi komponen rate, volume, mix, dan kalender atau event. Tujuannya bukan vonis melainkan peta: menunjukkan dari mana kinerja berasal, mana yang bisa dikendalikan, dan kemenangan tersembunyi mana yang patut dilindungi.
Bagaimana cara membedah gap revenue antara actual dan budget?
Bangun bridge di satu halaman, lalu pisahkan berapa gap dari ADR (efek harga), berapa dari room nights (efek volume), berapa dari pergeseran komposisi segment dan channel (mix), dan berapa dari kalender event. Contoh: miss 30.000 bisa terurai menjadi 45.000 negatif dari corporate wash, 20.000 positif dari leisure rate, dan 5.000 negatif dari mix OTA.
Mengapa headline variance saja tidak cukup?
Karena selisih tunggal tidak punya bagian sehingga tidak bisa dikelola, hanya bisa dijawab dengan janji mencoba lebih keras. Variance yang terurai berakhir dengan rencana: tiap komponen menunjuk ke pemilik, percakapan, dan solusi yang berbeda.
Mengapa event harus diisolasi dari penyebab run-rate?
Karena bila penyebab sekali-terjadi seperti pameran yang hanya ada tahun lalu tidak dipisahkan, baseline kinerja normal menjadi tidak jujur dan perbandingan periode menyesatkan. Isolasi event menjaga run-rate tetap jujur sehingga keputusan berbasis tren tidak salah arah.