Other Projects                                      2018-2022                   Capital Improvements Program       Schedule for Five Year Period
             Special assessment Bonds = a                                      Abatement District = ad                             Olmsted County = c Electric Utility =  eu Federal Funds =  f Flood Control Reserves =  fr                                              
                     Food & Beverage Tax = fb                                          Local Gov't Aid = ga              General Obligation Bonds = go Lodging Tax =  lt MN State Aid - Streets =  ms Operating Trfs - fr Storm Water =  os                                              
       Operating Trfs-fr General Fund = ot                   Operating Trfs-fr Sewer Utility = ow                               Private Funds = p Project Reserves =  r GO Revenue Bonds =  rb Retained Earnings = re                                              
                                     State Funds = s                          Sn/Sewer Availability Chg = sa                              Sales Tax DMC = sd State DMC Funds =  sm Sales Tax 2013 =  st Storm Water Mgmt Chg =  sw                                              
                                          Tax Levy = t                     Traffic Improvement Dist Chg = td                                Tax Increments = ti Operating Trfs - fr Other Funds = to Water Availability Chg =  wa Water Utility =  wu                                              
 2002-2017
Sort Map # Project Description Proj # Total Budget CIP Bdgt Amts 2018 2019 2020 2021 2022 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 Totals
0                          -  
1 1 Fire Station Infrastructure Improvements at various stations.  Prior year reserves transferred from J1918 (Misc. Fire Equipment-non vehicles).  2020-replace Station 3 roof. 1024                915,000             125,000  t              125,000 t             100,000 t             315,000 t             100,000 t             100,000 t t       50,000      75,000         125,000
1                 50,000  r  r      50,000           50,000
1                          -  
2 2 Land acquisition and construction for future Fire Station #6; land acquisition for future Fire Station #7.  Reserves to be transferred from J2003 (Future Property Acquisition). 1012            2,600,000             700,000  r              300,000 r             700,000 r             900,000 r r    700,000         700,000
2                          -  
3 3 Update Video Conferencing equipment, specifically cameras, recording equipment and monitors that are at the end of their 5 year replacement life. 1990                635,000             470,000  t                65,000 t             100,000 t t       275,000         45,000       50,000    100,000         470,000
3                          -  
4 4 800 MHz portable radio replacement for the Fire Dept., replace 60 radios over 4 yr time table.                422,000                   95,000 t               85,000 t               80,000 t               82,000 t               80,000 t                    -  
4                          -  
5 5 VHF Back-Up radio/paging system.  1960                  60,000                   20,000 t               20,000 t               20,000 t                    -  
5                          -  
6 6 SCBA units to replace outdated stock that is no longer supported by manufacturer. 1934                550,000               50,000  t                50,000 t               50,000 t             200,000 t             200,000 t t      50,000           50,000
6                          -  
7 7 Modular Live Fire Attack props and Training Containers to be used at the regional training facility phased in over a 5 year period.  Request fire classroom building for Regional Training Center site.   1978            1,300,000                 100,000 t             600,000 t             600,000 t                    -  
7                          -  
8 8 Emergency Operations Center (EOC) Technology.  Prior year reserves transferred from J1920 (CPAT Fitness & Testing Equip).  Phase 2 of technology installation in EOC. 1924                245,000               85,000  t                10,000 t               10,000 t               92,090 t               10,000 t t       75,000      10,000           85,000
8                 37,910  r  r      37,910           37,910
8      
9 9 Emergency Management Improvements.  Move one siren to a new location on West Circle Drive.  Added voice modulator device in needed areas in the City.  2049                150,000                   60,000 t               55,000 t               35,000 t t                    -  
9                          -  
10 10 RPD Precinct #2 at 41st St NW.  Building improvements to the Think Bank Bldg.  Interfund loan in 2017 from the Group Insurance Fund. 1023          14,212,000             417,000  to              735,000 go       10,500,000 go to    417,000         417,000
10                1,280,000 t          1,280,000 t
10                          -  
11 11 LEC Expanded identity management and video management capabilities through Intelligence Management programs.  Prior year reserves were transferred from J1917 (Automated License Plate Reader), J1915 ($34K) and J1944 ($118K). 1916            2,341,468             527,480  ga              191,661 t             152,561 t ga        200,000 327,480         527,480
11               820,719  t  t  345,953      98,000 180766 196,000         820,719
11               418,047  r  r  131,047 135000    152,000         418,047
11               231,000  ot  ot 231000         231,000
11                          -  
12 12 LEC In-Squad Video System. 1967                275,000             200,000  ot  75,000 t ot 200,000         200,000
12                          -  
13 13 ARMER Base Radio Replacement. 1956                210,932               52,733  t  52,733 t 52,733 t 52,733 t t 52,733           52,733
13                          -  
14 14 800 MHz portable radio replacement for the Police Dept.                995,000     199,000 t 199,000 t 199,000 t 199,000 t 199,000 t                    -  
14                          -  
15 15 800 MHz mobile radio replacement for the Police Dept.                428,000     85,600 t 85,600 t 85,600 t 85,600 t 85,600 t                    -  
15                          -  
16 16 Police range updates & maintenance.                500,000                 231,938 t             268,062 t                    -  
16                          -  
17 17 LEC smartphone replacements.                  35,000     35,000 t
17      
18 18 Driver's license swipe card reader.                  27,500     27,500 t
18      
19 19 Public Safety camera system.                  40,000     40,000 t
19      
20 20 Brazos Electronic Ticketing.                  60,000     60,000 t
20      
21 21 Additional dispatch work station located within the current LEC Dispatch Center.                377,324     188,662 t
21       188,662 c
21      
22 22 Public Safety Answering Point (PSAP) project-completion of dispatch center at Fire Station #2.            2,279,420     2,279,420 go                    -  
22                          -  
23 23 Multi-Purpose Specialty Vehicle for Forensic Mapping Unit (FMU) and Crime Scene Unit (CSU) - project includes equipment within the vehicle.                453,811                 453,811 t                    -  
23                          -  
24 24 Armored Rescue Vehicle for ERU.                253,742     253,742 t                    -  
24                          -  
25 25 Capital purchase of computer hardware/software for the Public Library. Funds will be transferred from the Library Information Technology Revolving Fund. 2041            1,648,654             184,408  c  13,604 c 13,604 c 13,604 c 13,604 c 13,604 c c         8,832         8,832         9,219       11,764       13,553         13,448         13,356          13,523          13,604      10,257 13,604 13,604 13,604 13,604 13,604         184,408
25            1,017,351  to  75,775 to 75,775 to 75,775 to 75,775 to 75,775 to to       70,026       70,026       70,026       75,026         75,026         70,118          69,951          70,370      74,717 72,370 73,370 74,775 75,775 75,775     1,017,351
25                          -  
26 26 Public Library Improvements:  projects include ongoing building improvements e.g. carpet replacement, refinishing/painting and other major projects. 2018: AV Lab equipment, DVD shelving, reupholstery of chairs, lighting upgrade, Literacy Nook, single man 20 foot platform lift, and other building improvements/equipment. 2039            1,838,480             686,538  t  49,000 t 100,000 t 100,000 t 200,000 t 110,000 to t       33,829         46,231         83,870             7,555 115,586 90,800 65,011 90,629 153,027         686,538
26                 34,610  ga  8,600 c 8,600 c 8,600 c 8,600 c 8,600 c ga          20,946 13,664           34,610
26               197,304  c  c       63,559            8,287         15,975             1,458          14,054 27,015 9,783 25,000 32,173         197,304
26               318,028  ot  ot    318,028         318,028
26                          -  
27 27 Public Library Building Maintenance-5 year plan for roof replacement, building envelope repair and major equipment replacement. 2043            2,044,800     485,038 t 485,038 t 485,038 t 485,038 t t
27       26,162 c 26,162 c 26,162 c 26,162 c c
27      
27                          -  
28 28 City Wide IT Integration.  Consulting for discovery, solution design & migration tools.  2017: Hardware for servers, storage, network along with virtualization and server licensing along with basic security services.  2018: Advanced networking separation for virtualized environment. DMZ virtualization 2019: ITIL Implementation services and 1st year costs.  Prior reserves were transferred from J2032 (Library IS Integration). 1997            1,150,000             417,702  t              210,000 t 105,000 t t    227,702    190,000         417,702
28                 72,298  r                54,000 eu 27,000 eu r       72,298           72,298
28               126,000  eu                   6,000 wu 3,000 wu eu    126,000         126,000
28                 14,000  wu                15,000 to 7,500 to wu      14,000           14,000
28                 35,000  to                12,000 ow 6,000 ow to      35,000           35,000
28                 28,000  ow                   3,000 os 1,500 os ow      28,000           28,000
28                    7,000  os  os        7,000             7,000
28      
29 29 City wide (includes RPU & RPL) IT Security tooling. 2017: Security Information and Event Management (SIEM - centralized logging and correlation of events for incident identification and resolution). 2018: Vulnerability Management (active auditing and reporting of IT systems for patching compliance and security best practices); Governance, Risk Management & Compliance (GRC - activities intended to ensure that the IT organization supports the current and future needs of the business, and complies with all IT-related mandates). 1895                325,000             105,000  t              122,500 t t    105,000         105,000
29                 27,000  eu                31,500 eu eu      27,000           27,000
29                    3,000  wu                   3,500 wu wu        3,000             3,000
29                    7,500  to                   8,750 to to        7,500             7,500
29                    6,000  ow                   7,000 ow ow        6,000             6,000
29                    1,500  os                   1,750 os os        1,500             1,500
29                          -  
30 30 Life/Safety Rehab and Upgrades to Traffic Operations Building (TOB).   Work to be phased over several years, based on building / functional analysis and report.  2018: office HVAC system, replace vehicle parking storage HVAC system.  Retained earnings from Parking enterprise funds. 1010                500,000             100,000  t                70,000 t               25,000 t t    100,000         100,000
30               210,000  to                70,000 to               25,000 to to      50,000    100,000      60,000         210,000
30      
31 31 GIS-based Work Management software.  Multi-departmental Integration of information from citizen calls, inspections and infrastructure assets to produce work orders, process permits, and track expenditures.  Retained Earnings to be transferred from the Sewer Fund and Storm Water Fund, 50% each.  Prior reserves were transferred from J2200 (Street Rehab). 1912                745,000             300,000  t                12,500 os t    100,000    100,000    100,000         300,000
31               105,000  os                12,500 ow os      37,500      37,500       15,000      15,000         105,000
31               105,000  ow  ow      37,500      37,500       15,000      15,000         105,000
31               105,000  fr  fr      37,500      37,500       15,000      15,000         105,000
31               105,000  r  r      37,500      37,500       15,000      15,000         105,000
31                          -  
32 32 Convert Street Lights to LED (2000 lights per year).            3,000,000              1,000,000 t          1,000,000 t          1,000,000 t                    -  
32                          -  
33 33 Construct "City Entrance / Welcome Sign" on TH52 North (north of 75th St NW).                  300,000                 300,000 t                    -  
33                          -  
34 34 Purchase property to replace old North Public Works Maintenance Material Storage area.  Old Maintenance Storage area to be used for future WRP expansion.                 500,000                 500,000 t                    -  
34      
35 35 Rochester Civic Theatre Improvements.  2017: $15,000 exterior and interior surface repairs and painting, $15,000 audio visual equipment, $15,000 completion of interior remodeling.  2018: $15,000 exterior surface repairs and painting, interior insulation, $10,000 electrical work. 2079                579,665             338,599  t                25,000 t               25,000 t               25,000 t               25,000 t t       43,000     15,850     21,098     38,000       15,651          65,000    20,000      20,000      25,000      35,000      40,000         338,599
35                 30,000  ga  ga          30,000           30,000
35               111,066  ot  ot   111,066         111,066
35                          -  
36 36 Rochester Art Center Improvements.  2017: rebrand, Building a Creative City, wireless connection, new stage, computer upgrades, and painting atrium space.  2018: Security systems, painting and repair of non-gallery walls, clean main hall ceiling, skylight leak repair. 2070                643,434             489,534  t                38,000 t               25,000 t               25,000 t               25,000 t t       12,500     95,000     83,000     15,000     56,431       17,457       15,976             8,000    19,400      35,700      45,105      16,585       31,380      38,000         489,534
36                 40,900  ga  ga          40,900           40,900
37 37 Energy Performance Contract - Multiple Locations. 2018: City Hall building-wide LED lighting retrofit and recommissioning effort targeted to reduce energy consumption of the facility, while improving its operation and maintenance routines.                200,000                 200,000 fr
37      
38 38 Fire panel replacement and code upgrade for City Hall due to the age of the system.   1910                775,000             165,000  t              610,000 t t 165000         165,000
38      
39 39 City Hall Building Security Upgrades. 1029                400,000             180,000  t                50,000 t t 180000         180,000
39               127,000  ot  ot 127000         127,000
39                 43,000  r  r 43000           43,000
40 40 City Attorney Office: renovate and convert existing law library into two separate offices for future employee expansion.  One office would be for State funded victim witness liaison and would utilize $5,000 of grant funded money towards expenses, and $5,000 of forfeiture funds. 2044                  40,000                   30,000 t
40                     10,000 ot
41 41 Data Practices Public Records portal software implementation to manage public records requests across the City, including all City departments and entities. Police Records and the City Clerk's Office will be the primary front end users of the system, with the ability for the Clerk's Office to manage requests and forward to departments for responsive data that can be managed and provided within the portal for users. Software includes the ability to collect payments for requests and to redact non public data as needed.                  30,000                   30,000 t
41                                                                              
Total Cost            44,086,230       10,028,227            4,250,735         18,269,108            6,183,602            3,270,779            2,083,779  
Sources of Funds
Olmsted County c                786,042             381,712 c             210,866 c               48,366 c               48,366 c               48,366 c               48,366 c
Electric Utility eu                265,500             153,000 eu               85,500 eu               27,000 eu                         -   eu                         -   eu                         -   eu
Flood Control Reserves fr                305,000             105,000 fr             200,000 fr                         -   fr                         -   fr                         -   fr                         -   fr
General Obligation Bonds go          13,514,420                         -   go             735,000 go       12,779,420 go                         -   go                         -   go                         -   go
Local Government Aid ga                632,990             632,990 ga                         -   ga                         -   ga                         -   ga                         -   ga                         -   ga
Operating Transfer - fr Storm Water Utility os                132,250             113,500 os               17,250 os                  1,500 os                         -   os                         -   os                         -   os
Operating Transfer - fr General Fund ot                997,094             987,094 ot               10,000 ot                         -   ot                         -   ot                         -   ot                         -   ot
Operating Transfer - fr Sewer Utility ow                176,500             139,000 ow               31,500 ow                  6,000 ow                         -   ow                         -   ow                         -   ow
Project reserves r            3,326,255          1,426,255 r                         -   r             300,000 r             700,000 r                         -   r             900,000 r
Tax Levy t          21,618,703          4,385,825 t          2,781,594 t          4,995,547 t          5,359,461 t          3,146,638 t             949,638 t
Operating Transfer - Other Funds to            2,301,976          1,686,851 to             169,525 to             108,275 to               75,775 to               75,775 to             185,775 to
Water Utility wu                  29,500               17,000 wu                  9,500 wu                  3,000 wu                         -   wu                         -   wu                         -   wu
Total Sources of Funds            44,086,230       10,028,227            4,250,735         18,269,108            6,183,602            3,270,779            2,083,779     10,028,227
Total of NEW FUNDING requests         4,250,735       18,269,108         6,183,602         3,270,779         2,083,779
Total adjustments to prior years' funding authorizations                        -                          -                          -                          -                          -  
Total Cost          4,250,735       18,269,108          6,183,602          3,270,779          2,083,779
                   -  
                 -