Sewer and Water                         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 Annual - sanitary sewer main replacement and rehabilitation. - Revenue Bonds to be repaid by Sewer Utility user rates.  Funding from Sewer Utility Retained Earnings. 2133            5,250,000          2,000,000 ow             500,000 ow             500,000 ow             500,000 ow             500,000 ow             500,000 ow ow  250,000  250,000   250,000    250,000    250,000    250,000        500,000           2,000,000
1               500,000 rb rb       250,000      250,000               500,000
1               250,000 re re    250,000               250,000
1                                -  
2 2 Annual - watermain replacement in conjunction with street reconstruction projects.  2144            4,800,000          3,300,000 wu             300,000 wu             300,000 wu             300,000 wu             300,000 wu             300,000 wu wu  400,000  400,000       400,000      400,000    400,000    400,000    300,000    300,000        300,000           3,300,000
2                                -  
3 3 Annual - Infiltration and inflow rehabilitation to Public sanitary sewer system(pipe lining and manhole rehab).  Revenue Bonds to be repaid by Sewer Utility user rates. 2179          13,000,000          3,750,000 ow          1,000,000 ow          1,000,000 ow          1,000,000 ow          1,000,000 ow          1,000,000 ow ow  500,000  1,000,000    750,000    500,000     1,000,000           3,750,000
3            4,250,000 rb rb  2,500,000       750,000      750,000    250,000           4,250,000
3                                -  
4 4 Annual - Sanitary sewer replacement in conjunction with major streets CIP projects. Funding from Sewer Utility Retained Earnings.            1,400,000             400,000 ow             200,000 ow             200,000 ow             200,000 ow             200,000 ow             200,000 ow ow    200,000        200,000               400,000
4                                -  
5 5 Sanitary sewer flow monitor upgrades and repair. Funding from Sewer Utility Retained Earnings.                600,000             350,000 ow               50,000 ow               50,000 ow               50,000 ow               50,000 ow               50,000 ow ow    250,000      50,000          50,000               350,000
5                                -  
6 6 Sanitary sewer and watermain extensions to provide service to properties currently served by private wells and septic systems. Alternative Connection Charge Policy. Funding from Sewer Utility Retained Earnings.                700,000             100,000 a             100,000 re             100,000 re             100,000 re             100,000 re             100,000 re a    100,000               100,000
6               100,000 re re        100,000               100,000
6                                -  
7 7 Trunk Sewer capacity replacement program.  Replace undersized sewer trunk lines, size for ultimate sewer service areas.           20,250,000                 250,000 re          2,000,000 rb          4,000,000 rb          6,000,000 rb          8,000,000 rb                          -  
7                                  -  
8 8 Update City of Rochester Sanitary Sewer Master Plan.  Current plan was last updated in 1996. 4340                500,000             250,000 rb             250,000 rb rb        250,000               250,000
8                                  -  
9 9 Hadley Valley trunk sanitary sewer extension.  Removes Emerald Hills lift station from service.  7816            1,450,000             250,000 p             100,000 ow p        250,000               250,000
9              1,100,000 sa sa     1,100,000           1,100,000
9                                  -  
10 10 Install 2 add't permanent I&I flow metering sites.   2179                250,000                 250,000 re                                      -  
10                                  -  
11 11 Watermain and Sanitary Sewer to Serve Mayowood Farm and Mayowood mansion.  7798            1,300,000             675,000 wa               50,000 wa wa    675,000               675,000
11                 525,000 sa               50,000 sa sa    525,000               525,000
11                                  -  
12 12 Golf Course South Trunkline Upgrade.   Phase I:  9th St So / Broadway to just north of 16th St SW.   Phase 2:  16th St SW to Mayowood Rd / 18th Av SW area.                 4,500,000              2,000,000 rb          2,500,000 rb                          -  
12                                -  
13 13 Sanitary Sewer and Watermain Extension to Sewer Service Area 6 West of 60th Avenue NW (Phase 1).  Revenue Bonds to be repaid by future SAC charges. 7793            3,100,000                 200,000 rb          2,250,000 rb                          -  
13                     650,000 wa                          -  
13                                -  
14 14 KR 6 Trunkline sewer and watermain - 19th Street to Valley High Drive - Serve portions of section 19, 20, 29 and 30 of Cascade Township, Sewer Service Area 6G (Phase 3A in 2016 and Phase 3B in 2019).  Revenue Bonds to be repaid by future SAC charges. 7773            2,000,000                 200,000 rb          1,800,000 rb rb  1,400,000  (1,400,000)                          -  
14                                -  
15 15 Willow Creek Sewer Extension - To Serve SSA 15E, 15-11 and 15-12 in Rochester Township Phase "A", Phase "B".  Design and Build alternating years.  Revenue Bonds to be repaid by future SAC charges. 7757            2,000,000                 200,000 rb          1,800,000 rb rb  400,000      100,000      (500,000)                          -  
15                                -  
16 16 Prairie Crossing Lift Station and force main upgrades and improvements.   7815                450,000             100,000 sa             350,000 sa sa        100,000               100,000
16                                  -  
17 17 Golf Course West Trunkline Upgrade.  Phase I:  Soldiers Field to Apache Mall.  Phase 2:  Apache Mall to Green Meadows.  Revenue Bonds to be repaid by Sewer Utility user rates.            2,500,000              2,500,000 rb                          -  
17                                -  
     
     
                                                       
Total Cost            64,050,000       17,900,000            3,000,000            4,250,000            6,150,000         11,100,000         21,650,000  
Sources of Funds
Special Assessment Bonds a                100,000             100,000 a                         -   a                         -   a                         -   a                         -   a                         -   a
Operating Transfer - fr Sewer Utility ow          15,350,000          6,500,000 ow          1,850,000 ow          1,750,000 ow          1,750,000 ow          1,750,000 ow          1,750,000 ow
Private Funds p                250,000             250,000 p                         -   p                         -   p                         -   p                         -   p                         -   p
General Obligation Revenue Bonds rb          38,700,000          5,000,000 rb             250,000 rb          2,000,000 rb          4,000,000 rb          8,600,000 rb       18,850,000 rb
Retained Earnings re            1,350,000             350,000 re             600,000 re             100,000 re             100,000 re             100,000 re             100,000 re
Sewer Availability Charges sa            2,125,000          1,725,000 sa                         -   sa               50,000 sa                         -   sa             350,000 sa                         -   sa
Water Availability Charges wa            1,375,000             675,000 wa                         -   wa               50,000 wa                         -   wa                         -   wa             650,000 wa
Water Utility wu            4,800,000          3,300,000 wu             300,000 wu             300,000 wu             300,000 wu             300,000 wu             300,000 wu
Total Sources of Funds            64,050,000       17,900,000          3,000,000          4,250,000          6,150,000       11,100,000       21,650,000   17,900,000.00
Total of NEW FUNDING requests         3,000,000         4,250,000         6,150,000       11,100,000       21,650,000
Total adjustments to prior years' funding authorizations                        -                          -                          -                          -                          -  
Total Cost          3,000,000          4,250,000          6,150,000       11,100,000       21,650,000
                (average yearly SAC/SCC revenue from 2003-2012 = $737,791)
*      Revenue bonds repaid with user rates          17,300,000          5,250,000             250,000             550,000          3,100,000          1,400,000          6,750,000
*      Revenue bonds repaid with future SAC charges           12,600,000             750,000                         -               500,000          5,750,000          5,600,000
                   -  
                 -  
      1,000,000                  -        (1,450,000)        (400,000)      (1,450,000)      (6,500,000)
59652 59653
2002 530357.29 65394.49
2003 805525.05 112485.57
2004 1259561.77 198711.71
2005 1112338.23 269118.42
2006 1291916.73 98228.13
2007 283359.57 55951.59
2008 114208.36 154308.06
2009 324605.83 -71062.3
2010 355623.57 41245.9
2011 310527.12 41749.53
2012 477678.2 141833.79