Integrating Moving Average Based Procurement Recommendations into a Web Based Pharmacy Order Form
DOI:
https://doi.org/10.69533/informatech.volume3number2.697Keywords:
Inventory management, Moving average, Pharmacy information systemAbstract
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.
Downloads
References
M. Q. Alanazi, E. K. Alkhadhairi, W. H. Alrumi, dan S. A. Alajlan, “Reducing pharmaceutical and non-pharmaceutical inventory waste in tertiary hospital: Impact of ABC-VEN analysis in a zero-waste strategy over 7 years,” Risk Manag. Healthc. Policy, vol. 17, hlm. 2659–2675, 2024, doi: 10.2147/RMHP.S467230.
R. Jaju, S. Varshney, P. Gupta, P. Bihani, dan H. M. R. Karim, “Inventory control mechanism of the pharmacy store of a recently established national institute in Eastern India: A cross-sectional, investigative analysis,” Cureus, vol. 15, no. 11, hlm. e49632, 2023, doi: 10.7759/cureus.49632.
S. Mabizela, H. N. Nakambale, dan V. Bangalee, “Predictors of medicine redistribution at public healthcare facilities in King Cetshwayo District, KwaZulu-Natal, South Africa,” BMC Health Serv. Res., vol. 23, hlm. 1108, 2023, doi: 10.1186/s12913-023-10096-4.
H. Suprapto, Y. Nita, dan A. Hermansyah, “Assessment of pharmaceutical inventory management in an Indonesian district health office: A pioneer study during the Covid-19 pandemic,” Pharm. Educ., vol. 23, no. 4, hlm. 164–167, 2023, doi: 10.46542/pe.2023.234.164167.
V. S. Gunawan, Muhammad, dan S. Maria, “Implementasi metode prototype dalam pengembangan sistem informasi inventaris obat di Apotek Syira Farma,” J. Comput. Sci. Inf. Technol. CoSciTech, vol. 6, no. 2, hlm. 189–198, 2025, doi: 10.37859/coscitech.v6i2.9652.
J. K. Obamiro, “Demand forecasting and measuring forecast accuracy in a pharmacy,” Acta Univ. Danub. Œcon., vol. 15, no. 3, hlm. 157–169, 2019.
S. Lestyawan, Z. M. Ramadhania, dan H. T. Kusumastuti, “Analisis safety stock dan re-order point obat di Puskesmas X Kota Bandung untuk optimalisasi manajemen persediaan,” Farmaka, vol. 23, no. 1, 2025, [Daring]. Tersedia pada: https://journals.unpad.ac.id/farmaka/article/download/65586/pdf
R. A. Wulandari dan S. Mulyati, “Sistem rekomendasi reorder point otomatis order barang di Apotek Qaureen Farma,” AUTOMATA, vol. 2, no. 1, 2021, [Daring]. Tersedia pada: https://journal.uii.ac.id/AUTOMATA/article/view/17304
M. K. H. Hong dkk., “Error rates in a clinical data repository: Lessons from the transition to electronic data transfer—A descriptive study,” BMJ Open, vol. 3, no. 5, hlm. e002406, 2013, doi: 10.1136/bmjopen-2012-002406.
Ichsandi dan A. A. Kurniawan, “Evaluasi usability sistem informasi manajemen apotek berbasis progressive web application menggunakan metode System Usability Scale,” J. Inov. Pendidik. Dan Teknol. Inf. JIPTI, vol. 7, no. 1, hlm. 131–142, 2026, doi: 10.52060/jipti.v7i1.4047.
I. Padiku, L. Hadjaratie, D. R. P. Papeo, dan M. F. F. Walahe, “Penerapan metode WMA dan EOQ pada sistem informasi pengendalian persediaan stok obat di Apotek Damhil,” J. Tek., vol. 21, no. 2, hlm. 155–167, 2023, doi: 10.37031/jt.v21i2.419.
K. Diana, A. D. A. Saputra, M. R. Tandah, C. F. Murti, dan N. Fajriningtyas, “Drug PC: A web-based information system for planning and controlling pharmaceutical inventory,” Indones. J. Pharm. Sci. Technol., vol. 6, no. 2, hlm. 119–129, 2024, doi: 10.24198/ijpst.v6i2.52618.
M. R. Pratama dan A. Supriyanto, “Sistem prediksi pemesanan dan pengendalian stok barang menggunakan metode EOQ dan ROP pada Apotek Setia Kawan Pati,” J. Inform. Dan Rekayasa Elektron., vol. 5, no. 1, hlm. 92–102, 2022, doi: 10.36595/jire.v5i1.450.
Z. I. Bela dan H. D. Bhakti, “Sistem prediksi penjualan obat menggunakan metode single moving average (studi kasus: Apotek Wilujeng Kecamatan Panceng Kab. Gresik),” Indexia Inform. Comput. Intell. J., vol. 4, no. 1, hlm. 47–58, 2022, doi: 10.30587/indexia.v4i1.3638.
I. G. B. Aprilyanta, A. Lestari, dan S. Christina, “Perbandingan implementasi metode weighted moving average dan metode single exponential smoothing pada penentuan persediaan obat,” J. Saintekom, vol. 12, no. 2, hlm. 137–145, 2022, doi: 10.33020/saintekom.v12i2.317.
A. Hidayah, M. A. Barata, dan A. D. Ardianti, “Peramalan penjualan obat dengan menggunakan metode single moving average,” J. Inf. Syst. Res. JOSH, vol. 7, no. 1, hlm. 69–76, 2025, doi: 10.47065/josh.v7i1.8256.
M. Q. Amin, S. Satibi, S. A. Kristina, dan F. Saleem, “Forecasting drug demand: A review of predictive methods, limitations, and future directions,” dipresentasikan pada Proceedings of the 6th International Conference on Bioinformatics, Biotechnology, and Biomedical Engineering (BIOMIC 2025), 2026. doi: 10.2991/978-94-6239-762-0_18.
M. Z. Babaï, A. A. Syntetos, Y. Dallery, dan K. Nikolopoulos, “Dynamic re-order point inventory control with lead-time uncertainty: Analysis and empirical investigation,” Int. J. Prod. Res., vol. 47, no. 9, hlm. 2461–2483, 2009, doi: 10.1080/00207540701666824.
S. Romadhon dan R. Wardoyo, “Prioritizing drug procurement using ABC, VEN, EOQ and ROP combination,” IJCCS Indones. J. Comput. Cybern. Syst., vol. 15, no. 2, hlm. 209–220, 2021, doi: 10.22146/ijccs.63486.
R. J. Hyndman dan G. Athanasopoulos, Forecasting: Principles and Practice, 2 ed. Melbourne, Australia: OTexts, 2018.
J. D. Croston, “Forecasting and stock control for intermittent demands,” Oper. Res. Q., vol. 23, no. 3, hlm. 289–303, 1972.
A. A. Syntetos dan J. E. Boylan, “On the bias of intermittent demand estimates,” Int. J. Prod. Econ., vol. 71, no. 1–3, hlm. 457–466, 2001, doi: 10.1016/S0925-5273(00)00143-2.
A. A. Syntetos, J. E. Boylan, dan J. D. Croston, “On the categorization of demand patterns,” J. Oper. Res. Soc., vol. 56, no. 5, hlm. 495–503, 2005, doi: 10.1057/palgrave.jors.2601841.
E. A. Silver, D. F. Pyke, dan D. J. Thomas, Inventory and Production Management in Supply Chains, 4 ed. Boca Raton, FL, USA: CRC Press, 2016.
J. Shen dkk., “Management of drug supply chain information based on ‘artificial intelligence + vendor managed inventory’ in China: Perspective based on a case study,” Front. Pharmacol., vol. 15, hlm. 1373642, 2024, doi: 10.3389/fphar.2024.1373642.
A. I. Bilal, U. S. Bititci, dan T. G. Fenta, “Effective supply chain strategies in addressing demand and supply uncertainty: A case study of Ethiopian Pharmaceutical Supply Services,” Pharmacy, vol. 12, no. 5, hlm. 132, 2024, doi: 10.3390/pharmacy12050132.
K. D. Kurdiana, S. Satibi, dan E. Yuniarti, “Pharmaceutical inventory management approaches and performance outcomes in hospital pharmacies: A systematic review,” J. Manaj. Dan Pelayanan Farm. J. Manag. Pharm. Pract., vol. 16, no. 3, hlm. 280–294, 2026, doi: 10.22146/jmpf.112847.
A. I. Bilal, U. S. Bititci, dan T. G. Fenta, “Challenges and the way forward in demand-forecasting practices within the Ethiopian public pharmaceutical supply chain,” Pharmacy, vol. 12, no. 3, hlm. 86, 2024, doi: 10.3390/pharmacy12030086.
A. A. Syntetos dan J. E. Boylan, “The accuracy of intermittent demand estimates,” Int. J. Forecast., vol. 21, no. 2, hlm. 303–314, 2005, doi: 10.1016/j.ijforecast.2004.10.001.
Downloads
Published
Issue
Section
License
Copyright (c) 2026 Ichsandi, Deni Satria, Widja Yanto, Rica Syofiana Sari, Nabila Sasgita, Yusrizal, Salman, M Effendi Gusliansyah (Author)

This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.









