Bill of material management method and device, readable storage medium and computer equipment

Abstract

The invention provides a bill of material management method and device, a readable storage medium and computer equipment, and belongs to the technical field of automobile production management, and the method comprises the steps: obtaining a first ordered material list according to the classification and sorting of parts of all existing automobile types on the same platform; determining a basic vehicle type according to the new vehicle type composition information of the same platform; according to the composition information of the basic vehicle type, establishing a first mapping relation between the basic vehicle type and the first ordered material list; generating a second ordered material list according to the composition information of the new vehicle type on the same platform and the first ordered material list; according to the composition information of the basic vehicle model and the composition information of the new vehicle models on the same platform, establishing a second mapping relation between the new vehicle models on the same platform and a second ordered material list; and according to the first mapping relation and the second mapping relation, part classification information corresponding to the new vehicle type on the same platform in the second ordered material list is determined. The method can solve the problem that the mode of firstly compiling the workpiece increase and decrease list and then compiling the engineering material list is not beneficial to part management and change.

Description

Technical Field

[0001] The present invention belongs to the technical field of automobile production management, and specifically relates to a bill of materials management method, device, readable storage medium and computer equipment. Background Art

[0002] In the automobile manufacturing process, the preparation of the parts list and the engineering bill of materials (EBOM) are two key steps, which correspond to different stages of product development. The parts list is usually prepared in the early stage of product design, which involves the preliminary planning of new parts that may appear in the vehicle design or old parts that need to be replaced. The engineering bill of materials is prepared after the product design is completed. It contains detailed information about the product design and is the basis for every link of the product from concept to market.

[0003] With the entry of new car manufacturers, the cycle of car modification and update is getting shorter and shorter. Among them, whether it is a new development or a modified model, there is a reference model. Correspondingly, in terms of material management, the usual practice is to first compile a list of added and reduced parts for the development of various preliminary work, and then compile an engineering material list to open up the upstream and downstream information flow from R&D to manufacturing, procurement, logistics and sales.

[0004] However, this method is repetitive and inefficient, and it also artificially separates the EBOM of the base model and the EBOM of the new model, which is not conducive to the full-configuration EBOM management of models on the same platform. During manufacturing, it is impossible to quickly understand the usage of special parts and common parts between products, which brings great inconvenience to parts management and changes. Summary of the invention

[0005] Based on this, an embodiment of the present invention provides a bill of materials management method, system, readable storage medium and computer device, which aims to solve the technical problem that the prior art first compiles a list of added and removed parts and then compiles a bill of materials for the project, resulting in duplicated workload, low efficiency, and inconvenience in parts management and changes.

[0006] A first aspect of an embodiment of the present invention provides a bill of materials management method, the method comprising:

[0007] According to the marking attributes of the parts of all existing models on the same platform, the first ordered material list is obtained by classification and sorting;

[0008] According to the composition information of the new model on the same platform, at least one basic model is determined from all existing models on the same platform;

[0009] Establishing a first mapping relationship between the basic vehicle model and the first ordered material table according to the composition information of the basic vehicle model;

[0010] Generate a second ordered material list according to the composition information of the new model on the same platform and the first ordered material list;

[0011] Establishing a second mapping relationship between the new model on the same platform and the second ordered material table according to the composition information of the basic model and the composition information of the new model on the same platform;

[0012] According to the first mapping relationship and the second mapping relationship, the component classification information corresponding to the new model of the same platform in the second ordered material table is determined, wherein the component classification information includes newly added parts, deleted parts, and shared parts.

[0013] In summary, according to the above-mentioned bill of materials management method, by obtaining the marking attributes of the parts of all existing models on the same platform, the first ordered material is obtained by classifying and sorting them, and then according to the EBOM of the new model on the same platform, the basic model is determined from all existing models on the same platform, and according to the EBOM of the basic model, a mapping relationship between the basic model and the aforementioned parts is established in the first ordered material, so that the component composition of each basic model can be conveniently managed through the first ordered material, and then according to the EBOM of the new model on the same platform and the first ordered material table, the parts of the new model on the same platform that do not reuse the parts in the first ordered material table are added to the first ordered material table, and the second ordered material table is obtained by classifying and sorting them, and then according to the EBOM of the basic model and the EBOM of the new model on the same platform, a mapping relationship between the new model on the same platform and the parts in the table is established in the second ordered material table, so that through the second The ordered material table can conveniently manage the component composition of each new model on the same platform, as well as the status of each new model on the same platform being able to reuse the components of the basic model. Finally, according to the mapping relationship between the basic model, the new model on the same platform and the components in the table, determine in the second ordered material table which components are new parts, deleted parts and shared parts of the new model on the same platform. In subsequent applications, the second ordered material can be used to complete the preparation of the list of added and reduced parts, the EBOM of a single project on the same platform, and the screening and extraction of the EBOM of multiple projects on the same platform. For example, if a list of added and reduced parts for a new model on the same platform is needed later, or if the new model on the same platform needs to reuse the reused parts of the basic model, or if the EBOM of the basic model and the newly developed model needs to be merged, the second ordered material table can be directly used for screening and extraction, which greatly improves work efficiency and the effectiveness of material data management while ensuring the accuracy of the data.

[0014] In addition, a bill of materials management method according to the above embodiment of the present invention may also have the following additional technical features:

[0015] Furthermore, the step of generating a second ordered material list according to the composition information of the new model on the same platform and the first ordered material list includes:

[0016] According to the composition information of the new model on the same platform, obtaining the dedicated parts and borrowed parts among the components of the new model on the same platform;

[0017] The second ordered material list is obtained by classifying and sorting the special parts, the borrowed parts and the parts of all existing models on the same platform according to their marking attributes.

[0018] Furthermore, the step of establishing a second mapping relationship between the new vehicle model on the same platform and the second ordered material table according to the composition information of the basic vehicle model and the composition information of the new vehicle model on the same platform includes:

[0019] Obtaining the compatibility confirmation information of the components in the base model and the new model on the same platform;

[0020] A second mapping relationship between the new model on the same platform and the second ordered material list is established according to the adaptation confirmation information and the composition information of the new model on the same platform.

[0021] Furthermore, the step of determining the component classification information corresponding to the new vehicle model on the same platform in the second ordered material table according to the first mapping relationship and the second mapping relationship includes:

[0022] Obtain a first quantity value of the basic vehicle model that each component in the second ordered material list is adapted to;

[0023] Obtain a second quantity value of the new vehicle model on the same platform that is adapted to each component in the second ordered material list;

[0024] Obtain a third quantity value of the sum of the quantity of the basic vehicle model and the new vehicle model on the same platform adapted by each component in the second ordered material list;

[0025] The component classification information is obtained by filtering according to the first quantity value, the second quantity value, and the third quantity value.

[0026] Furthermore, the step of filtering and obtaining the component classification information according to the first quantity value, the second quantity value, and the third quantity value includes:

[0027] Step 1: determining whether the first quantity value is equal to the third quantity value, and whether the first quantity value is a non-zero quantity value;

[0028] If so, the corresponding parts are newly added parts of the new model of the same platform;

[0029] Determine whether the second quantity value corresponding to the remaining parts is equal to the third quantity value, and whether the second quantity value is a non-zero quantity value;

[0030] If so, the corresponding parts are deleted parts of the new model of the same platform;

[0031] Step 2: determine whether the third quantity value corresponding to the remaining parts is less than the minimum value between the quantity of the basic model and the quantity of the new model on the same platform;

[0032] If so, the corresponding parts are determined as new parts or deleted parts of the new model on the same platform according to actual needs;

[0033] The components whose corresponding third quantity values ​​are non-zero among the remaining components are determined as the common parts of the new model on the same platform.

[0034] Furthermore, the marking attributes include a unified part number and a part assembly position serial number.

[0035] A second aspect of an embodiment of the present invention provides a bill of materials management device, the bill of materials management device comprising:

[0036] A first generation module is used to classify and sort the parts of all existing models of the same platform to obtain a first ordered material list according to the marking attributes of the parts;

[0037] A first determination module is used to determine at least one basic model from all existing models on the same platform according to the composition information of the new model on the same platform;

[0038] A first mapping module, configured to establish a first mapping relationship between the basic vehicle model and the first ordered material table according to the composition information of the basic vehicle model;

[0039] A second generating module, configured to generate a second ordered material list according to the composition information of the new model on the same platform and the first ordered material list;

[0040] A second mapping module, used for establishing a second mapping relationship between the new model on the same platform and the second ordered material table according to the composition information of the basic model and the composition information of the new model on the same platform;

[0041] The second determination module is used to determine the component classification information corresponding to the new model of the same platform in the second ordered material table according to the first mapping relationship and the second mapping relationship, wherein the component classification information includes newly added parts, deleted parts, and shared parts.

[0042] A third aspect of an embodiment of the present invention provides a readable storage medium, wherein the readable storage medium stores one or more programs, which, when executed, implement the above-mentioned bill of materials management method.

[0043] A fourth aspect of an embodiment of the present invention provides a computer device, the computer device comprising a memory and a processor, wherein:

[0044] The memory is used to store computer programs;

[0045] When the processor is used to execute the computer program stored in the memory, the above-mentioned bill of materials management method is implemented.

[0046] Additional aspects and advantages of the present invention will be given in part in the following description and in part will be obvious from the following description or will be learned through embodiments of the present invention. BRIEF DESCRIPTION OF THE DRAWINGS

[0047] Figure 1 A flowchart of a bill of materials management method proposed in the first embodiment of the present invention;

[0048] Figure 2 A schematic diagram of the structure of a bill of materials management device proposed in a fourth embodiment of the present invention;

[0049] Figure 3 is a schematic diagram of the structure of a second ordered material table in an embodiment of the present invention;

[0050] The following specific implementation manner will further illustrate the present invention in conjunction with the above-mentioned drawings. DETAILED DESCRIPTION

[0051] In order to facilitate the understanding of the present invention, the present invention will be described more fully below with reference to the relevant drawings. Several embodiments of the present invention are given in the drawings. However, the present invention can be implemented in many different forms and is not limited to the embodiments described herein. On the contrary, the purpose of providing these embodiments is to make the disclosure of the present invention more thorough and comprehensive.

[0052] It should be noted that when an element is referred to as being "fixed to" another element, it may be directly on the other element or there may be a central element. When an element is considered to be "connected to" another element, it may be directly connected to the other element or there may be a central element at the same time. The terms "vertical", "horizontal", "left", "right" and similar expressions used herein are for illustrative purposes only.

[0053] Unless otherwise defined, all technical and scientific terms used herein have the same meaning as those commonly understood by those skilled in the art of the present invention. The terms used herein in the specification of the present invention are only for the purpose of describing specific embodiments and are not intended to limit the present invention. The term "and / or" used herein includes any and all combinations of one or more related listed items.

[0054] Embodiment 1

[0055] See also Figure 1 , Figure 1 A flow chart of a bill of materials management method provided by the first embodiment of the present invention is shown. The method specifically includes steps S100 to S600.

[0056] Step S100: Classify and sort the parts of all existing models on the same platform according to their marking attributes to obtain a first ordered material list;

[0057] In this step, the same platform model refers to vehicles of different brands or models that share the same automobile manufacturing platform. These models usually have commonality in mechanical structure, engineering design and certain components, but they may differ according to different design concepts and market positioning, including exterior design, interior style, configuration level, etc. Specifically, a material table can be generated, in which the parts of all existing models on the same platform are set at the first position of each row, and at the same time, they are sorted according to the unified part number and the serial number of the part assembly position, so as to obtain an ordered table, thereby facilitating material data management. Among them, the unified part number can be set with reference to relevant Chinese standards. For example, the unified part number consists of the enterprise name code, group number, group number, part number, structure distinction number, and change experience code (repair part code). This numbering method helps to accurately identify and track parts during automobile maintenance and manufacturing. The part assembly position number is used to identify the exact position of each part during the product assembly process. This number is crucial to ensuring the correct assembly sequence and reducing assembly errors. By using the part assembly position number, engineers and technicians can clearly understand where each part should be installed in the product and its relative position relationship with other parts.

[0058] Step S200: determining at least one basic model from all existing models on the same platform according to the composition information of the new model on the same platform;

[0059] In this step, based on the EBOM of the new model on the same platform, the base model with the highest parts reuse rate can be determined from all existing models on the same platform. It should be noted that in automobile manufacturing, the base model usually refers to the most basic and standard version of a series of products. This version usually provides the core features and necessary functions of the series of models, and does not contain too many high-end configurations or special equipment. It is the basis for the development of other derivative models (such as high-end version, sports version, luxury version, etc.). The design and engineering focus of the base model is to ensure the basic functions, safety, reliability and economy of the vehicle, laying the foundation for subsequent market segmentation and personalized customization. In addition, the base model can be one or more than one. The specific number is set according to the actual situation, and is generally based on the various models in an existing project.

[0060] Step S300: establishing a first mapping relationship between the basic vehicle model and the first ordered material table according to the composition information of the basic vehicle model;

[0061] In this step, according to the EBOM of the basic model, each basic model can be set at the first place of several columns arranged side by side in the aforementioned material table, and then all the parts of a basic model in each column are compared with the parts at the beginning of the row. When the comparison shows corresponding parts, mark the intersection of the rows and columns, such as checking or circling. When all the marks in a column are selected, all the parts information of a basic model can be directly obtained.

[0062] Step S400: Generate a second ordered material list according to the composition information of the new model on the same platform and the first ordered material list, that is, add the parts of the new model on the same platform that are not reused in the basic model into the first ordered material list, so as to obtain the second ordered material list;

[0063] Specifically, according to the EBOM of the new model on the same platform, the special parts and borrowed parts in the components of the new model on the same platform are obtained, and according to the marking attributes of the special parts, borrowed parts and parts of all existing models on the same platform, the second ordered material table is obtained by classification and sorting. Among them, special parts refer to parts used only on new models on the same platform and do not include parts in the aforementioned first ordered material table, and borrowed parts refer to parts used in models other than the basic model and do not include parts in the aforementioned first ordered material table.

[0064] Illustratively, based on the EBOM of new models on the same platform, each new model on the same platform can be set in turn at the first position of several columns set side by side in the aforementioned first ordered material table, and then several rows can be added to the aforementioned material table, and then the special parts and borrowed parts of the new models on the same platform can be set at the first position of these newly added rows, and the positions of the newly added rows can be classified and sorted according to the unified part numbers and part assembly position serial numbers of the parts placed, so that the parts with installation positions similar to those of the basic models in the newly added rows are classified and sorted together, and finally an updated ordered material table is obtained, which is the second ordered material table.

[0065] Step S500: establishing a second mapping relationship between the new model on the same platform and the second ordered material table according to the composition information of the basic model and the composition information of the new model on the same platform;

[0066] Obtaining the compatibility confirmation information of the parts in the base model and the new model on the same platform. Specifically, the engineering and technical personnel compare the compatibility and adaptability of the parts in the base model with the new model to determine whether all the parts of the base model are compatible with the new model on the same platform. If they are compatible, the adaptation confirmation information is generated;

[0067] According to the adaptation confirmation information and the composition information of the new model on the same platform, a second mapping relationship between the new model on the same platform and the second ordered material table is established. Specifically, according to the generated adaptation confirmation information, the intersection of the row where the corresponding reusable parts are located and the column where a basic model are located is marked in the second ordered material table, and the intersection of the row where the special parts and borrowed parts of the new model on the same platform and the column where a basic model are located is marked in the second ordered material table. The aforementioned markings can be made by checking, circling, etc., so when all the marks in a column where a new model on the same platform is located are selected, all the parts information of a new model on the same platform can be directly obtained.

[0068] Step S600: Determine the component classification information corresponding to the new model of the same platform in the second ordered material table according to the first mapping relationship and the second mapping relationship, wherein the component classification information includes newly added components, deleted components, and shared components.

[0069] Specifically, in the updated ordered material table, based on the correspondence between the basic model, the new model on the same platform and the parts in the table, filter to determine which parts are newly added parts of the new model on the same platform, filter to determine which parts are deleted parts of the new model on the same platform, and filter to determine which parts are shared parts between the new model on the same platform and the basic model.

[0070] In summary, according to the above-mentioned bill of materials management method, by obtaining the marking attributes of the parts of all existing models on the same platform, the first ordered material is obtained by classifying and sorting them, and then according to the EBOM of the new model on the same platform, the basic model is determined from all existing models on the same platform, and according to the EBOM of the basic model, a mapping relationship between the basic model and the aforementioned parts is established in the first ordered material, so that the component composition of each basic model can be conveniently managed through the first ordered material, and then according to the EBOM of the new model on the same platform and the first ordered material table, the parts of the new model on the same platform that do not reuse the parts in the first ordered material table are added to the first ordered material table, and the second ordered material table is obtained by classifying and sorting them, and then according to the EBOM of the basic model and the EBOM of the new model on the same platform, a mapping relationship between the new model on the same platform and the parts in the table is established in the second ordered material table, so that through the second The ordered material table can conveniently manage the component composition of each new model on the same platform, as well as the status of each new model on the same platform being able to reuse the components of the basic model. Finally, according to the mapping relationship between the basic model, the new model on the same platform and the components in the table, determine in the second ordered material table which components are new parts, deleted parts and shared parts of the new model on the same platform. In subsequent applications, the second ordered material can be used to complete the preparation of the list of added and reduced parts, the EBOM of a single project on the same platform, and the screening and extraction of the EBOM of multiple projects on the same platform. For example, if a list of added and reduced parts for a new model on the same platform is needed later, or if the new model on the same platform needs to reuse the reused parts of the basic model, or if the EBOM of the basic model and the newly developed model needs to be merged, the second ordered material table can be directly used for screening and extraction, which greatly improves work efficiency and the effectiveness of material data management while ensuring the accuracy of the data.

[0071] Embodiment 2

[0072] A bill of materials management method provided by the second embodiment of the present invention specifically includes the following steps:

[0073] Step S100: Classify and sort the parts of all existing models on the same platform according to their marking attributes to obtain a first ordered material list;

[0074] Step S200: determining at least one basic model from all existing models on the same platform according to the composition information of the new model on the same platform;

[0075] Step S300: establishing a first mapping relationship between the basic vehicle model and the first ordered material table according to the composition information of the basic vehicle model;

[0076] Step S400, generating a second ordered material list according to the composition information of the new model on the same platform and the first ordered material list;

[0077] Step S500: establishing a second mapping relationship between the new model on the same platform and the second ordered material table according to the composition information of the basic model and the composition information of the new model on the same platform;

[0078] Step S610, obtaining a first quantity value of the basic vehicle model adapted by each component in the second ordered material table, obtaining a second quantity value of the new vehicle model on the same platform adapted by each component in the second ordered material table, and obtaining a third quantity value of the sum of the quantity of the basic vehicle model and the new vehicle model on the same platform adapted by each component in the second ordered material table;

[0079] In step S610, illustratively, Figure 3 As shown, three columns (represented by AH, AI, and AG respectively) can be set in the updated first ordered material table. The AH column counts the number of basic vehicle models that each component in the table is adapted to, the AI ​​column counts the number of new vehicle models on the same platform that each component in the table is adapted to, and the AG column counts the sum of the quantity values ​​in the same row in the first and second columns.

[0080] Step S620: Filter and obtain component classification information according to the first quantity value, the second quantity value, and the third quantity value, wherein the component classification information includes newly added components, deleted components, and shared components.

[0081] In summary, according to the above-mentioned bill of materials management method, by obtaining the marking attributes of the parts of all existing models on the same platform, the first ordered material is obtained by classifying and sorting them, and then according to the EBOM of the new model on the same platform, the basic model is determined from all existing models on the same platform, and according to the EBOM of the basic model, a mapping relationship between the basic model and the aforementioned parts is established in the first ordered material, so that the component composition of each basic model can be conveniently managed through the first ordered material, and then according to the EBOM of the new model on the same platform and the first ordered material table, the parts of the new model on the same platform that do not reuse the parts in the first ordered material table are added to the first ordered material table, and the second ordered material table is obtained by classifying and sorting them, and then according to the EBOM of the basic model and the EBOM of the new model on the same platform, a mapping relationship between the new model on the same platform and the parts in the table is established in the second ordered material table, so that through the second The ordered material table can conveniently manage the component composition of each new model on the same platform, as well as the status of each new model on the same platform being able to reuse the components of the basic model. Finally, according to the mapping relationship between the basic model, the new model on the same platform and the components in the table, determine in the second ordered material table which components are new parts, deleted parts and shared parts of the new model on the same platform. In subsequent applications, the second ordered material can be used to complete the preparation of the list of added and reduced parts, the EBOM of a single project on the same platform, and the screening and extraction of the EBOM of multiple projects on the same platform. For example, if a list of added and reduced parts for a new model on the same platform is needed later, or if the new model on the same platform needs to reuse the reused parts of the basic model, or if the EBOM of the basic model and the newly developed model needs to be merged, the second ordered material table can be directly used for screening and extraction, which greatly improves work efficiency and the effectiveness of material data management while ensuring the accuracy of the data.

[0082] Embodiment 3

[0083] A bill of materials management method provided in the third embodiment of the present invention specifically includes the following steps:

[0084] Step S100: Classify and sort the parts of all existing models on the same platform according to their marking attributes to obtain a first ordered material list;

[0085] Step S200: determining at least one basic model from all existing models on the same platform according to the composition information of the new model on the same platform;

[0086] Step S300: establishing a first mapping relationship between the basic vehicle model and the first ordered material table according to the composition information of the basic vehicle model;

[0087] Step S400, generating a second ordered material list according to the composition information of the new model on the same platform and the first ordered material list;

[0088] Step S500: establishing a second mapping relationship between the new model on the same platform and the second ordered material table according to the composition information of the basic model and the composition information of the new model on the same platform;

[0089] Step S610, obtaining a first quantity value of the basic vehicle model adapted by each component in the second ordered material table, obtaining a second quantity value of the new vehicle model on the same platform adapted by each component in the second ordered material table, and obtaining a third quantity value of the sum of the quantity of the basic vehicle model and the new vehicle model on the same platform adapted by each component in the second ordered material table;

[0090] Step S621: determine whether the first quantity value is equal to the third quantity value, and whether the first quantity value is a non-zero quantity value.

[0091] If so, the corresponding parts are new additions to the new model on the same platform;

[0092] Specifically, Figure 3 As shown, in the second ordered material table, the non-zero numbers in the statistics of the AH column and the zero items in the statistics of the AI ​​column can be filtered. At this time, the first quantity value is equal to the third quantity value, and the AJ column is set in the second ordered material table, and the letter A is marked in the AJ column to indicate that this behavior is a deleted item.

[0093] Determine whether the second quantity value corresponding to the remaining components is equal to the third quantity value, and whether the second quantity value is a non-zero quantity value;

[0094] If so, the corresponding parts are deleted parts of the new model on the same platform;

[0095] Specifically, Figure 3 As shown, the non-zero numbers in the statistics of the AI ​​column and the zero items in the statistics of the AH column can be filtered. At this time, the second quantity value is equal to the third quantity value, and the letter D is marked in the AJ column to indicate that this line is deleted.

[0096] Step S622:

[0097] Step S6221: Determine whether the third quantity value corresponding to the remaining parts is less than the minimum value between the quantity of the basic model and the quantity of the new model on the same platform;

[0098] If so, the corresponding parts are determined as new or deleted parts for the new model on the same platform according to actual needs;

[0099] Specifically, Figure 3As shown, the cells in the AJth column that are not marked with the letter A and the letter D can be filtered, and it can be determined whether the quantity value in the corresponding AGth column statistics is less than the minimum value of the number of basic models and the number of new models on the same platform. When the quantity value is less than the minimum value of the number of basic models and the number of new models on the same platform, it means that the number of these parts is very small. At this time, engineering and technical personnel will mark the letter A or the letter D in the corresponding cells in the AJth column based on the actual demand of the new models on the same platform.

[0100] Step S6222: Determine the components among the remaining components whose corresponding third quantity values ​​are non-zero quantity values ​​as common parts for the new model on the same platform.

[0101] Specifically, Figure 3 As shown, the rows where the cells in the AJth column that are not marked with the letters A and D are located are filtered out, and the rows where the cells corresponding to the non-zero numbers in the statistics in the AGth column are located are filtered out. The components corresponding to the final filtered rows are the common parts of the new model and the basic model on the same platform.

[0102] In summary, according to the above-mentioned bill of materials management method, by obtaining the marking attributes of the parts of all existing models on the same platform, the first ordered material is obtained by classifying and sorting them, and then according to the EBOM of the new model on the same platform, the basic model is determined from all existing models on the same platform, and according to the EBOM of the basic model, a mapping relationship between the basic model and the aforementioned parts is established in the first ordered material, so that the component composition of each basic model can be conveniently managed through the first ordered material, and then according to the EBOM of the new model on the same platform and the first ordered material table, the parts of the new model on the same platform that do not reuse the parts in the first ordered material table are added to the first ordered material table, and the second ordered material table is obtained by classifying and sorting them, and then according to the EBOM of the basic model and the EBOM of the new model on the same platform, a mapping relationship between the new model on the same platform and the parts in the table is established in the second ordered material table, so that through the second The ordered material table can conveniently manage the component composition of each new model on the same platform, as well as the status of each new model on the same platform being able to reuse the components of the basic model. Finally, according to the mapping relationship between the basic model, the new model on the same platform and the components in the table, determine in the second ordered material table which components are new parts, deleted parts and shared parts of the new model on the same platform. In subsequent applications, the second ordered material can be used to complete the preparation of the list of added and reduced parts, the EBOM of a single project on the same platform, and the screening and extraction of the EBOM of multiple projects on the same platform. For example, if a list of added and reduced parts for a new model on the same platform is needed later, or if the new model on the same platform needs to reuse the reused parts of the basic model, or if the EBOM of the basic model and the newly developed model needs to be merged, the second ordered material table can be directly used for screening and extraction, which greatly improves work efficiency and the effectiveness of material data management while ensuring the accuracy of the data.

[0103] Embodiment 4

[0104] Another embodiment of the present invention provides a material bill management device 300, see Figure 2 , the device comprises:

[0105] The first generation module 310 is used to classify and sort the parts of all existing models of the same platform to obtain a first ordered material list;

[0106] A first determination module 320, configured to determine at least one basic model from all existing models on the same platform according to the composition information of the new model on the same platform;

[0107] A first mapping module 330, configured to establish a first mapping relationship between a basic vehicle model and a first ordered material table according to the composition information of the basic vehicle model;

[0108] The second generating module 340 is used to generate a second ordered material list according to the composition information of the new model of the same platform and the first ordered material list;

[0109] A second mapping module 350, for establishing a second mapping relationship between the new model on the same platform and the second ordered material table according to the composition information of the basic model and the composition information of the new model on the same platform;

[0110] The second determination module 360 ​​is used to determine the component classification information corresponding to the new model of the same platform in the second ordered material table according to the first mapping relationship and the second mapping relationship, wherein the component classification information includes newly added parts, deleted parts, and shared parts.

[0111] In some optional embodiments of the present invention, the second generating module 340 further includes:

[0112] The first acquisition module is used to acquire the special parts and borrowed parts among the components of the new model on the same platform according to the composition information of the new model on the same platform;

[0113] The first table building module is used to classify and sort the special parts, borrowed parts and parts of all existing models on the same platform to obtain a second ordered material table according to their marking attributes.

[0114] In some optional embodiments of the present invention, the second mapping module 350 further includes:

[0115] The second acquisition module is used to obtain the adaptation confirmation information of the parts in the basic model and the new model on the same platform;

[0116] The second table building module is used to establish a second mapping relationship between the new model on the same platform and the second ordered material table according to the adaptation confirmation information and the composition information of the new model on the same platform.

[0117] In some optional embodiments of the present invention, the second determining module 360 ​​includes:

[0118] The third acquisition module is used to obtain the first quantity value of the basic vehicle model adapted by each component in the second ordered material table, obtain the second quantity value of the new vehicle model on the same platform adapted by each component in the second ordered material table, and obtain the third quantity value of the sum of the quantity of the basic vehicle model and the new vehicle model on the same platform adapted by each component in the second ordered material table;

[0119] The first screening module is used to screen and obtain component classification information according to the first quantity value, the second quantity value and the third quantity value, wherein the component classification information includes newly added components, deleted components and shared components.

[0120] In some optional embodiments of the present invention, the first screening module includes:

[0121] A first judgment and selection module is used to judge whether the first quantity value is equal to the third quantity value, and whether the first quantity value is a non-zero quantity value;

[0122] If so, the corresponding parts are selected as the new parts for the new model on the same platform;

[0123] A first judgment selection module is used to judge whether the second quantity value corresponding to the remaining parts is equal to the third quantity value, and whether the second quantity value is a non-zero quantity value;

[0124] If so, the corresponding parts are selected as deleted parts for the new model of the same platform;

[0125] The first judgment selection module is used to judge whether the third quantity value corresponding to the remaining parts is less than the minimum value between the quantity of the basic model and the quantity of the new model on the same platform;

[0126] If so, the corresponding parts are selected and determined as added or deleted parts for the new model of the same platform according to actual needs;

[0127] The second screening module is used to determine the components whose corresponding third quantity values ​​among the remaining components are non-zero quantity values ​​as the common parts of the new models on the same platform.

[0128] In summary, according to the above-mentioned bill of materials management method, by obtaining the marking attributes of the parts of all existing models on the same platform, the first ordered material is obtained by classifying and sorting them, and then according to the EBOM of the new model on the same platform, the basic model is determined from all existing models on the same platform, and according to the EBOM of the basic model, a mapping relationship between the basic model and the aforementioned parts is established in the first ordered material, so that the component composition of each basic model can be conveniently managed through the first ordered material, and then according to the EBOM of the new model on the same platform and the first ordered material table, the parts of the new model on the same platform that do not reuse the parts in the first ordered material table are added to the first ordered material table, and the second ordered material table is obtained by classifying and sorting them, and then according to the EBOM of the basic model and the EBOM of the new model on the same platform, a mapping relationship between the new model on the same platform and the parts in the table is established in the second ordered material table, so that through the second The ordered material table can conveniently manage the component composition of each new model on the same platform, as well as the status of each new model on the same platform being able to reuse the components of the basic model. Finally, according to the mapping relationship between the basic model, the new model on the same platform and the components in the table, determine in the second ordered material table which components are new parts, deleted parts and shared parts of the new model on the same platform. In subsequent applications, the second ordered material can be used to complete the preparation of the list of added and reduced parts, the EBOM of a single project on the same platform, and the screening and extraction of the EBOM of multiple projects on the same platform. For example, if a list of added and reduced parts for a new model on the same platform is needed later, or if the new model on the same platform needs to reuse the reused parts of the basic model, or if the EBOM of the basic model and the newly developed model needs to be merged, the second ordered material table can be directly used for screening and extraction, which greatly improves work efficiency and the effectiveness of material data management while ensuring the accuracy of the data.

[0129] Embodiment 5

[0130] Another aspect of the present invention further provides a computer-readable storage medium having one or more programs stored thereon, which implement the above-mentioned bill of materials management method when executed by a processor.

[0131] Embodiment 6

[0132] Another aspect of the present invention further provides a computer device, comprising a memory and a processor, wherein the memory is used to store a computer program, and the processor is used to execute the computer program stored in the memory to implement the above-mentioned bill of materials management method.

[0133] Those skilled in the art will appreciate that the logic and / or steps represented in the flowchart or otherwise described herein, for example, may be considered as an ordered list of executable instructions for implementing logical functions, and may be specifically implemented in any computer-readable medium for use by an instruction execution system, device or apparatus (such as a system based on a computer, a system including a processor, or other system that can fetch instructions from an instruction execution system, device or apparatus and execute instructions), or in conjunction with such instruction execution systems, devices or apparatuses. For purposes of this specification, "computer-readable medium" may be any device that can contain, store, communicate, propagate or transmit a program for use by an instruction execution system, device or apparatus, or in conjunction with such instruction execution systems, devices or apparatuses.

[0134] More specific examples of computer-readable media (a non-exhaustive list) include the following: an electrical connection with one or more wires (electronic device), a portable computer disk case (magnetic device), a random access memory (RAM), a read-only memory (ROM), an erasable and programmable read-only memory (EPROM or flash memory), an optical fiber device, and a portable compact disk read-only memory (CDROM). In addition, the computer-readable medium may even be a paper or other suitable medium on which the program is printed, since the program may be obtained electronically, for example, by optically scanning the paper or other medium, followed by editing, deciphering or, if necessary, processing in another suitable manner, and then stored in a computer memory.

[0135] It should be understood that the various parts of the present invention can be implemented by hardware, software, firmware or a combination thereof. In the above-mentioned embodiments, a plurality of steps or methods can be implemented by software or firmware stored in a memory and executed by a suitable instruction execution system. For example, if implemented by hardware, as in another embodiment, it can be implemented by any one of the following technologies known in the art or a combination thereof: a discrete logic circuit having a logic gate circuit for implementing a logic function for a data signal, a dedicated integrated circuit having a suitable combination of logic gate circuits, a programmable gate array (PGA), a field programmable gate array (FPGA), etc.

[0136] In the description of this specification, the description with reference to the terms "one embodiment", "some embodiments", "examples", "specific examples", or "some examples" means that the specific features, structures, materials or characteristics described in conjunction with the embodiment or example are included in at least one embodiment or example of the present invention. In this specification, the schematic representation of the above terms does not necessarily refer to the same embodiment or example. Moreover, the specific features, structures, materials or characteristics described may be combined in any one or more embodiments or examples in a suitable manner.

[0137] The above-mentioned embodiments only express several implementation modes of the present invention, and the descriptions thereof are relatively specific and detailed, but they cannot be understood as limiting the protection scope of the present invention. It should be pointed out that, for those of ordinary skill in the art, several variations and improvements can be made without departing from the concept of the present invention, and these all belong to the protection scope of the present invention. Therefore, the protection scope of the present invention shall be subject to the attached claims.

Claims

1. A bill of materials management method, characterized in that: The method comprises: According to the marking attributes of the parts of all existing models on the same platform, the first ordered material list is obtained by classification and sorting; According to the composition information of the new model on the same platform, at least one basic model is determined from all existing models on the same platform; Establishing a first mapping relationship between the basic vehicle model and the first ordered material table according to the composition information of the basic vehicle model; Generate a second ordered material list according to the composition information of the new model on the same platform and the first ordered material list; Establishing a second mapping relationship between the new model on the same platform and the second ordered material table according to the composition information of the basic model and the composition information of the new model on the same platform; According to the first mapping relationship and the second mapping relationship, the component classification information corresponding to the new model of the same platform in the second ordered material table is determined, wherein the component classification information includes newly added parts, deleted parts, and shared parts.

2. The material list management method according to claim 1, characterized in that: The step of generating a second ordered material list according to the composition information of the new model on the same platform and the first ordered material list comprises: According to the composition information of the new model on the same platform, obtaining the dedicated parts and borrowed parts among the components of the new model on the same platform; The second ordered material list is obtained by classifying and sorting the special parts, the borrowed parts and the parts of all existing models on the same platform according to their marking attributes.

3. The material list management method according to claim 1 or 2, characterized in that: The step of establishing a second mapping relationship between the new model on the same platform and the second ordered material table according to the composition information of the basic model and the composition information of the new model on the same platform includes: Obtaining the compatibility confirmation information of the components in the base model and the new model on the same platform; A second mapping relationship between the new model on the same platform and the second ordered material list is established according to the adaptation confirmation information and the composition information of the new model on the same platform.

4. The material list management method according to claim 1, characterized in that: The step of determining the component classification information corresponding to the new vehicle model on the same platform in the second ordered material table according to the first mapping relationship and the second mapping relationship comprises: Obtain a first quantity value of the basic vehicle model that each component in the second ordered material list is adapted to; Obtain a second quantity value of the new vehicle model on the same platform that is adapted to each component in the second ordered material list; Obtain a third quantity value of the sum of the quantity of the basic vehicle model and the new vehicle model on the same platform adapted by each component in the second ordered material list; The component classification information is obtained by filtering according to the first quantity value, the second quantity value, and the third quantity value.

5. The material list management method according to claim 4, characterized in that: The step of filtering and obtaining the component classification information according to the first quantity value, the second quantity value, and the third quantity value comprises: Step 1: determining whether the first quantity value is equal to the third quantity value, and whether the first quantity value is a non-zero quantity value; If so, the corresponding parts are newly added parts of the new model of the same platform; Determine whether the second quantity value corresponding to the remaining parts is equal to the third quantity value, and whether the second quantity value is a non-zero quantity value; If so, the corresponding parts are deleted parts of the new model of the same platform; Step 2: determine whether the third quantity value corresponding to the remaining parts is less than the minimum value between the quantity of the basic model and the quantity of the new model on the same platform; If so, the corresponding parts are determined as new parts or deleted parts of the new model on the same platform according to actual needs; The components whose corresponding third quantity values ​​are non-zero among the remaining components are determined as the common parts of the new model on the same platform.

6. The material list management method according to claim 1, characterized in that: The marking attributes include the unified part number and the part assembly position serial number.

7. A material bill management device, characterized in that: The bill of materials management device comprises: A first generation module is used to classify and sort the parts of all existing models of the same platform to obtain a first ordered material list according to the marking attributes of the parts; A first determination module is used to determine at least one basic model from all existing models on the same platform according to the composition information of the new model on the same platform; A first mapping module, configured to establish a first mapping relationship between the basic vehicle model and the first ordered material table according to the composition information of the basic vehicle model; A second generating module, configured to generate a second ordered material list according to the composition information of the new model on the same platform and the first ordered material list; a second mapping module, configured to establish a second mapping relationship between the new model on the same platform and the second ordered material table according to the composition information of the basic model and the composition information of the new model on the same platform; The second determination module is used to determine the component classification information corresponding to the new model of the same platform in the second ordered material table according to the first mapping relationship and the second mapping relationship, wherein the component classification information includes newly added parts, deleted parts, and shared parts.

8. A readable storage medium, characterized in that: The readable storage medium stores one or more programs, which, when executed by a processor, implement the bill of materials management method according to any one of claims 1 to 6.

9. A computer device, characterized in that: The computer device comprises a memory and a processor, wherein: The memory is used to store computer programs; When the processor is used to execute the computer program stored in the memory, the bill of materials management method described in any one of claims 1 to 6 is implemented.

Images