City of Phoenix, Arizona Monthly Financial Report March 2012 Monthly Financial Report – March 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 $14.8 million less than prior year-to-date revenues. As of March 2012, local sales taxes were up $7.6 million compared to the prior year-to-date sales tax revenues. However, state shared taxes were down $16.9 million compared to the prior year-to-date state shared tax revenues. The decrease in state shared revenues was primarily from income taxes. The decrease in Police revenues reflects a settlement received in the prior year. Revenues through March 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. (see pages 14-15) Expenditures • Citywide year-to-date expenditures for the month of March 2012 are $11.6 million less than year-to-date expenditures for March 2011. The decrease is mostly related to decreases in Public Transit, Water, Wastewater and Public Works expenditures. (see pages 22-25) • Year-to-date General Fund expenditures for the first nine months of the fiscal year are 69.7% of budgeted expenditures. This is primarily due to less expenditure as compared to the budget in capital improvements, environmental services, community development and transportation. (see page 3) • However, year-to-date General Fund expenditures are $24.1 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. 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. (see page 3) • Capital fund year-to-date expenditures have decreased $59.9 million to $551.5 million from $611.4 million spent during the same period last year. Decreases in capital expenditures as compared to last year-to-date include $124.4 million in Water, $19.9 million in Parks and Preserves, $31.4 in Streets and Transportation, $14.2 million in Public Transit and $10.4 million in Wastewater projects. Decreases in Capital Fund year-to-date expenditures are partially offset by increases at the Aviation Department (including Phx Sky-Train) of $175.4 million. (see pages 26-27) -1- General Funds Summary Summary General Funds As of March 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 $ 300,296 $ 2,107 292,708 2,184 72.0 % 85.5 74.6 % 89.4 110,696 122,065 48,045 126,763 3,270 9,567 83,258 91,508 34,686 75,692 2,185 4,688 82,141 107,735 36,503 76,296 2,389 4,799 75.2 75.0 72.2 59.7 66.8 49.0 73.5 75.0 75.6 58.3 77.3 50.1 20,759 1,100 12,598 1,256 7,103 993 5,124 16,024 861 11,881 990 4,286 746 4,174 15,944 845 12,711 917 5,108 786 4,755 77.2 78.3 94.3 78.8 60.3 75.1 81.5 74.8 72.8 78.8 73.8 68.1 70.0 90.5 36,750 12,462 300 14,890 26,828 8,372 493 10,580 26,694 8,398 201 13,307 73.0 67.2 164.3 71.1 72.5 68.6 60.3 76.4 953,212 $ 679,655 $ -2- 694,421 71.3 % 72.1 % Summary General Funds As of March 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 $ 1,022 $ 2,331 992 20,917 1,760 1,619 13,263 1,639 3,537 7,456 2,357 12,719 2,872 72,484 1,046 2,457 1,032 (1,234) 1,804 1,752 13,992 2,056 2,512 7,206 2,695 14,613 1,370 51,301 30,954 4,708 35,662 21,410 3,491 24,901 21,784 3,403 25,187 69.2 74.2 69.8 76.0 73.1 75.6 428,455 226,892 30 655,377 321,134 165,807 (26) 486,915 320,993 164,901 121 486,015 75.0 73.1 (86.7) 74.3 76.5 74.9 277.3 76.0 Transportation Street Transportation Public Transit Total Transportation 22,527 19,231 41,758 14,077 13,973 28,050 15,858 14,410 30,268 62.5 72.7 67.2 80.7 75.7 78.2 Community Development Economic Development Neighborhood Services Department Planning and Development Others Total Community Development 4,886 11,532 4,995 57 21,470 3,255 7,800 3,231 40 14,326 3,170 7,582 3,766 89 14,607 66.6 67.6 64.7 70.2 66.7 73.6 73.6 79.4 87.0 75.1 Community Enrichment Parks and Recreation Library Human Services Others Total Community Enrichment 89,567 35,277 18,493 2,121 145,458 64,401 23,134 12,305 1,422 101,262 64,206 23,315 13,012 1,578 102,111 71.9 65.6 66.5 67.0 69.6 74.5 72.2 76.3 69.7 74.1 Environmental Services Public Works Environmental Programs Total Environmental Services 16,400 978 17,378 10,538 556 11,094 6,494 704 7,198 64.3 56.9 63.8 49.4 77.3 51.2 3,733 1,959 220 52.5 19.7 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 $ $ 740,991 $ 71.6 % 70.1 50.3 63.6 75.9 70.8 72.7 63.7 71.2 67.7 73.9 74.1 103.2 69.6 716,907 (1) In prior years, Information Technology Services' charges were allocated to user departments. In fiscal year 2012, Information Technology Services' charges are budgeted for within the Information Technology Services Department. -3- 69.7 % 78.1 % 76.4 62.1 (44.0) 78.9 75.0 77.6 77.4 69.4 78.0 85.1 79.4 72.4 72.6 75.1 % Citywide Summary Comparison to Prior Year Revenues YEAR-TO-DATE REVENUES As of March 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 March 31 increased by $2,981,263 to $2,137,353,372 from the $2,134,372,109 collected during the same period last year, an increase of 0.1%. For the current year, 71.0% of the total estimated revenue has been collected. Of the total revenues received last year, 70.8% had been collected as of March 31. -4- Comparison to Prior Year Operating Expenditures YEAR-TO-DATE OPERATING EXPENDITURES (millions of dollars) As of March 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 March 31 decreased $11,558,064 to $2,234,415,570 from the $2,245,973,634 spent during the same period last year, a decrease of 0.5%. For the current year, 64.3% of the total appropriations has been spent. Of the total actual expenditures for last year, 74.2% had been spent as of March 31. -5- Comparison to Prior Year Capital Expenditures YEAR-TO-DATE CAPITAL EXPENDITURES As of March 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 March 31 decreased $59,871,249 to $551,492,351 from the $611,363,600 spent during the same period last year, a decrease of 9.8%. For the current year, 41.8% of the total appropriations has been spent. Of the total actual expenditures for last year, 71.0% had been spent as of March 31. -6- Summary Operating Revenues As of March 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 $ 300,296 $ 2,107 292,708 2,184 % of Year-to-Date Estimate Actual 2011-12 2010-11 72.0 % 85.5 74.6 % 89.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 83,258 91,508 34,686 75,692 2,185 4,688 16,885 11,881 990 4,286 746 4,174 35,200 493 10,580 82,141 107,735 36,503 76,296 2,389 4,799 16,789 12,711 917 5,108 786 4,755 35,092 201 13,307 75.2 75.0 72.2 59.7 66.8 49.0 77.2 94.3 78.8 60.3 75.1 81.5 71.5 164.3 71.1 73.5 75.0 75.6 58.3 77.3 50.1 74.7 78.8 73.8 68.1 70.0 90.5 71.5 60.3 76.4 953,212 679,655 694,421 71.3 72.1 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 19,491 57,475 19,731 116,517 7,414 24,811 12,683 10,141 65,634 15,581 2,426 22,326 156,304 58,882 18,440 55,878 18,938 108,834 2,692 22,680 12,686 9,852 76,933 22,291 6,937 15,388 134,491 90,104 72.3 73.2 71.7 72.8 64.9 75.0 72.5 68.6 72.0 54.0 62.9 87.1 51.1 59.0 72.8 75.0 72.9 71.0 91.3 71.3 81.1 67.1 72.9 52.9 78.1 63.1 54.5 58.4 925,073 589,416 596,144 63.7 64.4 329,036 57,391 366,646 230,882 142,567 6,130 245,900 39,215 286,155 183,457 108,877 4,678 242,923 45,539 257,916 185,641 107,477 4,311 74.7 68.3 78.0 79.5 76.4 76.3 73.0 74.1 72.7 81.5 75.1 75.5 1,132,652 868,282 843,807 76.7 75.0 71.0 % 70.8 % 3,010,937 -7- $ 2,137,353 $ 2,134,372 Summary Operating Revenues As of March 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 March 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 $ 72,484 $ 9,694 82,178 51,301 6,074 57,375 69.6 % 63.8 68.9 35,662 9,893 45,555 24,901 2,231 27,132 25,187 5,459 30,646 69.8 22.6 59.6 75.6 150.3 82.9 Public Safety General Funds Other Funds Total Public Safety 655,377 161,111 816,488 486,915 116,881 603,796 486,015 118,052 604,067 74.3 72.5 74.0 76.0 77.5 76.3 Transportation General Funds Other Funds Total Transportation 41,758 566,577 608,335 28,050 439,008 467,058 30,268 428,359 458,627 67.2 77.5 76.8 78.2 81.0 80.8 Community Development General Funds Other Funds Total Community Development 21,470 230,974 252,444 14,326 128,675 143,001 14,607 119,049 133,656 66.7 55.7 56.6 75.1 76.0 75.9 Community Enrichment General Funds Other Funds Total Community Enrichment 145,458 136,167 281,625 101,262 98,882 200,144 102,111 106,195 208,306 69.6 72.6 71.1 74.1 77.5 75.8 Environmental Services General Funds Other Funds Total Environmental Services 17,378 617,100 634,478 11,094 395,906 407,000 7,198 420,916 428,114 63.8 64.2 64.1 51.2 75.3 74.8 Debt Service General Funds Other Funds Total Debt Service 138,719 138,719 126,968 126,968 144,466 144,466 91.5 91.5 73.4 73.4 Capital Improvement General Funds Other Funds Total Capital Improvement 3,733 489,288 493,021 1,959 175,180 177,139 220 180,497 180,717 52.5 35.8 35.9 19.7 54.8 54.6 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 - $ 740,991 1,493,425 2,234,416 $ -9- 716,907 1,529,067 2,245,974 69.7 61.9 64.3 % 72.6 % 82.1 73.5 75.1 73.8 74.2 % Summary Operating Expenditures and Encumbrances As of March 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 Oct Nov Dec Jan Current YTD Expenditures Prior YTD Expenditures Feb Mar April May June Prior YTD Expenditures NOTE (1) 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 Jan Current YTD Expenditures NOTE (1) 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 Feb Mar April May June Prior YTD Expenditures In prior years, Information Technology Services' charges were allocated to user departments. In fiscal year 2012, Information Technology Services' charges are budgeted for within the Information Technology Services Department. - 10 - Summary Operating Expenditures and Encumbrances As of March 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 March 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 $ 32,548,662 112,037 $ 31,302,034 135,775 Local Taxes: Sales Taxes Privilege License Fees $ 417,006,000 2,464,500 $ 300,296,235 2,106,519 $ 292,708,153 2,183,441 72.0 % 85.5 74.6 % 89.4 32,660,699 31,437,809 Total Local Taxes 419,470,500 302,402,754 294,891,594 72.1 74.7 9,553,508 10,168,120 4,860,166 9,133,972 11,970,581 4,819,572 State Shared Taxes: State Sales Tax State Income Tax Vehicle License Tax 110,696,000 122,065,000 48,045,000 83,258,139 91,508,044 34,686,298 82,140,662 107,735,263 36,502,933 75.2 75.0 72.2 73.5 75.0 75.6 24,581,794 25,924,125 280,806,000 209,452,481 226,378,858 74.6 74.5 4,760,790 4,540,878 Primary Property Tax 126,763,000 75,692,220 76,295,791 59.7 58.3 287,823 277,426 Licenses and Permits 3,270,000 2,185,155 2,388,527 66.8 77.3 Cable Communications 9,567,056 4,687,667 4,799,355 49.0 50.1 Municipal Court: Fines and Forfeitures Court Default Fee 20,759,025 1,100,000 16,023,694 861,019 15,944,385 844,725 77.2 78.3 74.8 72.8 21,859,025 16,884,713 16,789,110 77.2 74.7 12,597,587 11,880,768 12,711,376 94.3 78.8 - - 2,237,647 206,027 2,487,949 177,122 2,443,674 2,665,071 1,295,726 1,090,728 Total State Shared Taxes Total Municipal Court Police 132,306 112,111 Library Fees 1,256,140 990,343 916,828 78.8 73.8 894,704 332,653 Parks and Recreation 7,102,531 4,286,055 5,107,675 60.3 68.1 59,290 129,480 Planning and Development 993,300 746,146 786,047 75.1 70.0 116,979 440,035 Street Transportation 5,124,098 4,173,920 4,754,851 81.5 90.5 2,811,109 139,725 231,357 2,985,782 261,232 141,805 36,750,000 1,300,000 11,161,613 26,828,115 581,286 7,790,110 26,693,981 665,493 7,732,834 73.0 44.7 69.8 72.5 51.6 70.6 3,182,191 3,388,819 49,211,613 35,199,511 35,092,308 71.5 71.5 41,038 26,410 301,380 493,424 201,446 163.7 60.3 941,178 3,938,110 14,889,664 10,579,484 13,307,132 71.1 76.4 71,398,192 74,303,655 953,211,894 679,654,641 694,420,898 71.3 72.1 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 March 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,551,455 $ 110,819 554,091 (5,218) 1,430,515 102,180 510,899 (9,906) 2,211,147 2,033,688 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 $ 13,595,380 971,099 4,855,493 68,906 $ 12,928,968 923,498 4,617,489 (29,998) 72.2 % 72.2 72.2 143.6 72.9 % 72.5 72.5 71.1 26,956,000 19,490,878 18,439,957 72.3 72.8 58,269,000 20,108,000 140,000 42,648,459 14,864,886 (38,035) 41,253,186 14,576,044 48,336 73.2 73.9 (27.2) 74.6 76.0 101.0 78,517,000 57,475,310 55,877,566 73.2 75.0 27,510,000 19,731,464 18,937,704 71.7 72.9 107,640,000 52,325,926 77,687,889 38,828,653 73,879,821 34,953,754 72.2 74.2 72.9 67.5 159,965,926 116,516,542 108,833,575 72.8 71.0 Court Awards 11,425,309 7,413,676 2,691,773 64.9 91.3 Planning and Development 33,100,000 24,810,976 22,680,387 75.0 71.3 Public Safety Enhancement & Expansion: Police Fire Interest/Other 4,608,565 1,537,912 (6,540) 4,345,416 1,477,412 1,913 6,139,937 5,824,741 2,243,084 2,092,198 Parks and Preserves 8,865,459 4,421,586 8,174,378 5,215,607 Transit 2000: Sales Taxes Interest/Other 13,287,045 13,389,985 1,057,028 470,873 3,253,976 2,613,755 1,368,047 1,422,857 Capital Construction 17,502,000 12,683,459 12,686,368 72.5 81.1 1,435,910 24,899 1,388,788 36,687 Sports Facilities: Sales Taxes Interest/Other 14,386,000 395,000 9,710,494 430,643 9,358,150 494,311 67.5 109.0 66.5 81.9 1,460,809 1,425,475 Total Sports Facilities 14,781,000 10,141,137 9,852,461 68.6 67.1 9,838,257 22,220 109,549 10,074,432 53,782 300 Highway User Revenue: Highway User Revenue Interest Other 90,226,000 600,000 300,000 65,131,388 232,581 269,577 76,469,892 375,615 87,872 72.2 38.8 89.9 72.9 69.1 64.6 9,970,026 10,128,514 91,126,000 65,633,546 76,933,379 72.0 72.9 1,931,045 11,845 28,863,623 15,581,417 22,291,119 54.0 52.9 15,211 3,014,805 Community Reinvestment 3,853,899 2,426,367 6,936,918 63.0 78.1 2,655,752 1,813,450 Other Restricted Fees 25,633,671 22,326,481 15,387,757 87.1 63.1 Total Public Safety Enhancement & Expansion Total Transit 2000 Total Highway User Revenue Regional Transit Revenues - 13 - Revenues For the Month Ended March 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) $ 610,152 5,716,069 76,153 $ 694,064 5,711,048 705,147 6,402,374 7,110,259 4,338,507 380,264 5,106,137 4,953,487 2,477,637 4,105,533 2,094,608 11,129,026 14,778,395 19,806,804 21,180,769 26,917,063 4,110,344 12,036 6,134,720 31,146 4,122,380 6,165,866 70,896,256 77,325,115 Grants: Public Housing: Rentals Grants Other $ Total Public Housing 9,270,065 77,005,775 2,431,392 $ 5,157,895 51,810,938 1,203,433 $ 4,867,660 43,987,073 3,004,979 55.6 % 67.3 49.5 73.5 % 61.2 28.9 88,707,232 58,172,266 51,859,712 65.6 58.4 42,765,750 9,983,354 34,665,229 129,960,524 30,812,395 3,265,155 14,850,301 49,203,472 28,741,408 2,024,152 13,401,697 38,464,060 72.0 32.7 42.8 37.9 63.7 10.7 76.2 50.3 Total Other 217,374,857 98,131,323 82,631,317 45.1 52.3 Total Grants 306,082,089 156,303,589 134,491,029 51.1 54.5 94,529,000 5,228,000 56,304,511 2,577,226 87,488,678 2,615,396 59.6 49.3 58.7 49.2 99,757,000 58,881,737 90,104,074 59.0 58.4 925,073,517 589,416,579 596,144,067 63.7 64.4 108,000,000 173,799,000 1,620,000 3,286,000 1,724,000 3,606,500 37,000,000 67,259,390 144,425,929 1,120,467 2,318,243 1,249,564 2,162,975 27,364,008 61,693,080 147,853,758 948,557 2,754,010 1,236,150 2,450,391 25,987,405 62.3 83.1 69.2 70.5 72.5 60.0 74.0 74.3 75.2 70.0 37.6 75.7 75.9 66.0 329,035,500 245,900,576 242,923,351 74.7 73.0 39,685,000 17,106,160 600,000 28,107,562 10,807,484 299,826 26,845,402 18,225,858 467,189 70.8 63.2 50.0 71.0 79.1 74.7 57,391,160 39,214,872 45,538,449 68.3 74.1 Other: Human Resources Federal Transit Administration Community Development Other G.O. Bond Debt Service Secondary Property Tax Interest Total G.O. Bond Debt Service Total Special Revenue and Debt Service Enterprise Funds AVIATION: 7,633,743 16,286,408 94,688 263,482 138,816 256,480 3,796,089 6,935,944 17,627,137 95,430 169,941 135,798 246,019 3,665,409 28,469,706 28,875,678 Sky Harbor: Airlines Concessions Interest Other Phoenix-Goodyear Phoenix-Deer Valley Phoenix-Customer Facility Charge Total Aviation CONVENTION CENTER: 3,499,089 1,836,022 26,438 3,334,890 1,597,639 53,362 5,361,549 4,985,891 Excise Taxes Operating Revenue Interest Total Convention Center - 14 - Revenues For the Month Ended March 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: $ 18,759,566 489,891 309,041 453,917 132,480 153,273 428,180 $ 20,726,348 15,540,151 591,647 187,843 611,055 121,500 249,071 327,866 17,629,133 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 $ 267,418,199 4,278,844 2,644,085 6,140,857 1,344,000 1,492,613 2,836,045 $ 239,986,047 4,438,511 2,204,914 5,364,921 924,300 2,592,516 2,405,224 77.9 % 71.3 83.1 65.4 89.6 115.0 143.2 72.3 % 73.8 81.6 68.3 75.9 74.8 144.2 366,646,000 286,154,643 257,916,433 78.0 72.7 196,104,000 14,486,000 1,400,000 1,962,000 16,930,000 145,688,939 14,783,656 1,262,520 1,675,947 20,046,371 148,030,909 14,317,643 818,340 2,138,630 20,335,356 74.3 102.1 90.2 85.4 118.4 74.9 75.2 77.3 69.3 299.4 230,882,000 183,457,433 185,640,878 79.5 81.5 123,625,000 7,440,000 750,000 10,752,500 93,073,216 5,079,838 390,356 10,333,608 92,539,691 5,976,243 530,141 8,431,285 75.3 68.3 52.0 96.1 74.9 71.1 76.8 79.8 142,567,500 108,877,018 107,477,360 76.4 75.1 WASTEWATER: 16,081,609 1,422,263 116,460 149,882 781,504 16,369,726 1,338,281 100,980 175,647 774,342 18,551,718 18,758,976 Sewer Service Charges Multi-City Development Fees Interest Other Total Wastewater SOLID WASTE: 10,388,486 508,211 42,253 164,822 10,284,109 950,162 61,372 1,129,518 11,103,772 12,425,161 Collection Fees Landfill Fees Interest Other Total Solid Waste GOLF COURSES: $ 670,269 7,294 252,700 (8,953) 15,916 643,855 6,854 243,195 (12,263) 2,375 937,226 884,016 85,150,319 83,558,855 227,444,767 $ 235,187,625 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,088,894 60,687 1,535,967 (90,764) 82,826 2,852,222 51,346 1,352,748 (106,786) 161,143 75.3 77.4 76.5 49.0 64.7 76.0 69.9 73.1 74.8 93.6 6,129,618 4,677,610 4,310,673 76.3 75.5 1,132,651,778 868,282,152 843,807,144 76.7 75.0 71.0 % 70.8 % 3,010,937,189 $ 2,137,353,372 $ 2,134,372,109 Operating Expenditures and Encumbrances For the Month Ended March 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 $ 127,716 $ 267,528 242,383 2,425,906 110,224 222,945 206,579 1,656,963 92,706 355,103 47,728 846,088 48,927 (38,459) 258,076 1,508,930 1,689,191 10,068,534 109,667 331,588 298,442 (19,485,166) 96,007 280,135 280,561 1,910,118 163,061 (752,140) 30,675 1,709,523 70,643 19,963 362,279 2,506,454 (12,068,190) 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,022,079 2,331,152 1,095,707 21,351,994 1,272,671 2,000,236 1,923,387 14,653,223 1,638,611 3,548,956 1,667,709 7,760,902 85,575 38,542 2,356,913 14,861,139 4,568,769 $ 1,060,948 2,456,786 1,234,943 (174,779) 976,945 2,053,239 2,031,880 15,313,236 2,056,302 2,634,595 226,216 8,141,644 73,157 94,014 2,695,345 16,500,158 - $ 1,022,079 2,331,152 1,095,707 21,206,234 1,272,671 2,000,236 1,923,387 14,653,223 1,638,611 3,537,227 1,667,709 7,695,595 85,575 38,542 2,356,913 14,757,596 4,568,769 $ 145,760 11,729 65,307 103,543 - 119,308,245 82,177,565 57,374,629 81,851,226 326,339 40,846,452 4,708,450 23,641,237 3,490,736 27,242,122 3,403,501 23,288,221 3,490,736 353,016 - 45,554,902 27,131,973 30,645,623 26,778,957 353,016 547,390,725 268,616,005 480,992 406,842,224 196,710,113 243,455 408,562,781 194,980,583 523,590 404,832,676 195,953,183 243,455 2,009,548 756,930 - 816,487,722 603,795,792 604,066,954 601,029,314 2,766,478 Criminal Justice 2,530,436 394,118 3,413,716 385,258 2,924,554 3,798,974 Municipal Court Public Defender Total Criminal Justice Public Safety 43,902,730 21,472,145 28,685 49,126,563 23,853,387 92,752 65,403,560 73,072,702 Police Fire Other Total Public Safety - 16 - Operating Expenditures and Encumbrances For the Month Ended March 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,360,833 1,015,584 23,428,037 8,703,808 37,508,262 $ 5,234,290 1,077,618 24,084,084 13,280,820 43,676,812 Street Transportation Street Lighting Aviation Public Transit Total Transportation $ 58,632,945 11,685,358 290,441,289 247,575,530 $ 41,995,292 7,898,556 198,915,607 218,248,548 $ 41,353,654 8,457,595 193,084,244 215,731,697 $ 41,908,420 7,898,556 147,415,427 179,564,855 $ 86,872 51,500,180 38,683,693 608,335,122 467,058,003 458,627,190 376,787,258 90,270,745 Community Development 2,313,224 6,438,702 1,736,570 3,966,713 3,474,631 6,740,522 2,125,149 3,531,573 Planning and Development Housing Economic Development Neighborhood Services Department 33,601,910 75,137,220 37,775,681 105,929,214 23,457,674 58,458,756 18,071,250 43,013,595 24,142,742 57,282,517 20,205,098 32,025,436 23,457,674 58,404,336 16,419,783 43,013,595 54,420 1,651,467 - 14,455,209 15,871,875 Total Community Development 252,444,025 143,001,275 133,655,793 141,295,388 1,705,887 96,385,575 36,069,133 8,341,758 62,545,832 10,968,395 62,339,505 4,133,240 841,581 68,876,062 23,638,723 6,301,346 44,971,465 5,930,373 47,388,736 2,427,200 610,106 69,605,437 23,910,288 5,825,707 47,820,697 9,165,408 48,730,799 2,381,346 866,477 68,746,129 23,638,723 6,300,596 30,406,832 47,345,488 2,427,200 610,106 129,933 750 14,564,633 5,930,373 43,248 - 281,625,019 200,144,011 208,306,159 179,475,074 20,668,937 Community Enrichment 6,702,756 3,570,192 584,923 4,264,658 651,071 5,223,976 365,015 102,582 21,465,173 7,954,417 2,686,706 622,307 4,375,509 1,017,965 6,758,963 151,815 (44,912) 23,522,770 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 March 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 $ 19,939,446 11,745,326 9,895,289 1,445,509 155,209 43,180,779 $ 27,454,339 16,275,756 9,687,704 3,661,578 155,741 57,235,118 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 $ 206,398,369 105,956,295 82,284,337 11,547,193 813,827 $ 210,189,493 115,545,942 89,624,729 11,847,386 906,630 $ 129,678,100 52,689,086 72,625,546 10,926,510 813,827 $ 266,733,069 76,720,269 53,267,209 9,658,791 620,683 - 634,477,563 407,000,021 428,114,180 140,266,952 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 986,291 9,208,369 14,806,638 158,523 3,078,589 503,824 3,089,591 508,083 6,954,598 5,313,461 697,142 18,825,630 37,650 6,025,284 1,169,648 4,103,568 3,828 1,384,406 23,729,569 20,853,818 229,809 5,299,978 985,541 7,156,182 15,068,113 198,544 3,641,651 500,374 3,647,836 631,894 5,464,796 4,197,958 689,642 14,056,624 37,650 8,823,541 1,916,265 4,951,192 20,349,243 1,885,969 19,104,347 27,498,164 125,109 3,535,158 - 986,291 9,208,369 14,806,638 158,523 3,078,589 503,824 3,089,591 508,083 6,954,598 5,313,461 697,142 18,825,630 37,650 6,025,284 1,169,648 4,103,568 3,828 1,384,406 23,729,569 20,853,818 229,809 5,299,978 General Obligation Debt Service 109,588 1,023,152 1,645,182 17,613 342,065 55,981 343,288 56,453 772,733 590,385 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,504 795,131 1,674,235 22,061 404,628 55,597 405,315 70,210 607,200 466,440 76,627 1,561,487 4,183 980,393 212,918 1,591,339 628,657 2,122,705 3,055,356 13,901 1,170,909 14,075,708 16,028,796 Total Debt Service 138,718,984 126,968,297 144,465,793 - 126,968,297 18,217,346 33,070,486 Capital Improvement 493,021,254 177,138,633 180,717,313 - 177,138,633 $ 227,299,125 $ 254,209,343 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 - $ 2,234,415,570 $ 2,245,973,634 $ 1,673,950,286 $ 560,465,284 Capital Expenditures and Encumbrances For the Month Ended March 31 2012 2011 $ 120,598 $ 10,917,147 35,893 958,525 (111,155) 316,018 143,642 4,339,079 105,182 29,705 906,270 (16,328) $ 341,340 8,330,368 36,562 565,005 1,022,977 30,143 38,010 11,742,174 33,657 317,584 62,853 219,326 865,416 20,415 133,194 233,199 4,321,917 203,864 499,580 727,060 398,713 3,256,223 2,776,501 5,899,933 2,766,228 3,955,126 4,169,021 24,235,487 31,328,170 $ 63,618,282 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 7,653,487 $ 292,735,665 5,048,031 8,549,058 7,202,317 2010-11 Actual Yearto-Date 4,222,687 117,348,180 14,147,703 4,397,491 6,731,354 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 187,309 24,968,516 4,638,541 8,549,058 188,696 $ 13,609,107 $ 382,222,294 3,598,529 17,445,800 7,466,178 267,767,149 409,490 7,013,621 Unencumbered Budget $ 7,150,620 143,077,004 5,095,483 9,167,923 11,995,483 Fire Protection Freeway Mitigation Historic Preservation Housing 21,140,399 2,759,359 63,604,234 10,135,410 482,933 27,136,514 4,901,324 1,268,122 36,537,315 86,883 48,568,331 17,768,411 21,140,399 2,672,476 15,035,903 10,135,410 482,933 9,368,103 11,004,989 2,276,426 36,467,720 Human Services Information Technology Libraries Neighborhood Services 2,857,262 14,253,403 7,697,854 12,085,676 378,657 4,825,462 2,928,130 1,405,962 4,513,059 6,541,971 4,291,567 2,677,413 10,256,533 1,454,500 3,966,861 3,155,994 1,259,231 609,930 2,857,262 3,996,870 6,243,354 8,118,815 378,657 1,669,468 1,668,899 796,032 2,478,605 9,427,941 4,769,724 10,679,714 Parks and Mountain Preserves Phoenix Convention Center Police Protection Public Transit 99,788,025 2,212,303 25,509,600 77,991,552 34,361,512 638,246 2,273,105 6,494,116 54,239,329 3,827,490 10,277,628 20,672,952 46,850,118 2,212,303 26,179,381 22,310,978 580,875 1,827,726 52,937,907 25,509,600 51,812,171 12,050,534 57,371 2,273,105 4,666,390 65,426,513 1,574,057 23,236,495 71,497,436 31,444,218 155,714,473 107,462,416 197,600,987 12,397,722 49,030,506 15,899,240 61,916,278 21,699,810 80,457,362 26,260,846 186,349,997 16,565,000 70,784,504 72,777,540 112,519,959 7,250,262 30,787,168 13,439,614 39,616,324 14,879,218 84,929,969 34,684,876 85,081,028 5,147,460 18,243,338 2,459,626 22,299,954 19,046,496 106,683,967 91,563,176 135,684,709 Solid Waste Disposal Street Transportation & Drainage Wastewater Water System Total Capital Improvement Program $ 1,319,796,832 $ 551,492,351 $ 611,363,600 - 19 - $ 493,021,254 $ 177,138,633 $ 826,775,578 $ 374,353,718 $ 768,304,481 Bonds Authorized and Sold As of March 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 29,285 884,175 $ 913,460 Revenue Bonds Bonds Fully Issued Total 1988 Authorizations 28,285 884,175 $ 912,460 1,000 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