Loading...
HomeMy WebLinkAbout6720 (2) ORDINANCE NO. 6720 AN ORDINANCE OF THE CITY COUNCIL OF THE CITY OF AUBURN, WASHINGTON, AMENDING ORDINANCE NO. 6693, THE 2019-2020 BIENNIAL OPERATING BUDGET ORDINANCE, AS AMENDED BY ORDINANCE NO. 6712, AUTHORIZING AMENDMENT TO THE CITY OF AUBURN 2019-2020 BUDGET AS SET FORTH IN SCHEDULE "A" AND SCHEDULE "B" WHEREAS, the Auburn City Council at its regular meeting of December 3, 2018, adopted Ordinance No. 6693 which adopted the City of Auburn 2019-2020 Biennial budget; and WHEREAS, the Auburn City Council at its regular meeting of April 1, 2019, adopted Ordinance No. 6712 (BA#1) which amended Ordinance No. 6693 which adopted the City of Auburn 2019-2020 Biennial budget; and WHEREAS, the Auburn City Council at its regular meeting of May 20, 2019, adopted Ordinance No. 6719 (BA#2) which amended Ordinance No. 6712 which amended the City of Auburn 2019-2020 Biennial budget; and WHEREAS, the City of Auburn deems it necessary to appropriate additional funds to the various funds of the 2019 budget as outlined in this Ordinance (BA#3); and WHEREAS, this Ordinance has been approved by one more than the majority of all councilpersons in accordance with RCW 35A.34.200. NOW THEREFORE, THE CITY COUNCIL OF THE CITY OF AUBURN, WASHINGTON DO ORDAIN AS FOLLOWS: Ordinance No. 6720 June 18, 2019 Page 1 of 3 Section 1. Amendment of the 2019-2020 Biennial Budget. The 2019- 2020 Biennial Budget of the City of Auburn is amended pursuant to Chapter 35A.34 RCW, to reflect the revenues and expenditures as shown on Schedule "A" attached hereto and incorporated herein by reference. The Mayor of the City of Auburn, Washington is hereby authorized to utilize revenue and expenditure amounts shown on said Schedule "A" and Schedule "B". A copy of said Schedule "A" and Schedule "B" is on file with the City Clerk and available for public inspection. Section 2. Implementation. The Mayor is authorized to implement those administrative procedures necessary to carry out the directives of this legislation. Section 3. Severability. The provisions of this ordinance are declared to be separate and severable. The invalidity of any clause, sentence, paragraph, subdivision, section, or portion of this ordinance, or the invalidity of the application of it to any person or circumstance, will not affect the validity of the remainder of this ordinance, or the validity of its application to other persons or circumstances. Section 4. Effective date. This Ordinance will take effect and be in force five days from and after its passage, approval, and publication as provided by law. INTRODUCED: JUL 1 5 20T9 PASSED: JUL 1 5 2019 JUL 15 20T9 APPROVED: CICY4k CKUS, M OR Ordinance No. 6720 June 18, 2019 Page 2 of 3 ATTEST: APPRO `• Q t TO FORM: 4‘111 .\ Shawn Campbell, MMC, City Clerk Ste - . ross, City Attorney Ordinance No. 6720 June 18, 2019 Page 3 of 3 CITY of -.* am * Interoffice Memorandum WASHINGTON To: City Council From: Shelley Coleman, Finance Director CC: Nancy Backus, Mayor Date: June 19, 2019 Re: Ordinance#6720—2019-2020 Budget Amendment#3 Budget Amendment#3 is the third amendment of the City of Auburn's 2019-2020 biennial budget. The main purpose of this budget amendment is to adjust budgeted 2019 beginning fund balances to match actual 2018 ending fund balances per accounting records. Additional items included in this amendment are recognition of new revenue,either grants or transfers in from other supporting funds, requests for additional budget authority for projects and removal of discontinued programs. To identify requested changes to each fund, please refer to the accompanying Schedule A,Summary of 2019 Budget Adjustments by Fund. This budget amendment has been revised to reflect updated working capital balance adjustments for enterprise and internal service funds. Fund Balance Adjustments: This amendment adjusts City-wide 2019 budgeted beginning fund balances to reflect actual ending balances as of the end of 2018. City-wide beginning fund balances are adjusted by a net increase of$10.4 million. Revenue Adjustments: This amendment recognizes new grants and updated revenue projections, including: • Federal grant for Auburn Way South widening project(cp1622) $ 1,297,500 • Increase in projected property tax revenues 275,000 • Increase MIT casino emergency service revenues 370,000 • Interlocal grant funding for a third school resource officer(from ASD) 60,000 • WSDOE grant to complete the City's shoreline master plan 15,400 • WA Assoc. of Sheriffs&Police Chiefs grant for a speed feedback sign 3,500 • Geocaching Event grant(from Fund 104) 1,100 TOTAL $ 2,022,500 AUBURN MORE THAN YOU IMAGINED Funding Adjustments: Funding adjustment requests included in this budget amendment increase or decrease spending authority for existing programs. Significant funding adjustment requests include: • Funding to replace lead service lines: Due to the availability of a low-interest loan from the Drinking Water State Revolving Fund (DWSRF), the City can accelerate its plan to replace lead service lines and associated water mains. The authorized loan amount is $3,000,000. The availability of these funds also means a planned $100,000 State grant and $50,000 in Water capital fund balance will not be utilized for this project. • Budget for DWSRF loan: In 2018,the City was awarded a DWSRF loan for$1,340,000 for the Coal Creek Springs transmission replacement project. During design, it was determined that the current approach was infeasible, and the loan was converted to pre-construction costs only in the amount of$300,000. The change also affects$347,000 in interfund loans and $1,030,200 in Water capital fund balance that are no longer needed. • LEOFF1 benefits(General Fund): This amendment reduces the 2019 budget for LEOFF1 benefits by$628,300 to better reflect historical actual expenditure levels. The adjustment results in a higher General Fund ending fund balance. • Salaries and Benefits for Second School Resource Officer(General Fund): This amendment provides budget of$114,300 in 2019 for salaries and benefits associated with the school resource officer that was added in 2018 in Budget Amendment#6 (Ordinance No. 6684). The offsetting revenue from the Auburn School District is already incorporated into the 2019 budget. • Budget for repairs to traffic signals caused by vehicular accidents: The City typically pays for these repairs and is then reimbursed by insurance companies. This budget amendment request, in the amount of$100,000, is offset by additional revenues. • Budget for East Auburn access project. Through an agreement, the Muckleshoot Indian Tribe (MIT)will reimburse the City's cost of$100,000 to provide technical guidance and support to MIT for this project, which is funded by WSDOT and led by MIT. The additional budget requested includes$20,000 in consultant support costs and$80,000 in City labor and benefit costs. • Revised estimates for aviation fuel sales at the Auburn Airport: This amendment would update the preliminary estimates made during budget development for expenditures and revenues associated with the sale of aviation fuel (AVGas), increasing both revenues and expenditures by$80,000. • Funding for sidewalks on Auburn Way South: This requested budget amendment would provide$75,000 in additional budget for the project that is needed to cover the cost of additional design and construction elements being required by WSDOT and anticipated increases due to a regional increase in construction bids. New Requests: Significant new funding requests include: • 2020 Arterial Street Preservation project(Fund 105) $ 699,400 • Replace two message boards(Fund 560) 72,000 • Add third School Resource Officer(70%funded by ASD) 67,200 • Purchase a man-lift and trailer(Fund 560) 22,000 TOTAL $896,600 AUBURN MORE THAN YOU IMAGINED The following table summarizes the current and revised budget as a result of this amendment. Table 1: 2019 Budget as Amended 2019 Budget as Amended(through BA#2) $333,333,982 Budget Amendment#3(Ord#6720) 18,829,533 Budget as Amended $352,163,515 Attachments: ❖ 1. Proposed Ordinance#6720(Budget Amendment#3) ❖ 2. Summary of proposed 2019 budget adjustments by fund and department(Schedule A) ❖ 3. Summary of proposed changes to adopted 2019 budget by fund(Schedule B) AUBURN * MORE THAN YOU IMAGINED Schedule A Summary of 2019 Budget Adjustments by Fund Budget Amendment#3(Ordinance#6720) Beg.Fund 2019 2019 Ending Fund Balance Revenues Expenditures Balance General Fund (#001) 2019 Adopted Budget 18,037,042 72,145,986 77,788,165 12,394,863 Previous Budget Amendments 539,000 (27,700) 538,400 (27,100) 2019 Amended Budget 18,576,042 72,118,286 78,326,565 12,367,763 BA#3(Ordinance#6720,Proposed): 3,074,234 941,000 1,147,900 2,867,334 General Fund Revenues: Increase budgeted property tax receipts to match long-term financial forecast - 275,000 - 275,000 Increase budgeted revenue from MIT for casino emergency services - 370,000 - 370,000 Community Development Department: WSDOE grant to complete the City's shoreline master plan - 15,400 15,400 - Budget for Crime Prevention Through Environ.Design training(w/revenue offset) - 8,800 8,800 - Police Department: Continue funding for the second SRO(from 2018 BA#6;revenue already budgeted) - - 114,300 (114,300) Budget for a third School Resource Officer 70%funded by ASD(no new FTEs) - 67,200 14,200 53,000 New grant from WA Assoc.of Sheriffs&Police Chiefs for a speed feedback sign - 3,500 3,500 - Public Works Department: Incr.budget to cover repairs to traffic signals damaged by vehicular accidents - 100,000 100,000 - Add budget for East Auburn Access Project,to be funded by MIT - 100,000 20,000 80,000 Administration Department: LTAC Board-approved grant to the City of Auburn for 2019 Geocaching Event - 1,100 - 1,100 Non-Departmental: Reduce estimated LEOFFI benefit expenditures to better reflect historical actuals - - (628,300) 628,300 Adjust beginning fund balance/eliminate contra account(underexpenditures) 3,074,234 - 1,500,000 1,574,234 Revised 2019 Budget-Fund 001 21,650,276 73,059,286 79,474,465 15,235,097 Page 1 of 14 6/14/2019 3:28 PM Schedule A Summary of 2019 Budget Adjustments by Fund Budget Amendment#3(Ordinance#6720) Beg.Fund 2019 2019 Ending Fund Balance Revenues Expenditures Balance Arterial Street Fund (#102) 2019 Adopted Budget 1,492,777 1,633,100 1,781,400 1,344,477 Previous Budget Amendments and CIP Carry-Forwards 611,413 1,383,641 2,070,054 (75,000) 2019 Amended Budget 2,104,190 3,016,741 3,851,454 1,269,477 BA#3(Ordinance#6720,Proposed): (41,819) 1,526,400 1,575,000 (90,419) Adjust beginning fund balance (41,819) - - (41,819) Incr funding for sidewalks on AWS(cp1705)due to WSDOT recl'ts and cost incr - - 75,000 (75,000) Funding for AWS widening proj.(cp1622;funded by grant and traffic impact fees) - 1,500,000 1,500,000 - Correct contractor payment from 2018(entered in F460 should have been F102) - 26,400 - 26,400 Revised 2019 Budget-Fund 102 2,062,371 4,543,141 5,426,454 1,179,058 Local Street Fund (#103) 2019 Adopted Budget 1,650,780 1,912,000 2,605,900 956,880 Previous Budget Amendments and CIP Carry-Forwards 899,476 - 899,476 - 2019 Amended Budget 2,550,256 1,912,000 3,505,376 956,880 BA#3(Ordinance#6720,Proposed): 249,701 - - 249,701 Adjust beginning fund balance 249,701 - - 249,701 Revised 2019 Budget-Fund 103 2,799,957 1,912,000 3,505,376 1,206,581 Hotel/Motel Tax Fund (#104) 2019 Adopted Budget 108,571 153,600 160,050 102,121 Previous Budget Amendments 6,650 - 41,650 (35,000) 2019 Amended Budget 115,221 153,600 201,700 67,121 BA#3(Ordinance#6720,Proposed): 82,454 - - 82,454 Adjust beginning fund balance 82,454 - - 82,454 LTAC Board-approved grant to the City of Auburn for 2019 Geocaching Event - - - - 104.00.557.300.41 PROFESSIONAL SERVICES (1,100) 104.00.597.300.55 OPERATING TRANSFERS OUT 1,100 Revised 2019 Budget-Fund 104 197,675 153,600 201,700 149,575 Page 2 of 14 6/14/2019 3:28 PM Schedule A Summary of 2019 Budget Adjustments by Fund Budget Amendment#3(Ordinance#6720) Beg.Fund 2019 2019 Ending Fund Balance Revenues Expenditures Balance Arterial Street Preservation Fund (#105) 2019 Adopted Budget 1,582,337 2,959,320 3,172,240 1,369,417 Previous Budget Amendments and CIP Carry-Forwards 998,143 793,170 1,791,313 - 2019 Amended Budget 2,580,480 3,752,490 4,963,553 1,369,417 BA#3(Ordinance#6720,Proposed): (536,021) 699,400 699,400 (536,021) Adjust beginning fund balance (536,021) - - (536,021) Transfer reserved REET funds for arterial street preservation projects(cp1926) - 699,400 699,400 - Revised 2019 Budget-Fund 105 2,044,459 4,451,890 5,662,953 833,396 Drug Forfeiture Fund (#117) 2019 Adopted Budget 376,497 155,000 298,037 233,460 Previous Budget Amendments - - - - 2019 Amended Budget 376,497 155,000 298,037 233,460 BA#3(Ordinance#6720,Proposed): 80,697 - 9,400 71,297 Adjust beginning fund balance 80,697 - - 80,697 Increase salaries and benefits in the Drug Forfeiture Fund to reflect Police CBA - - 9,400 (9,400) Revised 2019 Budget-Fund 117 457,194 155,000 307,437 304,757 Housing & Comm Develop Fund (#119) 2019 Adopted Budget 36,458 590,000 590,000 36,458 Previous Budget Amendments - 269,900 269,900 - 2019 Amended Budget 36,458 859,900 859,900 36,458 BA#3(Ordinance#6720,Proposed): 6,446 - - 6,446 Adjust beginning fund balance 6,446 - - 6,446 Revised 2019 Budget-Fund 119 42,904 859,900 859,900 42,904 Page 3 of 14 6/14/2019 3:28 PM Schedule A Summary of 2019 Budget Adjustments by Fund Budget Amendment#3(Ordinance#6720) Beg.Fund 2019 2019 Ending Fund Balance Revenues Expenditures Balance Recreation Trails Fund (#120) 2019 Adopted Budget 64,326 7,100 - 71,426 Previous Budget Amendments - - - - 2019 Amended Budget 64,326 7,100 - 71,426 BA#3(Ordinance#6720,Proposed): 1,550 - - 1,550 Adjust beginning fund balance 13550 - - 1,550 Revised 2019 Budget-Fund 120 65,876 7,100 - 72,976 BIA Fund (#121) 2019 Adopted Budget 109,473 55,200 90,000 74,673 Previous Budget Amendments 5,400 - 5,400 - 2019 Amended Budget 114,873 55,200 95,400 74,673 BA#3(Ordinance#67203 Proposed): 940 - - 940 Adjust beginning fund balance 940 - - 940 Revised 2019 Budget-Fund 121 115,813 55,200 95,400 75,613 Cumulative Reserve Fund (#122) 2019 Adopted Budget 10,124,312 180,200 142,200 10,162,312 Previous Budget Amendments and CIP Carry-Forwards - - - - 2019 Amended Budget 10,124,312 180,200 142,200 10,162,312 BA#3(Ordinance#67203 Proposed): 333754 - - 33,754 Adjust beginning fund balance 33,754 - - 33,754 Revised 2019 Budget-Fund 122 10,158,066 180,200 142,200 10,196,066 Page 4 of 14 6/14/2019 3:28 PM Schedule A Summary of 2019 Budget Adjustments by Fund Budget Amendment#3(Ordinance#6720) Beg.Fund 2019 2019 Ending Fund Balance Revenues Expenditures Balance Mitigation Fees Fund (#124) 2019 Adopted Budget 10,886,137 1,196,200 2,980,350 9,101,987 Previous Budget Amendments and CIP Carry-Forwards 962,356 416,200 1,228,556 150,000 2019 Amended Budget 11,848,493 1,612,400 4,208,906 9,251,987 BA#3(Ordinance#6720!Proposed): 33,289 - 252,500 (219,211) Adjust beginning fund balance 33,289 - - 33,289 Funding for AWS widening prof.(cp1622;funded by grant and traffic impact fees) - - 202,500 (202,500) Increase budget for Brannan Park synthetic infield project(cp1817) - - 50,000 (50,000) Revised 2019 Budget-Fund 124 11,881,782 1,612,400 4,461,406 9,032,776 Local Revitalization 2010 C&D Bond Fund (#231) 2019 Adopted Budget 11,396 590,300 589,800 11,896 Previous Budget Amendments - - - - 2019 Amended Budget 11,396 590,300 589,800 11,896 BA#3(Ordinance#6720,Proposed): 3,436 - - 3,436 Adjust beginning fund balance 3,436 - - 3,436 Revised 2019 Budget-Fund 231 14,832 590,300 589,800 15,332 LID Guarantee Fund (#249) 2019 Adopted Budget 1,618 30 - 1,648 Previous Budget Amendments - - - - 2019 Amended Budget 1,618 30 - 1,648 BA#3(Ordinance#6720,Proposed): 15 - - 15 Adjust beginning fund balance 15 - - 15 Revised 2019 Budget-Fund 249 1,633 30 - 1,663 Page 5 of 14 6/14/2019 3:28 I'M Schedule A Summary of 2019 Budget Adjustments by Fund Budget Amendment#3(Ordinance#6720) Beg.Fund 2019 2019 Ending Fund Balance Revenues Expenditures Balance LID 350 Fund (#275) 2019 Adopted Budget 8,709 7,350 7,400 8,659 Previous Budget Amendments - - - - 2019 Amended Budget 8,709 7,350 7,400 8,659 BA#3(Ordinance#6720,Proposed): (4,956) - - (4,956) Adjust beginning fund balance (4,956) - - (4,956) Revised 2019 Budget-Fund 275 3,753 7,350 7,400 3,703 Golf/Cemetery 2016 Refunding Fund (#276) 2019 Adopted Budget - 374,100 374,100 - Previous Budget Amendments - - - - 2019 Amended Budget - 374,100 374,100 - BA#3(Ordinance#6720,Proposed): 19 - - 19 Adjust beginning fund balance 19 - - 19 Revised 2019 Budget-Fund 276 19 374,100 374,100 19 Parks Construction Fund (#321) 2019 Adopted Budget 310,222 2,070,550 2,015,000 365,772 Previous Budget Amendments and CIP Carry-Forwards 184,924 1,100,085 1,285,009 - 2019 Amended Budget 495,146 3,170,635 3,300,009 365,772 BA#3(Ordinance#6720,Proposed): 120,757 50,000 50,000 120,757 Adjust beginning fund balance 120,757 - - 120,757 Increase budget for Brannan Park synthetic infield project(cp1817) - 50,000 50,000 - Revised 2019 Budget-Fund 321 615,903 3,220,635 3,350,009 486,529 Page 6 of 14 6/14/2019 3:28 PM Schedule A Summary of 2019 Budget Adjustments by Fund Budget Amendment#3(Ordinance#6720) Beg.Fund 2019 2019 Ending Fund Balance Revenues Expenditures Balance Capital Improvements Fund (#328) 2019 Adopted Budget 10,404,627 5,775,300 8,500,550 7,679,377 Previous Budget Amendments and CIP Carry-Forwards 1,709,627 839,333 2,698,960 (150,000) 2019 Amended Budget 12,114,254 6,614,633 11,199,510 7,529,377 BA#3(Ordinance#6720,Proposed): 1,211,410 75,000 774,400 512,010 Adjust beginning fund balance 1,211,410 - - 1,211,410 Incr funding for sidewalks on AWS(cp1705)due to WSDOT req'ts and cost incr - 75,000 75,000 - Transfer reserved REET funds for arterial street preservation projects(cp1926) - - 699,400 (699,400) Revised 2019 Budget-Fund 328 13,325,664 6,689,633 11,973,910 8,041,387 Local Revitalization Fund (#330) 2019 Adopted Budget 380,500 104,000 484,500 - Previous Budget Amendments and CIP Carry-Forwards 6,000 - 6,000 - 2019 Amended Budget 386,500 104,000 490,500 - BA#3(Ordinance#6720,Proposed): (4,512) - (4,512) - Adjust beginning fund balance (4,512) - (4,512) - Revised 2019 Budget-Fund 330 381,988 104,000 485,988 - Water Fund (#430) 2019 Adopted Budget 3,787,175 15,678,500 14,334,065 5,131,610 Previous Budget Amendments and CIP Carry-Forwards 128,200 - 128,200 - 2019 Amended Budget 3,915,375 15,678,500 14,462,265 5,131,610 BA#3(Ordinance#6720,Proposed): 4,052,091 3,135,100 2,323,700 4,863,491 Adjust beginning fund balance 4,052,091 - - 4,052,091 Adjust budget for Drinking Water Revolving Fund loan to pre-construction only - 135,100 (676,300) 811,400 Incr funding to replace lead service lines due to new DWSRF loan(cp1922) - 3,000,000 3,000,000 - Revised 2019 Budget-Fund 430 7,967,466 18,813,600 16,785,965 9,995,101 Page 7 of 14 6/14/2019 3:28 PM Schedule A Summary of 2019 Budget Adjustments by Fund Budget Amendment#3(Ordinance#6720) Beg.Fund 2019 2019 Ending Fund Balance Revenues Expenditures Balance Sewer Fund (#431) 2019 Adopted Budget 4,267,149 9,104,200 7,842,663 5,528,686 Previous Budget Amendments and CIP Carry-Forwards 25,100 - 25,100 - 2019 Amended Budget 4,292,249 9,104,200 7,867,763 5,528,686 BA#3(Ordinance#6720,Proposed): 1,085,922 - - 1,085,922 Adjust beginning fund balance 1,085,922 - - 1,085,922 Revised 2019 Budget-Fund 431 5,378,171 9,104,200 7,867,763 6,614,608 Storm Drainage Fund (#432) 2019 Adopted Budget 2,859,814 10,156,900 8,865,312 4,151,402 Previous Budget Amendments and CIP Carry-Forwards 26,800 - 26,800 - 2019 Amended Budget 2,886,614 10,156,900 8,892,112 4,151,402 BA#3(Ordinance#6720,Proposed): 2,080,595 - - 2,080,595 Adjust beginning fund balance 2,080,595 - - 2,080,595 Revised 2019 Budget-Fund 432 4,967,209 10,156,900 8,892,112 6,231,997 Sewer Metro Sub Fund (#433) 2019 Adopted Budget 3,184,467 18,372,500 18,215,600 3,341,367 Previous Budget Amendments - - - - 2019 Amended Budget 3,184,467 18,372,500 18,215,600 3,341,367 BA#3(Ordinance#6720,Proposed): 383,462 - - 383,462 Adjust beginning fund balance 383,462 - - 383,462 Revised 2019 Budget-Fund 433 3,567,929 18,372,500 18,215,600 3,724,829 Page 8 of 14 6/14/2019 3:28 PM Schedule A Summary of 2019 Budget Adjustments by Fund Budget Amendment#3(Ordinance#6720) Beg.Fund 2019 2019 Ending Fund Balance Revenues Expenditures Balance Solid Waste Fund (#434) 2019 Adopted Budget 5,556,175 16,249,100 16,296,306 5,508,969 Previous Budget Amendments - - - - 2019 Amended Budget 5,556,175 16,249,100 16,296,306 5,508,969 BA#3(Ordinance#6720,Proposed): 126,864 - - 126,864 Adjust beginning fund balance 126,864 - - 126,864 Revised 2019 Budget-Fund 434 5,683,039 16,249,100 16,296,306 5,635,833 Airport Fund (#435) 2019 Adopted Budget 434,633 1,218,600 1,353,493 299,740 Previous Budget Amendments 40,000 - 53,200 (13,200) 2019 Amended Budget 474,633 1,218,600 1,406,693 286,540 BA#3(Ordinance#67207 Proposed): 116,285 80,000 80,000 116,285 Adjust beginning fund balance 116,285 - - 116,285 Revise budgeted revenues and expenditures for aviation fuel sales - 80,000 80,000 - Revised 2019 Budget-Fund 435 590,918 1,298,600 1,486,693 402,825 Cemetery Fund (#436) 2019 Adopted Budget 441,060 1,187,000 1,363,962 264,098 Previous Budget Amendments - - - _ 2019 Amended Budget 441,060 1,187,000 1,363,962 264,098 BA#3(Ordinance#6720,Proposed): 309,598 - - 309,598 Adjust beginning fund balance 309,598 - - 309,598 Revised 2019 Budget-Fund 436 750,658 1,187,000 1,363,962 573,696 Page 9 of 14 6/14/2019 3:28 PM Schedule A Summary of 2019 Budget Adjustments by Fund Budget Amendment#3(Ordinance#6720) Beg.Fund 2019 2019 Ending Fund Balance Revenues Expenditures Balance Water Capital Fund (#460) 2019 Adopted Budget 138,010 9,037,400 6,612,686 2,562,724 Previous Budget Amendments and CIP Carry-Forwards 2,710,441 697,616 3,928,057 (520,000) 2019 Amended Budget 2,848,451 9,735,016 10,540,743 2,042,724 BA#3(Ordinance#6720,Proposed): (879,957) 1,876,700 796,500 200,243 Adjust beginning fund balance (879,957) - - (879,957) Adjust budget for Drinking Water Revolving Fund loan to pre-construction only - (1,023,300) (2,053,500) 1,030,200 Correct contractor payment from 2018(entered in F460 should have been F102) - - - - 460.00.590.100.65 CONSTRUCTION PROJECTS (26,400) 460.00.597.100.55 OPERATING TRANSFER OUT 26,400 Incr funding to replace lead service lines due to new DWSRF loan(cp1922) - 2,900,000 2,850,000 50,000 Revised 2019 Budget-Fund 460 1,968,494 11,611,716 11,337,243 2,242,967 Sewer Capital Fund (#461) 2019 Adopted Budget 11,210,691 734,700 2,895,900 9,049,491 Previous Budget Amendments and CIP Carry-Forwards 1,029,608 - 1,029,608 - 2019 Amended Budget 12,240,299 734,700 3,925,508 9,049,491 BA#3(Ordinance#6720,Proposed): 146,047 - - 146,047 Adjust beginning fund balance 146,047 - - 146,047 Revised 2019 Budget-Fund 461 12,386,346 734,700 3,925,508 9,195,538 Storm Drainage Capital Fund (#462) 2019 Adopted Budget 13,328,488 569,900 3,196,900 10,701,488 Previous Budget Amendments 464,293 181,965 646,258 - 2019 Amended Budget 13,792,781 751,865 3,843,158 10,701,488 BA#3(Ordinance#6720,Proposed): (1,496,283) - - (1,496,283) Adjust beginning fund balance (1,496,283) - - (1,496,283) Revised 2019 Budget-Fund 462 12,296,498 751,865 3,843,158 9,205,205 Page 10 of 14 6/14/2019 3:28 PM Schedule A Summary of 2019 Budget Adjustments by Fund Budget Amendment#3(Ordinance#6720) Beg.Fund 2019 2019 Ending Fund Balance Revenues _ Expenditures Balance Airport Capital Fund (#465) 2019 Adopted Budget 146,405 2,093,700 2,140,500 99,605 Previous Budget Amendments and CIP Carry-Forwards 100,562 730,346 867,108 (36,200) 2019 Amended Budget 246,967 2,824,046 3,007,608 63,405 BA#3(Ordinance#6720,Proposed): (35,086) - - (35,086) Adjust beginning fund balance (35,086) - - (35,086) Revised 2019 Budget-Fund 465 211,881 2,824,046 3,007,608 28,319 Cemetery Capital Fund (#466) 2019 Adopted Budget 261,037 133,000 358,100 35,937 Previous Budget Amendments and CIP Carry-Forwards - 22,442 22,442 - 2019 Amended Budget 261,037 155,442 380,542 35,937 BA#3(Ordinance#6720,Proposed): (7,685) - - (7,685) Adjust beginning fund balance (7,685) - - (7,685) Revised 2019 Budget-Fund 466 253,352 155,442 380,542 28,252 Insurance Fund (#501) 2019 Adopted Budget 1,928,070 21,000 180,600 1,768,470 Previous Budget Amendments - - - - 2019 Amended Budget 1,928,070 21,000 180,600 1,768,470 BA#3(Ordinance#6720,Proposed): 4,456 - - 4,456 Adjust beginning fund balance 4,456 - - 4,456 Revised 2019 Budget-Fund 501 1,932,526 21,000 180,600 1,772,926 Page 11 of 14 6/14/2019 3:28 PM Schedule A Summary of 2019 Budget Adjustments by Fund Budget Amendment#3(Ordinance#6720) Beg.Fund 2019 2019 Ending Fund Balance Revenues Expenditures Balance Workers' Comp Fund (#503) 2019 Adopted Budget 2,128,988 1,171,200 818,115 2,482,073 Previous Budget Amendments - - - - 2019 Amended Budget 2,128,988 1,171,200 818,115 2,482,073 BA#3(Ordinance#6720,Proposed): (956,046) - - (956,046) Adjust beginning fund balance (956,046) - - (956,046) Revised 2019 Budget-Fund 503 1,172,942 1,171,200 818,115 1,526,027 Facilities Fund (#505) 2019 Adopted Budget 1,412,874 3,532,500 3,894,563 1,050,811 Previous Budget Amendments 136,000 (31,400) 288,000 (183,400) 2019 Amended Budget 1,548,874 3,501,100 4,182,563 867,411 BA#3(Ordinance#6720,Proposed): 285,123 - - 285,123 Adjust beginning fund balance 285,123 - - 285,123 Revised 2019 Budget-Fund 505 1,833,997 3,501,100 4,182,563 1,152,534 Innovation &Technology Fund (#518) 2019 Adopted Budget 2,573,504 6,429,110 6,437,640 2,564,974 Previous Budget Amendments 124,500 118,200 242,700 - 2019 Amended Budget 2,698,004 6,547,310 6,680,340 2,564,974 BA#3(Ordinance#6720,Proposed): 96,070 - - 96,070 Adjust beginning fund balance 96,070 - - 96,070 Revised 2019 Budget-Fund 518 2,794,074 6,547,310 6,680,340 2,661,044 Page 12 of 14 6/14/2019 3:28 PM Schedule A Summary of 2019 Budget Adjustments by Fund Budget Amendment#3(Ordinance#6720) Beg.Fund 2019 2019 Ending Fund Balance Revenues Expenditures Balance Equipment Rental Fund (#550) 2019 Adopted Budget 3,091,626 2,007,606 2,746,591 2,352,641 Previous Budget Amendments - - 104,600 (104,600) 2019 Amended Budget 3,091,626 2,007,606 2,851,191 2,248,041 BA#3(Ordinance#6720,Proposed): 331,225 - - 331,225 Adjust beginning fund balance 331,225 - - 331,225 Revised 2019 Budget-Fund 550 3,422,851 2,007,606 2,851,191 2,579,266 Equipment Rental Capital Fund (#560) 2019 Adopted Budget 3,663,110 2,741,994 3,102,450 3,302,654 Previous Budget Amendments and CIP Carry-Forwards 46,400 75,200 371,500 (249,900) 2019 Amended Budget 3,709,510 2,817,194 3,473,950 3,052,754 BA#3(Ordinance#6720,Proposed): 60,622 62,000 156,000 (33,378) Replace two message board units that are past their useful lives(fully.paid in) - - 72,000 (72,000) Vehicle for third School Resource Officer(incl.$60k in funding from ASD) - 62,000 62,000 - Adjust beginning fund balance 60,622 - - 60,622 Purchase man-lift and trailer for Facilities Dept(funding in 2019 adopted budget) - - 22,000 (22,000) Revised 2019 Budget-Fund 560 3,770,132 2,879,194 3,629,950 3,019,376 IT Capital Fund (#568) 2019 Adopted Budget 1,169,997 - 869,300 300,697 Previous Budget Amendments and CIP Carry-Forwards - 22,500 22,500 - 2019 Amended Budget 1,169,997 22,500 891,800 300,697 BA#3(Ordinance#6720,Proposed): 356,536 12,200 12,200 356,536 Adjust beginning fund balance 356,536 - - 356,536 Vehicle electronics for third School Resource Officer - 12,200 12,200 - Revised 2019 Budget-Fund 568 1,526,533 34,700 904,000 657,233 Page 13 of 14 6/14/2019 3:28 PM Schedule A Summary of 2019 Budget Adjustments by Fund Budget Amendment#3(Ordinance#6720) Beg.Fund 2019 2019 Ending Fund Balance Revenues Expenditures Balance Fire Pension Fund (#611) 2019 Adopted Budget 2,205,369 120,900 215,120 2,111,149 Previous Budget Amendments - - - - 2019 Amended Budget 2,205,369 120,900 215,120 2,111,149 BA#3(Ordinance#6720,Proposed): 27,922 - 5,000 22,922 Increase budget for actuarial services - - 5,000 (5,000) Adjust beginning fund balance 27,922 - - 27,922 Revised 2019 Budget-Fund 611 2,233,291 120,900 220,120 2,134,071 Cemetery Endowment Fund (#701) 2019 Adopted Budget 1,817,409 45,000 33,000 1,829,409 Previous Budget Amendments and CIP Carry-Forwards 22,442 - 22,442 - 2019 Amended Budget 1,839,851 45,000 55,442 1,829,409 BA#3(Ordinance#6720,Proposed): 56,978 - - 56,978 Adjust beginning fund balance 56,978 - - 56,978 Revised 2019 Budget-Fund 701 1,896,829 45,000 55,442 1,886,387 Grand Total - All Funds 2019 Adopted Budget 121,191,833 194,308,846 207,147,258 108,353,421 Previous Budget Amendments 10,777,335 6,591,498 18,613,233 (1,244,400) 2019 Amended Budget 131,969,168 200,900,344 225,760,491 107,109,021 TOTAL BA#3(Ordinance#6720,Proposed) 10,456,133 8,457,800 7,877,488 11,036,445 Revised 2019 Budget 142,425,301 209,358,144 233,637,979 118,145,466 351,783,445 351,783,445 Page 14 of 14 6/14/2019 3:28 PM Schedule B 2019 Appropriations by Fund 2019 Adopted BA#1 BA#2 BA#3 Total Revised Fund Budget (Ord#6712) CIP CFs (Ord#6719) (Ord#6720) Amendments Budget General Fund(#001) 90,183,028 511,300 - 141,910 4,015,234 4,668,444 94,851,472 Arterial Street Fund(#102) 3,125,877 - 1,995,054 - 1,484,581 3,479,635 6,605,512 Local Street Fund(#103) 3,562,780 - 899,476 - 249,701 1,149,177 4,711,957 Hotel/Motel Tax Fund(#104) 262,171 6,650 - - 82,454 89,104 351,275 Arterial Street Preservation Fund(#105) 4,541,657 - 1,791,313 ' - 1.63,379 1,954,692 6,496,349 Drug Forfeiture Fund(#117) 531,497 - - - 80,697 80,697 612,194 Housing&Comm Develop Fund(#119) 626,458 269,900 - - 6,446 276,346 902,804 Recreation Trails Fund(#120) 71,426 - - - 1,550 1,550 72,976 BIA Fund(#121) 164,673 5,400 - - 940 6,340 171,013 Cumulative Reserve Fund(#122) 10,304,512 - 84,400 - 33,754 118,154 10,422,666 Mitigation Fees Fund(#124) 12,082,337 150,000 1,228,556 - 33,289 1,411,845 13,494,182 1998 GO Library Bond Fund(#229) - - - - - - - City Hall Annex 2010 A&B Bond Fund(#230) 1,664,900 - - - - - 1,664,900 Local Revitalization 2010 C&D Bond Fund(#231) 601,696 - - - 3,436 3,436 605,132 SCORE Debt Service Fund(#238) 2,129,800 - - - - - 2,129,800 LID Guarantee Fund(#249) 1,648 - - - 15 15 1,663 LID 350 Fund(#275) 16,059 - - - (4,956) (4,956) 11,103 Golf/Cemetery 2016 Refunding Fund(#276) 374,100 - - - 19 19 374,119 Parks Construction Fund(#321) 2,380,772 - 1,285,009 - 170,757 1,455,766 3,836,538 Capital Improvements Fund(#328) 16,179,927 54,000 2,494,960 _ - 1,286,410 3,835,370 20,015,297 Local Revitalization Fund(#330) 484,500 - 6,000 - (4,512) 1,488 485,988 Water Fund(#430) 19,465,675 115,200 13,000 - 7,187,191 7,315,391 26,781,066 Sewer Fund(#431) 13,371,349 12,100 13,000 - 1,085,922 1,111,022 14,482,371 Storm Drainage Fund(#432) 13,016,714 13,800 13,000 - 2,080,595 2,107,395 15,124,109 Sewer Metro Sub Fund(#433) 21,556,967 - - - 383,462 383,462 21,940,429 Solid Waste Fund(#434) 21,805,275 - - - 126,864 126,864 21,932,139 Airport Fund(#435) 1,653,233 40,000 - - 196,285 236,285 1,889,518 Cemetery Fund(#436) 1,628,060 - - - 309,598 309,598 1,937,658 Water Capital Fund(#460) 9,175,410 - 3,408,057 - 996,743 4,404,800 13,580,210 Sewer Capital Fund(#461) 11,945,391 - 1,029,608 - 146,047 1,175,655 13,121,046 Storm Drainage Capital Fund(#462) 13,898,388 - 646,258 - (1,496,283) (850,025) 13,048,363 Airport Capital Fund(#465) 2,240,105 - 830,908 - (35,086) 795,822 3,035,927 Cemetery Capital Fund(#466) 394,037 - 22,442 - (7,685) 14,757 408,794 Insurance Fund(#501) 1,949,070 - - - 4,456 4,456 1,953,526 Workers'Comp Fund(#503) 3,300,188 - - - (956,046) (956,046) 2,344,142 Facilities Fund(#505) 4,945,374 104,600 - _ 4,500 285,123 394,223 5,339,597 Innovation&Technology Fund(#518) 9,002,614 242,700 - 13,500 96,070 352,270 9,354,884 Equipment Rental Fund(#550) 5,099,232 - - - 331,225 331,225 5,430,457 Equipment Rental Capital Fund(#560) 6,405,104 82,600 39,000 - 122,622 244,222 6,649,326 IT Capital Fund(#568) 1,169,997 22,500 - - 368,736 391,236 1,561,233 Fire Pension Fund(#611) 2,326,269 - - - 27,922 27,922 2,354,191 SKHHP Fund(#654) - - - 220,160 - 220,160 220,160 Cemetery Endowment Fund(#701) 1,862,409 - 22,442 - 56,978 79,420 1,941,829 Total 315,500,679 1,630,750 15,822,483 380,070 18,913,933 36,747,236 352,247,915