An intelligent drug sales data management system

Through an intelligent drug sales data management system, combining warehousing and sales data to calculate sales coefficients, analyze and correct the sales period of drugs, the problem that the existing system cannot effectively manage drug sales, and achieve accurate prediction and resources of drug sales status Optimized management.

CN117273615BActive Publication Date: 2024-11-05GUANGZHOU GUANGKANG PHARM CO LTD
View PDF 6 Cites 0 Cited by

Patent Information

Application Number
CN202311341467.8
Authority / Receiving Office
CN · China
Patent Type
Patents(China)
Current Assignee / Owner
Filing Date
2023-10-17
Publication Date
2024-11-05
Estimated Expiration
2043-10-17

AI Technical Summary

Technical Problem

The existing drug sales management system cannot effectively combine drug storage information and sales information to analyze the drug sales status, resulting in the inability to conduct comprehensive management and early management, which can easily lead to waste of drug resources.

Method used

An intelligent drug sales data management system was designed, including theoretical term module, data collection module, coefficient generation module, analysis module, term prediction module and reporting module. By obtaining warehousing data and sales data, the sales coefficient is calculated and the sales are analyzed. The status and the estimated sales period will be corrected based on the analysis results and provided to users.

Benefits of technology

The system can effectively analyze the sales status of drugs and predict the sales period of drugs, help users to effectively manage and reduce waste of drug resources.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN117273615B_ABST
    Figure CN117273615B_ABST
Patent Text Reader

Abstract

The present invention discloses an intelligent drug sales data management system, which relates to the technical field of drug sales management. A data acquisition module is used to regularly obtain storage data and sales data related to the drug in the market. A coefficient generation module generates a sales coefficient for the drug after comprehensively calculating the storage data and sales data. After the analysis module obtains the sales coefficient, the sales coefficient is compared with a gradient threshold, and the sales status of the drug is analyzed according to the comparison result. Then, it is judged whether it is necessary to re-forecast the expected sales period according to the comparison result. When the period prediction module judges that it is necessary to re-forecast the expected sales period, the expected sales period is corrected by the sales coefficient to obtain the predicted sales period. The management system can effectively analyze the sales status of the drug and predict the sales period of the drug. After feeding back the sales status of the drug and the predicted sales period to the user, it is convenient for the user to manage the drug.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The present invention relates to the technical field of drug sales management, and in particular to an intelligent drug sales data management system. Background Art

[0002] The pharmaceutical sales business is highly complex worldwide. Different types of drugs require strict supervision, tracking and management to ensure safety and quality. In addition, drug prices, inventory, sales channels and market demand are constantly changing, requiring highly flexible management. An intelligent pharmaceutical sales data management system is a system that uses advanced information technology and data analysis technology to manage and optimize the pharmaceutical sales business. This system is often widely adopted by pharmaceutical manufacturers, wholesalers, retailers and medical institutions to improve business efficiency, reduce human errors, improve inventory management, enhance compliance and improve customer service.

[0003] The prior art has the following deficiencies:

[0004] Existing management systems usually manage the sales volume and storage volume of drugs. That is, when the storage volume of drugs is too low, the management system alerts the user and prompts the user to replenish the stock. However, the management system does not combine the storage information and sales information of the drugs to analyze the sales status of the drugs, and does not predict the sales period of the drugs in real time, making it impossible for users to effectively manage the drugs in an integrated manner and in advance, which easily leads to a waste of drug resources. Summary of the invention

[0005] The purpose of the present invention is to provide an intelligent drug sales data management system to solve the shortcomings of the background technology.

[0006] In order to achieve the above-mentioned object, the present invention provides the following technical solutions: an intelligent drug sales data management system, comprising a theoretical deadline module, a data acquisition module, a coefficient generation module, an analysis module, a deadline prediction module and a report module;

[0007] Theoretical period module: used for users to input the expected sales period of drugs;

[0008] Data collection module: After the drug is sold, it regularly obtains storage data and sales data related to the drug in the market, and pre-processes the storage data and sales data;

[0009] Coefficient generation module: generates sales coefficients for drugs after comprehensively calculating storage data and sales data;

[0010] Analysis module: After obtaining the sales coefficient, the sales coefficient is compared with the gradient threshold, and the sales status of the drug is analyzed based on the comparison results. Then, it is determined whether it is necessary to re-forecast the expected sales period based on the comparison results;

[0011] Deadline forecast module: when it is determined that the estimated sales period needs to be re-forecasted, the estimated sales period is corrected by the sales coefficient to obtain the predicted sales period;

[0012] Report module: displays the sales status and predicted sales period of drugs to users.

[0013] Preferably, the coefficient generation module comprehensively calculates storage data and sales data, the storage data includes the growth rate of drug storage volume, and the sales data includes the sales rate and the substitution index of similar drugs.

[0014] Preferably, the coefficient generation module comprehensively calculates the growth rate of drug storage volume, the sales rate and the substitution index of similar drugs to obtain the sales coefficient, and the calculation expression is:

[0015]

[0016] In the formula, xs z is the sales coefficient, GRO is the growth rate of drug storage volume, YT is the substitution index of similar drugs, SR is the sales rate, α, β, γ are the proportional coefficients of the growth rate of drug storage volume, the substitution index of similar drugs, and the sales rate, respectively, and α, β, γ are all greater than 0.

[0017] Preferably, after obtaining the sales coefficient, the analysis module compares the sales coefficient with a gradient threshold, where the gradient threshold includes a first gradient threshold TD1 and a second gradient threshold TD2, and the first gradient threshold is smaller than the second gradient threshold.

[0018] Preferably, when the first gradient threshold TD1 ≤ sales coefficient xs z When the value is ≤ the second gradient threshold, the analysis module analyzes that the sales status of the drug is stable and there is no need to revise the estimated sales period;

[0019] When the sales coefficient xs z When the value is less than the first gradient threshold TD1, the analysis module analyzes that the sales status of the drug is good and the estimated sales period needs to be revised;

[0020] When the sales coefficient xs z When the value is greater than the second gradient threshold TD2, the analysis module analyzes that the sales status of the drug is poor and the expected sales period needs to be revised.

[0021] Preferably, when it is determined that the expected sales period needs to be re-forecasted, the period forecasting module corrects the expected sales period by the sales coefficient to obtain the predicted sales period, and the calculation expression is:

[0022]

[0023] In the formula, qx sTo predict the sales period, qx y For the estimated sales period, xs z is the sales coefficient, TD1 is the first gradient threshold, and TD2 is the second gradient threshold.

[0024] Preferably, the calculation expression for the growth rate of the drug storage volume is:

[0025]

[0026] In the formula, GRO is the growth rate of drug storage volume, dc is the current storage volume, and qc is the storage volume in the previous period.

[0027] Preferably, the sales rate is calculated as follows:

[0028]

[0029] Where SR is the sales rate, dx is the current sales volume, qx is the sales volume of the previous period, and Ts is the time interval between the current time and the previous time.

[0030] Preferably, the calculation expression of the similar drug substitution index is:

[0031]

[0032] In the formula, YT is the substitution index of similar drugs, Z(t) is the change in drug market share, [t x , t y ] is the period of warning for the increase in the amount of similar substitute drugs, [t i , t j ] is the period when the demand for medicines increases.

[0033] Preferably, the logic for obtaining the time period for the warning of the increase in the amount of similar substitute drugs is: the time period when the increase in the amount of similar substitute drugs exceeds the increase threshold is the time period for the warning of the increase in the amount of similar substitute drugs;

[0034] The logic for obtaining the time period when the demand for medicine increases is: the time period when the demand for medicine exceeds the demand threshold is the time period when the demand for medicine increases.

[0035] In the above technical solution, the technical effects and advantages provided by the present invention are:

[0036] The present invention regularly obtains storage data and sales data related to the drug in the market through a data acquisition module, and the coefficient generation module generates a sales coefficient for the drug after comprehensively calculating the storage data and sales data. After the analysis module obtains the sales coefficient, it compares the sales coefficient with the gradient threshold, analyzes the sales status of the drug according to the comparison result, and then judges whether it is necessary to re-forecast the expected sales period according to the comparison result. When the period prediction module judges that it is necessary to re-forecast the expected sales period, it corrects the expected sales period through the sales coefficient to obtain the predicted sales period. The management system can effectively analyze the sales status of the drug and predict the sales period of the drug. After feeding back the sales status of the drug and the predicted sales period to the user, it is convenient for the user to manage the drug. BRIEF DESCRIPTION OF THE DRAWINGS

[0037] In order to more clearly illustrate the embodiments of the present application or the technical solutions in the prior art, the drawings required for use in the embodiments will be briefly introduced below. Obviously, the drawings described below are only some embodiments recorded in the present invention. For ordinary technicians in this field, other drawings can also be obtained based on these drawings.

[0038] Figure 1 It is a system module diagram of the present invention. DETAILED DESCRIPTION

[0039] In order to make the purpose, technical solution and advantages of the embodiments of the present invention clearer, the technical solution in the embodiments of the present invention will be clearly and completely described below in conjunction with the drawings in the embodiments of the present invention. Obviously, the described embodiments are part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present invention.

[0040] Example 1: Please refer to Figure 1 As shown, the intelligent drug sales data management system described in this embodiment includes a theoretical term module, a data acquisition module, a coefficient generation module, an analysis module, a term prediction module and a report module;

[0041] Theoretical period module: used for users to input the expected sales period of drugs (the expected sales period can be in days or hours. In order to improve the prediction accuracy of the expected sales period, the expected sales period in this application is in hours). The expected sales period of drugs obtained by users can be estimated based on the historical sales data of the drugs. The expected sales period information is sent to the period prediction module, including the following steps:

[0042] Data Collection:

[0043] Collect historical sales data related to drugs, including sales date, sales quantity, sales location, sales price and other information, which are usually stored in the sales record database;

[0044] Data cleaning and preparation:

[0045] Clean the collected data, including processing missing values, outliers and duplicate data, to ensure the quality and integrity of the data;

[0046] Time Series Analysis:

[0047] Organize and sort sales data in time series to facilitate time series analysis.

[0048] Use time series analysis techniques, such as moving averages, exponential smoothing, or ARIMA models, to analyze trends and seasonality in historical sales data;

[0049] Forecast sales:

[0050] Based on the results of time series analysis, use appropriate forecasting models to estimate sales volume in the future, which can help determine the demand trend of drugs in the future;

[0051] Calculate the sales period:

[0052] Based on the forecasted sales and current inventory levels, calculate the theoretical shelf life of the drug, which can be estimated using the following formula:

[0053] Estimated sales period = current inventory quantity / forecast sales volume;

[0054] Adjustable factors to consider:

[0055] Correct the theoretical period by taking into account other adjustable factors, such as sales seasonality, market trends, supply chain availability, etc., which may have an impact on the actual sales period;

[0056] Provide user feedback:

[0057] Feedback the estimated sell-by date to the user so that the user can manage inventory, order drugs or develop sales strategies based on the information provided by the system;

[0058] Regular updates:

[0059] Regularly updating sales deadline estimates to reflect new sales data and market changes will help keep the estimates accurate.

[0060] Data collection module: After the drug is sold, the storage data and the sales data related to the drug in the market are regularly obtained, and the storage data and sales data are pre-processed and sent to the coefficient generation module, including the following steps:

[0061] Data source identification:

[0062] Determine from which data sources to obtain warehousing and sales data, which may include internal company databases, supply chain systems, sales records, third-party data providers, etc.;

[0063] Data extraction:

[0064] Extract warehouse data and sales data from the selected data source, which may require using database queries, API calls, file downloads, etc. to obtain data;

[0065] Data cleaning:

[0066] Clean the extracted data to ensure data quality and consistency. Cleaning steps may include:

[0067] Handling missing values: filling missing data or deleting missing data;

[0068] Handling outliers: Detecting and correcting anomalous data points;

[0069] Data format conversion: ensuring that data is stored in the appropriate format, such as date and time formatting;

[0070] Data Merge:

[0071] If you are acquiring data from multiple sources, you need to combine them into a unified data set for analysis, usually using a unique identifier to link the data together;

[0072] Data conversion:

[0073] Transform the data to suit the needs of subsequent analysis, which may include calculating derived variables, aggregating data, performing time series decomposition, etc.

[0074] Data Storage:

[0075] Store the cleansed and transformed data in an appropriate database or data warehouse for future use. The data should be stored in a secure manner to protect sensitive information.

[0076] Data quality monitoring:

[0077] Establish a data quality monitoring mechanism to regularly check the accuracy and completeness of data, and if any problems arise, correct them in a timely manner.

[0078] Coefficient generation module: after comprehensively calculating the storage data and sales data, the sales coefficient is generated for the drug. The sales coefficient is used to reflect the sales status of the drug and to adjust the expected sales period. The sales coefficient is sent to the period prediction module;

[0079] Analysis module: After obtaining the sales coefficient, the sales coefficient is compared with the gradient threshold, and the sales status of the drug is analyzed based on the comparison result. Then, it is determined whether it is necessary to re-forecast the expected sales period based on the comparison result. The sales status analysis result is sent to the report module, and the judgment result is sent to the period prediction module;

[0080] Period forecasting module: when it is determined that the expected sales period needs to be re-forecasted, the expected sales period is corrected by the sales coefficient to obtain the predicted sales period, and the predicted sales period information is sent to the reporting module;

[0081] Report module: Display the sales status and predicted sales period of drugs to users, so that users can formulate corresponding management strategies. For example, when the supply of drugs is insufficient, increase the purchase volume of drugs and appropriately increase the price of drugs; when the supply of drugs is excessive, reduce the purchase volume of drugs and appropriately reduce the price of drugs. Compare the predicted sales period of drugs with the shelf life of drugs and then deal with the drugs accordingly, including the following steps:

[0082] Data query:

[0083] The user selects the drug or sales data to be viewed and specifies the time range and other filter criteria;

[0084] Sales Status Report:

[0085] Generate sales status report based on user query, including the following information:

[0086] Current inventory and historical sales data, such as sales quantity and sales amount;

[0087] Forecast sales period sales trend charts and graphs so that users can intuitively understand sales;

[0088] Management suggestions:

[0089] Provide management suggestions based on sales status reports. For example, when the supply of drugs is insufficient to meet the demand, it is recommended to increase the purchase volume and appropriately increase the drug price to meet the demand; when the supply of drugs is excessive to meet the demand, it is recommended to reduce the purchase volume and appropriately reduce the drug price to reduce the inventory backlog;

[0090] Term Comparison Report:

[0091] Compare the predicted shelf life of drugs with the shelf life of drugs and generate corresponding reports, which helps users identify potential inventory expiration risks;

[0092] Inventory handling suggestions:

[0093] Providing inventory handling suggestions based on the deadline comparison report, for example, if the predicted sales deadline is shorter than the shelf life, recommending expediting sales or taking other measures, such as giving away or recalling drugs, to avoid waste;

[0094] User Interaction:

[0095] Allow users to interact with the information provided by the report, such as setting inventory targets, updating sales forecasts, adjusting drug prices, etc.

[0096] Export and share:

[0097] Allow users to export report data for further analysis or sharing with the team;

[0098] Regular updates:

[0099] Ensure reports and recommendations are regularly updated to reflect new sales data and market changes;

[0100] Visualization and user-friendliness:

[0101] Use data visualization tools and user-friendly interfaces to present reports so that users can easily understand and act on them;

[0102] Security and Compliance:

[0103] Ensure the security and compliance of user data, especially when handling sensitive medical data.

[0104] This application uses a data acquisition module to regularly obtain storage data and sales data related to the drug in the market. The coefficient generation module generates a sales coefficient for the drug after comprehensively calculating the storage data and sales data. After the analysis module obtains the sales coefficient, it compares the sales coefficient with the gradient threshold, analyzes the sales status of the drug based on the comparison result, and then determines whether it is necessary to re-forecast the expected sales period based on the comparison result. When the period prediction module determines that it is necessary to re-forecast the expected sales period, it corrects the expected sales period through the sales coefficient to obtain the predicted sales period. The management system can effectively analyze the sales status of drugs and predict the sales period of drugs. After feeding back the sales status of drugs and the predicted sales period to users, it is convenient for users to manage drugs.

[0105] Embodiment 2: The coefficient generation module generates a sales coefficient for a drug after comprehensively calculating the storage data and the sales data;

[0106] The coefficient generation module comprehensively calculates storage data and sales data. Storage data includes the growth rate of drug storage volume, and sales data includes sales rate and similar drug substitution index.

[0107] The calculation expression of the growth rate of drug storage volume is:

[0108]

[0109] In the formula, GRO is the growth rate of drug storage volume, dc is the current storage volume, which records the storage volume of the current period (for example, this month), and qc is the previous period storage volume, which records the storage volume of the previous period (for example, last month);

[0110] The greater the growth rate of drug storage volume, the greater the growth rate of drug storage volume.

[0111] Poor sales: A high inventory growth rate may indicate a slow sales rate and the drugs cannot be sold quickly. This may be due to insufficient market demand, high prices, fierce market competition or other factors.

[0112] Inventory backlog: A high growth rate may indicate inventory backlog, that is, a large amount of unsold drugs are stored in the warehouse, which may cause inventory management problems, increase inventory costs, and may also cause some drugs to exceed their shelf life.

[0113] The sales velocity is calculated as:

[0114]

[0115] Where SR is the sales rate, dx is the current sales volume, which records the sales volume of the current period (for example, this month), qx is the previous period sales volume, which records the sales volume of the previous period (for example, last month), and Ts is the time interval between the current time and the previous time;

[0116] Hot-selling products: A high sales rate usually indicates that the drug is a hot-selling product that is popular in the market and in high demand, which is a positive sign for pharmaceutical companies because hot-selling products help increase revenue and profits;

[0117] Fast inventory turnover: High sales rate means fast inventory turnover, and drugs will not be stored in the warehouse for too long, which helps to reduce inventory costs, reduce inventory losses, and reduce the risk of drugs exceeding their shelf life;

[0118] Expected Short Selling Life: Due to the high sales velocity, the selling life of the drug may be short. This is because the high sales velocity will lead to a rapid decline in inventory levels, thus shortening the time the drug stays in inventory.

[0119] More frequent inventory replenishment may be required: High sales rates may require more frequent inventory replenishment to meet market demand, which requires good supply chain management and inventory replenishment strategies.

[0120] The calculation expression of the substitution index of similar drugs is:

[0121]

[0122] In the formula, YT is the substitution index of similar drugs, Z(t) is the change in drug market share, [t x , t y ] is the period of warning for the increase in the amount of similar substitute drugs, [t i , t j ] is the period of time when the demand for medicines increases;

[0123] The logic for obtaining the time period for the warning of the increase in the amount of similar alternative drugs is:

[0124] When there are too many alternative drugs of the same type, the following effects will occur:

[0125] Price competition: A large number of alternative drugs of the same type usually leads to fierce price competition. Pharmaceutical companies may lower their prices to attract patients and insurance companies, which may lead to a decrease in the price of the original drug;

[0126] Reduced market share: A large number of similar substitute drugs may disperse the market share and reduce the market share of the original drug, which may have a negative impact on the sales and revenue of the original drug;

[0127] Increased patient choice: A large number of alternative medicines in the same category provides patients with more choices, which may increase patient power and make it easier for them to choose medicines that are less expensive or better suited to their needs;

[0128] Prompting innovation: A highly competitive market may prompt original drug manufacturers to accelerate the pace of innovation to develop better treatments or improved drugs to remain competitive.

[0129] Therefore, the period when the increase in the amount of similar alternative drugs exceeds the increase threshold is the period for warning of the increase in the amount of similar alternative drugs.

[0130] The acquisition logic for the period when the demand for drugs increases is:

[0131] When the disease corresponding to the drug spreads widely (such as during the flu period, which will greatly increase the demand for cold medicine and antipyretic drugs), the demand for the drug will increase. Therefore, the period when the demand for the drug exceeds the demand threshold is the period when the demand for the drug increases.

[0132] The coefficient generation module comprehensively calculates the growth rate of drug storage volume, sales rate and similar drug substitution index to obtain the sales coefficient. The calculation expression is:

[0133]

[0134] In the formula, xs zis the sales coefficient, GRO is the growth rate of drug storage volume, YT is the substitution index of similar drugs, SR is the sales rate, α, β, γ are the proportional coefficients of the growth rate of drug storage volume, the substitution index of similar drugs, and the sales rate, respectively, and α, β, γ are all greater than 0.

[0135] After the analysis module obtains the sales coefficient, it compares the sales coefficient with the gradient threshold, analyzes the sales status of the drug based on the comparison result, and then determines whether it is necessary to re-forecast the expected sales period based on the comparison result;

[0136] The gradient threshold includes a first gradient threshold TD1 and a second gradient threshold TD2, and the first gradient threshold is smaller than the second gradient threshold. z From the calculation formula, we can know that the sales coefficient xs z The smaller the value, the better the sales of the drug. z The larger the value, the worse the sales status of the drug. When the sales status is good or bad, the estimated sales period needs to be revised. Therefore, the following solutions are available:

[0137] When the first gradient threshold TD1 ≤ sales coefficient xs z When the value is ≤ the second gradient threshold, it indicates that the sales status of the drug is stable and there is no need to revise the estimated sales period;

[0138] When the sales coefficient xs z When the value is less than the first gradient threshold TD1, it indicates that the sales status of the drug is good and the estimated sales period needs to be revised;

[0139] When the sales coefficient xs z When the value is greater than the second gradient threshold TD2, it indicates that the sales status of the drug is poor and the expected sales period needs to be revised.

[0140] When it is determined that the expected sales period needs to be re-forecasted, the period forecasting module corrects the expected sales period by the sales coefficient to obtain the predicted sales period. The calculation expression is:

[0141]

[0142] In the formula, qx s To predict the sales period, qx y For the estimated sales period, xs z is the sales coefficient, TD1 is the first gradient threshold, and TD2 is the second gradient threshold.

[0143] The above formulas are all dimensionless and numerical calculations. The formula is a formula for the most recent real situation obtained by collecting a large amount of data and performing software simulation. The preset parameters in the formula are set by technicians in this field according to actual conditions.

[0144] The above embodiments can be implemented in whole or in part by software, hardware, firmware or any other combination. When implemented by software, the above embodiments can be implemented in whole or in part in the form of a computer program product. The computer program product includes one or more computer instructions or computer programs. When the computer instructions or computer programs are loaded or executed on a computer, the process or function described in the embodiment of the present application is generated in whole or in part. The computer can be a general-purpose computer, a special-purpose computer, a computer network, or other programmable device. The computer instructions can be stored in a computer-readable storage medium, or transmitted from one computer-readable storage medium to another computer-readable storage medium. For example, the computer instructions can be transmitted from one website site, computer, server or data center to another website site, computer, server or data center by wired or wireless (e.g., infrared, wireless, microwave, etc.). The computer-readable storage medium can be any available medium that a computer can access or a data storage device such as a server or data center that contains one or more available media sets. The available medium can be a magnetic medium (e.g., a floppy disk, a hard disk, a tape), an optical medium (e.g., a DVD), or a semiconductor medium. The semiconductor medium can be a solid-state hard disk.

[0145] It should be understood that the term "and / or" in this article is only a description of the association relationship of associated objects, indicating that there can be three relationships. For example, A and / or B can represent: A exists alone, A and B exist at the same time, and B exists alone. A and B can be singular or plural. In addition, the character " / " in this article generally indicates that the associated objects before and after are in an "or" relationship, but it may also indicate an "and / or" relationship. Please refer to the context for specific understanding.

[0146] In this application, "at least one" means one or more, and "plurality" means two or more. "At least one of the following" or similar expressions refers to any combination of these items, including any combination of single or plural items. For example, at least one of a, b, or c can be represented by: a, b, c, ab, ac, bc, or abc, where a, b, c can be single or multiple.

[0147] It should be understood that in the various embodiments of the present application, the size of the serial numbers of the above-mentioned processes does not mean the order of execution. The execution order of each process should be determined by its function and internal logic, and should not constitute any limitation on the implementation process of the embodiments of the present application.

[0148] Those of ordinary skill in the art will appreciate that the units and algorithm steps of each example described in conjunction with the embodiments disclosed herein can be implemented in electronic hardware, or a combination of computer software and electronic hardware. Whether these functions are performed in hardware or software depends on the specific application and design constraints of the technical solution. Professional and technical personnel can use different methods to implement the described functions for each specific application, but such implementation should not be considered to be beyond the scope of this application.

[0149] Those skilled in the art can clearly understand that, for the convenience and brevity of description, the specific working processes of the systems, devices and units described above can refer to the corresponding processes in the aforementioned method embodiments and will not be repeated here.

[0150] In the several embodiments provided in the present application, it should be understood that the disclosed systems, devices and methods can be implemented in other ways. For example, the device embodiments described above are only schematic. For example, the division of the units is only a logical function division. There may be other division methods in actual implementation, such as multiple units or components can be combined or integrated into another system, or some features can be ignored or not executed. Another point is that the mutual coupling or direct coupling or communication connection shown or discussed can be through some interfaces, indirect coupling or communication connection of devices or units, which can be electrical, mechanical or other forms.

[0151] The units described as separate components may or may not be physically separated, and the components shown as units may or may not be physical units, that is, they may be located in one place or distributed on multiple network units. Some or all of the units may be selected according to actual needs to achieve the purpose of the solution of this embodiment.

[0152] In addition, each functional unit in each embodiment of the present application may be integrated into one processing unit, or each unit may exist physically separately, or two or more units may be integrated into one unit.

[0153] If the functions are implemented in the form of software functional units and sold or used as independent products, they can be stored in a computer-readable storage medium. Based on this understanding, the technical solution of the present application can be essentially or partly embodied in the form of a software product that contributes to the prior art. The computer software product is stored in a storage medium, including several instructions for a computer device (which can be a personal computer, a server, or a network device, etc.) to perform all or part of the steps of the methods described in each embodiment of the present application. The aforementioned storage medium includes: various media that can store program codes, such as USB flash drives, mobile hard disks, read-only memories (ROM), random access memories (RAM), magnetic disks or optical disks.

[0154] The above is only a specific implementation of the present application, but the protection scope of the present application is not limited thereto. Any person skilled in the art who is familiar with the present technical field can easily think of changes or substitutions within the technical scope disclosed in the present application, which should be included in the protection scope of the present application. Therefore, the protection scope of the present application should be based on the protection scope of the claims.

Claims

1. An intelligent drug sales data management system, characterized by: It includes theoretical term module, data collection module, coefficient generation module, analysis module, term prediction module and report module; Theoretical period module: used for users to input the expected sales period of drugs; Data collection module: After the drug is sold, it regularly obtains storage data and sales data related to the drug in the market, and pre-processes the storage data and sales data; Coefficient generation module: generates sales coefficients for drugs after comprehensively calculating storage data and sales data; Analysis module: After obtaining the sales coefficient, the sales coefficient is compared with the gradient threshold, and the sales status of the drug is analyzed based on the comparison results. Then, it is determined whether it is necessary to re-forecast the expected sales period based on the comparison results; Deadline forecast module: when it is determined that the estimated sales period needs to be re-forecasted, the estimated sales period is corrected by the sales coefficient to obtain the predicted sales period; Report module: displays the sales status and predicted sales period of drugs to users; The coefficient generation module comprehensively calculates storage data and sales data, the storage data includes the growth rate of drug storage volume, and the sales data includes the sales rate and similar drug substitution index; The coefficient generation module comprehensively calculates the growth rate of drug storage volume, sales rate and similar drug substitution index to obtain the sales coefficient, and the calculation expression is: In the formula, xsz is the sales coefficient, GRO is the growth rate of drug storage volume, YT is the substitution index of similar drugs, SR is the sales rate, α, β, γ are the proportional coefficients of the growth rate of drug storage volume, the substitution index of similar drugs, and the sales rate, and α, β, γ are all greater than 0; After the analysis module obtains the sales coefficient, the sales coefficient is compared with the gradient threshold, where the gradient threshold includes a first gradient threshold TD1 and a second gradient threshold TD2, and the first gradient threshold is less than the second gradient threshold; When the first gradient threshold TD1≤sales coefficient xsz value≤second gradient threshold, the analysis module analyzes that the sales status of the drug is stable and there is no need to revise the estimated sales period; When the sales coefficient xsz value is less than the first gradient threshold TD1, the analysis module analyzes that the sales status of the drug is good and the estimated sales period needs to be revised; When the sales coefficient xs z When the value is greater than the second gradient threshold TD2, the analysis module analyzes that the sales status of the drug is poor and the estimated sales period needs to be revised; When it is determined that the expected sales period needs to be re-forecasted, the period forecasting module corrects the expected sales period by the sales coefficient to obtain the predicted sales period. The calculation expression is: In the formula, qx s To predict the sales period, qx y For the estimated sales period, xs z is the sales coefficient, TD1 is the first gradient threshold, and TD2 is the second gradient threshold; The calculation expression of the growth rate of drug storage volume is: In the formula, GRO is the growth rate of drug storage volume, dc is the current storage volume, and qc is the storage volume in the previous period; The sales rate calculation expression is: In the formula, SR is the sales rate, dx is the current sales volume, qx is the sales volume of the previous period, and Ts is the time interval between the current time and the previous time; The calculation expression of the similar drug substitution index is: In the formula, YT is the substitution index of similar drugs, Z(t) is the change in drug market share, [t x , t y The period for increasing the quantity warning for similar substitute drugs, [t i , t j ] is the period when the demand for medicines increases.

2. An intelligent drug sales data management system according to claim 1, characterized in that: The logic for obtaining the time period for the warning of the increase in the amount of similar substitute drugs is as follows: the time period when the increase in the amount of similar substitute drugs exceeds the increase threshold is the time period for the warning of the increase in the amount of similar substitute drugs; The logic for obtaining the time period when the demand for medicine increases is: the time period when the demand for medicine exceeds the demand threshold is the time period when the demand for medicine increases.

Citation Information

Patent Citations

  • Warehouse management system, warehouse management method and cargo distribution method

    CN105913209A

  • Drug inventory prediction system and method based on big data

    CN111310977A

  • Method and system for determining optimal ordering time of drug purchasing

    CN112101879A

  • System for predicting available time of drugstore inventory

    CN112330375A

  • Logistic warehousing and storaging decision supporting system

    CN1741053A