Warehouse replenishment optimization methods, devices, computer equipment, and storage media

By calculating the theoretical inventory ratio between the main warehouse and the sub-warehouses, the replenishment strategy is optimized, solving the problems of uneven inventory distribution and backlog in existing technologies, and achieving accurate replenishment and balanced distribution of inventory.

CN117436784BActive Publication Date: 2026-11-17SF TECH CO LTD
View PDF 2 Cites 0 Cited by

Patent Information

Application Number
CN202210822807.8
Authority / Receiving Office
CN · China
Patent Type
Patents(China)
Current Assignee / Owner
Filing Date
2022-07-12
Publication Date
2026-11-17
Estimated Expiration
2042-07-12

AI Technical Summary

Technical Problem

Existing warehouse replenishment methods cannot ensure that the total warehouse inventory is sufficient to meet the needs of the warehouses. At the same time, there are problems such as uneven inventory distribution and inventory backlog in some warehouses, resulting in low inventory replenishment accuracy.

Method used

By obtaining sales forecast information from the main warehouse and sub-warehouses, the theoretical inventory ratio of each warehouse is calculated, and the theoretical inventory information of each warehouse is analyzed based on the optimal inventory ratio. The target replenishment quantity from the main warehouse to the sub-warehouses is obtained, and the replenishment strategy is optimized to ensure inventory balance.

Benefits of technology

It improved the accuracy of supply chain inventory replenishment, solved the problem of insufficient total warehouse inventory preventing normal shipments, and avoided uneven inventory distribution and backlog, achieving a balanced distribution of inventory.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN117436784B_ABST
    Figure CN117436784B_ABST
Patent Text Reader

Abstract

This application provides a method, apparatus, computer equipment, and storage medium for optimizing warehouse replenishment. The method includes: acquiring sales forecast information for at least two warehouses over a future period; wherein the at least two warehouses include a main warehouse and sub-warehouses, with the main warehouse supplying replenishment goods to the sub-warehouses; parsing the sales forecast information to determine the theoretical inventory ratio of each warehouse, obtaining a first theoretical inventory ratio for the main warehouse and a second theoretical inventory ratio for the sub-warehouses; determining the optimal inventory ratio for each warehouse based on the first and second theoretical inventory ratios; and analyzing the theoretical inventory information of each warehouse based on the optimal inventory ratios to obtain the target replenishable quantity of the main warehouse for the sub-warehouses. This method can improve the accuracy of inventory replenishment.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] This application relates to the field of supply chain technology, and in particular to a method, apparatus, computer equipment, and storage medium for optimizing warehouse replenishment. Background Technology

[0002] With the rapid development of the supply chain economy, the breadth and sources of supply chain materials are also increasing from multiple perspectives, making it impossible to meet current supply chain needs by relying on a single supplier. Multi-supplier supply and demand systems are widely used because they can effectively optimize supply and demand flexibility and reduce procurement costs.

[0003] However, the system maintains supply and demand balance by predicting sales volume in distribution warehouses, setting replenishment cycles and service levels, calculating safety stock for each warehouse, and then combining this with the warehouse's inventory and in-transit inventory to determine the replenishment quantity for each warehouse. A portion of the total warehouse inventory is then used to replenish the distribution warehouses. However, this operation not only fails to ensure that the total warehouse has sufficient inventory for distribution warehouses to consume, but also fails to ensure that the total warehouse's own shipping function is unaffected. It inevitably leads to a trade-off: with limited total warehouse inventory, the existing replenishment technology can cause distribution warehouses to replenish more inventory the more they sell, even exceeding their required inventory, while distribution warehouses with low sales receive less and less replenishment, sometimes failing to meet their inventory needs. This can easily result in uneven overall inventory distribution and inventory backlog in some warehouses.

[0004] Therefore, existing warehouse-based replenishment methods suffer from technical problems, such as low inventory replenishment accuracy due to unreasonable replenishment strategies. Summary of the Invention

[0005] The purpose of this application is to provide a method, apparatus, computer equipment, and storage medium for optimizing warehouse replenishment, so as to improve the replenishment accuracy of supply chain inventory.

[0006] Firstly, this application provides a method for optimizing warehouse replenishment, including:

[0007] Obtain sales forecast information for at least two warehouses over a future period of time; wherein the at least two warehouses include a main warehouse and a branch warehouse, and the main warehouse is used to supply goods to the branch warehouses;

[0008] Analyze sales forecast information to determine the theoretical inventory ratio of each warehouse, and obtain the first theoretical inventory ratio of the total warehouse and the second theoretical inventory ratio of each warehouse.

[0009] Based on the first theoretical inventory ratio and the second theoretical inventory ratio, the optimal inventory ratio for each warehouse is determined.

[0010] Based on the optimal inventory ratio, the theoretical inventory information of each warehouse is analyzed to obtain the target replenishment quantity of the total warehouse for each sub-warehouse.

[0011] In some embodiments of this application, parsing sales forecast information to determine the theoretical inventory ratio of each warehouse, obtaining a first theoretical inventory ratio for the total warehouse and a second theoretical inventory ratio for each warehouse, includes: summing the sales forecast information of each warehouse to obtain a total sales forecast value; calculating the ratio of the sales forecast information of each warehouse to the total sales forecast value to obtain the theoretical inventory ratio of each warehouse; determining the theoretical inventory ratio of the total warehouse as the first theoretical inventory ratio; and determining the theoretical inventory ratio of each warehouse as the second theoretical inventory ratio.

[0012] In some embodiments of this application, determining the optimal inventory ratio for each warehouse based on a first theoretical inventory ratio and a second theoretical inventory ratio includes: calculating the sales percentage quantile of each item belonging to the total warehouse to optimize the first theoretical inventory ratio; adjusting the second theoretical inventory ratio according to the optimized first theoretical inventory ratio to obtain the adjusted second theoretical inventory ratio; and determining the optimized first theoretical inventory ratio and the adjusted second theoretical inventory ratio as the optimal inventory ratio.

[0013] In some embodiments of this application, calculating the sales percentage quantile of each item belonging to the main warehouse to optimize the first theoretical inventory ratio includes: calculating the sales percentage value of each item belonging to the main warehouse; determining the target sales percentage value among the sales percentage values ​​based on the preset target quantile as the sales percentage quantile; and replacing the first theoretical inventory ratio with the maximum value between the sales percentage quantile and the first theoretical inventory ratio to optimize the first theoretical inventory ratio.

[0014] In some embodiments of this application, adjusting the second theoretical inventory ratio based on the optimized first theoretical inventory ratio to obtain the adjusted second theoretical inventory ratio includes: determining the second theoretical inventory ratio of the target sub-warehouse and the sum of the second theoretical inventory ratios of other sub-warehouses besides the target sub-warehouse, as the total second theoretical inventory ratio; when the sum of the optimized first theoretical inventory ratio and the second theoretical inventory ratio is 1, determining that the proportional relationship between the second theoretical inventory ratio and the total second theoretical inventory ratio remains unchanged, thereby adjusting the second theoretical inventory ratio to obtain the adjusted second theoretical inventory ratio.

[0015] In some embodiments of this application, the theoretical inventory information of each warehouse is analyzed based on the optimal inventory ratio to obtain the target replenishment quantity of the total warehouse for the sub-warehouses. This includes: obtaining the sum of the actual inventory information of each warehouse to obtain the total actual inventory; calculating the product of the total actual inventory and the optimal inventory ratio for both the total warehouse and the sub-warehouses to obtain the theoretical inventory information of each warehouse; and obtaining the target replenishment quantity of the total warehouse for the sub-warehouses based on the theoretical inventory information.

[0016] In some embodiments of this application, the target replenishable quantity of the total warehouse for the sub-warehouses is obtained based on the theoretical inventory information of each warehouse. This includes: determining the replenishable quantity of the total warehouse and the required replenishment quantity of each sub-warehouse based on the theoretical inventory information of each warehouse; if the replenishable quantity of the total warehouse is positive and the sum of the required replenishment quantities of each sub-warehouse is less than the replenishable quantity of the total warehouse, then the required replenishment ratio of each sub-warehouse is obtained; the product of the required replenishment ratio and the replenishable quantity is obtained to obtain the target replenishable quantity of the total warehouse for the sub-warehouses; wherein, the required replenishment ratio is the ratio between the required replenishment quantity and the total required replenishment quantity, and the total required replenishment quantity is the sum of the required replenishment quantities of each sub-warehouse.

[0017] In some embodiments of this application, the replenishable quantity of the total warehouse and the required replenishment quantity of each warehouse are determined based on the theoretical inventory information of each warehouse. This includes: determining the theoretical inventory information of the total warehouse as the first theoretical inventory information, and determining the theoretical inventory information of each warehouse as the second theoretical inventory information; determining the difference between the actual inventory information of the total warehouse and the first theoretical inventory information as the replenishable quantity; and when the actual inventory information of each warehouse is less than the second theoretical inventory information, determining the difference between the second theoretical inventory information and the actual inventory information of each warehouse as the required replenishment quantity.

[0018] In some embodiments of this application, obtaining the product of the required replenishment ratio and the replenishable quantity to obtain the target replenishable quantity of the main warehouse for the sub-warehouse includes: obtaining the product of the required replenishment ratio and the replenishable quantity as the candidate replenishable quantity for the corresponding sub-warehouse; if the candidate replenishable quantity is greater than or equal to the required replenishment quantity, then based on a preset replenishment quantity limit, determining any value between the required replenishment quantity and the candidate replenishable quantity as the target replenishable quantity; if the candidate replenishable quantity is less than the required replenishment quantity, and the candidate replenishable quantity is a positive integer, then determining the candidate replenishable quantity as the target replenishable quantity.

[0019] Secondly, this application provides a warehouse replenishment optimization device, comprising:

[0020] The sales acquisition module is used to obtain sales forecast information for at least two warehouses over a future period of time; the at least two warehouses include a main warehouse and a branch warehouse, with the main warehouse used to supply goods to the branch warehouses;

[0021] The ratio determination module is used to parse sales forecast information to determine the theoretical inventory ratio of each warehouse, and obtain the first theoretical inventory ratio of the total warehouse and the second theoretical inventory ratio of the individual warehouses.

[0022] The ratio optimization module is used to determine the optimal inventory ratio for each warehouse based on the first theoretical inventory ratio and the second theoretical inventory ratio.

[0023] The inventory acquisition module is used to analyze the theoretical inventory information of each warehouse based on the optimal inventory ratio, so as to obtain the target replenishable quantity of the total warehouse for each sub-warehouse based on the theoretical inventory information.

[0024] Thirdly, this application also provides a computer device, comprising:

[0025] One or more processors;

[0026] The memory; and one or more applications, wherein the one or more applications are stored in the memory and configured to be executed by the processor to implement the above-described warehouse replenishment optimization method.

[0027] Fourthly, this application also provides a computer-readable storage medium having a computer program stored thereon, the computer program being loaded by a processor to execute the steps in the warehouse replenishment optimization method.

[0028] Fifthly, embodiments of this application provide a computer program product or computer program that includes computer instructions stored in a computer-readable storage medium. A processor of a computer device reads the computer instructions from the computer-readable storage medium and executes the computer instructions, causing the computer device to perform the method provided in the first aspect described above.

[0029] The aforementioned warehouse replenishment optimization method, apparatus, computer equipment, and storage medium involve a server acquiring and analyzing sales forecast information for the main warehouse and sub-warehouses over a future period. This sales forecast information is used to determine the theoretical inventory ratio for each warehouse, resulting in a first theoretical inventory ratio for the main warehouse and a second theoretical inventory ratio for each sub-warehouse. Based on these ratios, the optimal inventory ratio for each warehouse is determined. The theoretical inventory information for each warehouse is then analyzed based on the optimal ratio, ultimately yielding the target replenishable quantity from the main warehouse to the sub-warehouses. Therefore, this application proposes using an algorithm to calculate the theoretical inventory percentage for each warehouse and using this theoretical inventory ratio to analyze and obtain the target replenishable quantity for each sub-warehouse within the constraints of the main warehouse. This not only efficiently improves the replenishment accuracy in supply chain scenarios and meets the replenishment needs of sub-warehouses but also solves the problem of insufficient inventory in the main warehouse, preventing normal order processing and shipment. Attached Figure Description

[0030] To more clearly illustrate the technical solutions in the embodiments of this application, the accompanying drawings used in the description of the embodiments will be briefly introduced below. Obviously, the accompanying drawings described below are only some embodiments of this application. For those skilled in the art, other drawings can be obtained based on these drawings without creative effort.

[0031] Figure 1 This is a schematic diagram illustrating a scenario of the warehouse replenishment optimization method provided in the embodiments of this application;

[0032] Figure 2 This is a flowchart illustrating the optimized warehouse replenishment method provided in the embodiments of this application;

[0033] Figure 3 This is a schematic diagram illustrating the specific process of the warehouse replenishment optimization method provided in the embodiments of this application.

[0034] Figure 4 This is a schematic diagram of the structure of the warehouse replenishment optimization device provided in the embodiments of this application;

[0035] Figure 5 This is a schematic diagram of the structure of the computer device provided in the embodiments of this application. Detailed Implementation

[0036] The technical solutions of the embodiments of this application will be clearly and completely described below with reference to the accompanying drawings. Obviously, the described embodiments are only some embodiments of this application, and not all embodiments. Based on the embodiments of this application, all other embodiments obtained by those skilled in the art without creative effort are within the scope of protection of this application.

[0037] In the description of this application, the terms "first" and "second" are used for descriptive purposes only and should not be construed as indicating or implying relative importance or implicitly specifying the number of indicated technical features. Thus, a feature defined as "first" or "second" may explicitly or implicitly include one or more of the stated features. In the description of this application, "multiple" means two or more, unless otherwise explicitly specified.

[0038] In the description of this application, the term "for example" is used to mean "used as an example, illustration, or description." Any embodiment described as "for example" in this application is not necessarily to be construed as being more preferred or advantageous than other embodiments. The following description is provided to enable any person skilled in the art to make and use the invention. Details are set forth in the following description for purposes of explanation. It should be understood that those skilled in the art will recognize that the invention can be made without using these specific details. In other instances, well-known structures and processes will not be described in detail to avoid obscuring the description of the invention with unnecessary detail. Therefore, the invention is not intended to be limited to the embodiments shown, but is consistent with the broadest scope of the principles and features disclosed in this application.

[0039] In this embodiment of the application, the warehouse replenishment optimization method provided can be applied to, for example, Figure 1 The illustrated warehouse replenishment optimization system includes a terminal 102 and a server 104. The terminal 102 can be a device that includes both receiving and transmitting hardware, i.e., a device with receiving and transmitting hardware capable of performing bidirectional communication over a bidirectional communication link. Such a device can include cellular or other communication devices with single-line displays, multi-line displays, or no multi-line displays. Specifically, the terminal 102 can be a desktop terminal or a mobile terminal; it can also be a mobile phone, tablet computer, or laptop computer. The server 104 can be a standalone server or a server network or server cluster, including but not limited to computers, network hosts, single network servers, multiple network server sets, or cloud servers composed of multiple servers. The cloud server consists of a large number of computers or network servers based on cloud computing. Furthermore, the terminal 102 and server 104 establish a communication connection through a network, which can be any of a wide area network (WAN), local area network (LAN), or metropolitan area network (MAN).

[0040] Those skilled in the art will understand that Figure 1 The application environment shown is merely one applicable scenario for the solution in this application and does not constitute a limitation on the application scenario of the solution in this application. Other application environments may include more than one. Figure 1 The number of devices shown may be more or less. For example, Figure 1 Only one server is shown. It is understood that this warehouse replenishment optimization system may also include one or more other devices, which are not specifically limited here. Additionally, the system may include a storage device for storing data such as actual inventory information and sales forecast information.

[0041] It should be noted that, Figure 1 The schematic diagram of the distributed warehouse replenishment optimization system shown is merely an example. The distributed warehouse replenishment optimization system and scenario described in the embodiments of the present invention are for the purpose of more clearly illustrating the technical solutions of the embodiments of the present invention, and do not constitute a limitation on the technical solutions provided by the embodiments of the present invention. As those skilled in the art will know, with the evolution of the distributed warehouse replenishment optimization system and the emergence of new business scenarios, the technical solutions provided by the embodiments of the present invention are also applicable to similar technical problems.

[0042] See Figure 2 This application provides a method for optimizing warehouse replenishment, and this embodiment mainly applies this method to the above-mentioned... Figure 1 Taking server 104 as an example, the method includes steps S201 to S204, as follows:

[0043] S201, Obtain sales forecast information for at least two warehouses over a future period of time; wherein the at least two warehouses include a main warehouse and a sub-warehouse, and the main warehouse is used to supply goods to the sub-warehouses.

[0044] To minimize logistics costs, retailers typically establish warehouses across multiple locations nationwide. For this "factory-central warehouse-sub-sub-warehouse" network structure, the main operations are as follows: Replenishment flow: The factory delivers goods to the central warehouse, and the central warehouse delivers goods to the sub-warehouses; Shipping flow: Both the central warehouse and sub-warehouses can ship to the customer. It's understood that there can be one central warehouse and multiple sub-warehouses. The following example illustrates a scenario where there is one central warehouse and more than one sub-warehouse.

[0045] In specific implementation, server 104 can predict the sales volume of each warehouse within a future period based on historical sales data of each warehouse and using a preset sales prediction algorithm, thus obtaining sales prediction information, which can be represented as "S". i (i = 1, ..., n)”. The duration of the period can be any duration in units of “minutes, hours, days, months, quarters, and years”, such as “3 days”, and can be set according to actual business needs. The sales forecasting algorithm can be a forecasting algorithm that takes into account holidays and non-holidays, or it can be a forecasting algorithm that takes into account the number of customers and / or the number of warehouses. The specific implementation of this application is not limited.

[0046] S202, Analyze the sales forecast information to determine the theoretical inventory ratio of each warehouse, and obtain the first theoretical inventory ratio of the total warehouse and the second theoretical inventory ratio of the sub-warehouses.

[0047] For specific implementation details, please refer to [link / reference]. Figure 3Since the inventory ratio is usually proportional to the sales forecast information, this application proposes to obtain the theoretical inventory ratio of each warehouse by calculating the proportion of the predicted sales of each warehouse to the total predicted sales of all warehouses nationwide. The theoretical inventory ratio of the warehouse with the role of the total warehouse is taken as the first theoretical inventory ratio, and the theoretical inventory ratio of the warehouse with the role of the sub-warehouse is taken as the second theoretical inventory ratio. The specific analysis method will be explained in detail below.

[0048] In one embodiment, this step includes: summing the sales forecast information of each warehouse to obtain the total sales forecast value; calculating the ratio of the sales forecast information of each warehouse to the total sales forecast value to obtain the theoretical inventory ratio of each warehouse; determining the theoretical inventory ratio of the total warehouse as the first theoretical inventory ratio; and determining the theoretical inventory ratio of each sub-warehouse as the second theoretical inventory ratio.

[0049] In practice, the formula for calculating the theoretical inventory ratio can be: r1+r i +…+r n =1, This refers to the total sales forecast, which is also the sum of sales forecasts for all warehouses nationwide over a future period. i If 'r' represents the sales forecast information for the i-th warehouse over a future period, then the first theoretical inventory ratio of the total warehouse can be represented as 'r1', and the second theoretical inventory ratio of the sub-warehouses can be represented as 'r'. i=2…n The formula shows that the total number of warehouses is 1, and the number of sub-warehouses is greater than 1.

[0050] S203, based on the first theoretical inventory ratio and the second theoretical inventory ratio, determine the optimal inventory ratio for each warehouse.

[0051] In practice, when a warehouse's inventory is insufficient, orders belonging to that warehouse will flow to other warehouses with sufficient inventory, which can easily lead to increased logistics costs. Therefore, to reduce supply chain logistics costs, it is necessary to ensure that the inventory of each warehouse can meet orders for the next N days. However, the inventory of the central warehouse is often constrained by the frequency and volume of deliveries from the factory, making it impossible to ensure that it is always in a sufficient state. Existing warehouse replenishment strategies have not proposed demand analysis for the central warehouse for the next N days, simply considering the equal distribution of excess inventory in the central warehouse. This not only easily leads to high-volume warehouses having increasingly large inventories, even exceeding their required inventory, but also easily results in uneven inventory distribution, insufficient inventory held by the central warehouse, and ultimately abnormal shipments to customers, requiring cross-warehouse order fulfillment. Therefore, this application proposes a warehouse replenishment optimization method to improve the accuracy of inventory replenishment, which can solve the problem of insufficient inventory held by the central warehouse to accept and ship orders normally, and also avoid the situation where high-volume warehouses accumulate large amounts of inventory.

[0052] Furthermore, since the central warehouse needs to replenish downstream branch warehouses and also receive sales orders from clients for direct shipment, it must perform two functions. Therefore, the central warehouse's inventory must be maintained at a certain percentage and cannot be empty. Thus, when a branch warehouse generates a replenishment request, server 104 must prioritize meeting the central warehouse's theoretical inventory, ensuring that the central warehouse's theoretical inventory is maintained. This requires determining whether the central warehouse's first theoretical inventory ratio is greater than zero; if so, it indicates that the central warehouse's theoretical inventory ratio is normal; if not, it indicates that the central warehouse's theoretical inventory ratio is abnormal, because its inventory must be maintained at a certain percentage and cannot be empty. Once empty, its own shipping function cannot be guaranteed to remain normal.

[0053] Therefore, this application proposes an anomaly correction scheme. When server 104 detects that the first theoretical inventory ratio of the total warehouse is zero or less than a preset threshold, it is necessary to further calculate the sales percentage quantile of each item belonging to the total warehouse. This sales percentage quantile is used to optimize the first theoretical inventory ratio, ensuring that the optimized first theoretical inventory ratio is not zero (i.e., not empty), thus guaranteeing its functionality during subsequent warehouse replenishment. The anomaly correction scheme will be described in detail below. However, if there is no anomaly, only the first and second theoretical inventory ratios obtained from the preceding steps need to be determined as the optimal inventory ratios for the corresponding total warehouse or warehouse. There is no need to optimize the first theoretical inventory ratio or adjust the second theoretical inventory ratio.

[0054] In one embodiment, this step includes: calculating the sales percentage quantile of each item belonging to the total warehouse to optimize the first theoretical inventory ratio; adjusting the second theoretical inventory ratio based on the optimized first theoretical inventory ratio to obtain the adjusted second theoretical inventory ratio; and determining the optimized first theoretical inventory ratio and the adjusted second theoretical inventory ratio as the optimal inventory ratio.

[0055] The sales percentage quantile can be represented as "Q". The quantile value can be set according to actual business needs, such as the quartile, quartile, etc. The specific implementation of this application is not limited.

[0056] The optimized first theoretical inventory ratio can be represented as "r′1", and the adjusted second theoretical inventory ratio can be represented as "r′". i=2…n ".

[0057] For specific implementation details, please refer to [link / reference]. Figure 3When server 104 detects that the first theoretical inventory ratio "r1" is zero or less than a preset threshold, it needs to assign a ratio to the total warehouse. If there is a situation where it is impossible to determine whether the first theoretical inventory ratio "r1" is less than the preset threshold, such as when no preset threshold is set, a more direct approach is to calculate the sales percentage quantile "Q" of each item belonging to the total warehouse, and use this sales percentage quantile "Q" to optimize the first theoretical inventory ratio. Since the sum of the theoretical inventory ratios of all warehouses should be "1", once the first theoretical inventory ratio "r1" is optimized to "r′1", the second theoretical inventory ratio "r" will be adjusted accordingly. i=2…n "Should also be changed to "r′" i=2…n The first theoretical inventory ratio optimization step and the second theoretical inventory ratio adjustment step involved in this embodiment will be described in detail below.

[0058] In one embodiment, calculating the sales percentage quantile of each item belonging to the total warehouse to optimize the first theoretical inventory ratio includes: calculating the sales percentage value of each item belonging to the total warehouse; determining the target sales percentage value among the sales percentage values ​​based on the preset target quantile, as the sales percentage quantile; and replacing the first theoretical inventory ratio with the maximum value between the sales percentage quantile and the first theoretical inventory ratio to optimize the first theoretical inventory ratio.

[0059] The sales percentage can be obtained by acquiring the sales volume of each item and the total sales volume, and then calculating the ratio of each item's sales volume to the total sales volume. For example, if the sales volume of item A is "20", the sales volume of item B is "50", and the sales volume of item C is "30", then the sales percentage of item A is "0.2", the sales percentage of item B is "0.5", and the sales percentage of item C is "0.3".

[0060] The target quantile can be set to quartile, quartile, etc., according to actual business needs, and the specific implementation of this application is not limited thereto.

[0061] In practice, when server 104 detects that the first theoretical inventory ratio "r1" is zero or less than a preset threshold, it needs to assign a ratio to the total warehouse. Through practical verification, the target quantile of the proportion of all goods in the total warehouse to the national sales volume can be considered as the lower limit of the total warehouse inventory ratio. For example, a total warehouse contains 3 types of goods (also called commodities): A, B, and C; where the sales ratio of A is "0.2", the sales ratio of B is "0.5", and the sales ratio of C is "0.3". If the median (also called the quartile) is taken, the sales ratio quantile is "Q = 0.3". Since "r1 = 0", the lower limit of the total warehouse inventory ratio is "0.3".

[0062] Thus, it can be seen that the optimization formula for the first theoretical inventory ratio is: r'₁ = max(r₁, Q), and the optimized first theoretical inventory ratio is denoted as "r'₁". Certainly, the above example illustrates the case where the first theoretical inventory ratio "r₁ = 0", but when the first theoretical inventory ratio "r₁ ≠ 0" and "r₁ < Q", "r'₁" also takes the value "Q". Since the sales volume is proportional to the inventory ratio, it is necessary to ensure the inventory with the sales volume. For a detailed explanation, reference may be made to the above description, which will not be repeated in the embodiments of the present application.

[0063] In one embodiment, adjusting the second theoretical inventory ratio according to the optimized first theoretical inventory ratio to obtain an adjusted second theoretical inventory ratio includes: determining the second theoretical inventory ratio of the target sub-warehouse and the sum of the second theoretical inventory ratios of other sub-warehouses except the target sub-warehouse, which is taken as the total second theoretical inventory ratio; in the case that the sum of the optimized first theoretical inventory ratio and the second theoretical inventory ratio is 1, determining that the proportional relationship between the second theoretical inventory ratio and the total second theoretical inventory ratio remains unchanged, so as to adjust the second theoretical inventory ratio and obtain the adjusted second theoretical inventory ratio.

[0064] The target sub-warehouse may be a sub-warehouse currently designated to have its second theoretical inventory ratio adjusted. It can be understood that each sub-warehouse will take turns to serve as the target sub-warehouse, so that its second theoretical inventory ratio can be adjusted.

[0065] For specific implementation, reference may be made to Figure 3 , since r₁+r i +…+r n =1, that is then it is reasonable to determine According to the optimized first theoretical inventory ratio "r'₁" of the main warehouse, the sum of the second theoretical inventory ratios of other sub-warehouses should be:

[0066]

[0067]

[0068] The total second theoretical inventory ratio can be expressed as The formula for determining that the proportional relationship between the second theoretical inventory ratio and the total second theoretical inventory ratio remains unchanged can be expressed as:

[0069]

[0070] Further, the server 104, combining the above two sets of formulas, can obtain the adjusted second theoretical inventory ratio based on the following equation:

[0071] r' i / 1-r'₁=r i / 1-r₁

[0072] Finally, the adjusted second theoretical inventory ratio "r′" is obtained. i ":

[0073] r′ i =r i / (1-r1)·(1-r′1),i=2,…,n

[0074] Among them, due to the second theoretical inventory ratio "r i The analysis methods for the first theoretical inventory ratio "r1" and the optimized first theoretical inventory ratio "r′1" have been explained in detail above, and have been obtained in the previous steps. Therefore, an accurate "r′" can be obtained without a doubt. i ".

[0075] S204, based on the optimal inventory ratio, analyzes the theoretical inventory information of each warehouse, and obtains the target replenishment quantity of the total warehouse for each sub-warehouse based on the theoretical inventory information.

[0076] The optimal inventory ratio can be either the first theoretical inventory ratio "r1" or the second theoretical inventory ratio "r". i ", can also be the optimized first theoretical inventory ratio "r′1" and the adjusted second theoretical inventory ratio "r′". i "This mainly depends on whether the first theoretical inventory ratio has been optimized."

[0077] In the specific implementation, after the server 104 analyzes and obtains the optimal inventory ratio of each warehouse, it can analyze and obtain the theoretical inventory information of each warehouse based on the optimal inventory ratio. Then, based on the goal of satisfying the theoretical inventory information of each warehouse, it analyzes and obtains the replenishable quantity from the total warehouse to each sub-warehouse as the target replenishable quantity. The specific steps will be explained in detail below.

[0078] In one embodiment, this step includes: obtaining the sum of the actual inventory information of each warehouse to obtain the total actual inventory; calculating the product of the total actual inventory and the optimal inventory ratio for both the main warehouse and the sub-warehouses to obtain the theoretical inventory information for each warehouse; and obtaining the target replenishable quantity of the main warehouse for the sub-warehouses based on the theoretical inventory information.

[0079] The actual inventory information can be data pre-stored in a database, and its index can be a warehouse identifier. That is, server 104 can obtain the actual inventory information of the corresponding warehouse by querying the warehouse identifier. The actual inventory information can be represented as "INV". i "", which refers to the actual inventory information of the i-th warehouse. This actual inventory information can be updated according to a preset period or in real time; the specific implementation of this application is not limited to this.

[0080] The total actual inventory can be expressed as:

[0081] In the specific implementation, server 104 analyzes and obtains the optimal inventory ratio "r′" for each warehouse. i After "(i=1,…,n)", we can further obtain the actual inventory information of each warehouse, and then calculate the sum of the actual inventory information of all warehouses to obtain the total actual inventory. Finally, the theoretical inventory information "INV_a" for each warehouse is calculated based on a custom formula. i ":

[0082]

[0083] Furthermore, after analyzing and obtaining the theoretical inventory information of each warehouse, server 104 can obtain the target replenishable quantity of the total warehouse for each sub-warehouse based on the theoretical inventory information. The steps for obtaining the target replenishable quantity will be described in detail below.

[0084] In one embodiment, obtaining the target replenishable quantity of the total warehouse for each sub-warehouse based on the theoretical inventory information includes: determining the replenishable quantity of the total warehouse and the required replenishable quantity of each sub-warehouse based on the theoretical inventory information of each warehouse; if the replenishable quantity of the total warehouse is positive and the sum of the required replenishable quantities of each sub-warehouse is less than the replenishable quantity of the total warehouse, then obtaining the required replenishable percentage of each sub-warehouse; obtaining the product of the required replenishable percentage and the replenishable quantity to obtain the target replenishable quantity of the total warehouse for each sub-warehouse; wherein, the required replenishable percentage is the ratio between the required replenishable quantity and the total required replenishable quantity, and the total required replenishable quantity is the sum of the required replenishable quantities of each sub-warehouse.

[0085] The replenishable quantity of the total warehouse can be represented as "REP_c", and the required replenishment quantity of sub-warehouse "i" can be represented as "REP_n". i The percentage of restocking required for warehouse "i" can be represented as "R_n". i The total replenishment required for all warehouses can be expressed as: The target replenishable quantity can be expressed as "REP". i ".

[0086] In the specific implementation, server 104 analyzes and obtains the theoretical inventory information "INV_a" for each warehouse. i After that, you can use the theoretical inventory information "INV_a" i The replenishment quantity of the main warehouse and the replenishment quantity of each sub-warehouse are determined separately. Then, it is determined whether the replenishment quantity of the main warehouse is positive. If it is, it means that the main warehouse has excess inventory that guarantees the theoretical inventory, and the excess inventory can be distributed to other sub-warehouses. If not, it means that the main warehouse cannot guarantee its theoretical inventory at present, and there is no excess inventory to be distributed to other warehouses.

[0087] Furthermore, if server 104 detects that the total replenishable quantity of the warehouse is positive, it can further calculate the sum of the required replenishment quantities of each sub-warehouse and determine whether the sum of the required replenishment quantities is less than the total replenishable quantity of the warehouse. If so, it means that the total replenishable quantity of the warehouse can meet the required replenishment quantities of each sub-warehouse with replenishment needs; if not, it means that the total replenishable quantity of the warehouse cannot meet the required replenishment quantities of all sub-warehouses with replenishment needs. This embodiment will explain the case where the total replenishable quantity of the warehouse is positive, and the sum of the required replenishment quantities of each sub-warehouse is less than the total replenishable quantity of the warehouse. Specifically, the required replenishment ratio of each sub-warehouse is obtained, and then based on this ratio, the total replenishable quantity of the warehouse is proportionally allocated, thus obtaining the target replenishable quantity that satisfies all warehouses under ideal conditions.

[0088] For example, if the sum of the replenishment needs of all sub-warehouses is less than the total replenishment capacity of the warehouse, then each sub-warehouse needs to allocate replenishment on demand. This can be done by allocating replenishment according to the proportion of each sub-warehouse's replenishment needs to the total replenishment needs of all sub-warehouses, i.e., the proportion of replenishment needs of the i-th sub-warehouse "R_n". i "for:

[0089] In one embodiment, determining the replenishable quantity of the total warehouse and the required replenishment quantity of each warehouse based on the theoretical inventory information of each warehouse includes: determining the theoretical inventory information of the total warehouse as the first theoretical inventory information, and determining the theoretical inventory information of each warehouse as the second theoretical inventory information; determining the difference between the actual inventory information of the total warehouse and the first theoretical inventory information as the replenishable quantity; and when the actual inventory information of a warehouse is less than the second theoretical inventory information, determining the difference between the second theoretical inventory information and the actual inventory information of the warehouse as the required replenishment quantity.

[0090] In this embodiment, the theoretical inventory information is represented as "INV_a". i Therefore, the first theoretical inventory information can be represented as "INV_a1", and the second theoretical inventory information can be represented as "INV_a". i The actual inventory information of the main warehouse can be represented as "INV1", and the actual inventory information of the branch warehouses can be represented as "INV". i ”, where i = 2, ..., n.

[0091] In practice, to ensure that the inventory of goods in the main warehouse is sufficient, it is necessary to ensure that the actual inventory of the main warehouse is equal to the theoretical inventory. Therefore, after retaining the theoretical inventory of the main warehouse, the remaining inventory of the main warehouse is the inventory that can be replenished to the branch warehouse. The replenishable quantity of the main warehouse "REP_c" is: REP_c = INV1 - INV_a1.

[0092] Furthermore, when server 104 detects that the actual inventory information of a certain sub-warehouse is greater than or equal to its second theoretical inventory information, it indicates that the sub-warehouse has sufficient inventory and does not need replenishment, and the replenishment quantity from the main warehouse to that sub-warehouse is zero; when server 104 detects that the actual inventory information of a certain sub-warehouse is less than its second theoretical inventory information, it can be determined that the sub-warehouse needs replenishment, and the required replenishment quantity for the sub-warehouse is "REP_n". i "is: REP_n i =INV_a i -INV i , i = 2, ..., n.

[0093] In one embodiment, obtaining the product of the required replenishment ratio and the replenishable quantity to obtain the target replenishable quantity of the total warehouse for the sub-warehouse includes: obtaining the product of the required replenishment ratio and the replenishable quantity as the candidate replenishable quantity for the corresponding sub-warehouse; if the candidate replenishable quantity is greater than or equal to the required replenishment quantity, then based on a preset replenishment quantity limit, determining any value between the required replenishment quantity and the candidate replenishable quantity as the target replenishable quantity; if the candidate replenishable quantity is less than the required replenishment quantity, and the candidate replenishable quantity is a positive integer, then determining the candidate replenishable quantity as the target replenishable quantity.

[0094] In the specific implementation, server 104 analyzes and obtains the replenishment requirement ratio "R_n" for each sub-warehouse. i After obtaining the total replenishable quantity "REP_c" of the warehouse, we can calculate its product as the candidate replenishable quantity "REP" for the i-th sub-warehouse. i ":REP i =REP_c·R_n i , i = 2, ..., n. However, the candidate replenishable quantities at this point cannot yet be determined as the final target replenishable quantities. Server 104 still needs to compare them with the required replenishable quantities "REP_n" obtained from the previous steps. i "Compare and determine the candidate replenishable quantity" (REP) i "REP_n" (replenishment quantity required) i The size relationship between "".

[0095] Specifically, when total warehouse inventory is insufficient or limited, REP i <REP_n i This allows for on-demand allocation of inventory to sub-warehouses while ensuring sufficient total warehouse inventory. For example, if the total warehouse's replenishable quantity is "2" and the replenishment requirement for each of the two sub-warehouses is "0.5", then each sub-warehouse's candidate replenishable quantity is "1", but the required replenishment quantity for both sub-warehouses is "2", meaning "1 < 2", which meets the requirements of REP. i <REP_n iIn this regard, to ensure sufficient inventory in the main warehouse, each of the two branch warehouses can be replenished with "1". That is to say, the target replenishment quantity at this time is "1". The principle is that the main warehouse cannot be short of goods, and the branch warehouses cannot be short of goods, unless the goods are so few that each branch warehouse cannot get "1" (for example, if the replenishment quantity of the main warehouse is 1, then neither branch warehouse will be replenished).

[0096] Furthermore, when the total warehouse inventory is sufficient, REP i ≥REP_n i Candidate replenishable quantity "REP" i "This can serve as the upper limit for dynamic replenishment in the warehouse. As long as it does not exceed this quantity, inventory balance among the warehouses can be maintained. For example, if the replenishable quantity of the main warehouse is "10", and the required replenishment ratio of each of the two sub-warehouses is "0.5", then the candidate replenishable quantity of each of the two sub-warehouses is "5". However, the required replenishment quantity of each of the two sub-warehouses is "2", so "5 > 2", i.e., REP." i REP_n i In this case, server 104 can use "2" as the target replenishable quantity.

[0097] However, it should be noted that if a warehouse requests additional stock (for example, to fill a truck, "5-2=3" can be used to fill any gaps in the truck), then any value between "2" and "5" can be used as the target replenishment quantity. That is, either , where the minimum replenishment is 2 and the maximum is 5, but the excess "3" can be limited. For example, the target replenishment quantity cannot exceed 30 days' sales. If 30 days' sales are "4", then only "4" needs to be replenished, and the remaining "1" is not replenished. Therefore, the replenishment quantity limit mentioned in this embodiment can be a limitation considering future sales, and the specific conditions can be set according to actual business needs.

[0098] The warehouse replenishment optimization method in the above embodiments involves the server obtaining sales forecast information for the total warehouse and sub-warehouses over a future period, and parsing the sales forecast information to determine the theoretical inventory ratio of each warehouse. This yields the first theoretical inventory ratio of the total warehouse and the second theoretical inventory ratio of the sub-warehouses. Based on these first and second theoretical inventory ratios, the optimal inventory ratio for each warehouse is determined. Then, based on the optimal inventory ratio, the theoretical inventory information of each warehouse is analyzed. Finally, based on the theoretical inventory information, the target replenishable quantity of the total warehouse for the sub-warehouses is obtained. Therefore, this application proposes using an algorithm to calculate the theoretical inventory ratio of each warehouse, and based on this theoretical inventory ratio, analyzes and obtains the target replenishable quantity of the sub-warehouses. Simultaneously, by using the proportion of the required replenishment quantity for each warehouse instead of the historical sales ratio, it avoids the dilemma of warehouses with high sales volumes receiving excessive replenishment, resulting in a more balanced inventory allocation. This not only efficiently improves the accuracy of inventory replenishment in supply chain scenarios and meets the replenishment needs of sub-warehouses, but also solves the problem of insufficient inventory in the total warehouse, preventing normal order acceptance and shipment.

[0099] It should be understood that, although Figure 2 The steps in the flowchart are shown sequentially as indicated by the arrows, but these steps are not necessarily executed in the order indicated by the arrows. Unless otherwise specified in this document, there is no strict order in which these steps are executed, and they can be performed in other orders. Figure 2 At least some of the steps in the process may include multiple sub-steps or multiple stages. These sub-steps or stages are not necessarily completed at the same time, but can be executed at different times. The execution order of these sub-steps or stages is not necessarily sequential, but can be executed in turn or alternately with other steps or at least some of the sub-steps or stages of other steps.

[0100] To better implement the warehouse replenishment optimization method provided in the embodiments of this application, this application also provides a warehouse replenishment optimization device based on the proposed warehouse replenishment optimization method, such as... Figure 4 As shown, the warehouse replenishment optimization device 400 includes:

[0101] The sales acquisition module 410 is used to acquire sales forecast information for at least two warehouses over a future period of time; wherein, the at least two warehouses include a main warehouse and a sub-warehouse, and the main warehouse is used to supply and replenish goods to the sub-warehouses;

[0102] The ratio determination module 420 is used to parse sales forecast information to determine the theoretical inventory ratio of each warehouse, and obtain the first theoretical inventory ratio of the total warehouse and the second theoretical inventory ratio of the sub-warehouses.

[0103] The ratio optimization module 430 is used to determine the optimal inventory ratio for each warehouse based on the first theoretical inventory ratio and the second theoretical inventory ratio.

[0104] The inventory acquisition module 440 is used to analyze the theoretical inventory information of each warehouse based on the optimal inventory ratio, so as to obtain the target replenishable quantity of the total warehouse for each sub-warehouse based on the theoretical inventory information.

[0105] In one embodiment, the ratio determination module 420 is further configured to sum the sales forecast information of each warehouse to obtain the total sales forecast value; calculate the ratio of the sales forecast information of each warehouse to the total sales forecast value to obtain the theoretical inventory ratio of each warehouse; determine the theoretical inventory ratio of the total warehouse as the first theoretical inventory ratio; and determine the theoretical inventory ratio of the sub-warehouses as the second theoretical inventory ratio.

[0106] In one embodiment, the ratio optimization module 430 is further configured to, when the first theoretical inventory ratio is detected to be zero, calculate the sales percentage quantile of each item belonging to the total warehouse to optimize the first theoretical inventory ratio; adjust the second theoretical inventory ratio according to the optimized first theoretical inventory ratio to obtain the adjusted second theoretical inventory ratio; and determine the optimized first theoretical inventory ratio and the adjusted second theoretical inventory ratio as the optimal inventory ratio.

[0107] In one embodiment, the ratio optimization module 430 is further configured to calculate the sales percentage of each item belonging to the total warehouse when the first theoretical inventory ratio is detected to be zero; determine the target sales percentage among the sales percentage values ​​based on the preset target quantile as the sales percentage quantile; and replace the first theoretical inventory ratio with the maximum value between the sales percentage quantile and the first theoretical inventory ratio to optimize the first theoretical inventory ratio.

[0108] In one embodiment, the ratio optimization module 430 is further configured to determine the second theoretical inventory ratio of the target sub-warehouse and the sum of the second theoretical inventory ratios of other sub-warehouses besides the target sub-warehouse, as the second theoretical total inventory ratio; if the sum of the optimized first theoretical inventory ratio and the second theoretical inventory ratio is 1, it is determined that the proportional relationship between the second theoretical inventory ratio and the second theoretical total inventory ratio remains unchanged, so as to adjust the second theoretical inventory ratio and obtain the adjusted second theoretical inventory ratio.

[0109] In one embodiment, the inventory acquisition module 440 is further configured to acquire the sum of the actual inventory information of each warehouse to obtain the total actual inventory; for the main warehouse and the sub-warehouses, calculate the product of the total actual inventory and the optimal inventory ratio to obtain the theoretical inventory information of each warehouse; and based on the theoretical inventory information, acquire the target replenishable quantity of the main warehouse for the sub-warehouses.

[0110] In one embodiment, the inventory acquisition module 440 is further configured to determine the replenishable inventory of the total warehouse and the required replenishment inventory of each sub-warehouse based on the theoretical inventory information of each warehouse; if the replenishable inventory of the total warehouse is positive and the sum of the required replenishment inventory of each sub-warehouse is less than the replenishable inventory of the total warehouse, then the required replenishment ratio of each sub-warehouse is obtained; the product of the required replenishment ratio and the replenishable inventory is obtained to obtain the target replenishable inventory of the total warehouse for the sub-warehouses; wherein, the required replenishment ratio is the ratio between the required replenishment inventory and the total required replenishment inventory, and the total required replenishment inventory is the sum of the required replenishment inventory of each sub-warehouse.

[0111] In one embodiment, the inventory acquisition module 440 is further configured to determine the theoretical inventory information of the total warehouse as the first theoretical inventory information, and to determine the theoretical inventory information of the sub-warehouses as the second theoretical inventory information; to determine the difference between the actual inventory information of the total warehouse and the first theoretical inventory information as the replenishable quantity; and when the actual inventory information of the sub-warehouse is less than the second theoretical inventory information, to determine the difference between the second theoretical inventory information and the actual inventory information of the sub-warehouse as the replenishable quantity.

[0112] In one embodiment, the inventory quantity acquisition module 440 is further configured to acquire the product of the required replenishment ratio and the replenishable quantity as the candidate replenishable quantity for the corresponding sub-warehouse; if the candidate replenishable quantity is greater than or equal to the required replenishment quantity, then based on the preset replenishment quantity limit, any value between the required replenishment quantity and the candidate replenishable quantity is determined as the target replenishable quantity; if the candidate replenishable quantity is less than the required replenishment quantity and the candidate replenishable quantity is a positive integer, then the candidate replenishable quantity is determined as the target replenishable quantity.

[0113] In the above embodiments, this application proposes to use an algorithm to calculate the theoretical inventory ratio of each warehouse, and to analyze and obtain the target replenishable quantity of each warehouse based on the theoretical inventory ratio. At the same time, the proportion of the required replenishment quantity of each warehouse is used instead of the proportion of historical sales volume. This can get rid of the dilemma that warehouses with large sales volume will replenish more and more, and make the inventory distribution more balanced. This not only efficiently improves the accuracy of inventory replenishment in the supply chain scenario and meets the replenishment needs of each warehouse, but also solves the problem that the total warehouse inventory is too low to accept orders and deliver goods normally.

[0114] It should be noted that the specific limitations of the warehouse replenishment optimization device can be found in the limitations of the warehouse replenishment optimization method mentioned above, and will not be repeated here. Each module in the aforementioned warehouse replenishment optimization device can be implemented entirely or partially through software, hardware, or a combination thereof. These modules can be embedded in the processor of the electronic device in hardware form or independently of it, or stored in the memory of the electronic device in software form, so that the processor can call and execute the corresponding operations of each module.

[0115] In one embodiment, the warehouse replenishment optimization device 400 can be implemented as a computer program, which can be configured as follows: Figure 5 The computer device shown runs on this device. The computer device's memory can store the various program modules that make up the warehouse replenishment optimization device 400, for example, Figure 4 The sales volume acquisition module 410, ratio determination module 420, ratio optimization module 430, and inventory acquisition module 440 shown; the computer program composed of each program module causes the processor to execute the steps in the warehouse replenishment optimization method of the various embodiments of this application described in this specification. For example, Figure 5 The computer equipment shown can be used as follows Figure 4 The sales volume acquisition module 410 in the illustrated warehouse replenishment optimization device 400 executes step S201. The computer device can execute step S202 via the ratio determination module 420. The computer device can execute step S203 via the ratio optimization module 430. The computer device can execute step S204 via the quantity acquisition module 440. The computer device includes a processor, memory, and a network interface connected via a system bus. The processor provides computing and control capabilities. The memory includes a non-volatile storage medium and internal memory. The non-volatile storage medium stores the operating system and computer programs. The internal memory provides an environment for the operation of the operating system and computer programs in the non-volatile storage medium. The network interface of the computer device is used for communication with external computer devices via a network connection. When the computer program is executed by the processor, it implements a warehouse replenishment optimization method.

[0116] Those skilled in the art will understand that Figure 5 The structure shown is merely a block diagram of a portion of the structure related to the present application and does not constitute a limitation on the computer device to which the present application is applied. Specific computer devices may include more or fewer components than those shown in the figure, or combine certain components, or have different component arrangements.

[0117] In some embodiments of this application, a computer device is provided, including one or more processors; a memory; and one or more application programs, wherein the one or more application programs are stored in the memory and configured to be executed by the processors as described in the warehouse replenishment optimization method. The steps of the warehouse replenishment optimization method described here may be steps from the warehouse replenishment optimization methods of the various embodiments described above.

[0118] In some embodiments of this application, a computer-readable storage medium is provided, storing a computer program that is loaded by a processor, causing the processor to execute the steps of the aforementioned warehouse replenishment optimization method. The steps of this warehouse replenishment optimization method may be those found in the warehouse replenishment optimization methods of the various embodiments described above.

[0119] Those skilled in the art will understand that all or part of the processes in the above embodiments can be implemented by a computer program instructing related hardware. The computer program can be stored in a non-volatile computer-readable storage medium, and when executed, it can include the processes of the embodiments of the above methods. Any references to memory, storage, databases, or other media used in the embodiments provided in this application can include at least one of non-volatile and volatile memory. Non-volatile memory can include read-only memory (ROM), magnetic tape, floppy disk, flash memory, or optical storage, etc. Volatile memory can include random access memory (RAM) or external cache memory. By way of illustration and not limitation, RAM can be in various forms, such as static random access memory (SRAM) or dynamic random access memory (DRAM), etc.

[0120] The technical features of the above embodiments can be combined in any way. For the sake of brevity, not all possible combinations of the technical features in the above embodiments are described. However, as long as there is no contradiction in the combination of these technical features, they should be considered to be within the scope of this specification.

[0121] The above provides a detailed description of a warehouse replenishment optimization method, apparatus, computer equipment, and storage medium provided in the embodiments of this application. Specific examples have been used to illustrate the principles and implementation methods of the present invention. The description of the above embodiments is only for the purpose of helping to understand the method and core ideas of the present invention. At the same time, for those skilled in the art, there will be changes in the specific implementation methods and application scope based on the ideas of the present invention. Therefore, the content of this specification should not be construed as a limitation of the present invention.

Claims

1. A method for optimizing warehouse replenishment, characterized in that, include: Obtain sales forecast information for at least two warehouses over a future period of time; wherein, the at least two warehouses include a main warehouse and a branch warehouse, and the main warehouse is used to supply goods to the branch warehouses; The sales forecast information is analyzed to determine the theoretical inventory ratio of each warehouse, thereby obtaining the first theoretical inventory ratio of the total warehouse and the second theoretical inventory ratio of the sub-warehouses; Based on the first theoretical inventory ratio and the second theoretical inventory ratio, the optimal inventory ratio for each of the warehouses is determined; Based on the optimal inventory ratio, the theoretical inventory information of each warehouse is analyzed, so as to obtain the target replenishable quantity of the total warehouse for the sub-warehouses according to the theoretical inventory information. Determining the optimal inventory ratio for each warehouse based on the first theoretical inventory ratio and the second theoretical inventory ratio includes: Calculate the sales percentage quantile of each item belonging to the total warehouse to optimize the first theoretical inventory ratio; Based on the optimized first theoretical inventory ratio, the second theoretical inventory ratio is adjusted to obtain the adjusted second theoretical inventory ratio; The optimized first theoretical inventory ratio and the adjusted second theoretical inventory ratio are determined as the optimal inventory ratio.

2. The method as described in claim 1, characterized in that, The step of parsing the sales forecast information to determine the theoretical inventory ratio of each warehouse, obtaining the first theoretical inventory ratio of the total warehouse and the second theoretical inventory ratio of the sub-warehouses, includes: The total sales forecast is obtained by summing the sales forecast information of each warehouse. Calculate the ratio of the sales forecast information of each warehouse to the total sales forecast value to obtain the theoretical inventory ratio of each warehouse; Determine the theoretical inventory ratio of the total warehouse, and use it as the first theoretical inventory ratio; The theoretical inventory ratio of the sub-warehouse is determined as the second theoretical inventory ratio.

3. The method as described in claim 1, characterized in that, The calculation of the sales percentage quantiles of each item belonging to the total warehouse, in order to optimize the first theoretical inventory ratio, includes: Calculate the sales percentage of each item belonging to the total warehouse; Based on the preset target quantile, the target sales percentage value among each of the sales percentage values ​​is determined as the sales percentage quantile. The first theoretical inventory ratio is optimized by replacing the maximum value between the sales percentage quantile and the first theoretical inventory ratio.

4. The method as described in claim 1, characterized in that, The step of adjusting the second theoretical inventory ratio based on the optimized first theoretical inventory ratio to obtain the adjusted second theoretical inventory ratio includes: The second theoretical inventory ratio of the target sub-warehouse is determined, and the sum of the second theoretical inventory ratios of other sub-warehouses excluding the target sub-warehouse is used as the total second theoretical inventory ratio. If the sum of the optimized first theoretical inventory ratio and the second theoretical inventory ratio is 1, it is determined that the proportional relationship between the second theoretical inventory ratio and the total second theoretical inventory ratio remains unchanged, so as to adjust the second theoretical inventory ratio and obtain the adjusted second theoretical inventory ratio.

5. The method as described in claim 1, characterized in that, The step of analyzing the theoretical inventory information of each warehouse based on the optimal inventory ratio, and obtaining the target replenishable quantity of the total warehouse for each sub-warehouse based on the theoretical inventory information, includes: The sum of the actual inventory information of each of the warehouses is obtained to get the total actual inventory. For the main warehouse and the branch warehouses, calculate the product of the sum of the actual inventory and the optimal inventory ratio to obtain the theoretical inventory information for each warehouse; Based on the theoretical inventory information, the target replenishment quantity of the total warehouse for each of the sub-warehouses is obtained.

6. The method as described in claim 1 or 5, characterized in that, The step of obtaining the target replenishable quantity of the total warehouse for the sub-warehouses based on the theoretical inventory information includes: Based on the theoretical inventory information of each warehouse, determine the replenishable quantity of the total warehouse and the required replenishment quantity of each sub-warehouse; If the replenishable quantity of the total warehouse is positive, and the sum of the replenishable quantities of each of the sub-warehouses is less than the replenishable quantity of the total warehouse, then the replenishable quantity ratio of each of the sub-warehouses is obtained. The product of the required replenishment ratio and the replenishable quantity is used to obtain the target replenishable quantity of the total warehouse for the sub-warehouses; wherein, the required replenishment ratio is the ratio between the required replenishment quantity and the total required replenishment quantity, and the total required replenishment quantity is the sum of the required replenishment quantities of each sub-warehouse.

7. The method as described in claim 6, characterized in that, The step of determining the replenishable quantity of the total warehouse and the required replenishment quantity of the sub-warehouses based on the theoretical inventory information of each warehouse includes: The theoretical inventory information of the main warehouse is determined as the first theoretical inventory information, and the theoretical inventory information of the sub-warehouses is determined as the second theoretical inventory information; The difference between the actual inventory information of the total warehouse and the first theoretical inventory information is determined as the replenishable quantity; and When the actual inventory information of the sub-warehouse is less than the second theoretical inventory information, the difference between the second theoretical inventory information and the actual inventory information of the sub-warehouse is determined as the replenishment quantity required.

8. The method as described in claim 6, characterized in that, The step of obtaining the product of the required replenishment ratio and the replenishable quantity to arrive at the target replenishable quantity of the total warehouse for the sub-warehouse includes: The product of the required replenishment ratio and the replenishable quantity is obtained as the candidate replenishable quantity for the corresponding sub-warehouse; If the candidate replenishable quantity is greater than or equal to the required replenishable quantity, then based on the preset replenishable quantity limit, any value between the required replenishable quantity and the candidate replenishable quantity is determined as the target replenishable quantity. If the candidate replenishable quantity is less than the required replenishable quantity, and the candidate replenishable quantity is a positive integer, then the candidate replenishable quantity is determined as the target replenishable quantity.

9. A warehouse replenishment optimization device, characterized in that, include: The sales acquisition module is used to acquire sales forecast information for at least two warehouses over a future period of time; wherein, the at least two warehouses include a main warehouse and a branch warehouse, and the main warehouse is used to supply goods to the branch warehouses; The ratio determination module is used to parse the sales forecast information to determine the theoretical inventory ratio of each warehouse, thereby obtaining the first theoretical inventory ratio of the total warehouse and the second theoretical inventory ratio of the sub-warehouses. The ratio optimization module is used to determine the optimal inventory ratio for each of the warehouses based on the first theoretical inventory ratio and the second theoretical inventory ratio. The inventory acquisition module is used to analyze the theoretical inventory information of each warehouse based on the optimal inventory ratio, so as to obtain the target replenishable inventory of the total warehouse for the sub-warehouses according to the theoretical inventory information. The ratio optimization module is further configured to calculate the sales percentage quantile of each item belonging to the total warehouse to optimize the first theoretical inventory ratio; adjust the second theoretical inventory ratio according to the optimized first theoretical inventory ratio to obtain the adjusted second theoretical inventory ratio; and determine the optimized first theoretical inventory ratio and the adjusted second theoretical inventory ratio as the optimal inventory ratio.

10. A computer device, characterized in that, The computer device includes: One or more processors; The memory; and one or more applications, wherein the one or more applications are stored in the memory and configured to be executed by the processor to implement the warehouse replenishment optimization method according to any one of claims 1 to 8.

11. A computer-readable storage medium, characterized in that, It stores a computer program, which is loaded by a processor to execute the steps of the warehouse replenishment optimization method according to any one of claims 1 to 8.

Citation Information

Patent Citations

  • Article storage information generation method and device

    CN109961247A

  • Commodity warehouse-dividing warehousing method and device, electronic device and computer readable medium

    CN110443533A