Earned value formula sheet
What do you need on the your earned value formula sheet?
Earned value management is an important component of managing any project, especially for projects in industries like construction and oil and gas, where projects stem for long periods of time and have hundreds of interdependent pieces, and internal and external forces.
Getting your earned value calculations right and tracking earned value accurately gives project managers and companies more insights into performance as the project progress, and more power to effect the project on a cost and schedule basis.
The reason for seeking out and using an earned value formula sheet is to understand and use all of the critical earned value formulas.
Calculating the different components of earned value requires a number of different formulas, which are used to paint a full and comprehensive picture of project health.
Almost all projects can benefit from most of the formulas on this earned value formula sheet, while others will just reference a few.
The earned value formula sheet
Planned value (PV):
Earned value (EV):
Actual cost (AC):
Schedule variance (SV):
Cost variance (CV):
Schedule performance index (SPI):
Budget at completion (BAC):
Estimate at completion (EAC):
Variance at completion (VAC):
Estimate to complete (ETC):
If you would like more detail about these formulas, as well as some examples of how they are used to actually calculate EV, click here.
How and when to use an earned value formula sheet
How often you need to reference an earned value formula sheet will depend on how you calculate and use earned value.
For some companies, their earned value formulas are embedded into the excel sheets they use to calculate earned value, for other companies, their earned value calculations are automated and derived straight from dedicated software systems.
If you calculate earned value manually, then you will likely need to reference this or another earned value formula sheet on a regular basis.
People in 100+ countries use this software to better track and calculate earned value.