采用VBA编制中药采购软件

发布时间：2018-03-06 02:32

本文选题：中草药　切入点：采购　出处：《山东大学》2016年硕士论文　论文类型：学位论文

【摘要】：目前,我国医疗卫生行业的改革不断深入,物流、计算机等相关行业也有较大的发展,先进的管理理念为医药行业的效率提升提供了智力支持,但由于药品种类繁多,供货商情况各异,药品管理人员水平限制,导致药品采购和库存管理工作难度较大。如何根据医院自身情况,制定合理的药品管理和采购方案,是各个医院都需要解决的问题。本文通过回顾式研究和比较分析,与其他医院相比较,分析本院中药采购流程和现有采购方法的不足之处,使用因果分析法查找问题的所在,对问题进行深入研究,通过对原采购方式进行分析、改造、检验和改善四个步骤,设计出新的采购模型,改良采购算法,引入销量预测和计算机辅助,使采购方法更加科学,采购数量更具有客观性,完成对现有中药采购方式的改良。本文分四部分,第一部分为绪论,主要讲述了本文的选题背景,分析了目前我院中药采购流程和采购方式中存在的不足,介绍了国内外相关行业的采购理念和模式。通过分析,提出了使用因果分析法查找存在的问题,然后对问题进行分析和改善,最终解决问题的思路。第二部分阐述了设计新的药品采购过程所需的基本理论,包括因果分析法、预测和PDCA循环理论。通过因果分析法,分析出自身的情况、需求、不足和目标,找出解决问题思路。通过采集、分析数据,运用预测原理,对采购数量进行计算。通过PDCA循环对采购的行为不断设计、执行、检验、改进,最终达到完善的过程。第三部分为本文的研究内容,论文通过对本院情况和需求的具体分析,确定了软件的设计原则、设计目标、设计流程,通过VBA编程,实现了设计要求。通过软件使用前后的对比,说明软件较好的改善了药品采购工作。通过PDCA循环,对软件不断改进,使之适应医院中药采购的需求。第四部分为讨论部分,讲述了使用中药采购软件后医院采购水平的提升；软件通过PDCA循环不断改进；该软件投入使用后,对医院药品管理带来的影响。本文通过编制药品采购软件,将计算机辅助和预测技术引入到药品采购管理领域,并结合因果分析法、预测技术和PDCA循环改进理论对原采购方式进行改进,这对提高医院药品管理水平,改进采购方法做出了一定程度的论述和探讨,具有较强的借鉴作用和价值。
[Abstract]:At present, the reform of the medical and health industry in our country is deepening, and the related industries, such as logistics, computer, etc., have also developed greatly. Advanced management concepts have provided intellectual support for the efficiency improvement of the pharmaceutical industry, but because of the wide variety of drugs, The situation of suppliers varies and the level of drug management personnel is restricted, which leads to the difficulty of drug procurement and inventory management. How to formulate a reasonable drug management and purchase plan according to the hospital's own situation, Through retrospective research and comparative analysis, compared with other hospitals, this paper analyzes the shortcomings of the traditional Chinese medicine procurement process and existing procurement methods, and uses causality analysis to find out where the problem lies. Through the four steps of analyzing, reforming, testing and improving the original purchasing method, the author designs a new purchasing model, improves the purchasing algorithm, introduces the sales forecast and computer aid, and makes the purchasing method more scientific. This paper is divided into four parts, the first part is the introduction, mainly describes the background of this paper. This paper analyzes the shortcomings in the procurement process and mode of traditional Chinese medicine in our hospital at present, introduces the purchasing concepts and modes of related industries at home and abroad. Through the analysis, the paper puts forward the problem of using causality analysis method to find out the existing problems. Then the problem is analyzed and improved to solve the problem. The second part describes the basic theory needed to design the new drug procurement process, including causality analysis, prediction and PDCA cycle theory. Through collecting, analyzing the data, applying the forecast principle, calculating the purchase quantity, designing, executing and checking the purchasing behavior through the PDCA cycle, we can find out the situation, the demand, the insufficiency and the target of the purchase, and find out the way to solve the problem. The third part is the research content of this paper. Through the concrete analysis of the situation and demand of our hospital, the software design principle, design goal, design flow, and programming through VBA are determined. Through the comparison of the software before and after the use of the software, it is shown that the software has improved the drug procurement work. Through the PDCA cycle, the software has been continuously improved to meet the needs of hospital Chinese medicine procurement. Part 4th is the discussion part. This paper describes the improvement of hospital procurement level after the use of traditional Chinese medicine procurement software; the continuous improvement of the software through the PDCA cycle; the impact on hospital drug management after the software is put into use. This paper introduces computer-aided and predictive techniques into the field of drug procurement management, and combines causality analysis, prediction technology and PDCA cycle improvement theory to improve the original purchasing methods, which can improve the level of drug management in hospitals. The improvement of purchasing method is discussed and discussed to a certain extent, which has strong reference function and value.
【学位授予单位】：山东大学
【学位级别】：硕士
【学位授予年份】：2016
【分类号】：R288;TP311.52

【相似文献】