Jurnal Pengabdian dan Kewirausahaan
Vol 10, No 1 (2026): Jurnal Pengabdian dan Kewirausahaan

PERANCANGAN APLIKASI LAPORAN HARGA POKOK PENJUALAN (HPP) BERBASIS MICROSOFT EXCEL VBA PADA UMKM INDAH SONGKET DAN SOUVENIR PALEMBANG

Sari, Yuliana (Politeknik Negeri Sriwijaya)
Dewata, Evada (Politeknik Negeri Sriwijaya)
Periansya, Periansya (Politeknik Negeri Sriwijaya)
Kusuma, Riany Fathika (Politeknik Negeri Sriwijaya)
Wulandary, Wulandary (Politeknik Negeri Sriwijaya)
Azzahra, Della (Politeknik Negeri Sriwijaya)



Article Info

Publish Date
29 Apr 2026

Abstract

The Indah Songket and Souvenir Palembang MSME faced problems in determining the cost of goods sold and financial reporting, which were still done manually. This Community Service Activity aimed to design and implement a Microsoft Excel VBA-based cost of goods sold reporting application that was accurate, fast, and appropriate to the MSME's capacity. The method used was the Waterfall method with stages of analysis, design, implementation, testing, deployment, and maintenance. The results of the activity showed that the application was able to automate the input, calculation, and reporting processes of cost of goods sold quickly and accurately. Partners also gained increased knowledge and skills in financial data management. The Community Service Activity contributed to supporting professional financial management, increasing product competitiveness, and opening up opportunities for replication of similar systems for other MSMEs.

Copyrights © 2026






Journal Info

Abbrev

pengabdian-dan-kewirausahaan

Publisher

Subject

Agriculture, Biological Sciences & Forestry Arts Humanities Computer Science & IT Decision Sciences, Operations Research & Management Economics, Econometrics & Finance Education Environmental Science Health Professions Industrial & Manufacturing Engineering Languange, Linguistic, Communication & Media Public Health Social Sciences Other

Description

Jurnal Pengabdiandan Kewirausahaan adalah jurnal Direktorat Penelitian, Pengembangan & Pengabdian kepada Masyarakat (P3M), yang berisikan kumpulan hasil penelitian dosen, penelitian dosen dan mahasiswa, penelitian mahasiswa dengan tema pengabdian masyarakat dan ...