US20050154704A1 - Management apparatus, program and method for controlling data included in bill of material - Google Patents

Abstract

A BOM is merged to a BOM stored in a BOM data base by means of the component identification judgment means that compares the product record in the BOM file with the product listed in the BOM stored in the BOM data base and makes judgment conformity between these two product records and a BOM rearrangement means that has a BOM rearrangement means a coding rule estimating means determining the coding compliance. A component assembly flag and a component assembly status flag are appended to the BOM stored in the BOM data base so that the expansion to the lower hierarchal layers of the component is presented.

Description

FIELD OF THE INVENTION
• The present invention relates to a management apparatus, a management method and a management program for controlling the data included in a bill of material (we call BOM data, hereinafter), especially a BOM management apparatus, a BOM management method and a BOM management program that may consolidate plural BOMs which are compiled by different controlling systems applied to such plural BOMs (we call them plural BOMs which are compiled by different BOM controlling schemes, for the purpose of simplicity). The controlling function for the BOM management also includes the compilation function to generate BOMs in the present invention.
• A BOM is a list of parts used for a particular product and complied in an architectural formation to be compliant to the binding or complexity of the product members. For example, a BOM for an electric lamp is first complied with an electric power unit, a suspending column and a bulb and then the structural members such as a bulb socket, a switch, a power cable, a power plug are compiled in the lower hierarchal layers against the power unit which is an upper member. The component which has further composing components which are regarded as the lower hierarchal layers of the BOM, however, is called a component assembly.
• When a component assembly is purchased from an outside supplier, however, it is not treated as a component assembly even though the component is substantially presented as a component assembly in the BOM. For example, if the above electric lamp is manufactured by using a non-finished power unit, a suspending column and a bulb, these materials are not treated as component assemblies. The substantial purpose of the BOM is to manage the design drawings/specifications and the production procedures. It is not necessary to expand these power units and suspending columns into the components as the components assemblies in the lower hierarchal layer of the BOM controlling scheme.
• Now-a-day, every industrial products are requested to reduce a burden against the environment in the manufacturing and to implement a safety in the operation. For such request, the manufacturers have to disclose the hazard chemical contents or the failure rates of the products. These indicative and characteristic contents are studied and decided for each component used for the products. Therefore it is necessary to study and decide the standard values. It is normal that the suppliers submit these standard values of the components that the manufacturers have purchased from them. However, the purchasing parties need to evaluate and determine the standard values of the hazard chemical contents or the failure rates of the products if the supplier parties are not well funded or have ability for testing. In this case, it is necessary to put the component assembly in the lower hierarchal layer in the BOM.
• It is the quickest method to obtain and use the BOM from the suppliers in order to put the purchased component assembly in the lower hierarchal layer. However the submitted BOMs from the suppliers are different from those of the manufactures in the design and structuring system. Therefore it is necessary to merge the BOM controlling scheme for the purpose of making matches between the submitted BOMs and the manufactures BOMs for parallel use.
• The suppliers sometimes do not accept to supply BOMs to keep secrecy of the technologies. For the products that have large scale BOMs, the evaluation of the hazard chemical contents or failure rates of the products is not carried out if it is not clear, such as, which components are the components assemblies, whether the component is set in the lower hierarchal layer, or what is the reasons for the fact that the components are not set in such hierarchal positions.
• In the past time, BOMs have never used for such a purpose as recording the detail technical information for the environmental issues and the safety issues. However, thereference 1 discloses an example of the system that collects the information which is available through the internet regarding the component products other suppliers supply. The system has a capability to replace the product codes with the component codes controlled in the system and to provide a new list of the components. However the list of the components is a table to include the components without a strict rule but to facilitate the selection of the relevant components used for the product design or the material procurement. Therefore the list of the components is different from a BOM that shows the members that compose the finish product. Thereference 2 discloses another system that has a capability to record the unit price and the weight of the component which is put in the BOM and to compute the price and the weight of the finish product composed of the components recorded in the BOM. In such system, however, it is not necessary to put the component assembly in the lower hierarchal layers of the BOM and no description regarding such BOM structure has been given.
• Reference 1:
• Paragraph 0018-0043 andFIG. 1-11, Japanese Published Patent Application, 2001-265838, A (2001)
• Reference 2:
• Paragraph 0058-0087 and 0098-0110,FIGS. 1 and 10, Japanese Published Patent Application, 2001-331535, A (2001)
BRIEF SUMMARY OF THE INVENTION
• The conventional technologies, the present invention has an advantage that even when the BOMs which suppliers submit are those compiled by different BOM controlling schemes from the reference BOMs that the purchasing parties generate by using their different BOM controlling schemes. The BOM controlling scheme regarding the present invention can merge the suppliers+ BOMs to the purchasing parties+ BOMs through the structural rearrangement when the component assembly is put in the lower hierarchal layer of the BOM. The present invention has further advantage that the BOM controlling scheme regarding the present invention supports a large scale BOMs where the component assemblies are appropriately expanded to the lower hierarchal layers and present the causes of failures if such expansion is not properly done.
• The first advantage of the present invention is realized with the construction such that the BOM management apparatus, constructed with a computer, comprises a component identification judgment means that makes a judgment whether the components included in the BOMs of the suppliers are same as the components included the reference BOMs, a coding rule estimating means that estimates and makes a judgment whether the rule of coding the components that is included in the BOMs of the suppliers is same as the rule of coding the components that is included in the reference BOMs and a BOM rearrangement means that makes a new arrangement of the BOM data already compiled through the above means to meet the system of the reference BOM. Even if the system of the BOM of the supplier to expand the component assembly is different from the system of the reference BOM, the BOM of the supplier is conformed to meet the reference BOM and then can be merged to the reference BOM.
• The second advantage of the present invention is realized in such a way that the component data in the BOM include a component assembly flag that shows the whether the component is a component assembly and a component assembly status data that shows the expansion of the component assembly to the lower hierarchal layer. The component assembly flag and the component assembly status data are concurrently presented to when the BOMs are present on the display.
• By using this advantage, the person who uses the BOM of the present invention can easily get to know the status of the expansion of component assemblies or the reasons why the expansion has not been done.
• As explained above, the present invention facilitates to merge the suppliers' BOMs that are complied by the different system from the reference BOMs. Since the person who uses the BOM can easily get to know the status of the expansion of component assemblies and can effectively direct the expansion of the component assemblies or the evaluation of quantity of the hazard chemical contents or the failure rates of the products.
BRIEF DESCRIPTION OF THE DRAWINGS
• FIG. 1 is a block diagram that shows the BOM management apparatus regarding an embodiment of the present invention.
• FIG. 2 is a schematic that shows an example of the presentation of the BOM regarding an embodiment of the present invention.
• FIG. 3 is a schematic that shows an example of the presentation of the BOM which is input to the BOM management apparatus regarding an embodiment of the present invention.
• FIG. 4 is a schematic that shows an example regarding an embodiment of the present invention as for the presentation of the display of the console input and output means which is used for the purposes to operate the computer processing for the BOM management and to display the results of the computer process.
• FIG. 5 is a schematic that shows an example regarding an embodiment of the present invention as for the presentation of the display of the console input and output means which is used for the purpose to operate the computer processing for the BOM management and display the results of the computer process.
• FIG. 6 is a flow chart regarding an embodiment of the present invention that shows a part number conformity judgment process in order to rearrange the BOM in the BOM file to be compliant to the BOM stored in the BOM data base.
• FIG. 7 is a flow chart that shows an identification judgment process included in an part number conformity judgment process regarding an embodiment of the present invention.
• FIG. 8 is a flow chart of a part number conformity judgment included in part number conformity judgment process which is an embodiment of the present invention.
• FIG. 9 is a schematic that shows a content of in-process operation for BOM rearrangement after the process of the part number conformity judgment regarding an embodiment of the present invention.
• FIG. 10 is a schematic that shows the presentation of the display of the console input and output means by which the results of the part number conformity judgment is provided.
• FIG. 11 is a flow chart that shows the part number renumbering process, by which the BOM file is rearranged to be merged to the BOM stored in the BOM data base regarding the embodiment of the present invention.
• FIG. 12 is a schematic that shows a content of in-process operation at the completion time of the part number renumbering process in the embodiment of the present invention.
• FIG. 13 is a graphic presentation that shows the results of the part number renumbering process displayed on the console input and output means regarding the embodiment of the present invention.
• FIG. 14 is a schematic that shows a content of the BOM stored in the BOM data base at the completion time of the BOM merging process in the embodiment of the present invention.
• FIG. 15 is a schematic that shows the graphic presentation of the results of the BOM merging process displayed on the console input and output means regarding the embodiment of the present invention.
DETAILED DESCRIPTION OF THE PRESENT INVENTION
• FIG. 1 shows an example of the present invention which is the block diagram of the BOM management apparatus. TheBOM management apparatus1 comprises acomputer2, a BOM file input means5, a console input and output means6 and a storage means7. Thecomputer2 comprises a central process unit and a memory device (not shown in the figure) and functions as a BOM file recording means10, a BOM rearrangement means11 and BOM merging means12. More concretely, the BOM file recording means10 is implemented by a memory space allocated in the memory device and theBOM merging means12 is implemented by a computer program which is stored in the memory device and carries out the function of such means by the central processor. The BOM rearrangement means11 includes the component identification judgment means15 and the coding rule estimating means16.
• The BOM file input means5 may, more concretely, be various disc drive devices that handles removal media such as flexible discs, MO (Magnetic Optical) discs, DVD (Digital Versatile Disk) which store theBOM file13 and data receiving devices which may be used for a network communication control device that receives theBOM file13 via networks such as an LAN (Local Area Network). The console input and output means6 is usually constructed with a keyboard, a mouse and CRT (Cathode Ray Tube) display or LCD (Liquid Crystal Display) display devices. The storage means7 is usually constructed with hard disc storage devices which stores more than oneBOM data base14.
• FIG. 2 shows an example of the present invention regarding BOM structure. As shown inFIG. 2, the BOM is constructed with aPN file201 and aPS file203.
• ThePN file201 is a set ofcomponent record202 which has apart number205 and a component name as the fundamental data item. In this example, thecomponent record202 has further data items such as a name of asupplier207, asupplier part number208,price209, acomponent assembly flag210, acomponent assembly status211.
• The component assembly flag shows whether the component presented in thecomponent record202 including the component assembly is the component assembly or not. When the flag value is “True” and “False”, it implies the component assembly and does not component assembly, respectively. Thecomponent assembly status211 shows the status that the component indicated by thecomponent record202 including thecomponent assembly status211 is expanded to the lower hierarchal layers. The values indicating the expansion are “−”, “expanded”, “expansion impossible” and “under search” and “not found”. When thecomponent assembly flag210 is “False”, the component is not a component assembly and then the value of thecomponent assembly status211 becomes to be “−”. On the other hand, when the value of thecomponent assembly status211 is “expanded”, the component assembly is expanded, which implies all of the members are in the same BOM. When the value of thecomponent assembly status211 is “under search”, “expansion impossible” or “not found”, it implies that the component assembly has not been expanded into the lower members and the reasons are “under search”, “expansion impossible” or “not found”.
• ThePS file203 is a set of thenesting record204 that has the data items such as themother part212,daughter part213 andquantity214. ThePS file203 shows the hierarchy among the components included in the PN file. The hierarchy is presented by “atree presentation215”. The power box A1 is composed of a chassis All and a drive unit A12 and the drive is further composed of an electric power unit A121, a motor A122 and a shaft A123.
• The operation of an embodiment of theBOM management apparatus1 will be explained by usingFIG. 1 to15. In theBOM data base14, the BOM shown inFIG. 2, thePN file201 and the PS file203 are recorded. In other words, the name of the product which is detailed with thisBOM data base14 is a power box. The BOM stored in theBOM data base14 may be a BOM describing a single product, a BOM including plural products or a BOM covering whole components used for the manufacturer who uses the BOM.
• ThePN file201 inFIG. 2 of whichcomponent assembly flag210 in thecomponent record202 having “motor” for the component name was “True” shows thecomponent assembly status211 is “under search” and the supplier of the member part is “B Industries”. As the result, theBOM file13 regarding the motor has been offered by “B Industries”.
• FIG. 3 shows the composition of theBOM file13 which is input to theBOM management apparatus1 as one of the embodiments of the present invention. As shown inFIG. 3, theBOM file13 composed of theproduct data301, thePN file302 and the PS file303 regarding the product. Theproduct data301 has data items such as thevendor316, theproduct code317, theproduct name318 and thecorresponding part number319. Thesupplier316 implies a party from whom the product is purchased. Theproduct code317 is that used by the supplier. Thecorresponding part number319 indicates the part number of the top component in the component structure in thePN file302.
• The systems of BOM used in own company (a purchasing party) and “B Industries”. For example, the PN file302 offered by “B Industries” has no data item of price209 (seeFIG. 2) but a data item of weight (Kg)320. Since thepart number305 is independently coded by each of the suppliers, there is a risk that the same part number is used for different components. For the present example, the part number “A12” is used for the part number of a drive unit in the PN file201 (seeFIG. 2) and the part number of a stator in thePN file302. When plural BOMs are merged, such non-unique use of the part numbers is excluded.
• FIG. 4 shows an example of thegraphic presentation41 on the display of the console input and outout means6 which shows the process, and the manipulation to carry out the BOM management steps in the present invention. Once the BOM management apparatus starts, theinput button icon42, thejudgment button icon43, therenumbering button icon44 and themerging button icon45 presented in the graphic presentation on the display of the console input and outmeans6. The BOM user sets a flexible disk in the BOM input means13 such as a flexible disk drive and clicks theinput button icon42. Then thecomputer2 starts to read theBOM file13 recorded in the flexible disk and is loaded into the memories of thecomputer2 and theBOM file13 is displayed in awindow46.
• FIG. 5 shows a schematic that shows an example regarding an embodiment of the present invention as for the graphic presentation of the display of the console input and output means which is used for the purposes to operate the computer processing for the BOM management and to display the results of the computer process. The presentation shows the content of theBOM file13. Theproduct record301, PN file302 and thePS file303 is dumped into the computer memory and they are handled as theproduct chart501, thePN chart502 and thePS chart503. However, an annex column to accommodate thePN chart502, anidentification flag512, asame PN513, acoding rule flag514 and anobsolete PN515 is appended to the component record. The details of the members in the component record will be discussed later. These charts in theBOM file13 are expanded in theBOM file13 recording means10 shown inFIG. 1.
• When a BOM user clicks thejudgment button icon43 in thegraphic presentation41 shown inFIG. 4, thecomputer2 starts to conform theBOM file13 to the BOMs stored in theBOM data base14. The major problems in the conformation are that different part numbers are assigned to an identically same component and the identically same part number is assigned to plural different components. The conformation process consists of a process to check any part number used in theBOM file13 is used in the BOM stored in theBOM data base14 and make a judgment for the results and a process to check any part number used in theBOM file13 is repeatedly used in the BOM stored in theBOM data base14 and make a judgment for the result.
• FIG. 6 shows a flow chart of part number conformity judgment process where the BOM in theBOM file13 is rearranged to be compliant to the BOM stored in theBOM data base14. Thecomputer2 retrieves a component record in the BOM stored in the BOM data base14 (S61). The component record has not been evaluated for checking the compliance. An identification judgment process for the components (S62) is carried out. The identification judgment process is to check whether a component described in the component record has been used in BOM in theBOM file13. The details of this identification judgment process will be discussed withFIG. 7. When same components are not found in the identification judgment process (“No” in S63), a part number conformity judgment process (S64) is carried out. When the same components are found (“Yes” in S63), means a part number conformity judgment process (S64) is skipped. The details of the part number conformity judgment will be discussed later withFIG. 8. Next, it is checked all of BOM records have been processed in the above process (S65). If there are any BOM records which have not been checked (“No” in S65) and the process goes back to S65 and repeats the steps S61 to S65. If none of the BOM records which have not been checked (“Yes” in S65), the part number conformity judgment process is ended.
• FIG. 7 shows identification judgment process included in the part number conformity judgment process. The component record retrieved from the BOM stored in theBOM data base14 is compared with the product record in the BOM file13 (which is handled as aproduct chart501 in the computer memory as shown inFIG. 5). This comparison is to search the components in the BOM stored in theBOM data base14 in order to expand the component assembly into the lower hierarchal layers. This identification judgment process is carried out by the component identification judgment means15 as shown inFIG. 1.
• First of all, thesupplier207 in the BOM stored in theBOM data base14 is compared with thevendor501 in the product chart. If they are conforming (“Yes” in S71), then thesupplier part number208 is compared with theproduct code517 in the product chart501 (S72). When thesupplier part number208 and theproduct code517 are conforming (“Yes” in S72), the identification flag in the component record of the most upper component is set as “True” so that the flag value is “True” (S73). This implies that the component is included in the BOM stored in theBOM data base14. The part number in the component record in the BOM stored in theBOM data base14 is set in a column of atemporary part number513 for conforming component in the step S73. If the results of the comparison indicate non-conforming (“No” in S71 and “No” in S72) each other, the step proceeds to the step S74 with skipping over the step S73.
• The component record retrieved from the BOM stored in theBOM data base14 is compared with the component record in the PN file (which is handled as aPN chart502 in the computer memory as shown inFIG. 5). The comparison is for the process to check the components which compose a component assembly are included in the BOM stored in theBOM data base14. A component record which has not been checked yet is retrieved from the PN file (which is handled in the computer memory as shown inFIG. 5) in the BOM file13 (S74). Thesupplier207 of the component listed in the BOM inBOM data base14 and thesupplier507 in thePN chart502 are compared. If they are conforming (“Yes” in S75), thesupplier part number208 in the BOM stored inBOM data base14 is compared with thesupplier part number508 in the PN chart502 (S76). When they are conforming (“Yes” in S76), the identification flag in the component record in thePN chart502 is set as “True” so that the flag value is “True” (S77). In the step S77, thepart number205 in the component record in the BOM stored in theBOM data base14 is set in a column of atemporary part number513 for conforming component in the step S73. If the results of the comparison indicates non-conforming (“No” in S75 and “No” in S76) each other, the step proceeds to the step S78 with skipping over the step S77. In the step S78, it is checked whether all component records in the BOM stored in theBOM data base14. If there are any BOM records which have not been checked (“No” in S78) and the process goes back to S74 and repeats the steps the part number conformity judgment process. If all of the part number conformity judgment process are completed (“Yes” in S78), the identification judgment process is ended.
• In the above process, the judgment for the identification is based on the conforming between the supplier and supplier part number, however, it may be judged for the identification regarding the manufacturing term, the lot number in addition to the supplier and the supplier part number as similar toFIG. 7.
• FIG. 8 shows a flow chart of a coding rule estimating process included in a part number conformity judgment which is an embodiment of the present invention. The coding compliance is a compliance between the coding of the part numbers and/or component numbers of the BOMs complied by different BOM controlling schemes. A coding rule estimating process estimates a coding rule of the components listed in a BOM which is recorded in theBOM file13 and determines a possibility to arrange the BOM in compliance with the BOM controlling scheme which compiles the BOM stored in theBOM data base14. There are various coding rules. The simplest rule but the minimum requisite rule for the coding, such as a unique coding scheme where the part number assigned to a specific component is never used for different components. Therefore, the different part numbers are assigned to the different components. The coding rule estimation is done with respect to the coding in such an aspect that the part numbers of the components used in theBOM file13 are checked whether they have already been used for the part numbers of the BOM stored in theBOM data base14. The coding rule estimating means provided in the present embodiments and prescribed in the appended claims carries out and implies this coding rule estimating process, respectively.
• FIG. 9 shows a schematic that shows a content of in-process operation for BOM rearrangement after the process of the part number conformity judgment regarding an embodiment of the present invention.FIG. 10 shows the presentation of the display of the console input and output means by which the results of the part number conformity judgment is provided. As shown inFIG. 9, anidentification flag512 and asame PN513 are given in the identification judgment process and thecoding rule flag514 is set in the a part number conformity judgment. The result of the part number conformity judgment is presented in ajudgment result window1001 as shown inFIG. 10. Thepart number505, and theidentification flag512, thesame PN513 and thecoding rule flag514 are only shown inFIG. 10. However, the other items regarding the judgment and/or all or a part of thePN chart502 or theproduct chart503 may be shown in the judgment resultswindow1001.
• The user clicks therenumbering button icon44 on thegraphic presentation41 shown inFIG. 10, thecomputer2 carries out a part number renumbering process.
• FIG. 11 shows a flow chart of the part number renumbering process, by which theBOM file13 is rearranged to be merged to the BOM stored in theBOM data base14 through the structural rearrangement. One component record in the PN file (which is handled as aPN chart502 in the computer memory as shown inFIG. 9), which has not been previously selected yet, is selected (S101). If theidentification flag512 of the component is “True” (“Yes” in S102), the content of thepart number505 is moved to theobsolete part number515 and thepart number505 is alternated by the same PN513 (S103). The part number in the PS chart is alternated with thesame PN513 as well (S107).
• If theidentification flag512 in the component record is not “True” (“No” in S102), then thecoding rule flag514 in the component record is checked in a judgment step (S104). If thecoding rule flag514 is “True” (“Yes” in S104), a new part number is assigned to the component described in the component record (S105). The new part number may be determined in compliance to the predetermined coding rule, however it cannot be duplicated with the existing part numbers used for the components listed in the BOM stored in theBOM data base14 at worst. When the new part number is assigned, the existingpart number505 of the component record is replaced with the new part number (S106). The new part number after such replacement replaces the part number in thePS chart503. In the judgment of the step S104, the step proceeds to the step S108 if thecoding rule flag514 is not “True” (“Yes” in S104).
• In the step S108, judgment is done to check whether all of the components listed in the PN file (which is handled as aPN chart502 in the computer memory as shown inFIG. 9) in theBOM file13 have been completed through this part number renumbering process. If any component records which have not been processed are found (“No” in S108), the step goes back to the step S101 and the actual steps for the part number renumbering process are repeated. If all of component records have been processed (“Yes” in S108), the part number renumbering process is ended.
• This part number renumbering process is carried out by the BOM rearrangement means11 shown inFIG. 1 as well as an identification judgment process and the coding rule estimating process.
• FIG. 12 shows a schematic that shows a content of in-process operation at the completion time of the part number renumbering process in the embodiment of the present invention.FIG. 13 shows thegraphic presentation41 of displayed on the console input and output means6, which presents the results of the part number renumbering process. By comparingFIG. 12 withFIG. 9, it can be seen that thepart number505 in thePN chart502 has been renumbered and that the corresponding part number in thePS chart503 is altered. The results of the part number renumbering process is given in therenumbering result window1301 displayed on thegraphic presentation41. In this window, thepart number505, thecoding rule flag514 and theobsolete part number515 are only presented. However, the other items obtained in the renumbering process may be presented. All of the records in thePN chart502 andPS chart503 may be presented.
• When the user clicks the mergingicon45 on thegraphic presentation41 inFIG. 13, thecomputer2 starts to carry out a BOM merging process, where a component record of which identification flag is not “True” in thePN chart502 of theBOM file13 which has already processed in the part number renumbering process is retrieved and the record items of the component record are rearranged to be compliant to those of the BOM stored in theBOM data base14 and the component record is appended to thePN file201 in the BOM stored in theBOM data base14. The nesting component record in thePS chart503 of theBOM file13 is added to the PS file203 of the BOM stored in theBOM data base14. If theidentification flag512 in the component record is “True” in the PN chart in theBOM file13, the content ofcomponent assembly status511 of the component assembly included in the component record replace the content in thecomponent assembly status211 of the corresponding component assembly in thePN file201 in the BOM stored in theBOM data base14.
• This BOM merging process is carried out by the BOM merging means12 shown inFIG. 1.
• FIG. 14 shows a schematic that shows a content of the BOM stored in theBOM data base14 at the completion time of the BOM merging process in the embodiment of the present invention.FIG. 15 shows thegraphic presentation41 of displayed on the console input and output means6, which presents the results of the BOM merging process. By comparingFIG. 14 withFIG. 2, it can be seen that a motor which is a component assembly has been expanded to a stator and a rotor. The part number assigned to the stator included in the supplier BOM has been renumbered since the part number had been already used for the part number of the existing drive unit. The shaft has already been used for the component composing the drive unit and the shaft is not added to the PN file141 as duplication.
• The BOM stored in theBOM data base14 after completion of the BOM merging process is presented in a tree structure form of the hierarchal layers of the components in the mergingresult window1501 displayed on thegraphic presentation41. The dark marks at the corners of the boxes enclosing the part numbers implies that they are not the component assembly and they are not necessary to be expanded to the lower hierarchal layers. The component assembly which is composed of the components that are further expanded to the lower hierarchal layers has, for example, a component assembly status, that says “A121 component cannot be expanded to the lower layers by the reason of expansion impossible”. According to the presentation of the component assembly status, the user can easily understand which component assembly is to be expanded to the lower hierarchal layers and the reason why the expansion is not possible. The presentation of the BOM stored in theBOM data base14 after completion of the BOM merging process is not necessary provided in a tree structure form but may be provided in a presentation such that the parts or all of thePN file1401 and thePS file1402 are in a form of charts.
• As explained inFIG. 3-15, the data processing by thecomputer2 can merge theBOM file13 of which controlling scheme is different from the controlling scheme used for theBOM data base14 into theBOM data base14. The display presentation of the merged BOM shows the status of the expansion of the component assembly to the lower hierarchal layers. The user can easily understand the status of the expansion.
• The addition of the items regarding hazard chemical contents or the failure rates of the products is easily carried out after completion of the merging as previously explained
FIRST VARIATION OF EMBODIMENT
• In the explanation of the previous embodiment, a concrete coding rule such that the same part number is never coded as a part number for the other part numbers is adopted. The present variation of the embodiment uses another coding rule such that the part number to be allocated for the newly added BOM is a serial part number to follow the latest part number of the lately added components. In other words, a new serial number starting from the last part number is allocated to every new component to be recorded in theBOM data base14.
• The coding rule of theBOM file13 always keeps no correspondence to the coding rule of the BOM stored in theBOM data base14. Therefore it is not necessary to make judgment whether the part number allocated to the components put in theBOM file13 is already used for the BOM stored in theBOM data base14. Thecoding rule flag514 is not necessary and no actual process as a coding rule estimating process is carried out so that the process is regarded as a dummy process. The judgment process of the step S104 is not necessary in the part number renumbering process (which corresponds toFIG. 11) and the new serial number coding in the step S105 may be performed by starting the renumbering from the latest allocated part numbers.
SECOND VARIATION OF EMBODIMENT
• The operation of the merging process, such that theBOM file data13 is merged to the BOM stored theBOM data base14, is carried out by clicking theinput icon42, thejudgment icon43, therenumbering icon44 and the mergingicon45 in an order as shown inFIG. 4,FIG. 10,FIG. 13 andFIG. 15. However, the operation of the merging process is not necessary to be confined by this sequential process.
• In the present variation of the embodiment, once clicking a subsequent icon before the previous process has not been started, the previous process is processed without clicking the previous process and the processes up to the process designated by clicking the icon is carried out. For example, the four icons shown in thedisplay4 inFIG. 4 are presented and not selected, but once the renumberingicon44 is clicked then the input process, all of the part number conformity judgment process and the part number renumbering process are sequentially executed at once. The merging icon is further clicked, the merging operation such that the BOM data is merged to theBOM data base14. By implementing this human interface in the system for theBOM management apparatus1, it is possible to reduce work load burdened to the operator and improve the work efficiency.
• As another implementation, it is possible to remove all of these icons. Thecomputer2 is once notified that theBOM file13 is set in the BOM file input means5 and then thecomputer2 carries out all of the input process, the part number conformity judgment process and the part number renumbering process are sequentially executed at once. By this process, an automated merging process of theBOM file13 is possible. In this example, theBOM file13 is given by files stored in the recoding media to be installed in the input and output device locally allocated to theBOM management system1. But they can be the files to be installed in anothercomputer2 if the files are to be transferred through the internet.
• The presentation window which shows the results of the plural processes on thedisplay41 as shown inFIG. 10,FIG. 13 andFIG. 15 provides tabs by which any of the results of the plural processes are selected to the front presentation. Each presentation is independently adjusted of the sizes. Therefore the operator can check the past process results and review the data by making comparison among these process results.
VARIATION OF EMBODIMENT
• In the previous embodiment, the merging process to merge to theBOM data base14 is carried out every time when such that theinput BOM file13 is set in the BOM file input means5. However, the present example, each of the plural BOM files13 is managed as an independent file and is merged to the BOM stored theBOM data base14. This BOM management method is convenient when an original product is expanded into series products with variation of specifications with modifications made in the part of the original product. For example, BOM management method, such that a common BOM stored inBOM data base14 is created for common components and other BOMs are created for the components used for the variation parts of the modifications made in the series products, may be adopted. The BOMs for components used for the variation parts are merged to the common BOM stored in the BOM data base if necessary.
• For this variation of the embodiment, the following three points need to be changed even the previous embodiments can be exploited as they are.
• The first point is that the plural BOM files13 are to be managed as the BOM data files (not shown in the figures). For this purpose, the BOM data files are stored in the hard disk installed to thecomputer2. In addition, the BOM data files may be those installed in another computer system which is connect to thecomputer2 through an internet.
• The second point is that necessary files are to be selected from the plural BOM data files and are to be merged to another BOM as aBOM file13. For this purpose, a human interface such as graphical display etc. by which the user of the BOMs selects necessary files and starts merging of the BOMs. Examples for such displays and process flows are not shown.
• The third point is that the BOM stored in theBOM data base14 is duplicated when the BOM merging process has started to merge BOMs, which is a duplication in theBOM data base14, replaces the BOM stored in theBOM data base14 upon the access and the process is ended. By this method, the BOM stored inBOM data base14 can be repeatedly used as a versatile BOM that has records of the common components.
• As explained above, the present variation of the embodiment features that variation products of series products do not need to have a complete BOM each by each, which results in the reduction of the amount ofBOM data base14.
VARIATION 4 OF EMBODIMENT
• The above embodiment can be applied for the case that the BOM stored in the BOM data base of X corporation to the BOM stored in the BOM data base of Y corporation are merged and the BOM stored in the BOM data base of Z corporation. For this case a new BOM stored in the BOM data base of Z corporation is created based on BOMs stored in the BOM data bases of X corporation and Y corporation. There are two methods to merge the BOM stored in the BOM data base.
• For the first case, the BOM stored in the BOM data base of X corporation is treated as theBOM file13 and the BOM stored in the BOM data base of Y corporation is treated as a BOM stored in the BOM data base. Then it is possible to merge the BOM stored in the BOM data base of X corporation to the BOM stored in the BOM data base of Y corporation. Therefore coding rule of BOM is rectified by that of the coding rule of the BOM stored in the BOM data base of Y corporation.
• For the second case, a new vacant BOM stored in the BOM data base of Z corporation, having a new coding rule, is created and handled as the BOM stored in the BOM data base. The BOM BOMs stored in the data bases of both X corporation and Y corporation are treated as the BOM files13 and the merging operation previously described is performed. Then the BOM stored in the BOM data bases of X corporation and Y corporation are evenly merged into the BOM stored in the BOM data base of Z corporation so that a new coding rule is applied to the components listed in both BOMs stored in the BOM data bases.
VARIATION 5 OF EMBODIMENT
• For case that X corporation and Y corporation cooperate or the both parties keep independency after merging, the variation 3 of the embodiment is applied. The BOMs stored in the BOM data bases of both parties are independently managed and merged on necessity. Of course there are two kind of merging.
• In the first case, the BOM stored in the BOM data base of X corporation is treated as aBOM file13 to which the BOM stored in the BOM data base of X corporation is input and the BOM stored in the BOM data base of Y corporation is treated as BOM stored in theBOM data base14. The BOM stored in the database of BOM of Y corporation is duplicated. The BOM stored in the BOM database of X corporation is merged to the BOM stored in the BOM data base of Y corporation. Therefore the coding rule of the BOM stored in the BOM data base is rectified by and merged to that of Y corporation. After the merged BOM stored in the BOM data base is completely used, the duplicated BOM stored in the BOM data base of Y corporation is returned to the original BOM stored in the BOM of Y corporation.
• In the second case, a new vacant BOM, having a new coding rule, is created and handled as the BOM stored in theBOM data base14. The BOMs stored in the BOM data bases of both X corporation and Y corporation are treated as the BOM files13 and the merging operation previously described is performed. Then the BOMs stored in the BOM data bases of X corporation and Y corporation are evenly merged into the BOM stored in the BOM data base which has a new coding rule.

Claims (11)

1. A management apparatus for controlling data of bill of material (abbreviated as BOM, hereinafter), which has a capability to manage plural sets of BOMs complied by different BOM controlling schemes, comprising;

a BOM scheme retrieval means that is to retrieve a BOM controlling scheme to be used as a reference BOM scheme from a memory means,

a BOM input means that inputs a BOM file to the management apparatus,

a BOM rearrangement means that rearranges a BOM filed in the BOM file to meet a BOM complied by the BOM controlling scheme.

2. A management apparatus for controlling data of bill of material (abbreviated as BOM, hereinafter), comprising:

a computer including at least a processor and a memory, and a storage means, being built-in or linked to the computer, that stores a BOM data base which holds BOMs in a data base management scheme therein;

a BOM file input means that inputs a BOM file, in which BOMs complied by a different BOM controlling scheme are filed, to the computer,

and a console input and output means that presents the BOM and commands to compile the BOM, wherein

the computer includes BOM file recording means to record a BOM file input through the BOM file input means or in-process data, a BOM rearrangement means that rearranges the BOM recorded in the BOM file recording means to meet the BOM, being complied by a BOM controlling scheme which is used for the management apparatus, which is stored in BOM data base and a BOM merging means that merges a BOM processed by the BOM rearrangement means with a BOM stored in the BOM data base and then records a merged BOM stored in the BOM data base in the storage means means.

3. A management apparatus according toclaim 2, wherein

the BOM rearrangement means includes a component identification judgment means that makes an identification judgment between components described in a component record listed in a BOM recorded in the BOM file recording means and components described in a component record listed in the BOM stored in the BOM data base, and

a coding rule estimating means that estimates a coding rule of the components listed in a BOM which is recorded in the BOM file recording means and determines a possibility to arrange the BOM in compliance with the BOM controlling scheme which compiles the BOM stored in the BOM data base.

4. A management apparatus according toclaim 2 orclaim 3, wherein

both the BOM recorded in the BOM file recording means and the BOM stored in the BOM data base include a component assembly flag indicating whether a component specified by the component record is a component assembly, and a component assembly status descriptor indicating whether the component assembly is further expanded in lower hierarchal layers, both of which flag and status descriptor are handled by the computer and edited by the console input and output means therein.

5. A management program for controlling data of bill of material (abbreviated as BOM, hereinafter) characterized by plural functions, such that a computer including at least a processor and a memory, and a storage means, being built-in or linked to the computer, that stores a BOM data base which holds BOMs in a data base management scheme therein has the functions of;

a BOM file input means that inputs a BOM file, in which BOMs complied by a different BOM controlling scheme are filed, to the computer,

and a console input and output means that presents the BOM and commands to compile the BOM, wherein

the computer includes BOM file recording means to record a BOM file input through the BOM file input means or in-process data, a BOM rearrangement means that rearranges the BOM recorded in the BOM file recording means to meet the BOM, being complied by a BOM controlling scheme which is used for the management apparatus, which is stored in BOM data base and a BOM merging means that merges a BOM processed by the BOM rearrangement means with a BOM stored in the BOM data base and then records a merged BOM stored in the BOM data base in the storage means.

6. A management program according toclaim 5 further having functions therein such that;

the BOM rearrangement means includes a component identification judgment means that makes an identification judgment between components described in a component record listed in a BOM recorded in the BOM file recording means and components described in a component record listed in the BOM stored in the BOM data base, and

a coding rule estimating means that estimates a coding rule of the components listed in a BOM which is recorded in the BOM file recording means and determines a possibility to arrange the BOM in compliance with the BOM controlling scheme which compiles the BOM stored in the BOM data base.

7. A management program according toclaim 5 orclaim 6 further having functions therein such that;

the both the BOM recorded in the BOM file recording means and the BOM stored in the BOM data base include a component assembly flag indicating whether a component specified by the component record is a component assembly, and a component assembly status descriptor indicating whether the component assembly is further expanded in lower hierarchal layers, both of which flag and status descriptor are handled by the computer and edited by the console input and output means therein.

8. A management method for controlling data of bill of material (abbreviated as BOM, hereinafter) characterized by the plural steps, such that a computer including at least a processor and a memory, and a storage means, being built-in or linked to the computer, that stores a BOM data base which holds BOMs in a data base management scheme therein has the steps of;

a BOM file input means that inputs a BOM file, in which BOMs complied by a different BOM controlling scheme are filed, to the computer,

and a console input and output means that presents a BOM and commands to compile the BOM, wherein

the computer includes BOM file recording means to record the BOM file input through the BOM file input means or in-process data, a BOM rearrangement means that rearranges the BOM recorded in the BOM file recording means to meet the BOM, being complied by a BOM controlling scheme which is used for the management apparatus, which is stored in BOM data base and a BOM merging means that merges a BOM processed by the BOM rearrangement means with a BOM stored in the BOM data base and then records a merged BOM stored in the BOM data base in the storage means.

9. A management method according toclaim 8 further having methods therein such that;

the BOM rearrangement means includes a component identification judgment means that makes an identification judgment between components described in a component record listed in a BOM recorded in the BOM file recording means and components described in a component record listed in the BOM stored in the BOM data base, and

a coding rule estimating means that estimates a coding rule of components listed in a BOM which is recorded in the BOM file recording means and determines a possibility to arrange the BOM in compliance with the BOM controlling scheme which compiles the BOM stored in the BOM data base.

10. A management program according toclaim 8 further having steps therein such that;

both the BOM recorded in the BOM file recording means and the BOM stored in the BOM data base include a component assembly flag indicating whether a component specified by the component record is a component assembly, and a component assembly status descriptor indicating whether the component assembly is further expanded in lower hierarchal layers, both of which flag and status descriptor are handled by the computer and edited by the console input and output means therein.

11. A management program according toclaim 9 further having steps therein such that;

both the BOM recorded in the BOM file recording means and the BOM stored in the BOM data base include a component assembly flag indicating whether a component specified by the component record is a component assembly, and a component assembly status descriptor indicating whether the component assembly is further expanded in lower hierarchal layers, both of which flag and status descriptor are handled by the computer and edited by the console input and output means therein.

Images