NCS Executive Dashboard
▾
Overview
Sales
Estimating
Structured Cabling
Audio Visual
Security
DAS
Verticals
Projections
Dream Teams
Insights
Status Tracker
MARCH 2026
Monthly Executive Summary — All Offices & Divisions
March 2026
Proposals by Office — Count & Value ($M)
March 2026
Proposals by Division — Count & Value ($M)
Estimators
Salespeople
VERTICAL MARKETS
Quoted value by vertical market & division
Quoted Value by Vertical Market — March 2026
PIPELINE PROJECTIONS
Projected wins over the next 90 days from active pipeline, using a per-customer weighted close-rate model (see below).
📐 How the 90-day projection is calculated
Every open proposal in each rep's active pipeline is projected as
value × applicable close rate, then summed per rep. The applicable rate depends on proposal size:
- Large proposals (≥ $250K) always use the rep's overall trailing-24-mo close rate. Per-customer streaks don't extrapolate from small fast-turnaround quotes to multi-hundred-K project bids — different decision-makers, more competition, longer cycles. Bedrock conservative.
- Smaller proposals (< $250K) use the (rep, client) pair close rate if the rep has ≥ 4 closed proposals with that client over the trailing 24 months (Approved + Bid Lost only — Cancelled excluded). Otherwise fall back to overall rate.
- Pair rates are dual-capped: never above 2.5× the rep's own overall rate, AND never above 50% absolute. Stops a 4-of-4 streak from projecting 80–100%. No floor — if a pattern is consistent loss, projection reflects it.
- Bluebird ceiling (> $500K): any proposal above this size is capped at 10% close probability, regardless of the rep's overall rate. Whale-sized open bids are great if they happen but mostly won't — this stops a single $2M proposal from carrying the forecast.
Total Active Pipeline
$212.0M
1,944 open proposals
Projected Wins (90 Days)
$25.32M
Blended close rate ~11.9%
Pipeline Proposals
1,944
Open through Apr 2026
Avg Deal Size
$109K
active pipeline
Projected Wins by Division — Next 90 Days
Projected Wins by Office — Next 90 Days
Division Detail
| Division | Open Pipeline | 24-Mo Close Rate | Projected Wins |
|---|---|---|---|
| Structured Cabling | $47.5M | 13.2% | $6.27M |
| Audio Visual | $19.8M | 18.8% | $3.72M |
| Security | $12.3M | 14.4% | $1.78M |
| DAS / Wireless | $7.0M | 1.4% | $0.10M |
Office Detail
| Office | Open Pipeline | 24-Mo Close Rate | Projected Wins |
|---|---|---|---|
| Houston | $60.1M | 19.1% | $11.48M |
| Dallas | $16.9M | 7.0% | $1.19M |
| Corpus Christi | $4.6M | 21.2% | $0.98M |
| RGV / McAllen | $5.0M | 4.5% | $0.23M |
Methodology: Active pipeline includes all open Pending and 90-Day proposals through April 2026. Projected wins apply each division's and office's 12-month dollar close rate to current open quoted value. Houston leads projected wins at $20.97M driven by a 15.3% close rate on $137M pipeline. AV has the strongest divisional close rate at 18.8%, projecting $3.7M from a $19.8M pipeline. DAS pipeline is dominated by one large open quote — treat that projection with caution.
NCS MARKETS
March 2026 — Proposals & quoted value by market
FEBRUARY 2026 · DOT SIZE = QUOTED VOLUME
Houston
219
Proposals
$20.3M
Quoted
15.3%
$ Close
Corpus Christi
69
Proposals
$2.8M
Quoted
14.5%
$ Close
McAllen / RGV
10
Proposals
$0.8M
Quoted
5.4%
$ Close
Dallas
61
Proposals
$4.8M
Quoted
5.6%
$ Close
STRUCTURED CABLING DIVISION
Select market and time period — proposals, close rates & quoted value
HoustonCorpusDallas
12 Months24 Months
12-Month History
Proposals Created vs. Approved
12-Month History
$ Close Rate %
12-Month History
Quoted Value ($M)
AUDIO VISUAL DIVISION
Select market and time period — proposals, close rates & quoted value
HoustonCorpusDallas
12 Months24 Months
12-Month History
Proposals Created vs. Approved
12-Month History
$ Close Rate %
12-Month History
Quoted Value ($M)
SECURITY DIVISION
Select market and time period — proposals, close rates & quoted value
HoustonCorpusDallas
12 Months24 Months
12-Month History
Proposals Created vs. Approved
12-Month History
$ Close Rate %
12-Month History
Quoted Value ($M)
DAS /
WIRELESS DIVISION
WIRELESS DIVISION
Select market and time period — proposals, close rates & quoted value
HoustonDallas
12 Months24 Months
12-Month History
Proposals Created vs. Approved
12-Month History
$ Close Rate %
12-Month History
Quoted Value ($M)
ESTIMATING PERFORMANCE
March 2026 · Proposal Count & Quoted Value · Division Coverage
Sort by:
Top Output
Steady
Slow Month
Top Estimators by Quoted Value — March 2026 ($M)
Top Estimators by Proposal Count — March 2026
SALES PERFORMANCE
2026 Quota Tracking · YTD Won Revenue · 90-Day Pipeline Projections
Sort by:
On Plan ≥90%
Building 75–89%
Needs Work <75%
Team: Won YTD + 90-Day Projection vs. 2026 Quota — by Rep ($M)
Won YTD = Jan–Mar 2026 closed revenue (from D-Tools). 90-day projections use each rep's own 12-month $ close rate × their active pipeline. Company avg close rate: 11.9%. Pipeline: $211.99M.
DREAM TEAMS
Salesperson + Estimator combo analysis — 12-month rolling — minimum 8 proposals together
🏆
Top Performing Combos
Ranked by $ Close Rate (Won Value ÷ Total Quoted)
⚠️
Needs Attention
Lowest $ Close Rate (Won Value ÷ Total Quoted)
WATCH LIST
Ranked data-driven flags — sales, estimating, and company-wide trends
SALES
Rep performance flags
ESTIMATING
Throughput + mix flags
GENERAL TRENDS
Division / office / vertical — historical
STATUS TRACKER
Approved proposals · post-bid execution: shop drawings, product submittals, PM handoff, and tech kickoff. Color ages from white toward red as days at status accumulate.
View
Focus
Div
📐 Color logic — by field
Shop Drawings + OD Submittals
Any in-flight status (Not Started, In Progress, Submitted, Revise & Resubmit) ages on the same scale:
0–9d 10d 20d 30d+ · Approved
Any in-flight status (Not Started, In Progress, Submitted, Revise & Resubmit) ages on the same scale:
0–9d 10d 20d 30d+ · Approved
Handoff (5d aging scale)
Any in-flight status (Not Started, Scheduled, "No") ages on the field's threshold:
0–1d 2d 4d 5d+ · Completed
Kickoff column shows raw status only — no color coding for now.
Any in-flight status (Not Started, Scheduled, "No") ages on the field's threshold:
0–1d 2d 4d 5d+ · Completed
Kickoff column shows raw status only — no color coding for now.
Day 1 note: daily archive started 2026-04-29. Until ~30 days of history accumulate, most cells will read "0d" at baseline color. Real coloring activates as time-in-status data builds. Blank cells stay white (will not age).