3) Test the Schedule of Values with Billing vs. Earned Revenue
Assumptions for January:
- Costs-to-date % (by cost): Mobilization 60%, Sitework 30%, Concrete 10%, others 0%
- Billed % (field progress): Mobilization 65%, Sitework 35%, Concrete 10%, others 0%
These small deltas are common (quantities/milestones vs. cost timing).
A) Baseline SOV (Proportional)
Earned Revenue = (Costs ÷ Budget) × Contract per line (Contract = Baseline CV)
Over/Under = Billing − Earned Revenue
SOV Line |
Budget $ |
Contract (Baseline CV) |
Costs % |
Earned Revenue |
Billed % |
Billing |
Over/(Under) |
Mobilization & GC |
$100,000 |
$110,000 |
60% |
$66,000 |
65% |
$71,500 |
$5,500 |
Sitework |
$100,000 |
$110,000 |
30% |
$33,000 |
35% |
$38,500 |
$5,500 |
Concrete |
$200,000 |
$220,000 |
10% |
$22,000 |
10% |
$22,000 |
$0 |
Structural Steel |
$200,000 |
$220,000 |
0% |
$0 |
0% |
$0 |
$0 |
MEP Rough-in |
$200,000 |
$220,000 |
0% |
$0 |
0% |
$0 |
$0 |
Interiors/Finishes |
$200,000 |
$220,000 |
0% |
$0 |
0% |
$0 |
$0 |
Totals |
$1,000,000 |
$1,100,000 |
|
$121,000 |
|
$132,000 |
$11,000 |
Result: The baseline structure produces positive overbilling of $11,000 because billed progress outpaced cost-based progress on early items.
Note: Over/Under is typically computed on gross billing; retainage affects cash but not the Over/Under calculation.
B) Revised SOV (Ethically Front-Loaded)
Same percentages, but using the Revised CV contracts:
SOV Line |
Budget $ |
Contract (Revised CV) |
Costs % |
Earned Revenue |
Billed % |
Billing |
Over/(Under) |
Mobilization & GC |
$100,000 |
$130,000 |
60% |
$78,000 |
65% |
$84,500 |
$6,500 |
Sitework |
$100,000 |
$130,000 |
30% |
$39,000 |
35% |
$45,500 |
$6,500 |
Concrete |
$200,000 |
$235,000 |
10% |
$23,500 |
10% |
$23,500 |
$0 |
Structural Steel |
$200,000 |
$220,000 |
0% |
$0 |
0% |
$0 |
$0 |
MEP Rough-in |
$200,000 |
$195,000 |
0% |
$0 |
0% |
$0 |
$0 |
Interiors/Finishes |
$200,000 |
$190,000 |
0% |
$0 |
0% |
$0 |
$0 |
Totals |
$1,000,000 |
$1,100,000 |
|
$140,500 |
|
$153,500 |
$13,000 |
Result: With the revised (front-loaded) SOV, the same progress yields $13,000 in overbilling. That extra cushion helps you ride out the 45–60 day AR lag without inflating progress.