Falcon Defense & Aerospace
Portfolio Portal · Reporting Period: Jan–Dec 2024
Global filters shown here are for demo context. Drill into a dashboard for interactive filtering.
Portfolio Snapshot — 2024
Headline figures from FACT_CONTRACT_REVENUE and FACT_PROGRAM_BUDGET (Revised baseline). Validated 2026-04-20.
Recognized Revenue 2024
$61,789M
↓ 12.6% vs 2023
Fee Earned 2024
$2,524M
↓ 14.4% vs 2023
Incurred Cost 2024
$63,041M
↓ 12.6% vs 2023
Portfolio CPI 2024
0.97
Target ≥ 1.00
Portfolio SPI 2024
0.95
Target ≥ 1.00
Active Programs
15
All domains covered
Active Suppliers
198
T1·10 T2·16 T3·172
Active Workforce
3,772
89.8% of 4,200
5-Year Trends
Recognized Revenue by Year ($M)
2023 peak · 2024 step-down reflects program cycle shift
2024 Recognized Revenue by Agency ($M)
Top 8 · DoD dominant (97% excl. DHS)
Budget vs Actual by Year ($M, Revised baseline)
Consistent 1.7–2.3% overrun · tight portfolio discipline
Dashboard Directory
Eight dashboards covering Finance, PMO, Supply Chain, and Workforce. Click any card to drill in.
01 · Executive
Executive Overview Ready
Portfolio P&L snapshot, EVM index averages, top programs/agencies, monthly revenue trend, 5-year Compare Years.
02 · PMO
Program Financial Performance Ready
Budget vs Actual vs Forecast by program × cost element (Revised only). Original-Revised baseline shift callout.
03 · PMO
Earned Value Management (CPI/SPI) Ready
Program & contract CPI/SPI with health tiers, monthly trend, top-20 at-risk contracts ranked by CPI.
04 · Finance
Billing vs Incurred Cost Ready
Billed vs Recognized vs Incurred cadence, billing lag, fee realization, FY-end September surge visualization.
05 · Finance
Agency & Program Roll-ups Ready
Revenue by customer agency, program, warfighting domain. Prime vs Mod vs Task Order mix.
06 · Supply Chain
Supply Chain Performance Ready
OTD by tier, first-pass yield, PPV, sole-source concentration, top-20 at-risk suppliers, DCAA coverage.
07 · Workforce
Labor Utilization & Workforce Ready
Direct/indirect hours, utilization trend, clearance-level capacity, classified split, facility headcount vs charge hours.
08 · Business Dev
Contract Portfolio Health Ready
Contract-type mix (FAR Part 16), ceiling-funded-incurred waterfall, period-of-perf expiry radar, set-aside and vehicle mix.
Insight Reports
AutoExplore output — directed exploration of supply chain vulnerabilities. Builds after the 8 dashboards ship.
Evidence Dashboard
Supply Chain Vulnerability Findings Ready
Finding cards with Chart.js evidence for each hypothesis: tier concentration, sole-source, quality gaps, DCAA risk.
Long-form Memo
Supply Chain Risk Memo Ready
Executive narrative with numbered findings, methodology, null results, prioritized recommendations.
Reference
Reference
Metrics & KPI Definitions Ready
Searchable reference for every KPI used across the 8 dashboards — name, definition, formula, unit, which dashboards use it.
Data scope & filters. Dataset covers 2020-01-01 → 2024-12-31 (5 full calendar years). Fiscal calendar: US Federal FY (Oct–Sep). BUDGET_VERSION = 'Revised' is applied to all headline program-budget metrics (grain test confirmed 2× inflation without this filter). Labor and supply dashboards filter to IS_ACTIVE = TRUE on the relevant dimension table. Contract portfolio health uses PERIOD_OF_PERF_END ≥ CURRENT_DATE as the "active contract" definition (DIM_CONTRACT has no IS_ACTIVE flag). All dollar values are nominal USD, displayed in millions ($M) unless noted. This is a demo environment — all classification, agency, and program data is synthetic.