Adopting Excel-Macro and POM-QM Automation System to Enhance Operational Efficiency in an Herbal MSME
DOI:
https://doi.org/10.38035/jemsi.v7i3.7202Keywords:
Digital Transformation, Excel-Macro, POM-QM, Production Automation, Production Time EfficiencyAbstract
This study designs and implements a production automation system using Excel-Macro integrated with POM-QM to improve production and time efficiency in the micro-scale herbal enterprise Sekar Utami Toga, located in South Tangerang, Banten, Indonesia. Building upon previous research on linear programming optimization, this study integrated the optimization model within an automated workflow. A quantitative descriptive pre-post design was used to compare production performance before (2024) and after (2025) automation. Data were collected through observation, time studies, interviews, and production records. The findings reveal substantial performance improvements: total output increased by 42.5%, profit margins rose by 27%, and production capacity utilization expanded by 34.6%. Data entry errors decreased by 90%, and documentation time reduced by 98.9%. Efficiency ratio analysis indicated moderate gains of 0.11% in production efficiency and 0.07% in time efficiency. Although relatively small, these improvements are significant for MSMEs due to higher productivity and output volume. A paired t-test confirmed a statistically significant enhancement in efficiency (t (7) = 4.08, p = 0.004 < 0.05). The study concludes that low-cost automation using Excel-Macro and POM-QM can effectively enhance operational efficiency, accuracy, and decision-making, offering a practical model for MSME digital transformation in Indonesia’s herbal industry.
References
Adi, Y. S. (2025) “Optimalisasi Keuntungan dan Pemanfaatan Waktu Kerja Pada UMKM Kapsul Herbal Sekar Utami Toga Tangerang Selatan Banten Menggunakan Program Linear Metode Simplek Dengan Aplikasi Komputer POM QM”, Ranah Research: Journal of Multidisciplinary Research and Development, 7(6), pp. 4242-4250. https://doi.org/10.38035/rrj.v7i6.1771
Akhmad. (2018). Manajemen Operasi: Teori dan Aplikasi dalam Dunia Bisnis. Yogyakarta: Azkia Publishing.
Belz, F. M., & Binder, J. K. (2017). Sustainable entrepreneurship: A convergent process model. Business Strategy and the Environment, 26(1), 1–17. https://doi.org/10.1002/bse.1887
Cheng, C.-Y., Pourhejazy, P., Hung, C.-Y., & Yuangyai, C. (2021). Smart monitoring of manufacturing systems for automated decision-making: A multi-method framework. Sensors, 21(20), 6860. https://doi.org/10.3390/s21206860
Dantzig, G. B. (2014). Linear programming. Operations Research, 50(1), 42–47.
Heizer, J., Render, B., & Munson, C. (2020). Operations Management (14th ed.). Pearson Education.
Heizer, J., & Render, B. (2015). Manajemen Operasi: Manajemen Keberlangsungan dan Rantai Pasokan. Jakarta: Salemba Empat.
International Society of Automation. (n.d.). What is automation? https://www.isa.org/about-isa/what-is-automation
Kalwar, M. A., Wassan, A. N., Khan, M. A., Wadho, M. H., Shaikh, S. A., & Marri, H. B. (2023). Automation of production plan generating workbook at a leather footwear company of Lahore Pakistan by using VBA in Microsoft Excel. Journal of Applied Research in Technology & Engineering, 4(2), 111-129. https://doi.org/10.4995/jarte.2023.18941
OECD. (2021). The digital transformation of SMEs. Organisation for Economic Co-operation and Development.
OECD. (2022). Digital Transformation of SMEs: Policy and Practices. Paris: OECD Publishing.
Ruminta. (2014). Matriks Persamaan Linier dan Pemprograman Linier (Edisi Revisi). Bandung: Rekayasa Sains.
Sarfiah, S., Atmaja, H., & Verawati, D. (2019). UMKM sebagai pilar membangun ekonomi bangsa. Jurnal REP (Riset Ekonomi Pembangunan), 4(2), 1–189. https://doi.org/10.31002/rep.v4i2.1952
Suci, Y. R. (2017). Perkembangan UMKM (Usaha Mikro, Kecil, dan Menengah) di Indonesia. Jurnal Cano Ekonomos, 6(1), 51–58.
Weiss, H. J. (2018). POM-QM for Windows: Version 5 manual. Pearson Education.
WHO. (2021). Global Report on Traditional and Complementary Medicine. Geneva: World Health Organization.
World Bank. (2022). Digitalizing SMEs to Boost Competitiveness (Finance, Competitiveness & Innovation Global Practice). World Bank Group.
Downloads
Published
How to Cite
Issue
Section
License
Copyright (c) 2026 Yakobus Saktono Adi
This work is licensed under a Creative Commons Attribution 4.0 International License.
Hak cipta :
Penulis yang mempublikasikan manuskripnya di jurnal ini menyetujui ketentuan berikut:
- Hak cipta pada setiap artikel adalah milik penulis.
- Penulis mengakui bahwa Jurnal Ekonomi Manajemen Sistem Informasi (JEMSI) berhak menjadi yang pertama menerbitkan dengan lisensi Creative Commons Attribution 4.0 International (Attribution 4.0 International CC BY 4.0) .
- Penulis dapat mengirimkan artikel secara terpisah, mengatur distribusi non-eksklusif manuskrip yang telah diterbitkan dalam jurnal ini ke versi lain (misalnya, dikirim ke repositori institusi penulis, publikasi ke dalam buku, dll.), dengan mengakui bahwa manuskrip telah diterbitkan pertama kali di Jurnal Ekonomi Manajemen Sistem Informasi (JEMSI).
