JP6587700B2 - Load man-hour estimation device, load man-hour estimation method, and program - Google Patents

Description

  The present invention relates to a load man-hour estimating device, a load man-hour estimating method, and a program.

  The factory production line operates according to the production plan. A production plan is created by accumulating load man-hours. Therefore, in order to operate the production line efficiently, it is necessary to estimate the load man-hours with high accuracy. For this reason, the load man-hour is set based on a process route indicating an execution order of each process in an actual production process of each production item, an operation time required for each process, and the like.

  However, since there is no production record for new production items, the person in charge of the process management department confirms personal knowledge or the work department and manually sets the process route and work time. However, consulting with the machine department and setting by manual work place a heavy burden on the person in charge, and in particular, in a factory or the like that performs high-mix low-volume production, an excessive burden is placed on the person in charge. Therefore, various techniques have been proposed for setting process routes and work times for newly produced items without placing an excessive burden on the person in charge.

  For example, in Patent Document 1, an item (similar item) having a new production item, a part configuration, and a number of parts similar to each other is extracted from past production items, and the assembly of the new production item is performed based on the actual data relating to the extracted item. An assembly work time prediction device for predicting work time is disclosed.

JP 7-164267 A

  Even for a production item having a similar part configuration and number of parts, the process route and the required work time of each process are not necessarily similar. If the process route and the required work time of each process are not similar, even if the process route and work time related to the new production item are set by diverting the results of other production items, it is far from the actual one. End up. In this case, the accumulated load man-hours are also different from the actual load man-hours, and it is often necessary to review the production plan.

  The present invention has been made in view of the above circumstances, and an object thereof is to provide a load man-hour estimating device, a load man-hour estimating method, and a program capable of accurately estimating the load man-hours of newly produced items with a small burden. And

In order to achieve the above object, a load man-hour estimation device of the present invention includes an estimation condition information storage unit, a reception unit, an acquisition unit, and an estimation unit. The estimated condition information storage unit associates the keywords extracted by morphological analysis from the item name of each production item, the process route indicating the execution order of each process in the production process of the production item, and the work time required for each process. Te Symbol to憶. The reception unit receives an item name of a new production item for which a load man-hour is estimated. Acquisition unit, new by the morphological analysis from the item name of the production article keywords are extracted, the extracted keywords to the estimated condition information storage unit or we get the process route and the working time associated with the keyword that matches the accepting unit accepts To do. The estimating unit estimates the load man-hours of newly produced items based on the acquired process route and working time.

  According to the present invention, it is possible to accurately estimate the load man-hours of a new production item with a small burden by diverting the process route and work time of a production item with production results as the process route and work time of a new production item. Can do.

Configuration diagram of load man-hour estimation system according to an embodiment of the present invention Flow chart of production planning process according to the embodiment Format diagram of read data sent from the barcode reader to the server device at the start of setup work Format of work record master stored in server Format diagram of read data transmitted from bar code reader to server device when setup work is interrupted Format diagram of work interruption management master stored in server Format diagram of read data sent from bar code reader to server device when setup work is resumed Format diagram of the read data sent from the barcode reader to the server device at the end of the setup work Format diagram of read data sent from bar code reader to server device at the start of work Format diagram of read data sent from bar code reader to server device at the end of work Format diagram of read data sent from bar code reader to server device when operation is interrupted Format diagram of read data sent from bar code reader to server device when resuming work The figure which shows the hardware constitutions of the load man-hour estimation apparatus concerning embodiment The figure which shows the function structure of the load man-hour estimation apparatus concerning embodiment Format diagram of process master stored in load man-hour estimation device Format diagram of process update management master stored in load man-hour estimation device Format diagram of work time master stored in load man-hour estimation device Format diagram of estimate master without summary item number stored in load man-hour estimation device Format drawing of estimate master with summary item number stored in load man-hour estimation device Flowchart of estimated condition information recording process according to the embodiment Flow chart of load man-hour estimation processing according to the embodiment Flow chart of master correction processing according to the embodiment

Hereinafter, a load man-hour estimation system according to an embodiment of the present invention will be described.
The load man-hour estimation system of this embodiment accumulates the load man-hours and estimates the load man-hours for each process and each day based on the work results of each process in the production process of the item being produced. The load man-hour is a man-hour required for completing the work of a specified process. However, since there is no work record for new production items, the work man-hours of similar production items are diverted to obtain the load man-hours. However, it is not possible to obtain sufficient estimation accuracy by simply diverting the work results of a production item that has a similar part configuration and number of parts to the newly produced item. In view of this, the load man-hour estimation system of the present embodiment devises a method of selecting work results to be diverted.

  As shown in FIG. 1, a load man-hour estimating system 100 according to this embodiment is transmitted from a load man-hour estimating device 1, a plurality of barcode readers 2 used at a work site, and a plurality of barcode readers 2. And a server device 3 for storing the received data.

  The plurality of bar code readers 2 are information processing apparatuses for improving the efficiency of the work work, and are constituted by a handy terminal or the like. Each barcode reader 2 reads a barcode recorded on a work instruction slip possessed by a worker at the production site and input to the production site based on the production plan, and records the work content and time in the read various information. The data is transmitted to the server device 3 in association with each other. The work content includes start of work, interruption, end of interruption, end of work, and the like.

  The server device 3 is a device for accumulating information received from the barcode reader 2 and includes a work record master DB (database) 101 and a work interruption management master DB 102. The work performance master DB 101 stores production items, work processes, work start and end times, and work execution times in association with each other. The work suspension management master DB 102 accumulates the suspension start time, the suspension end time, and the total suspension time of each work.

  The load man-hour estimating apparatus 1 refers to the work results for each production item stored in the work result master DB 101 of the server device 3 and accumulates the load man-hours of new production items to estimate the load man-hours by process and by day.

Next, a process of generating work performance data, which is a premise of the load man-hour estimating operation of the load man-hour estimating device 1, in the server device 3 will be described with reference to the work flow shown in FIG.
The process management department determines the production amount and the production period for each production item based on the order information 141 indicating the production item and delivery date of the confirmed order, and the informed information 142 indicating the production item expected to be accepted and the expected delivery date. A production plan representing a schedule such as the above is made (step S1).

  When the production plan is drawn up, the process management department creates a plurality of work instruction slips as work input instructions based on the production plan (step S2). The work instruction slip displays a two-dimensional barcode indicating the item number, item name, etc. of the production target item, and a process route indicating how the machine, equipment, etc. are used in order to produce the production target item. It is printed.

The worker at the work site refers to the work instruction slip to identify the first process (first process), and to the worker who performs the first process (hereinafter referred to as the first process worker), the work instruction slip. give. The first process worker who has received the work instruction slip starts the first process of production. This processing is set as work input (step S3).
The first process worker starts the setup work necessary as preparation before the work (step S4). At this time, the worker in the first process reads the printed barcode by holding the barcode reader 2 installed at the place where the first process is performed over the barcode displayed on the work instruction slip. The barcode reader 2 adds the barcode reading time read from the process name of the first process and the built-in timer to the item number and item name read from the barcode. Here, the process name of the first process is the name of the process to be performed first, and is registered in advance in the built-in memory of the barcode reader 2 in association with the barcode.

  Subsequently, the first process worker takes the total number of processes in process and processes that have been executed out of all processes constituting the process path displayed on the work instruction slip as a number of processes that have been completed. Input to the input unit of the reader 2. The number of processed steps is 1 if the process to be performed is the first process, 2 if the process is the second process. Which value is input in each process is recorded in the work instruction slip.

  The barcode reader 2 generates read data and transmits it to the server device 3 via a wireless network or a wired network. As shown in FIG. 3A, the read data to be generated includes the input item number, item name, step name of the first step, the number of processed steps, the barcode reading time, that is, the setup start time. ,including. The server device 3 receives the read data transmitted from the barcode reader 2 and records it as a work record in the work record master DB 101 in association with the automatically numbered number (step S5). Specifically, as illustrated in FIG. 3B, the server device 3 includes a row ID, an item number, an item name, a process name, a process order, a setup start time, a setup end time, A new record including the time taken, the work start time, the work end time, and the work time as items is generated in the work performance master DB 101. The line ID, item number, item name, process name, process order, and setup start time of the new record are automatically numbered and the item included in the received read data. The number, item name, process name, number of processed processes, and barcode reading time are registered. In this setup start stage, items of setup end time, setup time, work start time, work end time, and work time are set to NULL.

  By the above procedure, the server device 3 records the start of the setup work in the first step in the work result master DB 101 as a work result. Note that the server apparatus 3 does not record work results in the work result master DB 101 for work processes or production items for which no setup work exists until the work is started. At this stage, the first process worker only inputs to the barcode reader 2 that there is no setup work. In this case, the server device 3 sets, for example, NULL to the setup start time, setup end time, and setup time on the record of the work record master DB 101.

Next, it is assumed that the first process worker interrupts the setup work halfway due to various circumstances. It is desirable that the time when the work is interrupted is subtracted from the time taken for the setup work. Therefore, the time when the work is interrupted and the time when the work is resumed should be included in the recording target as the work results.
Therefore, when the first process operator interrupts the work, the bar code reader 2 reads the bar code on the work instruction slip, and further operates the input unit of the bar code reader 2 to indicate the setup work interruption. A capture interruption flag is input to the barcode reader 2. Then, the transmission button provided in the barcode reader 2 is operated. In response to this series of operations, the barcode reader 2 generates read data and transmits it to the server device 3 (step S6). As shown in FIG. 3C, the read data to be generated is input with the item number read from the barcode, the process name of the first step, the barcode reading time acquired from the internal timer, that is, the interruption start time. Including a setup interruption flag.

  The server device 3 receives the reading data of the barcode reader 2. The server device 3 determines that a setup interruption flag is included in the received read data, and records the received data in the work interruption management master DB 102. Specifically, as shown in FIG. 3D, the server device 3 includes a row ID, an item number, a process name, a row ID of a corresponding record on the work performance master DB 101, a setup interruption start time, A new record including items of the setup interruption end time, the setup interruption time, the machine interruption start time, the machine interruption end time, and the machine interruption time is generated in the work interruption management master DB 102. The line ID, item number, process name, and setup interruption start time of the new record are the number automatically assigned, the item number included in the received read data, the process name, Register the barcode reading time. Furthermore, in order to associate the record on the work record master DB 101 with the record on the work break management master DB 102, the row ID of the corresponding record on the work record master DB 101 is set to “work record of the corresponding record on the work break management master DB 102”. Registered in "Master Row ID" (step S7). Other items are set to NULL at this stage.

  When the suspended work is resumed, the barcode reader 2 generates read data and transmits it to the server device 3 by performing the same operation as when the work is started (step S6). As shown in FIG. 3E, the generated read data includes an item number, a process name, a barcode reading time, that is, an interruption end time, and a setup resumption flag. The server device 3 registers the received barcode reading time in the “setup interruption end time” of the corresponding record on the work interruption management master DB 102 shown in FIG. 3D (step S7).

  When the registration of the setup interruption end time is completed, the server device 3 obtains the setup operation interruption time by subtracting the setup interruption start time from the setup interruption end time. Then, the obtained interruption time is registered in the “setup interruption time” of the corresponding record on the work interruption management master DB 102 shown in FIG. 3D (step S7).

  When the interruption occurs a plurality of times, the barcode reader 2 transmits data indicating the interruption start and the interruption end each time. The server apparatus 3 individually registers a record including a plurality of interruption start times and interruption end times, and records each interruption time as the setup interruption time.

  When the setup work is completed, the barcode reader 2 includes the barcode reading time shown in FIG. 4A, that is, the setup work end time, and the setup end flag indicating the setup work end by the operator's operation. Read data is generated and transmitted to the server device 3 (step S8). The server device 3 registers the barcode reading time included in the received data in the “setup end time” of the corresponding record on the work performance master DB 101 (step S9).

  In response to the completion of the recording of the setup end time, the server device 3 subtracts the setup start time from the setup end time on the record registered in the work record master DB 101 shown in FIG. Ask. Then, the time required for the setup work is obtained by subtracting the setup interruption time registered in the corresponding record shown in FIG. 3D of the work interruption management master DB 102 from the obtained temporary setup time. At that time, when a plurality of records corresponding to the work interruption management master DB 102 are registered, the total time of the setup interruption times of those records is subtracted. Then, the obtained time is registered in the “setup time” of the corresponding record on the work record master DB 101 (step S9).

  When the first process worker finishes the setup work and starts the work, the first process worker performs the same operation as that at the start of the setup work. Thereby, the barcode reader 2 transmits the read data shown in FIG. 4B including the work start flag indicating the work start to the server device 3 (step S4). The server device 3 receives the read data from the bar code reader 2 and determines that the received read data includes a work start flag. In response to this determination, the server device 3 registers the barcode reading time included in the read data in the “work start time” of the corresponding record on the work performance master DB 101 shown in FIG. 3B (step S5). ). When the work is finished, the barcode reader 2 transmits the read data shown in FIG. 4C including the work end flag indicating the work end to the server device 3 (step S8). The server device 3 determines that the received read data includes a work end flag. In response to this determination, the server device 3 registers the barcode reading time included in the read data in the “work end time” of the corresponding record on the work performance master DB 101 shown in FIG. 3B (step S9). ).

  Further, when the first process operator interrupts the work during the work, the same operation as when the setup work is interrupted is performed. Thereby, the barcode reader 2 transmits the read data shown in FIG. 4D including the work interruption flag indicating the work interruption to the server device 3 (step S6). When the machine data interruption flag is included in the read data, the server device 3 sets the bar code reading time included in the read data to “work interruption start” in the corresponding record on the work interruption management master DB 102 shown in FIG. 3D. The time is registered (step S7). When the work is resumed, the barcode reader 2 transmits the read data shown in FIG. 4E including the work resume flag indicating the work resume to the server device 3 (step S6). When the received read data includes a work resumption flag, the server device 3 displays the bar code reading time included in the read data as “work” in the corresponding record on the work interruption management master DB 102 shown in FIG. 3D. It is registered at “interruption end time” (step S7).

  When the registration of the work interruption end time is completed, the server device 3 obtains the time at which the work was interrupted by subtracting the work interruption start time from the work interruption end time. Then, the obtained time is recorded or updated in the corresponding record of the work interruption management master DB 102 shown in FIG. 3D as the work interruption time.

  When interruption occurs a plurality of times during the work, the bar code reader 2 transmits data indicating the interruption start and interruption end each time as in the setup operation. The server apparatus 3 individually registers a record including a plurality of interruption start times and interruption end times, and records each interruption time as a work interruption time.

  When the recording of the work end time is completed, the server device 3 obtains a temporary work time by subtracting the work start time from the work end time. Then, the time required for the work is obtained by subtracting the work interruption time from the temporary work time. At that time, when a plurality of records corresponding to the work interruption management master DB 102 are registered, the total time of the work interruption times of those records is subtracted. And the calculated | required time is registered into the "work time" of the corresponding record on work performance master DB101 shown to FIG. 3B.

  When the work performance record in the first process is completed, the first process worker hands over the work instruction slip to the second process worker. The second process worker who has received the work instruction slip starts recording the work performance in the second process using the bar code reader 2 installed at the place where the second process is performed. The work results in each process are recorded in the work result master DB 101 (steps S4, S6, S8 / steps S7, S9). When the record of the work results in all the processes is completed, the record of the work results is finished for the production item for which the work instruction slip instructs the production. The record of work results is executed for all production items for which a work input instruction has been given based on the production plan.

  In this way, daily work results are accumulated in the server device 3. Based on the accumulated work results, the load man-hour estimation device 1 estimates the load man-hours of new items for which no work results exist.

  Hereinafter, the hardware configuration of the load man-hour estimating device 1 will be described with reference to FIG.

  The load man-hour estimation device 1 includes a ROM (Read Only Memory) 1-1, a RAM (Random Access Memory) 1-2, a CPU (Central Processing Unit) 1-3, a storage device 1-4, and a communication device 1. -5 and an input device 1-6.

  The ROM 1-1 is a non-transitory storage medium that stores a basic operation program executed by the CPU 1-3.

  The RAM 1-2 is a temporary storage medium serving as a work area for the CPU 1-3.

  The CPU 1-3 reads the program stored in the ROM 1-1 or the storage device 1-4 into the RAM 1-2, and executes various processes according to the read program.

  The storage device 1-4 is a non-transitory storage medium such as a hard disk or a flash memory.

  The communication device 1-5 includes a NIC (Network Interface Card), and communicates various data with the server device 3.

  The input device 1-6 is an input interface such as a keyboard and a mouse. The user can give an instruction to the CPU 1-3 by operating the input device 1-6.

  Next, the functional configuration of the load man-hour estimation device 1 will be described with reference to FIG.

  The CPU 1-3 reads and executes the program stored in the ROM 1-1, thereby causing the load man-hour estimation device 1 to function as each functional unit illustrated in FIG. Specifically, the CPU 1-3 uses the load man-hour estimation device 1 as a work performance storage unit 10, a process information storage unit 11, a work time information storage unit 12, an estimated condition information storage unit 13, a performance reflection unit 14, and an extraction unit. 15, function as record acquisition unit 16, total number calculation unit 17, average value calculation unit 18, estimation condition information recording unit 19, reception unit 20, acquisition unit 21, process / work time recording unit 22, estimation unit 23, and correction unit 24 Let The work record storage unit 10, the process information storage unit 11, the work time information storage unit 12, and the estimated condition information storage unit 13 are constructed in the storage device 1-4 built in the load man-hour estimation device 1.

  The work record storage unit 10 includes a work record master DB 101 and a work interruption management master DB 102.

  The process information storage unit 11 includes a process master DB 111 and a process update management master DB 112. The process master DB 111 includes process path information indicating the execution order of each process in the production process of the production item. Specifically, as illustrated in FIG. 7A, the process master DB 111 includes an item name, a summary item number, a process name, and a process order in association with the item number. All the production items are classified into a plurality of groups of production items having common characteristics, for example, a group of electrical parts, a group of sensors, and a group of displays. The summary item number indicates to which group the production item belongs. The summary item number is a number obtained by deleting the option number from the item number, for example, the upper three digits of the item number. The option number represents a minor difference between production items belonging to the same group, such as a difference in version of the production item. The process name indicates the name of the process. The process order indicates the number of processes to be executed among all processes. As shown in FIG. 7B, the process update management master DB 112 includes an update history of process names for each combination of item number and process order.

The work time information storage unit 12 stores a work time master DB 121. Hereinafter, the setup time and the standard time obtained based on the work results will be referred to as an actual base setup time and an actual base time, respectively. In addition, the setup time and the standard time obtained by diverting the work results of other items are set as the setup time and the diversion standard time, respectively. Further, the setup time and the standard time corrected by the process management department are set as the post-rating setup time and the post-rating standard time, respectively.
For each combination of production item and process, the work time master DB 121 includes an actual base setup time, an actual base standard time, a diversion setup time, a diversion standard time, a post-rating setup time, and a post-rating standard time. including.

  The performance-based setup time is an average value of setup times included in a plurality of records having the same process as the production item extracted from the work performance master DB 101 by the performance reflection unit 14. The performance base standard time is an average value of work times included in a plurality of records having the same process as the production item extracted from the work performance master DB 101 by the performance reflection unit 14. In addition, the diversion setup time means that there is no work record for a new production item, and therefore the estimation unit 23 is a step related to another production item acquired from the work record master DB 101 to be used as a work record for the new production item. It is taking time. The diversion standard time is a work time for other production items acquired from the work performance master DB 101 by the estimation unit 23 for the same purpose. In addition, the post-rating setup time and post-rating standard time are determined by the person in charge in the process management department after evaluating the validity of the actual base setup time, actual base standard time, diversion setup time, diversion standard time, etc. This is the setup time and standard time set when it is determined that correction is necessary.

  Information included in the work time master DB 121 will be described more specifically. As shown in FIG. 7C, the work time master DB 121 associates the item name with the process order, the item name, the summary item number, the process name, the actual base setup time, the actual base standard time, the diversion setup time, Accumulate standard time for diversion, setup time after rating, and standard time after rating.

  The estimate condition information storage unit 13 illustrated in FIG. 6 stores an estimate master DB (without a summary item number) 131 and an estimate master DB (with a summary item number) 132. The estimate master DBs 131 and 132 are common in that the candidates for work results that are diverted to estimate the load man-hours of newly produced items are stored, but the estimate master DB (with summary item number) 132 has work results. The summary item number is assigned to the estimate master DB (no summary item number) 131, and the summary item number is not assigned to the work result. When diverting work results for new production items, it is desirable to divert work results to which summary item numbers that match the summary item numbers assigned to the new production items are used. Therefore, the estimate master DB (with summary item number) 132 is normally used for diverting work results. However, there are also new production items that are not assigned a summary item number. Even in such a case, an estimate master DB (no summary item number) 131 is stored in the estimate condition information storage unit 13 so as not to hinder the diversion of work results. Details of the information included in the estimate master DBs 131 and 132 will be described later together with the description of the estimate condition information recording unit 19.

The record reflecting unit 14 reflects the latest work record recorded in the work record master DB 101 in the process master DB 111 and the work time master DB 121. Specifically, when there are production items that are not recorded in the process master DB 111 and the work time master DB 121 among the production items whose work results are recorded in the work result master DB 101, the production items are designated as process masters. Register in the DB 111 and the work time master DB 121. Further, if there is a difference between the process route recorded in the process master DB 111 and the process route in the latest work record, the result reflecting unit 14 changes the process route recorded in the process master DB 111 to the latest process route. An alert (hereinafter referred to as a process route review alert) is notified to the process management department so that it is updated. Further, the result reflecting unit 14 obtains the result base setup time and the result base standard time based on the latest work result, and obtains the result base setup time and the result base standard time recorded in the work time master DB 121. Update to the actual base setup time and actual base time.
Specifically, when the result reflecting unit 14 tries to update the result base setup time and the result base standard time recorded in the work time master DB 121 in association with the item number m and the nth step, The update history of the process name of the nth process for the item number m recorded in the update management master DB 112 is referred to.

  The result reflecting unit 14 then includes the process name s that is the process name of the nth process from the last update date to the current date (update process date) among the process names of the nth process for the item number m included in the update history. To get. Next, the performance reflecting unit 14 acquires a record including the item number m, the nth process, and the process name s from the work performance master DB 101. Then, when there are a plurality of acquired records, the result reflecting unit 14 acquires the result base setup time and the result base standard time from the plurality of records according to a prescribed rule. For example, the total number X (X is a natural number) of the acquired records is divided by 4, and the X / 4th smallest value is acquired in the performance-based setup time included in the acquired record. In addition, the X / 4th smallest value is acquired in the performance base standard time included in the acquired record. If the value of X / 4 is a decimal, the decimal part is rounded up. The result reflecting unit 14 acquires the result base setup time and the result base standard time recorded in the work time master DB 121 in association with the item number m and the nth process from the work result master DB 101 in the above procedure. Update to base setup time and actual base time.

  If the record including the item number m, the n-th process, and the process name s does not exist in the work record master DB 101, it is the process name of the n-th process for the item number m from the previous update date to the previous update date. The process name t is acquired from the process master DB 111. Furthermore, when the record including the item number m, the n-th process, and the process name t does not exist in the work performance master DB 101, the record for the item number m from the update date one more time before the update date one time before the update date before The process name q that was the process name of the nth process is acquired from the process master DB 111. As described above, the record reflecting unit 14 traces the time in the update history and acquires the process name until the desired record can be acquired from the work record master DB 101 or the time is traced back to the beginning of the update history. Try.

  The performance reflecting unit 14 may notify the alert by various methods. For example, an alert may be displayed on a screen provided in the load man-hour estimating device 1, or data may be transmitted from the load man-hour estimating device 1 to the printing device and a notification describing the alert may be issued to the printing device.

  The extraction unit 15 extracts a summary item number and one or more keywords from each record for all records in the process master DB 111 and the work time master DB 121 in which the latest work results are reflected by the result reflection unit 14. The extraction unit 15 extracts keywords by performing morphological analysis on the item names included in each record.

  The record acquisition unit 16 selects one keyword from one or a plurality of keywords extracted by the extraction unit 15. Then, the record acquisition unit 16 acquires a record group including item names that at least partially match the selected keyword from the process master DB 111 as a first diversion candidate record group. Note that the acquisition condition may be complete match instead of partial match.

  The total number calculation unit 17 calculates or counts the total number of records having the same process name of the k-th process (k is the process order being processed and initially k = 1) in the first diversion candidate record group for each process name. To do. Then, (a) the total number calculation unit 17 acquires process names included in a record group (hereinafter referred to as a first record group) in which the total number of records is the maximum. Next, (b) the total number calculation unit 17 calculates, as a probability, the ratio of the total number of records included in the first record group to the total number of records included in the first diversion candidate record group.

  The average value calculation unit 18 generates a record group including an item name that at least partially matches the keyword selected by the record acquisition unit 16 and a process name that matches the process name acquired by the total number calculation unit 17 as a work time master. Obtained from the DB 121. Then, (c) the average value calculation unit 18 calculates the average value of the post-rating setup time included in the acquired record group, and calculates the average value of the standard time after rating.

  As shown in FIG. 7D, the estimation condition information recording unit 19 associates the keyword selected by the record acquisition unit 16 with the combination of the process sequence being processed (the k-th process) from (a) to ( c) The process name acquired in the process of c), the calculated probability, the average value of setup time after rating, and the average value of standard time after rating are estimated masters as the process name, probability, setup time, and standard time, respectively. Record in DB (no summary item number) 131.

  Here, assuming that the maximum value of the process sequence of each record included in the first diversion candidate record group is the Nth process, the total number calculation unit 17 and the average value calculation unit 18 perform the above (a) to (c). The process of step k, that is, the process name is acquired and the probability, the average value of the post-rating setup time and the average value of the standard time after rating is calculated from the first process to the N-th process. Then, the estimated condition information recording unit 19 includes the process name acquired for each process from the first process to the Nth process, the calculated probability, the average value of setup time after rating, and the average value of standard time after rating. Are recorded in the estimate master DB (no summary item number) 131 in association with the keyword selected by the record acquisition unit 16 and the process order.

  Further, when there is an unselected keyword among the keywords extracted by the extraction unit 15, the record acquisition unit 16 selects one of the unselected keywords. Then, when a new keyword is selected by the record acquisition unit 16, in the same procedure as described above, acquisition of the first diversion candidate record group, acquisition of process name, probability, average value of setup time after rating, and The standard time after rating is calculated and recorded in the estimate master DB (no summary item number) 131.

  The record acquisition unit 16 selects one summary item number and one keyword extracted by the extraction unit 15. Then, the record acquisition unit 16 acquires from the process master DB 111 a record group including a summary item number that matches the selected summary item number and an item name that at least partially matches the selected keyword as a second diversion candidate record group. To do.

  The total number calculation unit 17 calculates the total number of records having the same process name of the first process in the second diversion candidate record group for each process name. Then, (d) the total number calculation unit 17 acquires process names included in a record group (hereinafter referred to as a second record group) in which the total number of records is maximum. Next, (e) the total number calculation unit 17 calculates, as a probability, the ratio of the total number of second record groups to the total number of records included in the second diversion candidate record group.

  The average value calculation unit 18 acquires the summary item number that matches the summary item number selected by the record acquisition unit 16, the item name that at least partially matches the keyword selected by the record acquisition unit 16, and the total number calculation unit 17 A record group including a process name that matches the process name that has been obtained is acquired from the work time master DB 121. Then, (f) the average value calculation unit 18 calculates an average value of the post-rating setup time included in the acquired record group, and calculates the average value of the standard time after rating.

  As shown in FIG. 7E, the estimation condition information recording unit 19 is associated with the combination of the summary item number selected by the record acquisition unit 16, the keyword, and the process order (kth process) being processed. The process name acquired in the above processes (d) to (f), the calculated probability, the average value of the setup time after rating, and the average value of the standard time after rating are respectively represented by the process name, probability, setup time, Recorded in the estimate master DB (with summary item number) 132 as standard time.

  Here, assuming that the maximum value of the process order of each record included in the second diversion candidate record group is the Nth process, the total number calculation unit 17 and the average value calculation unit 18 perform the above (d) to (f) In other words, the process k is acquired from the first process to the Nth process, in which the process name is acquired and the probability, the average value of the post-rating setup time and the average value of the standard time after rating are calculated. Then, the estimated condition information recording unit 19 obtains the process name acquired for each process from the first process to the Nth process, the calculated probability, the average value of the setup time after rating, and the average value of the standard time after rating. The summary item number selected by the record acquisition unit 16, the keyword, and the process order are recorded in the estimate master DB (with summary item number) 132 in association with the combination.

  The estimate master DBs 131 and 132 are used for estimating the load man-hours of newly produced items. If the load man-hour estimation target is a production item that has been produced in the past (hereinafter referred to as an existing item), the process route and standard time necessary for estimating the load man-hour are the process master DB 111 and the work time master DB 121. Is recorded. However, this is not the case for newly produced items, so diverting work results for existing items similar to newly produced items is essential for estimating the load man-hours. The estimate master DBs 131 and 132 are created from such circumstances, and work results that are candidates for diversion are recorded.

  Note that there may or may not be an existing item that matches the newly produced item and the summary item number. If it exists, the work record for the existing item recorded in the estimate master DB (with summary item number) 132 is used as the work record for the newly produced item. On the other hand, if it does not exist, the work record for the existing item recorded in the estimate master DB (no summary item number) 131 is used as the work record for the newly produced item.

  The accepting unit 20 accepts order information 141 and introductory information 142 supplied from an external device or directly inputted. In the order information 141, the item number, item name, production quantity, delivery date, etc. are listed as a list of production items scheduled to be produced. In the inside information 142, an item number, an item name, an estimated production quantity, an expected delivery date, and the like are listed as a list of production items to be produced.

  The acquisition unit 21 acquires an item number and an item name from the order information 141 and the indication information 142, and determines whether or not the acquired item number exists in the work performance master DB 101. When the item number exists in the work record master DB 101, the production item identified by the item number is an existing item. On the other hand, when the item number does not exist in the work record master DB 101, the production item identified by the item number is a new production item.

  Since no effort has been estimated for newly produced items, the process master DB 111 and the work time master DB 121 do not have information such as process route and standard time necessary for estimating the effort. Therefore, the acquisition unit 21 and the process / work time recording unit 22 set a process route, a standard time, and the like for a new production item.

  Specifically, when the acquisition unit 21 determines that the production item identified by the item number is a new production item, the acquisition unit 21 acquires a summary item number excluding the option number from the item number. Next, the acquisition unit 21 acquires one or more keywords by performing morphological analysis on the item name.

  For each combination of summary item number and keyword acquired by the acquisition unit 21, the process / work time recording unit 22 determines whether a combination of summary item number and keyword exists in the estimate master DB (with summary item number) 132. Determine whether or not. If it is determined that a combination exists, the process / work time recording unit 22 acquires a record group including a summary item number and a keyword constituting the combination from the estimate master DB (with summary item number) 132. Next, the process / work time recording unit 22 acquires a record group including the same process order from the acquired record group for each process order, and has the highest probability (calculated by the total number calculation unit 17) in each record group. Record that contains (probability). And a process name, setup time, and standard time are acquired from each record containing the highest probability. In addition, since the match of the summary item number becomes a condition for diverting the work results, the work results from the estimate master DB (with summary item numbers) 132 are diverted from the diversion of the work results from the estimate master DB (no summary item number) 131. The diversion increases the load man-hour estimation accuracy of new production items. Therefore, if there is an existing item whose summary item number matches the newly produced item, it is desirable to divert work results from the estimate master DB 132 (with summary item number).

  On the other hand, if the process / work time recording unit 22 determines that the combination of the summary item number and the keyword acquired by the acquisition unit 21 does not exist in the estimate master DB (with the summary item number) 132, the record including the keyword The group is acquired from the estimate master DB (no summary item number) 131. Next, a record group including the same process order is acquired from the acquired record group for each process order, and a record including the highest probability in each record group is acquired. And a process name, setup time, and standard time are acquired from each record containing the highest probability. There may be no existing item with the same summary item number as the new production item. In this case, work results are diverted from the estimate master DB (no summary item number) 131 where matching of summary item numbers is not a condition for diverting work results. Even in this case, since matching of keywords is a condition for diverting work results, a certain degree of estimation accuracy is ensured for estimating the man-hours for newly produced items.

  In addition, the process / work time recording unit 22 associates the item number, item name, and summary item number acquired by the acquisition unit 21 with the process order and process name acquired from the estimate master DB (with summary item number) 132. To the process master DB 111. Further, the work order, process name, setup time, and standard time acquired from the estimate master DB (with summary item number) 132 are associated with the item number, item name, and summary item number acquired by the acquisition unit 21. Record in the time master DB 121.

  If the acquisition unit 21 determines that the production item identified by the acquired item number is an existing item, the acquisition unit 21 uses the process name and process order associated with the acquired item number for estimation of the existing item. Acquired from the process master DB 111 as process information. Further, the acquisition unit 21 determines whether or not values are set in the post-rating setup time and the post-rating standard time associated with the acquired item number in the work time master DB 121. If it is determined that a value is set, the acquisition unit 21 acquires the post-rating setup time and the post-rating standard time from the work time master DB 121 as work time information for estimation for existing items. On the other hand, when it is determined that no value is set, the acquisition unit 21 acquires the actual base setup time and the actual base standard time from the work time master DB 121 as estimated work time information for the existing items.

  Based on the process information for estimation and work time information for estimation, and the process information for estimation and work time information for estimation for existing items acquired by the acquisition unit 21, the estimation unit 23 Create another load man-hour estimation result.

  The correcting unit 24 is realized by the cooperation of the CPU 1-3 and the input device 1-6. When the user inputs an instruction to the correction unit 24 via the input device 1-6, the correction unit 24 executes various processes according to the input instruction. For example, the person in charge of the process management department that receives the process path review alert inputs a master correction instruction to the correction unit 24. Then, the correction unit 24 corrects the contents of the process master DB 111, the post-rating setup time and the post-rating standard time recorded in the work time master DB 121 according to the input master correction instruction.

  Next, the estimated condition information recording process executed by the load man-hour estimating device 1 will be described with reference to FIG.

[Quote condition information recording process]
This process is programmed to be executed periodically. When this process is started, the result reflecting unit 14 acquires one item number from the work result master DB 101 (step S100). Then, the result reflecting unit 14 determines whether or not the acquired item number has been registered in the process master DB 111 (step S101). If it is determined that the item number has been registered (step S101; Yes), the result reflecting unit 14 determines whether or not the first process has been registered in association with the registered item number in the process master DB 111. Is determined (step S102). And when it determines with the 1st process having been registered (step S102; Yes), the performance reflection part 14 makes the process name and process sequence matched with the item number acquired by step S101 from work performance master DB101. get. Next, the performance reflecting unit 14 compares the process path indicated by the acquired process name and process order with the process path recorded in the process master DB 111 in association with the item number acquired in step S101. It is determined whether or not there is a difference between the two process paths (step S103). This determination is intended to clarify whether the process path recorded in the process master DB 111 is the latest process path from the presence or absence of a difference between the two process paths. Here, it is assumed that the performance reflecting unit 14 determines that there is no difference between the two process paths (step S103; Yes). In this case, since the process route recorded in the process master DB 111 is the latest and does not need to be corrected, the performance reflecting unit 14 does not correct the process master DB 111 and moves the process to step S107.

  When the result reflecting unit 14 determines in step S101 that the item number is not registered in the process master DB 111 (step S101; No), the result reflecting unit 14 is associated with the item number acquired in step S101 from the work result master DB 101. Get the item name, process name, and process order. And the performance reflection part 14 records an item number in process master DB111 (step S104). Further, the record reflecting unit 14 records the summary item number obtained by excluding the option number from the item number, the acquired process name, and the process order in the process master DB 111 in association with the recorded item number (step S105).

  In addition, when the result reflecting unit 14 determines in step S103 that there is a difference between the two process paths (step S103; No), an alert that prompts the user to review the process path recorded in the process master DB 111 (process) A route review alert) is performed to the process management department (step S106).

When the process moves to step S107, the result reflecting unit 14 determines whether or not the item number acquired in step S101 has been registered in the work time master DB 121 (step S107). And when the result reflection part 14 discriminate | determines that the item number has been registered (step S107; Yes), the process sequence, setup time, and working time matched with the item number acquired at step S101 will be acquired. (Step 108).
When the result reflection unit 14 determines in step S107 that the item number is not registered (step S107; No), the item number acquired in step S101 is recorded in the work time master DB 121 (step S109). ). Then, the performance reflecting unit 14 executes the process of step S108.

  Next, the performance reflecting unit 14 associates the summary item number, the setup time, and the work time with each of the combination of the item number acquired in step S101 and the process order acquired in step S108, and summarizes the item number. In addition, the performance base setup time and the performance base work time are recorded in the work time master DB 121 (step S110). Then, the result reflection unit 14 determines whether or not an item number that has not been acquired exists in the work result master DB 101 (step S111). When it is determined that there is an unacquired item number (step S111; Yes), the result reflection unit 14 repeatedly executes each process from step S100 to step S110 until all item numbers are acquired from the work result master DB 101. . On the other hand, when the performance reflecting unit 14 determines that there is no unacquired item number (step S111; No), it moves the process to step S112.

  The latest work performance is reflected in the process master DB 111 and the work time master DB 121 by each process from step S101 to step S111. Next, based on the latest process master DB 111 and work time master DB 121, update processing is performed on the estimate master DB (with summary item number) 132 and the estimate master DB (without summary item number) 131 necessary for estimating the man-hours. Is started.

  First, the extraction unit 15 extracts a summary item number and one or more keywords from each record for all the records in the process master DB 111 and the work time master DB 121 (step S112). As described above, the keyword is extracted by morphological analysis for the item name. The record acquisition unit 16 selects one from the extracted one or more keywords (step S113). Then, the record acquisition unit 16 acquires a record group including item names that at least partially match the selected keyword from the process master DB 111 as a first diversion candidate record group (step S114).

  The total number calculation unit 17 calculates, for each process name, the total number of records having the same process name of the i-th (initially i = 1) process in the first diversion candidate record group (step S115). Then, the total number calculation unit 17 acquires the process name included in the record having the maximum total number (step S116).

  Next, the total number calculation unit 17 calculates, as a probability, the ratio of the total number of records including the process name acquired in step S115 in the first diversion candidate record group to the total number of records included in the first diversion candidate record group. To do. (Step S117).

  The average value calculation unit 18 generates a record group including an item name that at least partially matches the keyword selected by the record acquisition unit 16 and a process name that matches the process name acquired by the total number calculation unit 17 as a work time master. Obtained from the DB 121. Then, the average value calculation unit 18 calculates the average value of the post-rating setup time and the average value of the standard time after rating included in the acquired record group (step S118).

  The estimation condition information recording unit 19 associates the keyword selected by the record acquisition unit 16 with the combination of the process order (i-th process) and the process name acquired in each step from step S116 to step S118. The calculated probability, the average value of the setup time after rating, and the average value of the standard time after rating are recorded in the estimate master DB (no summary item number) 131 as the process name, probability, setup time, and standard time, respectively ( Step S119).

  Here, it is assumed that the maximum value of the process order of each record included in the first diversion candidate record group is the Nth process (N is a natural number). When the process of step S119 is completed, the estimation condition information recording unit 19 determines whether or not the i-th process is less than the N-th process (step S120). When the estimated condition information recording unit 19 determines that the i-th process is less than the N-th process (step S120; Yes), 1 is added to i (step S121), and each process from step S115 to S119 is performed. Are repeatedly executed until the i-th step is not less than the N-th step. On the other hand, if the estimation condition information recording unit 19 determines that the i-th process is not less than the N-th process (step S120; No), whether or not an unselected keyword exists in the keyword extracted by the extraction unit 15 Is determined (step S122).

  When it is determined that there is an unselected keyword (step S122; Yes), the estimation condition information recording unit 19 repeatedly executes the processes from steps S113 to S120 until there is no unselected keyword. On the other hand, when it is determined that there is no unselected keyword (step S122; No), the estimation condition information recording unit 19 moves the process to step S123.

  Next, the record acquisition unit 16 selects one summary item number and one keyword extracted by the extraction unit 15 (step S123). Then, the record acquisition unit 16 sets, from the process master DB 111, a record group including a summary item number that completely matches the selected summary item number and an item name that at least partially matches the selected keyword as a second diversion candidate record group. Obtain (step S124).

  The total number calculation unit 17 calculates, for each process name, the total number of records having the same process name in the jth (initially j = 1) process in the second diversion candidate record group (step S125). Then, the total number calculation unit 17 acquires the process name included in the record having the maximum total number (step S126).

  Next, the total number calculation unit 17 calculates, as a probability, the ratio of the total number of records including the process name acquired in step S126 in the second diversion candidate record group to the total number of records included in the second diversion candidate record group. To do. (Step S127).

  The average value calculation unit 18 includes a summary item number that completely matches the summary item number selected by the record acquisition unit 16, an item name that at least partially matches the keyword selected by the record acquisition unit 16, and a total number calculation unit 17 A record group including a process name that matches the acquired process name is acquired from the work time master DB 121. Then, the average value calculation unit 18 calculates the average value of the post-rating setup time and the average value of the standard time after rating included in the acquired record group (step S128).

  The estimation condition information recording unit 19 is acquired in each step from step S126 to step S128 in association with the combination of the summary item number, the keyword, and the process order (jth process) selected by the record acquisition unit 16. Process name, calculated probability, average value of setup time after rating, and average value of standard time after rating are estimated master DB (with summary item number) 132 as process name, probability, setup time, and standard time, respectively. (Step S129).

  Here, it is assumed that the maximum value of the process order of each record included in the second diversion candidate record group is the Nth process (N is a natural number). When the process of step S129 is completed, the estimation condition information recording unit 19 determines whether the jth process is less than the Nth process (step S130). When the estimated condition information recording unit 19 determines that the j-th process is less than the N-th process (step S130; Yes), 1 is added to j (step S131), and each process from step S125 to S129 is performed. Are repeatedly executed until the j-th step is not less than the N-th step. On the other hand, when it is determined that the j-th process is not less than the N-th process (step S130; No), the estimation condition information recording unit 19 is not selected from the combination of the summary item number and the keyword extracted by the extraction unit 15 It is determined whether or not a combination exists (step S132).

  When it is determined that there is an unselected combination (step S132; Yes), the estimation condition information recording unit 19 repeatedly executes each process from step S123 to S130 until there is no unselected combination. On the other hand, when it is determined that there is no unselected combination (step S132; No), the estimation condition information recording unit 19 ends the estimation condition information recording process.

  Next, the load man-hour estimation process executed by the load man-hour estimating device 1 will be described with reference to FIG.

[Load man-hour estimation processing]
This process is started in response to the reception unit 20 receiving the order information 141 and the inside information 142 supplied from an external device. When this process is started, the acquisition unit 21 acquires an item number and an item name from the order information 141 and the introductory information 142 (step S200). And the acquisition part 21 discriminate | determines whether the acquired item number exists in process master DB111 and work time master DB121 (step S201). When determining that the item number does not exist (step S201; No), the acquiring unit 21 acquires a summary item number obtained by excluding the option number from the item number (step S202). Next, the acquisition unit 21 performs morphological analysis on the item name to acquire one or more keywords (step S203). Step S203 functions as an extraction step for extracting a keyword from the item name of the newly produced item.

For each combination of summary item number and keyword acquired by the acquisition unit 21, the process / work time recording unit 22 determines whether a combination of summary item number and keyword exists in the estimate master DB (with summary item number) 132. It is determined whether or not (step S204). If the process / work time recording unit 22 determines that a combination exists (step S204; Yes), a record group including a summary item number and a keyword constituting the combination is estimated master DB (with a summary item number) 132. Get from. Next, the process / work time recording unit 22 acquires a record group including the same process order from the acquired record group for each process order. The process / work time recording unit 22 acquires a record including the highest probability (probability calculated by the total number calculation unit 17) in the record group from each of the acquired record groups including the same process order.
Then, the process / work time recording unit 22 acquires the process name, the setup time, and the standard time from the record including the highest probability (step S205).

  Next, the process / work time recording unit 22 adds the process order and process acquired from the estimate master DB (with summary item number) 132 to the item number, item name, and summary item number acquired by the acquisition unit 21 in step S205. Name pairs are associated and recorded in the process master DB 111 (step S207). Further, the process / work time recording unit 22 associates the item number, item name, and summary item number acquired by the acquiring unit 21 with the process sequence acquired from the estimate master DB (with summary item number) 132 in step S205. The setup time and the standard time are recorded in the work time master DB 121 as the process order, the diversion setup time, and the diversion standard time, respectively (step S208).

On the other hand, when the process / work time recording unit 22 determines that the combination of the summary item number and the keyword acquired by the acquisition unit 21 in step S204 does not exist in the estimate master DB (with the summary item number) 132 (step S204). No), a record group including the keyword is acquired from the estimate master DB (no summary item number) 131. Next, the process / work time recording unit 22 acquires a record group including the same process order from the acquired record group for each process order. The process / work time recording unit 22 acquires a record including the highest probability in the record group from each of the acquired record groups including the same process order. Then, the process / work time recording unit 22 acquires the process name, the setup time, and the standard time from the record including the highest probability (step S206).
Step S205 or step S206 is based on the data that associates the keyword extracted from the item name of each production item, the process path indicating the execution order of each process in the production process of the production item, and the work time of each process. It functions as an acquisition step for acquiring a process route and work time associated with a keyword that matches the keyword extracted in the extraction step (step S203).

  Next, the process / work time recording unit 22 adds the process order and process acquired from the estimate master DB (no summary item number) 131 in step S206 to the item number, item name, and summary item number acquired by the acquiring unit 21. Name pairs are associated and recorded in the process master DB 111 (step S207). Further, the process / work time recording unit 22 associates the item number, item name, and summary item number acquired by the acquiring unit 21 with the process sequence acquired from the estimate master DB (no summary item number) 131 in step S206. The setup time and the standard time are recorded in the work time master DB 121 as the process order, the diversion setup time, and the diversion standard time, respectively (step S208).

  Then, the process / work time recording unit 22 that has completed the recording determines whether or not there is an unacquired item number in the order information 141 and the indication information 142 (step S209). If the process / work time recording unit 22 determines that there are unacquired item numbers (step S209; Yes), the process / work time recording unit 22 performs each process from step S200 to step S208 until all item numbers are acquired from the process master DB 111. Execute.

  If the production item identified by the item number acquired from the order information 141 and the introductory information 142 in step S200 is an existing item that has been produced in the past, the item number acquired in step S200 is the process number. It should be registered in the master DB 111 and the work time master DB 121. Therefore, in this case, the acquisition unit 21 determines in step S201 that the item number exists in the process master DB 111 and the work time master DB 121 (step S201; Yes).

  If it is determined that the item number exists, the acquisition unit 21 acquires the process name and the process order recorded in association with the item number from the process master DB 111 (step S212). Further, the acquisition unit 21 determines whether or not the post-rating setup time and the post-rating standard time are recorded in the work time master DB 121 for each combination of the item number and the process order acquired in step S212 ( Step S213). Then, for the combination determined that the post-rating setup time and the post-rating standard time are recorded (step S213; Yes), the acquisition unit 21 sets the post-rating setup time and the post-rating standard time to the setup time, The standard time is acquired from the work time master DB 121 (step S214), and the process proceeds to step S209. On the other hand, for a combination determined that the post-rating setup time and the post-rating standard time are not recorded (step S213; No), the acquisition unit 21 sets the actual base setup time and the actual base standard time as the setup time. The standard time is acquired from the work time master DB 121 (step S215), and the process proceeds to step S209.

When the process moves to step S209 and it is determined that there is no unacquired item number (step S209; No), the estimating unit 23 generates a calendar master that specifies the operation and holiday of the work site (factory), production A reference schedule master indicating a reference for the production lead time for each item is acquired from an external device or the like (step S210). Then, the estimation unit 23 calculates the date based on the acquired calendar master and reference schedule master, and the process name, process order, setup time, and standard time acquired in step S205, step S206, step S214, and step S215. The load man-hours for each process are estimated (step S211). Step S211 functions as an estimation step for estimating the load man-hours required for production of a new production item based on the process route and the work time acquired in the acquisition step (S205 or S206).
When the estimation of the load man-hour is finished, the load man-hour estimating process is also finished. Note that the estimated man-hours are used for production planning by the process management department. In addition, the load man-hours are accumulated on the basis of the scheduled work date in which the lead time from the work input to the customer transportation is backwarded from the delivery date.

  When the process route review alert is notified in step S106, the process management department reviews the contents recorded in the process master DB 111 and the work time master DB 121 and examines whether correction is necessary. If correction is necessary, a master correction instruction is input to the correction unit 24. The correction unit 24 starts the master correction process shown in FIG. 10 in response to the input of the master correction instruction.

[Master correction processing]
When the master correction process is started, the correction unit 24 determines whether or not a correction instruction for the process is included in the master correction instruction (step S301). If the correction unit 24 determines that the correction instruction for the process is included in the master correction instruction (step S301; Yes), the correction unit 24 corrects the contents of the process master DB 111 according to the master correction instruction (step S302).

  Next, the correction unit 24 determines whether or not a correction instruction for the post-rating setup time is included in the master correction instruction (step S303). When the correction unit 24 determines that the correction instruction for the post-rating setup time is included in the master correction instruction (step S303; Yes), the post-rating setup setup recorded in the work time master DB 121 according to the master correction instruction. The time is corrected (step S304). Next, the correcting unit 24 determines whether or not a correction instruction for the standard time after rating is included in the master correction instruction (step S305). If the correction unit 24 determines that the correction instruction for the post-rating standard time is included in the master correction instruction (step S305; Yes), the post-rating standard recorded in the work time master DB 121 according to the master correction instruction. The time is corrected (step S306).

If it is determined in step S301 that the correction instruction for the process is not included in the master correction instruction (step S301; No), the correction unit 24 skips step S302 and proceeds to the process of step S303. If the correction unit 24 determines in step S303 that the correction instruction for the post-rating setup time is not included in the master correction instruction (step S303; No), it skips step S304 and proceeds to the process of step S305. .
If the correction unit 24 determines in step S305 that the correction instruction for the standard time after rating is not included in the master correction instruction (step S305; No), the correction unit 24 skips step S306 and ends the master correction process. .

  As described above, the load man-hour estimating device 1 uses the match of summary item numbers and the match of keywords as conditions for diverting work results, and diverts work results for existing items that satisfy the conditions as work results for newly produced items. To do. Therefore, even when the coincidence of the parts configuration and the number of parts is inappropriate as a criterion for determining whether or not the work results are appropriate, the load man-hour estimation device 1 according to the embodiment is diverting the work results for the new production item, Load man-hours can be estimated accurately with a small burden.

(Modification)
Although the embodiment of the present invention has been described above, the above embodiment is an example, and the scope of application of the present invention is not limited to this. That is, the embodiments of the present invention can be applied in various ways, and all the embodiments are included in the scope of the present invention.

  For example, the acquisition unit 21 acquires the process to be diverted from the estimate master DB (with summary item number) 132 for each process from the first process to the N-th process for the new production item, but acquires the process to be diverted. All processes may be performed collectively. In this way, the time required for diverting the process is shortened and the load on the CPU is also reduced. Of course, it is more likely that an appropriate process will be diverted to a new production item in each process than in the case of all processes, but even in the case of all processes, at least keyword matching is included in the conditions for process diversion. Therefore, the diverted process does not greatly deviate from the actual process for new production items. Therefore, the estimated accuracy with a high load man-hour is maintained. In this case, the estimate master DB (with summary item number) 132 is a summary item so that the acquisition unit 21 can acquire the process diverted to the newly produced item using the summary item number and the keyword as a key. The process name is stored in association with each combination of the summary item number and the keyword, not the combination of the number, the keyword, and the process order.

  In this embodiment, the item number plays the role of item identification information for identifying the production item. However, if the item identification information can identify the production item, it is not a combination of numbers like the item number. May be. For example, a combination of symbols or an alphabet may be used. Similarly, in the present embodiment, the summary item number plays a role of summary item identification information for identifying a group of production items having a common characteristic. However, the summary item identification information is a group of production items having a common characteristic. As long as they can be identified, a combination of symbols or a combination of alphabets may be used.

  If a similar function can be realized, the system configuration, program configuration, data structure, record configuration, processing procedure, etc. can be arbitrarily changed.

  It should be noted that the load man-hour estimating device 1 having a configuration for realizing the functions according to the present invention can be provided as well as existing programs such as existing personal computers and information terminal devices by applying the program. It can also function as the estimation device 1. That is, by applying a program for realizing each functional configuration by the load man-hour estimation device 1 exemplified in the above embodiment so that a CPU or the like that controls an existing personal computer or information terminal device can be executed, It can be made to function as the load man-hour estimation apparatus 1 concerning this invention. Moreover, the load man-hour estimating method according to the present invention can be implemented using the load man-hour estimating device 1.

  Moreover, the application method of such a program is arbitrary. The program can be stored and applied to, for example, a non-transitory computer-readable information recording medium [CD-ROM (Compact Disc Read-Only Memory), DVD (Digital Versatile Disc), MO (Magneto Optical disc), etc.]. In addition, the program can be applied by storing the program in a storage on a network such as the Internet and downloading it.

  It should be noted that the present invention can be variously modified and modified without departing from the broad spirit and scope of the present invention. The above-described embodiments are for explaining the present invention and do not limit the scope of the present invention. That is, the scope of the present invention is shown not by the embodiments but by the claims. Various modifications within the scope of the claims and within the scope of the equivalent invention are considered to be within the scope of the present invention.

  This application is based on Japanese Patent Application No. 2006-021298 filed on Feb. 5, 2016. The specification, claims, and entire drawings of Japanese Patent Application No. 2006-021298 are incorporated herein by reference.

  1 load man-hour estimation device, 2 bar code reader, 3 server device, 1-1 ROM, 1-2 RAM, 1-3 CPU, 1-4 storage device, 1-5 communication device, 1-6 input device, 10 work Results storage unit, 11 Process information storage unit, 12 Work time information storage unit, 13 Estimated condition information storage unit, 14 Performance reflection unit, 15 Extraction unit, 16 Record acquisition unit, 17 Total number calculation unit, 18 Average value calculation unit, 19 Estimated condition information recording unit, 20 accepting unit, 21 acquiring unit, 22 process / work time recording unit, 23 estimating unit, 24 correcting unit, 100 load man-hour estimating system, 101 work result master DB (database), 102 work interruption management master DB, 111 Process master DB, 112 Process update management master DB, 121 Work time master DB, 131 Estimate master DB (summary item number) None), 132 have estimated the master DB (summary item number), 141 order information, 142 unofficial information

Claims (12)

Estimated conditions for storing the keywords extracted by morphological analysis from the item name of each production item, the process path indicating the execution order of each process in the production process of the production item, and the work time required for each process in association with each other An information storage unit;
A reception unit that receives the name of a new production item for which the load man-hours required for production are estimated;
A keyword is extracted by morphological analysis from the item name of the newly produced item received by the reception unit, and the process route and the work time associated with the keyword matching the extracted keyword are extracted from the estimated condition information storage unit. An acquisition unit to acquire;
An estimation unit for estimating the load man-hours of the new production item based on the acquired process route and the work time;
A load man-hour estimation device comprising: Process information that stores process information composed of records each including item identification information of each production item, the item name of the production item, and a process path indicating the execution order of each process in the production process of the production item A storage unit;
For each combination of the item identification information and the process in the production process of the production item, a work time information storage unit that stores the item name of the production item and the work time in association with each other,
An extraction unit for extracting a plurality of keywords by morphological analysis from the item name of the production item stored in the process information storage unit and the item name of the production item stored in the work time information storage unit;
For each of the keywords extracted by the extraction unit, a record acquisition unit that acquires a record including the item name of the production item that at least partially matches the keyword from the process information storage unit as a first diversion candidate record group;
A total number calculation unit that calculates the total number of records having the same process path in the first diversion candidate record group for each process path;
The item identification information is acquired from the first record group, which is a record group having the maximum total number of records, without duplication, and the work time associated with each of the acquired item identification information is the work time. An average value calculating unit that is obtained from an information storage unit and calculates an average value of the work time for each of the process paths;
Said step route included before Symbol first record group, wherein the said calculated average value, the in association with the keyword used to retrieve the first diverting candidate record group the estimated condition information storage unit An estimate condition information recording part to be recorded in
The load man-hour estimation device according to claim 1, comprising: The process path indicates that each process from the first process to the N-th process (N is a natural number) is sequentially performed from the first process in the production process,
The process information stored in the process information storage unit includes a process name and a process order indicating an execution order from the first process to the Nth process,
The total number calculation unit calculates, for each process name, the total number of records having the same process name of the first process in the first diversion candidate record group,
Said average value calculating unit, before Symbol first acquired from record group by omitting duplicate the item identification information, the acquired the item the work the working time associated with the each identification information time information storage The average value of the acquired work time,
The estimated condition information recording unit, and the step name included before Symbol first record group, the process order and the average value of the first diverting candidate record group wherein the average value calculated, the by the calculating section Record in the estimate condition information storage unit in association with the keyword used to acquire
The calculation by the total number calculation unit and the average value calculation unit and the recording by the estimation condition information recording unit are executed for each step from the first step to the Nth step.
The load man-hour estimation apparatus according to claim 2. All the production items of the process information stored in the process information storage unit are classified into a group of production items having common characteristics,
The process information stored in the process information storage unit includes summary item identification information indicating the group to which each production item belongs,
The record acquisition unit includes, for each combination of the keyword extracted by the extraction unit and the summary item identification information stored in the process information storage unit, the summary item identification information that matches the summary item identification information, and A record including an item name of the production item that at least partially matches the keyword is acquired as a second diversion candidate record group from the process information storage unit,
The total number calculation unit calculates the total number of records having the same process path in the second diversion candidate record group for each process path,
The average value calculating unit calculates an average value of the work time for each process route based on the total number of the records calculated by the total number calculating unit,
The estimated condition information recording unit includes the process path included in a second record group that is a record group in which the total number of the records is maximum, and an average value of the work time calculated by the average value calculating unit. Recording in the estimated condition information storage unit in association with the summary item identification information and the keyword used to acquire the second diversion candidate record group;
The load man-hour estimation apparatus according to claim 2. The process information stored in the process information storage unit includes a process name and a process order indicating an execution order from the first process to the Nth process (N is a natural number),
The total number calculation unit calculates, for each process name, the total number of records having the same process name of the first process in the second diversion candidate record group,
The average value calculating unit calculates an average value of the work time required for the first step based on a total number calculation result by the total number calculating unit,
The estimated condition information recording section includes the steps name included before Symbol second record group, the process order and the second diverting candidate records, and the average value of the working time calculated by the average value calculation unit Record in the estimated condition information storage unit in association with the summary item identification information and the keyword used to acquire the group,
The calculation by the total number calculation unit and the average value calculation unit and the recording by the estimation condition information recording unit are executed for each step from the first step to the Nth step.
The load man-hour estimation device according to claim 4. The accepting unit accepts the item identification information of the new production item to be estimated for the load man-hours,
The acquisition unit acquires the process path associated with the item identification information received by the reception unit and the work time required for each process from the process information storage unit and the work time information storage unit,
The estimation unit estimates the load man-hours of the production item based on the process route and the work time acquired by the acquisition unit.
The load man-hour estimation apparatus according to claim 2.   Process information that stores process information composed of records each including item identification information of each production item, the item name of the production item, and a process path indicating the execution order of each process in the production process of the production item A storage unit;
  For each combination of the item identification information and the process in the production process of the production item, a work time information storage unit that stores the item name of the production item and the work time in association with each other,
  An extraction unit for extracting a plurality of keywords by morphological analysis from the item name of the production item stored in the process information storage unit and the item name of the production item stored in the work time information storage unit;
  For each of the keywords extracted by the extraction unit, a record acquisition unit that acquires a record including the item name of the production item that at least partially matches the keyword from the process information storage unit as a first diversion candidate record group;
  Based on the first diversion candidate record group acquired by the record acquisition unit, a work time is acquired from the work time information storage unit, and a statistical value calculation unit that calculates a work time statistical value for each process route;
  An estimated condition information recording unit that records a process route and the calculated statistical value in the estimated condition information storage unit in association with the keyword used for acquiring the first diversion candidate record group;
  The load man-hour estimation device according to claim 1, further comprising: An extraction step of extracting a keyword from the item name of the newly produced item by morphological analysis ;
From the data that associates the keyword extracted by the morphological analysis from the item name of each production item, the process path indicating the execution order of each process in the production process of the production item, and the working time of each process, the extraction step An acquisition step of acquiring the process route and the work time associated with a keyword that matches the keyword extracted in
An estimation step for estimating a load man-hour required for production of the new production item based on the process route and the work time acquired in the acquisition step;
Load man-hour estimation method comprising   Process information composed of records each including item identification information of each production item, item name of the production item, and process path indicating an execution order of each process in the production process of the production item, and the item identification Multiple keyword extraction for extracting a plurality of keywords by morphological analysis from work time information in which the item name of the production item is associated with the work time for each combination of information and the process in the production process of the production item Steps,
  For each of the keywords extracted in the multiple keyword extraction step, a record acquisition step of acquiring a record including the item name of the production item that at least partially matches the keyword from the process information as a first diversion candidate record group;
  A total number calculating step for calculating, for each process path, the total number of records having the same process path in the first diversion candidate record group;
  The item identification information is acquired from the first record group, which is a record group having the maximum total number of records, without duplication, and the work time associated with each of the acquired item identification information is the work time. An average value calculating step that is obtained from information and calculates an average value of the work time for each process route;
  An estimation condition information recording step of recording the process path included in the first record group and the calculated average value in association with the keyword used for acquiring the first diversion candidate record group; ,
  The load man-hour estimating method according to claim 8, further comprising: On the computer,
Extract keywords from morphological analysis from item names of newly produced items,
From the data that associates the keyword extracted from the item name of each production item with the morphological analysis, the process path indicating the execution order of each process in the production process of the production item, and the work time of each process, the new production Obtaining the process route and the working time associated with a keyword that matches the keyword extracted by morphological analysis from the item name of the item;
Based on the acquired process route and the work time, estimate the load man-hours required for production of the new production item,
A program that executes processing. On the computer,
Obtain the process route and work time associated with the stored item identification information of the production item,
Based on the acquired process route and the work time, estimate the load man-hours of the production item,
The program according to claim 10 , further causing the process to be executed.   On the computer,
  Process information composed of records each including item identification information of each production item, item name of the production item, and process path indicating an execution order of each process in the production process of the production item, and the item identification For each combination of information and the process in the production process of the production item, a plurality of keywords are extracted by morphological analysis from work time information in which the item name of the production item is associated with the work time,
  For each of the extracted keywords, a record including an item name of the production item that at least partially matches the keyword is acquired from the process information as a first diversion candidate record group,
  The total number of records having the same process path in the first diversion candidate record group is calculated for each process path,
  The item identification information is acquired from the first record group, which is a record group having the maximum total number of records, without duplication, and the work time associated with each of the acquired item identification information is the work time. Obtained from the information, and calculating the average value of the work time for each process route,
  Recording the process path included in the first record group and the calculated average value in association with the keyword used for acquiring the first diversion candidate record group;
  The program according to claim 11, further causing the processing to be executed.

Images