Skip to content

MSP2007 - Summary EV Calculation

Tony McClennonMember for 23 years 10 months
Created
1
4
0

First of all, apologies if this has been covered in a previous post - I have gone back 3 years on this board and not been able to find the answer!!

Using MSP2007, I have been asked to produce a fairly basic EV report, and thought that MSP would be the ideal tool to do this. There are a number of tasks that roll up under three separate summary bars (Design, Procurement, Construction). All tasks are baselined, and I have added some cost information against the tasks (fixed costs rather than labour rates x hours).

As I would have expected, if I progress tasks as all up to date, task SPI/CPI are coming out as 1.

When I enter % complete as less than the Planned Value information, the task shows the "shortfall" in cash terms, and also shows the SPI being less than 1 (as expected), but does not show this shortfall in "earned value" as a forecast overspend in the EAC field, nor does the CPI change as I would have expected.

In addition, when I check the summary tasks, this is showing an SPI of 1.94, rather than something between 0.83 and 1 (the two SPI values of the sub-tasks).

I have searched the internet for a solution, and whilst there seems to be an acknowledgement that this is a problem, and the suggested solution of changing the EV calculation basis to use "Physical % Complete" does not seem to make any difference.

Is there something glaringly obvious that I am missing here? Any help gratefully accepted!!

1 reply

Oldest first
  1. 0
    Tony McClennon ·

    Think I may have answered my

    Think I may have answered my own question!!! Whilst playing around, I realised that after adding some more costs in that the updated tasks needed rebaselining in order for the calculations to be done correctly.

    When using Tools/Tracking/ Set Baseline then choosing "selected tasks", it offers an option  to "Roll up Baselines" and select "To all summary tasks". When I checked this box, the SPI then recalculated the summary bar, and this now shows an SPI of 0.89 (the two costed tasks below have SPIs of 0.8 and 1 hence 0.89 is in the right "ball park") instead of the previous 1.94.

    Fingers crossed this has resolved the issue!!

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Existing members: your original username and password still work. Forgot password?