## Friday, April 26, 2013

### Variance and Trend Analysis

In the previous chapters we took a look at some of the tools and techniques used in monitor and control risks process like Risk Audit, Risk Reassessment, Reserve analysis etc. The topic for discussion in this chapter is “Variance and Trend Analysis” which is a valuable tool for any Risk Manager.

Purpose: To forecast any potential cost and/or schedule deviations in the project at completion

In the chanter on inputs for the monitor and control risks process, we saw that we will be need performance related data like Work Performance Info and Performance Reports for this process. We will be using those inputs in this process. We take all the performance data related to our project so far and then:

• The risk management team examines trends in the team’s performance
• Identifies variances by comparing planned vs. actual data
• Identifies any potential delays or bottlenecks with respect to the completion of the Project.

So, the next logical question here would be – how will we analyze the data gathered so far?

We will be using Earned Value Analysis to do all that. Though Earned Value isn’t an actual topic as part of the PMI RMP syllabus, it would be a good idea to revisit the following two chapters to refresh your memory:

a. Cost Management during Monitoring & Controlling the Project
b. Measuring Project Performance

I am pretty sure that you did not revisit those chapters because; I would’ve probably done the same. So, let’s quickly cover the basics of Earned Value Analysis so that we know what we need to know for the PMI RMP Exam.

The basic idea of Earned Value Analysis is to integrate project, cost and scope measures to assess the project performance and progress as of date.

The following are the EVM Terms we will need to know:

Planned Value (PV) – The value that signifies how much work must have been completed so far
Earned Value (EV) – The value that signifies how much work has actually been completed so far
Actual Cost (AC) – The value that signifies how much money/cost we have spent on our project so far

Based on these 3 numbers we can calculate the following:

Schedule Variance (SV) – The deviation between the actual schedule progression and the planned schedule
Cost Variance (CV) – The deviation between the actual cost spent on the project and the planned project budget

Cost Performance Index (CPI) – The Numeric Representation of the Project’s cost performance – A number between 0 and 2.
Schedule Performance Index (SPI) – The Numeric Representation of the Project’s schedule performance – A number between 0 and 2.

In either case we would expect the performance index value to be greater than 1 which means we are ahead of schedule or within cost.

Estimate To Complete (ETC) – The amount of funds required to complete the project from the current status/point

Estimate At Completion (EAC) – The amount of funds the project is expected to utilize as a whole, throughout its life when the completion stage is reached.

If you are already a PMP certified manager, you must remember those confusing formulas EV/PV, EV/AC etc. that we would’ve memorized for the PMP Exam. Thankfully, for the RMP Exam, we need not remember all those formulae. That is why; I haven’t given any of the formulas in our quick recap. For the exam, we need to understand the concept and what each of these Earned Value terms signify which I believe, we do by now, don’t we??

Prev: Workarounds and Reserve Analysis

Next: Estimation Techniques & Cost Benefit Analysis