PERANCANGAN SISTEM PENGOLAHAN DATA PENJUALAN CATERING MENGGUNAKAN FUNGSI SUMIFS DAN VLOOKUP EXCEL DI VIN’S KITCHEN
DOI:
https://doi.org/10.69714/gqhzbj95Keywords:
Sales Data System, Microsoft Excel, SUMIFS, VLOOKUP, Catering BusinessAbstract
Catering businesses are one type of enterprise that require an accurate and efficient system for managing sales and financial data. Vin’s Kitchen, as a local catering business, still performs manual recording and processing of sales data, which may lead to calculation errors, delays in report preparation, and difficulties in financial data analysis. This study aims to design and analyze a catering sales data processing system based on Microsoft Excel by utilizing the SUMIFS and VLOOKUP functions. The research method used is applied research with a descriptive and case study approach. Data collection techniques include interviews, documentation, observation, and literature study. The results show that the system is able to improve time efficiency by approximately approximately 80% and reduce the error rate by approximately approximately 85%. The SUMIFS function enhances the speed and accuracy of data calculations, while the VLOOKUP function improves data retrieval speed and consistency, making the data processing more effective and integrated. The proposed system can accelerate the preparation of sales reports, minimize recording errors, and facilitate financial data analysis. This study is expected to provide a practical solution for small and medium-scale catering businesses and can be further developed into a larger-scale system.
References
S. Nurrahman and D. E. Rusmanto, “PENERAPAN FUNGSI INDEX MATCH MICROSOFT EXCEL PADA SISTEM PENGELOLAAN ARSIP INVOICE DI PT. XXX,” Jurnal Sistem Informasi dan Sains Teknologi, vol. 7, pp. 33–50, 2025, doi: https://doi.org/10.31326/sistek.v7i1.2122.
S. Nurrahman, A. Saefullah, R. Ar, R. M. Sitohang, R. Syaputra, and M. P. Hakim, “Pemanfaatan Platform Digital E-commerce Tiktok & Shopee Affiliate dalam Manajemen Resiko dan Ketahanan UMKM Budidaya Jangkrik dan Usaha Dimsum,” JCRE: Journal of Community Research and Engagement, vol. 1, pp. 23–35, 2024.
A. Wigunastuti, “PERANCANGAN SISTEM PENDAFTARAN EKSTRAKURIKULER BERBASIS MICROSOFT EXCEL MENGGUNAKAN FITUR VLOOKUP DAN PIVOT TABLE (STUDI KASUS: SMPN 6 BABELAN),” Jurnal Sistem Informasi dan Sains Teknologi, vol. 8, pp. 78–92, 2026, doi: https://doi.org/10.31326/sistek.v8i1.2671.
Jesslin Anastacia and Ugy Soebiantoro, “Penerapan Rumus Lanjutan Ms Excel Terhadap Efektivitas Input Data Sistem Informasi CV Wibowo Jaya Sentosa,” Faedah, vol. 1, no. 3, pp. 93–102, Jul. 2023, doi: 10.59024/faedah.v1i3.255.
Hendra Candra, Syarif Hidayatullah, Reko Adilani, Dian Safitri, and Aura Diana Salsabilah, “IMPLEMENTASI SAK-EMKM BERBASIS MS. EXCEL TERHADAP LAPORAN KEUANGAN UMKM (STUDI KASUS PADA PETANI TOGI DI PULAU BINTAN – KEPULAUAN RIAU),” jrlab, vol. 13, no. 3, pp. 1759–1772, Sep. 2024, doi: 10.34127/jrlab.v13i3.1221.
S. Nurrahman and S. A. Azzahra, “Sistem Pendukung Keputusan Mahasiswa Teladan Dengan Metode SAW Berbasis Microsoft Excel (STIE XXX),” TeknoIS: Jurnal Ilmiah Teknologi Informasi dan Sains, vol. 15, no. 2, 2025, doi: https://doi.org/10.36350/jbs.v15i2.311.
M. R. Ridho, “RANCANG BANGUN SISTEM INFORMASI POINT OF SALE DENGAN FRAMEWORK CODEIGNITER PADA CV POWERSHOP,” vol. 04, no. 02, 2021.
K. Nistrina and A. Rahmania, “SISTEM INFORMASI POINT OF SALE BERBASIS WEBSITE STUDI KASUS: PT BAROKAH KREASI SOLUSINDO (ARTPEDIA),” Jurnal Sistem Informasi, vol. 03, 2021.
Aulia Fitri Maharan, Christian Wiradendi Wolor, and Roni Faslah, “Analisis Sistem Informasi Pengolahan Data Gugus Tugas Pemenangan Caleg X,” jmia, vol. 1, no. 4, pp. 629–636, Aug. 2024, doi: 10.61722/jmia.v1i4.2347.
R. Gunawan, “Peningkatan Ekonomi Masyarakat Dengan Memanfaatkan Sampah Rumah Tangga Melalui Kelompok Sadar Sampah ‘Sri Kandi’ Di Desa Karangtengah, Kecamatan Kemangkon, Kabupaten Purabalingga,” UIN Sunan Ampel, Jawa Tengah, 2018.
pangansari.com, “Catering Adalah Pelayanan Terbaik untuk Makanan,” https://pangansari.com. Accessed: Jan. 12, 2025. [Online]. Available: https://pangansari.com/news/detail/catering-adalah-pelayanan-terbaik-untuk-makanan?cat=hotel
kelasexcel.id, “Fungsi SUMIFS Excel, Rumus Penjumlahan Banyak Kriteria Pada Microsoft Excel,” https://www.kelasexcel.id. Accessed: Jan. 12, 2025. [Online]. Available: https://www.kelasexcel.id/2016/05/fungsi-sumifs-excel.html
kelasexcel.id, “Rumus VLOOKUP Excel, Contoh & Cara Menggunakan Fungsi Vlookup Excel Lengkap,” https://www.kelasexcel.id. Accessed: Jan. 12, 2025. [Online]. Available: https://www.kelasexcel.id/2014/07/fungsi-vlookup-excel-untuk-pencarian-data.html
M. Ridwan, M. F. Aponno, and J. Pelupessy, “PERHITUNGAN DAN PENYAJIAN LAPORAN PENJUALAN MENGGUNAKAN PIVOT TABLE PADA UD. MULTI TEHNIK,” vol. 9, no. 1, 2020.
A. Azmiyati, G. Masitoh, F. W. Agustina, and M. Rohmah, “IMPLEMENTASI KOMPUTER AKUNTANSI BERBASIS EXCEL PADA UMKM SEBAGAI PENCATATAN LAPORAN KEUANGAN SEDERHANA,” Jurnal Akuntansi dan Ekonomi Bisnis (JAEB), vol. 14, no. 01, 2025, doi: https://doi.org/10.33795/jaeb.v14i01.7312.
Moch. Faisal Amin, Achmad Fudhaili, and Roni Yanto, “ANALISIS PENGARUH IMPLEMENTASI TEKNOLOGI AKUNTANSI TERHADAP EFISIENSI PENCATATAN KEUANGAN PADA UMKM,” JIMI, vol. 2, no. 4, pp. 147–152, Aug. 2025, doi: 10.69714/2ms0x935.
Downloads
Published
Issue
Section
License
Copyright (c) 2026 Jurnal Ilmiah Multidisiplin Ilmu
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
