# How to calculate the schedule performance index?

+1
vote
Please give me a complete walk through on how to calculate the schedule performance index or SPI.

Please start from scratch, don't just tell me SPI = X / Y , where X and Y are also calculated by other formulas.

So if SPI = X / Y then I want to know how to get X and how to get Y, and if X =  A / B then I want to know how to get  A an B as well, until I reach a number that is not calculated (like, for example, the total number of hours for the project).

0
OK, fair enough. Here's how you calculate the SPI, from scratch:

SPI = EV / PV (Earned Value / Planned Value)

in other words,

SPI = BCWP / BCWS = Budgeted Cost of Work Performed / Budgeted Cost of Work Scheduled = (Total Budget * % Complete Actual) / ((Hourly Rate or Daily Rate) * (Number of days scheduled or Number of hours scheduled))

%Complete Actual = AC / EAC Where AC is the Actual Complete and EAC is = AC + ETC. ETC is the Estimate To Complete.

%Complete Actual = AC /(AC + ETC)

In any project we have AC and we have ETC

So now the SPI formula is:

SPI = (Total Budget * (AC/(AC + ETC)))/(Hourly Rate * Number of planned hours)

Here's an example, assuming you have a project with a total budget of \$100,000. The project consists of 10 tasks (usually it's work packages but let's keep it easy) of equal lengths, each is a 100 hours, and each hour costs a \$100. Let's assume you look at your baseline, and you see by now you should have finished, by now 5 tasks, but in reality, you only finished 4.

Now the actual cost is AC = 4 tasks * 100 hours * 100 = 40,000

%complete = AC/(AC + ETC) = 40,000/(40,000 + 60,000) = 40%

Now the EV = \$100,000 * 40% = 40,000

SPI = EV / PV = 40,000 / 50,000 = 0.8. Since SPI is below 1, this means that we are behind schedule, and it is taking us 10 hours of actual work for each 8 hours of planned work.

I was going to give you another example, but it was very complicated, so I dropped it.

Anyway, hope the above helps!
answered 10 years ago by (17,390 points)

+1
vote
1
+1
vote
1