HomeMy WebLinkAbout04/15/2008 09A 2007 Year-end Budget Revenue and Expenditure Report BUSINESS OF THE CITY COUNCIL
YAKIMA, WASHINGTON
411) AGENDA STATEMENT •
Item No. T- OL.
For Meeting Of : April 15, 2008
ITEM TITLE: 2007 Year -End Budget Revenue & Expenditure Report
SUBMITTED BY: Dick Zais, City Manager
Rita DeBord, Finance Director
Cindy Epperson, Deputy Director of Accounting & Budgeting
CONTACT PERSON/TELEPHONE: Dick Zais, 575 -6040
Rita DeBord, 575 -6070/
Cindy Epperson, 575 -6670 CJ=
SUMMARY EXPLANATION:
As previously projected, actual 2007 budget performance has produced a stable revenue
position and overall departmental expenditures have again been restrained below authorized
budget levels. As a result of these factors, the City's final year -end 2007 financial position is
sound. Growth in General Fund revenue primarily from strong construction activity resulted in
revenues exceeding budget by almost $1.5 million (or 3.4 %). In addition, expenditures were
contained below budget by $1.1 million (or 2.5 %), as a result of strict cost containment
measures implemented by City Management in mid -2007. Therefore, the General Fund was
able to overcome the historical trend of the revenue growth rates being Tess than expenditure
S growth rates for the second consecutive year. Parks and Streets funds (the other tax- supported
funds) also experienced expenditures within current revenues, thereby contributing to reserves.
2008 expenditures are still experiencing pressure from private sector costs in areas such as
equipment; technology; utilities; oil and fuel; and insurance rates; as well as increased public
sector labor costs and related benefits. Future revenue growth is not expected to increase at the
same pace due to the softening in the general economy. In the absence of sustained growth in
City revenues, there will need to be reductions in other City expenditures and services in the
future, to maintain a balanced budget and acceptable reserves. This is the reason Council
established a Budget Committee, beginning in the spring of 2007, to review the sustainability
and prioritization of City services. The Committee is continuing its work for 2009 budget cycle.
Continued...
Resolution Ordinance Contract Other (Specify) 2007 Year -End Report
Funding Source: NA
APPROVED FOR SUBMITTAL:
City Manager
STAFF RECOMMENDATION: Accept Report
BOARD /COMMISSION /COMMITTE RECOMMENDATION: By general consensus, the Budget
• Council Committee recommended acceptance at their April 3, 2008 meeting.
COUNCIL ACTION:
2007 Year -End Budget Revenue and Expenditure Report Agenda Statement — Continued
•
Conclusion:
Given the current state of the local and national economy, the state of the worldwide affairs and
the related potential impacts to all govemment entities, City management has taken a
conservative approach to budgeting of revenues and continues to maintain tight controls on
expenditures. Overall, the 2007 year -end fiscal position of the City of Yakima reflects stable and
responsible budget performance.
•
4110
•
MEMORANDUM
April 10, 2008
TO: The Honorable Mayor and
Members of the City Council
FROM: Dick Zais, City Manage c
Rita DeBord, Finance Director
Cindy Epperson, Deputy Director of Acct & Budget C
SUBJECT: 2007 Year -End Budget Revenue and Expenditure Report
• In accordance with past practice, we are submitting for your review, the City of
Yakima's 2007 year -end actual compared to budgeted Revenue and Expenditure Report
for both Operating and Capital Budgets. Balances shown are subject to final
adjustments made as a result of the year -end closing process. We do not, at this time,
expect that any adjustments will materially affect the balances represented in this
report.
Year -end information is reported by fund, in the following order:
• City -Wide Overview
• General Government Budget Results
• Other Operating / Enterprise Funds
• Capital Funds
• Reserve Funds
• Operating Reserves
• Bond Redemption Funds
• Conclusion
41,
Cje Year-End Report 2007 3 1 of 23
CITY -WIDE OVERVIEW
As previously projected, actual 2007 budget performance has produced a stable revenue
position and overall departmental expenditures have again been restrained below authorized
budget levels. As a result of these factors, the City's final year -end 2007 financial position is
sound. Because of strong construction activity bolstering sales tax and permit fee revenues,
coupled with the flattening of salary costs as all of the bargaining units agreed to freeze base
wages at 2006 levels, the General Fund was able to again overcome the historical trend of
revenue growth rates being less than expenditure growth rates. However, expenditures are
still experiencing pressure from private sector costs in areas such as oil and fuel; equipment;
technology; utilities; and insurance rates. In the absence of continued growth in City revenues,
there will need to be reductions in other City expenditures and services in the future, to
maintain a balanced budget and acceptable reserves. This is the reason Council established a
Budget Committee, beginning in the spring of 2007, to review the sustainability and
prioritization of City services.
As illustrated in Chart I, General Government 2007 budget expenditures were $53,658,280
compared to the amended budget of $55,467,218 -- $1,808,938 or 3.3% less than budget
authorizations. The largest contributor to this variance in General Fund is Information
Systems, which had projects in process at year -end. About one -third of this savings was in the
Streets budget, arising from salary savings from vacancies and timing of purchases for street
repair /traffic signal supplies.
Total 2007 actual expenditure for all funds was $151,827,453 compared to the 2007 amended
budget of $174,813,982 -- $22,986,529 or approximately 13.1% less than the City Council's
authorized appropriation level, primarily due to deferred spending for major Capital
Improvement Projects, which are or will be re- budgeted for 2008.
•
Cje Year -End Report 2007 3 3 of 23 6
Chart I
CITY OF YAKIMA
2007 EXPENDITURE COMPARISON
(Budget vs. Actual - December Year -to -Date)
2007
Amended 2007 Variance
Funds Budget Actual Amount Percent
General $45,360,193 $44,195,770 $1,164,423 2.6%
Parks and Recreation 4,199,143 4,110,659 88,484 2.1%
Street & Traffic Operations 5,907,882 5,351,851 556,031 9.4%
General Gov't Subtotal $55,467,218 $53,658,280 $1,808,938 3.3%
Community Development $3,929,775 . $2,136,382 $1,793,393 45.6%
Utilities /Other Operating 51,151,714 48,461,614 2,690,100 5.3%
Capital Improvement 43,191,174 27,580,593 15,610,581 36.1%
G.O. Bonds/Notes 3,326,605 2,908,258 418,347 12.6%
Water /Sewer Revenue Bonds 3,053,472 2,977,061 76,411 2.5%
Employee Benefit Reserves 12,038,960 11,662,737 376,223 3.1%
Operating Reserves 2,628,064 2,415,700 212,364 8.1%
Trust and Agency Funds 27,000 26,828 172 0.6%
Total $174,813,982 - $151,827,453 $22,986,529 ( 13.1%
(1) Encumbrances: General Government encumbrances (which are not shown here) are $651,824 which reduces
that variance to $1,157,114 or a 2.1% variance from budget. Total encumbrances for all funds are $4,419,804,
which reduces the total variance to $18,566,725 or a 10.6% variance from budget.
411
Cje Year-End Report 2007 3 4 of 23
• GENERAL GOVERNMENT BUDGET RESULTS
Chart II
CITY OF YAKIMA
2007 GENERAL GOVERNMENT PERFORMANCE
(Budget vs. Actual)
General Parks &
Fund Recreation Fund Street Fund Total
Beginning Balance
Amended Budget $5,439,858 $431,032 $1,064,222 $6,935,112
Actual Beginning Balance 5,439,858 431,032 1,064,222 6,935,112
(Gain) Loss
Revenue
Amended Budget $43,536,274 $4,128,701 $5,604,286 $53,269,261
Actual 45,016,353 4,229,066 5,673,698 54,919,117
II) Gain (Loss) $1,480,079 $100,365 $69,412 $1,649,856
Expenditures
Amended Budget $45,360,193 $4,199,143 $5,907,882 $55,467,218
Actual 44,195,770 4,110,659 5,351,851 53,658,280
Difference $1,164,423 $88,484 $556,031 $1,808,938
Ending Balance
Budgeted _ $3,615,939 $360,590 $760,626 $4,737,155
Actual $6,260,441 $549,439 $1,386,069 $8,195,949
Less: Encumbrances 417,501 6,028 228,295 651,824
Net Balance $5,842,940 $543,411 $1,157,774 $7,544,125
(1) Actual General Fund expenses, including encumbrances, were $403,082 less than actual General Fund revenues.
The total General Government 2007 year -end balance, net of encumbrances, equals $7,544,125,
13.6% of the amended budget and $609,013 more than the beginning balance.
Chart III illustrates the General Government Amended 2007 budgets in comparison to actual
• results for major revenue categories and total expenditures. Immediately following this table is
a narrative review of the actual performance of our major resource categories.
Cje Year -End Report 2007 3 5 of 23
Chart III 0
CITY OF YAKIMA
2007 GENERAL GOVERNMENT REVENUE
(Budget vs. Actual - December Year -to -Date)
2007
Amended Actual Variance
Budget To -Date Amount Percent
GENERAL FUND
Revenue
Property Tax $6,851,000 $6,820,513 ($30,487) (0.5 %)
Criminal Justice Sales Tax .1% 842,000 885,966 43,966 5.2%
Criminal Justice Sales Tax .3% 1,435,000 1,492,194 57,194 4.0%
Retail Sales & Use Tax 13,151,500 13,423,269 271,769 2.1%
Franchise Fees 37,000 42,079 5,079 13.7%
Utility Tax 10,317,467 10,492,461 174,994 1.7%
Business License Tax 500,000 523,801 23,801 4.8%
Gambling Tax 985,000 955,484 (29,516) (3.0 %)
Dangerous Bldg Tax Assess. 15,000 21,771 6,771 45.1%
Leasehold Excise Tax 200 4,121 3,921
Police Federal Grants 170,000 216,232 46,232 27.2% 0
Fire Federal Grants 81,390 89,186 7,796 9.6%
Criminal Justice Funds 393,150 582,169 189,019 48.1%
Liquor Excise Tax 341,544 379,327 37,783 11.1%
Liquor Profits 602,690 608,770 6,080 1.0%
School Resource Officers 343,291 342,552 (739) (0.2 %)
Other Intergovermental 263,334 282,110 18,776 7.1%
Licenses and Permits 788,000 982,084 194,084 24.6%
Charges for Service 4,301,008 4,422,803 121,795 2.8%
Fines and Forfeitures 1,294,000 1,420,275 126,275 9.8%
Misc. Revenue 782,700 983,678 200,978 25.7%
Non- Revenue 1,000 5,508 4,508 450.8%
Transfers From Other Funds 40,000 40,000 0 0.0%
Capital Lease Financing 0 0 0 n/a
Total Revenue $43,536,274 $45,016,353 $1,480,079 3.4%
Plus: Beginning Fund Balance 5,439,858 5,439,858 0 0.0%
Total Resources $48,976,132 $50,456,211 $1,480,079 3.0%
Less: Expenditures 45,360,193 44,195,770 1,164,423 2.6%
Ending Fund. Balance $3,615,939 $6,260,441 $ 2,644,502 73.1%
Less: Encumbrances 0 417,501 417,501
Net Fund Balance $3,615,939 $5,842,940 $2,227,001
Cje Year -End Report 2007 3 6 of 23
0 Chart III (Continued...)
2007
Amended Actual Variance
Budget To -Date Amount Perc n
Parks and Recreation Fund
Property Tax $1,938,000 $1,938,000 $0 0.0%
Intergovernmental 181,246 167,291 ($13,955) -7.7%
Charges for Services 767,296 860,125 $92,829 12.1%
Misc. Revenue/Non- Revenue 256,159 240,523 ($15,636) -6.1%
Transfers From Other Funds 986,000 1,023,126 $37,126. 3.8%
Total Revenue $4,128,701 $4,229,065 $100,364 2.4%
Plus: Beginning Fund Balance 431,032 ; 431,032 0 0.0%
Total Resources $4,559,733 $4,660,098 $100,365 2.2%
Less: Expenditures 4,199,143 4,110,659 88,484 2.1%
Ending Fund Balance $360,590 $549,439 $188,849 52.4%
Less: Encumbrances 0 6,028 (6,028)
Net Fund Balance $360,590 $543,411 $182,821 50.7%
0 Street/Traffic Fund
Property Tax $3,920,202 $3,920,202 $0 0.0%
County Road Tax 198,388 161,316 (37,072) -18.7%
Fuel Tax : Street 1,408,146 1,389,297 (18,849) 4.3%
Other Intergovernmental 500 7,000 6,500
Charges for Services 17,000 70,227 53,227 313.1%
Misc. Revenue/Non- Revenue 60,050 125,656 65,606 109.2%
Total Revenue $5,604,286 $5,673,698 $69,412 1.2%
Plus: Beginning Fund Balance 1,064,222 1,064,222 0 0.0%
Total Resources $6,668,508 $6,737,920 $69,412 1.2%
Less: Expenditures 5,907,882 5,351,851 556,031 9.4%
Ending Fund Balance $760,626 $1,386,069 $625,443 82.2%
Less: Encumbrances 0 228,295 228,295
Net Fund Balance $760,626 $1,157,774 $397,148 52.2%
General Government Summary
Resources $60,204,373 $61,854,229 $1,649,856 2.7%
Expenditures 55,467,218 53,658,280 1,808,938 3.3%
Ending Fund Balance 4,737,155 8,195,949 3,458,794 73.0%
Less: Encumbrances 0 651,824 651,824
Net Fund Balance $4,737,155 $7,544,125 $2,806,970 59.3%
Cje Year-End Report 2007 3 7 of 23
General Government Budget Results (Continued...)
General Government Resources
In total, General Fund 2007 actual revenue exceeded the amended budget by $1,480,079.
Significant individual categories demonstrating increases over the amended budget included:
Sales taxes -- up $271,769; Criminal Justice Funds — up $189,019; Licenses and Permits — up
$194,084; and Miscellaneous Revenue (primarily interest earnings) — up $200,978. We had
anticipated most of these increases earlier in our year -end projections.
Sales Tax of $13,423,269 ended the year about 5.7% greater than the 2006 actual of $12,698,230.
A significant portion of this increase is estimated to have been generated by new construction
and sales of durable goods, both of which were precipitated by the low interest rate
environment; the recent annexations that are experiencing infill; and the City's designation as a
Federal Renewal Community, which provides tax benefits for capital investment for job
creation. 2008 is estimated to experience a modest increase of approximately 1.9% in light of
the recent softening in the housing financing market, even though capital construction related
to the Renewal Community designation and other announced commercial structures is
expected to continue. Both Criminal Justice Sales Tax distributions exceeded budget estimates
for the reasons given above.
Criminal Justice Funds received from the state experienced gains of $189,019 over the
amended budget. The major component of this distribution is tied to the City's crime rate as
compared to other cities. With recent improvements in our crime rate, the 2007 budget was
developed with the assumption that the high -crime distribution would be greatly reduced in
the 2 half of the year —the reduction did not materialize, thereby creating the positive
variance.
Licenses and Permits increased by $194,084 over the 2007 amended budget, and $240,592 or
32.4% over 2006 actual levels. This revenue is directly tied to the increased construction
activity noted above in the Sales Tax discussion.
Miscellaneous Revenue was $200,978 or 25% above the 2007 amended budget. Interest
earnings were conservatively estimated coming into 2007, however, market conditions
improved steadily throughout the year, resulting in this gain.
Significant revenue decreases below the 2007 budget included:
Property Taxes — down ($30,487); and Gambling Tax — down ($29,516). Property taxes
experienced a settlement resulting in a significant refund to a large commercial company. The
refunded amount has been added to the 2008 levy, but this did create a reduction in 2007
collections. One Gambling establishment has been experiencing cash flow difficulties, and is
behind in its gambling tax payments. Legal has been apprised, and is now actively pursuing
collection follow -up.
Cje Year-End Report 2007 3 8 of 23
0 General Government Budget Results (Continued...)
The General Fund 2007 -end balance was originally estimated to be $5,302,179 in the 2008
Adopted Budget. However, the net effect of some unanticipated revenue in excess of budget,
expenditure savings and outstanding unpaid purchase orders increased this balance by to a
total of $6,260,441. Bear in mind, however, that the 2008 budget has been amended to provide
for $417,501 in year -end encumbrances, (e.g., 2007 expenditures carry -over to 2008).
The General Fund revised balance for year -end 2008 is estimated to be $4,306,185, and is to
be maintained as a cash flow reserve, and as a reserve for unanticipated fiscal impacts, such
as the continuing escalation in oil/fuel costs. After including encumbrances, a total of
$1,954,256 or 4.0% has been used as a resource to balance the amended 2008 budget.
When the 2007 General Fund revenues (excluding beginning fund balances) are compared to
prior year, there is an increase of $1,223,474 or 2.8% from $43,792,879 to $45,016,353. (See Table
I attached.) The reductions in revenue related to the library annexation were more than offset
by the increase in Sales Tax and Permit fees (described above), and the annualized impact of
annexations effective in 2006 (i.e. Englewood and 96th Avenue), along with the Occidental
annexation effective mid -year 2007.
110 The expenditure budget saw an increase of $1,078,970 or 2.5% over 2006 actual levels. Even
though all bargaining units agreed to freeze wages at 2006 levels and the contribution to the
library of about $1.3 million was eliminated from the 2007 budget, several other factors
combined to create this increase, such as the annualized effect of expenses related to the new
Criminal Justice tax (including salaries and jail costs); start up expenses for the Safe
Community Action Plan (SCAP) program; public safety grants; rate adjustments from the
Washington State Retirement System; and continuing escalation in fuel costs.
With Sales Tax continuing strong growth for the second consecutive year, along with a record
year in Licenses and Permits, General Fund was again able to break the prior trend of
expenditures exceeding revenue and added $820,583 to its beginning balance. However, it
took these extraordinary events to accomplish this. Because of the concern of ongoing
sustainability of services, Council has formed a Budget Committee to review General
Government operations, which started to meet in the spring of 2007. As 2008 unfolds, this
committee will review the various dynamics that affect the budget, and report on those
findings. Continuing escalation in fuel, jail, and pension expenses also prompted City
Management to issue a cost containment directive in the summer of 2007. Staff will continue to
monitor revenues and expenditures
Overall, General Fund Resources, which include the Beginning Fund Balance, were $1,480,079
or 3.02% greater than the 2007 Amended Budget; and were within 0.6% or $320,667 above
year -end estimates presented in the 2008 Budget Wrap -up. General Fund expenditure savings,
• after providing for year -end encumbrances and adjustments, amounted to $746,922 or 1.6% of
the authorized 2007 budget.
Cje Year -End Report 2007 3 9 of 23
General Government Budget Results (Continued...)
Parks and Recreation actual resources were $100,365 or 2.4% more than the amended budget
for 2007. Increases resulted primarily from Park's share of Utility Taxes and participation in
senior travel program revenue. Expenditures were below the authorized amended budget for
2007 by $88,484 or 2.1 %. The year -end balance for the Parks and Recreation Fund of $549,439 is
$118,407 more than the beginning balance.
After providing for $6,028 in 2007 year -end encumbrances, $217,271 of the year -end balance
has been appropriated as a resource to balance the 2008 Budget. Therefore, the Parks Fund
revised balance for year -end 2008 is now estimated to be $332,168.
Street Fund resources were $69,412 or 1.24% greater than the amended budget. Reductions in
Gas tax related to decreased volume of fuel sales state -wide was offset by greater than
anticipated insurance recoveries and charges for street crew work to capital projects.
Expenditures were under budget levels by 9.41% or $556,031, caused primarily by position
vacancies, and low utilization of the 50/50 sidewalk repair program. The year -end balance is
therefore increased by $321,847 to $1,386,069.
After considering encumbrances of $228,295, the Street Fund's revised balance for year -end
2008 is now estimated to be $940,398.
Chart IV summarizes the actual status of General Government expenditures through year -end
2007, and compares these expenditures to amended budget authorization levels.
Cje Year -End Report 2007 3 10 of 23
•
0 Chart IV
CITY OF YAKIMA
2007 GENERAL GOVERNMENT EXPENDITURES
(Budget vs. Actual - December Year -to -Date)
2007 2007 Unexpended / Percent
Amended Expenditures Year -End Uncommitted Spent
Budget To 12/31 /06 Encumbrances Balance Committed
Police $19,525,836 $19,489,297 $20,860 15,679 99.9%
Fire 8,116,743 7,941,374 11,191 164,178 98.0%
Information Systems 2,805,093 2,476,068 327,660 1,365 99.9%
Transfers To Other Funds 2,049,500 2,082,216 0 (32,716) 101.6%
Code Administration 1,495,093 1,492,026 0 3,067 99.8%
Police Pension 1,424,202 1,384,894 11,000 28,308 98.0%
Legal 1,332,188 1,308,276 0 23,912 98.2%
Financial Services 1,291,854 1,219,856 2,861 69,137 94.6%
Municipal Court 1,195,251 1,072,678 0 122,573 89.7%
Engineering 1,151,117 1,029,928 5,000 116,189 - 89.9%
Utility Services 1,030,522 958,592 0 71,930 93.0%
411 Planning 715,885 691,506 5,926. 18,453 97.4%
Human Resources 482,524 410,129 2,586 69,809 85.5%
City Manager 462,076 450,429 735 10,912 97.6%
Records 410,881 365,783 4,682 40,416 90.2%
City Hall Maintenance 397,992 395,937 0 2,055 99.5%
Indigent Defense 371,000 360,797. 0 10,203 97.%
Purchasing 242,209 234,303 0 7,906 96.7%
Intergovernmental 283,417 284,423 0 (1,006) 100.3%
City Council 189,410 182,758 0 6,652 96.5%
SunDome 150,000 150,000 0 0 100.0%
State Examiner 103,000 95,467 0 7,533 92.7%
Urban Area Hearings Exam. 61,000 60,155 25,000 (24,155) 139.6%
Probation Services 48,000 48,233 0 (233) 100.5%
District Court 25,400 10,645 0 14,755 41.9%
Total General Fund $45,360,193 $44,195,770 $417,501. $746,922 98.3%
Parks & Recreation Fund 4,199,143 4,110,659 6,028 82,456 98.0%
Street & Traffic Ops. • 5,907,882 5,351,851 228,295 327,736 94.4%
Total General Government $55,467,218 $53,658,280 $651,824 $1,157,114 97.9%
0
Cje Year -End Report 2007 3 11 of 23
General Government Budget Results (Continued...)
Notable deviations from budgetary authorizations after including year -end encumbrances,
were as follows:
Police Department expenditures after encumbrances were slightly below the amended budget
(only $15,679 or 0.1 %). Savings from position vacancies were more than offset by increased
overtime, fuel, other operating supplies and jail costs, so that the largest General Government
operating unit ended the year spending virtually all of its appropriation.
Fire Department, the 2nd largest General Government budget, also ended the year less than
the amended budget by $164,178; expending 98.0% of its approximately $8.1 million budget.
The retirement of several long -term employees (including the Chief early in 2007 and a Deputy
Chief late in 2006) resulted in salary savings from vacant positions.
Information Systems, when encumbrances for ongoing technology projects are added to actual
expenditures, came in $1,365 below budget. The encumbrances of $327,660 include primarily
the prosecutorial case management, electronic bill paying, and time management systems all in
varying stages of research and implementation.
Transfers to Other Funds ended 2007 $32,716 or 1.6% more than budgeted. This category
includes the transfer of utility taxes to the Parks and Recreation fund. Since utility tax revenue
was greater than originally budgeted, the transfer account is also greater than budgeted.
Several operating divisions in the General Fund ended 2007 under budget primarily due to
salary savings:
• Legal Department expenditures were $23,912 or 1.8% less than budget.
• Financial Services had the newly authorized Treasury Services Officer vacant for the
whole year, thereby ending 2007 $69,137 or 5.4% less than budget. (The position was
ultimately underfilled with an Accountant which started in January 2008.)
• Municipal Court spent $122,573 or 10.3% less than the 2007 budget, because a part -time
Court Commissioner was vacant the entire year (and was subsequently filled half -time
in January 2008). Additionally, there was turnover in the existing staff throughout the
year.
• Engineering was $116,189 or 10.1% under budget, attributable primarily to 3
retirements /resignations throughout the year.
• Utility Services ended 2007 under budget by $71,930 or 7 %. The 2007 budget included
authorization for a new 3 /4 -time Water Service Specialist field position, along with an
upgrade for an existing position to a crew leader. After additional vetting, neither of
these position changes were implemented, and were eliminated from the 2008 budget
as a component of the Finance reorganization. Additionally, there was turnover in the
existing staff.
Cje Year -End Report 2007 3 12 of 23
110 General Government Budget Results (Continued...)
• Planning had a vacancy of a planner for a portion of the year, and ended 2007 $18,453
or 2.6% less than the amended budget.
• Human Resources also experienced salary savings from the vacancy of the Deputy
Human Resources Manager, and spent $69,809 or 14.5% less than its 2007 budget.
Records saved $40,416 or 9.8 %, because election costs were about $36,000 less than budgeted.
Intergovernmental went over budget by $1,006 because of the requirement to use 2% of the
Liquor Board Profits and Liquor Excise Tax for programs for alcoholism programs. As these
revenues exceeded budget, so did the related expense.
City Council saved $6,652 or 3.5% of the 2007 budget, primarily as a result of a reduction in the
volume of printing of council packets. Putting the electronic agenda on the City website, and
the practice of copying large documents to CDs have worked to reduce copying charges.
Urban Area Hearings Examiner actual expenditures matched the 2007 budget. However,
several issues /projects were identified late in the year that will likely require hearings.
Therefore, an estimate of $25,000 was included in the encumbrance ordinance, to appropriate
for these additional costs.
o
District Court reimbursements were less -than the budget by $14,755 or 58.1%. Our
current contract requires the City to remit 100% of payments collected by District Court
back to them to pay for their collection costs -- this is experiencing a decline because of
the age of the outstanding receivables. It should be noted that this expense has
corresponding revenues reflected in the "Fines and Forfeitures" line.
Parks and Recreation experienced a savings of $82,456 or 2.0% below budget, due primarily to
salary savings.
Street and Traffic Operations expenditures (net of encumbrances) were $327,736 - 5.5% less
than budget, primarily due to salary savings, and timing/demand for various supplies.
Cje Year -End Report 2007 3 13 of 23
OTHER OPERATING / ENTERPRISE FUNDS
Table IV attached depicts the City's Operating and Enterprise Funds.
The Economic Development Fund revenues of $155,552 consist of the allocation approved by
the state legislature for economically challenged communities and interest. Expenditures were
$268,300 or 94.6% of budget. This fund includes professional services related to the HUD
Section 108 loan program (such as appraisals, title reports, etc.), the Historic Preservation
program, and other economic development efforts focused primarily on Downtown.
revitalization. Additionally, a small portion of the Community & Economic Development
administrative staff costs are allocated to this budget. The ending fund balance is $222,675,
which will continue to be used to support programs which promote economic development.
The Neighborhood Development Fund ended 2007 with a fund balance of $396,431. Actual
expenditures equaled $2,136.382 - 54.4% of budget, and revenues amounted to $2,267,001 -
58.0% of amended budget. Because of the timing of project costs, this fund typically is
underspent in comparison to total grant authority in any particular year. The encumbrance
ordinance included $2,256,980 to carry - forward into the 2008 budget, which represents the
unspent balance of Federal grants awarded in 2007 and prior. The Marvin Garden project is
the major component in the unspent balance.
Community Relations revenues of $486,513 were 109.1% of the amended budget. Cable
franchise fees demonstrated a 3.0% increase from 2005 actual. Expenditures equaled $529,918 -
81.2% of the 2007 amended budget authorization. The savings were anticipated during budget
preparation, and although there are no encumbrances for this fund, the 2008 budget includes
the re- budgeting of major capital purchases. The year -end fund balance of $839,972 includes
the carry forward of capital grant resources from the cable TV franchise provider, per contract.
The Community Services Fund includes the Healthy Families Yakima grant funded program.
Expenditures of $105,993 were 25.7% of budget, the function of the timing of major components
of the program- -the encumbrance ordinance included the balance of the unspent budget.
Revenues of $92,833 consist of grant reimbursements, donations, and interest. The ending
balance is $542. For the program to continue as designed, donations will need to be secured to
match the grant, as there is a 33% match requirement.
Growth Management Fund has a year -end balance of $24,372. The only activity contemplated
in this fund relates to grant- supported growth management planning projects, which are
rebudgeted in 2008. The cash balance is restricted as program/local match for these grants.
Cje Year-End Report 2007 3 14 of 23
ak Other Operating / Enterprise Funds (Continued...)
Cemetery Fund revenues were $323,169 - 98.3% of amended budget estimates and
expenditures equaled $315,560 - under the amended budget by 3.2% or $10,545. The year -end
Cemetery fund balance is $37,116. Revenues included a subsidy of $125,000 from the Parks and
Recreation Fund that was required to maintain an adequate fund balance.
Emergency Services Fund actual revenues equaled $1,061,930 - 108.7% of budget estimates.
The EMS levy is an allocation based on population and call volume. Because of annexations in
2006, the 2007 allocation increased by 10 %. However, the allocation flattened for the 2008
budget. Expenditures equaled $1,019,794 - 100% of budget. The year -end balance is $219,226.
Public Safety Communications revenues were $2,703,830 - 102.1% of budget and expenditures
equaled $2,449,375 - 92.4% of budget, primarily, the result of a significant reduction in
telephone system costs relating to 911 call - taking of almost $180,000, and salary savings. The
ending fund balance is $432,531, however, the County's 911 contribution in 2008 will be
reduced by the $180,000 of savings - leaving an effective balance of about $250,000.
Parking and Business Improvement (PBIA) Fund actual revenues of $57,198 were 94.4% of
budget estimates and expenditures were $82,826 - 86.4% of budget. The year -end balance is
$34,871, most of which is designated to continue support of the downtown revitalization effort.
III Trolley Fund total revenue was $22,687, while expenditures were $24,873 or 5.4% of budget.
The year -end balance is $1,146. The budget included a reimbursable grant to refurbish the
trolley barn which will be carried forward into 2008.
Front Street Business Improvement Area total revenue was $3,175 - 133.7% of budget and
expenditures for marketing /improving the area were $1,200 - 40.0% of budget. The year -end
balance is $6,180.
Convention Center (Tourist Promotion Fund) actual revenues were $1,336,573 or 105.9% of
budget estimates, as both Hotel/Motel taxes and event revenues were strong throughout the
year. Program expenditures equaled $1,258,433 - 99.1% of the amended budget for 2007. The
year -end fund balance is $162,084, which is well within minimum guidelines.
Public Facilities District Fund realized revenues of $685,590 - 107.1% of the 2007 budget.
Expenditures totaled $644,628 - 99.3% of budget. The ending fund balance is $135,706. It
should be noted that this budget includes a transfer of $480,000 for debt service on the most
recent expansion of the Convention Center. The 2007 bond sale included refunding this bond
issue which reduced debt service by almost $20,000 annually.
Tourism Promotion Area Fund receipts and expenditures amounted to $381,834 or 95.5% of
0 the 2007 budgets. The ending balance at December 31, 2007 is $414. This fund does not build
reserves. Its purpose is to promote Yakima as a tourism destination, and all funds received
each month are forwarded to the Yakima Visitors and Convention Bureau for that purpose.
Cje Year-End Report 2007 3 15 of 23
:,
Other Operating / Enterprise Funds (Continued...)
0
Capitol Theatre Fund actual revenues of $295,370 were 105.8% of amended budget estimates
because of growth in the Cable TV utility tax, and expenditures equaled $281,611 - 100% of the
amended budget. The balance at year -end is $153,965.
Transit Operating Fund revenues of $6,683,700 were 1.4% less than budget estimates.
Approximately $4.2 million of Transit Sales Tax was allocated to this budget, while State and
Federal operating grants were $2.0 million. The remaining $0.5 million is derived from fares,
including the new contract with Selah, vanpool, advertising, etc. Expenditures were $6,386,584
- 93.1% of the amended budget, with about one -half of these savings coming from the Dial -a-
Ride program. The year -end fund balance is $618,031.
Refuse Fund revenues were $3,916,202 - 99.6% of the budget estimate. Actual expenditures
were $3,809,216 - 94.9% of budget. The conversion to automated pick -up continues to reduce
staffing costs in this operation. It should also be noted that the encumbrance ordinance
included $90,000 to purchase a new routing software system, and $33,400 that was this funds
allocation of the 2007 repaving budget for the Public Works parking lot. The year -end fund
balance is $460,308.
Wastewater Operating Fund actual revenues equaled $15,530,512 - 2.8% above amended
budget estimates, notably from higher than anticipated connection charge activity, that also
results in growth in ongoing billing. Expenditures were $15,908,713 - 99.4% of authorized
levels. The year -end fund balance is $2,030,877.
Water Operating Fund actual revenues were $6,831,147 for 2007 - 107.2% of budget estimates,
driven by increased volume, and reimbursement for work done on capital projects.
Expenditures were $6,594,239 - 97.7% of authorized budget levels. The year -end fund balance
is $1,889,503.
Irrigation Fund actual revenues equaled $2,524,231 - 102.3% of budget estimates, again
primarily due to reimbursement for work on capital projects. Expenditures were $2,625,516 or
98.7% of budget. This includes a transfer to the capital fund and debt service fund totaling
$1,251,245 in compliance with the capital charges billed by the irrigation utility. The balance at
year -end was $285,201.
Equipment Rental Fund expenditures equaled $4,553,279 and were 96.1% of the amended
budget. The encumbrance ordinance included $183,022 so that the budget for vehicle
purchases scheduled and begun in 2007 will be carried forward into 2008. Revenues of
$5,412,620 were 107.7% of budget estimates, due to strong interest returns, and additional
contributions made for replacement by Parks, Streets, and Refuse, funded by other salary
savings in these operating budgets. The $3,881,739 year -end balance primarily represents the
City's Equipment Replacement Reserve.
Cje Year -End Report 2007 3 16 of 23
• Other Operating / Enterprise Funds (Continued...)
Environmental Fund revenues equaled $155,944 or 115.5% of budget estimates. Expenditures
were $50,097 or 13.5% of budget, as the contingency account budget was not needed. The
encumbrance ordinance included 2 projects -- $50,000 as a contingency for dirt removal
associated with Richardson Airway, and $33,400 for this fund's allocation of the paving project
at Public Works. The year -end fund balance is $576,877.
Public Works Administration Fund actual revenue for 2007 was $1,151,332 - equal to budget
estimates. Actual expenditures totaled $1,131,552 - less than the amended budget by 2.0 %.
The year -end fund balance is $135,670.
Summary
Other Operating and Enterprise Funds generated revenues of $52,121,643 - 98.4% of budget
estimates; expenditures equaled $50,597,996 and were 91.9% of the authorized budget. The
Total Other Operating Enterprise Funds carry forward fund balance is $12,545,437. (About $3.9
million or 31% of this balance consists of the Equipment Rental Replacement Reserve.) In total,
without considering the Equipment Rental budget, the fund balances average about 17.2% of
the budget, or just slightly more than a 2 month operating reserve.
Cje Year -End Report 2007 3 17 of 23
•
CAPITAL FUNDS
110
Table V represents the fiscal status of Capital Construction and Reserve Fund budgets for 2007.
The Arterial Street Fund reflects an actual expenditure level of 68.6 %, or $4,099,997 for 2007.
The major project substantially completed in 2007 was the signalization /other improvements
on River Road in the vicinity of 16th Avenue, and the widening of W. Nob Hill Blvd. from 68th to
80th Avenue. Incomplete projects to be carried forward into the 2008 budget include the
William 0. Douglas Trail Projects, and the balance of River Road improvements. Revenue
equals $4,598,108 or 84.3% of budget estimates and is derived from Federal and State shared
funds, and bond proceeds for the River Road project. Half -cent Gas Tax funds are allocated
monthly and expenditures are based on an approved project prospectus. The fund balance at
year -end is $1,047,982.
Transportation Improvement Fund originally set up to account for the Gateway project
improvements used the final balance of $37,549 to make repairs to the fountain at that location.
The City's 5 -year obligation for any potential wetland mitigation is expired, and this fund will
be de- activated, as it has no balance as of December 31, 2007.
The Central Business District (CBD) Capital Fund is used to account for comprehensive
downtown planning and redevelopment efforts. This budget contains a small balance for
Phase I, and Phase II of Downtown Redevelopment/Pedestrian project, to be supported by
State grants and bonds issued in the spring of 2007. Expenditures were $2,586,061 - 71.4% of
budget authorizations and revenue totaled $3,852,767 - 106.6% of budget, representing
substantial completion of Phase II. The balance of Phase II is being rebudgeted for 2008. The
year -end balance is $1,680,413.
Capitol Theatre Construction Fund is used to account for capital grants /improvements for the
Theatre. Revenues were $182,731 or 56.2% of the budget representing a Federal grant, while
expenditures were $231,664 or 56.5% of budget. The unspent appropriation will be carried -
forward to 2008. The balance at December 31 is $137,982, most of which represents start up
funds transferred from the Reserve Fund to provide cash flow for reimbursable grants.
The Parks and Recreation Capital Funds actual revenue equaled $235,291 or 117.6% --
(consisting primarily of a transfer of REET 1 resources of $200,000 and interest earnings) while
actual expenditures (consisting primarily of installation improvements to the Southeast
Community Center and major repairs to Lion's pool) through year -end 2007 were $656,361 -
56.5% of the amended budget. The year -end fund balance is $473,823.
The Fire Capital Fund experienced actual expenditures of $1,567,482 - 74.5% of budget,
including the completion of the upgrade to Fire Station 92 (West Valley) and repayment of the
short -term borrowing for this project. Revenues were $2,140,135- 140.4% of budget estimates
primarily because 2007 activity included short -term financing in advance of the bond issued in
Cje Year-End Report 2007 3 18 of 23
Capital Funds (Continued...)
the spring of 2007. (These revenues also included a transfer of $200,000 of REET 1, which can
be used for Fire capital needs relating to property/building improvements, but not rolling
stock.) The encumbrance ordinance included about $250,000 representing the balance of the
Pumper Truck and replacement of a Fire Command vehicle. The year -end balance is $543,326.
Law and Justice Capital Fund revenue, which included an allocation of Local Criminal Justice
Sales Tax receipts, was $913,721 or 127.3% of budget. The excess revenue was generated
primarily by growth in the Cable TV utility tax dedicated to Criminal Justice capital purposes,
capital grants and interest. Project and equipment expenditures for the facilities were $953,479
- 91.8% of authorized levels. The encumbrance ordinance included $10,000 for furnishings for
the new part -time Court Commissioner. The "fund balance at year -end was $519,571.
The Public Works Trust Construction Fund accounts for the revenue generated by the first
1 /4% Real Estate Excise Tax (REET 1) and expenditures (including debt service) for General
Government projects associated with the State Public Works Trust Fund Loan Program.
Receipts for 2007 totaled $1,218,237. Of this amount, about $1,056,000 represents REET 1
proceeds; $87,000 represents interest and $75,000 are transfers from other funds for debt
service. Expenditures were $772,861 or 70.9% of budget during 2007. Savings resulted from
the deferment of City Hall planned improvements. The balance at year -end is $2,027,808.
The Real Estate Excise Tax — 2nd 1 /4% (REET 2) Capital Fund accounts for the 2nd 1 /4% Real
Estate Excise Tax, and related interest earnings. Revenue was $1,108,917- 147.9% of the
budget. Expenditures were $797,381 - 52.0% of budget, as the contingency budget was not
needed, and the supplies charged by the Street budget was not completely used. The balance
at year end is $1,273,152.
The LID Construction Control Fund is used to account for the resources and costs associated
with LID projects. Expenses for these projects are incurred and paid for through up -front
interest bearing warrants which are redeemable when the projects are completed from
individual pay -off's in full or from the proceeds of bond sales for that portion of the project or
projects to be financed over several years. The year -end fund balance is ($37,412) as there was
one LID construction project in start-up phase as. of December 31, 2007.
The Transit Capital Reserve Fund has a year -end balance of $2,241,353 which represents the
reserves that the City Council has directed be set aside to provide funds for equipment
replacement since the federal grant programs for Transit capital equipment have been phased
out. For 2007, the actual expenditures were $61,835 - 13.7% of budget. Encumbrances include
about $230,000 for Transit's allocation of the Public Works repaving project and the purchase of
vans for the vanpool program. Revenues were $605,490 - exceeding budget estimates by
$362,490, a function of strong sales tax coupled with a decrease in Dial -a -Ride expenses which
• frees up sales tax for capital purposes.
Cje Year-End Report 2007 3 19 of 23
Capital Funds (Continued...)
The Convention Center Capital Improvement Funds actual revenues were $139,700 consisting
primarily of an allocation of Hotel/Motel tax, while expenditures were $64,997 - 45.1% of
budget. As Hotel/Motel tax experienced a total increase of $129,000 or a growth rate of over
12 %, most of this growth was allocated to the capital fund, which resulted in the revenues
exceeding budget by $97,200. The year -end balance is $216,660, with about $17,000 being
earmarked for encumbrances.
The Cumulative Reserve for Capital Improvement Funds actual expenditures were $3,981,060
- 54.9% of amended budget primarily for preliminary Railroad /Grade Separation costs, which
is being funded by State and Federal grants. Revenues were $4,147,735, and the balance at
year -end is $168,250. (Most of the railroad project is already rebudgeted in 2008).
The purpose of the Wastewater Facilities Capital Reserve Fund is to provide resources for
major repairs /maintenance at the plant annually. Revenues equaled $153,280 - 6.3% of the
amended budget, and are derived from Sewer Operating contributions, Sewer Service
Agreements with Union Gap and Terrace Heights, and investment income. There were
expenditures for capital improvements and repairs of $19,620 - 0.7% of the budget
authorization. The fund balance at year -end is $885,748. It should be noted that the ultraviolet
disinfection project funded by the recently awarded Public Works Trust Fund Loan of $2.3
million and a budget of $2.645 million was originally budgeted in this fund in 2007, but was
later determined to be better categorized in the Wastewater Facility Project fund.
The Sewer Construction Fund provides principally for off -site system improvements such as
new interceptor and trunk line extensions. For 2007, $1,293,114 in revenue was provided
primarily from a Public Works Trust Fund loan for River Road improvements of $1,153,500,
Wastewater Operating Fund transfer of $100,000, and investment income. Expenditures of
$2,793,253 were primarily for the continuation of a Wastewater project done in conjunction
with the River Road improvement project. The year -end balance is $931,465.
In 2007 the Domestic Water Improvement. Fund expenditures totaled $473,612 - 37.9% of
budget, and included the 2 level reservoir pipe line improvement, and other watermain
replacement projects. Revenue to this fund totaled $508,000 and included $500,000 from the
Water Operating fund and $8,000 of interest earnings. The 2007 year -end balance is $1,513,820.
Wastewater Facility Project Fund actual expenditures for 2007 were $6,063,648 - 98.2% of
budget, for treatment plant projects. Actual revenues were $3,224,762 consisting primarily of
$2,558,000 from the Wastewater Operating fund, Public Works Trust Fund loan proceeds of
$460,000 (see discussion on the ultraviolet disinfection project above), and $106,000 of interest
earnings. The year -end balance is $1,315,240 to be used for the continuation of the capital
program at the wastewater facility.
Cje Year -End Report 2007 3 20 of 23
• Capital Funds (Continued...)
The Irrigation System Improvement Fund was opened in 1998 to account for capital
improvement projects. For 2007, revenue totaled $1,001,562 consisting of a $896,930 transfer
from operations, and interest earnings. Expenditures were $2,388,099 or 60.6% of the budget,
which were spent primarily on the General, Bracket Park, and Glen Drive systems leaving a
balance of $4,507,608. Construction on various sections of the system will be carried forward
into the 2008 budget.
Summary
Capital Improvement Funds received revenues of $25,330,270 — 85.6% of budget estimates;
expenditures equaled $27,580,593 and were 63.9% of the authorized budget. The carry forward
fund balance is $19,446,789. Incomplete project balances were either already carried forward in
the 2008 budget, or will be recorded as non - Lapsing appropriations.
•
•
•
Cje Year -End Report 2007 3 21 of 23
RESERVE FUNDS
Table VI reflects the status of the City's Reserve Funds at year -end 2007.
The Unemployment Compensation Reserve provides for unemployment claims filed by
former employees. Through year -end 2007, the City had actual expenditures of $109,920 —
72.4% of the amended budget. Revenues were $159,269 — 4.1% above budget. The reserve
balance at year -end is $459,798. Since the fund balance was increased significantly in 2007,
rates were reduced by 50% for 2008.
The Employees Health Benefit Reserve provides for group medical, vision and dental claims
for present, retired and terminated City employees and eligible dependents. Actual
expenditures through year -end were $8,691,744 — 99.8% of the amended budget. Revenue of
$8,697,994 was 103% of the amended budget, so that 2007 virtually "broke even ". The year -end
balance is $3,513,674, before the estimate for incurred but unpaid claims.
Financial Disclosure requirements prescribe that liabilities be recognized when incurred. The
self - insurance auditor recommended that we record 15% of the annual paid claims as a
liability. Therefore, $1,161,993 . in medical and dental claims representing 15% of the prior 12 months
will be recorded as a liability in the financial statements. The ending fund balance after considering this
transaction will be $2,351,681.
To accommodate health -care industry inflation coupled with the City's experience, rates were
increased by about 4% for the 2008 budget. Affordable insurance coverage continues to be the
focus of the Insurance Board, and there was a change in plan design for 2008 that added
preventative coverage, and reduced the number of doctor's visits paid at 100 %. Although this
is projected to be expense neutral in the near term, this change is designed to result in healthier
employees by catching major illnesses early and, therefore, better claims experience over time.
The Worker's Compensation Reserve provides for payment by the City of Industrial Insurance
claims and time loss for City employees who are injured in the performance of their assigned
duties. Revenues were $1,134,381 - 110.6% of budget estimates and expenditures were
$1,242,336 — 95.3% of the amended budget. The Reserve Fund balance of $1,215,705 is the cash
balance. For the same reasons discussed above, a liability will be presented in the financial
statements of about $792,000, which will leave the fund balance of about $425,000. Though
cash reserves were reduced in 2007, the base rates were unchanged for the 2008 budget, but a
surcharge was added to the Divisions generating the majority of large claims.
Firemen's Relief and Pension expenditures were $1,497,086 — 85.7% of budget through
year -end 2007. Actual revenues were $1,618,925 — 101.3% of budget. The fund balance at
year -end is $645,853, and reflects the Pension Board's policy to build reserves for potential
long -term medical care needs of the LEOFF I retirees.
Cje Year-End Report 2007 3 22 of 23
• OPERATING RESERVES
Table VI illustrates the position of the City's Contingency Reserve Funds.
General Contingency Fund -- The year -end balance is $359,070.
Capitol Theatre General Contingency Reserve -- For 2007, $71,927 was transferred to the
Capitol Theatre Operating Fund to fund the Theatre's annual capital improvement program.
Interest earnings of $20,795 were added as revenue, leaving a year -end balance of $575,070.
The Risk Management Reserve Fund was established to provide for payment of insurance
coverages and for claims incurred for liability losses. Annual allocations are made by City
operating departments to this fund. Total revenues received were $2,496,656, and expenditures
equaled $2,278,436. Major expenses included: $438,700 in payments for claims, $665,900 for
outside legal services, $63,500 for Brokers and claims adjustment fees, $228,000 for property
insurance coverage, and $584,000 for general liability insurance.
The year -end Risk Management fund balance is $1,037,963, before outstanding claims are
considered. The required claim reserve at December 31, 2007 is estimated to be about $1.1
• million, which will result in an underfunded balance of about ($62,000) to be reported in the
2007 financial statements. As the balance has improved from a negative ($300,000) at the end
of 2006, the 2008 budget included a 5% rate adjustment to pay the balance of outstanding
claims, continued professional support, and rebuild reserves. This reserve balance will also be
monitored for adequacy throughout 2008, and may require enhanced contributions from
operating funds.
BOND REDEMPTION FUNDS
Table VII illustrates the financial position of the City's General Obligation and Revenue Bond
Funds. Reserve balances are in compliance with bond covenants.
CONCLUSION
Given the current state of the local and national economy, the state of worldwide affairs
and the related potential impacts to all government entities, City management has
taken a conservative approach to budgeting of revenues and continues to maintain tight
controls on expenditures. Overall, the 2007 year -end fiscal position of the City of
Yakima reflects stable and responsible budget performance.
Cje Year-End Report 2007 3 23 of 23
City of Yakima Table I
Page 1 of 2 General Government Resources 100.0%
3 Year Comparison - December Year to Date of Year
General Fund Resources: 2005 2006 2007
Percent Percent Amended Percent
To -Date Received To -Date Received Budget To -Date Received
Property Tax $6,992,394 100.5% $7,363,765 102.6% $6,851,000 $6,820,513 99.6%
Criminal Justice Sales Tax Inc .3% 663,203 114.9% 1,447,810 108.2% 1,435,000 1,492,194 104.0%
Criminal Justice Sales Tax 779,523 109.0% 842,347 107.3% 842,000 885,966 105.2%
Sales Tax $11,970,427 104.3% 12,698,230 110.7% 13,151,500 13,423,269 102.1%
Franchise Tax
Nob Hill Water Assn. - -2.0% $31,456 98.3% $39,492 123.4% $37,000 $42,079 113.7%
Natural Gas -- 2.0% 395,362 100.6% 303,828 91.5% 0 0 n/a
Total Franchise Tax $426,818 100.4% $343,320 94.3% $37,000 $42,079 113.7%
Utility Tax
Pacific Power -- 6.0% $2,615,662 102.6% $2,831,923 103.0% $2,868,792 $2,939,163 102.5%
Nob Hill Water Assn. - -14.0% 221,290 100.1% 276,011 124.9% 274,933 296,557 107.9%
Natural Gas -- 6.0% 749,128 103.5% 1,457,627 169.5% 1,500,000 1,496,781 99.8%
Yakima Waste Systems - -10.0% 343,984 100.0% 351,536 100.0% 354,025 340,386 96.1%
Cellular Telephone -- 6.0% 1,023,903 105.6% 1,186,886 115.8% 1,137,784 1,211,476 106.5%
Telephone -- 6.0% 1,274,660 96.2% 1,129,890 86.3% 1,203,480 1,115,985 92.7%
Water -- 14.0% 745,425 103.0% 852,016 102.7% 830,000 872,853 105.2%
Sewer -- 14.0% 1,855,898 110.8% 1,886,184 109.0% 1,808,453 1,864,131 103.1%
Refuse -- 9.0% 315,418 98.0% 347,126 107.5% 340,000 355,130 104.5%
Total Utility Tax $9,145,368 103.3% $10,319,199 109.8% $10,317,467 $10,492,461 .101.7%
Business License Tax $510,885 102.2% $505,021 101.0% $500,000. $523,801 104.8%
Gambling Tax 1,035,396 982% 927,582 86.8% 985,000 955,484 97.0%
Dangerous Bldg Tax Assessment 21,055 n/a 13,496 n/a 15,000 21,771 145.1%
Leasehold Excise Tax (2,905) - 1452.5% 9,744 4872.0% 200 4,121 2060.6%
Total Taxes $31,542,164 103.2% $34,470,514 107.3% $34,134,167 $34,661,659 101.5%
Police Federal Grants $29,596 98.7% $68,508 25.4% $170,000 $216,232 127.2%
Fire Federal Grants 57,558 117.5% 42,814 73.0% 81,390 89,186 109.6%
Criminal Justice Funds 234,778 131.6% 425,553 109.9% 393,150 582,169 148.1%
Liquor Excise Tax 327,285 105.9% 351,733 109.9% 341,544 379,327 111.1%
Liquor Profits 563,761 97.2% 533,904 87.5% 602,690 608,770 101.0% .
School Dist. #7 Resource Officers 333,292 100.0% 332,552 96.9% 343,291 342,552 99.8%
Other Intergovernmental 217,718 105.8% 360,708 133.9% 263,334 282,110 107.1%
T tergovernmental $1,763,988 104.7% 0,772 93.7% $2,195,399 $2,500,346 113.9%
cje /wla008 4:22 PM Table I II
4110 Cityikima Table I ill
Page 2 of 2 General Government Resources 100.0%
3 Year Comparison - December Year to Date of Year
General Fund Resources (Contd.) 2005 2006 2007
Percent Percent Amended Percent
To -Date Received To -Date Received Budget To -Date Received
Licenses and Permits $690,850. 118.2% $741,492 125.3% $788,000 $982,084 124.6%
Charges for Service 4,290,541 101.5% 4,182,839 101.9% 4,301,008 4,422,803 102.8%
Fines and Forfeitures 1,190,300 81.4% 1,309,431 99.5% 1,294,000 1,420,275 109.8%
Misc. Revenue 792,858 132.5% 832,143 131.6% 782,700 983,678 125.7%
Non - Revenue 321 0.3% 100,688 99.7% 1,000 5,508 550.8%
Transfers From Other Funds 90,000 81.8% 40,000 36.4% 40,000 40,000 100.0%
Capital Lease Financing 0 0 0 0
Total General Fund Revenue $40,361,022. 102.6% $43,792,879 104.3% $43,536,274 $45,016,353 103.4%
Beginning Balance 5,175,976 100.0% 4,762,269 100.0% 5,439,858 5,439,858 100.0%
Total General Fund Resources $45,536,998 102.3% $48,555,148 103.9% $48,976,132 $50,456,211 103.0%
Parks & Recreation Fund Resources:
Property Tax $1,841,985 100.0% $1,901,985 103.3% $1,938,000 $1,938,000 100.0%
Intergovernmental 85,493 166.0% 97,308 114.3% 181,246 167,291 92.3%
Charges for Services 708,186 85.8% 686,391 86.1% 767,296 860,125 112.1%
Misc. Revenue/Non- Revenue 224,321 135.4% 253,035 124.2% 256,159 . 240,523 93.9%
Transfers From Other Funds 963,710 105.3% 1,015,105 105.9% 986,000 1,023,126 103.8%
Total Parks/Rec. Fund Revenue 3,823,695 100.6% 3,953,824 101.7% 4,128,701 4,229,066 102.4%
Beginning Balance 472,283 100.0% 479,487 100.0% • 431,032 431,032 100.0%
Total Parks/Rec. Fund Resources • • 4,295,978 100.6% 4,433,311 101.5% 4,559,733 4,660,098 102.2%
Street/Traffic Fund Resources:
Property Tax • $3,174,357 97.7% $3,314,344 100.0% $3,920,202 $3,920,202 100.0%
County Road Tax 152,640 79.6% 508,416 98.1% 198,388 161,316 81.3%
Fuel Tax - Street 1,164,787 102.3% 1,299,298 104.9% 1,408,146 1,389,297 98.7%
Other Intergovernmental 35,086 100.0% 0 0.0% 500 7,000 1400.0%
Charges for Services 67,751 118.9% 34,449 202.6% 17,000 70,227 413.1%
Misc. Revenue/Non- Revenue 133,746 667.1% 49,152 489.1% 60,050 125,656 209.3%
Total Street/Traffic Fund Revenue $4,728,367 100.8% $5,205,659 102.1% $5,604,286 $5,673,698 101.2%
Beginning Balance 1,148,043 100.0% 1,133,674 100.0% 1,064,222 1,064,222 100.0%
Total Street/Traffic Fund Resources $5,876,410 100.6% $6,339,333 101.7% $6,668,508 $6,737,920 101.0%
Total General Government Resources $55,709,386 102.0% $59,327,792 103.5% $60,204,373 $61,854,229 102.7%
cje /wla 4/10/2008 4:22 PM Table 1
City of Yakima Table II
General Government Summary of Operations 100.0%
3 Year Comparison - December Year to Date Of Year
2005 2006 2007
Percent Percent Percent
Received Received Amended Received
To -Date Expended To -Date Expended Budget To -Date Expended
General Fund
Beginning Balance $5,175,976 $4,762,269 $5,439,858 $5,439,858
Revenues 40,361,022 102.6% 43,792,879 104.3% 43,536,274 45,016,353 103.4%
Expenditures 40,776,797 98.0% 43,116,800 98.3% 45,360,193 44,195,770 97.4%
Ending Balance $4,760,201 $5,438,348 $3,615,939 $6,260,441
Parks and Recreation Fund -
Beginning Balance $472,283 $479,487 $431,032 $431,032
Revenues 3,823,695 100.6% 3,953,824 101.7% 4,128,701 4,229,066 102.4%
Expenditures 3,816,461 97.3% 4,001,793 98.2% 4,199,143 4,110,659 97.9%
Ending Balance $479,517 $431,518 $360,590 $549,439
Street/Traffic Fund
Beginning Balance $1,148,043 $1,133,674 $1,064,222 $1,064,222
Revenues 4,728,367 100.8% 5,205,659 102.1% 5,604,286 5,673,698 101.2%
Expenditures 4,742,736 89.9% 5,275,112 95.5% 5,907,882 5,351,851 90.6%
Ending Balance $1,133,674 $1,064,221 $760,626 $1,386,069
Total General Government
Beginning Balance $6,796,302 $6,375,430 $6,935,112 $6,935,112
Revenues 48,913,084 102.3% 52,952,362 103.9% 53,269,261 54,919,117 103.1%
Expenditures 49,335,994 97.1% 52,393,705 98.0% 55,467,218 53,658,280 96.7%
Net General Government Balance $6,373,392 $6,934,087 $4,737,155 $8,195,949
cewla/ III
J 4110
Table III
• City of Yakima
General Government Expenditures
2007 Budget vs. Actual
2007 2007
Amended Expenditures Year -end Unexpended Percent
Budget as of 12/31/07 Encumbrances Balance Spent
Police $ 19,525,836 $ 19,489,297 $ 20,860 $ 15,679 99.9%
Fire 8,116,743 7,941,374 11,191 164,178 98.0%
Information Systems 2,805,093 2,476,068 327,660 1,365 100.0%
Transfers To Other Funds 2,049,500 2,082,216 - 32,716 101.6%
Code Administration 1,495,093 1,492,026 3,067 99.8%
Police Pension 1,424,202 1,384,894 11,000 28,308 98.0%
Legal 1,332,188 1,308,276 23,912 98.2%
Financial Services 1,291,854 1,219,856 2,861 69,137 94.6%
Municipal Court 1,195,251 1,072,678 122,573 89.7%
Engineering 1,151,117 1,029,928 5,000 116,189 89.9%
Utility Services 1,030,522 958,592 71,930 93.0%
Planning 715,885 691,506 5,926 18,453 97.4%
0 Human Resources 482,524 410,129 2,586 69,809 85.5%
City Manager 462,076 450,429 735 10,912 97.6%
Records 410,881 365,783 4,682 40,416 90.2%
City Hall Maintenance 397,992 395,937 2,055 99.5%
Indigent Defense 371,000 360,797 10,203 97.2%
Purchasing 242,209 234,303 7,906 96.7%
Intergovernmental 283,417 284,423 -1,006 100.4%
City Council 189,410 182,758 6,652 96.5%
SunDome 150,000 150,000 0 100.0%
State Examiner 103,000 95,467 7,533 92.7%
Urban Area Hearings Exam. 61,000 - 60,155 25,000 - 24,155 139.6%
Probation Services 48,000 48,233 -233 100.5%
District Court 25,400 10,645 14,755 41.9%
Total General Fund $ 45,360,193 $ 44,195,770 $ 417,501 746,922 98.4%
Parks & Recreation Fund 4,199,143 4,110,659 6,028 82,456 98.0%
Street & Traffic Ops. 5,907,882 5,351,851 228,295 327,736 94.5%
Total General Government $ 55,467,218 $ 53,658,280 $ 651,824 1,157,114 97.9%
•
cje 4/10/2008
Table IV
City of Yakima
Other Operating/Enterprise Funds
2007 Budget vs. Actual
Actual Revenue Appropriations
Beginning % % Ending
Other Operating/ Balance Amended Actual Re- Amended Actual Ex- Balance
Enterprise Funds 1/1/2007 Budget Revenue ceived Budget Expenditures pended 12/31/2007
Economic Development $ 335,423 $ 100,000 $ 155,552 155.6% $ 283,695 $ 268,300 94.6% $ 222,675
Neighborhood Development 265,812 3,909,863 2,267,001 58.0% 3,929,775 2,136,382 54.4% 396,431
Community Relations 883,377 445,850 486,513 109.1% 652,467 529,918 81.2% 839,972
Community Services 13,702 407,067 92,833 22.8% 412,689 105,993 25.7% 542
Growth Management 0 19,778 69,966 42,700 61.0% 89,745 38,106 42.5% 24,372
Cemetery 29,507 328,779 323,169 98.3% 326,105 315,560 96.8% 37,116
Emergency Services 177,057 977,213 1,061,930 108.7% 1,019,794 1,019,761 100.0% 219,226
Public Safety Communications 178,076 2,648,554 2,703,830 102.1% 2,651,440 2,449,375 92.4% 432,531
P.B.I.A. (Parking & Business Imp.) 60,499 60,600 57,198 94.4% 95,911 82,826 86.4% 34,871
Trolley 3,332 461,254 22,687 4.9% 463,388 24,873 5.4% 1,146
Front Street Business Imp. Area 4,205 2,375 3,175 133.7% 3,000 1,200 40.0% 6,180
Convention Center
(Tourist Promotion) 83,944 1,262,300 1,336,573 105.9% 1,269,647 1,258,433 99.1% 162,084
Public Facilities District 94,744 640,000 685,590 107.1% 649,000 644,628 99.3% 135,706
Tourism Promotion Area 414 400,000 381,834 95.5% 400,000 381,834 95.5% 414
Capitol Theatre 140,206 279,267 . 295,370 105.8% 281,616 281,611 100.0% 153,965
Transit 320,915 6,777,573 6,683,700 98.6% 6,860,951 6,386,584 93.1% 618,031
Refuse 353,322 3,932,210 3,916,202 99.6% 4,015,321 3,809,216 94.9% 460,308
Wastewater Operating . 2,409,078 15,104,601 15,530,512 102.8% 16,001,642 15,908,713 99.4% 2,030,877
Water Operating 1,652,595 6,374,937 6,831,147 107.2% 6,752,388 6,594,239 97.7% 1,889,503
Irrigation 386,486 , 2,468,497 2,524,231 102.3% 2,659,949 2,625,516 98.7% 285,201
Equipment Rental 3,022,398 5,024,929 5,412,620 107.7% 4,736,503 4,553,279 96.1% 3,881,739
Environmental 471,030 135,000 155,944 115.5% 371,350 50,097 13.5% 576,877
Public Works Admin. 115,890 1,151,365 1,151,332 100.0% 1,155,113 1,131,552 98.0% 135,670
Total Other Operating Funds $ 11,021,790 $ 52,962,200 $ 52,121,643 98.4% $ 55,081,489 $ 50,597,996 91.9% $ 12,545,437
cie 4/1
ill ill
• •
City of Yakima
Capital Improvement Funds
2007 Budget vs. Actual
Actual Revenue Appropriations
Beginning % % Ending
Balance Amended Actual Re- Amended Actual Ex- Balance
Capital Improvement Funds 1/1/2007 Budget Revenue ceived Budget Expenditures pended 12/31/2007
Arterial Street $ 549,871 $ 5,452,586 $ 4,598,108 84.3% $ 5,973,880 $ 4,099,997 68.6% $ 1,047,982
Transportation Improvement 30,829 0 6,720 37,549 37,549 0
Central Business District Capital 413,707 3,615,500 3,852,767 106.6% 3,622,226 2,586,061 71.4% 1,680,413
Capitol Theatre Construction 186,915 325,085 182,731 56.2% 410,085 231,664 56.5% 137,982
Parks and Recreation Capital 894,893 200,000 235,291 117.6% 813,000 656,361 80.7% 473,823
Fire Capital (29,327) 1,524,459 2,140,135 140.4% 2,103,374 1,567,482 74.5% 543,326
Law and Justice Capital 559,329 717,870 913,721 127.3% 1,038,813 953,479 91.8% 519,571
Public Works Trust Construction 1,582,432 825,000 1,218,237 147.7% 1,090,514 772,861 70.9% 2,027,808
REET 2 Capital 961,616 750,000 1,108,917 147.9% 1,532,025 797,381 52.0% 1,273,152
LID Construction Control _ (5,778) 500,000 0 0.0% 500,000 31,634 6.3% (37,412)
Transit Capital Reserve 1,697,698 243,000 605,490 249.2% 451,546 61,835 13.7% 2,241,353
Convention Center
Capital Improvement 141,957 42,500 139,700 328.7% 144,000 64,997 45.1% 216,660
Reserve for Capital Improvement 1,575 7,040,100 4,147,735 58.9% 7,256,969 3,981,060 54.9% 168,250
Wastewater Facilities
Capital Reserve 752,088 2,452,000 153,280 6.3% 2,795,000 19,620 0.7% 885,748
Sewer Construction 2,431,604 1,904,350 1,293,114 67.9% 4,057,929 2,793,253 68.8% 931,465
Domestic Water Improvement 1,479,432 508,000 508,000 100.0% 1,248,216 473,612 37.9% 1,513,820
Wastewater Facility Project 4,154,126 2,582,204 3,224,762 124.9% 6,176,829 6,063,648 98.2% 1,315,240
Irrigation System Improvement 5,894,145 921,000 1,001,562 108.7% 3,939,219 2,388,099 60.6% 4,507,608
Total Capital Improvement Funds $ 21,697,112 $ 29,603,654 $ 25,330,270 85.6% $ 43,191,174 $ 27,580,593 63.9 %, .$ 19,446,789
cje 4/10/2008
Table VI
City of Yakima
Reserves and Other Funds
2007 Budget vs. Actual
Actual Revenue Appropriations
Beginning % % Ending
Employee Benefit Balance Amended Actual Re- . Amended Actual Ex- Balance
Reserves 1/1/2007 Budget Revenue ceived Budget Expenditures pended 12/31/2007
Unemployment Compensation
Reserve $ 410,449 $ 153,000 $ 159,269. 104.1% $ 151,918 $ 109,920 72.4% $ 459,798
Employees Health Benefit
Reserve 3,507,424 8,447,032 8,697,994 103.0% 8,709,804 8,691,744 99.8% 3,513,674 (1)
Worker's Compensation Reserve 1,323,660 1,025,800 1,134,381 110.6% 1,302,950 1,242,336 95.3% 1,215,705 (1)
Wellness/EAP 139,706 105,000 123,684 117.8% 127,940 121,651 95.1% 141,739
Firemens' Relief and Pension 524,014 1,598,659 1,618,925 101.3% 1,746,348 1,497,086 85.7% 645,853
Total Employee Benefit
Reserve Funds $ 5,905,253 $ 11,329,491 $11,734,253 103.6% $ 12,038,960 $ 11,662,737 96.9% $ 5,976,769
Operating Reserves
Contingency $ 349,407 $ 75,000 $ 75,000 100.0% $ 300,000 $ 65,337 21.8% $ 359,070
Capitol Theatre Reserve 626,202 30,000 20,795 69.3% 71,927 71,927 100.0% 575,070
Risk Management Reserve 819,743 2,176,659 2,496,656 114.7% 2,256,137 2,278,436 101.0% 1,037,963 (1)
Total Operating Reserve Funds $ 1,795,352 $ 2,281,659 $ 2,592,451 113.6% $ 2,628,064 $ 2,415,700 91.9% $ 1,972,103
Other Funds
Cemetery Trust $ 544,526 $ 26,000 $ 37,983 146.1% $ 27,000 $ 26,828 99.4% $ 555,681
Pass Through Grants $ - $ - $ - $ - $ - $ -
(1) These fund balances exclude an accrual for incurred but not reported claims.
cje 4/10
Ill III
• • Tae 1
•
City of Yakima
Bond Redemption Funds
2007 Budget vs. Actual
Actual Revenue Appropriations
Beginning % % Ending
General Obligation Bond Balance Amended Actual Re- Amended Actual Ex- Balance
Redemption 1/1/2007 Budget Revenue ceived Budget Expenditures pended 12/31/2007
L.I.D. Guaranty $ 77,792 $ 300 $ 1,890 $ - $ - $ 79,682.
1994 G.O. Ltd. - Police & Streets 265,024 514,100 514,000 100.0% 511,438 511,438 100.0% 267,586
1995 G.O. Street, Parks & Fire 195,656 300,000 292,669 97.6% 293,963 293,963 100.0% 194,362
1997 G.O. Line of Credit 918 862,000 532,200 61.7% 862,000 532,199 61.7% 919
1996 G.O. LTD - Convention Center 58,664 426,000 432,756 101.6% 432,358 432,358 100.0% 59,062
1998 G.O. Street Bond 85,565 182,000 182,000 100.0% 176,588 176,588 100.0% 90,977
2002 G.O. Convention Center 130,211 480,000 480,000 100.0% 479,255 459,729 95.9% 150,482
. 2005 G.O. Parks and Recreation Bond . 350 304,100 252,621 83.1% 304,003 248,310 81.7% 4,661
L.I.D. Debt Service Control 48,239 132,500 224,391 169.4% 267,000 253,673 95.0% 18,957
Total General Obligation Bond
Redemption Funds $ 862,419 $ 3,201,000 $ 2,912,527 91.0% $ 3,326,605 $ 2,908,258 87.4 % $ 866,688
Water /Sewer Revenue Bond Redemption
1997 Water Revenue Bond Reserve $ 268,807 $ 400 $ 400 100.0% $ - $ - $ 269,207
1978 Revenue Bond Reserve 345,827 700 700 100.0% 0 0 346,527
Water /Sewer Revenue Bonds 109,129 545,635 545,635 100.0% 545,235 545,235 100.0% 109,529
Apple Tree Sewer Revenue Bond 0 82,000 148,587 181.2% 225,000 148,587 66.0% 0
1997 Water Revenue Bonds 4,441 244,030 244,030 100.0% 244,005 244,005 100.0% 4,466
1978 Water /Sewer Revenue Bond 165,136 370,785 370,785 100.0% 370,285 370,285 100.0% 165,636
2003 Wastewater Bond Redemption 1 1,348,382 1,348,381 100.0% 1,348,382 1,348,381 100.0% 1
2003 Irrigation Bond Redemption 35,435 320,565 320,565 100.0% 320,565 320,568 100.0% 35,432
Water /Sewer Revenue Bond Reserve 947,700 2,500 15,000 600.0% 0 0 962,700
2003 Sewer Revenue Bond Reserve 828,650 0 0 0 0 828,650
Total Water /Sewer Revenue
Bond Redemption Funds $ 2,705,126 $ 2,914,997 $ 2,994,083 102.7% $ 3,053,472 $ 2,977,061 97.5% $ 2,722,148
cje 4/10/2008