Many EV professionals would argue that Planned Value is one of the most important metrics in earned value analysis.  It provides the critical benchmark from which numerous other metrics are being compared.
To give you an idea of what PV is, consider the example where you have a $1 million project that is scheduled to take 10 months to complete. An important aspect of project controls is to be able to plan out how that $1m will be spent over the 10 months. It obviously won’t be spent in one single lump. Neither will it be spent in an even, perfectly distributed rate over the 10 months.
Planned Value Trend

The project spend will follow an uneven pattern – loosely following the schedule of activities and purchases that occur over the project’s duration. Planning the budget over the project’s timeline is called Time-Phased Budgeting. Planned Value is the value of scheduled project spend at a point in time of a project’s duration.
Planned value is also referred to as Budgeted Cost of Work Scheduled (BCWS).

Comparing Planned Value against Earned Value and Actual Cost

Calculating Planned Value is dependent on there being a time-phased budget in place for the project. By time-phasing the budget, project controls can determine what the expected budget outlay is planned to be at any point during the project.  Once the project has been underway for two months for example, a PV calculation will tell you how much of that budget was supposed to have been spent by that point in time.  The answer, as I’m sure you’ve guessed, is not 20% of that 10-month project. The calculation has to take into account every item or activity budgeted on the project; and determine when exactly the cost is expected to be incurred for that item or activity, based on its scheduled time of completion or delivery.  Calculating PV therefore, requires a complex algorithm based on what, when and how much for the entire project.  We’ll talk about the details of the calculation further down – what’s important to understand, is that this calculation can determine PV to a precision of a day. In other words, I can pick any date on the calendar and the system will return PV for that day (as long as the date is within the schedule of the project). This is key because PV is being used to compare against Actual Cost and Earned Value to get a picture of the project’s performance and health. In order to obtain an accurate and relevant comparison of these three metrics, they all have to be aligned to a single day. These three metrics tell us the following:

  • Planned Value: The progress that was planned to be completed by this date
  • Earned Value: The actual progress that has been completed at this date
  • Actual Cost: The costs that have been incurred to this date
In an ideal scenario, these three values should be the same – or reasonably close at least.  Calculating actual cost to a single day is relatively straightforward as long as you have up-to-date cost information available to you.  Determining earned value is obviously trickier since it relies on a progress measurement as of a certain date; so it’s typically that progress measurement status date that is used to align these three metrics.
S-curve showing planned value earned value and actual cost
The role of PV is significant in this analysis since, without it, EV and AC are practically meaningless. If they can’t be compared against what was planned, they’re just numbers.

Baseline versus Adjusted PV

Planned Value is of course subject to change over the course of a project’s life. This is a result of scope changes, schedule changes and unplanned productivity issues that result in change orders added to the project. PV for any status date therefore, will adjust according to any approved budget and schedule changes that have occurred on the project.  It’s important however, to ensure that the baseline budget and schedule have been locked and are available as a reference point so that project controls can clearly see the delta between what was originally planned (baseline) and what is currently planned.

Click on the chart to the right to see an example of Baseline compared to the Current, or adjusted, budget and how they play out over time. The red popup displays when you hover your mouse over any of the status points on any of the lines. The Pending, Actual and Forecast lines have been deliberately turned off for this example, but they are also critical for this type of comparative analysis.

Forecast spend showing baseline and current budget and planned value

Schedule Variance and Schedule Performance Indicator (SPI)

Planned value is also used in the calculation of both SV and SPI. As mentioned above, Planned Value relates to the schedule in that budget items & activities are time-phased. Calculating schedule variance is done by simply subtracting Planned Value from Earned Value:

Schedule Variance (SV) = Earned Value (EV) − Planned Value (PV)

This formula is saying, “Take the value of the progress completed to date, and subtract what was planned to have been completed, and that’s the variance in schedule.”  A negative SV means you’ve completed less than expected by this point, so you’re behind schedule. Most project managers like to see SV in the form of a percent:

SV % = Schedule Variance (SV) ⁄ Planned Value (PV)

SPI also uses planned value in its calculation. SPI is a key performance indicator that shows how efficiently time is being utilized on a project. A value of greater than 1 means that your project is running better than planned efficiency – and a value less than 1 means less than planned efficiency.

SPI = Earned Value (EV) ⁄ Planned Value (PV)

 

Calculating Planned Value

PV calculation is a complex algorithm that takes into account all budgetary items & activities, and how their anticipated spend will be incurred over the time-phased planning of each item.  These budgetary items can be a combination of labor hours, materials & equipment costs, third-party expenses, consumables, etc.  Each item will completed or delivered at different points in time – and it’s at that point that PV calculation considers that activity or item as incurring a cost on the project. This isn’t to be confused with cash flow or invoiced costs – this is incurred only.

The PV algorithm essentially tallies up all these elements as of the required status date.

Accounting for Non-Work Days

There is an additional complexity with calculating PV that has to take into account non-work days according to the project work calendar.  Let’s say for example you have an engineering drawing that is estimated to take 10 days to complete. The algorithm can’t just assume that that will be 10 continuous work days. It has to look at weekends, statutory holidays and other non-productive days that may be planned in the scheduled start & end date of that activity.

Can you calculate PV in a spreadsheet?

Organizations that have adopted EVM as a key project analysis and controls methodology will really struggle with calculating planned value without an EVM-ready software solution. It’s generally too complex to calculate using a spreadsheet. Using a dumbed-down calculation in a spreadsheet will deliver only a vague estimation of PV and provide little value. A calculation such as Total Budget (BAC) * Percent Time Elapsed assumes that the project spend will occur in an even linear pattern. And we all know that’s just not true.