Using VersionOne for Earned Value Management (EVM) Reporting
Last Updated Feb 19, 2013 — Enterprise Agile Planning expert
Enterprise Agile Planning
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.
PI Planning aims to bring together all the people doing the work and empower them to plan, estimate, innovate, and commit to work that aligns with the business’s high-level goals, vision, and strategy.
Silvia Davis, Sr. Product Marketing Manager at Digital.ai, tells her story of how a positive app experience led to the realization that proper data integration is essential to the entire application lifecycle.
Regardless of where you are on your digital transformation journey, we can help you achieve your strategic outcomes and accelerate value delivery with the right combination of technology, services, and training.