JSIKA Vol. 5, No. 7, Tahun 2016
ISSN 2338-137X
RANCANG BANGUN SISTEM INFORMASI ADMINISTRASI PERHOTELAN PADA NEW CAHAYA HOTEL SIDOARJO Moch.Reza Pahlevie 1) Henry Bambang 2) Yoppy Mirza M.3) Email : 1)
[email protected], 2)
[email protected], 3)
[email protected]
Abstract
New Cahaya Hotel is a company engaged in the field of tourism as an hotel in Sidoarjo. New Cahaya Hotel still using manual methods for daily administration, such as reservation, check in, check out, in house services, and making reports. This recording methods for a company that engaged in services can be not efficient, for example taking too much time to handling check in registration. It can be risky too for saving valueable informations. To overcome the problems above, researcher is designing and implementing an hotel administration information system. The result from this hotel administration system is hotel administration reporting. So, this system can overcome the company’s administration problem and give efficient and effective information. Keywords: information system, hotel administration system reporting
New Cahaya Hotel merupakan perusahaan yang bergerak dibidang perhotelan. Perusahaan yang berbasis pada bidang jasa / pelayanan ini memiliki jumlah kamar sebanyak 35 kamar. Kecepatan pelayanan merupakan salah satu target utama untuk memberikan kepuasan kepada pelanggan hotel. Khususnya pada pelayanan administrasi pada New Cahaya Hotel. Pada saat ini, proses administrasi pada New Cahaya Hotel yaitu tamu melakukan reservasi baik melalui telepon ataupun melalui direct reservation. Selanjutnya tamu melakukan check in sesuai dengan tanggal dan waktu yang telah ditentukan pada saat reservasi. Tamu yang telah menginap dapat menggunakan fasilitas yang telah disediakan. Fasilitas yang diberikan kepada tamu hotel terdapat 2 macam, yaitu free services dan paid services. Free services meliputi airport pick up services, welcome drink, dan breakfast order. Paid services meliputi restaurant, drugstore, airport shuttle, dan laundry. Data paid services yang belum terbayar akan ditagihkan pada saat check out. Runtututan prosesnya, data tagihan tamu pada paid services, akan direkap oleh petugas services, kemudian diberikan kepada petugas front office untuk dilakukannya night audit. Dari hasil night audit tersebut akan didapatkan keseluruhan estimasi total biaya inap yang akan ditagihkan saat check out. Pada saat check out petugas front office mengecek ulang tagihan, sambil menunggu petugas house keeping untuk mengecek kamar, apabila ada tambahan tagihan. Setelah selesai
JSIKA Vol. 5, No. 7, Tahun 2016, ISSN 2338-137X
dilakukannya bill settlement, kemudian proses check out pun selesai. Proses akhir adalah proses rooms status maintenance. Proses ini adalah proses perubahan status kamar mulai dari check out, vacant dirty, hingga vacant clean. Proses ini adalah proses make up rooms kamar yang telah dipakai tamu sebelumnya. Masalah yang terjadi saat ini yaitu, New Cahaya Hotel selama dalam menjalankan administrasi sehari-harinya masih menggunakan cara manual, misal pencatatan reservasi dan check in yang lama, sering terjadinya penumpukan tagihan yang belum terbayar yang berakibat tidak terbayarnya tagihan tersebut, dan bill settlement yang memakan waktu lama dalam proses administrasi dan pengkalkulasiannya. Berdasarkan permasalahan di atas maka diperlukan suatu sistem informasi administrasi penjualan yang mampu mengolah data dan mempermudah dalam menyusun laporan. Dengan sistem informasi administrasi perhotelan diharapkan dapat membantu proses administrasi di New Cahaya Hotel. METODE Software Engineering Body of Knowledge (SWEBOK) Menurut John Willey & Sons (2004) dalam bukunya menuliskan : “SWEBOK mendeskripsikan pengetahuan secara umum tentang rekayasa perangkat lunak yang dibagi kedalam 10 area pengetahuan (Knowledge Areas) atau disebut KAs.” Software Engineering Body of Page 1
JSIKA Vol. 5, No. 7, Tahun 2016 Knowledge (SWEBOK) adalah produk dari komite koordinasi rekayasa perangkat lunak disponsori oleh IEEE Computer Society. Berikut adalah penjelasan tentang ruang lingkup pengetahuan atau yang disebut juga Knowledge Area (KA) yang digunakan sebagai panduan dalam mengembangkan aplikasi oleh penulis. 1.Requirement Tahapan awal dalam membangun aplikasi, Software Requirements merupakan sebuah properti yang harus diperlihatkan dengan bertujuan untuk menyelesaikan permasalahan yang ada. Menjabarkan bagaimana mengotomatisasikan sebuah permasalahan sebuah tugas yang dihadapi oleh pengguna, membantu menganalisis proses bisnis perusahaan yang telah menggunakan aplikasi, menganalisis kekurangan yang ada dan lainnya (John Willey & Sons, 2004). Berikut penjabaran tentang beberapa tahapan yang ada pada software requirement: a. Requirement Elicitation Tahapan awal dalam pemenuhan software requirements yang berkonsentrasi pada beberapa hal, darimana kebutuhan perangkat lunak itu sendiri dan bagaimana para pengembangan perangkat lunak dapat mengumpulkannya. b. Requirement Analysis Tahapan ini membahas tentang kegiatan menganalisis kebutuhan untuk : i. Mendeteksi dan menyelesaikan permasalahan yang ada pada tiap-tiap kebutuhan. ii. Menggali batasan yang ada pada perangkat lunak dan bagaimana perangkat lunak tersebut akan berinteraksi dengan lingkungan. iii. Menguraikan kebutuhan sistem yang akan digunakan sebagai kebutuhan perangkat lunak c. Requirements spesification Secara umum specification biasanya mengacu pada banyaknya jumlah pekerjaan atau kemampuan perangkat lunak tersebut dalam mencapai tujuannya, yang secara sistematis dapat dilihat kembali, dievaluasi dan di terima. d. Requirement Verification and Validation Beberapa dokumen requirements di atas menjadi bahan dari tahapan validasi dan verifikasi. Kebutuhan verifikasi dan validasi berpusat pada pemeriksaan kebutuhan dari dokumen yang meyakinkan bahwa ini merupakan sistem yang benar. Kebutuhan yang ada di validasi untuk menjamin bahwa JSIKA Vol. 5, No. 7, Tahun 2016, ISSN 2338-137X
ISSN 2338-137X pengembang dari perangkat lunak tersebut dapat memahami kebutuhan yang akan dicapai. 2.Desain Menurut, John Willey dalam bukunya, Menurut definisi dari IEEE, desain adalah proses yang menggambarkan arsitektur, komponen, antar muka, dan karakteristik yang lain dari sistem atau komponen, serta juga sebagai hasil dari proses tersebut. (John Willey & Sons, 2004). 3.Construction Software construction mengacu pada detil pembuatan dari sebuah pekerjaan, perangkat lunak yang bermakna melalui kombinasi dari pengkodean. sebagai pembuatan detail dari suatu pekerjaan, menciptakan satu perangkat lunak yang penting yang di kombinasikan dengan code, proses verifikasi, testing unit, dan testing yang terintegrasi, serta proses debuging. Sistem Administrasi Istilah administrasi berasal dari bahasa latin yaitu ad dan ministrate yang artinya pemberian jasa atau bantuan, yang dalam bahasa inggris disebut Administration artinya to serve, yaitu melayani dengan sebaik-baiknya. Pengertian administrasi dapat dibedakan menjadi 2 pengertian yaitu: a. Administrasi dalam arti sempit. Menurut Soewarno Handayaningrat mengatakan “Administrasi secara sempit berasal dari kata administratie(bahasa Belanda) yaitu meliputi kegiatan catat-mencatat, surat menyurat, pembukuan ringan, ketik mengetik, agenda dan sebagainya yang bersifat teknis ketatausahaan”(1988:2). Dari definisi tersebut dapat disimpulkan administrasi dalam arti sempit merupakan kegiatan ketatausahaan yang meliputi kegiatan catat mencatat, surat menyurat, pembukuan dan pengarsipan surat serta hal-hal lainnya yang dimaksudkan untuk menyediakan informasi serta mempermudah memperoleh informasi kembali jika dibutuhkan. b. Administrasi dalam arti luas. Menurut The Liang Gie mengatakan “Administrasi secara luas adalah seragkaian kegiatan yang dilakukan oleh sekelompok orang dalam suatu kerjasama untuk mencapai tujuan tertentu”(1980:9). Administrasi secara luas dapat disimpulkan pada dasarnya semua mengandung unsur pokok yang sama yaitu adanya kegiatan tertentu, adanya manusia yang melakukan kerjasama Page 2
JSIKA Vol. 5, No. 7, Tahun 2016
ISSN 2338-137X
serta mencapai tujuan yang telah ditentukan sebelumnya. Pendapat lain mengenai administrasi dikemukakan oleh Sondang P. Siagian mengemukakan “ Administrasi adalah keseluruhan proses kerjasama antara 2 orang atau lebih yang didasarkan atas rasionalitas tertentu untuk mencapai tujuan yang telah ditentukan sebelumnya” (1994:3). Berdasarkan uraian dan definisi tersebut maka dapat diambil kesimpulan bahwa adminsitrasi adalah seluruh kegiatan yang dilakukan melalui kerjasama dalam suatu organisasi berdasarkan rencana yang telah ditetapkan untuk mencapai tujuan.
STAKEHOLDER
PROSES BISNIS Sales Drugstore Sales F&B Reporting Laundry Services Snack Bar HK Rooms Maintenance HK Reporting Monthly Revenue Reporting
House Keeping
Proses Bisnis Berdasarkan Stakeholder
Accountin g
Berikut ini adalah proses bisnis administrasi perhotelan pada New Cahaya Hotel.
Operation al Manager
PHASE
POLICY -
8 14
-
14
-
18
-
19
-
20
-
10
-
Managerial Reporting
21
-
Tabel 1. Proses Bisnis Berdasarkan Stakeholder STAKEHOLDER
Front Office
PROSES BISNIS
PHASE
POLICY
Reservation
1
-
Check In Create Guest Folio Add Detail Guest Folio
2
-
3
-
Airport Shuttle Services
4
9
P9. Pick up services tidak berbayar(f ree), sedangkan drop off services berbayar
Document Flow Sistem Informasi Administrasi Perhotelan Lama
Berikut ini adalah arus dokumen dari sistem lama yang telah diterapkan sebelumnya. Secara detil alur proses administrasi hotel lama dapat ditunjukkan pada Gambar 1 Document Flow Sistem Informasi Administrasi Hotel Saat Ini Front Office
10
Night Audit
12
-
Check Out
15
-
Check In
13
Guest Folio Settlement
17
Welcome Drink Breakfast Order Restaurant
5 6 7
JSIKA Vol. 5, No. 7, Tahun 2016, ISSN 2338-137X
Airport Shuttle Services Bill
Breakfast Order
Welcome / Evening Drink
Breakfast Order List
Welcome/ Evening Drink List
Restaurant & Drugstore Sales Report Restaurant Bill
Occupancy Report
Drugstore Bill
Log Book Log Book Log
5
Book
8
Nota Deposit Reservasi
1
7
3 Mencatat Data pada Log Book
Log Book
Laundry Bill
Operational Manager
Accounting
Data Guest In House
Airport Shuttle Service
Nota Deposit Check In Buku Reservasi Buku Kas Harian
Laundry Services
Laporan Kas Harian Laundry Report
Laundry Report
HK Activity Report
Guest Bill
Laundry Bill Laundry Bill Laporan Kas Harian Occupancy Report Daily Revenue Report
Check Out ?
F&B Guest Invoice
Night Audit
Guest Invoice List
Laporan Kas Harian
Monthly Summary Report
1
9
Drugstore Sales
Drugstore Bill
9
Check Out
Y
Restaurant BIll
9
Mini Bar & Rooms Charge List
2
Restaurant Sales
F&B Audit & Reporting
N Vacant Dirty Rooms List
Occupancy Report
Check Out Book
F&B Guest Invoice
Restaurant & Drugstore Sales Report Restaurant Bill
Mini Bar & Rooms Charge Reporting
Bill Audit
Mini Bar & Rooms Charge List
Monthly Summary Report
6
2
FINISH
Vacant Dirty Rooms List
Drugstore Bill
-
5
HK Rooms Reporting
6 7 Guest Slip
Phase
Food & Beverage
Guest Folio Payment
House Keeping
Data Guest In House
Registration Form Guest Slip Occupancy Report Buku Kas Harian
Reservation
Guest Bill
Wake Up Call
Food & Beverage
4 START
Rooms Maintenance
Occupancy Report
4
3
HK Activity Report
8
.Gambar 1 Document Flow Sistem Informasi Administrasi Hotel Lama
-
System Flow Sistem Informasi Administrasi Perhotelan Baru
-
Berikut ini adalah aliran sistem dari sistem baru yang akan diterapkan pada perusahaan. Secara detil alur sistem administrasi hotel baru dapat ditunjukkan pada Gambar 2.
-
Page 3
JSIKA Vol. 5, No. 7, Tahun 2016
ISSN 2338-137X
System Flow Sistem Informasi Administrasi Hotel Front Office
Food & Beverage
House Keeping
1 Check In
Guest In House
2
4
5 Rooms
Check Out Breakfast Order
Check In Laundry Services
Welcome Drink
Laundry Receipt
Bill Master
Hotel Guest
Laporan Kas Harian FO Laporan Kas Harian F&B
Welcome / Evening Drink
Occupancy Reservation
Reservation receipt
Guest In House
Reservation receipt
Bill Hotel Check Out
Occupancy Report
Breakfast Order
Restaurant Receipt
Airport Shuttle
1
Rooms Check Out Report
Restaurant Sales
Occupancy Report
Restaurant Sales
Restaurant Receipt
[Get Data Rooms Type]
Managerial Reporting
Guest in House Report Rooms
Occupancy Report
F&B Audit & Reporting
Daily Transaction Report Monthly Revenue Report
Restaurant & Drugstore Revenue Summary Report
Extra Accomodation Type
4
Reservation
4
1.1
[Check Rooms Availability]
Company
8
[S impan Data Reservation]
Reservation
[Get Data Reservation]
[Input Data Reservasi]
Detail Reservation
5
[S impan Data Detail Reservation]
[Input Data Payment Reservasi] [P rint Reservation Invoice]
Detail Reservation
5
[Get Data Detail Reservation]
[Data Rooms A vailable]
Reservation [S ave Data Extra Accomodation]
[Notifikasi Data Reservasi Tersimpan] [Notifikasi Data Reservation P ayment Success]
Extra Accomodation
7
Extra Accomodation
12
4 [Get Data Detail Reservation]
5
Detail Reservation
10
Check In
Check In
[Notifikasi Check In Success]
5
[Get Data Check In]
+
10
[S ave Data Check In] [Check Pending Guest Folio]
Gambar 2 System Flow Transaksi Pembelian
Reservation
[Get Data Reservation]
[Input Data Check In] [E xpected Arrival List]
Payment
[S ave Data Payment2]
1.2
[Check In Request]
FINISH
7
[Get Data Extra Accomodation]
[Reservation Invoice]
Drugstore Receipt
Phase
Guest
9
Monthly Rooms Graphic Report Revenue Summary Report
Rooms
6
[Get Data Extra Accomodation Type]
+
4
Rooms Type Rooms Status
3
[Get Data Company]
Monthly Occupancy Graphical Report
Travel agent Invoice Report
Restaurant Receipt Check Out
Group Reservation Report
Guest Invoice Report
Laporan Kas Harian F&B
Bill Hotel
1 2
[Get Data Guest]
Reservation Report
F&B Audit
Bill Master
[Get Data Room S tatus]
[Get Data Rooms]
Drugstore Receipt
Guest In House
Drugstore Sales
Monthly Revenue Report
Rooms Maintenance Occupancy
Airport Shuttle
Restaurant Sales
Monthly Revenue Report
HK Rooms Cleaning Reporting
Check Out
Hotel Guest
Reservation
Bill Audit
Drugstore Sales
2 Check Out ?
Welcome / Evening Drink
Laundry Services
Laundry Receipt
Rooms Check Out Report
3
Rooms Check Out Report
Guest In House
Drugstore Sales
Airport Shuttle Receipt
Laporan Kas Harian FO
Occupancy
administrasi food & beverage, administrasi house keeping, monthly revenue reporting, dan managerial reporting. DFD Level 1 dapat dilihat pada Gambar dibawah ini.
Drugstore Receipt
Breakfast Order Airport Shuttle
Night Audit
Bill Master
3
Laundry Services
Bill Master
Reservation
Rooms
Operational Manager
Accounting
START
1.3
4
Check In
Reservation
[Get Data Reservation]
[Input Data Guest Folio] [Data Pending Guest Folio]
13
Create Guest Folio
[Notifikasi Guest Folio Created]
Guest Folio
[Get Data Guest Folio]
+
13
[S ave Data Guest Folio]
Guest Folio
[Get Data Guest Folio]
13
1.4
[Check Pending Transaction]
[Get Data Detail Guest Folio] [Data Pending Transaction]
Context Diagram
14
Detail Guest Folio
14
Detail Guest Folio
Guest Folio
[S ave Data Detail Guest Folio]
[Input Data Detail Guest Folio]
[Get Data Transaction] 4 Reservation [Get Data DGF From HK Transaction] SpMg_2983
Add Detail Guest Folio [Get Data Reservation]
[Notifikasi Data Detail Guest Folio S aved]
Detail Reservation [Get Data DGF From FB]
5
[Get Data Detail Reservation]
+
4
Reservation
SpMg_667
Context diagram sistem informasi administrasi perhotelan pada New Cahaya Hotel terdiri dari 5 entitas yaitu bagian front office, bagian food & beverage, bagian house keeping, bagian accounting dan operational manager. Setiap entitas memiliki input kedalam sistem dan mendapatkan output dari sistem. Agar lebih jelas, dapat dilihat pada gambar 4 context diagram dibawah ini.
1.5
Airport Shuttle Service
[Notifikasi Data Airport Shuttle Service Saved]
15
+
[A irport Shuttle Receipt]
[Get Data Reservation]
Airport Shuttle
[Get Data Service Type] [Get Data Service]
1.6
4
Detail Reservation
5
SpMg_673 15 Airport Shuttle [Get Data Airport Shuttle]
[S ave Data Airport Shuttle] [Input Data Airport Shuttle Service]
27
Service Type
28
Service
[Get Data Detail Reservation]
Reservation
[Get Data Reservation] [Input Data Wake Up Call]
Detail Reservation
5
[Get Data Detail Reservation]
Wake Up Call Service [Notifikasi Data Wake Up Call Service Saved]
16
[S ave Data Wake Up Call]
Wake Up Call [Get Data Payment]
1.7
[S ave Data Guest Folio]
[Input NA Data Guest Folio]
[S ave Data Detail Guest Folio] [Get Data Airport Shuttle] 12
[Input NA Data Detail Guest Folio] [P rint in House Service Schedule Request]
13
[Get Data Detail Reservation] 14 [Get Data Check In]
[P rint Check Out Report Request]
Front Office
Payment
[Get Data Wake Up Call] [Get Data Reservation]
[P rint Check In Report Request]
[P rint Reservation Report Request]
Night Audit
Guest Folio Detail Guest Folio
[Get Data Check Out]
[P rint Daily Guest in House Report Request]
[Get Data Rooms]
15
Airport Shuttle
[Get Data Rooms Type]
[P rint Daily Revenue Report Request]
[Get Data Guest]
[P rint Daily Room Sales Report Request]
16
[Get Data Company]
[P rint Daily Payment Report Request]
[Get Data Extra Accomodation] [Get Data Retur Payment]
+
[P rint Daily Occupancy Report Request]
Wake Up Call
4
Reservation Detail Reservation
5 [Notifikasi NA Data Detail Guest Folio Saved] [Notifikasi NA Data Guest Folio Saved] [Check In Report]
10
Check In
[Get Data Overtime]
[Check Out Report] [Reservation Report]
11
Check Out
[Daily Guest In House Report] 3
[Daily P ayment Report]
Rooms
[Daily Revenue Report] 1
Rooms Type
[In House Service Schedule] 6
Guest
[Daily Room Sales Report] 9
[Daily Occupancy Report] 1.8
4
Reservation
5
Detail Reservation
[Get Data Reservation] [Check Data Expected Departure] [Get Data Detail Reservation]
Company
7
[Input Data Check Out]
Extra Accomodation
33 Check Out
11
[Get Data Check Out]
[E xpected Departure List]
Retur Payment
Check Out 32
[S ave Data Check Out]
[Notifikasi Check Out Success]
+
[S impan Data Overtime]
11
Check Out
32
Overtime
1.9
13
Overtime
Guest Folio
[Get Data Guest Folio] [Check Guest Folio List Payment] Print Hotel Bill Request
[S ave Data Detail Guest Folio]
[P rint Payment Invoice Request]
Guest Folio Payment
Detail Guest Folio
14 [Get Data Detail Guest Folio]
[Guest Folio List P ayment] [Notifikasi Guest Folio P ayment Success]
Input Data Payment
Detail Guest Folio
14
[Input Data Payment]
Settlement Bill Check Guest Folio List Settlement Print P ayment Invoice Request
Check Guest Folio List Payment
[S ave Data Payment]
+
[P ayment Receipt]
[Get Data Payment]
Input Data Check Out Check Data Expected Departure
12
Payment
12
Payment
1.10 [Check Guest Folio List Settlement]
Input NA Data Detail Guest Folio
[P rint Hotel Bill Request]
Detail Guest Folio
13
Guest Folio
14
Detail Guest Folio
33
Retur Payment
[S ave Data Guest Folio]
[Notifikasi Settlement Success]
[S ave Data Detail Guest Folio]
[Hotel B ill]
Print Reservation Report Request
Guest Folio
14 [Get Data Detail Guest Folio] Guest Folio Settlement
[Guest Folio List S ettlement]
Print Daily Guest in House Report Request
13 [Get Data Guest Folio]
[S ettlement Bill]
Input NA Data Guest Folio Print Daily Occupancy Report Request Print Daily Room Sales Report Request Print Daily Payment Report Request Print Daily Revenue Report Request
+
[S impan Data Retur Payment]
Print Check Out Report Request
Front Office
Print Check In Report Request
Gambar 4 DFD Level 1 Administrasi Front Office
Print in House S ervice Schedule Request Input Data Wake Up Call Input Data Airport Shuttle Service Input Data Detail Guest Folio Check Pending Transaction Input Data Guest Folio
Input Data Check In Check In Request
[Get Data WED Guest Log]
Print Reservation Invoice Input Data Payment Reservasi
SpMg_2868
Input Data Reservasi Check Pending Guest Folio
[Get Data FB Type]
Check Rooms A vailability
17
[Get Data FB]
[Save Data WE Drink] [Input Data Welcome Evening Drink Service]
Input Data Laundry Service Data Rooms Available
[Get Data WE Drink]
Print Laundry Service Receipt Request
Notifikasi Data Reservasi Tersimpan
FB Type
18
FB
24
WE Drink
24
WE Drink
25
Detail WE Drink
25
Detail WE Drink
2.1
[Check Data Guest Log WED] 0
Input S nack Bar Sales
Notifikasi Data Reservation Payment Success
Welcome Evening Drink
[Data Guest Log WED]
Print S nack Bar Sales Receipt
Reservation Invoice
[Save Data Detail WE Drink]
Check Room Status List
Expected A rrival List
Input Data Room Maintenance Notifikasi Check In S uccess Data P ending Guest Folio
[Notifikasi Data WE Drink Service Saved]
Print Daily Laundry S ervice Revenue Report
+
Print Daily Snack Bar Sales Report
Notifikasi Guest Folio Created
[Get Data Det ail WE Drink]
Print Daily HK Room Maintenance Report
Data P ending Transaction
House Keeping
Notifikasi Data Detail Guest Folio S aved
Notifikasi Data Laundry Service Saved
Notifikasi Data Airport Shuttle Service Saved
[Get Data Breakfast Guest Log]
Laundry Service Receipt
Airport Shuttle Receipt
Notifikasi Data Snack Bar Sales Saved
Notifikasi Data Wake Up Call Service Saved
SpMg_674
Snack Bar Receipt
Notifikasi NA Data Guest Folio Saved
[Get Data FB Type]
Data Room Status List
Notifikasi NA Data Detail Guest Folio Saved
17
Notifikasi Data Room Maintenance Saved
In House Service Schedule
Daily Laundry Service Revenue Report
Sistem Informasi Administrasi Perhotelan
Check In Report
[Get Data FB]
Daily Snack Bar Sales Report
Check Out Report
FB Type
18
FB
36
Breakfast Menu
Daily HK Room Maintenance Report
Reservation Report
Daily Drugstore Sales Report
Daily Guest In House Report
[Check Data Guest Log BO]
Daily Drugstore Transaction Report
Daily Revenue Report
2.2
Daily Restaurant Sales Report
Daily Payment Report
Daily Restaurant Transaction Report Breakfast Order List
Daily Room Sales Report
Daily Welcome Evening Drink Report
Daily Occupancy Report
[Get Data Breakfast menu] 22 Breakfast
[Input Data Breakfast Order] [Save Data Breakfast]
Drugstore S ales Receipt
Expected Departure List
Notif Data Drugstore Sales Saved
Notifikasi Check Out Success
Restaurant Sales Receipt
Guest Folio List Payment
Breakfast Order
[Data Guest Log BO]
Notif Data Restaurant Sales Saved
Notifikasi Guest Folio Payment Success
+
Notifikasi S ettlement Success
[Save Data Detail Breakfast]
[Notifikasi Data Breakfast Order Tersimpan]
Data Guest Log BO
22
Breakfast
23
Detail Breakfast
[Get Data Breakfast]
Notifikasi Data Breakfast Order Tersimpan
Payment Receipt Guest Folio List Settlement
Notifikasi Data WE Drink Service Saved
+
Data Guest Log WED
[Get Data Det ail Breakf ast]
23
Detail Breakfast
Hotel Bill
[Get Data Restaurant Sales Guest Log] [Get Data FB Type]
17
FB Type
18
FB
SpMg_2870
2.3 19 [Input Data Restaurant Sales]
[Notif Dat a Rest aurant Sales Saved]
[GetSales Data Type FB]
[Get Data Sales Type] 20
[Print Restaurant Sales Receipt]
Print Monthly Accomodation Revenue Report
FB Sales
[Save Data FB Sales] Restaurant Sales
[Save Data Detail FB Sales]
21
Detail FB Sales
[Get Data Det ail FB Sales]
21
Detail FB Sales
20
FB Sales
Print Monthly Ariport Shuttle Revenue Report Check Data Guest Log WED Print Monthly Restaurant Sales Report
[Restaurant Sales Receipt]
Input Data Welcome Evening Drink Service
Print Monthly Drugstore Sales Revenue Report
+
Check Data Guest Log BO Input Data Breakfast Order
Print Monthly Other Income Report Print Monthly Hotel Revenue S ummary Report
[Get Data FB Sales]
Food & Beverage
Input Data Restaurant Sales Print Restaurant Sales Receipt
Monthly Accomodation Revenue Report Accounting
Food & Beverage
[Get Data FB]
Print Daily Welcome Evening Drink Report Print B reakfast Order List
Print Daily Restaurant Transaction Report Monthly Hotel Revenue Summary Report Print Daily Restaurant Sales Report
[Get Data Sales Type] [Drugstore Sales Receipt]
Print Daily Drugstore Transaction Report
FB
19
Sales Type
Drugstore Sales
Print Daily Drugstore Sales Report
[Notif Dat a Drugstore Sales Saved]
Print A nnual Occupancy Report
+
Print A nnual Revenue Report Operational Manager
FB Type
18
[Print Drugstore Sales Receipt ]
Monthly Drugstore Sales Revenue Report Monthly Other Income Report
[Get Data FB Type]
[Input Data Drugstore Sales]
Print Drugstore Sales Receipt
Monthly Restaurant S ales Revenue Report
17
2.4
Input Data Drugstore Sales
Monthly Airport Shuttle Revenue Report
Annual Occupancy Report
20 [Save Data FB Sales] [Get Data FB Sales]
FB Sales
21 [Get Data Det ail FB Sales] [Save Data Detail FB Sales]
Detail FB Sales
20 21
FB Sales Detail FB Sales
[Get Data Drugstore Sales Guest Log]
Annual Revenue Report
SpMg_2869 2.5
Gambar 3 Context Diagram
17
FB Type
[Get Data FB Type]
[Print Daily Welcome Evening Drink Report]
18 [Print Breakfast Order List]
FB
[Get Data FB]
[Print Daily Rest aurant Transaction Report]
22
[Get Data Breakfast]
Breakfast
[Print Daily Rest aurant Sales Report] 23
[Print Daily Drugstore Transaction Report]
Detail Breakfast
[Get Data Det ail Breakf ast]
Data Flow Diagram(DFD) DFD adalah breakdown dari Context Diagram yang berisi urutan proses yang terdapat pada Sistem Informasi Administrasi Perhotelan pada New Cahaya Hotel. Proses dibagi menjadi 5 sub proses yaitu proses administrasi front office,
JSIKA Vol. 5, No. 7, Tahun 2016, ISSN 2338-137X
[Print Daily Drugstore Sales Report ] [Daily Welcome Evening Drink Report]
FB Reporting
[Get Data Det ail WE Drink]
[Breakfast Order List] [Daily Restaurant Transaction Report ]
WE Drink Detail WE Drink
20
FB Sales
[Get Data Restaurant Sales]
[Daily Restaurant Sales Report]
[Get Data Det ail Restaurant Sales]
[Daily Drugstore Sales Report] [Daily Drugstore Transact ion Report]
24 25
[Get Data WE Drink]
+
21
Detail FB Sales
20
FB Sales
21
Detail FB Sales
[Get Data Drugstore Sales] [Get Data Det ail Drugst ore Sales]
Gambar 5 DFD Level 1 Administrasi Food & Beverages
Page 4
JSIKA Vol. 5, No. 7, Tahun 2016
ISSN 2338-137X Relation_365
[Get Data Laundry Gues t Log]
27
Payment
Rooms Maintenance
[Get Data Service]
3.1
[Input Data Laundry Service]
ID_Company Nama_Company
Service Type
28
Service
29
Laundry
Guest
ID_RM Tanggal_RM From_Status To_Status Relation_351
[Print Laundry Service Rec eipt Request] 29
Laundry
[Get Data Laundry]
Reservation
Rooms Status
Laundry Service
[Notifikasi Data Laundry Service Saved]
30
Detail Laundry
30
Detail Laundry
+
[Get Data Detail Laundry]
ID_RES TGL_RES Totalcost_RES Status_GL Path_GL Jenis_RES Status_RES
Relation_326
ID_RStatus Nama_RStatus
[Save Data Detail Laundry]
[Laundry Service Rec eipt]
Relation_343
[Get Data SnackBar Sales Gues t Log]
34
Snac k Bar
[Save Data Snack Bar]
[Input Snack Bar Sales]
34
Snac k Bar
35
Detail Snack Bar
Detail Guest Folio
Relation_348
Check Out
ID_WUC Jam_WUC Notes_WUC
[Get Data Service]
[Get Data Service Type]
27
Service Type
Relation_358
Detail WE Drink
3.3 SpMg _1013
[Save Data Room Maintenance]
HK Rooms Maintenance
31
Relation_372Relation_368
Relation_367
FBSales
[Save Data Rooms ]
Rooms
ID_SB Tgl_SB Total_SB Status_SB
Relation_328
Laundry_Service ID_LS Tgl_inLS Total_LS Status_Bayar_LS
[Get Data Laundry] [Print Daily Snac k Bar Sales Report] [Get Data Detail Laundry]
29
Laundry
30
Detail Laundry
Relation_340
ID_EA Jumlah_EA Harga_EA Subtotal_EA
ID_DLS Jumlah_DLS Harga_DLS Subtotal_DLS
Jabatan
Relation_345
ID_DBO Jumlah_DBO
Relation_324
Relation_330
Extra Accomodation Type
ID_BM Day
Relation_335 Relation_334
ID_EAType Nama_EAType Harga_EAType
Relation_329
ID_DFBS Jumlah_DFBS Harga_DFBS Subtotal_DFBS
Breakfast Menu
3.4
Relation_338
ID_DSB Jumlah_DSB Harga_DSB Subtotal_DSB
Detail_Laundry_Services
Relation_373
Extra Accomodation
Detail_Breakfast
Relation_336
Detail_FBSales
[Print Daily Laundry Service Revenue Report]
Relation_341
ID_Jabatan Nama_Jabatan
ID_FB Nama_FB Harga_FB
FB Type ID_FBType Nama_FBType
+
Relation_339
Detail Snackbar
Relation_371
ID_FBS Tanggal_FBS NoMeja_FBS Total_FBS Disc_FBS DiscN_FBS TotalNett_FBS Status_FBS
Relation_333
ID_Service Nama_Service Harga_Service
Relation_342
Relation_370
FB 3
Service
ID_AS TGL_AS Maskapai Terminal Flight Time Shuttle_Time Cost_AS Status_Bayar_AS
Room M aintenance Relation_337
[Data Room Status List]
[Notifikasi Data Room Maintenance Saved]
Relation_374
Relation_375 Relation_369
Relation_366
ID_BO Tglinput_BO Time_BO
Relation_362
ID_DGF Tipe_DGF Tgl_DGF Nilai_DGF OP_DGF
SnackBar
Relation_357
Relation_331
ID_OT TGL_OT Nilai_OT
Relation_354
Relation_356
Breakfast
ID_DWED Jumlah_DWED
[Get Data Rooms Log] [Chec k Room Status Lis t] [Input Data Room Maintenance]
Relation_361
ID_DR TGL_CIN_DR TGL_COUT_DR NIGHTS P_Adult P_Child Roomcost_DR Cost_DR DiscP_DR DiscN_DR Subtotal_DR Status_DR
WE Drink ID_WED Tgl_WED Status_WED
[Snack Bar Receipt]
House Keeping
Relation_349
ID_CO TGL_CO Wake Up Call
[Notifikasi Data Snack Bar Sales Saved]
Detail_Reservation
Relation_347
Relation_359
Relation_327
ID_ST Nama_ST
Airport_Shuttle
Relation_350
Overtime
Check In
[Get Data Detail Snack Bar] 28 Service
Service_Type Relation_346
Relation_353
35 Detail Snack Bar [Save Data Detail Snac k Bar]
+
Guest Folio
ID_Rooms
ID_CI TGL_CI
[Print Snack Bar Sales Receipt]
Relation_360
ID_GF TGLOP_GF TGLCL_GF Status_GF
Rooms Relation_325
[Get Data Snack Bar] Snac kBar Sales
ID_RP Tgl_RP Nilai_RP Relation_352
Relation_355
Rooms Type ID_RT Nama_RT Harga_RT Kapasitas
SpMg _2890 3.2
Retur_Payment
ID_Guest Nama_Guest Alamat_Guest NoTelp_Guest IDType NOID_Guest JK_Guest Birthdate_Guest Birthcity_Guest
Relation_344
[Save Data Laundry]
Relation_363
ID_Payment Tgl_Payment Type_Payment Nilai_Payment
Company
SpMg _1025 [Get Data Service Type]
Karyawan ID_Karyawan Nama_Karyawan Alamat No_Telp Password
Sales Type ID_Sales Nama_Sales
[Print Daily HK Room Maintenanc e Report] [Get Data Snack Bar]
HK Reporting [Daily Snac k Bar Sales Report]
[Get data Detail Snac k Bar]
34
Snac k Bar
35
Detail Snack Bar
Gambar 9 CDM
[Daily Laundry Service Revenue Report] 31
+
Room M aintenance
[Get Data Room Maintenanc e]
[Daily HK Room Maintenanc e Report]
PDM (Physical Data Model) Gambar 6 DFD Level 1 Administrasi House Keeping 4.1 Print Monthly Accomodation Revenue Report
[Monthly Accomodation Revenue Report]
[Print Monthly Restaurant Sales Report]
[Get Data Accomodation] SpMg _2915
4.2
[Monthly Restaurant Sales Revenue Report]
Print Monthly Restaurant Sales Revenue Report
[Get Data Restaurant Revenue] SpMg _2916
4.3 [Print Monthly Drug store Sales Revenue Report]
Print Monthly Drug store Sales Revenue Report
[Monthly Drug store Sales Revenue Report]
[Get Data Drugstore Revenue] SpMg _2917
Accounting 4.4 [Print Monthly Ariport Shuttle Revenue Report]
15 Airport Shuttle Print Monthly Airport Shuttle[Get Data Airport Shuttle Revenue] Revenue Report
[Monthly Airport Shuttle Revenue Report]
PDM (Physical Data Model) menjabarkan secara detil kerangka rancangan struktur basis data yang dirancang untuk suatu aplikasi. Physical Data Model (PDM) merupakan hasil dari Conseptual Data Model yang menggambarkan relasi antar basis data yang ada. Dimana pada PDM tergambar secara jelas tabel – tabel penyusun basis data beserta field – field yang terdapat pada setiap tabel, sebagaimana terlihat pada Gambar 10 ID_RES = ID_RES
PAYMENT
[Monthly Other Income Report]
[Get Data Other Income] SpMg _2919
integer varchar(10) timestamp varchar(30) varchar(30)
ROOMS_STATUS
[Get Data M onthly Hotel Revenue] SpMg _675
Gambar 7 DFD Level 0 Monthly Revenue Reporting
ID_RSTATUS NAMA_RSTATUS
[Annual Occupancy Report]
ID_ROOM S = ID_ROOMS
ID_RT = ID_RT
varchar(10) varchar(30) integer integer
ID_WUC ID_DR JAM_WUC NOTES_WUC
integer integer timestamp varchar(70)
DETAIL_WE_DRINK ID_DWE D ID_WED ID_FB JUMLAH_DWED
integer integer varchar(10) integer
varchar(10) varchar(10) timestamp integer smallint varchar(30) varchar(30) varchar(30)
varchar(10) varchar(10) varchar(10)
[Annual Revenue Report]
ID_BM ID_FB DAY
varchar(10) varchar(10) varchar(30)
varchar(10) varchar(30)
ID_ST = ID_ST
AIRPORT_SHUTTLE ID_AS ID_DR ID_DGF TGL_AS MASKAPAI TERMINAL FLIGHT_TIME SHUTTLE_TIME COST_AS STATUS_BAYAR_AS
ID_DGF = ID_DGF
ID_GUEST = ID_GUEST
WE_DRINK ID_WED ID_DR TGL_WED STATUS_WED
integer integer date varchar(30)
ID_WED = ID_W ED
EXTRA_ACCOMODATION
ID_DR = ID_DR ID_DR = ID_DR
BREAKFAST ID_BO ID_DR TGLINPUT_B O TIME_BO
varchar(10) integer date timestamp ID_BO = ID_BO
varchar(10) varchar(10) varchar(30) integer
BREAKFAST_MENU
[Get Data Revenue OM] SpMg _1031
SERVICE_TYPE
varchar(10) varchar(10) varchar(10) date date varchar(10)
varchar(10) integer integer SERVICE date varchar(30) ID_SERVICE varchar(10) ID_AS = ID_AS varchar(30) ID_ST varchar(10) DETAIL_GUE ST_FOLIO timestamp ID_AS varchar(10) timestamp ID_DGF integer NAMA_SERVICE varchar(30) integer ID_GF varchar(10) HARGA_SERVICE integer DETAIL_RES ERVATION OVERTIME varchar(30) ID_GUEST varchar(10) ID_DR integer ID_OT integer TIPE_DGF varchar(30) ID_RES varchar(10) ID_DR = ID_DRID_DR integer TGL_DGF date ID_GUEST varchar(10) ID_DGF integer NILAI_DGF integer ID_ROOM S = ID_ROOMS ID_DGF integer TGL_OT date ID_DGF = ID_DGFOP_DGF varchar(30) ID_SERVICE = ID_SERVICE ID_ROOMS varchar(10) NILAI_OT integer CHECK_IN T date ID_DR = ID_DR ID_CI integer TGL_COUT_DR date ID_DR integer CHECK_OUT NIGHTS integer ID_DGF = ID_DGF ID_DGF = ID_DGF TGL_CI timestamp ID_DR = ID_DR DETAIL_SNA CKBAR ID_CO integer ID_DR = ID_DR P_ADULT integer SNACKBAR ID_DSB integer ID_SERVICE = ID_SERVICE ID_DR integer P_CHILD integer ID_SB varchar(10) ID_DGF = ID_DGF ID_SERVICE varchar(10) TGL_CO timestamp ROOMCOST_DR integer ID_DR = ID_DR ID_DR integer ID_DR = ID_DR ID_SB varchar(10) COST_DR integer ID_DGF = ID_DGF ID_DGF integer ID_SB = ID_SBJUMLAH_DSB ID_DR = ID_DR integer DISCP_DR integer TGL_SB date HARGA_DSB integer DISCN_DR integer TOTAL_SB integer ID_DR = ID_DR SUBTOTAL_DSB integer SUBTOTAL_DR integer STATUS_SB varchar(30) ID_DR = ID_DR STATUS_DR integer
ID_ROOMS ID_RT ID_RSTATUS
ID_FB ID_FBTYPE NAMA_FB HARGA_FB ID_FBT YPE = ID_FBTYPE varchar(10) varchar(30)
FB_TYP E ID_FBTYPE NAMA_FBTYPE
Print Annual Revenue Report
ID_DGF = ID_DGF
ID_ST NAMA_ST ID_GF ID_GUEST ID_RES TGLOP_GF TGLCL_GF STATUS_GF
ID_RES = ID_RES
ID_GUEST = ID_GUEST ID_RES = ID_RES
FB ID_FB = ID_F B
5.2 [Print Annual Revenue Report]
integer integer date integer
ID_GUEST = ID_GUEST
ID_GF = ID_GF
WAKE_UP_CALL
Operational Manag er
ID_DGF = ID_DGF
GUEST_FOLIO
ROOMS
5.1
[Get Data Occupancy OM ] SpMg _1044
varchar(10) varchar(10) varchar(50) varchar(50) varchar(30) varchar(30) varchar(30) varchar(10) date varchar(30)
RESERVATION
ROOMS_TYPE
Print Annual Occupancy Report
varchar(10) varchar(30)
ID_RES ID_GUEST TGL_RE S TOTATLCOST_RES ID_RST AT US = ID_RST ATUS STATUS_GL PATH_GL JENIS_RES STATUS_RES
ID_RT NAMA_RT HARGA_RT KAPASITAS
[Print Annual Occupancy Report]
ID_RP ID_DGF TGL_RP NILAI_RP
GUEST ID_GUEST ID_COMPANY NAMA_GUEST ALAMAT_GUEST NOTELP_GUEST IDTYPE NOID_GUEST JK_GUE ST BIRTHDATE_GUEST BIRTHCITY_GUEST
ID_COMPANY = ID_COMPANY
ID_GUEST = ID_GUEST
Print Hotel Revenue Summary Report
[Monthly Hotel Revenue Summary Report]
varchar(10) integer varchar(10) timestamp varchar(30) integer
RETUR_PAYMENT
ROOMS_MAINTENANCE ID_RM ID_ROOMS TANGGAL_RM FROM_S TATUS TO_STATUS
4.6 [Print Monthly Hotel Revenue Summary Report]
ID_PAYMENT ID_DGF ID_RES TGL_PA YMENT TYPE_PAYMENT NILAI_PAYMENT
COMPANY ID_COMPANY varchar(10) NAMA_COMPANY varchar(30)
4.5 Print Monthly Other Income Report
[Print Monthly Other Income Report]
ID_FB = ID_F B
DETAIL_BRE AKFAST
ID_DBO ID_BO ID_FB JUMLAH_DBO
integer varchar(10) varchar(10) integer
FBSALE S ID_FBS ID_SALES ID_DR ID_DGF TGL_FBS NOMEJA_FBS TOTAL_FBS DISC_FBS DISCN_FBS TOTALNETT_FBS STATUS_FBS
varchar(10) varchar(10) integer integer date varchar(10) integer integer integer integer varchar(30)
ID_EA integer ID_DGF = ID_DGF ID_EATYPE varchar(10) ID_DR integer ID_DGF integer JUMLAH_EA integer HARGA_EA integer SUBTOTAL_EA integer
LAUNDRY_SERVICE ID_LS ID_DR ID_DGF TGL_INLS TOTAL_LS STATUS_BAYAR_LS
varchar(10) integer integer date integer varchar(30)
DETAIL_LAUNDRY_SERVICES
ID_LS = ID_LS
ID_FB = ID_F B ID_FB = ID_F B
integer varchar(10) varchar(10) integer integer integer
integer varchar(10) varchar(10) integer integer integer
EXTRA_ACCOMODATION_TYPE
ID_SALES = ID_SALES
ID_EATYPE NAMA_EATYPE HARGA_EATYPE
ID_EAT YPE = ID_EATYPE
varchar(10) varchar(30) integer KARYAWAN ID_KARYAWAN ID_JABATAN NAMA_KARYAWAN ALAMAT NO_TELP PASSWORD
DETAIL_FBSALES ID_DFBS ID_FBS ID_FB JUMLAH_DFBS HARGA_DFBS SUBTOTAL_DFBS
ID_DLS ID_SERVICE ID_LS JUMLAH_DLS HARGA_DLS SUBTOTAL_DLS
ID_FBS = ID_FBS
SALES_TYPE ID_SALES NAMA_SALES
varchar(10) varchar(30)
JABATAN ID_JABATAN NAMA_JABATAN
varchar(10) varchar(30)
varchar(10) varchar(10) varchar(50) varchar(50) varchar(30) varchar(30)
ID_JABAT AN = ID_JABAT AN
Gambar 10 PDM Gambar 8 DFD Level 0 Managerial Reporting CDM (Conceptual Data Model) CDM (Conseptual Data Model) merupakan struktur basis data dibuat. Pada CDM digambarkan hubungan antara basis data yang satu dengan basis data yang lainnya. Dimana basis data yang ada saling terhubung. Gambaran CDM ini dapat dilihat pada Gambar 9
JSIKA Vol. 5, No. 7, Tahun 2016, ISSN 2338-137X
Desain Input Output (IO) Desain Master Guest Form Master Guest digunakan oleh petugas front office untuk menginputkan data tamu yang menginap di hotel. Desain Master Guest dapat dilihat pada Gambar 11.
Page 5
JSIKA Vol. 5, No. 7, Tahun 2016
ISSN 2338-137X
Master Guest
Add Data
ID Guest
Nama Guest
Company
Alamat
Kota
No Hp
No KTP
Action Edit
Del
Edit
Del
Edit
Del
Gambar 11 Desain Master Guest Desain Form Reservasi Form Reservasi digunakan untuk mencatat reservasi kamar yang dipesan oleh tamu yang akan menginap di hotel. Desain Form Reservasi dapat dilihat pada Gambar 12
Gambar 14 Revenue Report
Reservation Room ID Reservation
Enter Text
Room No
Enter Text
Rooms Type
Enter Text
From
Dd-mm-yyyy
Person
Enter Text
Extra Bed
Enter Text
To Adult
Days
Dd-mm-yyyy Enter Text
Child
Extra Person Enter Text ______________________________________________________________________________________________________________________________________ Guest Name
Enter Text
City
Enter Text
Birthdate
Enter Text
Company
Enter Text
Search
New Guest
______________________________________________________________________________________________________________________________________ Settlement
Gambar 15 Annual Occupancy Report
Nights Price / Nights Total Accomodation Extra Bed Extra Person ____________________________________________________ + Total ______________________________________________________________________________________________________________________________________ Save
Cancel
Gambar 12 Desain Form Reservasi Rancangan Interface Input Output (IO) Rancangan Interface Input/Output adalah rancangan antar muka yang akan diimplementasikan pada Sistem Informasi Administrasi Perhotelan. Desain rancangan interface dapat dilihat pada Gambar 13.
KESIMPULAN Setelah dilakukan analisis, perancangan dan pembuatan aplikasi, maka tugas akhir yang berjudul “Rancang Bangun Sistem Informasi Administrasi Perhotelan pada New Cahaya Hotel” dapat disimpulkan sebagai berikut: rancang bangun Sistem Informasi Administrasi Perhotelan yang dibuat telah sesuai dengan kebutuhan pengguna pada New Cahaya Hotel. DAFTAR PUSTAKA Gie, The Liang. 1989. Materi Pokok Etika Administrasi Pemerintahan. Jakarta: Universitas Terbuka, Depdikbud. Handayaningrat, Soewarno. 1988. Administrasi Pemerintahan dalam Pembangunan Nasional. Jakarta: Haji Masagung.
Gambar 13 Interface HASIL DAN PEMBAHASAN Tampilan Hasil Laporan Tampilan laporan merupakan tampilan yang digunakan untuk mengetahui tingkat occupancy, room sales, F&B sales dan Services.
JSIKA Vol. 5, No. 7, Tahun 2016, ISSN 2338-137X
John Willey & Sons. 2004. IEEE. Guide to the Software Egineering Body of Knowledge : SWEBOK A Project of the IEEE Computer Society. England: John Willey & Sons.Inc Siagian,
Soendang P. Kepemimpinan Administrasi. Masagung.
1994. Organisasi dan Perilaku Jakarta: Haji
Page 6
JSIKA Vol. 5, No. 7, Tahun 2016
ISSN 2338-137X
Soenarno, Adi. 2006. Front Office Management. Yogyakarta: Andi Offset.
JSIKA Vol. 5, No. 7, Tahun 2016, ISSN 2338-137X
Page 7
