HomeMy WebLinkAbout08/18/2015 05D 2nd Quarter Financial Trend Monitoring SystemITEM TITLE:
SUBMITTED BY:
SUMMARY EXPLANATION:
'1111111 1,
nun 11,1:1141r10
BUSINESS OF THE CITY COUNCIL
YAKIMA, WASHINGTON
AGENDA STATEMENT
Item No. S.D.
For Meeting of: August 18, 2015
2nd Quarter Financial Trend Monitoring System
Cindy Epperson, Director of Finance & Budget
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.
At the end of the second quarter 2015, we are seeing typical variances tied to timing --such as annual
dues/assessments. 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. It is not typical for this category to go down in a year over year comparison through the
first half of the year. However, since it has it is likely that it will be between 3%-5% below its budget by year
end. Sales tax growth has also slowed, but it is anticipated to be between 1%-2% below the 2015 budget. No
categories received a "negative" designation.
As part of developing the 2016 budget, the 2015 actual results are being compared to budget, and there are
areas that will require an appropriation. Examples include new grant awards and retirement cashouts. We
expect to come to Council for the first reading of an appropriation in the near future.
Overall, first quarter results are as anticipated. Because of the slowdown in utility and sales tax revenues,
management is reviewing General Government Funds for potential cost containment measures, which will be
identified as we develop the 2016 budget.
Resolution: Ordinance:
Other (Specify): Report
Contract: Contract Term:
Start Date: End Date:
Item Budgeted: Amount:
Funding Source/Fiscal Impact:
Strategic Priority: Public Trust and Accountability
Insurance Required? No
Mail to:
Phone:
APPROVED FOR
SUBMITTAL:
RECOMMENDATION:
Accept Report
ATTACHMENTS:
Description
D 2nd Otr 2015 IBudget Report
City Manager
Upload Date
8/12/2015
Type
Omer Memo
MEMORANDUM
August 13, 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 2nd Quarter Financial Trend Monitoring Report
We are submitting for your review the City of Yakima's 2015 2nd Quarter actual compared to
budgeted Revenue and Expenditure Report for all city funds.
Overall, the City budget is performing as expected. We are currently in the process 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 appears to be responding negatively to drought conditions, so
2015 revenue estimates are being lowered as we put together the 2016 budget. Very
preliminary estimates show potential savings in expenditures that roughly match the reduced
revenues, so the total General Government Fund Balance may not be greatly impacted in total.
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
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.
FIN Report 2nd Qtr 2015 ce.docx
2-5
2/6-7
8-9
10
11
12
13
14
POS LTIVE
NORMAL
WARNING
NEGATIVE
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
2014
2015
Percent
Actual Rec'd
$ 29,559,654 51.8%
2,217,827 50.9%
2,352,112 50.8%
34,129,593 51.7%
31,826,425
27,083,556
1,645,229
780,495
5,743,540
2,841,239
552,385
$104,602,462
49.0%
50.9%
34.1%
36.4%
48.6%
84.5%
88.4%
50.5%
Amended
Budget
$ 61,333,941
5,459,455
4,718,610
71,512,006
Percent
Actual Rec'd
72,434,292
33,924,773
4,700,411
2,134,280
12,509,688
3,684,000
620,277
$ 201,519,727
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
2014
$ 30,121,613
2,718,209
2,539,208
35,379,030
32,489,407
5,537,720
2,853,968
774,753
6,046,520
3,212,786
639,339
$ 86,933,523
2015
49.1%
49.8%
53.8%
49.5%
44.9%
16.3%
60.7%
36.3%
48.3%
87.2%
103.1%
43.1%
Actual
$ 29,121,062
2,146,848
2,681,439
33,949,349
30,465,242
16,410,223
1,268,448
369,892
6,731,905
1,786,287
183,787
$ 91,165,133
Percent
Spent
49.9%
48.1%
54.2%
50.1%
44.4%
25.3%
24.1%
17.2%
52.8%
53.0%
29.5%
40.4%
Amended
Budget
$ 61,281,678
5,425,527
5,076,756
71,783,961
74,419,322
44,306,451
4,709,429
2,132,155
12,865,239
3,715,631
617,777
$ 214,549,965
Percent
Actual Spent
$30,677,926 50.1%
2,549,187 47.0%
2,341,307 46.1%
35,568,420 49.5%
31,711,241
5,696,591
2,597,144
348,577
6,464,216
2,758,007
472,440
$ 85,616,636
42.6%
12.9%
55.1%
16.3%
50.2%
74.2%
76.5%
39.9%
FIN Report 2nd Qtr 2015 ce.docx 2 of 14
GENERAL GOVERNMENT REVENUE ANALYSIS
GENERAL GOVERNMENT REVENUES
2015
Revenues through 6/30 Amended Percent
2013 2014 2015 Budget Receipted Status
General Sales Tax $ 6,952,180 $ 7,236,681 $ 7,520,655 $ 16,020,000 46.9%
Crim. Justice Sales Tax 1,398,434 1,496,667 1,567,934 3,205,350 48.9%
Property Tax 8,612,036 8,789,196 9,123,719 16,336,390 55.8%
Utility & Franchise Taxes 7,151,868 8,123,940 7,688,398 16,783,695 45.8%
Charges for Services 3,171,816 3,252,345 4,055,352 8,134,483 49.9%
State Shared Revenue 1,203,760 1,462,966 1,345,709 2,836,880 47.4%
Other Intergovemmental 753,784 700,272 943,918 1,629,520 57.9%
Fines and Forfeitures 815,955 765,276 837,683 1,645,110 50.9%
Other Taxes 977,332 962,810 909,565 1,429,000 63.7%
Transfers from other Funds 579,783 648,986 639,855 1,505,000 42.5%
Licenses and Permits 386,930 373,827 413,128 857,900 48.2%
Other Revenue 271,575 316,627 333,114 1,128,678 29.5%
Total Revenue 32,275,453 34,129,593 35,379,030 71,512,006 49.5%
Beginning Fund Balance 10,908,094 10,883,753 9,411,120 9,411,120
Total Resources $ 43,183,547 $ 45,013,346 $ 44,790,150 $ 80,923,126 55.3%
NORMAL
NORMAL
NORMAL
WARNING
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
Sales Tax - This important revenue source continued grow above 2014 levels. Through the second quarter
of 2015, sales tax is 3.9% more than the prior year. However, through the seven months ending in July, we
are 3.4% 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 second half 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, so we are estimating sales tax to remain relatively flat through the
end of the year. Fortunately, Building Permit activity is ahead of prior year, and this is a pre -cursor to
construction sales tax. Looking at these underlying economic factors, this revenue is being reduced by
approximately $340,000 for the 2015 estimate.
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 $435,542 or 5.3% from the first half of 2014,
and the actual is 45.8%, 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 mild weather conditions
FIN Report 2nd Qtr 2015 ce.docx 3 of 14
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 $750,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 negative 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 $600,000 to the first quarter 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 3.7% 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.
FIN Report 2nd Qtr 2015 ce.docx 4 of 14
GENERAL GOVERNMENT REVENUES - By Month
$10,000,000
$7,500,000
$5,000,000
$2,500,000
$-
2013 2014 2015
Jan $ 4,451,264 $ 4,775,515 $ 4,516,085
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,330,918
May 4,733,408 4,573,329 4,855,486
Jun 4,168,515 4,307,587 4,259,390
Jul 3,962,439 4,304,052
Aug 3,798,660 4,290,971
Sep 4,758,660 5,180,804
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 $ 35,188,176
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
GENERAL GOVERNMENT REVENUES - Cumulative By Month
$60,000,000
$40,000,000
$20,000,000
2013 2014 2015
Jan $ 4,451,264 $ 4,775,515 $ 4,516,085
Feb 8,718,900 9,546,416 9,237,673
Mar 13,615,483 14,531,117 14,742,382
Apr 23,373,766 25,248,674 26,073,300
May 28,107,174 29,822,003 30,928,786
Jun 32,275,689 34,129,590 35,188,176
Jul 36,238,128 38,433,642
Aug 40,036,788 42,724,613
Sep 44,795,448 47,905,417
Oct 54,865,479 57,796,790
Nov 58,871,889 62,191,951
Dec 63,513,321 67,382,676
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
FIN Report 2nd Qtr 2015 ce.docx 5 of 14
GENERAL FUND EXPENDITURE ANALYSIS
GENERAL GOVERNMENT EXPENDITURES
2015
Expenditures through 6/30 Amended Percent
2013 2014 2015 Budget Spent
Police $12,293,943 $12,982,772 $13,106,486 $ 26,638,098 49.2%
Fire 4,816,992 5,172,980 5,914,033 11,847,472 49.9%
Transfers To Other Funds 1,183,747 1,265,088 2,365,607 4,793,875 49.3%
Information Technology 1,158,164 1,512,453 1,688,625 3,062,977 55.1%
Code Administration 633,491 1,859,643 773,153 1,682,327 46.0%
Financial Services 742,653 759,079 821,623 1,605,263 51.2%
Municipal Court 647,680 619,742 623,799 1,395,989 44.7%
Utility Services 673,041 687,313 763,535 1,555,520 49.1%
Police Pension 698,456 604,553 570,208 1,167,200 48.9%
Legal 589,371 640,315 736,505 1,525,072 48.3%
Engineering 362,383 336,713 385,158 890,530 43.3%
Indigent Defense 244,522 306,569 454,335 1,000,500 45.4%
Records / City Clerk 249,666 394,088 331,009 592,904 55.8%
Purchasing 266,606 280,687 301,906 654,699 46.1%
Human Resources 249,622 245,038 304,776 682,303 44.7%
Economic Development 297,992 291,149 411,398 702,329 58.6%
Planning 284,919 220,940 253,327 581,384 43.6%
City Hall Facility 225,552 270,835 306,675 523,868 58.5%
City Manager 210,841 187,762 207,423 389,578 53.2%
Gang Free / Emer Mgmt - 113,870 103,381 443,066 23.3%
City Council 161,524 171,443 163,159 286,735 56.9%
Intergovernmental 178,593 198,030 87,596 174,989 50.1%
State Examiner 6,019 - 4,209 110,000 3.8%
Position Vacancy Savings - - (1,025,000) 0.0%
Total General Fund 26,175,777 29,121,062 30,677,926 61,281,678 50.1% NORMAL
Status
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
Parks & Recreation Fund 1,902,372 2,146,848 2,549,187 5,425,527 47.0%
Street & Traffic Ops. 2,730,221 2,681,439 2,341,307 5,076,756 46.1%
Total General Government $ 30,808,370 $ 33,949,349 $ 35,568,420 $ 71,783,961 49.5%
Total General Government Fund Expenditures - 0.5% Below 50%
FIN Report 2nd Qtr 2015 ce.docx
NORMAL
NORMAL
NORMAL
NORMAL
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 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 half of the year, and pick up through the end of the year.
However, since the total General Government budget is about 68% 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 50% in first quarter, yet comparable to prior years—i.e. payment timing variance.
➢ Information Technology - Annual maintenance for various computer software systems is paid in
the first half of the year.
➢ Code Administration - 2014 Actual included the one-time $1.1 million purchase for the purchase of
4 Tiger Oil properties for environmental clean-up. 2015 percentage of budget spent is below the 50%
mark because of position vacancies.
➢ Municipal Court - Position vacancies and the timing of payments made to Yakima County for jury
selection make up the favorable variance.
➢ Records - Prior year election costs of $124,000 were paid in the first quarter.
➢ Economic Development - The start-up payment to the Downtown Association of Yakima (DAY) of
about $123,000 was made in the second quarter.
➢ City Hall Facility Maintenance - Annual transfer to Risk Management Fund to pay for property
insurance is made in the first quarter - $126,000.
➢ Gang Free Initiative/Emergency Management- This program is under budget at the end of the 2nd
quarter primarily because of position vacancies, and the timing of contract payments to service
providers. Although we anticipate this particular area will end up under budget by year end, this is
contributing to the position vacancy savings.
➢ City Council - Annual Association of Washington Cities (AWC) dues of $64,000 paid in the first
quarter.
➢ State Examiner - The annual audit does not get under way until the end of the 2nd quarter of the
year.
➢ Position Vacancy Savings - Shown for fund total purposes only - no "actual" will be charged here.
FIN Report 2nd Qtr 2015 ce.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
Operating/Enterprise Funds
Capital Funds
Reserve, Trust & Agency Funds
Bond Redemption Funds
Total Expenditures
OTHER FUNDS REVENUES
Revenues through 6/30
2013
2014 2015
2015
Amended Percent
Budget Rec'd Status
$ 31,622,328
12,418,028
10,172,705
2,666,875
56,879,936
47,394,784
$ 31,826,425 $ 32,489,407
27,083,556 5,537,720
9,137,164 9,898,645
2,425,724 3,628,721
70,472,869 51,554,493
51,645,155 54,790,426
$104,274,720 $122,118,024 $106,344,919
OTHER FUNDS EXPENDITURES
Expenditures through 6/30
$ 72,434,292
33,924,773
16,813,965
6,834,691
130,007,721
54,790,426
44.9%
16.3%
58.9%
53.1%
39.7%
$184,798,147 57.5%
2015
Amended
2013 2014 2015 Budget
$ 30,010,678 $ 30,465,242 $ 31,711,241 $ 74,419,322
12,363,865 16,410,223 5,696,591 44,306,451
7,270,808 8,701,979 9,694,663 17,198,647
1,523,925 1,638,340 2,945,721 6,841,584
$ 51,169,276 $ 57,215,784 $ 50,048,216 $142,766,004
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
Percent
Rec'd Status
42.6%
12.9%
56.4%
43.1%
35.1%
NORMAL
NORMAL
NORMAL
NORMAL
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 half of
the year, such as the contributions to Risk Management and Irrigation ditch charges.
➢ 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 will be included in an
appropriation.
➢ The Cemetery Fund experienced the retirement of a long-time employee, so this is over 50% spent,
with a low fund balance at this point in time. However, the position vacancy will make up some the
overage going forward. This fund will be evaluated to see if an appropriation and/or an additional
transfer from Parks Operations will be needed.
➢ The Airport Operating Fund purchased equipment in the first half of the year for about $56k, which
temporarily put this fund in a negative fund balance position of approximately ($20k), which will be
FIN Report 2nd Qtr 2015 ce.docx 8 of 14
remedied as revenues come in throughout the rest of the year. The Airport Capital Fund has a
balance of about $736k, which covers the shortage for this enterprise until it corrects itself.
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 in preliminary stages at this point in time, so the total spent at the
halfway mark of the year is just 12.9% of the budget. A listing of the top ten budgeted projects and their
annual expenditures through the second quarter follow.
Reserve Funds are 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
over the 50% 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.
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.
FIN Report 2nd Qtr 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 Expected
Project Number/Description Dept Budget Expended Funding Source Completion
2376 Airport -Alpha Taxiway AP $10,090,644 $ 19,852 FAA Grant FY2015/16
Construction Passenger Facility Charges
2402 LIFT Area Roundabout LF 2,600,000 299,220 LIFT Sales tax credit, County FY 2015
Fair Avenue SIFD 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 56,010 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 183,351 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
TBD Randall Park improvements PK 900,000 19,682 RCO Grant, Parks Capital , FY 2015
community donations
$ 23,704,224
FIN Report 2nd Qtr 2015 ce.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/15 Budget Revenue Rec'd Budget Exp Exp'd 12/31/15
Economic Development $ 85,432 $ 222,000 $ 115,449 52.0% $ 260,766 $ 84,918 32.6% $ 115,963
Neighborhood Development 830,030 3,368,256 470,477 14.0% 3,373,107 578,580 17.2% 721,927
Community Relations 603,473 596,600 338,438 56.7% 674,823 321,254 47.6% 620,657
Cemetery 56,376 264,950 114,964 43.4% 291,709 163,834 56.2% 7,506
Emergency Services 208,306 1,290,026 734,138 56.9% 1,312,692 583,834 44.5% 358,610
Public Safety Communication 871,526 4,095,799 1,458,188 35.6% 4,506,862 1,930,188 42.8% 399,526
Police Grants 174,736 484,000 143,298 29.6% 475,296 74,938 15.8% 243,096
P.B.I.A. (Parking & Bus Impr) 12,408 197,840 87,904 44.4% 202,172 92,403 45.7% 7,909
Trolley 97,884 293,624 181,275 61.7% 368,961 205,980 55.8% 73,179
Front Street Bus Impr Area 6,099 3,735 2,368 63.4% 7,000 2,421 34.6% 6,046
Cony Center (Tourist Promo) 540,514 1,674,250 695,270 41.5% 1,609,854 793,261 49.3% 442,523
Capitol Theatre 27,259 395,250 197,175 49.9% 397,290 212,618 53.5% 11,816
PFD- Convention Center 421,225 816,750 401,483 49.2% 748,220 363,814 48.6% 458,894
Tourism Promotion Area 79,626 687,000 262,028 38.1% 687,000 262,028 38.1% 79,626
PFD- Capitol Theatre 176,423 618,700 304,336 49.2% 640,220 318,314 49.7% 162,445
Airport Operating 8,539 1,108,889 515,282 46.5% 1,102,006 544,125 49.4% (20,304)
Stormwater Operating 1,411,055 2,151,000 1,699,779 79.0% 3,353,229 650,710 19.4% 2,460,124
Transit Operating 981,775 8,519,226 3,801,222 44.6% 8,615,247 3,833,321 44.5% 949,676
Refuse 370,465 5,834,599 2,849,223 48.8% 5,877,188 2,738,802 46.6% 480,886
Wastewater Operating 4,144,825 21,431,302 10,648,864 49.7% 20,901,186 9,356,463 44.8% 5,437,226
Water Operating 3,274,367 8,876,000 3,859,843 43.5% 9,347,579 4,570,669 48.9% 2,563,541
Irrigation 851,179 1,766,200 946,694 53.6% 1,795,875 1,048,603 58.4% 749,270
Equipment Rental 4,263,021 5,612,858 1,562,434 27.8% 5,697,917 1,283,772 22.5% 4,541,683
Environmental 627,146 1,010,000 541,356 53.6% 1,007,950 1,125,429 111.7% 43,073
Public Works Admin. 509,733 1,115,438 557,919 50.0% 1,165,173 570,962 49.0% 496,690
Total Other Operating Funds $ 20,633,422 $ 72,434,292 $ 32,489,407 44.9% $ 74,419,322 $ 31,711,241 416% $ 21,411,588
FIN Report 2nd Qtr 2015 ce.docx 11 of 14
Exhibit II
CAPITAL IMPROVEMENT FUNDS
Actual Revenues Appropriations Ending
Beg Bal Amended Actual % Amended Actual % Balance
Fund 01/01/15 Budget Revenue Rec'd Budget Exp Exp'd 12/31/15
Arterial Street $ 1,367,320 $ 1,822,913 $ 352,916 19.4% $ 1,881,134 $ 720,351 38.3% $ 999,885
Central Bus District Capital 116,226 26,220 15,061 n/a 91,000 75,889 83.4% 55,398
Capitol Theatre Construction 144,473 71,927 25,000 n/a 190,000 - n/a 169,473
Yakima Redevelopment Area 2,668,747 1,900,000 124,617 6.6% 3,500,000 299,355 8.6% 2,494,009
Parks and Recreation Capital 242,353 1,750,000 455,000 n/a 1,962,211 279,045 14.2% 418,308
Fire Capital 1,097,851 1,963,500 26,685 1.4% 2,942,501 764,942 26.0% 359,594
Law and Justice Capital 574,250 554,886 134,612 24.3% 702,243 231,373 32.9% 477,489
Public Works Trust Constr 727,514 836,449 420,791 50.3% 1,028,084 461,611 44.9% 686,694
REET 2 Capital 551,438 1,152,000 420,791 36.5% 1,572,787 681,954 43.4% 290,275
Street Capital 931,057 20,811 44,627 214.4% 900,238 601,146 n/a 374,538
Convention Center Cap Impr 636,676 229,500 114,500 49.9% 549,790 126,974 23.1% 624,202
Reserve for Capital Impr 2,403,431 50,000 277,220 554.4% 3,745,000 129,924 3.5% 2,550,727
Airport Capital 630,382 12,776,500 125,642 1.0% 12,539,721 19,852 0.2% 736,172
Stormwater Capital 1,930,823 940,000 42,568 4.5% 2,025,000 38,398 1.9% 1,934,993
Transit Capital 2,304,367 1,868,507 195,806 10.5% 1,749,000 5,551 0.3% 2,494,622
Wastewater Capital 4,845,013 5,781,500 1,287,267 22.3% 4,690,000 396,022 8.4% 5,736,258
Water Capital 3,672,214 750,000 756,322 100.8% 2,670,000 106,211 4.0% 4,322,325
Irrigation Capital 1,070,350 1,430,060 718,295 50.2% 1,567,742 757,993 48.3% 1,030,652
Total Capital Impr Funds $ 25,914,485 $ 33,924,773 $ 5,537,720 16.3% $ 44,306,451 $ 5,696,591 12.9% $ 25,755,614
FIN Report 2nd Qtr 2015 ce.docx 12 of 14
Fund
Exhibit III
RESERVE AND OTHER 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
Employee Benefit Reserves
Unemployment Comp Res $ 435,231 $ 197,000 $ 100,480 51.0% $ 323,177 $ 84,474 26.1% $ 451,237
Employees Health Ben Res 2,068,574 9,823,850 4,649,769 47.3% 9,745,849 5,039,243 51.7% 1,679,100
Worker's Compensation Res 875,630 1,033,000 562,579 54.5% 1,241,131 607,014 48.9% 831,195
Wellness/EAP 182,715 175,000 - 0.0% 174,800 55,863 32.0% 126,852
Firemens' Relief and Pension 974,543 1,280,838 733,692 57,3% 1,380,282 677,622 49.1% 1,030,613
Total Employee Ben Reserve $ 4,536,693 $ 12,509,688 $ 6,046,520 48.3% $ 12,865,239 $ 6,464,216 50.2% $ 4,118,997
Operating Reserves
Capitol Theatre Reserve $ 108,568 $ - $ - n/a $ 71,927 $ - 0.0% $ 108,568
Risk Management Reserve 1,020,002 3,684,000 3,212,786 87.2% 3,643,704 2,758,007 75.7% 1,474,781
Total Operating Reserve $ 1,128,570 $ 3,684,000 $ 3,212,786 87.2% $ 3,715,631 $ 2,758,007 74.2% $ 1,583,349
Trust and Agency Funds
Cemetery Trust
Agency Fund-YAKCORPS
Total Other Funds
$ 632,022 $ 14,500 $ 12,006 82.8% $ 12,000 $ - 0.0% $ 644,028
242,647 605,777 627,333 103.6% 605,777 472,440 78.0% 397,540
$ 874,669 $ 620,277 $ 639,339 103.1% $ 617,777 $ 472,440 76.5% $ 1,041,568
FIN Report 2nd Qtr 2015 ce.docx 13 of 14
Fund
Exhibit IV
BOND REDEMPTIONS 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
GO Bond Redemption
LID Guaranty $ 25,264 $ 50 $ - 0.0% $ - $ - n/a $ 25,264
2002 GO Convention Center 161,795 1,016,422 513,693 50.5% 1,026,050 551,588 53.8% 123,900
2005 GO Various Bonds 8,733 3,010,189 2,111,864 70.2% 3,010,189 2,008,961 66.7% 111,636
1996 GO LTD - Cony Center 67,965 428,750 168,192 39.2% 428,190 36,595 8.5% 199,562
LID Debt Service Control 15 245,000 60,219 24.6% 245,000 - 0.0% 60,234
Total G.O. Bond Redemption $ 263,772 $ 4,700,411 $ 2,853,968 607% $ 4,709,429 $ 2,597,144 55.1% $ 520,596
Water/Sewer Revenue Bond Redemption
1997 Water Rev Bond Res $ 272,207 $ 400 $ - 0.0% $ $ - n/a $ 272,207
1996 Revenue Bond Reserve 149,163 700 - 0.0% - - n/a 149,163
1997 Water Revenue Bonds 6,966 237,725 118,850 50.0% 237,700 18,850 7.9% 106,966
2008 Water/Sewer Rev Bond 2 411,413 205,707 50.0% 411,413 85,706 20.8% 120,003
Water/Sewer Rev Bond Res 974,700 1,000 - 0.0% - - n/a 974,700
2003 Irrigation Bond Red 34,812 317,742 158,871 50.0% 317,742 93,871 29.5% 99,812
2003 Wastewater Bond Red 965 1,165,300 291,325 25.0% 1,165,300 150,150 12.9% 142,140
Total W/S Rev Bond Red $ 1,438,815 $ 2,134,280 $ 774,753 36.3% $ 2,132,155 $ 348,577 16.3% $ 1,864,991
FIN Report 2nd Qtr 2015 ce.docx 14 of 14