JP2018014056A - Order reception probability evaluation device, order reception probability evaluation method and program - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide an order reception probability evaluation device, an order reception probability evaluation method and a program which assist facilitation of determination of whether or not product order reception is probable.SOLUTION: A product specification database 132 stores product specification information indicating product specifications including at least one specification item, in association with number information of a product. A reception part 111 receives requirement specification information indicating requirement specifications of a product ordered from a customer, and number information of a candidate product to be supplied to the customer. A consistency determination part 113 obtains, from the product specification database 132, product specifications corresponding to the number information received by the reception part 111, and determines consistency between specification items included in the requirement specifications and specification items in the product specifications. An information output part 117 outputs a determination result by the consistency determination part 113.SELECTED DRAWING: Figure 3

Description

  The present invention relates to an order acceptability evaluation apparatus, an order acceptability evaluation method, and a program.

  There has been proposed a sales management device that determines whether or not an order for a product by a manufacturer is accepted based on the manufacturer's inventory status and production capacity status (see, for example, Patent Document 1).

Japanese Patent Laid-Open No. 2001-42918

  By the way, when determining whether or not to accept an order for a product, in addition to the inventory status and production capacity of the product, whether the product satisfies the required specifications of the product (including required specifications related to quality) is also considered. There is a need to. On the other hand, the sales department of the manufacturer often does not grasp all of the required specifications for the product. Therefore, each time the sales department receives an inquiry about whether or not an order can be received for a product from a customer, it has been time-consuming to make an inquiry to another department about required specifications that are not grasped.

  The present invention has been made in view of the above-described reasons, and an object thereof is to provide an order acceptability evaluation apparatus, an order acceptability evaluation method, and a program that support the smooth determination of whether or not an order can be received for a product.

The order possibility evaluation device according to the present invention as seen from the first viewpoint is:
A product specification database for storing product specification information indicating product specifications including at least one specification item in association with product number information;
A reception unit that receives required specification information indicating a required specification of a product ordered from a customer and product number information of a candidate product to be supplied to the customer;
Acquiring product specification information corresponding to the product number information from the product specification database, and a compatibility determination unit for determining compatibility between the required specification information and the product specification information,
And an output unit that outputs a determination result by the suitability determination unit.

The order possibility evaluation method according to the present invention from the second viewpoint is as follows:
Receiving required specification information indicating a required specification of a product ordered from a customer and product number information of a candidate product to be supplied to the customer;
Product specification information corresponding to the product number information is acquired from a product specification database that stores product specification information indicating product specifications including at least one specification item in association with the product number information, and the required specification information and the product specification information Determining compatibility with
Outputting a determination result of suitability.

The program according to the present invention viewed from the third viewpoint is:
Computer
A reception unit that receives required specification information indicating a required specification of a product ordered from a customer and product number information of a candidate product to be supplied to the customer;
Product specification information corresponding to the product number information is acquired from a product specification database that stores product specification information indicating product specifications including at least one specification item in association with the product number information, and the required specification information and the product specification information A compatibility determination unit for determining the compatibility with
An output unit for outputting a determination result by the suitability determination unit;
To function as.

  According to the present invention, the compatibility determination unit acquires the product specification information corresponding to the product number information received by the reception unit from the product specification database, and determines the compatibility between the required specification information and the product specification information. Thus, for example, even a user who does not have knowledge about the product specifications of the product can relatively easily know the suitability of the candidate product that is a candidate to be supplied to the customer with the requested specifications of the customer. Even such a user can determine whether or not an order for a product for which an order is requested by a customer can be made relatively smoothly.

It is the schematic which shows the order possibility evaluation system which concerns on embodiment of this invention. It is a block diagram which shows the hardware constitutions of the order possibility evaluation apparatus which concerns on embodiment. It is a block diagram which shows the function structure of the order possibility evaluation apparatus which concerns on embodiment. It is a figure which shows the content of the product specification database which concerns on embodiment. (A) is a figure which shows the content of the process capability index database which concerns on embodiment, (B) is a figure which shows the content of the determination result database which concerns on embodiment. It is a flowchart which shows the flow of the order possibility evaluation process which the order possibility evaluation apparatus which concerns on embodiment performs. It is a figure which shows an example of the screen displayed on the display part of the order possibility evaluation apparatus which concerns on embodiment. It is a figure which shows an example of the screen displayed on the display part of the order possibility evaluation apparatus which concerns on embodiment.

  Hereinafter, an order possibility evaluation system according to an embodiment of the present invention will be described in detail with reference to the drawings. The order possibility evaluation system according to the present embodiment, when requested to receive an order for a product from a customer, information related to the product specifications of the company's product (hereinafter referred to as “product specification information”) and the product. Based on the information (hereinafter referred to as “process information”) indicating the results of the manufacturing process, the possibility of receiving an order for the product is evaluated.

  As shown in FIG. 1, this order possibility evaluation system includes an order possibility evaluation apparatus 1 installed in a sales department, a server 2 installed in a quality control department, a server 3 installed in a manufacturing department, Is provided. The order possibility evaluation apparatus 1 and the servers 2 and 3 are connected via a wide area network NT such as the Internet. When a user who belongs to the sales department is requested to receive an order for a product from a customer, the user can evaluate the order possibility of the requested product using the order possibility evaluation apparatus 1. Then, the user determines whether or not an order can be received for the product based on the evaluation result by the order possibility evaluation device 1.

  The server 2 stores product specification information of each product of the company. The product specification information includes the operating temperature range for the product, the presence / absence of a test result such as a vibration test for the product, and whether or not an APQP (advanced product quality plan) can be implemented. Information regarding the specifications of these products is registered in the server 2 by a user belonging to the quality control department.

  The server 3 stores process information for each product of the company. This process information includes inspection result values of various inspections performed in a manufacturing process such as dimensional inspection, and standard values in various inspections.

  As shown in FIG. 2, the order possibility evaluation apparatus 1 includes a processing unit 101, a storage unit 103, an input unit 104, a display unit 105, and a communication unit 106. The order possibility evaluation apparatus 1 is composed of a general-purpose personal computer or the like.

  The processing unit 101 includes a CPU (Central Processing Unit) and a RAM (Random Access Memory). The RAM is used as a work area for the CPU. The CPU controls the order possibility evaluation device 1 by reading the program stored in the storage unit 103 into the RAM and executing it.

  The storage unit 103 includes a nonvolatile memory such as a magnetic disk or a semiconductor memory. The storage unit 103 stores programs executed by the CPU of the processing unit 101, various parameters, and the like. The storage unit 103 stores various databases described later.

  The input unit 104 includes an input device such as a keyboard and an input / output interface. The input unit 104 receives various types of operation information input by users belonging to the sales department, and outputs the received operation information to the processing unit 101. The display unit 105 includes a display device such as a liquid crystal display and a display unit interface. The display unit 105 displays various information input from the processing unit 101. The communication unit 106 is connected to the wide area network NT.

  Next, a functional configuration of the order possibility evaluation apparatus 1 according to the present embodiment will be described. The processing unit 101 illustrated in FIG. 2 functions as each unit illustrated in FIG. 3 by executing a program stored in the storage unit 103. Specifically, the processing unit 101 functions as a reception unit 111, a suitability determination unit 113, a process capability determination unit 114, a ranking unit 116, an information output unit 117, a process capability calculation unit 118, and a product specification recording unit 119. . As shown in FIG. 3, the storage unit 103 includes a product specification DB 132, a process capability index DB 133, a determination result DB 134, and a final determination result DB 136.

  As shown in FIG. 4, the product specification DB 132 shown in FIG. 3 stores specification items of the company's products and their contents in association with each piece of product number information. In the example shown in FIG. 4, the contents of a plurality of use items are stored for each of the product numbers “AAAAA”, “AAAABB”, “AABBBB”, “ACABC”,.

  As shown in FIG. 5A, the process capability index DB 133 shown in FIG. 3 stores process capability index information indicating the process capability indexes Cpk and Ppk in the manufacturing process of each product in association with the product number information. Here, the process capability indexes Cpk and Ppk correspond to the minimum value of the plurality of process capability indexes Cpk and Ppk when there are a plurality of types of process capability indexes Cpk and Ppk in the manufacturing process of each product. The example shown in FIG. 5A indicates that the process capability index Cpk of the manufacturing process of the product having the product number “AAAAA” is “1.5” and the process capability index “Ppk” is “1.5”. ing. As these process capability indexes, for example, those calculated from inspection performance information on products manufactured within a preset period are adopted.

  As shown in FIG. 5B, the determination result DB 134 shown in FIG. 3 displays the result of determining the compatibility between the specifications of the company's product and the requested specifications of the product requested for order from the customer for each piece number information. Store it in association with. The determination result is stored for each specification item. For each specification item, when the product specification of the company satisfies the required specification, the determination result is “◯”, and when the product specification of the company satisfies a part of the required specification, the determination result is “△”. If the product specification of the company does not satisfy the required specification at all, the determination result is “x”. For example, for the specification item “use temperature range”, when the use temperature range of the required specification is within the use temperature range of the company's product, the determination result is “◯”. In addition, the upper limit of the operating temperature range of the required specification is less than or equal to the upper limit of the operating temperature range of the company's product, but the lower limit of the operating temperature range of the required specification is less than the lower limit of the operating temperature range of the company's product. In this case, the determination result is “Δ”. On the other hand, the upper limit of the operating temperature range of the required specification exceeds the upper limit of the operating temperature range of the company's product, and the lower limit of the operating temperature range of the required specification is less than the lower limit of the operating temperature range of the company's product In this case, the determination result is “x”. In the example shown in FIG. 5B, in the product number “AAAAA”, the determination result of the specification item “operating temperature range” is “Δ”, and the determination result of the specification item “vibration test result” is “◯”. This indicates that the upper limit or lower limit of the operating temperature range of the required specifications is outside the operating temperature range of the company's product, the vibration test result exists, and the request for submission of the vibration test result can be met. ing.

  The final determination result DB 136 illustrated in FIG. 3 stores determination results for product number information that is candidates for supply to customers.

  The receiving unit 111 receives request specification information indicating a required specification of a product for which an order is requested from a customer input by the user via the input unit 104 and product number information of a product to be supplied to the customer. The accepting unit 111 notifies the product number information to the suitability determining unit 113 and the process capability determining unit 114, and notifies the required specification information to the conformity determining unit 113.

  The conformity determination unit 113 refers to the product specification DB 132 and acquires product specification information corresponding to the product number information notified from the reception unit 111 from the product specification DB 132. The suitability determination unit 113 compares the required specification information acquired from the reception unit 111 with the product specification information acquired from the product specification DB 132, and determines suitability for each specification item. Here, “compatibility” is a scale indicating how much the product specification satisfies the required specification. For example, when the use temperature range included in the required specification information is included in the use temperature range included in the product specification information, it is determined that the compatibility is good. On the other hand, if the use temperature range included in the required specification information is outside the use temperature range included in the product specification information, it is determined that the compatibility is poor. And the suitability determination part 113 memorize | stores the result of the suitability determination about each specification item in determination result DB134.

  The process capability determining unit 114 refers to the process capability index DB 133 and acquires process capability index information indicating the process capability indexes Cpk and Ppk of the product corresponding to the product number information notified from the product number specifying unit 112. Then, the process capability determination unit 114 determines whether or not the process capability index indicated by the process capability index information included in the required specification information is greater than or equal to the process capability indexes Cpk and Ppk indicated by the acquired process capability index information. And the process capability determination part 114 memorize | stores the determination result about process capability index | exponents Cpk and Ppk in determination result DB134.

  The ranking unit 116 ranks each of the product determination results stored in the determination result DB 134 according to the application status of “×”, “Δ”, and “◯”. The ranking unit 116 sets the special rank when all the specification items included in the determination result are given, and sets the first rank when the special rank is given and “x” is given to a part of the specification items. To do. In addition, when there is no specification item to which “×” is given among the specification items included in the determination result and some of the specification items are “△”, the ranking unit 116 determines that the second rank and all the specification items are included. When “◯” is given, it is set to the third rank. The ranking unit 116 stores rank information indicating the ranks of the plurality of products that have been ranked in the final determination result DB 136 in association with the determination results and the product number information of the plurality of products.

  The information output unit 117 outputs to the display unit 105 the determination result for the product supplied from the final determination result DB 136 to the customer.

  The process capability calculation unit 118 acquires information indicating an inspection result value and a preset standard value within a preset period in the manufacturing process of each product from the server 3 installed in the manufacturing department. . Then, the process capability calculation unit 118 calculates process capability indexes Cpk and Ppk corresponding to the product number information notified from the product number specifying unit 112 from the acquired inspection result value and standard value. The “preset period” is set, for example, in the period of the most recent months. In this case, the process capability determination unit 114 can determine whether or not the most recent process capability index exceeds the process capability index included in the required specification information. In addition, it is assumed that a plurality of types of inspections are performed in the product manufacturing process, and that there are a plurality of types of inspection results and standard values corresponding to them. In this case, the process capability calculation unit 118 calculates a process capability index corresponding to various inspections, and extracts the minimum value among the calculated process capability indexes as process capability indexes Cpk and Ppk corresponding to the product number information. As a result, it is possible to evaluate whether the process capability of the process with the lowest process capability among the manufacturing processes of each product exceeds the process capability included in the customer's requirement specification information. It can be assured that the products presented to meet the required specifications. The process capability calculation unit 118 stores process capability index information indicating the calculated process capability indexes Cpk and Ppk in the process capability index DB 133.

  The product specification recording unit 119 acquires product specification information of each product of the company from the server 2 installed in the quality control department and stores it in the product specification DB 132.

  Next, the order possibility evaluation process executed by the order possibility evaluation apparatus 1 will be described with reference to FIGS. This order possibility evaluation process is started when a user belonging to the sales department turns on the order possibility evaluation apparatus 1.

  First, the reception unit 111 outputs to the display unit 105 an input screen for inputting a required specification for which an order is requested from a customer and product part number information (step S101). For example, the reception unit 111 causes the display unit 105 to display a window 15a as illustrated in FIG. The window 15a includes an input prompt message M1, a product number information input field PN for inputting the product number of a candidate product to be supplied to the customer, and input fields B1, B2, for inputting each specification item required by the customer. B31, B32, B4 and an input completion button EK are included. For example, three product number information input fields are provided. In the input field B1, numerical values requested from the customer for each specification item are input. In the input field B2, the presence / absence of a request such as a vibration test result from the customer is input. The input field B2 is set so that a pop-up menu PM2 in which “Yes” and “No” are preset is displayed. In the input fields B31 and B32, the presence / absence of an implementation request such as APQP is input from the customer. In particular, for the specification item “PPAP”, the PPAP level requested by the customer is input. The input fields B31 and B32 are set so that a pop-up menu in which “Yes” and “No” are set in advance appears. In particular, the level input field of the specification item “PPAP” is set so that a pop-up menu PM3 in which “1”, “2”, and “3” are preset appears. In the input field B4, a numerical value indicating the process capability requested by the customer is input. Note that the reception unit 111 may be configured to take in information corresponding to each of the above-described input fields from other than the input unit 104, for example.

  Returning to FIG. 6, if the receiving unit 111 determines that the input completion notification has been received (step S102: Yes), the product number information input in the product number information input field PN is sent to the suitability determining unit 113 and the process capability determining unit 114. Output. At the same time, the reception unit 111 outputs the required specification information regarding each required specification input in the input fields B1, B2, B31, B32, and B4 to the suitability determination unit 113 and the process capability determination unit 114. Then, the compatibility determination unit 113 acquires the product specification corresponding to the product number information input from the reception unit 111 from the product specification DB 132, and determines the compatibility between the required specification input from the reception unit 111 and the product specification. (Step S103). Then, the suitability determination unit 113 stores the suitability determination result in the determination result DB 134.

  Subsequently, the process capability determination unit 114 acquires process capability index information corresponding to the product number information input from the product number specifying unit 112 from the process capability index DB 133, and the process capability index indicated by the process capability index information is the reception unit 111. It is determined whether or not the process capability index included in the required specification information input from (step S104). And the process capability determination part 114 memorize | stores the determination result about a process capability index | exponent in determination result DB134.

  After that, the ranking unit 116 ranks each of the product determination results stored in the determination result DB 134 according to the application status of “×”, “Δ”, and “◯” (step S105). The ranking unit 116 stores rank information indicating the ranks of the plurality of products that have been ranked in the final determination result DB 136 in association with the determination results and the product number information of the plurality of products.

  Subsequently, the information output unit 117 outputs the determination result stored in the final determination result DB 136 to the display unit 105 (step S106). Then, for example, a window 15b as shown in FIG. 8 is displayed on the display unit 105, and the determination results for the three products that are candidates to be supplied to the customer are presented.

  Thereafter, the accepting unit 111 determines whether or not there is an input screen display command from the input unit 104 (step S107). This input screen display command is output from the input unit 104 to the reception unit 111 when the user performs a predetermined operation for causing the input unit 104 to display the input screen on the display unit 105. If the reception unit 111 determines that there is an input screen display instruction (step S107: Yes), the reception unit 111 executes the process of step S101 again.

  On the other hand, if it is determined that there is no input screen display command (step S107: No), the reception unit 111 determines whether there is a termination command from the input unit 104 (step S108). This end command is output from the input unit 104 to the accepting unit 111 when the user performs a predetermined operation on the input unit 104 to end the order possibility evaluation process. If it is determined by the receiving unit 111 that there is an end instruction (step S108: Yes), the order possibility evaluation process ends. On the other hand, when the reception unit 111 determines that there is no termination command (step S108: Yes), the reception unit 111 executes the process of step S107 again.

  As described above, according to the order possibility evaluation device 1 according to the present embodiment, the suitability determination unit 113 acquires the product specification corresponding to the product number information received by the receiving unit 111 from the product specification DB 132. The compatibility between the specification item included in the required specification and the specification item included in the product specification is determined. Thus, for example, even a user who does not have knowledge about the product specifications of the product can relatively easily know the suitability of the candidate product that is a candidate to be supplied to the customer with the requested specifications of the customer. Even such a user can determine whether or not an order for a product for which an order is requested by a customer can be made relatively smoothly.

  In addition, the order possibility evaluation device 1 according to the present embodiment includes a process capability index DB 133 that stores process capability index information, and a process capability determination unit 114. Then, the process capability determination unit 114 determines whether or not the process capability index of the product manufacturing process notified from the reception unit 111 is equal to or greater than the process capability index included in the required specification information. As a result, the information output unit 117 can select a candidate product in consideration of the process capability index included in the required specification information, so that it can be shown to the customer that the product yield of the ordered product is guaranteed.

  Furthermore, the order possibility evaluation apparatus 1 according to the present embodiment is configured to determine the manufacturing process of each product from the inspection result value within a preset period and the preset standard value in the product manufacturing process. A process capability calculation unit 118 that calculates a process capability index is provided. Thereby, for example, when the preset period is set to the latest period, the process capability determination unit 114 determines whether or not the latest process capability index exceeds the process capability index included in the required specification information. It becomes possible to do. Therefore, it is possible to accurately determine whether or not the process capability index of each product exceeds the process capability index included in the requirement specification information based on the latest process capability index.

[Modification]
Although the embodiment of the present invention has been described above, the present invention is not limited to the configuration of the above-described embodiment. For example, the server 3 may calculate the process capability index from the process information of each product of the company, and may transmit the process capability index information indicating the calculated process capability index to the order possibility evaluation device 1. In this case, the order possibility evaluation device may be configured to store the process capability index information received from the server 3 in the process capability index DB 133 as it is.

  According to this configuration, the processing performed by the process capability calculation unit 118 can be simplified, and therefore the processing load of the order possibility evaluation device can be reduced.

  Moreover, the various functions of the order possibility evaluation apparatus 1 according to the present invention can be realized by using a normal computer system without using a dedicated system. For example, to a computer connected to a network, a program for executing the above operation is stored in a non-transitory recording medium (CD-ROM or the like) that can be read by a computer system, and the program is distributed to the computer. You may comprise the order possibility evaluation apparatus 1 which performs the above-mentioned process by installing in a system.

  Further, the method for providing the program to the computer is arbitrary. For example, the program may be uploaded to a bulletin board (BBS) on a communication line and distributed to a computer via the communication line. Then, the computer activates this program and executes it like other applications under the control of the OS. Thereby, the computer functions as the order possibility evaluation device 1 that executes the above-described processing.

As mentioned above, although each embodiment and modification (including what was written in the description. The same is true hereinafter) of the present invention have been described, the present invention is not limited to these. The present invention includes a combination of the embodiments and modifications as appropriate, and a modification appropriately added thereto.

1: order acceptability evaluation apparatus, 2, 3: server, 15a, 15b: window, 101: processing unit, 103: storage unit, 104: input unit, 105: display unit, 106: communication unit, 111: reception unit, 113: Suitability determination unit, 114: Process capability determination unit, 116: Ranking unit, 117: Information output unit, 118: Process capability calculation unit, 119: Product specification recording unit, 131: Product number DB, 132: Product specification DB 133: Process capability index DB, 134: Determination result DB, 135: Determination result score DB, 136: Final determination result DB, B1, B2, B4, B31, B32: Input field, EK: Input completion button, M1: Input Reminder message, NT: Wide area network, PM2, PM3: Pop-up menu, PN: Product number information input field

Claims (5)

A product specification database for storing product specification information indicating product specifications including at least one specification item in association with product number information;
A reception unit that receives required specification information indicating a required specification of a product ordered from a customer and product number information of a candidate product to be supplied to the customer;
Acquiring product specification information corresponding to the product number information from the product specification database, and a compatibility determination unit for determining compatibility between the required specification information and the product specification information,
An output unit that outputs a determination result by the suitability determination unit,
Order possibility evaluation device. A process capability index database for storing the process capability index in the manufacturing process of the product in association with the product number information of the product;
With reference to the process capability index database, obtaining the process capability index information indicating the process capability index of the manufacturing process of the product of the product number information received by the reception unit, the process capability index indicated by the acquired process capability index information, A process capability determination unit that determines whether or not the process capability index included in the required specification information is greater than,
The suitability determination unit determines suitability between the required specification information and the product specification information based on a determination result by the process capability determination unit.
The order possibility evaluation device according to claim 1. The apparatus further includes a process capability calculation unit that calculates a process capability index of the product manufacturing process of the product number information from an inspection result value within a preset period and a preset standard value in the product manufacturing process. ,
The order possibility evaluation device according to claim 2. Receiving required specification information indicating a required specification of a product ordered from a customer and product number information of a candidate product to be supplied to the customer;
Product specification information corresponding to the product number information is acquired from a product specification database that stores product specification information indicating product specifications including at least one specification item in association with the product number information, and the required specification information and the product specification information Determining compatibility with
Outputting a determination result of suitability,
Order possibility evaluation method. Computer
A reception unit that receives required specification information indicating a required specification of a product ordered from a customer and product number information of a candidate product to be supplied to the customer;
Product specification information corresponding to the product number information is acquired from a product specification database that stores product specification information indicating product specifications including at least one specification item in association with the product number information, and the required specification information and the product specification information A compatibility determination unit for determining the compatibility with
An output unit for outputting a determination result by the suitability determination unit;
Program to function as.

Images