Earned Value Management the Easy Way

Earned Value Management

Earned Value is based on the idea that the value of the product of the project increases as tasks are completed.
And therefore the Earned Value is a measure of the real progress of the project.

Earned Value provides a standard means of objectively measuring work accomplished by integrating cost, schedule and technical performance into one set of metrics so that meaningful comparisons can be made.

Earned Value can be used to communicate the progress of the works.
This is historical information, “water under the bridge”, you can’t do anything about it.

The more relevant use to the proactive project manager is to measure variances and define trends.
Actions can then be taken to reduce the unwanted variances and the wayward trends.

Remember, if you can’t measure it, you can’t manage it.

We spend man-hours and materials in completing a task. If we are efficient we complete the task with man-hours to spare and with minimum wasted materials.

If we are inefficient we use up more man-hours and waste materials.

We also plan how we will accomplish the task. How long it will take, the resources we need and the estimated costs.
By taking a snap-shot of the project and calculating the earned value metrics we can compare the planned with the actual and make a subjective assessment of how well the project is performing.

By extrapolating the curves and further calculation we can also estimate the costs to project completion and the probable completion date.

The fundamental concept of Earned Value Management can best be shown on the ubiquitous ‘S-Curve’.

S-Curve

The S-curve in its simplest form is a graph showing how project budget is planned to be spent over time.
We can complicate the graph by showing the actual costs of doing the work over the same period.
And also on the same graph we can show how the value of the product of the project increases over the same period.

The three curves on the graph represent:

Budgeted Cost for Work Scheduled (BCWS) – the budgets for all activities planned to be completed.

Actual Cost of Work Performed (ACWP) – the real costs of the work charged against the completed activities.

Budgeted Cost of Work Performed (BCWP) – the planned costs of the work allocated to the completed activities. This is the Earned Value.

The BCWS curve is derived from the Work Breakdown Structure, the project budget and the Project Master Schedule.

The planned cost of each Work Package is calculated and the cumulative planned cost of completed Works Packages is shown based on the planned completion dates shown in the Master Schedule.

The ACWP curve is found by actual measurement of the work completed.
Actual costs recorded from invoices and workmen’s time sheets.
This appears a daunting task but it can be very simple with sufficient planning and organising.

The BCWP is calculated from the measured work complete and the budgeted costs for that work.

Earned Value = Percentage project complete X Project Budget

Earned Value Variances

Schedule and cost variances can both be calculated in monetary terms from the data needed to produce the S-curves.

Schedule Variance (SV) is the difference between the Earned Value and the Planned Cost.

SV = BCWP – BCWS

Cost Variance (CV) is the difference between the Earned Value and the Actual Costs of the works.

CV = BCWP – ACWP

Earned Value Performance Indices

Schedule Performance Index and Cost Performance Index give indications of the health of the project.

Is the project on time, in budget or what?

Schedule Performance Index (SPI) is a ratio of Earned Value and the Planned Value of completed works.

SPI = BCWP / BCWS

Cost Performance Index (CPI) is a ratio of Earned Value and the Actual Costs of completed works.

CPI = BCWP / ACWP

Earned Value Estimate At Completion

The Estimate at Completion (EAC) gives an idea of the final costs of a project.

It takes into account the performance of the project so far and assumes the future performance will not change.

So, Estimate At Completion = Actual Costs to date + Difference between Budget At Completion and Budgeted Cost of Work Performed modified by the Cost Performance Index

EAC = ACWP + ((BAC-BCWP)/CPI)

Setting up an Earned Value Management system

Can be painless and for sure need only be done once, during the beginning phase of the project when the work is first scheduled.

In Steps:

  • Define the scope of the works.
  • Set up a Work Breakdown Structure (WBS).
  • Develop a Project Master Schedule showing when every Work Package will be carried out.
  • Allocate budget costs to each Work Package (the lowest level of WBS).
  • Establish a practical way of measuring the actual work completed.
  • Set, in concrete, the performance measurement baseline.

Define the Scope of the Work

Scope definition is defined at the very beginning of the the planning phase. I emphasise that the scope of the works must be frozen at some early stage in the project life cycle.
And if the product of the project changes shape, size or color then change management techniques must be employed to control and monitor the changes to the agreed frozen scope.

Set Up a Work Breakdown Structure

For efficient monitoring and control the scope of a project must be clearly structured.
A project’s structure is a hierarchical distribution of the scope into logical groupings and levels. The breakdown of the work can also be structured based on the project phases.
This, the Work Breakdown Structure, is usually triangular in shape and the base, or lowest level, is made up of Work Packages (WP).

Work Packages are the smallest self contained grouping of work tasks considered necessary for the level of control needed.

A Work Breakdown Structure is defined disregarding the time schedule and any inter-dependencies. However, it is the basis for developing the time schedules, delivery plans as well as for resource planning.

In ‘PMI-Speak’, the WBS is an output from the Scope Definition Phase, part of Scope Management.
And the development of the WBS to WP level is called ‘Decomposition’.

Develop a Project Master Schedule

A Project Master Schedule shows the calendar time it will take to complete the works.
It shows all activities and major events, like milestones and shows the logical relationship between the Work Breakdown Structure elements (at the most detail level, this will be the Work Packages).

Allocate Budget costs to Each Work Package

The computation of budgeted costs will depend on the financial management systems employed by the ‘Performing Organisation’. However the two principle cost elements are labor and materials.

To assist in estimating labor costs it is usual to devise an Organisational Breakdown Structure (OBS).
Similar to a WBS, the OBS shows the resource and competence groups necessary to complete the works.
At the lowest level, the OBS shows individuals engaged on the project.

By combining the WBS and the OBS we can obtain a good visual overview of the project.
A matrix can be drawn with the WBS along the top and the OBS along the side. At each intersection, detailed plans can be made regarding the tasks and the cost of labor.

Because the project scope has been decomposed to individual Work Packages it is a relatively simple exercise to estimate the cost of materials from Bills of Materials and suppliers quotations.

Overheads

And don’t forget the third major cost – Overhead. These costs include all the activities necessary to support the project. For example, costs of providing transport, communication and even a percentage for Head Office costs.
And don’t forget Project Management Costs.
The way Overheads are allocated to the project will depend on the standard operating procedure of the performing organisation, usually applied as a small percentage added to each Works Package.

Once all that is figured out the total cost for each Work Package can be calculated and frozen.

Very important point:

For cost control within the project, internal to the performing organisation, actual costs to the performing organisation is used.
For reporting to the Customer, customer contract prices are used.

Establish a practical way of measuring the actual work completed

There are many considerations before deciding the criteria to use for measuring the work completed, including type of contract, terms of payment and whether some WP’s are high value and some low value.

The methods adopted to obtain the data must also be cost effective. If the methods are cumbersome, difficult or expensive then find more efficient and cheaper alternatives.

The ‘Rules’ employed to measure the actual work completed must be easy to administer, unambiguous and applicable to all works packages.

Measures could include:

Quantities installed – Physically counting the number of an item installed compared to the planned quantity.

Percent complete – An estimate by the actual persons responsible for completing the Work Package.

Effort by support services – Tasks that cannot be easily allocated to a specific Works Package, like the work by project planners, more a function of time, can be measured by time lapsed compared to planned total time allowed. Similar to adding a simple percentage of cost to each Works Package.

By Milestones – Predefined milestones with predefined estimated work completed percentages. E.g, foundations poured = 15%, walls to first floor level = 10%, all materials delivered = 5%.

Tied to contract terms of payment – Usually related to progress of the works except for the initial down payment.

Two point measurement – Limited to two predefined measurement points. E.g, 50% when all materials on site, 50% on completion of the Works Package.

Single point measurement – In a project where there are numerous small value Work Packages, the measurement point could be 100% on completion only.

Set the performance measurement baseline

We now have the WBS, the OBS, the measuring rules and the budget.

We can now estimate, in monetary terms, how much we plan to spend claim in each time period (weeks or months), over the planned duration of the project.

This estimate is usually in tabular form. Time from left to right across the top. Work Packages from top to bottom along the left. Total planned cost for each period along the bottom.

Then another row for accumulative cost.

We can then draw a graph of time versus planned cost and accumulated actual cost. And this usually looks like the well known ‘S’ Curve.

And if we’re really smart, we would have negotiated with the project’s sponsor, a ‘management reserve’, which could also be included in the graph indicating the absolute maximum budget.

Earned Value Management Examples

We now look at some basic examples to illustrate how Earned Value is used to assess the ‘health’ of a project.

In all examples, as in real life, we are taking a ‘snapshot’ of the project at a single point in time

The baseline in the following table 1 shows the planned progress of tasks for the reporting period, usually from the start of the project up until the ‘snapshot’ is taken.

Table 1
A B C D E F G TOTAL
Planned Cost ($) 20 5 10 20 20 10 15 100
Actual Cost ($) 18 6 10 17 18 10 0 79
Spend Variance 2 -1 0 3 2 0 15 21

 

Comparing the measured (actual) spend with the baseline planned spend is of very little use without some indication of the amount of work done.

Task A is underspending by 2; Are we saving money, or behind schedule. On the other hand, Task B is overspent by 1; are we overbudget or ahead of schedule. While task G hasn’t even started yet; at a guess behind schedule.

Reports to management are usually at a high level, they see an underspend of 21%, congratulate the PM and divert some of the management reserve!

 

Table 2
A B C D E F G TOTAL
Planned Cost ($) 20 5 10 20 20 10 15 100
Actual Cost ($) 18 6 10 17 18 10 0 79
Earned Value ($) 20 5 10 15 17 8 0 75
Cost Variance ($) 2 -1 0 -2 -1 -2 0 -4

 

The earned value compared with the actual cost of doing the work necessary to achieve that earned value provides a measure between planned and actual costs. The difference is called Cost Variance. If the cost variance is negative, more money was spent doing the work than was planned. In the example, Table 2, the earned value of the work complete was 75 but the actual cost of doing the work was 79, a cost variance of 4 or 4/75 = 5.3% negative

 

Table 3
A B C D E F G TOTAL
Planned Cost ($) 20 5 10 20 20 10 15 100
Earned Value ($) 20 5 10 15 17 8 0 75
Schedule Variance 0 0 0 -5 -3 -2 -15 -25

 

Planned value compared with Earned Value measures the volume of the work planned against the work completed.

The difference is called Schedule Variance. If the schedule variance is negative the work is late. in the example Table 3 the Schedule Variance is 25 or 25/100= 25% negative

Earned Value Variance Analysis

Variance analysis and trend projection are two important tools used by the project manager to control projects. Using earned value techniques the project manager can monitor both schedule and cost variances as well as predict trends using Cost Performance Index and the Schedule Performance Index.

Critical Ratio

The astute project manager will also calculate a set of Critical ratios at a selected level of the Work Breakdown Structure. One useful ratio combines the schedule progress versus actual progress with the budgeted cost versus the actual cost.

Critical Ratio = (Actual Progress/Scheduled Progress) X (Budgeted Costs/Actual Costs)

This critical ratio is a good measure of the general health of a project as it combines both schedule and cost in that a poor performance in one is compensated by a good performance in the other.

A critical ratio greater than 1 is good, less than one is bad.

furthermore the project manager should also set control limits on the variances and the critical ratio. If the ratios are outside the limits then corrective action is necessary.

Jeb Riordan 2016