Loading...
HomeMy WebLinkAbout12/06/2016 10 2017 Revenue and Expenditure Budget - Second Public HearingBUSINESS OF THE CITY COUNCIL YAKIMA, WASHINGTON AGENDASTATEMENT Item No. 10. For Meeting of: December 6, 2016 ITEM TITLE: Second public hearing on the proposed 2017 Revenue and Expenditure Budget for the City of Yakima SUBMITTED BY: Cliff Moore, City Manager Cindy Epperson, Director of Finance & Budget SUMMARY EXPLANATION: The purpose of the second public hearing on the 2017 City of Yakima preliminary budget is to accept input, comments and/or questions from Council, citizens and other affected parties regarding the proposed 2017 Budget as updated to include direction given by Council during the budget process. The 2017 Preliminary Budget Summary is on the City's website home page - www.yakimawa.gov/services/finance/financial-reports/ Council reviewed the budget with staff on November 1, 3, 8, and 10. The first public hearing on the budget was held on November 15, 2016, along with the public hearing on the ad valorem (property) tax. Council then met on November 28 to formally vote on proposals that were not already included in the 2017 Preliminary budget. Finance has incorporated the changes approved by Council through November, along with several technical corrections. Additionally, there were required payroll adjustments, such as the change in the maximum amount subject to Social Security. At the November 28 study session, Council reviewed an interactive spreadsheet that calculated the change in General Government fund balance as Council gave direction. At the end of the meeting, the ending 2017 fund balance was estimated to be $6,513,765. After everything was entered into the payroll system, the ending balance as presented in today's material is slightly higher at $6,527,769, which represents a use of $415,212 from the beginning reserve balance of $6,942,980. In accordance with state law, Council is required to conduct two public hearings and adopt the budget prior to year end. The first public hearing was conducted on November 15, 2016, this is the second (December 6, 2016). Should Council make additional changes at the December 6, 2016 meeting, these will be incorporated into the final budget ordinance for Council approval on December 13, 2016. ITEM BUDGETED: NA STRATEGIC PRIORITY: Public Trust and Accountability APPROVED FOR SUBMITTAL: �"'�`~-City Manager cz*"00 STAFF RECOMMENDATION: Conduct the Public Hearing and accept public testimony. BOARD/COMMITTEE RECOMMENDATION: ATTACHMENTS: Description Upload Date Type D 2017 budget transmittal 12!212016 Co r Memo Memorandum Date: December 1, 2016 To: The Honorable Mayor and Members of City Council From: Cliff Moore, City Manager Cindy Epperson, Director of Finance and Budget Subject: 2017 Budget Wrap-up We are pleased to transmit the updated 2017 City of Yakima Budget for Council's and the Public's consideration at the final public hearing. The budget is balanced within available resources and is a prudent budget of $239.0 million. The overall 2017 budget represents a 15.3% increase over the projected 2016 year-end budget as well as an ending reserves of $50.9 million or 21.3% of budgeted expenditures and an increase in the operating property tax rate per $1,000 of assessed value of 0.8%. As is customary, any changes that are made to the Preliminary Budget previously presented to Council and the citizenry are summarized in this report, so that the final public hearing on the 2017 Budget includes the most updated changes. City Council met on November 28, 2016 and approved changes to the preliminary budget. These changes (along with some payroll housekeeping and other corrections) have been incorporated into this updated budget. Any changes made at the December 6 meeting will be incorporated into the Final Budget which will then be presented in ordinance form for adoption at the last business meeting of the year (December 13). In preparing the third quarter budget report (which is presented separately on this Council agenda), there were no changes warranted in the 2016 estimates in all but the Water fund, so for the most part, the beginning fund balance estimates are unchanged going into 2017. CITYWIDE BUDGET UPDATE The revised total City expenditure budget of $239.0 million represents a net increase of $3.7 million more than the 2017 Preliminary Budget of $235.3 million. The major increases include: ➢ Energy Conservation measure /switch to LED lighting $2,100,000 ➢ Fire Facilities remodel and major maintenance 307,850 ➢ Addition of three Firefighters (9 months) 209,250 ➢ Addition of one Fire Maintenance Mechanic (net of Temp salary) 74,800 ➢ Addition of one Airport Assistant Manager 102,400 ➢ Transportation Benefit District projects 451,500 ➢ The increase in state minimum wage in Parks operations 68,000 ➢ Additional costs associated with utility rate increases 458,000 ➢ General Government budget reductions (687,600) Page 1 of 11 The revised total City revenue budget of $219.8 million represents a net increase of $3.9 million more than the 2017 Preliminary Budget of $215.8 million. The major changes include: ➢ Borrowing and grants for the Street LED lighting project $2,100,000 ➢ Establishment of a Transportation Benefit District / vehicle tab fee 514,000 ➢ Lifting of electric, natural gas and telephone tax lid from $4,000 130,000 to $8,000 ➢ Addition of a Brokered Natural Gas utility tax 70,000 ➢ Change of Water, Wastewater, Stormwater and Refuse rates 784,250 The following chart summarizes the total City Budget, including the estimated beginning balance, revenues, expenditures and ending balance. CITY-WIDE BUDGET SUMMARY General Fund Parks and Recreation Street & Traffic Operations General Government Subtotal Utilities/Other Operating Capital Improvement Risk Management Reserves Employee Benefit Reserves Trust and Agency Funds G.O. Bond Debt Service Utility Revenue Bond Debt Service Total Estimated Estimated 2017 Beg. 2017 2017 Use of 2017 Ending Fund Balance Revenue Expenditures Reserves Balance $ 5,754,842 $ 65,087,882 $ 65,531,790 $ (443,908) $ 5,310,935 605,689 5,547,225 5,583,642 (36,417) 569,272 582,448 7,583,540 7,518,427 65,113 647,562 6,942,980 78,218,647 78,633,859 (415,212) 6,527,769 21,313,948 73,661,646 75,094,124 (1,432,478) 19,881,470 35,004,602 41,034,953 58,577,309 (17,542,357) 17,462,246 156,149 4,078,528 3,913,381 165,147 321,295 3,792,773 15,192,660 15,217,837 (25,177) 3,767,596 656,731 676,000 667,000 9,000 665,731 272,748 4,779,045 4,775,260 3,785 276,533 2,021,467 2,126,855 2,127,754 (899) 2,020,568 $ 70,161,400 $219,768,333 $239,006,524 $(19,238,191) $50,923,209 GENERAL GOVERNMENT BUDGET UPDATE Council approved changes to the Preliminary Budget at their November 28 meeting. The interactive spreadsheet that Finance used at the meeting indicated an ending General Government fund balance of $6,513,765. When all of the changes were entered into the budget/payroll system, the following is a summary of the differences: ➢ Revenue increased by $2,639,833, bringing that total from $75,578,814 to $78,218,647; ➢ Expenditures increased by $2,333,606 bringing the total from $76,300,253 to $78,633,859; ➢ Ending fund balance increase by $306,228 from $6,221,541 to $6,527,769. Page 2 of 11 The major increase in both revenue and expenditure was the approval of a street light upgrade to LED bulbs, estimated to cost about $2.1 million, to be funded by energy rebates, a grant and borrowing. Future energy savings are projected to be enough to make the debt service payments, so this is not adding cost, and will eventually result in cash flow savings when the debt is retired in about 10 years. Council accepted cost reduction proposals of about $687,591; added $812,500 from the unbudgeted expenditure proposals, and approved some fee and tax proposals. Even though the ending fund balance did experience a net increase from that originally presented in the Preliminary Budget document, the 2017 budget is still built to use $415,212 of its beginning reserve balance. Using reserves does stress the system and we will need to continue efforts to rebuild the fund balance to ensure adequate cash flow reserves and to preserve the City's bond rating. Revenue There were several additional revenue sources approved that pertain to the General Government: ➢ Establishment of a Transportation Benefit District / vehicle tab fee $112,500 ➢ Lift of electric, natural gas and telephone tax lid 130,000 ➢ Imposition of brokered natural gas utility tax 70,000 ➢ Borrowings and grants tied to the Street LED lighting upgrade 2,100,000 ➢ Increased Utility Taxes tied to internal rate increases 164,300 ➢ Correction to Yakima County charge for service for Purchasing 8,333 ➢ Allocation of Finance personnel to Utility Billing -additional transfer 54,700 Expenditures Major changes in expenditures in the General Government budget include: ➢ Energy Conservation measure /switch to LED lighting $2,100,000 ➢ Transfer to Fire Capital Fund for Fire Facility remodel 307,850 ➢ Addition of three Firefighters (9 months) 209,250 ➢ Addition of one Fire Maintenance Mechanic (net of Temp Sal.) 74,800 ➢ Human Resources and Finance Software 68,200 ➢ Transfer to Airport Operating Fund (to support Asst. Manager) 102,400 ➢ Budget Reductions (632,891) ➢ Statewide increase in Minimum Wage 68,000 ➢ Sidewalk Repair Program in Streets (tied to TBD revenue) 50,000 ➢ Miscellaneous corrections/payroll adjustments (14,003) Page 3 of 11 The following table details all of the changes made in the General Government Funds: GENERAL GOVERNMENT FUND CHANGES Revenue $ 2,100,000 Grant/Loan Energy conservation measure (LED lighting) $ 2,100,000 Increased Utility Tax due to rate increases 164,300 Elimination of electric, natural gas & telephone lid 130,000 Transportation Benefit District (TBD) / tab fee 112,500 Brokered Natural Gas utility tax 70,000 Allocation of Finance personnel to Utility Billing 54,700 Correction to Yakima County charge for purchasing 8,333 $ 2,639,833 Expenditures Energy conservation measure (LED lighting) $ 2,100,000 Transfer to Fire Capital for Fire facility remodel 307,850 Addition of 3 Firefighters 209,250 Transfer to Airport Operating 102,400 Addition of one Fire Maintenance Mechanic 74,800 Statewide increase in Minimum Wage 68,000 Sidewalk repair / installation & tree removal 50,000 NEOGov software 39,200 Workiva software 29,000 Budget Reductions (632,891) Miscellaneous corrections/payroll adjustments (14,003) Total Changes to General Government Expenditures $ 2,333,606 Net Change L_(3 General Government Summary The following table depicts a summary of all 2017 General Government budgets, including a revenue and expenditure projection, the difference (or the net effect on beginning cash reserves), the estimated beginning and ending reserve balances, and the percentage of the ending reserve in comparison to the operating budget. GENERAL GOVERNMENT BUDGET SUMMARY General Fund Parks & Recreation Street & Traffic Fund Total General Government 2017 2017 2017 Projected Proposed Estimated Revenue Expenditures Diff $65,087,882 $ 65,531,790 $ (443,908) 5,547,225 5,583,642 (36,417) 7,583,540 7,518,427 65,113 $78,218,647 $ 78,633,859 $(415,212) 2017 2017 2017 2017 Exp Estimated Estimated End Bal as % of Beginning Ending as % of Rev Balance Balance Exp 0.7% $ 5,754,842 $5,310,935 8.1% 0.7% 605,689 569,272 10.2% -0.9% 582,448 647,562 8.6% 0.0% $ 6,942,980 $ 6,527,769 8.3% Page 4 of 11 The 2017 General Government budget is virtually balanced, with the final net change using $415,212 of the beginning balance of $6,942,980, so that the 2017 projected ending fund balance is $6,527,769 which represents 8.3% of the 2017 budgeted expenditures. The recommended percentage of reserves compared to expenditures is 16.7%, which would require a balance of $13.1 million, or an additional $6.6 million. Management will continue to monitor operations and reserve levels. GENERAL GOVERNMENT BUDGET REDUCTIONS Departments were requested to make budget reductions after the Preliminary Budget was published ranging from 1.5% to 2.0%. The chart below shows these reductions and the final budget decisions from Council. 2017 GENERAL GOVERNMENT BUDGET REDUCTION DISPOSITION Svc Unit Personnel Changes Description Decrease IN P/O Reductions Yes No General Fund City Manager Temporary Salaries $ 2,850 - P $ 2,850 $ - Office & Operating Supplies 1,000 - O 1,000 Professional Services 8,000 - O 8,000 Data Communications 100 - O 100 Postage 100 - O 100 Transportation 1,400 - O 1,400 Dues & Subscriptions (1,000) - O (1,000) City Council Office & Operating Supplies 1,000 - O 1,000 Small Tools & Minor Equipment 250 - O 250 Professional Services 35,000 - O 35,000 Transportation 3,000 - O 3,000 City Clerk/Records Eliminate Overtime 5,500 - P 5,500 Office & Operating Supplies 3,400 - O 3,400 Info Technology Delay filling Tele Tech Analyst 30,000 V P 30,000 Prof Services - licenses 20,000 - O 20,000 Human Resources Prof Services - outside training 14,000 - O 14,000 Legal 2% Temporary Salaries 10,126 - P 10,126 Office & Operating Supplies 3,500 - O 3,500 Professional Services 1,300 - O 1,300 Postage 800 - O 800 Transportation 1,100 - O 1,100 Miscellaneous Expenses 2,148 - O 2,148 Dues & Subscriptions 7,500 - O 7,500 Repairs & Maintenance 2,500 - O 2,500 Municipal Court Delay hiring Judicial Specialist 35,200 V P 35,200 Finance Reallocate USR salaries 43,800 F P 43,800 Allocate AR time to Utilities 10,900 F P 10,900 Code Admin Delay hiring Code Comp Off 54,600 V P 54,600 Page 5 of 11 Svc Unit Personnel Changes Description Decrease F/V P/O Reductions Yes No Police Defund 2 task force positions 192,300 V P 192,300 Defund 1 Police Officer 96,150 V P 96,150 Lighting savings 15,250 - O 15,250 Reduce training budget 20,000 - O 20,000 Cancel Tower office lease 55,593 - O 55,593 Fire Uniforms 1,750 - O 1,750 Parks & Rec 2% DA -III Cemetery & PW Admin 32,500 V P 32,500 Reduce playground program 50,000 - O 50,000 Reduce summer concerts/movies 8,000 - O 8,000 Reduce ops at Franklin Pool 20,000 - O 20,000 Streets 2% Oper Supplies - street material 90,000 - O 90,000 Oper Supplies- sidewalk abatement 2,500 - O 2,500 Oper Supplies - weed abatement 5,000 - O 5,000 Oper Supplies - street lighting 7,500 - O 7,500 Prof Services - street maintenance 3,000 - O 3,000 Engineering Decreased Contract Specialist 9,900 F P 9,900 Delay hiring Design Engineer 38,700 - O 38,700 Copier/Plotter (18,000) - O (18,000) CH Facility 1.5% Temp Salaries 8,000 V P 8,000 Personnel Changes Total $ 936,217 $ 687,591 $ 248,626 FN = Filled / Vacant P/O = Personnel / Other OTHER FUND CHANGES Budget adjustments in non -General Government funds include: ➢ Rate increases for Wastewater, Stormwater, Water, and Refuse utilities, and related additional expenditures associated with rate increases (i.e. City in -lieu and State taxes, and additional transfers to capital funds where warranted). ➢ Double -budgeted items which required a transfer from General Fund: Major Maintenance for Fire facilities (paid out of the Fire Capital Fund) Assistant Airport Manager (paid out of the Airport Operating Fund) ➢ The portion of revenue and related expenditures from a Transportation Benefit District (TBD) that is allocated for street capital improvement. The TBD will go through the formal establishment stages in early 2017, but Council wanted the 2017 budget to reflect the estimate of first year receipts (it takes 6 months for the Department of Licensing to implement a new fee). The following chart details all of the changes from the Preliminary Budget to this Final Budget for all funds other than General Government. Page 6 of 11 OTHER FUNDS BUDGET SUMMARY Description Amount Revenue 401,500 Trans. Benefit District in Street Capital Fund $ 401,500 Transfer from General Fund to Fire Capital 307,850 Wastewater/Stormwater rates 305,250 Water rates 253,000 Refuse rates 226,000 Transfer from General Fund to Airport 102,400 Transfer from Stormwater ops to capital 100,000 Correct Wastewater Strong Waste overstatement 400,000) $ 1,296,000 Expenditures Additional Expenditures related to rate increases $ 458,000 Trans. Benefit District projects 401,500 Major Maintenance for Fire facilities (Fire Capital) 307,850 Airport Assistant Manager 102,400 Correction in Equip. Rental vehicle replacements 79,000 Miscellaneous Payroll adjustments (5,421) $ 1,343,329 Net Change $ 47,329 Following is a summary of the current status of the 2017 Final Budget. The updated 2017 Budget by City Functional Grouping table provides a 3 year expenditure detail by fund. Page 7 of 11 THREE-YEAR BUDGET COMPARISON - 2016 BUDGET BY CITY FUNCTIONAL GROUPING General Government City Management Indigent Defense City Council Neighborhood Groups Program City Clerk/Records Human Resources Legal Municipal Court Planning Code Administration City Hall Facility Economic Development Police Fire Information Technology Intergovernmental Transfers Finance State Examiner Police Pension Utility Services Purchasing Engineering Contingency Total General Fund Parks & Recreation Street & Traffic Operations Total General Government Funds 2015 ; 2016 2016 2017 2017 2017 2017 2017 2017 E Actual Amended Year -End Proposed vs 2015 Projected Use of Beginning Est. Ending E )enditures E Budget Estimate Expenditures Est Revenue Reserves Fund Balance Fund Balance $ 504,402E $ 418,138 $ 429,828 s $ 399,805 910,981 ; 935,500 940,500E 965,500 E 280,679E 285,340 271,415 = 252,176 - ; 206,735 - - 533,284 € 654,256 648,483 582,429 E 649,024E 653,258 638,353 724,580 1,467,922 ; E 1,651,505 1,566,632 1,703,161 1,346,861E 1,431,404 1,430,029 1,496,999 535,201 € 658,184 625,322 669,715 1,626,019 € 1,855,499 1,811,374 1,877,343 504,382E 505,447 495,696 521,591 784,085E E 889,964 798,264 743,507 26,452,368 E 27,462,308 27,202,038 ' 28,119,824 12,171,410 1 12,379,172 12,348,244 13,333,805 3,087,092E E 3,126,390 3,083,547 € 3,478,097 180,054E 189,551 189,551 ' 155,287 E 4,750,225E t 4,839,545 4,884,845: 5,352,664 1,532,581 E i 1,530,716 1,538,377 1 1,625,592 127,429 € 113,000 115,072 117,000 E 1,038,660 i E 1,104,060 953,661 ' 964,997 1,518,454 E 1,704,433 1,647,479 1 1,762,285 610,041 i E 630,092 625,273: 608,463 809,739 i i 833,710 728,578 ' 751,970 - (1,085,000) - (675,000) 61,420,893 62,973,206 62,972,563 65,531,790 5,554,286 ; 5,481,878 5,481,878 1 5,583,642 t 5,549,823 5,408,279 5,407,091 1 7,518,427 $ 72,525,002 $ 73,863,363 $ 73,861,531: $ 78,633,859 (7.0%) 2.7% (7.1%) n/a (10.2%) 13.5% 8.7% 4.7% 7.1% 3.6% 5.2% (6.9%) 3.4% 8.0% 12.8% (18.1%) 9.6% 5.7% 1.7% 1.2% 7.0% (2.7%) 3.2% n/a 4.1% $ 65,087,882 $ (443,908) $ 5,754,842 $ 5,310,935 1.9% 5,547,225 (36,417) 605,689 569,272 39.0% 7,583,540 65,113 582,448 647,562 6.5% $ 78,218,647 $ (415,212) $ 6,942,980 $ 6,527,769 Page 8 of 11 Other Operating/Enterprise Economic Development Community Development Community Relations Cemetery Emergency Services Public Safety Communications Police Grants Downtown Improvement District Trolley (Yakima Interurban Lines) Front St Business Impr Area Tourist Promotion (Conv Ctr) Capitol Theatre PFD Revenue -Convention Center Tourist Promotion Area PFD Revenue -Capitol Theatre Airport Operating Fund Stormwater Operating Transit Refuse Wastewater Operating Water Operating Irrigation Operating Equipment Rental Environmental Fund Public Works Administration Total Other Operating/Enterprise 2015 2016 2016 2017 2017 2017 2017 2017 2017 Actual ! Amended Year -End Preliminary vs 2015 Projected Use of Beginning Est. Ending )enditures € Budget Estimate Expenditures Est Revenue Reserves Fund Balance Fund Balance $ 248,183 ; $ 198,071 $ 193,745 $ 134,266 t 1,408,139 € E 31349,462 3,343,451 i 1,486,742 634,153E 618,913 578,572 644,764 281,178 € 274,712 273,212 280,957 E 1,305,260 ; 1,417,895 1,407,895: 1,417,413 4,059,802 = i 3,563,096 3,519,226 3,775,176 303,579 ; 401,716 368,457 1 384,078 E 199,062 € 208,993 198,500 1201,353 416,000 254,321 164,855 163,855 1 1,355 3,221 10,279 8,357: 3,500 1,610,885 € E 1,694,510 1,654,510 1,709,375 406,528E 420,497 420,497 1 434,878 738,730E 727,720 727,720 733,213 657,921E E 687,000 687,000 707,200 639,918 € 630,883 630,883 1 661,400 1,022,353 1,128,985 1,097,083 1,248,700 i 2,980,262 € 2,650,375 2,647,375 3,159,762 E 8,005,242 i E 8,368,765 8,091,493: 9,447,643 5,830,965 ; 6,459,053 6,394,856 6,914,474 21,889,068 ; 22,589,282 21,726,931 23,509,656 9,385,180 9,819,509 9,819,489 1 10,208,117 1,802,284E 1,829,496 1,828,709 1,737,460 4,749,623E 4,765,532 4,388,988 4,603,125 1,275,733 € 1,247,950 247,950 422,950 1,141,699E 1,256,978 1,249,153 1,266,566 $ 70,833,286 ; $ 74,484,527 $ 71,667,910: $ 75,094,124 (30.7%) $ 122,000 $ (12,266) $ 61,676 $ 49,410 (55.5%) 1,481,868 (4,874) 1,037,748 1,032,874 11.4% 678,100 33,336 756,939 790,275 2.8% 282,950 1,993 17,476 19,468 0.7% 1,365,890 (51,523) 120,857 69,334 7.3% 3,794,846 19,670 54,786 74,456 4.2% 416,000 31,922 451,312 483,234 1.4% 208,340 6,987 2,279 9,266 (99.2%) 1,275 (80) 757 677 (58.1%) 3,735 235 57 292 3.3% 1,710,250 875 517,551 518,426 3.4% 438,920 4,042 33,320 37,362 0.8% 850,750 117,537 615,616 733,153 2.9% 707,550 350 81,172 81,522 4.8% 660,500 (900) 183,728 182,828 13.8% 1,249,229 529 147,031 147,560 19.4% 3,057,650 (102,112) 321,868 219,756 16.8% 9,075,569 (372,074) 2,788,810 2,416,736 8.1% 7,131,094 216,620 329,347 545,967 8.2% 22,729,779 (779,877) 5,326,884 4,547,007 4.0% 9,703,000 (505,117) 2,463,391 1,958,275 (5.0%) 1,803,500 66,040 872,218 938,258 4.9% 4,636,942 33,817 4,092,769 4,126,586 70.6% 380,000 (42,950) 657,331 614,381 1.4% 1,171,908 (94,658) 379,027 284,369 4.8% $ 73,661,646 $ (1,432,478) $ 21,313,948 $ 19,881,470 Page 9 of 11 Capital Improvement Arterial Street C.B.D. Capital Improvement Capitol Theatre Construction Yakima Rev Development Area Parks & Recreation Capital Fire Capital Law & Justice Capital Public Works Trust Construction REET 2 Capital Construction Street Capital Fund Convention Center Capital Impr Cum. Reserve for Capital Impr Airport Capital Stormwater Capital Transit Capital Reserve Wastewater Facilities Capital Rsv Wastewater Construction Water Capital Wastewater Capital Irrigation Capital Total Capital Improvement 2015 2016 2016 2017 2017 2017 2017 2017 2017 Actual ! Amended Year -End Preliminary vs 2015 Projected Use of Beginning Est. Ending )enditures € Budget Estimate Expenditures Est Revenue Reserves Fund Balance Fund Balance $ 1,822,375 ; $ 10,737,025 $ 4,009,634 $ 4,867,075 21.4% $ 4,665,039 $ (202,036) $ 573,466 $ 371,430 t 566,050 € E 2,881,000 768,570 1 10,888,560 1316.7% 9,915,280 (973,280) 1,737,892 764,612 17,649E 242,351 70,000 60,000 (14.3%) 60,000 - 245,391 245,391 3,092,240 € 11500,000 1,177,000 2,168,686 84.3% 1,000,000 (1,168,686) 1,424,125 255,439 2,575,977E 3,344,049 3,342,406 ' 2,031,000 (39.2%) 1,126,817 (904,183) 1,240,543 336,360 1,220,178 1 i 2,239,976 787,328 2,648,617 236.4% 2,641,350 (7,267) 34,097 26,830 434,337 ; 693,000 693,000 1 693,000 0.0% 501,150 (191,850) 547,718 355,868 E 642,784 € 1,011,385 951,833 11,655,114 73.9% 836,448 (818,666) 1,206,091 387,425 1,177,547E 978,250 977,372 1 782,452 (19.9%) 752,000 (30,452) 277,589 247,137 934,473 5,000,000 167: 401,500 n/a 525,659 124,159 189,303 313,462 326,762 € E 385,000 385,000 385,000 0.0% 370,500 (14,500) 583,975 569,475 1,263,603E 1,580,000 1,490,249 - (100.0%) - - 428,298 428,298 547,128E 13,805,247 13,803,913: 2,815,089 (79.6%) 2,856,150 41,061 48,065 89,126 158,484 € E 2,400,000 700,000 i 3,900,000 457.1% 1,060,000 (2,840,000) 3,044,907 204,907 54,217 € 4,334,205 2,274,420 = 2,009,675 (11.6%) 2,656,000 646,325 4,700,848 5,347,173 83,709E 700,000 700,000 800,000 14.3% 700,000 (100,000) 1,968,809 1,868,809 81,809E 5,710,000 960,000 1 8,910,000 828.1% 2,900,000 (6,010,000) 6,114,767 104,767 E 467,972 ; E 2,257,738 506,000: 1,444,000 185.4% 750,000 (694,000) 4,555,143 3,861,143 320,669 ; 1,380,000 - 3,750,000 n/a 501,500 (3,248,500) 4,033,623 785,123 939,442 ; 11367,542 840,284 8,367,542 895.8% 7,217,060 (1,150,482) 2,049,953 899,471 $ 16,727,406 E $ 62,546,768 $ 34,437,176 1$ 58,577,309 70.1% $ 41,034,953 $(17,542,357) $ 35,004,602 $ 17,462,246 Contingency/Operating Reserves FRS/Capitol Theatre Reserve $ 71,927 f $ 36,641 $ 36,641 $ - (100.0%) $ - $ - $ - $ - Risk Management 4,684,994E 5,664,864 5,471,094 3,913,381 (28.5%) 4,078,528 165,147 156,149 321,295 Total Contingency/Operating Rsys $ 4,756,921E $ 5,701,505 $ 5,507,735: $ 3,913,381 (28.9%) $ 4,078,528 $ 165,147 $ 156,149 $ 321,295 Page 10 of 11 Employee Benefit Reserves Unemployment Compensation Employees Health Benefit Workers' Compensation Wellness/EAP Fund Firemen's Relief & Pension Total Employee Benefit Reserves Trust and Agency Funds Cemetery Trust YakCorps Agency Fund Total Trust and Agency Funds Debt Service L.I.D. Guaranty PFD Debt Service General Obligation Bonds L.I.D. Debt Service Water-Irrigation/Sewer Bonds Total Debt Service Total City Budget 2015 € i 2016 - $ - $ 2016 2017 2017 2017 1,029,213 - 2017 2017 2017 Actual Amended 81,814 Year -End Preliminary vs 2015 Projected - - Use of Beginning Est. Ending Expenditures E Budget 2,021,467 Estimate Expenditures Est Revenue 6,905,899 $ 2,886 $ Reserves Fund Balance Fund Balance E E $ 196,662 ! $ E 227,351 $ 192,644 $ 227,353 18.0% $ 205,000 $ (22,353) $ 453,600 $ 431,247 10,394,450E 11,588,338 11,584,028 12,308,313 6.3% 12,450,000 141,687 1,403,627 1,545,314 1,244,078 1,311,017 1,144,884 1,290,919 12.8% 1,104,500 (186,419) 738,787 552,368 95,530 € 121,800 111,300 101,800 (8.5%) 100,000 (1,800) 127,348 125,548 E 1,220,413E 1,349,628 1,183,583 1,289,452 8.9% 1,333,160 43,708 1,069,410 1,113,118 $ 13,151,134E $ 14,598,134 $ 14,216,438 $ 15,217,837 7.0% $ 15,192,660 $ (25,177) $ 3,792,773 $ 3,767,596 E E $ 12,000 $ E 12,000 $ 12,000: $ 12,000 0.0% $ 21,000 $ 9,000 $ 656,731 $ 665,731 - = i 655,777 643,060 655,000 1.9% 655,000 - - - $ 12,000 $ 667,777 $ 655,060 1 $ 667,000 1.8% $ 676,000 $ 9,000 $ 656,731 $ 665,731 E 1,026,050E 1,024,025 1,024,025 3,438,378 3,736,939 3,736,939 15 € 48,000 - 2,132,154 E 2,129,054 2,129,054 $ 6,596,597 ; $ 6,938,018 $ 6,890,018 E $184,602,345 E $ 238,800,092 $ 207,235,868 $ - n/a $ - $ - $ 25,329 $ 25,329 1,029,213 0.5% 1,029,213 - 165,605 165,605 3,746,047 0.2% 3,749,832 3,785 81,814 85,599 - n/a - - - - 2,127,754 (0.1%) 2,126,855 (899) 2,021,467 2,020,568 $ 6,903,013 0.2% $ 6,905,899 $ 2,886 $ 2,294,216 $ 2,297,101 $239,006,524 15.3% $219,768,333 $(19,238,191) $ 70,161,400 $ 50,923,209 Page 11 of 11