URC Master Dashboard

URC Master Dashboard
Urban Renovation Company · Executive View
As of —
Source: Pipeline-Report-2026.xlsx Master v2

$50M → $100M Trajectory

3-year goal at 26% required CAGR.

Cycle Time — Running Average

Actual cycle time on completed units, plus elapsed time on active units in flight.
Running Cumulative Avg — Completed Units (2026)
Monthly Avg Cycle Time — Completed
Active Units — Avg Elapsed Days by Region
RegionActive In-FlightAvg Elapsed (days)vs Target (17.4d)

Awarded $ by Region — 2026

Where wins are concentrated.

Pipeline by Region & Division

Stacked by Interiors / Exteriors / Combined.

Active Pipeline — Project Detail

ProjectRegionStatusValueAssignments% Complete

Top 15 Clients — Active Pipeline Value

Where bid value is concentrated by client.

Win Rate Snapshot

2026 YTD across all clients.

Top Clients — Bids & Pipeline Value

ClientActive BidsPipeline ValueAvg Bid% of Total Value

⭐ Top 3 Superintendents

Ranked by Early/On-Time%, then avg cycle, then volume. Min 10 completed units.

⚠️ Bottom 3 Superintendents

Lowest EF% (with late counts and overdue exposure). Min 10 completed units.

2026 Forecast — Totals

Pace and projection summary.

Live Production — Unit Counts

Real-time status across all tracked units.

Forecast vs Actual — Units

YTD unit production compared to the 2026 plan.

Region Breakdown

Project count, forecasted units, and revenue by region.
RegionProjectsUnitsRevenueAvg / Unit

Top Projects by Forecasted Units

Largest 2026 unit-volume projects across all regions.
ProjectRegionUnitsAvg Cost / UnitRevenue

State Breakdown

Status counts and on-time performance by region.
StateCompleteIn-ProgressOn NoticeOverdueRemovedAvg Cycle (d)EF %

⭐ Combined Performance Score

Volume + Speed + Quality blended into a single 0–100 score. Minimum 5 completes to qualify.
Rank Superintendent States Composite Score Volume Speed Quality Complete Avg Cycle EF %

Top Performers — By Single Metric

Superintendents ranked by total completed units and average cycle time. Minimum 5 completes for cycle ranking.
🏆 By Total Units Completed
RankSuperintendentStatesCompleteAvg CycleEF %
⚡ By Avg Cycle Time (Fastest)
RankSuperintendentStatesAvg CycleCompleteEF %

Superintendent Scorecard

Completed unit count and Early-Finish performance.
SuperintendentCompleteIn-ProgressOn NoticeOverdueEarlyOn-TimeLateAvg Cycle (d)EF %

Properties in Production

Top properties ranked by total units (Complete + Active).
PropertyStateClientSuperintendentCompleteActiveOn NoticeOverdue

Active Units in Flight

Every In-Progress, On Notice, and Overdue unit — sorted by urgency.
StatusStatePropertyUnitClientSuperintendentSubcontractorDays RemainingDue Date

⚠️ Risk Highlights — team members with active overdue units, low EF%, or heavy late exposure

Field Team — Superintendent Performance — sorted by EF% (min 5 completes)

Superintendent Region(s) Complete In Flight On Notice Overdue Avg Cycle EF% Risk

Project Manager Load — active + awarded projects

PM Projects Contract $ Late Units Risk

Project Coordinator Load — active + awarded projects

Coordinator Projects Contract $ Clients

Estimator Bid Load — from active pipeline (all open + awarded)

Estimator # Bids $ Pipeline # Awarded $ Awarded Win %
0
Total Active Exterior Projects
0%
Portfolio Avg % Complete
0
Near Completion (≥75%)

Exterior Projects — Progress — % complete from live Smartsheets · refreshes hourly

Project PM Superintendent % Complete Progress Last Updated

Team Member Performance — Exterior Portfolio — project count and portfolio avg % complete by PM and Superintendent

Project Managers
Name # Proj Avg % Progress
Superintendents
Name # Proj Avg % Progress