EUVIMEDEUVIMED entdecken
Open Access · CC BY-SA 4.0

Integrating Moving Average Based Procurement Recommendations into a Web Based Pharmacy Order Form

Ichsandi, Deni Satria, Widja Yanto, Rica Syofiana Sari, Nabila Sasgita, Yusrizal, Salman, M Effendi Gusliansyah

Jurnal Ilmiah Informatika dan Komputer · 11.12.2026 · 3 (2) · 215-225

DOI: 10.69533/informatech.volume3number2.697 ↗

Kurz gefasst

Fachartikel in der Zeitschrift Jurnal Ilmiah Informatika dan Komputer, online erschienen am 11.12.2026. Verfasst von Ichsandi und 7 weiteren Autor:innen. Der Volltext ist frei zugänglich (Open Access, CC BY-SA 4.0).

AbstractBibliografische AngabenZitierenVerwandte Studien

Abstract (Originalsprache)

Manual medicine procurement in pharmacies risks both stockouts and overstocking. This study aims to design and implement a medicine ordering module that integrates procurement recommendations based on moving average forecasting into the order form of a web-based pharmacy information system. The module, built with PHP and MySQL, computes the 30-day average daily sales, the estimated days until stockout, a risk classification, and a recommended quantity that raises stock to a target level of twice the predicted demand, and then fills the order form automatically. The evaluation used the database of Apotek Madani BS, which contains 5,564 sales transactions and 35 purchase orders. Of the 269 medicines sold in the last 30 days, 20 were critical, 3 were warning, and 246 were safe; 101 medicines were recommended for ordering, 78 of them with safe status. The module’s output matched that of an independent implementation of the same algorithm, which confirms consistent implementation but not the operational validity of the underlying procurement policy, and 67.4% of historical order lines were preceded by sales in the previous 30 days. The design removes the manual copying of recommendations and can be adapted to other PHP- and MySQL-based pharmacy information systems; the recommended quantities have not yet been tested against future demand, and the module does not yet consider supplier lead time or seasonal patterns.

Zitieren

APA

Ichsandi, Satria, D., Yanto, W., Sari, R. S., Sasgita, N., Yusrizal, Salman, & Gusliansyah, M. E. (2026). Integrating Moving Average Based Procurement Recommendations into a Web Based Pharmacy Order Form. Jurnal Ilmiah Informatika dan Komputer, 3(2), 215-225. https://doi.org/10.69533/informatech.volume3number2.697

Vancouver

Ichsandi, Satria D, Yanto W, Sari RS, Sasgita N, Yusrizal, et al. Integrating Moving Average Based Procurement Recommendations into a Web Based Pharmacy Order Form. Jurnal Ilmiah Informatika dan Komputer. 2026;3(2):215-225. doi:10.69533/informatech.volume3number2.697

BibTeX
@article{Ichsandi2026,
  author = {Ichsandi and Satria, Deni and Yanto, Widja and Sari, Rica Syofiana and Sasgita, Nabila and Yusrizal and Salman and Gusliansyah, M Effendi},
  title = {Integrating Moving Average Based Procurement Recommendations into a Web Based Pharmacy Order Form},
  journal = {Jurnal Ilmiah Informatika dan Komputer},
  year = {2026},
  volume = {3},
  number = {2},
  pages = {215--225},
  doi = {10.69533/informatech.volume3number2.697}
}
Kostenlos starten →