Spreadsheet 1 [PDF]

Citation preview

Laporan Keuangan Penginapan Hotel Internasional Kode Kamar EXC-1 EKO-2 LUX-1 EKO-2 LUX-2 EXC-1 EKO-1 EXC-2 LUX-1



Nama Tamu Wagiman Supardi Nursalim Dodot Didit Tami Tarmizin Darindi Ivan



Tabel Data Kode Kamar



Kelas Kamar Eksekutif Ekonomi Mewah Ekonomi Mewah Eksekutif Ekonomi Eksekutif Mewah



Tarif/hari Single



EKO EXC LUX



Tarif/hari (Rp) Rp Rp Rp Rp Rp Rp Rp Rp Rp



Tarif/hari Double



300,000 550,000 800,000



Tanggal Datang



550,000 400,000 800,000 400,000 900,000 550,000 300,000 650,000 800,000



4-Jan-07 4-Feb-07 2-Feb-07 2-Jan-07 2-Jan-07 5-Jan-07 5-Jan-07 1-Feb-07 20-Jan-07



Kelas Kamar



400,000 Ekonomi 650,000 Eksekutif 900,000 Mewah



Total Pendapatan Berdasarkan Kelas Kamar Rp12,000,000 Rp10,000,000 Rp8,000,000 Rp6,000,000 Rp4,000,000 Rp2,000,000 Rpf uti k se Ek



om on k E



i ew M



ah



om on k E



i ew M



ah



f i uti om ek n s o Ek Ek



tif ku e s Ek



ew M



ah



Tanggal Pergi 10-Jan-07 8-Feb-07 15-Feb-07 5-Jan-07 8-Jan-07 10-Jan-07 16-Jan-07 3-Feb-07 23-Jan-07



Keuangan Penginapan el Internasional Lama Nginap 6 hari 4 hari 13 hari 3 hari 6 hari 5 hari 11 hari 2 hari 3 hari



Tagihan Rp Rp Rp Rp Rp Rp Rp Rp Rp



3,300,000 1,600,000 10,400,000 1,200,000 5,400,000 2,750,000 3,300,000 1,300,000 2,400,000



Pajak Rp Rp Rp Rp Rp Rp Rp Rp Rp



165,000 160,000 520,000 120,000 540,000 137,500 165,000 130,000 120,000



Potongan Rp Rp Rp Rp Rp Rp Rp Rp Rp



99,000 520,000 162,000 165,000 -



Total Bayar Rp Rp Rp Rp Rp Rp Rp Rp Rp



3,366,000 1,760,000 10,400,000 1,320,000 5,778,000 2,887,500 3,300,000 1,430,000 2,520,000