HomeMy WebLinkAbout08/16/2016 06F Mid-year 2016 Budget Status Report 10 I
I 410)1
BUSINESS OF THE CITY COUNCIL
YAKIMA, WASHINGTON
AGENDA STATEMENT
Item No. 6.F.
For Meeting of: August 16, 2016
ITEM TITLE: Mid -year 2016 Budget Status Report
SUBMITTED BY: Cliff Moore, City Manager
Cindy Epperson, Director of Finance & Budget
SUMMARY EXPLANATION:
At a study session held earlier in the day, the mid -year 2016 report was presented for Council
review and discussion. In order to maintain consistency for interested individuals to find the
quarterly reports, the report is included in the regular business meeting for Council action.
As part of the 2013 Strategic Plan, the City Council implemented a Financial Trend Monitoring
System (FTMS) in order to provide a more 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.
As described in the updated Five -Year Financial Plan presented to Council on February 23rd,
2016, both Sales Tax and Utility Taxes did not come in as budgeted in 2015, which resulted in an
overstatement of revenue estimates in 2016, as well. At the April 5th meeting, Council approved
a plan to reduce expenditures by about $750,000, the estimated amount of the revenue
overstatement.
At the end of the second quarter 2016, we are seeing typical variances tied to timing - -such as
annual premiums, dues /assessments. All expenditure categories received a "normal" ranking, as
actual results are within 5% of expected levels at this point in time. Sales Tax and Utility Tax
categories in General Government are receiving a "warning" designation, as these major revenue
sources are not expected to reach the budget. No categories received a "negative" designation.
As part of developing the 2017 budget, the 2016 actual results are being compared to budget
and new year -end estimates are developed. This accomplishes two purposes — the ending fund
balance (which then becomes the beginning 2017 fund balance) is calculated based on these
estimates; and we can identify areas that will require an appropriation. Examples of items
needing additional appropriation may include new grant awards, snow plowing events and
retirement cashouts. We expect to come to Council for the first reading of an appropriation in late
September or October.
Overall, citywide first quarter results are as anticipated. Because of the slowdown identified
earlier in the year in utility and sales tax revenues, management initiated cost containment
measures in General Government funds which will extend at least through the end of the year, and
potentially into 2017 depending on revenue estimates.
ITEM BUDGETED: NA
STRATEGIC PRIORITY: Public Trust and Accountability
APPROVED FOR
SUBMITTAL: City Manager
STAFF RECOMMENDATION:
Accept Report
BOARD /COMMITTEE RECOMMENDATION:
ATTACHMENTS:
Description Upload Date Type
Mid year 2016 budgk report 8/10/2016 Cnver Memo o
MEMORANDUM
August 11, 2016
TO: The Honorable Mayor and
Members of the City Council
FROM: Cliff Moore, City Manager
Cindy Epperson, Director of Finance & Budget
SUBJECT: 2016 2nd Quarter Financial Trend Monitoring Report
We are submitting for your review the City of Yakima's 2016 2nd Quarter actual compared to
budgeted Revenue and Expenditure Report for all city funds.
Overall, the City budget is performing as expected.
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. 7345 .1.FIN_Report_2nd_Qtr_2016.docx 1 of 14
CITY WIDE OVERVIEW
REVENUE COMPARISON
(Budget vs. Actual)
2015 2016
Percent Amended Percent
Actual Rec'd Budget Actual Rec'd
General $ 30,121,613 49.1% $ 62,702,510 $ 31,670,814 50.5%
Parks and Recreation 2,718,209 49,8% 5,510,965 2,720,189 49.4%
Street & Traffic Operations 2,539,208 53 5,059,850 2,581,822 51.0%
General Government Subtotal 35,379,030 49.5% 73,273,325 36,972,825 50.5%
Operating/Enterprise Funds 32,511,089 44.9% 72,583,371 33,261,209 45.8%
Capital Funds 6,947,240 16.3% 46,644,571 11,730,420 25.1%
G.O. Bond Redemption Funds 2,877,480 60.7% 4,815,142 2,990,938 62.1%
Utility Revenue Bond Redemption Funds 1,549,505 36.3% 2,131,180 1,064,626 50.0%
Employee Benefit Reserves 6,046,520 48.3% 13,120,340 6,462,669 49.3%
Operating Reserves 3,212,786 87.2% 4,894,000 3,470,130 70.9%
Trust and Agency Funds 639,339 103.1% 626,777 668,934 106.7%
Total $ 89,162,989 43.1% $218,088,706 $ 96,621,751 44.3%
EXPENDITURE COMPARISON
(Budget vs. Actual)
2015 2016
Percent Amended Percent
Actual Spent Budget Actual Spent
General $ 30,840,297 50.1% $ 62,702,391 $ 31,770,032 50.7%
Parks and Recreation 2,610,280 47.0% 5,468,072 2,756,378 50.4%
Street & Traffic Operations 2,344,960 46.1% 5,090,088 3,023,568 59.4%
General Government Subtotal 35,795,537 49.5% 73,260,551 37,549,978 51.3%
Operating /Enterprise Funds 34,320,177 42.6% 73,893,343 33,831,594 45.8%
Capital Funds 5,864,923 12.9% 57,879,417 9,272,194 16.0%
G.O. Bond Redemption Funds 2,652,539 55.1% 4,808,964 2,805,290 58.3%
Utility Revenue Bond Redemption Funds 348,577 16.3% 2,129,054 327,027 15.4%
Employee Benefit Reserves 6,464,216 50.2% 13,398,134 6,529,683 48.7%
Operating Reserves 2,758,395 74.2% 4,901,505 4,152,888 84.7%
Trust and Agency Funds 472,440 76.5% 617,777 254,797 41.2%
Total $ 88,676,804 39.9% $230,888,745 $ 94,723,451 41.0%
Yakima. 7345 .1.FIN 2 of 14
GENERAL GOVERNMENT REVENUE ANALYSIS
GENERAL GOVERNMENT REVENUES
2016
Revenues through 6/30 Amended Percent
2014 2015 2016 Budget Receipted Status
General Sales Tax $ 7,236,681 $ 7,520,655 $ 7,748,857 $16,650,400 46.5% WARNING
Crirn. Justice Sales Tax 1,496,667 1,567,934 1,572,683 3,361,500 46.8% NORMAL
Property Tax 8,789,196 9,123,719 9,354,129 16,653,030 56.2% NORMAL
Utility & Franchise Taxes 8,123,940 7,688,398 7,738,356 16,278,300 47.5% WARNING
Charges for Services 3,252,345 4,055,352 4,580,059 8,718,028 52.5% NORMAL
State Shared Revenue 1,462,966 1,345,709 1,508,625 3,001,800 50.3% NORMAL
Other Intergovernmental 700,272 943,918 822,651 1,705,237 48.2% NORMAL
Fines and Forfeitures 765,276 837,683 876,779 1,707,110 51.4% NORMAL
Other Taxes 962,810 909,565 858,538 1,535,000 55.9% NORMAL
Transfers from other Funds 648,986 639,855 629,797 1,450,000 43.4% NORMAL
Licenses and Permits 373,827 413,128 509,108 916,470 55.6% NORMAL
Other Revenue 316,627 333,114 773,243 1,296,450 59.6% NORMAL
Total Revenue 34,129,593 35,379,030 36,972,825 73,273,325 50.5% NORMAL
Beginning Fund Balance 10,883,753 9,412,400 7,152,826 7,152,826
Total Resources $45,013,346 $44,791,430 $ 44,125,651 $80,426,151 54.9% NORMAL
Sales Tax - As reported in the Five -Year Financial Plan that went to Council on February 23, 2016, Sales Tax
dropped below prior year actual for the last 3 months of 2015, attributed primarily to the drought putting a
damper on spending in the region. Through the first quarter of 2016, sales tax was still running slightly
below the prior year, although there has been a positive trend for April through July, so that through the
seven months ending in July, we are 2.9% ahead of 2015 year to date for the same time period. The
downturn was noted and addressed in a report of Budget Reductions that went to Council on April 5, 2016.
The modified budget estimate was $16,271,000 -- $379,400 or 2.3% below the budgeted $16,650,400, and the
new estimate being used for the 2016 budget estimate is revised upward to $16,364,000 - still below the
original budget, which is why this category received a "warning" designation, but only by $286,400. The
new estimate is 3.8% above 2015 actual. The 2015 actual was only 2.9% higher than the full year of 2014,
after 3 consecutive years of 6.4% and higher growth rates in the years 2012 -2014. Since our economy is
closely tied to the agricultural sector, the wet winter eliminated the threat of extreme drought, and the four
recent sales tax receipts (i.e. April through July) would indicate an upturn in the economy. In looking at 1st
and 2nd quarter data from the Employment Security Department, year -over -year job growth was 2.6% and
2.4% respectively - -in comparison, the 3 and 4th quarters of 2015 experienced year -over -year job growth of
only 1.1% in each quarter. This job growth preliminarily indicates an upturn in the underlying economy.
Building Permit activity is staying strong, and this is a pre - cursor to construction sales tax. Looking at these
underlying economic factors, this revenue appears to be on target to meet the reduced budget estimate by
year end.
Yakima. 7345 .1.FIN_Report_2nd_Qtr_2016.docx 3 of 14
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
2016 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 — After falling off in 2015, this category is experiencing 0.65% growth over the
prior year at the end of the 2nd quarter, and is below the 50% mark through this time frame. Contributing
factors for this category includes weather conditions through the first six months of the year. Natural gas
use does slow down for the rest of the year, but water related utilities go up through the summer months,
as well as higher activity in strong waste producing operations (i.e. fruit processing) so this category overall
is expected to end about $330,000 below budgeted amounts by year end, still in line with the estimate made
in the most recent Five -Year Financial Plan. This reduced estimate, coupled with the lowered sales tax
estimate comprises most of the total reduction in revenue estimates that necessitated the mid -year budget
reductions.
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.
Other Intergovernmental — The SAFER (i.e. firefighter hiring) grant is only billed annually at the end of the
year, so the negative variance for this category is a timing difference, and considered normal.
Other Taxes — This category consists primarily of Business Licenses and Gambling Taxes. Business licenses
are due in January for the year, so that about 63% of this one category has been collected by June 30. It is
below prior year actual, because the bills went out earlier in December, and some of this revenue was
posted at the end of 2015. We anticipate the timing of the billing to continue at the earlier time, so that the
positive variance is a timing difference, and considered normal. Gambling Taxes are performing as
expected.
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 one of the four Tiger Mart properties was
completed in the 2 quarter for an amount that approximated the budget. Therefore, this positive 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,594,000 or 4.5% over 2015, and we anticipate year end to meet the
revenue budget within the 3% range which maintains the "normal" ranking. If the one time revenue tied to
the sale of a Tiger Mart property is removed, revenue is up approximately $1,190,000 or 3.4 %. We are not
experiencing a large increase in any revenue category, so the budget constraints are still necessary to
balance 2016.
Yakima. 7345 .1.FIN_Report_2nd_Qtr_2016.docx 4 of 14
GENERAL GOVERNMENT REVENUES - By Month
2014 2015 2016
Jan $ 4,775,515 $ 4,516,085 $ 5,041,214
Feb 4,770,901 4,721,588 5,025,995
Mar 4,984,701 5,504,709 4,977,454
Apr 10,717,557 11,330,918 11,269,682
May 4,573,329 4,855,486 5,909,109
Jun 4,307,587 4,259,390 4,749,373
Jul 4,304,052 4,604,158 -
Aug 4,290,971 4,636,646 -
Sep 5,180,804 5,084,171 -
Oct 9,891,373 10,623,480 -
Nov 4,395,161 4,782,114 -
Dec 5,190,725 5,348,293 -
$67,382,676 $70,267,038 $36,972,827
$12,500,000
$10,000,000
• 2014
$7,500,000
$5,000,000 - • 2015
$2,500,000
$_ • 2016
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
GENERAL GOVERNMENT REVENUES - Cumulative By Month
2014 2015 2016
Jan $ 4,775,515 $ 4,516,085 $ 5,041,214
Feb 9,546,416 9,237,673 10,067,209
Mar 14,531,117 14,742,382 15,044,663
Apr 25,248,674 26,073,300 26,314,345
May 29,822,003 30,928,786 32,223,454
Jun 34,129,590 35,188,176 36,972,827
Jul 38,433,642 39,792,334 -
Aug 42,724,613 44,428,980
Sep 47,905,417 49,513,151 -
Oct 57,796,790 60,136,631 -
Nov 62,191,951 64,918,745 -
Dec 67,382,676 70,267,038 -
$80,000,000
$60,000,000 • 2014
$40,000,000
• 2015
$20,000,000
$- ... MI III P 2016
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Yakima. 7345 .1.FIN_Report_2nd_Qtr_2016.docx 5 of 14
GENERAL FUND EXPENDITURE ANALYSIS
GENERAL GOVERNMENT EXPENDITURES
2016
Expenditures through 6/30 Amended Percent
2014 2015 2016 Budget Spent Status
Police $12,982,772 $13,203,992 $13,576,342 $27,178,683 50.0% NORMAL
Fire 5,212,980 6,067,545 6,010,719 12,310,596 48.8% NORMAL
Transfers To Other Funds 1,265,088 2,250,589 2,846,137 4,839,545 58.8% NORMAL
Information Technology 1,512,453 1,724,150 1,618,704 3,113,902 52.0% NORMAL
Code Administration 1,859,643 778,314 880,107 1,839,575 47.8% NORMAL
Utility Services 759,079 783,411 819,471 1,691,074 48.5% NORMAL
Legal 619,742 738,787 741,645 1,645,037 45.1% NORMAL
Financial Services 687,313 804,526 744,702 1,529,538 48.7% NORMAL
Municipal Court 604,553 626,783 674,797 1,427,119 47.3% NORMAL
Police Pension 640,315 570,208 493,074 1,104,060 44.7% NORMAL
Indigent Defense 336,713 454,335 469,446 935,500 50.2% NORMAL
Economic Development 306,569 412,236 399,033 888,891 44.9% NORMAL
Engineering 394,088 388,494 336,463 833,710 40.4% NORMAL
Planning 280,687 256,367 299,430 652,548 45.9% NORMAL
Records / City Clerk 245,038 331,982 406,469 652,086 62.3% NORMAL
Human Resources 291,149 306,444 307,652 648,774 47.4% NORMAL
Purchasing 220,940 303,307 307,537 630,092 48.8% NORMAL
City Hall Facility 270,835 307,868 304,478 505,447 60.2% NORMAL
City Manager 187,762 208,883 236,922 418,138 56.7% NORMAL
City Council 171,443 165,447 164,434 285,340 57.6% NORMAL
Neighborhood Partnerships - - - 206,735 n/a NORMAL
Intergovernmental 198,030 87,596 94,739 189,551 50.0% NORMAL
State Examiner - 4,209 587 113,000 0.5% NORMAL
Gang Free Initiative 73,870 64,824 37,144 148,450 n/a NORMAL
Position Vacancy Savings - - - (1,085,000) 0.0%
Total General Fund 29,121,062 30,840,297 31,770,032 62,702,391 50.7% I NORMAL
Parks & Recreation Fund 2,146,848 2,610,280 2,756,378 5,468,072 50.4% NORMAL
Street & Traffic Ops. 2,681,439 2,344,960 3,023,568 5,090,088 59.4% NORMAL
Total General Government $33,949,349 $35,795,537 $37,549,978 $73,260,551 51.3% NORMAL
Total General Government Fund Expenditures - 1.3% Above 50% NORMAL
Note: The "normal" designation is comparing to the budget after the budget reduction proposals are removed.
Yakima. 7345 .1.FIN_Report_2nd_Qtr_2016.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 second quarter. For example, the entire contribution to
the Risk Management fund is made in the first half of the year, 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 69% salaries many variances are tied to
persormel — i.e. position vacancies.
The following explains why some areas are receiving a Normal designation even though they may be
over /under 25% in first quarter, yet comparable to prior years —i.e. payment timing variance
➢ Transfers to Other Funds — The annual principal payment on the 2014 street bond issue is due in the
second quarter, which put this category slightly over 50 %.
➢ Information Technology — Annual maintenance for various computer software systems, including
the annual YAKCORPS assessment, is paid in the first half of the year.
➢ Legal — This savings is the result of the City Attorney being paid out of the City Manager's budget
as interim City Manager. Also, the Community Court program that was going to start in early 2016
was postponed in the budget reduction activity.
➢ Records /City Clerk — Prior year election costs of $214,000 were paid in the first quarter.
➢ City Hall Maintenance — Semi - annual transfer to Risk Management Fund to pay for property
insurance is made in the first half of the year - $139,000.
➢ City Manager — One -time recruiting expenses for the new City Manager, along with the employee
survey are included in the year -to -date figures.
➢ City Council — Annual Association of Washington Cities (AWC) dues of $64,600 paid in the first
quarter.
➢ Neighborhood Partnerships — This is a new program that was postponed in the April budget
reduction report due to the slow down of sales tax revenue.
➢ State Examiner — The annual audit does not get under way until the end of the 2 quarter.
➢ Street and Traffic Operations — There was a snow event in the 1st quarter that required overtime
and outside contractors to plow. It is likely that an appropriation will be necessary, which will be
brought to Council after we start to develop the 2017 budget and review 2016 results in late
September.
Position Vacancy Savings — Shown for fund total purposes only — no "actual" will be charged here.
Yakima. 7345 .1.FIN_Report_2nd_Qtr_2016.docx 7 of 14
OTHER FUNDS ANALYSIS
OTHER FUNDS REVENUES
2016
Revenues through 6/30 Amended Percent
2014 2015 2016 Budget Recd Status
Operating /Enterprise Funds $ 31,826,425 $ 32,511,089 $ 33,261,209 $ 72,583,371 45.8% NORMAL
Capital Funds 27,083,556 6,947,240 11,730,420 46,644,571 25.1% NORMAL
Reserve, Trust & Agency Funds 9,137,164 9,898,645 10,601,733 18,641,117 56.9% NORMAL
Bond Redemption Funds 2,425,724 4,426,985 4,055,564 6,946,322 58.4% NORMAL
Total Revenue 70,472,869 53,783,959 59,648,926 144,815,381 41.2% NORMAL
Beginning Fund Balance 51,645,155 51,022,832 61,807,854 61,807,854
Total Resources $122,118,024 $104,806,791 $121,456,780 $206,623,235 58.8% I NORMAL
OTHER FUNDS EXPENDITURES
2016
Expenditures through 6130 Amended Percent
2014 2015 2016 Budget Rec'd Status
Operating/Enterprise Funds $ 30,465,242 $ 34,320,177 $ 33,831,594 $ 73,893,343 45.8% NORMAL
Capital Funds 16,410,223 5,864,923 9,272,194 57,879,417 16.0% NORMAL
Reserve, Trust & Agency Funds 8,701,979 9,695,051 10,937,368 18,917,416 57.8% NORMAL
Bond Redemption Funds 1,638,340 3,001,116 3,132,317 6,938,018 45.1% NORMAL
Total Expenditures $ 57,215,784 $ 52,881,267 $ 57,173,473 $157,628,194 36.3% NORMAL
Second quarter results are performing as expected. Most variances at this time of the year are related to
timing, which is why they 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
quarter, such as the half of the contributions to Risk Management and Irrigation ditch charges.
The ONDS fund's budget has many large projects that did not have much activity in the first half.
Similarly, the Environmental Fund budget includes a grant from the Department of Ecology to clean-up a
Tiger Oil site. This work is just getting started. As is typical with grant - funded programs, the expenditures
have to be made before we can be reimbursed.
Capital Fund budgets include the full project, and are not expected to be 100% completed in the current
year. The projects budgeted to be funded by limited tax general obligation bonds are currently "on hold"
until we can identify available funds to repay the future debt service. Funding for N 1st Street is being
Yakima. 7345 .1.FIN_Report_2nd_Qtr_2016.docx 8 of 14
researched, and the related utility projects will not go forward until the Street project does. The large
equipment purchases (such as Transit buses and Fire apparatus) have been ordered, but depending on the
demand at the manufacturers, it could take up to a year to actually receive the equipment. We received
three buses ordered last year, and there are an additional 4 still on order. The Airport taxi way project got
under way in the 2 quarter. The City purchased the land from SOZO in 2015, and will pay for the
improvements as they occur throughout 2016. A listing of the top ten budgeted projects and their first
quarter expenses follow.
Reserve Funds are slightly ahead in revenue, primarily because a full year of "premiums" (i.e. transfers
from all the applicable operating funds) to Risk Management are made in the 1st half of the year, which are
then used for the purchased liability and property insurance premiums. Expenditures in Risk
Management also includes the $1.8 million settlement to the ACLU for the Voting Rights Act lawsuit paid
out in April. Available cash is minimal in this fund after insurance premiums and the large settlement.
This fund will likely need an interfund loan to cover ongoing program costs for the rest of the year. The
2017 budget tentatively includes a 12% increase in premiums to begin to replenish this reserve balance.
The Employees' Health Benefit Fund has used about $300,000 of fund balance through the first half of the
year — even though effective cost containment measures have been in place. Because of this trend, coupled
with a change in the underlying healthcare program that moves from reference -based hospital facility
costing back into utilizing a discount network, we implemented a mid -year "premium" increase of about
5 %, to cover claims for the rest of the year and keep an adequate reserve balance. We will be working with
all operating budgets to make sure they can absorb this increase. There may be a few instances where that
may not be possible, and those will be included in the mid -year appropriation ordinance after we get the
2016 budget estimates set (probably late September).
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. Revenue
in the Firemen's Relief and Pension Fund are tied to the property tax collection calendar —the positive
revenue variance is a timing issue (as described in the General Government section).
Revenues in Bond Redemption Funds are generally deposited /transferred ratably throughout the year, but
the bulk of debt service payments are made in the second and last quarters. For existing bond issues, these
funds will always approximate budget. The only real chance for a variance from budget is if an actual debt
service schedule for new debt differs from a budgeted estimate.
Yakima. 7345 .1.FIN_Report_2nd_Qtr_2016.docx 9 of 14
TOP 10 CAPITAL PROJECTS
These 10 projects represent about 58% of the total capital budgets:
Total Actual
2016 2016 Expected
Project Number/Description Dept Budget Expended Funding Source Completion
2376 Airport -Alpha Taxiway AP $10,120,000 $ 2,455,118 FAA Grant FY2016
Construction Passenger Facility Charges
2390 N 1st St Revitalization Phase II ST 6,855,000 153,156 Street Capital Reserves ?
State Grant, $6m LTGO Bond
2426 Road Improvements ST 5,000,000 - LTGO Bond ?
2365 Beech St Interceptor Phase III WW 4,000,000 - Charges for Services FY 2016/17
Capital Reserves
2406 SOZO Improvement & Land PK 3,350,000 478,259 LTGO Bond (carryover) FY2016
Purchase Phase II
n/a Transit Bus Replacement (7) TR 3,094,000 1,414,325 Transit Sales Tax, Capital FY2016/17
(3 received, 4 on order) Reserves, WSDOT Grant
2405 Yakima Central Plaza Phase II CBD 2,800,000 510,172 Community Donations, FY2016/17
LTGO Bonds
TBD N 1st St Revitalization - Stormwater SW 1,790,000 - Charges for Services ?
Capital Reserves
2391 N 1st St Revitalization - W 1,200,000 - Charges for Services ?
Water Main Replacement Capital Reserves
n/a Fire ladder truck replacement F 1,150,000 - Fire Capital Reserves, FY 2015/16
(on order) State LOCAL lease program
$ 39,359,000
Department Legend:
AP - Airport ST - Street Improvement
CBD - Central Business District TR - Transit
WW - Wastewater Capital F - Fire Capital
SW - Stormwater PK - Parks Capital
W - Water Capital
Yakima. 7345 .1.FIN_Report_2nd_Qtr_2016.docx 10 of 14
EXHIBITS
Exhibit I
OTHER OPERATING /ENTERPRISE FUNDS
Actual Revenues Appropriations Ending
Beg Bal Amended Actual % Amended Actual % Balance
Fund 01/01/16 Budget Revenue Rec'd Budget Exp Exp'd 12/31/16
Economic Development $ 76,421 $ 183,000 $ 82,441 45.0% $ 198,071 $ 71,049 35.9% $ 87,813
Neighborhood Development 897,054 3,338,886 198,746 6.0% 3,349,462 528,944 15.8% 566,856
Community Relations 657,412 666,600 170,022 25.5% 618,913 279,883 45.2% 547,551
Cemetery 37,538 262,950 123,626 47.0% 273,542 138,298 50.6% 22,866
Emergency Services 203,162 1,326,026 744,636 56.2% 1,407,117 662,635 47.1% 285,163
Public Safety Communicatic (361,269) 3,499,468 2,209,889 63.1% 3,563,096 1,780,547 50.0% 68,073
Police Grants 371,378 416,000 320,018 76.9% 369,716 103,077 27.9% 588,319
P.B.I.A. (Parking & Bus Impr (4,561) 205,340 109,231 53.2% 208,993 96,120 46.0% 8,550
Trolley 73,180 91,433 1,275 1.4% 164,855 73,168 44.4% 1,287
Front Street Bus Impr Area 4,679 3,735 5,703 152.7% 10,279 6,094 59.3% 4,288
Cony Center (Tourist Promo 528,261 1,683,800 699,291 41.5% 1,694,510 834,157 49.2% 393,395
Capitol Theatre 26,567 414,700 205,340 49.5% 420,497 227,089 54.0% 4,818
PFD- Convention Center 514,586 828,750 408,632 49.3% 727,720 362,084 49.8% 561,134
Tourism Promotion Area 80,822 687,000 269,790 39.3% 687,000 210,238 30.6% 140,374
PFD- Capitol Theatre 166,911 624,800 309,531 49.5% 630,883 314,165 49.8% 162,277
Airport Operating 46,313 1,134,929 559,230 49.3% 1,128,985 599,236 53.1% 6,307
Stormwater Operating 694,688 2,151,000 1,689,296 78.5% 2,638,104 1,130,237 42.8% 1,253,747
Transit Operating 1,954,958 8,701,402 3,595,175 41.3% 8,368,765 4,047,346 48.4% 1,502,787
Refuse 59,564 6,595,262 3,235,824 49.1% 6,452,485 3,148,987 48.8% 146,401
Wastewater Operating 4,309,330 22,102,484 10,683,451 48.3% 22,540,390 10,830,886 48.1% 4,161,895
Water Operating 3,130,380 8,816,000 3,899,741 44.2% 9,373,857 4,906,881 52.3% 2,123,240
Irrigation 897,427 1,803,540 933,762 51.8% 1,802,149 894,160 49.6% 937,029
Equipment Rental 4,057,425 4,722,942 2,146,701 45.5% 4,765,532 1,904,008 40.0% 4,300,118
Environmental 565,281 1,180,000 87,672 7.4% 1,247,950 39,946 3.2% 613,007
Public Works Admin. 484,256 1,143,324 572,186 50.0% 1,250,472 642,359 51.4% 414,083
Total Other Operating Funds $19,471,763 $ 72,583,371 $ 33,261,209 45.8% $ 73,893,343 $ 33,831,594 45.8% $18,901,378
Yakima. 7345 .1.FIN_Report_2nd_Qtr_2016.docx 11 of 14
Exhibit II
CAPITAL IMPROVEMENT FUNDS
Actual Revenues Appropriations Ending
Beg Bal Amended Actual % Amended Actual % Balance
Fund 01/01/16 Budget Revenue Rec'd Budget Exp Exp'd 12/31/16
Arterial Street $ 1,281,875 $10,397,841 $ 1,199,513 11.5% $10,737,025 $1,154,979 10.8% $ 1,326,409
Central Bus District Capital (23,298) 2,826,220 817,391 n/a 2,881,000 513,838 17.8% 280,255
Capitol Theatre Construction 248,750 66,641 33,321 n/a 70,000 2,478 n/a 279,593
Yakima Redevelopment Area 701,125 1,000,000 1,005,667 100.6% 1,500,000 276,992 18.5% 1,429,800
Parks and Recreation Capital 3,810,256 508,400 296,767 n/a 1,824,049 874,566 47.9% 3,232,457
Fire Capital 36,925 2,242,410 91,638 4.1% 2,239,976 153,650 6.9% (25,087)
Law and Justice Capital 740,305 479,350 233,612 48.7% 693,000 198,553 28.7% 775,364
Public Works Trust Constr 1,171,476 802,000 433,915 54.1% 1,011,385 265,068 26.2% 1,340,323
REET 2 Capital 352,961 802,000 433,915 54.1% 978,250 701,817 71.7% 85,059
Street Capital 94,164 5,095,306 20,879 0.4% 5,000,000 167 n/a 114,876
Convention Center Cap Impr 585,025 360,400 179,950 49.9% 385,000 36,190 9.4% 728,785
Reserve for Capital Impr 1,617,047 300,000 301,500 100.5% 765,000 383,193 50.1% 1,535,354
Airport Capital 795,550 11,325,568 2,392,715 21.1% 11,645,247 2,473,873 21.2% 714,392
Stormwater Capital 3,044,907 700,000 350,000 50.0% 2,400,000 2,759 0.1% 3,392,148
Transit Capital 4,464,872 3,849,875 1,182,571 30.7% 4,334,205 1,570,447 36.2% 4,076,996
Wastewater Capital 10,256,929 3,501,500 1,768,187 50.5% 7,790,000 297,711 3.8% 11,727,405
Water Capital 4,010,943 1,000,000 375,000 37.5% 2,257,738 113,120 5.0% 4,272,823
Irrigation Capital 1,503,177 1,387,060 613,879 44.3% 1,367,542 252,793 18.5% 1,864,263
Total Capital Impr Funds $ 34,692,989 $ 46,644,571 $11,730,420 25.1% $ 57,879,417 $ 9,272,194 16.0% $ 37,151,215
Yakima. 7345 .1.FIN_Report_2nd_Qtr_2016.docx 12 of 14
Exhibit III
RESERVE AND OTHER FUNDS
Actual Revenues Appropriations Ending
Beg Bal Amended Actual % Amended Actual % Balance
Fund 01/01/16 Budget Revenue Rec'd Budget Exp Exp'd 12/31/16
Employee Benefit Reserves
Unemployment Comp Res $ 441,244 $ 197,000 $ 103,403 52.5% $ 227,351 $ 74,638 32.8% $ 470,009
Employees Health Ben Res 1,616,969 10,407,500 5,043,169 48.5% 10,388,338 5,351,165 51.5% 1,308,973
Worker's Compensation Res 734,214 1,069,780 548,313 51.3% 1,311,017 457,183 34.9% 825,344
Wellness /EAP 127,185 121,800 463 0.4% 121,800 24,722 20.3% 102,926
Firemens' Relief and Pension 1,019,850 1,324,260 767,321 57.9% 1,349,628 621,975 46.1% 1,165,196
Total Employee Ben Reserve $ 3,939,462 $13,120,340 $ 6,462,669 49.3% $13,398,134 $ 6,529,683 48.7% $ 3,872,448
Operating Reserves
Capitol Theatre Reserve $ 36,641 $ - $ - n/a $ 36,641 $ 18,321 50.0% $ 18,320
Risk Management Reserve 733,243 4,894,000 3,470,130 70.9% 4,864,864 4,134,567 85.0% 68,806
Total Operating Reserve $ 769,884 $ 4,894,000 $ 3,470,130 70.9% $ 4,901,505 $ 4,152,888 84.7% $ 87,126
Trust and Agency Funds
Cemetery Trust $ 647,731 $ 21,000 $ 4,319 20.6% $ 12,000 $ - 0.0% $ 652,050
Agency Fund - YAKCORPS - 605,777 664,615 109.7% 605,777 254,797 42.1% 409,818
Total Other Funds $ 647,731 $ 626,777 $ 668,934 106.7% $ 617,777 $ 254,797 41.2% $ 1,061,868
Yakima. 7345 .1.FIN_Report_2nd_Qtr_2016.docx 13 of 14
Exhibit IV
BOND REDEMPTIONS FUNDS
Actual Revenues Appropriations Ending
Beg Bal Amended Actual % Amended Actual % Balance
Fund 01/01/16 Budget Revenue Rec'd Budget Exp Exp'd 12/31/16
GO Bond Redemption
LID Guaranty $ 25,329 $ 50 $ - 0.0% $ - $ - n/a $ 25,329
2002 GO Convention Center 163,591 1,026,103 513,046 50.0% 1,024,025 550,700 53.8% 125,937
2005 GO Various Bonds 8,734 3,312,239 2,240,707 67.6% 3,312,239 2,224,740 67.2% 24,701
1996 GO LTD- Cony Center 69,030 428,750 172,966 40.3% 424,700 29,850 7.0% 212,146
LID Debt Service Control - 48,000 64,219 133.8% 48,000 - 0.0% 64,219
Total G.O. Bond Redemption $ 266,684 $ 4,815,142 $ 2,990,938 62.1% $ 4,808,964 $ 2,805,290 58.3% $ 452,332
Water /Sewer Revenue Bond Redemption
Water Rev Bonds & Debt Service 366,380 235,125 117,350 49.9% 234,700 14,850 6.3% 468,880
WW Rev Bond & 2008 Debt Service - 411,813 205,906 50.0% 411,813 80,906 19.6% 125,000
Irrigation Bond Debt Service 34,813 317,542 158,870 50.0% 317,541 91,271 28.7% 102,412
WW Rev Bond Reserve & 2012 Debt Svc 1,618,148 1,166,700 582,500 49.9% 1,165,000 140,000 12.0% 2,060,648
Total W/S Rev Bond Red $ 2,019,341 $ 2,131,180 $1,064,626 50.0% $ 2,129,054 $ 327,027 15.4% $ 2,756,940
Yakima. 7345 .1.FIN_Report_2nd_Qtr_2016.docx 14 of 14