EVM (Earned Value Management)

FlipBumWalla · ‎03-01-2012

EVM (Earned Value Management)

I have a request to create some "reporting" functionality that our users are calling EVM (Earned Value Management). There is no out of the box solution for calculating this EVM. One person suggested "... using the 'metrics' table, set the %complete/budget spent fields to take a snapshot weekly and then trend against the results" Ultimately, we would like to present a trend graph that displays the value the %complete and %budget spent from week to week, and eventually month-to-month for a single project. This should provide us an indicator as to whether we are stalled on our efforts or progressing along.

Question:
-- Does anyone have any experience or possibly some sample code to help me out?

Please and thank you!

ddhaene · ‎06-05-2012

Bump

Does anyone have any insight?

maryjolyness · ‎07-26-2017

I have the same question. One of our customers is asking about whether SN PPS can provide Earned Value. It seems to me that you could get EV for the work being performed by creating a report that would take the value in the Planned Resource Cost field on a project record and multiply it by the value in the % Complete field in the project record. This may not align 100% with all the principles of EVM, but it would be something.

gyedwab · ‎01-25-2018

Hi Mary,

Not sure if you ever solved this, but I took a cut at creating this using Explore Analytics, you can see it here:

EVM

I used the Estimated Cost and Actual Cost fields on the Project Task table, although I could do the same with Planned Resource Cost as well.

For PV, I used a running total of the Estimated Cost by Planned end date of all the associated Problem Tasks.

For EV, based on this definition: ${\begin{aligned}\mathrm {EV} &=\sum _{\mathrm {Start} }^{\mathrm {Current} }\mathrm {PV(Completed)} \qquad \mathrm {or} \qquad \mathrm {EV} =\mathrm {budget\,at\,Completion\,(BAC)} \times \mathrm {Actual\%\,Complete} \end{aligned}}$

Using the first option, I used a running total of the Estimated Cost by Work end date of any completed problem tasks.

For the Actual Cost, I used a running total of the Actual Cost by Work end date of all the associated Problem tasks.

Does this look like what you're looking for?

This report is generated in real-time in ServiceNow, can be embedded in ServiceNow with drill-through.

gyedwab · ‎02-06-2018

Hey --

Created a video showing how the report is created:

ServiceNow Earned Value Management Reporting with ServiceNow - YouTube