Planning auxiliary system and method thereof

Abstract

The present invention provides a planning support system and method thereof that automatically generate or update highly reliable combination master data in production planning operations without consuming a large amount of time, enabling highly practical planning. The planning support system is implemented by a computer: a manufacturing sequence generation unit that extracts equipment / product combinations representing the relationship between the equipment used and the products manufactured using the equipment from manufacturing performance records and generates manufacturing sequence data for these equipment / product combinations; and a judgment unit that calculates sequence data of statistically processed information regarding the degree of participation of the equipment / product combination in manufacturing and, based on this statistically processed sequence data, makes a judgment regarding the generation of combination master data for these equipment / product combinations.

Description

Technical Field

[0001] The present invention relates to a plan making assistance system and method thereof, and in particular to a plan making assistance in production planning business. Background Art

[0002] In the production planning of products and parts, it is important to reflect the actual status of production activities in the plan and improve the accuracy of the plan. For example, Patent Document 1 discloses a production planning system that, to improve the accuracy of the overall factory production plan, includes a unit that compares performance data collected from the manufacturing line with the values ​​of each element operation that constitutes the setting parameters, and then corrects the setting values ​​and sets highly accurate predicted setting values.

[0003] Prior art literature

[0004] Patent Literature

[0005] Patent Document 1: Japanese Patent Application Laid-Open No. 2005-157819 Summary of the Invention

[0006] Problems to be solved by the invention

[0007] In production planning, planning managers draw up plans by referring to order information and master data representing the relationships between equipment and manufactured products (equipment / product combination master data). Equipment / product combination master data changes due to equipment upgrades and other factors, requiring regular maintenance. Using incomplete master data for production planning can prevent the use of equipment that would otherwise be capable, potentially negatively impacting planning results. Furthermore, as the number of combinations in combination master data increases, manually generating and updating this data requires significant time and effort. Therefore, to reduce the time required to generate and update combination master data, there is a demand for automated generation and updating of combination master data.

[0008] Furthermore, the technology described in Patent Document 1 may allow for frequent update of setting parameters such as equipment production capacity by comparing performance with the performance data and updating the parameters. However, since the equipment / product combination master data, which includes the products that the equipment can produce, is updated less frequently due to order information and maintenance updates, there is a possibility that the combination master data will not be updated.

[0009] The present invention aims to automatically generate or update highly reliable combination master data in production planning work without consuming a lot of time, thereby enabling highly practical planning.

[0010] Technical solutions to problems

[0011] Regarding the present invention, a preferred example thereof is constituted as a planning assistance system, which is characterized in that it is implemented by a computer: a manufacturing timing generation unit, which extracts equipment / variety combinations that represent the relationship between the equipment used and the varieties manufactured by the equipment from manufacturing performance, and generates manufacturing timing data for the equipment / variety combination; and a judgment unit, which calculates timing data of statistical processing information on the degree to which the equipment / variety combination participates in manufacturing, and judges the generation of combination master data on the equipment / variety combination based on the timing data of the statistical processing information.

[0012] Furthermore, regarding the present invention, a preferred example is taken as a planning assistance system, which is characterized by being implemented by a computer: a manufacturing timing generation unit, which extracts equipment / variety combinations that represent the relationship between the equipment used and the varieties manufactured by the equipment from manufacturing performance, and generates manufacturing timing data for the equipment / variety combination; and an update judgment unit, which calculates timing data of statistical processing information on the degree to which the equipment / variety combination participates in manufacturing, and based on the timing data of the statistical processing information, judges whether to delete existing equipment / variety from the combination master data or continue to maintain the existing equipment / variety, or whether to register equipment / variety related to new varieties to the combination master data.

[0013] The present invention can also be regarded as a planning support method and a program thereof in the above-mentioned planning support system.

[0014] Effects of the Invention

[0015] According to the present invention, in production planning work, highly reliable combination master data can be automatically generated or updated without consuming a lot of time, thereby enabling highly practical planning. BRIEF DESCRIPTION OF THE DRAWINGS

[0016] Figure 1 This is a diagram showing an example of the planning support system in the first embodiment.

[0017] Figure 2 This is a diagram showing an example of the manufacturing performance DB 102 .

[0018] Figure 3 This is a diagram showing an example of the order history DB 103 .

[0019] Figure 4 This is a diagram showing an example of the configuration of the device / item combination extraction processing unit 1011 .

[0020] Figure 5 This diagram shows an example of a device / item combination.

[0021] Figure 6 This is a diagram showing an example of the configuration of the equipment / item manufacturing sequence generating unit 1012 .

[0022] Figure 7 This is a diagram showing an example of manufacturing time series data of a combination of equipment / items in the shortest manufacturing time length in manufacturing performance.

[0023] Figure 8 This is a diagram showing an example of the configuration of the registration determination unit 1013 for the combination master data.

[0024] Figure 9 This is a graph showing an example of the delivery date adherence rate of each item during the target period in the order history.

[0025] Figure 10 This is a diagram showing an example of the hardware configuration of a PC.

[0026] Figure 11 This is a diagram showing an example of the processing flow of the planning support system in the first embodiment.

[0027] Figure 12 This is a diagram showing an example of a process flow for generating equipment / item combination master data.

[0028] Figure 13 This is a diagram showing an example of the equipment / item combination master data 107 .

[0029] Figure 14 This diagram shows an example of an unregistered device / item combination.

[0030] Figure 15A This is a diagram showing an example of a display screen of a terminal.

[0031] Figure 15B This is a diagram showing an example of a display screen of a terminal.

[0032] Figure 15C This is a diagram showing an example of a display screen of a terminal.

[0033] Figure 16 This is a diagram showing an example of a planning support system in the second embodiment.

[0034] Figure 17 This is a diagram showing an example of the item attribute DB 110 .

[0035] Figure 18 This is a diagram showing an example of the configuration of the master data update determination unit 1613 .

[0036] Figure 19 This is a diagram showing an example of the structure of the new product registration determination function 1803.

[0037] Figure 20 This is a diagram showing an example of the processing flow of the planning support system in the second embodiment.

[0038] Figure 21 This is a diagram showing an example of the processing flow for updating the equipment / item combination master data.

[0039] Figure 22 This diagram shows an example of the compatibility of a device / item combination with a new item.

[0040] Figure 23 This is a diagram showing an example of a deleted device / item combination.

[0041] Figure 24A This is a diagram showing an example of a display screen of a terminal.

[0042] Figure 24B This is a diagram showing an example of a display screen of a terminal.

[0043] Figure 24C This is a diagram showing an example of a display screen of a terminal. DETAILED DESCRIPTION

[0044] Preferred embodiments of the present invention will be described with reference to the accompanying drawings.

[0045] [Example 1]

[0046] [System Structure]

[0047] Figure 1 This section shows an example of the functional structure of a planning support system.

[0048] Figure 1 In the present invention, the planning support system 1 is composed of a combination master data generation unit 101, a planning unit 108, a manufacturing performance DB (database) 102, an order history DB 103, a planning information DB 104, a combination master data DB 1071, a planning result DB 1091, and a terminal 105 used by the user. The planning support system 1 is constructed using a computer, and the main functional units 101 and 108 are realized by executing programs by the processing unit (CPU) of the computer. In addition, regarding the hardware structure of the computer, refer to Figure 10 The terminal 105 includes a display unit, an input unit, and an information communication unit.

[0049] The combination master data generation unit 101 includes a device / item combination extraction processing unit 1011, a device / item manufacturing sequence generation unit 1012, and a master data registration judgment unit 1013. Based on the information in the manufacturing performance DB 102 and the order history DB 103, the combination master data 107 is generated. The combination master data 107 is stored in the combination master data DB 1071. In addition, for each component 1011 to 1013 of the combination master data generation unit 101, refer to Figures 4 to 8Described in the following text.

[0050] The plan preparation unit 108 includes a data input unit 1081, a plan preparation calculation unit 1082, and a plan result output unit 1083. It prepares a plan using the order information 106 and the combination master data 107 and outputs a plan result 109. The plan result 109 is stored in the plan result DB 1091 and displayed on the display unit of the terminal 105. For an example of the display screen of the display unit, refer to Figures 15A to 15C Described in the following text.

[0051] Manufacturing performance DB102 Figure 2 As shown, information such as the types, number of pieces, manufacturing date, and manufacturing time of products manufactured in the equipment in the past is stored. Figure 2 The items are those required to generate the combined master data, but other items related to the operating status of the equipment may also be included.

[0052] Order history DB103 Figure 3 As shown, order information such as order number, type, delivery date, demand quantity (number of required items) etc. is stored corresponding to the order. Figure 3 , and may also include other items about the order.

[0053] The planning information DB 104 stores order information 106 and factory operation information.

[0054] The order information 106 includes information such as order number, item, delivery date, required quantity (number of items required), etc. The combination master data 107 is equipment / item combination data indicating the items that can be manufactured by the equipment.

[0055] Combined master data DB1071 Figure 13 As shown, the combination of registered equipment and varieties.

[0056] The plan result DB 1091 registers the plan result 109 .

[0057] Figure 4 This section shows the configuration of the device / item combination extraction processing unit 1011.

[0058] The equipment / product combination extraction processing unit 1011 includes a manufacturing performance reading function 401, a equipment / product combination generation function 402, and an equipment / product combination storage function 403. The manufacturing performance reading function 401 reads the manufacturing performance DB 102. The equipment / product combination generation function 402 lists the equipment and product combinations in the manufacturing performance and calculates and generates the manufacturing capacity based on the number of manufactured units and operating time.

[0059] exist Figure 5An example of a device / product combination generated by the device / product combination generation function 402 is shown in FIG. For example, the capacity of producing product A by device "01" is 10 pieces / hour. Here, Figure 5 The example shows the equipment / variety combination in tree form, but it can also be shown in table form.

[0060] The device / item combination saving function 403 saves the extracted device / item combination in the combination master data DB 1071 .

[0061] Figure 6 This section shows the configuration of the device / item manufacturing sequence generator 1012.

[0062] The equipment / item manufacturing sequence generation unit 1012 includes a function 601 for extracting target equipment / item combinations from manufacturing performance, a function 602 for generating a manufacturing sequence for each minimum manufacturing time, and a function 603 for storing the manufacturing sequence for each equipment / item combination. The function 601 for extracting target equipment / item combinations extracts the manufacturing performance of each equipment / item combination. The function 602 for generating a manufacturing sequence chronologically sorts the number of units manufactured by the minimum manufacturing time within the manufacturing performance. The function 603 for storing the manufacturing sequence for each equipment / item combination stores the manufacturing sequence in the combination master data DB 1071.

[0063] Figure 7 An example of manufacturing time series data of a device / item combination in manufacturing performance is shown in FIG.

[0064] Time series data is data that divides manufacturing time (e.g., the time from the past to the present) into specified units (e.g., three-day units) and calculates the production quantity (e.g., number of units produced) for each specified unit. The example shown shows time series data for the number of units produced per day (the shortest manufacturing time) for the combination of equipment 01 and product A. If there are no orders for that product, the manufacturing time may be interrupted. Therefore, manufacturing performance may be a repetition of manufacturing time series data and interruptions for each equipment / product combination.

[0065] Figure 8 The configuration of the registration determination unit 1013 for the combination master data is shown.

[0066] The registration judgment unit 1013 for combination master data has a function 801 for calculating the delivery compliance rate of the product based on the order history and manufacturing performance, a function 802 for judging the registration of the combination master data, and a function 803 for saving the equipment / product combination master data. The function 801 for calculating the delivery compliance rate of the product reads the order history 103 and the manufacturing performance 102, and calculates the product compliance rate by comparing the product, delivery date, and required quantity in the order history with the product, manufacturing date, and manufacturing quantity in the manufacturing performance. The function 802 for judging whether to register / not register the combination master data is a function for judging whether to register / not register the combination master data using the manufacturing sequence and delivery compliance rate of the equipment / product combination. The function 803 for saving the equipment / product combination master data saves the registration / non-registration information of the equipment / product combination in the combination master data DB1071. In Figure 13 An example of the registered equipment / product combination master data 107 is shown in FIG. Figure 14 Examples of unregistered device / item combinations are shown in FIG.

[0067] The reason for storing not only registered information for device / product combinations but also unregistered information is to allow users to confirm device / product combinations that have been determined to be unregistered. It is possible to modify a device / product combination after confirmation to allow registration. Furthermore, unregistered information for a device / product combination can be stored separately from registered information as unregistered information in a separate database (not shown).

[0068] exist Figure 9 An example of the delivery date compliance rate for each product during the target period in the order history is shown in FIG. The example shown in the figure shows the change in the delivery date compliance rate of product B in the shortest manufacturing time length of every three days from the past to the present.

[0069] [Hardware structure]

[0070] As a computer for realizing the planning support system 1 , an information processing device such as a server or a personal computer (PC) can be used.

[0071] Figure 10 The hardware configuration of a PC is shown as an example of an information processing device. Figure 10 In the figure, 1001 is a CPU, 1002 is a memory, 1003 is a hard disk (HD), 1004 is a network interface (I / F), 1005 is an input unit, 1006 is a display unit, and 1007 is an interface.

[0072] CPU 1001 is a central processing unit (Central Processing Unit) that executes programs recorded in memory 1002 or transferred to memory 1002 in advance from hard disk 1003. In addition, the program can also be imported from a removable storage medium that can be used by the PC as needed. In this case, the device for reading the storage medium is connected to interface 1007. In addition, the program can also be imported into the PC via a communication medium (communication line or carrier wave on the communication line) using network interface 1004 as needed.

[0073] The memory 1002 temporarily stores programs and data. The hard disk 1003 is a storage device such as a magnetic disk or a nonvolatile memory that stores programs and data.

[0074] The network interface 1004 connects the PC to external devices. The input unit 1005 is a keyboard and mouse, etc., which are operated by the operator to input commands and data to the PC. The display unit 1006 displays data and processing results. The interface 1007 connects to devices within the PC.

[0075] [Processing Action]

[0076] refer to Figure 11 , the planning process performed by the planning support system is explained.

[0077] In step 1101, the combination master data generation unit 101 reads the manufacturing performance DB 102 and the order history DB 103 to generate combination master data 107 consisting of equipment / item combinations. The generated combination master data 107 (master data registration information) and equipment / item combinations determined to be unregistered (unregistered information) are then transmitted to the terminal 105.

[0078] In step 1102, the terminal 105 displays the order information 106 of the planned object from the planning information DB 104 and the generated combination master data 107 on the display unit, and accepts the user's confirmation input. Figure 15A 、 15B An example of the display screen of the terminal 105 is shown in FIG. Figure 12 Describe in detail.

[0079] In step 1103 , the plan formulation unit 108 sets decision variables, constraints, and evaluation functions based on the order information 106 and the combination master data 107 , and formulates a plan using an optimization algorithm to satisfy the constraints and optimize the evaluation function.

[0080] Here, as an example of generating the decision variables, constraints, and evaluation functions, there is the following setting method.

[0081] Set the index of the decision variable:

[0082] t: represents the index of the production day. The range of t is set from 1 to 30 in the program of the planning support system, for example, if it represents the production days of one month.

[0083] i: represents the index of the product. For example, if i represents all 100 products in the factory, it is set from 1 to 100 in the program of the planning support system.

[0084] m: Indicates the index of the device. For example, if m represents all 10 devices in the factory, it is set from 1 to 10 in the program of the planning support system.

[0085] Set the decision variable:

[0086] x tim : A variable representing the production volume of product i using equipment m on production day t. Set x in the program of the planning support system. tim .

[0087] Setting parameters:

[0088] B mi : Parameter read from the combination master data 107, indicating whether item i can be manufactured using equipment m.

[0089] C mi : Parameters read from the combination master data 107, indicating the manufacturing capability of item i that can be manufactured by equipment m.

[0090] D ti : Parameters read from the order information 106, indicating the demand quantity of item i on production day t.

[0091] w tim : A parameter that represents the cost of producing item i using equipment m on production day t. Set w in the program of the planning support system. tim . Or it can be read from external data.

[0092] Constraints:

[0093] [Mathematical formula 1]

[0094]

[0095] Before T days, the number of pieces produced for item i must exceed the number of pieces required D ti .

[0096] Evaluation function:

[0097] [Mathematical formula 2]

[0098]

[0099] Function for calculating production costs. Set the evaluation function in the program of the planning support system.

[0100] For the algorithm for generating decision variables, constraints, evaluation functions, and plan formulation, generally available mathematical programming software can be used. In the present embodiment, a search method such as backtracking is used. In addition, the backtracking method is one of the general solution (plan candidate) search algorithms. When a solution is obtained by the steps, the possible steps are tried in sequence. When it is found that the solution has not been obtained, the solution is saved as the solution. When it is found that the solution has not been obtained, the previous state is returned and other steps are tried. The backtracking search method can be used to search for multiple solutions (plan candidates). Multiple plan candidates are evaluated using an evaluation function, and the plan candidate with the highest evaluation is adopted. The CPU of the PC used in the plan formulation support system executes the search algorithm to formulate a plan.

[0101] In step 1104, the terminal 105 displays the plan result 109 output from the plan preparation unit 108 on the display unit and accepts the user's confirmation input. Figure 15C An example of a display screen showing a plan result is shown in FIG. For example, the user confirms the plan result and operates button 1512 ( Figure 15C ), the order information 106 and the planning result 109 are stored in the planning result DB 1091.

[0102] Figure 12 This is a flowchart showing a detailed example of the device / item combination master data generation process S1101 - S1102 executed by the combination master data generation unit 101 .

[0103] In step 1201, a device / item combination is generated based on the manufacturing performance DB 102. The device / item combination is extracted using the manufacturing performance of a certain period, and the manufacturing capacity of the device / item is calculated. Figure 5 An example of a device / product combination is shown in FIG. 1 , but the manufacturing capacity can also be shown on a daily basis or in a table or other form.

[0104] In step 1202, the manufacturing time series data of the equipment / item combination is generated. The manufacturing performance DB 102 is used to generate the manufacturing time series data of the equipment / item combination with the shortest manufacturing time length of 1 day, etc., based on the equipment / item generated in step 1201. Figure 7 shows an example of manufacturing time series data of equipment / item combination, but a table format or the like may also be used.

[0105] In step 1203, it is determined whether the equipment / product combination has been manufactured recently. That is, it is determined whether the equipment / product combination has been manufactured in the most recent time length (object time length) including the current time length traced back from the current moment of this system 1. In the case where it is determined that the equipment / product combination has been manufactured recently, the equipment / product combination is registered in the combination master data 107 using step 1205 (S1205). In addition, the unit of the shortest manufacturing time length that constitutes the object time length can be 1 day, or it can be a time length such as 1 week. The shortest manufacturing time length is pre-set in this system 1.

[0106] In step 1204, if it is determined in step 1203 that the equipment / product combination has not been manufactured recently, the delivery date compliance rate of the product in the non-manufacturing time length of the equipment / product (composed of one or more shortest manufacturing time lengths in the target time length) and the number of orders for the product are calculated based on the manufacturing performance DB102 and the order history DB103. The delivery date compliance rate is a ratio indicating the degree to which the delivery date of the product is complied with in each shortest manufacturing time length. Based on the order history, Figure 9 An example of the transition (time series) of the delivery date adherence rate of item B within the target duration is shown in FIG. In addition, the time series data of the delivery date adherence rate generally changes when the item changes.

[0107] In step 1206, the registration judgment is made based on the delivery compliance rate of the variety calculated in step 1204. That is, in the non-manufacturing time length of the equipment / variety, if there is a time length (one or more shortest manufacturing time lengths) in which the delivery compliance rate of the variety is less than a predetermined certain value (the delivery compliance rate is lower than a certain value), the equipment / variety is not registered in the combination master data 107 (set to non-registration) (step 1207). The equipment / variety combination judged to be non-registered is temporarily stored in the DB (not shown). For example, Figure 15B In the example of the screen, in the manufacturing sequence of combination 03 / D, there is one shortest manufacturing duration with a 100% delivery compliance rate among the non-manufacturing durations, but in this case, combination 03 / D is also set to not be registered. This is because it can be determined that even if combination 03 / D is not used, other equipment can still meet the delivery date when manufacturing item D, so it is considered that there is no impact even if combination 03 / D is not registered in the combination master data. In addition, in this case, the operation of equipment 01 can meet the delivery date of item D, so Figure 15A As shown in the screen example of , the combination 01 / D is registered in the combination master data 107.

[0108] On the other hand, in step 1206, if the number of units required for the equipment / item does not exist in the order history DB 103 for the non-manufacturing period for the equipment / item, the equipment / item is registered in the combination master data in step 1205. This is because it is assumed that the reason for the non-manufacturing of the item is that there is no order for it, and there is no problem even if the equipment / item is registered in the combination master data.

[0109] [Example of display screen]

[0110] Figures 15A to 15C An example of a display screen of the terminal 105 is shown.

[0111] Figure 15A The display screen shown is displayed in steps S1102 and S1205. This screen includes the equipment / product combination master data, the manufacturing time series data of the combination in the manufacturing performance, the delivery date compliance rate of the product in the target duration in the order history, and the master data output button 1511. When a certain equipment / product combination in the equipment / product combination master data is selected, the manufacturing time series data corresponding to the selected equipment / product combination and the delivery date compliance rate graph of the product are displayed ( Figure 7 、 Figure 9 (See the corresponding figure.) When the user presses the master data output button 1511, the data is registered in the device / product combination master data. Alternatively, a correction button may be provided on the display screen, and by pressing the correction button, a device / product combination may be corrected, with the correction result then being registered in the device / product combination master data.

[0112] Figure 15B The display screen shown is displayed in steps S1102 and S1205. This screen includes the display of the equipment / product combination set as unregistered, the manufacturing time series data of the combination in the manufacturing performance, the delivery date compliance rate of the product in the target duration in the order history, and a confirmation button 1512. Figure 15A Similarly, when you select a device / product combination in the device / product combination master data, the manufacturing time series data corresponding to the selected device / product combination and the delivery date compliance rate graph of the product are displayed ( Figure 7 、 Figure 9 When the user presses the confirmation button 1512, the device / product combination is not registered and is temporarily stored in the DB (not shown).

[0113] In addition, a correction button can be set on the display screen. By pressing the correction button, a certain device / product combination can be corrected or deleted. Figure 15A, and are registered in the combination master data. For example, if a device is not in use due to repairs, for reasons other than manufacturing, and it is expected that the delivery date compliance rate for this device / product combination will improve after the repair, the device / product combination can be removed from the registration list and corrected by clicking the Correct button.

[0114] Figure 15C The display screen shown includes order information, a display of the plan results, and a plan output button 1513. When the user confirms the plan results and presses the plan output button 1513, the plan results are finalized, and the order information 106 and plan results 109 are stored in the plan result DB 1091. The plan results are associated with the equipment ID, and the production volume (number of units manufactured) of each item for one month is registered, for example.

[0115] [Example 2]

[0116] The second embodiment discloses an example of updating processing of the registered equipment / item combination master data in the planning support system.

[0117] [System Structure]

[0118] Figure 16 This section shows a configuration example of a planning support system.

[0119] The main difference from the configuration of the first embodiment is that a combination master data updating unit 161 is provided in place of the combination master data generating unit 101 and a product attribute DB 162 is added.

[0120] The combination master data update unit 161 includes a device / item combination extraction processing unit 1611 , a device / item manufacturing sequence generation unit 1612 , and a combination master data update judgment unit 1613 , and reads the manufacturing performance DB 102 , order history DB 103 , and item attribute DB 162 to update the combination master data 107 .

[0121] Variety attributes DB162 such as Figure 17 As shown, for each product, the attribute items of the product such as size, material, and manufacturing temperature are registered.

[0122] In this embodiment, updating refers to deleting or maintaining existing equipment / variety from the combination master data, and registering new equipment / variety in the combination master data. The former uses the calculation of the delivery date compliance rate of the variety, referring to Figure 18 The latter is calculated based on the compatibility associated with the new variety, see Figure 19 .

[0123] Figure 18 The structure of the combined master data update determination unit 1613 is shown.

[0124] The combination master data update judgment unit 1613 has a function 1801 for calculating the delivery compliance rate of a product based on order history and manufacturing performance, a function 1802 for judging the update of the combination master data based on the manufacturing timing data and delivery compliance rate of the equipment / product combination, a registration judgment function 1803 for a new product, and a function 1804 for saving the equipment / product combination master data. The function 1801 for calculating the delivery compliance rate of a product reads the order history 103 and the manufacturing performance 102, compares the product, delivery date, and number of required pieces in the order history with the product, manufacturing date, and number of manufactured pieces in the manufacturing performance, and calculates the delivery compliance rate of the product. The delivery compliance rate of the product is compared with the delivery compliance rate of the product. Figure 9 The example shown is the same. The combination master data update determination function 1802 uses the manufacturing sequence and delivery date compliance rate of the equipment / product combination to determine whether to maintain or delete the combination master data. The new product registration determination function 1803 determines which equipment should manufacture the new product if the product exists in the order information 107 but not in the combination master data 107 or the manufacturing performance DB 102. The equipment / product combination master data storage function 1804 updates the combination master data 107 and stores it in the combination master data DB 1071.

[0125] Figure 19 This figure shows the structure of the new product registration determination function 1803.

[0126] The new product registration determination function 1803 includes a device / product compatibility calculation function 1901 and a new product registration function 1902. The device / product compatibility calculation function 1901 reads product attributes and the weights of the corresponding costs of the devices corresponding to the product attributes from the product attribute DB 162 and calculates the compatibility of the devices / products corresponding to the new product. The new product registration function 1902 registers the new product in the product attribute DB 162 for devices / products with good compatibility.

[0127] [Processing Action]

[0128] Figure 20 An example of the planning process executed by the planning support system is shown.

[0129] In step 2001 , the order information 106 is read from the planning information DB 104 , and the combination master data 107 is read from the combination master data DB 1071 .

[0130] In step 2002 , the combination master data update unit 161 reads the manufacturing performance DB 102 and the order information history DB 103 and updates the combination master data 107 .

[0131] In step 2003, the terminal 105 displays a screen including the order information 106 of the planning target from the planning information DB 104 and the generated combination master data 107 on the display unit, and accepts input from the user. The combination master data 107 screen is displayed on the terminal 105. Figure 24A An example of a display screen is shown in FIG.

[0132] In step 2004, the plan formulation unit 108 sets decision variables, constraints, and evaluation functions based on the order information 106 and the combination master data 107, and formulates a plan by using an optimization algorithm to satisfy the constraints and optimize the evaluation function.

[0133] In step 2005, the terminal 105 displays a screen including the plan result 109 obtained by the plan preparation unit 108 on the display unit, and accepts input from the user. Figure 24C An example of a display screen of the planning result 109 is shown in FIG.

[0134] [Updating of equipment / product combination master data]

[0135] Figure 21 An example of the updating process of the device / item combination master data executed by the combination master data updating unit 101 is shown.

[0136] In step 2101, it is determined whether the item in the order information 106 is included in the combination master data 107 and the manufacturing performance DB 102. If an item not included in the manufacturing performance exists, the item is identified as a new item X (S2101: Yes).

[0137] On the other hand, if the result of the judgment in step 2101 is that the product is not a new product (S2101: No), the process of whether to delete the existing equipment / product from the combination master data 107 is carried out. Specifically, in step 2102, the non-manufacturing time length in the time series data of the existing equipment / product is calculated with reference to the manufacturing performance DB 102. Furthermore, the delivery date compliance rate of the target time length of the product is calculated with reference to the order history DB 103. If the result of the calculation in step 2102 is that the delivery date compliance rate of the target time length of the product is lower than a certain value, the equipment / product is deleted from the combination master data 107 (S21041). On the other hand, if the delivery date compliance rate of the non-manufacturing time length of the product is higher than a certain value, the equipment / product is retained in the combination master data 107 (not deleted) (S21042).

[0138] Figure 23 The list of equipment / product combinations that are determined to be deleted is displayed. This list is temporarily stored in a DB (not shown). The screen of the list determined to be deleted is displayed on the terminal 105. Figure 24B An example of a display screen is shown in FIG.

[0139] If step 2101 determines that a new product X exists, step 2103 reads product attribute DB 162 and calculates the compatibility of the device / product. As an example of compatibility calculation, product attributes Fik, such as size, material, and manufacturing temperature, are used. Here, i represents product A, product B, etc., and k represents product attribute 1, product attribute 2, etc. Weights Vmk are set for the corresponding device's response costs. m represents device 01, device 02, etc. Equation 3 is used to calculate the compatibility of the device / product with the new product.

[0140] Compatibility of equipment / variety with new variety X:

[0141]

Mathematical formula 3

[0142]

[0143] Figure 22 This shows an example of the relationship between the compatibility of the device / product combination and the new product calculated using equation 3. Compatibility is expressed as a compatibility score. This list is temporarily stored in a DB (not shown). The screen of the generated device / product combination list is displayed on the terminal 105. Figure 24A An example of a display screen is shown in FIG.

[0144] In step 2105, the equipment / items with high compatibility scores related to the new item are registered in the combination master data 107. When formulating a production plan, the manufacturing capacity of the equipment / item combination with high compatibility scores is preferably used.

[0145] [Example of display screen]

[0146] Figures 24A to 24C An example of a display screen of the terminal 105 in the second embodiment is shown.

[0147] Figure 24A The display screen shown is displayed in steps S1803 and S2103. This screen includes the display of the equipment / product combination master data including compatibility, the manufacturing sequence data of the combination in the manufacturing performance, the delivery date compliance rate of the product in the target duration in the order history, and the master data output button 2411. When a certain equipment / product combination in the equipment / product combination master data is selected, the manufacturing sequence data corresponding to the selected equipment / product combination and the delivery date compliance rate of the product are displayed ( Figure 7 、 Figure 9When the user presses the master data output button 2411, the data is registered in the device / product combination master data. Alternatively, a correction button may be provided on the display screen, allowing the user to correct each device / product combination by pressing the correction button, and the correction result is registered in the device / product combination master data.

[0148] Figure 24B The screen shown is displayed in steps S2003 and S2104. This screen includes the display of the deleted equipment / product combination, the manufacturing time series data of the combination in the manufacturing performance, the delivery date compliance rate of the product in the target duration in the order history, and a confirmation button 2412. Figure 24A Similarly, when you select a device / product combination in the device / product combination master data, the manufacturing time series data corresponding to the selected device / product combination and the delivery date compliance rate graph of the product are displayed ( Figure 7 、 Figure 9 When the user presses the confirmation button 2412, the deleted device / product combination is temporarily stored in the DB (not shown).

[0149] In addition, a correction button can be set on the display screen. By pressing the correction button, a certain device / product combination can be corrected (eliminated) and excluded from the deletion object. Figure 24A On the screen, continue to register in the combination master data.

[0150] Figure 24C The display screen shown includes the display of order information and planning results, as well as a plan output button 2413. The display screen of planning results may include newly added equipment / product combinations.

[0151] When the user confirms the plan result and presses the plan output button 2413, the plan result is confirmed and the order information 106 and the plan result 109 are saved in the plan result DB 1091. Figure 24C A re-plan button is provided on the display screen, and by pressing the re-plan button, the planning support system is restarted and planning is performed again.

[0152] [Alternatives, Modifications]

[0153] The present invention is not limited to the above-described embodiments and includes various variations. Specifically, the above-described embodiments are provided to facilitate understanding of the present invention and are not intended to necessarily include all of the described structures. Furthermore, portions of the structures of the above-described embodiments may be replaced with other structures, and other structures may be added to the structures of the embodiments. Furthermore, portions of the structures of each embodiment may be added, deleted, or replaced with other structures.

[0154] [Variation 1]

[0155] The planning support system 1 of the first embodiment (mainly the combination master data generating unit 101) may be integrated with the planning support system 1 of the second embodiment (mainly the combination master data updating unit 161). Thus, the planning support system 1 can include the combination master data generating unit 101 and the combination master data updating unit 161.

[0156] [Variation 2]

[0157] In the above embodiments, the delivery compliance rate of the variety in the non-manufacturing time length of the manufacturing time series data is used to determine whether to register the equipment / variety combination in the combination master data (Example 1) and to determine whether to update the equipment / variety combination (Example 2). On the other hand, according to other examples, instead of using the delivery compliance rate of the variety, other statistical processing information may be used. For example, it is also possible to generate time series data of the utilization rate of the equipment / variety combination for the time series data of the manufacturing performance, and determine the generation and update of the combination master data based on the utilization rate. Regarding the utilization rate, it can be considered that Figure 9 The vertical axis shows the utilization rate for each equipment / product combination. The product's delivery date adherence rate or the utilization rate of a equipment / product combination reflects the extent to which that product or equipment / product combination contributes to manufacturing performance. This can be determined using statistically processed information derived from manufacturing performance. Specifically, if the statistically processed information on the length of non-manufacturing time falls below a predetermined value, the equipment / product combination can be deregistered or deleted.

[0158] [Variation 3]

[0159] The computer constituting the planning support system 1 of the above-described embodiments 1 and 2 may also be a cloud computer. In this case, the cloud computer may include all of the functional units constituting the planning support system 1, such as the combined master data generation unit 101, the planning unit 108, and the various databases, or may include only a portion of the functions or databases.

[0160] As another example, the combination master data generating unit 101 and the plan making unit 108 may be implemented as separate computers, and a computer for managing the plurality of DBs may be used. In this case, one or more computers may be implemented as a cloud computer.

[0161] [Variation 4]

[0162] For example, instead of the combination master data DB 1071 , the combination master data 107 may be stored in the planning information DB 104 together with the order information 106 and factory operation information.

[0163] [Variation 5]

[0164] The various structures, functions, processing units, and the like of the above-described embodiments may be partially or entirely implemented in hardware, for example, by designing them into an integrated circuit. Furthermore, the aforementioned structures, functions, and the like may also be implemented in software by having a processor interpret and execute programs that implement the functions. Information such as programs, tables, and files that implement the functions may be stored in a storage device such as a memory, a hard disk, or an SSD (Solid State Drive), or in a recording medium such as an IC card, an SD card, or a DVD.

[0165] In addition, the control lines and information lines in the above embodiment are shown as necessary for explanation, and not all control lines and information lines in the product are shown. In fact, it can be considered that almost all structures are connected to each other.

[0166] Description of Reference Numerals

[0167] 1…Planning support system

[0168] 101…Combination Master Data Generation Department

[0169] 102…Manufacturing Performance DB

[0170] 103…Order History DB

[0171] 104…Planning information DB

[0172] 105…Terminal

[0173] 106…Order Information

[0174] 107…Combined master data, 1071…Combined master data DB

[0175] 108…Planning Department

[0176] 109…Planned results, 1091…Planned results DB

[0177] 161 ...Combination master data update unit 162 ...Product attribute DB

[0178] 401…Manufacturing performance reading function

[0179] 402…Generation function for device / variety combination

[0180] 403...Save function for device / variety combination

[0181] 601…Function to extract target equipment / item combinations from manufacturing performance

[0182] 602… Function for generating a manufacturing sequence with the shortest manufacturing time

[0183] 603…Save function for manufacturing sequence of equipment / product combination

[0184] 801…A function that calculates the delivery date compliance rate of each product based on order history and manufacturing performance

[0185] 802 ... Function to determine whether to register or not register the combination master data

[0186] 803…Function to save equipment / variety combination master data.

Claims

1. A planning support system for formulating a production plan using combination master data consisting of combinations of equipment extracted from a plurality of equipment and varieties extracted from a plurality of varieties by a computer, the planning support system comprising: a manufacturing time series generating unit that extracts, from manufacturing performance records, combinations of equipment / products, which are combinations of used equipment and products manufactured using the equipment, divides the manufacturing time length into predetermined units, and generates, for each predetermined unit, manufacturing time series data that represents the production quantity of the equipment / product combination in a time series; a calculation unit for calculating a delivery date compliance rate of a product representing the equipment / product combination within a prescribed time period; and A judgment unit judges whether the delivery compliance rate of the variety in the non-manufacturing time length of the equipment / variety combination reaches a predetermined certain value based on the manufacturing timing data of the equipment / variety combination and the delivery compliance rate of the variety, and judges whether to register the equipment / variety to the combination master data based on the judgment result.

2. The planning assistance system according to claim 1, wherein: The system further includes a planning section that formulates a plan based on order information including item types and demand quantities and the combination master data.

3. The planning support system according to claim 1, wherein: include: A manufacturing performance DB storing at least information about a plurality of devices used in manufacturing, and information about the types, quantities, and dates of manufacture manufactured using any of the devices; and An order history DB that stores order information, including order type, delivery date, and demand quantity. The determination unit determines the manufacturing time of the equipment / item in the equipment / item combination in the manufacturing time series data, If the result of this determination is that the product was recently manufactured, it is registered in the combination master data. If the result of this judgment is that it is not determined to be recently manufactured, the order information of the variety in the order history DB is compared with the manufacturing performance of the variety in the manufacturing performance DB, and the delivery date compliance rate of the variety is calculated. The manufacturing sequence of the equipment / variety is compared with the delivery date compliance rate of the variety to determine whether it is registered in the combination master data.

4. The planning support system according to claim 1, wherein: include: A manufacturing performance DB storing at least information about a plurality of devices used in manufacturing, and information about the types, quantities, and dates of manufacture manufactured using any of the devices; and An order history DB that stores order information, including order type, delivery date, and demand quantity. The judgment unit divides the order information of any product into the time length traced back from the current start according to the shortest manufacturing time length, and calculates the time series data corresponding to the delivery date compliance rate calculated according to each of the multiple shortest manufacturing time lengths after the division.

5. The planning assistance system according to claim 1, wherein: A terminal connected to the computer is provided, the terminal being capable of displaying a display screen including the contents of the combination master data generated by the generation unit, the manufacturing sequence of the equipment / item included in the combination master data, and the time series data of the delivery date compliance rate of the item.

6. The planning assistance system according to claim 2, wherein: A terminal is provided which is connected to the computer and is capable of displaying a display screen including the planning result generated by the planning unit, the order information, and an output button.

7. The planning assistance system according to claim 1, wherein: The system further includes an update determination unit that determines whether to delete existing equipment / items from the combination master data or to continue to maintain the existing equipment / items, or whether to register equipment / items related to new items in the combination master data based on the time series data of the delivery date compliance rate.

8. The planning assistance system according to claim 7, wherein: A variety attribute DB for registering the attributes of each variety, The update judgment unit uses the manufacturing sequence of the equipment / item and the delivery date compliance rate of the item to make an update judgment on the combination master data, and For new products that are not included in the combination master data and the manufacturing performance, the compatibility between the equipment / product combination and the new product is calculated with reference to the product attribute DB, and the update of the new product is determined based on the compatibility.

9. A planning support system for formulating a production plan using combination master data consisting of combinations of equipment extracted from a plurality of equipment and varieties extracted from a plurality of varieties by a computer, the planning support system comprising: a manufacturing time series generating unit that extracts, from manufacturing performance records, combinations of equipment / products, which are combinations of used equipment and products manufactured using the equipment, divides the manufacturing time length into predetermined units, and generates, for each predetermined unit, manufacturing time series data that represents the production quantity of the equipment / product combination in a time series; a calculation unit for calculating a delivery date compliance rate of a product representing the equipment / product combination within a prescribed time period; and An update judgment unit determines, based on the manufacturing timing data of the equipment / variety combination and the delivery compliance rate of the variety, whether the delivery compliance rate of the variety in the non-manufacturing time length of the equipment / variety combination reaches a predetermined certain value, and based on the judgment result, determines whether to delete the existing equipment / variety from the combination master data about the equipment / variety combination or to continue to maintain the existing equipment / variety, or whether to register the equipment / variety about the new variety into the combination master data.

10. The planning assistance system according to claim 9, wherein: A variety attribute DB is provided, which registers the attributes of each variety. For new products that are not included in the combination master data and the manufacturing performance, the compatibility between the equipment / product combination and the new product is calculated with reference to the product attribute DB, and the update of the new product is determined based on the compatibility.

11. The planning assistance system according to claim 9, wherein: A terminal is connected to the computer, and the terminal is capable of displaying a display screen including the content of the combination master data generated by the generation unit, which includes the compatibility of the equipment / variety combination with the new variety, the manufacturing timing of the equipment / variety included in the combination master data, and the timing data of the delivery date compliance rate of the variety.

12. A plan-making assisting method, wherein a computer uses combined master data consisting of combinations of equipment extracted from a plurality of equipment and varieties extracted from a plurality of varieties to formulate a production plan, the plan-making assisting method comprising: A manufacturing time series generating step of extracting equipment / product combinations, which are combinations of used equipment and products manufactured by the equipment, from manufacturing performance records, dividing the manufacturing time length into predetermined units, and generating manufacturing time series data representing the production quantity of the equipment / product combination in a time series for each predetermined unit; A calculation step of calculating a delivery date compliance rate of a variety representing the equipment / variety combination within a specified time length; and A judgment step is performed, based on the manufacturing timing data of the equipment / variety combination and the delivery compliance rate of the variety, to judge whether the delivery compliance rate of the variety in the non-manufacturing time length of the equipment / variety combination reaches a predetermined certain value, and based on the judgment result, to judge whether to register the equipment / variety to the combination master data.

13. A plan-making assisting method for developing a production plan by a computer using combined master data consisting of combinations of equipment extracted from a plurality of equipment and varieties extracted from a plurality of varieties, the plan-making assisting method comprising: A manufacturing time series generating step of extracting equipment / product combinations, which are combinations of used equipment and products manufactured by the equipment, from manufacturing performance records, dividing the manufacturing time length into predetermined units, and generating manufacturing time series data representing the production quantity of the equipment / product combination in a time series for each predetermined unit; A calculation step of calculating a delivery date compliance rate of a variety representing the equipment / variety combination within a specified time length; and An update judgment step is performed to judge, based on the manufacturing timing data of the equipment / variety combination and the delivery compliance rate of the variety, whether the delivery compliance rate of the variety in the non-manufacturing time length of the equipment / variety combination reaches a predetermined certain value, and based on the judgment result, to judge whether to delete the existing equipment / variety from the combination master data of the equipment / variety combination or to continue to maintain the existing equipment / variety, or whether to register the equipment / variety of the new variety to the combination master data.

Images