City of Phoenix, Arizona Monthly Financial Report April 2012 Monthly Financial Report – April 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 $19.9 million less than prior year-to-date revenues. As of April 2012, local sales taxes were up $8.4 million compared to the prior year-to-date sales tax revenues. However, state shared taxes were down $19.8 million compared to the prior year-to-date state shared tax revenues. The decrease in state shared revenues was primarily from income taxes. There are also decreases in Fire revenues and in other fees and charges due to a decrease in activity. Revenues through April 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 April 2012 are $31.0 million less than year-to-date expenditures for April 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 ten months of the fiscal year are 76.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 $25.5 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 $106.0 million to $585.6 million from $691.6 million spent during the same period last year. Decreases in capital expenditures as compared to last year-to-date include $127.2 million in Water, $24.0 million in Parks and Preserves, $62.7 in Streets and Transportation, $19.8 million in Public Transit and $12.7 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 $174.7 million. (see pages 26-27) -1- General Funds Summary Summary General Funds As of April 30 (dollars in thousands) Revenues Local Taxes Sales Taxes Privilege License Fees State Shared Taxes State Sales Tax State Income Tax Vehicle License Tax Primary Property Tax Licenses and Permits Cable Communications Municipal Court Fines and Forfeitures Court Default Fee Police Library Parks and Recreation Planning & Development Street Transportation Fire Emergency Transportation Service Other Interest Other Fees and Service Charges Total Revenues Actual Year-to-Date 2011-12 2010-11 Budget Estimate 2011-12 $ $ 417,006 2,465 335,251 $ 2,202 326,877 2,282 80.4 % 89.3 83.3 % 93.4 110,696 122,065 48,045 126,763 3,270 9,567 93,002 101,676 38,168 82,136 2,400 7,121 92,589 119,706 40,357 83,105 2,607 7,192 84.0 83.3 79.4 64.8 73.4 74.4 82.8 83.3 83.6 63.5 84.3 75.0 20,759 1,100 12,598 1,256 7,103 993 5,124 17,972 1,023 13,124 1,099 4,595 829 4,510 17,807 982 13,939 1,016 5,646 912 4,568 86.6 93.0 104.2 87.5 64.7 83.5 88.0 83.5 84.6 86.4 81.7 75.3 81.2 87.0 36,750 12,462 300 14,890 29,965 9,984 530 11,638 31,635 10,672 229 14,970 81.5 80.1 176.7 78.2 85.9 87.2 68.6 86.0 953,212 $ % of Year-to-Date Estimate Actual 2011-12 2010-11 $ 757,225 $ -2- 777,091 79.4 % 80.7 % Summary General Funds As of April 30 (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,138 2,703 1,230 195 1,959 1,930 15,258 2,182 2,866 7,829 2,947 15,219 1,596 57,052 30,954 4,708 35,662 23,559 3,867 27,426 23,996 3,777 27,773 76.1 82.1 76.9 83.7 81.1 83.3 Public Safety Police Fire Others Total Public Safety 428,455 226,892 30 655,377 352,917 183,724 (1) 536,640 352,680 182,062 151 534,893 82.4 81.0 (3.3) 81.9 84.1 82.7 346.1 83.6 Transportation Street Transportation Public Transit Total Transportation 22,527 19,231 41,758 15,386 15,508 30,894 17,183 15,946 33,129 68.3 80.6 74.0 87.4 83.7 85.6 Community Development Economic Development Neighborhood Services Department Planning and Development Others Total Community Development 4,886 11,532 4,995 57 21,470 3,570 8,647 3,604 40 15,861 3,493 8,403 4,108 94 16,098 73.1 75.0 72.2 70.2 73.9 81.1 81.5 86.6 91.4 82.7 Community Enrichment Parks and Recreation Library Human Services Others Total Community Enrichment 89,567 35,277 18,493 2,121 145,458 70,913 24,806 13,195 1,428 110,342 70,887 26,333 14,239 1,741 113,200 79.2 70.3 71.4 67.3 75.9 82.3 81.5 83.5 77.0 82.2 Environmental Services Public Works Environmental Programs Total Environmental Services 16,400 978 17,378 11,817 615 12,432 6,180 765 6,945 72.1 62.9 71.5 47.1 84.0 49.4 3,733 2,039 320 54.6 28.6 37,890 - Capital Improvement Contingencies Total Expenditures and Encumbrances (1) $ 1,062,848 $ % of Year-to-Date Estimate Actual 2011-12 2010-11 1,137 $ 2,566 1,211 23,111 1,940 1,782 14,673 1,562 3,880 8,214 2,602 13,438 3,187 79,303 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 $ 814,937 $ 789,410 In prior years, Information Technology Services' charges were allocated to user departments. -3- 79.6 % 77.2 61.4 70.3 83.7 77.9 80.5 60.7 78.1 74.6 81.5 78.3 114.6 76.2 76.7 % 85.0 % 84.0 74.1 6.9 85.7 82.6 84.6 82.2 79.2 84.7 93.0 82.7 84.3 80.8 82.7 % Citywide Summary Comparison to Prior Year Revenues YEAR-TO-DATE REVENUES As of April 30, 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 April 30 increased by $7,184,494 to $2,397,151,778 from the $2,389,967,284 collected during the same period last year, an increase of 0.3%. For the current year, 79.6% of the total estimated revenue has been collected. Of the total revenues received last year, 79.3% had been collected as of April 30. -4- Comparison to Prior Year Operating Expenditures YEAR-TO-DATE OPERATING EXPENDITURES (millions of dollars) As of April 30, 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 April 30 decreased $31,012,505 to $2,438,651,090 from the $2,469,663,595 spent during the same period last year, a decrease of 1.3%. For the current year, 70.2% of the total appropriations has been spent. Of the total actual expenditures for last year, 81.6% had been spent as of April 30. -5- Comparison to Prior Year Capital Expenditures YEAR-TO-DATE CAPITAL EXPENDITURES As of April 30, 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 April 30 decreased $105,937,809 to $585,644,857 from the $691,582,666 spent during the same period last year, a decrease of 15.3%. For the current year, 44.4% of the total appropriations has been spent. Of the total actual expenditures for last year, 80.3% had been spent as of April 30. -6- Summary Operating Revenues As of April 30 (dollars in thousands) Source General Funds Local Taxes: Sales Taxes Privilege License Fees State Shared Taxes: State Sales Tax State Income Tax Vehicle License Tax Primary Property Tax Licenses and Permits Cable Communications Municipal Court Police Library Fees Parks and Recreation Planning & Development Street Transportation Fire Interest Other Fees and Service Charges Budget Estimate 2011-12 $ Total General Funds Special Revenue Funds and Debt Service Neighborhood Protection Public Safety Enhancement & Expansion Parks and Preserves Transit 2000 Court Awards Planning and Development Capital Construction Sports Facilities Highway User Revenue Regional Transit Revenues Community Reinvestment Other Restricted Fees Grants G.O. Bond Debt Service Total Special Revenue Funds and Debt Service Enterprise Funds Aviation Convention Center Water System Wastewater Solid Waste Golf Courses Total Enterprise Funds Total Operating Revenues $ 417,006 2,465 Actual Year-to-Date 2011-12 2010-11 335,251 $ 2,202 326,877 2,282 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 93,002 101,676 38,168 82,136 2,400 7,121 18,995 13,124 1,099 4,595 829 4,510 39,949 530 11,638 92,589 119,706 40,357 83,105 2,607 7,192 18,789 13,939 1,016 5,646 912 4,568 42,307 229 14,970 84.0 83.3 79.4 64.8 73.4 74.4 86.9 104.2 87.5 64.7 83.5 88.0 81.2 176.7 78.2 82.8 83.3 83.6 63.5 84.3 75.0 83.6 86.4 81.7 75.3 81.2 87.0 86.2 68.6 86.0 953,212 757,225 777,091 79.4 80.7 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 21,977 64,093 22,250 132,102 7,414 28,205 13,847 12,317 75,129 17,789 2,730 28,273 182,943 63,466 20,815 62,262 21,358 125,983 2,692 25,459 14,136 11,923 86,931 22,330 7,283 18,449 153,981 97,858 81.5 81.6 80.9 82.6 64.9 85.2 79.1 83.3 82.4 61.6 70.8 110.3 59.8 63.6 82.1 83.6 82.3 82.2 91.3 80.1 90.4 81.2 82.3 52.9 82.0 75.6 62.4 63.4 925,073 672,535 671,460 72.7 72.5 329,036 57,391 366,646 230,882 142,567 6,130 279,011 46,025 313,803 202,395 120,838 5,320 273,451 51,876 286,331 205,076 119,701 4,981 84.8 80.2 85.6 87.7 84.8 86.8 82.2 84.4 80.7 90.1 83.6 87.2 1,132,652 967,392 941,416 85.4 83.7 79.6 % 79.3 % 3,010,937 -7- $ % of Year-to-Date Estimate Actual 2011-12 2010-11 $ 2,397,152 $ 2,389,967 80.4 % 89.3 83.3 % 93.4 Summary Operating Revenues As of April 30, 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 April 30 (dollars in thousands) Source General Government General Funds Other Funds Total General Government Actual Year-to-Date 2011-12 2010-11 Budget 2011-12 $ 79,303 $ 9,168 88,471 57,052 6,800 63,852 76.2 % 60.4 74.2 35,662 9,893 45,555 27,426 2,388 29,814 27,773 5,994 33,767 76.9 24.1 65.4 83.3 165.0 91.4 Public Safety General Funds Other Funds Total Public Safety 655,377 161,111 816,488 536,640 127,841 664,481 534,893 130,866 665,759 81.9 79.3 81.4 83.6 85.9 84.1 Transportation General Funds Other Funds Total Transportation 41,758 566,577 608,335 30,894 465,038 495,932 33,129 456,820 489,949 74.0 82.1 81.5 85.6 86.3 86.3 Community Development General Funds Other Funds Total Community Development 21,470 230,974 252,444 15,861 141,473 157,334 16,098 130,956 147,054 73.9 61.3 62.3 82.7 83.6 83.5 Community Enrichment General Funds Other Funds Total Community Enrichment 145,458 136,167 281,625 110,342 108,185 218,527 113,200 117,635 230,835 75.9 79.5 77.6 82.2 85.8 84.0 Environmental Services General Funds Other Funds Total Environmental Services 17,378 617,100 634,478 12,432 434,935 447,367 6,945 468,983 475,928 71.5 70.5 70.5 49.4 83.9 83.1 Debt Service General Funds Other Funds Total Debt Service 138,719 138,719 141,044 141,044 160,495 160,495 101.7 101.7 81.6 81.6 Capital Improvement General Funds Other Funds Total Capital Improvement 3,733 489,288 493,021 2,039 193,642 195,681 320 201,705 202,025 54.6 39.6 39.7 28.6 61.2 61.1 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 - $ 814,937 1,623,714 2,438,651 $ -9- 789,410 1,680,254 2,469,664 76.7 67.3 70.2 % 80.8 % 91.9 81.8 82.7 81.1 81.6 % Summary Operating Expenditures and Encumbrances As of April 30, 2012 Total General Government Total Criminal Justice 100 40 90 80 30 (millions of dollars) (millions of dollars) 70 60 50 40 20 30 10 20 10 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 April 30, 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 April 30 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 $ 34,955,014 95,174 $ 34,169,426 97,784 Local Taxes: Sales Taxes Privilege License Fees $ 417,006,000 2,464,500 $ 335,251,249 2,201,693 $ 326,877,579 2,281,225 80.4 % 89.3 83.3 % 93.4 35,050,188 34,267,210 Total Local Taxes 419,470,500 337,452,942 329,158,804 80.4 83.4 9,743,517 10,168,121 3,482,279 10,448,089 11,970,582 3,853,921 State Shared Taxes: State Sales Tax State Income Tax Vehicle License Tax 110,696,000 122,065,000 48,045,000 93,001,656 101,676,165 38,168,577 92,588,751 119,705,845 40,356,854 84.0 83.3 79.4 82.8 83.3 83.6 23,393,917 26,272,592 280,806,000 232,846,398 252,651,450 82.9 83.2 6,443,897 6,809,292 Primary Property Tax 126,763,000 82,136,117 83,105,083 64.8 63.5 215,028 218,789 Licenses and Permits 3,270,000 2,400,183 2,607,316 73.4 84.3 2,433,143 2,392,357 Cable Communications 9,567,056 7,120,810 7,191,712 74.4 75.0 1,948,438 161,593 1,862,588 136,914 Municipal Court: Fines and Forfeitures Court Default Fee 20,759,025 1,100,000 17,972,132 1,022,612 17,806,973 981,639 86.6 93.0 83.5 84.6 2,110,031 1,999,502 21,859,025 18,994,744 18,788,612 86.9 83.6 1,243,493 1,227,669 12,597,587 13,124,261 13,939,045 104.2 86.4 108,858 99,186 Library Fees 1,256,140 1,099,201 1,016,014 87.5 81.7 308,502 538,498 Parks and Recreation 7,102,531 4,594,557 5,646,173 64.7 75.3 82,485 126,567 Planning and Development 993,300 828,631 912,614 83.4 81.2 336,128 (186,966) 5,124,098 4,510,048 4,567,885 88.0 87.0 36,750,000 1,300,000 11,161,613 29,964,707 620,265 9,363,862 31,635,876 815,843 9,855,901 81.5 47.7 83.9 85.9 63.2 90.0 49,211,613 39,948,834 42,307,620 81.2 86.2 3,136,592 38,979 1,573,752 4,941,895 150,350 2,123,067 4,749,323 7,215,312 36,600 27,793 1,058,985 1,662,968 77,570,578 82,670,769 Total State Shared Taxes Total Municipal Court Police Street Transportation Fire: Emergency Transportation Service Hazardous Materials Inspection Fee Other Total Fire Interest Other Fees and Service Charges Total General Funds - 12 - 301,380 530,024 229,239 175.9 68.6 14,889,664 11,638,469 14,970,100 78.2 86.0 953,211,894 757,225,219 777,091,667 79.4 80.7 Revenues Revenues For the Month Ended April 30 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,743,847 $ 124,560 622,803 (4,810) 1,663,228 118,801 594,010 (1,012) 2,486,400 2,375,027 5,003,689 1,620,444 (6,679) 4,812,877 1,570,727 437 Neighborhood Protection: Police Neighborhood Protection Police Blockwatch Fire Neighborhood Protection Interest/Other Total Neighborhood Protection $ 15,339,227 1,095,659 5,478,296 64,096 $ 14,592,196 1,042,299 5,211,499 (31,010) 81.4 % 81.5 81.4 133.5 82.3 % 81.8 81.8 73.5 21,977,278 20,814,984 81.5 82.1 58,269,000 20,108,000 140,000 47,652,148 16,485,330 (44,714) 46,066,063 16,146,771 48,773 81.8 82.0 (31.9) 83.3 84.2 101.9 78,517,000 64,092,764 62,261,607 81.6 83.6 27,510,000 22,250,029 21,357,768 80.9 82.3 107,640,000 52,325,926 87,652,726 44,449,471 83,383,978 42,599,321 81.4 84.9 82.2 82.2 159,965,926 132,102,197 125,983,299 82.6 82.2 Court Awards 11,425,309 7,413,676 2,691,773 64.9 91.3 Public Safety Enhancement & Expansion: Police Fire Interest/Other 6,617,454 6,384,041 2,420,064 Parks and Preserves 9,964,837 5,620,818 9,504,157 7,645,567 Transit 2000: Sales Taxes Interest/Other 15,585,655 17,149,724 - 18,837,000 1,345,000 6,726,000 48,000 26,956,000 2,518,565 - $ Total Public Safety Enhancement & Expansion Total Transit 2000 3,393,642 2,778,637 Planning and Development 33,100,000 28,204,618 25,459,024 85.2 80.1 1,163,981 1,449,951 Capital Construction 17,502,000 13,847,440 14,136,319 79.1 90.4 2,151,687 24,375 2,038,292 32,456 Sports Facilities: Sales Taxes Interest/Other 14,386,000 395,000 11,862,181 455,018 11,396,442 526,767 82.5 115.2 81.0 87.2 2,176,062 2,070,748 Total Sports Facilities 14,781,000 12,317,199 11,923,209 83.3 81.2 9,565,467 20,910 (90,912) 9,902,885 51,629 43,261 Highway User Revenue: Highway User Revenue Interest Other 90,226,000 600,000 300,000 74,696,855 253,491 178,665 86,372,777 427,244 131,133 82.8 42.2 59.6 82.3 78.6 96.4 9,495,465 9,997,775 91,126,000 75,129,011 86,931,154 82.4 82.3 2,207,535 39,057 28,863,623 17,788,952 22,330,176 61.6 52.9 303,697 345,761 3,853,899 2,730,064 7,282,679 70.8 82.0 5,946,467 3,060,898 25,633,671 28,272,948 18,448,655 110.3 75.6 Total Highway User Revenue Regional Transit Revenues Community Reinvestment Other Restricted Fees - 13 - Revenues Revenues For the Month Ended April 30 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) $ 549,634 5,255,523 719,090 $ 542,164 6,644,779 70,730 6,524,247 7,257,673 3,031,889 8,637,572 2,455,566 5,989,840 1,616,995 1,380,660 2,209,448 7,025,308 20,114,867 12,232,411 26,639,114 19,490,084 4,569,444 14,381 7,722,495 31,781 4,583,825 7,754,276 83,117,862 75,316,043 Grants: Public Housing: Rentals Grants Other $ Total Public Housing 9,270,065 77,005,775 2,431,392 $ 5,707,529 57,066,461 1,922,523 $ 5,409,824 50,631,852 3,075,709 61.6 % 74.1 79.1 81.7 % 70.5 29.6 88,707,232 64,696,513 59,117,385 72.9 66.6 42,765,750 9,983,354 34,665,229 129,960,524 33,844,284 11,902,727 17,305,867 55,193,312 30,358,403 3,404,812 15,611,145 45,489,368 79.1 119.2 49.9 42.5 67.3 18.1 88.8 59.4 Total Other 217,374,857 118,246,190 94,863,728 54.4 60.0 Total Grants 306,082,089 182,942,703 153,981,113 59.8 62.4 94,529,000 5,228,000 60,873,955 2,591,607 95,211,173 2,647,177 64.4 49.6 63.9 49.8 99,757,000 63,465,562 97,858,350 63.6 63.4 925,073,517 672,534,441 671,460,110 72.7 72.5 108,000,000 173,799,000 1,620,000 3,286,000 1,724,000 3,606,500 37,000,000 75,343,152 163,620,655 1,215,624 2,723,545 1,393,034 2,400,271 32,315,293 68,938,512 165,641,412 1,040,279 2,970,670 1,362,666 2,685,775 30,812,202 69.8 94.1 75.0 82.9 80.8 66.6 87.3 83.0 84.2 76.8 40.5 83.5 83.2 78.2 329,035,500 279,011,574 273,451,516 84.8 82.2 39,685,000 17,106,160 600,000 32,717,386 12,981,381 326,489 31,039,913 20,320,934 515,226 82.4 75.9 54.4 82.0 88.2 82.4 57,391,160 46,025,256 51,876,073 80.2 84.4 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,083,762 19,194,726 95,157 405,302 143,470 237,296 4,951,285 7,245,432 17,787,654 91,722 216,660 126,516 235,384 4,824,797 33,110,998 30,528,165 Sky Harbor: Airlines Concessions Interest Other Phoenix-Goodyear Phoenix-Deer Valley Phoenix-Customer Facility Charge Total Aviation CONVENTION CENTER: 4,609,824 2,173,897 26,663 4,194,511 2,095,076 48,037 6,810,384 6,337,624 Excise Taxes Operating Revenue Interest Total Convention Center - 14 - Revenues Revenues For the Month Ended April 30 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: $ 25,680,112 436,299 359,131 634,352 182,940 73,865 281,549 $ 27,648,248 26,104,220 521,629 326,122 787,926 108,300 282,120 283,772 28,414,089 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 $ 293,098,311 4,715,143 3,003,216 6,775,209 1,526,940 1,566,478 3,117,594 $ 266,090,267 4,960,140 2,531,036 6,152,847 1,032,600 2,874,636 2,688,996 85.4 % 78.6 94.4 72.1 101.8 120.7 157.5 80.2 % 82.5 93.7 78.4 84.8 82.9 161.2 366,646,000 313,802,891 286,330,522 85.6 80.7 196,104,000 14,486,000 1,400,000 1,962,000 16,930,000 161,871,685 16,575,107 1,403,940 1,890,272 20,654,068 164,509,216 16,136,966 901,979 2,454,615 21,073,166 82.5 114.4 100.3 96.3 122.0 83.2 84.7 85.2 79.6 310.3 230,882,000 202,395,072 205,075,942 87.7 90.1 123,625,000 7,440,000 750,000 10,752,500 103,482,133 5,482,651 431,053 11,441,896 102,853,430 6,762,783 582,173 9,502,145 83.7 73.7 57.5 106.4 83.3 80.5 84.4 89.9 142,567,500 120,837,733 119,700,531 84.8 83.6 WASTEWATER: 16,182,746 1,791,451 141,420 214,325 607,697 16,478,307 1,819,323 83,639 315,985 737,810 18,937,639 19,435,064 Sewer Service Charges Multi-City Development Fees Interest Other Total Wastewater SOLID WASTE: 10,408,917 402,813 40,697 1,108,288 10,313,739 786,540 52,032 1,070,860 11,960,715 12,223,171 Collection Fees Landfill Fees Interest Other Total Solid Waste GOLF COURSES: $ 428,099 6,681 207,802 (8,510) 7,910 447,210 7,783 211,372 (10,703) 14,588 641,982 670,250 99,109,966 97,608,363 259,798,406 $ 255,595,175 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,516,993 67,368 1,743,769 (99,274) 90,736 3,299,432 59,129 1,564,120 (117,489) 175,731 85.8 85.9 86.8 53.6 70.9 87.9 80.5 84.5 82.3 102.1 6,129,618 5,319,592 4,980,923 86.8 87.2 1,132,651,778 967,392,118 941,415,507 85.4 83.7 79.6 % 79.3 % 3,010,937,189 $ 2,397,151,778 $ 2,389,967,284 Operating Expenditures and Encumbrances For the Month Ended April 30 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 $ 115,215 $ 234,957 233,225 2,237,572 71,166 198,832 194,248 1,576,244 (76,838) 343,969 224,125 817,025 6,670 13,829 244,559 927,370 (1,068,734) 6,293,434 91,936 246,342 228,494 1,631,669 90,542 173,817 209,901 1,356,736 126,075 367,306 109,906 739,175 17,596 8,042 251,586 827,903 6,477,026 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,137,294 2,566,109 1,328,932 23,589,566 1,343,837 2,199,068 2,117,635 16,229,467 1,561,773 3,892,925 1,891,834 8,577,927 92,245 52,371 2,601,472 15,788,509 3,500,035 $ 1,152,884 2,703,128 1,463,437 1,456,890 1,067,487 2,227,056 2,241,781 16,669,972 2,182,377 3,001,901 336,122 8,880,819 90,753 102,056 2,946,931 17,328,061 - $ 1,137,294 2,566,109 1,328,932 23,428,945 1,343,837 2,199,068 2,117,635 16,229,467 1,561,773 3,879,999 1,891,834 8,505,956 92,245 52,371 2,601,472 15,674,401 3,500,035 $ 160,621 12,926 71,971 114,108 - 119,308,245 88,470,999 63,851,655 88,111,373 359,626 40,846,452 4,708,450 25,946,919 3,867,516 29,990,918 3,776,500 25,557,982 3,867,516 388,937 - 45,554,902 29,814,435 33,767,418 29,425,498 388,937 547,390,725 268,616,005 480,992 447,425,134 216,759,849 295,622 449,744,678 215,423,253 591,380 445,199,549 215,925,873 295,622 2,225,585 833,976 - 816,487,722 664,480,605 665,759,311 661,421,044 3,059,561 Criminal Justice 2,305,682 376,780 2,748,796 372,999 2,682,462 3,121,795 Municipal Court Public Defender Total Criminal Justice Public Safety 40,582,910 20,049,736 52,167 41,181,897 20,442,670 67,790 60,684,813 61,692,357 Police Fire Other Total Public Safety - 16 - Operating Expenditures and Encumbrances For the Month Ended April 30 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,337,396 775,039 18,510,909 5,250,606 28,873,950 $ 4,300,495 876,858 20,641,805 5,503,034 31,322,192 Street Transportation Street Lighting Aviation Public Transit Total Transportation $ 58,632,945 11,685,358 290,441,289 247,575,530 $ 46,332,688 8,673,595 217,426,516 223,499,154 $ 45,654,149 9,334,453 213,726,049 221,234,731 $ 46,236,952 8,673,595 160,974,439 179,987,187 $ 95,736 56,452,077 43,511,967 608,335,122 495,931,953 489,949,382 395,872,173 100,059,780 Community Development 2,377,835 6,186,184 1,912,487 3,855,907 2,405,682 6,296,750 1,615,899 3,079,447 Planning and Development Housing Economic Development Neighborhood Services Department 33,601,910 75,137,220 37,775,681 105,929,214 25,835,509 64,644,940 19,983,737 46,869,502 26,548,424 63,579,267 21,820,997 35,104,883 25,835,509 64,584,532 18,162,579 46,869,502 60,408 1,821,158 - 14,332,413 13,397,778 Total Community Development 252,444,025 157,333,688 147,053,571 155,452,122 1,881,566 96,385,575 36,069,133 8,341,758 62,545,832 10,968,395 62,339,505 4,133,240 841,581 75,820,376 25,557,790 6,833,697 48,759,678 6,581,443 51,831,001 2,587,455 555,647 76,933,943 26,986,007 6,568,839 52,127,346 10,183,373 54,442,449 2,645,892 947,215 75,677,191 25,557,790 6,832,947 32,596,703 51,783,349 2,587,455 555,647 143,185 750 16,162,975 6,581,443 47,652 - 281,625,019 218,527,087 230,835,064 195,591,082 22,936,005 Community Enrichment 6,944,314 1,919,067 532,351 3,788,213 651,070 4,442,265 160,255 (54,459) 18,383,076 7,328,506 3,075,719 743,132 4,306,649 1,017,965 5,711,650 264,546 80,738 22,528,905 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 April 30 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 $ 20,116,244 10,756,247 8,036,500 1,321,628 136,262 40,366,881 $ 24,073,893 13,074,229 10,301,894 254,131 109,363 47,813,510 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 $ 226,514,613 116,712,542 90,320,837 12,868,821 950,089 $ 234,263,386 128,620,171 99,926,623 12,101,517 1,015,993 $ 141,558,157 57,956,990 79,589,213 12,185,292 950,089 $ 292,239,741 84,956,456 58,755,552 10,731,624 683,529 - 634,477,563 447,366,902 475,927,690 155,127,161 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,095,879 10,231,522 16,451,820 176,137 3,420,654 559,804 3,432,879 564,537 7,727,331 5,903,845 774,602 20,917,007 41,833 6,694,760 1,299,609 4,534,844 3,834 1,538,229 26,366,188 23,170,909 255,344 5,882,445 1,095,046 7,951,313 16,742,347 220,604 4,046,279 555,971 4,053,151 702,105 6,071,996 4,664,397 766,269 15,618,111 41,833 9,803,935 2,129,184 6,542,532 20,349,250 2,514,625 21,227,053 30,553,519 139,010 4,706,066 - 1,095,879 10,231,522 16,451,820 176,137 3,420,654 559,804 3,432,879 564,537 7,727,331 5,903,845 774,602 20,917,007 41,833 6,694,760 1,299,609 4,534,844 3,834 1,538,229 26,366,188 23,170,909 255,344 5,882,445 General Obligation Debt Service 109,588 1,023,153 1,645,182 17,614 342,065 55,980 343,288 56,454 772,733 590,384 77,460 2,091,377 4,183 669,476 129,961 431,276 6 153,823 2,636,619 2,317,091 25,535 582,467 109,505 795,131 1,674,234 22,060 404,628 55,597 405,315 70,211 607,200 466,439 76,627 1,561,487 4,183 980,394 212,919 1,591,340 7 628,656 2,122,706 3,055,355 13,901 1,170,908 14,075,715 16,028,803 Total Debt Service 138,718,984 141,044,012 160,494,596 - 141,044,012 18,542,776 21,307,595 Capital Improvement 493,021,254 195,681,409 202,024,908 - 195,681,409 $ 204,235,520 $ 223,689,961 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,438,651,090 $ 2,469,663,595 $ 1,818,113,033 $ 620,538,057 Capital Expenditures and Encumbrances For the Month Ended April 30 2012 2011 $ $ Capital Expenditures and Encumbrances 2011-12 Actual YearBudget to-Date Program 1,705,902 $ 6,288,051 74,114 446,426 193,191 245,232 7,009,658 244,651 315,115 4,789,577 Arts and Cultural Facilities Aviation Economic Development Energy Conservation Facilities Management 3,192,677 (1,193) 1,928,262 129,005 83,149 3,051,640 Fire Protection Freeway Mitigation Historic Preservation Housing 21,140,399 2,759,359 63,604,234 13,328,087 481,740 29,064,776 Human Services Information Technology Libraries Neighborhood Services 2,857,262 14,253,403 7,697,854 12,085,676 Parks and Mountain Preserves Phoenix Convention Center Police Protection Public Transit 108,653 469,440 87,073 161,474 109,575 296,911 279,734 145,505 1,056,088 256,894 121,872 1,400,379 5,221,348 147,412 972,932 6,980,798 2,994,635 3,021,255 2,330,294 8,317,019 101,647 34,254,359 4,709,532 11,131,286 34,152,506 $ 80,219,066 Solid Waste Disposal Street Transportation & Drainage Wastewater Water System Total Capital Improvement Program $ 14,804,107 $ 435,812,669 10,143,514 17,716,981 19,197,800 233,272 28,416,018 4,710,969 8,995,484 280,512 5,030,329 1,351,271 39,588,955 86,883 48,568,331 487,310 5,294,902 3,015,203 1,567,436 4,622,634 6,838,882 4,571,301 2,822,918 99,788,025 2,212,303 25,509,600 77,991,552 35,417,600 895,140 2,394,977 7,894,495 31,444,218 155,714,473 107,462,416 197,600,987 15,392,357 52,051,761 18,229,534 70,233,297 585,644,857 $ - 19 - 4,467,919 124,357,838 14,392,354 4,712,606 11,520,931 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 $ 1,319,796,832 $ 9,359,389 $ 299,023,716 5,122,145 8,995,484 7,395,508 2010-11 Actual Yearto-Date 13,609,107 $ 382,222,294 3,598,529 17,445,800 9,126,117 270,607,698 411,176 7,114,996 18,785,748 21,140,399 2,672,476 15,035,903 13,328,087 481,740 10,279,028 7,812,312 2,277,619 34,539,458 10,256,533 1,454,500 3,966,861 3,204,470 1,347,993 648,091 2,857,262 3,996,870 6,243,354 8,118,815 487,310 2,090,432 1,667,210 919,345 2,369,952 8,958,501 4,682,651 10,518,240 59,460,677 3,974,902 11,250,560 27,653,750 46,850,118 2,212,303 26,179,381 22,923,537 811,669 2,462,899 52,937,907 25,509,600 51,812,171 12,494,063 83,471 2,394,977 5,431,596 64,370,425 1,317,163 23,114,623 70,097,057 21,801,457 114,711,721 30,970,378 197,481,283 16,565,000 70,784,504 72,777,540 112,519,959 7,924,715 32,817,120 15,695,239 46,423,673 14,879,218 84,929,969 34,684,876 85,081,028 7,467,642 19,234,641 2,534,295 23,809,624 16,051,861 103,662,712 89,232,882 127,367,690 691,582,666 $ $ 493,021,254 $ 195,681,409 $ Unencumbered Budget $ 826,775,578 $ 389,963,448 $ $ 5,444,718 136,788,953 5,021,369 8,721,497 11,802,292 734,151,975 Bonds Authorized and Sold As of April 30 (dollars in thousands) Authorized 1988 Authorizations General Obligation Bonds Freeway Mitigation, Neighborhood Stabilization, and Slum and Blight Elimination Bonds Fully Issued $ Total General Obligation Bonds Revenue Bonds Bonds Fully Issued Total 1988 Authorizations 29,285 884,175 Sold $ 28,285 884,175 Available $ 1,000 - 913,460 912,460 1,000 143,890 143,890 - 1,057,350 1,056,350 1,000 66,300 125,300 24,800 61,500 12,000 33,000 91,500 74,000 77,000 78,800 66,000 43,700 64,325 123,085 24,170 60,600 11,075 32,100 89,275 71,645 72,575 75,640 64,230 43,700 1,975 2,215 630 900 925 900 2,225 2,355 4,425 3,160 1,770 - 753,900 732,420 21,480 81,000 11,100 198,700 12,800 104,622 74,705 29,178 115,500 107,295 78,200 65,400 57,645 8,400 186,950 7,075 63,290 43,900 19,675 72,325 62,900 55,915 50,550 23,355 2,700 11,750 5,725 41,332 30,805 9,503 43,175 44,395 22,285 14,850 878,500 628,625 249,875 2001 Authorization General Obligation Bonds Education, Youth and Family Cultural Facilities Computer Technology Environmental Cleanup Fire Protection Historic Preservation Library Facilities Street Improvements Neighborhood Protection and Senior Centers Parks, Open Space, and Recreational Facilities Police Protection Storm Sewer and Flood Protection Bonds Fully Issued Total 2001 Authorizations 2006 Authorization General Obligation Bonds Affordable Housing and Neighborhood Revitalization Computer Technology Education and Health Science Facilities Environmental Cleanup Family, Senior, and Youth Cultural Facilities Fire Protection Library Facilities and Improvements Parks, Open Space, and Recreational Facilities Police Protection Street Improvements Storm Sewer and Flood Protection Total 2006 Authorizations Total Bond Program $ - 20 - 2,689,750 $ 2,417,395 $ 272,355