An Integrated Recording and Monitoring Solution for Pharmaceutical and Medical Device Logistics: Development and Implementation at the Yogyakarta Health Office
DOI:
https://doi.org/10.25047/ijhitech.v4i2.7411Keywords:
System Developmet, Recording System, Pharmaceutical and Medical Device Logistics, Monitoring Dashboard, User Centered DesignAbstract
Effective recording and monitoring systems are essential for managing pharmaceutical and medical device logistics and supporting healthcare services. However, logistics records at the Yogyakarta Special Region Health Office were maintained using multiple recording media, resulting in fragmented data, repetitive data entry, and difficulties in stock and expiration date monitoring. This study aimed to develop and initially implement an integrated recording system and monitoring dashboard based on user requirements. A research and development approach was applied using the Analysis, Design, Development, Implementation, and Evaluation model with a user centered design approach. Data were collected through observations, document reviews, and interviews, while system evaluation was conducted through a focus group discussion. Six participants were involved, comprising one Head of Pharmacy, Food, Beverage, and Medical Devices Section, one Technical Policy Reviewer, two Health Service Managers, one Operational Service Operator, and one Operational Service Manager. The developed system integrates logistics recording using Google Spreadsheet and monitoring using Google Looker Studio. Initial implementation showed that users were able to perform routine logistics recording and monitoring activities. Focus group discussion findings indicated that the system was aligned with the identified user requirements and supported recording, reporting, monitoring, and document preparation. The main limitation was the qualitative evaluation without quantitative measurement of efficiency or usability.
References
[1] B. A. Mekonnen, M. C. Worku, and B. B. Tefera, “Evaluation of logistics management information system and availability of non-program tracer drugs in public health facilities in Bahir Dar City, Northwest Ethiopia,” PLoS ONE, vol. 19, no. 4, Art. no. e0302319, 2024, doi: 10.1371/journal.pone.0302319.
[2] A. Zakiyahartanti, “Perbandingan antara perhitungan perencanaan kebutuhan dengan pemakaian obat pada logistik farmasi di Rumah Sakit Ibu dan Anak ‘Aisyiyah Bangkalan,” B.S. thesis, Universitas Muhammadiyah Surabaya, Surabaya, Indonesia, 2025.
[3] I. A. N. Yuliastuti and N. P. E. S. S. Dewi, “Pembuatan laporan mutasi barang konsinyasi dan kas kecil digital serta pemanfaatan media sosial sebagai platform dalam pemasaran pada Apotek K24 Sidakarya,” Prosiding Seminar Nasional Pengabdian Masyarakat (SENEMA), vol. 3, no. 1, pp. 166–177, 2024.
[4] R. Najiyah, E. Eriswanto, and T. Kartini, “Analisis sistem pengendalian internal atas persediaan obat (studi kasus di Puskesmas Bojonggenteng Kabupaten Sukabumi),” Equilibrium: Jurnal Ilmiah Ekonomi, Manajemen dan Akuntansi, vol. 9, no. 2, 2020, doi: 10.35906/je001.v9i2.574.
[5] W. Larutama, A. P. R. Lubis, A. Suyatno, and N. H. Camellia, “Information system design in warehouse inventory control,” Journal of Logistics and Supply Chain, vol. 3, no. 1, pp. 35–44, 2023, doi: 10.17509/jlsc.v3i1.62069.
[6] C. Barbieri, L. Neri, S. Stuard, F. Mari, and J. D. Martín-Guerrero, “From electronic health records to clinical management systems: How the digital transformation can support healthcare services,” Clinical Kidney Journal, vol. 16, no. 11, pp. 1878–1884, 2023, doi: 10.1093/ckj/sfad168.
[7] A. Zainudin, A. P. Hadi, and A. Priyadi, “Sistem informasi persediaan obat berbasis web di Rumah Sakit Bina Kasih,” Jurnal Ilmiah Sistem Informasi, vol. 3, pp. 30–34, 2024, doi: 10.51903/2xwvpm83.
[8] A. Kazemi, R. Rabiei, H. Moghaddasi, and G. Deimazar, “Pharmacy information systems in teaching hospitals: A multi-dimensional evaluation study,” Healthcare Informatics Research, vol. 22, no. 3, pp. 231–237, 2016, doi: 10.4258/hir.2016.22.3.231.
[9] R. Harte et al., “A human-centered design methodology to enhance the usability, human factors, and user experience of connected health systems: A three-phase methodology,” JMIR Human Factors, vol. 4, no. 1, 2017, doi: 10.2196/humanfactors.5443.
[10] D. Lanter and R. Essinger, “User-centered design,” in International Encyclopedia of Geography: People, the Earth, Environment and Technology, 2017, doi: 10.1002/9781118786352.wbieg0432.
[11] T. D. A. D. Dakhilullah and B. Suranto, “Penerapan metode user centered design pada perancangan pengalaman pengguna aplikasi I-Star,” AUTOMATA, vol. 3, no. 2, 2022.
[12] Hariansyah, H. Fajri, and B. Wulandari, “Implementasi metode user-centered design dalam perancangan UI/UX purwarupa aplikasi LacakIn,” Jurnal Informatika dan Teknik Elektro Terapan, vol. 12, no. 3, pp. 2029–2042, 2024, doi: 10.23960/jitet.v12i3.4602.
[13] E. R. Subhiyakto, Y. P. Astuti, and L. Umaroh, “Perancangan user interface aplikasi pemodelan perangkat lunak menggunakan metode user centered design,” KONSTELASI: Konvergensi Teknologi dan Sistem Informasi, vol. 1, no. 1, pp. 145–154, 2021, doi: 10.24002/konstelasi.v1i1.4266.
[14] J. Nielsen, “The use and misuse of focus groups,” IEEE Software, vol. 14, no. 1, pp. 94–95, 1997, doi: 10.1109/52.566434.
[15] K. P. Adisti and I. Nugraha, “Implementasi sistem dashboard untuk visualisasi data monitoring penagihan dengan menggunakan Google Looker Studio,” JATI (Jurnal Mahasiswa Teknik Informatika), vol. 9, no. 2, pp. 1854–1861, 2025, doi: 10.36040/jati.v9i2.12744.
[16] J. Asher and E. P. Rachmawati, “Visualisasi data operasi SAR BASARNAS di Indonesia menggunakan Google Looker Studio,” The Indonesian Journal of Computer Science, vol. 13, no. 2, pp. 3056–3068, 2024, doi: 10.33022/ijcs.v13i2.3672.
[17] T. P. Jaya, Y. Prihati, and J. Gondohanindijo, “Dashboard pemantauan inventori pada Mixue Erlangga Simpang Lima berbasis web,” INTECOMS: Journal of Information Technology and Computer Science, vol. 7, no. 5, pp. 1510–1519, 2024, doi: 10.31539/intecoms.v7i5.11407.
[18] C. J. I. Soge, D. F. Sengkey, and N. J. Tuturoong, “Monitoring dashboard for wireless network users at Sam Ratulangi University,” Jurnal Teknik Informatika, vol. 20, no. 1, pp. 69–76, 2025.
[19] D. Sunardi and C. Rozali, “Pelatihan visualisasi data kependudukan menggunakan Looker Studio pada Kelurahan Duren Seribu,” Jurnal Inovasi Pengabdian Masyarakat, vol. 3, no. 1, pp. 59–63, 2025, doi: 10.55903/jipm.v3i1.220.
[20] K. W. Broman and K. H. Woo, “Data organization in spreadsheets,” The American Statistician, vol. 72, no. 1, pp. 2–10, 2018, doi: 10.1080/00031305.2017.1375989.
[21] W. Nainggolan, “Integrasi layanan Google Spreadsheet untuk pengelolaan database dan informasi kegiatan perjalanan dinas, konsinyering, dan diskusi pakar,” project report, Pusat Pengembangan Kompetensi Sumber Daya Manusia Legislatif, Jakarta, Indonesia, 2019.
[22] F. A. Dantika and A. Aliyah, “Penggunaan Google Spreadsheet untuk meningkatkan mutu pendidikan di sekolah dasar,” EPISTEMIC: Jurnal Ilmiah Pendidikan, vol. 4, no. 2, pp. 220–237, 2025, doi: 10.70287/epistemic.v4i2.387.
[23] R. Siregar, I. T. Nazara, C. N. Saragi, and J. D. Situmorang, “Pemanfaatan Google Form dan Google Sheet dalam pembelajaran,” Jurnal Pengabdian Multidisiplin Indonesia, vol. 2, no. 1, pp. 23–26, 2024, doi: 10.69820/jupemi.v2i1.120.
[24] W. Karim, M. R. Katili, and I. R. Padiku, “Pengembangan sistem informasi persediaan obat berbasis web menggunakan metode prototype di Instalasi Farmasi Rumah Sakit Otanaha Kota Gorontalo,” Journal of System and Information Technology, vol. 5, no. 1, pp. 55–65, 2025, doi: 10.37031/diffusion.v5i1.27400.
[25] M. A. Kartikasari, “Design of medicine inventory system,” Jurnal Logistik Indonesia, vol. 8, no. 2, pp. 122–131, 2024, doi: 10.31334/logistik.v8i2.4538.
[26] K. Ravikumar et al., “Design and performance implication of pharmacy information system,” International Journal of Scientific Research in Engineering and Management, vol. 9, pp. 1–9, 2025, doi: 10.55041/ijsrem48407.
Downloads
Published
How to Cite
Issue
Section
License
Copyright (c) 2026 Maria Shelsavionda Dianthi, Nuryati
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
