Drug Inventory Management Information System Using VEN and ABC Methods in a Pharmacy

Tiara Arzhety Lubis; Fathiya Hasyifah Sibarani

doi:10.55537/j-ibm.v6i2.1918

Authors

Tiara Arzhety Lubis Universitas Islam Negeri Sumatera Utara
Fathiya Hasyifah Sibarani Universitas Islam Negeri Sumatera Utara

DOI:

https://doi.org/10.55537/j-ibm.v6i2.1918

Keywords:

Information systems, VEN, ABC, pharmacy, drug inventory management

Abstract

Manual drug inventory management in community pharmacies is vulnerable to recording errors, stock imbalance, and expiration when priority control is not applied systematically. This study developed SiStok, a web-based drug inventory management system integrating VEN (Vital, Essential, Non-Essential) and ABC classifications into a nine-cell priority matrix. Requirements were identified through observation and unstructured interviews with the pharmacy owner and responsible pharmacist. Quantitative analysis used 12 months of stock-movement data (11 May 2025–11 May 2026); after data cleaning, 1,994 unique drug SKUs were analyzed. VEN categories were assigned by the responsible pharmacist, while ABC groups were calculated from consumption value using cumulative thresholds of 80%, 95%, and 100%. The system was implemented using PHP, JavaScript, and MySQL under a waterfall model and verified through 12 black-box scenarios, all valid. Essential items dominated VEN (1,654; 82.95%) and represented IDR 1,535,214,692 (92.51%) of consumption value. Group A contained 350 items (17.55%) but accounted for IDR 1,327,287,230 (79.98%). The ABC-VEN matrix assigns AV, AE, AN, BV, and CV to Priority I; BE, BN, and CE to Priority II; and CN to Priority III. Further evaluation should assess user acceptance, usability, security, performance, reliability, and multi-site implementation.

Downloads

Download data is not yet available.

References

Alanazi, M. Q., Alkhadhairi, E. K., Alrumi, W. H., & Alajlan, S. A. (2024). Reducing pharmaceutical and non-pharmaceutical inventory waste in tertiary hospital: Impact of ABC-VEN analysis in a zero-waste strategy over 7 years. Risk Management and Healthcare Policy, 17, 2659–2675. https://doi.org/10.2147/RMHP.S467230

Amalia, R., Kasmiati, N., Hartono, B., & Daud, A. G. (2026). Analisis ABC-VEN sebagai alat pengendalian persediaan obat untuk meningkatkan efisiensi anggaran farmasi. RIGGS: Journal of Artificial Intelligence and Digital Business, 4(4), 12886–12893. https://doi.org/10.31004/riggs.v4i4.5657

Arief, K., Nafisah, U., & Amalia, A. R. (2025). An analysis of drug inventory control efficiency using Always Better Control, Vital Essential Non-Essential, and Economic Order Quantity methods: A case study at Assalaam Medicare. MEDFARM: Jurnal Farmasi dan Kesehatan, 14(1), 231–242. https://doi.org/10.48191/medfarm.v14i1.578

Damayanti, D., Suprapti, B., Andarsari, M. R., Machin, A., & Hakim, L. N. (2024). ABC-VEN analysis of drug use in outpatients at a neurology department in Indonesia. Pharmacy Education, 24(3), 63–68. https://doi.org/10.46542/pe.2024.243.6368

Fatimah, Gani, S. A., & Siregar, C. A. (2022). Pengendalian persediaan obat dengan metode ABC, VEN dan EOQ di Apotek Medina Lhokseumawe. Industrial Engineering Journal, 11(1). https://doi.org/10.53912/iej.v11i1.722

Gosyanti, E., & Lakoan, M. R. (2023). Gambaran pengelolaan obat rusak dan kadaluarsa di Instalasi Farmasi Rumah Sakit X Bekasi. An-Najat: Jurnal Ilmu Farmasi dan Kesehatan, 1(2), 60–71. https://doi.org/10.59841/an-najat.v1i2.76

Gusnita, E., & Junadi, P. (2025). Optimalisasi pengendalian persediaan farmasi rumah sakit melalui integrasi analisis ABC-VEN: Tinjauan literatur. Jurnal Kesehatan Tambusai, 6(2), 6593–6600. https://doi.org/10.31004/jkt.v6i2.46823

Kulwy, A., Hasan, P., & Irjanto, N. S. (2024). Sistem informasi penjualan obat berbasis website pada Aptotek Cipta Sehat 2 di Kabupaten Keerom. I-Robot Jurnal, 8(2), 6–10. https://doi.org/10.53514/ir.v8i1.508

Kusumawardhana, M. A., Darmanto, E., & Latifah, N. (2024). Sistem informasi perencanaan pengadaan obat menggunakan metode ABC VEN di Apotek Honesty. Jurnal SITECH: Sistem Informasi dan Teknologi, 7(2), 75–84. https://doi.org/10.24176/sitech.v7i2.13445

Mfizi, E., Niragire, F., Bizimana, T., & Mukanyangezi, M. F. (2023). Analysis of pharmaceutical inventory management based on ABC-VEN analysis in Rwanda: A case study of Nyamagabe district. Journal of Pharmaceutical Policy and Practice, 16, 30. https://doi.org/10.1186/s40545-023-00540-5

Nguyen, P. H., Dang, T. V. K., Nguyen, P. T., Vo, T. M. H., & Nguyen, T. T. M. (2022). 5-year inventory management of drug products using ABC-VEN analysis in the pharmacy store of a specialized public hospital in Vietnam. Pharmacia, 69(2), 517–525. https://doi.org/10.3897/pharmacia.69.e84348

Nova, S., Suprati, B., Ratri, D. M. N., Churniawan, R., & Prabowo, B. (2025). Analisis profil obat dengan ABC, VEN dan ABC-VEN untuk optimalisasi pengelolaan obat klinik paru. Jurnal Surya Medika, 11(2), 181–187. https://doi.org/10.33084/jsm.v11i2.9405

Prasetiyo, H., Bachtiar, B., Fitria, L., & Rukmi, H. S. (2023). Analyzing the inventory system of medical medicine in type B pharmaceutical installations at regional hospitals using the ABC-VEN analysis and continuous review system methods. International Journal of Scientific Advances, 4(4), 576–582. https://doi.org/10.51542/ijscia.v4i4.13

Purwaningsih, N. S., Senjaya, A., Sucipto, & Angguni, M. (2022). Analysis of diabetes mellitus drug planning using ABC and VEN methods based on value of use and investment value in pharmacy warehouse General Hospital Insan Permata period January-March 2021. HEME: Health and Medical Journal, 4(2), 93–99. https://doi.org/10.33854/heme.v4i2.984

Rizky, M., Nugraha, F., & Latifah, N. (2025). Sistem informasi inventory dengan metode VEN (Vital, Esensial, Non-Esensial) & metode ABC (Always, Better, Control) untuk pengelolaan persediaan di Apotek Sumber Gemilang. Jurnal SITECH: Sistem Informasi dan Teknologi, 8(1), 49–56. https://doi.org/10.24176/sitech.v8i1.15346

Shen, J., Bu, F., Ye, Z., Zhang, M., Ma, Q., Yan, J., & Huang, T. (2024). Management of drug supply chain information based on “artificial intelligence + vendor managed inventory” in China: Perspective based on a case study. Frontiers in Pharmacology, 15, 1373642. https://doi.org/10.3389/fphar.2024.1373642

Silaen, B. R., Nasution, M., & Muti’ah, R. (2024). Implementation of the ABC analysis to the inventory management. International Journal of Science, Technology & Management, 5(4), 816–825. https://doi.org/10.46729/ijstm.v5i4.1144

Sitanggang, A. B., Ginaris, R. P., & Nurahman, A. (2025). Evaluation of drug planning and procurement using ABC-VEN analysis at Mardi Waluyo Hospital Metro. PHARMADEMICA: Jurnal Kefarmasian dan Gizi, 5(1), 100–106. https://doi.org/10.54445/pharmademica.v5i1.92

Syahputra, R. W., Saptarini, O., & Wijayanti, T. (2025). Pengendalian persediaan obat menggunakan metode analisis ABC-VEN di Instalasi Farmasi RS Pandan Arang Boyolali. Infokes: Jurnal Ilmiah Rekam Medis dan Informatika Kesehatan, 15(2), 101–106.