Reporting & BI

Reports

Laporan operasional lintas-modul dan Analytics & Marketing ROI — dalam satu menu.

Operasional

Filter

Berlaku untuk seluruh section berbasis Project di bawah (Sales Pipeline dan SLA/Quotation Performance tidak terpengaruh).

Sales Pipeline

Seluruh Lead ber-deal dikelompokkan per status approval Quotation, lintas party (tidak terpengaruh filter project).

Open Leads (Quotation)

4

Nilai Pipeline Terbuka

Rp 360.000.000

Win Rate

50%

4 Won / 8 Deal

  • Draft2 · Rp 120.000.000
  • Menunggu Approval1 · Rp 180.000.000
  • Disetujui5 · Rp 1.960.000.000

Project Performance

Ringkasan status dan karakteristik project sesuai filter aktif.

Active Projects

7

Completed

1

On Hold

0

Rata-rata Traveler

24

Berdasarkan Status

  • Draft1
  • Planning2
  • Confirmed2
  • In Progress1
  • Ongoing Trip1
  • Completed1

Berdasarkan Tipe

  • Normal Project4
  • High-Change Project3
  • Complex Project1

Upcoming Departure dan Service Readiness

Keberangkatan dalam 30 hari ke depan dan status kesiapan layanan sesuai filter aktif.

Upcoming Departures

Service Readiness

  • Pending Confirmation3
  • Confirmed10
  • Changed2
  • Completed1
  • Cancelled1

Vendor Summary

Status quotation vendor dan committed cost sesuai filter project aktif.

Vendor Aktif

3

Committed Vendor Cost

Rp 1.365.000.000

Total Quotation

10

Status Quotation

  • Diajukan3
  • Diterima6
  • Ditolak1

Top Vendor (Committed Cost)

VendorCommitted CostPenugasan
CV Tiket Mitra NusantaraRp 545.000.0003
Hotel Prima MitraRp 540.000.0002
Cendana MICE OrganizerRp 280.000.0001

Budget vs Actual dan Margin

Agregat lintas project sesuai filter aktif (project berstatus Cancelled dikecualikan).

Budget

Rp 3.475.000.000

Actual Cost

Rp 51.450.000

Variance

Rp 3.423.550.000

Nilai Quotation

Rp 3.825.000.000

Margin

Rp 3.773.550.000

Total Budget vs Actual

Rp 51.450.000↓ 98.5% vs budget

Manila Business Trip

0%
Actual Rp 0Budget Rp85 jt

Abu Dhabi Corporate Gathering

15%
Actual Rp46,8 jtBudget Rp310 jt

Palu MICE Conference 2026

0%
Actual Rp4,7 jtBudget Rp1,3 M

Manila Follow-up Training Q1 2027

0%
Actual Rp 0Budget Rp60 jt

Korea Incentive Trip 2026

0%
Actual Rp 0Budget Rp900 jt

Abu Dhabi Business Delegation

0%
Actual Rp 0Budget Rp420 jt

Manila Corporate Meeting 2026

0%
Actual Rp 0Budget Rp150 jt

Singapore Conference 2026

0%
Actual Rp 0Budget Rp300 jt

Invoice Aging dan Outstanding

Invoice belum lunas lintas project sesuai filter aktif, diurutkan dari yang paling overdue. Klik baris untuk membuka tab Finance pada Project terkait.

Total Outstanding

Rp 1.135.000.000

Invoice Overdue

2

  • Belum Jatuh Tempo4
  • Overdue 1–30 Hari2
InvoiceProjectOutstandingJatuh TempoAging
Invoice Abu Dhabi (Termin Awal)Abu Dhabi Corporate GatheringRp 60.000.0001 Jul 202628 hari overdue
Invoice Tambahan (Perubahan Kamar & Traveler)Abu Dhabi Corporate GatheringRp 35.000.00020 Jul 20269 hari overdue
Invoice Palu MICE (Termin 2)Palu MICE Conference 2026Rp 700.000.0005 Agt 2026Jatuh tempo dalam 7 hari
Invoice Singapore Conference (Termin Awal)Singapore Conference 2026Rp 75.000.0005 Agt 2026Jatuh tempo dalam 7 hari
Invoice Korea Incentive Trip (Termin Awal)Korea Incentive Trip 2026Rp 245.000.00015 Agt 2026Jatuh tempo dalam 17 hari
Invoice DP Manila Follow-up Training (USD)Manila Follow-up Training Q1 2027Rp 20.000.00020 Agt 2026Jatuh tempo dalam 22 hari

SLA dan Quotation Performance

Cycle time Lead Qualified → Quotation Dibuat, lintas party (domain Lead/Quotation, tidak terpengaruh filter project di atas).

Rata-rata Cycle Time

9.4 hari

Dalam Threshold SLA

38%

Threshold mock: 3 hari

Quotation Terkirim ke Client

1

dari 8 quotation

Threshold SLA 3 hari adalah asumsi mock untuk demo, bukan SLA kontraktual nyata dengan client. "Approval cycle time" (Wajib literal Section 22) tidak dapat dihitung — Quotation tidak menyimpan timestamp approvedAt (hanya approvedBy/approvalNote), lihat known issues.

LeadQuotationLead QualifiedQuotation DibuatCycle TimeSLA
Palu MICE Conference 2026QUO-00315 Mei 20265 Jun 202621 hari Melebihi SLA
Abu Dhabi Corporate GatheringQUO-0021 Jun 202620 Jun 202619 hari Melebihi SLA
Manila Business Trip Q3 2026QUO-00110 Jun 202625 Jun 202615 hari Melebihi SLA
Bali Team Building 2026QUO-0055 Jul 202618 Jul 202613 hari Melebihi SLA
Manila Repeat Business Q4 2026QUO-00615 Jul 202622 Jul 20267 hari Melebihi SLA
Jakarta Incentive TripQUO-00415 Jun 202615 Jun 20260 hari Dalam SLA
Manila Follow-up Training Q1 2027QUO-00815 Jul 202615 Jul 20260 hari Dalam SLA
Surabaya Regional Sales Meeting 2027QUO-01027 Jul 202627 Jul 20260 hari Dalam SLA

Analytics & Marketing ROI

Revenue Periode Terakhir

Rp 490.000.000

Laba Bersih

Rp 485.350.000

Marketing ROI

481%

Margin Rata-rata Trip

98.3%

Revenue & Profitabilitas per Periode

  • 2026-06Rp 1.270.000.000Rp 747.200.000

    Biaya langsung Rp 0 · Opex Rp 522.800.000 · Diterima Rp 865.000.000

  • 2026-07Rp 1.365.000.000Rp 784.400.000

    Biaya langsung Rp 23.000.000 · Opex Rp 557.600.000 · Diterima Rp 805.000.000

  • 2026-08Rp 490.000.000Rp 485.350.000

    Biaya langsung Rp 4.650.000 · Opex Rp 0 · Diterima Rp 320.000.000

Batang atas = pendapatan, batang bawah = total biaya (langsung + opex). Angka opex bersumber dari modul Finance & ACC, bukan dihitung ulang di sini.

Cost per Trip

Biaya nyata per project dan per traveler, beserta marginnya.

Project Biaya Per Traveler Margin
Manila Business Trip

PT Cipta Distribusi Nusantara · 6 pax

Rp 0Rp 0100.0%

Rp 95.000.000

Manila Follow-up Training Q1 2027

PT Cipta Distribusi Nusantara · 8 pax

Rp 0Rp 0100.0%

Rp 60.000.000

Korea Incentive Trip 2026

PT Java Bhakti Persada · 45 pax

Rp 0Rp 0100.0%

Rp 980.000.000

Abu Dhabi Business Delegation

PT Java Bhakti Persada · 24 pax

Rp 0Rp 0100.0%

Rp 460.000.000

Manila Corporate Meeting 2026

PT Java Bhakti Persada · 12 pax

Rp 0Rp 0100.0%

Rp 165.000.000

Singapore Conference 2026

PT Java Bhakti Persada · 15 pax

Rp 0Rp 0100.0%

Rp 320.000.000

Palu MICE Conference 2026

PT Sinergi Korporindo · 60 pax

Rp 4.650.000Rp 77.50099.7%

Rp 1.395.350.000

Abu Dhabi Corporate Gathering

PT Alam Raya Group · 18 pax

Rp 46.800.000Rp 2.600.00086.4%

Rp 298.200.000

Vendor Performance

Konsentrasi belanja dan cakupan project per vendor.

Marketing ROI

Satu perhitungan bersama dengan modul Marketing — bukan angka paralel.

Total Belanja

Rp 267.600.000

Revenue Teratribusi

Rp 1.555.000.000

ROAS

5.81×

Rata-rata CAC

Rp 16.975.000

LTV : CAC

12.0×

  • Corporate Retreat Season 202612.5×Rp 1.555.000.000
  • MICE Nusantara Expo—Rp 0
  • Referral Booster Q3—Rp 0
  • TikTok Travel Story—Rp 0

Akuisisi per Channel

Channel Lead Belanja CAC
Website6Rp 38.500.000Rp 19.250.000
Referral6Rp 29.400.000Rp 14.700.000
Instagram1Rp 71.300.000—
TikTok1Rp 19.600.000—
WhatsApp1Rp 6.000.000—
Event1Rp 78.800.000—
Email1Rp 24.000.000—

Operasional & Sumber Daya

Aset Dipakai

6 / 16

Maintenance Terlewat

3

Kontributor Revenue Teratas

  • Doni Saputra8 projectRp 3.825.000.000
  • Rani Kusuma0 projectRp 0
  • Galih Ramadhan0 projectRp 0
  • Fitri Handayani0 projectRp 0
  • Fajar Nugroho0 projectRp 0