City of Phoenix, Arizona Monthly Financial Report July 2013 Monthly Financial Report – July 2013 Executive Summary Budget • The budget amounts in this report represent the official adopted budget, as approved by the City Council, for fiscal year 2013-14. Revenues • Local Taxes and the City’s portion of State Shared Taxes comprise the major portion, approximately 75 percent, of estimated General Fund revenues. July 2013 local sales tax revenues were $2.4 million higher than the prior July, an increase of 6.9%. State Shared Taxes were $1.8 million higher compared to the same period in the prior year, an increase of 6.7%. Overall, General Fund revenues for July 2013 are 6.2% higher than July 2012. (see page 2) • The Special Revenue and Debt Service funds revenues were $4.4 million higher in July 2013 than in July 2012, a 9.1% increase. (see page 7) • July 2013 Aviation Enterprise Fund operating revenues were $3.0 million higher than July 2012, a 10.5% increase. Not including the water department sale of property in McMullen Valley for $29.7 million in July 2012, the operating revenues for the other enterprise funds were stable for July 2013 as compared to July 2012. (see page 7) Expenditures • General Fund expenditures for July 2013 are $10.3 million more than they were in July 2012, a 10.4% increase. Increased personnel costs, particularly in Public Safety, and costs related to technology acquisitions in Finance and Information Technology Services accounted for the majority of the increase. • Citywide operating expenditures for July 2013 are $67.3 million more than the prior July, a 20.4% increase. (See pages 5 & 9) Along with the increase in the General Fund expenditures, transportation costs were significantly higher. This is primarily due to the timing of the encumbering of the Veolia bus services contract. The full amount of the annual Veolia contract was encumbered in July 2013, but that action did not take place until August in the prior year. -1- General Funds Summary Summary General Funds As of July 31 (dollars in thousands) Budget Estimate 2013-14 Actual Year-to-Date 2013-14 2012-13 % of Year-to-Date Estimate Actual 2013-14 2012-13 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 $ $ 442,309 2,363 36,360 $ 63 34,005 48 127,448 160,852 51,150 142,849 2,830 9,525 10,309 13,440 4,752 (783) 156 (2) 9,907 12,306 4,493 (936) 132 - 8.1 8.4 9.3 (0.5) 5.5 - 8.3 8.3 9.3 (0.7) 4.9 - 19,312 1,210 13,295 1,362 7,912 1,058 4,105 1,680 66 689 92 741 123 360 1,724 73 628 93 420 87 343 8.7 5.5 5.2 6.8 9.4 11.6 8.8 9.1 6.8 5.0 9.3 5.1 7.0 8.2 37,900 12,451 2,200 11,658 2,576 116 102 1,353 3,262 184 135 1,088 6.8 0.9 4.6 11.6 9.7 1.5 9.4 7.9 1,051,789 $ $ 72,193 $ -2- 67,992 8.2 % 2.7 6.9 % 8.3 % 2.0 7.0 % Summary General Funds As of July 31 (dollars in thousands) Budget Estimate 2013-14 Actual Year-to-Date 2013-14 2012-13 % of Year-to-Date Estimate Actual 2013-14 2012-13 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,755 3,590 2,339 32,781 2,319 2,367 19,542 2,389 5,797 10,225 3,054 18,061 2,213 106,432 $ 150 $ 284 265 3,694 289 216 1,958 495 255 832 387 2,683 321 11,829 131 257 233 2,564 200 189 1,848 464 239 821 360 1,441 439 9,186 8.5 % 7.9 11.3 11.3 12.5 9.1 10.0 20.7 4.4 8.1 12.7 14.9 14.5 11.1 7.8 % 8.0 12.1 7.8 8.2 8.4 9.3 23.8 5.1 8.4 12.3 8.8 17.7 9.0 29,395 4,903 34,298 3,275 378 3,653 3,093 410 3,503 11.1 7.7 10.7 10.8 8.6 10.5 462,407 250,693 22 713,122 43,763 24,014 1 67,778 39,854 22,245 62,099 9.5 9.6 4.5 9.5 9.0 9.3 2.0 9.1 Transportation Street Transportation Public Transit Total Transportation 22,097 19,520 41,617 1,848 3,934 5,782 5,611 1,685 7,296 8.4 20.2 13.9 29.9 8.7 19.1 Community Development Economic Development Neighborhood Services Department Planning and Development Others Total Community Development 5,134 12,337 5,026 54 22,551 664 1,186 439 4 2,293 353 903 441 4 1,701 12.9 9.6 8.7 7.4 10.2 8.4 7.9 10.2 8.3 8.5 Community Enrichment Parks and Recreation Library Human Services Others Total Community Enrichment 94,371 35,478 18,711 2,942 151,502 9,858 2,810 2,564 673 15,905 9,389 2,298 2,380 405 14,472 10.4 7.9 13.7 22.9 10.5 10.7 6.8 13.4 17.6 10.2 Environmental Services Public Works Environmental Programs Total Environmental Services 16,554 984 17,538 2,691 63 2,754 1,190 160 1,350 16.3 6.4 15.7 8.2 20.1 8.8 Public Safety Police Fire Others Total Public Safety Capital Improvement 2,442 Contingencies Total Expenditures and Encumbrances 5 38,313 $ 1,127,815 $ -3- 38 - - 109,999 $ 99,645 0.2 1.2 - - 9.8 % 9.6 % Citywide Summary Comparison to Prior Year Revenues YEAR-TO-DATE REVENUES As of July 31, 2013 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 July 31 decreased by $18,435,222 to $239,012,600 from the $257,447,822 collected during the same period last year, a decrease of 7.2%. For the current year, 7.7% of the total estimated revenue has been collected. Of the total revenues received last year, 8.3% had been collected as of July 31. -4- Comparison to Prior Year Operating Expenditures YEAR-TO-DATE OPERATING EXPENDITURES (millions of dollars) As of July 31, 2013 3,300 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 July 31 increased $67,296,993 to $396,319,557 from the $329,022,564 spent during the same period last year, an increase of 20.5%. For the current year, 11.3% of the total appropriations has been spent. Of the total actual expenditures for last year, 10.5% had been spent as of July 31. -5- Comparison to Prior Year Capital Expenditures YEAR-TO-DATE CAPITAL EXPENDITURES As of July 31, 2013 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 July 31 increased $11,601,102 to $44,280,489 from the $32,679,387 spent during the same period last year, an increase of 35.5%. For the current year, 3.7% of the total appropriations has been spent. Of the total actual expenditures for last year, 4.4% had been spent as of July 31. -6- Summary Operating Revenues As of July 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 $ 442,309 2,363 $ 34,005 48 10,309 13,440 4,752 (783) 156 (2) 1,746 689 92 741 123 360 2,692 102 1,353 9,907 12,306 4,493 (936) 132 1,797 628 93 420 87 343 3,446 135 1,088 8.1 8.4 9.3 (0.5) 5.5 8.5 5.2 6.8 9.4 11.6 8.8 5.3 4.6 11.6 8.3 8.3 9.3 (0.7) 4.9 9.0 5.0 9.3 5.1 7.0 8.2 7.5 9.4 7.9 72,193 67,992 6.9 7.0 30,240 85,231 30,399 8,060 171,171 15,377 36,720 17,226 15,829 100,600 41,867 4,862 31,369 288,554 40,581 2,455 7,225 2,433 265 15,010 7,518 1,305 959 7,667 2,097 17 2,939 4,109 (480) 2,240 6,702 2,224 320 13,401 3,374 1,410 1,001 7,978 2,410 1,294 1,628 5,940 (845) 8.1 8.5 8.0 3.3 8.8 20.5 7.6 6.1 7.6 5.0 0.3 9.4 1.4 (1.2) 8.1 8.4 8.0 3.8 8.2 8.3 8.6 6.6 8.1 10.1 26.7 4.0 2.0 (1.3) 918,086 53,519 49,077 5.8 5.3 309,343 60,544 407,749 211,312 145,755 31,036 4,004 49,017 17,633 11,611 28,081 4,235 79,417 17,547 11,099 10.0 6.6 12.0 8.3 8.0 8.1 7.1 18.7 8.1 7.7 1,134,703 113,301 140,379 10.0 11.8 239,013 $ 257,448 1,051,789 Special Revenue and Debt Service Funds Neighborhood Protection Public Safety Enhancement & Expansion Parks and Preserves Golf Courses 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/Secondary Property Tax Total Special Revenue and Debt Service Funds Enterprise Funds Aviation Convention Center Water System Wastewater Solid Waste Total Enterprise Funds $ % of Year-to-Date Estimate Actual 2013-14 2012-13 36,360 $ 63 127,448 160,852 51,150 142,849 2,830 9,525 20,522 13,295 1,362 7,912 1,058 4,105 50,351 2,200 11,658 Total General Funds Total Operating Revenues Actual Year-to-Date 2013-14 2012-13 Budget Estimate 2013-14 3,104,578 -7- $ 8.2 % 2.7 7.7 % 8.3 % 2.0 8.3 % Summary Operating Revenues As of July 31, 2013 General Funds Local Taxes General Funds State Shared Taxes 450 350 400 300 350 250 (millions of dollars) (millions of dollars) 300 250 200 150 200 150 100 100 50 50 0 0 July Sept Nov Jan Current YTD Revenues Mar May July Prior YTD Revenues Sept Nov Jan Current YTD Revenues Total General Funds Revenues Mar May Prior YTD Revenues Highway User Revenues 110 1,200 100 1,000 90 80 (millions of dollars) (millions of dollars) 800 600 400 70 60 50 40 30 20 200 10 0 0 July Sept Nov Jan Current YTD Revenues Mar July May Sept Nov Current YTD Revenues Prior YTD Revenues -8- Jan Mar May Prior YTD Revenues Summary Operating Expenditures and Encumbrances As of July 31 (dollars in thousands) Source General Government General Funds Other Funds Total General Government Actual Year-to-Date 2013-14 2012-13 Budget 2013-14 $ Criminal Justice General Funds Other Funds Total Criminal Justice 106,432 13,849 120,281 $ 11,829 $ 128 11,957 % of Year-to-Date Estimate Actual 2013-14 2012-13 9,186 (550) 8,636 11.1 % 0.9 9.9 9.0 % 7.6 34,298 12,573 46,871 3,653 901 4,554 3,503 744 4,247 10.7 7.2 9.7 10.5 9.5 10.3 Public Safety General Funds Other Funds Total Public Safety 713,122 171,219 884,341 67,778 13,742 81,520 62,099 13,806 75,905 9.5 8.0 9.2 9.1 8.8 9.0 Transportation General Funds Other Funds Total Transportation 41,617 595,272 636,889 5,782 175,601 181,383 7,296 94,130 101,426 13.9 29.5 28.5 19.1 17.3 17.4 Community Development General Funds Other Funds Total Community Development 22,551 206,080 228,631 2,293 17,644 19,937 1,701 18,020 19,721 10.2 8.6 8.7 8.5 9.5 9.4 Community Enrichment General Funds Other Funds Total Community Enrichment 151,502 136,700 288,202 15,905 9,935 25,840 14,472 17,338 31,810 10.5 7.3 9.0 10.2 13.1 11.6 Environmental Services General Funds Other Funds Total Environmental Services 17,538 610,730 628,268 2,754 45,216 47,970 1,350 65,087 66,437 15.7 7.4 7.6 8.8 11.9 11.8 52,455 52,455 8,399 8,399 11,366 11,366 16.0 16.0 8.3 8.3 2,442 528,263 530,705 5 14,755 14,760 38 9,437 9,475 0.2 2.8 2.8 1.2 2.6 2.6 38,313 47,550 85,863 - - - - Debt Service General Funds Other Funds Total Debt Service Capital Improvement General Funds Other Funds Total Capital Improvement Contingencies General Funds Other Funds Total Contingencies Total Operating General Funds Other Funds Total Operating Budget $ 1,127,815 2,374,691 3,502,506 $ 109,999 286,321 396,320 $ -9- 99,645 229,378 329,023 9.8 12.1 11.3 % 9.6 11.0 10.5 % Summary Operating Expenditures and Encumbrances As of July 31, 2013 Total General Government Total Criminal Justice 120 50 100 40 (millions of dollars) (millions of dollars) 80 60 40 30 20 10 20 0 0 July Sept Nov Jan Current YTD Expenditures Mar July May Sept (millions of dollars) (millions of dollars) Nov Jan Current YTD Expenditures Mar May Prior YTD Expenditures Total Transportation 900 875 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 Sept Jan Current YTD Expenditures Prior YTD Expenditures Total Public Safety July Nov Mar 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 July May Sept Nov Jan Current YTD Expenditures Prior YTD Expenditures - 10 - Mar May Prior YTD Expenditures Summary Operating Expenditures and Encumbrances As of July 31, 2013 Total Community Development Total Community Enrichment 220 300 280 260 240 220 160 150 140 130 120 110 100 90 200 (millions of dollars) (millions of dollars) 210 200 190 180 170 80 70 60 50 40 30 20 10 180 160 140 120 100 80 60 40 20 0 0 July Sept Nov Jan Current YTD Expenditures Mar May July Nov Jan Current YTD Expenditures Prior YTD Expenditures Total Environmental Services Mar May Prior YTD Expenditures Total Debt Service 600 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 150 140 130 120 110 100 (millions of dollars) (millions of dollars) Sept 90 80 70 60 50 40 30 20 10 0 July Sept Nov Current YTD Expenditures Jan Mar July May Sept Nov Current YTD Expenditures Prior YTD Expenditures - 11 - Jan Mar May Prior YTD Expenditures Citywide Detail Revenues Revenues For the Month Ended July 31 2013 2012 Budget Estimate 2013-14 Source Percent of Year-to-Date Estimate Actual 2013-14 2012-13 Actual Year-to-Date 2013-14 2012-13 General Funds $ 36,360,140 63,074 $ 34,005,443 47,919 Local Taxes: Sales Taxes Privilege License Fees $ 442,309,000 2,363,000 $ 36,360,140 63,074 $ 34,005,443 47,919 8.2 % 2.7 8.3 % 2.0 36,423,214 34,053,362 Total Local Taxes 444,672,000 36,423,214 34,053,362 8.2 8.3 10,309,000 13,440,181 4,751,835 9,907,000 12,305,684 4,493,000 State Shared Taxes: State Sales Tax State Income Tax Vehicle License Tax 127,448,000 160,852,000 51,150,000 10,309,000 13,440,181 4,751,835 9,907,000 12,305,684 4,493,000 8.1 8.4 9.3 8.3 8.3 9.3 28,501,016 26,705,684 339,450,000 28,501,016 26,705,684 8.4 8.5 Total State Shared Taxes (782,966) (936,092) Primary Property Tax 142,849,000 155,978 131,753 Licenses and Permits 2,830,000 Cable Communications 9,525,232 Municipal Court: Fines and Forfeitures Court Default Fee 19,312,290 1,210,000 1,680,173 65,879 20,522,290 (2,001) (239) 1,680,173 65,879 1,723,946 73,473 1,746,052 1,797,419 688,463 627,967 92,085 93,549 740,726 419,838 122,967 87,511 359,475 342,953 2,576,541 25,500 90,237 3,262,152 40,171 143,974 2,692,278 3,446,297 102,434 134,573 1,353,012 1,087,700 72,192,733 67,992,275 Total Municipal Court Police (782,966) (936,092) (0.5) (0.7) 155,978 131,753 5.5 4.9 - - 1,723,946 73,473 8.7 5.4 9.1 6.8 1,746,052 1,797,419 8.5 9.0 (2,001) (239) 13,294,540 688,463 627,967 5.2 5.0 Library Fees 1,362,000 92,085 93,549 6.8 9.3 Parks and Recreation 7,911,605 740,726 419,838 9.4 5.1 Planning and Development 1,058,400 122,967 87,511 11.6 7.0 Street Transportation 4,105,000 359,475 342,953 8.8 8.2 37,900,000 1,150,000 11,300,885 2,576,541 25,500 90,237 3,262,152 40,171 143,974 6.8 2.2 0.8 9.7 3.3 1.3 50,350,885 2,692,278 3,446,297 5.3 7.5 2,200,000 102,434 134,573 4.7 9.4 11,658,450 1,353,012 1,087,700 11.6 7.9 1,051,789,402 72,192,733 67,992,275 6.9 7.0 Fire: Emergency Transportation Service Hazardous Materials Inspection Fee Other Total Fire Interest Other Fees and Service Charges Total General Funds - 12 - Revenues Revenues For the Month Ended July 31 2013 2012 Budget Estimate 2013-14 Source Percent of Year-to-Date Estimate Actual 2013-14 2012-13 Actual Year-to-Date 2013-14 2012-13 Special Revenue and Debt Service Funds $ 1,694,496 121,035 605,177 33,903 $ 1,542,491 110,178 550,890 36,833 2,454,611 2,240,392 5,355,188 1,876,640 (7,153) 4,951,038 1,755,273 (4,822) 7,224,675 6,701,489 2,433,105 2,224,011 147,654 4,094 114,850 (3,893) 2,708 181,337 4,365 130,611 (6,775) 10,608 265,413 320,146 9,682,834 5,327,237 8,814,236 4,586,781 15,010,071 13,401,017 - - Neighborhood Protection: Police Neighborhood Protection Police Blockwatch Fire Neighborhood Protection Interest/Other $ Total Neighborhood Protection Public Safety Enhancement & Expansion: Police Fire Interest/Other Total Public Safety Enhancement & Expansion Parks and Preserves Golf Courses: Fees Coffee Shops Concessions Interest Other Total Golf Courses Transit 2000: Sales Taxes Interest/Other Total Transit 2000 21,066,000 1,505,000 7,523,000 145,500 $ 1,694,496 121,035 605,177 33,903 $ 1,542,491 110,178 550,890 36,833 8.0 % 8.0 8.0 23.3 8.0 % 8.0 8.0 24.1 30,239,500 2,454,611 2,240,392 8.1 8.1 63,718,000 21,578,000 (65,000) 5,355,188 1,876,640 (7,153) 4,951,038 1,755,273 (4,822) 8.4 8.7 11.0 8.3 8.6 6.2 85,231,000 7,224,675 6,701,489 8.5 8.4 30,399,000 2,433,105 2,224,011 8.0 8.0 5,427,300 271,360 2,331,200 (81,040) 111,731 147,654 4,094 114,850 (3,893) 2,708 181,337 4,365 130,611 (6,775) 10,608 2.7 1.5 4.9 4.8 2.4 3.2 1.5 5.6 9.5 9.2 8,060,551 265,413 320,146 3.3 3.8 120,380,000 50,791,438 9,682,834 5,327,237 8,814,236 4,586,781 8.0 10.5 8.0 8.6 171,171,438 15,010,071 13,401,017 8.8 8.2 - - Court Awards 15,376,764 7,517,988 3,374,020 Planning and Development 36,720,200 7,517,988 3,374,020 20.5 8.3 1,304,816 1,410,406 Capital Construction 17,226,000 1,304,816 1,410,406 7.6 8.6 947,128 12,270 981,759 19,064 Sports Facilities: Sales Taxes Interest/Other 15,564,000 265,000 947,128 12,270 981,759 19,064 6.1 4.6 6.6 5.1 959,398 1,000,823 15,829,000 959,398 1,000,823 6.1 6.6 Total Sports Facilities - 13 - - - Revenues Revenues For the Month Ended July 31 2013 2012 Budget Estimate 2013-14 Source Actual Year-to-Date 2013-14 2012-13 Percent of Year-to-Date Estimate Actual 2013-14 2012-13 Special Revenue and Debt Service Funds (Cont'd) $ Highway User Revenue: Highway User Revenue Interest Other 7,652,000 13,325 1,398 7,967,000 10,430 - 7,666,723 7,977,430 2,097,199 2,410,345 Regional Transit Revenues 16,464 1,294,302 Community Reinvestment 2,939,393 1,628,330 Other Restricted Fees 449,807 2,194,487 247,262 $ 493,033 4,269,976 (1,971,900) 2,891,556 2,791,109 (2,412,831) 2 4,559,596 (929,013) (2,056,391) 259 3,994,036 1,210,538 1,217,754 3,148,442 4,109,310 5,939,551 (477,241) (3,349) (480,590) 53,518,576 (796,835) (48,540) (845,375) 49,076,887 Total Highway User Revenue Grants: Public Housing: Rentals Grants Other $ Total Public Housing 100,150,000 250,000 200,000 7,652,000 13,325 1,398 7,967,000 10,430 - 7.6 5.3 0.7 8.1 5.9 - 100,600,000 7,666,723 7,977,430 7.6 8.1 41,867,049 2,097,199 2,410,345 5.0 10.1 4,861,901 16,464 1,294,302 0.3 26.7 31,368,544 2,939,393 1,628,330 9.4 4.0 6,952,965 73,208,080 5,269,398 $ 449,807 2,194,487 247,262 $ 493,033 4,269,976 (1,971,900) 6.5 % 3.0 4.7 7.1 % 6.1 (81.8) 85,430,443 2,891,556 2,791,109 3.4 3.5 42,441,013 59,918,966 33,269,864 67,493,613 (2,412,831) 2 4,559,596 (929,013) (2,056,391) 259 3,994,036 1,210,538 (5.7) 13.7 (1.4) (4.9) 25.9 1.2 Total Other 203,123,456 1,217,754 3,148,442 0.6 1.5 Total Grants 288,553,899 4,109,310 5,939,551 1.4 2.0 (796,835) (48,540) (1.3) (0.1) (1.3) (1.0) (845,375) Other: Human Resources Federal Transit Administration Community Development Other G.O. Bond/Secondary Property Tax Secondary Property Tax Interest 35,442,800 5,138,000 Total G.O. Bond/Secondary Property Tax 40,580,800 Total Special Revenue and Debt Service Funds (477,241) (3,349) (1.2) (1.3) 918,085,646 53,518,576 (480,590) 49,076,887 5.8 5.3 123,050,000 177,863,000 450,000 3,341,000 1,679,200 2,960,000 - 8,424,300 18,888,646 50,815 261,831 177,526 244,397 2,988,519 7,876,345 16,775,590 14,603 169,798 138,780 237,387 2,867,863 6.8 10.6 11.3 7.8 10.6 8.3 100.0 8.0 8.4 3.1 8.8 7.5 7.7 6.9 309,343,200 31,036,034 28,080,366 10.0 8.1 Enterprise Funds AVIATION: 8,424,300 18,888,646 50,815 261,831 177,526 244,397 2,988,519 7,876,345 16,775,590 14,603 169,798 138,780 237,387 2,867,863 31,036,034 28,080,366 Sky Harbor: Airlines Concessions Interest Other Phoenix-Goodyear Phoenix-Deer Valley Phoenix-Customer Facility Charge Total Aviation - 14 - Revenues Revenues For the Month Ended July 31 2013 2012 Budget Estimate 2013-14 Source Actual Year-to-Date 2013-14 2012-13 Percent of Year-to-Date Estimate Actual 2013-14 2012-13 Enterprise Funds (Cont'd) CONVENTION CENTER: 3,224,745 764,447 14,711 3,036,150 1,180,693 18,194 4,003,903 4,235,037 Excise Taxes Operating Revenue Interest Total Convention Center 43,924,000 16,280,625 338,980 3,224,745 764,447 14,711 3,036,150 1,180,693 18,194 7.3 4.7 4.3 7.4 6.4 7.3 60,543,605 4,003,903 4,235,037 6.6 7.1 WATER SYSTEM: $ 45,994,844 $ 504,828 871,254 1,267,999 293,100 134,091 (49,416) 47,088,334 427,619 959,220 1,437,356 203,280 133,348 29,168,165 49,016,700 79,417,322 Water Sales Water Service Fees Distribution Intergovernmental Development Fees Interest Other $ Total Water System 385,949,000 6,000,000 3,500,000 6,666,000 2,600,000 2,925,000 108,700 $ 45,994,844 504,828 871,254 1,267,999 293,100 134,091 (49,416) $ 47,088,334 427,619 959,220 1,437,356 203,280 133,348 29,168,165 11.9 % 8.4 24.9 19.0 11.3 4.6 (45.5) 12.6 % 7.2 26.9 21.7 8.7 7.1 92.2 407,748,700 49,016,700 79,417,322 12.0 18.7 179,686,000 16,004,000 2,500,000 1,370,000 11,752,000 15,052,242 1,546,000 267,180 87,433 680,723 14,836,150 1,587,000 212,372 110,073 801,278 8.4 9.7 10.7 6.4 5.8 8.2 8.7 9.3 8.3 5.2 211,312,000 17,633,578 17,546,873 8.3 8.1 125,935,000 6,932,000 310,000 12,578,700 10,547,163 763,222 25,085 275,606 10,440,462 568,130 29,403 61,067 8.4 11.0 8.1 2.2 8.3 7.8 8.6 0.6 145,755,700 11,611,076 11,099,062 8.0 7.7 1,134,703,205 113,301,291 140,378,660 10.0 11.8 WASTEWATER: 15,052,242 1,546,000 267,180 87,433 680,723 14,836,150 1,587,000 212,372 110,073 801,278 17,633,578 17,546,873 10,547,163 763,222 25,085 275,606 10,440,462 568,130 29,403 61,067 11,611,076 11,099,062 113,301,291 140,378,660 Sewer Service Charges Multi-City Development Fees Interest Other Total Wastewater SOLID WASTE: $ 239,012,600 $ 257,447,822 Collection Fees Landfill Fees Interest Other Total Solid Waste Total Enterprise Funds Total Operating Revenues $ - 15 - 3,104,578,253 $ 239,012,600 $ 257,447,822 7.7 % 8.3 % Operating Expenditures and Encumbrances For the Month Ended July 31 2013 2012 Budget Estimate 2013-14 Program Actual Year-to-Date 2013-14 2012-13 2013-14 Year-to-Date Operating Expenditures & Encumbrances Capital Operations and Debt General Government $ 149,942 $ 284,381 289,550 3,865,321 81,787 317,995 261,366 2,030,775 495,353 254,950 206,088 941,966 25,619 7,023 386,840 2,999,847 (641,676) 11,957,127 130,808 257,303 257,430 2,698,455 76,631 223,640 225,153 1,967,314 463,648 253,546 186,680 925,836 169,872 6,389 359,894 1,674,832 (1,241,847) 8,635,584 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,755,285 3,589,459 2,663,165 35,059,291 1,304,646 2,660,360 2,796,854 20,550,337 2,389,388 5,797,271 809,263 11,410,338 99,285 3,053,828 21,961,636 4,380,637 $ 149,942 284,381 289,550 3,865,321 81,787 317,995 261,366 2,030,775 495,353 254,950 206,088 941,966 25,619 7,023 386,840 2,999,847 (641,676) $ 130,808 257,303 257,430 2,698,455 76,631 223,640 225,153 1,967,314 463,648 253,546 186,680 925,836 169,872 6,389 359,894 1,674,832 (1,241,847) $ 149,942 284,381 289,550 3,725,001 81,787 317,995 261,366 2,030,775 495,353 254,950 206,088 876,681 25,619 7,023 386,840 2,908,592 (641,676) $ 140,320 65,285 91,255 - 120,281,043 11,957,127 8,635,584 11,660,267 296,860 41,968,415 4,902,494 4,176,213 377,847 3,836,906 409,648 3,657,000 377,847 519,213 - 46,870,909 4,554,060 4,246,554 4,034,847 519,213 585,912,700 297,951,260 476,598 53,795,902 27,672,546 51,348 50,155,679 25,634,831 114,550 53,389,438 27,393,257 51,348 406,464 279,289 - 884,340,558 81,519,796 75,905,060 80,834,043 685,753 Criminal Justice 4,176,213 377,847 3,836,906 409,648 4,554,060 4,246,554 Municipal Court Public Defender Total Criminal Justice Public Safety 53,795,902 27,672,546 51,348 50,155,679 25,634,831 114,550 81,519,796 75,905,060 Police Fire Other Total Public Safety - 16 - Operating Expenditures and Encumbrances For the Month Ended July 31 2013 2012 Budget Estimate 2013-14 Program Actual Year-to-Date 2013-14 2012-13 2013-14 Year-to-Date Operating Expenditures & Encumbrances Capital Operations and Debt Transportation $ 5,328,461 919,328 22,215,126 152,919,852 181,382,767 $ 5,449,398 787,441 20,598,028 74,591,369 101,426,236 Street Transportation Street Lighting Aviation Public Transit Total Transportation $ 59,665,604 11,172,894 305,626,250 260,424,196 $ 5,328,461 919,328 22,215,126 152,919,852 $ 5,449,398 787,441 20,598,028 74,591,369 $ 5,253,655 919,328 17,902,285 152,160,426 $ 74,806 4,312,841 759,426 636,888,944 181,382,767 101,426,236 176,235,694 5,147,073 Community Development 3,669,601 7,303,380 5,059,454 3,904,943 2,805,272 6,864,174 4,012,813 6,038,459 Planning and Development Housing Economic Development Neighborhood Services Department 41,536,572 82,014,323 33,963,216 71,117,238 3,669,601 7,303,380 5,059,454 3,904,943 2,805,272 6,864,174 4,012,813 6,038,459 3,669,601 7,297,033 2,287,014 3,904,943 6,347 2,772,440 - 19,937,378 19,720,718 Total Community Development 228,631,349 19,937,378 19,720,718 17,158,591 2,778,787 102,560,009 35,798,557 8,785,423 61,858,418 10,927,120 62,723,393 3,919,060 1,630,435 10,576,305 2,909,248 661,633 5,174,529 911,678 4,887,465 183,390 535,269 10,146,233 2,353,727 588,401 12,693,069 991,178 4,516,503 156,230 365,116 10,417,966 2,909,248 661,633 3,626,328 4,862,628 183,390 535,269 158,339 1,548,201 911,678 24,837 - 288,202,415 25,839,517 31,810,457 23,196,462 2,643,055 Community Enrichment 10,576,305 2,909,248 661,633 5,174,529 911,678 4,887,465 183,390 535,269 10,146,233 2,353,727 588,401 12,693,069 991,178 4,516,503 156,230 365,116 25,839,517 31,810,457 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 July 31 2013 2012 Budget Estimate 2013-14 Program 2013-14 Year-to-Date Operating Expenditures & Encumbrances Capital Operations and Debt Actual Year-to-Date 2013-14 2012-13 Environmental Services $ 24,112,115 10,655,646 9,910,472 3,168,810 123,206 47,970,249 $ 38,063,132 10,819,245 15,642,245 1,702,194 210,126 66,436,942 Water System Wastewater Solid Waste Management Public Works Environmental Programs $ Total Environmental Services 385,100,042 76,206,190 142,611,487 22,863,808 1,486,777 $ 24,112,115 10,655,646 9,910,472 3,168,810 123,206 $ 38,063,132 10,819,245 15,642,245 1,702,194 210,126 $ 14,560,416 4,917,051 8,827,245 2,739,025 123,206 $ 31,166,943 9,551,699 5,738,595 1,083,227 429,785 - 628,268,304 47,970,249 66,436,942 16,803,306 866,210 9,110,990 8,426,500 337,530 4,614,170 690,670 4,883,650 628,460 7,202,830 7,785,230 1,173,410 14,496,710 50,200 7,264,190 1,279,120 2,866,431 (48,335,390) 938,600 15,486,000 5,480,820 6,810 7,201,708 72,184 759,248 702,208 28,128 384,513 57,555 406,970 52,372 600,234 648,767 97,784 1,207,691 4,183 605,348 106,592 238,768 78,173 1,290,460 456,658 568 600,404 92,052 974,295 1,115,886 22,945 395,269 32,236 266,725 52,571 386,093 566,430 42,333 1,235,251 4,183 521,429 108,556 414,712 39,433 2,205,373 2,286,509 18,768 585,350 - 72,184 759,248 702,208 28,128 384,513 57,555 406,970 52,372 600,234 648,767 97,784 1,207,691 4,183 605,348 106,592 238,768 78,173 1,290,460 456,658 568 600,404 General Obligation Debt Service 72,184 759,248 702,208 28,128 384,513 57,555 406,970 52,372 600,234 648,767 97,784 1,207,691 4,183 605,348 106,592 238,768 78,173 1,290,460 456,658 568 600,404 92,052 974,295 1,115,886 22,945 395,269 32,236 266,725 52,571 386,093 566,430 42,333 1,235,251 4,183 521,429 108,556 414,712 39,433 2,205,373 2,286,509 18,768 585,350 8,398,808 11,366,399 Total Debt Service 52,454,849 8,398,808 11,366,399 - 8,398,808 14,759,855 9,474,614 Capital Improvement 530,704,538 14,759,855 9,474,614 - 14,759,855 $ 396,319,557 $ 329,022,564 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 85,863,000 Contingencies Total Operating Budget $ 3,502,505,909 - 18 - $ 396,319,557 $ 329,022,564 $ 344,286,847 $ 52,032,710 Capital Expenditures and Encumbrances For the Month Ended July 31 2013 2012 $ 35,855 $ 21,558,141 40,329 427,827 (17,080) 4,438,975 546,249 755 1,734,090 352,466 862,710 34,396 96,181 755,381 1,831,255 1,018,531 3,089,773 5,415 2,646,586 2,156,161 2,666,493 $ 44,280,489 $ 7,077,517 12,646,707 282,234 496,497 51,656 126,469 884,177 2,368,035 49,326 276,699 66,520 54,632 151,223 61,058 28,719 589,815 6,189 3,624,768 572,436 3,264,710 32,679,387 Capital Expenditures and Encumbrances 2013-14 Program Arts and Cultural Facilities Aviation Economic Development Energy Conservation Facilities Management Finance Fire Protection Historic Preservation Housing Human Services Information Technology Libraries Neighborhood Services Budget $ Parks and Mountain Preserves Phoenix Convention Center Police Protection Public Transit Regional Wireless Cooperative Solid Waste Disposal Street Transportation & Drainage Wastewater Water System Total Capital Improvement Program 329,136 $ 320,348,316 9,487,984 4,500,000 10,021,900 2,793,402 7,548,022 1,618,109 47,238,059 971,825 11,575,314 2,034,035 7,713,141 58,973,395 26,370,374 9,166,428 107,343,452 11,146,109 26,143,039 218,018,960 121,032,175 200,878,714 $ 1,205,251,889 $ 2012-13 Actual Yearto-Date Actual Yearto-Date 35,855 $ 21,558,141 40,329 427,827 (17,080) 4,438,975 546,249 755 1,734,090 352,466 862,710 34,396 96,181 755,381 1,831,255 1,018,531 3,089,773 5,415 2,646,586 2,156,161 2,666,493 44,280,489 $ - 19 - 7,077,517 12,646,707 282,234 496,497 51,656 126,469 884,177 2,368,035 49,326 276,699 66,520 54,632 2013-14 Year-to-Date Capital Amounts From Operating Funds From Capital Funds Budget Actual Budget Actual $ 151,223 61,058 28,719 589,815 6,189 3,624,768 572,436 3,264,710 32,679,387 10,000 $ 34,834,765 9,225,140 4,500,000 2,222,500 1,536,370 87,000 4,759 24,852,045 919,925 200,000 3,836,994 33,873,798 5,921,374 79,481,910 18,479,672 79,333,514 58,073,538 173,311,234 $ 530,704,538 $ 4,041 1,283,359 38,385 427,827 (25,905) 2,441,436 224 1,156,541 33,540 38,678 $ 738,009 126,147 2,606,361 2,297 1,272,701 2,112,176 2,504,038 14,759,855 319,136 $ 285,513,551 262,844 7,799,400 1,257,032 7,461,022 1,613,350 22,386,014 971,825 10,655,389 1,834,035 3,876,147 25,099,597 20,449,000 9,166,428 27,861,542 11,146,109 7,663,367 138,685,446 62,958,637 27,567,480 $ 674,547,351 $ 31,814 20,274,782 1,944 8,825 1,997,539 546,025 755 577,549 352,466 862,710 856 57,503 Unencumbered Budget $ 17,372 1,705,108 1,018,531 483,412 3,118 1,373,885 43,985 162,455 29,520,634 293,281 298,790,175 9,447,655 4,072,173 10,038,980 (1,645,573) 7,001,773 1,617,354 45,503,969 619,359 10,712,604 1,999,639 7,616,960 58,218,014 24,539,119 8,147,897 104,253,679 11,146,109 26,137,624 215,372,374 118,876,014 198,212,221 $ 1,160,971,400 Bonds Authorized and Sold As of July 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 $ - 20 - 2,689,750 $ 2,537,395 $ 152,355