HomeMy WebLinkAboutItem 04 FY23 Supplemental Budget 2AGENDA ITEM SUMMARY
Meeting Date:
Meeting Type:
Staff Contact/Dept.:
Staff Phone No:
Estimated Time:
2/21/2023
Regular Meeting
Neil Obringer/Finance
541.736.1032
10 Minutes
SPRINGFIELD Council Goals: Provide Financially
CITY COUNCIL Responsible and
Innovative Government
Services
ITEM TITLE: FY23 SUPPLEMENTAL BUDGET 2 & APPROPRIATIONS TRANSFER
Conduct a public hearing and adopt/not adopt the following resolutions:
ACTION
REQUESTED: A RESOLUTION ADJUSTING RESOURCES AND REQUIREMENTS IN THE
FOLLOWING FUNDS; GENERAL, SPECIAL REVENUE, COMMUNITY
DEVELOPMENT, FIRE LOCAL OPTION LEVY, REGIONAL WASTEWATER
CAPITAL, STREET CAPITAL, REGIONAL WASTEWATER, AMBULANCE,
STORM DRAINAGE OPERATIONS, VEHICLE & EQUIPMENT; AND
AUTHORIZING THE TRANSFER OF APPROPRIATIONS WITHIN THE
REGIONAL WASTEWATER CAPITAL PROJECTS FUND FROM
OPERATING EXPENSE TO CAPITAL EXPENSE, AND FROM GENERAL
FUND CONTINGENCY EXPENSE TO FIRE AND LIFE SAFETY OPERATING
EXPENSE, AND FROM FIRE LOCAL OPTION LEVY FUND CONTINGENCY
EXPENSE TO FIRE AND LIFE SAFETY OPERATING EXPENSE, AND FROM
AMBULANCE FUND CONTINGENCY EXPENSE TO FIRE AND LIFE
SAFETY OPERATING EXPENSE.
Additionally, there are several transfers between existing appropriation categories.
These transfers include: $87,334 from General Fund Contingency to Fire and Life
Safety Operating Expense, $12,736 from Fire Local Option Levy Fund
Contingency to Fire and Life Safety Operating Expense, $30,930 from Ambulance
Fund Contingency to Fire and Life Safety Operating Expense, and $55,000 from
Regional Wastewater Capital Projects Fund Operating Expense to Capital Expense.
At various times during the fiscal year, the Council is requested to adjust the annual
ISSUE
budget to reflect needed changes in planned activities, to recognize new revenues,
STATEMENT:
or to make other required changes. These adjustments to resources and
requirements change the current budget and are processed through supplemental
budget requests scheduled by the Finance Department. This is the second of three
FY23 supplemental budget requests to come before Council.
The City Council is asked to approve the attached Supplemental Budget Resolution.
1. Council Briefing Memorandum
ATTACHMENTS:
2. Supplemental Budget Resolution and Exhibit A
The overall financial impact of the Supplemental Budget Resolution is to increase
DISCUSSION/
department Operating Expenditures by $2,186,119, Capital Expenditures by
FINANCIAL
$20,375,223, and Interfund Transfer Expense by $401,339. These are offset by new
IMPACT:
revenue of $1,381,201, and a reduction in Reserves of $21,581,480.
Additionally, there are several transfers between existing appropriation categories.
These transfers include: $87,334 from General Fund Contingency to Fire and Life
Safety Operating Expense, $12,736 from Fire Local Option Levy Fund
Contingency to Fire and Life Safety Operating Expense, $30,930 from Ambulance
Fund Contingency to Fire and Life Safety Operating Expense, and $55,000 from
Regional Wastewater Capital Projects Fund Operating Expense to Capital Expense.
MEMORANDUM City of Springfield
Date: 2/21/2023
To: Nancy Newton, City Manager COUNCIL
From: Nathan Bell, Finance Director BRIEFING
Neil Obringer, Budget & Procurement Manager
Subject: FY23 SUPPLEMENTAL BUDGET 2 MEMORANDUM
ISSUE:
At various times during the fiscal year, the Council is requested to adjust the annual budget to
reflect needed changes in planned activities, to recognize new revenues, or to make other required
changes. These adjustments to resources and requirements change the current budget and are
processed through supplemental budget requests scheduled by the Finance Department. This is the
second of three FY23 supplemental budget requests to come before Council.
The City Council is asked to approve the attached Supplemental Budget Resolution.
COUNCIL GOALS/
MANDATE:
Financially Responsible and Stable Government Services
BACKGROUND:
Supplemental budgets may be used to meet unexpected needs or to spend revenues not anticipated at
the time the original budget was adopted. In accordance with Oregon budget law, notification of this
supplemental budget and a hearing is made no later than five calendar days before the public meeting.
A public hearing is only required when a supplemental budget request changes total appropriations
within a fund by 10% or greater. Notification of this public hearing was published in the Creswell
Chronicle at least five days prior to the public hearing. The attached information identifies the
individual items that are included in the February 21 st, 2023 Supplemental Budget request.
Summary of Proposed Changes by Fund:
General Fund 100
• Increase Development & Public Works Department operating expense by $65,000, offset by
a reduction in General Fund reserves, to support three priority projects: repaint/repair stucco
on the exterior of the Emerald Art Center, hire real estate broker to find land for affordable
housing, and site preparation for future development. These projects were originally funded
using resources from the CDBG program, however, after additional scoping, it has been
determined that requirements related to the use of federal funding make these small dollar
projects more efficient to fund with non-federal resources.
• Increase Eugene -Springfield Fire and Life Safety operating expense by $131,000, offset by a
reduction in General Fund contingency, to account for additional anticipated overtime related
to an added Kelly Day which was agreed to through bargaining with the International
Association of Fire Fighters (IAFF). Kelly Days are a type of paid time off and typically
result in additional overtime expense to ensure minimum coverage requirements are met.
• Increase City Attorney's Office operating expense by $100,000 to support appeal of the
Climate -Friendly and Equitable Communities (CFEC) rules. On December 29, 2022, the
Court of Appeals ordered on its own motion to expedite the timeline for briefing and
deciding the appeal. Legal costs that were expected to accrue in the next fiscal year (FY23-
24) will now be expended during the current fiscal year (FY22-23) to meet the Court's
expedited timeline. Springfield's portion of the total litigation and joint communications costs
is less than 15%, so 85% of the expenditures are expected to be recovered as revenue from
FY23 Supplemental Budget 2 Attachment 1 Page 1 of 3
other members of the local government coalition.
Increase Development & Public Works Department operating expense by $412,223 in the
Street Capital Fund through a transfer of $401,339 from the General Fund and the use of
$10,884 in Street SDC reserves. These appropriations allow for the purchase of the property
located at 3697 Franklin Blvd which is intended to provide land necessary for a future phase
of Franklin Blvd. development. It was not foreseen that the property would be available for
City purchase at the time of the original budget preparation, and the conditions of a potential
sale were unknown at the time of the prior supplemental budget. The General Fund portion
of this expenditure is offset by revenues from the sale of City owned property at S. 57th
Street. The Street Capital portion of this expenditure is offset through a reduction in System
Development Charge reserves.
Special Revenue Fund 204
• Increase Development & Public Works Department operating expense by $127,500 to
support customer service enhancements to the Accela permitting software. This request is
funded through a reduction in technology fee reserve. A change in department leadership has
resulted in staff re-evaluating the approach to customer service enhancements, shifting to the
use of vendor supported solutions for these enhancements.
• Recognize $250,000 in grant revenue from the State of Oregon to support voluntary trash and
sanitation services. These resources will be used to increase the Police department operating
budget by $100,000 to support an RV disposal program and to increase the Development and
Public Works Department operating budget $150,000 to provide dumpsters/vouchers for
homes identified as having code enforcement violations.
• Recognize $147,120 in grant revenuve from the Department of Justice and increase Police
Department operating expense to support costs related to the department's goal of becoming
an accredited law enforcement agency.
Regional Wastewater Capital Fund 433
Increase Development & Public Works Department capital expense by $20,103,000 to
support several projects approved by the MWMC Commission. Projects include large scale
work involving the switchgears and transformers at the plant, two vehicle purchases, and
replacement of the HVAC system in the MWMC construction trailer. These increases to
expense are offset through a corresponding decrease to the equipment replacement reserve by
$55,000 and the capital project reserve by $19,963,000.
Ambulance Fund 615
Recognize $80,582 in unanticipated revenue from medic standby staffing at special events
and increase Fire and Life Safety operating expense to offset overtime costs associated with
these events.
Recognize $98,607 in unanticipated revenue from an Assistance to Firefighters grant and
increase Fire & Life Safety operating expense by $98,607 to purchase six LUCAS chest
compression systems for Springfield EMS Operations.
FY23 Supplemental Budget 2 Attachment 1 Page 2 of 3
RECOMMENDED ACTION:
Conduct a public hearing and adopt/not adopt the following resolutions:
A RESOLUTION ADJUSTING RESOURCES AND REQUIREMENTS IN THE FOLLOWING
FUNDS; GENERAL, SPECIAL REVENUE, COMMUNITY DEVELOPMENT, FIRE LOCAL
OPTION LEVY, REGIONAL WASTEWATER CAPITAL, STREET CAPITAL, REGIONAL
WASTEWATER, AMBULANCE, STORM DRAINAGE OPERATIONS, VEHICLE &
EQUIPMENT; AND AUTHORIZING THE TRANSFER OF APPROPRIATIONS WITHIN THE
REGIONAL WASTEWATER CAPITAL PROJECTS FUND FROM OPERATING EXPENSE
TO CAPITAL EXPENSE, AND FROM GENERAL FUND CONTINGENCY EXPENSE TO
FIRE AND LIFE SAFETY OPERATING EXPENSE, AND FROM FIRE LOCAL OPTION
LEVY FUND CONTINGENCY EXPENSE TO FIRE AND LIFE SAFETY OPERATING
EXPENSE, AND FROM AMBULANCE FUND CONTINGENCY EXPENSE TO FIRE AND
LIFE SAFETY OPERATING EXPENSE.
FY23 Supplemental Budget 2 Attachment 1 Page 3 of 3
CITY OF SPRINGFIELD, OREGON
RESOLUTION NO.
SUPPLEMENTAL BUDGET #2 AND APPROPRIATIONS TRANSFER
A RESOLUTION ADJUSTING RESOURCES AND REQUIREMENTS IN THE FOLLOWING
FUNDS; GENERAL, SPECIAL REVENUE, COMMUNITY DEVELOPMENT, FIRE LOCAL OPTION
LEVY, REGIONAL WASTEWATER CAPITAL, STREET CAPITAL, REGIONAL WASTEWATER,
AMBULANCE, STORM DRAINAGE OPERATIONS, VEHICLE & EQUIPMENT; AND
AUTHORIZING THE TRANSFER OF APPROPRIATIONS WITHIN THE REGIONAL
WASTEWATER CAPITAL PROJECTS FUND FROM OPERATING EXPENSE TO CAPITAL
EXPENSE, AND FROM GENERAL FUND CONTINGENCY EXPENSE TO FIRE AND LIFE SAFETY
OPERATING EXPENSE, AND FROM FIRE LOCAL OPTION LEVY FUND CONTINGENCY
EXPENSE TO FIRE AND LIFE SAFETY OPERATING EXPENSE, AND FROM AMBULANCE FUND
CONTINGENCY EXPENSE TO FIRE AND LIFE SAFETY OPERATING EXPENSE.
WHEREAS, the Common Council has adopted the budget and made appropriations for Fiscal Year
2022-2023 through Resolution No. 2022-25 adopted June 20, 2022 and as amended by Resolution
2022-35 adopted October 17, 2022.
WHEREAS, ORS 294.471(1)(a), (b) and (c) permit a supplemental budget due to an occurrence or
condition that was not known at the time the budget was prepared that requires a change in financial
planning; due to a pressing necessity that creates a need for prompt action, that was not reasonably
foreseen when preparing the original budget; or to budget funds that are made available by another
unit of federal, state, or local government, which funds were not reasonably foreseen when preparing
the original budget;
WHEREAS, the Common Council is requested to make adjustments to the Fiscal Year 2022-2023
budget and appropriations to meet unexpected needs and to allow appropriations of new revenues
pursuant to ORS 294.471(1)(a), (b) and (c) as justified in Exhibit A, which is attached and incorporated
by reference;
WHEREAS, ORS 294.463 allows transfers of appropriations within a fund when authorized by
ordinance or resolution of the governing body, stating the need for the transfer, the purpose of the
authorized expenditure, and the amount transferred;
WHEREAS, this supplemental budget and adjustments to appropriations are being presented at a
public hearing at which the public may comment on such requests; and
WHEREAS, notice of a public hearing, including information regarding such revenues and
expenditures was published in a newspaper of general circulation not less than 5 days prior to the
public meeting,
NOW, THEREFORE, BE IT RESOLVED BY THE COMMON COUNCIL OF THE CITY OF SPRINGFIELD:
Section 1: The Fiscal Year 2022-2023 budget and appropriations, as adopted by Resolution
No. 2022-25 hereby adjusted as provided in Exhibit A.
Section 2: This Resolution will take effect upon adoption by the Council.
ADOPTED by the Common Council of the City of Springfield this _ day of ,
by a vote of for and against.
ATTEST:
City Recorder
General Fund - 100
Department Operating
City Manager's Office
Development & Public Works
Finance
Fire and Life Safety
Human Resources
Information Technology
Legal Services
Library
Police
Total Department Operating
Non -Departmental
Transfers
Contingency
Reserves*
Total Non -Departmental
Total General Fund
Exhibit A Page 1 of 9
EXHIBIT A
FY2022-23
SUPPLEMENTAL BUDGET AND APPROPRIATIONS TRANSFER
Appropriations
FY23 Supplemental Supplemental Transfers & FY23
Adopted Budget Budget 1 Budget 2 Adjustments Revised Budget
$ 1,599,228 $ 82,293 $ - $ (1,000) $ 1,680,521
3,105,437 - 65,000 3,170,437 (1)
2,595,074 - - 2,595,074
12,589,148 10,350 21,078 87,334 12,707,910 (2,3)
750,152 - - - 750,152
1,856,407 - - 1,856,407
887,735 100,000 100,000 1,087,735 (4)
2,062,570 12,420 - 2,074,990
17,336,526 - - 17,336,526
42,782,276 205,063 186,078 86,334 43,2599751
852,378 - 401,339 1,000 1,254,717 (5)
1,000,000 - - (87,334) 912,666 (3)
8,664,351 (189,689) (466,339) - 8,008,323 (1,5)
10,516,729 (189,689) (65,000) (86,334) 10,1759706
$ 53,299,005 $ 15,374 $ 1219078 $ - $ 5394359457
General Fund Commentary:
1.) Increase Development & Public Works Department operating expense by $65,000, offset by a reduction in General Fund reserves, to support three
priority projects: repaint/repair stucco on the exterior of the Emerald Art Center, hire real estate broker to find land for affordable housing, and site
preparation for future development. These projects were originally funded using resources from the CDBG program, however, after additional scoping it
was determined that requirements related to the use of federal funding make these small dollar projects more efficient to fund with non-federal resources.
2.) Increase Eugene -Springfield Fire and Life Safety operating expense by $21,078 in the General Fund, $8,917 in the Fire Local Option Levy Fund, and
$15,249 in the Ambulance Fund in response to Conflagration reimbursement for Fire personnel. This operating expense increase is offset by
corresponding revenue for conflagration deployments which happened between 7/1/22-10/31/22 resulting in the revenue being recieved after supplemental
budget 1.
3.) Increase Eugene -Springfield Fire and Life Safety operating expense by $131,000, offset by a reduction in General Fund contingency ($87,334), Fire
Levy Fund contingency ($12,736), and Ambulance Fund contingency ($30,930), to account for additional overtime related to an added Kelly Day which
was agreed to through bargaining with the International Association of Fire Fighters (IAFF). Originally, it was the intent for FLS to absorb this additional
cost in FY23, however, it now is apparent that these additional costs cannot be absorbed and are being requested through this supplememal budget.
4.) Increase City Attorney's Office operating expense by $100,000 to support appeal of the Climate -Friendly and Equitable Communities (CFEC) rules. On
December 29, 2022, the Court of Appeals ordered on its own motion to expedite the timeline for briefing and deciding the appeal. Legal costs that were
expected to accrue in the next fiscal year (FY23-24) will now be expended during the current fiscal year (FY22-23), to meet the Court's expedited
timeline. This need was not accertained during the development of Supplemental Budget 1. Springfield's portion of the total litigation and joint
communications costs is less than 15%, so 85% of the expendiatures are expected to be recovered as revenue from other members of the local government
coalition.
5.) Increase Development & Public Works Department operating expense by $412,223 in the Street Capital Fund through a transfer of $401,339 from the
General Fund and $10,884 from street SDC's. These appropriations allow for the purchase of property located at 3697 Franklin Blvd which is intended to
provide land necessary for a future phase of Franklin Boulevard development. It was not foreseen that the property would be available for City purchase at
the time of the original budget preparation, and the conditions of a potential sale were unknown at the time of the prior supplemental budget. The General
Fund portion of this expenditure is offset by revenues from the sale of City owned property at S. 57th Street. The Street Capital portion of this expenditure
is offset through a reduction in System Development Charge reserves.
Exhibit A Page 2 of 9
Total Development & Public Works Capital Projects
40,000 - 40,000
Non -Departmental
Reserves* 4,325,763 3,161,253 (608,224) 6,878,792 (1,3,7)
Total Non -Departmental 4,325,763 3,161,253 (608,224) - 6,878,792
Total Special Revenue Fund $ 11,184,722 $ 12,106,425 $ (9,717) $ 1,000 $ 23,282,430
Special Revenue Fund Commentary:
1.) Increase Development & Public Works Department operating expense by $127,500 to support customer service enhancements for the Accela
permitting software. This request is funded through a reduction in technology fee reserve. A change in department leadership has resulted in staff re-
evaluating the approach to customer service enhancements, shifting to the use of vendor supported solutions for this work. This change in scope was not
identified until after SB 1 of FY23.
2.) Recognize $250,000 in grant revenue, the availability of which was not known during the development of the adopted budget, from the State of Oregon
to support voluntary trash and sanitation services. These resources will be used to increase the Police department operating budget by $100,000 to support
an RV disposal program, and to increase the Development and Public Works Department operating budget $150,000 to provide dumpsters/vouchers for
homes identified as having code enforcement violations. The plan for how to utilize these resources was not developed until after SB 1 of FY23 so is being
included in this supplemental budget.
3.) Increase Eugene -Springfield Fire and Life Safety operating expense by $35,724 to support the purchase of vehicles and office furniture using funds
from the American Recovery Plan Reserve (ARPA). The department has added two new positions (Fire Life Safety Inspector and Fire Marshall), and the
request is for the vehicle and office equipment for these positions. Approval for the use of ABPA funds for these costs was not provided until after SB 1 so
are being included in this supplemental budget.
4.) Recognize new grant revenue and increase Library operating expense by $27,032 to support library remodel shelving, programming at the Library,
replacement of self check out machines, and the For Every Student a Library program.
5.) Increase Library operating expense by $11,131 in order to recognize donation revenue not anticipated during development of the adopted budget. The
increased appropriations will support the museum through a limited duration position, the purchase of a new printer and program costs.
6.) Recognize $147,120 in grant revenuve, from the Department of Justice, awarded in October 2022, and increase Police Department operating expense
to support costs related to the department's goal of becoming an accredited law enforcement agency.
7.) Decrease $445,000 in both reserves and revenue to adjust for the duplicated resources. HB5006 CSFRF award for mobile home park preservation was
received and budgeted in late FY22. Due to unknown timing of disbursal of funds, budget was also included in the FY23 budget adoption.
Appropriations
FY23
Supplemental
Supplemental
Transfers &
FY23
Street Fund - 201
Adopted Budget
Budget 1
Budget 1
Adjustments
Revised Budget
Department Operating
City Manager's Office
$ 57,912
$
$
$
$ 57,912
Development & Public Works
6,951,767
6,951,767
Finance
68,156
68,156
Total Department Operating
7,077,835
-
7,077,835
Non -Departmental
Transfers
150,000
150,000
Contingency
200,000
200,000
Reserves*
2,167,503
6,972
2,174,475
Total Non -Departmental
2,517,503
6,972
-
2,524,475
Total Street Fund
$ 9,595,338
$ 6,972
$
$ -
$ 9,602,310
Street Fund Commentary:
- No current activity.
Appropriations
FY23
Supplemental
Supplemental
Transfers &
FY23
Special Revenue Fund - 204
Adopted Budget
Budget 1
Budget 2
Adiustments
Revised Budget
Department Operating
City Manager's Office
$ 273,934
$ 29,976
$ -
$ 1,000
$ 304,910
Development & Public Works
5,534,827
6,815,262
277,500
-
12,627,589
(1,2)
Finance
14,000
1,000,000
-
1,014,000
Fire and Life Safety
270,508
630,000
35,724
936,232
(3)
Human Resources
103,622
-
-
103,622
Information Technology
143,889
-
-
143,889
Library
125,180
141,740
38,163
305,083
(4,5)
Police
393,000
288,194
247,120
928,314
(2,6)
Total Department Operating
6,8589959
899059172
5989507
1,000
16,3639638
Total Development & Public Works Capital Projects
40,000 - 40,000
Non -Departmental
Reserves* 4,325,763 3,161,253 (608,224) 6,878,792 (1,3,7)
Total Non -Departmental 4,325,763 3,161,253 (608,224) - 6,878,792
Total Special Revenue Fund $ 11,184,722 $ 12,106,425 $ (9,717) $ 1,000 $ 23,282,430
Special Revenue Fund Commentary:
1.) Increase Development & Public Works Department operating expense by $127,500 to support customer service enhancements for the Accela
permitting software. This request is funded through a reduction in technology fee reserve. A change in department leadership has resulted in staff re-
evaluating the approach to customer service enhancements, shifting to the use of vendor supported solutions for this work. This change in scope was not
identified until after SB 1 of FY23.
2.) Recognize $250,000 in grant revenue, the availability of which was not known during the development of the adopted budget, from the State of Oregon
to support voluntary trash and sanitation services. These resources will be used to increase the Police department operating budget by $100,000 to support
an RV disposal program, and to increase the Development and Public Works Department operating budget $150,000 to provide dumpsters/vouchers for
homes identified as having code enforcement violations. The plan for how to utilize these resources was not developed until after SB 1 of FY23 so is being
included in this supplemental budget.
3.) Increase Eugene -Springfield Fire and Life Safety operating expense by $35,724 to support the purchase of vehicles and office furniture using funds
from the American Recovery Plan Reserve (ARPA). The department has added two new positions (Fire Life Safety Inspector and Fire Marshall), and the
request is for the vehicle and office equipment for these positions. Approval for the use of ABPA funds for these costs was not provided until after SB 1 so
are being included in this supplemental budget.
4.) Recognize new grant revenue and increase Library operating expense by $27,032 to support library remodel shelving, programming at the Library,
replacement of self check out machines, and the For Every Student a Library program.
5.) Increase Library operating expense by $11,131 in order to recognize donation revenue not anticipated during development of the adopted budget. The
increased appropriations will support the museum through a limited duration position, the purchase of a new printer and program costs.
6.) Recognize $147,120 in grant revenuve, from the Department of Justice, awarded in October 2022, and increase Police Department operating expense
to support costs related to the department's goal of becoming an accredited law enforcement agency.
7.) Decrease $445,000 in both reserves and revenue to adjust for the duplicated resources. HB5006 CSFRF award for mobile home park preservation was
received and budgeted in late FY22. Due to unknown timing of disbursal of funds, budget was also included in the FY23 budget adoption.
Exhibit A Page 3 of 9
Non -Departmental
Transfers
Reserves*
Total Non -Departmental
Total Transient Room Tax Fund
Transient Room Tax Fund Commentary:
- No current activity.
Community Development Fund - 210
Department Operating
Development & Public Works
Finance
Total Department Operating
Non -Departmental
Reserves*
Total Non -Departmental
Total Community Development Fund
944,444 - 944,444
1,772,561 240,730 2,013,291
2,717,005 240,730 2,957,735
$ 3,241,862 $ 248,267 $ $ $ 3,490,129
Appropriations
FY23 Supplemental Supplemental Transfers & FY23
Adopted Budget Budget 1 Budget 2 Adiustments Revised Budget
$ 1,321,783 $ $ 665,146 $ $ 1,986,929 (1)
26,041 - 26,041
1,347,824 665,146 - 290129970
6,991 199,652 - 206,643
6,991 199,652 206,643
$ 1,354,815 $ 199,652 $ 665,146 $ $ 2,219,613
Community Development Fund Commentary:
1.) At the time of budget adoption the total available for CDBG programs was not certain, this request aligns budget with available resources and the
approved action plan for FY23. This includes carrying forward $665,146 in revenue from the prior year to support several CDBG projects.
Appropriations
FY23
Supplemental Supplemental Transfers &
FY23
Transient Room Tax Fund - 208
Adopted Budget
Budaet 1 Budget 2 Adjustments
Revised Budget
Department Operating
City Manager's Office
$ 242,212
$ $ $
$ 242,212
Development & Public Works
32,874
32,874
Library
249,771
7,537
257,308
Total Department Operating
524,857
7,537 -
532,394
Non -Departmental
Transfers
Reserves*
Total Non -Departmental
Total Transient Room Tax Fund
Transient Room Tax Fund Commentary:
- No current activity.
Community Development Fund - 210
Department Operating
Development & Public Works
Finance
Total Department Operating
Non -Departmental
Reserves*
Total Non -Departmental
Total Community Development Fund
944,444 - 944,444
1,772,561 240,730 2,013,291
2,717,005 240,730 2,957,735
$ 3,241,862 $ 248,267 $ $ $ 3,490,129
Appropriations
FY23 Supplemental Supplemental Transfers & FY23
Adopted Budget Budget 1 Budget 2 Adiustments Revised Budget
$ 1,321,783 $ $ 665,146 $ $ 1,986,929 (1)
26,041 - 26,041
1,347,824 665,146 - 290129970
6,991 199,652 - 206,643
6,991 199,652 206,643
$ 1,354,815 $ 199,652 $ 665,146 $ $ 2,219,613
Community Development Fund Commentary:
1.) At the time of budget adoption the total available for CDBG programs was not certain, this request aligns budget with available resources and the
approved action plan for FY23. This includes carrying forward $665,146 in revenue from the prior year to support several CDBG projects.
Building Code Fund Commentary:
- No current activity.
Appropriations
FY23
Supplemental Supplemental Transfers &
FY23
Building Code Fund - 224
Adopted Budget
Budget 1 Budget 2 Adiustments
Revised Budget
Department Operating
City Manager's Office
$ 22,647
$ $ $
$ 22,647
Development & Public Works
1,396,226
1,396,226
Fire & Life Safety
84,213
84,213
Total Department Operating
1,503,087
-
1,503,087
Non -Departmental
Contingency
35,000
35,000
Reserves*
3,680,726
312,548
3,993,274
Total Non -Departmental
3,715,726
312,548 -
4,028,274
Total Building Fund
$ 5,218,813
$ 312,548 $ $
$ 5,531,361
Building Code Fund Commentary:
- No current activity.
Exhibit A Page 4 of 9
Non -Departmental
Contingency 45000 - (12,736) 32,264 (2)
Reserves* 1,639,130 27,207 1,666,337
Total Non -Departmental 1,684,130 27,207 (12,736) 1,698,601
Total Fire Local Option Levy Fund $ 3,331,225 $ 27,207 $ 8,917 $ - $ 3,367,349
Fire Local Option Levy Fund Commentary:
1.) See General Fund Commentary #2.
2.) See General Fund Commentary #3.
Appropriations
Appropriations
FY23
FY23
Supplemental Supplemental
Transfers &
FY23
Fire Local Option Levy Fund - 235
Adopted Budget
Budaet 1 Budget 2
Adiustments
Revised Budget
Department Operating
Finance
$ 701,355
$ $ $
$ 701,355
Fire and Life Safety
$ 1,647,095
$ $ 8,917
$ 12,736
$ 1,668,748 (1,2)
Total Department Operating
1,647,095
8,917
12,736
1,668,748
Non -Departmental
Contingency 45000 - (12,736) 32,264 (2)
Reserves* 1,639,130 27,207 1,666,337
Total Non -Departmental 1,684,130 27,207 (12,736) 1,698,601
Total Fire Local Option Levy Fund $ 3,331,225 $ 27,207 $ 8,917 $ - $ 3,367,349
Fire Local Option Levy Fund Commentary:
1.) See General Fund Commentary #2.
2.) See General Fund Commentary #3.
Police Local Option Levy Fund Commentary:
- No current activity.
Appropriations
FY23
Supplemental Supplemental Transfers &
FY23
Police Local Option Levy Fund - 236
Adopted Budeet
Budget 1 Budget 1 Adiustments
Revised Budget
Department Operating
Finance
$ 701,355
$ $ $
$ 701,355
Legal Services
89,700
31,656
89,700
Police
7,134,929
492,000
7,626,929
Total Department Operating
7,925,984
4929000 -
894179984
Non -Departmental
Contingency
150,000
-
150,000
Reserves*
2,104,665
56,373
2,161,038
Total Non -Departmental
2,2549665
56,373
2,3119038
Total Police Local Option Levy Fund
$ 109180,649
$ 548,373 $ $ -
$ 10,729,022
Police Local Option Levy Fund Commentary:
- No current activity.
Total Bond Sinking Fund $ 4,442,338 $ 31,656 $ - $ - $ 4,473,994
Bond Sinking Fund Commentary:
- No current activity.
Appropriations
FY23
Supplemental Supplemental Transfers &
FY23
Bond Sinking Fund - 306
Adopted Budget
Budget 1 Budget 2 Adiustments
Revised Budget
Non -Departmental
Debt Service
$ 4,016,880
$ - $ $
$ 4,016,880
Unappropriated Ending Fund Balance*
425,458
31,656
457,114
Total Non -Departmental
4,442,338
31,656
4,473,994
Total Bond Sinking Fund $ 4,442,338 $ 31,656 $ - $ - $ 4,473,994
Bond Sinking Fund Commentary:
- No current activity.
Development Assessment Fund Commentary:
- No current activity.
Appropriations
FY23
Supplemental Supplemental Transfers &
FY23
Development Assessment Fund - 419
Adopted Budget
Budget 1 Budget 2 Adjustments
Revised Budget
Non -Departmental
Reserves*
$ 798,816
$ (8,308) $ $
$ 790,508
Total Non -Departmental
798,816
(8,308) -
790,508
Total Development Assessment Fund
$ 798,816
$ (8,308) $ - $ -
$ 790,508
Development Assessment Fund Commentary:
- No current activity.
Exhibit A Page 5 of 9
Appropriations
FY23 Supplemental Supplemental Transfers & FY23
Development Proiects Fund - 420 Adopted Budget Budget 1 Budget 2 Adjustments Revised Budget
Total Development & Public Works Capital Projects $ 313,812 $ - S $ - $ 313,812
Non -Departmental
Reserves*
Total Non -Departmental
Total Development Projects Fund
Development Projects Fund Commentary:
- No current activity.
Regional Wastewater Capital Fund - 433
Department Operating
Development & Public Works
Total Department Operating
3,674,469 557,162 4,231,631
3,674,469 557,162 - 4,231,631
$ 3,988,281 $ 557,162 $ - $ - $ 4,545,443
Appropriations
FY23 Supplemental Supplemental Transfers & FY23
Adopted Budget Budget 1 Budget 2 Adiustments Revised Budget
$ 3,896,000 $ 1,331,580 $ $ (55,000) $ 5,172,580 (1)
3,896,000 19331,580 (55,000) 5,1729580
Total Development & Public Works Capital Projects 30,900,000 149412,431 1999639000 55,000 65,3309431 (1)
Non -Departmental
Transfers 24,744 24,744
Reserves* 62,722,029 (9,277,729) (19,963,000) 33,481,300 (1)
Total Non -Departmental 62,746,773 (9,277,729) (19,963,000) - 33,5069044
Total Regional Wastewater Capital Fund $ 97,542,773 $ 6,466,282 $ - $ - $ 1049009,055
Regional Wastewater Capital Fund Commentary:
1.) Increase Development & Public Works Department capital expense by $20,018,000 to support two projects approved by the MWMC Commission.
Projects include large scale work involving the switchgears and transformers at the plant, and replacement of the HVAC system in the MWMC
construction trailer. These increases to expense are offset through a transfer from the equipment replacement reserve to capital project expense of $55,000,
and reduction in the capital project reserve of $19,963,000. It was known that some of the transformers needed replacement (budgeted in the FY23
budget) but it was only discovered later that more extensive work needed to be done. The HVAC for the MWMC construction trailer failed after SB 1, and
is needed to be replaced to have the heaters work.
Appropriations
FY23 Supplemental Supplemental Transfers & FY23
Street Capital Fund - 434 Adopted Budget Budget 1 Budget 2 Adiustments Revised Budget
Department Operating
Development & Public Works $ 137,069 $ $ $ $ 137,069
Total Department Operating 137,069 - 137,069
Total Development & Public Works Capital Projects 2,773,100 1,900,000 412,223
Non -Departmental
Reserves*
Total Non -Departmental
Total Street Capital Fund
Street Capital Fund Commentary:
1.) See General Fund Commentary #5.
7,197,612 (2,621,260) (10,884)
7,197,612 (2,621,260) (10,884)
$ 10,107,781 $ (721,260) $ 401,339 $
- 5,085,323 (1)
4,565,468 (1)
4,565,468
- $ 9,787,860
Exhibit A Page 6 of 9
Appropriations
FY23 Supplemental Supplemental Transfers & FY23
Sanitary Sewer Operations Fund - 611 Adopted Budget Budget 1 Budget 2 Adjustments Revised Budget
Department Operating
City Manager's Office $ 81,907 $ $ $ $ 81,907
Development & Public Works 5,013,493 5,013,493
Finance 61,922 61,922
Total Department Operating 5,157,322 - 5,157,322
Total Development & Public Works Capital Projects 10,421,782 - 10,421,782
Non -Departmental
Debt Service
Contingency
Reserves*
Total Non -Departmental
Total Sewer Operations Fund
Sanitary Sewer Operations Fund Commentary:
- No current activity.
Regional Wastewater Fund - 612
Department Operating
City Manager's Office
Development & Public Works
Finance
Total Department Operating
Non -Departmental
Transfers
Debt Service
Reserves*
Total Non -Departmental
Total Regional Wastewater Fund
1,708,000
150,000 -
25,632,532 874,715
27,490,532 874,715
$ 43,069,636 $ 874,715 $
1,708,000
150,000
26,507,247
28,365,247
$ - $ 43,9449351
$ 51,788,723 $ 1,420,719 $ - $ - $ 53,209,442
Regional Wastewater Fund Commentary:
1.) Increase Development & Public Works Department operating expense by $85,000 for the purchase of two vehicles, offset by a reduction in operating
reserve. The vehicles were intended to be part of the FY24 budget but with current market conditions and the difficulties in finding vehicles budget is
being requested now so that they can be purchased if suitable vehicles become available.
Appropriations
FY23
Supplemental
Supplemental Transfers &
FY23
Adopted Budget
Budget 1
Budget 2 Adjustments
Revised Budget
$ 17,222
$ -
$ - $
$ 17,222
22,115,080
100,000
85,000
22,300,080 (1)
187,593
-
-
187,593
22,319,896
100,000
85,000 -
2295049896
14,600,000
-
-
14,600,000
4,108,550
-
-
4,108,550
10,760,277
1,320,719
(85,000)
11,995,996 (1)
29,468,827
1,320,719
(85,000) -
30,704,546
$ 51,788,723 $ 1,420,719 $ - $ - $ 53,209,442
Regional Wastewater Fund Commentary:
1.) Increase Development & Public Works Department operating expense by $85,000 for the purchase of two vehicles, offset by a reduction in operating
reserve. The vehicles were intended to be part of the FY24 budget but with current market conditions and the difficulties in finding vehicles budget is
being requested now so that they can be purchased if suitable vehicles become available.
Exhibit A Page 7 of 9
Non -Departmental
Contingency
150,000
-
(58,108) 91,892 (2,4)
Appropriations
5,683
(81,152)
FY23
Supplemental
Supplemental
Transfers &
FY23
Ambulance Fund - 615
Adopted Budget
Budget 1
Budget 2
Adiustments
Revised Budget
Department Operating
City Manager's Office
$ 82,228
$ -
$ - $
Fire and Life Safety
$ 6,781,261
$ 32,600
$ 194,438
$ 58,108
$ 7,066,407 (1-4)
Total Department Operating
6,781,261
32,600
194,438
58,108
790669407
Non -Departmental
Contingency
150,000
-
(58,108) 91,892 (2,4)
Reserves*
5,683
(81,152)
- (75,469)
Total Non -Departmental
155,683
(81,152)
(58,108) 16,423
Total Ambulance Fund
$ 6,936,944
$ (48,552) $
194,438 $ - $ 7,082,830
Ambulance Fund Commentary:
1.) See General Fund Commentary #2.
2.) See General Fund Commentary #3.
3.) Recognize $80,582 in unanticipated revenue from medic standby staffing at special events and increase appropriations in the Fire and Life Safety
Department to offset overtime costs associated with these events.
4.) Recognize $98,607 in unanticipated revenue from an Assistance to Firefighters grant and increase Fire & Life Safety operating expense by $98,607 to
purchase six LUCAS chest compression systems for Springfield EMS Operations.
Non -Departmental
Contingency 200,000 200,000
Debt Service 551,718 551,718
Reserves* 17,197,422 (235,766) (35,000) 16,926,656 (1)
Total Non -Departmental 17,949,140 (235,766) (35,000) - 17,678,374
Total Drainage Operating Fund $ 32,026,934 $ 562,234 $ - $ - $ 32,589,168
Storm Drainage Operating Fund Commentary:
1.) Increase the Development & Public Works Department operating expense by $35,000 through the carryforward of funds to support purchase of a pole
building to house floodfight boxwalls and sand storage used during flood fight.
Appropriations
FY23
Supplemental
Supplemental Transfers &
FY23
Storm Drainage Operating Fund - 617
Adopted Budget
Budget 1
Budget 2 Adiustments
Revised Budget
Department Operating
City Manager's Office
$ 82,228
$ -
$ - $
$ 82,228
Development & Public Works
6,969,180
198,000
35,000
7,202,180 (1)
Finance
61,923
-
-
61,923
Total Department Operating
7,113,330
198,000
35,000 -
7,346,330
Total Development & Public Works Capital Projects
6,964,464
600,000
- -
7,564,464
Non -Departmental
Contingency 200,000 200,000
Debt Service 551,718 551,718
Reserves* 17,197,422 (235,766) (35,000) 16,926,656 (1)
Total Non -Departmental 17,949,140 (235,766) (35,000) - 17,678,374
Total Drainage Operating Fund $ 32,026,934 $ 562,234 $ - $ - $ 32,589,168
Storm Drainage Operating Fund Commentary:
1.) Increase the Development & Public Works Department operating expense by $35,000 through the carryforward of funds to support purchase of a pole
building to house floodfight boxwalls and sand storage used during flood fight.
Exhibit A Page 8 of 9
Non -Departmental
Transfers 84,237 84,237
Contingency 15,000 - 15,000
Reserves* 1,007,633 (40,366) 967,267
Total Non -Departmental 1,106,870 (40,366) 1,066,504
Total Booth -Kelly Fund $ 1,877,398 $ 259,634 $ $ $ 2,137,032
Booth -Kelly Fund Commentary:
- No current activity.
Appropriations
FY23 Supplemental Supplemental Transfers & FY23
Regional Fiber Consortium - 629 Adopted Budget Budget 1 Budget 2 Adiustments Revised Budget
Department Operating
Finance $ 252,150 $ $ $ $ 252,150
Total Department Operating 252,150 252,150
Non -Departmental
Reserves* 413,282 63,031 476,313
Total Non -Departmental 413,282 63,031 - 4769313
Total Regional Fiber Consortium Fund $ 6659432 $ 639031 $ $ - $ 7289463
Regional Fiber Consortium Commentary:
- No current activity.
Appropriations
FY23
Supplemental Supplemental Transfers &
FY23
Booth -Kelly Fund - 618
Adopted Budget
Budget 1 Budget 2 Adjustments
Revised Budget
Department Operating
City Manager's Office
$ 50,583
$ - $ $
$ 50,583
Development & Public Works
529,946
300,000
829,946
Total Department Operating
580,528
300,000
880,528
Total Development & Public Works Capital Projects
190,000
190,000
Non -Departmental
Transfers 84,237 84,237
Contingency 15,000 - 15,000
Reserves* 1,007,633 (40,366) 967,267
Total Non -Departmental 1,106,870 (40,366) 1,066,504
Total Booth -Kelly Fund $ 1,877,398 $ 259,634 $ $ $ 2,137,032
Booth -Kelly Fund Commentary:
- No current activity.
Appropriations
FY23 Supplemental Supplemental Transfers & FY23
Regional Fiber Consortium - 629 Adopted Budget Budget 1 Budget 2 Adiustments Revised Budget
Department Operating
Finance $ 252,150 $ $ $ $ 252,150
Total Department Operating 252,150 252,150
Non -Departmental
Reserves* 413,282 63,031 476,313
Total Non -Departmental 413,282 63,031 - 4769313
Total Regional Fiber Consortium Fund $ 6659432 $ 639031 $ $ - $ 7289463
Regional Fiber Consortium Commentary:
- No current activity.
Insurance Fund Commentary:
- No current activity.
Appropriations
FY23
Supplemental Supplemental Transfers &
FY23
Insurance Fund - 707
Adopted Budget
Budget 1 Budget 2 Adiustments
Revised Budget
Department Operating
Human Resources
$ 877,871
$ $ $
$ 877,871
Health Insurance
8,589,515
8,589,515
Property & Liability
1,687,609
1,687,609
Worker's Compensation
741,958
741,958
Total Department Operating
11,896,953
- -
11,896,953
Non -Departmental
Contingency
200,000
200,000
Reserves*
14,014,211
(273,387)
13,740,824
Total Non -Departmental
14,214,211
(273,387) -
13,940,824
Total Insurance Fund
$ 26,111,164
$ (273,387) $ $
$ 25,837,777
Insurance Fund Commentary:
- No current activity.
Vehicle and Equipment Fund - 713
Department Operating
Development & Public Works
Finance
Fire & Life Safety
Information Technology
Library
Police
Total Department Operating
Non -Departmental
Transfers
Reserves*
Total Non -Departmental
Total Vehicle and Equipment Fund
Exhibit A Page 9 of 9
Vehicle and Equipment Fund Commentary:
1.) Increase the Development & Public Works Department operating expense by $55,000 to replace the local stormwater van. This was originally planned
for the FY24 budget but due to the ongoing procurement difficulties related to the pandemic it is important to get funding established now to make sure a
purchase can be made if and when a suitable vehicle becomes available.
2.) Increase the Development & Public Works Department operating expense by $9,684 to replace a failed copier in the SE Quad.
3.) Increase Fire & Life Safety operating expense by $87,349 to purchase a new vehicle for the Life Safety Inspector and replace the Battalion Chief
vehicle.
4.) Increase the Police Department operating expense by $261,000 to purchase and upfit five vehicles. These costs were budgeted and procurement was
initiated in the FY22, but the vehicles were not received until FY23 due to supply chain issues.
SDC Administration Fund - 719
Department Operating
Development & Public Works
Finance
Total Department Operating
Non -Departmental
Contingency
Reserves*
Total Non -Departmental
Total SDC Administration Fund
SDC Administration Fund Commentary:
- No current activity.
TOTAL RESOLUTION
Appropriations
FY23 Supplemental Supplemental Transfers & FY23
Adopted Budget Budget 1 Budget 2 Adiustments Revised Budget
$ 469,638 $
45,054
514,693
$ 469,638
45,054
514,693
10,000 - 10,000
380,710 103,914 484,624
390,710 103,914 - - 494,624
$ 905,403 $ 103,914 $ $ - $ 1,009,317
$ 388,789,800 $ 24,639,582 $ 1,381,201 $ 1,000 $ 414,811,583
*Reserves and Unappropriated Ending Fund Balance are not appropriated for spending and are shown for information purposes only.
Appropriations
FY23
Supplemental
Supplemental Transfers &
FY23
Adopted Budget
Budget 1
Budget 2 Adjustments
Revised Budget
$ 948,400
$ 585,584
$ 64,684 $
$ 1,598,668
(1,2)
500
-
-
500
328,300
747,378
87,349
1,163,027
(3)
636,115
-
-
636,115
8,000
-
8,000
370,250
-
261,000
631,250
(4)
2,291,565
19332,962
413,033 -
4,037,560
-
36,500
-
36,500
8,830,184
517,462
(413,033)
8,934,613
(1-4)
8,830,184
553,962
(413,033) -
8,971,113
$ 11,121,749
$ 198869924
$ - $ -
$ 13,008,673
Vehicle and Equipment Fund Commentary:
1.) Increase the Development & Public Works Department operating expense by $55,000 to replace the local stormwater van. This was originally planned
for the FY24 budget but due to the ongoing procurement difficulties related to the pandemic it is important to get funding established now to make sure a
purchase can be made if and when a suitable vehicle becomes available.
2.) Increase the Development & Public Works Department operating expense by $9,684 to replace a failed copier in the SE Quad.
3.) Increase Fire & Life Safety operating expense by $87,349 to purchase a new vehicle for the Life Safety Inspector and replace the Battalion Chief
vehicle.
4.) Increase the Police Department operating expense by $261,000 to purchase and upfit five vehicles. These costs were budgeted and procurement was
initiated in the FY22, but the vehicles were not received until FY23 due to supply chain issues.
SDC Administration Fund - 719
Department Operating
Development & Public Works
Finance
Total Department Operating
Non -Departmental
Contingency
Reserves*
Total Non -Departmental
Total SDC Administration Fund
SDC Administration Fund Commentary:
- No current activity.
TOTAL RESOLUTION
Appropriations
FY23 Supplemental Supplemental Transfers & FY23
Adopted Budget Budget 1 Budget 2 Adiustments Revised Budget
$ 469,638 $
45,054
514,693
$ 469,638
45,054
514,693
10,000 - 10,000
380,710 103,914 484,624
390,710 103,914 - - 494,624
$ 905,403 $ 103,914 $ $ - $ 1,009,317
$ 388,789,800 $ 24,639,582 $ 1,381,201 $ 1,000 $ 414,811,583
*Reserves and Unappropriated Ending Fund Balance are not appropriated for spending and are shown for information purposes only.