City of Phoenix, Arizona Monthly Financial Report May 2012 Monthly Financial Report – May 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 • Revenues for the General Fund were $31.5 million less than prior year-to-date revenues. As of May 2012, local sales taxes were up $7.9 million compared to the prior year-to-date sales tax revenues. However, there were decreases in state shared taxes of $22.2 million, primary property taxes of $12.1 million and other fees and service charges of $2.5 million compared to the prior year-to-date revenues. • Year-to-date General Fund Revenues for the first eleven months are 88.6% of budgeted revenues. This percentage indicates General Fund revenues are trending lower than what was projected in the Budget Estimate. (see pages 1213) Expenditures • Citywide year-to-date expenditures for the month of May 2012 are $40.9 million less than year-to-date expenditures for May 2011. The decrease is mostly related to decreases in Water, Wastewater, and Public Works expenditures. (see pages 22-25) • Year-to-date General Fund expenditures for the first eleven months of the fiscal year are 83.3% of budgeted expenditures. This percentage indicates expenditures are lower compared to the budget. This is primarily due to less expenditure in capital improvements, environmental services, community development, and transportation. (see page 3) • However, year-to-date General Fund expenditures are $25.4 million more than prior year-to-date expenditures primarily due to a change in the accounting for the Information Technology Services (ITS) Department’s costs. (see page 3) In fiscal year 2011, ITS costs were charged directly to the user departments. In fiscal year 2012, ITS costs are budgeted in the General Fund and then user departments transfer amounts back to the General Fund through a centralized cost allocation model. • Capital fund year-to-date expenditures have decreased $76.2 million to $677.4 million from $753.6 million as of the same period last year. Significant decreases in capital expenditures as compared to last year-to-date include $124.2 million in Water, $29.6 million in Parks and Preserves, $66.0 in Streets and Transportation, and $20.6 million in Public Transit projects. Decreases in Capital Fund year-todate expenditures are partially offset by increases at the Aviation Department (including PHX Sky-Train) of $175.1 million. (see pages 26-27) -1- General Funds Summary Summary General Funds As of May 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 367,773 $ 2,272 359,918 2,378 88.2 % 92.2 91.7 % 97.4 110,696 122,065 48,045 126,763 3,270 9,567 102,745 111,844 41,965 102,877 2,669 7,121 102,637 131,676 44,447 114,921 2,867 7,192 92.8 91.6 87.3 81.2 81.6 74.4 91.8 91.7 92.0 87.8 92.7 75.0 20,759 1,100 12,598 1,256 7,103 993 5,124 19,666 1,119 14,610 1,221 5,558 969 4,966 19,555 1,079 15,074 1,133 6,651 1,042 5,163 94.7 101.7 116.0 97.2 78.2 97.6 96.9 91.7 93.0 93.5 91.1 88.7 92.7 98.3 36,750 12,462 300 14,890 32,610 10,931 674 12,818 33,455 11,119 281 15,363 88.7 87.7 224.7 86.1 90.8 90.8 84.2 88.3 953,212 $ % of Year-to-Date Estimate Actual 2011-12 2010-11 $ 844,408 $ -2- 875,951 88.6 % 91.0 % Summary General Funds As of May 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 $ 1,240 2,948 1,439 57 2,158 2,118 16,693 2,420 3,260 8,502 3,219 17,097 1,740 62,891 30,954 4,708 35,662 25,507 4,248 29,755 26,374 4,154 30,528 82.4 90.2 83.4 92.0 89.2 91.6 Public Safety Police Fire Others Total Public Safety 428,455 226,892 30 655,377 381,706 199,510 581,216 387,908 199,923 161 587,992 89.1 87.9 88.7 92.5 90.8 369.8 91.9 Transportation Street Transportation Public Transit Total Transportation 22,527 19,231 41,758 16,527 17,071 33,598 18,196 17,475 35,671 73.4 88.8 80.5 92.5 91.7 92.1 Community Development Economic Development Neighborhood Services Department Planning and Development Others Total Community Development 4,886 11,532 4,995 57 21,470 3,841 9,435 3,995 45 17,316 3,889 9,365 4,437 98 17,789 78.6 81.8 80.0 78.9 80.7 90.3 90.9 93.6 95.7 91.4 Community Enrichment Parks and Recreation Library Human Services Others Total Community Enrichment 89,567 35,277 18,493 2,121 145,458 77,723 28,587 14,072 1,597 121,979 77,941 28,875 15,487 1,951 124,254 86.8 81.0 76.1 75.3 83.9 90.4 89.4 90.9 86.3 90.2 Environmental Services Public Works Environmental Programs Total Environmental Services 16,400 978 17,378 12,334 669 13,003 9,967 832 10,799 75.2 68.4 74.8 75.9 91.3 76.9 3,733 2,103 528 56.3 47.1 37,890 - Capital Improvement Contingencies Total Expenditures and Encumbrances (1) $ 1,062,848 $ % of Year-to-Date Estimate Actual 2011-12 2010-11 1,279 $ 2,788 1,406 25,456 2,077 1,919 15,899 1,693 4,184 8,964 2,524 14,630 3,290 86,109 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 $ 885,079 $ 870,452 In prior years, Information Technology Services' charges were allocated to user departments. -3- 89.6 % 83.9 71.3 77.4 89.6 83.9 87.2 65.7 84.2 81.4 79.1 85.3 118.3 82.7 83.3 % 92.7 % 91.6 86.7 2.0 94.5 90.7 92.6 91.1 90.1 92.0 101.6 92.9 91.9 89.0 91.2 % Citywide Summary Comparison to Prior Year Revenues YEAR-TO-DATE REVENUES As of May 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 May 31 decreased by $6,391,391 to $2,674,759,338 from the $2,681,150,729 collected during the same period last year, a decrease of 0.2%. For the current year, 88.8% of the total estimated revenue has been collected. Of the total revenues received last year, 88.9% had been collected as of May 31. -4- Comparison to Prior Year Operating Expenditures YEAR-TO-DATE OPERATING EXPENDITURES (millions of dollars) As of May 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 May 31 decreased $40,903,574 to $2,667,134,250 from the $2,708,037,824 spent during the same period last year, a decrease of 1.5%. For the current year, 76.8% of the total appropriations has been spent. Of the total actual expenditures for last year, 89.5% had been spent as of May 31. -5- Comparison to Prior Year Capital Expenditures YEAR-TO-DATE CAPITAL EXPENDITURES As of May 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 May 31 decreased $76,213,403 to $677,394,840 from the $753,608,243 spent during the same period last year, a decrease of 10.1%. For the current year, 51.3% of the total appropriations has been spent. Of the total actual expenditures for last year, 87.5% had been spent as of May 31. -6- Summary Operating Revenues As of May 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 367,773 $ 2,272 359,918 2,378 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 102,745 111,844 41,965 102,877 2,669 7,121 20,785 14,610 1,221 5,558 969 4,966 43,541 674 12,818 102,637 131,676 44,447 114,921 2,867 7,192 20,634 15,074 1,133 6,651 1,042 5,163 44,574 281 15,363 92.8 91.6 87.3 81.2 81.6 74.4 95.1 116.0 97.2 78.2 97.6 96.9 88.5 224.7 86.1 91.8 91.7 92.0 87.8 92.7 75.0 91.8 93.5 91.1 88.7 92.7 98.3 90.8 84.2 88.3 953,212 844,408 875,951 88.6 91.0 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 24,195 70,077 24,494 144,505 7,414 31,080 15,274 13,847 83,088 23,255 2,911 31,316 212,518 78,741 23,028 68,187 23,629 138,713 2,692 28,443 15,562 13,391 96,213 22,342 7,303 19,917 173,918 136,741 89.8 89.3 89.0 90.3 64.9 93.9 87.3 93.7 91.2 80.6 75.5 122.2 69.4 78.9 90.9 91.5 91.0 90.5 91.3 89.4 99.5 91.2 91.1 53.0 82.2 81.7 70.4 88.6 925,073 762,715 770,079 82.4 83.1 329,036 57,391 366,646 230,882 142,567 6,130 309,206 50,975 346,438 222,129 133,128 5,760 300,539 56,949 316,233 223,852 132,100 5,448 94.0 88.8 94.5 96.2 93.4 94.0 90.4 92.6 89.2 98.3 92.3 95.4 1,132,652 1,067,636 1,035,121 94.3 92.0 2,674,759 $ 2,681,151 88.8 % 88.9 % 3,010,937 -7- $ % of Year-to-Date Estimate Actual 2011-12 2010-11 $ 88.2 % 92.2 91.7 % 97.4 Summary Operating Revenues As of May 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 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 May 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 $ 86,109 $ 9,958 96,067 62,891 7,586 70,477 82.7 % 65.6 80.5 89.0 % 102.5 90.3 35,662 9,893 45,555 29,755 2,531 32,286 30,528 6,532 37,060 83.4 25.6 70.9 91.6 179.8 100.3 Public Safety General Funds Other Funds Total Public Safety 655,377 161,111 816,488 581,216 138,771 719,987 587,992 143,796 731,788 88.7 86.1 88.2 91.9 94.4 92.4 Transportation General Funds Other Funds Total Transportation 41,758 566,577 608,335 33,598 503,469 537,067 35,671 487,975 523,646 80.5 88.9 88.3 92.1 92.2 92.2 Community Development General Funds Other Funds Total Community Development 21,470 230,974 252,444 17,316 153,907 171,223 17,789 143,109 160,898 80.7 66.6 67.8 91.4 91.4 91.4 Community Enrichment General Funds Other Funds Total Community Enrichment 145,458 136,167 281,625 121,979 117,965 239,944 124,254 128,498 252,752 83.9 86.6 85.2 90.2 93.8 92.0 Environmental Services General Funds Other Funds Total Environmental Services 17,378 617,100 634,478 13,003 476,828 489,831 10,799 514,158 524,957 74.8 77.3 77.2 76.9 92.0 91.7 Debt Service General Funds Other Funds Total Debt Service 138,719 138,719 155,120 155,120 176,524 176,524 111.8 111.8 89.7 89.7 Capital Improvement General Funds Other Funds Total Capital Improvement 3,733 489,288 493,021 2,103 223,505 225,608 528 229,408 229,936 56.3 45.7 45.8 47.1 69.6 69.5 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 - $ 885,079 1,782,054 2,667,133 $ -9- 870,452 1,837,586 2,708,038 83.3 73.9 76.8 % 91.2 88.7 89.5 % Summary Operating Expenditures and Encumbrances As of May 31, 2012 Total General Government Total Criminal Justice 120 40 100 80 (millions of dollars) (millions of dollars) 30 60 40 20 10 20 0 0 July July Aug Sept Oct Nov Dec Jan Feb Mar April May June Current YTD Expenditures Aug Sept Oct Nov Dec Jan Current YTD Expenditures Prior YTD Expenditures Feb Mar April May June Prior YTD Expenditures see Note 1 on page 3 for General Government explanation. 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 (millions of dollars) (millions of dollars) Total Public Safety July Aug Sept Oct Nov Dec Current YTD Expenditures Jan Feb 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 May 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 Revenues For the Month Ended May 31 2012 2011 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 $ 32,521,329 70,321 $ 33,039,994 96,413 Local Taxes: Sales Taxes Privilege License Fees $ 417,006,000 2,464,500 $ 367,772,578 2,272,014 $ 359,917,573 2,377,638 88.2 % 92.2 91.7 % 97.4 32,591,650 33,136,407 Total Local Taxes 419,470,500 370,044,592 362,295,211 88.2 91.8 9,743,354 10,168,121 3,796,109 10,048,379 11,970,581 4,090,677 State Shared Taxes: State Sales Tax State Income Tax Vehicle License Tax 110,696,000 122,065,000 48,045,000 102,745,010 111,844,286 41,964,686 102,637,130 131,676,426 44,447,531 92.8 91.6 87.3 91.8 91.7 92.0 23,707,584 26,109,637 280,806,000 256,553,982 278,761,087 91.4 91.8 20,741,109 31,815,684 Primary Property Tax 126,763,000 102,877,226 114,920,767 81.2 87.8 268,629 259,401 Licenses and Permits 3,270,000 2,668,812 2,866,717 81.6 92.7 Cable Communications 9,567,056 7,120,810 7,191,712 74.4 75.0 Municipal Court: Fines and Forfeitures Court Default Fee 20,759,025 1,100,000 19,665,768 1,119,251 19,555,515 1,079,116 94.7 101.8 91.7 93.0 21,859,025 20,785,019 20,634,631 95.1 91.8 12,597,587 14,610,503 15,074,081 116.0 93.5 Library Fees 1,256,140 1,220,620 1,132,753 97.2 91.1 Parks and Recreation 7,102,531 5,557,577 6,650,923 78.2 88.7 993,300 968,778 1,041,754 97.5 92.7 5,124,098 4,966,429 5,163,535 96.9 98.3 36,750,000 1,300,000 11,161,613 32,610,460 920,890 10,010,159 33,455,010 1,105,100 10,013,762 88.7 70.8 89.7 90.8 85.6 91.4 49,211,613 43,541,509 44,573,872 88.5 90.8 - - Total State Shared Taxes 1,693,636 96,639 1,748,542 97,477 1,790,275 1,846,019 1,486,242 1,135,036 121,419 116,739 963,020 1,004,750 140,147 129,140 Planning and Development 456,381 595,650 Street Transportation 2,645,753 300,625 646,297 1,819,134 289,257 157,861 3,592,675 2,266,252 144,022 52,156 1,179,530 392,935 87,182,683 98,859,806 Total Municipal Court Police Fire: Emergency Transportation Service Hazardous Materials Inspection Fee Other Total Fire Interest Other Fees and Service Charges Total General Funds - 12 - 301,380 674,046 281,395 223.7 84.2 14,889,664 12,817,999 15,363,035 86.1 88.3 953,211,894 844,407,902 875,951,473 88.6 91.0 Revenues Revenues For the Month Ended May 31 2012 2011 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,554,856 $ 111,062 555,305 (3,569) 1,551,292 110,808 554,033 (2,659) 2,217,654 2,213,474 4,513,017 1,476,563 (5,579) 4,471,296 1,454,430 (40) Neighborhood Protection: Police Neighborhood Protection Police Blockwatch Fire Neighborhood Protection Interest/Other Total Neighborhood Protection $ 16,894,083 1,206,721 6,033,601 60,527 $ 16,143,488 1,153,107 5,765,532 (33,669) 89.7 % 89.7 89.7 126.1 91.0 % 90.5 90.5 79.8 24,194,932 23,028,458 89.8 90.9 58,269,000 20,108,000 140,000 52,165,165 17,961,893 (50,293) 50,537,359 17,601,201 48,733 89.5 89.3 (35.9) 91.4 91.8 101.8 78,517,000 70,076,765 68,187,293 89.3 91.5 27,510,000 24,494,353 23,628,907 89.0 91.0 107,640,000 52,325,926 96,537,614 47,967,415 92,248,506 46,464,534 89.7 91.7 91.0 89.7 159,965,926 144,505,029 138,713,040 90.3 90.5 Court Awards 11,425,309 7,413,676 2,691,773 64.9 91.3 Public Safety Enhancement & Expansion: Police Fire Interest/Other 5,984,001 5,925,686 2,271,139 Parks and Preserves 8,884,888 3,517,944 8,864,528 3,865,213 Transit 2000: Sales Taxes Interest/Other 12,402,832 12,729,741 - 18,837,000 1,345,000 6,726,000 48,000 26,956,000 2,244,324 - $ Total Public Safety Enhancement & Expansion Total Transit 2000 2,875,762 2,984,106 Planning and Development 33,100,000 31,080,380 28,443,130 93.9 89.4 1,426,904 1,426,068 Capital Construction 17,502,000 15,274,344 15,562,387 87.3 99.5 1,508,035 21,709 1,428,223 39,229 Sports Facilities: Sales Taxes Interest/Other 14,386,000 395,000 13,370,216 476,727 12,824,665 565,996 92.9 120.7 91.1 93.7 1,529,744 1,467,452 Total Sports Facilities 14,781,000 13,846,943 13,390,661 93.7 91.2 7,933,589 21,181 3,958 9,210,003 66,821 4,661 Highway User Revenue: Highway User Revenue Interest Other 90,226,000 600,000 300,000 82,630,444 274,672 182,623 95,582,780 494,065 135,794 91.6 45.8 60.9 91.1 90.9 99.8 7,958,728 9,281,485 91,126,000 83,087,739 96,212,639 91.2 91.1 5,466,324 12,210 Regional Transit Revenues 28,863,623 23,255,276 22,342,386 80.6 53.0 181,450 19,825 Community Reinvestment 3,853,899 2,911,514 7,302,504 75.5 82.2 3,042,888 1,467,982 25,633,671 31,315,836 19,916,637 122.2 81.7 Total Highway User Revenue Other Restricted Fees - 13 - Revenues Revenues For the Month Ended May 31 2012 2011 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) $ Grants: Public Housing: Rentals Grants Other 702,638 $ 6,593,544 (239,084) 597,629 5,637,213 1,440,586 7,057,098 7,675,428 4,750,524 3,939,091 771,483 13,056,893 5,950,311 1,541,845 1,241,132 3,528,119 22,517,991 12,261,407 29,575,089 19,936,835 15,211,058 64,214 36,270,946 2,611,915 15,275,272 38,882,861 Total G.O. Bond Debt Service 90,180,972 98,618,864 Total Special Revenue and Debt Service $ Total Public Housing 9,270,065 77,005,775 2,431,392 $ 6,410,167 63,660,005 1,683,439 $ 6,007,453 56,269,065 4,516,295 69.1 % 82.7 69.2 90.7 % 78.3 43.5 88,707,232 71,753,611 66,792,813 80.9 75.2 42,765,750 9,983,354 34,665,229 129,960,524 38,594,808 15,841,818 18,077,350 68,250,205 36,308,714 4,946,657 16,852,277 49,017,487 90.2 158.7 52.1 52.5 80.5 26.2 95.8 64.0 Total Other 217,374,857 140,764,181 107,125,135 64.8 67.8 Total Grants 306,082,089 212,517,792 173,917,948 69.4 70.4 94,529,000 5,228,000 76,085,013 2,655,821 131,482,119 5,259,092 80.5 50.8 88.2 98.9 99,757,000 78,740,834 136,741,211 78.9 88.6 925,073,517 762,715,413 770,078,974 82.4 83.1 108,000,000 173,799,000 1,620,000 3,286,000 1,724,000 3,606,500 37,000,000 83,124,467 180,915,693 1,302,706 2,990,019 1,533,794 2,630,900 36,708,076 76,047,873 180,406,419 1,171,793 3,692,359 1,498,879 2,920,927 34,800,700 77.0 104.1 80.4 91.0 89.0 72.9 99.2 91.6 91.7 86.5 50.4 91.8 90.5 88.4 329,035,500 309,205,655 300,538,950 94.0 90.4 39,685,000 17,106,160 600,000 36,304,708 14,318,876 351,184 34,453,640 21,921,669 573,813 91.5 83.7 58.5 91.1 95.2 91.8 57,391,160 50,974,768 56,949,122 88.8 92.6 Other: Human Resources Federal Transit Administration Community Development Other G.O. Bond Debt Service Secondary Property Tax Interest Enterprise Funds AVIATION: 7,781,315 17,295,038 87,082 266,474 140,760 230,629 4,392,783 7,109,361 14,765,007 131,514 721,689 136,213 235,152 3,988,498 30,194,081 27,087,434 Sky Harbor: Airlines Concessions Interest Other Phoenix-Goodyear Phoenix-Deer Valley Phoenix-Customer Facility Charge Total Aviation CONVENTION CENTER: 3,587,322 1,337,495 24,695 3,413,727 1,600,735 58,587 4,949,512 5,073,049 Excise Taxes Operating Revenue Interest Total Convention Center - 14 - Revenues Revenues For the Month Ended May 31 2012 2011 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: $ 30,810,310 454,895 350,518 489,647 178,140 135,415 216,328 $ 32,635,253 27,959,153 529,276 206,028 658,701 33,960 294,966 220,566 29,902,650 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 $ 323,908,621 5,170,038 3,353,734 7,264,856 1,705,080 1,701,893 3,333,922 $ 294,049,420 5,489,416 2,737,064 6,811,548 1,066,560 3,169,602 2,909,562 94.4 % 86.2 105.5 77.3 113.7 131.1 168.4 88.6 % 91.3 101.3 86.8 87.6 91.5 174.4 366,646,000 346,438,144 316,233,172 94.5 89.2 196,104,000 14,486,000 1,400,000 1,962,000 16,930,000 178,291,911 18,070,809 1,563,180 2,028,188 22,174,546 180,800,094 17,534,927 926,039 2,710,077 21,880,646 90.9 124.7 111.7 103.4 131.0 91.5 92.1 87.4 87.8 322.2 230,882,000 222,128,634 223,851,783 96.2 98.3 123,625,000 7,440,000 750,000 10,752,500 113,897,830 6,141,873 467,246 12,621,530 113,161,181 7,499,329 637,765 10,801,634 92.1 82.6 62.3 117.4 91.6 89.3 92.4 102.2 142,567,500 133,128,479 132,099,909 93.4 92.3 WASTEWATER: 16,420,226 1,495,702 159,240 137,916 1,520,478 16,290,878 1,397,961 24,060 255,462 807,480 19,733,562 18,775,841 Sewer Service Charges Multi-City Development Fees Interest Other Total Wastewater SOLID WASTE: 10,415,697 659,222 36,193 1,179,634 10,307,751 736,546 55,592 1,299,489 12,290,746 12,399,378 Collection Fees Landfill Fees Interest Other Total Solid Waste GOLF COURSES: $ 271,698 6,144 163,515 (7,465) 6,859 300,607 2,105 170,033 (12,798) 6,476 440,751 466,423 100,243,905 93,704,775 277,607,560 $ 291,183,445 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 3,788,691 73,512 1,907,284 (106,739) 97,595 3,600,039 61,234 1,734,153 (130,287) 182,207 92.4 93.8 95.0 57.6 76.2 95.9 83.4 93.7 91.3 105.9 6,129,618 5,760,343 5,447,346 94.0 95.4 1,132,651,778 1,067,636,023 1,035,120,282 94.3 92.0 2,681,150,729 88.8 % 88.9 % 3,010,937,189 $ 2,674,759,338 $ Operating Expenditures and Encumbrances For the Month Ended May 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 $ 141,818 $ 221,893 207,624 2,384,382 69,630 153,814 166,102 1,330,749 131,259 305,175 11,448 766,598 (9,293) 30,687 (77,358) 1,383,785 378,040 102,516 244,796 238,069 (2,040) 84,264 217,507 223,384 1,570,720 237,644 407,681 31,270 764,085 33,123 8,797 271,914 2,191,770 - 7,596,353 6,625,500 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 $ 1,279,112 2,788,002 1,536,556 25,973,948 1,413,467 2,352,882 2,283,737 17,560,216 1,693,032 4,198,100 1,903,282 9,344,525 82,952 83,058 2,524,114 17,172,294 3,878,075 $ 1,255,400 2,947,924 1,701,506 1,454,850 1,151,751 2,444,563 2,465,165 18,240,692 2,420,021 3,409,582 367,392 9,644,904 123,876 110,853 3,218,845 19,519,831 - $ 1,279,112 2,788,002 1,536,556 25,798,467 1,413,467 2,352,882 2,283,737 17,560,216 1,693,032 4,183,977 1,903,282 9,265,890 82,952 83,058 2,524,114 17,047,620 3,878,075 $ 175,481 14,123 78,635 124,674 - 119,308,245 96,067,352 70,477,155 95,674,439 392,913 40,846,452 4,708,450 28,038,623 4,247,499 32,905,188 4,154,491 27,613,765 4,247,499 424,858 - 45,554,902 32,286,122 37,059,679 31,861,264 424,858 547,390,725 268,616,005 480,992 484,388,334 235,222,838 376,159 494,503,841 236,694,932 589,213 481,946,711 234,311,816 376,159 2,441,623 911,022 - 816,487,722 719,987,331 731,787,986 716,634,686 3,352,645 Criminal Justice 2,091,704 379,983 2,914,270 377,991 2,471,687 3,292,261 Municipal Court Public Defender Total Criminal Justice Public Safety 36,963,200 18,462,989 80,537 44,759,163 21,271,679 (2,167) 55,506,726 66,028,675 Police Fire Other Total Public Safety - 16 - Operating Expenditures and Encumbrances For the Month Ended May 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 $ 4,258,558 897,160 23,935,392 12,043,529 41,134,639 $ 4,051,925 881,998 20,582,767 8,179,641 33,696,331 Street Transportation Street Lighting Aviation Public Transit Total Transportation $ 58,632,945 11,685,358 290,441,289 247,575,530 $ 50,591,246 9,570,755 241,361,908 235,542,683 $ 49,706,074 10,216,451 234,308,816 229,414,372 $ 50,486,646 9,570,755 179,957,932 187,202,443 $ 104,600 61,403,976 48,340,240 608,335,122 537,066,592 523,645,713 427,217,776 109,848,816 Community Development 2,238,800 6,114,553 1,749,936 3,786,208 2,488,729 6,188,382 1,664,012 3,503,392 Planning and Development Housing Economic Development Neighborhood Services Department 33,601,910 75,137,220 37,775,681 105,929,214 28,074,309 70,759,493 21,733,673 50,655,710 29,037,153 69,767,649 23,485,009 38,608,275 28,074,309 70,693,096 19,742,824 50,655,710 66,397 1,990,849 - 13,889,497 13,844,515 Total Community Development 252,444,025 171,223,185 160,898,086 169,165,939 2,057,246 96,385,575 36,069,133 8,341,758 62,545,832 10,968,395 62,339,505 4,133,240 841,581 83,106,406 29,395,961 7,346,995 52,265,290 7,232,514 57,056,499 2,922,614 617,635 84,639,154 29,742,182 7,184,461 56,360,056 11,202,958 59,548,998 3,054,056 1,020,149 82,949,969 29,395,961 7,346,245 34,503,974 57,004,443 2,922,614 617,635 156,437 750 17,761,316 7,232,514 52,056 - 281,625,019 239,943,914 252,752,014 214,740,841 25,203,073 Community Enrichment 7,286,030 3,838,171 513,298 3,505,612 651,071 5,225,498 335,159 61,988 7,705,211 2,756,175 615,622 4,232,710 1,019,585 5,106,549 408,164 72,934 21,416,827 21,916,950 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 May 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 $ 18,217,678 6,162,955 17,342,896 621,410 119,576 42,464,515 $ 23,294,747 11,880,979 9,301,305 4,359,744 192,868 49,029,643 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 $ 244,732,291 122,875,497 107,663,733 13,490,231 1,069,665 $ 257,558,133 140,501,150 109,227,928 16,461,261 1,208,861 $ 155,297,430 63,941,052 95,859,276 12,743,857 1,069,665 $ 328,911,280 89,434,861 58,934,445 11,804,457 746,374 - 634,477,563 489,831,417 524,957,333 160,920,137 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 1,205,467 11,254,674 18,097,002 193,751 3,762,720 615,785 3,776,167 620,991 8,500,064 6,494,230 852,062 23,008,383 46,017 7,364,236 1,429,570 4,966,183 3,834 1,692,115 29,002,807 25,487,999 280,878 6,464,973 1,204,550 8,746,445 18,416,582 242,664 4,450,907 611,568 4,458,466 772,316 6,679,195 5,130,837 842,896 17,179,598 46,017 10,784,329 2,342,102 8,134,189 20,349,250 3,143,600 23,349,758 33,608,875 152,911 5,877,292 - 1,205,467 11,254,674 18,097,002 193,751 3,762,720 615,785 3,776,167 620,991 8,500,064 6,494,230 852,062 23,008,383 46,017 7,364,236 1,429,570 4,966,183 3,834 1,692,115 29,002,807 25,487,999 280,878 6,464,973 General Obligation Debt Service 109,588 1,023,152 1,645,182 17,614 342,066 55,981 343,288 56,454 772,733 590,385 77,460 2,091,376 4,184 669,476 129,961 431,339 153,886 2,636,619 2,317,090 25,534 582,528 109,504 795,132 1,674,235 22,060 404,628 55,597 405,315 70,211 607,199 466,440 76,627 1,561,487 4,184 980,394 212,918 1,591,657 628,975 2,122,705 3,055,356 13,901 1,171,226 14,075,896 16,029,751 Total Debt Service 138,718,984 155,119,908 176,524,347 - 155,119,908 29,927,020 27,910,603 Capital Improvement 493,021,254 225,608,429 229,935,511 - 225,608,429 $ 228,483,160 $ 238,374,229 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 - $ 2,667,134,250 $ 2,708,037,824 $ 1,984,206,225 $ 682,928,025 Capital Expenditures and Encumbrances For the Month Ended May 31 2012 2011 $ 11,299,352 $ 11,135,230 (191,273) 530,805 658,283 38,717 67,214 3,971,295 7,441,620 (2,328) 2,306,205 141,112 2,494,568 15,195 1,387,508 42,164 168,054 635,527 130,860 1,836,119 77,313 (27,417) 780,927 $ 5,653,580 10,747,500 (22,080) 925,195 1,381,408 7,415,840 8,749 282,946 1,603,074 42,707 4,560,117 37,617,976 15,314,235 740,446 7,942,675 2,319,421 12,304,721 91,749,983 $ 62,025,577 Capital Expenditures and Encumbrances 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,143,514 17,716,981 19,197,800 20,658,741 $ 310,158,946 4,930,872 9,526,289 8,053,791 2011-12 Year-to-Date Capital Amounts From Operating Funds From Capital Funds Budget Actual Budget Actual 2010-11 Actual Yearto-Date 10,121,499 135,105,338 14,370,274 5,637,801 12,902,339 $ 1,195,000 $ 53,590,375 6,544,985 17,716,981 1,752,000 258,755 31,499,063 3,787,659 9,526,289 323,908 $ 13,609,107 $ 382,222,294 3,598,529 17,445,800 20,399,986 278,659,883 1,143,213 7,729,883 Unencumbered Budget $ (5,854,634) 125,653,723 5,212,642 8,190,692 11,144,009 Fire Protection Freeway Mitigation Historic Preservation Housing 21,140,399 2,759,359 63,604,234 13,366,804 548,954 33,036,071 12,471,949 1,348,943 41,895,160 86,883 48,568,331 20,603,027 21,140,399 2,672,476 15,035,903 13,366,804 548,954 12,433,044 7,773,595 2,210,405 30,568,163 Human Services Information Technology Libraries Neighborhood Services 2,857,262 14,253,403 7,697,854 12,085,676 628,422 7,789,470 3,030,398 2,954,944 4,664,798 7,006,936 5,206,828 2,953,778 10,256,533 1,454,500 3,966,861 3,496,476 1,358,903 757,857 2,857,262 3,996,870 6,243,354 8,118,815 628,422 4,292,994 1,671,495 2,197,087 2,228,840 6,463,933 4,667,456 9,130,732 Parks and Mountain Preserves Phoenix Convention Center Police Protection Public Transit 99,788,025 2,212,303 25,509,600 77,991,552 37,253,719 972,453 2,367,560 8,675,422 66,876,517 3,983,651 11,533,506 29,256,824 46,850,118 2,212,303 26,179,381 24,676,064 873,572 3,057,551 52,937,907 25,509,600 51,812,171 12,577,655 98,881 2,367,560 5,617,871 62,534,306 1,239,850 23,142,040 69,316,130 31,444,218 155,714,473 107,462,416 197,600,987 15,435,064 56,611,878 55,847,510 85,547,532 22,541,903 122,654,396 33,289,799 209,786,004 16,565,000 70,784,504 72,777,540 112,519,959 7,941,156 35,075,545 25,496,496 56,876,108 14,879,218 84,929,969 34,684,876 85,081,028 7,493,908 21,536,333 30,351,014 28,671,424 16,009,154 99,102,595 51,614,906 112,053,455 Solid Waste Disposal Street Transportation & Drainage Wastewater Water System Total Capital Improvement Program $ 1,319,796,832 $ 677,394,840 $ 753,608,243 - 19 - $ 493,021,254 $ 225,608,429 $ 826,775,578 $ 451,786,411 $ 642,401,992 Bonds Authorized and Sold As of May 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,600 124,685 24,170 60,700 11,205 32,100 89,275 71,645 72,575 77,685 65,950 43,700 1,700 615 630 800 795 900 2,225 2,355 4,425 1,115 50 - 753,900 738,290 15,610 81,000 11,100 198,700 12,800 104,622 74,705 29,178 115,500 107,295 78,200 65,400 63,385 8,510 190,610 8,345 85,510 61,200 21,100 102,290 81,900 58,135 61,770 17,615 2,590 8,090 4,455 19,112 13,505 8,078 13,210 25,395 20,065 3,630 878,500 742,755 135,745 2001 Authorization General Obligation Bonds Education, Youth and Family Cultural Facilities Computer Technology Environmental Cleanup Fire Protection Historic Preservation Library Facilities Street Improvements Neighborhood Protection and Senior Centers Parks, Open Space, and Recreational Facilities Police Protection Storm Sewer and Flood Protection Bonds Fully Issued Total 2001 Authorizations 2006 Authorization General Obligation Bonds Affordable Housing and Neighborhood Revitalization Computer Technology Education and Health Science Facilities Environmental Cleanup Family, Senior, and Youth Cultural Facilities Fire Protection Library Facilities and Improvements Parks, Open Space, and Recreational Facilities Police Protection Street Improvements Storm Sewer and Flood Protection Total 2006 Authorizations Total Bond Program $ 2,689,750 $ 2,537,395 NOTE: In May $120,000,000 in bonds were sold, but the proceeds were not received until June. The sold amounts shown above include the bonds sold in May. - 20 - $ 152,355