City of Phoenix, Arizona Monthly Financial Report February 2012 Monthly Financial Report – February 2012 Executive Summary Budget • The budget amounts in this report represent the official adopted budget, as approved by the City Council, for fiscal year 2011-12. Revenues • Citywide year-to-date revenues for the month of February 2012 are $10.7 million more than year-to-date revenues for February 2011. This is an increase of 1% and is due to increases in the enterprise funds of primarily Water, Solid Waste and Aviation. (see page 7) • Revenues for the General Fund were $11.9 million less than prior year-to-date revenues. Local sales taxes and the City’s portion of state shared taxes comprise the major portion, approximately 73.2 percent, of estimated General Fund revenues. As of February 2012, local sales taxes were up $6.3 million compared to the prior year-to-date General Fund revenues. However, state shared taxes were down $15.6 million, Primary Property Taxes were down $1.0 million and Police revenue was down $1.0 million compared to the prior year-todate. The decrease in state shared revenues was mostly from Income and Vehicle License Taxes. The decrease in Police revenues reflects a settlement received in the prior year. Revenues through February 2012 are slightly lower than what was projected in the Budget Estimate. (see pages 12-13) • Regional Transit revenues are less as compared to the fiscal year 2012 budget estimate. This is due to a decrease in public transportation reimbursements for light rail costs and service reductions. Expenditures • Citywide year-to-date expenditures for the month of February 2012 are $15.4 million more than year to date expenditures for February 2011. The increase is mostly related to an increase of $11.3 million in citywide capital improvements (see pages 24 and 25). • Year-to-date General Fund expenditures for the first eight months of the fiscal year are less than budgeted expenditures. This is primarily due to less expenditures as compared to the budget in capital improvements, environmental services, community development and transportation. Year-to-date General Fund expenditures are $16.8 million more than prior year-to-date expenditures. This increase is primarily due to increases in Public Safety and Environmental Services. • Capital fund year-to-date expenditures have decreased $27.6 million to $520.2 million from $547.8 million spent during the same period last year. Decreases in capital expenditures as compared to last year-to-date include $106.1 million in Water, $16.4 in Parks and Preserves, $30.7 in Streets and Transportation, $13.7 million in Public Transit and $9.0 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 $172.8 million. (see pages 2627) -1- General Funds Summary Summary General Funds As of February 29 (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 $ 267,748 $ 1,994 261,406 2,048 64.2 % 80.9 66.6 % 83.8 110,696 122,065 48,045 126,763 3,270 9,567 73,705 81,340 29,826 70,932 1,897 4,688 73,007 95,765 31,683 71,755 2,111 4,799 66.6 66.6 62.1 56.0 58.0 49.0 65.3 66.7 65.6 54.8 68.3 50.1 20,759 1,100 12,598 1,256 7,103 993 5,124 13,786 655 10,585 858 3,391 687 4,057 13,456 668 11,621 805 4,775 656 4,315 66.4 59.5 84.0 68.3 47.7 69.2 79.2 63.1 57.5 72.1 64.7 63.7 58.4 82.1 36,750 12,462 300 14,890 24,017 8,000 453 9,638 23,708 7,995 175 9,369 65.4 64.2 151.0 64.7 64.4 65.3 52.4 53.8 953,212 $ 608,257 $ -2- 620,117 63.8 % 64.4 % Summary General Funds As of February 29 (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 Expenditures and Encumbrances General Government Mayor City Council City Manager Information Technology Services Public Information Equal Opportunity Law City Auditor City Clerk Human Resources Budget and Research Finance Others Total General Government $ 894 $ 2,064 764 18,535 1,559 1,450 11,768 1,546 3,183 6,629 2,099 11,437 2,703 64,631 936 2,125 766 18,368 1,552 1,505 12,256 1,893 3,278 5,595 2,333 10,377 1,153 62,137 62.6 % 62.1 38.7 56.4 67.2 63.4 64.5 60.0 64.1 60.2 65.8 66.6 97.2 62.1 30,954 4,708 35,662 19,143 3,096 22,239 18,978 3,018 21,996 61.8 65.8 62.4 66.2 64.8 66.0 428,455 226,892 30 655,377 286,656 147,673 (26) 434,303 282,173 144,389 68 426,630 66.9 65.1 (86.7) 66.3 67.3 65.6 157.0 66.7 Transportation Street Transportation Public Transit Total Transportation 22,527 19,231 41,758 12,684 12,451 25,135 13,498 12,709 26,207 56.3 64.7 60.2 68.7 66.7 67.7 Community Development Economic Development Neighborhood Services Department Planning and Development Others Total Community Development 4,886 11,532 4,995 57 21,470 2,938 6,879 2,992 32 12,841 2,702 6,536 3,174 83 12,495 60.1 59.7 59.9 56.1 59.8 62.7 63.4 66.9 81.1 64.2 Community Enrichment Parks and Recreation Library Human Services Others Total Community Enrichment 89,567 35,277 18,493 2,121 145,458 58,086 19,641 11,223 1,185 90,135 56,831 20,680 11,139 1,567 90,217 64.9 55.7 60.7 55.9 62.0 65.9 64.0 65.4 69.3 65.5 Environmental Services Public Works Environmental Programs Total Environmental Services 16,400 978 17,378 9,214 494 9,708 3,472 612 4,084 56.2 50.5 55.9 26.4 67.2 29.1 3,733 1,846 310 49.5 27.6 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 $ $ -3- 660,838 $ 644,076 62.2 % 69.9 % 66.1 46.1 654.7 67.9 64.4 68.0 71.3 90.6 60.6 73.6 56.4 60.9 88.0 67.5 % Citywide Summary Comparison to Prior Year Revenues YEAR-TO-DATE REVENUES As of February 29, 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 February 29 increased by $10,724,121 to $1,909,908,605 from the $1,899,184,484 collected during the same period last year, an increase of 0.6%. For the current year, 63.4% of the total estimated revenue has been collected. Of the total revenues received last year, 63.0% had been collected as of February 29. -4- Comparison to Prior Year Operating Expenditures YEAR-TO-DATE OPERATING EXPENDITURES (millions of dollars) As of February 29, 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 February 29 increased $15,352,152 to $2,007,116,445 from the $1,991,764,293 spent during the same period last year, an increase of 0.8%. For the current year, 57.8% of the total appropriations has been spent. Of the total actual expenditures for last year, 65.8% had been spent as of February 29. -5- Comparison to Prior Year Capital Expenditures YEAR-TO-DATE CAPITAL EXPENDITURES As of February 29, 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 February 29 decreased $27,581,137 to $520,164,181 from the $547,745,318 spent during the same period last year, a decrease of 5.0%. For the current year, 39.4% of the total appropriations has been spent. Of the total actual expenditures for last year, 63.6% had been spent as of February 29. -6- Summary Operating Revenues As of February 29 (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 $ 267,748 $ 1,994 261,406 2,048 % of Year-to-Date Estimate Actual 2011-12 2010-11 64.2 % 80.9 66.6 % 83.8 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 73,705 81,340 29,826 70,932 1,897 4,688 14,441 10,585 858 3,391 687 4,057 32,017 453 9,638 73,007 95,765 31,683 71,755 2,111 4,799 14,124 11,621 805 4,775 656 4,315 31,703 175 9,369 66.6 66.6 62.1 56.0 58.0 49.0 66.1 84.0 68.3 47.7 69.2 79.2 65.1 151.0 64.7 65.3 66.7 65.6 54.8 68.3 50.1 62.8 72.1 64.7 63.7 58.4 82.1 64.6 52.4 53.8 953,212 608,257 620,117 63.8 64.4 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 17,280 51,335 17,488 103,230 6,357 21,557 11,315 8,680 55,664 13,650 2,411 19,671 135,123 54,759 16,406 50,053 16,845 95,444 2,221 20,067 11,264 8,427 66,805 22,279 3,922 13,574 107,574 83,938 64.1 65.4 63.6 64.5 55.6 65.1 64.6 58.7 61.1 47.3 62.6 76.7 44.1 54.9 64.7 67.2 64.9 62.3 75.4 63.1 72.0 57.4 63.3 52.8 44.2 55.7 43.6 54.4 925,073 518,520 518,819 56.1 56.0 329,036 57,391 366,646 230,882 142,567 6,130 217,431 33,853 265,428 164,906 97,773 3,741 214,048 40,552 240,287 166,882 95,052 3,427 66.1 59.0 72.4 71.4 68.6 61.0 64.3 65.9 67.8 73.3 66.4 60.0 1,132,652 783,132 760,248 69.1 67.6 63.4 % 63.0 % 3,010,937 -7- $ 1,909,909 $ 1,899,184 Summary Operating Revenues As of February 29, 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 February 29 (dollars in thousands) Source General Government General Funds Other Funds Total General Government Actual Year-to-Date 2011-12 2010-11 Budget 2011-12 $ 64,631 $ 7,478 72,109 62,137 7,306 69,443 62.1 % 49.2 60.4 35,662 9,893 45,555 22,239 1,968 24,207 21,996 4,851 26,847 62.4 19.9 53.1 66.0 133.5 72.6 Public Safety General Funds Other Funds Total Public Safety 655,377 161,111 816,488 434,303 104,089 538,392 426,630 104,364 530,994 66.3 64.6 65.9 66.7 68.5 67.0 Transportation General Funds Other Funds Total Transportation 41,758 566,577 608,335 25,135 404,415 429,550 26,207 388,743 414,950 60.2 71.4 70.6 67.7 73.5 73.1 Community Development General Funds Other Funds Total Community Development 21,470 230,974 252,444 12,841 115,705 128,546 12,495 105,289 117,784 59.8 50.1 50.9 64.2 67.2 66.9 Community Enrichment General Funds Other Funds Total Community Enrichment 145,458 136,167 281,625 90,135 88,544 178,679 90,217 94,566 184,783 62.0 65.0 63.4 65.5 69.0 67.2 Environmental Services General Funds Other Funds Total Environmental Services 17,378 617,100 634,478 9,708 354,111 363,819 4,084 366,795 370,879 55.9 57.4 57.3 29.1 65.7 64.8 Debt Service General Funds Other Funds Total Debt Service 138,719 138,719 112,893 112,893 128,437 128,437 81.4 81.4 65.3 65.3 Capital Improvement General Funds Other Funds Total Capital Improvement 3,733 489,288 493,021 1,846 157,075 158,921 310 147,337 147,647 49.5 32.1 32.2 27.6 44.7 44.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 - $ 660,838 1,346,278 2,007,116 $ -9- 644,076 1,347,688 1,991,764 62.2 55.8 57.8 % 88.0 % 98.8 89.0 67.5 65.1 65.8 % Summary Operating Expenditures and Encumbrances As of February 29, 2012 Total General Government Total Criminal Justice 90 40 80 70 60 (millions of dollars) (millions of dollars) 30 50 40 30 20 10 20 10 0 0 July Aug Sept Oct July Nov Dec Jan Feb Mar April May June Current YTD Expenditures Aug Sept (millions of dollars) (millions of dollars) Nov Dec Jan Current YTD Expenditures Feb Jan Feb Mar April May June Prior YTD Expenditures Total Transportation 850 825 800 775 750 725 700 675 650 625 600 575 550 525 500 475 450 425 400 375 350 325 300 275 250 225 200 175 150 125 100 75 50 25 0 Aug Sept Oct Nov Dec Current YTD Expenditures Prior YTD Expenditures Total Public Safety July Oct 600 575 550 525 500 475 450 425 400 375 350 325 300 275 250 225 200 175 150 125 100 75 50 25 0 July Mar April May June Aug Sept Oct Nov Dec Jan Current YTD Expenditures Prior YTD Expenditures - 10 - Feb Mar April May June Prior YTD Expenditures Summary Operating Expenditures and Encumbrances As of February 29, 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 February 29 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 $ 31,532,232 130,977 $ 30,658,492 180,997 Local Taxes: Sales Taxes Privilege License Fees $ 417,006,000 2,464,500 $ 267,747,573 1,994,482 $ 261,406,119 2,047,666 64.2 % 80.9 66.6 % 83.8 31,663,209 30,839,489 Total Local Taxes 419,470,500 269,742,055 263,453,785 64.3 66.7 8,571,869 10,168,121 3,620,004 9,258,220 11,970,582 3,372,445 State Shared Taxes: State Sales Tax State Income Tax Vehicle License Tax 110,696,000 122,065,000 48,045,000 73,704,631 81,339,924 29,826,132 73,006,690 95,764,682 31,683,361 66.6 66.6 62.1 65.3 66.7 65.6 22,359,994 24,601,247 280,806,000 184,870,687 200,454,733 65.8 66.0 3,263,893 2,558,853 Primary Property Tax 126,763,000 70,931,430 71,754,913 56.0 54.8 265,066 301,250 Licenses and Permits 3,270,000 1,897,332 2,111,101 58.0 68.3 14,116 Cable Communications 9,567,056 4,687,667 4,799,355 49.0 50.1 2,339,178 151,348 2,210,875 152,190 Municipal Court: Fines and Forfeitures Court Default Fee 20,759,025 1,100,000 13,786,047 654,992 13,456,436 667,603 66.4 59.5 63.1 57.5 2,490,526 2,363,065 21,859,025 14,441,039 14,124,039 66.1 62.8 3,812,618 2,293,766 12,597,587 10,585,042 11,620,648 84.0 72.1 - 113,685 91,504 561,073 218,485 116,971 69,231 555,282 918,900 3,188,651 45,800 702,668 2,866,990 28,450 656,484 3,937,119 3,551,924 41,912 27,534 967,790 335,286 70,149,138 68,184,650 Total State Shared Taxes Total Municipal Court Police Library Fees 1,256,140 858,037 804,717 68.3 64.7 Parks and Recreation 7,102,531 3,391,351 4,775,022 47.7 63.7 993,300 686,856 656,567 69.1 58.4 5,124,098 4,056,941 4,314,816 79.2 82.1 36,750,000 1,300,000 11,161,613 24,017,006 441,561 7,558,753 23,708,199 404,261 7,591,029 65.4 34.0 67.7 64.4 31.3 69.3 49,211,613 32,017,320 31,703,489 65.1 64.6 301,380 452,386 175,036 150.1 52.4 14,889,664 9,638,306 9,369,022 64.7 53.8 953,211,894 608,256,449 620,117,243 63.8 64.4 Planning and Development Street Transportation 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 February 29 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,461,766 $ 104,411 522,059 (5,547) 1,398,190 99,870 499,353 20,651 2,082,689 2,018,064 Neighborhood Protection: Police Neighborhood Protection Police Blockwatch Fire Neighborhood Protection Interest/Other Total Neighborhood Protection $ 12,043,925 860,280 4,301,402 74,124 $ 11,498,453 821,318 4,106,590 (20,092) 63.9 % 64.0 64.0 154.4 64.8 % 64.4 64.4 47.6 17,279,731 16,406,269 64.1 64.7 58,269,000 20,108,000 140,000 38,039,894 13,326,974 (31,495) 36,907,770 13,098,632 46,423 65.3 66.3 (22.5) 66.8 68.3 97.0 78,517,000 51,335,373 50,052,825 65.4 67.2 27,510,000 17,488,380 16,845,506 63.6 64.9 107,640,000 52,325,926 68,822,430 34,407,067 65,705,443 29,738,147 63.9 65.8 64.8 57.4 159,965,926 103,229,497 95,443,590 64.5 62.3 Court Awards 11,425,309 6,356,648 2,220,900 55.6 75.4 Planning and Development 33,100,000 21,557,000 20,066,632 65.1 63.1 4,343,854 1,503,586 2,274 5,980,783 5,849,714 2,112,940 2,039,129 Parks and Preserves 8,352,949 4,762,582 7,989,652 2,376,100 Transit 2000: Sales Taxes Interest/Other 13,115,531 10,365,752 - 18,837,000 1,345,000 6,726,000 48,000 26,956,000 Public Safety Enhancement & Expansion: Police Fire Interest/Other 4,463,483 1,523,424 (6,124) - $ Total Public Safety Enhancement & Expansion Total Transit 2000 3,051,459 2,303,551 1,440,444 1,418,598 Capital Construction 17,502,000 11,315,412 11,263,511 64.7 72.0 1,209,891 25,866 1,260,310 32,343 Sports Facilities: Sales Taxes Interest/Other 14,386,000 395,000 8,274,584 405,744 7,969,362 457,624 57.5 102.7 56.6 75.8 1,235,757 1,292,653 Total Sports Facilities 14,781,000 8,680,328 8,426,986 58.7 57.4 6,883,440 21,769 1,865 8,288,459 45,292 (20,230) Highway User Revenue: Highway User Revenue Interest Other 90,226,000 600,000 300,000 55,293,131 210,361 160,028 66,395,460 321,833 87,572 61.3 35.1 53.3 63.3 59.2 64.3 6,907,074 8,313,521 91,126,000 55,663,520 66,804,865 61.1 63.3 1,931,418 11,590 28,863,623 13,650,372 22,279,274 47.3 52.8 281,299 191,273 3,853,899 2,411,156 3,922,113 62.6 44.2 1,791,292 1,145,158 25,633,671 19,670,729 13,574,307 76.7 55.7 Total Highway User Revenue Regional Transit Revenues Community Reinvestment Other Restricted Fees - 13 - Revenues For the Month Ended February 29 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) $ 569,313 6,806,534 88,691 $ 474,916 5,828,011 302,347 7,464,538 6,605,274 2,862,307 85,881 117,438 10,299,003 13,278,055 35,855 1,040,710 7,059,163 13,364,629 21,413,783 20,829,167 28,019,057 2,421,581 10,073 3,040,409 21,058 2,431,654 3,061,467 63,191,507 66,029,527 Grants: Public Housing: Rentals Grants Other $ Total Public Housing 9,270,065 77,005,775 2,431,392 $ 4,547,743 46,094,869 1,127,280 $ 4,173,596 38,276,025 2,299,832 49.1 % 59.9 46.4 63.0 % 53.3 22.1 88,707,232 51,769,892 44,749,453 58.4 50.4 42,765,750 9,983,354 34,665,229 129,960,524 26,473,888 2,884,891 9,744,164 44,249,985 26,263,771 (2,081,381) 11,307,089 27,335,034 61.9 28.9 28.1 34.0 58.2 (11.0) 64.3 35.7 Total Other 217,374,857 83,352,928 62,824,513 38.3 39.7 Total Grants 306,082,089 135,122,820 107,573,966 44.1 43.6 94,529,000 5,228,000 52,194,167 2,565,190 81,353,958 2,584,250 55.2 49.1 54.6 48.6 99,757,000 54,759,357 83,938,208 54.9 54.4 925,073,517 518,520,323 518,818,952 56.1 56.0 108,000,000 173,799,000 1,620,000 3,286,000 1,724,000 3,606,500 37,000,000 59,625,647 128,139,521 1,025,779 2,054,761 1,110,748 1,906,495 23,567,919 54,757,136 130,226,621 853,127 2,584,069 1,100,352 2,204,372 22,321,996 55.2 73.7 63.3 62.5 64.4 52.9 63.7 65.9 66.2 62.9 35.3 67.4 68.3 56.7 329,035,500 217,430,870 214,047,673 66.1 64.3 39,685,000 17,106,160 600,000 24,608,473 8,971,462 273,388 23,510,512 16,628,219 413,827 62.0 52.4 45.6 62.1 72.2 66.2 57,391,160 33,853,323 40,552,558 59.0 65.9 Other: Human Resources Federal Transit Administration Community Development Other G.O. Bond Debt Service Secondary Property Tax Interest Total G.O. Bond Debt Service Total Special Revenue and Debt Service Enterprise Funds AVIATION: 7,796,856 14,913,067 93,443 435,029 137,471 222,079 3,430,454 6,852,948 15,260,580 80,513 187,065 133,660 239,929 5,604,248 27,028,399 28,358,943 Sky Harbor: Airlines Concessions Interest Other Phoenix-Goodyear Phoenix-Deer Valley Phoenix-Customer Facility Charge Total Aviation CONVENTION CENTER: 3,375,651 780,531 26,799 3,219,222 1,096,135 45,738 4,182,981 4,361,095 Excise Taxes Operating Revenue Interest Total Convention Center - 14 - Revenues For the Month Ended February 29 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: $ 16,596,154 494,391 223,341 400,006 280,860 171,172 116,422 $ 18,282,346 14,686,059 488,881 228,224 484,619 126,240 237,184 119,654 16,370,861 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 $ 248,658,633 3,788,953 2,335,044 5,686,940 1,211,520 1,339,340 2,407,865 $ 224,445,896 3,846,864 2,017,071 4,753,866 802,800 2,343,445 2,077,358 72.4 % 63.1 73.4 60.5 80.8 103.2 121.6 67.7 % 64.0 74.7 60.6 65.9 67.6 124.5 366,646,000 265,428,295 240,287,300 72.4 67.8 196,104,000 14,486,000 1,400,000 1,962,000 16,930,000 129,607,330 13,361,393 1,146,060 1,526,065 19,264,867 131,661,183 12,979,362 717,360 1,962,983 19,561,014 66.1 92.2 81.9 77.8 113.8 66.6 68.2 67.7 63.6 288.0 230,882,000 164,905,715 166,881,902 71.4 73.3 123,625,000 7,440,000 750,000 10,752,500 82,684,730 4,571,627 348,103 10,168,786 82,255,582 5,026,081 468,769 7,301,767 66.9 61.4 46.4 94.6 66.6 59.8 67.9 69.1 142,567,500 97,773,246 95,052,199 68.6 66.4 WASTEWATER: 16,124,007 1,749,750 268,560 130,493 (2,234,314) 16,259,960 1,683,075 119,400 198,107 5,328,636 16,038,496 23,589,178 Sewer Service Charges Multi-City Development Fees Interest Other Total Wastewater SOLID WASTE: 10,293,115 559,571 41,963 1,708,675 10,265,771 455,946 53,083 405,020 12,603,324 11,179,820 Collection Fees Landfill Fees Interest Other Total Solid Waste GOLF COURSES: $ 571,571 5,856 217,507 (9,324) 6,888 511,093 6,779 183,468 (11,045) 21,878 792,498 712,173 78,928,044 84,572,070 212,268,689 $ 218,786,247 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 2,418,625 53,393 1,283,267 (81,811) 66,910 2,208,367 44,492 1,109,553 (94,523) 158,768 59.0 68.1 63.9 44.2 52.3 58.8 60.6 59.9 66.2 92.3 6,129,618 3,740,384 3,426,657 61.0 60.0 1,132,651,778 783,131,833 760,248,289 69.1 67.6 63.4 % 63.0 % 3,010,937,189 $ 1,909,908,605 $ 1,899,184,484 Operating Expenditures and Encumbrances For the Month Ended February 29 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,186 $ 247,025 246,080 (1,967,249) 68,912 187,500 204,368 1,433,253 134,868 404,030 10,865 765,306 20,679 8,971 236,716 1,786,499 4,865,807 8,794,816 99,611 239,345 244,587 2,035,135 47,801 197,551 194,985 1,446,624 135,457 251,756 2,104 704,233 34,216 11,169 236,516 3,413,826 9,294,916 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 $ 894,363 2,063,624 853,324 18,926,088 1,162,447 1,777,291 1,716,808 12,996,260 1,545,905 3,193,853 1,619,981 6,914,814 36,648 77,001 2,098,837 13,352,209 2,879,578 $ 951,281 2,125,198 936,501 19,310,387 880,938 1,773,104 1,751,319 13,403,118 1,893,241 3,386,736 195,541 6,432,121 2,514 74,051 2,333,066 13,993,704 - $ 894,363 2,063,624 853,324 18,795,188 1,162,447 1,777,291 1,716,808 12,996,260 1,545,905 3,183,321 1,619,981 6,856,171 36,648 77,001 2,098,837 13,259,232 2,879,578 $ 130,900 10,532 58,643 92,977 - 119,308,245 72,109,031 69,442,820 71,815,979 293,052 40,846,452 4,708,450 21,110,801 3,096,618 23,828,406 3,018,243 20,793,706 3,096,618 317,095 - 45,554,902 24,207,419 26,846,649 23,890,324 317,095 547,390,725 268,616,005 480,992 362,939,494 175,237,968 214,770 359,436,218 171,127,197 430,838 361,145,983 174,558,084 214,770 1,793,511 679,884 - 816,487,722 538,392,232 530,994,253 535,918,837 2,473,395 Criminal Justice 2,351,443 381,735 2,673,187 378,072 2,733,178 3,051,259 Municipal Court Public Defender Total Criminal Justice Public Safety 42,354,781 19,644,137 28,465 42,053,861 18,787,907 51,876 62,027,383 60,893,644 Police Fire Other Total Public Safety - 16 - Operating Expenditures and Encumbrances For the Month Ended February 29 2012 2011 Budget Estimate 2011-12 Program Actual Year-to-Date 2011-12 2010-11 2011-12 Year-to-Date Operating Expenditures & Encumbrances Capital Operations and Debt Transportation $ 3,228,574 859,344 27,986,835 9,013,897 41,088,650 $ 3,947,782 1,004,989 21,850,267 11,225,314 38,028,352 Street Transportation Street Lighting Aviation Public Transit Total Transportation $ 58,632,945 11,685,358 290,441,289 247,575,530 $ 37,634,459 6,882,972 175,487,570 209,544,740 $ 36,119,364 7,379,977 169,000,160 202,450,877 $ 37,556,452 6,882,972 128,939,288 175,689,320 $ 78,007 46,548,282 33,855,420 608,335,122 429,549,741 414,950,378 349,068,032 80,481,709 Community Development 2,351,027 6,061,959 1,768,413 4,361,508 2,533,217 6,278,887 1,556,185 2,762,113 Planning and Development Housing Economic Development Neighborhood Services Department 33,601,910 75,137,220 37,775,681 105,929,214 21,144,450 52,020,054 16,334,680 39,046,882 20,668,111 50,541,995 18,079,949 28,493,863 21,144,450 51,971,622 14,852,905 39,046,882 48,432 1,481,775 - 14,542,907 13,130,402 Total Community Development 252,444,025 128,546,066 117,783,918 127,015,859 1,530,207 96,385,575 36,069,133 8,341,758 62,545,832 10,968,395 62,339,505 4,133,240 841,581 62,173,306 20,068,531 5,716,423 40,706,807 5,279,302 42,164,760 2,062,185 507,524 61,651,020 21,223,582 5,203,400 43,445,188 8,147,443 41,971,836 2,229,531 911,389 62,056,625 20,068,531 5,715,673 27,740,515 42,125,916 2,062,185 507,524 116,681 750 12,966,292 5,279,302 38,844 - 281,625,019 178,678,838 184,783,389 160,276,969 18,401,869 Community Enrichment 6,478,870 2,446,236 588,077 4,044,174 651,070 5,221,230 253,521 91,861 6,285,722 2,073,011 477,544 3,976,421 1,017,965 3,773,709 251,640 89,334 19,775,039 17,945,346 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 February 29 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,458,195 9,590,496 8,826,459 798,760 132,793 39,806,703 $ 20,494,904 10,136,176 8,709,990 (1,994,025) 112,791 37,459,836 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 $ 186,458,923 94,210,969 72,389,048 10,101,684 658,618 $ 182,735,154 99,270,186 79,937,025 8,185,808 750,889 $ 117,976,267 46,223,440 63,803,091 9,543,846 658,618 $ 238,205,262 68,482,656 47,987,529 8,585,957 557,838 - 634,477,563 363,819,242 370,879,062 125,613,980 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 876,703 8,185,217 13,161,456 140,910 2,736,524 447,843 2,746,303 451,630 6,181,865 4,723,076 619,682 16,734,253 33,467 5,355,808 1,039,687 3,672,291 3,828 1,230,583 21,092,950 18,536,727 204,275 4,717,511 876,037 6,361,051 13,393,878 176,483 3,237,023 444,777 3,242,521 561,684 4,857,596 3,731,518 613,015 12,495,137 33,467 7,843,148 1,703,347 3,359,853 20,349,243 1,257,312 16,981,642 24,442,808 111,208 2,364,249 - 876,703 8,185,217 13,161,456 140,910 2,736,524 447,843 2,746,303 451,630 6,181,865 4,723,076 619,682 16,734,253 33,467 5,355,808 1,039,687 3,672,291 3,828 1,230,583 21,092,950 18,536,727 204,275 4,717,511 General Obligation Debt Service 109,588 1,023,152 1,645,182 17,614 342,066 55,980 343,288 56,454 772,734 590,384 77,460 2,091,376 4,184 669,476 129,961 431,277 153,823 2,636,618 2,317,091 25,534 582,466 109,505 795,132 1,674,235 22,060 404,627 55,597 405,315 70,211 607,199 466,440 76,627 1,561,487 4,184 980,394 212,918 1,591,339 628,656 2,122,705 3,055,356 13,901 1,171,065 14,075,708 16,028,953 Total Debt Service 138,718,984 112,892,589 128,436,997 - 112,892,589 15,523,134 19,350,869 Capital Improvement 493,021,254 158,921,287 147,646,827 - 158,921,287 $ 218,367,518 $ 215,183,577 Aviation Cultural Facilities Downtown Development Early Redemption Economic Development Fire Protection Freeway Mitigation Historic/Neighborhood Preservation Human Services Information Systems Libraries Maintenance Service Centers Mountain Preserves/Parks Municipal Administration Buildings Police Protection Public Housing Renovation Sanitary Sewers Secondary Property Tax Solid Waste Enterprise Bonds Storm Sewer Improvements Street Improvements Street Light Refinancing Water System 84,440,000 Contingencies Total Operating Budget $ 3,474,412,836 - 18 - $ 2,007,116,445 $ 1,991,764,293 $ 1,506,191,262 $ 500,925,183 Capital Expenditures and Encumbrances For the Month Ended February 29 2012 2011 $ $ 139,395 $ 6,360,415 4,020,175 578,763 1,043,220 209,959 14,840,452 1,115,806 298,054 2,543,732 76,469 60,130 1,578,398 255,425 27,813 2,009,016 146,267 33,464 236,642 220,270 40,904 843,285 543,593 335,675 1,013,805 36,002 302,318 623,414 2,713,846 35,224 907,381 1,232,258 331,547 4,292,739 4,270,126 8,849,244 50,465 12,060,966 1,917,727 12,623,880 34,212,803 $ 54,605,461 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,532,889 $ 281,818,518 5,012,138 7,590,533 7,313,472 2010-11 Actual Yearto-Date 3,881,347 109,017,812 14,111,141 3,832,486 5,708,377 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 21,042,377 4,608,409 7,590,533 170,493 $ 13,609,107 $ 382,222,294 3,598,529 17,445,800 7,345,580 260,776,141 403,729 7,142,979 Unencumbered Budget $ 7,271,218 153,994,151 5,131,376 10,126,448 11,884,328 Fire Protection Freeway Mitigation Historic Preservation Housing 21,140,399 2,759,359 63,604,234 9,819,392 339,291 22,797,435 4,871,181 1,230,112 24,795,141 86,883 48,568,331 15,086,299 21,140,399 2,672,476 15,035,903 9,819,392 339,291 7,711,136 11,321,007 2,420,068 40,806,799 Human Services Information Technology Libraries Neighborhood Services 2,857,262 14,253,403 7,697,854 12,085,676 273,475 4,795,757 2,021,860 1,422,290 4,479,402 6,224,387 4,228,714 2,458,087 10,256,533 1,454,500 3,966,861 3,127,336 1,143,103 588,435 2,857,262 3,996,870 6,243,354 8,118,815 273,475 1,668,421 878,757 833,855 2,583,787 9,457,646 5,675,994 10,663,386 Parks and Mountain Preserves Phoenix Convention Center Police Protection Public Transit 99,788,025 2,212,303 25,509,600 77,991,552 33,496,096 617,831 2,139,911 6,260,917 49,917,412 3,623,626 9,778,048 19,945,892 46,850,118 2,212,303 26,179,381 21,447,694 561,712 1,683,729 52,937,907 25,509,600 51,812,171 12,048,402 56,119 2,139,911 4,577,188 66,291,929 1,594,472 23,369,689 71,730,635 31,444,218 155,714,473 107,462,416 197,600,987 11,999,009 45,774,283 13,122,739 56,016,345 18,933,582 76,502,236 22,091,825 162,114,510 16,565,000 70,784,504 72,777,540 112,519,959 7,178,862 28,614,675 11,496,120 34,394,201 14,879,218 84,929,969 34,684,876 85,081,028 4,820,147 17,159,608 1,626,619 21,622,144 19,445,209 109,940,190 94,339,677 141,584,642 Solid Waste Disposal Street Transportation & Drainage Wastewater Water System Total Capital Improvement Program $ 1,319,796,832 $ 520,164,181 $ 547,745,318 - 19 - $ 493,021,254 $ 158,921,287 $ 826,775,578 $ 361,242,894 $ 799,632,651 Bonds Authorized and Sold As of February 29 (dollars in thousands) Authorized Sold Available 1988 Authorizations General Obligation Bonds Freeway Mitigation, Neighborhood Stabilization, and Slum and Blight Elimination Bonds Fully Issued $ Total General Obligation Bonds Revenue Bonds Bonds Fully Issued Total 1988 Authorizations 29,285 884,175 $ 28,285 884,175 $ 1,000 - 913,460 912,460 1,000 143,890 143,890 - 1,057,350 1,056,350 1,000 66,300 125,300 24,800 61,500 12,000 33,000 91,500 74,000 77,000 78,800 66,000 43,700 64,325 123,085 24,170 60,600 11,075 32,100 89,275 71,645 72,575 75,640 64,230 43,700 1,975 2,215 630 900 925 900 2,225 2,355 4,425 3,160 1,770 - 753,900 732,420 21,480 81,000 11,100 198,700 12,800 104,622 74,705 29,178 115,500 107,295 78,200 65,400 57,645 8,400 186,950 7,075 63,290 43,900 19,675 72,325 62,900 55,915 50,550 23,355 2,700 11,750 5,725 41,332 30,805 9,503 43,175 44,395 22,285 14,850 878,500 628,625 249,875 2001 Authorization General Obligation Bonds Education, Youth and Family Cultural Facilities Computer Technology Environmental Cleanup Fire Protection Historic Preservation Library Facilities Street Improvements Neighborhood Protection and Senior Centers Parks, Open Space, and Recreational Facilities Police Protection Storm Sewer and Flood Protection Bonds Fully Issued Total 2001 Authorizations 2006 Authorization General Obligation Bonds Affordable Housing and Neighborhood Revitalization Computer Technology Education and Health Science Facilities Environmental Cleanup Family, Senior, and Youth Cultural Facilities Fire Protection Library Facilities and Improvements Parks, Open Space, and Recreational Facilities Police Protection Street Improvements Storm Sewer and Flood Protection Total 2006 Authorizations Total Bond Program $ - 20 - 2,689,750 $ 2,417,395 $ 272,355