City of Phoenix, Arizona Monthly Financial Report October 2011 Monthly Financial Report – October 2011 Executive Summary Budget • The budget amounts in this report represent the official adopted budget, as approved by the City Council, for fiscal year 2011-12. Revenues • Revenues for the General Fund were $2.9 million less than prior year-to-date revenues. Local sales taxes and the City’s portion of state sales tax comprise the major portion, approximately 55 percent, of estimated General Fund revenues. As of October 2011, local sales taxes were up $6.1 million compared to the prior year-to-date General Fund revenues. However, state shared taxes were down $8.3 million compared to the prior year-to-date. The decrease in state shared revenues was mostly from Income and Vehicle License Taxes. (see pages 12-13) Expenditures • Citywide year-to-date expenditures for the month of October 2011 are $24.3 million less than year to date expenditures for October 2010. This reduction is primarily due to reduced capital improvements in the operating budget. • General Fund expenditures for the first four months of the fiscal year are on target representing 32.2 percent of the total budget. (see page 3) • Capital fund year-to-date expenditures have decreased $181.2 million to $159.3 million from $340.5 million spent during the same period last year. -1- General Funds Summary Summary General Funds As of October 31 (dollars in thousands) 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 Actual Year-to-Date 2011-12 2010-11 Budget Estimate 2011-12 $ $ 417,006 2,465 $ 136,231 $ 323 130,061 336 % of Year-to-Date Estimate Actual 2011-12 2010-11 32.7 % 13.1 33.1 % 13.8 110,696 122,065 48,045 126,763 3,270 9,567 35,705 40,667 15,691 7,677 869 2,263 35,357 47,882 17,098 8,505 977 2,396 32.3 33.3 32.7 6.1 26.6 23.7 31.6 33.3 35.4 6.5 31.6 25.0 20,759 1,100 12,598 1,256 7,103 993 5,124 6,720 288 3,319 380 1,960 326 1,182 6,762 303 4,201 412 3,023 292 1,704 32.4 26.2 26.3 30.3 27.6 32.8 23.1 31.7 26.1 26.0 33.1 40.3 26.0 32.4 36,750 12,462 300 14,890 11,671 4,512 237 4,432 11,511 2,595 80 3,858 31.8 36.2 79.0 29.8 31.2 21.2 23.9 22.2 28.8 % 28.8 % 953,212 $ 274,453 $ -2- 277,353 Summary General Funds As of October 31 (dollars in thousands) Budget Estimate 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 $ 394 1,119 (117) 9,658 739 750 6,323 1,269 1,685 2,908 1,130 5,092 736 31,686 29.0 % 31.7 44.8 35.1 35.5 31.5 32.9 37.1 31.6 28.5 34.6 29.1 66.6 33.7 30,954 4,708 35,662 9,897 1,543 11,440 9,848 1,505 11,353 32.0 32.8 32.1 34.4 32.3 34.1 Public Safety Police Fire Others Total Public Safety 428,455 226,892 30 655,377 146,710 74,218 3 220,931 145,011 70,812 (23) 215,800 34.2 32.7 10.0 33.7 34.6 32.2 (54.3) 33.7 Transportation Street Transportation Public Transit Total Transportation 22,527 19,231 41,758 6,852 6,203 13,055 7,229 6,439 13,668 30.4 32.3 31.3 36.8 33.8 35.3 Community Development Economic Development Neighborhood Services Department Planning and Development Others Total Community Development 4,886 11,532 4,995 57 21,470 1,465 3,673 1,460 16 6,614 1,315 3,859 1,701 73 6,948 30.0 31.9 29.2 28.1 30.8 30.5 37.5 35.9 71.2 35.7 Community Enrichment Parks and Recreation Library Human Services Others Total Community Enrichment 89,567 35,277 18,493 2,121 145,458 32,705 9,934 6,304 651 49,594 32,217 9,589 6,095 863 48,764 36.5 28.2 34.1 30.7 34.1 37.4 29.7 35.8 38.1 35.4 Environmental Services Public Works Environmental Programs Total Environmental Services 16,400 978 17,378 4,930 242 5,172 5,228 374 5,602 30.1 24.7 29.8 39.8 41.1 39.9 3,733 345 107 9.2 9.6 - - - - Capital Improvement Contingencies Total Expenditures and Encumbrances $ % of Year-to-Date Estimate Actual 2011-12 2010-11 414 $ 1,053 884 11,535 824 720 5,998 955 1,568 3,133 1,105 5,000 1,853 35,042 Criminal Justice Municipal Court Public Defender Total Criminal Justice 1,428 3,323 1,973 32,873 2,319 2,287 18,234 2,575 4,969 11,008 3,191 17,160 2,782 104,122 Actual Year-to-Date 2011-12 2010-11 37,890 $ 1,062,848 $ -3- 342,193 $ 333,928 32.2 % 29.5 % 34.8 (7.1) 344.3 32.4 32.1 35.1 47.8 46.6 31.5 35.7 27.7 38.8 44.9 35.0 % Citywide Summary Comparison to Prior Year Revenues YEAR-TO-DATE REVENUES As of October 31, 2011 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 October 31 increased by $23,737,979 to $916,380,113 from the $892,642,134 collected during the same period last year, an increase of 2.7%. For the current year, 30.4% of the total estimated revenue has been collected. Of the total revenues received last year, 29.6% had been collected as of October 31. -4- Comparison to Prior Year Operating Expenditures YEAR-TO-DATE OPERATING EXPENDITURES (millions of dollars) As of October 31, 2011 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 October 31 decreased $24,348,732 to $1,062,664,245 from the $1,087,012,977 spent during the same period last year, a decrease of 2.2%. For the current year, 30.6% of the total appropriations has been spent. Of the total actual expenditures for last year, 35.9% had been spent as of October 31. -5- Comparison to Prior Year Capital Expenditures YEAR-TO-DATE CAPITAL EXPENDITURES As of October 31, 2011 950 900 850 800 750 700 (millions of dollars) 650 600 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 October 31 decreased $181,250,103 to $159,291,841 from the $340,541,944 spent during the same period last year, a decrease of 53.2%. For the current year, 12.1% of the total appropriations has been spent. Of the total actual expenditures for last year, 39.6% had been spent as of October 31. -6- Summary Operating Revenues As of October 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 Budget Estimate 2011-12 $ Total General Funds 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 Total Special Revenue Funds and Debt Service Enterprise Funds Aviation Convention Center Water System Wastewater Solid Waste Golf Courses Total Enterprise Funds Total Operating Revenues $ 417,006 2,465 Actual Year-to-Date 2011-12 2010-11 $ 136,231 $ 323 130,061 336 % of Year-to-Date Estimate Actual 2011-12 2010-11 32.7 % 13.1 33.1 % 13.8 110,696 122,065 48,045 126,763 3,270 9,567 21,859 12,598 1,256 7,103 993 5,124 49,212 301 14,890 35,705 40,667 15,691 7,677 869 2,263 7,008 3,319 380 1,960 326 1,182 16,183 237 4,432 35,357 47,882 17,098 8,505 977 2,396 7,065 4,201 412 3,023 292 1,704 14,106 80 3,858 32.3 33.3 32.7 6.1 26.6 23.7 32.1 26.3 30.3 27.6 32.8 23.1 32.9 78.7 29.8 31.6 33.3 35.4 6.5 31.6 25.0 31.4 26.0 33.1 40.3 26.0 32.4 28.7 23.9 22.2 953,213 274,453 277,353 28.8 28.8 26,956 78,517 27,510 159,966 11,425 33,100 17,502 14,781 91,126 28,863 3,854 25,634 306,082 99,757 8,524 26,729 8,591 50,447 2,422 11,114 5,632 3,756 27,508 6,813 441 8,547 51,101 5,622 7,889 25,691 8,145 45,886 891 10,850 5,491 3,444 33,047 6,399 2,001 7,460 23,253 9,632 31.6 34.0 31.2 31.5 21.2 33.6 32.2 25.4 30.2 23.6 11.4 33.3 16.7 5.6 31.1 34.5 31.4 30.0 30.2 34.1 35.1 23.5 31.3 15.2 22.5 30.6 9.4 6.2 925,073 217,247 190,079 23.5 20.5 329,036 57,391 366,646 230,882 142,567 6,130 105,881 15,995 176,291 76,753 48,599 1,161 118,334 22,123 158,693 77,936 47,077 1,047 32.2 27.9 48.1 33.2 34.1 18.9 35.6 36.0 44.7 34.2 32.9 18.3 1,132,652 424,680 425,210 37.5 37.8 916,380 $ 892,642 30.4 % 29.6 % 3,010,938 -7- $ Summary Operating Revenues As of October 31, 2011 General Funds Local Taxes General Funds State Shared Taxes 450 350 400 300 350 (millions of dollars) (millions of dollars) 250 300 250 200 150 200 150 100 100 50 50 0 0 July Aug Sept Oct July Aug Sept Oct Nov Dec Jan Feb Mar April May June Current YTD Revenues Prior YTD Revenues Nov Dec Current YTD Revenues Total General Funds Revenues Jan Feb Mar April May June Prior YTD Revenues Highway User Revenues 1,200 120 110 100 1,000 800 (millions of dollars) (millions of dollars) 90 600 400 80 70 60 50 40 30 20 200 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 October 31 (dollars in thousands) Source General Government General Funds Other Funds Total General Government Actual Year-to-Date 2011-12 2010-11 Budget 2011-12 $ 35,042 $ 585 35,627 31,686 2,736 34,422 33.7 % 3.9 29.9 44.9 % 37.0 44.1 35,662 9,893 45,555 11,440 935 12,375 11,353 2,372 13,725 32.1 9.5 27.2 34.1 65.3 37.1 Public Safety General Funds Other Funds Total Public Safety 655,377 161,111 816,488 220,931 51,340 272,271 215,800 51,101 266,901 33.7 31.9 33.3 33.7 33.6 33.7 Transportation General Funds Other Funds Total Transportation 41,758 566,577 608,335 13,055 274,403 287,458 13,668 259,037 272,705 31.3 48.4 47.3 35.3 49.0 48.0 Community Development General Funds Other Funds Total Community Development 21,470 230,974 252,444 6,614 54,769 61,383 6,948 56,940 63,888 30.8 23.7 24.3 35.7 36.3 36.3 Community Enrichment General Funds Other Funds Total Community Enrichment 145,458 136,167 281,625 49,594 47,499 97,093 48,764 52,631 101,395 34.1 34.9 34.5 35.4 38.4 36.9 Environmental Services General Funds Other Funds Total Environmental Services 17,378 619,300 636,678 5,172 179,100 184,272 5,602 188,573 194,175 29.8 28.9 28.9 39.9 33.8 33.9 Debt Service General Funds Other Funds Total Debt Service 138,719 138,719 56,307 56,307 64,121 64,121 40.6 40.6 32.6 32.6 Capital Improvement General Funds Other Funds Total Capital Improvement 3,733 487,088 490,821 345 55,533 55,878 107 75,575 75,682 9.2 11.4 11.4 9.6 22.9 22.9 37,890 46,550 84,440 - - Criminal Justice General Funds Other Funds Total Criminal Justice Contingencies General Funds Other Funds Total Contingencies Total Operating General Funds Other Funds Total Operating Budget $ 104,122 15,186 119,308 1,062,848 2,411,565 3,474,413 $ % of Year-to-Date Estimate Actual 2011-12 2010-11 $ 342,193 720,471 1,062,664 $ -9- 333,928 753,086 1,087,014 32.2 29.9 30.6 % 35.0 36.4 35.9 % Summary Operating Expenditures and Encumbrances As of October 31, 2011 Total General Government Total Criminal Justice 90 40 80 30 60 (millions of dollars) (millions of dollars) 70 50 40 30 20 10 20 10 0 0 July Aug Sept Oct July Nov Dec Jan Feb Mar April May June Current YTD Expenditures (millions of dollars) (millions of dollars) Nov Dec Current YTD Expenditures Jan Feb Nov Dec Jan Feb Mar April May June Prior YTD Expenditures Total Transportation 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 Aug Sept Oct Oct Current YTD Expenditures Prior YTD Expenditures Total Public Safety July Aug Sept 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 Aug Sept Oct Mar April May June Nov Dec Jan Current YTD Expenditures Prior YTD Expenditures - 10 - Feb Mar April May June Prior YTD Expenditures Summary Operating Expenditures and Encumbrances As of October 31, 2011 Total Community Development Total Community Enrichment 190 300 180 280 170 260 150 240 140 220 130 (millions of dollars) (millions of dollars) 160 120 110 100 90 80 70 60 200 180 160 140 120 100 50 80 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 620 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 Jan Feb Mar April May June Prior YTD Expenditures Total Debt Service 210 200 190 180 170 160 150 (millions of dollars) (millions of dollars) Total Environmental Services Nov Dec 140 130 120 110 100 90 80 70 60 50 40 30 20 10 0 July Aug Sept Oct Nov Dec Current YTD Expenditures Jan July Aug Sept Oct Feb Mar April May June Nov Dec Jan Current YTD Expenditures Prior YTD Expenditures - 11 - Feb Mar April May June Prior YTD Expenditures Citywide Detail Revenues For the Month Ended October 31 2011 2010 Budget Estimate 2011-12 Source Actual Year-to-Date 2011-12 2010-11 Percent of Year-to-Date Estimate Actual 2011-12 2010-11 General Funds $ 34,745,601 164,373 $ 32,142,794 186,885 Local Taxes: Sales Taxes Privilege License Fees $ 417,006,000 2,464,500 $ 136,231,200 323,053 $ 130,060,846 336,137 32.7 % 13.1 33.1 % 13.8 34,909,974 32,329,679 Total Local Taxes 419,470,500 136,554,253 130,396,983 32.6 33.0 9,176,883 10,168,121 3,669,368 8,642,018 11,970,581 4,018,188 State Shared Taxes: State Sales Tax State Income Tax Vehicle License Tax 110,696,000 122,065,000 48,045,000 35,704,578 40,667,440 15,691,128 35,357,212 47,882,356 17,098,330 32.3 33.3 32.7 31.6 33.3 35.4 23,014,372 24,630,787 280,806,000 92,063,146 100,337,898 32.8 33.0 7,721,492 8,658,799 Primary Property Tax 126,763,000 7,676,769 8,504,953 6.1 6.5 161,147 213,282 Licenses and Permits 3,270,000 868,535 977,036 26.6 31.6 2,416,639 2,263,311 Cable Communications 9,567,056 2,263,003 2,396,170 23.7 25.0 1,624,666 70,194 1,602,548 73,946 Municipal Court: Fines and Forfeitures Court Default Fee 20,759,025 1,100,000 6,719,834 287,900 6,761,360 303,306 32.4 26.2 31.7 26.1 1,694,860 1,676,494 21,859,025 7,007,734 7,064,666 32.1 31.4 1,290,531 1,032,664 12,597,587 3,318,826 4,200,440 26.3 26.0 82,361 101,464 321,851 1,354,268 127,614 40,903 263,263 281,198 2,838,048 59,100 2,124,523 2,952,858 62,081 1,534,892 5,021,671 4,549,831 49,934 10,273 1,194,152 943,974 78,269,861 78,086,927 Total State Shared Taxes Total Municipal Court Police Library Fees 1,256,140 379,697 411,392 30.2 33.1 Parks and Recreation 7,102,531 1,959,699 3,023,355 27.6 40.3 993,300 326,121 291,657 32.8 26.0 5,124,098 1,181,856 1,704,232 23.1 32.4 36,750,000 1,300,000 11,161,613 11,671,238 231,636 4,280,452 11,511,210 214,300 2,380,304 31.8 17.8 38.3 31.2 16.6 21.7 49,211,613 16,183,326 14,105,814 32.9 28.7 301,380 237,176 79,924 78.7 23.9 14,889,664 4,432,473 3,858,034 29.8 22.2 953,211,894 274,452,614 277,352,554 28.8 28.8 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 - Revenues For the Month Ended October 31 2011 2010 Budget Estimate 2011-12 Source Actual Year-to-Date 2011-12 2010-11 Percent of Year-to-Date Estimate Actual 2011-12 2010-11 Special Revenue Funds and Debt Service $ 1,509,009 107,786 538,932 9,272 2,164,999 $ 1,373,758 98,125 490,627 (15,649) 1,946,861 Neighborhood Protection: Police Neighborhood Protection Police Blockwatch Fire Neighborhood Protection Interest/Other Total Neighborhood Protection $ 5,899,082 421,363 2,106,815 96,695 $ 5,528,075 394,862 1,974,312 (8,427) 31.3 % 31.3 31.3 201.4 31.2 % 31.0 31.0 20.0 8,523,955 7,888,822 31.6 31.1 58,269,000 20,108,000 140,000 19,612,399 7,128,517 (11,481) 18,745,291 6,910,655 34,744 33.7 35.5 (8.2) 33.9 36.0 72.6 78,517,000 26,729,435 25,690,690 34.0 34.5 27,510,000 8,590,913 8,145,200 31.2 31.4 107,640,000 52,325,926 33,709,041 16,737,446 31,588,995 14,297,205 31.3 32.0 31.2 27.6 159,965,926 50,446,487 45,886,200 31.5 30.0 Court Awards 11,425,309 2,421,546 890,766 21.2 30.2 4,716,061 1,752,716 5,637 6,970,782 6,474,414 2,194,834 2,011,578 Parks and Preserves 8,622,911 4,178,122 7,850,033 3,574,083 Transit 2000: Sales Taxes Interest/Other 12,801,033 11,424,116 - 18,837,000 1,345,000 6,726,000 48,000 26,956,000 Public Safety Enhancement & Expansion: Police Fire Interest/Other 5,100,360 1,874,658 (4,236) - $ Total Public Safety Enhancement & Expansion Total Transit 2000 2,343,675 2,483,220 Planning and Development 33,100,000 11,114,320 10,850,345 33.6 34.1 1,321,213 1,386,146 Capital Construction 17,502,000 5,631,968 5,490,959 32.2 35.1 Sports Facilities: Sales Taxes Interest/Other 14,386,000 395,000 3,614,127 142,171 3,284,139 160,280 25.1 36.0 23.3 26.5 925,147 29,447 811,726 35,332 954,594 847,058 Total Sports Facilities 14,781,000 3,756,298 3,444,419 25.4 23.5 6,706,889 27,983 466 7,924,411 39,488 15,380 Highway User Revenue: Highway User Revenue Interest Other 90,226,000 600,000 300,000 27,275,653 117,841 114,628 32,881,693 149,689 15,680 30.2 19.6 38.2 31.3 27.6 11.5 6,735,338 7,979,279 91,126,000 27,508,122 33,047,062 30.2 31.3 2,953,127 1,936,317 28,863,623 6,813,370 6,399,243 23.6 15.2 130,624 16,490 3,853,899 441,177 2,000,533 11.4 22.5 3,753,010 3,730,633 25,633,671 8,547,046 7,460,014 33.3 30.6 Total Highway User Revenue Regional Transit Revenues Community Reinvestment Other Restricted Fees - 13 - Revenues For the Month Ended October 31 2011 2010 Budget Estimate 2011-12 Source Actual Year-to-Date 2011-12 2010-11 Percent of Year-to-Date Estimate Actual 2011-12 2010-11 Special Revenue Funds and Debt Service (Cont'd) $ 609,168 7,790,869 1,020,060 $ 645,319 7,502,483 73,641 9,420,097 8,221,443 3,599,396 84,841 1,773,157 5,039,836 1,342,263 368,409 6,721,990 10,497,230 8,432,662 19,917,327 16,654,105 Grants: Public Housing: Rentals Grants Other $ Total Public Housing 9,270,065 77,005,775 2,431,392 $ 2,329,785 23,425,933 (298,425) $ 1,901,172 13,873,168 (418,141) 25.1 % 30.4 (12.3) 28.7 % 19.3 (4.0) 88,707,232 25,457,293 15,356,199 28.7 17.3 42,765,750 9,983,354 34,665,229 129,960,524 11,108,716 2,134,033 6,013,618 6,387,304 6,731,993 (3,615,566) 3,276,674 1,503,594 26.0 21.4 17.3 4.9 14.9 (19.2) 18.6 2.0 Total Other 217,374,857 25,643,671 7,896,695 11.8 5.0 Total Grants 306,082,089 51,100,964 23,252,894 16.7 9.4 Other: Human Resources Federal Transit Administration Community Development Other G.O. Bond Debt Service Secondary Property Tax Interest 5,934,814 (1,733) 10,132,900 195 5,933,081 10,133,095 Total G.O. Bond Debt Service 68,173,637 67,023,312 Total Special Revenue and Debt Service 94,529,000 5,228,000 5,674,148 (52,100) 9,667,660 (35,482) 6.0 (1.0) 6.5 (0.7) 99,757,000 5,622,048 9,632,178 5.6 6.2 925,073,517 217,247,649 190,079,325 23.5 20.5 30,667,367 73,404,359 503,057 1,809,482 674,758 1,426,925 9,847,798 26.6 38.3 36.0 (64.0) 32.9 26.5 28.5 36.9 37.3 37.1 24.7 41.3 44.2 25.0 Enterprise Funds AVIATION: 6,647,389 16,100,753 182,654 223,014 138,693 236,367 2,750,773 10,233,050 24,758,208 106,264 328,964 258,114 449,875 2,405,501 26,279,643 38,539,976 Sky Harbor: Airlines Concessions Interest Other Phoenix-Goodyear Phoenix-Deer Valley Phoenix-Customer Facility Charge 108,000,000 173,799,000 1,620,000 3,286,000 1,724,000 3,606,500 37,000,000 Total Aviation 28,766,585 66,569,590 582,580 (2,102,507) 567,968 956,871 10,540,188 329,035,500 105,881,275 118,333,746 32.2 35.6 39,685,000 17,106,160 600,000 11,601,065 4,240,726 152,581 10,662,735 11,243,495 217,073 29.2 24.8 25.4 28.2 48.8 34.7 57,391,160 15,994,372 22,123,303 27.9 36.0 CONVENTION CENTER: 3,006,086 1,121,949 36,278 2,700,281 619,824 56,090 4,164,313 3,376,195 Excise Taxes Operating Revenue Interest Total Convention Center - 14 - Revenues For the Month Ended October 31 2011 2010 Budget Estimate 2011-12 Source Actual Year-to-Date 2011-12 2010-11 Percent of Year-to-Date Estimate Actual 2011-12 2010-11 Enterprise Funds (Cont'd) WATER SYSTEM: $ 33,424,299 505,516 226,274 859,661 140,760 115,699 588,086 $ 35,860,295 28,241,819 507,629 201,875 691,111 101,040 356,351 488,255 30,588,080 Water Sales Water Service Fees Distribution Intergovernmental Development Fees Interest Other $ Total Water System 343,293,000 6,000,000 3,180,000 9,395,000 1,500,000 1,298,000 1,980,000 $ 166,902,430 2,002,976 1,388,466 3,763,937 659,040 704,624 869,359 $ 150,305,148 2,047,917 1,162,264 3,142,104 417,660 1,239,729 378,130 48.6 % 33.4 43.7 40.1 43.9 54.3 43.9 45.3 % 34.1 43.0 40.0 34.3 35.8 22.7 366,646,000 176,290,832 158,692,952 48.1 44.7 196,104,000 14,486,000 1,400,000 1,962,000 16,930,000 64,985,670 6,440,642 625,440 816,282 3,885,277 66,129,468 6,279,490 367,301 1,028,899 4,131,328 33.1 44.5 44.7 41.6 22.9 33.5 33.0 34.7 33.4 60.8 230,882,000 76,753,311 77,936,486 33.2 34.2 123,625,000 7,440,000 750,000 10,752,500 41,344,947 2,645,688 177,338 4,431,306 41,173,477 2,501,536 247,781 3,153,728 33.4 35.6 23.6 41.2 33.3 29.8 35.9 29.8 142,567,500 48,599,279 47,076,522 34.1 32.9 16.3 37.3 24.8 22.7 6.0 14.3 26.8 22.8 34.4 68.7 WASTEWATER: 16,337,390 1,592,220 128,640 217,188 885,137 16,307,894 1,533,842 99,161 259,500 659,956 19,160,575 18,860,353 Sewer Service Charges Multi-City Development Fees Interest Other Total Wastewater SOLID WASTE: 10,336,510 691,103 44,604 1,135,994 10,270,410 562,170 56,477 1,456,731 12,208,211 12,345,788 Collection Fees Landfill Fees Interest Other Total Solid Waste GOLF COURSES: $ 202,121 6,704 139,046 (10,532) 4,136 162,127 5,570 123,904 (11,648) 118,026 341,475 397,979 98,014,512 104,108,371 244,458,010 $ 249,218,610 Fees Coffee Shops Concessions Interest Other 4,100,500 78,400 2,008,000 (185,282) 128,000 Total Golf Courses Total Enterprise Funds Total Operating Revenues $ - 15 - 667,512 29,233 498,366 (42,028) 7,698 536,418 19,680 421,975 (49,077) 118,250 6,129,618 1,160,781 1,047,246 18.9 18.3 1,132,651,778 424,679,850 425,210,255 37.5 37.8 892,642,134 30.4 % 29.6 % 3,010,937,189 $ 916,380,113 $ Operating Expenditures and Encumbrances For the Month Ended October 31 2011 2010 Budget Estimate 2011-12 Program Actual Year-to-Date 2011-12 2010-11 2011-12 Year-to-Date Operating Expenditures & Encumbrances Capital Operations and Debt General Government $ 97,964 $ 243,656 224,841 2,589,530 76,810 207,437 199,360 1,666,688 93,585 430,236 364,023 773,073 18,769 8,320 236,155 1,311,751 (1,362,528) 7,179,670 94,144 250,309 227,190 2,203,172 95,812 188,238 203,469 1,649,853 176,329 318,899 28,171 766,680 5,990 7,704 255,452 1,321,357 7,792,769 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,438,508 3,323,173 2,289,692 33,838,035 1,321,292 2,624,699 2,691,191 20,041,149 2,574,942 4,993,080 1,298,797 11,729,936 162,059 3,191,087 24,160,975 3,629,630 $ 414,363 1,052,459 996,738 11,740,960 580,622 954,190 857,440 6,608,532 954,810 1,573,493 1,224,484 3,240,752 34,704 40,269 1,105,024 5,950,274 (1,701,772) $ 401,401 1,119,008 (69,820) 10,148,200 618,528 877,223 880,902 6,923,042 1,269,464 1,739,401 116,218 3,344,220 (12,780) 13,554 1,130,470 5,922,871 - $ 414,363 1,052,459 996,738 11,673,464 580,622 954,190 857,440 6,608,532 954,810 1,568,067 1,224,484 3,210,542 34,704 40,269 1,105,024 5,902,377 (1,701,772) $ 67,496 5,426 30,210 47,897 - 119,308,245 35,627,342 34,421,902 35,476,313 151,029 40,846,452 4,708,450 10,831,777 1,542,907 12,219,347 1,505,215 10,667,945 1,542,907 163,832 - 45,554,902 12,374,684 13,724,562 12,210,852 163,832 547,390,725 268,616,005 480,992 184,052,532 88,095,323 122,674 182,794,834 83,935,767 170,091 183,143,978 87,744,169 122,674 908,554 351,154 - 816,487,722 272,270,529 266,900,692 271,010,821 1,259,708 Criminal Justice 2,325,595 379,793 2,881,344 376,820 2,705,388 3,258,164 Municipal Court Public Defender Total Criminal Justice Public Safety 41,910,643 21,315,993 27,221 41,314,380 19,630,614 68,434 63,253,857 61,013,428 Police Fire Other Total Public Safety - 16 - Operating Expenditures and Encumbrances For the Month Ended October 31 2011 2010 Budget Estimate 2011-12 Program Actual Year-to-Date 2011-12 2010-11 2011-12 Year-to-Date Operating Expenditures & Encumbrances Capital Operations and Debt Transportation $ 4,634,958 961,223 20,891,681 8,866,931 35,354,793 $ 4,610,747 807,564 18,007,586 8,814,861 32,240,758 Street Transportation Street Lighting Aviation Public Transit Total Transportation $ 58,632,945 11,685,358 290,441,289 247,575,530 $ 19,251,693 3,350,449 84,973,595 179,882,150 $ 18,825,993 3,262,431 79,295,310 171,321,562 $ 19,211,508 3,350,449 65,151,988 160,569,056 $ 40,185 19,821,607 19,313,094 608,335,122 287,457,887 272,705,296 248,283,001 39,174,886 Community Development 2,641,905 7,761,991 1,945,268 5,297,936 2,526,121 6,171,713 1,330,599 3,298,704 Planning and Development Housing Economic Development Neighborhood Services Department 33,601,910 75,137,220 37,775,681 105,929,214 10,943,446 26,571,318 8,194,565 15,674,065 10,437,761 25,670,263 10,740,010 17,040,011 10,943,446 26,546,839 7,432,795 15,674,065 24,479 761,770 - 17,647,100 13,327,137 Total Community Development 252,444,025 61,383,394 63,888,045 60,597,145 786,249 96,385,575 36,069,133 8,341,758 62,545,832 10,968,395 62,339,505 4,133,240 841,581 35,114,107 10,161,728 3,180,455 23,733,382 2,652,682 20,910,095 1,033,972 306,198 34,716,429 9,798,117 2,680,427 26,302,223 4,075,584 22,124,568 1,144,632 552,583 35,053,967 10,161,728 3,179,705 17,166,045 20,890,043 1,033,972 306,198 60,140 750 6,567,337 2,652,682 20,052 - 281,625,019 97,092,619 101,394,563 87,791,658 9,300,961 Community Enrichment 7,911,355 2,646,867 839,888 3,897,010 662,239 4,955,443 188,458 (56,670) 21,044,590 7,761,201 2,644,162 767,856 4,392,091 1,017,965 5,940,640 386,069 152,719 23,062,703 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 October 31 2011 2010 Budget Estimate 2011-12 Program 2011-12 Year-to-Date Operating Expenditures & Encumbrances Capital Operations and Debt Actual Year-to-Date 2011-12 2010-11 Environmental Services $ 24,404,712 11,894,330 8,917,286 975,120 97,029 46,288,477 $ 21,047,536 13,108,169 8,547,712 2,346,308 154,460 45,204,185 Water System Wastewater Solid Waste Management Public Works Environmental Programs $ Total Environmental Services 390,781,777 84,743,876 126,438,686 33,305,241 1,407,983 $ 95,722,519 49,172,676 33,934,094 5,365,313 77,451 $ 91,702,033 51,151,176 43,109,284 7,573,382 638,994 $ 59,983,351 24,132,739 29,639,470 5,075,615 77,451 $ 118,908,626 35,739,168 25,039,937 4,294,624 289,698 - 636,677,563 184,272,053 194,174,869 65,363,427 1,315,055 13,124,099 19,974,955 211,365 4,727,555 671,765 4,165,274 677,444 9,357,132 7,370,435 929,524 26,140,222 50,200 8,957,446 2,022,132 6,361,800 (37,080,505) 1,846,375 31,958,772 28,193,672 306,413 7,437,854 438,352 4,092,608 6,580,728 70,455 1,368,262 223,922 1,373,151 225,815 3,090,932 2,361,538 309,841 8,365,507 16,733 2,677,904 519,844 1,725,107 3,820 615,292 10,546,475 9,268,363 102,137 2,330,598 438,018 3,180,525 6,696,939 88,242 1,618,512 222,388 1,621,261 280,842 2,428,798 1,865,759 306,508 6,245,948 16,733 3,921,574 851,674 6,365,357 3,820 2,514,625 8,490,821 12,221,385 55,604 4,685,274 - 438,352 4,092,608 6,580,728 70,455 1,368,262 223,922 1,373,151 225,815 3,090,932 2,361,538 309,841 8,365,507 16,733 2,677,904 519,844 1,725,107 3,820 615,292 10,546,475 9,268,363 102,137 2,330,598 General Obligation Debt Service 109,588 1,023,152 1,645,182 17,614 342,066 55,981 343,287 56,454 772,733 590,384 77,460 2,091,377 4,183 669,476 129,961 431,277 153,823 2,636,619 2,317,090 25,534 582,467 109,504 795,131 1,674,235 22,061 404,628 55,597 405,316 70,210 607,199 466,440 76,627 1,561,487 4,183 980,394 212,919 1,591,339 628,656 2,122,705 3,055,318 13,901 1,170,909 14,075,708 16,028,759 Total Debt Service 138,718,984 56,307,384 64,120,607 - 56,307,384 12,526,863 28,678,699 Capital Improvement 490,821,254 55,878,353 75,682,441 - 55,878,353 $ 220,076,446 $ 230,606,602 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 Contingencies Total Operating Budget 84,440,000 $ 3,474,412,836 - 18 - $ 1,062,664,245 $ 1,087,012,977 $ 834,278,416 $ 228,385,829 Capital Expenditures and Encumbrances For the Month Ended October 31 2011 2010 $ $ 457,823 $ 10,398,191 84,852 652,391 141,776 1,574,177 15,376,014 926,225 664,535 298,595 2011-12 Actual YearBudget to-Date Program Arts and Cultural Facilities Aviation Economic Development Energy Conservation Facilities Management $ 14,804,107 $ 435,812,669 10,253,514 17,746,981 19,197,800 2010-11 Actual Yearto-Date 7,004,931 57,264,091 788,754 3,706,230 4,001,976 $ $ 1,195,000 $ 53,590,375 6,544,985 17,746,981 1,752,000 7,589,469 446,056 3,706,230 59,543 3,401,194 1,007,107 10,857,550 86,883 48,568,331 $ 13,609,107 $ 382,222,294 3,708,529 17,445,800 7,004,931 49,674,622 342,698 3,942,433 7,014,410 21,140,399 2,672,476 15,975,903 7,715,403 236,174 5,601,458 Unencumbered Budget $ 7,799,176 378,548,578 9,464,760 14,040,751 15,195,824 5,419 39,293 1,888,061 1,045,199 37,749 2,476,952 Fire Protection Freeway Mitigation Historic Preservation Housing 21,140,399 2,759,359 64,544,234 195,647 811,465 42,150 349,533 5,058 1,082,828 1,149,354 408,232 Human Services Information Technology Libraries Neighborhood Services 2,857,262 14,253,403 7,697,854 11,785,676 (360,639) 2,017,642 1,651,668 689,109 4,111,825 1,713,526 2,369,235 1,388,213 10,256,533 1,454,500 3,966,861 1,245,119 967,394 270,809 2,857,262 3,996,870 6,243,354 7,818,815 3,152,697 96,126 227,948 69,415 29,622,009 29,252 918,687 694,630 Parks and Mountain Preserves Phoenix Convention Center Police Protection Public Transit 99,758,025 2,212,303 25,509,600 77,991,552 7,225,751 106,164 816,284 3,099,447 37,097,669 3,181,127 1,432,403 9,723,130 46,820,118 2,212,303 26,179,381 2,832,639 104,991 1,188,361 52,937,907 25,509,600 51,812,171 4,393,112 1,173 816,284 1,911,086 92,532,274 2,106,139 24,693,316 74,892,105 546,560 2,129,007 927,899 5,472,543 6,202,208 18,626,306 2,253,780 12,506,315 Solid Waste Disposal Street Transportation & Drainage Wastewater Water System 29,244,218 155,264,473 107,162,416 197,600,987 2,249,973 14,998,293 4,906,843 28,557,879 18,042,134 49,614,969 17,637,472 111,188,050 14,365,000 70,784,504 72,777,540 112,519,959 1,890,716 10,945,172 4,242,836 13,374,608 14,879,218 84,479,969 34,384,876 85,081,028 359,257 4,053,121 664,007 15,183,271 26,994,245 140,266,180 102,255,573 169,043,108 340,541,944 $ 490,821,254 $ 55,878,353 103,413,488 $ 1,158,304,991 27,688,796 $ 95,898,105 Total Capital Improvement Program $ 1,317,596,832 $ 7,715,403 236,174 12,615,868 1,756,816 49,846,647 12,217,536 2,347,574 1,607,767 2011-12 Year-to-Date Capital Amounts From Operating Funds From Capital Funds Budget Actual Budget Actual 159,291,841 $ - 19 - $ 826,775,578 $ (360,639) 772,523 684,274 418,300 13,424,996 2,523,185 51,928,366 3,217,901 12,235,761 6,046,186 11,096,567 Bonds Authorized and Sold As of October 31 (dollars in thousands) Authorized 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 Sold $ 28,285 884,175 Available $ 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,325 123,085 24,170 60,600 11,075 32,100 89,275 71,645 72,575 75,640 64,230 43,700 1,975 2,215 630 900 925 900 2,225 2,355 4,425 3,160 1,770 - 753,900 732,420 21,480 81,000 11,100 198,700 12,800 104,622 74,705 29,178 115,500 107,295 78,200 65,400 57,645 8,400 186,950 7,075 63,290 43,900 19,675 72,325 62,900 55,915 50,550 23,355 2,700 11,750 5,725 41,332 30,805 9,503 43,175 44,395 22,285 14,850 878,500 628,625 249,875 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,417,395 $ 272,355