ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMAN
1
2
Construction Project Portfolio Management Dashboard Template Example
https://www.smartsheet.com/try-it?trp=12328&utm_source=template-google-sheet&utm_medium=content&utm_campaign=Construction+Project+Portfolio+Management+Dashboard-google-sheet-12328&lpa=Construction+Project+Portfolio+Management+Dashboard+google-sheet+12328
3
Enter project data below; charts, graphs, and summary info will populate automatically. Shaded cells also will auto-populate.
4
This tab contains example data. To begin building your dashboard, use the BLANK tab. If necessary, enter alternate dropdown menu data in the tables at the bottom of this tab.
5
Portfolio NamePortfolio ManagerTotal ProjectsDate of Last Update
6
Infrastructure and Roads DivisionMarta Hicks1410/21/20XX
7
8
Total BudgetCost VarianceAverage % CompleteProjects on TrackHigh-Risk Projects
9
$4,085,000.00$669,000.007.14%2.00%21.43%
10
11
Portfolio Financing
Project Progress
Risk Radar
12
Budget$4,085,000
13
Actual$3,416,000
14
Balance$669,000
15
16
Project Health Level
Priority Level
Project Strategic Objective
17
18
19
Project Data
20
Project Health LevelPriorityProject IDProject NameStatusProject SummaryProject ManagerBudgetActualBudget Less ActualExpected Date of CompletionNumber of Days RemainingPercent Of Project CompleteRisk LevelAssociated RisksStrategic ObjectiveCost-Benefit Analysis OutcomeCommentsAttachments / Links
21
1HighIT-P12001On HoldOlivia Carter $ 800,000 $ 500,000 $ 300,000 –90%Highly UnlikelyImprove Customer Loyalty
22
2MediumIT-P12002CompletePetrus Nishimura $ 285,000 $ 312,000 $ (27,000)–100%UnlikelyIncrease Customer Value
23
3HighIT-P12003In ProgressRaghu Prakash $ 430,000 $ 384,000 $ 46,000 –50%PossibleIncrease Brand Awareness
24
4ExtremeIT-P12004PlanningOlivia Carter $ 1,624,000 $ 1,500,000 $ 124,000 –8%LikelyExpand Market Reach
25
5ExtremeIT-P12005ApprovedSarah Goodwin $ 946,000 $ 720,000 $ 226,000 –11%LikelyExpand Market Reach
26
4LowIT-P12006ApprovedHenry McNeal $ - $ - $ - –17%Highly LikelyIncrease Revenue
27
4LowIT-P12007ProposedTamika Marshall $ - $ - $ - –20%LikelyGenerate Leads
28
2MediumIT-P12008MonitorVictoria Pearson $ - $ - $ - –30%Highly LikelyIncrease Sales
29
1MediumIT-P12009In ProgressOlivia Carter $ - $ - $ - –45%Highly LikelyModernize Technology
30
4HighIT-P12010RequestedHenry McNeal $ - $ - $ - –0%UnlikelyIncrease Customer Value
31
2HighIT-P12011RequestedRomy Bailey – –0%Highly UnlikelyIncrease Sales
32
3HighIT-P12012MonitorOlivia Carter – –15%UnlikelyImprove Customer Loyalty
33
4ExtremeIT-P12013PlanningRomy Bailey – –20%UnlikelyIncrease Sales
34
5HighIT-P12014In ProgressHenry McNeal – –75%UnlikelyGrow & Innovate
35
36
Dropdown Menu and Chart Data
37
If necessary, enter alternate dropdown menu data in the tables below.
38
Quantity columns calculate automatically to populate Dashboard charts; do not alter.
39
Health LevelHealth
Quantity		Priority
Level		Priority
Quantity		Project
Status		Status
Quantity		Risk
Level		Risk
Quantity		Strategic
Objective		Quantity
40
12Low2Proposed1Highly Unlikely2Improve Customer Loyalty2
41
23Medium3Requested2Unlikely5Modernize Technology1
42
32High6Approved2Possible1Expand Through M&A0
43
45Extreme3Planning2Likely3Grow & Innovate1
44
52In Progress3Highly Likely3Increase Brand Awareness1
45
Complete1Increase Customer Value2
46
On Hold1Expand Market Reach2
47
Monitor2Increase Revenue1
48
Other0Generate Leads1
49
Increase Sales3
50
Other0
51
Other 20
52
Other 30
53
Other 40
54
Other 50
55
Other 60
56
Other 70
57
58
CLICK HERE TO CREATE IN SMARTSHEET
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100