Article Per Year (5 Year)
p-Index From 2021 - 2026
0.23
P-Index
This Author published in this journals
All Journal JURNAL SATYA MANDIRI MANAJEMEN DAN BISNIS
Yosephina Dwita Ayuningtyas
Unknown Affiliation
Decision Sciences, Operations Research & Management Economics, Econometrics & Finance Social Sciences

Published : 1 Documents Claim Missing Document
Claim Missing Document
Check
Articles

Found 1 Documents
Search

 1 
The Perancangan Dashboard Berbasis Microsoft Excel Untuk Pengelolaan Keuangan (Studi Kasus : UMKM Mel Kitchen Malang) Yosephina Dwita Ayuningtyas
Jurnal Satya Mandiri Manajemen dan Bisnis Vol 11 No 2 (2025): Volume 11 Nomor 2 Tahun 2025
Publisher : Pasca Sarjana Universitas Satya Negara Indonesia

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.54964/satyamandiri.v11i2.520

Abstract

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.
Co-Authors