Project Utilization %
—
vs. net available hrs
Hours by Month
Total time logged, split by type
Hours by Client
Project work hours by client group, by month
Hours by Task Type
Work type distribution (excl. leave)
Employee Hours (Total YTD)
All hours per person — project work broken out by client group. Always shows full breakdown regardless of time type filter above.
Project Utilization by Employee
% project utilization = project work hrs ÷ net available hrs (capacity minus vacation & sick).
🟢 ≥85% 🟡 70–84% 🔴 <70%
2026 Costs (Estimated) by Employee
Project work hours × employee bill rate. Overhead and leave hours excluded from cost calculation.
YTD Actual vs. Pace Target — by Employee
Target = net available hrs × 75% project utilization. Green = on/ahead of pace | Red = behind pace.
Project Analytics
Project-level cost, staffing, and activity analysis
Project Health Scorecard
Combines cost, momentum trend (month-over-month hours change), and rework/issue flags from time entry comments. Top 20 projects by cost.
Flagged-for-Review — Executive Summary
Live from tus.time_details_view. Entries are flagged when a comment contains a keyword
from a fixed list (rework, wrong, missing, damage, delay, etc.) — naive scan, expect 10–20% false positives.
Treat numbers as directional, not audit-grade.
Estimated Rework Cost by Project — Top 10
Hours × hand-maintained role rates from EMPLOYEE_RATES. Treat as directional, not invoice-grade.
Flagged-for-Review Trend by Month
Hours (left axis) and estimated cost (right axis) for keyword-flagged entries. Watch the slope.
Root-Cause Categories
Comments bucketed by keyword family — Design, Damage, Missing, Delay, Defect.
Top 10 Employees by Flagged Hours
Who is logging the most flagged time. Coaching signal, not blame — verify before acting.
Flagged Hours by Task Type — Top 10
Which work disciplines surface the most flags — Civil / Drafting / Manufacturing etc.
Repeat-Flag Projects
Projects with flagged hours in 2+ consecutive months — chronic vs one-off pattern.
Budget vs Actual — Hours
From time_wtm_projects.budget_hours joined to YTD time entries by job code. Excludes admin/placeholder rows (DELETE / TBD / TEST / <100 hr) and the 00000/99999 overhead buckets. Sorted by % consumed.
Stale Projects (no entries 14+ days)
Projects with logged hours YTD but nothing in the last 14 days. Sorted by days quiet.
Timesheet Log Lag — Top 10 Slowest
Average days between work date and entry creation. Higher = entries logged after the fact (recall risk).
Flagged-for-Review Log
Live from tus.time_details_view. Entries are surfaced when comments contain any of:
rework, redo, wrong, error, missing, damage, broken, delay, on hold, defect, reject, fail, correction, return from field.
Naive keyword scan — read the comment before drawing conclusions. Click a row header to expand/collapse by project.
Project Cost by Month — Top 10 Projects
Monthly burn curve for the highest-cost projects. Dollars = hours × blended employee rate.
Project Activity Mix — Top 15 Projects
Task breakdown per project. Shows what phase each project is in (construction-heavy, engineering, documentation/closeout).
Staffing & Concentration Risk
Headcount, lead contributor, and single-person dependency flags. 🔴 = one person accounts for ≥70% of project hours.