Case Study
Year: 2017 | Month: March | Volume: 2 | Issue: 1 | Pages: 11-17
An Excel-Based Inventory Control System Based on ABC and VED Analyses for Pharmacy: A Case Study
Hacer GünerGören1, Özge Dağdeviren1
1Asst. Prof. Department of Industrial Engineering, Pamukkale University, Kinikli Campus, 20070, Denizli, Turkey
Corresponding author: Hacer GünerGören1
ABSTRACT
In today's competitive environment, businesses that can offer products or services to users at any time, in any quantity and quality, have great advantages. Especially when these businesses are vital for human health, they need to keep staples of medicines, medical supplies and other support materials in sufficient quantity so that the service can continue without any interruption. Hospitals must keep drugs according to their cost and importance in order to minimize inventory and holding costs. For this purpose, inventory control techniques are needed in order to cut total expenses. The aim of this study was to determine the importance of drugs in a hospital’s pharmacy via ABC, VED and ABC-VED Matrix Analyses. Based on the results, order quantities were determined using Economic Order Quantity model. In order to cope with numerous drugs, an Excel-based inventory system was built to do the analyses quickly and efficiently.
Key words: Inventory management, ABC analysis, VED analysis, ABC-VED matrix, economic order quantity, pharmacy.