The URL can be used to link to this page

Home My WebLink About12/01/2015 05C 3rd Quarter 2015 Financial Trend Monitoring SystemBUSINESS OF THE CITY COUNCIL YAKIMA, WASHINGTON AGENDA STATEMENT Item No. 5. C. For Meeting of. December 1, 2015 ITEM TITLE: 3rd Quarter 2015 Financial Trend Monitoring System SUBMITTED BY: Cindy Epperson, Director of Finance & Budget SUMMARY EXPLANATION: As part of the 2013 Strategic Plan, the City Council implemented a Financial Trend Monitoring System (FTMS) in order to provide a simple "performance at a glance" of budgetary and revenue trends. The FTMS compares key financial and economic indicators as an "early warning system" regarding the financial and economic health of the City, and assigns "positive ", "normal ", "warning ", and "negative" labels to revenues and expenditures. At the end of the third quarter 2014, we are seeing typical variances tied to timing- -such as debt service contributions, progress on capital projects, and property tax collections. All expenditure categories received a "normal" ranking, as actual results are within 5% of expected levels at this point in time. There was only one category receiving a "warning" designation, which is utility tax revenue. We estimate that this category will be below budget by 3 -5% by year end. No categories received a "negative" designation. Management implemented cost containment measures through the end of the year to make up for the reduction in utility tax revenue, but we are estimating to use about $485,000 of reserves by the end of 2015. All of the funds were reviewed carefully during recent budget preparation, as we estimate year end results to arrive at a beginning fund balance that becomes part of the available resources for the 2016 budget. The trends in this report were the basis for preparing those estimates. It should be noted that the appropriation that went to Council in November is not included in these budget numbers, as it is 4th quarter activity. General Government (i.e. tax supported) funds including General, Parks & Recreation, and Street & Traffic Engineering are at 73.1% of budget. Citywide, expenditures are at 60.4% of budget, which is below 75% of the year primarily because of timing of capital projects and debt service payments. Overall, year -to -date results through the third quarter are as anticipated. Resolution: Other (Specify): Report Contract: Start Date: Item Budgeted: NA Ordinance: Contract Term: End Date: Amount: Funding Source/Fiscal Impact: Strategic Priority: Insurance Required? No Mail to: Phone: APPROVED FOR SUBMITTAL: RECOMMENDATION: Accept report. Public Trust and Accountability City Manager ATTACHMENTS: Description Upload Date Type D 2015 3rd Qtir F:Ihnaincliall Freund Wxii�oriing IRelpat 11/23/2015 ExEIKAAND SLYrnirruiry MEMORANDUM November 12, 2015 TO: The Honorable Mayor and Members of the City Council FROM: Tony O'Rourke, City Manager Cindy Epperson, Director of Finance & Budget SUBJECT: 2015 3rd Quarter Financial Trend Monitoring Report We are submitting for your review the City of Yakima's 2015 3rd Quarter actual compared to budgeted Revenue and Expenditure Report for all city funds. Overall, the City budget is performing as expected. We are in the final stages of developing the 2016 budget. This includes estimating revenues and expenditures in the current year, to arrive at a beginning fund balance for next year's budget. Unfortunately, General Government revenue (particularly utility taxes) appears to be responding negatively to drought conditions, so 2015 revenue estimates are being lowered as we put together the 2016 budget. Estimates show potential savings in expenditures that roughly match the reduced revenues, so the total General Government Fund Balance is projected to use about $485,000 of reserves in 2015. Management is developing cost containment measures to ensure that we continue to live within our means. This report is summarized by type of fund, and incorporates the Financial Monitoring System presentation. Information is reported by functional type, in the following order: ➢ Performance at a Glance - Financial Monitoring System ➢ City -Wide Overview ➢ General Government Revenue Analysis ➢ General Government Expenditure Analysis ➢ Other Funds Analysis ➢ Top 10 Capital Project List ➢ Exhibits - Fund detail that supports the summaries: • Exhibit I - Other Operating /Enterprise Funds • Exhibit II - Capital Improvement Funds • Exhibit III - Reserve and Other Funds • Exhibit IV - Bond Redemption Funds PERFORMANCE AT A GLANCE STATUS PAGE General Fund Revenues NORMAL 2 - 5 Expenditures NORMAL 2 / 6 - 7 Other Funds NORMAL 8 - 9 Top 10 Capital Projects NORMAL 10 Exhibits Operating /Enterprise Funds (1) NORMAL 11 Capital Funds (1) NORMAL 12 Reserve, Trust & Agency Funds (1) NORMAL 13 Bond Redemption Funds (1) NORMAL 14 Legend: Revenues exceed budget >5 %, Expenditures below budget >5% POSITIVE Revenues exceed budget <5 %, Expenditures below budget <5% NORMAL Revenues below budget between 3 -5% WARNING Revenues below budget >5% NEGATIVE (1) These funds are graded on a net Revenue measurement. Yakima. 6315. 1. FIN_Report_3rd_Qtr_2015_ce.docx 1 of 14 CITY WIDE OVERVIEW REVENUE COMPARISON (Budget vs. Actual) EXPENDITURE COMPARISON (Budget vs. Actual) 2014 2015 Percent Amended Percent Actual Rec'd Budget Actual Rec'd General $ 41,991,669 72.6% $ 61,333,941 $ 42,737,302 69.7% Parks and Recreation 2,843,096 67.9% 5,459,455 3,379,133 61.9% Street & Traffic Operations 3,070,657 61.2% 4,718,610 3,039,754 64.4% General Government Subtotal 47,905,422 71.3% 71,512,006 49,156,189 68.7% Operating /Enterprise Funds 49,796,016 73.8% 72,434,292 50,021,529 69.1% Capital Funds 33,407,195 43.8% 34,576,129 11,728,582 33.9% G.O. Bond Redemption Funds 2,567,049 58.9% 4,700,411 4,084,446 86.9% Utility Revenue Bond Redemption Funds 1,852,575 57.5% 2,134,280 1,840,830 86.3% Employee Benefit Reserves 8,297,036 66.9% 12,509,688 8,723,542 69.7% Operating Reserves 2,922,752 82.7% 3,684,000 3,309,619 89.8% Trust and Agency Funds 554,413 101.4% 620,277 641,462 103.4% Total $147,302,458 64.6% $ 202,171,083 $129,506,199 64.1% EXPENDITURE COMPARISON (Budget vs. Actual) Yakima. 6315. 1. FIN_Report_3rd_Qtr_2015_ce.docx 2 of 14 2014 2015 Percent Amended Percent Actual Spent Budget Actual Spent General $ 42,441,292 72.0% $ 61,281,678 $ 44,907,462 73.3% Parks and Recreation 3,646,549 78.5% 5,425,527 4,014,846 74.0% Street & Traffic Operations 3,720,619 70.1% 5,076,756 3,577,856 70.5% General Government Subtotal 49,808,460 72.2% 71,783,961 52,500,164 73.1% Operating /Enterprise Funds 47,434,154 70.2% 74,419,322 50,856,792 68.3% Capital Funds 31,746,499 41.8% 44,957,807 9,915,555 22.1% G.O. Bond Redemption Funds 1,362,755 31.7% 4,709,429 2,746,846 58.3% Utility Revenue Bond Redemption Funds 595,957 29.1% 2,132,155 572,447 26.8% Employee Benefit Reserves 9,784,132 59.8% 12,865,239 9,300,896 72.3% Operating Reserves 2,666,072 78.2% 3,715,631 3,565,544 96.0% Trust and Agency Funds 200,279 102.7% 617,777 489,225 79.2% Total $143,598,308 61.1% $ 215,201,321 $129,947,469 60.4% Yakima. 6315. 1. FIN_Report_3rd_Qtr_2015_ce.docx 2 of 14 GENERAL GOVERNMENT REVENUE ANALYSIS GENERAL GOVERNMENT REVENUES 2015 Revenues through 9/30 Amended Percent 2013 2014 2015 Budget Receipted Status General Sales Tax $10,603,688 $11,229,097 $11,699,223 $16,020,000 73.0% NORMAL Crim. Justice Sales Tax 2,118,531 2,343,670 2,365,585 3,205,350 73.8% NORMAL Property Tax 9,288,887 9,710,476 9,496,379 16,336,390 58.1% NORMAL Utility & Franchise Taxes 10,853,277 11,908,494 11,675,917 16,783,695 69.6% WARNING Charges for Services 4,539,339 5,093,601 6,195,620 8,134,483 76.2% NORMAL State Shared Revenue 1,919,876 2,192,093 2,083,391 2,836,880 73.4% NORMAL Other Intergovernmental 1,009,662 897,685 1,073,638 1,629,520 65.9% NORMAL Fines and Forfeitures 1,184,825 1,194,294 1,214,430 1,645,110 73.8% NORMAL Other Taxes 1,190,025 1,171,275 1,154,908 1,429,000 80.8% NORMAL Transfers from other Funds 957,456 864,931 896,783 1,450,000 61.8% NORMAL Licenses and Permits 576,328 679,289 673,675 857,900 78.5% NORMAL Other Revenue 428,555 620,517 626,640 1,183,678 52.9% NORMAL Total Revenue 44,670,449 47,905,422 49,156,189 71,512,006 68.7% NORMAL Beginning Fund Balance 10,908,094 10,883,753 9,412,400 9,412,400 Total Resources $55,578,543 $58,789,175 $58,568,589 $80,924,406 72.4% I NORMAL Sales Tax — This important revenue source continued grow above 2014 levels. Through the third quarter of 2015, sales tax is 4.2% more than the prior year, and through the ten months ending in October, we are 4.3% ahead of 2014 year to date for the same time period. The 2015 budget is about 3.6% higher than the full year of 2014 actual results. Since our economy is closely tied to the agricultural sector, the drought and other weather conditions have had a dampening effect on the middle part of the year —both June and July receipts were flat compared to prior year. Our June receipt corresponds to April sales, which is when the Governor declared drought conditions. Fortunately, August- October rebounded, and came in with month over month increases of 3.5 % -9.7% so we are estimating sales tax to grow slightly through the end of the year. Building Permit activity is close to the high levels experienced in the prior year, and this is a pre- cursor to construction sales tax. Looking at these underlying economic factors, this revenue is estimated to approximate budget for 2015. Property Tax — The first half of the Property Tax assessment is due to the Yakima County Treasurer by April 30, and the second half is due October 31. Therefore, the second quarter receipts are typically slightly more than 50% of the annual budget, because of accounts that are paid in full in April and payments in full when property sells. The budget is set based on assumptions of new construction and collection rates —the 2015 actual levy was very close to the levy assumptions made, so this major revenue should meet or slightly exceed budget, depending on collection rate. Utility and Franchise Taxes — This category fell off from 2014 by $232,577 or 2.0% from the first three quarters of 2014, and the actual is 69.6% of budget, which warrants a warning, as this revenue is estimated to come in between 3 -5% below budget by year end. Contributing factors for this reduction include the Yakima. 6315. 1. FIN_Report_3rd_Qtr_2015_ce.docx 3 of 14 mild weather conditions through the first three months of the year, compared to the severe cold weather in the prior year. The drought alert has also slowed water (and therefore wastewater) usage. Telephone taxes continue to decline, with the migration away from land lines and cell phone "talking minutes" to data which is not currently taxable. The 2015 year end estimate is being adjusted downward by about $960,000 in response to these trends. Charges for Services — Some accounts in this category are collected ratably throughout the year, while some are seasonal in nature, such as the Parks and Recreation programs and Engineering /Construction Inspection. Therefore, the slightly positive variance is a timing difference, and considered normal. The total went up year over year primarily because the new Union Gap contract for fire services is included in this category, adding about $900,000 to the year to date actual. Other Taxes — This category consists primarily of Business Licenses and Gambling Taxes. Business licenses are due in January for the year, so that over 75% of this one category has been collected by March 31. The positive variance is a timing difference, and considered normal. Other Revenue — This category consists primarily of interest earnings, concession revenue and sale of assets. Most concessions activate in the summer, and the sale of two of the four Tiger Mart properties will be made later in the year. Therefore, this negative variance is a timing difference, and considered normal. Other categories all contain timing exceptions, and are still expected to meet the budget. Overall, general government revenues are up by about $1,250,000 or 2.6% over 2014, with about half of that growth being the new contract for Union Gap fire service. We anticipate year end to meet the budget within the 3% range which maintains the "normal' ranking. Yakima. 6315. 1. FIN_Report_3rd_Otr_2015_ce.docx 4 of 14 GENERAL GOVERNMENT REVENUES - By Month 2013 2014 2015 Jan $ 4,451,264 $ 4,775,515 $ 4,497,985 Feb 4,267,636 4,770,901 4,721,588 Mar 4,896,583 4,984,701 5,504,709 Apr 9,758,283 10,717,557 11,332,602 May 4,733,408 4,573,329 4,855,896 Jun 4,168,515 4,307,587 3,922,536 Jul 3,962,439 4,304,052 4,610,374 Aug 3,798,660 4,290,971 4,636,646 Sep 4,758,660 5,180,804 5,073,853 Oct 10,070,031 9,891,373 - Nov 4,006,410 4,395,161 - Dec 4,641,432 5,190,725 - $63,513,321 $67,382,676 $49,156,189 $10,000,000 $7,500,000 • 2013 $5,000,000 $2,500,000 IC • 2014 $ ■2015 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec GENERAL GOVERNMENT REVENUES - Cumulative By Month 2013 2014 2015 Jan $ 4,451,264 $ 4,775,515 $ 4,497,985 Feb 8,718,900 9,546,416 9,219,573 Mar 13,615,483 14,531,117 14,724,282 Apr 23,373,766 25,248,674 26,056,884 May 28,107,174 29,822,003 30,912,780 Jun 32,275,689 34,129,590 34,835,316 Jul 36,238,128 38,433,642 39,445,690 Aug 40,036,788 42,724,613 44,082,336 Sep 44,795,448 47,905,417 49,156,189 Oct 54,865,479 57,796,790 - Nov 58,871,889 62,191,951 - Dec 63,513,321 67,382,676 - $60,000,000 , • 2013 $40,000,000 $20,000,000 1 1 1 1 1 • 2014 $_ ' ' ' ' ' III • 2015 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Yakima. 6315. 1. FIN_Report_3rd_Qtr_2015_ce.docx 5 of 14 GENERAL FUND EXPENDITURE ANALYSIS GENERAL GOVERNMENT EXPENDITURES 2015 Expenditures through 9/30 Amended Percent 2013 2014 2015 Budget Spent Status Police $18,509,094 $19,324,697 $18,811,662 $26,638,098 70.6% I ORM i r Fire 7,030,665 7,576,121 8,781,592 11,847,472 74.1% NORMAL Transfers To Other Funds 1,820,373 2,105,497 3,785,720 4,793,875 79.0% NORMAL Information Technology 1,693,116 2,104,796 2,379,317 3,062,977 77.7% NORMAL Code Administration 1,011,794 2,222,457 1,169,203 1,682,327 69.5% NORMAL Financial Services 1,070,925 1,106,231 1,146,698 1,605,263 71.4% NORMAL Municipal Court 970,018 916,650 930,778 1,395,989 66.7% NORMAL Utility Services 963,417 985,377 1,094,946 1,555,520 70.4% NORMAL Police Pension 1,020,409 881,991 808,319 1,167,200 69.3% NORMAL Legal 917,868 1,000,348 1,088,937 1,525,072 71.4% NORMAL Engineering 495,078 493,344 615,258 890,530 69.1% NORMAL Indigent Defense 393,529 451,907 682,856 1,000,500 68.3% NORMAL Records / City Clerk 340,575 483,074 425,855 592,904 71.8% NORMAL Purchasing 402,960 415,532 449,936 654,699 68.7% NORMAL Human Resources 336,660 371,981 469,109 682,303 68.8% NORMAL Economic Development 408,229 377,752 528,866 702,329 75.3% NORMAL Planning 401,450 324,060 382,828 581,384 65.8% NORMAL City Hall Facility 290,090 318,320 406,555 523,868 77.6% NORMAL City Manager 273,149 274,864 307,157 389,578 78.8% NORMAL Gang Free / Emer Mgmt - 199,216 194,378 443,066 43.9% NORMAL City Council 237,674 238,990 230,254 286,735 80.3% NORMAL Intergovernmental 259,255 221,940 147,989 174,989 84.6% NORMAL State Examiner 77,723 46,147 69,249 110,000 63.0% NORMAL Position Vacancy Savings - - - (1,025,000) 0.0% Total General Fund 38,924,051 42,441,292 44,907,462 61,281,678 73.3% NORMAL Parks & Recreation Fund 3,243,801 3,646,549 4,014,846 5,425,527 74.0% NORMAL Street & Traffic Ops. 3,848,266 3,720,619 3,577,856 5,076,756 70.5% NORMAL Total General Government $46,016,118 $49,808,460 $52,500,164 $71,783,961 73.1% NORMAL Total General Government Fund Expenditures - 1.9% Below 75% IsTORMAL Yakima. 6315. 1. FIN_Report_3rd_Qtr_2015_ce.docx 6 of 14 SIGNIFICANT EXPENDITURE VARIANCES Some operations in the General Government area have seasonal expenditures, which result in either positive or negative timing variances through the third quarter. For example, the entire contribution to the Risk Management fund is made in the first quarter, because the corresponding purchased insurance premiums are due at the beginning of the year. Conversely, Parks and Recreation and Economic Development have lower program activity in the first half of the year, and pick up through the end of the year. However, since the total General Government budget is about 68% salaries most variances at the end of the third quarter are tied to personnel — i.e. position vacancies. In response to the reduction in Utility Tax revenue, we instigated cost containment measures through the end of 2015, and therefore anticipate total expenditures to come in under budget by about $426,000 by year end. The following explains why some areas are receiving a Normal designation even though they may be over /under 75% in third quarter, yet comparable to prior years —i.e. payment timing variance. ➢ Transfers to Other Funds —Debt service for the 2014 Streets Bond is due in May, so the full amount of $1.7 million has been transferred. Remaining items are transferred ratably throughout the year. ➢ Information Technology —Annual maintenance for various computer software systems is paid in the first half of the year. ➢ Municipal Court — Position vacancies and the timing of payments made to Yakima County for jury selection make up the favorable variance. ➢ City Hall Facility Maintenance — Annual transfer to Risk Management Fund to pay for property insurance is made in the first quarter - $126,000. Also, some of the work on the City Hall remodel is being done by internal staff either using more temporary hours or on overtime. ➢ City Manager — Increase in City Manager's compensation was not included in the 2015 budget. Additionally, Personal Time Off (PTO) accrual cashouts were not anticipated. The employee survey was also paid in full earlier in the year. Savings in other areas are making up these slight overages. ➢ Gang Free Initiative /Emergency Management— This program is under budget at the end of the 3rd quarter primarily because of position vacancies, and the timing of contract payments to service providers. ➢ City Council — Annual Association of Washington Cities (AWC) dues of $64,000 were paid in the first quarter, and the citizen survey of about $30,000 was paid in the 3rd quarter. This budget is anticipated to end the year slightly under budget. ➢ Intergovernmental — Most annual dues are paid in full by the end of the third quarter. ➢ State Examiner — The annual audit does not get under way until the end of the 2nd quarter of the year. This is a timing variance. ➢ Position Vacancy Savings — Shown for fund total purposes only — no "actual" will be charged here. Yakima. 6315. 1. FIN_Report_3rd_Otr_2015_ce.docx 7 of 14 OTHER FUNDS ANALYSIS OTHER FUNDS REVENUES 2015 Revenues through 9/30 Amended Percent 2013 2014 2015 Budget Rec'd Status Operating/Enterprise Funds $ 48,550,759 $ 49,796,016 $ 50,021,529 $ 72,434,292 69.1% NORMAL Capital Funds 23,054,665 33,407,195 11,728,582 34,576,129 33.9% NORMAL Reserve, Trust & Agency Funds 13,286,968 11,774,201 12,674,623 16,813,965 75.4% NORMAL Bond Redemption Funds 3,469,373 4,419,624 5,925,276 6,834,691 86.7% NORMAL Total Revenue 88,361,765 99,397,036 80,350,010 130,659,077 61.5% NORMAL Beginning Fund Balance 47,394,784 51,645,155 56,161,007 56,161,007 Total Resources $135,756,549 $151,042,191 $136,511,017 $186,820,084 73.1% OTHER FUNDS EXPENDITURES 2015 Expenditures through 9/30 Amended Percent 2013 2014 2015 Budget Rec'd Status Operating/Enterprise Funds $ 46,483,625 $ 47,434,154 $ 50,856,792 $ 74,419,322 68.3% NORMAL Capital Funds 26,051,938 31,746,499 9,915,555 44,957,807 22.1% NORMAL Reserve, Trust & Agency Funds 12,352,578 12,650,483 13,355,665 17,198,647 77.7% NORMAL Bond Redemption Funds 1,832,484 1,958,712 3,319,293 6,841,584 48.5% NORMAL Total Expenditures $ 86,720,625 $ 93,789,848 $ 77,447,305 $143,417,360 54.0% NORMAL Third quarter results are performing as expected. Most variances at this time of the year are related to timing, and revenues generally match expenditures which is why these budget areas are getting a Normal status. Many Operating/Enterprise Funds have a seasonal component, and are not as active in the cold winter months (i.e. Refuse does not do yard waste, Water and Wastewater accelerate their programs during the good weather, Convention Center activity picks up in the spring, etc.). Equipment Rental vehicle purchases are typically ordered, but not yet received. Conversely, some expenses are due in entirety in the first half of the year, such as the contributions to Risk Management and Irrigation ditch charges. ➢ The Public Safety Communications Fund spent about $900,000 on the move to its new location in Union Gap which temporarily put this fund in a negative fund balance position of approximately ($92k). The 2015 budget included an interfund loan of $720,000 to fund this project. Since the fund balance just went negative at the end of September, we haven't yet activated the loan, but will do that at year end when we know the full extent of the fund balance. ➢ The Environmental Fund budget includes a grant from the Department of Ecology to clean -up the 4 Tiger Oil sites. There was another grant award in 2015, and this was included in an appropriation that went to Council in October. Yakima. 6315. 1. FIN_Report_3rd_Qtr_2015_ce.docx 8 of 14 Capital Fund budgets include the full project, and are not expected to be 100% completed in the current year. Many of the major projects are still in preliminary stages at this point in time, so the total spent at the three quarter mark of the year is just 22.1% of the budget. A listing of the top ten budgeted projects and their annual expenditures through the third quarter follow. Reserve Funds are slightly ahead in revenue, primarily because the full year of "premiums" (i.e. transfers from all the applicable operating funds) to Risk Management are made in the 1st quarter, which are then used for the purchased liability and property insurance premiums. The Employees' Health Benefit Fund is slightly below the 75% mark mid - year -- the cost containment measures implemented at the beginning of the year are working to hold these costs down, but we did have several larger claims. This fund balance will be monitored to assure it complies with state requirements. The Wellness /Employee Assistance Program (EAP) fund is funded annually at the end of the year by a transfer from operating funds of the City's portion of insurance premiums budgeted for unfilled /vacant positions, so the full budget is "pre- funded" and there is no revenue in this fund until year -end. The Firemens' Relief and Pension Fund has property tax as its primary revenue source, which we receive in April and October —this fund will ultimately receive its revenue budget. Revenues in Bond Redemption Funds are deposited /transferred ratably throughout the year. The bulk of debt service payments are made in the second and last quarters. Yakima. 6315. 1. FIN_Report_3rd_Otr_2015_ce.docx 9 of 14 TOP 10 CAPITAL PROJECTS These 10 projects represent about 58% of the total capital budgets: Total Actual 2015 2015 Project Number/Description Dept Budget Expended Funding Source Expected Completion 2376 Airport -Alpha Taxiway AP $10,090,644 $ 509,689 FAA Grant FY2015/16 Construction Passenger Facility Charges 2402 LIFT Area Roundabout LF 2,600,000 1,124,249 LIFT Sales tax credit, County FY 2015 Fair Avenue SIED loan & grant, local match 2365 Beech St Interceptor Phase III WW 1,800,000 - Charges for Services FY2015/16 TBD N 1st St Revitalization - Stormwater SW 1,790,000 - Charges for Services FY2015/16 2335 Modifications to Water Treatment W 1,408,580 123,733 Charges for Services FY 2015 Plant Intake 2391 N 1st St Revitalization - W 1,360,000 - Charges for Services FY2015/16 Water Main Replacement 2390 N 1st St Revitalization Phase II ST 1,315,000 335,546 Street Capital Reserves FY2015/16 n/a Transit Bus Replacement TR 1,290,000 - Transit Sales Tax FY 2015 n/a Fire ladder truck replacement F 1,150,000 - Fire Capital Reserves, FY 2016 State local lease program 2414 Randall Park improvements PK 900,000 12,152 RCO Grant, Parks Capital, FY 2015 community donations $23,704,224 Department Legend: AP - Airport ST - Street Improvement LF - LIFT Area TR - Transit WW - Wastewater Capital F - Fire Capital SW - Stormwater PK - Parks Capital W - Water Capital Yakima. 6315. 1. FIN_Report_3rd_Otr_2015_ce.docx 10 of 14 EXHIBITS OTHER OPERATING /ENTERPRISE FUNDS Exhibit I Fund Actual Beg Bal 01/01/15 Amended Budget Revenues Actual Revenue % Rec'd Appropriations Amended Actual Budget Exp % Exp'd Ending Balance 12/31/15 Economic Development $ 85,432 $ 222,000 $ 184,019 82.9% $ 260,766 $ 172,804 66.3% $ 96,647 Neighborhood Development 830,030 3,368,256 650,071 19.3% 3,373,107 944,816 28.0% 535,285 Community Relations 603,473 596,600 352,512 59.1% 674,823 452,695 67.1% 503,290 Cemetery 56,376 264,950 172,729 65.2% 291,709 219,206 75.1% 9,899 Emergency Services 208,306 1,290,026 769,255 59.6% 1,312,692 902,145 68.7% 75,416 Public Safety Communicatic 871,526 4,095,799 2,022,221 49.4% 4,506,862 2,985,637 66.2% (91,890) Police Grants 174,736 484,000 284,719 58.8% 475,296 171,993 36.2% 287,462 P.B.I.A. (Parking & Bus Impr 12,408 197,840 168,556 85.2% 202,172 138,089 68.3% 42,875 Trolley 97,884 293,624 229,616 78.2% 368,961 251,438 68.1% 76,062 Front Street Bus Impr Area 6,099 3,735 3,701 99.1% 7,000 2,421 34.6% 7,379 Conv Center (Tourist Promo 540,514 1,674,250 1,138,000 68.0% 1,609,854 1,179,255 73.3% 499,259 Capitol Theatre 27,259 395,250 295,557 74.8% 397,290 309,311 77.9% 13,505 PFD- Convention Center 421,225 816,750 613,779 75.1% 748,220 555,882 74.3% 479,122 Tourism Promotion Area 79,626 687,000 457,582 66.6% 687,000 457,582 66.6% 79,626 PFD- Capitol Theatre 176,423 618,700 465,159 75.2% 640,220 479,632 74.9% 161,950 Airport Operating 8,539 1,108,889 771,547 69.6% 1,102,006 772,076 70.1% 8,010 Stormwater Operating 1,420,735 2,151,000 1,732,511 80.5% 3,353,229 1,998,422 59.6% 1,154,824 Transit Operating 1,923,362 8,519,226 5,737,805 67.4% 8,615,247 5,682,737 66.0% 1,978,430 Refuse 283,037 5,834,599 4,120,001 70.6% 5,877,188 4,187,566 71.3% 215,472 Wastewater Operating 4,179,204 21,431,302 16,443,368 76.7% 20,901,186 15,120,616 72.3% 5,501,956 Water Operating 3,605,526 8,876,000 6,798,649 76.6% 9,347,579 7,448,831 79.7% 2,955,344 Irrigation 854,274 1,766,200 1,311,054 74.2% 1,795,875 1,458,037 81.2% 707,291 Equipment Rental 4,305,656 5,612,858 3,292,317 58.7% 5,697,917 2,886,816 50.7% 4,711,157 Environmental 627,146 1,010,000 1,170,020 115.8% 1,007,950 1,228,865 121.9% 568,301 Public Works Admin. 509,733 1,115,438 836,781 75.0% 1,165,173 849,920 72.9% 496,594 Total Other Operating Funds $ 21,908,529 $ 72,434,292 $ 50,021,529 69.1% $ 74,419,322 $ 50,856,792 68.3% $ 21,073,266 Yakima. 6315. 1. FIN_Report_3rd_Otr_2015_ce.docx 11 of 14 Fund Arterial Street Central Bus District Capital Capitol Theatre Construction Yakima Redevelopment Area Parks and Recreation Capital Fire Capital Law and Justice Capital Public Works Trust Constr REET 2 Capital Street Capital Convention Center Cap Impr Reserve for Capital Impr Airport Capital Stormwater Capital Transit Capital Wastewater Capital Water Capital Irrigation Capital Total Capital Impr Funds Exhibit II CAPITAL IMPROVEMENT FUNDS Actual Revenues Appropriations Ending Beg Bal Amended Actual % Amended Actual % Balance 01/01/15 Budget Revenue Rec'd Budget Exp Exp'd 12/31/15 $ 1,367,587 $ 2,474,269 $ 1,196,119 48.3% $ 2,532,490 $ 908,692 35.9% $ 1,655,014 116,226 26,220 422,871 n/a 91,000 293,464 322.5% 245,633 144,473 71,927 91,445 n/a 190,000 12,906 n/a 223,012 2,668,747 1,900,000 577,876 30.4% 3,500,000 1,124,249 32.1% 2,122,374 253,224 1,750,000 657,946 n/a 1,962,211 419,323 21.4% 491,847 1,097,851 1,963,500 39,685 2.0% 2,942,501 1,135,866 38.6% 1,670 574,249 554,886 410,603 74.0% 702,243 338,921 48.3% 645,931 750,742 836,449 659,231 78.8% 1,028,084 503,354 49.0% 906,619 551,438 1,152,000 659,231 57.2% 1,572,787 786,361 50.0% 424,308 931,057 20,811 84,183 404.5% 900,238 914,473 n/a 100,767 636,676 229,500 171,750 74.8% 549,790 154,834 28.2% 653,592 2,403,431 50,000 277,220 554.4% 3,745,000 1,038,252 27.7% 1,642,399 633,020 12,776,500 636,548 5.0% 12,539,721 536,254 4.3% 733,314 1,930,823 940,000 867,568 92.3% 2,025,000 141,203 7.0% 2,657,188 2,309,367 1,868,507 57,750 3.1% 1,749,000 49,314 2.8% 2,317,803 4,845,013 5,781,500 2,717,025 47.0% 4,690,000 481,060 10.3% 7,080,978 3,672,214 750,000 1,155,893 154.1% 2,670,000 157,735 5.9% 4,670,372 1,070,351 1,430,060 1,045,638 73.1% 1,567,742 919,294 58.6% 1,196,695 $ 25,956,489 $ 34,576,129 $11,728,582 33.9% $ 44,957,807 $ 9,915,555 22.1% $ 27,769,516 Yakima. 6315. 1. FIN_Report_3rd_Otr_2015_ce.docx 12 of 14 Fund Employee Benefit Reserves Unemployment Comp Res Employees Health Ben Res Worker's Compensation Res Wellness /EAP Firemens' Relief and Pension Total Employee Ben Reserve Operating Reserves Capitol Theatre Reserve Risk Management Reserve Total Operating Reserve Trust and Agency Funds Cemetery Trust Agency Fund- YAKCORPS Total Other Funds Exhibit III RESERVE AND OTHER FUNDS Actual Revenues Appropriations 6,976,681 Ending Beg Bal Amended Actual % Amended Actual % Balance 01/01/15 Budget Revenue Rec'd Budget Exp Exp'd 12/31/15 $ 435,945 $ 197,000 $ 149,320 75.8% $ 323,177 $ 125,732 38.9% $ 459,533 2,077,874 9,823,850 6,976,681 71.0% 9,745,849 7,243,923 74.3% 1,810,632 880,288 1,033,000 838,402 81.2% 1,241,131 902,305 72.7% 816,385 182,715 175,000 - 0.0% 174,800 73,478 42.0% 109,237 974,543 1,280,838 759,139 59.3% 1,380,282 955,458 69.2% 778,224 $ 4,551,365 $12,509,688 $ 8,723,542 69.7% $12,865,239 $ 9,300,896 72.3% $ 3,974,011 $ 108,568 $ - $ - n/a $ 71,927 $ 53,945 75.0% $ 54,623 956,899 3,684,000 3,309,619 89.8% 3,643,704 3,511,599 96.4% 754,919 $1,065,467 $ 3,684,000 $ 3,309,619 89.8% $ 3,715,631 $ 3,565,544 96.0% $ 809,542 $ 632,022 $ 14,500 $ 14,129 97.4% $ 12,000 $ - 0.0% $ 646,151 80,133 605,777 627,333 103.6% 605,777 489,225 80.8% 218,241 $ 712,155 $ 620,277 $ 641,462 103.4% $ 617,777 $ 489,225 79.2% $ 864,392 Yakima. 6315. 1. FIN_Report_3rd_Qtr_2015_ce.docx 13 of 14 Fund GO Bond Redemption LID Guaranty 2002 GO Convention Center 2005 GO Various Bonds 1996 GO LTD- Conv Center LID Debt Service Control Total G. 0. Bond Redemption Water /Sewer Revenue Bond Redemption 1997 Water Rev Bond Res 1996 Revenue Bond Reserve 1997 Water Revenue Bonds 2008 Water /Sewer Rev Bond Water /Sewer Rev Bond Res 2003 Irrigation Bond Red 2003 Wastewater Bond Red Total W/S Rev Bond Red Exhibit IV BOND REDEMPTIONS FUNDS Actual Revenues Appropriations 0.0% Ending Beg Bal 01/01/15 Amended Actual % Budget Revenue Rec'd Amended Actual Budget Exp % Exp'd Balance 12/31/15 $ 25,264 $ 50 $ - 0.0% $ - $ - n/a $ 25,264 161,795 1,016,422 745,303 73.3% 1,026,050 551,588 53.8% 355,510 8,733 3,010,189 2,971,978 98.7% 3,010,189 2,103,268 69.9% 877,443 67,965 428,750 303,979 70.9% 428,190 36,595 8.5% 335,349 15 245,000 63,186 25.8% 245,000 55,395 22.6% 7,806 $ 263,772 $ 4,700,411 $ 4,084,446 86.9% $ 4,709,429 $ 2,746,846 58.3% $1,601,372 $ 358,989 $ 400 $ - 0.0% $ - $ - n/a $ 358,989 149,163 700 - 0.0% - - n/a 149,163 6,966 237,725 237,700 100.0% 237,700 18,850 7.9% 225,816 2 411,413 411,413 100.0% 411,413 85,706 20.8% 325,709 897,333 1,000 - 0.0% - - n/a 897,333 34,812 317,742 317,742 100.0% 317,742 317,741 100.0% 34,813 255,965 1,165,300 873,975 75.0% 1,165,300 150,150 12.9% 979,790 $1,703,230 $ 2,134,280 $1,840,830 86.3% $ 2,132,155 $ 572,447 26.8% $ 2,971,613 Yakima. 6315. 1. FIN_Report_3rd_Otr_2015_ce.docx 14 of 14