Search

CN-121146684-B - Intelligent matching and inventory management system for automobile wire harness production materials

CN121146684BCN 121146684 BCN121146684 BCN 121146684BCN-121146684-B

Abstract

The invention relates to the technical field of material management in production and manufacturing, in particular to an intelligent matching and inventory management system for automobile wire harness production materials. The intelligent matching and the stock dynamic management of the automobile wire harness production materials are realized through the cooperative operation of the work order analysis module, the replenishment triggering module, the distribution scheduling module and the execution feedback module. The system is used for accurately calculating material demands and preparation rate based on production work orders and real-time inventory, generating an executable work order queue and predicting consumption standard, further realizing intelligent triggering of replenishment through dynamic replenishment points, carrying out priority ordering on replenishment instructions by combining multidimensional factors, and finally forming a management closed loop through execution feedback.

Inventors

  • Niu Fengmei
  • LIU FENGCHUN

Assignees

  • 长春易加科技有限公司

Dates

Publication Date
20260505
Application Date
20251118

Claims (7)

  1. 1. An intelligent matching and inventory management system for automobile wire harness production materials, comprising: the work order analysis module is used for acquiring corresponding bill of materials and required quantity according to the production work order, acquiring a material stock rate by combining the current available stock quantity of the materials, further generating an executable work order queue, and then acquiring a reference consumption rate of the materials in the executable work order queue; the system comprises a replenishment triggering module, a replenishment instruction generation module, a replenishment control module and a replenishment control module, wherein the replenishment triggering module is used for acquiring real-time inventory of each material in an executable work order queue; the delivery scheduling module is used for determining the delivery emergency degree of each replenishment instruction and carrying out descending arrangement according to the real-time inventory and consumption dynamics of the materials and combining the replenishment advance period to generate a delivery sequence; The system comprises an execution feedback module, a delivery module and a storage module, wherein the execution feedback module is used for issuing a delivery sequence to an execution terminal to execute a replenishment task; The determining process of the material preparation rate comprises the steps of obtaining the planned production period of the product in the production work order, obtaining the unit product consumption quota of each material forming the product, and combining the current available stock quantity, the planned production quantity and the planned production period to calculate the actual sustainable period of the material stock; The reference consumption rate determining process comprises the steps of obtaining a bill of materials and corresponding material demand quantity of all work orders in an executable work order queue, summarizing the material demand quantity of each material in all work orders to obtain the total demand quantity of the material, obtaining total planned production time according to the planned production period of all work orders in the executable work order queue, comparing the total demand quantity of each material with the total planned production time to obtain the expected unit time consumption of the material, obtaining the actual consumption total quantity of the material in a historical statistical period, calculating the average unit time consumption by combining the time length of the historical statistical period, and carrying out fusion calculation on the expected unit time consumption and the average unit time consumption to obtain the reference consumption rate; The process for determining the dynamic replenishment point comprises the steps of obtaining source types of each material in an executable work order queue, wherein the source types comprise outsourcing and inner manufacturing, calculating to obtain estimated in-transit transportation time according to geographic positions of suppliers and product production warehouses and combining real-time traffic road condition data, obtaining historical average replenishment period of the suppliers and standard warehousing processing time of the materials, further taking the sum of the historical average replenishment period of the suppliers and the estimated in-transit transportation time as a replenishment advance period, obtaining corresponding inner production period and inner transfer time of the inner manufacturing materials, taking the sum of the internal production period and the inner transfer time as the replenishment advance period, multiplying reference consumption rate of each material by the replenishment advance period to obtain theoretical consumption, and taking the sum of the theoretical consumption and preset safe stock quantity as the dynamic replenishment point of the materials.
  2. 2. The intelligent matching and inventory management system for automobile wire harness production materials according to claim 1, wherein the corresponding bill of materials and the required quantity are obtained according to a production work order, specifically: obtaining the product model number and the planned production quantity in the production work order; Correlating the product model with a bill of materials database to obtain all the material types and unit product consumption quota of each material forming the product; taking the product of the unit product consumption quota and the planned production quantity as the theoretical total consumption of each material; acquiring the total stock quantity of each material in a warehouse system and the allocated reserved quantity; calculating the difference between the total stock quantity and the reserved quantity to obtain the current available stock quantity of each material; taking the difference value between the theoretical consumption total amount of each material and the current available stock amount as the required amount; And summarizing the types and the required quantity of all materials, and generating a bill of materials and the required quantity corresponding to the production work order.
  3. 3. The intelligent matching and inventory management system for automotive harness production materials according to claim 2, wherein the determining process of the actual sustainable period is: Taking the ratio of the planned production quantity of the product to the planned production period as the average production rhythm; Multiplying the unit product consumption quota of each material by the corresponding average production rhythm to obtain the unit time consumption rate of the material; The ratio of the current available inventory of each material to the rate of consumption per unit time is taken as the actual sustainable period of the inventory of materials.
  4. 4. The intelligent matching and inventory management system for automotive harness production materials according to claim 1, wherein the executable work order queue generating process is as follows: the method comprises the steps of (1) forming an initial executable work order set by using production work orders with material preparation rate larger than or equal to a preset threshold; Acquiring the scheduled delivery date of each work order in the initial executable work order set, and calculating the difference value between the scheduled delivery date and the current date to obtain the residual delivery time of the work order; And according to the residual delivery time of the worksheets, the worksheets in the initial executable worksheets are arranged in an ascending order, and a final executable worksheet queue is generated.
  5. 5. The intelligent matching and inventory management system for automotive harness production materials according to claim 1, wherein the process of acquiring real-time inventory of each material in the executable work order queue is as follows: extracting bill of materials of all worksheets in the executable worksheet queue, summarizing all material types contained in the bill of materials, and removing repeated material records to form a target material identification set consisting of unique material identifications; inquiring the corresponding current total stock quantity and the reserved quantity distributed by other production work orders from a warehouse management system according to each material identifier in the target material identifier set; and calculating the difference between the current total stock quantity of each material and the reserved quantity which is distributed by other production work orders, and taking the difference as the real-time stock quantity of the material.
  6. 6. The intelligent matching and inventory management system for automotive harness production materials according to claim 3, wherein the distribution emergency degree determining process of each replenishment instruction is as follows: for the material corresponding to each replenishment instruction, the following operations are executed: Comparing the real-time in-stock quantity of the material with the consumption rate of unit time to obtain the residual production time of the current stock which can maintain production; comparing the residual production time with the replenishment advance period, and if the residual production time is smaller than or equal to the replenishment advance period, distributing the highest distribution emergency degree for the replenishment instruction; If the remaining production time is greater than the replenishment advance period, calculating a difference value between the remaining production time and the replenishment advance period; And determining the corresponding distribution emergency degree according to the preset interval in which the difference value falls, wherein the smaller the difference value is, the higher the corresponding emergency degree level is.
  7. 7. The intelligent matching and inventory management system for automotive wiring harness production materials of claim 6, further comprising, in the distribution urgency determination of each replenishment instruction: Determining the latest planned starting time of each replenishment order according to the planned delivery date and the planned production period of all executable work orders corresponding to the materials in each replenishment order; Inquiring the materials in each replenishment instruction, except for a target production line, the total times of the materials in other replenishment instructions which are generated and have the latest planned starting time earlier than the current replenishment instruction, and taking the total times as the shortage influence factors of the replenishment instructions; Based on the distribution emergency degree determined by the comparison result of the residual production time and the replenishment earlier period, carrying out weighted fusion by combining the shortage influence factors to obtain the comprehensive emergency degree; and (3) arranging all the replenishment instructions in a descending order according to the comprehensive emergency degree, and determining the final position of each replenishment instruction in the distribution sequence.

Description

Intelligent matching and inventory management system for automobile wire harness production materials Technical Field The invention relates to the technical field of material management in production and manufacturing, in particular to an intelligent matching and inventory management system for automobile wire harness production materials. Background Automotive wiring harnesses are a central component of automotive electrical systems, the production of which typically involves a variety of materials, such as wires, terminals, connectors, etc., and which are widely different in demand from one production job ticket to another and frequently reused. The same material is easy to be shared by a plurality of production worksheets at the same time. At present, most of matching and inventory management of materials are performed in a regular interval replenishment mode. When the method faces the complex scene that the production work orders are large in quantity and the production plans are frequently adjusted, the real-time consumption pressure of the materials cannot be adjusted according to the specific work orders, the general materials are occupied by the non-urgent work orders easily, and the urgent work orders are interrupted due to the shortage of the materials. Meanwhile, the material is difficult to trigger and replenish in advance, so that stock backlog and shortage risk of the material are easily caused, and the production line is interrupted. Disclosure of Invention The invention aims to overcome the defects of the prior art, accurately predicts the consumption trend of materials and dynamically adjusts the replenishment strategy by linking the work order requirement and the stock state in real time, and avoids the problems of stock backlog and shortage risk of the materials caused by delayed replenishment response of the materials, thereby interrupting the production line. The technical scheme includes that the intelligent matching and inventory management system for the automobile wire harness production materials comprises a work order analysis module, a work order management module, a material management module and a material management module, wherein the work order analysis module is used for acquiring corresponding bill of materials and required quantity according to production work orders, acquiring material preparation rate by combining the current available inventory quantity of the materials, generating an executable work order queue, and acquiring reference consumption rate of the materials in the executable work order queue. And the replenishment triggering module is used for acquiring real-time inventory quantity of each material in the executable work order queue, determining a dynamic replenishment point by combining the reference consumption rate and the replenishment advance period, and generating a replenishment instruction when the real-time inventory quantity is smaller than or equal to the dynamic replenishment point. And the delivery scheduling module is used for determining the delivery emergency degree of each replenishment instruction according to the real-time inventory and consumption dynamics of the materials and combining the replenishment advance period, and carrying out descending arrangement to generate a delivery sequence. And the execution feedback module is used for issuing the distribution sequence to the execution terminal to execute the replenishment task, and re-acquiring the real-time inventory after the replenishment is completed, and if the inventory is smaller than or equal to the dynamic replenishment point and no replenishment task is to be executed, regenerating a replenishment instruction, otherwise, continuing monitoring. Compared with the prior art, the intelligent matching and inventory dynamic management of the automobile wire harness production materials are realized through the cooperative operation of the work order analysis module, the replenishment triggering module, the distribution scheduling module and the execution feedback module. The system is used for accurately calculating material demands and preparation rate based on production work orders and real-time inventory, generating an executable work order queue and predicting consumption standard, further realizing intelligent triggering of replenishment through dynamic replenishment points, carrying out priority ordering on replenishment instructions by combining multidimensional factors, and finally forming a management closed loop through execution feedback. The invention effectively improves the timeliness of material replenishment, reduces stock backlog and shortage risk, and ensures the smooth execution of the production plan. Drawings In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the drawings that are needed for the description of the embodiments will be briefly described below, and it is obvious that the drawings in the follo