HomeMy WebLinkAbout12/02/2014 05A 3rd Quarter 2014 Financial Trend Monitoring ReportBUSINESS OF THE CITY COUNCIL
YAKIMA, WASHINGTON
AGENDA STATEMENT
Item No. 5.A.
For Meeting of: December 02, 2014
IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII
ITEM TITLE:
SUBMITTED BY:
SUMMARY EXPLANATION:
3rd Quarter 2014 Financial Trend Monitoring Report
Cindy Epperson, Director of Finance and 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 third quarter 2014, we are seeing typical variances tied to timing --such as debt
service contributions, progress on capital projects, and property tax collections. All of the funds
were reviewed carefully during recent budget preparation, as we estimate year end results to
arrive at a beginning fund balance that becomes part of the available resources for the 2015
budget. The trends in this report were the basis for preparing those estimates. It should be
noted that the appropriation that went to Council in October is not included in these budget
numbers, as it is 4th quarter activity.
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.
General Government (i.e. tax supported) funds including General, Parks & Recreation, and
Street & Traffic Engineering are at 73.3% of budget. Citywide, expenditures are 62.3% of
budget, which is below 75% of the year primarily because of timing of capital projects and debt
service payments. Overall, year -to date results through the third quarter are as anticipated.
Resolution:
Other (Specify): Report
Contract:
Start Date:
Item Budgeted: NA
Funding Source/Fiscal
Ordinance:
Contract Term:
End Date:
Amount:
Impact:
Strategic Priority:
Insurance Required? No
Mail to:
Phone:
APPROVED FOR
SUBMITTAL:
RECOMMENDATION:
Accept Report
ATTACHMENTS:
Description
Public Trust and Accountability
City Manager
Upload Date
2014 3rd Qtr Financial Trend Monitoring Report 11/24/2014
Type
Cover Memo
MEMORANDUM
November 26, 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 3rd Quarter Financial Trend Monitoring Report
We are submitting for your review the City of Yakima's 2014 3rd Quarter actual compared to
budgeted Revenue and Expenditure Report for all city funds.
Overall, the City budget is performing as expected. These results were the basis for the 2014
year-end estimates and 2015 budget development.
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
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
POSITIVE
NORMAL
WARNING
NEGATIVE
PDFConvert.4802.1.FIN_Report_3rd_Qrtr_2014.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)
2013
3rd Qtr Percent
Actual Rec'd
$38,589,206
2,771,854
3,309,389
44,670,449
48,550,759
23,054,665
2,244,840
1,224,533
9,786,550
2,965,841
535,577
$133,033,214
72.6%
67.9%
61.2%
71.3%
Amended
Budget
$58,276,563
4,470,215
4,631,360
2014
3rd Qtr
Actual
$42,049,583
2,841,756
3,070,237
67,378,138 47,961,576
73.8% 66,199,204 49,327,675
43.8% 56,985,847 34,919,484
58.9% 4,809,441 2,567,049
57.5% 2,146,286 1,852,575
66.9% 11,802,538 8,293,912
82.7% 3,360,500 2,922,752
101.4% 625,171 554,413
Percent
Rec'd
72.2%
63.6%
66.3%
71.2%
74.5%
61.3%
53.4%
86.3%
70.3%
87.0%
88.7%
64.6% $213,307,125 $148,399,436 69.6%
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
3rd Qtr
Actual
$38,913,214
3,243,801
3,848,266
46, 005, 281
46,483,625
26,051,938
1,212,952
619,532
8,758,849
3,062,625
531,104
$132,725,906
Percent
Spent
72.0%
78.5%
70.1%
72.2%
2014
Amended 3rd Qtr
Budget Actual
$58,584,566 $42,439,128
4,556,548 3,646,245
4,821,409 3,720,262
67,962,523 49,805,635
70.2% 69,713,439 47,518,149
41.8% 69,020,176 31,752,196
31.7% 4,968,849 1,362,755
29.1% 2,144,786 595,957
59.8% 12,848,523 9,773,512
78.2% 3,371,576 2,666,072
102.7% 622,671 200,279
61.1% $230,652,543 $143,674,555
Percent
Spent
72.4%
80.0%
77.2%
73.3%
68.2%
46.0%
27.4%
27.8%
76.1%
79.1%
32.2%
62.3%
PDFConvert.4802.1.FIN_Report_3rd_Qrtr_2014.docx 2 of 14
GENERAL GOVERNMENT REVENUE ANALYSIS
GENERAL GOVERNMENT REVENUES
2014
Revenues through 9/30 Amended Percent
2012 2013 2014 Budget Receipted
General Sales Tax $9,460,280 $10,603,688 $11,229,097 $15,200,000 73.9%
Crim. Justice Sales Tax 1,994,395 2,118,531 2,343,670 2,970,000 78.9%
Property Tax 8,581,369 9,288,887 9,710,476 15,954,000 60.9%
Utility & Franchise Taxes 8,763,020 10,853,277 11,990,146 15,892,500 75.4%
Charges for Services 5,102,648 4,539,339 5,089,972 7,243,689 70.3%
State Shared Revenue 2,069,372 1,919,876 2,192,093 2,835,400 77.3%
Other Intergovernmental 763,598 1,009,662 875,584 1,320,171 66.3%
Fines and Forfeitures 1,165,827 1,184,825 1,194,294 1,670,000 71.5%
Other Taxes 1,149,237 1,190,025 1,171,275 1,420,500 82.5%
Transfers from other Funds 838,847 957,456 864,931 1,463,000 59.1%
Licenses and Permits 647,654 576,328 679,289 769,200 88.3%
Other Revenue 592,953 428,555 620,749 639,678 97.0%
Total Revenue 41,129,200 44,670,449 47,961,576 67,378,138 71.2%
Beginning Fund Balance 9,948,220 10,908,094 9,927,817 10,883,753
Total Resources 51,077,420 55,578,543 57,889,393 78,261,891 74.0%
Status
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
Sales Tax - This important revenue source is continuing to grow above 2013 levels. Through the third
quarter of 2014, sales tax is 5.9% more than the prior year, and through the eleven months ending in
November, we are 6.4% ahead of 2013 year to date for the same time period. The 2014 budget was
amended to represents a 5.1% growth rate, so this revenue is currently on target to meet or slightly exceed
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 third 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
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.
Utility and Franchise Taxes - This category is demonstrating strong growth, with 2014 exceeding 2013 by
$1,136 869 or 10.5%. However, many of the increases were anticipated in the budget, so that we are only
0.4% over the three quarter mark. 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 $392,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
PDFConvert.4802.1.FIN_Report_3rd_Qrtr_2014.docx 3 of 14
keep growing at the rate experienced in the first half of the year, but it should exceed budgeted amounts by
year end.
Charges for Services - The 2014 budget included an estimate for the street break permit program, but as
that changed from the original proposal, this category is not expected to meet budget estimates. The year-
end estimate was reduced to meet the trend.
Other Intergovernmental - This budget was increased by about $130,000 for the SAFER (i.e. Firefighter
hiring) grant, which was effective in July but not yet billed. When that is factored in, the year-to-date
approximates 75% received.
Fines and Forfeitures - Since the legal department began reviewing charges in preparation for the indigent
defense rule changes, fewer tickets/charges are going forward through the municipal court system. This
revenue is now estimated to be less than the budget, but is still within the 5% range.
Other Taxes - This category consists primarily of Business Licenses and Gambling Taxes. Business licenses
are due in January for the year, so that over 82% of this category has been collected by September 30. The
positive variance is a timing difference, and considered normal.
Other categories all contain some timing exceptions, and are still expected to meet the budget. Overall,
general government revenues are up by about $3,291,000 or 7.4% over 2013—most of these increases were
anticipated in the 2014 budget. 2014 General Government revenues are 71.2% of budget through three
quarters, and with the second half of property taxes due in October, we anticipate year end to approximate
the amended budget which maintains the "normal" ranking.
PDFConvert.4802.1.FIN_Report_3rd_Qrtr_2014.docx 4 of 14
GENERAL GOVERNMENT REVENUES - By Month
2012
2013 2014
Jan 3,668,912 4,451,264 4,833,015
Feb 4,206,186 4,267,636 4,770,111
Mar 4,861,758 4,896,583 4,984,702
Apr 9,388,842 9,758,283 10,717,557
May 4,833,268 4,733,408 4,573,329
Jun 4,146,240 4,168,515 4,307,587
Jul 4,636,431 3,962,439 4,303,677
Aug 3,574,114 3,798,660 4,290,791
Sep 4,250,150 4,758,660 5,180,804
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 47,961,573
10,000,000
7,500,000
5,000,000
2,500,000
0
LtILJTJ}
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
2012
■ 2013
■ 2014
GENERAL GOVERNMENT REVENUES - Cumulative By Month
2012
2013 2014
Jan 3,668,912 4,451,264 4,833,015
Fe b 7,875,098 8,718,900 9,603,126
Mar 12,736,856 13,615,483 14,587,828
Apr 22,125,698 23,373,766 25,305,385
May 26,958,966 28,107,174 29,878,714
Jun 31,105,206 32,275,689 34,186,301
Jul 35,741,637 36,238,128 38,489,978
Aug 39,315,751 40,036,788 42,780,769
Se p 43,565,901 44,795,448 47,961,573
Oct 53,239,407 54,865,479
Nov 57,502,627 58,871,889
Dec 61,519,571 63,513,321
PDFConvert.4802.1.FIN_Report_3rd_Qrtr_2014. docx
5 of 14
GENERAL FUND EXPENDITURE ANALYSIS
GENERAL GOVERNMENT EXPENDITURES
2014
Expenditures through 9/30 Amended Percent
2012 2013 2014 Budget Spent
Police $17,254,228 $18,509,094 $19,323,084 $26,278,167 73.5%
Fire 6,668,241 7,030,665 7,575,817 10,387,649 72.9%
Transfers To Other Funds 1,849,474 1,820,373 2,105,497 3,992,275 52.7%
Information Technology 1,587,448 1,693,116 2,104,796 3,047,612 69.1%
Code Administration 843,962 988,428 2,222,307 2,639,371 84.2%
Financial Services 1,045,959 1,070,925 1,106,231 1,488,836 74.3%
Utility Services 964,059 963,417 985,325 1,465,199 67.2%
Legal 788,629 917,868 1,000,348 1,359,323 73.6%
Municipal Court 856,251 970,018 916,650 1,344,118 68.2%
Police Pension 944,769 1,020,409 881,991 1,343,325 65.7%
Engineering 486,232 495,078 493,312 1,109,632 44.5%
Indigent Defense 353,825 393,529 451,907 650,500 69.5%
Records - City Clerk 448,249 340,575 483,074 583,921 82.7%
Purchasing 363,912 402,960 415,532 549,369 75.6%
Human Resources 318,743 336,660 371,968 513,151 72.5%
Economic Development 0 397,392 377,752 511,733 73.8%
Planning 438,126 424,816 324,060 497,481 65.1%
City Hall Maintenance 247,355 290,090 318,320 422,885 75.3%
City Manager 257,812 273,149 274,864 372,684 73.8%
Gang Free Initiative 0 0 199,216 333,105 59.8%
City Council 195,164 237,674 238,990 290,199 82.4%
Intergovernmental 219,024 259,255 221,940 244,031 90.9%
State Examiner 61,312 77,723 46,147 110,000 42.0%
Position Vacancy Savings 0 0 0 (950,000) 0.0%
Total General Fund 36,192,774 38,913,214 42,439,128 58,584,566 72.4%
Parks & Recreation Fund 3,016,213 3,243,801 3,646,245 4,556,548 80.0%
Street & Traffic Ops. 3,883,701 3,848,266 3,720,262 4,821,409 77.2%
Total General Government $43,092,688 $46,005,281 $49,805,635 $67,962,523 73.3%
Total General Government Fund Expenditures -1.7% Below 75%
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
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 about
72.8% of the annual budget. For comparative purposes, the third quarter of 2013 was 72.2% of budget.
There was an appropriation done in the 4th quarter which added about $950,000 to both the General
Government revenue and expenditure budget -the year end total is estimated to remain below the
amended budget.
PDFConvert.4802.1.FIN_Report_3rd_Qrtr_2014. docx
6 of 14
SIGNIFICANT EXPENDITURE VARIANCES
Normal-Over/under 75% in third quarter, yet comparable to prior years—payment timing variance
• Transfers to Other Funds - This budget includes $2 million for the street renovation project. Since
bonds were issued in May, there are atill sufficient project funds at the end of the third quarter.
When the bond proceeds are depleted, the transfer from General Fund will be made to the complete
the project. Additionally, the transfer for the LIFT program will be done as part of the year end
process, as that fund has adequate cash flow for 2014 activities. This is a 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 72.5% of budget, with the savings related
to position vacancies.
• Engineering - The 2015 budget included the transfer of Traffic Engineering from the Streets Fund
into General Fund, which was to be done in conjunction with the street break ordinance. Also, there
are several vacancies in this Division. These combine so that this operation is about 30.5% below the
3rd quarter target of 75%. Because this also reduces the "Charges for Services" revenue category,
since much of the engineering division's time is charged out to active projects, this operating unit is
still receiving a "Normal" classification.
• 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 half of the year, but now that the
manager is on board, spending levels will increase. The year-end estimate approximates budget.
• City Council - Annual Association of Washington Cities (AWC) dues of $63,000 are paid in the first
quarter, and about $30,000 was expended on the Citizen Survey in the 3rd quarter. This account is
anticipated to end the year very close to its budget.
• Intergovernmental - Most annual dues are paid in full by the end of the third quarter - we
anticipate very little activity in the 4th quarter
• State Examiner - The annual audit does not get under way until the 2nd quarter of the year, and
extends through the end of the year. This is a timing variance.
• Parks and Recreation - Many of the programs are in full swing during the 2nd and 3rd quarters, so
this fund is 80% spent through the end of the 3rd quarter. We anticipate this fund ending the year
within budget.
• Street and Traffic Operations - There was a snow event in the 1st quarter that required more than
average overtime and outside contractors to plow.
Position Vacancy Savings - Shown for fund total purposes only - no "actual" will be charged here.
PDFConvert.4802.1.FIN_Report_3rd_Qrtr_2014.docx 7 of 14
OTHER FUNDS ANALYSIS
OTHER FUNDS REVENUES
2014
Revenues through 9/30 Amended Percent
2012 2013 2014 Budget Rec'd Status
Operating/Enterprise Funds $46,221,232 $48,550,759 $49,327,675 $66,199,204 74.5%
Capital Funds 8,943,637 23,054,665 34,919,484 56,985,847 61.3%
Reserve, Trust & Agency Funds 12,951,064 13,286,968 11,771,077 15,788,209 74.6%
Bond Redemption Funds 4,060,276 3,469,373 4,419,624 6,955,727 63.5%
Total Revenue 72,176,209 88,361,765 100,437,860 145,928,987 68.8%
Beginning Fund Balance 45,711,333 47,394,784 51,022,832 51,022,832
Total Resources 117,887,542 135,756,549 151,460,692 196,951,819 76.9%
OTHER FUNDS EXPENDITURES
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
2014
Expenditure through 9/30 Amended Percent
2012 2013 2014 Budget Rec'd Status
Operating/Enterprise Funds $44,870,714 $46,483,625 $47,518,149 $69,713,439 68.2%
Capital Funds 11,990,875 26,051,938 31,752,196 69,020,176 46.0%
Reserve, Trust & Agency Funds 12,892,208 12,352,578 12,639,863 16,842,770 75.0%
Bond Redemption Funds 3,146,035 1,832,484 1,958,712 7,113,635 27.5%
Total Expenditures 72,899,832 86,720,625 93,868,920 162,690,020 57.7%
NORMAL
NORMAL
NORMAL
NORMAL
NORMAL
Third quarter results are performing as expected. Most variances at this time of the year are related to
timing, especially in capital and bond redemption funds,which is why they are getting a Normal status.
Most Operating/Enterprise Funds are close to the 75% mark for both revenue and expenditures at
September 30. Significant variances are related to timing (i.e. Irrigation operating fund pays all of its ditch
charges to outside irrigation companies in the first half of the year, so it is showing 82.2% spent—this is not
unusual, and the budget is not in jeopardy to be overspent by year end.) Fund balances are within expected
levels at this time of the year for all of these funds.
Capital Fund budgets include the full project, and are not expected to be 100% completed in the current
year. Transit's purchase of buses used fund balance until the grant reimbursement arrives. The
Cumulative Reserve for Capital Improvement Fund contains the Martin Luther King Jr. Blvd railroad
underpass project. This fund is over budget, at the end of the 3rd quarter, but there is a non -lapsing
appropriation (i.e. carry -forward from the 2013 budget) that will be added to this fund. The total revenue
just slightly exceeds the total expenditure, so that the fund balance is unchanged. A listing of the top ten
budgeted projects and their third quarter year-to-date expenses follow.
PDFConvert.4802.1.FIN_Report_3rd_Qrtr_2014.docx 8 of 14
Reserve Funds are under 75% at the end of the third quarter due in part to position vacancies which reduce
the "premiums" paid into the Health Benefit Fund, coupled with the timing of Property Tax receipts
allocation to the Firemen's Relief and Pension Fund. Expenses are up primarily because the Medical
Insurance Fund included a major claim (i.e. over $250,000) in this time frame. This claim has hit the stop
loss reimbursement level, so this claim will not be incurring additional costs to the City in 2014. The
Medical Insurance fund is also experiencing several mid-size claims, so it has used fund balance. We have
developed cost containment options with the insurance consultant that will be implemented at the
beginning of 2015, which are estimated to slow the growth of medical claims so that a 4% increase in rates
in the 2015 budget should be adequate to cover the costs of the program and rebuild the reserves that are
currently being used. The remaining employee benefit related funds are all doing well in 2014, and no rate
increases are included in the 2015 budget for unemployment and workers' compensation funds. Risk
management continues to have challenges, this fund will require a 10% increase in "premiums" from the
operating funds in 2015.
Revenues in Bond Redemption Funds are deposited/transferred ratably throughout the year, but mainly
interest payments are made in the first half of the year - the bulk of debt service principal payments are
made in the last quarter.
PDFConvert.4802.1.FIN_Report_3rd_Qrtr_2014.docx 9 of 14
TOP 10 CAPITAL PROJECTS
Project Number/Description
Total 2014 Actual 2014
Dept Budget Expended Funding Source
2379 Streets Capital Preservation
2376 Airport -Alpha Taxiway
Construction
1818 Railroad Grade Separation
Martin Luther King Blvd
ST $16,500,000 $12,636,476 General Obligation Bond
AIR 11,162,885 1,057,002 FAA Grant
Passenger Facility Charges
ST 4,898,000 4,898,000 State & Federal Grants
Public Works Trust Fund Loan
4,700,000 619,211 Debt Proceeds, Contributions
Charges for Services
W 3,063,938 2,848,766 Drinking Water State
Revolving Fund Loan
WW 2,000,000 0 Charges for Services
1,800,000 327,700 Wastewater Capital Reserves
W 1,500,000 243,151 Charges for Services
2308 Wastewater Facility Improvement WW
2259 Water Treatment Plant Lagoons
2365 Beech St Interceptor Phase III
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
TR 1,300,000 1,288,440 Transit Sales Tax
ST 1,200,000 106,911 Grant
Expected
Completion
FY 2014
FY 2015
FY 2014
FY 2014/15
FY 2014
FY 2014/15
FY 2014/15
FY 2014
FY 2014
FY2015/16
PDFConvert.4802.1.FIN_Report_3rd_Qrtr_2014.docx 10 of 14
EXHIBITS
Exhibit I
OTHER OPERATING/ENTERPRISE FUNDS
Actual Revenue Appropriations Ending
Beg Bal Amended Actual % Amended Actual % Balance
Fund 01/01/14 Budget Revenue Recd Budget Exp Exp'd 09/30/14
Economic Development $239,488 $258,000 $206,643 80.1% $456,622 $321,060 70.3% $125,071
Neighborhood Development 522,381 3,117,321 935,732 30.0% 3,120,096 1,048,933 33.6% 409,180
Community Relations 550,233 551,600 443,235 80.4% 601,850 480,457 79.8% 513,011
Cemetery 54,260 264,950 179,554 67.8% 278,900 190,546 68.3% 43,268
Emergency Services 156,188 1,337,026 826,577 61.8% 1,339,282 823,030 61.5% 159,735
Public Safety Communication 677,659 3,019,937 2,352,222 77.9% 3,219,521 1,987,548 61.7% 1,042,333
Police Grants 256,642 484,000 217,832 45.0% 469,024 256,846 54.8% 217,628
P.B.I.A. (Parking & Bus Impr) 37,680 235,170 154,342 65.6% 244,358 169,389 69.3% 22,633
Trolley 7,150 163,967 125,455 76.5% 166,850 9,329 5.6% 123,276
Front Street Bus Impr Area 5,675 3,335 2,651 79.5% 9,000 1,500 16.7% 6,826
Cony Center (Tourist Promo) 479,522 1,548,250 1,088,239 70.3% 1,483,667 1,073,325 72.3% 494,436
Capitol Theatre 57,158 297,250 226,157 76.1% 342,020 264,796 77.4% 18,519
PFD - Convention Center 261,465 755,750 583,628 77.2% 645,000 476,680 73.9% 368,413
Tourism Promotion Area 73,324 687,000 453,516 66.0% 687,000 453,502 66.0% 73,338
PFD - Capitol Theatre 104,222 575,500 441,770 76.8% 531,000 397,128 74.8% 148,864
Airport Operating 50,113 993,625 753,559 75.8% 1,130,293 769,901 68.1% 33,771
Stormwater Operating Fund 1,463,183 2,165,000 1,636,328 75.6% 2,325,519 1,681,010 72.3% 1,418,501
Transit 606,448 7,660,917 5,000,500 65.3% 8,240,033 5,461,251 66.3% 145,697
Refuse 370,325 5,773,500 4,324,554 74.9% 5,864,823 4,382,712 74.7% 312,167
Wastewater Operating 2,012,348 19,958,357 16,831,343 84.3% 20,363,432 14,971,684 73.5% 3,872,007
Water Operating 3,066,048 7,997,500 6,856,303 85.7% 9,022,649 7,212,255 79.9% 2,710,096
Irrigation 939,053 1,766,100 1,364,099 77.2% 2,063,884 1,696,207 82.2% 606,945
Equipment Rental 4,383,063 5,319,711 3,350,578 63.0% 5,671,800 2,543,347 44.8% 5,190,294
Environmental 524,232 150,000 135,358 90.2% 192,950 28,527 14.8% 631,063
Public Works Admin. 514,760 1,115,438 837,500 75.1% 1,243,866 817,186 65.7% 535,074
Total Other Operating Funds $17,412,620 $66,199,204 $49,327,675 74.5% $69,713,439 $47,518,149 68.2% $19,222,146
PDFConvert.4802.1.FIN_Report_3rd_Qrtr_2014.docx 11 of 14
Fund
Exhibit II
CAPITAL IMPROVEMENT FUNDS
Actual Revenue Appropriations Ending
Beg Bal Amended Actual % Amended Actual % Balance
01/01/14 Budget Revenue Recd Budget Exp Exp'd 09/30/14
Arterial Street $2,181,881 $3,823,975 $1,667,468 43.6% $5,106,566 $1,600,598 31.3% $2,248,751
Central Bus District Capital 163,264 62,400 58,533 n/a 131,000 50,891 38.8% 170,906
Capitol Theatre Construction 72,546 71,927 0 n/a 140,000 0 n/a 72,546
Yakima Redevelopment Area 1,228,687 3,350,000 1,526,213 45.6% 2,473,235 442,776 17.9% 2,312,124
Parks and Recreation Capital 239,590 0 0 n/a 100,000 10,421 10.4% 229,169
Fire Capital 1,116,489 134,500 25,782 19.2% 882,808 161,121 18.3% 981,150
Law and Justice Capital 942,748 382,886 293,103 76.6% 884,796 729,779 82.5% 506,072
Public Works Trust Constr 525,217 676,306 550,492 81.4% 732,773 458,416 62.6% 617,293
REET 2 Capital 585,060 592,000 550,492 93.0% 772,787 672,787 87.1% 462,765
Street Capital 0 16,500,000 14,822,105 89.8% 16,500,000 12,636,476 76.6% 2,185,629
Convention Center Cap Impr 631,396 260,500 195,000 74.9% 402,311 116,071 28.9% 710,325
Reserve for Capital Impr 2,838,419 4,004,489 5,740,543 143.4% 4,948,000 5,730,233 115.8% 2,848,729
Airport Capital 625,020 10,666,597 1,013,427 9.5% 11,162,885 1,057,002 9.5% 581,445
Stormwater Capital Fund 1,360,734 444,000 387,850 87.4% 790,000 3,934 0.5% 1,744,650
Transit Capital Reserve 2,455,220 1,508,507 68,386 4.5% 1,989,000 1,555,448 78.2% 968,158
Wastewater Capital 3,653,495 10,501,900 3,118,600 29.7% 14,857,492 2,020,743 13.6% 4,751,352
Domestic Water Improvement 4,365,386 2,264,800 3,500,929 154.6% 5,525,019 3,879,467 70.2% 3,986,848
Irrigation System Impr 504,332 1,741,060 1,400,561 80.4% 1,621,504 626,033 38.6% 1,278,860
Total Capital Impr Funds $23,489,484 $56,985,847 $34,919,484 61.3% $69,020,176 $31,752,196 46.0% $26,656,772
PDFConvert.4802.1.FIN_Report_3rd_Qrtr_2014.docx 12 of 14
Fund
Exhibit III
RESERVE AND OTHER FUNDS
Actual Revenue Appropriations Ending
Beg Bal Amended Actual % Amended Actual % Balance
01/01/14 Budget Revenue Recd Budget Exp Exp'd 09/30/14
Employee Benefit Reserves
Unemployment Comp Res $394,723 $177,000 $144,756 81.8% $286,582 $107,162 37.4% $432,317
Employees Health Ben Res 3,299,663 9,158,200 6,556,573 71.6% 9,867,703 7,708,527 78.1% 2,147,709
Worker's Compensation Res 1,070,111 1,033,000 802,320 77.7% 1,258,630 926,991 73.7% 945,440
Wellness/EAP 179,929 175,000 0 0.0% 176,300 91,141 51.7% 88,788
Firemens' Relief and Pension 941,110 1,259,338 790,263 62.8% 1,259,308 939,691 74.6% 791,682
Total Employee Ben Reserve $5,885,536 $11,802,538 $8,293,912 70.3% $12,848,523 $9,773,512 76.1% $4,405,936
Operating Reserves
Capitol Theatre Reserve 180,495 500 0 0.0% 71,927 0 0.0% 180,495
Risk Management Reserve 839,065 3,360,000 2,922,752 87.0% 3,299,649 2,666,072 80.8% 1,095,745
Total Operating Reserve $1,019,560 $3,360,500 $2,922,752 87.0% $3,371,576 $2,666,072 79.1% $1,276,240
Trust and Agency Funds
Cemetery Trust $622,896 $14,500 $6,030 41.6% $12,000 $0 0.0% $628,926
Agency Fund-YAKCORPS 333,270 610,671 548,383 89.8% 610,671 200,279 32.8% 681,374
Total Other Funds $956,166 $625,171 $554,413 88.7% $622,671 $200,279 32.2% $1,310,300
PDFConvert.4802.1.FIN_Report_3rd_Qrtr_2014.docx 13 of 14
Fund
Exhibit IV
BOND REDEMPTIONS FUNDS
Actual Revenue Appropriations Ending
Beg Bal Amended Actual % Amended Actual % Balance
01/01/14 Budget Revenue Rec'd Budget Exp Exp'd 09/30/14
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 738,278 72.6% 1,015,650 540,475 53.2% 357,247
2005 GO Various Bonds 9,026 2,986,989 1,340,094 44.9% 2,987,284 702,822 23.5% 646,298
1995 GO Street, Parks & Fire 186,675 107,230 83,656 78.0% 294,975 4,988 1.7% 265,343
1996 GO LTD - Cony Center 65,655 428,750 309,293 72.1% 425,940 42,970 10.1% 331,978
LID Debt Service Control 53,138 270,000 95,728 35.5% 245,000 71,500 29.2% 77,366
Total G.O. Bond Redemption $499,152 $4,809,441 $2,567,049 53.4% $4,968,849 $1,362,755 27.4% $1,703,446
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 240,500 100.0% 240,500 22,750 9.5% 224,691
2008 Water/Sewer Rev Bond 2 415,813 415,813 100.0% 415,813 90,406 21.7% 325,409
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 321,504 100.0% 322,129 322,129 100.0% 34,812
2003 Wastewater Bond Red 965 1,166,344 874,758 75.0% 1,166,344 160,672 13.8% 715,051
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 $1,852,575 86.3% $2,144,786 $595,957 27.8% $3,016,932
PDFConvert.4802.1.FIN_Report_3rd_Qrtr_2014.docx 14 of 14