Other Projects                                      2016-2020                   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       Operating Trfs-fr Gen Fnd Sales Tax = ox 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 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-2015
Sort Map # Project Description Proj # Total Budget CIP Bdgt Amts 2016 2017 2018 2019 2020 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 Totals
0                          -  
1 1 Update Video Conferencing equipment, specifically cameras, recording equipment and monitors that are at end of life for replacement.  1990                420,000             320,000  t                50,000 t               50,000 t t       275,000         45,000         320,000
1                          -  
2 2 Fire Records software package. CAD Enterprise enhancement with RPD. 1972                125,000               60,000  t                65,000 t t      60,000           60,000
2                          -  
3 3 Remodel Fire Admin front office area.  Reserves to be transferred from J2008 (City Hall Bldg Improvements). 1026                  33,000                   33,000 r                    -  
3                          -  
4 4 Fire Station Infrastructure Improvements at various stations.  Prior year reserves transferred from J1918 (Misc Fire Equipment-non vehicles). 1024                640,000               50,000  r                50,000 t               50,000 t             100,000 t               75,000 t             315,000 t r      50,000           50,000
4                          -  
5 5 800 MHz portable radio replacement for the Fire Dept., replace 60 radios over 4 yr time table. 1956                330,000                   82,000 t               83,000 t               85,000 t               80,000 t                    -  
5                          -  
6 6 Land acquisition for future Fire Station #6. 1012                950,000                 200,000 t             200,000 t             350,000 t             200,000 t                    -  
6                          -  
7 7 VHF Back-Up radio/paging system.  1960                  60,000                   20,000 t               20,000 t               20,000 t                    -  
7                          -  
8 8 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
8                          -  
9 9 Modular Live Fire Attack props and Training Containers to be used at the regional training facility phased in over a 5 year period.  1978            1,200,000              1,200,000 t                    -  
9                          -  
10 10 Emergency Operations Center (EOC) Technology.  Prior year reserves transferred from J1920 (CPAT Fitness & Testing Equip).  Phase 2 of technology installation in EOC. 1924                235,000               37,910  r                75,000 t               10,000 t               10,000 t               10,000 t               92,090 t r      37,910           37,910
10                          -  
11 11 Emergency Mgmt Improvements.  Move one siren to a new location on West Circle Drive. 2049                  10,000                   10,000 t t                    -  
11                          -  
12 12 LEC Remodeling and enhancements - including additional work stations. 1969                795,750             217,625  t  40,000 t 100,000 t 120,000 t 140,000 t 160,000 t t       71,000       28,125     100,500 18,000         217,625
12                 18,125  c  c       18,125           18,125
12                          -  
13 13 ARMER Base Radio Replacement 1956                263,665     52,733 t 52,733 t 52,733 t 52,733 t 52,733 t                    -  
13                          -  
14 14 LEC Expanded identity management and video management capabilities through Intelligence Management programs.  Prior year reserves were transferred from J1917 (Automated License Plate Reader).  Reserves to be transferred from J1915 ($34K) and J1944 ($118K). 1916            1,801,246             527,480  ga  180,766 t ga        200,000 327,480         527,480
14               443,953  t  t  345,953      98,000         443,953
14               418,047  r  r  131,047 135000    152,000         418,047
14               231,000  ot  ot 231000         231,000
14                          -  
15 15 Automatic External Defibrillator (AED) replacement.   Reserves to be transferred from J8204 (Future Construction-Asmnt Projs). 1988                119,300               46,540  r  72,760 t r      46,540           46,540
15                          -  
16 16 ARMER Simulcast Channel Expansion 1989                  54,830     54,830 t                    -  
16                          -  
17 17 Lec Software and Infrastructure 1999                  25,000     25,000 t                    -  
17                          -  
18 18 ICOR Mini Caliber Robot.                  45,000     45,000 t                    -  
18                          -  
19 19 800 MHz portable radio replacement for the Police Dept.                722,750     222,750 t 225,000 t 137,500 t 137,500 t                    -  
19                          -  
20 20 800 MHz mobile radio replacement for the Police Dept.                515,000     205,000 t 155,000 t 155,000 t                    -  
20                          -  
21 21 Capital purchase of computer hardware/software for the Public Library. Funds will be transferred from the Library Information Technology Revolving Fund. 2041            1,479,896             157,200  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         157,200
21               865,801  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         865,801
21                          -  
22 22 Public Library Improvements:  projects include ongoing building improvements e.g. carpet replacement, refinishing/painting and other major projects.  2007:  Automated materials handling and sorting system, 2011: Sound system upgrade (to address malfunctioning paging and sound system), 2012:  Security camera system upgrade (to address security issues better), cooling tower replacement (pipes are rusting out and could leak or the rust can deposit into the tubes within the chiller), 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 east elevation windows, entrance flashing repair etc.2016: Recarpet 1st Floor Fiction Area, Automated Materials Handling System upgrade, new shelving in Children's Division etc. 2039            1,710,016             442,882  t  90,629 t 172,000 t 185,000 t 100,000 t 100,000 t t       33,829         46,231         83,870             7,555 115,586 90,800 65,011         442,882
22                 34,610  ga  25,000 c 30,562 c 31,174 c 20,000 c 20,000 c ga          20,946 13,664           34,610
22               140,131  c  c       63,559            8,287         15,975             1,458          14,054 27,015 9,783         140,131
22               318,028  ot  ot    318,028         318,028
22                          -  
23 23 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                208,067             101,918  t  72,851 t t 60,000 41,918         101,918
23                 26,573  c  6,725 c c 18,073 8,500           26,573
23                          -  
24 24 JDE Employee Self Service Module - Phase 2 and 3. 1926                430,500             153,300  t              147,200 t               80,000 t t        103,300      50,000         153,300
24                 50,000  ga  ga          50,000           50,000
24                          -  
25 25 Implement the Halogen eLearning Management System/Single Sign-On. 1947                105,000               75,000  t                15,000 t               15,000 t t       75,000           75,000
25                          -  
26 26 Purchase of Open Gov Software. 1899                  18,000                   18,000 t                    -  
26                          -  
27 27 City Wide IT Integration.  Reserves to be transferred from J2032 (Library IS Integration). 1997                300,000                 227,702 t                    -  
27                     72,298 r                    -  
27                          -  
28 28 Building Safety Department Imaging Project and Back File Scanning of Address files.  Digitization of all paper records stored in the address files so that they can be loaded into the City’s Laserfishe document management system. 1898                300,000                 300,000 t                    -  
28                          -  
29 29 Administrative Fines Software to include billing and assessment process.                  60,000                   60,000 t                    -  
29                          -  
30 30 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. 2089                772,000             527,000  t                50,000 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
30                 45,000  ga  ga          45,000           45,000
30                          -  
31 31 City Hall Roof Replacement - to be replaced in 2018.  Prior year reserves were transferred from J2702 (Future Improvements).  Reserves to be transferred from J2600 (ED Loans). 2008            1,745,776             100,000  t           1,150,000 r t    100,000         100,000
31               495,776  r  r    375,000    120,776         495,776
31                          -  
32 32 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                350,000             100,000  t                50,000 t t    100,000         100,000
32                 50,000  to              100,000 to               50,000 to to      50,000           50,000
32      
33 33 Upgrade Public Works City Hall administrative / customer service area.  Reserves to be transferred from J2008 (City Hall Bldg Improvements).   1027                  10,000                   10,000 r                    -  
33                          -  
34 34 Purchase and install a Diesel Exhaust Fluid (DEF) bulk fueling station at PWTOC fuel island.   1028                  40,000                   40,000 t                    -  
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.  Reserves to be transferred from J2200 (Street Rehab). 1912                660,000             300,000  t  t    100,000    100,000    100,000         300,000
35                 75,000  os                15,000 os os      37,500      37,500           75,000
35                 75,000  ow                15,000 ow ow      37,500      37,500           75,000
35                 75,000  fr                15,000 fr fr      37,500      37,500           75,000
35                 75,000  r                15,000 r r      37,500      37,500           75,000
35                          -  
36 36 PWTOC Sign shop improvements;  shelving, sign equipment and software upgrades                  30,000                   30,000 t                    -  
36                          -  
37 37 Construct "City Entrance / Welcome Sign" on TH52 North (north of 75th St NW).                  200,000                 200,000 t                    -  
37                          -  
38 38 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                    -  
38                   500,000 re                    -  
38                          -  
39 39 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. 2079                539,665             298,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         298,599
39                 30,000  ga  ga          30,000           30,000
39               111,066  ot  ot   111,066         111,066
39                          -  
40 40 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. 2070                592,434             420,154  t                31,380 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         420,154
40                 40,900  ga  ga          40,900           40,900
40                          -  
     
                                                                           
Total Cost            19,446,895          7,604,618            3,155,253            1,520,424            1,473,286            1,567,612            4,125,702  
Sources of Funds
Olmsted County c                543,510             342,029 c               45,329 c               44,166 c               44,778 c               33,604 c               33,604 c
Flood Control Reserves fr                  90,000               75,000 fr               15,000 fr                         -   fr                         -   fr                         -   fr                         -   fr
Local Government Aid ga                727,990             727,990 ga                         -   ga                         -   ga                         -   ga                         -   ga                         -   ga
Operating Transfer - fr Storm Water Utility os                  90,000               75,000 os               15,000 os                         -   os                         -   os                         -   os                         -   os
Operating Transfer - fr General Fund ot                660,094             660,094 ot                         -   ot                         -   ot                         -   ot                         -   ot                         -   ot
Operating Transfer - fr Sewer Utility ow                  90,000               75,000 ow               15,000 ow                         -   ow                         -   ow                         -   ow                         -   ow
Project reserves r            2,403,571          1,123,273 r          1,280,298 r                         -   r                         -   r                         -   r                         -   r
Retained Earnings re                500,000                         -   re                         -   re                         -   re                         -   re                         -   re             500,000 re
Tax Levy t          12,887,054          3,610,431 t          1,608,851 t          1,349,483 t          1,350,733 t          1,455,233 t          3,512,323 t
Operating Transfer - Other Funds to            1,454,676             915,801 to             175,775 to             126,775 to               77,775 to               78,775 to               79,775 to
Total Sources of Funds            19,446,895          7,604,618            3,155,253            1,520,424            1,473,286            1,567,612            4,125,702       7,604,618
Total of NEW FUNDING requests         3,155,253         1,520,424         1,473,286         1,567,612         4,125,702
Total adjustments to prior years' funding authorizations                        -                          -                          -                          -                          -  
Total Cost          3,155,253          1,520,424          1,473,286          1,567,612          4,125,702
                   -  
                 -