Loading...
HomeMy WebLinkAboutCouncil Presentation 06/06/2017 - 2017 Financial Update Qtr3 C== MAII R, ANA AZ FY2017 Financial Update — 3rd Quarter Erik Montague, Finance Director June 6, 2017 • AL Update for 3rd quarter (July — March ) • Summary for General Fund and other selected major funds • General Fund Big three revenues — Transaction Privilege (Sales) Taxes — State Shared Revenues — Licenses, Permits & Fees • Overall status through March L AL r ■ "The Big Three" represent FY2014 3rd FY2015 FY2016 ' , • = • • - 95% of budgeted revenue Revenue Category Qtr 3rd Qtr 3rd Qtr Sales taxes 15,385,733 15,814,250 18,066,766 • • ' . ■ YoY for 3rdQuarter — ■ Sales taxes — 3.5% T Intergovernmental 671647180 676227942 677747242 ■ Intergovernmental — 17.4% T Licenses, fees and License & permits _ 6.6/ permits 277527523 373457768 3,187,285 - � - � • • • • : - ' . All other 174797878 176337832 173307418 - - • - ' . Total Revenues 25,782,314 27,416,792 29,358,711 - • - •' . General Fund - Major Revenues - SFR Permits N $20.0 500 486 ,o $15.0 480 459 $10.0 FY2014 3rd Qtr. 460 436 $5.0 FY2015 3rd Qtr. 440 $0.0 L 420 418 414 �� a� �•.• FY2016 3rd Qtr. a 400 a ,��� �� FY2017 3rd Qtr. aye, � �� 380 Lj OJQi 360 �� 2014 3rd Qtr 2015 3rd Qtr 2016 3rd Qtr 2017 3rd Qtr 2017 Budget L AL r Expenditure Category FY2014 3rd Qtr. FY2015 3rd Qtr. FY2016 3rd Qtr. = • • - Personnel and benefits 15,764,123 17,050,776 17,590,307 - - • • ' Contracted services 275237675 279137807 375037243 • - - ' Operating supplies & equipment 272097475 274207750 276717680 - • - : ' Capital outlay 3447045 4607236 4697473 • - - - - ' Other financing uses 173357718 174417911 171207054 • - - - of off Total Expenditure's 2291779039 2492879480 2593549757 - : • : - ' Over/Under 396059275 391299312 490039954 - • - ■ Overall — within General Fund Expenditures expectations 20,000,000 1510001000 FY2014 3rd Qtr. ■ Lagging expenditure 1010001000 FY2015 3rd Qtr. cate o ri es wi I l l i ke I 5,000,000 g y FY2016 3rd Qtr. approximate budget by end 0 Personnel and Contracted Operating Capital outlay FY2017 3rd Qtr. of fiscal year benefits services supplies& equipment Note 1: General Fund budget includes $5M in contingency and $2M for Police Facility General Fund Contribution L AL r Bed Tax Revenue Category FY2014 3rd FY2015 3rd FY2016 3rd ' , = • • - • � = • • - � � Qtr. Qtr. Qtr. Sales taxes 6227650 5677416 7267044 Total Revenues 6229650 5679416 7269044 Expenditures Personnel and benefits 16 124 20 917 65 419 • - • ' Contracted services 583 334 562 953 673 002 • • � � : • ' , Operating supplies & equipment 22 262 39 922 60 504 1 off - : • ' Total Expenditures 621 721 623 793 798 925 • - • - • - • ' Net Over/Under 929 (56,377) (72,881) ■ Revenues — Bed Tax Revenues ■ YOY for 3rd Quarter— 6.6% T 900 ■ Expenditures — 800 ■ Non-personnel categories are lagging, but 700 FY2014 3rd Qtr. are anticipated to approach budget in future � 600 quarters soo FY2015 3rdQtr. ■ 400 _ FY2016 3rd Qtr. Contracted services slight variance due to large lease payment 300 kin FY2017 3rd Qtr. Y 200 - 100 0 5 Sales taxes L AL Revenue Category FY2014 3rd Qtr. FY2015 3rd FY2016 3rd ' , = • • - Qtr.Q Qtr. Intergovernmental 176387988 177827356 178797909 ' Investment income 17070 17396 37817 off Total Revenues 196409057 197839752 198839725 • Expenditure Category Personnel and benefits 3957738 3987940 4287329 - • : ' Contracted services 173617237 170847162 170717126 - - • ' Operating supplies & equipment 1427071 1337790 1507580 - - • ' Capital outlay 3177231 2237266 1737285 : - : • • • ' Total Expenditures 292169276 198409157 198239320 : • • Net Over/Under (576,219) (56,405) 609405 • • - - : • : - HURF E ■ Revenues - 1.6 - ■ Overall within expectations ■ YoY for 3rd Quarter—20.2% T .2 1.4 - — � Expenditures — 1.2 FY2014 3rd Qtr. ■ � ■ Expense categories are lagging, 1.0 FY2015 3rd Qtr. but are anticipated to approach 0.8 pp p FY2016 3rd Qtr. budget by end of fiscal year 0.6 FY2017 3rd Qtr. 0.4 0.2 0.0 VIF Personnel and Contracted Operating supplies Capital outlay benefits services &equipment ■ Revenues — FY2016 - Revenues Target 3rd Qtr. = • • - � � ■ Anticipated to approach budget in future due to Sales taxes 1870007000 371347598some seasonality Total Revenue 1870007000 371347598 . off off variation Will need to monitor Expenditures Capital outlay 327490 � • � ■ Expenditures are lagging, but will soon approach budget as Total Expenditure 327490 � major projects commence in Net Over/Under 371027108 � • . 1St Qtr. of next fiscal year 3,776,248 9,467,807 4,755,945 7 L AL r Revenue Category FY2014 3rd Qtr. FY2015 3rd Qtr. FY2016 3rd Qtr. ' ' • • • 1 Charges for services 275277147 278087479 278327537 - •' . Miscellaneous 137597 407985 57505 1 1' Licenses, fees and permits 197633 437675 327058 1 1 1 Investment income - 37262 67914 1 1 1 Other financing sources - - 557920 Total Revenue 275607377 278967401 279327934 - - • 1 •' . Expense Category Personnel and benefits 9097345 170757126 171487237 Contracted services 4277414 3447542 4327405 Operating supplies & equipment 6457287 6467418 6717279 - • - 1 : • : ' . Capital outlay 277465 597436 997531 • • 1 1 1 Debt service 597987 767636 717289 - - - •- ' . Total Expenditures 290699498 292029156 294229741 - : - 1 1 • :' , Over/Under 4909879 6949246 5109193 Revenues — Water ■ Within expectations 4,000,000 ■ Expenses — 3 000 000 > FY2014 3rd Qtr. on-personne categories 210001000 are labut are gg'in g FY2015 3rd Qtr. 1,000,000 anticipated to approach FY2016 3rd Qtr. budget by end of fiscal year - Charges for Personnel and Contracted Operating FY2017 3rd Qtr. services benefits services supplies& equipment ------------ Revenue Category FY2014 3rd Qtr. FY2015 3rd Qtr. FY2016 3rd Qtr. ' ' • • • 1 Charges for services 5967304 6847973 7427786 • • • ' . Miscellaneous - - - 1' . Licenses, fees and permits - 107242 117315 1 1 1 1 Total Revenue 5967304 6957215 7547101 • • • : : • :' . Expense Category Personnel and benefits 2137371 2657794 2957557 • • - - ' . Contracted services 3307975 2617634 3667783 • • - - - 1 1 1 • • • 1' , Operating supplies & equipment 567716 827157 867599 1 • 1 1 ' , Total Expenditures 6019061 6099585 7489940 • • ' . Over/Under (4 757 85 629 5 161 1 1 - 1 • • ■ Revenues — ■ Within expectations Wastewater Expenses 11000 Expenses — 800 ■ Non-personnel categories are lagging, but are ° 600 FY2014 3rd Qtr. anticipated to approach 400 FY2015 3rd Qtr. budget by end of fiscal 20o FY2016 3rd Qtr. year � - FY2017 3rd Qtr. Charges for Personnel and Contracted Operating services benefits services supplies& equipment Questions .? jo �Jrmmmftv -------------- ............................................ MARANA AZ ESTAB L IsHEo 1977 10