Employee Utilization Dashboard

Role-Level Capacity Forecasting & Demand Matching

Meridian Technology Partners • 280 FTEs • Next 90 Days Forecast
Firm-Wide Coverage Ratio
0.87
-16% vs 10 weeks ago
Critical Roles
3
Below 0.80 coverage
Pipeline Demand (90d)
18.2K
hours weighted
Skills Gap Index
6.8
↑ 2.1 pts (high)
Contractor Dependency
22%
Cloud practice
Overtime Concentration
3.2
Top 15% carry load
Schedule Confidence
74%
Medium risk

Roles Below 0.80 Coverage Threshold

Senior Cloud Engineer
0.64
Gap: 920h
CRITICAL
ML/AI Specialist
0.71
Gap: 580h
CRITICAL
Cybersecurity Analyst
0.78
Gap: 340h
WATCH

Pipeline-Weighted Demand Hours by Role (Next 90 Days)

Role Demand Coverage Ratio Trend

Skills Gap Index by Competency

Cloud Architecture (AWS/Azure) 8.4
Machine Learning Engineering 7.2
Security Operations (SOC) 6.1
DevOps/Platform Engineering 5.3
Full-Stack Development 3.8

Hire Lead Time vs. Gap Runway by Role

Action Required: Senior Cloud Engineer and ML/AI Specialist hire lead times exceed available runway. Initiate requisitions immediately or engage contract resources within 2 weeks.

90-Day Capacity Heatmap by Role & Week

W1
W2
W3
W4
W5
W6
W7
W8
W9
W10
W11
W12
Sr Cloud Engineer
0.62
0.61
0.58
0.64
0.67
0.73
0.71
0.75
0.82
0.88
0.94
1.02
ML/AI Specialist
0.68
0.71
0.74
0.72
0.76
0.81
0.85
0.91
0.96
1.04
1.08
1.12
Cybersecurity Analyst
0.75
0.78
0.82
0.84
0.87
0.91
0.93
0.96
0.98
1.02
1.05
1.08
DevOps Engineer
0.92
0.95
0.94
0.97
1.01
1.04
1.06
1.09
1.12
1.15
1.18
1.21
Full-Stack Developer
1.08
1.11
1.14
1.12
1.16
1.19
1.22
1.24
1.27
1.29
1.32
1.35
< 0.70
0.70–0.79
0.80–0.89
≥ 0.90

Scenario Comparison: 90-Day Coverage by Strategy

Scenario Sr Cloud Eng ML/AI Spec Cyber Analyst Avg Coverage Cost Impact Risk
Status Quo (No Action) 0.64 0.71 0.78 0.87 $0 High
Hire 2 Sr Cloud + 1 ML/AI (12 wks) 0.94 0.96 0.91 1.04 +$420K Low
Contract Staff (4 wks) 0.86 0.84 0.91 0.96 +$580K Medium
Hybrid: 1 Hire + 2 Contract 0.92 0.91 0.93 1.02 +$490K Low
✓ Recommended 0.94 0.96 0.91 1.04 +$420K Low

Role Planning Details (Next 90 Days)

Role Current FTE Demand (hrs) Coverage Gap (hrs) Hire Lead Runway Action
Senior Cloud Engineer 18 2,820 0.64 -920 14 wks 6 wks Open 2 reqs immediately
ML/AI Specialist 9 1,260 0.71 -580 16 wks 8 wks Open 1 req + contract
Cybersecurity Analyst 12 1,540 0.78 -340 10 wks 11 wks Monitor + internal transfer
DevOps Engineer 22 2,090 0.95 +110 12 wks — No action
Full-Stack Developer 48 4,230 1.14 +590 8 wks — Deploy to other roles
Data Engineer 15 1,380 1.09 +120 11 wks — No action
Solutions Architect 14 1,260 1.11 +140 13 wks — No action
Project Manager 26 2,340 1.11 +260 9 wks — No action