How to Calculate Project Variance

project variance

Hopefully your projects never have this type of variance!

A variance is defined as a schedule, technical, or cost deviation from the project plan.  Variances should be tracked and reported, as well as mitigated through corrective actions.  There are two types of variance which normally receive most of the attention:

  1. Cost Variance
  2. Schedule Variance

Calculating variances for an engineering project is an important step and requires the definition of several variables:

  • BCWS, or Budgeted Cost of Work Scheduled, is the budgeted amount for each task at the specified point of analysis (usually today).
  • BCWP, or Budgeted Cost of Work Performed, is the actual completion amount of each task relative to the task budget.
  • ACWP, or Actual Cost of Work Performed, is the actual expenditure for each task.

And now, for the calculations:

  • Cost Variance (CV) is the amount that the project in a cost overrun or underrun position:
    CV = BCWP – ACWP
  • Schedule Variance (SV) is the amount that the project is behind or ahead of schedule:
    SV = BCWP – BCWS

Obviously, the cost is used as the base variable in the calculation for both cost and schedule variance, which has caused some engineers to want to express them as a percentage:

  • CVP = CV / BCWP
  • SVP = SV / BCWS

However, the units of each variable does not have to be dollars.  It can be hours, days, weeks, resource depletion units, etc.

Example

Let’s say you are the project manager for the renovation of 3 hotel rooms.  The tasks are as follows:

  1. Preparation:  Mar. 1-Mar. 10, $5,000
  2. Room #1:  Mar. 10-20, $10,000
  3. Room #2:  Mar. 15-25, $10,000
  4. Room #3:  Mar. 20-30, $10,000
  5. Wrap-up:  Mar. 25-31, $5,000

It’s Mar. 22 today.  You figure you’re 100% complete on the preparation phase as well as Room #1, and 60% complete Room #2. Your receipts (plus timesheets, etc.) are showing $5,500 spent on preparation, $8,900 on Room #1, and $5,500 on Room #2.

project variance example table
In this case, we have a schedule problem (SV is negative) but not a cost problem (CV is positive).  The project is behind schedule, but below budget relative to the tasks performed.

About Bernie Roseke, P.Eng., PMP

Bernie Roseke, P.Eng., PMP, is the president of Roseke Engineering. As a bridge engineer and project manager, he manages projects ranging from small, local bridges to multi-million dollar projects. He is also the technical brains behind ProjectEngineer, the online project management system for engineers. He is a licensed professional engineer, certified project manager, and six sigma black belt. He lives in Lethbridge, Alberta, Canada, with his wife and two kids.

View all posts by Bernie Roseke, P.Eng., PMP

Leave a Reply

Your email address will not be published. Required fields are marked *

*