Using VersionOne for Earned Value Management (EVM) Reporting

There has been a lot written on the relationship between Earned Value Management (EVM) and Agile Development (See References below). There is now functionality in VersionOne Analytics (part of the VersionOne Ultimate Edition) to pull key Agile metrics that support EVM and output them in a report. This post goes through one such report. You can use the Custom Reporting module in Analytics to create variations on this example. Note that the information in the report can be exported to Excel, CSV, and/or PDF.

Assumptions used in building the Report:

  • All EVM information is at the Release level.
  • Dates, Budget (or Budget at Completion- BAC), and Total Estimate (Planned Release Story Points= PRSP) baselines will be established at the beginning of the Release and fixed as much as possible.
  • Percent Complete will be measured by comparing Open and Closed Story Points.
  • Expected Percent Complete will be measured by comparing days elapsed versus total days for the Release.
  • Costs will be computed using Effort. This might not work for all organizations as they might track this in a separate system.

Calculations in the Report:

  • Planned Value (PV) = Budget * Expected Percent Complete
  • Earned Value (EV) = Budget * Percent Complete
  • Actual Cost (AC) = Total Done * Constant ($145/ hour)
  • Cost Performance Index (CPI) = EV/ AC
  • Scheduling Performance Index (SPI) = EV/ PV
  • If Percent Complete is less than Expected Percent Complete, then the cell will be highlighted in Red.

The Resulting Report:

Again, this is just one way to approach this using VersionOne Analytics. This report can be customized to match the way your organization does EVM.

If you are interested in more information or a copy of the VersionOne Analytics Report Definition for this report, please contact me.

Here are a list of References on EVM and Agile:

This is still an emerging area within Agile and Project Management.

Please share your comments and questions below. Thanks for reading!

This entry was posted in Product Tips & Tricks. Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>