Supplier selection business support device, supplier selection business support method, and supplier selection business support program

Abstract

To provide a supplier selection work support apparatus, a supplier selection work support method, and a supplier selection work support program which allows support of a supplier selection work upon competitive estimates.SOLUTION: A method according to an embodiment of the present invention has (1) a step of generating, with setting a supplier in an estimation request data as one axis and setting an article in the estimate request data as the other axis, an estimate response input screen including a table capable of being input with an estimate response amount, an estimate response deadline and evaluation in each matrix formed by both axes, (2) a step of acquiring, from an evaluation master, evaluation for combination of the supplier and the article in the estimate request data, (3) a step of inputting the estimate response amount and the estimate response deadline by an operator to display the estimate response input screen including the table automatically input with the acquired evaluation, and (4) a step of displaying the lowest value, the shortest deadline and the highest evaluation obtained by comparing three elements of the estimate response amount, the estimate response deadline and the evaluation with respect to each article among suppliers upon the display.SELECTED DRAWING: Figure 9

Description

[Technical field]

[0001] The present invention relates to a supplier selection task support device, a supplier selection task support method, and a supplier selection task support program. [Background technology]

[0002] Patent Document 1 discloses a system that can handle construction-related order formats that have been difficult to systematize in the past, reduce the burden on the requester, and improve work efficiency by inheriting information entered in a department during circulation (see paragraph 0007 of Patent Document 1, etc.). Patent Document 1 also discloses that the materials department node selects one or more companies depending on the contents of the request, outputs an estimate, and requests an estimate (see paragraph 0028 of Patent Document 1, etc.). [Prior art documents] [Patent documents]

[0003] [Patent Document 1] JP 2004-164045 A Summary of the Invention [Problem to be solved by the invention]

[0004] In the construction industry as described in the above Patent Document 1, the procurement department procures materials (products) and contract work (services) required at the site. At this time, the procurement department requests quotations from multiple suppliers, which is called competitive bidding.

[0005] The Procurement Department then selects one supplier based on the estimated amounts and delivery dates of the multiple suppliers and the evaluations that the company has given to the multiple suppliers. However, since the responses come from multiple suppliers, there is a problem that the information is scattered. In addition, even after collecting the information about each supplier in one place, it is still time-consuming to select the supplier with the best conditions.

[0006] The present invention has been made in consideration of the above problems, and has an object to provide a supplier selection work support device, a supplier selection work support method, and a supplier selection work support program which, when competitive bids for goods or services are obtained, display in one place the estimated response amounts and estimated delivery dates from a plurality of suppliers, as well as the ratings given by a company to the plurality of suppliers, and at this time, highlight and display the cheapest estimated response amount, the shortest estimated delivery date, and the highest rating among the plurality of suppliers, thereby supporting the work of selecting a supplier. [Means for solving the problem]

[0007] In order to solve the above-mentioned problems and achieve the object, a supplier selection operation support device according to the present invention is provided which is capable of supporting an operation of selecting a supplier when competitive bidding is conducted in which quotations are requested from a plurality of suppliers, and which includes a control unit and a storage unit, wherein the storage unit stores supplier identification data for identifying a supplier, supplier target identification data for identifying a product or service to be purchased, and an evaluation master including an evaluation set for each combination of a supplier and a supplier target, and quotation request data including the supplier identification data and the supplier target identification data, and the control unit stores the supplier identification data in the quotation request data on one axis and the supplier target identification data in the quotation request data on the other axis, and stores a table in which the amount and delivery date of the quotation response from each supplier in response to the quotation request, and an evaluation for each supplier can be inputted into each matrix formed by the two axes. the estimate response input screen generating means for generating an estimate response input screen which is a screen for inputting estimate responses from the supplier identification data and the purchase target identification data, an evaluation acquiring means for acquiring from the evaluation master an evaluation corresponding to the combination of the supplier identification data and the purchase target identification data in the estimate request data, and an estimate response input screen display means for displaying the estimate response input screen including the table into which the estimate response amount and the estimate response delivery date are input by an operator and into which the evaluation acquired by the evaluation acquiring means is automatically input, wherein the estimate response input screen display means supports the task of supplier selection when obtaining competitive quotations by highlighting the cheapest amount for the estimate response amount, the nearest date for the estimate response delivery date, and the highest evaluation when comparing the three elements of the estimate response amount, the estimate response delivery date, and the evaluation between the supplier identification data for each of the same purchase target identification data.

[0008] In addition, in the supplier selection work supporting device of the present invention, the quotation request data further includes, in addition to the supplier identification data and the supplier target identification data, a flag for identifying whether or not the supplier has been selected as a final supplier, and the input quotation response amount, and the control unit further comprises: a supplier candidate display means for displaying, from the quotation request data, the supplier identification data with the flag indicating that the supplier has been selected as a final supplier, on an order input screen as a supplier candidate, and an order data generation means for generating order data when specific supplier identification data is selected from the supplier identification data displayed by the supplier candidate display means, based on the selected supplier identification data and the supplier target identification data and the quotation response amount in the quotation request data corresponding to the selected supplier identification data.

[0009] In addition, in the supplier selection business support device of the present invention, the quotation request data further includes, in addition to the supplier identification data and the purchase target identification data, a quotation request amount for each supplier and the input quotation response amount, and the control unit further includes a negotiation result confirmation screen display means for displaying, based on the quotation request data, a negotiation result confirmation screen which is a screen for confirming the result of a price reduction negotiation from the quotation request amount, which includes the quotation request amount, the quotation response amount, and a difference between both amounts, for each combination of the supplier identification data and the purchase target identification data.

[0010] In addition, in a supplier selection task support method according to the present invention, there is provided a supplier selection task support method executed by an information processing device having a control unit and a storage unit, capable of supporting a task of supplier selection when competitive bidding is requested for quotations from a plurality of suppliers, wherein the storage unit stores supplier identification data for identifying a supplier, supplier target identification data for identifying a product or service to be purchased, and an evaluation master including an evaluation set for each combination of a supplier and a supplier target, and quotation request data including the supplier identification data and the supplier target identification data, and a process executed by the control unit inputs quotation responses from each supplier in response to a quotation request, the process including a table in which the supplier identification data in the quotation request data is set as one axis and the supplier target identification data in the quotation request data is set as the other axis, and in which the quotation response amount and quotation response delivery date from each supplier and the evaluation for each supplier can be input into each matrix formed by both axes. a quotation reply input screen generating step of generating a quotation reply input screen which is a screen for inputting a quotation reply amount to a supplier identification data and a procurement target identification data in the quotation request data, an evaluation acquisition step of acquiring an evaluation corresponding to the combination of the supplier identification data and the procurement target identification data in the quotation request data from the evaluation master, and a quotation reply input screen display step of displaying the quotation reply input screen including the table into which the quotation reply amount and the quotation reply delivery date are input by an operator and into which the evaluation acquired in the evaluation acquisition step is automatically input, wherein in the quotation reply input screen display step, when the three elements of the quotation reply amount, the quotation reply delivery date and the evaluation are compared between the supplier identification data for each of the same procurement target identification data, the cheapest amount for the quotation reply amount, the nearest date for the quotation reply delivery date and the highest evaluation are highlighted, thereby supporting a supplier selection task when obtaining competitive bids.

[0011] In addition, a supplier selection task support program according to the present invention is a supplier selection task support program to be executed by an information processing device having a control unit and a storage unit, capable of supporting a task of supplier selection when competitive bidding is requested to a plurality of suppliers, wherein the storage unit stores supplier identification data for identifying a supplier, supplier target identification data for identifying a product or service to be purchased, and an evaluation master including an evaluation set for each combination of a supplier and a supplier target, and quotation request data including the supplier identification data and the supplier target identification data, and the control unit executes a program to support a task of supplier selection support when competitive bidding is requested to a plurality of suppliers, the program storing an evaluation master including supplier identification data for identifying a supplier, supplier target identification data for identifying a product or service to be purchased, and an evaluation set for each combination of a supplier and a supplier target, the evaluation master including the supplier identification data and the supplier target identification data, and a matrix formed by the two axes, the supplier identification data in the quotation request data being one axis and the supplier target identification data in the quotation request data being the other axis, the matrix including a table into which the amount and delivery date of the quotation response from each supplier in response to the quotation request can be input, the estimate response input screen display step of displaying the estimate response input screen including the table into which the estimate response amount and the estimate response delivery date are input by an operator and into which the evaluation acquired in the evaluation acquisition step is automatically input, and wherein the estimate response input screen display step supports a supplier selection task when obtaining competitive quotations by highlighting the lowest amount for the estimate response amount, the nearest date for the estimate response delivery date, and the highest evaluation, when the three elements of the estimate response amount, the estimate response delivery date, and the evaluation are compared between the supplier identification data for each of the same purchasing target identification data. Effect of the Invention

[0012] According to the present invention, when competitive bids for goods or services are made, the estimated response prices and estimated delivery dates from a plurality of suppliers, as well as the evaluations given by the company to the plurality of suppliers, are displayed together in one place, and the cheapest estimated response price, shortest estimated delivery date, and highest evaluation among the plurality of suppliers are highlighted, thereby providing the effect of supporting the task of selecting a supplier. [Brief description of the drawings]

[0013] [Figure 1] FIG. 1 is a block diagram showing an example of the configuration of a supplier selection operation support device. [Diagram 2] FIG. 2 is an illustration showing an example of a processing flow according to this embodiment. [Diagram 3] FIG. 3 is a flowchart showing an example of a processing flow according to this embodiment. [Figure 4] FIG. 4 is a diagram illustrating an example of the supplier-specific product evaluation master. [Diagram 5] FIG. 5 is a diagram showing an example of quotation request data generated by inputting a quotation request. [Figure 6] FIG. 6 is a diagram showing an example of the estimate reply input screen in the initial state. [Figure 7] FIG. 7 is a diagram showing an example of the estimate reply input screen on which the evaluation has been automatically input. [Figure 8] FIG. 8 shows an example of the quotation response input screen on which a response from company A is input and quotation request data updated based on that screen. [Figure 9] FIG. 9 shows an example of the quotation response input screen on which responses from companies B and C are input, and an example of quotation request data updated based on this screen. [Figure 10] FIG. 10 shows an example of the quotation reply input screen on which the final supplier has been selected and the quotation request data updated based on that screen. [Figure 11] FIG. 11 is a diagram showing an example of the data extraction screen and the negotiation result confirmation screen. [Figure 12]FIG. 12 is a diagram showing an example of an order input screen and order data. DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS

[0014] Hereinafter, an embodiment of a supplier selection task support device, a supplier selection task support method, and a supplier selection task support program according to the present invention will be described in detail with reference to the drawings. Note that the present invention is not limited to the embodiment.

[0015] [1. Overview] As a preliminary step to ordering and purchasing, the procurement department requests quotes from multiple suppliers for products requested by the site. For example, in the construction industry, when ordering materials or contract work required at the site, the procurement department negotiates with suppliers based on several criteria (price, delivery date, quality, etc.). In this way, when ordering products or work, requesting quotes from multiple suppliers rather than one company is called competitive bidding.

[0016] However, when competitive bidding is conducted, quotations are received from multiple suppliers, which results in the information being dispersed. As a result, there is a problem in that it takes a great deal of time and effort for procurement department staff to select a supplier.

[0017] Therefore, in this embodiment, the procurement department staff can, for example, register data when requesting quotations from multiple suppliers on one screen. Also, in this embodiment, the procurement department staff can, for example, input response results from multiple suppliers on one screen and compare them.

[0018] This makes it possible, for example, to objectively and easily select the supplier with the best conditions, leading to cost reduction and profit creation. In addition, for example, it is possible to accumulate the results of negotiations by the procurement department and product information by supplier. The accumulated negotiation results of the procurement department can be used, for example, as reference material for personnel evaluation in the procurement department. The specific configuration and operation are described below.

[0019] [2. Configuration] An example of the configuration of the supplier selection work support device 100 according to this embodiment will be described with reference to Fig. 1. Fig. 1 is a block diagram showing an example of the configuration of the supplier selection work support device 100.

[0020] The supplier selection work support device 100 is a commercially available desktop personal computer. The supplier selection work support device 100 is not limited to a stationary information processing device such as a desktop personal computer, but may be a portable information processing device such as a commercially available notebook personal computer, a PDA (Personal Digital Assistant), a smartphone, or a tablet personal computer.

[0021] The supplier selection work support device 100 comprises a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. The units comprised in the supplier selection work support device 100 are connected to each other so as to be able to communicate with each other via any communication path.

[0022] The communication interface unit 104 communicatively connects the supplier selection work support device 100 to the network 300 via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 104 has a function of communicating data with other devices via the communication line. Here, the network 300 has a function of connecting the supplier selection work support device 100 and the server 200 so that they can communicate with each other, and is, for example, the Internet or a LAN (Local Area Network). Note that data such as various masters described below may be stored in the server 200, for example.

[0023] An input device 112 and an output device 114 are connected to the input / output interface unit 108. The output device 114 may be a monitor (including a home television), a speaker, or a printer. The input device 112 may be a keyboard, a mouse, a microphone, or a monitor that cooperates with a mouse to realize a pointing device function. In the following, the output device 114 may be referred to as the monitor 114, and the input device 112 may be referred to as the keyboard 112 or the mouse 112.

[0024] Various databases, tables, files, etc. are stored in the storage unit 106. Computer programs for cooperating with an OS (Operating System) to give instructions to a CPU (Central Processing Unit) to perform various processes are recorded in the storage unit 106. For example, memory devices such as RAM (Random Access Memory) and ROM (Read Only Memory), fixed disk devices such as hard disks, flexible disks, and optical disks can be used as the storage unit 106.

[0025] The storage unit 106 includes, for example, a supplier-specific product evaluation master 106a as an evaluation master, quotation request data 106b, and order data 106c.

[0026] In the construction and engineering industries, the procurement department that receives a request for procurement of goods or services from a site often requests quotations from multiple suppliers, so-called competitive bidding. The supplier selection support device 100 according to this embodiment can support the supplier selection process when competitive bidding is requested.

[0027] As shown in FIG. 4, the supplier-specific product evaluation master 106a includes, for example, supplier identification data (supplier) for identifying the supplier, purchase target identification data (product) for identifying the product or service to be purchased, and an evaluation set for each combination of supplier and purchase target (supplier-specific product evaluation).

[0028] The goods to be purchased are, for example, materials and supplies required for construction work, etc. The services to be purchased are, for example, outsourced work and contract work required for construction work, etc.

[0029] The evaluation (product evaluation by supplier) is, for example, the result of evaluation by the site based on the details of past transactions with each supplier. For example, in the case of an evaluation of supplier A and product 1, it means that the evaluation is for product 1 that supplier A delivered in the past. The evaluation (product evaluation by supplier) may be a score as shown in FIG. 4, or may be a rank such as "A to C" or "good, fair, poor."

[0030] As shown in Figures 5, 8, 9 and 10, quotation request data 106b includes, for example, a quotation request number, a quotation request processing number, the supplier identification data (supplier), a quotation request line number, the purchase target identification data (product), the quotation request amount for each supplier, a response status to the quotation request or a flag for identifying whether or not the supplier has been selected as a final supplier (quotation request status), the quotation response amount from each supplier (response amount), and the quotation response delivery date from each supplier (response delivery date).

[0031] The quotation request number is assigned to each supplier, and therefore, in a broad sense, the quotation request number can also be considered as the supplier identification data.

[0032] The quotation request processing number is a number for bundling all quotation inputs at one time.

[0033] The flag (quote request status) for identifying the response status to the quotation request is a flag indicating that a response to the quotation request has not yet arrived (no response), or a flag indicating that a response to the quotation request has already arrived (response in progress), as shown in Figures 5, 8 and 9.

[0034] The flag (quotation request status) for identifying whether or not a supplier has been selected as a final supplier is a flag (rejected) indicating that the supplier has not been selected as a final supplier, or a flag (accepted) indicating that the supplier has been selected as a final supplier, as shown in FIG. 10.

[0035] Here, quotation request data 106b shown in Fig. 5 is quotation request data 106b immediately after registration. Since the same quotation request amount is requested for multiple suppliers, the quotation request amount is the same for each supplier, as shown in Fig. 5. Also, immediately after registration, as shown in Fig. 5, the quotation request status for each supplier is all "unanswered," the quotation response amounts are all 0 yen, and the quotation response delivery dates are all blank.

[0036] As shown in FIG. 12, the order data 106c includes, for example, an order number, the supplier identification data (supplier), an order line number, the purchase target identification data (product), the order amount, the quotation request number, the quotation request line number, etc.

[0037] The control unit 102 is a CPU or the like that performs overall control of the supplier selection operation support device 100. The control unit 102 has an internal memory for storing control programs such as an OS, programs that define various processing procedures, required data, and the like, and executes various information processing based on these stored programs.

[0038] The control unit 102 has, in terms of functional concept, for example: (1) an estimate reply input screen generating unit 102a as estimate reply input screen generating means for generating an estimate reply input screen for inputting an estimate reply from each supplier to a quotation request, the estimate reply input screen including a table in which the estimate reply amount and estimate reply delivery date from each supplier and an evaluation for each supplier can be input in each matrix formed by the two axes, with the supplier identification data in the quotation request data being one axis and the purchasing target identification data in the quotation request data being the other axis; (2) an evaluation acquiring unit 102b as evaluation acquiring means for acquiring, from the evaluation master, an evaluation corresponding to the combination of the supplier identification data and the purchasing target identification data in the quotation request data; and (3) an estimate reply input screen display unit 102c as estimate reply input screen display means for displaying the estimate reply input screen including the table in which the estimate reply amount and the estimate reply delivery date are input by an operator and the evaluation acquired by the evaluation acquiring means is automatically input. (4) a supplier candidate display unit 102d serving as supplier candidate display means for displaying, on an order input screen as a supplier candidate, the supplier identification data with a flag indicating that the supplier has been selected as a final supplier from the quotation request data; (5) an order data generating unit 102e serving as order data generating means for generating order data based on the selected supplier identification data and the purchase target identification data and the quotation response amount in the quotation request data corresponding to the selected supplier identification data, when specific supplier identification data is selected from the supplier identification data displayed by the supplier candidate display means; and (6) a negotiation result confirmation screen display unit 102f serving as negotiation result confirmation screen display means for displaying, based on the quotation request data, a negotiation result confirmation screen for confirming a result of discount negotiation from the quotation request amount, including the quotation request amount, the quotation response amount, and the difference between the two amounts, for each combination of the supplier identification data and the purchase target identification data.

[0039] The quotation reply input screen generating unit 102a generates a quotation reply input screen, which is a screen for inputting quotation replies from suppliers to a quotation request, and which includes a table in which the quotation reply amount and quotation reply delivery date from each supplier and an evaluation of each supplier can be input in each matrix formed by the two axes, with the suppliers in the quotation request data 106b (see FIG. 5) as one axis and the products in the quotation request data 106b (see FIG. 5) as the other axis (see FIG. 6).

[0040] The evaluation acquisition unit 102b acquires the evaluation corresponding to the combination of the supplier and the product in the quotation request data 106b (see FIG. 5) from a supplier-specific product evaluation master 106a (see FIG. 4) that includes the supplier, the product, and the evaluation.

[0041] The estimate response input screen display unit 102c displays the estimate response input screen including the table in which the estimate response amount and the estimate response delivery date are input by the operator and the evaluation acquired by the evaluation acquisition unit 102b is automatically input (see FIG. 9).

[0042] At this time, when comparing the three elements of the quote response amount, the quote response delivery date, and the evaluation between the suppliers for each of the same products, the quote response input screen display unit 102c highlights and displays the lowest amount for the quote response amount, the closest date for the quote response delivery date, and the highest evaluation (see FIG. 9). There are no particular limitations on the method of highlighting, but examples include displaying by coloring, displaying by hatching, displaying by increasing the value, and displaying by making the text bold.

[0043] In this way, by highlighting the lowest price, shortest delivery time, and highest rating among the suppliers for each product, it is possible to support the procurement department staff in selecting a supplier when obtaining competitive bids.

[0044] The supplier candidate display unit 102d displays, from the quotation request data 106b (see FIG. 10), the suppliers to which the flag (quotation request status: accepted) indicating that they have been selected as the final supplier, as supplier candidates on the order input screen (see FIG. 12).

[0045] When a specific supplier is selected from the suppliers displayed in the supplier candidate display unit 102d, the order data generation unit 102e generates order data 106c (see FIG. 12) based on the selected supplier and the product and the quotation response amount (response amount) in the quotation request data 106b (see FIG. 10) corresponding to the selected supplier.

[0046] The negotiation result confirmation screen display unit 102f displays a negotiation result confirmation screen (see FIG. 11) for confirming the result of the discount negotiation from the quotation request amount, including the quotation request amount, the quotation response amount (response amount), and the difference between the two amounts, for each combination of the supplier and the product, based on the quotation request data 106b (see FIG. 10).

[0047] [3. Processing flow] In this section, the processing flow according to this embodiment will be described with reference to FIG.

[0048] First, in the "quote request input" shown in Figure 2, the procurement department staff requests quotes from multiple suppliers for the products for which procurement has been requested by the field. At this time, the procurement department staff uses an input screen (quote request input screen) that allows them to input the same quotes to multiple suppliers in one go.

[0049] Next, in the "quote response input" shown in Figure 2, the procurement department staff inputs the response amounts and response delivery dates from multiple suppliers, compares each supplier, and finally selects one supplier. At this time, the procurement department staff uses a screen (quote response input screen) that allows them to compare the response amounts, response delivery dates, and past accumulated evaluations from multiple suppliers.

[0050] 2, the procurement department staff calls up quotation request data 106b to place an order with the supplier selected in "Quotation Response Input." At this time, the procurement department staff uses a screen (order input screen) for generating order data 106c based on quotation request data 106b.

[0051] [4. Specific examples of processing] In this section, a specific example of the process according to this embodiment will be described. In this section, a case will be described in which a purchasing manager in the procurement department of a construction company (hereinafter, simply referred to as "purchasing manager") obtains competitive bids from multiple suppliers and finally selects one supplier.

[0052] Before going into a description of the specific processing contents, the processing flow will be briefly described with reference to FIG. 3. First, the process of inputting a request for quotation is executed (step S1 in FIG. 3), which will be described in [4-1] below. Next, the process of inputting a reply to a quotation is executed (step S2 in FIG. 3), which will be described in [4-2] below. Next, the process of confirming the results of price negotiation is executed (step S3 in FIG. 3), which will be described in [4-3] below. Finally, the process of inputting an order is executed (step S4 in FIG. 3), which will be described in [4-4] below.

[0053] In this section [4. Specific example of processing], it is assumed that the supplier-specific product evaluation master 106a is registered in advance with the contents shown in Fig. 4. As shown in Fig. 4, the master registers evaluations of products 1 and 2 for suppliers A to C.

[0054] [4-1. Input quote request (Step S1)] First, a process for inputting a request for quotation is executed. In other words, a process for registering the request for quotation information is executed. This will be described in detail below.

[0055] When making a request for quotation to companies A to C for products 1 and 2, the purchasing staff registers quotation request data 106b shown in Fig. 5. As shown in Fig. 5, a quotation is requested from each supplier for a quotation request amount of 10,000 yen for product 1 and a quotation request amount of 20,000 yen for product 2.

[0056] Then, a quotation request form is printed based on the registered quotation request data 106b and sent to companies A to C.

[0057] [4-2. Enter quotation response (Step S2)] Next, the process of inputting the estimate response is executed. In other words, the process of registering the estimate response information is executed. This will be described in detail below.

[0058] (1) Creating a screen for inputting quotation responses First, the quotation reply input screen generating unit 102a generates a quotation reply input screen. Specifically, the quotation reply input screen generating unit 102a generates the quotation reply input screen shown in Fig. 6, which includes a table in which the quotation reply amount, quotation reply delivery date, and evaluation can be input in each of six matrices formed by the horizontal axis representing Suppliers A to C, which are suppliers in the quotation request data 106b in Fig. 5, and the vertical axis representing Products 1 to 2, which are products in the quotation request data 106b in Fig. 5.

[0059] (2) Obtaining and displaying ratings Next, the evaluation acquisition unit 102b acquires evaluations corresponding to the suppliers and products in the quotation request data 106b from the supplier-specific product evaluation master 106a. Specifically, the evaluation acquisition unit 102b acquires 80 as an evaluation corresponding to supplier A company and product 1, 80 as an evaluation corresponding to supplier A company and product 2, 90 as an evaluation corresponding to supplier B company and product 1, 80 as an evaluation corresponding to supplier B company and product 2, 70 as an evaluation corresponding to supplier C company and product 1, and 60 as an evaluation corresponding to supplier C company and product 2.

[0060] Then, the estimate response input screen display unit 102c automatically inputs the evaluation acquired by the evaluation acquisition unit 102b into the estimate response input screen of FIG. 6, thereby displaying the estimate response input screen shown in FIG.

[0061] At this time, the quotation reply input screen display unit 102c highlights the highest rating when comparing between the suppliers for each same product. Specifically, as shown by dotted hatching in Fig. 7, the quotation reply input screen display unit 102c highlights the rating of Company B of 90 for Product 1, and highlights the ratings of Company A and Company B of 80 for Product 2.

[0062] (3) Display when quotation reply comes from supplier A Next, when the quotation reply arrives from company A, the purchasing clerk inputs the quotation reply amount and the quotation reply delivery date for products 1 and 2 for company A on the quotation reply input screen of FIG.

[0063] At this time, the quotation reply input screen display unit 102c highlights the cheapest quotation reply amount and the shortest quotation reply delivery date when comparing between each supplier for the same product. Specifically, since only a reply has been received from company A at this point, the quotation reply input screen display unit 102c highlights the quotation reply amount and quotation reply delivery date from company A for both products 1 and 2, as shown by dotted hatching in Fig. 8. Note that the quotation reply input screen display unit 102c highlights the evaluation as explained in (2).

[0064] When an estimate reply is input as shown in the estimate reply input screen of Fig. 8, the quotation request data 106b is updated as shown in Fig. 8. In the updated quotation request data 106b shown in Fig. 8, as shown by hatching, the values ​​of the estimate reply amount and estimate reply delivery date from company A have been updated, and the quotation request status for company A has been updated from "no reply" to "replying".

[0065] (4) Display when quotation responses are received from suppliers B and C When quotation replies arrive from companies B and C following company A, the purchasing clerk inputs the estimated amounts and estimated delivery dates for products 1 and 2 from companies B and C into the quotation input screen of FIG.

[0066] At this time, the quotation response input screen display unit 102c highlights the cheapest quotation response amount and the shortest quotation response delivery date when comparing between the suppliers for each of the same products. Specifically, as shown by dotted hatching in Fig. 9, the quotation response input screen display unit 102c highlights the cheapest quotation response amount for product 1, 9,000 yen from Company B, and highlights all three companies for the quotation response delivery date for product 1 because they are the same for all three companies. The quotation response amount for product 2 highlights the cheapest 15,000 yen from Company B, and highlights the shortest quotation response delivery date for product 2, 2021 / 12 / 9 from Company A.

[0067] When an estimate reply is input as shown in the estimate reply input screen of Fig. 9, the estimate request data 106b is updated as shown in Fig. 9. In the updated estimate request data 106b shown in Fig. 9, as shown by hatching, the values ​​of the estimate reply amounts and estimate reply delivery dates from companies B and C have been updated, and the quotation request statuses for companies B and C have been updated from "no reply" to "replying".

[0068] (5) Confirmation of suppliers Through the process up to this point, quotation responses have come in from all of companies A through C, and the quotation response input screen is displayed as shown in Fig. 10. Referring to the quotation response input screen in Fig. 10, the area indicated by dotted hatching is larger for company B than for companies A and C. This means that company B is a supplier with favorable conditions in terms of price, delivery date, and evaluation.

[0069] In this case, the purchasing staff selects Company B as the final supplier and sets it as the confirmed supplier, as shown in the lower part of the quotation response input screen in Figure 10. In principle, only one company (Company B) is selected as the confirmed supplier. In other words, it is not possible to select different suppliers as confirmed suppliers for each product or service.

[0070] When company B is selected as a confirmed supplier, quotation request data 106b is updated as shown in Fig. 10. In the updated quotation request data 106b shown in Fig. 10, as shown by hatching, the quotation request status of companies A and C, which were not selected as final suppliers, is updated from "replying" to "rejected," while the quotation request status of company B, which was selected as the final supplier, is updated from "replying" to "rejected."

[0071] [4-3. Confirmation of price negotiation results (Step S3)] Next, a process for confirming the result of the price reduction negotiation is executed, which will be described in detail below.

[0072] When the purchasing person specifies the person in charge, the supplier, the product, and the quotation request date on the data extraction screen of Fig. 11, the negotiation result confirmation screen display unit 102f extracts the specified details from the quotation request data 106b. In this example, the negotiation result confirmation screen display unit 102f extracts all six details in the quotation request data 106b of Fig. 10.

[0073] Then, the negotiation result confirmation screen display unit 102f displays the negotiation result confirmation screen based on the six extracted details. Specifically, as shown in Fig. 11, the negotiation result confirmation screen display unit 102f displays a negotiation result confirmation screen including the quotation request amount in the quotation request data 106b in Fig. 10, the quotation response amount in the quotation request data 106b in Fig. 10, and the difference between the two amounts for each product for each of companies A to C.

[0074] The purchasing staff may check the discount results on the negotiation result confirmation screen, and if there is room for negotiation, may ask the supplier to submit a quotation again and perform the quotation response input in [4-2] again. The purchasing staff may then check the discount results on the negotiation result confirmation screen again and repeat the process of considering whether there is room for further negotiation.

[0075] [4-4. Order Entry (Step S4)] Finally, the order entry process is executed. In other words, the order information is registered. This will be described in detail below.

[0076] When a purchasing clerk selects the "quotation request number" field on the order entry screen in Fig. 12, the supplier candidate display unit 102d displays, via a pull-down menu or the like, only the quotation request numbers of items whose quotation request status is "adopted" in the quotation request data 106b in Fig. 10, as supplier candidates. In the example in Fig. 12, only quotation request numbers MI002 of two items whose quotation request status is "adopted" are displayed.

[0077] When the purchasing clerk selects the displayed quotation request number MI002, the information in the quotation request data 106b in FIG. 10 is transferred to the order entry screen in FIG. 12, and the values ​​are set on the order entry screen as shown in the order details in FIG. 12.

[0078] Then, the order data generating unit 102e generates the order data 106c shown in FIG. 12 based on the two details in the quotation request data 106b of FIG. 10, which includes the selected quotation request number MI002.

[0079] In the order data 106c, the "order number" is an automatically assigned number, the "supplier" corresponds to the "supplier" in the quotation request data 106b, the "order line number" is an automatically assigned number, the "product" corresponds to the "product" in the quotation request data 106b, the "order amount" corresponds to the "reply amount" in the quotation request data 106b, the "quotation request number" corresponds to the "quotation request number" in the quotation request data 106b, and the "quotation request line number" corresponds to the "quotation request line number" in the quotation request data 106b.

[0080] When the contents of the order data 106c are corrected, the automatically generated order number is set in the "order number" field on the order input screen of FIG.

[0081] [5. Summary of this embodiment] As has been described above, as mainly explained in [4-1] and [4-2], the supplier selection work support device 100 of this embodiment can support the work of supplier selection by, for example, displaying in one place the estimated response amounts and estimated response delivery dates from multiple suppliers as well as the ratings given by the company to the multiple suppliers when competitive bids for goods or services are being obtained, and highlighting the cheapest estimated response amount, shortest estimated response delivery date, and highest rating among the multiple suppliers.

[0082] Furthermore, according to the supplier selection operation support device 100 of this embodiment, as explained mainly in [4-3], the quotation request amount, the quotation reply amount, and the difference between the two amounts can be displayed on one screen for each combination of supplier and product. This allows a comparison to be made between the quotation request amount requested from the field to the procurement department and the quotation reply amount replied by the supplier, so that the procurement department staff can confirm how much of a discount they have succeeded in obtaining.

[0083] A specific explanation of discounts will be given with reference to the negotiation result confirmation screen in Figure 11. For the combination of "Supplier B Company" and "Product 1," the requested quotation amount is 10,000 yen, the replied quotation amount is 9,000 yen, and the difference is 1,000 yen, which means that the discount of 1,000 yen was successful. On the other hand, for the combination of "Supplier C Company" and "Product 1," the requested quotation amount is 10,000 yen, the replied quotation amount is 11,000 yen, and the difference is -1,000 yen, which means that not only was the discount unsuccessful, but the supplier instead offered an amount 1,000 yen higher than the requested quotation amount.

[0084] Furthermore, according to the supplier selection work support device 100 of this embodiment, as mainly described in [4-4], a supplier selected from a plurality of suppliers by a procurement department staff member or the like can be displayed on the order input screen as a candidate supplier, thereby supporting ordering work.

[0085] [6. Contribution to the United Nations-led Sustainable Development Goals (SDGs)] This embodiment can contribute to improving business efficiency and promoting appropriate management decisions by companies, thereby contributing to goals 8 and 9 of the SDGs.

[0086] Furthermore, this embodiment can contribute to reducing waste and promoting paperless and electronic systems, thereby contributing to the achievement of SDGs Goals 12, 13, and 15.

[0087] Furthermore, this embodiment can contribute to strengthening control and governance, making it possible to contribute to Goal 16 of the SDGs.

[0088] 7. Other Embodiments The present invention may be embodied in various different embodiments other than those described above within the scope of the technical concept set forth in the claims.

[0089] For example, among the processes described in the embodiments, all or part of the processes described as being performed automatically can be performed manually, or all or part of the processes described as being performed manually can be performed automatically using known methods.

[0090] In addition, the processing procedures, control procedures, specific names, information including parameters such as registered data and search conditions for each process, screen examples, and database configurations shown in this specification and drawings may be changed as desired unless otherwise specified.

[0091] Moreover, with regard to the supplier selection task support device 100, the components shown in the figures are merely conceptual functional elements, and the device does not necessarily have to be physically configured as shown in the figures.

[0092] For example, the processing functions of the supplier selection operation support device 100, particularly the processing functions performed by the control unit, may be realized in whole or in part by a CPU and a program interpreted and executed by the CPU, or may be realized as hardware using wired logic. The program is recorded on a non-transient computer-readable recording medium containing programmed instructions for causing the information processing device to execute the processes described in this embodiment, and is mechanically read by the supplier selection operation support device 100 as necessary. That is, a computer program for giving instructions to the CPU in cooperation with the OS and performing various processes is recorded in a storage unit such as a ROM or HDD (Hard Disk Drive). This computer program is executed by being loaded into a RAM, and cooperates with the CPU to form the control unit.

[0093] In addition, this computer program may be stored in an application program server connected to the supplier selection work support device 100 via any network, and it is also possible to download all or a part of it as necessary.

[0094] In addition, the program for executing the process described in this embodiment may be stored in a non-transient computer-readable recording medium, or may be configured as a program product. Here, the "recording medium" includes any "portable physical medium" such as a memory card, a Universal Serial Bus (USB) memory, a Secure Digital (SD) card, a flexible disk, a magneto-optical disk, a ROM, an Erasable Programmable Read Only Memory (EPROM), an Electrically Erasable and Programmable Read Only Memory (EEPROM (registered trademark)), a Compact Disk Read Only Memory (CD-ROM), a Magneto-Optical disk (MO), a Digital Versatile Disk (DVD), and a Blu-ray (registered trademark) Disc.

[0095] Moreover, a "program" is a data processing method written in any language or description method, and may be in any form, such as source code or binary code. Note that a "program" is not necessarily limited to a single configuration, but also includes a distributed configuration as multiple modules or libraries, and a program that works with a separate program, such as an OS, to achieve its function. Note that the specific configuration and reading procedure for reading a recording medium in each device shown in the embodiments, as well as the installation procedure after reading, may use well-known configurations and procedures.

[0096] The various databases etc. stored in the memory unit are storage means such as memory devices such as RAM and ROM, fixed disk devices such as hard disks, flexible disks, and optical disks, and store various programs, tables, databases, and web page files etc. used for various processes and providing websites.

[0097] The supplier selection task support device 100 may be configured as an information processing device such as a known personal computer or workstation, or may be configured as the information processing device to which any peripheral device is connected. The supplier selection task support device 100 may be realized by installing software (including programs, data, etc.) that causes the device to realize the processing described in this embodiment.

[0098] Furthermore, the specific form of distribution and integration of the devices is not limited to that shown in the drawings, and all or part of them can be functionally or physically distributed and integrated in any unit according to various additions or functional loads. In other words, the above-mentioned embodiments can be implemented in any combination, or the embodiments can be implemented selectively. [Industrial Applicability]

[0099] The present invention is useful in fields such as construction, engineering, machinery, steel, food, chemicals, trading companies, retail distribution, temporary staffing, consulting, IT media, logistics and transportation, but is particularly useful in the field of construction and engineering. [Explanation of symbols]

[0100] 100 Supplier selection support device 102 Control section 102a Estimate response input screen generation unit 102b Evaluation Department 102c Estimate response input screen display section 102d Supplier candidate display section 102e Order data generation unit 102f Negotiation result confirmation screen display section 104 Communication interface section 106 Storage section 106a Supplier-specific product evaluation master 106b Request for quotation data 106c Ordering Data 108 Input / Output Interface Section 112 Input Devices 114 Output Device 200 Servers 300 Network

Claims

1. A supplier selection operation support device that supports a supplier selection operation when requesting quotes from a plurality of suppliers, the device including a control unit and a storage unit, The storage unit includes: an evaluation master including supplier identification data for identifying a plurality of suppliers, purchase target identification data for identifying a plurality of products or services to be purchased, and an evaluation set for each combination of a supplier and a purchase target; Request for quotation data including supplier identification data and purchase target identification data; is stored, The control unit is a quotation reply input screen generating means for generating a quotation reply input screen for inputting quotation replies from each supplier in response to the quotation request, the quotation reply input screen including a table in which the quotation reply amount and quotation reply delivery date from each supplier and an evaluation of each supplier can be input in each matrix formed by the two axes, the supplier identification data in the quotation request data being on one axis and the purchase target identification data in the quotation request data being on the other axis; an evaluation acquisition means for acquiring an evaluation corresponding to a combination of the supplier identification data and the purchase target identification data in the quotation request data from the evaluation master; an estimate response input screen display means for displaying the estimate response input screen including the table into which the estimate response amount and the estimate response delivery date are input by an operator and into which the evaluation acquired by the evaluation acquisition means is automatically input; Equipped with The estimate response input screen display means When the three elements of the quotation response amount, the quotation response delivery date and the evaluation are compared between the supplier identification data for each of the same purchasing target identification data, the lowest amount for the quotation response amount, the nearest date for the quotation response delivery date and the highest evaluation are highlighted, thereby supporting the task of selecting a supplier when competitive bids are made and accepting one supplier selected by a user for a plurality of products or services; A supplier selection operation support device characterized by the above.

2. the quotation request data further includes, in addition to the supplier identification data and the purchase target identification data, a flag for identifying whether or not the supplier has been selected as a final supplier, and the input quotation response amount; The control unit is a supplier candidate display means for displaying, on an order input screen, the supplier identification data to which a flag indicating that the supplier has been selected as a final supplier from the quotation request data; and an order data generating means for generating order data based on the selected supplier identification data and the purchase target identification data and the estimated response amount in the quotation request data corresponding to the selected supplier identification data when the specific supplier identification data is selected from the supplier identification data displayed by the supplier candidate display means; Further comprising:

2. The supplier selection task support device according to claim 1, wherein:

3. The quotation request data further includes, in addition to the supplier identification data and the purchase target identification data, a quotation request price for each supplier and the input quotation response price, The control unit is a negotiation result confirmation screen display means for displaying, for each combination of the supplier identification data and the purchase target identification data based on the quotation request data, a negotiation result confirmation screen for confirming the result of a discount negotiation from the quotation request amount, including the quotation request amount, the quotation reply amount, and the difference between the two amounts; Further comprising:

3. The supplier selection task support device according to claim 1, further comprising:

4. A method for supporting supplier selection operations, executed by an information processing device having a control unit and a storage unit, capable of supporting a supplier selection operation when requesting quotations from a plurality of suppliers, comprising: The storage unit includes: an evaluation master including supplier identification data for identifying a plurality of suppliers, purchase target identification data for identifying a plurality of products or services to be purchased, and an evaluation set for each combination of a supplier and a purchase target; Request for quotation data including supplier identification data and purchase target identification data; is stored, Executed by the control unit, a quotation reply input screen generating step of generating a quotation reply input screen for inputting quotation replies from each supplier in response to the quotation request, the quotation reply input screen including a table in which the quotation reply amount and quotation reply delivery date from each supplier and an evaluation of each supplier can be input in each matrix formed by the two axes, the supplier identification data in the quotation request data being one axis and the purchase target identification data in the quotation request data being the other axis; an evaluation acquisition step of acquiring, from the evaluation master, an evaluation corresponding to a combination of the supplier identification data and the purchase target identification data in the quotation request data; an estimate response input screen display step of displaying the estimate response input screen including the table into which the estimate response amount and the estimate response delivery date are input by an operator and into which the evaluation acquired in the evaluation acquisition step is automatically input; Including, In the estimate response input screen display step, When the three elements of the quotation response amount, the quotation response delivery date and the evaluation are compared between the supplier identification data for each of the same purchasing target identification data, the lowest amount for the quotation response amount, the nearest date for the quotation response delivery date and the highest evaluation are highlighted, thereby supporting the task of selecting a supplier when competitive bids are made and accepting one supplier selected by a user for a plurality of products or services; A method for supporting a supplier selection process, comprising:

5. A supplier selection operation support program for being executed by an information processing device having a control unit and a storage unit, capable of supporting an operation of selecting a supplier when requesting quotations from a plurality of suppliers, comprising: The storage unit includes: an evaluation master including supplier identification data for identifying a plurality of suppliers, purchase target identification data for identifying a plurality of products or services to be purchased, and an evaluation set for each combination of a supplier and a purchase target; Request for quotation data including supplier identification data and purchase target identification data; is stored, To cause the control unit to execute a quotation reply input screen generating step of generating a quotation reply input screen for inputting quotation replies from each supplier in response to the quotation request, the quotation reply input screen including a table in which the quotation reply amount and quotation reply delivery date from each supplier and an evaluation of each supplier can be input in each matrix formed by the two axes, the supplier identification data in the quotation request data being one axis and the purchase target identification data in the quotation request data being the other axis; an evaluation acquisition step of acquiring, from the evaluation master, an evaluation corresponding to a combination of the supplier identification data and the purchase target identification data in the quotation request data; an estimate response input screen display step of displaying the estimate response input screen including the table into which the estimate response amount and the estimate response delivery date are input by an operator and into which the evaluation acquired in the evaluation acquisition step is automatically input; Including, In the estimate response input screen display step, When the three elements of the quotation response amount, the quotation response delivery date and the evaluation are compared between the supplier identification data for each of the same purchasing target identification data, the lowest amount for the quotation response amount, the nearest date for the quotation response delivery date and the highest evaluation are highlighted, thereby supporting the task of selecting a supplier when competitive bids are made and accepting one supplier selected by a user for a plurality of products or services; A supplier selection support program that features:

Images