S-Curve Earned Value Tracking: Visual EVM for Construction Projects

An S-curve is a graph that plots cumulative cost, value, or progress against time. In earned value management, it's the single most effective way to show a project board whether you're winning or losing. Forget tables of CPI and SPI figures that make non-commercial eyes glaze over. An S-curve shows the same information in a shape that anyone - project directors, client reps, board members - can read in five seconds.

Why Construction Projects Look Like an S

The shape maps directly to how construction gets delivered.

• Phase 1: Slow start (months 1-3). Mobilising site, chasing design approvals, placing subcontract orders. Money trickles out but physical progress is minimal. On a 24-month programme, you might spend 10% of the budget in the first 20% of the time.
• Phase 2: Steep middle (months 4-18). Subcontractors on site, materials flowing, critical path driven hard. This is where 60-70% of the work happens and the curve climbs steeply. That's what healthy looks like.
• Phase 3: Tapering finish (months 19-24). Commissioning, snagging, handover documentation. The build is essentially done. The curve flattens towards BAC.

If your actual curve doesn't follow this shape, something's wrong - and the shape tells you what. A curve that stays flat through month 6 means mobilisation has stalled. Still climbing steeply at month 22 means scope has grown or the programme has shifted.

The Three Curves You Need to Plot

Planned Value (PV) - The Baseline

PV is your time-phased budget. It answers: "How much work should we have completed by now, in cost terms?" You build it from the Accepted Programme and the cost-loaded schedule. Cumulate those budgets over time and you get the PV curve - your baseline S.

Don't touch it after that. The PV curve gets set at the start and doesn't change unless you formally rebaseline. It's your measuring stick. Move the stick and you've got nothing to measure against.

Earned Value (EV) - What You've Actually Done

EV answers: "How much of the planned work have we actually completed, measured in budget terms?" This is the truth curve. Not how much you've spent - how much you've done. If you've completed 45% of the earthworks package and the budget for earthworks is £1.2M, EV is £540,000. Doesn't matter if you spent £400K or £700K getting there. EV doesn't care about costs. It only cares about physical progress.

Actual Cost (AC) - What You've Spent

How much cash has gone out the door? On its own, useless. You can spend £5M and be ahead of programme or catastrophically behind. AC only becomes meaningful when compared to the other two curves.

Reading the Gaps: Visual Variance Analysis

The gaps between the three curves tell you exactly what's happening - without calculating a single ratio.

Cost Variance - The Vertical Gap Between EV and AC

Pick any point on the time axis. Look at the vertical distance between EV and AC.

• EV above AC = under budget
• AC above EV = over budget - you're spending faster than you're delivering

That gap is your CV in pounds. On a £60M scheme, if EV sits at £28M and AC at £31M, your cost variance is -£3M. You don't need a calculator. The gap tells the story. See the cost and schedule variance guide for the formula breakdown.

Schedule Variance - The Horizontal Gap Between EV and PV

Look at where EV is and trace horizontally back to the PV curve.

• EV above PV = ahead of schedule
• EV below PV = behind schedule - less work done than planned by now

The horizontal distance measured in time tells you roughly how many weeks ahead or behind you are. Show project directors "we're 6 weeks behind on a 24-month programme" as a gap on a chart and they get it instantly. Note: schedule variance in pounds (SV = EV - PV) becomes meaningless near the end of a project - both curves converge on BAC, so SV trends to zero even if you're still late. The horizontal time gap doesn't have this problem.

Worked Example: £35M Water Treatment Plant

Project: £35M water treatment plant upgrade, NEC4 Option C, 50/50 pain/gain share, 18-month programme. Reporting date: Month 9.

On the S-curve, EV sits below both PV and AC. The worst combination - behind programme and over budget.

• CV = EV - AC = -£1,650,000 (over budget)
• SV = EV - PV = -£2,100,000 (behind programme)
• CPI = 17.15 / 18.80 = 0.912
• SPI = 17.15 / 19.25 = 0.89 (89% of planned work delivered)

EAC (CPI-based) = £35M / 0.912 = £38,377,193. A projected overrun of £3.38M. At 50/50 pain share, the contractor carries £1.69M. Plot the EAC line on the S-curve and that gap between BAC and EAC is visible to everyone in the room.

The S-curve also shows that the divergence between AC and EV started around month 5 - when the M&E subcontractor mobilised late and worked overtime to recover. The overspend is concentrated in that package, not systemic. Target the M&E package specifically rather than cutting across the board. For a full 12-month walkthrough, see the construction example.

Banana Curves: The Confidence Envelope

A banana curve is an S-curve with two PV lines instead of one - one based on earliest possible dates and one on latest. The area between them looks like a banana.

A single PV baseline implies false precision. Activities shift, float gets consumed, weather happens. The banana curve shows the realistic envelope: "we should be somewhere between here and here."

How to Build One

1. Early dates curve: Schedule every activity at its earliest start date. Cumulate the costs. Best case.
2. Late dates curve: Schedule every activity at its latest start (consuming all float). Cumulate. Worst case without affecting critical path.
3. Shade the area between them. That's your banana.

If EV falls within the banana, progress is within acceptable bounds. If it drops below the late dates curve, the project has consumed all float and the critical path is likely affected. On the £35M example, if early dates PV at month 9 is £20,800,000 and late dates PV is £17,900,000, the EV of £17,150,000 sits below even the late dates curve - confirming the project isn't just using float, it's consuming it.

Don't use banana curves on every project. They're most useful when the programme has significant float on non-critical paths, when reporting to a board that needs confidence bands, or at early project stages when the PV envelope is widest.

S-Curves vs Tabular Reporting

Use both. The S-curve goes on slide 1 of your monthly report for the 30-second "how are we doing?" conversation. The tables go in the appendix for the commercial deep-dive. The S-curve tells the story. The tables provide the evidence.

Building S-Curves in Excel

Most commercial teams on mid-size projects (under £50M) build S-curves in Excel. Not glamorous, but it works.

1. Set up the time-phased budget. Create a row for each cost element or work package. Columns represent reporting periods. Distribute budget across planned duration - front-load if the bulk of work is early.
2. Create the cumulative PV. Sum each period column to get periodic planned spend, then create a running total. That's your PV curve data.
3. Add EV each period. Assess percentage complete for every package and multiply by budget. Cumulate. Plot.
4. Add AC each period. Pull actual costs from your cost reporting system. Cumulate. Plot.
5. Plot all three on an XY scatter chart with smooth lines. X-axis is time, Y-axis is cumulative value. Three lines: PV (dashed), EV (solid), AC (solid, different colour).

Common Excel Pitfalls

• Using a bar chart instead of a line chart. Bar charts don't show the S-shape or gaps properly. Use an XY scatter with smooth lines.
• Not cumulating the data. Plotting periodic values gives you a bell curve, not an S-curve. Always cumulate.
• Updating the PV line. Once set, leave the baseline alone. Create a separate "forecast" line for the revised projection.

S-Curves for NEC4 Option C Target Cost Monitoring

Under NEC4 Option C, the contractor gets paid Defined Cost plus Fee, but the target cost creates a pain/gain share mechanism. The S-curve makes the commercial position visible - and it's the best tool for explaining pain/gain to people who aren't contract specialists.

On an NEC4 Option C project, your S-curve needs four lines:

1. Target Cost (PV equivalent) - time-phased target, adjusted for implemented compensation events
2. Defined Cost (AC equivalent) - actual Defined Cost to date
3. Earned Value - physical progress measured in target cost terms
4. Projected Final Cost - your EAC forecast line, extending to completion

The gap between the target cost line and the projected final cost line is your projected pain/gain exposure.

Under NEC4, compensation events adjust the target cost. Your PV line steps up each time a CE is implemented. If the Defined Cost line stays below the stepped target, you're in gain share territory. "See that step at month 6? That's the £800K ground conditions CE being implemented. See how actual cost is still below the stepped target? That's £200K of gain share we're protecting." That visual beats any formula table.

Update the S-curve at each NEC4 assessment date (clause 50.1). The data feeds into the earned value report template.

S-Curve Types: Reference Table

Common S-Curve Mistakes

1. Plotting periodic data instead of cumulative. This gives you a bell curve, not an S-curve. The S-shape only appears when you cumulate.
2. Updating the baseline PV curve. Once set, leave it alone. Create a separate "current forecast" line if you want to show the revised plan.
3. Treating the S-curve as the report. The curve is a communication tool, not a contractual document. You still need the underlying data tables and variance analysis.
4. Guessing percentage complete. Your EV curve is only as good as your progress measurement. Use weighted milestones, measured quantities, or consistent earned value rules.
5. Ignoring early warning signs. The divergence between curves always starts small. Monthly updates catch a trend at £150K, not £2M. Quarterly S-curves aren't project controls - they're post-mortems.
6. Using S-curves for schedule analysis near completion. SV in cost terms converges to zero near project end. Use the horizontal time gap or switch to earned schedule (ES) analysis for the final 20%.