VED分类法和Excel工作表制订药品采购计划应用探讨  

Investigation on Drug Purchase Plan Formulated by VED Classification Method and Excel Worksheet

作　　者：尹希 张仕利 于秋影 

机构地区：[1]四川省眉山市人民医院,四川眉山620020

出　　处：《中国药业》2018年第2期87-89,共3页China Pharmaceuticals

摘　　要：目的探讨如何利用VED(vital essential desirable)分类法和Excel工作表制订药品采购计划并实施采购监管,及其对提高药品周转率的作用。方法根据VED分类法确定药品基础库存天数,收集医院信息管理系统(HIS)中药品记录,利用Excel软件的数据处理功能,实现药品计划的制订及实施情况统计。结果药品周转率由2015年5月至2016年4月的1 812.95%上升到2016年5月至2017年4月的2 767.35%。结论在供货商正常供货的前提下,利用该方法制订药品采购计划并执行,能有效地提高药品周转率,节约人工成本。Objective To investigate the effect of using vital essential desirable（ VED） classification method and Excel worksheet to formulate drug purchase plan and implement procurement supervision to improve the turnover rate of drug. Methods The days of drug base inventory were determined according to the VED classification method,the records of drugs were collected from HIS system,the data processing function of Excel tool was used to realize the formulation and implementation of drug purchase plan. Results The turnover rate of drugs rose from 1 812. 95% from May 2015 to April 2016,up to 2 767. 35% from May 2016 to April 2017. Conclusion On the premise of the suppliers＇ normal supply,making use of this method to formulate the drug purchase plan and implementing it can effectively improve the drug turnover rate and save the labor costs.

关 键 词：VED分类法 EXCEL工作表 药品采购计划 药品周转率 医院药品管理 

分 类 号：R952[医药卫生—药学]