Automobile wire harness production material intelligent matching and inventory management system

Abstract

The present application relates to the technical field of material management in production and manufacturing, and particularly relates to an intelligent matching and inventory management system for automobile wiring harness production materials. Through the collaborative operation of a work order analysis module, a replenishment triggering module, a distribution scheduling module and an execution feedback module, the present application realizes intelligent matching and dynamic inventory management of automobile wiring harness production materials. The system first accurately calculates material demand and readiness based on production work orders and real-time inventory, generates executable work order queues and predicts consumption benchmarks; then, through dynamic replenishment points, it intelligently triggers replenishment and prioritizes replenishment instructions in combination with multi-dimensional factors; finally, through execution feedback, a management closed loop is formed.

Description

Technical Field

[0001] This invention relates to the field of material management technology in manufacturing, specifically to an intelligent matching and inventory management system for automotive wiring harness production materials. Background Technology

[0002] As a core component of automotive electrical systems, automotive wiring harnesses typically involve the production of various materials, such as wires, terminals, and connectors. The demand for these materials varies significantly across different production work orders, and they are frequently reused. The same material can also be shared by multiple production work orders simultaneously.

[0003] Currently, material matching and inventory management mostly rely on periodic replenishment. However, in complex scenarios with a large number of production orders and frequent production plan adjustments, this method cannot adjust to the real-time consumption pressure of materials based on specific work orders. This can easily lead to general-purpose materials being used by non-urgent work orders, causing urgent work orders to be interrupted due to material shortages. Furthermore, it is difficult to achieve early-triggered replenishment, easily leading to material inventory backlog and shortage risks, causing production line interruptions. Summary of the Invention

[0004] The purpose of this invention is to overcome the shortcomings of the prior art by linking work order demand and inventory status in real time, accurately predicting the consumption trend of materials and dynamically adjusting replenishment strategies, so as to avoid the risk of material inventory backlog and shortage due to delayed material replenishment response, which could cause production line interruption.

[0005] The technical solution adopted by the present invention to solve its technical problem is: an intelligent matching and inventory management system for automotive wiring harness production materials, including: a work order analysis module, used to obtain the corresponding material list and required quantity according to the production work order, combine the current available inventory of materials to obtain the material availability rate, and then generate an executable work order queue, and then obtain the baseline consumption rate of materials in the executable work order queue.

[0006] The replenishment trigger module is used to obtain the real-time inventory of each material in the executable work order queue; combined with the baseline consumption rate and replenishment lead time, it determines the dynamic replenishment point; when the real-time inventory is less than or equal to the dynamic replenishment point, it generates a replenishment instruction.

[0007] The delivery scheduling module is used to determine the delivery urgency of each replenishment instruction based on the real-time inventory and consumption dynamics of materials, combined with the replenishment lead time, and to sort them in descending order to generate a delivery sequence.

[0008] The execution feedback module is used to send the delivery sequence to the execution terminal to execute the replenishment task. After the replenishment is completed, the real-time inventory is retrieved again. If it is less than or equal to the dynamic replenishment point and there is no replenishment task to be executed, a replenishment instruction is regenerated; otherwise, monitoring continues.

[0009] Compared to existing technologies, this invention offers the following advantages: Through the collaborative operation of a work order analysis module, a replenishment triggering module, a delivery scheduling module, and an execution feedback module, this invention achieves intelligent matching and dynamic inventory management of automotive wiring harness production materials. The system first accurately calculates material requirements and availability rates based on production work orders and real-time inventory, generating an executable work order queue and predicting consumption baselines. Then, it uses dynamic replenishment points to intelligently trigger replenishment and prioritizes replenishment instructions based on multi-dimensional factors. Finally, execution feedback forms a closed-loop management system. Overall, this invention effectively improves the timeliness of material replenishment, reduces the risk of material inventory backlog and shortages, and ensures the smooth execution of production plans. Attached Figure Description

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

[0011] Figure 1 This is a schematic diagram of the system module connections of the present invention.

[0012] Figure 2 This is a schematic diagram illustrating the process of determining dynamic replenishment points in this invention.

[0013] Figure 3 This is a flowchart illustrating the process of determining the delivery urgency of each replenishment order according to the present invention. Detailed Implementation

[0014] Various exemplary embodiments of the present invention will now be described in detail with reference to the accompanying drawings. It should be noted that, unless otherwise specifically stated, the relative arrangement, numerical expressions, and values ​​of the components and steps set forth in these embodiments do not limit the scope of the invention. Furthermore, it should be understood that, for ease of description, the dimensions of the various parts shown in the drawings are not drawn to actual scale.

[0015] The following description of at least one exemplary embodiment is merely illustrative and is in no way intended to limit the invention or its application or use. Techniques, methods, and apparatus known to those skilled in the art may not be discussed in detail, but where appropriate, such techniques, methods, and apparatus should be considered part of the specification.

[0016] In all examples shown and discussed herein, any specific values ​​should be interpreted as merely exemplary and not as limitations. Therefore, other examples of exemplary embodiments may have different values.

[0017] Unless otherwise defined, all technical and scientific terms used herein have the same meaning as commonly understood by one of ordinary skill in the art to which this invention pertains.

[0018] The following description, in conjunction with the accompanying drawings, details a specific solution for an intelligent matching and inventory management system for automotive wiring harness production materials provided by this invention.

[0019] Please see Figure 1 The diagram illustrates the module connections of an intelligent matching and inventory management system for automotive wiring harness production materials provided by the present invention, specifically including: a work order analysis module, a replenishment triggering module, a delivery scheduling module, and an execution feedback module.

[0020] The replenishment trigger module is unidirectionally connected to the work order analysis module and the delivery scheduling module, while the execution feedback module is bidirectionally connected to the replenishment trigger module and unidirectionally connected to the delivery scheduling module.

[0021] As shown in the module connection diagram, in the system of this invention, data starts from the work order analysis module, passes through the replenishment trigger module and the delivery scheduling module in sequence, and finally reaches the execution feedback module; the execution result data is then fed back to the replenishment trigger module by the execution feedback module, triggering a new round of execution feedback, and so on, to achieve intelligent material matching and dynamic optimization and closed-loop automatic control of inventory management.

[0022] The operation process of the work order analysis module is as follows: Step S11: First, obtain the corresponding bill of materials and required quantity based on the production work order.

[0023] Specifically, this involves first obtaining the product model and planned production quantity from the production work order, and then associating the product model with the bill of materials database to obtain all the material types that constitute the product and the unit product consumption quota for each material.

[0024] The planned production quantity refers to the total quantity of a specific model of wire harness products required to be completed in a specific production work order.

[0025] The bill of materials database is a pre-built and continuously maintained database that stores the correspondence between all product models and their required materials; while the unit product consumption quota refers to the standard quantity of each material required to produce a single molded product.

[0026] In actual production, the same material may be needed by multiple production orders simultaneously. Therefore, to understand the true available inventory, the system further obtains the total inventory and allocated reserve quantity of each material from the warehousing system.

[0027] The allocated reserved quantity refers to the quantity of materials in inventory that have been locked by other production work orders that have not yet started execution but have been approved by the system.

[0028] By calculating the difference between the total inventory and the reserved quantity, the current available inventory of each material can be obtained, thus avoiding the duplication of inventory materials.

[0029] Based on this, according to the calculation formula: The required quantity is calculated. .

[0030] in, For the first The required quantity of this material For the first The unit product consumption quota for this type of material For planned production quantity, For the first The theoretical total consumption of this material. For the first The current available inventory of the material; This is the identifier for the material, with values ​​of 1, 2, ... , This represents the total number of material types.

[0031] Finally, by summarizing the types and quantities of all materials, a bill of materials and required quantities corresponding to the production work order are generated.

[0032] Step S12: After obtaining the bill of materials and required quantities, the system further combines the current available inventory of materials to obtain the material availability rate, and then evaluates the support capacity of the current inventory for the production work order, that is, the feasibility of the production work order under the current inventory. The specific process is as follows: First, obtain the planned production cycle of the products in the production work order. This refers to the total time required to complete all production outputs for that production order.

[0033] Next, in order to translate production demand into an assessment of material consumption rates, the planned production quantity of the product was determined. Divide by the planned production cycle ,Right now To obtain the average production rhythm This refers to the number of molded products that need to be produced per unit of time, which reflects the load intensity of the production line.

[0034] Subsequently, for each material constituting the product, the formula will be used: Calculate the first Consumption rate per unit time of a certain material .

[0035] Then, the current available inventory level Divide by the rate of consumption per unit time ,Right now , obtained the The actual sustainability of a material inventory. That is, the number of days that the material inventory can sustain production at the current consumption rate.

[0036] Finally, the ratio of the actual sustainable lifespan to the planned production cycle for each material is calculated. Considering that the successful completion of a production order depends not on the most abundant inventory of a particular material, but on the first material to run out, the minimum of all ratios is selected as the material availability rate for that production order. The closer the material availability rate is to or greater than 1, the better the material inventory can support the complete execution of the production order.

[0037] However, not all production work orders can be put into production quickly. Further analysis and evaluation based on material availability are needed to screen and prioritize multiple production work orders.

[0038] Step S13: Specifically, the system first forms an initial set of executable work orders by selecting production work orders with a material availability rate greater than or equal to a preset threshold.

[0039] For example, the preset threshold can be 0.8. However, the preset threshold is not fixed. For instance, when the planned delivery date of the work order is very tight and the remaining delivery time is very short, the preset threshold can be increased appropriately; conversely, the preset threshold can be decreased appropriately.

[0040] To further optimize the production sequence, the planned delivery date of each work order in the initial set of executable work orders is obtained, which is the final deadline for product completion and delivery as required by the customer or stipulated in the internal plan of the product manufacturer; and the difference between the planned delivery date and the current date is calculated to obtain the remaining delivery time of the work order.

[0041] Finally, the work orders in the initial set of executable work orders are sorted in ascending order according to the remaining delivery time of the work orders to generate the final executable work order queue, ensuring that the work orders with the most urgent delivery can obtain material resources first.

[0042] Step S14: After obtaining the final executable work order queue, in order to ensure that the work orders in the queue will not be interrupted due to insufficient materials during subsequent execution, it is necessary to accurately predict the future consumption rate of materials so that materials can be replenished in a timely manner.

[0043] To this end, firstly, obtain the bill of materials and corresponding material requirements for all work orders in the executable work order queue; then, summarize the material requirements for each material in all work orders to obtain the total material requirements.

[0044] The total planned production time is obtained based on the planned production cycle of all work orders in the executable work order queue.

[0045] It should be noted that, considering that in actual production, there are usually two execution modes: a serial execution mode where multiple work orders share the same production line or key equipment, and a parallel execution mode where multiple work orders are assigned to different and independent production lines. Based on this, the present invention adopts different calculation methods. For serial execution, the total planned production time is usually the maximum value of the planned production cycles of all work orders; while for parallel execution, the total planned production time is the sum of the planned production cycles of all work orders in the executable work order queue.

[0046] Then, the total demand for each material is compared with the total planned production time to obtain the expected consumption per unit time of that material, which represents the theoretical prediction of the future material consumption rate based on the current production plan.

[0047] Meanwhile, to incorporate historical consumption trends and make forecasts more accurate, the actual total consumption of the material within the historical statistical period is obtained, and a ratio is calculated based on the duration of the historical statistical period to obtain the average consumption per unit time.

[0048] Finally, through weighted fusion, based on the expected consumption per unit time... Average time consumption Calculations were performed to obtain the baseline consumption rate. .

[0049] The weighted fusion formula is: .

[0050] in, The weighting coefficient has a range of values. In this invention, it can be taken as 0.6. Furthermore, if the production plan of the current executable work order queue has a high similarity to the plans of the same historical period, then... It can be increased, for example, by taking it as 0.7.

[0051] After generating an executable work order queue and determining the baseline consumption rate of future materials, the replenishment trigger module starts running to translate the above consumption forecast into actual inventory management actions.

[0052] The specific operation process of the replenishment trigger module is as follows: Step S21: First, it is necessary to extract the bill of materials of all work orders in the executable work order queue, summarize all material types contained in the bill of materials, and remove duplicate material records, thereby forming a target material identifier set composed of unique material identifiers.

[0053] Determining the target material identifier set helps improve the accuracy and relevance of subsequent inventory control and replenishment decisions.

[0054] Then, based on each material identifier in the target material identifier set, the current total inventory and the reserved quantity allocated by other production work orders are queried from the warehouse management system, and the difference is calculated to obtain the real-time inventory of the material.

[0055] After obtaining real-time inventory levels, the core task of the replenishment trigger module is to determine when to trigger replenishment, which relies on the dynamic replenishment point. The dynamic replenishment point acts as a threshold; when the real-time inventory level is less than or equal to the dynamic replenishment point, a replenishment instruction is generated.

[0056] The core of calculating dynamic replenishment points lies in accurately predicting replenishment lead time, which is the time elapsed from issuing a replenishment order to the availability of materials.

[0057] Please see Figure 2 Step S22: Based on this, the system first needs to obtain the source type of each material in the executable work order queue. The source type includes external purchase and internal production.

[0058] For purchased materials, the estimated transit time, the supplier's historical average lead time, and the standard warehousing processing time should be determined first. Then, the three should be summed to calculate the replenishment lead time.

[0059] The process for determining the estimated transit time involves obtaining the actual road transport distance between the supplier and the product manufacturing warehouse through a map API service. Furthermore, from historical data of multiple transport trips along the same route (e.g., 10 trips), the actual transport speed is extracted, outliers are removed, and the arithmetic mean is calculated to obtain the baseline transport speed. .

[0060] Then, according to the calculation formula: To obtain the basic transportation time .

[0061] Next, because the estimated transit time is easily affected by real-time changes in traffic conditions in the short term, a real-time traffic impact factor is introduced. right Make corrections to achieve more accurate predictions.

[0062] The corrected formula is: Based on this, the estimated transit time is obtained. .

[0063] It should be noted that, The range of values ​​for can be: However, the specific values ​​within this range need to be dynamically adjusted based on the real-time traffic data of the current transportation route obtained from the real-time traffic data platform.

[0064] For example, when the platform returns a real-time traffic condition that is clear, 1.0 is acceptable; if it's a slow process, then take 1.0. 1.2 is acceptable; if there is congestion, then take... 1.3 is acceptable. The value of increases as congestion worsens.

[0065] The historical average lead time of a supplier refers to the time from order confirmation to the material leaving the supplier's warehouse. It is determined by: statistically analyzing the time from order confirmation to shipment for all valid orders placed by the supplier within the past year, categorizing them by material type, and then calculating the arithmetic mean of all corresponding time periods. This yields the historical average lead time.

[0066] Standard inbound processing time refers to the total time from the arrival of materials in the warehouse to the completion of registration and availability. Its determination process involves: first, calculating the average basic time consumed at each stage of the process based on historical data as a baseline value; then, dynamically adjusting it according to the actual warehouse operations.

[0067] For example, the baseline value for standard inbound processing time is 0.5, but when the warehouse workload increases, the standard inbound processing time can be increased to 0.7.

[0068] However, it is important to note that the specific value of the standard inbound processing time must always fall within the specified range. Within this range, we ensure that the final calculation results reflect both the actual operating conditions and maintain a reasonable fluctuation range.

[0069] For internally manufactured materials, it is necessary to first obtain their corresponding internal production cycle and internal transfer time, and then sum them up to obtain the replenishment lead time.

[0070] The internal production cycle refers to the complete time span from the issuance of a production order to the completion of all processing, inspection, and warehousing of the material on the production line. Its determination process involves: based on historical data from the Manufacturing Execution System (MES), extracting several past actual production cycles of the material on the same or similar production lines and with similar production batches; removing outliers; and then calculating the arithmetic mean to obtain the internal production cycle.

[0071] Internal transfer time refers to the time required for materials to be taken out of the internal warehouse, transported through the factory's logistics system to the target production line's side warehouse or designated workstation, and for handover confirmation to be completed.

[0072] The determination process is as follows: First, based on the factory map, the fixed distance from the warehouse to the production line is measured. Then, based on the average speed of the transportation equipment, a ratio is calculated to obtain the basic transportation time. Next, the time for each step, such as picking, unpacking, handover, counting, and signing confirmation, is added to obtain the internal transfer time.

[0073] It should be noted that the present invention introduces dynamic adjustments to the estimated transit time and standard warehousing processing time because both are susceptible to short-term fluctuations such as real-time changes in road conditions or warehouse busyness, and using static average values ​​cannot accurately reflect the actual time consumption of each replenishment.

[0074] The reason why the supplier's historical average preparation cycle, internal production cycle, and internal transit time are used with relatively stable values ​​is that these three reflect the basic standards of the supplier's contract performance or the operating standards of the product manufacturer, and their changes are slow and long-term.

[0075] Step S23: After determining the replenishment lead time, multiply the baseline consumption rate of each material by the replenishment lead time to obtain the theoretical consumption; and use the sum of the theoretical consumption and the preset safety stock as the dynamic replenishment point of the material.

[0076] For example, in this invention, the preset safety stock level can be 0.15. When the standard deviation of the historical consumption data of a certain material is large or the supplier's delivery is unstable, the preset safety stock level can be appropriately increased. When the material consumption is stable and the supplier's delivery is stable, the preset safety stock level can be appropriately decreased.

[0077] The replenishment trigger module continuously monitors the real-time inventory of each material. Once it detects that the real-time inventory of a certain material is less than or equal to its dynamic replenishment point, the system automatically generates a replenishment instruction for that material and transmits it to the delivery scheduling module.

[0078] In actual production scenarios, the inventory consumption rates of various materials often differ, so the system often generates multiple replenishment instructions simultaneously.

[0079] When multiple replenishment orders exist simultaneously, the delivery scheduling module needs to prioritize these replenishment orders by combining real-time inventory levels, consumption dynamics, and replenishment lead time in order to optimize the allocation of material resources and achieve targeted and timely replenishment.

[0080] Specifically, the priority sorting process is as follows: Please refer to Figure 3 Step S31: For each replenishment instruction, the real-time inventory of the material is compared with the consumption rate per unit time to obtain the remaining production time that the current inventory can sustain production.

[0081] Next, compare the remaining production time with the replenishment lead time. If the remaining production time is less than or equal to the replenishment lead time, it indicates that the inventory of the material is about to run out, and the highest delivery urgency is assigned to the corresponding replenishment instruction.

[0082] If the remaining production time is greater than the replenishment lead time, it indicates that the current inventory of the material still has a certain safety buffer. In this case, the difference between the remaining production time and the replenishment lead time is calculated to quantify the urgency of the safety buffer. After obtaining this difference, the corresponding delivery urgency is determined according to the preset range in which the difference falls.

[0083] It should be noted that, in this invention, the preset interval can be exemplarily defined as follows: The unit is hours; the smaller the difference, the higher the urgency level.

[0084] Step S32: To more comprehensively assess the urgency level, the system can also introduce a shortage impact factor. The process for determining the shortage impact factor is as follows: First, obtain the planned delivery date and planned production cycle of all executable work orders corresponding to the materials in each replenishment instruction.

[0085] Then, by using the calculation formula: Latest planned start time = Planned delivery date - Planned production cycle - Internal transfer time, the latest planned start time of this replenishment instruction can be calculated.

[0086] Simultaneously, for each replenishment order, the total number of times the material appears in other replenishment orders (excluding the target production line) that have been generated and whose latest planned start time is earlier than the current replenishment order is used as the shortage impact factor for that replenishment order. The higher the total number of occurrences, the more common and urgently needed the material is.

[0087] Step S33: After determining the initial delivery urgency through step S31 Based on this, and combined with the influencing factors of scarcity Calculate the overall urgency level .

[0088] Specifically, this can be calculated using the weighted fusion formula: .

[0089] in, , They are respectively and The weighting coefficients, and In this invention, by way of example, , The values ​​can be 0.6 and 0.4 respectively.

[0090] Then, based on the overall urgency from high to low, all replenishment orders are sorted in descending order to determine the final position of each replenishment order in the delivery sequence, and finally the delivery sequence is generated.

[0091] The execution feedback module receives the delivery sequence from the delivery scheduling module and sends it to the corresponding execution terminal to drive it to execute the replenishment task.

[0092] After the replenishment task is completed, the execution feedback module must also perform critical closed-loop verification. Specifically, this involves re-acquiring the real-time inventory quantity of the corresponding materials.

[0093] If, after replenishment, the real-time inventory of the material is still less than or equal to its dynamic replenishment point, and there are no replenishment tasks being executed or pending for the material in the system, a new replenishment instruction will be generated.

[0094] The reasons that may necessitate regenerating replenishment orders include insufficient replenishment, rapid consumption, or the emergence of new demand.

[0095] If, after replenishment, the real-time inventory of the material exceeds its dynamic replenishment point, the system will continue to monitor it.

[0096] In summary, this invention achieves intelligent matching and dynamic inventory management of automotive wiring harness production materials through the collaborative operation of a work order analysis module, a replenishment triggering module, a delivery scheduling module, and an execution feedback module. The system first accurately calculates material requirements and availability rates based on production work orders and real-time inventory, generating an executable work order queue and predicting consumption baselines. Then, it intelligently triggers replenishment through dynamic replenishment points and prioritizes replenishment instructions based on multi-dimensional factors. Finally, execution feedback forms a closed-loop management system. Overall, this effectively improves the timeliness of material replenishment, reduces the risk of material inventory backlog and shortages, and ensures the smooth execution of production plans.

[0097] The above embodiments can be implemented, in whole or in part, by software, hardware, firmware, or any other combination thereof. When implemented using software, the above embodiments can be implemented, in whole or in part, in the form of a computer program product.

[0098] Those skilled in the art will recognize that the modules and algorithm steps of the various examples described in conjunction with the embodiments disclosed herein can be implemented in electronic hardware, or a combination of computer software and electronic hardware. Whether these functions are implemented in hardware or software depends on the specific application and design constraints of the technical solution. Those skilled in the art can use different methods to implement the described functions for each specific application, but such implementations should not be considered beyond the scope of this invention.

[0099] In addition, the functional modules in the various embodiments of the present invention can be integrated into one processing module, or each module can exist physically separately, or two or more modules can be integrated into one module.

[0100] The above description is merely a specific embodiment of the present invention, but the scope of protection of the present invention is not limited thereto. Any variations or substitutions that can be easily conceived by those skilled in the art within the technical scope disclosed in the present invention should be included within the scope of protection of the present invention. Therefore, the scope of protection of the present invention should be determined by the scope of the claims.

[0101] Finally, the above description is only a preferred embodiment of the present invention and is not intended to limit the present invention. Any modifications, equivalent substitutions, improvements, etc., made within the spirit and principles of the present invention should be included within the protection scope of the present invention.

Claims

1. An intelligent matching and inventory management system for automotive wiring harness production materials, characterized in that, include: The work order analysis module is used to obtain the corresponding bill of materials and required quantity based on the production work order, combine it with the current available inventory of materials to obtain the material availability rate, and then generate an executable work order queue. Finally, the baseline consumption rate of materials in the executable work order queue is obtained. The replenishment trigger module is used to obtain the real-time inventory of each material in the executable work order queue; by multiplying the baseline consumption rate by the replenishment lead time to obtain the theoretical consumption, and then adding it to the preset safety stock, the dynamic replenishment point is determined. When the real-time inventory is less than or equal to the dynamic replenishment point, a replenishment instruction is generated. The delivery scheduling module is used to determine the delivery urgency of each replenishment instruction and sort them in descending order based on the real-time inventory and consumption dynamics of materials, combined with the replenishment lead time, to generate a delivery sequence. The execution feedback module is used to send the delivery sequence to the execution terminal to execute the replenishment task. After the replenishment is completed, the real-time inventory is retrieved again. If it is less than or equal to the dynamic replenishment point and there is no replenishment task to be executed, a replenishment instruction is regenerated; otherwise, monitoring continues. The process for determining the material availability rate is as follows: obtain the planned production cycle of the product in the production work order; for each material that constitutes the product, obtain its unit product consumption quota, and calculate the actual sustainable cycle of the material inventory in combination with the current available inventory, planned production quantity and planned production cycle; calculate the ratio of the actual sustainable cycle to the planned production cycle of each material, and select the minimum value among all ratios as the material availability rate of the production work order. The process for determining the baseline consumption rate is as follows: obtain the bill of materials and corresponding material requirements of all work orders in the executable work order queue; summarize the material requirements of each material in all work orders to obtain the total material requirements; and obtain the total planned production time based on the planned production cycle of all work orders in the executable work order queue. The total demand for each material is compared with the total planned production time to obtain the expected consumption per unit time of the material; the actual total consumption of the material in the historical statistical period is obtained, and the average consumption per unit time is calculated in combination with the duration of the historical statistical period; the expected consumption per unit time and the average consumption per unit time are combined to obtain the baseline consumption rate. The process of determining the dynamic replenishment point is as follows: Obtain the source type of each material in the executable work order queue; the source type includes external purchase and internal production; for externally purchased materials: calculate the estimated transit time based on the geographical location of the supplier and the product production warehouse, combined with real-time traffic data; obtain the supplier's historical average preparation cycle and the standard warehousing processing time for the material, and then sum these two with the estimated transit time as the replenishment lead time; for internally produced materials: obtain their corresponding internal production cycle and internal transfer time, and sum these two as the replenishment lead time; multiply the baseline consumption rate of each material by the replenishment lead time to obtain the theoretical consumption; and sum the theoretical consumption and the preset safety stock level as the dynamic replenishment point for that material.

2. The intelligent matching and inventory management system for automotive wiring harness production materials according to claim 1, characterized in that, The process of obtaining the corresponding bill of materials and required quantities based on the production work order is as follows: Obtain the product model and planned production quantity from the production work order; By associating the product model with the bill of materials database, we can obtain all the material types that make up the product and the unit product consumption quota for each material. The product of the unit product consumption quota and the planned production quantity is taken as the theoretical total consumption of each material. Obtain the total inventory of each material in the warehousing system and the allocated reserved quantity; Calculate the difference between the total inventory and the reserved quantity to obtain the current available inventory of each material; The difference between the theoretical total consumption of each material and its current available inventory is taken as the demand quantity; Summarize the types and quantities of all materials and generate a bill of materials and required quantities corresponding to the production work order.

3. The intelligent matching and inventory management system for automotive wiring harness production materials according to claim 2, characterized in that, The process for determining the actual sustainable period is as follows: The ratio of the planned production quantity to the planned production cycle is used as the average production rhythm. Multiply the unit product consumption quota of each material by the corresponding average production rhythm to obtain the unit time consumption rate of that material. The ratio of the current available inventory of each material to its consumption rate per unit time is taken as the actual sustainable lifespan of that material's inventory.

4. The intelligent matching and inventory management system for automotive wiring harness production materials according to claim 1, characterized in that, The process of generating the executable work order queue is as follows: Production work orders with a material availability rate greater than or equal to a preset threshold constitute the initial set of executable work orders. Obtain the planned delivery date for each work order in the initial set of executable work orders, and calculate the difference between the planned delivery date and the current date to obtain the remaining delivery time for the work order; Based on the remaining delivery time of each work order, the work orders in the initial set of executable work orders are sorted in ascending order to generate the final queue of executable work orders.

5. The intelligent matching and inventory management system for automotive wiring harness production materials according to claim 1, characterized in that, The process of obtaining the real-time inventory of each material in the executable work order queue is as follows: Extract the bill of materials for all work orders in the executable work order queue, summarize all material types contained in the bill of materials, remove duplicate material records, and form a target material identifier set consisting of unique material identifiers; For each material identifier in the target material identifier set, query the current total inventory and the reserved quantity that has been allocated by other production work orders from the warehouse management system. Calculate the difference between the current total inventory of each material and the reserved quantity that has been allocated by other production orders, and use this difference as the real-time inventory of that material.

6. The intelligent matching and inventory management system for automotive wiring harness production materials according to claim 3, characterized in that, The process for determining the delivery urgency of each replenishment order is as follows: For each replenishment order corresponding to a material, perform the following operations: By comparing the real-time inventory of the material with its consumption rate per unit time, the remaining production time that its current inventory can sustain is obtained. Compare the remaining production time with the replenishment lead time: if the remaining production time is less than or equal to the replenishment lead time, then assign the highest delivery urgency to the replenishment order; If the remaining production time is greater than the replenishment lead time, then calculate the difference between the remaining production time and the replenishment lead time; The urgency of delivery is determined based on the preset range into which the difference falls; the smaller the difference, the higher the urgency level.

7. The intelligent matching and inventory management system for automotive wiring harness production materials according to claim 6, characterized in that, The process of determining the urgency of each replenishment order also includes: Based on the planned delivery dates and planned production cycles of all executable work orders corresponding to the materials in each replenishment order, determine the latest planned start time of the replenishment order; Query the materials in each replenishment order, excluding the target production line, and find the total number of times they appear in other replenishment orders that have been generated and whose latest planned start time is earlier than the current replenishment order. Use the total number of times as the shortage impact factor for that replenishment order. The delivery urgency is determined by comparing the remaining production time with the replenishment lead time, and then weighted and integrated with the shortage influencing factors to obtain the comprehensive urgency. All replenishment orders are sorted in descending order based on their overall urgency to determine the final position of each replenishment order in the delivery sequence.

Images