Ending Out-of - Stock Syndrome in Hospital Pharmacies through Computer - Based Forecasting

International Journal of Computer Trends and Technology (IJCTT)          
© 2019 by IJCTT Journal
Volume-67 Issue-11
Year of Publication : 2019
Authors : Onu,Fergus Uche, Eme,Ogwo
DOI :  10.14445/22312803/IJCTT-V67I11P105


MLA Style:Onu,Fergus Uche, Eme,Ogwo  "Ending Out-of - Stock Syndrome in Hospital Pharmacies through Computer - Based Forecasting," International Journal of Computer Trends and Technology 67.11 (2019):28-37.

APA Style Onu,Fergus Uche, Eme,Ogwo.Ending Out-of - Stock Syndrome in Hospital Pharmacies through Computer - Based Forecasting  International Journal of Computer Trends and Technology, 67(11),28-37.

Hospital pharmacies usually stock a variety of drugs. The primary reason for holding stock in hospital pharmacies is to ensure the availability of these essential items all the time. This is not the case in many hospital pharmacies as many of them are affected by the unavailability of these drugs especially at a time they are needed. This paper discusses ways of ending this problem of the shortage of these drugs, known as out –of –stock syndrome, through the application of computer based forecasting.Forecasting is the process of making predictions of the future based on past and present data and most commonly by analysis of trends. In order to solve the out- of –stock syndrome in hospital pharmacies, we propose a computer- based forecasting system that uses time series data to provide for both trend and seasonal forecasts of different type of drugs required in a hospital pharmacy. We adopted Object Oriented Analysis and Design Methodology (OOADM) for the design of our computer based-forecasting system using Visual Basic 6.0 programming language to program and implement the application while Microsoft Access was used to design the database as the back-end for the storage and retrieval of the stored information when required.The benefits of application of computer based forecasting in hospital pharmacies include ensuring availability of drugs, improved management of inventories, facilitate better planning and greater efficiency all the areas in the hospitals due to an efficient stock analysis in the hospital pharmacy department.

[1] Canadian drug shortages survey: final report. Ottawa (ON): Canadian Pharmacists Association; 2010. Available from: www.pharmacists.ca/cpha-ca/assets/File/cpha-on-theissues/ DrugShortageReport.pdf.
[2] Kaakeh R, Sweet BV, Reilly C, Bush C, DeLoach S, Higgins B, et al. Impact of drug shortages on U.S. health systems. Am J Health Syst Pharm. 2011;68(19):1811–1819. doi: 10.2146/ajhp110210. [PubMed][Cross Ref]
[3] Gray, A, &Manasse, HR., Jr. Shortages of medicines: a complex global challenge. Bull World Health Organ. 2012;90(3):158–158A. doi: 10.2471/BLT.11.101303. Available at http://www.who.int/bulletin/volumes/90/3/11- 101303.pdf
[4] Daniels, Matthew J., "Forecasting hospital bed availability using computer simulation and neural networks" (2004). Thesis.RochesterInstitute of Technology. Accessed from: http://scholarworks.rit.edu/cgi/viewcontent.cgi?article=8078 &context=theses
[5] Wikipedia (2017). Hospital pharmacy. Available at https://en.m.wikipedia.org/wiki/Hospital_pharmacy
[6] Hodnoceníuživatel?: (May 2010). Hospital Pharmacy :Conception of the Field. Available at http://www.nemlek.cz/index.php/articles-in-english/243- hospital-pharmacy-conception-of-the-field
[7] Clive Newman ,C . 2011 How to reduce medicines waste,https://www.pharmaceuticaljournal. com/careers/career-feature/how-to-reducemedicines- waste/11057855.article
[8] David S. Walonick 1993.An Overview of Forecasting Methodology.http://www.statpac.org/researchlibrary/ forecasting.htm
[9] Hyndman, R.O &Athanasopoulos,G. (2018). Forecasting: Principles and Practice. Available at https://www.otexts.org/fpp/1/1
[10] J. Scott Armstrong &Kesten C. Green: 2015. Answers to Frequently-Asked Questions. Retrieved from http://www.forecastingprinciples.com/index.php/faq
[11] Rogers DP, Shapiro MA, Brunet G, Cohen JC, Connor SJ, Diallo AA, et al. Health and climate—opportunities. Proc Environ Sci. 2010;1:37–54. doi: 10.1016/j.proenv.2010.09.005.
[12] Boyle J, Jessup M, Crilly J, Green D, Lind J, Wallis M, et al. Predicting emergency department admissions. Emerg Med J. 2011
[13] Hoot NR, LeBlanc LJ, Jones I, Levin SR, Zhou C, Gadd CS, et al. Forecasting emergency department crowding: a discrete event simulation. Ann Emerg Med. 2008;52(2):116–125. doi: 10.1016/j.annemergmed.2007.12.011.]
[14] McCarthy ML, Zeger SL, Ding R, Aronsky D, Hoot NR, Kelen GD. The challenge of predicting demand for emergency department services.AcadEmerg Med. 2008;15(4):337–346. doi: 10.1111/j.1553- 2712.2008.00083.x.
[15] Champion R, Kinsman LD, Lee GA, Masman KA, May EA, Mills TM, et al. Forecasting emergency department presentations. Aust Health Rev. 2007;31(1):83–90. doi: 10.1071/AH070083.
[16] Roos,D (n.d). How Sales Forecasting Works. Retrieved from https://money.howstuffworks.com/salesforecasting. htm
[17] Elliot, T. (2017). 3 Sales Forecasting Methods. https://www.thebalancesmb.comsales-forecasting-methods- 2948036
[18] Dirmeyer, Paul A.; Schlosser, C. Adam; Brubaker, Kaye L. (February 1, 2009). "Precipitation, Recycling, and Land Memory: An Integrated Analysis". Journal of Hydrometeorology.10:278–288. Bibcode:2009JHyMe..10..278D. doi:10.1175/2008JHM1016.1.
[19] U.S Department of Commerce Economics and Statistics Administration (2014).Fostering Innovation, Creating Jobs, Driving Better Decisions: The Value of Government Data.Economics and Statistics Administration Office of the Chief Economist. July 2014. p. 15.https://www.datainnovation.org/resources/
[20] Chang, Li-Chiu; Shen, Hung-Yu; Chang, Fi-John (2014-11- 27). "Regional flood inundation nowcast using hybrid SOM and dynamic neural networks".Journal of Hydrology.519 (Part A): 476–489. doi:10.1016/j.jhydrol.2014.07.036
[21] Kasapoglu OA. Selection of the Forecasting Model in Health Care. J Hosp Med Manage. 2016, 2:2. http://hospitalmedical- management.imedpub.com/selection-of-theforecasting- model-in-health-care.php?aid=17612
[22] Ireneous N. Soyiri&Daniel D. Reidpath An overview of health forecasting.Environ Health Prev Med. 2013 Jan; 18(1): 1–9. doi: 10.1007/s12199-012-0294-6
[23] Vicente SG, Suarez-Varela MM, Monros AM, Gonzalez AL (2015) Development of certified environmental management in hospital and outpatient haemodialysis units. Nefrologia 35: 539-546.
[24] Zepeda ED, Nyaga GN, Young GJ (2016) Supply chain risk management and hospital inventory: Effects of system affiliation. Journal of Operations Management 44: 30-47
[25] Nikolopoulos K, Buxton S, Khammash M, Stern P (2016) Forecasting branded and generic pharmaceuticals. International Journal of Forecasting 32: 344-357
[26] Afilal M, Yalaoui F, Dugardin F, Amodeo L, Laplanche D, et al. (2016) Emergency department flow: A new practical patients classification and forecasting daily attendance. IFAC-PapersOnLine 49: 721-726.
[27] Jurado I, Maestre JM, Velarde P, Ocampo-Martinez C, Fernandez I, et al. (2016) Stock management in hospital pharmacy using chanceconstrained model predictive control. Computers in Biology and Medicine 72: 248-255
[28] Schweigler, L.M., Desmond, J.S., McCarthy, M.L. & Kyle, J.B (2009), Forecasting Models of Emergency Department Crowding. http//www.researchgate.net/publication/24001633_forecasti ng_models_of_emergency_crowding/amp.
[29] Kadri,F., Chaabane,S. &Cristian, T (2014). A Simulation Based Decision SupportSystem to prevent and predict strain situations in emergency department systems:Simulation Modeling practice and theory. Pp 32- 52.http://scholar.google.comscholar?q=kaderi+et+al
[30] SamiaRekhi (n.d.). Use of Computers in Economic Analysis and Forecasting. Retrieved from www.economicdisussion.net
[31] Vaillancourt,R.Drug Shortages: What Can Hospital Pharmacists Do? https://www.ncbi.nlm.nih.gov/pmc/articles/PMC3379822/
[32] Kathy Calloway-Sykes. Strategies for Dealing with Drug Shortages in the Hospital Pharmacy Setting February 02, 2015. Retrieved from http://www.pharmacytimes.com/contributor/kathycalloway- sykes-bs-pharm-mba/2015/02/strategies-fordealing- with-drug-shortages-in-the-hospital-pharmacysetting
[33] Ogwo Eme, UchennaUgboaja C. A., FaustinaOdinakachiUwazuruike, ChukwuUkaUkpai,"Computer – based Drug Sales and Inventory Control System and its Applications in Pharmaceutical Stores", International Journal of Education and Management Engineering(IJEME), Vol.8, No.1, pp.30- 39, 2018.DOI: 10.5815/ijeme.2018.01.04

Computer-based Forecasting, Health care, Hospital Pharmacy, Inventory, Out-of-Stock syndrome