Lakewood Medical Pavilion

Contract Value: $18.9M | Week 18 of 28 | 63% Complete | Meridian Commercial Builders

Last Updated: Jan 17, 2025 14:30
Portfolio CPI
0.91
-0.07 vs W6
VAC Forecast
-$1.82M
9.6% overrun
Committed Cost
$14.6M
77% of Budget
Contingency Burn
66%
1.05x pace
CO Margin Impact
+2.1%
$394K approved
EV vs Actual Gap
-$1.08M
SCV unfavorable

Budget to Estimated Final Cost Waterfall

CPI Trend by CSI Division

Material Price Variance by Commodity

Cost Code Variance Analysis — Top Deviations

Cost Code Description Budget Committed Actual EAC Variance Status
03-3000 Concrete Formwork $892K $978K $1,082K $1,102K -$210K Critical
23-2100 HVAC Equipment $2,400K $2,494K $1,790K $2,584K -$184K Critical
09-6800 Carpet & Resilient $312K $338K $118K $365K -$53K Monitor
26-2400 Electrical Panels $687K $702K $439K $732K -$45K Monitor
08-1100 Doors & Hardware $428K $446K $312K $459K -$31K Review
07-9200 Joint Sealants $94K $99K $58K $103K -$9K Review
05-5000 Structural Steel $1,245K $1,239K $1,196K $1,248K -$3K On Track
03-3100 Concrete Rebar $564K $558K $541K $559K +$5K On Track

Subcontractor Invoice vs Commitment

Change Order Margin Contribution

Overhead Absorption

87%
Target: 95%

Budget Reforecast Accuracy

92%
Last 3 cycles

Schedule Performance Index

0.96
Baseline: 1.00

Earned Value vs Actual Spend Timeline

EAC Reforecast History

Risk Events Log

Week 14: Formwork Tolerance Failure
Discovered 3" deviation in slab elevation. Required demolition and re-pour. Impact: $210K, 8-day delay.
Code: 03-3000
Week 16: HVAC Equipment Lead Time
Apex Mechanical notified 6-week delay on RTU delivery. Evaluating substitution options.
Code: 23-2100
Week 17: Carpet Price Escalation
Material cost increased 17% since bid due to nylon supply constraints. Evaluating alternate spec.
Code: 09-6800