M

L1: Management Dashboard

Executive Portfolio Overview

Portfolio Profit Margin

13.8%

Target: 15.0%

โ–ผ 8% variance

YoY change

+2.3 pts

Revenue Forecast

+5.4%

Efficiency Score

91%

WARNING

Portfolio margin at 13.8% is tracking 1.2% below target. Monitor 4 at-risk projects to prevent further erosion.

Project Status

On Track
9
At Risk
4
Critical
2

Total Projects

15

Total Revenue

$4,200,000

Target: $5,000,000-16% variance-20%

Total Costs

$3,620,400

Target: $4,250,000-14.8% variance-19.9%

Active Projects

15

Target: 20-25% variance+2%

Bid Win Rate

18.0%

Target: 22.0%-18.2% variance+3.2%

Trend Analysis

Revenue vs Costs

Revenue by Service

Masonry

$2.1M

50%

Concrete

$1.3M

30%

Caulking

$630K

15%

Other

$210K

5%

New vs Existing Clients

New Clients

4

$200K (5%)

Existing Clients

10 avg

$4.0M (95%)

Cashflow & Risk Score

Current Cash Position

$475K

-3.1% from last month
Risk Score

68

Moderate
-2 from last month

Project Health Matrix

StatusProjectPMCPISPIMarginPrimary IssueActions
๐Ÿ”ด
Heritage Plaza

Brookfield Properties

Sarah Chen0.870.856.2%
Cost overrun detected
๐Ÿ”ด
Riverside Tower

Oxford Properties

Mike Johnson0.920.828.5%
Schedule slippage
๐ŸŸก
Ottawa Commons

Cadillac Fairview

Sarah Chen0.970.9412.8%
Performance issues
๐ŸŸก
Lakeshore Complex

OMERS Realty

Mike Johnson0.940.9512.6%
Performance issues
๐ŸŸกDavid Park0.960.9513.1%
Performance issues
Page 1 of 3

Priority Alerts

S3/S4 Only
5 unread
๐Ÿ”ดS4
--

Labour costs 29% over budget

Heritage Plaza

Labour category has exceeded budget by $13,000. Current EAC shows $58,000 against $45,000 budget. Primary driver: Overtime hours due to schedule compression. Immediate intervention required to prevent further cost escalation.

Impact: $13K

๐Ÿ”ดS4
--

Safety certification expiring in 3 days

Heritage Plaza

Working at Heights certification for 3 crew members expires January 17. Work cannot proceed without valid certifications. Schedule recertification immediately or reassign certified workers.

Impact: $5K

Supporting Metrics

Days Sales Outstanding
45 days
Target: 45 days2%
Crew Utilization
82%
Target: 85%+3%
Safety Rate (TRIR)
0.5
Target: 20.2%
YoY Revenue Growth
+8.5%
Target: 10%+1.5%