HomeMy WebLinkAbout6837 ORDINANCE NO. 6837
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 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 City of Auburn deems it necessary to appropriate additional
funds to the various funds of the 2022 budget as outlined in this Ordinance (BA#4);
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:
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.
Ordinance No. 6837
October 20, 2021
Page 1 of 2
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.
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:
NOV 1 5 2021
PASSED: NOV 1 5 2021
APPROVED: NOV 1 5 2021
ANCY KUS, MAYOR
ATTEST: APPROVED AS TO FORM:
Shawn Campbell, MMC, City Clerk Kendra Comeau, City Attorney
Published: .\10‘16,011)( ‘1St 7021 4i4 '\ (5
Ordinance No. 6837
October 20, 2021
Page 2 of 2
CITY OF Interoffice Memorandum
AUBURN
WASHINGTON
To: City Council
From: Jamie Thomas, Finance Director
CC: Nancy Backus, Mayor
Date: October 12, 2021
Re: Ordinance#6837—2021-2022 Budget Amendment#4 --AMENDED
The City's biennial 2021-2022 budget was approved by Council as two one-year appropriations. Budget
Amendments#1 through#3 amended the budget for calendar year 2021.This amendment will be the fourth
budget amendment for the biennium and the first budget amendment for calendar year 2022. The purpose
of this budget amendment is to:
1. Realign significant revenue sources;
2. Adjust projected 2022 beginning fund balance to reflect budget amendments made in 2021;
3. Adopt the continuation of previously-approved requests for ongoing expenditures;
4. Adjust capital project budgets to match the 2022-2025 Capital Facilities Plan(CFP);and
5. Add budget authority for new programs and other expected changes in 2022.
Realign Significant Revenue Sources.With new legislation and policies adopted throughout 2021,and
three quarters of revenue collection data for 2021,there is an opportunity to fine-tune revenue projections for
2022. Total General Fund revenue adjustments would result in a net reduction of$652,000 and include:
• Sales and use tax increase $ 2,500,000
• Business&Occupation tax reduction to reflect delays in implementation -4,300,000
• Streamlined sales tax mitigation increase due to legislative extension through 2022 1,000,000
Adopt the continuation of previously approved requests by Council. Amend the 2022 budget for
changes adopted in 2021 for which there is an ongoing fiscal impact in 2022. Items in this category
were previously approved by Council in 2021. In total, these items would increase budgeted 2022
expenditures by about$1.1 million, and include:
• Utility tax increase to reflect higher City tax rate $2,242,900
• Reduced budget for lead service line replacement project(moved to 2021) -1,600,000
• Net reduction in debt service on 2020 LTGO A&B refunding bonds - 695,400
• Axon contract for body camera hardware and software 427,500
• Reduction in Airport debt service due to change in funding for hangar project - 336,300
• Increased budget for homeless sheltering by the Auburn Food Bank 275,000
• Operating budget for the Auburn Community Resource Center 150,900
• Limited Term Employee: Recruitment Coordinator 137,000
AUBURN r MORE THAN YOU IMAGINED
• Limited Term Employee: Grants Coordinator(ARPA-funded) 132,000
• Limited Term Employee: Accounting Specialist 116,700
• Contracted Security at City Hall,the Annex, and Les Gove campus 112,000
Adjust capital project budgets. Represent changes to project budgets to align with the updated
2022-2027 Capital Facilities Plan (CFP)that is scheduled to be adopted in December, excluding
unspent capital project budgets from 2021 that are automatically carried forward into 2022 due to the
adoption of multi-year capital budgeting, as authorized in Ordinance No. 6682 (June 2018). The net
increase due to these proposed adjustments is$4.2 million.
Significant project adjustments included in this budget amendment include:
• Funding for North Airport storm improvements (cp2102) $ 946,000
• Incr. budget for sidewalk repair and improvements(ARPA and fee funded) 850,000
• Incr. budget for Neighborhood Street Lighting Program (ARPA funded) 500,000
• Net increase for Airport hangar project 439,100
• Funding for North Airport stormwater system improvements (cp2118) 435,000
• Budget for City Hall Annex customer service center reconfiguration 350,000
• Incr. budget for Neighborhood Traffic Safety Program (ARPA and REET funded) 250,000
Add budget authority for new programs and other expected changes in 2022.These include
requests for new full-time employees (FTEs), increased funding for existing programs, and funding
requests for new projects or programs. These requests, which total $1.9 million, include:
• Four new FTEs to provide support for body cameras $ 479,200
• Two new FTEs for an in-house litter crew 267,500
• New FTE: Outreach Coordinator 141,600
• Supplement the existing human services contracts budget(ARPA funded) 160,000
• Incr. Golf Course maintenance, inventory, and supplies budget(revenue funded) 105,000
Adjustments of 2022 beginning fund balance due to 2021 budget amendments. Each approved
budget amendment in 2021 (in BA#1, BA#2,and proposed BA#3)that amended the 2021 budgeted ending
fund balance also affects the budgeted 2022 beginning fund balance. These adjustments,which affect most
funds, increase 2022 budgeted fund balance by$18.8 million.
The following table summarizes the current and revised budget as a result of this amendment.
Table 1: 2022 Budget as Amended
2022 Adopted Budget $326,609,691
Budget Amendment#4(Ord #6837) 20,294,437
2022 Budget as Amended $346,904,128
Attachments:
• Proposed Ordinance#6837(Budget Amendment#4)
• Summary of 2022 Budget Adjustments by Fund(Schedule A)
• Summary of 2022 ending fund balance/working capital by fund(Schedule B)
AUBURN * MORE THAN YOU IMAGINED
Schedule A
Summary of 2022 Budget Adjustments by Fund
Budget Amendment#4(Ordinance#6837)
Beg.Fund 2022 2022 Ending Fund
Balance Revenues Expenditures Balance
General Fund(#001)
2022 Adopted Budget 10,524,785 81,938,250 85,605,016 6,858,019
BA#4(Ordinance#6837,Proposed): 6,891,448 (106,600) 2,778,300 4,006,548
General Fund Revenues:
Move lease revenues from Facilities to General Fund jBA#3j - 108,000 - 108,000
Budget for ACRC lease revenues from the Auburn Food Bank(BA#3) - 40,000 - 40,000
Adjust sales tax,B&O tax,and streamlined sales tax mitigation revenues - (800,000) - J800,000).
Mayor/Council:
New Full-Time Employee(FTE): Outreach Coordinator - - 141,600 (141,600)
Human Resources Department:
Funds to certify Human Resources staff to allow for more internally-run training - - 50,000 (50,000)
Increase funding to improve the recruitment process using a DEI lens - - 100,000 (100,000)
Continue Limited Term Employee(LTE): Recruitment Coordinator jBA#3,1_. - - 137,000 (137,000).
City Attorneys Office:
Ongoing incr to Auburn Food Bank sheltering budget for homeless persons [BA#21 - - 275,000 (275,0001
Ongoing budget for operation of the Auburn Consolidated Resource Center (BA#21 - - 150,900 (150,900)
Ongoing incr to budget to respond to civil judgments,subpoenas,etc. [BA#11 - - 25,000 (25,000)
Four new FTEs to provide support for body cameras and Axon contract for 2022 - - 906,700 (906,700)
Community Development Department:
Ongoing budget for eCityGov Alliance annual subscription(fee supported)_..[BA#2j - - 65,000 (85y000).
Use of ARPA funds to supplement the existing Human Services contracts budget - 160,000 160,000 -
Adjust SKHHP budget to reflect adopted 2022 budget - 25,400 25,400 -
Finance Department:
Continue Limited Term Employee..(LTE): Accounts Receivable Specialist [BA#31 - - 116,700 (116,700)
Continue Limited Term Employee(LTE): Grants Coordinator(ARPA funded) (BA#31 - 132,000 132,000 -
Public Works Department:
Ongoing increase in budget for signal system repair and maintenance [BA#11 - 50,000 50,000 -
Convert part-time temp GIS Technician position to LTE(GF,F430,F431,F432) - - 15,000 (15,000)
Fund analysis and modeling to update the Comprehensive Transportation Plan - - 100,000 (100,000)
Parks Department:
Update the Parks,Arts and Recreation Plan required by the GMA - - 50,000 (50,000)
Increase contracted landscaping work within public right-of-ways - - 100,000 (100,000)
Recreation access grants to impacted communities(ARPA funded) - 50,000 50,000 -
Increase Golf Course repair and maintenance,inventory,and supplies budgets - 105,000 105,000
King County Veterans,Seniors and Human Services levy(grant funds) - 23,000 r 23,000
Page 1 of 12 11/4/2021 6:57 AM
Schedule A
Summary of 2022 Budget Adjustments by Fund
Budget Amendment#4(Ordinance#6837)
Beg.Fund 2022 2022 Ending Fund
Balance Revenues Expenditures Balance
Streets Department:
Move funds to F102 for Roadway Channelization Refreshment project - - - -
001.42.542.300.41 PROFESSIONAL SERVICES (200,000)
001.98.5127.100.55 OPERATING TRANSFERS OUT 200,000
Non-Departmental:
Adjust beginning_fund balance for budget amendments in 2021 6,891,448 - - 6,891,448
Revised 2022 Budget-Fund 001 17,416,233 81,831,650 88,383,316 10,864,567
Arterial Street Fund(#102)
2022 Adopted Bud9et427,309 5,778,300 5,892,400 313,209
BA#4(Ordinance#6837,Proposed): 129,821 315,000 515,000 (70,179).
Adjust beginning_fund balance for budget amendments in 2021 129,821 - - 129,821
Move funds and increase budget for Roadway Channelization Refreshment project - 200,000 350,000 (150,000)
Increase budget for the Non-Motorized Safety Program - - 50,000 (50,000)
Replace traffic impact fee funding for A St.Loop project with Sound Transit funds - 40,000 40,000 -
Grant revenue and expenditure for Arterial&Pedestrian Bicycle Safety program - 75,000 75,000 -
Revised 2022 Budget-Fund 102 557,130 6,093,300 6,407,400 243,030
Local Street Fund(#103)
2022 Adopted Budget 1,318,428 1,660,500 1,664,500 1,314,428
BA#4(Ordinance#6837,Proposed): 709,525 - - 709,525
Adjust beginning fund balance for budget amendments in 2021 709,525 - - 709,525
Revised 2022 Budget-Fund 103 2,027,953 1,660,500 1,664,500 2,023,953
Hotel/Motel Tax Fund(#104)
2022 Adopted Budget 187,276 168,900 177,110 179,066
BA#4(Ordinance#6837,Proposed): 90,521 - - 90,521
Adjust beginning fund balance for budget amendments in 2021 90,52190,521_
Revised 2022 Budget-Fund 104 277,797 168,900 177,110 269,587
Page 2 of 12 11/42021 6:57 AM
Schedule A
Summary of 2022 Budget Adjustments by Fund
Budget Amendment#4(Ordinance#6837)
Beg.Fund 2022 2022 Ending Fund
Balance Revenues Expenditures Balance
Arterial Street Preservation Fund(#105)
2022 Adopted Budget 1,514,104 2,058,800 2,135,000 1,437,904
BA#4(Ordinance#6837,Proposed): (71,451) - - (71,451)
Adjust beginning fund balance for budget amendments in 2021 (71,451) - - (71,4511
Revised 2022 Budget-Fund 105 1,442,653 2,058,800 2,135,000 1,366,453
American Rescue Plan Act Fund Fund(#106)
2022 Adopted Budget - - -
BA#4(Ordinance#6764,Proposed): 5,416,700 - 1,970,000 3,446,700
Adjust beginning fund balance for budget amendments in 2021 5,416,700 - - 5,416,700
Use of ARPA funds to supplement the existing Human Services contracts budget - - 160,000 (160,000)
Increase budget for Neighborhood Traffic Safety Program(ARPA&REET funding) - - 200,000 (200,000)
Increase sidewalk repair&improvement project budgets(ARPA and fee funded) - - 800,000 (800,000)
Increase Neighborhood Street Lighting Program budget(ARPA funded) - - 500,000 (500,000)
Recreation access grants to impacted communities(ARPA funded) - - 50,000 (50,000)
Minor improvements to qualifying neighborhood parks(ARPA funded) - - 75,000 (75,000)
Repair or replace Dykstra Footbridge(ARPA funded) 50,000�Y (50,000)
Continue Limited Term Employee(LTE): Grants Coordinator(ARPA funded) [BA#3 _._ -, _ 135,000 (135,000)
Revised 2022 Budget-Fund 106 5,416,700 - 1,970,000 3,446,700
Drug Forfeiture Fund(#117)
2022 Adopted Budget 612,573 148,000 356,531 404,042
BA#4(Ordinance#6837,Proposed): (53,266) - - (53,266)
Adjust beginning fund balance for budget amendments in 2021 153,266) - - (53,266).
Revised 2022 Budget-Fund 117 559,307 148,000 356,531 350,776
Housing&Comm Develop Fund(#119)
2022 Adopted Budget 42,904 600,000 600,000 42,904
BA#4(Ordinance#6837,Proposed): (579)_._ - - (579)
Adjust beginning fund balance for budget amendments in 2021 (579) - - - (579),
Revised 2022 Budget-Fund 119 42,325 600,000 600,000 42,325
Page 3 of 12 11/42021 6:57 AM
Schedule A
Summary of 2022 Budget Adjustments by Fund
Budget Amendment#4(Ordinance#6837)
Beg.Fund 2022 2022 Ending Fund
Balance Revenues Expenditures Balance
Recreation Trails Fund(#120)
2022 Adopted Budget 87,125 7,700 - 94,825
BA#4(Ordinance#6837,Proposed): 2,287 - - 2,287
Adjust beginning fund balance for budget amendments in 2021 2,287 - 2,287
Revised 2022 Budget-Fund 120 89,412 7,700 - 97,112
BIA Fund(#121)
2022 Adopted Budget 62,025 55,400 90,000 27,425
BA#4(Ordinance#6837,Proposed): 73,070 - 73,070
Adjust beginning fund balance for budget amendments in 2021 73,07073,070
Revised 2022 Budget-Fund 121 135,095 55,400 90,000 100,495
Cumulative Reserve Fund(#122)
2022 Adopted Budget 6,484,315 80,000 1,950,000 4,614,315
BA#4(Ordinance#6837,Proposed): 4,196,829 - 4,196,829
Adjust beginning fund balance for budget amendments in 2021 4,196,829 - - 4,196,829
Revised 2022 Budget-Fund 122 10,681,144 80,000 1,950,000 8,811,144
Mitigation Fees Fund(#124)
2022 Adopted Budget 9,372,642 1,161,900 5,851,450 4,683,092
BA#4(Ordinance#6837,Proposed): (1,476,597) - (300,000) (1,176,5971
Adjust beginning fund balance for budget amendments in 2021 (1,476,597) - - (1,476597)
Replace traffic impact fee funding for A St.Loop project with Sound Transit funds - (300,000) 300,000
Revised 2022 Budget-Fund 124 7,896,045 1,161,900 5,551,450 3,506,495
Page 4 of 12 11/42021 6:57 AM
Schedule A
Summary of 2022 Budget Adjustments by Fund
Budget Amendment#4(Ordinance#6837)
Beg.Fund 2022 2022 Ending Fund
Balance Revenues Expenditures Balance
City Hall Annex 2010 A&B Bond Fund(#230)
2022 Adopted Budget 4,489 1,637,300 1,637,300 4,489
BA#4(Ordinance#6837,Proposed): (4,489) (1,637,300) (1,637,300) (4,489)
Move debt service on 2010 debt to 2020 LTGO A&B Refunding Bonds Fund IBA#2) - (1,637,300) (1,637,300) -
Adjust beginning fund balance for budget amendments in 2021 (4,489) - - (4,489)
Revised 2022 Budget-Fund 230 - - -
Local Revitalization 2010 C&D Bond Fund(#231)
2022 Adopted Budget 33,863 567,370 567,100 34,133
BA#4(Ordinance#6837,Proposed): (33,863) (567,370) (567,100) (34,133)
Adjust beginning fund balance for budget amendments in 2021 (33,863) - - (33,863)
Move debt service on 2010 debt to 2020 LTGO A&B Refunding Bonds Fund(BA#2). - (567,370) (567100) (270)
Revised 2022 Budget-Fund 231 - - -
2020 LTGO A&B Refunding Bonds Fund(#232)
2022 Adopted Budget - - -
BA#4(_Ordinance#6764,Proposed): 102,828 2,204,670 1,509,250 798,248
Adjust beginning fund balance for budget amendments in 2021 102,828 - - 102,828
Move debt service on 2010 debt to 2020 LTGO A&B Refunding Bonds Fund (13A#2) - 2,204,670 1,5097250 695,420
Revised 2022 Budget-Fund 232 102,828 2,204,670 1,509,250 798,248
LID Guarantee Fund(#249)
2022 Adopted Budget 1,679 10 - 1,689
BA#4(Ordinance#6837,Proposed): 7 - - 7
Adjust beginning fund balance for budget amendments in 2021 7 - - 7
Revised 2022 Budget-Fund 249 1,686 10 - 1,696
Page 5 of 12 11/4/2021 6:57 AM
Schedule A
Summary of 2022 Budget Adjustments by Fund
Budget Amendment#4(Ordinance#6837)
Beg.Fund 2022 2022 Ending Fund
Balance Revenues Expenditures Balance
LID 350 Fund(#275)
2022 Adopted Budget 1,363 10 -
1,373
BA#4(Ordinance#6837,Proposed): 794 - - 794
Adjust beginning fund balance for budget amendments in 2021 794794
Revised 2022 Budget-Fund 275 2,157 10 - 2,167
Parks Construction Fund(#321)
2022 Adopted Budget 1,031,996 3,483,950 3,730 050 785,896
BA#4(Ordinance#6837,Proposed): (177,301) 125,000 125,000 (177,301.)
Adjust beginning fund balance for budget amendments in 2021 (177,301) - (177,301)
Minor improvements to qualifying neighborhood parks ARPA funded) - 75,000 75,000
Repair or replace Dykstra Footbridge(ARPA funded)_ _ - 50,000 50,000 _ -
Revised 2022 Budget-Fund 321 854,695 3,608,950 3,855,050 608,595
Capital Improvements Fund(#328)
2022 Adopted Budget... .4,037,304..................._3,109,910...................-3,689.210...................._3,458,004..
BA#4(Ordinance#6837,Proposed): 3,027,711 1,550,000 1,950,000 2,627,711
Adjust beginning fund balance for budget amendments in 2021 3,027,711 - - 3,027,711
Increase sidewalk repair&improvement project budgets.(ARPA and fee funded) 850,000 850,000
Increase budget for Neighborhood Traffic Safety Program(ARPA&REET funding) - 200,000 250,000 (50,000)
Increase Neighborhood Street Lighting Program budget(ARPA funded) - 500,000 500,000
Reconfigure City Hall Annex 2nd floor customer service center(REET funded) - - 350,000 (350,000)
Revised 2022 Budget-Fund 328 7,065,015 4,659,910 5,639,210 6,085,715
Page 6 of 12 11/4/2021 6:57 AM
Schedule A
Summary of 2022 Budget Adjustments by Fund
Budget Amendment#4(Ordinance#6837)
Beg.Fund 2022 2022 Ending Fund
Balance Revenues Expenditures Balance
Water Fund(#430)
2022 Adopted Budget 11,169,984 19,298,050 23,266,154 7,201,880
BA#4(Ordinance#6837,Proposed): (210,918) - (1,032,800) 821,882
. ..................
Adjust beginning fund balance for budget amendments in 2021 6210,918) - - (210,918)
Ongoing cost of new FTE in M&O Division—Administrative Specialist (BA#2]_ - - 14,200 (14,200)
Delete budget for lead service line replacement project(moved to 2021) (BA#1a - - (1,600 000) 1,600,000
Increase utility tax expense to reflect higher City tax rate(in Ord.#6822) - - 539,200 (539,200)
Convert part-time temp GIS Technician position to LTE(GF,F430,F431,F432) - - 13,800 (13,800)
Revised 2022 Budget-Fund 430 10,959,066 19,298,050 22,233,354 8,023,762
Sewer Fund(#431)
2022 Adopted Budget 9,001,356 9,992,880 8,321,966 10,672,270
BA#4(Ordinance#6837,Proposed): (286,984) - 976,400 (1,263,384).
Adjust beginning fund balance for budget amendments in 2021 (286,984) - - (286,984)
Ongoing cost of new FTE in M&O Division—Administrative Specialist (BA#2( - - 14,200 (14,200)
Increase utility tax expense to reflect higher City tax rate(in Ord.#6822) - - 948,400 (948,400)
Convert part-time temp GIS Technician position to LTE(GF,F430,F431,F432) - - 13,800 (13,800)
Revised 2022 Budget-Fund 431 8,714,372 9,992,880 9,298,366 9,408,886
Storm Drainage Fund(#432)
2022 Adopted Budget 10,263,121 10,951,870 9,283,281 11,931,710
BA#4(Ordinance#6837,Proposed): 613,461 - 369,600 243,861
Adjust beginning fund balance for budget amendments in 2021 613,461 - - 613,461
Ongoing cost of new FTE in M&O Division—Administrative Specialist [BA#21 - - 14,200 (14,200)
Increase utility tax expense to reflect higher City tax rate(in Ord.#6822) - - 341,600 (341,600).
Convert part-time temp GIS Technician position to LTE(GF,F430,F431,F432) - - 13,800 (13,800)
Revised 2022 Budget-Fund 432 10,876,582 10,951,870 9,652,881 12,175,571
Page 7 of 12 11/4/2021 6:57 AM
Schedule A
Summary of 2022 Budget Adjustments by Fund
Budget Amendment#4(Ordinance#6837)
Beg.Fund 2022 2022 Ending Fund
Balance Revenues Expenditures Balance
Sewer Metro Sub Fund(#433)
2022 Adopted Budget 2,070,836 21,012,700 21,008,800 2,074,736
BA#4(Ordinance#6837,Proposed): 771,586 - - 771,586
Adjust beginning fund balance for budget amendments in 2021 771,586 - - 771,586
Revised 2022 Budget-Fund 433 2.842,422 21,012,700 21,008,800 2,846,322
Solid Waste Fund(#434)
2022 Adopted Budget 5,578,288 18,629,600 18,719,680 5,488,208
BA#4(Ordinance#6837,Pr posed): (281,301) - 681,200 (962,501).
Adjust beginning fund balance for budget amendments in 2021 (281,301) - - (281,301).
Increase utility tax expense to reflect higher City tax rate(in Ord.#6822) - - 413,700 (413,700)
Provide in-house litter crew to replace Waste Management crew(incl two FTEs) - - 267,500 (267,5001
Revised 2022 Budget-Fund 434 5,296,987 18,629,600 19,400,880 4,525,707
Airport Fund(#435)
2022 Adopted Budget 1,608,781 1,507,100 2,878,847 237,034
BA#4(Ordinance#6837,Proposed):...__.._..__...__...__ (473,825) 750,000 (397,200)_ 673,375
Move budget for Airport maintenance projects from capital subfund IBA#21 - - -
435.00.597.100.55 OPERATING TRANSFERS OUT (75,000)
435.00.548.800.48 REPAIRS&MAINTENANCE 75,000
Reduce budget for hangar projects that had been planned to be bond-funded - 750,000 .1397200)_ 1,147,200
Adjust beginning fund balance for budget amendments in 2021 (473,825) - - (473,825)
Revised 2022 Budget-Fund 435 1,134,956 2,257,100 2,481,647 910,409
Cemetery Fund(#436)
2022 Adopted Budget 364,582 1,280,400 1,386,048 258,934
BA#4(Ordinance#6837,Proposed): 437,117 97,100 97,100 437,117
Adjust beginning fund balance for budget amendments in 2021 437,117 - - 437,117
New Limited Term Employee(LTE): Maintenance Worker _ __ - 975100 _ 97,100
Revised 2022 Budget-Fund 436 801,699 1,377,500 1,483,148 696,051
Page 8 of 12 11/4/2021 6:57 AM
Schedule A
Summary of 2022 Budget Adjustments by Fund
Budget Amendment#4(Ordinance#6837)
Beg.Fund 2022 2022 Ending Fund
Balance Revenues Expenditures Balance
Water Capital Fund(#460)
2022 Adopted Budget 1832,439 10,450,710 9,466,,310 2,816,839
BA#4(Ordinance#6837,Proposed): (257,156) (1,600,000) (1,600,000) (257,156)
Adjust beginning fund balance for budget amendments in 2021 (257,156) - - (257,156)
Delete budget for lead service line replacement project(moved to 2021) (BA#1) - 1.1,,600,000) (17600,000)__
Revised 2022 Budget-Fund 460 1,575,283 8,850,710 7,866,310 2,559,683
Sewer Capital Fund(#461)
2022 Adopted Budget _ 8,125,157 755,600 3,815,900 5,064,857
BA#4(Ordinance#6837,Proposed): (395,750) - - (395,7501
Adjust beginning fund balance for budget amendments in 2021 (395,750) - - (395,750)
Revised 2022 Budget-Fund 461 7,729,407 755,600 3,815,900 4,669,107
Storm Drainage Capital Fund(#462)
2022 Adopted Budget 6,713,135 562,800 4,651,800 2,,624,135
BA#4(Ordinance#6837,Proposed): 519,381 - 1,381,000 (861,619)
Adjust beginning fund balance for budget amendments in 2021 519,381 - - 519,381
Provide funding for North Airport stormwater improvements(cp2102) - - 946,000 (946,000)
Incr budget for North Airport stormwater system improvements,phase 2(cp2118) - - 435,000 (435,000)
Revised 2022 Budget-Fund 462 7,232,516 562,800 6,032,800 1,762,516
Page 9 of 12 11/4/2021 6:57 AM
Schedule A
Summary of 2022 Budget Adjustments by Fund
Budget Amendment#4(Ordinance#6837)
Beg.Fund 2022 2022 Ending Fund
Balance Revenues Expenditures Balance
Airport Capital Fund(#465)
2022 Adopted Budget _-_ 129,157 1,847,420 1,780,440 196,137
BA#4(Ordinance#6837,Proposed): 140,783 364,100 364,100 140,783
Move budget for Airport maintenance projects to operating subfund [BA#2) - (75,000) (75,000) -
Adjust
Adjust beginning fund balance for budget amendments in 2021 140,783 - - 140,783
Reduce budget for hangar projects that had been planned to be bond-funded - 439,100 439,100_.. -
Revised 2022 Budget-Fund 465 269,940 2,211,520 2,144,540 336,920
BA#4(Ordinance#6837,Proposed): _ 43,597 -
- 43,597
Adjust beginning fund balance for budget amendments in 2021 43,597 - - 43,597
Revised 2022 Budget-Fund 466 53,280 1,000 100 54,18_
Insurance Fund(#501) .
2022 Adopted Budget 1,571,253 12,000 183,200 1,400,053
BA#4(Ordinance#6837,Proposed): 18,262 - - 18,262
Adjust beginning fund balance for budget amendments in 2021 18,262 . - - 18,262
Revised 2022 Budget-Fund 501 1,589,515 12,000 183,200 1,418,315
Workers'Comp Fund(#503)
2022 Adopted Budget 2,644,627 1,144,900 884:000 2,905,527
BA#4(Ordinance#6837,Proposed): 58,098 - - 58,098
Adjust beginning fund balance for budget amendments in 2021 58,098 - - 58,098
Revised 2022 Budget-Fund 503 2,702,725 1,144,900 884,000 2,963,625
Page 10 of 12 11/4/2021 6:57 AM
Schedule A
Summary of 2022 Budget Adjustments by Fund
Budget Amendment#4(Ordinance#6837)
Beg.Fund 2022 2022 Ending Fund
Balance Revenues Expenditures Balance
Facilities Fund(#505)
2022 Adopted Budget 623,845 3,694,500 3,724,226 5941119
BA#4(Ordinance#6837,Proposed): (46,261) (67,800) 112,000 (226,061)
Ongoing operating budget for Auburn Consolidated Resource Center);BA#21 - 2,700 - 2,700
Move lease revenues from Facilities to General Fund);BA#3) - (108,000) - (108,000)
Add lease revenue for Game Farm Park - 37,500 - 37,500
Adjust beginning fund balance for budget amendments in 2021 (46,261) - - (46,261)
Contracted security for City Hall,Annex,and Les Gove campus(BA#3j - - 112,000 (112,000)
Revised 2022 Budget-Fund 505 577,584 3,626,700 3,836,226 368,058
Innovation&Technology Fund(#518)
2022 Adopted Budget 1,949,637 6,903,800 7,014,444 1,838,993
BA#4(Ordinance#6837,Proposed): 126,252 6,000 6,000 126,252
Adjust beginning fund balance for budget amendments in 2021 126,252 - - 126,252
Continue Limited Term Employee(LTE): Grants Coordinator(ARPA funded) [BA#31 - 3,000 3,000
New Full-Time Employee(FTE): Outreach Coordinator - 3,000 3,000 -
Revised 2022 Budget-Fund 518 2,075,889 6,909,800 7,020,444 1,965,245
Equipment Rental Fund(#550)
2022 Adopted Budget 1,552,779 2,301,100 3,079,708 774,171
BA#4(Ordinance#6837,Proposed): 227,114 - 25,700 201,414
Ongoing cost of new FTE in M&O Division—Administrative Specialist (13A#21 - 25,700 (25,7001
Adjust beginning fund balance for budget amendments in 2021 227,114 - - 2271114
Revised 2022 Budget-Fund 550 1,779,893 2,301,100 3,105,408 975,585
Equipment Rental Capital Fund(#560)
2022 Adopted Budget 3,902,729 1,993,760 1,435,600 4,460,889
BA#4(Ordinance#6837,Proposed): (1,059,460) 72,700 72,700 (1,059,460)
Adjust beginning fund balance for budget amendments in 2021 (1,059,460) - - (1,059,460)
Provide in-house litter crew to replace Waste Management crew(incl two FTEs) - 72,700 72,700 -
Revised 2022 Budget-Fund 560 2,843,269 2,066,460 1,508,300 3,401,429
Page 11 of 12 11/4/2021 6:57AM
Schedule A
Summary of 2022 Budget Adjustments by Fund
Budget Amendment#4(Ordinance#6837)
Beg.Fund 2022 2022 Ending Fund
Balance Revenues Expenditures Balance
IT Capital Fund(#568)
2022 Adopted Budget 635,814 3,400 414,200 225,014
BA#4(Ordinance#6837,Proposed): (135,461) - - (135,461)
Adjust beginning_fund balance for budget amendments in 2021 (135,461) - - (135,461).
Revised 2022 Budget-Fund 568 500,353 3,400 414,200 89,553
Fire Pension Fund(#611)
2022 Adopted Budget 1,926,737 103,600 211,204 1,819,133
BA#4(Ordinance#6837,Proposed): 55,039 - - 55,039
Adjust beginning fund balance for budget amendments in 2021 55,039 - 55,039
Revised 2022 Budget-Fund 611 1,981,776 103,600 211,204 1,874,172
SKHHP Fund(#654)
2022 Adopted Budget 186,885 252,300 315,450 123,735
BA#4(Ordinance#6764,Proposed): 38,028 24,225 25,400 36,853
Adjust beginning_fund balanGe for budget amendments in 2021 38,028 38,028
Adjust SKHHP budget to reflect adopted 2022 budget - 24,225 25,400 (1,175)
Revised 2022 Budget-Fund 654 .. 224,913 276,525 340,850 160,588
Cemetery Endowment Fund(#701)
2022 Adopted Budget 2,046,766 64,130 - 2,110,896
BA#4(Ordinance#6837,Proposed): 39,116 - 39116.
Adjust beginning fund balance for budget amendments in 2021 39,116 - - 39,116
Revised 2022 Budget-Fund 701 2,085,882 64,130 - 2,150,012
Grand Total-All Funds
2022 Adopted Budget 109,651,771 216,957,920 237,525,025 89,084,666
TOTAL BA#4(Ordinance#6837,Proposed): 18,764,712 1,529,725 7,424,350 12,870,087
Revised 2022 Budget 128,416,483 218,487,645 244,949,375 101,954,753
346,904,128 346,904,128
Page 12 of 12 11/4/2021 6:57AM
Schedule B
2022 Ending Fund Balance/Working Capital
by Fund
2022
Adopted BA#4 Revised
Fund Budget (Ord #6837) Budget
General Fund (#001) 6,858,019 4,006,548 10,864,567
Arterial Street Fund(#102) 313,209 (70,179) 243,030
Local Street Fund(#103) 1,314,428 709,525 2,023,953
Hotel/Motel Tax Fund (#104) 179,066 90,521 269,587
Arterial Street Preservation Fund(#105) 1,437,904 (71,451) 1,366,453
American Rescue Plan Act Fund (#106) - 3,446,700 3,446,700
Drug Forfeiture Fund (#117) 404,042 (53,266) 350,776
Housing &Comm Develop Fund(#119) 42,904 (579) 42,325
Recreation Trails Fund (#120) 94,825 2,287 97,112
BIA Fund (#121) 27,425 73,070 100,495
Cumulative Reserve Fund (#122) 4,614,315 4,196,829 8,811,144
Mitigation Fees Fund (#124) 4,683,092 (1,176,597) 3,506,495
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
SCORE Debt Service Fund(#238) - - -
LID Guarantee Fund(#249) 1,689 7 1,696
LID 350 Fund(#275) 1,373 794 2,167
Golf/Cemetery 2016 Refunding Fund(#276) - - -
Parks Construction Fund(#321) 785,896 (177,301) 608,595
Capital Improvements Fund(#328) 3,458,004 2,627,711 6,085,715
Local Revitalization Fund (#330) - - -
Water Fund (#430) 7,201,880 821,882 8,023,762
Sewer Fund (#431) 10,672,270 (1,263,384) 9,408,886
Storm Drainage Fund (#432) 11,931,710 243,861 12,175,571
Sewer Metro Sub Fund (#433) 2,074,736 771,586 2,846,322
Solid Waste Fund(#434) 5,488,208 (962,501) 4,525,707
Airport Fund (#435) 237,034 673,375 910,409
Cemetery Fund (#436) 258,934 437,117 696,051
Water Capital Fund(#460) 2,816,839 (257,156) 2,559,683
Sewer Capital Fund (#461) 5,064,857 (395,750) 4,669,107
Storm Drainage Capital Fund (#462) 2,624,135 (861,619) 1,762,516
Airport Capital Fund (#465) 196,137 140,783 336,920
Cemetery Capital Fund (#466) 10,583 43,597 54,180
Insurance Fund(#501) 1,400,053 18,262 1,418,315
Workers'Comp Fund(#503) 2,905,527 58,098 2,963,625
Facilities Fund(#505) 594,119 (226,061) 368,058
Innovation&Technology Fund (#518) 1,838,993 126,252 1,965,245
Equipment Rental Fund(#550) 774,171 201,414 975,585
Equipment Rental Capital Fund(#560) 4,460,889 (1,059,460) 3,401,429
IT Capital Fund(#568) 225,014 (135,461) 89,553
Fire Pension Fund (#611) 1,819,133 55,039 1,874,172
SKHHP Fund(#654) 123,735 36,853 160,588
Cemetery Endowment Fund(#701) 2,110,896 39,116 2,150,012
Total 89,084,666 12,870,087 101,954,753