January 2015 Monthly Financial Report PREPARED BY Financial Accounting & Reporting Division City of Phoenix Monthly Financial Report January 2015 Table of Contents Expenditures by Programs Page Performance Status General Fund Expenditures General Fund Total Expenditures 1 Better than Expected Report Navigation General Government 1 Better than Expected Click on either the schedule name or the Criminal Justice 2 Better than Expected performance status in the table of contents to Public Safety 2 Better than Expected be taken directly to that page of the report. Transportation 3 Better than Expected Community Development 3 Better than Expected From any page of the report, click on the Community Enrichment 4 Better than Expected City of Phoenix Bird Emblem to return to the Environmental Services 4 Better than Expected Table of Contents Citywide Total Operating Expenditures 5 Better than Expected General Government 5 Better than Expected Criminal Justice 6 Better than Expected Citywide Expenditures Performance Status Public Safety 6 Better than Expected Better than Expected - Positive variance of Transportation 7 Better than Expected greater than 1% actual vs budget. Community Development 7 Better than Expected Expected - Actual vs budget variance within 1% Community Enrichment 8 Better than Expected positive or negative. Environmental Services 8 Better than Expected Monitor and Consider Taking Action - Negative General Obligation Debt Service 9 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 General Fund Total Operating Revenue Page 13 Performance Status Monitor & Consider Corrective Action 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. January 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 January YTD Annual % of Annual Expenditures Expenditures * Expenditures 575,172 954,795 60.2% 592,428 995,771 59.5% 624,431 1,038,092 60.2% 626,815 1,042,102 60.1% 623,286 1,103,572 56.5% $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 January YTD January 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 are budgeted to increase 5.9% over fiscal year 2013-14 actuals. Through January 2015, general fund expenditures are performing better than expected as year to date expenditures are 0.6% lower than through January 2014. General Government Criminal Justice General Government January YTD Annual % of Annual Expenditures Expenditures * Expenditures 55,405 70,650 78.4% 61,237 98,577 62.1% 61,422 102,211 60.1% 64,431 100,400 64.2% 59,182 109,033 54.3% $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 January YTD Expenditures January 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 January 2015 with an 8.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 January 2015 are at their lowest level since fiscal year 2010-11. -1- January 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 January YTD Annual % of Annual Expenditures Expenditures * Expenditures 19,575 33,324 58.7% 19,686 33,542 58.7% 20,127 33,453 60.2% 19,729 32,659 60.4% 18,769 34,031 55.2% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected Criminal Justice Public Safety $40,000 $40,000 $35,000 $35,000 $30,000 $30,000 $25,000 $25,000 $20,000 $20,000 $15,000 $15,000 $10,000 $5,000 $10,000 $0 $5,000 January YTD Expenditures January 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 January 2015 with a 4.9% 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 January 2015, 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 January YTD Annual % of Annual Expenditures Expenditures * Expenditures 376,630 639,691 58.9% 385,251 647,049 59.5% 407,056 684,609 59.5% 415,773 699,796 59.4% 419,830 726,963 57.8% * - 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 January YTD Expenditures January 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 January 2015 are better than expected with a 1.0% 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- January 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 January YTD Annual % of Annual Expenditures Expenditures * Expenditures 23,486 38,711 60.7% 23,317 39,161 59.5% 23,982 38,161 62.8% 18,112 29,713 61.0% 21,255 39,756 53.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 January YTD Expenditures January YTD Expenditures 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 public transit and street maintenance and repair. 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. Therefore, the fiscal year 2014-15 budget includes a 33.8% increase over fiscal year 2013-14 actuals. General fund transportation expenditures are better than expected through January 2015 with a 17.4% increase over the same period in the prior year. Even with the restoration of the General Fund support for Public Transit, year to date expenditures through January are lower in fiscal year 201415 than in fiscal years 2010-11, 2011-12 or 2012-13. Community Development Community Enrichment Community Development 10-11 11-12 12-13 13-14 14-15 January YTD Annual % of Annual Expenditures Expenditures * Expenditures 11,797 19,458 60.6% 11,803 19,393 60.9% 12,218 19,927 61.3% 12,912 20,210 63.9% 11,897 22,241 53.5% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected $25,000 $25,000 January JanuaryYTD 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 11-12 12-13 13-14 13-14 14-15 Community development expenditures include costs for economic development and neighborhood services. General fund community development expenditures are better than expected through January 2015 with a 7.9% 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- January 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 January YTD Annual % of Annual Expenditures Expenditures * Expenditures 81,366 137,793 59.0% 80,393 140,026 57.4% 85,747 141,209 60.7% 85,563 143,665 59.6% 80,276 150,195 53.4% * - 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 JanuaryYTD YTD January 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 January 2015 with a 6.2% decrease from 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 January 2015, general fund community enrichment year to date expenditures are lower than the previous four 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 January YTD Annual % of Annual Expenditures Expenditures * Expenditures 6,631 14,046 47.2% 8,948 15,723 56.9% 12,147 15,353 79.1% 9,608 13,748 69.9% 11,638 18,508 62.9% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected $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 January YTD Expenditures Annual Expenditures * 10-11 10-11 11-12 13-14 11-12 12-13 12-13 14-15 13-14 Environmental service expenditures include costs for maintaining and operating city facilities. General Fund environmental services expenditures through January 2015 are 21.1% 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. Historically, the timing of the general fund environmental service expenditures has fluctuated much more than the annual total expenditures. This can lead to large year over year variances in year to date expenditures through the earlier portions of the year. -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. January 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 January YTD Annual % of Annual Expenditures Expenditures * Expenditures 1,776,581 3,026,005 58.7% 1,788,749 2,985,410 59.9% 1,852,467 3,123,865 59.3% 1,821,790 3,054,098 59.7% 1,819,923 3,512,673 51.8% * - For prior years-total actual expenditures, for current year-total approved budget net of adjustments for contingencies and use of the early redemption fund. Total Citywide General Government $4,000,000 $3,500,000 $3,500,000 $3,000,000 $3,000,000 $2,500,000 $2,500,000 $2,000,000 $2,000,000 $1,500,000 $1,500,000 $1,000,000 $1,000,000 $500,000 $500,000 $0 $0 Better than Expected January YTD January 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 anticipates an increase of 15.0% over prior year actuals in total operating expenditures. Actual expenditures are better than expected with a year to date decrease of 0.1% from the prior year through January 2015. General Government 10-11 11-12 12-13 13-14 14-15 January YTD Annual % of Annual Expenditures Expenditures * Expenditures 60,148 78,047 77.1% 63,314 109,658 57.7% 65,011 114,015 57.0% 69,543 114,235 60.9% 65,974 122,878 53.7% * - 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 January YTD Expenditures January 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 5.1% through January 2015 from the prior January. 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 anticipates an increase of 7.6% for fiscal year 2014-15 over prior year actuals. -5- January 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 January YTD Annual % of Annual Expenditures Expenditures * Expenditures 23,795 36,958 64.4% 21,474 36,305 59.1% 24,790 41,290 60.0% 24,530 40,697 60.3% 23,638 46,819 50.5% * - 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 January YTD Expenditures January 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 January 2015 of 3.6% from the prior January. 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 January YTD Annual % of Annual Expenditures Expenditures * Expenditures 470,101 792,002 59.4% 476,365 803,367 59.3% 500,743 842,387 59.4% 500,708 842,270 59.4% 497,065 874,993 56.8% * - 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 January YTD Expenditures January 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 January 2015 expenditures 0.7% lower than the prior year. The budgeted increase for fiscal year 2014-15 over prior year actuals is 3.9%. -6- January 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 January YTD Annual % of Annual Expenditures Expenditures * Expenditures 376,922 567,830 66.4% 388,461 584,429 66.5% 401,109 582,381 68.9% 402,024 573,025 70.2% 405,724 610,044 66.5% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected Transportation Community Development $700,000 $600,000 January YTD Expenditures January 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 January 2015 of 0.9% over the prior January. 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 January YTD Annual % of Annual Expenditures Expenditures * Expenditures 104,654 176,114 59.4% 114,003 192,133 59.3% 132,940 209,403 63.5% 122,729 194,542 63.1% 116,122 229,984 50.5% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected CommunityDevelopment Enrichment Community $250,000 $250,000 JanuaryYTD YTD January 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 January 2015 of 5.4% from the prior January. These expenditures are budgeted to increase 18.2% for fiscal year 2014-15 over prior year actuals. -7- January 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 January YTD Annual % of Annual Expenditures Expenditures * Expenditures 166,838 274,824 60.7% 158,904 272,353 58.3% 162,765 273,110 59.6% 161,870 272,326 59.4% 155,480 285,034 54.5% * - For prior years-total actual expenditures, for current year-total approved budget Environmental Services Community Enrichment $300,000 $300,000 JanuaryYTD YTD January 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 January 2015 of 3.9% from the prior January. 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 January YTD Annual % of Annual Expenditures Expenditures * Expenditures 333,419 572,693 58.2% 324,013 549,628 59.0% 340,307 564,051 60.3% 338,945 577,118 58.7% 329,028 616,265 53.4% * - 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 JanuaryYTD YTD January 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 January 2015 of 2.9% from the prior January. The budgeted increase for fiscal year 2014-15 over prior year actuals is 6.8%. -8- January 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 January YTD Annual % of Annual Expenditures Expenditures * Expenditures 112,408 196,779 57.1% 98,817 157,298 62.8% 80,285 137,208 58.5% 58,790 100,524 58.5% 78,524 148,544 52.9% * - 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 JanuaryYTD YTD January 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 January 2015, year to date expenditures are 33.6% higher than the prior January. -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,761 Discussion: 14-15 (YTD) $ 93,135 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 ($34 million), and an upgrade to the South Transit Facility ($20 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 $ 177,048 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 $117.3 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) $ 14,964 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) $ 1,704 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) $ 7,028 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. In fiscal year 2014-15 Wastewater is planning to begin work on the SROG Interceptor, spending $8 million. 14-15 (YTD) 14-15 (Budget) 13-14 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) $ 62,191 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 January 2015, the water system has spent or committed $9.3 million for rehabilitation at the 24th Street water treatment plant and $24.1 million for improvements to the solids handling facility at the Union Hills water treatment plant. The water system has spent or committed $12.2 million of an estimated $80.1 million on mains and lines, most of which is for rehabilitation or replacement. 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 Jan 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 Jan YTD Actuals 551,933 538,107 560,227 590,776 600,002 11-12 Annual Revenues* 962,689 948,384 980,945 1,026,167 1,060,289 12-13 13-14 14-15 % of Annual Revenues 57.3% 56.7% 57.1% 57.6% 56.6% * - 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 revenues are through January 2015 are 1.6% higher than the same period in the prior year. 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 100,000 50,000 130,913 Primary 27,218 137,956 76,146 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 103,364 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 Dec 34,444 40,845 31,075 32,028 18,028 32,866 14-15 YTD Jan 9,642 7,689 7,015 7,180 8,869 6,919 14-15 budget 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 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 2.3 % higher than budget expectations through January 2015. This corresponds to a 5.9% increase over year to date revenues through January 2014. 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 January 2015 are 2.4% 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 January 2015 local sales tax revenues fell short of January 2014 revenues by 7.2%. This was the fifth time in seven months of fiscal year 2014-15 that monthly revenues were lower than the prior year. 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 January 2015 are 2.0% below the budget estimates for the same period. State Sales Tax 3 Year Trend 14,000 12,000 10,000 8,000 12-13 Actuals 13-14 Actuals 6,000 14-15 Actuals 4,000 2,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June Fiscal year 2013-14 state shared sales tax revenues were 7.0% higher than fiscal year 2012-13. This growth rate is nearly 75% greater than the 4.1% growth rate from fiscal year 2011-12 to fiscal year 2012-13 reflecting continued economic recovery. Through January 2015 state shared sales tax revenues were 4.5% higher than through January 2014. 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 January 2015 are at 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 January 2015 were 6.1% higher than through January 2014. 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 January 2015 were better than expected at 6.1% 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 January 2015, aviation operating revenues are 2.6% higher than through January 2014. 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 9.7% below budget projections through January 2015 reflecting the record setting rainfall received in the 2014 monsoon. For the months of November, December and January, actual revenues are only 1.1% below budget expectations for those months. 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 January 2015 are 4.6% below revenues through January 2014. 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 January 2015 are 4.6% lower than budget expectations for the same time frame. Fiscal years 2009-10 through 2012-13 included revenues from a contract with Palo Verde Nuclear Generating Station (PVNGS). The contract required annual payments resulting in large revenue spikes in the months the payments were received. Those revenue spikes are reflected in the average monthly revenues used to allocate the annually budgeted revenues for fiscal year 2014-15. Since Wastewater is no longer receiving payments on the PVNGS contract, revenues are much more consistent month to month. We anticipate that revenues will be close to the budgeted amount by year end. 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 January 31 (dollars in thousands) Actual Year-to-Date 2014-15 2013-14 Budget Estimate 2014-15 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 $ $ - 21 - 431,320 2,541 $ 247,010 $ 1,894 249,843 1,954 135,474 175,174 54,300 137,956 2,833 9,495 75,838 102,191 30,846 76,146 1,606 2,260 72,572 94,081 29,084 78,490 1,567 2,430 17,722 1,015 13,487 1,025 7,361 1,431 3,928 8,498 389 8,516 543 3,911 716 2,991 9,287 435 6,884 570 4,256 771 2,305 32,500 13,596 1,800 17,331 17,750 8,604 1,547 8,746 17,872 7,783 1,033 9,559 1,060,289 $ 600,002 $ 590,776 General Fund Expenditures As of January 31 (dollars in thousands) Budget Estimate 2014-15 Actual Year-to-Date 2014-15 2013-14 Expenditures and Encumbrances General Government Mayor City Council City Manager Information Technology Services Public Information Equal Opportunity Law City Auditor City Clerk Human Resources Budget and Research Finance Others Total General Government $ 1,831 3,537 2,366 37,168 2,072 2,336 19,960 2,410 4,244 9,871 2,956 18,277 2,005 109,033 901 $ 1,883 1,997 17,269 1,123 1,460 10,702 1,595 1,928 5,333 1,776 10,860 2,355 59,182 1,019 1,996 1,076 20,756 1,430 1,343 11,849 1,644 2,630 5,520 2,070 11,468 1,630 64,431 29,049 4,982 34,031 15,895 2,874 18,769 17,054 2,675 19,729 471,386 255,563 14 726,963 271,801 148,045 (16) 419,830 269,894 145,906 (27) 415,773 Transportation Street Transportation Public Transit Total Transportation 21,554 18,202 39,756 10,074 11,181 21,255 11,728 6,384 18,112 Community Development Economic Development Neighborhood Services Department Planning and Development Others Total Community Development 4,796 12,481 4,910 54 22,241 2,649 6,790 2,430 28 11,897 2,858 7,214 2,812 28 12,912 Community Enrichment Parks and Recreation Library Human Services Others Total Community Enrichment 92,913 35,515 18,895 2,872 150,195 49,638 19,749 9,069 1,820 80,276 53,308 20,276 10,442 1,537 85,563 Environmental Services Public Works Environmental Programs Total Environmental Services 17,663 845 18,508 11,266 372 11,638 9,184 424 9,608 2,845 439 687 - - Criminal Justice Municipal Court Public Defender Total Criminal Justice Public Safety Police Fire Others Total Public Safety Capital Improvement Contingencies Total Expenditures and Encumbrances $ 45,268 $ 1,148,840 - 22 - $ 623,286 $ 626,815 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 January 31 (dollars in thousands) Source General Funds Local Taxes: Sales Taxes Privilege License Fees State Shared Taxes: State Sales Tax State Income Tax Vehicle License Tax Primary Property Tax Licenses and Permits Cable Communications Municipal Court Police Library Fees Parks and Recreation Planning & Development Street Transportation Fire Interest Other Fees and Service Charges Budget Estimate 2014-15 $ Total General Funds 431,320 2,541 $ 249,843 1,954 72,572 94,081 29,084 78,490 1,567 2,430 9,722 6,884 570 4,256 771 2,305 25,655 1,033 9,559 1,060,289 600,002 590,776 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 17,648 50,927 17,673 2,939 93,485 7,774 28,695 8,472 7,667 60,794 17,916 3,700 15,471 99,567 29,576 16,894 49,313 16,850 3,848 99,037 6,201 26,753 9,018 7,601 54,959 15,030 3,512 19,670 136,055 21,400 944,825 462,304 486,141 322,353 63,497 415,361 214,792 150,150 191,864 33,697 235,896 126,923 87,051 187,030 29,421 247,188 127,741 85,355 1,166,153 675,431 676,735 Enterprise Funds Aviation Convention Center Water System Wastewater Solid Waste $ 247,010 1,894 75,838 102,191 30,846 76,146 1,606 2,260 8,887 8,516 543 3,911 716 2,991 26,354 1,547 8,746 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,737,737 $ 1,753,652 Citywide Operating Expenditures As of January 31 (dollars in thousands) Source General Governmen General Funds Other Funds Total General Governmen Actual Year-to-Date 2014-15 2013-14 Budget 2014-15 $ 59,182 $ 6,792 65,974 64,431 5,112 69,543 34,031 12,788 46,819 18,769 4,869 23,638 19,729 4,801 24,530 Public Safety General Funds Other Funds Total Public Safety 726,963 148,030 874,993 419,830 77,235 497,065 415,773 84,935 500,708 Transportation General Funds Other Funds Total Transportation 39,756 570,288 610,044 21,255 384,469 405,724 18,112 383,912 402,024 Community Developmen General Funds Other Funds Total Community Developmen 22,241 207,743 229,984 11,897 104,225 116,122 12,912 109,818 122,730 Community Enrichment General Funds Other Funds Total Community Enrichment 150,195 134,839 285,034 80,276 75,204 155,480 85,563 76,307 161,870 Environmental Services General Funds Other Funds Total Environmental Services 18,508 597,757 616,265 11,638 317,390 329,028 9,608 329,337 338,945 74,164 74,164 78,524 78,524 58,790 58,790 2,845 575,267 578,112 439 147,929 148,368 687 141,963 142,650 Criminal Justice General Funds Other Funds Total Criminal Justice Debt Service General Funds Other Funds Total Debt Service Capital Improvemen General Funds Other Funds Total Capital Improvemen 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 - 623,286 1,196,637 1,819,923 $ - 626,815 1,194,975 1,821,790 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 January 31 2015 2014 Budget Estimate 2014-15 Source Actual Year-to-Date 2013-14 2014-15 General Funds $ 37,226,611 249,611 $ 40,115,972 257,274 Local Taxes: Sales Taxes Privilege License Fees $ 431,320,000 2,541,000 $ 247,010,332 1,893,665 $ 249,843,488 1,953,510 37,476,222 40,373,246 Total Local Taxes 433,861,000 248,903,997 251,796,998 13,173,396 14,598,650 4,660,948 12,744,220 13,440,181 3,935,768 State Shared Taxes: State Sales Tax State Income Tax Vehicle License Tax 135,474,000 175,174,000 54,300,000 75,837,596 102,190,547 30,846,271 72,571,706 94,081,267 29,084,002 32,432,994 30,120,169 364,948,000 208,874,414 195,736,975 6,581,765 5,798,107 Primary Property Tax 137,956,000 76,145,825 78,490,104 197,275 199,383 Licenses and Permits 2,833,000 1,605,588 1,566,662 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 8,498,184 389,159 9,286,494 435,173 18,736,789 8,887,343 9,721,667 13,487,000 8,516,332 6,883,922 Library Fees 1,025,000 542,741 569,593 Parks and Recreation 7,361,300 3,911,132 4,256,417 Planning and Development 1,431,400 716,062 771,249 Street Transportation 3,928,108 2,991,050 2,305,358 32,500,000 1,400,000 12,195,773 17,750,176 395,837 8,208,052 17,871,890 333,725 7,449,730 46,095,773 26,354,065 25,655,345 1,800,000 1,547,339 1,032,976 17,330,894 8,745,987 9,558,529 1,060,289,264 600,002,112 590,775,900 - - Total State Shared Taxes 1,154,772 57,821 1,399,831 64,069 1,212,593 1,463,900 1,228,898 1,362,477 87,688 77,063 559,880 471,697 125,176 97,104 341,786 384,238 2,453,280 29,728 2,209,831 2,069,855 22,725 1,579,782 4,692,839 3,672,362 258,170 187,198 Interest 1,630,333 864,640 Other Fees and Service Charges 86,825,619 85,071,584 Total Municipal Court Police Fire: Emergency Transportation Service Hazardous Materials Inspection Fee Other Total Fire Total General Funds - 25 - Citywide Operating Revenue by Source (continued) For the Month Ended January 31 2015 2014 Budget Estimate 2014-15 Source Actual Year-to-Date 2013-14 2014-15 Special Revenue and Debt Service Funds $ 1,987,347 141,953 709,766 10,007 $ 1,944,703 138,907 694,536 1,807 Neighborhood Protection: Police Neighborhood Protection Police Blockwatch Fire Neighborhood Protection Interest/Other 2,849,073 2,779,953 5,623,011 1,798,610 (9,858) 5,526,647 1,774,183 (12,385) 7,411,763 7,288,445 2,864,223 2,799,222 Parks and Preserves 390,951 4,873 182,636 (3,837) 10,492 1,089,736 94,589 284,138 (6,807) 55,169 Golf Courses: Fees Coffee Shops Concessions Interest Other 585,115 1,516,825 10,074,831 4,242,728 11,112,586 4,219,098 14,317,559 15,331,684 - - $ Total Neighborhood Protection Public Safety Enhancement & Expansion: Police Fire Interest/Other Total Public Safety Enhancement & Expansion 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 $ 12,207,428 871,959 4,359,795 209,266 $ 11,710,030 836,430 4,182,153 165,051 31,135,000 17,648,448 16,893,664 66,032,000 22,381,000 (67,500) 37,902,665 13,105,528 (81,375) 36,636,794 12,741,421 (64,862) 88,345,500 50,926,818 49,313,353 31,337,000 17,672,508 16,849,927 5,722,702 311,350 2,352,140 (70,000) 399,500 1,815,661 46,277 1,076,515 (22,573) 23,396 2,519,148 125,736 1,175,467 (35,737) 63,249 8,715,692 2,939,276 3,847,863 115,177,000 52,021,458 62,787,897 30,696,800 66,914,454 32,122,297 167,198,458 93,484,697 99,036,751 4,385,818 7,774,164 6,200,633 3,522,702 2,809,444 Planning and Development 42,783,000 28,694,743 26,753,151 1,056,564 1,250,966 Capital Construction 15,470,000 8,471,608 9,017,545 982,606 11,455 1,021,016 12,565 Sports Facilities: Sales Taxes Interest/Other 16,451,000 250,000 7,463,356 203,794 7,388,425 212,472 994,061 1,033,581 16,701,000 7,667,150 7,600,897 Total Sports Facilities - 26 - Citywide Operating Revenue by Source (continued) For the Month Ended January 31 2015 2014 Budget Estimate 2014-15 Source Actual Year-to-Date 2013-14 2014-15 Special Revenue and Debt Service Funds (Cont'd) $ 8,968,831 32,771 7,283 7,723,913 25,270 (177,080) 9,008,885 7,572,103 3,038,003 2,574,983 1,270,120 (1,721,143) 620,497 5,723,817 246,094 $ Highway User Revenue: Highway User Revenue Interest Other 106,383,000 200,000 200,000 60,441,227 194,172 158,755 54,679,449 128,808 150,978 106,783,000 60,794,154 54,959,235 Regional Transit Revenues 46,596,781 17,916,085 15,030,326 1,177,014 Community Reinvestment 2,608,664 3,700,306 3,512,185 3,801,006 Other Restricted Fees 44,684,752 15,470,974 19,669,744 601,214 5,358,351 362,491 Grants: Public Housing: Rentals Grants Other 6,590,408 6,322,056 3,404,484 2,251,664 1,801,419 2,741,256 701,642 2,257,476 1,759,643 6,489,929 10,198,823 11,208,690 16,789,231 17,530,746 2,287,178 - 1,381,517 (7,721) 2,287,178 1,373,796 64,273,334 68,839,768 Total Highway User Revenue $ Total Public Housing 7,109,137 74,501,952 4,714,782 $ 3,923,609 37,865,360 1,214,931 $ 3,780,817 36,805,117 2,729,512 86,325,871 43,003,900 43,315,446 40,078,832 72,253,928 31,945,433 52,142,725 17,766,263 7,457,245 12,008,234 19,331,144 15,669,611 30,162,383 13,185,868 33,722,109 Total Other 196,420,918 56,562,886 92,739,971 Total Grants 282,746,789 99,566,786 136,055,417 50,404,017 4,928,832 27,217,789 2,358,293 19,046,176 2,354,244 55,332,849 29,576,082 21,400,420 944,824,303 462,303,799 486,141,111 131,840,000 182,337,300 800,000 2,498,000 1,895,125 2,982,075 - 59,982,723 127,075,759 380,772 1,568,766 1,295,394 1,361,023 199,078 60,018,182 121,340,805 530,859 2,178,203 1,223,250 1,723,916 15,356 322,352,500 191,863,515 187,030,571 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,977,997 17,681,969 53,539 1,084,514 194,752 (109,816) 34,240 8,913,088 16,784,118 73,467 450,794 175,948 246,903 14,588 27,917,195 26,658,906 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 January 31 2015 2014 Budget Estimate 2014-15 Source Actual Year-to-Date 2014-15 2013-14 Enterprise Funds (Cont'd) CONVENTION CENTER: 3,535,989 1,741,526 20,452 3,348,582 772,558 18,846 5,297,967 4,139,986 Excise Taxes Operating Revenue Interest Total Convention Center 47,993,000 15,328,192 175,863 24,543,385 8,998,028 155,372 23,108,366 6,183,331 128,935 63,497,055 33,696,785 29,420,632 WATER SYSTEM: $ 19,392,849 468,696 246,100 331,690 92,100 296,553 203,400 $ 21,031,388 20,706,379 462,349 259,769 554,495 84,960 274,637 529,107 22,871,696 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 $ 221,788,322 3,015,324 2,766,292 3,729,596 1,224,000 1,572,657 1,799,774 $ 233,094,879 3,455,250 2,416,231 3,409,632 994,680 1,270,923 2,546,397 415,361,000 235,895,965 247,187,992 182,029,000 16,199,000 2,400,000 1,348,000 12,816,000 106,365,294 11,169,553 1,158,780 852,628 7,376,796 105,434,252 11,010,693 926,400 781,873 9,588,038 214,792,000 126,923,051 127,741,256 128,235,000 9,720,000 270,000 11,925,446 74,599,910 4,798,965 299,807 7,352,649 73,991,726 4,567,784 213,390 6,581,964 150,150,446 87,051,331 85,354,864 1,166,153,001 675,430,647 676,735,315 WASTEWATER: 15,174,099 1,588,944 87,300 165,075 1,167,542 14,951,165 1,578,541 75,600 166,388 846,644 18,182,960 17,618,338 Sewer Service Charges Multi-City Development Fees Interest Other Total Wastewater SOLID WASTE: $ 10,710,106 674,541 50,607 385,360 10,609,237 596,760 39,020 490,367 11,820,614 11,735,384 84,250,124 83,024,310 235,349,077 $ 236,935,662 Collection Fees Landfill Fees Interest Other Total Solid Waste Total Enterprise Funds Total Operating Revenues $ - 28 - 3,171,266,568 $ 1,737,736,558 $ 1,753,652,326 Citywide Operating Expenditures by Program For the Month Ended January 31 2015 2014 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 $ 122,740 194,616 304,011 2,838,223 47,964 190,862 245,829 1,350,130 191,177 242,515 519 810,571 128,190 5,940 272,159 2,305,776 148,628 9,399,850 $ 145,655 321,684 277,131 2,415,047 47,230 182,126 211,818 1,782,896 175,131 414,450 16,776 927,851 (22,494) 6,575 292,809 1,621,577 513,497 9,329,759 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 $ 900,965 1,882,627 1,993,322 18,633,217 614,728 1,344,304 1,687,007 11,274,457 1,595,331 1,928,290 681,908 6,210,504 1,057,337 16,964 1,776,069 12,459,986 1,916,369 $ 1,019,345 1,996,444 1,250,302 22,083,915 823,065 1,559,466 1,577,745 12,477,370 1,644,307 2,629,927 724,271 6,179,597 34,962 48,479 2,069,965 13,665,346 (241,320) $ 900,965 1,882,627 1,993,322 17,709,090 614,728 1,344,304 1,687,007 11,274,457 1,595,331 1,928,290 681,908 5,540,237 1,057,337 16,964 1,776,069 12,366,108 1,916,369 $ 924,127 670,267 93,878 - 122,877,786 65,973,385 69,543,186 64,285,113 1,688,272 41,837,569 4,981,585 20,764,175 2,873,941 21,854,739 2,675,220 16,973,706 2,873,941 3,790,469 - 46,819,154 23,638,116 24,529,959 19,847,647 3,790,469 570,433,037 304,086,736 472,781 325,948,265 170,802,801 314,001 330,727,973 169,690,852 288,832 321,901,166 168,699,540 314,001 4,047,099 2,103,261 - 874,992,554 497,065,067 500,707,657 490,914,707 6,150,360 Criminal Justice 2,719,199 393,926 2,936,580 388,223 3,113,125 3,324,803 Municipal Court Public Defender Total Criminal Justice Public Safety 46,133,930 23,516,590 80,331 48,932,173 24,656,496 46,279 69,730,851 73,634,948 Police Fire Other Total Public Safety - 29 - Citywide Operating Expenditures by Program (continued) For the Month Ended January 31 2015 2014 Budget Estimate 2014-15 Program Actual Year-to-Date 2014-15 2013-14 2014-15 Year-to-Date Operating Expenditures & Encumbrances Capital Operations and Debt Transportation $ 4,260,591 906,118 20,524,865 7,477,519 33,169,093 $ 4,426,099 951,458 22,761,238 6,333,392 34,472,187 Street Transportation Street Lighting Aviation Public Transit Total Transportation $ 60,347,257 11,676,247 285,060,223 252,960,307 $ 33,075,120 6,630,021 159,353,579 206,665,277 $ 33,974,778 6,518,086 161,264,399 200,266,731 $ 33,005,780 6,630,021 129,975,590 178,158,042 $ 69,340 29,377,989 28,507,235 610,044,034 405,723,997 402,023,994 347,769,433 57,954,564 Community Development 2,865,441 6,389,552 2,090,098 2,675,980 3,134,593 6,124,557 2,372,274 4,163,562 Planning and Development Housing Economic Development Neighborhood Services Department 46,760,869 88,592,415 35,505,370 59,125,414 23,151,515 46,634,619 25,809,358 20,526,181 22,991,473 44,483,816 24,565,778 30,688,412 23,151,515 46,590,957 13,394,386 20,526,181 43,662 12,414,972 - 14,021,071 15,794,986 Total Community Development 229,984,068 116,121,673 122,729,479 103,663,039 12,458,634 102,825,230 36,062,173 8,354,628 60,752,841 11,048,412 60,440,955 4,007,435 1,542,517 54,341,742 20,062,032 4,058,958 37,020,349 6,447,745 30,349,343 2,065,077 1,134,925 57,230,931 20,798,689 5,626,527 36,892,559 6,375,212 32,069,691 1,870,017 1,006,667 53,222,352 20,062,032 4,058,958 26,172,852 30,178,160 2,065,077 1,134,925 1,119,390 10,847,497 6,447,745 171,183 - 285,034,191 155,480,171 161,870,293 136,894,356 18,585,815 Community Enrichment 6,202,079 2,804,723 238,790 3,903,050 920,389 4,323,608 318,935 51,586 7,084,326 2,568,652 1,542,912 4,449,876 910,103 4,023,994 298,715 63,132 18,763,160 20,941,710 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 January 31 2015 2014 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 $ 24,035,238 10,204,719 10,502,611 2,745,529 120,958 $ 47,609,055 23,763,077 11,496,786 9,216,785 3,817,475 113,600 48,407,723 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 $ 174,050,552 71,531,311 68,110,273 15,029,675 306,483 $ 173,248,585 81,089,672 71,619,062 12,547,488 440,637 $ 105,759,988 39,323,815 60,509,511 11,296,596 306,483 $ 217,196,393 68,290,564 32,207,496 7,600,762 3,733,079 - 616,265,128 329,028,294 338,945,444 111,831,901 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 121,811 6,641,927 15,246,289 509,853 3,575,854 399,746 7,011,452 1,180,354 4,297,771 4,495,042 732,543 6,360,090 29,231 5,762,914 2,148,397 1,661,960 126,785 1,599,576 7,012,676 5,147,406 3,707 4,458,326 505,286 5,314,736 4,915,456 196,895 2,691,590 402,888 2,848,789 366,604 4,201,637 4,541,371 684,489 8,453,836 29,283 4,237,436 746,146 1,671,375 2,213 547,210 9,033,219 3,196,607 3,974 4,199,209 - 121,811 6,641,927 15,246,289 509,853 3,575,854 399,746 7,011,452 1,180,354 4,297,771 4,495,042 732,543 6,360,090 29,231 5,762,914 2,148,397 1,661,960 126,785 1,599,576 7,012,676 5,147,406 3,707 4,458,326 General Obligation Debt Service 16,854 942,614 2,178,041 72,836 509,809 56,904 1,000,232 168,622 611,969 640,288 104,352 902,386 4,175 821,194 306,892 237,406 228,481 996,616 733,078 512 632,868 72,183 759,248 702,208 28,128 384,513 57,556 406,970 52,372 600,234 648,768 97,784 1,207,691 4,183 605,348 106,592 238,768 (1) 78,172 1,290,460 456,658 568 599,981 11,166,129 8,398,384 Total Debt Service 74,164,415 78,523,710 58,790,249 - 78,523,710 8,261,252 15,031,871 Capital Improvement 578,111,992 148,368,449 142,650,227 - 148,368,449 $ 215,233,586 $ 229,336,371 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,819,922,862 $ 1,821,790,488 $ 1,380,570,688 $ 439,352,174 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,430,452 73,248,002 3,250,325 123,636,622 17,957,644 159,820,808 5,536 $ 4,647,804 731,521 5,086,865 260,836 500,483 71,573 3,039,645 14,844 9,952,130 307,608 358,174 10,998,702 463,625 9,148,522 3,414,328 44,133,236 724,318 1,039,876 4,086,293 2,881,508 4,260,328 3,048,776 158,818 10,285,269 714,799 9,507,769 204,771 666,502 12,733,880 8,802,959 13,377,034 3,090,181 69,071,705 Total Capital Improvement Program $ 511,760,654 $ 93,135,432 $ 144,654,786 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,320,486 $ $ 177,048,062 14,963,523 1,703,852 7,027,829 62,190,783 262,934,049 $ 356,069,481 $ $ 104,654,359 12,465,720 149,645 9,668,100 34,767,091 161,704,915 $ 306,359,701 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,281,373 42,931,503 3,182,088 95,545,813 75,677,465 5,536 4,646,428 731,521 4,214,726 143,460 1,711,660 4,527 81 117,763 8,502,412 89,396 8,295,099 36,741,405 263,357,506 $ 65,204,014 $ 28,117,700 5,868,367 29,202,053 73,266,111 178,300,255 314,754,486 $ 578,111,992 - 32 - $ $ 11,068,221 3,034,940 1,411,012 6,979,119 60,671,143 83,164,435 $ 148,368,449 $ $ $ 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 1,376 872,139 117,376 500,483 71,573 1,327,985 10,317 9,952,130 307,527 240,411 2,496,290 374,229 853,423 3,414,328 7,391,831 248,403,148 $ 27,931,418 $ 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,120,038 3,898,162 468,479 7,363,980 2,175,885 11,244,440 1,334,769 33,532,833 594,156 39,896,340 1,168,874 6,072,278 62,249,300 2,786,700 114,488,100 14,543,316 115,687,572 $ 418,625,222 $ 165,979,841 11,928,583 292,840 48,710 1,519,640 179,769,614 $ $ 142,261,173 11,353,844 34,846,145 124,193,854 140,970,767 453,625,783 $ 207,701,032 $ 872,251,005 Bonds Authorized and Sold As of January 31 (dollars in thousands) Authorized Sold Available 1988 Authorizations General Obligation Bonds Freeway Mitigation, Neighborhood Stabilization, and Slum and Blight Elimination Bonds Fully Issued $ Total General Obligation Bonds Revenue Bonds Bonds Fully Issued Total 1988 Authorizations 29,285 884,175 $ 28,285 884,175 $ 1,000 - 913,460 912,460 1,000 143,890 143,890 - 1,057,350 1,056,350 1,000 66,300 125,300 24,800 61,500 12,000 33,000 91,500 74,000 77,000 78,800 66,000 43,700 64,600 124,685 24,170 60,700 11,205 32,100 89,275 71,645 72,575 77,685 65,950 43,700 1,700 615 630 800 795 900 2,225 2,355 4,425 1,115 50 - 753,900 738,290 15,610 81,000 11,100 198,700 12,800 104,622 74,705 29,178 115,500 107,295 78,200 65,400 63,385 8,510 190,610 8,345 85,510 61,200 21,100 102,290 81,900 58,135 61,770 17,615 2,590 8,090 4,455 19,112 13,505 8,078 13,210 25,395 20,065 3,630 878,500 742,755 135,745 2001 Authorization General Obligation Bonds Education, Youth and Family Cultural Facilities Computer Technology Environmental Cleanup Fire Protection Historic Preservation Library Facilities Street Improvements Neighborhood Protection and Senior Centers Parks, Open Space, and Recreational Facilities Police Protection Storm Sewer and Flood Protection Bonds Fully Issued Total 2001 Authorizations 2006 Authorization General Obligation Bonds Affordable Housing and Neighborhood Revitalization Computer Technology Education and Health Science Facilities Environmental Cleanup Family, Senior, and Youth Cultural Facilities Fire Protection Library Facilities and Improvements Parks, Open Space, and Recreational Facilities Police Protection Street Improvements Storm Sewer and Flood Protection Total 2006 Authorizations Total Bond Program $ - 33 - 2,689,750 $ 2,537,395 $ 152,355 Appendix A Additional historic and trend information for various revenue streams. Local Sales Tax (Dollars in Thousands) Local Sales Tax 45,000 10-11 Actuals 11-12 Actuals 12-13 Actuals 13-14 Actuals 14-15 Actuals 14-15 budget 40,000 35,000 30,000 25,000 20,000 15,000 July FY 10-11 11-12 12-13 13-14 14-15 14-15 budget July 32,543 33,875 34,005 36,360 35,365 36,235 Aug Aug 32,288 34,239 34,276 35,589 36,414 36,132 Sept Sept 33,087 33,371 34,254 35,873 35,290 36,183 Oct Nov Oct 32,143 34,746 33,337 35,068 34,621 35,841 Dec Nov 32,952 31,854 33,430 34,363 33,033 35,127 Jan Dec 31,456 31,745 32,504 32,474 35,062 33,956 Feb Jan 36,278 36,385 36,527 40,116 37,227 39,553 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 - YTD thru Jan 230,748 236,215 238,334 249,843 247,010 253,027 Mar Apr May June 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,595 33,920 37,094 35,346 38,338 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 Jan Dec 8,947 9,055 9,462 10,296 10,695 10,849 Feb Jan 10,757 11,290 11,986 12,744 13,173 13,439 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 - Mar YTD thru Jan 63,748 65,133 68,036 72,572 75,838 77,425 Apr May June 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,782 11,228 12,214 11,652 12,173 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 Feb Dec 4,095 3,781 3,993 3,872 3,857 4,389 Jan 3,894 3,645 3,572 3,936 4,661 4,195 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 - Mar YTD thru Jan 28,311 26,206 27,009 29,084 30,846 30,840 Apr May June 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,442 5,259 4,137 4,633 4,990 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 Dec 27,977 29,526 28,146 27,171 27,853 26,948 Feb Jan 25,681 27,146 27,054 26,659 27,917 25,447 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 - Mar YTD thru Jan 185,689 190,402 194,252 187,031 191,864 180,903 Apr May June 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,234 27,898 31,072 28,102 28,145 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 Dec 21,157 20,946 25,523 22,327 24,573 23,429 Feb Jan 17,482 19,694 21,738 22,872 21,031 21,835 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 - Mar YTD thru Jan 223,916 247,146 282,078 247,188 235,896 261,179 Apr May June 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 20,305 21,945 31,141 35,938 44,855 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 Dec 27,453 18,864 17,744 17,763 18,276 17,564 Feb Jan 19,363 26,967 25,337 17,618 18,183 22,588 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 - Mar YTD thru Jan 143,293 148,867 135,258 127,741 126,923 133,051 Apr May June 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 16,721 15,442 17,828 18,095 13,653