The Application of Supply Chain Management Concepts to Improve Business Process Efficiency and Data Quality in Financial Reports
Keywords:
Analytical Hierarchy Process (AHP), Business Process Efficiency, Financial Reports, Supply Chain Management, Visual Basic for Applications (VBA).Abstract
Konveksi Puji 25 is a garment manufacturing business facing challenges in supply chain management and financial recording, including suboptimal supplier selection, unstructured raw-material inventory management, and manual financial reporting. These conditions contribute to production delays, operational data inaccuracies, and inefficient business processes. This study aims to design an integrated system based on Supply Chain Management (SCM) concepts to improve business-process efficiency and data quality in financial reports at Konveksi Puji 25. An empirical qualitative case-study approach was employed through direct observation, interviews with the business owner and employees, and documentation of procurement, inventory, production, sales, purchasing, and financial-recording activities. Analytical Hierarchy Process (AHP) was applied to evaluate suppliers based on quality, delivery, price, and warranty and customer service criteria, while System Design and Engineering was used to develop the system architecture through a Context Diagram, Data Flow Diagram (DFD), and Conceptual Design. A VBA-based financial reporting system was developed in Microsoft Excel to integrate transaction recording, inventory, accounts payable and receivable, journals, ledgers, and financial statements. The AHP results identified Supplier 2 as the preferred supplier with a priority value of 52.7%, compared with 47.3% for Supplier 1. The integrated system provides a structured mechanism for improving operational data management, financial reporting, and decision-making. The study demonstrates the practical potential of integrating SCM, AHP, system design, and VBA technology to support more efficient and data-driven business processes in SMEs.
Downloads
References
Anggani, P. C., & Baihaqi, I. (2017). Supplier Selection Using Analytical Hierarchy Process at PT. Indolakto. Jurnal Sains dan Seni ITS, 6(1), D27–D31. https://doi.org/10.12962/j23373520.v6i1.21479
Ariyati, I. M., Ismawati, A. F., Rizqillah, A. I., Wulandari, S. S., & Susanti. (2024). MSMEs Marketing Strategies Through the Use of Social Media: A Systematic Literature Review. IQTISHADUNA: Jurnal Ilmiah Ekonomi Kita, 13(1), 65–84. https://doi.org/10.46367/iqtishaduna.v13i1.1817
Assyarofi, A. A., & Ifada, L. M. (2024). Accounting Information System Management, Business Processes, and the Quality of Financial Reports Mechanism. AKRUAL: Jurnal Akuntansi, 15(2), 104-117. https://journal.unesa.ac.id/index.php/aj/article/download/27444/11146
Axshelby, O. B., & Sharasanti, D. A. (2025). Implementasi Penggunaan Microsoft Excel VBA untuk Membuat Laporan Keuangan Sederhana UMKM XYZ Studio. Jurnal Akuntansi dan Pajak, 25(2), 1-10. https://jurnal.stie-aas.ac.id/index.php/jap/article/view/16234
Cahyono, D. (2017). Sistem Informasi Standard Bill of Material Quantity Genset di PT Conductorjasa Suryapersada. Jurnal INFORM, 2(1), 1–7. https://doi.org/10.25139/ojsinf.v2i1.404
Dashkevich, N., Counsell, S., & Destefanis, G. (2024). Blockchain Financial Statements: Innovating Financial Reporting, Accounting, and Liquidity Management. Future Internet, 16(7), 244. https://doi.org/10.3390/fi16070244
Ekasari, K., Eltivia, N., Pratama, B. B., & Azizah, N. (2022). Improving the Quality of Business Processes with Financial Information Systems. International Journal of Informatics, Economics, Management and Science, 1(2), 125-135. https://doi.org/10.52362/ijiems.v1i2.880
Gunawan, A. A., Fatiha, A. N., Humaira, A. A., & Adistiya, C. (2023). Application of Design Thinking in Designing A Digital Financial Reporting Platform. Jurnal Ilmu Keuangan dan Perbankan (JIKA), 12(2), 257–268. https://doi.org/10.34010/jika.v12i2.9543
Handayani, R. I., & Darmianti, Y. (2017). Pemilihan Supplier Bahan Baku Bangunan dengan Metode Analytical Hierarchy Process (AHP) pada PT. Cipta Nuansa Prima Tangerang. Jurnal Techno Nusa Mandiri, 14(1), 1–8. https://doi.org/10.33480/techno.v14i1.176
Javadi, M., Raeisi, Z., Latifian, A., Shojaee, A., & Jorshary, K. M. (2025). Business Process Management in Financial Performance. Journal of Economics, Finance and Accounting Studies, 7(3), 82-90. https://doi.org/10.32996/jefas.2025.7.8
Kadam, A. A., & Vaidya, T. (2025). Digital Transformation of Supply Chain Quality Management: Integrating AI, IoT, Blockchain, and Big Data. Journal Of Economics, Finance and Accounting Studies, 7(3), 41-49. https://doi.org/10.32996/jefas.2025.7.3.5
Magdalena, L., Febima, M., & Hatta, M. (2026, June). Development of a Supply Chain Information System Framework for Sustainable Manufacturing Operations. In Proceeding International Conference on Religion, Science and Education (Vol. 5, pp. 1461-1468). https://sunankalijaga.org/prosiding/index.php/icrse/article/view/1661
Mbaka, A. O., & Namada, J. M. (2019). Integrated Financial Management Information System and Supply Chain Effectiveness. American Journal of Industrial and Business Management, 9(1), 204-232. https://doi.org/10.4236/ajibm.2019.91014
Nurlina, F., & Sasari, U. (2022). Marketing Mix, Implementation of Marketing Strategies in Health Services: Literature Review. HealthCare Nursing Journal, 4(1), 260–264. https://doi.org/10.35568/healthcare.v4i1.1871
Padmowati, R. D. L. E. (2015). Pengukuran Index Konsistensi dalam Proses Pengambilan Keputusan Menggunakan Metode AHP. Seminar Nasional Informatika (SEMNASIF), 1(5). https://jurnal.upnyk.ac.id/index.php/semnasif/article/view/910
Parhusip, J. (2019). Penerapan Metode Analytical Hierarchy Process (AHP) pada Desain Sistem Pendukung Keputusan Pemilihan Calon Penerima Bantuan Pangan Non Tunai (BPNT) di Kota Palangka Raya. Jurnal Teknologi Informasi: Jurnal Keilmuan dan Aplikasi Bidang Teknik Informatika, 13(2), 18-29. https://doi.org/10.47111/jti.v13i2.25
Perano, M., Cammarano, A., Varriale, V., Del Regno, C., Michelino, F., & Caputo, M. (2023). Embracing Supply Chain Digitalization and Unphysicalization to Enhance Supply Chain Performance: A Conceptual Framework. International Journal of Physical Distribution & Logistics Management, 53(5-6), 628-659. https://doi.org/10.1108/IJPDLM-06-2022-0201
Saaty, T. L. (1980). The Analytic Hierarchy Process: Planning, Priority Setting, Resource Allocation. McGraw-Hill International Book Company.
Sari, D. N. I., & Wulandari, I. (2023). Pengarahan dan Pencatatan Laporan Keuangan UMKM Untung Secara Terkomputerisasi. Bantenese: Jurnal Pengabdian Masyarakat, 5(1), 142–155. https://doi.org/10.30656/ps2pm.v5i1.6524.
Sugito, E., & Kusrini, E. (2023). Enhancing Company Productivity Through Information Sharing in Supply Chain Implementation. Jurnal Teknik Industri, 24(2), 109-126. https://doi.org/10.22219/JTIUMM.Vol24.No2.109-126
Soundappan, S. J. (2022). Integrated Risk Governance Framework for Financial Compliance Supply Chain Resilience and Enterprise Data Management. International Journal of Computer Technology and Electronics Communication, 5(6), 16254-16263. https://doi.org/10.15680/IJCTECE.2022.0506026
Yang, Y., & Yin, Z. (2023). Resilient Supply Chains to Improve the Integrity of Accounting Data in Financial Institutions Worldwide Using Blockchain Technology. International Journal of Data Warehousing and Mining (IJDWM), 19(4), 1-20. https://doi.org/10.4018/ijdwm.320648
