Loading...
HomeMy WebLinkAboutItem 05FY22 Supplemental Budget 3AGENDA ITEM SUMMARY Meeting Date: Meeting Type: Staff Contact/Dept.: Staff Phone No: Estimated Time: 2/22/2022 Regular Meeting Neil Obringer/Finance 541.736.1032 10 Minutes SPRINGFIELD Council Goals: Provide Financially CITY COUNCIL Responsible and Innovative Government Services ITEM TITLE: FY22 SUPPLEMENTAL BUDGET 3 & APPROPRIATIONS TRANSFER Additionally, there is one transfer totaling $336,000 from General Fund Contingency to Police 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: GENERAL, STREET, SPECIAL REVENUE, BUILDING CODE, FIRE LOCAL OPTION LEVY, REGIONAL WASTEWATER CAPITAL, STREET CAPITAL, SANITARY SEWER OPERATIONS, REGIONAL WASTEWATER, AMBULANCE, BOOTH -KELLY, AND VEHICLE & EQUIPMENT; AND AUTHORIZING THE TRANSFER OF APPROPRIATIONS WITHIN THE GENERAL FUND FROM CONTINGENCY EXPENSE TO POLICE DEPARTMENT 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 third 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 Operating Expenditures by $7,409,466 and Capital Expenditures by FINANCIAL $40,000. These are offset by new revenue of $1,441,627 and a reduction in IMPACT: Reserves of $6,007,839. Additionally, there is one transfer totaling $336,000 from General Fund Contingency to Police Operating Expense. MEMORANDUM City of Springfield Date: 2/22/2022 To: Nancy Newton, City Manager COUNCIL From: Nathan Bell, Finance Director BRIEFING Neil Obringer, Budget Officer Yueyin Lin, Finance Analyst Subject: FY22 SUPPLEMENTAL BUDGET 3 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 third 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 February 22nd, 2022 Supplemental Budget request. This supplemental budget includes new appropriation requests, including the recognition of new grant revenue, increases to appropriations through reduction in reserves, and the use of Contingency expense to address high priority needs. Summary of Proposed Changes by Fund: General Fund 100 Increase Eugene -Springfield Fire and Life Safety operating expense in the General Fund by $52,558, in the Fire Local Option Levy Fund by $22,398, and in the Ambulance Fund by $6,910 in response to Conflagration deployments within Oregon from July 1, 2021 to September 30, 2021. This operating expense increase is offset by corresponding revenue. Transfer $225,000 from Contingency to the Police operating expense to support unanticipated, non -discretionary overtime costs due to low staffing levels and minimum staffing requirements. Transfer an additional $111,000 to support the full funding of the Police Office Supervisor position assigned to Records. The position was only partially funded due to a software calculation error in the budget preparation process. Special Revenue Fund 204 • Transfer $35,000 from the American Recovery Plan Reserve to the City Manager's Office operating expense to provide appropriations to support Springfield's share of costs for a consultant to complete a financial analysis of the functionally merged Eugene -Springfield Fire and Life Safety Department. The purpose of the analysis is to help inform the governing FY22 Supplemental Budget 3 Page 1 of 2 bodies of each repective City of the cost/benefits of different potential future configurations of the department. • Recognize $76,800 in grant revenue from the Department of Land Conservation & Development (DLCD) and increase appropriations in the Development & Public Works Department Community Development (CMD) Division to support the Comprehensive Plan Map Project. The purpose of the Comprehensive Plan Map Project is to create a property - specific Comprehensive Plan Map for the City of Springfield. This map will add greater certainty to ambiguous plan designations. • Recognize $79,945 in grant revenue from the DLCD and increase appropriations in the Development & Public Works Department Community Development (CMD) Division for Natural Resource Protection in the Urban Growth Boundary Expansion Areas. This is a continuation of previous CMD work identified in the Comprehensive Planning Work Program. This first phase of this project started in FY21 and was completed in FY22. This second grant will allow for additional consulting services and community outreach. • Transfer $2,750,000 from the American Recovery Plan Reserve to the Development & Public Works Department Operations Division to provide for city-wide legacy street light replacement using modern LED fixtures. • Transfer $45,000 from the American Recovery Plan Reserve to the Development & Public Works Department Operations Division to support an engineering analysis of the City Hall heating, ventilation, and air-conditioning (HVAC) system. The purpose of the analysis is to inform replacement options and support the development of a scope of work and project budget for HVAC system and roof improvements. • Transfer $450,000 from the American Recovery Plan Reserve to the Development & Public Works Department Operations Division to allow for roof replacement at the Springfield Justice Center. • Transfer $200,000 from the American Recovery Plan Reserve to the Development & Public Works Department Operations Division to install a comprehensive security camera system at City Hall to address security issues. • Transfer $950,000 from the American Recovery Plan Reserve to the Development & Public Works Department Operations Division to support the City Hall Library remodel. The project will address the need for modernized and more accessible meeting/programming space and improvements to the teen and children's area, along with relocation of the City Manager's Office. • Transfer $150,000 from the American Recovery Plan Reserve to the Development & Public Works Department Operations Division to increase security in the Council Chambers. • Transfer $1,000,000 from the American Recovery Plan Reserve to Finance Department operating expense to provide for a pass thm of $1M to Willamalane Parks and Recreation as agreed to by City Council. • Recognize $27,000 in grant revenue from the Federal Emergency Management Agency (FEMA) and a $13,000 contribution from Lane County to support the preparation of an Emergency Action Plan for the 42nd Street Levee. Building Code Fund 224, Street Capital Fund 434, Sanitary Sewer Operations Fund 611 • Increase appropriations in the Development & Public Works Department Community Development (CMD) Division by $98,000 to accommodate merchant fee expenses which have been greater than anticipated. The planning and development center has seen drastic increases in the number of permits and applications being filled out and paid for via credit card. This request is for an increase in the Development & Public Works operating expense of $48,000 from the Building Fund, $18,000 from the Street Capital Fund, and $32,000 from the Sanitary Sewer Fund. Ambulance Fund 615 • Recognize $1,021,000 in revenue from the Ground Emergency Medical Transport (GEMT) program, increase Fire & Life Safety operating expense by $284,000, and increase operating reserve by $737,000. FY22 Supplemental Budget 3 Page 2 of 3 Booth -Kelly Fund 618 • Transfer $250,000 from Booth -Kelly Operating Reserves to the Development & Public Works Department Operations Division to establish authority for facility assessment and possible demolition of the Carter Building. The building has suffered a significant structural failure impacting the roof and building structure. Vehicle & Equipment Fund 713 • Transfer $250,000 from Vehicle & Equipment Reserves to the Information Technology Department to purchase replacement server hardware which supports the function of the City's network. This server hardware should be replaced on a five-year cycle and the current hardware is six years old. RECOMMENDED ACTION: Conduct a public hearing and adopt/not adopt the following resolutions: A RESOLUTION ADJUSTING RESOURCES AND REQUIREMENTS IN THE FOLLOWING FUNDS: GENERAL, STREET, SPECIAL REVENUE, BUILDING CODE, FIRE LOCAL OPTION LEVY, REGIONAL WASTEWATER CAPITAL, STREET CAPITAL, SANITARY SEWER OPERATIONS, REGIONAL WASTEWATER, AMBULANCE, BOOTH -KELLY, AND VEHICLE & EQUIPMENT; AND AUTHORIZING THE TRANSFER OF APPROPRIATIONS WITHIN THE GENERAL FUND FROM CONTINGENCY EXPENSE TO POLICE DEPARTMENT OPERATING EXPENSE. FY22 Supplemental Budget 3 Page 3 of 3 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 FY2021-22 SUPPLEMENTAL BUDGET 3 AND APPROPRIATIONS TRANSFER Appropriations FY22 Supplemental Supplemental Supplemental Transfers & FY22 Adopted Budget Budeet 1 Budget 2 Budget 3 Adjustments Revised Budget $ 1,531,860 $ 83,793 $ 2,819,475 - 2,396,951 5,400 12,302,070 80,324 688,070 - 1,941,296 - 777,086 - 1,902,711 13,240 16,413,396 _ 40,772,914 182,757 1,172,619 811,185 1,000,000 - 7,431,484 476,175 9,604,103 1,287,360 $ - $ 62,000 $ 1,677,653 1,350 - 2,820,825 (1) - 9,600 2,411,951 52,558 - 12,434,952 (2) - 25,750 713,820 - 1,941,296 777,086 1,915,951 336,000 16,749,396 (3) 53,908 433,350 41,442,929 6,000 1,989,804 - (439,350) 560,650 (3) _ 7,907,659 (433,350) 10,458,113 $ 50,377,017 $ 1,470,117 $ - $ 53,908 $ - $ 51,901,042 General Fund Commentary: 1.) Recognize $1,350 in unanticipated revenue from outside agencies and increase appropriations in the Development & Public Works Department, Community Development Division to support training expense in the department. The Historic Commission is putting on a training with Live Oaks Consulting to training the Commission and staff about decolonization and white supremecy. Springfield staffhave invited members of Team Springfield to pay for some of their staff to attend. 2.) Increase Eugene -Springfield Fire and Life Safety operating expense in the General Fund by $52,558, in the Fire Local Option Levy Fund by $22,398, and in the Ambulance Fund by $6,910 in response to Conflagration deployments within Oregon from July 1, 2021 - September 30, 2021. This operating expense increase is offset by corresponding revenue. 3.) Transfer $225,000 from Contingency to Police Department operating expense to support unanticipated, non -discretionary overtime costs due to low staffing levels and minimum staffing requirements. Transfer another $111,000 to support the full funding of the Police Office Supervisor position assigned to Records. The position was partially funded due to a software calculation error in the budget preparation process. Street Fund Commentary: 1.) Recognize $15,000 from the River Glen Homeowners Association (HOA) and increase appropriations in the Development & Public Works Department, Operations Division to replace lights in the River Glen subdivision which were failing. This request for services and associated reimbursement was not anticipated during the budget process or prior supplemental budgets Attachment 2, Page 1 of 7 Appropriations FY22 Supplemental Supplemental Supplemental Transfers & FY22 Street Fund - 201 Adopted Budget Budget 1 Budget 2 Budget 3 Adjustments Revised Budget Department Operating City Manager's Office $ 56,570 $ - $ - $ - $ - $ 56,570 Development & Public Works 6,423,441 30,884 - 15,000 - 6,469,325 (1) Finance 55,075 - - - - 55,075 Information Technology 391,892 16,200 408,092 Total Department Operating 6,926,977 47,084 15,000 6,989,061 Non -Departmental Transfers 150,000 - - - - 150,000 Reserves* 1,410,332 680,184 2,090,516 Total Non -Departmental 1,560,332 680,184 2,240,516 Total Street Fund $ 8,487,309 $ 727,268 $ - $ 15,000 $ - $ 9,229,577 Street Fund Commentary: 1.) Recognize $15,000 from the River Glen Homeowners Association (HOA) and increase appropriations in the Development & Public Works Department, Operations Division to replace lights in the River Glen subdivision which were failing. This request for services and associated reimbursement was not anticipated during the budget process or prior supplemental budgets Attachment 2, Page 1 of 7 Special Revenue Fund Commentary: 1.) Transfer $35,000 from the American Recovery Plan Reserve to the City Manager's Office operating expense to provide appropriations to support Springfield's share of costs for a consultant to complete a financial analysis of the functionally merged Eugene -Springfield Fire and Life Safety Department. The purpose of the analysis is to help inform the governing bodies of each repective City of the cost/benefits of different potential future configurations of the department. This request recognizes unanticipated revenue from the Federal government. 2.) Recognize $76,800 in grant revenue from the Department of Land Conservation & Development (DLCD) and increase appropriations in the Development & Public Works Department, Community Development (CMD) Division to support the Comprehensive Plan Map Project. The purpose of the Comprehensive Plan Map Project is to create a property -specific Comprehensive Plan Map for the City of Springfield. This map will add greater certainty to ambiguous plan designations. This request recognizes unanticipated revenue from the State government. 3.) Recognize $79,945 in grant revenue from the DLCD and increase appropriations in the Development & Public Works Department, Community Development (CMD) Division for Natural Resource Protection in the Urban Growth Boundary Expansion Areas. This is a continuation of previous CMD work identified in the Comprehensive Planning Work Program. This first phase of this project started in FY21, and was completed in FY22. This second grant will allow for additional consulting services and community outreach. This request recognizes unanticipated revenue from the State government. 4.) Transfer $2,750,000 from the American Recovery Plan Reserve to the Development & Public Works Department, Operations Division to provide for City wide legacy street light replacement using modern LED fixtures. This request recognizes unanticipated revenue from the Federal government. 5.) Transfer $45,000 from the American Recovery Plan Reserve to the Development & Public Works Department, Operations Division to support an engineering analysis of the City Hall heating, ventilation, an -conditioning (HVAC) system. The purpose of the analysis is to inform replacement options and support the development of a scope of work and project budget for HVAC system and roof improvements. This request recognizes unanticipated revenue from the Federal government. 6.) Transfer $450,000 from the American Recovery Plan Reserve to the Development & Public Works Department, Operations Dvision for the roof replacement at the Springfield Justice Center. This request recognizes unanticipated revenue from the Federal government. 7.) Transfer $200,000 from the American Recovery Plan Reserve to the Development & Public Works Department, Operations Division to install a comprehensive security camera system at City Hall to address security issues. This request recognizes unanticipated revenue from the Federal government. 8.) Transfer $950,000 from the American Recovery Plan Reserve to the Development & Public Works Department, Operations Division to support the City Hall Library remodel. The project will address the need for modernized and more accessible meeting/programming space along with improvements to the teen and children's area. This request recognizes unanticipated revenue from the Federal government. 9.) Transfer $150,000 from the American Recovery Plan Reserve to the Development & Public Works Department, Operations Division to increase security in the Council Chambers. This request recognizes unanticipated revenue from the Federal government. 10.) Transfer $1,000,000 from the American Recovery Plan Reserve to the Finance Department operating expense to provide for the pass thin of $1M to Willamalane Parks and Recreation as agreed to by City Council. This request recognizes unanticipated revenue from the Federal government. 11.) Increase Library appropriations by $29,653 in order to recognize grant revenue not anticipated during development of the adopted budget. The Library received additional funding from LCOL libraries to purchase downloadable books ($3,295). The library received a Lane Arts Council grant for our Dia de los Muertos programming ($960.23). The Mills Davis grant was awarded after the budget was complete for the year; because of the size of the grant, we did not budget for it until received ($25,398). 12.) Increase Library appropriations by $2,971 in order to recognize grant revenue not anticipated during development of the adopted budget. The department budgeted $7,000 for funding that comes from the State Ready to Read program that supports youth literacy for Springfield residents. Instead, the department received $9,972 this year. 13.) Increase Library appropriations by $3,000 in order to recognize grant revenue not anticipated during development of the adopted budget. This fiscal year the Library anticipated a $7,000 grant amount but was awarded $10,000. These funds support the library's summer reading programming. 14.) Increase Library appropriations by $1,000 in order to recognize donation revenue not anticipated during development of the adopted budget. A community donation of $1,000 was received in FY22 that will be used for printer replacement/repair in the museum. 15.) Increase Library appropriations by $6,500 in order to recognize grant revenue not anticipated during development of the adopted budget. The Library was awarded two grants from the Network of the National Library of Medicine administered through the University of Washington. The Collection Equity Outreach Award will be used to increase the current health collection (in both English and Spanish) and the Technology Equity Award will be used to purchase equipment and software to add adaptive technology to aid in providing services for the blind and/ or developmentally disabled population. 16.) Increase Police Department appropriations by $2,957 in order to recognize donation revenue not anticipated during development of the adopted budget. The funds can be used for up to 50% of the cost of a bulletproof vest meeting award requirements. 17.) Carryforward Police Department appropriations from the prior year totalling $22,752 for replacement of equipment approved within the FY21 budget not complete until FY22. Equipment availability and supply chain issues delayed receipt of red dot sights until August 2021. Equipment selection and staff resource impacted the delayed purchase of Forward Looking Infra -Red (FLIR) equipment. Both equipment purchases were approved using forfeiture funds in FY21. 18.) Increase the Development & Public Works capital expense by $40,000 in order to recognize $27,000 in grant revenue from the Federal Emergency Management Agency (FEMA), and a $13,000 contribution from Lane County to support the preparation of an Emergency Action Plan for the 42nd Street Levee. Attachment 2, Page 2 of 7 FY22 Supplemental Supplemental Supplemental Transfers & FY22 Special Revenue Fund - 204 Adopted Budget Budget 1 Budget 2 Budget 3 Adjustments Revised Budget Department Operating City Manager's Office $ 38,230 $ 53,011 $ - $ 35,000 $ - $ 126,241 (1) Development & Public Works 93,345 488,576 - 4,701,745 - 5,283,666 (2-9) Information Technology 20,000 - - - - 20,000 Finance - - - 1,000,000 - 1,000,000 (10) Fire and Life Safety - 630,000 - - - 630,000 Library 84,154 71,662 - 43,125 79,500 278,441 (11-15) Police 134,000 176,342 25,709 336,051 (16-17) Total Department Operating 369,729 1,419,591 5,805,579 79,500 7,674,399 Total Development & Public Works Capital Projects 40,000 40,000 (18) Non -Departmental Reserves* 1,657,994 (1,063,768) 6,978,111 (5,580,000) 1,992,337 (1 &4-10) Total Non -Departmental 1,657,994 (1,063,768) 6,978,111 (5,580,000) 1,992,337 Total Special Revenue Fund $ 2,027,723 $ 355,823 $ 6,978,111 $ 265,579 $ 79,500 $ 9,706,736 Special Revenue Fund Commentary: 1.) Transfer $35,000 from the American Recovery Plan Reserve to the City Manager's Office operating expense to provide appropriations to support Springfield's share of costs for a consultant to complete a financial analysis of the functionally merged Eugene -Springfield Fire and Life Safety Department. The purpose of the analysis is to help inform the governing bodies of each repective City of the cost/benefits of different potential future configurations of the department. This request recognizes unanticipated revenue from the Federal government. 2.) Recognize $76,800 in grant revenue from the Department of Land Conservation & Development (DLCD) and increase appropriations in the Development & Public Works Department, Community Development (CMD) Division to support the Comprehensive Plan Map Project. The purpose of the Comprehensive Plan Map Project is to create a property -specific Comprehensive Plan Map for the City of Springfield. This map will add greater certainty to ambiguous plan designations. This request recognizes unanticipated revenue from the State government. 3.) Recognize $79,945 in grant revenue from the DLCD and increase appropriations in the Development & Public Works Department, Community Development (CMD) Division for Natural Resource Protection in the Urban Growth Boundary Expansion Areas. This is a continuation of previous CMD work identified in the Comprehensive Planning Work Program. This first phase of this project started in FY21, and was completed in FY22. This second grant will allow for additional consulting services and community outreach. This request recognizes unanticipated revenue from the State government. 4.) Transfer $2,750,000 from the American Recovery Plan Reserve to the Development & Public Works Department, Operations Division to provide for City wide legacy street light replacement using modern LED fixtures. This request recognizes unanticipated revenue from the Federal government. 5.) Transfer $45,000 from the American Recovery Plan Reserve to the Development & Public Works Department, Operations Division to support an engineering analysis of the City Hall heating, ventilation, an -conditioning (HVAC) system. The purpose of the analysis is to inform replacement options and support the development of a scope of work and project budget for HVAC system and roof improvements. This request recognizes unanticipated revenue from the Federal government. 6.) Transfer $450,000 from the American Recovery Plan Reserve to the Development & Public Works Department, Operations Dvision for the roof replacement at the Springfield Justice Center. This request recognizes unanticipated revenue from the Federal government. 7.) Transfer $200,000 from the American Recovery Plan Reserve to the Development & Public Works Department, Operations Division to install a comprehensive security camera system at City Hall to address security issues. This request recognizes unanticipated revenue from the Federal government. 8.) Transfer $950,000 from the American Recovery Plan Reserve to the Development & Public Works Department, Operations Division to support the City Hall Library remodel. The project will address the need for modernized and more accessible meeting/programming space along with improvements to the teen and children's area. This request recognizes unanticipated revenue from the Federal government. 9.) Transfer $150,000 from the American Recovery Plan Reserve to the Development & Public Works Department, Operations Division to increase security in the Council Chambers. This request recognizes unanticipated revenue from the Federal government. 10.) Transfer $1,000,000 from the American Recovery Plan Reserve to the Finance Department operating expense to provide for the pass thin of $1M to Willamalane Parks and Recreation as agreed to by City Council. This request recognizes unanticipated revenue from the Federal government. 11.) Increase Library appropriations by $29,653 in order to recognize grant revenue not anticipated during development of the adopted budget. The Library received additional funding from LCOL libraries to purchase downloadable books ($3,295). The library received a Lane Arts Council grant for our Dia de los Muertos programming ($960.23). The Mills Davis grant was awarded after the budget was complete for the year; because of the size of the grant, we did not budget for it until received ($25,398). 12.) Increase Library appropriations by $2,971 in order to recognize grant revenue not anticipated during development of the adopted budget. The department budgeted $7,000 for funding that comes from the State Ready to Read program that supports youth literacy for Springfield residents. Instead, the department received $9,972 this year. 13.) Increase Library appropriations by $3,000 in order to recognize grant revenue not anticipated during development of the adopted budget. This fiscal year the Library anticipated a $7,000 grant amount but was awarded $10,000. These funds support the library's summer reading programming. 14.) Increase Library appropriations by $1,000 in order to recognize donation revenue not anticipated during development of the adopted budget. A community donation of $1,000 was received in FY22 that will be used for printer replacement/repair in the museum. 15.) Increase Library appropriations by $6,500 in order to recognize grant revenue not anticipated during development of the adopted budget. The Library was awarded two grants from the Network of the National Library of Medicine administered through the University of Washington. The Collection Equity Outreach Award will be used to increase the current health collection (in both English and Spanish) and the Technology Equity Award will be used to purchase equipment and software to add adaptive technology to aid in providing services for the blind and/ or developmentally disabled population. 16.) Increase Police Department appropriations by $2,957 in order to recognize donation revenue not anticipated during development of the adopted budget. The funds can be used for up to 50% of the cost of a bulletproof vest meeting award requirements. 17.) Carryforward Police Department appropriations from the prior year totalling $22,752 for replacement of equipment approved within the FY21 budget not complete until FY22. Equipment availability and supply chain issues delayed receipt of red dot sights until August 2021. Equipment selection and staff resource impacted the delayed purchase of Forward Looking Infra -Red (FLIR) equipment. Both equipment purchases were approved using forfeiture funds in FY21. 18.) Increase the Development & Public Works capital expense by $40,000 in order to recognize $27,000 in grant revenue from the Federal Emergency Management Agency (FEMA), and a $13,000 contribution from Lane County to support the preparation of an Emergency Action Plan for the 42nd Street Levee. Attachment 2, Page 2 of 7 Transient Room Tax Fund - 208 Department Operating City Manager's Office Development & Public Works Library Total Department Operating 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 Community Development Fund Commentary: - No current activity. FY22 Supplemental Adopted Budget Budeet 1 $ 233,162 $ - $ 24,909 264,048 _ 522,119 Supplemental Supplemental Budget 2 Budget 3 S Transfers & FY22 Adjustments Revised Budeet 233,162 24,909 264,048 522,119 750,000 - - - - 750,000 866,491 468,322 1,334,813 1,616,491 468,322 2,084,813 $ 2,138,610 $ 468,322 $ - $ - $ - $ 2,606,932 Appropriations FY22 Supplemental Supplemental Supplemental Transfers & FY22 Adopted Budget Budeet 1 Budget 2 Budeet 3 Adjustments Revised Budeet $ 2,071,567 $ 48,509 $ - $ - $ - $ 2,120,076 24,590 24,590 2,096,157 48,509 2,144,666 823,665 (497,653) 326,012 823,665 (497,653) 326,012 $ 2,919,822 $ (449,144) $ - $ - $ - $ 2,470,678 Fire Local Option Levy Fund Commentary 1.) See General Fund Commentary #2. Attachment 2, Page 3 of 7 Appropriations Appropriations FY22 Supplemental Supplemental Supplemental Transfers & FY22 Building Code Fund - 224 Adopted Budeet Budget 1 Budget 2 Budeet 3 Adjustments Revised Budget Department Operating Budget 3 Adjustments Revised Budeet Department Operating City Manager's Office $ 21,742 $ - $ - $ - $ - $ 21,742 Development & Public Works 1,266,115 97,500 - 48,000 - 1,411,615 (1) Fire & Life Safety 80,701 1,589,299 80,701 Total Department Operating 1,368,558 97,500 48,000 1,514,058 Non -Departmental Reserves* Reserves* 3,017,754 140,829 (48,000) 3,110,583 (1) Total Non -Departmental 3,017,754 140,829 (48,000) 3,110,583 1,381,979 Total Building Fund $ 4,386,312 $ 238,329 $ - $ - $ - $ 4,624,641 Building Code Fund Commentary: 1.) Increase appropriations in the Development & Public Works Department, Community Development (CMD) Division by $98,000 to accommodate merchant fee expenses which have been greater than anticipated. The planning and development center has seen drastic increases in the number of permits and applications being filled out and paid for via credit card. This request is for an increase in the Development & Public Works operating expense of $48,000 from the Budding Fund, $18,000 from the Street Capital Food, and $32,000 from the Sanitary Sewer Fund. Fire Local Option Levy Fund Commentary 1.) See General Fund Commentary #2. Attachment 2, Page 3 of 7 Appropriations FY22 Supplemental Supplemental Supplemental Transfers & FY22 Fire Local Ontion Levy Fund - 235 Adopted Budget Budeet 1 Budeet 2 Budget 3 Adjustments Revised Budeet Department Operating Fire and Life Safety $ 1,589,299 $ 20,294 $ $ 22,398 $ - $ 1,631,991 (1) Total Department Operating 1,589,299 20,294 22,398 1,631,991 Non -Departmental Reserves* 1,333,028 48,951 1,381,979 Total Non -Departmental 1,333,028 48,951 1,381,979 Total Fire Local Option Levy Fund $ 2,922,327 $ 69,245 $ - $ 22,398 $ - $ 3,013,970 Fire Local Option Levy Fund Commentary 1.) See General Fund Commentary #2. Attachment 2, Page 3 of 7 Bond Sinking Fund Commentary - No current activity. Appropriations Appropriations Supplemental Supplemental Supplemental Transfers & FY22 FY22 Supplemental Supplemental Supplemental Transfers & FY22 Police Local Option Levy Fund - 236 Adopted Budget Budget 1 Budget 2 Budget 3 Adjustments Revised Budget Department Operating $ - $ 3,678,700 (1) Total Department Operating 1,132,000 2,010,000 536,700 3,678,700 Total Development & Public Works Capital Projects Finance $ 687,452 $ - $ - $ - $ - $ 687,452 Legal Services 89,700 - - - - 89,700 Legal Services $ 6,839,951 $ (2,800) $ - $ - $ - 6,839,951 Total Department Operating 7,617,103 7,617,103 - No current activity. Non -Departmental Reserves* 1,953,525 583,665 Appropriations 2,537,190 Total Non -Departmental supplemental 1,953,525 583,665 Transfers & FY22 2,537,190 Total Police Local Option Levy Fund $ 9,570,628 $ 583,665 $ - $ - $ - $ 10,154,293 Police Local Option Levy Fund Commentary: Total Development & Public Works Capital Projects $ 305,892 - No current activity. - $ - $ - $ 305,892 Non -Departmental Interfund Loan Appropriations 1,500,000 $ - - FY22 Supplemental Supplemental Supplemental Transfers & FY22 Bond Sinking Fund - 306 Adopted Budget Budget 1 Budget 2 Budget 3 Adjustments Revised Budget Non -Departmental (240,079) 5,144,577 Total Development Projects Fund $ 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 Sinking Fund $ 4,530,970 $ 59,638 $ - $ - $ - $ 4,590,608 Bond Sinking Fund Commentary - No current activity. Development Projects Fund Commentary: - No current activity. Appropriations Appropriations Supplemental Supplemental Supplemental Transfers & FY22 FY22 Supplemental Supplemental Supplemental Transfers & FY22 Development Assessment Fund - 419 Adopted Budget Budget 1 Budget 2 Budget 3 Adjustments Revised Budget Non -Departmental $ - $ 3,678,700 (1) Total Department Operating 1,132,000 2,010,000 536,700 3,678,700 Total Development & Public Works Capital Projects 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. Appropriations FY22 supplemental Supplemental Supplemental Transfers & FY22 Adopted Budget Budget 1 Budget 2 Budget 3 Adjustments Revised Budget Development Projects Fund - 420 Total Development & Public Works Capital Projects $ 305,892 $ - $ - $ - $ - $ 305,892 Non -Departmental 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. Non -Departmental Transfers 23,172 - - - - 23,172 Reserves* 63,194,374 1,258,101 (536,700) 63,915,775 (1) Total Non -Departmental 63,217,546 1,258,101 (536,700) 63,938,947 Total Regional Wastewater Capital Fund $ 86,049,546 $ 6,284,824 $ $ - $ - $ 92,334,370 Regional Wastewater Capital Fund Commentary: 1.) Increase Development & Public Works operating expense by $536,700 to increase the budget for Screw Pump Wet Wells concrete rehab work with a corresponding decrease to the Capital Reserve. The Screw Pump Wet Wells rehab project was completed in July 2021, and the expenses were budgeted in FY22, so the budget is being carried forward. Attachment 2, Page 4 of 7 Appropriations FY22 Supplemental Supplemental Supplemental Transfers & FY22 Regional Wastewater Capital Fund - 433 Adopted Budget Budget 1 Budget 2 Budget 3 Adjustments Revised Budget Department Operating Development & Public Works $ 1,132,000 $ 2,010,000 $ $ 536,700 $ - $ 3,678,700 (1) Total Department Operating 1,132,000 2,010,000 536,700 3,678,700 Total Development & Public Works Capital Projects 21,700,000 3,016,723 24,716,723 Non -Departmental Transfers 23,172 - - - - 23,172 Reserves* 63,194,374 1,258,101 (536,700) 63,915,775 (1) Total Non -Departmental 63,217,546 1,258,101 (536,700) 63,938,947 Total Regional Wastewater Capital Fund $ 86,049,546 $ 6,284,824 $ $ - $ - $ 92,334,370 Regional Wastewater Capital Fund Commentary: 1.) Increase Development & Public Works operating expense by $536,700 to increase the budget for Screw Pump Wet Wells concrete rehab work with a corresponding decrease to the Capital Reserve. The Screw Pump Wet Wells rehab project was completed in July 2021, and the expenses were budgeted in FY22, so the budget is being carried forward. Attachment 2, Page 4 of 7 Street Capital Fund - 434 Department Operating Development & Public Works Total Department Operating Total Development & Public Works Capital Projects Non -Departmental Reserves* Total Non -Departmental Total Street Capital Fund Street Capital Fund Commentary: 1.) See Budding Code Fund Commentary #1. Sanitary Sewer Operations Fund - 611 Department Operating City Manager's Office Development & Public Works Finance Information Technology Total Department Operating Total Development & Public Works Capital Projects Non -Departmental Debt Service Reserves* Total Non -Departmental Total Sewer Operations Fund Sanitary Sewer Operations Fund Commentary: 1.) See Building Code Fund Commentary # 1. 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 7,368,537 (3,474,623) (18,000) 3,875,914 (1) 7,368,537 (3,474,623) (18,000) 3,875,914 $ 10,438,917 $ 1,498,777 $ 955,000 $ - $ - $ 12,892,694 Appropriations FY22 Supplemental Supplemental Supplemental Transfers & FY22 Appropriations FY22 Supplemental Supplemental Supplemental Transfers & FY22 Adopted Budget Budget 1 Budeet 2 Budget 3 Adjustments Revised Budget $ 148,026 $ - $ - $ 18,000 $ - $ 166,026 (1) 148,026 $ - $ - 18,000 166,026 2,922,354 4,973,400 955,000 - 8,850,754 7,368,537 (3,474,623) (18,000) 3,875,914 (1) 7,368,537 (3,474,623) (18,000) 3,875,914 $ 10,438,917 $ 1,498,777 $ 955,000 $ - $ - $ 12,892,694 10,550,000 - - (136,616) - 10,413,384 (1) 4,110,375 - - - - 4,110,375 10,802,255 2,331,026 155,727 13,289,008 (1) 25,462,630 2,331,026 19,111 27,812,767 $ 46,131,641 $ 2,452,034 $ - $ 19,111 $ - $ 48,602,786 Regional Wastewater Fund Commentary: 1.) Increase $19,111 in beginning cash, with a corresponding increase to operating reserve. Decrease the required loan reserve for MWMC SRF loan, this was budgeted as $186,616 but was reduced to $50,000. As the loan reserve decreases, the offset is to the operating reserve. Both of these items were presented to the MWMC commission on 12/10/2021 and approved on MWMC resolution 21-10. Appropriations FY22 Supplemental Supplemental Supplemental Transfers & FY22 Appropriations Budeet 3 Adiustments Revised Budeet FY22 Supplemental Supplemental Supplemental Transfers & FY22 Adopted Budget Budeet 1 Budget 2 Budget 3 Adjustments Revised Budget $ 81,550 $ - $ - $ - $ - $ 81,550 4,852,271 - - 32,000 - 4,884,271 (1) 53,109 - - - - 53,109 375,942 15,300 391,242 5,362,871 15,300 32,000 5,410,171 9,296,600 1,700,000 10,996,600 1,707,800 - - - - 1,707,800 23,308,457 (1,603,311) (32,000) 21,673,146 (1) 25,016,257 (1,603,311) (32,000) 23,380,946 $ 39,675,728 $ 111,989 $ - $ - $ - $ 39,787,717 Aooroorlations FY22 Supplemental Supplemental Supplemental Transfers & FY22 Adopted Budget Budget 1 Budget 2 Budget 3 Adjustments 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 - - (136,616) - 10,413,384 (1) 4,110,375 - - - - 4,110,375 10,802,255 2,331,026 155,727 13,289,008 (1) 25,462,630 2,331,026 19,111 27,812,767 $ 46,131,641 $ 2,452,034 $ - $ 19,111 $ - $ 48,602,786 Regional Wastewater Fund Commentary: 1.) Increase $19,111 in beginning cash, with a corresponding increase to operating reserve. Decrease the required loan reserve for MWMC SRF loan, this was budgeted as $186,616 but was reduced to $50,000. As the loan reserve decreases, the offset is to the operating reserve. Both of these items were presented to the MWMC commission on 12/10/2021 and approved on MWMC resolution 21-10. Attachment 2, Page 5 of 7 Appropriations FY22 Supplemental Supplemental Supplemental Transfers & FY22 Ambulance Fund - 615 Adopted Budget Budeet 1 Budeet 2 Budeet 3 Adiustments Revised Budeet Department Operating Fire and Life Safety $ 6,681,492 $ $ $ 328,631 $ - $ 7,010,123 (1-4) Total Department Operating 6,681,492 328,631 7,010,123 Non -Departmental Reserves* _ 737,000 737,000 (3) Total Non -Departmental 737,000 737,000 Total Ambulance Fund $ 6,681,492 $ - $ - $ 1,065,631 $ - $ 7,747,123 Ambulance Fund Commentary: 1.) See General Fund Commentary #2. 2.) Recognize $7,721 in unamiciapted revenue from Lane County for COVID-19 vaccination clincs and increase appropriations in the Fire and Life Safety Department for additional spending authority. 3.) Recognize $1,021,000 in unanticipated revenue from the Ground Emergency Medical Transport (GEMT) program, increase Fire & Life Safety operating expense by $284,000, and increase operating reserve by $737,000. 4.) Recognize $30,000 in unanticipated revenue from the medic standby staffing of special events and increase appropriations in the Fire and Life Safety Department for additional spending authority. Attachment 2, Page 5 of 7 Storm Drainage Operating Fund Commentary: - No current activity. Appropriations Appropriations FY22 Supplemental Supplemental Supplemental Transfers & FY22 Storm Drainage Operating Fund - 617 Adopted Budget Budeet 1 Budget 2 Budeet 3 Adjustments Revised Budget Department Operating Budget 3 Adjustments Revised Budget Department Operating City Manager's Office $ 81,991 $ - $ - $ - $ - $ 81,991 Development & Public Works 6,652,919 250,000 - - - 6,902,919 Finance 53,110 - - - - 53,110 Information Technology 284,421 13,050 297,471 Total Department Operating 7,072,441 263,050 7,335,491 Total Development & Public Works Capital Projects 6,517,370 300,000 6,817,370 Non -Departmental 80,651 - - - Debt Service 551,643 - - - - 551,643 Reserves* 17,391,341 (1,825,812) 15,565,529 Total Non -Departmental 17,942,984 (1,825,812) 16,117,172 Total Drainage Operating Fund $ 31,532,795 $ (1,262,762) $ - $ - $ - $ 30,270,033 Storm Drainage Operating Fund Commentary: - No current activity. Booth -Kelly Fund Commentary: 1.) Increase appropriations in the Development & Public Works Department, Operations Division by $250,000 from Booth -Kelly Operating Reserves for a facility assessment and possible demolition of the Carter Building. The building has suffered a significant structural failure impacting the roof and building structure. This request responds to a pressing necessitythat requires prompt action. Appropriations Appropriations FY22 Supplemental Supplemental Supplemental Transfers & FY22 Booth -Kelly Fund - 618 Adopted Budget Budget 1 Budget 2 Budget 3 Adjustments Revised Budget Department Operating Budeet 1 Budeet 2 Budeet 3 Adjustments Development & Public Works $ 503,822 $ $ $ 250,000 $ - $ 753,822 (1) Total Department Operating 503,822 250,000 753,822 Total Development & Public Works Capital Projects 190,000 $ $ - 190,000 Non -Departmental 211,150 Transfers 80,651 - - - - 80,651 Reserves* 1,184,293 273,327 (250,000) 1,207,620 (1) Total Non -Departmental 1,264,944 273,327 (250,000) 1,288,271 Total Booth -Kelly Fund $ 1,958,766 $ 273,327 $ $ - $ - $ 2,232,093 Booth -Kelly Fund Commentary: 1.) Increase appropriations in the Development & Public Works Department, Operations Division by $250,000 from Booth -Kelly Operating Reserves for a facility assessment and possible demolition of the Carter Building. The building has suffered a significant structural failure impacting the roof and building structure. This request responds to a pressing necessitythat requires prompt action. Insurance Fund Commentary - No current activity. Attachment 2, Page 6 of 7 Appropriations FY22 Supplemental Supplemental Supplemental Transfers & FY22 Regional Fiber Consortium - 629 Adopted Budget Budeet 1 Budeet 2 Budeet 3 Adjustments Revised Budeet 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. Appropriations FY22 Supplemental Supplemental Supplemental Transfers & FY22 Insurance Fund - 707 Adopted Budeet Budget 1 Budget 2 Budget 3 Adjustments Revised Budget Department Operating 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* 10,646,682 869,247 11,515,929 Total Non -Departmental 10,646,682 869,247 11,515,929 Total Insurance Fund $ 22,726,011 $ 869,247 $ - $ - $ - $ 23,595,258 Insurance Fund Commentary - No current activity. Attachment 2, Page 6 of 7 Vehicle and Equipment Fund Commentary: 1.) Increase Development & Public Works Department, Community Development Division operating expense by $38,250 for technology replacement. The techonolgy replacement includes: a copier/printer in the SE Quad of CMD failed before it's expected date, several laptops that were unable to be ordered last fiscal year due to supply chain shortages that are ready now, and a small scanner. 2.) Increase Development & Public Works Department, Operations Division operating expense by $4,100 to allow for the purchase of a laptop. Laptop #01374 is past its useful life and needs replaced. It was determined by the IT department that the computer was not repairable and needed to be replaced. 3.) Increase Development & Public Works Department, Operations Division operating expense by $2,400 to allow for the purchase a new laptop. Operations has created anew safety and training coordinator and now needs to purchase a laptop for this position. 4.) Increase Information Technology Department operating expense by $250,000 to allow for the replacement of server hardware which supports the function of the City's network. This server hardware should be replaced on a five-year cycle and the current hardware is six years old. Due to staffing changes in the IT department the need for this replacement was not known at the time of budget development. 5.) Increase Information Technology Department operating expense by $4,500 to allow for the purchase of Stancil software that is used to record telephone and radio communications for Police Dispatch. The Stancil software must be integrated with the new Mitel telephone system to adhere to City HIPAA requirements. Details regarding this requirement were unknown during budget development and more research was needed. That research is now complete and the Stancil/Mitel integration work has been scoped. Appropriations Appropriations FY22 FY22 Supplemental Supplemental Supplemental Transfers & FY22 Adopted Budget Vehicle and Equipment Fund - 713 Adopted Budget Budget 1 Budget 2 Budget 3 Adjustments Revised Budget Department Operating Development & Public Works $ 412,155 $ - $ - $ - $ - Development & Public Works $ 2,144,200 $ 329,163 $ - $ 44,750 $ - $ 2,518,113 (1-3) Fire & Life Safety 139,900 1,095,700 - - - 1,235,600 Total Department Operating Human Resources - 4,000 - - - 4,000 Information Technology 775,704 - - 254,500 - 1,030,204 (4-5) Library 8,000 - - - - 8,000 Police 307,000 127,487 $ 66,590 $ 434,487 $ 811,775 Total Department Operating 3,374,804 1,556,350 299,250 5,230,404 - No current activity. Non -Departmental TOTAL RESOLUTION $ 352,130,510 Transfers - 27,500 - - 27,500 Reserves* 8,376,051 (117,159) (299,250) 7,959,642 (1-5) Total Nan -Departmental 8,376,051 (89,659) (299,250) 7,987,142 Total Vehicle and Equipment Fund $ 11,750,855 $ 1,466,691 $ - $ - $ - $ 13,217,546 Vehicle and Equipment Fund Commentary: 1.) Increase Development & Public Works Department, Community Development Division operating expense by $38,250 for technology replacement. The techonolgy replacement includes: a copier/printer in the SE Quad of CMD failed before it's expected date, several laptops that were unable to be ordered last fiscal year due to supply chain shortages that are ready now, and a small scanner. 2.) Increase Development & Public Works Department, Operations Division operating expense by $4,100 to allow for the purchase of a laptop. Laptop #01374 is past its useful life and needs replaced. It was determined by the IT department that the computer was not repairable and needed to be replaced. 3.) Increase Development & Public Works Department, Operations Division operating expense by $2,400 to allow for the purchase a new laptop. Operations has created anew safety and training coordinator and now needs to purchase a laptop for this position. 4.) Increase Information Technology Department operating expense by $250,000 to allow for the replacement of server hardware which supports the function of the City's network. This server hardware should be replaced on a five-year cycle and the current hardware is six years old. Due to staffing changes in the IT department the need for this replacement was not known at the time of budget development. 5.) Increase Information Technology Department operating expense by $4,500 to allow for the purchase of Stancil software that is used to record telephone and radio communications for Police Dispatch. The Stancil software must be integrated with the new Mitel telephone system to adhere to City HIPAA requirements. Details regarding this requirement were unknown during budget development and more research was needed. That research is now complete and the Stancil/Mitel integration work has been scoped. *Reserves and Unappropriated Ending Fund Balance are not appropriated for spending and are shown for information purposes only. Attachment 2, Page 7 of 7 Appropriations FY22 Supplemental Supplemental Supplemental Transfers & FY22 SDC Administration Fund - 719 Adopted Budget Budget 1 Budget 2 Budget 3 Adjustments Revised Budget Department Operating Development & Public Works $ 412,155 $ - $ - $ - $ - $ 412,155 Finance 39,222 - - - - 39,222 Information Technology 69,604 450 70,054 Total Department Operating 520,980 450 521,430 Non -Departmental Reserves* 224,205 66,140 290,345 Total Non -Departmental 224,205 66,140 290,345 Total SDC Administration Fund $ 745,185 $ 66,590 $ $ - $ - $ 811,775 SDC Administration Fund Commentary: - No current activity. TOTAL RESOLUTION $ 352,130,510 $ 15,049,148 7,933,111 1,441,627 $ 79,500 $ 376,633,896 *Reserves and Unappropriated Ending Fund Balance are not appropriated for spending and are shown for information purposes only. Attachment 2, Page 7 of 7