The Earned Schedule Exchange


March 30, 2017
ES for Agile Projects: Steps 3 & 4 Capture the Data & Calculate the Metrics

Concept: My posts on AgileES have thus far focused on “what” and “why”. That is, I’ve described the concepts behind AgileES and the benefits of using ES on Agile projects. It’s now time to shift the focus to “how to”. The next posts describe how to apply ES to Agile projects. There are several steps. Some of the steps, especially the initial ones, are controversial. In explaining each step, I will identify and address the issues and then describe the actions to be taken. 

Step_3_and_4_Capture_and_Calculate.jpg 

Practice: AgileES is a lightweight process. It requires no data collection beyond what is normally done for an Agile project that is constrained by time. Calculating the metrics takes additional effort, but the increment is virtually eliminated by using a tool.

3. Capture Performance Data.

The routines for collecting performance data vary from project to project, but the best practices we have observed are as follows.

  • Collect data continuously during a Sprint, rather than at the end of a Sprint.
  • Count the number of Release Points that have been completed during the Sprint.
  • Add new Items identified during the Sprint to the Product Backlog.
  • Add new Release Points identified during the Sprint to the total count.
  • Remove all Product Backlog Items and Release Points that are no longer required.

4. Calculate the Metrics.

The calculations are generally done at the end of each Sprint and results are stored across Sprints to facilitate trend analysis.

Here are the calculations used by both Agile and AgileES projects that operate under constraints:

  • Planned Value and Earned Value: Historically, these are referred to as Budgeted Cost of Work Scheduled (BCWS) and Budgeted Cost of Work Performed (BCWP). The Cumulative Planned Value (CPV) equals the Planned Release Points (PRP) multiplied by a relevant Rate (Rk). The Earned Value at the Actual Time (EVAT) equals all Release Points Completed (RPC) by the Actual Time multiplied by a relevant Rate. [1]

EQ01_CPV.jpg

EQ02_EVAT.jpg

  •  Actual Percent Complete: the Actual Percent Complete at Sprint n (APCn) equals the total number of Release Points Completed at Sprint n (RPCn) divided by the total number of Planned Release Points (PRP). That is,

EQ03_APC2.jpg 

  • Estimated Completion Date for counts: This is also known as the estimated Release Date given the expected velocity (RDv). It equals the Start Date (SD) plus the sprint length (L) multiplied by the number of sprints (n) divided by the Actual Per Cent Complete (APCn).

EQ04_RDv.jpg

  • Baseline Release Points (RP) Burndown: For each Sprint, the number of Release Points remaining given the total number of Planned Release Points less the planned velocity (vp). When charted, the Baseline RP Burndown shows how much planned work should have been completed and, by inference, how much remains on the project.

EQ05_RP_Base_Burn_Calc.jpg

Graphically:

EQ06_RP_Base_Burn_Chart.jpg

Figure 1

  • Actual Release Points Burndown: For each Sprint, the number of Release Points remaining given the total number of Planned Release Points less the actual velocity at Sprint n (vn). When charted, the Actual RP Burndown shows how much planned work has been completed and, by inference, how much remains on the project.

EQ07_RP_Act_Burn_Calc.jpg

Graphically:

EQ08_RP_Act_Burn_Chart.jpg

Figure 2


Here are the calculations used specifically by AgileES:

  • Earned Schedule: The ES is the time at which the value currently earned should have been earned. It is calculated by the following equation.
    EQ09_ES.jpg
  • Schedule Performance Index for time: The SPIt measures how efficiently time is being used on the project. The efficiency is given by the ratio between the amount of schedule that has been earned and the current time.

EQ10_SPIt2.jpg 

  • Estimate at Completion for time: The EACt estimates how long it will take to complete the project given past performance. The estimate equals the ratio between the Planned Duration (PD) and the SPIt.

EQ11_EACt2.jpg 

  • Estimated Completion Date for time: The ECDt renders the estimate as a specific date. To produce the date, the EACt is added to the project’s Start Date (SD).

EQ12_ECDt.jpg 

  • Rate of Discovery: The ratio between the current number of Planned Release Points and the baselined total of Planned Release Points. The RoD measures the amount of change that is occurring on the project.

EQ13_RoD2.jpg

  • Baseline Earned Schedule (ES) Burndown: For each Sprint, it is the number of Sprints remaining given the total number of Sprints less the number of Elapsed Sprints. [2] When charted, the Baseline ES Burndown shows how much of the timeline should have been completed and, by inference, how much remains on the project.

EQ14_ES_Base_Burn_Calc.jpg

Graphically:

EQ15_ES_Base_Burn_Chart.jpg

Figure 3

  • Actual ES Burndown: For each Sprint, the number of Sprints remaining given the total number of Sprints less the number of Sprints (or portions thereof) completed, i.e., less the Earned Schedule. When charted, the Actual ES Burndown shows how much of the timeline has been completed and, by inference, how much remains on the project.

EQ16_ES_Act_Burn_Calc.jpg

Graphically:

EQ17_ES_Act_Burn_Chart.jpg

Figure 4

When differential rates are applied to Release Points, the ES Burndown can vary significantly from the RP Burndown.  A recent project provides an example.

First, Figure 5 shows the Release Point Burndown. The “bulge” at Sprint 8 occurred when Reserve was released. Reserve is not part of the Baseline but omitting it made the chart inaccurate: either the new Release Points were not shown or the burndown went into negative numbers. Here, it is included as part of the project commitment.

EQ18_RP_Burn_Chart_One_Rate.jpg 

Figure 5

Next, Figure 6 shows the ES Burndown when a single rate is used to value all Release Points. Note how it follows the Release Point Burndown for most of the project. It varies only at the end. Again, that is when Reserve was released. The release is reflected in the extension to the timeline.

EQ19_ES_Burn_Chart_One_Rate.jpg

Figure 6

Finally, here is the ES Burndown when different rates are applied to Release Points. In the real case, the rates varied by the resource assigned to complete the Release Points. There is an obvious “bulge” at Sprints 3-5, indicating that time was not being used efficiently.

What happened? In an effort to maintain the planned velocity, the team completed Release Points that were quick to finish but of relatively low value. That move sustained the Release Point velocity but lost schedule efficiency (as measured by value).

EQ20_ES_Burn_Chart_Var_Rate.jpg

Figure 7

 [1] On many Agile projects, a nominal Rate of $1 is appropriate. If so, the committed PRP total and the CPV will match, as will the RPC and EVAT. There are cases where variable Rates are a better fit, and when this occurs, metrics can be significantly affected. For more information on differential Rates, see the previous post on ES and Agile differences. Finally, do not mistake Earned Value for Business Value. EV is a measure of performance efficiency. BV is a measure of performance effectiveness. For more information, see the aforesaid post.

 [2] The total number of sprints is determined by the total number of release points divided by the estimated velocity, i.e., by the estimated number of Release Points per Sprint.

Add new comment

All fields are required.

*

*

*

No Comments




Archives