HomeMy WebLinkAbout06/07/2016 05C 1st Quarter 2016 Financial Trend Monitoring ReportBUSINESS OF THE CITY COUNCIL
YAKIMA, WASHINGTON
AGENDASTATEMENT
Item No. 5.C.
For Meeting of: June 7, 2016
ITEM TITLE: 1st Quarter 2016 Financial Trend Monitoring Report
SUBMITTED BY: Cindy Epperson, Director of Finance and Budget
SUMMARY EXPLANATION:
As part of the 2013 Strategic Plan, the City Council included 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.
At the end of the first quarter 2016, we are seeing typical variances tied to timing of annual
dues/assessments and property tax receipts, along with the slowdown of some operational and
construction activity in the winter months. All expenditure categories received a "normal" ranking,
as actual results are within 5% of expected levels at this point in time. The only category
receiving a "warning" designation is General Government Sales Tax, as it is flat through the first
quarter, and we expect a growth rate of 3.2%, although April and May indicate that this important
revenue is back on an upward trend. No category received a "negative" designation. Overall, first
quarter results are as anticipated.
ITEM BUDGETED:
NA
STRATEGIC PRIORITY: Public Trust and Accountability
APPROVED FOR SUBMITTAL:
Interim City Manager
STAFF RECOMMENDATION:
Accept Report
BOARD/COMMITTEE RECOMMENDATION:
ATTACHMENTS:
Description Upload Date
0 2016 1st Qtr Budget Report 5/26/2016
Type
Cover Memo
MEMORANDUM
June 2, 2016
TO: The Honorable Mayor and
Members of the City Council
FROM: Jeff Cutter, Interim City Manager
Cindy Epperson, Director of Finance & Budget
SUBJECT: 2016 1st Quarter Financial Trend Monitoring Report
We are submitting for your review the City of Yakima's 2016 1st 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
General Fund
Revenues
Expenditures
Other Funds
Top 10 Capital Projects
Exhibits
Operating/Enterprise Funds (1)
Capital Funds (1)
Reserve, Trust & Agency Funds (1)
Bond Redemption Funds (1)
STATUS PAGE
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
Legend:
Revenues exceed budget >5%, Expenditures below budget >5%
Revenues exceed budget <5%, Expenditures below budget <5%
Revenues below budget between 3-5%
Revenues below budget >5%
(1) These funds are graded on a Net Revenue measurement.
2-5
2/6-7
8 -9
10
11
12
13
14
POSITIVE
NORMAL
WARNING
NEGATIVE
Yakima.7047.1.FIN_Report_1 st_Qtr_2016.docx 1 of 14
CITY WIDE OVERVIEW
REVENUE COMPARISON
(Budget vs. Actual)
General
Parks and Recreation
Street & Traffic Operations
General Government Subtotal
Operating/Enterprise Funds
Capital Funds
G.O. Bond Redemption Funds
Utility Revenue Bond Redemption Funds
Employee Benefit Reserves
Operating Reserves
Trust and Agency Funds
Total
General
Parks and Recreation
Street & Traffic Operations
General Government Subtotal
2015
2016
Percent Amended
Actual Rec'd Budget
$ 13,471,307 22.1% $ 62,702,510
700,801 12.8% 5,510,965
552,175 11.7% 5,059,850
14,724,283 20.7%
14,355,466
3,380,498
1,749,026
774,753
2,709,901
3,173,051
630,111
$ 41,497,089
20.4%
10.0%
37.2%
36.3%
21.7%
86.1%
101.6%
20.9%
73,273,325
72,583,371
46,644,571
4,815,142
2,131,180
13,120,340
4,894,000
626,777
$ 218,088,706
EXPENDITURE COMPARISON
(Budget vs. Actual)
Operating/Enterprise Funds
Capital Funds
G.O. Bond Redemption Funds
Utility Revenue Bond Redemption Funds
Employee Benefit Reserves
Operating Reserves
Trust and Agency Funds
Total
2015
Percent
Actual Rec'd
$ 13,557,614 21.6%
781,852 14.2%
590,872 11.7%
14,930,338 20.4%
15,085,743 20.8%
4,271,815 9.2%
1,224,549 25.4%
612,473 28.7%
2,963,101 22.6%
1,734,406 35.4%
667,487 106.5%
$ 41,489,912 19.0%
2016
Percent
Actual Spent
$ 14,885,342
985,601
1,296,346
17,167,289
16,840,290
2,858,353
94,307
93,871
3,005,255
1,958,309
219,579
$ 42,237,253
24.4%
18.2%
25.7%
24.0%
23.1%
7.0%
2.0%
4.4%
23.4%
52.7%
35.5%
20.2%
Amended
Budget
$ 62,702,391
5,468,072
5,090,088
73,260,551
Percent
Actual Spent
73,893,343
61,229,417
4,808,964
2,129,054
13,398,134
4,901,505
617,777
$ 234,238,745
$ 14,562,331
1,002,590
1,579,946
17,144,867
15,145, 340
1,790,878
94,307
91,271
3,113,176
1,765,620
247,394
$ 39,392,853
23.2%
18.3%
31.0%
23.4%
20.5%
2.9%
2.0%
4.3%
23.2%
36.0%
40.0%
16.8%
Yakima.7047.1.FIN_Report_1 st_Qtr_2016.docx 2 of 14
GENERAL GOVERNMENT REVENUE ANALYSIS
GENERAL GOVERNMENT REVENUES
2016
Revenues through 3/31 Amended Percent
2014 2015 2016 Budget Receipted Status
General Sales Tax $ 3,558,005 $ 3,772,717 $ 3,764,550 $16,650,400 22.6%
Crim. Justice Sales Tax 741,209 791,084 780,949 3,361,500 23.2%
Property Tax 1,399,117 1,266,620 1,340,836 16,653,030 8.1%
Utility & Franchise Taxes 4,489,623 4,078,379 4,199,373 16,278,300 25.8%
Charges for Services 1,506,659 2,002,801 1,916,037 8,718,028 22.0%
State Shared Revenue 752,128 674,582 740,163 3,001,800 24.7%
Other Intergovernmental 318,688 362,598 383,102 1,705,237 22.5%
Fines and Forfeitures 393,164 459,739 488,465 1,707,110 28.6%
Other Taxes 669,716 641,845 580,119 1,535,000 37.8%
Transfers from other Funds 317,999 298,152 362,500 1,450,000 25.0%
Licenses and Permits 196,160 231,799 227,703 916,470 24.8%
Other Revenue 124,881 143,967 146,541 1,296,450 11.3%
Total Revenue 14,467,349 14,724,283 14,930,338 73,273,325 20.4%
Beginning Fund Balance 10,883,753 9,412,400 7,152,826 7,152,826
Total Resources $25,351,102 $24,136,683 $ 22,083,164 $80,426,151 27.5%
WARNING
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
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 is still running slightly below
the prior year, although April and May have turned back up so that through the five months ending in
May, we are 2.1% ahead of 2015 year to date for the same time period. This deficiency was noted and
addressed in a report of Budget Reductions that went to Council on April 5, 2016. The modified budget
estimate is $16,271,000--$379,400 or 2.3% below the budgeted $16,650,400, which is why this category
received a "warning" designation. The new estimate is 3.2% 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 rate in the years
2012-2014. Since our economy is closely tied to the agricultural sector, the wet winter would indicate that
the threat of extreme drought is over, and the two recent sales tax receipts (i.e. April and May) would
indicate an upturn in the economy. In looking at 1st quarter data from the Employment Security
Department, 1st quarter 2016 year -over -year job growth was 2.6% --in comparison, the 3rd and 4th quarters of
2015 experienced year -over -year job growth of only 1.1% in each quarter. This job growth would also
preliminarily indicate 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.
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 first quarter receipts are typically below 10%
of the annual budget. The budget is set based on assumptions of new construction and collection rates—the
Yakima.7047.1.FIN_Report_1st_Qtr_2016.docx 3 of 14
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 3% growth over the
prior year at the end of the 1st quarter, and is slightly above the 25% mark through this time frame.
Contributing factors for this category includes weather conditions through the first three 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, so this category overall is expected to approximate budgeted amounts by year end.
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 negative variance is a timing difference, and considered normal.
Other Intergovernmental — The grants for both Air Service promotion and SAFER (i.e. firefighter hiring)
have not been billed for 1st quarter activity, 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 60% of this one category has been collected by March 31. 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.
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 are in
process 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 $206,000 or 1.4% over 2015, and we anticipate year end to meet the
budget within the 3% range which maintains the "normal" ranking.
Yakima.7047.1.FIN_Report_1st_Qtr_2016.docx 4 of 14
GENERAL GOVERNMENT REVENUES - By Month
2014 2015 2016
Jan $ 4,775,515 $ 4,497,985 $ 5,028,023
Feb 4,770,901 4,721,588 5,025,995
Mar 4,984,701 5,504,709 4,876,321
Apr 10,717,557 11,332,602
May 4,573,329 4,855,896 -
Jun 4,307,587 3,922,536 -
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,725,197
$67,382,676 $70,291,082 $14,930,339
$12,500,000
$10,000,000
$7,500,000
$5,000,000
$2,500,000
$-
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
■ 2014
■ 2015
■ 2016
GENERAL GOVERNMENT REVENUES - Cumulative By Month
2014 2015 2016
Jan $ 4,775,515 $ 4,497,985 $ 5,028,023
Feb 9,546,416 9,219,573 10,054,018
Mar 14,531,117 14,724,282 14,930,339
Apr 25,248,674 26,056,884
May 29,822,003 30,912,780 -
Jun 34,129,590 34,835,316 -
Jul 38,433,642 39,439,474 -
Aug 42,724,613 44,076,120 -
Sep 47,905,417 49,160,291 -
Oct 57,796,790 59,783,771 -
Nov 62,191,951 64,565,885 -
Dec 67,382,676 70,291,082 -
$80,000,000
$60,000,000
$40,000,000
$20,000,000
$
MI
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
■ 2014
■ 2015
■ 2016
Yakima.7047.1.FIN_Report_1st_Qtr_2016.docx 5 of 14
GENERAL FUND EXPENDITURE ANALYSIS
GENERAL GOVERNMENT EXPENDITURES
2016 Proposed
Expenditures through 3/31 Amended Percent Budget
2014 2015 2016 Budget Spent Reduction
Police $ 6,046,982 $ 6,096,797 $ 5,857,259 $27,327,133 21.4% $ (182,000)
Fire 2,441,800 2,901,427 2,874,676 12,310,596 23.4% (62,000)
Transfers To Other Funds 1,101,817 1,286,667 1,186,060 4,839,545 24.5%
Information Technology 633,435 908,799 907,652 3,113,902 29.1%
Code Administration 1,466,015 377,698 410,546 1,839,575 22.3%
Utility Services 351,090 408,411 339,434 1,691,074 20.1%
Legal 301,208 361,861 355,390 1,645,037 21.6% (64,600)
Financial Services 383,956 358,697 353,023 1,529,538 23.1%
Municipal Court 316,214 289,437 329,101 1,427,119 23.1%
Police Pension 315,635 291,673 275,945 1,104,060 25.0%
Indigent Defense 155,451 226,274 232,231 935,500 24.8%
Economic Development 108,297 89,432 105,159 888,891 11.8% (91,700)
Engineering 168,335 194,456 169,761 833,710 20.4% (60,000)
Planning 98,287 124,855 136,909 652,548 21.0% -
Records / City Clerk 301,609 229,139 309,144 652,086 47.4% (5,000)
Human Resources 125,132 134,626 155,116 648,774 23.9% (17,000)
Purchasing 136,113 147,263 148,234 630,092 23.5%
City Hall Facility 190,957 211,470 155,348 505,447 30.7%
City Manager 96,653 109,754 118,929 418,138 28.4% (5,000)
City Council 114,103 109,409 113,409 285,340 39.7% (34,000)
Neighborhood Partnerships - - - 206,735 n/a (206,735)
Intergovernmental 65,237 22,988 29,005 189,551 15.3%
State Examiner - 4,209 - 113,000 0.0%
Gang Free / Emer Mgmt 19,490 - - - n/a
Position Vacancy Savings - - - (1,085,000) 0.0%
Total General Fund 14,937,816 14,885,342 14,562,331 62,702,391 23.2% (728,035)
Parks & Recreation Fund 998,999 985,601 1,002,590 5,468,072 18.3%
Street & Traffic Ops. 1,398,571 1,296,346 1,579,946 5,090,088 31.0%
Total General Government $17,335,386 $17,167,289 $17,144,867 $73,260,551 23.4% $ (728,035)
Total General Government Fund Expenditures - 1.6% Below 25%
Status
1
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
II NORMAL
NORMAL
WARNING
NORMAL
NORMAL
Note: The "normal" designation is comparing to the budget after the budget reduction porposals are removed.
Yakima.7047.1.FIN_Report_1 st_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 in the first quarter. For example, half of the 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 quarter, 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 personnel — 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
➢ Information Technology — Annual maintenance for various computer software systems, including
the annual YAKCORPS assessment, is paid in the first quarter.
➢ Utility Services — This budget includes additional costs related to the new utility billing system
implementation. We anticipate using the additional overtime, temporary salaries and system
maintenance expenses in the 2nd and 3rd quarters.
➢ 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.
➢ Economic Development — This division is under budget through the end of the first quarter because
of the seasonal nature of the events.
➢ 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 quarter - $69,500.
➢ 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 2nd quarter of the year.
➢ 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 summer.
Position Vacancy Savings — Shown for fund total purposes only — no "actual" will be charged here.
Yakima.7047.1.FIN_Report_1st_Qtr_2016.docx 7 of 14
OTHER FUNDS ANALYSIS
Operating/Enterprise Funds
Capital Funds
Reserve, Trust & Agency Funds
Bond Redemption Funds
Total Revenue
Beginning Fund Balance
Total Resources
OTHER FUNDS REVENUES
Revenues through 3/31
2014
2015 2016
2016
Amended Percent
Budget Rec'd Status
$ 15,367,589
7,266,896
5,958,130
1,835,056
30,427,671
51,645,155
$ 82,072,826
$ 14,355,466 $ 15,085,743
3,380,498 4,271,815
6,513,063 5,364,994
2,523,779 1,837,022
26,772,806 26,559,574
51,022,832 61,807,854
$ 77,795,638 $ 88,367,428
OTHER FUNDS EXPENDITURES
Expenditures through 3/31
2014 2015 2016
$ 72,583,371
46,644,571
18,641,117
6,946,322
144,815,381
61,807,854
$ 206,623,235
20.8%
9.2%
28.8%
26.4%
18.3%
42.8%
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
2016
Amended Percent
Budget Rec'd Status
Operating/Enterprise Funds $ 16,524,842 $ 16,840,290
Capital Funds 7,806,690 2,858,353
Reserve, Trust & Agency Funds 4,706,761 5,183,143
Bond Redemption Funds 190,371 188,178
Total Expenditures $ 29,228,664 $ 25,069,964
$ 15,145,340
1,790,878
5,126,190
185,578
$ 22,247,986
$ 73,893,343
61,229,417
18,917,416
6,938,018
$160,978,194
20.5%
2.9%
27.1%
2.7%
13.8%
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
First 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 Emergency Management Fund relies on a property tax based levy for its revenue, so its revenue is less
than 10% received, and even though expenses are only at 21.6% of budget through the end of the 1st quarter,
there is temporarily a minimum fund balance until half of the property tax is collected in April. This is
normal for this fund at this time of year. The Stormwater utility is also included on the property tax bill, so
its revenue collection is tied to the property tax collection schedule. Hotel/Motel tax is historically lowest in
the 1st quarter of the year, which affects revenue in the Convention Center and Tourist Promotion Area
funds.
Yakima.7047.1.FIN_Report_1st_Qtr_2016.docx 8 of 14
The Public Safety Communications Fund used fund balance in 2015 to furnish the new call center. An
interfund loan was made from Equipment Rental fund, however, according to accounting rules an
interfund loan cannot create "revenue", so this fund will have a negative fund balance until that loan can be
repaid. Even though this will create a negative fund balance anomaly, an interfund loan is still the most
cost effective way to borrow small sums.
The ONDS fund's budget has many large projects that did not have much activity in the first quarter.
Similarly, the Environmental Fund budget includes a grant from the Department of Ecology to clean-up a
Tiger Oil site. This work was just getting started at the end of the first quarter. 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. Street projects require good weather
for asphalt. 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. The Airport taxi way project had their bid opening, and will be under way in the 2nd 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 half 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
virtually breaking even through the first quarter -- the cost containment measures are working to hold these
costs down. 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
negative revenue variance is a timing issue.
Revenues in Bond Redemption Funds are deposited/transferred ratably throughout the year, but the bulk
of debt service payments are made in the second and last quarters.
Yakima.7047.1.FIN_Report_1st_Qtr_2016.docx 9 of 14
TOP 10 CAPITAL PROJECTS
These 10 projects represent about 58% of the total capital budgets:
Project Number/Description
Total Actual
2016 2016
Dept Budget Expended Funding Source
Expected
Completion
2376 Airport -Alpha Taxiway
Construction
2390 N 1st St Revitalization Phase II
2426 Road Improvements
2365 Beech St Interceptor Phase III
2406 SOZO Improvement & Land
Purchase Phase II
n/a Transit Bus Replacement (7)
(on order)
2405 Yakima Central Plaza Phase II
AP $10,120,000 $ 30,293 FAA Grant
Passenger Facility Charges
ST 6,855,000
ST 5,000,000
WW 4,000,000
PK 3,350,000
TR 3,094,000
CBD 2,800,000
1,790,000
W 1,200,000
F 1,150,000
TBD N 1st St Revitalization - Stormwater SW
2391 N 1st St Revitalization -
Water Main Replacement
n/a Fire ladder truck replacement
(on order)
Department Legend:
AP - Airport
CBD - Central Business District
WW - Wastewater Capital
SW - Stormwater
W - Water Capital
$39,359,000
FY2016
82,816 Street Capital Reserves FY 2016/17
State Grant, $6m LTGO Bond
- LTGO Bond
- Charges for Services
Capital Reserves
285,899 LTGO Bond (carryover)
- Transit Sales Tax, Capital
Reserves, WSDOT Grant
246,620 Community Donations,
LTGO Bonds
- Charges for Services
Capital Reserves
- Charges for Services
Capital Reserves
- Fire Capital Reserves,
State LOCAL lease program
ST - Street Improvement
TR - Transit
F - Fire Capital
PK - Parks Capital
FY 2016/17
FY 2016/17
FY2016
FY 2016
FY 2016
FY 2016/17
FY 2016/17
FY 2015/16
Yakima.7047.1.FIN_Report_1st_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 $ 40,454 22.1% $ 198,071 $ 26,703 13.5% $ 90,172
Neighborhood Development 897,054 3,338,886 128,415 3.8% 3,349,462 199,302 6.0% 826,167
Community Relations 657,412 666,600 200 0.0% 618,913 137,486 22.2% 520,126
Cemetery 37,538 262,950 64,570 24.6% 273,542 63,175 23.1% 38,933
Emergency Services 203,162 1,326,026 115,602 8.7% 1,407,117 304,868 21.7% 13,896
Public Safety Communicatic (361,269) 3,499,468 1,019,664 29.1% 3,563,096 832,672 23.4% (174,277)
Police Grants 371,378 416,000 60,730 14.6% 369,716 42,311 11.4% 389,797
P.B.I.A. (Parking & Bus Impr; (4,561) 205,340 75,010 36.5% 208,993 16,966 8.1% 53,483
Trolley 73,180 91,433 1,275 1.4% 164,855 388 0.2% 74,067
Front Street Bus Impr Area 4,679 3,735 4,419 118.3% 10,279 6,094 59.3% 3,004
Cony Center (Tourist Promo 528,261 1,683,800 285,128 16.9% 1,694,510 407,135 24.0% 406,254
Capitol Theatre 26,567 414,700 102,755 24.8% 420,497 111,458 26.5% 17,864
PFD- Convention Center 514,586 828,750 213,231 25.7% 727,720 181,102 24.9% 546,715
Tourism Promotion Area 80,822 687,000 111,937 16.3% 687,000 43,742 6.4% 149,017
PFD- Capitol Theatre 166,911 624,800 161,500 25.8% 630,883 157,142 24.9% 171,269
Airport Operating 46,313 1,134,929 281,675 24.8% 1,128,985 274,688 24.3% 53,300
Stormwater Operating 694,688 2,151,000 301,003 14.0% 2,638,104 686,644 26.0% 309,047
Transit Operating 1,954,958 8,701,402 1,709,021 19.6% 8,368,765 1,856,325 22.2% 1,807,654
Refuse 59,564 6,595,262 1,497,339 22.7% 6,452,485 1,442,694 22.4% 114,209
Wastewater Operating 4,309,330 22,102,484 5,252,912 23.8% 22,540,390 4,872,542 21.6% 4,689,700
Water Operating 3,130,380 8,816,000 1,727,205 19.6% 9,373,857 1,835,641 19.6% 3,021,944
Irrigation 897,427 1,803,540 507,439 28.1% 1,802,149 503,219 27.9% 901,647
Equipment Rental 4,057,425 4,722,942 1,094,676 23.2% 4,765,532 788,649 16.5% 4,363,452
Environmental 565,281 1,180,000 43,752 3.7% 1,247,950 22,320 1.8% 586,713
Public Works Admin. 484,256 1,143,324 285,831 25.0% 1,250,472 332,074 26.6% 438,013
Total Other Operating Funds $19,471,763 $ 72,583,371 $ 15,085,743 20.8% $ 73,893,343 $ 15,145,340 20.5% $ 19,412,166
Yakima.7047.1.FIN_Report_1st_Qtr_2016.docx 11 of 14
Fund
CAPITAL IMPROVEMENT FUNDS
Actual
Revenues
Appropriations
Beg Bal Amended
01/01/16 Budget
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
$ 1,281,875
(23,298)
248,750
701,125
3,810,256
36,925
740,305
1,171,476
352,961
94,164
585,025
1,617,047
795,550
3,044,907
4,464,872
10,256,929
4,010,943
1,503,177
$ 10,397,841
2,826,220
66,641
1,000,000
508,400
2,242,410
479,350
802,000
802,000
5,095,306
360,400
300,000
11,325,568
700,000
3,849,875
3,501,500
1,000,000
1,387,060
$ 34,692,989 $ 46,644,571
Actual % Amended Actual
Revenue Rec'd Budget Exp
$ 149,070 1.4% $ 10,737,025 $ 176,287
407,080 n/a 2,881,000 250,112
16,660 n/a 70,000 -
1,005,667 100.6% 1,500,000 199,391
63,674 n/a 5,174,049 320,848
38,631 1.7% 2,239,976 11,832
115,319 24.1% 693,000 66,835
179,997 22.4% 1,011,385 85,709
179,997 22.4% 978,250 125,985
5,192 0.1% 5,000,000 167
89,975 25.0% 385,000 7,509
0.0% 765,000 90,063
106,136 0.9% 11,645,247 30,293
275,000 39.3% 2,400,000 525
377,471 9.8% 4,334,205 127,366
926,617 26.5% 7,790,000 75,160
0.0% 2,257,738 29,083
335,329 24.2% 1,367,542 193,713
$ 4,271,815 9.2% $ 61,229,417 $ 1,790,878
Exhibit II
Ending
% Balance
Exp'd 12/31/16
1.6% $ 1,254,658
8.7% 133,670
n/a 265,410
13.3% 1,507,401
6.2% 3,553,082
0.5% 63,724
9.6% 788,789
8.5% 1,265,764
12.9% 406,973
n/a 99,189
2.0% 667,491
11.8% 1,526,984
0.3% 871,393
0.0% 3,319,382
2.9% 4,714,977
1.0% 11,108,386
1.3% 3,981,860
14.2% 1,644,793
2.9% $ 37,173,926
Yakima.7047.1.FIN_Report_1st_Qtr_2016.docx 12 of 14
Fund
Exhibit III
RESERVE AND OTHER FUNDS
Actual Revenues Appropriations Ending
Beg Bal Amended Actual % Amended Actual % Balance
01/01/16 Budget Revenue Rec'd Budget Exp Exp'd 12/31/16
Employee Benefit Reserves
Unemployment Comp Res $ 441,244 $ 197,000 $ 50,020 25.4% $ 227,351 $ 18,048 7.9% $ 473,216
Employees Health Ben Res 1,616,969 10,407,500 2,553,614 24.5% 10,388,338 2,533,696 24.4% 1,636,887
Worker's Compensation Res 734,214 1,069,780 269,023 25.1% 1,311,017 189,927 14.5% 813,310
Wellness/EAP 127,185 121,800 - 0.0% 121,800 11,651 9.6% 115,534
Firemens' Relief and Pension 1,019,850 1,324,260 90,444 6.8% 1,349,628 359,854 26.7% 750,440
Total Employee Ben Reserve $ 3,939,462 $13,120,340 $ 2,963,101 22.6% $13,398,134 $ 3,113,176 23.2% $ 3,789,387
Operating Reserves
Capitol Theatre Reserve $ 36,641 $ - $ - n/a $ 36,641 $ 9,160 25.0% $ 27,481
Risk Management Reserve 733,243 4,894,000 1,734,406 35.4% 4,864,864 1,756,460 36.1% 711,189
Total Operating Reserve $ 769,884 $ 4,894,000 $ 1,734,406 35.4% $ 4,901,505 $ 1,765,620 36.0% $ 738,670
Trust and Agency Funds
Cemetery Trust $ 647,731 $ 21,000 $ 2,872 13.7% $ 12,000 $ - 0.0% $ 650,603
Agency Fund-YAKCORPS - 605,777 664,615 109.7% 605,777 247,394 40.8% 417,221
Total Other Funds $ 647,731 $ 626,777 $ 667,487 106.5% $ 617,777 $ 247,394 40.0% $ 1,067,824
Yakima.7047.1.FIN_Report_1st_Qtr_2016.docx 13 of 14
Fund
Exhibit IV
BOND REDEMPTIONS FUNDS
Actual Revenues Appropriations Ending
Beg Bal Amended Actual % Amended Actual % Balance
01/01/16 Budget Revenue Rec'd Budget Exp Exp'd 12/31/16
GO Bond Redemption
LID Guaranty
2002 GO Convention Center
2005 GO Various Bonds
1996 GO LTD - Conv Center
LID Debt Service Control
Total G.O. Bond Redemption
Water/Sewer Revenue Bond Redemption
Water Rev Bonds &Debt Service
WW Rev Bond & 2008 Debt Service
Irrigation Bond Debt Service
WW Rev Bond Reserve & 2012 Debt Svc
Total W/S Rev Bond Red
$ 25,329 $ 50 $ - 0.0% $ - $ - n/a $ 25,329
163,591 1,026,103 231,150 22.5% 1,024,025 - 0.0% 394,741
8,734 3,312,239 891,159 26.9% 3,312,239 94,307 2.8% 805,586
69,030 428,750 66,025 15.4% 424,700 - 0.0% 135,055
48,000 36,215 75.4% 48,000 - 0.0% 36,215
$ 266,684 $ 4,815,142 $1,224,549 25.4% $ 4,808,964 $ 94,307 2.0% $1,396,926
366,380 235,125 59,425 25.3% 234,700 - 0.0% 425,805
411,813 102,853 25.0% 411,813 - 0.0% 102,853
34,813 317,542 158,870 50.0% 317,541 91,271 28.7% 102,412
1,618,148 1,166,700 291,325 25.0% 1,165,000 - 0.0% 1,909,473
$2,019,341 $2,131,180 $ 612,473 28.7% $2,129,054 $ 91,271 4.3% $2,540,543
Yakima.7047.1.FIN_Report_1st_Qtr_2016.docx 14 of 14