May 2014 Monthly Financial Report PREPARED BY Financial Accounting & Reporting Division City of Phoenix Monthly Financial Report May 2014 Table of Contents Expenditures by Programs Page Performance Status General Fund Expenditures General Fund Total Expenditures 1 Better than Expected Report Navigation General Government 1 Better than Expected Click on either the schedule name or the Criminal Justice 2 Better than Expected performance status in the table of contents to Public Safety 2 Better than Expected be taken directly to that page of the report. Transportation 3 Better than Expected Community Development 3 Better than Expected From any page of the report, click on the Community Enrichment 4 Better than Expected City of Phoenix Bird Emblem to return to the Environmental Services 4 Better than Expected Table of Contents Citywide Total Operating Expenditures 5 Better than Expected General Government 5 Better than Expected Criminal Justice 6 Better than Expected Citywide Expenditures Performance Status Public Safety 6 Better than Expected Better than Expected - Positive variance of Transportation 7 Better than Expected greater than 1% actual vs budget. Community Development 7 Better than Expected Expected - Actual vs budget variance within 1% Community Enrichment 8 Better than Expected positive or negative. Environmental Services 8 Better than Expected Monitor and Consider Taking Action - Negative General Obligation Debt Service 9 Expected variance greater than 1% actual vs budget. Capital Expenditures CIP-General Government 10 Corrective Action Taken - Negative variance CIP-Aviation 10 greater than 1% actual vs budget, however the CIP-Phoenix Convention Center 11 City has taken action to address the negative CIP-Solid Waste Disposal 11 variance. CIP-Wastewater 12 CIP-Water System 12 Revenues by Source General Fund Total Operating Revenue Page 13 Performance Status Corrective Action Taken Property Tax 14 Better than Expected Local Sales Tax 15 Corrective Action Taken State Sales Tax 16 Expected Vehicle License Tax 17 Expected Regional Transit Revenues 18 Better than Expected Aviation 19 Better than Expected Water System 20 Monitor & Consider Corrective Action Wastewater 21 Expected Financial Schedules General Fund Revenue Page 22 General Fund Expenditures 23 Citywide Operating Revenue 24 Citywide Operating Expenditures 25 Citywide Operating Revenue by Source 26 Citywide Operating Expenditures by Program 30 Capital Expenditures and Encumbrances 33 Bonds Authorized and Sold 34 Appendix A - Additional Detail for Revenues General Fund Expenditures Expenditures from the City's General Fund for core functions such as Police, Fire, Parks, Streets and Social Services as well as administrative functions such as Mayor and Council, City Manager, Finance, and Human Resources. This does not include any expenditures from dedicated revenue streams such as grants, bonds, specifically dedicated taxes, and enterprise revenues. May General Fund YTD Expenditures (Dollars in Thousands) Refer to detailed financial schedules pages 22 thru 34 Total General Fund Expenditures 09-10 10-11 11-12 12-13 13-14 May YTD Annual % of Annual Expenditures Expenditures * Expenditures 911,796 994,322 91.7% 870,452 954,795 91.2% 885,079 995,771 88.9% 951,725 1,038,092 91.7% 950,798 1,089,502 87.3% * - For prior years-total actual expenditures, for current year-total approved budget net of adjustment for contingencies. Better than Expected TotalGovernment General Fund General $1,200,000 $1,200,000 May YTD May YTD Expenditures Expenditures $1,000,000 $1,000,000 $800,000 $800,000 $600,000 $600,000 $400,000 $400,000 $200,000 $200,000 $0 $0 Annual Annual Expenditures * Expenditures * 09-10 09-10 10-11 10-11 11-12 11-12 12-13 12-13 13-14 13-14 In order to have a better comparison to prior year actuals, contingencies will only be included in the annual budget to the extent that they have been spent. The general fund provides for core City functions that are not provided by dedicated revenue streams. It does not include services provided by dedicated taxes, grants, bond proceeds or enterprise fund revenues. For fiscal year 2013-14 general fund expenditures were budgeted to increase 5.0% over fiscal year 2012-13 actuals. Through May 2014 general fund expenditures are performing better than expected as year to date expenditures are 0.1% lower than through May 2013. The lower than expected expenditures are the result of the City's efforts to reduce costs due to the lower than expected general fund revenues. General Government 09-10 10-11 11-12 12-13 13-14 May YTD Annual % of Annual Expenditures Expenditures * Expenditures 69,442 77,130 90.0% 62,891 70,650 89.0% 86,109 98,577 87.4% 93,493 102,211 91.5% 94,146 106,432 88.5% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected Criminal Justice General Government $120,000 $120,000 $100,000 $100,000 $80,000 $80,000 $60,000 $60,000 $40,000 $40,000 May YTD Expenditures May YTD Expenditures Annual Expenditures * Annual Expenditures * $20,000 $20,000 $0$0 09-10 09-10 10-11 10-11 11-12 12-13 12-13 13-14 13-14 11-12 General government expenditures include costs for administrative and internal service functions such as the Mayor and City Council, City Manager's Office, City Auditor, Finance, Budget and Research, and Human Resources. General fund general government expenditures are better than expected through May 2014 with a 0.7% increase from the same period in the prior year. The fiscal year 2013-14 budget includes a 4.1% increase over fiscal year 2012-13 actuals. The better than expected performance reflects actions taken by departments to reduce costs due to the lower than expected general fund revenues. -1- May General Fund YTD Expenditures (Dollars in Thousands) Refer to detailed financial schedules pages 22 thru 34 Criminal Justice 09-10 10-11 11-12 12-13 13-14 Criminal Justice Public Safety May YTD Annual % of Annual Expenditures Expenditures * Expenditures 32,489 35,028 92.8% 30,528 33,324 91.6% 29,755 33,542 88.7% 30,711 33,453 91.8% 29,846 34,298 87.0% * - For prior years-total actual expenditures, for current year-total approved budget $40,000 $36,000 $35,000 $35,000 $34,000 $30,000 $33,000 $25,000 $32,000 $31,000 $20,000 $30,000 $15,000 $29,000 $28,000 $10,000 $27,000 $5,000 May YTD Expenditures May YTD Expenditures Annual Expenditures * Annual Expenditures * 09-10 10-11 11-12 12-13 13-14 $0 Better than Expected 09-10 10-11 11-12 12-13 13-14 Criminal justice expenditures include costs for municipal courts and public defenders. General fund criminal justice expenditures are better than expected through May 2014 with a 2.8% decrease from the same period in the prior year. The fiscal year 2013-14 budget includes a 2.5% increase over fiscal year 2012-13 actuals. The better than expected performance reflects actions taken by departments to reduce costs due to the lower than expected general fund revenues. Public Safety May YTD % of Annual Annual Expenditures Expenditures * Expenditures 09-10 10-11 11-12 12-13 13-14 605,462 587,992 581,216 628,313 638,481 658,886 639,691 647,049 684,609 713,122 91.9% 91.9% 89.8% 91.8% 89.5% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected Transportation Public Safety $800,000 $800,000 $700,000 $700,000 $600,000 $600,000 $500,000 $400,000 $500,000 $300,000 $400,000 $200,000 $300,000 $100,000 $200,000 $0 $100,000 09-10 10-11 11-12 12-13 13-14 $0 09-10 10-11 11-12 12-13 13-14 May YTD Expenditures May YTD Expenditures Annual Expenditures * Annual Expenditures * Public safety expenditures include costs for police and fire services. General fund public safety expenditures are better than expected through May 2014 with a 1.6% increase over the same period in the prior year. The fiscal year 2013-14 budget includes a 4.2% increase over fiscal year 2012-13 actuals. The better than expected performance reflects actions taken by departments to reduce costs due to the lower than expected general fund revenues. - 2- May General Fund YTD Expenditures (Dollars in Thousands) Transportation May YTD % of Annual Annual Expenditures Expenditures * Expenditures 09-10 10-11 11-12 12-13 13-14 36,933 35,671 33,598 34,946 27,648 39,570 38,711 39,161 38,161 41,617 93.3% 92.1% 85.8% 91.6% 66.4% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected Refer to detailed financial schedules pages 22 thru 34 Community Development Transportation $45,000 $40,000 $35,000 $35,000 $30,000 $30,000 $25,000 $25,000 $20,000 $20,000 $15,000 $15,000 $10,000 $10,000 $5,000 $5,000 $0 $0 May YTD Expenditures May YTD Expenditures Annual Annual Expenditures * Expenditures * 09-10 09-10 10-11 10-11 11-12 11-12 12-13 12-13 13-14 13-14 Transportation expenditures include costs for public transit and street maintenance and repair. General fund transportation expenditures are better than expected through May 2014 with a 20.9% decrease over the same period in the prior year. The fiscal year 2013-14 budget includes a 9.1% increase over fiscal year 2012-13 actuals. As part of the plan to reduce the food tax in January 2014, Public Transit used savings achieved by refunding transit bonds to reduce the amount of support needed from the General Fund resulting in the significant decrease in transportation expenses from fiscal year 2012-13 to fiscal year 2013-14. Community Development Community Enrichment Community Development 09-10 10-11 11-12 12-13 13-14 May YTD Annual % of Annual Expenditures Expenditures * Expenditures 19,623 21,352 91.9% 17,789 19,458 91.4% 17,316 19,393 89.3% 18,229 19,927 91.5% 18,522 22,551 82.1% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected $25,000 $25,000 May MayYTD YTD Expenditures Expenditures $20,000 $20,000 $15,000 $15,000 $10,000 $10,000 Annual Annual Expenditures * Expenditures * $5,000 $5,000 $0 $0 09-10 10-11 09-10 10-11 11-12 11-12 12-13 12-13 13-14 13-14 Community development expenditures include costs for economic development and neighborhood services. General fund community development expenditures are better than expected through May 2014 with a 1.6% increase over the same period in the prior year. The fiscal year 2013-14 budget includes a 13.2% increase over fiscal year 2012-13 actuals. The better than expected performance reflects actions taken by departments to reduce costs due to the lower than expected general fund revenues. -3- May General Fund YTD Expenditures (Dollars in Thousands) Refer to detailed financial schedules pages 22 thru 34 Community Enrichment 09-10 10-11 11-12 12-13 13-14 May YTD Annual % of Annual Expenditures Expenditures * Expenditures 132,326 145,893 90.7% 124,254 137,793 90.2% 121,979 140,026 87.1% 128,996 141,209 91.4% 129,122 151,502 85.2% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected Environmental Services Community Enrichment $160,000 $160,000 $140,000 $140,000 $120,000 $120,000 $100,000 $100,000 $80,000 $80,000 $60,000 $60,000 $40,000 $40,000 $20,000 $20,000 $0 $0 09-10 10-11 09-10 10-11 MayYTD YTD May Expenditures Expenditures Annual Expenditures * Annual Expenditures * 11-12 11-12 12-13 12-13 13-14 13-14 Community enrichment expenditures include costs for parks, recreational activities, senior centers and community centers. General fund community enrichment expenditures are better than expected through May 2014 with a 0.1% increase over the same period in the prior year. The fiscal year 2013-14 budget includes a 7.3% increase over fiscal year 2012-13 actuals. The better than expected performance reflects actions taken by departments to reduce costs due to the lower than expected general fund revenues. Environmental Services 09-10 10-11 11-12 12-13 13-14 May YTD Annual % of Annual Expenditures Expenditures * Expenditures 14,949 15,767 94.8% 10,799 14,046 76.9% 13,003 15,723 82.7% 14,390 15,353 93.7% 11,726 17,538 66.9% * - For prior years-total actual expenditures, for current year-total approved budget Environmental Total GeneralServices Fund $20,000 $18,000 $16,000 $14,000 $12,000 $10,000 $8,000 $6,000 $4,000 $2,000 $0 Better than Expected May YTD Expenditures Annual Expenditures * 09-10 10-11 11-12 12-13 13-14 Environmental service expenditures include costs for maintaining and operating city facilities. General Fund environmental services expenditures are better than expected through May 2014 with an 18.5% decrease over the same period in the prior year. The fiscal year 2013-14 budget includes a 14.2% increase over fiscal year 2012-13 actuals. Lower fuel costs account for the majority of the decrease from the prior year. The better than expected performance also reflects actions taken by departments to reduce costs due to the lower than expected general fund revenues. -4- Citywide Expenditures All expenditures of the City including those for enterprise functions and those related to dedicated revenue streams. Expenditures are reported in total and by program. May Citywide YTD Expenditures (Dollars in Thousands) Refer to detailed financial schedules pages 22 thru 34 Total Citywide Operating 09-10 10-11 11-12 12-13 13-14 May YTD Annual % of Annual Expenditures Expenditures * Expenditures 2,637,247 2,923,454 90.2% 2,708,038 3,026,005 89.5% 2,667,134 2,985,410 89.3% 2,833,957 3,123,865 90.7% 2,744,885 3,465,334 79.2% * - For prior years-total actual expenditures, for current year-total approved budget net of adjustments for contingencies and use of the early redemption fund. Total Citywide General Government $4,000,000 $4,000,000 $3,500,000 $3,500,000 $3,000,000 $3,000,000 $2,500,000 $2,500,000 $2,000,000 $2,000,000 $1,500,000 $1,500,000 $1,000,000 $1,000,000 $500,000 $500,000 $0 $0 Better than Expected May YTD May YTD Expenditures Expenditures Annual Annual Expenditures * Expenditures * 09-10 09-10 10-11 10-11 11-12 11-12 12-13 12-13 13-14 13-14 In order to have a better comparison to prior year actuals, contingencies will only be included in the annual budget to the extent that they have been spent. Additionally, per the note on General Obligation Debt Service Expenditures (Page 9), the credit for the use of the early redemption fund will not be included in the budgetary total. After these adjustments, the budget for fiscal year 2013-14 anticipated an increase 10.9% in total operating expenditures. Actual expenditures are better than expected with a year to date decrease of 3.1% from the prior year through May 2014. General Government 09-10 10-11 11-12 12-13 13-14 May YTD Annual % of Annual Expenditures Expenditures * Expenditures 76,271 84,752 90.0% 70,477 78,047 90.3% 96,067 109,658 87.6% 104,746 114,015 91.9% 105,299 120,281 87.5% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected Criminal Justice General Government $140,000 $140,000 $120,000 $120,000 $100,000 $100,000 $80,000 $80,000 $60,000 $60,000 $40,000 $40,000 May YTD Expenditures May YTD Expenditures Annual Expenditures * Annual Expenditures * $20,000 $20,000 $0 09-10 10-11 11-12 11-12 12-13 12-13 13-14 13-14 General government expenditures include costs for administrative and internal service functions such as the Mayor and City Council, City Manager's Office, City Auditor, Finance, Budget and Research, and Human Resources. Citywide general government expenditures are better than expected with a year to date increase of 0.5% through May 2014 over the prior May. This is lower than the budgeted increase of 5.5% for fiscal year 2013-14 over prior year actuals. -5- May Citywide YTD Expenditures (Dollars in Thousands) Refer to detailed financial schedules pages 22 thru 34 Criminal Justice 09-10 10-11 11-12 12-13 13-14 Public Safety Criminal Justice May YTD Annual % of Annual Expenditures Expenditures * Expenditures 39,357 42,633 92.3% 37,060 36,958 100.3% 32,286 36,305 88.9% 37,914 41,290 91.8% 37,232 46,871 79.4% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected $50,000 $200,000 $45,000 $40,000 $35,000 $30,000 $25,000 $20,000 $15,000 $10,000 $0 $5,000 09-10 10-11 11-12 12-13 13-14 $0 09-10 10-11 11-12 12-13 13-14 May YTD Expenditures May YTD Expenditures Annual Annual Expenditures * Expenditures * Criminal Justice expenditures include costs of the Municipal Court and the Public Defender’s office. Citywide criminal justice expenditures are better than expected with a year to date decrease at May 2014 of 1.8% from the prior April. The budgeted increase for fiscal year 2013-14 over prior year actuals is 13.5%. Public Safety Transportation Public Safety May YTD % of Annual Annual Expenditures Expenditures * Expenditures 09-10 10-11 11-12 12-13 13-14 747,799 731,788 719,987 770,476 768,394 817,192 792,002 803,367 842,387 875,841 91.5% 92.4% 89.6% 91.5% 87.7% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected $1,000,000 $1,000,000 $900,000 $800,000 $800,000 $600,000 $700,000 $600,000 $400,000 $500,000 $400,000 $200,000 $300,000 $200,000 $0 $100,000 09-10 10-11 11-12 12-13 13-14 $0 09-10 10-11 11-12 12-13 13-14 May YTD Expenditures May YTD Expenditures Annual Expenditures * Annual Expenditures * Public Safety expenditures include costs of Police, Fire and Emergency Management. Citywide public safety expenditures are better than expected with a year to date decrease at May 2014 of 0.3% from the prior April. The budgeted increase for fiscal year 2013-14 over prior year actuals is 4.0%. -6- May Citywide YTD Expenditures (Dollars in Thousands) Transportation % of Annual May YTD Annual Expenditures Expenditures * Expenditures 09-10 10-11 11-12 12-13 13-14 519,637 523,646 537,067 545,665 538,073 577,083 567,830 584,429 582,381 636,889 90.0% 92.2% 91.9% 93.7% 84.5% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected Refer to detailed financial schedules pages 22 thru 34 Transportation Community Development $700,000 $600,000 $500,000 May YTD Expenditures May YTD Expenditures $400,000 $400,000 $300,000 $300,000 $200,000 $200,000 $100,000 $100,000 $0 $0 Annual Annual Expenditures * Expenditures * 09-10 09-10 10-11 10-11 11-12 11-12 12-13 12-13 13-14 13-14 Transportation expenditures include costs for Street lighting, maintenance and repair; Aviation and Public Transit. Citywide transportation expenditures are better than expected with a year to date decrease at May 2014 of 1.4% from the prior May. The budgeted increase for fiscal year 2013-14 over prior year actuals is 9.4%. Community Development 09-10 10-11 11-12 12-13 13-14 May YTD Annual % of Annual Expenditures Expenditures * Expenditures 153,134 170,213 90.0% 160,898 176,114 91.4% 171,223 192,133 89.1% 193,293 209,403 92.3% 178,348 228,688 78.0% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected CommunityDevelopment Enrichment Community $250,000 $250,000 MayYTD YTD May Expenditures Expenditures $200,000 $200,000 $150,000 $150,000 $100,000 $100,000 $50,000 $50,000 $0 $0 09-10 09-10 Annual Expenditures * Annual Expenditures * 10-11 10-11 11-12 11-12 12-13 12-13 13-14 13-14 Community Development expenditures include costs for Neighborhood Services, Housing, Planning and Economic Development. Citywide community development expenditures are better than expected with a year to date decrease at May 2014 of 7.7% from the prior May. These expenditures were budgeted to increase 9.2% for fiscal year 2013-14 over prior year actuals. The decrease is primarily due to the culmination of the ARRA grants leading to lower spending levels in Neighborhood Services. -7- May Citywide YTD Expenditures (Dollars in Thousands) Refer to detailed financial schedules pages 22 thru 34 Community Enrichment 09-10 10-11 11-12 12-13 13-14 May YTD Annual % of Annual Expenditures Expenditures * Expenditures 257,339 283,569 90.8% 252,752 274,824 92.0% 239,944 272,353 88.1% 249,731 273,110 91.4% 248,395 288,202 86.2% * - For prior years-total actual expenditures, for current year-total approved budget Environmental Services Community Enrichment $350,000 $350,000 $300,000 $300,000 $250,000 $250,000 $200,000 $200,000 $150,000 $150,000 $100,000 $100,000 $50,000 $50,000 $0 $0 Better than Expected MayYTD YTD May Expenditures Expenditures Annual Expenditures * Annual Expenditures * 09-10 09-10 10-11 10-11 11-12 11-12 12-13 12-13 13-14 13-14 Community Enrichment expenditures include costs for Parks, Libraries, the Convention Center, Senior Centers and Community Centers. Citywide community enrichment expenditures are better than expected with a year to date decrease at May 2014 of 0.5% from the prior May. The budgeted increase for fiscal year 2013-14 over prior year actuals is 5.5%. Environmental Services 09-10 10-11 11-12 12-13 13-14 May YTD Annual % of Annual Expenditures Expenditures * Expenditures 524,079 579,689 90.4% 524,957 572,693 91.7% 489,831 549,628 89.1% 515,850 564,051 91.5% 525,172 627,459 83.7% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected General Obligation Services Debt Service Environmental $700,000 $700,000 $600,000 $600,000 MayYTD YTD May Expenditures Expenditures $500,000 $500,000 $400,000 $400,000 $300,000 $300,000 $200,000 $200,000 $100,000 $100,000 $0 $009-10 10-11 11-12 12-13 09-10 10-11 11-12 12-13 Annual Expenditures * Annual Expenditures * 13-14 13-14 Environmental Services expenditures include costs for Water, Wastewater and Solid Waste services as well as the care and maintenance of City facilities. Citywide environmental services expenditures are better than expected with a year to date increase at May 2014 of 1.8% over the prior May. The budgeted increase for fiscal year 2013-14 over prior year actuals is 11.2%. -8- May Citywide YTD Expenditures (Dollars in Thousands) Refer to detailed financial schedules pages 22 thru 34 General Obligation Debt Service 09-10 10-11 11-12 12-13 13-14 May YTD Annual % of Annual Expenditures Expenditures * Expenditures 153,045 168,779 90.7% 176,524 196,779 89.7% 155,120 157,298 98.6% 125,823 137,208 91.7% 92,383 100,790 91.7% * - For prior years-total actual expenditures, for current year-total approved budget net of credit for early redemption fund resources Expected General Obligation Debt Service Total Citywide $250,000 $250,000 MayYTD YTD May Expenditures Expenditures $200,000 $200,000 $150,000 $150,000 $100,000 $100,000 Annual Expenditures * Annual Expenditures * $50,000 $50,000 $0 $009-10 10-11 11-12 12-13 09-10 10-11 11-12 12-13 13-14 13-14 In order to better compare the current year budget to prior year actuals, the budget for General Obligation Debt Service expenditures has been increased by $48.3 million over the amount recorded on the accompanying statements. The approved budget includes a credit for $48.3 million to be taken from the early redemption fund which is not included in available resources for budget purposes. However, the expenditures are measured at full value for the actuals. Using the adjusted budget figure, general obligation debt service expenditures are performing as expected. Budgeted expenditures for fiscal year 2013-14 are 26.5% lower than actual expenditures for the prior fiscal year. Through May 2014, year to date expenditures are 26.6% lower than the prior May. -9- Capital Expenditures Expenditures for capital projects. These expenditures may come from designated capital funds such as bond proceeds or grants, or they may come from operating funds and be reported in both the operating and capital sections. Because of the long-term view used in capital budgeting and the volatility of capital spending, no performance status is provided unless capital spending exceeds the capital budget. Capital Expenditures (Dollars in Thousands) General Gov't Refer to detailed financial schedules pages 22 - 34 09-10 10-11 11-12 12-13 13-14 (Budget) 13-14 (YTD) $ 371,045 $ 388,422 $ 232,848 $ 320,599 $ 521,760 $ 235,244 Discussion: General Gov't Major Projects in fiscal year 2013-14 include technology acquisitions for E-Procurement and Regional Wireless Communications ($21 million), street projects (Avenida Rio Salado-$27 million, Black Mountain Blvd ramps to SR51$9 million, Pinnacle Peak Rd-$10 million, and Greenway Rd/Cave Creek Wash Bridge-$7 million), and Police PACE Upgrade/Replacement ($12 million). 13-14 (YTD) 13-14 (Budget) 12-13 11-12 Major Projects in fiscal year 2012-13 included Bus Acquisitions ($60 million), Sonoran Preserve Land Acquisitions ($25 million), Ballet Arizona and Arizona Opera facilities ($8 million), and the purchase of fire safety apparatus ($6 million). 10-11 09-10 $0 Aviation $200,000 $400,000 09-10 10-11 11-12 12-13 13-14 (Budget) 13-14 (YTD) $ 566,779 $ 157,884 $ 332,920 $ 168,639 $ 320,348 $ 153,577 $600,000 Discussion: Aviation In addition to the ongoing capital costs needed to maintain the property and infrastructure of the Aviation Department, in fiscal year 2009-10 the department spent $440 million on stage 1 of the PHX Sky Train and in fiscal year 2011-12 the department spent $190 million on stage 1a of the PHX Sky Train. In fiscal year 2013-14 the department has spent $19 million on Terminal Development Concept Design. 13-14 (YTD) 13-14 (Budget) 12-13 11-12 10-11 09-10 $0 $200,000 $400,000 $600,000 - 10 - Capital Expenditures (Dollars in Thousands) 09-10 Phx Convention Ctr 10-11 12,109 4,493 Refer to detailed financial schedules pages 22 - 34 11-12 12-13 1,644 Discussion: 21,830 13-14 (Budget) 26,370 13-14 (YTD) 21,431 Phx Convention Ctr Beginning in fiscal year 2012-13, Phoenix Convention Center began making debt service payments on the state funded portion of the 2005 Convention Center bonds. The payments from the state are accumulated in a capital fund and the subsequent debt service payments are then made from the capital fund within the capital budget. For fiscal year 2012-13 that payment was $20 million and through May 2014 the year to date payments were $19 million. 13-14 (YTD) 13-14 (Budget) 12-13 11-12 10-11 09-10 $0 09-10 Solid Waste 10-11 13,326 22,640 11-12 $10,000 12-13 15,512 8,605 13-14 (Budget) 23,656 $20,000 $30,000 13-14 (YTD) 684 Discussion: Solid Waste Fiscal years 2010-11, 2011-12 and 2012-13 included about $5-$6 million per year in spending on the SR85 landfill. Additionally, in fiscal years 2009-10, 2010-11 and 2011-12 renovation of the 27th Ave Transfer Station accounted for a total of $24 million in spending. Through May 2014 there have not been any major projects at any of the landfills or transfer stations for this fiscal year. 13-14 (YTD) 13-14 (Budget) 12-13 11-12 10-11 09-10 $0 $10,000 $20,000 $30,000 - 11 - Capital Expenditures (Dollars in Thousands) 09-10 Wastewater $ 43,016 Refer to detailed financial schedules pages 22 - 34 10-11 $ 41,347 11-12 $ 66,342 12-13 13-14 (Budget) $ 109,914 $ 121,032 Discussion: 13-14 (YTD) $ 47,641 Wastewater Capital funds were used to pay $25 million, $50 million and $25 million of commercial paper in fiscal years 201112, 2012-13 and 2013-14 respectively. In fiscal year 1213 the department spent $21 million on the Broadway Road Parallel Sewer. 13-14 (YTD) 13-14 (Budget) 12-13 11-12 10-11 09-10 $0 Water System 09-10 10-11 $ 138,146 $ 246,177 11-12 $ 95,990 $50,000 12-13 13-14 (Budget) $ 110,333 $ 201,694 $100,000 $150,000 13-14 (YTD) $ 86,959 Discussion: Water System Major Projects in fiscal year 2009-10 included Val Vista GAC Contactors ($25 million) and Automatic Meter Reading System ($7 million). 13-14 (YTD) 13-14 (Budget) Major Projects in fiscal year 2010-11 included Val Vista GAC Contactors ($51 million), Rehabilitation of the 42nd St/Baseline Reservoir ($19 million), DBP mitigation at various water treatment plants ($27 million), and Residential Pressure Improvements ($41 million). 12-13 11-12 10-11 Additionally, the Water department has spent about $100 million per year to maintain the infrastructure for the water system. 09-10 $0 $100,000 $200,000 $300,000 - 12 - Revenues Sources of funds for the operations of the City including local taxes, state shared taxes, user fees and charges, and grants. General Fund Total Operating Revenue (Dollars in Thousands) Refer to detailed financial schedules pages 22 thru 34 General Fund Revenues $1,200,000 $1,000,000 May YTD Actuals $800,000 $600,000 $400,000 Annual Revenues* $200,000 $0 09-10 09-10 10-11 11-12 12-13 13-14 May YTD Actuals 852,705 875,951 844,408 885,412 930,638 Annual Revenues* 944,096 962,689 948,384 980,945 1,051,789 10-11 11-12 12-13 13-14 % of Annual Revenues 90.3% 91.0% 89.0% 90.3% 88.5% * - For prior years - total actual revenues, for current year - total approved budget Corrective Action Taken Fiscal Year 2013-14 general fund operating revenues were budgeted to increase 7.2% over prior year actuals. Actual year over year revenue growth through May 2014 is 5.1%. The Budget and Research Department is monitoring the shortfall in revenues and has worked with departments to reduce expenditures so that expenditures will not exceed available resources. Specific revenue sources are discussed on the following pages. - 13 - Property Taxes (Dollars in Thousands) Refer to detailed financial schedules pages 22 thru 34 Property Taxes Primary & Secondary 350,000 300,000 Secondary 250,000 200,000 196,673 149,019 94,436 150,000 62,012 35,443 31,257 Primary 100,000 50,000 121,366 130,913 128,054 132,101 127,628 142,849 09-10 10-11 11-12 12-13 13-14 YTD 13-14 budget - FY 09-10 10-11 11-12 12-13 13-14 YTD 13-14 budget Total 318,039 279,932 222,488 194,112 158,886 178,292 July (2,743) (3,017) (2,553) (1,733) (1,260) (1,869) Aug 1,842 1,118 1,059 1,349 971 903 Sept 908 1,279 1,189 904 867 863 Oct 12,540 18,792 13,656 11,888 11,107 11,349 Nov 92,245 85,251 55,555 54,091 46,645 49,888 Dec 52,851 34,444 40,845 31,075 32,028 27,226 Jan 9,954 9,642 7,689 7,015 7,180 6,232 Feb 6,193 5,599 5,685 4,743 3,818 4,102 Mar 11,325 10,676 8,871 6,670 5,668 6,711 Apr 14,830 14,532 11,013 8,323 7,300 8,669 May 85,484 68,087 35,952 44,111 44,562 37,922 June 32,610 33,529 43,527 25,676 26,296 Note: Monthly budget amount for 13-14 is the average % of last 3 years of the total budget amount Better than Expected Because property taxes are primarily collected in November, December, May and June, a monthly breakdown of the revenues is not particularly useful, therefore property tax revenues are presented with an annual perspective. Property tax revenues for fiscal year 2013-14 are better than expected through May 2014 showing a 5.6% decline from prior year actuals as opposed to the 8.1% decline anticipated in the budget. Total property tax revenues have been decreasing each year since fiscal year 2009-10 and since the assessments for property taxes lag market changes by about two years, the revenues have not yet benefitted from the market recovery. - 14 - Local Sales Tax (Dollars in Thousands) Refer to detailed financial schedules pages 22 thru 34 Local Sales Tax Budget vs Actual 45,000 40,000 35,000 30,000 25,000 13-14 Actuals 20,000 13-14 budget 15,000 10,000 5,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June Corrective Action Taken Local sales tax revenues through May 2014 are 4.2% below budget for that period. The Budget and Research Department has adjusted their revenue estimates to account for the budget shortfall. The new revenue estimates are being used by departments as they adjust expenditure levels so that expenditures do not exceed available resources. Local Sales Tax 3 Year Trend 45,000 40,000 35,000 30,000 25,000 11-12 Actuals 20,000 12-13 Actuals 15,000 13-14 Actuals 10,000 5,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June As you can see from the chart above, local sales tax revenues have been increasing over the last three years. Through May, year to date revenues for fiscal year 2013-14 are 2.9% higher than fiscal year 2012-13. The current year was bolstered by a strong holiday season reflected in a 9.8% increase over the prior year for the month of January. In the four months (February through May) reflecting the reduction of the food tax from 2% to 1% the City has experienced a 0.6% year over year reduction in local sales tax revenues.. Click Here for Additional Information - 15 - State Sales Tax (Dollars in Thousands) Refer to detailed financial schedules pages 22 thru 34 State Sales Tax Budget vs Actual 14,000 12,000 10,000 13-14 Actuals 8,000 13-14 budget 6,000 4,000 2,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June Expected State shared sales tax revenues are performing as expected through May 2014 at 0.3% below the budget estimates for the same period. State Sales Tax 3 Year Trend 14,000 12,000 10,000 8,000 11-12 Actuals 12-13 Actuals 6,000 13-14 Actuals 4,000 2,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June Year to date state shared sales tax revenues have increased 7.0% at May 2014 over May 2013. The growth rate is over 50% greater than the 4.1% growth rate from fiscal year 2011/12 to fiscal year 2012-13 reflecting continued economic recovery. Click Here for Additional Information - 16 - Vehicle License Tax (Dollars in Thousands) Refer to detailed financial schedules pages 22 thru 34 Vehicle License Tax Budget vs Actual 6,000 5,000 4,000 13-14 Actuals 3,000 Budget 13-14 2,000 1,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June Expected State shared vehicle license tax revenues are performing as expected at 0.4% higher than budgeted through May 2014. Vehicle License Tax 3 Year Trend 6,000 5,000 4,000 11-12 Actuals 3,000 12-13 Actuals 2,000 13-14 Actuals 1,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June State shared vehicle license tax revenues through May 2014 have increased 7.8% over the same period in the prior year. This follows a 4.2% increase for fiscal year 2012-13 over fiscal year 2011-12 which reversed a trend of declining revenues from fiscal year 2009-10 through fiscal year 2011-12. Click Here for Additional Information - 17 - Regional Transit Revenues (Dollars in Thousands) Refer to detailed financial schedules pages 22 thru 34 Regional Transit Revenues Budget vs Actual 12,000 10,000 13-14 Actuals 8,000 Budget 13-14 6,000 4,000 2,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June Better than Expected Regional transit revenues are generated through agreements with other communities for transit services. Through May 2014, actuals were better than expected with 20.5% greater revenues than budget expectations for the same time period. Regional Transit Revenues 3 Year Trend 12,000 10,000 8,000 11-12 Actuals 6,000 4,000 12-13 Actuals 2,000 13-14 Actuals July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June (2,000) The City is reimbursed for bus route operations which tend to be stable from year to year. The City is also reimbursed for bus acquisitions which can result in large year over year variances. The city recorded revenues related to bus acquisitions of $5.5 million in February and $5.8 million in May. Additionally, the City received payments from Valley Metro Rail of $3.3 million related to the Northwest Extension funding agreement. These revenues account for the majority of the 78.2% increase in regional transit revenues through May 2014 as compared to May 2013. Click Here for Additional Information - 18 - Aviation Revenues (Dollars in Thousands) Refer to detailed financial schedules pages 22 thru 34 Aviation Revenues Budget vs Actual 35,000 30,000 25,000 13-14 Actuals 20,000 Budget 13-14 15,000 10,000 5,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June Better than Expected Aviation revenues through May 2014 were better than expected at 7.1% higher than budget expectations for the same period. Concession revenues related to commercial tenants in the terminals and airline joint use spaces are well ahead of budget projections through May. Aviation Revenues 3 Year Trend 40,000 35,000 30,000 25,000 11-12 Actuals 20,000 12-13 Actuals 15,000 10,000 13-14 Actuals 5,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June In fiscal year 2013-14 Customer Facility Charge revenues were moved from operating to non-operating to better reflect their required use for capital projects and debt service. Through May 2013, those revenues amounted to $36.5 million. Not counting the Customer Facility Charge, Aviation revenues through May 2014 increased $20.0 million (7.1%) over the same period in the prior year. This growth rate in revenues nearly triples the 2.5% growth rate for fiscal year 2012-13 over fiscal year 2011-12.. Click Here for Additional Information - 19 - Water System Revenues (Dollars in Thousands) Refer to detailed financial schedules pages 22 thru 34 Water System Revenues Budget vs Actual 60,000 50,000 40,000 13-14 Actuals Budget 13-14 30,000 20,000 10,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June Monitor & Consider Corrective Action Water revenues are 1.8% below budget projections through May 2014. These revenues are being monitored, however, at this time, no specific actions are being taken as Water’s available resources are enough to meet expenditure requirements. Water System Revenues 3 Year Trend 90,000 80,000 70,000 60,000 11-12 Actuals 50,000 40,000 12-13 Actuals 30,000 13-14 Actuals 20,000 10,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June In July 2012 Water sold land in McMullen Valley for $29.7 million. Not including those revenues in fiscal year 2012-13, water revenues through May 2014 are 0.5% lower than the same period in the prior year. This follows four years of revenue growth. Click Here for Additional Information - 20 - Wastewater Revenues (Dollars in Thousands) Refer to detailed financial schedules pages 22 thru 34 Wastewater Revenues Budget vs Actual 25,000 20,000 15,000 13-14 Actuals Budget 13-14 10,000 5,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June Expected Wastewater revenues through May 2014 are performing as expected at 0.1% lower than budget expectations for the same time frame. Wastewater Revenues 3 Year Trend 30,000 25,000 20,000 11-12 Actuals 15,000 12-13 Actuals 10,000 13-14 Actuals 5,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June Wastewater revenues are $5.5 million (2.7%) less through May 2014 than through the prior May. Wastewater rates decreased effective July 1, 2012 leading to a decrease in revenues for fiscal year 2012-13 from fiscal year 2011-12. Click Here for Additional Information - 21 - General Funds Summary Presents comparisons of year-to-date balances to the fiscal year budget and to the actual results for the prior year for the general fund. General Fund Revenue As of May 31 (dollars in thousands) Actual Year-to-Date 2013-14 2012-13 Budget Estimate 2013-14 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 $ $ 442,309 2,363 383,228 $ 2,400 372,534 2,286 127,448 160,852 51,150 142,849 2,830 9,525 115,655 148,130 46,911 127,628 2,488 7,289 108,131 135,363 43,535 114,592 2,447 7,240 19,312 1,210 13,266 1,362 7,912 1,058 3,975 16,218 938 11,977 964 6,541 1,118 3,875 17,500 1,005 11,268 911 6,679 1,173 4,189 37,900 12,451 2,200 11,817 28,630 12,100 1,765 12,783 30,879 11,547 1,333 12,800 1,051,789 - 22 - $ $ 930,638 $ 885,412 General Fund Expenditures As of May 31 (dollars in thousands) Actual Year-to-Date 2013-14 2012-13 Budget Estimate 2013-14 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 $ 1,755 3,590 2,442 32,781 2,319 2,367 19,542 2,389 5,694 10,225 3,054 18,061 2,213 106,432 1,518 $ 3,045 1,945 28,077 2,034 2,019 17,489 2,176 3,812 8,740 3,004 18,452 1,835 94,146 1,547 2,952 1,697 29,225 2,311 2,070 18,269 1,928 4,358 8,966 2,960 14,809 2,401 93,493 29,395 4,903 34,298 25,674 4,172 29,846 26,448 4,263 30,711 Public Safety Police Fire Others Total Public Safety 462,407 250,693 22 713,122 413,627 224,841 13 638,481 408,931 219,366 16 628,313 Transportation Street Transportation Public Transit Total Transportation 22,097 19,520 41,617 16,307 11,341 27,648 17,166 17,780 34,946 Community Development Economic Development Neighborhood Services Department Planning and Development Others Total Community Development 5,134 12,337 5,026 54 22,551 4,086 10,556 3,835 45 18,522 3,864 10,355 3,965 45 18,229 Community Enrichment Parks and Recreation Library Human Services Others Total Community Enrichment 94,371 35,478 18,711 2,942 151,502 80,142 30,528 16,222 2,230 129,122 79,230 31,057 16,691 2,018 128,996 Environmental Services Public Works Environmental Programs Total Environmental Services 16,554 984 17,538 11,077 649 11,726 13,645 745 14,390 2,442 1,307 2,647 38,313 - - Criminal Justice Municipal Court Public Defender Total Criminal Justice Capital Improvement Contingencies Total Expenditures and Encumbrances $ 1,127,815 - 23 - $ $ 950,798 $ 951,725 Citywide Summary Presents the City's summarized comparisons of the year-to-date balances to the fiscal year budget and to the actual results for the prior year. Citywide Operating Revenue As of May 31 (dollars in thousands) Source General Funds Local Taxes: Sales Taxes Privilege License Fees State Shared Taxes: State Sales Tax State Income Tax Vehicle License Tax Primary Property Tax Licenses and Permits Cable Communications Municipal Court Police Library Fees Parks and Recreation Planning & Development Street Transportation Fire Interest Other Fees and Service Charges Budget Estimate 2013-14 $ Total General Funds 442,309 2,363 383,228 $ 2,400 372,534 2,286 127,448 160,852 51,150 142,849 2,830 9,525 20,522 13,266 1,362 7,912 1,058 3,975 50,351 2,200 11,817 115,655 148,130 46,911 127,628 2,488 7,289 17,156 11,977 964 6,541 1,118 3,875 40,730 1,765 12,783 108,131 135,363 43,535 114,592 2,447 7,240 18,505 11,268 911 6,679 1,173 4,189 42,426 1,333 12,800 1,051,789 930,638 885,412 30,240 85,231 30,399 8,056 171,171 15,377 36,720 17,226 15,829 100,600 41,867 4,862 31,368 288,554 40,581 26,849 76,007 26,889 8,327 168,401 12,167 41,200 14,046 14,919 92,647 39,024 4,700 29,483 202,423 33,593 25,191 72,356 25,237 6,050 150,254 8,515 36,452 15,125 14,012 89,324 21,898 4,808 34,783 209,365 55,776 918,081 790,675 769,146 309,343 60,544 407,753 211,312 145,756 302,761 54,759 356,237 197,471 134,822 319,235 53,975 387,646 203,030 131,974 1,134,708 1,046,050 1,095,860 2,767,363 $ 2,750,418 Special Revenue and Debt Service Funds Neighborhood Protection Public Safety Enhancement & Expansion Parks and Preserves Golf Courses 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/Secondary Property Tax Total Special Revenue and Debt Service Funds Enterprise Funds Aviation Convention Center Water System Wastewater Solid Waste Total Enterprise Funds Total Operating Revenues $ Actual Year-to-Date 2013-14 2012-13 3,104,578 - 24 - $ $ Citywide Operating Expenditures As of May 31 (dollars in thousands) Source General Government General Funds Other Funds Total General Government Actual Year-to-Date 2013-14 2012-13 Budget 2013-14 $ Criminal Justice General Funds Other Funds Total Criminal Justice 106,432 13,849 120,281 $ 94,146 $ 11,153 105,299 93,493 11,253 104,746 34,298 12,573 46,871 29,846 7,386 37,232 30,711 7,203 37,914 Public Safety General Funds Other Funds Total Public Safety 713,122 162,719 875,841 638,481 129,913 768,394 628,313 142,163 770,476 Transportation General Funds Other Funds Total Transportation 41,617 595,272 636,889 27,648 510,425 538,073 34,946 510,719 545,665 Community Development General Funds Other Funds Total Community Development 22,551 206,137 228,688 18,522 159,826 178,348 18,229 175,064 193,293 Community Enrichment General Funds Other Funds Total Community Enrichment 151,502 136,700 288,202 129,122 119,273 248,395 128,996 120,735 249,731 Environmental Services General Funds Other Funds Total Environmental Services 17,538 609,921 627,459 11,726 513,446 525,172 14,390 501,460 515,850 52,455 52,455 92,383 92,383 125,823 125,823 2,442 537,871 540,313 1,307 250,282 251,589 2,647 287,812 290,459 Debt Service General Funds Other Funds Total Debt Service Capital Improvement General Funds Other Funds Total Capital Improvement Contingencies General Funds Other Funds Total Contingencies Total Operating General Funds Other Funds Total Operating Budget 38,313 47,194 85,507 $ 1,127,815 2,374,691 3,502,506 - 25 - - $ 950,798 1,794,087 2,744,885 $ 951,725 1,882,232 2,833,957 Citywide Detail Presents, in detail, the results of the City's operations for the current month and for the fiscal year-to-date. Included are breakdowns of the City's revenues, operating budget expenditures, capital budget expenditures and bonds authorized and sold. Citywide Operating Revenue by Source For the Month Ended May 31 2014 2013 Budget Estimate 2013-14 Source Actual Year-to-Date 2013-14 2012-13 General Funds $ 33,165,785 73,567 $ 34,699,438 83,396 Local Taxes: Sales Taxes Privilege License Fees $ 442,309,000 2,363,000 $ 383,228,445 2,399,706 $ 372,533,454 2,286,325 33,239,352 34,782,834 Total Local Taxes 444,672,000 385,628,151 374,819,779 10,862,865 13,449,465 4,643,480 9,901,675 12,305,683 4,087,693 State Shared Taxes: State Sales Tax State Income Tax Vehicle License Tax 127,448,000 160,852,000 51,150,000 115,655,363 148,130,394 46,911,138 108,130,855 135,362,518 43,535,237 28,955,810 26,295,051 339,450,000 310,696,895 287,028,610 35,756,232 29,951,630 142,849,000 127,628,053 114,592,248 207,220 Licenses and Permits 2,830,000 2,487,875 2,446,777 2,428,469 Cable Communications 9,525,232 7,289,333 7,239,601 1,434,955 87,473 1,709,339 99,991 Municipal Court: Fines and Forfeitures Court Default Fee 19,312,290 1,210,000 16,217,848 938,141 17,500,469 1,004,904 1,522,428 1,809,330 20,522,290 17,155,989 18,505,373 1,285,757 989,668 13,266,040 11,976,724 11,267,797 - 273,523 Total State Shared Taxes Primary Property Tax 131,439 96,860 83,630 841,912 Total Municipal Court Police Library Fees 1,362,000 964,135 910,978 Parks and Recreation 7,911,605 6,540,579 6,679,351 112,373 108,166 Planning and Development 1,058,400 1,118,038 1,173,487 291,108 627,319 Street Transportation 3,975,000 3,875,003 4,189,093 2,606,609 175,725 193,542 2,673,193 192,000 121,657 37,900,000 1,150,000 11,300,885 28,630,289 1,101,022 10,998,610 30,879,372 1,066,974 10,479,972 2,975,876 2,986,850 50,350,885 40,729,921 42,426,318 204,799 113,107 2,200,000 1,764,759 1,332,819 315,136 1,517,677 105,081,160 102,822,396 Fire: Emergency Transportation Service Hazardous Materials Inspection Fee Other Total Fire Interest Other Fees and Service Charges Total General Funds - 26 - 11,816,950 12,783,019 12,799,816 1,051,789,402 930,638,474 885,412,047 Citywide Operating Revenue by Source (continued) For the Month Ended May 31 2014 2013 Budget Estimate 2013-14 Source Actual Year-to-Date 2012-13 2013-14 Special Revenue and Debt Service Funds $ 1,727,226 123,373 616,867 3,088 $ 1,726,539 123,325 616,621 (738) 2,470,554 2,465,747 4,927,745 1,587,508 (10,040) 4,911,332 1,578,020 (7,176) 6,505,213 6,482,176 2,483,794 2,478,360 789,149 66,611 224,092 (2,584) 19,685 306,996 6,017 178,400 (4,009) 9,761 1,096,953 497,165 8,894,090 18,887,920 9,865,936 1,618,972 27,782,010 11,484,908 - 355,711 Neighborhood Protection: Police Neighborhood Protection Police Blockwatch Fire Neighborhood Protection Interest/Other $ Total Neighborhood Protection Public Safety Enhancement & Expansion: Police Fire Interest/Other Total Public Safety Enhancement & Expansion Parks and Preserves Golf Courses: Fees Coffee Shops Concessions Interest Other 21,066,000 1,505,000 7,523,000 145,500 $ 18,666,533 1,333,323 6,666,619 182,345 $ 17,526,104 1,251,865 6,259,323 153,277 30,239,500 26,848,820 25,190,569 63,718,000 21,578,000 (65,000) 56,789,630 19,322,788 (105,451) 53,917,703 18,508,909 (70,846) 85,231,000 76,006,967 72,355,766 30,399,000 26,888,629 25,237,488 5,427,300 271,360 2,331,200 (81,040) 107,431 5,441,015 257,598 2,172,268 (54,402) 510,060 3,830,657 66,141 1,951,529 (67,498) 268,904 8,056,251 8,326,539 6,049,733 120,380,000 50,791,438 102,797,500 65,604,063 100,149,167 50,104,469 171,171,438 168,401,563 150,253,636 Court Awards 15,376,764 12,167,579 8,515,219 Total Golf Courses Transit 2000: Sales Taxes Interest/Other Total Transit 2000 3,462,782 4,238,869 Planning and Development 36,720,200 41,200,227 36,452,489 1,250,379 1,353,005 Capital Construction 17,226,000 14,046,113 15,124,613 1,707,832 11,865 1,599,917 14,079 Sports Facilities: Sales Taxes Interest/Other 15,564,000 265,000 14,661,361 257,337 13,695,683 316,463 1,719,697 1,613,996 15,829,000 14,918,698 14,012,146 Total Sports Facilities - 27 - Citywide Operating Revenue by Source (continued) For the Month Ended May 31 2014 2013 Budget Estimate 2013-14 Source Actual Year-to-Date 2012-13 2013-14 Special Revenue and Debt Service Funds (Cont'd) $ 9,431,784 22,791 18,908 8,651,532 19,252 1,318 9,473,483 8,672,102 Highway User Revenue: Highway User Revenue Interest Other Total Highway User Revenue 100,150,000 250,000 200,000 92,230,895 219,038 197,253 89,124,241 161,271 38,655 100,600,000 92,647,186 89,324,167 9,155,646 1,858,776 Regional Transit Revenues 41,867,049 39,023,835 21,897,783 1,173,080 1,464,992 Community Reinvestment 4,861,901 4,699,814 4,808,296 2,347,887 2,662,035 Other Restricted Fees 31,368,544 29,482,815 34,783,122 598,227 5,981,543 75,308 Grants: Public Housing: Rentals Grants Other 448,697 5,335,928 239,781 $ 6,024,406 6,655,078 3,663,356 7,568,438 65,563 4,778,487 2,706,603 3,270,623 142,029 6,610,083 16,075,844 12,729,338 22,100,250 19,384,416 8,806,254 (1,979) 14,159,507 6,022 $ Total Public Housing 6,952,965 73,208,080 5,269,398 $ 6,040,245 64,621,711 3,480,936 $ 6,415,263 60,330,210 2,364,940 85,430,443 74,142,892 69,110,413 42,441,013 59,918,966 33,269,864 67,493,613 30,225,370 29,483,693 17,899,382 50,671,683 31,175,599 10,308,692 17,107,111 81,663,025 Total Other 203,123,456 128,280,128 140,254,427 Total Grants 288,553,899 202,423,020 209,364,840 35,442,800 5,138,000 31,256,572 2,336,052 53,844,393 1,931,441 Other: Human Resources Federal Transit Administration Community Development Other G.O. Bond/Secondary Property Tax Secondary Property Tax Interest 8,804,275 14,165,529 Total G.O. Bond/Secondary Property Tax 99,826,003 79,177,787 Total Special Revenue and Debt Service Funds 40,580,800 33,592,624 55,775,834 918,081,346 790,674,429 769,145,701 123,050,000 177,863,000 450,000 3,341,000 1,679,200 2,960,000 - 94,856,244 198,562,865 851,785 3,938,718 1,937,987 2,708,972 (95,735) 90,478,234 185,884,849 455,487 1,582,969 1,638,722 2,698,519 36,496,424 309,343,200 302,760,836 319,235,204 Enterprise Funds AVIATION: 8,751,658 19,325,602 79,358 808,869 182,351 238,564 (36,085) 8,512,390 17,363,047 58,888 511,452 128,056 256,760 4,189,192 29,350,317 31,019,785 Sky Harbor: Airlines Concessions Interest Other Phoenix-Goodyear Phoenix-Deer Valley Phoenix-Customer Facility Charge Total Aviation - 28 - Citywide Operating Revenue by Source (continued) For the Month Ended May 31 2014 2013 Budget Estimate 2013-14 Source Actual Year-to-Date 2013-14 2012-13 Enterprise Funds (Cont'd) CONVENTION CENTER: 4,044,935 1,597,301 23,414 3,947,360 1,224,426 25,256 5,665,650 5,197,042 Excise Taxes Operating Revenue Interest Total Convention Center 43,924,000 16,280,625 338,980 40,136,504 14,412,431 209,952 37,201,239 16,542,288 231,073 60,543,605 54,758,887 53,974,600 WATER SYSTEM: $ 34,140,716 437,855 304,877 555,639 242,340 166,639 443,833 $ 36,291,899 32,749,825 500,223 303,324 627,575 171,360 134,882 175,393 34,662,582 Water Sales Water Service Fees Distribution Intergovernmental Development Fees Interest Other $ Total Water System 385,949,000 6,000,000 3,500,000 6,666,000 2,600,000 2,925,000 113,000 $ 333,861,203 5,262,642 3,746,556 5,293,841 2,215,920 2,024,120 3,831,762 $ 333,110,181 5,427,384 3,783,664 7,548,753 2,236,440 1,694,173 33,845,069 407,753,000 356,236,044 387,645,664 179,686,000 16,004,000 2,500,000 1,370,000 11,752,000 165,829,172 17,169,999 2,109,720 1,196,463 11,165,538 164,884,289 16,823,895 2,182,800 1,206,126 17,933,534 211,312,000 197,470,892 203,030,644 125,935,000 6,932,000 310,000 12,578,700 116,415,794 6,447,669 353,708 11,604,852 115,100,760 6,177,111 315,095 10,381,616 145,755,700 134,822,023 131,974,582 1,134,707,505 1,046,048,682 1,095,860,694 WASTEWATER: 15,220,441 1,508,326 221,340 97,147 1,251,559 15,133,398 1,457,426 169,860 86,674 1,134,648 18,298,813 17,982,006 Sewer Service Charges Multi-City Development Fees Interest Other Total Wastewater SOLID WASTE: $ 10,626,958 242,779 35,410 965,532 10,520,000 787,338 26,607 1,103,682 11,870,679 12,437,627 101,477,358 101,299,042 306,384,521 $ 283,299,225 Collection Fees Landfill Fees Interest Other Total Solid Waste Total Enterprise Funds Total Operating Revenues $ - 29 - 3,104,578,253 $ 2,767,361,585 $ 2,750,418,442 Citywide Operating Expenditures by Program For the Month Ended May 31 2014 2013 Budget Estimate 2013-14 Program Actual Year-to-Date 2013-14 2012-13 2013-14 Year-to-Date Operating Expenditures & Encumbrances Capital Operations and Debt General Government $ 120,457 $ 258,264 294,562 2,894,112 63,590 167,879 205,179 1,562,585 15,136 234,183 4,476 984,032 (40,903) 7,297 263,998 2,046,106 661,078 9,742,031 131,705 282,565 280,470 3,742,030 75,835 238,678 228,351 1,824,010 143,995 405,416 89,074 924,954 (68,328) 6,445 285,955 1,770,322 586,044 10,947,521 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,755,285 3,589,459 2,766,001 35,059,291 1,304,646 2,660,360 2,796,854 20,550,337 2,389,388 5,694,435 809,263 11,410,338 99,285 3,053,828 21,961,636 4,380,637 $ 1,517,924 3,045,402 2,211,484 30,196,379 1,045,952 2,352,842 2,379,368 18,506,776 2,175,466 3,812,240 734,088 9,825,717 (11,605) 77,302 3,003,633 19,884,719 4,541,384 $ 1,546,709 2,952,048 1,905,089 30,755,963 1,228,850 2,611,042 2,420,011 19,459,004 1,928,043 4,358,141 1,138,909 10,218,798 39,502 53,921 2,959,837 17,550,807 3,619,724 $ 1,517,924 3,045,402 2,211,484 28,652,723 1,045,952 2,352,842 2,379,368 18,506,776 2,175,466 3,812,240 734,088 9,107,581 (11,605) 77,302 3,003,633 18,880,911 4,541,384 $ 1,543,656 718,136 1,003,808 - 120,281,043 105,299,071 104,746,398 102,033,471 3,265,600 41,968,415 4,902,494 33,059,482 4,172,320 33,651,336 4,262,649 27,346,883 4,172,320 5,712,599 - 46,870,909 37,231,802 37,913,985 31,519,203 5,712,599 577,412,700 297,951,260 476,598 505,949,199 262,009,877 434,706 511,757,186 258,215,849 502,712 501,489,199 258,933,447 434,706 4,460,000 3,076,430 - 875,840,558 768,393,782 770,475,747 760,857,352 7,536,430 Criminal Justice 2,985,235 376,701 3,062,510 387,949 3,361,936 3,450,459 Municipal Court Public Defender Total Criminal Justice Public Safety 44,427,008 22,715,972 29,516 47,185,392 22,956,548 48,569 67,172,496 70,190,509 Police Fire Other Total Public Safety - 30 - Citywide Operating Expenditures by Program (continued) For the Month Ended May 31 2014 2013 Budget Estimate 2013-14 Program Actual Year-to-Date 2013-14 2012-13 2013-14 Year-to-Date Operating Expenditures & Encumbrances Capital Operations and Debt Transportation $ 5,114,490 917,525 23,481,330 8,001,207 37,514,552 $ 4,390,214 975,231 22,677,786 10,196,689 38,239,920 Street Transportation Street Lighting Aviation Public Transit Total Transportation $ 59,665,604 11,172,894 305,626,250 260,424,196 $ 52,064,995 10,336,103 248,123,170 227,548,681 $ 50,609,464 10,093,875 247,571,576 237,390,134 $ 51,242,132 10,336,103 200,776,608 186,617,107 $ 822,863 47,346,562 40,931,574 636,888,944 538,072,949 545,665,049 448,971,950 89,100,999 Community Development 3,173,161 6,312,915 1,796,462 2,962,101 3,056,386 6,282,729 2,737,374 4,723,654 Planning and Development Housing Economic Development Neighborhood Services Department 41,892,298 82,014,323 33,963,216 70,818,138 34,969,204 69,641,895 31,901,005 41,836,056 32,946,426 69,114,811 28,982,993 62,249,242 34,969,204 69,577,332 19,200,452 41,836,056 64,563 12,700,553 - 14,244,639 16,800,143 Total Community Development 228,687,975 178,348,160 193,293,472 165,583,044 12,765,116 102,560,009 35,798,557 8,785,423 61,858,418 10,927,120 62,723,393 3,919,060 1,630,435 86,880,909 31,184,026 8,631,889 53,918,491 10,015,624 53,456,203 3,054,239 1,253,602 85,481,413 31,700,995 6,847,410 52,744,572 10,865,331 58,052,955 2,971,812 1,066,410 85,139,118 31,184,026 8,631,889 36,881,969 53,182,910 3,054,239 1,253,602 1,741,791 17,036,522 10,015,624 273,293 - 288,202,415 248,394,983 249,730,898 219,327,753 29,067,230 Community Enrichment 8,004,464 2,731,448 869,705 4,751,041 910,103 4,708,310 317,279 60,332 8,076,819 3,797,736 597,167 3,703,817 984,148 11,426,295 161,660 51,072 22,352,682 28,798,714 Parks and Recreation Library Golf Convention Center Sports and Cultural Facilities Human Services Public Parking Facilities Other Total Community Enrichment - 31 - Citywide Operating Expenditures by Program For the Month Ended May 31 2014 2013 Budget Estimate 2013-14 Program 2013-14 Year-to-Date Operating Expenditures & Encumbrances Capital Operations and Debt Actual Year-to-Date 2013-14 2012-13 Environmental Services $ 22,636,146 12,700,538 8,931,592 1,761,282 132,041 $ 46,161,599 21,725,817 10,813,938 10,730,514 1,148,288 205,682 44,624,239 Water System Wastewater Solid Waste Management Public Works Environmental Programs $ Total Environmental Services 385,100,042 76,206,190 141,801,767 22,863,808 1,486,777 $ 266,949,888 127,850,653 112,860,670 16,638,777 872,378 $ 261,933,414 121,540,836 112,030,419 19,270,239 1,074,790 $ 162,507,263 65,054,535 100,967,508 11,906,465 872,378 $ 341,308,149 104,442,625 62,796,118 11,893,162 4,732,312 - 627,458,584 525,172,366 515,849,698 183,864,217 866,210 9,110,990 8,426,500 337,530 4,614,170 690,670 4,883,650 628,460 7,202,830 7,785,230 1,173,410 14,496,710 50,200 7,264,190 1,279,120 2,866,431 (48,335,390) 938,600 15,486,000 5,480,820 6,810 7,201,708 794,021 8,351,727 7,724,288 309,406 4,229,641 633,110 4,476,668 576,092 6,602,572 7,136,440 1,075,626 13,284,599 46,017 6,658,829 1,172,516 2,626,446 2,247 859,902 14,195,058 5,023,239 6,245 6,598,269 1,012,565 10,671,878 12,229,838 249,143 4,294,180 354,107 2,897,696 577,285 4,182,311 6,225,479 463,750 13,500,937 46,017 5,682,400 1,184,299 5,558,377 2,207 427,465 24,203,101 25,126,347 206,445 6,726,874 - 794,021 8,351,727 7,724,288 309,406 4,229,641 633,110 4,476,668 576,092 6,602,572 7,136,440 1,075,626 13,284,599 46,017 6,658,829 1,172,516 2,626,446 2,247 859,902 14,195,058 5,023,239 6,245 6,598,269 General Obligation Debt Service 72,183 759,247 702,208 28,127 384,513 57,556 406,970 52,372 600,233 648,768 97,784 1,207,691 4,184 605,348 106,593 238,768 9 78,173 1,290,460 456,658 568 599,765 92,050 965,221 1,106,905 22,295 384,512 32,139 259,470 52,372 373,151 565,380 41,951 1,217,886 4,184 510,764 106,593 505,278 38,173 2,194,172 2,281,658 18,768 611,452 8,398,178 11,384,374 Total Debt Service 52,454,849 92,382,958 125,822,701 - 92,382,958 43,944,229 40,953,271 Capital Improvement 540,313,358 251,588,709 290,458,604 - 251,588,709 $ 252,892,342 $ 265,389,150 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 85,507,274 $ - 3,502,505,909 $ - 32 - 2,744,884,780 $ 2,833,956,552 $ 2,069,600,922 $ 675,283,858 Capital Expenditures and Encumbrances 2013-14 ogram Budget General Government Arts and Cultural Facilities Economic Development Energy Conservation Facilities Management Finance Fire Protection Historic Preservation Housing Human Services Information Technology Libraries Neighborhood Services Parks and Mountain Preserves Police Protection Public Transit Regional Wireless Cooperative Street Transportation & Drainage Total Capital Improvement Program Enterprise Aviation Phoenix Convention Center Solid Waste Disposal Wastewater Water System Enterprise Subtotal Total Capital Budget Program Actual Yearto-Date 2012-132013-14 Year-to-Date Capital Amounts Actual YearFrom Operating Funds to-Date Budget Actual $ 453,939 $ 9,487,984 4,674,297 12,589,400 2,963,402 7,548,022 1,618,109 47,238,059 971,825 11,475,314 2,034,035 7,713,141 58,973,395 17,666,428 107,343,452 11,146,109 217,863,460 761,935 $ 3,315,687 4,352,785 3,777,074 7,352,376 4,427,576 169,667 16,852,767 2,089,235 10,613,953 654,926 1,050,969 17,659,787 14,109,557 21,544,847 5,327,451 121,183,717 15,453,331 2,886,420 6,134,226 10,056,710 11,313,117 1,421,199 28,290,412 683,145 476,542 325,708 2,987,134 43,505,589 7,959,789 85,974,654 54,390,577 $ 521,760,371 $ 235,244,309 $ 271,858,553 $ $ $ 320,348,316 26,370,374 23,655,539 121,032,175 201,693,934 693,100,338 $ $ 153,576,935 21,431,110 683,924 47,640,902 86,959,330 310,292,201 $ 1,214,860,709 $ 545,536,510 $ $ $ $ 117,441,068 19,564,723 4,230,441 77,801,608 98,713,843 317,751,683 $ 589,610,236 134,803 $ 9,225,140 4,674,297 4,790,000 1,606,370 87,000 4,759 24,852,045 919,925 200,000 3,836,994 33,873,798 8,500,000 79,481,910 79,178,014 210,614 3,132,544 4,352,785 2,829,747 4,072,628 224 10,849,511 82,000 764,106 114,077 657,067 14,201,343 5,387,820 17,399,070 60,590,096 251,365,055 $ 124,643,632 $ $ 34,834,765 5,921,374 15,992,172 58,073,538 174,126,454 288,948,303 $ 540,313,358 - 33 - From Capital Funds Budget $ $ $ $ 17,221,812 2,683,480 557,218 20,438,103 86,044,464 126,945,077 $ 251,588,709 Actual Unencumbered Budget 319,136 $ 262,844 7,799,400 1,357,032 7,461,022 1,613,350 22,386,014 971,825 10,555,389 1,834,035 3,876,147 25,099,597 9,166,428 27,861,542 11,146,109 138,685,446 551,321 183,143 947,327 3,279,748 4,427,352 169,667 6,003,256 2,007,235 9,849,847 540,849 393,902 3,458,444 8,721,737 4,145,777 5,327,451 60,593,621 270,395,316 $ 110,600,677 $ $ 285,513,551 20,449,000 7,663,367 62,958,637 27,567,480 404,152,035 $ 674,547,351 $ (307,996) 6,172,297 321,512 8,812,326 (4,388,974) 3,120,446 1,448,442 30,385,292 (1,117,410) 861,361 1,379,109 6,662,172 41,313,608 3,556,871 85,798,605 5,818,658 96,679,743 $ 286,516,062 $ $ 136,355,123 18,747,630 126,706 27,202,799 914,866 183,347,124 $ 166,771,381 4,939,264 22,971,615 73,391,273 114,734,604 382,808,137 $ 293,947,801 $ 669,324,199 Bonds Authorized and Sold As of May 31 (dollars in thousands) Authorized Sold Available 1988 Authorizations General Obligation Bonds Freeway Mitigation, Neighborhood Stabilization, and Slum and Blight Elimination Bonds Fully Issued $ Total General Obligation Bonds Revenue Bonds Bonds Fully Issued Total 1988 Authorizations 29,285 884,175 $ 28,285 884,175 $ 1,000 - 913,460 912,460 1,000 143,890 143,890 - 1,057,350 1,056,350 1,000 66,300 125,300 24,800 61,500 12,000 33,000 91,500 74,000 77,000 78,800 66,000 43,700 64,600 124,685 24,170 60,700 11,205 32,100 89,275 71,645 72,575 77,685 65,950 43,700 1,700 615 630 800 795 900 2,225 2,355 4,425 1,115 50 - 753,900 738,290 15,610 81,000 11,100 198,700 12,800 104,622 74,705 29,178 115,500 107,295 78,200 65,400 63,385 8,510 190,610 8,345 85,510 61,200 21,100 102,290 81,900 58,135 61,770 17,615 2,590 8,090 4,455 19,112 13,505 8,078 13,210 25,395 20,065 3,630 878,500 742,755 135,745 2001 Authorization General Obligation Bonds Education, Youth and Family Cultural Facilities Computer Technology Environmental Cleanup Fire Protection Historic Preservation Library Facilities Street Improvements Neighborhood Protection and Senior Centers Parks, Open Space, and Recreational Facilities Police Protection Storm Sewer and Flood Protection Bonds Fully Issued Total 2001 Authorizations 2006 Authorization General Obligation Bonds Affordable Housing and Neighborhood Revitalization Computer Technology Education and Health Science Facilities Environmental Cleanup Family, Senior, and Youth Cultural Facilities Fire Protection Library Facilities and Improvements Parks, Open Space, and Recreational Facilities Police Protection Street Improvements Storm Sewer and Flood Protection Total 2006 Authorizations Total Bond Program $ - 34 - 2,689,750 $ 2,537,395 $ 152,355 Appendix A Additional historic and trend information for various revenue streams. Local Sales Tax (Dollars in Thousands) Local Sales Tax 45,000 09-10 Actuals 40,000 10-11 Actuals 35,000 11-12 Actuals 30,000 12-13 Actuals 25,000 13-14 Actuals 20,000 13-14 budget 15,000 July FY 09-10 10-11 11-12 12-13 13-14 13-14 budget July 17,876 32,543 33,875 34,005 36,360 36,708 Aug Aug 32,064 32,288 34,239 34,276 35,589 36,847 Sept Sept 30,205 33,087 33,371 34,254 35,873 36,813 Oct Nov Oct 26,205 32,143 34,746 33,337 35,068 36,636 Dec Nov 30,500 32,952 31,854 33,430 34,363 35,908 Jan Dec 32,382 31,456 31,745 32,504 32,474 34,984 Jan 29,948 36,278 36,385 36,527 40,116 39,913 Feb Feb 27,160 30,658 31,532 32,542 32,084 34,628 Note: City of Phoenix revenue is budgeted on an annual basis. 2013-14 monthly budget amounts are based on an allocation of the annual budget. Monthly budget amounts are calculated based on an allocation of FY 2010-11 through 2012-13 actual expenditures. FY 2009-10 expenditures were excluded from the calculation due to a significant outlier in July 2009. Return to Summary Page - A1 - Mar Mar 26,456 31,302 32,549 32,047 32,147 35,054 Apr Apr 34,963 34,169 34,955 34,911 35,988 38,028 May May 26,601 33,040 32,521 34,699 33,165 36,648 June YTD thru May 314,360 359,918 367,773 372,533 383,228 402,167 June 36,787 32,462 39,115 38,243 40,143 State Sales Tax (Dollars in Thousands) State Sales Tax 13,000 12,000 09-10 Actuals 11,000 10-11 Actuals 10,000 11-12 Actuals 9,000 8,000 12-13 Actuals 7,000 13-14 Actuals 6,000 13-14 budget 5,000 July FY 09-10 10-11 11-12 12-13 13-14 YTD 13-14 budget Aug July 11,157 9,769 8,852 9,907 10,309 10,553 Sept Aug 8,370 8,262 8,683 8,755 9,616 9,507 Sept 8,954 8,684 8,993 9,240 10,012 9,957 Oct Oct 8,785 8,642 9,177 9,229 9,923 10,006 Nov Nov 8,530 8,687 9,083 9,456 9,673 10,071 Dec Jan Dec 8,883 8,947 9,055 9,462 10,296 10,160 Feb Jan 11,040 10,757 11,290 11,986 12,744 12,589 Mar Feb 8,164 9,258 8,572 9,270 10,430 10,025 Note: City of Phoenix revenue is budgeted on an annual basis. 2013-14 monthly budget amounts are based on an allocation of the annual budget. Monthly budget amounts are calculated based on an allocation of FY 2010-11 through 2012-13 actual expenditures. FY 2009-10 expenditures were excluded from the calculation due to a significant outlier in June 2010. Return to Summary Page - A2 - Apr Mar 8,625 9,134 9,554 9,887 10,506 10,570 May Apr 10,070 10,448 9,744 11,037 11,285 11,552 June May 8,718 10,048 9,743 9,902 10,863 10,984 YTD thru May 101,294 102,637 102,745 108,131 115,655 115,974 June 5,623 9,150 11,272 10,599 11,475 Vehicle License Tax (Dollars in Thousands) Vehicle License Tax 5,500 09-10 Actuals 5,000 4,500 10-11 Actuals 4,000 11-12 Actuals 3,500 12-13 Actuals 3,000 13-14 Actuals 2,500 Budget 13-14 2,000 July FY 09-10 10-11 11-12 12-13 13-14 Budget 13-14 Aug July 4,920 5,217 4,482 4,493 4,752 5,077 Sept Aug 5,344 4,141 3,698 3,982 4,663 4,559 Oct Sept 3,336 3,722 3,842 3,852 3,992 3,918 Nov Oct 4,425 4,018 3,669 3,535 3,912 4,156 Dec Nov 3,702 3,224 3,089 3,582 3,958 3,612 Jan Feb Dec 3,649 4,095 3,781 3,993 3,872 4,122 Jan 4,145 3,894 3,645 3,572 3,936 4,052 Mar Feb 3,437 3,372 3,620 4,141 4,799 3,870 Note: City of Phoenix revenue is budgeted on an annual basis. 2013-14 monthly budget amounts are based on an allocation of the annual budget. Monthly budget amounts are calculated based on an allocation of FY 2009-10 through 2012-13 actual expenditures. Return to Summary Page - A3 - Apr Mar 4,742 4,820 4,860 4,623 4,559 5,059 May Apr 3,912 3,854 3,482 3,676 3,826 3,964 June May 4,295 4,091 3,796 4,088 4,643 4,321 YTD thru May 45,907 44,448 41,965 43,535 46,911 46,710 June 3,594 3,851 4,435 4,834 4,440 Regional Transit Revenues (Dollars in Thousands) Regional Transit Revenues 20,000 09-10 Actuals 15,000 10-11 Actuals 11-12 Actuals 10,000 12-13 Actuals 5,000 13-14 Actuals Budget 13-14 July FY 09-10 10-11 11-12 12-13 13-14 Budget 13-14 Aug July 15,852 1,256 (7) 2,410 2,097 1,681 Sept Aug (36) 2,067 1,931 2,077 2,106 2,791 Oct Sept 13 1,140 1,936 2,077 2,097 2,367 Nov Oct 2,564 1,936 2,953 2,077 1,460 3,201 Dec Nov 7 2,661 1,043 2,077 2,600 2,656 Jan Dec 14,098 11,011 1,931 1,197 2,096 6,496 Feb Jan 7,255 2,196 1,931 2,113 2,575 2,867 Mar Feb (325) 12 1,931 2,076 9,865 1,847 Note: City of Phoenix revenue is budgeted on an annual basis. 2013-14 monthly budget amounts are based on an allocation of the annual budget. Monthly budget amounts are calculated based on an allocation of FY 2010-11 through 2012-13 actual expenditures. FY 2009-10 expenditures were excluded from the calculation due to multiple months with significant outliers. Return to Summary Page - A4 - Apr Mar 56 12 1,931 2,075 1,396 1,846 May Apr 2,208 39 2,208 1,859 3,576 1,886 June May 74 12 5,466 1,859 9,156 3,371 YTD Thru May 41,768 22,342 23,255 21,898 39,024 31,009 June 16,328 19,833 1,931 1,869 10,858 Aviation Revenues (Dollars in Thousands) Aviation Revenues 40,000 09-10 Actuals 35,000 10-11 Actuals 30,000 11-12 Actuals 25,000 12-13 Actuals 20,000 13-14 Actuals 15,000 Budget 13-14 10,000 July FY 09-10 10-11 11-12 12-13 13-14 Budget 13-14 Aug July 24,629 26,581 27,628 28,080 31,036 24,975 Sept Aug 22,881 26,388 24,404 26,231 22,760 22,855 Oct Sept 24,894 26,824 27,570 28,144 26,677 25,060 Nov Oct 24,298 38,540 26,280 30,124 26,505 25,089 Dec Nov 24,558 13,697 27,849 26,471 26,222 24,522 Jan Dec 27,072 27,977 29,526 28,146 27,171 26,345 Feb Jan 23,587 25,681 27,146 27,054 26,659 24,183 Mar Feb 24,594 28,359 27,028 27,884 26,561 24,717 Note: City of Phoenix revenue is budgeted on an annual basis. 2013-14 monthly budget amounts are based on an allocation of the annual budget. Monthly budget amounts are calculated based on an allocation of FY 2009-10, 2011-12, and 2012-13 actual expenditures. FY 2010-11 expenditures were excluded from the calculation due to significant outliers in October and November 2010. Return to Summary Page - A5 - Apr Mar 27,973 28,876 28,470 31,100 28,352 27,215 May Apr 29,635 30,528 33,111 34,980 31,467 30,381 June May 26,896 27,087 30,194 31,020 29,350 27,392 YTD thru April 281,018 300,539 309,206 319,235 302,761 282,734 June 27,054 32,096 30,075 28,463 26,609 Water System Revenues (Dollars in Thousands) Water System Revenues 80,000 75,000 09-10 Actuals 70,000 65,000 60,000 55,000 10-11 Actuals 50,000 11-12 Actuals 45,000 40,000 35,000 12-13 Actuals 30,000 13-14 Actuals 25,000 20,000 15,000 10,000 Budget 13-14 July FY 09-10 10-11 11-12 12-13 13-14 Budget 13-14 Aug July 42,332 47,691 48,584 79,417 49,017 51,867 Sept Aug 41,933 40,774 44,616 42,419 42,137 47,644 Oct Sept 40,206 39,640 47,230 42,446 41,144 47,552 Nov Oct 35,368 30,588 35,860 34,197 34,917 38,100 Dec Nov 21,267 26,585 30,215 36,338 34,774 29,213 Jan Dec 24,487 21,157 20,946 25,523 22,327 24,918 Feb Jan 16,423 17,482 19,694 21,738 22,872 20,057 Mar Feb 15,317 16,371 18,282 18,711 21,185 18,699 Note: City of Phoenix revenue is budgeted on an annual basis. 2013-14 monthly budget amounts are based on an allocation of the annual budget. Monthly budget amounts are calculated based on an allocation of FY 2009-10 through FY 2011-12 actual expenditures. FY 2012-13 expenditures were excluded from the calculation due to a significant outlier in July 2012. Return to Summary Page - A6 - Apr Mar 15,957 17,629 20,726 21,386 21,993 20,324 May Apr 24,693 28,414 27,648 30,809 29,578 30,219 June May 27,969 29,903 32,635 34,663 36,292 33,868 YTD thru May 305,951 316,233 346,438 387,646 356,236 362,461 June 40,252 38,411 42,378 37,680 45,294 Wastewater Revenues (Dollars in Thousands) Wastewater Revenues 27,000 09-10 Actuals 22,000 10-11 Actuals 17,000 11-12 Actuals 12,000 12-13 Actuals 13-14 Actuals 7,000 Budget 13-14 2,000 July FY 09-10 10-11 11-12 12-13 13-14 Budget 13-14 Aug July 18,122 18,867 18,754 17,547 17,634 16,893 Sept Aug 19,401 19,831 19,339 18,057 18,252 17,630 Oct Sept 18,594 20,379 19,500 17,930 18,224 17,390 Nov Oct 21,058 18,860 19,161 17,684 17,798 17,973 Dec Nov 16,469 18,540 26,283 20,958 20,452 19,776 Jan Feb Dec 17,830 27,453 18,864 17,744 17,763 16,898 Jan 18,340 19,363 26,967 25,337 17,618 21,928 Mar Feb 18,338 23,589 16,038 17,663 18,058 16,153 Note: City of Phoenix revenue is budgeted on an annual basis. 2013-14 monthly budget amounts are based on an allocation of the annual budget. Monthly budget amounts are calculated based on an allocation of FY 2009-10, 2011-12, and 2012-13 actual expenditures. FY 2010-11 expenditures were excluded from the calculation due to a significant outlier in June 2011. Return to Summary Page - A7 - Apr Mar 18,038 18,759 18,552 14,263 14,986 15,785 May Apr 19,619 19,435 18,938 17,865 18,386 17,514 June May 26,066 18,776 19,734 17,982 18,299 19,798 YTD thru May 211,874 223,852 222,129 203,031 197,471 197,738 June 18,374 3,789 10,717 14,638 13,574