HomeMy WebLinkAbout07/20/2010 19B 1st Quarter 2010 Revenue and Expenditure Report BUSINESS OF THE CITY COUNCIL
• YAKIMA, WASHINGTON
AGENDA STATEMENT
Item No. *- Kt Q
For Meeting Of July 20, 2010
ITEM TITLE: 1st Quarter 2010 Revenue and Expenditure Report
SUBMITTED BY: Dick Zais, City Manager
Rita DeBord, Finance Director
Cindy Epperson, Deputy Director of Accounting & Budgeting
CONTACT PERSON/TELEPHONE: Cindy Epperson, 575 -6070 C,t
SUMMARY EXPLANATION:
The attached report provides a comprehensive summary of the City of Yakima's 2010 budget
and expenditure status through March 31, 2010. Overall, the 1st quarter activity reflects a
stable, but guarded fiscal position within the context of the national recession. General City
expenses are within budget estimates at 24.2% through March 31 and General Government
revenues are at 21.0% through this period. The City's other operating and enterprise funds
have generated revenues of 19.0% and expenditures of 19.5% of budget estimates through the
first quarter of 2010.
4. The national recession caused reductions in a few key revenue sources. The 2010 budget was
developed with lower levels of revenue contemplated. However, a combination of sales tax
continuing to drop throughout the first quarter and a mild winter /spring caused revenues to be
below the conservative estimates used to develop the budget. Therefore, City Management has
responded with a cost containment plan implemented in April of 2010 to reduce overall
expenditures by about $1.3 million to remain within the lower revenue projections. This plan
includes the reduction of jail costs as the result of targeted cost reductions measures,
maintaining certain position vacancies for the remainder of the year, and a 5 day furlough of
employees in General Government positions.
The 2010 beginning balances used in this report are preliminary and may be affected by final
year -end and /or audit adjustments; however, no material changes to these amounts are
anticipated.
Resolution Ordinance Other (Specify) Report
Contract Mail to (name and address)
Phone
Funding Source Not Ap licable
APPROVED FOR SUBMITTAL ------,: V` City Manager
0 STAFF RECOMMENDATION: Accept Report
BOARD /COMMISSION /COMMITTEE RECOMMENDATION:
COUNCIL ACTION:
MEMORANDUM
0
JULY 15, 2010
TO: The Honorable Mayor and Members of the City Council
FROM: Dick Zais, City Manager
Rita DeBord, Finance Director
Cindy Epperson, Deputy Director of Accounting & Budgeting
SUBJECT: First Quarter 2010 Budget Revenue and Expenditure Report
This report provides a comprehensive summary of the City's financial status from January
1 through March 31, 2010. This summary information is provided by fund in the following
411
categories:
. .
• General Government Resources
• . General Government Expenditures
• Other Operating and Enterprise Funds
• Capital Funds
• Reserve Funds
Overall, the City's first quarter budget status reflects a stable, but guarded fiscal position
within the context of the national recession.
As of this date, the 2010 amended City of Yakima Budget is $199,683,074 or $6,499,305 .
greater than the adopted 2010 Budget. The increase is due primarily to carry -over 2009
encumbrances of $4.7 million, and a non - lapsing appropriation for Wastewater
construction projects of $1.7 million.
•
Page 1
CJE /Finance
Rev /Exp 1st Qtr Report 07/15/10
GENERAL GOVERNMENT RESOURCES
Table I identifies and compares General Government resources by major source through the first
quarter for 2008, 2009 and 2010. As of March 31, 2010, total General Government resources which
include actual beginning balances, are at $18,627,694 or 28.9% of the total 2010 budget. (This
compares to a level of 31.6% for the same period in 2009.)
GENERAL FUND RESOURCES
Property Tax receipts for the first three months of 2010 are $647,456 or 7.6% of this year's budget
compared to $586,646 or 7.6% of last year's budget for the same period. The flow of receipts to
date depends on collection activity. The first half assessment is due to the County by April 30.
Yakima County Treasurer's Office estimates that we should collect between 96% and 97% of the
current year levy, and 50% of the delinquent tax balance. 2009 actual results were within this
range. Collections appear to be on target to meet this estimate.
Local Criminal Justice Sales Tax (General Fund) receipts through the first quarter are $397,206 or
23.6% compared to $412,416 or 24.0% at this time last year for the 0.3% Criminal Justice Sales Tax.
The City's portion of the 0.1% sales tax is $224,136 or 23.3% of estimates to date, versus $231,800 or
23.6% at the same time last year. (See discussion on General Sales Tax below.)
Sales tax receipts through March 31 are $3 080 041 or 24.2% of budget estimates compared to
P g � g p
$3,279,773 or 23.5% at this time last year, representing a decline in revenues of (6.1%) through the
first quarter. The 2010 budget was set assuming modest growth of about 1.0% in sales tax
revenue, as some leading economic indicators were pointing to a modest recovery. However, the
1St quarter continued to drop from 2009 levels. Since then, we have experienced 3 months of
collections being more than the prior year, so it appears that the 18 month drop in sales tax month
over month has at least flattened. (As of June 30, the cumulative decline is only slightly more than
1 %). In response to the continuing fall in sales tax in the first quarter, City Management
implemented cost containment measures in April, 2010 to address the expected shortfall. It
should be noted that there is a two -month lag from the point of sale to our receipt of sales tax
revenues.
Franchise tax receipts of $2,441 through the first quarter are at 5.8% of budget estimates. The
Water franchise fee is paid monthly, and picks up through the summer months as water usage
increases for irrigation.
Utility tax receipts through the first quarter are $3,222,627 or 26.1% for 2010 compared to
$3,480,450 or 30.0% for the first three months of 2009. Much of this decrease is in the area of
natural gas, which was lower because of the extremely mild winter the valley experienced. These
taxes are functions of usage (which is heavily impacted by weather), rates, and the timing of
billings.
Page 2
CJE/ Finance
Rev /Exp tat Qtr Report 07/15/10
General Government Resources (Continued ) ,
Business License receipts through the first quarter of 2010 are $448,271 or 86.2% compared to
$465,891 or 89.6% for the first three months of 2009. Most of this revenue is collected at the
beginning of the budget year, as this is an annual fee. .
Gambling Tax is performing as expected in the .first quarter. The total collected of $226,657 is
24.4% of budget. .
The Police Federal Grants have not yet been collected in 2010, as this is a function of the timing of
program expenditures and the related billing.
State Shared Revenue such as Liquor Excise of $103,707 or 25.6% is close to budget estimates for
this period, as are Liquor Profits of $196,900 or 28.3 %. As these are per capita allocations, they are
expected to approximate budget by year -end. The liquor profits are at risk in future years, should
the recent initiatives (I -1099 and I -1100) to privatize liquor sales go forward and are approved
through the, election process.
Criminal Justice funds are performing as expected at $166,938 or 26.1% of budget.
Overall, Total Intergovernmental revenues are on target with $782,319 or 26.4% received through
March 31, 2010.
• Licenses and Permits revenue is $242,320 or 35.2% of budget throu h the first quarter of 2010,
g
compared with $155,008 or 19.0% of budget received in the same time in 2009, indicating an
increase in construction activity. Because permits are the precursor to construction spending, this
trend will be monitored for possible effects on future sales tax receipts.
Miscellaneous Revenue consists primarily of interest earnings. Receipts of $66,632 are 13.0% of
budget. This category is affected both by interest rates which are at historic lows, and the timing
of payments. (By the end of May, this category is tracking at 44% of budget, which is within
budget estimates.)
All other significant General Fund revenue sources are performing as expected.
Beginning Balance - .
The actual 2010 General Fund Beginning Balance is currently estimated to be $4,612,886;
$2,185,845 less than the 2009 final amended Beginning Balance of $6,798,731. Of the total 2010
Beginning Balance, $1,660,224 is presently obligated to balance the amended General Fund
budget, as compared to $2,125,434 of Beginning Balance which was used to balance the 2009
amended General Fund budget at this point in time.
Total General Fund Resources equal $15,625,068 or 29.4% of budget through March 31, 2010.
This compares with $18,284,398 or 33.0% of last year's budget resources through the first quarter
AI of the year.
Millr
Page 3
CJE /Finance
Rev /Exp 1st Qtr Report 07/15/10
General Government Resources (Continued )
Summary:
Overall, General Government revenue is performing-reasonably well in light of the national
economic condition and is within budget tolerance. It should be noted that City Management has
implemented cost reductions of about $1.3 million for the balance of 2010, to offset some of the
revenue shortfalls noted above.
PARKS AND RECREATION FUND RESOURCES
Parks and Recreation revenues of $676,757 are at 15.9% of budget estimates through the first
quarter of 2010. This compares with last year's resources to budget for three months of $563,498
or 13.3 %. Utility Tax receipts on City -owned utilities amounting to $232,281 (20.8% of the 2010
estimate) have been transferred, to date, to the Parks Fund from the General Fund. The total
revenue is below 25% because of the timing of Parks program activities (such as swimming, golf
and softball) coupled with the Property Tax receipts, which aren't collected from the County until
the second quarter.
STREET AND TRAFFIC OPERATIONS FUND RESOURCES
Total Street Fund revenues are $525,048 or 10.0 %. Fuel tax receipts are $297,172 or 24.8% - as this
is a per gallon tax, higher fuel costs and statewide unemployment are pushing down 111111
consumption. As of March 31, 2009 Property Tax, the major revenue category in the Street Fund, is
$220,748 or 6.0% of the total 2010 (as compared to 6.1% for the same period last year) because of
the timing of receipts.
Summary
Table II identifies the beginning balance, revenues and expenditures to date, and the ending
balance for each of the three General Government Funds. For 2010, at the end of the first quarter,
the Cumulative General Government Revenue is $12,213,987 or 21.0% of budget compared to
$12,607,609 or 21.5% at March 31, 2009.
At March 31, 2010, the net General Government Balance (beginning reserves plus current
revenues less current expenditures) is $4,641,772, compared to $6,501,734 in 2009.
•
0
Page 4
CJE /Finance
Rev /Exp 1st Qtr Report 07/15/10
GENERAL GOVERNMENT EXPENDITURES
Table III summarizes expenditure activity on a departmental basis for General Government
ID
budgets.
GENERAL FUND EXPENDITURES
General Fund budget data of interest include:
Police expenditures, $5,373,521 or 23.5% are below first quarter averages, due primarily to
position vacancies, and savings in outside jail expenses. The entire budget for insurance /risk
management is transferred to the Risk Management Fund in the first quarter, as the annual
insurance premiums are due in this period.
Fire expenditures of $2,246,916 are 24.6% of the 2010 budget through the first quarter. This slight
saving is the result of the timing of supply purchases, offset by the full payment for risk
management (as described above in the Police narrative.)
Information Systems expenditures are at $655,616 or 25.3% because of the timing of contract
payments and project implementation, coupled with the cash -out of the manager. This position is
currently being held vacant pending an independent study of the operation.
0 Code Administration, Financial Services, and. Legal are respectively at 23.7 %, 21.9 %, and 22.8%
of budget, due primarily to position vacancies. '
Municipal Court, Planning and Human Resources are at 22.1 %, 23.7% and 22.2% of budget •
respectively, a function of the timing of supply purchases and outside professional services.
Records expenditures of $220,493 or 49.5% include one -time payment of election costs of $153,490.
The budget for this category is $130,000. This overrun will need to be offset by other savings in
General Fund.
City Hall Maintenance expenditures are $168,639 or 41.7% of budget, primarily because the entire
insurance payment of about $88,000 was made to the Risk Management fund to purchase
property/boiler insurance in the first quarter.
Intergovernmental expenditures of $132,189 are 34.7% because the City pays all of the
Yakima County Emergency Management assessment in the first quarter. Additionally „Yakima
County Development Association (YCDA) receives a semi - annual payment in the first quarter.
City Council pays the City's annual dues to the Association of Washington Cities in the first
quarter. Therefore, expenditures of $91,159 are 44.0% of budget at March 31, 2010.
el
- Page .
CJE /Finance
Rev /Exp 1st Qtr Report 07/15/10
•
General Government Expenditures (Continued )
SunDome paid -0- or 0% of its budget in the first quarter of 2010 because of timing of annual debt
service payments.
State Examiner only incurred incidental expenditures of $550 in the first quarter as the 2009
financial statement audit is just in planning stages.
Urban Area Hearings Examiner expenditures to date are $6,579 or 14.4 %, reflecting the number of
cases heard and paid for as of March 31, 2010.
District Court expenditures of $219 or 12.2% match the revenue being submitted on old cases still
being collected by District Court. As most of the receivables are several years old, both the
revenue and expenditures are dropping off as time passes.
All other General Fund Departments are close to the first quarter average of 25 %.
Summary:
In total, the General. Fund is 24.1% expended through the first quarter, and is within authorized
budget levels. The 2010 General Fund budgeted ending balance is projected to be $2,952,662 or
about 5.9% of the budget.
•
PARKS AND STREETS EXPENDITURES
Parks expenditures are at $929,840 or 22.0 %, and Street and Traffic Operations expenditures are
at $1,458, 056 or 26.9% to date. In both areas, many costs are seasonal in nature, and as the impact
of summer recreation and parks maintenance programs is accounted for, the associated program
costs should bring actual expenditure levels closer to budget by year -end. Even though Streets
and Traffic have salary savings, the first quarter includes the full year of insurance charges and
some debt service obligations, and slightly over half of the snow and ice control budget has been
spent to date.
Summary:
Overall, General Government expenditures are within budget estimates - 24.2% through March
31, 2010. In April, City. Management implemented a cost containment plan to reduce total
expenditures by about $1.3 million or 2.2% to match the downturn in revenues.
0
Page 6
CJE /Finance
Rev /Exp 1st Qtr Report 07/15/10
OTHER OPERATING AND ENTERPRISE FUNDS
• Table IV represents the status of the Operating and Enterprise Funds.
The Economic Development Fund has a fund balance of $283,247 at March 31. Revenues amount
to $29,795 or 25.3 %, while expenditures are at $45,382 or 21.5% of budget. The savings are a result
of the timing of the deployment of professional services (i.e. studies related to the sawmill
redevelopment area, etc.)
The Community Development Fund shows a fund balance of $72,959 at the end of the first
quarter. Revenues are at $190;214 o 3.4% of budget, while expenditures are $494,558 or 8.7% of
budget. The budget includes about $2.2 million of program carryover from the prior year
(primarily for single family home rehabilitation programs). The 2010 HUD grants have not yet
been awarded (even though estimates were included in the 2010 budget), so program expenses
are still using primarily the carried forward funds.
Community Relations Fund revenues are $129,504 or 27.1% of budget through the first quarter.
Expenditures are $163,831 or 29.2 %; resulting in a fund balance of $858,777 at March 31
representing primarily an accumulation of capital grant proceeds.
The Community Services Fund consisting of the Healthy Families Yakima program experienced
revenues of $1,108 or .5 %, and expenditures of $6,031 or 2.9% of the 2010 budget. The program
0 has substantially completed its media campaign, and is transitioning into the final phase /year of
the grant. The fund balance is $676 at the end of the first quarter.
Growth Management Fund had no activity in the first quarter, and a fund balance of $24,372 at
March 31. This budget contemplates grants to update portions of the Comprehensive Plan in
compliance with the Growth Management Act.
Cemetery Fund revenues are $44,921 or 18.4% of budget through the first quarter, as the transfers
of interest earnings from the Cemetery Trust fund or the operating subsidy from the Parks and
Recreation fund have not yet been made. Expenditures are $57,049 or 22.3 %. The fund balance at
March 31 is $75,039.
Emergency Services Fund revenues are $80,392 or 7.6% of budget and expenditures are $234,526
or 21.1% of budget through the first quarter. The fund balance at March 31, 2009 is ($90,755). The
revenue source is a special voter - approved property tax, with the first half due in the second
quarter, so that the balance is currently positive.
. Public Safety Communications Fund revenues are $631,188 or 21.5% of budget and expenditures
are $760,879 or. 25.4 %, slightly above the first quarter target because of an annual software
maintenance payment. The March 31 fund balance is $127,192.
•
Page 7
CJE /Finance
Rev /Exp 1st Qtr Report 07/15/10
Other Operating and Enterprise Funds (Continued )
Police Grants fund was opened in 2009 in order to account for narcotics forfeitures upon the
dissolution of the City - County Narcotics Unit (CCNU), and the new federal ARRA police - related
operating grants. Both of these programs have extensive tracking /reporting requirements, so that
isolating the programs outside of General Fund will assist in accounting for applicable
expenditures. Revenues in 2010 were $133,221, and grant expenditures were $130,402, leaving
$300,763 as a fund balance.
PBIA (Parking and Business Improvement) assessments and collections follow quarterly cycles.
Revenues are at $69,315 or 28.9% and expenditures are $71,441 or 29.8% of budget. The fund
balance at March 31 is $514.
Trolley (Yakima Interurban Lines) Operating Fund revenues are $0 and expenditures are $4,361
or 1.8 %. The majority of the revenue and expense budgets are a grant to upgrade the trolley
facilities, and this project only incurred minor expenses in the first quarter. The balance at March
31 is $574.
Front Street Business Improvement Area revenues are $450 or 12.7 %, and expenditures of $3,248
or 65% were made in the first quarter; resulting in a balance of $5,615.
Convention Center (Tourist Promotion) Fund revenues of $265,340 are presently at 18.9% of
budget. Expenditures are $375,385 or 25.6% of budget. The balance at March 31 is $135,098.
Historically, the first quarter revenues are lower than the rest of the year, because of the
slowdown in convention business and Hotel/Motel tax generated during the winter months.
However, revenues are expected to steadily increase as the year progresses because of scheduled
convention center business.
Public Facilities District Fund - Convention Center realized revenues of $171,115 - 25.1% of the
2010 budget. Expenditures totaled $171,250 - 24.9% of budget. The ending fund balance is
$155,753.
Public Facilities District - Capitol Theatre is a new fund that was set up at the end of 2008 to
differentiate PFD sales tax revenues that are dedicated to the construction of the Production
Center and Pavilion from other PFD revenue. For the first quarter of 2010, revenues are $160,955,
or 32.0% of budget. Expenditures are $115,020 or 22.9% of budget, leaving a fund balance of
$69,566 at March 31.
Tourism Promotion Area Fund receipts are $60,272 or 15.9% of the 2010 budget. Expenditures
total $60,272 or 15.9 %. Like hotel /motel tax, the tourism promotion fee is lowest in the first
quarter through the winter months. All fees collected are forwarded by contract to the Yakima
Valley Visitors' and Convention Bureau for promotion emphases. The ending balance at March
31, 2009 is $414.
Page 8
CJE /Finance
Rev /Exp 1st Qtr Report 07/15/10
Other Operating and Enterprise Funds (Continued )
411 Capitol Theatre Fund revenues are.$49,871 or 16 1% of budget —the transfer from the reserve
fund is being made semi- annually in the second quarter. Expenditures of.$83,834 are at 26.2 %, a
function of the timing of major maintenance projects and full insurance payments in the first
quarter. The fund balance at March 31 is $94,841.
Recovery Grants Program Fund was reactivated to account for Federal ARRA grants that cross
fund /functional boundaries. The City was awarded a Department of Energy grant for
conservation efforts. Matching grant revenue is also recorded, in the amount of $1,314, so that
there is no fund balance. This grant activity is anticipated to ramp up in 2010.
Stormwater Operating Fund revenues are $275,536 or 13.1% of budget. As this is included on the
property tax bill, a majority of the revenue will be collected in the April/May timeframe.
Expenditures are $305,627 or 13.9% of budget, because the transfers for capital and program
repayment to Wastewater and Streets funds are being timed to occur after the revenue collection. •
The fund balance at March 31 is $443,549.
Transit operations completed the first quarter of 2010 with revenues totaling $1,322,969 or 18.5%
of budget, which exclude the federal grant, and expenditures at $1,976,327 or 27.3 %. (As noted in
other narratives, the entire insurance transfer is made in the first quarter.) The operating fund
balance at March 31 is $19,872.
110 Refuse expenditures are $1,107,422 or 23.2% of the budget through March 31, 2010. This is below
scheduled levels because of the timing of payments for landfill charges (only two months are
included.) Total revenues are at $1,102,194 or 22.9 %, as the Yard Waste program is discontinued
through the winter months. The fund balance at March 31 is $215,449.
Wastewater Operating Fund revenues are $3,902,617 or 22.6% of estimated levels, while
expenditures are at $3,049,004 or 17.3% of budget due primarily to the timing of transfers to
capital /debt service funds. The fund balance at March 31 is $3,023,012.
Water Operating Fund revenues of $1,323,708 to date equal 17.9% of budget estimates, and reflect
the timing of billing cycles and historically lower water usage in the winter months. Expenditures
are at $1,510,137 or 19.4 %, also a function of the timing of capital /debt service transfers. The fund
balance at March 31 is $1,924,390.
Irrigation Fund revenues are at $757,834 or 27.3% of budget estimates. Expenditures are $896,541
or 32.5% through the first quarter —ditch charges and insurance contributions are paid in the first
quarter. The fund balance at March 31 is $143,057.
The Equipment Rental. Fund shows revenues of $1,209,478 or 24.3% of budget estimates.
Expenditures are at $884,022 or 17.0 %, a function of the timing of capital purchases. The fund
0 balance at March 31 is $4,555,810.
Page 9
CJE /Finance
Rev /Exp 1st Qtr Report 07/15/10
Other Operating and Enterprise Funds (Continued )
Environmental Fund revenues are at $94,437 or 10.4% of budget estimates. Expenditures are
$242,722 or 20.7% of budget. The fund balance at March 31 is $310,034. This fund's revenue
comes in primarily at the end of the year, while expenditure timing is related to projects —clean-
up projects at the airport funded by grants from the Dept of Ecology are in process.
Public Works Administration revenues are $296,107 or 25.0% of budget through the first quarter,
and expenditures are $313,474 or 26.7% of budget over the same time period. As mentioned in
other discussions, the insurance contribution is paid in the first quarter. The fund balance at
March 31 is $202,024.
Summary:
In total, Other Operating and Enterprise Funds have generated revenues of $12,303,855 or
19.0 %, while expenditures are at $13,064,059 or 19.5% of budget estimates through the first three
months of 2010. These results are similar to the first quarter of the prior year.
0
Page 10
CJE/ Finance
Rev /Exp 1st Qtr Report 07/15/10
CAPITAL FUNDS
4111/ Table V represents the status of our Capital Construction and Capital Reserve Fund balance. The
activity in the Capital Funds is dependent on the scope and timing of capital projects; therefore,
the first quarter percentage comparison to total budget is not expected to reflect the percentage of
the year completed.
Several projects are approaching the construction phase in the Arterial Street Fund. $3,767,364 is
budgeted for construction projects during 2010 - the major ones being 16th and Washington
Avenue intersection reconstruction, signalization at 66th and Summitview, and completion of the
Nob Hill Overpass Repair. Revenue through March is $387,424 or 13.0% of budget. Expenditures,
which are based on an approved project prospectus, are $984,807 or 26.1% of budget. The fund
balance at March 31 is $599,678.
The Central Business District (CBD) Capital Fund provides resources for CBD studies and
capital projects, and the 2010 budget includes the fourth phase of improvements along Yakima
Avenue being done as part of the Downtown Yakima Futures Initiative. The balance at March 31
is $408,703. Revenues of $7,142 represent 0.7% of budget, while expenditures to date are $30,393
or 2.6 %, as Phase IV is in design stage.
The Capitol Theatre Construction Fund was reactivated to account for major capital projects
proposed for the Theatre. Expenditures of $718,548 or 22.8% of budget have been made for
ill construction costs relating to the expansion project. Revenues for the first quarter are at - 0 - , as
the General Obligation bonds to complete the project were issued mid -2009, leaving a fund
balance at March 31 of $3,711,872.
Parks and Recreation Capital Fund revenue to date is $30,535 or 5.3% of budget, while .
expenditures are at $70,937 or 11.2 %. The major project included in the 2010 budget is the
development of upper Kiwanis Park. The balance at March 31 is $273,888.
Fire Capital Fund expenditures through the first quarter of 2010 are at $223,932 or 16.6%
consisting primarily of construction costs for the remodel of Fire Station 94 at the airport, and
revenues of $14,478 or 6.9% have been received. The balance at March 31 is $1,214,026. The other
major expenditure in this fund's budget is the replacement of a ladder truck.
Law and Justice Capital Fund revenues to date are $73,380 or 7.1% and expenditures are $154,229
or 13.3% of budget, the function of the timing of grant related expenditures and reimbursements.
The fund balance at March 31 is $304,617.
The Public Works Trust Construction Fund was created to accumulate revenue received and to
track capital projects, including those associated with the State Public Works Trust Loan Program.
Revenue of $98,374 or 16.0% of budget has been received through the first quarter, and include
the first quarter percent Real Estate Excise Tax. The softening of the real estate market has caused
a marked drop in this revenue from 2008 levels. However, the revenue is on target to meet the
0 , revenue estimate. Expenditures of $7,867 or 0.9% of budget were made through the same period.
The fund balance at the end of the first quarter is $1,262,559. Loan payments and related transfers .
from other funds are due in the second quarter.
Page 11
CJE/ Finance
Rev /Exp 1st Qtr Report 07/15/10
•
Capital Funds (Continued.....)
The Real Estate Excise Tax— Second quarter percent (REET 2) Capital Construction fund is
used to account for the second quarter percent Real Estate Excise Tax (REET 2). Through
the first quarter, $98,374 or 18.6% of the revenue budget has been received. Expenditures
of $1,207, or 0.1% were made through the same period. (See the discussion for the Public
Works Trust Construction Fund above.) The fund balance at March 31, 2010 is $1,166,593.
The Local Improvement District (LID) Construction Control Fund is used to account for
resources and costs associated with LID projects. Projects are paid for through interest bearing
warrants redeemable at the end of the project either by pay -off's by affected property owners or
proceeds of bond sales. Therefore, this fund will carry a negative fund balance until active
projects and related financings are completed. The balance as of March 31 is ($897,020).
The Transit Capital Reserve Fund has a current fund balance of $1,093,989. This represents the
reserve that the City Council has directed be set aside to provide funds for capital projects and
equipment. Expenditures are at $51,742 or 1.1 %, while revenues are $25,299 or 1.9%. (All Transit
sales tax goes into the operating fund until the grant is drawn down.) Transit has been awarded a
grant to purchase five replacement buses, which are currently on order.
The Stormwater Capital Fund has a current fund balance of $509,965. The revenue budget of
$434,781 consists of a transfer from the operating fund, with an expenditure budget of $368,040 for
the study and design of stormwater capital projects. As of March 31, there has been a total of
$9,909, or 2.7 %, in expenditures.
The Convention Center Capital Improvement Fund reflected a balance of $362,381 in the
Convention Center Reserve at the end of the first quarter of 2010. Revenues were $43,750 or 5.4%
of budget. Expenditures are $168,998 or 17.3% to date, as the capital projects are in various stages
of completion.
At the end of the first quarter the Cumulative Reserve for Capital Improvement Fund
shows a balance of $1,313,282. Expenditures are $139,899, 0.7% of budget, with no revenues to
date. The major project budgeted in this fund is the Railroad Grade Separation, which was
ramping up to begin construction in the 2 quarter. As this is a large project to be funded
primarily by reimbursable grants, a Public Works Trust Fund loan can be used to provide cash
flow during the interim times between project payments and the receipt of grant reimbursements,
as a portion of this revenue source can be drawn in advance of actual cash disbursements.
The purpose of the Wastewater Facilities Capital Reserve Fund is to provide resources for
contingency modifications at the Wastewater Treatment Plant. Revenues of $152,000 are
estimated for 2010 and will be generated primarily from Sewer Operating Fund contributions,
Sewer Service Agreements with Union Gap and Terrace Heights, and investment income. To
date, $4,538 or 3.0% of budgeted revenues have been received. Planned expenditures of $50,000
in 2010 are for miscellaneous capital improvements -- there have been $799 in expenditures to
date. The fund balance at March 31 is $480,914. 410
Page 12
CJE/ Finance
Rev /Exp 1st Qtr Report 07/15/10
Capital Funds (Continued.....)
• The Sewer Construction Fund provides principally for off -site system improvements such as new
interceptor and trunk line extensions. Revenue consisting primarily of capital transfers from the
operating fund is budgeted at $1,388,000 with $115,350 actual revenue to date. $3,685,000 is
presently budgeted for sewer system planning and improvement, with the major projects being a
sewer trunk line in the Congdon annexation area, sewer improvements in under- served
neighborhoods, and the Speedway/Race Street interceptor. Actual expenditures at the end of the
first quarter amounted to $192,351 or 5.2%. The fund balance at March 31 is $3,846,498.
Expenditures are $78,317 or 2.6% through the first quarter in the_Domestic Water Improvement
Fund. The major projects in the 2010 budget of $2,997,200 are a new well at Gardner Park and an
automated meter reading system. Revenues are budgeted to be $2,045,460 and include a Public
Works Trust Fund loan, a transfer from the operating fund and interest earnings. As of March 31,
there was no revenue because of the timing of the contribution from the operating fund, therefore,
the ending balance was $2,470,368.
The Wastewater Facility Project Fund ended first quarter 2010 with a fund balance of $3,363,821.
For 2010, budget expenditures of $3,773,050 are anticipated to continue construction of capital
improvements mandated by NPDES permit requirements. Actual expenditures through the first
quarter of 2010 are $459,024 or 12.2% and no revenues have been posted to date, again the result
of timing of operating fund contributions.
• The Irrigation System Improvement Fund revenues q
through the first quarter of 2010 amount to
g
$262,826 or 29.7 %. $651,101 or 25.0% has been expended for system repairs, leaving a fund
balance of $1,769,417, consisting mainly of accumulated capital contributions.
0
Page 13
CJE/ Finance
Rev /Exp 1st Qtr Report 07/15/10
RESERVE FUNDS -
Table VI illustrates the position of the City's Employee Benefit and Pension Reserve Funds. 0
The Unemployment Compensation Reserve is used to pay unemployment claims filed by former
employees. Through the first quarter, the City had actual expenditures amounting to $47,850 or
20.2% of the 2010. budget. Revenue, which is primarily from pro - rations to City operating
departments, is $35,797 or 25.2% through the first quarter. The current reserve balance is
$381,832. The City operates a self - insured program.
The Employees Health Benefit Reserve pays for group medical and dental claims for covered
City employees and eligible dependents. Revenues for this fund are primarily generated from
monthly charges for each covered employee which are paid by operating budgets through
assessments, and through payments from active and retired employees and other persons who
are entitled to participate in the City's health benefit plan. Actual revenues through the first
quarter were $2,500,666 or 24.9% while expenditures of $2,252,289 or 21.3% were experienced.
The current fund balance is $3,023,139, before considering the required 15% reserve of
approximately $1.2 million.
The Worker's Compensation Reserve provides for payment by the City of industrial insurance
medical claims and time loss payments for City employees who are injured while performing
their assigned duties. Through the first quarter, expenditures were $280,140 or 19.1% of budget.
Revenues, billed on an interfund basis, are at $288,881 or 20.5 %. The March 31, 2010 fund balance
is $1,178,004 on a cash basis, without considering the claims reserve of about $1 million.
The Wellness /Employee Assistance Program fund expenditures during the first quarter were
$12,106 or 13.5% of budget, leaving a balance of $130,856 at March 31, 2010. Revenues are
recorded at the end of the year as medical insurance savings from vacant positions.
Firemens' Relief and Pension expenditures are at $409,690 or 25.2% of budget through March 31,
2010. Revenue to date, which is largely dependent upon the flow of property tax receipts, is
$89,464 or 5.7 %. The first quarter balance is $425,697.
General Contingency Reserves
Table VI also illustrates the position of the Contingency Reserve Funds of the City.
The General Contingency Fund has a $256,720 balance at March 31, 2010.
The Capitol Theatre Reserve is programmed to transfer $71,927 consisting of interest income and
the cash reserve to the Capitol Theatre Operating Fund to help support the major capital
maintenance program of the theatre. The fund balance as of March 31 is $451,651.
0
Page 14
CJE /Finance
Rev /Exp 1st Qtr Report 07/15/10
Reserve Funds (Continued )
411 The Risk Management Reserve provides for payment of liability insurance and litigation defense
through an internal service fund. The Reserve is funded by allocations from the various operating
funds of the City transferred at the beginning of the year, and interest earned by the fund.
Revenue to date amounts to $2,400,300 or 93.8% of budget. Expenditures, which encompass
payment of the City's annual premiums for liability, property and miscellaneous coverages;
broker fees; and legal services are $863,275 or 31.3% of budget. The cash balance at March 31 is.
$2,546,625 without considering the liability for incurred but unpaid claims of about $0.9 million.
Bond Redemption Funds
Table VII illustrates the financial position of the City's General Obligation and Revenue Bond
Funds. The timing of actual expenditures are a function of the terms of each bond and its . related
repayment schedule —most bond principal payments are due in the last quarter of the year.
III
_.
III
Page 15
CJE/ Finance
Rev /Exp 1st Qtr Report 07/15/10
•
0 •
•
• City of Yakima Table I
Page 1 of 2 General Government Resources 25.0%
3 Year Comparison - March 2010 Year to Date of Year
General Fund Resources: 2008 2009 2010
% Amended
To -Date Rcvd To -Date Rcvd Budget To -Date Rcvd
Property Tax • $559,496 7.6% $586,646 7.6% $8,523,000 $647,456 7.6%
Criminal Justice Sales Tax Inc .3% 413,483 25.5% 412,416 .24.0% 1,682,000 397,206 23.6%
. Criminal Justice Sales Tax 224,240 24.7% 231,800 23:6% 960,000 224,136 23.3%
Sales Tax 3,394,798 24.8% 3,279,773. 23.5% . 12,703,000 • 3,080,041 24.2%
Franchise Tax
Nob Hill Water Assn. - -2.0% 2,454 5.7% 5,537 11.6% 42,000 2,441 5.8%
Total Franchise Tax . 2,454 5.7% 5,537 11.6% 42,000 2,441 A 5.8%
Utility Tax
PacificPower - -6.0% 1,076,661 35.7% 1,145,237 • � 31.4% 3,816,000 1,150,364 30.1%
Elia ob Hill Water Assn. - -14.0% 17,381 5.8% 38,915 11.8% 325,00 17,322 5.3%
tural Gas -- 6.0% 620,449 40.2% 811,977 60.6% 1,710,000 592,175 34.6%
Yakima Waste Systems - -10.0% 78,420 22.5% 52,040 16.8% 320,000 78,595 24.6%
Cellular Telephone -- 6.0% 341,367 29.1% 401,856 26.0% 1,570,000 381,967 24.3%
Telephone -- 6.0% 322,200 ' 26.0% 276,885 24.3% 1,070,000 256,024 23.9%
Water -- 14.0% 147,265 16.3% 184,580 • • 20.4% 980,000 173,882 17.7%
Wastewater -- 14.0% 460,211 23.7% 477,345 24.1% 2,129,000 472,239 22.2%
Refuse -- 9.0% 84,819 22.9% 91,615 22.1% 420,000 100,059 23.8%
Total Utility Tax 3,148,773 29.1% 3,480,450 30.0% 12,340,000 3,222,627 26.1%
Business License Tax 474,200 94.8% , 465,891 89.6% • 520,000 - 448,271 86.2%
Gambling Tax 226,150 23.8% 248,128 26.6% 928,000 226,657 24.4%
Dangerous Bldg Tax Assessment 2,724 ri/a 2,524 n/a '35,000 0 0.0%
Leasehold Excise Tax 1,161 580.5% 1,145 572.5% 4,000 2,156 53.9%
Total Taxes 8,447,479 23.5% 8,714,310 23.2% 37,737,000 8,250,991 21.9%
Police Federal Grants 0 0.0% 21,945 6.3% 135,000 0 0.0%
Fire Federal Grants 0 0.0% 13,000 25.d% 0 0 0.0%
Criminal Justice Funds 152,380 35.9% 154,941 35.9% 640,000 166,938 26.1%
Liquor Excise Tax 96,285 24.5% 100,077 23.8% 405,000 103,707 25.6%
Liquor Profits 143,535 23.7% 139,786 22.6% 695,000 196,900 • 28.3%
School Dist. #7 Resource Officers 88,207 25.0% 90,853 24.5% . 370,440 0 0.0%
Other Intergovermental • 113,415 23.3% 204,605 31.9% 715,968 • 314,774 44.0%
T talIntergovernmental 593,822 22.9% 727,207 25.2% 2,961,408 782,319 26.4%
•
erp 7/14/2010 Revenues Gen Gov- 2010.xls .
•
0
City of Yakima Table I
Page 2 of 2 General Government Resources 25.0%
• 3 Year Comparison - March 2010 . Year to. Date of Year
General Fund Resources (Contd.) 2008 2009 2010
Percent Percent Amended Percent
To -Date Received To -Date Received Budget . To -Date Received
Licenses and Permits • $224,269 25.7% .. $155,008 19.0% $689,000 $242,320 35.2%
Charges for Service 1,188,945 26.6% 1,168,684 23.9% 4,914,680 1,219,239 24.8%
Fines and Forfeitures 428,651 31.1% 464,397 28.4% 1,736,900 450,681 . 25.9% -
Misc. Revenue . 217,066 23.0% 256,061 27.7% 511,294 66,632 13.0%
Non- Revenue 365 36.5% 0 0.0% 1,000 0 0.0%
Transfers From Other Funds 0 0.0% 0 0.0% 40,000 0 0.0%
Capital Lease Financing 0 0 0 0
Total General Fund Revenue $11,100,597 24.0% $11,485,667 23.6% $48,591,282 $11,012,182 22.7%
Beginning Balance 6,250,708 100.0% 6,798,731 100.0% 4,612,886 4,612,886 100.0%
Total General Fund Resources . $17,351,305 33.1% $18,284,398 33.0% $53,204,168 $15,625,068 29.4%
Parks & Recreation Fund Resources: . iii
Property Tax 101,536 5.6% 109,222 6.1% 1,788,500 . 106,475
Intergovernmental . 22,374 12.8% 32,836 18.2% 147,700 37,128 . 21 VF
' Charges for Services 182,290 20.0% 163,615 17.5% 946,365 272,641 28.8%
Misc. Revenue/Non- Revenue 30,685 15.5% ' 28,773 11.2% 247,420 28,232 11.4%
Transfers From Other Funds 216,646 19.6% 229,052 21.3% 1,117,000 232,281 20.8%
Total Parks/Rec. Fund Revenue $553,531 13.2% $563,498 13.3% $4,246,985 $676,757 15.9%
Beginning Balance 549,439 100.0% .451,356 100.0% 339,555 339,555 100.0%
Total Parks/Rec. Fund Resources . $1,102,970 23.3% $1,014,854 21.6% $4,586,540 $1,016,312. 22.2%
Street/Traffic Fund Resources:
Property Tax 238,056. 5.6% 261,768 6.1% 3,708,000 220,748 6.0%
County Road Tax . 0 0.0% 0 0.0% 0 0 0.0%
Fuel Tax - Street 312,412 21.8% 285,068 21.1% 1,200,000 297,172 24.8%
Other Intergovernmental 0 0.0% 0 0.0% 0 . 0 0.0%
Charges for Services 4,307 27.3% . 11,160 70.8% 215,760 6,581 3.1%
Misc. Revenue/Non- Revenue 9,921 16.5% 448 0.5% 105,050 547 0.5%
Total Street/Traffic Fund Revenue $564,696 • 9.9% $558,444 9.7% . $5,228,810 $525,048 10.0%
Beginning Balance 1,386,069 100.0% 1,372,651 100.0% 1;461,266 1,461,266 100.0%
Total Street/Traffic Fund Resources $1,950,765 27.4% $1,931,095 27.1% $6,690,076 $1,986,314 29.7%
Total General Government Resources $20,405,040 31.7% $21,230,347 31.5% $64,480,784 $18,627,694 28.9%
0
erp 7/14/2010 Revenues Gen Gov- 2010.xls •
•
410
City of Yakima Table II
General Government Summary of Operations 25.0%
3 Year Comparison - March 2010 Year to Date Of Year
2008 2009 2010
% %
Rcvd Rcvd Amended Rcvd
•
To -Date Exp To -Date Exp Budeet . To -Date Exp
General Fund
Beginning Balance $6,250,708 $6,798,731 $4,612,886 $4,612,886
Revenues $11,100,597 24.0% $11,485,667 23.6% $48,591,282 • $11,012,182 22.7%
Expenditures $11,392,836 23.5% $12,203,751 23.5% $50,251,506 $12,126,242 "24.1%
Ending Balance • $5,958,469 $6,080,647 $2,952,662 $3,498,826
Parks and Recreation Fund
Beginning Balance $549,439 $451,356 $339,555 $339,555
Revenues $553,531 13.2% $563,498 13.3% $4,246,985 $676,757 15.9%
lik penditures $854,525 19.3% $947,883 21.7% • $4,218,655 $929,840 22.0%
Ending Balance $248,445 $66,971. $367,885 $86,472
Street/Traffic Fund
Beginning Balance $1,386,069 $1,372,651 $1,461,266 $1,461,266
Revenues $564,696 9.9% $558,444 9.7% $5,228,810 • $525,048 10.0%
Expenditures $1,299,766 20.9% $1,576,979 26.0% $5,424,662 $929,840 17.1%
Ending Balance $650,999 • $354,116 $1,265,414 $1,056,474
Total General Government
Beginning Balance $8,186,216 • $8,622,738 $6;413,707 $6,413,707
Revenues $12,218,824 21.8% $12,607,609 21.5% $58,067,077 $12,213,987 21.0%
Expenditures $13,547,127 22.9% $14,728,613 23.6% 859,894,823 $13,985,922 23.4%
Net General Government Balance $6,857,913 $6,501,734 $4,585,961 $4,641,772
•
•
•
erp 7/14/2010 Revenues Gen Gov- 2010.xls
Table III
City of Yakima
II
General Government Expenditures
2010 Budget vs. Actual
2010 2010
Amended Expenditures Unexpended Percent
Budget To 3/31/10 Balance Spent
Police $ 22,859,639 $ 5,373,521 $ 17,486,118 23.5%
Fire 9,142,568 2,246,916 6,895,652 24.6%
Information Systems 2,589,406 655,616 1,933,790 25.3%
Transfers To Other Funds 2,252,275 477,964 1,774,311 21.2%
Code Administration 1,504,058 356,841 1,147,217 23.7%
Police Pension 1,373,040 374,334 998,706 27.3%
Legal 1,142,950 260,525 882,425 22.8%
Financial Services 1,460,278 319,879 1,140,399 21.9%
Municipal Court 1,262,770 279,441 983,329 22.1%
Engineering 1,002,489 258,522 743,967 25.8%
Utility Services 1,256,127 274,368 981,759 21.8%
Planning 768,484 181,828 586,656 23.7% 40
Human Resources 467,478 103,820 363,658 22.2%
City Manager 518,563 125,411 393,152 24.2%
Records 445,728 220,493 225,235 49.5%
City Hall Maintenance 404,486 168,639 235,847 41.7%
Indigent Defense 480,000 117,834 362,166 24.5%
Purchasing 432,432 99,594 332,838 23.0%
Intergovernmental 381,065. 132,189 248,876 34.7%
City Council . 207,265 • 91,159 116,106 44.0%
SunDome 150,000 0 150,000 0.0%
State Examiner 103,000 550 102,450 0.5%
Urban Area Hearings Exam. 45,605 6,579. 39,026 • 14.4%
District Court • 1,800 219 1,581 • 12.2%
Total General Fund $ 50,251,506 $ 12,126,242 38,125,264 24.1%
Parks& Recreation Fund 4,218,655 929,840 • 3,288,815 22.0%
Street & Traffic Ops. 5,424,662 1,458,056 3,966,606 26.9%
Total General Government $ . 59,894,823 $ 14,514,138 45,380,685 24.2%
0
cje 7/15/2010
ee IV
• City "lima
Other Operating/Enterprise Funds
2010 Budget vs. Actual
Actual Revenue Appropriations
Beginning %. % Ending
Other Operating/ Balance Amended Actual Re- Amended Actual Ex- Balance
Enterprise Funds 1/1/2010 Budget Revenue ceived Budget Expenditures pended .3/31/2010
Economic Development $ 298,834 $ 118,000 $ 29,795 25.3% $ 211,304 $ 45,382 21.5% $ 283,247
Community Development 377,303 5,549,082 190,214 3.4% 5,705,566 494,558 8.7% 72,959
Community Relations 893,104 477,200 129,504 27.1% 561,448 163,831 29.2% 858,777
Community Services 5,599 205,000 1,108 0.5% 206,834 6,031 2.9% 676
Growth Management 24,372 25,373 0 0.0% • 49,745 0 0.0% 24,372
Cemetery 87,167 243,750 44,921 18.4% 256,155 57,049 22.3% 75,039
Emergency Services 63,379 1,063,870 80,392 7.6% 1,110,329 234,526 21.1% (90,755)
Public Safety Communications . 256,883 2,936,310 631,188 21.5% 2,994,508 760,879 25.4% 127;192
Police Grants • 297,944 1,146,686. 133,221 11.6% 1,251,126 130,402 10.4% 300,763
P.B.I.A. (Parking & Business Imp.) 2,640 240,170 . 69,315 28.9% 239,989 71,441 29.8% 514
Trolley 4,935 213,479 0 0.0% 247,218. 4,361 1.8% 574
Front Street Business Imp. Area • 8,413 3,535 450 12.7% 5,000 • 3,248 65.0% 5,615
Convention Center
(Tourist Promotion) • 245,143 1,404,500 265,340 18.9% 1,469,180 375,385 25.6% 135,098
• Public Facilities District - Convention Ctr 155,888 681,000 171,115 25.1% • 689,000 171,250 .24.9% 155,753
Tourism Promotion Area - 414 378,205 • 60,272 15.9% 378,205 60,272 15.9% 414
Capitol Theatre 128,804 309,927 • 49,871 16.1% 319,749 83,834 26.2% 94,841
Public Facilities District - Capitol Theatre 23,631 503,000 . 160,955 32.0 %. 502,000 • 115,020 22.9% 69,566
Recovery Grants Program 0 814,000 1,314 0.2% 814,000 1,314 • 0.2% 0
Stormwater Operating Fund 473,640 2,100,000 275,536 13.1% 2,191,887 305,627 13.9% 443,549
Transit • 673,230 7,148,005 1,322,969 18.5% 7,248,870 1,976,327 27.3% 19,872
Refuse 220,677 4,805,525 1,102,194. 22.9% 4,765,792 1,107,422 23.2% 215,449
Wastewater Operating ' •. 2,169,399 17,249,214 3,902,617 22.6% 17,583,255 3,049,004 17.3% 3,023,012
Water Operating 2,110,819 7,386,837 1,323,708 17.9% 7,774,807 1,510,137 19.4% 1,924,390
Irrigation 281,764 2,771,600 • 757,834 27.3% 2,758,394 896,541 32.5% 143,057
Equipment Rental 4,230,354 4,983,304 1,209,478 24.3% 5,201,037 884,022 17.0% 4,555,810
Environmental 458,319 907,423 94,437 10.4% 1,172,873 242,722 20.7% 310,034
Public Works Admin. • 219,391 1,185,331 296,107 25.0% 1,175,373 313,474 26.7% 202,024 .
Total Other Operating Funds $ 13,712,046 $ 64,850,326 $ 12,303,855 19.0% $ 66,883,644 $ 13,064,059 19.5% $ 12,951,842
cje 7 /15/2010
Table V
City of Yakima
• . Capital Improvement Funds
2010 Budget vs. Actual
Actual Revenue Appropriations
Beginning % % Ending
Balance Amended Actual . Re- Amended Actual Ex- Balance
Capital Improvement Funds 1/1/2010 Budget Revenue ceived Budget Expenditures pended 3/31/2010
Arterial Street $ 1,197,061. $ 2,976,767. $ 387,424 13.0% $ 3,767,364 $ 984,807 26.1% $ 599,678
•Transportation Improvement 0 0 0 0 0 0
Central Business District Capital 431,954 1,021,800 7,142 0.7% 1,165,185 30,393 2.6% 408,703
Capitol Theatre Construction 4,430,420 • . 37,000 • 0 0.0% 3,150,000 718,548 22.8% 3,711,872
Parks and Recreation Capital 314,290 578,536 30,535 5.3% 633,258 70,937 11.2% 273,888
•
Fire Capital 1,423,480 209,588 14,478 6.9% 1,348,018 223,932 16.6% 1,214,026
• Law and Justice Capital 385,466 1,038,035. 73,380 7.1% 1,159,603 154,229 13.3% 304,617
Public Works Trust Construction 1,172,052 615,000 98,374. 16.0% 845,851 7,867 0.9% 1,262,559
REET 2 Capital 1,069,426 5 • • 98,374 18.6% 1,301,822 . 1,207 0.1% 1,166,593 •
LID Construction Control (897,020) 0 0 0 0 (897,020)
Transit Capital Reserve 1,120,432 2,342,005 25,299 1.1% 2,732,039 . 51,742 1.9% 1,093,989
Stormwater Capital Fund 519,874 434,781 0 0.0% 368,040 9,909 2.7% 509,965
• Convention Center
Capital Improvement 487,629 808,500 • 43,750 5.4% 975,712 168,998 17.3% . . 362,381
Reserve. for Capital Improvement 1,453,181 .21,093,775 • - 0 0.0% 18,946,251. 139,899 0.7% 1,313,282
Wastewater Facilities
Capital Reserve 477,175 152,000 4,538 3.0% 50,000 799 1.6% 480,914
Sewer Construction 3,923,499 1,388,000 115,350 8.3% 3,685,000 192,351 5.2% 3,846,498
Domestic Water Improvement 2,548,685 2,045,460 0 0.0% 2,997,200 78,317 . 2.6% 2,470,368
Wastewater Facility Project 3,822,845 1,505,000 0 0.0% 3,773,050 459,024 12.2% 3,363,821
Irrigation System Improvement 2,157,692 884,000 262,826 29.7% 2,600,000 651,101 25.0% 1,769,417
• Total Capital Improvement Funds $ 26,038,141 $ 37,660,247 $ 1,161,470 3.1% $ 49,498,393 $ 3,944,060 8.0% $ . 23,255,551
cje 7/13/2 . III e •
. .
's.
•
• . vI ,
4,
City of Yakima
Reserves and Other Funds
' 2010 Budget vs. Actual
Actual Revenue Appropriations
Beginning % % Ending
Employee Benefit Balance Amended Actual Re- Amended Actual Ex- Balance
Reserves 1/1/2010 Budget Revenue ceived Budget Expenditures pended 3/31/2010
Unemployment Compensation
Reserve $ 393,885 $ 142,000 $ 35,797 25.2% $ 236,861 $ 47,850 20.2% $ 381,832
Employees Health Benefit
Reserve 2,774,762. 10,051,000 2,500,666 24.9% 10,553,586 2,252,289 21.3% 3,023,139 (1)
Worker's Compensation Reserve 1,169,263 1,412,300 • 288,881 20.5% 1,469;617 280,140 19.1% 1,178,004. (1)
Wellness /EAP 142,962 60,000 0 0.0% 89,849 12,106 13.5% 130,856
Firemens' Relief and Pension 745,923 • 1,578,565 89,464 5.7% • 1,624,792 • 409,690 25.2% 425,697
Total Employee Benefit
Reserve Funds $ 5,226,795 $ 13,243,865 $ 2,914,808 22.0% $ 13,974,705 $ 3,002,075 21.5% $ 5,139,528
Operating Reserves
Contingency - $ 256,720 $ 50,000 $ - 0.0% $ 225,000 $ - 0.0% $ 256,720
Capitol Theatre Reserve 451,642 2,000 9 0.5% 71,927 0 0.0% 451,651
Risk Management Reserve . 1,009,600. 2,559,500 2,400,300 93.8% 2,759,338 863,275 31.3% 2,546,625 (1)
Total Operating Reserve Funds $ 1,717,962 $ 2,611,500 $ 2,400,309 91.9% $ 3,056,265 . $ 863,275 28.2% $ 3,254,996
Other Funds
Cemetery Trust $ 578;512 $ 23,000 $ 2,812 12.2% $ 15,000 $ - 0.0% $ 581;324
Pass Through Grants $ - $ - $ - $ - $ - $ -
(1) These fund balances exclude an accrual for incurred but not reported claims.
cje 7/13/2010
Table VII
City of Yakima
Bond Redemption Funds
2010 Budget vs. Actual
Actual Revenue Appropriations
Beginning % % Ending
General Obligation Bond Balance Amended Actual Re- Amended Actual Ex- Balance
Redemption 1/1/2010 Budget Revenue ceived Budget Expenditures pended . 3/31/2010
L.I.D. Guaranty $ 79,830 $ 100 $ 15 $ - $ - $ 79,845
1994 G.O. Ltd. - Police & Streets 109,611 512,000 99,999 19.5% 511,788 0 0.0% 209,610
1995 G.O. Street, Parks &Fire 192,246 297,000 20,219 6.8% 296,550 0 0.0% 212,465
G.O. Line of Credit . . 0 , 50,000 0 0.0% 50,000 0 0.0% 0
1996 G.O. LTD - Convention Center 63,252 429,200 64,970 15.1% 427,815 . 0 0.0% 128,222
2002 G.O. Convention Center 151,195 1,028,896 230,000 22.4% 1,014,286 0 . 0.0% 381,195
2005 G.O. Parks and Recreation Bond 8,564 989,763 0 0.0% 989,763 - . 0 0.0% 8,564
L.I.D. Debt Service Control 26,030 212,000 7,295 3.4% 207,000 0 0.0% 33,325
Total General Obligation Bond
Redemption Funds $ 630,728 $ 3,518,959 $ 422,498 12.0% $ 3,497,202 $ - 0.0% $ 1,053,226
Water /Sewer Revenue Bond Redemption
1997 Water Revenue Bond Reserve $ 270,007 $ 400 $ - 0.0% $ - $ - $ 270,007
1996 Revenue Bond Reserve 145,363 700 0 0.0% 0 0 145,363
Water /Sewer Revenue Bonds . 113,727 540,687. 0 0.0% 540,287 0 0.0% 113,727
1997 Water Revenue Bonds 4,816 238,839 0 0.0% 238,814 0 0.0% 4,816
2008 Water /Sewer Revenue Bond 0 414,613 0 0.0% . 414,613 0 Q.0% 0
2003 Wastewater Bond Redemption 2 1,346,645 , 0 0.0% 1,346,644 0 0.0% 2
2003 Irrigation Bond Redemption . . 35,436 322,684 80,671 25.0% 322,684 103,842 32.2% 12,265
Water /Sewer Revenue Bond Reserve .967,700 2,500 0 0.0% 0 0 967,700
2003 Sewer Revenue Bond Reserve , 828,650 0 0 0 0 828,650
Total Water /Sewer Revenue
Bond Redemption Funds $ 2,365,701 $ 2,867,068 $ 80,671 2.8% $ 2,863,042 $ 103,842 3.6% $ 2,342,530
cje 7/15/20 11/1 e