Abstract :

PharmaHealth Group encounters significant challenges in its supply chain distribution due to the pharmaceutical industry’s demand for rapid responsiveness and the high risk of demand fluctuations, particularly during events like the COVID-19 pandemic. Additional complexities include the short shelf-life of pharmaceutical products and extensive quality control processes mandated by strict regulations. This study compares advanced demand forecasting methods to address these issues and optimize supply chain efficiency.

The research examines three forecasting techniques: Holt-Winters, ARIMA (Autoregressive Integrated Moving Average), and the hybrid ARHOW (ARIMA & Holt-Winters additive) model. The Holt-Winters method, effective for time series data with trends and seasonal patterns, improves supply chain management but has limitations in inventory forecasting. ARIMA, known for its simplicity and effectiveness in capturing trends and seasonality, faces challenges with non-linear data and the need for stationarity. The hybrid ARHOW model combines the strengths of both Holt-Winters and ARIMA, offering enhanced forecasting accuracy and efficiency.

By analyzing these methods, the study highlights the potential of hybrid approaches like ARHOW to address PharmaHealth Group’s unique supply chain challenges, leading to improved inventory management and overall supply chain performance.

---

Keywords :

ARHOW Model, ARIMA, Demand forecasting, Holt-Winters Method, Hybrid Forecasting, Pharmaceutical Industry

---

References :

1. Angula, T. (2024). Assessing the impact of artificial intelligence and machine learning on forecasting medication demand and supply in public pharmaceutical systems: a systematic review. GSC Biological and Pharmaceutical Sciences, 26(2), 140-150.
2. George, S. and Elrashid, S. (2023). Inventory management and pharmaceutical supply chain performance of hospital pharmacies in bahrain: a structural equation modeling approach. Sage Open, 13(1), 215824402211497.
3. Lebovitz, L. and Eddington, N. (2019). Trends in the pharmacist workforce and pharmacy education. American Journal of Pharmaceutical Education, 83(1), 7051.
4. Knapp, K. and Cultice, J. (2007). New pharmacist supply projections: lower separation rates and increased graduates boost supply estimates. Journal of the American Pharmacists Association, 47(4), 463-470.
5. Bhakoo, V. and Singh, P. (2012). Collaborative management of inventory in australian hospital supply chains: practices and issues. Supply Chain Management an International Journal, 17(2), 217-230.
6. Polater, A. and Demirdöğen, O. (2018). An investigation of healthcare supply chain management and patient responsiveness. International Journal of Pharmaceutical and Healthcare Marketing, 12(3), 325-347.
7. Mirčetić, D., Nikoličić, S., Maslarić, M., Ralević, N., & Debelić, B. (2016). Development of s-arima model for forecasting demand in a beverage supply chain. Open Engineering, 6(1).
8. Xiao, Y., Zhu, J., Huang, L., Sharma, A., & Sharma, A. (2021). A novel method of material demand forecasting for power supply chains in industrial applications. Iet Collaborative Intelligent Manufacturing, 3(3), 273-280.
9. She, S. (2023). Research on material demand forecasting algorithm based on multi-dimensional feature fusion. International Journal of Information System Modeling and Design, 14(1), 1-13.
10. Li, J., Cui, T., Yang, K., Yuan, R., He, L., & Li, M. (2021). Demand forecasting of e-commerce enterprises based on horizontal federated learning from the perspective of sustainable development. Sustainability, 13(23), 13050.
11. Fan, W., Xiang, W., Shi, X., Zhang, C., Ip, W., Leung, Y., … & Zeng, L. (2023). Support vector regression model for flight demand forecasting. International Journal of Engineering Business Management, 15, 184797902311743.
12. Thummathid, S. (2020). A comparison of forecasting methods for rotable spare parts in a thai low-cost airline.
13. Singh, A. (2024). Prediction of intermittent demand occurrence using machine learning. Eai Endorsed Transactions on Internet of Things, 10.
14. Wu, Q. (2010). Product demand forecasts using wavelet kernel support vector machine and particle swarm optimization in manufacture system. Journal of Computational and Applied Mathematics, 233(10), 2481-2491.
15. Wang, H., Sagbansua, L., & Alidaee, B. (2023). Enhancing supply chain security with automated machine learning.
16. Islam, S. and Amin, S. (2020). Prediction of probable backorder scenarios in the supply chain using distributed random forest and gradient boosting machine learning techniques. Journal of Big Data, 7(1).
17. Ma, X., Li, M., Jin, T., & Feng, X. (2023). Deep learning combinatorial models for intelligent supply chain demand forecasting. Biomimetics, 8(3), 312.
18. Nasution, A., Matondang, N., & Ishak, A. (2022). Inventory optimization model design with machine learning approach in feed mill company. Jurnal Sistem Teknik Industri, 24(2), 254-272.
19. Wang, W., Hong, Y., & Zhang, Z. (2017). Dynamic performance of service-manufacturing hybrid supply chain with two forecasting methods.
20. Fu, W., Chien, C., & Lin, Z. (2018). A hybrid forecasting framework with neural network and time-series method for intermittent demand in semiconductor supply chain., 65-72.
21. Chen, C. (1996). Some statistical properties of the holtwinters seasonal forecasting method. Journal of the Japan Statistical Society, 26(2), 173-187.
22. Purwanto, E. and Nofrisel, N. (2020). Effectiveness demand forecasting analysis for xyz brand jeans (case study in ptgp).
23. Agusman, J. (2023). Stock forecasting information system using the holt-winters method. Bit-Tech, 6(2), 176-182.
24. Ponziani, R. (2022). Forecasting of jakarta islamic index (jii) returns using holt-winters family models. Asian Journal of Islamic Management (Ajim), 111-122.
25. Nieto, M., Benitez, R., & Martinez, J. (2021). Comparing models to forecast cargo volume at port terminals. Journal of Applied Research and Technology, 19(3), 238-249.
26. Mardiana, S., Saragih, F., & Huseini, M. (2020). Forecasting gasoline demand in indonesia using time series. International Journal of Energy Economics and Policy, 10(6), 132-145.
27. Petropoulos, F., Wang, X., & Disney, S. (2019). The inventory performance of forecasting methods: evidence from the m3 competition data. International Journal of Forecasting, 35(1), 251-265.
28. Adeyinka, D. and Muhajarine, N. (2020). Time series prediction of under-five mortality rates for nigeria: comparative analysis of artificial neural networks, holt-winters exponential smoothing and autoregressive integrated moving average models. BMC Medical Research Methodology, 20(1).
29. Fara, L., Diaconu, A., Crăciunescu, D., & Fara, S. (2021). Forecasting of energy production for photovoltaic systems based on arima and ann advanced models. International Journal of Photoenergy, 2021, 1-19.
30. Faradiela, P., Wibowo, A., & Husniyawati, Y. (2022). Forecasting the number of vertical referrals for bpjs participants at health service center in universitas airlangga using arima model. Jurnal Biometrika Dan Kependudukan, 11(1), 62-71.
31. Derbentsev, V., Datsenko, N., Степаненко, О., & Bezkorovainyi, V. (2019). Forecasting cryptocurrency prices time series using machine learning approach. SHS Web of Conferences, 65, 02001.
32. Singh, S., Sundram, B., Rajendran, K., Law, K., Aris, T., Ibrahim, H., … & Gill, B. (2020). Forecasting daily confirmed covid-19 cases in malaysia using arima models. The Journal of Infection in Developing Countries, 14(09), 971-976.
33. Helmini, S., Jihan, N., Jayasinghe, M., & Perera, S. (2019). Sales forecasting using multivariate long short term memory network models.
34. Velasco, L., Polestico, D., Macasieb, G., Reyes, M., & Vasquez, F. (2019). A hybrid model of autoregressive integrated moving average and artificial neural network for load forecasting. International Journal of Advanced Computer Science and Applications, 10(11).
35. Yang, Y., Wu, J., Chen, Y., & Li, C. (2013). A new strategy for short-term load forecasting. Abstract and Applied Analysis, 2013, 1-9.
36. Siddiqui, R., Azmat, M., Ahmed, S., & Kummer, S. (2022). A hybrid demand forecasting model for greater forecasting accuracy: the case of the pharmaceutical industry. Supply Chain Forum: An International Journal, 23(2), 124-134.