Room Availability Report

Internal report untuk Reservation Agent / Front Desk — "kamar mana yang bisa saya jual untuk tanggal X tipe Y". Berbeda dari Overbooking (focus area kritis) atau Forecast (focus revenue projection).

Path menu: Laporan → Reservasi → Room Availability (/reports/room-availability)

Konsep

Per (tanggal × tipe kamar):

Capacity        = COUNT(rooms is_active=true) di tipe tsb
Sold            = COUNT(reservations confirmed/checked_in covering tanggal)
Available       = Capacity − Sold (forward-looking)
Blocked Today   = (snapshot only) rooms dgn status maintenance/blocked saat ini

Filter

• Periode — default today → today+30 (forward-looking)
• Tipe Kamar (single, untuk drill-down)

Output

4 Summary Cards

• Periode — date range + jumlah kamar aktif
• Total Capacity Nights — capacity × jumlah hari
• Total Available Nights — sum available
• Overall Occupancy % — sold / capacity

Per Tipe Kamar Snapshot

Tabel: Tipe Kamar, Capacity, Blocked Today, Available Today, Avg Available Periode, Min Available, Peak Demand Date, Base Rate.

Daily Matrix

Grid harian × tipe kamar. Setiap cell:

• Available count (large)
• Status badge: Tersedia / Hampir Habis (≤2) / FULL / Hari Ini / Realisasi (past)
• Sticky first column untuk scroll horizontal

Use Case

• Reservation agent lookup tool — saat tamu telepon, agent buka report ini, jawab "Untuk 25 Mei, Suite tersedia 3 kamar"
• FD walk-in handling — kalau kamar tipe tertentu full, tawarkan upgrade ke tipe yang available
• Peak demand identification — Min Available + Peak Date → forewarning kapan minggu padat

Excel Export

Tombol Export Excel generate file dengan:

• Daily matrix lengkap
• Summary statistics
• Filter applied tertulis di header

Tips

• Forward-looking — tidak include OOO snapshot future (status maintenance future bisa berubah)
• Same logic dengan Forecast Report tapi presentation-nya operational (bukan revenue)
• Pair dengan Calendar Reservasi Date Matrix mode untuk visualisasi sama tapi clickable