November 2014 Monthly Financial Report PREPARED BY Financial Accounting & Reporting Division City of Phoenix Monthly Financial Report November 2014 Table of Contents Expenditures by Programs Page Performance Status General Fund Expenditures General Fund Total Expenditures 1 Better than Expected Report Navigation General Government 1 Better than Expected Click on either the schedule name or the Criminal Justice 2 Better than Expected performance status in the table of contents to Public Safety 2 Better than Expected be taken directly to that page of the report. Transportation 3 Better than Expected Community Development 3 Better than Expected From any page of the report, click on the Community Enrichment 4 Better than Expected City of Phoenix Bird Emblem to return to the Environmental Services 4 Monitor & Consider Corrective Action Citywide Total Operating Expenditures 5 Better than Expected General Government 5 Better than Expected Criminal Justice 6 Better than Expected Table of Contents Citywide Expenditures Performance Status Public Safety 6 Better than Expected Better than Expected - Positive variance of Transportation 7 Better than Expected greater than 1% actual vs budget. Community Development 7 Better than Expected Expected - Actual vs budget variance within 1% Community Enrichment 8 Better than Expected positive or negative. Environmental Services 8 Better than Expected Monitor and Consider Taking Action - Negative General Obligation Debt Service 9 Better than Expected variance greater than 1% actual vs budget. Capital Expenditures CIP-General Government 10 Corrective Action Taken - Negative variance CIP-Aviation 10 greater than 1% actual vs budget, however the CIP-Phoenix Convention Center 11 City has taken action to address the negative CIP-Solid Waste Disposal 11 variance. CIP-Wastewater 12 CIP-Water System 12 Revenues by Source Page Performance Status General Fund Total Operating Revenue 13 Expected Property Tax 14 Better than Expected Local Sales Tax 15 Corrective Action Taken State Sales Tax 16 Monitor & Consider Corrective Action Vehicle License Tax 17 Expected Aviation 18 Better than Expected Water System 19 Monitor & Consider Corrective Action Wastewater 20 Monitor & Consider Corrective Action 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. November General Fund YTD Expenditures (Dollars in Thousands) Refer to detailed financial schedules pages 21 thru 33 Total General Fund Expenditures Total General Fund General Government November YTD Annual % of Annual Expenditures Expenditures * Expenditures 418,447 954,795 43.8% 424,412 995,771 42.6% 450,253 1,038,092 43.4% 450,295 1,042,102 43.2% 452,319 1,103,572 41.0% $1,200,000 $1,200,000 * - For prior years-total actual expenditures, for current year-total approved budget net of adjustment for contingencies. $200,000 $200,000 $0 $0 10-11 11-12 12-13 13-14 14-15 Better than Expected November YTD November YTD Expenditures Expenditures $1,000,000 $1,000,000 $800,000 $800,000 $600,000 $600,000 $400,000 $400,000 Annual Annual Expenditures * Expenditures * 10-11 10-11 11-12 12-13 13-14 11-12 12-13 14-15 13-14 In order to have a better comparison to prior year actuals, contingencies will only be included in the annual budget to the extent that they have been spent. The general fund provides for core City functions that are not provided by dedicated revenue streams. It does not include services provided by dedicated taxes, grants, bond proceeds or enterprise fund revenues. For fiscal year 2014-15, general fund expenditures were budgeted to increase 5.9% over fiscal year 2013-14 actuals. Through November 2014, general fund expenditures are performing better than expected as year to date expenditures are 0.4% higher than through November 2013. General Government Criminal Justice General Government November YTD Annual % of Annual Expenditures Expenditures * Expenditures 39,987 70,650 56.6% 44,029 98,577 44.7% 44,878 102,211 43.9% 48,471 100,400 48.3% 43,081 109,033 39.5% $120,000 $120,000 $100,000 $100,000 $80,000 $80,000 $60,000 $60,000 $40,000 $40,000 * - For prior years-total actual expenditures, for current year-total approved budget $20,000 $20,000 10-11 11-12 12-13 13-14 14-15 Better than Expected November YTD Expenditures November YTD Expenditures Annual Expenditures * Annual Expenditures * $0$0 10-11 11-12 11-12 10-11 12-13 12-13 13-14 13-14 14-15 General government expenditures include costs for administrative and internal service functions such as the Mayor and City Council, City Manager's Office, City Auditor, Finance, Budget and Research, and Human Resources. General fund general government expenditures are better than expected through November 2014 with an 11.1% decrease from the same period in the prior year. The decrease is primarily due to the receipt of Information Technology Services assessments from other funds for the FY2014-15 Tech Plan and Regional Wireless Cooperative costs. The fiscal year 2014-15 budget includes an 8.6% increase over fiscal year 2013-14 actuals. Year to date general government expenditures in the general fund through November 2014 are at their lowest level since fiscal year 2010-11. -1- November 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 November YTD Annual % of Annual Expenditures Expenditures * Expenditures 14,134 33,324 42.4% 14,232 33,542 42.4% 14,468 33,453 43.2% 14,120 32,659 43.2% 13,609 34,031 40.0% * - 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 November YTD Expenditures November 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 November 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. General fund criminal justice expenditures have been relatively flat for the past four years with a variance of less than 3% between the highest and lowest year. Through November 2014, the year to date expenditures are lower than in the previous four years. Public Safety 10-11 11-12 12-13 13-14 14-15 Transportation Public Safety November YTD Annual % of Annual Expenditures Expenditures * Expenditures 269,449 639,691 42.1% 273,005 647,049 42.2% 290,290 684,609 42.4% 294,031 699,796 42.0% 302,503 726,963 41.6% * - For prior years-total actual expenditures, for current year-total approved budget Better than 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 November YTD Expenditures November YTD Expenditures 10-11 11-12 12-13 13-14 14-15 Annual Expenditures * Annual Expenditures * $0 10-11 11-12 12-13 13-14 Public safety expenditures include costs for police and fire services. General fund public safety expenditures through November 2014 are better than expected with a 2.9% 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. Although there have been staffing reductions in both police and fire, general fund public safety expenditures have increased each of the last five years as the savings realized by the staff level reductions have been applied to the special revenue funds for public safety dedicated sales taxes. - 2- November 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 November YTD Annual % of Annual Expenditures Expenditures * Expenditures 20,615 38,711 53.3% 17,437 39,161 44.5% 17,773 38,161 46.6% 15,026 29,713 50.6% 16,331 39,756 41.1% * - 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 November YTD Expenditures November 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 November 2014 with an 8.7% increase over the same period in the prior year. The fiscal year 2014-15 budget includes a 33.8% increase over fiscal year 2013-14 actuals. As part of the plan to reduce the food tax in January 2014, Public Transit used savings achieved by refunding transit bonds to reduce the amount of support needed from the General Fund for fiscal year 2013-14. The 2014-15 budget includes the restoration of the General Fund support for Public Transit resulting in the large year over year increase. Community Development Community Enrichment Community Development 10-11 11-12 12-13 13-14 14-15 November YTD Annual % of Annual Expenditures Expenditures * Expenditures 8,720 19,458 44.8% 8,361 19,393 43.1% 8,798 19,927 44.2% 9,255 20,210 45.8% 8,559 22,241 38.5% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected $25,000 $25,000 November NovemberYTD 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 November 2014 with a 7.5% 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- November 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 November YTD Annual % of Annual Expenditures Expenditures * Expenditures 59,087 137,793 42.9% 60,592 140,026 43.3% 64,528 141,209 45.7% 63,311 143,665 44.1% 59,080 150,195 39.3% * - 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 NovemberYTD YTD November 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 November 2014 with a 6.7% 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. Through November 2014, general fund community enrichment year to date expenditures are lower than the previous four fiscal years. Right sourcing efforts have resulted in decreased personnel costs partially offset by increased contractual costs over the last few years. Environmental Total GeneralServices Fund Environmental Services 10-11 11-12 12-13 13-14 14-15 November YTD Annual % of Annual Expenditures Expenditures * Expenditures 6,345 14,046 45.2% 6,351 15,723 40.4% 8,662 15,353 56.4% 5,712 13,748 41.5% 7,823 18,508 42.3% * - For prior years-total actual expenditures, for current year-total approved budget Monitor & Consider Corrective Action $20,000 $18,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 November YTD Expenditures Annual Expenditures * 10-11 10-11 11-12 13-14 11-1212-13 12-13 14-15 13-14 Environmental service expenditures include costs for maintaining and operating city facilities. General Fund environmental services expenditures through November 2014 are 37.0% 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 resulting from a decrease in equipment maintenance requests from the operating departments. 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. November 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 November YTD Annual % of Annual Expenditures Expenditures * Expenditures 1,323,639 3,026,005 43.7% 1,295,745 2,985,410 43.4% 1,358,940 3,123,865 43.5% 1,360,917 3,054,098 44.6% 1,373,955 3,512,673 39.1% * - 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 November YTD November YTD Expenditures Expenditures Annual Annual Expenditures * Expenditures * 10-11 10-11 11-12 12-13 13-14 11-12 12-13 14-15 13-14 In order to have a better comparison to prior year actuals, contingencies will only be included in the annual budget to the extent that they have been spent. Additionally, per the note on General Obligation Debt Service Expenditures (Page 9), the credit for the use of the early redemption fund will not be included in the budgetary total. After these adjustments, the budget for fiscal year 2014-15 anticipated an increase of 15.0% in total operating expenditures. Actual expenditures are better than expected with a year to date increase of 1.0% from the prior year through November 2014. General Government 10-11 11-12 12-13 13-14 14-15 November YTD Annual % of Annual Expenditures Expenditures * Expenditures 43,390 78,047 55.6% 45,541 109,658 41.5% 46,796 114,015 41.0% 50,558 114,235 44.3% 46,872 122,878 38.1% * - 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 November YTD Expenditures November 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 7.3% through November 2014 from the prior November. The decrease is primarily due to the recovery of information technology costs from the enterprise funds for the tech plan and from the Regional Wireless Cooperative for shared site costs. The budget anticipated an increase of 7.6% for fiscal year 2014-15 over prior year actuals. -5- November 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 November YTD Annual % of Annual Expenditures Expenditures * Expenditures 17,064 36,958 46.2% 15,581 36,305 42.9% 17,822 41,290 43.2% 17,614 40,697 43.3% 17,126 46,819 36.6% * - 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 November YTD Expenditures November 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 November 2014 of 2.8% from the prior November. 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 November YTD Annual % of Annual Expenditures Expenditures * Expenditures 333,139 792,002 42.1% 337,082 803,367 42.0% 357,015 842,387 42.4% 354,032 842,270 42.0% 353,738 874,993 40.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 November YTD Expenditures November 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 November 2014 expenditures 0.1% lower than the prior year. The budgeted increase for fiscal year 2014-15 over prior year actuals is 3.9%. -6- November 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 November YTD Annual % of Annual Expenditures Expenditures * Expenditures 311,726 567,830 54.9% 321,150 584,429 55.0% 333,829 582,381 57.3% 333,855 573,025 58.3% 336,901 610,044 55.2% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected Transportation Community Development $700,000 $600,000 November YTD Expenditures November 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 November 2014 of 0.9% over the prior November. 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 November YTD Annual % of Annual Expenditures Expenditures * Expenditures 77,479 176,114 44.0% 77,227 192,133 40.2% 96,187 209,403 45.9% 91,309 194,542 46.9% 85,506 230,064 37.2% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected CommunityDevelopment Enrichment Community $250,000 $250,000 NovemberYTD YTD November Expenditures Expenditures $200,000 $200,000 $150,000 $150,000 $100,000 $100,000 $50,000 $50,000 $0 $0 Annual Expenditures * Annual Expenditures * 10-11 10-11 11-12 12-13 11-12 12-13 13-14 13-14 14-15 Community Development expenditures include costs for Neighborhood Services, Housing, Planning and Economic Development. Citywide community development expenditures are better than expected with a year to date decrease at November 2014 of 6.3% from the prior November. These expenditures were budgeted to increase 18.3% for fiscal year 2014-15 over prior year actuals. -7- November 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 November YTD Annual % of Annual Expenditures Expenditures * Expenditures 123,035 274,824 44.8% 119,392 272,353 43.8% 118,475 273,110 43.4% 117,958 272,326 43.3% 115,275 285,034 40.4% * - For prior years-total actual expenditures, for current year-total approved budget Environmental Services Community Enrichment $300,000 $300,000 NovemberYTD YTD November 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 November 2014 of 2.3% from the prior November. 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 November YTD Annual % of Annual Expenditures Expenditures * Expenditures 239,620 572,693 41.8% 230,984 549,628 42.0% 249,213 564,051 44.2% 241,024 577,118 41.8% 233,726 616,265 37.9% * - 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 NovemberYTD YTD November 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 November 2014 of 3.0% from the prior November. The budgeted increase for fiscal year 2014-15 over prior year actuals is 6.8%. -8- November 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 November YTD Annual % of Annual Expenditures Expenditures * Expenditures 80,149 196,779 40.7% 70,383 157,298 44.7% 56,948 137,208 41.5% 41,994 100,524 41.8% 55,960 148,544 37.7% * - 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 NovemberYTD YTD November 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 November 2014, year to date expenditures are 33.3% higher than the prior November. -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) $ 76,456 General Gov't Major Projects in fiscal year 2012-13 included Bus Acquisitions ($60 million), Sonoran Preserve Land Acquisitions ($25 million), Ballet Arizona and Arizona Opera facilities ($8 million), and the purchase of fire safety apparatus ($6 million). 14-15 (YTD) 14-15 (Budget) 13-14 Major Projects in fiscal year 2013-14 include technology acquisitions for E-Procurement and Regional Wireless Communications ($21 million), street projects (Avenida Rio Salado-$27 million, Sonoran Desert Drive-$14 million, Black Mountain Blvd ramps to SR51-$9 million, Pinnacle Peak Rd-$10 million, and Greenway Rd/Cave Creek Wash Bridge-$7 million), and Police PACE Upgrade/Replacement ($12 million). 12-13 11-12 10-11 $0 $200,000 $400,000 $600,000 Major Projects planned for fiscal year 2014-15 include the replacement of the City’s telephone system and data network ($36 million), continued work on Avenida Rio Salado and Black Mountain Blvd ramps to SR51 ($28 million), and an upgrade to the South Transit Facility ($19 million). Aviation 10-11 11-12 12-13 13-14 14-15 (Budget) 14-15 (YTD) $ 157,884 $ 332,920 $ 168,639 $ 180,571 $ 319,309 $ 159,131 Discussion: Aviation In fiscal year 2011-12 the department spent $190 million on stage 1a of the PHX Sky Train. In fiscal year 2013-14 the department spent $19 million on Terminal Development Concept Design. 14-15 (YTD) 14-15 (Budget) 13-14 Aviation has spent or committed $115.5 million of an expected $126 million in fiscal year 2014-15 for the Terminal Development Concept Design. In addition to normal reinvestment in the infrastructure of the airport system Aviation is planning to spend $23 million on Terminal 4 International Expansion. 12-13 11-12 10-11 $0 $100,000 $200,000 $300,000 - 10 - Capital Expenditures (Dollars in Thousands) 10-11 Phx Convention Ctr $ 4,493 Refer to detailed financial schedules pages 21 - 33 11-12 $ 1,644 12-13 $ 14-15 (Budget) 13-14 21,830 Discussion: $ 23,189 $ 26,317 14-15 (YTD) $ 11,079 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) $ 992 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) $ 5,363 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) $ 56,052 Discussion: Water System Major Projects in fiscal year 2010-11 included Val Vista GAC Contactors ($51 million), Rehabilitation of the 42nd St/Baseline Reservoir ($19 million), DBP mitigation at various water treatment plants ($27 million), and Residential Pressure Improvements ($41 million). 14-15 (YTD) 14-15 (Budget) 13-14 Major projects in fiscal year 2013-14 include construction of a new 20 million gallon concrete reservoir at Deer Valley WTP ($16 million). 12-13 11-12 10-11 $0 $100,000 $200,000 $300,000 Through November 2014, the water system has spent or committed $9.3 million for rehabilitation at the 24th Street water treatment plant and $24.0 million for improvements to the solids handling facility at the Union Hills water treatment plant. In addition to normal reinvestment in the infrastructure of the water system, an upgrade to the Customer Care and Billing system costing $7 million is planned in fiscal year 2014-15. - 12 - Revenues Sources of funds for the operations of the City including local taxes, state shared taxes, user fees and charges, and grants. General Fund Total Operating Revenue (Dollars in Thousands) Refer to detailed financial schedules pages 21 thru 33 General Fund Revenues $1,200,000 $1,000,000 Nov 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 Nov YTD Actuals 387,288 370,835 387,451 408,585 423,814 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 40.2% 39.1% 39.5% 39.8% 40.0% * - For prior years - total actual revenues, for current year - total approved budget Expected Fiscal Year 2014-15 general fund operating revenues were budgeted to increase 3.3% over prior year actuals. Actual year over year revenues are performing as expected with growth through November 2014 of 3.7%. Specific revenue sources are discussed on the following pages. - 13 - Property Taxes (Dollars in Thousands) Refer to detailed financial schedules pages 21 thru 33 Property Taxes Primary & Secondary 300,000 250,000 200,000 Secondary 149,019 94,436 62,012 35,204 128,054 132,101 143,931 150,000 50,404 Primary 100,000 50,000 130,913 137,956 20,344 56,123 10-11 FY 10-11 11-12 12-13 13-14 14-15 YTD 14-15 budget Total 279,932 222,488 194,112 179,136 76,467 188,360 11-12 July (3,017) (2,553) (1,733) (1,260) (1,107) (1,754) Aug 1,118 1,059 1,349 971 760 1,068 12-13 Sept 1,279 1,189 904 867 816 936 Oct 18,792 13,656 11,888 11,107 12,338 11,588 13-14 Nov 85,251 55,555 54,091 46,645 63,660 49,416 14-15 YTD 14-15 budget 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 32,866 6,919 4,504 6,706 8,422 39,405 28,284 Note: Monthly budget amount for 13-14 is the average % of last 3 years of the total budget amount Better than Expected Because property taxes are primarily collected in November, December, May and June, a monthly breakdown of the revenues is not particularly useful, therefore the chart for property tax revenues is presented with an annual perspective. Property tax revenues are 24.8 % higher than budget expectations through November 2014. This corresponds to a 31.1% increase over year to date revenues through November 2013. 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 42,000 40,000 38,000 36,000 14-15 Actuals 34,000 14-15 budget 32,000 30,000 28,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June Corrective Action Taken Local sales tax revenues through November 2014 are 2.7% below budget for that period. In October 2014 the budget and research department lowered their estimate for annual local sales tax revenues by $15.5 million. Expenditures are being monitored to ensure that they do not exceed the available resources based on this new estimate. Local Sales Tax 3 Year Trend 45,000 40,000 35,000 30,000 25,000 12-13 Actuals 20,000 13-14 Actuals 15,000 14-15 Actuals 10,000 5,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June Through November 2014, local sales tax revenues are 1.4% lower than the same period in the prior year. Local sales tax revenues saw a net increase from fiscal year 2012-13 to fiscal year 201314. However, in seven of the ten 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.9% 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 November 2014 are 2.2% 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 November 2014 state shared sales tax revenues were 4.9% higher than through November 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 through November 2014 are 0.3% 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 November 2014 were 4.9% higher than through November 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 November 2014 were better than expected at 5.9% 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 November 2014, aviation operating revenues are 2.2% higher than through November 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 11.9% below budget projections through November 2014 reflecting the record setting rainfall received in the 2014 monsoon. Water System Operating Revenues 3 Year Trend 90,000 80,000 70,000 12-13 Actuals 60,000 50,000 13-14 Actuals 40,000 14-15 Actuals 30,000 20,000 10,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June In July 2012 Water sold land in McMullen Valley for $29.7 million. Primarily due to the large amount of rainfall received in August and September 2014, year to date revenues through November 2014 are 5.8% below revenues through November 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 Monitor & Consider Corrective Action Wastewater revenues through November 2014 are 2.6% lower 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 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 November 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 $ 174,722 $ 465 177,253 663 135,474 175,174 54,300 137,956 2,833 9,495 51,969 72,993 22,329 56,123 970 2,260 49,531 67,201 21,276 46,998 980 2,430 17,722 1,015 13,487 1,025 7,361 1,431 3,928 6,117 281 5,874 356 2,543 485 2,332 6,728 314 4,236 378 2,861 551 1,494 32,500 13,596 1,800 17,331 12,503 4,129 1,045 6,318 12,672 5,260 717 7,042 1,060,289 - 21 - $ 423,814 $ 408,585 General Fund Expenditures As of November 30 (dollars in thousands) Budget Estimate 2014-15 Actual Year-to-Date 2014-15 2013-14 Expenditures and Encumbrances General Government Mayor City Council City Manager Information Technology Services Public Information Equal Opportunity Law City Auditor City Clerk Human Resources Budget and Research Finance Others Total General Government $ 1,831 3,537 2,366 37,168 2,072 2,336 19,960 2,410 4,244 9,871 2,956 18,277 2,005 109,033 659 $ 1,445 1,430 12,928 789 1,052 8,020 1,174 1,335 3,855 1,380 7,414 1,600 43,081 727 1,413 1,639 15,669 1,109 983 8,528 1,247 1,893 3,870 1,503 8,394 1,496 48,471 29,049 4,982 34,031 11,599 2,010 13,609 12,288 1,832 14,120 471,386 255,563 14 726,963 196,465 106,020 18 302,503 191,334 102,744 (47) 294,031 Transportation Street Transportation Public Transit Total Transportation 21,554 18,202 39,756 7,856 8,475 16,331 8,707 6,319 15,026 Community Development Economic Development Neighborhood Services Department Planning and Development Others Total Community Development 4,796 12,481 4,910 54 22,241 1,930 4,820 1,789 20 8,559 2,057 5,180 1,998 20 9,255 Community Enrichment Parks and Recreation Library Human Services Others Total Community Enrichment 92,913 35,515 18,895 2,872 150,195 37,248 13,639 6,719 1,474 59,080 39,769 14,392 7,893 1,257 63,311 Environmental Services Public Works Environmental Programs Total Environmental Services 17,663 845 18,508 7,572 251 7,823 5,387 325 5,712 2,845 1,333 369 45,268 - Criminal Justice Municipal Court Public Defender Total Criminal Justice Public Safety Police Fire Others Total Public Safety Capital Improvement Contingencies Total Expenditures and Encumbrances $ 1,148,840 - 22 - $ $ 452,319 $ 450,295 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 November 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 $ 177,253 663 49,531 67,201 21,276 46,998 980 2,430 7,042 4,236 378 2,861 551 1,494 17,932 717 7,042 1,060,289 423,814 408,585 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 12,142 36,582 12,082 1,822 64,601 7,419 21,905 6,236 5,316 42,884 12,258 2,357 13,886 65,269 20,344 11,725 35,693 11,646 1,777 69,220 6,201 20,977 6,508 5,268 39,190 10,359 1,992 13,956 98,810 11,332 944,825 325,103 344,654 322,353 63,497 415,361 214,792 150,150 136,093 23,019 190,292 90,464 62,314 133,200 20,575 201,989 92,360 61,428 1,166,153 502,182 509,552 Enterprise Funds Aviation Convention Center Water System Wastewater Solid Waste $ 174,722 465 51,969 72,993 22,329 56,123 970 2,260 6,398 5,874 356 2,543 485 2,332 16,632 1,045 6,318 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 - $ 1,251,099 $ 1,262,791 Citywide Operating Expenditures As of November 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 $ 43,081 $ 3,791 46,872 48,471 2,087 50,558 34,031 12,788 46,819 13,609 3,517 17,126 14,120 3,494 17,614 Public Safety General Funds Other Funds Total Public Safety 726,963 148,030 874,993 302,503 51,235 353,738 294,031 60,001 354,032 Transportation General Funds Other Funds Total Transportation 39,756 570,288 610,044 16,331 320,570 336,901 15,026 318,829 333,855 Community Development General Funds Other Funds Total Community Development 22,241 207,823 230,064 8,559 76,947 85,506 9,255 82,054 91,309 Community Enrichment General Funds Other Funds Total Community Enrichment 150,195 134,839 285,034 59,080 56,195 115,275 63,311 54,647 117,958 Environmental Services General Funds Other Funds Total Environmental Services 18,508 597,757 616,265 7,823 225,903 233,726 5,712 235,312 241,024 74,164 74,164 55,960 55,960 41,994 41,994 2,845 575,187 578,032 1,333 127,518 128,851 369 112,203 112,572 Criminal Justice General Funds Other Funds Total Criminal Justice Debt Service General Funds Other Funds Total Debt Service Capital Improvement General Funds Other Funds Total Capital Improvement Contingencies General Funds Other Funds Total Contingencies Total Operating General Funds Other Funds Total Operating Budget 109,033 13,845 122,878 $ 45,268 48,500 93,768 $ 1,148,840 2,383,221 3,532,061 - 24 - - $ 452,319 921,636 1,373,955 $ 450,295 910,621 1,360,916 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 November 30 2014 2013 Budget Estimate 2014-15 Source Actual Year-to-Date 2013-14 2014-15 General Funds $ 33,032,501 277,081 $ 34,362,907 301,933 Local Taxes: Sales Taxes Privilege License Fees $ 431,320,000 2,541,000 $ 174,721,683 465,189 $ 177,253,394 663,219 33,309,582 34,664,840 Total Local Taxes 433,861,000 175,186,872 177,916,613 10,295,460 14,598,650 4,197,690 9,672,528 13,440,181 3,957,809 State Shared Taxes: State Sales Tax State Income Tax Vehicle License Tax 135,474,000 175,174,000 54,300,000 51,969,411 72,993,248 22,328,566 49,531,470 67,200,905 21,275,889 29,091,800 27,070,518 364,948,000 147,291,225 138,008,264 46,673,250 37,575,817 Primary Property Tax 137,956,000 56,123,361 46,998,407 164,495 140,263 Licenses and Permits 2,833,000 970,056 979,603 Cable Communications 9,495,000 2,260,237 2,430,105 Municipal Court: Fines and Forfeitures Court Default Fee 17,721,789 1,015,000 6,117,280 280,760 6,728,515 313,537 18,736,789 6,398,040 7,042,052 13,487,000 5,874,276 4,235,587 Library Fees 1,025,000 355,653 377,722 - - Total State Shared Taxes 1,060,322 48,355 1,220,524 53,081 1,108,677 1,273,605 1,246,985 1,106,144 50,027 58,845 125,881 503,526 Parks and Recreation 7,361,300 2,543,474 2,860,866 109,109 105,631 Planning and Development 1,431,400 484,617 551,102 153,198 227,767 Street Transportation 3,928,108 2,332,051 1,493,420 2,269,115 72,900 54,449 2,640,396 66,100 2,192,791 32,500,000 1,400,000 12,195,773 12,502,928 318,259 3,810,403 12,672,360 258,325 5,001,500 2,396,464 4,899,287 46,095,773 16,631,590 17,932,185 220,594 154,651 1,800,000 1,044,953 716,663 17,330,894 6,317,578 7,042,225 1,060,289,264 423,813,983 408,584,814 1,181,064 115,831,126 (6,195) 107,774,699 Total Municipal Court Police Fire: Emergency Transportation Service Hazardous Materials Inspection Fee Other Total Fire Interest Other Fees and Service Charges Total General Funds - 25 - Citywide Operating Revenue by Source (continued) For the Month Ended November 30 2014 2013 Budget Estimate 2014-15 Source Actual Year-to-Date 2013-14 2014-15 Special Revenue and Debt Service Funds $ 1,613,952 115,282 576,412 16,649 $ 1,652,558 118,040 590,200 7,375 2,322,295 2,368,173 5,113,183 1,795,212 (9,672) 5,032,993 1,713,952 (10,117) 6,898,723 6,736,828 2,326,339 2,376,783 403,142 (1,505) 220,465 (3,338) 18,328 372,279 5,761 171,869 (5,372) 4,878 637,092 549,415 8,294,222 3,505,781 9,443,185 3,150,472 11,800,003 12,593,657 303,215 - 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 Court Awards 21,791,000 1,556,000 7,783,000 5,000 $ 8,386,383 599,027 2,995,137 161,870 $ 8,094,363 578,169 2,890,844 161,911 31,135,000 12,142,417 11,725,287 66,032,000 22,381,000 (67,500) 27,032,036 9,611,667 (61,327) 26,318,518 9,416,486 (42,137) 88,345,500 36,582,376 35,692,867 31,337,000 12,081,809 11,645,833 5,722,702 311,350 2,352,140 (70,000) 399,500 1,073,863 30,183 725,005 (15,111) 8,235 1,055,015 25,465 721,226 (23,134) (1,075) 8,715,692 1,822,175 1,777,497 115,177,000 52,021,458 43,206,177 21,394,751 46,253,500 22,966,120 167,198,458 64,600,928 69,219,620 4,385,818 7,418,855 6,200,633 3,583,536 3,024,629 Planning and Development 42,783,000 21,904,635 20,976,890 1,236,764 1,259,919 Capital Construction 15,470,000 6,235,677 6,507,754 1,371,531 132,486 1,373,079 143,368 Sports Facilities: Sales Taxes Interest/Other 16,451,000 250,000 5,134,687 181,635 5,078,115 189,393 1,504,017 1,516,447 16,701,000 5,316,322 5,267,508 Total Sports Facilities - 26 - Citywide Operating Revenue by Source (continued) For the Month Ended November 30 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,545,593 27,901 (1,778) 7,630,443 19,708 56,150 8,571,716 7,706,301 2,523,975 2,599,518 1,139,035 25,884 896,872 3,399,026 Other Restricted Fees 516,988 8,676,123 907,189 Grants: Public Housing: Rentals Grants Other 524,963 5,581,542 79,471 $ 6,185,976 10,100,300 3,659,719 1,306,650 3,263,419 2,767,470 3,208,010 4,267,380 4,904,673 4,976,593 10,997,258 17,356,656 17,183,234 27,456,956 16,986,483 - 9,069,278 3,034 16,986,483 9,072,312 77,913,299 80,685,848 106,383,000 200,000 200,000 42,600,471 131,989 151,171 38,780,190 82,934 327,323 106,783,000 42,883,631 39,190,447 Regional Transit Revenues 46,596,781 12,258,622 10,359,530 Community Reinvestment 2,608,664 2,357,102 1,991,922 44,684,752 13,885,801 13,955,503 Total Highway User Revenue $ Total Public Housing 7,109,137 74,501,952 4,714,782 $ 2,680,549 26,144,137 665,629 $ 2,657,938 25,558,556 2,761,649 86,325,871 29,490,315 30,978,143 40,078,832 72,253,928 31,945,433 52,142,725 11,011,406 3,281,204 8,139,929 13,345,884 10,578,615 26,299,663 9,855,389 21,098,352 Total Other 196,420,918 35,778,423 67,832,019 Total Grants 282,746,789 65,268,738 98,810,162 50,404,017 4,928,832 20,343,775 177 11,330,733 1,439 55,332,849 20,343,952 11,332,172 944,824,303 325,103,040 344,653,625 131,840,000 182,337,300 800,000 2,498,000 1,895,125 2,982,075 - 42,417,324 89,885,858 248,177 1,268,083 905,226 1,222,329 145,961 322,352,500 136,092,958 Other: Human Resources Federal Transit Administration Community Development Other G.O. Bond/Secondary Property Tax Secondary Property Tax Interest Total G.O. Bond/Secondary Property Tax Total Special Revenue and Debt Service Funds Enterprise Funds AVIATION: 8,699,264 18,244,258 23,325 176,672 188,751 247,549 30,523 8,658,276 15,521,125 71,391 1,536,482 179,340 247,314 8,167 27,610,342 26,222,095 Sky Harbor: Airlines Concessions Interest Other Phoenix-Goodyear Phoenix-Deer Valley Phoenix-Customer Facility Charge Total Aviation - 27 - 42,522,506 85,757,923 349,704 2,477,281 866,662 1,227,109 (751) 133,200,434 Citywide Operating Revenue by Source (continued) For the Month Ended November 30 2014 2013 Budget Estimate 2014-15 Source Actual Year-to-Date 2014-15 2013-14 Enterprise Funds (Cont'd) CONVENTION CENTER: 3,679,425 2,345,166 25,444 3,739,538 926,517 21,340 6,050,035 4,687,395 Excise Taxes Operating Revenue Interest Total Convention Center 47,993,000 15,328,192 175,863 16,960,408 5,946,868 111,435 16,283,218 4,201,466 90,306 63,497,055 23,018,711 20,574,990 WATER SYSTEM: $ 29,779,116 325,745 165,787 632,051 224,700 196,617 805,518 $ 32,129,534 33,023,842 430,989 161,217 482,625 125,520 179,308 370,537 34,774,038 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 $ 179,559,932 2,147,214 2,214,100 3,226,216 848,520 1,069,567 1,226,223 $ 191,828,663 2,565,972 1,897,273 2,397,647 802,920 804,823 1,691,912 415,361,000 190,291,772 201,989,210 182,029,000 16,199,000 2,400,000 1,348,000 12,816,000 75,946,594 8,121,389 803,820 567,898 5,024,703 75,418,709 7,968,919 756,420 501,341 7,714,487 214,792,000 90,464,404 92,359,876 128,235,000 9,720,000 270,000 11,925,446 53,185,203 3,689,622 202,197 5,237,193 52,784,737 3,470,076 141,071 5,032,279 150,150,446 62,314,215 61,428,163 1,166,153,001 502,182,060 509,552,673 WASTEWATER: 15,013,557 1,628,856 217,200 111,349 558,496 14,921,755 1,625,716 116,820 108,057 3,679,779 17,529,458 20,452,127 Sewer Service Charges Multi-City Development Fees Interest Other Total Wastewater SOLID WASTE: $ 10,630,006 755,974 41,867 1,188,856 10,566,312 411,207 19,896 978,529 12,616,703 11,975,944 95,936,072 98,111,599 289,680,497 $ 286,572,146 Collection Fees Landfill Fees Interest Other Total Solid Waste Total Enterprise Funds Total Operating Revenues $ - 28 - 3,171,266,568 $ 1,251,099,083 $ 1,262,791,112 Citywide Operating Expenditures by Program For the Month Ended November 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 $ 114,809 304,672 332,017 3,795,911 59,223 206,281 194,318 1,702,358 66,749 295,410 2,482 792,870 142,760 5,493 287,980 1,918,801 756,513 10,978,647 $ 134,228 258,449 333,170 3,242,279 167,799 203,455 192,602 1,783,489 238,129 479,046 62,542 868,170 14,071 7,804 293,493 1,894,211 557,017 10,729,954 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 $ 658,719 1,445,365 1,386,725 13,893,757 503,422 955,293 1,214,614 8,429,239 1,173,840 1,335,291 324,189 4,499,936 756,508 32,109 1,380,108 8,542,440 340,484 $ 726,592 1,413,262 1,773,113 16,555,215 726,282 1,193,522 1,152,881 8,972,749 1,246,627 1,893,116 678,410 4,311,372 55,535 36,256 1,503,059 9,954,369 (1,634,109) $ 658,719 1,445,365 1,386,725 13,233,666 503,422 955,293 1,214,614 8,429,239 1,173,840 1,335,291 324,189 4,021,174 756,508 32,109 1,380,108 8,475,384 340,484 $ 660,091 478,762 67,056 - 122,877,786 46,872,039 50,558,251 45,666,130 1,205,909 41,837,569 4,981,585 15,116,701 2,009,760 15,782,365 1,832,006 12,408,863 2,009,760 2,707,838 - 46,819,154 17,126,461 17,614,371 14,418,623 2,707,838 570,433,037 304,086,736 472,781 232,212,558 121,270,425 254,822 234,324,730 119,498,201 209,201 229,321,038 119,767,633 254,822 2,891,520 1,502,792 - 874,992,554 353,737,805 354,032,132 349,343,493 4,394,312 Criminal Justice 2,610,531 399,697 2,947,098 364,725 3,010,228 3,311,823 Municipal Court Public Defender Total Criminal Justice Public Safety 40,528,687 21,137,716 77,209 43,185,490 22,428,903 91,691 61,743,612 65,706,084 Police Fire Other Total Public Safety - 29 - Citywide Operating Expenditures by Program (continued) For the Month Ended November 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,994,646 877,773 20,103,691 7,527,957 32,504,067 $ 4,665,280 918,897 23,604,019 6,528,805 35,717,001 Street Transportation Street Lighting Aviation Public Transit Total Transportation $ 60,347,257 11,676,247 285,060,223 252,960,307 $ 24,314,137 4,756,520 112,860,093 194,970,534 $ 24,692,287 4,599,186 114,344,530 190,219,009 $ 24,264,609 4,756,520 91,871,485 171,236,842 $ 49,528 20,988,608 23,733,692 610,044,034 336,901,284 333,855,012 292,129,456 44,771,828 Community Development 3,016,123 6,245,287 2,098,256 2,883,399 3,326,878 5,918,503 1,671,677 4,344,289 Planning and Development Housing Economic Development Neighborhood Services Department 46,760,869 88,592,415 35,505,370 59,205,414 16,406,513 33,454,103 21,155,197 14,490,201 16,363,047 32,506,378 20,080,373 22,359,292 16,406,513 33,422,751 9,383,276 14,490,201 31,352 11,771,921 - 14,243,065 15,261,347 Total Community Development 230,064,068 85,506,014 91,309,090 73,702,741 11,803,273 102,825,230 36,062,173 8,354,628 60,752,841 11,048,412 60,440,955 4,007,435 1,542,517 40,751,551 13,821,967 2,860,090 29,110,946 4,606,968 21,709,266 1,390,750 1,023,341 42,610,060 14,829,768 3,408,872 27,686,163 4,555,006 22,654,841 1,335,751 877,778 39,951,987 13,821,967 2,860,090 21,365,521 21,586,992 1,390,750 1,023,341 799,564 7,745,425 4,606,968 122,274 - 285,034,191 115,274,879 117,958,239 102,000,648 13,274,231 Community Enrichment 6,872,616 2,294,010 383,268 4,640,735 920,388 4,562,083 232,345 41,205 7,145,435 2,981,495 939,464 4,121,572 910,103 5,230,680 152,579 68,134 19,946,650 21,549,462 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 November 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 $ 21,468,937 9,716,230 5,450,263 5,338,033 119,129 $ 42,092,592 22,833,261 11,032,546 8,386,953 2,041,600 128,788 44,423,148 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 $ 123,939,048 51,508,310 45,183,669 13,020,030 74,437 $ 123,628,118 57,676,218 51,305,120 7,783,611 631,340 $ 75,642,749 28,505,798 42,515,847 7,590,259 74,437 $ 154,329,090 48,296,299 23,002,512 2,667,822 5,429,771 - 616,265,128 233,725,494 241,024,407 79,396,404 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 87,464 4,749,428 10,890,207 364,181 2,555,038 285,701 5,009,350 843,110 3,071,502 3,212,295 523,493 4,548,086 20,880 4,118,100 1,534,587 1,187,129 125,985 1,142,579 5,013,383 3,678,607 2,662 2,996,205 360,919 3,796,240 3,511,040 140,639 1,922,564 287,777 2,034,849 261,860 3,001,169 3,243,836 488,921 6,038,454 20,917 3,026,740 532,962 1,193,839 2,213 390,865 6,452,299 2,283,291 2,839 2,999,463 - 87,464 4,749,428 10,890,207 364,181 2,555,038 285,701 5,009,350 843,110 3,071,502 3,212,295 523,493 4,548,086 20,880 4,118,100 1,534,587 1,187,129 125,985 1,142,579 5,013,383 3,678,607 2,662 2,996,205 General Obligation Debt Service 17,493 949,886 2,178,042 72,836 511,008 57,140 1,001,870 168,622 614,301 642,459 104,699 909,617 4,176 823,620 306,917 237,426 15 228,516 1,002,676 735,721 532 599,443 72,184 759,248 702,208 28,128 384,513 57,555 406,970 52,372 600,234 648,767 97,784 1,207,691 4,184 605,348 106,593 238,768 13 78,173 1,290,460 456,658 568 599,764 11,167,015 8,398,183 Total Debt Service 74,164,415 55,959,972 41,993,696 - 55,959,972 24,713,156 29,183,055 Capital Improvement 578,031,992 128,851,143 112,571,630 - 128,851,143 $ 220,399,032 $ 234,280,057 Aviation Cultural Facilities Downtown Development Early Redemption Economic Development Fire Protection Freeway Mitigation Historic/Neighborhood Preservation Human Services Information Systems Libraries Maintenance Service Centers Mountain Preserves/Parks Municipal Administration Buildings Police Protection Public Housing Renovation Sanitary Sewers Secondary Property Tax Solid Waste Enterprise Bonds Storm Sewer Improvements Street Improvements Street Light Refinancing Water System Contingencies Total Operating Budget 93,768,000 $ - 3,532,061,322 $ - 31 - 1,373,955,091 $ 1,360,916,828 $ 1,031,590,181 $ 342,364,910 Capital Expenditures and Encumbrances 2014-15 Program Budget General Government Arts and Cultural Facilities Economic Development Energy Conservation Facilities Management Finance Fire Protection Historic Preservation Housing Human Services Information Technology Libraries Neighborhood Services Parks and Mountain Preserves Police Protection Public Transit Regional Wireless Cooperative Street Transportation & Drainage 2013-14 Actual Yearto-Date Actual Yearto-Date $ 1,125,574 $ 8,545,966 1,200,000 12,450,845 2,436,721 11,744,923 1,406,342 36,572,478 609,000 49,848,470 1,476,482 6,350,452 73,248,002 3,250,325 123,636,622 17,957,644 159,820,808 2,092 $ 1,108,222 579,103 5,882,535 1,725,072 386,905 41,097 1,368,855 13,566 9,385,997 304,260 277,957 8,593,449 277,134 8,335,611 130,275 38,043,410 622,051 893,531 3,472,268 3,255,673 3,703,481 1,539,705 152,193 6,324,602 761,603 8,541,357 115,911 483,776 6,401,265 8,544,042 11,601,679 23,340 58,844,960 Total Capital Improvement Program $ 511,680,654 $ 76,455,540 $ 115,281,437 Enterprise Aviation Phoenix Convention Center Solid Waste Disposal Wastewater Water System Enterprise Subtotal Total Capital Budget Program $ $ 319,309,235 26,317,367 36,549,997 131,221,683 203,161,550 716,559,832 $ 1,228,240,486 $ $ 159,131,499 11,079,470 991,735 5,362,718 56,051,836 232,617,258 $ 309,072,798 $ $ 89,365,702 8,917,459 102,142 6,178,461 23,426,008 127,989,772 $ 243,271,209 2014-15 Year-to-Date Capital Amounts From Operating Funds From Capital Funds Budget Actual Budget $ $ $ 51,574 $ 8,381,140 1,200,000 5,300,845 1,161,446 7,944,250 17,299,618 1,200,391 200,000 3,201,373 42,931,503 3,182,088 95,545,813 75,677,465 2,039 1,107,601 579,103 5,077,183 948,790 648,122 3,249 81 85,285 8,022,165 39,076 7,994,565 33,024,291 263,277,506 $ 57,531,550 $ 28,117,700 5,868,367 29,202,053 73,266,111 178,300,255 314,754,486 $ 578,031,992 - 32 - $ $ 7,783,742 2,559,053 715,012 5,432,201 54,829,585 71,319,593 $ 128,851,143 $ $ $ 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 621 805,352 776,282 386,905 41,097 720,733 10,317 9,385,997 304,179 192,672 571,284 238,058 341,046 130,275 5,019,119 248,403,148 $ 18,923,990 $ 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,123,482 7,437,744 620,897 6,568,310 711,649 11,358,018 1,365,245 35,203,623 595,434 40,462,473 1,172,222 6,072,495 64,654,553 2,973,191 115,301,011 17,827,369 121,777,398 $ 435,225,114 $ 151,347,757 8,520,417 276,723 (69,483) 1,222,251 161,297,665 $ $ 160,177,736 15,237,897 35,558,262 125,858,965 147,109,714 483,942,574 $ 180,221,655 $ 919,167,688 Bonds Authorized and Sold As of November 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 Sept 33,087 33,371 34,254 35,873 35,290 36,183 Oct Nov Oct 32,143 34,746 33,337 35,068 34,621 35,841 Dec Nov 32,952 31,854 33,430 34,363 33,033 35,127 YTD thru Nov 163,013 168,085 169,302 177,253 174,722 179,518 Jan Feb Mar Apr May June 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 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 Nov Oct 8,642 9,177 9,229 9,923 10,307 10,622 Dec Nov 8,687 9,083 9,456 9,673 10,295 10,601 YTD thru Nov 44,044 44,787 46,587 49,531 51,969 53,137 Jan Feb Mar Apr May June 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,849 13,439 10,782 11,228 12,214 11,652 12,173 Note: City of Phoenix revenue is budgeted on an annual basis. 2014-15 monthly budget amounts are based on an allocation of the annual budget. Monthly budget amounts are calculated based on an allocation of FY 2010-11 through 2013-14 actual expenditures. Return to Summary Page - A2 - Vehicle License Tax (Dollars in Thousands) Vehicle License Tax 5,500 10-11 Actuals 11-12 Actuals 5,000 12-13 Actuals 13-14 Actuals 4,500 14-15 Actuals 4,000 Budget 14-15 3,500 3,000 2,500 2,000 July FY 10-11 11-12 12-13 13-14 14-15 Budget 14-15 Aug July 5,217 4,482 4,493 4,752 4,963 5,282 Sept Aug 4,141 3,698 3,982 4,663 5,004 4,596 Oct Sept 3,722 3,842 3,852 3,992 3,749 4,296 Nov Oct 4,018 3,669 3,535 3,912 4,415 4,220 Dec Nov 3,224 3,089 3,582 3,958 4,198 3,862 Jan YTD thru Nov 20,323 18,780 19,444 21,276 22,329 22,256 Feb Mar Apr May June 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,389 4,195 4,442 5,259 4,137 4,633 4,990 Note: City of Phoenix revenue is budgeted on an annual basis. 2014-15 monthly budget amounts are based on an allocation of the annual budget. Monthly budget amounts are calculated based on an allocation of FY 2010-11 through 2013-14 actual expenditures. Return to Summary Page - A3 - Aviation Revenues (Dollars in Thousands) Aviation Operating Revenues 40,000 10-11 Actuals 11-12 Actuals 35,000 12-13 Actuals 13-14 Actuals 30,000 14-15 Actuals Budget 14-15 25,000 20,000 15,000 10,000 July FY 10-11 11-12 12-13 13-14 14-15 Budget 14-15 Aug July 26,581 27,628 28,080 31,036 27,544 27,068 Sept Aug 26,388 24,404 26,231 22,760 26,594 23,834 Oct Sept 26,824 27,570 28,144 26,677 27,855 26,087 Nov Oct 38,540 26,280 30,124 26,505 26,489 29,009 Dec Nov 13,697 27,849 26,471 26,222 27,610 22,510 Jan YTD thru Nov 132,031 133,730 139,051 133,200 136,093 128,508 Feb Mar Apr 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,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 - May June Water System Revenues (Dollars in Thousands) Water System Operating Revenues 80,000 75,000 70,000 10-11 Actuals 65,000 12-13 Actuals 60,000 13-14 Actuals 55,000 50,000 14-15 Actuals 11-12 Actuals Budget 14-15 45,000 40,000 35,000 30,000 25,000 20,000 15,000 10,000 July FY 10-11 11-12 12-13 13-14 14-15 Budget 14-15 Aug July 47,691 48,584 79,417 49,017 50,166 52,833 Sept Aug 40,774 44,616 42,419 42,137 40,684 46,373 Oct Sept 39,640 47,230 42,446 41,144 36,711 46,550 Nov Oct 30,588 35,860 34,197 34,917 30,601 36,860 Dec Nov 26,585 30,215 36,338 34,774 32,130 33,299 Jan YTD thru Nov 185,278 206,506 234,817 201,989 190,292 215,915 Feb Mar Apr 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 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 - May June Wastewater Revenues (Dollars in Thousands) Wastewater Operating Revenues 10-11 Actuals 27,000 11-12 Actuals 12-13 Actuals 22,000 13-14 Actuals 14-15 Actuals Budget 14-15 17,000 12,000 7,000 2,000 July FY 10-11 11-12 12-13 13-14 14-15 Budget 14-15 Aug July 18,867 18,754 17,547 17,634 18,325 17,423 Sept Aug 19,831 19,339 18,057 18,252 18,520 17,977 Oct Sept 20,379 19,500 17,930 18,224 18,337 17,979 Nov Oct 18,860 19,161 17,684 17,798 17,754 17,652 Dec Nov 18,540 26,283 20,958 20,452 17,529 21,868 Jan YTD thru Nov 96,476 103,036 92,177 92,360 90,464 92,899 Feb Mar Apr May June 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,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 -