Scribd Logo
Upload

Welcome to Scribd!

  • 88 views

    Pongel Keren

    Uploaded by

    pongelkeren
    The document is a report listing guest information and flight data from Hotel Lare Kula. It includes a table with guest names, room codes, room types, length of stay, and room rates. A second table lists room types and rates. A third section provides flight codes, departure/arrival times, destinations, flight types, ticket prices, taxes, and agency fees. Flight passenger numbers and average are reported. A final table lists flight numbers, departure times, destinations, ticket prices, and bonus for each flight. Total passenger numbers and revenues are calculated.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as ODS or read online from Scribd

    Pongel Keren

    Uploaded by

    pongelkeren
    88 views4 pages
    The document is a report listing guest information and flight data from Hotel Lare Kula. It includes a table with guest names, room codes, room types, length of stay, and room rates. A second table lists room types and rates. A third section provides flight codes, departure/arrival times, destinations, flight types, ticket prices, taxes, and agency fees. Flight passenger numbers and average are reported. A final table lists flight numbers, departure times, destinations, ticket prices, and bonus for each flight. Total passenger numbers and revenues are calculated.

    Copyright

    © Attribution Non-Commercial (BY-NC)

    Available Formats

    ODS or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document is a report listing guest information and flight data from Hotel Lare Kula. It includes a table with guest names, room codes, room types, length of stay, and room rates. A second table lists room types and rates. A third section provides flight codes, departure/arrival times, destinations, flight types, ticket prices, taxes, and agency fees. Flight passenger numbers and average are reported. A final table lists flight numbers, departure times, destinations, ticket prices, and bonus for each flight. Total passenger numbers and revenues are calculated.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as ODS or read online from Scribd
    Download as ods
    88 views4 pages

    Pongel Keren

    Uploaded by

    pongelkeren
    The document is a report listing guest information and flight data from Hotel Lare Kula. It includes a table with guest names, room codes, room types, length of stay, and room rates. A second table lists room types and rates. A third section provides flight codes, departure/arrival times, destinations, flight types, ticket prices, taxes, and agency fees. Flight passenger numbers and average are reported. A final table lists flight numbers, departure times, destinations, ticket prices, and bonus for each flight. Total passenger numbers and revenues are calculated.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as ODS or read online from Scribd
    Download as ods
    of 4

    Sheet1

    HOTEL “LARE – KULA”


    LAPORAN DAFTAR TAMU

    KODE NAMA TYPE LAMA TARIP


    NAMA TAMU KODE TYPE
    KAMAR KAMAR KAMAR TINGGAL KAMAR
    Tamara Blezenski S0011 Suite S Single 3 27,000.00
    Primus Yustisio P0021 President S Single 6 56,000.00
    Yusroni S0011 Suite D Double 2 27,000.00
    Muhammad Liem P0021 President F Fmily 7 56,000.00
    Soetrisno Bachir E0051 Executive F Fmily 3 275,000.00
    Tifatul Sembiring B0041 Bussines SP Special 12 250,000.00
    Zainuddin MZ T0031 Top Room S Single 7 300,000.00
    Ahmad Dhani T0031 Top Room F Fmily 9 300,000.00
    Din Syamsudin E0051 Executive D Double 2 275,000.00
    Wanda Hamidah E0051 Executive S Single 6 275,000.00
    Harley Davidson P0021 President D Double 3 56,000.00
    Alvi Lie S0011 Suite D Double 5 27,000.00
    Hidayat Nurwahid B0041 Bussines S Single 8 250,000.00
    Hatta Rajasa E0051 Executive SP Special 1 275,000.00
    Chinta Laura B0041 Bussines F Fmily 2 250,000.00
    Rata – Rata Lama Tinggal 5 TOTAL

    TABEL TAMU
    NAMA TARIP
    KODE KAMAR
    KAMAR KAMAR
    S0011 Suite 27,000
    P0021 President 56,000
    T0031 Top Room 300,000
    B0041 Bussines 250,000
    E0051 Executive 275,000

    Page 1
    Sheet1
    – KULA”
    TAR TAMU

    JUMLAH TOTAL HADIAH


    DISC.
    PEMBAYARAN PEMBAYARAN LANGSUNG
    81,000.00 8100 72,900.00 T-Shirt
    336,000.00 33600 302,400.00 T-Shirt
    54,000.00 5400 48,600.00 T-Shirt
    392,000.00 39200 352,800.00 T-Shirt
    825,000.00 123750 701,250.00 Jam Tangan
    3,000,000.00 600000 2,400,000.00 Televisi
    2,100,000.00 420000 1,680,000.00 Televisi
    2,700,000.00 540000 2,160,000.00 Televisi
    550,000.00 82500 467,500.00 T-Shirt
    1,650,000.00 330000 1,320,000.00 Televisi
    168,000.00 16800 151,200.00 T-Shirt
    135,000.00 13500 121,500.00 T-Shirt
    2,000,000.00 400000 1,600,000.00 Televisi
    275,000.00 27500 247,500.00 T-Shirt
    500,000.00 75000 425,000.00 T-Shirt
    14766000 2715350 12050650 Pongel
    www.pongel.co.cc

    Page 2
    Sheet2

    Philiphines Airways National


    Arus Penerbangan
    KODE BERANGKAT FLIGHT HARGA PSC
    NO TUJUAN KE PAJAK
    PENERBANGAN DATANG TYPE TIKET AGEN
    1 PAN219DC9 09.00-04.00 MEDAN DC-9 $ 80.00 $ 8.00 $ 1.60
    2 PAN660AB3 06.00-08.45 DENPASAR AIRBUS3 $ 115.00 $ 11.50 $ 4.60
    3 PAN898747 19.15-22.00 DENPASAR BOING747 $ 115.00 $ 11.50 $ 4.60
    4 PAN874D10 06.00-08.45 DENPASAR DC-10 $ 115.00 $ 11.50 $ 4.60
    5 PAN958D10 08.45-13.30 MANILA DC-10 $ 725.00 $ 72.50 $ 36.25
    6 PAN660AB3 06.00-08.45 DENPASAR AIRBUS3 $ 115.00 $ 11.50 $ 4.60
    7 PAN898747 19.15-22.00 DENPASAR BOING747 $ 115.00 $ 11.50 $ 4.60
    8 PAN878D10 06.00-08.45 DENPASAR DC-10 $ 115.00 $ 11.50 $ 4.60
    9 PAN874D10 06.00-08.45 DENPASAR DC-10 $ 115.00 $ 11.50 $ 4.60
    10 PAN972747 19.00-22.15 BANGKOK BOING747 $ 730.00 $ 73.00 $ 36.50
    11 PAN960AB3 08.45-13.30 MANILA AIRBUS3 $ 725.00 $ 72.50 $ 36.25
    12 PAN958D10 08.45-13.30 MANILA DC-10 $ 725.00 $ 72.50 $ 36.25
    Penumpang Terbanyak 204
    Penumpang Terendah 43
    Rata – Rata Penumpang 99.17

    Tabel Pesawat
    NOMOR BERANGKAT HARGA
    TUJUAN KE BONUS
    PENERBANGAN DATANG TIKET
    PAN219 09.00-04.00 MEDAN Lunch $ 80.00
    PAN430 07.10-08.00 YOGYA Snack $ 70.00
    PAN660 06.00-08.45 DENPASAR Breakfast $ 115.00
    PAN898 19.15-22.00 DENPASAR Dinners $ 115.00
    PAN874 08.45-13.30 HONGKONG Breakfast $ 675.00
    PAN958 08.45-13.30 MANILA Lunch $ 725.00
    PAN972 19.00-22.15 BANGKOK Dinners $ 730.00
    PAN878 14.30-21.45 PERT Dinners $ 1,054.00
    PAN960 17.25-20.00 SINGAPORE Dinners $ 840.00

    Page 3
    Sheet2

    nal

    JUMLAH
    TOTAL BONUS
    PENUMPANG
    85 $ 7,616.00 Lunch
    132 $ 17,305.20 Breakfast
    121 $ 15,863.10 Dinners
    99 $ 12,978.90 Breakfast
    67 $ 55,861.25 Lunch
    156 $ 20,451.60 Breakfast
    204 $ 26,744.40 Dinners
    98 $ 12,847.80 Breakfast
    56 $ 7,341.60 Breakfast
    77 $ 64,641.50 Dinners
    43 $ 35,851.25 Lunch
    52 $ 43,355.00 Lunch
    Total Pendapatan $ 320,857.60

    Page 4

    You might also like