Pendampingan Pembuatan Aplikasi Penjualan Menggunakan Microsoft Excel Pada UMKM Kripik Tempe Sanan

Priska Wulan Ndari; Yulanda Elis Meyana; Rini Aprilia Lestari

doi:10.54147/jpkm.v5i01.893

Priska Wulan Ndari Sekolah Tinggi Teknik Malang
Yulanda Elis Meyana Sekolah Tinggi Teknik Multimedia Internasional Malang, Malang, Jawa Timur
Rini Aprilia Lestari Sekolah Tinggi Teknik Multimedia Internasional Malang, Malang, Jawa Timur

DOI: https://doi.org/10.54147/jpkm.v5i01.893

Keywords: sales applications, microsoft excel, MSME, technology

Abstract

The increasing use of information and communication technology (ICT) has played an important role in developing Micro, Small and Medium Enterprises (MSMEs) in various sectors. While ICT has great potential to develop MSMEs, there are still challenges such as start-up costs, training, and information security that need to be overcome. However, with the right investment and a good strategy, MSMEs can leverage these technological advantages for growth and success. Sanan Tempe Chips SMEs often have limited resources, including funds, personnel, and technology infrastructure. Purchasing, developing, and maintaining financial applications require significant investment, which these SMEs have not been able to accommodate. This community service activity aims to provide practical solutions for Kripik Tempe Sanan SMEs through assistance in making simple sales applications using Microsoft Excel. Therefore, assistance in making simple sales applications using Microsoft Excel can be a viable alternative for MSMEs with limited resources to improve financial management and business competitiveness. The results of community service activities are able to improve efficiency in recording sales, inventory, and financial reporting of Kripik Tempe Sanan MSMEs. MSME owners and employees feel more confident in using this application after going through training and technical guidance.

References

Adnan, T., Praptiningsih, N., & Kalbuana, N. (2024). Analyzing The Impact Of Research And Community Service Programs Of Higher Education Institutions On Local Economic Empowerment In Indonesia: A Literature Review Study. International Journal of Teaching and Learning (INJOTEL), 2(1), 210–222.

Arnas, Y., Arti, E. S., & Kalbuana, N. (2024). Analisis Five Forces Porter dalam Evaluasi Produktivitas Penelitian Dosen di Perguruan Tinggi Kedinasan. Journal of Education Research, 5(1), 158–169.

Arti, E. S., Widiarto, H., Endrawijaya, I., Kalbuana, N., & Anggraini, D. (2024). Analisa Kebutuhan Kompetensi Lulusan PPIC terhadap Perusahaan Penerbangan. Journal on Education, 06(02), 13843–13851.

Bakhri, S., Hanif, F., & Haidir, A. (2020). Rancang Bangun Aplikasi Kasir Penjualan Susu Berbasis Web Pada Alomgada Kids Jakarta. IJCIT (Indonesian Journal on Computer and Information Technology), 5(1), 47–54.

Hendriarto, P., Mursidi, A., Kalbuana, N., Aini, N., & Aslan, A. (2021). Understanding the Implications of Research Skills Development Framework for Indonesian Academic Outcomes Improvement. Jurnal Iqra’ : Kajian Ilmu Pendidikan, 6(2), 51–60. https://doi.org/10.25217/JI.V6I2.1405

Intelektual, D. K., Indonesia, R., & Sani, A. (n.d.). Model Kesiapan dan Adopsi Teknologi Informasi di Antara Usaha Kecil Menengah (UKM) Indonesia. (000119314).

Kadeni, & Srijani, N. (2020). Peran UMKM (Usaha Mikro Kecil Menengah) Dalam Meningkatkan Kesejahteraan Masyarakat. Jurnal Ilmiah Ekonomi Dan Pembelajarannya, 8(2), 191–200.

Kalbuana, N. (2024). Examining Customer Content With Indomaret Pointku Application Services Through E-Servqual. Journal of Data Analytics, Information, and Computer Science (JDAICS), 1(1), 22–30.

Kalbuana, N., & Kurnianto, B. (2024). Design of Microcontroller Sensor-Based Smoke Detection System as an Effort for Fire Prevention Desain Sistem Deteksi Asap Berbasis Sensor Mikrokontroler Sebagai Upaya Pencegahan Kebakaran. MALCOM: Indonesian Journal of Machine Learning and Computer Science, 4(January), 266–272.

Kardi, Pamuraharjo, H., Kalbuana, N., & Kurnianto, B. (2023). The Nexus Of Artificial Intelligence, Blockchain Technology, And Human Capital In Digital Marketing Strategy: An Exploratory Study On The Integration, Ethical Implications, And Future Prospects. International Journal of Economic Literature, 1(1), 12–22.

Kurniawan, W., Gunawan, F., Solihin, S., Saputra, S. T., Yusmana, W., Kalbuana, N., & Supri, S. (2023). Pelatihan pencegahan dan penanggulangan bahaya kebakaran di fire station Bandar Udara Internasional. Penamas: Journal of Community Service, 3(2), 66–76.

L., E. A. W. E., Probowulan, D., & Murwanti, R. (2020). Eksistensi Pencatatan Keuangan Berdasarkan SAK EMKM pada UMKM dengan Aplikasi Microsoft Excel. Budgeting: Journal of Business, Management and Accounting, 2(1), 398-412.

Lamtiar, S., Yoga, M. F., & Kalbuana, N. (2024). Perancangan Sistem Presensi Permakanan Taruna Menggunakan Kartu RFID Berbasis Internet of Things. Journal on Education, 06(02), 13864–13874.

Nasution, A. P., & Pristiyono. (2019). Antisipasi Ketahanan Ekonomi Keluarga Di Kabupaten Labuhanbatu Selatan. ECOBISMA (Jurnal Ekonomi, Bisnis Dan Manajemen )., 6(1), 90.

Pamuraharjo, H., Kardi, Kalbuana, N., & Abdusshomad, A. (2023). Catalyzing Educational Transformation In The Digital Age : Analyzing The Technological Implications On Millennial. International Journal of Teaching and Learning (INJOTEL), 1(3), 234–247.

Rais, A. H., & Usman, A. (2020). Effect of Eco-Efficiency and Corporate Social Performance on Firm Value with Financial Performance as Intervening Variables (Study on Mining and Manufacturing Companies Listed on the Indonesia Stock Exchange). International Journal of Innovative Science and Research Technology, 5(12), 510–522.

Rostiani, Y., & Juliana, R. (2021). Perancangan Aplikasi Akuntansi Penerimaan Dan Pengeluaran Kas Berbasis Web (Studi Kasus Pada STMIK Rosma). Jurnal Interkom: Jurnal Publikasi Ilmiah Bidang Teknologi Informasi Dan Komunikasi, 16(01).

Setiawan, P. A. A., & Suarmanayasa, I. N. (2022). Pengaruh Literasi Keuangan dan Sikap Keuangan terhadap Pengelolaan Keuangan UMKM di Kecamatan Gerokgak pada Masa Pandemi COVID-19. Jurnal Ilmiah Akuntansi Dan Humanika, 12(2), 156–164.

Shobaruddin, M. (2020). Strategi pengembangan Usaha Mikro Kecil Menengah (UMKM) di Kota Malang melalui literasi informasi. Jurnal Kajian Informasi & Perpustakaan, 8(2), 151. https://doi.org/10.24198/jkip.v8i2.26141

Sisdianto, E., Razimi, M. S. A., Masykur, R., Mei Sari, R. D., & Robiansyah, A. (2023). The Effect of Environmental Performance on Financial Performance with Islamic Corporate Social Responsibility (ICSR) as Intervening Variable. Jurnal Ilmiah Akuntansi, 8(1), 191–205. https://doi.org/10.23887/jia.v8i1.52442

Sundoro, Kalbuana, N., & Cahyadi, C. I. (2024). Strategic Trajectories: An In-Depth Exploration of Complex Landscape of Higher Education In Indonesia. International Journal of Teaching and Learning (INJOTEL), 2(1), 236–250.

Syarifah, A. H., & Fauziyah. (2017). Pengaruh Adopsi Teknologi Informasi Pada Peningkatan Daya Siang Usaha Kecil Dan Menengah. Jurnal Manajemen Bisnis, 8(2), 181–199.

Tjahjani, F., Tanoto, S. S., & Kalbuana, N. (2024). Devidend Policy Moderates Growth Opportunity, Free Cash Flow, And Debt Policy on Firm Value. International Journal of Economic Literature (INJOLE), 2(1), 158–166.

Yenni Arnas, Ika Endrawijaya, & Nurudin Siraj. (2022). Implementation of the Use of the Guide Note Learning Method Taking in Mathematics. EduLine: Journal of Education and Learning Innovation, 2(2), 140–145. https://doi.org/10.35877/454ri.eduline881

Yusuf, A. M., Rostiani, Y., & Lestari, L. D. (2021). Sistem Informasi Akuntansi Kas Kecil Dengan Sistem Fluktuatif Pada PT. Hunu Osias Padmada Eara Karawang Menggunakan Macro VBA Microsoft Excel. Seminar Nasional : Inovasi & Adopsi Teknologi, 20–29.