JP2006018416A - Product information management device and program therefor - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To solve the following problem of conventional technology: because it cannot be decided whether a component used in product production performed one day is a component produced by one's own company or a component produced by a subcontractor, high-accuracy cost of the product produced one day cannot be calculated. <P>SOLUTION: This product information management device automatically determines a kind showing whether the component identified by a constituting item identifier is produced by the own company or by the subcontractor on the basis of a production results day of the production, buying results day information of the component, and production results day information of the component, and calculates the cost of the product on the basis of the kind. Thereby, because can calculate the production cost of the product in a state that it is distinguished whether the own company's production or the subcontractor's production, the high-accuracy production cost can be automatically calculated. <P>COPYRIGHT: (C)2006,JPO&NCIPI

Description

  The present invention relates to a product information management apparatus and the like for managing information related to products.

As a prior art related to the product information management apparatus, there is the following component configuration specification management system (see Patent Document 1). The system includes an information input unit for inputting information, and a configuration list creation storage unit that creates data of a configuration list of each part constituting the product using the information input unit and stores the data in a work storage unit of the memory. Using the information input means, the component list specified from the configuration list data stored in the work storage unit is related to the sending data, or the configuration list and the drawing are related to the sending data. At the same time, a delivery form information creation storage means for editing and creating the delivery form information and historically storing it in the delivery form information storage section of the memory, and reading and specifying the delivery form information stored in the delivery form information storage section. The data delivery means for sending to the delivery destination and the delivery management information including the data indicating that the delivery form has been sent are created in correspondence with the delivery form information stored in the above-mentioned delivery form information storage section and distributed. Delivery management information creation storage means for storing in an information storage section; and display means for displaying the information input by the information input means and the information stored in the memory on a display screen in a designated form. A product is characterized in that a delivery form is created and stored by the delivery form information creation storage means, and after the delivery form is sent, the construction list of the delivery form information or the configuration list and drawing cannot be edited and changed. This is a component configuration specification management system. Such a component configuration specification management system can transmit the configuration list and drawing information created by the development department to the manufacturing department, and can instruct the use of the internal product or the external product at the time of the transmission. Easy management.
Japanese Unexamined Patent Publication No. 2000-99587 (first page, FIG. 1 etc.)

  However, there are the following backgrounds in the product manufacturing department. In other words, there are cases where the parts used for manufacturing a certain product are produced in-house and outsourced production. For example, when a large number of one part is required, a predetermined number is often produced in-house and the other number is procured by outsourced production.

  In such a case, it is impossible to determine whether the parts used in product production performed on a certain day are in-house manufactured parts or outsourced parts. Therefore, a highly accurate cost for a product produced on a certain day is calculated. I couldn't. In addition, for example, it is difficult to determine whether the parts used for production on a day with a high percentage of manufacturing defects are in-house manufactured parts or outsourced parts, making it difficult to improve quality and reduce manufacturing costs. there were.

  In view of this point, an object of the present invention is to provide a product information management apparatus that can easily distinguish whether a part used in manufacturing a product is an in-house product or an outsourced product.

In order to solve the above-described problems, the first invention provides a line completed item identifier which is information for identifying an item which is a product to be produced or a part of the product, and an item identified by the line completed item identifier. Production result data storage unit storing at least one production result data including production result date information that is information related to the production result date, production number information that is information indicating the production number, and information for identifying the purchased parts A purchase having a purchase item identifier, purchase actual date information that is information indicating the date of purchase of the item identified by the purchase item identifier, and purchase number information that is information indicating the number of purchases A purchase record data storage unit that stores one or more record data, and information indicating the configuration of the product, and configures the product or part identified by the line complete item identifier and the line complete item identifier Product configuration data storage unit that stores one or more product configuration data having configuration item identifiers that are information for identifying parts to be configured, and a configuration table output instruction that is an instruction to output a configuration table indicating the correspondence between products and parts A reception unit that receives a composition table output instruction having a line completion item identifier, and a production result data storage unit that is paired with a line completion item identifier included in the composition table output instruction received by the reception unit From the product configuration data storage unit, the configuration item identifier of the part that is a descendant of the product identified by the line completion item identifier included in the configuration table output instruction received by the reception unit and the finished product production result date information acquisition unit acquired from the product configuration data storage unit Purchase results paired with a component item identifier acquisition unit to be acquired one or more and a purchase item identifier that matches the component item identifier acquired by the component item identifier acquisition unit Production result date information paired with a component purchase result date information acquisition unit that acquires information from the purchase result data storage unit and a line completed item identifier that matches the component item identifier acquired by the component item identifier acquisition unit Obtained from the production result data storage unit, the production date information acquired by the finished product production date information acquisition unit, and the component purchase result date information acquisition unit. The parts identified by the component item identifier acquired by the component item identifier acquisition unit based on the purchased purchase date information and the production result date information acquired by the component production result date information acquisition unit are in-house production A type determining unit that determines a type indicating whether it is outsourced production, a line completed item identifier included in a configuration table output instruction received by the receiving unit, and one or more acquired by the component item identifier acquiring unit Based on the component item identifier and the type of the component item identifier determined by the type determination unit, the configuration table configuration unit constituting the configuration table and the configuration table configured by the configuration table configuration unit can be visually identified by component type. It is a product information management device comprising a configuration table output unit for outputting in a mode that can be clearly specified.

  With this configuration, it is possible to output the product configuration table by distinguishing whether the parts used for manufacturing the product are in-house production or outsourced production, and as a result, the parts used in the product production performed on a certain day However, it is easy to determine whether the part is an in-house manufactured part or an outsourced part, making it easy to improve quality and reduce manufacturing costs.

In addition, the second invention is information regarding a line completed item identifier that is information for identifying a product to be produced or an item that is a part of the product, and information relating to a production actual date of the item identified by the line completed item identifier. Production result date information, production result data storage unit storing one or more production result data having production number information which is information indicating the production number, a purchased item identifier which is information for identifying the purchased parts, One or more purchase record data having purchase record date information, which is information indicating the date of purchase of the item identified by the purchase item identifier, and purchase quantity information, which is information indicating the number of purchased items, is stored. Information indicating the configuration of the purchased purchase data storage unit and the product, and information for identifying the part constituting the product or part identified by the line completed item identifier and the line completed item identifier This is the cost of in-house production of a product configuration data storage unit that stores one or more product configuration data having a certain configuration item identifier, a line completed item identifier, and a product or part identified by the line completed item identifier. In-house processing cost information that is information related to in-house processing costs, and processing costs that have information on out-of-house costs that are information related to external manufacturing costs that are costs when the product or part identified by the line finished product identifier is outsourced Store one or more material cost data having processing cost data storage unit that stores one or more data, a component item identifier, and material cost information that is information about the material cost of the part identified by the component item identifier The actual cost output instruction, which is an instruction to output the actual cost of the product and part identified by the line cost item storage unit and the line completed item identifier, A finished product that receives from the production result data storage unit a reception unit that receives an actual cost output instruction having a bespoke and a production result date information that is paired with a line completed item identifier that the actual cost output instruction received by the reception unit has A configuration for acquiring one or more configuration item identifiers of the descendant parts of the product identified by the line completed item identifiers included in the actual cost output instruction received by the reception unit and the actual production date information acquisition unit from the product configuration data storage unit A component purchase record that acquires from the purchase record data storage unit the purchase record date information paired with the item identifier acquisition unit and the purchase item identifier that matches the component item identifier acquired by the component item identifier acquisition unit Date information acquisition unit and production result date information paired with the line completed item identifier that matches the component item identifier acquired by the component item identifier acquisition unit Data acquisition date information acquisition unit obtained from the data storage unit, production result date acquired by the finished product production result date information acquisition unit, and purchase result acquired by the component purchase result date information acquisition unit Based on the date information and the production result date information acquired by the component production result date information acquisition unit, the part identified by the component item identifier acquired by the component item identifier acquisition unit is in-house production or subcontracted production A type determination unit that determines a type indicating whether or not a product or a part identified by a line completed item identifier included in production result data stored in the production result data storage unit is the type determined by the type determination unit; A type accumulating unit for accumulating in association with a configuration item identifier for identifying a component to be configured, and one or more configuration item identifiers acquired by the configuration item identifier acquisition unit, or the one or more configuration item identifiers and Acquire the type corresponding to the line completed item identifier that the actual cost output instruction has, and based on the type, each component item identifier, or the processing cost of the part or product identified by each component item identifier and line completed item identifier, or The material cost is identified by the cost acquisition unit that acquires the material cost from the processing cost data storage unit or the material cost data storage unit, and the line completion item identifier that the actual cost output instruction has based on the cost acquired by the cost acquisition unit. The product information management apparatus includes a cost calculation unit that calculates the cost of a product and a cost information output unit that outputs cost information that is information about the cost calculated by the cost calculation unit.
With this configuration, it is possible to calculate the manufacturing cost of a product by distinguishing whether it is in-house production or outsourced production, and as a result, it is possible to calculate a highly accurate manufacturing cost.

  According to the present invention, since it is possible to automatically determine whether a part used in manufacturing a product is in-house production or outsourced production, various measures can be easily taken.

Embodiments of the present invention will be described below in detail with reference to the drawings. Note that in this embodiment, components using the same reference numerals and steps in the flowcharts perform the same function, and thus description of what has been described once may be omitted.
(Embodiment 1)

  FIG. 1 is a hardware configuration diagram of the information processing system according to the present embodiment. The information processing system includes an information processing terminal 11 and a product information management device 12. Here, the information processing terminal 11 and the product information management apparatus 12 constitute a server / client system.

FIG. 2 is a block diagram of the information processing system in the present embodiment. The information processing terminal 11 includes an input reception unit 1101, a configuration table output instruction transmission unit 1102, a configuration table reception unit 1103, a configuration table display unit 1104, and a control unit 1105.
The product information management apparatus 12 includes a production record data storage unit 1201, a purchase record data storage unit 1202, a product configuration data storage unit 1203, a reception unit 1204, a finished product production record date information acquisition unit 1205, a component item identifier acquisition unit 1206, A component purchase result date information acquisition unit 1207, a component production result date information acquisition unit 1208, a type determination unit 1209, a configuration table configuration unit 1210, and a configuration table output unit 1211 are provided. The type determination unit 1209 includes a production start date calculation unit 12091 and a type determination unit 12092.

The input receiving unit 1101 receives an input of a configuration table output instruction that is an instruction to output a configuration table indicating the correspondence between products and parts. The composition table output instruction has a line completion item identifier. The line completion item identifier is information for identifying an item that is a product to be produced or a part of the product. The line completion item identifier may be a product number, or a name of a product or a part. The input means may be anything such as a numeric keypad, keyboard, mouse or menu screen. The input receiving unit 1101 can be realized by a device driver of an input unit such as a numeric keypad or a keyboard, menu screen control software, or the like.

  The configuration table output instruction transmission unit 1102 transmits the configuration table output instruction received by the input reception unit 1101 to the product information management apparatus 12. The configuration table output instruction transmitted by the configuration table output instruction transmission unit 1102 may not have the same structure as the configuration table output instruction received by the input reception unit 1101. The configuration table output instruction transmission unit 1102 can be realized by a wireless or wired communication unit or the like.

  The configuration table receiving unit 1103 receives the configuration table from the product information management apparatus 12. The configuration table is information indicating the correspondence between products and parts. In other words, the configuration table includes information on all parts constituting the product and information indicating a hierarchical relationship between the product and the part. The configuration table has information for identifying the type of product or part. The type is information indicating whether the product or part is in-house production or outsourced production. The configuration table receiving unit 1103 can be realized by wireless or wired communication means. Normally, the configuration table output instruction transmission unit 1102 and the configuration table reception unit 1103 are realized by a single communication unit.

  The configuration table display unit 1104 displays the configuration table received by the configuration table reception unit 1103 in such a manner that the type of product or part can be visually specified. The configuration table may be a table format or a hierarchical diagram. Specific display of the configuration table in the configuration table display unit 1104 will be described later. The configuration table display unit 1104 may or may not include a display (display device). The configuration table display unit 1104 can be realized by display device driver software or display device driver software and a display.

  The control unit 1105 passes the configuration table output instruction received by the input reception unit 1101 to the configuration table output instruction transmission unit 1102, and passes the configuration table received by the configuration table reception unit 1103 to the configuration table display unit 1104. The control unit 1105 can be usually realized by an MPU, a memory, or the like. The processing procedure of the control unit 1105 is usually realized by software, and the software is recorded on a recording medium such as a ROM. However, it may be realized by hardware (dedicated circuit).

  The production result data storage unit 1201 is information regarding a line completion item identifier that is information for identifying an item that is a product to be produced or a part of the product, and a production result date of the item identified by the line completion item identifier. One or more pieces of production result data having production result date information and production number information which is information indicating the production number are stored.

  The purchase record data storage unit 1202 includes a purchase item identifier that is information for identifying a purchased part, and purchase record date information that is information indicating the date of purchase of the item identified by the purchase item identifier. One or more purchase result data having purchased number information, which is information indicating the purchased number, is stored.

The product configuration data storage unit 1203 is information indicating the configuration of a product, and a product having a configuration item identifier that is information identifying a line completed item identifier and a product identified by the line completed item identifier or a component constituting the part. One or more pieces of configuration data are stored.
The production record data storage unit 1201, the purchase record data storage unit 1202, and the product configuration data storage unit 1203 are preferably non-volatile recording media, but can also be realized by volatile recording media. Note that the production record data storage unit 1201, the purchase record data storage unit 1202, and the product configuration data storage unit 1203 are normally realized by one recording medium, but may be realized by a plurality of recording media.

The accepting unit 1204 is a composition table output instruction that is an instruction to output a composition table indicating a correspondence relationship between products and parts, and accepts a composition table output instruction having a line completed item identifier. The reception here is usually reception. However, when the product information management apparatus 12 is realized as a stand-alone, the receiving unit 1204 is a unit that receives an input from the user. The accepting unit 1204 can be realized by, for example, a wireless or wired communication unit.
The finished product production date information acquisition unit 1205 acquires the production result date information paired with the line completed item identifier included in the configuration table output instruction received by the receiving unit 1204 from the production result data storage unit 1201.

The configuration item identifier acquisition unit 1206 acquires from the product configuration data storage unit 1203 one or more configuration item identifiers of the descendant parts of the product identified by the line completion item identifier included in the configuration table output instruction received by the reception unit 1204. The configuration item identifier acquisition unit 1206 acquires configuration item identifiers of all descendant parts by recursively acquiring the configuration item identifier corresponding to the line completion item identifier from the product configuration data storage unit 1203.
The component purchase record date information acquisition unit 1207 acquires purchase record date information paired with the purchase item identifier that matches the component item identifier acquired by the component item identifier acquisition unit 1206 from the purchase record data storage unit 1202. To do.
The component production record date information acquisition unit 1208 acquires the production record date information paired with the line completion item identifier that matches the component item identifier acquired by the component item identifier acquisition unit 1206 from the production record data storage unit 1201.

The type determination unit 1209 includes the production result date information acquired by the finished product production date information acquisition unit 1205, the purchase result date information acquired by the component purchase result date information acquisition unit 1207, and the component production result date information. Based on the production result date information acquired by the acquisition unit 1208, a type indicating whether the part identified by the configuration item identifier acquired by the configuration item identifier acquisition unit 1206 is in-house production or outsourced production is determined.
The production start date calculation unit 12091 calculates the production start date based on the production result date information acquired by the finished product production result date information acquisition unit 1205. For example, the production start date calculation unit 12091 calculates the production start date as “production result date—one day”.

  The type determination unit 12092 includes a production start date calculated by the production start date calculation unit 12091, a purchase result date information acquired by the component purchase result date information acquisition unit 1207, and a component production result date information acquisition unit 1208. Based on the acquired production date information, the type indicating whether the part identified by the configuration item identifier acquired by the configuration item identifier acquisition unit 1206 is in-house production or outsourced production is determined. Specifically, for example, first, the type determination unit 12092 is the purchase record date information acquired by the component purchase record date information acquisition unit 1207, and among the purchase record date information corresponding to the parts, the production start point The latest purchase record date information which is the purchase record date information indicating the day before the date and which is closest to the production start date is acquired. Next, the type determining unit 12092 is the production result date information acquired by the component production result date information acquisition unit 1208, and the production result date indicating the date before the production start date among the production result date information corresponding to the part. The latest production result date information which is information and is the date closest to the production start date is acquired. Next, the type determination means 12092 compares the latest purchase record date information with the latest production record date information, and the date indicated by the latest production record date information is closer to the production start date than the date indicated by the latest purchase record date information. The part is determined to be manufactured in-house, and if the date indicated by the latest purchase record date information is closer to the production start date than the date indicated by the latest record record date information, the part is determined to be outsourced. . Note that the algorithm for determining the type by the type determining unit 12092 may be another algorithm. In other words, any type determination algorithm that matches the way the parts are used at the manufacturing site may be used.

The configuration table configuration unit 1210 includes a line completion item identifier included in the configuration table output instruction received by the reception unit 1204, one or more configuration item identifiers acquired by the configuration item identifier acquisition unit 1206, and the configuration determined by the type determination unit 1209. A composition table is configured based on the type of item identifier. The configuration table includes information on all parts constituting the product identified by the line completion item identifier, information on the hierarchical relationship between the products and parts, and information on the types of products and parts.
The configuration table output unit 1211 outputs the configuration table configured by the configuration table configuration unit 1210 in such a manner that the type of part can be visually clearly indicated. The output here is usually transmission. Transmission is transmission to the information processing terminal 11. When the product information management device 12 is configured as a stand-alone, the output includes a concept including display on a display, printing on a printer, sound output, transmission to an external device, and the like. The configuration table output unit 1211 can be realized by wireless or wired communication means. When the product information management apparatus 12 is configured in a stand-alone manner, the configuration table output unit 1211 can be realized by driver software for an output device such as a display or driver software and output device for an output device.

The finished product production date information acquisition unit 1205, the component item identifier acquisition unit 1206, the component purchase result date information acquisition unit 1207, the component production result date information acquisition unit 1208, the type determination unit 1209, and the configuration table configuration unit 1210. The production start date calculating unit 12091 and the type determining unit 12092 can be usually realized by an MPU, a memory, or the like. The processing procedure of each component is usually realized by software, and the software is recorded on a recording medium such as a ROM. However, it may be realized by hardware (dedicated circuit).
Hereinafter, the operation of the information processing system will be described. First, the operation of the information processing terminal 11 will be described using the flowchart of FIG.

(Step S301) The input reception unit 1101 is a configuration table output instruction which is an instruction to output a configuration table indicating the correspondence between products and parts, and whether or not an input of a configuration table output instruction having a line completion item identifier has been received. Judging. If a configuration table output instruction is accepted, the process goes to step S302, and if a configuration table output instruction is not accepted, the process returns to step S301.
(Step S302) The control unit 1105 passes the configuration table output instruction received in step S301 to the configuration table output instruction transmission unit 1102, and instructs the configuration table output instruction transmission unit 1102 to transmit the configuration table output instruction.

(Step S303) The configuration table output instruction transmission unit 1102 configures a configuration table output instruction to be transmitted. The configuration of the configuration table output instruction to be transmitted is to configure the data structure of the configuration table output instruction to be transmitted based on the instruction received in step S301.
(Step S304) The configuration table output instruction transmission unit 1102 transmits the configuration table output instruction configured in step S303 to the product information management apparatus 12.

(Step S305) The configuration table receiving unit 1103 determines whether or not a configuration table has been received from the product information management apparatus 12. If the configuration table is received, the process proceeds to step S306. If the configuration table is not received, the process returns to step S305. Here, timeout processing may be performed. The timeout process is a process of displaying an error panel when the configuration table is not received for a predetermined time or longer. The configuration table received from the product information management apparatus 12 is the original data of the configuration table to be displayed.
(Step S306) The control unit 1105 passes the configuration table received in step S305 to the configuration table display unit 1104, and instructs the configuration table display unit 1104 to display the configuration table.
(Step S307) The configuration table display unit 1104 configures a configuration table to be displayed from the information passed in step S306. For example, the configuration table display unit 1104 configures graphic data of a hierarchical structure of products / parts.
(Step S308) The configuration table display unit 1104 displays the configuration table configured in step S307. The process returns to step S301.
In the flowchart of FIG. 3, the process ends when the power is turned off or the process is terminated.
Next, the operation of the product information management apparatus 12 will be described using the flowchart of FIG.

(Step S401) The receiving unit 1204 determines whether a configuration table output instruction having a line completion item identifier has been received. If a configuration table output instruction is accepted, the process proceeds to step S402. If a configuration table output instruction is not accepted, the process returns to step S401. The reception of the configuration table output instruction here means reception of the configuration table output instruction.
(Step S402) The finished product production date information acquisition unit 1205 acquires the line finished product identifier included in the configuration table output instruction received in Step S401.
(Step S403) The finished product production record date information acquisition unit 1205 acquires the production record date information paired with the line completed item identifier acquired in step S402 from the production record data storage unit 1201.

  (Step S404) The production start date calculation unit 12091 calculates the production start date based on the production result date information acquired in step S403. The production start date is the date from which product production starts. The production start date does not always coincide with the production start date. For example, the production start date calculation unit 12091 calculates the production start date as “production result date—one day”.

(Step S405) The configuration item identifier acquisition unit 1206 obtains the configuration item identifier of the part descendant of the product identified by the line completion item identifier included in the configuration table output instruction received by the reception unit 1204 from the product configuration data storage unit 1203. All the component item identifiers are temporarily stored in the buffer. A function that performs such processing is called a “descendant item acquisition” function, and the operation of the function will be described with reference to the flowchart of FIG. The “descendant item acquisition” function is a function for obtaining an identifier of a descendant item when an identifier of the parent item is given.
(Step S406) The type determining unit 12092 substitutes 1 for the counter i.

(Step S407) The type determining unit 12092 determines whether or not the item identifier of the i-th part exists in the buffer (the buffer storing all the component item identifiers in Step S405). If the item identifier of the i-th part exists, the process goes to step S408, and if the item identifier of the i-th part does not exist, the process jumps to step S415.
(Step S408) The component purchase record date information acquisition unit 1207 acquires all purchase record date information paired with the i-th item identifier. The type determining means 12092 is purchase result date information indicating a date before the production start date among the purchase result dates indicated by the one or more purchase result date information, and the most recent production start date. Get the latest purchase record date information that is the nearest day.

(Step S409) The component production record date information acquisition unit 1208 acquires all the production record date information paired with the i-th item identifier. Then, the type determining unit 12092 is the production result date information indicating the date before the production start date among the one or more production result date information, and the latest production result date information that is the date closest to the production start date. To get.
(Step S410) The type determining means 12092 compares the latest purchase record date information with the latest production record date information, and the date indicated by the latest purchase record date information is determined to be the production start date from the date indicated by the latest production record date information. Judge whether it is close or not. If the date indicated by the latest purchase record date information is closer to the production start date than the date indicated by the latest production record date information, the process goes to step S411, and otherwise, the process jumps to step S414.
(Step S411) The type determining unit 12092 substitutes information indicating “subcontract production” into the type information that is information indicating the type.

(Step S412) The type determining unit 12092 records the type information in association with the configuration item identifier. This recording is, for example, recording “0” or “1” as a flag attached to each line completed item identifier of the record constituting the product configuration data. In this case, for example, when the flag is “0”, it is “external production”, and when it is “1”, it is “in-house production”.
(Step S413) The counter i is incremented by one. The process returns to step S407.
(Step S414) The type determining unit 12092 substitutes information indicating “in-house production” into the type information that is information indicating the type. Go to step S412.

(Step S415) The configuration table configuration unit 1210 includes a line completion item identifier included in the configuration table output instruction received by the reception unit 1204, a configuration item identifier that matches the line completion item identifier, and the configuration determined by the type determination unit 1209. A composition table is configured based on the type of item identifier. Specifically, for example, the configuration table configuration unit 1210 has a hierarchical structure based on the product configuration data and the type information recorded in step S412 and can visually specify the type of product or part. Construct a hierarchical diagram of the aspects.
(Step S416) The configuration table output unit 1211 transmits the configuration table configured in step S415 to the information processing terminal 11. The process returns to step S401.

  In the flowchart of FIG. 4, the process ends when the power is turned off or the process ends. Further, in the flowchart of FIG. 4, there may be a part that does not need to determine whether the type is in-house production or outsourced production. The processing from step S408 to step S412 in FIG. 4 is not performed for such a part. Further, such a component is the lowest component in the hierarchical component structure.

Next, the operation of the component item identifier acquisition unit 1206 of the product information management apparatus 12 will be described using the flowchart of FIG. The configuration item identifier acquisition unit 1206 acquires one or more configuration item identifiers of the descendant parts of the product identified by the line completion item identifier included in the received configuration table output instruction from the product configuration data storage unit 1203. Note that the argument of the function that realizes this flowchart is a line completion item identifier (parent identifier).
(Step S501) 1 is substituted into the counter j.

(Step S502) It is determined whether or not the j-th line completed item identifier exists in the product configuration data storage unit 1203. If the j-th line completed item identifier exists, the process goes to step S503, and if the j-th line completed item identifier does not exist, the process returns to the upper function.
(Step S503) It is determined whether or not the j-th line completed item identifier matches the argument line completed item identifier. If they match, the process goes to step S504, and if they do not match, the process jumps to step S506.
(Step S504) A component item identifier corresponding to the j-th line completed item identifier is acquired and temporarily stored in a buffer.
(Step S505) The “descendant item acquisition” function is called with the component item identifier temporarily stored in the buffer in step S504 as the parent identifier (argument).
(Step S506) The counter j is incremented by one. Go to step S502.
Hereinafter, a specific operation of the information processing system in the present embodiment will be described. A conceptual diagram of the information processing system is shown in FIG.

Now, the production performance data storage unit 1201 holds the production performance data management table shown in FIG. The purchase record data storage unit 1202 holds a purchase record data management table shown in FIG. Further, the product configuration data storage unit 1203 holds a product configuration data management table shown in FIG. The production result data management table manages one or more records (production result data) having “ID”, “line completed item identifier”, “production result date information”, and “production number information”. The purchase record data management table manages one or more records (purchase record data) having “ID”, “purchase item identifier”, “purchase record date information”, and “purchase quantity information”. The product configuration data management table manages one or more records (product configuration data) having “ID”, “line completed item identifier”, and “configuration item identifier”. The “ID” of each table is information for identifying a record, and exists for a request in table management. Although not specifically shown in FIG. 6 to FIG. 8, in the case of this example, in order to simplify the explanation, the parent product or part uses only one child part. .

In this situation, it is assumed that the user gives an instruction to output a configuration table from the screen of the information processing terminal 11 as shown in FIG. In FIG. 9, it is assumed that the user inputs a complete product number “main item x” and presses an “output” button. The finished product number is product identification information and is the same information as the line finished product identifier.
Next, the information processing terminal 11 configures a configuration table output instruction having a line completion item identifier of “main item x”. Then, the information processing terminal 11 transmits the configuration table output instruction to the information processing terminal 11.

  Next, the receiving unit 1204 of the product information management apparatus 12 receives a configuration table output instruction having a line completion item identifier “main item x”. Then, the finished product production date information acquisition unit 1205 acquires a line finished item identifier “main item x” from the received configuration table output instruction. Then, the finished product production record date information acquisition unit 1205 acquires the production record date information “2004/4/4” paired with “main item x” from the production record data table of FIG. Then, the production start date calculation unit 12091 calculates the date “2004/4/3” one day before as the production start date from the production result date information “2004/4/4”.

Next, the configuration item identifier acquisition unit 1206 acquires the configuration item identifier of the descendant part of the product identified by the line completion item identifier from the product configuration data management table of FIG. Here, the identifiers acquired by the component item identifier acquisition unit 1206 are seven identifiers of “parent item a” “item c” “parent item f” “item g” “item d” “item e” “item h”. is there. That is, the constituent item identifier acquisition unit 1206 recursively acquires the identifier of the child item based on “main item x”.
Next, the type determination unit 12092 determines whether the part identified by the seven identifiers is in-house production or outsourced production, and whether or not the determination is necessary.

  First, the type determining unit 12092 determines “parent item a” as follows. The component purchase record date information acquisition unit 1207 acquires all purchase record date information paired with “parent item a” from the purchase record date information management table of FIG. Here, the purchase record date information acquired by the component purchase record date information acquisition unit 1207 is “2004/4/1” of “ID = 1” and “2004/3/25” of “ID = 3”. It is. The type determination means 12092 is purchase record date information indicating a date before the production start date among one or more purchase record dates “2004/4/1” and “2004/3/25”, and The latest purchase record date information “2004/4/1” which is the date closest to the production start date is acquired.

Next, the component production record date information acquisition unit 1208 acquires all the production record date information paired with the “parent item a” from the production record date information management table of FIG. Here, the production record date information acquired by the component production record date information acquisition unit 1208 is “2004/3/31” of “ID = 2” and “2004/3/27” of “ID = 4”. . The type determining means 12092 is production performance date information indicating a date before the production start date among the one or more production performance date information “2004/3/31” and “2004/3/27”, and The latest production performance date information “2004/3/31” which is the date closest to the production start date is acquired.
Next, the type determining means 12092 compares the latest purchase record date information “2004/4/1” with the latest production record date information “2004/3/31”, and the date indicated by the latest purchase record date information is the latest. It is determined that it is closer to the production start date “2004/4/3” than the date indicated by the production result date information. Therefore, the type determining unit 12092 determines that the “parent item a” is “outsourced production”. Then, the type determination unit 12092 records “0” in the type information corresponding to the component item identifier “parent item a” in FIG.

Next, the type determining unit 12092 determines “item c” as follows. That is, since there is neither purchase record date information having the identifier of “item c” nor production record date information, the type determining unit 12092 does not need to determine whether “item c” is in-house production or subcontract production. It is determined that there is, and “-” is recorded in the type information (see FIG. 10).
Next, the type determining unit 12092 determines “parent item f” as follows. The component purchase record date information acquisition unit 1207 acquires all purchase record date information paired with the “parent item f” from the purchase record date information management table of FIG. Here, the purchase record date information acquired by the component purchase record date information acquisition unit 1207 is only “2004/3/31” of “ID = 2”. The type determining means 12092 then obtains the latest purchase record date information “2004/31” because the purchase record date “2004/3/31” is purchase record date information indicating the date before the production start date. 3/31 ".

  Next, the component production record date information acquisition unit 1208 acquires all the production record date information paired with the “parent item f” from the production record date information management table of FIG. Here, the production result date information acquired by the component production result date information acquisition unit 1208 is only “2004/4/1” of “ID = 3”. The type determining means 12092 then displays the latest production result date information “2004/4/1” because the production result date information “2004/4/1” is production result date information indicating the date before the production start date. 1 ”.

Next, the type determining unit 12092 compares the latest purchase record date information “2004/3/31” with the latest production record date information “2004/4/1”, and the date indicated by the latest production record date information is the latest record. It is determined that it is closer to the production start date “2004/4/3” than the date indicated by the entry result date information. Then, the type determination unit 12092 records “1” in the type information corresponding to the component item identifier “parent item f” in FIG. 10 (see FIG. 10).
Similarly to the processing of “item c”, the type determining unit 12092 records “−” in the type information of “item g”, “item d”, “item e”, and “item h” (see FIG. 10). ).
Thus, the information for creating the configuration table as shown in FIG. 10 is completed. The “line completed item identifier” and “configuration item identifier” in FIG. 10 can be acquired from the product configuration data management table in FIG.

Next, the configuration table configuration unit 1210 configures a parts hierarchy table for the product “main item x” from the intermediate table (also referred to as a configuration table) in FIG. 10. Then, the configuration table output unit 1211 transmits the configured configuration table to the information processing terminal 11. Note that the information transmitted to the information processing terminal 11 may be the information shown in FIG. 10 or the information showing the hierarchical relationship shown in FIG.
Next, the configuration table receiving unit 1103 of the information processing terminal 11 receives the configuration table (for example, the information in FIG. 10) from the product information management device 12. Based on the information of the configuration table, the configuration table display unit 1104 displays a hierarchical diagram of products and parts as shown in FIG. In the hierarchy diagram of products and parts (output example of the configuration table here), the parts for outsourced production are shown with a thick frame, and the parts produced in-house are shown with shading. Therefore, in FIG. 11, it can be said that the types of parts constituting the product are output in a form that can be visually clearly indicated.

As described above, according to the present embodiment, when outputting a configuration table indicating a hierarchy of parts constituting a product, by clearly indicating whether the part is a self-produced part or an outsourced part, for example, When a problem occurs, the next steps such as quality improvement can be easily performed.
According to the present embodiment, the information processing system is a server / client system, but may be a stand-alone system. In such a case, the reception unit of the product information management apparatus receives user input, and the configuration table output unit displays or prints the configuration table.
Further, according to the specific example of the present embodiment, the configuration table example has a hierarchical structure as shown in FIG. 11, but the table format shown in FIG. 10 or other hierarchical structure is also shown. Etc.

  Further, according to the specific example of the present embodiment, the product itself is determined to be in-house production, but the product information management device 12 determines whether the product itself (for example, “main item x” above) is in-house production or subcontracting. It may be configured to determine whether it is production. The same applies to other embodiments.

  Further, according to the present embodiment, after the receiving unit 1204 receives the configuration table output instruction, the component type is determined and the configuration table is configured, but the type is determined in advance or the configuration table is configured. It may be. In such a case, the product information management apparatus 12 only outputs the stored configuration table when the reception unit 1204 receives a configuration table output instruction.

  Furthermore, the processing in the present embodiment may be realized by software. Then, this software may be distributed by software download or the like. Further, this software may be recorded and distributed on a recording medium such as a CD-ROM. This also applies to other embodiments in this specification. Note that the software that implements the product information management apparatus according to the present embodiment is the following program. That is, the program is a configuration table output instruction that is an instruction to output a configuration table indicating a correspondence relationship between products and parts to a computer, and a reception step of receiving a configuration table output instruction having a line completed item identifier; The finished product production date information acquisition step for obtaining the production result date information paired with the line completed item identifier included in the composition table output instruction received in the step from the stored production result data, and received in the reception step. A configuration item identifier acquisition step of acquiring one or more configuration item identifiers of the descendant parts of the product identified by the line completion item identifier included in the configuration table output instruction from stored product configuration data, and the configuration item identifier acquisition step That store the purchase date information that is paired with the purchase item identifier that matches the component identifier obtained in The actual production date information that is paired with the line item identifier that matches the component item identifier acquired in the component item acquisition date information acquisition step and the component item identifier acquisition step stored from the input result data is stored. Component production result date information acquisition step acquired from production result data, production result date information acquired in the finished product production result date information acquisition step, and purchase result acquired in the component purchase result date information acquisition step Based on the date information and the production result date information acquired in the component production result date information acquisition step, the part identified by the component item identifier acquired in the component item identifier acquisition step is in-house production or subcontracted production A type determining step for determining a type indicating whether there is a line, a line completed item identifier included in the configuration table output instruction received in the receiving step, Based on the one or more configuration item identifiers acquired in the configuration item identifier acquisition step and the type of the configuration item identifier determined in the type determination step, the configuration table configuration step for configuring the configuration table, and the configuration table configuration step It is a program for executing a configuration table output step for outputting a configured configuration table in a form in which the types of parts can be visually clearly specified.

The type determination step includes a production start date calculation sub-step for calculating a production start date based on the production record date information acquired in the finished product production record date information acquisition step, the production start date, and the component purchase. Based on the purchase record date information acquired in the record date information acquisition step and the record record date information acquired in the component production record date information acquisition step, the component item identifier acquired in the component item identifier acquisition step is identified. A configuration having a type determining sub-step for determining a type indicating whether the part to be manufactured is in-house production or outsourced production is preferable.
(Embodiment 2)

  In the present embodiment, a description will be given of a mode in which it is automatically determined whether the parts constituting the product are in-house production or outsourced production, and cost calculation with high accuracy is performed. The hardware configuration diagram of the information processing system in the present embodiment is the same as the configuration shown in FIG.

FIG. 12 is a block diagram of the information processing system in the present embodiment. The information processing system includes an information processing terminal 121 and a product information management device 122. The information processing terminal 121 includes an input reception unit 12101, an instruction transmission unit 12102, a cost information reception unit 12103, a cost information display unit 12104, and a control unit 12105.
The product information management device 122 includes a production result data storage unit 1201, a purchase result data storage unit 1202, a product configuration data storage unit 1203, a processing cost data storage unit 12201, a material cost data storage unit 12202, a reception unit 12203, and a finished product production. Actual date information acquisition unit 1205, component item identifier acquisition unit 1206, component purchase result date information acquisition unit 1207, component production result date information acquisition unit 1208, type determination unit 1209, type storage unit 12204, cost acquisition unit 12205, A cost calculation unit 12206 and a cost information output unit 12207 are provided. The type determination unit 1209 includes a production start date calculation unit 12091 and a type determination unit 12092.

The input receiving unit 12101 receives an input of an actual cost output instruction that is an instruction to output the actual cost of the product and part identified by the line completed item identifier. The actual cost output instruction has a line completed item identifier. The input means may be anything such as a numeric keypad, keyboard, mouse or menu screen. The input receiving unit 12101 can be realized by a device driver of input means such as a numeric keypad or a keyboard, control software for a menu screen, and the like.
The instruction transmission unit 12102 transmits the actual cost output instruction received by the input reception unit 12101 to the product information management apparatus 122. The instruction transmission unit 12102 can be realized by a wireless or wired communication unit or the like.

The cost information receiving unit 12103 receives cost information, which is information indicating the cost of the product identified by the line completed item identifier included in the actual cost output instruction, from the product information management apparatus 12. The cost information receiving unit 12103 can be realized by wireless or wired communication means. Usually, the instruction transmitting unit 12102 and the cost information receiving unit 12103 are usually realized by one communication means.
The cost information display unit 12104 displays the cost information received by the cost information receiving unit 12103. The display mode of the cost information in the cost information display unit 12104 is not questioned. A specific display mode of cost information in the cost information display unit 12104 will be described later. The cost information display unit 12104 may be considered as including or not including a display. The cost information display unit 12104 can be realized by display device driver software or display device driver software and a display device.

  The control unit 12105 passes the actual cost output instruction received by the input receiving unit 12101 to the instruction transmitting unit 12102, and passes the cost information received by the cost information receiving unit 12103 to the cost information display unit 12104. The control unit 12105 can be usually realized by an MPU, a memory, or the like. The processing procedure of the control unit 1105 is usually realized by software, and the software is recorded on a recording medium such as a ROM. However, it may be realized by hardware (dedicated circuit).

The processing cost data storage unit 12201 includes an in-house processing cost information that is information regarding an in-house processing cost that is a cost when the product or part identified by the line completed item identifier is produced in-house, One or more pieces of processing cost data having external production cost information, which is information related to external production costs, which are costs when the product or part identified by the line finished item identifier is outsourced, are stored. The processing cost data storage unit 12201 is preferably a nonvolatile recording medium, but can also be realized by a volatile recording medium.
The material cost data storage unit 12202 stores one or more material cost data having a component item identifier and material cost information that is information related to the material cost of the part identified by the component item identifier. The material cost data storage unit 12202 is preferably a nonvolatile recording medium, but can also be realized by a volatile recording medium.

The receiving unit 12203 is an actual cost output instruction that is an instruction to output the actual cost of the product and part identified by the line completed item identifier, and receives an actual cost output instruction having the line completed item identifier. The reception here is usually reception. However, when the product information management apparatus 122 is realized as a stand-alone, the receiving unit 12203 is a unit that receives an input from the user. The accepting unit 1204 can be realized by, for example, a wireless or wired communication unit.

  The type storage unit 12204 is configured to identify a part constituting the product or part identified by the line completed item identifier included in the production result data stored in the production result data storage unit 1201 with the type determined by the type determination unit 1209 It accumulates in association with the item identifier. The recording medium in which the type storage unit 12204 stores the type information may be a recording medium built in the product information management apparatus 122 or an external recording medium. The type storage unit 12204 can usually be realized by an MPU, a memory, or the like. The information storage processing procedure of the type storage unit 12204 is usually realized by software, and the software is recorded in a recording medium such as a ROM. However, it may be realized by hardware (dedicated circuit).

  The cost acquisition unit 12205 acquires one or more configuration item identifiers acquired by the configuration item identifier acquisition unit 1206 or a type corresponding to the line completion item identifier included in the one or more configuration item identifiers and actual cost output instructions, Based on the type, each component item identifier, or the processing cost or material cost of the part or product identified by each component item identifier and line finished item identifier is acquired from the processing cost data storage unit 12201 or the material cost data storage unit 12202 To do. The cost acquisition unit 12205 can usually be realized by an MPU, a memory, or the like. The processing procedure of the cost acquisition unit 12205 is usually realized by software, and the software is recorded in a recording medium such as a ROM. However, it may be realized by hardware (dedicated circuit).

  The cost calculation unit 12206 calculates the cost of the product identified by the line completion item identifier included in the actual cost output instruction based on the cost acquired by the cost acquisition unit 12205. The cost calculation unit 12206 normally calculates the product cost by adding up the processing costs and material costs of all parts and products acquired by the cost acquisition unit 12205. The cost calculation unit 12206 can be usually realized by an MPU, a memory, or the like. The processing procedure of the cost calculation unit 12206 is usually realized by software, and the software is recorded on a recording medium such as a ROM. However, it may be realized by hardware (dedicated circuit).

The cost information output unit 12207 outputs cost information that is information on the cost calculated by the cost calculation unit 12206. Here, the output is usually transmission to the information processing terminal 121. Note that when the product information management device 122 is a stand-alone device, the output includes display on a display, printing on a printer, transmission to an external device, and the like. The cost information output unit 12207 can be realized by, for example, a wireless or wired communication unit.
Hereinafter, the operation of the information processing system will be described. First, the operation of the information processing terminal 121 will be described using the flowchart of FIG.

(Step S1301) The input receiving unit 12101 is an actual cost output instruction that is an instruction to output the actual cost of the product and part identified by the line completed item identifier, and inputs an actual cost output instruction having the line completed item identifier. It is determined whether or not it has been accepted. If an actual cost output instruction is accepted, the process goes to step S1302, and if an actual cost output instruction is not accepted, the process returns to step S1301.
(Step S1302) The control unit 12105 passes the actual cost output instruction received in step S1301 to the instruction transmission unit 12102, and instructs the instruction transmission unit 12102 to transmit the actual cost output instruction.

(Step S1303) The instruction transmission unit 12102 constitutes an actual cost output instruction to be transmitted. The configuration of the actual cost output instruction to be transmitted is to configure the data structure of the actual cost output instruction to be transmitted based on the instruction received in step S1301.
(Step S1304) The instruction transmission unit 12102 transmits the actual cost output instruction configured in step S1303 to the product information management apparatus 122.

(Step S1305) The cost information receiving unit 12103 determines whether or not cost information, which is information indicating the cost of the product identified by the line completed item identifier included in the actual cost output instruction, has been received from the product information management device 122. . If the cost information is received, the process goes to step S1306. If the cost information is not received, the process returns to step S1305. Here, timeout processing may be performed. The timeout process is a process of displaying an error panel when the configuration table is not received for a predetermined time or longer.
(Step S1306) The control unit 12105 passes the cost information received in step S1305 to the cost information display unit 12104 and instructs the cost information display unit 12104 to display the cost information.
(Step S1307) The cost information display unit 12104 displays the cost information passed in step S1306. The process returns to step S1301.
In the flowchart of FIG. 13, the process is terminated by powering off or a process termination interrupt.
Next, the operation of the product information management apparatus 122 will be described using the flowchart of FIG. The description of the same steps as those in the flowchart of FIG. 4 is omitted.
(Step S1401) The cost of the product identified by the line completion item identifier included in the actual cost output instruction is calculated. Details of the cost calculation operation will be described with reference to the flowchart of FIG.
(Step S1402) The cost information output unit 12207 outputs cost information that is information on the cost calculated in step S1401. The output here is transmission to the information processing terminal 121. The process returns to step S401.
Next, the operation in which the product information management apparatus 122 calculates the cost will be described with reference to the flowchart of FIG.
(Step S1501) Initialization is performed. Initialization means substituting 0 into cost information.
(Step S1502) The expense acquisition unit 12205 acquires the line completed item identifier included in the actual cost output instruction received by the reception unit 12203.

(Step S1503) The expense acquisition unit 12205 acquires type information indicating the type of the line completion item identifier acquired in Step S1502. The type of the line completion item identifier is usually in-house production. If it is not in-house production, there is a flag indicating that it is outsourced production in the received actual cost output instruction, or there is predetermined information in other data (for example, purchase performance data), etc. It can be judged from.
(Step S1504) The cost acquisition unit 12205 determines whether or not the type acquired in step S1503 is in-house production. If it is in-house production, it goes to step S1505, and if it is not in-house production, it jumps to step S1506. If it is not in-house production, it is outsourced production.

(Step S1505) The cost acquisition unit 12205 acquires the in-house processing cost information corresponding to the line completion item identifier acquired in step S1503 as a price. This in-house manufacturing cost information is acquired from the processing cost data storage unit 12201.
(Step S1506) The cost acquisition unit 12205 acquires the external production cost information corresponding to the line completion item identifier acquired in Step S1503 as a price. This external manufacturing cost information is acquired from the processing cost data storage unit 12201.
(Step S1507) The cost calculation unit 12206 adds the price to the cost information.

(Step S1508) The component item identifier acquisition unit 1206 acquires one or more component item identifiers indicating the parts constituting the product identified by the line completion item identifier included in the received actual cost output instruction, and stores them in the buffer. The parts constituting the product may be hierarchical. If the parts are hierarchical, the component item identifier acquisition unit 1206 acquires the component item identifiers of all the parts lower in the hierarchy. Since this process has been described above, a detailed description thereof will be omitted.
(Step S1509) 1 is substituted into the counter i.

(Step S1510) The cost acquisition unit 12205 determines whether or not the i-th component item identifier exists in the buffer (the buffer that stores the component item identifier in step S1508). If the i-th component item identifier exists, the process proceeds to step S1511. If the i-th component item identifier does not exist, the process returns. When returning, the cost information is returned to the process of the flowchart of FIG.
(Step S1511) The expense acquisition unit 12205 acquires the i-th component item identifier from the buffer.
(Step S1512) The expense acquisition unit 12205 acquires type information corresponding to the i-th component item identifier.
(Step S1513) It is determined whether or not the type indicated by the type information acquired in step S1512 is in-house production. If it is in-house production, it goes to step S1514, and if it is not in-house production, it jumps to step S1515.
(Step S1514) The cost acquisition unit 12205 acquires in-house processing cost information corresponding to the i-th component item identifier from the processing cost data storage unit 12201 as a price. The process jumps to step S1518.
(Step S1515) It is determined whether or not the type indicated by the type information acquired in step S1512 is outsourced production. If it is outsourced production, it will go to step S1516, and if it is not outsourced production, it will jump to step S1517.
(Step S1516) The cost acquisition unit 12205 acquires the external production cost information corresponding to the i-th component item identifier from the processing cost data storage unit 12201 as a price. The process jumps to step S1518.
(Step S1517) The cost acquisition unit 12205 acquires the material cost data corresponding to the i-th component item identifier from the material cost data storage unit 12202 as a price.
(Step S1518) The cost calculation unit 12206 adds the price acquired by the cost acquisition unit 12205 to the cost information.
(Step S1519) The cost calculation unit 12206 increments the counter i by one. The process returns to step S1510.
Hereinafter, a specific operation of the information processing system in the present embodiment will be described. A conceptual diagram of the information processing system is shown in FIG.

  Now, the production performance data storage unit 1201 holds the production performance data management table shown in FIG. The purchase record data storage unit 1202 holds a purchase record data management table shown in FIG. Further, the product configuration data storage unit 1203 holds a product configuration data management table shown in FIG.

The machining cost data storage unit 12201 holds a machining cost data management table shown in FIG. Further, the material cost data storage unit 12202 holds a material cost data management table shown in FIG. The processing cost data management table has one or more records having “ID”, “line completed item identifier”, “in-house manufacturing cost information”, and “external manufacturing cost information”. “In-house processing cost information” is information indicating processing cost in the case of in-house manufacturing, and is processing cost per unit (unit: yen / piece). “Outside manufacturing cost information” is information indicating processing cost in the case of outsourced production, and is processing cost per unit (unit: yen / piece). The material cost data management table has one or more records having “ID”, “component identifier”, and “material cost data”. The “configuration item identifier” is an identifier of a part constituting the product. “Material cost data” is information (unit: yen / piece) indicating the price of the material cost of a part.

Further, the product information management apparatus 122 determines the type of the part (part identified by the component item identifier) constituting the product identified by the line completed item identifier by the processing shown in the first embodiment, and FIG. The table is obtained. The recording timing of the type information in such a table is not limited.
In this case, the user inputs an actual cost output instruction having the line completed item identifier “main item x” from the “actual cost configuration master inquiry (model selection)” screen shown in FIG. 18 and presses the “inquiry” button. , And.
Next, the input reception unit 12101 of the information processing terminal 121 receives an actual cost output instruction having the line completion item identifier “main item x”, and the instruction transmission unit 12102 has an actual result having the line completion item identifier “main item x”. A cost output instruction is transmitted to the product information management device 122.

Next, the reception unit 12203 of the product information management apparatus 122 receives the actual cost output instruction having the line completion item identifier “main item x”. Since “main item x” is in-house production, the cost acquisition unit 12205 acquires in-house processing cost information “250” corresponding to “main item x” from the processing cost data management table. Then, the cost calculation unit 12206 adds “250” to the cost information and sets the cost information to “250”.
Next, the component item identifier acquisition unit 1206 includes descendant identifiers “parent item a”, “item c”, “parent item f”, “item g”, “item d”, and “item e” of the line completed item identifier “main item x”. "Item h" is acquired and temporarily stored in the buffer.

Next, the expense acquisition unit 12205 acquires the type information “0” corresponding to “parent item a” from the table of FIG. Since the type information “0” is outsourced production, the cost acquisition unit 12205 acquires the outsourcing cost information “21” corresponding to the “parent item a” from the processing cost data management table. The cost calculation unit 12206 adds the outsourcing cost information “21” to the cost information “250” to obtain the cost information “271”.
Next, the expense acquisition unit 12205 acquires the type information “-” corresponding to “item c” from the table of FIG. Since the type information “-” is neither outsource production nor in-house production, the cost acquisition unit 12205 acquires material cost data “5” corresponding to “item c” in the material cost data management table. Next, the cost calculation unit 12206 adds the material cost data “5” to the cost information “271” to obtain cost information “276”.

  Next, the expense acquisition unit 12205 acquires the type information “1” corresponding to the “parent item f” from the table of FIG. Since the type information “1” is in-house production, the cost acquisition unit 12205 acquires in-house processing cost information “10” corresponding to “parent item f” from the processing cost data management table. The cost calculation unit 12206 adds the in-house manufacturing cost information “10” to the cost information “276” to obtain cost information “286”.

  Furthermore, the expense acquisition unit 12205 and the like repeat the following processing for “item g”, “item d”, “item e”, and “item h”. That is, the expense acquisition unit 12205 acquires the type information “−” corresponding to “item g” or the like from the table of FIG. Since the type information “-” is neither outsource production nor in-house production, the cost acquisition unit 12205 acquires material cost data corresponding to the item from the material cost data management table. Then, the cost calculation unit 12206 adds the material cost data to the cost information. Finally, the cost calculation unit 12206 obtains cost information “315”. Further, the cost information is not necessarily only information indicating the cost of the product. For example, the cost information may include cost data indicating the cost of the entire product and processing cost data indicating the processing cost in the cost. In such a case, the cost calculation unit 12206 configures cost information shown in FIG. 19, for example. The cost information shown in FIG. 19 includes cost data indicating the cost of the entire product and processing cost data indicating the processing cost in the cost.

  Next, the cost information output unit 12207 transmits the cost information in FIG. 19 to the information processing terminal 121. Next, the cost information receiving unit 12103 receives the cost information of FIG. The cost information display unit 12104 displays the cost information of FIG. An example of the display mode is shown in FIG. In FIG. 20, the actual material cost amount is the cost of the product (processing cost + material cost, etc.). The internal processing cost is a product processing cost.

As described above, according to this embodiment, the cost of a product can be calculated with high accuracy. In other words, by automatically determining whether the parts that make up the product are in-house manufactured parts or outsourced parts, the cost considering the type of parts (whether in-house or outsourced production) Calculation is possible. Outsourced parts are generally cheaper than in-house manufactured parts due to increased transportation costs.
According to the present embodiment, the information processing system is a server / client system, but may be a stand-alone system.
In the present embodiment, the type of the product itself (whether it is in-house production or outsourced production) is judged, and the cost may vary depending on the type, and the product itself is determined in advance to be in-house production. May be.

  Furthermore, the software that implements the product information management apparatus according to the present embodiment is the following program. In other words, this program is an actual cost output instruction that is an instruction to output the actual cost of the product and part identified by the line completion item identifier to the computer, and a reception step of receiving the actual cost output instruction having the line completion item identifier And a finished product production date information acquisition step for obtaining production result date information paired with a line completed item identifier included in the actual cost output instruction received in the reception step from the stored production result data, and the reception A component item identifier acquisition step for acquiring one or more component item identifiers of the descendant parts of the product identified by the line completion item identifier included in the actual cost output instruction received in the step from the stored product configuration data; The item paired with the purchased item identifier that matches the component identifier acquired in the item identifier acquisition step The actual purchase date information is paired with the component purchase actual date information acquisition step acquired from the stored purchase actual data, and the line completed item identifier matching the component item identifier acquired in the configuration item identifier acquisition step. The production result date information acquisition step for acquiring the production result date information from the stored production result data, the production result date acquired in the finished product production date information acquisition step, and the component purchase result Based on the purchase record date information acquired in the date information acquisition step and the production record date information acquired in the component production record date information acquisition step, the component item identifier acquired in the component item identifier acquisition step is identified. The type determination step for determining the type indicating whether the part is in-house production or subcontract production, and the type determined in the type determination step are stored. A type accumulation step of accumulating in association with a component item identifier for identifying a part constituting a product or a part identified by a line completion item identifier included in production performance data, and one or more configurations acquired in the component item identifier acquisition step The type corresponding to the line identifier of the item identifier or the one or more component item identifiers and the actual cost output instruction is acquired, and each component item identifier or each component item identifier and the line completed item is acquired based on the type. Based on the cost acquisition step of acquiring the processing cost or material cost of the part or product identified by the identifier from the stored processing cost data or the stored material cost data, and the cost acquired in the cost acquisition step The raw cost for calculating the cost of the product identified by the line completion item identifier included in the actual cost output instruction A calculation step, a program for executing the cost information output step of outputting costs information as information cost calculated by the cost calculation step.

As described above, since the product information management apparatus according to the present invention can automatically determine whether a part used in manufacturing a product is in-house production or outsourced production, various measures are taken. It has the effect of facilitating and is useful as a product information management device that manages product information at the manufacturing site.

Hardware configuration diagram of information processing system according to Embodiment 1 Block diagram of the information processing system A flowchart for explaining the operation of the information processing terminal Flow chart for explaining the operation of the product information management apparatus Flow chart for explaining the operation of the product information management apparatus Figure showing the production data management table Figure showing the same purchase results data management table Figure showing the product configuration data management table The figure which shows the inquiry screen of the same user Figure showing an example of the same configuration table Figure showing an example of output of the same configuration table Block diagram of an information processing system in the second embodiment A flowchart for explaining the operation of the information processing terminal Flow chart for explaining the operation of the product information management apparatus Flowchart explaining the cost calculation operation of the product information management device Figure showing the processing cost data management table Figure showing the material cost data management table The figure which shows the inquiry screen of the same user Figure showing an example of the cost information Figure showing a display example of the same cost information

Explanation of symbols

DESCRIPTION OF SYMBOLS 11, 121 Information processing terminal 12, 122 Product information management apparatus 1101, 12101 Input reception part 1102 Configuration table output instruction transmission part 1103 Configuration table reception part 1104 Configuration table display part 1105 Control part 1201 Production result data storage part 1202 Purchase result data Storage unit 1203 Product configuration data storage unit 1204, 12203 Reception unit 1205 Completed product production result date information acquisition unit 1206 Configuration item identifier acquisition unit 1207 Component product purchase date information acquisition unit 1208 Component product performance date information acquisition unit 1209 Type determination Unit 1210 Configuration table configuration unit 1211 Configuration table output unit 12091 Production start date calculation unit 12092 Type determination unit 12102 Instruction transmission unit 12103 Cost information reception unit 12104 Cost information display unit 12105 Control unit 12201 Processing cost data storage unit 1220 Material cost data storage unit 12204 type storage unit 12205 cost acquisition unit 12206 cost calculator 12207 cost information output unit

Claims (7)

Line completed item identifier that is information for identifying the product to be produced or an item that is a part of the product, production actual date information that is information on the production actual date of the item identified by the line completed item identifier, and the number of products to be produced A production result data storage unit that stores one or more production result data having production number information that is information indicating
A purchase item identifier that is information for identifying a purchased part, purchase date information that is a date of purchase of an item identified by the purchase item identifier, and information that indicates the number of items purchased. A purchase record data storage unit that stores one or more purchase record data having purchase quantity information, and information indicating a product configuration, and a product identified by a line completed item identifier and the line completed item identifier A product configuration data storage unit that stores at least one product configuration data having a configuration item identifier that is information for identifying a component constituting the component;
A configuration table output instruction that is an instruction to output a configuration table indicating a correspondence relationship between a product and a part, and a reception unit that receives a configuration table output instruction having a line completion item identifier;
A finished product production date information acquisition unit that acquires production result date information paired with a line completion item identifier included in the configuration table output instruction received by the reception unit;
A configuration item identifier acquisition unit that acquires one or more configuration item identifiers of the descendant parts of the product identified by the line completion item identifier included in the configuration table output instruction received by the reception unit, from the product configuration data storage unit;
A component purchase result date information acquisition unit that acquires purchase result date information paired with a purchase item identifier that matches the configuration item identifier acquired by the configuration item identifier acquisition unit;
A component production result date information acquisition unit that acquires production result date information paired with a line completed item identifier that matches the configuration item identifier acquired by the component item identifier acquisition unit;
The production result date information acquired by the finished product production date information acquisition unit, the purchase result date information acquired by the component purchase result date information acquisition unit, and the component production result date information acquisition unit A type determination unit that determines a type indicating whether the part identified by the configuration item identifier acquired by the configuration item identifier acquisition unit is in-house production or subcontracted production based on production date information;
Based on the line completion item identifier included in the configuration table output instruction received by the reception unit, one or more configuration item identifiers acquired by the configuration item identifier acquisition unit, and the type of the configuration item identifier determined by the type determination unit A configuration table configuration unit that configures the configuration table,
A product information management apparatus comprising a configuration table output unit configured to output a configuration table configured by the configuration table configuration unit in a manner in which a type of a part can be visually specified. Line completed item identifier that is information for identifying the product to be produced or an item that is a part of the product, production actual date information that is information on the production actual date of the item identified by the line completed item identifier, and the number of products to be produced A production result data storage unit that stores one or more production result data having production number information that is information indicating
A purchase item identifier that is information for identifying a purchased part, purchase date information that is a date of purchase of an item identified by the purchase item identifier, and information that indicates the number of items purchased. A purchase record data storage unit that stores one or more purchase record data having purchase quantity information, and information indicating a product configuration, and a product identified by a line completed item identifier and the line completed item identifier A product configuration data storage unit that stores at least one product configuration data having a configuration item identifier that is information for identifying a component constituting the component;
The line completed item identifier, the in-house processing cost information that is information related to the in-house processing cost that is the cost when the product or part identified by the line completed item identifier is produced in-house, and the line completed item identifier A processing cost data storage unit that stores one or more processing cost data having external manufacturing cost information that is information related to external manufacturing costs that are costs when outsourcing products or parts;
A material cost data storage unit that stores one or more material cost data having material cost information that is information related to the material cost of the component identified by the component item identifier and the material cost of the component;
A reception unit that receives an actual cost output instruction that is an actual cost output instruction that is an instruction to output the actual cost of the product and part identified by the line completed item identifier; and
A finished product production date information acquisition unit that acquires production result date information that is paired with a line completed item identifier included in the actual cost output instruction received by the reception unit;
A configuration item identifier acquisition unit that acquires one or more configuration item identifiers of the descendant parts of the product identified by the line completion item identifier included in the actual cost output instruction received by the reception unit, from the product configuration data storage unit;
A component purchase result date information acquisition unit that acquires purchase result date information paired with a purchase item identifier that matches the configuration item identifier acquired by the configuration item identifier acquisition unit;
A component production result date information acquisition unit that acquires production result date information paired with a line completed item identifier that matches the configuration item identifier acquired by the component item identifier acquisition unit;
Production result date acquired by the finished product production date information acquisition unit, purchase result date information acquired by the component purchase result date information acquisition unit, and production acquired by the component product result date information acquisition unit A type determination unit that determines a type indicating whether the part identified by the configuration item identifier acquired by the configuration item identifier acquisition unit is in-house production or subcontracted production based on actual date information;
The type determined by the type determination unit is associated with a component identifier for identifying a part constituting a product or a part identified by a line completion item identifier included in the production result data stored in the production result data storage unit. A type storage unit for storing;
One or more component item identifiers acquired by the component item identifier acquisition unit, or a type corresponding to the one or more component item identifiers and a line completion item identifier included in the actual cost output instruction, and based on the type, A cost acquisition unit that acquires a processing cost or a material cost of a component item or a part or product identified by each configuration item identifier and a line completion item identifier from the processing cost data storage unit or the material cost data storage unit;
A cost calculating unit that calculates the cost of the product identified by the line completed item identifier included in the actual cost output instruction based on the cost acquired by the cost acquiring unit;
A product information management device comprising a cost information output unit that outputs cost information that is information on the cost calculated by the cost calculation unit. The type determining unit
A production start date calculating means for calculating a production start date based on the production record date information acquired by the finished product production record date information acquiring unit;
Based on the production start date, the purchase record date information acquired by the component purchase record date information acquisition unit, and the production record date information acquired by the component production record date information acquisition unit, the component item identifier The product information management according to claim 1 or 2, further comprising a type determining means for determining a type indicating whether the part identified by the component identifier acquired by the acquiring unit is in-house production or outsourced production. apparatus. The type determining means includes
When determining the type of part identified by one component item identifier,
The purchase result date information obtained by the component purchase result date information acquisition unit, and the purchase result date information indicating the date before the production start date among the purchase result date information corresponding to the part, And the latest purchase record date information that is the date closest to the production start date is acquired,
The production result date information acquired by the component production result date information acquisition unit and the production result date information corresponding to the part, the production result date information indicating the date before the production start date, and the most Get the latest production performance date information that is the date close to the production start date,
Compare the latest purchase record date information with the latest production record date information,
If the date indicated by the latest production record date information is closer to the production start date than the date indicated by the latest purchase record date information, the part is determined to be in-house production,
4. The product information management device according to claim 3, wherein when the date indicated by the latest purchase record date information is closer to the production start date than the date indicated by the latest production record date information, the part is determined to be outsourced production. . On the computer,
A configuration table output instruction that is an instruction to output a configuration table indicating a correspondence relationship between a product and a part, and a reception step of receiving a configuration table output instruction having a line completion item identifier;
Production result date information paired with the line completed item identifier included in the composition table output instruction received in the reception step,
A finished product production result date information acquisition step acquired from the stored production result data;
A configuration item identifier acquisition step of acquiring one or more configuration item identifiers of the descendant parts of the product identified by the line completion item identifier included in the configuration table output instruction received in the reception step;
A component purchase result date information acquisition step acquired from purchase result data storing purchase result date information paired with a purchase item identifier that matches the component item identifier acquired in the component item identifier acquisition step; ,
A component production result date information acquisition step for acquiring production result date information paired with a line completed item identifier that matches the component item identifier acquired in the component item identifier acquisition step;
Production result date information acquired in the finished product production date information acquisition step, purchase result date information acquired in the component purchase result date information acquisition step, and acquired in the component production result date information acquisition step Based on production date information, a type determination step for determining a type indicating whether the part identified by the component item identifier acquired in the component item identifier acquisition step is in-house production or subcontracted production;
Based on the line completion item identifier included in the configuration table output instruction received in the reception step, one or more configuration item identifiers acquired in the configuration item identifier acquisition step, and the type of the configuration item identifier determined in the type determination step A program for executing a configuration table output step for outputting a configuration table configured in the configuration table and a configuration table configured in the configuration table configuration step in such a manner that the type of part can be visually clearly indicated. On the computer,
An actual cost output instruction that is an instruction to output the actual cost of the product and part identified by the line completed item identifier, and a reception step for receiving an actual cost output instruction having the line completed item identifier;
The production result date information acquisition step for obtaining the production result date information paired with the line completed item identifier that the actual cost output instruction received in the reception step has, from the stored production result data;
A component item identifier obtaining step for obtaining one or more component item identifiers of the descendant parts of the product identified by the line completed item identifier included in the actual cost output instruction accepted in the accepting step;
Component purchase record date information acquisition step for acquiring purchase record date information paired with the purchase item identifier that matches the component item identifier acquired in the component item identifier acquisition step from the stored purchase record data When,
A component production result date information acquisition step for acquiring production result date information paired with a line completed item identifier that matches the component item identifier acquired in the component item identifier acquisition step;
The production result date acquired in the finished product production date information acquisition step, the purchase result date information acquired in the component purchase result date information acquisition step, and the production acquired in the component production result date information acquisition step. A type determination step for determining a type indicating whether the part identified by the configuration item identifier acquired in the configuration item identifier acquisition step is in-house production or subcontracting production based on actual date information;
A type accumulating step for accumulating the type determined in the type determining step in association with the component item identifier for identifying the product or the component constituting the component identified by the line completion item identifier included in the stored production performance data; ,
One or more component item identifiers acquired in the component item identifier acquisition step, or a type corresponding to the one or more component item identifiers and the line completed item identifiers included in the actual cost output instruction are acquired, and based on the type, Cost acquisition step for acquiring the processing cost or material cost of the component item identifier or each part or product identified by the component item identifier and the line completed item identifier from the stored processing cost data or stored material cost data When,
A cost calculating step of calculating a cost of a product identified by a line completed item identifier included in the actual cost output instruction based on the cost acquired in the cost acquiring step;
A program for executing a cost information output step for outputting cost information that is information on the cost calculated in the cost calculation step. The type determining step includes
A production start date calculation sub-step for calculating a production start date based on the production record date information acquired in the finished product production record date information acquisition step;
Based on the production start date, the purchase record date information acquired in the component purchase record date information acquisition step, and the production record date information acquired in the component production record date information acquisition step, the component item identifier The program according to claim 5 or 6, further comprising a type determination substep for determining a type indicating whether the part identified by the component item identifier acquired in the acquisition step is in-house production or outsourced production.

Images