Loading...
HomeMy WebLinkAboutItem 10 Supplemental Budget Resolution AGENDA ITEM SUMMARY Meeting Date: 10/17/2016 Meeting Type: Regular Meeting Staff Contact/Dept.: Paula Davis/Finance Staff Phone No: 541.726.3698 Estimated Time: 10 Minutes S P R I N G F I E L D C I T Y C O U N C I L Council Goals: Provide Financially Responsible and Innovative Government Services ITEM TITLE: SUPPLEMENTAL BUDGET RESOLUTION ACTION REQUESTED: 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, Transient Room Tax, Community Development, Building Code, Fire Local Option Levy, Police Local Option Levy, Bancroft Redemption, Bond Sinking, Regional Wastewater Revenue Bond Capital Project, Development Assessment Capital, Development Projects, Regional Wastewater Capital, Street Capital, Sanitary Sewer Operations, Regional Wastewater, Ambulance, Storm Drainage Operations, Storm Drainage Operations, Storm Drainage Operations, Storm Drainage Operations, Storm Drainage Operations, Booth-Kelly, Regional Fiber Consortium, Insurance, Vehicle & Equipment, and SDC Administration funds. ISSUE STATEMENT: 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 on an annual basis. This is the first of three scheduled FY17 supplemental budget requests to come before Council. The supplemental budget being presented includes adjusting resources and requirements in General, Street, Special Revenue, Transient Room Tax, Community Development, Building Code, Fire Local Option Levy, Police Local Option Levy, Bancroft Redemption, Bond Sinking, Regional Wastewater Revenue Bond Capital Project, Development Assessment Capital, Development Projects, Regional Wastewater Capital, Street Capital, Sanitary Sewer Operations, Regional Wastewater, Ambulance, Storm Drainage Operations, Storm Drainage Operations, Storm Drainage Operations, Storm Drainage Operations, Storm Drainage Operations, Booth-Kelly, Regional Fiber Consortium, Insurance, Vehicle & Equipment, and SDC Administration funds. The City Council is asked to approve the attached Supplemental Budget Resolution. ATTACHMENTS: Attachment 1. Council Briefing Memorandum Attachment 2. Supplemental Budget Resolution DISCUSSION/ FINANCIAL IMPACT: The overall financial impact of the Supplemental Budget Resolution is to increase capital projects by $2,586,953 and the unappropriated ending fund balance by $31,373. These effects are offset by beginning cash adjustments of $11,684,061, reserve increases of $10,730,115, revenue erratum of $360,989, decreases in operating expenditures of $1,914,570, and decreases in interfund transfers of $57,088. M E M O R A N D U M City of Springfield Date: 10/17/2016 To: Gino Grimaldi COUNCIL From: Bob Duey and Paula Davis BRIEFING Subject: SUPPLEMENTAL BUDGET REQUEST MEMORANDUM ISSUE: At various times during the fiscal year, the Council is requested to make adjustments to the annual budget to reflect needed changes in planned activities, to recognize new revenues, or to make other required adjustments. These adjustments to resources and requirements change the current budget and are processed through supplemental budget requests scheduled by the Finance Department on an annual basis. This is the first of three scheduled FY17 supplemental budget requests to come before Council. The supplemental budget being presented includes adjusting resources and requirements in the General, Street, Special Revenue, Transient Room Tax, Community Development, Building Code, Fire Local Option Levy, Police Local Option Levy, Bancroft Redemption, Bond Sinking, Regional Wastewater Revenue Bond Capital Project, Development Assessment Capital, Development Projects, Regional Wastewater Capital, Street Capital, Sanitary Sewer Operations, Regional Wastewater, Ambulance, Storm Drainage Operations, Storm Drainage Operations, Storm Drainage Operations, Storm Drainage Operations, Storm Drainage Operations, Booth- Kelly, Regional Fiber Consortium, Insurance, Vehicle & Equipment, and SDC Administration funds. 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; however, the City of Springfield practice has been to process all supplemental budget requests through a public hearing for Council’s approval and adoption. Notification of this public hearing was published in the Springfield Times on Thursday, October 6, 2016. The attached information identifies the individual items that are included in the October 17, 2016 Supplemental Budget request. Changes to the budget included in this request fall into three general categories: reallocation of existing resources, re-appropriations or carryovers, and new appropriation requests. Reallocations move existing approved budget authority between funds or between departments. These adjustments can include reallocating reserves within a fund and beginning cash adjustments. Attachment 1, Page 1 of 13 Re-appropriations or carryovers represent money that was committed by contract in the previous year but the contracted work was not completed within the fiscal year. The prior year’s remaining budget amount needs to be appropriated into this year’s budget to allow final payments to be made in the current year. Re-appropriations also may include money for capital projects that were planned but not completed in the prior year. The projects are still scheduled and funds are being carried forward to the current year’s budget. New appropriation requests include both expenditure items that are funded by new revenue, such as a new grant, and expenditure items that are being requested to be funded out of reserves. Those requests funded from reserves include items implementing Council direction, emerging issues identified by the City Executive Team that need to be resolved immediately or to meet legal requirements. SUPPLEMENTAL BUDGET REQUESTS BY FUNDS In the proceeding fund tables, requests will be reflected in two separate columns - one for adjustments and carryovers and a second for new requests. The intent of this format is to separate items that are strictly housekeeping efforts from requests for program changes. All funds Beginning Cash adjustments total $11,684,061. Usually Beginning Cash adjustments occur because prior year expenses were not as great as predicted, resulting in more money being available in the new year. When Beginning Cash is greater than expected, the balance is normally placed in Reserves. The largest Beginning Cash adjustments usually occur when the completion status of capital projects are adjusted to reflect progress made during the previous fiscal year. In February or March, the budget preparers attempt to estimate the status of their capital projects as of the end of the fiscal year (June 30), but a variety of factors can result in projects being ahead or behind schedule. Beginning cash adjustment is reflected in the proceeding tables in the beginning cash line under the “Adjustment & Carryovers” column. The net effect of all adjustments is reflected as a total in the reserve line. FY17 Supplemental Budget Request 1 Page 2 of 13 General Fund – The proceeding table shows the impact of all General Fund requests on the FY17 amended budget. The numbers at the right of the table correspond to the description of the request that are below the table. FY17 Adopted Budget Adjustment & Carryovers New Request Amended Budget Resources FY17 Adopted Resources 44,201,023$ 44,201,023$ Beginning Cash 352,787 352,787 Total General Fund 44,201,023$ 44,553,810$ Requirements FY17 Adopted Operating Budget 35,466,540$ 35,466,540$ Finance (39,888) (39,888) (1) Fire & Life Safety 30,000 30,000 (2) Human Resourcers 98,395 98,395 (3) Information Technology 43,608 43,608 (4) Legal Judicial Services 283,472 283,472 (5) Library 2,508 2,508 (6) Total Operating Budget 35,884,635$ Non-Departmental Expenses: Transfers 411,300$ 4,201 415,501$ (7) Debt Service 532,740 532,740 Contingency 1,000,000 1,000,000 Reserves 6,790,443 (69,509) 6,720,934 Total Non-Departmental 8,734,483$ 8,669,175$ (1-7) Total General Fund 44,201,023$ 44,553,810$ General F100 1. Request reappropriates unspent project funds for Neubrain and Board budget software implementation and the transfer of funding for a 1.0 FTE Human Resource Analyst from the Finance Dept to the Human Resources Dept. 2. Request reallocates unspent funds intended to pay for equipment and implementation of Internet Protocol (IP) Alerting system for fire stations. 3. Request reallocates funds associated with transfer of employee from Finance Department to Human Resources Department. 4. Request reallocates funds to retain software maintenance assurance for database conversion and to upgrade network infrastructure and purchase a secure information transfer appliance. 5. Request utilizes reserve funds to repay overpayment to CenturyLink as mandated in CenturyLink vs. City of Springfield. 6. Request reappropriates reserve funds for FY17 book expenditures. 7. Request transfers funds from General Fund reserves to F201 to correct an FY16 budgetary erratum for right-of-way use fees. FY17 Supplemental Budget Request 1 Page 3 of 13 Street Funds – The proceeding table shows the impact of all Street Funds requests on the FY17 amended budget. The numbers at the right of the table correspond to the description of the request that are below the table. FY17 Adopted Budget Adjustment & Carryovers New Request Amended Budget Resources FY17 Adopted Resources 12,860,406$ 12,860,406$ Beginning Cash 411,488 411,488 Transfer from F100 4,201 4,201 (1) Total Street Funds 12,860,406$ 13,276,095$ Requirements FY17 Adopted Operating Budget 5,799,654$ 5,799,654$ Information Technology 5,372 5,372 (2) Total Operating Budget 5,805,026$ Non-Departmental Expenses: Reserves 5,355,088 (3,309,730) 2,045,358 (1-3) Total Non-Departmental 5,355,088$ 2,045,358$ Total Capital Projects 1,705,664$ 3,720,047 5,425,711$ (3) Total Street Funds 12,860,406$ 13,276,095$ Street Funds Streets F201, Street Capital F434 1. Request transfers funds from General Fund reserves to F201 to correct an FY16 budgetary erratum for right-or-way use fees. 2. Request reallocates funds to retain software maintenance assurance for database. 3. Request reappropriates unexpended funding from FY16 to FY17 for street improvements and the removal of funds for the South Bank Path Extension as it has been completed. FY17 Supplemental Budget Request 1 Page 4 of 13 Sanitary Sewer Funds – The proceeding table shows the impact of all Sanitary Sewer Fund requests on the FY17 amended budget. The numbers at the right of the table correspond to the description of the request that are below the table. FY17 Adopted Budget Adjustment & Carryovers Amended Budget Resources FY17 Adopted Resources 25,735,710$ 25,735,710$ Beginning Cash 1,047,813 1,047,813 Total Sanitary Funds 25,735,710$ 26,783,523$ Requirements FY17 Adopted Operating Budget 3,869,086$ 3,869,086$ Information Technology 11,378 11,378 (1) Total Operating Budget 3,869,086 3,880,464$ Non-Departmental Expenses: Debt Service 1,709,133 1,709,133 Reserves 15,715,503 1,878,018 17,593,521 (1-2) Total Non-Departmental 17,424,636$ 19,302,654$ Total Capital Projects 4,441,988$ (841,583) 3,600,405$ (2) Total Sanitary Funds 25,735,710$ 26,783,523$ Sanitary Sewer Funds Operations F611 1. Request reallocates funds for the upgrade of City standard database platforms and continues the contract with Oracle for software maintenance assurance until database conversion is complete. 2. Request reallocates funds into sanitary/storm water capital reserve by reconciling FY17 project budgets with FY16 actuals. FY17 Supplemental Budget Request 1 Page 5 of 13 Storm Drainage Funds – The proceeding table shows the impact of all Storm Drainage Fund requests on the FY17 amended budget. The numbers at the right of the table correspond to the description of the request that are below the table. FY17 Adopted Budget Adjustment & Carryovers New Request Amended Budget Resources FY17 Adopted Resources 26,844,169$ 26,844,169$ Beginning Cash (317,060) (317,060) Total Storm Funds 26,844,169$ 26,527,109$ Requirements FY17 Adopted Operating Budget 5,192,412$ 5,192,412$ Development & Public Works (897,441) (897,441) (1) Information Technology 7,897 7,897 (2) Total Operating Budget 4,302,868$ Non-Departmental Expenses: Debt Service 704,152 704,152 Reserves 9,551,415 572,484 10,123,899 (1-2) Total Non-Departmental 10,255,567$ 10,828,051$ Total Capital Projects 11,396,190$ 11,396,190$ Total Storm Funds 26,844,169$ 26,527,109$ Storm Drainage Funds Operations F617 1. Request will reappropriate the FY16 unspent budgets for the Firing Range Decommissioning, Glenwood Floodplain Study, and Channel 6 project budget into their respective FY17 budgets. Additionally, this request will reduce the FY17 budgets for the Over/Under Channel and the Mill Race Stormwater Facility as expenditures in FY16 exceeded estimates. 2. Request reallocates funds for the upgrade of City standard database platforms and continues the contract with Oracle for software maintenance assurance until database conversion is complete. FY17 Supplemental Budget Request 1 Page 6 of 13 Regional Wastewater Funds – The proceeding table shows the impact of all Regional Wastewater Funds requests on the FY17 amended budget. The numbers at the right of the table correspond to the description of the request that are below the table. FY17 Adopted Budget Adjustment & Carryovers New Request Amended Budget Resources FY17 Adopted Resources 120,399,847$ 120,399,847$ Beginning Cash 7,143,966 7,143,966 Total Regional Funds 120,399,847$ 127,543,813$ Requirements FY17 Adopted Operating Budget 24,285,630$ 24,285,630$ Development & Public Works (3,080,481) (3,080,481) (1) Total Operating Budget 24,285,630 21,205,149$ Non-Departmental Expenses: Transfers 13,570,191$ 13,570,191$ Debt Service 5,504,462 5,504,462 Reserves 46,682,964 10,107,918 56,790,882 (1) Total Non-Departmental 65,757,617$ 75,865,535$ Total Capital Projects 30,356,600$ 116,529 30,473,129$ (1) Total Regional Funds 120,399,847$ 127,543,813$ Regional Wastewater Funds Revenue Bond Capital Projects F412, Capital F433, and Operations F612 1. Request reallocates unspent operations and capital project funds from FY16 and expected to be spent in FY17. FY17 Supplemental Budget Request 1 Page 7 of 13 All Other Debt Service Funds – The proceeding table shows the impact of all Debt Service Fund requests on the FY17 amended budget. The numbers at the right of the table correspond to the description of the request that are below the table. FY17 Adopted Budget Adjustment & Carryovers Amended Budget Resources FY17 Adopted Resources 2,634,100$ 2,634,100$ Beginning Cash 29,403 29,403 (1) Total Community Develp. Fund 2,634,100$ 2,663,503$ Requirements FY17 Adopted Operating Budget 18,854$ 18,854$ Finance - Total Operating Budget 18,854$ Non-Departmental Expenses: Transfers -$ -$ Debt Service 2,205,610$ 2,205,610 Unappropriated Balances 356,000 31,373 387,373 (1) Reserves 53,636 (1,970) 51,666 (1) Total Non-Departmental 2,615,246$ 2,644,649$ All Other Debt Service Funds Bancroft Redemption F305 and Bond Sinking F306 1. Request adjusts for beginning cash. FY17 Supplemental Budget Request 1 Page 8 of 13 All Other Capital Funds – The proceeding table shows the impact of all Capital Fund requests on the FY17 amended budget. The numbers at the right of the table correspond to the description of the request that are below the table. FY17 Adopted Budget Adjustment & Carryovers New Request Amended Budget Resources FY17 Adopted Resources 4,709,781$ 4,709,781$ Beginning Cash 822,262 822,262 Transfer from F707 (115,000) (115,000) (1) Transfer from F208 (350,000) (350,000) (1) Total Funds 4,709,781$ 5,067,043$ Requirements FY17 Adopted Operating Budget 92,596$ 92,596$ - Total Operating Budget 92,596 92,596$ Non-Departmental Expenses: Transfers 262,902$ 262,902$ Reserves 3,705,365 (132,139) 3,573,226 (1) Total Non-Departmental 3,968,267$ 3,836,128$ All Other Capital Funds Development Assessment Capital F419 and Development Projects F420 1. Request eliminates unnecessary budget reappropriation relation to Gateway Flame and wellness clinic and updates the building preservation capital funds in the Development Projects fund by reappropriating unspent funds from FY16 to FY17. FY17 Supplemental Budget Request 1 Page 9 of 13 All Other Enterprise Funds - The proceeding table shows the impact of all Enterprise Fund requests on the FY17 amended budget. The numbers at the right of the table correspond to the description of the request that are below the table. FY17 Adopted Budget Adjustment & Carryovers New Request Amended Budget Resources FY17 Adopted Resources 10,151,066$ 10,151,066$ Beginning Cash 775,784 775,784 Total Insurance Fund 10,151,066$ 10,926,850$ Requirements FY17 Adopted Operating Budget 6,632,103$ 6,632,103$ Fire & Life Safety 45,255 45,255 (1) Total Operating Budget 6,677,358$ Non-Departmental Expenses: Debt Service 835,025$ 835,025$ Reserves 2,407,938 775,784 (45,255) 3,138,467 (1) Total Non-Departmental 3,242,963$ 3,973,492$ Total Capital Projects 276,000$ 276,000$ Total Other Enterprise Funds 10,151,066$ 10,926,850$ All Other Enterprise Funds Ambulance F615, Booth-Kelly F618 and Regional Fiber Consortium F629 1. Request pays for Springfield Fire & Life Safety's share of IGA agreement with Tualatin Valley Fire & Rescue for representation and implementation of the Ground Emergency Medical Transportation (GEMT) efforts in Oregon. Request also reappropriates funds for the purchase of equipment and implementation of Internet Protocol (IP) Alerting for all stations from FY16 to FY17. FY17 Supplemental Budget Request 1 Page 10 of 13 All Other Internal Service Funds – The proceeding table shows the impact of all Internal Service Fund requests on the FY17 amended budget. The numbers at the right of the table correspond to the description of the request that are below the table. FY17 Adopted Budget Adjustment & Carryovers New Request Amended Budget Resources FY17 Adopted Resources 37,620,941$ 37,620,941$ Beginning Cash 1,683,500 1,683,500 Total All Other Funds 37,620,941$ 39,304,441$ Requirements FY17 Adopted Operating Budget 11,793,781$ 11,793,781$ Development & Public Works 345,275 12,000 357,275 (1) Information Technology 63,643 63,643 (2) Total Operating Budget 12,214,699$ Non-Departmental Expenses: Transfers 338,032$ (61,289) 276,743$ (3) Debt Service 239,868 239,868 Statutory Payments 10,429,297 10,429,297 Reserves 14,819,963 1,335,871 (12,000) 16,143,834 (1-3) Total Non-Departmental 25,827,160$ 27,089,742$ Total All Other Internal Funds 37,620,941$ 39,304,441$ All Other Internal Service Funds Insurance F707, Vehicle & Equipment F713 and SDC Administration F719 1. Request reappropriates funds from FY16 to FY17 for the purchase of a compact track loader and related attachments for use by the DPW Operations Division. Request also increases the FY17 Vehicle and Equipment Fund for the purchase of a tractor to replace existing failing tractor for control of unwanted vegetation and invasive species. Additionally, request provides additional funding for the purchase of copier/printer equipment for use by DPW/MWMC staff as costs are higher than anticipated. 2. Request increases funds for the initiation of network equipment repair and replacement to be in compliance with information security regulations. 3. Request eliminates unnecessary budget appropriations relating to Gateway Flame and wellness clinic and transfers insurance proceeds from F707 and F713 for wrecked vehicles. FY17 Supplemental Budget Request 1 Page 11 of 13 All Other Special Revenue Funds – The proceeding table shows the impact of all Special Revenue Fund requests on the FY17 amended budget. The numbers at the right of the table correspond to the description of the request that are below the table. FY17 Adopted Budget Adjustment & Carryovers New Request Amended Budget Resources FY17 Adopted Resources 16,622,502$ 16,622,502$ Beginning Cash (265,882) (265,882) Local JAG Grant 21,419 21,419 (1) SHPO Grants 2,000 2,000 (2) CDBG Federal Grants 76,391 76,391 (3) Total Special Revenue Fund 16,622,502$ 16,456,430$ Requirements FY17 Adopted Operating Budget 10,784,365$ 10,784,365$ Development & Public Works 76,391 2,000 78,391 (2-3) Library 351 62,550 62,901 (4) Police 115,704 115,704 (1, 5) Total Operating Budget 10,784,365 11,041,361$ Non-Departmental Expenses: Transfers 675,000$ 675,000$ Reserves 5,163,137 (351) (422,717) 4,740,069 (1, 4-5) Total Non-Departmental 5,838,137$ 5,415,069$ Total Special Revenue Funds 16,622,502$ 16,456,430$ All Other Special Revenue Funds Special Revenue F204, Transient Room Tax F208, Community Development F210, Building Code F224, Fire Local Option Levy F235 and Police Local Option Levy F236 1. Request reallocates remaining funds from the 2015 Justice Assistance Grant award from and allows the recognition of the 2016 Justice Assistance Grant award. 2. Request recognizes the City’s most recent State Historic Preservation grant award covering the period from April 2016 to August 2017. 3. Request allocates funds from the Community Development Block Grant (CDBG) for the 2016 program year. 4. Request reappropriates funds to complete Phase 1 of the Library Needs Assessment. 5. Request reallocates funds from the Federal Forfeiture Reserves to purchase safety equipment for police officers, new rifles for the SWAT Team, a new surveillance camera system for patrol officers, funds undercover investigations by the detective bureau, increases appropriation for SunGard emergency dispatch software expenditures. FY17 Supplemental Budget Request 1 Page 12 of 13 RECOMMENDED ACTION: Hold a public hearing and adopt/not adopt the following resolutions: A RESOLUTION ADJUSTING RESOURCES AND REQUIREMENTS IN THE FOLLOWING FUNDS: General, Street, Special Revenue, Transient Room Tax, Community Development, Building Code, Fire Local Option Levy, Police Local Option Levy, Bancroft Redemption, Bond Sinking, Regional Wastewater Revenue Bond Capital Project, Development Assessment Capital, Development Projects, Regional Wastewater Capital, Street Capital, Sanitary Sewer Operations, Regional Wastewater, Ambulance, Storm Drainage Operations, Storm Drainage Operations, Storm Drainage Operations, Storm Drainage Operations, Storm Drainage Operations, Booth-Kelly, Regional Fiber Consortium, Insurance, Vehicle & Equipment, and SDC Administration funds. FY17 Supplemental Budget Request 1 Page 13 of 13 Resources Requirements Beginning Cash Balance 352,787$ Operating Expenses: Finance (39,888) Fire & Life Safety 30,000 Human Resources 98,395 Information Technology 43,608 Legal/Judicial Services 283,472 Library 2,508 Total Operating Expense 418,095$ Non-Departmental Expenses: Transfers 4,201 Reserves (69,509)$ Total Resources Adjustments 352,787$ Total Requirements Adjustments 352,787$ CITY OF SPRINGFIELD FY 2016-2017 SUPPLEMENTAL BUDGET No. 1 RESOLUTION NO. A RESOLUTION ADJUSTING RESOURCES AND REQUIREMENTS IN THE FOLLOWING FUNDS: General, Street, Special Revenue, Transient Room Tax, Community Development, Building Code, Fire Local Option Levy, Police Local Option Levy, Bancroft Redemption, Bond Sinking, Regional Wastewater Revenue Bond Capital Project, Development Assessment Capital, Development Projects, Regional Wastewater Capital, Street Capital, Sanitary Sewer Operations, Regional Wastewater, Ambulance, Storm Drainage Operations, Storm Drainage Operations, Storm Drainage Operations, Storm Drainage Operations, Storm Drainage Operations, Booth-Kelly, Regional Fiber Consortium, Insurance, Vehicle & Equipment, and SDC Administration funds. WHEREAS, the 2016-2017 fiscal year appropriations for the City of Springfield were made by Resolution No. 2016- 19 dated June 20, 2016 and, WHEREAS, at various times during the fiscal year the Common Council is requested to make adjustments to the fiscal year budget to reflect needed changes in planned activities, to recognize new revenues, or to make other required adjustments; and, WHEREAS, the Common Council handles such requests for adjustment to the budget through Supplemental Budget Resolutions presented at public hearings 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; and, NOW, THEREFORE, BE IT RESOLVED, by the Common Council of the City of Springfield, a Municipal Corporation of the State of Oregon, as follows: Section 1. Resolution 2016-19 is hereby adjusted as follows: General - Fund 100 Page 1 of 9 Resources Requirements Beginning Cash Balance 132,892$ Operating Expenses: Transfer from F100 4,201$ Information Technology 5,372 Non-Departmental Expenses: Reserves 131,721$ Total Resources Adjustments 137,093$ Total Requirements Adjustments 137,093$ Resources Requirements Beginning Cash 69,487$ Operating Expenses: JAG Grants 21,419 Development & Public Works 2,000$ SHPO Grant 2,000 Library 62,550 Police 83,519 Total Operating Expense 148,069$ Non-Departmental Expenses: Reserves (55,163) Total Resources Adjustments 92,906$ Total Requirements Adjustments 92,906$ Special Revenue - Fund 204 Comments: Beginning cash is being adjusted because prior year end cash was more than expected and balance is being removed into reserves. Request transfers funds from General Fund reserves to F201 to correct an FY16 budgetary erratum and reallocates funds to retain software maintenance assurance for database. Comments: Beginning cash adjustment is being made because prior year expenses were less than predicted and balance is being placed into reserves. Request reappropriates unspent project funds for Neubrain and Board budget software implementation, reallocates unspent funds intended to pay for equipment and implementation of Internet Protocol (IP) Alerting system for fire stations, reallocates funds associated with transfer of employee from Finance Department to Human Resources Department, reallocates funds to retain software maintenance assurance for database conversion and to upgrade network infrastructure and purchase a secure information transfer appliance, utilizes reserve funds to repay overpayment to CenturyLink as mandated in CenturyLink vs. City of Springfield, reappropriates reserve funds for FY17 book expenditures, and transfers funds from General Fund reserves to F201 to correct an FY16 budgetary erratum. Street - Fund 201 Page 2 of 9 Resources Requirements Beginning Cash (71,476)$ Operating Expenses: Library 351$ Non-Departmental Expenses: Reserves (71,827) Total Resources Adjustments (71,476)$ Total Requirements Adjustments (71,476)$ Resources Requirements CDBG Federal Grants 76,391$ Operating Expenses: Development & Public Works 76,391$ Total Resources Adjustments 76,391$ Total Requirements Adjustments 76,391$ Resources Requirements Beginning Cash (241,641)$ Non-Departmental Expenses: Reserves (241,641)$ Total Resources Adjustments (241,641)$ Total Requirements Adjustments (241,641)$ Comments: Beginning cash adjustment is being made because prior year expenses were less than predicted and balance is being placed into reserves. Request reallocates remaining funds from the 2015 Justice Assistance Grant award and allows the recognition of the 2016 Justice Assistance Grant award; recognizes the City’s most recent State Historic Preservation grant award covering the period from April 2016 to August 2017; reappropriates funds to complete Phase 1 of the Library Needs Assessment; and reallocates funds from the Federal Forfeiture Reserves to purchase safety equipment for police officers, new rifles for the SWAT Team, a new surveillance camera system for patrol officers; funds undercover investigations by the detective bureau; and increases appropriation for SunGard emergency dispatch software expenditures. Transient Room Tax - Fund 208 Comments: Beginning cash is being adjusted because prior year end cash was more than expected and balance is being removed from reserves. Request reappropriates funds from Tourism Reserves to fully fund Library programming. Community Development - Fund 210 Comments: Request reallocates funds from the Community Development Block Grant (CDBG) for the 2016 CDBG program year. Comments: Beginning cash adjustment is being made because prior year expenses were more than predicted and balance is being removed from reserves. Building Code - Fund 224 Page 3 of 9 Resources Requirements Beginning Cash 113,558$ Non-Departmental Expenses: Reserves 113,558$ Total Resources Adjustments 113,558$ Total Requirements Adjustments 113,558$ Resources Requirements Beginning Cash (135,810)$ Operating Expenses: Police 32,185 Non-Departmental Expenses: Reserves (167,995)$ Total Resources Adjustments (135,810)$ Total Requirements Adjustments (135,810)$ Resources Requirements Beginning Cash (1,970)$ Non-Departmental Expenses: Reserves (1,970)$ Total Resources Adjustments (1,970)$ Total Requirements Adjustments (1,970)$ Resources Requirements Beginning Cash 31,373$ Non-Departmental Expenses: Unappropriated Fund Balance 31,373$ Total Resources Adjustments 31,373$ Total Requirements Adjustments 31,373$ Resources Requirements Beginning Cash 244,409$ Non-Departmental Expenses: Reserves 267,119$ Capital Projects (22,710)$ Total Resources Adjustments 244,409$ Total Requirements Adjustments 244,409$ Resources Requirements Beginning Cash 645$ Non-Departmental Expenses: Comments: Beginning cash adjustment is being made because prior year expenses were more than predicted and balance is being removed from reserves. Request increases appropriation for SunGard emergency dispatch software expenditures. Police Local Option Levy - Fund 236 Comments: Beginning cash adjustment is being made because prior year expenses were less than predicted and balance is being placed into reserves. Request carries forward portions of projects budgeted and included in estimated actuals for 2015 but not yet expended; these expenses are expected to be incurred in FY17. Regional Wastewater Revenue Bond Capital Project - Fund 412 Fire Local Option Levy - Fund 235 Comments: Beginning cash adjustment is being made because prior year expenses were less than predicted and balance is being placed into reserves. Bond Sinking - Fund 306 Comments: Beginning cash adjustment is being made because prior year expenses were less than predicted and balance is being placed into Unappropriated Fund Balance. Development Assessment Capital - Fund 419 Bancroft Redemption - Fund 305 Comments: Beginning cash is being adjusted because prior year expenses were more than expected and balance is being removed from reserves. Page 4 of 9 Reserves 645$ Total Resources Adjustments 645$ Total Requirements Adjustments 645$ Resources Requirements Beginning Cash 821,617$ Non-Departmental Expenses: Transfer from F707 (115,000) Reserves (132,784) Transfer from F208 (350,000) Capital Projects 489,401$ Total Resources Adjustments 356,617$ Total Requirements Adjustments 356,617$ Resources Requirements Beginning Cash 5,594,875$ Operating Expenses: Development & Public Works (3,209,881)$ Non-Departmental Expenses: Reserves 8,665,517$ Capital Projects 139,239$ Total Resources Adjustments 5,594,875$ Total Requirements Adjustments 5,594,875$ Resources Requirements Beginning Cash 278,596$ Non-Departmental Expenses: Reserves (3,441,451)$ Capital Projects 3,720,047$ Total Resources Adjustments 278,596$ Total Requirements Adjustments 278,596$ Resources Requirements Beginning Cash 1,047,813$ Operating Expenses: Information Technology 11,378$ Non-Departmental Expenses: Reserves 1,878,018$ Capital Projects (841,583)$ Total Resources Adjustments 1,047,813$ Total Requirements Adjustments 1,047,813$ Local Wastewater Operations - Fund 611 Regional Wastewater Capital - Fund 433 Street Capital - Fund 434 Comments: Beginning cash is being adjusted because prior year expenses were less than expected and balance is being placed into reserves. Request reappropriates unexpended funding from FY16 to FY17 for street improvements and the removal of funds for the South Bank Path Extension as it has been completed. Comments: Beginning cash adjustment is being made because prior year expenses were less than predicted and balance is being placed into reserves. Development Projects - Fund 420 Comments: Beginning cash adjustment is being made because prior year expenses were less than predicted and balance is being placed into reserves. Request eliminates unnecessary budget appropriation related to Gateway Flame and wellness clinic projects and updates the building preservation capital funds in the Development Projects fund by reappropriating unspent funds from FY16 to FY17. Comments: Beginning cash adjustment is being made because prior year expenses were less than predicted and balance is being placed into reserves. Request reallocates unspent operations and capital project funds from FY16 and expected to be spent in FY17. Page 5 of 9 Comments: Beginning cash is being adjusted because prior year expenses were less than expected and balance is being placed into reserves. Request reallocates funds for the upgrade of City standard database platforms and continues the contract with Oracle for software maintenance assurance until database conversion is complete and reallocates funds into sanitary/storm water capital reserve by reconciling FY17 project budgets with FY16 actuals. Page 6 of 9 Resources Requirements Beginning Cash 1,304,682$ Operating Expenses: Development & Public Works 129,400$ Non-Departmental Expenses: Reserves 1,175,282$ Total Resources Adjustments 1,304,682$ Total Requirements Adjustments 1,304,682$ Resources Requirements Beginning Cash 729,151$ Operating Expenses: Fire & Life Safety 45,255$ Non-Departmental Expenses: Reserves 683,896$ Total Resources Adjustments 729,151$ Total Requirements Adjustments 729,151$ Resources Requirements Beginning Cash (317,060)$ Operating Expenses: Information Technology 7,897 Non-Departmental Expenses: Reserves 572,484$ Capital Projects (897,441)$ Total Resources Adjustments (317,060)$ Total Requirements Adjustments (317,060)$ Comments: Beginning cash is being adjusted because prior year expenses were more than expected and balance is being removed from reserves. Request will reappropriate the FY16 unspent budgets for the Firing Range Decommissioning, Glenwood Floodplain Study, and Channel 6 project budget into their respective FY17 budgets. Additionally, this request will reduce the FY17 budgets for the Over/Under Channel and the Mill Race Stormwater Facility as expenditures in FY16 exceeded estimates. Request reallocates funds for the upgrade of City standard database platforms and continues the contract with Oracle for software maintenance assurance until database conversion is complete. Storm Drainage Operations - Fund 617 Regional Wastewater - Fund 612 Comments: Beginning cash adjustment is being made because prior year expenses wereless than predicted and balance is being placed into reserves. Request reallocates unspent operations and capital project funds from FY16 and expected to be spent in FY17. Ambulance - Fund 615 Comments: Beginning cash is being adjusted because prior year end cash was more than expected and balance is being placed into reserves. Request pays for Springfield Fire & Life Safety's share of IGA agreement with Tualatin Valley Fire & Rescue for representation and implementation of the Ground Emergency Medical Transportation (GEMT) efforts in Oregon. Request also reappropriates funds for the purchase of equipment and implementation of Internet Protocol (IP) Alerting for all stations from FY16 to FY17. Page 7 of 9 Resources Requirements Beginning Cash (31,595)$ Non-Departmental Expenses: Reserves (31,595)$ Total Resources Adjustments (31,595)$ Total Requirements Adjustments (31,595)$ Resources Requirements Beginning Cash 78,228$ Non-Departmental Expenses: Reserves 78,228$ Total Resources Adjustments 78,228$ Total Requirements Adjustments 78,228$ Resources Requirements Beginning Cash 1,177,803$ Non-Departmental Expenses: Transfers (61,289)$ Reserves 1,239,092 Total Non-Departmental Expenses 1,177,803$ Total Resources Adjustments 1,177,803$ Total Requirements Adjustments 1,177,803$ Resources Requirements Beginning Cash 357,158$ Operating Expenses: Development & Public Works 357,275$ Information Technology 63,000 Total Operating Expense 420,275$ Non-Departmental Expenses: Reserves (63,117)$ Total Resources Adjustments 357,158$ Total Requirements Adjustments 357,158$ Regional Fiber Consortium - Fund 629 Comments: Beginning cash adjustment is being made because prior year expenses were less than predicted and balance is being placed into reserves. Booth-Kelly - Fund 618 Comments: Beginning cash adjustment is being made because prior year expenses were more than predicted and balance is being removed from reserves. Insurance - Fund 707 Comments: Beginning cash adjustment is being made because prior year expenses were less than predicted and balance is being placed into reserves. Request eliminates unnecessary budget appropriations relating to Gateway Flame and wellness clinic and transfers insurance proceeds from F707 and F713 for wrecked vehicles. Vehicle & Equipment - Fund 713 Page 8 of 9 Resources Requirements Beginning Cash 148,539$ Operating Expenses: Information Technology 643 Non-Departmental Expenses: Reserves 147,896$ Total Resources Adjustments 148,539$ Total Requirements Adjustments 148,539$ Total Resources Adjustments 11,323,072$ Total Requirements Adjustments 11,323,072$ Attest: Section 2. This resolution shall take effect upon adoption by the Council and approval by the Mayor. Adopted by the Common Council of the City of Springfield this 17th day of October, 2016, by a vote of ______for and ______against. Mayor Christine L Lundberg City Recorder Amy Sowa Comments: Beginning cash adjustment is being made because prior year expenses were less than predicted and balance is being placed into reserves. Request reappropriates funds from FY16 to FY17 for the purchase of a compact track loader and related attachments for use by the DPW Operations Division. Request also increases the FY17 Vehicle and Equipment Fund for the purchase of a tractor to replace existing failing tractor for control of unwanted vegetation and invasive species. Additionally, request provides additional funding for the purchase of copier/printer equipment for use by DPW/MWMC staff as costs are higher than anticipated. Request increases funds for the initiation of network equipment repair and replacement to be in compliance with information security regulations. SDC Administration - Fund 719 Comments: Beginning cash is being adjusted because prior year expenses were less than expected and balance is being placed into reserves. Request increases funds for the initiation of network equipment repair and replacement to be in compliance with information security regulations. Page 9 of 9