A Prognostic System for Pharmaceutical Inventory Forecasting Using the Trend Least Squares Method at Rakha Medika

Authors

  • Evi Yulianti Indo Global Mandiri University
  • Indah Pratiwi Putri Universitas Indo Global Mandiri
  • Dona Marcelina Indo Global Mandiri University

DOI:

https://doi.org/10.62123/aqila.v2i1.80

Keywords:

Pharmaceutical Inventory, Trend Least Squares, Drug Stock Prediction, Healthcare Supply Chain, Public Health

Abstract

This study proposes the development of a sophisticated predictive system for pharmaceutical inventory management at Rakha Medika, Palembang, aimed at addressing the prevalent challenges associated with inaccurate drug stock forecasting. Employing the Trend Least Squares method, the system leverages historical consumption data to generate precise predictions of future pharmaceutical needs, thereby facilitating optimal procurement strategies and mitigating the risks of both stockouts and surplus inventory. Developed with PHP and MySQL, the system offers a user-friendly web-based interface, providing role-specific access for administrators, warehouse personnel, and senior management, ensuring seamless integration within the existing operational framework. This research highlights the importance of data-driven decision-making in healthcare supply chain management, where the accuracy of stock forecasts directly correlates with the quality-of-service delivery. Through rigorous testing using real-world data, the system demonstrated a significant improvement in forecasting accuracy and operational efficiency, with tangible benefits including reduced administrative burdens and enhanced drug availability. The implementation of this predictive system not only optimizes inventory control but also contributes to the overall enhancement of healthcare services at the public health center.

References

[1] A. Burinskiene, "Forecasting model: The case of the pharmaceutical retail," Frontiers in Medicine, vol. 9, p. 582186, 2022.

[2] T. Jobira, H. Abuye, A. Jemal, and T. Gudeta, "Evaluation of pharmaceuticals inventory management in selected health facilities of West Arsi Zone, Oromia, Ethiopia," Integrated Pharmacy Research and Practice, pp. 1–11, 2021.

[3] S. Budennyy, A. Kazakov, E. Kovtun, and L. Zhukov, "New drugs and stock market: a machine learning framework for predicting pharma market reaction to clinical trial announcements," Scientific Reports, vol. 13, no. 1, p. 12817, 2023.

[4] E. Oluwagbade, A. Vincent, O. Oluwole, and B. Animasahun, "Lifecycle governance for explainable AI in pharmaceutical supply chains: a framework for continuous validation, bias auditing, and equitable healthcare delivery," Int. J. Eng. Technol. Res. Manag., vol. 7, no. 11, pp. 1–10, 2023.

[5] O. Oluwole, E. Emmanuel, O. O. Ogbuagu, V. Alemede, and I. Adefolaju, "Pharmaceutical supply chain optimization through predictive analytics and value-based healthcare economics frameworks," 2024. [Unpublished].

[6] M. H. Hugos, Essentials of Supply Chain Management, Hoboken, NJ: John Wiley & Sons, 2024.

[7] Y. Jin, D. Yan, A. Chong, B. Dong, and J. An, "Building occupancy forecasting: A systematical and critical review," Energy and Buildings, vol. 251, p. 111345, 2021.

[8] B. Endeshaw, "Healthcare service quality-measurement models: a review," Journal of Health Research, vol. 35, no. 2, pp. 106–117, 2021.

[9] N. X. Nguyen, K. Tran, and T. A. Nguyen, "Impact of service quality on in-patients’ satisfaction, perceived value, and customer loyalty: A mixed-methods study from a developing country," Patient Preference and Adherence, pp. 2523–2538, 2021.

[10] Å. Björck, Numerical Methods for Least Squares Problems, Philadelphia, PA: Society for Industrial and Applied Mathematics, 2024.

[11] B. K. Meher, I. T. Hawaldar, C. M. Spulbar, and F. R. Birau, "Forecasting stock market prices using mixed ARIMA model: A case study of Indian pharmaceutical companies," Investment Management and Financial Innovations, vol. 18, no. 1, pp. 42–54, 2021.

[12] M. Shahin, F. F. Chen, M. Maghanaki, S. Firouzranjbar, and A. Hosseinzadeh, "Evaluating the fidelity of statistical forecasting and predictive intelligence by utilizing a stochastic dataset," The International Journal of Advanced Manufacturing Technology, pp. 1–31, 2024.

[13] E. Mfizi, F. Niragire, T. Bizimana, and M. F. Mukanyangezi, "Analysis of pharmaceutical inventory management based on ABC-VEN analysis in Rwanda: a case study of Nyamagabe district," Journal of Pharmaceutical Policy and Practice, vol. 16, no. 1, p. 30, 2023.

[14] V. KEk, S. P. Nadeem, M. Ravichandran, M. Ethirajan, and J. Kandasamy, "Resilience strategies to recover from the cascading ripple effect in a copper supply chain through project management," Operations Management Research, vol. 15, no. 1, pp. 440–460, 2022.

[15] F. De Martini, "Supply chains and disruptive events: An inventory management system perspective," 2021.

[16] K. A. Wager, F. W. Lee, and J. P. Glaser, Health Care Information Systems: A Practical Approach for Health Care Management, Hoboken, NJ: John Wiley & Sons, 2021.

[17] O. M. Alqarafi et al., "Comprehensive review of healthcare systems and their evolving structures," Journal of Ecohumanism, vol. 3, no. 8, pp. 4101–4111, 2024.

[18] D. S. G. S. Aujla and R. Bajaj, "Evolution from ancient medication to human-centered Healthcare 4.0: A review on health care recommender systems," [Unpublished].

[19] A. E. Mohamed, "Inventory management," in Operations Management - Recent Advances and New Perspectives, IntechOpen, 2024.

[20] S. Singh, "Basic approach on inventory control and management," Industrial Engineering and Management System, p. 103.

[21] G. Woo, C. Liu, D. Sahoo, A. Kumar, and S. Hoi, "Cost: Contrastive learning of disentangled seasonal-trend representations for time series forecasting," arXiv preprint, arXiv:2202.01575, 2022.

[22] Z. Liu, Z. Zhu, J. Gao, and C. Xu, "Forecast methods for time series data: A survey," IEEE Access, vol. 9, pp. 91896–91912, 2021.

[23] M. Ding et al., "A time series model based on hybrid-kernel least-squares support vector machine for short-term wind power forecasting," ISA Transactions, vol. 108, pp. 58–68, 2021.

[24] W. Zhang and Z. Wu, "Optimal hybrid framework for carbon price forecasting using time series analysis and least squares support vector machine," Journal of Forecasting, vol. 41, no. 3, pp. 615–632, 2022.

[25] E. P. Adeghe, C. A. Okolo, and O. T. Ojeyinka, "A review of the use of machine learning in predictive analytics for patient health outcomes in pharmacy practice," OARJ of Life Sciences, vol. 7, no. 1, pp. 052–055, 2024.

[26] B. I. Ashiwaju, O. F. Orikpete, and C. G. Uzougbo, "The intersection of artificial intelligence and big data in drug discovery: a review of current trends and future implications," Matrix Science Pharma, vol. 7, no. 2, pp. 36–42, 2023.

[27] S. Pargaonkar, "A comprehensive research analysis of software development life cycle (SDLC) agile & waterfall model advantages, disadvantages, and application suitability in software quality engineering," International Journal of Scientific and Research Publications (IJSRP), vol. 13, no. 08, pp. 345–358, 2023.

[28] M. I. Hossain, "Software development life cycle (SDLC) methodologies for information systems project management," International Journal of Multidisciplinary Research, vol. 5, no. 5, pp. 1–36, 2023.

Downloads

Published

2025-06-24

How to Cite

Yulianti, E., Putri, I. P., & Marcelina, D. (2025). A Prognostic System for Pharmaceutical Inventory Forecasting Using the Trend Least Squares Method at Rakha Medika. Acceleration, Quantum, Information Technology and Algorithm Journal, 2(1), 28–37. https://doi.org/10.62123/aqila.v2i1.80

Similar Articles

You may also start an advanced similarity search for this article.