Loading...
HomeMy WebLinkAbout04/20/2010 13B 2009 Year-End Budget Revenue & Expenditure Report BUSINESS OF THE CITY COUNCIL YAKIMA, WASHINGTON AGENDA STATEMENT • Item No." 1 3 B For Meeting Of : April 20, 2010 ITEM TITLE: 2009 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 -6070 SUMMARY EXPLANATION: As previously projected, actual 2009 budget performance was effectively managed in the midst of an economic downturn and overall departmental expenditures have again been restrained below authorized budget levels. As a result of these factors, the City's final year -end 2009 financial position stayed within minimum guidelines. General Fund revenues were $47.6 million - - under budget by about $1.1 million (or 2.2 %). In addition, expenditures of $49.8 million were contained below budget by $2.0 million (or 3.9 %), as a result of strict cost control measures implemented by City Management in mid -2009, which produced salary savings from position vacancies and the carry- forward of Information Systems projects. The General Fund used about $2.2 million of reserves in 2009, but still ended with a balance of $4.6 million, which is 9.2% of the 2010 adopted budget. Parks and Streets funds (the other tax - supported funds) both curbed expenditures in response to dropping revenues. The net result for the 3 General Government funds was a use of reserves of slightly over $2.2 million, from $8.6 million to $6.4 million. Continued... Resolution Ordinance Contract Other (Specify) 2009 Year -End Report Funding Source: NA . APPROVED FOR SUBMITTAL: City Manager STAFF RECOMMENDATION: Accept Report BOARD /COMMISSION /COMMITTE RECOMMENDATION: A preliminary version of the 2009 Year End Report was presented to the Budget Council Committee at their February 24, 2010 meeting. COUNCIL ACTION: 410 2009 Year -End Budget Revenue and Expenditure Report Agenda Statement— Continued • Even though a national recession was identified as beginning in December, 2007, Yakima's general economy started softening in mid -2008, although not as severely as some governments in the state and nation. Sales tax and permit fees are continuing to drop -off, and future revenue growth is not expected to increase at the same pace as the recent past. In the absence of sustained growth in City revenues, management has developed and is implementing additional reductions in other City expenditures and services for the 2010 General Government budget, and into the future, to maintain a balanced budget and acceptable reserves. The Council Budget . Committee is continuing to review the sustainability and prioritization of City services, following its "Priorities of Government" budget model adopted by the full Council in mid -2009. Total 2009 actual expenditure for all funds was $161.8 million compared to the 2009 amended budget of $212.2 million -- $50.4 million or approximately 23.8% 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 2010. Conclusion: Given the current state of the local and national economy, the state of the 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 2009 year -end fiscal position reflects that the City of Yakima was able to effectively manage its economic environment. • • • . MEMORANDUM April 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 Acct & Budget SUBJECT: 2009 Year -End Budget Revenue and Expenditure Report • In accordance with past practice, we are submitting for your review, the City of Yakima's 2009 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, which will not be officially concluded until the State Auditor's work is completed. We do not, at this time, expect that any adjustments will materially affect the balances represented in this report. 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 • • Year -End Report 2009.doc 1 of 24 This page was intentionally left blank. Year -End Report 2009.doc 2 of 24 ® . CITY -WIDE OVERVIEW As previously projected, actual 2009 budget performance was effectively managed in the midst of an economic downturn and overall departmental expenditures have again been restrained below authorized budget levels. As a result of these factors, the City's final year -end 2009 financial position stayed within minimum guidelines. The national recession was identified as beginning in December, 2007, and cost containment measures have been implemented since that time as sales tax revenue and permit fees dropped off throughout 2009. The 2010 revenue budget was developed based on projections that the revenues would flatten at the lower levels experienced in 2009. However, we are still experiencing declines in revenue that are steeper than that in the 2010 adopted budget, which has caused management to recommend and implement further reductions in General Government expenditures of about $1.25 million from the adopted 2010 budget. These additional budget reductions are necessary in order to maintain a balanced budget with acceptable reserve levels. The Council Budget Committee is continuing to review the sustainability and prioritization of City services, within the Council's "Priorities of Government" Model. As illustrated in Chart I, General Government 2009 actual expenditures were $59,493,084 ID compared to the amended budget of $62,280,983 -- $2,787,899 or 4.5% less than budget authorizations. Strict cost reduction measures were implemented in mid -2009, and were effective in achieving necessary savings. In addition, the reduction in fuel prices from 2008 levels helped to create this positive variance. By operational unit, the largest contributor to the positive variance in General Fund expenditures is the Police Department, which had salary savings from position vacancies throughout the year, and a reduction in outside jail costs. The Streets budget also experienced salary savings from vacancies. Information Systems had several projects in process, but not completed that helped create this variance in this calendar year, but will be carried forward into the 2010 budget. Total 2009 actual expenditures for all funds was $161,817,348 compared to the 2009 amended budget of $212,228,474 -- $50,411,126 or approximately 23.8% 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 2010. • 0 Year -End Report 2009.doc - 3 of 24 Chart I CITY OF YAKIMA 2009 EXPENDITURE COMPARISON (Budget vs. Actual — December Year -to -Date) 2009 Amended 2009 Variance Funds Budget Actual Amount (1) Percent General $51,828,607 $49,794,628 $2,033,979 3.9% Parks and Recreation 4,377,543 4,208,433 169,110 3.9% Street & Traffic Operations 6,074,833 5,490,023 584,810 9.6% General Government Subtotal $62,280,983 $59,493,084 $2,787,899 4.5% Neighborhood Development $4,525,424 $2,541,863 $1,983,561 43.8% Utilities /Other Operating 59,555,944 55,299,912 4,256,032 7.1% Capital Improvement 62,374,249 22,163,686 40,210,563 64.5% G.O. Bonds /Notes 3,198,919 3,063,599 135,320 4.2% • Water /Sewer Revenue Bonds 2,860,417 2,860,416 1 0.0% Employee Benefit Reserves 13,596,013 13,045,459 550,554 4.0% Operating Reserves 3,811,525 3,337,269 474,256 12.4% Trust and Agency Funds 25,000 12,060 12,940. 51.8% Total $212,228,474 $161,817,348 $50,411,126 23.8% (1) Encumbrances: General Government encumbrances (which are not shown here) are $344,844 which reduces that variance to $2,443,055 or a 3.9% variance from budget. Total encumbrances for all funds are $4,703,175, which reduces the total variance to $45,707,951 or a 21.5% variance from budget. Most of this variance is the result of the timing of capital projects. If the capital projects are removed from the calculation, the remaining operating budgets were under spent by about 6.8 %. 411 Year -End Report 2009.doc 4 of 24 410 GENERAL GOVERNMENT BUDGET RESULTS In the City of Yakima, General Government is the term used to describe basic tax - supported activities, which are included in three funds: General Fund; Parks and Recreations Fund; and Street Fund. Chart II below summarizes actual performance compared to the amended budget for each of these funds individually, and in total. Chart II CITY OF YAKIMA 2009 GENERAL GOVERNMENT PERFORMANCE (Budget vs. Actual) / General Parks & Rec Street Fund (1) Fund Fund Total Beginning Balance Amended Budget $6,798,731 $451,356 $1,372,651 $8,622,738 Actual Beginning Balance 6,798,731 451,356 1,372,651 8,622,738 • (Gain) Loss $0 $0 $0 $0 Revenue Amended Budget $48,686,634 $4,244,385 $5,764,810 $58,695,829 Actual 47,595,699 4,096,632 5,578,638 57,270,969 Gain (Loss) ($1,090,935) ($147,753) ($186,172) ($1,424,860) Expenditures , Amended Budget $51,828,607 $4,377,543 $6,074,833 $62,280,983 Actual 49,794,628 4,208,433 5,490,023 59,493,084 Difference $2,033,979 $169,110 $584,810 $2,787,899 Ending Balance Budgeted $3,656,758 $318,198 $1,062,628 $5,037,584 Actual 4,599,802 339,555 1,461,266 6,400,623 Less: Encumbrances 299,225 0 45,619 344,844 Net Balance $4,300,577 $339,555 $1,415,647 $6,055,779 (1) Actual General Fund expenses, including encumbrances, were $2,498,154 more than actual General Fund revenues. The total General Government 2009 year -end balance, net of encumbrances, equals $6,055,779, ® 9.7% of the amended budget and $2,566,959 less than the beginning balance. The cash reserve position at the end of 2009 was $6,400,623, which is $2,222,115 less than the beginning balance. Year -End Report 2009.doc 5 of 24 Chart III presents a historical perspective of the total General Government reserve. In 2008, total revenues exceeded total expenditures by $436,522, thereby adding to the reserve balance. The 2009 budget was adopted using about $2.11 million of reserves —the encumbrance ordinance of about $450,000, and other appropriations, primarily for the Criminal Justice system, of about $1.02 million increased the reliance on reserves to $3.585 million. When the Budget Wrap -up document was presented at the end of November, 2009, the year -end estimates had both revenues and expenditures coming in below budget, which produced a projected ending balance of $2.776 million. Actual revenues were still $162,676 below the estimate, while expenditures were $716,920 below estimate, reducing the use of reserves by $544,244. Over the prior ten years (1999 through 2008), revenues have exceeded budget from a minimum of $536,000 to a maximum of $1,984,000, annually averaging $1,340,000. During this same time, expenditures have remained below budget in the range of $1,155,000 to $2,152,000, averaging $1,662,000. Therefore, over the last decade, an estimated use of reserves of about $3.0 million ended up being the "break even" level. 2009 was the first time in many years that revenue did not even meet expected levels. As this was recognized early in the budget year, cost containment measures held expenditure levels well below historical savings levels to keep ending reserves within minimum guidelines. Chart III GENERAL GOVERNMENT RESERVES • USAGE AND BALANCE COMPARISON (1) (2) (3) (4) (5) 2009 2009 2009 Wrap -up Actual 2008 Amended Year -End as of Variance Actual Budget Estimate 4/15/10 (4 -2) Beg. Reserve Balance $8,186,216 $8,622,738 $8,622,738 $8,622,738 Revenue 57,435,372 58,695,829 57,433,645 57,270,969 Total Resources 65,621,588 67,318,567 66,056,383 65,893,707 (1,424,860) Expenditure Budget 56,998,850 62,280,983 60,210,004 59,493,084 (2,787,899) End. Reserve Balance 8,622,738 5,037,584 5,846,379 6,400,623 % of Annual Expenditures n/a 8.1% 9.7% 10.8% Incr. / (Decr.) in Res f/ Prior Year. $436,522 ($3,585,154) ($2,776,359) ($2,222,115) % of Expenditure Budget n/a -5.8% -4.6% -3.7% (1) The appropriation for one -time encumbrances from the 2009 General Government Budget will utilize $344,844 of this actual beginning balance. 411 Year-End Report 2009.doc 6 of 24 • Chart IV illustrates the General Government Amended 2009 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. Chart IV CITY OF YAKIMA 2009 GENERAL GOVERNMENT REVENUE (Budget vs. Actual - December Year -to -Date) 2009 Amended Actual Variance GENERAL FUND Budget To -Date Amount Percent Revenue Property Tax $7,726,000 $8,057,000 $331,000 4.3% Criminal Justice Sales Tax .3% 1,720,450 1,619,573 (100,877) (5.9 %) Criminal Justice Sales Tax .1% 983,150 902,308 (80,842) (8.2 %) Retail Sales & Use Tax 13,927,830 12,623,990 (1,303,840) (9.4 %) Franchise Fees 47,586 52,945 5,359 11.3% Utility Tax 11,615,130 12,040,938 425,808 3.7% Business License Tax 520,000 519,941 (59) 0.0% Gambling Tax 932,000 923,090 (8,910) (1.0 %) • Dangerous Bldg Tax Assess. 30,000 22,509 (7,491) (25.0 %) Leasehold Excise Tax 200 18,623 18,423 9311.5% Police Federal Grants 348,459 176,465 (171,994) (49.4 %) Fire Federal Grants 60,000 69,000 9,000 15.0% Criminal Justice Funds 431,000 645,935 214,935 49.9% Liquor Excise Tax 420,000 411,997 (8,003) (1.9 %) Liquor Profits 619,500 580,137 (39,363) (6.4 %) School Resource Officers 370,440 363,512 (6,928) (1.9 %) Other Intergovernmental 641,109 806,553 165,444 25.8% Licenses and Permits 814,000 711,835 (102,165) (12.6 %) Charges for Service 4,880,680 4,719,210 (161,470) (3.3 %) Fines and Forfeitures 1,632,900 1,631,593 (1,307) (0.1 %) Misc. Revenue 925,200 657,445 (267,755) (28.9 %) Non - Revenue 1,000 1,100 100 10.0% Transfers From Other Funds 40,000 40,000 0 0.0% Total Revenue 48,686,634 47,595,699 (1,090,935) (2.2 %) Plus: Beginning Fund Balance 6,798,731 6,798,731 0 Total Resources 55,485,365 54,394,430 (1,090,935) (2.0 %) Less: Expenditures 51,828,607 49,794,628 2,033,979 3.9% Ending Fund Balance 3,656,758 . 4,599,802 943,044 25.8% ® Less: Encumbrances 0 299,255 299,255 Net Fund Balance $3,656,758 $4,300,547 $643,789 Year -End Report 2009.doc 7 of 24 Chart IV (Continued...) • 2009 Amended Actual Variance Budget To -Date Amount Percent Parks and Recreation Fund Property Tax $1,800,000 $1,623,500 (176,500) (9.8 %) Intergovernmental 180,200 178,965 (1,235) (0.7 %) Charges. for Services 934,265 898,505 (35,760) (3.8 %) Misc. Revenue /Non- Revenue 255,920 218,863 (37,057) (14.5 %) Transfers From Other Funds 1,074,000 1,176,799 102,799 9.6% Total Revenue 4,244,385 4,096,632 (147,753) (3.5 %) Plus: Beginning Fund Balance 451,356 451,356 0 0.0% Total Resources 4,695,741 4,547,988 (147,753) (3.1 %) Less: Expenditures 4,377,543 4,208,433 169,110 3.9% Ending Fund Balance 318,198 339,555 21,357 6.7% Less: Encumbrances 0 0 0 0.0% Net Fund Balance 318,198 339,555 21,357 6.7% Street/Traffic Fund ill Property Tax $4,314,000 $4,209,000 ($105,000) (2.4 %) County Road Tax 0 8,463 8,463 0.0% Fuel Tax - Street 1,350,000 1,249,776 (100,224) (7.4 %) Other Intergovernmental 0 33,535 33,535 0.0% Charges for Services 15,760 30,453 14,693 932.0% Misc. Revenue /Non- Revenue 85,050 47,411 (37,639) (44.3 %) Total Revenue 5,764,810 5,578,638 (186,172) (3.2 %) Plus: Beginning Fund Balance 1,372,651 1,372,651 0 0.0% Total Resources 7,137,461 6,951,289 (186,172) (2.6 %) Less: Expenditures 6,074,833 5,490,023 584,810 9.6% Ending Fund Balance 1,062,628 1,461,266 398,638 37.5% Less: Encumbrances 0 45,619 45,619 0.0% Net Fund Balance $1,062,628 $1,415,647 $353,019 33.2% General Government Summary Resources $67,318,567 $65,893,707 ($1,424,860) 6.2% Expenditures 62,280,983 59,493,084 2,787,899 4.5% Ending Fund Balance 5,037,584 6,400,623 1,363,039 28.1% 0 Less: Encumbrances 0 344,844 344,844 Net Fund Balance _ $5,037,584 $6,055,779 $1,018,195 21.3% Year -End Report 2009.doc 8 of 24 III General Government Budget Results (Continued...) General Government Resources In total, General Fund 2009 actual revenue was under the amended budget by $1,090,935. Significant individual categories demonstrating changes from the amended budget included: Retail Sales & Use Tax - down ($1,303,840); Utility Taxes - up $424,808; Miscellaneous Revenue (primarily interest earnings) - down ($267,755); and Criminal Justice -State shared revenue - up $214,935. Property Tax is allocated in each budget cycle to General,' Parks, Streets, Fire Capital Debt Service, and Fire Pension funds. The Citywide budget for 2009 was $15,640,765, while actual collections totaled $15,569,614, a variance of ($71,151) (less than .5 %). Receipts were slightly less than originally anticipated because the beginning of the economic crisis was rooted in the housing market, which had an impact on collections Countywide. It should be noted that Property Tax is the only major revenue source allocated to each of the General Government operating funds. Therefore, when budget reductions were made in the Parks and Streets funds, a re- allocation of property tax was used to balance these funds which resulted in the variances displayed in the prior chart. Sales Tax of $12,623,990 ended the year about 9.2% less than the 2008 actual of $13,719,058, and 0 $1,303,840 or 9.4% less than the 2009 budget. The downward trend in sales tax receipts started in the 4th quarter of 2008, extending throughout 2009, and into 2010. This was noted early in 2009, and a budget reduction plan was implemented in April 2009 to address the projected shortfall. Prior to the recession, Sales Tax has been shored up 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. Even though the recession hit all areas of the country, it appears that the agricultural sector has not been as negatively affected as many other sectors of the economy. Statewide, cities experienced a decline of almost 14% for the calendar year 2009 compared to 2008. The actual receipts were slightly above the revised year -end estimate. Criminal Justice Sales Tax distributions experienced similar trends. The first quarter of 2010 has experienced a continuation of downward trend; therefore, the 2010 expenditure reduction is being modified to take into consideration the extension of economic downturn. Utility Taxes of $12,040,938 increased by $425,808 or 3.7% over the 2009 amended budget, ending up 8.9% more than 2008 actual. The natural gas utility taxes are ahead of budget by 19.0 %, because of collections in new annexation areas, weather patterns and a rate increase. In general, utility taxes exhibit growth from usage fluctuations and /or rate adjustments. Police Federal Grants - down ($171,994), primarily the result of timing of the Byrne and COPS grants (rebudgeted in 2010). The program expenditures were also forwarded into 2010. fa Year -End Report 2009.doc 9 of 24 General Government Budget Results (Continued...) • Criminal Justice Funds received from the state experienced gains of $214,935 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 2009 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. Charges for Services was under budget by ($161,470) or 3.3 %. About $100,000 of this decrease was the customer service charge that is billed to the utilities —as this is annually a balanced transaction (i.e. revenue equals expenditures), this did not affect total reserves. The other major component in this category affected by the falling economy was plan review fees, which were under budget by about $94,000. This reduction was also noted early in the year, and the year end estimate was reduced accordingly. Miscellaneous Revenues consist primarily of interest earnings. Because of the downturn in rates of return for eligible investments, 2009 ended ($267,755) below budget. This reduction was also anticipated and included in the year end estimate. The General Fund 2009 year -end balance was originally estimated to be $4,328,549 in the 2010 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 $271,253 to a total of $4,599,802. Bear in mind, however, that the 2010 budget has been amended to provide for $299,225 in year -end encumbrances, (e.g., 2009 expenditures carry -over to 2010). The General Fund revised balance for year -end 2010 is estimated to be $2,940,248, and is to be maintained as a cash flow reserve, and as a reserve for unanticipated fiscal impacts, such as the continuing reductions in revenues because of the ongoing recession. After including encumbrances, a total of $1,659,524 has been used as a resource to balance the amended 2010 budget, if needed. Note: The 2009 amended budget allocated $3,141,973 of reserves to balance. However, even though the revenues did not reach estimates by about $1 million, expenditures were curtailed by about $2 million so that General Fund only used $2.2 million to balance in 2009. When the 2009 General Fund revenues (excluding beginning fund balances) are compared to prior year, there is an increase of $145,014 or 0.3% from $47,450,685 to $47,595,699, even amid a national recession (See Table I attached.) (If the reallocation of property taxes into General Fund is not included in the calculation, total revenues decreased by $185,986). General Fund expenditures saw an increase of $2,878,585 or 6.1% over 2008 actual levels. Several factors combined to create this increase: ➢ 2008 and 2009 bargaining unit settlements included some catch -up provisions, since all bargaining units agreed to freeze wages in 2007; > An escalation in outside jail costs; and > New public safety grants. Year -End Report 2009.doc 10 of 24 • General Government Budget Results (Continued...) With revenues feeling the pressure of the national recession and expenditures responding to the economic issues listed above, General Fund used reserves, but not to the extent originally projected. However, it took directed budget constraints to accomplish this. Because of the concern of ongoing sustainability of services, the Council Budget Committee continues to review General Government operations. As 2010 unfolds, this committee will review the various dynamics that affect the budget, and report on those findings. Continuing revenue reductions has also prompted City Management to create a cost containment plan. Staff will continue to monitor revenues and expenditures. Overall, General Fund Resources, which include the Beginning Fund Balance, were $1,090,935 or 2.0% less than the 2009 Amended Budget; and were within 0.4% or $207,635 above year -end estimates presented in the 2010 Budget Wrap -up. General Fund expenditure savings, after providing for year -end encumbrances and adjustments, amounted to $1,734,754 or 3.3% of the • authorized 2009 budget. • Parks and Recreation actual resources were ($147,753) or 3.1% less than the amended budget for 2009. Major components of this variance include the reallocation of property taxes back to General Fund by an amount similar to the planned cost reduction measures. The transfer of 0 utility taxes exceeded budget (See discussion on utility taxes above). Expenditures were below the authorized amended budget for 2009 by $169,110 or 3.9 %. The year -end balance for the Parks and Recreation Fund of $339,555 is $111,801 less than the beginning balance. The 2010 budget is virtually balanced, and currently anticipates restoring $28,330 to the minimum fund balance. Therefore, the Parks Fund revised balance for year -end 2010 is now estimated to be $367,885. Street Fund resources were ($186,172) or 2.6% less than the amended budget. Reductions in Gas tax related to decreased volume of fuel sales state -wide; the reallocation of property taxes; and the decline in interest earnings contributed to this shortage. Expenditures were under budget levels by 9.6% or $584,810, caused cost containment measures focused primarily in position vacancies. The year -end balance is increased by $88,615 to $1,415,647. After considering encumbrances of $45,619, the Street Fund's revised balance for year -end 2010 is now estimated to be $1,265,414. Chart V summarizes the actual status of General Government expenditures through year -end 2009, and compares these expenditures to amended budget authorization levels. 0 Year -End Report 2009.doc 11 of 24 Chart V 0 CITY OF YAKIMA 2009 GENERAL GOVERNMENT EXPENDITURES (Budget vs. Actual- December Year - to - Date) 2009 2009 Year -End Unexpended / Percent Amended Expenditures Encum- Uncommitted Spent Budget To 12/31/09 brances Balance Committed Police 23,378,366 22,829,884 $8,409 540,073 97.7% Fire 8,909,315 9,063,500 0 (154,185) 101.7% Information Systems 2,823,003 2,450,100 277,451 95,452 96.6% Transfers To Other Funds 2,232,275 2,272,933 0 (40,658) 101.8% Code Administration 1,783,856 1,559,823 3,760 220,273 87.7% Police Pension 1,403,957 1,316,580 0 87,377 93.8% Legal 1,459,796 1,160,611 0 299,185 79.5% Financial Services 1,540,878 1,471,508 0 69,370 95.5% Municipal Court 1,321,304 1,278,903. 0 42,401 96.8% i Engineering 1,199,716 . 1,026,172 5,000 168,544 86.0% Utility Services 1,225,469 1,130,716 0 94,753 92.3% Planning 901,557 799,520 ' 0 102,037 88.7% Human Resources 494,040 454,937 0 39,103 92.1% City Manager 521,307 503,378 0 17,929 96.6% Records 449,013 380,613 0 68,400 84.8% City Hall Maintenance 426,178 410,184 0 15,994 96.2% Indigent Defense 425,000 429,570 0 (4,570) 101.1% Purchasing _ 348,140 331,879 0 16,261 95.3% Intergovernmental 436,097 395,086 0 41,011 90.6% City Council 213,540 197,458 0 16,082 92.5% SunDome 150,000 150,000 0 0 100.0% State Examiner 103,000 102,600 0 400 99.6% Urban Area Hearings Exam. 56,000 51,396 4,605 (1) 100.0% Probation Services 25,000 25,000 0 0 100.0% District Court 1,800 2,277 0 (477) 126.5% Total General Fund 51,828,607 49,794,628 $299,225 1,734,754 96.7% Parks & Recreation Fund 4,377,543 4,208,433 0 169,110 96.1% Street & Traffic Ops. 6,074,833 5,490,023 45,619 539,191 91.1% Total General Government 62,280,983 59,493,084 $344,844 2,443,055 96.1% 411) Year -End Report 2009.doc 12 of 24 • General Government Budget Results (Continued...) As the recession eroded General Government revenues, cost containment measures were put in place in April. Many of the large positive variances are the result of these reductions. In addition to the concentrated effort to reduce variable costs by doing such things as holding vacancies and cancelling contracts, all operating divisions were also positively affected by a significant reduction in fuel prices and a reduction in retirement system rates. Notable deviations from budgetary authorizations after including year -end encumbrances, were as follows: Police Department expenditures after encumbrances were below the amended budget by $540,073 or 2.3 %, due primarily to savings from position vacancies, coupled with the successful implementation of measures to reduce jail costs. Fire Department, the 2nd largest General Government budget, ended the year more than the amended budget by ($154,185); expending 101.7% of its approximately $8.9 million budget. The overages were the result of a combination of significant overtime caused by major fires throughout the year, and underestimating the year -end unused holiday pay cash -out. • Information Systems came in $95,452 or 3.4% under budget in response to reductions in temporary assistance to install technology in new police cars and computer equipment replacement. Transfers to Other Funds was over - budget by ($40,658), as the underlying utility revenue that is the basis for a major transfer to Parks and Recreation came in a little better than expected. Several operating divisions in the General Fund ended 2009 under budget primarily due to salary savings: • Code Administration had several vacancies throughout the year, resulting in a savings of $220,273 from the 2009 budget. • Legal Department also experienced several vacancies, bringing expenditures $299,185 or 21.5% less than budget. • Financial Services spent $69,370 or 4.5% less than the 2009 budget, because of the vacancy of an Accountant (subsequently eliminated for the 2010 budget). Additionally, there was turnover in other existing staff throughout the year. • Engineering was $168,544 or 14.0% under budget, attributable primarily to the long -term vacancy of a position, and reduced use of temporary staff, both ultimately eliminated in the 2010 budget. Additionally, the budget included a cash -out estimate for an employee who was eligible to retire, but chose to continue employment into 2010. • Utility Services ended 2009 under budget by $94,753 or 7.7 %, because of turnover in the • existing staff, and delayed implementation of the acceptance of debit /credit cards to pay utility bills. Year -End Report 2009.doc 13 of 24 General Government Budget Results (Continued...) • Police Pension was underspent by $87,377 or 6.2 %. This was the function of fewer pensioners requiring stays in a long -term care facility, and the passing of 4 pensioners during the course of the year. Planning experienced savings of $102,037 or 11.3% below the 2009 budget, primarily the result of a reduced volume of land use change requests which affected line items such as postage, advertising and printing costs. Human Resources spent $39,103 or 7.9% less than its 2009 budget, primarily because the City was able to use training programs with little or no out of pocket costs for temporary assistance, which also eased the need for overtime. Records saved $68,400 or 13.2 %, because election costs were about $50,000 less than budgeted, and the municipal code update was less than anticipated. Indigent Defense overspent by ($4,570) or 1.1% of the 2009 budget, primarily as a result of the mid -year increase in the contract to require indigent defense attorneys to be present at arraignment hearings, in order to reduce jail costs. 0 The Intergovernmental category typically ends a year close to the budgeted amount. However, in 2009, this is below budget by $41,011 because the contract to Yakima Basin Storage Alliance was discontinued mid -year. Additionally, the contract for the community policing component of the federal Byrne grant was originally budgeted for the full year, but was not begun until mid -year. City Council ended 2009 $16,082 or 7.5% below budget, mostly because of a concentrated effort to reduce mobile communication and travel /training costs. District Court reimbursements were more than the budget by ($477). The 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 $169,110 or 3.9% below budget, due primarily to salary savings from vacancies, and the mid -year cancellation of the contract for the inmate work release program. Street and Traffic Operations expenditures were $539,191 - 8.9% less than budget, primarily due to salary savings. There were several positions vacant for various amounts of time throughout the year. This budget was also affected by the cancellation of the inmate work release program, and the drop in fuel prices. III Year-End Report 2009.doc 14 of 24 0 OTHER OPERATING / ENTERPRISE FUNDS Table IV attached depicts the City's Operating and Enterprise Funds. The Economic Development Fund revenues of $218,484 consist of the allocation approved by the state legislature for economically challenged communities and interest. Additionally, in 2009 the state started to measure the "base" sales tax generated in the LIFT Redevelopment Area (i.e. Yakima Resources long -range plan). Although this revenue was historically recorded as general sales tax, a portion of this sales tax (about $80,000) was allocated to this fund to provide adequate funding for planning efforts pertaining to this major economic development project. The City also obtained County SIED funding of $50,000 for planning efforts related to this project. Expenditures were $109,806 or 75.1% 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, including Downtown revitalization. Additionally, a small portion of the Community & Economic Development administrative staff costs are allocated to this budget. The ending fund balance is $298,833, which will continue to be used to support programs which promote economic development. The Neighborhood Development Fund ended 2009 with a fund balance of $377,304. Actual ii expenditures equaled $2,541,863 - 56.2% of budget, and revenues amounted to $2,629,397 - 59.9% 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,208,136 to carry - forward into the 2009 budget, which represents the unspent balance of Federal grants awarded in 2009 and prior. The single family homeownership programs and support for infrastructure improvement are the major components in the unspent balance. Community Relations revenues of $509,259 were 84.3% of the amended budget, because the budget erroneously included an estimate for a capital contribution from the cable provider, which has made these contributions according to the franchise agreement. Cable franchise fees demonstrated a 2.9% increase from 2008 actual. Expenditures equaled $478,730 - 82.9% of the 2009 amended budget authorization. The year -end fund balance of $893,104 includes the carry forward of capital grant resources from the cable TV franchise provider, per contract (as mentioned above). The Community Services Fund includes the Healthy Families Yakima grant funded program. Expenditures of $342,254 were 70.2% of budget, because of greater than anticipated in -kind donations. Revenues of $336,685 consist of grant reimbursements and donations. The ending balance is $5,599. For the program to continue as designed, donations will need to be secured to match the grant, as there is a 34% match requirement. . Growth Management Fund has a year -end balance of $24,372. The only activity contemplated in 0 this fund relates to grant- supported growth management planning projects, which are rebudgeted in 2010. The cash balance is restricted as program/local match for these grants. 15 of 24 Year -End Report 2009.doc Other Operating / Enterprise Funds (Continued...) 0 Cemetery Fund revenues were $268,425 - 108.3% of amended budget estimates and expenditures equaled $247,877 - under the amended budget by 4.8% or $12,543., The year -end Cemetery fund balance is $87,167. Revenues included a subsidy of $50,000 from the Parks and Recreation Fund that was required to maintain an adequate fund balance. Emergency Services Fund actual revenues equaled $1,048,696 - 99.0% of budget estimates. The EMS levy is an allocation of the countywide property tax based on population and call volume. Expenditures equaled $1,166,738 - 99.9% of budget. The year -end balance is $63,379. Public Safety Communications revenues were $2,893,752 - 99.4% of budget and expenditures - equaled $2,900,801 - 95.8% of budget, primarily due to temporary position vacancies. The ending fund balance is $256,883, which is an 8.5% reserve — within guidelines. 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 2009 were $310,672 consisting of the first distribution from CCNU after it was dissolved, and ARRA grant reimbursement. Grant expenditures were $99,575, leaving $211,097 as a fund balance. ID Parking and Business Improvement (PBIA) Fund actual revenues of $202,993 were 96.6% of budget estimates and expenditures were $201,849 - 98.7% of budget. The contract with the Committee for Downtown Yakima calls for them to receive all DYBID receipts less administrative costs. The year -end balance is $2,640. Trolley Fund total revenue was $8,353, while expenditures were $6,209 or 2.5% of budget. The year -end balance is $4,934. The budget included a reimbursable grant to refurbish the trolley barn which will be carried forward into 2010. Front Street Business Improvement Area (FSBIA) total revenue was $3,970 - 112.3% of budget and expenditures for marketing /improving the area were $3,024 - just slightly over budget by $24. The FSBIA is in the process of designing plaques for the area that detail the historical significance of the buildings, and cost of one plaque exceeded the estimate. Revenue was sufficient to cover this overage. The year -end balance is $8,413. Convention Center (Tourist Promotion Fund) actual revenues were $1,327,949 or 93.5% of budget estimates, as the economic downturn affected Hotel /Motel tax and convention volume. This was identified early in the year, so that program expenditures could be reduced coming in at $1,313,109 - 89.1% of the amended budget for 2009, and below actual revenues. The year -end fund balance is $245,144 or 10.9% of the budget. S Year -End Report 2009.doc 16 of 24 1111) Other Operating / Enterprise Funds (Continued...) Public Facilities District - Convention Center Fund realized revenues of $667,250 - 92.8% of the 2009 budget, as falling sales taxes affected this revenue. _ This was recognized early enough in the year to reduce expenditures to $657,871 - 94.5% of budget, and below actual revenues. The ending fund balance is $155,887. • Tourism Promotion Area Fund receipts and expenditures amounted to $368,978 or 91.1% of the 2009 budgets. The ending balance at December 31, 2009 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. Public Facilities District - Capitol Theatre Fund realized revenues. of $502,882 - 101% of the 2009 budget. Expenditures which include transfers of $220,000 to the Capitol Theatre construction fund and $246,000 to make the first debt service payment on the 2009 bond issue were $479,252 - 96.2% of budget, and below actual revenues. The ending fund balance is $23,630. Capitol Theatre Fund actual revenues of $298,627 were 94.9% of amended budget estimates because of the drop in Hotel/Motel taxes. Expenditures were $318,647 slightly over - budget by $134, as the ongoing construction project strained the operating maintenance budget. The balance at year -end is $128,805. 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. When the grant was originally awarded in late 2009, actual expenditures were not anticipated to be incurred in 2009, therefore, the entire grant of $814,000 was included in the 2010 budget. However, one program was begun with $7,563 spent in 2009. Even though the budget was not formally set up in 2009, Council had previously approved the grant terms. Matching grant revenue is also recorded, so that there is no fund balance. This grant activity is anticipated to ramp up in 2010. Stormwater Operating Fund concluded its second year of operations with revenue of $1,773,236 or 98.8% and expenditures of $1,637,880 or 90.9% of budget. The largest variance arose from salary savings from position vacancies, as the program is still in its start -up phase. The ending balance is $473,641, which will be available for cash flow purposes, as the stormwater receipts follow the property tax cycle (i.e. most receipts are in April and October). Transit Operating Fund revenues of $6,916,459 were 4.3% less than budget estimates. Approximately $4.1 million of Transit Sales Tax was allocated to this budget, while State and Federal operating grants were $1.8 million. The remaining $1.0 million is derived from fares, including the contract with Selah, vanpool, advertising, etc. Expenditures were $6,829,986 - 91.6% of the amended budget. Over half of this variance can be attributed to the reduction in fuel prices. The year -end fund balance is $673,230. The reduction in sales tax affected this budget in 2009. lio However, the steep decrease in fuel prices negated the reduction in revenue, so service reductions were not needed in 2009. This fund will be monitored closely in 2010 - -if sales tax continues to decline, service reductions may need to be implemented. Year -End Report 2009.doc . 17 of 24 Other Operating / Enterprise Funds (Continued...) • Refuse Fund revenues were $4,633,948 - 100.4% of the budget estimate. Actual expenditures were $4,617,358 - 99.3% of budget. The year -end fund balance is $220,677, which is 4.7% (still slightly below the guidelines, but improved from the prior year). Wastewater Operating Fund actual revenues equaled $17,307,692 - 3.6% above amended budget estimates, notably from higher than anticipated strong waste revenue. Expenditures were $16,867,157 - 99.9% of authorized levels to maximize transfers to capital funds. The year -end fund balance is $2,169,399. Water Operating Fund actual revenues were $7,547,553 for 2009 - 109.4% of budget estimates, driven by increased volume, and reimbursement for work done on capital projects. Expenditures were $7,297,514 - 99.9% of authorized budget levels. The year -end fund balance is $2,110,760. Irrigation Fund actual revenues equaled $2,661,802 - 99.9% of budget estimates. Expenditures were $2,643,303 or 94.9% of budget. The savings arise from position vacancies and a reduced need for outside professional services for ongoing maintenance. This includes 'a transfer to the capital fund and debt service fund totaling $1.25 million in compliance with the capital charges billed by the irrigation utility. The balance at year -end was $281,764. Equipment Rental Fund expenditures equaled $5,094,648 and were 84.9% of the amended budget. Revenues of $4,971,246 were 86.5% of budget estimates, as the transfers for additions to fleet were conservatively budgeted — actual costs and charges to the operating divisions for fuel were less than anticipated by over $800,000. The $4,220,039 year -end balance primarily represents the City's Equipment Replacement Reserve. Environmental Fund revenues equaled $412,991 or 38.3% of budget estimates. Expenditures were $459,121 or 33.2% of budget, as the dirt removal associated with Richardson Airway, and Airport tank cleanup projects were both underway, but had a combined balance of $345,000 carried forward into the 2010 budget. The fuel capacity expansion project has been delayed, and was already rebudgeted in 2010. The year -end fund balance is $468,114. Public Works Administration Fund actual revenue for 2009 was $1,190,260 - 97.6% of budget estimates. Actual expenditures totaled $1,150,662 - less than the amended budget by 4.1% as this budget also participated in the mid -year cost containment plan and eliminated a vacant position. The year -end fund balance is $214,391. Summary Other Operating and Enterprise Funds generated revenues of $59,019,122 - 95.0% of budget estimates; expenditures equaled $57,841,775 and were 90.3% of the authorized budget. The Total Other Operating Enterprise Funds carry forward fund balance is $13,619,620. (About $4.2 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 14.7% of the budget, or just slightly less than a 2 month operating reserve. Year -End Report 2009.doc 18 of 24 CAPITAL FUNDS Table V represents the fiscal status of Capital Construction and Reserve Fund budgets for 2009. The Arterial Street Fund reflects an actual expenditure level of 46.9 %, or $3,816,626 for 2009. The major projects substantially completed in 2009 were the Nob Hill bridge repair; Nob Hill street improvements /widening from 53 to 72 Avenue; and the William 0. Douglas Trail Projects. Incomplete projects to be carried forward into the 2010 budget include Coolidge Avenue improvements; 66th and Summitview signalization; and the reconstruction project at 16th and Washington Avenues. Revenue equals $3,131,345 or 47.1% of budget estimates and is derived from Federal and State shared funds. Gas Tax funds are allocated monthly and expenditures are based on an approved project prospectus. The fund balance at year -end is $1,182,317. The Central Business District (CBD) Capital Fund is used to account for comprehensive downtown planning and redevelopment efforts. Expenditures in 2009 included wrap -up of Phase III, and start -up of Phase IV of Downtown Redevelopment/Pedestrian project, to be supported by State grants; and the contract with the Committee for Downtown Yakima (CDY) for CBD maintenance, along with the purchase of the new parking meters for the lots. These totaled $286,908 - 61.1% of budget authorizations and revenue totaled $102,617 - 286.6% of budget, representing grant reimbursement for Phase III and monthly parking permits. The year -end 11111 balance is $431,955. Capitol Theatre Construction Fund is used to account for capital grants /improvements for the Theatre. Revenues were $7,618,631 or 72.9% of the budget consisting primarily of bond proceeds, while expenditures consisting of costs for the planned improvements to the production center were $3,255,726 or 33.2% of budget. The unspent appropriation will be carried- forward to 2010. The balance at December 31 is $4,430,290 —the major component being unspent bond proceeds. The Parks and Recreation Capital Funds actual revenue equaled $268,148 or 21.6% -- (consisting primarily of a transfer of REET 1 resources of $250,000) while actual expenditures through year -end 2009 were $253,901 - 17.2% of the amended budget. The major project included in the 2009 budget but just in start -up phase is the development of upper Kiwanis Park. The unspent balance along with the applicable financing is being rebudgeted for 2010. The year -end fund balance is $189,626. The Fire Capital Fund experienced actual expenditures of $428,181 - 26.5% of budget, including a first installment on the new ladder truck, and initial costs for the remodel of Station 94 (located at the Airport). Revenues were $343,604 - 101.0% of budget estimates. The major components of revenue include a transfer of $178,000 of REET 1, which can be used for Fire capital needs relating to property/building improvements, but not rolling stock; and a transfer from the EMS Fund of $95,000 to support apparatus replacement. The ladder truck is rebudgeted in 2010 by its inclusion in the encumbrance ordinance. The year -end balance is $1,423,480. 110 Year -End Report 2009.doc 19 of 24 Capital Funds (Continued...) • Law and Justice Capital Fund revenue, which included an allocation of Local Criminal Justice Sales Tax receipts, was $1,021,207 or 88.6% of budget, primarily because of the rebudgeting of a capital grant. Project and equipment expenditures (i.e. replacement vehicles, crime analysis software and hardware, purchase of property at 3 St. and Walnut, etc.) were $1,256,831 - 79.9% of authorized levels. The fund balance at year -end was $395,779. 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 2009 totaled $642,832. Of this amount, about $542,000 represents REET 1 proceeds; and $75,000 are transfers from other funds for debt service. Expenditures were $922,109 or 74.6% of budget during 2009. These include Debt Service -- $347,000; Parks and Fire Capital Contributions -- $428,000; and City Hall improvements -- $95,000. Savings resulted from the deferment of City Hall planned improvements. The balance at year -end is $1,172,053. 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 $553,616 - 67.5% of the budget, Expenditures were $714,318 - 43.0% of budget, as the grind and overlay project was postponed and the street chip sealing materials /projects were reduced because of the revenue shortfall. The balance at year end is $1,069,426. Note: Both REET revenues are particularly sensitive to the current economic condition, as housing sales were curtailed by the national banking crisis. The downturn was factored into the 2009 year end estimates and 2010 budget. 2009 revenues slightly exceeded the revised estimate, and 2010 is currently on par with 2009, so that the budgeted projects in 2010 can tentatively go forward, however, these reserves are being depleted, and future capital improvements may be postponed. 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 ($897,020) as there were two LID construction projects substantially completed, but not yet closed out as of December 31, 2009. The Transit Capital Reserve Fund has a year -end balance of $1,120,431 which represents the reserves that the City Council has directed be set aside to provide funds for equipment replacement. For 2009, the actual expenditures were $969,899 - 81.0% of budget. Encumbrances include about $38,000 for bus shelters and mobile radios. Revenues were $973,669 - exceeding budget estimates by $397,169 as Federal ARRA grant funds were awarded and received in 2009. Year -End Report 2009.doc 20 of 24 ® Capital Funds (Continued...) The Stormwater Capital Fund ended its second year with a balance of $519,875. Revenues of $440,000 exceeded the budgeted transfer from the operating fund because of other program savings. Expenditures of $47,369 or 14.6% of budget included drainage improvement projects. Projects to be carried forward into 2010 include Coolidge Rd, and. Nob Hill/Fair Ave drainage improvements. The Convention Center Capital Improvement Funds actual revenues were $246,103 consisting primarily of an allocation of Hotel/Motel tax and a contribution from the Public Facilities District. Revenues exceeded budget by $29,903 as insurance proceeds were received to properly address an ongoing maintenance issue. Expenditures were $65,820 - 24.3% of budget, and the encumbrance ordinance included a carry forward of $152,000 for the planned purchase of table drapes and stack chairs. The year -end balance is $487,629. • The Cumulative Reserve for Capital Improvement Funds actual expenditures were $1,694,952 - 8.6% of the amended budget primarily for preliminary Railroad /Grade Separation costs, which is being funded by State and Federal grants, and the Utility Management System, funded by transfers from the utilities. Revenues were $2,773,687, and the balance at year -end is $1,453,180. (Most of the railroad project is already rebudgeted in 2010). ® 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 - 100.8% 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 $333,953 - 92.0% of the budget authorization. The replacement of the Dystor digester covers was completed in 2009. The fund balance at year -end is $477,175. The Wastewater Collection System Project Fund provides principally for off -site system improvements such as new interceptor and trunk line extensions. For 2009, $1,273,000 in revenue came primarily from a Wastewater Operating Fund transfer. Expenditures of $55,057 were primarily for a sewer main project adjacent to West Nob Hill Blvd. Projects to be carried - forward into 2010 include improvements to the collection system in conjunction with the development of the Congdon annexation area and unsewered neighborhoods. The year -end balance is $3,923,500. In 2009 the Domestic Water Improvement Fund expenditures totaled $1,909,300 - 80.2% of budget, and included a new well at Gardner Park, and other watermain replacement projects. Revenue to this fund totaled $1,644,740 and included $625,000 from the Water Operating fund, $1.0 million from a Public Works Trust Fund loan for the Gardner Park well, and interest earnings. The balance of the 2009 budget was mostly rebudgeted °when the 2010 budget was adopted. The 2009 year -end balance is $2,548,686. Year -End Report 2009.doc 21 of 24 Capital Funds (Continued...) • Wastewater Facility Project Fund actual expenditures for 2009 were $3,512,377 — 59.2% of budget, for treatment plant projects. Actual revenues were $1,378,702 consisting primarily of $1.1 million from the Wastewater Operating fund, Public Works Trust Fund loan proceeds of $115,000 for the ultraviolet disinfection project, with balance consisting of interest earnings and other miscellaneous contributions. The year -end balance is $3,822,844 to be used for the continuation of the capital program at the wastewater facility, and the 2010 budget will be adjusted with a non- lapsing appropriation as needed. The Irrigation System Improvement Fund was opened in 1998 to account for capital improvement projects. For 2009, revenue totaled $938,697 consisting of a transfer from operations, and interest earnings. Expenditures were $1,818 686 or 60.9% of the budget, which were spent primarily on the General, Hillcrest Buena Vista, and Capital Hill systems leaving a balance of $2,173,547. Construction on various sections of the system will be carried forward into the 2010 budget. Summary Capital Improvement Funds received revenues of $23,510,606 — 48.4% of budget estimates; expenditures equaled $22,163,686 and were 35.5% of the authorized budget. The carry forward fund balance is $25,924,773. Incomplete project balances were either already carried forward in • the 2010 budget, or will be recorded as non - lapsing appropriations. • Year -End Report 2009.doc 22 of 24 0 RESERVE FUNDS Table VI reflects the status of the City's Reserve Funds at year -end 2009. The Unemployment Compensation Reserve provides for unemployment claims filed by former employees. Through year -end 2009, the City had actual expenditures of $127,950 - 84.1% of the amended budget. Revenues were $117,392 - 8.1% above budget. The reserve balance at year -end is $385,940. Because of the continuing possibility of reductions in force in response to the economic downturn, rates were increased by 33% for 2010. V 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 $9,922,099 - 99.2% of the amended budget. Revenue of $9,600,778 was 103.1% of the amended budget, so that 2009 used reserves of over $320,000. The year -end balance is $2,774,763, 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, about $1.3 million 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 0 considering this transaction will be about $1.5 million. To accommodate health -care industry inflation y coupled with the City's experience, rates were increased by about 7.5% for the 2010 budget. Affordable insurance coverage continues to be the focus of the Insurance Board, and a change in benefit design was implemented in February 2010. This change is not expected to actually reduce plan costs, but to slow the growth of required premium contributions. ( 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,347,933 - 86.3% of budget estimates and expenditures were $1,317,593 - 77.8% of the amended budget. The Reserve Fund balance of $1,169,263 is the cash balance. For the same reasons discussed above, a liability will be presented in the financial statements of about $843,000 which will leave the fund balance of about $326,000. Because cash reserves were replenished in 2009, the 2010 rates were unchanged. The Wellness /Employee Assistance Program fund expenditures ended the year at $110,034 or 84.4% of budget. Revenues were $100,000 or 83.3 %, leaving a balance of $142,962. Revenues are recorded at the end of the year as medical insurance savings from vacant positions, therefore the balance needs to carry this fund's activity to the end of the next year. Firemen's Relief and Pension expenditures were $1,567,783 - 96.8% of budget through year -end 2009. Actual revenues were $1,485,075 - 92.3% of budget, as the property tax was reallocated to 0 support General Government operations. The fund balance at year -end is $745,923, and reflects the Pension Board's policy to build reserves for potential long -term medical care needs of the LEOFF I retirees. Year -End Report 2009.doc 23 of 24 OPERATING RESERVES • Table VI illustrates the position of the City's Contingency Reserve Funds. General Contingency Fund -- The year -end balance is $256,720. Capitol Theatre General Contingency Reserve -- For 2009, $71,927 was transferred to the Capitol Theatre Operating Fund to fund the Theatre's annual capital improvement program. Additional activity in this fund included providing a short -term inter -fund loan to the Capitol Theatre construction fund for project start -up costs needed prior to bond issuance. This resulted in an expenditure when borrowed, and a revenue when re -paid of $300,000, plus interest. The year -end balance is $451,642. 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,707,975, and expenditures equaled $2,845,143. Major expenses included: $313,000 for payments of claims, $948,000 for outside legal services (revenues include $366,000 of insurance reimbursement for services relating to prior City ownership of the Yakima Resources site), $260,000 for property insurance coverage, and $720,000 for general liability insurance. The year -end Risk Management fund balance is $1,009,599, before outstanding claims are. considered. The required claim reserve at December 31, 2009 is estimated to be about $976,000, which will result in an adjusted funded balance of about $33,000 to be reported in the 2009 financial statements. Even though the balance has slowly improved from a negative ($97,000) at the end of 2007, the reserve balance is not yet back to minimum levels. Therefore, the 2010 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 2010, 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 2009 year -end fiscal position reflects that the City of Yakima was able to effectively manage its economic environment. Year -End Report 2009.doc 24 of 24 • City of Yakima -. Table I Page 1 of 2 • ' ' General Government Resources 100.0% 3 Year Comparison - December 2009 Year to Date. of Year General Fund Resources: 2007 2008 2009 % % Amended % To -Date Rcvd To -Date Rcvd .Budget To -Date . Rcvd Property Tax $6,820,513 99.6% $7,437,787 101.5% $7,726,000 $8,057,000 104.3% Criminal Justice Sales Tax Inc .3% 1,492,194 104.0% 1,676,175 103.2% 1,720,450 1,619,573 94.1% Criminal Justice Sales Tax 885,966 105.2% 929,067 102.2% 983,150 902,308 91.8% Sales Tax 13,423,269 102.1% 13,719,058 100.3% 13,927,830 12,623,990 90.6% Franchise Tax Nob Hill Water Assn. - -2.0% 42,079 113.7% , 40,245 93.6% 47,586 52,945 111.3% Natural Gas -- (2.0% 2005) 0 0.0% 0 0.0% 0 0 0.0% Total Franchise Tax 42,079 113.7% 40,245 93.6% 47,586 52,945 111.3% Utility Tax . cific Power -- 6.0% 2,939,163 102.5% 3,405,099 113.0% 3,650,000 3,677,212 100.7% ob Hill Water Assn.--14.0% 296,557 107.9% 283,680 94.6% 330,000 ' 372,950 113.0% Natural Gas -- 6.0% (4% 2005) 1,496,781 . 99.8% 1,292,335 83.6% 1,339,000 1,593,020 119.0% Yakima Waste Systems - -10.0% 340,386 96.1% 329,913 94.8% 310,000 324,738 104.8% Cellular Telephone -- 6.0% 1,211,476 106.5% 1,446,082 123.2% 1,545,000 1,596,266 103.3% Telephone -- 6.0% 1,115,985 92.7% 1,074,537 . .86.7% 1,140,000 1,001,993 87.9% Water -- 14.0% 872,853 105.2% 883,411 97.5% 906,000 994,227 ' 109.7% Wastewater -- 14.0% 1,864,131 103.1% 1,963,497 101.3% 1,980,000 2,062,101. 104.1% • Refuse. - -9.0% 355,130 104.5% . 381,196 102.7% 415,130' 418,431 100.8% Total Utility Tax _ ' . 10,492,462 101.7% 11,059,750 102.1% 11,615,130. 12,040,938 103.7% Business License Tax 523,801 104.8% 533,091 106.6% , ' 520,000 519,941 100.0% Gambling Tax " 955,484 97.0% 913,885 96.1% 932,000 923,090 99.0% Dangerous Bldg Tax Assessment 21,771 n/a 39,064 . n/a 30,000 22,509 75.0% Leasehold Excise Tax . _ ' 4,121 2060.5% 3,992 1996.0% 200 18,623 9311.5% Total Taxes .. 34,661,660 101.5% 36,352,114 101.3% 37,502,346 36,780,91,7 98.1% Police Federal Grants ' . 216,232 127.2% 152,677 57.6% • 348,459 176,465 ' 50.6% .. Fire Federal Grants • - 89,186' 109.6% 72,000 102.9% 60,000 • 69,000 115.0% Criminal Justice Funds 582,169 148.1% ' 568,110 • 133.9% 431,000 645,935 149.9% Liquor Excise Tax 379,327 111.1% 403,020 102.5% , 420,000 411,997 98.1% Liquor Profits 608,770 101.0% 565,917 93.5% 619,500 580,137 93.6% School Dist. #7 Resource Officers 342,552 . . 99.8% 352,828 100.0% 370,440 363,512 • 98.1% Other Intergovermental 282,110: 107.1% 549,490 113.1% 641,109 806,553 125.8% •alInterovernmental 2,500,346 113.9% 2,664,042 102.6% 2,890,508 3,053,599 105.6% • erp 4/15/2010 Revenues Gen Gov- 2009.xls i City of Yakima Table I Page 2 of 2 General Government Resources 100.0% . 3 Year Comparison - December 2009 Year to Date of Year General Fund Resources (Contd.) 2007 2008 2009 Percent Percent Amended Percent To -Date Received To -Date Received Budget To -Date Received Licenses and Permits $982,084 124.6% • $993,122 114.0% $814,000 $711,835 87.4% Charges for Service 4,422,803 102.8% 4,808,037 107.5% 4,880,680. 4,719,210 96.7% Fines and Forfeitures 1,420,275 109.8% 1,582,815 114.8% 1,632,900 1,631,593 99.9% Misc. Revenue 974,239 124.5% 1,010,088 106.8% 925,200 657,445 71.1% Non- Revenue 14,946 1494.6% 467 46.7% 1,000 1,100 110.0% Transfers From Other Funds 40,000 100.0% 40,000 100.0% 40,000 40,000 100:0% Capital Lease Financing 38,293 0 0 0 Total General Fund Revenue $45,054,646 103.5% $47,450,685 102.8% $48,686,634 $47,595,699 97.8% Beginning Balance 5,439,858 100.0% 6,250,708 100.0% 6,798,731 6,798,731 100.0% Total General Fund Resources $50,494,504 103.1% $53,701,393 102.4% $55,485,365 $54,394,430 98.0% Parks & Recreation Fund Resources: Property Tax 1,938,000 100.0% 1,800,000 100.0% 1,800,000 1,623,500 Intergovernmental 167,291 92.3% 153,252 87.7% 180,200 178,965 99.3% Charges for Services 860,126 112.1% 886,086 97.0% 934,265 898,505 96.2% Misc. Revenue/Non- Revenue 240,523 93.9% 290,212 146.4% 255,920 218,863 85.5% Transfers From Other Funds 1,023,126. 103.8% 1,046,359 94.7% .1,074,000 1,176,799 109.6% Total Parks/Rec. Fund Revenue $4,229,066 102.4% $4,175,909 99.6% $4,244,385 $4,096,632 96.5% Beginning Balance 431,032 100.0% 549,439 100.0% 451,356 451,356 100.0% Total Parks/Rec. Fund Resources $4,660,098 102.2% $4,725,348 99.7% $4,695,741 $4,547,988 96.9% Street/Traffic Fund Resources: • Property Tax 3,920,202 100.0% 4,220,202 100.0% 4,314,000 4,209,000 97.6% County Road Tax 161,316 0.0% 9,260 0.0% 0 8,463 0.0% Fuel Tax - Street 1,374,901 97.6% 1,306,335 91.4% 1,350,000 1,249,776 92.6% Other Intergovernmental 14,396 0.0% 91,834 . 0.0% 0 33,535 0.0% Charges for. Services 77,227 454.3% 35,274 223.8% 15,760 30,453 ' 193.2% Misc. Revenue/Non- Revenue 125,656 209.3% , 145,373 242.1% 85,050 47,411 55.7% Total Street/Traffic Fund Revenue $5,673,698 101.2% $5,808,278 101.4% $5,764,810 $5,578,638 96.8% Beginning Balance 1,064,222 100.0% 1,386,069 100.0% 1,372,651 ' 1,372,651 100.0% Total Street /Traffic Fund Resources $6,737,920 101.0% $7,194,347 101.2% $7,137,461 $6,951,289 97.4% Total General Government Resources $61,892.522 102.8% $65,621,088 102.1% $67,318,567 $65,893,707 97.9% erp 4/15/2010 Revenues Gen Gov- 2009.xls • ' City of Yakima Table II General Government Summary of Operations 100.0% 3 Year Comparison - December 2009 Year to Date Of Year 2007 2008 2009 % % . Rcvd Rcvd Amended Rcvd To -Date Exp To -Date Exp Budget To -Date •Exp General Fund Beginning Balance $5;439,858 $6,250,708 $6,798,731 $6,798,731 Revenues $45,054,646 103.5% $47,450,685 102.8% $48,686,634 $47,595,699. 97.8% Expenditures $44,233,877 97.5% $46,916,043 96.8% $51,828,607 $49,794,628 96.1% Ending Balance $6,260,627 $6,785,350 $3,656,758 $4,599,802 Parks and Recreation Fund Beginning Balance : $431,032 $549,439 $451,356 $451,356 Revenues $4,229,066 102.4% $4,175,909 : 99.6% $4,244,385 $4,096,632 96.5% penditures $4,110,659 97.9% $4,274,493 96.7% $4,377,543 $4,208,433 96.1% • Ending Balance $549,439 $450,855 $318,198 $339,555 Street /Traffic Fund Beginning Balance $1,064,222 $1,386,069 $1,372,651 $1,372,651 Revenues $5,673,698 101.2% $5,808,278 101.4% $5,764,810 $5,578,638 96.8% Expenditures * $5,351,851 90.6% $5,821,695 • 93.7% $6 $5,490,023 90.4% Ending Balance $1,386,069 $1,372,652 $1,062,628. $1,461,266 Total General Government Beginning Balance $6,935,112 $8,186,216 $8,622,738 • $8,622,738 Revenues $54,957,410 103.2% $57,434,872 102.4% $58,695,829 $57,270,969 97.6% Expenditures • $53,696,387 96.8% $57,012,231 96.5% $62,280;983 $59,493,084. 95.5% Net General Government Balance • $8,196,135 • $8,608,857 $5,037,584 $6,400,623 erp 4/15/2010 Revenues Gen Gov- 2009.xls Table III City of Yakima • General Government Expenditures 2009 Budget vs. Actual as of December 31, 2009 2009 2009 Amended Expenditures Year -end Unexpended Budget To 12/31/09 Encumbrances Balance Police $ 23,378,366 $ 22,829,884 $ 8,409 $ 540,073 Fire 8,909,315 9,063,500 (154,185) Information Systems 2,823,003 2,450,100 277,451 95,452 Transfers To Other Funds 2,232,275 2;272,933 (40,658) Code Administration 1,783,856 1;559,823 3,760 220,273 Police Pension 1,403,957 1,316,580 87,377 Legal 1,459,796 1,160,611 299,185 Financial Services 1,540;878 1,471,508 69,370 Municipal Court 1,321,304 1,278,903 - 42,401 Engineering 1,199,716 1,026,172 5,000 168,544 Utility Services 1,225,469 1,130,716 94,753 Planning 901,557 799,520 102,037 Human Resources 494,040 454,937 39,103 City Manager 521,307 503,378 17,929 Records 449,013 380,613 68,400 City Hall Maintenance 426,178 410,184 15,994 Indigent Defense 425,000 429,570 (4,570) Purchasing 348,140 331,879 16,261 Intergovernmental 436,097 395,086 41,01.1 City Council 213,540 197,458 16,082 SunDome 150,000 150,000 0 State Examiner . 1 03,000 102,600 400 Urban Area Hearings Exam. 56,000 51,396 4,605 (1) Probation Services 25,000 25,000 0 District Court 1,800 2,277 (477) Total General Fund $ 51,828,607 $ 49,794,628 $ 299,225 1,734,754 Parks & Recreation Fund 4,377,543 4,208,433 169,110 Street & Traffic Ops. 6,074,833 5,490,023 45,619 539,191 Total General Government $ 62,280,983 $ 59,493,084 $ 344,844 2,443,055 erp 4/15/2010 2:26 PM Yr End 2009 report.xis City o iniia 111111 Other Operating /Enterprise Funds . 2009 Budget vs. Actual as of December 31, 2009 ' Actual Revenue Appropriations Beginning %_ % Ending Other Operating/ Balance Amended Actual Re- Amended Actual Ex- Balance Enterprise Funds 1/1/2009 Budget Revenue ceived Budget Expenditures vended 12/31/2009 Economic Development $ 190,155 $ 90,000 $ 218,484 242.8% $ 146,173 $ 109,806 75.1% $ 298,833 Neighborhood Development 289,770 4,388,602 2,629,397 59.9% 4,525,424 2,541,863 56.2% 377,304 Community Relations 862,575 604,420 509,259 84.3% 577,802 478,730 82.9% 893,104 Community Services • 11,168 522,712 336,685 64.4% 487,712 342,254 70.2% 5,599 Growth Management 24,372 25,466 0 0.0% 49,745 0 0.0% . 24,372 Cemetery 66,619 247,750 268,425 108.3% 260,420 247,877 95.2% 87,167 Emergency Services 18 1,059,476. . 1,048,696 99.0% 1,167,430 1,166,738 99.9% 63,379 Public Safety Communications 263,932 2,912,166 2,893,752 99.4% 3,028,165 .2,900,801 95.8% 256,883 Police Grants 0 534,191 310,672 58.2% 534,191 99,575 18.6% 211,097 P.B.I.A. (Parking & Business Imp.) 1,496 210,170 202,993 96:6% 204,592 . 201,849 98.7% 2,640 Trolley 2,790 249,348 8,353 3.3% 248,207 6,209 2.5% 4,934 Front Street B usiness Imp. Area • 7,467 3,535 3,970 112.3% 3,000 3,024 100.8% 8,413 Convention Ctr. (Tourist Promotion) 230,304 1,420,300 1,327,949 93.5% 1,474,205 1,313,109' 89.1% 245,144 Public Facilities District - Convention Ctr 146,508 719,000 667,250 92.8% 696,000 657,871 94.5% 155,887 Tourism Promotion Area 414 405,088 368,978 91.1% 405,088 368,978 91.1% 414 Public Facilities District - Capitol Theatre . 0 498,000 502,882 101.0% 498,000 479,252 96.2% 23,630 Capitol Theatre 148,825 314,567 298,627 94.9% 318,513 318,647 100.0% 128,805 Recovery Grants Program 0 0 7,563 0 7,563 0 StormwaterOperating Fund 338,285 1,795,000 1,773,236 98.8% 1,801,039 1,637,880 90.9% 473,641 Transit 586,757 7,223,591 6,916,459 95.7% 7,460,107 6,829,986 91.6% 673,230 Refuse 204,087 4,615,650 4,633,948 100.4% 4,652,022 4,617,358 99.3% 220,677 Wastewater Operating 1,728,864 16,702,714 • 17,307,692 103.6% 16,875,924 16,867,157 99.9% 2,169,399 Water Operating 1,860,721 6,898,837 7,547,553 109.4% 7,303,953 7,297,514 99.9% 2,1 10,760 Irrigation 263,265 2,665,250 2,661,802 99.9% 2,784,200 2,643,303 • 94.9% . • 281,764 Equipment Rental 4,343,441 5,749,355 4,971,246 86.5% 5,998,773 5,094,648 84.9% 4,220,039 Environmental 514,244 1,079,581 412,991 38.3% 1,381,220 • 459,121 33.2% 468,114 Public Works Admin. 174,793 1,220,130 1,190,260 97:6% 1,199,463 1,150,662 95.9% 214,391 Total Other Operating Funds $ 12,442,273 $ 62,154,899 $ 59,019,122 95.0% $ 64,081,368 $ 57,841,775 90.3% $ 13,619,620 erp 4/15/2010 1:45 PM Yr End 2009 report.xls Table V City of Yakima Capital Improvement Funds 2009 Budget vs. Actual as of December 31, 2009 Actual Revenue Appropriations Beginning % % Ending • Balance Amended Actual Re- Amended Actual Ex- Balance Capital Improvement Funds 1/1/2009 Budget Revenue ceived Budget Expenditures pended 12/31/2009 Arterial Street $ 1,867,598 $ 6,643,041 $ 3,131,345 47.1% $ 8,139,749 $ 3,816,626 46.9% $ 1,182,317 Transportation Improvement 0 0 0 0 0 . 0 Central Business District Capital 616,246 35,800 102,617 286.6% 469,235 286,908 61.1% 431,955 Capitol Theatre Construction 67,385 10,455,676 7,618,631 72.9% 9,811,426 3,255,726 33.2% 4,430,290 Parks and Recreation Capital 175,379 1,240,000 268,148 21.6% 1,475,000 253,901 17.2% 189,626 Fire Capital 1,508,057 340,153 343,604 101.0% 1,618,100 428,181 26.5% 1,423,480 Law and Justice Capital 631,403 1,153,150 1,021,207 88.6% 1,572,633 1,256,831 79.9% 395,779 Public Works Trust Construction 1,451,330 925,000 642,832 69.5% 1,235,570 922,109 74.6% 1,172,053 REET 2 Capital 1,230,128 820,000 553,616 67.5% 1,661,822 714,318 43.0% 1,069,426 LID Construction Control (82,075) 1,002,413 6,728 0.7% 827,000 821,673 99.4% (897,020) Transit Capital Reserve 1,1 16,661 576,500 973,669 168.9% 1,197,913 969,899 81.0% 1,120,431 Stormwater Capital Fund 127,244 350,000 440,000 125.7% 325,000 47,369 14.6% 519,875 Convention Center Capital Improvement 307,346 216,200 246,103 113.8% 270,770 65,820 24.3% 487,629 Reserve for Capital Improvement 374,445 19,465,100 2,773,687 14.2% 19,611,173 1,694,952 8.6% 1,453,180 Wastewater Facilities Capital Reserve 657,848 152,000 153,280 100.8% 363,186 333,953 92.0% 477,175 Sewer Construction 2,705,557 1,391,350 1,273,000 91.5% 2,491,332 55,057 2.2% . 3,923,500 Domestic Water Improvement 2,813,246 1,708,000 1,644,740 96.3% 2,380,100 1,909,300 80.2% 2,548,686 Wastewater Facility Project 5,956,519 1,161,000 1,378,702 118.8% 5,937,540 3,512,377 59.2% 3,822,844 Irrigation System Improvement 3,053,536 906,000 938,697 103.6% 2,986,700 1,818,686 60.9% 2,173,547 Total Capital Improvement Funds $ 24,577,853 $ 48,541,383 $ 23,510,606 48.4% $ 62,374,249 $ 22,1.63,686 35.5% $ 25,924,773 erp 4/6/19 AM Yr End 2009 report • IIII • VI City of Yakima Reserves and Other Funds 2009 Budget vs. Actual as of December 31, 2009 Actual Revenue Appropriations • Beginning % % Ending Employee Benefit Balance Amended Actual Re- Amended Actual Ex- " . Balance Reserves 1/1/2009 Budget Revenue ceived. Budget Expenditures vended 12/31/2009 Unemployment Compensation Reserve $ 396,498 $ 108,550 $ 117,392 108.1% $ 152,202 $ 127,950 84.1% $ 385,940 Employees Health Benefit Reserve - 3,096,084 9,315,000 9,600,778 103.1% 9,999,738 .9,922,099 99.2% 2,774,763 (1) Worker's Compensation Reserve 1,138,923 1,561,300 1,347,933 86.3% 1,694,397 1,317,593. 77.8% 1,169,263 (1) Wellness /EAP 152,996 120,000 100,000 83.3% 130,296 110,034 84.4% 142,962 Firemens' Relief and Pension 828,631 1,608,565 1,485,075 92.3% 1,619,380 1,567,783 96.8% 745,923 Total Employee Benefit Reserve Funds $ 5,613,132 $ 12,713,415 $12,651,178 99.5% $ 13,596,013 $ 13,045,459 96.0% $ 5,218,851 Operating Reserves Contingency $ 351,919 $ 50,000 $ 25,000 50.0% $ 300,000 $ 120,199 40.1% $ 256,720 Capitol Theatre Reserve 521,118 538,750 302,451 56.1% 571,927 • 371,927 65.0% 451,642 Risk Management Reserve 1,146,767 2,618,500 2,707,975 103.4% 2,939,598 2,845,143 96.8% 1,009,599 (1) Total Operating Reserve Funds $ 2,019,804 $ 3,207,250 $ 3,035,426 94.6% $. 3,811,525 $ 3,337,269 87.6% $ 1,717,961 Other Funds Cemetery Trust $ 566,365 $ 31,000 $ 24,208 78.1% $ 25,000 $ 12,060 48.2% $ 578,513 Pass. Through Grants $ - $ - $ - $ - $ $ - (1) These fund balances exclude an accrual for incurred but not reported claims. erp 4/6/2010 7:19 AM Yr End 2009 report.xls Table V1I City of Yakima Bond Redemption Funds 2009 Budget vs. Actual as of December 31, 2009 Actual Revenue Appropriations Beginning % % Ending General Obligation Bond Balance Amended Actual Re- Amended Actual Ex- Balance Redemption 1/1/2009 Budget Revenue ceived Budget Expenditures pended 12/31/2009 L.I.D. Guaranty $ 79,720 $ 300 $ 110 $ - $ - $ 79,830 2003 G.O. Police &Streets Ref 1994 263,649 364,100 364,000 100.0% 518,038 518,038 100.0% 109,611 2004 G.O. Street, Parks & Fire Ref 1995 194,251 268,000 265,672 99.1% 267,678 267,678 100.0% 192,245 1997 G.O. Line of Credit 0 50,000 0 0.0% 50,000 0 0.0% 0 2004 G.O. Convention Center Ref 1996 61,417 447,000 443,200 99.1% 441,365 441,365 100.0% 63,252 2007 G.O. Convention Center Ref 2002 151,407 460,000 734,137 159.6% 734,550 734,349 100.0% 151,195 Various General Obligation Bonds 4,663 980,289 984,189 100.4% 980,288 980,288 100.0% 8,564 L.1.D. Debt Service Control 32,144 213,000 119,077 55.9% 207,000 121,881 58.9% 29,340 Total General Obligation Bond Redemption Funds $ 787,251 $ 2,782,689 $ 2,910,385 104.6% $ 3,198,919 $ 3,063,599 95.8% $ 634,037 Water /Sewer Revenue Bond Redemption ' 2008 Water Revenue Bond Res ref 1998 $ 269,607 $ 400 $ 400 100.0 % $ - $ - $ 270,007 2008 Revenue Bond Reserve 144,663 700 700 100.0% 0 0 145,363 Water /Sewer Revenue Bonds 113,326 545,541 545,541 100.0% 545,141 545,140 100.0% 113,727 2008 Water Revenue Bonds Ref 1998 4,790 ' 234,585 234,585 100.0% 234,560 234,560 100.0% 4,815 2008 Water /Sewer Revenue Bond • (1) 412,213 412,213 • 100.0% 412,213 412,213 100.0% (1) 2003 Wastewater Bond Redemption 1 1,347,794 1,347,794 100.0% 1,347,794 1,347,794 100.0% _ l 2003 Irrigation Bond Redemption 35,435 320,709 320,709 100.0% 320,709 320,709 100.0% 35,435 Water /Sewer Revenue Bond Reserve 965,200 2,500 - 2,500 100.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,361,671 $ 2,864,442 $ 2,864,442 100.0% $ 2,860,417 $ 2,860,416 100.0% $ 2,365,697 erp 4/6/ • 19 AM Yr End 2009 report.xls II