← All analytics projects

Power BI companion layout target; not a hosted report.
06
Project 06 · FP&A, variance & scenario planning
Financial Planning & Variance
Reconcile a real operating budget, investigate Q3 pacing, and test revenue, cost, and hiring scenarios.
FP&AExcelBudget vs actual
Annual budget$8.1B
Expenditures to date$6.0B
Utilization74.3%Through Q3 · 75% elapsed
Pace variance$-55.2MActual minus straight-line expectation
Above-pace departments640 departments reviewed
Public-finance explorer
Filter the reviewed planning mart
The 75% Q3 benchmark is a pacing reference, not an accounting forecast.
Department and fund filters
Filtered budget$8.1B
Expenditures$6.0B
Utilization74.3%
Pace variance$-55.2M
Largest absolute pace variances · 100 of 1,366 shown
| Department | Fund | Program | Budget | Spent | Utilization | Pace |
|---|---|---|---|---|---|---|
| General Obligation Debt Service | General Obligation Debt Service Fund | Transfers and Other Requirements | $281.5M | $77.0M | 27.4% | Below pace |
| Aviation | Airport Operating Fund | Transfers, Debt Service, and Other Requirements | $238.3M | $71.6M | 30.1% | Below pace |
| Nondepartmental | Hotel Occupancy Tax Fund | Transfers, Debt Service, and Other Requirements | $167.3M | $172.3M | 103.0% | Above pace |
| Enterprise Debt Service | AWU Debt Service Fund | Transfers, Debt Service, and Other Requirements | $225.2M | $214.2M | 95.1% | Above pace |
| Enterprise Debt Service | AE Debt Service Fund | Transfers, Debt Service, and Other Requirements | $174.1M | $174.7M | 100.4% | Above pace |
| Nondepartmental | Project Connect Fund | Division Placeholder | $186.7M | $183.5M | 98.3% | Above pace |
| Austin Energy | E-Elec Short Trm Debt Clearing | Electric Cip Transfers To | $223.9M | $127.0M | 56.7% | Below pace |
| Human Resources | Employee Benefits Fund | Employee Medical | $169.3M | $152.6M | 90.2% | Above pace |
| Enterprise Debt Service | Airport Revenue Bond Redemption Fund | Transfers, Debt Service, and Other Requirements | $104.9M | $103.9M | 99.1% | Above pace |
| Austin Convention Center | Tourism Public Improvement District | Public Improvement District | $27.9M | $0.00 | 0.0% | Below pace |
| Austin Energy | Austin Energy Fund | Support Services | $12.1M | $-10.7M | -88.0% | Below pace |
| Austin Energy | Austin Energy Fund | Transfers, Debt Service, and Other Requirements | $479.6M | $379.4M | 79.1% | Near pace |
| Aviation | Airport Capital Fund | Transfers, Debt Service, and Other Requirements | $185.7M | $119.8M | 64.5% | Below pace |
| Neighborhood Housing & Community Development | Homestead Preservation Reinvestment Tax Increment Fund | Housing | $24.0M | $0.00 | 0.0% | Below pace |
| Austin Energy | Austin Energy Fund | Power Generation, Market Operations & Resource Planning | $141.5M | $123.1M | 86.9% | Above pace |
| Enterprise Debt Service | Convention Center HOT Debt Service Fund-Subordinate Lien | Transfers, Debt Service, and Other Requirements | $30.3M | $8.0M | 26.4% | Below pace |
| Austin Convention Center | Tourism Public Improvement District | Public Improvement District | $0.00 | $13.9M | 0.0% | Review: spend without budget |
| Enterprise Debt Service | Convention Center Expansion Senior Lien Debt Service Fund | Transfers, Debt Service, and Other Requirements | $17.9M | $0.00 | 0.0% | Below pace |
| Austin Energy | Austin Energy Fund | Power Supply | $0.00 | $13.3M | 0.0% | Review: spend without budget |
| Fire | General Fund | Fire / Emergency Response | $129.7M | $108.6M | 83.8% | Above pace |
| Homeless Strategy Office | General Fund | Social Service Grants - HSO | $39.5M | $18.5M | 46.7% | Below pace |
| Office of Arts, Culture, Music and Entertainment | Historic Preservation Fund | Cultural Education and Heritage Preservation | $15.6M | $1.9M | 11.9% | Below pace |
| Austin Energy | Austin Energy Fund | Electric System | $270.0M | $212.2M | 78.6% | Near pace |
| Austin Energy | Austin Energy Fund | Customer Care | $38.1M | $19.7M | 51.7% | Below pace |
| Austin Water | Austin Water Wastewater Utility Operating Fund | Transfers, Debt Service, and Other Requirements | $224.9M | $176.9M | 78.6% | Near pace |
| Austin Water | Austin Water Water Utility Operating Fund | Transfers, Debt Service, and Other Requirements | $208.4M | $164.3M | 78.9% | Near pace |
| Financial Services | Downtown Public Improvement District Fund | Public Improvement District | $14.3M | $3.2M | 22.6% | Below pace |
| Austin Energy | Austin Energy Fund | Electric System | $105.0M | $86.0M | 81.9% | Above pace |
| Austin Convention Center | Convention Center Capital Fund | Transfers, Debt Service, and Other Requirements | $37.3M | $20.9M | 55.9% | Below pace |
| Office of Arts, Culture, Music and Entertainment | Cultural Arts Fund | Cultural Arts | $14.9M | $4.1M | 27.5% | Below pace |
| Fire | General Fund | Fire / Emergency Response | $8.9M | $13.8M | 154.0% | Above pace |
| Neighborhood Housing & Community Development | Neighborhood Housing-Housing Trust Fund | Housing | $7.7M | $0.00 | 0.0% | Below pace |
| Austin Convention Center | Convention Center Tax Fund | Transfers, Debt Service, and Other Requirements | $68.5M | $57.1M | 83.3% | Above pace |
| Austin Energy | Austin Energy Fund | Support Services | $75.4M | $62.2M | 82.5% | Above pace |
| Austin Energy | Austin Energy Fund | Support Services | $42.2M | $26.0M | 61.7% | Below pace |
| Austin Convention Center | Convention Center Expansion | Interfund Transfers-Other | $7.0M | $0.00 | 0.0% | Below pace |
| Austin Water | W-Water Impact Fees | Water Cip Transfers To | $20.0M | $20.0M | 100.0% | Above pace |
| Fleet Services | Fleet Services Fund | Fleet Service Centers | $18.3M | $18.4M | 100.5% | Above pace |
| Police | General Fund | Operations Support | $45.7M | $38.9M | 85.0% | Above pace |
| Emergency Medical Services | General Fund | Operations | $11.1M | $12.8M | 115.4% | Above pace |
| Police | General Fund | Transfers, Debt Service, and Other Requirements | $53.0M | $44.2M | 83.3% | Above pace |
| Homeless Strategy Office | Neighborhood Housing-Housing Trust Fund | Homeless Diversion Services | $0.00 | $4.3M | 0.0% | Review: spend without budget |
| Austin Water | Austin Water Wastewater Utility Operating Fund | Support Services | $18.8M | $18.3M | 97.1% | Above pace |
| Austin Energy | Austin Energy Fund | Customer Care | $51.0M | $42.4M | 83.1% | Above pace |
| Police | General Fund | Neighborhood-Based Policing | $161.5M | $125.1M | 77.5% | Near pace |
| Law | Liability Reserve Fund | Liability Reserve | $6.8M | $1.1M | 16.2% | Below pace |
| Austin Convention Center | Convention Center Operating Fund | Transfers, Debt Service, and Other Requirements | $27.4M | $24.5M | 89.4% | Above pace |
| Homeless Strategy Office | Neighborhood Housing-Housing Trust Fund | Homeless Diversion Services | $5.1M | $0.00 | 0.0% | Below pace |
| Neighborhood Housing & Community Development | Neighborhood Housing University Neighborhood Overlay Fund | Housing | $5.0M | $0.00 | 0.0% | Below pace |
| Human Resources | Employee Benefits Fund | Retiree Medical | $44.4M | $37.0M | 83.3% | Above pace |
| Police | General Fund | Investigations | $8.4M | $9.9M | 117.8% | Above pace |
| Homeless Strategy Office | Pay for Success Reserve Fund | Pay for Success | $4.8M | $0.00 | 0.0% | Below pace |
| Police | General Fund | Transfers, Debt Service, and Other Requirements | $42.1M | $35.1M | 83.4% | Above pace |
| Austin Energy | Austin Energy Fund | Transfers, Debt Service, and Other Requirements | $42.1M | $35.1M | 83.3% | Above pace |
| Financial Services | Mueller Local Government Corp | Mueller Development | $5.3M | $455.6K | 8.7% | Below pace |
| Police | General Fund | Neighborhood-Based Policing | $59.0M | $47.5M | 80.5% | Above pace |
| Police | General Fund | Professional Standards | $18.4M | $17.0M | 92.4% | Above pace |
| Communications & Technology Management | Information and Technology Fund | Support Services | $894.8K | $3.7M | 413.0% | Above pace |
| Austin Energy | Austin Energy Fund | Customer Care | $9.4M | $4.1M | 44.0% | Below pace |
| Police | General Fund | Neighborhood-Based Policing | $26.3M | $22.6M | 86.0% | Above pace |
| Austin Resource Recovery | Austin Resource Recovery Fund | Collection Services | $26.5M | $22.8M | 85.9% | Above pace |
| Austin Energy | Austin Energy Fund | Customer Care | $-35.2M | $-29.3M | 83.2% | Review: non-positive budget |
| Police | General Fund | Operations Support | $6.3M | $7.5M | 120.4% | Above pace |
| Austin Water | Austin Water Wastewater Utility Operating Fund | Operations | $38.7M | $31.8M | 82.1% | Above pace |
| Nondepartmental | General Fund | Transfers, Debt Service, and Other Requirements | $4.4M | $538.0K | 12.3% | Below pace |
| Austin Energy | Austin Energy Fund | Electric System | $24.3M | $15.5M | 63.7% | Below pace |
| Austin Water | Austin Water Community Benefit Charge Fund | Transfers, Debt Service, and Other Requirements | $22.2M | $13.9M | 62.7% | Below pace |
| Financial Services | Waller Creek Reserve Fund | Transfers, Debt Service, and Other Requirements | $11.2M | $11.1M | 99.1% | Above pace |
| Office of Arts, Culture, Music and Entertainment | Iconic Venue Fund | Music and Entertainment | $300.0K | $2.9M | 966.7% | Above pace |
| Emergency Medical Services | General Fund | Operations | $58.4M | $46.4M | 79.5% | Near pace |
| Office of Arts, Culture, Music and Entertainment | Live Music Fund | Music and Entertainment | $4.8M | $968.0K | 20.2% | Below pace |
| Neighborhood Housing & Community Development | Neighborhood Housing-Housing Trust Fund | Housing | $0.00 | $2.6M | 0.0% | Review: spend without budget |
| Communications & Technology Management | Information and Technology Fund | Support Services | $1.5M | $3.7M | 251.1% | Above pace |
| Austin Water | Austin Water Water Utility Operating Fund | Environmental, Planning, and Development Services | $5.4M | $1.5M | 27.8% | Below pace |
| Austin Energy | Austin Energy Fund | Customer Energy Solutions | $9.9M | $4.9M | 49.8% | Below pace |
| Financial Services | Support Services Fund | Support Services | $3.2M | $-123.3K | -3.9% | Below pace |
| Austin Water | S-Wastewater Impact Fees | Wastewater Cip Transfers To | $10.0M | $10.0M | 100.0% | Above pace |
| Fleet Services | General Svc Inventories | Operational Services | $0.00 | $2.5M | 0.0% | Review: spend without budget |
| Nondepartmental | General Fund | Transfers, Debt Service, and Other Requirements | $36.6M | $29.9M | 81.8% | Above pace |
| Human Resources | Employee Benefits Fund | Retiree Medical | $24.6M | $20.9M | 84.9% | Above pace |
| Development Services | Development Services Fund | Support Services | $5.0M | $1.4M | 27.8% | Below pace |
| Austin Water | Austin Water Wastewater Utility Operating Fund | Engineering and Technical Services | $10.9M | $10.5M | 96.6% | Above pace |
| Austin Public Health | General Fund | Social Service Grants | $25.5M | $16.8M | 65.8% | Below pace |
| Austin Energy | Austin Energy Fund | Transfers, Debt Service, and Other Requirements | $19.2M | $16.7M | 87.2% | Above pace |
| Financial Services | GCP-Interest Income Fund | Interfund Transfers-Other | $9.3M | $9.3M | 100.0% | Above pace |
| Management Services | Support Services Fund | Support Services | $3.3M | $210.9K | 6.3% | Below pace |
| Human Resources | Workers' Compensation Fund | Indemnity Payments | $8.3M | $3.9M | 47.6% | Below pace |
| Austin Resource Recovery | Austin Resource Recovery Fund | Collection Services | $12.4M | $7.0M | 56.8% | Below pace |
| Law | Liability Reserve Fund | Liability Reserve | $363.0K | $2.5M | 692.9% | Above pace |
| Aviation | Airport Operating Fund | Support Services | $11.0M | $6.0M | 54.9% | Below pace |
| Communications & Technology Management | Combined Transportation, Emergency & Communications Ctr Fund | CTECC and Public Safety IT Support | $9.9M | $9.6M | 97.1% | Above pace |
| Human Resources | Employee Benefits Fund | Employee Dental | $11.7M | $10.9M | 93.0% | Above pace |
| Municipal Court | General Fund | Community Court | $6.4M | $2.7M | 42.6% | Below pace |
| Communications & Technology Management | Information and Technology Fund | Enterprise Operations & Technology | $19.2M | $12.3M | 64.2% | Below pace |
| Austin Water | Austin Water Wastewater Utility Operating Fund | Customer Experience | $7.4M | $7.6M | 102.1% | Above pace |
| Aviation | Airport Operating Fund | Support Services | $28.9M | $23.6M | 81.9% | Above pace |
| Financial Services | Waller Creek Tax Increment Financing Fund | Transfers, Debt Service, and Other Requirements | $23.6M | $19.7M | 83.3% | Above pace |
| Economic Development | Economic Development Fund | Workforce Development and Childcare | $2.9M | $201.6K | 7.0% | Below pace |
| Austin Energy | Austin Energy Fund | Power Generation, Market Operations & Resource Planning | $8.4M | $4.4M | 51.7% | Below pace |
| Office of Arts, Culture, Music and Entertainment | Iconic Venue Fund | Music and Entertainment | $2.6M | $0.00 | 0.0% | Below pace |
Variance drivers
Sequence investigation by materiality
Above straight-line pace
Synthetic corporate scenario
Test revenue, cost inflation, and hiring-delay assumptions
Only future-period rows change. Actual periods and the reviewed public-finance data stay untouched.
Future-period assumptions
Revenue$157.9M
Cost$124.6M
EBITDA margin21.1%
Monthly EBITDA: base forecast versus scenario
Base forecastScenario
Excel and Power BI
Companion deliverables for desktop review
