KPI-BASED ADAPTIVE SCORING MODEL OF MSME PERFORMANCE USING QUANTILE CLIPPING AND DATA-DRIVEN WEIGHTING

  • Abdul Halim Ilmu Komputer, Universitas Bina Bangsa
  • Nurul Chafid Ilmu Komputer, Universitas Bina Bangsa
  • Mochammad Darip Universitas Bina Bangsa
Keywords: MSMEs, KPI, quantile clipping, adaptive weighting, data-driven scoring, robust normalization

Abstract

Monitoring the performance of Micro, Small, and Medium Enterprises (MSMEs) is a challenge for local governments due to the large number of business actors, heterogeneity of business scale, and variations in financial indicators that often contain extreme values. These conditions cause Key Performance Indicators (KPI)-based evaluations to be susceptible to bias when using conventional normalization and weighting. This study aims to develop an adaptive scoring model for MSME performance based on KPIs that is robust to outliers and more objective in indicator weighting. The proposed method integrates quantile clipping at the P5–P95 percentiles to stabilize the KPI distribution, followed by min–max normalization to the range 0–100. Furthermore, KPI weights are determined in a data-driven manner using standard deviation (adaptive weighting) to represent the indicator's contribution based on actual data variations. Experiments were conducted on a dataset of 1,000 MSMEs in Serang City using three main KPIs, namely ROI, Profit Margin, and Growth Rate. The results show that the adaptive weights obtained are ROI 0.308, Profit Margin 0.353, and Growth Rate 0.339. A ranking comparison between fixed weighting and adaptive weighting yielded a Spearman correlation of 0.9879, and two entities changed in the Top 10. These findings indicate that the adaptive method maintains ranking stability while increasing evaluation objectivity. The proposed model is computationally efficient and has potential for application in multi-indicator-based performance monitoring systems.

References

[1] N. W. Bintang and Munawaroh, “Peran Usaha Mikro, Kecil Dan Menengah (UMKM) Di Era Digitalisasi Di Kota Serang,” vol. 3, no. 1, pp. 723–728, Jan. 2025, doi: https://doi.org/10.59435/gjmi.v3i1.1314.
[2] A. Sijabat and R. Z. Ikhsan, “Pengaruh Implementasi Teknologi Informasi pada Usaha Mikro Kecil dan Menengah di Kota Serang,” vol. 5, no. 1, pp. 1–6, Nov. 2024, doi: 10.34306.
[3] ???????????????????? ???????????????? ???????????????????????????? Putri, ???????????????????????? S., and ???????????????????????????? A., “Implementasi Program Pemberdayaan Usaha Menengah, Usaha Kecil dan Usaha MIkro Kecil (UMKM) Pada Dinas Koperasi Usaha Kecil Menengah Perindustrian dan Perdagangan Kabupaten Hulu Sungai Utara,” Jurnal MSDM: Manajemen Sumber Daya Manusia, vol. 2, no. 1, 2025, [Online]. Available: https://ejurnal.stiaamuntai.ac.id/index.php/JMSDM/article/download/1026/814/1838
[4] P. Hidayah, Samsudin, and A. M. Harahap, “Rancang Bangun Sistem Informasi Monitoring UMKM Berbasis Mobile (Studi Kasus: Dinas Koperasi, UKM, Perindustrian dan Perdagangan Kota Medan),” vol. VII, no. 3, pp. 1286–1292, Agustus 2024.
[5] A. Nelson and E. Agustina, “Penerapan Key Performance Indicators dalam Meningkatkan Kinerja Karyawan,” vol. 6, no. 1, pp. 66–76, Mar. 2025, doi: http://doi.org/10.55338/jpkmn.v6i1.5518.
[6] F. I. Olinmah, A. C. Uzoka, C. H. Okolo, K. V. Omotayo, and O. S. Adanigbo, “Real-Time KPI Monitoring Dashboard Model for Merchant Activity Using BI Tools in Financial Applications,” JFMR, vol. 2, no. 2, pp. 168–175, 2021, doi: 10.54660/.IJFMR.2021.2.2.168-175.
[7] Jumadi, B. Handaga, M. T. Nugroho, M. Dai, and G. Ariyanto, “Development of WebGIS-Based Monitoring System for Key Performance Indicators of Muhammadiyah Regional Board in Central Java,” Journal of Community Services and Engagement: Voice of Community, vol. 4, no. 1, pp. 7–14, Apr. 2024.
[8] “SME indicators, benchmarking and monitoring,” OECD. Accessed: Feb. 20, 2026. [Online]. Available: https://www.oecd.org/en/topics/sme-indicators-benchmarking-and-monitoring.html
[9] “SME Performance Review - Internal Market, Industry, Entrepreneurship and SMEs.” Accessed: Feb. 20, 2026. [Online]. Available: https://single-market-economy.ec.europa.eu/smes/sme-strategy-and-sme-friendly-business-conditions/sme-performance-review_en
[10] May Equitozia Eyeregba, Chukwunweike Mokogwu, Somto Emmanuel Ewim, and Titilayo Deborah Olorunyomi, “Integrating visual reporting, analytics, and sustainable dashboards to support decision-making and growth in small and medium enterprises (SMEs),” Int. J. Front. Sci. Technol. Res., vol. 7, no. 2, pp. 090–099, Nov. 2024, doi: 10.53294/ijfstr.2024.7.2.0059.
[11] M. Alharthi, Md. M. Islam, A. G. B. Hamida, G. Dash, and Md. W. Murad, “Determinants of E-commerce Adoption for Saudi MSMEs: Does E-commerce Adoption Impact Financial and Non-Financial Performances?,” vol. 15, no. 6, pp. 83–96, 2025, doi: https://doi.org/10.32479/ijefi.20739.
[12] L. Walaszczyk and S. Dingli, “Online financial calculator as a microlearning tool for entrepreneurs in business modelling,” International Entrepreneurship Review, vol. 9, no. 3, pp. 61–74, Sep. 2023, doi: 10.15678/IER.2023.0903.04.
[13] R. A. Saleh and H. T. Jawad, “The effect of some normalization methods on neural networks and robust methods with the presence of outliers,” International Journal of Computational and Experimental Science and Engineering, vol. 11, no. 3, May 2025, doi: 10.22399/ijcesen.1716.
[14] S. T. Mhlanga and M. Lall, “Normalization Techniques’ Effect on Multi-Criteria Methods for Decision Making,” Current Overview on Science and Technology Research Vol. 2, pp. 62–77, Aug. 2022, doi: 10.9734/bpi/costr/v2/2469A.
[15] A. Aytekin, “Comparative Analysis of the Normalization Techniques in the Context of MCDM Problems,” Decision Making: Applications in Management and Engineering, vol. 4, no. 2, pp. 1–25, Mar. 2021, doi: 10.31181/dmame210402001a.
[16] M. Baydaş and O. E. Elma, “An objectıve criteria proposal for the comparison of MCDM and weighting methods in financial performance measurement: An application in Borsa Istanbul,” Decision Making: Applications in Management and Engineering, vol. 4, no. 2, pp. 257–279, Sep. 2021, doi: 10.31181/dmame210402257b.
[17] E. Purnamasari and D. A. Verano, “Model Data-Driven untuk Prediksi Digitalisasi UMKM Menggunakan GMM dan XGBoost,” Jurnal Pustaka AI (Pusat Akses Kajian Teknologi Artificial Intelligence), vol. 5, no. 2, pp. 204–214, Aug. 2025, doi: 10.55382/jurnalpustakaai.v5i2.984.
[18] A. Alipok, H. Tuli, and V. Taruh, “Analisis Penilaian Kinerja UMKM Dengan Pendekatan Balanced Scorecard,” Jambura Accounting Review, vol. 5, no. 2, pp. 193–202, Sep. 2024, doi: 10.37905/jar.v5i2.131.
[19] M. A. Pratiwi, “Analisis Evaluasi Kinerja UMKM Dengan Metode Balanced Scorecard (Studi Kasus Bintan Snack Millenium),” Manajerial dan Bisnis Tanjungpinang, vol. 4, no. 2, pp. 149–158, 2021, doi: 10.52624/manajerial.v4i2.2237.
Published
2026-06-13
How to Cite
Abdul Halim, Nurul Chafid, & Darip, M. (2026). KPI-BASED ADAPTIVE SCORING MODEL OF MSME PERFORMANCE USING QUANTILE CLIPPING AND DATA-DRIVEN WEIGHTING. TEKNIMEDIA: Teknologi Informasi Dan Multimedia, 7(1), 101-109. https://doi.org/10.46764/teknimedia.v7i1.368
Section
Articles
Abstract viewed = 0 times
PDF (INDONESIA) downloaded = 0 times