The present application claims priority from Japanese application JP2012-190869 filed on Aug. 31, 2012, the content of which is hereby incorporated by reference into this application.
The present invention relates to a technique permitting a buyer (business enterprise) that orders parts for manufacturing or assembling products to retrieve alternative suppliers of parts heretofore used and, more particularly, to a technique for retrieving candidate suppliers available for a transaction for information about the suppliers and extracting candidate suppliers from which alternative parts can be procured.
In order to purchase parts from plural companies with a view to avoid procurement risks such as supply chain interruption or bankruptcy of transacting suppliers, it is customary to select suppliers capable of offering alternatives to normally purchased parts. One conventional method of selecting a supplier capable of supplying alternative parts is to empirically extract candidate reliable suppliers capable of supplying the alternative parts from suppliers which actually performed transactions with the buyer based on past experience of the buyer itself. Arbitrary suppliers are selected from among the extracted candidate suppliers. Furthermore, a supplier to which a final order will be placed is generally determined after making overall decisions as to whether the candidates can supply parts satisfying required design specifications, can supply a required amount of parts, can deliver them up to a desired delivery date, and the price can be within an assumed budget. In the prior art, when such candidate suppliers are extracted, profile information about the suppliers (open information such as information about addresses and amount of sales) is previously accumulated in a database. Candidate alternative suppliers can be extracted by retrieving the database. According to the technique of JP-A-2002-342626, it is possible for a buyer to extract suppliers capable of supplying parts meeting desired specifications by storing the categories (classification codes) to which ordered parts belong in a database as supplier information and conducting a retrieval using the classification codes as keys.
In businesses for selecting suppliers, it is necessary to make overall decisions as to whether they can supply parts meeting required design specifications, whether a required amount of supply can be achieved, whether the parts can be delivered up to a desired delivery date, and whether the price can be kept within an assumed budget. The required design specifications arise from design departments and quality assurance departments of companies in terms of shapes of parts, used materials, functions realized by parts and durability, weatherability, sense of usage, texture, feeling of raw material, distortions, and deformations under assumed use environments. The overall decisions are made by consensus of every department associated with procured parts in addition to the above-described departments. Each buyer is required to quickly extract candidate suppliers that would satisfy these requirements, based on past experience of transactions made by the buyer itself. The present invention pertains to a technique that assists in doing decision making for procurement such that suppliers from which a buyer can procure alternative parts can be selected accurately and quickly.
When a buyer selects suppliers, a personal decision is made while taking account of past achievements of orders, transactional experience, and requirements of the above-described associated departments. Therefore, depending on a buyer, a different supplier for alternative parts may be selected depending on the presence or absence of past transactional experience or on the contents of experience. Consequently, there is the problem that it is not assured that an alternative supplier can offer parts meeting required design specifications as a result of such different results of decision making done by buyers for selection of suppliers.
One available conventional method for solving this problem consists of causing categories (classification codes) of parts to which ordered parts belong to be previously stored as supplier information in a database and permitting a buyer to retrieve the database using the classification codes as keys, thus extracting alternative suppliers capable of supplying alternative parts. According to the above-cited JP-A-2002-342626, management information about each individual supplier is previously stored in a database. The management information includes information about summaries of suppliers, the number of employees of each supplier, items of business, main clients, suppliers of main materials, main subcontractors, contents of the newest account settlement, main apparatuses and pieces of equipment, technical level, quality management method, organizational structure, and public relations activities undertaken by suppliers. Suppliers can be retrieved for by making given inputs to entry fields for maker code, maker name, item code (large classification), item code (moderate classification), item name, and location which have been previously defined. However, in the technique of the above-cited JP-A-2002-342626, when retrieval is performed by item name, for example, different suppliers often supply parts which have the same design specifications (performing the same function and role) but bear different item names. For this reason, it is difficult to retrieve by item name. In the case of make-to-order products, parts supplied by existing suppliers conform to specifications required by a client (buyer). Other suppliers who are not transacting now do not always supply parts of the same specifications. Hence, it is not easy to extract alternative suppliers if retrieval is performed by item name or classification code of part supplied by a supplier. It is an object of the present invention to provide a technique of extracting suppliers who have sufficient supply capability to be alternative suppliers when the suppliers cannot be extracted easily if retrieval is performed only by item names or classification codes of parts currently being offered by the suppliers.
The above-described object is achieved, for example, by adopting configurations as set forth in the accompanying claims.
The present disclosure includes a plurality of means capable of achieving the foregoing object. One example thereof is accomplished by a supplier retrieval apparatus having a computing section for receiving supplier information including the names of supplier companies and classification information about parts capable of being offered by the supplier companies, storing the received information as supplier information, receiving retrieval conditions regarding alternative suppliers from buyers, and calculating degrees of similarity between existing suppliers acting as procurement sources and candidate alternative suppliers and a listing up-output portion for listing up candidate alternative suppliers having priority order information from information about the degrees of similarity and outputting the list of the candidate alternative suppliers.
In businesses for determining alternative suppliers, candidate alternative suppliers which meet specification conditions required by a buyer can be extracted and calculated quickly and accurately.
Other objects, features and advantages of the invention will become apparent from the following description of the embodiments of the invention taken in conjunction with the accompanying drawings.
One embodiment of the present invention is hereinafter described with reference to some of the drawings. The present embodiment provides an apparatus and method for calculating the degrees of similarity between existing suppliers (procurement sources) and candidate alternative suppliers and offering candidate alternative suppliers to a buyer to permit the buyer to select alternative suppliers from which the buyer can procure alternative parts and materials.
The storage section 30 of the supplier retrieval apparatus 100 is realized by the main storage unit 205 or the external storage unit 203 of the supplier retrieval apparatus 100. The control section 10 and computing section 20 of the supplier retrieval apparatus 100 are realized by computer programs that cause the arithmetic unit 204 of the supplier retrieval apparatus 100 to perform processing. The programs are stored in the main storage unit 205 or in the external storage unit 203. When they are run, they are loaded into the main storage unit 205 and executed by the arithmetic unit 204. The communication section 40 of the supplier retrieval apparatus 100 is realized by the communication device 206 of the supplier retrieval apparatus 100. When suppliers are retrieved for, an ordering party reports the retrieval conditions to the supplier retrieval apparatus 100.
First, the control section 10 accepts supplier information including at least supplier names and classification codes and stores them in the supplier information storage portion 310 of the storage section 30 (step S001).
The classification codes of parts that can be offered from a supplier may be presented from the supplier side. Alternatively, a buyer may conduct researches and enter the classification codes. The information accepted at the above-described step may be supplier information other than supplier names and classification codes capable of being offered from a supplier. According to the example of input screen of
Data about transaction records can also be obtained from a database in which data about past transactional results managed by a buyer is stored. With respect to the results of transactions, very old information may not be informative and, therefore, it is effective to obtain data indicating whether there was a transaction during a specified period of time (e.g., within 1 year or within three years from now on).
The make decision button 304 is used to store input information, which is received at the supplier information entry region 300, into the supplier information storage portion 310.
In step S001 of the flowchart of
The supplier information 303 accepted at the screen of
Referring back to
The control section 10 receives supplier retrieval conditions including at least supplier name and parts name (step S002). In particular, in step S002, the control section 10 stores the value, which is accepted at the supplier retrieval condition entry region 400 and has been entered in a supplier name entry field 401, into a supplier name field 331 of a retrieval condition storage portion 330 and stores the value entered in a parts name entry field 402 into a parts name field 332.
The information accepted at the above-described steps may represent retrieval conditions other than existing supplier names and parts names. According to
The retrieval execution button 404 is a make decision button used to cause the input information received at the supplier retrieval condition entry region 400 to be stored in the retrieval condition storage portion 330.
Retrieval conditions 403 accepted in the entry field of
Then, the control section 10 performs a processing routine for extracting suppliers from which alternative parts can be procured (step S003). The processing routine (S003) performed by the computing section 20 to extract candidate alternative suppliers is next described in detail.
In the present embodiment, it is seen from the data table stored in the retrieval condition storage portion 330 that “company N” is entered in the supplier name field 331. Then, using information entered in the supplier name field 331 as a retrieval key, the supplier names in the supplier name field 331 of the data table stored in the supplier information storage portion 310 are collated and the classification code 312 of a corresponding record is extracted. More specifically, using “company N” entered in the supplier name field 331 as a retrieval key, the records in the supplier information storage portion 310 are retrieved. It is seen from the data table of
Subsequently to the execution of step S0301, a decision is made as to whether there is any record meeting the retrieval conditions (step S0302). If there is no pertinent record, the present processing routine is terminated. If there is at least one pertinent record, control proceeds to the next step.
The computing section 20 then performs a processing routine for calculating degrees of similarity of suppliers to determine whether each retrieved supplier can act as an alternative supplier (S0303).
In step S0303, regarding all the suppliers stored in the supplier information storage portion 310, classification codes that can be offered from each supplier are extracted. It can be seen from
Then, the degree of coincidence with each combination with each classification code which can be offered by the retrieved supplier and which has been extracted as described above is calculated for each supplier. In the present embodiment, as shown in
The processing operation described so far is repeated for every supplier stored in the supplier information storage portion 310. The results of the computations performed in this way are stored in the decision result information storage portion 320 of the storage section 30 under control of the control section 10 (step S0304).
In the foregoing process, the degrees of similarity of suppliers are calculated. Besides, evaluation values equivalent to the degrees of similarity can be found by the following method.
First, information as shown in
Based on the parts name 332 entered from the input screen shown in
The score of the alternative supplier computed as described so far is stored in the decision result information storage portion 320 at step S0304. In particular, value 19 that is the calculated score of the alternative supplier for company B is placed in the degree of similarity field 322 of the decision result information storage portion 320. Similar processing is performed for company C. The score of the alternative supplier is calculated to be 17. Similar processing is performed for company D. The score of the alternative supplier can be calculated to be 18. These scores are stored in the score information storage portion 323 of the decision result information storage portion 320.
The processing steps S0302-S0304 included in the routine for judging degrees of similarity of suppliers have been described in detail thus far. In the present invention, company D that cannot offer parts of the classification code A002 can be extracted although the entered part name belongs to the classification code A002 as described previously. In the present invention, in the case of make-to-order products, the degrees of similarity of supply capability among suppliers can be evaluated if parts supplied from the suppliers are not uniform in specifications or if they do not belong to the same classification. The above example of the present invention is characterized in that company D can be evaluated to be similar in supply capability to company N although company D does not offer parts of classification code A002 and that candidate alternative suppliers which could not have been extracted by the prior art retrieval simply using parts names and classification codes can be extracted.
Returning to the routine of
A method of determining the order in which suppliers are sorted is described, the method being displayed in the candidate supplier display area 504. Supplier names are displayed in a supplier name area 5041. The value of a degree of similarity or of a score is displayed in a value area 5042 according to a selection made using the candidate supplier display method selection button 505. The order in which candidate suppliers is displayed are determined based on the retrieval conditions entered from the retrieval condition entry region 400 and on information entered using the candidate supplier display method selection button 505. In particular, in cases where conditions included in the retrieval conditions 403 about manufacturing bases or results of transactions are not accepted (both items are neglected) at the supplier retrieval condition entry region 400, if an input of “degree of similarity” is accepted using the candidate supplier display method selection button 505, then the values of degrees of similarity 322 in the decision result information storage portion 320 are ranked in decreasing order, and their values are stored in the ranking information area 326. In cases where conditions included in the retrieval conditions 403 about manufacturing bases or results of transactions are not accepted (both items are neglected) at the supplier retrieval condition entry region 400, if an input of “score” is accepted using the candidate supplier display method selection button 505, then the values of scores in the score information storage portion 323 of the decision result information storage portion 320 are ranked in decreasing order, and their values are stored in the ranking information area 326. In cases where conditions included in the retrieval conditions 403 about manufacturing bases or results of transactions are accepted at the supplier retrieval condition entry region 400, if an input of “degree of similarity” is accepted using the candidate supplier display method selection button 505, then only those of the records in the decision result information storage portion 320 which meet the retrieval conditions are extracted, the extracted records are ranked in decreasing degree of similarity 322, and their values are placed in the ranking information area 326. In cases where conditions included in the retrieval conditions 403 about manufacturing bases or results of transactions are accepted at the supplier retrieval condition entry region 400, if an input of “score” is accepted using the candidate supplier display method selection button 505, then only those of records in the decision result information storage portion 320 which meet the retrieval conditions are extracted. The values of these records in the score information storage portion 323 are ranked in decreasing order, and their values are stored in the ranking information area 326. The processing procedure described so far permits a buyer to select alternative suppliers.
In the present embodiment, during a retrieval for alternative suppliers, the degrees of similarity among partner suppliers are evaluated using the existing ordering conditions (supplier names and parts names) as retrieval keys as described above. Even when novel parts are retrieved, for example, candidate suppliers with which orders will be placed can be quickly presented by entering retrieval conditions about newly ordered parts from the retrieval screen and implementing the present invention.
It is to be understood that the present invention is not restricted to the above embodiments but rather various changes and modifications are possible. The above embodiments have been described in detail to explain the invention in an easily understandable manner. The invention is not restricted to one including all the configurations described. In addition, some configurations of some embodiment can be replaced by configurations of other embodiment. Furthermore, configurations of other embodiment can be added to configurations of one embodiment. Additionally, with respect to some configuration of each embodiment, other configurations may be added, deleted, or replaced.
Furthermore, the above-described configurations, functions, processing portions, and processing means may be realized in hardware. For example, all or some of them are designed using an integrated circuit. In addition, the above-described configurations and functions may be realized in software by causing a processor to interpret and execute programs that implement those functions. Programs, tables, files, and other information for realizing the functions can be placed in a memory, a hard disk, an SSD (solid-state drive), or other storage device or on a storage medium (such as IC card, SD card, or DVD).
Only those of control lines and information lines which are considered to be necessary for explanation are shown. Not all control lines and information lines of final products are shown. In practice, it can be considered that almost all configurations are interconnected.
It should be further understood by those skilled in the art that although the foregoing description has been made on embodiments of the invention, the invention is not limited thereto and various changes and modifications may be made without departing from the spirit of the invention and the scope of the appended claims.
Number | Date | Country | Kind |
---|---|---|---|
2012-190869 | Aug 2012 | JP | national |