Bill-of-material comparison system

Abstract

To provide a bill-of-material comparison system which even enables verification of whether parent numbers of a certain part number are the same and whether qualities used are the same.SOLUTION: A bill-of-material comparison system 10 is provided, comprising a storage unit 11 for storing a bill of material prepared by a first department and a bill of material prepared by a second department, an integration unit 12 for integrating the bill of material prepared by the first department and the bill of material prepared by the second department into a comparison table, and a verification unit 13 for verifying whether or not levels and quantities in both bills of material are the same and reflecting a verification result to the comparison table.SELECTED DRAWING: Figure 1

Description

[Technical field]

[0001] The present invention relates to a bill of materials matching system. [Background technology]

[0002] Cited document 1 describes a parts table generation device that compares part numbers searched for by a first part search means, which searches for part numbers of electronic parts from a part database storage means, with part numbers searched for by a second part search means, extracts matching part numbers and different part number, and determines the final part number based on the extraction results. [Prior art documents] [Patent documents]

[0003] [Patent Document 1] Japanese Patent Application Publication No. 10-240787 Summary of the Invention [Problem to be solved by the invention]

[0004] However, the bill of materials generation device in the cited document 1 only compares part numbers of individual parts, and is not able to check the number of parts when multiple pieces of the same part are used, or whether the combination of parent part numbers and child part numbers match. [Means for solving the problem]

[0005] In one embodiment, the parts bill comparison system consolidates the parts bills prepared by the first department and the second department into a single comparison table, checks whether the levels and quantities of both parts bills are equal, and reflects the results of the check in the comparison table. Effect of the Invention

[0006] According to the bill of materials comparison system of the present disclosure, the system can compare whether the parent numbers of certain product numbers are the same and even whether the quantities used are the same. [Brief description of the drawings]

[0007] [Figure 1] FIG. 1 is a block diagram of a parts table collation system according to an embodiment of the present invention. [Diagram 2] 5 is a flowchart showing an example of the operation of the BOM comparison system according to the present embodiment. [Diagram 3] FIG. 2 is a diagram illustrating an example of an EBOM and a PBOM. [Figure 4] FIG. 13 is a diagram showing an example of a comparison table between EBOM and PBOM. [Diagram 5] 5 is a flowchart showing an example of the operation of the BOM comparison system according to the present embodiment. [Figure 6] FIG. 13 is a diagram showing an example of a comparison table between EBOM and PBOM. DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS

[0008] (Present embodiment) Hereinafter, an embodiment of the present invention will be described with reference to the drawings. Fig. 1 is a block diagram of a BOM comparison system according to the present embodiment. In Fig. 1, a BOM comparison system 10 includes a storage unit 11, an integration unit 12, a confirmation unit 13, an input unit 14, and an output unit 15.

[0009] The storage unit 11 stores the parts bill prepared by the first department and the parts bill prepared by the second department. For example, the storage unit 11 is preferably a non-volatile memory, a solid state drive (SSD), or a hard disk drive (HDD).

[0010] The integration unit 12 integrates the parts bill prepared by the first department and the parts bill prepared by the second department, which are stored in the storage unit 11, into one comparison table. Then, the integration unit 12 stores the comparison table in the storage unit 11.

[0011] The confirmation unit 13 confirms whether the levels and quantities in both parts tables are the same, and reflects the confirmation result in the comparison table. The integration unit 12 and the confirmation unit 13 are preferably processors such as a CPU (Central Processing Unit).

[0012] The input unit 14 is an interface for inputting data on the parts bill prepared by the first department and the parts bill prepared by the second department. The input unit 14 is preferably, for example, a keyboard. If the data on the parts bill prepared by the first department and the parts bill prepared by the second department are stored in a memory card, the input unit 14 may be a memory card reader. If the data on the parts bill prepared by the first department and the parts bill prepared by the second department are stored in a file server on a network, the input unit 14 may be a network interface.

[0013] The output unit 15 displays the lookup table reflecting the confirmation result by the confirmation unit 13. For example, the output unit 15 is preferably a liquid crystal display.

[0014] Next, the operation of the BOM comparison system 10 will be described. Fig. 2 is a flowchart showing an example of the operation of the BOM comparison system according to this embodiment. In Fig. 2, an EBOM (Engineering Bill of Materials) is a BOM prepared by a design department. Also, a PBOM (Procurement Bill of Materials) is a BOM prepared by a procurement department.

[0015] 2, first, in step S201, the EBOM is acquired, and then the process proceeds to step S202. In step S202, the PBOM is acquired, and the process proceeds to step S203.

[0016] In step S203, each generation in the EBOM hierarchy is extracted, and the process proceeds to step S204. In step S204, each generation in the hierarchical layer of the PBOM is extracted, and the process proceeds to step S205.

[0017] In step S205, the hierarchical layers from the parent generation to the child generation of the EBOM are linked, and the process proceeds to step S206. In step S206, the hierarchical levels from the parent generation to the child generation of the PBOM are linked, and the process proceeds to step S207.

[0018] In step S207, the number of parts in the EBOM that are connected to the same hierarchy is counted, and the process proceeds to step S208. In step S208, the number of parts in the PBOM that are connected to the same hierarchy is counted, and the process proceeds to step S209.

[0019] In step S209, the EBOM and the PBOM are compiled into one correspondence table, and the process proceeds to step S210.

[0020] In step S210, a brute force search is performed to see if the levels and quantities of both parts tables are the same, and then the process proceeds to step S211.

[0021] In step S211, it is determined whether the levels and quantities of both parts bills are the same. If the levels and quantities of both parts bills are the same, the process proceeds to step S212. If the levels and quantities of both parts bills are different, the process ends.

[0022] In step S212, data in which the levels and quantities of both parts bills are the same is colored and output or displayed to distinguish it from data in which the levels and quantities of both parts bills are different, and then the process ends.

[0023] Next, the detailed processing of step S210 will be described. Fig. 3 is a diagram showing an example of EBOM and PBOM. Comparing the EBOM shown in the upper left of Fig. 3 with the PBOM shown in the upper right of Fig. 3, the way part numbers are held is different, and the management of parent numbers and level indication are also different. The EBOM and PBOM are stored as data in an equal form. The lower left and lower right of Fig. 3 show data in an equal form.

[0024] The column names shown in these tables are as follows: Number: Car serial number b_H_R: A string combining the "product number" and "level" of the PBOM c_H_R: A string combining the "product number" and "level" of the EBOM b_O_H_R: A string that combines the "Parent Part Number", "Part Number", and "Level" of the PBOM c_O_H_R: A string that combines the "Parent Part Number", "Part Number", and "Level" of the EBOM b_O_H_R_C: A string that combines the counted values ​​of b_O_H_R in PBOM c_O_H_R_C: A string that combines the counted values ​​of c_O_H_R in EBOM

[0025] A cross-reference table combining the respective data is shown in Fig. 5. Fig. 4 shows an example of a cross-reference table between EBOM and PBOM.

[0026] Each part is checked against the check table shown in FIG. 5 is a flow chart showing an example of the operation of the BOM comparison system according to this embodiment, which shows details of step S210 shown in FIG.

[0027] First, in step S501, the first line of c_H_R is input to the system, and the process proceeds to step S502. Next, in step S502, the first row of b_H_R is input to the system. In step S503, the first row of c_H_R is compared with the first row of b_H_R.

[0028] Thereafter, the loop from step S502 to step S504 and the loop from step S501 to step S505 are performed on the i-th row of c_H_R and the j-th row of b_H_R, and are repeated until i becomes m and j becomes n.

[0029] The same process is also performed for _O_H_R and _O_H_R_C.

[0030] The EBOM and PBOM are compared against each other, and if the combination exists on the other side, the combination is colored. If the combination cannot be found, it is not colored. Figure 6 shows an example of an EBOM and PBOM comparison table. In Figure 6, the colors are expressed using grayscale instead.

[0031] As described above, according to the parts table collation system of this embodiment, the work is performed automatically, so that the number of collation steps is significantly reduced and human errors are eliminated.

[0032] The present invention is not limited to the above-described embodiment, and can be modified as appropriate without departing from the spirit and scope of the present invention.

[0033] Each element depicted in the drawings as a functional block performing various processes can be configured in hardware with a CPU, memory, and other circuits, and in software with a program loaded into memory, etc. Therefore, it will be understood by those skilled in the art that these functional blocks can be realized in various forms by hardware, software, or a combination thereof, and are not limited to any one of them.

[0034] The above-mentioned program can be stored and provided to a computer using various types of non-transitory computer-readable media. The non-transitory computer-readable media includes various types of tangible recording media. Examples of the non-transitory computer-readable media include magnetic recording media (e.g., flexible disks, magnetic tapes, hard disk drives), magneto-optical recording media (e.g., magneto-optical disks), CD-ROMs (Read Only Memory), CD-Rs, CD-R / Ws, and semiconductor memories (e.g., mask ROMs, PROMs (Programmable ROMs), EPROMs (Erasable PROMs), flash ROMs, and RAMs (Random Access Memory)). The program may also be provided to a computer by various types of temporary computer-readable media. Examples of the temporary computer-readable media include electrical signals, optical signals, and electromagnetic waves. The temporary computer-readable media can provide the program to a computer via a wired communication path such as an electric wire and an optical fiber, or via a wireless communication path. [Explanation of symbols]

[0035] 10 Bill of Materials Verification System 11 Storage section 12 Integration Department 13 Verification Section

Claims

[Claim 1] a storage unit that stores a parts list prepared by the first department and a parts list prepared by the second department; an integration unit that integrates the parts list prepared by the first department and the parts list prepared by the second department into one comparison table; a confirmation unit that confirms whether the hierarchical levels and quantities of both parts tables are equal and reflects the confirmation results in the confirmation table.

Images