Estimation system and method
The estimation system integrates data models across multiple manufacturing sites to efficiently trace and identify defective raw materials and products, reducing costs and risks through unified data management and processing.
Patent Information
- Application Number
- JP2023082544
- Authority / Receiving Office
- JP · JP
- Patent Type
- Applications
- Current Assignee / Owner
- Filing Date
- 2023-05-18
- Publication Date
- 2024-11-28
- Estimated Expiration
- 2043-05-18
AI Technical Summary
Existing methods fail to efficiently trace the impact of defective raw materials across multiple manufacturing sites, leading to increased costs and risks due to the varying information management levels at different manufacturing bases.
An estimation system and method that integrates data models from multiple manufacturing sites, allowing for the estimation of the range of influence and raw material identification by defining a common data model for all factories and individual factory data models, using trace forward and traceback processing to quickly identify affected products and materials.
Enables rapid estimation of the impact of defective raw materials and products, reducing loss costs and recall risks by aligning data management levels across sites and facilitating efficient tracing and traceback.
Smart Images

Figure 2024165940000001_ABST
Abstract
Description
[Technical field]
[0001] The present invention relates to an estimation system and method, and is suitable for use in an estimation system that, for example, traces a manufacturing process across multiple locations to estimate the scope of impact of a raw material in which a defect has been discovered, or that estimates the raw materials of a product in which a defect has been discovered. [Background technology]
[0002] When a product is found to be defective, it is important to quickly respond by tracing the manufacturing process to determine the cause and investigating the extent of the effect of the cause. However, because it is necessary to contact various places and information is scattered, tracing the manufacturing process to determine the cause and investigating the extent of the effect of the cause are burdensome.
[0003] Regarding this point, for example, Patent Document 1 discloses a method for performing tracing that reduces the burden on the user by linking performance information in the manufacturing process up to product shipment and registering storage information that indicates the linking content. [Prior art documents] [Patent documents]
[0004] [Patent Document 1] International Publication No. 2021 / 005747 Summary of the Invention [Problem to be solved by the invention]
[0005] However, this Patent Document 1 does not take into consideration tracing across multiple manufacturing sites. When doubts are discovered about a raw material, there are cases where that raw material (hereinafter referred to as the suspect raw material) is procured from multiple manufacturing sites, so when identifying the range of products manufactured using the suspect raw material (the range of influence of the suspect raw material), tracing across multiple manufacturing sites may be required.
[0006] In order to perform tracing across multiple manufacturing sites, it would be ideal to have the same granularity of information management (hereafter referred to as the information management level) at each manufacturing site, but it is expected to be difficult to achieve the same information management level at all manufacturing sites.
[0007] For this reason, it is desirable to develop a method that can quickly grasp the extent of the impact of a suspect raw material, even if the level of information management differs at each manufacturing site. If such a method could be realized, it is believed that it would be possible to reduce loss costs due to the production of defective products and the risk of loss due to the recall of defective products.
[0008] The present invention has been made in consideration of the above points, and aims to propose an estimation system and method that can reduce loss costs due to the production of defective products and reduce the risk of loss due to the recall of defective products. [Means for solving the problem]
[0009] In order to solve such problems, in the present invention, an estimation system for estimating the scope of the impact when doubts are discovered about raw materials used in the manufacture of a product at multiple manufacturing sites and / or estimating the raw materials when a defect in the product is discovered, includes a data collection unit that collects on-site data for each process performed at each of the manufacturing sites, a data model definition unit that defines a first data model that models each of the processes performed at the manufacturing sites based on the collected on-site data and sequentially associates the first data model for each process in the order of the manufacturing process of the product, thereby defining a second data model that models the manufacturing process of the product, and a data access control unit that utilizes the second data model based on information about the raw materials about which doubts are discovered, to estimate the scope of the product manufactured using the raw materials or to estimate the raw materials of the product about which a defect is discovered.
[0010] In addition, in the present invention, an estimation method is executed in an estimation system that estimates the scope of impact when doubts are discovered about raw materials used in the manufacture of a product at a plurality of manufacturing sites and / or estimates raw materials when a defect in the product is discovered, and includes a first step of collecting on-site data for each process performed at each of the manufacturing sites, a second step of defining a first data model that models each of the processes performed at the manufacturing sites based on the collected on-site data and sequentially associating the first data model for each process in the order of the manufacturing process of the product, thereby defining a second data model that models the manufacturing process of the product, and a third step of using the second data model to estimate the scope of the product manufactured using the raw materials based on information about the raw materials about which doubts are discovered, or estimating the raw materials of the product about which a defect is discovered.
[0011] According to the estimation system and method of the present invention, it is possible to quickly estimate the scope of the impact of a suspected raw material or the raw material of a product in which a defect has occurred. Effect of the Invention
[0012] According to the present invention, it is possible to realize an estimation system and method that can reduce loss costs due to the production of defective products and reduce the risk of loss due to the recall of defective products. [Brief description of the drawings]
[0013] [Figure 1] FIG. 1A is a conceptual diagram for explaining a business data model, and FIG. 1B is a conceptual diagram for explaining an integrated data model. [Diagram 2] 13A and 13B are conceptual diagrams for explaining an all-factory common data model and an individual factory data model. [Diagram 3] 1 is a block diagram showing a configuration of an estimation system according to an embodiment of the present invention. [Figure 4] 1 is a diagram showing an example of a configuration of master data. [Diagram 5] 1 is a diagram showing an example of a configuration of transaction data. [Figure 6A] 1 is a diagram showing an example of the configuration of integrated 4M information. [Figure 6B] This is a conceptual diagram showing how the integrated 4M information of each process is linked in the all-factory common data model. [Figure 7A] 1 is a diagram showing an example of the configuration of 4M information. [Figure 7B] This is a conceptual diagram conceptually showing how 4M information for each process is linked in an individual factory data model. [Figure 8] FIG. 11 is a conceptual diagram illustrating a trace forward process. [Figure 9] FIG. 1 is a conceptual diagram illustrating a traceback process. [Figure 10A] FIG. 13 is a diagram showing an example of a first condition setting and result display screen for an all-factory common data model. [Figure 10B] FIG. 13 is a diagram showing an example of a first condition setting / result display screen for an individual factory data model. [Figure 11] FIG. 13 is a diagram showing an example of the screen configuration of a second condition setting / result display screen. [Figure 12] 13 is a flowchart showing a processing procedure of a trace forward process. [Figure 13] 13 is a flowchart showing a procedure for traceback processing; DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS
[0014] An embodiment of the present invention will now be described in detail with reference to the drawings.
[0015] (1) Data Model in the Present Embodiment As shown in Figure 1(A), all production activities can be defined by information about the content of the work (hereafter referred to as work information), information about the parts (material) input into the work and the finished products (material) produced as a result of the work, information about the workers (Man) and machines (Machines) who performed the work, and information about the work procedures (Method) of the work.
[0016] In the following, the data model in Figure 1(A) will be referred to as business data model 1, and the nodes corresponding to business, parts, finished products, workers, machines, and work procedures will be referred to as business node 1B, part node 1A, finished product node 1C, worker node 1D, machine node 1E, and work procedure node 1F, respectively.
[0017] In the following, information related to operations will be referred to as "operational information," and information related to parts, finished products, workers, machines, and work procedures will be collectively referred to as "4M information," taking the initial letter "M" from the English names of parts, finished products, workers, machines, and work procedures.
[0018] Therefore, each business can be represented as a business data model 1 as shown in Figure 1(A), in which business information is mapped to a business node 1B, and 4M information data acquired at the actual site (hereinafter referred to as site data) is mapped to a part node 1A, a finished product node 1C, a worker node 1D, a machine node 1E, and a work procedure node 1F.
[0019] Furthermore, in a manufacturing site such as a factory, if we note that the output parts of a previous process are the input parts of a subsequent process, the series of manufacturing processes from the receipt of raw materials to the production and shipment of products can also be represented as a series of data models (hereinafter referred to as an integrated data model) 2 as shown in Figure 1(B), which associates business data models 1 of each process in the order in which they are performed.
[0020] Therefore, by mapping the on-site data of each process to an integrated data model 2 that represents a series of manufacturing processes from the receipt of raw materials to the shipment of products, the manufacturing process from raw materials to the shipment of products can be defined as a single integrated data model 2.
[0021] Furthermore, when the same product is made in multiple factories using the same raw materials, by associating the 4M information of each process in the integrated data model 2 that represents the manufacturing process with the 4M information of that process in each factory, the series of manufacturing processes from raw materials to product shipment in multiple factories can be represented by a single integrated data model 2. Note that "the same raw materials" here means the same type of raw materials, and "the same product" means the same product item. The same applies below.
[0022] In this way, by expressing a series of manufacturing processes in each factory that manufactures the same product using the same raw materials in a single integrated data model 2, it is possible to facilitate performance management for each factory.
[0023] Furthermore, for example, if a defect is discovered in a certain lot of a certain raw material, by starting from that lot of that raw material (suspect raw material) (hereinafter referred to as the suspect lot) and tracing the integrated data model 2 along the flow of the manufacturing process (hereinafter referred to as trace forward processing), it is possible to detect all at once the location and status of products that have been manufactured or are in the manufacturing process at each factory using that suspect lot of the suspect raw material, and thereby the scope of the impact of the suspect lot of the suspect raw material can be quickly identified.
[0024] Furthermore, even when a product defect is discovered, the raw materials and their lots that may have caused the defect can be identified by tracing the integrated data model 2 in the reverse direction of the manufacturing process, starting from the product (hereinafter, this is referred to as trace-back processing).In addition, if an investigation of that raw material lot reveals that the raw material lot is defective, the integrated data model 2 can be traced along the manufacturing process, starting from that raw material lot (trace-forward processing), to quickly estimate the scope of the impact of the raw material defect, such as which product manufactured in which factory the defect may have occurred.
[0025] However, when the same product is manufactured in multiple factories using the same raw materials, the information management level at each factory may differ. For example, some factories A1, A2, etc. manage the process from manufacturing to shipping the product with on-site data for four processes, "Process 1" to "Process 4," as shown in Figure 2(A), while other factories B, C, etc., which manufacture the same product using the same raw materials, manage the process from manufacturing to shipping the product with on-site data for six processes, "Process 1" to "Process 6," as shown in Figure 2(B) (in the case of Factory B in Figure 2(B)), or manage the process with on-site data for five processes, "Process 1" to "Process 5," as shown in Figure 2(B) (in the case of Factory C in Figure 2(B)).
[0026] Figure 2(A) shows an example in which the process from manufacturing to shipping a product is managed using on-site data for two processes: "Process 1," where raw materials and other parts are received, and "Process 2," where those parts are used to manufacture a finished product (product); and the process from manufacturing to shipping the finished product is managed using on-site data for two processes: "Process 3," where a specified number of finished products are stacked on pallets, and "Process 4," where the finished products are shipped in pallet units.
[0027] The upper part of Figure 2 (B) is an example in which the processes from manufacturing to shipping a product are managed using on-site data for three processes: "Process 1," where raw materials and other parts are received; "Process 2," where finished products are manufactured using those parts; and "Process 3," where the manufactured finished products are individually packaged (individually wrapped); and the processes from manufacturing to shipping the finished products are managed using on-site data for three processes: "Process 4," where a specified number of finished products are placed in cases; "Process 5," where a specified number of those cases are loaded onto pallets; and "Process 6," where finished products are shipped in pallet units.
[0028] Furthermore, the lower section of Figure 2 (B) is an example in which the process from manufacturing to shipping a product is managed using on-site data for three processes: "Process 1," where raw materials and other parts are received; "Process 2," where finished products are manufactured using those parts; and "Process 3," where the manufactured finished products are individually packaged (packaged).The process from manufacturing to shipping a finished product is managed using on-site data for two processes: "Process 4," where finished products (whether individually packaged or not) are stacked on pallets in specified quantities; and "Process 5," where finished products are shipped in pallet units.
[0029] In such a case, since the contents of "Process 1," "Process 2," etc. are different between Factory A1, A2, etc. and Factory B and Factory C, it is not possible to create an integrated data model 2 as shown in Figure 2(A) that is common to all factories. If it is not possible to create an integrated data model 2 that is common to all factories, it is not possible to enjoy the above-mentioned benefits that can be obtained by creating such an integrated data model 2.
[0030] Therefore, in this embodiment, when the information management level of some factories is different from that of other factories, an integrated data model 2 (hereinafter, referred to as a data model common to all factories) is created that collects only the processes for which on-site data is managed in common across all factories (hereinafter, referred to as processes common to all factories). Note that, here, factories other than factories A1, A2, ..., factory B, and factory C also have the same processes as "Process 1" to "Process 4" of factories A1, A2, ....
[0031] For example, in the examples of Figures 2(A) and 2(B), "Process 1," "Process 2," "Process 3," and "Process 4" of factories A1, A2, ... are respectively the same processes as "Process 1," "Process 2," "Process 5," and "Process 6" of factory B, and are respectively the same processes as "Process 1," "Process 2," "Process 4," and "Process 5" of factory C. Therefore, a common data model for all factories as shown in Figure 2(A) is created, which consists only of "Process 1," "Process 2," "Process 3," and "Process 4" of factory A, which are common to all of factories A1, A2, ..., factory B, and factory C.
[0032] Furthermore, for Factory B, Factory C, etc., which manage on-site data for processes other than those common to all factories and have finer information granularity, an integrated data model 2 (hereinafter referred to as an individual factory data model) dedicated to that factory B is created, as shown in the upper part of Figure 2(B) consisting of each process ("Process 1" to "Process 6") of that factory B. Similarly, for Factory C, an individual factory data model dedicated to that factory C is created, as shown in the lower part of Figure 2(B) consisting of each process ("Process 1" to "Process 5") of that factory C.
[0033] Then, when a defect is discovered in a certain lot of a certain raw material and the extent of the impact is identified, for factories whose information management level is the same as that of the all-factory common data model (i.e. factories that manage only on-site data for the same processes as those that make up the all-factory common data model), the all-factory common data model is used to estimate the extent of the impact of that raw material in each factory whose information management level is the same as that of the all-factory common data model.
[0034] In addition, for factories whose information management level is different from that of the all-factory common data model (i.e., factories that also manage on-site data of processes different from those that make up the all-factory common data model), the individual factory data model of that factory is used to estimate the impact range of the raw materials at that factory.
[0035] Then, by combining the impact range of the raw material estimated for each factory whose information management level is the same as the all-factory common data model with the impact range of the raw material estimated for each factory whose information management level is different from the all-factory common data model, it is possible to estimate the impact range of the defective raw material lot across multiple factories.
[0036] By doing so, the extent of the impact of a defect in a raw material can be estimated more easily and quickly than in the case where individual factory data models are created for all factories.
[0037] The following describes an estimation system of this embodiment, in which the manufacturing processes of products in multiple factories that manufacture the same product using the same raw materials are managed by defining the all-factory common data model and individual factory data model as described above, and in the event that a defect in the raw materials or product is discovered, the extent of the impact can be estimated using the all-factory common data model and the individual factory data model and presented to the user.
[0038] (2) Configuration of Estimation System According to the Present Embodiment In Fig. 3, the estimation system according to this embodiment is generally designated by 10. This estimation system 10 is configured with manufacturing systems and equipment 11 installed in each of a plurality of factories that manufacture the same product using the same raw materials, a central management device 12 installed in a head office or the like that centrally manages the factories, a data extraction device 13, a client 14, and an estimation device 15.
[0039] In addition, the communication between the general management device 12 and the data extraction device 13, the communication between the data extraction device 13 and the estimation device 15, and the communication between the client 14 and the estimation device 15 can use a general public line network, whether wired or wireless, for example, a fifth generation mobile communication system (so-called 5G (5th Generation)) that enables "multiple simultaneous connections" and "ultra-low latency". Furthermore, by utilizing the characteristics of new mobile phone systems after 5G, it is expected that the effects of this embodiment described below will be improved.
[0040] The manufacturing system / equipment 11 is composed of a barcode reader that acquires the work logs of workers, a computer device or server device that collects the work logs, machines that process parts or assemble finished products, and sensors that collect inspection information from RFID (Radio Frequency Identifiers) attached to the parts or finished products (products).
[0041] The overall management device 12 is composed of a general-purpose computer device, and holds preregistered information such as the item, name and raw materials of the products manufactured in each factory as common management master information 16. The overall management device 12 also collects various information output from the manufacturing systems and equipment 11 of each factory, and holds this collected information and pregiven information such as the manufacturing plans of products in each factory as common system information 17.
[0042] The data extraction device 13 is composed of, for example, a general-purpose server device. The data extraction device 13 reads out the common management master information 16 held by the central management device 12 periodically (for example, every few hours, one day, or several days) and transmits the read common management master information 16 to the estimation device 15. This common management master information 16 is stored as master data 19 as shown in FIG. 4 in a master data storage unit composed of a large-capacity nonvolatile storage device such as a hard disk device or SSD (Solid State Drive) mounted on the estimation device 15.
[0043] Furthermore, the data extraction device 13 periodically (for example, at the same period as the period for reading out the common management master information 16) extracts business information and 4M information of each process carried out in each factory from the common system information 17 held and managed by the overall management device 12, and transmits the extracted business information and 4M information of each process in each factory to the estimation device 15. This business information and 4M information are stored as transaction data 21 as shown in Fig. 5 in a transaction data storage unit 20 consisting of a large-capacity storage device such as a hard disk device or SSD mounted on the estimation device.
[0044] The client 14 is a computer device used by a user. The user can, by performing a predetermined operation, display on the client 14 a first condition setting and result display screen 30, which will be described later with reference to Fig. 10A and Fig. 10B, and a second condition setting and result display screen 50, which will be described later with reference to Fig. 11. Using the first and second condition setting and result display screens 30, 50, the user can set conditions (hereinafter referred to as search conditions) for estimating the extent of the influence of a raw material by a trace-forward process when a defect in the raw material is discovered, or for estimating the raw materials of the product by a trace-back process when a defect in the product is discovered.
[0045] The estimation device 15 is composed of a general-purpose computer device equipped with physical devices such as a processor such as a CPU (Central Processing Unit), a non-volatile memory such as a semiconductor memory, and a large-capacity non-volatile storage device such as a hard disk drive or SSD.
[0046] 3, the estimation device 15 is logically configured to include a data model definition unit 22, a data access control unit 23, and a display unit 24. The data model definition unit 22, the data access control unit 23, and the display unit 24 are realized by the above-mentioned processor executing corresponding programs stored in the above-mentioned memory or storage device.
[0047] The data model definition unit 22 is a functional unit having a function of defining the all-factory common data model described above with reference to FIG. 2(B) and individual factory data models for the required factories, using the master data 19 (FIG. 4) stored in the master data storage unit 18 and the transaction data 21 (FIG. 5) stored in the transaction data storage unit 20.
[0048] In practice, the data model definition unit 22 first extracts all processes for which on-site data is managed in common across all factories, based on the master data 19 stored in the master data storage unit 18 and the transaction data 21 stored in the transaction data storage unit 20, and defines the business data model 1 described above for each of the extracted processes in Fig. 1(A). In this case, the method disclosed in JP 2019-153051 A can be applied as a method for defining the business data model 1.
[0049] At this time, the 4M information mapped to the business data model 1 does not necessarily need to include all of the information on parts, finished products, workers, machines, and work procedures; only the information that can be obtained should be mapped to the corresponding part node 1A, finished product node 1C, worker node 1D, machine node 1E, and work procedure node 1F, respectively.
[0050] Then, the data model definition unit 22 defines an all-factory common data model by sequentially associating the business data models 1 of the defined individual processes in the order of the processes. Such an all-factory common data model can be defined by identifying a factory in which all processes for which on-site data is managed are common to all factories, and sequentially associating the business data models 1 of each process of the factory in the order of processes on a lot-by-lot basis, focusing on the fact that the finished products of the preceding process are input parts of the succeeding process, so that the finished products and their lot numbers of the preceding process match the input parts and their lot numbers of the succeeding process in sequence.
[0051] At this time, the data model definition unit 22 links (maps) the 4M information for each process in the all-factory common data model in each factory (corresponding transaction data 21 extracted from the transaction data storage unit 20) to that process as integrated 4M information 25A, which is compiled as one as shown in Figure 6A.
[0052] For ease of understanding, Fig. 6A simply shows only the information relating to part node 1A in Fig. 1(A) among the integrated 4M information 25A associated with the process of inputting raw materials into the manufacturing equipment ("Process 2" in Fig. 2(A) and "Process 2" in Fig. 2(B)). Therefore, in reality, in addition to the information relating to part node 1A for this process, each piece of information relating to finished product node 1C, worker node 1D, machine node 1E, and work procedure node 1F in Fig. 1(A) for that process in each factory is also collected and linked to that process as part of integrated 4M information 25A.
[0053] By linking the integrated 4M information 25A for each process of the all-factory common data model in this way, the integrated 4M information 25A for each process is linked as shown in Fig. 6B. This makes it easy to search for information such as the current location of a product made using a certain lot of raw materials (for example, the pallet number of the pallet on which it is loaded), the manufacturing date and time of the product, and the production volume.
[0054] In addition, for factories that manage on-site data for processes other than those for which on-site data is managed commonly across all factories, the data model definition unit 22 defines a business data model 1 for each process in the factory by linking the 4M information 25B for that process, as shown in Figure 7.
[0055] Like Fig. 6A, Fig. 7A, for ease of understanding, simply depicts only the information relating to part node 1A in Fig. 1(A) among the 4M information 25B linked to the process of inputting raw materials into the manufacturing equipment ("Process 2" in Fig. 2(A) and "Process 2" in Fig. 2(B)). Therefore, in reality, in addition to the information relating to part node 1A for this process, each piece of information relating to finished product node 1C, worker node 1D, machine node 1E, and work procedure node 1F in Fig. 1(A) for that process in each factory is also collected and linked to that process as part of the 4M information 25B.
[0056] And by linking the 4M information 25B to each process of the individual factory data model in this way, it is possible to link the information of the "parts" in the process of inputting raw materials into the manufacturing equipment to the information of the "finished product" in the process that has been completed up to that point, as shown in Fig. 7B. This makes it easy to search for more detailed information about the products, such as the serial number of each product made using a certain lot of raw materials, the case number of the case in which the product is stored, and the pallet number of the pallet on which the product is loaded.
[0057] The data model definition unit 22 then defines an individual factory data model for the factory by sequentially associating these defined business data models 1 in the order of processes so that the finished products and their lots in the preceding process match the input parts and their lots in the succeeding process, while paying attention to the fact that the output parts of the preceding process are the input parts of the succeeding process.
[0058] The data model definition unit 22 then stores the all-factory common data model and the individual factory data model defined in this manner in a data model accumulation unit 26 consisting of a large-capacity non-volatile storage device such as a hard disk device or SSD.
[0059] The display unit 24 is a functional unit having a function of transmitting screen data of a first condition setting / result display screen 30 (FIGS. 10A and 10B) and screen data of a second condition setting / result display screen 50 (FIG. 11) to the client 14 in response to a request from the client 14. Based on these screen data, the first or second condition setting / result display screen 30, 50 is displayed on the client 14.
[0060] The display unit 24 also has a function of acquiring search conditions designated by the user on these first and second condition setting / result display screens 30, 50 and transferring them to the data access control unit 23, and transmitting to the client 14 the extent of the influence of defective raw materials estimated by the data access control unit 23 based on these search conditions as described below, and the estimated results of the raw material lot of the product in which the defect was discovered. As a result, the estimated results are displayed on the first and second condition setting / result display screens 30, 50 displayed on the client 14.
[0061] In addition, the "search conditions" for estimating the scope of the impact when a defect in a raw material is discovered are identification information of that raw material (suspect raw material), such as the raw material code or raw material name, and the lot number of the lot in which the defect in the suspect raw material was discovered (hereinafter referred to as the suspect lot).
[0062] In addition, when a product defect is discovered, the "search conditions" for estimating the lot of raw materials used to manufacture the product are information capable of identifying the product, such as the product item, manufacturing date, manufacturing time, manufacturing plant identification code, and / or serial number printed on the product's individual packaging.
[0063] The data access control unit 23 is a functional unit that, when search conditions are given from the display unit 24, estimates the scope of impact of the suspect raw material from all factories in which a defect has been discovered, and the raw material lot of the product in which a defect has been discovered, using the search conditions and the all-factory common data model and the individual factory data model stored in the data model storage unit 26, and transmits the estimation results to the client 14 via the display unit 24.
[0064] In practice, when the data access control unit 23 estimates the scope of the impact of a raw material in which a defect has been discovered (suspect raw material), it starts from the suspect raw material with the identification information and lot number specified as the search conditions, and searches the all-factory common data model (upper part of Figure 8) and the individual factory data model (lower part of Figure 8) along the product manufacturing process, as shown in Figure 8, and estimates the location and status of each product that has been manufactured or is in the process of being manufactured using the suspect raw material (trace-forward processing).
[0065] Furthermore, when a defect in a product is discovered and the data access control unit 23 needs to estimate the lot of the raw materials, first, based on information capable of identifying the product, such as the product's serial number, specified as a search condition, the data access control unit 23 estimates the raw materials and their lot by tracing the integrated data model 2 (data model common to all factories or individual factory data model) corresponding to the factory that manufactured the product in the reverse direction of the product's manufacturing process, as shown in FIG. 9 (traceback processing).
[0066] (3) Configuration of the condition setting and result display screen Fig. 10A shows the screen configuration of a first condition setting / result display screen 30 that can be displayed on the client 14 by a predetermined operation. This first condition setting / result display screen 30 is a screen where the user sets search conditions for making the estimation device 15 estimate the extent of the influence by trace forward processing when a defect in a raw material is discovered, and where the estimation results are displayed. Note that Fig. 10A is a display example of the first condition setting / result display screen 30 displayed for the all-factory common data model described above with reference to Fig. 6A.
[0067] The first condition setting / result display screen 30 comprises a search condition setting area 31, a process designation area 32, an estimated result display area 33, and a back button .
[0068] The search condition setting area 31 is an area for setting such search conditions, and includes a raw material code setting text box 40, a raw material name setting text box 41, a lot number setting text box 42, a period start date setting text box 43, and a period end date setting text box 44.
[0069] In the search condition setting area 31, the raw material code of the raw material in which a defect has been discovered (suspect raw material) is entered into the raw material code setting text box 40, or the name of the suspect raw material is entered into the raw material name setting text box 41, and the lot number of the lot of the suspect raw material containing the defect (suspect lot) is entered into the lot number setting text box 42, thereby allowing the identification information of the suspect raw material and the lot number of the suspect lot to be set as search conditions.
[0070] In addition, in the search condition setting area 31, the start date of the desired period can be further entered in the period start date setting text box 43, and the end date of the period can be entered in the period end date setting text box 44, thereby also allowing the range of manufacturing dates of products manufactured using suspect lots of suspect raw materials to be set as search conditions.
[0071] Furthermore, in the process designation area 32, raw material marks 45 displayed in correspondence with the search condition setting area 31 and process buttons 46 corresponding to each process in the all-factory common data model are displayed vertically. In this case, the process buttons 46 are displayed in the order of the corresponding processes performed in the process of manufacturing the product.
[0072] In the first condition setting / result display screen 30, by clicking on the process button 46 corresponding to the desired process among the process buttons 46 displayed in the process designation area 32, the influence range up to that process can be specified as the influence range of the suspect raw material to be estimated.
[0073] Hereinafter, a process designated in this way will be referred to as a designated process. Note that the business content of each process in the all-factory common data model does not necessarily match that of each process in the individual factory data model. Therefore, a "designated process" in the individual factory data model is a process whose business content is the same as that of a designated process in the all-factory common data model.
[0074] Furthermore, the estimation result display area 33 lists in tabular form information on at least "parts" and "finished products" out of the 4M information of products that have been manufactured or are in the process of being manufactured using the questionable lot of questionable raw materials in each factory up to the designated process, which is estimated by tracing the necessary integrated data models out of the all-factory data model and each individual factory data model by tracing forward from the questionable raw materials to the designated process under the search conditions set in the search condition setting area 31.
[0075] 10A illustrates an example in which "Process 1" is a process for receiving raw materials, and only part of the information on "Parts" and "Finished Products" in that process is displayed, but other 4M information may be displayed. Also, the type of information displayed as an estimation result in the estimation result display area 33 may be freely set.
[0076] Furthermore, a check box 48 is displayed corresponding to each factory (each record) in the list 47 storing the estimation results displayed in the estimation result display area 33. Then, by clicking on this check box 48 to display a check mark 49 in the check box 48, it is possible to set the estimation of the impact range of the suspect raw material for processes after the designated process only for the factory corresponding to the record in which the check mark 49 is displayed.
[0077] For example, when a list 47 of the scope of the impact of the suspect raw material up to "Process 1" is displayed in the estimation result display area 33, if a check mark 49 is displayed in the check box 48 of the record corresponding to a desired factory, clicking the process button 46 for "Process 2" will display in the estimation result display area 33 the list 47 of the scope of the impact of the suspect raw material in "Process 2" of the factory related to the record with the displayed check mark 49.
[0078] Similarly, in this state, if a check mark 49 is displayed in the check box 48 of the record corresponding to a desired factory in the list of the impact range of suspect raw materials 47, clicking the process button 46 for "Process 3" will display the list 47 of the impact range of suspect raw materials in "Process 3" of the factory related to the record with the displayed check mark 49 in the estimation result display area 33. Furthermore, in the same manner thereafter, the impact range of suspect raw materials can be identified while narrowing down the impact range of suspect raw materials for each process.
[0079] The check mark 49 can be simultaneously displayed in each of the multiple check boxes 48. In this case, for the designated process and subsequent processes, the impact range of the suspect raw material is displayed in the list 47 of the estimation result display area 33 for all factories corresponding to each record in which the check mark 49 is displayed.
[0080] According to this first condition setting / result display screen 30, the user can easily recognize which process in a factory a product that uses a questionable lot of questionable raw materials is currently in, by switching the specified process to each process in the all-factory common data model in turn.
[0081] Furthermore, by designating the last process of the all-factory common data model (hereinafter referred to as the final process) as the designated process, the user can display information about the finished products of each factory that were manufactured using the suspect lot of the suspect raw material in the estimation result display area 33. In this case, since the information about the finished products of the final process includes the identification information of the pallet on which the products are loaded, even if the products have already been shipped from the factory, the destination of the products after shipment can be traced using the identification information of the pallet.
[0082] It should be noted that, on the first condition setting / result display screen 30, by clicking the back button 34, the display screen of the client 14 can be returned to a predetermined menu screen (not shown).
[0083] On the other hand, Fig. 10B, in which the same reference numerals are assigned to parts corresponding to those in Fig. 10A, shows an example of a first condition setting / result display screen 30 displayed for the individual factory data model described above in Fig. 7A. This first condition setting / result display screen 30 also has a similar configuration to the first condition setting / result display screen 30 described above in Fig. 10A.
[0084] However, in this case, since the corresponding factory manages data for more processes than the factory corresponding to the all-factory common data model, the number of process buttons 46 displayed in the process designation area 32 increases on the first condition setting / result display screen 30. Accordingly, a more detailed list 47 is displayed in the estimation result display area 33 on the first condition setting / result display screen 30.
[0085] For example, in the example of Fig. 10A, only the pallet number of the pallet on which the final product is loaded can be identified as the scope of influence of the suspect raw material, whereas in the example of Fig. 10B, the serial number of the final product, the case number of the case in which these products are stored, and even the pallet number of the pallet on which these cases are loaded are displayed in the list 47 of the estimation result display area 33 as the scope of influence of the suspect raw material. In other words, highly accurate tracing according to the information granularity held by the manufacturing base can be realized. In this way, the estimation device 15 can perform tracing for multiple manufacturing bases with different information granularity according to the information management level of the manufacturing base.
[0086] 11 shows the screen configuration of a second condition setting / result display screen 50 that can be displayed on the client 14 by a predetermined operation. This second condition setting / result display screen 50 is a screen where the user sets search conditions for causing the estimation device 15 to estimate the raw material lot by traceback processing when a defect in a product is discovered, and where the estimation results are displayed.
[0087] The second condition setting / result display screen 50 comprises a search condition setting area 51, an ingredient button display area 52, an estimated result display area 53, and a back button 54.
[0088] The search condition setting area 51 is an area for setting such search conditions, and includes a product item setting text box 60, a factory identification code setting text box 61, a manufacturing date setting text box 62, a manufacturing time setting text box 63, and a serial number setting text box 64.
[0089] In the search condition setting area 51, by inputting available information from among the product item, factory identification code, manufacturing date, manufacturing time, and serial number printed on the product itself or its packaging in which a defect has been discovered, into the product item setting text box 60, factory identification code setting text box 61, manufacturing date setting text box 62, manufacturing time setting text box 63, or serial number setting text box 64, this information can be set as search conditions for searching for the raw materials and lot of the product in which a defect has been discovered.
[0090] In addition, in the ingredient button display area 52, product marks 65 displayed in association with the search condition setting area 51 and ingredient buttons 66 corresponding to the ingredients are displayed aligned vertically.
[0091] In the second condition setting / result display screen 50, by clicking the raw materials button 66 displayed in the raw materials button display area 52, it is possible to instruct the estimating device 15 to estimate the raw materials and their lots of the product by traceback processing.
[0092] The identification information of the raw material estimated by this traceback process and the lot number of the lot are then displayed in the estimation result display area 53.
[0093] Incidentally, even on the second condition setting / result display screen 50, by clicking the back button 54, the display screen of the client 14 can be returned to the above-mentioned menu screen.
[0094] (4) Trace forward / backward search processing Next, the flow of the above-mentioned trace forward process and trace back process will be described. Note that the trace forward process will be described as a process flow when the process button 46 corresponding to the last process of the all-factory common data model in the process designation area 32 (the process button 46 for "Process 4" in the case of FIG. 10) is clicked after the search conditions are set on the above-mentioned first condition setting / result display screen 30 (FIG. 10).
[0095] (4-1) Trace forward processing Fig. 12 shows the procedure of the trace forward process executed by the data access control unit 23 (Fig. 3). This trace forward process is started when the client 14 notifies the data access control unit 23 via the display unit 24 (Fig. 3) of the estimation device 15 that the process button 46 corresponding to the last process of the all-factory common data model has been clicked in the process designation area 32 after the search conditions have been set in the search condition setting area 31 of the first condition setting / result display screen 30 (Fig. 10).
[0096] When the data access control unit 23 starts this trace forward processing, it first accepts as search conditions the identification information of the suspect raw material and the lot number of the suspect lot, which have been set as search conditions on the first condition setting / result display screen 30 and which are provided by the client 14 via the display unit 24 of the estimation device 15 (S1), as well as the start date and end date of the period, if a period has been set.
[0097] Next, the data access control unit 23 identifies the factory that accepted the suspect lot of the suspect raw material (S2). This identification is performed by identifying the all-factory common data model and the individual factory data model that include the identification information of the suspect raw material and the lot number of the suspect lot in the information of the "parts" of the 4M information linked to the receiving process of the raw material, among the all-factory common data model and each individual factory data model stored in the data model storage unit 26, and identifying the factory that corresponds to the identified all-factory common data model and individual factory data model.
[0098] Next, the data access control unit 23 selects one factory from among all factories identified in step S2 that has not been processed from step S4 onwards (S3). The data access control unit 23 then identifies the input record of the questionable lot of the questionable raw material in the selected factory (hereinafter referred to as the selected factory) (S4). This identification is performed by referring to the business information (the "business" information in FIG. 1(A)) of each process in the integrated data model (the all-factory common data model or the individual factory data model) of the selected factory to identify the process of inputting the raw materials into the machine, and identifying information including the identification information of the questionable raw material and the lot number of the questionable lot as "part" information from the integrated 4M information 25A or 4M information 25B linked to that process.
[0099] Next, the data access control unit 23 uses the results identified in step S4 as a starting point to sequentially identify manufacturing results related to the information on the manufacturing results identified in step S4 for each process in the integrated data model of the selected factory along the product manufacturing process (S5).
[0100] This process is performed by focusing on the fact that the output parts of the preceding process are input parts of the succeeding process as described above. Specifically, the data access control unit 23 identifies the information of the "finished product" in Fig. 1(A) corresponding to the actual results identified in step S4 (corresponding to the information of the "parts" in Fig. 1(A)), identifies the information of the "parts" including the information of the "finished product" from the integrated 4M information 25A or 4M information 25B of the next process, and further identifies the information of the "finished product" in Fig. 1(A) corresponding to that information, and repeats the process.
[0101] The data access control unit 23 then identifies the final process at the selected factory for the product manufactured using the questionable lot of questionable raw materials (hereinafter referred to as the final process) (S6), and obtains information regarding the "parts" and "finished products" in Figure 1 (A) for the product manufactured using the questionable lot of questionable raw materials at the identified final process from the 4M information linked to that process (S7).
[0102] Thereafter, the data access control unit 23 judges whether or not the processing of steps S4 to S7 has been completed for all factories identified in step S2 (S8). If the data access control unit 23 obtains a negative result in this judgment, it returns to step S3, and thereafter repeats the processing of steps S3 to S8 while sequentially switching the factory selected in step S3 to other applicable factories for which step S4 and subsequent steps have not been processed.
[0103] Then, when the data access control unit 23 has obtained the process results in step S8 by completing the acquisition of information regarding the "parts" and "finished products" in FIG. 1(A) in the final process of each product manufactured in each factory using the suspect lot of suspect raw materials for all factories identified in step S2, it displays the information acquired in step S7 up to that point in the estimation result display area 33 (FIG. 10) of the first condition setting / result display screen 30 (FIG. 10), and then terminates the trace forward process (S9).
[0104] (4-2) Traceback processing 13 shows the procedure of the traceback process executed by the data access control unit 23. This traceback process is started when the client 14 notifies the data access control unit 23 via the display unit 24 of the estimation device 15 (FIG. 3) that the ingredient button 66 in the ingredient button display area 52 has been clicked after the search conditions have been set in the search condition setting area 51 of the second condition setting / result display screen 50 (FIG. 11).
[0105] When the data access control unit 23 starts this traceback process, it first accepts (S10) the product type, factory identification code, manufacturing date, and manufacturing time of the target product (the product in which a defect has been discovered) that have been set as search conditions on the second condition setting / result display screen 50, which are provided from the client 14 via the display unit 24 of the estimation device 15. Note that in the case of an individual factory model of a manufacturing base with high information granularity, it is also possible to accept a serial number.
[0106] Next, the data access control unit 23 refers to the integrated 4M information 25A (FIG. 6) linked to the last process of the all-factory common data model and the 4M information 25B (FIG. 7) linked to the last process of each individual factory data model, and identifies the last manufacturing record of the target product (S11). This identification is performed by identifying the information of the "finished product" in FIG. 1(A) including information such as the product item, factory identification code, manufacturing date, manufacturing time, and / or serial number received in step S10 from the integrated 4M information and the 4M information.
[0107] Next, the data access control unit 23 identifies the factory that has the manufacturing history identified in step S11, and identifies the manufacturing history for each process related to the manufacturing history by tracing the integrated data model (all-factory common data model or individual factory data model) associated with that factory back in the manufacturing process of the target product, starting from the manufacturing history identified in step S11 (S12).
[0108] This process is performed by focusing on the fact that the input parts of the subsequent process are output parts of the preceding process. Specifically, the data access control unit 23 identifies the "parts" information in Fig. 1(A) that corresponds to the manufacturing performance identified in step S11 (corresponding to the "finished product" information in Fig. 1(A)), identifies the "finished product" information that includes the "parts" information from the integrated 4M information 25A or 4M information 25B of the previous process, and further identifies the "parts" information in Fig. 1(A) that corresponds to that information, and repeats the process.
[0109] Then, when the data access control unit 23 traces back to the first process by the above process, it identifies the raw materials and their lots of the target product based on the "parts" information of that process (S13), displays the identified raw materials and their lot information in the estimation result display area 53 (Fig. 11) of the second condition setting / result display screen 50 (Fig. 11) (S14), and then terminates this traceback process. Note that in the case of a factory in the entire factory data model, the manufacturing date and time, etc. are input for tracing, so that the questionable range is identified (lot 1 to lot 3, etc.), whereas in the case of a factory in the individual factory data model, serial numbers are input for tracing, so that the raw materials and their lot information can be pinpointed.
[0110] (5) Effects of this embodiment As described above, in the estimation system 10 of this embodiment, for each process carried out to manufacture a product in each factory, a business data model 1 that models the respective process is defined, and an integrated data model 2 is defined by associating these business data models 1 with the order of the manufacturing processes. Based on information about a raw material in which a doubt has been discovered, the integrated data model 2 is used to estimate the range of products manufactured using that raw material, or the raw materials of a product in which a defect has been discovered.
[0111] Therefore, the estimation system 10 can realize tracing for multiple manufacturing sites with different information granularity according to the information management level of the manufacturing site. It can quickly estimate the impact range of a suspected raw material or the raw material of a product with a defect, thereby reducing the loss cost due to the production of defective products and the risk of loss due to the recall of defective products.
[0112] (6) Other embodiments In the above embodiment, the same product is manufactured using the same raw materials at all factories. However, the present invention is not limited to this. The present invention can also be applied to cases where the same raw materials are used to manufacture different products, and when a defect in the raw materials is discovered, the extent of the impact can be estimated.
[0113] In the above-described embodiment, the data model definition unit 22, the data access control unit 23, and the display unit 24 are arranged in the estimation device 15, which is a single computer device. However, the present invention is not limited to this, and the data model definition unit 22, the data access control unit 23, and the display unit 24 may be arranged in a distributed manner in multiple computer devices that constitute a distributed computing system.
[0114] Furthermore, in the above embodiment, the data extraction device 13 is provided separately from the estimation device 15. However, the present invention is not limited to this. A functional unit having the same function as the data extraction device 13 may be provided in the estimation device 15, and the data extraction device 13 may be omitted. [Industrial Applicability]
[0115] The present invention can be widely applied to estimation systems of various configurations that estimate the extent of the impact when a defect is discovered in raw materials that are commonly used in the production of products at multiple manufacturing sites, and / or that estimate the raw materials when a product defect is discovered. [Explanation of symbols]
[0116] 1...business data model, 2...integrated data model, 10...estimation system, 11...manufacturing system / equipment, 12...overall management device, 13...data extraction device, 14...client, 15...estimation device, 16...common management master information, 17...common system information, 18...master data storage section, 19...master data, 20...transaction data storage section, 21...transaction data, 22...data model definition section, 23...data access control section, 24...display section, 25A...integrated 4M information, 25B...4M information, 26...data model storage section, 30...first condition setting / result display screen, 50...second condition setting / result display screen.
Claims
1. In an estimation system for estimating the extent of the impact when a doubt is discovered about a raw material used in the manufacture of a product at multiple manufacturing sites, and / or estimating the raw material when a product defect is discovered, A data collection unit that collects on-site data of each process performed at each of the manufacturing bases; a data model definition unit that defines a first data model that models each of the processes performed at the manufacturing site based on the collected on-site data, and defines a second data model that models the manufacturing process of the product by sequentially associating the first data model for each of the processes with the order of the manufacturing process of the product; a data access control unit that uses the second data model to estimate the range of the product manufactured using the raw material in question, or estimates the raw material of the product in which a defect has been discovered, based on information about the raw material in question; An estimation system comprising:
2. The data model definition unit The first data model of each of the processes, in which the on-site data is managed in common among the plurality of manufacturing bases, is sequentially associated with the order of the manufacturing processes of the product, and the on-site data of each of the manufacturing bases is collectively linked to each of the processes, thereby defining a second data model that models the manufacturing processes of the product. The estimation system according to claim 1 .
3. The data model definition unit For the manufacturing bases that manage the on-site data of the processes other than the processes for which the on-site data is managed in common among the multiple manufacturing bases, the first data models that model the processes for which the on-site data is managed at the manufacturing bases are sequentially associated in the order of the manufacturing processes, and the second data model is defined by linking the on-site data of the manufacturing base to each of the processes. The estimation system according to claim 1 .
4. The data access control unit Based on information about the product in which a defect has been discovered, the second data model is traced in a reverse direction to the flow of the manufacturing process to estimate the raw materials of the product.
4. The estimation system according to claim 2 or 3.
5. The data access control unit Based on the information on the raw material for which doubt has been discovered, the second data model is traced in a direction along the flow of the manufacturing process to estimate the range of the products manufactured using the raw material.
4. The estimation system according to claim 2 or 3.
6. The data model definition unit The second data model is defined by sequentially associating the first data model with the order of the manufacturing process of the product so that the finished product and the lot of the finished product in the preceding process match the input part and the lot of the input part in the succeeding process. The estimation system according to claim 1 .
7. The system further includes a display unit that displays the extent of the influence of the suspected raw material or the raw material of the product in which a defect has been discovered, which is estimated by the data access control unit. The estimation system according to claim 1 .
8. An estimation method executed in an estimation system for estimating an impact extent when a doubt is found about a raw material used in the manufacture of a product at a plurality of manufacturing sites, and / or estimating a raw material when a defect in the product is found, comprising: A first step of collecting on-site data of each process performed at each of the manufacturing sites; a second step of defining a first data model that models each of the processes performed at the manufacturing site based on the collected on-site data, and defining a second data model that models the manufacturing process of the product by sequentially associating the first data model for each process with the order of the manufacturing process of the product; a third step of estimating the range of the product manufactured using the raw material or estimating the raw material of the product in which a defect is found, based on information about the raw material in which the defect is found, using the second data model; An estimation method comprising:
9. In the second step, the estimation system The first data model of each of the processes, in which the on-site data is managed in common among the plurality of manufacturing bases, is sequentially associated with the order of the manufacturing processes of the product, and the on-site data of each of the manufacturing bases is collectively linked to each of the processes, thereby defining a second data model that models the manufacturing processes of the product. The method according to claim 8 .
10. In the second step, the estimation system For the manufacturing bases that manage the on-site data of the processes other than the processes for which the on-site data is managed in common among the multiple manufacturing bases, the first data models that model the processes for which the on-site data is managed at the manufacturing bases are sequentially associated in the order of the manufacturing processes, and the second data model is defined by linking the on-site data of the manufacturing base to each of the processes. The method according to claim 8 .
11. In the third step, the estimation system Based on information about the product in which a defect has been discovered, the second data model is traced in a reverse direction to the flow of the manufacturing process to estimate the raw materials of the product. The estimation method according to claim 9 or 10.
12. In the third step, the estimation system Based on the information on the raw material for which doubt has been discovered, the second data model is traced in a direction along the flow of the manufacturing process to estimate the range of the products manufactured using the raw material. The estimation method according to claim 9 or 10.
13. In the second step, the estimation system The second data model is defined by sequentially associating the first data model with the order of the manufacturing process of the product so that the finished product and the lot of the finished product in the preceding process match the input part and the lot of the input part in the succeeding process. The method according to claim 8 .
14. The method further includes a fourth step of displaying the extent of the influence of the suspected raw material estimated in the third step, or the raw material of the product in which a defect has been discovered. The method according to claim 8 .
Citation Information
Patent Citations
Device and system for managing manufacturing history
JP2006172014A
Information collection display system, information collection method, and information display method
JP2019153051A
Processing device, processing method, and program
WO2021005747A1
