September 2014 Monthly Financial Report PREPARED BY Financial Accounting & Reporting Division City of Phoenix Monthly Financial Report September 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 performance status in the table of contents to Criminal Justice 2 Better than Expected Public Safety 2 Monitor & Consider Corrective Action 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 Better than Expected Table of Contents Citywide Total Operating Expenditures 5 Better than Expected General Government 5 Better than Expected Criminal Justice 6 Better than Expected 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. 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 13 Performance Status Monitor & Consider Corrective Action Property Tax 14 Expected Local Sales Tax 15 Monitor & Consider Corrective Action 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. September 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 September YTD Annual % of Annual Expenditures Expenditures * Expenditures 257,057 954,795 26.9% 267,880 995,771 26.9% 279,193 1,038,092 26.9% 280,430 1,042,102 26.9% 276,573 1,103,572 25.1% * - For prior years-total actual expenditures, for current year-total approved budget net of adjustment for contingencies. Better than Expected Total General Fund General Government $1,200,000 $1,200,000 September YTD September 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 September 2014, general fund expenditures are performing better than expected as year to date expenditures are 1.4% lower than through September 2013. General Government September YTD Annual % of Annual Expenditures Expenditures * Expenditures 10-11 24,593 70,650 34.8% 11-12 27,008 98,577 27.4% 12-13 25,377 102,211 24.8% 13-14 30,218 100,400 30.1% 14-15 20,801 109,033 19.1% * - 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 September YTD Expenditures September YTD Expenditures Annual Expenditures * $40,000 $40,000 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 September 2014 with a 31.2% 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. -1- September 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 September YTD Annual % of Annual Expenditures Expenditures * Expenditures 8,794 33,324 26.4% 8,901 33,542 26.5% 8,909 33,453 26.6% 8,837 32,659 27.1% 8,540 34,031 25.1% * - 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 September YTD Expenditures September 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 September 2014 with a 3.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. Public Safety 10-11 11-12 12-13 13-14 14-15 Transportation Public Safety September YTD Annual % of Annual Expenditures Expenditures * Expenditures 166,555 639,691 26.0% 170,483 647,049 26.3% 174,097 684,609 25.4% 179,254 699,796 25.6% 190,371 726,963 26.2% * - For prior years-total actual expenditures, for current year-total approved budget Monitor & Consider Corrective Action $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 September YTD Expenditures September 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 September 2014 are 6.2% higher than the same period in the prior year. The increase is primarily due to increased personnel costs and a decrease in cost recovery from the Aviation Department. An overhead cost recovery entry for $3.3 million was posted in September 2013. The corresponding entry for fiscal year 2014-15 will be posted in October 2014. The fiscal year 2014-15 budget includes a 3.9% increase over fiscal year 2013-14 actuals. - 2- September 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 September YTD Annual % of Annual Expenditures Expenditures * Expenditures 10,435 38,711 27.0% 13,330 39,161 34.0% 21,138 38,161 55.4% 12,127 29,713 40.8% 10,518 39,756 26.5% * - 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 September YTD Expenditures September 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 September 2014 with a 13.3% decrease 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 September YTD Annual % of Annual Expenditures Expenditures * Expenditures 5,415 19,458 27.8% 5,063 19,393 26.1% 5,147 19,927 25.8% 5,805 20,210 28.7% 5,507 22,241 24.8% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected $25,000 $25,000 September SeptemberYTD 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 September 2014 with a 5.1% 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- September 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 September YTD Annual % of Annual Expenditures Expenditures * Expenditures 37,424 137,793 27.2% 38,540 140,026 27.5% 40,003 141,209 28.3% 40,852 143,665 28.4% 36,853 150,195 24.5% * - 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 SeptemberYTD YTD September 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 September 2014 with a 9.8% 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 September YTD Annual % of Annual Expenditures Expenditures * Expenditures 3,773 14,046 26.9% 4,243 15,723 27.0% 4,375 15,353 28.5% 3,214 13,748 23.4% 3,621 18,508 19.6% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected 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 September 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 are better than expected through September 2014 with a 12.7% increase over 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. September 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 September YTD Annual % of Annual Expenditures Expenditures * Expenditures 856,406 3,026,005 28.3% 842,588 2,985,410 28.2% 866,821 3,123,865 27.7% 875,622 3,054,098 28.7% 884,329 3,512,673 25.2% * - For prior years-total actual expenditures, for current year-total approved budget net of adjustments for contingencies and use of the early redemption fund. Total Citywide General Government $4,000,000 $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 September YTD September Expenditures YTD 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 1.0% from the prior year through September 2014. General Government September YTD Annual % of Annual Expenditures Expenditures * Expenditures 10-11 26,629 78,047 34.1% 11-12 28,448 109,658 25.9% 12-13 27,597 114,015 24.2% 13-14 32,870 114,235 28.8% 14-15 27,267 122,878 22.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 September YTD Expenditures September YTD Expenditures $80,000 $60,000 Annual Expenditures * Annual Expenditures * $60,000 $40,000 $40,000 $20,000 $20,000 $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 17.0% through September 2014 from the prior September. The decrease is primarily due to the recovery of information technology costs from the enterprise funds for the tech plan and from RWC for shared site costs. The budget anticipated an increase of 7.6% for fiscal year 2014-15 over prior year actuals. -5- September Citywide YTD Expenditures (Dollars in Thousands) Criminal Justice September YTD Annual % of Annual Expenditures Expenditures * Expenditures 10-11 10,466 36,958 28.3% 11-12 9,669 36,305 26.6% 12-13 10,921 41,290 26.4% 13-14 11,039 40,697 27.1% 14-15 10,653 46,819 22.8% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected Refer to detailed financial schedules pages 21 thru 33 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 September YTD Expenditures September 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 September 2014 of 3.5% from the prior September. 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 September YTD Annual % of Annual Expenditures Expenditures * Expenditures 205,887 792,002 26.0% 209,017 803,367 26.0% 213,211 842,387 25.3% 215,823 842,270 25.6% 221,999 874,993 25.4% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected Transportation Public Safety $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 September YTD Expenditures September 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 September 2014 expenditures 2.9% higher than the prior year. The budgeted increase for fiscal year 2014-15 over prior year actuals is 3.9%. -6- September 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 September YTD Annual % of Annual Expenditures Expenditures * Expenditures 240,465 567,830 42.3% 252,103 584,429 43.1% 252,044 582,381 43.3% 262,977 573,025 45.9% 264,029 610,044 43.3% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected Transportation Community Development $700,000 $600,000 September YTD Expenditures September 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 September 2014 of 0.4% over the prior September. 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 September YTD Annual % of Annual Expenditures Expenditures * Expenditures 50,561 176,114 28.7% 43,736 192,133 22.8% 57,735 209,403 27.6% 56,259 194,542 28.9% 57,641 230,064 25.1% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected CommunityDevelopment Enrichment Community $250,000 $250,000 SeptemberYTD YTD September 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 increase at September 2014 of 2.5% over the prior September. These expenditures were budgeted to increase 18.3% for fiscal year 2014-15 over prior year actuals. -7- September 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 September YTD Annual % of Annual Expenditures Expenditures * Expenditures 78,332 274,824 28.5% 76,048 272,353 27.9% 74,312 273,110 27.2% 75,351 272,326 27.7% 65,538 285,034 23.0% * - For prior years-total actual expenditures, for current year-total approved budget Environmental Services Community Enrichment $300,000 $300,000 SeptemberYTD YTD September 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 September 2014 of 13.0% from the prior September. The decrease is primarily related to a timing difference related to recording the annual marketing contract for the Phoenix Convention Center with the Greater Phoenix Convention and Visitors Bureau. 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 September YTD Annual % of Annual Expenditures Expenditures * Expenditures 148,971 572,693 26.0% 137,984 549,628 25.1% 158,138 564,051 28.0% 143,143 577,118 24.8% 137,560 616,265 22.3% * - 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 SeptemberYTD YTD September 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 September 2014 of 3.9% from the prior September. The budgeted increase for fiscal year 2014-15 over prior year actuals is 6.8%. -8- September 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 September YTD Annual % of Annual Expenditures Expenditures * Expenditures 48,092 196,779 24.4% 42,232 157,298 26.8% 34,100 137,208 24.9% 25,197 100,524 25.1% 33,627 148,544 22.6% * - 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 SeptemberYTD YTD September 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 September 2014, year to date expenditures are 33.5% higher than the prior September. -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) $ 41,392 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) $ 29,889 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) $ 5,437 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) $ 373 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) $ 2,987 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) $ 26,064 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 Sept 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 Sept YTD Actuals 199,266 196,183 204,582 218,035 221,316 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 20.7% 20.7% 20.9% 21.2% 20.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 September 2014 is 1.5%. 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 469 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 Sept 1,279 1,189 904 867 816 936 14-15 YTD 14-15 budget 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 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 Monitor & Consider Corrective Action Local sales tax revenues through September 2014 are 1.4% 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 Local sales tax revenues saw a net increase from fiscal year 2012-13 to fiscal year 2013-14. However, in five of the eight 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.8% 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 September 2014 are 1.7% 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 September 2014 state shared sales tax revenues were 4.8% higher than through September 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 September 2014 are 3.2% 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 September 2014 were 2.3% higher than through September 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 September 2014 were better than expected at 6.5% 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 September 2014, aviation operating revenues are 1.9% higher than through September 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 12.5% below budget projections through September 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 September 2014, year to date revenues through September 2014 are 3.6% below revenues through September 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 September 2014 are better than expected at 3.4% 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 September 30 (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 $ 107,068 $ 156 107,822 165 135,474 175,174 54,300 137,956 2,833 9,495 31,367 43,796 13,716 441 672 3 29,936 40,321 13,407 531 671 (2) 17,722 1,015 13,487 1,025 7,361 1,431 3,928 3,797 174 3,344 282 1,704 290 1,449 4,179 197 2,035 251 1,847 341 750 32,500 13,596 1,800 17,331 7,204 2,340 618 2,895 7,932 2,668 312 4,672 $ 1,060,289 - 21 - $ 221,316 $ 218,035 General Fund Expenditures As of September 30 (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 $ 404 $ 860 844 2,877 441 584 4,577 946 773 2,299 800 4,391 1,005 20,801 451 876 788 10,239 691 637 5,139 877 1,058 2,257 939 5,337 929 30,218 29,049 4,982 34,031 7,335 1,205 8,540 7,730 1,107 8,837 Public Safety Police Fire Others Total Public Safety 471,386 255,563 14 726,963 124,251 66,112 8 190,371 116,568 62,664 22 179,254 Transportation Street Transportation Public Transit Total Transportation 21,554 18,202 39,756 4,749 5,769 10,518 5,437 6,690 12,127 Community Development Economic Development Neighborhood Services Department Planning and Development Others Total Community Development 4,796 12,481 4,910 54 22,241 1,349 2,989 1,157 12 5,507 1,390 3,198 1,205 12 5,805 Community Enrichment Parks and Recreation Library Human Services Others Total Community Enrichment 92,913 35,515 18,895 2,872 150,195 23,849 7,785 4,079 1,140 36,853 25,703 8,926 5,060 1,163 40,852 Environmental Services Public Works Environmental Programs Total Environmental Services 17,663 845 18,508 3,457 164 3,621 3,015 199 3,214 2,845 362 123 - - Capital Improvement Contingencies Total Expenditures and Encumbrances 45,268 $ 1,148,840 - 22 - $ 276,573 $ 280,430 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 September 30 (dollars in thousands) Source General Funds Local Taxes: Sales Taxes Privilege License Fees State Shared Taxes: State Sales Tax State Income Tax Vehicle License Tax Primary Property Tax Licenses and Permits Cable Communications Municipal Court Police Library Fees Parks and Recreation Planning & Development Street Transportation Fire Interest Other Fees and Service Charges Budget Estimate 2014-15 $ Total General Funds 431,320 2,541 107,822 165 1,060,289 221,316 218,035 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 7,383 22,411 7,355 862 40,899 7,116 14,988 3,784 2,796 26,058 6,980 1,178 4,488 31,730 28 7,097 21,851 7,000 834 41,749 6,201 14,864 3,949 2,747 23,630 6,300 1,633 5,644 59,425 45 944,825 178,056 202,969 322,353 63,497 415,361 214,792 150,150 81,994 12,668 127,561 55,181 37,214 80,473 11,729 132,298 54,110 36,946 1,166,153 314,618 315,556 713,990 $ 736,560 Enterprise Funds Aviation Convention Center Water System Wastewater Solid Waste $ 107,068 $ 156 31,367 43,796 13,716 441 672 3 3,971 3,344 282 1,704 290 1,449 9,544 618 2,895 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 - $ 29,936 40,321 13,407 531 671 (2) 4,376 2,035 251 1,847 341 750 10,600 312 4,672 Citywide Operating Expenditures As of September 30 (dollars in thousands) Source General Government General Funds Other Funds Total General Government Actual Year-to-Date 2014-15 2013-14 Budget 2014-15 $ 20,801 $ 6,466 27,267 30,218 2,652 32,870 34,031 12,788 46,819 8,540 2,113 10,653 8,837 2,202 11,039 Public Safety General Funds Other Funds Total Public Safety 726,963 148,030 874,993 190,371 31,628 221,999 179,254 36,569 215,823 Transportation General Funds Other Funds Total Transportation 39,756 570,288 610,044 10,518 253,511 264,029 12,127 250,850 262,977 Community Development General Funds Other Funds Total Community Development 22,241 207,823 230,064 5,507 52,134 57,641 5,805 50,454 56,259 Community Enrichment General Funds Other Funds Total Community Enrichment 150,195 134,839 285,034 36,853 28,685 65,538 40,852 34,499 75,351 Environmental Services General Funds Other Funds Total Environmental Services 18,508 597,757 616,265 3,621 133,940 137,561 3,214 139,929 143,143 74,164 74,164 33,627 33,627 25,197 25,197 2,845 575,187 578,032 362 65,652 66,014 123 52,840 52,963 45,268 48,500 93,768 - - 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 1,148,840 2,383,221 3,532,061 - 24 - $ $ 276,573 607,756 884,329 $ 280,430 595,192 875,622 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 September 30 2014 2013 Budget Estimate 2014-15 Source Actual Year-to-Date 2014-15 2013-14 General Funds $ 35,289,788 40,556 $ 35,873,023 49,741 Local Taxes: Sales Taxes Privilege License Fees $ 431,320,000 2,541,000 $ 107,068,436 155,935 $ 107,822,340 164,699 35,330,344 35,922,764 Total Local Taxes 433,861,000 107,224,371 107,987,039 10,552,413 14,598,650 3,748,792 10,011,815 13,440,181 3,991,879 State Shared Taxes: State Sales Tax State Income Tax Vehicle License Tax 135,474,000 175,174,000 54,300,000 31,367,357 43,795,949 13,716,239 29,936,335 40,320,543 13,406,543 28,899,855 27,443,875 364,948,000 88,879,545 83,663,421 628,233 645,207 Primary Property Tax 137,956,000 441,308 530,631 253,680 255,578 Licenses and Permits 2,833,000 672,202 670,848 Cable Communications 9,495,000 3,262 Municipal Court: Fines and Forfeitures Court Default Fee 17,721,789 1,015,000 3,796,990 173,560 - - 1,212,551 56,319 1,069,033 62,094 1,268,870 1,131,127 1,692,177 628,071 110,191 70,348 368,437 364,261 Total State Shared Taxes Total Municipal Court Police (2,001) 4,178,556 197,495 18,736,789 3,970,550 4,376,051 13,487,000 3,343,863 2,035,028 Library Fees 1,025,000 281,777 250,884 Parks and Recreation 7,361,300 1,704,142 1,847,087 103,603 146,496 Planning and Development 1,431,400 290,198 340,816 766,112 124,357 Street Transportation 3,928,108 1,448,471 750,677 1,972,647 67,700 443,513 2,178,474 72,825 2,250,821 32,500,000 1,400,000 12,195,773 7,204,093 186,759 2,153,449 7,932,475 142,075 2,525,789 2,483,860 4,502,120 46,095,773 9,544,301 10,600,339 245,368 101,990 1,800,000 617,574 312,078 1,501,871 1,362,109 73,652,601 72,698,303 Fire: Emergency Transportation Service Hazardous Materials Inspection Fee Other Total Fire Interest Other Fees and Service Charges Total General Funds - 25 - 17,330,894 2,894,743 4,672,018 1,060,289,264 221,316,307 218,034,916 Citywide Operating Revenue by Source (continued) For the Month Ended September 30 2014 2013 Budget Estimate 2014-15 Source Actual Year-to-Date 2013-14 2014-15 Special Revenue and Debt Service Funds $ 1,665,477 118,962 594,812 5,654 $ 1,603,349 114,524 572,625 39,616 2,384,905 2,330,114 5,537,690 2,012,567 (9,822) 5,395,705 1,977,079 (8,214) 7,540,435 7,364,570 2,399,022 2,304,066 164,132 6,333 140,893 (2,957) (11,590) 172,594 5,226 146,244 (4,532) (12,096) 296,811 307,436 8,494,680 5,569,278 9,161,994 4,564,723 14,063,958 13,726,717 - 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 Total Golf Courses Transit 2000: Sales Taxes Interest/Other Total Transit 2000 21,791,000 1,556,000 7,783,000 5,000 $ 5,108,296 364,878 1,824,391 85,385 $ 4,864,533 347,466 1,737,334 147,292 31,135,000 7,382,950 7,096,625 66,032,000 22,381,000 (67,500) 16,540,434 5,900,391 (30,084) 16,063,992 5,810,577 (23,219) 88,345,500 22,410,741 21,851,350 31,337,000 7,355,462 7,000,403 5,722,702 311,350 2,352,140 (70,000) 399,500 487,090 19,575 375,975 (8,226) (12,035) 464,071 14,461 380,313 (12,694) (12,515) 8,715,692 862,379 833,636 115,177,000 52,021,458 26,335,292 14,563,400 27,797,332 13,951,938 167,198,458 40,898,692 41,749,270 4,385,818 7,115,640 6,200,633 5,083,633 Court Awards 3,544,956 4,692,697 Planning and Development 42,783,000 14,988,186 14,863,753 1,242,781 1,299,127 Capital Construction 15,470,000 3,783,782 3,949,216 890,902 11,257 912,535 10,968 Sports Facilities: Sales Taxes Interest/Other 16,451,000 250,000 2,758,815 37,573 2,711,931 35,117 902,159 923,503 16,701,000 2,796,388 2,747,048 Total Sports Facilities - 26 - Citywide Operating Revenue by Source (continued) For the Month Ended September 30 2014 2013 Budget Estimate 2014-15 Source Actual Year-to-Date 2013-14 2014-15 Special Revenue and Debt Service Funds (Cont'd) $ 8,799,343 26,171 13,852 7,666,429 15,720 44,600 8,839,366 7,726,749 Highway User Revenue: Highway User Revenue Interest Other 106,383,000 200,000 200,000 25,834,081 73,493 150,152 23,536,358 44,699 48,998 106,783,000 26,057,726 23,630,055 Regional Transit Revenues 46,596,781 6,980,408 6,300,142 Community Reinvestment 2,608,664 1,178,048 1,633,453 44,684,752 4,487,570 5,643,806 Total Highway User Revenue 1,899,625 2,096,835 1,014,227 36,297 315,589 1,339,670 Other Restricted Fees 595,456 5,258,781 650,911 Grants: Public Housing: Rentals Grants Other 744,666 5,431,026 204,415 $ 6,380,107 6,505,148 4,473,346 3,328 23,486 3,852,183 3,725,381 19,457,560 160,546 5,971,958 $ Total Public Housing Other: Human Resources Federal Transit Administration Community Development Other 7,109,137 74,501,952 4,714,782 $ 1,579,827 14,978,488 172,682 $ 1,565,022 13,143,507 1,569,740 86,325,871 16,730,997 16,278,269 40,078,832 72,253,928 31,945,433 52,142,725 4,071,292 (1,154,789) 4,842,370 7,239,644 5,027,657 21,577,938 4,881,117 11,660,464 8,352,343 29,315,445 Total Other 196,420,918 14,998,517 43,147,176 14,732,450 35,820,593 Total Grants 282,746,789 31,729,514 59,425,445 187,309 - 221,394 1,874 50,404,017 4,928,832 27,841 177 187,309 223,268 59,363,593 85,275,275 G.O. Bond/Secondary Property Tax Secondary Property Tax Interest Total G.O. Bond/Secondary Property Tax Total Special Revenue and Debt Service Funds 46,663 (1,992) 55,332,849 28,018 44,671 944,824,303 178,055,504 202,969,506 131,840,000 182,337,300 800,000 2,498,000 1,895,125 2,982,075 - 25,667,991 54,060,540 201,311 687,833 532,900 740,567 102,370 25,631,163 52,608,399 341,603 755,893 535,745 735,618 (135,348) 322,352,500 81,993,512 80,473,073 Enterprise Funds AVIATION: 8,480,486 18,609,434 71,995 252,979 182,758 247,294 10,481 8,716,395 17,161,933 127,337 320,906 180,464 246,914 (77,225) 27,855,427 26,676,724 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 September 30 2014 2013 Budget Estimate 2014-15 Source Actual Year-to-Date 2014-15 2013-14 Enterprise Funds (Cont'd) CONVENTION CENTER: 3,146,489 705,537 21,612 3,056,996 700,114 17,409 3,873,638 3,774,519 Excise Taxes Operating Revenue Interest Total Convention Center 47,993,000 15,328,192 175,863 10,009,515 2,599,032 59,990 9,375,492 2,305,029 48,524 63,497,055 12,668,537 11,729,045 WATER SYSTEM: $ 34,451,492 457,030 320,374 663,915 207,420 254,161 356,258 $ 36,710,650 38,854,689 492,731 389,806 521,867 175,500 154,088 555,499 41,144,180 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 $ 121,066,190 1,314,281 1,617,805 1,995,484 525,000 621,880 420,457 $ 126,068,043 1,553,458 1,442,602 1,434,878 540,300 434,229 824,695 415,361,000 127,561,097 132,298,205 182,029,000 16,199,000 2,400,000 1,348,000 12,816,000 45,757,686 4,970,985 499,200 322,517 3,630,755 45,386,824 4,829,206 506,400 276,098 3,111,159 214,792,000 55,181,143 54,109,687 128,235,000 9,720,000 270,000 11,925,446 31,912,040 2,182,779 115,034 3,004,351 31,662,938 2,145,407 90,985 3,046,218 150,150,446 37,214,204 36,945,548 1,166,153,001 314,618,493 315,555,558 WASTEWATER: 15,295,308 1,700,069 191,760 104,323 1,045,099 15,194,048 1,605,002 168,120 95,754 1,160,802 18,336,559 18,223,726 Sewer Service Charges Multi-City Development Fees Interest Other Total Wastewater SOLID WASTE: $ 10,643,115 731,364 39,565 964,512 10,567,747 644,154 33,121 1,520,527 12,378,556 12,765,549 99,154,830 102,584,698 232,171,024 $ 260,558,276 Collection Fees Landfill Fees Interest Other Total Solid Waste Total Enterprise Funds Total Operating Revenues $ - 28 - 3,171,266,568 $ 713,990,304 $ 736,559,980 Citywide Operating Expenditures by Program For the Month Ended September 30 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 $ 176,432 319,045 159,828 2,575,052 203,298 186,765 217,918 1,470,461 204,506 225,776 60,273 842,162 113,736 7,084 256,395 1,537,467 467,179 9,023,377 $ 166,989 314,679 269,770 3,455,315 151,304 177,655 206,650 1,705,945 138,769 373,174 204,803 802,099 (8,448) 8,191 279,849 1,679,249 456,022 10,382,015 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 $ 404,049 859,662 775,660 3,452,382 308,511 563,803 685,819 4,824,768 945,837 772,576 243,302 2,704,653 432,635 20,385 800,095 5,059,019 4,413,746 $ 450,938 876,456 869,267 10,767,074 341,746 768,329 742,048 5,392,914 877,161 1,057,957 549,787 2,522,224 15,707 22,212 938,521 6,252,841 425,195 $ 404,049 859,662 775,660 3,056,327 308,511 563,803 685,819 4,824,768 945,837 772,576 243,302 2,417,396 432,635 20,385 800,095 5,018,785 4,413,746 $ 396,055 287,257 40,234 - 122,877,786 27,266,902 32,870,377 26,543,356 723,546 41,837,569 4,981,585 9,448,213 1,204,983 9,931,802 1,107,199 7,823,006 1,204,983 1,625,207 - 46,819,154 10,653,196 11,039,001 9,027,989 1,625,207 570,433,037 304,086,736 472,781 146,377,904 75,498,109 123,034 142,993,959 72,681,354 147,782 144,641,963 74,595,786 123,034 1,735,941 902,323 - 874,992,554 221,999,047 215,823,095 219,360,783 2,638,264 Criminal Justice 2,797,753 396,993 2,880,682 362,175 3,194,746 3,242,857 Municipal Court Public Defender Total Criminal Justice Public Safety 45,497,387 24,336,797 49,794 42,113,839 22,350,622 58,379 69,883,978 64,522,840 Police Fire Other Total Public Safety - 29 - Citywide Operating Expenditures by Program (continued) For the Month Ended September 30 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 $ 3,168,738 981,753 23,695,674 8,254,980 36,101,145 $ 4,961,086 977,529 22,771,249 5,168,229 33,878,093 Street Transportation Street Lighting Aviation Public Transit Total Transportation $ 60,347,257 11,676,247 285,060,223 252,960,307 $ 14,732,411 2,906,213 65,923,528 180,466,877 $ 15,210,749 2,833,281 67,567,001 177,365,709 $ 14,702,694 2,906,213 53,325,021 166,225,798 $ 29,717 12,598,507 14,241,079 610,044,034 264,029,029 262,976,740 237,159,726 26,869,303 Community Development 2,928,865 10,400,823 4,438,591 2,450,752 3,221,774 6,679,085 4,405,873 4,676,774 Planning and Development Housing Economic Development Neighborhood Services Department 46,760,869 88,592,415 35,505,370 59,205,414 10,142,552 24,822,956 14,371,243 8,304,225 9,563,445 20,340,347 13,966,681 12,388,281 10,142,552 24,803,914 5,783,058 8,304,225 19,042 8,588,185 - 20,219,031 18,983,506 Total Community Development 230,064,068 57,640,976 56,258,754 49,033,749 8,607,227 102,825,230 36,062,173 8,354,628 60,752,841 11,048,412 60,440,955 4,007,435 1,542,517 26,070,547 7,890,145 1,905,323 12,878,109 2,766,191 12,317,453 828,978 881,397 27,460,017 9,118,544 1,825,588 19,992,432 2,734,800 12,578,698 772,573 868,781 25,590,808 7,890,145 1,905,323 8,231,166 12,244,089 828,978 881,397 479,739 4,646,943 2,766,191 73,364 - 285,034,191 65,538,143 75,351,433 57,571,906 7,966,237 Community Enrichment 7,195,444 2,552,126 606,162 3,989,837 920,388 5,440,891 283,796 59,424 8,380,208 2,739,929 569,013 3,400,375 910,103 3,822,816 259,689 57,539 21,048,068 20,139,672 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 September 30 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 $ 23,438,252 9,993,865 9,420,560 504,957 101,984 $ 43,459,618 23,865,860 12,315,352 8,772,244 1,157,316 120,614 46,231,386 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 73,297,057 30,359,422 28,528,421 5,069,956 305,573 $ 74,111,845 35,359,260 28,836,720 4,455,089 379,756 $ 44,352,295 16,557,575 25,269,642 3,467,391 305,573 $ 89,952,476 28,944,762 13,801,847 3,258,779 1,602,565 - 137,560,429 143,142,670 47,607,953 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 52,478 2,849,657 6,534,124 218,509 1,533,023 171,421 3,005,610 505,866 1,842,901 1,927,377 314,096 2,728,852 12,528 2,470,860 920,752 712,277 125,963 685,547 3,008,030 2,207,164 1,597 1,798,690 216,551 2,277,744 2,106,624 84,384 1,153,538 172,666 1,220,909 157,116 1,800,702 1,946,302 293,353 3,623,072 12,550 1,816,044 319,777 716,303 2,200 234,519 3,871,380 1,369,974 1,703 1,799,934 - 52,478 2,849,657 6,534,124 218,509 1,533,023 171,421 3,005,610 505,866 1,842,901 1,927,377 314,096 2,728,852 12,528 2,470,860 920,752 712,277 125,963 685,547 3,008,030 2,207,164 1,597 1,798,690 General Obligation Debt Service 17,492 949,886 2,178,041 72,837 511,008 57,140 1,001,870 168,622 614,300 642,459 104,699 909,617 4,176 823,620 306,917 237,426 228,515 1,002,678 735,721 532 598,107 72,183 759,248 702,208 28,128 384,512 57,555 406,970 52,372 600,234 648,768 97,785 1,207,690 4,183 605,348 106,592 238,768 2,200 78,173 1,290,460 456,658 568 599,765 11,165,663 8,400,368 Total Debt Service 74,164,415 33,627,322 25,197,345 - 33,627,322 26,391,053 22,700,791 Capital Improvement 578,031,992 66,013,651 52,962,811 - 66,013,651 $ 240,486,679 $ 228,481,528 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 - $ 884,328,695 $ 875,622,226 $ 688,649,985 $ 195,678,710 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 Total Capital Improvement Program Enterprise Aviation Phoenix Convention Center Solid Waste Disposal Wastewater Water System Enterprise Subtotal Total Capital Budget Program 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 368 $ 746,371 439,741 1,223,206 1,708,135 262,383 2,937 904,447 10,770 715,640 304,088 21,375 4,250,759 239,024 6,811,478 108,412 23,643,120 310,796 673,249 1,993,086 1,560,968 3,700,000 1,006,177 117,585 4,508,197 370,681 2,085,286 49,717 267,736 2,467,214 3,513,695 7,121,659 23,340 18,172,829 $ 511,680,654 $ 41,392,254 $ 47,942,215 $ $ $ 319,309,235 26,317,367 36,549,997 131,221,683 203,161,550 716,559,832 $ $ 29,888,939 5,436,522 372,824 2,986,604 26,064,174 64,749,063 $ 1,228,240,486 $ 106,141,317 2014-15 Year-to-Date Capital Amounts From Operating Funds From Capital Funds Actual Budget Budget $ $ $ $ 34,010,363 5,633,729 65,687 4,566,809 13,759,740 58,036,328 $ 105,978,543 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 315 745,965 439,741 1,134,510 939,474 385,128 2,578 81 1,102 3,973,931 28,032 6,694,311 18,011,178 263,277,506 $ 32,356,346 $ $ 28,117,700 5,868,367 29,202,053 73,266,111 178,300,255 314,754,486 $ 578,031,992 - 32 - $ $ $ $ 4,564,074 324,272 108,853 3,366,619 25,293,487 33,657,305 $ 66,013,651 Unencumbered Budget Actual 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 406 88,696 768,661 262,383 2,937 519,319 8,192 715,640 304,007 20,273 276,828 210,992 117,167 108,412 5,631,942 248,403,148 $ 9,035,908 $ $ 291,191,535 20,449,000 7,347,944 57,955,572 24,861,295 401,805,346 $ 650,208,494 $ 1,125,206 7,799,595 760,259 11,227,639 728,586 11,482,540 1,403,405 35,668,031 598,230 49,132,830 1,172,394 6,329,077 68,997,243 3,011,301 116,825,144 17,849,232 136,177,688 $ 470,288,400 $ $ 25,324,865 5,112,250 263,971 (380,015) 770,687 31,091,758 $ 289,420,296 20,880,845 36,177,173 128,235,079 177,097,376 651,810,769 $ 40,127,666 $ 1,122,099,169 Bonds Authorized and Sold As of September 30 (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 Oct Sept 33,087 33,371 34,254 35,873 35,290 36,183 YTD thru Sept 97,918 101,486 102,535 107,822 107,069 108,550 Nov Dec Jan Feb Mar Apr May June 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 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 Sept 8,684 8,993 9,240 10,012 10,552 10,610 Oct YTD thru Sept 26,715 26,528 27,902 29,936 31,367 31,914 Nov Dec Jan Feb Mar Apr May June 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,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 Sept 3,722 3,842 3,852 3,992 3,749 4,296 Nov YTD thru Sept 13,080 12,022 12,327 13,407 13,716 14,174 Dec Jan Feb Mar 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,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 - Apr May June 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 YTD thru Sept 79,794 79,602 82,456 80,473 81,994 76,989 Dec Jan Feb Mar Apr May June 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 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 Sept 39,640 47,230 42,446 41,144 36,711 46,550 Nov YTD thru Sept 128,105 140,431 164,283 132,298 127,561 145,756 Dec Jan Feb Mar Apr May June 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 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 Sept 20,379 19,500 17,930 18,224 18,337 17,979 Nov YTD thru Sept 59,076 57,593 53,534 54,110 55,181 53,379 Dec Jan Feb Mar 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,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 - Apr May June