Loading...
2019-2023 Equipment Replacement Plan (ERP) and 2019-2023 Capital Improvement Plan (CIP); Bishop CITY OF HOPKINS Memorandum To: Honorable Mayor and Council Members Mike Mornson, City Manager From: Nick Bishop, Finance Director Date: November 13, 2018 Subject: 2019 – 2023 Equipment Replacement Plan (ERP) 2019 – 2023 Capital Improvement Plan (CIP) _____________________________________________________________________ PURPOSE To provide continued input and guidance for the 2019 – 2023 Equipment Replacement Plan and 2019 – 2023 Capital Improvement Plan. INFORMATION The revenues and expenditures in the ERP have been slightly reduced since the last work session. The IT department has found a lower cost Patching Automation Software that will reduce costs by approximately $20,000. The ERP for 2019 includes revenues of $801,569 and expenditures of $691,263. The fund is projected to finish 2019 with a $41,007 working capital balance. The CIP being presented hasn’t changed since the last work session. The CIP for 2019 includes revenues of approximately $7.5 million (grants, dedication fees, franchise fees and tax levy) and estimated bond proceeds of $11.8 million. All funds in the CIP have 2019 project costs of $19,346,000. FUTURE ACTION Approval of the ERP and CIP is being scheduled for December 4, 2018. Finance Dept. City of Hopkins Equipment Replacement Fund (602) Rate Change 9%10%9%9%9%6%6% ACTUAL PROJECTED BUDGET BUDGET BUDGET BUDGET BUDGET 2017 2018 2019 2020 2021 2022 2023 Working Capital Begin Year 1,172,861 (28,845) (69,299) 41,007 173,984 443,107 327,733 Revenues from charges 445,012 489,513 533,569 581,591 633,934 671,970 712,288 Tax Levy 230,000 250,000 250,000 250,000 250,000 Transfer in Debt Service Fund - - - - - - Interest earnings 1,332 3,000 3,000 3,000 3,000 3,000 3,000 Other revenues (sale of assets)69,883 30,000 35,000 35,000 35,000 35,000 35,000 Enterpirse contribution to software upgrade - - - - - - Equipment Certificates (Bonds)- 590,000 - - - - 1,600,000 Interfund Loan - -- - - - Total Revenues 516,227 1,112,513 801,569 869,591 921,934 959,970 2,600,288 Expenditures (excludes Leases & Depr.) 31,929 32,887 33,873 34,890 35,936 37,014 38,125 Fire Truck Financing Pymnts (2009-2018)54,217 54,217 - - - - Capital Outlay - Equipment 1,631,787 1,065,863 657,390 701,724 616,875 1,038,329 1,604,077 Repayment of Interfund Loan - - Total Expenses 1,717,933 1,152,967 691,263 736,614 652,811 1,075,343 1,642,202 Working Capital Ending Balance (28,845) (69,299) 41,007 173,984 443,107 327,733 1,285,819 (Unrestricted Net Position) EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP DEPARTMENT SUMMARY 2019 2023thru Total20192020202120222023Department Comm Svcs - Activity Center 127,62416,000 82,624 17,000 12,000 Comm Svcs - Arts Center 13,50013,500 Comm Svcs - IT 891,659153,390 223,500 120,075 162,129 232,565 Community Services 51,30051,300 Fire 822,90029,000 344,500 449,400 HRA 57,60016,500 41,100 Police 1,573,612258,000 137,400 271,800 329,500 576,912 Public Works: Parks/Forestry 390,800177,900 163,600 49,300 Public Works: Streets/Traffic 855,900230,000 225,000 103,400 297,500 Refuse 270,300270,300 Sewer 43,00043,000 Water 35,00035,000 692,390 701,724 887,175 1,193,129 1,658,777 5,133,195TOTAL Tuesday, November 6, 2018 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP PROJECTS BY DEPARTMENT 2019 2023thru Total20192020202120222023DepartmentProject #Priority Comm Svcs - Activity Center 01-ERP-0037 20,00020,000Activity Center Security System Upgrade 1 01-ERP-0038 29,00017,000 12,000Activity Center Kitchen Storage 5 01-ERP-0039 16,00016,000Activity Center Dishwasher 5 01-ERP-0041 62,62462,624Activity Center A/V Replacement & Upgrade 1 127,62416,000 82,624 17,000 12,000Comm Svcs - Activity Center Total Comm Svcs - Arts Center 01-ERP-1105 13,50013,500Art Center Jaycee Studio Audio Visual n/a 13,50013,500Comm Svcs - Arts Center Total Comm Svcs - IT 01-ERP-0003 117,25022,000 22,000 22,000 25,000 26,250CH - Network Server n/a 01-ERP-0004 89,60089,600Telephone System n/a 01-ERP-0006 165,76930,000 31,500 33,075 34,729 36,465Computersn/a 01-ERP-0009 23,40023,400Network Infrastructure Upgrade n/a 01-ERP-0014 50,00050,000Distribution Network Switches n/a 01-ERP-0015 66,00066,000Backup Server n/a 01-ERP-0017 154,00011,000 22,000 33,000 44,000 44,000IT - Office 365 n/a 01-ERP-0018 19,00019,000IT - RSA/Netmotion VPN n/a 01-ERP-0019 19,39019,390IT - Email Threat Protection n/a 01-ERP-0020 70,00030,000 10,000 10,000 10,000 10,000IT - Patching Automation Software 1 01-ERP-0211 117,25022,000 22,000 22,000 25,000 26,250PD - Network Server n/a 891,659153,390 223,500 120,075 162,129 232,565Comm Svcs - IT Total Community Services 01-ERP-0008 11,30011,300Document Management Scanner (2)n/a 01-ERP-0051 40,00040,000City Hall Exterior Security Camera System 1 51,30051,300Community Services Total Fire 01-ERP-0105 314,500314,500Quick Attack Pumper/Rescue (Rescue 8)n/a 01-ERP-0109 91,00029,000 30,000 32,000Extrication Tool (2)n/a 01-ERP-0112 15,40015,400Thermal Imaging Camera (2)n/a 01-ERP-0125 368,000368,000Fire Radios - Portable and Mobile Devices n/a 01-ERP-0126 16,00016,000Fire - Fire Helmets n/a 01-ERP-0127 18,00018,000Fire - Lucus Device n/a 822,90029,000 344,500 449,400Fire Total HRA 01-ERP-0400 41,10041,1004x4 3/4 Ton Truck n/a 01-ERP-0401 16,50016,500HRA Copier n/a Tuesday, November 6, 2018 Total20192020202120222023DepartmentProject #Priority 57,60016,500 41,100HRA Total Police 01-ERP-0200 591,30098,000 107,400 161,100 107,400 117,400Marked Patrol Vehicles (7)n/a 01-ERP-0201 57,00057,000Sergeant's Vehicle n/a 01-ERP-0202 53,70053,700PSO / Parking Enforcement Vehicle n/a 01-ERP-0203 72,10072,100PSO - Utility 4x4 n/a 01-ERP-0212 85,00085,000Squad Car Camera Systems n/a 01-ERP-0214 76,51276,512Tactical Ballistic Vests / Helmets - SWAT 3 01-ERP-0215 290,000290,000Police - Portable Radios n/a 01-ERP-0217 76,00076,000Taser Replacement n/a 01-ERP-0218 37,00020,000 17,000Building Video Server n/a 01-ERP-0219 20,00010,000 10,000PD - Video Data Server n/a 01-ERP-0220 65,00065,000Mobile Data Computers n/a 01-ERP-0221 150,000150,000Records Management System n/a 1,573,612258,000 137,400 271,800 329,500 576,912Police Total Public Works: Parks/Forestry 01-ERP-0800 35,40035,4001/2 Ton Pickup Truck n/a 01-ERP-0801 85,20085,2004x4 3/4Ton Trucks (2)n/a 01-ERP-0804 163,600163,600Log Truck n/a 01-ERP-0808 13,90013,900Riding Mowers (2)n/a 01-ERP-0810 92,70092,700Large Turf Mower n/a 390,800177,900 163,600 49,300Public Works: Parks/Forestry Total Public Works: Streets/Traffic 01-ERP-0300 28,90028,9004x4 1/2 Ton Pickup with Plow n/a 01-ERP-0303 53,40053,4001 Ton Dump Truck (2)n/a 01-ERP-0305 225,000225,000Single Axle Dump Truck (2)n/a 01-ERP-0308 268,600268,600Front End Loaders (2)n/a 01-ERP-0309 50,00050,000Skid Loader (2)n/a 01-ERP-0311 230,000230,000Sweepern/a 855,900230,000 225,000 103,400 297,500Public Works: Streets/Traffic Total Refuse 01-ERP-0900 270,300270,300Refuse Truck (RAP-R) (2)n/a 270,300270,300Refuse Total Sewer 01-ERP-0555 43,00043,000Generator (2)n/a 43,00043,000Sewer Total Water 01-ERP-0503 35,00035,000Air Compressor 2 35,00035,000Water Total GRAND TOTAL 5,133,195692,390 701,724 887,175 1,193,129 1,658,777 Tuesday, November 6, 2018 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP FUNDING SOURCE SUMMARY 2019 thru 2023 TotalSource20192020202120222023 AC - Arts Center Fund 13,50013,500 Equipment Replacement Fund 4,618,395657,390 701,724 616,875 1,038,329 1,604,077 HRA - Housing and Redevelopment Authority 57,60016,500 41,100 RF - Refuse Fund 352,100270,300 81,800 SF - Sanitary Sewer Fund 49,80043,000 6,800 WF - Water Fund 41,80035,000 6,800 692,390 701,724 887,175 1,193,129 1,658,777 5,133,195GRAND TOTAL Tuesday, November 6, 2018 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN - ERP PROJECTS BY FUNDING SOURCE 2019 2023thru TotalSourceProject #Priority 2019 2020 2021 2022 2023 AC - Arts Center Fund 01-ERP-1105 13,50013,500Art Center Jaycee Studio Audio Visual n/a 13,50013,500AC - Arts Center Fund Total Equipment Replacement Fund 01-ERP-0003 117,25022,000 22,000 22,000 25,000 26,250CH - Network Server n/a 01-ERP-0004 76,00076,000Telephone System n/a 01-ERP-0006 165,76930,000 31,500 33,075 34,729 36,465Computersn/a 01-ERP-0008 11,30011,300Document Management Scanner (2)n/a 01-ERP-0009 23,40023,400Network Infrastructure Upgrade n/a 01-ERP-0014 50,00050,000Distribution Network Switches n/a 01-ERP-0015 66,00066,000Backup Server n/a 01-ERP-0017 154,00011,000 22,000 33,000 44,000 44,000IT - Office 365 n/a 01-ERP-0018 19,00019,000IT - RSA/Netmotion VPN n/a 01-ERP-0019 19,39019,390IT - Email Threat Protection n/a 01-ERP-0020 70,00030,000 10,000 10,000 10,000 10,000IT - Patching Automation Software 1 01-ERP-0037 20,00020,000Activity Center Security System Upgrade 1 01-ERP-0038 29,00017,000 12,000Activity Center Kitchen Storage 5 01-ERP-0039 16,00016,000Activity Center Dishwasher 5 01-ERP-0041 62,62462,624Activity Center A/V Replacement & Upgrade 1 01-ERP-0051 40,00040,000City Hall Exterior Security Camera System 1 01-ERP-0105 314,500314,500Quick Attack Pumper/Rescue (Rescue 8)n/a 01-ERP-0109 91,00029,000 30,000 32,000Extrication Tool (2)n/a 01-ERP-0112 15,40015,400Thermal Imaging Camera (2)n/a 01-ERP-0125 368,000368,000Fire Radios - Portable and Mobile Devices n/a 01-ERP-0126 16,00016,000Fire - Fire Helmets n/a 01-ERP-0127 18,00018,000Fire - Lucus Device n/a 01-ERP-0200 591,30098,000 107,400 161,100 107,400 117,400Marked Patrol Vehicles (7)n/a 01-ERP-0201 57,00057,000Sergeant's Vehicle n/a 01-ERP-0202 53,70053,700PSO / Parking Enforcement Vehicle n/a 01-ERP-0203 72,10072,100PSO - Utility 4x4 n/a 01-ERP-0211 117,25022,000 22,000 22,000 25,000 26,250PD - Network Server n/a 01-ERP-0212 85,00085,000Squad Car Camera Systems n/a 01-ERP-0214 76,51276,512Tactical Ballistic Vests / Helmets - SWAT 3 01-ERP-0215 290,000290,000Police - Portable Radios n/a 01-ERP-0217 76,00076,000Taser Replacement n/a 01-ERP-0218 37,00020,000 17,000Building Video Server n/a 01-ERP-0219 20,00010,000 10,000PD - Video Data Server n/a 01-ERP-0220 65,00065,000Mobile Data Computers n/a 01-ERP-0221 150,000150,000Records Management System n/a 01-ERP-0300 28,90028,9004x4 1/2 Ton Pickup with Plow n/a 01-ERP-0303 53,40053,4001 Ton Dump Truck (2)n/a 01-ERP-0305 225,000225,000Single Axle Dump Truck (2)n/a 01-ERP-0308 268,600268,600Front End Loaders (2)n/a Tuesday, November 6, 2018 TotalSourceProject #Priority 2019 2020 2021 2022 2023 01-ERP-0309 50,00050,000Skid Loader (2)n/a 01-ERP-0311 230,000230,000Sweepern/a 01-ERP-0800 35,40035,4001/2 Ton Pickup Truck n/a 01-ERP-0801 85,20085,2004x4 3/4Ton Trucks (2)n/a 01-ERP-0804 81,80081,800Log Truck n/a 01-ERP-0808 13,90013,900Riding Mowers (2)n/a 01-ERP-0810 92,70092,700Large Turf Mower n/a 4,618,395657,390 701,724 616,875 1,038,329 1,604,077Equipment Replacement Fund Total HRA - Housing and Redevelopment A 01-ERP-0400 41,10041,1004x4 3/4 Ton Truck n/a 01-ERP-0401 16,50016,500HRA Copier n/a 57,60016,500 41,100HRA - Housing and Redevelopment Authority Total RF - Refuse Fund 01-ERP-0804 81,80081,800Log Truck n/a 01-ERP-0900 270,300270,300Refuse Truck (RAP-R) (2)n/a 352,100270,300 81,800RF - Refuse Fund Total SF - Sanitary Sewer Fund 01-ERP-0004 6,8006,800Telephone System n/a 01-ERP-0555 43,00043,000Generator (2)n/a 49,80043,000 6,800SF - Sanitary Sewer Fund Total WF - Water Fund 01-ERP-0004 6,8006,800Telephone System n/a 01-ERP-0503 35,00035,000Air Compressor 2 41,80035,000 6,800WF - Water Fund Total 5,133,195692,390 701,724 887,175 1,193,129 1,658,777GRAND TOTAL Tuesday, November 6, 2018 City of Hopkins Park Capital Improvements Fund (301) ACTUAL PROJECTED BUDGET BUDGET BUDGET BUDGET BUDGET 2017 2018 2019 2020 2021 2022 2023 Working Capital Begin Year 760,900 1,088,355 137,539 1,020,714 442,721 625,448 565,548 Revenues Franchise Fees 300,805 295,300 295,300 295,300 295,300 295,300 295,300 Dedication Fees-Oxford Village - - - - - - - Dedication Fees-Moline 180,750 - - - - - - Dedication Fees-Cold Storage - - 1,000,000 - - - - Interest earnings 5,246 10,884 1,375 10,207 4,427 - - Bond Proceeds 1,829,097 - - 1,300,000 - - Total Revenues 2,315,898 306,184 1,296,675 305,507 1,599,727 295,300 295,300 Expenditures Current - 7,000 7,000 7,000 7,000 7,000 7,000 Capital Projects 1,883,443 1,140,000 296,500 766,500 1,300,000 108,200 130,000 Bond Payment Contribution (2015)10,000 10,000 10,000 10,000 10,000 10,000 10,000 Bond Payment Contribution (2016)95,000 100,000 100,000 100,000 100,000 105,000 110,000 Bond Payment Contribution (Central Park)- - - - - 125,000 125,000 Total Expenditures 1,988,443 1,257,000 413,500 883,500 1,417,000 355,200 382,000 Working Capital Ending Balance 1,088,355 137,539 1,020,714 442,721 625,448 565,548 478,848 (Unrestricted Net Position) City of Hopkins Capital Improvements Fund (305) ACTUAL PROJECTED BUDGET BUDGET BUDGET BUDGET BUDGET 2017 2018 2019 2020 2021 2022 2023 Working Capital Begin Year (245,928) (145,647) (254,147) 63,853 411,603 2,221,603 2,196,603 Revenues from charges Tax Levy per FMP 303,050 75,000 100,000 300,000 150,000 100,000 100,000 Interest earnings - - - - - - - Other revenues 609 - - - - - - Bond Proceeds - - - - - - - Franchise Fees - - 360,000 360,000 360,000 - - Interfund Loan or Bond Proceeds - 200,000 - - 1,300,000 - - City Hall Bond Proceeds - -4,245,000 - - - - Total Revenues 303,659 275,000 4,705,000 660,000 1,810,000 100,000 100,000 Expenditures Current 9,118 - - - 1,300,000 - - Capital Projects 194,260 383,500 4,387,000 312,250 150,000 15,000 160,000 City Hall Debt Service 360,000 360,000 360,000 360,000 Bond Payment Contribution (Central Park)203,378 383,500 4,387,000 312,250 - 125,000 125,000 Working Capital Ending Balance (145,647) (254,147) 63,853 411,603 2,221,603 2,196,603 2,171,603 (Unrestricted Net Position) City of Hopkins Municipal State Aid Fund (302) ACTUAL PROJECTED BUDGET BUDGET BUDGET BUDGET BUDGET 2017 2018 2019 2020 2021 2022 2023 Working Capital Begin Year (253,875) (650,590) 62,254 552,073 1,041,892 242,130 242,130 Revenues State MSA Funds, projects - 489,819 489,819 489,819 489,819 489,819 489,819 Community Works Grant - County 223,025 Interest Earnings - - - - 10,419 - - Total Revenues - 712,844 489,819 489,819 500,238 - - - - Expenditures 1,300,000 CIP State Aid Projects 396,715 - - - - - 700,000 Total Expenditures 396,715 - - - 1,300,000 - 700,000 Working Capital Ending Balance (650,590) 62,254 552,073 1,041,892 242,130 242,130 (457,870) (Unrestricted Net Position)1,300,000 City of Hopkins Permanent Improving Revolving Fund (501) ACTUAL PROJECTED BUDGET BUDGET BUDGET BUDGET BUDGET 2017 2018 2019 2020 2021 2022 2023 Working Capital Begin Year (639,073) 197,261 210,346 533,264 626,597 5,314,863 3,719,863 Revenues Tax Levy per FMP 4,399 - - - - - - Special Assessments (Prepaid)741,370 290,700 180,000 250,000 377,000 100,000 210,000 Grants 2,480,548 5,954,600 5,704,600 - - - - Investments 40,983 1,973 2,103 5,333 6,266 - - Bond Proceeds 8,546,154 3,244,912 6,000,000 5,700,000 4,700,000 - - - - - - 1,300,000 - - Total Revenues 11,813,454 9,492,185 11,886,703 5,955,333 6,383,266 100,000 210,000 Expenditures Current - - - - - - - Residential Street Improvements 5,347,000 2,159,200 3,510,000 4,592,000 1,300,000 1,150,000 3,220,000 8th Avenue Construction 4,451,317 - - - - - - Light Rail Transit Stations 10,888 - - 800,000 - - - Bond Payment Contribution (Central Park)- 25,000 25,000 100,000 - 125,000 125,000 Blake Road Corridor Improvements 1,167,915 6,974,900 7,683,785 - - - - Street Overlay Improvements - 300,000 325,000 350,000 375,000 400,000 425,000 Street Sign Management - 20,000 20,000 20,000 20,000 20,000 20,000 Transfer Out - Total Expenditures 10,977,120 9,479,100 11,563,785 5,862,000 1,695,000 1,695,000 3,790,000 Working Capital Ending Balance 197,261 210,346 533,264 626,597 5,314,863 3,719,863 139,863 (Unrestricted Net Position) CAPITAL IMPROVEMENT PLAN City of Hopkins, MN - CIP DEPARTMENT SUMMARY 2019 2023thru Total20192020202120222023Department City Hall Administration 4,417,0004,417,000 Comm Svcs - Activity Center 507,00030,000 197,000 105,000 15,000 160,000 Comm Svcs - Arts Center 478,10099,100 152,000 57,000 20,000 150,000 Fire 69,00024,000 45,000 Pavilion 188,00088,000 100,000 Police 73,25073,250 Public Works: Bldg/Equip Serv 235,000145,000 90,000 Public Works: Parks 2,665,000285,000 850,000 1,300,000 100,000 130,000 Public Works: Streets/Traffic 44,327,90013,394,900 9,040,000 9,810,000 2,820,000 9,263,000 Public Works: Transportation 1,420,000620,000 800,000 Public Works: Utilities 4,492,500232,000 73,000 74,000 4,032,500 81,000 Recreation 110,00035,000 50,000 25,000 19,346,000 11,449,250 11,391,000 7,012,500 9,784,000 58,982,750TOTAL Thursday, November 8, 2018 CAPITAL IMPROVEMENT PLAN City of Hopkins, MN - CIP PROJECTS BY DEPARTMENT 2019 2023thru Total20192020202120222023DepartmentProject #Priority City Hall Administration 09-CIP-CH030 4,395,0004,395,000City Hall Lobby Upgrade 1 19-CIP-CH037 22,00022,000City Hall - Roof to Roof Transition Stairs (2)1 4,417,0004,417,000City Hall Administration Total Comm Svcs - Activity Center 08-CIP-AC018 105,000105,000Activity Center - Replace Gymnasium Roof n/a 08-CIP-AC024 80,00080,000Activity Center - Raspberry Room Roof Replacement n/a 09-CIP-AC031 80,00080,000Activity Center - Lower Roof Replacement n/a 17-CIP-AC039 20,00020,000Activity Center - Bathroom Improvements n/a 18-CIP-AC043 22,00022,000Activity Center - Outdoor Signage n/a 19-CIP-AC045 185,00010,000 175,000Activity Center - Facility Improvements n/a 19-CIP-AC048 15,00015,000Activity Center - Gym Acoustical Panels n/a 507,00030,000 197,000 105,000 15,000 160,000Comm Svcs - Activity Center Total Comm Svcs - Arts Center 17-CIP-AR004 80,00080,000Arts Center - Theater Curtains 3 18-CIP-AR008 30,00030,000Arts Center - Building Automation System 1 19-CIP-AR001 74,00030,000 22,000 22,000Arts Center - Carpeting 2 19-CIP-AR002 10,00010,000Arts Center - Outdoor Signage/lighting 2 19-CIP-AR003 15,00015,000Arts Center - Tile Flooring n/a 19-CIP-AR004 11,10011,100Arts Center - Water Fountain Replacement 5 19-CIP-AR005 78,00018,000 20,000 20,000 20,000Arts Center - Key Card Exterior & Interior Access 2 19-CIP-AR006 30,00030,000Arts Center - Fire Panel 2 19-CIP-AR007 150,000150,000Arts Center - Roof Replacement 2 478,10099,100 152,000 57,000 20,000 150,000Comm Svcs - Arts Center Total Fire 08-CIP-FD123 45,00045,000Fire Station - Replace Boilers n/a 19-CIP-FD001 24,00024,000Fire - Garage Door Openers 2 69,00024,000 45,000Fire Total Pavilion 13-CIP-PV321 45,00045,000Pavilion Mezzanine Rooftop Unit Replacement 1 13-CIP-PV322 15,00015,000Pavilion HHS Team Room Rooftop Unit Repl 1 19-CIP-PV330 90,00090,000Pavilion - Indoor Turf System Replacement 2 19-CIP-PV331 10,00010,000Pavilion - Arena Lighting Replacement 2 19-CIP-PV332 28,00028,000Pavilion - Pav/Cent Park Sound System 2 188,00088,000 100,000Pavilion Total Police 08-CIP-PD016 73,25073,250Replace Carpet - Police Station n/a Thursday, November 8, 2018 Total20192020202120222023DepartmentProject #Priority 73,25073,250Police Total Public Works: Bldg/Equip Serv 08-CIP-B021 50,00050,000Public Works - Replace Wash Bay Roof n/a 08-CIP-B023 90,00090,000Public Works - Replace Overhead Doors n/a 09-CIP-B034 50,00050,000Public Works Garage Roof Replacement n/a 18-CIP-B007 25,00025,000PW Exterior Painting n/a 19-CIP-B008 20,00020,000Public Works - Fuel Dispenser Replacement n/a 235,000145,000 90,000Public Works: Bldg/Equip Serv Total Public Works: Parks 05-CIP-P202 10,00010,000Central Park Tennis Courts n/a 13-CIP-P044 130,000130,000Oakes Park - Tennis Courts n/a 13-CIP-P063 100,000100,000Maetzold Field - Pavilion n/a 13-CIP-P066 150,000150,000Shady Oak Beach - Picnic Shelter 3 13-CIP-P068 150,000150,000Valley Park - Picnic Shelter 3 16-CIP-P002 450,000450,000Cottageville Park - Phase III Improvements n/a 17-CIP-P004 100,000100,000Downtown Park Rehab 3 17-CIP-P005 25,00025,000Oakes Park Cricket Pitch n/a 19-CIP-P001 1,300,0001,300,000Central Park Improvements n/a 19-CIP-P002 250,000250,000Park Lighting Upgrade n/a 2,665,000285,000 850,000 1,300,000 100,000 130,000Public Works: Parks Total Public Works: Streets/Traffic 01-CIP-S101 32,403,0005,575,000 8,570,000 9,390,000 2,375,000 6,493,000Residential Street Improvements and Utilities n/a 01-CIP-S104 2,300,0002,300,000County Road 3 n/a 13-CIP-S040 200,00025,000 100,000 25,000 25,000 25,000Pedestrian & Bicycle Access Improvements n/a 15-CIP-S001 7,449,9007,449,900Blake Road Corridor Improvements n/a 16-CIP-S041 1,875,000325,000 350,000 375,000 400,000 425,000Street Overlay Improvements n/a 16-CIP-S042 100,00020,000 20,000 20,000 20,000 20,000Street Sign Management n/a 44,327,90013,394,900 9,040,000 9,810,000 2,820,000 9,263,000Public Works: Streets/Traffic Total Public Works: Transportation 01-CIP-S502 1,420,000620,000 800,000Light Rail Transit Stations (3)n/a 1,420,000620,000 800,000Public Works: Transportation Total Public Works: Utilities 01-CIP-U002 120,00022,000 23,000 24,000 25,000 26,000Storm Drainage System Maintenance - Alley Repairs n/a 08-CIP-U001 160,000160,000Lift Station # 4 n/a 18-CIP-U016 257,50050,000 50,000 50,000 52,500 55,000Sewer Lining 2 19-CIP-U017 3,955,0003,955,000Trunk Water Main Rehabilitation 2 4,492,500232,000 73,000 74,000 4,032,500 81,000Public Works: Utilities Total Recreation 16-CIP-R003 110,00035,000 50,000 25,000Shady Oak Beach Improvements 3 110,00035,000 50,000 25,000Recreation Total GRAND TOTAL 58,982,75019,346,000 11,449,250 11,391,000 7,012,500 9,784,000 Thursday, November 8, 2018 CAPITAL IMPROVEMENT PLAN City of Hopkins, MN - CIP FUNDING SOURCE SUMMARY 2019 thru 2023 TotalSource20192020202120222023 AC - Arts Center Fund 478,10099,100 152,000 57,000 20,000 150,000 CI - Capital Improvement Fund 5,024,2504,387,000 312,250 150,000 15,000 160,000 CT - Cable Franchise Fees 150,000150,000 GU - Other Governmental Units 7,478,4005,728,100 133,500 16,800 1,600,000 MS - Municipal State Aid Streets 700,000700,000 PA - Pavilion Fund 188,00088,000 100,000 PDF- Park Dedication Fund 2,601,200296,500 766,500 1,300,000 108,200 130,000 PI - PIR/General Obligation Bonds 16,339,3003,400,300 4,262,000 3,492,000 2,545,000 2,640,000 RF - Refuse Fund 33,00015,000 18,000 SA - Special Assessment 6,000,0001,250,000 1,600,000 1,600,000 500,000 1,050,000 SF - Sanitary Sewer Fund 6,947,5001,250,000 1,575,000 1,757,000 947,500 1,418,000 SU - Storm Sewer Fund 3,593,000852,000 861,000 964,000 410,000 506,000 WF - Water Fund 9,450,0001,830,000 1,669,000 2,071,000 2,450,000 1,430,000 19,346,000 11,449,250 11,391,000 7,012,500 9,784,000 58,982,750GRAND TOTAL Thursday, November 8, 2018 CAPITAL IMPROVEMENT PLAN City of Hopkins, MN - CIP PROJECTS BY FUNDING SOURCE 2019 2023thru TotalSourceProject #Priority 2019 2020 2021 2022 2023 AC - Arts Center Fund 17-CIP-AR004 80,00080,000Arts Center - Theater Curtains 3 18-CIP-AR008 30,00030,000Arts Center - Building Automation System 1 19-CIP-AR001 74,00030,000 22,000 22,000Arts Center - Carpeting 2 19-CIP-AR002 10,00010,000Arts Center - Outdoor Signage/lighting 2 19-CIP-AR003 15,00015,000Arts Center - Tile Flooring n/a 19-CIP-AR004 11,10011,100Arts Center - Water Fountain Replacement 5 19-CIP-AR005 78,00018,000 20,000 20,000 20,000Arts Center - Key Card Exterior & Interior Access 2 19-CIP-AR006 30,00030,000Arts Center - Fire Panel 2 19-CIP-AR007 150,000150,000Arts Center - Roof Replacement 2 478,10099,100 152,000 57,000 20,000 150,000AC - Arts Center Fund Total CI - Capital Improvement Fund 08-CIP-AC018 105,000105,000Activity Center - Replace Gymnasium Roof n/a 08-CIP-AC024 80,00080,000Activity Center - Raspberry Room Roof Replacement n/a 08-CIP-B021 10,00010,000Public Works - Replace Wash Bay Roof n/a 08-CIP-B023 18,00018,000Public Works - Replace Overhead Doors n/a 08-CIP-FD123 45,00045,000Fire Station - Replace Boilers n/a 08-CIP-PD016 73,25073,250Replace Carpet - Police Station n/a 09-CIP-AC031 80,00080,000Activity Center - Lower Roof Replacement n/a 09-CIP-B034 50,00050,000Public Works Garage Roof Replacement n/a 09-CIP-CH030 4,245,0004,245,000City Hall Lobby Upgrade 1 17-CIP-AC039 20,00020,000Activity Center - Bathroom Improvements n/a 18-CIP-AC043 22,00022,000Activity Center - Outdoor Signage n/a 18-CIP-B007 25,00025,000PW Exterior Painting n/a 19-CIP-AC045 185,00010,000 175,000Activity Center - Facility Improvements n/a 19-CIP-AC048 15,00015,000Activity Center - Gym Acoustical Panels n/a 19-CIP-B008 5,0005,000Public Works - Fuel Dispenser Replacement n/a 19-CIP-CH037 22,00022,000City Hall - Roof to Roof Transition Stairs (2)1 19-CIP-FD001 24,00024,000Fire - Garage Door Openers 2 5,024,2504,387,000 312,250 150,000 15,000 160,000CI - Capital Improvement Fund Total CT - Cable Franchise Fees 09-CIP-CH030 150,000150,000City Hall Lobby Upgrade 1 150,000150,000CT - Cable Franchise Fees Total GU - Other Governmental Units 01-CIP-S104 1,600,0001,600,000County Road 3 n/a 13-CIP-P066 100,000100,000Shady Oak Beach - Picnic Shelter 3 15-CIP-S001 5,704,6005,704,600Blake Road Corridor Improvements n/a 16-CIP-R003 73,80023,500 33,500 16,800Shady Oak Beach Improvements 3 Thursday, November 8, 2018 TotalSourceProject #Priority 2019 2020 2021 2022 2023 7,478,4005,728,100 133,500 16,800 1,600,000GU - Other Governmental Units Total MS - Municipal State Aid Streets 01-CIP-S104 700,000700,000County Road 3 n/a 700,000700,000MS - Municipal State Aid Streets Total PA - Pavilion Fund 13-CIP-PV321 45,00045,000Pavilion Mezzanine Rooftop Unit Replacement 1 13-CIP-PV322 15,00015,000Pavilion HHS Team Room Rooftop Unit Repl 1 19-CIP-PV330 90,00090,000Pavilion - Indoor Turf System Replacement 2 19-CIP-PV331 10,00010,000Pavilion - Arena Lighting Replacement 2 19-CIP-PV332 28,00028,000Pavilion - Pav/Cent Park Sound System 2 188,00088,000 100,000PA - Pavilion Fund Total PDF- Park Dedication Fund 05-CIP-P202 10,00010,000Central Park Tennis Courts n/a 13-CIP-P044 130,000130,000Oakes Park - Tennis Courts n/a 13-CIP-P063 100,000100,000Maetzold Field - Pavilion n/a 13-CIP-P066 50,00050,000Shady Oak Beach - Picnic Shelter 3 13-CIP-P068 150,000150,000Valley Park - Picnic Shelter 3 16-CIP-P002 450,000450,000Cottageville Park - Phase III Improvements n/a 16-CIP-R003 36,20011,500 16,500 8,200Shady Oak Beach Improvements 3 17-CIP-P004 100,000100,000Downtown Park Rehab 3 17-CIP-P005 25,00025,000Oakes Park Cricket Pitch n/a 19-CIP-P001 1,300,0001,300,000Central Park Improvements n/a 19-CIP-P002 250,000250,000Park Lighting Upgrade n/a 2,601,200296,500 766,500 1,300,000 108,200 130,000PDF- Park Dedication Fund Total PI - PIR/General Obligation Bonds 01-CIP-S101 11,144,0002,260,000 2,992,000 3,072,000 650,000 2,170,000Residential Street Improvements and Utilities n/a 01-CIP-S502 800,000800,000Light Rail Transit Stations (3)n/a 13-CIP-S040 200,00025,000 100,000 25,000 25,000 25,000Pedestrian & Bicycle Access Improvements n/a 15-CIP-S001 770,300770,300Blake Road Corridor Improvements n/a 16-CIP-S041 1,875,000325,000 350,000 375,000 400,000 425,000Street Overlay Improvements n/a 16-CIP-S042 100,00020,000 20,000 20,000 20,000 20,000Street Sign Management n/a 19-CIP-U017 1,450,0001,450,000Trunk Water Main Rehabilitation 2 16,339,3003,400,300 4,262,000 3,492,000 2,545,000 2,640,000PI - PIR/General Obligation Bonds Total RF - Refuse Fund 08-CIP-B021 10,00010,000Public Works - Replace Wash Bay Roof n/a 08-CIP-B023 18,00018,000Public Works - Replace Overhead Doors n/a 19-CIP-B008 5,0005,000Public Works - Fuel Dispenser Replacement n/a 33,00015,000 18,000RF - Refuse Fund Total SA - Special Assessment 01-CIP-S101 6,000,0001,250,000 1,600,000 1,600,000 500,000 1,050,000Residential Street Improvements and Utilities n/a Thursday, November 8, 2018 TotalSourceProject #Priority 2019 2020 2021 2022 2023 6,000,0001,250,000 1,600,000 1,600,000 500,000 1,050,000SA - Special Assessment Total SF - Sanitary Sewer Fund 01-CIP-S101 5,577,000500,000 1,507,000 1,707,000 500,000 1,363,000Residential Street Improvements and Utilities n/a 01-CIP-S502 150,000150,000Light Rail Transit Stations (3)n/a 08-CIP-B021 10,00010,000Public Works - Replace Wash Bay Roof n/a 08-CIP-B023 18,00018,000Public Works - Replace Overhead Doors n/a 08-CIP-U001 160,000160,000Lift Station # 4 n/a 15-CIP-S001 375,000375,000Blake Road Corridor Improvements n/a 18-CIP-U016 257,50050,000 50,000 50,000 52,500 55,000Sewer Lining 2 19-CIP-B008 5,0005,000Public Works - Fuel Dispenser Replacement n/a 19-CIP-U017 395,000395,000Trunk Water Main Rehabilitation 2 6,947,5001,250,000 1,575,000 1,757,000 947,500 1,418,000SF - Sanitary Sewer Fund Total SU - Storm Sewer Fund 01-CIP-S101 3,065,000600,000 820,000 940,000 225,000 480,000Residential Street Improvements and Utilities n/a 01-CIP-S502 120,000120,000Light Rail Transit Stations (3)n/a 01-CIP-U002 120,00022,000 23,000 24,000 25,000 26,000Storm Drainage System Maintenance - Alley Repairs n/a 08-CIP-B021 10,00010,000Public Works - Replace Wash Bay Roof n/a 08-CIP-B023 18,00018,000Public Works - Replace Overhead Doors n/a 15-CIP-S001 100,000100,000Blake Road Corridor Improvements n/a 19-CIP-U017 160,000160,000Trunk Water Main Rehabilitation 2 3,593,000852,000 861,000 964,000 410,000 506,000SU - Storm Sewer Fund Total WF - Water Fund 01-CIP-S101 6,617,000965,000 1,651,000 2,071,000 500,000 1,430,000Residential Street Improvements and Utilities n/a 01-CIP-S502 350,000350,000Light Rail Transit Stations (3)n/a 08-CIP-B021 10,00010,000Public Works - Replace Wash Bay Roof n/a 08-CIP-B023 18,00018,000Public Works - Replace Overhead Doors n/a 15-CIP-S001 500,000500,000Blake Road Corridor Improvements n/a 19-CIP-B008 5,0005,000Public Works - Fuel Dispenser Replacement n/a 19-CIP-U017 1,950,0001,950,000Trunk Water Main Rehabilitation 2 9,450,0001,830,000 1,669,000 2,071,000 2,450,000 1,430,000WF - Water Fund Total 58,982,75019,346,000 11,449,250 11,391,000 7,012,500 9,784,000GRAND TOTAL Thursday, November 8, 2018 2019 –2023 Equipment Replacement Plan Council Work Session November 13, 2018 2019 –2023 ERP 5 year plan, updated annually Included as part of Financial Management Plan 2019 –2023 ERP Funding Sources User Department Charges Increasing by 9% $533,569 in 2019 Primarily from General Fund Tax Levy $230,000 in 2019 Reduced since preliminary levy for lower IT cost options 2019 –2023 ERP Directly Funded Arts Center, HRA and Utility Funds 2019 –2023 ERP 2019 Uses of Funds Activity Center - $16,000 Dishwasher Information Technology - $153,390 Network server computers, Office 365, VPN, E-Mail Threat Protection, Patching Automation 2019 –2023 ERP 2019 Uses of Funds Police - $258,000 Marked patrol vehicles, squad car camera system, data server and mobile data computers Streets/Traffic - $230,000 Sweeper 2019 –2023 ERP Working Capital Projection $41,007 at end of 2019 Positive balance in future years with levy and 2023 Equipment Certificates 2019 –2023 Capital Improvement Plan Council Work Session November 13, 2018 2019 –2023 CIP 5 year plan, updated annually Funds included in Financial Management Plan Park Capital Capital Improvement Permanent Improvement Revolving Pavilion Arts Center 2019 –2023 CIP Park Capital Improvement Fund Funded by Franchise Fees, $295,300 in 2019 Dedication Fees, $1,000,000 o Cold Storage Site 2019 –2023 CIP Park Capital Improvement Fund $296,500 of projects in 2019 Park Lighting Upgrade -$250,000 Oakes Park Cricket Pitch -$25,000 Central Park Tennis Courts -$10,000 Shady Oak Beach Maintenance -$11,500 o $35,000 total split 67%/33% between Minnetonka/Hopkins 2019 –2023 CIP Park Capital Improvement Fund Projected balance of $1,020,714 at end of 2019 Dependent on timing of Cold Storage dedication fees 2019 –2023 CIP Capital Improvement Fund Funded by Tax Levy, $100,000 in 2019 o (as high as $310,000 in 2017) Franchise Fees, $360,000 in 2019 2019 –2023 CIP Capital Improvement Fund $4,387,000 of projects in 2019 City Hall Project -$4,245,000 o Also funded by Communications Fund Public Works Building -$90,000 Activity Center -$30,000 City Hall Roof Stairs -$22,000 2019 –2023 CIP Capital Improvement Fund Projected balance of $63,853 at end of 2019 2019 –2023 CIP Municipal State Aid Fund Received funds in 2018 Next scheduled project is 2023 Projected balance of $62,254 at end of 2019 2019 –2023 CIP Permanent Improvement Revolving 2019 Funding Sources Bond Proceeds -$6,000,000 o Paid with Tax Levy and Special Assessments Grants -$5,325,455 Prepaid Special Assessments -$180,000 2019 –2023 CIP Permanent Improvement Revolving $11,563,785 of projects in 2019 2nd Half of Blake Road -$7,683,785 Residential Street Improvements -$3,510,000 Street Overlay -$325,000 Pedestrian & Bicycle Access -$25,000 Street Signs -$20,000 2019 –2023 CIP Permanent Improvement Revolving Projected balance of $210,346 at end of 2019 CITY OF HOPKINS Memorandum To: Honorable Mayor and Council Members Mike Mornson, City Manager From: Nick Bishop, Finance Director Date: November 13, 2018 Subject: 2019 Enterprise and Special Revenue Fund Budgets _____________________________________________________________________ PURPOSE To provide input and guidance for the 2019 Enterprise and Special Revenue Fund Budgets. INFORMATION The attached presentation gives an overview of the Enterprise and Special Revenue Fund budgets. FUTURE ACTION Approval of the budgets is scheduled for December 4, 2018 (as part of General Fund and Tax Levy Approval). Finance Dept. 2019 Enterprise Fund Budgets Council Work Session November 13, 2018 2019 Enterprise Budgets Estimated consumption reduced by 5.3% 6.8% Rate Increase Additional Costs for Depreciation, Principal & Interest Water 2018 2019 %age Budget Budget Incr (Decr) Revenues 2,147,086$ 2,168,556$ 1.00% Expenditures 1,980,810$ 2,168,556$ 9.48% Revenues over (under) Expenditures 166,276$ -$ -100.00% 2019 Enterprise Budgets Estimated consumption reduced by 4.5% 5.6% Rate Increase Additional Costs for Depreciation, Principal & Interest Sewer 2018 2019 %age Budget Budget Incr (Decr) Revenues 3,088,299$ 3,119,182$ 1.00% Expenditures 2,746,202$ 3,067,143$ 11.69% Revenues over (under) Expenditures 342,097$ 52,039$ -84.79% 2019 Enterprise Budgets Revenue reduction from County Recycling Grant Refuse 2018 2019 %age Budget Budget Incr (Decr) Revenues 1,010,500$ 1,009,267$ -0.12% Expenditures 987,379$ 965,113$ -2.26% Revenues over (under) Expenditures 23,121$ 44,154$ 90.97% 2019 Enterprise Budgets Additional costs for Depreciation, Principal and Interest Storm Sewer 2018 2019 %age Budget Budget Incr (Decr) Revenues 810,200$ 793,532$ -2.06% Expenditures 526,942$ 605,940$ 14.99% Revenues over (under) Expenditures 283,258$ 187,592$ -33.77% 2019 Enterprise Budgets $40,383 of Tax Levy in 2019 Will continue in future years Includes $100,000 of depreciation and $53,000 of interest costs Pavilion 2018 2019 %age Budget Budget Incr (Decr) Revenues 445,000$ 519,383$ 16.72% Expenditures 476,548$ 635,517$ 33.36% Revenues over (under) Expenditures (31,548)$ (116,134)$ -268.12% 2019 –Special Revenue Fund Budgets Council Work Session November 13, 2018 2019 Special Revenue Budgets Includes $257,500 Tax Levy Consistent with projections to eliminate deficit fund balance by 2024 Arts Center 2018 2019 Percentage Budget Budget Incr (Decr) Revenues 975,626$ 988,582$ 1.33% Expenditures 992,908$ 1,005,600$ 1.28% Revenues over (under) Expenditures (17,282)$ (17,018)$ 1.53% 2019 Special Revenue Budgets 2019 2020 2021 2022 2023 2024 2025 2026 Budget REVENUE 4 General Property Tax - Sustain Operations 257,500 265,225 273,182 281,377 289,819 298,513 489,694 518,342 5 Transfers In - From Communications Fund 86,920 86,920 86,920 86,920 86,920 86,920 20,000 20,000 6 Intergovernmental 41,820 42,656 43,509 44,379 45,267 46,172 47,095 48,037 7 Charges for services 267,648 273,001 278,461 284,030 289,711 295,505 301,415 307,443 8 Lease Revenue 300,251 309,259 318,536 328,093 337,935 348,073 358,516 369,271 9 Contributions & Donations 43,800 43,800 43,800 43,800 43,800 43,800 43,800 43,800 10 Economic Development Loan Forgiveness - - - - - - - - 11 Total Revenue 997,939 1,020,861 1,044,408 1,068,599 1,093,452 1,118,984 1,260,520 1,306,894 EXPENSES 12 Total Current 914,957 949,268 984,865 1,021,798 1,060,115 1,099,870 1,141,115 1,183,907 13 Total Capital Projects 100,000 103,000 106,090 109,273 112,551 115,927 119,405 122,987 14 Total Expenses 1,014,957 1,052,268 1,090,955 1,131,071 1,172,666 1,215,797 1,260,520 1,306,894 15 Revenues Over / (Under) Expenses (17,018) (31,407) (46,547) (62,472) (79,215) (96,814) (0) (0) 16 General Property Tax - Deficit - 134,775 426,818 418,623 410,181 401,487 - - 17 Increase/(Decrease) in Fund Balance (17,018) 103,368 380,271 356,151 330,966 304,673 (0) (0) 18 Ending Fund Balance (1,330,111) (1,226,743) (846,472) (490,321) (159,354) 145,319 145,319 145,318 Arts Center Projected 2019 Special Revenue Budgets Expenditures are reimbursed by grant Chemical Assessment 2018 2019 Percentage Budget Budget Incr (Decr) Revenues 60,000$ 60,000$ 0.00% Expenditures 60,000$ 60,000$ 0.00% Revenues over (under) Expenditures -$ -$ 0.00% 2019 Special Revenue Budgets Levy at maximum of $350,154 Includes $100,000 in Façade Improvement Grants Economic Development 2018 2019 Percentage Budget Budget Incr (Decr) Revenues 402,037$ 395,154$ -1.71% Expenditures 245,700$ 390,519$ 58.94% Revenues over (under) Expenditures 156,337$ 4,635$ -97.04% 2019 Special Revenue Budgets Includes increased rates for 2019 Parking 2018 2019 Percentage Budget Budget Incr (Decr) Revenues 150,500$ 152,650$ 1.43% Expenditures 113,529$ 141,783$ 24.89% Revenues over (under) Expenditures 36,971$ 10,867$ -70.61% 2019 Special Revenue Budgets Rates Approved on September 18th 2019 Special Revenue Budgets Planned use of fund balance for City Hall Project Communications 2018 2019 Percentage Budget Budget Incr (Decr) Revenues 269,200$ 255,235$ -5.19% Expenditures 285,566$ 482,459$ 68.95% Revenues over (under) Expenditures (16,366)$ (227,224)$ -1288.39% 2019 Special Revenue Budgets Includes $5,000 additional contribution from both Hopkins and Minnetonka Depot - Youth 2018 2019 Percentage Budget Budget Incr (Decr) Revenues 117,000$ 127,100$ 8.63% Expenditures 126,515$ 132,640$ 4.84% Revenues over (under) Expenditures (9,515)$ (5,540)$ -41.78% 2019 Special Revenue Budgets Staff Reductions in 2019 SWLRT Construction Temporary parking lot to West of building Trail detours and possible closure Depot - Coffee Operations 2018 2019 Percentage Budget Budget Incr (Decr) Revenues 235,000$ 235,500$ 0.21% Expenditures 241,238$ 215,285$ -10.76% Revenues over (under) Expenditures (6,238)$ 20,215$ -424.06% 2019 Special Revenue Budgets Requested additional funding from Hopkins School District the Three Rivers Park District Nothing included in this budget Depot 2018 2019 Percentage Budget Budget Incr (Decr) Revenues 352,000$ 362,600$ 3.01% Expenditures 367,753$ 347,925$ -5.39% Revenues over (under) Expenditures (15,753)$ 14,675$ -193.16%