New Developments in Scheduling ApplicationsView this Special Issue
Research Article | Open Access
Victor Fernandez-Viagas, Jose M. Framinan, "Integrated Project Scheduling and Staff Assignment with Controllable Processing Times", The Scientific World Journal, vol. 2014, Article ID 924120, 16 pages, 2014. https://doi.org/10.1155/2014/924120
Integrated Project Scheduling and Staff Assignment with Controllable Processing Times
This paper addresses a decision problem related to simultaneously scheduling the tasks in a project and assigning the staff to these tasks, taking into account that a task can be performed only by employees with certain skills, and that the length of each task depends on the number of employees assigned. This type of problems usually appears in service companies, where both tasks scheduling and staff assignment are closely related. An integer programming model for the problem is proposed, together with some extensions to cope with different situations. Additionally, the advantages of the controllable processing times approach are compared with the fixed processing times. Due to the complexity of the integrated model, a simple GRASP algorithm is implemented in order to obtain good, approximate solutions in short computation times.
The lead time required to carry out a project—project makespan—has turned to be one of the main sources of competitive advantage for companies (see, e.g., [1, 2]). Since, in many cases, the processing times of the tasks that compose a project depend on the resources allocated to the task (see, e.g., ), it is clear that the project lead time depends both on the scheduling of the tasks and on the allocation of staff to these tasks. Regarding task scheduling, it encompasses the sequence to be followed by each task over time, and it is usually regarded as an important aspect of the industrial organization  and production . On the other hand, staff assignment is essential in a project  and it can be defined as the allocation of company workers to different tasks. Traditionally, staff assignment is included within the manpower planning as one of its steps. Thus, several authors [7–10] have considered the following structure: planning; scheduling; allocation. In staff assignment, worker’s satisfaction tends to be maximized whereas makespan and production costs are often minimized in task scheduling. To execute a task, it is essential that a particular employee is available at that time; otherwise the realization of such task should be postponed until the employee becomes available and, consequently, staff assignment directly influences task schedule. Due to the importance of the scheduling and the assignment in a project environment and since both are very related, it is critical to address both problems in an integrated manner. Furthermore, the majority of scheduling problems in the literature consider fixed processing times  and most of the rest assume that processing times depend linearly on the amount of resources assigned . As lead times strongly depend on the processing times of the task, and since the processing time of a task depends on the number of employees assigned to this task, in this paper we explicitly take into account this relationship.
In this paper, an integration of project scheduling and staff assignment (PSSA) problem with controllable processing times (CPT) is presented using renewable resources and nonpreemptive tasks. Minimization of the makespan has been chosen as the objective function since delays can lead to an increase in costs and even to the loss of customers. This problem can be placed within the project management process. According to Demeulemeester and Herroelen , the project life cycle is as follows.(i)Concept Phase. There is a need of a customer to perform a project. This need is transmitted to the company.(ii)Definition Phase. First, the goal of the project is defined. Next, the work content is defined and, finally, a project strategy is elaborated to achieve the goal.(iii)Planning Phase. The project is divided into tasks. Then, their processing times are estimated and both the resources requirements and the precedence relationships between tasks are identified.(iv)Scheduling Phase. Both task scheduling and the amount of resources in each period of time are defined in this phase(v)Control Phase. In this phase it is controlled that the project is implemented following the aspects defined in the planning and scheduling phases.(vi)Termination Phase. This phase corresponds to the delivery of the results of the project.
Note that between the scheduling phase (where the amount of resources is known) and the control phase there must be an assignment of resources to the tasks if the resources are not identical. For these cases, an additional phase is therefore needed. This phase—named “resources assignment phase”—must be placed between the scheduling phase and the control phase. Alternatively, integration between the scheduling and the resources assignment phases can be done. The latter is the adopted approach in this paper, which is organized as follows: a state of the art and a description of the problem are shown in Section 2. An extended explanation of the CPT is also presented, while the problem statement and a formulation of the integer linear programming model are shown in Section 3. Additionally this integer linear programming model is compared with a multimode formulation. In Section 4, we define a simple GRASP heuristic algorithm for the problem. Section 5 contains computational experiments based on a test bed. Besides, a comparison between the model with and without CPT is shown there. Lastly, conclusions are described in Section 6.
2. Literature Review
The model presented in this paper includes two decision problems: task scheduling and staff assignment. Task scheduling is traditionally denoted in the literature as project scheduling problem (PSP). Furthermore, if limitations regarding the number of resources per activity are assumed, it is named resource-constraint project scheduling problem (RCPSP). This problem has been extensively studied in the literature, and recent reviews can be found in Węglarz et al.  and Hartmann and Briskorn . Staff assignment is a type of assignment decision problem that has also been extensively addressed . Nevertheless, the integration between project scheduling and staff assignment has not been so comprehensively studied, and hence there is still no consensus about the name of this joint problem (see in Table 1 different names that have been used to denote the problem). In our work, we consider the name “project scheduling and staff assignment” as denomination for the problem.
Our problem is related to several contributions in the literature, which are summarized in Table 2. Bassett  presents a model of project scheduling and staff assignment considering time windows for the completion times of the tasks. Vairaktarakis  adds precedence relationships to the integrated problem. However, no time units are used in the linear programming model (the order of the tasks defines the schedule of the project). Time units are included in a similar problem by Bellenguez and Néron  and Bellenguez-Morineau and Néron  where some lower bounds are calculated in the former reference, while in the latter the authors implement a branch and bound algorithm. External and internal resources constraints are considered by Kolisch and Heimerl . Wu and Sun  present the integrated problem proposing a nonlinear model, which is solved by a genetic algorithm. Although learning effect (i.e., the longer an employee works on a task, the greater his/her efficiency is) is considered in the model, neither precedence relationships nor skill constraints are used in their model. Gutjahr et al.  consider portfolio selection and skills in the integrated problem with learning effect but with precedence relationship which are included by Gutjahr et al. . Precedence relationships are also included by Corominas et al.  in an integrated problem, similar to the problem of Wu and Sun , also with learning effect. Drezet and Billaut  propose a linear programming model for a project scheduling and staff assignment problem. However, they do not consider learning effects in the model and include move constraints (i.e., the number of assignment movements of the employees from one nonfinished task to another is bounded). Moreover, the number of employees assigned to each task at each period of time is set between a minimum and a maximum depending on the level of skills of the workers. However, the processing times of the tasks are assumed to be fixed and not depending on the number of employees assigned. Since no solutions can be found for medium-sized instances of the problem, a tabu search algorithm was implemented using a greedy algorithm as initial solution.
|Processing times are preprocessed depending on the number of assigned employees or on the level of skills of the assigned employee(s) and then they are introduced in the model as data.|
An integer programming model is solved, although the way to do it is not explained.
A common feature in all the aforementioned works is that none of them include variable processing times. Regarding CPT, Hachicha et al.  propose a staff assignment model considering multiskilled employees, preference of the employees for some tasks, and skill-based processing times (i.e., the processing times of the tasks depend on the skills of the employee). Nevertheless, they are preprocessed before solving the model, which means that the processing times do not change during the planning horizon. More specifically, processing times are first calculated depending on the skills of each employee and then introduced in the model as data. Heimerl and Kolisch  analyze a staff assignment problem without scheduling considering learning effect on the employees, so the processing times are now variables of the problem as they depend on the experience of the staff. In order to solve this problem, a nonlinear model is implemented. Hachicha et al.  and Heimerl and Kolisch  use CPT in their models, although none of them solve the integrated problem (only the staff assignment problem). Variable processing times in a scheduling problem can be found in Alfares and Bailey . They use a linear programming model to schedule the task of a project and to assign the number of employees to each task; that is, the variables of the problem are the starting times of each task, the processing times, and the number of employees per period. Regarding the processing times, they are chosen to minimize the costs, but they do not depend on any variable. Moreover, staff assignment for each employee is not considered there.
CPT in an integrated PSSA problem are considered in Drexl , Dodin and Elimam  with the objective of costs minimization. However, in their models, the processing times depend on the skills of the employee assigned (and consequently are introduced in the model as data), but not on the amount of resources allocated; that is, processing times are defined by a matrix of two dimensions where the rows are the processing times of the tasks and the columns the employees. In Valls et al. , each task has to be performed by a single employee and its processing time increases or decreases depending on the efficiency of the employee. Nonpreemptive tasks with release times and due dates are taken into account, as well as precedence relations with time lags. No programming model is implemented, but a hybrid genetic algorithm is developed to solve the cost minimization problem. This contribution is the one most related to our problem, since the authors implement an integrated PSSA with CPT. However, in our paper, a linear programming model is considered to minimize the makespan of the project where the processing times of the tasks depend piecewise linearly on the number of employees assigned instead of the efficiency level of the employee and multiple assignments to each task are also allowed as well, while in Valls et al.  each task must be implemented by a single employee. To the best of our knowledge, the proposed model has not been analyzed before.
3. Model Proposal for the Integrated PSSA Problem
3.1. Problem Statement
This paper presents a PSSA problem in which a company is responsible for the implementation of a project consisting of tasks (with task ) with (known) precedence relations between tasks (i.e., some tasks should be finished before carrying out others). The order of execution of each task has to be decided to minimize the corresponding objective function. Each task must be performed by some workers from total of employees (employee ) with certain skills in each period of the planning horizon .
It is assumed that each task has a release time , so it must always start after this time. Furthermore, once a task starts, it runs continuously until its end (nonpreemptive approach). One employee can be assigned to a task if the employee possesses the required skills for the task. We assume that there is an optimal number of employees, , to be assigned to each task, although overcoverage and undercoverage of employees are allowed by the model. Under- and overcoverage would lead to different values of the efficiency of the employees and, consequently, to different processing times of the tasks.
3.2. Controllable Processing Times (CPT)
In this paper, we assume that processing times depend on the resources (or employees, as we would use both terms as equivalent in this paper) assigned. Such type of processing times has been studied in the literature as a function of the resources allocated and of the experience of the workers (level of skills). The relationship between time and amount of resources has been mainly analysed under two different approaches, namely, linear and convex (see the review by ). In the linear approach (see, e.g., ), a linear relationship between the processing times of a task and the resources allocated to this task is assumed. Denoting as the processing time of task and as the number of resources allocated to this task, this relationship can be expressed as , with and constants. However, this approach is not well suited to many realistic situations, since according to Belbin , there must be an optimal number of employees to be assigned to task in order to achieve maximum workers’ efficiency (point ). Therefore, it is easy to see that the linear approach is not flexible to this concept, at least for values to each side of the efficiency level since the efficiency point of worker must always be in an extreme of the line (see, e.g., Figure 2(a), where the efficiency point is placed for resources).
In the convex approach it is assumed that there is an inverse relationship between processing times and employees (see, e.g., ), where and (normally denoted workload of the task ) are constants:
For , the number of resources and the processing times are inversely proportional (e.g., doubling the employees would cut the processing time by half and vice versa; see the red line of Figure 1). The convex relationship is closer to real life than the linear and it has been used for many actual government and industrial projects , distributed communication network, time-sharing computing system, and chemical plant or commercial construction projects . Nevertheless, its nonlinearity would preclude modeling the problem using linear programming. Thus, in this paper a piecewise linear relationship to represent the relationship between processing times and amount of resources assigned to the task is proposed. The relationship is shown in (2), being the slope of each section for a task in the piecewise linear relationship and the number of employees fulfilled of that task in each section, where section has a length (). This piecewise linear relationship can be adjusted to the convex relationship (with ) as shown in the blue line of Figure 1. This relationship is over the convex relationship representing a safer configuration of processing times and amount of resources:
The superscript for processing times, , and for the amount of resources, , denotes that they correspond to point .
According to Lanigan , the convex relationships between the processing time of a task and the number of employees assigned do not entirely match the reality, and there shall be a penalty due to assigning different numbers of employees. On the one hand, if , then a penalty for communication exists. In contrast (see, e.g., [41, 42]), if then there is a penalty for lack of specialization . Hence, each feasible point different than the optimum must be placed over the convex curve; otherwise many optima would exist and there would be no penalties for under- and overcoverage. The feasible area formed by these points is represented by the light red area in Figure 2(a) (this feasible area is also taken into account by [44, 45]). Moreover, it shall be considered that the processing time of a task decreases when the number of employees increases; otherwise it would make no sense to assign more employees to the tasks. Thus, the feasible area can be reduced by considering that the processing time of a task cannot increase when the number of employees increases (Figure 2(b)). In this way, the feasible relationships between both aspects must be in this area. Therefore, we propose using a piecewise linear relationship with a maximum and minimum possible number of workers on each task. Depending on the maximum and minimum possible number of workers, the slopes of the lines must be different to avoid that both lines are under the convex curve (i.e., in the infeasible region) in any point. The directions of the slope of the piecewise relationships are placed in the feasible region and shown in Figure 2(c). By doing so, linear programming can be used to model and solve the problem. Furthermore, the piecewise relationship is on the safe side with respect to the convex relation, since the piecewise relationship is always over the convex relation.
To define the slopes of the lines, we propose introducing the parameters and . The higher these parameters are, the bigger the penalties for under- and overassignment of employees with respect to the optimal value, and consequently the closer the problem to the PSSA with fixed processing times (FPT). In the most extreme case, both problems are the same. The piecewise linear relation left and right of the optimum can be written as follows (see Figure 2(d)):
Analogously, let us now consider as the undercoverage of task and as the overcoverage of task , :
3.3. Formulation of the Model
3.3.1. Proposed Integer Linear Programming Model
In the previous section, we have presented a mechanism for formulating a realistic relationship between the processing times of the task and the number of employees assigned. Furthermore, this relationship can be embedded into a piecewise linear function; therefore a linear programming model can be formulated for the PSSA. In this section, a formal description of this model is given.
Data earliest starting time (release time) of task . optimal number of employees of task . processing time of task for the optimal number employees . maximum allowed undercoverage for task . maximum allowed overcoverage for task . constants related to the slopes of the lines defining the processing times.
Variables undercoverage in task . overcoverage in task . processing time of task .
Auxiliary Variables starting time of task . completion time of task . project makespan. auxiliary variable. It is used to enforce that the constraint set (18) is satisfied if is zero since the auxiliary variable takes the value of the over- or undercoverage.
Objective function (5) minimizes the project makespan. Constraint set (6) guarantees that each task must start exactly once. Constraint sets (7) and (8) define the starting and completion times of each task, respectively. Constraint set (9) assures that a task cannot start before its release time. Constraint set (10) serves to obtain the makespan. Constraint set (11) ensures with that an employee cannot perform a task if he/she does not possess the skills required. Moreover, the variable is added to the constraint to preclude work at a time when the task is not being processed. Constraint set (12) establishes the precedence relationships. Constraint set (13) defines over- and undercoverage for each task at each period. The auxiliary constraint sets (14) and (15) ensure that constraint set (13) is satisfied for every period. Constraint sets (16) and (17) limit the maximum possible under- and overcoverage, respectively. Constraint set (18) enforces that an employee can work at most in one task at each period. Constraint sets (19) and (20) are used to determine the CPT. Constraint set (21) forces to be 1 if and only if task is active. Constraint set (22) ensures that task must be performed () whenever it starts . Constraint sets (23) and (24) model the nonpreemptive assumption: (23) determines that a task cannot be performed () after its completion time, and (24) states that it cannot be performed () before its starting time. Equations (25), (26), (27), and (28) define the variables employed in the model.
3.3.2. Extension 1: Limitation of Moves
The model presented above allows moving the staff from a task to another. These moves can be detrimental for the service company since they may involve setup and learning times as well as instability in the team composition that performs each task. This limitation of moves can be easily incorporated in the model adding the following two constraints: where yields 1 if the employee is assigned to the task , 0 otherwise. Constraints (29) and (30) force that an employee have to be assigned to the task during the whole duration of the task when is equal to 1.
3.3.3. Extension 2: Generic Piecewise Linear Relationship
In Section 3.2 a piecewise linear relationship with two sections was presented to model the relationship between the processing time of a task and the amount of resources assigned to such task. In order to include a generic piecewise linear relationship with k sections, the constraints (31)–(38) must replace the constraints (19)-(20): where is an auxiliary variable yielding 1 only in the section , where is over 0 and lower than (represented by the constraints (33)-(34), (36)). Generic piecewise linear relationship is defined in constraint (31). is introduced to define with 1 the sections with , 0 otherwise (constraint (35)). Finally, constraint (32) delimits the upper value of the variable and the constraints (37)-(38) establish = 1 in each section preceding the section, where , otherwise. Thereby, any piecewise linear relationship could be considered in the model by means of these constraints. To adjust this relationship to the convex relationship with , it is necessary only define the parameter replacing the term by in (2) (see the slope in (39) assuming that the length for each section ):
3.4. Additional Models
3.4.1. Model with Fixed Processing Times (FPT)
In this section, the PSSA problem without CPT is analyzed. The goal is to compare the PSSA model with CPT (PSSA-CPT in the following) with the model with FPT (PSSA-FPT model). To the best of our knowledge, it is the first time that the PSSA problem is solved with processing times depending on the number of employees allocated, so it is relevant to assess the benefits of the assumption. Both models are similar, but there are two main changes. First, in the PSSA-FPT model, processing times do not depend on the number of employees assigned (i.e., this number is fixed and equal to the optimum). Second, over- and undercoverage are not allowed in this model; that is, -, -, and -related constraints are not taken into account. The constraint sets (13)–(17), (19)-(20) are then replaced by
Thus, the PSSA-FPT model consists of the constraint sets (6)–(12), (18), and (21)–(28), where the above variable is now a data of the problem. Obviously, the PSSA-CPT problem is harder than the PSSA-FPT since it has more variables and constraints. It will be analyzed again in the computational results.
3.4.2. Formulation of the Model Using Discrete Time/Resource Trade-Off Problem (DTRTP) Approach with Staff Assignment
The model presented in this paper could be also modeled using a DTRTP approach adding the staff assignment and the release times constraints. However, the results found by this approach were considerably worse in computational time and in average relative percentage deviation. When both models were compared for each instance presented in Section 5.1 (several instances are shown in Table 3), only 363 optimal solutions were found using the DTRTP approach compared to the 567 of the proposed model and the computational time by the DTRTP approach presented a deviation of 287.1% over our proposed model (the deviation runtime is calculated considering only the instances which were optimal solutions found for both models; the amount of these instances is presented in the column of Table 3 denoted by “Both optimum”) as well, justifying the PSSA-CPT model proposed here.
3.5. Complexity of the Problem
The PSSA can be reduced to the identical parallel machine problem with two machines (, , according to Graham et al. ), when , , and are considered. As this problem is NP-hard  and our problem is a generalization of it, the PSSA is NP-hard.
On the other hand, the constraint sets (6)–(23) approximately form a total of constraints. Regarding the variables, there are in the model, where are binary (i.e., , , and ). The number of constraints and variables is calculated in Table 4 for some instances of the test beds presented in Section 5.1. Since the PSSA with CPT is an NP-hard problem and since the number of constraints and variables for medium-large size of the problem is very high, exact solvers for integer programming problems have difficulties to find feasible and optimal solutions in such instances and therefore approximate algorithms have to be implemented. In the next section, a simple GRASP algorithm is presented to get feasible solutions in lower computational times.
4. A Simple GRASP Heuristic Algorithm
Given the complexity of the problem, a greedy randomized adaptive search procedure (GRASP) is presented in this section to solve the PSSA problem with CPT. GRASP was first introduced by Feo and Resende  and it has been widely applied to several combinatorial optimization problems. A review of the application fields of this algorithm is done in Festa and Resende . The algorithm consists of two phases: first a constructive phase is implemented, and then a local search phase is made to find better solutions in the neighborhood. The constructive phase is usually employed to find a feasible solution for the problem, while the local search phase is performed to improve the solution found in the constructive phase. Both phases are repeated until the stopping criterion is reached (see Procedure 1).
In our problem, fixed processing times are considered during the constructive phase. In the local search phase, the task schedule is fixed and more employees are gradually assigned to each task in order to decrease the processing times and thus possibly improving the makespan of the project. In summary, a project scheduling problem is solved in the constructive phase, a CPT problem in the local search phase, while the staff assignment problem is treated in both phases (see Figure 3). In the next subsections the phases are explained in detail.
4.1. Constructive Phase
The constructive phase consists in the successive allocation of employees and starting times to tasks. The goal is to assign the tasks as early as possible until all tasks are scheduled. In this phase, both the processing times and the number of assigned employees are kept fixed. The number of employees allocated to each task is randomly assigned within the upper and lower limits. The processing times of each task are calculated for the so-obtained number of employees using the expressions shown in Section 3. With respect to the task to be chosen at each step, a restricted candidate list (RCL) is defined based on the tasks’ precedence relations. According to these relations, the tasks are classified into sets: set corresponds to tasks without predecessors, set is tasks which only have predecessors of set , and, in general, set contains tasks with predecessors in sets . The tasks are iteratively inserted in the schedule according to the following procedure. First, the RCL contains all tasks in set . A task is randomly chosen from the RCL to be placed in the schedule. The process is repeated until the RCL is empty. Then, the tasks of set are moved to. The same procedure is carried out until each task is introduced in the schedule.
Once a task is chosen from the RCL, it has to be placed into the schedule. To do this, the earliest possible start time for the task is calculated. Next, the starting time of the task is fixed to this earliest time and employees (from those having the required skills for the task) are assigned until the number of employees, , is reached. Employees are assigned one by one at random. At each step, the feasibility of the problem is checked. If, at some point, the resulting schedule is not feasible, the starting time of the task is postponed until feasibility is achieved. This process is repeated until the task is definitely inserted in a time period (see function buildSolution() in Procedure 3). It is important to note that the processing times are fixed at this phase. The steps of the constructive phase are shown in Procedure 2.
4.2. Local Search Phase
After obtaining a schedule of tasks and a staff assignment in the constructive phase, the local search phase aims to improve the solution by reducing the processing times of each task. To do so, tasks are first ordered again at random and then, step by step, the number of employees allocated to each task (following this order) is increased. In each step, the processing time of the task is updated and the makespan is analyzed (using the buildSolution() function, Procedure 3). If the makespan decreases, then the new solution is kept and the new amount of assigned employees is updated. Next, another employee is assigned to the same task and the objective function is analyzed. This process is repeated until the maximum overcoverage allowed for the task is reached. Then, we continue with the following task in the same way. The local search phase finishes when all tasks have been analyzed. The output of this phase is the best solution found. The pseudocode of this phase is shown in Procedure 4.
5. Computational Results
In this section, the problem under consideration is solved using the PSSA-CPT model introduced in Section 3 and the GRASP algorithm presented in Section 4. The PSSA-CPT model is implemented using the software Gurobi Optimizer 4.51 and ILOG CPLEX 12.4 and the GRASP heuristic is coded in C#. The computational experiments were tested on an Intel Core i7-930, 2.8 GHz, 16 GB RAM under Windows 7.
This section is divided into two parts. An explanation of the test bed is presented in Section 5.1 and, next, in Section 5.2, a comparison of the computational results discussed is made, along the following aspects:(i)comparison between CPLEX and Gurobi solvers;(ii)comparison between GRASP algorithm results and exact results;(iii)impact of CPT on reducing the makespan of the project.
5.1. Test Bed
The integer programming problem presented in this paper was solved by the software Gurobi Optimizer 4.5 for instances based on the sets j30 and j60 of the PSPLIB classical instances , which are a reference test beds for project scheduling. Each combination of parameters is replicated ten times and the mean value is taken to represent it. In order to adapt the test beds to our problem, additional parameters have to be defined: maximum possible over- and undercoverage ( and ) were drawn from uniform distributions and , respectively; release times were chosen following uniform distributions and the number of employees was the average of the capacities of the 4 employees in the PSPLIB. The test bed used in this paper is similar to the test bed of Drezet and Billaut , where an employee was assigned a 70% probability to master a skill. In our paper, it is assigned an 85% probability to avoid infeasibility in the test beds. The parameters and are set to 2.5 according to the slope of the piecewise relationships explained in Section 3.2. In total, 960 instances were generated where 10 replicates were obtained for each combination of the parameters in Table 5 (see  for a detailed description of the parameters NC, RF, and RS).
5.2. Comparison and Analysis of Computational Results
The integer linear programming model was solved in this paper using the Gurobi software and ILOG CPLEX. Firstly, time limit was set to 30 min using Gurobi. The average results out of the 10 replicates for each parameter combination are shown in the 7th and 8th columns of Tables 6 and 7 (for the j30 and j60 instances, resp.). Dashed lines are used in some combination to specify that no solution was found for any replicate. The 9th, 10th, and 11th columns indicate the number of optimal, feasible, and nonfound solutions, respectively, for each combination of parameters found by Gurobi. It can be seen that optimal solutions were achieved for 567 instances from the total of 960 instances, feasible solutions were found for 16 cases, and no solutions before 30 minutes were therefore obtained for 377. The latter represents a huge amount of instances without solution and thus different method of resolution has to be implemented. More specifically, exact solutions were achieved for 325 instances considering 30 tasks in the project, and only in 242 instances with 60 tasks. Using the same time limit than CPLEX, makespan and runtime are shown in the second and third columns. Optimal solutions were found only for 216 from the total of 960 instances (only 13 in the set j60) and feasible solutions for 352 instances and, hence, no solutions were found in 608 instances. This represents worse results as compared to that of Gurobi. With respect to the value of the makespan for the instances where feasible solutions were found, the ARPD (average relative percentage deviation) for CPLEX in these 352 instances was 58.4%, calculated using the expression (41), in contrast to the ARPD of 3.4% found by Gurobi in the 583 feasible solutions:
Finally, the GRASP heuristic was compared with the exact solutions. The time limit of the GRASP heuristic was set to seconds; that is, it increases with the difficulty of the problem. Results are shown in Tables 6 and 7. Each row corresponds to a given combination of parameters and the first column indicates the chosen parameters in the format (j-NC-RF-RS). The column “” represents the average makespan using the GRASP algorithm for 10 iterations and the column “” is corresponding computation time . The mean deviation between the solutions by Gurobi with time limit of 30 min and the solutions by GRASP with time limit of are shown in the column “” using the expression (41).
The ARPD of the GRASP algorithm for all problems was 0.38%. Comparing the results of the exact solutions found by Gurobi (567 instances), the deviation of the solutions obtained by the GRASP algorithm is 0.62%, and optimal solutions using GRASP were found in 457 of these 567 instances (80.7% of the instances). Furthermore, feasible solutions were found by GRASP in each instance while feasible solutions were found in 587 instances using Gurobi.
Even better results are obtained when the GRASP algorithm is compared with Gurobi with the same time limit; that is, the time limit is fixed for both GRASP heuristic and Gurobi. In this case, Gurobi found only optimal solutions in 201 of the total of 960 instances of the test bed while our heuristic found feasible solutions for all instances. Furthermore, the deviation of the heuristic from the optimal solutions was only 0.05% for these 201 instances and optimal solutions were found in 195 instances which represents a 97.01%.
In Section 3.4.1, the interest to compare the PSSA problem with CPT with the PSSA problem with FPT was discussed. The PSSA problem with FPT was solved by Gurobi setting also a time limit of 30 minutes. The makespan and runtime of this problem for each instance are shown in the 11th and 12th columns, respectively. Results of the PSSA-CPT and PSSA-FPT are compared in the 13th column. The objective function of PSSA-FPT represents an upper bound of the function objective of the PSSA-CPT (), since a solution of PSSA-FPT is always a feasible solution for PSSA-CPT. The difference between the makespan and the runtimes of both models is analyzed. Considering only the instances with optimal solution (567 instances), the makespan decreases by 13.4% using CPT. On the other hand, runtime increased by 160.03%, which may seem an excessive increase in runtimes. However, since the planning horizon is always over 75 days, it seems reasonable that such a long and important decision must be performed carefully, so the runtime increase must not be so significant in that case.
In this paper, a project scheduling and staff assignment problem has been integrated. As in many real-life cases, the processing times of the tasks depend on the number of employees assigned; CPT were analyzed. There exists a feasible region where the relation of processing times and number of employees can be placed, so a piecewise linear relationship was proposed and included in a linear programming model for the problem in order to better represent the reality considering the penalty for communication in bigger teams and the penalty for lack of specialization in small teams. The consideration of a piecewise linear relationship between the processing times and the amount of resources in the PSSA-CPT provided a large reduction in runtime compared to the adaptation of the DTRTP adding staff assigned.
Different instances of the problem were first solved using the solver Gurobi Optimizer 4.5 and ILOG CPLEX 12.4, the former being more computationally efficient. Furthermore, a comparison between the model with CPT and with FPT was performed to justify the introduction of such CPT. The results obtained highlight an important decrease of the makespan by considering variable processing times. However, due to the complexity of the problem, extremely high computational times were needed for medium-large size instances by Gurobi, justifying the implementation of an approximate algorithm (GRASP). Computational times were greatly decreased there maintaining good ARPDs.
Regarding the future research lines of this paper, different approximate algorithms may be implemented in order to decrease the computational times comparing the results to the GRASP algorithm presented here and with other approximate algorithms employed for similar problems. Finally, a future research line relates to the CPT. In this paper, a piecewise linear relationship between processing times and number of employees (renewable discrete resources) has been introduced in the model. However, different relationships between both variables may be analyzed, such as a convex relationship and hyperbola, in order to adapt the model presented in this paper to continuous renewable and nonrenewable resources.
Conflict of Interests
The authors declare that there is no conflict of interests regarding the publication of this paper.
- R. J. Tersine and E. A. Hummingbird, “Lead-time reduction: the search for competitive advantage,” International Journal of Operations and Production Management, vol. 15, no. 2, pp. 8–18, 1995.
- C. H. Glock, “Lead time reduction strategies in a single-vendorsingle-buyer integrated inventory model with lot size-dependent lead times and stochastic demand,” International Journal of Production Economics, vol. 136, no. 1, pp. 37–44, 2012.
- E. Nowicki and S. Zdrzałka, “A survey of results for sequencing problems with controllable processing times,” Discrete Applied Mathematics, vol. 26, no. 2-3, pp. 271–287, 1990.
- A. A. Fernandez, R. L. Armacost, and J. J. Pet-Edwards, “Understanding simulation solutions to resource constrained project scheduling problems with stochastic task durations,” Engineering Management Journal, vol. 10, no. 4, pp. 5–13, 1998.
- B. L. Maccarthy and J. Liu, “Addressing the gap in scheduling research: a review of optimization and heuristic methods in production scheduling,” International Journal of Production Research, vol. 31, no. 1, pp. 59–79, 1993.
- M. H. A. Hendriks, B. Voeten, and L. Kroep, “Human resource allocation in a multi-project R&D environment: resource capacity allocation and project portfolio planning in practice,” International Journal of Project Management, vol. 17, no. 3, pp. 181–188, 1999.
- A. Corominas, J. Ojeda, and R. Pastor, “Multi-objective allocation of multi-function workers with lower bounded capacity,” Journal of the Operational Research Society, vol. 56, no. 6, pp. 738–743, 2005.
- A. Corominas, R. Pastor, and E. Rodríguez, “Rotational allocation of tasks to multifunctional workers in a service industry,” International Journal of Production Economics, vol. 103, no. 1, pp. 3–9, 2006.
- S. P. Siferd and W. C. Benton, “Workforce staffing and scheduling: hospital nursing specific models,” European Journal of Operational Research, vol. 60, no. 3, pp. 233–246, 1992.
- W. J. Abernathy, N. Baloff, J. C. Hershey, and S. Wandel, “A three stage manpower planning and scheduling model—a service sector example,” Abstracts of Hospital Management Studies, vol. 9, no. 4, Article ID 09928, 30 pages, 1973.
- C. Tseng, C. Liao, and K. Huang, “Minimizing total tardiness on a single machine with controllable processing times,” Computers and Operations Research, vol. 36, no. 6, pp. 1852–1858, 2009.
- D. Shabtay and G. Steiner, “A survey of scheduling with controllable processing times,” Discrete Applied Mathematics, vol. 155, no. 13, pp. 1643–1666, 2007.
- E. L. Demeulemeester and W. Herroelen, Project Scheduling, Kluwer Academic Publishers, Boston, Mass, USA, 2002.
- O. Bellenguez and E. Néron, “Lower bounds for the multi-skill project scheduling problem with hierarchical levels of skills,” in Practice and Theory of Automated Timetabling V, vol. 3616 of Lecture Notes in Computer Science (Including Subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics), pp. 229–243, Springer, 2005.
- O. Bellenguez-Morineau and E. Néron, “A branch-and-bound method for solving multi-skill project scheduling problem,” RAIRO—Operations Research, vol. 41, no. 2, pp. 155–170, 2007.
- P. Brucker and S. Knust, Complex Scheduling, GOR-Publications, 2012.
- L.-E. Drezet and J.-C. Billaut, “A project scheduling problem with labour constraints and time-dependent activities requirements,” International Journal of Production Economics, vol. 112, no. 1, pp. 217–225, 2008.
- G. L. Vairaktarakis, “The value of resource flexibility in the resource-constrained job assignment problem,” Management Science, vol. 49, no. 6, pp. 718–732, 2003.
- V. Valls, Á. Pérez, and S. Quintanilla, “Skilled workforce scheduling in Service Centres,” European Journal of Operational Research, vol. 193, no. 3, pp. 791–804, 2009.
- A. Corominas, J. Olivella, and R. Pastor, “A model for the assignment of a set of tasks when work performance depends on experience of all tasks involved,” International Journal of Production Economics, vol. 126, no. 2, pp. 335–340, 2010.
- A. Drexl, “Scheduling of project networks by job assignment,” Management Science, vol. 37, no. 12, pp. 1590–1602, 1991.
- B. Dodin and A. A. Elimam, “Audit scheduling with overlapping activities and sequence-dependent setup costs,” European Journal of Operational Research, vol. 97, no. 1, pp. 22–33, 1997.
- C. Heimerl and R. Kolisch, “Scheduling and staffing multiple projects with a multi-skilled workforce,” OR Spectrum, vol. 32, no. 2, pp. 343–368, 2010.
- R. Kolisch and C. Heimerl, “An efficient metaheuristic for integrated scheduling and staffing IT projects based on a generalized minimum cost flow network,” Naval Research Logistics, vol. 59, no. 2, pp. 111–127, 2012.
- W. J. Gutjahr, S. Katzensteiner, P. Reiter, C. Stummer, and M. Denk, “Competence-driven project portfolio selection, scheduling and staff assignment,” Central European Journal of Operations Research, vol. 16, no. 3, pp. 281–306, 2008.
- W. J. Gutjahr, S. Katzensteiner, P. Reiter, C. Stummer, and M. Denk, “Multi-objective decision analysis for competence-oriented project portfolio selection,” European Journal of Operational Research, vol. 205, no. 3, pp. 670–679, 2010.
- M. Wu and S. Sun, “A project scheduling and staff assignment model considering learning effect,” International Journal of Advanced Manufacturing Technology, vol. 28, no. 11-12, pp. 1190–1195, 2006.
- H. K. Alfares and J. E. Bailey, “Integrated project task and manpower scheduling,” IIE Transactions (Institute of Industrial Engineers), vol. 29, no. 9, pp. 711–717, 1997.
- M. Bassett, “Assigning projects to optimize the utilization of employees' time and expertise,” Computers and Chemical Engineering, vol. 24, no. 2–7, pp. 1013–1021, 2000.
- R. M. Hachicha, E. M. Dafaoui, and A. El Mhamedi, “Assignment problem formulation under competence and preference constraints,” in Proceedings of the IEEE International Conference on Industrial Engineering and Engineering Management (IEEM '10), pp. 1864–1868, December 2010.
- C. Heimerl and R. Kolisch, “Work assignment to and qualification of multi-skilled human resources under knowledge depreciation and company skill level targets,” International Journal of Production Research, vol. 48, no. 13, pp. 3759–3781, 2010.
- J. Węglarz, J. Józefowska, M. Mika, and G. Waligóra, “Project scheduling with finite or infinite number of activity processing modes—a survey,” European Journal of Operational Research, vol. 208, no. 3, pp. 177–205, 2011.
- S. Hartmann and D. Briskorn, “A survey of variants and extensions of the resource-constrained project scheduling problem,” European Journal of Operational Research, vol. 207, no. 1, pp. 1–14, 2010.
- D. W. Pentico, “Assignment problems: a golden anniversary survey,” European Journal of Operational Research, vol. 176, no. 2, pp. 774–793, 2007.
- J. N. D. Gupta, K. Krüger, V. Lauff, F. Werner, and Y. N. Sotskov, “Heuristics for hybrid flow shops with controllable processing times and assignable due dates,” Computers and Operations Research, vol. 29, no. 10, pp. 1417–1439, 2002.
- R. M. Belbin, Management Teams, Butterworth-Heinemann, Oxford, UK, 3rd edition, 2010.
- D. Shabtay and M. Kaspi, “Minimizing the total weighted flow time in a single machine with controllable processing times,” Computers and Operations Research, vol. 31, no. 13, pp. 2279–2289, 2004.
- C. L. Monma, A. Schrijver, M. J. Todd, and V. K. Wei, “Convex resource allocation problems on directed acyclic graphs: duality, complexity,” Special Cases, and Extensions, Mathematics of Operations Research, vol. 15, pp. 736–748, 1990.
- C. Lee and L. Lei, “Multiple-project scheduling with controllable project duration and hard resource constraint: some solvable cases,” Annals of Operations Research, vol. 102, no. 1–4, pp. 287–307, 2001.
- M. J. Lanigan, “Task estimating: completion time versus team size,” Engineering Management Journal, vol. 4, no. 5, pp. 212–218, 1994.
- P. C. Pendharkar and J. A. Rodger, “An empirical study of the impact of team size on software development effort,” Information Technology and Management, vol. 8, no. 4, pp. 253–262, 2007.
- K. G. Smith, K. A. Smith, J. D. Olian, H. P. Sims Jr, D. P. O'Bannon, and J. A. Scully, “Top management team demography and process: the role of social integration and communication,” Administrative Science Quarterly, vol. 39, pp. 412–438, 1994.
- M. A. Cusumano and R. W. Selby, Microsoft Secrets, The Free Press, New York, NY, USA, 1995.
- E. Demeulemeester, B. de Reyck, and W. Herroelen, “The discrete time/resource trade-off problem in project networks: a branch-and-bound approach,” IIE Transactions (Institute of Industrial Engineers), vol. 32, no. 11, pp. 1059–1069, 2000.
- M. R. Ranjbar and F. Kianfar, “Solving the discrete time/resource trade-off problem in project scheduling with genetic algorithms,” Applied Mathematics and Computation, vol. 191, no. 2, pp. 451–456, 2007.
- R. L. Graham, E. L. Lawler, J. K. Lenstra, and A. H. G. R. Kan, “Optimization and approximation in deterministic sequencing and scheduling: a survey,” Annals of Discrete Mathematics, vol. 5, pp. 287–326, 1979.
- J. K. Lenstra and A. H. G. R. Kan, “Complexity of scheduling under precedence constraints,” Operations Research, vol. 26, no. 1, pp. 22–35, 1978.
- T. A. Feo and M. G. C. Resende, “A probabilistic heuristic for a computationally difficult set covering problem,” Operations Research Letters, vol. 8, no. 2, pp. 67–71, 1989.
- P. Festa and M. G. C. Resende, GRASP: An Annotated Bibliography, pp. 325–367, Kluwer Academic Publishers, Boston, Mass, USA, 2001.
- R. Kolisch and A. Sprecher, “PSPLIB—a project scheduling problem library,” European Journal of Operational Research, vol. 96, no. 1, pp. 205–216, 1997.
- R. Kolisch, A. Sprecher, and A. Drexl, “Characterization and generation of a general class of resource-constrained project scheduling problems,” in Characterization and Generation of a General Class of Resource-Constrained Project Scheduling Problems: Easy and Hard Instances, Institute for Operations Research and the Management Sciences, 1992.
Copyright © 2014 Victor Fernandez-Viagas and Jose M. Framinan. This is an open access article distributed under the Creative Commons Attribution License, which permits unrestricted use, distribution, and reproduction in any medium, provided the original work is properly cited.