Proceedings of International Conference on Applied Innovation in IT
2025/06/27, Volume 13, Issue 2, pp.261-268

Comparison of Linear Trend Analysis and Double Exponential Smoothing Methods for Predicting Chronic Disease Drug Needs


Wedyan Habeeb Hameed, Bashar Talib AL Nuaimi and Wisam Sami Mohsin


Abstract: One of the factors influencing the standard of care given to patients and society is the process of identifying medical needs and accurately quantifying them. Therefore, finding new methods or mechanisms to evaluate the need for drugs has become essential. Due to faulty prediction methods, the Ministry of Health in Iraq was unable to achieve a precise match between actual consumption and estimated demand due to the employment of old methods. Therefore, the research aims to 1) select a suitable method from the two forecasting techniques, trend exponential analysis (TEA) and double exponential smoothing (DES), and 2) predict the needs for drugs for the next five years based on historical data. Accuracy measures (MAPE, MAD, and MSD) have been utilized as model selection criteria to best characterize the trend of estimating the demands of chronic drugs from 2017 to 2019. The results demonstrate a decrease in MAPE values in all medications compared with MAD and MSD. In addition, the MAPE of a DES technique for (Lovastatin = 3, Insulin = 12, Valproic acid = 4.36, Carbidopa = 1.74) is greater than the MAPE of a TEA (Lovastatin = 2, Insulin = 11, Valproic acid = 3.92, Carbidopa = 1.72). Depending on the value of MAPE, TEA was recognized as the optimal prediction model and can best fit for predicting the demand for chronic drugs in future needs. Annual forecasts using a trend exponential analysis for the quantities required for each drug from 2020 to 2024 show a significant increase in demand for all pharmaceuticals. Whereas insulin tablets are the smallest, with 559,367 packs in 2024, valproic acid is the largest, with 13,387,773 packs, indicating a shortage of competing drugs or an anticipated increase in patient numbers. The proposed method might be useful for inventory prediction at industrial sites as well.

Keywords: Drugs, Trend Exponential Analysis, Double Exponential Smoothing, Forecasting, Future Needs, Prediction.

DOI: 10.25673/120445

Download: PDF

References:

  1. W. H. Hameed, "Forecasting Drug Needs And Quantification Tools In Healthcare Institutions," Quantum Center, 2021.
  2. E. Belyi, P. J. Giabbanelli, I. Patel, et al., "Combining association rule mining and network analysis for pharmacosurveillance," The Journal of Supercomputing, vol. 72, no. 5, pp. 2014-2024, 2016, [Online]. Available: https://doi.org/10.1007/s11227-016-1714-y.
  3. P. B. Arik, "Interpretable Deep Learning for Time Series Forecasting," Google AI Blog, p. 2, 2021.
  4. F. Benhamida, O. Kaddouri, T. Ouhrouche, M. Benaichouche, D. Casado-Mansilla, and D. Lopez-de-Ipina, "Demand Forecasting Tool For Inventory Control Smart Systems," Journal of Communications Software and Systems, vol. 17, no. 2, pp. 185-196, June 2021, [Online]. Available: https://doi.org/10.24138/jcomss-2021-0068.
  5. J. Volland, A. Fügener, J. Schoenfelder, and J. O. Brunner, "Material logistics in hospitals: a literature review," Omega, vol. 69, pp. 82-101, 2017.
  6. M. A. Moon, "Quantitative Forecasting Techniques," in Demand and Supply Integration, De Gruyter, 2018, pp. 87-112.
  7. A. Pamungkas et al., IOP Conf. Ser.: Earth Environ. Sci., vol. 934, p. 012016, 2021.
  8. A. W. Omer, H. T. A. Blbas, and D. H. Kadir, "A Comparison between Brown's and Holt's Double Exponential Smoothing for Forecasting Applied Generation Electrical Energies in Kurdistan Region," CUESJ, vol. 5, no. 2, pp. 56-63, 2021, [Online]. Available: https://doi.org/10.24086/cuesj.v5n2y2021.pp56-63.
  9. A. T. Hariguna, "Comparison of Three Time Series Forecasting Methods on LinearRegression, Exponential Smoothing and Weighted Moving Average," International Journal of Informatics and Information Systems, vol. 6, no. 2, pp. 89-102, 2023, [Online]. Available: https://doi.org/10.47738/ijiis.v6i2.165.
  10. A. S. Ahmara, S. M. Meliyana, M. Botto-Tobar, and R. Hidayat, "The Comparison of Single and Double Exponential Smoothing Models in Predicting Passenger Car Registrations in Canada," Journal of Humanities and Social Sciences Innovation, vol. 4, no. 2, 2024, [Online]. Available: https://doi.org/10.35877/454RI.daengku2639.
  11. H. Mohammed, I. Nazeeh, W. Alisawi, Q. Kadhim, and S. Ahmed, "Anomaly detection in human disease: a hybrid approach using GWO-SVM for gene selection," Revue d'Intelligence Artificielle, vol. 37, no. 4, pp. 913-919, 2023, [Online]. Available: https://doi.org/10.18280/ria.370411.
  12. H. A. A. Mohammed, S. T. Ahmed, R. M. H. Zaki, and Q. K. Kadhim, "Detection and localization of wrist fractures in x-ray imagery using deep learning teaching," Review of Computer Engineering Research, vol. 11, no. 3, pp. 85-98, 2024.
  13. A. Saha and K. Sînha, "Usage of Holt's Linear Trend Exponential Smoothing for Time Series Forecasting in Agricultural Research," 2020.
  14. M. Zellner, A. E. Abbas, D. V. Budescu, and A. Galstyan, "A survey of human judgement and quantitative forecasting methods," Royal Society open science, vol. 8, no. 2, p. 201187, 2021.
  15. H. Abbasimehr, M. Shabani, and M. Yousefi, "An optimized model using LSTM network for demand forecasting," Computers & industrial engineering, vol. 143, p. 106435, 2020.
  16. K. Padmanaban, Supriya, B. S. Dhekale, and P. K. Sahu, "Forecasting of Tea Export from India - an Exponential Smoothing Techniques Approach," International Journal of Agricultural Sciences, vol. 7, no. 7, pp. 577-580, 2015.
  17. H. Abbasimehr, M. Shabani, and M. Yousefi, "An optimized model using LSTM network for demand forecasting," Computers & Industrial Engineering, vol. 143, p. 106435, 2020, [Online]. Available: https://doi.org/10.1016/j.cie.2020.106435.
  18. R. Lakkana and S. Monta lee, "Forecasting agricultural products prices using time series methods for crop planning," International Journal of Mechanical Engineering and Technology, vol. 9, pp. 957-971, 2018.
  19. T. Falatouri, F. Darbanian, P. Brandtner, and C. Udokwu, "Predictive analytics for demand forecasting–a comparison of SARIMA and LSTM in retail SCM," Procedia Computer Science, vol. 200, pp. 993-1003, 2022.
  20. A. Khayati, "Forecasting Major Vegetable Crops Productions in Tunisia," International Journal of Research in Business Studies and Management, vol. 2, no. 6, pp. 15-19, 2015.
  21. D. Bertsimas and N. Kallus, "From predictive to prescriptive analytics," Management Science, vol. 66, no. 3, pp. 1025-1044, 2020.


    HOME

       - Conference
       - Journal
       - Paper Submission to Journal
       - For Authors
       - For Reviewers
       - Important Dates
       - Conference Committee
       - Editorial Board
       - Reviewers
       - Last Proceedings


    PROCEEDINGS

       - Volume 13, Issue 2 (ICAIIT 2025)
       - Volume 13, Issue 1 (ICAIIT 2025)
       - Volume 12, Issue 2 (ICAIIT 2024)
       - Volume 12, Issue 1 (ICAIIT 2024)
       - Volume 11, Issue 2 (ICAIIT 2023)
       - Volume 11, Issue 1 (ICAIIT 2023)
       - Volume 10, Issue 1 (ICAIIT 2022)
       - Volume 9, Issue 1 (ICAIIT 2021)
       - Volume 8, Issue 1 (ICAIIT 2020)
       - Volume 7, Issue 1 (ICAIIT 2019)
       - Volume 7, Issue 2 (ICAIIT 2019)
       - Volume 6, Issue 1 (ICAIIT 2018)
       - Volume 5, Issue 1 (ICAIIT 2017)
       - Volume 4, Issue 1 (ICAIIT 2016)
       - Volume 3, Issue 1 (ICAIIT 2015)
       - Volume 2, Issue 1 (ICAIIT 2014)
       - Volume 1, Issue 1 (ICAIIT 2013)


    PAST CONFERENCES

       ICAIIT 2025
         - Photos
         - Reports

       ICAIIT 2024
         - Photos
         - Reports

       ICAIIT 2023
         - Photos
         - Reports

       ICAIIT 2021
         - Photos
         - Reports

       ICAIIT 2020
         - Photos
         - Reports

       ICAIIT 2019
         - Photos
         - Reports

       ICAIIT 2018
         - Photos
         - Reports

    ETHICS IN PUBLICATIONS

    ACCOMODATION

    CONTACT US

 

        

         Proceedings of the International Conference on Applied Innovations in IT by Anhalt University of Applied Sciences is licensed under CC BY-SA 4.0


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


           ISSN 2199-8876
           Publisher: Edition Hochschule Anhalt
           Location: Anhalt University of Applied Sciences
           Email: leiterin.hsb@hs-anhalt.de
           Phone: +49 (0) 3496 67 5611
           Address: Building 01 - Red Building, Top floor, Room 425, Bernburger Str. 55, D-06366 Köthen, Germany

        site traffic counter

Creative Commons License
Except where otherwise noted, all works and proceedings on this site is licensed under Creative Commons Attribution-ShareAlike 4.0 International License.