Microsoft Excel Dashboard Design to Support Financial Management : The Case of SMEs Mel Kitchen Malang
DOI:
https://doi.org/10.54964/satyamandiri.v11i2.520Abstract
This research aimed to design a Microsoft Excel-based financial database and dashboard system tailored
to the needs of MSME Mel Kitchen, a culinary business and the primary user of the system. The design
focused on improving the efficiency and structure of its financial recording and management. The design
focused on improving the efficiency and structure of its financial recording and management. Primary data
were collected through interviews and observations to understand the user needs. The system was
developed using the ADDIE model (Analyze, Design, Develop, Implement, and Evaluate). The results of
the user needs analysis showed that the user needed a computerized financial data recording and
visualization system to facilitate its financial management in a more structured and easy-to understand
manner. Based on the analysis and development process, this research resulted in a Microsoft Excel-based
financial database and dashboard system which consisted of several features such as sales input, expense
tracking, cash flow monitoring, raw material inventory, outgoing stock management, and visual
dashboards in the form of graphs and charts. Evaluation by both a technology expert and the end user
confirmed that the system was feasible to use and effective for Mel Kitchen’s financial management needs.
References
Adan, R., Patricia, E., & David, R. (2022). Analysis and Design of the Web Game on Descriptive Statictic Through The ADDIE Model, Data Science and Machine Learning. International Journal of Education in Mathematics, Science, and Technology, 245-260.
Ariandi, M., & Puteri, S. (2022). Analisis Visualisasi Data Kecamatan Kertapati menggunakan Tableau Public. Jurnal Jupiter, 366-373.
Bahiu, E., Saerang, I., & Untu, V. (2021). Pengaruh Literasi Keuangan, Pengelolaan Keuangan Terhadap Keuangan UMKM Di Desa Gemeh Kabupaten Kepulauan Talaud. Jurnal EMBA : Jurnal Riset Ekonomi, Manajemen, Bisnis, dan Akuntansi, 1819-1828.
Dewi, I., Pandin, M., & GS, A. (2022).
Peningkatan Kinerja UMKM Melalui Pengelolaan Keuangan. Jurnal Ekonomi Akuntansi, 23- 36.
Hidayat, K., Gunawan, E., & Gunawan,
Y. (2022). Analisis Strategi Pengelolaan Keuangan Bisnis di Masa Pandemi pada Pelaku Bisnis Generasi Milenial di Wilayah Bandung. Jurnal Akuntansi, 45-55.
Ismail, S., Irfan, M., & Harriansyah. (2025). Perancangan Dashboard Berbasis Web Untuk Visualisasi Data Penjualan Pada UMKM ( Studi Kasus: Toko Wyloz). Jurnal Rekayasa Aplikasi, Multimedia Dan Sistem Informasi (Reklamasi), 11-16.
Kuswadi. (2005). Cara Mudah Memahami Angka dan Manajemen Keuangan Bagi Orang Awam. Jakarta: Elex Media Komputindo.
Lastiansah, S. (2012). Pengertian User Interface. Jakarta: PT. Elex Media Komputindo.
Pratiwi, D. (2019). Visualisasi Data : Teori Dan Penerapannya.
Perancangan Dashboard Berbasis Microsoft Excel Untuk Pengelolaan Keuangan ( Studi Kasus :
UMKM Mel Kitchen Malang)
Ponorogo: Uwais Inspirasi Indonesia.
Prayoga, E., & Delima, R. (2022). Perancangan dan Implementasi Dashboard Keuangan Persekutuan Joy Indonesia dengan Metode User Centered Design. JUTEI, 95-102.
Santika, S., Sari, D. R., Sorongan, E., Finanto, H., & Novri, F. (2024). Otomasi Pengelolaan Anggaran Pada UMKM Menggunakan Pendekatan Macro Excel Berbasis Dashboard View. Jurnal Pengabdian Masyarakat: Ekonomi dan Bisnis Digital (JPMEBD), 267-281.
Wiwesa, N. (2021). User Interface Dan User Experience Untuk Mengelola Kepuasan Pelanggan. Jurnal Sosial Humaniora Terapan, 17-31.
Zed, E. Z., Rizkiyah, A., Zaien, R. N.,
Jannah, R. R., Sunaji, A. E., & Reza, A. F. (2024). Pelatihan Digital Marketing Dalam Upaya Pengembangan Usaha Berbasis Teknologi Pada Umkm di Kecamatan Cibarusah. Jurnal Inovasi Global, 460-473.
Downloads
Published
How to Cite
Issue
Section
License
Copyright (c) 2025 Jurnal Satya Mandiri Manajemen dan Bisnis
This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.
