Financial Health & Efficiency
Data Discovery Analysis Summary
Our comprehensive data discovery analysis has revealed 29 key findings spanning 18 opportunities and 11 risks. The assessment identifies substantial potential for operational improvement and strategic value creation.
Key Metrics
Risk Assessment
Found 11 areas requiring attention, including compliance, security, and operational risks that should be addressed.
Key Opportunities
Identified 18 potential opportunities for business improvement across operations, cost optimization, and strategic initiatives.
Business Impact
Estimated business impact score of 112.0 across all findings, indicating significant potential for value creation.
Strategic Recommendations
Prioritize high-impact findings based on business value and implementation feasibility
Establish governance processes for ongoing data quality management
Develop implementation roadmap with clear ownership and timelines
Monitor progress and adjust priorities based on business outcomes
Conclusion
This comprehensive data discovery analysis reveals substantial opportunities for value creation through strategic data management initiatives. Success depends on executive commitment, cross-functional collaboration, and sustained investment in data governance capabilities.
Opportunities
Showing 18 results
Unlock $167–$259M via real estate optimization and office consolidation.
Unlock $1.1B PV over 10 years via coordinated real-estate and facility initiatives.Long-term real-estate portfolio optimization ($1.1B PV over 10 years) represents the largest strategic capital-allocation opportunity. Combines building sales, consolidation, and hybrid-work enablement into a sustainable, multi-year runway extension.
Unlock $1.1B+ in cost savings and revenue via internal initiativesAggregated low-estimate impact from organizational restructuring, real estate optimization, service efficiency, fleet management, and fee adjustments totals $1.1B, exceeding FY25 $146M deficit and reducing external funding dependency.
Reduce real estate fixed costs by $55.5M–$202M via consolidation and asset salesOffice consolidation yields $55.5M PV over 10 years with $1M Year-1 savings; office building sales generate $29.1M PV and $16.3M Year-1 revenue. Combined, this addresses largest fixed-cost lever without impacting service delivery.
Target Police and Transportation (22% of budget) for efficiency benchmarking and reallocationPolice ($2.11B, 11.5%) and Transportation ($1.84B, 10.0%) are only outliers >mean+1σ. Modest YoY growth (Police +1.8%, Transportation +12%) suggests room for efficiency gains. Benchmarking against peer cities could yield 3–5% savings ($55M–$92M).
Accelerate revenue $20M–$252M via fee schedule updates and cost-recovery alignment.FY24 fee base of $518.7M is underutilized; fee adjustments alone could add $20–$252M incrementally. Vehicle Sticker ($118.6M) and Standard Plan Review ($20.6M) demonstrate high-efficiency revenue streams. Outdated fee structures represent immediate, low-effort revenue capture.
Reduce operational spend $63M–$77M via fleet and service optimization initiatives.Fleet initiatives ($12–$23M) plus service optimization ($33–$597M, conservative mid-range $100M+) and organizational restructuring ($148–$257M) form a multi-lever cost-reduction strategy. Fleet right-sizing and pooling are quick wins; broader service optimization offers scaling potential.
Target top 3 departments (58% of spend) for efficiency gains and reallocation.Finance General (44%), Police (11.5%), and Transportation (10%) concentrate budget risk. Finance General's flat growth and Police/Transportation's high absolute spend create opportunities for process re-engineering and shared-service consolidation without broad organizational disruption.
Capture $40M–$252M in FY24 revenue via fee and fine adjustmentsCurrent fees generate $503M FY24 revenue; incremental adjustments to align with peer benchmarks and close recovery gaps could add $40M–$252M. Special events alone show $21M gap between costs and recovery.
Optimize fleet operations to save $12M–$23M annually via utilization and R&MFleet initiatives span utilization ($2.9–$5.8M), repair/maintenance optimization ($5.1–$10.2M), lifecycle modelling ($2.2–$4.4M), and disposition acceleration ($4.4–$6.4M), totaling $12–$23M in recurring savings with 2–3 year payback.
Reallocate $920M (5% of budget) from discretionary to essential servicesDiscretionary spending (Housing, Library, Tech, Culture) accounts for 5.06% of $18.35B FY26 budget (~$920M). Reallocation to high-ROI initiatives or deficit reduction offers immediate flexibility without core service cuts.
Renegotiate vendor contracts; top 5 vendors represent 15% of $109B paymentsVendor concentration (top 5 = 15% of $109B annual payments) creates significant bargaining leverage. Renegotiation, consolidation, or alternative sourcing could yield 5–10% savings ($0.8B–$1.6B) on concentrated spend.
Optimize health insurance via network/PBM renegotiation; potential $15M–$24M savingsEmployee benefit cost-containment via network and pharmacy benefit manager renegotiation can yield $15M–$24M savings, representing largest single-line health insurance opportunity without benefit cuts.
Optimize payment timing to smooth $5B+ monthly spikes and improve cash position.Monthly payments peaked at $5.07B (early 2022) and $5.60B (early 2023), with seasonal clustering. Renegotiating payment terms, staggering vendor settlements, or accelerating receivables collection could reduce peak cash demand without changing underlying economics.
Leverage vendor concentration (top 5 = 15%) to renegotiate contracts and terms.Top 5 vendors receive ~15% of $109.35B in payments, creating meaningful bargaining power. Contract renegotiation, volume discounts, or payment-term optimization could yield 2–5% savings on vendor spend without service degradation.
Consolidate 29 micro-departments (<0.1% spend each) via shared servicesTwenty-nine departments collectively spend ~0.7% of $18.35B total budget. Merging or consolidating these low-impact functions into shared services hubs can reduce overhead and improve coordination with minimal operational disruption.
Smooth cash flow timing; peaks of $5.6B (early 2023) indicate working capital optimization potentialMonthly payment peaks ($5.07B–$5.60B in early 2022–2023) and February 2025 spike ($2.04B) suggest seasonal or batch payment patterns. Optimizing payment cycles and receivables timing could improve cash position by $100M–$300M without changing economics.
Consolidate 29 micro-departments (<0.1% spend) into shared services.Twenty-nine departments collectively represent <0.7% of $18.35B budget. Low fiscal footprint and minimal impact make them ideal candidates for service consolidation, outsourcing, or absorption into larger functions with negligible operational risk.
Risks
Showing 11 results
Special events cost-recovery gap of $21M signals misalignment with fiscal sustainability.Special events cost $32.3M but recover only $7.4M, leaving a $21M structural deficit. Even with reforms ($6.3M–$14.7M additional recovery), the program remains a fiscal drain and undermines cost-recovery strategic priorities.
Special events cost $32.3M but recover only $7.4M; $21M gap signals cost-control failureSpecial events spending far exceeds cost recovery ($32.3M spend vs. $7.4M recovery = $21M gap). Even with reforms ($14.7M incremental recovery), a $6.3M gap remains, contradicting fiscal sustainability priority.
Department of Environment budget jumped 2,085% YoY, flagging control and governance gaps.Environment spending surged from $2.4M to $52.4M, a 2,085% increase. While still a small absolute share (<0.03%), the spike suggests inadequate budget controls, reallocation without oversight, or new programs lacking cost discipline. Requires immediate review.
Organizational restructuring ($148–$257M savings) carries high execution risk and effort.Organizational Analysis projects $148–$257M savings but requires significant governance redesign and restructuring. High effort (4/5), moderate likelihood (3/5), and execution complexity create implementation risk. Savings realization depends on sustained change management.
Dataset lacks cash balance, burn rate, and growth metrics; runway modeling not possible.Critical data gaps prevent calculation of runway, burn efficiency score, or scenario modeling. Without cash position, monthly burn rates, and revenue trends, cannot quantify financial sustainability or validate the urgency of cost-reduction initiatives.
High-estimate scenarios show $1.58B cost overrun; initiatives may widen FY26 gapAggregated high-estimate values from cost-savings and revenue tables yield negative net ($1.58B), indicating that some projects could incur costs exceeding benefits. Without rigorous gate-keeping, initiatives could consume capital without proportional returns.
Department of Environment budget surged 2,085% YoY; control and oversight gaps flaggedEnvironment budget jumped from $2.4M to $52.4M YoY, a 2,085% increase. Relative to its <0.03% budget share, this spike suggests reallocation or new programs lacking controls, creating overspend and audit risk.
Total city burn rose 1.8% FY25–FY26; fixed-cost share grew 0.17 pp despite efficiency goalsAppropriations increased $320M ($18.03B→$18.35B) while fixed-cost share rose from 19.44% to 19.61%. Salary and wage growth outpacing overall spend indicates structural rigidity, limiting flexibility to absorb future shocks.
Budget concentration (top 3 depts = 58%) limits flexibility to respond to shocks.Finance General (44%), Police (11.5%), and Transportation (10%) concentrate budget risk. Policy or operational changes in these areas could cascade across the organization. Limited diversification reduces ability to absorb disruptions or redirect capital dynamically.
35% of payments lack department attribution, obscuring cash flow visibility and control.Null department entries represent $39.15B (35.8% of total $109.35B payments). Missing attribution prevents accurate cash-flow mapping, delays identification of timing mismatches, and complicates cost-reduction targeting. Data quality issue with operational impact.
35% of $109B payments lack department attribution; data quality gaps prevent precise targetingMissing department data on $39.15B (35.8% of payments) prevents accurate cash flow mapping, burn-rate decomposition, and departmental accountability. Limits ability to identify and track cost-reduction initiatives.
Full process
Showing 86 results