Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
7.a. Water and Sewer Utility Rate Review
4 ROSEMOUNT' EXECUTIVE SUMMARY UTILITY COMMISSION Utility Commission Meeting: July 20, 2015 AGENDA ITEM: Water and Sewer Utility Rate Review AGENDA SECTION: New Business PREPARED BY: Christine Watson, Public Works Coordinator AGENDA NO. -7. C'. ATTACHMENTS: Water Rate Analysis spreadsheet; Sanitary Sewer Rate Analysis spreadsheet; 2016 APPROVED BY: Budget Worksheets RECOMMENDED ACTION: Motion to Recommend City Council Approval of Water and Sewer Utility Rate Changes for 2016. BACKGROUND WATER UTILITY RATES For the past 51/2 years, the City has operated with a tiered water rate structure in order to comply with DNR requirements to encourage water conservation. Staff has completed its annual review of the water utility fund activity and adjusted the model to reflect the proposed changes for 2016 and beyond. Based on this review, staff is proposing a 4% increase over the rates in 2015,which is less than the increases over the past four years. The tables below summarize the rate changes over the past four years. Residential Tier 2012 Rate 2013 Rate 2014 Rate 2015 Rate 2016 Rate (5%) (5%) (5%) (5%) (4%) 0- 10,000 $0.95 $1.00 $1.05 $1.10 $1.14 10,001 -30,000 $1.16 $1.22 $1.28 $1.35 $1.40 30,001 -60,000 $1.47 $1.54 $1.62 $1.70 $1.77 > 60,000 $2.00 $2.10 $2.21 $2.32 $2.41 Irrigation Only* $2.00 $2.15 $2.32 $2.44 $2.54 *includes all irrigation meters (multi-fam/comm/ind/inst) Commercial/Industrial/Institutional Tier 2012 Rate 2013 Rate 2014 Rate 2015 Rate 2016 Rate (5%) (5%) (5%) (5%) (4%) 0-100,000 $1.10 $1.16 $1.22 $1.28 $1.33 100,001 -200,000 $1.37 $1.44 $1.51 $1.59 $1.65 200,001 -300,000 $1.68 $1.76 $1.85 $1.94 $2.02 > 300,000 $2.10 $2.21 $2.32 $2.44 $2.54 G:\Utilities\Rates\20150720 UC Water and Sewer Rates.docx The water rate model includes the following items of note: • LINE 2: Annual residential growth is estimated to be 2.5%annually beginning in 2016. These figures are slightly lower than the growth estimates used in previous models (3.5%per year starting in 2017). • LINES 7-16: Fixed rate and usage charges are proposed to increase 4%per year. • LINES 25-33: In calculating the estimated usage revenue, the following assumptions were made regarding the number of accounts in each tier and the average usage on those accounts (these assumptions are based on actual usage data from 2014): Residential Commercial/Industrial Tier %in tier Avg.usage Tier %in tier Avg.usage 0— 10,000 30% 6,800 0—100,000 70% 27,500 10,001 —30,000 50% 17,300 100,001 —200,000 15% 141,000 30,001 —60,000 15% 42,200 200,001 —300,000 7% 240,000 > 60,000 5% 96,500 > 300,000 8% 1,175,000 FUTURE GROUND WATER STORAGE TANK AND WATER TREATMENT FACILITY The water rate model includes funding for the construction of a ground water storage tank to be located on the City property between Fire Station 2 and the Bacardi Tower/Well 14. The storage tank is slated for construction in 2016,with debt service to begin in 2017. The primary purpose for this storage tank is to mix (dilute)water from future Well 16 to address the issue of increased levels of radium identified in samples from the test well. Funding for the storage tank is proposed to be split equally between the Water Utility Fund (Line 53) and the Water Core Fund (Line 68). The model also includes funding for the construction of a water treatment facility. Past models have had this scheduled in 2016; however, due to the construction of the new ground storage facility, the treatment facility has been moved back to 2019 in this model. It is expected that the water treatment facility will utilire the storage capacity of the new ground storage tank. G:\Utilities\Rates\20150720 UC Water and Sewer Rates.docx SEWER UTILITY RATES As illustrated in the sanitary sewer spreadsheet model, the usage rate is proposed to increase 3%per year, and the fixed rate is proposed to increase $0.50 per year. The table below summarizes the rate changes over the past four years. Sewer Rates 2012 Rate 2013 Rate 2014 Rate 2015 Rate 2016 Rate (5%) (5%) (2%) (2%) (3%) Fixed Rate $21.00 $22.00 $22.50 $23.00 $23.50 Usage Rate $1.58 $1.66 $1.69 $1.73 $1.78 The sewer rate model includes the following items of note: • LINE 31: This line currently shows a 4% annual increase for Met Council sewer service charges, down from 7%used in previous models and 5% used last year. The per-thousand-gallon charges have fluctuated over the past several years,but 4% per year appears to be a reasonable estimate based on historical data. • LINE 31: Staff is still researching and developing a lift station maintenance program. Once a program has been developed, the amount in this line may increase beginning in 2017. SUMMARY Staff is requesting Utility Commission recommendation to the City Council to approve the proposed utility rate changes for 2016. G:\Utilities\Rates\20150720 UC Water and Sewer Rates.docx Water Rate Analysis Description 2014 Projected 2014 Actual 2015 Projected 2016 Budgeted 2017 2018 2019 2020 2021 2022 2023 2024 2025 1 Water Demand(MG) 902.56 815.26 870.00 892.29 914.58 937.48 960.98 985.08 1,009.78 1,035.08 1,060.99 1,087.50 1,114.61 1 2 Estimated Growth 2.5% 1.4% 2.0% 2.6% 2.5% 2.5% 2.5% 2.5% 2.5% 2.5% 2.5% 2.5% 2.5% 2 3 Projected Residential Accounts(excluding association irrigation) 6,860 6,784 6,920 7,095 7,270 7,450 7,635 7,825 8,020 8,220 8,425 8,635 8,850 3 Demands and 4 Connections Commercial Accounts(excluding irrigation) 130 132 135 140 145 150 155 160 165 170 175 180 185 4 5 Institutional/Industrial Accounts(excluding irrigation) 50 49 50 50 50 50 50 50 50 50 50 50 50 5 6 Irrigation-only Accounts(excluding single family) 115 113 115 120 125 130 135 140 145 150 155 160 165 6 7 Water Fixed Charge($/account/quarter) $ 11.58 $ 11.58 $ 12.16 $ 12.65 $ 13 15 $ 13.68 $ 14.23 $ 14.79 $ 15.39 $ 16.00 $ 16.64 $ 17.31 $ 18.00 7 8 Residential Tier 1(0-10,000 gal) $ 1.05 $ 1.05 $ 1.10 $ 1.14 $ 1.19 $ 1.24 $ 1.29 $ 1.34 $ 1.39 $ 1.45 $ 1.51 $ 1.57 $ 1.63 8 9 Residential Tier 2(10,001-30,000 gal) $ 1.28 $ 1.28 $ 1.35 $ 1.40 $ 1.46 $ 1.52 $ 1.58 $ 1.64 $ 1.71 $ 1.78 $ 1.85 $ 1.92 $ 2.00 9 10 Residential Tier 3(30,001-60,000 gal) $ 1.62 $ 1.62 $ 1.70 $ 1.77 $ 1.84 $ 1.91 $ 1 99 $ 2.07 $ 2.15 $ 2.24 $ 2.33 $ 2.42 $ 2.52 10 11 Residential Tier 4(>60,000 gal) $ 2.21 $ 2.21 $ 2.32 $ 2.41 $ 2.51 $ 2.61 $ 2.71 $ 2.82 $ 2.94 $ 3.05 $ 3.18 $ 3 30 $ 3 43 11 12 Irrigation Meters(Multi Fam/Comm/Ind/Inst) $ 2.32 $ 2.32 $ 2.44 $ 2.54 $ 2.64 $ 2.74 $ 2.85 $ 2.97 $ 3.09 $ 3.21 $ 3 34 $ 3.47 $ 3.61 12 13 Comm/Ind/Inst Tier 1(0-100,000 gal) $ 1.22 $ 1.22 $ 1.28 $ 1.33 $ 1.38 $ 1.44 $ 1.50 $ 1.56 $ 1.62 $ 1.68 $ 1.75 $ 1.82 $ 1.89 13 14 Proposed Rates Comm/Ind/Inst Tier 2(100,001-200,000 gal) $ 1.51 $ 1.51 $ 1.59 $ 1.65 $ 1.72 $ 1.79 $ 1.86 $ 1.93 $ 2.01 $ 2.09 $ 2.18 $ 2.26 $ 2.35 14 15 and Tiers Comm/Ind/Inst Tier 3(200,001 -300,000 gal) $ 1.85 $ 1.85 $ 1.94 $ 2.02 $ 2.10 $ 2.18 $ 2.27 $ 2 36 $ 2.45 $ 2.55 $ 2.66 $ 2.76 $ 2.87 15 16 Comm/Ind/Inst Tier 4(>300,000 gal) $ 2.32 $ 2.32 $ 2.44 $ 2.54 $ 2.64 $ 2.74 $ 2.85 $ 2.97 $ 3.09 $ 3.21 $ 3.34 $ 3.47 $ 3.61 16 17 Surcharge-Single Family 5/8"($/account) $ 8.80 $ 8.80 $ 8.80 $ 8.80 $ 8.80 $ 8.80 $ 8.80 $ 8.80 $ 8.80 5 8.80 $ 8.80 $ 8.80 $ 8.80 17 18 Surcharge-Multi Family 5/8"($/account) $ 6.80 $ 6.80 $ 6.80 $ 6.80 $ 6.80 $ 6.80 $ 6.80 $ 6.80 $ 6.80 $ 6.80 $ 6.80 $ 6.80 $ 6.80 18 19 Surcharge-1"($/account) $ 13.50 $ 13.50 $ 13.50 $ 13.50 $ 13.50 $ 13.50 $ 13.50 $ 13.50 $ 13.50 $ 13.50 $ 13.50 $ 13.50 $ 13.50 19 20 Surcharge-1.5"($/account) $ 28.00 $ 28.00 $ 28.00 $ 28.00 $ 28.00 $ 28.00 $ 28.00 $ 28.00 $ 28.00 $ 28.00 $ 28.00 $ 28.00 $ 28.00 20 21 Meter Maintenance-1"($/account/quarter) $ 6.25 $ 6.25 $ 6.25 $ 6.25 $ 6.25 $ 6.25 $ 6.25 $ 6.25 $ 6.25 $ 6.25 $ 6.25 $ 6.25 $ 6.25 21 22 Meter Maintenance-1.5"($/account/quarter) $ 11.25 $ 11.25 $ 11.25 $ 11.25 $ 11.25 $ 11.25 $ 11.25 $ 11.25 $ 11.25 $ 11.25 $ 11.25 $ 11.25 $ 11.25 22 23 601 49400 Water Utility Fund Beginning Balance $ 5,040,408.25 $ 5,608,503.89 $ 5,858,124.58 $ 6,310,889.12 $ 6,475,604.48 $ 7,029,924.70 $ 6,188,520.14 $ 5,505,001.26 $ 4,949,943.50 $ 4,739,213.76 $ 4,602,598.09 $ 4,627,731.05 23 24 Calculated Fixed Charges $ 331,462.53 $ 351,180.80 $ 374,586.37 $ 399,302.49 $ 425,670.13 $ 453,792.81 $ 483,780.13 $ 515,748.08 $ 549,819.46 $ 586,124.18 $ 624,799.73 $ 665,991.51 24 25 Residential Tier 1(0-10,000 gal) $ 53,676.76 $ 62,113.92 $ 66,232.11 $ 70,580.37 $ 75,221.01 $ 80,172.47 $ 85,454.29 $ 91,087.18 $ 97,093.03 $ 103,495.02 $ 110,317.71 $ 117,587.05 25 26 Residential Tier 2(10,001-30,000 gal) $ 292,393.40 $ 288,633.20 $ 307,769.75 $ 327,975.41 $ 349,539.68 $ 372,548.30 $ 397,092.09 $ 423,267.18 $ 451,175.37 $ 480,924.40 $ 512,628.31 $ 546,407.75 26 27 Residential Tier 3(30,001-60,000 gal) $ 198,065.21 $ 243,888.48 $ 260,058.43 $ 277,131.75 $ 295,353.07 $ 314,794.83 $ 335,533.77 $ 357,651.13 $ 381,232.91 $ 406,370.17 $ 433,159.25 $ 461,702.11 27 28 Residential Tier4(>60,000 gal) $ 361,486.88 $ 240,373.12 $ 256,310.00 $ 273,137.23 $ 291,095.91 $ 310,257.44 $ 330,697.45 $ 352,496.01 $ 375,737.90 $ 400,512.83 $ 426,915.77 $ 455,047.22 28 29 Irrigation Meters(Multi-Fam/Comm/Ind/Inst) $ 255,200.00 $ 244,000.00 $ 291,824.00 $ 303,496.96 $ 315,636.84 $ 328,262.31 $ 341,392.80 $ 355,048.52 $ 369,250.46 $ 384,020.48 $ 399,381.29 $ 415,356.55 29 30 Revenue Comm/Ind/Inst Tier 1 (0-100,000 gal) $ 17,293.65 $ 18,233.60 $ 18,919.01 $ 20,193.56 $ 21,539.80 $ 22,961.42 $ 24,462.32 $ 26,046.54 $ 27,718.37 $ 29,482.26 $ 31,342.92 $ 33,305.26 30 31 Comm/Ind/Inst Tier 2(100,001-200,000 gal) $ 20,998.66 $ 21,444.09 $ 24,431.58 $ 26,077.50 $ 27,816.00 $ 29,651.85 $ 31,590.07 $ 33,635.90 $ 35,794.86 $ 38,072.72 $ 40,475.53 $ 43,009.65 31 32 Comm/Ind/Inst Tier 3(200,001-300,000 gal) $ 20,514.82 $ 18,886.28 $ 23,054.39 $ 24,607.52 $ 26,248.03 $ 27,980.40 $ 29,809.36 $ 31,739.87 $ 33,777.13 $ 35,926.58 $ 38,193.95 $ 40,585.22 32 33 Comm/Ind/Inst Tier 4(>300,000 gal) $ 146,664.00 $ 154,867.20 $ 165,414.91 $ 176,558.65 $ 188,329.23 $ 200,758.96 $ 213,881.74 $ 227,733.13 $ 242,350.42 $ 257,772.72 $ 274,041.04 $ 291,198.39 33 34 Calc.Meter Maintenance-1"(inc.3%/year) $ 18,900.00 $ 19,350.00 $ 19,930.50 $ 20,528.42 $ 21,144.27 $ 21,778.60 $ 22,431.95 $ 23,104.91 $ 23,798.06 $ 24,512.00 $ 25,247.36 $ 26,004.78 34 35 Calc.Meter Maintenance-1.5"(inc.3%/year) $ 9,315.00 $ 9,450.00 $ 9,733.50 $ 10,025.51 $ 10,326.27 $ 10,636.06 $ 10,955.14 $ 11,283.79 $ 11,622.31 $ 11,970.98 $ 12,330.11 $ 12,700.01 35 36 Misc Water Revenues(antenna,interest,new meter sales) $ 240,500.00 $ 245,500.00 $ 245,500.00 $ 263,500.00 $ 265,300.00 $ 267,100.00 $ 268,900.00 $ 270,700.00 $ 272,500.00 $ 274,300.00 $ 276,100.00 $ 277,900.00 36 37 Total Usage Revenue(excluding surcharge) $ 1,966,470.89 $ 1,883,897.00 $ 1,917,920.69 $ 2,063,764.54 $ 2,193,115.36 $ 2,313,220.21 $ 2,440,695.45 $ 2,575,981.11 $ 2,719,542.25 $ 2,871,870.26 $ 3,033,484.33 $ 3,204,932.96 $ 3,386,795.50 37 38 100's-Salaries and Benefits(4%)(add 2 pos.in 2019) $ 443,300.00 $ 452,813.00 $ 449,100.00 $ 495,800.00 $ 515,700.00 $ 536,400.00 $ 737,900.00 $ 767,500.00 $ 798,200.00 $ 830,200.00 $ 863,500.00 $ 898,100.00 $ 934,100.00 38 39 200's-Office Materials and Supplies $ 24,600.00 $ 28,499.00 $ 24,600.00 $ 34,700.00 $ 35,800.00 $ 36,900.00 $ 38,100.00 $ 39,300.00 $ 40,500.00 $ 41,800.00 $ 43,100.00 $ 44,400.00 $ 45,800.00 39 40 216.00-Chemicals(tied to pop growth) $ 70,000.00 $ 51,562.00 $ 70,000.00 $ 70,000.00 $ 71,700.00 $ 73,500.00 $ 75,300.00 $ 77,200.00 $ 79,100.00 $ 81,100.00 $ 83,100.00 $ 85,200.00 $ 87,300.00 40 41 220.01-Water Meter Purchases(replacements) $ 40,000.00 $ 13,930.00 $ 50,000.00 $ 60,000.00 $ 61,800.00 $ 63,700.00 $ 65,700.00 $ 67,700.00 $ 69,800.00 $ 71,900.00 $ 74,100.00 $ 76,400.00 $ 78,700.00 41 42 220.02-Water Meter Purchases(new homes) $ 40,000.00 $ 68,837.00 $ 45,000.00 $ 45,000.00 $ 63,000.00 $ 64,800.00 $ 66,600.00 $ 68,400.00 $ 70,200.00 $ 72,000.00 $ 73,800.00 $ 75,600.00 $ 77,400.00 42 43 300's-GIS,Legal,Office,Computer,Eng,Prof Svcs $ 154,700.00 $ 204,889.00 $ 181,700.00 $ 165,900.00 $ 170,900.00 $ 176,100.00 $ 181,400.00 $ 186,900.00 $ 192,600.00 $ 198,400.00 $ 204,400.00 $ 210,600.00 $ 217,000.00 43 44 400's-Training,Conferences,Contracted Repair $ 56,200.00 $ 38,630.00 $ 79,200.00 $ 79,900.00 $ 82,300.00 $ 84,800.00 $ 87,400.00 $ 90,100.00 $ 92,900.00 5 95,700.00 $ 98,600.00 $ 101,600.00 $ 104,700.00 44 45 500's-Buildings,Inspections,Purchases,Furniture $ 16,600.00 $ 560.00 $ 16,600.00 $ 16,100.00 $ 16,600.00 $ 17,100.00 $ 17,700.00 $ 18,300.00 $ 18,900.00 $ 19,500.00 $ 20,100.00 $ 20,800.00 $ 21,500.00 45 46 Expenses 530.03-CRP of Water Main $ 150,000.00 $ - $ 150,000.00 $ 150,000.00 $ 150,000.00 $ 150,000.00 $ 150,000.00 $ 150,000.00 $ 150,000.00 $ 150,000.00 $ 150,000.00 $ 150,000.00 $ 150,000.00 46 47 530.04-Well and Tower Maintenance(long-term schedule) $ 37,000.00 $ - $ 320,000.00 $ 190,000.00 $ 355,000.00 $ 55,000.00 $ 546,000.00 $ 541,000.00 $ 500,000.00 $ 250,000.00 $ 250,000.00 $ 225,000.00 $ 225,000.00 47 48 710.00-Transfers for Other Improvements $ - $ 4,796.00 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 48 49 Utility Equipment Purchases(from CIP) $ - $ - $ - $ 27,500.00 $ 13,500.00 $ - $ 72,000.00 $ - $ - $ - $ 27,500.00 $ - $ - 49 50 Well and Tower Expenses(combined) $ 264,200.00 $ 282,468.00 $ 282,100.00 $ 276,100.00 $ 284,400.00 $ 292,900.00 $ 301,700.00 $ 310,800.00 $ 320,100.00 $ 329,700.00 $ 339,600.00 $ 349,800.00 $ 360,300.00 50 51 WTP Operating Expenses $ - $ - $ - $ - $ - $ - $ 50,000.00 $ 50,000.00 $ 50,000.00 $ 50,000.00 $ 50,000.00 $ 50,000.00 $ 50,000.00 51 52 WTP Debt Service$10,000,000 15 years @ 4.0% $ - $ - $ - $ - $ - $ - $ 684,600.00 $ 684,600.00 $ 684,600.00 $ 684,600.00 $ 684,600.00 $ 684,600.00 $ 684,600.00 52 53 1/2 of Ground Storage Debt Service $ - $ - $ - $ - $ 207,700.00 $ 207,700.00 $ 207,700.00 $ 207,700.00 $ 207,700.00 $ 207,700.00 $ 207,700.00 $ 207,700.00 $ 207,700.00 53 54 Total Expenses $ 1,296,600.00 $ 1,146,984.00 $ 1,668,300.00 $ 1,611,000.00 $ 2,028,400.00 $ 1,758,900.00 $ 3,282,100.00 $ 3,259,500.00 $ 3,274,600.00 $ 3,082,600.00 $ 3,170,100.00 $ 3,179,800.00 $ 3,244,100.00 54 55 Year End Balance(before debt service) $ 5,710,279.14 $ 5,858,124.58 $ 6,310,889.12 $ 6,475,604.48 $ 7,029,924.70 $ 6,188,520.14 $ 5,505,001.26 $ 4,949,943.50 $ 4,739,213.76 $ 4,602,598.09 $ 4,627,731.05 $ 4,770,426.55 55 56 Balance change amount $ 669,870.89 $ 249,620.69 $ 452,764.54 $ 164,715.36 $ 554,320.21 $ (841,404.55) $ (683,518.89) $ (555,057.75) $ (210,729.74) $ (136,615.67) $ 25,132.96 $ 142,695.50 56 57 Balance change% 13.29% 4.45% 7.73% 2.61% 8.56% -11.97% -11.04% -10.08% -4.26% -2.88% 0.55% 3.08% 57 G:\Utilities\Rates\Water Rates 20150720 Debt Service Impact Description 2014 Projected 2014 Actual 2015 Projected 2016 Budgeted 2017 2018 2019 2020 2021 2022 2023 2024 2025 58 Water Core Fund Beginning Balance $ 355,453.81 $ 663,710.62 $ 364,510.62 $ 200,135.62 $ 126,060.62 $ 242,860.62 $ 371,535.62 $ 506,085.62 $ 652,510.62 $ 810,810.62 $ 980,985.62 $ 1,163,035.62 58 59 Water Core Fund Revenue from New Connections $ 391,500.00 $ 295,800.00 $ 380,625.00 $ 380,625.00 $ 391,500.00 $ 402,375.00 $ 413,250.00 $ 424,125.00 $ 435,000.00 $ 445,875.00 $ 456,750.00 $ 467,625.00 59 60 Capital Investment Fund Beginning Balance $ 329,589.00 $ 339,393.62 $ 645,525.62 $ 959,707.10 $ 1,281,996.84 $ 1,612,629.40 $ 1,951,841.13 $ 2,299,870.28 $ 2,656,957.00 $ 3,023,343.44 $ 3,399,273.80 $ 3,784,994.36 60 61 Water Surcharge-Single Family 5/8"(95%) $ 229,398.40 $ 231,404.80 $ 237,256.80 $ 243,108.80 $ 249,128.00 $ 255,314.40 $ 261,668.00 $ 268,188.80 $ 274,876.80 $ 281,732.00 $ 288,754.40 $ 295,944.00 61 62 Capital Water Family-Multi Surcharge 5/8" Investment Fund g y (5%) $ 9,329.60 $ 9,411.20 $ 9,649.20 $ 9,887.20 $ 10,132.00 $ 10,383.60 $ 10,642.00 $ 10,907.20 $ 11,179.20 $ 11,458.00 $ 11,743.60 $ 12,036.00 62 63 Revenue Water Surcharge-1"(inc.3%/year) $ 40,824.00 $ 41,796.00 $ 43,049.88 $ 44,341.38 $ 45,671.62 $ 47,041.77 $ 48,453.02 $ 49,906.61 $ 51,403.81 $ 52,945.92 $ 54,534.30 $ 56,170.33 63 64 Water Surcharge-1.5"(inc.3%/year) $ 23,184.00 $ 23,520.00 $ 24,225.60 $ 24,952.37 $ 25,700.94 $ 26,471.97 $ 27,266.13 $ 28,084.11 $ 28,926.63 $ 29,794.43 $ 30,688.27 $ 31,608.91 64 65 Total Water Surcharge Revenue $ 302,736.00 $ 306,132.00 $ 314,181.48 $ 322,289.74 $ 330,632.56 $ 339,211.73 $ 348,029.15 $ 357,086.72 $ 366,386.44 $ 375,930.35 $ 385,720.57 $ 395,759.24 65 66 Estimated Debt Service $ 617,000.00 $ 617,000.00 $ 595,000.00 $ 545,000.00 $ 454,700.00 $ 274,700.00 $ 273,700.00 $ 278,700.00 $ 277,700.00 $ 276,700.00 $ 275,700.00 $ 274,700.00 $ 277,700.00 66 67 Debt Service Capital Investment Fund Contribution to Debt Service $ 302,000.00 $ 302,000.00 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 67 68 Water Core Fund Contribution to Debt Service $ 315,000.00 $ 315,000.00 $ 595,000.00 $ 545,000.00 $ 454,700.00 $ 274,700.00 $ 273,700.00 $ 278,700.00 $ 277,700.00 $ 276,700.00 $ 275,700.00 $ 274,700.00 $ 277,700.00 68 69 Capital Investment Fund Year End Balance $ 330,325.00 $ 339,393.62 $ 645,525.62 $ 959,707.10 $ 1,281,996.84 $ 1,612,629.40 $ 1,951,841.13 $ 2,299,870.28 $ 2,656,957.00 $ 3,023,343.44 $ 3,399,273.80 $ 3,784,994.36 $ 4,180,753.60 69 Year End Fund 70 Balances Water Core Fund Year End Balance $ 431,953.81 $ 663,710.62 $ 364,510.62 $ 200,135.62 $ 126,060.62 $ 242,860.62 $ 371,535.62 $ 506,085.62 $ 652,510.62 $ 810,810.62 $ 980,985.62 $ 1,163,035.62 $ 1,352,960.62 70 71 Water Utility Fund Year End Balance $ 5,710,279.14 $ 5,608,503.89 $ 5,858,124.58 $ 6,310,889.12 $ 6,475,604.48 $ 7,029,924.70 $ 6,188,520.14 $ 5,505,001.26 $ 4,949,943.50 $ 4,739,213.76 $ 4,602,598.09 $ 4,627,731.05 $ 4,770,426.55 71 G.\Utilities\Rates\Water Rates 20150720 Sanitary Sewer Rate Analysis Description 2014 Projected 2014 Actual 2015 Projected 2016 Budgeted 2017 2018 2019 2020 2021 2022 2023 2024 2025 1 Water Demand(MG) 902.80 815.26 870.00 892.04 914.08 936.73 960.00 983.88 1,008.37 1,033.47 1,059.18 1,085.51 1,112.45 1 2 Q1 Water Demand(MG)(-14%of total demand) 126.39 124.68 121.80 124.89 127.97 131.14 134.40 137.74 141.17 144.69 148.29 151.97 155.74 2 3 Projected Sanitary Sewer Flows(MG)* 533.80 516.90 527.29 540.65 554.01 567.74 581.84 596.31 611.15 626.37 641.95 657.91 674.23 3 Demands and 4 Connections Estimated Growth(from water spreadsheet) 2.5% 1.4% 2.0% 2.5% 2.5% 2.5% 2.5% 2.5% 2.5% 2.5% 2.5% 2.5% 2.5% 4 5 Residential Accounts(includes multi-family) 6,860 6,784 6,920 7,095 7,270 7,450 7,635 7,825 8,020 8,220 8,425 8,635 8,850 5 6 Commercial/Ind/Inst Accounts 180 181 185 190 195 200 205 210 215 220 225 230 235 6 7 Projected Rates Sanitary Sewer Fixed Charge($/account/quarter) $ 22.50 $ 22.50 $ 23.00 $ 23.50 $ 24.00 $ 24.50 $ 25.00 $ 25.50 $ 26.00 $ 26.50 $ 27.00 $ 27.50 $ 28.00 7 8 Usage Rates Per 1000 Gal(2%inc.starting in 2014) $ 1.69 $ 1.69 $ 1.73 $ 1.78 $ 1.84 $ 1.89 $ 1.95 $ 2.01 $ 2.07 $ 2.13 $ 2.19 $ 2.26 $ 2.32 8 9 Scenario#2 rates $ 1.69 $ 2.00 $ 2.10 $ 2.20 $ 2.30 $ 2.40 $ 2.50 $ 2.60 $ 2.70 $ 2.80 $ 2.90 $ 3.00 9 10 602 49450 Sewer Utility Fund Beginning Balance $ 2,055,825.50 $ 2,055,825.50 $ 1,895,157.82 $ 1,887,676.38 $ 1,826,766.19 $ 1,856,390.57 $ 1,846,256.08 $ 1,842,268.02 $ 1,902,571.61 $ 2,001,563.72 $ 2,141,934.89 $ 2,299,145.88 $ 2,531,341.63 10 12 Fixed Charges $ 633,600.00 $ 653,660.00 $ 684,790.00 $ 716,640.00 $ 749,700.00 $ 784,000.00 $ 819,570.00 $ 856,440.00 $ 894,640.00 $ 934,200.00 $ 975,150.00 $ 1,017,520.00 12 13 Revenue Sewer Use Charges(-72%of water demand billed) $ 1,101,686.66 $ 1,083,672.00 $ 1,144,459.82 $ 1,207,919.61 $ 1,274,990.30 $ 1,345,856.42 $ 1,420,711.10 $ 1,499,756.39 $ 1,583,203.68 $ 1,671,274.07 $ 1,764,198.84 $ 1,862,219.84 13 14 Miscellaneous Revenue(-8%of usage revenue) $ 173,528.67 $ 138,986.56 $ 146,339.99 $ 153,964.77 $ 161,975.22 $ 170,388.51 $ 179,222.49 $ 188,495.71 $ 198,227.49 $ 208,437.93 $ 219,147.91 $ 230,379.19 14 15 Total Revenue $ 1,908,815.33 $ 1,651,532.00 $ 1,876,318.56 $ 1,975,589.81 $ 2,078,524.38 $ 2,186,665.52 $ 2,300,244.94 $ 2,419,503.59 $ 2,544,692.10 $ 2,676,071.17 $ 2,813,912.00 $ 2,958,496.75 $ 3,110,119.02 15 21 100's-Salaries and Benefits(4%)(add 1 pos.in 2019) $ 443,800.00 $ 452,012.00 $ 449,600.00 $ 496,300.00 $ 516,200.00 $ 536,900.00 $ 648,400.00 $ 674,400.00 $ 701,400.00 $ 729,500.00 $ 758,700.00 $ 789,100.00 $ 820,700.00 21 22 200's-Materials and Equipment $ 13,800.00 $ 6,468.00 $ 13,800.00 $ 13,800.00 $ 14,300.00 $ 14,800.00 $ 15,300.00 $ 15,800.00 $ 16,300.00 $ 16,800.00 $ 17,400.00 $ 18,000.00 $ 18,600.00 22 23 300's-Communications,Computer,Eng,Prof Svcs $ 92,700.00 $ 69,876.00 $ 117,700.00 $ 101,400.00 $ 104,500.00 $ 107,700.00 $ 111,000.00 $ 114,400.00 $ 117,900.00 $ 121,500.00 $ 125,200.00 $ 129,000.00 $ 132,900.00 23 24 400's-Training,Conferences,Contracted Repair,Misc $ 11,800.00 $ 1,002.00 $ 11,600.00 $ 11,600.00 $ 12,000.00 $ 12,400.00 $ 12,800.00 $ 13,200.00 $ 13,600.00 $ 14,100.00 $ 14,600.00 $ 15,100.00 $ 15,600.00 24 25 500's-Buildings,Machinery,Furniture,Equipment $ 21,000.00 $ - $ 21,000.00 $ 21,000.00 $ 21,700.00 $ 22,400.00 $ 23,100.00 $ 23,800.00 $ 24,600.00 $ 25,400.00 $ 26,200.00 $ 27,000.00 $ 27,900.00 25 26 Expenses 530.03-CRP of Sewer Main $ 150,000.00 $ - $ 150,000.00 $ 150,000.00 $ 150,000.00 $ 150,000.00 $ 150,000.00 $ 150,000.00 $ 150,000.00 $ 150,000.00 $ 150,001.00 $ 150,001.00 $ 150,002.00 26 27 602-Sewer Service Charges(4%per year starting 2014) $ 1,090,300.00 $ 1,090,261.00 $ 1,080,000.00 $ 1,130,000.00 $ 1,175,200.00 $ 1,222,300.00 $ 1,271,200.00 $ 1,322,100.00 $ 1,375,000.00 $ 1,430,000.00 $ 1,487,200.00 $ 1,546,700.00 $ 1,608,600.00 27 28 611-Interest on Lease Payments $ - $ 2,165.00 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 28 29 710.00-Transfers for Other Improvements $ - $ 2,405.00 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 29 30 Utility Equipment Purchases(from CIP) $ 177,500.00 $ 189,190.00 $ - $ 27,500.00 $ 13,500.00 $ 87,500.00 $ 28,333.00 $ - $ - $ - $ 27,500.00 $ - $ - 30 31 Lift Station Expenses $ 50,900.00 $ 36,117.00 $ 40,100.00 $ 84,900.00 $ 41,500.00 $ 42,800.00 $ 44,100.00 $ 45,500.00 $ 46,900.00 $ 48,400.00 $ 49,900.00 $ 51,400.00 $ 53,000.00 31 32 Total Expenses $ 2,051,800.00 $ 1,849,496.00 $ 1,883,800.00 $ 2,036,500.00 $ 2,048,900.00 $ 2,196,800.00 $ 2,304,233.00 $ 2,359,200.00 $ 2,445,700.00 $ 2,535,700.00 $ 2,656,701.00 $ 2,726,301.00 $ 2,827,302.00 32 33 Year End Balance $ 1,912,840.83 $ 1,895,157.82 $ 1,887,676.38 $ 1,826,766.19 $ 1,856,390.57 $ 1,846,256.08 $ 1,842,268.02 $ 1,902,571.61 $ 2,001,563.72 $ 2,141,934.89 $ 2,299,145.88 $ 2,531,341.63 $ 2,814,158.65 33 34 Balance change $ (142,984.67) $ (7,481.44) $ (60,910.19) $ 29,624.38 $ (10,134.48) $ (3,988.06) $ 60,303.59 $ 98,992.10 $ 140,371.17 $ 157,211.00 $ 232,195.75 $ 282,817.02 34 35 %change -6.96% -0.39% -3.23% 1.62% -0.55% -0.22% 3.27% 5.20% 7.01% 7.34% 10.10% 11.17% 35 Sanitary Sewer Flows are calculated from July 1 through June 30 of the following year. This is the number used by MCES to calculate the following year Sanitary Service Charges(line 31). For example: flows from July 1,2012 through June 30,2013 are used to determine our 2014 service charges. MCES charges per 1,000 gallons $2.10923 Percent change from previous year 6.614% G:\Utilities\Rates\Sewer Rates 20150720 Model Page One 2016 BUDGET WORKSHEETS WATER UTILITY -REVENUES- April 14,2015 2016 2015 Object 2016 2012 2013 2014 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 601 33425.00 Other State Grants&Aids $19,960 $0 $9,901 $0 $0 601 34108.00 Administrative Fees-Other Funds 5,733 2,497 3,931 0 0 5%of 5%Fees-Const Projects 601 34109.00 Other Gen'I Govt Chgs for Services 14,000 12,250 15,820 0 0 601 36101.00 Principal-Special Assessments 59,342 55,362 56,217 55,000 55,000 601 36102.00 Penalties&Interest-S/A (3,093) 224 (847) 0 0 601 36210.00 Interest Earnings-Investments 60,556 57,119 105,027 55,000 55,000 601 36214.00 Net Change in FV-Investments 5,131 (125,524) 96,607 0 0 Annual Market Value Changes 601 36215.00 Interest Earnings 427 70 65 500 500 601 36220.00 Rents&Royalties 84,223 88,052 107,624 90,000 90,000 Antenna Leases 601 36260.00 Other Revenues 0 128 0 0 0 601 36265.00 Use of Reserve Funds 0 0 0 41,800 41,800 601 37110.00 Residential Water Revenues 1,258,104 1,155,429 1,100,286 1,100,000 1,100,000 601 37120.00 Apartment Water Revenues 79,934 83,470 84,079 80,000 80,000 601 37125.00 Institutional Water Revenues 87,847 70,541 61,957 70,000 70,000 601 37130.00 Commercial Water Revenues 84,393 79,091 79,817 75,000 75,000 _ 601 37140.00 Industrial Water Revenues 70,693 123,072 113,947 70,000 70,000 601 37160.00 Penalties-Water Revenues 10,470 9,896 9,280 9,000 9,000 601 37165.00 Meter Maint Water Revenues 0 0 0 0 0 601 37170.00 Other Water Revenues 0 0 2,800 0 0 601 37180.00 Water Meter Sales Revenue 42,497 46,529 37,385 40,000 40,000 _ 601 39103.00 Gain or Loss from F/A Disposal (739) (144) 0 0 0 601 39203.00 Transfer From 0 24,443 0 0 0 FUND TOTALS $1,879,477 $1,682,505 $1,883,897 $1,686,300 $1,686,300 Page One 2016 BUDGET WORKSHEETS WATER UTILITY -EXPENDITURES- April 14,2015 2016 2015 Object 2016 2012 2013 2014 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 601 49400 101.00 Salaries&Benefits $479,800 Salary,Taxes,PERA&Benefits 601 49400 77 101.00 Administrative 120,763 117,500 117,387 115,100 149,500 601 49400 78 101.00 Technical/Clerical 144,153 142,778 151,671 153,100 159,800 601 49400 79 101.00 Maintenance 146,589 157,164 163,437 164,900 170,500 601 49400 xx 101.00 Salary&Benefit Contingency 0 0 0 0 0 601 49400 102.00 Full-Time Overtime 7,794 15,629 13,810 8,000 8,000 601 49400 103.00 Part-Time Salaries&Benefits 6,112 5,697 6,508 8,000 8,000 601 49400 99 103.01 Utility Commission Wages(50%) 1,000 50%-601; 50%-602 601 49400 99 103.02 Maintenance Labor 7,000 100%-601 601 49400 01 203.00 Printed Forms&Paper 2,260 1,742 2,075 2,000 2,200 Inserts&Water Bill Statements 601 49400 01 209.00 Other Office Supplies 749 1,459 186 200 200 601 49400 01 216.00 Chemicals&Chemical Products 66,610 58,454 51,562 70,000 70,000 Chlorine,Flouride,Polyphos 601 49400 01 219.00 Other Operating Supplies 97 331 250 200 300 Maintenance Supplies 601 49400 01 220.00 Water Meter Purchases 105,000 Meters,MIU's&CU Horns 601 49400 01 220.01 For Replacements 0 43,441 13,930 45,000 60,000 New Meter Standards 601 49400 01 220.02 For New Homes 46,600 61,704 68,837 68,000 45,000 From Water Rate Model 601 49400 01 224.00 Street Maintenance Materials 637 0 0 2,500 2,500 Patching for Breaks 601 49400 01 225.00 Landscaping Materials 208 845 0 500 500 Topsoil,Seed&Sod 601 49400 01 228.00 Meter Repair Materials 0 29 490 0 0 601 49400 01 229.00 Other Maintenance Supplies 24,000 601 49400 01 229.01 Supplies for Hydrants 4,599 3,332 6,622 6,000 6,000 601 49400 01 229.02 Curb Shutoffs 1,097 565 653 1,000 1,000 601 49400 01 229.03 GV Repair/Replacement 2,574 0 11,973 2,200 12,000 Repairs Done By City Staff 601 49400 01 229.04 Miscellaneous Supplies 4,438 3,355 2,581 5,000 5,000 601 49400 01 241.00 Small Tools 1,792 614 702 2,000 2,000 Wrenches,Shovels,etc. 601 49400 01 242.00 Minor Equipment 609 2,860 2,966 3,000 3,000 601 49400 01 303.00 Engineering Fees 45,000 601 49400 01 303.01 WHPP 474 0 0 5,000 5,000 Groundwater Plan Implementation 601 49400 01 303.02 GIS 2,539 516 4,607 5,000 5,000 601 49400 01 303.03 Rate Study 0 0 0 0 15,000 Part of Comp Plan Update 601 49400 01 303.04 Miscellaneous Fees 28,450 20,093 29,118 20,000 20,000 601 49400 01 304.00 Legal Fees 1,269 0 0 1,000 1,000 601 49400 01 310.00 Testing Services 47,000 601 49400 01 310.01 Bacteria&Water Quality 1,560 1,585 1,560 2,500 2,000 Radon,Tri-Chl.,Pesticides,Etc. 601 49400 01 310.02 V.O.C.,Pesticides,etc. 0 0 0 0 0 601 49400 01 310.03 MDH Service Connection Fee 41,623 43,149 43,552 44,000 45,000 $6.36/Connection-Annual Fee 601 49400 01 312.00 Gopher State One-Call 2,559 2,303 2,770 2,500 2,500 $7500 split 3 ways 601 49400 01 313.00 Temporary Service Fees 6,190 0 0 0 0 601 49400 01 318.00 Contract Engineer 8,000 10,000 12,000 25,000 0 601 49400 01 319.00 Other Professional Services 23,100 601 49400 01 319.01 Thaw Pipes,Check Leaks,etc. 311 0 32,250 1,500 1,500 601 49400 01 319.02 Supervisory Controls 910 15,648 6,562 5,000 5,000 SCADA 601 49400 01 319.03 Hazardous Chemical Permits 725 725 725 1,000 1,000 MN Department of Public Safety 601 49400 01 319.06 Contracted Hydrant Painting 9,922 10,004 10,120 10,000 10,000 120 Hydrants/Yr($82 each) 601 49400 01 319.07 Antenna Expenses 0 12,563 19,904 0 0 601 49400 01 319.08 Buxton Project 0 0 5,556 5,600 5,600 601 49400 01 320.00 Credit Card Activity Fees 0 3,324 5,372 3,000 6,000 1/3 Cost of C/C Pymt Processing 601 49400 01 321.00 Telephone Costs 2,646 2,745 3,003 3,000 3.500 Cell Phones,Modesm,GPS 601 49400 01 322.00 Postage Costs 4,678 4,556 4,173 5,000 5,000 Billings with Inserts 601 49400 01 323.00 Radio Units 1,116 1,045 1,367 1,500 1,500 24 Units*$300(Split 5 Ways) 601 49400 01 352-08 - _ • - _ - _ .. - • - 78 0 0 0 0 601 49400 01 365.00 Workers Comp Insurance 6,807 6,990 7,095 7,000 7,000 Water's Share of Premiums 601 49400 01 369.00 Other Insurance 10,746 6,181 6,048 12,000 12,000 Water's Share of Premiums 601 49400 01 391.00 P.C.Maintenance 2,900 601 49400 01 391.01 U/B Software Maintenance 1,827 2,081 2,074 2,000 2,200 Added to Utility Budgets in 2012 601 49400 01 391.02 Auto Read Software Support 585 585 578 700 700 Added to Utility Budgets in 2012 601 49400 01 392.00 P.C.Accessories&Supplies 0 0 0 200 200 601 49400 01 393.00 P.C.Hardware Purchases 1,637 4,093 1,707 12,000 2,000 !• -_ _ 601 49400 01 394.00 P.C.Software Purchases 7,200 601 49400 01 394.01 Licensing&Maintenance 4,843 4,279 4,371 6,200 6,200 Cartegraph,GIS 601 49400 01 394.02 Online Subscriptions 308 286 379 800 800 Pictometry 601 49400 01 394.03 New Software Purchases 7,868 2,271 0 200 200 601 49400 01 395.00 P.C.Repairs 0 0 0 0 0 PAGE TOTALS 705,356 772,524 820,530 838,400 871,400 Page Two 2016 BUDGET WORKSHEETS WATER UTILITY -EXPENDITURES- April 14,2015 2016 2015 Object 2016 2012 2013 2014 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 601 49400 01 403.00 Contracted R&M-Other Impr 22,113 30,845 23,576 30,000 30,000 Main Breaks,Gate Valves,Etc. 601 49400 01 416.00 Machinery Rental 0 0 0 0 0 601 49400 01 433.00 Dues&Subscriptions 73 25 0 200 400 Suburban Utility Supt Assn,MRWA 601 49400 01 435.00 Books&Pamphlets 23 0 0 200 200 Reference Materials 601 49400 01 437.00 Conferences&Seminars 4,300 601 49400 01 437.01 MDH Training(Water School) 755 816 1,459 1,500 2,000 Operator Licensure 601 49400 01 437.02 AWWA Conference 0 0 0 0 0 601 49400 01 437.03 CarteGraph,ESRI,GIS 270 370 126 1,300 1,300 User Group,Conference,Training 601 49400 01 437.04 Miscellaneous Training 0 0 9 1,000 1,000 601 49400 01 439.00 Other Miscellaneous Charges 16,646 14,627 13,460 45,000 45,000 DNR Annual Water Use 601 49400 01 521.00 Building&Structure Purchases 0 0 0 10,000 10,000 Pymt on P.W.Building(17 of 20) 601 49400 01 530.00 Improvements Other Than Bldgs 345,600 601 49400 01 530.01 Well Inspections 560 490 560 600 600 601 49400 01 530.02 Miscellaneous Improvements 1,050 0 0 5,000 5,000 601 49400 01 530.03 CRP of Watermain 0 0 0 150,000 150,000 Annual Pavement Management 601 49400 01 530.04 Inspection&Maintenance 20,000 0 0 320,000 190,000 From Long-Term Project Schedule 601 49400 01 570.00 Office Equipment Purchases 58 107 0 1,000 500 601 49400 01 611.00 Interest on Lease Payments 2,893 2,538 2,167 0 0 P.W.Building Expansion(See 521) 601 49400 01 710.00 Transfers 200,000 139,194 4,796 0 0 Transfers for Other Improvements 601-49400-01 TOTALS 969,797 961,537 866,683 1,404,200 1,307,400 601 49406 01 221.00 Equipment Parts 0 0 2,762 500 500 601 49406 01 223.00 Building Repair Supplies 0 0 7,250 200 200 601 49406 01 319.00 Other Professional Services 0 0 2,352 1,000 1,000 601 49406 01 381.00 Electric Utilities 995 1,045 1,083 1,300 1,300 Pumping&Lighting TOTAL-PRV 995 1,045 13,448 3,000 3,000 601 49407 01 221.00 Equipment Parts 5,968 1,401 0 1,500 1,500 601 49407 01 223.00 Building Repair Supplies 0 0 8 200 200 601 49407 01 319.00 Other Professional Services 0 0 0 0 0 601 49407 01 321.00 Telephone Costs 211 211 211 300 300 601 49407 01 381.00 Electric Utilities 21,934 23,667 23,142 33,000 33,000 Pumping,Lighting,Tower Mixer 601 49407 01 409.00 Other Contracted Repairs&Maint 0 6,000 11,781 2,000 2,000 $800 for Lights in 2015 601 49407 01 439.00 Other Miscellaneous Charges 0 37 0 100 100 Contingencies 601 49407 01 530:00 - - - -••-• - e •- •-• _ -- 1-04 0 0 0 0 TOTAL-WELL#7 28,213 31,316 35,142 37,100 37,100 601 49408 01 221.00 Equipment Parts 2,024 1,342 242 1,500 1,500 601 49408 01 223.00 Building Repair Supplies 15 0 106 200 200 601 49408 01 319.00 Other Professional Services 0 0 0 0 0 601 49408 01 381.00 Electric Utilities 21,917 23,841 21,542 25,000 25,000 Pumping&Lighting 601 49408 01 383.00 Gas Utilities 428 470 592 600 600 Heat Only 601 49408 01 409.00 Other Contracted Repairs&Maint 0 5,952 27,330 2,000 2,000 $800 for Lights in 2015 601 49408 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies 601 49408-e 53a,Oe • . _ -- 0 0 0 e 0 TOTAL-WELL#8 24,385 31,605 49,812 29,400 29,400 601 49409 01 221.00 Equipment Parts 3,955 2,831 2,569 1,500 1,500 601 49409 01 223.00 Building Repair Supplies 0 0 0 200 200 601 49409 01 319.00 Other Professional Services 0 0 0 0 0 601 49409 01 381.00 Electric Utilities 25,692 16,618 31,854 30,000 32.000 Pumping&Lighting 601 49409 01 383.00 Gas Utilities 627 795 901 1,500 1,500 Heat Only 601 49409 01 409.00 Other Contracted Repairs&Maint 0 837 335 2,000 2,000 $800 for Lights in 2015 601 49409 01 439.00 Other Miscellaneous Charges 259 0 0 100 100 Contingencies -1-04 24v007 0 0 0 - TOTAL-WELL#9 30,633 42,988 35,659 35,300 37,300 Page Three 2016 BUDGET WORKSHEETS WATER UTILITY -EXPENDITURES- April 14,2015 2016 2015 Object 2016 2012 2013 2014 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 601 49410 01 219.00 Other Operating Supplies 1 0 0 500 500 601 49410 01 221.00 Equipment Parts 1,062 4,434 0 1,000 1,000 601 49410 01 223.00 Building Repair Supplies 0 213 15 200 200 601 49410 01 324-410 Telep4one-Costs 765 765 765 0 0 601 49410 01 381.00 Electric Utilities 13,189 16,623 13,223 17,000 17,000 Pumping&Lighting 601 49410 01 409.00 Other Contracted Repairs&Maint 1,703 9,957 1,748 2,000 2,000 $800 for Lights in 2015 601 49410 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies 601 19110 01 &30-00 • - - -••-• - : •- •-• = .. 0 10,014 0 9 9 TOTAL-WELL#10 16,720 42,005 15,751 20,800 20,800 Rural Water System 601 49411 01 221.00 Equipment Parts 0 0 0 0 0 601 49411 01 439.00 Other Miscellaneous Charges 0 0 0 0 0 TOTAL-WELL#11 0 0 0 0 0 Rural Water System(#2) 601 49412 01 221.00 Equipment Parts 1,847 0 0 1,500 1,500 601 49412 01 223.00 Building Repair Supplies 10 0 0 200 200 601 49412 01 319.00 Other Professional Services 0 0 0 0 0 601 49412 01 381.00 Electric Utilities 22,444 23,242 21,696 30,000 28,000 Pumping&Lighting 601 49412 01 409.00 Other Contracted Repairs&Maint 278 1,495 8,317 2,000 2,000 $800 for Lights in 2015 601 49412 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies TOTAL-WELL#12 24,578 24,737 30,013 33,800 31,800 601 49414 01 221.00 Equipment Parts 1,063 0 161 1,500 1,500 601 49414 01 223.00 Building Repair Supplies 0 0 408 200 200 601 49414 01 319.00 Other Professional Services 1,097 0 384 1,000 1,000 _ 601 49414 01 381.00 Electric Utilities 24,193 27,051 23,382 30,000 28,000 Pumping&Lighting 601 49414 01 409.00 Other Contracted Repairs&Maint 0 883 0 2,000 2,000 $800 for Lights in 2015 601 49414 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies 601 49414 01 530.00 - - ----• a •- •-• _ -- 0 0 0 0 0 TOTAL-WELL#14 26,353 27,934 24,335 34,800 32,800 601 49425 01 221.00 Equipment Parts 3,629 575 830 1,500 1,500 601 49425 01 223.00 Building Repair Supplies 0 0 0 200 200 601 49425 01 319.00 Other Professional Services 0 0 0 500 500 601 49425 01 381.00 Electric Utilities 23,461 26,071 24,817 30,000 28,000 Pumping&Lighting 601 49425 01 409.00 Other Contracted Repairs&Maint 0 1,526 430 2,000 2,000 $800 for Lights in 2015 601 49425 01 439.00 Other Miscellaneous Charges 185 0 0 100 100 Contingencies 601 4912501 53400 - - - e •- _ -- 0 0 0 0 0 TOTAL-WELL#15 27,276 28,172 26,077 34,300 32,300 601 49426 01 221.00 Equipment Parts 0 0 0 1,500 1,500 601 49426 01 223.00 Building Repair Supplies 0 0 0 200 200 601 49426 01 319.00 Other Professional Services 0 0 0 500 500 601 49426 01 381.00 Electric Utilities 0 0 0 30,000 28,000 Pumping&Lighting 601 49426 01 383.00 Gas Utilities 0 0 0 1,000 1,000 May Be Electric Only(TBD) 601 49426 01 409.00 Other Contracted Repairs&Maint 0 0 0 1,000 1,000 601 49426 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies 601 4942601 53o-o0 • - - -•--• e • -• _ --- 0 0 9 0 0 TOTAL-WELL#16 0 0 0 34,300 32,300 Page Four 2016 BUDGET WORKSHEETS WATER UTILITY -EXPENDITURES- April 14,2015 2016 2015 Object 2016 2012 2013 2014 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 601 49415 01 221.00 Equipment Parts 0 0 0 500 500 Touch-up Paint 601 49415 01 319.00 Other Professional Services 0 0 3,675 0 0 601 49415 01 409.00 Other Contracted Repairs&Maint 0 0 1,050 500 500 601 49415 01 439.00 Other Miscellaneous Charges 0 0 0 200 200 Contingencies 601 19415 01 630-00 0 0 0 0 0 TOTAL-WATER TOWER#1 0 0 4,725 1,200 1,200 (Chippendale Water Tower) 601 49416 01 221.00 Equipment Parts 0 12 101 500 500 Touch-up Paint 601 49416 01 319.00 Other Professional Services 0 0 0 0 0 Tower Inspection 601 49416 01 381.00 Electric Utilities 429 1,338 1,261 4,500 4,500 New Water Mixers in 2014 601 49416 01 409.00 Other Contracted Repairs&Maint 0 0 8,210 500 500 601 49416 01 439.00 Other Miscellaneous Charges 0 0 0 200 200 Contingencies 601-4944604 53040 0 0 0 0 0 TOTAL-WATER TOWER#2 429 1,350 9,572 5,700 5,700 (Connemara Water Tower) 601 49417 01 221.00 Equipment Parts 0 0 206 500 500 601 49417 01 319.00 Other Professional Services 0 0 0 0 0 601 49417 01 381.00 Electric Utilities 5,345 5,374 4,760 6,000 6,000 601 49417 01 409.00 Other Contracted Repairs&Maint 0 0 14,700 500 500 601 49417 01 439.00 Other Miscellaneous Charges 0 96 0 200 200 Contingencies 601 19117 01 530-00 0 0 0 0 0 TOTAL-WATER TOWER#4 5,345 5,470 19,666 7,200 7,200 (Bacardi Water Tower) 601 49418 01 221.00 Equipment Parts 0 0 0 500 500 601 49418 01 319.00 Other Professional Services 3,800 0 0 0 0 601 49418 01 381.00 Electric Utilities 1,885 3,359 2,768 4,000 4,000 New Water Mixers in 2014 601 49418 01 409.00 Other Contracted Repairs&Maint 792 519 15,500 500 500 601 49418 01 439.00 Other Miscellaneous Charges 28 0 0 200 200 Contingencies 601 19118 01 530-00 ••- e -••-• - e • -• _ --- 0 0 0 0 0 TOTAL-WATER TOWER#3 6,505 3,878 18,268 5,200 5,200 (East Side Water Tower) GRAND TOTAL-ALL DEPTS. $1,161,229 $1,202,036 $1,149,152 $1,686,300 $1,583,500 -6.1% overall decrease 10 4% increase in salaries and benefits -12 1% decrease in operating budget Page One 2016 BUDGET WORKSHEETS SEWER UTILITY -EXPENDITURES- April 14,2015 2016 2015 Object 2016 2012 2013 2014 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 602 49450 101.00 Salaries&Benefits $479,800 Salary,Taxes,PERA&Benefits 602 49450 77 101.00 Administrative 120,762 117,498 117,386 115,100 149,500 602 49450 78 101.00 Technical/Clerical 144,154 142,778 151,671 153,100 159,800 602 49450 79 101.00 Maintenance 146,589 157,163 163,438 164,900 170,500 602 49450 xx 101.00 Salary&Benefit Contingency 0 0 0 0 0 602 49450 102.00 Full-Time Overtime 7,794 15,629 13,810 7,500 7,500 602 49450 103.00 Part-Time Salaries&Benefits 8,025 5,531 5,707 9,000 9,000 602 49450 99 103.01 Utility Commission Wages(50%) 1,000 50%-602; 50%-601 602 49450 99 103.02 Maintenance Labor 8,000 100%-602 602 49450 01 203.00 Printed Forms&Paper 1,499 1,613 1,416 1,500 1,500 Inserts&Water Bill Statements 602 49450 01 209.00 Other Office Supplies 227 899 172 200 200 602 49450 01 216.00 Chemicals&Chemical Products 0 0 0 500 500 Root Killer,Degreaser 602 49450 01 219.00 Other Operating Supplies 0 304 100 200 200 602 49450 01 224.00 Street Maintenance Materials 0 0 0 2,500 2,500 Patching 602 49450 01 225.00 Landscaping Materials 0 0 0 400 400 Topsoil,Seed&Sod 602 49450 01 227.00 Utility System Maintenance Supplies 3,292 211 797 5,000 5,000 MH Castings Replacement Prog. 602 49450 01 241.00 Small Tools 802 165 237 500 500 Wrenches,Shovels,etc. 602 49450 01 242.00 Minor Equipment 414 2,990 3,746 3,000 3,000 602 49450 01 303.00 Engineering Fees 35,000 602 49450 01 303.01 GIS 2,539 516 4,607 5,000 5,000 602 49450 01 303.02 Rate Study 0 0 0 0 15,000 Part of Comp Plan Update 602 49450 01 303.04 Miscellaneous 2,395 7,402 2,846 15,000 15,000 Sewer System O&M Review 602 49450 01 304.00 Legal Fees 286 0 0 500 500 602 49450 01 312.00 Gopher State One-Call 2,559 2,303 2,770 2,500 2,500 $7500 split 3 ways 602 49450 01 313.00 Temporary Service Fees 0 0 0 0 0 602 49450 01 318.00 Contract Engineer 8,000 10,000 12,000 25,000 0 602 49450 01 319.00 Other Professional Services 15,600 602 49450 01 319.01 Televising 531 0 0 3,000 3,000 602 49450 01 319.02 Root Control 0 0 0 2,000 2,000 602 49450 01 319.03 Supervisory Controls(Maint Cont) 0 6,802 0 5,000 5,000 SCADA System 602 49450 01 319.04 Buxton Project 0 0 5,556 5,600 5,600 602 49450 01 320.00 Credit Card Activity Fees 0 3,324 5,372 3,000 6,000 1/3 Cost of C/C Pymt Processing 602 49450 01 321.00 Telephone Costs 2,646 2,745 3,001 3,000 3,500 Cell Phones,Modems,GPS 602 49450 01 322.00 Postage Costs 4,678 4,556 4,173 5,000 5,000 Billings with Inserts 602 49450 01 323.00 Radio Units 1,116 1,045 1,367 1,500 1,500 24 Units*$300(Split 5 Ways) 602 49450 01 365.00 Workers Comp Insurance 6,828 7,011 7,117 7,000 7,000 Sewer's Share of Premiums 602 49450 01 369.00 Other Insurance 6,443 10,777 12,067 12,000 12,000 Sewer's Share of Premiums 602 49450 01 391.00 P.C.Maintenance 0 0 0 2,900 602 49450 01 391.01 U/B Software Maintenance 1,827 2,081 2,074 2,000 2,200 Added to Utility Budgets in 2012 602 49450 01 391.02 Auto Read Software Support 585 585 578 700 700 Added to Utility Budgets in 2012 602 49450 01 392.00 P.C.Accessories&Supplies 0 0 0 200 200 602 49450 01 393.00 P.C.Hardware Purchases 1,362 4,093 1,600 12,000 2.000 602 49450 01 394.00 P.C.Software Purchases 7,200 602 49450 01 394.01 Licensing&Maintenance 4,779 4,279 4,371 6,200 6,200 Cartegraph,GIS 602 49450 01 394.02 Online Subscriptions 308 286 379 800 800 Pictometry 602 49450 01 394.03 New Software Purchases 7,772 2,271 0 200 200 602 49450 01 395.00 P.C.Repairs 0 0 0 500 500 602 49450 01 403.00 Contracted R&M-Other Impr 3,533 2,581 63 5,000 5,000 MH Castings Replacement Prog. 602 49450 01 415.00 Other Equipment Rental 0 0 0 200 200 602 49450 01 416.00 Machinery Rental 0 0 0 2,000 2,000 602 49450 01 433.00 Dues&Subscriptions 50 0 0 200 200 SUSA(AJ,Dick)50%Split w/Storm 602 49450 01 435.00 Books&Pamphlets 0 0 0 300 300 Reference Materials 602 49450 01 437.00 Conferences&Seminars 3,800 602 49450 01 437.01 MPCA Training(Sewer School) 90 1,646 669 1,500 1,500 Operator Licensure$300 each(M) 602 49450 01 437.02 Collection System Conference 1,310 0 0 0 0 Duplicate of Sewer School 437.01 602 49450 01 437.03 CarteGraph,ESRI,GIS 270 120 126 1,300 1,300 User Group,Conference,Training 602 49450 01 437.04 Miscellaneous Training 0 0 0 1,000 1,000 602 49450 01 439.00 Other Miscellaneous Charges 153 148 145 100 100 Contingencies 602 49450 01 521.00 Building&Structure Purchases 0 0 0 10,000 10,000 Pymt on P.W.Building(16 of 20) 602 49450 01 530.00 Improvements Other Than Bldgs 160,000 602 49450 01 530.01 Miscellaneous Improvements 0 31 0 10,000 10,000 SCADA Reconfiguration,PCL's 602 19150 01 530-02 _ _ -••-• 0 0 0 0 0 602 49450 01 530.03 CRP of Sewermain 0 0 0 150,000 150,000 Annual Pavement Management 602 19450 01 530-.04 0 0 0 0 0 602 49450 01 540.00 Heavy Machinery Purchases 0 0 189,190 0 0 602 49450 01 560.00 Furniture&Fixture Purchases 0 0 0 500 500 602 49450 01 570.00 Office Equipment Purchases 0 0 0 500 500 PAGE TOTALS 493,620 519,385 718,548 763,700 794,100 Page Two 2016 BUDGET WORKSHEETS SEWER UTILITY -EXPENDITURES- April 14,2015 2016 2015 Object 2016 2012 2013 2014 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 602 49450 01 602.00 Sewer Service Charges 940,900 1,007,195 1,090,261 1,080,000 1,130,000 MWCC Charges 602 49450 01 611.00 Interest on Lease Payments 2,893 2,538 2,165 0 0 P.W.Building Expansion(See 521) 602 49450 01 710.00 Transfers 10,493 116,948 2,405 0 0 Transfers for Other Improvements 602-49450-01 TOTALS 1,447,906 1,646,066 1,813,379 1,843,700 1,924,100 602 49451 01 219.00 Other Operating Supplies 0 0 0 100 100 602 49451 01 221.00 Equipment Parts 21 0 0 800 800 602 49451 01 229.00 Other Maintenance Supplies 0 0 0 200 200 602 49451 01 303.00 Engineering Fees 0 0 0 0 0 602 49451 01 381.00 Electric Utilities 925 915 916 1,500 1,500 602 49451 01 403.00 Contracted R&M-Other Impr 0 0 775 200 45,000 New electronics and cabinet 602 49451 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies (City Hall) TOTAL-LIFT STATION#1 947 915 1,691 2,900 47,700 602 49452 01 219.00 Other Operating Supplies 0 0 0 100 100 602 49452 01 221.00 Equipment Parts 59 1,060 0 800 800 602 49452 01 229.00 Other Maintenance Supplies 0 0 0 200 200 602 49452 01- 324-00 TEle &tss 10-5 0 0 0 0 602 49452 01 381.00 Electric Utilities 554 630 623 700 700 602 49452 01 403.00 Contracted R&M-Other Impr 0 0 0 200 200 602 49452 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies (Bloomfield 5th) TOTAL-LIFT STATION#7 719 1,691 623 2,100 2,100 602 49453 01 219.00 Other Operating Supplies 0 0 0 100 100 602 49453 01 221.00 Equipment Parts 0 0 0 800 800 602 49453 01 229.00 Other Maintenance Supplies 0 0 0 200 200 602 49453 01 381.00 Electric Utilities 3,578 3,753 3,548 4,000 4,000 602 49453 01 403.00 Contracted R&M-Other Impr 230 0 7,395 200 200 602 49453 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies (Shannon Pond) TOTAL-LIFT STATION#3 3,808 3,753 10,942 5,400 5,400 602 49454 01 219.00 Other Operating Supplies 0 0 0 100 100 602 49454 01 221.00 Equipment Parts 2,001 167 6 800 800 602 49454 01 229.00 Other Maintenance Supplies 0 0 0 200 200 602 49454 01 381.00 Electric Utilities 5,377 4,602 4,821 6,000 6,000 602 49454 01 403.00 Contracted R&M-Other Impr 0 1,582 0 2,000 2,000 602 49454 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies (Hawkins) TOTAL-LIFT STATION#4 7,377 6,351 4,827 9,200 9,200 602 49455 01 219.00 Other Operating Supplies 0 0 0 100 100 602 49455 01 221.00 Equipment Parts 0 0 1,800 800 800 602 49455 01 229.00 Other Maintenance Supplies 0 0 0 200 200 602 49455 01 303.00 Engineering Fees 0 0 0 0 0 602 49455 01 310.00 Testing Services 0 0 0 0 0 602 49455 01 381.00 Electric Utilities 5,879 5,569 5,802 6,000 6,000 602 49455 01 403.00 Contracted R&M-Other Impr 0 0 415 200 200 602 49455 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies (LeForet Add'n) TOTAL-LIFT STATION#5 5,879 5,569 8,016 7,400 7,400 602 49456 01 219.00 Other Operating Supplies 0 0 0 100 100 602 49456 01 221.00 Equipment Parts 4,247 2,385 0 800 800 602 49456 01 229.00 Other Maintenance Supplies 0 0 0 200 200 602 49456 01 381.00 Electric Utilities 3,788 6,001 8,270 6,000 6,000 602 49456 01 403.00 Contracted R&M-Other Impr 0 0 0 200 200 Alarm rades 602 49456 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies (Drumcliffe) TOTAL-LIFT STATION#6 8,035 8,385 8,270 7,400 7,400 Page Three 2016 BUDGET WORKSHEETS SEWER UTILITY -EXPENDITURES- April 14,2015 2016 2015 Object 2016 2012 2013 2014 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 602 49457 01 219.00 Other Operating Supplies 0 0 0 100 100 602 49457 01 221.00 Equipment Parts 0 0 0 500 500 602 49457 01 229.00 Other Maintenance Supplies 0 0 0 200 200 602 49457 01 381.00 Electric Utilities 1,176 1,278 857 1,200 1,200 602 49457 01 403.00 Contracted R&M-Other Impr 0 0 0 200 200 602 49457 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies (Glendalough 5th) TOTAL-LIFT STATION#9 1,176 1,278 857 2,300 2,300 602 49458 01 219.00 Other Operating Supplies 0 0 0 100 100 602 49458 01 221.00 Equipment Parts 353 1,269 0 500 500 602 49458 01 229.00 Other Maintenance Supplies 0 0 0 200 200 602 49458 01 381.00 Electric Utilities 522 633 629 800 800 602 49458 01 403.00 Contracted R&M-Other Impr 0 0 0 200 200 602 49458 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies (Meadows of) TOTAL-LIFT STATION#8 875 1,902 629 1,900 1,900 (Bloomfield) 602 49460 01 219.00 Other Operating Supplies 0 0 0 100 100 602 49460 01 221.00 Equipment Parts 294 725 0 500 500 602 49460 01 229.00 Other Maintenance Supplies 0 0 0 200 200 602 49460 01 381.00 Electric Utilities 251 252 261 400 400 602 49460 01 403.00 Contracted R&M-Other Impr 0 0 0 200 200 602 49460 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies (Glen Rose) TOTAL-LIFT STATION#10 545 977 261 1,500 1,500 GRAND TOTAL-ALL DEPTS. $1,477,266 $1,676,886 $1,849,496 $1,883,800 $2,009,000 6.6% overall increase 10.4% increase in salaries and benefits 5.5% increase in operating budget