Other Projects                                      2017-2021                   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-2016
Sort Map # Project Description Proj # Total Budget CIP Bdgt Amts 2017 2018 2019 2020 2021 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 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                765,000               50,000  t                75,000 t             100,000 t               75,000 t             315,000 t             100,000 t t       50,000           50,000
1                 50,000  r  r      50,000           50,000
1                          -  
2 2 Land acquisition for future Fire Station #6.  Reserves to be transferred from J8204 (Future Constr-Asmnt Projects). 1012                700,000                 700,000 r                    -  
2                          -  
3 3 Update Video Conferencing equipment, specifically cameras, recording equipment and monitors that are at end their 5 year replacement life.  2017 new equipment for Stations 1 & 4. 1990                570,000             370,000  t              100,000 t             100,000 t t       275,000         45,000       50,000         370,000
3                          -  
4 4 800 MHz portable radio replacement for the Fire Dept., replace 60 radios over 4 yr time table.                330,000                   83,000 t               85,000 t               80,000 t               82,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             400,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               75,000  t                10,000 t               10,000 t               10,000 t               92,090 t               10,000 t t       75,000           75,000
8                 37,910  r  r      37,910           37,910
9 9 Emergency Mgmt Improvements.  Move one siren to a new location on West Circle Drive.  Added voice modulator device in needed areas  in the City.  2049                105,000                   35,000 t               35,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          10,917,000                 417,000 to       10,500,000 go                    -  
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            1,997,246             527,480  ga  196,000 t ga        200,000 327,480         527,480
11               624,719  t  t  345,953      98,000 180766         624,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                200,000     200,000 ot                    -  
12                          -  
13 13 Police Officer Protective Clothing/Equipment (not included as part of the regular issued uniforms) 1893                  91,000                   91,000 t                    -  
13                          -  
14 14 Unmanned Aerial Vehicle (Drone) 1894                  72,400                   72,400 t                    -  
14                          -  
15 15 LEC Computer Aided Dispatch Upgrade - eCitation Project.  Reserves were transferred from J8204 (Future Construction) 2035                130,000               95,000  r                35,000 t r 95000           95,000
15                          -  
16 16 RS 6000 Message Switch (not 911 Eligible) to be located at our Disaster Recovery location as part of the Disaster Recovery and High Availability (DR/HA) project. 1905                  20,800     10,400 t                    -  
16       10,400 c                    -  
16                          -  
17 17 ARMER Base Radio Replacement. 1956                263,665               52,733  t  52,733 t 52,733 t 52,733 t 52,733 t t 52,733           52,733
17                          -  
18 18 800 MHz portable radio replacement for the Police Dept.                515,000     205,000 t 155,000 t 155,000 t                    -  
18                          -  
19 19 800 MHz mobile radio replacement for the Police Dept.                515,000     205,000 t 155,000 t 155,000 t                    -  
19                          -  
20 20 Public Safety Answering Point (PSAP) Project…completion of the dispatch center at Fire Station #2.            2,279,420     2,279,420 go                    -  
20                          -  
21 21 Multi-Purpose Specialty Vehicle for Forensic Mapping Unit (FMU) and Crime Scene Unit (CSU)…project includes equipment within the vehicle.  ($232,061 vehicle request listed in the 2018 Equipment Revolving budget)  Total cost is $450,811                218,750                 218,750 t                    -  
21                          -  
22 22 Concrete Shooting Lanes at pistol range.                  90,000                   90,000 t                    -  
22                          -  
23 23 ICOR Mini Caliber Robot.                  52,700     52,700 t                    -  
23                          -  
24 24 Capital purchase of computer hardware/software for the Public Library. Funds will be transferred from the Library Information Technology Revolving Fund. 2041            1,569,275             170,804  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         170,804
24               941,576  to  75,775 to 76,775 to 77,775 to 78,775 to 79,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         941,576
24                          -  
25 25 Public Library Improvements:  projects include ongoing building improvements e.g. carpet replacement, refinishing/painting and other major projects. 2013:  Second floor public area carpeting and new shelving in the Children's Division.  2014: Roof leak flashing mitigation, shelving, high efficiency hand dryers, etc. 2015: Reglazing of west elevation windows, entrance flashing repair etc.2016: Automated Materials Handling System upgrade, new shelving in Children's Division etc.2017:Server Room security enhancements, backup cooling for Server Room; Library security review, recarpet 1st floor Fiction Area and building repair.  2039            4,576,076             533,511  t  153,027 t 749,567 t 1,522,827 t 622,683 t 311,827 t t       33,829         46,231         83,870             7,555 115,586 90,800 65,011 90,629         533,511
25                 34,610  ga  32,173 c 33,173 c 33,173 c 33,173 c 33,173 c ga          20,946 13,664           34,610
25               165,131  c  c       63,559            8,287         15,975             1,458          14,054 27,015 9,783 25,000         165,131
25               318,028  ot  ot    318,028         318,028
25                          -  
26 26 Public Library Radio Frequency ID:  add RFID tags to the library's collection to improve speed of checkout, reduce error rates, speed the return of materials in the walk  up and drive up book drops, and reduce repetitive strain injuries. 1985                218,067             174,769  t  9,000 t t 60,000 41,918 72,851         174,769
26                 33,298  c  1,000 c c 18,073 8,500 6,725           33,298
26                          -  
27 27 JDE Employee Self Service Module - Phase 2 and 3. 1926                430,500             300,500  t                80,000 t t        103,300      50,000    147,200         300,500
27                 50,000  ga  ga          50,000           50,000
27                          -  
28 28 Implement the Halogen eLearning Management System/Single Sign-On. 1947                130,000               90,000  t                40,000 t t       75,000       15,000           90,000
28                          -  
29 29 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.   Prior reserves were transferred from J2032 (Library IS Integration). 1997                850,000             227,702  t              190,000 t             105,000 t t    227,702         227,702
29                 72,298  r              126,000 eu               27,000 eu r       72,298           72,298
29                     14,000 wu                  3,000 wu                    -  
29                     35,000 to                  7,500 to                    -  
29                     28,000 ow                  6,000 ow                    -  
29                        7,000 os                  1,500 os                    -  
29                          -  
30 30 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 complience and security best practices); Governance, Risk Management & Complience (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                    -  
30                     27,000 eu               31,500 eu                    -  
30                        3,000 wu                  3,500 wu                    -  
30                        7,500 to                  8,750 to                    -  
30                        6,000 ow                  7,000 ow                    -  
30                        1,500 os                  1,750 os                    -  
30                          -  
31 31 Imaging Project.  2010: Consulting/programming services for Bldg Safety's rental certificates backlog ($30,000), 2011-12: Clerk's council agenda archiving ($245,000), and various other departments.  2015: Laserfiche document mgmt system.  2016: HR document management and Finance A/P imaging.  2017: City Clerk document imaging project. 2089                768,000             527,000  t                46,000 [1] t               50,000 t               50,000 t               50,000 t t       20,000       15,000         27,000          30,000    200,000    100,000    135,000         527,000
31                 45,000  ga  ga          45,000           45,000
31                          -  
32 32 City Hall building security upgrades for customer service areas.  Reserves of $33K and $10K to be transferred from J1026 (Remodel Fire Admin office) and J1027 (Remodel City Hall PW office), respectively. 1029                350,000                 180,000 t                    -  
32                   127,000 ot
32                     43,000 r
32      
33 33 City Hall Carpet Replacement:  Employee Offices in the following departments: City Attorney, City Administration, Finance, Mayor Office, Fire Administration, and Conference rooms 320, 304, 306, 319, 321. 1011                110,000                 110,000 t                    -  
33      
34 34 Life/Safety Rehab and Upgrades to Traffic Operations Building (TOB).   Work to be phased over several years, based on building / functional analysis and report conducted in late 2013.   Retained earnings from Parking enterprise funds. 1010                500,000             100,000  t                70,000 t               25,000 t t    100,000         100,000
34               150,000  to                60,000 to               70,000 to               25,000 to to      50,000    100,000         150,000
34      
35 35 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                720,000             300,000  t  t    100,000    100,000    100,000         300,000
35                 90,000  os                15,000 os os      37,500      37,500       15,000           90,000
35                 90,000  ow                15,000 ow ow      37,500      37,500       15,000           90,000
35                 90,000  fr                15,000 fr fr      37,500      37,500       15,000           90,000
35                 90,000  r                15,000 t r      37,500      37,500       15,000           90,000
35                          -  
36 36 Public Works Engineering Division Imaging Project and Back File Scanning of Permit files and Record drawings.  Digitization of all paper records stored in the utility permit files so that they can be loaded into the City’s Laserfishe document management system.  Digitization of all construction record drawings so they can be stored / retrieved electronically.  1896                225,000                   75,000 ow                    -  
36                     75,000 wa                    -  
36                     75,000 os                    -  
36                          -  
37 37 Re-roof Traffic Operations Building (TOB) 1010                  16,000                   16,000 t                    -  
37                          -  
38 38 Convert Street Lights to LED (2000 lights per year).            4,000,000              1,000,000 t          1,000,000 t          1,000,000 t          1,000,000 t                    -  
38                          -  
39 39 Construct "City Entrance / Welcome Sign" on TH52 North (north of 75th St NW).                  200,000                 200,000 t                    -  
39                          -  
40 40 Purchase property north of PWTOC to replace old North Public Works Maintenance Material Storage area.   Old Maintenance Storage area to be used for future WRP expansion.  Retained Earnings to be transferred from the Sewer Fund.            1,000,000                 500,000 t                    -  
40                   500,000 re                    -  
40                          -  
41 41 Rochester Zoning Ordinance Update and Land Development Manual (LDM) as it relates to the new Comprehensive Plan for the City. 1897                600,000                 600,000 st                    -  
41                          -  
42 42 Rochester Civic Theatre Improvements.  2013: Replace air conditioning compressor and purchase of an assisted hearing system.  2014: IT infrastructure updates.  2015: House & basement lighting updates.  2017: $15,000 Exterior and interior suface repairs and painting, $15,000 Audio Visual Equipment,  $15,000 Completion of interior remodeling. 2079                579,665             298,599  t                40,000 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         298,599
42                 30,000  ga  ga          30,000           30,000
42               111,066  ot  ot   111,066         111,066
42                          -  
43 43 Rochester Art Center Improvements.  2012: Portable Locking Gate, Security cameras, and upgrade sound system. 2013: Computer hardware, floor cleaning machine, vertical lift, window shades, benches and chairs.  2014: Benches, chairs, website improvements, carpet, tables, and window shades.  2015: GOBO light, elevator floor, steamvac and vacuum.  2016: security cameras, HVAC, way-finding, credit card upgrades.  2016: Rebrand, Building a Creative City, Security Systems, Wireless Connection, New Stage, Computer Upgrades, and Painitng Atrium Space. 2070                630,434             451,534  t                38,000 t               25,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         451,534
43                 40,900  ga  ga          40,900           40,900
                                                                             
Total Cost            39,785,998          8,108,215            4,416,779            5,839,722         14,235,112            4,718,058            2,468,112  
Sources of Funds
Olmsted County c                613,518             369,233 c               57,177 c               46,777 c               46,777 c               46,777 c               46,777 c
Electric Utility eu                211,500                         -   eu             153,000 eu               58,500 eu                         -   eu                         -   eu                         -   eu
Flood Control Reserves fr                105,000               90,000 fr               15,000 fr                         -   fr                         -   fr                         -   fr                         -   fr
General Obligation Bonds go          12,779,420                         -   go                         -   go          2,279,420 go       10,500,000 go                         -   go                         -   go
Local Government Aid ga                727,990             727,990 ga                         -   ga                         -   ga                         -   ga                         -   ga                         -   ga
Operating Transfer - fr Storm Water Utility os                191,750               90,000 os               98,500 os                  3,250 os                         -   os                         -   os                         -   os
Operating Transfer - fr General Fund ot                987,094             660,094 ot             327,000 ot                         -   ot                         -   ot                         -   ot                         -   ot
Operating Transfer - fr Sewer Utility ow                227,000               90,000 ow             124,000 ow               13,000 ow                         -   ow                         -   ow                         -   ow
Project reserves r            1,506,255             763,255 r             743,000 r                         -   r                         -   r                         -   r                         -   r
Retained Earnings re                500,000                         -   re                         -   re                         -   re                         -   re             500,000 re                         -   re
Sales Tax 2013 st                600,000                         -   st             600,000 st                         -   st                         -   st                         -   st                         -   st
Tax Levy t          19,126,770          4,226,067 t          1,611,827 t          3,269,250 t          3,585,560 t          4,092,506 t          2,341,560 t
Operating Transfer - Other Funds to            2,111,201          1,091,576 to             595,275 to             163,025 to             102,775 to               78,775 to               79,775 to
Water Availability Charges wa                  75,000                         -   wa               75,000 wa                         -   wa                         -   wa                         -   wa                         -   wa
Water Utility wu                  23,500                         -   wu               17,000 wu                  6,500 wu                         -   wu                         -   wu                         -   wu
Total Sources of Funds            39,785,998          8,108,215            4,416,779            5,839,722         14,235,112            4,718,058            2,468,112       8,108,215
Total of NEW FUNDING requests         4,416,779         5,839,722       14,235,112         4,718,058         2,468,112
Total adjustments to prior years' funding authorizations                        -                          -                          -                          -                          -  
Total Cost          4,416,779          5,839,722       14,235,112          4,718,058          2,468,112
                   -  
                 -  

[1]
Houdek, Rachel:
add another 46k for aaron project