Dashboard Executive Scorecard Dashboard

Desciption

Contract
Mix
#Wins
YTD
14
5
9
CM
65%
Est. Revenue
Won YTD
$345,000,000
$225,000,000
$120,000,000
NPS
-2
â–¼-21 vs LY

Dashboard Title: Executive Scorecard
Subtitle: Analyzing Financial, Corporate Risk, Safety, Project, Business Development, and Employee Engagement

Overall Summary: This dashboard provides an overview of the financial, corporate risk, safety, project, business development, and employee engagement performance of an organization. With this dashboard, executives can gain insights into their business, identify areas of improvement, and make informed decisions.

Dashboard Insights:
Analyze financial performance, including cash balance, gross margin YTD, prior month billings, and more.
Monitor corporate risk, including outstanding risk items, bonds, subcontracts, change, aged AP, and aged AR.
Track safety performance, including lost time, near misses, and more.
Monitor project performance, including % complete, schedule risk, fee erosion risk, and more.
Analyze business development performance, including current backlog, win/loss ratio, avg bid E/R %, key markets, and more.
Monitor employee engagement performance, including net promoter scores, win/loss %, IPD, NPS, contract mix, #wins, CM, est. revenue won YTD, and more.

Who Can Benefit: Executives, business owners, and managers can benefit from using this dashboard. With this dashboard, they can gain insights into their business performance and make informed decisions.

Benefits:
Gain insights into financial, corporate risk, safety, project, business development, and employee engagement performance.
Identify areas of improvement and make informed decisions.
Monitor progress and performance over time.
Analyze data and trends to make better decisions.

Data

Construction | Executive Scorecard
Financial
Cash Balance
$2,462,490
Gross Margin YTD
$58,542,131 ER%/10%
LL…
Prior Month Billings
$62,448,145
Corporate Risk
Outstanding Risk Items
(Greater than 30 Days)
Outstanding
Bonds
Unsigned
Subcontracts
Unsigned
Change
$33M
17
$17M
15
$SM
Aged AP
93,210,497
Aged AR
85,334,030
Mirvish+Gehry Toronto
The One
Safety
Safety YTD KPIs
Lost Time
1
Near Misses
7
Project
One Burrard Place
TRIF
Top 3 Jobs for Schedule Risk
Project
F
% Complete
73%
SkyTower
5.3%
26%
MAM
J
Top 3 Jobs for Fee Erosion Risk
%6
Complete
73%
Current Expected
E/R Ratio
0.9%
1435
Medical Aids
4
Schedule Perf
Index
83%
82%
79%
First Aids
9
1.88
Expected
Days Late
72
64
52
S
Change in
Expected Fee
â–¼326,000
787 900
Business Development
Current Backlog
$1,240M
YTD Win/Loss Ratio
35%
YTD Avg Bid E/R %
7.2%
Key Markets
Market
Healthcare
K-12 Education
Warehouse/Distribution
NPS
7
A3 vs LY
Lump Sum
32%
Client
Engagement
Net Promoter Scores
Win Loss %
YTD
53%
42%
62%
IPD
17%
NPS
11
â–²6 vs LY
Employee
Contract
Mix
#Wins
YTD
22
9
15
CM
51%
Est. Revenue
Won YTD
$427,650,000
$259,774,000
$218,850,000
NPS
2
â–¼-18 vs LY
Subcontractor