CN114093479A - Information processing method for making purchase plan based on medicine consumption data - Google Patents
Information processing method for making purchase plan based on medicine consumption data Download PDFInfo
- Publication number
- CN114093479A CN114093479A CN202111355007.1A CN202111355007A CN114093479A CN 114093479 A CN114093479 A CN 114093479A CN 202111355007 A CN202111355007 A CN 202111355007A CN 114093479 A CN114093479 A CN 114093479A
- Authority
- CN
- China
- Prior art keywords
- medicine
- inventory
- days
- stock
- purchase
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Classifications
-
- G—PHYSICS
- G16—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR SPECIFIC APPLICATION FIELDS
- G16H—HEALTHCARE INFORMATICS, i.e. INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR THE HANDLING OR PROCESSING OF MEDICAL OR HEALTHCARE DATA
- G16H40/00—ICT specially adapted for the management or administration of healthcare resources or facilities; ICT specially adapted for the management or operation of medical equipment or devices
- G16H40/20—ICT specially adapted for the management or administration of healthcare resources or facilities; ICT specially adapted for the management or operation of medical equipment or devices for the management or administration of healthcare resources or facilities, e.g. managing hospital staff or surgery rooms
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
- G06F16/2462—Approximate or statistical queries
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/08—Logistics, e.g. warehousing, loading or distribution; Inventory or stock management
- G06Q10/087—Inventory or stock management, e.g. order filling, procurement or balancing against orders
- G06Q10/0875—Itemisation or classification of parts, supplies or services, e.g. bill of materials
Landscapes
- Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- General Business, Economics & Management (AREA)
- Probability & Statistics with Applications (AREA)
- Economics (AREA)
- Health & Medical Sciences (AREA)
- General Physics & Mathematics (AREA)
- Biomedical Technology (AREA)
- General Health & Medical Sciences (AREA)
- Strategic Management (AREA)
- Tourism & Hospitality (AREA)
- Operations Research (AREA)
- Development Economics (AREA)
- Marketing (AREA)
- Finance (AREA)
- Human Resources & Organizations (AREA)
- Entrepreneurship & Innovation (AREA)
- Epidemiology (AREA)
- Quality & Reliability (AREA)
- Medical Informatics (AREA)
- Primary Health Care (AREA)
- Public Health (AREA)
- Accounting & Taxation (AREA)
- Fuzzy Systems (AREA)
- Mathematical Physics (AREA)
- Software Systems (AREA)
- Computational Linguistics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- Medical Treatment And Welfare Office Work (AREA)
Abstract
The invention discloses an information system processing method for making a purchasing plan based on medicine consumption data, which relates to the technical field of hospital medicine information processing and has the technical scheme key points that: calculating the weighted daily average usage amount of each medicine according to the daily usage amount of each medicine in the statistical time period and the statistical weight of different dates; calculating the use sequencing rate of each medicine according to the weighted number sequencing serial number of each medicine advice in the statistical time period; calculating the required quantity of each medicine according to the purchase planning days of the sorting rate interval where each medicine is located and the weighted daily average usage amount, and determining the purchase quantity of each medicine according to the lowest whole package quantity of the medicine and the inventory upper limit; dividing the existing inventory quantity of each medicine by the weighted daily usage quantity of the medicine to obtain the inventory available days of each medicine, and determining whether the medicine is purchased or not by combining the days from the current date to the next delivery date and the set inventory lower limit; the above-mentioned medicines and purchase quantity are combined with other information to form purchase schedule.
Description
Technical Field
The invention relates to the technical field of drug inventory management information processing, in particular to an information processing method for making a purchasing plan based on drug consumption data.
Background
One important task in material warehouse management is to make a purchase plan, and whether the purchase plan is reasonably related to the turnover rate of capital is further related to the use efficiency of capital, the delivery efficiency of materials, the inventory management cost, whether normal production and supply are affected, and the like. The current purchasing plan is made according to experience under most conditions, a slightly scientific purchasing plan is made according to a method for setting upper and lower limits of each material inventory, the purchasing plan is related to the management level and the management quality of management personnel, and the unscientific purchasing plan causes low fund utilization efficiency and reduces the distribution efficiency so as to increase the distribution cost, increase the inventory management cost and influence normal production and supply. The medicine is a special commodity or material, has the characteristics of life saving besides the characteristics of common commodities, and can influence the normal treatment of patients and even endanger the lives of the patients when the medicine is not supplied in time.
The well-known twenty-eight laws refer to: of any group, the most important accounts for only a small portion, about 20%, and the remaining 80%, although the majority, are secondary, and are called the twenty-eight law. In the stock management of materials, the two-eight law is also followed, and even if the item with the largest usage amount/use amount of 20%, the stock amount/stock amount accounts for about 80% of the total stock amount/total stock amount. Combining the commodity attributes and the use characteristics of the medicines, the medicine with the largest sorting rate of 20% is the largest factor influencing the inventory turnover rate, and the guarantee of the supply of the medicines is most important.
Based on the property of the drug for rescuing patients, for some situations with small usage amount but indispensable for rescuing patients, it is also necessary to ensure the supply of the part of drugs by properly increasing the number of days for inventory use and setting the lower limit of inventory, and at the same time, the total inventory amount is not greatly influenced.
Another characteristic of the use of drugs is that the usage amount and usage ranking rate of the same drugs may vary greatly in different seasons or years, especially when the national policy changes and the disease treatment guidelines are updated, and it is difficult to adapt the procurement plan prepared by the traditional method according to experience or the method of stock upper and lower limits to such variations, or it is not scientific and reasonable to increase the workload or to reset the stock upper and lower limits.
Accordingly, the present invention is directed to an information system for preparing a purchase plan from medicine consumption data to solve the above problems.
Disclosure of Invention
The present invention is directed to solving the above-mentioned problems, and an object of the present invention is to provide an information system processing method for preparing a purchase plan based on medicine consumption data.
The technical purpose of the invention is realized by the following technical scheme: an information system processing method for making a purchasing plan based on medicine consumption data comprises the following steps:
s1, configuring the statistical weights of different orders in the statistical time period and different dates by using the sorting rate through the information system of the purchasing plan, and configuring the purchasing plan days in the sorting rate using interval; setting an upper inventory limit and a lower inventory limit of each medicine; setting the whole packaging quantity of each medicine purchasing plan; setting a delivery period or delivery date for each drug;
s2, calculating the number of used medical orders of each medicine per day in the statistical time period, calculating the number of used weighted medical orders of each medicine by combining different date statistical weights, sequencing the used medical orders of each medicine from large to small or from small to large according to the number of used weighted medical orders, taking the number of medicines of which the number is not zero as a denominator and the sequencing number as a numerator, and calculating the use sequencing rate of the medical orders;
s3, calculating the daily usage of each drug in the statistical time period, calculating the weighted daily average usage of each drug by combining the system configuration, and converting the weighted daily average usage into a stock drug unit through a conversion coefficient;
s4, calculating the usable days of each drug stock according to the current stock quantity of each drug and the weighted daily average use quantity; calculating the estimated inventory quantity during the delivery according to the current inventory quantity, the weighted daily average usage amount and the days from the current date to the current purchasing date; when the number of available days in inventory is less than the number of days from the current date to the next delivery cycle, the medicine needs to be purchased in the current purchasing plan; or when the estimated inventory quantity during the delivery is less than the inventory lower limit set in the configuration file, the medicine needs to be purchased;
s5, calculating the required quantity of each medicine according to the interval of the use sorting rate of each medicine order and the configuration file, and then: the demand quantity is the weighted daily average usage quantity, the planning days of purchase-the current inventory quantity;
s6, calculating the required quantity of each medicine whole package by combining the required quantity with the set whole package quantity of each medicine purchasing plan; comparing the difference value between the whole package required quantity and the current inventory quantity with the set inventory upper limit, and if the difference value is larger than the inventory upper limit, taking the purchase quantity as the difference value between the inventory upper limit and the current inventory quantity; if the difference is smaller than the upper limit of the inventory, the purchase quantity is the difference between the whole package demand quantity and the current inventory quantity;
and S7, summarizing the purchase quantity of all the medicines to be purchased, and combining the basic attributes of each medicine, such as medicine code, medicine name, medicine specification, quantity unit, manufacturing enterprise, purchase plan execution object name, purchase plan making unit or department, to obtain the medicine purchase plan.
Further, the method of the system configuration and setting principle in step S1 is as follows:
s101, weight configuration principle: the closer to the current date, the higher the statistical weight ratio, and the farther from the current date, the lower the statistical weight ratio;
s102, configuring a principle of using the purchasing planning days of the sorting rate interval: the higher the usage ranking rate is, the fewer the purchase planning days are, the lower the usage ranking rate is, the more the purchase planning days are;
s103, setting the principle of upper and lower inventory limits: the upper and lower inventory limits are generally set according to experience, and the optimal method for setting the upper inventory limit is as follows: the principle of the inventory upper limit setting is that the maximum quantity of certain medicine goods places can be stored, and the inventory upper limit is set to be 0 under the condition that the medicine is not prepared; the method for setting the lower limit of the inventory comprises the following steps: setting a lower inventory limit, which generally belongs to rescue medicines or medicines in short supply, wherein the lower inventory limit is not lower than the total quantity of medicines required to be used for rescuing patients in a specific quantity, and the quantity of the patients in the specific quantity to be rescued is formulated according to the functional positioning of different hospitals or departments and the maximum number of patients to be diagnosed in a delivery period, or according to the expected shortage degree of each medicine, the quantity required to be used in the next possible delivery period is expected;
s104, setting the principle of the lowest whole package quantity of each medicine purchasing plan: the purchasing plan execution object sends out multiple times of medicine metering units contained in the minimum package of the medicine, wherein the purchasing plan execution object can be an upstream medicine supplier or all levels of medicine storehouses in a hospital;
s105, setting the delivery cycle or delivery date of each medicine: performing a time determination of the delivery of the object according to the procurement plan, the time determination being a day of the week or a day of the month or a day of the week or a day of the interval of the week or a number of days or a number of weeks; when the purchase plan execution object is delivery every day, the delivery period is 1; the interval belongs to a delivery period, the day of the week or the day of the week belongs to a delivery date, and the delivery dates can be set to be more than one;
further, the calculation method of the number of used weighted medical orders in step S2 needs to be determined according to the weight configuration in the configuration file, and the calculation method is as follows:
s201, weighting the number of use orders ∑ daily use order number ∑ daily statistical weight.
Further, the method for calculating the weighted daily average usage amount in step S3 needs to be determined according to the weight configuration in the configuration file, and the calculating method is as follows:
s301, when the sum of the weights of all days in the statistical time period is 100%, the calculation method of the weighted daily average usage amount comprises the following steps:
weighting daily average usage amount ∑ daily usage amount of each medicine ∑ the daily statistical weight;
s302, counting the weighted daily usage amount of which the sum of the weights of all days in the time period is not 100 percent:
weighted daily average usage (daily usage for each drug) the daily statistical weight/total days of all days weight.
Further, the method of determining whether to purchase the calculation in step S1 and step S4 is:
s401, step S1 do not set the inventory lower limit:
the number of usable days of the current inventory is less than or equal to the number of planned days, and the inventory needs to be purchased; the current inventory quantity can use days > planning days, and no purchase is needed;
s402 and step S1 are provided with a lower inventory limit:
if the number of usable days of the current inventory quantity is less than the planning number of days, purchasing is needed;
if the estimated inventory is less than the lower limit of the inventory during the delivery, purchasing is needed;
if the current inventory quantity can use days > planning days, and the estimated inventory quantity is greater than the inventory lower limit during the delivery, no purchase is needed;
wherein, the estimated stock at the current delivery is the current stock-the weighted daily average usage amount and the days from the current date to the current delivery date;
further, the calculation method of the whole package quantity of the procurement plan in the steps S1 and S6 is as follows:
s601, calculating the whole package quantity of the required quantity: [ required number divided by/lowest number of whole packages (rounded off) ]. lowest number of whole packages;
s602 and step S1 are not set for calculating the total package quantity of the inventory upper limit demand quantity: [ required number divided by/lowest number of whole packages (rounded off) ]. lowest number of whole packages;
s603, step S1 sets an upper limit of stock:
if the upper limit of the inventory is larger than or equal to the whole package quantity of the required quantity: the whole package purchase quantity is equal to the whole package required quantity;
if the upper limit of the stock quantity is less than the whole package quantity of the required quantity: the whole package purchase quantity is equal to the upper limit of the stock-the stock is estimated when the goods are delivered, and the whole package is selected according to the method of S601;
if the number of usable days in the stock is larger than the planned number of days, but the stock quantity is estimated to be less than the lower limit of the stock when the goods are delivered, and the whole package purchasing quantity is equal to the lower limit of the stock-the stock quantity is estimated when the goods are delivered;
s604, step S1 sets the lower limit of stock:
if the lower limit of the stock is set, the number of days of the stock can be used for planning days, but the stock quantity is estimated to be less than the lower limit of the stock when the goods are delivered, the whole package purchase quantity is the lower limit of the stock-the stock quantity is estimated when the goods are delivered, and the whole package purchase quantity is rounded according to the method of S601;
further, the procurement plan is used for procurement plans of hospital drug depots or replenishment plans of various pharmacies or entities.
Furthermore, the information system of the procurement plan is realized by a program or a software system by using a programming method, and the system program used by the information system of the procurement plan is realized by Fox, Foxpro, Pacical, C language, C + +, Delphi,. Net, JAVA, the programming language of Phython or WebService in combination with XML.
Further, the information system of the procurement plan is an independent operation program or is mounted in common software of the OA system, the hospital HIS system and the hospital logistics management system, or is a part of the hospital HIS system, the hospital logistics management system or the hospital medicine management system.
In conclusion, the invention has the following beneficial effects:
1. the purchase plan calculates the purchase quantity on the basis of the use sorting rate of the medical advice, the higher the use sorting rate is, the less the set purchase plan days are, so that the medicine turnover rate is higher, the purposes of effectively reducing inventory quantity and management cost are achieved, the fund turnover can be accelerated, and the fund use efficiency is improved to the maximum extent; the lower the usage sorting rate is, the more the number of days of the set purchasing plan is, so that the frequency of distributing the medicines is reduced under the condition of not increasing the inventory so as to reduce the distribution cost, and the normal supply and use of the medicines can be ensured;
2. the statistical weight setting method of the intervals with different use sequencing rates comprises the steps that the closer to the current date, the larger the statistical weight, the farther from the current date, the smaller the statistical weight, and therefore the closer the daily usage amount calculated according to the statistical weight is to the expected usage amount is, and the closer the purchase amount calculated according to the daily usage amount and the purchase number calculated according to the inventory available days is to the real expected data;
3. according to the invention, the upper limit of the stock is set according to the maximum quantity of the stocked goods, so that the change of the stock position can be effectively reduced, the storage management cost is effectively reduced, or the upper limit of the stock is set according to the expected shortage degree of the medicines, thereby ensuring that the medicines in shortage are not out of stock; the lower limit of the stock is set according to the quantity of the medicines needed to be used for rescuing patients or the expected shortage degree of the medicines, so that the condition that no medicine is available when the patients are rescued can be ensured;
4. according to the invention, whether each medicine is purchased or not is determined according to the delivery cycle or the delivery date and the available date of the stock, so that each medicine can be ensured to be continuously delivered before the next delivery, and the patient is ensured to be available for the medicine all the time;
5. in the invention, the preparation of the purchasing plan is not only suitable for the purchasing plan of the medicines in the medicine warehouse of the hospital, but also suitable for the preparation of the medicine supplementing plan of each pharmacy, and is suitable for the preparation of the medicine supplementing plan of the emergency medicine and the spare medicine in the ward;
6. according to the invention, the manual intervention can be effectively reduced and the workload of manually making the purchasing plan is reduced through the purchasing plan made by the program.
Drawings
FIG. 1 is a flow diagram of a drug procurement plan in an embodiment of the invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the present invention more apparent, the present invention is further described in detail with reference to the following embodiments. It should be understood that the specific embodiments described herein are merely illustrative of the invention and are not intended to limit the invention; the dosage of the medicine related to the invention is also called consumption in some occasions, and the difference of the terms does not influence the invention.
The scheme of the invention provides an information system processing method for making a purchasing plan based on medicine consumption data, which comprises the following steps:
s1, configuring the statistical weights of different orders in the statistical time period and different dates by using the sorting rate through the information system of the purchasing plan, and configuring the purchasing plan days in the sorting rate using interval; setting an upper inventory limit and a lower inventory limit of each medicine; setting the whole packaging quantity of each medicine purchasing plan; setting a delivery period or delivery date for each drug;
s2, calculating the number of used medical orders of each medicine per day in the statistical time period, calculating the number of used weighted medical orders of each medicine by combining different date statistical weights, sequencing the used medical orders of each medicine from large to small or from small to large according to the number of used weighted medical orders, taking the number of medicines of which the number is not zero as a denominator and the sequencing number as a numerator, and calculating the use sequencing rate of the medical orders;
s3, calculating the daily usage of each drug in the statistical time period, calculating the weighted daily average usage of each drug by combining the system configuration, and converting the weighted daily average usage into a stock drug unit through a conversion coefficient;
s4, calculating the usable days of each drug stock according to the current stock quantity of each drug and the weighted daily average use quantity; calculating the estimated inventory quantity during the delivery according to the current inventory quantity, the weighted daily average usage amount and the days from the current date to the current purchasing date; when the number of available days in inventory is less than the number of days from the current date to the next delivery cycle, the medicine needs to be purchased in the current purchasing plan; or when the estimated inventory quantity during the delivery is less than the inventory lower limit set in the configuration file, the medicine needs to be purchased;
s5, calculating the required quantity of each medicine according to the interval of the use sorting rate of each medicine order and the configuration file, and then: the demand quantity is the weighted daily average usage quantity, the planning days of purchase-the current inventory quantity;
s6, calculating the required quantity of each medicine whole package by combining the required quantity with the set whole package quantity of each medicine purchasing plan; comparing the difference value between the whole package required quantity and the current inventory quantity with the set inventory upper limit, and if the difference value is larger than the inventory upper limit, taking the purchase quantity as the difference value between the inventory upper limit and the current inventory quantity; if the difference is smaller than the upper limit of the inventory, the purchase quantity is the difference between the whole package demand quantity and the current inventory quantity;
and S7, summarizing the purchase quantity of all the medicines to be purchased, and combining the basic attributes of each medicine, such as medicine code, medicine name, medicine specification, quantity unit, manufacturing enterprise, purchase plan execution object name, purchase plan making unit or department, to obtain the medicine purchase plan.
The method of the system configuration and setting principle in step S1 is as follows:
s101, weight configuration principle: the closer to the current date, the higher the statistical weight ratio, and the farther from the current date, the lower the statistical weight ratio;
s102, configuring a principle of using the purchasing planning days of the sorting rate interval: the higher the usage ranking rate is, the fewer the purchase planning days are, the lower the usage ranking rate is, the more the purchase planning days are;
s103, setting the principle of upper and lower inventory limits: the upper and lower inventory limits are generally set according to experience, and the optimal method for setting the upper inventory limit is as follows: the principle of the inventory upper limit setting is that the maximum quantity of certain medicine goods places can be stored, and the inventory upper limit is set to be 0 under the condition that the medicine is not prepared; the method for setting the lower limit of the inventory comprises the following steps: setting a lower inventory limit, which generally belongs to rescue medicines or medicines in short supply, wherein the lower inventory limit is not lower than the total quantity of medicines required to be used for rescuing patients in a specific quantity, and the quantity of the patients in the specific quantity to be rescued is formulated according to the functional positioning of different hospitals or departments and the maximum number of patients to be diagnosed in a delivery period, or according to the expected shortage degree of each medicine, the quantity required to be used in the next possible delivery period is expected;
s104, setting the principle of the lowest whole package quantity of each medicine purchasing plan: the purchasing plan execution object sends out multiple times of medicine metering units contained in the minimum package of the medicine, wherein the purchasing plan execution object can be an upstream medicine supplier or all levels of medicine storehouses in a hospital;
s105, setting the delivery cycle or delivery date of each medicine: performing a time determination of the delivery of the object according to the procurement plan, the time determination being a day of the week or a day of the month or a day of the week or a day of the interval of the week or a number of days or a number of weeks; when the purchase plan execution object is delivery every day, the delivery period is 1; the interval belongs to the delivery period, the day of the week or the day of the week belongs to the delivery date, and the delivery date can be set to be more than one;
the calculation method of the number of used weighted medical orders in step S2 needs to be determined according to the weight configuration in the configuration file, and the calculation method is as follows:
s201, weighting the number of use orders ∑ daily use order number ∑ daily statistical weight.
The method for calculating the weighted daily average usage in step S3 needs to be determined according to the weight configuration in the configuration file, and the calculation method is as follows:
s301, when the sum of the weights of all days in the statistical time period is 100%, the calculation method of the weighted daily average usage amount comprises the following steps:
weighting daily average usage amount ∑ daily usage amount of each medicine ∑ the daily statistical weight;
s302, counting the weighted daily usage amount of which the sum of the weights of all days in the time period is not 100 percent:
weighted daily average usage (daily usage for each drug) the daily statistical weight/total days of all days weight.
The method for determining whether to purchase the computer in steps S1 and S4 includes:
s401, step S1 do not set the inventory lower limit:
the number of usable days of the current inventory is less than or equal to the number of planned days, and the inventory needs to be purchased; the current inventory quantity can use days > planning days, and no purchase is needed;
s402 and step S1 are provided with a lower inventory limit:
if the number of usable days of the current inventory quantity is less than the planning number of days, purchasing is needed;
if the estimated inventory is less than the lower limit of the inventory during the delivery, purchasing is needed;
if the current inventory quantity can use days > planning days, and the estimated inventory quantity is greater than the inventory lower limit during the delivery, no purchase is needed;
wherein, the estimated stock at the current delivery is the current stock-the weighted daily average usage amount and the days from the current date to the current delivery date;
the method for calculating the whole package quantity of the procurement plan in the steps S1 and S6 comprises the following steps:
s601, calculating the whole package quantity of the required quantity: [ required number divided by/lowest number of whole packages (rounded off) ]. lowest number of whole packages;
s602 and step S1 are not set for calculating the total package quantity of the inventory upper limit demand quantity: [ required number divided by/lowest number of whole packages (rounded off) ]. lowest number of whole packages;
s603, step S1 sets an upper limit of stock:
if the upper limit of the inventory is larger than or equal to the whole package quantity of the required quantity: the whole package purchase quantity is equal to the whole package required quantity;
if the upper limit of the stock quantity is less than the whole package quantity of the required quantity: the whole package purchase quantity is equal to the upper limit of the stock-the stock is estimated when the goods are delivered, and the whole package is selected according to the method of S601;
if the number of usable days in the stock is larger than the planned number of days, but the stock quantity is estimated to be less than the lower limit of the stock when the goods are delivered, and the whole package purchasing quantity is equal to the lower limit of the stock-the stock quantity is estimated when the goods are delivered;
s604, step S1 sets the lower limit of stock:
if the lower limit of the stock is set, the number of days of the stock can be used for planning days, but the stock quantity is estimated to be less than the lower limit of the stock when the goods are delivered, the whole package purchase quantity is the lower limit of the stock-the stock quantity is estimated when the goods are delivered, and the whole package purchase quantity is rounded according to the method of S601;
wherein the procurement plan is used for procurement plan of hospital drug depot or replenishment plan for each pharmacy or entity.
The information system of the purchasing plan is realized by a program or a software system by using a programming method, and the system program used by the information system of the purchasing plan is realized by Fox, Foxpro, Pacical, C language, C + +, Delphi,. Net, JAVA, Phython programming language or WebService combined with XML.
The information system of the procurement plan is an independent operation program or is mounted in common software of an OA system, a hospital HIS system and a hospital logistics management system, or is a part of the hospital HIS system, the hospital logistics management system or a hospital medicine management system.
In this embodiment, the preparation of a medicine purchasing plan in a hospital is taken as an example for explanation, if a specific pharmacy exists, all data are derived from data of the specific pharmacy, and if a spare medicine or an emergency medicine in a specific department exists, all data are derived from data of a spare medicine or an emergency medicine library in the specific department, and the latter two cases are not illustrated in the embodiment.
Example 1: example procurement plan profiles
The present embodiment is intended to be described by taking as an example the preparation of a hospital drug procurement plan, wherein the procurement period is wednesday per week and the current date is monday.
1. The number of days of the procurement plan is configured as follows:
2. the calculation formula of the purchasing planning days is configured as follows:
3. basic information, upper and lower inventory limits and the minimum whole packaging quantity of several medicines are set as follows:
example 2: statistical example of orders over the last 30 days for each drug:
according to "daily statistical weight of the daily use order pieces ∑ weighted order use pieces ∑ in combination with the actual order use pieces, the weighted order use pieces for each medicine are calculated as follows:
example 4: calculation of the ranking ratio of each drug
Calculating the weighted medical advice number of each medicine of the hospital according to the method, and sorting the medicines in a reverse order according to the weighted medical advice number, wherein the total number of the medicines, of which the weighted medical advice number is not zero, is denominator (the total number of the medicines in the embodiment is 900), the serial number is numerator, and calculating the sorting rate of each medicine, as shown in the following table:
| name of medicine | Number of weighted medical orders | Sequence number | Rank ratio |
| Aspirin enteric-coated tablet | 1941.961 | 1 | 0.11％ |
| 0.9% sodium chloride injection 250ml | 689.4 | 31 | 3.44％ |
| Ceftriaxone sodium for injection | 546.2 | 53 | 5.89％ |
| Piracetam capsule | 544.7 | 59 | 6.56％ |
| 0.9% sodium chloride injection 50ml | 500.6 | 84 | 9.33％ |
| 100ml of 5% glucose injection | 277.4 | 237 | 26.33％ |
| Ganciclovir injection | 48.1 | 427 | 47.44％ |
| Vitamin C Yinqiao tablet | 47.2 | 430 | 47.78％ |
| Oseltamivir granules | 32.8 | 556 | 61.78％ |
| Isatis root granules | 29.7 | 603 | 67.00％ |
| Pill of six ingredients with rehmannia (concentrated pill) | 23.8 | 695 | 77.22％ |
| Glycerol nitrate injection | 0.111 | 899 | 99.89％ |
Example 4: the weighted days within the last 30 days of each drug use a statistical example of the quantity:
according to the weighted daily average usage amount ∑ daily usage amount ∑ statistical weight of that day, in combination with the actual order usage amount, the weighted order usage amount per drug is as follows:
note: total daily average usage (in units of medical advice), i.e., total daily average usage (in units of medical advice)/conversion factor.
Example 5: the required quantity of each medicine and whether the purchasing example is needed are judged, and the calculation result is shown in the following table by combining the medicine stock and the setting:
the above table calculation illustrates:
1. the sorting rate and the weighted daily average usage amount are from example 4 and example 5;
2. the sequencing rate interval is calculated according to the sequencing rate interval in the configuration file where the sequencing rate of each medicine is located, and the planned days are set as the numerical values set in the configuration file corresponding to the sequencing rate;
3. the upper limit of the stock, the lower limit of the stock and the minimum whole packaging quantity are derived from preset data;
4. the current inventory quantity is derived from data in the HIS system;
5. the current inventory quantity available days are equal to the current inventory quantity/weighted daily average usage;
6. when the goods are delivered, the estimated stock is the current stock quantity-weighted daily average use quantity x 2, wherein 2 is 2 days from the current date to the current purchasing date;
7. weighted daily average usage number purchase days-current inventory number
8. Calculation of whether to purchase:
there are three cases:
8.1 if the lower inventory limit is not set:
1) if the current inventory quantity can be used for more days than planning days, no purchase is needed;
in the example 50ml of 0.9% sodium chloride injection is the case
2) If the number of usable days of the current inventory quantity is less than the planning number of days, purchasing is needed;
this is the case for most of the drugs in the examples where the lower limit of inventory is not set;
8.2 if the lower limit of the stock is set:
1) if the current inventory quantity can be used for days < planning days, purchasing is needed
2) If the estimated inventory is less than the lower limit of the inventory during the delivery, the purchase is required
Oseltamivir granules belong to this case;
3) if the current inventory quantity can use days > planning days, and the estimated inventory quantity is greater than the inventory lower limit during the delivery, no purchase is needed.
This is the case with the injectable ceftriaxone in the examples.
9. Planning the number of whole packages includes two steps and four cases:
9.1 calculation of the required quantity and the whole package quantity: [ required quantity divided by/lowest whole package quantity (rounded off) ]. minimum whole package quantity.
9.2 if the upper limit of the stock is not set, the whole package purchase quantity is equal to the whole package required quantity
9.3 if the stock upper limit is set, comparing the whole package quantity of the required quantity with the stock upper limit:
1) if the upper limit of the stock is not less than the whole package quantity of the required quantity
The whole package purchase quantity is equal to the whole package required quantity;
the examples include ceftriaxone and radix Isatidis granule for injection.
2) If the upper limit of the stock quantity is less than the whole package quantity of the required quantity
The whole package purchase quantity is equal to the upper limit of the stock-the stock is estimated when the goods are delivered, and the whole package is selected according to the method of 9.1;
this is the case with the six ingredient rehmannia pills of the examples.
9.4 if the lower limit of stock is set, the number of usable days of stock > planned days, but the stock quantity is expected to be < the lower limit of stock at the time of the present shipment.
The whole package purchase quantity is equal to the inventory lower limit-the estimated inventory quantity at the time of the delivery is rounded up according to the method of 9.1.
Oseltamivir granules are in this case.
10. In the estimated inventory amount during the delivery, the piracetam capsules are negative, which indicates that the current inventory amount is not enough for the purchase, so whether the purchase is urgent or not needs to be carried out before large-batch purchase.
Example 6: example procurement schedules
In the embodiment of the invention, the purchase plan is made according to the ordering rate of the use of medical advice, the higher the utilization rate is, the fewer the days of the purchase plan are, and the inventory can be effectively reduced, and the aspirin enteric-coated tablet and the 0.9% sodium chloride injection 250ml in the embodiment can effectively ensure the clinical use, can effectively reduce the whole inventory, reduce the inventory management cost and accelerate the fund turnover only by purchasing 10 days because the ordering rate of the use is less than or equal to 5%; in the setting method of the statistical weight, the closer to the current date, the larger the statistical weight is, the closer to the situation of subsequent use, and the weighted daily average use amount and the weighted medical advice use rate calculated according to the statistical weight are more scientific and closer to reality; the upper limit of the inventory related in the invention is set according to the maximum storage capacity of the inventory, so that the frequent change of the goods location can be effectively avoided, and the problem of overlarge purchase amount calculated due to the abnormal use in the near term can be avoided, which is the case of the pill (concentrated pill) of six ingredients with rehmannia in the embodiment; the lower inventory limit is set in the embodiment, so that on one hand, the minimum inventory of the rescue medicines is guaranteed to ensure that the rescue patients can use the medicines, such as the glycerin nitrate injection in the embodiment, and on the other hand, the lower inventory limit is set for the medicines which are currently or expected to be in short supply, so that the phenomenon that no medicines are clinically available due to untimely supply is guaranteed to occur, such as oseltamivir granules in the embodiment.
The present embodiment is only for explaining the present invention, and it is not limited to the present invention, and those skilled in the art can make modifications of the present embodiment without inventive contribution as needed after reading the present specification, but all of them are protected by patent law within the scope of the claims of the present invention.
The present embodiment is only for explaining the present invention, and it is not limited to the present invention, and those skilled in the art can make modifications of the present embodiment without inventive contribution as needed after reading the present specification, but all of them are protected by patent law within the scope of the claims of the present invention.
Claims (9)
1. An information system processing method for making a purchase plan based on medicine consumption data is characterized by comprising the following steps: the method comprises the following steps:
s1, configuring the statistical weights of different orders in the statistical time period and different dates by using the sorting rate through the information system of the purchasing plan, and configuring the purchasing plan days in the sorting rate using interval; setting an upper inventory limit and a lower inventory limit of each medicine; setting the whole packaging quantity of each medicine purchasing plan; setting a delivery period or delivery date for each drug;
s2, calculating the number of used medical orders of each medicine per day in the statistical time period, calculating the number of used weighted medical orders of each medicine by combining different date statistical weights, sequencing the used medical orders of each medicine from large to small or from small to large according to the number of used weighted medical orders, taking the number of medicines of which the number is not zero as a denominator and the sequencing number as a numerator, and calculating the use sequencing rate of the medical orders;
s3, calculating the daily usage of each drug in the statistical time period, calculating the weighted daily average usage of each drug by combining the system configuration, and converting the weighted daily average usage into a stock drug unit through a conversion coefficient;
s4, calculating the usable days of each drug stock according to the current stock quantity of each drug and the weighted daily average use quantity; calculating the estimated inventory quantity during the delivery according to the current inventory quantity, the weighted daily average usage amount and the days from the current date to the current purchasing date; when the number of available days in inventory is less than the number of days from the current date to the next delivery cycle, the medicine needs to be purchased in the current purchasing plan; or when the estimated inventory quantity during the delivery is less than the inventory lower limit set in the configuration file, the medicine needs to be purchased;
s5, calculating the required quantity of each medicine according to the interval of the use sorting rate of each medicine order and the configuration file, and then: the demand quantity is the weighted daily average usage quantity, the planning days of purchase-the current inventory quantity;
s6, calculating the required quantity of each medicine whole package by combining the required quantity with the set whole package quantity of each medicine purchasing plan; comparing the difference value between the whole package required quantity and the current inventory quantity with the set inventory upper limit, and if the difference value is larger than the inventory upper limit, taking the purchase quantity as the difference value between the inventory upper limit and the current inventory quantity; if the difference is smaller than the upper limit of the inventory, the purchase quantity is the difference between the whole package demand quantity and the current inventory quantity;
and S7, summarizing the purchase quantity of all the medicines to be purchased, and combining the basic attributes of each medicine, such as medicine code, medicine name, medicine specification, quantity unit, manufacturing enterprise, purchase plan execution object name, purchase plan making unit or department, to obtain the medicine purchase plan.
2. The information system processing method for preparing a procurement plan based on drug consumption data according to claim 1, characterized by: the method of the system configuration and setting principle in step S1 is as follows:
s101, weight configuration principle: the closer to the current date, the higher the statistical weight ratio, and the farther from the current date, the lower the statistical weight ratio;
s102, configuring a principle of using the purchasing planning days of the sorting rate interval: the higher the usage ranking rate is, the fewer the purchase planning days are, the lower the usage ranking rate is, the more the purchase planning days are;
s103, setting the principle of upper and lower inventory limits: the upper and lower inventory limits are generally set according to experience, and the optimal method for setting the upper inventory limit is as follows: the principle of the inventory upper limit setting is that the maximum quantity of certain medicine goods places can be stored, and the inventory upper limit is set to be 0 under the condition that the medicine is not prepared; the method for setting the lower limit of the inventory comprises the following steps: setting a lower inventory limit, which generally belongs to rescue medicines or medicines in short supply, wherein the lower inventory limit is not lower than the total quantity of medicines required to be used for rescuing patients in a specific quantity, and the quantity of the patients in the specific quantity to be rescued is formulated according to the functional positioning of different hospitals or departments and the maximum number of patients to be diagnosed in a delivery period, or according to the expected shortage degree of each medicine, the quantity required to be used in the next possible delivery period is expected;
s104, setting the principle of the lowest whole package quantity of each medicine purchasing plan: the purchasing plan execution object sends out multiple times of medicine metering units contained in the minimum package of the medicine, wherein the purchasing plan execution object can be an upstream medicine supplier or all levels of medicine storehouses in a hospital;
s105, setting the delivery cycle or delivery date of each medicine: performing a time determination of the delivery of the object according to the procurement plan, the time determination being a day of the week or a day of the month or a day of the week or a day of the interval of the week or a number of days or a number of weeks; when the purchase plan execution object is delivery every day, the delivery period is 1; the interval belongs to the delivery period, the day of the week or the day of the week belongs to the delivery date, and the delivery date can be set to be more than one.
3. The information system processing method for preparing a procurement plan based on drug consumption data according to claim 1, characterized by: the calculation method of the number of used weighted medical orders in step S2 needs to be determined according to the weight configuration in the configuration file, and the calculation method is as follows:
s201, weighting the number of use orders ∑ daily use order number ∑ daily statistical weight.
4. The information system processing method for preparing a procurement plan based on drug consumption data according to claim 1, characterized by: the method for calculating the weighted daily average usage amount in step S3 needs to be determined according to the weight configuration in the configuration file, and the calculation method is as follows:
s301, when the sum of the weights of all days in the statistical time period is 100%, the calculation method of the weighted daily average usage amount comprises the following steps:
weighting daily average usage amount ∑ daily usage amount of each medicine ∑ the daily statistical weight;
s302, counting the weighted daily usage amount of which the sum of the weights of all days in the time period is not 100 percent:
weighted daily average usage (daily usage for each drug) the daily statistical weight/total days of all days weight.
5. The information system processing method for preparing a procurement plan based on drug consumption data according to claim 1, characterized by: the method of determining whether to purchase the calculation in step S1 and step S4 is:
s401, step S1 do not set the inventory lower limit:
the number of usable days of the current inventory is less than or equal to the number of planned days, and the inventory needs to be purchased; the current inventory quantity can use days > planning days, and no purchase is needed;
s402 and step S1 are provided with a lower inventory limit:
if the number of usable days of the current inventory quantity is less than the planning number of days, purchasing is needed;
if the estimated inventory is less than the lower limit of the inventory during the delivery, purchasing is needed;
if the current inventory quantity can use days > planning days, and the estimated inventory quantity is greater than the inventory lower limit during the delivery, no purchase is needed;
the estimated stock at the time of the delivery is the current stock-weighted daily average usage amount and the number of days from the current date to the current delivery date.
6. The information system processing method for preparing a procurement plan based on drug consumption data according to claim 1, characterized by: the calculation method of the whole package quantity of the procurement plan in the step S1 and the step S6 is as follows:
s601, calculating the whole package quantity of the required quantity: [ required number divided by/lowest number of whole packages (rounded off) ]. lowest number of whole packages;
s602 and step S1 are not set for calculating the total package quantity of the inventory upper limit demand quantity: [ required number divided by/lowest number of whole packages (rounded off) ]. lowest number of whole packages;
s603, step S1 sets an upper limit of stock:
if the upper limit of the inventory is larger than or equal to the whole package quantity of the required quantity: the whole package purchase quantity is equal to the whole package required quantity;
if the upper limit of the stock quantity is less than the whole package quantity of the required quantity: the whole package purchase quantity is equal to the upper limit of the stock-the stock is estimated when the goods are delivered, and the whole package is selected according to the method of S601;
if the number of usable days in the stock is larger than the planned number of days, but the stock quantity is estimated to be less than the lower limit of the stock when the goods are delivered, and the whole package purchasing quantity is equal to the lower limit of the stock-the stock quantity is estimated when the goods are delivered;
s604, step S1 sets the lower limit of stock:
if the lower limit of stock is set, the number of days available for stock > planned days, but the estimated stock quantity at the time of this delivery is < the lower limit of stock, and the total package purchase quantity is the lower limit of stock-the estimated stock quantity at the time of this delivery is rounded up by the method of S601.
7. The information system processing method for preparing a procurement plan based on drug consumption data according to claim 1, characterized by: the procurement plan is used for procurement plan of hospital drug depot or replenishment plan of each pharmacy or entity.
8. The information system processing method for preparing a procurement plan based on drug consumption data according to claim 1, characterized by: the information system of the purchasing plan is realized by a program or a software system by using a programming method, and the system program used by the information system of the purchasing plan is realized by Fox, Foxpro, Pacical, C language, C + +, Delphi,. Net, JAVA, Phython programming language or WebService combined with XML.
9. The information system processing method for preparing a procurement plan based on drug consumption data according to claim 1, characterized by: the information system of the purchasing plan is an independent operation program or is mounted in common software of an OA system, a hospital HIS system and a hospital logistics management system, or is one part of the hospital HIS system, the hospital logistics management system or a hospital medicine management system.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111355007.1A CN114093479A (en) | 2021-11-16 | 2021-11-16 | Information processing method for making purchase plan based on medicine consumption data |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111355007.1A CN114093479A (en) | 2021-11-16 | 2021-11-16 | Information processing method for making purchase plan based on medicine consumption data |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN114093479A true CN114093479A (en) | 2022-02-25 |
Family
ID=80300936
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202111355007.1A Pending CN114093479A (en) | 2021-11-16 | 2021-11-16 | Information processing method for making purchase plan based on medicine consumption data |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN114093479A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN116109283A (en) * | 2023-04-12 | 2023-05-12 | 中川建投集团有限公司 | Digital project management collaboration platform |
| CN116777377A (en) * | 2023-06-25 | 2023-09-19 | 深圳市诺飞科技开发有限公司 | Enterprise management office platform system based on cloud ERP management |
-
2021
- 2021-11-16 CN CN202111355007.1A patent/CN114093479A/en active Pending
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN116109283A (en) * | 2023-04-12 | 2023-05-12 | 中川建投集团有限公司 | Digital project management collaboration platform |
| CN116777377A (en) * | 2023-06-25 | 2023-09-19 | 深圳市诺飞科技开发有限公司 | Enterprise management office platform system based on cloud ERP management |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN114093479A (en) | Information processing method for making purchase plan based on medicine consumption data | |
| US8744897B2 (en) | Sample store forecasting process and system | |
| US7921029B2 (en) | Projection factors for forecasting product demand | |
| US20200251209A1 (en) | Automated utilization driven inventory management | |
| US8078488B2 (en) | System and method for determining trailing data adjustment factors | |
| US7813953B2 (en) | System and method for product level projections of pharmacy prescriptions within product therapy classes | |
| CN111599435B (en) | Intelligent pharmacy data processing method and device based on medical advice information | |
| US11023979B2 (en) | Reference price index for pharmaceutical products | |
| US20090287540A1 (en) | System And Method For Allocating Prescriptions To Non-Reporting Outlets | |
| CN111599453B (en) | Intelligent pharmacy data processing method and device, computer equipment and storage medium | |
| Song et al. | Making medicines more accessible in China: an empirical study investigating the early progress of essential medicine system | |
| CN108657709B (en) | Medicine supplementing method | |
| Subratha et al. | Inventory management using matrix analysis and inventory index in an oncology pharmacy of a tertiary care teaching hospital | |
| WO2020074207A1 (en) | Product supply apparatus | |
| Dredge et al. | Vaccinating Health Care Supply Chains Against Market Failure: The Case of Civica Rx | |
| Khasanah et al. | OVERVIEW OF FACTORS INFLUENCING DRUG MANAGEMENT AT PRIMARY HEALTH CENTERS IN INDONESIA: A SYSTEMATIC REVIEW | |
| EP3637334A1 (en) | Product planning apparatus | |
| Chen et al. | Simulation-based optimization approach to clinical trial supply chain management | |
| WO2006080987A2 (en) | Sample store forecasting process and system | |
| de Carvalho | OPTIMIZING PERISHABLE | |
| US20230307109A1 (en) | Interaction between pharmaceutical dispensing devices | |
| Khouja et al. | What Ails Drug Supply Chains? A Model for Diagnosis and Suggestions for a Cure | |
| Felizzi et al. | PNS51 SHIFTING THE MARKET ACCESS FRAMEWORK TO INVESTMENT DECISIONS IN EARLY ASSETS | |
| Sarno | A holistic approach to hospital material management process reengineering by means of the MRP algorithm | |
| Grootendorst et al. | The impact of reference pricing of cardiovascular drugs on health care costs and health outcomes: evidence from British Columbia Volume II: Technical Report |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication |