Automation of Pharmacy Inventory Management

Automation of Pharmacy Inventory Management

Pharmacy inventory management (PIM) comprises business activities which are connected with the size and placement of stocked drugs. To manage minimal and maximal drugs stock, orders dynamics etc., pharmacies must track expiration dates of each drug in stock. Outdated drugs can’t be counted as stock and produce lot of costs, especially for their disposal. The most number of pharmacies in Bosnia use European Article Numbering (EAN13) barcode by which is impossible to define drug expiration dates. Radio Frequency Identification (RFID) enables full automatization of PIM, but it is still not in use, mostly because of high costs of implementation of this system. In our research we have observed 52 Bosnian pharmacies and presented another approach to barcode technology which can be used in automatization of PIM. As the base we have used existing EAN13 code, adding 6 digits for expiration dates. We have successfully created and tested program for extraction of EAN13 and expiration dates from that barcode using separate files in database to keep inputs, outputs and stocks of each item by expiration dates

___

  • Association for Automatic Identification and Mobility. (2010) Technologies: Bar Code & RFID Retrieved from http://www.aimglobal.org/technologies/barcode/
  • Charlotte, A. S. (2002) Managing Pharmaceutical Waste. Journal of the Pharmacy Society of Wisconsin. Retrieved from www.premierinc.com/safety/topics/epp/downloads/PSW_article.pdf
  • McCarthy, G. (2005) Managing Pharmaceutical Waste. Connecticut Hospital Roundtable. Retrieved from www.ct.gov/dep/lib/dep/p2/institution/pharmaceutical_waste.pdf
  • Sofvelocity Inc. (2011) Clarion Language Programming, Pompano Beach, Florida.
  • Softvelocity Inc. (2011) Data Modeller, Pompano Beach, Florida.
  • Sysoptima, (2005) . Inventory Management Overview - Demand Forecasting, Inventory Monitoring and Inventory Reporting. Retrieved from http://www.sysoptima.com/scm/inventory_management.php
  • Šabanović, Z., Osmanbegović, E., (2010) The role of barcode technology in inventory management. Conference proceedings. Management, izobraževanje in turizem. Portorož. Slovenia.