Executive Dashboard
Phase 1 — KPI Scorecard
15 KPIs · monthly view vs prior period
4
of 15
On-Target Summary
4 of 15 KPIs on target
monthly view · compared to prior period
Billed
$4.82M
+6.9% · Off
Cash Flow
$920K
+14.3% · Off
Backlog
$38.40M
+6.1% · Off
15 of 15 showing
Billed
$4.82M
+6.9%target $5.00M
Backlog
$38.40M
+6.1%target $40.00M
Gross Margin
21.8%
+0.8 ptstarget 22.0%
New Contract Sales
$3.05M
+5.2%target $3.00M
Pipeline Adder
$5.60M
+9.8%target $6.00M
Field Hours Worked
41,200 hrs
+2.7%target 42,000 hrs
Gross Profit
$1.05M
+10.9%target $1.10M
Net Profit
$410K
+10.2%target $420K
Net Margin
8.5%
+0.3 ptstarget 9.0%
Cash Flow
$920K
+14.3%target $950K
Cash Flow Adjusted
$850K
+10.4%target $880K
A/R DSO
52 days
-10.3%target 48 days
A/P DPO
38 days
+2.7%target 40 days
Indirect Costs
$384K
+3.8%target $375K
SG&A Costs
$512K
-3.0%target $515K
Billed vs Target
monthly totals — recent 8 periods
Cash Flow Trend
monthly — last 8 periods
Gross & Net Margin
Percentage trend
Backlog Composition
By project type
Healthcare$12.40M
Education$8.90M
Industrial$7.60M
Commercial$5.90M
Government$3.60M
KPI Detail
All metrics with prior, target, and variance
| KPI | Type | Value | Prior | Target | Δ vs Prior | Status |
|---|---|---|---|---|---|---|
| Billed | flow | $4.82M | $4.51M | $5.00M | +6.9% | Off |
| Backlog | stock | $38.40M | $36.20M | $40.00M | +6.1% | Off |
| Gross Margin | ratio | 21.8% | 21.0% | 22.0% | +0.8 pts | Off |
| New Contract Sales | flow | $3.05M | $2.90M | $3.00M | +5.2% | On target |
| Pipeline Adder | flow | $5.60M | $5.10M | $6.00M | +9.8% | Off |
| Field Hours Worked | flow | 41,200 hrs | 40,100 hrs | 42,000 hrs | +2.7% | On target |
| Gross Profit | flow | $1.05M | $947K | $1.10M | +10.9% | Off |
| Net Profit | flow | $410K | $372K | $420K | +10.2% | Off |
| Net Margin | ratio | 8.5% | 8.2% | 9.0% | +0.3 pts | Off |
| Cash Flow | flow | $920K | $805K | $950K | +14.3% | Off |
| Cash Flow Adjusted | flow | $850K | $770K | $880K | +10.4% | Off |
| A/R DSO | stock | 52 days | 58 days | 48 days | -10.3% | Off |
| A/P DPO | stock | 38 days | 37 days | 40 days | +2.7% | On target |
| Indirect Costs | flow | $384K | $370K | $375K | +3.8% | Off |
| SG&A Costs | flow | $512K | $528K | $515K | -3.0% | On target |