City of Phoenix, Arizona Monthly Financial Report November 2011 Monthly Financial Report – November 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 • Citywide year-to-date revenues for the month of November 2011 are 3.9 million higher than year-to-date revenues for November 2010. This is an increase of 0.3%. • Revenues for the General Fund were $16.5 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 November 2011, local sales taxes were up $5.1 million compared to the prior year-to-date General Fund revenues. However, state shared taxes were down $9.8 million, Primary Property Taxes were down $8.6 million and Police revenue was down $2.8 million compared to the prior year-todate. The decrease in state shared revenues was mostly from Income and Vehicle License Taxes. The decrease in Police revenues reflects a settlement received in the prior year. Revenues through November 2011 are slightly higher than what was project in the Budget Estimate. (see pages 12-13) Expenditures • Citywide year-to-date expenditures for the month of November 2011 are $27.9 million less than year to date expenditures for November 2010. This reduction is primarily due to reduced capital improvements in the operating budget and reduced General Obligation Debt Service. (see pages 24-25) • General Fund expenditures for the first five months of the fiscal year are slightly less than what was forecasted in the budget representing 39.9 percent of the total budget. (see page 3) • Capital fund year-to-date expenditures have decreased $55 million to $358.9 million from $413.9 million spent during the same period last year. The $358.9 million in capital expenditures includes projects at the Aviation department (including Sky-Train) for 227.8 million. Decreases in capital expenditures as compared to last year to date include $101.1 million in Water, $28.5 in Parks and Preserves, $22.1 in Streets and Transportation and $13.8 million in Sewer projects. (see pages 26-27) -1- General Funds Summary Summary General Funds As of November 30 (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 $ 168,085 $ 584 163,013 675 % of Year-to-Date Estimate Actual 2011-12 2010-11 40.3 % 23.7 41.5 % 27.7 110,696 122,065 48,045 126,763 3,270 9,567 44,787 50,836 18,780 39,649 1,036 2,263 44,044 59,853 20,323 48,237 1,240 2,396 40.5 41.6 39.1 31.3 31.7 23.7 39.4 41.7 42.1 36.8 40.1 25.0 20,759 1,100 12,598 1,256 7,103 993 5,124 8,241 355 4,439 467 2,224 417 1,997 8,168 372 7,242 500 3,340 369 2,269 39.7 32.3 35.2 37.2 31.3 42.0 39.0 38.3 32.0 44.9 40.2 44.6 32.9 43.2 36,750 12,462 300 14,890 14,961 4,753 284 6,677 14,072 4,624 98 6,453 40.7 38.1 94.7 44.8 38.2 37.8 29.2 37.1 38.9 % 40.2 % 953,212 $ 370,835 $ -2- 387,288 Summary General Funds As of November 30 (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 $ 510 1,386 138 12,011 986 953 8,039 1,392 2,176 3,657 1,443 6,447 849 39,987 36.3 % 39.5 58.6 43.4 44.2 39.6 41.7 44.4 41.0 36.7 43.1 38.2 75.6 42.3 30,954 4,708 35,662 12,302 1,930 14,232 12,251 1,883 14,134 39.7 41.0 39.9 42.7 40.4 42.4 Public Safety Police Fire Others Total Public Safety 428,455 226,892 30 655,377 180,521 92,536 (52) 273,005 180,105 89,335 9 269,449 42.1 40.8 (173.3) 41.7 42.9 40.6 21.5 42.1 Transportation Street Transportation Public Transit Total Transportation 22,527 19,231 41,758 9,680 7,757 17,437 12,627 7,988 20,615 43.0 40.3 41.8 64.2 41.9 53.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,870 4,606 1,865 20 8,361 1,645 4,854 2,144 77 8,720 38.3 39.9 37.3 35.1 38.9 38.2 47.1 45.2 75.0 44.8 Community Enrichment Parks and Recreation Library Human Services Others Total Community Enrichment 89,567 35,277 18,493 2,121 145,458 39,595 12,554 7,621 822 60,592 39,070 11,743 7,179 1,095 59,087 44.2 35.6 41.2 38.8 41.7 45.3 36.3 42.1 48.4 42.9 Environmental Services Public Works Environmental Programs Total Environmental Services 16,400 978 17,378 6,047 304 6,351 5,877 468 6,345 36.9 31.1 36.5 44.7 51.5 45.2 3,733 405 110 10.8 9.8 - - Capital Improvement Contingencies Total Expenditures and Encumbrances $ % of Year-to-Date Estimate Actual 2011-12 2010-11 519 $ 1,311 1,157 14,254 1,026 905 7,602 1,143 2,037 4,035 1,376 6,561 2,103 44,029 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- 424,412 $ 418,447 39.9 % 38.1 % 43.1 8.3 428.1 43.2 40.8 44.6 52.4 60.1 39.6 45.5 35.0 44.8 56.6 43.8 % Citywide Summary Comparison to Prior Year Revenues YEAR-TO-DATE REVENUES As of November 30, 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 November 30 increased by $3,898,326 to $1,192,805,413 from the $1,188,907,087 collected during the same period last year, an increase of 0.3%. For the current year, 39.6% of the total estimated revenue has been collected. Of the total revenues received last year, 39.4% had been collected as of November 30. -4- Comparison to Prior Year Operating Expenditures YEAR-TO-DATE OPERATING EXPENDITURES (millions of dollars) As of November 30, 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 November 30 decreased $27,893,578 to $1,295,745,441 from the $1,323,639,019 spent during the same period last year, a decrease of 2.1%. For the current year, 37.3% of the total appropriations has been spent. Of the total actual expenditures for last year, 43.7% had been spent as of November 30. -5- Comparison to Prior Year Capital Expenditures YEAR-TO-DATE CAPITAL EXPENDITURES As of November 30, 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 November 30 decreased $54,980,327 to $358,885,536 from the $413,865,863 spent during the same period last year, a decrease of 13.3%. For the current year, 27.2% of the total appropriations has been spent. Of the total actual expenditures for last year, 48.1% had been spent as of November 30. -6- Summary Operating Revenues As of November 30 (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 $ 168,085 $ 584 163,013 675 % of Year-to-Date Estimate Actual 2011-12 2010-11 40.3 % 23.7 41.5 % 27.7 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 300 14,890 44,787 50,836 18,780 39,649 1,036 2,263 8,596 4,439 467 2,224 417 1,997 19,714 284 6,677 44,044 59,853 20,323 48,237 1,240 2,396 8,540 7,242 500 3,340 369 2,269 18,696 98 6,453 40.5 41.6 39.1 31.3 31.7 23.7 39.3 35.2 37.2 31.3 42.0 39.0 40.1 94.7 44.8 39.4 41.7 42.1 36.8 40.1 25.0 38.0 44.9 40.2 44.6 32.9 43.2 38.1 29.2 37.1 953,212 370,835 387,288 38.9 40.2 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 10,537 32,804 10,650 61,732 2,422 13,767 7,053 5,161 34,200 7,857 682 11,114 68,998 29,215 9,848 31,848 10,156 57,474 2,221 13,393 6,835 4,849 41,145 9,061 2,161 6,987 48,890 55,180 39.1 41.8 38.7 38.6 21.2 41.6 40.3 34.9 37.5 27.2 17.7 43.4 22.5 29.3 38.9 42.7 39.1 37.5 75.4 42.1 43.7 33.0 39.0 21.5 24.3 28.6 19.8 35.8 925,073 296,192 300,048 32.0 32.4 329,036 57,391 366,646 230,882 142,567 6,130 133,731 19,948 206,506 103,036 60,867 1,690 132,031 27,258 185,278 96,476 58,962 1,566 40.6 34.8 56.3 44.6 42.7 27.6 39.7 44.3 52.2 42.4 41.2 27.4 1,132,652 525,778 501,571 46.4 44.6 39.6 % 39.4 % 3,010,937 -7- $ 1,192,805 $ 1,188,907 Summary Operating Revenues As of November 30, 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 November 30 (dollars in thousands) Source General Government General Funds Other Funds Total General Government Actual Year-to-Date 2011-12 2010-11 Budget 2011-12 $ 44,029 $ 1,512 45,541 39,987 3,403 43,390 42.3 % 10.0 38.2 56.6 % 46.0 55.6 35,662 9,893 45,555 14,232 1,349 15,581 14,134 2,930 17,064 39.9 13.6 34.2 42.4 80.6 46.2 Public Safety General Funds Other Funds Total Public Safety 655,377 161,111 816,488 273,005 64,076 337,081 269,449 63,690 333,139 41.7 39.8 41.3 42.1 41.8 42.1 Transportation General Funds Other Funds Total Transportation 41,758 566,577 608,335 17,437 303,713 321,150 20,615 291,111 311,726 41.8 53.6 52.8 53.3 55.0 54.9 Community Development General Funds Other Funds Total Community Development 21,470 230,974 252,444 8,361 68,866 77,227 8,720 68,759 77,479 38.9 29.8 30.6 44.8 43.9 44.0 Community Enrichment General Funds Other Funds Total Community Enrichment 145,458 136,167 281,625 60,592 58,800 119,392 59,087 63,948 123,035 41.7 43.2 42.4 42.9 46.7 44.8 Environmental Services General Funds Other Funds Total Environmental Services 17,378 619,300 636,678 6,351 224,633 230,984 6,345 233,275 239,620 36.5 36.3 36.3 45.2 41.8 41.8 Debt Service General Funds Other Funds Total Debt Service 138,719 138,719 70,383 70,383 80,149 80,149 50.7 50.7 40.7 40.7 Capital Improvement General Funds Other Funds Total Capital Improvement 3,733 487,088 490,821 405 78,001 78,406 110 97,926 98,036 10.8 16.0 16.0 9.8 29.7 29.6 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 $ 424,412 871,333 1,295,745 $ -9- 418,447 905,191 1,323,638 39.9 36.1 37.3 % 43.8 43.7 43.7 % Summary Operating Expenditures and Encumbrances As of November 30, 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 November 30, 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 November 30 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 $ 31,853,504 260,752 $ 32,952,117 339,285 Local Taxes: Sales Taxes Privilege License Fees $ 417,006,000 2,464,500 $ 168,084,704 583,805 $ 163,012,963 675,422 40.3 % 23.7 41.5 % 27.7 32,114,256 33,291,402 Total Local Taxes 419,470,500 168,668,509 163,688,385 40.2 41.5 9,082,776 10,168,121 3,088,784 8,686,977 11,970,582 3,224,424 State Shared Taxes: State Sales Tax State Income Tax Vehicle License Tax 110,696,000 122,065,000 48,045,000 44,787,354 50,835,561 18,779,912 44,044,189 59,852,938 20,322,754 40.5 41.6 39.1 39.4 41.7 42.1 22,339,681 23,881,983 280,806,000 114,402,827 124,219,881 40.7 40.9 31,971,903 39,731,590 Primary Property Tax 126,763,000 39,648,672 48,236,543 31.3 36.8 167,287 263,497 Licenses and Permits 3,270,000 1,035,822 1,240,533 31.7 40.1 Cable Communications 9,567,056 2,263,003 2,396,170 23.7 25.0 Municipal Court: Fines and Forfeitures Court Default Fee 20,759,025 1,100,000 8,241,578 354,917 8,168,439 371,736 39.7 32.3 38.3 32.0 21,859,025 8,596,495 8,540,175 39.3 38.0 12,597,587 4,438,650 7,241,800 35.2 44.9 - - 1,521,744 67,017 1,407,079 68,430 1,588,761 1,475,509 1,119,824 3,041,360 87,818 88,325 264,555 316,654 91,389 77,529 815,345 564,889 3,290,136 72,500 168,356 2,561,165 72,917 1,956,562 3,530,992 4,590,644 46,503 17,622 2,244,524 2,594,562 96,382,838 109,935,566 Total State Shared Taxes Total Municipal Court Police Library Fees 1,256,140 467,515 499,717 37.2 40.2 Parks and Recreation 7,102,531 2,224,254 3,340,009 31.3 44.6 993,300 417,510 369,186 42.0 32.9 5,124,098 1,997,201 2,269,121 39.0 43.2 36,750,000 1,300,000 11,161,613 14,961,374 304,136 4,448,808 14,072,375 287,217 4,336,866 40.7 23.4 39.9 38.2 22.3 39.6 49,211,613 19,714,318 18,696,458 40.1 38.1 301,380 283,679 97,546 94.1 29.2 14,889,664 6,676,997 6,452,596 44.8 37.1 953,211,894 370,835,452 387,288,120 38.9 40.2 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 November 30 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,414,449 $ 101,032 505,160 (7,154) 1,377,330 98,381 491,904 (8,333) 2,013,487 1,959,282 Neighborhood Protection: Police Neighborhood Protection Police Blockwatch Fire Neighborhood Protection Interest/Other Total Neighborhood Protection Public Safety Enhancement & Expansion: Police Fire Interest/Other 4,496,445 1,582,936 (4,987) 4,520,510 1,632,804 4,369 6,074,394 6,157,683 2,058,828 2,011,237 Parks and Preserves 8,082,565 3,202,842 7,870,463 3,717,593 Transit 2000: Sales Taxes Interest/Other 11,285,407 11,588,056 - $ Total Public Safety Enhancement & Expansion Total Transit 2000 18,837,000 1,345,000 6,726,000 48,000 $ 7,313,531 522,395 2,611,975 89,541 $ 6,905,405 493,243 2,466,216 (16,760) 38.8 % 38.8 38.8 186.5 38.9 % 38.7 38.7 39.7 26,956,000 10,537,442 9,848,104 39.1 38.9 58,269,000 20,108,000 140,000 24,108,844 8,711,453 (16,468) 23,265,801 8,543,459 39,113 41.4 43.3 (11.8) 42.1 44.6 81.7 78,517,000 32,803,829 31,848,373 41.8 42.7 27,510,000 10,649,741 10,156,437 38.7 39.1 107,640,000 52,325,926 41,791,606 19,940,288 39,459,458 18,014,798 38.8 38.1 38.9 34.8 159,965,926 61,731,894 57,474,256 38.6 37.5 1,330,134 Court Awards 11,425,309 2,421,546 2,220,900 21.2 75.4 2,652,870 2,543,009 Planning and Development 33,100,000 13,767,190 13,393,354 41.6 42.1 1,421,445 1,344,357 Capital Construction 17,502,000 7,053,413 6,835,316 40.3 43.7 1,221,012 184,072 1,206,697 197,643 Sports Facilities: Sales Taxes Interest/Other 14,386,000 395,000 4,835,139 326,243 4,490,836 357,923 33.6 82.6 31.9 59.3 1,405,084 1,404,340 Total Sports Facilities 14,781,000 5,161,382 4,848,759 34.9 33.0 6,665,282 26,809 - 7,993,653 39,817 64,566 Highway User Revenue: Highway User Revenue Interest Other 90,226,000 600,000 300,000 33,940,935 144,650 114,628 40,875,346 189,506 80,246 37.6 24.1 38.2 39.0 34.9 59.0 6,692,091 8,098,036 91,126,000 34,200,213 41,145,098 37.5 39.0 1,043,099 2,661,221 28,863,623 7,856,469 9,060,464 27.2 21.5 241,242 160,106 3,853,899 682,419 2,160,639 17.7 24.3 25,633,671 11,114,088 6,986,825 43.4 28.6 2,567,042 (473,189) Total Highway User Revenue Regional Transit Revenues Community Reinvestment Other Restricted Fees - 13 - Revenues For the Month Ended November 30 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) $ 573,219 5,341,828 960,100 6,875,147 $ 1,553,584 5,588,242 94,337 7,236,163 4,606,770 636,091 662,859 5,115,874 2,535,384 78,913 3,215,615 12,571,235 11,021,594 18,401,147 17,896,741 25,637,310 23,582,720 9,797 45,519,409 27,959 23,592,517 45,547,368 78,944,247 109,968,950 Grants: Public Housing: Rentals Grants Other $ Total Public Housing 9,270,065 77,005,775 2,431,392 $ 2,903,004 28,767,761 661,675 $ 3,454,756 19,461,410 (323,804) 31.3 % 37.4 27.2 52.2 % 27.1 (3.1) 88,707,232 32,332,440 22,592,362 36.4 25.4 42,765,750 9,983,354 34,665,229 129,960,524 15,715,486 2,770,124 6,676,477 11,503,178 9,267,377 (3,536,653) 6,492,289 14,074,829 36.7 27.7 19.3 8.9 20.5 (18.8) 36.9 18.4 Total Other 217,374,857 36,665,265 26,297,842 16.9 16.6 Total Grants 306,082,089 68,997,705 48,890,204 22.5 19.8 94,529,000 5,228,000 29,256,868 (42,303) 55,187,069 (7,523) 31.0 (0.8) 37.0 (0.1) 99,757,000 29,214,565 55,179,546 29.3 35.8 925,073,517 296,191,896 300,048,275 32.0 32.4 34,052,329 80,102,724 609,227 2,020,718 690,211 1,473,322 13,082,387 33.4 47.8 45.3 (59.0) 40.9 33.4 37.6 41.0 40.7 45.0 27.6 42.3 45.6 33.2 Other: Human Resources Federal Transit Administration Community Development Other G.O. Bond Debt Service Secondary Property Tax Interest Total G.O. Bond Debt Service Total Special Revenue and Debt Service Enterprise Funds AVIATION: 7,273,051 16,494,763 151,906 162,411 137,192 249,459 3,380,395 3,384,962 6,698,365 106,170 211,236 15,453 46,397 3,234,589 27,849,177 13,697,172 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 36,039,636 83,064,353 734,486 (1,940,096) 705,160 1,206,330 13,920,583 329,035,500 133,730,452 132,030,918 40.6 39.7 39,685,000 17,106,160 600,000 14,797,974 4,961,821 188,293 13,982,880 13,004,636 270,112 37.3 29.0 31.4 37.0 56.5 43.2 57,391,160 19,948,088 27,257,628 34.8 44.3 CONVENTION CENTER: 3,196,909 721,095 35,712 3,320,145 1,761,141 53,039 3,953,716 5,134,325 Excise Taxes Operating Revenue Interest Total Convention Center - 14 - Revenues For the Month Ended November 30 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: $ 28,105,700 426,546 234,337 644,992 93,960 209,881 499,941 $ 30,215,357 24,613,337 424,420 193,725 581,074 72,420 261,420 438,174 26,584,570 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 $ 195,008,130 2,429,522 1,622,803 4,408,929 753,000 914,505 1,369,300 $ 174,918,485 2,472,337 1,355,989 3,723,178 490,080 1,501,149 816,304 56.8 % 40.5 51.0 46.9 50.2 70.5 69.2 52.7 % 41.1 50.2 47.4 40.2 43.3 48.9 366,646,000 206,506,189 185,277,522 56.3 52.2 196,104,000 14,486,000 1,400,000 1,962,000 16,930,000 81,002,969 8,166,388 711,240 1,002,704 12,152,814 82,412,505 7,965,683 427,361 1,243,042 4,427,760 41.3 56.4 50.8 51.1 71.8 41.7 41.8 40.3 40.3 65.2 230,882,000 103,036,115 96,476,351 44.6 42.4 123,625,000 7,440,000 750,000 10,752,500 51,671,953 3,188,262 223,434 5,783,280 51,440,823 2,989,080 302,163 4,229,896 41.8 42.9 29.8 53.8 41.7 35.6 43.8 40.0 142,567,500 60,866,929 58,961,962 42.7 41.2 24.5 45.6 33.5 28.5 23.6 23.5 35.9 32.0 42.2 72.1 WASTEWATER: 16,017,299 1,725,746 85,800 186,422 8,267,537 16,283,037 1,686,193 60,060 214,143 296,432 26,282,804 18,539,865 Sewer Service Charges Multi-City Development Fees Interest Other Total Wastewater SOLID WASTE: 10,327,006 542,574 46,096 1,351,974 10,267,346 487,544 54,382 1,076,168 12,267,650 11,885,440 Collection Fees Landfill Fees Interest Other Total Solid Waste GOLF COURSES: $ 337,293 6,541 173,997 (10,861) 22,541 347,338 6,712 170,348 (11,123) 5,790 529,511 519,065 101,098,215 76,360,437 276,425,300 $ 296,264,953 Fees Coffee Shops Concessions Interest Other Total Golf Courses Total Enterprise Funds Total Operating Revenues $ - 15 - 4,100,500 78,400 2,008,000 (185,282) 128,000 1,004,805 35,774 672,363 (52,889) 30,239 6,129,618 1,690,292 1,566,311 27.6 27.4 1,132,651,778 525,778,065 501,570,692 46.4 44.6 39.6 % 39.4 % 3,010,937,189 $ 1,192,805,413 883,756 26,392 592,323 (60,200) 124,040 $ 1,188,907,087 Operating Expenditures and Encumbrances For the Month Ended November 30 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 $ 104,195 258,188 287,628 2,764,723 217,892 221,966 217,034 1,765,605 187,726 470,159 88,638 963,176 17,825 9,787 271,290 1,811,631 256,296 9,913,759 $ 121,120 267,257 293,603 2,460,011 79,308 269,067 227,814 1,853,509 122,650 504,119 28,668 845,515 (2,478) 8,034 312,475 1,577,738 8,968,410 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 $ 518,558 1,310,647 1,284,366 14,505,683 798,514 1,176,156 1,074,474 8,374,137 1,142,536 2,043,652 1,313,122 4,203,928 52,529 50,056 1,376,314 7,761,905 (1,445,476) $ 522,521 1,386,265 223,783 12,608,211 697,836 1,146,290 1,108,716 8,776,551 1,392,114 2,243,520 144,886 4,189,735 (15,258) 21,588 1,442,945 7,500,609 - $ 518,558 1,310,647 1,284,366 14,421,345 798,514 1,176,156 1,074,474 8,374,137 1,142,536 2,036,870 1,313,122 4,166,165 52,529 50,056 1,376,314 7,702,034 (1,445,476) $ 84,338 6,782 37,763 59,871 - 119,308,245 45,541,101 43,390,312 45,352,347 188,754 40,846,452 4,708,450 13,651,008 1,930,157 15,181,394 1,882,882 13,446,465 1,930,157 204,543 - 45,554,902 15,581,165 17,064,276 15,376,622 204,543 547,390,725 268,616,005 480,992 227,275,624 109,710,370 95,530 226,754,435 106,133,822 250,708 226,140,629 109,271,897 95,530 1,134,995 438,473 - 816,487,722 337,081,524 333,138,965 335,508,056 1,573,468 Criminal Justice 2,819,231 387,250 2,962,047 377,667 3,206,481 3,339,714 Municipal Court Public Defender Total Criminal Justice Public Safety 43,223,092 21,615,047 (27,144) 43,959,601 22,198,055 80,617 64,810,995 66,238,273 Police Fire Other Total Public Safety - 16 - Operating Expenditures and Encumbrances For the Month Ended November 30 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 $ 6,504,568 790,603 19,211,013 7,185,829 33,692,013 $ 7,834,014 1,244,897 21,625,068 8,316,513 39,020,492 Street Transportation Street Lighting Aviation Public Transit Total Transportation $ 58,632,945 11,685,358 290,441,289 247,575,530 $ 25,756,261 4,141,052 104,184,608 187,067,979 $ 26,660,007 4,507,328 100,920,378 179,638,075 $ 25,706,029 4,141,052 79,411,104 162,926,611 $ 50,232 24,773,504 24,141,368 608,335,122 321,149,900 311,725,788 272,184,796 48,965,104 Community Development 2,810,582 6,208,489 2,133,949 4,690,536 2,624,739 6,181,694 1,692,500 3,091,822 Planning and Development Housing Economic Development Neighborhood Services Department 33,601,910 75,137,220 37,775,681 105,929,214 13,754,028 32,779,807 10,328,514 20,364,601 13,062,500 31,851,957 12,432,510 20,131,833 13,754,028 32,749,340 9,376,433 20,364,601 30,467 952,081 - 15,843,556 13,590,755 Total Community Development 252,444,025 77,226,950 77,478,800 76,244,402 982,548 96,385,575 36,069,133 8,341,758 62,545,832 10,968,395 62,339,505 4,133,240 841,581 42,452,640 12,838,159 3,859,234 28,403,046 3,314,922 26,850,848 1,272,648 400,797 42,282,093 11,996,741 3,442,376 30,539,775 5,093,549 27,555,347 1,413,780 711,689 42,377,481 12,838,159 3,858,484 20,235,208 26,825,805 1,272,648 400,797 75,159 750 8,167,838 3,314,922 25,043 - 281,625,019 119,392,294 123,035,350 107,808,582 11,583,712 Community Enrichment 7,338,533 2,676,431 678,779 4,669,664 662,240 5,940,753 238,676 94,599 7,565,664 2,198,624 761,949 4,237,552 1,017,965 5,430,779 269,148 159,106 22,299,675 21,640,787 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 November 30 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 $ 23,851,641 11,546,807 9,892,125 1,275,666 145,488 46,711,727 $ 22,606,177 12,638,835 8,795,257 1,250,069 154,587 45,444,925 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 $ 119,574,160 60,719,483 43,826,219 6,640,979 222,939 $ 114,308,210 63,790,011 51,904,541 8,823,451 793,581 $ 74,971,937 29,599,962 38,458,762 6,280,056 222,939 $ 149,533,656 44,602,223 31,119,521 5,367,457 360,923 - 636,677,563 230,983,780 239,619,794 81,450,124 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 547,940 5,115,761 8,225,910 88,068 1,710,327 279,902 1,716,439 282,269 3,863,665 2,951,923 387,301 10,456,883 20,917 3,347,380 649,805 2,156,383 3,828 769,115 13,183,094 11,585,454 127,672 2,913,064 547,523 3,975,657 8,371,174 110,302 2,023,140 277,985 2,026,576 351,052 3,035,998 2,332,199 383,134 7,807,435 20,917 4,901,967 1,064,592 7,956,697 3,820 3,143,281 10,613,526 15,276,741 69,505 5,856,182 - 547,940 5,115,761 8,225,910 88,068 1,710,327 279,902 1,716,439 282,269 3,863,665 2,951,923 387,301 10,456,883 20,917 3,347,380 649,805 2,156,383 3,828 769,115 13,183,094 11,585,454 127,672 2,913,064 General Obligation Debt Service 109,588 1,023,153 1,645,182 17,613 342,065 55,980 343,288 56,454 772,733 590,385 77,460 2,091,376 4,184 669,476 129,961 431,276 8 153,823 2,636,619 2,317,091 25,535 582,466 109,505 795,132 1,674,235 22,060 404,628 55,597 405,315 70,210 607,200 466,440 76,626 1,561,487 4,184 980,393 212,918 1,591,340 628,656 2,122,705 3,055,356 13,901 1,170,908 14,075,716 16,028,796 Total Debt Service 138,718,984 70,383,100 80,149,403 - 70,383,100 22,527,274 22,353,890 Capital Improvement 490,821,254 78,405,627 98,036,331 - 78,405,627 $ 233,081,196 $ 236,626,042 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,295,745,441 $ 1,323,639,019 $ 1,002,008,461 $ 293,736,980 Capital Expenditures and Encumbrances For the Month Ended November 30 2011 2010 $ 63,254 $ 170,547,095 45,845 1,249,555 260,562 492,039 24,150,416 190,455 591,385 754,290 92,613 9,069 1,773,910 753,129 15,955 8,302,800 244,783 181,581 79,439 97,744 231,782 92,829 379,872 106,396 3,433,641 90,196 142,049 283,531 909,072 16,387,074 504,168 3,198,514 $ 199,593,695 $ 2,158,146 (84,389) 4,179,511 3,904,664 18,682 3,820,286 1,529,365 21,736,306 73,323,919 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,716,981 19,197,800 Fire Protection Freeway Mitigation Historic Preservation Housing 21,140,399 2,759,359 64,544,234 Human Services Information Technology Libraries Neighborhood Services 2,857,262 14,253,403 7,697,854 11,785,676 Parks and Mountain Preserves Phoenix Convention Center Police Protection Public Transit 99,788,025 2,212,303 25,509,600 77,991,552 29,244,218 155,264,473 107,162,416 197,600,987 Solid Waste Disposal Street Transportation & Drainage Wastewater Water System Total Capital Improvement Program $ 1,317,596,832 $ 2010-11 Actual Yearto-Date 7,068,185 227,811,186 834,599 4,955,785 4,262,538 $ 7,808,016 245,243 14,389,778 2,248,855 73,997,063 12,407,991 2,938,959 2,362,057 2011-12 Year-to-Date Capital Amounts From Operating Funds From Capital Funds Budget Actual Budget Actual $ 1,195,000 $ 53,590,375 6,544,985 17,716,981 1,752,000 27,309 10,306,881 477,562 4,955,785 114,751 $ 13,609,107 $ 382,222,294 3,708,529 17,445,800 7,040,876 217,504,305 357,037 4,147,787 Unencumbered Budget $ 4,154,323 1,023,062 19,160,350 86,883 48,568,331 8,220,766 21,140,399 2,672,476 15,975,903 4,343,607 1,806,355 2,749,107 1,494,609 10,256,533 1,454,500 3,966,861 1,419,854 1,040,054 325,416 2,857,262 3,996,870 6,243,354 7,818,815 10,659,392 196,360 958,333 3,382,978 39,255,815 3,096,738 5,611,914 13,627,794 46,850,118 2,212,303 26,179,381 6,237,249 170,409 1,266,176 52,937,907 25,509,600 51,812,171 4,422,143 25,951 958,333 2,116,802 89,128,633 2,015,943 24,551,267 74,608,574 3,159,045 31,385,367 5,411,011 31,756,393 18,060,816 53,435,255 19,166,837 132,924,356 14,365,000 70,784,504 72,777,540 112,519,959 2,496,785 20,729,162 4,690,031 15,927,437 14,879,218 84,479,969 34,384,876 85,081,028 662,260 10,656,205 720,980 15,828,956 26,085,173 123,879,106 101,751,405 165,844,594 413,865,863 $ 490,821,254 $ 78,405,627 (115,856) 2,199,223 1,731,107 786,853 358,885,536 $ - 19- $ 826,775,578 $ 7,808,016 245,243 6,169,012 7,735,922 208,001,483 9,418,915 12,761,196 14,935,262 13,332,383 2,514,116 50,154,456 (115,856) 779,369 691,053 461,437 280,479,909 2,973,118 12,054,180 5,966,747 10,998,823 $ 958,711,296 Bonds Authorized and Sold As of November 30 (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