Integrating Moving Average Based Procurement Recommendations into a Web Based Pharmacy Order Form
Year: 2026
Type: article
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.
Institution: Universitas Merangin
Language: English
Field: Decision Sciences
Domain: Social Sciences
Open Access status: hybrid
OpenAlex ID: W7236061202
