Loading...
HomeMy WebLinkAboutItem 17 FY22 Supplemental Budget 2AGENDA ITEM SUMMARY SPRINGFIELD CITY COUNCIL Meeting Date: Meeting Type: Staff Contact/Dept.: Staff Phone No: Estimated Time: Council Goals: 12/6/2021 Regular Meeting Neil Obringer/Finance 541.736.1032 10 Minutes Provide Financially Responsible and Innovative Government Services ITEM TITLE: FY22 SUPPLEMENTAL BUDGET 2 & APPROPRIATIONS TRANSFER Additionally, there are two transfers between existing appropriation categories. Those transfers include $25,750 from General Fund Contingency to Human Resources Operating Expense and $63,000 from General Fund Contingency to City Manager's Office Operating Expense. Conduct a public hearing and adopt/not adopt the following resolutions: ACTION REQUESTED: A RESOLUTION ADJUSTING RESOURCES AND REQUIREMENTS IN THE FOLLOWING FUNDS: SPECIAL REVENUE, STREET CAPITAL; AND AUTHORIZING THE TRANSFER OF APPROPRIATIONS WITHIN THE GENERAL FUND FROM CONTINGENCY EXPENSE TO CITY MANAGER'S OFFICE OPERATING EXPENSE AND FROM CONTINGENCY EXPENSE TO HUMAN RESOURCES OPERATING 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 four FY22 supplemental budget requests to come before Council. The City Council is asked to approve the attached Supplemental Budget Resolution. Attachment 1. Council Briefing Memorandum ATTACHMENTS: Attachment 2. Supplemental Budget Resolution and Exhibit A The overall financial impact of the Supplemental Budget Resolution is to adjust DISCUSSION/ department Capital Expenditures by $955,000 and increase reserves by $6,978,111. FINANCIAL These are offset by new revenue of $955,000, and adjustments to Beginning Cash IMPACT: of $6,978,111. Additionally, there are two transfers between existing appropriation categories. Those transfers include $25,750 from General Fund Contingency to Human Resources Operating Expense and $63,000 from General Fund Contingency to City Manager's Office Operating Expense. MEMORANDUM City of Springfield Date: 12/6/2021 To: Nancy Newton, City Manager COUNCIL From: Nathan Bell, Finance Director BRIEFING Neil Obringer, Budget Officer Subject: FY22 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 four FY22 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 Register Guard at least five days prior to the public hearing. The attached information identifies the individual items that are included in the December 6th, 2021 Supplemental Budget request. This supplemental budget only includes new appropriation requests, including the recognition of new grant revenue and the use of Contingency expense to address high priority needs Summary of Proposed Changes by Fund: General Fund 100 • Transfer $25,750 from Contingency to Human Resources operating expense to support the addition of an HR Specialist position (position cost estimated at $103,000/year). As an organization, we are seeing an increase in turnover and recruitment. In FY17, the department had 1.5 FTE dedicated to City recruitment with an average of 46 annual job postings. Today, the department has a single recruiter working to fill an average of 56 job postings per year. The Human Resources Department requests the addition of an HR Specialist in the B band at the journey level to provide dedicated support for recruitment activities. This position would be responsible for NeoGov configuration, scheduling interviews, processing and distributing applicant documents, preparing interview packets, processing pre-employment background checks, and meeting new hires for completion of hiring paperwork and on -boarding. • Transfer $63,000 from Contingency to City Manager's Office (CMO) operating expense to support addition of a Senior Management Analyst (position cost estimated at $126,000/year). This position addresses staffing needs in CMO and will support Economic Development, the Legislative Program, and general CMO activities. Duties of this position will include: general economic development and legislative program FY22 Supplemental Budget 2 Attachment 1, Page 1 of 2 Page 1 of 2 support, special project management, leasable property management, State legislative agenda, Parking Program daily activities, CMO budget preparation and ongoing monitoring, and general CMO contract drafting and management. Special Revenue Fund 204 • Increase beginning cash and increase reserves by $6,978,111 in order to recognize the receipt of American Rescue Plan funds from the Federal Government. Street Capital Fund 434 • Increase Development & Public Works capital project expense by $955,000. Expenditures will be offset by grant revenue from the Oregon Department of Transportation. This project is intended to address pedestrian safety on Highway 126B and 126. Project scope includes the installation of 117 LED light fixtures on new mast arms on existing SUB poles and the replacement of 191 HID fixtures with LED fixtures on Main Street from 10th Street to east city limit, and South A Street from the Willamette River to 20th Street. RECOMMENDED ACTION: Conduct a public hearing and adopt/not adopt the following resolutions: A RESOLUTION ADJUSTING RESOURCES AND REQUIREMENTS IN THE FOLLOWING FUNDS: SPECIAL REVENUE, STREET CAPITAL; AND AUTHORIZING THE TRANSFER OF APPROPRIATIONS WITHIN THE GENERAL FUND FROM CONTINGENCY EXPENSE TO CITY MANAGER'S OFFICE OPERATING EXPENSE AND FROM CONTINGENCY 1*09:32 KI aC6lso NlulX01141:06181'%M)are]921IMPrIIe[ef*:4921af.991 FY22 Supplemental Budget 2 Attachment 1, Page 2 of 2 Page 2 of 3 CITY OF SPRINGFIELD, OREGON RESOLUTION NO. SUPPLEMENTAL BUDGET #2 AND APPROPRIATIONS TRANSFER A RESOLUTION ADJUSTING RESOURCES AND REQUIREMENTS IN THE FOLLOWING FUNDS; SPECIAL REVENUE, STREET CAPITAL; AND AUTHORIZING THE TRANSFER OF APPROPRIATIONS WITHIN THE GENERAL FUND FROM CONTINGENCY EXPENSE TO CITY MANAGER'S OFFICE OPERATING EXPENSE, AND FROM CONTINGENCY EXPENSE TO HUMAN RESOURCES OPERATING EXPENSE. WHEREAS, the Common Council has adopted the budget and made appropriations for Fiscal Year 2021-2022 through Resolution No. 2021-23 adopted June 21, 2021 and as amended by Resolution 2021-30 adopted September 7, 2021, and Resolution 2021-37 adopted October 18, 2021. WHEREAS, ORS 294.471(1)(c) and (d) permit a supplemental budget in order to recognize funds that are made available by another unit of federal, state or local government and the availability of which could not reasonably be foreseen when preparing the original budget or a previous supplemental budget for the current year or current budget period; or due to a request for services or facilities the cost of which is to be supplied by a private individual, corporation or company or by another governmental unit and the amount of which could not be accurately estimated when preparing the original budget or a previous supplemental budget for the current year or current budget period; WHEREAS, the Common Council is requested to make adjustments to the Fiscal Year 2021-2022 budget and appropriations to meet unexpected needs and to allow appropriations of new revenues pursuant to ORS 294.471(1)(c) and (d) 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 2021-2022 budget and appropriations, as adopted by Resolution No. 2021-23 and amended by Resolution 2021-30 and Resolution 2021-37, are hereby adjusted as provided in Exhibit A. Attachment 2, Page 1 of 9 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 Attachment 2, Page 2 of 9 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 7 1,172,619 811,185 6,000 1,989,804 1,000,000 - (103,350) 896,650 (1,2) 7,431,484 476,175 - 7,907,659 9,604,103 1,287,360 (97,350) 10,7949113 $ 50,377,017 $ 1,470,117 $ $ - $ 51,8479134 General Fund Commentary: 1.) Transfer $63,000 from Contingency to City Manager's Office (CMO) operating expense to support addition of a Senior Management Analyst (position cost estimated at $126,000/year). This position addresses staffing needs in CMO and will support Economic Development, Legislative programs and general CMO activities. Duties of this position will include: general economic development and legislative program support and special project management, leasable property management, State legislative agenda, Parking Program daily activities, CMO budget preparation and ongoing monitoring, general CMO contract drafting and management. 2.) Transfer $25,750 from Contingency to Human Resources Operating expense to support the addition of an HR Specialist position (position cost estimated at $103,000/year). As an organization, we are seeing an increase in turnover and recruitment. In FYI 7, the department had 1.5 FTE dedicated to City recruitment of 46 job annual job postings. Today the department has a single recruiter working to fill an average of 56 job postings per year. The Human Resources Department requests the addition of an HR Specialist in the B band at the journey level to provide dedicated support for recruitment activities. This position would be responsible for NeoGov configuration, scheduling interviews, processing and distributing applicant documents, preparing interview packets, processing pre-employment background checks, and meeting new hires for completion of hiring paperwork and on- >, -Ai - Street Fund - 201 Department Operating City Manager's Office Development & Public Works Finance Information Technology Total Department Operating Non -Departmental Transfers Reserves* Total Non -Departmental Total Street Fund Street Fund Commentary: - No current activity. FY22 Supplemental Supplemental Adopted Budget Budget 1 Budget 2 $ 56,570 $ - $ 6,423,441 30,884 55,075 - 391,892 16,200 6,926,977 47,084 Appropriations Transfers & FY22 Adiustments Revised Budget $ $ 56,570 6,454,325 55,075 408,092 6,974,061 150,000 - 150,000 1,410,332 680,184 2,090,516 1,560,332 680,184 2,240,516 $ 8,487,309 $ 727,268 $ $ $ 9,214,577 Attachment 2, Page 3 of 9 EXHIBIT A FY2021-22 SUPPLEMENTAL BUDGET 2 AND APPROPRIATIONS TRANSFER Appropriations FY22 Supplemental Supplemental Transfers & FY22 Adopted Budget Budget 1 Budget 2 Adiustments Revised Budget $ 1,531,860 $ 83,793 $ $ 62,000 $ 1,677,653 (1) 2,819,475 - - 2,819,475 2,396,951 5,400 9,600 2,411,951 12,302,070 80,324 - 12,382,394 688,070 - 25,750 713,820 (2) 1,941,296 - 1,941,296 777,086 - 777,086 1,902,711 13,240 1,915,951 16,413,396 16,413,396 40,772,914 182,757 97,350 41,053,021 1,172,619 811,185 6,000 1,989,804 1,000,000 - (103,350) 896,650 (1,2) 7,431,484 476,175 - 7,907,659 9,604,103 1,287,360 (97,350) 10,7949113 $ 50,377,017 $ 1,470,117 $ $ - $ 51,8479134 General Fund Commentary: 1.) Transfer $63,000 from Contingency to City Manager's Office (CMO) operating expense to support addition of a Senior Management Analyst (position cost estimated at $126,000/year). This position addresses staffing needs in CMO and will support Economic Development, Legislative programs and general CMO activities. Duties of this position will include: general economic development and legislative program support and special project management, leasable property management, State legislative agenda, Parking Program daily activities, CMO budget preparation and ongoing monitoring, general CMO contract drafting and management. 2.) Transfer $25,750 from Contingency to Human Resources Operating expense to support the addition of an HR Specialist position (position cost estimated at $103,000/year). As an organization, we are seeing an increase in turnover and recruitment. In FYI 7, the department had 1.5 FTE dedicated to City recruitment of 46 job annual job postings. Today the department has a single recruiter working to fill an average of 56 job postings per year. The Human Resources Department requests the addition of an HR Specialist in the B band at the journey level to provide dedicated support for recruitment activities. This position would be responsible for NeoGov configuration, scheduling interviews, processing and distributing applicant documents, preparing interview packets, processing pre-employment background checks, and meeting new hires for completion of hiring paperwork and on- >, -Ai - Street Fund - 201 Department Operating City Manager's Office Development & Public Works Finance Information Technology Total Department Operating Non -Departmental Transfers Reserves* Total Non -Departmental Total Street Fund Street Fund Commentary: - No current activity. FY22 Supplemental Supplemental Adopted Budget Budget 1 Budget 2 $ 56,570 $ - $ 6,423,441 30,884 55,075 - 391,892 16,200 6,926,977 47,084 Appropriations Transfers & FY22 Adiustments Revised Budget $ $ 56,570 6,454,325 55,075 408,092 6,974,061 150,000 - 150,000 1,410,332 680,184 2,090,516 1,560,332 680,184 2,240,516 $ 8,487,309 $ 727,268 $ $ $ 9,214,577 Attachment 2, Page 3 of 9 Special Revenue Fund - 204 Department Operating City Manager's Office Development & Public Works Information Technology Fire and Life Safety Library Police Total Department Operating Non -Departmental Reserves* Total Non -Departmental Total Special Revenue Fund Exhibit A, Page 2 of 7 Special Revenue Fund Commentary: 1.) Increase beginning cash and increase reserves by $6,978,111 in order to recognize the receipt of American Rescue Plan funds from the Federal Government. Appropriations Appropriations FY22 Supplemental Supplemental Transfers & FY22 Adopted Budget Budget 1 Budget 2 Adiustments Revised Budget $ 38,230 $ 53,011 $ Department Operating $ $ 91,241 93,345 488,576 City Manager's Office 581,921 20,000 - $ $ 233,162 20,000 - 630,000 630,000 84,154 71,662 264,048 79,500 235,316 134,000 176,342 - 310,342 369,729 1,419,591 Non -Departmental 79,500 1,868,820 1,657,994 (1,063,768) 6,978,111 Transfers 7,572,337 (1) 1,657,994 (1,063,768) 6,978,111 750,000 7,572,337 $ 2,027,723 $ 355,823 $ 6,978,111 $ 79,500 $ 9,441,157 Special Revenue Fund Commentary: 1.) Increase beginning cash and increase reserves by $6,978,111 in order to recognize the receipt of American Rescue Plan funds from the Federal Government. Community Development Fund Commentary: - No current activity. Attachment 2, Page 4 of 9 Appropriations FY22 Supplemental Supplemental Transfers & FY22 Transient Room Tax Fund - 208 Adopted Budget Budget 1 Budget 2 Adiustments Revised Budget Department Operating City Manager's Office $ 233,162 $ $ $ $ 233,162 Development & Public Works 24,909 24,909 Library 264,048 264,048 Total Department Operating 522,119 522,119 Non -Departmental Transfers 750,000 750,000 Reserves* 866,491 468,322 1,334,813 Total Non -Departmental 1,616,491 468,322 2,084,813 Total Transient Room Tax Fund $ 2,138,610 $ 468,322 $ $ $ 2,606,932 Transient Room Tax Fund Commentary: - No current activity. Appropriations FY22 Supplemental Supplemental Transfers & FY22 Community Development Fund - 210 Adopted Budget Budget 1 Budget 2 Adiustments Revised Budget Department Operating Development & Public Works $ 2,071,567 $ 48,509 $ $ $ 2,120,076 Finance 24,590 - 24,590 Total Department Operating 2,096,157 48,509 2,144,666 Non -Departmental Reserves* 823,665 (497,653) 326,012 Total Non -Departmental 823,665 (497,653) 326,012 Total Community Development Fund $ 2,919,822 $ (449,144) $ $ $ 2,470,678 Community Development Fund Commentary: - No current activity. Attachment 2, Page 4 of 9 Exhibit A, Page 3 of 7 Non -Departmental Reserves* Total Non -Departmental Total Building Fund Building Code Fund Commentary: - No current activity. Fire Local Option Levy Fund - 235 Department Operating Fire and Life Safety Total Department Operating Non -Departmental Reserves* Total Non -Departmental Total Fire Local Option Levy Fund Fire Local Option Levy Fund Commentary: - No current activity. 3,017,754 140,829 3,158,583 3,017,754 140,829 3,158,583 $ 4,386,312 $ 238,329 $ $ $ 4,624,641 Appropriations Appropriations Supplemental Supplemental FY22 Supplemental Supplemental Transfers & FY22 Building Code Fund - 224 Adopted Budget Budget 1 Budget 2 Adiustments Revised Budget Department Operating 209294 1,609,593 1,333,028 City Manager's Office $ 21,742 $ - $ $ $ 21,742 Development & Public Works 1,266,115 97,500 1,363,615 Fire & Life Safety 80,701 - 80,701 Total Department Operating 1,368,558 97,500 1,466,058 Non -Departmental Reserves* Total Non -Departmental Total Building Fund Building Code Fund Commentary: - No current activity. Fire Local Option Levy Fund - 235 Department Operating Fire and Life Safety Total Department Operating Non -Departmental Reserves* Total Non -Departmental Total Fire Local Option Levy Fund Fire Local Option Levy Fund Commentary: - No current activity. 3,017,754 140,829 3,158,583 3,017,754 140,829 3,158,583 $ 4,386,312 $ 238,329 $ $ $ 4,624,641 Bond Sinldng Fund Commentary: - No current activity. Attachment 2, Page 5 of 9 Appropriations FY22 Supplemental Supplemental Transfers & FY22 Adopted Budget Budget 1 Budget 2 Adiustments Revised Budget $ 1,589,299 $ 20,294 $ $ $ 1,609,593 1,589,299 209294 1,609,593 1,333,028 48,951 1,381,979 1,333,028 48,951 1,381,979 $ 2,922,327 $ 69,245 $ $ $ 2,991,572 Bond Sinldng Fund Commentary: - No current activity. Attachment 2, Page 5 of 9 Appropriations FY22 Supplemental Supplemental Transfers & FY22 Police Local Option Levy Fund - 236 Adouted Budget Budget I Budget 2 Adiustments Revised Budget Department Operating Finance $ 687,452 $ $ $ $ 687,452 Legal Services 89,700 89,700 Police 6,839,951 6,839,951 Total Department Operating 7,617,103 7,617,103 Non -Departmental Reserves* 1,953,525 583,665 2,537,190 Total Non -Departmental 1,953,525 583,665 2,537,190 Total Police Local Option Levy Fund $ 9,570,628 $ 583,665 $ $ $ 10,154,293 Police Local Option Levy Fund Commentary: - No current activity. Appropriations FY22 Supplemental Supplemental Transfers & FY22 Bond Sinldng Fund - 306 Adopted Budget Budget 1 Budget 2 Adiustments Revised Budget Non -Departmental Debt Service $ 4,012,785 $ - $ $ $ 4,012,785 Unappropriated Ending Fund Balance* 518,185 59,638 577,823 Total Non -Departmental 4,530,970 59,638 4,590,608 Total Bond Sinldng Fund $ 4,530,970 $ 59,638 $ $ $ 4,5909608 Bond Sinldng Fund Commentary: - No current activity. Attachment 2, Page 5 of 9 Exhibit A, Page 4 of 7 Total Development Assessment Fund $ 722,812 $ (2,800) $ $ - $ 720,012 Development Assessment Fund Commentary: - No current activity. Appropriations FY22 Supplemental Supplemental Transfers & FY22 Development Assessment Fund - 419 Adopted Budget Budget 1 Budget 2 Adiustments Revised Budget Non -Departmental Total Development & Public Works Capital $ Reserves* $ 722,812 $ (2,800) $ $ $ 720,012 Total Non -Departmental 722,812 (2,800) 720,012 Total Development Assessment Fund $ 722,812 $ (2,800) $ $ - $ 720,012 Development Assessment Fund Commentary: - No current activity. Development Projects Fund Commentary: - No current activity. Appropriations FY22 Supplemental Supplemental Transfers & FY22 Adopted Budget Budget 1 Budget 2 Adiustments Revised Budget Development Proiects Fund - 420 Department Operating Total Development & Public Works Capital $ 305,892 $ $ $ $ 305,892 Non -Departmental Total Department Operating 1,132,000 2,010,000 Interfund Loan $ 1,500,000 $ $ 1,500,000 Reserves* 3,884,656 (240,079) 3,644,577 Total Non -Departmental 5,384,656 (240,079) 5,144,577 Total Development Projects Fund $ 5,690,548 $ (240,079) $ $ $ 5,450,469 Development Projects Fund Commentary: - No current activity. Total Regional Wastewater Capital Fund $ 86,049,546 $ 6,284,824 $ - $ - $ 92,3349370 Regional Wastewater Capital Fund Commentary: - No current activity. Appropriations FY22 Supplemental Supplemental Transfers & FY22 Street Capital Fund - 434 Adopted Budget Budget 1 Budget 2 Adiustments Revised Budget Department Operating Development & Public Works $ 148,026 $ $ $ $ 148,026 Total Department Operating 148,026 148,026 Total Development & Public Works Capital 2,922,354 4,973,400 955,000 8,850,754 (1) Non -Departmental Reserves* 7,368,537 (3,474,623) 3,893,914 Total Non -Departmental 7,368,537 (3,474,623) 3,893,914 Total Street Capital Fund $ 10,438,917 $ 1,498,777 $ 955,000 $ - $ 12,892,694 Street Capital Fund Commentary: 1.) Increase Development & Public Works capital project expense by $955,000. Expenditures will be offset by grant revenue from the Oregon Department of Transportation. This project is intended to address pedestrian safety on Highway 126B and 126. Project scope includes the installation of 117 LED light fixtures on new mast arms on existing SUB poles and the replacement of 191 HID fixtures with LED fixtures on Main Street from 10th Street to east city limit, and South A Street from the Willamette River to 20th Street. Attachment 2, Page 6 of 9 Anuronriations FY22 Supplemental Supplemental Transfers & FY22 Regional Wastewater Capital Fund - 433 Adopted Budget Budget 1 Budget 2 Adiustments Revised Budget Department Operating Development & Public Works $ 1,132,000 $ 2,010,000 $ $ $ 3,142,000 Total Department Operating 1,132,000 2,010,000 3,142,000 Total Development & Public Works Capital 21,700,000 3,016,723 24,716,723 Non -Departmental Transfers 23,172 - 23,172 Reserves* 63,194,374 1,258,101 64,452,475 Total Non -Departmental 63,217,546 1,258,101 64,475,647 Total Regional Wastewater Capital Fund $ 86,049,546 $ 6,284,824 $ - $ - $ 92,3349370 Regional Wastewater Capital Fund Commentary: - No current activity. Appropriations FY22 Supplemental Supplemental Transfers & FY22 Street Capital Fund - 434 Adopted Budget Budget 1 Budget 2 Adiustments Revised Budget Department Operating Development & Public Works $ 148,026 $ $ $ $ 148,026 Total Department Operating 148,026 148,026 Total Development & Public Works Capital 2,922,354 4,973,400 955,000 8,850,754 (1) Non -Departmental Reserves* 7,368,537 (3,474,623) 3,893,914 Total Non -Departmental 7,368,537 (3,474,623) 3,893,914 Total Street Capital Fund $ 10,438,917 $ 1,498,777 $ 955,000 $ - $ 12,892,694 Street Capital Fund Commentary: 1.) Increase Development & Public Works capital project expense by $955,000. Expenditures will be offset by grant revenue from the Oregon Department of Transportation. This project is intended to address pedestrian safety on Highway 126B and 126. Project scope includes the installation of 117 LED light fixtures on new mast arms on existing SUB poles and the replacement of 191 HID fixtures with LED fixtures on Main Street from 10th Street to east city limit, and South A Street from the Willamette River to 20th Street. Attachment 2, Page 6 of 9 Non -Departmental Debt Service 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 Regional Wastewater Fund Commentary: - No current activity. Ambulance Fund - 615 Department Operating Fire and Life Safety Total Department Operating Non -Departmental Reserves* Total Non -Departmental Total Ambulance Fund Ambulance Fund Commentary: - No current activity. Supplemental Budget 2 Exhibit A, Page 5 of 7 Appropriations Transfers & FY22 Adiustments Revised Budget $ $ 81,550 4,852,271 53,109 391,242 5,378,171 10,996,600 1,707,800 1,707,800 23,308,457 (1,603,311) 21,705,146 25,016,257 (1,603,311) 23,412,946 $ 39,675,728 $ 111,989 $ $ $ 39,787,717 FY22 Supplemental Sanitary Sewer Operations Fund - 611 Adopted Budget Budget 1 Department Operating Budget 1 Budget 2 Adiustments Revised Budget City Manager's Office $ 81,550 $ $ Development & Public Works 4,852,271 20,592,373 Finance 53,109 181,869 Information Technology 375,942 15,300 Total Department Operating 5,362,871 15,300 _ Total Development & Public Works Capital 9,296,600 1,700,000 Non -Departmental Debt Service 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 Regional Wastewater Fund Commentary: - No current activity. Ambulance Fund - 615 Department Operating Fire and Life Safety Total Department Operating Non -Departmental Reserves* Total Non -Departmental Total Ambulance Fund Ambulance Fund Commentary: - No current activity. Supplemental Budget 2 Exhibit A, Page 5 of 7 Appropriations Transfers & FY22 Adiustments Revised Budget $ $ 81,550 4,852,271 53,109 391,242 5,378,171 10,996,600 1,707,800 1,707,800 23,308,457 (1,603,311) 21,705,146 25,016,257 (1,603,311) 23,412,946 $ 39,675,728 $ 111,989 $ $ $ 39,787,717 Appropriations FY22 Supplemental Supplemental Transfers & FY22 Adopted Budget Budget 1 Budget 2 Adiustments Revised Budget $ 6,681,492 $ $ $ $ 6,681,492 6,681,492 6,681,492 $ 6,681,492 $ $ $ $ 6,681,492 Attachment 2, Page 7 of 9 Appropriations FY22 Supplemental Supplemental Transfers & FY22 Adopted Budget Budget 1 Budget 2 Adiustments Revised Budget $ 15,777 $ - $ $ $ 15,777 20,471,365 121,008 20,592,373 181,869 - 181,869 20,669,011 121,008 20,790,019 10,550,000 - 10,550,000 4,110,375 - 4,110,375 10,802,255 2,331,026 13,133,281 25,462,630 2,331,026 27,793,656 $ 46,131,641 $ 2,452,034 $ $ $ 48,583,675 Appropriations FY22 Supplemental Supplemental Transfers & FY22 Adopted Budget Budget 1 Budget 2 Adiustments Revised Budget $ 6,681,492 $ $ $ $ 6,681,492 6,681,492 6,681,492 $ 6,681,492 $ $ $ $ 6,681,492 Attachment 2, Page 7 of 9 Non -Departmental Debt Service Reserves* Total Non -Departmental Total Drainage Operating Fund Storm Drainage Operating Fund Commentary: - No current activity. 551,643 17,391,341 (1,825,812) 17,942,984 (1,825,812) $ 31,532,795 $ (1,262,762) $ Exhibit A, Page 6 of 7 Appropriations Supplemental Transfers & FY22 Budget 2 Adiustments Revised Budget $ $ 81,991 6,902,919 53,110 297,471 7,335,491 6,817,370 551,643 _ 15,565,529 16,117,172 - $ - $ 30,270,033 FY22 Supplemental Storm Drainage Operating Fund - 617 Adopted Budget Budget 1 Department Operating FY22 Supplemental City Manager's Office $ 81,991 $ - $ Development & Public Works 6,652,919 250,000 Finance 53,110 - Information Technology 284,421 13,050 Total Department Operating 7,072,441 263,050 _ Total Development & Public Works Capital 6,517,370 300,000 _ Non -Departmental Debt Service Reserves* Total Non -Departmental Total Drainage Operating Fund Storm Drainage Operating Fund Commentary: - No current activity. 551,643 17,391,341 (1,825,812) 17,942,984 (1,825,812) $ 31,532,795 $ (1,262,762) $ Exhibit A, Page 6 of 7 Appropriations Supplemental Transfers & FY22 Budget 2 Adiustments Revised Budget $ $ 81,991 6,902,919 53,110 297,471 7,335,491 6,817,370 551,643 _ 15,565,529 16,117,172 - $ - $ 30,270,033 Non -Departmental Reserves* 454,345 8,047 462,392 Total Non -Departmental 454,345 8,047 462,392 Total Regional Fiber Consortium Fund $ 665,495 $ 8,047 $ $ $ 673,542 Regional Fiber Consortium Fund Commentary: - No current activity. Attachment 2, Page 8 of 9 Appropriations FY22 Supplemental Supplemental Transfers & FY22 Booth -Kelly Fund - 618 Adopted Budget Budget 1 Budget 2 Adiustments Revised Budget Department Operating Development & Public Works $ 503,822 $ $ $ $ 503,822 Total Department Operating 503,822 503,822 Total Development & Public Works Capital 190,000 190,000 Non -Departmental Transfers 80,651 80,651 Reserves* 1,184,293 273,327 1,457,620 Total Non -Departmental 1,264,944 273,327 1,538,271 Total Booth -Kelly Fund $ 1,958,766 $ 273,327 $ $ $ 2,232,093 Booth -Kelly Fund Commentary: - No current activity. Appropriations FY22 Supplemental Supplemental Transfers & FY22 Regional Fiber Consortium - 629 Adopted Budget Budget 1 Budget 2 Adiustments Revised Budget Department Operating Finance $ 211,150 $ $ $ $ 211,150 Total Department Operating 211,150 211,150 Non -Departmental Reserves* 454,345 8,047 462,392 Total Non -Departmental 454,345 8,047 462,392 Total Regional Fiber Consortium Fund $ 665,495 $ 8,047 $ $ $ 673,542 Regional Fiber Consortium Fund Commentary: - No current activity. Attachment 2, Page 8 of 9 Exhibit A, Page 7 of 7 Non -Departmental Reserves* Total Non -Departmental Total Insurance Fund Insurance Fund Commentary: - No current activity. Vehicle and Equipment Fund - 713 Department Operating Development & Public Works Fire & Life Safety Human Resources Information Technology Library Police Total Department Operating Non -Departmental Transfers Reserves* Total Non -Departmental Total Vehicle and Equipment Fund Vehicle and Equipment Fund Commentary: - No current activity. SDC Administration Fund - 719 Department Operating Development & Public Works Finance Information Technology Total Department Operating Non -Departmental Reserves* Total Non -Departmental Total SDC Administration Fund SDC Administration Fund Commentary: - No current activity. TOTAL RESOLUTION 10,646,682 869,247 11,515,929 10,646,682 869,247 11,515,929 $ 22,726,011 $ 869,247 $ $ $ 23,595,258 FY22 Supplemental Supplemental Appropriations Budget 1 Budget 2 FY22 Supplemental Supplemental Transfers & FY22 Insurance Fund - 707 Adopted Budget Budget 1 Budget 2 Adiustments Revised Budget Department Operating 775,704 - Human Resources $ 735,379 $ $ $ $ 735,379 Health Insurance 9,334,875 9,334,875 Property & Liability 1,058,895 1,058,895 Worker's Compensation 950,180 950,180 Total Department Operating 12,079,329 12,079,329 Non -Departmental Reserves* Total Non -Departmental Total Insurance Fund Insurance Fund Commentary: - No current activity. Vehicle and Equipment Fund - 713 Department Operating Development & Public Works Fire & Life Safety Human Resources Information Technology Library Police Total Department Operating Non -Departmental Transfers Reserves* Total Non -Departmental Total Vehicle and Equipment Fund Vehicle and Equipment Fund Commentary: - No current activity. SDC Administration Fund - 719 Department Operating Development & Public Works Finance Information Technology Total Department Operating Non -Departmental Reserves* Total Non -Departmental Total SDC Administration Fund SDC Administration Fund Commentary: - No current activity. TOTAL RESOLUTION 10,646,682 869,247 11,515,929 10,646,682 869,247 11,515,929 $ 22,726,011 $ 869,247 $ $ $ 23,595,258 FY22 Supplemental Supplemental Adopted Budget Budget 1 Budget 2 $ 2,144,200 $ 329,163 $ 139,900 1,095,700 - 4,000 775,704 - 8,000 - 307,000 127,487 3,374,804 1,556,350 Appropriations Transfers & FY22 Adiustments Revised Budget $ $ 2,473,363 1,235,600 4,000 775,704 8,000 434,487 4,931,154 - 27,500 27,500 8,376,051 (117,159) 8,258,892 8,376,051 (89,659) 8,286,392 $ 11,750,855 $ 1,466,691 $ $ $ 13,2179546 $ 352,130,510 $ 15,049,148 7,933,111 $ 79,500 $ 375,192,269 *Reserves and Unappropriated Ending Fund Balance are not appropriated for spending and are shown for information purposes only. Attachment 2, Page 9 of 9 Appropriations FY22 Supplemental Supplemental Transfers & FY22 Adopted Budget Budget 1 Budget 2 Adiustments Revised Budget $ 412,155 $ $ $ $ 412,155 39,222 39,222 69,604 450 70,054 520,980 450 521,430 224,205 66,140 290,345 224,205 $ 66,140 $ $ 290,345 $ 745,185 $ 66,590 $ $ $ 811,775 $ 352,130,510 $ 15,049,148 7,933,111 $ 79,500 $ 375,192,269 *Reserves and Unappropriated Ending Fund Balance are not appropriated for spending and are shown for information purposes only. Attachment 2, Page 9 of 9