JP4241816B2 - Production management apparatus and production management method - Google Patents

Description

  The present invention relates to a technology for managing production of a product, and more particularly to a production management apparatus and a production management method for managing processing, purchasing, subcontracting and the like of parts constituting a product.

  In recent years, IT has been promoted in every situation, and production management systems are being developed at the production sites of products with the aim of improving production efficiency.

  However, in the past, since systematization has been promoted based on unique know-how in each process, cooperation between departments is insufficient, and it cannot be said that efficient production management has been realized. In order to improve such a situation, there is a need for a technology that comprehensively manages the process from receiving a product order from a customer, procuring parts, and producing the product.

  The present invention has been made in view of such a situation, and an object thereof is to provide a more convenient production management technique.

  One embodiment of the present invention relates to a production management apparatus. This production management device expresses a hierarchical structure of parts constituting the product with reference to the parts database storing information relating to parts constituting the product and information relating to parts constituting the part. A tree display unit that displays the tree, and a common component extraction unit that extracts common components from the tree displayed by the tree display unit and displays them in an identifiable manner in the tree. And

  The production management device includes a procurement method classification unit for classifying the part into an in-house part and an externally acquired part, an inventory amount of the part acquired from the outside, and the part required for manufacturing the ordered product. A required amount calculation unit that calculates a required amount for acquiring the part from the outside on a level-by-level basis based on the required amount may be further provided.

  The production management apparatus may further include a purchased part order quantity determining unit that determines an order quantity of parts to be purchased based on the required quantity calculated by the required quantity calculating unit. The production management apparatus may further include an outsourced part order quantity determining unit that determines an order quantity of parts to be subcontracted based on the required quantity calculated by the required quantity calculating unit.

  The production management device further includes a machining process information acquisition unit that acquires information related to the machining process of the part to be produced in an internal manner, and an export unit that exports information related to the machining process to a simulator that simulates the machining process. Also good.

  The production management apparatus further includes an import unit that imports a simulation result of the machining process from the simulator, and a work instruction generation unit that generates a work instruction related to the part to be produced based on the simulation result. Good.

  Another aspect of the present invention relates to a production management method. The production management method is configured to receive information related to a part constituting a product and information related to a part constituting the part, store the received information in a part database, refer to the part database, and The method includes a step of displaying a tree expressing a hierarchical structure of components to be configured, and a step of extracting common components from the tree and displaying them in an identifiable manner in the tree.

  Still another embodiment of the present invention relates to a program. This program uses a computer to receive information related to parts constituting a product and information related to parts constituting the part, and to store the received information in a parts database. Tree display means for displaying a tree representing the hierarchical structure of the parts constituting the product, common parts extracted from the tree displayed by the tree display means, and displayed in an identifiable manner in the tree It functions as a component extraction means.

  It should be noted that any combination of the above-described constituent elements and a representation of the present invention converted between a method, an apparatus, a system, etc. are also effective as an aspect of the present invention.

  According to the present invention, a highly convenient production management technique can be provided.

  FIG. 1 shows a configuration of a production management system 10 according to the embodiment. The production management system 10 includes a terminal 20 that is an example of a production management apparatus, a production system simulator 14, and a network 12 that connects these configurations. In the present embodiment, the function of the production management apparatus is realized by a spreadsheet of a spreadsheet application. As a result, even when each process for manufacturing a product is managed by a plurality of different departments such as a sales department, a design department, a manufacturing department, and a procurement department, a spreadsheet is transmitted and received between terminals via the network 12. Thus, data can be shared. Spreadsheets may be exchanged between departments without being connected via the network 12 in a state of being recorded on a recording medium.

  FIG. 2 shows the configuration of the terminal 20. The terminal 20 mainly includes an input unit 30, a control unit 40, an export unit 51, an import unit 52, a component database 60, and a display device 70. The control unit 40 includes an order information reception unit 41, a part information acquisition unit 42, a tree display unit 43, a common part extraction unit 44, a procurement method classification unit 45, a manufactured part information generation unit 46, a purchased part information generation unit 47, an outsourced part. An information generation unit 48, a machining process information acquisition unit 49, a required amount calculation unit 50, an export unit 51, an import unit 52, a work instruction form generation unit 53, a purchased part order quantity determination unit 54, an outsourced part order quantity determination unit 55, and A profit chart generator 56 is included.

  In terms of hardware components, these configurations are realized by a CPU of a computer, a memory, a program loaded in the memory, and the like, but here, functional blocks realized by their cooperation are illustrated. Accordingly, those skilled in the art will understand that these functional blocks can be realized in various forms by hardware only, software only, or a combination thereof.

  The order information receiving unit 41 receives information about a product for which an order has been received via the input unit 30 and stores it in the parts database 60. FIG. 3 shows an example of internal data of the order information table 61 of the parts database 60. The order information table 61 includes an order date column 100, an order receiver column 102, a product code column 104, a product name column 106, a quantity column 108, a delivery date column 110, and a user information column 112. The order date column 100 stores the date when the product is ordered. The order receiving party column 102 stores the company name of the order receiving party. The product code column 104 stores a code for identifying the ordered product. The product name column 106 stores the name of the ordered product. The quantity column 108 stores the quantity of the ordered product. The delivery date column 110 stores the delivery date. The user information column 112 stores special notes relating to the order receiving party. The order information receiving unit 41 may receive information regarding the ordered product in the sales department terminal 20a.

  The part information acquisition unit 42 acquires information about parts constituting the ordered product and information about parts constituting the part. If the product has not been designed, after the product is designed in the design department, the part information acquisition unit 42 receives information on the part via the input unit 30 in the design department terminal 20b and stores it in the part database 60. To do. FIG. 4 shows an example of the component table 62 of the component database 60. The component part table 62 is a table for inputting the component parts of the product by classifying them into hierarchies. Level 0 is the product itself, and a product number column 120 and a product name column 122 are provided. Level 1 is a primary part constituting a product, and a group number column 124 and a group name column 126 are provided. Level 2 is a secondary part constituting the primary part, and a part number column 128 and a part name column 129 are provided. Thereafter, in the same manner, information on the (n + 1) -order component that constitutes the n-order component is input.

  Detailed information regarding each component is stored in the component information table 63. FIG. 5 shows an example of internal data of the component information table 63. The component information table 63 includes a product code column 130, a component code column 132, a component name column 134, a classification column 136, a drawing number column 138, a production base column 140, and a user information column 142. The product code column 130 stores a code for identifying a product. The part code column 132 stores a code for identifying a part constituting the product. The part name column 134 stores the name of the part. The classification column 136 stores a part procurement method. Examples of parts procurement methods include in-house production, purchasing, and subcontracting. The drawing number column 138 stores the number of the part design drawing. The production base column 140 stores the parts production base. The user information column 142 stores information transferred from the user information column 112 of the order information table 61 shown in FIG.

  If the product has already been designed and information about the parts that make up the product is already stored in the parts database 60, the parts information acquisition unit 42 may configure the component table 62 and the parts of the parts database 60 as necessary. Necessary information may be acquired from the information table 63.

  The tree display unit 43 refers to the part database 60 and displays a family tree representing the hierarchical structure of the parts constituting the product on the display device 70. FIG. 6 shows an example of a family tree displayed by the tree display unit 43. A family tree in which the components of the product “C” are arranged hierarchically according to the level is displayed. Conventionally, such a family tree has been used mainly when ordering parts in the purchasing department. However, in the production management apparatus according to the present embodiment, the tree display unit 43 displays the family tree, so that the product is displayed. You can refer to Family Tree in all departments related to production. As a result, for example, the design department can design individual parts while grasping the part configuration of the entire product, or the manufacturing department can produce individual parts while grasping the part structure of the entire product. , Can improve the production efficiency of products.

  The common parts extraction unit 44 refers to the parts database 60, extracts common parts from the family tree displayed by the tree display unit 43, and displays them on the family tree display screen so that they can be identified. In the family tree shown in FIG. 6, the part “A1111” is a component part of the part “A111” and is also used as a component part of the part “A12”. Therefore, the display mode is different from other parts. Is displayed. The common component extraction unit 44 may display the common component in a color, shape, size, or the like different from other components. This makes it easy to grasp the parts that are used in common from all the parts that make up the product. For example, you can place orders for common parts in the procurement department, or manage the inventory together. Management efficiency can be improved.

  The procurement method classification unit 45 acquires a procurement method for parts constituting the product, and classifies the parts according to the procurement method. The procurement method classification unit 45 classifies the parts constituting the product into parts produced in-house and parts acquired from the outside. Parts acquired from the outside are further classified into parts to be purchased and parts to be outsourced. The procurement method classification unit 45 may acquire a component procurement method with reference to the classification column 136 of the component information table 63 of the component database 60. When the classification field 136 is not registered, the procurement method classification unit 45 acquires the procurement method of each part via the input unit 30 in the procurement department terminal 20d and stores it in the classification field 136 of the part information table 63. .

  The manufactured part information generation unit 46, the purchased part information generation unit 47, and the subcontracted part information generation unit 48 are necessary for manufacturing the product in accordance with the part procurement method stored in the classification column 136 of the part information table 63 of the part database 60. A manufactured part information table 64, a purchased part information table 65, and an outsourced part information table 66 are generated by extracting a manufactured part, a purchased part, and an outsourced part, respectively. FIG. 7 shows an example of internal data of the manufactured parts information table 64, the purchased parts information table 65, and the outsourced parts information table 66. Each table is provided with a product name column 150, a component code column 152, and a component name column 154. The product name column 150 stores the name of the product. The part code column 152 stores part codes of manufactured parts, purchased parts, or outsourced parts. The part name column 154 stores the name of the part. In this way, the parts that make up the product are classified and managed as manufactured parts produced in-house, purchased parts purchased from other companies, and outsourced parts outsourced to other companies.

  The machining process information acquisition unit 49 acquires information related to the machining process of the manufactured part to be produced in-house. FIG. 8 shows an example of internal data of the machining process information table 67. The processing process information table 67 includes a product name field 160, a part code field 162, a part name field 164, a process order field 166, a process number field 168, a process name field 170, a process type field 172, a processing time field 174, and a non-processing. A time field 176, an equipment name field 178, and a user information field 180 are provided. The product name column 160 stores the name of the product. The part code column 162 stores a part code of a part constituting the product. The part name column 164 stores the name of the part. The process order column 166 stores the order of processes for manufacturing parts. The process number column 168 stores a number for identifying a process. The process name column 170 stores the name of the process. The process type column 172 stores the type of process. The processing time column 174 stores the time required for processing. The non-processing time column 176 stores the time required for processes other than processing. The equipment name column 178 stores the name of equipment used in the process. The user information column 180 stores information arbitrarily input by the user. The processing process information acquisition unit 49 may receive information regarding the manufacturing process of the manufactured part via the input unit 30 in the manufacturing department terminal 20 c and store the information in the processing process information table 67 of the part database 60.

  The export unit 51 converts data related to the machining process output from the machining process information acquisition unit 49 into a data format that can be input by the production system simulator 14 and exports the data to the production system simulator 14. The export unit 51 may extract data to be input to the production system simulator 14 from data related to the machining process output from the machining process information acquisition unit 49, and may output the data in, for example, a CSV format.

  The import unit 52 acquires simulation result data from the production system simulator 14, converts the data into a data format that can be handled by the production management apparatus, and imports the data into the production management apparatus. The import unit 52 may extract data used in the production management apparatus from the data output from the production system simulator 14 in, for example, the CSV format and output the data to the production management apparatus.

  Based on the simulation result of the production system simulator 14 imported by the import unit 52, the work instruction form generation unit 53 generates a work instruction related to the manufactured part to be produced. The work instruction may be generated for each worker engaged in the machining process or for each facility used in the machining process.

  The required amount calculation unit 50 calculates the required amount to acquire the part from the outside on a level-by-level basis based on the inventory amount of the part acquired from the outside and the required amount of the part required for manufacturing the ordered product. To do. FIG. 9 shows an example of the structure screen displayed by the requirement calculation unit 50 calculating and displaying the requirement. The required amount calculation unit 50 calculates the required amount of parts in each layer on a level-by-level basis from the level 0 product in order toward the lower layer. Since the required amount of the level “0” product “C” is the same as the order amount, the required amount calculation unit 50 refers to the quantity column 108 of the order information table 61 of the parts database 60 and stores the required amount. The required amount calculation unit 50 refers to an inventory database (not shown) and confirms the inventory of the product “C”. In this case, since the stock is 0, the net requirement of the product “C” is “30-0 = 30”.

  The level 1 part “A11” that is the primary part constituting the product “C” is required for each product “C”, so the required amount of the part “A11” is “30 × 3 = 90”. . Since the current on-hand inventory amount of the part “A11” is “45”, even if the entire on-hand inventory amount “45” is used, “45” is still insufficient. Therefore, the net requirement for the part “A11” is “45”. Similarly, since one level “1” component “A12” is required for each product “C”, the required amount is “30 × 1 = 30”. Since the on-hand inventory amount is “50”, the on-hand inventory amount is “50−30 = 20”, and the net required amount is “0”.

  The level 2 part “A111” that is the secondary part constituting the primary part “A11” is required for each part “A11”, but the net requirement of the part “A11” is “45”. The required amount of the part “A111” is “45 × 2 = 90”. Since the on-hand inventory amount of the part “A111” is “10”, the on-hand inventory amount is “0”, and the net required amount is “90−10 = 80”.

  Thus, the required amount calculation unit 50 calculates the required amount of parts on a level-by-level basis while referring to the parts database 60. Thereby, the required amount of each part can be grasped appropriately and easily, and the order quantity of purchased parts or outsourced parts can be determined. Further, even if there are common parts, it is possible to allocate the stock appropriately and calculate the net required amount.

  The purchased part order quantity determination unit 54 determines the order quantity of parts to be purchased from another company based on the required quantity calculated by the required quantity calculation unit 50. The outsourced part order quantity determining unit 55 determines the order quantity of parts to be subcontracted to other companies based on the required quantity calculated by the required quantity calculating unit 50.

  The profit chart generation unit 56 refers to the parts database 60 and generates a profit chart related to the ordered product. FIG. 10 shows an example of the profit chart 198 generated by the profit chart generator 56. The profit chart generation unit 56 refers to a price table (not shown) in the parts database 60, obtains the manufacturing cost, purchase price, subcontracting price, etc. of each part, calculates the variable cost, and calculates fixed costs such as equipment costs. calculate. The profit chart generation unit 56 draws a sales line 194 and a total cost line 196 on the graph to generate a profit chart 198, and obtains a breakeven point from the intersection. The profit chart generator 56 displays a control 190 for adjusting variable costs and a control 192 for adjusting fixed costs when the profit chart 198 is displayed on the display device 70. When the user adjusts the variable cost by the control 190, the profit chart generation unit 56 changes the slope of the total cost line 196. Further, when the user adjusts the fixed cost by the control 192, the profit chart generation unit 56 changes the Y intercept of the total cost line 196. This makes it possible to visually simulate how much ordinary profit can be obtained by reducing variable costs and fixed costs, which can be used for management decisions.

  The present invention has been described based on the embodiments. This embodiment is an exemplification, and it will be understood by those skilled in the art that various modifications can be made to combinations of the respective constituent elements and processing processes, and such modifications are also within the scope of the present invention. is there.

It is a figure which shows the structure of the production management system which concerns on embodiment. It is a figure which shows the structure of a terminal. It is a figure which shows the example of the internal data of the order information table of a components database. It is a figure which shows the example of the component table of a components database. It is a figure which shows the example of the internal data of a components information table. It is a figure which shows the example of the family tree displayed by the tree display part. It is a figure which shows the example of the internal data of a manufacture parts information table, a purchase parts information table, and an outsourced parts information table. It is a figure which shows the example of the internal data of a process information table. It is a figure which shows the example of the structure screen which the requirement calculation part calculated and displayed the requirement. It is a figure which shows the example of the profit chart produced | generated by the profit chart production | generation part.

Explanation of symbols

  DESCRIPTION OF SYMBOLS 10 Production management system 12 Network 14 Production system simulator 20 Terminal 30 Input part 40 Control part 41 Order information reception part 42 Part information acquisition part 43 Tree display part 44 Common part extraction part 45 Procurement method Classification part, 46 Manufacturing part information generation part, 47 Purchased part information generation part, 48 Subcontracted part information generation part, 49 Machining process information acquisition part, 50 Required amount calculation part, 51 Export part, 52 Import part, 53 Work instruction form generation 54, purchased parts order quantity determination section, 55 subcontracted parts order quantity determination section, 56 profit chart generation section, 60 parts database, 61 order information table, 62 component parts table, 63 parts information table, 64 manufactured parts information table, 65 Purchased parts information table, 66 Subcontracted parts information table, 67 Processing process Broadcasting table, 70 display device.

Claims (8)

Storing a table hierarchically classify parts constituting the part products and the parts constituting a product, including the classification information indicating a procurement method information and said component for identifying the component, and information about the component Parts database to be
With reference to the classification information stored in the parts database, the procurement method classification unit for classifying the parts into in-house produced parts , parts to be subcontracted, and parts acquired from the outside consisting of parts to be purchased ;
In accordance with the procurement method classified by the procurement method classification unit , the information for identifying the part classified as the part to be produced in-house from the parts constituting the product stored in the parts database, A manufacturing part information generation unit that extracts information on the part to be produced in-house and generates a manufacturing part information table;
In accordance with the procurement method classified by the procurement method classification unit, the subcontracting includes information for identifying a part classified as a part to be subcontracted from the parts constituting the product stored in the parts database. To extract information on the parts to be outsourced, and to generate an outsourced parts information table,
According to the procurement method classified by the procurement method classification unit, the purchase includes information for identifying a part classified as a part to be purchased out of parts constituting the product stored in the parts database. A purchase parts information generation unit that extracts information about parts to be generated and generates a purchase parts information table;
A tree display that displays a tree representing a hierarchical structure of parts constituting the product with reference to the parts database in all departments that procure the in-house produced parts, the outsourced parts, and the purchased parts. And
Referring to the parts database, extracting common parts from the tree displayed by the tree display unit, and displaying them in an identifiable manner in the tree;
A production management device comprising: An inventory database for storing an inventory quantity of the parts;
The part is acquired from the outside based on the inventory amount of the part acquired from the outside read from the inventory database and the required amount of the part required for manufacturing the ordered product read from the table. The production management apparatus according to claim 1, further comprising a requirement calculation unit that calculates a requirement to be calculated on a level-by-level basis. The purchase part order quantity determining unit that determines an order quantity of a part to be purchased based on the required quantity calculated by the required quantity calculating unit with reference to the purchased parts information table. 2. The production management apparatus according to 2. The subcontracted part order quantity determination unit that determines an order quantity of a part to be subcontracted based on the required quantity calculated by the required quantity calculation unit with reference to the subcontracted part information table. 2. The production management apparatus according to 2. The manufacturing part information table includes a machining process information table storing information on a machining process of the part to be produced in-house,
With reference to the machining process information table, a machining process information acquisition unit that acquires information on the machining process of the part to be internally produced,
An export unit that exports information related to the machining process to a simulator that simulates the machining process;
The production management apparatus according to claim 1, further comprising: An import unit for importing the simulation result of the machining process from the simulator;
Based on the simulation result, a work instruction generating unit that generates a work instruction related to the part to be produced in-house,
The production management apparatus according to claim 5, further comprising: Comprising a table hierarchically classify parts constituting the part products and the parts constituting a product, a classification information indicating a procurement method information and said component for identifying the component receives the information relating to the component Storing the received information in a parts database;
A step above with reference to the parts category information stored in the database, to classify the parts, to the parts of the inner work, a component obtained from an external consisting components outsource and parts to purchase,
In accordance with the procurement method classified by the classification step, the information includes information for identifying a part classified as a part to be produced from among the parts constituting the product stored in the parts database . Extracting information about the part to be created and generating a manufacturing part information table;
The subcontracting includes information for identifying a part classified as a part to be subcontracted from the parts constituting the product stored in the parts database according to the procurement method classified by the classifying step. Extracting information about the part and generating an outsourced part information table;
According to the procurement method classified by the classification step, the purchasing includes information for identifying a part classified as a part to be purchased out of parts constituting the product stored in the parts database. Extracting information about parts and generating a purchased parts information table;
Displaying a tree representing a hierarchical structure of parts constituting the product with reference to the parts database in all departments that procure the in-house produced parts, the outsourced parts, and the purchased parts. ,
Extracting common parts from the tree with reference to the parts database and displaying them in an identifiable manner in the tree;
A production management method comprising: Computer
Comprising a table hierarchically classify parts constituting the part products and the parts constituting a product, a classification information indicating a procurement method information and said component for identifying the component receives the information relating to the component , Parts information receiving means for storing the received information in the parts database,
Above with reference to the parts category information stored in the database, the parts, and parts of the inner work, procurement method classifying means for classifying into a component obtained from an external consisting components outsource and parts to purchase,
In accordance with the procurement method classified by the procurement method classification means , information for specifying a part classified as an in-house produced part from the parts constituting the product stored in the parts database is included. Manufacturing part information generating means for extracting information on the part to be produced in-house and generating a manufacturing part information table;
The subcontracting includes information for identifying a part classified as a part to be subcontracted from among the parts constituting the product stored in the parts database according to the procurement method classified by the procurement method classification unit. Subcontracting part information generating means for extracting information about parts to be generated and generating a subcontracting part information table,
The purchasing includes information for identifying a part classified as a part to be purchased out of parts constituting the product stored in the parts database according to the procurement method classified by the procurement method classification unit. Purchasing part information generating means for extracting information on parts to be generated and generating a purchasing parts information table;
A tree display that displays a tree representing a hierarchical structure of parts constituting the product with reference to the parts database in all departments that procure the in-house produced parts, the outsourced parts, and the purchased parts. means,
A common component extraction unit that refers to the component database, extracts common components from the tree displayed by the tree display unit, and displays them in an identifiable manner in the tree;
A program characterized by functioning as

Images