JP2006318331A - System for work man-hour estimation and personnel allocation, and its method - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To perform estimation of appropriate man-hour and personnel allocation on the basis of the past achievements by estimating the man-hour which takes into consideration of characteristics of every project or development team. <P>SOLUTION: The system has: an evaluation reference management part 102 for creating an evaluation reference of registered work by one-dimensional unit; a work progress management part 103 for registering or updating a new project and work; a work estimation processing part 104 for searching for whether or not work similar to the past one is generated with additional information on the work to be registered as a search key; an empty man-hour search part 105 for obtaining a period of work when personnel are needed and searching for workers to whom the work is available within the period of work to decide by using a computation expression whether or not the person in charge has any empty man-hour; and a personnel competence estimation part 106 for selecting a person in charge of work with skills and experiences best suited to the registration work from among workers who have empty man-hour within the period of work to examine whether or not the workers with empty man-hour satisfy the work man-hour required by the work. <P>COPYRIGHT: (C)2007,JPO&INPIT

Description

  The present invention relates to a work estimation and human resource allocation system for applying an optimal human resource by estimating an appropriate work man-hour from a past performance for a new work and collating it with the human resource skill, and a method thereof.

Conventionally, there have been proposals for managing the degree of progress and results of work for new work, but there have been few proposals for estimating work man-hours and assigning appropriate human resources.
Among them, a human resource allocation method proposed is, for example, a “human resource allocation support system” described in Japanese Patent Application Laid-Open No. 11-288435 (see Patent Document 1).
This support system includes an input / output processing unit, a project information management unit that accepts input of project goal information and manages the information, function items experienced by each human resource, fitness to the function items, new Human resources information management department that accumulates the period of time that can participate in the project, fitness calculation section that calculates the overall fitness level of human resources for each function item of the new project, and the fitness level of human resource allocation in the entire project, that is, the project It consists of a human resource suitability calculation unit that calculates using the estimated value of the expected outcome, a new project information database, a project information database that stores information on projects that have been implemented in the past, and a human resource information database .

  In the above support system, when new project information is sent to relevant terminals in the organization by e-mail, each human resource in the organization looks at this project information and, if necessary, requests to participate in the project to the support system by e-mail. Send. The Human Resources Information Management Department shows in advance the human resource name, experienced function items, suitability to functional items, information about experienced projects, and the period of participation in new projects in the personnel information database. A free schedule is set. Here, the degree of conformity is a numerical value representing the length of time (experience) engaged in the research and development of functional items. In addition, it is described that the proficiency level may be an evaluation value of skill level and ability of skill and work of function items separately determined by the person himself or his supervisor. The selection is performed by comparing the execution schedule in the new project database with the empty schedule in the human resource information database.

Japanese Patent Laid-Open No. 11-288435

In the conventional system, there is a problem that in the development work, the project manager cannot adjust the schedule in consideration of the worker's ability and the available man-hours, and the work delay occurs. Conventionally, the fitness calculation for achieving the target is performed based on a preset hierarchical relationship. That is, the fitness is calculated using existing static evaluation criteria.
However, what is originally desired is to estimate the man-hours in consideration of the characteristics of each project and development team without using static existing evaluation standard values. It is desirable to calculate the amount of work depending on the ability of the team based on the past performance values and the amount of work of the new project. In addition, it is desirable to assign human resources that flexibly correspond to the changing work ability of individual human resources, based on past performance values of individual human resources and subordinate work preparation skills of new projects.

(the purpose)
The purpose of the present invention is to estimate the man-hours taking into account the characteristics of each project and development team without using static existing evaluation criteria, and to determine the functional elements determined by the registrant's intention to register a new project. It is an object to provide a work man-hour estimation and human resource allocation system and method capable of more accurately estimating man-hours and assigning suitable human resources based on past results.

  The work man-hour estimation and human resource allocation system of the present invention has a function of estimating man-hours for new work by searching for similar work done in the past, and also calculates the worker's vacant man-hour and worker skill information. The worker having the function to perform and having the manpower required for the work is searched from the workers having the available man-hours within the work period of the new work, and a human resource is assigned as the optimum worker.

  That is, the work man-hour estimation and human resource allocation system of the present invention creates an evaluation standard for registered work in a one-dimensional unit, registers or changes the created information, and manages a new project. A work progress management unit that registers or updates tasks, a work estimation processing unit that searches whether additional work information to be registered is used as a search key, and whether or not a work similar to the past work has occurred, and a work to be registered The work period that requires human resources is obtained from the work start date and the work end date, and a worker who is active in the work period is searched. If there is no other work that the worker is in charge of, the work is performed. It is determined that there are available man-hours, and if there is, there is an empty man-hour search unit that determines whether the person in charge has free man-hours using a calculation formula, and among workers who have free man-hours within the work period. To the most registered work Select the person in charge from those who have the skills and experience that have been assigned, and evaluate the aptitude for human resources to check whether the person in charge of the work satisfies the work manpower required for the work for the worker with available man-hours. Department, project and work information in units of dimensions, a work evaluation standard database that holds the work items in the dimensions and dimensions linked to each other, and stores the registered project and work data, and expresses the project It is characterized by having a work progress database for storing necessary items and a human resource management database for holding management items for the names of human resources, effective work start dates, and effective work end dates.

  In the present invention, first, an evaluation standard database is provided as function information expressing what functional elements the project has, and the project is expressed. This functional element can be added at any time according to the intended situation, and unlike the conventional case, it does not include numerical information used to calculate the human resource fit rate for each functional element, and registers a new project. By using a value determined according to the intention of the registrant, it is possible to estimate the man-hours more accurately and assign suitable human resources.

  According to the present invention, by not using existing static evaluation criteria, it is possible to estimate the most realistic man-hours and assign suitable human resources in consideration of the features of each past project and development team. Become.

Embodiments of the present invention will be described below in detail with reference to the drawings.
FIG. 1 is a functional configuration diagram of a work man-hour estimation and human resource allocation system according to an embodiment of the present invention.
As shown in FIG. 1, the system 100 according to the present embodiment includes an input / output processing unit 101, an evaluation criterion management unit 102, a work progress management unit 103, a work estimation processing unit 104, a free man-hour search unit 105, and a human resource aptitude estimation unit 106. , A work evaluation reference database 107, a work progress database 108, and a human resource management database 109.
Hereinafter, functions and operations of the units 101 to 109 will be described.

(Data management department (contents of each database))
FIG. 2 is a diagram showing an example of data items of evaluation criteria managed by the work evaluation criteria database in FIG.
The work evaluation reference database 107 handles project and work information in units of dimensions, and each dimension has work items for expressing projects and works. For example, as shown in FIG. 2, the dimensions include work purpose, work, work content, customer, project, accounting work, etc., and the items are 1 (requirement definition), 2 (development), 3 (Survey), 4 (Material creation), etc.
In the work evaluation reference database 107, only the dimension and the work item in the dimension are linked and held, and the information necessary for calculating the work man-hour is not held.

FIG. 3 is a diagram showing an example of work items managed by the work progress database in FIG.
FIG. 3 lists data items in the work progress database 108 that stores registered projects and work data. Necessary items for expressing a project include work number, project name, work man-hour, work start date, work end date, actual start date, actual end date, actual response rate, actual man-hours, work contents, and customer.
In addition to the essential items for expressing the project, the essential items for expressing the work have each information of the parent work number, the work name, the work in charge, the person in charge, and the response rate.

  Each item will be described below. The work number is a unique number for managing a project or work, and is information used for associating with a related parent work. The parent work number is an item expressing which project and work the work is generated from. The parent work number can be managed by indicating the work one level higher. The project name is the name of the project and the project in which work is occurring. The work name is a name for expressing the actual work. The work in charge is an evaluation standard expressed as the largest classification for the work, and this actual data is determined from those managed in the work evaluation standard database 107.

  The person in charge is the person in charge who actually performs the work. Since the work progress information is registered for each person in charge of work, if there are a plurality of work persons in the same work, the work information is registered with a new work number. The response rate expresses the ratio of man-hours corresponding to the worker in charge per month, and is actually expressed by information from 0 to 1. The work man-hour expresses the work amount in the work, and the numerical value is determined by reference from the registrant and other work. The work start date is the date on which the work is scheduled to start, and the work end date is the date on which the work is scheduled to end. The actual start date and actual end date express the date when the person in charge actually started the work and the date when the work was completed. The actual response rate expresses the amount actually handled by the worker when the work is completed per month. The actual man-hour is information that is input after actually completing the work, and the basic work amount that one worker usually performs in one month is 10000, and the work amount is defined. The time work man-hour represents a work amount that has been completed and corrected from the planned work man-hours.

Next, additional information expressing project information and work information will be described.
In the system of this embodiment, as a method of expressing project information and work information, it has a function of searching and creating from other similar work information, and a work evaluation standard is used to express information for search. Used.
The number of additional information is not limited, and an applicable item can be arbitrarily selected from the work evaluation reference database 107.

FIG. 4 is a diagram showing a management example of the human resource management database in FIG.
As shown in FIG. 4, the management items of the human resource management database 109 for managing human resource information related to the project are composed of the name of the human resource, the effective work start date and the effective work end date, and have been related to the work so far. The workable period of workers is managed. Here, a human resource whose effective work end date is blank “−” means that the work end date has not been determined and is treated as a human resource capable of working at the present time. In other words, since it is clear that a person whose work end date is fixed will be transferred to the next work, it cannot be handled as a workable person. The efficient allocation method of the present embodiment allocates human resources having similar work contents (high relevance rate) and high response rate (ratio of man-hours corresponding to work personnel per month).

(Function Department (Estimation of human resources aptitude / vacant man-hour search))
The input / output processing unit 101 can perform additional registration of work evaluation criteria, registration of work, update of work progress, and additional registration of human resource management information using a GUI (Graphical User Interface). It is possible to update the work evaluation standard, work progress information, and human resource management information.
The evaluation standard management unit 102 can create the evaluation standard shown in FIG. 2 in a one-dimensional unit through the GUI of the input / output processing unit 101.
In addition, the work progress management unit 103 can register / update a project and work information related to the project.
The evaluation criterion management unit 102 registers / changes the work evaluation criterion.
The input / output processing unit 101 has a GUI function and is used for information input / output such as work progress management and evaluation reference management.
The work progress management unit 103 registers a project and work by the user.

FIG. 5 is a flowchart for calculating the work man-hour according to an embodiment of the present invention.
The registrant first inputs the project name, work name, assigned work, work start date, and work end date as necessary information regarding the project and work (steps 201 and 202). Next, the evaluation standard list information is read from the work evaluation standard database 107, and an arbitrary number of dimensions and items for expressing the registered work are selected (step 203).
Next, although the work man-hour is input, the work man-hour candidates can be referred to from similar work completed in the past.

The work estimation processing unit 104 searches the work progress database 108 using the additional information of the work to be registered as a search key to determine whether a work similar to the past work has occurred (step 208). In the search, first, a man-hour relational expression for representing a priority order between work items between dimensions and within dimensions is defined in advance for dimensions and items to be search keys (steps 206 and 207).
FIG. 6 is a dialog for inputting a relationship between dimensions, and weighting is performed with a value from 0 to 1 between all dimensions added to the registered work. Here, as an example, the work content is defined as 1, the work weight is defined as 0.7, and the customer weight is defined as 0.5. The registrant decides where to place weights into consideration. That is, in the search, 1 is set when the work content is hit, whereas 0.7 is set when the work is hit and 0.5 is set when the customer is hit.
FIG. 7 is a dialog for inputting the relationship between items in the dimension. The weight of the item registered in the work is set to 1, and values from 0 to 0.9 are added to the other items. . Here, as an example, the weight of the correction item is defined as 0.7.

In the search, an OR search is performed at the dimension level (items between dimensions) from the additional information of the work, and then an OR search is performed on items in the dimension (step 212). The search result is extracted as a similar work list 211. If there are a plurality of search results, the work relevance ratio is obtained using the calculation formula shown in FIG. 8 using the relational expression registered at the time of search (step 210). As shown in FIG. 8, an OR search is performed for each number of search dimensions, the dimension N evaluation ratio corresponds to the weight between dimensions, the evaluation ratio of the dimension item corresponds to the weight in the dimension, and the difference from 1 and ( 100 / number of search dimensions), and the product obtained by subtracting these products from 100 is the precision.
After obtaining the work relevance ratio, a list of similar work candidates is displayed in order from the work having the highest relevance ratio. The work registrant selects the most similar work from this list, and applies the actual work man-hour required for the work as the work man-hour of the work to be registered this time (step 213).

The last item to complete the work progress table is the person in charge and the response rate. This is calculated from the empty man-hour search unit 105 and the human resource aptitude estimation unit 106 based on the information on the work man-hours, the work start date, and the work end date.
FIG. 9 is a process flowchart for searching whether or not there is an empty man-hour for the worker within the work period according to one embodiment of the present invention.
When the empty man-hour search unit 105 is activated, first, a work period requiring human resources is obtained from the work start date and work end date of the work to be registered (steps 312 and 313). Next, a worker whose work is effective for the project team within this work period is searched from the human resource management database 109 (step 314). The human resources that the project team exists in the work period may also be doing several different work, so the worker is responsible for other work within the period using the searched worker and work period as a key. It is searched from the work progress database 108 whether or not there is (step 316).

  If there is no other work that the worker is in charge of, it can be determined that there are man-hours that can be worked on, but if other work is in charge, the formula shown in FIG. 320), it is determined whether or not the person in charge has an empty man-hour (step 318). The person in charge of the work is selected from those who have free man-hours within the work period and those who have the skills and experience most suitable for the registered work. That is, if the worker availability ratio is 0 or more, it is extracted as a work assignable human resource (step 321). In the calculation formula of FIG. 10, α is a person whose work period is valid from the effective work period table, β is a corresponding case to be calculated for each of a plurality of cases, and Σ is calculated for each β. It is the total value of the corresponding rates. The fraction in parentheses is the ratio of the period of how much of the other work β is done for this human resource α for the registered work period, and the corresponding rate is the period spent in one month For example, the value is 0.5, for example.

FIG. 11 is a flowchart of a human resource aptitude estimation function according to an embodiment of the present invention.
Here, the work man-hour of the worker who is in charge is estimated by a trial calculation formula, and it is determined whether or not the necessary work man-hour is satisfied. First, in a loop from step 402 to step 408, after obtaining the suitability value for the registered work for all workers, the work man-hour within the work period considering the suitability value is obtained. Next, in the loop from step 411 to 417, after determining whether or not the man-hours that the worker can work satisfy the man-hours of the registration work, if not, the worker's response rate for the necessary man-hours is set. calculate.

That is, when the human resource aptitude estimation unit 106 is activated, the free manpower information (list of workers having free manpower and the available correspondence rate for each worker shown in FIG. 10) 403 is input, and the aptitude for each worker is input. The value is searched (step 402). Next, the work progress database 108 is accessed, information is sequentially read out for each worker α, and the suitability value for the registered work β of the worker α is obtained using the suitability value calculation formula 406 shown in FIG. 12 (step 404). ). The formula for calculating the suitability value in FIG. 12 is similar to the formula for the suitability ratio in FIG. 8, except that the item hit rate is further multiplied by the same formula in parentheses. The item hit rate is a coefficient that means that a person who has hit the same work in the past three times has priority over a person who has been in the past once.
Next, based on the obtained suitability value 409 of the worker, the work man-hour within the work period in consideration of the suitability value is obtained (step 407). After obtaining all the workers α, a worker assigned to the registered work is selected from the list of workers and suitability values (step 410).

  Next, it is determined whether or not the man-hour that can be worked by the worker satisfies the man-hour for registration work based on the man-hour for registration work (remaining work man-hour) 414 until the work man-hour for registration work is satisfied (step 412). In the case of satisfying, the response rate for the worker's registration work is registered as the response rate for the empty man-hour (step 413). If the work man-hour is not satisfied, the work correspondence rate calculation formula (see the work correspondence rate calculation formula in FIG. 13) is used to calculate the worker correspondence rate of the man-hour required for the registration work (step 416). . Then, each assigned worker is registered in the work progress database 108 (step 418). In this way, with respect to the work man-hours that do not satisfy the required work man-hours, the worker to be assigned next is selected from among the workers having free man-hours.

  As shown in FIG. 13, the work man-hours for work within a period is a value obtained by multiplying the basic work man-hours per month, the empty man-hour ratio for each work period, and the work suitability rate, and the work response rate. The calculation formula is divided into two: 1) If the work man-hour of the human resource α is equal to or greater than the work man-hour for the work within the period, the work correspondence rate of the human resource α is the free man-hour rate (of course, 2) If the work man-hours of the human resources α are less than the work man-hours for the work within the period, the work response rate of the human resources α is the work for the basic work man-hours. It is a value obtained by dividing the ratio of man-hours by the work aptitude rate.

FIG. 14 is a three-dimensional space diagram showing the work for each dimension and the skill range of the worker.
Here, taking the business dimension as an example, the item range related to the work and the skill range possessed by the worker's business dimension are visually represented in three dimensions. In this graph, the vertical axis of the graph is the work man-hour and the horizontal axis is the dimension item, but for the work to be registered, the visual range is expressed by the relational expression between the item expressed by the work progress and the item, For the worker, the horizontal axis is expressed based on the previous work searched using the dimension as a key and the hit rate of the dimension item expressed in the work. The hit rate of the dimension item at this time is calculated by using the calculation formula shown in FIG. In the three-dimensional space diagram of FIG. 14, the white space surrounded by the line is the skill range based on the work history of the human resource A, and the gray space is the current work range for each dimension. It can be judged whether or not it can be satisfied by how much the range of the white space covers.
In addition, this makes it possible for the human resource to perform what kind of work in the past and what results have been obtained, but it becomes clear at a glance and is useful as a judgment material.

FIG. 15 is a diagram illustrating a hit rate calculation formula for a dimension item.
This formula is a formula showing the hit rate of the dimension item in FIG. 14, and how many projects are there for the human resource, how long the work period has been done, what is the correspondence rate, etc. It is a formula that multiplies each and looks at the hit rate comprehensively.

It is a block block diagram of the work man-hour estimation and human resource allocation system which concerns on one Example of this invention. It is a figure which shows the storage data of the project evaluation reference | standard database in FIG. It is a figure which shows the storage data of the work progress database in FIG. It is a figure which shows the storage data of the human resource management database in FIG. It is an operation | movement flowchart of the operation man-hour calculation process which concerns on one Example of this invention. It is a figure explaining the weighting between the dimensions on a screen. It is a figure explaining the weighting between the items in the dimension on a screen. It is a figure which shows the calculation formula of work search precision. It is a flowchart of the empty man-hour search process which concerns on one Example of this invention. It is a figure which shows the calculation formula of an empty correspondence rate. It is a process flowchart of the personnel aptitude estimation function which concerns on one Example of this invention. It is a figure which shows a worker's work aptitude value calculation formula. It is a figure which shows the calculation formula of work corresponding | compatible rate. It is a figure which shows the work for every dimension, and the skill range of an operator. It is a figure which shows the hit rate calculation formula of a dimension item.

Explanation of symbols

DESCRIPTION OF SYMBOLS 100: Work man-hour estimation and personnel allocation system 101: Input / output processing part 102: Evaluation reference management part 103: Work progress management part 104: Work estimation processing part 105: Empty man-hour search part 106: Personnel aptitude estimation part 107: Work evaluation reference Database 108: Work progress database 109: Human resource management database

Claims (9)

In the work man-hour estimation and human resource allocation system that allocates the optimal human resources for new work by estimating work man-hours based on past results and comparing them with human resource skills,
An evaluation standard management unit that creates an evaluation standard for registered work in a one-dimensional unit, registers or changes the created information, and manages,
A work progress manager that registers or updates new projects and work,
Using the additional information of the work to be registered as a search key, a work estimation processing unit for searching whether a work similar to the past work has occurred,
When a work period that requires human resources is obtained from the work start date and work end date of the work to be registered, a worker who is effective in the work period is searched, and there is no other work that the worker is in charge of If there are other tasks in charge, the available man-hours search unit that determines whether the person in charge has available man-hours using a calculation formula,
From the workers with available man-hours within the work period, select the worker in charge from those who have the skills and experience that best match the registered work, and work is required for workers with available man-hours. A personnel aptitude estimation unit that checks whether or not the person in charge satisfies the work man-hour
A work evaluation standard database that handles project and work information in units of dimensions and holds the work items in the dimensions and associated with them,
A work progress database for storing the registered project and work data and storing necessary items for expressing the project;
A work man-hour estimation and human resource allocation system characterized by having a human resource management database that holds management items for the names of human resources, effective work start dates, and effective work end dates. With the work progress management department, in the work man-hour estimation and human resource allocation method for obtaining work man-hours of work,
Access the work evaluation criteria database, read the evaluation criteria list information from the database, and express the work content,
Enter the relational expression between the dimensions and items in the dimension for the expressed work content,
Select an arbitrary number of dimensions and items for expressing the work to be registered from the work evaluation criteria database,
Using the additional information of the work to be registered as a search key, search for whether or not work similar to the past work has occurred,
If there are multiple search results, calculate the work relevance rate by the arithmetic circuit using the relational expression registered at the time of search,
A work man-hour estimation and human resource allocation method characterized in that a real work man-hour of a similar work most suitable for a registration work is used as a work man-hour for registration work. In the work man-hour estimation and personnel allocation method according to claim 2,
The relational expression between the items between the dimensions and within the dimensions is a weight for indicating a priority between the work items between the dimensions and within the dimensions,
The relational expression registered at the time of the search is represented by: relevance ratio = 100−Σ {(100 / number of search dimensions) × (1-dimensional N evaluation ratio) × (1-dimensional item evaluation ratio)}. Work man-hour estimation and personnel allocation method. In the work man-hour estimation and human resource allocation method for searching whether or not the worker has free man-hours within the work period by the free man-hour search unit,
From the work start date and work end date of the work to be registered, calculate the work period that requires human resources by the arithmetic circuit,
Access to the human resource management database, search for and retrieve workers who are effective within the work period,
Using the searched worker and the work period as a key, search the work progress database to determine whether the worker is in charge of other work within the period,
If there is no other work that the worker is in charge of, determine that there are man-hours that can be worked on,
If there is other work that the worker is in charge of, determine whether the person in charge has available man-hours by the calculation formula,
A work man-hour estimation and human resource allocation method characterized by determining whether or not a person in charge satisfies a work man-hour required for work with respect to a worker having free man-hours. In the work man-hour estimation and personnel allocation method according to claim 4,
The calculation formula is represented by: empty correspondence rate = 1−Σ {(work period of work β / registration work period) × correspondence rate}. In the human resource aptitude estimation unit, the work man-hour estimation and the human resource allocation method for estimating the work man-hour of the worker who is in charge and calculating whether the required man-hour is satisfied or not,
Search the aptitude value for each worker from the empty manpower information,
Access the work progress database, read the work man-hours of the worker, calculate the aptitude value by the calculation formula of the aptitude value for the worker's registered work using the arithmetic circuit,
Calculate the work man-hours within the work period considering the aptitude value,
Select the worker to be assigned to the registered work from the list of workers and aptitude values,
Judge whether or not the man-hours that can be worked by the worker satisfy the man-hours for registration work until the work hours for registration work are met,
Register the response rate for the worker's registration work as the response rate for empty man-hours,
Using the work correspondence rate calculation formula, calculate the worker's correspondence rate for the number of man-hours required for registration work by the arithmetic circuit,
A work man-hour estimation and human resource assignment method, wherein each assigned worker is registered in the work progress database. In the work man-hour estimation and human resource allocation method according to claim 6,
The formula for calculating the aptitude value is represented by 100−Σ {(100 / number of search dimensions) × (1-dimensional N evaluation ratio) × (1-dimensional item evaluation ratio) × item hit ratio}.
The work correspondence rate calculation formula is an empty man-hour rate (the work man-hour is insufficient) when the work man-hour ≧ the work man-hour for the work within the period,
A work man-hour estimation and human resource allocation method characterized in that (work man-hour / basic work man-hour) / work aptitude rate when work man-hour <work man-hour for work within a period. In the work man-hour estimation and human resource allocation methods that visually represent the skill range of the work related item range and the worker's work dimension in three dimensions,
The vertical axis of the graph is the work man-hours, the horizontal axis is the dimension item, and the visual range is expressed by the relational expression between the items expressed by the work progress regarding the registered work,
A work man-hour estimation and human resource allocation method characterized in that the horizontal axis is expressed based on the past work searched for using the dimension as a key and the hit rate of the dimension items expressed in the work for the worker. . In the work man-hour estimation and personnel allocation method according to claim 8,
The hit rate of the dimension item is represented by {(number of hits / number of work) × Σ (work period N / effective work period) × (correspondence rate / actual response rate)}. Assignment method.

Images