A Web-Based Decision Support System for Inventory Procurement Optimisation Using Pareto Analysis
DOI:
https://doi.org/10.55537/jistr.v5i1.1447Keywords:
Decision Support System, Pharmacy Procurement, Pareto Method, Web-Based Application, Procurement ManagementAbstract
Existing research and practical applications of multi-objective optimization in this domain continue to rely mainly on manual Pareto analysis. Typically, decision makers analyze trade-off curves or a collection of candidate solutions before making subjective configuration choices. This method is time-consuming, difficult to replicate, and subject to bias or inconsistency among evaluators. Furthermore, many publications stop at creating the Pareto front without giving a systematic mechanism for automated selection or assessing the effectiveness of the produced front in comparison to alternative tactics. Data for fast-moving product categories with high profit margins can be processed in a computerized application. These two parameters will provide the best recommendations according to the Pareto principle, which states that 80% of the best income comes from 20% of sources. Pareto Method optimization has proven to narrow the focus of work on the parts that have a significant effect (benefit) for the pharmacy. The manual process used before the research was conducted resulted in one item recommendation in 6 minutes and 20 seconds, while the computerized DSS could process a large amount of item data in just 3 minutes and 15 seconds, with an average gross profit for the top 10 recommended items of 32.1%. This study presents an automated Pareto optimization and selection methodology, which eliminates the need for manual inspection. The system not only creates candidates for Pareto-optimal solutions, but also ranks and selects them based on quantitative criteria. In addition, the framework includes comparative benchmarking, which allows for performance evaluation against baseline methodologies, heuristics, or existing decision procedures. This results in an objective, repeatable, data-driven decision pipeline.
Downloads
References
[1] K. K. R. Indonesia, “Peraturan Menteri Kesehatan Republik Indonesia Nomor 73 Tahun 2016.” 2016.
[2] N. M. I. F. P. Dewi and I. M. A. G. Wirasuta, “Studi Perencanaan Pengadaan Sediaan Farmasi Di Apotek X Berdasarkan Peraturan Menteri Kesehatan Nomor 73 Tahun 2016,” Indonesian Journal of Legal and Forensic Sciences, vol. 11, p. 1, 2021.
[3] A. D. P. Utami, M. Shoaliha, and F. Amirulah, “Gambaran Tingkat Kepuasan Pasien Terhadap Pelayanan Kefarmasian di Apotek Sembuh Kota Bekasi,” Jurnal Ilmiah Pharmacy, vol. 11, p. 101, 2024.
[4] H. S. Salam and W. E. Rusmana, “Analisis Efisiensi Pengelolaan Obat Berdasarkan Metode Pareto/ABC Di Apotek Keluarga 8 Antapani Bandung,” Sosains, p. 1211, 2021.
[5] A. F. Syuhada and B. E. Rukaya, “Gambaran Penjualan Dan Investasi Obat Over-The-Counter Apotek ‘X’ Kelurahan Karang Anyar Kota Tarakan Menggunakan Analisis ABC Tahun 2022,” Jurnal Borneo, vol. 4, no. 2, pp. 47-54, 2024.
[6] M. M. Fathoni and al, “Pelayanan Kefarmasian di Beberapa Apotek di Indonesia Pada Era Pandemi Covid-19,” Jurnal Farmasi Komunitas, vol. 8, p. 45, 2021.
[7] R. Arif and A. Gunawan, “Diagram Pareto dan Diagram Fishbone: Penyebab yang mempengaruhi keterlambatan pengadaan barang di Perusahaan Industri Petrochemicals Cilegon Periode 2020-2022,” Jurnal Riset Bisnis Dan Manajemen Tirtayasa, vol. 7, pp. 1-10, 2023.
[8] P. Polak, M. Pristavka, and K. Kollarova, “Evaluating The Effectiveness Of Production Process Using Pareto Analysis,” Acta Technologica Agriculturae, p. 18, 2015.
[9] A. Sabri, Living The 80/20 Way by Richard Koch. Jakarta: PT Gramedia, 2023.
[10] Sunarto and H. S. WN, Buku Saku Analisis Pareto. Surabaya: Prodi Kebidanan Magetan - Poltekkes Kemenkes Surabaya, 2020.
[11] N. Ayesya, “Analisis Pareto Dalam Perencanaan Produk Di Apotek,” PT. Apotek Digital Indonesia, Jul. 2022.
[12] N. F. Novianti and R. Emelia, “Analisis Pareto Obat Antidiabetes Sebagai Dasar Keputusan Pembelian Bagian Pengadaan Obat Di Apotek Kimia Farma 167 Cimahi,” Sosains, vol. 2, pp. 182-192, 2022.
[13] Lasriana and A. Gunaryati, “Sistem Informasi Berbasis Web Menggunakan Algoritma Squential Search dan Selection Sort,” JIPI, vol. 07, p. 392, 2022.
[14] S. R. WIcaksono, E. S. Krisnadiva, and A. B. Yulliermawan, “Sistem Pendukung Keputusan Pengadaan Perangkat Multimedia Kodam IV/DIP Semarang Dengan Metode Simple Additive Weighting (SAW),” Jurnal Ilmiah Manajemen, Bisnis dan Kewirausahaan, vol. 3, p. 204, 2023.
[15] E. Widodo, A. T. Sasongko, and A. Z. Kamalia, “Klasifikasi Barang Paling Laku (Pareto) Indomaret Untung Suropati 35 (T3M1) Menggunakan Rapidminer Dengan Metode Naive Bayes,” SIGMA, vol. 13, pp. 231-234, 2022.
[16] W. Kom, A. Pohan, and A. Safrudin, “Implementasi Metode Agile Development Dalam Perancangan Sistem Informasi Pemesanan Menu Pada Restoran,” in SINTA, 2022, p. 106,.
[17] C. E. N. Marita and Z. B. Ni’am, “Pengaruh Current Ratio Dan Gross Profit Magin Terhadap Pertumbuhan Laba Pada Perusahaan Food And Beverage,” Sinta, vol. 6, p. 1, 2023.
[18] P. Li and A. Tuzhilin, “Deep Pareto Reinforcement Learning for Multi-Objective Recommender System.” 2024.
[19] M. Alkiayat, “A Practical Guide to Creating a Pareto Chart as a Quality Improvement Tool,” JQSH, vol. 4, no. 3, pp. 83-84, 2021.
[20] A. Mokrini and T. Aouam. "A Decision-Support Tool For Policy Makers In Healthcare Supply Chains To Balance Between Perceived Risk In Logistics Outsourcing And Cost-Efficiency." Expert Syst. Appl., 201 (2022): 116999. https://doi.org/10.1016/j.eswa.2022.116999.
[22] H. Smedberg and S. Bandaru. "Interactive Knowledge Discovery and Knowledge Visualization For Decision Support in Multi-Objective Optimization." Eur. J. Oper. Res., 306: 1311-1329. 2022. https://doi.org/10.1016/j.ejor.2022.09.008.
[23] C. Franco and E. A. -Lizarazo. "Optimization Under Uncertainty Of The Pharmaceutical Supply Chain In Hospitals." Computers & Chemical Engineering, 135:106689. 2020. https://doi.org/10.1016/j.compchemeng.2019.106689.
[24] J. Corny, A. Rajkumar, O. Martin, X. Dode, J. Lajonchère, O. Billuart, Y. Bézie and A. Buronfosse. "A Machine Learning–Based Clinical Decision Support System To Identify Prescriptions With A High Risk of Medication Error." Journal of the American Medical Informatics Association : JAMIA, 27:1688-1694. 2020. https://doi.org/10.1093/jamia/ocaa154.
[25] V. M. M. Siregar, S. Sonang and E. Damanik. "Sistem Pendukung Keputusan Penentuan Pelanggan Terbaik Menggunakan Metode Weighted Product." Jurnal Teknik Informasi dan Komputer (Tekinkom) 2021. https://doi.org/10.37600/tekinkom.v4i2.392.
[26] C. Ash, C. Diallo, U. Venkatadri and P. Vanberkel. "Distributionally Robust Optimization Of A Canadian Healthcare Supply Chain To Enhance Resilience During The COVID-19 Pandemic." Computers & Industrial Engineering, 168: 108051 - 108051. 2022. https://doi.org/10.1016/j.cie.2022.108051.
[27] A. Pentrakan, C. -C. Yang and W. Wong. "How Well Does A Sequential Minimal Optimization Model Perform In Predicting Medicine Prices For Procurement System?." International Journal of Environmental Research and Public Health, 18, 2021. https://doi.org/10.3390/ijerph18115523.
[28] K. Qiu, J. Chen, S. Ashraf and T. Shahid. "Strategic Decision Support System With Probabilistic Linguistic Term Sets: Extended CRADIS Approach for Supply Chain Risk Management in Sports Industry." IEEE Access, 13: 32853-32862. 2025. https://doi.org/10.1109/access.2024.3416391.
[29] P. S. Dosantos, A. Bouchet, I. M. Collado and S. Montes. "OPSBC: A Method To Sort Pareto-Optimal Sets Of Solutions In Multi-Objective Problems." Expert Syst. Appl., 250:123803. 2024. https://doi.org/10.1016/j.eswa.2024.123803.
[30] F. P. Dewanti, S. Setiyowati and S. Harjanto. "Prediksi Persediaan Obat Untuk Proses Penjualan Menggunakan Metode Decision Tree Pada Apotek." Jurnal Teknologi Informasi dan Komunikasi (TIKomSiN) 2022. https://doi.org/10.30646/tikomsin.v10i1.604.
[31] C. Bogaerts, N. Schoenmaekers, M. Haems, M. Storme and H. De Loof. "A quality Improvement Study Of The Implementation And Initial Results Of A Pragmatic Clinical Decision Support System In The Community Pharmacy Setting." International Journal of Clinical Pharmacy, 46:141-149. 2023. https://doi.org/10.1007/s11096-023-01648-z.
[32] M. Puruhito, & A. Falani. "Decision Support System For Developing Application For Pharmaceutical Supplies Using The MMSL And Pareto Law Methods." , 4, 12-22. 2021. https://doi.org/10.29138/ijeeit.v4i1.1329.
[33] M. Fernández, P. Chanfreut, I. Jurado, and J. Maestre. A Data-Based Model Predictive Decision Support System for Inventory Management in Hospitals. IEEE Journal of Biomedical and Health Informatics, 25, 2227-2236. 2020. https://doi.org/10.1109/jbhi.2020.3039692.
Downloads
Published
How to Cite
Issue
Section
License
Copyright (c) 2026 Ibnu Fajar , Sitti Rachmawati Yahya, Farah Aqilah Bohani, Nor Nadiah Yusof
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
