The URL can be used to link to this page

Home My WebLink About05/21/2013 11 2013 1st Quarter Financial Trend Monitoring SystemBUSINESS OF THE CITY COUNCIL YAKIMA, WASHINGTON AGENDA STATEMENT Item No. I For Meeting of: 5/21/2013 ITEM TITLE: 1 st Quarter Financial Trend Monitoring System. SUBMITTED BY: Cindy Epperson, Director of Finance and Budget SUMMARY EXPLANATION: As part of the 2013 Strategic Plan, Finance is implementing the attached Financial Monitoring Report for the 1 st Quarter of 2013. The new format for the Financial Trend Monitoring System (FTMS) is intended to provide a more simple "performance at a glance" of budgetary and revenue trends. The FTMS compares key financial and economic indicators as an "early warning system" regarding the fianancial and economic health of the City, and assigns "positive ", "normal ", "warning ", and "negative" labels to revenues and expenditures. At the end of the first quarter, we are seeing typical variances tied to timing of annual dues /assessments and property tax receipts, along with the slowdown of some operational and construction activity in the winter months. Most categories received a "normal' ranking, as actual results are within 5% of expected levels at this point in time. There were no categories receiving a "warning" or "negative" designation. Overall, first quarter results are as anticipated. Resolution: Other (Specify): Report Contract: Start Date: Item Budgeted: Funding Source /Fiscal Impact: Strategic Priority: Insurance Required? No Mail to: Phone: APPROVED FOR Ordinance: Contract Term: End Date: Amount: Public Trust and Accountability City Manager SUBMITTAL: RECOMMENDATION: Accept Report ATTACHMENTS: Name- Description- L-1 FIN Report 1st Qrtr 5-13-13.pdf 1st quarter 2013 budget report MEMORANDUM May 14, 2013 TO: The Honorable Mayor and Members of the City Council FROM: Tony O'Rourke, City Manager Cindy Epperson, Director of Finance & Budget SUBJECT: 2013 1St Quarter Budget Revenue and Expenditure Report We are submitting for your review the City of Yakima's 20131St Quarter actual compared to budgeted Revenue and Expenditure Report for all city funds. Beginning fund balances shown are subject to final adjustments made as a result of the year -end closing process, which will not be officially concluded until the State Auditor's work is completed. We do not, at this time, expect that any adjustments will materially affect the balances represented in this report. It should be noted that the budget information for the Airport has not yet been incorporated into this report. We received a final close -out check from Yakima County the first of April in the amount of $725,133 -- $226,962 operating and $498,201 capital. Finance is preparing the first monthly report to be submitted on the June 4 agenda for activity through April. This report is summarized by type of fund, and incorporates a new Financial Monitoring System presentation. Information is reported by functional type, in the following order: ➢ Performance at a Glance - Financial Monitoring System ➢ City -Wide Overview ➢ General Fund Revenue Analysis ➢ General Fund Expenditure Analysis ➢ Other Funds Analysis ➢ Top 10 Capital Project ➢ Exhibits - Fund detail that supports the summaries: • Exhibit I - Other Operating /Enterprise Funds • Exhibit II - Capital Improvement Funds • Exhibit III - Reserve and Other Funds • Exhibit IV - Bond Redemption Funds PERFORMANCE AT A GLANCE General Fund Revenues Expenditures Operating /Enterprise Funds Capital Funds (1) Reserve, Trust & Agency Funds Bond Redemption Funds (1) Legend: Revenues exceed budget >5 %, Expenditures below budget >5% Revenues exceed budget <5 %, Expenditures below budget <5% Revenues below budget between 3 -5% Revenues below budget >5% (1) These funds are graded on a net Revenue measurement. STATUS NORMAL NORMAL NORMAL NORMAL NORMAL NORMAL PAGE 2 -4 2/5-6 7/9 7/10 7/11 7/12 POSITIVE NORMAL WARNING NEGATIVE FIN Report 1 st Qrtr 1 of 12 CITY WIDE OVERVIEW REVENUE COMPARISON (Budget vs. Actual) EXPENDITURE COMPARISON (Budget vs. Actual) -----2012 ____- _____. ._- ____- ________ -____ 2013 -____-________-____ - 1st Qtr Percent 1st Qtr Percent Actual Rec'd Budget Actual Rec'd General $11,580,077 23.1% $52,437,635 $12,328,884 23.5% Parks and Recreation 631,117 15.6% 4,083,765 623,421 15.3% Street & Traffic Operations 546,927 10.8% 5,411,260 663,139 12.3% General Government Subtotal 12,758,121 21.5% 61,932,660 13,615,444 22.0% Community Development 229,967 6.5% $2,538,741 158,003 6.2% Operating/Enterprise Funds 14,879,552 24.4% 63,275,950 14,170,766 22.4% Capital Funds 2,759,799 8.8% 46,921,514 3,256,665 6.9% G.O. Bond Redemption Funds 374,230 10.3% 3,812,383 985,700 25.9% Water /Sewer Redemption Funds 0 0.0% 2,129,686 160,752 7.5% Employee Benefit Reserves 2,951,410 21.1% 14,630,500 3,137,718 21.4% Operating Reserves 2,607,813 26.0% 3,586,500 2,828,011 78.9% Trust and Agency Funds 360,891 68.2% 528,200 530,208 100.4% Total $36,921,783 19.8% $199,356,134 $38,843,267 19.5% EXPENDITURE COMPARISON (Budget vs. Actual) FIN Report 1 st Qrtr 2 of 12 -----2012 - _ 2013 --- ____________________ -. 1st Qtr Percent 1st Qtr Percent Actual Spent Budget Actual Spent General $12,268,083 24.6% $52,613,086 $12,658,058 24.1% Parks and Recreation 833,790 21.8% 4,082,425 950,585 23.3% Street & Traffic Operations 1,589,937 32.0% 5,410,291 1,368,448 25.3% General Government Subtotal 14,691,810 24.9% 62,105,802 14,977,091 24.1% Community Development (HUD grants) 374,695 10.4% $2,564,724 310,536 12.1% Operating/Enterprise Funds 13,644,787 21.7% 63,424,573 13,979,948 22.0% Capital Funds 2,660,892 7.3% 54,429,142 3,774,033 6.9% G.O. Bond Redemption Funds 0 0.0% 3,831,384 1,859 0.0% Utility Revenue Bond Redemption Funds 100,277 3.8% 2,127,561 98,252 4.6% Employee Benefit Reserves 3,147,542 22.0% 14,634,979 2,628,601 18.0% Operating Reserves 741,199 7.3% 3,918,264 776,609 19.8% Trust and Agency Funds 17,985 3.6% 517,200 45,273 8.8% Total $35,379,187 18.0% $207,553,629 $36,592,202 17.6% FIN Report 1 st Qrtr 2 of 12 GENERAL FUND REVENUE ANALYSIS GENERAL GOVERNMENT REVENUES General Sales Tax Crim. Justice Sales Tax Property Tax Franchise & Utility Taxes Charges for Services State Shared Revenue Other Intergovernmental Fines and Forfeitures Other Taxes Transfers from other Funds Licenses and Permits Other Revenue Total Revenue Beginning Fund Balance Total Resources -- ---- -- Revenues through 3/31 -- ---- -- 2011 2012 2013 $3,147,821 $3,199,792 $3,495,744 637,595 674,684 703,084 953,711 1,140,813 1,470,742 3,154,706 3,758,791 3,763,192 1,514,577 1,289,448 1,293,536 651,335 665,408 599,923 374,168 117,277 436,082 435,497 433,295 447,577 663,102 649,932 696,818 225,120 341,548 271,115 154,925 186,465 159,543 68,337 123,483 92,903 11,980,894 12,580,936 13,430,259 5,954,903 9,948,220 6,868,086 17,935,797 22,529,156 20,298,345 2013 Amended Budget $13,375,000 2,747,000 15,329,000 14,530,000 5,195,480 2,611,000 1,334,605 1,555,000 1,396,500 1,370,000 731,700 573,650 60,748,935 9,944,261 70,693,196 Percent Receipted 26.1% 25.6% 9.6% 25.9% 24.9% 23.0% 32.7% 28.8% 49.9% 19.8% 21.8% 16.2% 22.1% 28.7% Status NORMAL NORMAL NORMAL NORMAL NORMAL NORMAL NORMAL NORMAL NORMAL NORMAL NORMAL NORMAL NORMAL NORMAL Property Tax - The first half of the Property Tax assessment is due to the Yakima County Treasurer by April 30, and the second half is due October 31. Therefore, the first quarter receipts are typically below 10% of the annual budget. The budget is set based on assumptions of new construction and collection rates —the 2013 actual levy was very close to the levy assumptions made, so this major revenue should meet or slightly exceed budget, depending on collection rate. Sales Tax - The first quarter continued the acceleration seen in the second half of 2012. Through the first quarter of 2013, sales tax is 9.2% more than the prior year, although this percentage is not expected to hold as we get to the second half of the year because last year's numbers well exceeded budgeted amounts. We are finally on track to exceed 2008 levels in 2013. Since the 2013 budget is slightly below 2012 actual results, this revenue should exceed budget by year end, however, it is too soon to estimate by how much. Other Taxes - This category consists primarily of Business Licenses and Gambling Taxes. Business licenses are due in January for the year, so that over 90% of this category has been collected by March 31. Therefore, the positive variance is a timing difference, and this is considered normal. The last three categories all contain timing exceptions, and are still expected to meet the budget. Overall, general government revenues are up by about $850,000 or 6.7% over 2012, and we anticipate year end to exceed the budget within the 5% range which maintains the "normal" ranking. FIN Report 1 st Qrtr 3 of 12 10,000,000 8,000,000 6,000,000 4,000,000 2,000,000 0 GENERAL FUND REVENUES - By Month C I -A-1 F- Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec GENERAL FUND REVENUES - Cumulative By Month 2011 2012 2013 Jan 4,204,721 3,668,912 4,451,264 Feb 3,875,777 4,206,186 4,267,636 Mar 4,078,448 4,861,758 4,896,583 Apr 9,178,647 9,388,842 May 4,565,077 4,833,268 Jun 3,929,664 4,146,240 Jul 3,536,362 4,636,431 Aug 3,405,624 3,574,114 Sep 4,354,881 4,250,150 Oct 8,531,924 9,673,506 Nov 3,925,532 4,263,220 Dec 4,035,837 4,016,944 57,622,494 61,519,571 13,615,483 C I -A-1 F- Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec GENERAL FUND REVENUES - Cumulative By Month Nov 53,586,657 57,502,627 Dec 57,622,494 61,519,571 ■ 2011 .2012 ■ 2013 60,000,000 — 40,000,000 — ■ 2011 20,000,000 1-1A — 2012 0 al ■ 2013 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec FIN Report 1 st Qrtr 4 of 12 2011 2012 2013 Jan 4,204,721 3,668,912 4,451,264 Feb 8,080,498 7,875,098 8,718,900 Mar 12,158,946 12,736,856 13,615,483 Apr 21,337,593 22,125,698 May 25,902,670 26,958,966 Jun 29,832,334 31,105,206 Jul 33,368,696 35,741,637 Aug 36,774,320 39,315,751 Sep 41,129,201 43,565,901 Oct 49,661,125 53,239,407 Nov 53,586,657 57,502,627 Dec 57,622,494 61,519,571 ■ 2011 .2012 ■ 2013 60,000,000 — 40,000,000 — ■ 2011 20,000,000 1-1A — 2012 0 al ■ 2013 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec FIN Report 1 st Qrtr 4 of 12 GENERAL FUND EXPENDITURE ANALYSIS Police Fire Transfers To Other Funds Information Systems Financial Services Municipal Court Code Administration Utility Services Police Pension Legal Indigent Defense Engineering Purchasing Records - City Clerk Planning Human Resources Economic Development City Hall Maintenance City Manager City Council Intergovernmental State Examiner Urban Area Hearings Exam Position Vacancy Savings Total General Fund GENERAL GOVERNMENT EXPENDITURES Expenditures through 3/31-- ---- -- 2011 2012 2013 $5,256,663 2,102,146 454,780 594,651 324,960 276,536 323,906 355,942 397,573 252,441 116,924 187,064 101,972 145,930 170,873 87,238 0 151,240 104,468 87,432 97,491 6,020 6,399 0 11,602,649 $5,634,443 2,158,155 568,007 619,058 369,678 284,892 293,578 385,834 353,961 255,999 125,184 166,094 111,990 286,695 137,852 112,607 0 153,016 58,554 92,142 92,955 543 6,846 0 12,268,083 $5,669,467 2,385,939 625,983 536,654 354,272 323,482 299,881 398,837 382,223 265,313 121,252 165,817 127,367 165,095 134,110 109,180 102,592 165,253 92,340 107,238 116,943 0 8,820 0 12,658,058 2013 852,063 833,790 Amended Percent 23.3% Budget Spent Status $25,309,932 22.4% NORMAL 9,865,187 24.2% NORMAL 2,502,275 25.0% NORMAL 2,264,038 23.7% NORMAL 1,478,418 24.0% NORMAL 1,384,004 23.4% NORMAL 1,338,032 22.4% NORMAL 1,324,950 30.1% NORMAL 1,297,225 29.5% NORMAL 1,287,573 20.6% NORMAL 833,500 14.5% POSIT E 686,172 24.2% NORMAL 541,244 23.5% NORMAL 491,070 33.6% NORMAL 460,502 29.1% NORMAL 459,969 23.7% NORMAL 367,217 27.9% NORMAL 372,923 44.3% NORMAL 366,555 25.2% NORMAL 284,751 37.7% NORMAL 291,549 40.1% NORMAL 110,000 0.0% NORMAL 26,000 33.9% NORMAL (730,000) 0.0% 52,613,086 24.1% NORMAL Parks & Recreation Fund 852,063 833,790 950,585 4,082,425 23.3% NORMAL Street & Traffic Ops. 1,330,357 1,589,937 1,368,448 5,410,291 25.3% NORMAL Total General Government $13,785,069 $14,691,810 $14,977,091 $62,105,802 24.1% NORMAL Total General Government Fund Expenditures -0.9% Below 25% NORMAL FIN Report 1 st Qrtr 5 of 12 SIGNIFICANT EXPENDITURE VARIANCES Positive Indigent Defense - The contract increase to comply with a new mandate was budgeted to begin in mid -year. The implementation date of the new rule has been moved back to 2015 — savings could extend through the end of the year. Normal- Over /under 25% in first quarter, yet comparable to prior years — payment timing variance • Utility Services - Annual maintenance of $115,000 for the utility billing system is paid in the first quarter. • Police Pension - Annual medicare premiums of $44,000 reimbursed to pensioners in the first quarter. • Records - Prior year election costs of $86,700 paid in the first quarter. • City Hall Maintenance - Annual transfer to Risk Management Fund to pay for property insurance is made in the first quarter - $107,000. • City Council - Annual Association of Washington Cities (AWC) dues of $62,000 paid in the first quarter. • Intergovernmental - Annual dues for Yakima County Emergency Management of $67,000 paid in the first quarter. • State Examiner - The annual audit does not get under way until the 2nd quarter of the year. Position Vacancy Savings - Shown for fund total purposes only - no "actual" will be charged here. FIN Report 1 st Qrtr 6 of 12 OTHER FUNDS ANALYSIS Operating/Enterprise Funds Capital Funds Reserve, Trust & Agency Funds Bond Redemption Funds Total Revenue Beginning Fund Balance Total Resources Operating/Enterprise Funds Capital Funds Reserve, Trust & Agency Funds Bond Redemption Funds Total Expenditures OTHER FUNDS REVENUES OTHER FUNDS EXPENDITURES Expenditure through 3/31 2011 2012 2013 2013 $14,019,482 $14,290,484 -- ---- -- Revenues through 3/31 -- ---- -- Amended Percent 3,906,726 2011 2012 2013 Budget Spent Status $12,683,554 $15,109,519 $14,328,769 $65,814,691 21.8% ORMAL 2,960,999 2,759,799 3,256,665 46,921,514 6.9% ORMAL 5,327,910 5,920,114 6,495,937 18,745,200 34.7% ORMAL 454,689 374,230 1,146,452 5,942,069 19.3% ORMAL 21,427,152 24,163,662 25,227,823 137,423,474 18.4% ORMAL 47,410,641 44,858,285 47,394,784 47,394,784 68,837,793 69,021,947 72,622,607 184,818,258 39.3% ORMAL OTHER FUNDS EXPENDITURES Expenditure through 3/31 2011 2012 2013 $13,508,980 $14,019,482 $14,290,484 3,502,332 2,660,892 3,774,033 4,343,524 3,906,726 3,450,483 102,117 100,277 100,111 21,456,`)53 2U,661,311 21,615,111 2013 Amended Percent Budget Spent Status $65,989,297 21.7% NORMAL 54,429,142 6.9% NORMAL 19,070,443 18.1% NORMAL 5,958,945 1.7% NORMAL 145,447,827 14.9% 1 NORMAL First quarter results are performing as expected. Most variances at this time of the year are related to timing, which is why they are getting a Normal status. Many Operating/Enterprise Funds have a seasonal component, and are not as active in the cold winter months (i.e. Refuse does not do yard waste, Water and Wastewater accelerate their programs during the good weather, etc.) Equipment Rental vehicle purchases are typically ordered, but not yet received. Capital Fund budgets include the full project, and are not expected to be 100% completed in the current year. Street projects require good weather for asphalt. A listing of the top ten budgeted projects and their first quarter expenses follow. Reserve Funds are ahead in revenue, because the full year of "premiums' to Risk Management are transferred in the 1St quarter. Expenses are down primarily because of a good quarter in the Medical Insurance Fund -last year included a major claim in this time frame. Revenues in Bond Redemption Funds are deposited /transferred ratably throughout the year, but the bulk of debt service payments are made in the last quarter. FIN Report 1 st Qrtr 7 of 12 TOP 10 CAPITAL PROJECTS pt. Legend: ST - Street Improvement WW - Wastewater Capital W - Water Capital FIN Report 1 st Qrtr 8 of 12 Total 2013 Actual 2013 Expected Project Number /Description Dept Budget Expended Funding Source Completion 1818 Railroad Grade Separation ST $12,409,500 $180,197 State & Federal Grants FY 2014 Martin Luther King Blvd Public Works Trust Fund Loan 2341 Regional Wastewater Treatment WW 6,510,000 1,622,773 Capital Reserves FY 2013/14 Plant UASB and Electrical Impr Revenue Bond (2014) 2353 City Streets Project Impr ST 5,000,000 4,994 General Obligation Bond FY 2013 2308 Biosolids Improvement WW 5,000,000 0 State Revolving Fund Loan FY 2014/15 2261 Automated Meter Reading W/WW 4,165,000 3,584 Public Works Trust Fund Loan FY 2013 2327 Ind Waste Line Boise Site WW 2,200,000 555,600 Public Works Trust Fund Loan FY 2013/14 2264 Speedway/Race Street (2nd Ph) WW 1,700,000 249,908 Wastewater Capital Reserves FY 2013/14 2259 Water Treatment Plant Lagoons W 1,500,000 33,777 Drinking Water State FY 2014 Revolving Fund Loan 2267 WW NPDES/TMDL Dschrg/Load WW 1,300,000 94,728 Wastewater Capital Reserves FY 2014/15 2314 River Road Improvement ST 1,204,421 41,000 State & Federal Grants FY 2013 pt. Legend: ST - Street Improvement WW - Wastewater Capital W - Water Capital FIN Report 1 st Qrtr 8 of 12 EXHIBITS OTHER OPERATING /ENTERPRISE FUNDS Exhibit I Fund Actual Beg Bal 1/1/2013 Amended Budget Revenue Actual Revenue % Rec'd Appropriations Amended Actual Budget Exp % Exp'd Ending Balance 12/31/2013 Economic Development $253,488 $229,000 $61,545 26.9% $277,332 $70,546 25.4% $244,487 Neighborhood Development 193,121 2,538,741 158,003 6.2% 2,564,724 310,536 12.1% 40,588 Community Relations 902,872 521,750 137,287 26.3% 922,855 109,948 11.9% 930,211 Cemetery 35,219 252,550 49,878 19.7% 267,327 65,319 24.4% 19,778 Emergency Services 106,982 1,195,026 120,079 10.0% 1,189,923 255,587 21.5% (28,526) Public Safety Communication 535,778 3,268,328 1,016,157 31.1% 3,505,154 702,391 20.0% 849,544 Police Grants 431,407 707,911 30,052 4.2% 644,878 180,075 27.9% 281,384 P.B.I.A. (Parking & Bus Impr) 83,656 205,340 58,632 28.6% 287,522 29,627 10.3% 112,661 Trolley 19,986 64,926 1,275 2.0% 77,246 451 0.6% 20,810 Front Street Bus Impr Area 8,750 3,535 450 12.7% 5,000 0 0.0% 9,200 Conv Center (Tourist Promo) 314,510 1,468,250 295,762 20.1% 1,460,299 359,921 24.6% 250,351 PFD- Convention Center 193,585 700,750 194,148 27.7% 684,000 170,142 24.9% 217,591 Tourism Promotion Area 414 667,000 114,522 17.2% 667,000 78,271 11.7% 36,665 Capitol Theatre 108,960 359,177 73,326 20.4% 348,300 123,455 35.4% 58,831 PFD- Capitol Theatre 53,337 528,500 146,876 27.8% 517,000 129,467 25.0% 70,746 Stormw ater Operating Fund 1,365,147 2,035,000 354,111 17.4% 2,087,622 338,188 16.2% 1,381,070 Transit 603,916 8,049,195 1,919,938 23.9% 8,042,761 2,148,263 26.7% 375,591 Refuse 533,131 5,473,500 1,253,407 22.9% 5,545,199 1,383,474 24.9% 403,064 Wastewater Operating 1,495,206 20,653,916 4,607,356 22.3% 19,525,178 4,137,956 21.2% 1,964,606 Water Operating 2,910,120 8,258,100 1,634,796 19.8% 8,546,883 1,896,446 22.2% 2,648,470 Irrigation 662,115 1,683,100 499,088 29.7% 1,509,163 626,015 41.5% 535,188 Equipment Rental 4,602,251 5,653,658 1,315,223 23.3% 5,978,336 876,309 14.7% 5,041,165 Environmental 438,798 150,000 0 0.0% 192,950 0 0.0% 438,798 Public Works Admin. 474,218 1,147,438 286,858 25.0% 1,142,645 298,097 26.1% 462,979 Total Other Operating Funds $16,326,967 $65,814,691 $14,328,769 21.8% $65,989,297 $14,290,484 21.7% $16,365,252 FIN Report 1 st Qrtr 9 of 12 Exhibit II CAPITAL IMPROVEMENT FUNDS Fund Actual Beg Bal 1/1/2013 Amended Budget Revenue Actual Revenue % Rec'd Appropriations Amended Actual Budget Exp % Exp'd Ending Balance 12/31/2013 Arterial Street $400,600 $8,870,322 $208,092 2.3% $8,935,977 $186,927 2.1% $421,765 Central Bus District Capital 335,424 0 4,480 n/a 229,500 6,191 2.7% 333,713 Capitol Theatre Construction 619 0 0 n/a 0 0 n/a 619 Yakima Redevelopment Area 671,283 2,850,000 0 0.0% 2,509,240 54,842 2.2% 616,441 Parks and Recreation Capital 156,544 75,000 73,791 n/a 100,000 71,655 71.7% 158,680 Fire Capital 470,817 800,750 21,875 2.7% 569,896 19,540 3.4% 473,152 Law and Justice Capital 272,377 359,886 100,104 27.8% 556,563 114,067 20.5% 258,414 Public Works Trust Constr 695,613 611,306 92,252 15.1% 845,282 115,795 13.7% 672,070 REET 2 Capital 437,954 527,000 92,252 17.5% 506,822 128,411 25.3% 401,795 Transit Capital Reserve 1,231,995 618,250 9,900 1.6% 545,500 18,231 3.3% 1,223,664 Stormwater Capital Fund 992,090 320,000 0 0.0% 435,000 33,799 7.8% 958,291 Convention Center Cap Impr 537,767 220,500 55,000 24.9% 295,000 20,768 7.0% 571,999 Reserve for Capital Impr 2,667,858 10,728,000 0 0.0% 12,537,058 203,000 1.6% 2,464,858 Wastewater Capital 8,692,828 15,132,000 2,244,400 14.8% 20,455,000 2,554,640 12.5% 8,382,588 Domestic Water Improvement 3,810,836 4,600,000 0 0.0% 4,875,000 54,150 1.1% 3,756,686 Irrigation System Impr 58,847 1,208,500 354,519 29.3% 1,033,304 192,017 18.6% 221,349 Total Capital Impr Funds $21,433,452 $46,921,514 $3,256,665 6.9% $54,429,142 $3,774,033 6.9% $20,916,084 FIN Report 1 st Qrtr 10 of 12 Exhibit III RESERVE AND OTHER FUNDS Fund Actual Beg Bal 1/1/2013 Amended Budget Revenue Actual Revenue % Rec'd Appropriations Amended Actual Budget Exp % Exp'd Ending Balance 12/31/2013 Employee Benefit Reserves Risk Management Reserve 1,030,191 3,586,000 2,828,011 78.9% 3,846,337 776,609 20.2% Unemployment Comp Res $358,948 $177,000 $44,026 24.9% $293,796 $9,642 3.3% $393,332 Employees Health Ben Res 2,471,682 11,995,000 2,669,991 22.3% 11,628,854 2,072,724 17.8% 3,068,949 Worker's Compensation Res 1,092,471 1,018,000 309,847 30.4% 1,244,636 168,350 13.5% 1,233,968 Wellness/EAP 126,438 60,000 0 0.0% 120,200 15,382 12.8% 111,056 Firemens' Relief and Pension 892,140 1,380,500 113,854 8.2% 1,347,493 362,503 26.9% 643,491 Total Employee Ben Reserve $4,941,679 $14,630,500 $3,137,718 21.4% $14,634,979 $2,628,601 18.0% $5,450,796 Operating Reserves Capitol Theatre Reserve 251,922 500 0 0.0% 71,927 0 0.0% 251,922 Risk Management Reserve 1,030,191 3,586,000 2,828,011 78.9% 3,846,337 776,609 20.2% 3,081,593 Total Operating Reserve $1,282,113 $3,586,500 $2,828,011 78.9% $3,918,264 $776,609 19.8% $3,333,515 Trust and Agency Funds Cemetery Trust $612,724 $16,500 $2,135 12.9% $5,500 $0 0.0% $614,859 Agency Fund - YAKCORPS 392,200 511,700 528,073 103.2% 511,700 45,273 8.8% 875,000 Total Other Funds $1,004,924 $528,200 $530,208 100.4% $517,200 $45,273 8.8% $1,489,859 FIN Report 1 st Qrtr 11 of 12 Exhibit IV BOND REDEMPTIONS FUNDS Fund Actual Beg Bal 1/1/2013 Amended Budget Revenue Actual Revenue % Rec'd Appropriations Amended Actual Budget Exp % Exp'd Ending Balance 12/31/2013 GO Bond Redemption LIDGuaranty $60,164 $50 $0 0.0% $0 $0 n/a $60,164 1994 GO LTD Police & Streets 96,934 512,000 99,999 19.5% 515,625 0 0.0% 196,933 1995 GO Street, Parks & Fire 189,345 293,000 27,340 9.3% 294,600 0 0.0% 216,685 1996 GO LTD- Conv Center 65,220 428,750 68,991 16.1% 428,315 0 0.0% 134,211 2002 GO Convention Center 168,506 1,017,594 227,675 22.4% 1,017,000 0 0.0% 396,181 2005 GO Parks and Rec Bond 14,739 1,286,989 493,495 38.3% 1,290,844 1,859 0.1% 506,375 LID Debt Service Control 54,154 274,000 68,200 24.9% 285,000 0 0.0% 122,354 Total G. 0. Bond Redemption $649,062 $3,812,383 $985,700 25.9% $3,831,384 $1,859 0.0% $1,632,903 Water /Sewer Revenue Bond Redemption 1997 Water Rev Bond Res $271,407 $400 $0 0.0% $0 $0 n/a $271,407 1996 Revenue Bond Reserve 147,763 700 0 0.0% 0 0 n/a 147,763 Water /Sewer Revenue Bonds 114,528 0 0 n/a 0 0 n/a 114,528 1997 Water Revenue Bonds 4,916 232,725 0 0.0% 232,700 0 0.0% 4,916 2008 Water /Sewer Rev Bond 1 414,813 0 0.0% 414,813 0 0.0% 1 2003 Wastewater Bond Red 965 1,158,544 0 0.0% 1,158,544 0 0.0% 965 2003 Irrigation Bond Red 35,436 321,504 160,752 50.0% 321,504 98,252 30.6% 97,936 Water /Sewer Rev Bond Res 972,700 1,000 0 0.0% 0 0 n/a 972,700 2003 Sewer Rev Bond Res 208,871 0 0 n/a 0 0 n/a 208,871 Total W/S Rev Bond Red $1,756,587 $2,129,686 $160,752 7.5% $2,127,561 $98,252 4.6% $1,819,087 FIN Report 1 st Qrtr 12 of 12