Leroy's Flat Files
Sheet L-01

Running a monthly earned-value review on a design contract

Seven steps and a worked example, in plain words.

Project management · 2026-11-17

Once a month, compare the work you planned, the work you finished and what it cost. Done honestly, it tells you in month four what the budget report will not admit until month ten. Here is the review in seven steps, with a worked example.

1. Fix the status date

Use the last day of the billing period, so the review and the invoice describe the same month. Every number below is as of that date.

2. Know your three numbers

  • Planned value (PV): the budget for the work the schedule says should be done by the status date.
  • Earned value (EV): the budget for the work actually done. Each task's budget times its % complete.
  • Actual cost (AC): what the work has cost so far, from timesheets and invoices, on the same rate basis as the budget.

If the budget is at billing rates, AC must be at billing rates too. Mixing cost and billing rates is the most common way a review goes wrong.

3. Set % complete from the work, not the hours

This is the step that makes or breaks the review. "Hours spent divided by hours budgeted" is not % complete; it just makes EV equal AC and hides every problem.

Use rules you can defend to the Owner:

  • Deliverable milestones for design phases: for example, drawings drafted 40%, internal QC 70%, submittal issued 100%.
  • 0/100 for small tasks under a month: nothing until it is done.
  • 50/50 for short tasks that span two periods: half at start, half at finish.

Ask the person doing the work, then check it against what you can see: sheets drawn, sections written, comments addressed.

4. Calculate the measures

Measure Formula Reads as
Schedule variance (SV) EV − PV Work behind (−) or ahead (+), in dollars
Cost variance (CV) EV − AC Over (−) or under (+) budget for the work done
SPI EV ÷ PV Below 1.00 = behind schedule
CPI EV ÷ AC Below 1.00 = each dollar buys less than a dollar of work
Estimate at completion (EAC) BAC ÷ CPI Final cost if efficiency stays where it is
Estimate to complete (ETC) EAC − AC What the rest will cost
Variance at completion (VAC) BAC − EAC Expected overrun (−) or underrun (+)
TCPI (BAC − EV) ÷ (BAC − AC) Efficiency needed on the remaining work to finish on budget

BAC (budget at completion) is your total labor budget.

5. Worked example

A $200,000 design contract, month 6 of 14. The project totals look only a little off:

Task BAC ($) PV ($) % complete EV ($) AC ($) SPI CPI
Preliminary Design (30%) 60,000 60,000 100% 60,000 57,000 1.00 1.05
Final Design (60%) 110,000 25,000 15% 16,500 24,000 0.66 0.69
Permitting 30,000 5,000 15% 4,500 5,000 0.90 0.90
Project 200,000 90,000 81,000 86,000 0.90 0.94

At the project level: SV is −$9,000 and CV is −$5,000. EAC is $200,000 ÷ 0.942 = about $212,300, so VAC is about −$12,300. TCPI is 119,000 ÷ 114,000 = 1.04: the rest of the job has to run 4% better than plan to finish on budget.

The task rows tell the real story. Preliminary Design finished under budget and is covering for Final Design, which is a third behind schedule and spending about $1.45 for every dollar of work earned. That is where to look.

6. Find the cause before the cure

For each task under about 0.95 on SPI or CPI, ask why:

  • Waiting on others. Owner review or agency comments ran long. Not a performance problem, but record it: it may support a schedule extension.
  • Scope growth. The Owner asked for more than the Scope of Services covers. That is a change in services, and the time to raise it is now, not at the end.
  • Estimate was light. The task simply takes more effort than budgeted. Re-plan the remaining work, re-staff, or tell the Owner early.
  • Wrong % complete. Re-check step 3 before you act on a bad number.

7. Record it and act

Write one line per flagged task: cause, action, owner, date. Keep each month's SPI, CPI and EAC so the S-curve shows the trend, not just this month. A CPI that slides from 0.98 to 0.94 to 0.90 over three months says more than any single review.

A review takes about an hour once the habit is set. The hour is cheap next to an overrun found in the last month.

Do this in one tab. The Leroy PM Workbook runs this method with the schedule, staffing, fee and earned value tied together.

See the PM Workbook

← All articles

Get the next file in the drawer

One email when a new tool or article is ready, usually about once a month. Unsubscribe any time.