Using VersionOne for Earned Value Management (EVM) Reporting

February 19, 2013 Jerry Odenwelder

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!

About the Author

Jerry Odenwelder

Jerry Odenwelder is a Senior Product Manager at CollabNet VersionOne. He has been involved in software development for over 20 years. The majority of that time has been spent in agile environments. Jerry has held various roles in start-ups and Fortune 500 organizations. He has co-written articles for Cutter Consortium and has spoken at conferences. In his spare time, Jerry enjoys being outdoors and spending time with his family.

More Content by Jerry Odenwelder
Previous Article
Hands-On Lab with Gerrit and Jenkins Q & A
Hands-On Lab with Gerrit and Jenkins Q & A

CollabNet kicked off the new year with a 3 part series called Go Agile with Git on January 15, 2013. (Tweet...

Next Article
New 12.3 Point Release Available
New 12.3 Point Release Available

In honor of our great late President, and of that fateful day in history, we present the 12.3.7 point relea...