Creation of Appsheet-Based Vendor Database System at Savoy Homann Hotel Purchasing Division
Abstract
The tourism industry in Indonesia is experiencing rapid development. One of these industries is hospitality as a place for tourists to stay. In carrying out its operations, the hotel depends on vendors to meet the needs of goods and services. Therefore, the vendor selection stage needs to be done properly. An improper selection process can result in a mismatch between the goods received and the needs of the hotel. Based on these problems, this project was created with the aim of building an Appsheet-based vendor database system that contains complete information about vendor data and quality to support a better decision-making process. This project began with a needs analysis through interviews with Savoy Homann Hotel Purchasing. In addition, a literature study was conducted as a reference for designing solutions. Next, the system was developed and tested using the Blackbox Testing method and interviews. As a result, the system successfully fulfills all the company's needs, ranging from vendor data, product quality, to performance ratings. The test shows that the features run well and according to plan. In conclusion, this vendor database system effectively helps the Purchasing division in managing the procurement of goods and services more efficiently, structurally, and optimally.
Downloads
References
D. R. Anggarini, “Dampak Sektor Pariwisata Pada Pertumbuhan Ekonomi Daerah Lampung,” Jurnal Bisnis Darmajaya, Vol. 7, No. 2, Pp. 116–122, Jun. 2021, Accessed: Feb. 16, 2025. [Online]. Available: Https://Jurnal.Darmajaya.Ac.Id/Index.Php/Jurnalbisnis/Article/View/3089
D. Kania And Suhendi, “Komitmen Organisasi Dan Kinerja Karyawan Pada Hotel Grandia Bandung,” Bisman (Bisnis Dan Manajemen): The Journal Of Business And Management, Vol. 5, No. 1, Pp. 95–105, Aug. 2022, Doi: 10.37112/Bisman.V5i1.2107.
E. Fitriyani, “Upaya Mempertahankan Nilai Sejarah Melalui Pendekatan Experiental Marketing Di Hotel Savoy Homann Bidakara,” Historia: Jurnal Pendidik Dan Peneliti Sejarah, Vol. 5, No. 1, Pp. 37–48, Feb. 2022, Doi: 10.17509/Historia.V5i1.38594.
E. Effendy, E. A. Siregar, P. C. Fitri, And I. A. S. Damanik, “Mengenal Sistem Informasi Manajemen Dakwah (Pengertian Sistem, Karakteristik Sistem),” Jurnal Pendidikan Dan Konseling (Jpdk), Vol. 5, No. 2, Pp. 4343–4349, Apr. 2023, Doi: 10.31004/Jpdk.V5i2.14061.
N. Y. Arifin, R. I. Borman, S. S. Tyas, H. Sulistiani, A. Hardiansyah, And G. P. Suri, Analisa Perancangan Sistem Informasi . Percetakan Cendekia Mulia Mandiri, 2022. Accessed: Feb. 24, 2025. [Online]. Available: Https://Books.Google.Co.Id/Books?Hl=Id&Lr=&Id=Ldxzeaaaqbaj&Oi=Fnd&Pg=Pr2&Dq=Tujuan+Dari+Sistem+&Ots=Turquodjqa&Sig=Hfo0bqc7flfw4r_5vz9olp_Sgrk&Redir_Esc=Y#V=Onepage&Q=Tujuan%20dari%20sistem&F=False
A. T. Rahmawati And Y. Agustina, “Analisis Pengadaan Barang: Kendala Pada Divisi Purchasing Di Lippo Plaza Batu,” Jurnal Ekonomi, Bisnis Dan Pendidikan (Jebp), Vol. 1, No. 10, Pp. 922–926, 2021, Doi: 10.17977/Um066v1i102021p922-926.
A. Febyanti And S. Suwarno, “Peran Sistem Informasi Akuntansi Dalam Rangka Meningkatkan Kinerja Karyawan Divisi Purchasing Di Pt Semen Indonesia Distributor,” Co-Value Jurnal Ekonomi Koperasi Dan Kewirausahaan, Vol. 15, No. 8, Jan. 2025, Doi: 10.59188/Covalue.V15i8.5039.
H. B. Santoso And S. Hidayatullah, “Sistem Pendukung Keputusan Untuk Penilaian Staff Divisi Purchasing Menggunakan Metode Saw Dan Roc,” Journal Of Information Technology, Software Engineering And Computer Science, Vol. 2, No. 4, Pp. 171–181, Oct. 2024, Doi: 10.58602/Itsecs.V2i4.160.
Rusliyawati And R. Nuraini, “Sistem Pendukung Keputusan Pemilihan Vendor It Menggunakan Metode Perbandingan Eksponensial (Mpe),” Insearch: Information System Research Journal, Vol. 2, No. 02, Pp. 90–98, Nov. 2022, Accessed: Jan. 31, 2025. [Online]. Available: Https://Ejournal.Uinib.Ac.Id/Jurnal/Index.Php/Insearch/Article/View/4382
M. Y. S And S. Samsugi, “Sistem Informasi Pendaftaran Online Untuk Supplier Kayu Log (Bulat) Pada Pt Karya Prima Sentosa Abadi Berbasis Web Mobile,” Jurnal Teknologi Dan Sistem Informasi (Jtsi), Vol. 3, No. 2, Pp. 70–76, Jun. 2022, [Online]. Available: Http://Jim.Teknokrat.Ac.Id/Index.Php/Jtsi
F. Firza, M. Zakaria, And Trisna, “Evaluasi Kinerja Pemasok Dengan Pendekatan Vendor Performance Indicator Dan Traffic Light System Di Pt Ika Bina Agro Wisesa,” Sisfo: Jurnal Ilmiah Sistem Informasi, Vol. 5, No. 2, Oct. 2021, Doi: 10.29103/Sisfo.V5i2.6243.
I. Sukendar, W. Fatmawati, And A. Frinzani, “Analisis Kinerja Supplier Berdasarkan Pendekatan Vendor Performance Indicator (Vpi) Menggunakan Metode Analytical Hierarchy Process(Ahp) Di Pt. Idelux Furniture Indonesia,” Dinamika Teknik Industri, Vol. Iv, No. 1, Sep. 2021, Accessed: Feb. 27, 2025. [Online]. Available: Https://Www.Unisbank.Ac.Id/Ojs/Index.Php/Ft1/Article/View/8728
R. Widyanto And M. I. P. Nasution, “Analisis Penerapan Dan Manfaat Sistem Database Dalam Lingkungan E-Commerce: Studi Kasus Pada Aplikasi Shopee,” Kohesi: Jurnal Sains Dan Teknologi, Vol. 3, No. 9, Pp. 91–100, Jun. 2024, Doi: 10.3785/Kohesi.V3i9.4056.
R. F. Ramadhan And R. Mukhaiyar, “Penggunaan Database Mysql Dengan Interface Phpmyadmin Sebagai Pengontrolan Smarthome Berbasis Raspberry Pi,” Jtein: Jurnal Teknik Elektro Indonesia, Vol. 1, No. 2, 2020.
N. Novita, “Manajemen Proyek Sistem Informasi Pengolahan Data Apotek Berbasis Database,” Methosisfo : Jurnal Ilmiah Sistem Informasi, Vol. 2, No. 1, Pp. 9–17, Apr. 2022, Accessed: Feb. 25, 2025. [Online]. Available: Https://Ejurnal.Methodist.Ac.Id/Index.Php/Methosisfo/Article/View/2234
W. Yustika, N. Tusa, Diah Siregar, V. Aprinilova Barus, M. Abiyyu Alwansyah Hasibuan, And J. Manajemen, “Peranan Sistem Database Di Dalam Sistem Informasi Manajemen Pada Uinsu (Universitas Islam Negeri Sumatera Utara),” Surplus: Jurnal Ekonomi Dan Bisnis, Vol. 1, No. 2, Pp. 188–196, Jun. 2023, Accessed: Jan. 24, 2025. [Online]. Available: Https://Yptb.Org/Index.Php/Sur/Article/View/428
Hermanto, A. Fergina, M. I. Thohir, L. S. Parwati, And S. Alhidamkara, “Implementasi Aplikasi Absensi Dengan Qr Code Menggunakan App Sheet Di Sekolah Madrasah Az-Zain,” Jurnal Restikom : Riset Teknik Informatika Dan Komputer, Vol. 6, No. 1, Pp. 130–136, Apr. 2024, Doi: 10.52005/Restikom.V6i1.273.
A. Medikano, S. Rachmawati, A. Sebayang, I. Yuniasih, W. Khafanofa, And H. N. Irmanda, “Jurnal Sistem Informasi Dan Aplikasi Perancangan Aplikasi Persediaan Bahan Baku Mie Ayam Berbasis Android Appsheet Pada Ud Anam Sejahtera,” Jurnal Sistem Informasi Dan Aplikasi, Vol. 1, Sep. 2023.
Ushud Achmad Aditya Ashadul, “Perancangan Aplikasi Pin In Menggunakan Appsheet Dan Google Sheets,” Jurnal Maklumatika, Vol. 11, No. 1, Pp. 1–11, Jan. 2024, Accessed: Feb. 01, 2025. [Online]. Available: Https://Maklumatika.I-Tech.Ac.Id/Index.Php/Maklumatika/Article/View/253
P. Patresia, M. Wali, P. Studi Manajemen Informatika, And F. Ilmu Komputer, “Absensi Online Berbasis Android (Implementasi Platform Appsheet),” Jurnal Indonesia : Manajemen Informatika Dan Komunikasi, Vol. 3, No. 1, Pp. 8–12, Jun. 2022, Doi: 10.35870/Jimik.V3i1.81.
A. A. Wahid, “Analisis Metode Waterfall Untuk Pengembangan Sistem Informasi,” Jurnal Ilmu-Ilmu Informatika Dan Manajemen Stmik, Nov. 2020, Accessed: Feb. 24, 2025. [Online]. Available: Https://Www.Researchgate.Net/Profile/Aceng-Wahid/Publication/346397070_Analisis_Metode_Waterfall_Untuk_Pengembangan_Sistem_Informasi/Links/5fbfa91092851c933f5d76b6/Analisis-Metode-Waterfall-Untuk-Pengembangan-Sistem-Informasi.Pdf
S. Rahmatul Azkiya And U. Sunan Kalijaga Yogyakarta, “Analisis Penerimaan Aplikasi Ikalsel Menggunakan Teori Technology Acceptance Model (Tam),” Unilib : Jurnal Perpustakaan, Vol. 14, No. 1, Pp. 21–31, Mar. 2023, Doi: 10.20885/Unilib.Vol14.Iss1.Art3.
I. M. Sunarya, “Pengaruh Faktor Persepsi Terhadap Minat Penggunaan Layanan Dompet Digital (E-Wallet) Melalui Pendekatan Teori Technology Acceptance Model (Tam),” Jurnal Ilmiah Akuntansi Dan Keuangan, Vol. 5, No. 3, P. 20, Oct. 2022, [Online]. Available: Https://Journal.Ikopin.Ac.Id/Index.Php/Fairvalue
Fadhallah R.A, Wawancara . Jakarta Timur: Unj Press, 2021. Accessed: May 21, 2025. [Online]. Available: Https://Books.Google.Co.Id/Books?Hl=Id&Lr=&Id=Rn4feaaaqbaj&Oi=Fnd&Pg=Pa1&Dq=Keuntungan+Teknik+Wawancara&Ots=Yygmi2335v&Sig=6b-K416i3est8djg2_Cszrr4mau&Redir_Esc=Y#V=Onepage&Q=Keuntungan%20teknik%20wawancara&F=False
A. Yani, D. Setiawan, N. Egi, R. Subagja, And T. Desyani, “Pengujian Aplikasi Reservasi Hotel Di Legreen Hotel & Suite Dengan Metode Black Box Testing Boundary Value Analysis,” Jurnal Teknologi Sistem Informasi Dan Aplikasi, Vol. 3, No. 2, P. 114, Apr. 2020, Doi: 10.32493/Jtsi.V3i2.4686.
Copyright (c) 2025 Amalina Sawitri, Sri Raharso, Sherry Novalia
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
This is an open-access article distributed under the terms of the Creative Commons Attribution-ShareAlike 4.0 International License which permits unrestricted use, distribution, and reproduction in any medium. Users are allowed to read, download, copy, distribute, search, or link to full-text articles in this journal without asking by giving appropriate credit, provide a link to the license, and indicate if changes were made. All of the remix, transform, or build upon the material must distribute the contributions under the same license as the original.
