← All analytics projects
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

DepartmentFundProgramBudgetSpentUtilizationPace
General Obligation Debt ServiceGeneral Obligation Debt Service FundTransfers and Other Requirements$281.5M$77.0M27.4%Below pace
AviationAirport Operating FundTransfers, Debt Service, and Other Requirements$238.3M$71.6M30.1%Below pace
NondepartmentalHotel Occupancy Tax FundTransfers, Debt Service, and Other Requirements$167.3M$172.3M103.0%Above pace
Enterprise Debt ServiceAWU Debt Service FundTransfers, Debt Service, and Other Requirements$225.2M$214.2M95.1%Above pace
Enterprise Debt ServiceAE Debt Service FundTransfers, Debt Service, and Other Requirements$174.1M$174.7M100.4%Above pace
NondepartmentalProject Connect FundDivision Placeholder$186.7M$183.5M98.3%Above pace
Austin EnergyE-Elec Short Trm Debt ClearingElectric Cip Transfers To$223.9M$127.0M56.7%Below pace
Human ResourcesEmployee Benefits FundEmployee Medical$169.3M$152.6M90.2%Above pace
Enterprise Debt ServiceAirport Revenue Bond Redemption FundTransfers, Debt Service, and Other Requirements$104.9M$103.9M99.1%Above pace
Austin Convention CenterTourism Public Improvement DistrictPublic Improvement District$27.9M$0.000.0%Below pace
Austin EnergyAustin Energy FundSupport Services$12.1M$-10.7M-88.0%Below pace
Austin EnergyAustin Energy FundTransfers, Debt Service, and Other Requirements$479.6M$379.4M79.1%Near pace
AviationAirport Capital FundTransfers, Debt Service, and Other Requirements$185.7M$119.8M64.5%Below pace
Neighborhood Housing & Community DevelopmentHomestead Preservation Reinvestment Tax Increment FundHousing$24.0M$0.000.0%Below pace
Austin EnergyAustin Energy FundPower Generation, Market Operations & Resource Planning$141.5M$123.1M86.9%Above pace
Enterprise Debt ServiceConvention Center HOT Debt Service Fund-Subordinate LienTransfers, Debt Service, and Other Requirements$30.3M$8.0M26.4%Below pace
Austin Convention CenterTourism Public Improvement DistrictPublic Improvement District$0.00$13.9M0.0%Review: spend without budget
Enterprise Debt ServiceConvention Center Expansion Senior Lien Debt Service FundTransfers, Debt Service, and Other Requirements$17.9M$0.000.0%Below pace
Austin EnergyAustin Energy FundPower Supply$0.00$13.3M0.0%Review: spend without budget
FireGeneral FundFire / Emergency Response$129.7M$108.6M83.8%Above pace
Homeless Strategy OfficeGeneral FundSocial Service Grants - HSO$39.5M$18.5M46.7%Below pace
Office of Arts, Culture, Music and EntertainmentHistoric Preservation FundCultural Education and Heritage Preservation$15.6M$1.9M11.9%Below pace
Austin EnergyAustin Energy FundElectric System$270.0M$212.2M78.6%Near pace
Austin EnergyAustin Energy FundCustomer Care$38.1M$19.7M51.7%Below pace
Austin WaterAustin Water Wastewater Utility Operating FundTransfers, Debt Service, and Other Requirements$224.9M$176.9M78.6%Near pace
Austin WaterAustin Water Water Utility Operating FundTransfers, Debt Service, and Other Requirements$208.4M$164.3M78.9%Near pace
Financial ServicesDowntown Public Improvement District FundPublic Improvement District$14.3M$3.2M22.6%Below pace
Austin EnergyAustin Energy FundElectric System$105.0M$86.0M81.9%Above pace
Austin Convention CenterConvention Center Capital FundTransfers, Debt Service, and Other Requirements$37.3M$20.9M55.9%Below pace
Office of Arts, Culture, Music and EntertainmentCultural Arts FundCultural Arts$14.9M$4.1M27.5%Below pace
FireGeneral FundFire / Emergency Response$8.9M$13.8M154.0%Above pace
Neighborhood Housing & Community DevelopmentNeighborhood Housing-Housing Trust FundHousing$7.7M$0.000.0%Below pace
Austin Convention CenterConvention Center Tax FundTransfers, Debt Service, and Other Requirements$68.5M$57.1M83.3%Above pace
Austin EnergyAustin Energy FundSupport Services$75.4M$62.2M82.5%Above pace
Austin EnergyAustin Energy FundSupport Services$42.2M$26.0M61.7%Below pace
Austin Convention CenterConvention Center ExpansionInterfund Transfers-Other$7.0M$0.000.0%Below pace
Austin WaterW-Water Impact FeesWater Cip Transfers To$20.0M$20.0M100.0%Above pace
Fleet ServicesFleet Services FundFleet Service Centers$18.3M$18.4M100.5%Above pace
PoliceGeneral FundOperations Support$45.7M$38.9M85.0%Above pace
Emergency Medical ServicesGeneral FundOperations$11.1M$12.8M115.4%Above pace
PoliceGeneral FundTransfers, Debt Service, and Other Requirements$53.0M$44.2M83.3%Above pace
Homeless Strategy OfficeNeighborhood Housing-Housing Trust FundHomeless Diversion Services$0.00$4.3M0.0%Review: spend without budget
Austin WaterAustin Water Wastewater Utility Operating FundSupport Services$18.8M$18.3M97.1%Above pace
Austin EnergyAustin Energy FundCustomer Care$51.0M$42.4M83.1%Above pace
PoliceGeneral FundNeighborhood-Based Policing$161.5M$125.1M77.5%Near pace
LawLiability Reserve FundLiability Reserve$6.8M$1.1M16.2%Below pace
Austin Convention CenterConvention Center Operating FundTransfers, Debt Service, and Other Requirements$27.4M$24.5M89.4%Above pace
Homeless Strategy OfficeNeighborhood Housing-Housing Trust FundHomeless Diversion Services$5.1M$0.000.0%Below pace
Neighborhood Housing & Community DevelopmentNeighborhood Housing University Neighborhood Overlay FundHousing$5.0M$0.000.0%Below pace
Human ResourcesEmployee Benefits FundRetiree Medical$44.4M$37.0M83.3%Above pace
PoliceGeneral FundInvestigations$8.4M$9.9M117.8%Above pace
Homeless Strategy OfficePay for Success Reserve FundPay for Success$4.8M$0.000.0%Below pace
PoliceGeneral FundTransfers, Debt Service, and Other Requirements$42.1M$35.1M83.4%Above pace
Austin EnergyAustin Energy FundTransfers, Debt Service, and Other Requirements$42.1M$35.1M83.3%Above pace
Financial ServicesMueller Local Government CorpMueller Development$5.3M$455.6K8.7%Below pace
PoliceGeneral FundNeighborhood-Based Policing$59.0M$47.5M80.5%Above pace
PoliceGeneral FundProfessional Standards$18.4M$17.0M92.4%Above pace
Communications & Technology ManagementInformation and Technology FundSupport Services$894.8K$3.7M413.0%Above pace
Austin EnergyAustin Energy FundCustomer Care$9.4M$4.1M44.0%Below pace
PoliceGeneral FundNeighborhood-Based Policing$26.3M$22.6M86.0%Above pace
Austin Resource RecoveryAustin Resource Recovery FundCollection Services$26.5M$22.8M85.9%Above pace
Austin EnergyAustin Energy FundCustomer Care$-35.2M$-29.3M83.2%Review: non-positive budget
PoliceGeneral FundOperations Support$6.3M$7.5M120.4%Above pace
Austin WaterAustin Water Wastewater Utility Operating FundOperations$38.7M$31.8M82.1%Above pace
NondepartmentalGeneral FundTransfers, Debt Service, and Other Requirements$4.4M$538.0K12.3%Below pace
Austin EnergyAustin Energy FundElectric System$24.3M$15.5M63.7%Below pace
Austin WaterAustin Water Community Benefit Charge FundTransfers, Debt Service, and Other Requirements$22.2M$13.9M62.7%Below pace
Financial ServicesWaller Creek Reserve FundTransfers, Debt Service, and Other Requirements$11.2M$11.1M99.1%Above pace
Office of Arts, Culture, Music and EntertainmentIconic Venue FundMusic and Entertainment$300.0K$2.9M966.7%Above pace
Emergency Medical ServicesGeneral FundOperations$58.4M$46.4M79.5%Near pace
Office of Arts, Culture, Music and EntertainmentLive Music FundMusic and Entertainment$4.8M$968.0K20.2%Below pace
Neighborhood Housing & Community DevelopmentNeighborhood Housing-Housing Trust FundHousing$0.00$2.6M0.0%Review: spend without budget
Communications & Technology ManagementInformation and Technology FundSupport Services$1.5M$3.7M251.1%Above pace
Austin WaterAustin Water Water Utility Operating FundEnvironmental, Planning, and Development Services$5.4M$1.5M27.8%Below pace
Austin EnergyAustin Energy FundCustomer Energy Solutions$9.9M$4.9M49.8%Below pace
Financial ServicesSupport Services FundSupport Services$3.2M$-123.3K-3.9%Below pace
Austin WaterS-Wastewater Impact FeesWastewater Cip Transfers To$10.0M$10.0M100.0%Above pace
Fleet ServicesGeneral Svc InventoriesOperational Services$0.00$2.5M0.0%Review: spend without budget
NondepartmentalGeneral FundTransfers, Debt Service, and Other Requirements$36.6M$29.9M81.8%Above pace
Human ResourcesEmployee Benefits FundRetiree Medical$24.6M$20.9M84.9%Above pace
Development ServicesDevelopment Services FundSupport Services$5.0M$1.4M27.8%Below pace
Austin WaterAustin Water Wastewater Utility Operating FundEngineering and Technical Services$10.9M$10.5M96.6%Above pace
Austin Public HealthGeneral FundSocial Service Grants$25.5M$16.8M65.8%Below pace
Austin EnergyAustin Energy FundTransfers, Debt Service, and Other Requirements$19.2M$16.7M87.2%Above pace
Financial ServicesGCP-Interest Income FundInterfund Transfers-Other$9.3M$9.3M100.0%Above pace
Management ServicesSupport Services FundSupport Services$3.3M$210.9K6.3%Below pace
Human ResourcesWorkers' Compensation FundIndemnity Payments$8.3M$3.9M47.6%Below pace
Austin Resource RecoveryAustin Resource Recovery FundCollection Services$12.4M$7.0M56.8%Below pace
LawLiability Reserve FundLiability Reserve$363.0K$2.5M692.9%Above pace
AviationAirport Operating FundSupport Services$11.0M$6.0M54.9%Below pace
Communications & Technology ManagementCombined Transportation, Emergency & Communications Ctr FundCTECC and Public Safety IT Support$9.9M$9.6M97.1%Above pace
Human ResourcesEmployee Benefits FundEmployee Dental$11.7M$10.9M93.0%Above pace
Municipal CourtGeneral FundCommunity Court$6.4M$2.7M42.6%Below pace
Communications & Technology ManagementInformation and Technology FundEnterprise Operations & Technology$19.2M$12.3M64.2%Below pace
Austin WaterAustin Water Wastewater Utility Operating FundCustomer Experience$7.4M$7.6M102.1%Above pace
AviationAirport Operating FundSupport Services$28.9M$23.6M81.9%Above pace
Financial ServicesWaller Creek Tax Increment Financing FundTransfers, Debt Service, and Other Requirements$23.6M$19.7M83.3%Above pace
Economic DevelopmentEconomic Development FundWorkforce Development and Childcare$2.9M$201.6K7.0%Below pace
Austin EnergyAustin Energy FundPower Generation, Market Operations & Resource Planning$8.4M$4.4M51.7%Below pace
Office of Arts, Culture, Music and EntertainmentIconic Venue FundMusic and Entertainment$2.6M$0.000.0%Below pace
Variance drivers

Sequence investigation by materiality

Above straight-line pace

Transfers, Debt Service, and Other Requirements$46.8M
Nondepartmental · signed $46.8M
Transfers, Debt Service, and Other Requirements$45.3M
Enterprise Debt Service · signed $45.3M
Transfers, Debt Service, and Other Requirements$44.2M
Enterprise Debt Service · signed $44.2M
Division Placeholder$43.5M
Nondepartmental · signed $43.5M
Employee Medical$25.6M
Human Resources · signed $25.6M
Transfers, Debt Service, and Other Requirements$25.2M
Enterprise Debt Service · signed $25.2M
Transfers, Debt Service, and Other Requirements$19.7M
Austin Energy · signed $19.7M
Power Generation, Market Operations & Resource Planning$16.9M
Austin Energy · signed $16.9M
Public Improvement District$13.9M
Austin Convention Center · signed $13.9M
Power Supply$13.3M
Austin Energy · signed $13.3M
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

Scenario EBITDA$33.3M

Base forecast EBITDA: $33.3M
Change: $0.00

Revenue$157.9M
Cost$124.6M
EBITDA margin21.1%

Monthly EBITDA: base forecast versus scenario

$2.0M$2.7M$3.5MJan 2026Jun 2026Dec 2026
Base forecastScenario
Excel and Power BI

Companion deliverables for desktop review