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

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.

Authors

Institutions

Publication Details

Journal
Jurnal Ilmiah Informatika dan Komputer
Published
2026-11-18
DOI
https://doi.org/10.69533/informatech.volume3number2.697
Primary Topic
Supply Chain and Inventory Management
Type
article
Field-Weighted Citation Impact
0.00
Controls
|||
ALL TIME
JAN
FEB
MAR
APR
MAY
JUN
JUL
AUG
SEP
OCT
NOV
article

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

Nabila Sasgita, Widja Yanto, Deni Satria, Yusrizal et al.
Jurnal Ilmiah Informatika dan Komputer
Supply Chain and Inventory Management
article

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

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

Abstract

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.

Jurnal Ilmiah Informatika dan KomputerVol. 3(2)
Universitas Merangin (ID)
Supply Chain and Inventory Management
AI Navigator

Ask Laika to Summarize, Analyze, and Connect papers live on the map.

Summarize Papers & Methodologies

Extract key findings, datasets, and comparative methods across publications.

Benchmark Rankings & Visual Analytics

Rank top research institutions, authors, funders, topics, and journals by Field-Weighted Citation Impact (FWCI) and paper volume with instant charts.

Connect Distant Disciplines

Bridge topological clusters on the map to find hidden collaborative intersections.

Laika access coming soon