# Earned value analysis, for the rest of us

Earned value is a powerful tracking and budgeting feature in Project. Despite the slew of intimidating acronyms that defines it (like AC, BCWP, TPI, EV, and the like), it isn’t especially complicated. Earned value helps you answer questions like, “Looking at the amount of work done so far in this project, how much money were we supposed to have spent?” Which then leads to other questions like, "Will we finish on time?"

A simple example    You’re working on a gardening project for 10 homes in a cul-de-sac, and you expect to get the entire project of 10 homes done in 10 months. Further, you need to complete one home’s garden in each month. Let’s walk through some of the details on this project.

• \$10,000 is your total budget for all 10 homes.

• \$1,000 is budgeted for each home, which means you plan to spend \$1,000 per month on the entire project. This includes money spent on plants, tools, and a gardener.

• You ask your account for a report after 2 months have passed. The accountant tells you \$1,500 has been spent on the project so far. You think, “Great, I’m saving money.”

• Then you realize your mistake. After 2 months’ time, 20 percent of the project should have been done, because 2 months is 20 percent of the 10 months that you had originally planned to spend on the project. But only one and a half gardens are actually done, not 2.

• So, after two months, you should have spent 20 percent X \$10,000 (or \$2,000) on the project to get it done on time, and two gardens should be complete—not \$1,500 for one and half gardens. Now you realize you’re actually behind schedule. Yikes! Time to have a talk with the gardener.

Here’s the tricky thing (and great thing) about earned value. It marries time with money because it multiplies currency by scheduled time (or percent complete, in the jargon of professional project managers).

The lesson?    “Time is money,” as the old saying goes. Now, you can’t boast your prowess with earned value quite yet. You need to read on . . .

## Display earned value

Project displays earned value information two ways: with views and with reports. But first you need to do a few things to set up earned value for reporting.

### Using reports

1. Choose Project > Reports > More Reports.

2. Choose Costs, and then choose Earned Value.

Note: In Project 2007, choose Report > Reports > Costs, choose Select, and then choose Earned Value.

### Using views

1. Choose View > Table, then choose More Tables.

2. In the list, select Earned Value, Earned Value Cost Indicators, or Earned Value Schedule Indicators.
If you’re not sure which table, just pick Earned Value.

3. Choose Apply.

## Interpret earned value

Three key values are at the root of earned value analysis, and you pretty much need to know at least these three values to use earned value.

An important theme running through these common earned value terms is the status date. Earned value analysis assumes you want to see the progress on your project prior to a specific point in time that you choose.

Because a picture is worth a thousand words, let’s look at this graphically. Here’s a chart showing a steady accumulation of cost over the lifetime of a project. The dotted line shows a steady expenditure over the lifetime of the project.

After work on the project has begun, a chart of the key values of earned value analysis may look like this.

The status date determines the values Project calculates. The actual cost (AC) of this project has exceeded the budgeted cost. The earned value (EV) reflects the true value of the work performed. In this case, the value of the work performed is less than the amount spent to perform that work.

## Some advice on using earned value

 Do this How Take action soon The earlier in a project's life cycle you identify such discrepancies between actuals costs, budgeted costs, and earned value the sooner you can take steps to remedy the problem. Work harder Easier said than done. The more work you get done before the next status date for determining earned value, the better. Simply hiring more workers may not help, but hiring cheaper workers might. Or you may need to “walk the floor,” to find out why workers aren’t being more productive. Or maybe the problem is with the managers who are providing machinery that needs more maintenance than expected. There could be many reasons, but the point is, using a “numbers approach” with earned value will help you spot negative trends. Work smarter Don’t chase after productivity problems on those tasks that are less important than others. Check tasks on the critical path first for the greatest impact on positive earned value numbers. Re-run your reports An earned value analysis at the end of a project really has little value. The sources of your project’s problems is likely early in it, and will likely have had too much impact to correct without incurring great cost and frustration from your team, manager, and other stakeholders. Get in the habit of running earned value reports monthly, if you’re going to do them at all. Don’t sweat the early stuff If you see problems very early in the project, it could just be ramp-up costs, or the costs of training, getting everyone on-board, abundant but necessary early collaboration with your team, and other housekeeping chores. Don’t ignore these early signs of trouble, but they may be more understandable early in the project than later.