August 2014 Monthly Financial Report PREPARED BY Financial Accounting & Reporting Division City of Phoenix Monthly Financial Report August 2014 Table of Contents Expenditures by Programs Page Performance Status General Fund Expenditures Report Navigation General Fund Total Expenditures 1 Better than Expected 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 be taken directly to that page of the report. 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 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. Table of Contents Citywide Expenditures Performance Status 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 Performance Status 13 Monitor & Consider Corrective Action Property Tax 14 Expected Local Sales Tax 15 Expected State Sales Tax 16 Monitor & Consider Corrective Action Vehicle License Tax 17 Expected 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. August General Fund YTD Expenditures (Dollars in Thousands) Refer to detailed financial schedules pages 21 thru 33 Total General Fund Expenditures 10-11 11-12 12-13 13-14 14-15 August YTD Annual % of Annual Expenditures Expenditures * Expenditures 174,652 954,795 18.3% 179,646 995,771 18.0% 197,068 1,038,092 19.0% 197,973 1,042,102 19.0% 191,888 1,103,572 17.4% * - 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 August YTD August 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 * 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 August 2014, general fund expenditures are performing better than expected as year to date expenditures are 3.1% lower than through August 2013. General Government 10-11 11-12 12-13 13-14 14-15 August YTD Annual % of Annual Expenditures Expenditures * Expenditures 16,287 70,650 23.1% 18,489 98,577 18.8% 17,335 102,211 17.0% 21,014 100,400 20.9% 12,838 109,033 11.8% * - 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 August YTD Expenditures August YTD Expenditures Annual Expenditures * Annual Expenditures * $20,000 $20,000 $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 August 2014 with a 38.9% decrease from the same period in the prior year. The decrease is primarily due to Information Technology Services assessments 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. -1- August General Fund YTD Expenditures (Dollars in Thousands) Refer to detailed financial schedules pages 21 thru 33 Criminal Justice August YTD Annual % of Annual Expenditures Expenditures * Expenditures 6,049 33,324 18.2% 6,190 33,542 18.5% 6,322 33,453 18.9% 6,243 32,659 19.1% 6,019 34,031 17.7% 10-11 11-12 12-13 13-14 14-15 * - 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 August YTD Expenditures August 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 August 2014 with a 3.6% 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. Public Safety 10-11 11-12 12-13 13-14 14-15 Transportation Public Safety August YTD Annual % of Annual Expenditures Expenditures * Expenditures 111,887 639,691 17.5% 115,996 647,049 17.9% 123,201 684,609 18.0% 126,065 699,796 18.0% 130,177 726,963 17.9% * - 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 August YTD Expenditures August 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 are performing as expected through August 2014 with a 3.3% 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- August 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 August YTD Annual % of Annual Expenditures Expenditures * Expenditures 6,989 38,711 18.1% 5,818 39,161 14.9% 15,096 38,161 39.6% 8,926 29,713 30.0% 9,232 39,756 23.2% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected 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 August YTD Expenditures August 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 August 2014 with a 3.4% increase over the same period in the prior year. The fiscal year 2014-15 budget includes a 33.8% increase over fiscal year 201314 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 August YTD Annual % of Annual Expenditures Expenditures * Expenditures 3,632 19,458 18.7% 3,375 19,393 17.4% 3,598 19,927 18.1% 4,074 20,210 20.2% 3,828 22,241 17.2% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected $25,000 $25,000 August AugustYTD 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 10-11 10-11 11-12 12-13 11-12 12-13 13-14 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 August 2014 with a 6.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- August 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 August YTD Annual % of Annual Expenditures Expenditures * Expenditures 25,866 137,793 18.8% 26,251 140,026 18.7% 28,223 141,209 20.0% 29,044 143,665 20.2% 25,858 150,195 17.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 10-11 11-12 12-13 13-14 10-11 11-12 12-13 AugustYTD YTD August 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 August 2014 with an 11.0% 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 August YTD Annual % of Annual Expenditures Expenditures * Expenditures 3,909 14,046 27.8% 3,257 15,723 20.7% 3,210 15,353 20.9% 2,475 13,748 18.0% 3,598 18,508 19.4% * - For prior years-total actual expenditures, for current year-total approved budget 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 Monitor & Consider Corrective Action August 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 August 2014 are 45.4% 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. August 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 August YTD Annual % of Annual Expenditures Expenditures * Expenditures 621,907 3,026,005 20.6% 609,244 2,985,410 20.4% 641,356 3,123,865 20.5% 647,141 3,054,098 21.2% 643,842 3,512,673 18.3% * - 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 August YTD August YTD Expenditures Expenditures Annual Annual Expenditures * Expenditures * 10-11 10-11 Better than Expected 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 decrease of 0.5% from the prior year through August 2014. General Government 10-11 11-12 12-13 13-14 14-15 August YTD Annual % of Annual Expenditures Expenditures * Expenditures 17,612 78,047 22.6% 18,976 109,658 17.3% 18,286 114,015 16.0% 22,488 114,235 19.7% 18,244 122,878 14.8% * - 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 August YTD Expenditures August 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 18.9% through August 2014 over the prior August. This is lower than the budgeted increase of 7.6% for fiscal year 2014-15 over prior year actuals. -5- August 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 August YTD Annual % of Annual Expenditures Expenditures * Expenditures 7,155 36,958 19.4% 6,802 36,305 18.7% 7,705 41,290 18.7% 7,796 40,697 19.2% 7,458 46,819 15.9% * - 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 August YTD Expenditures August 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 August 2014 of 4.3% from the prior August. 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 August YTD Annual % of Annual Expenditures Expenditures * Expenditures 138,059 792,002 17.4% 142,306 803,367 17.7% 149,749 842,387 17.8% 151,300 842,270 18.0% 152,115 874,993 17.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 August YTD Expenditures August 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 August 2014 expenditures 0.5% higher than the prior year. The budgeted increase for fiscal year 2014-15 over prior year actuals is 3.9%. -6- August 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 August YTD Annual % of Annual Expenditures Expenditures * Expenditures 199,584 567,830 35.1% 210,003 584,429 35.9% 216,261 582,381 37.1% 229,099 573,025 40.0% 227,928 610,044 37.4% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected Transportation Community Development $700,000 $600,000 $500,000 August YTD Expenditures August YTD Expenditures $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 11-1212-13 12-13 10-11 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 decrease at August 2014 of 0.5% from the prior August. 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 August YTD Annual % of Annual Expenditures Expenditures * Expenditures 35,234 176,114 20.0% 28,969 192,133 15.1% 39,212 209,403 18.7% 37,275 194,542 19.2% 37,422 230,064 16.3% * - For prior years-total actual expenditures, for current year-total approved budget CommunityDevelopment Enrichment Community $250,000 $250,000 AugustYTD YTD August Expenditures Expenditures $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 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 increase at August 2014 of 0.4% from the prior August. These expenditures were budgeted to increase 18.3% for fiscal year 2014-15 over prior year actuals. -7- August 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 August YTD Annual % of Annual Expenditures Expenditures * Expenditures 53,768 274,824 19.6% 52,971 272,353 19.4% 53,864 273,110 19.7% 55,212 272,326 20.3% 44,490 285,034 15.6% * - For prior years-total actual expenditures, for current year-total approved budget Environmental Services Community Enrichment $300,000 $300,000 $250,000 $250,000 $200,000 $200,000 AugustYTD YTD August Expenditures Expenditures $150,000 $150,000 $100,000 $100,000 $50,000 $50,000 $0 $0 Annual Expenditures * Annual Expenditures * Better than Expected 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 August 2014 of 19.4% from the prior August. 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 August YTD Annual % of Annual Expenditures Expenditures * Expenditures 100,070 572,693 17.5% 92,686 549,628 16.9% 113,108 564,051 20.1% 96,911 577,118 16.8% 94,101 619,914 15.2% * - 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 AugustYTD YTD August Expenditures Expenditures $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 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 August 2014 of 2.9% from the prior August. The budgeted increase for fiscal year 2014-15 over prior year actuals is 7.4%. -8- August 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 August YTD Annual % of Annual Expenditures Expenditures * Expenditures 32,061 196,779 16.3% 28,154 157,298 17.9% 22,732 137,208 16.6% 16,797 100,524 16.7% 22,462 148,544 15.1% * - 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 AugustYTD YTD August 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 August 2014, year to date expenditures are 33.8% higher than the prior August. -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 $ 508,032 Discussion: 14-15 (YTD) $ 23,454 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) $ 157,884 $ 332,920 $ 168,639 $ 180,571 $ 319,309 14-15 (YTD) $ 13,735 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 Major projects planned for fiscal year 2014-15 include Terminal Development Concept Design ($126 million) and Terminal 4 International Expansion ($23 million). 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) $ 3,689 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) $ 285 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) $ 1,831 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) $ 18,850 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 Major projects planned for fiscal year 2014-15 include water treatment plant improvements at the 24th Street and Union Hills facilities ($34 million) and an upgrade to the Customer Care and Billing system ($7 million). 10-11 $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 21 thru 33 General Fund Revenues $1,200,000 $1,000,000 Aug 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 Aug YTD Actuals 133,201 131,723 135,898 145,337 147,664 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 13.8% 13.9% 13.9% 14.2% 13.9% * - For prior years - total actual revenues, for current year - total approved budget Monitor & Consider Corrective Action Fiscal Year 2014-15 general fund operating revenues were budgeted to increase 3.3% over prior year actuals. Actual year over year revenue growth through August 2014 is 1.6%. 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 Secondary 149,019 200,000 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 - FY 10-11 11-12 12-13 13-14 14-15 YTD 14-15 budget Total 279,932 222,488 194,112 179,136 (347) 188,358 July (3,017) (2,553) (1,733) (1,260) (1,107) (1,754) Aug 1,118 1,059 1,349 971 760 1,068 14-15 YTD 14-15 budget Sept 1,279 1,189 904 867 Oct 18,792 13,656 11,888 11,107 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 936 11,588 49,416 32,866 6,919 4,504 6,706 8,422 39,404 28,283 Note: Monthly budget amount for 13-14 is the average % of last 3 years of the total budget amount 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 will be presented as “Expected” in July, August and September as receipts in those months are immaterial and not representative of annual performance. Property tax revenues are budgeted to increase 5.1% in fiscal year 2014-15 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 Expected Local sales tax revenues through August 2014 are 0.8% below budget for that period. 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 While local sales tax revenues saw a net increase from fiscal year 2012-13 to fiscal year 2013-14, August 2014 was the first month since April 2014 to show a year over year increase in local sales tax revenues. 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 August 2014 are 2.3% 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 August 2014 state shared sales tax revenues were 4.5% higher than through August 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 Expected State shared vehicle license tax revenues are performing as expected through August 2014 at 0.9% higher 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 August 2014 were 5.9% higher than through August 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 August 2014 were better than expected at 6.4% 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. 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 8.4% below budget projections through August 2014 reflecting the significant 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 In July 2012 Water sold land in McMullen Valley for $29.7 million. Through August 2014 year over year water revenues are essentially flat. Click Here for Additional Information - 19 - May June 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 August 2014 are better than expected at 4.1% 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 Wastewater revenues have shown year over year increases every month since February 2014. Click Here for Additional Information - 20 - May 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 August 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 71,779 $ 115 71,949 115 135,474 175,174 54,300 137,956 2,833 9,495 20,815 29,197 9,967 (187) 419 3 19,925 26,880 9,415 (115) 415 (2) 17,722 1,015 13,487 1,025 7,361 1,431 3,928 2,585 117 1,652 172 1,336 187 682 3,110 135 1,407 181 1,483 194 627 32,500 13,596 1,800 17,331 5,231 1,829 372 1,393 5,754 344 210 3,310 $ 1,060,289 - 21 - $ $ 147,664 $ 145,337 General Fund Expenditures As of August 31 (dollars in thousands) Actual Year-to-Date 2014-15 2013-14 Budget Estimate 2014-15 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 Criminal Justice Municipal Court Public Defender Total Criminal Justice $ 228 $ 540 567 494 319 400 3,180 741 547 1,583 544 3,075 620 12,838 284 562 541 6,962 533 461 3,528 738 685 1,531 659 3,956 574 21,014 29,049 4,982 34,031 5,211 808 6,019 5,498 745 6,243 Public Safety Police Fire Others Total Public Safety 471,386 255,563 14 726,963 85,251 44,923 3 130,177 82,520 43,544 1 126,065 Transportation Street Transportation Public Transit Total Transportation 21,554 18,202 39,756 4,815 4,417 9,232 3,608 5,318 8,926 Community Development Economic Development Neighborhood Services Department Planning and Development Others Total Community Development 4,796 12,481 4,910 54 22,241 1,025 1,968 827 8 3,828 1,065 2,199 802 8 4,074 Community Enrichment Parks and Recreation Library Human Services Others Total Community Enrichment 92,913 35,515 18,895 2,872 150,195 17,350 5,238 2,280 990 25,858 17,809 6,258 3,950 1,027 29,044 Environmental Services Public Works Environmental Programs Total Environmental Services 17,663 845 18,508 3,489 109 3,598 2,337 138 2,475 2,845 338 132 - - Capital Improvement Contingencies Total Expenditures and Encumbrances 45,268 $ 1,148,840 - 22 - $ 191,888 $ 197,973 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 August 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 $ 431,320 2,541 $ 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 Total General Funds 1,060,289 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 $ 71,949 115 20,815 29,197 9,967 (187) 419 3 2,702 1,652 172 1,336 187 682 7,060 372 1,393 19,925 26,880 9,415 (115) 415 (2) 3,245 1,407 181 1,483 194 627 6,098 210 3,310 4,998 14,870 4,956 566 26,835 7,116 11,443 2,541 1,894 17,218 5,081 164 4,172 16,997 (159) 145,337 4,767 14,487 4,696 526 28,023 1,117 10,171 2,650 1,824 15,903 4,203 1,597 4,304 23,605 (179) 944,825 118,692 117,694 322,353 63,497 415,361 214,792 150,150 54,138 8,795 90,850 36,844 24,836 53,796 7,955 91,154 35,886 24,180 1,166,153 215,463 212,971 481,819 $ 476,002 Enterprise Funds Aviation Convention Center Water System Wastewater Solid Waste Total Enterprise Funds 71,779 $ 115 147,664 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 Total Special Revenue and Debt Service Funds Total Operating Revenues Actual Year-to-Date 2014-15 2013-14 3,171,267 - 23 - $ Citywide Operating Expenditures As of August 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 $ Criminal Justice General Funds Other Funds Total Criminal Justice 109,033 13,845 122,878 $ 12,838 $ 5,406 18,244 21,014 1,474 22,488 34,031 12,788 46,819 6,019 1,439 7,458 6,243 1,553 7,796 Public Safety General Funds Other Funds Total Public Safety 726,963 148,030 874,993 130,177 21,938 152,115 126,065 25,235 151,300 Transportation General Funds Other Funds Total Transportation 39,756 570,288 610,044 9,232 218,696 227,928 8,926 220,173 229,099 Community Development General Funds Other Funds Total Community Development 22,241 207,823 230,064 3,828 33,594 37,422 4,074 33,201 37,275 Community Enrichment General Funds Other Funds Total Community Enrichment 150,195 134,839 285,034 25,858 18,632 44,490 29,044 26,168 55,212 Environmental Services General Funds Other Funds Total Environmental Services 18,508 601,406 619,914 3,598 90,503 94,101 2,475 94,437 96,912 74,164 74,164 22,461 22,461 16,797 16,797 2,845 571,538 574,383 338 39,285 39,623 132 30,130 30,262 45,268 48,500 93,768 - - 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 $ 1,148,840 2,383,221 3,532,061 - 24 - $ 191,888 451,954 643,842 $ 197,973 449,168 647,141 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 August 31 2014 2013 Budget Estimate 2014-15 Source Actual Year-to-Date 2014-15 2013-14 General Funds $ 36,413,783 53,558 $ 35,589,177 51,884 Local Taxes: Sales Taxes Privilege License Fees $ 431,320,000 2,541,000 $ 71,778,648 115,379 $ 71,949,317 114,958 36,467,341 35,641,061 Total Local Taxes 433,861,000 71,894,027 72,064,275 9,711,944 14,598,649 5,004,427 9,615,520 13,440,181 4,662,829 State Shared Taxes: State Sales Tax State Income Tax Vehicle License Tax 135,474,000 175,174,000 54,300,000 20,814,944 29,197,299 9,967,447 19,924,520 26,880,362 9,414,664 29,315,020 27,718,530 364,948,000 59,979,690 56,219,546 603,787 668,390 Primary Property Tax 298,800 259,292 Licenses and Permits Cable Communications Municipal Court: Fines and Forfeitures Court Default Fee 17,721,789 1,015,000 2,584,439 117,241 - - 1,376,170 61,053 1,429,350 69,522 1,437,223 1,498,872 942,907 718,494 84,658 88,451 348,574 742,100 86,695 71,353 179,575 266,845 2,015,811 66,859 1,542,057 3,177,460 43,750 184,731 3,624,727 3,405,941 143,818 107,654 568,517 1,956,897 74,101,642 73,143,880 Total State Shared Taxes 137,956,000 Total Municipal Court Police (186,925) (114,576) 2,833,000 418,522 415,270 9,495,000 3,262 (2,001) 3,109,523 135,401 18,736,789 2,701,680 3,244,924 13,487,000 1,651,686 1,406,957 Library Fees 1,025,000 171,586 180,536 Parks and Recreation 7,361,300 1,335,705 1,482,826 Planning and Development 1,431,400 186,595 194,320 Street Transportation 3,928,108 682,359 626,320 32,500,000 1,400,000 12,195,773 5,231,446 119,059 1,709,936 5,754,001 69,250 274,968 46,095,773 7,060,441 6,098,219 1,800,000 372,206 210,088 Fire: Emergency Transportation Service Hazardous Materials Inspection Fee Other Total Fire Interest Other Fees and Service Charges Total General Funds - 25 - 17,330,894 1,392,872 3,309,909 1,060,289,264 147,663,706 145,336,613 Citywide Operating Revenue by Source (continued) For the Month Ended August 31 2014 2013 Budget Estimate 2014-15 Source Actual Year-to-Date 2013-14 2014-15 Special Revenue and Debt Service Funds $ 1,726,680 123,335 616,673 50,973 $ 1,566,688 111,907 559,532 73,773 2,517,661 2,311,900 5,636,621 2,022,433 (10,093) 5,313,099 1,956,858 (7,852) 7,648,961 7,262,105 2,486,012 2,263,232 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 181,127 12,183 119,119 (2,740) (4,193) 143,823 5,141 119,219 (4,269) (3,127) 305,496 260,787 8,964,278 3,392,253 8,952,504 4,059,978 12,356,531 13,012,482 6,515,640 1,117,000 Court Awards 3,511,989 2,653,068 1,285,720 1,345,273 1,052,567 12,536 852,268 11,879 1,065,103 864,147 21,791,000 1,556,000 7,783,000 5,000 $ 3,442,819 245,916 1,229,579 79,731 $ 3,261,184 232,942 1,164,709 107,676 31,135,000 4,998,045 4,766,511 66,032,000 22,381,000 (67,500) 11,002,744 3,887,824 (20,262) 10,668,287 3,833,498 (15,005) 88,345,500 14,870,306 14,486,780 31,337,000 4,956,440 4,696,337 5,722,702 311,350 2,352,140 (70,000) 399,500 322,958 13,242 235,082 (5,269) (445) 291,477 9,235 234,069 (8,162) (419) 8,715,692 565,568 526,200 115,177,000 52,021,458 17,840,612 8,994,122 18,635,338 9,387,215 167,198,458 26,834,734 28,022,553 4,385,818 7,115,640 1,117,000 Planning and Development 42,783,000 11,443,230 10,171,056 Capital Construction 15,470,000 2,541,001 2,650,089 Sports Facilities: Sales Taxes Interest/Other 16,451,000 250,000 1,867,913 26,316 1,799,396 24,149 16,701,000 1,894,229 1,823,545 Total Golf Courses Transit 2000: Sales Taxes Interest/Other Total Transit 2000 Total Sports Facilities - 26 - Citywide Operating Revenue by Source (continued) For the Month Ended August 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,721,738 24,381 - 8,217,929 15,654 3,000 8,746,119 8,236,583 2,574,010 2,106,108 45,963 1,580,692 2,078,514 1,364,743 Other Restricted Fees 519,759 5,690,239 671,567 Grants: Public Housing: Rentals Grants Other 399,223 5,279,974 210,516 $ 106,383,000 200,000 200,000 17,034,738 47,322 136,300 15,869,929 28,979 4,398 106,783,000 17,218,360 15,903,306 Regional Transit Revenues 46,596,781 5,080,783 4,203,307 Community Reinvestment 2,608,664 163,821 1,597,156 44,684,752 4,171,981 4,304,136 Total Highway User Revenue $ $ 835,161 9,547,462 (31,733) $ 969,566 7,884,726 918,829 5,889,713 6,881,565 1,558,554 1,823,932 149,435 3,573,021 3,715,107 2,120,376 160,975 6,617,519 7,104,942 12,613,977 Total Other 196,420,918 6,646,174 13,831,731 12,994,655 19,495,542 Total Grants 282,746,789 16,997,064 23,604,852 156,323 3,236 302,510 (517) 159,559 301,993 64,291,933 64,175,655 Total Public Housing 7,109,137 74,501,952 4,714,782 Other: Human Resources Federal Transit Administration Community Development Other G.O. Bond/Secondary Property Tax Secondary Property Tax Interest 86,325,871 10,350,890 9,773,121 40,078,832 72,253,928 31,945,433 52,142,725 (402,054) (1,158,117) 4,818,884 3,387,461 1,302,276 2,120,378 4,720,571 5,688,506 50,404,017 4,928,832 Total G.O. Bond/Secondary Property Tax Total Special Revenue and Debt Service Funds 55,332,849 (159,468) 177 (159,291) (174,731) (3,866) (178,597) 944,824,303 118,691,911 117,694,231 131,840,000 182,337,300 800,000 2,498,000 1,895,125 2,982,075 - 17,187,505 35,451,106 129,316 434,854 350,142 493,273 91,889 16,914,768 35,446,466 214,266 434,987 355,281 488,704 (58,123) 322,352,500 54,138,085 53,796,349 Enterprise Funds AVIATION: 8,710,480 17,231,611 67,364 136,027 174,837 241,350 32,435 8,490,468 16,557,820 163,451 173,156 177,755 244,307 (3,046,642) 26,594,104 22,760,315 Sky Harbor: Airlines Concessions Interest Other Phoenix-Goodyear Phoenix-Deer Valley Phoenix-Customer Facility Charge Total Aviation - 27 - Citywide Operating Revenue by Source (continued) For the Month Ended August 31 2014 2013 Budget Estimate 2014-15 Source Actual Year-to-Date 2014-15 2013-14 Enterprise Funds (Cont'd) CONVENTION CENTER: 3,580,989 856,511 19,803 3,093,751 840,468 16,404 4,457,303 3,950,623 Excise Taxes Operating Revenue Interest Total Convention Center 47,993,000 15,328,192 175,863 6,863,026 1,893,495 38,378 6,318,496 1,604,915 31,115 63,497,055 8,794,899 7,954,526 WATER SYSTEM: $ 38,460,101 420,392 311,440 710,920 229,200 186,518 365,612 $ 40,684,183 41,218,510 555,899 181,542 (354,988) 71,700 146,050 318,612 42,137,325 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 $ 86,614,698 857,251 1,297,431 1,331,569 317,580 367,719 64,199 $ 87,213,354 1,060,727 1,052,796 913,011 364,800 280,141 269,196 415,361,000 90,850,447 91,154,025 182,029,000 16,199,000 2,400,000 1,348,000 12,816,000 30,462,378 3,270,916 307,440 218,194 2,585,656 30,192,776 3,224,204 338,280 180,344 1,950,357 214,792,000 36,844,584 35,885,961 128,235,000 9,720,000 270,000 11,925,446 21,268,925 1,451,415 75,469 2,039,839 21,095,191 1,501,253 57,864 1,525,691 150,150,446 24,835,648 24,179,999 1,166,153,001 215,463,663 212,970,860 WASTEWATER: 15,328,676 1,703,916 220,860 109,888 1,156,632 15,140,534 1,678,204 71,100 92,911 1,269,634 18,519,972 18,252,383 Sewer Service Charges Multi-City Development Fees Interest Other Total Wastewater SOLID WASTE: $ 10,627,092 836,147 37,847 989,735 10,548,028 738,031 32,779 1,250,085 12,490,821 12,568,923 102,746,383 99,669,569 241,139,958 $ 236,989,104 Collection Fees Landfill Fees Interest Other Total Solid Waste Total Enterprise Funds Total Operating Revenues $ - 28 - 3,171,266,568 $ 481,819,280 $ 476,001,704 Citywide Operating Expenditures by Program For the Month Ended August 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 $ 111,576 $ 270,209 324,107 (2,592,664) 50,691 154,871 208,256 1,521,242 167,985 144,509 181,451 940,754 155,151 6,346 229,198 1,475,874 4,422,852 7,772,408 134,007 277,396 309,947 3,446,438 108,655 272,679 274,032 1,656,194 243,039 429,833 138,896 778,159 (1,464) 6,998 271,832 1,573,745 610,849 10,531,235 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 $ 227,617 540,617 615,832 877,330 105,213 377,038 467,901 3,354,307 741,331 546,800 183,029 1,862,491 318,899 13,301 543,700 3,521,552 3,946,567 $ 283,949 561,777 599,497 7,311,759 190,442 590,674 535,398 3,686,969 738,392 684,783 344,984 1,720,125 24,155 14,021 658,672 4,573,592 (30,827) $ 227,617 540,617 615,832 613,294 105,213 377,038 467,901 3,354,307 741,331 546,800 183,029 1,670,986 318,899 13,301 543,700 3,494,730 3,946,567 $ 264,036 191,505 26,822 - 122,877,786 18,243,525 22,488,362 17,761,162 482,363 41,837,569 4,981,585 6,650,460 807,990 7,051,120 745,024 5,566,569 807,990 1,083,891 - 46,819,154 7,458,450 7,796,144 6,374,559 1,083,891 570,433,037 304,086,736 472,781 100,880,517 51,161,312 73,240 100,880,120 50,330,732 89,403 99,722,365 50,559,223 73,240 1,158,152 602,089 - 874,992,554 152,115,069 151,300,255 150,354,828 1,760,241 Criminal Justice 2,752,708 395,848 2,874,907 367,177 3,148,556 3,242,084 Municipal Court Public Defender Total Criminal Justice Public Safety 44,737,706 22,968,868 32,723 47,084,218 22,658,186 38,055 67,739,297 69,780,459 Police Fire Other Total Public Safety - 29 - Citywide Operating Expenditures by Program (continued) For the Month Ended August 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 $ 4,917,228 977,967 19,299,968 10,808,304 36,003,467 $ 4,921,202 936,424 22,580,626 19,277,628 47,715,880 Street Transportation Street Lighting Aviation Public Transit Total Transportation $ 60,347,257 11,676,247 285,060,223 252,960,307 $ 11,563,673 1,924,460 42,227,854 172,211,897 $ 10,249,663 1,855,752 44,795,752 172,197,480 $ 11,543,862 1,924,460 33,824,038 162,717,124 $ 19,811 8,403,816 9,494,773 610,044,034 227,927,884 229,098,647 210,009,484 17,918,400 Community Development 3,677,009 6,713,563 5,129,564 2,674,346 2,672,070 6,357,882 4,501,354 3,806,564 Planning and Development Housing Economic Development Neighborhood Services Department 46,760,869 88,592,415 35,505,370 59,205,414 7,213,687 14,422,133 9,932,652 5,853,473 6,341,671 13,661,262 9,560,808 7,711,507 7,213,687 14,409,245 4,206,823 5,853,473 12,888 5,725,829 - 18,194,482 17,337,870 Total Community Development 230,064,068 37,421,945 37,275,248 31,683,228 5,738,717 102,825,230 36,062,173 8,354,628 60,752,841 11,048,412 60,440,955 4,007,435 1,542,517 18,875,103 5,338,019 1,299,161 8,888,272 1,845,803 6,876,562 545,182 821,973 19,079,809 6,378,615 1,256,575 16,592,057 1,824,697 8,755,882 512,884 811,242 18,555,277 5,338,019 1,299,161 5,790,070 6,827,653 545,182 821,973 319,826 3,098,202 1,845,803 48,909 - 285,034,191 44,490,075 55,211,761 39,177,335 5,312,740 Community Enrichment 8,099,705 2,823,456 671,589 4,036,519 923,682 3,322,236 183,528 213,855 8,503,504 3,469,367 594,942 11,417,528 913,019 3,868,417 329,494 275,973 20,274,570 29,372,244 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 August 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 $ 22,704,667 9,941,904 9,205,253 2,040,365 83,426 $ 43,975,615 26,133,870 12,388,262 10,154,004 128,963 135,936 48,941,035 Water System Wastewater Solid Waste Management Public Works Environmental Programs $ Total Environmental Services 371,308,322 75,410,036 146,831,385 25,033,479 1,330,589 $ 49,858,805 20,365,557 19,107,861 4,564,999 203,589 $ 50,245,985 23,043,908 20,064,476 3,297,773 259,142 $ 30,640,151 11,164,042 16,934,578 3,495,062 203,589 $ 62,437,422 19,218,654 9,201,515 2,173,283 1,069,937 - 619,913,811 94,100,811 96,911,284 31,663,389 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 34,986 1,899,771 4,356,083 145,672 1,022,015 114,281 2,003,740 337,244 1,228,601 1,284,918 209,397 1,819,235 8,352 1,647,240 613,835 474,851 125,963 457,032 2,005,352 1,471,443 1,065 1,200,583 144,368 1,518,496 1,404,416 56,256 769,026 115,111 813,939 104,744 1,200,468 1,297,534 195,568 2,415,382 8,367 1,210,696 213,185 477,535 156,346 2,580,920 913,316 1,135 1,200,169 - 34,986 1,899,771 4,356,083 145,672 1,022,015 114,281 2,003,740 337,244 1,228,601 1,284,918 209,397 1,819,235 8,352 1,647,240 613,835 474,851 125,963 457,032 2,005,352 1,471,443 1,065 1,200,583 General Obligation Debt Service 17,493 949,885 2,178,042 72,836 511,007 57,141 1,001,870 168,622 614,301 642,459 104,698 909,618 4,176 823,620 306,918 237,425 125,934 228,516 1,002,675 735,722 533 602,511 72,184 759,248 702,208 28,128 384,513 57,556 406,969 52,372 600,234 648,767 97,784 1,207,691 4,184 605,348 106,593 238,767 78,173 1,290,460 456,658 567 599,765 11,296,002 8,398,169 Total Debt Service 74,164,415 22,461,659 16,796,977 - 22,461,659 22,192,270 15,502,165 Capital Improvement 574,383,309 39,622,598 30,262,020 - 39,622,598 $ 230,596,667 $ 250,821,141 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 - 643,842,016 $ 647,140,698 $ 517,798,018 $ 126,043,998 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 8,802,162 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 158 $ 63,200 142,509 1,059,645 1,620,951 22,288 1,532 640,775 9,526 707,776 296,614 (1,185) 3,005,001 147,523 2,831,334 12,906,363 126,502 63,437 1,052,216 192,150 4,438,975 823,332 102,120 3,489,461 362,035 916,173 44,836 195,131 1,981,042 3,477,156 5,443,586 22,040 9,998,637 Total Capital Improvement Program $ 508,031,971 $ 23,454,010 $ 32,728,829 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,224,591,803 $ $ 13,735,487 3,689,083 284,998 1,830,989 18,850,159 38,390,716 $ 61,844,726 $ $ 27,182,404 3,916,225 53,067 3,024,205 5,241,821 39,417,722 $ 72,146,551 2014-15 Year-to-Date Capital Amounts From Operating Funds From Capital Funds Budget Actual Budget $ 51,574 $ 8,381,140 1,200,000 1,652,162 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 $ 62,888 142,509 1,012,634 891,523 244,355 1,564 81 (16,913) 2,746,384 27,872 2,762,152 8,358,919 259,628,823 $ $ $ 28,117,700 5,868,367 29,202,053 73,266,111 178,300,255 314,754,486 $ 574,383,309 - 32 - 16,233,968 $ $ 3,169,259 280,916 32,396 1,785,395 18,120,664 23,388,630 $ 39,622,598 $ $ $ 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 158 312 47,011 729,428 22,288 1,532 396,420 7,962 707,776 296,533 15,728 258,617 119,651 69,182 4,547,444 248,403,148 $ 7,220,042 $ 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,125,416 8,482,766 1,057,491 7,742,517 815,770 11,722,635 1,404,810 35,931,703 599,474 49,140,694 1,179,868 6,351,637 70,243,001 3,102,802 120,805,288 17,957,644 146,914,445 $ 484,577,961 $ 10,566,228 3,408,167 252,602 45,594 729,495 15,002,086 $ $ 305,573,748 22,628,284 36,264,999 129,390,694 184,311,391 678,169,116 $ 22,222,128 $ 1,162,747,077 Bonds Authorized and Sold As of August 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 YTD thru Aug 64,831 68,114 68,281 71,949 71,779 72,367 Oct Nov Dec Jan Feb Mar Apr May June Sept 33,087 33,371 34,254 35,873 Oct 32,143 34,746 33,337 35,068 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 36,183 35,841 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 YTD thru Aug 18,031 17,535 18,662 19,925 20,815 21,304 Oct Nov Dec Jan Feb Mar Apr May June Sept 8,684 8,993 9,240 10,012 Oct 8,642 9,177 9,229 9,923 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,610 10,622 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 YTD thru Aug 9,358 8,180 8,475 9,415 9,967 9,878 Nov Dec Jan Feb Mar Apr May June Sept 3,722 3,842 3,852 3,992 Oct 4,018 3,669 3,535 3,912 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 4,296 4,220 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 YTD thru Aug 52,969 52,031 54,312 53,796 54,138 50,902 Nov Dec Jan Feb Mar Apr May June Sept 26,824 27,570 28,144 26,677 Oct 38,540 26,280 30,124 26,505 Nov 13,697 27,849 26,471 26,222 Dec 27,977 29,526 28,146 27,171 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 26,087 29,009 22,510 26,948 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 - 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 55,000 13-14 Actuals 50,000 Budget 14-15 14-15 Actuals 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 YTD thru Aug 88,465 93,200 121,837 91,154 90,850 99,206 Nov Dec Jan Feb Mar Apr May June Sept 39,640 47,230 42,446 41,144 Oct 30,588 35,860 34,197 34,917 Nov 26,585 30,215 36,338 34,774 Dec 21,157 20,946 25,523 22,327 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 46,550 36,860 33,299 23,429 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 - 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 YTD thru Aug 38,697 38,093 35,604 35,886 36,845 35,400 Nov Dec Jan Feb Mar Apr May June Sept 20,379 19,500 17,930 18,224 Oct 18,860 19,161 17,684 17,798 Nov 18,540 26,283 20,958 20,452 Dec 27,453 18,864 17,744 17,763 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 17,979 17,652 21,868 17,564 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 -