The present invention relates to a work status prediction apparatus, a method, and a work status prediction program, for predicting a future work status to provide estimation for work.
Conventionally, to estimate progress of various types of work, methods for predicting future work statuses are frequently used. In the method, values of actual result working efficiency (generally, a ratio of an amount of resource to a workload (an amount of work for a predetermined period)) based on an actual result of the work up to date or scheduled working efficiency defined at a scheduling stage are used as reference. Further, to reflect learning effect of workers, a prediction value of the working efficiency may be varied as a function defined on time.
The prediction methods as described above are frequently applied to work in production lines. As an example, Japanese laid-open patent application publication No. 2000-176799 discloses, at paragraphs 0010 to 0012, a production/manufacture scheduling system and Japanese laid-open patent application publication No. 2002-23823 discloses, at paragraphs 0017 to 0018, a production managing system. Further, Trett Consulting Japan Limited disclosed at a seminar held by the Overseas Construction Association of Japan, Inc., “Good and Bad claims”, part 2-15.45 to 16.35, (2002), in which a relation between the number of workers, which is one of factors of the work resource included in the resource, and the working efficiency is analyzed on the basis of actual cases.
In the conventional technologies mentioned above, values of the future working efficiency based on the actual result values or scheduled values are used as constant values as used at an initial stage. However, an actual work may encounter such a phenomenon that, for example, at an initial stage of the work, the working efficiency is low because the worker has not been experienced yet, but as the work has been done, the working efficiency gradually increases, and then, becomes stable. When the remainder of the work becomes little, the working efficiency decreases again because the worker should take time off for procedures at the finish of the work. In other words, the working efficiency frequently varies as time passes.
To solve this problem, a further process may be added to gradually increase the working efficiency as time passes. However, in this method, variation of the working efficiency as time passes does not always agree with the actual working efficiency. Further, this does not reflect the decrease in the working efficiency when the remainder of the work becomes little.
Further, in the conventional method, an amount of resource for the work (work resource amount), e.g., the number of workers, is estimated as the value is scheduled. Actually, the progress of the work may lag behind the scheduled value, which is problematic if the working efficiency is unchanged.
Further, though the work resource amount is increased, the working efficiency does not always increase in proportion to increase in the work resource amount. More specifically, the working efficiency may decrease due to congestion at worker's space caused by increase in the number of workers or due to increase in the number of inexperienced workers.
According to an aspect of the present invention, when a future work status of work is predicted, an amount of variation in the working efficiency (generally, defined as a ratio of an amount of resource to a workload for a predetermined period) and an amount of variation in a resource for the work (work resource), caused in accordance with progress of the work, are considered. Further, the working efficiency may be compensated or altered in accordance with compensation of an amount of work resource (work resource amount).
A further aspect of the present invention provides a work status prediction apparatus for predicting a future work status of work, comprising: work schedule data storing means for storing work schedule data indicative of the work to be done for each future predetermine period such that a work schedule for each future predetermined period is stored as the work schedule data; work actual result data storing means for storing work actual result data, indicative of the work that has been done for each past predetermined period such that a work actual result for each past predetermined period is stored as the work actual result data, the work schedule data and the work actual result data and being entered by a user, the future predetermined period being equivalent to the past predetermined period; work status prediction means for effecting prediction such that a prediction workload of the work for each future predetermined period is predicted from at least one of the work schedule and the work actual result and for predicting the future work status, in which the prediction amount of the future work is reflected in the work schedule data; and prediction result display means of displaying the predicted result from the work status prediction means.
In the above described structure, a prediction workload for each predetermined period may be calculated from at least one of the working efficiency and the schedule resource amount compensated in accordance with progress of the work. Further, the initially set work schedule data (for example, a schedule workload) may be reflected in the calculated prediction workload. This increases accuracy in calculation in the work schedule data.
A further aspect of the present invention described above provides a method of predicting a work status and the work status prediction program for predicting a work status.
When a future work status is predicted, a variation amount of the working efficiency and a variation amount of the work resource (work resource amount) are considered. In other words, working efficiency of various types of work can be accurately calculated though delay or moving-up of a work occurs. Further, it is possible to consider the phenomenon that the working efficiency increases at the initial stage and decreases at the final stage of the work. Further, increase in the number of workers upon occurrence of delay of the work process can be considered. Further, the working efficiency can be compensated in accordance with the compensation of the work resource amount.
The object and features of the present invention will become more readily apparent from the following detailed description taken in conjunction with the accompanying drawings in which:
The same or corresponding elements or parts are designated with like references throughout the drawings.
The work status prediction apparatus predicts a future work status of work. Work schedule data is data of a schedule indicating the work to be processed for each future predetermine period and is entered by a user, wherein the schedule data is stored such that a work schedule for each future predetermined period is stored as the work schedule data. Work actual result data is data of actual results indicating the work that has been processed for each past predetermined period and is entered by the user, wherein the actual result data is stored such that a work actual result for each past predetermined period is stored as the work actual result data. The future predetermined period is equivalent to the past predetermined period. The prediction is made such that a prediction workload of the work for each future predetermined period is predicted from at least one of the work schedule and the work actual result to predict the future work status, in which the prediction amount of the future work is reflected in the work schedule data. The predicted result is displayed and provided to the user.
When a future work status is predicted, the user is requested to previously define variation patterns of the working efficiency and the number of workers (head count) with the variation pattern definition section 4 to store the data for definition in the variation definition data storing section 3. Next, the variation pattern selection section 5 selects one of variation patterns used for each work from the variation patterns of the working efficiency and the number of workers stored in the variation definition data storing section 3. The work status prediction section 6 compensates the working efficiency and the number of workers in accordance with the current progress of the work with the data of the work schedule data and the variation patterns. Further the work status prediction section 6 predicts future time-series variation in an amount of the work resource (work resource amount), a workload (an amount of work), and working efficiency with the data. Further, the prediction result display section 8 displays schedule data, actual result data, prediction data with respect to the work resource amount, the workload, and the working efficiency on the basis of the data from the prediction data storing section 7 in a form of a table or a graphical diagram.
Further, the work actual result data storing section 2 stores actual result data of other past work classified in accordance with each type of the work in addition to the actual result data of the work to be currently estimated. The variation pattern learning section 9 updates parameters defining variation patterns for each type of the works at each predetermined period using the past actuarial result data. The updated actual result data is stored in the variation definition data storing section 3.
The work status prediction apparatus 20 is provided by employing a personal computer (PC) or a file server. The work schedule data storing section 1, the work actual result data storing section 2, the variation definition data storing section 3, and the prediction data storing section 7 are provided by employing a non-volatile storage such as a hard disc drive and a flash memory.
The variation pattern definition section 4 is provided by employing a display, a keyboard, a mouse or the like. The prediction result display section 8 is provided by employing the display. Further, the variation pattern selection section 5, the work status prediction section 6, and the variation pattern learning section 9 are provided by execution of predetermined programs stored in a memory by a central processing unit in the PC.
Outline of Process
In a judging step S202, it is judged whether the work to be estimated has been started. This is judged by checking whether the work actual result data is stored in the work actual result data storing section 2. If the work has not been started (No, in the judging step S202), processing proceeds to a processing step S203. If the work has been started (Yes, in the judging step S202), processing proceeds to a processing step S204. In the processing step S203, the variation pattern selection section 5 adopts scheduled values as reference. More specifically, a value of a scheduled working efficiency is set as a reference value of the working efficiency used in work status prediction. In the processing step S204, the variation pattern selection section 5 selects actual result values. More specifically, a value of actual result working efficiency calculated from an amount of actual result resource (actual result resource amount) and an amount of actual result work (actual result workload) as a reference value for the working efficiency used upon prediction of a work status. In a processing step S205, the variation pattern selection section 5 selects one of variation patterns used in accordance with the type of the work to be predicted, and the type of the part subject to the work carried out, and the scheduled number of workers.
In a processing step S206, the work prediction is executed. More specifically, using the progress of the work and the data stored in the variation definition data storing section 3, values of the prediction working efficiency and the prediction number of workers which are used to estimate a future work status for each week are compensated. Then, values of a prediction workload (prediction workload) and a prediction amount of resource (prediction resource amount) for each week are calculated. On the basis of the data of the compensated values and the data stored in the work schedule data storing section 1, the prediction workload, and the prediction resource amount for each weak are calculated. This process continues until a prospect for completion of the work is provided (until an amount of remaining work becomes zero).
In a processing step S207, the result (prediction result) calculated in the processing step S206 is displayed as numerical data in a table or as a graph for the user. In a judging step S208, it is judged whether the work to be estimated has been started. If the work has not been started (No, in the step S208), the whole of the process is completed. If the work to be estimated has been started (Yes, in the step S208), processing proceeds to a processing step S209. In the processing step S209, variation pattern learning is done. More specifically, the parameters defining the variation patterns of the working efficiency and the number of workers are updated.
Here, “week” corresponds to terms of “a predetermined period” in claims of the specification.
Example of Data Previously Determined
The work status prediction apparatus of the present embodiment will be further described with an example.
If the work to be done has not been started, the actual start day 203 and the actual end date 204 are not stored. If the prediction object of work has not been completed, the actual end date 204 is not stored. Furthermore, the actual result workload 205 for each week and the actual resource amount 206 for each week are stored for all weeks on which actual results exist. Further, in the work actual result data storing section 2, all of actual result data of work executed in the past is left as it is in the similar format. Here, the actual result data is entered by the user or the data for process management that has been stored can be used as the actual result data.
The variation characteristic code 301 of the working efficiency is previously defined and associated, on the basis of a basic data stored in the variation definition data storing section 3, with the type of the work of which work status is predicted and with the type of the part to be used in the work.
Regarding the case that the next week is within the period of construction, when the scheduled number of workers is from one to the threshold value defined in the row 308, a compensation coefficient for the number of workers is shown at a row 308. When the scheduled number of workers is from the threshold value at the row 308 plus one to the threshold value defined in a row 309, a compensation coefficient is shown at a row 309. When the scheduled number of workers is from the threshold value at the row 309 plus one to the threshold value defined in the row 310, a compensation coefficient is shown at a row 310. When the scheduled number of workers is from the threshold value at the row 310 plus one to the threshold value defined in the row 311, a compensation coefficient is shown at a row 311.
Regarding the case that the next week is beyond the period of construction, when the scheduled number of workers is from one to the threshold value defined in the row 312, a compensation coefficient is shown at a row 312. When the scheduled number of workers is from the threshold value at the row 312 plus one to the threshold value defined in the row 313a compensation coefficient is shown at a row 313. When the scheduled number of workers is from the threshold value at the row 313 plus one to the threshold value defined in the row 314, compensation coefficient is shown at a row 314. When the scheduled number of workers is more than the threshold value at the row 314, a compensation coefficient is shown at a row 315. The code at the leftmost column is an identification code for identifying each definition data.
The data includes a coefficient parameters for defining a function for obtaining a working efficiency decrease ratio corresponding to the ratio of the number of increased workers (the number of workers after compensation/the scheduled number of workers) for each variation characteristic code 316 (301 in
The work status prediction section 6 calculates the working efficiency decrease ratio with the function represented in Equation (1) using these parameters.
(Working efficiency Decrees Ratio)=α1LN((Ratio of the Number of Increased Workers)×γ1)+β1 (1)
where LN (*) defines a natural logarithm.
Example of Screen Image for Defining Variation Pattern
On the definition screen image of the variation pattern of the working efficiency in
(Scheduled Working efficiency)=(Scheduled Resource Amount)/(Scheduled Workload) (2)
Further, the screen image displays a working efficiency improvement coefficient 408 defining the efficiency increase ratio for each week for which the working efficiency gradually increases, and the working efficiency deterioration coefficient 409 defining the efficiency decrease ratio for each week for which the working efficiency gradually decreases. The screen image further displays a progress % 410 of the work regarding the workload corresponding to the point 405 (work progress regarding the workload at saturation of increase in the efficiency), and the work progress % (when the efficiency decreases again) 411. The compensation of the variation pattern is done by correcting the displayed number on the boxes 408 and 411 on the screen image in an interactive manner between the user and the work status prediction apparatus 20.
The variation pattern definition screen image shown in
On the variation pattern definition screen image for the working efficiency shown in
After that, the variation pattern selection section 5 selects from the matrix of data shown in
On the variation definition pattern definition screen image, in
Prediction Process of Work Status
First, in step S601, a value indicative of the actual result present week is set to a variable M indicative of the present week to be estimated. Here, the actual result present week means the final week of the actual result data stored in the work actual result data storing section 2. For example, if today is an intermediate day of this week, the actual final week is the last week. In a subroutine step S602, the compensation process is executed for the scheduled number of workers on (M+1)th week on the basis of the data selected by the variation pattern selection section 5. In a processing step S603, one is added to the value in the variation M. In a subroutine step S604, a compensation process of the prediction working efficiency on Mth week is executed. In a processing step S605, the prediction workload is calculated with Equation (3) using the scheduled number of workers calculated in the subroutine step S602 and the data of the prediction working efficiency calculated in the step S604.
(Prediction Workload)=(the Scheduled Number of Workers)×(the Number of Days in the Mth week)/(Prediction Working efficiency) (3)
In a subroutine step S606, the scheduled workload for the Mth week is compared with the value of the prediction workload obtained in step S605 to execute an adjustment process for the scheduled workload for the remaining work. In a judging step S607, it is judged whether the remaining workload of the work is zero or not. If the remaining workload (unfinished workload) is not zero (No, in the judging step S607), processing returns to the subroutine step S602. If remaining workload is zero (Yes, in the judging step S607), processing is completed. The remaining workload is calculated by Equation (4).
(Remaining Workload)=(Scheduled Workload (the whole))−[(Actual Result Workload (accumulation))+(Prediction Workload (accumulation))] (4)
Here, this predetermined value is determined as a value of 10% of the whole of the scheduled workload in order to judge whether the affection of the delay in the workload on the whole of the work is large or not. In the judgment step S610, it is judged whether the variation M is greater than a value which is smaller than the ordinal number of the last week by one. If the variation M is not greater than the value (No, in the judgment step S610), processing proceeds to process in a processing step S611. If the variation M is greater than the value (Yes, in the judging step S610), processing proceeds to a processing step S612. In the processing step S611, the scheduled number of workers for the (M+1)th week is compensated by the following Equation (5).
(The Scheduled Number of Workers for (M+1)th Week)=(the Scheduled Number of Workers for (M+1)th Week)×(Compensation Coefficient) (5)
In the processing step S612, the scheduled number of workers for the (M+1)th week is compensated by compensating the number of workers for the schedule last week as a base with the compensation coefficient for the beyond scheduled process period on the basis of the data selected with the variation pattern selection section 5. More specifically, the scheduled number of workers for the (M+1)th week is calculated by the following Equation (6).
(The Scheduled Number of Workers for (M+1)th Week)=(the Actual (Prediction) Number of Workers for Last Schedule Week)×(Compensation Coefficient) (6)
K=(Scheduled Resource Amount)/(Scheduled Workload) (7)
In the judging step S615, the user is required to select, as a method of calculating the value of the prediction working efficiency K to be reference, either one of methods of calculation with Equation (8) in a processing step S616 or the method of calculation by Equation (9) in a processing step S617. User's selection criteria is such that the processing step S616 is selected when the prediction working efficiency K is calculated on the basis of the tendency of the past actual results, and a processing step S617 is selected when it is calculated on the basis of the tendency just before.
K=(Accumulated Actual Result Resource Amount)/(Accumulation Actual Result Workload) (8)
K=(Actual Result Resource Amount for the Actual Result Last Week)/(Actual Result Workload for the Actual Result Last Week) (9)
In a judging step S618, it is judged whether the progress % of the work regarding the workload up to the Mth week is smaller than the threshold value A of the variation pattern selected by the variation pattern selection section 5. If the progress % of the work regarding the workload up to the Mth week is smaller than the threshold value A (Yes, in the judging step S618), processing proceeds to a processing step S619. If the progress % of the work regarding the workload up to the Mth week is not smaller than the threshold value (No, in the judging step 618), processing proceeds to a processing step S620. Here, the progress % of the work regarding the workload is calculated by Equation (10).
(Progress % of the Work)=[(Actual Result Workload (accumulation))+(Prediction Workload (accumulation))]/(Scheduled Workload (the whole))×100[%] (10)
In the processing step S619, a prediction working efficiency H defied as a prediction variation amount is calculated with a coefficient α of the variation pattern selected by the pattern selection section 5 and a value W represented with an integer indicating past weeks from the actual result last week (in the case that the work has been started) or the scheduled start week (in the case that the work is not started) with Equation (11).
H=αW+K (11)
In the processing step S620, a temporary variation C is calculated with Equation (12) using a value X representing in weeks the period from the actual result last week (in the case that the work has been started) or the scheduled start week (in the case that the work has not been started) to when the progress % of the work regarding the workload exceeds the threshold value A. This temporary variation C represents a value of the prediction working efficiency when the prediction working efficiency becomes a constant value.
C=αX+K (12)
In a judging step S621, it is judged whether the progress % of the work regarding the workload is smaller than the threshold value B of the variation pattern selected by the variation pattern selection section 5. If the progress % of the work regarding the workload is smaller than the threshold value B (Yes, in the judging step S621), processing proceeds to a processing step S622. If the work progress % of the work regarding the workload is not smaller than the threshold value B (No, in the judging step S621), processing proceeds to a processing step S623. In the processing step S622, the prediction working efficiency H is calculated by Equation (13).
H=C (13)
In the processing step S623, the prediction working efficiency H is calculated with the coefficient β of the variation pattern selected by the variation pattern selection section 5 and the number Y of weeks past from time when the work progress % of the work regarding the workload equal to or exceeds the threshold value B with the following Equation (14).
H=βY+C (14)
After the compensation of the working efficiency in the process, further, compensation for the working efficiency accompanied with the compensation of a scheduled resource amount is executed in accordance with the flow of another part S604b of the subroutine 604 as shown in
P=(the Number of Workers after Compensation)/(the Scheduled Number of Workers) (15)
Next, in a processing step S636, three coefficient parameters (coefficient α1317, the coefficient β1318, and the coefficient γ1319) for compensation of the working efficiency are selected from the variation definition data storing section 3 on the basis of information of the variation characteristic code 316 of the work to be processed. In a processing step S637, with the selected coefficient parameters and the value of P, a decrease ratio (KD) of the working efficiency are calculated by Equation (1) previously described.
After that, in a processing step S638, values of P (the ratio of the number of increased workers) calculated as compensation data and KD (working efficiency decrease ratio) are displayed for confirmation by the user.
In a processing step S639, the prediction working efficiency used in the work status prediction is compensated by the following Equation (16) in consideration of the user's setting result in the processing step S638.
(Compensated Working efficiency)=(Working efficiency)×(((Working efficiency Decrease Ratio)/100)+1.0) (16)
In this operation, the compensation of the working efficiency using Equation (16) regarding the work, to which the period limitation regarding the working efficiency decrease is set in the processing step S638, can be executed only within the compensation valid period.
D=(Scheduled Workload for the Mth Week)−(Prediction Workload for the Mth Week) (17)
The variable M used in this equation is the same as that defined in
In the processing step S627, the value of D is added to the scheduled workload for the (M+1)th week. This is because when D has a positive value or a value of zero (No, in the judging step S625), the D indicates that there is a remaining prediction workload, so that the prediction remaining workload for the Mth week is transferred (carried over) to the next week. In a processing step S626, a temporary variable N is defined as one. In a processing step S628, a temporary variable E is calculated by the following Equation (18). In a processing step S628, a temporary variable E is calculated by the following Equation (18). This is because when D has a negative value (Yes, in the judging step S625), the D indicates that there is an unused workload, so that the unused workload for the Mth week is transferred to the next week to be spent.
E=(Scheduled Workload for the (M+N)th Week)+D (18)
In a judging step S629, it is checked whether the value of E obtained in the processing step S628 is smaller than zero. If the value of E obtained in the processing step S628 is smaller than zero (Yes, in the judging step S629), processing proceeds to a processing step S630. If the value of E obtained in the processing step S628 is not smaller than zero (No, in the judging step S629), processing proceeds to a processing step S633. In the processing step S630, the scheduled workload for the (M+N)th week is set to be zero. In a processing step S631, the value of D is updated by the following Equation (19). This is because the value of E is a negative value that indicates a used workload for the (M+N)th week, so that the unused workload E is substituted for D to transfer it to the further next week to be used.
D=E (19)
In a processing step S632, one is added to the value of N, and processing returns to the processing step S628. In a processing step S633, the scheduled workload for the (M+N)th week is set to be E. This is because when E has a positive or a value of zero, E indicates a remaining scheduled workload for the (M+N)th week after the unused workload for the previous week was spent. In a processing step S634, the week having a scheduled workload of zero is cancelled in the whole of the schedule. More specifically, the final scheduled workload at each week is checked. If any week having the scheduled workload of zero exists between the (M+1)th to the (M+N−1)th week, the scheduled workload at the following week is successively moved up to the previous weeks. Thus, the scheduled work in the schedule is cancelled from the last week of the schedule. Here, in this embodiment, a variation in the working efficiency is represented by a first order equation. It is also possible to express the variation in a second order equation or a Weibull function.
Example of Display of Prediction Result
As an example of a graphical display result, a screen image displays a curve 818 representing variation in the scheduled resource amount, a curve 819 representing variation in the actual resource amount, and a curve 820 representing variation in the prediction resource amount. The screen image displays a line 817 representing the current week. Further, in step with the graph displaying, numerical data 821 for each week is displayed.
Process for Learning Variation Pattern
On the other hand, in the processing step S905, values of compensation coefficients for the scheduled number of workers at each classification of the number of workers for each week (See
(Compensation Coefficient)=(the Actual Result Number of Workers)/(the Scheduled Number of Workers) (20)
In a processing step S906, the values of compensation coefficients calculated in the processing step S905 are averaged, and an updating process of the variation definition data stored in the variation defining data storing section 3 with the average value.
Here, the processing steps from S902 to S904 regarding the variation pattern learning and the processing steps from S905 and S906 are executed in parallel.
Further, the processing steps regarding the learning the variation definition data of the working efficiency (Steps S902 to S904 in
As mentioned above, one example of the process according to an embodiment of the present invention has been described. In the actual processing, as shown in
The preferred embodiment has been described according to the present invention with an example. However, the embodiment can be modified.
For example, in the embodiment, the schedule data, the actual result data, and the prediction data is stored in the storing section 7. However, it is also possible to store the schedule data in the work schedule data storing section 1. Further, the actual data can be stored in the work record data storing section 2 and the prediction data can be stored in the prediction data storing section 7. The prediction result display section 8 inputs each data from respective storing sections to use the data to display the prediction result.
Further, the work status prediction apparatus 20 can predict work status for a project including a plurality of sets of work in addition to a set of work. More specifically, the work includes a plurality of different types of substantially sequential processes, and the work status prediction section predicts the future work status of the sequential processes.
Number | Date | Country | Kind |
---|---|---|---|
2004-022484 | Jan 2004 | JP | national |
2004-269740 | Sep 2004 | JP | national |