Inventory Allocation Method, Device, Computer Equipment and Storage Medium
By calculating the marginal order satisfaction rate of each sub-warehouse and adjusting the replenishment volume, the problem of low order satisfaction rate caused by the lack of data optimization support by inventory managers is solved, and higher order satisfaction rate and lower out-of-stock losses are achieved.
Patent Information
- Application Number
- CN202010972842.9
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- Filing Date
- 2020-09-16
- Publication Date
- 2025-05-27
- Estimated Expiration
- 2040-09-16
AI Technical Summary
In the warehouse network structure of multi-level warehouses, due to the lack of data optimization support by inventory managers, simple proportional allocation logic is usually used to allocate inventory, resulting in reduced order satisfaction rate and higher out-of-stock losses.
By obtaining the initial requested replenishment volume of each sub-warehouse, calculating the marginal order satisfaction rate, filtering out the sub-warehouse with the smallest marginal order satisfaction rate as the target warehouse, and adjusting the requested replenishment volume of the target warehouse according to the preset value until the inventory volume of the total warehouse is met, thereby distributing inventory.
The order satisfaction rate of each sub-warehouse is improved, thereby improving the overall order satisfaction rate and reducing out-of-stock losses.
Smart Images

Figure CN114266515B_ABST
Abstract
Description
Technical Field
[0001] This application relates to the field of logistics technologies, and particularly to an inventory allocation method, apparatus, computer device, and storage medium. Background Art
[0002] In application scenarios involving a warehouse network structure including multiple levels of warehouses, multiple downstream sub-warehouses formulate replenishment plans based on their own facing demands and current inventories, and submit replenishment requests to the upstream main warehouse according to the replenishment plans. However, it often occurs that the total amount of replenishment requests from each downstream sub-warehouse exceeds the current inventory of the upstream main warehouse. Therefore, the upstream inventory management personnel need to allocate the inventory in the upstream main warehouse among each of the downstream sub-warehouses.
[0003] Currently, due to the lack of data optimization support for inventory management personnel, inventory allocation is usually based on a simple proportional allocation logic. However, this allocation method will reduce the order fulfillment rate, resulting in a higher out-of-stock loss. Summary of the Invention
[0004] Based on this, in view of the above technical problems, it is necessary to provide an inventory allocation method, apparatus, computer device, and storage medium that can improve the order fulfillment rate.
[0005] An inventory allocation method, the method comprising:
[0006] Obtain the initial replenishment request quantity of the target item in each sub-warehouse;
[0007] When the sum of the initial replenishment request quantities is greater than the inventory quantity of the target item in the main warehouse, determine the marginal order fulfillment rate of the corresponding sub-warehouse according to the initial replenishment request quantity;
[0008] Screen out the sub-warehouse with the minimum marginal order fulfillment rate from each of the sub-warehouses as the target warehouse;
[0009] Subtract a preset value from the initial replenishment request quantity corresponding to the target warehouse to obtain the target replenishment request quantity;
[0010] When the sum of the target replenishment request quantity of the target warehouse and the initial replenishment request quantities of the remaining sub-warehouses is less than or equal to the inventory quantity, allocate the inventory to each of the sub-warehouses according to the target replenishment request quantity of the target warehouse and the initial replenishment request quantities of the remaining sub-warehouses.
[0011] In one of the embodiments, the method further comprises:
[0012] When the sum of the target replenishment request quantity of the target warehouse and the initial replenishment request quantities of the remaining sub-warehouses is greater than the inventory quantity, use the target replenishment request quantity as the initial replenishment request quantity of the corresponding sub-warehouse, and return to the step of respectively determining the marginal order fulfillment rate of the corresponding sub-warehouse according to the initial replenishment request quantity to continue execution.
[0013] In one embodiment, the method further includes:
[0014] When the sum of the target replenishment request quantity of the target warehouse and the initial replenishment request quantities of the remaining sub-warehouses is greater than the inventory quantity, update the number of cycles;
[0015] When the updated number of cycles is greater than or equal to the cycle number threshold, allocate inventory to each of the sub-warehouses according to the target replenishment request quantity of the target warehouse and the initial replenishment request quantities of the remaining sub-warehouses;
[0016] When the updated number of cycles is less than the cycle number threshold, use the target replenishment request quantity as the initial replenishment request quantity of the corresponding sub-warehouse, and return to the step of respectively determining the marginal order fulfillment rate of the corresponding sub-warehouse according to the initial replenishment request quantity to continue execution.
[0017] In one embodiment, the step of respectively determining the marginal order fulfillment rate of the corresponding sub-warehouse according to the initial replenishment request quantity includes:
[0018] Calculate the initial order fulfillment rate of the corresponding sub-warehouse according to the initial replenishment request quantity respectively;
[0019] Subtract a preset value from each of the initial replenishment request quantities to obtain the corresponding candidate replenishment request quantity;
[0020] Calculate the candidate order fulfillment rate of the corresponding sub-warehouse according to the candidate replenishment request quantity respectively;
[0021] Subtract the initial order fulfillment rate corresponding to each sub-warehouse from the candidate order fulfillment rate to obtain the corresponding marginal order fulfillment rate.
[0022] In one embodiment, the step of obtaining the initial replenishment request quantity of the target item in each sub-warehouse includes:
[0023] Obtain the initial replenishment request quantity, replenishment lead time, daily average demand quantity, daily demand standard deviation and existing inventory quantity of the target item corresponding to each sub-warehouse;
[0024] Use the initial replenishment request quantity or the candidate replenishment request quantity as the replenishment request quantity; use the initial order fulfillment rate or the candidate order fulfillment rate as the order fulfillment rate; calculate the order fulfillment rate of the corresponding sub-warehouse according to the replenishment request quantity respectively, including:
[0025] Calculate the order fulfillment rate of each corresponding sub-warehouse according to the requested replenishment quantity, replenishment lead time, average daily demand, standard deviation of daily demand, and existing inventory of the target item in each sub-warehouse, in accordance with a preset mapping relationship.
[0026] In one embodiment, the steps for determining the preset mapping relationship include:
[0027] Determine the first functional relationship between the requested replenishment quantity, the existing inventory, the average daily demand, the replenishment lead time, and the safety stock;
[0028] Determine the second functional relationship between the standard deviation of daily demand, the replenishment lead time, the standard score corresponding to the order fulfillment rate in the standard normal distribution, and the safety stock;
[0029] Based on the first functional relationship and the second functional relationship, obtain the third functional relationship between the standard score corresponding to the order fulfillment rate in the standard normal distribution, and the requested replenishment quantity, the existing inventory, the average daily demand, the replenishment lead time, and the standard deviation of daily demand;
[0030] Determine the preset mapping relationship according to the standard mapping relationship between the order fulfillment rate and the standard score corresponding to the order fulfillment rate in the standard normal distribution.
[0031] In one embodiment, the step of obtaining the initial requested replenishment quantity of the target item in each sub-warehouse is performed regularly according to a preset cycle.
[0032] An inventory allocation device, the device includes:
[0033] An acquisition module, configured to acquire the initial requested replenishment quantity of the target item in each sub-warehouse;
[0034] A determination module, configured to, when the sum of the initial requested replenishment quantities is greater than the inventory of the target item in the main warehouse, determine the marginal order fulfillment rate of the corresponding sub-warehouse according to the initial requested replenishment quantity;
[0035] A screening module, configured to screen out the sub-warehouse with the smallest marginal order fulfillment rate from each sub-warehouse as the target warehouse;
[0036] An update module, configured to subtract a preset value from the initial requested replenishment quantity corresponding to the target warehouse to obtain the target requested replenishment quantity;
[0037] An allocation module, configured to, when the sum of the target requested replenishment quantity of the target warehouse and the initial requested replenishment quantities of the remaining sub-warehouses is less than or equal to the inventory, allocate inventory to each sub-warehouse according to the target requested replenishment quantity of the target warehouse and the initial requested replenishment quantities of the remaining sub-warehouses.
[0038] A computer device includes a memory and a processor. The memory stores a computer program, and when the processor executes the computer program, the steps in the above-mentioned various embodiments are implemented.
[0039] A computer-readable storage medium stores a computer program, and when the computer program is executed by a processor, the steps in the above-mentioned various embodiments are implemented.
[0040] In the above inventory allocation method, device, computer device, and storage medium, after obtaining the initial requested replenishment quantities of the target item in each sub-warehouse, when the sum of the initial requested replenishment quantities of each sub-warehouse is greater than the inventory quantity of the target item in the main warehouse, it indicates that the inventory quantity of the target item in the main warehouse is insufficient to meet the replenishment requests of each sub-warehouse. Then, the marginal order fulfillment rate of each sub-warehouse is determined according to the initial requested replenishment quantity of each sub-warehouse. The sub-warehouse with the minimum marginal order fulfillment rate among each sub-warehouse is used as the target warehouse. The initial requested replenishment quantity of the target warehouse minus a preset value is used to obtain the target requested replenishment quantity, and the target requested replenishment quantity is used as the current initial requested replenishment quantity of the corresponding sub-warehouse. Then, the sum of the current initial requested replenishment quantities of each sub-warehouse is calculated. When the sum of the current initial requested replenishment quantities of each sub-warehouse is less than or equal to the inventory quantity of the main warehouse, the inventory is allocated to each sub-warehouse according to the current initial requested replenishment quantity and the inventory quantity of each sub-warehouse. In this way, by cyclically adjusting the initial requested replenishment quantity of each sub-warehouse in the way of decreasing marginal order fulfillment rate, and when the inventory quantity of the main warehouse is sufficient to meet the adjusted replenishment requests of each sub-warehouse, the replenishment quantity allocated to each sub-warehouse is determined and allocated according to the determined replenishment quantity, which can improve the order fulfillment rate of each sub-warehouse, thereby improving the overall order fulfillment rate and further reducing the out-of-stock loss. Description of the Drawings
[0041] Figure 1 It is a schematic flowchart of the inventory allocation method in one embodiment;
[0042] Figure 2 It is a schematic flowchart of the inventory allocation method in another embodiment;
[0043] Figure 3 It is a schematic diagram of the principle of the inventory allocation method in one embodiment;
[0044] Figure 4 It is a structural block diagram of the inventory allocation device in one embodiment;
[0045] Figure 5 It is an internal structure diagram of the computer device in one embodiment. Detailed Embodiments
[0046] To make the objectives, technical solutions and advantages of this application more clear and understandable, the following further details this application in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are merely used to explain this application and are not used to limit this application.
[0047] In one embodiment, as Figure 1 shown, a method for inventory allocation is provided. In this embodiment, an example is given where this method is applied to a server. It can be understood that this method can also be applied to a terminal, and can also be applied to a system including a terminal and a server, and is implemented through the interaction between the terminal and the server. In this embodiment, the method includes the following steps:
[0048] Step 102, obtain the initial requested replenishment quantity of the target item in each sub-warehouse.
[0049] The initial requested replenishment quantity refers to the quantity of the target item requested for replenishment when a sub-warehouse initiates a replenishment request to the main warehouse. The initial requested replenishment quantity can be specifically specified by the replenishment request. The target item refers to the item for which replenishment is to be requested. It can be understood that the sub-warehouse corresponds to the main warehouse. The sub-warehouse can be understood as an RDC (regional distribution center), and the main warehouse can be understood as a CDC (Central Distribution Center). The sub-warehouse is the downstream warehouse of the main warehouse. Correspondingly, the main warehouse is the upstream warehouse of the sub-warehouse. The sub-warehouse needs to request replenishment from the main warehouse through a replenishment request.
[0050] Specifically, the server obtains the initial requested replenishment quantity of each sub-warehouse for the target item from the main warehouse. The server can receive the replenishment requests sent by each sub-warehouse for the target item, and obtain the corresponding initial requested replenishment quantity by receiving the received replenishment requests.
[0051] In one embodiment, the server is deployed in the main warehouse, and is used to respond to the replenishment requests of each sub-warehouse, and allocate inventory to each sub-warehouse that initiates a replenishment request based on the inventory of the target item in the main warehouse.
[0052] In one embodiment, when the inventory allocation condition is met, the server obtains the initial requested replenishment quantity corresponding to the target item in each sub-warehouse, and based on the obtained initial requested replenishment quantity, executes the corresponding inventory allocation process according to the inventory allocation method provided in one or more embodiments of this application. Among them, the inventory allocation condition is, for example, receiving an inventory allocation instruction, or reaching a preset duration since the previous trigger of the inventory allocation process. The preset duration is, for example, 1 week.
[0053] In one embodiment, step 102 is executed regularly according to a preset cycle.
[0054] Among them, the preset period refers to the time interval between two adjacent executions of the inventory allocation process, which can be customized according to the actual situation, such as 1 week.
[0055] Specifically, the server dynamically detects the waiting duration since the previous trigger of the inventory allocation process, and compares the detected waiting duration with the preset duration. When the waiting duration is greater than or equal to the preset duration, the current inventory allocation process is triggered, and the initial requested replenishment quantity of the target item in each sub-warehouse within the current preset period is obtained, that is, the initial requested replenishment quantity initiated by each sub-warehouse for the target item within the time range from the previous trigger of the inventory allocation process to the current trigger of the inventory allocation process is obtained.
[0056] In one embodiment, the server regularly obtains the initial requested replenishment quantity of the target item in each sub-warehouse according to the preset period, and regularly executes the inventory allocation process based on the obtained initial requested replenishment quantity. In this way, during each inventory allocation process, the requested replenishment times of the sub-warehouses participating in the inventory allocation are close, and all are within the replenishment lead time interval of the main warehouse. That the requested replenishment time of the sub-warehouse is within the replenishment lead time interval of the main warehouse means that the main warehouse cannot meet the replenishment requests of each sub-warehouse by requesting replenishment externally during this time period.
[0057] Step 104, when the sum of the initial requested replenishment quantities is greater than the inventory quantity of the target item in the main warehouse, determine the marginal order fulfillment rate of the corresponding sub-warehouse according to the initial requested replenishment quantity.
[0058] Among them, the inventory quantity refers to the total quantity of the target item that can be allocated to the sub-warehouse in the main warehouse currently. The marginal order fulfillment rate refers to the change value of the order fulfillment rate corresponding to the allocated replenishment quantity minus the preset value, relative to the order fulfillment rate corresponding to this replenishment quantity, that is, the difference between the order fulfillment rate corresponding to the allocated replenishment quantity and the order fulfillment rate corresponding to this replenishment quantity minus the preset value. The preset value can be customized, such as 1. The marginal order fulfillment rate is used to characterize the degree of influence of the order fulfillment rate on the change of the replenishment quantity. The larger the marginal order fulfillment rate, the greater the degree of influence of the order fulfillment rate on the change of the replenishment quantity. Correspondingly, the smaller the marginal order fulfillment rate, the smaller the degree of influence of the order fulfillment rate on the change of the replenishment quantity. It can be understood that if the allocated replenishment quantity changes, and the difference between the order fulfillment rates corresponding to the replenishment quantities before and after the change is small, it indicates that the order fulfillment rate is less affected by the change in the replenishment quantity. The order fulfillment rate refers to the proportion of the number of orders fulfilled in the total number of orders, that is, the proportion of the satisfied demand quantity of the target item in the total demand quantity. Each order line can be understood as a demand for the target item.
[0059] For example, assume that the allocated replenishment quantity is 100, the preset value is 1, the order fulfillment rate corresponding to the replenishment quantity of 100 is 95%, and the order fulfillment rate corresponding to the replenishment quantity of 99 (99 = 100 - 1) is 90%. Then the marginal order fulfillment rate is 95% - 90% = 5%.
[0060] Specifically, the server sums up the initial requested replenishment quantities of the target item in each sub-warehouse to obtain the corresponding total initial replenishment request. The server obtains the current inventory quantity of the target item in the main warehouse and compares this inventory quantity with the total initial replenishment request. When the total initial replenishment request is greater than the inventory quantity, it indicates that the current inventory quantity of the target item in the main warehouse is insufficient to meet the replenishment requests initiated by each sub-warehouse for this target item. The server then determines the corresponding marginal order fulfillment rate for each sub-warehouse according to the initial requested replenishment quantity of this target item in each sub-warehouse.
[0061] In one embodiment, when the total initial replenishment request is less than or equal to the inventory quantity of the target item in the main warehouse, it indicates that the current inventory quantity of this target item in the main warehouse is sufficient to meet the replenishment requests initiated by each sub-warehouse for this target item. Then, according to the initial requested replenishment quantity of this target item in each sub-warehouse, inventory is allocated to each sub-warehouse.
[0062] In one embodiment, there are multiple sub-warehouses corresponding to the main warehouse. If, during the current inventory allocation process, the initial requested replenishment quantity of the target item in a certain sub-warehouse is 0, it indicates that there is no current replenishment demand for this target item in this sub-warehouse, that is, it indicates that this sub-warehouse does not need to participate in the inventory allocation of this target item in the main warehouse. The server then allocates inventory to each sub-warehouse that currently has a replenishment request for this target item according to the inventory allocation method provided in one or more embodiments of this application.
[0063] In one embodiment, the inventory quantity of the target item in the main warehouse does not include in-transit items. In-transit items refer to the target items that are in transit and have not yet reached the main warehouse.
[0064] Step 106: Screen out the sub-warehouse with the smallest marginal order fulfillment rate from each sub-warehouse as the target warehouse.
[0065] Specifically, after the server obtains the current marginal order fulfillment rate of each sub-warehouse, it compares the marginal order fulfillment rates of each sub-warehouse, screens out the sub-warehouse with the smallest marginal order fulfillment rate from these sub-warehouses according to the comparison result, and determines the screened-out sub-warehouse as the target warehouse.
[0066] For example, assume that there are three sub-warehouses A, B, and C in total. The respective marginal order fulfillment rates of sub-warehouses A, B, and C are 5%, 3%, and 6%. Thus, based on the marginal order fulfillment rate, sub-warehouse B is determined as the target warehouse.
[0067] Step 108: Subtract a preset value from the initial replenishment request quantity corresponding to the target warehouse to obtain the target replenishment request quantity.
[0068] The preset value is a pre-set numerical value, such as 1. Specifically, after the server selects the target warehouse from each sub-warehouse, it subtracts the preset value from the current initial replenishment request quantity of the target item in the target warehouse to obtain the corresponding target replenishment request quantity.
[0069] For example, assume that the current initial replenishment request quantity of the target item in the target warehouse B is 100 and the preset value is 1. Then the target replenishment request quantity corresponding to the target warehouse B is 100 - 1 = 99.
[0070] It can be understood that the target warehouse is the sub-warehouse in which the order fulfillment rate is least affected by the change in the allocated replenishment quantity among all sub-warehouses. Thus, by subtracting the preset value from the initial order fulfillment rate of the target warehouse, the total initial replenishment request quantity is reduced, so as to make the adjusted total initial replenishment request quantity less than or equal to the inventory quantity of the main warehouse through continuous iterative adjustment, and allocate inventory to each sub-warehouse according to the adjusted initial replenishment request quantity for each sub-warehouse.
[0071] Step 110: When the sum of the target replenishment request quantity of the target warehouse and the initial replenishment request quantities of the remaining sub-warehouses is less than or equal to the inventory quantity, allocate inventory to each sub-warehouse according to the target replenishment request quantity of the target warehouse and the initial replenishment request quantities of the remaining sub-warehouses.
[0072] The remaining sub-warehouses refer to the other sub-warehouses except the target warehouse among the sub-warehouses, specifically, it can refer to the other sub-warehouses except the target warehouse among the sub-warehouses that currently have replenishment requirements for the target item. For example, among sub-warehouses A, B, and C, if sub-warehouse B is determined as the target warehouse based on the marginal order fulfillment rate, then sub-warehouses A and C can be referred to as the remaining sub-warehouses or other sub-warehouses relative to the target warehouse B.
[0073] Specifically, the server sums up the current target replenishment request quantity corresponding to the target warehouse and the current initial replenishment request quantities corresponding to each remaining sub-warehouse to obtain the adjusted total initial replenishment request, that is, the updated total initial replenishment request, and compares this adjusted total initial replenishment request with the current inventory quantity of the target item in the main warehouse. When it is determined that the adjusted total initial replenishment request is less than or equal to the inventory quantity, it indicates that the current inventory quantity of the target item in the main warehouse is sufficient to meet the adjusted replenishment requirements of each sub-warehouse. The server then allocates inventory to each sub-warehouse according to the current target replenishment request quantity corresponding to the target warehouse and the current initial replenishment request quantities corresponding to each remaining sub-warehouse. It can be understood that the target warehouse itself is a sub-warehouse. When the adjusted total initial replenishment request is less than or equal to the inventory quantity, the target replenishment request quantity corresponding to the target warehouse can be determined as the current initial replenishment request quantity corresponding to this sub-warehouse of the target warehouse, and inventory is allocated to each sub-warehouse according to the current initial replenishment request quantities corresponding to each sub-warehouse.
[0074] For example, assume that the initial replenishment request quantities corresponding to sub-warehouses A, B, and C are 80, 100, and 60 respectively, the inventory quantity of the target item in the main warehouse is 239, and the total initial replenishment request is 240. Since the total initial replenishment request of 240 is greater than the inventory quantity of 239, it is necessary to screen the target warehouse from the sub-warehouses and adjust the initial replenishment request quantity of the target warehouse to obtain the corresponding target replenishment request quantity. In this way, the target replenishment request quantity corresponding to target warehouse B can be obtained as 99. At this time, the adjusted total initial replenishment request quantities corresponding to sub-warehouses A, B, and C are 239. Since the adjusted total initial replenishment request is equal to the inventory quantity, the server allocates inventory to each sub-warehouse according to the current initial replenishment request quantities corresponding to each sub-warehouse. Thus, the replenishment quantities allocated to sub-warehouses A, B, and C are 80, 99, and 60 respectively.
[0075] In the above inventory allocation method, after obtaining the initial requested replenishment quantities of the target item in each sub-warehouse, when the sum of the initial requested replenishment quantities of each sub-warehouse is greater than the inventory quantity of the target item in the main warehouse, it indicates that the inventory quantity of the target item in the main warehouse is insufficient to meet the replenishment requests of each sub-warehouse. Then, the marginal order fulfillment rate of each sub-warehouse is determined based on the initial requested replenishment quantity of each sub-warehouse. The sub-warehouse with the minimum marginal order fulfillment rate among each sub-warehouse is used as the target warehouse. The target requested replenishment quantity is obtained by subtracting a preset value from the initial requested replenishment quantity of the target warehouse. The target requested replenishment quantity is used as the current initial requested replenishment quantity of the corresponding sub-warehouse, and the sum of the current initial requested replenishment quantities of each sub-warehouse is calculated. When the sum of the current initial requested replenishment quantities of each sub-warehouse is less than or equal to the inventory quantity of the main warehouse, the inventory is allocated to each sub-warehouse according to the current initial requested replenishment quantity and the inventory quantity of each sub-warehouse. In this way, by cyclically adjusting the initial requested replenishment quantity of each sub-warehouse in the decreasing order of the marginal order fulfillment rate, and when the inventory quantity of the main warehouse is sufficient to meet the replenishment requests of each sub-warehouse after adjustment, the replenishment quantity allocated to each sub-warehouse is determined and allocated according to the determined replenishment quantity, which can improve the order fulfillment rate of each sub-warehouse, thereby improving the overall order fulfillment rate and further reducing the shortage loss.
[0076] In one embodiment, the above inventory allocation method further includes: when the sum of the target requested replenishment quantity of the target warehouse and the initial requested replenishment quantities of the remaining sub-warehouses is greater than the inventory quantity, the target requested replenishment quantity is used as the initial requested replenishment quantity of the corresponding sub-warehouse, and the process returns to the step of determining the marginal order fulfillment rate of the corresponding sub-warehouse according to the initial requested replenishment quantity and continues to execute.
[0077] Specifically, when it is determined that the total amount of the adjusted initial replenishment requests is greater than the inventory of the target item in the main warehouse, it indicates that the current inventory of the target item in the main warehouse is still insufficient to meet the adjusted replenishment requirements in each sub-warehouse. Then the server takes the target requested replenishment quantity corresponding to the target warehouse as the current initial requested replenishment quantity corresponding to this sub-warehouse of the target warehouse. Further, based on the current initial requested replenishment quantities corresponding to each sub-warehouse, the server calculates the marginal order fulfillment rate corresponding to each sub-warehouse respectively according to the marginal order fulfillment rate provided in one or more embodiments of this application, and takes the sub-warehouse with the minimum marginal order fulfillment rate corresponding to the current in each sub-warehouse as the target warehouse. The server subtracts a preset value from the current initial requested replenishment quantity corresponding to the target warehouse to obtain the corresponding target requested replenishment quantity. When the sum of the target requested replenishment quantity of the target warehouse and the current initial requested replenishment quantities of the remaining sub-warehouses is less than or equal to the inventory of the target item in the main warehouse, the inventory is allocated to each sub-warehouse according to the current initial requested replenishment quantity corresponding to each sub-warehouse. Otherwise, the corresponding marginal order fulfillment rates are determined respectively according to the current initial requested replenishment quantities of each sub-warehouse, and so on, until the constraint condition that the sum of the current initial requested replenishment quantities corresponding to each sub-warehouse is less than or equal to the inventory of the target item in the main warehouse is satisfied, then the iteration stops, and the inventory is allocated to each sub-warehouse according to the current initial requested replenishment quantity corresponding to each sub-warehouse.
[0078] In the above embodiment, taking the sum of the current initial requested replenishment quantities corresponding to each sub-warehouse being less than or equal to the inventory of the target item in the main warehouse as the constraint condition, the initial requested replenishment quantities of each sub-warehouse are cyclically reduced in a decreasing manner of the marginal order fulfillment rate until the iteration stops when the constraint condition is satisfied, and the inventory is allocated to each sub-warehouse according to the current initial requested replenishment quantity corresponding to each sub-warehouse when the constraint condition is satisfied. Inventory allocation is performed according to this inventory allocation method, which can maximize the sum of the order fulfillment rates of each sub-warehouse, that is, can maximize the total order fulfillment rate corresponding to the sub-warehouse, thereby reducing the sales loss caused by out-of-stock losses.
[0079] In one embodiment, the above inventory allocation method further includes: when the sum of the target requested replenishment quantity of the target warehouse and the initial requested replenishment quantities of the remaining sub-warehouses is greater than the inventory, update the number of cycles; when the updated number of cycles is greater than or equal to the cycle number threshold, allocate the inventory to each sub-warehouse according to the target requested replenishment quantity of the target warehouse and the initial requested replenishment quantities of the remaining sub-warehouses; when the updated number of cycles is less than the cycle number threshold, take the target requested replenishment quantity as the initial requested replenishment quantity of the corresponding sub-warehouse, and return to the step of respectively determining the marginal order fulfillment rate of the corresponding sub-warehouse according to the initial requested replenishment quantity to continue execution.
[0080] Among them, the number of cycles refers to the number of times of cyclically adjusting the initial requested replenishment quantity of the sub-warehouses. The cycle number threshold is a value used to compare with the updated cycle number to determine whether to stop iteration, which can be customized specifically, such as 10 times.
[0081] Specifically, when it is determined that the total initial requested replenishment quantity after adjustment is greater than the inventory quantity of the target item in the main warehouse, the server incrementally updates the current cycle number to obtain the updated cycle number, and compares the updated cycle number with the cycle number threshold. When it is determined that the updated cycle number is greater than or equal to the cycle number threshold, the server uses the target requested replenishment quantity of the target warehouse as the current corresponding initial requested replenishment quantity of this sub-warehouse of the target warehouse, and distributes the inventory according to the current corresponding initial requested replenishment quantities of each sub-warehouse. When it is determined that the updated cycle number is less than the cycle number threshold, the server uses the target requested replenishment quantity of the target warehouse as the current corresponding initial requested replenishment quantity of this sub-warehouse of the target warehouse, and respectively calculates the current marginal order fulfillment rate of each sub-warehouse according to the current corresponding initial requested replenishment quantity of each sub-warehouse, and continues to execute the above-related operations based on each marginal order fulfillment rate. It can be understood that the server incrementally updates the current cycle number, which means adding 1 to the current cycle number to obtain the updated cycle number.
[0082] In one embodiment, when the sum of the current corresponding initial requested replenishment quantities of each sub-warehouse is greater than the inventory quantity of the main warehouse and the updated cycle number is greater than or equal to the cycle number threshold, the server distributes the inventory quantity in the main warehouse to each sub-warehouse according to the ratio between the current corresponding initial requested replenishment quantities of each sub-warehouse to achieve the distribution of the inventory quantity.
[0083] In the above embodiment, the constraint condition that the sum of the current corresponding initial requested replenishment quantities of each sub-warehouse is less than or equal to the inventory quantity of the main warehouse is used as the first stop condition for the loop iteration, and the cycle number being greater than or equal to the cycle number threshold is used as the second stop condition. When either the first stop condition or the second stop condition is satisfied, the iteration is stopped to avoid infinite loop waiting, and the inventory distribution efficiency can be improved while ensuring a relatively large total order fulfillment rate.
[0084] In one embodiment, determining the marginal order fulfillment rate of the corresponding sub-warehouse according to the initial requested replenishment quantity includes: calculating the initial order fulfillment rate of the corresponding sub-warehouse according to the initial requested replenishment quantity; subtracting a preset value from each initial requested replenishment quantity to obtain the corresponding candidate requested replenishment quantity; calculating the candidate order fulfillment rate of the corresponding sub-warehouse according to the candidate requested replenishment quantity; and subtracting the initial order fulfillment rate corresponding to each sub-warehouse from the candidate order fulfillment rate to obtain the corresponding marginal order fulfillment rate.
[0085] Specifically, for each sub-warehouse, the server calculates the corresponding initial order fulfillment rate based on the current initial requested replenishment quantity of the sub-warehouse, subtracts a preset value from the initial requested replenishment quantity to obtain the corresponding candidate requested replenishment quantity, calculates the corresponding candidate order fulfillment rate based on the candidate requested replenishment quantity, and then subtracts the candidate order fulfillment rate from the initial order fulfillment rate to obtain the corresponding marginal order fulfillment rate.
[0086] In one embodiment, when determining the marginal order fulfillment rates of each sub-warehouse, the server subtracts the preset value from the current initial requested replenishment quantity of each sub-warehouse respectively to obtain the corresponding candidate requested replenishment quantity, so as to calculate the corresponding candidate order fulfillment rate based on the candidate requested replenishment quantity, and then obtain the corresponding marginal order fulfillment rate based on the initial order fulfillment rate and the candidate order fulfillment rate. After screening out the target warehouse from each sub-warehouse based on the marginal order fulfillment rate, the server subtracts the preset value from the current initial requested replenishment quantity of the target warehouse to obtain the corresponding target requested replenishment quantity, so as to perform subsequent operations based on the target requested replenishment quantity. It can be understood that for the target warehouse, the candidate requested replenishment quantity obtained by subtracting the preset value from the initial requested replenishment quantity is the same as the target requested replenishment quantity obtained by subtracting the preset value from the initial requested replenishment quantity.
[0087] In one embodiment, the server calculates the corresponding initial order fulfillment rate according to the current initial requested replenishment quantity of the sub-warehouse according to the preset mapping relationship, and calculates the corresponding candidate order fulfillment rate according to the current candidate requested replenishment quantity of the sub-warehouse according to the preset mapping relationship. The preset mapping relationship is used to represent the mapping relationship between the requested replenishment quantity and the order fulfillment rate.
[0088] In the above embodiment, the initial order fulfillment rate and the candidate order fulfillment rate are calculated respectively according to the initial requested replenishment quantity and the preset value, and the corresponding marginal order fulfillment rate is calculated based on the initial order fulfillment rate and the candidate order fulfillment rate, so as to determine the degree of influence of the change in the allocated replenishment quantity on the order fulfillment rate in the corresponding sub-warehouse based on the marginal order fulfillment rates of each sub-warehouse.
[0089] In one embodiment, step 102 includes: obtaining the initial requested replenishment quantity, replenishment lead time, daily average demand, daily demand standard deviation, and existing inventory quantity of the target item in each sub-warehouse; using the initial requested replenishment quantity or the candidate requested replenishment quantity as the requested replenishment quantity; using the initial order fulfillment rate or the candidate order fulfillment rate as the order fulfillment rate; calculating the order fulfillment rate of the corresponding sub-warehouse according to the requested replenishment quantity, including: calculating the order fulfillment rate of the corresponding sub-warehouse according to the requested replenishment quantity, replenishment lead time, daily average demand, daily demand standard deviation, and existing inventory quantity of the target item in each sub-warehouse according to the preset mapping relationship.
[0090] Among them, the replenishment lead time refers to the time interval from when a replenishment request is made for the target item until the allocated target item arrives at the corresponding sub-warehouse, that is, the time period from the replenishment request date to the item arrival date. In this embodiment, the replenishment lead time specifically refers to the time length corresponding to the time period from the replenishment request date to the item arrival date. For example, the date when sub-warehouse A makes a replenishment request for the target item is September 1, 2020, and the date when the allocated target item arrives at sub-warehouse A is September 8, 2020. Then, the replenishment lead time corresponding to sub-warehouse A is from September 1, 2020 to September 8, 2020. Thus, the lead replenishment period is September 8, 2020 - September 1, 2020 = 7 days. The average daily demand refers to the average value of the daily demand of the sub-warehouse, specifically, it can refer to the average value of the daily demand of the downstream warehouse or store of the sub-warehouse. The standard deviation of daily demand refers to the standard deviation of the daily demand of the sub-warehouse, specifically, it can refer to the standard deviation of the daily demand of the downstream warehouse or store of the sub-warehouse. The preset mapping relationship is used to represent the mapping relationship between the requested replenishment quantity, replenishment lead time, average daily demand, standard deviation of daily demand, existing inventory quantity, and order fulfillment rate of the target item in the sub-warehouse.
[0091] Specifically, the server obtains the current initial requested replenishment quantity, replenishment lead time, average daily demand, standard deviation of daily demand, and existing inventory quantity of the target item in each sub-warehouse.
[0092] In one embodiment, the server can parse the replenishment requests sent by each sub-warehouse for the target item to obtain the corresponding initial requested replenishment quantity, replenishment lead time, average daily demand, standard deviation of daily demand, and existing inventory quantity. The server can also parse the replenishment request to obtain the initial requested replenishment quantity, and based on the replenishment request, obtain the corresponding replenishment lead time, average daily demand, standard deviation of daily demand, and existing inventory quantity from each sub-warehouse. Further, when the sum of the current initial requested replenishment quantities of each sub-warehouse is greater than the inventory quantity of the target item in the main warehouse, for each sub-warehouse, the server calculates the corresponding initial order fulfillment rate according to the current initial requested replenishment quantity, replenishment lead time, average daily demand, standard deviation of daily demand, and existing inventory quantity of the sub-warehouse according to the preset mapping relationship, subtracts the preset value from the initial requested replenishment quantity to obtain the candidate requested replenishment quantity, and calculates the corresponding candidate order fulfillment rate of the sub-warehouse according to the candidate requested replenishment quantity, replenishment lead time, average daily demand, standard deviation of daily demand, and existing inventory quantity of the sub-warehouse according to the preset mapping relationship.
[0093] In the above embodiments, for each sub-warehouse, based on the initial requested replenishment quantity, replenishment lead time, daily average demand, daily demand standard deviation, and existing inventory quantity corresponding to the target item in the sub-warehouse, as well as a pre-configured preset value, the initial order fulfillment rate and candidate order fulfillment rate are respectively calculated according to a preset mapping relationship, and then the marginal order fulfillment rate is obtained.
[0094] In one embodiment, the steps for determining the preset mapping relationship include: determining a first functional relationship between the requested replenishment quantity, existing inventory quantity, daily average demand, replenishment lead time, and safety stock quantity; determining a second functional relationship between the daily demand standard deviation, replenishment lead time, standard score corresponding to the order fulfillment rate in the standard normal distribution, and safety stock quantity; obtaining a third functional relationship between the standard score corresponding to the order fulfillment rate in the standard normal distribution and the requested replenishment quantity, existing inventory quantity, daily average demand, replenishment lead time, and daily demand standard deviation according to the first functional relationship and the second functional relationship; and determining the preset mapping relationship according to the standard mapping relationship between the order fulfillment rate and the standard score corresponding to the order fulfillment rate in the standard normal distribution.
[0095] Among them, the safety stock quantity refers to the buffer stock prepared to cope with the uncertain factors of future supply or demand of the target item. The standard score corresponding to the order fulfillment rate in the standard normal distribution refers to the standard score corresponding when the area reaches the order fulfillment rate in the standard normal distribution. This standard normal distribution is obtained by standardizing the normal distribution satisfied by the daily demand of a single sub-warehouse. It can be understood that the demand faced by each sub-warehouse follows a normal distribution, that is, the daily demand of each sub-warehouse follows a normal distribution. The daily average demand and daily demand standard deviation are respectively obtained by averaging or calculating the standard deviation of multiple daily demands that follow a normal distribution. After subtracting the daily average demand from each daily demand and then dividing by the daily demand standard deviation, the z-score value (standard score) corresponding to the daily demand is obtained. Thus, from the standard scores corresponding to multiple daily demands that follow a normal distribution, the standard normal distribution corresponding to this normal distribution can be obtained.
[0096] Specifically, based on the definition of the requested replenishment quantity, the server reversely determines the first functional relationship among the requested replenishment quantity, the existing inventory quantity, the daily average demand quantity, the replenishment lead time, and the safety stock quantity. That is, the safety stock quantity is characterized by the first functional relationship, as well as the relationship among the requested replenishment quantity, the existing inventory quantity, the daily average demand quantity, and the replenishment lead time. The server determines the second functional relationship between the standard score corresponding to the daily demand standard deviation, the replenishment lead time, and the order fulfillment rate in the standard normal distribution, and the safety stock quantity based on the definition of the safety stock quantity of the target item in the sub-warehouse. Further, based on the first functional relationship and the second functional relationship, the server determines the third functional relationship between the standard score corresponding to the order fulfillment rate in the standard normal distribution, and the requested replenishment quantity, the existing inventory quantity, the daily average demand quantity, the replenishment lead time, and the daily demand standard deviation. Then, based on the standard mapping relationship between the order fulfillment rate and the standard score corresponding to the order fulfillment rate in the standard normal distribution, the server determines the preset mapping relationship among the requested replenishment quantity, the replenishment lead time, the daily average demand quantity, the daily demand standard deviation, the existing inventory quantity, and the order fulfillment rate.
[0097] In one embodiment, based on the definition of the requested replenishment quantity, it can be known that the requested replenishment quantity = daily average demand quantity * replenishment lead time + safety stock quantity - existing inventory quantity, that is, R i = D i l i + SS i - S i , thus, the first functional relationship can be reversely calculated as: SS i = S i + R i - D i l i . Assuming that the daily demand of each sub-warehouse follows a normal distribution, the second functional relationship between the safety stock quantity and the standard score corresponding to the daily demand standard deviation, the replenishment lead time, and the order fulfillment rate in the standard normal distribution is: It can be understood that the safety stock quantity can be calculated based on both the first functional relationship and the second functional relationship. Thus, the functional relationship Based on this functional relationship, the third functional relationship between the standard score corresponding to the order fulfillment rate in the standard normal distribution, and the requested replenishment quantity, the existing inventory quantity, the daily average demand quantity, the replenishment lead time, and the daily demand standard deviation can be obtained, which is
[0098] Further, denoting the probability density function of the normal distribution as f, based on the standard mapping relationship between the order fulfillment rate and the standard score corresponding to the order fulfillment rate in the standard normal distribution, the preset mapping relationship between the standard score corresponding to the order fulfillment rate in the standard normal distribution and the order fulfillment rate is reversely calculated as That is, the preset mapping relationship obtained by reverse calculation among the replenishment request quantity, replenishment lead time, average daily demand, standard deviation of daily demand, existing inventory, and order fulfillment rate is where i (i = 1, 2,... n) represents the i-th sub-warehouse, n represents the number of sub-warehouses, l i represents the replenishment lead time, D i represents the average daily demand, SS i represents the safety stock, σ i represents the standard deviation of daily demand, S i represents the existing inventory, R i represents the replenishment request quantity.
[0099] In the process of circularly adjusting the initial replenishment request quantity of each sub-warehouse, x i can be used to represent the current corresponding initial replenishment request quantity of the i-th sub-warehouse. Thus, the constraint condition that the current corresponding initial replenishment request quantity of each sub-warehouse is less than or equal to the inventory in the main warehouse can be expressed as ∑ i x i ≤ S, where S represents the inventory of the target item in the main warehouse. In this way, when the iteration stops, x i is used to represent the replenishment quantity allocated to the i-th sub-warehouse, that is, the inventory is allocated according to the x i corresponding to each sub-warehouse.
[0100] It can be understood that in the process of circularly adjusting the initial replenishment request quantity of each sub-warehouse, the marginal order fulfillment rate corresponding to the i-th sub-warehouse can be expressed as Δα i = α i (x i ) - α i (x i - 1), and is calculated through the mapping relationship , where Δα i represents the marginal order fulfillment rate, α i (x i )α i (x i ) represents the initial order fulfillment rate corresponding to the current initial replenishment request quantity, and α i (x i - 1) represents the candidate order fulfillment rate corresponding to the candidate replenishment request quantity. The preset mapping relationships corresponding to each sub-warehouse are the same. Since when calculating the corresponding order fulfillment rates for each sub-warehouse, the values of each parameter in the preset mapping relationship are different, therefore, it is necessary to calculate the marginal order fulfillment rates corresponding to each sub-warehouse respectively according to the parameter values corresponding to each parameter in the preset mapping relationship under each sub-warehouse according to the preset mapping relationship.
[0101] In the above embodiments, based on the first functional relationship and the second functional relationship corresponding to the safety inventory, and the standard mapping relationship between the order fulfillment rate and the standard score corresponding to the order fulfillment rate in the standard normal distribution, a preset mapping relationship between the requested replenishment quantity, the replenishment lead time, the daily average demand, the daily demand standard deviation, the existing inventory quantity, and the order fulfillment rate is determined, so as to quickly and accurately calculate the corresponding order fulfillment rate according to the requested replenishment quantity, the replenishment lead time, the daily average demand, the daily demand standard deviation, and the existing inventory quantity of the target item in each sub-warehouse according to the preset mapping relationship.
[0102] As Figure 2 shown, a method for inventory allocation is provided, and the method specifically includes the following steps:
[0103] Step 202, obtain the initial requested replenishment quantity, the replenishment lead time, the daily average demand, the daily demand standard deviation, and the existing inventory quantity of the target item corresponding to each sub-warehouse.
[0104] Step 204, when the sum of the initial requested replenishment quantities is greater than the inventory quantity of the target item in the main warehouse, calculate the initial order fulfillment rate of the corresponding sub-warehouse according to the initial requested replenishment quantity, the replenishment lead time, the daily average demand, the daily demand standard deviation, and the existing inventory quantity of the target item in each sub-warehouse according to the preset mapping relationship.
[0105] Step 206, subtract a preset value from each initial requested replenishment quantity to obtain the corresponding candidate requested replenishment quantity.
[0106] Step 208, calculate the candidate order fulfillment rate of the corresponding sub-warehouse according to the candidate requested replenishment quantity, the replenishment lead time, the daily average demand, the daily demand standard deviation, and the existing inventory quantity of the target item in each sub-warehouse according to the preset mapping relationship.
[0107] Step 210, subtract the initial order fulfillment rate of each sub-warehouse from the candidate order fulfillment rate to obtain the corresponding marginal order fulfillment rate.
[0108] Step 212, screen out the sub-warehouse with the smallest marginal order fulfillment rate from each sub-warehouse as the target warehouse.
[0109] Step 214, subtract a preset value from the initial requested replenishment quantity of the target warehouse to obtain the target requested replenishment quantity.
[0110] Step 216, when the sum of the target requested replenishment quantity of the target warehouse and the initial requested replenishment quantities of the remaining sub-warehouses is less than or equal to the inventory quantity, allocate the inventory to each sub-warehouse according to the target requested replenishment quantity of the target warehouse and the initial requested replenishment quantities of the remaining sub-warehouses.
[0111] Step 218: When the sum of the target replenishment request quantity of the target warehouse and the initial replenishment request quantities of the remaining sub-warehouses is greater than the inventory quantity, update the number of cycles.
[0112] Step 220: When the updated number of cycles is greater than or equal to the cycle number threshold, allocate the inventory to each sub-warehouse according to the target replenishment request quantity of the target warehouse and the initial replenishment request quantities of the remaining sub-warehouses.
[0113] Step 222: When the updated number of cycles is less than the cycle number threshold, use the target replenishment request quantity as the initial replenishment request quantity of the corresponding sub-warehouse, and return to Step 204 to continue execution.
[0114] In the above embodiments, the constraint condition that the sum of the initially configured initial replenishment request quantities corresponding to each sub-warehouse is less than or equal to the inventory quantity of the target item in the main warehouse is pre-configured as the first stop condition, and the condition that the number of cycles is greater than or equal to the cycle number threshold is set as the second stop condition. Combining the first stop condition and the second stop condition, the initial request quantities of each sub-warehouse are cyclically adjusted until the iteration stops when the first stop condition or the second stop condition is met, and the inventory is allocated to each sub-warehouse according to the initial replenishment request quantity corresponding to each sub-warehouse currently.
[0115] In one embodiment, the inventory allocation method provided in one or more embodiments of the present application is applicable not only to the application scenario where downstream sub-warehouses request replenishment from the upstream main warehouse, but also to the application scenario where each store requests replenishment from a certain upstream main warehouse. Through this inventory allocation method, the inventory allocation problem in the case where the sum of the initial replenishment request quantities of downstream sub-warehouses / stores is greater than the inventory quantity of the target item in the upstream main warehouse when the downstream sub-warehouses / stores request replenishment from the upstream main warehouse is solved, which can effectively improve the overall order fulfillment rate, provide data optimization support for inventory allocation, assist inventory managers in optimizing the replenishment allocation strategy, and reduce out-of-stock / sales losses.
[0116] In one embodiment, a random number is used to verify the effect of the inventory allocation method provided in the present application. The verification result shows that the inventory allocation method based on the marginal order fulfillment rate can increase the overall order fulfillment rate by about 12% compared with the proportional allocation method based on the initial replenishment request quantity, and can significantly reduce out-of-stock / sales losses.
[0117] Figure 3 It is a schematic diagram of the principle of the inventory allocation method in one embodiment. As Figure 3As shown, obtain the initial requested replenishment quantity, replenishment lead time, daily average demand, daily demand standard deviation, and existing inventory quantity of the target item in each sub-warehouse as input data. Determine whether the sum of the initial requested replenishment quantities of the target item in each downstream sub-warehouse is greater than the inventory quantity of the main warehouse based on the input data. When it is determined that the sum of the initial requested replenishment quantities of each sub-warehouse is greater than the inventory quantity of the main warehouse, perform inventory allocation according to the inventory allocation method provided in this application to obtain an inventory allocation result, and output the inventory allocation result as output data.
[0118] It should be understood that although Figure 1-2 each step in the flowchart of Figure 1-2 is shown in sequence according to the indication of the arrow, these steps do not necessarily execute in the order indicated by the arrow. Unless there is a clear description in this article, the execution of these steps has no strict order limit, and these steps can be executed in other orders. Moreover,
[0119] In one embodiment, as Figure 4 shown, an inventory allocation device 400 is provided, including: an acquisition module 401, a determination module 402, a screening module 403, an update module 404, and an allocation module 405, where:
[0120] The acquisition module 401 is used to acquire the initial requested replenishment quantity of the target item in each sub-warehouse;
[0121] The determination module 402 is used to determine the marginal order fulfillment rate of the corresponding sub-warehouse according to the initial requested replenishment quantity when the sum of the initial requested replenishment quantities is greater than the inventory quantity of the target item in the main warehouse;
[0122] The screening module 403 is used to screen the sub-warehouse with the smallest marginal order fulfillment rate from each sub-warehouse as the target warehouse;
[0123] The update module 404 is used to subtract a preset value from the initial requested replenishment quantity corresponding to the target warehouse to obtain the target requested replenishment quantity;
[0124] The allocation module 405 is used to allocate inventory to each sub-warehouse according to the target requested replenishment quantity of the target warehouse and the initial requested replenishment quantities of the remaining sub-warehouses when the sum of the target requested replenishment quantity of the target warehouse and the initial requested replenishment quantities of the remaining sub-warehouses is less than or equal to the inventory quantity.
[0125] In one embodiment, the allocation module 405 is further configured to, when the sum of the target replenishment request quantity of the target warehouse and the initial replenishment request quantities of the remaining sub-warehouses is greater than the inventory quantity, use the target replenishment request quantity as the initial replenishment request quantity of the corresponding sub-warehouse, and determine the marginal order fulfillment rate of the corresponding sub-warehouse according to the initial replenishment request quantity.
[0126] In one embodiment, the allocation module 405 is further configured to update the number of cycles when the sum of the target replenishment request quantity of the target warehouse and the initial replenishment request quantities of the remaining sub-warehouses is greater than the inventory quantity; when the updated number of cycles is greater than or equal to the cycle number threshold, allocate inventory to each sub-warehouse according to the target replenishment request quantity of the target warehouse and the initial replenishment request quantities of the remaining sub-warehouses; when the updated number of cycles is less than the cycle number threshold, use the target replenishment request quantity as the initial replenishment request quantity of the corresponding sub-warehouse, and determine the marginal order fulfillment rate of the corresponding sub-warehouse according to the initial replenishment request quantity.
[0127] In one embodiment, the determination module 402 is further configured to calculate the initial order fulfillment rate of the corresponding sub-warehouse according to the initial replenishment request quantity respectively; subtract a preset value from each initial replenishment request quantity to obtain the corresponding candidate replenishment request quantity; calculate the candidate order fulfillment rate of the corresponding sub-warehouse according to the candidate replenishment request quantity respectively; subtract the candidate order fulfillment rate corresponding to each sub-warehouse from the initial order fulfillment rate to obtain the corresponding marginal order fulfillment rate.
[0128] In one embodiment, the acquisition module 401 is further configured to acquire the initial replenishment request quantity, replenishment lead time, daily average demand quantity, daily demand standard deviation and existing inventory quantity of the target item corresponding to each sub-warehouse; use the initial replenishment request quantity or the candidate replenishment request quantity as the replenishment request quantity; use the initial order fulfillment rate or the candidate order fulfillment rate as the order fulfillment rate; the determination module 402 is further configured to calculate the order fulfillment rate of the corresponding sub-warehouse according to the replenishment request quantity, replenishment lead time, daily average demand quantity, daily demand standard deviation and existing inventory quantity of the target item corresponding to each sub-warehouse according to a preset mapping relationship.
[0129] In one embodiment, the determination module 402 is further configured to determine the first functional relationship between the replenishment request quantity, the existing inventory quantity, the daily average demand quantity, the replenishment lead time and the safety inventory quantity; determine the second functional relationship between the daily demand standard deviation, the replenishment lead time, the standard score corresponding to the order fulfillment rate in the standard normal distribution and the safety inventory quantity; according to the first functional relationship and the second functional relationship, obtain the third functional relationship between the standard score corresponding to the order fulfillment rate in the standard normal distribution and the replenishment request quantity, the existing inventory quantity, the daily average demand quantity, the replenishment lead time and the daily demand standard deviation; determine the preset mapping relationship according to the standard mapping relationship between the order fulfillment rate and the standard score corresponding to the order fulfillment rate in the standard normal distribution.
[0130] In one embodiment, the obtaining module 401 is further configured to regularly obtain the initial requested replenishment quantity of the target item in each sub-warehouse at a preset period.
[0131] For the specific limitations of the inventory allocation device, reference can be made to the limitations of the inventory allocation method in the foregoing text, which will not be elaborated here. Each module in the above inventory allocation device can be implemented in whole or in part by software, hardware, and their combination. The above modules can be embedded in the processor in the computer device in hardware form or be independent of it, or can be stored in the memory in the computer device in software form, so as to facilitate the processor to call and execute the operations corresponding to the above modules.
[0132] In one embodiment, a computer device is provided. The computer device can be a server, and its internal structure diagram can be as Figure 5 shown. The computer device includes a processor, a memory, and a network interface connected through a system bus. Among them, the processor of the computer device is used to provide computing and control capabilities. The memory of the computer device includes a non-volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system, a computer program, and a database. The internal memory provides an environment for the operation of the operating system and the computer program in the non-volatile storage medium. The database of the computer device is used to store the inventory quantity of the target item in the main warehouse. The network interface of the computer device is used to communicate with an external terminal through a network connection. When the computer program is executed by the processor, it implements an inventory allocation method.
[0133] Those skilled in the art can understand that Figure 5 the structure shown in
[0134] is only a block diagram of some structures related to the solution of the present application, and does not constitute a limitation on the computer device to which the solution of the present application is applied. The specific computer device may include more or fewer components than those shown in the figure, or combine some components, or have different component arrangements.
[0135] In one embodiment, when the processor executes the computer program, the following steps are further implemented: when the sum of the target replenishment request quantity of the target warehouse and the initial replenishment request quantities of the remaining sub-warehouses is greater than the inventory quantity, the target replenishment request quantity is used as the initial replenishment request quantity of the corresponding sub-warehouse, and the marginal order fulfillment rate of the corresponding sub-warehouse is determined according to the initial replenishment request quantity.
[0136] In one embodiment, when the processor executes the computer program, the following steps are further implemented: when the sum of the target replenishment request quantity of the target warehouse and the initial replenishment request quantities of the remaining sub-warehouses is greater than the inventory quantity, the number of loop iterations is updated; when the updated number of loop iterations is greater than or equal to the loop iteration threshold, the inventory is allocated to each sub-warehouse according to the target replenishment request quantity of the target warehouse and the initial replenishment request quantities of the remaining sub-warehouses; when the updated number of loop iterations is less than the loop iteration threshold, the target replenishment request quantity is used as the initial replenishment request quantity of the corresponding sub-warehouse, and the marginal order fulfillment rate of the corresponding sub-warehouse is determined according to the initial replenishment request quantity.
[0137] In one embodiment, when the processor executes the computer program, the following steps are further implemented: the initial order fulfillment rate of the corresponding sub-warehouse is calculated respectively according to the initial replenishment request quantity; the preset value is subtracted from each initial replenishment request quantity to obtain the corresponding candidate replenishment request quantity; the candidate order fulfillment rate of the corresponding sub-warehouse is calculated respectively according to the candidate replenishment request quantity; the difference between the initial order fulfillment rate and the candidate order fulfillment rate corresponding to each sub-warehouse is obtained to get the corresponding marginal order fulfillment rate.
[0138] In one embodiment, when the processor executes the computer program, the following steps are further implemented: the initial replenishment request quantity, replenishment lead time, daily average demand quantity, daily demand standard deviation and existing inventory quantity of the target item in each sub-warehouse are obtained; the initial replenishment request quantity or the candidate replenishment request quantity is used as the replenishment request quantity; the initial order fulfillment rate or the candidate order fulfillment rate is used as the order fulfillment rate; according to the replenishment request quantity, replenishment lead time, daily average demand quantity, daily demand standard deviation and existing inventory quantity of the target item in each sub-warehouse, the order fulfillment rate of the corresponding sub-warehouse is calculated according to the preset mapping relationship.
[0139] In one embodiment, when the processor executes the computer program, the following steps are further implemented: determining a first functional relationship between the requested replenishment quantity, the existing inventory quantity, the average daily demand quantity, the replenishment lead time, and the safety stock quantity; determining a second functional relationship between the standard deviation of the daily demand, the replenishment lead time, the standard score corresponding to the order fulfillment rate in the standard normal distribution, and the safety stock quantity; obtaining, according to the first functional relationship and the second functional relationship, a third functional relationship between the standard score corresponding to the order fulfillment rate in the standard normal distribution, and the requested replenishment quantity, the existing inventory quantity, the average daily demand quantity, the replenishment lead time, and the standard deviation of the daily demand; and determining a preset mapping relationship according to the standard mapping relationship between the order fulfillment rate and the standard score corresponding to the order fulfillment rate in the standard normal distribution.
[0140] In one embodiment, when the processor executes the computer program, the following steps are further implemented: regularly obtaining the initial requested replenishment quantity of the target item in each sub-warehouse at a preset period.
[0141] In one embodiment, a computer-readable storage medium is provided, on which a computer program is stored. When the computer program is executed by a processor, the following steps are implemented: obtaining the initial requested replenishment quantity of the target item in each sub-warehouse; when the sum of the initial requested replenishment quantities is greater than the inventory quantity of the target item in the main warehouse, determining the marginal order fulfillment rate of the corresponding sub-warehouse according to the initial requested replenishment quantity; screening out the sub-warehouse with the minimum marginal order fulfillment rate from each sub-warehouse as the target warehouse; subtracting a preset value from the initial requested replenishment quantity corresponding to the target warehouse to obtain the target requested replenishment quantity; and when the sum of the target requested replenishment quantity of the target warehouse and the initial requested replenishment quantities of the remaining sub-warehouses is less than or equal to the inventory quantity, allocating the inventory to each sub-warehouse according to the target requested replenishment quantity of the target warehouse and the initial requested replenishment quantities of the remaining sub-warehouses.
[0142] In one embodiment, when the computer program is executed by the processor, the following steps are further implemented: when the sum of the target requested replenishment quantity of the target warehouse and the initial requested replenishment quantities of the remaining sub-warehouses is greater than the inventory quantity, using the target requested replenishment quantity as the initial requested replenishment quantity of the corresponding sub-warehouse, and determining the marginal order fulfillment rate of the corresponding sub-warehouse according to the initial requested replenishment quantity.
[0143] In one embodiment, when the computer program is executed by the processor, the following steps are further implemented: when the sum of the target requested replenishment quantity of the target warehouse and the initial requested replenishment quantities of the remaining sub-warehouses is greater than the inventory quantity, updating the number of loop times; when the updated number of loop times is greater than or equal to the loop times threshold, allocating the inventory to each sub-warehouse according to the target requested replenishment quantity of the target warehouse and the initial requested replenishment quantities of the remaining sub-warehouses; and when the updated number of loop times is less than the loop times threshold, using the target requested replenishment quantity as the initial requested replenishment quantity of the corresponding sub-warehouse, and determining the marginal order fulfillment rate of the corresponding sub-warehouse according to the initial requested replenishment quantity.
[0144] In one embodiment, when the computer program is executed by a processor, the following steps are further implemented: calculating the initial order fulfillment rate of the corresponding sub-warehouses according to the initial requested replenishment quantities respectively; subtracting a preset value from each of the initial requested replenishment quantities to obtain the corresponding candidate requested replenishment quantities; calculating the candidate order fulfillment rate of the corresponding sub-warehouses according to the candidate requested replenishment quantities respectively; subtracting the initial order fulfillment rate corresponding to each sub-warehouse from the candidate order fulfillment rate to obtain the corresponding marginal order fulfillment rate.
[0145] In one embodiment, when the computer program is executed by a processor, the following steps are further implemented: obtaining the initial requested replenishment quantity, replenishment lead time, daily average demand, daily demand standard deviation, and existing inventory quantity of the target item in each sub-warehouse; using the initial requested replenishment quantity or the candidate requested replenishment quantity as the requested replenishment quantity; using the initial order fulfillment rate or the candidate order fulfillment rate as the order fulfillment rate; calculating the order fulfillment rate of the corresponding sub-warehouse according to the requested replenishment quantity, replenishment lead time, daily average demand, daily demand standard deviation, and existing inventory quantity of the target item in each sub-warehouse according to a preset mapping relationship.
[0146] In one embodiment, when the computer program is executed by a processor, the following steps are further implemented: determining a first functional relationship between the requested replenishment quantity, existing inventory quantity, daily average demand, replenishment lead time, and safety inventory quantity; determining a second functional relationship between the daily demand standard deviation, replenishment lead time, standard score corresponding to the order fulfillment rate in the standard normal distribution, and safety inventory quantity; obtaining a third functional relationship between the standard score corresponding to the order fulfillment rate in the standard normal distribution, and the requested replenishment quantity, existing inventory quantity, daily average demand, replenishment lead time, and daily demand standard deviation according to the first functional relationship and the second functional relationship; determining the preset mapping relationship according to the standard mapping relationship between the order fulfillment rate and the standard score corresponding to the order fulfillment rate in the standard normal distribution.
[0147] In one embodiment, when the computer program is executed by a processor, the following steps are further implemented: regularly obtaining the initial requested replenishment quantity of the target item in each sub-warehouse at a preset period.
[0148] Those of ordinary skill in the art can understand that all or part of the processes in the methods of the above embodiments can be completed by instructing relevant hardware through a computer program. The computer program can be stored in a non-volatile computer-readable storage medium. When the computer program is executed, it can include the processes of the embodiments of the above various methods. Among them, any reference to a memory, storage, database, or other medium used in the various embodiments provided in the present application can include at least one of non-volatile and volatile memories. Non-volatile memory can include read-only memory (ROM), magnetic tape, floppy disk, flash memory, or optical memory, 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.
[0149] The technical features of the above embodiments can be combined arbitrarily. For the sake of concise description, 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, it should be considered as the scope described in this specification.
[0150] The above embodiments only represent several implementation manners of the present application. The description is relatively specific and detailed, but it should not be construed as a limitation on the scope of the invention patent. It should be noted that for those of ordinary skill in the art, without departing from the concept of the present application, several modifications and improvements can still be made, and these all belong to the protection scope of the present application. Therefore, the protection scope of the patent of the present application should be subject to the appended claims.
Claims
1. An inventory allocation method, characterized in that, the method includes: Obtaining the initial requested replenishment quantity of the target item in each sub-warehouse; When the sum of the initial requested replenishment quantities is greater than the inventory quantity of the target item in the main warehouse, determining the marginal order fulfillment rate of the corresponding sub-warehouse according to the initial requested replenishment quantity, where the marginal order fulfillment rate is the change value of the order fulfillment rate corresponding to the replenishment quantity allocated to the sub-warehouse minus the preset value, relative to the order fulfillment rate corresponding to the allocated replenishment quantity; Selecting the sub-warehouse with the smallest marginal order fulfillment rate from each of the sub-warehouses as the target warehouse; Subtracting the preset value from the initial requested replenishment quantity corresponding to the target warehouse to obtain the target requested replenishment quantity; When the sum of the target requested replenishment quantity of the target warehouse and the initial requested replenishment quantities of the remaining sub-warehouses is greater than the inventory quantity, taking the target requested replenishment quantity as the initial requested replenishment quantity of the corresponding sub-warehouse, and returning to the step of determining the marginal order fulfillment rate of the corresponding sub-warehouse according to the initial requested replenishment quantity to continue execution; When the sum of the target requested replenishment quantity of the target warehouse and the initial requested replenishment quantities of the remaining sub-warehouses is less than or equal to the inventory quantity, allocating inventory to each of the sub-warehouses according to the target requested replenishment quantity of the target warehouse and the initial requested replenishment quantities of the remaining sub-warehouses.
2. The method according to claim 1, characterized in that, the method further includes: When the sum of the target requested replenishment quantity of the target warehouse and the initial requested replenishment quantities of the remaining sub-warehouses is greater than the inventory quantity, updating the number of cycles; When the updated number of cycles is greater than or equal to the cycle number threshold, allocating inventory to each of the sub-warehouses according to the target requested replenishment quantity of the target warehouse and the initial requested replenishment quantities of the remaining sub-warehouses; When the updated number of cycles is less than the cycle number threshold, taking the target requested replenishment quantity as the initial requested replenishment quantity of the corresponding sub-warehouse, and returning to the step of determining the marginal order fulfillment rate of the corresponding sub-warehouse according to the initial requested replenishment quantity to continue execution.
3. The method according to claim 1, characterized in that, determining the marginal order fulfillment rate of the corresponding sub-warehouse according to the initial requested replenishment quantity includes: Calculating the initial order fulfillment rate of the corresponding sub-warehouse according to the initial requested replenishment quantity; Subtracting the preset value from each of the initial requested replenishment quantities to obtain the corresponding candidate requested replenishment quantity; Calculating the candidate order fulfillment rate of the corresponding sub-warehouse according to the candidate requested replenishment quantity; Subtracting the initial order fulfillment rate corresponding to each of the sub-warehouses from the candidate order fulfillment rate to obtain the corresponding marginal order fulfillment rate.
4. The method according to claim 3, characterized in that, obtaining the initial requested replenishment quantity of the target item in each sub-warehouse includes: Obtaining the initial requested replenishment quantity, replenishment lead time, daily average demand, daily demand standard deviation and existing inventory quantity corresponding to the target item in each sub-warehouse; Use the initial requested replenishment quantity or the candidate requested replenishment quantity as the requested replenishment quantity; use the initial order fulfillment rate or the candidate order fulfillment rate as the order fulfillment rate; calculate the order fulfillment rate of the corresponding sub-warehouses according to the requested replenishment quantity, including: Calculate the order fulfillment rate of the corresponding sub-warehouses according to the requested replenishment quantity, replenishment lead time, average daily demand, standard deviation of daily demand, and existing inventory quantity of the target item in each sub-warehouse, according to a preset mapping relationship.
5. The method according to claim 4, wherein, the steps for determining the preset mapping relationship include: Determine the first functional relationship between the requested replenishment quantity, the existing inventory quantity, the average daily demand, the replenishment lead time, and the safety inventory quantity; Determine the second functional relationship between the standard deviation of daily demand, the replenishment lead time, the standard score corresponding to the order fulfillment rate in the standard normal distribution, and the safety inventory quantity; According to the first functional relationship and the second functional relationship, obtain the third functional relationship between the standard score corresponding to the order fulfillment rate in the standard normal distribution, and the requested replenishment quantity, the existing inventory quantity, the average daily demand, the replenishment lead time, and the standard deviation of daily demand; Determine the preset mapping relationship according to the standard mapping relationship between the order fulfillment rate and the standard score corresponding to the order fulfillment rate in the standard normal distribution.
6. The method according to any one of claims 1 to 5, wherein, the step of obtaining the initial requested replenishment quantity of the target item in each sub-warehouse is executed regularly according to a preset cycle.
7. An inventory allocation device, wherein, the device includes: An acquisition module, configured to acquire the initial requested replenishment quantity of the target item in each sub-warehouse; A determination module, configured to, when the sum of the initial requested replenishment quantities is greater than the inventory quantity of the target item in the total warehouse, determine the marginal order fulfillment rate of the corresponding sub-warehouses according to the initial requested replenishment quantities, where the marginal order fulfillment rate is the change value of the order fulfillment rate corresponding to the replenishment quantity allocated to the sub-warehouse minus a preset value, relative to the order fulfillment rate corresponding to the allocated replenishment quantity; A screening module, configured to screen the sub-warehouse with the smallest marginal order fulfillment rate from each of the sub-warehouses as the target warehouse; An update module, configured to subtract a preset value from the initial requested replenishment quantity corresponding to the target warehouse to obtain the target requested replenishment quantity; An allocation module, configured to, when the sum of the target requested replenishment quantity of the target warehouse and the initial requested replenishment quantities of the remaining sub-warehouses is greater than the inventory quantity, use the target requested replenishment quantity as the initial requested replenishment quantity of the corresponding sub-warehouses, and return to the step of determining the marginal order fulfillment rate of the corresponding sub-warehouses according to the initial requested replenishment quantities to continue execution; when the sum of the target requested replenishment quantity of the target warehouse and the initial requested replenishment quantities of the remaining sub-warehouses is less than or equal to the inventory quantity, allocate inventory for each of the sub-warehouses according to the target requested replenishment quantity of the target warehouse and the initial requested replenishment quantities of the remaining sub-warehouses.
8. The device according to claim 7, wherein, the determination module is further configured to: Calculate the initial order fulfillment rate of the corresponding sub-warehouses according to the initial requested replenishment quantity respectively; Subtract the preset value from each of the initial requested replenishment quantities to obtain the corresponding candidate requested replenishment quantities; Calculate the candidate order fulfillment rate of the corresponding sub-warehouses according to the candidate requested replenishment quantities respectively; Subtract the initial order fulfillment rate corresponding to each sub-warehouse from the candidate order fulfillment rate to obtain the corresponding marginal order fulfillment rate.
9. A computer device, comprising a memory and a processor, the memory storing a computer program, wherein, when the processor executes the computer program, the steps of the method according to any one of claims 1 to 6 are implemented.
10. A computer-readable storage medium, having a computer program stored thereon, wherein, when the computer program is executed by a processor, the steps of the method according to any one of claims 1 to 6 are implemented.
Citation Information
Patent Citations
Storage-based standard box goods delivery adjustment method and apparatus
CN107256473A
Inventory allocation method and device
CN108596544A