Loading...
HomeMy WebLinkAbout6850 ORDINANCE NO. 6850 AN ORDINANCE OF THE CITY COUNCIL OF THE CITY OF AUBURN, WASHINGTON, AMENDING ORDINANCE NO. 6794, THE 2021-2022 BIENNIAL OPERATING BUDGET ORDINANCE, AND ORDINANCE NO. 6796, THE 2021-2022 BIENNIAL CAPITAL BUDGET ORDINANCE, AS AMENDED BY ORDINANCE NO. 6815, ORDINANCE NO. 6827, ORDINANCE NO. 6836, AND ORDINANCE NO. 6837, AUTHORIZING AMENDMENT TO THE CITY OF AUBURN 2021-2022 BUDGET AS SET FORTH IN SCHEDULE "A" AND SCHEDULE "B" WHEREAS, the Auburn City Council at its regular meeting of November 16, 2020, adopted Ordinances Nos. 6794 and 6796 which adopted the City of Auburn 2021-2022 biennial operating and capital budgets; and WHEREAS, the Auburn City Council at its regular meeting of April 5, 2021, adopted Ordinance No. 6815 (BA#1) which amended Ordinances Nos. 6794 and 6796 which adopted the City of Auburn 2021-2022 Biennial budget; and WHEREAS, the Auburn City Council at its regular meeting of August 2, 2021 , adopted Ordinance No. 6827 (BA#2) which amended Ordinance No. 6815 which amended the City of Auburn 2021-2022 Biennial budget; and WHEREAS, the Auburn City Council at its regular meeting of November 1, 2021, adopted Ordinances Nos. 6836 (BA#3) and 6837 (BA#4), both of which amended Ordinance No. 6827 which amended the City of Auburn 2021-2022 Biennial budget; and WHEREAS, the City of Auburn deems it necessary to appropriate additional funds to the various funds of the 2022 budget as outlined in this Ordinance (BA#5); and Ordinance No. 6850 March 9, 2022 Page 1 of 3 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: Section 1. Amendment of the 2021-2022 Biennial Budget. The 2021- 2022 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. 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 3. Implementation. The Mayor is authorized to implement those administrative procedures necessary to carry out the directives of this legislation. Ordinance No. 6850 March 9, 2022 Page 2 of 3 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: MAR 2 1 2022 PASSED: MAR 2 1 2022 APPROVED: MAR 2 1 2022 ANCY KUS, MAOR ATTEST: APPROVED AS TO FORM: Shawn Campbell, MMC, City Clerk Kendra Comeau, City Attorney PUBLISHED: MOkOn 201.1, In -(le ettAAttT�eAQ�( Ordinance No. 6850 March 9, 2022 Page 3 of 3 Schedule A Summary of 2022 Budget Adjustments by Fund Budget Amendment#5(Ordinance#6850) Beg.Fund Ending Fund r2 eq Balance Revenues Expenditures Balance OT/OG _No General Fund (#001) 2022 Adopted Budget 10,524,785 81,938,250 85,605,016 6,858,019 Previous Budget Amendments 6,891,448 (106,600) 2,778,300 4,006,548 2022 Amended Budget 17,416,233 81,831,650 88,383,316 10,864,567 BA#5(Ordinance#6850,Proposed): 667,070 2,708,000 4,804,370 (1,429,300) Mayor's Office: Diversity,Equity&Inclusion Carry Forward 46,600 - 46,600 - OT 001-01 Carry-Forward of Sally Port Project at City Hall 39,600 - 39,600 - OT 001-02 Inclusive Auburn Initiative-Diversity,Equity&Inclusion Program - - 124,500 (124,500) OT 001-03 Human Resources: DEI Data Dashboard(ARPA-Funded) - 50,000 50,000 - OT 001-04 Temporary Internship Position in HR - - 20,000 (20,000) 001-05 HR Lobby Build-Out Budget Carry Forward 25,000 - 25,000 - 001-06 Vaccination Incentive Program Carry-Forward(ARPA Funded) - 15,000 15,000 - 001-07 Finance Department: Convert Sr.Accounting Specialist LTE to Sr.Accountant FTE(no cost in 2022) - - - - OG 001-08 City Attorneys Office: Emergency Housing Voucher Program(ARPA-Funded) - 250,000 250,000 - OG 001-09 Auburn Resource Center&Homeless Outreach Funding - - 36,700 (36,700) OT 001-10 Property Management Budget Increase - - 25,000 (25,000) OT 001-11 Carry Forward Budget for Server Room Retrofit and Furniture 45,000 - 45,000 - OT 001-12 ACRC-Design&Engineering Carry-Forward and New Request 88,800 - 118,800 (30,000) OT 001-13 Community Development: Transit-Oriented Development Implementation Grant - 250,000 250,000 - OT 001-14 Comprehensive Plan Framework and Element Updates - - 250,000 (250,000) OT 001-15 ARPA Funding for Mitigated Negative Economic Impacts - 500,000 500,000 - OT 001-16 Façade Improvement Grant Program 20,600 - 20,600 - OT 001-17 Human Services Budget Carry Forward 27,000 - 27,000 - OT 001-18 SKHHP Regional Effort - 100,000 100,000 - OT 001-19 SKHHP Membership Dues - - 26,000 (26,000) OT 001-20 Housing Action Plan Implementation Grant - 100,000 100,000 - OT 001-21 Police Department: Police CBA Impacts to 2022 Budget - 819,000 1,459,000 (640,000) OG/OT 001-22 Carry Forward of ARPA Funds for Axon Contract - 42,900 42,900 - OT 001-23 Public Works Department: Commute Trip Reduction Program - 28,000 28,000 - OG 001-24 Local Road Safety Plan Carry Forward 40,000 - 40,000 - OT 001-25 Comprehensive Transportation Plan Carry Forward 65,000 - 65,000 - OT 001-26 Translation Services(ARPA-Funded) - 75,000 75,000 - OT 001-27 Page I of 9 3/9/2022 4:38 PM Schedule A Summary of 2022 Budget Adjustments by Fund Budget Amendment#5 (Ordinance#6850) Beg.Fund Ending Fund Req Balance Revenues Expenditures Balance OT/OG No Parks Department: WSDA Grant for Auburn Farmers Market Carry Forward 17,520 - 17,520 - OT 001-28 KCD 2022 Grant for Auburn Farmers Market - 20,000 20,000 - OT 001-29 Pumphouse Electrical Panel&Irrigation Pump 50,200 - 50,200 - OT 001-30 Golf Course Clubhouse Repairs - 150,000 150,000 - OT 001-31 Miscellaneous Safety and Repair at the Auburn Golf Course - - 40,000 (40,000) OT 001-32 Convert P/T Museum Curator to LTE - - 57,900 (57,900) OT 001-33 King County Revive and Thrive 2022 Grant for Petpalooza - 9,000 9,000 - OT 001-34 Senior Center VSHSL Grant Carry Forward 114,500 - 114,500 - OT 001-35 Auburn Arts&Culture Ctr Carry Forward and New Funding Request 51,000 - 141,000 (90,000) OT 001-36 4Culture-Auburn Arts Alley Funding Carry Forward - 18,400 18,400 - OT 001-37 AWC 2022 SEEK Programs - 230,700 230,700 - OT 001-38 Auburn Way South Median Landscape Replanting/Irrigation - 50,000 50,000 - OT 001-39 Streets Department: Street Light Repairs Carry Forward 36,250 - 36,250 - OT 001-40 Non Departmental: ERR Reimbursement for Vehicle Overruns - - 75,000 (75,000) OT 001-41 Replace Golf Mower - - 14,200 (14,200) OT 001-42 Revised 2022 Budget-Fund 001 18,083,303 84,539,650 93,187,686 9,435,267 Arterial Street Fund (#102) 2022 Adopted Budget 427,309 5,778,300 5,892,400 313,209 Previous Budget Amendments 129,821 315,000 515,000 (70,179) 2022 Amended Budget 557,130 6,093,300 6,407,400 243,030 BA#5(Ordinance#6850,Proposed): - 200,000 350,000 (150,000) Arterial Pedestrian and Bike Safety Project - - 100,000 (100,000) 102-01 124th Ave SE Improvements Project - 50,000 100,000 (50,000) 102-02 Auburn Way South Roundabout(ARPA-Funded) - 150,000 150,000 - 102-03 Revised 2022 Budget-Fund 102 557,130 6,293,300 6,757,400 93,030 Local Street Fund (#103) 2022 Adopted Budget 1,318,428 1,660,500 1,664,500 1,314,428 Previous Budget Amendments 709,525 - - 709,525 ................ 2022 Amended Budget 2,027,953 1,660,500 1,664,500 2,023,953 BA#5(Ordinance#6850,Proposed): - 636,866 636,866 - Paving Gravel Roads(ARPA-Funded) - 636,866 636,866 - OT 103-01 Revised 2022 Budget-Fund 103 2,027,953 2,297,366 2,301,366 2,023,953 Page 2 of 9 3/9/2022 4:38 PM Schedule A Summary of 2022 Budget Adjustments by Fund Budget Amendment#5(Ordinance#6850) Beg.Fund Ending Fund Req Balance Revenues Expenditures Balance OT/OG No Arterial Street Preservation Fund (#105) 2022 Adopted Budget 1,514,104 2,058,800 2,135,000 1,437,904 Previous Budget Amendments (71,451) - - (71,451) 2022 Amended Budget 1,442,653 2,058,800 2,135,000 1,366,453 BA#5(Ordinance#6850,Proposed): - 225,000 225,000 - Increase Budget for 2nd Street Reconstruction Project - 225,000 225,000 - OT 105-01 Revised 2022 Budget-Fund 105 1,442,653 2,283,800 2,360,000 1,366,453 American Rescue Plan Act Fund Fund (#106) 2022 Adopted Budget - - - - Previous Budget Amendments 5,416,700 - 1,970,000 3,446,700 2022 Amended Budget 5,416,700 - 1,970,000 3,446,700 BA#5(Ordinance#6850, Proposed): 371,300 7,375,600 2,923,166 4,823,734 Paving Gravel Roads(ARPA-Funded) - - 636,866 (636,866) OT 106-01 Police CBA Impacts to 2022 Budget - - 825,000 (825,000) OG/OT 106-02 Translation Services(ARPA-Funded) - - 75,000 (75,000) OT 106-03 Carry Forward ARPA-Funded Utility Assistance Program Funds 328,400 - 328,400 - OT 106-04 Vaccination Incentive Program Carry-Forward(ARPA Funded) - - 15,000 (15,000) OT 106-05 ARPA Revenue - 7,375,600 - 7,375,600 OT 106-06 Auburn Way South Median Landscape Replanting/Irrigation - - 50,000 (50,000) OT 106-07 Auburn Way South Roundabout(ARPA-Funded) - - 150,000 (150,000) OT 106-08 Carry Forward of ARPA Funds for Axon Contract 42,900 - 42,900 - OT 106-09 ARPA Funding for Mitigated Negative Economic Impacts - - 500,000 (500,000) OT 106-10 Emergency Housing Voucher Program(ABPA-Funded) - - 250,000 (250,000) OG 106-11 DEI Data Dashboard(ARPA-Funded) - - 50,000 (50,000) OT 106-12 Revised 2022 Budget-Fund 106 5,788,000 7,375,600 4,893,166 8,270,434 Drug Forfeiture Fund (#117) 2022 Adopted Budget 612,573 148,000 356,531 404,042 Previous Budget Amendments (53,266) - - (53,266) 2022 Amended Budget 559,307 148,000 356,531 350,776 BA#5(Ordinance#6850,Proposed): - 6,000 11,000 (5,000) Police CBA Impacts to 2022 Budget - 6,000 11,000 (5,000) OG/OT 117-01 Revised 2022 Budget-Fund 117 559,307 154,000 367,531 345,776 Page 3 of 9 3/9/2022 4:38 PM Schedule A Summary of 2022 Budget Adjustments by Fund Budget Amendment#5(Ordinance#6850) Beg.Fund Ending Fund Req Balance Revenues Expenditures Balance OTIOG _ No Housing & Comm Develop Fund (#119) 2022 Adopted Budget 42,904 600,000 600,000 42,904 Previous Budget Amendments (579) - - (579) 2022 Amended Budget 42,325 600,000 600,000 42,325 BA#5(Ordinance#6850,Proposed): - 744,900 744,900 - Community Development Block Grant Fund Adjustments for 2022 - 744,900 744,900 - OT 119-01 Revised 2022 Budget-Fund 119 42,325 1,344,900 1,344,900 42,325 Cumulative Reserve Fund (#122) 2022 Adopted Budget 6,484,315 80,000 1,950,000 4,614,315 Previous Budget Amendments 4,196,829 - - 4,196,829 2022 Amended Budget 10,681,144 80,000 1,950,000 8,811,144 BA#5(Ordinance#6850,Proposed): - 2,029,800 - 2,029,800 Sale of Fire Station - 2,029,800 - 2,029,800 OT 122-01 Revised 2022 Budget-Fund 122 10,681,144 2,109,800 1,950,000 10,840,944 Mitigation Fees Fund (#124) 2022 Adopted Budget 9,372,642 1,161,900 5,851,450 4,683,092 Previous Budget Amendments (1,476,597) - (300,000) (1,176,597) 2022 Amended Budget 7,896,045 1,161,900 5,551,450 3,506,495 BA#5(Ordinance#6850,Proposed): - - (2,581,550) 2,581,550 Reduce Funding for Jacobsen Tree Farm Project - - (2,581,550) 2,581,550 OT 124-01 Revised 2022 Budget-Fund 124 7,896,045 1,161,900 2,969,900 6,088,045 Parks Construction Fund (#321) 2022 Adopted Budget 1,031,996 3,483,950 3,730,050 785,896 Previous Budget Amendments (177,301) 125,000 125,000 (177,301) 2022 Amended Budget 854,695 3,608,950 3,855,050 608,595 BA#5(Ordinance#6850,Proposed): - (2,915,450) (2,815,450) (100,000) Reduce Funding for Jacobsen Tree Farm Project - (3,081,550) (3,081,550) - OT 321-01 Mill Creek Assemblage(Grant-Funded) - 166,100 166,100 - OT 321-02 Miscellaneous Park Improvements - - 100,000 (100,000) OT 321-03 Revised 2022 Budget-Fund 321 854,695 693,500 1,039,600 508,595 Page 4 of 9 3/9/2022 4:38 PM Schedule A Summary of 2022 Budget Adjustments by Fund Budget Amendment#5(Ordinance#6850) Beg.Fund Ending Fund Req Balance Revenues Expenditures Balance OT/OG No Capital Improvements Fund (#328) 2022 Adopted Budget 4,037,304 3,109,910 3,689,210 3,458,004 Previous Budget Amendments 3,027,711 1,550,000 1,950,000 2,627,711 2022 Amended Budget 7,065,015 4,659,910 5,639,210 6,085,715 BA#5(Ordinance#6850,Proposed): 150,000 - 150,000 - Arts&Cultural Roof Replacement Carry Forward 150,000 - 150,000 - OT 328-01 Revised 2022 Budget-Fund 328 7,215,015 4,659,910 5,789,210 6,085,715 Water Fund (#430) 2022 Adopted Budget 11,169,984 19,298,050 23,266,154 7,201,880 Previous Budget Amendments (210,918) - (1,032,800) 821,882 2022 Amended Budget 10,959,066 19,298,050 22,233,354 8,023,762 BA#5(Ordinance#6850,Proposed): 422,000 - 573,900 (151,900) Hydraulic Modeling Services Carry Forward 42,000 - 42,000 - OT 430-01 SCADA Radio System Upgrade Carry Forward 150,000 - 150,000 - OT 430-02 Consultant Services for Utility Rate Studiesp - - 44,300 (44,300) OT 430-03 Carry Forward Professional Services for Water Rights -- 230,000 - 230,000 - OT 430-04 Reallocate Utility Bill Printing and Credit Card Fee Expenses - - 72,100 (72,100) OT 430-05 ERR Reimbursement for Vehicle Overruns - - 35,500 (35,500) OT 430-06 Revised 2022 Budget-Fund 430 11,381,066 19,298,050 22,807,254 7,871,862 Sewer Fund (#431) 2022 Adopted Budget 9,001,356 9,992,880 8,321,966 10,672,270 Previous Budget Amendments (286,984) - 976,400 (1,263,384) 2022 Amended Budget 8,714,372 9,992,880 9,298,366 9,408,886 BA#5(Ordinance#6850,Proposed): 100,000 - 197,100 (97,100) SCADA Radio System Upgrade Carry Forward 100,000 - 100,000 - OT 431-01 Consultant Services for Utility Rate Studies - - 25,000 (25,000) OT 431-02 Reallocate Utility Bill Printing and Credit Card Fee Expenses - - 72,100 (72,100) OT 431-03 Revised 2022 Budget-Fund 431 8,814,372 9,992,880 9,495,466 9,311,786 Page 5 of 9 3/9/2022 4:38 PM Schedule A Summary of 2022 Budget Adjustments by Fund Budget Amendment#5(Ordinance#6850) Beg.Fund Ending Fund Req Balance Revenues Expenditures Balance OT/OG No Storm Drainage Fund (#432) 2022 Adopted Budget 10,263,121 10,951,870 9,283,281 11,931,710 Previous Budget Amendments 613,461 - 369,600 243,861 2022 Amended Budget 10,876,582 10,951,870 9,652,881 12,175,571 BA#5(Ordinance#6850,Proposed): 50,000 - 147,800 (97,800) SCADA Radio System Upgrade Carry Forward 50,000 - 50,000 - OT 432-01 Consultant Services for Utility Rate Studies - - 25,700 (25,700) OT 432-02 Reallocate Utility Bill Printing and Credit Card Fee Expenses - - 72,100 (72,100) OT 432-03 Revised 2022 Budget-Fund 432 10,926,582 10,951,870 9,800,681 12,077,771 Solid Waste Fund (#434) 2022 Adopted Budget 5,578,288 18,629,600 18,719,680 5,488,208 Previous Budget Amendments (281,301) - 681,200 (962,501) 2022 Amended Budget 5,296,987 18,629,600 19,400,880 4,525,707 BA#5(Ordinance#6850,Proposed): - - (216,300) 216,300 Reallocate Utility Bill Printing and Credit Card Fee Expenses - - (216,300) 216,300 OT 434-01 Revised 2022 Budget-Fund 434 5,296,987 18,629,600 19,184,580 4,742,007 Airport Fund (#435) 2022 Adopted Budget 1,608,781 1,507,100 2,878,847 237,034 Previous Budget Amendments (473,825) 750,000 (397,200) 673,375 2022 Amended Budget 1,134,956 2,257,100 2,481,647 910,409 BA#5(Ordinance#6850,Proposed): 10,000 - 10,000 - Airport Repairs&Maintenance Carry Forward 10,000 - 10,000 - OT 435-01 Revised 2022 Budget-Fund 435 1,144,956 2,257,100 2,491,647 910,409 Cemetery Fund (#436) 2022 Adopted Budget 364,582 1,280,400 1,386,048 258,934 Previous Budget Amendments 437,117 97,100 97,100 437,117 2022 Amended Budget 801,699 1,377,500 1,483,148 696,051 BA#5(Ordinance#6850,Proposed): - - 15,000 (15,000) Cemetery Gator Replacement - - 15,000 (15,000) OT 436-01 Convert Cemetery Maintenance Worker LTE to FTE(no cost in 2022) - - - - OG 436-02 Revised 2022 Budget-Fund 436 801,699 1,377,500 1,498,148 681,051 Page 6 of 9 3/9/2022 4:38 PM Schedule A Summary of 2022 Budget Adjustments by Fund Budget Amendment#5(Ordinance#6850) Beg.Fund Ending Fund Req Balance Revenues Expenditures Balance OT/OG No Sewer Capital Fund (#461) 2022 Adopted Budget 8,125,157 755,600 3,815,900 5,064,857 Previous Budget Amendments (395,750) - - (395,750) 2022 Amended Budget 7,729,407 755,600 3,815,900 4,669,107 BA#5(Ordinance#6850,Proposed): - - 100,000 (100,000) Additional Funding for Comprehensive Sewer Plan - - 100,000 (100,000) OT 461-01 Revised 2022 Budget-Fund 461 7,729,407 755,600 3,915,900 4,569,107 Storm Drainage Capital Fund (#462) 2022 Adopted Budget 6,713,135 562,800 4,651,800 2,624,135 Previous Budget Amendments 519,381 - 1,381,000 (861,619) 2022 Amended Budget 7,232,516 562,800 6,032,800 1,762,516 BA#5(Ordinance#6850,Proposed): - - (120,000) 120,000 TM- Additional Funding for Comprehensive Storm Drainage Plan - - 180,000 (180,000) OT 462-01 Correct CP2118 Project Budget - - (300,000) 300,000 OT 462-02 Revised 2022 Budget-Fund 462 7,232,516 562,800 5,912,800 1,882,516 Facilities Fund (#505) 2022 Adopted Budget 623,845 3,694,500 3,724,226 594,119 Previous Budget Amendments (46,261) (67,800) 112,000 (226,061) ............ 2022 Amended Budget 577,584 3,626,700 3,836,226 368,058 BA#5(Ordinance#6850,Proposed): 42,700 150,000 438,700 (246,000) Replace Justice Center Elevator Components - - 50,000 (50,000) OT 505-01 Arts&Cultural Roof Replacement Carry Forward - 150,000 150,000 - OT 505-02 City Hall Elevator Modification Carry Forward and New Request 42,700 - 175,700 (133,000) OT 505-03 Compliance with Clean Building Standards - - 20,000 (20,000) OG 505-04 Contracted Security - - 43,000 (43,000) OT 505-05 Revised 2022 Budget-Fund 505 620,284 3,776,700 4,274,926 122,058 Page 7 of 9 3/9/2022 4:38 PM Schedule A Summary of 2022 Budget Adjustments by Fund Budget Amendment#5(Ordinance#6850) Beg.Fund Ending Fund Req Balance Revenues Expenditures Balance OT/OG No Innovation &Technology Fund (#518) J 2022 Adopted Budget 1,949,637 6,903,800 7,014,444 1,838,993 Previous Budget Amendments 126,252 6,000 6,000 126,252 2022 Amended Budget 2,075,889 6,909,800 7,020,444 1,965,245 BA#5(Ordinance#6850,Proposed): 255,000 - 255,000 - Carry Forward IT Equipment,Upgrades and Licenses 255,000 - 255,000 - OT 518-01 Revised 2022 Budget-Fund 518 2,330,889 6,909,800 7,275,444 1,965,245 Equipment Rental Fund (#550) 2022 Adopted Budget 1,552,779 2,301,100 3,079,708 774,171 Previous Budget Amendments 227,114 - 25,700 201,414 2022 Amended Budget 1,779,893 2,301,100 3,105,408 975,585 BA#5(Ordinance#6850,Proposed): - - 86,000 (86,000) ERR Reimbursement for Vehicle Overruns - - 86,000 (86,000) OT 550-01 Revised 2022 Budget-Fund 550 1,779,893 2,301,100 3,191,408 889,585 Equipment Rental Capital Fund (#560) 2022 Adopted Budget 3,902,729 1,993,760 1,435,600 4,460,889 Previous Budget Amendments (1,059,460) 72,700 72,700 (1,059,460) 2022 Amended Budget 2,843,269 2,066,460 1,508,300 3,401,429 ................ BA#5(Ordinance#6850,Proposed): - 225,700 301,400 (75,700) Replace Golf Mower - 14,200 89,900 (75,700) OT 560-01 Cemetery Gator Replacement - 15,000 15,000 - OT 560-02 ERR Reimbursement for Vehicle Overruns - 196,500 196,500 - OT 560-03 Revised 2022 Budget-Fund 560 2,843,269 2,292,160 1,809,700 3,325,729 Page 8 of 9 3/9/2022 438 PM Schedule A Summary of 2022 Budget Adjustments by Fund Budget Amendment#5(Ordinance#6850) Beg.Fund Ending Fund Req Balance Revenues Expenditures Balance OT/OG No SKHHP Fund (#654) 2022 Adopted Budget 186,885 252,300 315,450 123,735 Previous Budget Amendments 38,028 24,225 25,400 36,853 2022 Amended Budget 224,913 276,525 340,850 160,588 BA#5(Ordinance#6850,Proposed): - 126,000 100,000 26,000 SKHHP Regional Effort - 100,000 100,000 - OT 654-01 SKHHP Membership Dues - 26,000 - 26,000 OT 654-02 Revised 2022 Budget-Fund 654 224,913 402,525 440,850 186,588 Grand Total -All Funds 2022 Adopted Budget 109,651,771 216,957,920 237,525,025 89,084,666 Previous Budget Amendments 18,764,712 1,529,725 7,424,350 12,870,087 2022 Amended Budget 128,416,483 218,487,645 244,949,375 101,954,753 TOTAL BA#5(Ordinance#6850,Proposed): 2,068,070 11,512,416 6,336,902 7,243,584 Revised 2022 Budget 130,484,553 230,000,061 251,286,277 109,198,337 360,484,614 360,484,614 Page 9 of 9 3/9/2022 4:38 PM Schedule B 2021 Ending Fund Balance/Working Capital by Fund 2022 2022 Amended Adopted BA#4 Budget BA#5 Revised Fund Budget (Ord#6837) (before BA#5) (Ord#6850) Budget General Fund(#001) I 6,858,019 4,006,548 10,864,567 (1,429,300) 9,435,267 Arterial Street Fund(#102) 313,209 (70,179) 243,030 (150,000) 93,030 Local Street Fund(#103) 1,314,428 709,525 2,023,953 - 2,023,953 Hotel/Motel Tax Fund(#104) 179,066 90,521 269,587 - 269,587 Arterial Street Preservation Fund(#105) 1,437,904 (71,451) 1,366,453 - 1,366,453 American Rescue Plan Act Fund(#106) - 3,446,700 3,446,700 4,823,734 8,270,434 Drug Forfeiture Fund(#117) 404,042 (53,266) 350,776 (5,000) 345,776 Housing&Comm Develop Fund(#119) 42,904 (579) 42,325 - 42,325 Recreation Trails Fund(#120) 94,825 2,287 97,112 - 97,112 BIA Fund(#121) 27,425 73,070 100,495 - 100,495 Cumulative Reserve Fund(#122) 4,614,315 4,196,829 8,811,144 2,029,800 10,840,944 Mitigation Fees Fund(#124) 4,683,092 (1,176,597) 3,506,495 2,581,550 6,088,045 City Hall Annex 2010 A&B Bond Fund(#230) 4,489 , (4,489) - - - Local Revitalization 2010 C&D Bond Fund(#231) 34,133 (34,133) - - - 2020 LTGO A&B Refunding Bonds Fund(#232) - 798,248 798,248 - 798,248 SCORE Debt Service Fund(#238) - - - - - LID Guarantee Fund(#249) 1,689 7 1,696 - 1,696 LID 350 Fund(#275) 1,373 794 2,167 - 2,167 Golf/Cemetery 2016 Refunding Fund(#276) - - - - - Parks Construction Fund(#321) 785,896 (177,301) 608,595 (100,000) 508,595 Capital Improvements Fund(#328) 3,458,004 2,627,711 6,085,715 - 6,085,715 Local Revitalization Fund(#330) - - - - - Water Fund(#430) 7,201,880 821,882 8,023,762 (151,900) 7,871,862 Sewer Fund(#431) 10,672,270 (1,263,384) 9,408,886 (97,100) 9,311,786 Storm Drainage Fund(#432) 11,931,710 243,861 12,175,571 (97,800) 12,077,771 Sewer Metro Sub Fund(#433) 2,074,736 771,586 2,846,322 - 2,846,322 Solid Waste Fund(#434) 5,488,208 (962,501) 4,525,707 216,300 4,742,007 Airport Fund(#435) 237,034 673,375 910,409 - 910,409 Cemetery Fund(#436) 258,934 437,117 696,051 (15,000) 681,051 Water Capital Fund(#460) 2,816,839 (257,156) 2,559,683 - 2,559,683 Sewer Capital Fund(#461) 5,064,857 (395,750) 4,669,107 (100,000) 4,569,107 Storm Drainage Capital Fund(#462) 2,624,135 (861,619) 1,762,516 120,000 1,882,516 Airport Capital Fund(#465) 196,137 140,783 336,920 - 336,920 Cemetery Capital Fund(#466) 10,583 43,597 54,180 - 54,180 Insurance Fund(#501) 1,400,053 18,262 1,418,315 - 1,418,315 Workers'Comp Fund(#503) 2,905,527 58,098 2,963,625 - 2,963,625 Facilities Fund(#505) 594,119 (226,061) 368,058 (246,000) 122,058 Innovation&Technology Fund(#518) 1,838,993 126,252 1,965,245 - 1,965,245 Equipment Rental Fund(#550) 774,171 201,414 975,585 (86,000) 889,585 Equipment Rental Capital Fund(#560) 4,460,889 (1,059,460) 3,401,429 (75,700) 3,325,729 IT Capital Fund(#568) 225,014 (135,461) 89,553 - 89,553 Fire Pension Fund(#611) 1,819,133 55,039 1,874,172 - 1,874,172 SKHHP Fund(#654) 123,735 36,853 160,588 26,000 186,588 Cemetery Endowment Fund(#701) 2,110,896 39,116 2,150,012 - 2,150,012 Total 89,084,666 12,870,087 101,954,753 7,243,584 109,198,337