Purchasing planning for pharmaceuticals inventory: a case study of drug warehouse in hospital

Praphan Yawara, Naratip Supattananon, Pinpicha Siwapornrak, Raknoi Akarrungruangkul

Abstract


Lack of purchasing planning and proper demand forecasting causes hospitals to suffer from drug inventory mismatches with actual demand; in other words, the inventory management cost is high if the quantity exceeds or less the demand. Therefore, this research aimed to plan an appropriate inventory purchase to reduce inventory costs and effectively meet the hospital's pharmaceutical inventory needs in a case study: i) demand forecasting for 29 AV drugs using Minitab 19, ii) economic order quantity (EOQ) and Newsboy form when drug demand is stable and non-steady, respectively, and iii) design a ready-made program using Excel program to help control, make purchase decisions and be easy to use. There were 5 forecasting methods used. Each drug forecasting method was selected from the one with the slightest error. Twenty-four drugs and five drugs were determined using EOQ and Newsboy forms for re-order point (ROP), safety stock (SS), and total costs. The total cost of drug inventory management per year was 1,780,336.98 baht; compared with the current method, it reduced the cost by 506,569.10 baht per year or a 22.15% reduction.

Keywords


Economic order quantity; Forecasting; Inventory; Newsboy; Purchasing planning

Full Text:

PDF


DOI: http://doi.org/10.11591/ijeecs.v31.i3.pp1496-1506

Refbacks

  • There are currently no refbacks.


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

Indonesian Journal of Electrical Engineering and Computer Science (IJEECS)
p-ISSN: 2502-4752, e-ISSN: 2502-4760
This journal is published by the Institute of Advanced Engineering and Science (IAES) in collaboration with Intelektual Pustaka Media Utama (IPMU).

shopify stats IJEECS visitor statistics