October 2014 Monthly Financial Report PREPARED BY Financial Accounting & Reporting Division City of Phoenix Monthly Financial Report October 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 Expected 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 Monitor & Consider Corrective Action Citywide Total Operating Expenditures 5 Better than Expected General Government 5 Better than Expected Criminal Justice 6 Better than Expected be taken directly to that page of the report. Table of Contents 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 Better than 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 Page Performance Status General Fund Total Operating Revenue 13 Expected Property Tax 14 Better than Expected Local Sales Tax 15 Corrective Action Taken State Sales Tax 16 Monitor & Consider Corrective Action Vehicle License Tax 17 Monitor & Consider Corrective Action Aviation 18 Better than Expected Water System 19 Monitor & Consider Corrective Action Wastewater 20 Better than Expected Financial Schedules General Fund Revenue Page 21 General Fund Expenditures 22 Citywide Operating Revenue 23 Citywide Operating Expenditures 24 Citywide Operating Revenue by Source 25 Citywide Operating Expenditures by Program 29 Capital Expenditures and Encumbrances 32 Bonds Authorized and Sold 33 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. October General Fund YTD Expenditures (Dollars in Thousands) Refer to detailed financial schedules pages 21 thru 33 Total General Fund Expenditures Total General Fund General Government October YTD Annual % of Annual Expenditures Expenditures * Expenditures 333,928 954,795 35.0% 342,193 995,771 34.4% 365,001 1,038,092 35.2% 366,794 1,042,102 35.2% 371,239 1,103,572 33.6% $1,200,000 $1,200,000 * - For prior years-total actual expenditures, for current year-total approved budget net of adjustment for contingencies. $200,000 $200,000 $0 $0 10-11 11-12 12-13 13-14 14-15 Better than Expected October YTD October YTD Expenditures Expenditures $1,000,000 $1,000,000 $800,000 $800,000 $600,000 $600,000 $400,000 $400,000 Annual Annual Expenditures * Expenditures * 10-11 10-11 11-12 12-13 13-14 11-12 12-13 14-15 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 2014-15, general fund expenditures were budgeted to increase 5.9% over fiscal year 2013-14 actuals. Through October 2014, general fund expenditures are performing better than expected as year to date expenditures are 1.2% higher than through October 2013. General Government Criminal Justice General Government October YTD Annual % of Annual Expenditures Expenditures * Expenditures 31,686 70,650 44.8% 35,042 98,577 35.5% 34,730 102,211 34.0% 39,058 100,400 38.9% 33,545 109,033 30.8% $120,000 $120,000 $100,000 $100,000 $80,000 $80,000 $60,000 $60,000 $40,000 $40,000 * - For prior years-total actual expenditures, for current year-total approved budget $20,000 $20,000 10-11 11-12 12-13 13-14 14-15 Better than Expected October YTD Expenditures October YTD Expenditures Annual Expenditures * Annual Expenditures * $0$0 10-11 11-12 11-12 10-11 12-13 12-13 13-14 13-14 14-15 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 October 2014 with a 14.1% decrease from the same period in the prior year. The decrease is primarily due to the receipt of Information Technology Services assessments from other funds for the FY2014-15 Tech Plan and Regional Wireless Cooperative costs. The fiscal year 2014-15 budget includes an 8.6% increase over fiscal year 2013-14 actuals. Year to date general government expenditures in the general fund through October 2014 are at their lowest level since fiscal year 2010-11. -1- October General Fund YTD Expenditures (Dollars in Thousands) Refer to detailed financial schedules pages 21 thru 33 Criminal Justice 10-11 11-12 12-13 13-14 14-15 October YTD Annual % of Annual Expenditures Expenditures * Expenditures 11,353 33,324 34.1% 11,440 33,542 34.1% 11,687 33,453 34.9% 11,453 32,659 35.1% 11,292 34,031 33.2% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected Criminal Justice Public Safety $40,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 $5,000 $10,000 $0 $5,000 October YTD Expenditures October YTD Expenditures Annual Expenditures * Annual Expenditures * 10-11 11-12 12-13 13-14 $0 10-11 11-12 12-13 13-14 14-15 Criminal justice expenditures include costs for municipal courts and public defenders. General fund criminal justice expenditures are better than expected through October 2014 with a 1.4% decrease from the same period in the prior year. The fiscal year 2014-15 budget includes a 4.2% increase over fiscal year 2013-14 actuals. General fund criminal justice expenditures have been relatively flat for the past four years with a variance of less than 3% between the highest and lowest year. Through October 2014, the year to date expenditures are lower than in the previous four years. Public Safety 10-11 11-12 12-13 13-14 14-15 Transportation Public Safety October YTD Annual % of Annual Expenditures Expenditures * Expenditures 215,800 639,691 33.7% 220,931 647,049 34.1% 237,059 684,609 34.6% 238,793 699,796 34.1% 249,916 726,963 34.4% * - For prior years-total actual expenditures, for current year-total approved budget Expected $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 10-11 11-12 12-13 13-14 $0 10-11 11-12 12-13 October YTD Expenditures October YTD Expenditures 14-15 Annual Expenditures * Annual Expenditures * 13-14 Public safety expenditures include costs for police and fire services. General fund public safety expenditures through October 2014 are performing as expected with a 4.6% increase over the same period in the prior year. The fiscal year 2014-15 budget includes a 3.9% increase over fiscal year 2013-14 actuals. - 2- October General Fund YTD Expenditures (Dollars in Thousands) Refer to detailed financial schedules pages 21 thru 33 Transportation 10-11 11-12 12-13 13-14 14-15 October YTD Annual % of Annual Expenditures Expenditures * Expenditures 13,668 38,711 35.3% 13,055 39,161 33.3% 14,528 38,161 38.1% 13,620 29,713 45.8% 14,161 39,756 35.6% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected Community Development Transportation $45,000 $40,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 October YTD Expenditures October YTD Expenditures Annual Annual Expenditures * Expenditures * 10-11 11-12 11-1212-13 12-13 10-11 13-14 13-14 14-15 Transportation expenditures include costs for public transit and street maintenance and repair. General fund transportation expenditures are better than expected through October 2014 with a 4.0% increase over the same period in the prior year. The fiscal year 2014-15 budget includes a 33.8% increase over fiscal year 2013-14 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 for fiscal year 2013-14. The 2014-15 budget includes the restoration of the General Fund support for Public Transit resulting in the large year over year increase. Community Development Community Enrichment Community Development 10-11 11-12 12-13 13-14 14-15 October YTD Annual % of Annual Expenditures Expenditures * Expenditures 6,948 19,458 35.7% 6,614 19,393 34.1% 6,936 19,927 34.8% 7,530 20,210 37.3% 7,153 22,241 32.2% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected $25,000 $25,000 October OctoberYTD YTD Expenditures Expenditures $20,000 $20,000 $15,000 $15,000 $10,000 $10,000 Annual Expenditures * Annual Expenditures * $5,000 $5,000 $0 $0 10-11 10-11 11-12 12-13 13-14 11-12 12-13 13-14 14-15 Community development expenditures include costs for economic development and neighborhood services. General fund community development expenditures are better than expected through October 2014 with a 5.0% decrease over the same period in the prior year. The fiscal year 2014-15 budget includes a 10.0% increase over fiscal year 2013-14 actuals. -3- October General Fund YTD Expenditures (Dollars in Thousands) Refer to detailed financial schedules pages 21 thru 33 Community Enrichment 10-11 11-12 12-13 13-14 14-15 October YTD Annual % of Annual Expenditures Expenditures * Expenditures 48,764 137,793 35.4% 49,594 140,026 35.4% 53,423 141,209 37.8% 52,141 143,665 36.3% 49,084 150,195 32.7% * - 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 10-11 11-12 12-13 13-14 10-11 11-12 12-13 OctoberYTD YTD October Expenditures Expenditures Annual Expenditures * Annual Expenditures * 14-15 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 October 2014 with a 5.9% decrease over the same period in the prior year. The fiscal year 2014-15 budget includes a 4.5% increase over fiscal year 2013-14 actuals. Environmental Services 10-11 11-12 12-13 13-14 14-15 October YTD Annual % of Annual Expenditures Expenditures * Expenditures 5,602 14,046 39.9% 5,172 15,723 32.9% 6,097 15,353 39.7% 4,084 13,748 29.7% 5,714 18,508 30.9% * - For prior years-total actual expenditures, for current year-total approved budget Monitor & Consider Corrective Action Environmental Total GeneralServices Fund $18,000 $20,000 $18,000 $16,000 $16,000 $14,000 $14,000 $12,000 $12,000 $10,000 $10,000 $8,000 $8,000 $6,000 $6,000 $4,000 $4,000 $2,000 $0 October YTD Expenditures Annual Expenditures * 10-11 10-11 11-12 12-13 12-13 11-12 13-14 13-14 14-15 Environmental service expenditures include costs for maintaining and operating city facilities. General Fund environmental services expenditures through October 2014 are 39.9% higher than the same period in the prior year. The increase is primarily due to a reduction in equipment management credits received by the general fund. The fiscal year 2014-15 budget includes a 34.6% increase over fiscal year 2013-14 actuals. -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. October Citywide YTD Expenditures (Dollars in Thousands) Refer to detailed financial schedules pages 21 thru 33 Total Citywide Operating 10-11 11-12 12-13 13-14 14-15 October YTD Annual % of Annual Expenditures Expenditures * Expenditures 1,087,013 3,026,005 35.9% 1,062,664 2,985,410 35.6% 1,126,589 3,123,865 36.1% 1,126,637 3,054,098 36.9% 1,153,556 3,512,673 32.8% * - 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 $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 October YTD October YTD Expenditures Expenditures Annual Annual Expenditures * Expenditures * 10-11 10-11 11-12 12-13 13-14 11-12 12-13 14-15 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 2014-15 anticipated an increase of 15.0% in total operating expenditures. Actual expenditures are better than expected with a year to date increase of 2.4% from the prior year through October 2014. General Government 10-11 11-12 12-13 13-14 14-15 October YTD Annual % of Annual Expenditures Expenditures * Expenditures 34,422 78,047 44.1% 35,627 109,658 32.5% 35,071 114,015 30.8% 39,828 114,235 34.9% 35,893 122,878 29.2% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected Criminal Justice General Government $120,000 $140,000 $100,000 $120,000 $80,000 $100,000 October YTD Expenditures October YTD Expenditures $80,000 $60,000 Annual Expenditures * $60,000 $40,000 $40,000 $20,000 $20,000 Annual Expenditures * $0 10-11 10-11 11-12 12-13 12-13 11-12 13-14 13-14 14-15 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 decrease of 9.9% through October 2014 from the prior October. The decrease is primarily due to the recovery of information technology costs from the enterprise funds for the tech plan and from the Regional Wireless Cooperative for shared site costs. The budget anticipated an increase of 7.6% for fiscal year 2014-15 over prior year actuals. -5- October Citywide YTD Expenditures (Dollars in Thousands) Refer to detailed financial schedules pages 21 thru 33 Criminal Justice 10-11 11-12 12-13 13-14 14-15 October YTD Annual % of Annual Expenditures Expenditures * Expenditures 13,725 36,958 37.1% 12,375 36,305 34.1% 14,379 41,290 34.8% 14,303 40,697 35.1% 14,116 46,819 30.2% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected Public Safety Criminal Justice $50,000 $200,000 $45,000 $40,000 $35,000 $30,000 $25,000 $20,000 $15,000 $10,000 $0 $5,000 $0 October YTD Expenditures October YTD Expenditures Annual Annual Expenditures * Expenditures * 10-11 10-11 11-12 11-12 12-13 12-13 13-14 13-14 14-15 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 October 2014 of 1.3% from the prior October. The budgeted increase for fiscal year 2014-15 over prior year actuals is 15.0%. Public Safety 10-11 11-12 12-13 13-14 14-15 Transportation Public Safety October YTD Annual % of Annual Expenditures Expenditures * Expenditures 266,901 792,002 33.7% 272,271 803,367 33.9% 290,165 842,387 34.4% 288,326 842,270 34.2% 291,994 874,993 33.4% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected $1,000,000 $900,000 $800,000 $800,000 $700,000 $600,000 $600,000 $500,000 $400,000 $400,000 $200,000 $300,000 $200,000 $0 $100,000 10-11 11-12 12-13 13-14 $0 10-11 11-12 12-13 October YTD Expenditures October YTD Expenditures 14-15 Annual Expenditures * Annual Expenditures * 13-14 Public Safety expenditures include costs of Police, Fire and Emergency Management. Citywide public safety expenditures are performing better than expected with year to date October 2014 expenditures 1.3% higher than the prior year. The budgeted increase for fiscal year 2014-15 over prior year actuals is 3.9%. -6- October Citywide YTD Expenditures (Dollars in Thousands) Refer to detailed financial schedules pages 21 thru 33 Transportation 10-11 11-12 12-13 13-14 14-15 October YTD Annual % of Annual Expenditures Expenditures * Expenditures 272,705 567,830 48.0% 287,458 584,429 49.2% 300,192 582,381 51.5% 298,138 573,025 52.0% 304,397 610,044 49.9% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected Transportation Community Development $700,000 $600,000 October YTD Expenditures October YTD Expenditures $500,000 $400,000 $400,000 $300,000 $300,000 $200,000 $200,000 $100,000 $100,000 $0 $0 Annual Annual Expenditures * Expenditures * 10-11 11-12 12-13 10-11 11-12 12-13 13-14 13-14 14-15 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 increase at October 2014 of 2.1% over the prior October. The budgeted increase for fiscal year 2014-15 over prior year actuals is 6.5%. Community Development 10-11 11-12 12-13 13-14 14-15 October YTD Annual % of Annual Expenditures Expenditures * Expenditures 63,888 176,114 36.3% 61,383 192,133 31.9% 77,758 209,403 37.1% 76,048 194,542 39.1% 71,263 230,064 31.0% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected CommunityDevelopment Enrichment Community $250,000 $250,000 OctoberYTD YTD October Expenditures Expenditures $200,000 $200,000 $150,000 $150,000 $100,000 $100,000 $50,000 $50,000 $0 $0 Annual Expenditures * Annual Expenditures * 10-11 10-11 11-12 12-13 11-12 12-13 13-14 13-14 14-15 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 October 2014 of 6.3% from the prior October. These expenditures were budgeted to increase 18.3% for fiscal year 2014-15 over prior year actuals. -7- October Citywide YTD Expenditures (Dollars in Thousands) Refer to detailed financial schedules pages 21 thru 33 Community Enrichment 10-11 11-12 12-13 13-14 14-15 October YTD Annual % of Annual Expenditures Expenditures * Expenditures 101,395 274,824 36.9% 97,093 272,353 35.6% 97,830 273,110 35.8% 96,409 272,326 35.4% 95,328 285,034 33.4% * - For prior years-total actual expenditures, for current year-total approved budget Environmental Services Community Enrichment $300,000 $300,000 OctoberYTD YTD October Expenditures Expenditures $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 Annual Expenditures * Annual Expenditures * 10-11 11-12 12-13 13-14 10-11 11-12 12-13 14-15 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 October 2014 of 1.1% from the prior October. The budgeted increase for fiscal year 2014-15 over prior year actuals is 4.7%. Environmental Services 10-11 11-12 12-13 13-14 14-15 October YTD Annual % of Annual Expenditures Expenditures * Expenditures 194,175 572,693 33.9% 184,272 549,628 33.5% 205,179 564,051 36.4% 196,601 577,118 34.1% 191,633 616,265 31.1% * - 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 $500,000 $500,000 $400,000 $400,000 $300,000 $300,000 $200,000 $200,000 $100,000 $100,000 $0 $0 10-11 10-11 OctoberYTD YTD October Expenditures Expenditures Annual Expenditures * Annual Expenditures * 11-12 11-12 12-13 13-14 12-13 13-14 14-15 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 decrease at October 2014 of 2.5% from the prior October. The budgeted increase for fiscal year 2014-15 over prior year actuals is 6.8%. -8- October Citywide YTD Expenditures (Dollars in Thousands) Refer to detailed financial schedules pages 21 thru 33 General Obligation Debt Service 10-11 11-12 12-13 13-14 14-15 October YTD Annual % of Annual Expenditures Expenditures * Expenditures 64,121 196,779 32.6% 56,307 157,298 35.8% 45,465 137,208 33.1% 33,596 100,524 33.4% 44,793 148,544 30.2% * - For prior years-total actual expenditures, for current year-total approved budget net of credit for early redemption fund resources Better than Expected General Obligation Debt Service Total Citywide $250,000 $250,000 OctoberYTD YTD October Expenditures Expenditures $200,000 $200,000 $150,000 $150,000 $100,000 $100,000 Annual Expenditures * Annual Expenditures * $50,000 $50,000 $0 $010-11 11-12 12-13 10-11 11-12 13-14 12-13 14-15 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 $74.4 million over the amount recorded on the accompanying statements. The approved budget includes a credit for $74.4 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 better than expected. Budgeted expenditures for fiscal year 2014-15 are 47.8% higher than actual expenditures for the prior fiscal year. Through October 2014, year to date expenditures are 33.3% higher than the prior October. -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 21 - 33 10-11 11-12 12-13 13-14 14-15 (Budget) $ 388,422 $ 232,848 $ 320,599 $ 263,112 $ 511,681 Discussion: 14-15 (YTD) $ 57,236 General Gov't 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). 14-15 (YTD) 14-15 (Budget) 13-14 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, Sonoran Desert Drive-$14 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). 12-13 11-12 10-11 $0 $200,000 $400,000 $600,000 Major Projects planned for fiscal year 2014-15 include the replacement of the City’s telephone system and data network ($36 million), continued work on Avenida Rio Salado and Black Mountain Blvd ramps to SR51 ($28 million), and an upgrade to the South Transit Facility ($19 million). Aviation 10-11 11-12 12-13 13-14 14-15 (Budget) 14-15 (YTD) $ 157,884 $ 332,920 $ 168,639 $ 180,571 $ 319,309 $ 151,731 Discussion: Aviation 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 spent $19 million on Terminal Development Concept Design. 14-15 (YTD) 14-15 (Budget) 13-14 Aviation has spent or committed $115.5 million of an expected $126 million in fiscal year 2014-15 for the Terminal Development Concept Design. In addition to normal reinvestment in the infrastructure of the airport system Aviation is planning to spend $23 million on Terminal 4 International Expansion. 12-13 11-12 10-11 $0 $100,000 $200,000 $300,000 - 10 - Capital Expenditures (Dollars in Thousands) 10-11 Phx Convention Ctr $ 4,493 Refer to detailed financial schedules pages 21 - 33 11-12 $ 1,644 12-13 $ 14-15 (Budget) 13-14 21,830 Discussion: $ 23,189 $ 26,317 14-15 (YTD) $ 8,386 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 and fiscal year 2013-14 that payment was $20 million. 14-15 (YTD) 14-15 (Budget) 13-14 12-13 Phoenix Convention Center has included another $20 million debt service payment in the fiscal year 2014-15 capital budget. 11-12 10-11 $0 10-11 Solid Waste $ 22,640 11-12 $ 15,512 8,605 14-15 (Budget) 13-14 12-13 $ $10,000 $ 8,063 $ 36,550 $20,000 $30,000 14-15 (YTD) $ 431 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. In fiscal year 2013-14, projects included $3.5 million for methane gas systems at closed landfills and $3 million for a park in Buckeye as part of the intergovernmental agreement for the Buckeye landfill. 14-15 (YTD) 14-15 (Budget) 13-14 12-13 11-12 10-11 $0 $10,000 $20,000 $30,000 $40,000 The fiscal year 2014-15 capital budget for Solid Waste includes $12 million for a Composting Facility at the 27th Avenue site. - 11 - Capital Expenditures (Dollars in Thousands) 10-11 Wastewater $ 41,347 11-12 $ 66,342 Refer to detailed financial schedules pages 21 - 33 14-15 (Budget) 13-14 12-13 $ 109,914 $ 58,012 Discussion: $ 131,222 14-15 (YTD) $ 3,961 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. 14-15 (YTD) 14-15 (Budget) 13-14 In fiscal year 2014-15 Wastewater is planning to begin work on the SROG Interceptor, spending $8 million. 12-13 11-12 10-11 $0 10-11 Water System $ 246,177 11-12 $ 95,990 $50,000 12-13 13-14 14-15 (Budget) $ 110,333 $ 129,080 $ 203,162 $100,000 $150,000 14-15 (YTD) $ 51,143 Discussion: Water System 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). 14-15 (YTD) 14-15 (Budget) 13-14 Major projects in fiscal year 2013-14 include construction of a new 20 million gallon concrete reservoir at Deer Valley WTP ($16 million). 12-13 11-12 10-11 $0 $100,000 $200,000 $300,000 Through October 2014, the water system has spent or committed $9.3 million for rehabilitation at the 24th Street water treatment plant and $24.0 million for improvements to the solids handling facility at the Union Hills water treatment plant. In addition to normal reinvestment in the infrastructure of the water system, an upgrade to the Customer Care and Billing system costing $7 million is planned in fiscal year 2014-15. - 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 21 thru 33 General Fund Revenues $1,200,000 $1,000,000 Oct YTD Actuals $800,000 $600,000 $400,000 Annual Revenues* $200,000 $0 10-11 10-11 11-12 12-13 13-14 14-15 Oct YTD Actuals 277,353 274,453 283,476 300,810 307,983 Annual Revenues* 962,689 948,384 980,945 1,026,167 1,060,289 11-12 12-13 13-14 14-15 % of Annual Revenues 28.8% 28.9% 28.9% 29.3% 29.0% * - For prior years - total actual revenues, for current year - total approved budget Expected Fiscal Year 2014-15 general fund operating revenues were budgeted to increase 3.3% over prior year actuals. Actual year over year revenues are performing as expected with growth through October 2014 of 2.4%. Specific revenue sources are discussed on the following pages. - 13 - Property Taxes (Dollars in Thousands) Refer to detailed financial schedules pages 21 thru 33 Property Taxes Primary & Secondary 300,000 250,000 200,000 Secondary 149,019 94,436 62,012 35,204 50,404 130,913 128,054 132,101 143,931 137,956 10-11 11-12 12-13 13-14 150,000 Primary 100,000 50,000 $ 3 ,3 5 7 - FY 10-11 11-12 12-13 13-14 14-15 YTD 14-15 budget 9 ,4 5 0 Total 279,932 222,488 194,112 179,136 12,807 188,360 July (3,017) (2,553) (1,733) (1,260) (1,107) (1,754) Aug 1,118 1,059 1,349 971 760 1,068 Sept 1,279 1,189 904 867 816 936 Oct 18,792 13,656 11,888 11,107 12,338 11,588 14-15 YTD 14-15 budget Nov 85,251 55,555 54,091 46,645 Dec 34,444 40,845 31,075 32,028 Jan 9,642 7,689 7,015 7,180 Feb 5,599 5,685 4,743 3,818 Mar 10,676 8,871 6,670 5,668 Apr 14,532 11,013 8,323 7,300 May 68,087 35,952 44,111 44,562 June 33,529 43,527 25,676 20,250 49,416 32,866 6,919 4,504 6,706 8,422 39,405 28,284 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 the chart for property tax revenues is presented with an annual perspective. Property tax revenues are better than expected through October 2014 with a 9.6% increase over the prior October. Property tax revenues are budgeted to increase 5.1% in fiscal year 201415 over prior year actuals. Total property tax revenues have been decreasing each year since fiscal year 2009-10 with fiscal year 2014-15 anticipated to be the first year where the revenues will start to see recovery. - 14 - Local Sales Tax (Dollars in Thousands) Refer to detailed financial schedules pages 21 thru 33 Local Sales Tax Budget vs Actual 40,000 39,000 38,000 37,000 36,000 35,000 14-15 Actuals 34,000 14-15 budget 33,000 32,000 31,000 30,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June Corrective Action Taken Local sales tax revenues through October 2014 are 1.9% below budget for that period. Based on the low sales tax revenue collections through October, the budget and research department has lowered their estimate for annual local sales tax revenues by $15.5 million. Expenditures are being monitored to ensure that they do not exceed the available resources based on this new estimate. Local Sales Tax 3 Year Trend 45,000 40,000 35,000 30,000 25,000 12-13 Actuals 20,000 13-14 Actuals 15,000 14-15 Actuals 10,000 5,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June Local sales tax revenues saw a net increase from fiscal year 2012-13 to fiscal year 2013-14. However, in six of the nine reporting months since the decrease of the food tax from 2% to 1%, local sales tax revenues have shown a year over year decline, resulting in a net year over year decrease of 1.7% for that period. Click Here for Additional Information - 15 - State Sales Tax (Dollars in Thousands) Refer to detailed financial schedules pages 21 thru 33 State Sales Tax Budget vs Actual 16,000 14,000 12,000 10,000 14-15 Actuals 14-15 budget 8,000 6,000 4,000 2,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June Monitor & Consider Corrective Action State shared sales tax revenues through October 2014 are 2.0% below the budget estimates for the same period. State Sales Tax 3 Year Trend 14,000 12,000 10,000 8,000 12-13 Actuals 13-14 Actuals 6,000 14-15 Actuals 4,000 2,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June Fiscal year 2013-14 state shared sales tax revenues were 7.0% higher than fiscal year 2012-13. This growth rate is nearly 75% greater than the 4.1% growth rate from fiscal year 2011-12 to fiscal year 2012-13 reflecting continued economic recovery. Through October 2014 state shared sales tax revenues were 4.6% higher than through October 2013. Click Here for Additional Information - 16 - Vehicle License Tax (Dollars in Thousands) Refer to detailed financial schedules pages 21 thru 33 Vehicle License Tax Budget vs Actual 6,000 5,000 4,000 14-15 Actuals 3,000 Budget 14-15 2,000 1,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June Monitor & Consider Corrective Action State shared vehicle license tax revenues through October 2014 are 1.4% lower than budget expectations for the same period. Vehicle License Tax 3 Year Trend 6,000 5,000 4,000 12-13 Actuals 3,000 13-14 Actuals 2,000 14-15 Actuals 1,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June State shared vehicle license tax revenues for fiscal year 2013-14 increased 6.9% over fiscal year 2012-13. This follows a 4.2% increase for fiscal year 2012-13 over fiscal year 2011-12. Revenues through October 2014 were 4.7% higher than through October 2013. Click Here for Additional Information - 17 - Aviation Revenues (Dollars in Thousands) Refer to detailed financial schedules pages 21 thru 33 Aviation Operating Revenues Budget vs Actual 35,000 30,000 25,000 14-15 Actuals 20,000 Budget 14-15 15,000 10,000 5,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June Better than Expected Aviation revenues through October 2014 were better than expected at 2.3% higher than budget expectations for the same period. Aviation Operating Revenues 3 Year Trend 40,000 35,000 30,000 25,000 12-13 Actuals 20,000 13-14 Actuals 15,000 14-15 Actuals 10,000 5,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June In the above chart, fiscal year 2012-13 includes customer facility charge revenues. 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. In fiscal year 2012-13, those revenues amounted to $41.4 million. Through October 2014, aviation operating revenues are 1.4% higher than through October 2013. Click Here for Additional Information - 18 - Water System Revenues (Dollars in Thousands) Refer to detailed financial schedules pages 21 thru 33 Water System Operating Revenues Budget vs Actual 60,000 50,000 40,000 14-15 Actuals Budget 14-15 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 13.4% below budget projections through October 2014 reflecting the record setting rainfall received in the 2014 monsoon. Water System Operating Revenues 3 Year Trend 90,000 80,000 70,000 12-13 Actuals 60,000 50,000 13-14 Actuals 40,000 14-15 Actuals 30,000 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. Primarily due to the large amount of rainfall received in August and September 2014, year to date revenues through October 2014 are 5.4% below revenues through October 2013. Click Here for Additional Information - 19 - Wastewater Revenues (Dollars in Thousands) Refer to detailed financial schedules pages 21 thru 33 Wastewater Operating Revenues Budget vs Actual 25,000 20,000 15,000 14-15 Actuals Budget 14-15 10,000 5,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June Better than Expected Wastewater revenues through October 2014 are better than expected at 2.7% higher than budget expectations for the same time frame. Wastewater Operating Revenues 3 Year Trend 30,000 25,000 20,000 12-13 Actuals 13-14 Actuals 15,000 14-15 Actuals 10,000 5,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May While wastewater rates have not changed since the rate decrease in July 2012, annual revenues have increased slightly each year due to account growth. Click Here for Additional Information - 20 - June 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 October 31 (dollars in thousands) Budget Estimate 2014-15 Actual Year-to-Date 2014-15 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 $ $ 431,320 2,541 $ 141,689 $ 188 142,890 361 135,474 175,174 54,300 137,956 2,833 9,495 41,674 58,395 18,131 9,450 806 2,260 39,859 53,761 17,318 9,423 839 2,430 17,722 1,015 13,487 1,025 7,361 1,431 3,928 5,057 232 4,627 306 2,418 375 2,179 5,508 260 3,130 319 2,357 446 1,266 32,500 13,596 1,800 17,331 10,234 4,001 824 5,137 10,032 3,001 562 7,048 1,060,289 - 21 - $ 307,983 $ 300,810 General Fund Expenditures As of October 31 (dollars in thousands) Budget Estimate 2014-15 Actual Year-to-Date 2014-15 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,831 3,537 2,366 37,168 2,072 2,336 19,960 2,410 4,244 9,871 2,956 18,277 2,005 109,033 544 $ 1,141 1,120 9,332 605 887 6,399 1,107 1,040 3,158 1,092 5,729 1,391 33,545 592 1,155 1,334 12,604 891 825 6,852 1,008 1,414 3,100 1,210 6,829 1,244 39,058 29,049 4,982 34,031 9,682 1,610 11,292 9,986 1,467 11,453 471,386 255,563 14 726,963 162,106 87,799 11 249,916 155,470 83,371 (48) 238,793 Transportation Street Transportation Public Transit Total Transportation 21,554 18,202 39,756 7,039 7,122 14,161 7,076 6,544 13,620 Community Development Economic Development Neighborhood Services Department Planning and Development Others Total Community Development 4,796 12,481 4,910 54 22,241 1,650 4,000 1,487 16 7,153 1,708 4,212 1,590 20 7,530 Community Enrichment Parks and Recreation Library Human Services Others Total Community Enrichment 92,913 35,515 18,895 2,872 150,195 30,984 11,384 5,367 1,349 49,084 33,166 11,612 6,211 1,152 52,141 Environmental Services Public Works Environmental Programs Total Environmental Services 17,663 845 18,508 5,532 182 5,714 3,819 265 4,084 2,845 374 115 - - Criminal Justice Municipal Court Public Defender Total Criminal Justice Public Safety Police Fire Others Total Public Safety Capital Improvement Contingencies Total Expenditures and Encumbrances $ 45,268 $ 1,148,840 - 22 - $ 371,239 $ 366,794 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 October 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 2014-15 $ Total General Funds 431,320 2,541 $ 142,890 361 39,859 53,761 17,318 9,423 839 2,430 5,768 3,130 319 2,357 446 1,266 13,033 562 7,048 1,060,289 307,983 300,810 31,135 88,346 31,337 8,716 167,198 4,386 42,783 15,470 16,701 106,783 46,597 2,609 44,684 282,747 55,333 9,820 29,684 9,755 1,185 52,801 7,116 18,321 4,999 3,812 34,312 9,735 1,218 12,989 48,086 3,357 9,357 28,956 9,269 1,228 56,626 6,201 17,952 5,248 3,751 31,484 7,760 1,966 10,557 71,353 2,260 944,825 247,190 263,968 322,353 63,497 415,361 214,792 150,150 108,483 16,969 158,162 72,935 49,697 106,978 15,888 167,215 71,908 49,452 1,166,153 406,246 411,441 961,419 $ 976,219 Enterprise Funds Aviation Convention Center Water System Wastewater Solid Waste $ 141,689 188 41,674 58,395 18,131 9,450 806 2,260 5,289 4,627 306 2,418 375 2,179 14,235 824 5,137 Total Special Revenue and Debt Service Funds Total Operating Revenues $ 135,474 175,174 54,300 137,956 2,833 9,495 18,737 13,487 1,025 7,361 1,431 3,928 46,096 1,800 17,331 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 Enterprise Funds Actual Year-to-Date 2014-15 2013-14 3,171,267 - 23 - $ Citywide Operating Expenditures As of October 31 (dollars in thousands) Source General Government General Funds Other Funds Total General Government Actual Year-to-Date 2014-15 2013-14 Budget 2014-15 $ 33,545 $ 2,348 35,893 39,058 770 39,828 34,031 12,788 46,819 11,292 2,824 14,116 11,453 2,850 14,303 Public Safety General Funds Other Funds Total Public Safety 726,963 148,030 874,993 249,916 42,078 291,994 238,793 49,533 288,326 Transportation General Funds Other Funds Total Transportation 39,756 570,288 610,044 14,161 290,236 304,397 13,620 284,518 298,138 Community Development General Funds Other Funds Total Community Development 22,241 207,823 230,064 7,153 64,110 71,263 7,530 68,518 76,048 Community Enrichment General Funds Other Funds Total Community Enrichment 150,195 134,839 285,034 49,084 46,244 95,328 52,141 44,268 96,409 Environmental Services General Funds Other Funds Total Environmental Services 18,508 597,757 616,265 5,714 185,920 191,634 4,084 192,517 196,601 74,164 74,164 44,793 44,793 33,596 33,596 2,845 575,187 578,032 374 103,764 104,138 115 83,273 83,388 Criminal Justice General Funds Other Funds Total Criminal Justice 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 109,033 13,845 122,878 $ 45,268 48,500 93,768 $ 1,148,840 2,383,221 3,532,061 - 24 - - $ 371,239 782,317 1,153,556 $ 366,794 759,843 1,126,637 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 October 31 2014 2013 Budget Estimate 2014-15 Source Actual Year-to-Date 2013-14 2014-15 General Funds $ 34,620,746 32,173 $ 35,068,147 196,587 Local Taxes: Sales Taxes Privilege License Fees $ 431,320,000 2,541,000 $ 141,689,182 188,108 $ 142,890,487 361,286 34,652,919 35,264,734 Total Local Taxes 433,861,000 141,877,290 143,251,773 10,306,594 14,598,649 4,414,637 9,922,607 13,440,181 3,911,537 State Shared Taxes: State Sales Tax State Income Tax Vehicle License Tax 135,474,000 175,174,000 54,300,000 41,673,951 58,394,598 18,130,876 39,858,942 53,760,724 17,318,080 29,319,880 27,274,325 364,948,000 118,199,425 110,937,746 9,008,803 8,891,959 Primary Property Tax 137,956,000 9,450,111 9,422,590 133,359 168,492 Licenses and Permits 2,833,000 805,561 839,340 2,256,975 2,432,106 Cable Communications 9,495,000 2,260,237 2,430,105 1,259,968 58,845 1,329,435 62,961 Municipal Court: Fines and Forfeitures Court Default Fee 17,721,789 1,015,000 5,056,958 232,405 5,507,991 260,456 1,318,813 1,392,396 18,736,789 5,289,363 5,768,447 1,283,428 1,094,415 13,487,000 4,627,291 3,129,443 23,849 67,993 Library Fees 1,025,000 305,626 318,877 713,451 510,253 Parks and Recreation 7,361,300 2,417,593 2,357,340 85,310 104,655 Planning and Development 1,431,400 375,508 445,471 730,382 514,976 Street Transportation 3,928,108 2,178,853 1,265,653 3,029,720 58,600 1,602,505 2,099,489 50,150 282,920 32,500,000 1,400,000 12,195,773 10,233,813 245,359 3,755,954 10,031,964 192,225 2,808,709 4,690,825 2,432,559 46,095,773 14,235,126 13,032,898 206,785 249,934 1,800,000 824,359 562,012 2,241,771 2,376,402 17,330,894 5,136,514 7,048,420 86,666,550 82,775,199 1,060,289,264 307,982,857 300,810,115 Total State Shared Taxes Total Municipal Court Police Fire: Emergency Transportation Service Hazardous Materials Inspection Fee Other Total Fire Interest Other Fees and Service Charges Total General Funds - 25 - Citywide Operating Revenue by Source (continued) For the Month Ended October 31 2014 2013 Budget Estimate 2014-15 Source Actual Year-to-Date 2013-14 2014-15 Special Revenue and Debt Service Funds $ 1,664,135 118,867 594,334 59,836 $ 1,577,272 112,663 563,310 7,244 2,437,172 2,260,489 5,378,419 1,916,064 (21,571) 5,221,533 1,891,957 (8,801) 7,272,912 7,104,689 2,400,008 2,268,647 183,631 12,113 128,565 (3,547) 1,942 218,665 5,243 169,044 (5,068) 6,562 322,704 394,446 8,576,663 3,325,570 9,012,983 5,863,710 11,902,233 14,876,693 - - 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,791,000 1,556,000 7,783,000 5,000 Transit 2000: Sales Taxes Interest/Other Total Transit 2000 Court Awards 6,772,431 483,745 2,418,725 145,221 $ 6,441,805 460,129 2,300,644 154,536 31,135,000 9,820,122 9,357,114 66,032,000 22,381,000 (67,500) 21,918,853 7,816,455 (51,655) 21,285,525 7,702,534 (32,020) 88,345,500 29,683,653 28,956,039 31,337,000 9,755,470 9,269,050 5,722,702 311,350 2,352,140 (70,000) 399,500 Total Golf Courses $ 670,721 31,688 504,540 (11,773) (10,093) 682,736 19,704 549,357 (17,762) (5,953) 8,715,692 1,185,083 1,228,082 115,177,000 52,021,458 34,911,955 17,888,970 36,810,315 19,815,648 167,198,458 52,800,925 56,625,963 4,385,818 7,115,640 6,200,633 3,332,913 3,088,508 Planning and Development 42,783,000 18,321,099 17,952,261 1,215,131 1,298,619 Capital Construction 15,470,000 4,998,913 5,247,835 1,004,341 11,576 993,105 10,908 Sports Facilities: Sales Taxes Interest/Other 16,451,000 250,000 3,763,156 49,149 3,705,036 46,025 1,015,917 1,004,013 16,701,000 3,812,305 3,751,061 Total Sports Facilities - 26 - Citywide Operating Revenue by Source (continued) For the Month Ended October 31 2014 2013 Budget Estimate 2014-15 Source Actual Year-to-Date 2013-14 2014-15 Special Revenue and Debt Service Funds (Cont'd) $ Highway User Revenue: Highway User Revenue Interest Other 8,220,797 30,595 2,797 7,613,389 18,527 222,175 8,254,189 7,854,091 2,754,239 1,459,870 40,019 332,585 8,501,359 4,912,671 Other Restricted Fees 575,928 3,738,926 284,720 Grants: Public Housing: Rentals Grants Other 575,759 5,584,107 413,476 $ 6,573,342 4,599,574 3,280,395 3,129,343 34,140 3,338,770 2,342,948 454,345 69,599 4,461,295 9,782,648 7,328,187 16,355,990 11,927,761 3,329,451 - 2,214,792 397 3,329,451 2,215,189 69,134,237 60,998,271 106,383,000 200,000 200,000 34,054,878 104,088 152,949 31,149,747 63,226 271,173 106,783,000 34,311,915 31,484,146 Regional Transit Revenues 46,596,781 9,734,647 7,760,012 Community Reinvestment 2,608,664 1,218,067 1,966,038 44,684,752 12,988,929 10,556,477 Total Highway User Revenue $ Total Public Housing 7,109,137 74,501,952 4,714,782 $ 2,155,586 20,562,595 586,158 $ 2,140,950 16,882,433 1,854,460 86,325,871 23,304,339 20,877,843 40,078,832 72,253,928 31,945,433 52,142,725 7,351,687 1,974,554 4,876,510 10,578,414 7,370,605 22,032,283 4,950,716 16,121,759 Total Other 196,420,918 24,781,165 50,475,363 Total Grants 282,746,789 48,085,504 71,353,206 50,404,017 4,928,832 3,357,292 177 2,261,455 (1,595) 55,332,849 3,357,469 2,259,860 944,824,303 247,189,741 263,967,777 131,840,000 182,337,300 800,000 2,498,000 1,895,125 2,982,075 - 33,718,060 71,641,600 224,852 1,091,411 716,475 974,780 115,438 322,352,500 108,482,616 Other: Human Resources Federal Transit Administration Community Development Other G.O. Bond/Secondary Property Tax Secondary Property Tax Interest Total G.O. Bond/Secondary Property Tax Total Special Revenue and Debt Service Funds Enterprise Funds AVIATION: 8,050,069 17,581,060 23,541 403,578 183,575 234,213 13,068 8,233,067 17,628,399 (63,290) 184,906 151,577 244,177 126,430 26,489,104 26,505,266 Sky Harbor: Airlines Concessions Interest Other Phoenix-Goodyear Phoenix-Deer Valley Phoenix-Customer Facility Charge Total Aviation - 27 - 33,864,230 70,236,798 278,313 940,799 687,322 979,795 (8,918) 106,978,339 Citywide Operating Revenue by Source (continued) For the Month Ended October 31 2014 2013 Budget Estimate 2014-15 Source Actual Year-to-Date 2014-15 2013-14 Enterprise Funds (Cont'd) CONVENTION CENTER: 3,271,468 1,002,670 26,001 3,168,188 969,920 20,442 4,300,139 4,158,550 Excise Taxes Operating Revenue Interest Total Convention Center 47,993,000 15,328,192 175,863 13,280,983 3,601,702 85,991 12,543,680 3,274,949 68,966 63,497,055 16,968,676 15,887,595 WATER SYSTEM: $ 28,714,626 507,188 430,508 598,681 98,820 251,070 248 $ 30,601,141 32,736,778 581,525 293,454 480,144 137,100 191,286 496,680 34,916,967 Water Sales Water Service Fees Distribution Intergovernmental Development Fees Interest Other $ Total Water System 393,242,000 6,000,000 4,340,000 6,826,000 2,600,000 2,342,000 11,000 $ 149,780,816 1,821,469 2,048,313 2,594,165 623,820 872,950 420,705 $ 158,804,821 2,134,983 1,736,056 1,915,022 677,400 625,515 1,321,375 415,361,000 158,162,238 167,215,172 182,029,000 16,199,000 2,400,000 1,348,000 12,816,000 60,933,037 6,492,533 586,620 456,549 4,466,207 60,496,954 6,343,203 639,600 393,284 4,034,708 214,792,000 72,934,946 71,907,749 128,235,000 9,720,000 270,000 11,925,446 42,555,197 2,933,648 160,330 4,048,337 42,218,425 3,058,869 121,175 4,053,750 150,150,446 49,697,512 49,452,219 1,166,153,001 406,245,988 411,441,074 WASTEWATER: 15,175,351 1,521,548 87,420 134,032 835,452 15,110,130 1,513,997 133,200 117,186 923,549 17,753,803 17,798,062 Sewer Service Charges Multi-City Development Fees Interest Other Total Wastewater SOLID WASTE: $ 10,643,157 750,869 45,296 1,043,986 10,555,487 913,462 30,190 1,007,532 12,483,308 12,506,671 91,627,495 95,885,516 247,428,282 $ 239,658,986 Collection Fees Landfill Fees Interest Other Total Solid Waste Total Enterprise Funds Total Operating Revenues $ - 28 - 3,171,266,568 $ 961,418,586 $ 976,218,966 Citywide Operating Expenditures by Program For the Month Ended October 31 2014 2013 Budget Estimate 2014-15 Program Actual Year-to-Date 2014-15 2013-14 2014-15 Year-to-Date Operating Expenditures & Encumbrances Capital Operations and Debt General Government $ 139,861 $ 281,031 279,048 6,645,464 135,688 185,209 334,477 1,902,113 161,254 267,305 78,405 1,002,413 181,113 6,231 292,033 1,564,620 (4,829,775) 8,626,490 141,426 278,357 570,676 2,545,862 216,737 221,738 218,231 1,796,346 131,337 356,113 66,081 920,978 25,757 6,240 271,045 1,807,317 (2,616,321) 6,957,920 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,831,282 3,536,455 2,598,527 39,623,947 1,295,862 2,410,636 2,925,130 20,973,333 2,409,910 4,244,327 616,163 11,446,511 92,797 2,955,905 21,198,759 4,718,242 $ 543,910 1,140,693 1,054,708 10,097,846 444,199 749,012 1,020,296 6,726,881 1,107,091 1,039,881 321,707 3,707,066 613,748 26,616 1,092,128 6,623,639 (416,029) $ 592,364 1,154,813 1,439,943 13,312,936 558,483 990,067 960,279 7,189,260 1,008,498 1,414,070 615,868 3,443,202 41,464 28,452 1,209,566 8,060,158 (2,191,126) $ 543,910 1,140,693 1,054,708 9,569,773 444,199 749,012 1,020,296 6,726,881 1,107,091 1,039,881 321,707 3,324,056 613,748 26,616 1,092,128 6,569,995 (416,029) $ 528,073 383,010 53,644 - 122,877,786 35,893,392 39,828,297 34,928,665 964,727 41,837,569 4,981,585 12,506,170 1,610,063 12,835,267 1,467,281 10,339,648 1,610,063 2,166,522 - 46,819,154 14,116,233 14,302,548 11,949,711 2,166,522 570,433,037 304,086,736 472,781 191,683,871 100,132,709 177,613 191,139,240 97,069,298 117,510 189,370,140 98,930,152 177,613 2,313,731 1,202,557 - 874,992,554 291,994,193 288,326,048 288,477,905 3,516,288 Criminal Justice 3,057,957 405,080 2,903,465 360,082 3,463,037 3,263,547 Municipal Court Public Defender Total Criminal Justice Public Safety 45,305,967 24,634,600 54,579 48,145,281 24,387,944 (30,272) 69,995,146 72,502,953 Police Fire Other Total Public Safety - 29 - Citywide Operating Expenditures by Program (continued) For the Month Ended October 31 2014 2013 Budget Estimate 2014-15 Program Actual Year-to-Date 2014-15 2013-14 2014-15 Year-to-Date Operating Expenditures & Encumbrances Capital Operations and Debt Transportation $ 5,587,080 972,534 26,832,874 6,975,700 40,368,188 $ 4,816,258 847,008 23,173,510 6,324,495 35,161,271 Street Transportation Street Lighting Aviation Public Transit Total Transportation $ 60,347,257 11,676,247 285,060,223 252,960,307 $ 20,319,491 3,878,747 92,756,402 187,442,577 $ 20,027,007 3,680,289 90,740,511 183,690,204 $ 20,279,868 3,878,747 75,962,485 168,455,191 $ 39,623 16,793,917 18,987,386 610,044,034 304,397,217 298,138,011 268,576,291 35,820,926 Community Development 3,247,838 2,385,860 4,685,698 3,302,577 3,472,724 6,247,528 4,442,015 5,626,722 Planning and Development Housing Economic Development Neighborhood Services Department 46,760,869 88,592,415 35,505,370 59,205,414 13,390,390 27,208,816 19,056,941 11,606,802 13,036,169 26,587,875 18,408,696 18,015,003 13,390,390 27,183,619 7,606,546 11,606,802 25,197 11,450,395 - 13,621,973 19,788,989 Total Community Development 230,064,068 71,262,949 76,047,743 59,787,357 11,475,592 102,825,230 36,062,173 8,354,628 60,752,841 11,048,412 60,440,955 4,007,435 1,542,517 33,878,935 11,527,957 2,476,822 24,470,211 3,686,580 17,147,183 1,158,405 982,136 35,464,625 11,848,273 2,469,408 23,564,591 3,644,903 17,424,161 1,183,172 809,644 33,239,284 11,527,957 2,476,822 18,274,527 17,049,364 1,158,405 982,136 639,651 6,195,684 3,686,580 97,819 - 285,034,191 95,328,229 96,408,777 84,708,495 10,619,734 Community Enrichment 7,808,388 3,637,812 571,499 11,592,102 920,389 4,829,730 329,427 100,739 29,790,086 8,004,608 2,729,729 643,820 3,572,159 910,103 4,845,463 410,599 (59,137) 21,057,344 Parks and Recreation Library Golf Convention Center Sports and Cultural Facilities Human Services Public Parking Facilities Other Total Community Enrichment - 30 - Citywide Operating Expenditures by Program (continued) For the Month Ended October 31 2014 2013 Budget Estimate 2014-15 Program 2014-15 Year-to-Date Operating Expenditures & Encumbrances Capital Operations and Debt Actual Year-to-Date 2014-15 2013-14 Environmental Services $ 29,173,054 $ 11,432,658 11,204,985 2,612,041 (350,265) 26,683,012 11,284,412 14,081,447 1,286,922 122,796 54,072,473 53,458,589 Water System Wastewater Solid Waste Management Public Works Environmental Programs $ Total Environmental Services 371,308,322 75,410,036 146,831,385 21,384,796 1,330,589 $ 616,265,128 102,470,111 41,792,080 39,733,406 7,681,997 (44,692) $ 100,794,857 46,643,672 42,918,167 5,742,011 502,552 $ 63,798,490 23,389,901 35,389,131 5,546,803 (44,692) $ 128,079,633 38,671,621 18,402,179 4,344,275 2,135,194 - 191,632,902 196,601,259 63,553,269 4,441,975 12,231,905 26,136,496 874,035 6,199,154 698,890 12,109,390 2,023,464 7,501,731 8,068,835 1,274,411 14,276,351 50,200 10,019,078 3,684,108 3,136,383 (74,379,600) 3,264,075 16,211,189 8,976,399 86,813 7,279,133 69,971 3,799,542 8,712,165 291,345 2,044,030 228,561 4,007,480 674,488 2,457,201 2,569,836 418,794 3,638,469 16,704 3,294,480 1,227,670 949,703 125,970 914,063 4,010,707 2,942,886 2,130 2,396,762 288,735 3,036,992 2,808,832 112,511 1,538,051 230,222 1,627,879 209,488 2,400,935 2,595,069 391,137 4,830,763 16,733 2,421,392 426,369 955,071 2,200 312,692 5,161,839 1,826,633 2,271 2,399,699 - 69,971 3,799,542 8,712,165 291,345 2,044,030 228,561 4,007,480 674,488 2,457,201 2,569,836 418,794 3,638,469 16,704 3,294,480 1,227,670 949,703 125,970 914,063 4,010,707 2,942,886 2,130 2,396,762 General Obligation Debt Service 17,493 949,885 2,178,041 72,836 511,007 57,140 1,001,870 168,622 614,300 642,459 104,698 909,617 4,176 823,620 306,918 237,426 7 228,516 1,002,677 735,722 533 - 72,184 759,248 702,208 28,127 384,513 57,556 406,970 52,372 600,233 648,767 97,784 1,207,691 4,183 605,348 106,592 238,768 78,173 1,290,459 456,659 568 599,765 10,567,563 8,398,168 Total Debt Service 74,164,415 44,792,957 33,595,513 - 44,792,957 38,124,336 30,425,764 Capital Improvement 578,031,992 104,137,987 83,388,575 - 104,137,987 $ 268,629,292 $ 251,014,545 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 93,768,000 $ - 3,532,061,322 $ - 31 - 1,153,556,059 $ 1,126,636,771 $ 876,508,057 $ 277,048,002 Capital Expenditures and Encumbrances 2014-15 Program 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 2013-14 Actual Yearto-Date Actual Yearto-Date $ 1,125,574 $ 8,545,966 1,200,000 12,450,845 2,436,721 11,744,923 1,406,342 36,572,478 609,000 49,848,470 1,476,482 6,350,452 73,248,002 3,250,325 123,636,622 17,957,644 159,820,808 1,388 $ 755,638 535,455 1,705,654 1,700,689 311,449 3,804 1,203,475 11,592 8,346,005 306,362 106,013 6,558,624 271,592 7,470,333 108,521 27,839,574 389,376 731,941 2,438,873 1,699,553 3,700,000 1,239,175 121,158 5,465,984 464,690 8,119,789 22,941 372,433 4,561,529 4,523,680 8,034,665 23,340 44,501,463 Total Capital Improvement Program $ 511,680,654 $ 57,236,168 $ 86,410,590 Enterprise Aviation Phoenix Convention Center Solid Waste Disposal Wastewater Water System Enterprise Subtotal Total Capital Budget Program $ $ 319,309,235 26,317,367 36,549,997 131,221,683 203,161,550 716,559,832 $ 1,228,240,486 $ $ 151,731,161 8,386,257 430,838 3,960,516 51,143,125 215,651,897 $ 272,888,065 $ $ 59,042,398 7,384,986 98,237 5,577,638 17,174,893 89,278,152 $ 175,688,742 2014-15 Year-to-Date Capital Amounts From Operating Funds From Capital Funds Budget Actual Budget $ $ $ 51,574 $ 8,381,140 1,200,000 5,300,845 1,161,446 7,944,250 17,299,618 1,200,391 200,000 3,201,373 42,931,503 3,182,088 95,545,813 75,677,465 1,335 755,125 535,455 1,187,082 935,379 555,452 3,175 81 80,466 6,185,394 38,916 7,310,641 23,902,475 263,277,506 $ 41,490,976 $ 28,117,700 5,868,367 29,202,053 73,266,111 178,300,255 314,754,486 $ 578,031,992 - 32 - $ $ 6,532,277 1,569,924 156,412 4,278,270 50,110,128 62,647,011 $ 104,137,987 $ $ $ 1,074,000 $ 164,826 7,150,000 1,275,275 3,800,673 1,406,342 19,272,860 609,000 48,648,079 1,276,482 3,149,079 30,316,499 68,237 28,090,809 17,957,644 84,143,343 53 513 518,572 765,310 311,449 3,804 648,023 8,417 8,346,005 306,281 25,547 373,230 232,676 159,692 108,521 3,937,099 248,403,148 $ 15,745,192 $ 291,191,535 20,449,000 7,347,944 57,955,572 24,861,295 401,805,346 $ 650,208,494 Unencumbered Budget Actual $ $ 1,124,186 7,790,328 664,545 10,745,191 736,032 11,433,474 1,402,538 35,369,003 597,408 41,502,465 1,170,120 6,244,439 66,689,378 2,978,733 116,166,289 17,849,123 131,981,234 $ 454,444,486 $ 145,198,884 6,816,333 274,426 (317,754) 1,032,997 153,004,886 $ $ 167,578,074 17,931,110 36,119,159 127,261,167 152,018,425 500,907,935 $ 168,750,078 $ 955,352,421 Bonds Authorized and Sold As of October 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 $ - 33 - 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 10-11 Actuals 11-12 Actuals 12-13 Actuals 13-14 Actuals 14-15 Actuals 14-15 budget 40,000 35,000 30,000 25,000 20,000 15,000 July FY 10-11 11-12 12-13 13-14 14-15 14-15 budget July 32,543 33,875 34,005 36,360 35,365 36,235 Aug Aug 32,288 34,239 34,276 35,589 36,414 36,132 Sept Sept 33,087 33,371 34,254 35,873 35,290 36,183 Oct Nov Oct 32,143 34,746 33,337 35,068 34,621 35,841 Dec YTD thru Oct 130,061 136,231 135,872 142,890 141,689 144,391 Jan Feb Mar Apr May June Nov 32,952 31,854 33,430 34,363 Dec 31,456 31,745 32,504 32,474 Jan 36,278 36,385 36,527 40,116 Feb 30,658 31,532 32,542 32,084 Mar 31,302 32,549 32,047 32,147 Apr 34,169 34,955 34,911 35,988 May 33,040 32,521 34,699 33,165 June 32,462 39,115 38,243 34,898 35,127 33,956 39,553 33,595 33,920 37,094 35,346 38,338 Note: City of Phoenix revenue is budgeted on an annual basis. 2014-15 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 2013-14 actual expenditures. Return to Summary Page - A1 - State Sales Tax (Dollars in Thousands) State Sales Tax 14,000 10-11 Actuals 13,000 11-12 Actuals 12,000 12-13 Actuals 11,000 13-14 Actuals 14-15 Actuals 10,000 14-15 budget 9,000 8,000 7,000 6,000 5,000 July FY 10-11 11-12 12-13 13-14 14-15 14-15 budget Aug July 9,769 8,852 9,907 10,309 11,103 11,158 Sept Aug 8,262 8,683 8,755 9,616 9,712 10,146 Oct Sept 8,684 8,993 9,240 10,012 10,552 10,610 Nov Oct 8,642 9,177 9,229 9,923 10,307 10,622 YTD thru Oct 35,357 35,705 37,131 39,859 41,674 42,536 Dec Jan Feb Mar Apr May June Nov 8,687 9,083 9,456 9,673 Dec 8,947 9,055 9,462 10,296 Jan 10,757 11,290 11,986 12,744 Feb 9,258 8,572 9,270 10,430 Mar 9,134 9,554 9,887 10,506 Apr 10,448 9,744 11,037 11,285 May 10,048 9,743 9,902 10,863 June 9,150 11,272 10,599 11,350 10,601 10,849 13,439 10,782 11,228 12,214 11,652 12,173 Note: City of Phoenix revenue is budgeted on an annual basis. 2014-15 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 2013-14 actual expenditures. Return to Summary Page - A2 - Vehicle License Tax (Dollars in Thousands) Vehicle License Tax 5,500 10-11 Actuals 11-12 Actuals 5,000 12-13 Actuals 13-14 Actuals 4,500 14-15 Actuals 4,000 Budget 14-15 3,500 3,000 2,500 2,000 July FY 10-11 11-12 12-13 13-14 14-15 Budget 14-15 Aug July 5,217 4,482 4,493 4,752 4,963 5,282 Sept Aug 4,141 3,698 3,982 4,663 5,004 4,596 Oct Sept 3,722 3,842 3,852 3,992 3,749 4,296 Nov Oct 4,018 3,669 3,535 3,912 4,415 4,220 Dec YTD thru Oct 17,098 15,691 15,863 17,318 18,131 18,394 Jan Feb Mar Apr May June Nov 3,224 3,089 3,582 3,958 Dec 4,095 3,781 3,993 3,872 Jan 3,894 3,645 3,572 3,936 Feb 3,372 3,620 4,141 4,799 Mar 4,820 4,860 4,623 4,559 Apr 3,854 3,482 3,676 3,826 May 4,091 3,796 4,088 4,643 June 3,851 4,435 4,834 4,778 3,862 4,389 4,195 4,442 5,259 4,137 4,633 4,990 Note: City of Phoenix revenue is budgeted on an annual basis. 2014-15 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 2013-14 actual expenditures. Return to Summary Page - A3 - Aviation Revenues (Dollars in Thousands) Aviation Operating Revenues 40,000 10-11 Actuals 11-12 Actuals 35,000 12-13 Actuals 13-14 Actuals 30,000 14-15 Actuals Budget 14-15 25,000 20,000 15,000 10,000 July FY 10-11 11-12 12-13 13-14 14-15 Budget 14-15 Aug July 26,581 27,628 28,080 31,036 27,544 27,068 Sept Aug 26,388 24,404 26,231 22,760 26,594 23,834 Oct Sept 26,824 27,570 28,144 26,677 27,855 26,087 Nov Oct 38,540 26,280 30,124 26,505 26,489 29,009 Dec YTD thru Oct 118,334 105,881 112,580 106,978 108,483 105,998 Jan Feb Nov 13,697 27,849 26,471 26,222 Dec 27,977 29,526 28,146 27,171 22,510 26,948 Mar Apr May Jan 25,681 27,146 27,054 26,659 Feb 28,359 27,028 27,884 26,561 Mar 28,876 28,470 31,100 28,352 Apr 30,528 33,111 34,980 31,467 May 27,087 30,194 31,020 29,350 June 32,096 30,075 28,463 27,200 25,447 26,234 27,898 31,072 28,102 28,145 Note: City of Phoenix revenue is budgeted on an annual basis. 2014-15 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 FY 2013-14 actual expenditures. Return to Summary Page - A4 - June Water System Revenues (Dollars in Thousands) Water System Operating Revenues 80,000 75,000 10-11 Actuals 70,000 11-12 Actuals 65,000 12-13 Actuals 60,000 13-14 Actuals 55,000 14-15 Actuals 50,000 Budget 14-15 45,000 40,000 35,000 30,000 25,000 20,000 15,000 10,000 July FY 10-11 11-12 12-13 13-14 14-15 Budget 14-15 Aug July 47,691 48,584 79,417 49,017 50,166 52,833 Sept Aug 40,774 44,616 42,419 42,137 40,684 46,373 Oct Sept 39,640 47,230 42,446 41,144 36,711 46,550 Nov Oct 30,588 35,860 34,197 34,917 30,601 36,860 Dec YTD thru Oct 158,693 176,291 198,479 167,215 158,162 182,616 Jan Feb Nov 26,585 30,215 36,338 34,774 Dec 21,157 20,946 25,523 22,327 33,299 23,429 Mar Apr May Jan 17,482 19,694 21,738 22,872 Feb 16,371 18,282 18,711 21,185 Mar 17,629 20,726 21,386 21,993 Apr 28,414 27,648 30,809 29,578 May 29,903 32,635 34,663 36,292 June 38,411 42,378 37,680 42,563 21,835 20,305 21,945 31,141 35,938 44,855 Note: City of Phoenix revenue is budgeted on an annual basis. 2014-15 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, FY 2011-12, and FY 2013-14 actual expenditures. FY 2012-13 expenditures were excluded from the calculation due to a significant outlier in July 2012. Return to Summary Page - A5 - June Wastewater Revenues (Dollars in Thousands) Wastewater Operating Revenues 10-11 Actuals 27,000 11-12 Actuals 12-13 Actuals 22,000 13-14 Actuals 14-15 Actuals Budget 14-15 17,000 12,000 7,000 2,000 July FY 10-11 11-12 12-13 13-14 14-15 Budget 14-15 Aug July 18,867 18,754 17,547 17,634 18,325 17,423 Sept Aug 19,831 19,339 18,057 18,252 18,520 17,977 Oct Sept 20,379 19,500 17,930 18,224 18,337 17,979 Nov Oct 18,860 19,161 17,684 17,798 17,754 17,652 Dec YTD thru Oct 77,936 76,753 71,218 71,908 72,935 71,031 Jan Feb Nov 18,540 26,283 20,958 20,452 Dec 27,453 18,864 17,744 17,763 21,868 17,564 Mar Apr May Jan 19,363 26,967 25,337 17,618 Feb 23,589 16,038 17,663 18,058 Mar 18,759 18,552 14,263 14,986 Apr 19,435 18,938 17,865 18,386 May 18,776 19,734 17,982 18,299 June 3,789 10,717 14,638 16,909 22,588 16,721 15,442 17,828 18,095 13,653 Note: City of Phoenix revenue is budgeted on an annual basis. 2014-15 monthly budget amounts are based on an allocation of the annual budget. Monthly budget amounts are calculated based on an allocation of FY 2011-12 through FY 2013-14 actual expenditures. FY 2010-11 expenditures were excluded from the calculation due to a significant outlier in June 2011. Return to Summary Page - A6 - June