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