City of Phoenix, Arizona Monthly Financial Report January 2012 Monthly Financial Report – January 2012 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 January 2012 are $17.2 million more than year-to-date revenues for January 2011. This is an increase of 1% and is due to increases in the enterprise funds of primarily Water, Wastewater and Aviation. (see page 7) • Revenues for the General Fund were $13.8 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 January 2012, local sales taxes were up $5.5 million compared to the prior year-to-date General Fund revenues. However, state shared taxes were down $13.3 million, Primary Property Taxes were down $1.5 million and Police revenue was down $2.6 million compared to the prior year-to-date. 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 January 2012 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 January 2012 are $12.2 million more than year to date expenditures for January 2011. The increase is mostly related to an increase of $15.1 million in citywide capital improvements (see pages 24 and 25). • Year to date General Fund expenditures for the first seven months of the fiscal year are slightly less than budgeted expenditures. This is primarily due to less expenditures as compared to the budget in capital improvements, environmental services, community development and transportation. • Capital fund year-to-date expenditures have decreased $7.2 million to $485.9 million from $493.1 million spent during the same period last year. The $485.9 million in capital expenditures includes projects at the Aviation department (including Phx Sky-Train) for $275.5 million. Decreases in capital expenditures as compared to last year to date include $102.3 million in Water, $14.7 in Parks and Preserves, $23.0 in Streets and Transportation and $11.3 million in Sewer projects. (see pages 26-27) -1- General Funds Summary Summary General Funds As of January 31 (dollars in thousands) Actual Year-to-Date 2011-12 2010-11 Budget Estimate 2011-12 % of Year-to-Date Estimate Actual 2011-12 2010-11 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 $ $ 417,006 2,465 $ 236,215 $ 1,864 230,748 1,867 56.6 % 75.6 58.8 % 76.4 110,696 122,065 48,045 126,763 3,270 9,567 65,133 71,172 26,206 67,668 1,632 4,688 63,748 83,794 28,311 69,196 1,810 4,785 58.8 58.3 54.5 53.4 49.9 49.0 57.0 58.3 58.6 52.9 58.5 49.9 20,759 1,100 12,598 1,256 7,103 993 5,124 11,447 504 6,772 744 2,830 570 3,502 11,246 515 9,327 713 4,557 587 3,396 55.1 45.8 53.8 59.2 39.8 57.4 68.3 52.7 44.4 57.8 57.4 60.8 52.3 64.6 36,750 12,462 300 14,890 20,828 7,252 410 8,670 20,841 7,310 148 9,034 56.7 58.2 136.7 58.2 56.6 59.7 44.1 51.9 953,212 $ 538,107 $ -2- 551,933 56.5 % 57.3 % Summary General Funds As of January 31 (dollars in thousands) Budget Estimate 2011-12 Actual Year-to-Date 2011-12 2010-11 % of Year-to-Date Estimate Actual 2011-12 2010-11 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 $ 753 $ 1,817 532 20,545 1,396 1,279 10,472 1,411 2,780 5,911 1,862 9,885 2,594 61,237 836 1,886 548 16,446 1,377 1,338 10,931 1,758 3,040 4,978 2,097 9,112 1,058 55,405 52.7 % 54.7 27.0 62.5 60.2 55.9 57.4 54.8 55.9 53.7 58.4 57.6 93.2 58.8 30,954 4,708 35,662 16,971 2,715 19,686 16,935 2,640 19,575 54.8 57.7 55.2 59.1 56.7 58.7 428,455 226,892 30 655,377 254,129 131,149 (27) 385,251 248,815 127,774 41 376,630 59.3 57.8 (90.0) 58.8 59.3 58.1 93.6 58.9 Transportation Street Transportation Public Transit Total Transportation 22,527 19,231 41,758 12,431 10,886 23,317 12,339 11,147 23,486 55.2 56.6 55.8 62.8 58.5 60.7 Community Development Economic Development Neighborhood Services Department Planning and Development Others Total Community Development 4,886 11,532 4,995 57 21,470 2,638 6,514 2,623 28 11,803 2,371 6,500 2,847 79 11,797 54.0 56.5 52.5 49.1 55.0 55.0 63.1 60.0 76.7 60.6 Community Enrichment Parks and Recreation Library Human Services Others Total Community Enrichment 89,567 35,277 18,493 2,121 145,458 52,053 17,223 10,105 1,012 80,393 51,090 18,813 10,056 1,407 81,366 58.1 48.8 54.6 47.7 55.3 59.3 58.2 59.0 62.2 59.0 Environmental Services Public Works Environmental Programs Total Environmental Services 16,400 978 17,378 8,514 434 8,948 6,025 606 6,631 51.9 44.4 51.5 45.9 66.5 47.2 3,733 1,793 282 48.0 25.1 37,890 - Criminal Justice Municipal Court Public Defender Total Criminal Justice Public Safety Police Fire Others Total Public Safety Capital Improvement Contingencies Total Expenditures and Encumbrances $ 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 1,062,848 $ $ 592,428 $ 575,172 62.5 % 58.6 33.0 586.2 60.3 57.3 60.6 66.2 84.0 53.9 66.2 49.5 55.9 78.4 55.7 % 60.2 % (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 January 31, 2012 3,500 3,000 (millions of dollars) 2,500 2,000 1,500 1,000 500 0 July Aug Sept Oct Nov Dec Current YTD Revenues Jan Feb Mar April May June Prior YTD Revenues Revenues Year-to-date revenues as of January 31 increased by $17,241,679 to $1,697,639,916 from the $1,680,398,237 collected during the same period last year, an increase of 1.0%. For the current year, 56.4% of the total estimated revenue has been collected. Of the total revenues received last year, 55.7% had been collected as of January 31. -4- Comparison to Prior Year Operating Expenditures YEAR-TO-DATE OPERATING EXPENDITURES (millions of dollars) As of January 31, 2012 3,200 3,100 3,000 2,900 2,800 2,700 2,600 2,500 2,400 2,300 2,200 2,100 2,000 1,900 1,800 1,700 1,600 1,500 1,400 1,300 1,200 1,100 1,000 900 800 700 600 500 400 300 200 100 0 July Aug Sept Oct Nov Dec Current YTD Expenditures Jan Feb Mar April May June Prior YTD Expenditures Operating Expenditures For the entire City, including enterprise funds such as Water Services and Aviation, year-to-date operating expenditures as of January 31 increased $12,168,211 to $1,788,748,927 from the $1,776,580,716 spent during the same period last year, an increase of 0.7%. For the current year, 51.5% of the total appropriations has been spent. Of the total actual expenditures for last year, 58.7% had been spent as of January 31. -5- Comparison to Prior Year Capital Expenditures YEAR-TO-DATE CAPITAL EXPENDITURES As of January 31, 2012 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 January 31 decreased $7,188,479 to $485,951,378 from the $493,139,857 spent during the same period last year, a decrease of 1.5%. For the current year, 36.8% of the total appropriations has been spent. Of the total actual expenditures for last year, 57.3% had been spent as of January 31. -6- Summary Operating Revenues As of January 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 $ 236,215 $ 1,864 230,748 1,867 % of Year-to-Date Estimate Actual 2011-12 2010-11 56.6 % 75.6 58.8 % 76.4 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 65,133 71,172 26,206 67,668 1,632 4,688 11,951 6,772 744 2,830 570 3,502 28,080 410 8,670 63,748 83,794 28,311 69,196 1,810 4,785 11,761 9,327 713 4,557 587 3,396 28,151 148 9,034 58.8 58.3 54.5 53.4 49.9 49.0 54.7 53.8 59.2 39.8 57.4 68.3 57.1 136.7 58.2 57.0 58.3 58.6 52.9 58.5 49.9 52.3 57.8 57.4 60.8 52.3 64.6 57.4 44.1 51.9 953,212 538,107 551,933 56.5 57.3 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 15,197 45,355 15,375 90,114 6,357 18,505 9,875 7,445 48,756 11,719 2,130 17,879 114,294 52,328 14,388 44,203 14,806 85,078 2,221 17,763 9,845 7,134 58,491 22,268 3,731 12,429 79,555 80,877 56.4 57.8 55.9 56.3 55.6 55.9 56.4 50.4 53.5 40.6 55.3 69.7 37.3 52.5 56.8 59.3 57.0 55.5 75.4 55.9 63.0 48.6 55.4 52.8 42.0 51.0 32.2 52.4 925,073 455,329 452,789 49.2 48.9 329,036 57,391 366,646 230,882 142,567 6,130 190,403 29,670 247,146 148,867 85,170 2,948 185,689 36,192 223,916 143,293 83,872 2,714 57.9 51.7 67.4 64.5 59.7 48.1 55.8 58.9 63.1 62.9 58.6 47.5 1,132,652 704,204 675,676 62.2 60.0 56.4 % 55.7 % 3,010,937 -7- $ 1,697,640 $ 1,680,398 Summary Operating Revenues As of January 31, 2012 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 Nov Dec Jan Feb Mar April May June Current YTD Revenues July Aug Sept Oct 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 January 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 $ 61,237 $ 2,077 63,314 55,405 4,743 60,148 58.8 % 13.7 53.1 35,662 9,893 45,555 19,686 1,788 21,474 19,575 4,220 23,795 55.2 18.1 47.1 58.7 116.2 64.4 Public Safety General Funds Other Funds Total Public Safety 655,377 161,111 816,488 385,251 91,114 476,365 376,630 93,471 470,101 58.8 56.6 58.3 58.9 61.4 59.4 Transportation General Funds Other Funds Total Transportation 41,758 566,577 608,335 23,317 365,144 388,461 23,486 353,436 376,922 55.8 64.4 63.9 60.7 66.8 66.4 Community Development General Funds Other Funds Total Community Development 21,470 230,974 252,444 11,803 102,200 114,003 11,797 92,857 104,654 55.0 44.2 45.2 60.6 59.3 59.4 Community Enrichment General Funds Other Funds Total Community Enrichment 145,458 136,167 281,625 80,393 78,511 158,904 81,366 85,472 166,838 55.3 57.7 56.4 59.0 62.4 60.7 Environmental Services General Funds Other Funds Total Environmental Services 17,378 617,100 634,478 8,948 315,065 324,013 6,631 326,788 333,419 51.5 51.1 51.1 47.2 58.5 58.2 Debt Service General Funds Other Funds Total Debt Service 138,719 138,719 98,817 98,817 112,408 112,408 71.2 71.2 57.1 57.1 Capital Improvement General Funds Other Funds Total Capital Improvement 3,733 489,288 493,021 1,793 141,605 143,398 282 128,014 128,296 48.0 28.9 29.1 25.1 38.8 38.8 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 - $ 592,428 1,196,321 1,788,749 $ -9- 575,172 1,201,409 1,776,581 55.7 49.6 51.5 % 78.4 % 64.1 77.1 60.2 58.0 58.7 % Summary Operating Expenditures and Encumbrances As of January 31, 2012 Total General Government Total Criminal Justice 90 40 80 70 60 (millions of dollars) (millions of dollars) 30 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 Aug Sept (millions of dollars) (millions of dollars) Nov Dec Jan Current YTD Expenditures Feb 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 Nov Dec Current YTD Expenditures Prior YTD Expenditures Total Public Safety July Oct 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 Mar April May June Aug Sept Oct 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 January 31, 2012 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 January 31 2011 2012 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 $ 36,385,190 258,845 $ 36,278,321 304,197 Local Taxes: Sales Taxes Privilege License Fees $ 417,006,000 2,464,500 $ 236,215,341 1,863,505 $ 230,747,627 1,866,669 56.6 % 75.6 58.8 % 76.4 36,644,035 36,582,518 Total Local Taxes 419,470,500 238,078,846 232,614,296 56.8 58.9 11,290,176 10,168,121 3,645,118 10,757,066 11,970,581 3,893,652 State Shared Taxes: State Sales Tax State Income Tax Vehicle License Tax 110,696,000 122,065,000 48,045,000 65,132,762 71,171,803 26,206,128 63,748,470 83,794,100 28,310,916 58.8 58.3 54.5 57.0 58.3 58.6 25,103,415 26,621,299 280,806,000 162,510,693 175,853,486 57.9 57.9 4,483,193 4,503,391 Primary Property Tax 126,763,000 67,667,537 69,196,060 53.4 52.9 191,728 198,113 Licenses and Permits 3,270,000 1,632,266 1,809,851 49.9 58.5 2,424,664 2,389,069 Cable Communications 9,567,056 4,687,667 4,785,239 49.0 49.9 1,642,836 76,988 1,587,753 79,223 Municipal Court: Fines and Forfeitures Court Default Fee 20,759,025 1,100,000 11,446,869 503,644 11,245,561 515,413 55.1 45.8 52.7 44.4 1,719,824 1,666,976 21,859,025 11,950,513 11,760,974 54.7 52.3 1,202,827 949,216 12,597,587 6,772,424 9,326,882 53.8 57.8 Total State Shared Taxes Total Municipal Court Police 177,106 125,884 Library Fees 1,256,140 744,352 713,213 59.3 57.4 355,107 966,939 Parks and Recreation 7,102,531 2,830,278 4,556,537 39.8 60.8 65,167 108,202 Planning and Development 993,300 569,885 587,336 57.4 52.3 670,788 812,118 Street Transportation 5,124,098 3,501,659 3,395,916 68.3 64.6 3,293,642 34,450 2,294,535 3,025,631 38,776 2,285,597 36,750,000 1,300,000 11,161,613 20,828,355 395,761 6,856,085 20,841,209 375,811 6,934,545 56.7 30.4 61.4 56.6 29.1 63.3 5,622,627 5,350,004 49,211,613 28,080,201 28,151,565 57.1 57.4 82,185 28,673 301,380 410,474 147,502 136.2 44.1 229,155 1,112,038 14,889,664 8,670,516 9,033,736 58.2 51.9 78,971,821 81,414,440 953,211,894 538,107,311 551,932,593 56.5 57.3 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 January 31 2011 2012 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,780,057 $ 127,148 635,735 (4,612) 1,751,008 125,072 625,360 (10,055) 2,538,328 2,491,385 5,095,399 1,646,734 (3,295) 5,032,443 1,633,165 2,209 6,738,838 6,667,817 2,570,027 2,543,538 10,171,756 5,510,273 10,005,762 4,783,147 15,682,029 14,788,909 - - 2,343,807 2,153,623 1,415,673 1,443,083 Neighborhood Protection: Police Neighborhood Protection Police Blockwatch Fire Neighborhood Protection Interest/Other $ Total Neighborhood Protection 18,837,000 1,345,000 6,726,000 48,000 $ 10,582,159 755,869 3,779,343 79,671 $ 10,100,263 721,448 3,607,237 (40,743) 56.2 % 56.2 56.2 166.0 56.9 % 56.6 56.6 96.6 26,956,000 15,197,042 14,388,205 56.4 56.8 58,269,000 20,108,000 140,000 33,576,411 11,803,550 (25,371) 32,563,916 11,595,046 44,149 57.6 58.7 (18.1) 58.9 60.5 92.2 78,517,000 45,354,590 44,203,111 57.8 59.3 27,510,000 15,375,440 14,806,377 55.9 57.0 107,640,000 52,325,926 60,469,481 29,644,485 57,715,791 27,362,047 56.2 56.7 56.9 52.8 159,965,926 90,113,966 85,077,838 56.3 55.5 Court Awards 11,425,309 6,356,648 2,220,900 55.6 75.4 Planning and Development 33,100,000 18,505,541 17,763,081 55.9 55.9 Capital Construction 17,502,000 9,874,968 9,844,913 56.4 63.0 Sports Facilities: Sales Taxes Interest/Other 14,386,000 395,000 7,064,693 379,878 6,709,052 425,281 49.1 96.2 47.7 70.4 Public Safety Enhancement & Expansion: Police Fire Interest/Other Total Public Safety Enhancement & Expansion Parks and Preserves Transit 2000: Sales Taxes Interest/Other Total Transit 2000 955,160 26,997 945,795 33,861 982,157 979,656 Total Sports Facilities 14,781,000 7,444,571 7,134,333 50.4 48.6 7,640,850 21,256 37,322 9,368,184 44,237 27,256 Highway User Revenue: Highway User Revenue Interest Other 90,226,000 600,000 300,000 48,409,691 188,592 158,163 58,107,001 276,541 107,802 53.7 31.4 52.7 55.4 50.9 79.2 7,699,428 9,439,677 91,126,000 48,756,446 58,491,344 53.5 55.4 1,931,271 2,195,890 Regional Transit Revenues 28,863,623 11,718,954 22,267,684 40.6 52.8 1,448,480 1,516,804 Community Reinvestment 3,853,899 2,129,857 3,730,840 55.3 42.0 6,057,666 2,972,308 Other Restricted Fees 25,633,671 17,879,437 12,429,149 69.7 51.0 Total Highway User Revenue - 13 - Revenues For the Month Ended January 31 2011 2012 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) $ 579,388 5,339,277 200,684 $ 556,690 5,218,888 275,437 6,119,349 6,051,015 4,245,243 10,219 1,834,011 13,774,991 1,919,702 268,369 634,522 1,971,799 19,864,464 4,794,392 25,983,813 10,845,407 3,205,910 2,585,966 5,138,397 18,596 5,791,876 5,156,993 81,183,393 63,195,090 Grants: Public Housing: Rentals Grants Other $ Total Public Housing 9,270,065 77,005,775 2,431,392 $ 3,978,430 39,288,335 1,038,589 $ 3,698,680 32,448,014 1,997,485 42.9 % 51.0 42.7 55.9 % 45.2 19.2 88,707,232 44,305,354 38,144,179 49.9 42.9 42,765,750 9,983,354 34,665,229 129,960,524 23,611,581 2,799,010 9,626,726 33,950,982 12,985,716 (2,117,236) 10,266,379 20,275,871 55.2 28.0 27.8 26.1 28.8 (11.2) 58.4 26.5 Total Other 217,374,857 69,988,299 41,410,730 32.2 26.2 Total Grants 306,082,089 114,293,653 79,554,909 37.3 32.2 94,529,000 5,228,000 49,772,586 2,555,117 78,313,549 2,563,192 52.7 48.9 52.6 48.2 99,757,000 52,327,703 80,876,741 52.5 52.4 925,073,517 455,328,816 452,789,425 49.2 48.9 108,000,000 173,799,000 1,620,000 3,286,000 1,724,000 3,606,500 37,000,000 51,828,791 113,226,454 932,336 1,619,732 973,277 1,684,416 20,137,465 47,904,188 114,966,041 772,614 2,397,004 966,692 1,964,443 16,717,748 48.0 65.1 57.6 49.3 56.5 46.7 54.4 57.7 58.5 57.0 32.7 59.2 60.8 42.5 329,035,500 190,402,471 185,688,730 57.9 55.8 39,685,000 17,106,160 600,000 21,232,822 8,190,931 246,589 20,291,290 15,532,084 368,089 53.5 47.9 41.1 53.6 67.4 58.9 57,391,160 29,670,342 36,191,463 51.7 58.9 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: 8,060,271 15,000,043 97,103 670,357 137,778 225,018 2,955,421 7,097,670 15,013,595 76,144 215,380 138,523 240,284 2,898,914 27,145,991 25,680,510 Sky Harbor: Airlines Concessions Interest Other Phoenix-Goodyear Phoenix-Deer Valley Phoenix-Customer Facility Charge Total Aviation CONVENTION CENTER: 3,132,724 1,035,277 28,799 3,287,632 577,741 47,648 4,196,800 3,913,021 Excise Taxes Operating Revenue Interest Total Convention Center - 14 - Revenues For the Month Ended January 31 2011 2012 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: $ 17,857,339 463,227 264,446 400,787 107,220 66,136 534,619 $ 19,693,774 15,748,461 488,564 230,815 133,217 88,860 346,553 445,744 17,482,214 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 $ 232,062,479 3,294,562 2,111,703 5,286,934 930,660 1,168,168 2,291,443 $ 209,759,837 3,357,983 1,788,847 4,269,247 676,560 2,106,261 1,957,704 67.6 % 54.9 66.4 56.3 62.0 90.0 115.7 63.2 % 55.9 66.2 54.4 55.6 60.8 117.4 366,646,000 247,145,949 223,916,439 67.4 63.1 196,104,000 14,486,000 1,400,000 1,962,000 16,930,000 113,483,323 11,611,643 877,500 1,395,572 21,499,181 115,401,223 11,296,287 597,960 1,764,876 14,232,378 57.9 80.2 62.7 71.1 127.0 58.4 59.3 56.5 57.2 209.6 230,882,000 148,867,219 143,292,724 64.5 62.9 123,625,000 7,440,000 750,000 10,752,500 72,391,615 4,012,056 306,140 8,460,111 71,989,811 4,570,135 415,686 6,896,747 58.6 53.9 40.8 78.7 58.3 54.4 60.2 65.3 142,567,500 85,169,922 83,872,379 59.7 58.6 WASTEWATER: 16,323,451 1,828,515 101,520 225,121 8,488,807 16,513,933 1,730,732 87,079 307,244 724,430 26,967,414 19,363,418 Sewer Service Charges Multi-City Development Fees Interest Other Total Wastewater SOLID WASTE: 10,364,600 415,677 40,983 1,159,216 10,269,127 820,252 58,961 1,072,076 11,980,476 12,220,416 Collection Fees Landfill Fees Interest Other Total Solid Waste GOLF COURSES: $ 470,434 6,357 188,213 (9,623) 8,303 465,853 6,268 173,453 (11,703) 7,447 663,684 641,318 90,648,139 79,300,897 250,803,353 $ 223,910,427 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,847,054 47,537 1,065,760 (72,487) 60,022 1,697,274 37,713 926,085 (83,478) 136,890 45.0 60.6 53.1 39.1 46.9 45.2 51.4 50.0 58.5 79.5 6,129,618 2,947,886 2,714,484 48.1 47.5 1,132,651,778 704,203,789 675,676,219 62.2 60.0 56.4 % 55.7 % 3,010,937,189 $ 1,697,639,916 $ 1,680,398,237 Operating Expenditures and Encumbrances For the Month Ended January 31 2012 2011 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 $ 113,258 $ 255,878 239,127 3,083,007 105,703 185,547 210,829 1,658,762 129,160 374,927 3,304 930,505 12,249 8,236 243,351 1,762,136 (1,048,409) 8,267,570 199,991 241,162 238,658 2,088,947 70,568 221,322 204,956 1,520,843 140,815 413,388 18,099 773,776 29,208 26,348 404,851 1,432,533 8,025,465 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 $ 753,177 1,816,599 607,244 20,893,337 1,093,535 1,589,791 1,512,440 11,563,007 1,411,037 2,789,823 1,609,116 6,149,508 15,969 68,030 1,862,121 11,565,710 (1,986,229) $ 851,670 1,885,853 691,914 17,275,252 833,137 1,575,553 1,556,334 11,956,494 1,757,784 3,134,980 193,437 5,727,888 (31,702) 62,882 2,096,550 10,579,878 - $ 753,177 1,816,599 607,244 20,777,297 1,093,535 1,589,791 1,512,440 11,563,007 1,411,037 2,780,488 1,609,116 6,097,529 15,969 68,030 1,862,121 11,483,298 (1,986,229) $ 116,040 9,335 51,979 82,412 - 119,308,245 63,314,215 60,147,904 63,054,449 259,766 40,846,452 4,708,450 18,759,358 2,714,883 21,155,219 2,640,171 18,478,184 2,714,883 281,174 - 45,554,902 21,474,241 23,795,390 21,193,067 281,174 547,390,725 268,616,005 480,992 320,584,713 155,593,831 186,305 317,382,357 152,339,290 378,962 319,007,240 154,990,993 186,305 1,577,473 602,838 - 816,487,722 476,364,849 470,100,609 474,184,538 2,180,311 Criminal Justice 2,400,946 393,514 2,701,411 371,394 2,794,460 3,072,805 Municipal Court Public Defender Total Criminal Justice Public Safety 47,785,176 21,546,211 28,657 44,122,424 21,031,703 36,263 69,360,044 65,190,390 Police Fire Other Total Public Safety - 16 - Operating Expenditures and Encumbrances For the Month Ended January 31 2012 2011 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 $ 3,530,425 935,374 19,557,096 9,063,177 33,086,072 $ 3,871,309 1,028,641 21,693,719 6,642,467 33,236,136 Street Transportation Street Lighting Aviation Public Transit Total Transportation $ 58,632,945 11,685,358 290,441,289 247,575,530 $ 34,405,885 6,023,628 147,500,735 200,530,843 $ 32,171,582 6,374,988 147,149,893 191,225,563 $ 34,336,742 6,023,628 112,823,435 171,507,057 $ 69,143 34,677,300 29,023,786 608,335,122 388,461,091 376,922,026 324,690,862 63,770,229 Community Development 2,397,427 6,176,678 1,733,037 6,221,033 2,401,458 5,769,932 1,695,832 2,499,826 Planning and Development Housing Economic Development Neighborhood Services Department 33,601,910 75,137,220 37,775,681 105,929,214 18,793,423 45,958,095 14,566,267 34,685,374 18,134,894 44,263,108 16,523,764 25,731,750 18,793,423 45,915,652 13,254,183 34,685,374 42,443 1,312,084 - 16,528,175 12,367,048 Total Community Development 252,444,025 114,003,159 104,653,516 112,648,632 1,354,527 96,385,575 36,069,133 8,341,758 62,545,832 10,968,395 62,339,505 4,133,240 841,581 55,694,436 17,622,295 5,128,346 36,662,633 4,628,232 36,943,530 1,808,664 415,663 55,365,298 19,150,571 4,725,856 39,468,767 7,129,478 38,198,127 1,977,891 822,055 55,591,007 17,622,295 5,127,596 25,294,682 36,909,091 1,808,664 415,663 103,429 750 11,367,951 4,628,232 34,439 - 281,625,019 158,903,799 166,838,043 142,768,998 16,134,801 Community Enrichment 5,864,769 2,330,308 578,146 4,159,966 651,071 3,866,626 270,988 (67,514) 17,654,360 6,554,181 4,354,457 555,091 4,194,802 1,017,964 5,681,197 296,359 104,283 22,758,334 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 January 31 2012 2011 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 $ 21,712,517 12,059,678 8,439,221 1,068,507 160,585 43,440,508 $ 21,009,899 12,429,591 8,560,059 1,399,932 130,876 43,530,357 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 $ 166,000,728 84,620,473 63,562,589 9,302,924 525,825 $ 162,240,250 89,134,010 71,227,035 10,179,833 638,098 $ 105,710,709 41,815,090 56,049,465 8,807,931 525,825 $ 212,909,020 60,290,019 42,805,383 7,513,124 494,993 - 634,477,563 324,012,539 333,419,226 111,103,519 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 767,115 7,162,065 11,516,274 123,296 2,394,458 391,863 2,403,015 395,176 5,409,131 4,132,692 542,222 14,642,877 29,283 4,686,332 909,726 3,241,014 3,828 1,076,760 18,456,332 16,219,636 178,741 4,135,045 766,532 5,565,919 11,719,643 154,423 2,832,396 389,180 2,837,206 491,473 4,250,397 3,265,078 536,388 10,933,650 29,283 6,862,754 1,490,429 1,768,514 20,349,243 628,656 14,858,937 21,387,452 97,307 1,193,184 - 767,115 7,162,065 11,516,274 123,296 2,394,458 391,863 2,403,015 395,176 5,409,131 4,132,692 542,222 14,642,877 29,283 4,686,332 909,726 3,241,014 3,828 1,076,760 18,456,332 16,219,636 178,741 4,135,045 General Obligation Debt Service 109,588 1,023,152 1,645,182 17,614 342,065 55,980 343,288 56,454 772,733 590,385 77,461 2,094,617 4,183 669,476 129,960 653,354 153,822 2,636,619 2,317,091 25,535 639,514 109,504 795,131 1,674,235 22,061 404,628 55,597 405,315 70,210 607,200 466,440 76,627 1,564,727 4,183 980,393 212,919 (7,956,696) 20,345,423 (3,143,281) 2,122,705 3,055,355 13,901 (5,854,541) 14,358,073 16,032,036 Total Debt Service 138,718,984 98,816,881 112,408,044 - 98,816,881 33,466,026 9,670,549 Capital Improvement 493,021,254 143,398,153 128,295,958 - 143,398,153 $ 238,955,288 $ 213,883,120 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 84,440,000 Contingencies Total Operating Budget $ 3,474,412,836 - 18 - $ 1,788,748,927 $ 1,776,580,716 $ 1,351,449,566 $ 437,299,361 Capital Expenditures and Encumbrances For the Month Ended January 31 2012 2011 $ $ 269,778 $ 40,139,760 90,359 953,801 330,959 2011-12 Actual YearBudget to-Date Program 245,820 9,908,054 51,968 304,607 352,654 Arts and Cultural Facilities Aviation Economic Development Energy Conservation Facilities Management 996,604 11,194 4,572,662 62,018 129,869 2,000,017 Fire Protection Freeway Mitigation Historic Preservation Housing 21,140,399 2,759,359 63,604,234 9,742,923 279,161 21,219,037 114,539 845,286 21,770 126,094 36,448 560,868 780,398 355,067 Human Services Information Technology Libraries Neighborhood Services 2,857,262 14,253,403 7,697,854 12,085,676 7,262,869 272,056 166,925 1,991,917 572,531 43,809 306,251 3,180,370 Parks and Mountain Preserves Phoenix Convention Center Police Protection Public Transit 4,303,979 5,983,211 2,041,229 9,785,812 612,699 6,577,507 (417,203) 10,370,859 80,280,804 $ 36,034,611 Solid Waste Disposal Street Transportation & Drainage Wastewater Water System Total Capital Improvement Program $ 14,804,107 $ 435,812,669 10,253,514 17,716,981 19,197,800 2011-12 Year-to-Date Capital Amounts From Operating Funds From Capital Funds Budget Actual Budget Actual 2010-11 Actual Yearto-Date 1,195,000 $ 53,590,375 6,544,985 17,716,981 1,752,000 187,309 21,573,237 597,078 7,011,770 129,031 4,615,756 1,202,299 22,786,125 86,883 48,568,331 13,964,998 21,140,399 2,672,476 15,035,903 9,742,923 279,161 7,254,039 11,397,476 2,480,198 42,385,197 127,208 4,762,293 1,785,218 1,202,020 4,438,498 5,381,102 3,685,121 2,122,412 10,256,533 1,454,500 3,966,861 3,124,965 1,081,812 521,884 2,857,262 3,996,870 6,243,354 8,118,815 127,208 1,637,328 703,406 680,136 2,730,054 9,491,110 5,912,636 10,883,656 99,788,025 2,212,303 25,509,600 77,991,552 32,482,291 581,829 1,837,593 5,637,503 47,203,566 3,588,402 8,870,667 18,713,634 46,850,118 2,212,303 26,179,381 24,689,060 529,360 1,571,567 52,937,907 25,509,600 51,812,171 7,793,231 52,469 1,837,593 4,065,936 67,305,734 1,630,474 23,672,007 72,354,049 31,444,218 155,604,473 107,462,416 197,600,987 11,667,462 41,481,544 8,852,613 47,167,101 18,883,117 64,441,270 20,174,098 149,490,630 16,565,000 70,784,504 72,777,540 112,519,959 7,071,322 26,578,308 7,820,795 26,945,657 14,879,218 84,819,969 34,684,876 85,081,028 4,596,140 14,903,236 1,031,818 20,221,444 19,776,756 114,122,929 98,609,803 150,433,886 $ 1,319,796,832 $ 7,393,494 275,458,103 991,963 7,011,770 6,270,252 $ 485,951,378 $ - 19 - 3,671,388 94,177,360 12,995,335 3,534,432 3,164,645 493,139,857 $ $ 493,021,254 $ 143,398,153 $ $ 13,609,107 $ 382,222,294 3,708,529 17,445,800 826,775,578 $ 7,206,185 253,884,866 394,885 6,141,221 Unencumbered Budget 342,553,225 $ $ 7,410,613 160,354,566 9,261,551 10,705,211 12,927,548 833,845,454 Bonds Authorized and Sold As of January 31 (dollars in thousands) Authorized Sold Available 1988 Authorizations General Obligation Bonds Freeway Mitigation, Neighborhood Stabilization, and Slum and Blight Elimination Bonds Fully Issued $ Total General Obligation Bonds Revenue Bonds Bonds Fully Issued Total 1988 Authorizations 29,285 884,175 $ 28,285 884,175 $ 1,000 - 913,460 912,460 1,000 143,890 143,890 - 1,057,350 1,056,350 1,000 66,300 125,300 24,800 61,500 12,000 33,000 91,500 74,000 77,000 78,800 66,000 43,700 64,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