A spare part allocation method for multiple warehouses
By obtaining and analyzing spare parts inventory information and historical outbound data from multiple warehouses, determining the models of out-of-stock spare parts and generating allocation orders, the problems of unreasonable allocation plans and unreasonable transportation decisions in the existing technology are solved, and more efficient and accurate inventory management and allocation transportation are achieved.
Patent Information
- Application Number
- CN202411136581.1
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- Filing Date
- 2024-08-19
- Publication Date
- 2025-06-13
- Estimated Expiration
- 2044-08-19
AI Technical Summary
During the allocation process of existing warehouses, there are problems such as unreasonable allocation plan, no standard operation process, unreasonable allocation strategy setting, and unreasonable transportation decisions, resulting in inefficiency, increased costs and reduced inventory turnover.
By obtaining spare parts inventory information and historical outbound data from multiple warehouses, analyzing the out-of-stock spare parts models of each warehouse, determining the spare parts collection warehouse group, and generating the corresponding spare parts allocation order. Send the allocation order to multiple audit terminal devices for parallel audit, generate allocation and outbound database information, and monitor transportation information to ensure accuracy and efficiency.
More accurate and efficient inventory management is achieved, reducing inventory backlog and out of stock, improving allocation efficiency and inventory turnover rate, and reducing transportation costs and time.
Smart Images

Figure CN119090399B_ABST
Abstract
Description
Technical Field
[0001] The present invention relates to the field of transfer, and specifically relates to a spare part transfer method for multiple warehouses. Background Art
[0002] With the booming development of the e-commerce industry, the market competition is becoming increasingly fierce. In order to meet the diverse needs of consumers and quickly respond to market changes, each industry has built a more efficient and flexible supply chain system. The transfer of goods among multiple warehouses is an important part of supply chain management.
[0003] In the existing warehouse transfer process, the following technical problems often exist:
[0004] First, the transfer plan is unreasonable, resulting in untimely transfer or overstocking of goods; there is no standard process for the transfer process operation, which is prone to errors and omissions, affecting the efficiency and accuracy of transfer;
[0005] Second, the unreasonable setting of the transfer strategy leads to low efficiency of the transfer work among warehouses, chaos in the supply chain, and a decrease in the inventory turnover rate of multiple warehouses. It is impossible to accurately match the actual needs of multiple warehouses, and it will also increase the transfer cost and time;
[0006] Third, during the transfer transportation process, if the transportation decision is unreasonable, it will directly lead to many problems such as low transportation efficiency, increased cost, and damaged goods. Summary of the Invention
[0007] This part of the present invention is used to briefly introduce the concepts, which will be described in detail in the following detailed implementation part. This part of the present invention is not intended to identify the key features or essential features of the claimed technical solution, nor is it intended to limit the scope of the claimed technical solution.
[0008] The present invention proposes a spare part transfer method for multiple warehouses to solve one or more of the technical problems mentioned in the above background art part.
[0009] The present invention provides a spare part transfer method for multiple warehouses, including: obtaining the spare part inventory information and historical spare part outbound data of each warehouse among multiple warehouses, where the spare part inventory information of each warehouse includes the warehouse name, warehouse address, multiple spare part models, and the inventory quantity corresponding to each spare part model; the historical spare part outbound data of each warehouse includes historical spare part transfer outbound data and historical spare part sales outbound data; analyzing the inventory quantity corresponding to each spare part model among the multiple spare part models of each warehouse among the multiple warehouses to obtain the out-of-stock spare part models of each warehouse, and determining the warehouses corresponding to the out-of-stock spare part models as spare part receiving warehouses to obtain a group of spare part receiving warehouses; determining the spare part transfer orders of each spare part receiving warehouse according to the historical spare part outbound data of each warehouse and the spare part inventory information of each warehouse to obtain multiple spare part transfer orders corresponding to multiple spare part receiving warehouses; sending each spare part transfer order to multiple audit terminal devices, so that multiple auditors corresponding to the multiple audit terminal devices conduct audits according to a predetermined multiple audit contents and give audit results, and the audit results include audit passed and audit rejected, where each audit terminal device corresponds to one auditor, and when the audit results of each auditor among the multiple auditors are audit passed, the audit is completed; when the spare part transfer order audit is completed, generating the transfer outbound information corresponding to the spare part transfer order, and sending the transfer outbound information corresponding to the spare part transfer order to the shipping terminal device corresponding to the target spare part shipping warehouse, so that the shipping transfer personnel corresponding to the shipping terminal device perform transfer operations according to the transfer outbound information and upload the transfer transportation information corresponding to the transfer outbound information; monitoring the transfer transportation information, and if it is monitored that the transportation status included in the transfer transportation information is received, generating the transfer receiving information of the spare part transfer order, and sending the transfer receiving information of the spare part transfer order to the receiving terminal device corresponding to the target spare part receiving warehouse, so that the receiving transfer personnel corresponding to the receiving terminal device accept the transferred spare part models and transfer quantities corresponding to the transfer receiving information.
[0010] Optionally, each warehouse among the multiple warehouses is configured with a corresponding safety inventory quantity, and the safety inventory quantity corresponding to each spare part model of each warehouse is determined through the following steps:
[0011] Obtaining the warehouse data of each warehouse among the multiple warehouses and the attribute information of each spare part model, where the warehouse data includes the warehouse type, warehouse location information, and a list of project information supplied by the warehouse; the attribute information of each spare part model includes the spare part scarcity degree, spare part unit price, spare part life, spare part replaceability degree, and replacement cost, where the warehouse type is a central warehouse or a peripheral warehouse;
[0012] Determining at least one warehouse with the warehouse type of peripheral warehouse among the multiple warehouses as a peripheral warehouse and dividing it into a peripheral warehouse group, and determining at least one warehouse with the warehouse type of central warehouse among the multiple warehouses as a central warehouse and dividing it into a central warehouse group;
[0013] For each edge warehouse in the edge warehouse group, determine whether there is a central warehouse within the preset range of the edge warehouse according to the warehouse location information. If there is, determine the location attribute of the edge warehouse as secondary. If not, determine the location attribute of the edge warehouse as tertiary, and determine the location attribute of each central warehouse in the central warehouse group as primary;
[0014] For each warehouse among multiple warehouses, generate a spare part demand coefficient corresponding to each project according to the project scale, project importance degree, and project operation time included in each project information in the project information list of the warehouse supply. According to the spare part demand coefficient corresponding to each project, generate the cumulative value of the spare part demand coefficients of multiple projects involved in the project information list of each warehouse;
[0015] For each warehouse among multiple warehouses, generate a warehouse stock preparation coefficient corresponding to each warehouse according to the location attribute and the cumulative value of the spare part demand coefficient;
[0016] Generate a spare part stock preparation coefficient for each spare part model according to the attribute information of each spare part model in each warehouse, including the scarcity degree of the spare part, the unit price of the spare part, the life of the spare part, the replaceability degree of the spare part, and the replacement cost;
[0017] For each spare part model in each warehouse, generate the safety stock quantity corresponding to each warehouse according to the spare part stock preparation coefficient of the spare part model, the warehouse stock preparation coefficient of the corresponding warehouse, and the benchmark safety stock quantity corresponding to each spare part model.
[0018] Optionally, the safety stock quantity corresponding to each spare part model in each warehouse is dynamically updated through the following steps:
[0019] Within the preset time interval after generating the safety stock quantity corresponding to each warehouse, when the actual stock quantity of each spare part model in each warehouse is less than the configured safety stock quantity, generate an inventory emergency message corresponding to the warehouse. The inventory emergency message includes the warehouse name, the emergency spare part model, and the emergency time, and obtain the inventory emergency message set corresponding to the preset time interval;
[0020] For each central warehouse in the central warehouse group, if the number of inventory emergency messages in the inventory emergency message set corresponding to the central warehouse is greater than the first preset quantity threshold, increase the safety stock quantity corresponding to the central warehouse;
[0021] For each edge warehouse in the edge warehouse group, if the number of inventory shortage messages in the inventory shortage message set corresponding to the edge warehouse is zero, the safety inventory quantity corresponding to the edge warehouse is reduced. If the number of inventory shortage messages in the inventory shortage message set corresponding to the edge warehouse is non-zero and less than or equal to the second preset quantity threshold, the safety inventory quantity corresponding to the edge warehouse remains unchanged. If the number of inventory shortage messages in the inventory shortage message set corresponding to the edge warehouse is greater than the second preset quantity threshold, the safety inventory quantity corresponding to the edge warehouse is increased; wherein, the first preset quantity threshold is greater than the second preset quantity threshold.
[0022] Optionally, the spare part transfer order of each spare part receiving warehouse includes a target spare part receiving warehouse and a target spare part shipping warehouse, and the target spare part receiving warehouse and the target spare part shipping warehouse are determined through the following steps:
[0023] Compare the inventory quantity of each spare part model corresponding to each warehouse among multiple warehouses with the safety inventory quantity of each spare part model. If the inventory quantity of each spare part model is less than the safety inventory quantity of each spare part model, determine the spare part models with inventory quantity less than the safety inventory quantity as out-of-stock spare part models, obtain the out-of-stock spare part model group corresponding to the warehouse, and determine the warehouse corresponding to the out-of-stock spare part model as the spare part receiving warehouse and add it to the spare part receiving warehouse group;
[0024] Based on the historical spare part sales and outbound data of each out-of-stock spare part model in the out-of-stock spare part model group of each spare part receiving warehouse in the spare part receiving warehouse group during the target time period, obtain the historical spare part sales and outbound quantity of each out-of-stock spare part model; according to the historical spare part sales and outbound quantity of each out-of-stock spare part model, determine the spare part receiving warehouse sequence corresponding to each out-of-stock spare part model, and determine the spare part receiving warehouse with the largest historical spare part sales and outbound quantity in the spare part receiving warehouse sequence corresponding to each out-of-stock spare part model as the target spare part receiving warehouse corresponding to each out-of-stock spare part model;
[0025] If the inventory quantity of the out-of-stock spare part model corresponding to the target spare part receiving warehouse in the warehouse among multiple warehouses is greater than the safety inventory quantity of the out-of-stock spare part model, determine the warehouse with the inventory quantity greater than the safety inventory quantity as the spare part shipping warehouse and add it to the spare part shipping warehouse group, wherein at least one spare part shipping warehouse corresponds to one out-of-stock spare part model;
[0026] Based on the warehouse addresses of each spare part shipping warehouse in the spare part shipping warehouse group, determine the distance value between each spare part shipping warehouse and the target spare part receiving warehouse, score the distance value between each spare part shipping warehouse and the target spare part receiving warehouse according to a preset rule, and determine the score corresponding to each spare part shipping warehouse; select the spare part shipping warehouse corresponding to the highest score from the scores corresponding to each spare part shipping warehouse as the target spare part shipping warehouse corresponding to each out-of-stock spare part model.
[0027] Optionally, the spare part transfer order includes a transfer quantity, which is determined through the following steps:
[0028] Based on the historical spare part sales and issue quantity of the out-of-stock spare part model corresponding to the target spare part delivery warehouse, generate a spare part sales volume chart for the out-of-stock spare part model corresponding to the target spare part delivery warehouse; divide the spare part sales volume chart to obtain multiple spare part sales sub-charts corresponding to multiple periods. Among them, each spare part sales sub-chart for a period shows the sales volume of the out-of-stock spare part model corresponding to the target spare part delivery warehouse within the target time period, with the horizontal axis being time and the vertical axis being the sales volume of the out-of-stock spare part model; perform superposition analysis on each spare part sales sub-chart for each period among the multiple spare part sales sub-charts corresponding to multiple periods to obtain the sales trend of each historical time point of the out-of-stock spare part model and multiple sales volumes corresponding to each historical time point;
[0029] Determine the time point corresponding to the spare part transfer order for each spare part receiving warehouse, and analyze the sales trend and multiple sales volumes of the historical time points corresponding to the time point. If the sales trend of the historical time points of multiple periods corresponding to the time point is an increasing trend, then select the highest sales volume among the multiple sales volumes of the historical time points corresponding to multiple periods as the first estimated demand quantity; if the sales trend of the historical time points of multiple periods of the time point is a decreasing trend, then select the lowest sales volume among the multiple sales volumes of the historical time points corresponding to multiple periods as the second estimated demand quantity;
[0030] Based on the inventory quantity, safety inventory quantity, and the first estimated demand quantity or the second estimated demand quantity corresponding to the out-of-stock spare part model corresponding to the target spare part delivery warehouse, obtain the transfer quantity of the out-of-stock spare part model corresponding to the spare part transfer order for the target spare part delivery warehouse.
[0031] Optionally, the spare part transfer order includes a spare part transfer order number, which is determined through the following steps:
[0032] Determine the prefix identifier of the transfer order number according to the business type and the format preset in the system;
[0033] Obtain the date and time when the spare part transfer order is generated. The date and time include year, month, day, and time point, and process the date and time according to the preset time and date format to obtain the processed date and time;
[0034] Obtain the count of the spare part transfer orders generated in the transfer order increment counter, and use the count of the generated spare part transfer orders as the suffix number of the transfer order. Among them, the update frequency of the transfer order increment counter is updated according to the preset frequency;
[0035] Concatenate the transfer order number prefix identifier, the processed date and time, and the transfer order suffix number in sequence according to the pre-set transfer order number format to generate a spare part transfer order number.
[0036] Optionally, the total number of reviewers corresponding to multiple reviewers is determined through the following steps:
[0037] Obtain the review duration of each historical spare part transfer order among multiple historical spare part transfer orders within the target time period, select a target number of historical spare part transfer orders from the multiple historical spare part transfer orders to obtain a group of historical spare part transfer orders; calculate the average value of the multiple review durations corresponding to the group of historical spare part transfer orders to obtain the average review duration of each historical spare part transfer order.
[0038] Obtain the total number of transfer orders of multiple spare part transfer orders and the daily working hours of each reviewer, and calculate the total number of reviewers based on the total number of transfer orders, the average review duration of each historical spare part transfer order, and the daily working hours of each reviewer. Here, the daily working hours of each reviewer are in hours, and the total number of reviewers is an integer.
[0039] The present invention has the following beneficial effects:
[0040] 1. By using the historical spare part outbound data of each warehouse and the spare part inventory information of each warehouse, determine the spare part transfer orders for the spare part receiving warehouse, obtain the inventory situation of each warehouse, which helps to reduce inventory backlog, and can also transfer the out-of-stock spare part models in advance to prevent service interruptions caused by out-of-stock; send the spare part transfer orders to multiple review terminal devices, so that multiple reviewers corresponding to the multiple review terminal devices can review according to the pre-specified multiple review contents and give review results. Multiple reviewers review the same spare part transfer order simultaneously, realizing the parallel processing of the review process, greatly shortening the review time; different reviewers have different professional backgrounds and experiences, and they can review the spare part transfer order from different perspectives, and can timely discover potential problems and risks; when the review of the spare part transfer order is completed, generate the transfer outbound information corresponding to the spare part transfer order. If the spare part transfer order is reviewed and approved, generate the transfer outbound information, which can quickly start the outbound process, reduce the waiting time, improve the transfer efficiency, and automatically generate the transfer outbound information, which can reduce manual intervention and speed up the information processing speed; monitor the transfer transportation information. If it is monitored that the transfer transportation information is received, generate the transfer receipt information of the spare part transfer order, so that the transfer transportation information can be updated in real time and improve the timeliness of information processing; accept the transfer receipt information together with the transferred spare part model and transfer quantity corresponding to the spare part transfer order, which helps to ensure the accuracy and consistency of spare part transfer. The entire transfer process is reasonable and scientific, improving the transfer efficiency.
[0041] 2. By dividing into a central warehouse and edge warehouses, the actual demand of different warehouse types for each spare part model can be accurately matched; by analyzing the scarcity degree of spare part models, it is possible to avoid the insufficient supply caused by out-of-stock of spare part models with a higher scarcity degree, and it is also possible to avoid spare part models with a lower scarcity degree from occupying storage resources. By calculating the optimal inventory quantity in combination with the unit price of spare parts, the out-of-stock cost and inventory cost can be balanced; for spare part models with high scarcity and low substitutability, setting a higher safety inventory quantity can ensure sufficient inventory support in case of emergency; by dynamically updating the safety inventory quantity of each warehouse according to the number of inventory shortage messages corresponding to different inventory types, the adverse effects brought by inventory backlog or insufficient inventory can be avoided, and the warehousing cost can also be reduced; by selecting the target spare part receiving warehouse based on the historical spare part sales and out-of-stock quantity of out-of-stock spare part models, it is helpful to more accurately understand which warehouse has the highest demand for out-of-stock spare parts, and timely allocate to the warehouse corresponding to the highest demand, so as to improve the inventory turnover rate; by selecting the spare part shipping warehouse corresponding to the highest score from the distance scores corresponding to each spare part shipping warehouse as the target spare part shipping warehouse, it is beneficial to reduce the transportation cost and time cost and improve the logistics efficiency of allocation; by analyzing the sales data in the past time period to determine the allocation quantity, the sales data reveals the demand change law of spare parts within a certain time period. By understanding these laws, the demand quantity in the future period can be predicted more accurately, thus avoiding the occurrence of inventory backlog or out-of-stock, and optimizing the supply chain among multiple warehouses; by generating an allocation order number, it helps to ensure the uniqueness and traceability of the allocation order, and at the same time improve the allocation efficiency; by determining the number of auditors according to the total quantity of the allocation order and the average review time of each spare part allocation order, it helps to improve the review efficiency and review quality;
[0042] 3. By using the total weight of the allocated spare parts corresponding to each warehouse to match the allocated vehicle with the corresponding load capacity from multiple allocated vehicles for each warehouse, it is ensured that the allocated vehicle will not overload and travel, and the safety of the allocated spare parts is guaranteed; by using the warehouse address of each warehouse among multiple warehouses to determine the warehouse group within the preset range of the warehouse corresponding to the remaining load-carrying vehicles, it is beneficial for each allocated vehicle to make full use of the loading space and improve the transportation efficiency at the same time; by combining the transportation of the allocated spare parts of the target carpooling warehouse and the allocated spare parts corresponding to the warehouse corresponding to the remaining load-carrying vehicles, while reducing the transportation cost of the allocated vehicle, it can also ensure that the allocated spare parts can be delivered to each target spare part receiving warehouse in time. By assigning weights to the distance value score and the task urgency degree, the allocation decision is made reasonable, ensuring that the warehouses with a higher task urgency degree are given priority, and the transportation cost is also reduced; by determining the delivery priority corresponding to each warehouse in the combined warehouse group according to the total score corresponding to each warehouse, determining the delivery priority corresponding to each warehouse, and selecting the warehouse with the highest priority for priority delivery, the benefit cost and transportation cost are maximized. Description of the Drawings
[0043] In conjunction with the accompanying drawings and with reference to the following specific embodiments, the above and other features, advantages and aspects of the various embodiments of the present invention will become more apparent. Throughout the drawings, the same or similar reference numerals denote the same or similar elements. It should be understood that the drawings are schematic and the elements and elements are not necessarily drawn to scale.
[0044] Figure 1 is a flowchart of a spare part allocation method for multiple warehouses according to the present invention. Specific Embodiments
[0045] The present invention will be described in more detail below with reference to the accompanying drawings. Although some embodiments of the present invention are shown in the drawings, it should be understood that the present invention can be implemented in various forms and should not be construed as limited to the embodiments set forth herein. On the contrary, these embodiments are provided to more thoroughly and completely understand the present invention. It should be understood that the drawings and embodiments of the present invention are only for exemplary purposes and are not used to limit the scope of protection of the present invention.
[0046] In addition, it should be noted that for the sake of convenience of description, only the parts related to the relevant invention are shown in the drawings. Without conflict, the embodiments in the present invention and the features in the embodiments can be combined with each other.
[0047] It should be noted that the concepts such as "first" and "second" mentioned in the present invention are only used to distinguish different devices, modules or units, and are not used to limit the order or mutual dependence relationship of the functions performed by these devices, modules or units.
[0048] It should be noted that the modifications of "one" and "multiple" mentioned in the present invention are illustrative rather than restrictive. Those skilled in the art should understand that unless otherwise clearly specified in the context, it should be understood as "one or more".
[0049] The names of the messages or information exchanged between multiple devices of the present invention are only for illustrative purposes and are not used to limit the scope of these messages or information.
[0050] The present invention will be described in detail below with reference to the accompanying drawings and in conjunction with embodiments.
[0051] As Figure 1 shown, it is a flowchart of a spare part allocation method for multiple warehouses according to the present invention.
[0052] Step 101: Obtain the spare part inventory information and historical spare part outbound data of each warehouse among multiple warehouses. Among them, the spare part inventory information of each warehouse includes the warehouse name, warehouse address, multiple spare part models, and the inventory quantity corresponding to each spare part model; the historical spare part outbound data of each warehouse includes historical spare part transfer outbound data and historical spare part sales outbound data.
[0053] In some embodiments, the execution entity of the present invention can be a background server, which obtains the spare part inventory information and historical spare part outbound data of each warehouse among multiple warehouses from the background database. Specifically, the spare part inventory information of each warehouse can be: Warehouse name: Warehouse A, Warehouse address: XX Street, XX District, XX City, Multiple spare part models: (Spare part 1, Spare part 2, Spare part 3, Spare part 4), Inventory quantity corresponding to each spare part model: (Inventory quantity of spare part 1 is 50, Inventory quantity of spare part 2 is 80, Inventory quantity of spare part 3 is 60, Inventory quantity of spare part 4 is 30). The historical spare part transfer outbound data is the data of each spare part model transferred from one warehouse to another among the multiple spare part models corresponding to each warehouse. For example, a total of 60 spare part 1s were transferred from Warehouse A to other warehouses in the past month. The historical spare part sales outbound data is the data of each spare part model sold to users and shipped out from the corresponding warehouse among the multiple spare part models corresponding to each warehouse. For example, 70 spare part 2s were sold and shipped out in the past month.
[0054] Step 102: Analyze the inventory quantity corresponding to each spare part model among the multiple spare part models of each warehouse among multiple warehouses to obtain the out-of-stock spare part models of each warehouse, determine the warehouses corresponding to the out-of-stock spare part models as spare part receiving warehouses, and obtain a group of spare part receiving warehouses; according to the historical spare part outbound data of each warehouse and the spare part inventory information of each warehouse, determine the spare part transfer orders of each spare part receiving warehouse to obtain multiple spare part transfer orders corresponding to multiple spare part receiving warehouses; send each spare part transfer order to multiple audit terminal devices, so that multiple auditors corresponding to the multiple audit terminal devices perform audits according to a predefined multiple audit contents and give audit results. The audit results include audit passed and audit rejected. Among them, each audit terminal device corresponds to an auditor, and when the audit results of each auditor among the multiple auditors are audit passed, the audit is completed.
[0055] In some embodiments, the multiple spare part models corresponding to Warehouse A may be Spare Part 1 (Graphics Card 1) and Spare Part 2 (Memory Card 2). The inventory quantities of Graphics Card 1 and Memory Card 2 corresponding to Warehouse A are respectively compared with the safety inventory quantities of Graphics Card 1 and Memory Card 2. Herein, the "1" in Graphics Card 1 represents the model of the graphics card. If the inventory quantity (100) corresponding to Graphics Card 1 is less than the safety inventory quantity (150) of Graphics Card 1, then Graphics Card 1 is determined as an out-of-stock spare part model. If the inventory quantity (70) corresponding to Memory Card 2 is less than the safety inventory quantity (100) of Memory Card 2, then Memory Card 2 is determined as an out-of-stock spare part model. Warehouse A corresponding to Graphics Card 1 and Memory Card 2 is determined as the spare part receiving warehouse. Suppose there are three warehouses, Warehouse A, Warehouse B, and Warehouse C. The historical spare part outbound quantity of Spare Part 1 in Warehouse A is 100, the historical spare part outbound quantity of Spare Part 1 in Warehouse B is 200, and the historical spare part outbound quantity of Spare Part 1 in Warehouse C is 50. For Spare Part 1, the historical spare part outbound quantity of Warehouse B is the largest (200 per month), and the inventory quantity of Warehouse B is 100 (less than the safety inventory quantity). The inventory quantities of Warehouse A and Warehouse C are sufficient. The inventory quantity of Warehouse C is 500 (greater than the safety inventory quantity) and the historical spare part outbound quantity is the smallest. Among Warehouse A and Warehouse C, Warehouse C is closer to Warehouse B. Then, Spare Part 1 is transferred from Warehouse C to Warehouse B. Warehouse B is the target spare part receiving warehouse, and Warehouse C is the target spare part shipping warehouse. A spare part transfer order for Warehouse B is generated. The spare part transfer order 1 for Warehouse B includes the transferred spare part model: Spare Part 1, the transferred quantity corresponding to the transferred spare part model: 200, the target spare part receiving warehouse: Warehouse B, and the target spare part shipping warehouse: Warehouse C. The predefined multiple audit contents include auditing the transfer data, whether the transfer quantity complies with the transfer policy, and whether the transfer business process is standardized and legal. The spare part transfer order 1 is sent to the corresponding three audit computers so that the three auditors corresponding to the three audit computers can conduct audits simultaneously according to the predefined multiple audit contents and give audit results. When the audit result of each auditor among the three auditors is audit passed, the audit is completed. If the audit result of any one of the three auditors is audit rejected, wherein the audit rejection includes the reason for the audit rejection, after the audit rejection, a new spare part transfer order is generated based on the reason for the audit rejection and audited again.
[0056] Step 103, after the spare part transfer order is audited, generate the transfer outbound information corresponding to the spare part transfer order, and send the transfer outbound information corresponding to the spare part transfer order to the shipping terminal device corresponding to the target spare part shipping warehouse, so that the shipping transfer personnel corresponding to the shipping terminal device can perform transfer operations according to the transfer outbound information and upload the transfer transportation information corresponding to the transfer outbound information.
[0057] In some embodiments, if the review of the spare part transfer order of Warehouse B is approved, the transfer-out information of Warehouse B is automatically generated. The transfer-out information of Warehouse B corresponds to the information in Spare Part Transfer Order 1 of Warehouse B. The difference is that based on Spare Part Transfer Order 1, the specific transfer-out date and the names of multiple reviewers are added. For example, the transfer-out information is: Transfer-out date: 2024-XX-XX, Spare Part Transfer Order Number: DB20240801, Transferred Spare Part Model: Spare Part 1, Transferred Quantity: 200, Target Spare Part Delivery Warehouse: Warehouse C, Target Spare Part Receiving Warehouse: Warehouse B, Reviewers: Zhang San, Li Si. The shipping terminal device can be Smart Phone 1 for viewing the transfer-out information. The shipping transfer personnel corresponding to the target spare part delivery warehouse perform the transfer-out operation in the warehouse for the transferred spare part model (Spare Part 1) and the transferred quantity (200) corresponding to the transfer-out information. After the transfer-out operation is completed, the background server will automatically update the inventory quantity and automatically generate the transfer transportation information. The transfer transportation information can include: Transportation Method: Road Transportation, Transportation Vehicle: Use a "2.3-meter box truck" for transportation, Transportation Route: Starting from Warehouse C, via the G30 Expressway, arriving at Warehouse B; Driver Information: Driver's Name "Zhang Wei", Contact Information "138xxxxxx88", Transportation Status: "Shipped", "In Transit", "Received", Tracking Number: Logistics Tracking Number is "YTO123456789". The shipping transfer personnel corresponding to the shipping terminal device upload the transfer transportation information corresponding to the transfer-out information to the shipping terminal device.
[0058] Step 104, monitor the transfer transportation information. If it is monitored that the transportation status included in the transfer transportation information is "Received", generate the transfer receipt information of the spare part transfer order, and send the transfer receipt information of the spare part transfer order to the receiving terminal device corresponding to the target spare part receiving warehouse, so that the receiving transfer personnel corresponding to the receiving terminal device can accept the transferred spare part model and the transferred quantity corresponding to the transfer receipt information.
[0059] In some embodiments, if it is monitored that the transportation status included in the transfer transportation information is "Received", the transfer receipt information of the spare part transfer order is automatically generated. The transfer receipt information can be: Transfer Order Number: DB20240801, Receiving Date such as "August 1, 2024", Receiving Warehouse: Warehouse B, Consignee: such as "Warehouse Administrator Zhang San", Transferred Spare Part Model: Spare Part 1, Transferred Quantity: 200, Packaging Condition: such as "Packaging intact". The receiving terminal device can be Smart Phone 2 for viewing the receipt information. The receiving transfer personnel corresponding to Warehouse A accept the transferred spare part model and the transferred quantity corresponding to the transfer receipt information of the generated spare part transfer order.
[0060] In some embodiments, by using the historical spare part outbound data of each warehouse and the spare part inventory information of each warehouse to determine the spare part transfer order for the receiving warehouse, and obtaining the inventory status of each warehouse, it helps to reduce inventory backlogs, and can also transfer the out-of-stock spare part models in advance to prevent service interruptions caused by shortages; sending the spare part transfer order to multiple audit terminal devices, so that multiple auditors corresponding to the multiple audit terminal devices can conduct audits according to a pre-specified multiple audit contents and give audit results. Multiple auditors audit the same spare part transfer order simultaneously, realizing the parallel processing of the audit process, greatly shortening the audit time; different auditors have different professional backgrounds and experiences, and they can review the spare part transfer order from different perspectives, and can timely discover potential problems and risks; when the spare part transfer order is audited and completed, the transfer outbound information corresponding to the spare part transfer order is generated. If the spare part transfer order is audited and approved, the transfer outbound information is generated, which can quickly initiate the outbound process, reduce waiting time, improve transfer efficiency, and automatically generate the transfer outbound information, which can reduce manual intervention and speed up information processing; monitoring the transfer transportation information, if it is monitored that the transfer transportation information is received, the transfer receipt information of the spare part transfer order is generated, enabling the transfer transportation information to be updated in real time and improving the timeliness of information processing; verifying the transfer receipt information with the transferred spare part model and transfer quantity corresponding to the spare part transfer order helps to ensure the accuracy and consistency of spare part transfers. The entire transfer process is reasonable and scientific, improving transfer efficiency.
[0061] In some embodiments, in order to further solve Technical Problem 2 described in the background art section, that is, "the unreasonable setting of transfer strategies leads to low transfer efficiency among warehouses, chaotic supply chains, and reduced inventory turnover rates of multiple warehouses, unable to accurately match the actual needs of multiple warehouses, and also increases transfer costs and time", in some embodiments of the present invention, each warehouse among multiple warehouses is configured with a corresponding safety inventory quantity, and the safety inventory quantity corresponding to each spare part model of each warehouse is determined through the following steps:
[0062] Obtain the warehouse data of each warehouse and the attribute information of each spare part model among multiple warehouses. The warehouse data includes warehouse type, warehouse location information, and a list of project information supplied by the warehouse; the attribute information of each spare part model includes spare part scarcity, spare part unit price, spare part life, spare part replaceability, and replacement cost, where the warehouse type is a central warehouse or a peripheral warehouse;
[0063] In some embodiments, the warehouse data of each warehouse and the attribute information of each spare part model are obtained from the background database. Specifically, the warehouse data of Warehouse 1 includes the warehouse type (central warehouse), the warehouse location information (No. XX, XX District, XX City), and the list of project information supplied by the warehouse (Project A, Project B, Project C). The warehouse data of Warehouse 2 includes the warehouse type (peripheral warehouse), the warehouse location information (No. XX, XX District, XX City), and the list of project information supplied by the warehouse (Project B, Project D). Warehouse 1 (central warehouse): The attribute information of Spare Part 1 includes the scarcity level of the spare part (low), the unit price of the spare part (50 yuan), the service life of the spare part (5 years), the replaceability of the spare part (high), and the replacement cost (10 yuan). The attribute information of Spare Part 2 includes the scarcity level of the spare part (medium), the unit price of the spare part (120 yuan), the service life of the spare part (8 years), the replaceability of the spare part (medium), and the replacement cost (50 yuan). Warehouse 2 (peripheral warehouse): The attribute information of Spare Part A includes the scarcity level of the spare part (medium), the unit price of the spare part (800 yuan), the service life of the spare part (6 years), the replaceability of the spare part (low), and the replacement cost (800 yuan). Among them, the replacement cost refers to the additional cost required to use another spare part model (i.e., the substitute) to maintain normal operation when a certain spare part model cannot be directly obtained or is no longer produced. A central warehouse refers to a warehouse that occupies a core position in a supply chain. A central warehouse has a large storage capacity, a more comprehensive variety of spare part models, and a strong logistics distribution capacity. A peripheral warehouse refers to a warehouse located at the edge of the supply chain relative to the central warehouse. A peripheral warehouse is usually closer to the end user or the sales point, so it can quickly respond to market demand and reduce distribution time and costs.
[0064] Determine at least one warehouse with the warehouse type of peripheral warehouse among the multiple warehouses as a peripheral warehouse and divide it into the peripheral warehouse group, and determine at least one warehouse with the warehouse type of central warehouse among the multiple warehouses as a central warehouse and divide it into the central warehouse group;
[0065] In some embodiments, the above-mentioned Warehouse 2 is determined as a peripheral warehouse and divided into the peripheral warehouse group, and the above-mentioned Warehouse 1 is determined as a central warehouse and divided into the central warehouse group.
[0066] For each peripheral warehouse in the peripheral warehouse group, determine whether there is a central warehouse within the preset range of the peripheral warehouse according to the warehouse location information. If there is, determine the location attribute of the peripheral warehouse as secondary. If not, determine the location attribute of the peripheral warehouse as tertiary, and determine the location attribute of each central warehouse in the central warehouse group as primary;
[0067] In some embodiments, the location attribute is a classification label used to measure the importance of a warehouse in the supply chain. It is determined based on the location information of the warehouse and its relationship with other warehouses (especially the central warehouse). For Warehouse 2 (peripheral warehouse) located at No. XX, XX District, XX City, by querying the electronic map within the preset range of Warehouse 2 (for example, an area with a radius of 50 kilometers centered on Warehouse 2), it is found that Warehouse 3 (central warehouse) exists within this preset range. Therefore, we determine the location attribute of Warehouse 2 as secondary. If no central warehouse exists within the preset range of Warehouse 2, the location attribute of Warehouse 2 is determined as tertiary. The location attribute of Warehouse 1 is determined as primary.
[0068] For each warehouse among multiple warehouses, based on the item size, item importance level, and item operation time included in each item information in the item information list of warehouse supply, generate a spare part demand coefficient corresponding to each item. According to the spare part demand coefficient corresponding to each item, generate the cumulative value of the spare part demand coefficients of multiple items involved in the item information list of each warehouse.
[0069] In some embodiments, for the item information list of warehouse supply corresponding to Warehouse 1: In Project A, the item size is large, the item importance level is high, and the item operation time is 24 months; in Project B, the item size is medium, the item importance level is medium, and the item operation time is 12 months. Specifically, before generating the spare part demand coefficient corresponding to each item, assign a weight to each item information list. The item size (large = 3, medium = 2, small = 1), the item importance level (high = 3, medium = 2, low = 1), and the item operation time (per month = 0.1, directly multiplied by the number of months). The total weight is the item size (3) + the item size (3) + the item operation time (1) = 7. Calculate the spare part demand coefficient corresponding to Project A through the weight. Then, the spare part demand coefficient corresponding to Project A = (item size + item importance level + item operation time) ÷ total weight = (3 + 3 + 2.4) ÷ 7 = 1.20; the spare part demand coefficient corresponding to Project B = (2 + 2 + 1.2) ÷ 7 = 0.74. Then, the cumulative value of the spare part demand coefficients of multiple items corresponding to Warehouse 1 = the spare part demand coefficient corresponding to Project A + the spare part demand coefficient corresponding to Project B = 1.20 + 0.74 = 1.94. The spare part demand coefficient is a numerical value determined by the item size, item importance level, and item operation time, and is used to represent the demand degree of each item for spare parts. The higher the spare part demand coefficient, the greater the demand of the item for spare parts.
[0070] For each warehouse among multiple warehouses, generate a warehouse stocking coefficient corresponding to each warehouse based on the location attribute and the cumulative value of the spare part demand coefficient.
[0071] In some embodiments, before generating the inventory preparation coefficient for each warehouse, an addition coefficient is set for each of the first, second, and third levels corresponding to the location attribute (the addition coefficient can be adjusted according to the actual situation), specifically, the first level (1.5), the second level (1.2), and the third level (0.8). For the location attribute corresponding to Warehouse 1 (central warehouse: first level) and the cumulative value of the spare part demand coefficient corresponding to Warehouse 1 (1.94), the inventory preparation coefficient corresponding to Warehouse 1 = the location attribute corresponding to Warehouse 1 * the cumulative value of the spare part demand coefficient corresponding to Warehouse 1 = 1.5 * 1.94 = 2.91.
[0072] Generate the spare part inventory preparation coefficient for each spare part model according to the attribute information of each spare part model in each warehouse, including the scarcity degree of the spare part, the unit price of the spare part, the lifespan of the spare part, the replaceability of the spare part, and the replacement cost.
[0073] In some embodiments, a weight is assigned to each item in the attribute information of each spare part model: scarcity degree of the spare part (high = 0.3, medium = 0.2, low = 0.1), unit price of the spare part (0.2, the unit price of the spare part may need to be adjusted inversely because a high price does not necessarily mean a higher inventory preparation demand), lifespan of the spare part (0.2), replaceability of the spare part (high = -0.3, medium = -0.2, low = -0.1), and replacement cost (0.2).
[0074] In some embodiments, for Warehouse 1 (central warehouse): the attribute information of Spare Part 1 includes the scarcity degree of the spare part (low), the unit price of the spare part ($50), the lifespan of the spare part (5 years), the replaceability of the spare part (high), and the replacement cost ($10). Then the spare part inventory preparation coefficient of Spare Part 1 = 0.1 + (50 * 0.2) + (5 * 0.2) + (-0.3) + (10 * 0.2) = 12.8. The spare part inventory preparation coefficient is determined by the scarcity degree of the spare part, the unit price of the spare part, the lifespan of the spare part, the replaceability of the spare part, and the replacement cost of each spare part model.
[0075] For each spare part model in each warehouse, generate the safety stock quantity corresponding to each warehouse according to the spare part inventory preparation coefficient of the spare part model, the inventory preparation coefficient of the corresponding warehouse, and the benchmark safety stock quantity corresponding to each spare part model.
[0076] In some embodiments, the benchmark safety stock quantity corresponding to each spare part model is a buffer stock quantity reserved to cope with uncertain factors. As an example, the benchmark safety stock quantity corresponding to Spare Part 1 in Warehouse 1 is 100 pieces.
[0077] In some embodiments, for the safety stock quantity corresponding to Warehouse 1 = the spare part inventory preparation coefficient of Spare Part 1 in Warehouse 1 * the inventory preparation coefficient of Warehouse 1 * the benchmark safety stock quantity corresponding to Spare Part 1 = 12.8 * 2.91 * 100 = 3724.8 pieces (rounded to 3725 pieces).
[0078] Optionally, the safety stock quantity corresponding to each spare part model in each warehouse is dynamically updated through the following steps:
[0079] Within a preset time interval after generating the safety stock quantity corresponding to each warehouse, when the actual stock quantity of each spare part model in each warehouse is less than the configured safety stock quantity, a stock emergency message corresponding to the warehouse is generated. The stock emergency message includes the warehouse name, the emergency spare part model, and the emergency time, obtaining a set of stock emergency messages corresponding to the preset time interval;
[0080] In some embodiments, assume that the preset time interval for generating the safety stock quantity corresponding to Warehouse 1 is from October 1, 2023 to October 31, 2023. When it is October 15, 2023, the actual stock quantity of Spare Part 1 (3600) is less than the configured safety stock quantity (3725), and a stock emergency message 1 corresponding to Warehouse 1 is generated. Specifically, the stock emergency message 1 corresponding to Warehouse 1 includes the warehouse name (Warehouse 1), the emergency spare part model (Spare Part 1), and the emergency time (October 15, 2023).
[0081] In some embodiments, when it is October 20, 2023, the actual stock quantity of Spare Part 2 (590) is less than the configured safety stock quantity (600), and a stock emergency message 2 corresponding to Warehouse 1 is generated. Specifically, the stock emergency message 2 corresponding to Warehouse 1 includes the warehouse name (Warehouse 1), the emergency spare part model (Spare Part 2), and the emergency time (October 20, 2023). The set of stock emergency messages corresponding to the preset time interval includes stock emergency message 1 and stock emergency message 2 corresponding to Warehouse 1.
[0082] For each central warehouse in the central warehouse group, if the number of stock emergency messages in the set of stock emergency messages corresponding to the central warehouse is greater than the first preset quantity threshold, the safety stock quantity corresponding to the central warehouse is increased;
[0083] In some embodiments, for each central warehouse (Warehouse 1) in the central warehouse group, if the number of stock emergency messages (8) in the set of stock emergency messages corresponding to Warehouse 1 is greater than the first preset quantity threshold (5), the safety stock quantity corresponding to Warehouse 1 is increased by 20%. Specifically, the safety stock quantity of Spare Part 1 is increased to 3725 * 1.2 = 4470, and the safety stock quantity of Spare Part 2 is increased to 600 * 1.2 = 720.
[0084] For each edge warehouse in the edge warehouse group, if the number of inventory emergency messages in the inventory emergency message set corresponding to the edge warehouse is zero, then the safety inventory quantity corresponding to the edge warehouse is reduced. If the number of inventory emergency messages in the inventory emergency message set corresponding to the edge warehouse is non-zero and less than or equal to the second preset quantity threshold, then the safety inventory quantity corresponding to the edge warehouse remains unchanged. If the number of inventory emergency messages in the inventory emergency message set corresponding to the edge warehouse is greater than the second preset quantity threshold, then the safety inventory quantity corresponding to the edge warehouse is increased; wherein, the first preset quantity threshold is greater than the second preset quantity threshold.
[0085] In some embodiments, for each edge warehouse (Warehouse 2) in the edge warehouse group, if the number of inventory emergency messages in the inventory emergency message set corresponding to Warehouse 2 is zero, then the safety inventory quantity corresponding to Warehouse 2 is reduced, and the safety inventory quantity of spare part A in Warehouse 2 is reduced by 10%. If the safety inventory quantity of spare part A is 50, then the safety inventory quantity of spare part A after reduction is 50 * 0.9 = 45.
[0086] In some embodiments, if the number of inventory emergency messages (1) in the inventory emergency message set corresponding to Warehouse 2 is non-zero and less than or equal to the second preset quantity threshold (2), then the safety inventory quantity corresponding to Warehouse 2 remains unchanged. If the number of inventory emergency messages (3) in the inventory emergency message set corresponding to Warehouse 2 is greater than the second preset quantity threshold (2), then the safety inventory quantity corresponding to Warehouse 2 is increased by 10%; then the safety inventory quantity of spare part A in Warehouse 2 after reduction is 50 * 1.1 = 55.
[0087] Optionally, the spare part transfer order of each spare part receiving warehouse includes a target spare part receiving warehouse and a target spare part shipping warehouse, and the target spare part receiving warehouse and the target spare part shipping warehouse are determined through the following steps:
[0088] Compare the inventory quantity of each spare part model corresponding to each warehouse among multiple warehouses with the safety inventory quantity of each spare part model. If the inventory quantity of each spare part model is less than the safety inventory quantity of each spare part model, then determine the spare part model with the inventory quantity less than the safety inventory quantity as the out-of-stock spare part model, obtain the out-of-stock spare part model group corresponding to the warehouse, and determine the warehouse corresponding to the out-of-stock spare part model as the spare part receiving warehouse and add it to the spare part receiving warehouse group;
[0089] Based on the historical spare part sales and outbound data of each out-of-stock spare part model in the out-of-stock spare part model group of each spare part receiving warehouse in the spare part receiving warehouse group during the target time period, obtain the historical spare part sales and outbound quantity of each out-of-stock spare part model; according to the historical spare part sales and outbound quantity of each out-of-stock spare part model, determine the spare part receiving warehouse sequence corresponding to each out-of-stock spare part model, and determine the spare part receiving warehouse with the largest historical spare part sales and outbound quantity in the spare part receiving warehouse sequence corresponding to each out-of-stock spare part model as the target spare part receiving warehouse corresponding to each out-of-stock spare part model;
[0090] If the inventory quantity of the out-of-stock spare part model corresponding to the target spare part receiving warehouse in multiple warehouses is greater than the safety inventory quantity of the out-of-stock spare part model, then determine the warehouse with the inventory quantity greater than the safety inventory quantity as the spare part shipping warehouse and add it to the spare part shipping warehouse group, where at least one spare part shipping warehouse corresponds to one out-of-stock spare part model;
[0091] According to the warehouse address of each spare part shipping warehouse in the spare part shipping warehouse group, determine the distance value between each spare part shipping warehouse and the target spare part receiving warehouse, score the distance value between each spare part shipping warehouse and the target spare part receiving warehouse according to the preset rules, and determine the score corresponding to each spare part shipping warehouse; select the spare part shipping warehouse corresponding to the highest score from the scores corresponding to each spare part shipping warehouse as the target spare part shipping warehouse corresponding to each out-of-stock spare part model.
[0092] In some embodiments, if the inventory quantity (100) of spare part 1 in warehouse A is less than the safety stock quantity (150) of spare part 1, then spare part 1 is determined as an out-of-stock spare part model; if the inventory quantity (70) of spare part 2 in warehouse A is less than the safety stock quantity (100) of spare part 2, then spare part 2 is determined as an out-of-stock spare part model; warehouse A is determined as the spare part receiving warehouse, and the out-of-stock spare part model group corresponding to warehouse A is spare part 1 and spare part 2. In warehouse B, if the inventory quantity (90) of spare part 1 is less than the safety stock quantity (150) of spare part 1, then spare part 1 is determined as an out-of-stock spare part model; if the inventory quantity (60) of spare part 3 in warehouse B is less than the safety stock quantity (100) of spare part 3, then spare part 3 is determined as an out-of-stock spare part model, and warehouse B is determined as the spare part receiving warehouse, and the out-of-stock spare part model group corresponding to warehouse B is spare part 1 and spare part 3. If the inventory quantity (300) of spare part 1 in warehouse C is greater than the safety stock quantity (150) of spare part 1, and the inventory quantity (400) of spare part 3 is greater than the safety stock quantity (100) of spare part 3. If the inventory quantity (350) of spare part 1 in warehouse D is greater than the safety stock quantity (150) of spare part 1, the inventory quantity (400) of spare part 2 is greater than the safety stock quantity (100) of spare part 2, and the inventory quantity (300) of spare part 4 is greater than the safety stock quantity (150) of spare part 4. Warehouse A and warehouse B are added to the spare part receiving warehouse group, where the safety stock quantity refers to the minimum inventory quantity maintained to cope with demand fluctuations or supply chain disruptions.
[0093] In some embodiments, the historical spare part sales and outbound data of the out-of-stock spare part model groups (spare part 1 and spare part 2) of warehouse A and the out-of-stock spare part model group (spare part 1 and spare part 3) of warehouse B in the spare part receiving warehouse group in the target time period (the previous quarter, i.e., 3 months) are as follows: For warehouse A: For spare part 1: The sales and outbound quantity in January = 50 pieces, the sales and outbound quantity in February = 60 pieces, and the sales and outbound quantity in March = 45 pieces; for spare part 2: The sales and outbound quantity in January = 30 pieces, the sales and outbound quantity in February = 40 pieces, and the sales and outbound quantity in March = 35 pieces. The total sales and outbound quantity of spare part 1 in warehouse A = 50 + 60 + 45 = 155 pieces; the total sales and outbound quantity of spare part 2 in warehouse A = 30 + 40 + 35 = 105 pieces. For warehouse B: For spare part 1: The sales and outbound quantity in January = 20 pieces, the sales and outbound quantity in February = 25 pieces, and the sales and outbound quantity in March = 30 pieces; for spare part 3: The sales and outbound quantity in January = 15 pieces, the sales and outbound quantity in February = 20 pieces, and the sales and outbound quantity in March = 18 pieces. The total sales and outbound quantity of spare part 1 in warehouse B = 20 + 25 + 30 = 75 pieces; the total sales and outbound quantity of spare part 3 in warehouse B = 15 + 20 + 18 = 53 pieces.
[0094] In some embodiments, for each out-of-stock spare part model, a spare part receiving warehouse containing the above out-of-stock spare part model is selected from the spare part receiving warehouse group, and the spare part receiving warehouses containing the above out-of-stock spare part model are sorted by the historical spare part sales and outbound quantity of the above out-of-stock spare part model to obtain a spare part receiving warehouse sequence corresponding to each out-of-stock spare part model; for spare part 1, spare part receiving warehouses containing spare part 1 are selected from Warehouse A and Warehouse B, and both Warehouse A and Warehouse B contain spare part 1. The historical spare part sales and outbound quantity of spare part 1 in Warehouse A is 155 pieces, and the historical spare part sales and outbound quantity of spare part 1 in Warehouse B is 75 pieces. The spare part receiving warehouse sequence includes Warehouse A and Warehouse B. Among the spare part receiving warehouse sequence (Warehouse A, Warehouse B) corresponding to spare part 1, the historical spare part sales and outbound quantity corresponding to spare part 1 in Warehouse A is the largest, and Warehouse A is determined as the target spare part receiving warehouse corresponding to spare part 1. Specifically, the target spare part receiving warehouse refers to the receiving warehouse determined due to the shortage of spare part 1. For the out-of-stock spare part model spare part 2, if the spare part receiving warehouses containing spare part 2 corresponding to spare part 2 are selected from the spare part receiving warehouse group for sorting to obtain a spare part receiving warehouse sequence, the target spare part receiving warehouse for spare part 2 is selected from the spare part receiving warehouse sequence. Therefore, the target spare part receiving warehouse changes with the change of the out-of-stock spare part model.
[0095] In some embodiments, the inventory quantity of spare part 1 in Warehouse C (300) is greater than the safety inventory quantity of spare part 1 (150), and the inventory quantity of spare part 1 in Warehouse D (350) is greater than the safety inventory quantity of spare part 1 (150). Then, both Warehouse C and Warehouse D are determined as spare part shipping warehouses, and Warehouse C and Warehouse D are in the spare part shipping warehouse group. By the warehouse address of each warehouse, the distances from Warehouse C and Warehouse D to Warehouse A are calculated respectively, and the distance value from Warehouse C to the target spare part receiving warehouse (Warehouse A) is 8 kilometers, and the distance value from Warehouse D to the target spare part receiving warehouse (Warehouse A) is 16 kilometers. If Warehouse C and Warehouse D are scored according to a preset rule (90 points within 10 kilometers (including 10 kilometers), 80 points for 10 - 30 (excluding 30 kilometers) kilometers, 60 points for 30 - 50 kilometers (excluding 50 kilometers)), then Warehouse C gets 90 points and Warehouse D gets 80 points, and Warehouse C is used as the target spare part shipping warehouse. Specifically, the target spare part shipping warehouse refers to the shipping warehouse determined for the out-of-stock spare part model (spare part 1) corresponding to the target spare part receiving warehouse.
[0096] Optionally, the spare part transfer order includes a transfer quantity, and the transfer quantity is determined through the following steps:
[0097] Generate a spare part sales volume chart for the out-of-stock spare part models corresponding to the target spare part delivery warehouse based on the historical spare part sales and outbound quantities of the out-of-stock spare part models corresponding to the target spare part delivery warehouse; divide the spare part sales volume chart to obtain multiple spare part sales sub-charts corresponding to multiple periods, where each spare part sales sub-chart for a period shows the sales volume of the out-of-stock spare part models corresponding to the target spare part delivery warehouse within the target time period, with the horizontal axis being time and the vertical axis being the sales volume of the out-of-stock spare part models; perform superposition analysis on each spare part sales sub-chart for each period among the multiple spare part sales sub-charts corresponding to multiple periods to obtain the sales trend at each historical time point of the out-of-stock spare part models and the multiple sales volumes corresponding to each historical time point.
[0098] Determine the time points corresponding to the spare part transfer orders for each spare part receiving warehouse, and analyze the sales trend and multiple sales volumes at the historical time points corresponding to the time points. If the sales trend at the historical time points of multiple periods corresponding to the time point is an increasing trend, then select the highest sales volume among the multiple sales volumes at the historical time points corresponding to the multiple periods as the first estimated demand quantity; if the sales trend at the historical time points of multiple periods of the time point is a declining trend, then select the lowest sales volume among the multiple sales volumes at the historical time points corresponding to the multiple periods as the second estimated demand quantity.
[0099] Based on the inventory quantity, safety inventory quantity, and the first estimated demand quantity or the second estimated demand quantity corresponding to the out-of-stock spare part models corresponding to the target spare part delivery warehouse, obtain the transfer quantity of the out-of-stock spare part models corresponding to the spare part transfer order for the target spare part delivery warehouse.
[0100] In some embodiments, based on the sales and outbound quantities of spare part 1 in warehouse C in the past three years (2021, 2022, 2023), generate a spare part sales volume chart for spare part 1 in warehouse C. The horizontal axis of the spare part sales volume chart is time, and the vertical axis is the sales volume of spare part 1; divide the spare part sales volume chart of spare part 1 in the past three years into three spare part sales sub-charts corresponding to three periods (one year for each period). Each spare part sales sub-chart for a period represents the sales and outbound quantity of spare part 1 at each historical time point corresponding to one of the past three years. Superimpose and analyze the spare part sales sub-charts of spare part 1 in 2021, 2022, and 2023 to obtain the sales trend at each historical time point (which can be each historical month) corresponding to the three periods (2021, 2022, 2023) of spare part 1 and the multiple sales volumes at each historical time point (which can be each historical month) in 2021, 2022, and 2023.
[0101] In some embodiments, obtain the time point for determining the target spare part receiving warehouse in the spare part transfer order for each spare part receiving warehouse. Suppose the time point for determining the target spare part receiving warehouse (Warehouse C) in the spare part transfer order is July. Then, analyze the sales trends of spare part 1 in July corresponding to 2021, 2022, and 2023 respectively, and the multiple sales volumes in July corresponding to 2021, 2022, and 2023 respectively. If the overall sales trend of spare part 1 in Warehouse C in July corresponding to 2021, 2022, and 2023 is increasing, and the sales volumes in July each year are: 200 pieces in 2021, 230 pieces in 2022, and 270 pieces in 2023, then take 270 pieces as the first estimated demand quantity. Then, the transfer quantity for Warehouse C = inventory quantity (500) - safety stock quantity (100) - estimated demand quantity (270) = 130 pieces; among them, the first estimated demand quantity is the estimated demand quantity determined when the overall sales trend at the historical time points of multiple cycles is an increasing trend. Suppose the time point for determining the target spare part receiving warehouse in the spare part transfer order is November. Then, analyze the sales trends of spare part 1 in November corresponding to 2021, 2022, and 2023 respectively, and the sales volumes in November corresponding to 2021, 2022, and 2023 respectively. If the overall sales trend of spare part 1 in Warehouse C in November corresponding to 2021, 2022, and 2023 is a downward trend, and the sales volumes in November each year are: 150 pieces in 2021, 100 pieces in 2022, and 120 pieces in 2023, then take 100 pieces as the estimated demand quantity. Then, the transfer quantity for Warehouse C = inventory quantity (500) - safety stock quantity (100) - estimated demand quantity (100) = 300 pieces; among them, the second estimated demand quantity is the estimated demand quantity determined when the overall sales trend at the historical time points corresponding to multiple cycles is a downward trend.
[0102] After completing the determination of the target spare part receiving warehouse (Warehouse A), the target spare part shipping warehouse (Warehouse C), and the transfer quantity for the target spare part shipping warehouse corresponding to spare part 1, the inventory quantity of spare part 1 in Warehouse C is the inventory quantity before transfer minus the transfer quantity to the corresponding target spare part receiving warehouse (Warehouse A).
[0103] Exclude Warehouse A from the spare part receiving warehouse sequence (Warehouse A, Warehouse B) to obtain the updated spare part receiving warehouse sequence (Warehouse B). Designate Warehouse B as the target spare part receiving warehouse corresponding to Spare Part 1. If the inventory quantity of Warehouse C is still greater than the safety stock quantity corresponding to Spare Part 1 after the transfer to Warehouse A, then add Warehouse C and Warehouse D to the spare part shipping warehouse group. Select a spare part shipping warehouse from Warehouse C and Warehouse D as the target spare part shipping warehouse for Warehouse B according to the steps of selecting the target spare part shipping warehouse for Warehouse A as described above. If the inventory quantity of Warehouse C is less than the safety stock quantity corresponding to Spare Part 1 after the transfer to Warehouse A, then designate Warehouse D as the target spare part shipping warehouse.
[0104] For another out-of-stock spare part model (Spare Part 2) in Warehouse A, determine the target spare part receiving warehouse, the target spare part shipping warehouse, and the transfer quantity of the target spare part shipping warehouse for Spare Part 2 in Warehouse A according to the method of determining the target spare part receiving warehouse, the target spare part shipping warehouse, and the transfer quantity of the target spare part shipping warehouse for Spare Part 1. And so on for the out-of-stock spare part models corresponding to other spare part receiving warehouses to ensure that the transfer is completed for each spare part receiving warehouse.
[0105] Optionally, the spare part transfer order includes a spare part transfer order number, which is determined through the following steps:
[0106] Determine the prefix identifier of the transfer order number according to the business type and the format preset in the system;
[0107] Obtain the date and time when the spare part transfer order is generated. The date and time include year, month, day, and time point. Process the date and time according to the preset time and date format to obtain the processed date and time;
[0108] Obtain the count of the spare part transfer orders generated in the transfer order increment counter, and use the count of the generated spare part transfer orders as the suffix number of the transfer order. Among them, the update frequency of the transfer order increment counter is updated according to the preset frequency;
[0109] Concatenate the prefix identifier of the transfer order number, the processed date and time, and the suffix number of the transfer order in sequence according to the preset transfer order number format to generate the spare part transfer order number.
[0110] In some embodiments, the business type of the spare part transfer order is transfer. The format preset in the system is that the first letter of the business type is capitalized. The transfer order number prefix identifier is an identifier used to identify the business type corresponding to the spare part transfer order. For example, the transfer order number prefix identifier for the spare part transfer order is DB. Obtain the date and time when the spare part transfer order is generated from the system. If the date and time is May 2, 2024, the preset time and date format is to only retain the numerical part, and if the year and month parts have less than two digits, add zeros in front of the numbers to make up. After processing May 2, 2024 according to the preset format, it becomes 20240502. The transfer order increment counter is used to incrementally count multiple transfer orders created within the target time period. The update frequency of the transfer order increment counter is once a day, and the target time period is the current day. Obtain the count of spare part transfer orders generated on the current day from the transfer order increment counter; if the count of the generated spare part transfer orders is 006, the transfer order suffix number is 006. The transfer order suffix number is the last three digits in the spare part transfer order number. The preset transfer order number format is: transfer order number prefix identifier + processed date and time + transfer order suffix number (the “+” in the specific transfer order number is omitted), then the concatenated spare part transfer order number is DB20240502006.
[0111] Optionally, the total number of auditors corresponding to multiple auditors is determined through the following steps:
[0112] Obtain the review duration of each historical spare part transfer order among multiple historical spare part transfer orders within the target time period. Select a target number of historical spare part transfer orders from the multiple historical spare part transfer orders to obtain a group of historical spare part transfer orders; calculate the average value of the review durations corresponding to the group of historical spare part transfer orders to obtain the average review duration of each historical spare part transfer order.
[0113] Obtain the total number of transfer orders of multiple spare part transfer orders and the daily working hours of each auditor. Calculate the total number of transfer orders, the average review duration of each historical spare part transfer order, and the daily working hours of each auditor to obtain the total number of auditors. Among them, the daily working hours of each auditor are in hours, and the total number of auditors is an integer.
[0114] In some embodiments, a plurality of historical spare part transfer orders for the past three months are obtained from the background database. The total number of historical spare part transfer orders in the past three months is 100. 30 historical spare part transfer orders are randomly selected as samples for analysis (i.e., the target quantity is 30). The transfer order 1 takes 2.5 hours, the transfer order 2 takes 1.5 hours, the transfer order 3 takes 2.0 hours, the transfer order 4 takes 1.5 hours... the transfer order 30 takes 2.5 hours. Add up the total durations of transfer orders 1 to 30. Assuming the total duration is T, if the total review time for the above 30 spare part transfer orders is 100 hours, then the average review duration for each historical spare part transfer order is 100÷30 = 3.33 hours.
[0115] In some embodiments, obtain the total number of transfer orders (70) of a plurality of spare part transfer orders from the background database, and obtain the daily working hours of each reviewer as 8 hours from the attendance system. The calculation formula for the number of reviewers is: the total number of transfer orders multiplied by the average review duration of each historical spare part transfer order = 70 * 3.33 = 233.1 hours, 233.1÷8 = 29.1375. Since the number of people cannot be a decimal, round up to the nearest integer to ensure there are enough reviewers to complete the work. Then select 30 people to review the spare part transfer orders for one day.
[0116] In some embodiments, through the division of the central warehouse and the edge warehouse, the actual demand of different warehouse types for each spare part model can be accurately matched; by analyzing the scarcity degree of the spare part models, it is possible to avoid the insufficient supply caused by out-of-stock of spare part models with a higher scarcity degree, and it is also possible to avoid spare part models with a lower scarcity degree from occupying storage resources. By combining the unit price of the spare parts to calculate the optimal inventory quantity, the out-of-stock cost and the inventory cost can be balanced; for spare part models with high scarcity and low substitutability, setting a higher safety inventory quantity can ensure sufficient inventory support in case of emergency; by dynamically updating the safety inventory quantity of each warehouse according to the number of inventory emergency messages corresponding to different inventory types, the adverse effects brought by inventory backlog or insufficient inventory can be avoided, and the warehousing cost can also be reduced; by selecting the target spare part receiving warehouse based on the historical spare part sales and out-of-stock quantity of the out-of-stock spare part models, it is helpful to more accurately understand which warehouse has the highest demand for out-of-stock spare parts, and to allocate goods to the warehouse corresponding to the highest demand in a timely manner, thereby improving the inventory turnover rate; selecting the spare part shipping warehouse with the highest score from the distance scores corresponding to each spare part shipping warehouse as the target spare part shipping warehouse is beneficial to reducing the transportation cost and time cost and improving the logistics efficiency of allocation; by analyzing the sales data in the past period to determine the allocation quantity, the sales data reveals the demand change law of the spare parts within a certain period. By understanding these laws, the demand quantity in the future period can be predicted more accurately, thus avoiding the occurrence of inventory backlog or out-of-stock situations, and optimizing the supply chain among multiple warehouses; by generating the allocation order number, it helps to ensure the uniqueness and traceability of the allocation order, and at the same time improves the allocation efficiency; by determining the number of auditors according to the total quantity of the allocation order and the average review time of each spare part allocation order, it helps to improve the review efficiency and review quality.
[0117] In some embodiments, in order to further solve Technical Problem 3 described in the background art section, that is, "in the allocation and transportation process, if the transportation decision is unreasonable, it will directly lead to many problems such as low transportation efficiency, increased cost, and damage to goods", in some embodiments of the present invention, it further includes:
[0118] Obtain the vehicle information of multiple allocation vehicles, where the vehicle information includes the vehicle type, and one vehicle type corresponds to one load capacity; obtain the weight of the allocated spare part models corresponding to the spare part allocation orders of each warehouse, and obtain the total weight of the allocated spare parts corresponding to each warehouse according to the weight and the allocation quantity of the allocated spare part models corresponding to the spare part allocation orders of each warehouse; match the allocation vehicles with the corresponding load capacity for each warehouse from multiple allocation vehicles according to the total weight of the allocated spare parts corresponding to each warehouse.
[0119] Analyze the remaining load capacity of the transfer vehicles corresponding to each warehouse. If the remaining load capacity of the transfer vehicles corresponding to each warehouse is greater than the preset remaining load capacity, determine the transfer vehicles with the remaining load capacity greater than the preset remaining load capacity as the remaining load vehicles, and add the warehouses corresponding to the remaining load vehicles to the merged warehouse group;
[0120] According to the warehouse addresses of each warehouse in multiple warehouses, determine the warehouse groups within the preset range of the warehouses corresponding to the remaining load vehicles. Match the total weight of the transferred spare parts corresponding to each warehouse in the warehouse groups within the preset range with the remaining load capacity of the remaining load vehicles. Determine the warehouses with the total weight of the transferred spare parts less than or equal to the remaining load capacity of the remaining load vehicles as the carpooling warehouses to obtain the carpooling warehouse group. Sort the distance values from the target spare parts receiving warehouses corresponding to each warehouse in the carpooling warehouse group to the target spare parts receiving warehouses corresponding to the remaining load vehicles to obtain the carpooling warehouse sequence. Select the target spare parts receiving warehouse corresponding to the carpooling warehouse with the shortest distance to the target spare parts receiving warehouse corresponding to the warehouse of the remaining load vehicle as the target carpooling warehouse and add the target carpooling warehouse to the merged warehouse group; Send the spare parts transfer orders corresponding to each warehouse in the merged warehouse group to the vehicle terminal device corresponding to the remaining load vehicle, so that the vehicle personnel corresponding to the vehicle terminal device can transport the transferred spare parts models corresponding to each warehouse in the merged warehouse group in a combined manner and pick up the goods from each warehouse in the merged warehouse group in the order of picking up. The order of picking up is determined according to the order of joining the merged warehouse group;
[0121] Obtain the distance value from the target carpooling warehouse in the merged warehouse group to the target spare parts receiving warehouse corresponding to the target carpooling warehouse and the distance value from the target carpooling warehouse to the target spare parts receiving warehouse corresponding to the warehouse of the remaining load vehicle. Score the distance value from the target carpooling warehouse in the merged warehouse group to the target spare parts receiving warehouse corresponding to the target carpooling warehouse and the distance value from the target carpooling warehouse to the target spare parts receiving warehouse corresponding to the warehouse of the remaining load vehicle to obtain the distance value score of each warehouse; Obtain the task urgency of the target carpooling warehouse in the merged warehouse group and the task urgency of the warehouse corresponding to the remaining load vehicle to obtain the task urgency of each warehouse;
[0122] Configure weights for the distance value score and the task urgency respectively, and perform weighted summation on the distance value score of each warehouse in the merged warehouse group and the task urgency of each warehouse through the weights to obtain the total score corresponding to each warehouse in the merged warehouse group. Determine the delivery priority corresponding to each warehouse in the merged warehouse group according to the total score corresponding to each warehouse.
[0123] In some embodiments, vehicle information of multiple allocated vehicles is obtained from an allocation vehicle management system. The vehicle information includes vehicle types, which are divided into small vehicles, medium-sized vehicles, and large vehicles. Assume that the load capacities of small vehicles, medium-sized vehicles, and large vehicles are within 1000 kilograms, 1000 - 3000 kilograms, and 3000 - 7000 kilograms respectively. When the spare part model allocated by Warehouse B is spare part X, the weight of spare part X (40 kilograms) is obtained from the background database. If the allocation quantity is 100, the total weight of the allocated spare parts in Warehouse B is 4000 kilograms, then a large vehicle is selected. Assume that there is still a remaining load capacity of 3000 kilograms after the large vehicle finishes loading Warehouse B, and the preset remaining load capacity is 1000 kilograms, then the large vehicle is determined as the vehicle with remaining load, and Warehouse B is added to the merged warehouse group. Warehouses within the preset range (within 10 kilometers) of Warehouse B are queried in the electronic map. If Warehouses C, D, and E are queried within the preset range, then Warehouses C, D, and E are added to the warehouse group within the preset range. If the total weights of the allocated spare parts corresponding to Warehouses C, D, and E are 1500 kilograms, 2800 kilograms, and 3500 kilograms respectively, then Warehouses C and D are determined as carpooling warehouses. Assume that the target spare part receiving warehouse of Warehouse B is Warehouse X, the target spare part receiving warehouse of Warehouse C is Warehouse Y, the distance between Warehouse Y and Warehouse X is 30 kilometers, the target spare part receiving warehouse of Warehouse D is Warehouse Z, and the distance between Warehouse Z and Warehouse X is 12 kilometers. Sort Warehouses C and D according to the distances from the target spare part receiving warehouses of Warehouse C and Warehouse D to Warehouse X. The obtained carpooling warehouse sequence includes Warehouses C and D. Since the target spare part receiving warehouse of Warehouse D is closer to Warehouse X, Warehouse D is determined as the target carpooling warehouse and added to the merged warehouse group. The spare part transfer orders of Warehouse B and Warehouse D are sent to the in-vehicle mobile phone of the large vehicle. The vehicle personnel corresponding to the in-vehicle mobile phone of the large vehicle transport the allocated spare parts of Warehouse B and Warehouse D together. Since Warehouse B is added to the merged warehouse group first, pick up the goods from Warehouse B first, and then pick up the goods from Warehouse D.
[0124] In some embodiments, after the vehicle personnel corresponding to the large vehicle finish picking up goods from Warehouse D, they start to dispatch the allocated spare parts corresponding to Warehouse B and Warehouse D. The distance from Warehouse D to the target spare parts receiving warehouse (Warehouse Z) corresponding to Warehouse D is 45 kilometers, and the distance from Warehouse D to the target spare parts receiving warehouse (Warehouse X) corresponding to Warehouse B is 60 kilometers. According to the preset distance scoring rule, the distance values from the target carpooling warehouse in the combined warehouse group to the target spare parts receiving warehouse corresponding to the target carpooling warehouse and the distance values from the target carpooling warehouse to the target spare parts receiving warehouse corresponding to the warehouse where the remaining loaded vehicle is located are scored. The preset distance scoring rule is that the score corresponding to 10 - 30 kilometers (excluding 30 kilometers) is 90 points, the score corresponding to 30 - 50 kilometers (excluding 50 kilometers) is 70 points, and the score corresponding to 50 - 70 kilometers (excluding 70 kilometers) is 60 points. The score corresponding to the distance of 45 kilometers from Warehouse D to the target spare parts receiving warehouse (Warehouse Z) corresponding to Warehouse D is 70 points, and the score corresponding to the distance of 60 kilometers from Warehouse D to the target spare parts receiving warehouse (Warehouse X) corresponding to Warehouse B is 60 points. The urgency levels of the tasks corresponding to Warehouse B and Warehouse D are obtained from the background database. The urgency level of the task corresponding to Warehouse B is 90%, and the urgency level of the task corresponding to Warehouse D is 70%. Weights are configured for the distance value score and the task urgency level respectively. The weight corresponding to the distance value score is 40%, and the weight corresponding to the task urgency level is 60%. The total score corresponding to Warehouse B: 60 * 40% + 90% * 60% = 24.54 points. The total score corresponding to Warehouse D: 70 * 40% + 70% * 60% = 28.54 points. The total score corresponding to Warehouse D is higher, so Warehouse D is given priority for dispatch.
[0125] In some embodiments, the total weight of the allocated spare parts corresponding to each warehouse is used to match the allocated vehicle with the corresponding load capacity from multiple allocated vehicles for each warehouse, ensuring that the allocated vehicles do not overload and guaranteeing the safety of the allocated spare parts. Based on the warehouse addresses of each warehouse in multiple warehouses, a warehouse group within the preset range of the warehouse where the remaining loaded vehicle is located is determined, which is beneficial for each allocated vehicle to make full use of the loading space and improve the transportation efficiency at the same time. The allocated spare parts of the target carpooling warehouse and the allocated spare parts corresponding to the warehouse where the remaining loaded vehicle is located are transported together, which reduces the transportation cost of the allocated vehicle and can also ensure that the allocated spare parts can be delivered to each target spare parts receiving warehouse in a timely manner. By allocating weights to the distance value score and the task urgency level, the allocation decision is made reasonable, ensuring that the warehouses with higher task urgency levels are given priority for processing and also reducing the transportation cost. The delivery priority corresponding to each warehouse in the combined warehouse group is determined through the total score corresponding to each warehouse, and the delivery priority corresponding to each warehouse is determined. The warehouse with the highest priority is selected for priority delivery to ensure the maximization of the benefit cost and the transportation cost.
[0126] The above description is only some preferred embodiments of the present invention and an explanation of the applied technical principles. Those skilled in the art should understand that the scope of the invention involved in the present invention is not limited to the technical solutions formed by the specific combination of the above technical features, but should also cover other technical solutions formed by any combination of the above technical features or their equivalent features without departing from the above inventive concept. For example, the technical solutions formed by mutually replacing the above features with the technical features (but not limited to) having similar functions disclosed in the present invention.
Claims
1. A method for allocating spare parts to multiple warehouses, characterized in that: include: Obtain spare parts inventory information and historical spare parts outbound data of each of the multiple warehouses, wherein the spare parts inventory information of each warehouse includes the warehouse name, warehouse address, multiple spare parts models and the inventory quantity corresponding to each spare parts model; the historical spare parts outbound data of each warehouse includes historical spare parts transfer outbound data and historical spare parts sales outbound data; Analyze the inventory quantity corresponding to each spare part model among the multiple spare part models in each of the multiple warehouses to obtain the out-of-stock spare part model of each warehouse, determine the warehouse corresponding to the out-of-stock spare part model as the spare parts receiving warehouse, and obtain a spare parts receiving warehouse group; determine the spare parts transfer order of each spare parts receiving warehouse according to the historical spare parts outbound data of each warehouse and the spare parts inventory information of each warehouse, and obtain multiple spare parts transfer orders corresponding to the multiple spare parts receiving warehouses; send each spare parts transfer order to multiple audit terminal devices, so that multiple auditors corresponding to the multiple audit terminal devices conduct audits according to multiple pre-defined audit contents and give audit results, wherein each audit terminal device corresponds to an auditor, and the audit result of each auditor among the multiple auditors is audit passed, that is, audit completed; When the spare parts transfer order is reviewed, the transfer outbound information corresponding to the spare parts transfer order is generated, and the transfer outbound information corresponding to the spare parts transfer order is sent to the shipping terminal device corresponding to the target spare parts shipping warehouse, so that the shipping transfer personnel corresponding to the shipping terminal device can perform the transfer operation according to the transfer outbound information and upload the transfer transportation information corresponding to the transfer outbound information; The allocation and transportation information is monitored. If it is monitored that the transportation status included in the allocation and transportation information is received, the allocation and receipt information of the spare parts allocation order is generated, and the allocation and receipt information of the spare parts allocation order is sent to the receiving terminal device corresponding to the target spare parts receiving warehouse, so that the receiving and allocation personnel corresponding to the receiving terminal device can inspect and accept the allocation spare parts model and allocation quantity corresponding to the allocation and receipt information; Obtaining warehouse data of each warehouse among the multiple warehouses and attribute information of each spare part model, wherein the warehouse data includes warehouse type, warehouse location information, and a list of item information supplied by the warehouse; the attribute information of each spare part model includes spare part scarcity, spare part unit price, spare part life, spare part substitutability, and replacement cost, wherein the warehouse type is a central warehouse or an edge warehouse; Determine at least one warehouse whose warehouse type is an edge warehouse among the multiple warehouses as an edge warehouse and divide it into an edge warehouse group, and determine at least one warehouse whose warehouse type is a central warehouse among the multiple warehouses as a central warehouse and divide it into a central warehouse group; For each edge warehouse in the edge warehouse group, determine whether there is a central warehouse within the preset range of the edge warehouse according to the warehouse location information; if so, determine the location attribute of the edge warehouse as level 2; if not, determine the location attribute of the edge warehouse as level 3, and determine the location attribute of each central warehouse in the central warehouse group as level 1; For each of the multiple warehouses, generating a spare parts demand coefficient corresponding to each project according to the project scale, project importance, and project operation time included in each project information in the project information list supplied by the warehouse, and generating a cumulative value of spare parts demand coefficients of multiple projects involved in the project information list of each warehouse according to the spare parts demand coefficient corresponding to each project; For each of the plurality of warehouses, generating a warehouse stocking coefficient corresponding to each warehouse according to the location attribute and the accumulated value of the spare parts demand coefficient; Generate the spare parts stocking coefficient for each spare parts model based on the attribute information of each spare parts model in each warehouse, including spare parts scarcity, spare parts unit price, spare parts life, spare parts substitutability and substitution cost; For each spare part model in each warehouse, the safety stock quantity corresponding to each warehouse is generated according to the spare part stocking coefficient of the spare part model, the warehouse stocking coefficient of the corresponding warehouse and the benchmark safety stock quantity corresponding to each spare part model.
2. The method for allocating spare parts for multiple warehouses according to claim 1, characterized in that: The safety stock quantity corresponding to each spare part model in each warehouse is dynamically updated through the following steps: Within a preset time interval after the safety inventory quantity corresponding to each warehouse is generated, when the actual inventory quantity of each spare part model in each warehouse is less than the configured safety inventory quantity, an inventory emergency information corresponding to the warehouse is generated, and the inventory emergency information includes the warehouse name, the emergency spare part model, and the emergency time, and a set of inventory emergency information corresponding to the preset time interval is obtained; For each central warehouse in the central warehouse group, if the number of inventory emergency information in the inventory emergency information set corresponding to the central warehouse is greater than a first preset quantity threshold, the safety stock quantity corresponding to the central warehouse is increased; For each edge warehouse in the edge warehouse group, if the number of inventory emergency information in the inventory emergency information set corresponding to the edge warehouse is zero, the safety stock quantity corresponding to the edge warehouse is reduced; if the number of inventory emergency information in the inventory emergency information set corresponding to the edge warehouse is not zero and is less than or equal to a second preset quantity threshold, the safety stock quantity corresponding to the edge warehouse remains unchanged; if the number of inventory emergency information in the inventory emergency information set corresponding to the edge warehouse is greater than the second preset quantity threshold, the safety stock quantity corresponding to the edge warehouse is increased; wherein the first preset quantity threshold is greater than the second preset quantity threshold.
3. The method for allocating spare parts for multiple warehouses according to claim 2, characterized in that: The spare parts transfer order of each spare parts receiving warehouse includes a target spare parts receiving warehouse and a target spare parts shipping warehouse, and the target spare parts receiving warehouse and the target spare parts shipping warehouse are determined by the following steps: Compare the inventory quantity corresponding to each spare part model corresponding to each warehouse in the multiple warehouses with the safety stock quantity of each spare part model; if the inventory quantity corresponding to each spare part model is less than the safety stock quantity of each spare part model, determine the spare part model corresponding to the inventory quantity less than the safety stock quantity as an out-of-stock spare part model, obtain the out-of-stock spare part model group of the corresponding warehouse, determine the warehouse corresponding to the out-of-stock spare part model as the spare parts receiving warehouse and add it to the spare parts receiving warehouse group; According to the historical spare parts sales and delivery data of each out-of-stock spare parts model in the out-of-stock spare parts model group of each spare parts receiving warehouse in the spare parts receiving warehouse group within the target time period, the historical spare parts sales and delivery quantity of each out-of-stock spare parts model is obtained; according to the historical spare parts sales and delivery quantity of each out-of-stock spare parts model, the sequence of spare parts receiving warehouses corresponding to each out-of-stock spare parts model is determined, and the spare parts receiving warehouse with the largest historical spare parts sales and delivery quantity in the spare parts receiving warehouse sequence corresponding to each out-of-stock spare parts model is determined as the target spare parts receiving warehouse corresponding to each out-of-stock spare parts model; If the inventory quantity of the out-of-stock spare part model corresponding to the target spare part receiving warehouse in the multiple warehouses is greater than the safety stock quantity of the out-of-stock spare part model, the warehouse corresponding to the warehouse with an inventory quantity greater than the safety stock quantity is determined as the spare parts shipping warehouse and added to the spare parts shipping warehouse group, wherein one out-of-stock spare part model corresponds to at least one spare parts shipping warehouse; According to the warehouse address of each spare parts shipping warehouse in the spare parts shipping warehouse group, the distance value between each spare parts shipping warehouse and the target spare parts receiving warehouse is determined, and the distance value between each spare parts shipping warehouse and the target spare parts receiving warehouse is scored according to a preset rule to determine the score corresponding to each spare parts shipping warehouse; the spare parts shipping warehouse with the highest score is selected from the scores corresponding to each spare parts shipping warehouse as the target spare parts shipping warehouse corresponding to each out-of-stock spare parts model.
4. The method for allocating spare parts for multiple warehouses according to claim 3 is characterized in that: The spare parts transfer order includes a transfer quantity, and the transfer quantity is determined by the following steps: According to the historical spare parts sales and delivery quantity of the out-of-stock spare parts model corresponding to the target spare parts shipping warehouse, generate a spare parts sales volume graph for the out-of-stock spare parts model corresponding to the target spare parts shipping warehouse; segment the spare parts sales volume graph to obtain multiple spare parts sales quantum graphs corresponding to multiple periods, wherein the spare parts sales quantum graph of each period shows the sales volume of the out-of-stock spare parts model corresponding to the target spare parts shipping warehouse within the target time period, with the horizontal axis being time and the vertical axis being the sales volume of the out-of-stock spare parts model; overlay and analyze the spare parts sales quantum graph of each period in the multiple spare parts sales quantum graphs corresponding to the multiple periods to obtain the sales trend of the out-of-stock spare parts model at each historical time point and multiple sales volumes corresponding to each historical time point; Determine the time point corresponding to the spare parts transfer order of each spare parts receiving warehouse, analyze the sales trend and multiple sales volumes of the historical time point corresponding to the time point, if the sales trend of the historical time points of multiple periods corresponding to the time point is an increasing trend, select the highest sales volume among the multiple sales volumes in the historical time points corresponding to the multiple periods as the first estimated demand quantity; if the sales trend of the historical time points of multiple periods corresponding to the time point is a declining trend, select the lowest sales volume among the multiple sales volumes in the historical time points corresponding to the multiple periods as the second estimated demand quantity; According to the inventory quantity, safety stock quantity and first estimated demand quantity or second estimated demand quantity corresponding to the out-of-stock spare part model corresponding to the target spare parts shipping warehouse, the transfer quantity of the out-of-stock spare part model corresponding to the spare parts transfer order corresponding to the target spare parts shipping warehouse is obtained.
5. The method for allocating spare parts for multiple warehouses according to claim 4, characterized in that: The spare parts transfer order includes a spare parts transfer order number, and the spare parts transfer order number is determined by the following steps: Determine the transfer order number prefix based on the business type and the system preset format; Obtain the date and time of generating the spare parts transfer order, the date and time including year, month, day and time point, and process the date and time according to a preset time and date format to obtain a processed date and time; Obtaining the count of spare parts transfer orders generated in the transfer order increment counter, and using the count of the generated spare parts transfer orders as the transfer order suffix number, wherein the update frequency of the transfer order increment counter is updated according to a preset frequency; The transfer order number prefix identifier, the processed date and time, and the transfer order suffix number are sequentially concatenated according to a preset transfer order number format to generate the spare parts transfer order number.
6. The method for allocating spare parts for multiple warehouses according to claim 5, characterized in that: The total number of auditors corresponding to the multiple auditors is determined by the following steps: Obtain the review duration of each historical spare parts transfer order from multiple historical spare parts transfer orders within a target time period, select a target number of historical spare parts transfer orders from the multiple historical spare parts transfer orders, and obtain a historical spare parts transfer order group; average multiple review durations corresponding to the historical spare parts transfer order group to obtain an average review duration of each historical spare parts transfer order; Obtain the total number of transfer orders of the multiple spare parts transfer orders and the daily working hours of each auditor, calculate the total number of transfer orders, the average audit time of each historical spare parts transfer order, and the daily working hours of each auditor, and obtain the total number of auditors, wherein the daily working hours of each auditor are in hours, and the total number of auditors is an integer.
Citation Information
Patent Citations
Method and equipment for determining allocation warehouse
CN110046755A