Store replenishment amount calculation method, apparatus and device, and storage medium

Abstract

The invention discloses a store replenishment amount calculation method and device, equipment and a storage medium. The method comprises the steps that the safety basic replenishment amount and the sales basic replenishment amount of commodities are calculated according to the historical commodity sales amount and the preset stocking day number; solving a safe single-item replenishment amount according to the safe basic replenishment amount through a first replenishment optimization model to obtain a safe replenishment calculation value; updating a sales basic replenishment amount based on the safe replenishment calculation value to obtain an updated basic replenishment amount; a branch and bound method is adopted to solve the sales single-item replenishment amount according to the updated basic replenishment amount through a second replenishment optimization model, a sales replenishment calculation value is obtained, and the constraint condition of the second replenishment optimization model comprises the constraint based on the updated category replenishment amount. The technical problem that the replenishment amount calculation result is lack of accuracy and reliability due to the fact that the influence between different types of commodities is not considered in the prior art and only the analysis of single-item data under a simple condition is focused on can be solved.

Description

Technical Field

[0001] This application relates to the technical field of store operation, and particularly to a method, device, equipment and storage medium for calculating the replenishment quantity of a store. Background Art

[0002] The supply chain replenishment system is the most core business system in the retail industry. If the replenishment quantity of the store can be obtained in a timely and accurate manner, it can provide effective data support for the efficient operation of the industrial chain, thereby improving the working efficiency of the business system in the retail industry.

[0003] At present, there are two ways to calculate the replenishment quantity of a store. One is the prediction calculation method based on the historical sales volume of goods, and the other is the solution method based on the operation research optimization algorithm. However, the former is only suitable for calculation under ideal conditions and has too single consideration factors; while the latter does not consider the display layout of goods during store retail, that is, it does not consider the influence between different categories of goods, so the calculation result lacks reliability. Moreover, both algorithms analyze based on single-category goods, with a large prediction error, resulting in the lack of accuracy in calculating the replenishment quantity. Summary of the Invention

[0004] This application provides a method, device, equipment and storage medium for calculating the replenishment quantity of a store, which is used to solve the technical problem that the prior art does not consider the influence between different types of goods and only focuses on the analysis of single-item data in a simple situation, resulting in the lack of accuracy and reliability in the calculation result of the replenishment quantity.

[0005] In view of this, the first aspect of this application provides a method for calculating the replenishment quantity of a store, including:

[0006] Respectively calculate the safety basic replenishment quantity and the sales basic replenishment quantity of goods according to the historical sales volume of goods and the pre-set replenishment days, and both the safety basic replenishment quantity and the sales basic replenishment quantity include the single-item basic replenishment quantity and the category basic replenishment quantity;

[0007] Solve the safety single-item replenishment quantity according to the safety basic replenishment quantity through the first replenishment optimization model to obtain the safety replenishment calculation value;

[0008] Update the sales basic replenishment quantity based on the safety replenishment calculation value to obtain the updated basic replenishment quantity, and the updated basic replenishment quantity includes the updated single-item replenishment quantity and the updated category replenishment quantity;

[0009] Adopt the branch and bound method to solve the sales single-item replenishment quantity according to the updated basic replenishment quantity through the second replenishment optimization model to obtain the sales replenishment calculation value, and the constraint conditions of the second replenishment optimization model include the constraints based on the updated category replenishment quantity.

[0010] Preferably, calculating the safety-based replenishment quantity and the sales-based replenishment quantity of a product based on the historical sales volume of the product and the planned stock replenishment days respectively includes:

[0011] Using a preset prediction algorithm to predict the single-item sales volume and the category sales volume of the product based on the historical sales volume of the product and the planned stock replenishment days respectively, to obtain a product sales volume prediction value, where the product sales volume prediction value includes a single-item sales volume prediction value and a category sales volume prediction value;

[0012] Calculating the single-item-based replenishment quantity and the category-based replenishment quantity of the product under the condition of meeting the minimum safety stock respectively according to the minimum safety stock and the current product inventory, to obtain the safety-based replenishment quantity;

[0013] Calculating the single-item-based replenishment quantity and the category-based replenishment quantity of the product under the condition of meeting future sales respectively according to the product sales volume prediction value, the minimum safety stock and the current product inventory, to obtain the sales-based replenishment quantity.

[0014] Preferably, calculating the safety-based replenishment quantity and the sales-based replenishment quantity of a product based on the historical sales volume of the product and the planned stock replenishment days respectively further includes:

[0015] If the calculated safety-based replenishment quantity or the sales-based replenishment quantity is less than or equal to 0, then assign a value of 0 to the replenishment quantity of the corresponding product to obtain a zero-value replenishment quantity.

[0016] Preferably, using the branch and bound method to solve for the single-item replenishment quantity of sales according to the updated basic replenishment quantity through a second replenishment optimization model to obtain a sales replenishment calculation value includes:

[0017] Taking the single-item replenishment quantity of each category of product as a variable to construct an objective optimization function, where the objective optimization function aims to maximize the turnover rate;

[0018] Configuring constraint conditions for the objective optimization function according to the updated basic replenishment quantity to obtain updated constraint conditions;

[0019] Combining the objective optimization function and the updated constraint conditions to generate a second replenishment optimization model;

[0020] Using the branch and bound method to solve the second replenishment optimization model to obtain a sales replenishment calculation value.

[0021] Preferably, after using the branch and bound method to solve for the single-item replenishment quantity of sales according to the updated basic replenishment quantity through a second replenishment optimization model to obtain a sales replenishment calculation value, it further includes:

[0022] Integrating the safety replenishment calculation value, the zero-value replenishment quantity and the sales replenishment calculation value to obtain an overall replenishment result.

[0023] The second aspect of the present application provides a store replenishment quantity calculation device, including:

[0024] A gap calculation unit, configured to calculate the safety basic replenishment quantity and the sales basic replenishment quantity of a commodity respectively according to the historical commodity sales volume and the pre-set replenishment days, where both the safety basic replenishment quantity and the sales basic replenishment quantity include the single-item basic replenishment quantity and the category basic replenishment quantity;

[0025] A safety replenishment unit, configured to solve the safety single-item replenishment quantity according to the safety basic replenishment quantity through a first replenishment optimization model to obtain a safety replenishment calculation value;

[0026] A gap update unit, configured to update the sales basic replenishment quantity based on the safety replenishment calculation value to obtain an updated basic replenishment quantity, where the updated basic replenishment quantity includes an updated single-item replenishment quantity and an updated category replenishment quantity;

[0027] A replenishment calculation unit, configured to solve the sales single-item replenishment quantity according to the updated basic replenishment quantity through a second replenishment optimization model by using the branch and bound method to obtain a sales replenishment calculation value, and the constraint conditions of the second replenishment optimization model include constraints based on the updated category replenishment quantity.

[0028] Preferably, the gap calculation unit is specifically configured to:

[0029] Adopt a preset prediction algorithm to predict the single-item sales volume and category sales volume of a commodity respectively according to the historical commodity sales volume and the pre-set replenishment days to obtain a commodity sales volume prediction value, where the commodity sales volume prediction value includes a single-item sales volume prediction value and a category sales volume prediction value;

[0030] Calculate the single-item basic replenishment quantity and the category basic replenishment quantity of a commodity under the condition of meeting the minimum safety inventory respectively according to the minimum safety inventory and the current commodity inventory to obtain the safety basic replenishment quantity;

[0031] Calculate the single-item basic replenishment quantity and the category basic replenishment quantity of a commodity under the condition of meeting future sales respectively according to the commodity sales volume prediction value, the minimum safety inventory and the current commodity inventory to obtain the sales basic replenishment quantity.

[0032] Preferably, the replenishment calculation unit is specifically configured to:

[0033] Take the single-item replenishment quantity of each category of commodity as a variable to construct an objective optimization function, and the objective optimization function aims at maximizing the turnover rate;

[0034] Configure constraint conditions for the objective optimization function according to the updated basic replenishment quantity to obtain updated constraint conditions;

[0035] Generate a second replenishment optimization model by combining the objective optimization function and the updated constraint conditions.

[0036] The branch and bound method is used to solve the second replenishment optimization model, and the calculated value of sales replenishment is obtained.

[0037] A third aspect of the present application provides a store replenishment quantity calculation device, which includes a processor and a memory;

[0038] The memory is used to store program codes and transmit the program codes to the processor;

[0039] The processor is used to execute the store replenishment quantity calculation method described in the first aspect according to the instructions in the program codes.

[0040] A fourth aspect of the present application provides a computer-readable storage medium, which is used to store program codes for executing the store replenishment quantity calculation method described in the first aspect.

[0041] It can be seen from the above technical solutions that the embodiments of the present application have the following advantages:

[0042] In the present application, a store replenishment quantity calculation method is provided, including: calculating the safety basic replenishment quantity and the sales basic replenishment quantity of commodities according to the historical commodity sales volume and the pre-set replenishment days respectively, and both the safety basic replenishment quantity and the sales basic replenishment quantity include the single-item basic replenishment quantity and the category basic replenishment quantity; solving the safety single-item replenishment quantity according to the safety basic replenishment quantity through the first replenishment optimization model to obtain the safety replenishment calculation value; updating the sales basic replenishment quantity based on the safety replenishment calculation value to obtain the updated basic replenishment quantity, and the updated basic replenishment quantity includes the updated single-item replenishment quantity and the updated category replenishment quantity; using the branch and bound method to solve the sales single-item replenishment quantity according to the updated basic replenishment quantity through the second replenishment optimization model to obtain the sales replenishment calculation value, and the constraint conditions of the second replenishment optimization model include the constraints based on the updated category replenishment quantity.

[0043] In the store replenishment quantity calculation method provided by this application, the replenishment quantity calculation process is divided into two stages. In the first stage, the safety replenishment calculation value is calculated based on the safety basic replenishment quantity and the replenishment optimization model. Then, based on this value, the sales basic replenishment quantity is updated, and then the replenishment quantity calculation in the second stage is entered. This process takes into account the differences in the demand for goods at different stages and quantifies them into the specific replenishment quantity calculation process, which is more in line with the actual situation, and the obtained sales replenishment calculation value is also more accurate. In addition, the actual replenishment quantity is calculated by constructing a replenishment optimization model and setting category replenishment quantity constraints, fully considering the impact of the category factors of goods on replenishment, which provides a guarantee for obtaining a more reliable replenishment quantity calculation value. This application can solve the technical problems that the prior art does not consider the influence between different types of goods and only focuses on the analysis of single-item data in simple situations, resulting in the lack of accuracy and reliability of the replenishment quantity calculation results. BRIEF DESCRIPTION OF THE DRAWINGS

[0044] Figure 1 It is a schematic flowchart of a store replenishment quantity calculation method provided by an embodiment of this application;

[0045] Figure 2 It is a schematic structural diagram of a store replenishment quantity calculation device provided by an embodiment of this application. DETAILED DESCRIPTION OF THE EMBODIMENTS

[0046] In order to enable those skilled in the art to better understand the solution of this application, the technical solutions in the embodiments of this application will be clearly and completely described below with reference to the accompanying drawings in the embodiments of this application. Obviously, the described embodiments are only a part of the embodiments of this application, rather than all the embodiments. Based on the embodiments in this application, all other embodiments obtained by those of ordinary skill in the art without creative efforts shall fall within the protection scope of this application.

[0047] For ease of understanding, please refer to Figure 1 , an embodiment of a store replenishment quantity calculation method provided by this application includes:

[0048] Step 101: Calculate the safety basic replenishment quantity and the sales basic replenishment quantity of the goods respectively according to the historical sales volume of the goods and the pre-set stock replenishment days. Both the safety basic replenishment quantity and the sales basic replenishment quantity include the single-item basic replenishment quantity and the category basic replenishment quantity.

[0049] Further, step 101 includes:

[0050] Use a pre-set prediction algorithm to predict the single-item sales volume and category sales volume of the goods respectively according to the historical sales volume of the goods and the pre-set stock replenishment days, and obtain the predicted value of the goods sales volume. The predicted value of the goods sales volume includes the predicted value of the single-item sales volume and the predicted value of the category sales volume;

[0051] Calculate the single - item basic replenishment quantity and the category - based basic replenishment quantity of the commodity under the condition of meeting the minimum safety stock respectively according to the minimum safety stock and the current commodity inventory, and obtain the safety - based basic replenishment quantity;

[0052] Calculate the single - item basic replenishment quantity and the category - based basic replenishment quantity of the commodity under the condition of meeting future sales respectively according to the predicted value of commodity sales, the minimum safety stock and the current commodity inventory, and obtain the sales - based basic replenishment quantity.

[0053] It should be noted that the safety - based basic replenishment quantity and the sales - based basic replenishment quantity in this embodiment are both pre - calculated basic replenishment demand values, which are specifically calculated based on the inventory and sales volume of the store. The sales volume refers to the predicted value of the store's future sales volume, and the sales volume includes the predicted value of the sales volume of a single - type commodity and the predicted value of the sales volume of multi - category commodities. The preset prediction algorithm can be a sales volume prediction algorithm designed based on methods such as machine learning or time series, and can be selected and configured according to the actual situation, which is not limited here. The historical commodity sales volume and the preset stock - preparation days for prediction, the historical commodity sales volume can be obtained from the historical databases of each store, and the stock - preparation days are parameters set considering the stock - preparation frequency of the user's store and the transportation days from the warehouse to the store; based on the above parameters and methods, the predicted value of the single - item sales volume and the predicted value of the category sales volume of the commodity can be predicted, which are respectively expressed as 、 ; among them, represents the commodity number index, represents the store index, is the preset stock - preparation days.

[0054] Analyzing from the business strategy, taking common offline retail as an example, the minimum safety stock needs to be met on the store display board, so there is the concept of the minimum safety stock, which can also be specifically divided into the single - item minimum safety stock and the category - based minimum safety stock, which are respectively expressed as 、 ; that is to say, the minimum safety stock cannot be less on the store display board. In addition, it is also necessary to clarify the current inventory of the single - item and category of the store's commodities, that is, the current commodity inventory, which can also be specifically divided into the current single - item inventory and the current category inventory . Therefore, the safety - single - item basic replenishment quantity and the safety - category basic replenishment quantity included in the safety - based basic replenishment quantity are expressed in the calculation process as:

[0055]

[0056] The basic replenishment quantity for sales, on the premise of meeting the minimum safety inventory requirements of the store, calculates the demand gap when discussing how to meet the future sales demand of the store; the specific basic replenishment quantity for single sales items and the basic replenishment quantity for sales categories The calculation process is expressed as:

[0057]

[0058] Furthermore, step 101 also includes:

[0059] If the calculated basic safety replenishment quantity or the basic replenishment quantity for sales is less than or equal to 0, then assign the replenishment quantity of the corresponding product as 0 to obtain the zero-value replenishment quantity.

[0060] Since the calculation methods of the above basic safety replenishment quantity and the basic replenishment quantity for sales are both subtraction calculations, there are situations where the equations are less than or equal to 0. However, negative values and 0 values have no substantial meaning for the subsequent calculations of this embodiment. Therefore, such situations need to be considered separately here. For example, when the current inventory of the product on the store display is large, and the sales forecast value and the minimum safety inventory are both small, it is considered that no replenishment is required, that is, there is no demand gap. At this time, only need to assign the replenishment quantity of this product in this store as 0. Here only one situation is illustrated as an example, and there may be other situations where the calculated basic replenishment quantity is less than or equal to 0. At this time, directly assign the required replenishment quantity as 0, which is regarded as no replenishment required, and this product in this store does not participate in the subsequent model solution calculations.

[0061] The specific situations where the basic replenishment quantity is less than or equal to 0 are: if the current product meets any of the following conditions, assign its replenishment quantity as 0, and the conditions include: 1) the basic replenishment quantity for single items ; 2) the basic replenishment quantity for categories ; 3) the available inventory in the warehouse .

[0062] Step 102, solve the safety single-item replenishment quantity according to the basic safety replenishment quantity through the first replenishment optimization model to obtain the safety replenishment calculation value.

[0063] The first replenishment optimization model is a replenishment quantity calculation model constructed in advance with the single-item replenishment quantity of each type of commodity as a variable. The constraint conditions of the first replenishment optimization model include commodity constraint conditions with the safety basic replenishment quantity as the constraint, warehouse inventory constraint conditions with the available inventory in the warehouse as the constraint, and extreme value constraint conditions where the single-item replenishment quantity of the commodity needs to be greater than or equal to 0. These constraint conditions jointly act to constrain the first replenishment optimization model to perform optimization solution calculations to obtain the safety single-item replenishment quantity, that is, the safety replenishment calculation value. After analyzing the safety single-item replenishment quantity of each store, the safety category replenishment quantity can be determined, and then the safety single-item replenishment quantity and category replenishment quantity of all stores under the requirement of meeting the minimum safety inventory can be analyzed.

[0064] Step 103: Update the sales basic replenishment quantity based on the safety replenishment calculation value to obtain the updated basic replenishment quantity, and the updated basic replenishment quantity includes the updated single-item replenishment quantity and the updated category replenishment quantity.

[0065] If replenishment operations are carried out according to the calculated safety replenishment calculation value, then the current inventory of goods in the store, that is, the current single-item inventory and the current category inventory will change, and the sales basic replenishment quantity calculated based on this value, that is, the sales single-item basic replenishment quantity and the sales category basic replenishment quantity will also change accordingly. In this way, the sales basic replenishment quantity can be updated to obtain the updated basic replenishment quantity. The updated single-item replenishment quantity and the updated category replenishment quantity after the update operation can be obtained.

[0066] Step 104: Use the branch and bound method to solve for the sales single-item replenishment quantity according to the updated basic replenishment quantity through the second replenishment optimization model to obtain the sales replenishment calculation value. The constraint conditions of the second replenishment optimization model include constraints based on the updated category replenishment quantity.

[0067] Furthermore, step 104 includes:

[0068] Take the single-item replenishment quantity of each type of commodity as a variable to construct an objective optimization function, and the objective optimization function aims to maximize the turnover rate;

[0069] Configure constraint conditions for the objective optimization function according to the updated basic replenishment quantity to obtain updated constraint conditions;

[0070] Combine the objective optimization function and the updated constraint conditions to generate the second replenishment optimization model;

[0071] Use the branch and bound method to solve the second replenishment optimization model to obtain the sales replenishment calculation value.

[0072] It should be noted that with the single-item replenishment quantity If it is a variable, the objective optimization function of the second replenishment optimization model can be expressed as:

[0073]

[0074] Among them, represents the store the weight of the product on the store service level. This weight is positively correlated with the sales volume and can be defined according to the actual situation. The goal is to ensure the best overall service level for consumers. is the function mark of the objective optimization function.

[0075] The construction method of the second replenishment optimization model in this application is the same as that of the first replenishment optimization model, that is, generating an objective optimization function, configuring multiple constraint conditions, and obtaining a replenishment calculation model; in this process, since the current inventory of products in the store is updated and changing, the difference between the first replenishment optimization model in the first stage and the second replenishment optimization model in the second stage is reflected in the parameters related to the calculation of the current inventory of products. For example, in the constraint conditions of the first replenishment optimization model, there is a variable that the single-product replenishment quantity cannot be greater than the safety single-product basic replenishment quantity , while in the constraint conditions of the second replenishment optimization model, there is a variable that the variable single-product replenishment quantity cannot be greater than the sales single-product basic replenishment quantity , and after the update, it cannot be greater than the updated single-product replenishment quantity . Similarly, if it is a category-related constraint, it is necessary to use the specific calculation-based gap in the two stages as the constraint value, corresponding to the category replenishment quantity obtained by solving the calculation, that is, the sum of the single-product replenishment quantities of all products in a store cannot be greater than the safety category basic replenishment quantity , the sales category basic replenishment quantity or the updated category replenishment quantity .

[0076] The constraint conditions of the replenishment optimization model are generally expressed as follows:

[0077] 1) The single-product replenishment quantity of each type of product is not greater than the single-product demand gap, that is, the single-product basic replenishment quantity:

[0078]

[0079] 2) The sum of the single-product replenishment quantities of each type of product is not greater than the category demand gap, that is, the category basic replenishment quantity:

[0080]

[0081] Among them, represents the store the single product belongs to the category ;Since the replenishment quantity results of each store should be less than the gap in category demand, the replenishment quantities of these affiliated single products need to be summarized by category.

[0082] 3) The sum of the single-product replenishment quantities of all stores belonging to the same warehouse for a certain product cannot be greater than the available inventory of that warehouse:

[0083]

[0084] Among them, is the store index, is the available inventory of product i in the current warehouse.

[0085] 4) The single-product replenishment quantity of each product cannot be less than 0 and is an integer:

[0086]

[0087] Then, the branch and bound method is used to solve the second replenishment optimization model under all the above constraints, and the sales replenishment calculation value can be obtained , similarly, this value is the calculation value of the single-product replenishment quantity of a certain product. By counting the calculation values of the single-product replenishment quantities of all products, the corresponding category replenishment calculation value can be finally sorted out, and the details are not elaborated here. The sales replenishment calculation value is the replenishment quantity obtained from the calculation in the second stage and is the value obtained after the replenishment operation in the first stage. Therefore, the actual replenishment operation quantity is the sum of the replenishment quantity calculation value in the first stage and the replenishment quantity calculation value in the second stage, that is, the sum of the safety replenishment calculation value and the sales replenishment calculation value The sum can also calculate the overall sum of the category replenishment quantity.

[0088] Furthermore, step 104 is followed by:

[0089] Integrate the safety replenishment calculation value, zero-value replenishment quantity, and sales replenishment calculation value to obtain the overall replenishment result.

[0090] In the actual operation process, the replenishment quantities of all stores need to be output as a whole. Since the situation of no replenishment is involved previously, the zero-value replenishment quantities sorted out earlier can be spliced with the replenishment calculation values here to obtain the overall replenishment quantity result of all stores. Just divide it into single products and categories, which can be used as the replenishment quantity output result for the actual scenario to guide the store replenishment operation.

[0091] In the store replenishment quantity calculation method provided by the embodiments of the present application, the replenishment quantity calculation process is divided into two stages. The first stage is to calculate the safety replenishment calculation value according to the safety basic replenishment quantity and the replenishment optimization model; then, based on this value, the sales basic replenishment quantity is updated, and then the replenishment quantity calculation in the second stage is entered. This process takes into account the differences in the demand for goods in different stages and quantifies them into the specific replenishment quantity calculation process, which is more in line with the actual situation, and the obtained sales replenishment calculation value is also more accurate. In addition, the actual replenishment quantity is calculated by constructing a replenishment optimization model and a category replenishment quantity constraint, which fully considers the impact of the category factors of goods on replenishment and provides a guarantee for obtaining a more reliable replenishment quantity calculation value. The embodiments of the present application can solve the technical problems that the prior art does not consider the influence between different types of goods and only focuses on the analysis of single-item data in simple situations, resulting in the lack of accuracy and reliability of the replenishment quantity calculation results.

[0092] For ease of understanding, please refer to Figure 2 , an embodiment of a store replenishment quantity calculation device provided by the present application includes:

[0093] A gap calculation unit 201, configured to calculate the safety basic replenishment quantity and the sales basic replenishment quantity of goods respectively according to the historical sales volume of goods and the pre-set replenishment days, and both the safety basic replenishment quantity and the sales basic replenishment quantity include the single-item basic replenishment quantity and the category basic replenishment quantity;

[0094] A safety replenishment unit 202, configured to solve the safety single-item replenishment quantity according to the safety basic replenishment quantity through the first replenishment optimization model to obtain a safety replenishment calculation value;

[0095] A gap update unit 203, configured to update the sales basic replenishment quantity based on the safety replenishment calculation value to obtain an updated basic replenishment quantity, and the updated basic replenishment quantity includes an updated single-item replenishment quantity and an updated category replenishment quantity;

[0096] A replenishment calculation unit 204, configured to solve the sales single-item replenishment quantity according to the updated basic replenishment quantity through the second replenishment optimization model by using the branch and bound method to obtain a sales replenishment calculation value, and the constraint condition of the second replenishment optimization model includes a constraint based on the updated category replenishment quantity.

[0097] Further, the gap calculation unit 201 is specifically configured to:

[0098] Adopt a preset prediction algorithm to predict the single-item sales volume and category sales volume of goods respectively according to the historical sales volume of goods and the pre-set replenishment days to obtain a goods sales volume prediction value, and the goods sales volume prediction value includes a single-item sales volume prediction value and a category sales volume prediction value;

[0099] Calculate the single - item basic replenishment quantity and category - based basic replenishment quantity of the commodity under the condition of meeting the minimum safety stock respectively according to the minimum safety stock and the current commodity inventory, and obtain the safety - based basic replenishment quantity.

[0100] Calculate the single - item basic replenishment quantity and category - based basic replenishment quantity of the commodity under the condition of meeting future sales respectively according to the predicted value of commodity sales, the minimum safety stock and the current commodity inventory, and obtain the sales - based basic replenishment quantity.

[0101] Further, the replenishment calculation unit 204 is specifically configured to:

[0102] Construct a target optimization function with the single - item replenishment quantity of each category of commodity as a variable, and the target optimization function aims to maximize the turnover rate.

[0103] Configure constraint conditions for the target optimization function according to the updated basic replenishment quantity to obtain updated constraint conditions.

[0104] Generate a second replenishment optimization model by combining the target optimization function and the updated constraint conditions.

[0105] Solve the second replenishment optimization model using the branch - and - bound method to obtain the sales replenishment calculation value.

[0106] The present application also provides a store replenishment quantity calculation device, which includes a processor and a memory.

[0107] The memory is used to store program code and transmit the program code to the processor.

[0108] The processor is used to execute the store replenishment quantity calculation method in the first aspect according to the instructions in the program code.

[0109] The present application also provides a computer - readable storage medium, which is used to store program code, and the program code is used to execute the store replenishment quantity calculation method in the first aspect.

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

[0111] The unit described as a separation component may or may not be physically separated. The component shown as a unit may or may not be a physical unit, that is, it may be located in one place or distributed to multiple network units. Some or all of the units can be selected according to actual needs to achieve the purpose of the solution of this embodiment.

[0112] In addition, each functional unit in various embodiments of the present application may be integrated in a processing unit, or each unit may exist physically alone, or two or more units may be integrated in one unit. The above-mentioned integrated unit can be implemented in the form of hardware or in the form of a software functional unit.

[0113] If the above-mentioned integrated unit is implemented in the form of a software functional unit and sold or used as an independent product, it can be stored in a computer-readable storage medium. Based on such an understanding, the technical solution of the present application, in essence, or the part that contributes to the prior art, or all or part of this technical solution, can be embodied in the form of a software product. This computer software product is stored in a storage medium and includes several instructions for a computer device (which can be a personal computer, a server, or a network device, etc.) to execute all or part of the steps of the methods described in various embodiments of the present application. The aforementioned storage medium includes: USB flash drives, mobile hard disks, read-only memories (English full name: Read-Only Memory, English abbreviation: ROM), random access memories (English full name: Random Access Memory, English abbreviation: RAM), magnetic disks, or optical discs and other various media that can store program codes.

[0114] As described above, the above embodiments are only used to illustrate the technical solutions of the present application, rather than to limit it; although the present application has been described in detail with reference to the foregoing embodiments, those of ordinary skill in the art should understand that they can still modify the technical solutions described in the foregoing embodiments, or perform equivalent replacements for some of the technical features; and these modifications or replacements do not make the essence of the corresponding technical solutions deviate from the spirit and scope of the technical solutions of various embodiments of the present application.

Claims

1. A method for calculating store replenishment quantity, characterized in that: include: The safety basic replenishment quantity and sales basic replenishment quantity of the commodity are calculated respectively according to the historical commodity sales volume and the number of days for pre-equipment. The safety basic replenishment quantity and the sales basic replenishment quantity both include the single product basic replenishment quantity and the category basic replenishment quantity; Solving the safety item replenishment quantity according to the safety basic replenishment quantity through the first replenishment optimization model to obtain a safety replenishment calculation value; Based on the safety replenishment calculation value, the sales basic replenishment quantity is updated to obtain an updated basic replenishment quantity, wherein the updated basic replenishment quantity includes an updated single product replenishment quantity and an updated category replenishment quantity; The branch and bound method is adopted to solve the sales item replenishment quantity according to the updated basic replenishment quantity through the second replenishment optimization model to obtain the sales replenishment calculation value, and the constraint conditions of the second replenishment optimization model include the constraint based on the updated category replenishment quantity.

2. The method for calculating store replenishment quantity according to claim 1, characterized in that: The calculation of the safety base replenishment quantity and sales base replenishment quantity of the commodity based on the historical commodity sales volume and the number of days for pre-equipment replenishment includes: Using a preset prediction algorithm to predict the sales volume of a single product and the sales volume of a category of a product based on historical product sales and the number of days to prepare for shipment, to obtain a sales volume forecast value for the product, wherein the sales volume forecast value for the product includes a sales volume forecast value for a single product and a sales volume forecast value for a category; According to the minimum safety stock quantity and the current product inventory quantity, calculate the basic replenishment quantity of the single product and the basic replenishment quantity of the category under the condition of meeting the minimum safety stock quantity, and obtain the basic safety replenishment quantity; The basic replenishment quantity of a single product and the basic replenishment quantity of a category of the product that meet future sales conditions are calculated respectively according to the predicted sales volume of the product, the minimum safety inventory quantity and the current inventory quantity of the product to obtain the basic replenishment quantity for sales.

3. The store replenishment quantity calculation method according to claim 1, characterized in that: The calculation of the safety base replenishment quantity and the sales base replenishment quantity of the commodity based on the historical commodity sales volume and the pre-equipment stocking days also includes: If the calculated safety basic replenishment quantity or the sales basic replenishment quantity is less than or equal to 0, the replenishment quantity of the corresponding commodity is assigned a value of 0 to obtain a zero-value replenishment quantity.

4. The store replenishment quantity calculation method according to claim 1, characterized in that: The method of using the branch and bound method to solve the sales item replenishment quantity according to the updated basic replenishment quantity through the second replenishment optimization model to obtain the sales replenishment calculation value includes: The replenishment quantity of each type of commodity is used as a variable to construct a target optimization function, wherein the target optimization function takes the maximum turnover rate as a goal; According to the updated basic replenishment quantity, a constraint condition is configured for the objective optimization function to obtain an updated constraint condition; generating a second replenishment optimization model by combining the objective optimization function and the update constraint condition; The second replenishment optimization model is solved by using the branch and bound method to obtain the sales replenishment calculation value.

5. The method for calculating store replenishment quantity according to claim 1, characterized in that: The method adopts the branch and bound method through the second replenishment optimization model to solve the sales item replenishment quantity according to the updated basic replenishment quantity to obtain the sales replenishment calculation value, and then further includes: The safety replenishment calculation value, the zero-value replenishment quantity and the sales replenishment calculation value are integrated to obtain an overall replenishment result.

6. A store replenishment quantity calculation device, characterized in that: include: A gap calculation unit is used to calculate the safety basic replenishment quantity and the sales basic replenishment quantity of the commodity based on the historical commodity sales volume and the number of days for pre-equipment, wherein the safety basic replenishment quantity and the sales basic replenishment quantity both include the single product basic replenishment quantity and the category basic replenishment quantity; A safety replenishment unit, configured to solve the safety item replenishment quantity according to the safety basic replenishment quantity through a first replenishment optimization model to obtain a safety replenishment calculation value; a gap updating unit, configured to update the sales basic replenishment quantity based on the safety replenishment calculation value to obtain an updated basic replenishment quantity, wherein the updated basic replenishment quantity includes an updated single product replenishment quantity and an updated category replenishment quantity; The replenishment calculation unit is used to solve the sales item replenishment quantity according to the updated basic replenishment quantity through a second replenishment optimization model by using a branch and bound method to obtain a sales replenishment calculation value, wherein the constraint conditions of the second replenishment optimization model include constraints based on the updated category replenishment quantity.

7. The store replenishment quantity calculation device according to claim 6, characterized in that: The gap calculation unit is specifically used for: Using a preset prediction algorithm to predict the sales volume of a single product and the sales volume of a category of a product based on historical product sales and the number of days to prepare for shipment, to obtain a sales volume forecast value for the product, wherein the sales volume forecast value for the product includes a sales volume forecast value for a single product and a sales volume forecast value for a category; According to the minimum safety stock quantity and the current product inventory quantity, calculate the basic replenishment quantity of the single product and the basic replenishment quantity of the category under the condition of meeting the minimum safety stock quantity, and obtain the basic safety replenishment quantity; The basic replenishment quantity of a single product and the basic replenishment quantity of a category of the product that meet future sales conditions are calculated respectively according to the predicted sales volume of the product, the minimum safety inventory quantity and the current inventory quantity of the product to obtain the basic replenishment quantity for sales.

8. The store replenishment quantity calculation device according to claim 6, characterized in that: The replenishment calculation unit is specifically used for: The replenishment quantity of each type of commodity is used as a variable to construct a target optimization function, wherein the target optimization function takes the maximum turnover rate as a goal; According to the updated basic replenishment quantity, a constraint condition is configured for the objective optimization function to obtain an updated constraint condition; generating a second replenishment optimization model by combining the objective optimization function and the update constraint condition; The second replenishment optimization model is solved by using the branch and bound method to obtain the sales replenishment calculation value.

9. A store replenishment quantity calculation device, characterized in that: The device comprises a processor and a memory; The memory is used to store program code and transmit the program code to the processor; The processor is used to execute the store replenishment quantity calculation method described in any one of claims 1-5 according to the instructions in the program code.

10. A computer-readable storage medium, characterized in that: The computer-readable storage medium is used to store program codes, and the program codes are used to execute the store replenishment quantity calculation method according to any one of claims 1 to 5.

Images