Calculation method and model for preventing warehouse explosion and improving loading efficiency

By calculating the amount of warehouse transfer and optimizing the inventory allocation of multiple warehouses, the problem of warehouse inventory filing caused by unbalanced warehouse inventory is solved, inventory warning and warehouse transfer strategies are realized, and the loading efficiency is improved.

CN118941204APending Publication Date: 2024-11-12NEW TREND INT LOGIS TECH
View PDF 0 Cites 0 Cited by

Patent Information

Application Number
CN202410962852.2
Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
Filing Date
2024-07-18
Publication Date
2024-11-12

AI Technical Summary

Technical Problem

Dynamic imbalance in warehouse inventory in production points/shipping points leads to overdue warehouses and uneven distribution of materials, resulting in goods being reversed between multiple warehouses and cannot be delivered on time.

Method used

Through calculation methods, the amount of warehouse transfer is judged and calculated, conventional, special and personalized rules are used, and linear planning algorithms are combined to optimize the inventory allocation of multiple warehouses to generate the optimal transfer plan to avoid reverse loading.

Benefits of technology

The inventory warning and warehouse transfer strategy has been realized, which avoids multiple reversal loading, shortens the loading time, prevents warehouses from exploding, and improves loading efficiency.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure FT_1
    Figure FT_1
  • Figure FT_2
    Figure FT_2
  • Figure FT_3
    Figure FT_3
Patent Text Reader

Abstract

The invention discloses a calculation method and model for preventing warehouse explosion and improving loading efficiency. The calculation method comprises the following steps: A, moving in a production point / delivery point: judging whether the warehouse needs to be moved or not, judging the warehouse moving amount, performing a conventional classification process, performing a special rule configuration process and performing personalized rule customization; and B, algorithm description: problem definition, variable definition, objective function, constraint condition, special rule processing, solving process and result extraction. According to the method, the production plan, the sales plan, the stock condition of each material in each warehouse at the production point / delivery point and the safety stock threshold value are combined, the materials needing to be moved, the quantity and the moved warehouses are calculated, and through the safety stock of each material and the safety stock of the warehouses, the purchase mode of customers is combined, so that the material transfer efficiency is improved. And calculating warehouse material transfer requirements in a factory or a production point / delivery point, realizing inventory early warning and providing a corresponding warehouse transfer strategy.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The present invention relates to the field of warehouse technology, and in particular to a calculation method and model for preventing warehouse explosions and improving loading efficiency. Background Art

[0002] When a dynamic balance is not formed between production warehousing or procurement warehousing and outbound warehousing in the production / shipping point, it will lead to warehouse overflow, uneven material inventory distribution, and scattered material distribution. As a result, a truckload of goods or goods for the same order need to be reversed and loaded between multiple warehouses, which will result in the goods delivery not arriving on time within the specified time window. Summary of the Invention

[0003] The purpose of the present invention is to provide a calculation method and model for preventing warehouse explosion and improving loading efficiency, so as to solve the problems raised in the above background technology.

[0004] To achieve the above objectives, the present invention provides the following technical solution: a calculation method for preventing warehouse explosions and improving loading efficiency, the calculation method comprising the following steps: A. Internal transfer of warehouses at production / shipping points: This includes determining whether warehouse transfer is necessary and the amount of warehouse transfer, general classification processes, special rule configuration processes, and personalized rule customization; B. Algorithm description: including problem definition, variable definition, objective function, constraints, special rule processing, solution process and result extraction.

[0005] Preferably, the judgment of whether warehouse transfer is needed and the amount of transfer is as follows: the safety stock is obtained by issuing data or configuring data, the inventory quantity of each warehouse calculated by the production schedule, the sales inventory calculated by the orders and non-order contracts, and the amount of unallocated data, the current inventory of each warehouse are integrated and displayed in the data dashboard, and then the minimum transfer quantity is calculated according to the formula, in which each variable value is passed to the scheduling management module as follows: expected transfer quantity = (safety stock + production inventory quantity * N days - expected allocation quantity) - (safety stock).

[0006] Preferably, the conventional classification process is: under the premise of no special rule configuration and personalized customization rules, the target warehouse priority weight will be read in turn and the target warehouse will be judged, the materials that can participate in the warehouse transfer will be judged, the inventory will be compared to obtain the range of warehouse transfer, and the above variables will be retained waiting for input into the intelligent algorithm for solution. The special rule configuration process is: special materials, special starting warehouses and special target materials will be selected through the parameter configuration interface. The brands of this part will be strictly screened in accordance with special rules to obtain the final materials, target warehouses and the number of warehouses that can be transferred, etc., which will be used to input into the intelligent algorithm for solution. The personalized rule customization is: the participating materials are judged by customized conditions, such as the dehumidifier cargo position judgment, which requires preconditions such as data interface, and finally the solution variables that can be used for reinforcement learning are obtained or they do not participate in the intelligent algorithm process.

[0007] Preferably, the problem is defined as: optimizing inventory allocation among multiple warehouses to minimize comprehensive costs, the comprehensive costs including inventory deviation costs, priority costs and excess inventory costs, the variable definitions including transfer variables and slack variables, the transfer variables representing the amount of goods transferred between different warehouses, the type being a continuous variable, the range being non-negative (lowBound=0), interpreted as representing the amount of goods transferred between different warehouses, defined as a three-dimensional variable (i, j, k), where i and j represent warehouses, k represents the type of goods, the slack variable represents inventory deviation, used to adjust the difference between actual inventory and target inventory, the type being a continuous variable, the range being non-negative (lowBound=0), interpreted as representing inventory deviation, used to adjust the difference between actual inventory and target inventory, defined as a two-dimensional variable (i, k), where i represents warehouse, and k represents the type of goods.

[0008] Preferably, the objective function includes inventory deviation cost, priority cost, excess inventory cost and objective function formula. The inventory deviation cost is: the deviation between the actual inventory and the target inventory of each warehouse. The priority cost is: the cost of transferring goods between different warehouses according to the priority weight. The excess inventory cost is: the portion of the total inventory of the warehouse that exceeds its maximum storage capacity. The objective function formula is: .

[0009] Preferably, the constraints include a maximum inventory capacity constraint, a safety stock constraint, a non-negative transfer constraint, and a special rule constraint. The maximum inventory capacity constraint is: the total inventory of each warehouse does not exceed its maximum inventory capacity. The formula is: , the safety stock constraint is: the inventory of each product is between the minimum and maximum safety stocks, the formula is: , the non-negative transfer constraint is: goods cannot be transferred between the same warehouses. The formula is: , the special rule constraint is: according to the specific rules, limit the transfer of specific goods between specific warehouses, item_index represents the type of goods, start_index represents the starting warehouse, and end_index represents the target warehouse. For each special rule, add the following constraints: This means that the item_index goods departing from the start_index warehouse can only be transferred to the end_index warehouse and cannot be transferred to other warehouses.

[0010] Preferably, the special rule processing is: according to the special rule data frame, constraints are added to specific goods and warehouses to ensure that inventory allocation under specific conditions meets business needs. The solution process is: solving the optimization problem defined above through a linear programming solver (CBC solver) to obtain the optimal goods transfer plan.

[0011] Preferably, the result extraction is: extracting the optimal transfer plan from the solution result, generating a specific transfer action list, and the result extraction includes algorithm steps, the algorithm steps include initializing the problem, defining variables, adding objective functions, adding constraints, solving the problem and extracting solutions, the initialization problem is: defining a linear programming problem instance, setting the goal to be minimized, defining variables as: creating transfer variables and slack variables, adding an objective function as: comprehensively considering inventory deviation, priority weight and excess inventory, constructing an objective function, adding constraints as: ensuring that the total inventory of each warehouse does not exceed the maximum warehouse capacity, the inventory is within the safety stock range, not allowing the transfer of goods between the same warehouses, and processing special rules, solving the problem is: calling a linear programming solver, solving the optimization problem, extracting a solution as: extracting the optimal transfer plan from the solution result, and generating a specific transfer action list.

[0012] A calculation model for preventing warehouse overflow and improving loading efficiency adopts the calculation method for preventing warehouse overflow and improving loading efficiency.

[0013] Compared with the prior art, the present invention has the following beneficial effects: The present invention combines the production plan, sales plan and the inventory status of each material in each warehouse at the production point / shipping point and the safety stock threshold to calculate the materials that need to be transferred, the quantity and the warehouse to be transferred to. Moreover, through the safety stock of various materials and the safety stock of the warehouse, combined with the customer's procurement pattern, the material transfer demand of the warehouse within the factory or production point / shipping point is calculated, inventory early warning is implemented and corresponding transfer strategy is provided to avoid multiple reverse loading, long loading time, slow departure, warehouse overflow and the like. BRIEF DESCRIPTION OF THE DRAWINGS

[0014] Figure 1 It is the inventory quantity map of the present invention; Figure 2 This is the outbound quantity diagram of the present invention; Figure 3 This is a diagram of the intelligent warehouse transfer solution of the present invention. DETAILED DESCRIPTION

[0015] The following will clearly and completely describe the technical solutions in the embodiments of the present invention in conjunction with the accompanying drawings. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without making creative efforts are within the scope of protection of the present invention.

[0016] See also Figure 1-Figure 3 A calculation method for preventing warehouse overflow and improving loading efficiency includes the following steps: A. Internal transfers within production / shipping points: This involves determining whether transfers are necessary and the transfer quantity, along with routine classification processes, special rule configuration processes, and customized rule customization. Based on optimization objective rules such as reducing loading time and ensuring warehouse overflow, as well as a few customized rules such as prioritizing the transfer of work-in-progress, a reward function is calculated. Reinforcement learning training is conducted using historical transfer orders and applied to actual solutions to determine the final transfer plan. B. Algorithm description: including problem definition, variable definition, objective function, constraints, special rule processing, solution process and result extraction.

[0017] To determine whether warehouse transfer is needed and the transfer quantity, the following are used: the safety stock quantity is obtained by issuing data or configuring data, the incoming inventory quantity of each warehouse is calculated by the production schedule, the sales outgoing inventory is calculated by the ordered and unordered contracts, and the amount of unallocated data. The current inventory quantity of each warehouse is integrated and displayed in the data dashboard, and then the minimum transfer quantity is calculated according to the formula. The formula for passing each variable value to the scheduling management module is: Estimated transfer quantity = (safety stock + scheduled incoming inventory * N days - estimated allocation quantity) - (safety stock).

[0018] The general classification process is: under the premise of no special rule configuration and personalized customization rules, the target warehouse priority weight will be read in turn and the target warehouse will be judged, the materials that can participate in the transfer will be judged, the inventory will be compared to obtain the range of transfer, and the above variables will be retained for input into the intelligent algorithm for solution. The special rule configuration process is: special materials, special starting warehouses and special target materials will be selected through the parameter configuration interface. The brands of this part will be strictly screened according to special rules to obtain the final materials, target warehouses and the number of transferable warehouses and other variables for input into the intelligent algorithm for solution. Personalized rule customization is: the participating materials are judged by customized conditions, such as the dehumidifier cargo position judgment, which requires preconditions such as data interface, and finally the solution variables that can be used for reinforcement learning are obtained or they do not participate in the intelligent algorithm process.

[0019] The problem is defined as: optimize the inventory allocation between multiple warehouses to minimize the comprehensive cost. The comprehensive cost includes inventory deviation cost, priority cost and excess inventory cost. The variable definitions include transfer variables (transfer_vars) and slack variables (slack). The transfer variable represents the transfer amount of goods between different warehouses. The type is a continuous variable (Continuous) and the range is non-negative (lowBound=0). It is interpreted as representing the transfer amount of goods between different warehouses and is defined as a three-dimensional variable (i, j, k), where i and j represent warehouses and k represents the type of goods. The slack variable represents the inventory deviation, which is used to adjust the difference between the actual inventory and the target inventory. The type is a continuous variable and the range is non-negative (lowBound=0). It is interpreted as representing the inventory deviation, which is used to adjust the difference between the actual inventory and the target inventory. It is defined as a two-dimensional variable (i, k), where i represents the warehouse and k represents the type of goods.

[0020] The objective function includes inventory deviation cost, priority cost, excess inventory cost, and objective function formula. The inventory deviation cost is the deviation between the actual inventory and the target inventory of each warehouse. The priority cost is the cost of transferring goods between different warehouses based on the priority weight. The excess inventory cost is the amount by which the total inventory of a warehouse exceeds its maximum storage capacity. The objective function formula is: .

[0021] Constraints include maximum inventory capacity constraints, safety stock constraints, non-negative transfer constraints, and special rule constraints. The maximum inventory capacity constraint is that the total inventory of each warehouse does not exceed its maximum inventory capacity. The formula is: , the safety stock constraint is: the inventory of each product is between the minimum and maximum safety stocks, the formula is:, , the non-negative transfer constraint is: goods cannot be transferred between the same warehouses. The formula is: , the special rule constraint is: according to the specific rules, limit the transfer of specific goods between specific warehouses, item_index represents the type of goods, start_index represents the starting warehouse, and end_index represents the target warehouse. For each special rule, add the following constraints: This means that the item_index goods departing from the start_index warehouse can only be transferred to the end_index warehouse and cannot be transferred to other warehouses.

[0022] Special rule processing is as follows: according to the special rule data frame, constraints are added for specific goods and warehouses to ensure that inventory allocation under specific conditions meets business needs. The solution process is as follows: the optimization problem defined above is solved by a linear programming solver (CBC solver) to obtain the optimal goods transfer plan.

[0023] The result extraction is: extracting the optimal transfer plan from the solution results and generating a specific transfer action list. The result extraction includes algorithm steps, which include initializing the problem, defining variables, adding objective functions, adding constraints, solving the problem and extracting solutions. The initialization problem is: defining a linear programming problem instance, setting the goal to be minimized, defining variables: creating transfer variables and slack variables, adding objective functions: comprehensively considering inventory deviations, priority weights and excess inventory, constructing objective functions, adding constraints: ensuring that the total inventory of each warehouse does not exceed the maximum inventory capacity, the inventory is within the safety stock range, and the transfer of goods between the same warehouses is not allowed, and special rules are handled. The problem solving is: calling the linear programming solver to solve the optimization problem. The solution extraction is: extracting the optimal transfer plan from the solution results and generating a specific transfer action list.

[0024] A calculation model for preventing warehouse overflow and improving loading efficiency adopts a calculation method for preventing warehouse overflow and improving loading efficiency.

[0025] Intelligent warehouse transfer experiment: You can view warehouse capacity information, current inventory, production plan incoming quantity, planned sales outgoing quantity, unallocated quantity, etc. You can modify the algorithm configuration and warehouse capacity online. Figure 1 and Figure 2 As shown, the safety stock can also be modified manually, such as Figure 3 As shown, in the intelligent factory transfer experiment, click on the production factory transfer plan to generate the transfer plan, and refer to the production plan incoming quantity, planned sales outgoing quantity and current inventory information to calculate the details of the materials that need to be transferred. The transferred materials can be manually adjusted.

[0026] While embodiments of the present invention have been shown and described, it will be appreciated by those skilled in the art that various changes, modifications, substitutions, and variations may be made to these embodiments without departing from the principles and spirit of the invention, and that the scope of the invention is defined by the appended claims and their equivalents.

Claims

1. A calculation method for preventing warehouse explosion and improving loading efficiency, characterized by: The calculation method includes the following steps: A. Warehouse transfer within the production point / shipping point: including determining whether warehouse transfer is required and the amount of transfer, conventional classification process, special rule configuration process and personalized rule customization; B. Algorithm description: including problem definition, variable definition, objective function, constraints, special rule processing, solution process and result extraction.

2. A calculation method for preventing warehouse explosion and improving loading efficiency according to claim 1, characterized in that: The judgment on whether warehouse transfer and the amount of transfer is needed is as follows: the safety stock is obtained by issuing data or configuring data, the warehouse incoming quantity calculated by the production schedule, the sales outgoing quantity calculated by the ordered and unordered contracts, and the amount of unallocated data. The current inventory of each warehouse is integrated in the data dashboard for display, and then the minimum transfer quantity is calculated according to the formula. The formula for passing each variable value to the scheduling management module is: Estimated transfer quantity = (safety stock + production incoming quantity * N days - estimated transfer quantity) - (safety stock).

3. The calculation method for preventing warehouse explosion and improving loading efficiency according to claim 1 is characterized by: The conventional classification process is: under the premise of no special rule configuration and personalized customization rules, the target warehouse priority weight will be read in turn and the target warehouse will be judged, the materials that can participate in the warehouse transfer will be judged, the inventory will be compared to obtain the range of warehouse transfer, and the above variables will be retained waiting for input into the intelligent algorithm for solution. The special rule configuration process is: select special materials, special starting warehouses and special target materials through the parameter configuration interface. The grades of this part will be strictly screened in accordance with special rules to obtain the final materials, target warehouses and the number of warehouses that can be transferred, etc. Variables are used to input into the intelligent algorithm for solution. Personalized rule customization is: the participating materials are judged by customized conditions, such as the dehumidifier cargo position judgment, which requires preconditions such as data interface, and finally the solution variables that can be used for reinforcement learning are obtained or they do not participate in the intelligent algorithm process.

4. The calculation method for preventing warehouse explosion and improving loading efficiency according to claim 1 is characterized by: The problem is defined as: optimize the inventory allocation between multiple warehouses to minimize the comprehensive cost. The comprehensive cost includes inventory deviation cost, priority cost and excess inventory cost. The variable definition includes transfer variables and slack variables. The transfer variable represents the transfer amount of goods between different warehouses. The type is a continuous variable with a non-negative range (lowBound=0). It is interpreted as representing the transfer amount of goods between different warehouses and is defined as a three-dimensional variable (i, j, k), where i and j represent warehouses, and k represents the type of goods. The slack variable represents the inventory deviation, which is used to adjust the difference between the actual inventory and the target inventory. The type is a continuous variable with a non-negative range (lowBound=0). It is interpreted as representing the inventory deviation, which is used to adjust the difference between the actual inventory and the target inventory. It is defined as a two-dimensional variable (i, k), where i represents the warehouse and k represents the type of goods.

5. The calculation method for preventing warehouse explosion and improving loading efficiency according to claim 1 is characterized by: The objective function includes inventory deviation cost, priority cost, excess inventory cost and objective function formula. The inventory deviation cost is: the deviation between the actual inventory and the target inventory of each warehouse. The priority cost is: according to the priority weight, the cost of transferring goods between different warehouses is calculated. The excess inventory cost is: the part of the total inventory of the warehouse that exceeds its maximum storage capacity. The objective function formula is: .

6. The calculation method for preventing warehouse explosion and improving loading efficiency according to claim 1 is characterized by: The constraints include maximum inventory capacity constraints, safety inventory constraints, non-negative transfer constraints and special rule constraints. The maximum inventory capacity constraint is: the total inventory of each warehouse does not exceed its maximum inventory capacity. The formula is: , the safety stock constraint is: the inventory of each product is between the minimum and maximum safety stocks, the formula is: , the non-negative transfer constraint is: goods cannot be transferred between the same warehouses. The formula is: , the special rule constraint is: according to the specific rules, limit the transfer of specific goods between specific warehouses, item_index indicates the type of goods, start_index indicates the starting warehouse, and end_index indicates the target warehouse. For each special rule, add the following constraints: This means that the item_index goods departing from the start_index warehouse can only be transferred to the end_index warehouse and cannot be transferred to other warehouses.

7. The calculation method for preventing warehouse explosion and improving loading efficiency according to claim 1 is characterized by: The special rule processing is: according to the special rule data frame, constraints are added to specific goods and warehouses to ensure that the inventory allocation under specific conditions meets business needs. The solution process is: the optimization problem defined above is solved by a linear programming solver (CBC solver) to obtain the optimal goods transfer plan.

8. The calculation method for preventing warehouse explosion and improving loading efficiency according to claim 1 is characterized by: The result extraction is: extracting the optimal transfer plan from the solution results, generating a specific transfer action list, and the result extraction includes algorithm steps, the algorithm steps include initializing the problem, defining variables, adding objective functions, adding constraints, solving the problem and extracting solutions, the initialization problem is: defining a linear programming problem instance, setting the goal to be minimized, defining variables: creating transfer variables and slack variables, adding an objective function: comprehensively considering inventory deviations, priority weights and excess inventory, constructing an objective function, adding constraints: ensuring that the total inventory of each warehouse does not exceed the maximum warehouse capacity, the inventory is within the safety stock range, the transfer of goods between the same warehouses is not allowed, and special rules are processed, the problem is solved: calling a linear programming solver, solving the optimization problem, and extracting a solution: extracting the optimal transfer plan from the solution results, and generating a specific transfer action list.

9. A calculation model for preventing warehouse explosion and improving loading efficiency, characterized by: The calculation model adopts the calculation method for preventing warehouse explosion and improving loading efficiency as described in any one of claims 1-8.