Skip to main content

Linking Earned Value to Schedule Analysis

Earned Value (EV) has grown in popularity over the last several years. With over 75% of projects failing, project management and control systems must be utilized to ensure project success.  The purpose of this article is to outline a simplified approach to understanding earned value.  Earned value shows a “three dimensional” view of project progress. Earned value is an early indicator and forecaster of project progress. We’ll examine how earned value links to the work breakdown structure, the schedule, and the budget.  You will see the potential for implementing earned value on your projects –  starting now!



 

To fully understand earned value we must understand how the values are developed.  Let’s start with the Work Breakdown Structure (WBS).  By definition the WBS is “a deliverable-oriented grouping of project elements that organize and define the total scope of the project”.  This in its most basic use is a list of all the tasks or activities that must be accomplished to deliver the project.  A properly developed WBS is dissected into parts that represent a unit of work.   Through the years the infamous “80-hour” rule has been handed down from generation to generation of project managers.  I have even heard project managers that keep the unit of work down to 40 hours.  Why is this?  When you try to assess how you’re doing – looking at 40 or 80 hours is much easier to assess than two months of work.  If you can make better assessments of activity progress you will increase the accuracy of your reporting.

 

How far do you break down a task?  I always say, “to the level that makes sense”. For customer reporting you would go to a different level of detail than you would for management, and yet again a different level of detail for the employee who will do the work.  The objective should be to break the work into parts that can be measured and identified that they are completed, and have not exceed 80 hours.  Using common sense is best when determining this.  Remember the WBS is a tool to help manage your project, it is not a tool to micro manage.

 

The lowest level that you dissect the WBS to is the “work package”. By definition the work package is “a deliverable at the lowest level of the WBS”. These are the activities that duration and costs will be assigned to. Once again, remember not to exceed the

80-hour rule. 

 

Now that a WBS has been developed we can estimate the time and cost for each activity.  Let’s assess what we have so far.  We have a WBS that consists of the project, its deliverables, tasks, and activities.  

 

What else do you have? You can look to contracts, statements of work, requirements, and other organizational representatives that may have been involved in the development of the project plans (or whatever you may call them at this point).  You also have subject matter experts and those that will do the work.  Please tell me they are included! They have valuable inputs and need to be factored into the estimating process.  You also may have access to project records of similar projects.  If you do not, start archiving project records.  This will help you to develop best practices as you develop in your organizations project management maturity.

Time estimating is your next step in this process.  We have a very rough estimate that the work package can be done in less than 80 hours.  Possibly there is a need for a more detailed WBS for the technical teams that will work on specific parts of the project.  As you analyze each work package or activity, consider the time it would take under normal conditions, optimal conditions, and worst-case conditions.  Estimates should be realistic, and there are many tools that can be used to minimize that risk that a project might run late.

 

When looking at tasks in a project, a strategic planning session should occur to determine task sequence.  Think of this as a game of chess.  Analyze the best sequence for the project tasks.  This is a powerful use for the post-it note.  They can be placed and moved at will.  Once all the tasks have been laid out they can be placed into a scheduling software tool of choice.  Remember, the software is a tool to help you with reporting; it is not project management.  This is no more than saying that using a word processor makes someone an author.  Understanding the skills and tools to manage projects is what makes you a project manager.

 

While estimating task duration all resources should be considered.  Then all direct and (don’t forget) indirect cost can be computed.  Remember the factoring of project duration when considering costs.  This will assist you in determining a reasonable and acceptable budget that you can manage your projects to.

 

Now that you have a schedule and a budget, you can determine the rate of spending.  This is a time-distributed budget that is “the cumulative cost curve”.  This spending curve is developed based on the planned schedule. The schedule indicates when the tasks occur and the tasks have a cost associated with them.  Now is when the 80-hour rule will become important.  With the tasks being dissected to less than 80 hours, the validity of measuring the task to determine project progress is enhanced. 

 

Key Earned Value measures are:

            Budget at Completion (BAC)

            Earned Value (EV)

            Planned Value (PV)

            Actual Costs (AC)

 

The cumulative cost curve can be used to develop the EV values.  The entire project value is the budget at completion (BAC).  Specific points along the curve are called planned value (PV).  When you decide the appropriate point to measure your project progress (this could be weekly, monthly, quarterly, or any divisible factor) you can look at your cumulative cost curve and determine  what should be done to that point in time and how much it should cost. 

 

When monitoring project progress the schedule can be utilized to determine what work has been done.  If 80 percent of the scheduled work is completed (again aren’t you glad tasks are broken down to less than 80 hours?) then the value for that work is 80 percent of the cost (PV) given for that portion of the work.  Here is an example; through one month we had tasks totaling $100,000, this would be the PV.  When we measured the work completed we determine that only 80 percent is done.  This results in an EV of $80,000.  

 

Next we can determine the money spent to complete the work accomplished.  This is referred to as actual costs (AC).  Based on the previous example we might assume that the work accomplished is $80,000, but after all check is cleared we might have spent $85,000.  Thus our actual cost for the $80,000 worth of work was $85,000. 

 

What does this all mean? You have a tool that provides a three dimensional view of the project.  Typical project variance has been determined by looking at the difference between the planned and the actuals.  Earned value lets you look at the planned values (PV), actual expenditures (AC), and the actual work completed (EV). 

 

The previous example showed us that we have a schedule variance of negative $20,000.  This is calculated by subtracting the PV of $100,000 from the EV of $80,000.  This identifies that we did not do all of the work we said that we would ($100,000).  We are behind the planned schedule.  We can also determine a rate of efficiency by dividing EV by the PV.  This results in a schedule performance index of .80.

 

Also, the previous example showed us that we have a cost variance of negative $5,000.  This is calculated by subtracting the AC of $85,000 from the EV of $80,000.  This identifies that the work accomplished did not cost what we estimated the work to cost.  We have gone $5,000 over budget.  We can also determine a rate of efficiency of spending by dividing EV by the AC.  This results in a cost performance index of .94.

 

For effective project management, identifying the acceptable variance is a must. What if the acceptable variance is 10%?  We can determine that our budget estimating is acceptable.  But we also can see that our schedule variance is unacceptable.  We had better data for the cost of work than we did for the time to do the work.  This is what we need to manage to.  We can now better control our projects.

 

We can also predict where our project cost will end up.  There are several estimates at completion (EAC) formulas.  These formulas can be used to determine the upper estimates and the lower estimates.  By dividing the BAC by the CPI we can get a center estimate.  If our BAC for this project is $1.5M, we can assume that with a cost performance index at .94 we will have an EAC of $1,595,744. If we subtract this value from the BAC we can determine the Variance at Completion (VAC) as -$95,744.  Remember what I said about acceptable variance?  If we have an acceptable variance of 10%, we would be within tolerance ranges. 

 

What does this all mean? We have a tool, EV, which allows us to identify how much we should spend based on how much work we said we would do.  But as all plans go, these are subject to change. We must determine acceptable ranges of variation when we first plan our project.  How does an organization determine an acceptable variance range?  First determine the level of difficulty for the project. Second determine the level of experience of those working on the project. Last determine how the organization assesses variance.  I have seen organizations set variance level as; +/- 10%, +/- 25%, +/- 50%, +10/-5%, +25%, -10%,  and +75/-25.  The different ranges should be articulated in the beginning and should be based upon the level of confidence that you can assign to your estimating efforts.

 

What have we learned? Earned Value is a control and monitoring system used to assess project performance.  You can measure schedule progress, task progress, and cost progress.  EV can be used to predict project performance and determine where the project will end up.  Corrective actions can be taken to possibly put the project back on track or to stay within acceptable tolerance.  We have identified that the values we use in EV are based on the WBS, schedule, estimates, and cumulative costs.  Connecting these aspects will make EV an easy and valuable tool.  Go ahead give it a try!

 

 

Wayne Brantley , MS Ed, PMP, CRP, CPLP is the Senior Director of Professional Education for the Villanova University (www.VillanovaU.com). Wayne has taught and consulted project management, quality management, leadership, curriculum development, Internet course development, and return on investment around the world to Fortune 500 companies. He has over 26 years experience from the Air Force as a project manager for AF technology training and curriculum development programs. Wayne has developed numerous AF and corporate training programs, classroom, multimedia, and Internet based programs. A dynamic presenter and trainer, he has spoken at numerous conferences such as; the Project Management Institute (PMI®), the International Society for Performance Improvement (ISPI), and the American Society of Training and Development (ASTD) annual conferences. He is a doctoral candidate with Nova Southeastern University specializing in Computer Information Technology. University.

Seven Reasons to Take a Look at Microsoft Project 2007

So you’re perfectly happy with Microsoft Project 2003 and you can’t think of any good reason to splurge on an upgrade to Microsoft Project 2007. You may want to give it a little more thought because, according to Special Edition: Using Microsoft Project 2007 (ISBN 0-7897-3652-7) by QuantumPM, LLC (Que Publishing), there are seven new features that might make Microsoft Project 2007 worth your money:

 

Multiple Undo – The Multiple Undo feature is one of the most exciting additions to Microsoft Project 2007. It allows you to backtrack through recent changes or undo the most recent series of changes at once.

 

Change Highlighting – When you make a change to a project, the Change Highlighting      feature calls your attention to all fields affected by the change. Project managers can now see the impact of the change as it ripples through the tasks in the project.

 

Visual Reports – Reports have always been an excellent way to examine and share data in Project. New to 2007 are visual reports, which display project information in visual charts, tables or diagrams.

 

Task Drivers – The Task Drivers feature opens a pane on the left side of the screen that displays information that impacts, or drives, the selected task.

 

Cost Resource Type – The cost resource type enables users to identify specific fixed costs on a task, such as travel expenses or delivery charges for materials.

 

Budget Resource – The budget resource feature allows the project manager to define budget at the summary-level task to represent capital budget or overall approved budget for the project

 

3-D Gantt Chart Display – Three-dimensional display of the taskbars in the Gantt Chart view makes the Gantt Chart view more visually appealing and eye-catching, especially when printed to show as a report.

David Barrett’s Blog: The Show is Over!

ProjectWorld * BusinessAnalystWorld Toronto 2007 is over.
This is the largest event if the year that I am involved in… by far. 2700 delegates five days – 3300 bodies all in when you count the speakers, trainers, exhibitors, my wife and my daughter…

_
It’s a huge effort by everyone involved – and well worth every ounce of effort. I often complain about the stress leading into it, the exhaustion during the event and the endless catch up afterwards but I wouldn’t change it for the world.

Highlights? The workshops – 39 of them – all filled almost to capacity. The track sessions seemed to go well- we’ll wait to see the evaluations. The keynote got pretty good reviews. The food was alright – considering we had to feed as many as 1500 on any one day.

The opening conference reception on Tuesday night was fabulous. We all had fun. The delegates loved it – especially the ones who were just there for the workshop on Monday and Tuesday.

The disappointments? The biggest let down was the formal roundtable discussions on Thursday morning. I blew it! This was a new event for the Toronto conference. We’ve been doing this session instead of a second keynote at all of our smaller regional events: Boston, Chicago, Washington DC, Montreal and Vancouver.

If I had spent a few minutes in front of the 1400 delegates on Wednesday morning explaining what it was all about – how it worked and how great it would be – it would have been fine. But I didn’t. I never even mentioned it in my opening comments to delegates. What a mistake!

So Thursday morning rolls around and only 400 of the 1200 potential delegates show up. They loved it! But I was so disappointed the other others took a pass.

My biggest challenge will be the choice to run them again next year or not.

New ideas? I had a few great ideas come my way via delegates during the conference. One of them – Saturday/Sunday workshops for the billable consultants out there who cannot afford the loss of billable days. Interesting.

So – now we do the post mortem, record our ideas for next year, tabulate the evaluations and move onto the next show. Washington in April, Montreal in May, Minneapolis, Houston and Atlanta in June and Sydney/Melbourne in August … I am stressed already.

David Barrett’s Weekly Blog: What a Ride!

ImageI got involved in this business of project management nearly 12 years ago. Quite a good story some tell me. But I think what amazes me still today is how this business has grown.

 

Many said back then that it was just a ‘wave’. Some of the ‘older’ PMs, the ones who were there already, suggested that the boom was just a fad. They could be heard saying that technology projects were not large enough nor important enough to warrant a seat in the professional world of project management.

 

Man, were they wrong.

But very interestingly, while the ‘boom’ in interest in project management has come from the technology sectors over the past 10 years, I am seeing a renewed interest in formal project management from the more traditional sectors: engineering, construction and aerospace. It’s almost like they woke up over the past year and said “maybe we were wrong to stop learning about project management. Maybe we don’t know it all.”

And then as our classrooms and conference isles site more of this more established set, we see a whole new crowd of ‘kids’ take a major interest in project management. I write this as I fly home from Vancouver – the home of over 10,000 employees working in the Gaming industry. Video games. And guess how old this group is? Young. Very young. This groups looks on the 30 something crowd of PMs as old, established and traditional.

So what am I getting at? I think that the most fascinating part of this business over the next 10 year will be the growth – from all sectors, the hand off from the old to the young and the challenge we will all have to address the needs of all of these communities.

David Barrett