City of Phoenix, Arizona Monthly Financial Report August 2012 Monthly Financial Report – August 2012 Executive Summary Budget • The budget amounts in this report represent the official adopted budget, as approved by the City Council, for fiscal year 2012-13. Revenues • Local Taxes and the City’s portion of State Shared Taxes comprise the major portion, approximately 74 percent, of estimated General Fund revenues. At the end of August 2012, local sales revenues were comparable to the prior August and State Shared Taxes were $5.7 million higher compared to the prior August. (see page 2). Expenditures • General Fund Expenditures overall at the end of August 2012 are $17.4 million more than they were through August of the prior fiscal year. (see page 3) Individual specific trends are difficult to determine at this time as it is still early in the fiscal year. • Citywide operating expenditures at the end of August 2012 are $32.1 million more than year-to-date expenditures at August 2011, a 5.3% increase. (See page 5) -1- General Funds Summary Summary General Funds As of August 31 (dollars in thousands) Budget Estimate 2012-13 Actual Year-to-Date 2012-13 2011-12 % of Year-to-Date Estimate Actual 2012-13 2011-12 Revenues Local Taxes Sales Taxes Privilege License Fees State Shared Taxes State Sales Tax State Income Tax Vehicle License Tax Primary Property Tax Licenses and Permits Cable Communications Municipal Court Fines and Forfeitures Court Default Fee Police Library Parks and Recreation Planning & Development Street Transportation Fire Emergency Transportation Service Other Interest Other Fees and Service Charges Total Revenues $ $ 432,690 2,680 68,281 $ 96 68,114 113 15.8 % 3.6 16.7 % 4.9 119,646 147,655 47,000 131,921 2,897 9,386 18,662 24,611 8,475 (150) 393 - 17,535 20,331 8,180 (632) 513 (154) 15.6 16.7 18.0 (0.1) 13.6 - 15.4 16.7 17.6 (0.5) 17.4 (1.6) 22,009 1,150 12,317 1,313 7,889 894 3,960 3,267 149 1,195 180 959 172 561 3,453 142 1,378 201 1,281 140 739 14.8 13.0 9.7 13.7 12.2 19.2 14.2 16.2 11.7 8.8 14.7 19.2 13.2 14.0 41,100 12,878 870 12,752 5,941 1,671 261 1,174 6,104 2,177 140 1,968 14.5 13.0 30.0 9.2 17.0 18.0 17.5 13.1 13.4 % 13.9 % 1,011,007 $ $ 135,898 $ -2- 131,723 Summary General Funds As of August 31 (dollars in thousands) Budget Estimate 2012-13 Actual Year-to-Date 2012-13 2011-12 % of Year-to-Date Estimate Actual 2012-13 2011-12 Expenditures and Encumbrances General Government Mayor City Council City Manager Information Technology Services Public Information Equal Opportunity Law City Auditor City Clerk Human Resources Budget and Research Finance Others Total General Government $ Criminal Justice Municipal Court Public Defender Total Criminal Justice 1,692 3,646 2,306 35,299 2,438 2,446 19,348 2,367 5,156 10,511 3,007 17,603 2,192 108,011 $ 310 $ 525 464 5,289 394 369 3,322 585 716 1,635 653 2,658 415 17,335 201 558 453 6,306 440 370 3,023 727 658 1,614 615 2,628 896 18,489 18.3 % 14.4 20.1 15.0 16.2 15.1 17.2 24.7 13.9 15.6 21.7 15.1 18.9 16.0 13.9 % 17.7 24.7 21.2 18.9 17.1 16.5 36.5 14.4 15.8 21.3 15.8 26.6 18.8 30,422 4,780 35,202 5,520 802 6,322 5,422 768 6,190 18.1 16.8 18.0 18.8 16.2 18.5 450,336 244,149 16 694,501 79,938 43,260 3 123,201 77,679 38,316 1 115,996 17.8 17.7 18.8 17.7 18.3 17.3 66.9 17.9 Transportation Street Transportation Public Transit Total Transportation 23,904 19,559 43,463 11,804 3,292 15,096 2,706 3,112 5,818 49.4 16.8 34.7 13.2 16.6 14.9 Community Development Economic Development Neighborhood Services Department Planning and Development Others Total Community Development 4,799 11,819 4,987 54 21,659 685 2,023 882 8 3,598 761 1,852 754 8 3,375 14.3 17.1 17.7 14.8 16.6 17.7 17.3 17.3 16.7 17.4 Community Enrichment Parks and Recreation Library Human Services Others Total Community Enrichment 89,909 36,051 18,260 2,485 146,705 18,258 5,383 3,775 807 28,223 17,240 4,601 3,953 457 26,251 20.3 14.9 20.7 32.5 19.2 19.2 14.1 24.5 26.2 18.7 Environmental Services Public Works Environmental Programs Total Environmental Services 16,136 987 17,123 2,982 228 3,210 3,109 148 3,257 18.5 23.1 18.7 20.8 19.6 20.7 83 270 1.5 11.7 - - Public Safety Police Fire Others Total Public Safety Capital Improvement 5,698 Contingencies Total Expenditures and Encumbrances 42,658 $ 1,115,020 $ -3- 197,068 $ 179,646 17.7 % 18.0 % Citywide Summary Comparison to Prior Year Revenues YEAR-TO-DATE REVENUES As of August 31, 2012 3,500 3,000 (millions of dollars) 2,500 2,000 1,500 1,000 500 0 July Aug Sept Oct Nov Dec Current YTD Revenues Jan Feb Mar April May June Prior YTD Revenues Revenues Year-to-date revenues as of August 31 increased by $43,272,917 to $483,752,190 from the $440,479,273 collected during the same period last year, an increase of 9.8%. For the current year, 15.7% of the total estimated revenue has been collected. Of the total revenues received last year, 14.7% had been collected as of August 31. -4- Comparison to Prior Year Operating Expenditures YEAR-TO-DATE OPERATING EXPENDITURES (millions of dollars) As of August 31, 2012 3,200 3,100 3,000 2,900 2,800 2,700 2,600 2,500 2,400 2,300 2,200 2,100 2,000 1,900 1,800 1,700 1,600 1,500 1,400 1,300 1,200 1,100 1,000 900 800 700 600 500 400 300 200 100 0 July Aug Sept Oct Nov Dec Current YTD Expenditures Jan Feb Mar April May June Prior YTD Expenditures Operating Expenditures For the entire City, including enterprise funds such as Water Services and Aviation, year-to-date operating expenditures as of August 31 increased $32,111,534 to $641,355,836 from the $609,244,302 spent during the same period last year, an increase of 5.3%. For the current year, 18.0% of the total appropriations has been spent. Of the total actual expenditures for last year, 20.4% had been spent as of August 31. -5- Comparison to Prior Year Capital Expenditures YEAR-TO-DATE CAPITAL EXPENDITURES As of August 31, 2012 800 750 700 650 600 (millions of dollars) 550 500 450 400 350 300 250 200 150 100 50 0 July Aug Sept Oct Nov Dec Current YTD Expenditures Jan Feb Mar April May June Prior YTD Expenditures Capital Expenditures Year-to-date capital expenditures as of August 31 decreased $40,567,147 to $58,705,602 from the $99,272,749 spent during the same period last year, a decrease of 40.9%. For the current year, 5.0% of the total appropriations has been spent. Of the total actual expenditures for last year, 13.3% had been spent as of August 31. -6- Summary Operating Revenues As of August 31 (dollars in thousands) Source General Funds Local Taxes: Sales Taxes Privilege License Fees State Shared Taxes: State Sales Tax State Income Tax Vehicle License Tax Primary Property Tax Licenses and Permits Cable Communications Municipal Court Police Library Fees Parks and Recreation Planning & Development Street Transportation Fire Interest Other Fees and Service Charges $ 432,690 2,680 $ 119,646 147,655 47,000 131,921 2,897 9,386 23,159 12,317 1,313 7,889 894 3,960 53,978 870 12,752 Total General Funds 1,011,007 Special Revenue Funds and Debt Service Neighborhood Protection Public Safety Enhancement & Expansion Parks and Preserves Transit 2000 Court Awards Planning and Development Capital Construction Sports Facilities Highway User Revenue Regional Transit Revenues Community Reinvestment Other Restricted Fees Grants G.O. Bond Debt Service Enterprise Funds Aviation Convention Center Water System Wastewater Solid Waste Golf Courses Total Enterprise Funds $ % of Year-to-Date Estimate Actual 2012-13 2011-12 68,281 $ 96 68,114 113 15.8 % 3.6 16.7 % 4.9 18,662 24,611 8,475 (150) 393 3,416 1,195 180 959 172 561 7,612 261 1,174 17,535 20,331 8,180 (632) 513 (154) 3,595 1,378 201 1,281 140 739 8,281 140 1,968 15.6 16.7 18.0 (0.1) 13.6 14.8 9.7 13.7 12.2 19.2 14.2 14.1 30.0 9.2 15.4 16.7 17.6 (0.5) 17.4 (1.6) 15.9 8.8 14.7 19.2 13.2 14.0 17.3 17.5 13.1 13.4 13.9 4,350 13,142 4,376 24,993 302 5,530 2,886 1,931 13,507 1,924 301 3,436 16,457 (909) 15.1 16.6 14.9 14.7 20.8 16.1 11.5 14.8 13.0 39.5 4.8 8.4 (0.4) 16.4 17.1 16.3 15.8 3.3 16.9 17.3 12.7 14.9 7.6 9.4 10.1 6.4 (0.9) 135,898 29,009 82,103 29,472 169,411 11,327 33,990 17,405 16,092 102,211 34,489 3,564 26,785 274,742 68,149 Total Special Revenue Funds and Debt Service Total Operating Revenues Actual Year-to-Date 2012-13 2011-12 Budget Estimate 2012-13 4,374 13,644 4,380 24,963 7,068 2,809 1,857 15,136 4,487 1,409 1,275 23,177 (284) 131,723 898,749 104,295 92,226 11.6 10.6 350,068 60,697 379,108 231,107 144,972 6,205 54,312 7,913 121,837 35,604 23,307 586 52,031 8,201 93,200 38,093 24,473 532 15.5 13.0 32.1 15.4 16.1 9.4 15.3 14.6 24.0 16.4 16.9 8.8 1,172,157 243,559 216,530 20.8 18.5 483,752 $ 440,479 15.7 % 14.7 % 3,081,913 -7- $ Summary Operating Revenues As of August 31, 2012 General Funds Local Taxes General Funds State Shared Taxes 450 300 400 250 300 (millions of dollars) (millions of dollars) 350 250 200 150 200 150 100 100 50 50 0 0 July Aug Sept Oct Nov Dec Jan Feb Mar April May June Current YTD Revenues July Aug Sept Oct Prior YTD Revenues Jan Current YTD Revenues Total General Funds Revenues Feb Mar April May June Prior YTD Revenues Highway User Revenues 1,000 100 900 90 800 80 700 70 (millions of dollars) (millions of dollars) Nov Dec 600 500 400 60 50 40 300 30 200 20 100 10 0 0 July Aug Sept Oct Nov Dec Jan Feb Mar April May June July Aug Sept Oct Nov Dec Jan Feb Mar April May June Current YTD Revenues Current YTD Revenues Prior YTD Revenues -8- Prior YTD Revenues Summary Operating Expenditures and Encumbrances As of August 31 (dollars in thousands) Source General Government General Funds Other Funds Total General Government Actual Year-to-Date 2012-13 2011-12 Budget 2012-13 $ Criminal Justice General Funds Other Funds Total Criminal Justice 108,011 13,360 121,371 $ 17,335 $ 951 18,286 18,489 487 18,976 % of Year-to-Date Estimate Actual 2012-13 2011-12 16.0 % 7.1 15.1 18.8 % 4.4 17.3 35,202 13,015 48,217 6,322 1,383 7,705 6,190 612 6,802 18.0 10.6 16.0 18.5 22.1 18.7 Public Safety General Funds Other Funds Total Public Safety 694,501 174,273 868,774 123,201 26,548 149,749 115,996 26,309 142,305 17.7 15.2 17.2 17.9 16.8 17.7 Transportation General Funds Other Funds Total Transportation 43,463 582,736 626,199 15,096 201,165 216,261 5,818 204,185 210,003 34.7 34.5 34.5 14.9 37.4 35.9 Community Development General Funds Other Funds Total Community Development 21,659 224,492 246,151 3,598 35,614 39,212 3,375 25,594 28,969 16.6 15.9 15.9 17.4 14.8 15.1 Community Enrichment General Funds Other Funds Total Community Enrichment 146,705 157,019 303,724 28,223 25,641 53,864 26,251 26,720 52,971 19.2 16.3 17.7 18.7 20.2 19.4 Environmental Services General Funds Other Funds Total Environmental Services 17,123 614,891 632,014 3,210 109,898 113,108 3,257 89,429 92,686 18.7 17.9 17.9 20.7 16.8 16.9 Debt Service General Funds Other Funds Total Debt Service 106,762 106,762 22,732 22,732 28,154 28,154 21.3 21.3 17.9 17.9 Capital Improvement General Funds Other Funds Total Capital Improvement 5,698 523,523 529,221 83 20,356 20,439 270 28,108 28,378 1.5 3.9 3.9 11.7 10.1 10.1 42,658 47,550 90,208 - - Contingencies General Funds Other Funds Total Contingencies Total Operating General Funds Other Funds Total Operating Budget $ 1,115,020 2,457,621 3,572,641 $ 197,068 444,288 641,356 $ -9- 179,646 429,598 609,244 17.7 18.1 18.0 % 18.0 21.6 20.4 % Summary Operating Expenditures and Encumbrances As of August 31, 2012 Total General Government Total Criminal Justice 120 40 100 80 (millions of dollars) (millions of dollars) 30 60 40 20 10 20 0 0 July Aug Sept Oct July Aug Sept Oct Nov Dec Jan Feb Mar April May June Current YTD Expenditures Nov Dec Jan Current YTD Expenditures Prior YTD Expenditures Feb Mar April May June Prior YTD Expenditures see Note 1 on page 3 for General Government explanation. 850 825 800 775 750 725 700 675 650 625 600 575 550 525 500 475 450 425 400 375 350 325 300 275 250 225 200 175 150 125 100 75 50 25 0 Total Transportation (millions of dollars) (millions of dollars) Total Public Safety July Aug Sept Oct July Aug Sept Oct Nov Dec Jan Feb Mar April May June Current YTD Expenditures 625 600 575 550 525 500 475 450 425 400 375 350 325 300 275 250 225 200 175 150 125 100 75 50 25 0 Nov Dec Jan Feb Mar April May June Current YTD Expenditures Prior YTD Expenditures - 10 - Prior YTD Expenditures Summary Operating Expenditures and Encumbrances As of August 31, 2012 Total Community Development Total Community Enrichment 210 300 200 280 190 180 260 170 240 160 220 140 (millions of dollars) (millions of dollars) 150 130 120 110 100 90 80 70 60 200 180 160 140 120 100 80 50 40 60 30 40 20 20 10 0 0 July Aug Sept Oct Nov Dec Jan Feb Mar April May June July Aug Sept Oct Current YTD Expenditures Current YTD Expenditures Prior YTD Expenditures 580 560 540 520 500 480 460 440 420 400 380 360 340 320 300 280 260 240 220 200 180 160 140 120 100 80 60 40 20 0 Jan Feb Mar April May June Prior YTD Expenditures Total Debt Service 170 160 150 140 130 120 (millions of dollars) (millions of dollars) Total Environmental Services Nov Dec 110 100 90 80 70 60 50 40 30 20 10 0 July Aug Sept Oct Nov Dec Jan Feb Mar April May June July Aug Sept Oct Nov Dec Jan Feb Mar April May June Current YTD Expenditures Current YTD Expenditures Prior YTD Expenditures - 11 - Prior YTD Expenditures Citywide Detail Revenues Revenues For the Month Ended August 31 2012 2011 Budget Estimate 2012-13 Source Actual Year-to-Date 2012-13 2011-12 Percent of Year-to-Date Estimate Actual 2012-13 2011-12 General Funds $ 34,275,894 47,746 $ 34,239,095 69,095 Local Taxes: Sales Taxes Privilege License Fees $ 432,689,754 2,680,000 $ 68,281,337 95,665 $ 68,114,211 113,319 15.8 % 3.6 16.7 % 4.9 34,323,640 34,308,190 Total Local Taxes 435,369,754 68,377,002 68,227,530 15.7 16.7 8,755,378 12,305,683 3,982,374 8,682,923 10,163,078 3,698,080 State Shared Taxes: State Sales Tax State Income Tax Vehicle License Tax 119,646,000 147,655,000 47,000,000 18,662,378 24,611,367 8,475,374 17,534,923 20,331,199 8,180,080 15.6 16.7 18.0 15.4 16.7 17.6 25,043,435 22,544,081 314,301,000 51,749,119 46,046,202 16.5 16.3 Total State Shared Taxes 785,693 513,540 Primary Property Tax 131,921,000 260,994 361,295 Licenses and Permits 2,897,000 (14,114) Cable Communications 9,385,916 Municipal Court: Fines and Forfeitures Court Default Fee 22,008,875 1,150,000 3,266,846 149,442 23,158,875 1 (150,399) (631,737) (0.1) (0.5) 392,747 513,345 13.6 17.4 (153,636) - (1.6) 3,453,066 141,835 14.8 13.0 16.2 11.7 3,416,288 3,594,901 14.8 15.9 (238) 1,542,900 75,969 1,640,167 73,092 1,618,869 1,713,259 567,234 682,874 Police 12,316,712 1,195,201 1,377,845 9.7 8.8 86,927 101,319 Library Fees 1,313,000 180,476 201,154 13.7 14.7 539,197 929,997 Parks and Recreation 7,888,825 959,035 1,280,576 12.2 19.2 84,133 87,524 217,731 145,988 2,678,816 64,101 1,422,677 3,081,456 65,425 674,059 4,165,594 3,820,940 125,935 58,361 86,238 1,123,053 67,905,621 66,376,307 Total Municipal Court Planning and Development Street Transportation Fire: Emergency Transportation Service Hazardous Materials Inspection Fee Other Total Fire Interest Other Fees and Service Charges Total General Funds - 12 - 894,000 171,644 139,433 19.2 13.2 3,959,982 560,684 739,130 14.2 14.0 41,100,000 1,300,000 11,578,248 5,940,968 104,272 1,566,651 6,104,035 116,961 2,060,046 14.5 8.0 13.5 17.0 8.8 19.2 53,978,248 7,611,891 8,281,042 14.1 17.3 870,000 260,508 140,094 29.9 17.5 12,752,227 1,173,938 1,967,413 9.2 13.1 1,011,006,539 135,897,896 131,723,292 13.4 13.9 Revenues Revenues For the Month Ended August 31 2011 2012 Budget Estimate 2012-13 Source Actual Year-to-Date 2012-13 2011-12 Percent of Year-to-Date Estimate Actual 2012-13 2011-12 Special Revenue Funds and Debt Service $ Neighborhood Protection: Police Neighborhood Protection Police Blockwatch Fire Neighborhood Protection Interest/Other 1,494,750 $ 106,768 533,839 (2,044) 1,487,138 106,224 531,121 63,865 2,133,313 2,188,348 5,076,473 1,871,513 (5,624) 4,967,656 1,811,479 (2,688) 6,942,362 6,776,447 2,156,429 2,166,847 Parks and Preserves 8,541,431 3,020,875 8,497,932 4,777,163 Transit 2000: Sales Taxes Interest/Other 11,562,306 13,275,095 $ Total Neighborhood Protection Public Safety Enhancement & Expansion: Police Fire Interest/Other Total Public Safety Enhancement & Expansion Total Transit 2000 20,280,000 1,449,000 7,243,000 37,000 $ 3,037,241 216,946 1,084,729 34,789 $ 3,000,249 214,304 1,071,518 64,264 15.0 % 15.0 15.0 94.0 16.1 % 16.2 16.2 112.7 29,009,000 4,373,705 4,350,335 15.1 16.4 61,354,000 20,784,000 (35,000) 10,027,511 3,626,786 (10,446) 9,693,014 3,452,801 (4,350) 16.3 17.4 29.8 17.0 17.6 7.8 82,103,000 13,643,851 13,141,465 16.6 17.1 29,472,000 4,380,440 4,375,977 14.9 16.3 115,886,000 53,524,611 17,355,667 7,607,656 17,144,280 7,849,139 15.0 14.2 16.1 15.1 169,410,611 24,963,323 24,993,419 14.7 15.8 Court Awards 11,326,546 3,694,261 2,562,859 Planning and Development 33,990,000 7,068,281 5,529,975 20.8 16.9 1,398,909 1,435,366 Capital Construction 17,405,000 2,809,315 2,885,501 16.1 17.3 835,872 18,853 882,310 32,122 Sports Facilities: Sales Taxes Interest/Other 15,672,000 420,000 1,817,631 37,917 1,844,597 86,825 11.6 9.0 12.6 15.8 854,725 914,432 Total Sports Facilities 16,092,000 1,855,548 1,931,422 11.5 12.7 7,144,460 13,843 - 6,698,651 32,648 73,802 Highway User Revenue: Highway User Revenue Interest Other 101,561,000 350,000 300,000 15,111,460 24,273 - 13,362,651 66,835 77,531 14.9 6.9 - 14.8 23.1 42.7 7,158,303 6,805,101 102,211,000 15,135,733 13,507,017 14.8 14.9 2,077,124 1,931,372 34,489,645 4,487,469 1,924,198 13.0 7.6 114,652 268,398 Community Reinvestment 3,564,321 1,408,954 301,012 39.5 9.4 (352,903) 468,476 Other Restricted Fees 26,785,065 1,275,427 3,435,989 4.8 10.1 - 301,546 Total Highway User Revenue Regional Transit Revenues - 13 - - 301,546 - 3.3 Revenues Revenues For the Month Ended August 31 2011 2012 Budget Estimate 2012-13 Source Actual Year-to-Date 2012-13 2011-12 Percent of Year-to-Date Estimate Actual 2012-13 2011-12 Special Revenue Funds and Debt Service (Cont'd) $ 590,051 5,513,809 498,632 6,602,492 $ 642,366 8,495,035 1,683,970 10,821,371 Grants: Public Housing: Rentals Grants Other $ Total Public Housing Other: Human Resources Federal Transit Administration Community Development Other 6,417,750 74,227,147 4,045,150 $ 1,083,084 9,783,785 (1,473,268) $ 1,088,312 7,823,295 (3,444,587) 16.9 % 13.2 (36.4) 15.9 % 11.0 (74.0) 84,690,047 9,393,601 5,467,020 11.1 6.6 42,898,440 19,321,262 34,362,991 93,468,913 97,929 21,738 4,080,348 9,583,650 4,338,562 1,701,449 3,871,368 1,078,710 0.2 0.1 11.9 10.3 9.1 7.4 22.2 1.2 2,154,320 21,479 86,312 8,373,112 4,557,546 1,701,449 2,023,671 12,331,456 10,635,223 20,614,122 Total Other 190,051,606 13,783,665 10,990,089 7.3 6.3 17,237,715 31,435,493 Total Grants 274,741,653 23,177,266 16,457,109 8.4 6.4 563,678 (1,832) 545,278 (5,538) 561,846 539,740 55,539,042 71,069,520 G.O. Bond Debt Service Secondary Property Tax Interest Total G.O. Bond Debt Service Total Special Revenue and Debt Service 62,961,000 5,188,000 (233,157) (50,372) (862,855) (46,304) (0.4) (1.0) (0.9) (0.9) 68,149,000 (283,529) (909,159) (0.4) (0.9) 898,748,841 104,295,783 92,225,806 11.6 10.6 117,260,000 179,146,000 1,620,000 6,110,500 1,623,000 3,109,000 41,200,000 16,104,008 31,570,678 31,008 494,048 282,000 466,733 5,363,276 14,742,574 33,538,196 238,772 (2,501,909) 274,549 491,758 5,247,217 13.7 17.6 1.9 8.1 17.4 15.0 13.0 16.2 17.3 28.7 (33.9) 16.4 16.6 12.7 350,068,500 54,311,751 52,031,157 15.5 15.3 42,987,000 17,356,485 353,222 5,960,525 1,914,078 38,389 5,924,316 2,192,147 84,538 13.9 11.0 10.9 14.8 13.8 22.7 60,696,707 7,912,992 8,201,001 13.0 14.6 Enterprise Funds AVIATION: 8,227,663 14,795,088 16,405 324,250 143,220 229,346 2,495,413 7,447,142 16,562,893 116,050 (2,682,204) 136,026 239,696 2,584,026 26,231,385 24,403,629 Sky Harbor: Airlines Concessions Interest Other Phoenix-Goodyear Phoenix-Deer Valley Phoenix-Customer Facility Charge Total Aviation CONVENTION CENTER: 2,924,375 733,385 20,195 2,963,893 1,326,880 40,051 3,677,955 4,330,824 Excise Taxes Operating Revenue Interest Total Convention Center - 14 - Revenues Revenues For the Month Ended August 31 2011 2012 Budget Estimate 2012-13 Source Actual Year-to-Date 2012-13 2011-12 Percent of Year-to-Date Estimate Actual 2012-13 2011-12 Enterprise Funds (Cont'd) WATER SYSTEM: $ 40,579,785 $ 542,351 290,707 (69,394) 266,340 144,339 665,240 41,950,442 567,665 293,511 318,804 110,100 202,287 1,173,499 42,419,368 44,616,308 15,052,608 1,581,521 251,488 113,093 1,058,280 16,299,752 1,552,216 92,400 204,444 1,190,155 18,056,990 19,338,967 Water Sales Water Service Fees Distribution Intergovernmental Development Fees Interest Other $ Total Water System 356,625,000 6,010,000 3,190,000 7,651,000 2,000,000 2,707,000 925,000 $ 87,668,119 969,970 1,249,927 1,367,962 469,620 277,687 29,833,405 $ 88,662,233 1,011,710 874,916 1,887,494 321,060 415,530 27,529 24.6 % 16.1 39.2 17.9 23.5 10.3 3,225.2 24.2 % 17.8 29.2 29.7 17.6 21.7 0.9 379,108,000 121,836,690 93,200,472 32.1 24.0 192,582,000 19,206,000 1,800,000 2,001,000 15,518,000 29,888,758 3,168,521 463,860 223,166 1,859,558 32,357,349 3,113,216 298,800 430,948 1,892,528 15.5 16.5 25.8 11.2 12.0 16.6 19.8 17.9 19.5 10.1 231,107,000 35,603,863 38,092,841 15.4 16.4 124,225,000 8,100,000 365,000 12,282,000 20,868,098 1,056,403 59,465 1,323,479 20,668,036 1,460,967 94,678 2,249,039 16.8 13.0 16.3 10.8 16.6 21.3 18.9 17.7 144,972,000 23,307,445 24,472,720 16.1 16.9 WASTEWATER: Sewer Service Charges Multi-City Development Fees Interest Other Total Wastewater SOLID WASTE: 10,427,636 488,273 30,062 1,262,412 10,341,242 810,596 45,658 1,261,641 12,208,383 12,459,137 Collection Fees Landfill Fees Interest Other Total Solid Waste GOLF COURSES: $ 142,637 5,462 123,464 (6,886) 947 123,838 6,249 100,383 (10,741) (2,717) 265,624 217,012 102,859,705 105,365,877 226,304,368 $ 242,811,704 Fees Coffee Shops Concessions Interest Other Total Golf Courses Total Enterprise Funds Total Operating Revenues $ - 15 - 4,118,580 85,060 1,958,500 (126,084) 169,500 323,974 9,827 254,075 (13,661) 11,555 304,762 15,542 225,734 (22,542) 8,488 7.9 11.6 13.0 10.8 6.8 7.7 20.0 11.1 19.8 8.9 6,205,556 585,770 531,984 9.4 8.8 1,172,157,763 243,558,511 216,530,175 20.8 18.5 440,479,273 15.7 % 14.7 % 3,081,913,143 $ 483,752,190 $ Operating Expenditures and Encumbrances For the Month Ended August 31 2012 2011 Budget Estimate 2012-13 Program Actual Year-to-Date 2012-13 2011-12 2012-13 Year-to-Date Operating Expenditures & Encumbrances Capital Operations and Debt General Government $ 179,637 $ 267,487 253,450 2,907,033 75,598 221,809 214,476 1,601,376 120,877 462,215 2,572 954,009 (109,263) 6,940 292,810 1,456,080 743,483 9,650,589 108,644 281,928 249,584 4,620,064 99,156 252,071 230,996 1,619,897 132,896 372,011 149,258 883,904 30,559 9,580 274,994 1,507,743 367,153 11,190,438 Mayor City Council City Manager Information Technology Services Government Relations Public Information Equal Opportunity Law City Auditor City Clerk Elections Human Resources Retirement Systems Phoenix Employment Relations Board Budget and Research Finance Regional Wireless Cooperative Total General Government $ 1,692,427 3,645,603 2,586,241 37,158,029 1,265,498 2,749,291 2,868,513 20,780,565 2,367,167 5,334,050 812,985 11,970,394 113,144 3,006,705 20,557,525 4,462,701 $ 310,445 524,790 510,880 5,605,488 152,229 445,449 439,629 3,568,690 584,525 715,761 189,252 1,879,845 60,609 13,329 652,704 3,130,912 (498,364) $ 200,793 557,817 536,578 6,399,901 384,434 487,495 446,493 3,294,640 727,398 660,973 515,428 1,685,213 (5,720) 20,698 615,033 3,123,283 (674,599) $ 310,445 524,790 510,880 5,396,120 152,229 445,449 439,629 3,568,690 584,525 715,761 189,252 1,702,860 60,609 13,329 652,704 3,100,153 (498,364) $ 209,368 176,985 30,759 - 121,370,838 18,286,173 18,975,858 17,869,061 417,112 43,437,077 4,780,377 6,903,399 801,843 6,033,096 768,585 5,864,485 801,843 1,038,914 - 48,217,454 7,705,242 6,801,681 6,666,328 1,038,914 576,653,193 290,718,478 1,402,594 99,533,687 50,062,623 152,380 97,296,779 44,931,457 78,085 98,605,546 49,652,168 152,380 928,141 410,455 - 868,774,265 149,748,690 142,306,321 148,410,094 1,338,596 Criminal Justice 3,066,493 392,195 2,579,420 404,522 3,458,688 2,983,942 Municipal Court Public Defender Total Criminal Justice Public Safety 49,378,008 24,427,792 37,830 47,338,218 22,311,360 31,801 73,843,630 69,681,379 Police Fire Other Total Public Safety - 16 - Operating Expenditures and Encumbrances For the Month Ended August 31 2012 2011 Budget Estimate 2012-13 Program Actual Year-to-Date 2012-13 2011-12 2012-13 Year-to-Date Operating Expenditures & Encumbrances Capital Operations and Debt Transportation $ 5,743,893 958,681 21,382,745 86,749,007 114,834,326 $ 4,385,964 628,828 20,415,318 12,059,804 37,489,914 Street Transportation Street Lighting Aviation Public Transit Total Transportation $ 61,570,685 11,014,510 296,142,386 257,470,874 $ 11,193,291 1,746,122 41,980,773 161,340,376 $ 9,033,155 1,527,754 37,920,620 161,521,863 $ 11,080,399 1,746,122 32,914,478 151,204,737 $ 112,892 9,066,295 10,135,639 626,198,455 216,260,562 210,003,392 196,945,736 19,314,826 Community Development 2,900,600 6,805,366 3,672,418 6,112,468 2,780,689 6,235,703 2,045,333 3,611,318 Planning and Development Housing Economic Development Neighborhood Services Department 39,700,228 82,942,907 43,484,725 80,022,667 5,705,872 13,669,540 7,685,231 12,150,927 5,494,673 12,300,992 4,331,128 6,841,910 5,705,872 13,657,730 4,035,171 12,150,927 11,810 3,650,060 - 19,490,852 14,673,043 Total Community Development 246,150,527 39,211,570 28,968,703 35,549,700 3,661,870 98,145,384 36,552,016 8,181,541 80,892,732 12,330,577 62,617,917 3,775,655 1,227,764 19,674,675 5,455,852 1,301,802 15,888,257 1,983,878 8,419,346 476,780 663,654 18,395,342 4,722,230 1,414,036 15,598,580 1,328,203 10,675,923 568,496 268,126 19,364,553 5,455,852 1,301,052 12,789,616 8,372,730 476,780 663,654 310,122 750 3,098,641 1,983,878 46,616 - 303,723,586 53,864,244 52,970,936 48,424,237 5,440,007 Community Enrichment 9,528,442 3,102,125 713,401 3,195,188 992,700 3,902,843 320,550 298,538 9,379,342 2,589,621 796,238 4,968,145 664,570 4,954,741 333,319 195,459 22,053,787 23,881,435 Parks and Recreation Library Golf Convention Center Sports and Cultural Facilities Human Services Public Parking Facilities Other Total Community Enrichment - 17 - Operating Expenditures and Encumbrances For the Month Ended August 31 2012 2011 Budget Estimate 2012-13 Program 2012-13 Year-to-Date Operating Expenditures & Encumbrances Capital Operations and Debt Actual Year-to-Date 2012-13 2011-12 Environmental Services $ 22,033,156 11,553,771 10,671,916 2,295,146 117,253 46,671,242 $ 24,626,093 12,704,331 9,120,787 1,874,722 130,084 48,456,017 Water System Wastewater Solid Waste Management Public Works Environmental Programs $ Total Environmental Services 305,978,438 164,779,934 137,297,120 22,491,280 1,467,646 $ 632,014,418 60,096,288 22,373,016 26,314,161 3,997,340 327,379 $ 48,086,868 24,293,731 16,692,441 3,333,188 279,436 $ 29,225,126 12,052,413 24,157,962 3,055,461 327,379 $ 68,818,341 30,871,162 10,320,603 2,156,199 941,879 - 113,108,184 92,685,664 44,289,843 1,104,655 12,586,976 22,011,525 235,585 4,834,585 676,265 4,672,507 845,364 7,485,581 7,623,820 1,058,524 21,334,286 50,200 8,322,272 1,849,762 6,317,402 (59,195,407) 1,847,394 27,545,652 27,987,298 225,213 7,342,210 184,104 1,948,590 2,231,771 45,890 790,539 64,471 533,449 105,142 772,186 1,132,860 84,665 2,470,503 8,367 1,042,859 217,112 829,423 78,867 4,410,747 4,573,019 37,535 1,170,016 219,176 2,046,304 3,290,364 35,227 684,131 111,961 686,576 112,907 1,545,466 1,180,769 154,920 4,182,753 8,367 1,338,952 259,922 862,553 1,620 307,646 5,273,238 4,634,182 51,069 1,165,665 - 184,104 1,948,590 2,231,771 45,890 790,539 64,471 533,449 105,142 772,186 1,132,860 84,665 2,470,503 8,367 1,042,859 217,112 829,423 78,867 4,410,747 4,573,019 37,535 1,170,016 General Obligation Debt Service 92,052 974,295 1,115,885 22,945 395,270 32,235 266,724 52,571 386,093 566,430 42,332 1,235,252 4,184 521,430 108,556 414,711 39,434 2,205,374 2,286,510 18,767 584,666 109,588 1,023,152 1,645,182 17,613 342,066 55,981 343,288 56,453 772,733 590,384 77,460 2,091,376 4,184 669,476 129,961 431,276 1,620 153,823 2,636,619 2,317,091 25,535 582,467 11,365,716 14,077,328 Total Debt Service 106,761,669 22,732,115 28,153,768 - 22,732,115 10,964,442 10,249,671 Capital Improvement 529,221,454 20,439,056 28,377,979 - 20,439,056 $ 312,333,272 $ 232,683,167 Aviation Cultural Facilities Downtown Development Early Redemption Economic Development Fire Protection Freeway Mitigation Historic/Neighborhood Preservation Human Services Information Systems Libraries Maintenance Service Centers Mountain Preserves/Parks Municipal Administration Buildings Police Protection Public Housing Renovation Sanitary Sewers Secondary Property Tax Solid Waste Enterprise Bonds Storm Sewer Improvements Street Improvements Street Light Refinancing Water System 90,208,390 Contingencies Total Operating Budget $ 3,572,641,056 - 18 - $ 641,355,836 $ 609,244,302 $ 522,683,497 $ 118,672,339 Capital Expenditures and Encumbrances For the Month Ended August 31 2012 2011 $ $ 2012-13 Program 51,879 $ 7,507,906 14,720 547,013 309,805 430,968 8,456,024 107,247 325,078 1,800,002 Arts and Cultural Facilities Aviation Economic Development Energy Conservation Facilities Management 2,048,105 35,857 4,572,604 118,963 22,379 4,834,383 Fire Protection Historic Preservation Housing (694,140) 264,350 1,066,087 93,558 Human Services Information Technology Libraries Neighborhood Services 322,703 3,353,139 39,004 821,921 2,161,352 1,086 237,843 434,743 4,280 1,605,430 787,337 3,879,996 106,162 1,425,417 1,969,550 7,343,203 12,962 357 37,967 73,230 26,026,215 $ 30,504,255 Capital Expenditures and Encumbrances Budget $ 8,738,512 $ 256,370,044 6,332,221 6,118,898 13,753,000 2011-12 Actual Yearto-Date Actual Yearto-Date 7,129,396 $ 20,154,613 296,954 1,043,510 361,461 6,532,513 40,954,029 642,579 978,214 2,301,717 2012-13 Year-to-Date Capital Amounts From Operating Funds From Capital Funds Budget Actual Budget Actual $ 5,963,000 $ 73,637,378 6,309,421 6,118,898 5,335,000 2,267,088 297,674 1,043,510 82,863 7,652,949 166,649 8,307,653 950,000 4,759 31,833,284 (684,760) 876,464 1,382,635 191,974 $ Unencumbered Budget 2,775,512 $ 182,732,666 22,800 8,418,000 7,129,396 17,887,525 (720) 278,598 $ 1,609,116 236,215,431 6,035,267 5,075,388 13,391,539 4,424,325 8,030,100 2,792,402 27,163,374 2,174,574 920,034 2,516,314 6,805,526 1,877,127 52,056,019 7,700,041 281,000 2,695,000 124 39,523 44,703 1,928,486 842,154 2,063,400 4,523,347 62,288 276,932 64,964 83,159 1,866,198 8,265,139 2,239,913 7,090,485 8,980,100 2,797,161 58,996,658 2,174,574 920,034 6,940,639 1,928,486 8,542,195 2,344,400 7,218,347 62,288 277,056 104,487 127,862 Parks and Mountain Preserves Phoenix Convention Center Police Protection Public Transit 85,424,176 3,119,967 16,729,321 122,393,928 473,926 3,414,197 67,723 1,411,736 3,351,427 3,409 530,995 1,408,068 53,350,342 3,003,572 50,008,360 471,315 21,898 1,093,005 32,073,834 116,395 16,729,321 72,385,568 2,611 3,392,299 67,723 318,731 84,950,250 (294,230) 16,661,598 120,982,192 Solid Waste Disposal Street Transportation & Drainage Wastewater Water System 18,906,108 197,733,383 180,110,892 171,152,743 10,469 5,230,198 1,359,773 7,144,706 124,851 9,931,907 2,895,227 11,724,249 11,711,000 73,581,360 74,706,298 122,032,741 9,939 3,718,709 1,055,541 5,868,839 7,195,108 124,152,023 105,404,594 49,120,002 530 1,511,489 304,232 1,275,867 18,895,639 192,503,185 178,751,119 164,008,037 Total Capital Improvement Program $ 1,177,690,540 $ 58,705,602 $ - 19 - 99,272,749 $ 529,221,454 $ 20,439,056 $ 648,469,086 $ 38,266,546 $ 1,118,984,938 Bonds Authorized and Sold As of August 31 (dollars in thousands) Authorized Sold Available 1988 Authorizations General Obligation Bonds Freeway Mitigation, Neighborhood Stabilization, and Slum and Blight Elimination Bonds Fully Issued $ Total General Obligation Bonds Revenue Bonds Bonds Fully Issued Total 1988 Authorizations 29,285 884,175 $ 28,285 884,175 $ 1,000 - 913,460 912,460 1,000 143,890 143,890 - 1,057,350 1,056,350 1,000 66,300 125,300 24,800 61,500 12,000 33,000 91,500 74,000 77,000 78,800 66,000 43,700 64,600 124,685 24,170 60,700 11,205 32,100 89,275 71,645 72,575 77,685 65,950 43,700 1,700 615 630 800 795 900 2,225 2,355 4,425 1,115 50 - 753,900 738,290 15,610 81,000 11,100 198,700 12,800 104,622 74,705 29,178 115,500 107,295 78,200 65,400 63,385 8,510 190,610 8,345 85,510 61,200 21,100 102,290 81,900 58,135 61,770 17,615 2,590 8,090 4,455 19,112 13,505 8,078 13,210 25,395 20,065 3,630 878,500 742,755 135,745 2001 Authorization General Obligation Bonds Education, Youth and Family Cultural Facilities Computer Technology Environmental Cleanup Fire Protection Historic Preservation Library Facilities Street Improvements Neighborhood Protection and Senior Centers Parks, Open Space, and Recreational Facilities Police Protection Storm Sewer and Flood Protection Bonds Fully Issued Total 2001 Authorizations 2006 Authorization General Obligation Bonds Affordable Housing and Neighborhood Revitalization Computer Technology Education and Health Science Facilities Environmental Cleanup Family, Senior, and Youth Cultural Facilities Fire Protection Library Facilities and Improvements Parks, Open Space, and Recreational Facilities Police Protection Street Improvements Storm Sewer and Flood Protection Total 2006 Authorizations Total Bond Program $ 2,689,750 - 20 - $ 2,537,395 $ 152,355