JP2004302593A - Medicine distribution management system and medicine distribution management program - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To enable a medicine maker to plan production with high precision according to accurate distribution information. <P>SOLUTION: A third management computer 5 collects past medicine consumption information on each medicine distribution terminal institution 11<SB>1</SB>to<SB>m</SB>, calculates a predicted future consumption of each medicine in each medicine distribution terminal institution 11<SB>1</SB>to<SB>m</SB>according to the collection result, and transmits it to a second management computer 4. According to the collection of the received predicted consumption of each medicine in each medicine distribution terminal institution 11<SB>1</SB>to<SB>m</SB>, the second management computer 4 calculates predicted future shipments of each medicine to the medicine distribution terminal institutions 11<SB>1</SB>to<SB>m</SB>for each medicine wholesaler 10<SB>1</SB>to<SB>n</SB>, and transmits them to a first management computer 3. According to the collection of the received predicted shipments of each medicine for each medicine wholesaler 10<SB>1</SB>to<SB>n</SB>, the first management computer 3 plans production of each medicine. <P>COPYRIGHT: (C)2005,JPO&NCIPI

Description

[0001]
TECHNICAL FIELD OF THE INVENTION
The present invention relates to a drug distribution management system and a program for collectively managing the distribution of a drug between a drug manufacturer, a drug wholesaler, and a drug distribution terminal facility (a hospital, a pharmacy, or the like).
[0002]
[Prior art]
2. Description of the Related Art Conventionally, as a system for managing drug distribution, a system for managing drug distribution between a drug wholesaler and a drug distribution terminal facility (hospital, pharmacy, or the like) has been considered (see Patent Document 1).
[0003]
[Patent Document 1]
JP-A-2002-149819
[0004]
[Problems to be solved by the invention]
However, a system for performing drug distribution management including a management computer for manufacturing control of a drug maker has not been constructed. Therefore, a drug maker formulates a highly accurate manufacturing plan based on accurate distribution information. There was a problem that it was difficult.
[0005]
[Means for Solving the Problems]
In order to achieve the above-mentioned object, a medicine distribution management system according to the present invention includes a first management computer for managing a medicine production of a medicine maker, an inventory of various kinds of medicines purchased from the medicine maker, and an order destination. A second management computer that manages the inventory of one or more drug wholesalers to be delivered to one or more drug distribution terminal facilities that temporarily stock and then consume or sell the drugs purchased from the drug wholesalers. A third management computer that performs medicine inventory management.
[0006]
These first to third management computers are communicably connected via an electric communication line.
[0007]
A function of summing up past drug consumption information of each of the medicine distribution end facilities and calculating a future consumption expectation of each medicine in each of the medicine distribution end facilities based on the summation result; And transmitting the estimated wear to the second management computer.
[0008]
The second management computer, based on the aggregation of the consumption prediction of each drug in each of the medicine distribution terminal facilities received from the third management computer, predicts future shipment of each drug to the medicine distribution terminal facility. And a function of transmitting the calculated shipping forecast to the first management computer.
[0009]
The first management computer executes a function of drafting a production plan of each medicine based on the total of the shipping prediction of each medicine for each medicine wholesale received from the second management computer.
[0010]
In addition, the medicine distribution management program of the present invention includes a first management program for managing medicine production of a medicine maker, and one or a plurality of medicines that once stock various kinds of medicines purchased from the medicine maker and deliver them to an order destination. A second management program for managing the inventory of medicines at the drug wholesaler, and a third management for inventorying one or more drug distribution terminal facilities that once consume and sell or sell the medicines purchased from the wholesaler. It has a management program.
[0011]
These programs are programs that are installed in computers that are communicably connected to each other via an electric communication line.
[0012]
The third management program includes a function of summing up past drug consumption information of each of the drug distribution terminal facilities and calculating a future consumption prediction of each drug in each of the drug distribution terminal facilities based on the result of the calculation. And a function of transmitting the estimated consumption to the second management program by the computer on which the third management program is installed.
[0013]
The second management program is configured to calculate a future shipment forecast of each drug to the drug distribution terminal facility based on a total of the consumption prediction of each drug in the drug distribution terminal facility received from the third management program. The computer in which the second management program is installed executes a function of calculating for each chemical wholesaler and a function of transmitting the calculated shipping forecast to the first management program.
[0014]
The first management program has a function of drafting a production plan for each medicine based on the total of the shipment predictions of each medicine for each medicine wholesale received from the second management program, according to the first management program. A program to be executed by the computer on which the program is installed.
[0015]
The present invention calculates a shipping forecast of a drug wholesaler based on a sum of consumption forecasts of a drug distribution terminal facility, and drafts a manufacturing plan for each drug based on the calculated total of the drug wholesaler shipping forecast. For this reason, the planned production plan of the chemical manufacturer conforms to the actual consumption state, and there is no inconvenience such as wasted production or insufficient production.
[0016]
The second management computer (program) estimates a future stock change of each medicine in each of the medicine distribution terminal facilities based on the consumption forecast, and then estimates the estimated stock change of each medicine and the consumption forecast. It is preferable to calculate the shipping forecast of each medicine in each of the medicine wholesalers based on the above. This makes it possible to formulate a manufacturing plan based on the stock status of the drug distribution terminal facilities, and further increases the accuracy of the manufacturing plan.
[0017]
The first management computer (program) estimates a future stock change of each medicine in each of the medicine wholesalers based on the shipment forecast, and then calculates the estimated stock change of each medicine and the shipment forecast. It is preferable to make a production plan for each chemical on the basis of this. Then, it is possible to formulate a manufacturing plan based on the stock status of the chemical wholesaler, and accordingly, the accuracy of planning the manufacturing plan is further improved.
[0018]
It is preferable that the third management computer (program) performs inventory management and order management of each medicine at each medicine distribution terminal facility based on the consumption prediction. Then, it is possible to accurately perform inventory / order management in the medicine distribution terminal facility using the consumption prediction created in the present invention.
[0019]
It is preferable that the second management computer (program) performs inventory management and order management of each medicine in each medicine wholesaler based on the shipment prediction. Then, inventory and order management at the drug distribution terminal facility can be performed with high accuracy using the prediction created in the present invention.
[0020]
The second management computer (program) preferably divides the drug distribution terminal facilities into facility groups for each region, and further calculates the shipping forecast for each of the divided facility groups. . Then, it becomes possible to grasp the consumption information of the medicine in a state of being divided for each region.
[0021]
BEST MODE FOR CARRYING OUT THE INVENTION
FIG. 1 is a system diagram showing a configuration of a medicine distribution management system 1 of the present embodiment. The medicine distribution management system 1 includes a first management computer 3, a second management computer 4, and a third management computer 5. The computers 3, 4, and 5 are communicably connected to each other by an electric communication line 2. The telecommunication line 2 is constituted by, for example, an optical fiber cable network, and the computers 3, 4, and 5 are communicably connected to each other by a LAN (Local Area Network) constituted by such a telecommunication line 2 or an Internet line network. Have been.
[0022]
A first management program 6 is installed in the first management computer 3. On the second management computer 4, a second management program 7 is installed. The third management computer 5 has a third management program 8 installed therein.
[0023]
The first management computer 3 is a computer that manages the manufacture of the medicine of the medicine maker 9. The second management computer 4 includes a plurality of medicine wholesalers 10 that temporarily stock various kinds of medicines purchased from the medicine maker 9 and deliver the medicines to the customer._{1 ~ n}This is a computer that collectively manages medicine inventory orders. The third management computer 5 stores a chemical wholesaler 10._{1 ~ n}One or more drug distribution terminal facilities 11 for temporarily consuming or selling medicines purchased from_{1 ~ m}This is a computer that collectively manages medicine inventory orders. Pharmaceutical distribution terminal facilities 11_{1 ~ m}Hospitals and pharmacies are examples.
[0024]
The third management program 8 is a program that causes the third management computer 5 to execute the following functions.
・ Chemical distribution terminal facility 11_{1 ~ m}The past chemical consumption information is totaled, and the chemical distribution terminal facility 11 is calculated based on the totaled result._{1 ~ m}Function to calculate the future consumption forecast of each chemical in each.
A function of transmitting the calculated consumption prediction to the second management computer 4 (second management program 7).
-Each chemical terminal distribution facility 11 based on the consumption prediction_{1 ~ m}Function to perform inventory management and order management of each medicine in
[0025]
The second management program 7 is a program that causes the second management computer 4 to execute the following functions.
-Drug distribution terminal facility 11 received from the third management program 8_{1 ~ m}Function to sum the consumption forecast of each chemical in each.
・ Drug distribution terminal facility 11 based on aggregation of consumption prediction_{1 ~ m}After estimating the future stock change of each medicine in each case, the medicine wholesaler 10 is estimated based on the estimated stock change of each medicine and the estimated consumption._{1 ~ n}Function to calculate the shipping forecast of each chemical in each.
A function of transmitting the calculated shipping forecast to the first management computer 3 (first management program 6).
・ Each chemical wholesaler 10 based on shipping forecast_{1 ~ n}Function to perform inventory management and order management of each medicine in
・ Chemical distribution terminal facility 11_{1 ~ m}Is a function to classify the facilities into groups of facilities for each region, and to further calculate shipping forecasts for each group of facilities.
[0026]
The first management program 6 is a program that causes the first management computer 3 to execute the following functions.
-Wholesale drug 10 received from the second management computer 4 (second management program 7)_{1 ~ n}Function to aggregate shipping forecasts for each chemical.
・ Wholesale of chemicals based on aggregated shipment forecasts 10_{1 ~ n}Function to estimate future stock change of each medicine in each.
-A function to formulate a production plan for each chemical based on the estimated inventory change of each chemical and the estimated result of shipment.
[0027]
Next, the medicine distribution management operation by the medicine distribution management system 1 will be described based on the flowcharts shown in FIGS. 2 to 5 and the database structure shown in FIGS. In the following description, the drug distribution terminal facility 11_{1 ~ m}Is assumed to be a hospital.
[0028]
The first management computer 3 sets and records a first database 17 as shown in FIG. The second management computer 4 sets and records a second database 18 as shown in FIG. The third management computer 5 sets and records a third database 19 as shown in FIG.
[0029]
The first to third databases 17 to 19 include a pharmaceutical database 20, a wholesale database 21, and a hospital database 22. In the pharmaceutical database 20, a drug name, a drug ID, and a distribution unit are set and recorded for each drug. The wholesale database 21 contains the chemical wholesaler 10_{1 ~ n}Each time, a wholesale ID and its location information on the map are set and recorded. The hospital database 22 includes a hospital (drug distribution terminal facility) 11_{1 ~ m}Each time the hospital ID and the location information on the map are set and recorded. In the pharmaceutical database 20, the wholesale database 21, and the hospital database 22, data is commonly recorded in the first to third management computers 3 to 5, respectively.
[0030]
The first to third management computers 3 to 5 further include the following databases. The second database 18 sets and records a wholesale stock database 23, a wholesale receipt / delivery database 24, a wholesale safety stock quantity database 25, and a wholesale order database 26.
[0031]
The wholesale stock database 23 stores the chemical wholesaler 10_{1 ~ n}The following data is set and recorded every time.
・ 10 chemical wholesalers whose inventory is to be monitored_{1 ~ n}Wholesale ID
・ Drug ID of stock monitored drug
-The number of inventories of stock monitored drugs.
-The lot number of the stock monitoring target drug in stock.
[0032]
The wholesale import / export database 24 contains the chemical wholesaler 10_{1 ~ n}The following data is set and recorded every time.
・ 10 chemical wholesalers to be monitored for entry / exit_{1 ~ n}Wholesale ID.
The medicine ID of the medicine to be monitored for entry and exit.
-Stock confirmation date.
-The number of stocks, the number of stocks, and the number of shipments on the stock confirmation date (n day) of the medicines to be monitored in and out of stock.
The number of stocks, the number of stocks, and the number of shipments for each day up to x days before the stock confirmation date of the medicine to be monitored.
-The predicted stock quantity, the expected storage quantity, and the predicted shipment quantity for each day up to y days before the inventory check date of the medicine for which entry / exit is monitored.
[0033]
It should be noted that the wholesale in / out database 24 stores the medicine wholesale 10_{1 ~ n}Each time, it is set corresponding to each medicine. The number of past data and future predicted data held in the wholesale inventory database 23 is set by the memory capacity of the wholesale inventory database 23.
[0034]
The wholesale safety stock quantity database 25 stores the chemical wholesaler 10._{1 ~ n}The following data is set and recorded every time.
・ 10 chemical wholesalers to be monitored for safety stock_{1 ~ n}Wholesale ID.
The medicine ID of the medicine whose safety stock quantity is to be monitored.
-Safety stock quantity The safety stock quantity of the monitored drug.
-The replenishment point of the drug subject to monitoring the number of safety stock.
-Estimated number of days of consumption of the stock-monitoring target drug.
[0035]
The safety stock of chemicals is the number of stocks that are expected to be sufficient to fulfill orders for a while in the future, and when ordering, add the order quantity to the current stock quantity. The quantity that satisfies the safety stock quantity is the order quantity. Specifically, the order quantity is obtained by subtracting the current stock quantity from the safety stock quantity. The replenishment point is a lower limit of inventory that is expected to be ordered promptly if the number of inventories decreases further, because there is a possibility that a recent order cannot be covered. The estimated number of days of consumption is day data indicating how many days to reach the replenishment point with the current number of stocks, as estimated from past orders.
[0036]
The wholesale order database 26 stores the following data on the order of the medicine to the medicine manufacturer 9 for each medicine wholesaler 10._{1 ~ n}It is set and recorded every time.
-An order ID individually assigned to each order data.
・ 10 chemical wholesalers to be monitored_{1 ~ n}Wholesale ID.
The medicine ID of the medicine to be monitored.
-Order (or planned order) date.
·scheduled delivery date.
・ Number of orders (or planned orders).
-The latest lot number of the medicine ordered (or scheduled to be ordered).
[0037]
The hospital inventory database 27 sets and records the following data for each hospital medical bureau as a stock destination.
The hospital medical office ID of the hospital medical office whose inventory is to be monitored.
The medicine ID of the medicine to be monitored.
-The number of inventories of drugs to be monitored.
-The lot number of the stock monitoring target drug in stock.
[0038]
The hospital entrance / exit database 28 sets and records the following data for each hospital medical office.
A hospital medical office ID of a hospital medical office to be monitored for entry / exit.
The medicine ID of the medicine to be monitored for entry and exit.
-Stock confirmation date.
-The number of stocks, the number of stocks, and the number of shipments on the stock confirmation date (n day) of the medicines to be monitored in and out of stock.
The number of stocks, the number of stocks, and the number of shipments for each day up to x days before the stock confirmation date of the medicine to be monitored.
-The predicted stock quantity, the scheduled storage quantity, and the predicted consumption quantity for each day up to y days before the stock confirmation date of the medicine to be monitored.
[0039]
The hospital entry / exit database 28 is set for each medicine at each hospital medical office. The number of past data and predicted future data held in the hospital entrance / exit database 28 is set based on the memory capacity of the hospital entrance / exit database 28.
[0040]
The hospital safety stock quantity database 29 sets and records the following data for each hospital medical office.
A hospital medical office ID of the hospital medical office to be monitored for the safety stock quantity.
The medicine ID of the medicine to be monitored for the safety stock quantity.
-The number of safety stocks of the drugs to be monitored.
-Replenishment points for chemicals to be monitored for safety stock.
-A consumption prediction flag.
-Estimated number of days of consumption of chemicals to be monitored.
[0041]
The safety stock number of a medicine is the stock number that is supposed to be enough to cover the consumption of the medicine for a while in the future. The replenishment point is the lower limit of inventory that is expected to be ordered promptly if the number of inventories decreases further, because it may not be possible to cover the consumption of chemicals in the near future. The estimated consumption days are days data indicating how many days to reach the replenishment point with the current stock number estimated from past consumption. These data are basically 10_{1 ~ n}This is the same concept as each data in.
[0042]
The wholesale order database 30 sets and records the following data for each hospital medical office.
-An order ID individually assigned to each order data.
The hospital medical office ID of the hospital medical office to be monitored for ordering.
-The medicine ID of the medicine to be monitored.
・ Wholesale of chemicals to be ordered (or to be ordered) 10_{1 ~ n}Wholesale ID.
-Order (or planned order) date.
·scheduled delivery date.
・ Number of orders (or planned orders).
-The latest lot number of the medicine ordered (or scheduled to be ordered).
[0043]
Next, the third management computer 5 uses the hospital (drug distribution terminal facility 11)._{1 ~ m}2) will be described with reference to the flowchart of FIG. Here, an arbitrary medicine is set as a monitoring target medicine, and the monitoring target medicine is changed to an arbitrary medicine wholesaler 10 in the morning of the day._{1 ~ n}The operation of the third management computer 5 will be described on the assumption that the medicines to be monitored have been consumed in the respective medical offices during the day of the day after the delivery (reception) to the hospital. In the following description, data input to the third management computer 5 may be performed by an operator via an input device (keyboard or the like) of the third management computer 5 or may be input to other data. Data generated by the management system may be transferred to the third management computer 5.
[0044]
When the data indicating that the medicine is stored is input to the third management computer 5, the third management computer 5 performs a storage process of the delivered monitoring target medicine (S201). More specifically, the third management computer 5 performs a process of writing the number of received medicines to be monitored in the hospital entry / exit database 28. The entry / exit data is implemented for each hospital medical office. Next, the third management computer 5 performs an inventory update process of the delivered monitoring target medicine (S202). Specifically, the third management computer 5 performs a process of updating the stock quantity data of the monitored drug at each hospital medical office, which is recorded in the hospital inventory database 27 and the hospital entry / exit database 28, respectively.
[0045]
Next, when data indicating drug consumption at each medical office is input to the third management computer 5, the third management computer 5 performs consumption processing of the consumed monitoring target medicine (S203). Specifically, the third management computer 5 performs a process of writing the consumption number of the monitored drug in the hospital entry / exit database 28. The entry of the number of consumption is performed for each hospital medical office.
[0046]
Next, the third management computer 5 performs an inventory update process for the consumed medicine (S204). Specifically, the third management computer 5 updates the latest inventory data by subtracting the consumption number from the inventory data recorded in the hospital inventory database 27 and the hospital entry / exit database 28, respectively. Perform processing. The inventory update processing is performed for each hospital medical office.
[0047]
Next, the third management computer 5 performs a process of detecting the number of scheduled storages (S205). Specifically, the third management computer 5 first determines whether new scheduled delivery date data of the monitored drug is entered in the hospital order database 30. Then, when it is confirmed that the expected delivery date data is newly entered, based on the expected delivery date data, the expected storage quantity data and the predicted inventory quantity of the hospital entrance / exit database 28 on the expected delivery date. A process for rewriting data is performed. The above processing is also performed for each hospital medical office.
[0048]
Next, the hospital inventory order prediction processing by the third management computer 5 will be described with reference to the flowchart of FIG. The inventory order prediction process is performed for each hospital medical bureau, which is a stock destination of medicines in a hospital. The inventory order prediction process is performed, for example, at night, when the daytime inventory order management process is completed.
[0049]
First, the third management computer 5 reads out the past consumption data from the hospital entrance / exit database 28 and analyzes the consumption data, thereby calculating the future consumption prediction of the monitored drug at the hospital medical office.
[0050]
Specifically, first, the prediction model in the hospital medical office is determined by reading and analyzing the past consumption data in the hospital medical office to be predicted. For example, the following model can be considered as the prediction model.
・ Constant fluctuation model (consumption value does not greatly deviate from the constant average value).
A trend model (a model in which the consumption value always falls or rises over a long period with a slight deviation).
・ Seasonal model (a model in which consumption values periodically repeat the highest value or the lowest value that is far from the constant average value).
-Seasonal trend model (model in which the average consumption of the seasonal model continuously increases or decreases).
[0051]
The third management computer 5 analyzes the past consumption data to determine an optimal prediction model from these prediction models when predicting the consumption of the monitored drug in the hospital physician office. Then, a statistical coefficient is calculated based on the determined prediction model. By using a statistical method such as an exponential smoothing method based on the determined prediction model, the calculated various statisticians, and the latest consumption data, a future consumption prediction of the monitored drug in the hospital medical office is estimated (S301). FIG. 9 shows an example of the estimated future consumption of the monitoring target medicine.
[0052]
When the estimation of the consumption forecast is completed, the third management computer 5 writes the estimated consumption forecast in the hospital entrance / exit database 28 of the monitored hospital medical office (S302). Further, based on the estimated consumption estimation value, it is determined when the monitored medicine at the monitored medical station reaches the replenishment point, and based on the determination result, the planned order date and the planned number of orders are calculated. Further, based on the calculated estimated order date and the estimated order quantity, the estimated storage date, the estimated storage quantity, and the predicted inventory quantity are calculated (S303). FIG. 10 shows an example of the calculated future transition amount of the monitored drug.
[0053]
Then, the calculated planned ordering date, planned ordering number, planned warehousing date, planned warehousing number, and predicted stock quantity are written in the hospital entrance / exit database 28 and the hospital ordering database 30, respectively (S304). FIG. 10 shows the forecast of the future inventory change of the medicine to be managed in each hospital or hospital medical bureau in the state where the order is scheduled.
[0054]
After performing the above processing, the order processing is performed. Specifically, the third management computer 5 searches whether or not the planned order date in the hospital order database 30 indicates today, and confirms that today is the planned order date. The order data of the monitored drug is transmitted to the management computer 4 (S305). Further, at this time, the third management computer 5 stores the respective chemical wholesalers 10_{1 ~ n}The data of the planned order date and the data of the planned order quantity of each medicine are transmitted to the second management computer 4 in each case.
[0055]
Next, the chemical wholesaler 10 by the second management computer 4_{1 ~ n}Will be described with reference to the flowchart of FIG. Here, an arbitrary drug is set as a monitoring target drug, and the monitoring target drug is supplied from a drug manufacturer 9 to a drug wholesaler 10 in the morning of the day._{1 ~ n}The operation of the second management computer 4 will be described on the assumption that the delivery of the monitored drug to each hospital is performed during the day of the day after the delivery (reception). In the following description, data input to the second management computer 4 may be performed by an operator via an input device (keyboard or the like) of the second management computer 4 or may be other data. Data generated by the management system may be transferred to the second management computer 4.
[0056]
When data indicating that a medicine is stored is input to the second management computer 4, the second management computer 4 performs a storage process of the delivered monitoring target medicine (S401). More specifically, the second management computer 4 performs a process of writing the number of warehoused medicines to be monitored in the wholesaler warehouse database 24. Next, the second management computer 4 performs inventory update processing of the delivered monitoring target medicine (S402). Specifically, the second management computer 4 performs a process of updating the stock quantity data recorded in the wholesale stock database 23 and the wholesale receipt / delivery database 24, respectively.
[0057]
Next, when data indicating that the medicine has been shipped to each hospital is input to the second management computer 4, the second management computer 4 performs shipping processing of the shipped monitoring target medicine (S403). ). Specifically, the second management computer 4 performs a process of writing the number of shipments of the monitored drug in the wholesale / delivery database 24. Next, the second management computer 4 performs inventory update processing of the shipped medicine (S404). Specifically, the second management computer 4 updates the stock data by subtracting the number of shipments from the stock data recorded in the wholesale stock database 23 and the wholesale receipt / delivery database 24, respectively. Perform processing.
[0058]
Next, the second management computer 4 performs a process of detecting the expected number of storages (S405). Specifically, the second management computer 4 first determines whether or not new ordering date data of the monitored drug is entered in the wholesale order database 26. Then, when it is confirmed that the planned order date data has been newly entered, based on the planned order date data and the planned order quantity data, the storage schedule of the wholesale / delivery database 24 on the planned order date is determined. A process of rewriting the number data and the predicted stock number data is performed.
[0059]
Next, the chemical wholesaler 10 by the second management computer 4_{1 ~ n}Will be described with reference to the flowchart of FIG. The inventory order prediction process is performed, for example, at night, when the daytime inventory order management process is completed.
[0060]
First, the second management computer 4 receives the drug wholesaler 10 received from the third management computer 5._{1 ~ n}The data on the planned ordering date and the data on the number of planned orders for each drug to be managed are tabulated, and based on the result of the tabulation, the drug wholesaler 10 to be managed is collected._{1 ~ n}Estimate future shipment forecast at. (S501).
[0061]
When the estimation of the estimated shipping value is completed, the second management computer 4 compares the estimated estimated shipping value with the monitored drug wholesaler 10._{1 ~ n}Is written into the wholesale / in-out database 24 (S502). Further, based on the estimated shipping forecast value, the monitored drug wholesaler 10_{1 ~ n}Is determined at which point the monitored drug reaches the replenishment point, and the expected order date and the expected number of orders for the drug maker 9 are calculated based on the determination result. Further, based on the calculated estimated order date and the estimated order quantity, the estimated storage date, the estimated storage quantity, and the predicted inventory quantity are calculated (S503).
[0062]
Then, the calculated planned ordering date, planned ordering number, planned warehousing date, planned warehousing number, and predicted stock quantity are written in the wholesale / inbound / outgoing database 24 and the wholesale order database 26, respectively (S504). Chemical wholesaler 10 in the state where an order is scheduled in this way_{1 ~ n}FIG. 11 shows the forecast of the future change of the inventory of the drug to be managed.
[0063]
After performing the above processing, the order processing is performed. Specifically, the second management computer 4 searches whether or not the planned order date in the wholesale order database 26 indicates today, and confirms that today is the planned order date. The order data of the monitored drug is transmitted to the management computer 3 (S505). Further, at this time, the second management computer 4 transmits the planned order date data and the planned order quantity data to the first management computer 3.
[0064]
The first management computer 3 performs a process of sending out the medicine ordered from the second management computer 4. Further, the first management computer 3 stores each medicine wholesaler 10 received from the second management computer 4._{1 ~ n}For each drug, the estimated order date data and order quantity data for each drug are tabulated for each drug, and a future shipment forecast for the drug to be managed is estimated based on the tabulated result. Then, a future production plan is drafted based on the estimated shipping forecast. FIG. 12 shows an example of the production prediction of the medicine to be managed. In FIG. 12, the solid line is the production plan before correction, and the dotted line is the production plan after correction. In the production plan before the modification, there is a possibility that the production order cannot be processed unless production exceeding the maximum production amount is performed after x days. Therefore, it is possible to process the order quantity without exceeding the maximum production quantity by leveling the production in advance of the production.
[0065]
Also, drug wholesalers 10 stored in the wholesale database 21 are stored._{1 ~ n}Distribution facility 11 stored in the hospital database 22 and the location information of the hospital_{1 ~ m}Medicine wholesale 10 based on the location information of_{1 ~ n}And chemical distribution terminal facilities 11_{1 ~ m}May be grouped for each region, and the consumption amount and order amount of the management target medicine may be totaled for each region. Then, it becomes possible to manage the consumption amount and the order amount for each region of the medicine to be managed. This is convenient for grasping a disease selectively occurring in an arbitrary region and grasping a consumption amount of a drug necessary for the disease.
[0066]
In the above-described embodiment, the first management program 6, the second management program 7, and the third management program 8 are installed on separate computers 3, 4, and 5. However, these programs 6, 7 , 8 may be installed on one computer.
[0067]
【The invention's effect】
As described above, according to the present invention, it is possible for a drug manufacturer to formulate a highly accurate manufacturing plan based on accurate distribution information.
[Brief description of the drawings]
FIG. 1 is a diagram showing a configuration of a medicine distribution management system according to an embodiment of the present invention.
FIG. 2 is a flowchart showing a first operation of a third management computer in the medicine distribution management system according to the embodiment.
FIG. 3 is a flowchart showing a second operation of a third management computer in the medicine distribution management system according to the embodiment.
FIG. 4 is a flowchart showing a first operation of a second management computer in the medicine distribution management system according to the embodiment.
FIG. 5 is a flowchart showing a second operation of the second management computer in the medicine distribution management system according to the embodiment.
FIG. 6 is a diagram showing a configuration of a first database managed by a first management computer.
FIG. 7 is a diagram showing a configuration of a second database managed by a second management computer.
FIG. 8 is a diagram showing a configuration of a third database managed by a third management computer.
FIG. 9 is a diagram illustrating an example of consumption prediction at a drug distribution terminal facility.
FIG. 10 is a diagram showing an example of a change in inventory at a drug distribution terminal facility.
FIG. 11 is a diagram showing an example of the stock quantity of a chemical wholesaler.
FIG. 12 is a diagram showing an example of a production plan of a drug manufacturer.
[Explanation of symbols]
1 medicine distribution management system
2 Telecommunication lines
3 First management computer
4 Second management computer
5. Third management computer
6 first management program
7 Second management program
8 Third Management Program
9 Chemical manufacturers
10_{1 ~ n}Chemical wholesale
11_{1 ~ m}Pharmaceutical distribution terminal facilities
17 First database
18 Second database
19 Third database
20 Pharmaceutical Database
21 Wholesale Database
22 Hospital Database
23 Wholesale Inventory Database
24 Wholesale / inbound / outbound database
25 Wholesale Safety Stock Quantity Database
26 Wholesale order database
27 Hospital Inventory Database
28 Hospital Access Database
29 Hospital Safety Stock Database
30 Hospital Order Database

Claims (12)

A first management computer for managing drug production of a drug manufacturer;
A second management computer that manages the medicine inventory of one or more medicine wholesalers that once stocks various kinds of medicines purchased from the medicine maker and delivers them to an order destination;
A third management computer that manages a drug inventory of one or more drug distribution terminal facilities that once consumes or sells the drug purchased from the drug wholesaler,
Communicatively connected via a telecommunication line,
The third management computer includes:
A function of calculating the future consumption of each drug in each of the drug distribution terminal facilities based on the tabulated results of the past drug consumption information of each of the drug distribution terminal facilities,
Transmitting the calculated consumption forecast to the second management computer;
To do,
The second management computer includes:
Based on the sum of the consumption forecasts of each medicine in each of the medicine distribution terminal facilities received from the third management computer, a future shipment forecast of each medicine to each of the medicine distribution terminal facilities is calculated for each of the medicine wholesalers. Features and
Transmitting the calculated shipping forecast to the first management computer;
The first management computer executes a function of drafting a manufacturing plan for each drug based on the total of the shipping forecast of each drug for each drug wholesale received from the second management computer. To do,
A drug distribution management system, characterized in that: In the medicine distribution management system according to claim 1,
The second management computer estimates the future stock change of each medicine in each of the medicine distribution terminal facilities based on the consumption forecast, and then, based on the estimated stock change of each medicine and the consumption forecast, Calculate the shipping forecast of each drug in each drug wholesaler,
A drug distribution management system, characterized in that: In the medicine distribution management system according to claim 1 or 2,
The first management computer estimates a future stock change of each medicine in each of the medicine wholesalers based on the shipment forecast, and then, based on the estimated stock change of each medicine and the shipment forecast, determines a stock of each medicine. To make a production plan,
A drug distribution management system, characterized in that: In the medicine distribution management system according to any one of claims 1 to 3,
The third management computer performs inventory management and order management of each medicine in each medicine distribution terminal facility based on the consumption prediction.
A drug distribution management system, characterized in that: In the medicine distribution management system according to any one of claims 1 to 4,
The second management computer performs inventory management and order management of each medicine in each medicine wholesaler based on the shipment prediction.
A drug distribution management system, characterized in that: In the medicine distribution management system according to any one of claims 1 to 5,
The second management computer, after dividing the drug distribution terminal facilities into facility groups for each region, further calculates the shipping forecast for each of the divided facility groups.
A drug distribution management system, characterized in that: A first management program for managing drug production of a drug manufacturer;
A second management program that manages the inventory of one or more drug wholesalers that once stocks the various drugs purchased from the drug manufacturer and then delivers them to the ordering party;
A third management program that manages the drug inventory of one or more drug distribution terminal facilities that consume or sell the drug once stocked from the drug wholesaler,
With
These programs are programs that are installed on computers that are communicably connected to each other via a telecommunication line,
The third management program includes:
A function of calculating the future consumption of each drug in each of the drug distribution terminal facilities based on the tabulated results of the past drug consumption information of each of the drug distribution terminal facilities,
Transmitting the calculated consumption forecast to the second management program;
A program executed by the computer on which the third management program is installed,
The second management program includes:
Based on the aggregation of the consumption forecasts of each drug in each of the medicine distribution terminal facilities received from the third management program, a future shipment forecast of each medicine to each of the medicine distribution terminal facilities is calculated for each of the medicine wholesalers. Features and
Transmitting the calculated shipping forecast to the first management program,
A program to be executed by the computer on which the second management program is installed,
The first management program has a function of drafting a production plan for each medicine based on the total of the shipment predictions of each medicine for each medicine wholesale received from the second management program, according to the first management program. A program to be executed by the computer on which the program is installed,
A drug distribution management program characterized by the following. In the medicine distribution management program according to claim 7,
The second management program estimates a future inventory change of each medicine in each of the medicine distribution terminal facilities based on the consumption forecast, and then, based on the estimated stock change of each medicine and the consumption forecast, A function to calculate the shipping forecast for each drug in each drug wholesaler,
A program to be executed by the computer on which the second management program is installed,
A drug distribution management program characterized by the following. In the medicine distribution management program according to claim 7 or 8,
The first management program estimates a future stock change of each medicine in each of the medicine wholesalers based on the shipment forecast, and then, based on the estimated stock change of each medicine and the shipment prediction, A program for causing the computer on which the first management program is installed to execute a function of drafting a manufacturing plan;
A drug distribution management program characterized by the following. In the medicine distribution management program according to any one of claims 7 to 9,
The third management program causes the computer on which the third management program is installed to execute a function of performing inventory management and order management of each drug in each drug distribution terminal facility based on the consumption prediction. Is a program,
A drug distribution management program characterized by the following. In the medicine distribution management program according to any one of claims 7 to 10,
The second management program is a program that causes the second management program to execute a function of performing inventory management and order management of each medicine in each medicine wholesaler based on the shipment prediction.
A drug distribution management program characterized by the following. In the medicine distribution management program according to any one of claims 7 to 11,
The second management program is provided with a function of classifying the drug distribution terminal facilities into facility groups for each region and further calculating the shipping forecast for each of the divided facility groups. A program to be executed by the computer,
A drug distribution management program characterized by the following.

Images