Project management is an important body of knowledge and practices that comprises the planning, organisation and control of resources to achieve one or more pre-determined objectives. In this paper, we introduce ProjectManagement, a new R package that provides the necessary tools to manage projects in a broad sense, and illustrate its use by examples.
Project management is an important body of knowledge and practices that comprises the planning, organisation and control of resources to achieve one or more pre-determined objectives. The most commonly used methods for project planning are PERT (Program Evaluation and Review Technique model) and CPM (Critical Path Method). PERT/CPM analyses the tasks involved in completing a project, especially the time needed to complete each task, and computes the minimum time needed to complete the total project. Through the data obtained in the analysis of the project, PERT/CPM identifies the critical activities, which are those for which any disturbance in its duration modifies the minimum time of execution of the project. Also, it obtains the times that can be assigned to non-critical activities, called slacks, in addition to their fixed durations, to give them flexibility. Project management often deals with the problem of redistribution of resources. Sometimes it is convenient to reduce the time of an activity by increasing the assigned costs. Other times, when the availability of resources is limited in a period of time, it may be necessary to level the use of those resources. These situations require a re-planning of the project.
Even with good project management, once the project has been carried out and the actual durations of the activities are known, there can be a delay in the completion time of the project. When the delay generates an additional cost, ways are needed to distribute the cost of the delay among the different tasks involved. To solve this problem we can use cooperative game theory and rules based on bankruptcy problems.
The essential elements related to project management can be found in Castro et al. (2007) or in Hillier and Lieberman (2001). Project management techniques have been widely used in all fields of engineering. Hall (2012) reviews the impact that such techniques have in various fields and their broad business opportunities. Their fields of application vary from classical construction and engineering to information technology and software development, including modern agile methods. Schmitz et al. (2019) also argue the usefulness of traditional project management techniques in the context of agile methodology. Evdokimov et al. (2018) include a case study that shows the current relevance of project management techniques in software development. Özdamar and Ulusoy (1995) present a survey of the problem of resource constraints. To distribute the delay cost of the project among the activities, Brânzei et al. (2002) provide two rules using, respectively, a game theoretical and a bankruptcy-based approach, and Bergantiños et al. (2018) introduce and analyse a consistent rule based on the Shapley value.
A well-known project management software is Microsoft Project. This tool is designed to create and control a project, through the allocation of resources to tasks, the management of budget and workloads, as well as monitoring developments. Microsoft Project is not open source and its license is fee-based. Other project management applications have been created as free software, such as OpenProj, PpcProject or ProMes (Gregoriou et al. 2013). In Salas-Morera et al. (2013) we can see a useful comparison of these applications.
The aforementioned tools are written in Java or Phyton. To the best of our knowledge, there are only two packages in R available for project management. PlotPrjNetworks (Muñoz 2015) and plan (Kelley 2018) are packages that offer the user the creation of a Gantt diagram for the visualization of the project structure. In our opinion, a tool was missing to manage a project from its development to its control. We believe that such a tool would be useful for the user community because it could be integrated with other tools developed in R, it could be easily modified to suit the specific needs of each user, and it could be wrapped into a graphical interface.
In this paper, we introduce ProjectManagement1 (Gonçalves-Dosantos et al. 2020a), a new R package that provides the necessary tools to manage projects in a broad sense. It calculates the critical activities, the slack of each activity, the minimum duration of the project and the early and last times of each activity. It plots a graph of the project and the schedule. The package also allows cost management to reduce the minimum project time, as well as resource management. Once the actual durations of the activities are known, it is possible to distribute the delay generated in the project among the different activities. When activity durations are considered random variables, the package provides additional functionality. In particular, it calculates the average duration of the project and the criticality index of each activity. It plots a representation of the project duration distribution and the early and last times of the activities. And it calculates several allocation proposals of the delay cost when the project has been completed and the actual duration of the activities is known.
The paper is organized as follows. First, we recall the basic definitions of project management and present different ways to distribute the delay cost when durations are assumed to be known and when they are random variables. Then, we provide a description of ProjectManagement. Finally, we illustrate the use of the package by way of examples.
In this section we discuss the basic concepts of deterministic and stochastic projects with a special focus on allocating the delay cost among the project activities. The aim of this section is to provide a brief (and quick) survey of the methodologies implemented in the R package ProjectManagement that we introduce later, as well as to indicate the main bibliographical sources in which interested readers can deepen their knowledge of each of these methodologies.
Let \(X\) be a finite non-empty set and \(N\) be a set of ordered pairs \(\left(x_{1}, x_{2}\right)\), with \(x_{1}, x_{2}\in X\) and \(|N|=n\). A directed graph is a pair \(G=\left(X,N\right)\), where \(X\) is the set of nodes and \(N\) is the set of arcs. We say that an arc \(i = \left(x_{i,1}, x_{i,2}\right)\in N\) starts at node \(x_{i,1}\in X\) and ends at \(x_{i,2}\in X\). A node \(x_s\in X\) is a source node if there is no arc \(i\in N\) such that \(x_{i,2}=x_s\). A node \(x_e\in X\) is a sink node if there is no arc \(i\in N\) such that \(x_{i,1}=x_e\). A cycle is a set of arcs \(i_0,i_1,...,i_m\in N\) such that \(x_{i_j,2} = x_{i_{j+1},1}\), with \(j\in\{0,...,m-1\}\), and \(x_{i_{m},2} = x_{i_{0},1}\). To illustrate the concept of directed graph consider the following example. Take graph \(G=\left(X,N\right)\) given by \(X=\{a,b,c,d\}\) and \(N=\{1=\left(a,b\right),2=\left(a,c\right),3=\left(b,d\right),4=\left(c,d\right)\}\). The diagram representing this graph is depicted in Figure 1. This graph has one source \(\left(a\right)\) and one sink \(\left(d\right)\). Arc \(3\), for instance, starts at node \(b\) and ends at node \(d\). This graph has no cycles. However, if we add an arc \(5=\left(d,a\right)\), the resulting graph has two cycles: \(1,3,5\) and \(2,4,5\).
A deterministic project \(P\) is a tuple \(P=\left(G,x^0\right)\), where \(G=\left(X,N\right)\) is a directed graph without cycles, with one source node and one sink node, and \(x^0\in \mathbb{R}_{+}^{n}\) is the vector of non-negative planned durations. In this context, \(N\) represents the set of activities in the project. We denote by \({\cal P}^N\) the family of all deterministic projects with set of activities \(N\), and by \({\cal P}\) the family of all deterministic projects.
In a deterministic project \(P=\left(G,x^0\right)\in {\cal P}^N\), you can calculate the minimum duration of \(P\), denoted by \(D\left(G,x^0\right)\), i.e. the minimum time the project needs to complete all activities taking into account the structure of the graph. This time can be obtained as the solution of a linear programming problem, and thus, can be easily computed. Alternatively, \(D\left(G,x^0\right)\) can be calculated using a project planning methodology like PERT (see, for instance, Hillier and Lieberman (2001) for details on project planning).
Given a node \(x\in X\), we define the set of immediate predecessors of \(x\) as the set of activities ending in \(x\), \(Pred\left(x\right)=\{i\in N/x_{i,2}= x\}\), and the immediate successors of \(x\) as \(Suc\left(x\right)=\{i\in N/x=x_{i,1}\}\). We define the earliest time \(D^{E}_i\left(G,x^0\right)\) of an activity \(i\in N\) as the minimum time required to complete all immediate predecessor activities of \(x_{i,1}\), i.e. the earliest start time the activity \(i\) can start taking into account the graph \[D^{E}_i\left(G,x^0\right)=\max_{j\in Pred\left(x_{i,1}\right)}\{D^{E}_j\left(G,x^0\right)+x^{0}_j\}.\] The latest completion time \(D^{L}_i\left(G,x^0\right)\) of an activity \(i\in N\) is the latest point in time when the activity can end without delaying the project \[D^{L}_i\left(G,x^0\right)= \left\{ \begin{array}{lcc} \max_{j\in N; Suc\left(x_{j,2}\right)=\emptyset}\{D^{E}_j\left(G,x^0\right)+x^{0}_j\} & if &Suc\left(x_{i,2}\right)=\emptyset, \\ \\\min_{j\in Suc\left(x_{i,2}\right)}\{D^{L}_j\left(G,x^0\right)-x^{0}_j\} & & otherwise. \\ \end{array} \right.\]
It is easy to see that \(D^{E}_i\left(G,x^0\right)\leq D^{L}_i\left(G,x^0\right)\) for all \(i\in N\). Also, we can calculate the minimum duration of a project, using the earliest start times, as \(D\left(G,x^0\right)=\max_{i\in N}\{D^{E}_i\left(G,x^0\right)+x^{0}_i\}\).
We define the slack \(S_i\left(G,x^0\right)\) of an activity \(i\in N\) as the maximum time, in addition to \(x^{0}_i\), that \(i\) can use to complete its task without delaying the project \[S_i\left(G,x^0\right)=D^{L}_i\left(G,x^0\right)-D^{E}_i\left(G,x^0\right)-x^{0}_i.\]
If the slack for an activity is equal to \(0\), then this activity is critical, i.e. any perturbation in its time modifies the duration of the project. We can also define two other types of slack. The free slack of an activity is the maximum amount of time that this activity can be delayed without causing a delay in the project or in the earliest time of the other activities. The free slack of an activity can be calculated as \[FS_i\left(G,x^0\right)=\min_{j\in Suc\left(x_{i,2}\right)}\{D^E_j\left(G,x^0\right)\}-D^E_i\left(G,x^0\right)-x^0_i.\]
The independent slack of an activity is the maximum time that the activity duration can be increased without affecting the times of others activities \[IS_i\left(G,x^0\right)=\max\{\min_{j\in Suc\left(x_{i,2}\right)}\{D^E_j\left(G,x^0\right)\}-D^L_i\left(G,x^0\right)-x^0_i,0\}.\]
Given the slack of an activity, we define the latest start time as the latest time that an activity can start without delaying the project \[D^{EL}_i\left(G,x^0\right)=D^{E}_i\left(G,x^0\right)+S_i\left(G,x^0\right)\] and the earliest completion time as the earliest time in which an activity can end if it starts in its earliest start time \[D^{LE}_i\left(G,x^0\right)=D^{L}_i\left(G,x^0\right)-S_i\left(G,x^0\right).\]
Besides the schedule of a project, we can manage the resources allocated to the activities. The minimal cost expediting or MCE method (Kelley 1961) considers that the duration of some activities can be reduced by increasing the resources allocated to them and thus the implementation costs. An MCE problem is a tuple \(\left(P,\bar{x}^0,c,D\right)\), where \(P\) is a deterministic project, \(\bar{x}^0\in\mathbb{R}_{+}^n\) is the vector of minimum durations, that is, for each activity \(i\in N\), \(\bar{x}^0_i\) is the minimum duration that the activity can take if the resources allocated to carry it out are increased, \(c\in\mathbb{R}^n\) is the vector of unit costs, that is, for each activity \(i\in N\), \(c_i\) is the cost of accelerating a unit of time the duration of \(i\), and \(D\) is the minimum duration of the project we are trying to achieve, with \(D<D\left(G,x^0\right)\). This problem can be solved as a linear programming problem.
Two other interesting problems that arise from the management of resources are the levelling and the allocation (Hegazy 1999). These problems take into account that in order for activities to be carried out in the estimated time, a certain level of resources must be used. The problem of levelling of resources is to find a schedule that allows to execute the project in its minimum duration time \(D\left(G,x^{0}\right)\) whilst the use of resources is as uniform as possible over time. In the problem of allocation of resources, the level of resources available in each period of time is limited. The aim is to find the minimum duration time and a schedule for the execution of the project taking into account this resource constraint. Given the complex nature of these problems, their exact resolution is computationally demanding. The most common practice is to use heuristic methods to solve them.
Once the project is completed, we can know the actual (observed) duration of the activities and, therefore, whether there has been a delay in the project, that is, whether the actual duration of the project has been different than expected. We define a deterministic project with delays as a tuple \(CP=\left(G,x^0,x,C\right)\), where \(\left(G,x^0\right)\) is a deterministic project, \(x\in \mathbb{R}_{+}^{n}\) is the vector of actual duration of the activities, and \(C:\mathbb{R}_{+}\rightarrow\mathbb{R}\) is the delay cost function. We assume that \(C\) only depends on the duration of the project, it is a non-decreasing function, and \(C\left(D\left(G,x^0\right)\right)=0\). In practice, the most commonly used functions, for a vector \(y\in \mathbb{R}_{+}^{n}\), are \[C\left(D\left(G,y\right)\right)=D\left(G,y\right)-\delta \label{cf} \tag{1}\] with \(\delta\in \mathbb{R}_{+}\), for example \(\delta=D\left(G,x^0\right)\).
We denote by \({\cal CP}^N\) the family of all deterministic projects with delays with set of activities \(N\), and by \({\cal CP}\) the family of all deterministic projects with delays.
In a deterministic project with delays \(CP\in {\cal CP}^N\), we may need to allocate \(C\left(D\left(G,x\right)\right)\) among the activities. This can be useful for several reasons. For example, it can serve as an incentive for those responsible for the activities that have been delayed to be more diligent in similar projects that we may carry out with them in the future; or it can be a mechanism to distribute among those responsible for the activities that have been delayed the financial penalty that the project manager has contractually guaranteed. Brânzei et al. (2002) propose two rules based on bankruptcy problems to address this problem: the Proportional rule and the Truncated Proportional rule. Although they define these rules for the case \(x_i\geq x_i^0\), we do not consider this restriction. These rules are only defined when the sum of the individual delays is not zero.
The Proportional rule for deterministic scheduling problems with delays \(\phi\) is defined, for each \(i\in N\), by \[\phi_i=\frac{x_i-x^{0}_i}{\sum_{j\in N}x_j-x^{0}_j}\cdot C\left(D\left(G,x\right)\right).\]
The Truncated Proportional rule for deterministic scheduling problems with delays \(\bar{\phi}\) is defined, for each \(i\in N\), by \[\bar{\phi}_i=\frac{\min\{x_i-x^{0}_i,C\left(D\left(G,x\right)\right)\}}{\sum_{j\in N}\min\{x_j-x^{0}_j,C\left(D\left(G,x\right)\right)\}}\cdot C\left(D\left(G,x\right)\right).\]
In Bergantiños et al. (2018), the problem of allocating the delay costs is addressed in the context of cooperative game theory using a Shapley rule. As we illustrate later in an example, the Shapley rule allocates the delay costs in a more sensible way than the proportional rules, at least in some cases. It is much more costly to compute it but, in general, the extra effort is worthwhile. A TU-game is a pair \(\left(N,v\right)\) where \(N\) is a finite non-empty set, and \(v\) is a map from \(2^N\) to \(\mathbb{R}\) with \(v\left(\emptyset\right)=0\). We say that \(N\) is the player (activity) set of the game and \(v\) is the characteristic function of the game, and we usually identify \(\left(N,v\right)\) with its characteristic function \(v\). The Shapley value, an allocation rule in cooperative game theory, is a map \(\varPhi\) that associates to each TU-game \(\left(N,v\right)\) a vector \(\varPhi \left(v\right)\in \mathbb{R}^N\) satisfying \(\sum_{i\in N}\varPhi_i \left(v\right)=v\left(N\right)\) and providing a fair allocation of \(v\left(N\right)\) among the players in \(N\). The explicit formula of the Shapley value for every TU-game \(\left(N,v\right)\) and every \(i\in N\) is given by \[\varPhi_i \left(v\right)=\sum _{S\subseteq N\setminus \{i\}}{\frac {\left(|N|-|S|-1\right)!\;|S|!}{|N|!}}\left(v\left(S\cup \{i\}\right)-v\left(S\right)\right).\]
Since its introduction by Shapley (1953), the Shapley value has proved to be one of the most important rules in cooperative game theory and to have applications in many practical problems (see, for instance, Moretti and Patrone (2008)).
Bergantiños et al. (2018) define the Shapley rule for deterministic projects with delays \(Sh\) as \(Sh\left(CP\right)=\varPhi\left(v^{CP}\right)\), where for all \(CP=\left(G,x^0,x,C\right)\in {\cal CP}^N\):
The calculation of the Shapley value has, in general, an exponential complexity. In this context, its exact calculation is impossible in practice, even for a moderate number of activities. As an alternative to exact calculation, Castro et al. (2009) proposed an estimate of the Shapley value in polynomial time using a sampling process. In practical terms, this estimate is a reasonable solution.
Next, we introduce a generalization of the model and the rules described above. It follows the results in Gonçalves-Dosantos et al. (2020b). If instead of \(x^0_i\), the planned duration of activity \(i\in N\) , we consider the non-negative random variable \(X^0_i\) describing the duration of \(i\), we can define a stochastic project \(SP\) as tuple \(SP=\left(G,X^0\right)\). Unlike in the deterministic setting, the duration of activities, the duration of the project, as well as the early and last times are now random variables instead of fixed numbers.
A stochastic project with delays is a tuple \(SCP=\left(G,X^0,x,C\right)\), where \(\left(G,X^0\right)\) is a stochastic project, \(x\) is the vector of actual durations, and \(C:\mathbb{R}_{+}\rightarrow \mathbb{R}\) is the delay cost function. We assume that \(C\) is non-decreasing and \(C\left(D\left(G,0\right)\right)=0\), where \(0\in R^n\) is the vector with all components equal to zero. Proportional rules can be extended to stochastic projects with delays in a straightforward way.
The Stochastic Proportional rule for deterministic scheduling problems with delays \(\phi\) is defined, for each \(i\in N\), by \[\phi_i=\frac{x_i-E\left(X^{0}_i\right)}{\sum_{j\in N}x_j-E\left(X^{0}_j\right)}\cdot C\left(D\left(G,x\right)\right).\]
The Stochastic Truncated Proportional rule for deterministic scheduling problems with delays \(\bar{\phi}\) is defined, for each \(i\in N\), by \[\bar{\phi}_i=\frac{\min\{x_i-E\left(X^{0}_i\right),C\left(D\left(G,x\right)\right)\}}{\sum_{j\in N}\min\{x_j-E\left(X^{0}_j\right),C\left(D\left(G,x\right)\right)\}}\cdot C\left(D\left(G,x\right)\right).\]
Also, we can extend the Shapley rule to the stochastic context. Let us see two extensions of the rule. The Shapley rule for stochastic projects with delays \(SSh\) is defined by \(SSh\left(SCP\right)=\varPhi\left(v^{SCP}\right)\), where
As an alternative to the previous rule, the Shapley rule in two steps for stochastic projects with delays \(SSh2\) is defined by \(SSh2\left(SCP\right)=\varPhi\left(v_1^{SCP}\right)+\varPhi\left(v_2^{SCP}\right)\), where
In general, the calculation of \(v^{SCP}\), \(v_1^{SCP}\) and \(v_2^{SCP}\) is very complex. In our package, we use simulations to approximate these characteristic functions.
ProjectManagement is a new R package that allows the user to address different tasks in project management. The user can obtain the duration of a project and a schedule of activities, and can plot this schedule for a better understanding of the problem. When the actual durations of each activity are observed, the package proposes several allocations of the delay cost, if there was any, among the activities. In the stochastic context, the package estimates the average duration of the project and plots the density functions of the following random variables: duration of the project, and early and last times of the activities. As in the deterministic case, it can make an allocation of the delay cost, if any.
The following dependencies of the package must be taken into account: triangle (Carnell 2019), plotly (Sievert 2020), igraph (Csardi and Nepusz 2006), kappalab (Grabisch et al. 2015), GameTheory (Cano-Berlanga 2017) and lpSolveAPI (lp_solve et al. 2020). The first one is used for calculations with triangular distributions, the second one to plot interactive graphics, the third one to plot graphs, the next two are related to game-theoretic concepts and the last one to solve linear programming problems.
The functions incorporated in the package can be seen in Table
1. Note that for projects of more than \(10\)
activities, functions delay.pert
and delay.stochastic.pert
will
approximate the Shapley value through a sampling process. Table
2 describes the complete list of parameters used by
the functions. Tables 3, 4, 5, and 6
state which arguments use each function.
Function | Description |
dag.plot |
Plots the AON graph of a project. |
delay.pert |
Calculates the delay cost of a deterministic project and allocates it among the activities. |
delay.stochastic.pert |
Calculates the delay cost of a stochastic project and allocates it among the activities. |
early.time |
Calculates the earliest start time for each activity. |
last.time |
Calculates the latest completion time for each activity. |
levelling.resources |
Calculates the schedule of the project so that the consumption of resources is as uniform as possible. |
mce |
Calculates the costs per activity needed to accelerate the project. |
organize |
Relabels the activities of a project (if \(i\) precedes \(j\) then \(i\leq j\)). |
rebuild |
Builds a type \(1\) precedence matrix. |
resource.allocation |
Calculates the project schedule so that resource consumption does not exceed the maximum available per time period. |
schedule.pert |
Calculates the duration of a project and the schedule of each activity, and plots the schedule and the AON graph. |
stochastic.pert |
Calculates the average duration of a stochastic project, the criticality index of each activity, and the density functions of the duration of the project, early times and last times. |
ProjectManagement allows the user to plot the activities on nodes
graph of the Project (AON). Originally, in the PERT methodology,
projects are represented by activities on arcs graphs (AOA). This is the
representation we have used in this paper up to now. Both AON and AOA
representations are widely used in the literature, each having some
advantages over the other in particular circumstances. For automatically
drawing the network of a project, the AON representation is more
appropriate because it is computationally much more efficient. This is
why we have incorporated it into the dag.plot
function. This
representation will be useful mainly for the user to check that he has
entered the precedence matrices correctly, which are the ones that
really characterize the project.
ProjectManagement also allows the user to choose from four different types of immediate precedences between the activities.
The relationships between the types of dependencies are as follows: Type \(1\) implies type \(2\), type \(2\) implies type \(4\), type \(1\) implies type \(3\) and finally type \(3\) implies type \(4\). Considering these relations, if one activity precedes another by more than one type, it is only necessary to indicate the one with the strongest character.
The user can indicate types \(1\) or \(2\) in the "prec1and2"
parameter
(see Table 2) using the values \(1\) or \(2\)
respectively, and types \(3\) or \(4\) in "prec3and4"
using \(3\) or \(4\)
respectively. Note that cycles can not exist.
Parameter | Description |
duration |
Vector with the expected duration for each activity. |
prec1and2 |
Matrix indicating precedence type \(1\) or type \(2\) between the activities (Default=matrix(0) ). |
prec3and4 |
Matrix indicating precedence type \(3\) or type \(4\) between the activities (Default=matrix(0) ). |
observed.duration |
Vector with the actual duration for each activity. |
delta |
Value indicating the maximum time that the project can take without delay (see equation (1)). This value is only used with the default cost function. |
distribution |
Vector with the distribution function of the duration for each activity. It can be normal, triangular, exponential, uniform, beta, t-Student, F distribution, chi-squared, gamma, Weibull, binomial, Poisson, geometric, hypergeometric, and empirical. |
values |
Matrix with the arguments of the distribution function of the duration for each activity. By rows the activities, and by columns the arguments. |
percentile |
Value used to calculate the maximum time allowed for the |
duration of the project without delay. This value is only used if no delta value is assigned. |
|
compilations |
Number of simulations that the function uses for estimation (Default=1000 ). |
cost.funtion |
Delay cost function. If this value is not added, the package uses equation (1). |
early.times |
Vector with the early time for each activity. |
PRINT |
Logical parameter indicating if the schedule and the AON graph are depicted (Default=TRUE ). |
plot.activities.times |
Vector of selected activities from which it is shown the distribution of their early and last times (Default=NULL ). |
minimum.durations |
Vector with the minimum duration an activity can take even if the resources are increased. |
critical.activities |
Vector with the critical activities to represent them in a different color in the AON graph (Default=NULL ). |
duration.project |
Value indicating the minimum time sought in the project (Default=NULL ). |
activities.costs |
Vector indicating the cost of accelerating a unit of time the duration for each activity. |
resources |
Vector indicating the necessary resources for each activity per period of time. |
int |
Value indicating the duration of each period of time (Default=1). |
max.resources |
Value indicating the maximum number of resources that can be used in each period of time. |
Function | duration |
prec1and2 |
prec3and4 |
observed.duration |
delta |
---|---|---|---|---|---|
dag.plot |
\(\checkmark\) | \(\checkmark\) | |||
delay.pert |
\(\checkmark\) | \(\checkmark\) | \(\checkmark\) | \(\checkmark\) | \(\checkmark\) |
delay.stochastic.pert |
\(\checkmark\) | \(\checkmark\) | \(\checkmark\) | \(\checkmark\) | |
early.time |
\(\checkmark\) | \(\checkmark\) | \(\checkmark\) | ||
last.time |
\(\checkmark\) | \(\checkmark\) | \(\checkmark\) | ||
levelling.resources |
\(\checkmark\) | \(\checkmark\) | \(\checkmark\) | ||
mce |
\(\checkmark\) | \(\checkmark\) | \(\checkmark\) | ||
organize |
\(\checkmark\) | \(\checkmark\) | |||
resource.allocation |
\(\checkmark\) | \(\checkmark\) | \(\checkmark\) | ||
schedule.pert |
\(\checkmark\) | \(\checkmark\) | \(\checkmark\) | ||
stochastic.pert |
\(\checkmark\) | \(\checkmark\) |
Function | distribution |
values |
percentile |
cost.function |
compilations |
---|---|---|---|---|---|
dag.plot |
|||||
delay.pert |
\(\checkmark\) | \(\checkmark\) | |||
delay.stochastic.pert |
\(\checkmark\) | \(\checkmark\) | \(\checkmark\) | \(\checkmark\) | \(\checkmark\) |
early.time |
|||||
last.time |
|||||
levelling.resources |
|||||
mce |
|||||
organize |
|||||
resource.allocation |
|||||
schedule.pert |
|||||
stochastic.pert |
\(\checkmark\) | \(\checkmark\) | \(\checkmark\) |
Function | early.times |
PRINT |
plot.activities.times |
minimum.durations |
critical.activities |
---|---|---|---|---|---|
dag.plot |
\(\checkmark\) | ||||
delay.pert |
|||||
delay.stochastic.pert |
|||||
early.time |
|||||
last.time |
\(\checkmark\) | ||||
levelling.resources |
|||||
mce |
\(\checkmark\) | ||||
organize |
|||||
resource.allocation |
|||||
schedule.pert |
\(\checkmark\) | ||||
stochastic.pert |
\(\checkmark\) |
Function | duration.project |
activities.costs |
resources |
int |
max.resources |
---|---|---|---|---|---|
dag.plot |
|||||
delay.pert |
|||||
delay.stochastic.pert |
|||||
early.time |
|||||
last.time |
|||||
levelling.resources |
\(\checkmark\) | \(\checkmark\) | |||
mce |
\(\checkmark\) | \(\checkmark\) | |||
organize |
|||||
resource.allocation |
\(\checkmark\) | \(\checkmark\) | \(\checkmark\) | ||
schedule.pert |
|||||
stochastic.pert |
ProjectManagement is available for download from CRAN. To use the package you will need to load it at the beginning of the session, usually by typing
> library("ProjectManagement")
Next we analyse the following deterministic project with \(10\) activities. Their durations and precedence relations are given in Table 7.
\(N\) | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |
---|---|---|---|---|---|---|---|---|---|---|
Immediate precedence type 1 | - | - | - | 2 | 3 | 3 | 1, 4 | 2 | 5, 8 | 6 |
Immediate precedence type 2 | - | - | - | - | 4 | - | - | - | - | - |
Immediate precedence type 3 | - | - | - | - | - | 8 | - | - | - | - |
Immediate precedence type 4 | - | - | - | - | - | - | 9 | - | - | - |
Durations | 2 | 1.5 | 1 | 4.5 | 2 | 2.5 | 3 | 4 | 2 | 5 |
We start by introducing the data set characterizing the project. We use
the function dag.plot
for depicting its AON graph. Figure
2 shows it; the green blocks contain the activities and
the precedences are represented by arrows. The blocks \(S\) and \(E\) are
the source and sink nodes, respectively. Note that the precedences type
\(1\) are arrows without label, precedences type \(2\) are labeled as SS,
precedences type \(3\) as FF, and precedences type \(4\) as SF.
> prec1and2<-matrix(0,nrow=10,ncol=10)
> prec1and2[1,7]<-1; prec1and2[2,4]<-1; prec1and2[2,8]<-1; prec1and2[3,5]<-1;
> prec1and2[3,6]<-1; prec1and2[4,7]<-1; prec1and2[5,9]<-1; prec1and2[6,10]<-1;
> prec1and2[8,9]<-1; prec1and2[4,5]<-2
> prec3and4<-matrix(0,nrow=10,ncol=10)
> prec3and4[8,6]<-3; prec3and4[9,7]<-4
> dag.plot(prec1and2,prec3and4)
Using schedule.pert
, we obtain the project schedule, i.e. the minimum
time needed to complete all activities and the early and last times.
Also, we can plot the schedule. Let us see it:
> duration<-c(2,1.5,1,1.5,2,2.5,3,4,2,5)
> schedule.pert(duration,prec1and2,prec3and4)
`Total duration of the project`
1] 10.5 [
2]] [[
Activities |
Duration |
Earliest start time |
Latest start time |
Earliest completion time |
1 |
2.0 |
0.0 |
5.5 |
2.0 |
2 |
1.5 |
0.0 |
0.0 |
1.5 |
3 |
1.0 |
0.0 |
2.0 |
1.0 |
4 |
1.5 |
1.5 |
6.0 |
3.0 |
5 |
2.0 |
1.5 |
6.5 |
3.5 |
6 |
2.5 |
2.0 |
3.0 |
5.5 |
7 |
3.0 |
3.0 |
7.5 |
6.0 |
8 |
4.0 |
1.5 |
1.5 |
5.5 |
9 |
2.0 |
5.5 |
8.5 |
7.5 |
10 |
5.0 |
5.5 |
5.5 |
10.5 |
Activities |
Latest completion time |
Slack |
Free Slack |
Independent Slack |
1 |
7.5 |
5.5 |
1.0 |
0.0 |
2 |
1.5 |
0.0 |
0.0 |
0.0 |
3 |
3.0 |
2.0 |
0.0 |
0.0 |
4 |
7.5 |
4.5 |
0.0 |
0.0 |
5 |
8.5 |
5.0 |
2.0 |
0.0 |
6 |
5.5 |
2.0 |
2.0 |
0.0 |
7 |
10.5 |
4.5 |
4.5 |
0.0 |
8 |
5.5 |
0.0 |
0.0 |
0.0 |
9 |
10.5 |
3.0 |
3.0 |
0.0 |
10 |
10.5 |
0.0 |
0.0 |
0.0 |
3]] [[
In this output we can see the total duration (10.5 units) of the project as well as other relevant information for each activity. Figure 3 depicts the different times of each activity using a colour coding. If we click on the points on the graph, a label indicates which activity and time it belongs to. Also, if we double click on a section of the legend we can see the data related to it, as in Figure 4 with the last times for each activity (another double click restarts the graph). In the output, the plot depicted in Figure 3 is saved as an object on \([[3]]\); this allows the users to manipulate the plot according to their needs. Finally, Figure 5 shows the AON graph of the project where critical activities are represented in red.
Next, suppose we are interested in shortening the duration of the
project. The mce
function is used for this purpose. Let us use the
function with the following input data: the minimum duration for each
activity even if the resources are increased
\[\bar{x}^0=\left(1,1,0.5,1,1,2,2,3,1,3\right)\]
and the costs per unit time to shorten each activity
\[c=\left(1,2,1,1,3,2,1,2,3,5\right).\]
> minimum.durations<-c(1,1,0.5,1,1,2,2,3,1,3)
> activities.costs<-c(1,2,1,1,3,2,1,2,3,5)
> mce(duration,minimum.durations,prec1and2,prec3and4,
duration.project=NULL)
activities.costs,
necessary negative increase 1: 0.5
1 item
Read =
Project duration 1] 10.0 9.5 9.0 8.5 8.0 7.5 7.0 [
= Costs per solution = Estimated durations
2.0 |
2.0 |
2.0 |
2.0 |
2.0 |
2.0 |
2.0 |
1.5 |
1.5 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.5 |
1.5 |
1.5 |
1.5 |
1.5 |
1.5 |
1.5 |
2.0 |
2.0 |
2.0 |
2.0 |
2.0 |
2.0 |
2.0 |
2.5 |
2.5 |
2.5 |
2.5 |
2.5 |
2.5 |
2.5 |
3.0 |
3.0 |
3.0 |
3.0 |
3.0 |
3.0 |
3.0 |
3.5 |
3.0 |
3.0 |
3.0 |
3.0 |
3.0 |
3.0 |
2.0 |
2.0 |
2.0 |
2.0 |
2.0 |
2.0 |
2.0 |
5.0 |
5.0 |
5.0 |
4.5 |
4.0 |
3.5 |
3.0 |
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
|||
0.0 |
0.0 |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
|||
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
|||
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
|||
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
|||
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
|||
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
|||
1.0 |
2.0 |
2.0 |
2.0 |
2.0 |
2.0 |
2.0 |
|||
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
|||
0.0 |
0.0 |
0.0 |
2.5 |
5.0 |
7.5 |
10 |
The parameter duration.project=NULL
means that we do not indicate a
minimum duration of the project, so the function asks us for a decrease
of the duration of the project to obtain all possible solutions. We have
considered it convenient a decrease of \(0.5\) units of time. Therefore,
we have obtained that the project can reduce its minimum duration to
\(10\), \(9.5\), \(9\), \(8.5\), \(8\), \(7.5\) and \(7\). For each possible duration
of the project, we have the durations of each activity (duration per
column and activity per row), as well as the cost needed to reduce their
times to these durations.
Suppose now that to complete the project each activity needs the amount
of resources
\[\left(6,6,6,3,4,2,1,2,3,1\right),\]
and we are interested in obtaining a new schedule with a uniform
consumption of resources over time. To do this we use the function
levelling.resources
in such a way
> resources<-c(6,6,6,3,4,2,1,2,3,1)
> levelling.resources(duration,prec1and2,prec3and4,resources,int=0.5)
=
Earliest start times 1] 3.5 0.0 2.0 2.0 6.5 3.0 5.5 1.5 8.5 5.5
[=
Resources by period1] 6 6 6 2 11 11 7 10 10 10 10 2 2 6 6 6 6 4 4 4 4 [
As we can see, the function returns the new earliest start times of the activities and the resources consumed in each period with the new schedule, where time periods start at \(0\) and end at \(10.5\) with an increase of \(0.5\) time units. Figure 6 represents the resources required in each period of time, before and after the readjustment.
To conclude with the analysis of resources, consider that the maximum
amount of resources available in each period is \(10\). We use the
resource.allocation
function in this situation.
> max.resources<-10
> resource.allocation(duration,prec1and2,prec3and4,resources,
int=0.5)
max.resources,=
Project duration 1] 11
[=
Earliest start times 1] 6.0 0.0 1.5 2.5 4.0 2.5 8.0 1.5 6.0 5.5
[=
Resources by period 1] 6 6 6 8 8 7 7 7 8 8 6 5 10 10 10 10 2 2 2 2 2 1 [
With the new restriction, the minimum duration of the project becomes \(11\) instead of \(10\). The output includes the new earliest start times for each activity and the consumption of resources by period (note that the last period is now 11).
Continuing the example, we now analyse the allocation of delays. The
function delay.pert
shows if there has been a delay in the project
and, in that case, allocates it among the activities. Let us see it
using the delay cost function
and the (observed) actual durations \[x=\left(2.5,1.5,2,2,2,6,4,6,3,5.5\right).\]
> observed.duration<-c(2.5,1.5,2,2,2,6,4,6,3,5.5)
> cost.function<-function(x){return(max(x-10.5,0))}
> delay.pert(duration,prec1and2,prec3and4,observed.duration,
delta=NULL,cost.function)
= 3 There has been a delay of
1 |
2 |
3 |
4 |
5 |
|
The proportional payment |
0.15000 |
0.00000 |
0.30000 |
0.15000 |
0.00000 |
The truncated proportional payment |
0.15789 |
0.00000 |
0.31579 |
0.15789 |
0.00000 |
Shapley rule |
0.00000 |
0.00000 |
0.33333 |
0.00000 |
0.00000 |
6 |
7 |
8 |
9 |
10 |
|
The proportional payment |
1.05000 |
0.30000 |
0.60000 |
0.30000 |
0.15000 |
The truncated proportional payment |
0.94737 |
0.31579 |
0.63158 |
0.31579 |
0.15789 |
Shapley rule |
1.08333 |
0.00000 |
1.08333 |
0.00000 |
0.50000 |
The output shows that there is a delay in the project of \(3\) units. As
there is a delay, we proceed to make the allocation using three rules:
proportional, truncated proportional and Shapley. We can see the
differences between the three rules, especially in activities \(1\), \(4\),
\(7\) and \(9\). While the proportional and truncated proportional rules
assign a positive payment, the Shapley rule does not assign costs to
these activities. This is due to the fact that, although they fall
behind the planned duration, they do not affect the overall delay of the
project. Note that if the project has more than ten activities,
delay.pert
does not calculate the Shapley rule; instead, it asks the
user if he wants to calculate an estimate of its value.
Let us now assume that we are in a stochastic context, with additional
information on planned durations being random variables. Using the
function stochastic.pert
with the following random variables to
describe the duration of the activities
\[\begin{aligned}
X^0=&\left(t\left(1,2,3\right),\exp\left(2/3\right),t\left(1/2,5/4,5/4\right),t\left(1/4,7/4,5/2\right),t\left(1,2,3\right),\right.\\
&\left.t\left(1,3/2,5\right),t\left(1,1,7\right),t\left(3,4,5\right),t\left(1/2,5/2,3\right),t\left(1,6,8\right)\right),
\end{aligned}\]
where \(t\left(a,b,c\right)\) denotes the triangular distribution with
parameters \(a\), \(b\), and \(c\), and \(\exp\left(\alpha \right)\) denotes the
exponential distribution with parameter \(\alpha\), we can obtain relevant
information about the project. Note that with the argument
plot.activities.times=c(7,8)
we indicate the activities for which we
want to estimate the densities of their earliest and latest start and
completion times; in this example we have requested only such densities
for activities \(7\) and \(8\).
> values<-matrix(c(1,3,2,2/3,0,0,1/2,5/4,5/4,1/4,5/2,7/4,1,3,2,1,5,3/2,
1,7,1,3,5,4,1/2,3,5/2,1,8,6),nrow=10,ncol=3,byrow=T)
> distribution<-c("TRIANGLE","EXPONENTIAL",rep("TRIANGLE",8))
> stochastic.pert(prec1and2,prec3and4,distribution,values,percentile=0.95,
plot.activities.times=c(7,8))
= 10.64242
Average duration of the project = 14.21999
Percentile duration of the project
1 |
2 |
3 |
4 |
5 |
6 |
7 |
8 |
9 |
10 |
|
Criticality index by activity |
0.6 |
88 |
11.4 |
2 |
0.1 |
11.3 |
2.6 |
86 |
4 |
93.4 |
In the output we can see the average duration of the project and the
percentile duration of the project. The percentile duration of the
project shows the value of such that the probability that the duration
of the project is smaller than \(d\) equals the variable percentile
introduced by the user (see Table 2); in this case
percentile=0.95
. In addition, we obtain the criticality index by
activity, that is, the proportion of times that an activity is critical.
An activity is critical when it has zero slack. Figure 7
plots estimations of the density function of the project duration, the
earliest start time and the latest completion time of activities \(7\) and
\(8\).
We proceed now to the allocation of the delay cost in the stochastic
model using the function delay.stochastic.pert
. To be able to compare
the results, we will use the same delay cost function as in the
deterministic case. As expected, there are noticeable differences in the
allocations between the two models, as the stochastic model makes use of
more complex information.
> delay.stochastic.pert(prec1and2,prec3and4,distribution,values,
percentile=NULL,delta=NULL,cost.function)
observed.duration,= 3 Total delay of the stochastic project
1 |
2 |
3 |
4 |
5 |
|
Stochastic Shapley rule |
0.07238 |
-0.07569 |
0.56946 |
0.07440 |
0.07238 |
Stochastic Shapley rule 2 |
0.00693 |
0.03470 |
0.51967 |
0.01363 |
0.00731 |
The proportional payment |
0.15000 |
0.00000 |
0.30000 |
0.15000 |
0.00000 |
The truncated proportional payment |
0.15789 |
0.00000 |
0.31579 |
0.15789 |
0.00000 |
6 |
7 |
8 |
9 |
10 |
|
Stochastic Shapley rule |
1.66514 |
0.08271 |
0.11897 |
0.07256 |
0.34769 |
Stochastic Shapley rule 2 |
1.62101 |
0.02287 |
0.25006 |
0.01046 |
0.51336 |
The proportional payment |
1.05000 |
0.30000 |
0.60000 |
0.30000 |
0.15000 |
The truncated proportional payment |
0.94737 |
0.31579 |
0.63158 |
0.31579 |
0.15789 |
Finally, to illustrate the runtime of previously used functions, Table 8 shows the time (in seconds) needed to compute several problems. We have selected a variety of projects with \(2\), \(4\), \(6\), \(8\) and \(10\) activities, and we have run the different routines on a computer with Intel Core i\(5-7200\)U and \(12\) GB of RAM.
Activities | 2 | 4 | 6 | 8 | 10 |
---|---|---|---|---|---|
delay.pert |
\(0.00\) | \(0.00\) | \(0.00\) | \(0.03\) | \(0.11\) |
delay.stochastic.pert |
\(0.06\) | \(0.44\) | \(1.68\) | \(6.23\) | \(30.58\) |
early.time |
\(0.00\) | \(0.00\) | \(0.00\) | \(0.00\) | \(0.00\) |
last.time |
\(0.00\) | \(0.00\) | \(0.00\) | \(0.00\) | \(0.00\) |
levelling.resources |
\(0.00\) | \(0.00\) | \(0.00\) | \(0.02\) | \(0.03\) |
mce |
\(0.00\) | \(0.00\) | \(0.00\) | \(0.00\) | \(0.02\) |
organize |
\(0.00\) | \(0.00\) | \(0.00\) | \(0.00\) | \(0.00\) |
resources.allocation |
\(0.00\) | \(0.00\) | \(0.00\) | \(0.01\) | \(0.02\) |
schedule.pert |
\(0.08\) | \(0.11\) | \(0.13\) | \(0.11\) | \(0.12\) |
stochastic.pert |
\(0.02\) | \(0.03\) | \(0.05\) | \(0.04\) | \(0.04\) |
This work has been supported by the MINECO grant MTM2017-87197-C3-1-P and by the Xunta de Galicia through the ERDF (Grupos de Referencia Competitiva ED431C-2016-015 and Centro Singular de Investigación de Galicia ED431G/01). The comments of an anonymous reviewer have helped us to improve this paper significantly.
PlotPrjNetworks, plan, ProjectManagement, triangle, plotly, igraph, kappalab, GameTheory, lpSolveAPI
Distributions, GraphicalModels, Optimization, WebTechnologies
This article is converted from a Legacy LaTeX article using the texor package. The pdf version is the official version. To report a problem with the html, refer to CONTRIBUTE on the R Journal homepage.
Text and figures are licensed under Creative Commons Attribution CC BY 4.0. The figures that have been reused from other sources don't fall under this license and can be recognized by a note in their caption: "Figure from ...".
For attribution, please cite this work as
Gonçalves-Dosantos, et al., "ProjectManagement: an R Package for Managing Projects", The R Journal, 2020
BibTeX citation
@article{RJ-2020-009, author = {Gonçalves-Dosantos, Juan Carlos and García-Jurado, Ignacio and Costa, Julian}, title = {ProjectManagement: an R Package for Managing Projects}, journal = {The R Journal}, year = {2020}, note = {https://rjournal.github.io/}, volume = {12}, issue = {1}, issn = {2073-4859}, pages = {419-436} }