HomeMy WebLinkAbout06/03/2014 08 2014 1st Quarter Financial Trend Monitoring ReportBUSINESS OF THE CITY COUNCIL
YAKIMA, WASHINGTON
AGENDA STATEMENT
Item No. 8.
For Meeting of: June 03, 2014
IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII
ITEM TITLE:
SUBMITTED BY:
SUMMARY EXPLANATION:
1st Quarter 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 2014, 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:
Other (Specify): Report
Contract: Contract Term:
Start Date: End Date:
Amount:
Ordinance:
Item Budgeted:
Funding Source/Fiscal
Impact:
Strategic Priority:
Insurance Required? No
Mail to:
Phone:
APPROVED FOR
SUBMITTAL:
Public Trust and Accountability
City Manager
RECOMMENDATION:
Accept Report
ATTACHMENTS:
Description
ist Qtr 2014 Financial Monitoring Report
Upload Date
5/27/2014
Type
Cover Memo
MEMORANDUM
May 29, 2014
TO: The Honorable Mayor and
Members of the City Council
FROM: Tony O'Rourke, City Manager
Cindy Epperson, Director of Finance & Budget
SUBJECT: 2014 1St Quarter Financial Trend Monitoring Report
We are submitting for your review the City of Yakima's 2014 1St Quarter actual compared to
budgeted Revenue and Expenditure Report for all city funds. Beginning fund balances shown
are subject to final adjustments made as a result of the year-end closing process, which will not
be officially concluded until the State Auditor's work is completed. We do not, at this time,
expect that any adjustments will materially affect the balances represented in this report.
It should be noted that the budget information for the Airport is now incorporated into this
report.
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 Fund Revenue Analysis
> General Fund 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
Operating/Enterprise Funds (1)
Capital Funds (1)
Reserve, Trust & Agency Funds (1)
Bond Redemption Funds (1)
STATUS PAGE
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 / 3-5
2 / 6-7
8/11
8/12
8/13
8/14
NORMAL
WARNING
PDFConvert.4056.1.FIN_Report_1st_Qrtr.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
2012 Total Comparison
General
Parks and Recreation
Street & Traffic Operations
General Government Subtotal
1st Qtr
Actual
2013 --------------
$12,328,884
623,421
663,139
13,615,444
14,328,769
3,256,665
985,700
160,752
3,137,718
2,828,011
530,208
$38,843,267
Percent
Rec'd
23.1%
15.6%
10.8%
21.5%
2014
1st Qtr
Budget Actual
$57,181,843 $13,172,500
4,357,215 667,317
4,596,360 627,532
66,135,418 14,46 7,349
24.4% 64,649,505 15,367,589
8.8% 56,205,847 7,266,896
10.3% 4,809,441 1,054,561
0.0% 2,146,286 780,495
21.1% 11,802,538 2,576,713
26.0% 3,360,500 2,831,187
68.2% 625,171 550,230
19.8% $209,734,706 $44,895,020
Percent
Rec'd
23.0%
15.3%
13.7%
21.9%
23.8%
12.9%
21.9%
36.4%
21.8%
84.2%
88.0%
21.4%
$192,009,500 $42,829,854 22.3%
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
-_-- 2013 --
1st Qtr Percent
2014
1st Qtr Percent
Actual Spent Budget Actual Spent
$12,658,058
950,585
1,368,448
14,977,091
14,290,484
3,774,033
1,859
98,252
2,628,601
776,609
45,273
$36,592,202
24.6% $58,138,453 $14,937,816 25.7%
21.8% 4,412,448 998,999 22.6%
32.0% 4,786,409 1,398,571 29.2%
24.9% 67,337,310 17,335,386 25.7%
21.7% 67,837,845 16,524,842
64,889,845 7,806,690
0.0% 4,968,849 94,307
3.8% 2,144,786 96,064
22.0% 12,843,823 3,391,726
3,371,576 1,152,698
3.6% 622,671 162,337
7.3%
7.3%
24.4%
12.0%
1.9%
4.5%
26.4%
34.2%
26.1%
18.0% $224,016,705 $46,564,050 20.8%
PDFConvert.4056.1.FIN_Report_1st_Qrtr.docx 2 of 14
GENERAL FUND REVENUE ANALYSIS
GENERAL GOVERNMENT REVENUES
2014
Revenues through 3/31 Amended Percent
2012 2013 2014 Budget Receipted Status
General Sales Tax $3,199,792 $3,495,744 $3,558,005 $14,820,000 24.0%
Crim. Justice Sales Tax 674,684 703,084 741,209 2,970,000 25.0%
Property Tax 1,140,813 1,470,742 1,399,117 15,899,000 8.8%
Franchise & Utility Taxes 3,758,791 3,763,192 4,489,623 15,332,500 29.3%
Charges for Services 1,289,448 1,478,675 1,506,659 7,007,789 21.5%
State Shared Revenue 665,408 599,969 752,128 2,835,400 26.5%
Other Intergovernmental 117,277 436,082 318,688 1,436,751 22.2%
Fines and Forfeitures 433,295 447,577 393,164 1,670,000 23.5%
Other Taxes 649,932 696,818 669,716 1,420,500 47.1%
Transfers from other Funds 341,548 271,115 317,999 1,415,000 22.5%
Licenses and Permits 186,465 159,543 196,160 769,200 25.5%
Other Revenue 123,483 92,903 124,881 559,278 22.3%
Total Revenue 12,580,936 13,615,444 14,467,349 66,135,418 21.9%
Beginning Fund Balance 9,948,220 10,908,094 10,682,085 10,682,085
Total Resources 22,529,156 24,523,538 25,149,434 76,817,503 32.7%
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
Sales Tax - The first quarter continued grow above 2013 levels. Through the first quarter of 2014, sales
tax is 1.8% more than the prior year, and through the five months ending in May, we are 4.2% ahead of
2013 year to date for the same time period. Since the 2014 budget ended up being 2.9% higher than the
full year of 2013 actual results, this revenue is currently 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 2014 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 is demonstrating strong growth, with 2014 exceeding 2013
by $726,431 or 19%. Contributing factors include the move of the Cable TV utility tax from a debt
service fund in prior years to General Fund in 2014 - adding about $129,000; a combination of rate
increases for the gas and electric utilities, coupled with harsher weather conditions; and other rate and
usage variances. Natural gas use does slow down for the rest of the year, so this category is not
expected to keep growing at the rate experienced in the first quarter, but it should meet or slightly
exceed 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.
PDFConvert.4056.1.FIN_Report_1st_Qrtr.docx 3 of 14
Other Taxes - This category consists primarily of Business Licenses and Gambling Taxes. Business
licenses are due in January for the year, so that over 85% of this category has been collected by March
31. The 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 $850,000 or 6.3% over 2013, and we anticipate year end
to exceed the budget within the 5% range which maintains the "normal" ranking.
PDFConvert.4056.1.FIN_Report_1st_Qrtr.docx 4 of 14
GENERAL FUND REVENUES - By Month
2012 2013 2014
Jan 3,668,912 4,451,264 4,828,039
Feb 4,206,186 4,267,636 4,770,111
Mar 4,861,758 4,896,583 4,869,197
Apr 9,388,842 9,758,283
May 4,833,268 4,733,408
Jun 4,146,240 4,168,515
Jul 4,636,431 3,962,439
Aug 3,574,114 3,798,660
Sep 4,250,150 4,758,660
Oct 9,673,506 10,070,031
Nov 4,263,220 4,006,410
Dec 4,016,944 4,641,432
61,519,571 63,513,321 14,467,347
10,000,000
8,000,000
6,000,000
4,000,000
2,000,00 ' Arr FIHEI
0
0
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
■ 2012
■ 2013
■ 2014
GENERAL FUND REVENUES - Cumulative By Month
2012 2013 2014
Jan 3,668,912 4,451,264 4,828,039
Feb 7,875,098 8,718,900 9,598,150
Mar 12,736,856 13,615,483 14,467,347
Apr 22,125,698 23,373,766
May 26,958,966 28,107,174
Jun 31,105,206 32,275,689
Jul 35,741,637 36,238,128
Aug 39,315,751 40,036,788
Sep 43,565,901 44,795,448
Oct 53,239,407 54,865,479
Nov 57,502,627 58,871,889
Dec 61,519,571 63,513,321
L60,000,000
40,000,000
20,000,000
0
tiII+I'hI'ifiF
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
2012
■ 2013
2014
PDFConvert.4056.1.FIN_Report_1st_Qrtr.docx 5 of 14
GENERAL FUND EXPENDITURE ANALYSIS
Police
Fire
Transfers To Other Funds
Information Systems
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 Maintenance
City Manager
Gang Free Initiative
City Council
Intergovernmental
State Examiner
Urban Area Hearings Exam.
Position Vacancy Savings
Total General Fund
Parks & Recreation Fund
Street & Traffic Ops.
Total General Government
GENERAL GOVERNMENT EXPENDITURES
2014
-------- Expenditures through 3/31 -------- Amended Percent
2012 2013 2014 Budget Spent Status
$5,634,443
2,158,155
568,007
619,058
293,578
369,678
284,892
353,961
385,834
255,999
166,094
125,184
286,695
111,990
112,607
0
137,852
153,016
58,554
0
92,142
92,955
543
6,846
0
12,268,083
833,790
1,589,937
$5,669,467 $6,046,982 $26,057,587 23.2%
2,385,939 2,441,800 10,167,258 24.0%
625,983 1,101,817 4,442,275 24.8%
536,654 633,435 2,912,612 21.7%
299,881 1,466,015 2,639,371 55.5%
354,272 383,956 1,488,836 25.8%
323,482 316,214 1,344,118 23.5%
382,223 315,635 1,343,325 23.5%
398,837 351,090 1,316,181 26.7%
265,313 301,208 1,314,323 22.9%
165,817 168,335 1,109,632 15.2%
121,252 155,451 600,500 25.9%
165,095 301,609 563,921 53.5%
127,367 136,113 549,369 24.8%
109,180 125,132 513,151 24.4%
102,592 108,297 486,733 22.2%
134,110 93,121 458,481 20.3%
165,253 190,957 407,885 46.8%
92,340 96,653 372,684 25.9%
0 19,490 333,105 5.9%
107,238 114,103 282,075 40.5%
116,943 65,237 244,031 26.7%
0 0 110,000 0.0%
8,820 5,166 31,000 16.7%
0 0 (950,000) 0.0%
12,658,058
950,585
1,368,448
14,937,816 58,138,453 25.7%
998,999 4,412,448 22.6%
1,398,571 4,786,409 29.2%
$14,691,810 $14,977,091 $17,335,386 $67,337,310 25.7%
Total General Government Fund Expenditures -0.7% Above 25%
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
Note: The one-time purchase of the Tiger Oil properties was completed in the first quarter, which
added $1.1 million to the normal operations. Without this one-time expenditure, actual expenditures
are slightly less than 25% of the annual budget.
PDFConvert.4056.1.FIN_Report_1 st_Qrtr.docx
6 of 14
SIGNIFICANT EXPENDITURE VARIANCES
Normal-Over/under 25% in first quarter, yet comparable to prior years—payment timing variance
• Code Administration - Because the purchase of the Tiger Oil properties was for the purpose of
environmental clean-up, the appropriation for the $1.1 million purchase was entered in the
Code Administration budget. This purchase was completed at the end of March. If this
transaction is pulled out for comparison's sake, actual expenditures are 23.8% of budget.
• Utility Services - Annual maintenance of $86,000 for the utility billing system is paid in the first
quarter.
• Records - Prior year election costs of $208,000 were paid in the first quarter.
• City Hall Maintenance - Annual transfer to Risk Management Fund to pay for property
insurance is made in the first quarter - $115,000.
• Gang Free Initiative - This program was previously included in the Police budget. The new
program manager position was being recruited during the first quarter, so there are salary
savings.
• City Council - Annual Association of Washington Cities (AWC) dues of $63,000 paid in the first
quarter.
• 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 outside
contractors to plow.
Position Vacancy Savings - Shown for fund total purposes only - no "actual" will be charged here.
PDFConvert.4056.1.FIN_Report_1st_Qrtr.docx 7 of 14
OTHER FUNDS ANALYSIS
OTHER FUNDS REVENUES
------- Revenues through 3/31 --------
2012 2013 2014
Operating/Enterprise Funds $15,109,519
Capital Funds 2,759,799
Reserve, Trust & Agency Funds 5,920,114
Bond Redemption Funds 374,230
Total Revenue 24,163,662
Beginning Fund Balance 44,858,285
Total Resources 69,021,947
2014
Amended Percent
Budget Spent Status
$14,328,769 $15,367,589 $64,649,505 23.8%
3,256,665 7,266,896 56,205,847 12.9%
6,495,937 5,958,130 15,788,209 37.7%
1,146,452 1,835,056 6,955,727 26.4%
25,227,823 30,427,671 143,599,288 21.2%
47,394,784 51,645,155 51,645,155
72,622,607 82,072,826 195,244,443 42.0%
OTHER FUNDS EXPENDITURES
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
2014
------- Expenditure through 3/31 Amended Percent
2012 2013 2014 Budget Spent Status
Operating/Enterprise Funds $14,019,482 $14,290,484 $16,524,842 $67,837,845 24.4%
Capital Funds 2,660,892 3,774,033 7,806,690 64,889,845 12.0%
Reserve, Trust & Agency Funds 3,906,726 3,450,483 4,706,761 16,838,070 28.0%
Bond Redemption Funds 100,277 100,111 190,371 7,113,635 2.7%
Total Expenditures 20,687,377 21,615,111 29,228,664 156,679,395 18.7%
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, 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.3% of budget through the end of the 1St
quarter, there is temporarily a negative fund balance until half of the property tax is collected in April.
This is normal for this fund at this time of year.
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.
PDFConvert.4056.1.FIN_Report_1st_Qrtr.docx 8 of 14
Reserve Funds are ahead in revenue, because the full year of "premiums" to Risk Management are
transferred in the 1St quarter. Expenses are also higher than anticipated primarily because of activity in
the Medical Insurance Fund -even with the savings we are experiencing with our clinic, a major claim
has hit the stop -loss limit of $250,000 in this time frame. Additionally we are seeing more medium size
claims. Our insurance broker is reviewing alternatives to ensure we maintain state required reserves.
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.
PDFConvert.4056.1.FIN_Report_1st_Qrtr.docx 9 of 14
TOP 10 CAPITAL PROJECTS
Project Number/Description
2379 Streets Capital Preservation
2376 Airport -Alpha Taxiway
Construction
1818 Railroad Grade Separation
Martin Luther King Blvd
Total 2014 Actual 2014
Dept Budget Expended Funding Source
ST $16,500,000 $301,265 General Obligation Bond
AIR 11,162,885 63,201 FAA Grant
Passenger Facility Charges
ST 4,898,000 430,330 State & Federal Grants
Public Works Trust Fund Loan
2308 Wastewater Facility Improvement WW
2259 Water Treatment Plant Lagoons
2365 Beech St Interceptor Phase III
4,700,000 0 Debt Proceeds, Contributions
Charges for Services
W 2,100,000 374,483 Drinking Water State
Revolving Fund Loan
0 Charges for Services
528,763 Wastewater Capital Reserves
64,179 Charges for Services
TR 1,300,000 0 Transit Sales Tax
ST 1,200,000 0 Grant
WW 2,000,000
1,800,000
W 1,500,000
2267 WW NPDES/TMDL Dschrg/Load WW
Riparian outflow modification
2335 Modifications to Water Treatment
Plant Intake
Transit Bus Replacement
2340 N 1st St Revitalization Phase I
apt. Legend:
AIR - Airport
ST - Street Improvement
TR - Transit
WW - Wastewater Capital
W - Water Capital
Expected
Completion
FY 2014
FY 2015
FY 2014
FY 2014/15
FY 2014
FY 2014
FY 2014/15
FY 2014
FY 2014
FY2015/16
PDFConvert.4056.1.FIN_Report_1st_Qrtr.docx 10 of 14
EXHIBITS
Fund
OTHER OPERATING/ENTERPRISE FUNDS
Actual
Beg Bal Amended
1/1/2014 Budget
Revenue
Actual
Revenue
°/O
Recd
--- Appropriations
Amended Actual
Budget Exp
°/O
Exp'd
Exhibit I
Ending
Balance
3/31/2014
Economic Development
Neighborhood Development
Community Relations
Cemetery
Emergency Services
Public Safety Communication
Police Grants
P.B.I.A. (Parking & Bus Impr)
Trolley
Front Street Bus Impr Area
Cony Center (Tourist Promo)
Capitol Theatre
PFD- Convention Center
Tourism Promotion Area
PFD - Capitol Theatre
Airport Operating
Stormwater Operating Fund
Transit
Refuse
Wastewater Operating
Water Operating
Irrigation
Equipment Rental
Environmental
Public Works Admin.
Total Other Operating Funds
$812,218 $258,000
191,131 1,764,163
550,233 551,600
54,049 264,950
156,188 1,337,026
677,659 3,019,937
256,184 484,000
37,680 235,170
7,150 154,926
5,675 3,335
479,522 1,548,250
57,158 297,250
261,465 755,750
73,324 687,000
104,222 575,500
66,532 993,625
1,463,183 2,165,000
606,448 7,660,917
370,478 5,586,000
2,011,413 19,958,357
2,959,877 7,997,500
939,053 1,766,100
4,120,677 5,319,711
524,232 150,000
514,760 1,115,438
$63,647
228,807
144,635
57,831
125,719
659,704
41,381
55,540
25,455
984
267,430
75,031
253,038
104,542
191,821
253,539
304,453
2,127,296
1,436,468
5,905,602
1,794,498
423,701
504,718
42,915
278,834
$17,300,511
24.7%
13.0%
26.2%
21.8%
9.4%
21.8%
8.5%
23.6%
16.4%
29.5%
17.3%
25.2%
33.5%
15.2%
33.3%
25.5%
14.1%
27.8%
25.7%
29.6%
22.4%
24.0%
9.5%
28.6%
25.0%
$456,622
1,766,938
601,850
278,900
1,339,282
3,218,239
469,024
244,358
157,809
9,000
1,483,667
342,020
645,000
687,000
531,000
1,037,370
2,325,519
8,240,033
5,670,633
20,213,432
9,022,649
2,063,884
5,671,800
192,950
1,168,866
$74,426
332,621
142,873
63,170
284,759
634,999
97,242
17,173
9
1,500
374,430
115,512
159,647
104,542
133,147
206,406
649,115
2,138,674
1,511,470
5,566,588
2,363,859
866,732
373,058
2,099
310,791
$64,649,505 $15,367,589 23.8% $67,837,845 $16,524,842
16.3%
18.8%
23.7%
22.6%
21.3%
19.7%
20.7%
7.0%
0.0%
16.7%
25.2%
33.8%
24.8%
15.2%
25.1%
19.9%
27.9%
26.0%
26.7%
27.5%
26.2%
42.0%
6.6%
1.1%
26.6%
24.4%
$801,439
87,317
551,995
48,710
(2,852)
702,364
200,323
76,047
32,596
5,159
372,522
16,677
354,856
73,324
162,896
113,665
1,118,521
595,070
295,476
2,350,427
2,390,516
496,022
4,252,337
565,048
482,803
$16,143,258
PDFConvert.4056.1.FIN_Report_1st_Qrtr.docx 11 of 14
Fund
Exhibit II
CAPITAL IMPROVEMENT FUNDS
Actual Revenue Appropriations Ending
Beg Bal Amended Actual % Amended Actual 0/0
Balance
1/1/2014 Budget Revenue Rec'd Budget Exp Exp'd 3/31/2014
Arterial Street $2,169,408 $3,823,975 $235,800 6.2% $5,106,566 $285,067 5.6% $2,120,141
Central Bus District Capital 163,264 22,400 13,080 n/a 91,000 231 0.3% 176,113
Capitol Theatre Construction 72,546 71,927 0 n/a 140,000 0 n/a 72,546
Yakima Redevelopment Area 1,207,557 2,850,000 193,589 6.8% 2,473,235 64,129 2.6% 1,337,017
Parks and Recreation Capital 239,590 0 0 n/a 100,000 0 0.0% 239,590
Fire Capital 1,116,489 134,500 22,056 16.4% 296,459 23,276 7.9% 1,115,269
Law and Justice Capital 940,905 382,886 64,760 16.9% 750,636 218,031 29.0% 787,634
Public Works Trust Constr 519,049 676,306 127,862 18.9% 732,773 280,171 38.2% 366,740
REET 2 Capital 585,060 592,000 127,862 21.6% 772,787 128,411 16.6% 584,511
Street Capital 0 16,500,000 325,000 2.0% 16,500,000 301,265 1.8% 23,735
Transit Capital Reserve 2,455,220 1,268,507 15,247 1.2% 1,749,000 0 0.0% 2,470,467
Convention Center Cap Impr 631,396 260,500 65,000 25.0% 360,000 28,311 7.9% 668,085
Reserve for Capital Impr 3,883,363 4,004,489 1,532,555 38.3% 4,948,000 2,331,591 47.1% 3,084,327
Airport Capital 581,655 10,666,597 75,155 0.7% 11,162,885 356,776 3.2% 300,034
Stormwater Capital Fund 1,360,734 444,000 205,142 46.2% 790,000 2,804 0.4% 1,563,072
Wastewater Capital 3,452,383 10,501,900 1,696,692 16.2% 12,975,000 1,021,558 7.9% 4,127,517
Domestic Water Improvement 4,365,386 2,264,800 2,030,575 89.7% 4,320,000 2,412,651 55.8% 3,983,310
Irrigation System Impr 504,332 1,741,060 536,521 30.8% 1,621,504 352,418 21.7% 688,435
Total Capital Impr Funds $24,248,337 $56,205,847 $7,266,896 12.9% $64,889,845 $7,806,690 12.0% $23,708,543
PDFConvert.4056.1.FIN_Report_1st_Qrtr.docx 12 of 14
Fund
Exhibit III
RESERVE AND OTHER FUNDS
Actual Revenue Appropriations Ending
Beg Bal Amended Actual % Amended Actual % Balance
1/1/2014 Budget Revenue Rec'd Budget Exp Exp'd 3/31/2014
Employee Benefit Reserves
Unemployment Comp Res $394,723 $177,000 $47,138 26.6% $286,582 $11,336 4.0% $430,525
Employees Health Ben Res 3,299,663 9,158,200 2,167,866 23.7% 9,867,703 2,655,467 26.9% 2,812,062
Worker's Compensation Res 1,070,111 1,033,000 256,537 24.8% 1,258,630 349,132 27.7% 977,516
Wellness/EAP 179,929 175,000 0 0.0% 171,600 38,674 22.5% 141,255
Firemens' Relief and Pension 941,110 1,259,338 105,172 8.4% 1,259,308 337,117 26.8% 709,165
Total Employee Ben Reserve $5,885,536 $11,802,538 $2,576,713 21.8% $12,843,823 $3,391,726 26.4% $5,070,523
Operating Reserves
Capitol Theatre Reserve 180,495 500 0 0.0% 71,927 0 0.0% 180,495
Risk Management Reserve 820,160 3,360,000 2,831,187 84.3% 3,299,649 1,152,698 34.9% 2,498,649
Total Operating Reserve $1,000,655 $3,360,500 $2,831,187 84.2% $3,371,576 $1,152,698 34.2% $2,679,144
Trust and Agency Funds
Cemetery Trust
Agency Fund-YAKCORPS
Total Other Funds
$622,896 $14,500 $1,847 12.7% $12,000 $0 0.0% $624,743
326,211 610,671 548,383 89.8% 610,671 162,337 26.6% 712,257
$949,107 $625,171 $550,230 88.0% $622,671 $162,337 26.1% $1,337,000
PDFConvert.4056.1.FIN_Report_1st_Qrtr.docx 13 of 14
Fund
Exhibit IV
BOND REDEMPTIONS FUNDS
Actual Revenue Appropriations Ending
Beg Bal Amended Actual % Amended Actual 0/0
Balance
1/1/2014 Budget Revenue Rec'd Budget Exp Exp'd 3/31/2014
GO Bond Redemption
LID Guaranty $25,214 $50 $0 0.0% $0 $0 n/a $25,214
2002 GO Convention Center 159,444 1,016,422 229,250 22.6% 1,015,650 0 0.0% 388,694
2005 GO Various Bonds 9,026 2,986,989 695,090 23.3% 2,987,284 94,307 3.2% 609,809
1995 GO Street, Parks & Fire 186,675 107,230 26,063 24.3% 294,975 0 0.0% 212,738
1996 GO LTD- Cony Center 65,655 428,750 65,470 15.3% 425,940 0 0.0% 131,125
LID Debt Service Control 54,681 270,000 38,688 14.3% 245,000 0 0.0% 93,369
Total G.O. Bond Redemption $500,695 $4,809,441 $1,054,561 21.9% $4,968,849 $94,307 1.9% $1,460,949
Water/Sewer Revenue Bond Redemption
1997 Water Rev Bond Res $271,407 $400 $0 0.0% $0 $0 n/a $271,407
1996 Revenue Bond Reserve 148,463 700 0 0.0% 0 0 n/a 148,463
Water/Sewer Revenue Bonds 114,528 0 0 n/a 0 0 n/a 114,528
1997 Water Revenue Bonds 6,941 240,525 120,250 50.0% 240,500 0 0.0% 127,191
2008 Water/Sewer Rev Bond 2 415,813 207,907 50.0% 415,813 0 0.0% 207,909
Water/Sewer Rev Bond Res 973,700 1,000 0 0.0% 0 0 n/a 973,700
2003 Irrigation Bond Red 35,437 321,504 160,752 50.0% 322,129 96,064 29.8% 100,125
2003 Wastewater Bond Red 965 1,166,344 291,586 25.0% 1,166,344 0 0.0% 292,551
2003 Sewer Rev Bond Res 208,871 0 0 n/a 0 0 n/a 208,871
Total W/S Rev Bond Red $1,760,314 $2,146,286 $780,495 36.4% $2,144,786 $96,064 4.5% $2,444,745
PDFConvert.4056.1.FIN_Report_1st_Qrtr.docx 14 of 14