Simple SPI

[Kevinexzim]

I want to keep an eye on schedule slippage on a project.

Is there a simple equivalent to SPI (Schedule Performance Index = ratio of
work performed/work scheduled) using just Duration, without involving
Resources, Work and Costs?

MS Project wants to use Work, Resources and Costs to calculate SPI =
BCWP/BCWS (Budgeted Cost of Work Performes/Budgeted Cost of Work Scheduled).

Some of my projects are simply task-based and scheduled in Duration
(workdays) - without Resources, Work or Costs.

Even for those projects that do have Resources, Work and Costs, I would like
SPI based simply on Duration.

I use MS Project 2002.

Thanks.

 

[Jim Aksel]

Is your real question "I need to know if my %Complete is big enough to be on
schedule, or am I behind schedule because my %Compelte is too small?"

If that is what you need, try the status column. Also, read the post and my
answer by "Hanni" titles "Releative % Progress and status column" It was
posted today.
--
If this post was helpful, please consider rating it.

Jim
It''s software; it''s not allowed to win.

Visit http://project.mvps.org/ for FAQs and more information
about Microsoft Project

 

[Kevinexzim]

After raising the question below, I scoured the postings & found some helpful
threads on the same issue. Thanks to John <[email protected]>, Jack and
Steve House.

I would like to add to the question:
I also want to identify SV Schedule Variance, again simply in tems of
Duration Performed minus Duration Planned to the Status Date.
MSP wants to use costs as the basis - I only want to use Duration.

 

[Jim Aksel]

To accomplish this, you will need to create custom fields for each of them
and use custom formulas. It begs the question - if there has been all this
effort over many years to develop Earned Value and all the associated
formulas, etc then why not use what has been working for years? Trying not
to be insulting, but I can't imagine that your project is so special that you
have to do it different than the rest of the world. Please think deep on
that one.

So, here's how you can use all the work Microsoft and the American National
Standards Institute and others aound the world have already done for you--

Make one resoure called "Resource" who works at $1/hr. All the real calcs
will work as long as the resource is level loaded at 100% and you have a
baseline. One Day of time duration equals $8 of work - you are trading one
for the other.

--
If this post was helpful, please consider rating it.

Jim
It''s software; it''s not allowed to win.

Visit http://project.mvps.org/ for FAQs and more information
about Microsoft Project

 

[Kevinexzim]

Thanks Jim - that helps.
Now I want to go further and see what the end date is being pushed out by as
a result.
Regards.

 

[Kevinexzim]

That's helpful Jim and I agree with your overall sentiment. For plans that I
build myself, I may take the simple resource-cost approach that you suggest.
Often though, I have to assess other service providers' plans and cannot rely
on them having accurate and updated cost-resource data. Before tearing their
data apart I want to make a simple progress vs plan assessment.

In this context I agree with others that Schedule Variance should be based
on duration, independent of cost, which should have its own variance metrics.