none
SPI and CPI showing Zero values? Help needed RRS feed

  • Question

  • Below are 2 scenarios/questions related to not seeing expected SPI/CPI values:
    ===============

    SPI and CPI showing Zero values: (Scenario-1)
    ----------------------------------------

    We have got a Master Project which has got its own few tasks (under a summary task) and then it has also got 2 sub-projects inside it as well.

    For some reason we see the value of "SPI" and "CPI" as zero value whenever we open the same published schedule.

    But, when we expand 2 subprojects inside the master project then we start seeing the values in there just fine.

    And then again after saving/publishing and reopening the values gets shown as ZERO.

    Strangely, then there is a PWA report that shows these values of the SPI and CPI correctly on it so that tells as if the values are getting saved fine in the Project Server Database.

    So, the question is as to why the MS Project 2010 is resetting both SPI / CPI to zero value every time this master project is opened.?

    SPI and CPI showing Zero values: (Scenario-2)
    ----------------------------------------

    We have a project with a particular task, which has a start date in the future. The project has been baselined and the task in question show's values for baselined cost and actuals just fine. Now not sure as to why SPI and CPI values are shown as ZERO for a particular task?

    ===============

    I would appreciate if some help pointers can be given here for the above 2 seperate questions. Thanks in advance.


    • Edited by Srini-coder Tuesday, January 10, 2012 5:51 AM typo correction
    Tuesday, January 10, 2012 5:50 AM

Answers

  • Ok - I read it a bit closer.  Scenario 2 is predictable.  Microsoft Project doesn't handle work ahead of schedule for EVMS calculations.  If you push the status date past the end of the task that completed ahead of schedule, my guess is that you will see EVMS data.  Please confirm.

    Scenario 1: at the master project level, do you see ACWP, BCWP, and BCWS data?


    Andrew Lavinsky [MVP] Blog: http://azlav.umtblog.com Twitter: @alavinsky
    Tuesday, January 10, 2012 1:06 PM
    Moderator
  • i would echo what andrew said, unless you push the status date you wouldn't see SPI & CPI for future tasks
    Thanks | Sunil Kr Singh | http://epmxperts.wordpress.com
    Wednesday, January 11, 2012 1:56 PM
    Moderator

All replies

  • Possibly an issue with the baseline and/or status date mechanism...?  Here's a blog post which might point you in a direction to try:

    http://azlav.umtblog.com/2011/10/25/working-with-master-projects-in-project-server-2010/

    Do you see ACWP, BCWP and BCWS data?


    Andrew Lavinsky [MVP] Blog: http://azlav.umtblog.com Twitter: @alavinsky
    Tuesday, January 10, 2012 10:48 AM
    Moderator
  • So again there as 2 different cases from 2 different projects that I have mentioned here. May be, I should have done 2 different posts, I guess.

    For Case-1:
    So the expectation was that Master Project’s Summary Level should show me the Cumulative Roll ups of sub-projects SPI/CPI and which in a way its doing but unfortunately its not saving those values even after doing save and publish of master project? Do we know as to why these values are not getting saved?

    For Case-2:
    ACWP, BCWP and BCWS data all show zero values too. And yes , these are the ones used in  SPI/CPI calculation.  Again, my impression was that if we have the cost figure appearing in there  for that particular task then we should see some thing for CPI?

    Thanks in advance.

    Tuesday, January 10, 2012 11:38 AM
  • Ok - I read it a bit closer.  Scenario 2 is predictable.  Microsoft Project doesn't handle work ahead of schedule for EVMS calculations.  If you push the status date past the end of the task that completed ahead of schedule, my guess is that you will see EVMS data.  Please confirm.

    Scenario 1: at the master project level, do you see ACWP, BCWP, and BCWS data?


    Andrew Lavinsky [MVP] Blog: http://azlav.umtblog.com Twitter: @alavinsky
    Tuesday, January 10, 2012 1:06 PM
    Moderator
  • i would echo what andrew said, unless you push the status date you wouldn't see SPI & CPI for future tasks
    Thanks | Sunil Kr Singh | http://epmxperts.wordpress.com
    Wednesday, January 11, 2012 1:56 PM
    Moderator
  • Thanks Andrew. I have another follow-up question for scenario-2: Apparently I found that there were some actuals done by the PM for the future dates which was causing the issue of CPI/SPI to be zero. But now whats the best way to correct this. My guess is that PM make the adjustments to the start and end dates and these Actuals will move as well. And then re-baseline the project? Please advise.
    Thursday, January 12, 2012 3:56 AM