Skip to content
flowss
Start freeChecking your session
Plot templates

EVM Performance Report — PV / EV / AC S-curve with CPI, SPI and EAC

Monthly earned value management report for a capital scheme: cumulative planned value, earned value and actual cost curves at the data date, with cost variance, schedule variance, CPI, SPI, TCPI and a CPI-based estimate at completion — the ANSI/EIA-748 figure a project controls manager files every period.

PlotProject & PlanningPlot syntax docs
Template previewPlot
Earned value at data date — Northgate WWTW Phase 2 membrane upgrade3 series (line). x from 0 to 12 — Month after contract award. y from 0 to 8000 — Cumulative cost. Series: PV — planned value (BCWS); EV — earned value (BCWP); AC — actual cost (ACWP).Earned value at data date — Northgate WWTW Phase 2 membrane upgradeCumulative £k, control account 3000. Data date: end of month 12 of 24. · 3 series · 36 pointsPV — planned value (BCWS)EV — earned value (BCWP)AC — actual cost (ACWP)036912Month after contract award02000400060008000Cumulative cost (£k)PV — planned value (BCWS)EV — earned value (BCWP)AC — actual cost (ACWP)BAC = £14,400k over 24 months. At the data date EV = £6,210k, so the scheme is 43.1% complete against a plan of 47.9%.CV = EV − AC = 6,210 − 6,900 = −£690k. SV = EV − PV = 6,210 − 6,900 = −£690k.CPI = EV/AC = 0.90. SPI = EV/PV = 0.90. Cumulative CPI has held between 0.90 and 0.91 since month 6, which is why it is used to project the EAC.EAC = BAC/CPI = 14,400/0.90 = £16,000k. VAC = BAC − EAC = −£1,600k. TCPI(EAC) = (BAC−EV)/(EAC−AC) = 8,190/9,100 = 0.90.The composite estimate EAC = AC + (BAC−EV)/(CPI×SPI) gives £17,011k. That is the figure carried in the risk case, not the reported EAC, and the two are not the sameclaim.SV is in money, not time. It says £690k of planned work is undone; it does not say the finish date has moved. The finish date is a schedule question, answered by thenetwork, not by this figure.

Make it your own.

title: Earned value at data date — Northgate WWTW Phase 2 membrane upgrade
subtitle: Cumulative £k, control account 3000. Data date: end of month 12 of 24.
x: Month after contract award
y: Cumulative cost (£k)
x limits: 0 .. 12
y limits: 0 .. 8000
grid: both
legend: right

line "PV — planned value (BCWS)" colour: blue curve: monotone
  1   110
  2   310
  3   610
  4  1020
  5  1530
  6  2120
  7  2790
  8  3510
  9  4270
  10 5060
  11 5970
  12 6900

line "EV — earned value (BCWP)" colour: green curve: monotone
  1   105
  2   295
  3   570
  4   940
  5  1390
  6  1900
  7  2470
  8  3080
  9  3720
  10 4410
  11 5290
  12 6210

line "AC — actual cost (ACWP)" colour: red curve: monotone
  1   120
  2   330
  3   640
  4  1050
  5  1545
  6  2110
  7  2745
  8  3420
  9  4135
  10 4900
  11 5880
  12 6900

note: BAC = £14,400k over 24 months. At the data date EV = £6,210k, so the scheme is 43.1% complete against a plan of 47.9%.
note: CV = EV − AC = 6,210 − 6,900 = −£690k. SV = EV − PV = 6,210 − 6,900 = −£690k.
note: CPI = EV/AC = 0.90. SPI = EV/PV = 0.90. Cumulative CPI has held between 0.90 and 0.91 since month 6, which is why it is used to project the EAC.
note: EAC = BAC/CPI = 14,400/0.90 = £16,000k. VAC = BAC − EAC = −£1,600k. TCPI(EAC) = (BAC−EV)/(EAC−AC) = 8,190/9,100 = 0.90.
note: The composite estimate EAC = AC + (BAC−EV)/(CPI×SPI) gives £17,011k. That is the figure carried in the risk case, not the reported EAC, and the two are not the same claim.
note: SV is in money, not time. It says £690k of planned work is undone; it does not say the finish date has moved. The finish date is a schedule question, answered by the network, not by this figure.