HomeMy WebLinkAbout07/07/2015 05B 1st Quarter 2015 Financial Trend Monitoring ReportITEM TITLE:
SUBMITTED BY:
SUMMARY EXPLANATION:
BUSINESS OF THE CITY COUNCIL
YAKIMA, WASHINGTON
AGENDA STATEMENT
Item No. 5.B.
For Meeting of: July 7, 2015
1st Quarter 2015 Financial Trend Monitoring Report
Cindy Epperson, Director of Finance and Budget
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 2015, 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 categories received a "normal" ranking, as actual results
are within 5% of expected levels at this point in time. There were no categories receiving a "warning"
or "negative" designation. Overall, first quarter results are as anticipated.
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:
City Manager
RECOMMENDATION:
Accept Report
ATTACHMENTS:
Description Upload Date
2015 1st Qtr Budget Report 6/29/2015
Type
Cover Memo
MEMORANDUM
June 30, 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 1st Quarter Financial Trend Monitoring Report
We are submitting for your review the City of Yakima's 2015 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/G-7
8-9
10
11
12
13
14
POSITIVE
NORMAL
WARNING
NEGATIVE
FIN Report 1st Qtr 2015 ce.docx 1 of 14
CITY WIDE OVERVIEW
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
REVENUE COMPARISON
(Budget vs. Actual)
2014
2014 Percent
Actual Rec'd
$13,172,500
667,317
627,532
14,467,349
15,367,589
7,266,896
1,054,561
780,495
2,576,713
2,831,187
550,230
$44,895,020
23.0%
15.3%
13.7%
21.9%
Amended
Budget
$61,333,941
5,459,455
4,718,610
2015
2015
Actual Rec'd
Percent
$13,567,386
700,801
552,175
71,512,006 14,820,362
22.1%
12.8%
11.7%
20.7%
23.8% 70,300,373 14,350,474 20.4%
12.9% 33,874,773 3,380,245 10.0%
21.9% 4,700,411 1,749,026 37.2%
36.4% 2,134,280 774,753 36.3%
21.8% 12,509,688 2,709,901 21.7%
84.2% 3,684,000 3,173,051 86.1%
88.0% 620,277 630,111 101.6%
21.4% $199,335,808 $41,587,923 20.9%
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
2015
2014 Percent Amended 2015
Actual
$14,937,816
998,999
1,398,571
17,335,386
16,524,842
7,806,690
94,307
96,064
3,391,726
1,152,698
162,337
$46,564,050
Percent
Spent Budget Actual Spent
25.7% $60,975,098 $14,884,966
22.6% 5,425,527 985,601
29.2% 5,049,379 1,296,296
25.7% 71,450,004 17,166,863
24.4%
18.2%
25.7%
24.0%
24.4% 71,723,234 16,554,493 23.1%
12.0% 40,743,263 2,858,353 7.0%
1.9% 4,709,429 94,307 2.0%
4.5% 2,132,155 93,871 4.4%
26.4% 12,865,239 3,005,255 23.4%
34.2% 3,715,631 1,958,309 52.7%
26.1% 617,777 219,579 35.5%
20.8% $207,956,732 $41,951,030 20.2%
FIN Report 1st Qtr 2015 ce.docx 2 of 14
GENERAL GOVERNMENT REVENUE ANALYSIS
GENERAL GOVERNMENT REVENUES
2015
-------- Revenues through 3131-------- Amended Percent
2013 2014 2015 Budget Receipted
General Sales Tax $3,495,744 $3,558,005 $3,772,717 $16,020,000 23.6%
Crim. Justice Sales Tax 703,084 741,209 791,084 3,205,350 24.7%
Property Tax 1,470,742 1,399,117 1,266,620 16,336,390 7.8%
Utility & Franchise Taxes 3,763,192 4,489,623 4,160,838 16,783,695 24.8%
Charges for Services 1,478,675 1,506,659 2,019,221 8,134,483 24.8%
State Shared Revenue 599,969 752,128 674,582 2,836,880 23.8%
Other Intergovernmental 436,082 318,688 362,598 1,629,520 22.3%
Fines and Forfeitures 447,577 393,164 459,739 1,645,110 27.9%
Other Taxes 696,818 669,716 641,845 1,429,000 44.9%
Transfers from other Funds 271,115 317,999 298,152 1,505,000 19.8%
Licenses and Permits 159,543 196,160 228,999 857,900 26.7%
Other Revenue 92,903 124,881 143,967 1,128,678 12.8%
Total Revenue 13,615,444 14,467,349 14,820,362 71,512,006 20.7%
Beginning Fund Balance 10,908,094 10,883,753 9,411,120 9,411,120
Total Resources $24,523,538 $25,351,102 $24,231,482 $80,923,126 29.9%
Status
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
Sales Tax — The first quarter continued grow above 2014 levels. Through the first quarter of 2015, sales tax
is 6.0% more than the prior year, and through the five months ending in May, we are 4.9% ahead of 2014
year to date for the same time period. The 2015 budget ended up being 3.6% higher than the full year of
2014 actual results, the budget may still be attained with a lower rate of growth through year end. Since
our economy is closely tied to the agricultural sector, the drought and other weather conditions could have
a dampening effect on the second half of the year. However, 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 appears to still be on target to meet the budget 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
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.
Franchise and Utility Taxes — This category fell off from 2014 by $328,785 or 7.3% from the first quarter of
2014, although the actual is 24.8%, which is close to the quarter total. Contributing factors for this reduction
include the mild weather conditions through the first three months of the year, compared to the severe cold
weather in the prior year. It also appears that our internal billing cycles experienced a timing difference at
the end of March, which has turned around in April and May. Natural gas use does slow down for the rest
FIN Report 1st Qtr 2015 ce.docx 3 of 14
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. The
total went up year over year primarily because the new Union Gap contract for fire services is included in
this category, adding about $300,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 $353,000 or 2.4% over 2014, and we anticipate year end to meet the
budget within the 3% range which maintains the "normal" ranking.
FIN Report 1st Qtr 2015 ce.docx 4 of 14
GENERAL GOVERNMENT REVENUES - By Month
$10,000,000
$7,500,000
$5,000,000
$2,500,000
$o
2013 2014 2015
Jan $4,451,264 $4,775,515 $4,598,223
Feb 4,267,636 4,770,901 4,720,788
Mar 4,896,583 4,984,701 5,501,349
Apr 9,758,283 10,717,557 0
May 4,733,408 4,573,329 0
Jun 4,168,515 4,307,587 0
Jul 3,962,439 4,304,052 0
Aug 3,798,660 4,290,971 0
Sep 4,758,660 5,180,804 0
Oct 10,070,031 9,891,373 0
Nov 4,006,410 4,395,161 0
Dec 4,641,432 5,190,725 0
$63,513,321 $67,382,676 $14,820,360
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
GENERAL GOVERNMENT REVENUES - Cumulative By Month
2013
2014 2015
Jan $4,451,264 $4,775515 $4,598,223
Feb 8,718,900 9546,416 9,319,011
Mar 13,615,483 14,531,117 14,820,360
Apr 23,373,766 25,248,674
May 28,107,174 29,822003
Jun 32,275,689 34,129590
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 62191,951
Dec 63,513,321 67,382,676
$60,000,000
$40,000,000
$20,000,000
$a
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
• 2013
• 2014
• 2015
FIN Report 1st Qtr 2015 ce.docx 5 of 14
GENERAL FUND EXPENDITURE ANALYSIS
Police
Fire
Transfers To Other Funds
Information Technology
Code Administration
Financial Services
Municipal Court
Police Pension
Utility Services
Legal
Engineering
Indigent Defense
Records / City Clerk
Purchasing
Human Resources
Economic Development
Planning
City Hall Facility
City Manager
Gang Free / Emer Mgmt
City Council
Intergovernmental
State Examiner
Position Vacancy Savings
Total General Fund
GENERAL GOVERNMENT EXPENDITURES
2015
-------- Expenditures through 3/31------ Amended Percent
2013 2014 2015 Budget Spent
$5,669,467 $6,046,982 $6,067,848 $26,610,805 22.8%
2,385,939 2,441,800 2,881,130 11,833,188 24.3%
625,983 1,101,817 1,286,667 4,793,875 26.8%
536,654 633,435 908,799 2,892,348 31.4%
299,881 1,466,015 377,698 1,682,327 22.5%
354,272 383,956 361,938 1,594,263 22.7%
323,482 316,214 289,437 1,395,989 20.7%
382,223 315,635 291,673 1,167,200 25.0%
398,837 351,090 408,411 1,499,446 27.2%
265,313 301,208 361,861 1,516,072 23.9%
165,817 168,335 194,403 890,530 21.8%
121,252 155,451 226,274 1,000,500 22.6%
165,095 301,609 229,139 592,904 38.6%
127,367 136,113 147,263 654,699 22.5%
109,180 125,132 134,626 664,003 20.3%
102,592 108,297 89,432 702,329 12.7%
142,930 98,287 124,855 581,384 21.5%
165,253 190,957 211,470 523,868 40.4%
92,340 96,653 109,754 389,578 28.2%
0 19,490 45,682 443,066 10.3%
107,238 114,103 109,409 286,735 38.2%
116,943 65,237 22,988 174,989 13.1%
0 0 4,209 110,000 3.8%
0 0 0 (1,025,000) 0.0%
12,658,058 14,937,816 14,884,966 60,975,098 24.4%
Parks & Recreation Fund 950,585 998,999 985,601 5,425,527 18.2%
Street & Traffic Ops. 1,368,448 1,398,571 1,296,296 5,049,379 25.7%
Total General Government $14,977,091 $17,335,386 $17,166,863 $71,450,004 24.0%
Total General Government Fund Expenditures -1.0% Below 25%
FIN Report 1st Qtr 2015 ce.docx
Status
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
1
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 in the first quarter. For example, the entire contribution to the Risk
Management fund is made in the first quarter, because the corresponding purchased insurance premiums
are due at the beginning of the year. Conversely, Parks and Recreation and Economic Development have
lower program activity in the first quarter, 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 25% 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 quarter.
➢ 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 normal for
this time of the year.
➢ Utility Services - Annual maintenance of $86,000 for the utility billing system is paid in the first
quarter.
➢ Records - Prior year election costs of $124,000 were paid in the first quarter.
➢ Economic Development - This division is under budget through the end of the first quarter because
of the seasonal nature of the events, along with the vacancy of the new assistant position. Also, the
City was recently awarded a grant to market airport operations, and this work was just getting
started.
➢ City Hall 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 1St
quarter primarily because the program contracts were under review. Also, the newly created
emergency management position was being recruited during the first quarter, so there are salary
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 2nd quarter of the year.
Position Vacancy Savings - Shown for fund total purposes only - no "actual" will be charged here.
FIN Report 1st Qtr 2015 ce.docx 7 of 14
OTHER FUNDS ANALYSIS
OTHER FUNDS REVENUES
2015
-------- Revenues through 3/31 -------- Amended Percent
2013 2014 2015 Budget Rec'd
Operating/Enterprise Funds $14,328,769 $15,367,589 $14,350,474 $70,300,373 20.4%
Capital Funds 3,256,665 7,266,896 3,380,245 33,874,773 10.0%
Reserve, Trust & Agency Funds 6,495,937 5,958,130 6,513,063 16,813,965 38.7%
Bond Redemption Funds 1,146,452 1,835,056 2,523,779 6,834,691 36.9%
Total Revenue 25,227,823 30,427,671 26,767,561 127,823,802 20.9%
Beginning Fund Balance 47,394,784 51,645,155 54,008,091 54,008,091
Total Resources $72,622,607 $82,072,826 $80,775,652 $181,831,893 44.4%
OTHER FUNDS EXPENDITURES
2015
-------- Expenditures through 3131-------- Amended Percent
2013 2014 2015 Budget Rec'd
Operating/Enterprise Funds $14,290,484 $16,524,842 $16,554,493 $71,723,234 23.1%
Capital Funds 3,774,033 7,806,690 2,858,353 40,743,263 7.0%
Reserve, Trust & Agency Funds 3,450,483 4,706,761 5,183,143 17,198,647 30.1%
Bond Redemption Funds 100,111 190,371 188,178 6,841,584 2.8%
Total Expenditures $21,615,111 $29,228,664 $24,784,167 $136,506,728 18.2%
Status
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
Status
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 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 lst 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. Fortunately, the Stormwater capital
program is not in full swing in the first quarter, so the transfer can be delayed until the April collections.
The Environmental Fund budget includes a grant from the Department of Ecology to clean-up the 4 Tiger
Oil sites. This work was just getting started at the end of the first quarter, and, as is typical with grant -
funded programs, the expenditures have to be made before we can be reimbursed.
FIN Report 1st Qtr 2015 ce.docx 8 of 14
Capital Fund budgets include the full project, and are not expected to be 100% completed in the current
year. Street projects require good weather for asphalt. A listing of the top ten budgeted projects and their
first quarter expenses 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 virtually
breaking even through the first quarter -- the cost containment measures implemented at the beginning of
the year 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.
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.
FIN Report 1st 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 $1,453 FAA Grant FY2015/16
Construction Passenger Facility Charges
2402 LIFT Area Roundabout LF 2,600,000 178,000 LIFT Sales tax credit, County FY 2015
Fair Avenue SIFD loan & grant, local match
2365 Beech St Interceptor Phase III WW 1,800,000 0 Charges for Services FY2015/16
TBD N 1st St Revitalization - Stormwater SW 1,790,000 0 Charges for Services FY2015/16
2335 Modifications to Water Treatment W 1,408,580 30,905 Charges for Services FY 2015
Plant Intake
2391 N 1st St Revitalization - W 1,360,000 0 Charges for Services FY2015/16
Water Main Replacement
2390 N 1st St Revitalization Phase II ST 1,315,000 108,876 Street Capital Reserves FY2015/16
n/a Transit Bus Replacement TR 1,290,000 0 Transit Sales Tax FY 2015
n/a Fire ladder truck replacement F 1,150,000 0 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
Department Legend:
AP - Airport
LF - LIFT Area
WW - Wastewater Capital
SW - Stormwater
W - Water Capital
ST - Street Improvement
TR - Transit
F - Fire Capital
PK - Parks Capital
FIN Report 1st Qtr 2015 ce.docx 10 of 14
EXHIBITS
Fund
OTHER OPERATING/ENTERPRISE FUNDS
Actual Revenue Appropriations Ending
Beg Bal Amended Actual % Amended Actual % Balance
01/01/15 Budget Revenue Rec'd Budget Exp Exp'd 12/31/15
Exhibit I
Economic Development $85,432 $222,000 $53,984 24.3% $235,766 $49,926 21.2% $89,490
Neighborhood Development 830,030 1,474,337 142,677 9.7% 1,479,188 323,737 21.9% 648,970
Community Relations 603,473 596,600 171,581 28.8% 610,714 159,631 26.1% 615,423
Cemetery 56,376 264,950 57,950 21.9% 291,709 94,491 32.4% 19,835
Emergency Services 208,306 1,290,026 110,806 8.6% 1,312,692 283,826 21.6% 35,286
Public Safety Communication 871,526 4,095,799 787,886 19.2% 4,438,988 787,917 17.7% 871,495
Police Grants 174,736 484,000 34,113 7.0% 475,296 38,036 8.0% 170,813
P.B.I.A. (Parking & Bus Impr) 12,408 197,840 56,996 28.8% 197,500 32,394 16.4% 37,010
Trolley 97,884 53,624 1,275 2.4% 57,046 3,893 6.8% 95,266
Front Street Bus Impr Area 6,099 3,735 1,084 29.0% 7,000 1,550 22.1% 5,633
Cony Center (Tourist Promo) 540,514 1,674,250 316,956 18.9% 1,609,854 401,269 24.9% 456,201
Capitol Theatre 27,259 395,250 98,343 24.9% 396,540 121,656 30.7% 3,946
PFD- Convention Center 421,225 816,750 213,278 26.1% 748,220 181,868 24.3% 452,635
Tourism Promotion Area 79,626 687,000 114,903 16.7% 687,000 114,903 16.7% 79,626
PFD- Capitol Theatre 176,423 618,700 161,611 26.1% 640,220 159,118 24.9% 178,916
Airport Operating 8,539 1,108,889 261,726 23.6% 1,099,337 264,614 24.1% 5,651
Stormwater Operating 1,411,055 2,151,000 289,553 13.5% 3,353,229 358,206 10.7% 1,342,402
Transit Operating 981,775 8,519,226 1,687,260 19.8% 8,581,432 2,036,863 23.7% 632,172
Refuse 370,465 5,834,599 1,308,192 22.4% 5,877,188 1,342,469 22.8% 336,188
Wastewater Operating 4,144,825 21,431,302 5,283,771 24.7% 20,901,186 5,624,323 26.9% 3,804,273
Water Operating 3,274,367 8,876,000 1,755,590 19.8% 9,347,579 2,521,995 27.0% 2,507,962
Irrigation 851,179 1,766,200 392,548 22.2% 1,795,875 718,071 40.0% 525,656
Equipment Rental 4,263,021 5,612,858 727,939 13.0% 5,411,876 576,938 10.7% 4,414,022
Environmental 627,146 1,010,000 41,395 4.1% 1,007,950 65,966 6.5% 602,575
Public Works Admin. 509,733 1,115,438 279,057 25.0% 1,159,849 290,833 25.1% 497,957
Total Other Operating Funds $20,633,422 $70,300,373 $14,350,474 20.4% $71,723,234 $16,554,493 23.1% $18,429,403
FIN Report 1st Qtr 2015 ce.docx 11 of 14
Exhibit II
CAPITAL IMPROVEMENT FUNDS
Actual Revenue 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 $206,250 11.3% $1,881,134 $329,132 17.5% $1,244,438
Central Bus District Capital 116,226 26,220 6,200 n/a 91,000 158 0.2% 122,268
Capitol Theatre Construction 144,473 71,927 12,500 n/a 50,000 0 n/a 156,973
Yakima Redevelopment Area 2,668,747 1,900,000 124,617 6.6% 3,500,000 239,849 6.9% 2,553,515
Parks and Recreation Capital 242,353 1,700,000 50,000 n/a 1,750,000 136,739 7.8% 155,614
Fire Capital 1,097,851 1,963,500 8,114 0.4% 2,254,159 629,553 27.9% 476,412
Law and Justice Capital 574,250 554,886 98,230 17.7% 639,636 119,507 18.7% 552,973
Public Works Trust Constr 727,514 836,449 166,779 19.9% 1,028,084 322,889 31.4% 571,404
REET2 Capital 551,438 1,152,000 166,779 14.5% 1,572,787 256,822 16.3% 461,395
Street Capital 931,057 20,811 29,891 143.6% 0 10,033 n/a 950,915
Convention Center Cap Impr 636,676 229,500 57,250 24.9% 490,000 35,673 7.3% 658,253
Reserve for Capital Impr 2,403,431 50,000 0 0.0% 2,245,000 13,903 0.6% 2,389,528
Airport Capital 630,382 12,776,500 65,219 0.5% 12,539,721 1,453 0.0% 694,148
Stormwater Capital 1,930,823 940,000 42,568 4.5% 2,025,000 0 0.0% 1,973,391
Transit Capital 2,304,367 1,868,507 8,638 0.5% 1,749,000 5,551 0.3% 2,307,454
Wastewater Capital 4,845,013 5,781,500 1,256,559 21.7% 4,690,000 219,248 4.7% 5,882,324
Water Capital 3,672,214 750,000 726,480 96.9% 2,670,000 30,905 1.2% 4,367,789
Irrigation Capital 1,070,350 1,430,060 354,171 24.8% 1,567,742 506,938 32.3% 917,583
Total Capital Impr Funds $25,914,485 $33,874,773 $3,380,245 10.0% $40,743,263 $2,858,353 7.0% $26,436,377
FIN Report 1st Qtr 2015 ce.docx 12 of 14
Fund
Exhibit III
RESERVE AND OTHER FUNDS
Actual - Revenue - 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 $48,505 24.6% $323,177 $12,647 3.9% $471,089
Employees Health Ben Res 2,068,574 9,823,850 2,311,056 23.5% 9,745,849 2,342,942 24.0% 2,036,688
Worker's Compensation Res 875,630 1,033,000 268,335 26.0% 1,241,131 260,493 21.0% 883,472
Wellness/EAP 182,715 175,000 0 0.0% 174,800 29,290 16.8% 153,425
Firemens' Relief and Pension 974,543 1,280,838 82,005 6.4% 1,380,282 359,883 26.1% 696,665
Total Employee Ben Reserve $4,536,693 $12,509,688 $2,709,901 21.7% $12,865,239 $3,005,255 23.4% $4,241,339
Operating Reserves
Capitol Theatre Reserve 108,568 0 0 n/a 71,927 0 0.0% 108,568
Risk Management Reserve 1,020,002 3,684,000 3,173,051 86.1% 3,643,704 1,958,309 53.7% 2,234,744
Total Operating Reserve $1,128,570 $3,684,000 $3,173,051 86.1% $3,715,631 $1,958,309 52.7% $2,343,312
Trust and Agency Funds
Cemetery Trust $632,022 $14,500 $2,778 19.2% $12,000 $0 0.0% $634,800
Agency Fund-YAKCORPS 242,647 605,777 627,333 103.6% 605,777 219,579 36.2% 650,401
Total Other Funds $874,669 $620,277 $630,111 101.6% $617,777 $219,579 35.5% $1,285,201
FIN Report 1st Qtr 2015 ce.docx 13 of 14
Fund
Exhibit IV
BOND REDEMPTIONS FUNDS
Actual Revenue 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.0% $0 $0 n/a $25,264
2002 GO Convention Center 161,795 1,016,422 231,610 22.8% 1,026,050 0 0.0% 393,405
2005 GO Various Bonds 8,733 3,010,189 1,423,442 47.3% 3,010,189 94,307 3.1% 1,337,868
1996 GO LTD- Cony Center 67,965 428,750 67,654 15.8% 428,190 0 0.0% 135,619
LID Debt Service Control 15 245,000 26,320 10.7% 245,000 0 0.0% 26,335
Total G.O. Bond Redemption $263,772 $4,700,411 $1,749,026 37.2% $4,709,429 $94,307 2.0% $1,918,491
Water/Sewer Revenue Bond Redemption
1997 Water Rev Bond Res $272,207 $400 $0 0.0% $0 $0 n/a $272,207
1996 Revenue Bond Reserve 149,163 700 0 0.0% 0 0 n/a 149,163
1997 Water Revenue Bonds 6,966 237,725 118,850 50.0% 237,700 0 0.0% 125,816
2008 Water/Sewer Rev Bond 2 411,413 205,707 50.0% 411,413 0 0.0% 205,709
Water/Sewer Rev Bond Res 974,700 1,000 0 0.0% 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 0 0.0% 292,290
Total W/S Rev Bond Red $1,438,815 $2,134,280 $774,753 36.3% $2,132,155 $93,871 4.4% $2,119,697
FIN Report 1st Qtr 2015 ce.docx 14 of 14