Constructelligence
Guide · earned value

Earned value management for construction, explained with one job

Earned value management compares three numbers — what you planned to have done, what you have actually done, and what it cost — to say whether a job is over budget, behind schedule, or both. It sounds academic; for a contractor it is the most reliable early warning there is. Here it is with one job’s numbers.

Updated · 10 minute read

Key takeaways
  • PV = planned, EV = done, AC = spent. Everything else is arithmetic on those three.
  • CPI and SPI below 1.0 mean over budget and behind schedule.
  • TCPI tells you whether the budget is still achievable.
  • Take percent complete from the schedule or quantities — never from cost.

The three numbers

PV · planned valueBudgeted cost of the work scheduled by today
EV · earned valueBudgeted cost of the work actually done = budget × % complete
AC · actual costWhat that work actually cost — from the ledger
Budget at completion (BAC)$3,520,000Estimate at completion (EAC)$4,100,000TodayPlanned value (PV) · 32% scheduled$1,126,400Earned value (EV) · 30% done$1,056,000Actual cost (AC)$1,230,000CPI = EV ÷ AC = 0.86 · SPI = EV ÷ PV = 0.94 · TCPI = 1.08
The worked example. Today’s three numbers are drawn at a larger scale: earned value sits below both what was planned and what was spent — behind and over.

Measuring percent complete: the part that decides everything

Earned value is only as good as the percent complete behind it. Four common methods, from most to least objective:

MethodHowBest for
Units installedInstalled quantity ÷ budgeted quantityRepetitive work — conduit, drywall, pipe, concrete
Weighted milestonesFixed credit per step (e.g. set 20%, connect 50%, test 30%)Equipment and systems with clear steps
Fixed formula0/100 or 50/50 credit when an activity starts and finishesShort activities, a week or two long
Cost-to-costCost to date ÷ forecast total costRevenue recognition — not performance measurement

Cost-to-cost is standard for revenue on the WIP schedule, but it cannot measure cost performance: it makes earned value equal actual cost. Use physical progress for EVM, by cost code or cost type.

Variances and indices

CV = EV − AC    CPI = EV ÷ AC
SV = EV − PV    SPI = EV ÷ PV
EAC = BAC ÷ CPI    ETC = EAC − AC
TCPI = (BAC − EV) ÷ (BAC − AC)

Below 1.0, CPI means over budget and SPI means behind schedule. TCPI is the efficiency the rest of the job must achieve to land on budget — if it is well above the CPI you are running, the budget is not realistic any more.

Note the sign convention: in PMI’s standard, VAC = BAC − EAC, so an overrun is negative. Many contractors (and this site) show overruns as positive; be consistent.

A worked example

Budget at completion (BAC)$3,520,000
Planned value (PV, 32% scheduled)$1,126,400
Earned value (EV, 30% done)$1,056,000
Actual cost (AC)$1,230,000
CPI = EV ÷ AC0.86
SPI = EV ÷ PV0.94
EAC = BAC ÷ CPI$4,100,000
TCPI = (BAC − EV) ÷ (BAC − AC)1.08

This job is over budget (CPI 0.86) and slightly behind (SPI 0.94). To finish on budget the rest of the work would need a CPI of 1.08 — 25% better than it is running. That is not going to happen by itself.

CalculatorEarned value calculator

For more inputs, a second forecast and a shareable link: the full cost overrun calculator →

Where EVM goes wrong on construction jobs

The forecast view in the demo runs CPI-based EAC weekly with a range.

Earned value and the WIP schedule

Most contractors already produce one progress number a month: the percentage of completion on the WIP schedule, which is cost-to-cost. Put the physical percent complete next to it and the gap is itself an early warning. If a job is 40% complete by cost and 32% complete by installed quantities, it has spent eight points of budget it has not earned — the same signal as a CPI of 0.80, available the week the quantities are counted rather than when the budget runs out.

That comparison is what turns a WIP schedule from an accounting report into a forecast. The job cost forecasting guide shows how to carry it forward to a cost at completion.

Checklist
Earned value tracker in Excel, filled in with example rows — columns: Job, Cost type, BAC, Scheduled %, Complete %, PV, EV, AC…
The earned value tracker as it opens in Excel: example rows in italics, calculated columns shaded.
Free template · Earned value tracker (Excel & CSV)An Excel workbook with drop-downs, validation and formulas built in — or the same columns as a CSV for Google Sheets and Numbers.
Download Excel (.xlsx)
What this template captures

Budget at completion with scheduled and actual percent complete, and PV, EV, CPI, SPI, EAC and TCPI calculated from them and actual cost.

12 columns: 6 you fill in and 6 calculated by formula and filled down 200 rows, so nothing is worked out by hand. In the Excel version, 4 columns reject entries of the wrong type (a date column only takes dates, an amount column only numbers), the header row stays frozen with filters on it, and the workbook opens on an Instructions sheet that lists every column below.

Every column, and how it is captured
ColumnTypeWhat goes in it
JobTextJob number exactly as in your accounting system (e.g. J-1104), so rows join to job cost.
Cost typeTextLabor, material, subcontract, equipment or other.
BACAmount ($)Enter the amount in dollars.
Scheduled %PercentEnter a percentage, 0–100.
Complete %PercentEnter a percentage, 0–100.
PVCalculatedCalculated: [BAC] × [Scheduled %] ÷ 100
EVCalculatedCalculated: [BAC] × [Complete %] ÷ 100
ACAmount ($)Enter the amount in dollars.
CPICalculatedCalculated: [EV] ÷ [AC]
SPICalculatedCalculated: [EV] ÷ [PV]
EACCalculatedCalculated: [BAC] ÷ [CPI]
TCPICalculatedCalculated: ([BAC] − [EV]) ÷ ([BAC] − [AC])

See it on real-looking numbers

Constructelligence is a construction intelligence platform: it reads your ERP, project and field systems read-only and does this arithmetic every week, for every job. The demo runs it on a sample eight-job portfolio.

Try the demoJoin the private beta

Frequently asked questions

What is earned value in construction?

Earned value is the budgeted cost of the work actually completed — the budget multiplied by percent complete. Comparing it with actual cost shows cost performance, and with planned value shows schedule performance.

What is the difference between CPI and SPI?

CPI (cost performance index) is earned value divided by actual cost; below 1.0 the job is over budget. SPI (schedule performance index) is earned value divided by planned value; below 1.0 the job is behind schedule.

What is TCPI?

The to-complete performance index is the cost efficiency the remaining work must achieve to finish on budget: (budget at completion − earned value) ÷ (budget at completion − actual cost). A TCPI far above the current CPI means the budget is no longer realistic.

Why shouldn't percent complete come from cost?

Because earned value then equals actual cost, so CPI is always 1.0 and an overrun stays hidden until the budget runs out. Measure percent complete from installed quantities, milestones or the schedule, and keep cost-to-cost for revenue recognition.

How do you calculate EAC with earned value?

The most common formula is budget at completion divided by CPI. Other variants include actual cost plus remaining work at budget rate, or dividing by CPI × SPI when schedule slip also drives cost.

CI
Written by the Constructelligence teamConstruction finance and software. Worked examples use the sample demo portfolio; formulas are standard practice. Reviewed September 2026.

More in Forecasting & cost

Free tools for this topic: Construction cost overrun calculator · Construction labor burden calculator · Construction markup vs margin calculator

All forecasting & cost resources →