City of Phoenix, Arizona Monthly Financial Report December 2011 Monthly Financial Report – December 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 December 2011 are 9.7 million less than year-to-date revenues for December 2010. This is a decrease of 0.7%. • Revenues for the General Fund were $11.4 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 December 2011, local sales taxes were up $5.4 million compared to the prior year-to-date General Fund revenues. However, state shared taxes were down $11.8 million, Primary Property Taxes were down $1.5 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 December 2011 are slightly lower than what was projected in the Budget Estimate. (see pages 12-13) • Regional Transit revenues are less as compared to the fiscal year 2012 budget estimate. This is due to a decrease in public transportation reimbursements for light rail costs and service reductions. Expenditures • Citywide year-to-date expenditures for the month of December 2011 are $12.9 million less than year to date expenditures for December 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 six months of the fiscal year are slightly less than what was forecasted in the budget representing 48.1 percent of the total budget. (see page 3) • Capital fund year-to-date expenditures have decreased $51.4 million to $405.7 million from $457.1 million spent during the same period last year. The $405.7 million in capital expenditures includes projects at the Aviation department (including Sky-Train) for $235.3 million. Decreases in capital expenditures as compared to last year to date include $101.7 million in Water, $21.4 in Parks and Preserves, $22.4 in Streets and Transportation and $13.8 million in Sewer projects. (see pages 26-27) -1- General Funds Summary Summary General Funds As of December 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 $ 199,830 $ 1,605 194,469 1,562 % of Year-to-Date Estimate Actual 2011-12 2010-11 47.9 % 65.1 49.6 % 64.0 110,696 122,065 48,045 126,763 3,270 9,567 53,843 61,004 22,561 63,184 1,440 2,263 52,991 71,824 24,417 64,693 1,612 2,396 48.6 50.0 47.0 49.8 44.0 23.7 47.4 50.0 50.6 49.4 52.1 25.0 20,759 1,100 12,598 1,256 7,103 993 5,124 9,804 427 5,570 567 2,475 505 2,831 9,658 436 8,378 587 3,590 479 2,584 47.2 38.8 44.2 45.1 34.8 50.9 55.2 45.3 37.6 52.0 47.2 47.9 42.6 49.2 36,750 12,462 300 14,890 17,534 4,923 328 8,441 17,815 4,986 119 7,922 47.7 39.5 109.3 56.7 48.4 40.7 35.6 45.5 953,212 $ 459,135 $ -2- 470,518 48.2 % 48.9 % Summary General Funds As of December 31 (dollars in thousands) Budget Estimate 2011-12 Expenditures and Encumbrances General Government Mayor City Council City Manager Information Technology Services (1) Public Information Equal Opportunity Law City Auditor City Clerk Human Resources Budget and Research Finance Others Total General Government $ 639 1,645 339 14,472 1,173 1,161 9,555 1,617 2,640 4,328 1,692 7,875 913 48,049 44.8 % 47.0 15.6 53.3 53.0 48.1 49.2 49.8 48.4 45.7 50.7 48.7 89.7 50.4 30,954 4,708 35,662 14,726 2,321 17,047 14,779 2,269 17,048 47.6 49.3 47.8 51.6 48.7 51.2 428,455 226,892 30 655,377 216,962 112,688 (27) 329,623 214,719 110,455 41 325,215 50.6 49.7 (90.0) 50.3 51.2 50.2 93.9 50.8 Transportation Street Transportation Public Transit Total Transportation 22,527 19,231 41,758 11,829 9,341 21,170 11,414 9,594 21,008 52.5 48.6 50.7 58.0 50.4 54.3 Community Development Economic Development Neighborhood Services Department Planning and Development Others Total Community Development 4,886 11,532 4,995 57 21,470 2,295 5,553 2,230 24 10,102 2,098 5,769 2,490 74 10,431 47.0 48.2 44.6 42.1 47.1 48.7 56.0 52.5 72.3 53.6 Community Enrichment Parks and Recreation Library Human Services Others Total Community Enrichment 89,567 35,277 18,493 2,121 145,458 46,575 14,953 9,029 1,001 71,558 45,043 14,472 8,773 1,199 69,487 52.0 42.4 48.8 47.2 49.2 52.3 44.8 51.5 53.0 50.4 Environmental Services Public Works Environmental Programs Total Environmental Services 16,400 978 17,378 7,540 370 7,910 5,201 544 5,745 46.0 37.8 45.5 39.6 59.7 40.9 3,733 1,770 272 47.4 24.2 37,890 - Public Safety Police Fire Others Total Public Safety Capital Improvement Contingencies Total Expenditures and Encumbrances $ 1,062,848 $ % of Year-to-Date Estimate Actual 2011-12 2010-11 640 $ 1,561 307 17,514 1,230 1,099 8,976 1,282 2,407 5,030 1,619 8,354 2,496 52,515 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 $ 511,695 $ 497,255 47.7 % 51.1 20.4 515.9 51.3 49.7 53.0 60.9 72.9 46.8 53.4 42.8 48.2 68.0 48.1 % 52.1 % (1) In prior years, Information Technology Services' charges were allocated to Departments on a monthly basis. In the current year, the costs will be allocated through the upgraded cost allocation model and will be reported in March of 2012. -3- Citywide Summary Comparison to Prior Year Revenues YEAR-TO-DATE REVENUES As of December 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 December 31 decreased by $9,651,247 to $1,446,836,563 from the $1,456,487,810 collected during the same period last year, a decrease of 0.7%. For the current year, 48.1% of the total estimated revenue has been collected. Of the total revenues received last year, 48.3% had been collected as of December 31. -4- Comparison to Prior Year Operating Expenditures YEAR-TO-DATE OPERATING EXPENDITURES (millions of dollars) As of December 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 December 31 decreased $12,903,957 to $1,549,793,639 from the $1,562,697,596 spent during the same period last year, a decrease of 0.8%. For the current year, 44.6% of the total appropriations has been spent. Of the total actual expenditures for last year, 51.6% had been spent as of December 31. -5- Comparison to Prior Year Capital Expenditures YEAR-TO-DATE CAPITAL EXPENDITURES As of December 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 December 31 decreased $51,434,672 to $405,670,574 from the $457,105,246 spent during the same period last year, a decrease of 11.3%. For the current year, 30.7% of the total appropriations has been spent. Of the total actual expenditures for last year, 53.1% had been spent as of December 31. -6- Summary Operating Revenues As of December 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 $ 199,830 $ 1,605 194,469 1,562 % of Year-to-Date Estimate Actual 2011-12 2010-11 47.9 % 65.1 49.6 % 64.0 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 53,843 61,004 22,561 63,184 1,440 2,263 10,231 5,570 567 2,475 505 2,831 22,457 328 8,441 52,991 71,824 24,417 64,693 1,612 2,396 10,094 8,378 587 3,590 479 2,584 22,801 119 7,922 48.6 50.0 47.0 49.8 44.0 23.7 46.8 44.2 45.1 34.8 50.9 55.2 45.6 109.3 56.7 47.4 50.0 50.6 49.4 52.1 25.0 44.9 52.0 47.2 47.9 42.6 49.2 46.5 35.6 45.5 953,212 459,135 470,518 48.2 48.9 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 12,659 38,616 12,805 74,432 6,357 16,162 8,459 6,462 41,057 9,788 681 11,822 88,310 46,536 11,897 37,535 12,263 70,289 2,221 15,609 8,402 6,155 49,052 20,072 2,214 9,457 68,709 75,720 47.0 49.2 46.5 46.5 55.6 48.8 48.3 43.7 45.1 33.9 17.7 46.1 28.9 46.6 46.9 50.4 47.2 45.9 75.4 49.1 53.7 41.9 46.5 47.6 24.9 38.8 27.8 49.1 925,073 374,146 389,595 40.4 42.1 329,036 57,391 366,646 230,882 142,567 6,130 163,257 25,474 227,452 121,900 73,189 2,284 160,008 32,279 206,434 123,929 71,652 2,073 49.6 44.4 62.0 52.8 51.3 37.3 48.1 52.5 58.2 54.4 50.1 36.3 1,132,652 613,556 596,375 54.2 53.0 48.1 % 48.3 % 3,010,937 -7- $ 1,446,837 $ 1,456,488 Summary Operating Revenues As of December 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 December 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 $ 52,515 $ 2,532 55,047 48,049 4,073 52,122 50.4 % 16.7 46.1 35,662 9,893 45,555 17,047 1,633 18,680 17,048 3,675 20,723 47.8 16.5 41.0 51.2 101.2 56.1 Public Safety General Funds Other Funds Total Public Safety 655,377 161,111 816,488 329,623 77,382 407,005 325,215 79,695 404,910 50.3 48.0 49.8 50.8 52.3 51.1 Transportation General Funds Other Funds Total Transportation 41,758 566,577 608,335 21,170 334,205 355,375 21,008 322,678 343,686 50.7 59.0 58.4 54.3 61.0 60.5 Community Development General Funds Other Funds Total Community Development 21,470 230,974 252,444 10,102 87,373 97,475 10,431 81,855 92,286 47.1 37.8 38.6 53.6 52.3 52.4 Community Enrichment General Funds Other Funds Total Community Enrichment 145,458 136,167 281,625 71,558 69,691 141,249 69,487 74,593 144,080 49.2 51.2 50.2 50.4 54.4 52.4 Environmental Services General Funds Other Funds Total Environmental Services 17,378 617,100 634,478 7,910 272,662 280,572 5,745 284,144 289,889 45.5 44.2 44.2 40.9 50.9 50.6 Debt Service General Funds Other Funds Total Debt Service 138,719 138,719 84,459 84,459 96,376 96,376 60.9 60.9 49.0 49.0 Capital Improvement General Funds Other Funds Total Capital Improvement 3,733 489,288 493,021 1,770 108,162 109,932 272 118,353 118,625 47.4 22.1 22.3 24.2 35.9 35.9 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 $ % of Year-to-Date Estimate Actual 2011-12 2010-11 37,890 46,550 84,440 $ 1,062,848 2,411,565 3,474,413 - $ 511,695 1,038,099 1,549,794 $ -9- 497,255 1,065,442 1,562,697 48.1 43.0 44.6 % 68.0 % 55.1 66.8 52.1 51.4 51.6 % Summary Operating Expenditures and Encumbrances As of December 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 December 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 December 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 $ 31,745,447 1,020,855 $ 31,456,343 887,050 Local Taxes: Sales Taxes Privilege License Fees $ 417,006,000 2,464,500 $ 199,830,151 1,604,660 $ 194,469,306 1,562,472 47.9 % 65.1 49.6 % 64.0 32,766,302 32,343,393 Total Local Taxes 419,470,500 201,434,811 196,031,778 48.0 49.7 9,055,232 10,168,121 3,781,098 8,947,215 11,970,581 4,094,510 State Shared Taxes: State Sales Tax State Income Tax Vehicle License Tax 110,696,000 122,065,000 48,045,000 53,842,586 61,003,682 22,561,010 52,991,404 71,823,519 24,417,264 48.6 50.0 47.0 47.4 50.0 50.6 23,004,451 25,012,306 280,806,000 137,407,278 149,232,187 48.9 49.1 23,535,672 16,456,126 Primary Property Tax 126,763,000 63,184,344 64,692,669 49.8 49.4 404,716 371,205 Licenses and Permits 3,270,000 1,440,538 1,611,738 44.1 52.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 9,804,033 426,656 9,657,808 436,190 47.2 38.8 45.3 37.6 21,859,025 10,230,689 10,093,998 46.8 44.9 12,597,587 5,569,597 8,377,666 44.2 52.0 - - 1,562,455 71,739 1,489,369 64,454 1,634,194 1,553,823 1,130,947 1,135,866 Total State Shared Taxes Total Municipal Court Police 99,731 87,612 Library Fees 1,256,140 567,246 587,329 45.2 47.2 250,917 249,589 Parks and Recreation 7,102,531 2,475,171 3,589,598 34.8 47.9 87,208 109,948 Planning and Development 993,300 504,718 479,134 50.8 42.6 833,670 314,677 Street Transportation 5,124,098 2,830,871 2,583,798 55.2 49.2 2,573,339 57,175 112,742 3,743,203 49,818 312,082 36,750,000 1,300,000 11,161,613 17,534,713 361,311 4,561,550 17,815,578 337,035 4,648,948 47.7 27.8 40.9 48.4 26.1 42.4 2,743,256 4,105,103 49,211,613 22,457,574 22,801,561 45.6 46.5 44,610 21,283 301,380 328,289 118,829 108.9 35.6 1,764,364 1,469,102 14,889,664 8,441,361 7,921,698 56.7 45.5 88,300,038 83,230,033 953,211,894 459,135,490 470,518,153 48.2 48.9 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 December 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,488,571 $ 106,326 531,633 (5,258) 1,443,850 103,133 515,661 (13,928) 2,121,272 2,048,716 Neighborhood Protection: Police Neighborhood Protection Police Blockwatch Fire Neighborhood Protection Interest/Other Total Neighborhood Protection $ 8,802,102 628,721 3,143,608 84,283 $ 8,349,255 596,376 2,981,877 (30,688) 46.7 % 46.7 46.7 175.6 47.1 % 46.8 46.8 72.7 12,658,714 11,896,820 47.0 46.9 58,269,000 20,108,000 140,000 28,481,012 10,156,816 (22,076) 27,531,473 9,961,881 41,940 48.9 50.5 (15.8) 49.8 52.0 87.6 78,517,000 38,615,752 37,535,294 49.2 50.4 27,510,000 12,805,413 12,262,839 46.5 47.2 107,640,000 52,325,926 50,297,725 24,134,212 47,710,029 22,578,900 46.7 46.1 47.1 43.6 159,965,926 74,431,937 70,288,929 46.5 45.9 Court Awards 11,425,309 6,356,648 2,220,900 55.6 75.4 4,265,672 1,418,422 2,827 5,811,923 5,686,921 2,155,672 2,106,402 Parks and Preserves 8,506,119 4,193,924 8,250,571 4,564,102 Transit 2000: Sales Taxes Interest/Other 12,700,043 12,814,673 - 18,837,000 1,345,000 6,726,000 48,000 26,956,000 Public Safety Enhancement & Expansion: Police Fire Interest/Other 4,372,168 1,445,363 (5,608) 3,935,102 $ Total Public Safety Enhancement & Expansion Total Transit 2000 2,394,544 2,216,104 Planning and Development 33,100,000 16,161,734 15,609,458 48.8 49.1 1,405,882 1,566,514 Capital Construction 17,502,000 8,459,295 8,401,830 48.3 53.7 1,274,394 26,638 1,272,421 33,497 Sports Facilities: Sales Taxes Interest/Other 14,386,000 395,000 6,109,533 352,881 5,763,257 391,420 42.5 89.3 40.9 64.8 1,301,032 1,305,918 Total Sports Facilities 14,781,000 6,462,414 6,154,677 43.7 41.9 6,827,906 22,686 6,213 7,863,471 42,798 300 Highway User Revenue: Highway User Revenue Interest Other 90,226,000 600,000 300,000 40,768,841 167,336 120,841 48,738,817 232,304 80,546 45.2 27.9 40.3 46.5 42.8 59.2 6,856,805 7,906,569 91,126,000 41,057,018 49,051,667 45.1 46.5 1,931,214 11,011,330 28,863,623 9,787,683 20,071,794 33.9 47.6 3,853,899 681,377 2,214,036 17.7 24.9 25,633,671 11,821,771 9,456,841 46.1 38.8 (1,042) 707,683 53,397 2,470,016 Total Highway User Revenue Regional Transit Revenues Community Reinvestment Other Restricted Fees - 13 - Revenues For the Month Ended December 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) $ 496,038 5,181,297 176,230 $ (312,766) 7,767,716 2,045,852 Grants: Public Housing: Rentals Grants Other 5,853,565 9,500,802 3,650,852 18,667 1,116,238 8,672,813 1,798,637 1,151,048 3,139,568 4,229,243 13,458,570 10,318,496 19,312,135 19,819,298 17,309,808 11,454 17,988,083 2,552,119 17,321,262 20,540,202 Total G.O. Bond Debt Service 77,953,527 89,546,060 Total Special Revenue and Debt Service $ Total Public Housing 9,270,065 77,005,775 2,431,392 $ 3,399,042 33,949,058 837,905 $ 3,141,990 27,229,126 1,722,048 36.7 % 44.1 34.5 47.5 % 37.9 16.6 88,707,232 38,186,005 32,093,164 43.0 36.1 42,765,750 9,983,354 34,665,229 129,960,524 19,366,338 2,788,791 7,792,715 20,175,991 11,066,014 (2,385,605) 9,631,857 18,304,072 45.3 27.9 22.5 15.5 24.5 (12.7) 54.8 23.9 Total Other 217,374,857 50,123,835 36,616,338 23.1 23.2 Total Grants 306,082,089 88,309,840 68,709,502 28.9 27.8 94,529,000 5,228,000 46,566,676 (30,849) 73,175,152 2,544,596 49.3 (0.6) 49.1 47.8 99,757,000 46,535,827 75,719,748 46.6 49.1 925,073,517 374,145,423 389,594,335 40.4 42.1 108,000,000 173,799,000 1,620,000 3,286,000 1,724,000 3,606,500 37,000,000 43,768,520 98,226,411 835,233 949,375 835,499 1,459,398 17,182,044 40,806,518 99,952,446 696,470 2,181,624 828,169 1,724,159 13,818,834 40.5 56.5 51.6 28.9 48.5 40.5 46.4 49.1 50.8 51.4 29.8 50.7 53.4 35.1 329,035,500 163,256,480 160,008,220 49.6 48.1 39,685,000 17,106,160 600,000 18,100,098 7,155,654 217,790 17,003,658 14,954,343 320,441 45.6 41.8 36.3 44.9 64.9 51.3 57,391,160 25,473,542 32,278,442 44.4 52.5 Other: Human Resources Federal Transit Administration Community Development Other G.O. Bond Debt Service Secondary Property Tax Interest Enterprise Funds AVIATION: 7,728,884 15,162,058 100,747 2,889,471 130,339 253,068 3,261,461 6,754,189 19,849,722 87,243 160,906 137,958 250,837 736,447 29,526,028 27,977,302 Sky Harbor: Airlines Concessions Interest Other Phoenix-Goodyear Phoenix-Deer Valley Phoenix-Customer Facility Charge Total Aviation CONVENTION CENTER: 3,302,124 2,193,833 29,497 3,020,778 1,949,707 50,329 5,525,454 5,020,814 Excise Taxes Operating Revenue Interest Total Convention Center - 14 - Revenues For the Month Ended December 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: $ 19,197,010 401,813 224,454 477,218 70,440 187,527 387,524 $ 20,945,986 19,092,891 397,082 202,043 412,852 97,620 258,559 695,656 21,156,703 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 $ 214,205,140 2,831,335 1,847,257 4,886,147 823,440 1,102,032 1,756,824 $ 194,011,376 2,869,419 1,558,032 4,136,030 587,700 1,759,708 1,511,960 62.4 % 47.2 58.1 52.0 54.9 84.9 88.7 58.5 % 47.7 57.7 52.7 48.3 50.8 90.6 366,646,000 227,452,175 206,434,225 62.0 58.2 196,104,000 14,486,000 1,400,000 1,962,000 16,930,000 97,159,872 9,783,128 775,980 1,170,451 13,010,374 98,887,290 9,565,555 510,881 1,457,632 13,507,948 49.5 67.5 55.4 59.7 76.8 50.0 50.2 48.2 47.2 198.9 230,882,000 121,899,805 123,929,306 52.8 54.4 123,625,000 7,440,000 750,000 10,752,500 62,027,015 3,596,379 265,157 7,300,895 61,720,684 3,749,883 356,725 5,824,671 50.2 48.3 35.4 67.9 50.0 44.6 51.7 55.1 142,567,500 73,189,446 71,651,963 51.3 50.1 WASTEWATER: 16,156,903 1,616,740 64,740 167,747 857,560 16,474,785 1,599,872 83,520 214,590 9,080,188 18,863,690 27,452,955 Sewer Service Charges Multi-City Development Fees Interest Other Total Wastewater SOLID WASTE: 10,355,062 408,117 41,723 1,517,615 10,279,861 760,803 54,562 1,594,775 12,322,517 12,690,001 Collection Fees Landfill Fees Interest Other Total Solid Waste GOLF COURSES: $ 371,815 5,406 205,184 (9,975) 21,480 347,665 5,053 160,309 (11,575) 5,403 593,910 506,855 87,777,585 94,804,630 254,031,150 $ 267,580,723 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,376,620 41,180 877,547 (62,864) 51,719 1,231,421 31,445 752,632 (71,775) 129,443 33.6 52.5 43.7 33.9 40.4 32.8 42.8 40.7 50.3 75.2 6,129,618 2,284,202 2,073,166 37.3 36.3 1,132,651,778 613,555,650 596,375,322 54.2 53.0 48.1 % 48.3 % 3,010,937,189 $ 1,446,836,563 $ 1,456,487,810 Operating Expenditures and Encumbrances For the Month Ended December 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 $ 121,361 $ 250,074 (916,249) 3,304,647 189,318 228,088 227,137 1,530,108 139,341 371,244 292,690 1,015,075 (48,809) 9,738 242,456 2,041,669 507,656 129,158 258,426 229,473 2,578,094 64,733 207,941 242,662 1,659,100 224,855 478,072 30,452 764,377 (45,652) 14,946 248,754 1,646,736 - 9,505,544 8,732,127 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 $ 639,919 1,560,721 368,117 17,810,330 987,832 1,404,244 1,301,611 9,904,245 1,281,877 2,414,896 1,605,812 5,219,003 3,720 59,794 1,618,770 9,803,574 (937,820) $ 651,679 1,644,691 453,256 15,186,305 762,569 1,354,231 1,351,378 10,435,651 1,616,969 2,721,592 175,338 4,954,112 (60,910) 36,534 1,691,699 9,147,345 - $ 639,919 1,560,721 368,117 17,709,150 987,832 1,404,244 1,301,611 9,904,245 1,281,877 2,406,758 1,605,812 5,173,688 3,720 59,794 1,618,770 9,731,728 (937,820) $ 101,180 8,138 45,315 71,846 - 119,308,245 55,046,645 52,122,439 54,820,166 226,479 40,846,452 4,708,450 16,358,412 2,321,369 18,453,808 2,268,777 16,113,159 2,321,369 245,253 - 45,554,902 18,679,781 20,722,585 18,434,528 245,253 547,390,725 268,616,005 480,992 272,799,537 134,047,620 157,648 273,259,933 131,307,587 342,699 271,438,101 133,521,828 157,648 1,361,436 525,792 - 816,487,722 407,004,805 404,910,219 405,117,577 1,887,228 Criminal Justice 2,707,404 391,212 3,272,414 385,895 3,098,616 3,658,309 Municipal Court Public Defender Total Criminal Justice Public Safety 45,523,913 24,337,250 62,118 46,505,498 25,173,765 91,991 69,923,281 71,771,254 Police Fire Other Total Public Safety - 16 - Operating Expenditures and Encumbrances For the Month Ended December 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 $ 5,119,199 947,202 23,759,031 4,399,687 34,225,119 $ 1,640,266 839,019 24,535,796 4,945,021 31,960,102 Street Transportation Street Lighting Aviation Public Transit Total Transportation $ 58,632,945 11,685,358 290,441,289 247,575,530 $ 30,875,460 5,088,254 127,943,639 191,467,666 $ 28,300,273 5,346,347 125,456,174 184,583,096 $ 30,815,182 5,088,254 98,218,237 167,272,153 $ 60,278 29,725,402 24,195,513 608,335,122 355,375,019 343,685,890 301,393,826 53,981,193 Community Development 2,641,968 7,001,610 2,504,716 8,099,740 2,670,936 6,641,219 2,395,422 3,100,091 Planning and Development Housing Economic Development Neighborhood Services Department 33,601,910 75,137,220 37,775,681 105,929,214 16,395,996 39,781,417 12,833,230 28,464,341 15,733,436 38,493,176 14,827,932 23,231,924 16,395,996 39,744,962 11,690,837 28,464,341 36,455 1,142,393 - 20,248,034 14,807,668 Total Community Development 252,444,025 97,474,984 92,286,468 96,296,136 1,178,848 96,385,575 36,069,133 8,341,758 62,545,832 10,968,395 62,339,505 4,133,240 841,581 49,829,667 15,291,987 4,550,200 32,502,667 3,977,161 33,076,904 1,537,676 483,177 48,811,117 14,796,114 4,170,765 35,273,965 6,111,514 32,516,930 1,681,532 717,772 49,739,489 15,291,987 4,549,450 22,734,058 33,046,869 1,537,676 483,177 90,178 750 9,768,609 3,977,161 30,035 - 281,625,019 141,249,439 144,079,709 127,382,706 13,866,733 Community Enrichment 7,377,027 2,453,828 690,966 4,099,621 662,239 6,226,056 265,028 82,380 6,529,024 2,799,373 728,389 4,734,190 1,017,965 4,961,583 267,752 6,083 21,857,145 21,044,359 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 December 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,714,051 11,841,312 11,297,149 1,593,438 142,301 49,588,251 $ 26,922,141 12,914,408 10,762,435 (43,550) (286,359) 50,269,075 Water System Wastewater Solid Waste Management Public Works Environmental Programs $ Total Environmental Services 390,781,777 84,743,876 124,238,686 33,305,241 1,407,983 $ 144,288,211 72,560,795 55,123,368 8,234,417 365,240 $ 141,230,351 76,704,419 62,666,976 8,779,901 507,222 $ 92,290,995 35,251,395 48,683,077 7,802,270 365,240 $ 184,392,977 51,997,216 37,309,400 6,440,291 432,147 - 634,477,563 280,572,031 289,888,869 96,179,054 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 657,527 6,138,913 9,871,092 105,682 2,052,393 335,883 2,059,727 338,722 4,636,398 3,542,307 464,761 12,548,260 25,100 4,016,856 779,766 2,587,660 3,828 922,938 15,819,713 13,902,545 153,206 3,495,531 657,028 4,770,788 10,045,408 132,362 2,427,768 333,583 2,431,891 421,263 3,643,197 2,798,638 459,761 9,368,923 25,100 5,882,361 1,277,510 9,725,210 3,820 3,771,937 12,736,232 18,332,097 83,406 7,047,725 - 657,527 6,138,913 9,871,092 105,682 2,052,393 335,883 2,059,727 338,722 4,636,398 3,542,307 464,761 12,548,260 25,100 4,016,856 779,766 2,587,660 3,828 922,938 15,819,713 13,902,545 153,206 3,495,531 General Obligation Debt Service 109,587 1,023,152 1,645,182 17,614 342,066 55,981 343,288 56,453 772,733 590,384 77,460 2,091,377 4,183 669,476 129,961 431,277 153,823 2,636,619 2,317,091 25,534 582,467 109,505 795,131 1,674,234 22,060 404,628 55,598 405,315 70,211 607,199 466,439 76,627 1,561,488 4,183 980,394 212,918 1,768,513 628,656 2,122,706 3,055,356 13,901 1,191,543 14,075,708 16,226,605 Total Debt Service 138,718,984 84,458,808 96,376,008 - 84,458,808 31,526,500 20,589,078 Capital Improvement 493,021,254 109,932,127 118,625,409 - 109,932,127 $ 254,048,198 $ 239,058,577 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,549,793,639 $ 1,562,697,596 $ 1,187,837,916 $ 361,955,723 Capital Expenditures and Encumbrances For the Month Ended December 31 2011 2010 $ $ 55,531 $ 7,507,157 67,005 1,102,184 1,676,755 1,176,713 10,272,243 535,376 290,866 449,934 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 2010-11 Actual Yearto-Date 7,123,716 235,318,343 901,604 6,057,969 5,939,293 $ 3,425,568 84,269,306 12,943,367 3,229,825 2,811,991 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 12,895,338 523,695 6,057,969 126,616 $ 13,609,107 $ 382,222,294 3,708,529 17,445,800 7,096,407 222,423,005 377,909 5,812,677 Unencumbered Budget $ 7,680,391 200,494,326 9,351,910 11,659,012 13,258,507 938,303 22,724 2,256,597 399,415 49,368 1,625,758 Fire Protection Freeway Mitigation Historic Preservation Housing 21,140,399 2,759,359 64,544,234 8,746,319 267,967 16,646,375 4,553,738 1,072,430 20,786,108 86,883 48,568,331 9,920,128 21,140,399 2,672,476 15,975,903 8,746,319 267,967 6,726,247 12,394,080 2,491,392 47,897,859 128,525 1,717,784 32,341 289,073 58,443 3,013,879 155,616 272,736 Human Services Information Technology Libraries Neighborhood Services 2,857,262 14,253,403 7,697,854 11,785,676 12,669 3,917,007 1,763,448 1,075,926 4,402,050 4,820,234 2,904,723 1,767,345 10,256,533 1,454,500 3,966,861 3,139,734 1,066,071 427,744 2,857,262 3,996,870 6,243,354 7,818,815 12,669 777,273 697,377 648,182 2,844,593 10,336,396 5,934,406 10,709,750 14,560,030 113,413 712,335 262,608 7,375,220 447,855 2,952,502 1,905,470 Parks and Mountain Preserves Phoenix Convention Center Police Protection Public Transit 99,788,025 2,212,303 25,509,600 77,991,552 25,219,422 309,773 1,670,668 3,645,586 46,631,035 3,544,593 8,564,416 15,533,264 46,850,118 2,212,303 26,179,381 18,305,743 257,304 1,496,490 52,937,907 25,509,600 51,812,171 6,913,679 52,469 1,670,668 2,149,096 74,568,603 1,902,530 23,838,932 74,345,966 4,204,438 4,112,966 1,400,373 5,624,896 209,602 4,428,508 1,424,464 6,195,415 Solid Waste Disposal Street Transportation & Drainage Wastewater Water System 31,444,218 154,964,473 107,462,416 197,600,987 7,363,483 35,498,333 6,811,384 37,381,289 18,270,418 57,863,763 20,591,301 139,119,771 16,565,000 70,784,504 72,777,540 112,519,959 5,515,137 24,274,067 6,035,399 19,863,383 14,879,218 84,179,969 34,684,876 85,081,028 1,848,346 11,224,266 775,985 17,517,906 24,080,735 119,466,140 100,651,032 160,219,698 46,785,038 $ 43,239,383 Total Capital Improvement Program $ 1,319,796,832 $ 405,670,574 $ - 19 - 457,105,246 $ 493,021,254 $ 109,932,127 $ 826,775,578 $ 295,738,447 $ 914,126,258 Bonds Authorized and Sold As of December 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