Executive Overview
Consolidated performance · FY25 Period 08 (August) · Updated 2 minutes ago
Revenue · EBITDA · Forecast
AI Executive Narrative
Renewable Energy margin slipped 280 bps QoQ as subcontractor costs outpaced billable utilization. Recommend tightening staffing and accelerating change-order recovery on Helios Solar Phase II.
Conversion lag concentrated in two infrastructure programs. Automating WIP-to-invoice handoff is projected to release ~$1.24M of working capital within 60 days.
Reconciliation copilot has reduced WD+5 effort by 36% MoM. Duplicate expense detection caught $48K in the last close.
Pipeline conversion is trailing forecast by 6.8%. Two enterprise utility deals are slipping into Q1; revise Q4 EBITDA guidance by ~$0.4M.
EBITDA Bridge · FY24 → FY25
Business Unit Performance
| Unit | Revenue | Margin | Status |
|---|---|---|---|
| Infrastructure | $28.4M | 22.4% | |
| Engineering Consulting | $19.2M | 18.1% | |
| Renewable Energy | $12.8M | 14.6% | |
| Substation Design | $9.4M | 26.3% | |
| Construction Mgmt | $7.8M | 11.2% | |
| Advisory | $4.1M | 31.8% |
A/R Aging Waterfall
Utilization by Department
Expense Mix
Source Documents Powering This View
| Code | Dataset | System of Record | Source Document |
|---|---|---|---|
| General Ledger | QuickBooks Online (per Aug Close Pack) | ||
| Accounts Receivable Aging | QuickBooks Online (per Aug Close Pack) | ||
| Accounts Payable Aging | QuickBooks Online (per Aug Close Pack) | ||
| Bank Statements & Recon | QuickBooks / Bank (per Aug Close Pack) | ||
| Project Cost & Margin | Deltek Vision | ||
| Time Capture & Utilization | Deltek Vision | ||
| WIP / Unbilled A/R | Deltek Vision | ||
| Payroll Register | ADP Workforce Now | ||
| Subcontractor Commitments | Project Accounting | ||
| Pipeline & Backlog | Salesforce CRM | ||
| Forecast / North Star | Finance (YMC North Star Plan) | ||
| YMC AI Copilot | AI Intelligence Layer |
Every figure on this page traces back to one of the source documents above. Hover any SRC tag on a panel or KPI to view the originating system and file. Source codes are stable and survive system migrations — only the registry mapping changes.