|
|
|
|
|
|
|
|
|
|
|
|
CONSTRUCTION PROJECT COST MANAGEMENT DASHBOARD |
|
[Enter Project Name] |
|
|
|
|
|
|
|
|
|
|
|
|
KEY PERFORMANCE INDICATORS |
|
|
|
|
|
|
|
|
|
|
|
|
Total Project
Budget |
Actual Cost to Date |
Cost Perf Index (CPI) |
Schedule Perf Index (SPI) |
% Complete (Earned) |
|
$19,048,500 |
$7,650,000 |
0.54 |
0.86 |
29.9% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
COST BY PHASE |
|
|
|
|
|
|
|
|
|
|
|
|
Phase |
Budget ($) |
Actual ($) |
Variance ($) |
% Spent |
Status |
|
|
|
|
|
1.1 Pre-Construction |
$720,000 |
$620,000 |
$100,000 |
86.1% |
OK |
|
|
|
|
|
1.2 Site Work |
$1,125,000 |
$980,000 |
$145,000 |
87.1% |
OK |
|
|
|
|
|
1.3 Foundations & Structure |
$2,820,000 |
$2,350,000 |
$470,000 |
83.3% |
OK |
|
|
|
|
|
1.4 Building Envelope |
$1,625,000 |
$850,000 |
$775,000 |
52.3% |
OK |
|
|
|
|
|
1.5 MEP Systems |
$3,785,000 |
$1,500,000 |
$2,285,000 |
39.6% |
OK |
|
|
|
|
|
1.6 Interior Finishes |
$1,130,000 |
$420,000 |
$710,000 |
37.2% |
OK |
|
|
|
|
|
1.7 Specialties & Equipment |
$1,245,000 |
$180,000 |
$1,065,000 |
14.5% |
OK |
|
|
|
|
|
1.8 PM & Closeout |
$1,245,000 |
$750,000 |
$495,000 |
60.2% |
OK |
|
|
|
|
|
TOTAL |
$13,695,000 |
$7,650,000 |
$6,045,000 |
55.9% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
CONTINGENCY & CHANGE ORDER STATUS |
|
|
|
|
|
|
|
|
|
|
|
|
Contingency Budget: |
|
$1,867,500 |
|
Approved Change Orders: |
0 |
|
|
|
|
Contingency Used: |
|
$160,000 |
|
Pending Change Orders: |
0 |
|
|
|
|
Contingency Remaining: |
$1,707,500 |
|
CO Total Value: |
|
$0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
QUICK NAVIGATION |
|
|
|
|
|
|
|
|
|
|
|
|
▶ Project Setup |
|
Project details &
assumptions |
|
|
|
|
|
|
|
▶ WBS |
|
Work breakdown structure |
|
|
|
|
|
|
|
▶ Cost Estimation |
|
Detailed cost breakdown |
|
|
|
|
|
|
|
▶ Cost Baseline |
|
Time-phased budget |
|
|
|
|
|
|
|
▶ Actual Costs |
|
Expenditure tracking |
|
|
|
|
|
|
|
|
▶ Variance Analysis |
|
EVM metrics &
analysis |
|
|
|
|
|
|
|
▶ Change Orders |
|
Change order log |
|
|
|
|
|
|
|
|
▶
Contingency Planning |
Risk register &
contingency |
|
|
|
|
|
|
|
▶ Cash Flow |
|
Cash flow projections |
|
|
|
|
|
|
|
▶ Resource Plan |
|
Labor & equipment
plan |
|
|
|
|
|
|
|
▶ Reports |
|
Executive summary report |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Note: All values are dynamically linked to source
sheets. Dashboard updates automatically when source data changes. |
|
|
|
|
|
|
|
|
|
|
|