Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
6.a. Water and Sewer Utility Rate Review
RO5EMEUI .1F EXECUTIVE SUMMARY UTILITY COMMISSION Utility Commission Meeting: August 11, 2014 AGENDA ITEM: Water and Sewer Utility Rate Review AGENDA SECTION: New Business PREPARED BY: Andrew J. Brotzler, PE, Director of Public AGENDA NO. Works / City Engineer �� ATTACHMENTS: Water Rate Analysis spreadsheet; Sanitary Sewer Rate Analysis APPROVED BY: spreadsheet; 2015 budget worksheets RECOMMENDED ACTION: Motion to Recommend City Council Approval of Water and Sewer Utility Rate Changes for 2015. BACKGROUND WATER UTILITY RATES For the past 41/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 2015 and beyond. Based on this review, staff is proposing a 5%increase over the rates in 2014,which is consistent with the increases over the past three years. The tables below summarize the rate changes over the past four years. Residential Tier 2011 Rate 2012 Rate 2013 Rate 2014 Rate 2015 Rate (0%) (5%) (5%) (5%) (5%) 0-10,000 $0.90 $0.95 $1.00 $1.05 $1.10 10,001 -30,000 $1.10 $1.16 $1.22 $1.28 $1.35 30,001 -60,000 $1.40 $1.47 $1.54 $1.62 $1.70 > 60,000 $1.90 $2.00 $2.10 $2.21 $2.32 Irrigation Only* $2.00 $2.00 $2.15 $2.32 $2.44 *includes all irrigation meters (multi-fam/comm/ind/inst) Commercial/Industrial/Institutional Tier 2011 Rate 2012 Rate 2013 Rate 2014 Rate 2015 Rate (0%) (5%) (5%) (5%) (5%) 0- 100,000 $1.05 $1.10 $1.16 $1.22 $1.28 100,001 -200,000 $1.30 $1.37 $1.44 $1.51 $1.59 200,001 -300,000 $1.60 $1.68 $1.76 $1.85 $1.94 > 300,000 $2.00 $2.10 $2.21 $2.32 $2.44 G:\Utilities\Rates\20140811 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 3%in 2015 and 2016, and 3.5%per year from 2017 through 2024. • LINE 7: Fixed rate charges are proposed to increase 5%per year. • LINES 27-35: In calculating the 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 2013): Residential Commercial/Industrial Tier %in tier Avg. usage Tier %in tier _ Avg. usage 0—10,000 27% 6,900 0—100,000 68% 29,000 10,001 —30,000 52% 17,800 100,001 —200,000 16% 140,000 30,001 —60,000 13% 42,000 200,001 —300,000 8% 245,000 > 60,000 8% 96,300 > 300,000 8% 1,200,000 FUTURE WATER TREATMENT FACILITY The attached water rate model includes funding the construction of a purposed water treatment facility in 2016. This has been shown in the year 2016 only from a funding capability standpoint,2016 being the year that existing debt service will be retired. The actual timing for the construction of a water treatment facility will affect the projected rate increases. If the project is delayed, the rates may be able to be modified. SEWER UTILITY RATES As illustrated in the sanitary sewer spreadsheet model, the usage rate is proposed to increase 2%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 2011 Rate 2012 Rate 2013 Rate 2014 Rate 2015 Rate (0%) (5%) (5%) (2%) (2%) Fixed Rate $20.00 $21.00 $22.00 $22.50 $23.00 Usage Rate $1.50 $1.58 $1.66 $1.69 $1.73 The sewer rate model includes the following items of note: • LINE 31: This line currently shows a 5% annual increase for Met Council sewer service charges, down from 7%used in previous models. The per-thousand-gallon charges have fluctuated over the past several years,but 5%per year appears to be a more reasonable estimate going forward. • LINE 35: 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 2016. SUMMARY Staff is requesting Utility Commission recommendation to the City Council to approve the proposed utility rate changes for 2015. G:\Utilities\Rates\20140811 UC Water and Sewer Rates.docx Water Rate Analysis Description 2013 Projected 2013 Actual 2014 Projected 2015 Budgeted 2016 2017 2018 2019 2020 2021 2022 2023 2024 1 Water Demand(MG) 992.90 880.61 902.80 929.91 962.06 995.48 1,030.15 1,066.09 1,103.28 1,141.74 1,181.46 1,222.44 1,264.68 1 2 Estimated Growth 2.0% 2.3% 2.5% 3.0% 3.5% 3.5% 3.5% 3.5% 3.5% 3.5% 3.5% 3.5% 3.5% 2 3 Projected Residential Accounts(excluding association irrigation) 6,680 6,693 6,860 7,065 7,310 7,565 7,830 8,105 8,390 8,685 8,990 9,305 9,630 3 Demands and 4 Commercial Accounts(excluding irrigation) 125 126 130 1.35 140 145 150 155 160 165 170 175 180 4 Connections 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) 110 116 120 125 130 135 140 145 150 155 160 165 170 6 ` 7 Water Fixed Charge($/accountquarter) $ 11.03 $ 11.03 S 11 58 $ 12 16 $ 12 77 $ 13 41 $ 14 08 $ 14 78 $ 15 52 S 16 30 S 17 11 $ 17 97 $ 18 87 7 8 Residential Tier 1 (0-10,000 gal) $ 1.00 $ 1.00 $ 1 05 $ 1 10 5 1 16 $ 1 22 S 1 28 S 1 34 $ 1 41 S 1 48 $ 1 55 $ 1 63 $ 1 71 8 9 Residential Tier 2(10,001-30,000 gal) $ 1.22 $ 1.22 S 1 28 $ 1 35 S 1 41 $ 1 48 S 1 56 S 1 63 $ 1 72 $ 1 80 S 1 89 5 1 99 $ 2 09 9 10 Residential Tier 3(30,001-60,000 gal) $ 1.54 $ 1.54 S 1 62 S 1.70 S 1 78 $ 1 87 $ 1 97 S 2.06 5 2 17 $ 2 28 $ 2 39 S 2 51 $ 2.63 10 11 Residential Tier 4(>60,000 gal) $ 2.10 $ 2.10 S 2 21 $ 2 32 $ 2 43 5 2 55 S 2 68 $ 2 81 S 2 95 S 3 10 S 3 26 S 3 42 $ 3 59 11 12 Irrigation Meters(Multi Fam/Comm/Ind/Inst) $ 2.15 $ 2.15 S 2 32 S 2 44 $ 2 56 $ 2 69 S 2 82 $ 2.96 $ 3 11 $ 3 26 S 3 43 $ 360 $ 3 78 12 13 Comm/Ind/Inst Tier 1 (0-100,000 gal) $ 1.16 $ 1.16 S 1 22 S 1 28 $ 1 34 $ 1 41 S 1 48 $ 1 55 $ 1 63 S 1 71 $ 1 80 $ 1 89 $ 1 98 13 14 Proposed Rates Comm/Ind/Inst Tier 2(100,001 -200,000 gal) $ 1.44 $ 1.44 $ 1 51 $ 1 59 $ 1 67 5 1 75 $ 1.84 $ 1 93 $ 2 03 3 2 13 $ 2.23 $ 2.35 $ 2 46 14 15 and Tiers Comm/Ind/Inst Tier 3(200,001 -300,000 gal) $ 1.76 $ 1.76 5 1 85 S 1 94 $ 2 04 $ 2 14 $ 2 25 $ 2 36 $ 2 48 $ 2 60 $ 2 73 $ 2 87 5 3 01 15 16 Comm/Ind/Inst Tier 4(>300,000 gal) $ 2.21 $ 2.21 S 2 32 5 2 44 $ 2 56 $ 2 69 $ 2 82 $ 2 96 $ 3 11 $ 3 27 S 3 43 $ 3 60 $ 3 78 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 $ 8.80 $ 8.80 $ 8.80 $ 8.80 17 18 Surcharge-Multi Family 5/8"($/account) $ 6.80 5 6.80 $ 6.80 5 6.80 5 6.80 5 6.80 $ 6.80 $ 6.80 5 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 5 28.00 $ 28.00 $ 28.00 $ 28.00 $ 28.00 $ 28.00 $ 28.00 $ 28.00 $ 28.00 20 21 Meter Maintenance-1"($/accounUquarter) $ 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"($/accounUquarter) $ 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 $ 4,427,365.19 $ 5,040,408.25 $ 5,410,510.77 $ 5,855,019.19 $ 5,221,457.29 $ 3,944,511.05 $ 3,706,540.12 $ 3,014,758.71 $ 2,763,176.38 $ 2,476,177.97 $ 2,372,909.08 $ 2,635,367.47 23 24 CRP,Equipment,Tower Reserves $ 304,000.00 $ 300,000.00 24 25 Available Water Utility Fund Beginning Balance $ 4,123,365.19 $ 4,740,408.25 $ 5,410,510.77 $ 5,855,019.19 $ 5,221,457.29 $ 3,944,511.05 $ 3,706,540.12 $ 3,014,758.71 $ 2,763,176.38 $ 2,476,177.97 $ 2,372,909.08 $ 2,635,367.47 25 26 Calculated Fixed Charges $ 307,156.50 $ 331,694.16 $ 358,736.96 $ 389,697.79 $ 423,394.13 $ 460,048.96 $ 499,902.04 5 543,211.12 $ 590,253.20 $ 641,325.91 $ 696,748.93 $ 756,865.53 26 27 Residential Tier 1 (0-10,000 gal) $ 46,760.00 $ 53,676.76 $ 58,044.84 $ 63,060.60 $ 68,523.41 $ 74,469.96 $ 80,939.71 $ 87,975.13 $ 95,621.83 $ 103,928.88 $ 112,948.95 $ 122,738.67 27 28 Residential Tier 2(10,001-30,000 gal) $ 290,392.96 $ 292,393.40 $ 316,187.65 $ 343,510.03 $ 373,267.58 $ 405,660.20 $ 440,902.90 $ 479,226.91 $ 520,880.81 $ 566,131.77 $ 615,266.84 $ 668,594.38 28 29 Residential Tier 3(30,001 -60,000 gal) $ 183,683.97 $ 198,065.21 $ 214,183.27 $ 232,691.26 $ 252,848.81 $ 274,791.34 5 298,664.50 $ 324,624.91 $ 352,840.97 $ 383,493.65 $ 416,777.40 $ 452,901.09 29 30 Residential Tier 4(>60,000 gal) $ 288,228.64 5 361,486.88 $ 390,903.79 $ 424,682.53 $ 461,471.89 $ 501,518.99 $ 545,089.65 $ 592,469.74 $ 643,966.59 $ 699,910.49 $ 760,656.34 $ 826,585.34 30 31 Irrigation Meters(Multi-Fam/Comm/Ind/Inst) $ 268,750.00 $ 255,200.00 $ 267,960.00 $ 281,358.00 $ 295,425.90 $ 310,197.20 $ 325,707.05 $ 341,992.41 $ 359,092.03 $ 377,046.63 $ 395,898.96 $ 415,693.91 31 32 Revenue Comm/Ind/Inst Tier 1 (0-100,000 gal) $ 17,782.80 $ 17,293.65 $ 18,662.73 $ 20,125.49 5 21,687.86 $ 23,356.16 $ 25,137.06 $ 27,037.67 $ 29,065.50 $ 31,228.51 $ 33,535.16 $ 35,994.41 32 33 Comm/Ind/Inst Tier 2(100,001 -200,000 gal) $ 15,797.60 $ 20,998.66 $ 22,661.05 $ 24,437.19 $ 26,334.28 $ 28,360.00 $ 30,522.45 $ 32,830.24 5 35,292.51 $ 37,918.93 $ 40,719.76 $ 43,705.88 33 34 Comm/Ind/Inst Tier 3(200,001 -300,000 gal) $ 11,564.00 $ 20,514.82 $ 22,138.91 $ 23,874.12 $ 25,727.50 $ 27,706.54 $ 29,819.16 $ 32,073.78 $ 34,479.32 $ 37,045.22 $ 39,781.52 $ 42,698.83 34 35 Comm/Ind/Inst Tier 4(>300,000 gal) $ 138,852.00 $ 146,664.00 5 158,274.90 $ 170,680.23 $ 183,930.41 $ 198,078.90 $ 213,182.41 $ 229,301.08 $ 246,498.67 $ 264,842.75 $ 284,405.00 $ 305,261.37 35 36 Calc.Meter Maintenance-1"(inc.2%/year) $ 18,475.00 $ 18,900 00 $ 19,278.00 $ 19,663.56 $ 20,056.83 $ 20,457.97 $ 20,867.13 $ 21,284.47 $ 21,710.16 $ 22,144.36 $ 22,587.25 $ 23,038.99 36 37 Calc.Meter Maintenance-1.5"(inc.2%/year) $ 9,270.00 $ 9,315.00 $ 9,501.30 $ 9,691.33 $ 9,885.15 $ 10,082.86 $ 10,284.51 $ 10,490.20 $ 10,700.01 $ 10,914.01 $ 11,132.29 $ 11,354.93 37 38 Miscellaneous Water Revenues(antenna,interest) $ 221,000.00 $ 240,500.00 $ 268,500.00 $ 286,300.00 $ 289,800.00 $ 293,300.00 $ 296,800.00 $ 300,300.00 $ 303,800.00 $ 307,300.00 $ 310,800.00 $ 314,300.00 38 39 Total Usage Revenue(excluding surcharge) $ 1,817,713.47 $ 1,682,505.00 $ 1,966,702.52 $ 2,125,033.41 $ 2,289,772.11 $ 2,452,353.76 $ 2,628,029.06 $ 2,817,818.59 $ 3,022,817.67 $ 3,244,201.59 $ 3,483,231.11 $ 3,741,258.40 $ 4,019,733.33 39 40 100's-Salaries and Benefits(4%)(add 2 pos.in 2017) $ 426,800.00 $ 438,768.00 $ 443,300.00 $ 456,000.00 $ 474,300.00 $ 673,300.00 $ 700,300.00 $ 728,400.00 $ 757,600.00 $ 788,000.00 $ 819,600.00 $ 852,400.00 $ 886,500.00 40 41 200's-Office Materials and Supplies $ 24,900.00 $ 15,133.00 $ 24,600.00 $ 24,600.00 $ 25,400.00 $ 26,200.00 $ 27,000.00 $ 27,900.00 $ 28,800.00 $ 29,700.00 $ 30,600.00 $ 31,600.00 $ 32,600.00 41 42 216.00-Chemicals(tied to pop growth) $ 65,000.00 $ 58,454.00 $ 70,000.00 $ 70,000.00 $ 72,400.00 $ 74,900.00 $ 77,500.00 $ 80,200.00 $ 83,000.00 $ 85,900.00 $ 88,900.00 $ 92,000.00 $ 95,200.00 42 43 220.01 -Water Meter Purchases(replacements) $ 10,000.00 $ 43,441.00 $ 40,000.00 $ 45,000.00 $ 40,000.00 $ 45,000.00 $ 45,000.00 $ 45,000.00 $ 45,000.00 $ 45,000.00 $ 45,000.00 $ 45,000.00 $ 45,000.00 43 44 220.02-Water Meter Purchases(new homes) $ 30,000.00 $ 61,704.00 $ 40,000.00 $ 68,000.00 $ 85,800.00 $ 89,300.00 $ 92,800.00 $ 96,300.00 $ 99,800.00 $ 103,300.00 $ 106,800.00 $ 110,300.00 $ 113,800.00 44 45 300's-GIS,Legal,Office,Computer,Eng,Prof Svcs $ 157,100.00 $ 155,024.00 $ 154,700.00 $ 169,200.00 $ 174,300.00 $ 179,600.00 $ 185,000.00 $ 190,600.00 $ 196,400.00 $ 202,300.00 $ 208,400.00 $ 214,700.00 $ 221,200.00 45 46 400's-Training,Conferences,Contracted Repair $ 27,100.00 $ 46,683.00 $ 56,200.00 $ 79,025.00 $ 81,400.00 $ 83,900.00 $ 86,500.00 $ 89,100.00 $ 91,800.00 $ 94,600.00 $ 97,500.00 $ 100,500.00 $ 103,600.00 46 47 500's-Buildings,Inspections,Purchases,Furniture $ 16,600.00 $ 597.00 $ 16,600.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 $ 22,200.00 47 Expenses 48 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 48 49 530.04-Well and Tower Maintenance(long-term schedule) $ 150,000.00 $ - $ 37,000.00 $ 320,000.00 $ 323,000.00 $ 526,500.00 $ 26,500.00 $ 546,000.00 $ 328,500.00 $ 528,500.00 $ 525,000.00 $ 329,000.00 $ 29,000.00 49 50 710.00-Transfers for Other Improvements $ 139,194.00 $ 139,194.00 $ - $ - $ - $ 415,400.00 $ - $ - $ - $ - $ - $ - $ - 50 51 Utility Equipment Purchases(from CIP) $ - $ - $ - $ - $ 40,834.00 $ - $ - $ 71,300.00 $ - $ - $ - $ 27,500.00 $ - 51 52 Well and Tower Expenses(combined) $ 272,800.00 $ 240,500.00 $ 264,200.00 $ 282,100.00 $ 290,600.00 $ 299,300.00 $ 308,300.00 $ 317,500.00 $ 327,000.00 $ 336,800.00 $ 346,900.00 $ 357,300.00 $ 368,000.00 52 53 WTP Operating Expenses $ - $ - $ - $ - $ 50,000.00 $ 50,000.00 $ 50,000.00 $ 50,000.00 $ 50,000.00 $ 50,000.00 $ 50,000.00 $ 50,000.00 $ 50,000.00 53 54 WTP Debt Service$12,000,000 15 years @ 4.0% $ - $ - $ - $ - $ 1,098,200.00 $ 1,098,200.00 $ 1,098,800.00 $ 1,098,400.00 $ 1,097,000.00 $ 1,097,000.00 $ 1,097,000.00 $ 1,097,000.00 $ 1,097,000.00 54 55 Total Expenses $ 1,469,494.00 $ 1,199,498.00 $ 1,296,600.00 $ 1,680,525.00 $ 2,923,334.00 $ 3,729,300.00 $ 2,866,000.00 $ 3,509,600.00 $ 3,274,400.00 $ 3,531,200.00 $ 3,586,500.00 $ 3,478,800.00 $ 3,214,100.00 55 56 Year End Balance(before debt service) $ 4,471,584.66 $ 5,410,510.77 $ 5,855,019.19 $ 5,221,457.29 $ 3,944,511.05 $ 3,706,540.12 $ 3,014,758.71 $ 2,763,176.38 $ 2,476,177.97 $ 2,372,909.08 $ 2,635,367.47 $ 3,441,000.80 56 57 Balance change amount $ 348,219.47 $ 670,102.52 $ 444,508.41 $ (633,561.89) $ (1,276,946.24) $ (237,970.94) $ (691,781.41) $ (251,582.33) $ (286,998.41) $ (103,268.89) $ 262,458.40 $ 805,633.33 57 58 Balance change% 8.45% 14.14% 8.22% -10.82% -24.46% -6.03% -18.66% -8.35% -10.39% -4.17% 11.06% 30.57% 58 G:\Utilities\Rates\Water Rates 20140606 Debt Service Impact Description 2013 Projected 2013 Actual 2014 Projected 2015 Budgeted 2016 2017 2018 2019 2020 2021 2022 2023 2024 59 Water Core Fund Beginning Balance $ 483,465.83 $ 355,453.81 $ 431,953.81 $ 431,953.81 $ 484,828.81 $ 774,453.81 $ 1,350,828.81 $ 1,948,953.81 $ 2,568,828.81 $ 3,210,453.81 $ 3,873,828.81 $ 4,558,953.81 59 60 Water Core Fund Revenue from New Connections $ 280,575.00 $ 391,500.00 $ 445,875.00 $ 532,875.00 $ 554,625.00 $ 576,375.00 $ 598,125.00 $ 619,875.00 $ 641,625.00 $ 663,375.00 $ 685,125.00 $ 706,875.00 60 61 Capital Investment Fund Beginning Balance $ 298,765.19 $ 329,589.00 $ 330,325.00,$ 598,350.16 $ 919,332.08 $ 1,250,519.88 $ 1,592,288.20 $ 1,945,012.21 $ 2,309,067.61 $ 2,684,830.68 $ 3,072,678.26 $ 3,472,987.74 61 62 Water Surcharge-Single Family 5/8"(95%) $ 223,379.20 $ 229,398.40 $ 236,253.60_ $ 244,446.40 $ 252,973.60 $ 261,835.20 $ 271,031.20 $ 280,561.60 $ 290,426.40 $ 300,625.60 $ 311,159.20 $ 322,027.20 62 63 Capital Water Surcharge-Multi Family 5/8"(5%) $ 9,084.80 $ 9,329.60 $ 9,608.40 $ 9,941.60 $ 10,288.40 $ 10,648.80 $ 11,022.80 $ 11,410.40 $ 11,811.60 $ 12,226.40 $ 12,654.80 $ 13,096.80 63 Investment Fund 64 Revenue Water Surcharge-1"(inc.2%/year) $ 39,906.00 $ 40,824.00 $ 41,640.48 $ 42,473.29 $ 43,322.76 $ 44,189.21 $ 45,072.99 $ 45,974.45 $ 46,893.94 $ 47,831.82 $ 48,788.46 $ 49,764.23 64 65 Water Surcharge-1.5"(inc.2%/year) $ 23,072.00 $ 23,184.00 $ 23,647.68 $ 24,120.63 $ 24,603.05 $ 25,095.11 $ 25,597.01 $ 26,108.95 $ 26,631.13 $ 27,163.75 $ 27,707.03 $ 28,261.17 65 66 Total Water Surcharge Revenue $ 295,442.00 $ 302,736.00 $ 311,150.16 $ 320,981.92 $ 331,187.80 $ 341,768.32 $ 352,724.00 $ 364,055.40 $ 375,763.07 $ 387,847.57 $ 400,309.49 $ 413,149.39 66 67 Estimated Debt Service $ 735,000.00 $ 735,000.00 $ 617,000.00 $ 489,000.00 $ 480,000.00 $ 265,000.00 $ - $ - $ - $ - $ - $ - $ - 67 68 Debt Service Capital Investment Fund Contribution to Debt Service $ 270,000.00 $ 270,000.00 $ 302,000.00 $ 43,125.00 $ - $ - $ - $ - $ - $ - $ - $ - $ - 68 69 Water Core Fund Contribution to Debt Service $ 465,000.00 $ 465,000.00 $ 315,000.00 $ 445,875.00 $ 480,000.00 r$ 265,000.00 $ - $ - $ - $ - $ - $ - $ - 69 70 Water Utility Fund Contribution to Debt Service $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 70 71 Capital Investment Fund Year End Balance $ 324,207.19 $ 329,589.00 $ 330,325.00 $ 598,350.16 $ 919,332.08 $ 1,250,519.88 $ 1,592,288.20 $ 1,945,012.21 $ 2,309,067.61 $ 2,684,830.68 $ 3,072,678.26 $ 3,472,987.74 $ 3,886,137.14 71 Year End Fund 72 Balances Water Core Fund Year End Balance $ 299,040.83 $ 355,453.81 $ 431,953.81 $ 431,953.81 $ 484,828.81 $ 774,453.81 $ 1,350,828.81 $ 1,948,953.81 $ 2,568,828.81 $ 3,210,453.81 $ 3,873,828.81 $ 4,558,953.81 $ 5,265,828.81 72 73 Water Utility Fund Year End Balance _ $ 4,471,584.66 $ 5,040,408.25 $ 5,410,510.77 $ 5,855,019.19 $ 5,221,457.29 $ 3,944,511.05 $ 3,706,540.12 $ 3,014,758.71 $ 2,763,176.38 $ 2,476,177.97 $ 2,372,909.08 $ 2,635,367.47_ $ 3,441,000.80 73 G1Utilities\Rates\Water Rates 20140606 Sanitary Sewer Rate Analysis Description 2013 Projected 2013 Actual 2014 Projected 2015 Budgeted 2016 2017 2018 2019 2020 2021 2022 2023 2024 1 Water Demand(MG) 992.66 880.61 902.80 929.91 962.06 995.48 1,030.15 1,066.09 1,103.28 1,141.74 1,181.46 1,222.44 1,264.68 1 2 Q1 Water Demand(MG)(-14%of total demand) 138.97 124.67 126.39 130.19 134.69 139.37 144.22 149.25 154.46 159.84 165.40 171.14 177.06 2 3 Projected Sanitary Sewer Flows(MG)* 520.68 509.10 533.80 549.83 568.84 588.60 609.10 630.35 652.34 675.08 698.56 722.79 747.77 3 Demands and - 4 Connections Estimated Growth(from water spreadsheet) 2.0% 2.3% 2.5% 3.0% 3.5% 3.5% 3.5% 3.5% 3.5% 3.5% 3.5% 3.5% 3.5% 4 5 Residential Accounts(includes multi-family) 6,680 6,693 6,860 7,065 7,310 7,565 7,830 8,105 8,390 8,685 8,990 9,305 9,630 5 6 Commercial/Ind/Inst Accounts 175 175 180 185 190 195 200 205 210 215 220 221 221 6 7 Sanitary Sewer Fixed Charge($/account/quarter) $ 22.00 $ 22.00 $ 22.50 $ 23.00 $ 23.50 $ 24.00 $ 24.50 $ 25.00 $ 25.50 $ 26.00 $ 26.50 $ 27.00 $ 27.50 7 Projected Rates 8 Usage Rates Per 1000 Gal(2%inc.starting in 2014) $ 1.66 $ 1.66 $ 1.69 $ 1.73 $ 1.76 $ 1.80 $ 1.83 $ 1.87 $ 1.91 $ 1.95 $ 1.99 $ 2.03 $ 2.07 8 10 602 49450 Sewer Utility Fund Beginning Balance $ 2,053,272.12 $ 2,053,272.12 $ 2,055,825.50 $ 1,585,340.83 $ 1,641,775.56 $ 1,687,619.79 $ 1,116,222.06 $ 1,090,044.76 $ 1,157,394.07 $ 1,289,825.08 $ 1,461,450.15 $ 1,674,777.37 $ 1,904,608.15 10 11 CRP and Equipment Replacement Reserve $ 150,000.00 $ - $ 327,500.00 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 11 12 Available Sewer Utility Fund Beginning Balance $ 1,903,272.12 $ 2,053,272.12 $ 1,728,325.50 $ 1,585,340.83 $ 1,641,775.56 $ 1,687,619.79 $ 1,116,222.06 $ 1,090,044.76 $ 1,157,394.07 $ 1,289,825.08 $ 1,461,450.15 $ 1,674,777.37 $ 1,904,608.15 12 16 Fixed Charges $ 603,240.00 $ 633,600.00 $ 667,000.00 $ 705,000.00 $ 744,960.00 $ 786,940.00 $ 831,000.00 $ 877,200.00 $ 925,600.00 $ 976,260.00 $ 1,028,808.00 $ 1,083,610.00 16 17 Revenue Sewer Use Charges(-72%of water demand billed) $ 1,105,119.55 $ 1,101,686.66 $ 1,157,463.39 $ 1,221,433.84 $ 1,289,132.98 $ 1,360,717.00 $ 1,436,347.55 $ 1,516,191.83 $ 1,600,422.78 $ 1,689,219.29 $ 1,782,766.35 $ 1,881,255.22 17 18 Miscellaneous Revenue(-10%of usage revenue) $ 170,835.96 $ 173,528.67 $ 182,446.34 $ 192,643.38 $ 203,409.30 $ 214,765.70 $ 226,734.76 $ 239,339.18 $ 252,602.28 $ 266,547.93 $ 281,157.43 $ 296,486.52 18 19 Total Revenue $ 1,879,195.51 $ 1,707,729.00 $ 1,908,815.33 $ 2,006,909.73 $ 2,119,077.23 $ 2,237,502.27 $ 2,362,422.70 $ 2,494,082.31 $ 2,632,731.01 $ 2,778,625.06 $ 2,932,027.22 $ 3,092,731.78 $ 3,261,351.75 19 25 100's-Salaries and Benefits(4%)(add 1 pos.in 2017) $ 427,300.00 $ 438,599.00 $ 443,800.00 $ 456,500.00 $ 474,800.00 $ 583,800.00 $ 607,200.00 $ 631,500.00 $ 656,800.00 $ 683,100.00 $ 710,500.00 $ 739,000.00 $ 768,600.00 25 26 200's-Materials and Equipment $ 13,800.00 $ 6,183.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 26 27 300's-Communications,Computer,Eng,Prof Svcs $ 89,800.00 $ 70,076.00 $ 92,700.00 $ 112,700.00 $ 116,100.00 $ 119,600.00 $ 123,200.00 $ 126,900.00 $ 130,800.00 $ 134,800.00 $ 138,900.00 $ 143,100.00 $ 147,400.00 27 28 400's-Training,Conferences,Contracted Repair,Misc $ 11,000.00 $ 4,495.00 $ 11,800.00 $ 11,475.00 $ 11,900.00 $ 12,300.00 $ 12,700.00 $ 13,100.00 $ 13,500.00 $ 14,000.00 $ 14,500.00 $ 15,000.00 $ 15,500.00 28 29 500's-Buildings,Machinery,Furniture,Equipment $ 21,000.00 $ 31.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 29 30 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,000.00 $ 150,001.00 $ 150,001.00 30 31 602-Sewer Service Charges(5%per year starting 2014) $ 1,030,000.00 $ 1,007,195.00 $ 1,090,300.00 $ 1,144,900.00 $ 1,202,200.00 $ 1,262,400.00 $ 1,325,600.00 $ 1,391,900.00 $ 1,461,500.00 $ 1,534,600.00 $ 1,611,400.00 $ 1,692,000.00 $ 1,776,600.00 31 32 611 -Interest on Lease Payments $ - $ 2,538.00 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 32 33 710.00-Transfers for Other Improvements $ 116,948.00 $ 116,948.00 $ - $ - $ - $ 600,900.00 $ - $ - $ - $ - $ - $ - $ - 33 34 Utility Equipment Purchases(from CIP) $ - $ - $ 177,500.00 $ - $ 40,833.00 $ - $ 87,500.00 $ 28,333.00 $ - $ - $ - $ 27,500.00 $ - 34 35 Lift Station Expenses $ 39,300.00 $ 30,820.00 $ 50,900.00 $ 40,100.00 $ 41,400.00 $ 42,700.00 $ 44,000.00 $ 45,400.00 $ 46,800.00 $ 48,300.00 $ 49,800.00 $ 51,300.00 $ 52,900.00 35 36 Total Expenses $ 1,899,148.00 $ 1,676,885.00 $ 2,051,800.00 $ 1,950,475.00 $ 2,073,233.00 $ 2,808,900.00 $ 2,388,600.00 $ 2,426,733.00 $ 2,500,300.00 $ 2,607,000.00 $ 2,718,700.00 $ 2,862,901.00 $ 2,957,501.00 36 37 Year End Balance $ 1,883,319.63 $ 2,055,825.50 $ 1,585,340.83 $ 1,641,775.56 $ 1,687,619.79 $ 1,116,222.06 $ 1,090,044.76 $ 1,157,394.07 $ 1,289,825.08 $ 1,461,450.15 $ 1,674,777.37 $ 1,904,608.15 $ 2,208,458.90 37 38 Balance change $ (19,952.49) $ 2,553.38 $ (142,984.67) $ 56,434.73 $ 45,844.23 $ (571,397.73) $ (26,177.30) $ 67,349.31 $ 132,431.01 $ 171,625.06 $ 213,327.22 $ 229,830.78 $ 303,850.75 38 39 %change -1.05% 0.12% -8.27% 3.56% 2.79% -33.86% -2.35% 6.18% 11.44% 13.31% 14.60% 13.72% 15.95% 39 *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 $1.97838 Percent change from previous year 4.376% G:\Utilities\Rates\Sewer Rates 20140606 Model Page One 2015 BUDGET WORKSHEETS WATER UTILITY -REVENUES- August 11,2014 2014 2015 Object 2015 2011 2012 2013 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 601 33425.00 Other State Grants&Aids $0 $19,960 $0 $0 $0 601 34108.00 Administrative Fees-Other Funds 2,123 5,733 2,497 0 0 5%of 5%Fees-Const Projects 601 34109.00 Other Gen'l Govt Chgs for Services 0 14,000 12,250 0 0 601 36101.00 Principal-Special Assessments 54,354 59,342 55,362 50,000 55,000 601 36102.00 Penalties&Interest-S/A (5,989) (3,093) 224 0 0 601 36210.00 Interest Earnings-Investments 60,496 60,556 57,119 60,000 55,000 601 36214.00 Net Change in FV-Investments 3,794 5,131 (125,524) 0 0 Annual Market Value Changes 601 36215.00 Interest Earnings 1,280 427 70 500 500 601 36220.00 Rents&Royalties 80,745 84,223 88,052 90,000 90,000 Antenna Leases 601 36260.00 Other Revenues 750 0 128 0 0 601 36265.00 Use of Reserve Funds 0 0 0 0 45,900 601 37110.00 Residential Water Revenues 1,079,507 1,258,104 1,155,429 1,200,000 1,100,000 601 37120.00 Apartment Water Revenues 75,444 79,934 83,470 75,000 80,000 601 37125.00 Institutional Water Revenues 70,470 87,847 70,541 75,000 70,000 601 37130.00 Commercial Water Revenues 71,131 84,393 79,091 70,000 75,000 601 37140.00 Industrial Water Revenues 73,851 70,693 123,072 70,000 70,000 601 37160.00 Penalties-Water Revenues 9,378 10,470 9,896 8,000 9,000 601 37165.00 Meter Maint Water Revenues 0 0 0 0 0 601 37170.00 Other Water Revenues 0 0 0 0 0 601 37180.00 Water Meter Sales Revenue 27,498 42,497 46,529 35,000 40,000 601 39103.00 Gain or Loss from F/A Disposal (1,532) (739) (144) 0 0 601 39203.00 Transfer From 0 0 24,443 0 0 FUND TOTALS $1,603,302 $1,879,477 $1,682,505 $1,733,500 $1,690,400 Page One 2015 BUDGET WORKSHEETS WATER UTILITY -EXPENDITURES- August 11,2014 2014 2015 Object 2015 2011 2012 2013 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 601 49400 101.00 Salaries&Benefits $437,200 Salary,Taxes,PERA&Benefits 601 49400 77 101.00 Administrative 110,344 120,763 117,500 112,900 116,100 601 49400 78 101.00 Technical/Clerical 136,304 144,153 142,778 148,800 154,300 601 49400 79 101.00 Maintenance 138,854 146,589 157,164 165,600 166,800 601 49400 xx 101.00 Salary&Benefit Contingency 0 0 0 0 0 601 49400 102.00 Full-Time Overtime 9,378 7,794 15,629 8,000 8,000 601 49400 103.00 Part-Time Salaries&Benefits 6,289 6,112 5,697 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 1,196 2,260 1,742 2,000 2,000 Inserts&Water Bill Statements 601 49400 01 209.00 Other Office Supplies 238 749 1,459 200 200 601 49400 01 216.00 Chemicals&Chemical Products 59,746 66,610 58,454 70,000 70,000 Chlorine,Flouride,Polyphos 601 49400 01 219.00 Other Operating Supplies 465 97 331 200 200 Maintenance Supplies 601 49400 01 220.00 Water Meter Purchases 113,000 Meters,MIU's&CU Horns 601 49400 01 220.01 For Replacements 0 0 43,441 40,000 45,000 New Meter Standards 601 49400 01 220.02 For New Homes 23,283 46,600 61,704 40,000 68,000 Water Rate Model(3%Growth) 601 49400 01 224.00 Street Maintenance Materials 3,720 637 0 2,500 2,500 Patching for Breaks 601 49400 01 225.00 Landscaping Materials 279 208 845 500 500 Topsoil,Seed&Sod 601 49400 01 228.00 Meter Repair Materials 0 0 29 0 0 601 49400 01 229.00 Other Maintenance Supplies 14,200 601 49400 01 229.01 Supplies for Hydrants 5,849 4,599 3,332 6,000 6,000 601 49400 01 229.02 Curb Shutoffs 554 1,097 565 1,000 1,000 601 49400 01 229.03 GV Repair/Replacement 0 2,574 0 2,200 2,200 Repairs Done By City Staff 601 49400 01 229.04 Miscellaneous Supplies 4,626 4,438 3,355 5,000 5,000 601 49400 01 241.00 Small Tools 1,513 1,792 614 2,000 2,000 Wrenches,Shovels,etc. 601 49400 01 242.00 Minor Equipment 2,095 609 2,860 3,000 3,000 601 49400 01 303.00 Engineering Fees 30,000 601 49400 01 303.01 WHPP 0 474 0 5,000 5,000 Groundwater Plan Implementation 601 49400 01 303.02 GIS 0 2,539 516 5,000 5,000 601 49400 01 303.03 Rate Study 0 0 0 7,500 0 601 49400 01 303.04 Miscellaneous Fees 40,828 28,450 20,093 20,000 20,000 601 49400 01 304.00 Legal Fees 94 1,269 0 1,000 1,000 601 49400 01 310.00 Testing Services 46,500 601 49400 01 310.01 Bacteria&Water Quality 1,734 1,560 1,585 2,000 2,500 Radon,Tri-Chl.,Pesticides,Etc. 601 49400 01 310.02 V.O.C.,Pesticides,etc. 1 0 0 1,000 0 601 49400 01 310.03 MDH Service Connection Fee 40,901 41,623 43,149 41,000 44,000 $6.36/Connection-Annual Fee 601 49400 01 312.00 Gopher State One-Call 2,098 2,559 2,303 3,500 2,500 601 49400 01 313.00 Temporary Service Fees 23,401 6,190 0 0 0 601 49400 01 318.00 Contract Engineer 7,000 8,000 10,000 7,000 25,000 601 49400 01 319.00 Other Professional Services 23,100 601 49400 01 319.01 Thaw Pipes,Check Leaks,etc. 200 311 0 1,500 1,500 601 49400 01 319.02 Supervisory Controls 3,015 910 15,648 5,000 5,000 SCADA 601 49400 01 319.03 Hazardous Chemical Permits 0 725 725 1,000 1,000 MN Department of Public Safety 601 49400 06 319.06 Contracted Hydrant Painting 9,800 9,922 10,004 10,000 10,000 120 Hydrants/Yr($82 each) 601 49400 01 319.07 Antenna Expenses 0 0 12,563 0 0 601 49400 01 319.08 Buxton Project 0 0 0 0 5,600 601 49400 01 320.00 Credit Card Activity Fees 0 0 3,324 2,000 3,000 1/3 Cost of C/C Pymt Processing 601 49400 01 321.00 Telephone Costs 2,354 2,646 2,745 2,500 3,000 Cell Phones,Modesm,GPS 601 49400 01 322.00 Postage Costs 4,504 4,678 4,556 5,000 5,000 Billings with Inserts 601 49400 01 323.00 Radio Units 1,211 1,116 1,045 1,500 1,500 24 Units*$300(Split 5 Ways) 601 49400 01 352.00 General Notices&Public Info 0 78 0 0 0 601 49400 01 365.00 Workers Comp Insurance 7,089 6,807 6,990 7,000 7,000 Water's Share of Premiums 601 49400 01 369.00 Other Insurance 10,487 10,746 6,181 12,000 12,000 Water's Share of Premiums 601 49400 01 391.00 P.C.Maintenance 491 2,700 601 49400 01 391.01 U/B Software Maintenance 0 1,827 2,081 2,000 2,000 Added to Utility Budgets in 2012 601 49400 01 391.02 Auto Read Software Support 0 585 585 700 700 Added to Utility Budgets in 2012 601 49400 01 392.00 P.C.Accessories&Supplies 128 0 0 200 200 601 49400 01 393.00 P.C.Hardware Purchases 320 1,637 4,093 3,000 12,000 Replace SCADA Hardware/Software 601 49400 01 394.00 P.C.Software Purchases 4,574 7,200 601 49400 01 394.01 Licensing&Maintenance 0 4,843 4,279 6,500 6,200 Cartegraph,GIS 601 49400 01 394.02 Online Subscriptions 0 308 286 800 800 Pictometry 601 49400 01 394.03 New Software Purchases 0 7,868 2,271 500 200 601 49400 01 395.00 P.C.Repairs 0 0 0 500 0 PAGE TOTALS 664,963 705,356 772,524 772,600 842,500 Page Two 2015 BUDGET WORKSHEETS WATER UTILITY -EXPENDITURES- August 11,2014 2014 2015 Object 2015 2011 2012 2013 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 601 49400 01 403.00 Contracted R&M-Other Impr 10,544 22,113 30,845 6,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 45 73 25 400 200 Suburban Utility Supt Assn 601 49400 01 435.00 Books&Pamphlets 0 23 0 300 200 Reference Materials 601 49400 01 437.00 Conferences&Seminars 3,800 601 49400 01 437.01 MDH Training(Water School) 588 755 816 2,000 1,500 Operator Licensure 601 49400 01 437.02 AWWA Conference 0 0 0 0 0 601 49400 01 437.03 CarteGraph,ESRI,GIS 157 270 370 1,500 1,300 User Group,Conference,Training 601 49400 01 437.04 Miscellaneous Training 0 0 0 1,000 1,000 601 49400 01 439.00 Other Miscellaneous Charges 15,235 16,646 14,627 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 475,600 601 49400 01 530.01 Well Inspections 560 560 490 600 600 601 49400 01 530.02 Miscellaneous Improvements 0 1,050 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 0 20,000 0 245,000 320,000 From Long-Term Project Schedule 601 49400 01 570.00 Office Equipment Purchases 0 58 107 1,000 1,000 601 49400 01 611.00 Interest on Lease Payments 3,232 2,893 2,538 0 0 P.W.Building Expansion(See 521) 601 49400 01 710.00 Transfers 298,666 200,000 139,194 0 0 Transfers for Other Improvements 601-49400-01 TOTALS 993,990 969,797 961,537 1,240,400 1,408,300 601 49406 01 221.00 Equipment Parts 512 0 0 500 500 601 49406 01 223.00 Building Repair Supplies 0 0 0 200 200 601 49406 01 319.00 Other Professional Services 0 0 0 1,000 1,000 601 49406 01 381.00 Electric Utilities 1,304 995 1,045 1,300 1,300 Pumping&Lighting TOTAL-PRV 1,816 995 1,045 3,000 3,000 601 49407 01 221.00 Equipment Parts 779 5,968 1,401 500 1,500 601 49407 01 223.00 Building Repair Supplies 0 0 0 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 18,322 21,934 23,667 30,000 33,000 Pumping,Lighting,Tower Mixer 601 49407 01 409.00 Other Contracted Repairs&Maint 3,741 0 6,000 1,000 2,000 $800 for Lights in 2015 601 49407 01 439.00 Other Miscellaneous Charges 100 0 37 100 100 Contingencies 601 49407 01 530.00 Improvements Other Than Bldgs 3,219 101 0 0 0 TOTAL-WELL#7 26,370 28,213 31,316 32,100 37,100 601 49408 01 221.00 Equipment Parts 2,390 2,024 1,342 500 1,500 601 49408 01 223.00 Building Repair Supplies 0 15 0 200 200 601 49408 01 319.00 Other Professional Services 0 0 0 0 0 601 49408 01 381.00 Electric Utilities 14,969 21,917 23,841 25,000 25,000 Pumping&Lighting 601 49408 01 383.00 Gas Utilities 468 428 470 600 600 Heat Only 601 49408 01 409.00 Other Contracted Repairs&Maint 0 0 5,952 20,000 2,000 $800 for Lights in 2015 601 49408 01 439.00 Other Miscellaneous Charges 100 0 0 100 100 Contingencies 601 49408 01 530.00 Improvements Other Than Bldgs 1,809 0 0 0 0 _-- --- _---- ----------------- TOTAL-WELL#8 19,736 24,385 31,605 46,400 29,400 601 49409 01 221.00 Equipment Parts 1,009 3,955 2,831 1,000 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 27,268 25,692 16,618 35,000 30,000 Pumping&Lighting 601 49409 01 383.00 Gas Utilities 547 627 795 1,500 1,500 Heat Only 601 49409 01 409.00 Other Contracted Repairs&Maint 0 0 837 1,000 2,000 $800 for Lights in 2015 601 49409 01 439.00 Other Miscellaneous Charges 100 259 0 100 100 Contingencies 601 49409 01 530.00 Improvements Other Than Bldgs 1,809 101 21,907 1,000 0 TOTAL-WELL#9 30,732 30,633 -42,988 39,800 35,300 Page Three 2015 BUDGET WORKSHEETS WATER UTILITY -EXPENDITURES- August 11,2014 2014 2015 Object 2015 2011 2012 2013 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 601 49410 01 219.00 Other Operating Supplies 0 1 0 500 500 601 49410 01 221.00 Equipment Parts 1,469 1,062 4,434 1,000 1,000 601 49410 01 223.00 Building Repair Supplies 9 0 213 200 200 601 49410 01 321.00 Telephone Costs 765 765 765 0 0 Removing Phone Line in 2013 601 49410 01 381.00 Electric Utilities 12,489 13,189 16,623 15,000 17,000 Pumping&Lighting 601 49410 01 409.00 Other Contracted Repairs&Maint 0 1,703 9,957 500 2,000 $800 for Lights in 2015 601 49410 01 439.00 Other Miscellaneous Charges 50 0 0 100 100 Contingencies 601 49410 01 530.00 Improvements Other Than Bldgs 0 0 10,014 0 0 TOTAL-WELL#10 14,782 16,720 42,005 17,300 20,800 Rural Water System 601 49411 01 221.00 Equipment Parts 1,565 0 0 0 0 601 49411 01 439.00 Other Miscellaneous Charges 50 0 0 0 0 TOTAL-WELL#11 1,615 0 0 0 0 Rural Water System(#2) 601 49412 01 221.00 Equipment Parts 1,134 1,847 0 1,000 1,500 601 49412 01 223.00 Building Repair Supplies 0 10 0 200 200 601 49412 01 319.00 Other Professional Services 0 0 0 0 0 601 49412 01 381.00 Electric Utilities 19,190 22,444 23,242 30,000 30,000 Pumping&Lighting 601 49412 01 409.00 Other Contracted Repairs&Maint 6,101 278 1,495 1,000 2,000 $800 for Lights in 2015 601 49412 01 439.00 Other Miscellaneous Charges 100 0 0 100 100 Contingencies TOTAL-WELL#12 26,525 24,578 24,737 32,300 33,800 601 49414 01 221.00 Equipment Parts 1,104 1,063 0 500 1,500 601 49414 01 223.00 Building Repair Supplies 0 0 0 200 200 601 49414 01 319.00 Other Professional Services 0 1,097 0 1,000 1,000 601 49414 01 381.00 Electric Utilities 29,008 24,193 27,051 30,000 30,000 Pumping&Lighting 601 49414 01 409.00 Other Contracted Repairs&Maint 2,138 0 883 7,000 2,000 $800 for Lights in 2015 601 49414 01 439.00 Other Miscellaneous Charges 100 0 0 100 100 Contingencies 601 49414 01 530.00 Improvements Other Than Bldgs 0 0 0 1,000 0 TOTAL-WELL#14 32,349 26,353 27,934 39,800 34,800 601 49425 01 221.00 Equipment Parts 1,096 3,629 575 500 1,500 601 49425 01 223.00 Building Repair Supplies 0 0 0 200 200 601 49425 01 319.00 Other Professional Services 353 0 0 500 500 601 49425 01 381.00 Electric Utilities 25,190 23,461 26,071 30,000 30,000 Pumping&Lighting 601 49425 01 409.00 Other Contracted Repairs&Maint 0 0 1,526 500 2,000 $800 for Lights in 2015 601 49425 01 439.00 Other Miscellaneous Charges 48 185 0 100 100 Contingencies 601 49425 01 530.00 Improvements Other Than Bldgs 0 0 0 0 0 TOTAL-WELL#15 26,687 27,276 28,172 31,800 34,300 601 49426 01 221.00 Equipment Parts 0 0 0 0 1,500 601 49426 01 223.00 Building Repair Supplies 0 0 0 0 200 601 49426 01 319.00 Other Professional Services 0 0 0 0 500 601 49426 01 381.00 Electric Utilities 0 0 0 0 30,000 Pumping&Lighting 601 49426 01 383.00 Gas Utilities 0 0 0 0 1,000 May Be Electric Only(TBD) 601 49426 01 409.00 Other Contracted Repairs&Maint 0 0 0 0 1,000 601 49426 01 439.00 Other Miscellaneous Charges 0 0 0 0 100 Contingencies 601 49426 01 530.00 Improvements Other Than Bldgs 0 0 0 0 0 TOTAL-WELL#16 0 0 0 0 34,300 Page Four 2015 BUDGET WORKSHEETS WATER UTILITY -EXPENDITURES- August 11,2014 2014 2015 Object 2015 2011 2012 2013 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 601 49415 01 221.00 Equipment Parts 122 0 0 500 500 Touch-up Paint 601 49415 01 319.00 Other Professional Services 0 0 0 0 0 601 49415 01 409.00 Other Contracted Repairs&Maint 0 0 0 500 500 601 49415 01 439.00 Other Miscellaneous Charges 100 0 0 200 200 Contingencies 601 49415 01 530.00 Improvements Other Than Bldgs 0 0 0 0 0 TOTAL-WATER TOWER#1 222 0 0 1,200 1,200 (Chippendale Water Tower) 601 49416 01 221.00 Equipment Parts 2,500 0 12 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 712 429 1,338 1,400 4,500 New Water Mixers in 2014 601 49416 01 409.00 Other Contracted Repairs&Maint 2,945 0 0 500 500 601 49416 01 439.00 Other Miscellaneous Charges 0 0 0 200 200 Contingencies 601 49416 01 530.00 Improvements Other Than Bldgs 0 0 0 0 0 TOTAL-WATER TOWER#2 6,158 429 1,350 2,600 5,700 (Connemara Water Tower) 601 49417 01 221.00 Equipment Parts 4,261 0 0 500 500 601 49417 01 319.00 Other Professional Services 0 0 0 0 0 601 49417 01 381.00 Electric Utilities 4,267 5,345 5,374 6,000 6,000 601 49417 01 409.00 Other Contracted Repairs&Maint 122 0 0 7,000 500 601 49417 01 439.00 Other Miscellaneous Charges 0 0 96 200 200 Contingencies 601 49417 01 530.00 Improvements Other Than Bldgs 0 0 0 0 0 TOTAL-WATER TOWER#4 8,651 5,345 5,470 13,700 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 0 3,800 0 0 0 601 49418 01 381.00 Electric Utilities 1,648 1,885 3,359 3,000 4,000 New Water Mixers in 2014 601 49418 01 409.00 Other Contracted Repairs&Maint 0 792 519 500 500 601 49418 01 439.00 Other Miscellaneous Charges 0 28 0 200 200 Contingencies 601 49418 01 530.00 Improvements Other Than Bldgs 0 0 0 0 0 -- ---------------------------------------- TOTAL-WATER TOWER#3 1,648 6,505 3,878 4,200 5,200 (East Side Water Tower) GRAND TOTAL-ALL DEPTS. $1,191,281 $1,161,229 $1,202,036 $1,504,600 $1,690,400 Page One 2015 BUDGET WORKSHEETS SEWER UTILITY -REVENUES- August 11,2014 2014 2015 Object 2015 2011 2012 2013 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 602 33425.00 Other State Grants&Aids $0 $0 $0 $0 $0 602 34108.00 Administrative Fees-Other Funds 2,123 5,733 2,497 0 0 5%of 5%Fees-Const Projects 602 36101.00 Principal-Special Assessments 77,214 192,425 98,077 80,000 90,000 602 36102.00 Penalties&Interest-S/A 2,775 1,783 327 0 0 602 36210.00 Interest Earnings-Investments 40,077 24,678 17,042 25,000 15,000 602 36214.00 Net Change in FV-Investments 3,447 725 (8,621) 0 0 Annual Market Value Changes 602 36215.00 Interest Earnings 282 240 76 500 500 602 36260.00 Other Revenues 2,212 0 0 0 0 602 36265.00 Use of Reserve Funds 0 0 0 323,800 291,300 602 37210.00 Residential Sewer Revenues 1,135,626 1,274,698 1,278,008 1,200,000 1,300,000 602 37220.00 Apartment Sewer Revenues 101,697 106,160 114,024 100,000 105,000 602 37225.00 Institutional Sewer Revenues 22,231 23,868 24,238 23,000 24,000 602 37230.00 Commercial Sewer Revenues 63,367 65,411 72,645 65,000 68,000 602 37240.00 Industrial Sewer Revenues 47,106 47,136 86,042 47,000 47,000 602 37260.00 Penalties-Sewer Revenues 11,327 12,809 12,567 10,000 12,000 602 39103.00 Gain or Loss from F/A Disposal (3,421) 0 0 0 0 602 39203.00 Transfer From 0 238,964 10,806 0 0 FUND TOTALS $1,506,064 $1,994,630 $1,707,729 $1,874,300 ��� $1,952,800 Page One 2015 BUDGET WORKSHEETS SEWER UTILITY -EXPENDITURES- August 11,2014 2014 2015 Objecl 2015 2011 2012 2013 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of ' A 602 49450 101.00 Salaries&Benefits $437,200 Salary,Taxes,PERA&Benefits 602 49450 77 101.00 Administrative 110,563 120,762 117,498 112,900 116,100 602 49450 78 101.00 Technical/Clerical 136,305 144,154 142,778 148,800 154,300 602 49450 79 101.00 Maintenance 138,718 146,589 157,163 165,600 166,800 602 49450 xx 101.00 Salary&Benefit Contingency 0 0 0 0 0 602 49450 102.00 Full-Time Overtime 9,029 7,794 15,629 7,500 7,500 602 49450 103.00 Part-Time Salaries&Benefits 8,880 8,025 5,531 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,195 1,499 1,613 1,500 1,500 Inserts&Water Bill Statements 602 49450 01 209.00 Other Office Supplies 0 227 899 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 0 304 200 200 602 49450 01 224.00 Street Maintenance Materials 1,425 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 Supplier 18 3,292 211 5,000 5,000 MH Castings Replacement Prog. 602 49450 01 241.00 Small Tools 417 802 165 500 500 Wrenches,Shovels,etc. 602 49450 01 242.00 Minor Equipment 1,285 414 2,990 3,000 3,000 602 49450 01 303.00 Engineering Fees 20,000 602 49450 01 303.01 GIS 129 2,539 516 5,000 5,000 602 49450 01 303.02 Rate Study 0 0 0 7,500 0 602 49450 01 303.04 Miscellaneous 4,148 2,395 7,402 15,000 15,000 Sewer System O&M Review 602 49450 01 304.00 Legal Fees 0 286 0 500 500 602 49450 01 312.00 Gopher State One-Call 2,092 2,559 2,303 3,500 2,500 602 49450 01 313.00 Temporary Service Fees 14,559 0 0 0 0 _ 602 49450 01 318.00 Contract Engineer 7,000 8,000 10,000 7,000 25,000 602 49450 01 319.00 Other Professional Services 15,600 602 49450 01 319.01 Televising 1,720 531 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) 3,356 0 6,802 5,000 5,000 SCADA System 602 49450 01 319.04 Buxton Project 3,356 0 0 0 5,600 602 49450 01 320.00 Credit Card Activity Fees 0 0 3,324 2,000 3,000 1/3 Cost of C/C Pymt Processing 602 49450 01 321.00 Telephone Costs 2,312 2,646 2,745 2,500 3,000 Cell Phones,Modems,GPS 602 49450 01 322.00 Postage Costs 4,504 4,678 4,556 5,000 5,000 Billings with Inserts 602 49450 01 323.00 Radio Units 1,211 1,116 1,045 1,500 1,500 24 Units*$300(Split 5 Ways) 602 49450 01 365.00 Workers Comp Insurance 7,109 6,828 7,011 7,000 7,000 Sewer's Share of Premiums 602 49450 01 369.00 Other Insurance 5,307 6,443 10,777 12,000 12,000 Sewer's Share of Premiums 602 49450 01 391.00 P.C.Maintenance 491 0 0 2,700 602 49450 01 391.01 U/B Software Maintenance 0 1,827 2,081 2,000 2,000 Added to Utility Budgets in 2012 602 49450 01 391.02 Auto Read Software Support 0 585 585 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 320 1,362 4,093 3,000 12,000 Replace SCADA Hardware/Software 602 49450 01 394.00 P.C.Software Purchases 4,574 7,200 602 49450 01 394.01 Licensing&Maintenance 0 4,779 4,279 6,500 6,200 Cartegraph,GIS 602 49450 01 394.02 Online Subscriptions 0 308 286 800 800 Pictometry 602 49450 01 394.03 New Software Purchases 0 7,772 2,271 500 200 602 49450 01 395.00 P.C.Repairs 0 0 0 500 500 602 49450 01 403.00 Contracted R&M-Other Impr 0 3,533 2,581 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 23 50 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) 23 90 1,646 1,500 1,500 Operator Licensure$300 each(M) 602 49450 01 437.02 Collection System Conference 950 1,310 0 0 0 Duplicate of Sewer School 437.01 602 49450 01 437.03 CarteGraph,ESRI,GIS 158 270 120 1,500 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 144 153 148 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 0 31 10,000 10,000 SCADA Reconfiguration,PCL's 602 49450 01 530.02 Misc.Improvements/Repairs 0 0 0 0 0 602 49450 01 530.03 CRP of Sewermain 0 0 0 150,000 150,000 Annual Pavement Management 602 49450 01 530.04 0 0 0 0 0 602 49450 01 540.00 Heavy Machinery Purchases 0 0 0 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 471,320 493,620 519,385 733,100 767,800 Page Two 2015 BUDGET WORKSHEETS SEWER UTILITY -EXPENDITURES- August 11,2014 2014 2015 Object 2015 2011 2012 2013 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 602 49450 01 602.00 Sewer Service Charges 981,478 940,900 1,007,195 1,090,300 1,144,900 MWCC Charges 602 49450 01 611.00 Interest on Lease Payments 3,232 2,893 2,538 0 0 P.W.Building Expansion(See 521) 602 49450 01 710.00 Transfers 172,451 10,493 116,948 0 0 Transfers for Other Improvements 602-49450-01 TOTALS 1,628,481 1,447,906 1,646,066 1,823,400 1,912,700 602 49451 01 219.00 Other Operating Supplies 0 0 0 100 100 602 49451 01 221.00 Equipment Parts 4,215 21 0 800 800 602 49451 01 229.00 Other Maintenance Supplies 0 0 0 200 200 602 49451 01 303.00 Engineering Fees 5,499 0 0 0 0 602 49451 01 381.00 Electric Utilities 1,058 925 915 1,500 1,500 602 49451 01 403.00 Contracted R&M-Other Impr 0 0 0 200 200 602 49451 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies (City Hall) TOTAL-LIFT STATION#1 10,772 947 915 2,900 2,900 602 49452 01 219.00 Other Operating Supplies 0 0 0 100 100 602 49452 01 221.00 Equipment Parts 2,697 59 1,060 800 800 602 49452 01 229.00 Other Maintenance Supplies 0 0 0 200 200 602 49452 01 321.00 Telephone Costs 211 105 0 0 0 602 49452 01 381.00 Electric Utilities 620 554 630 700 700 602 49452 01 403.00 Contracted R&M-Other lmpr 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 ---3,528 719 1,691 2,100 2,100 602 49453 01 219.00 Other Operating Supplies 0 0 0 100 100 602 49453 01 221.00 Equipment Parts 338 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,154 3,578 3,753 4,000 4,000 602 49453 01 403.00 Contracted R&M-Other Impr 0 230 0 200 200 602 49453 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies (Shannon Pond) TOTAL-LIFT STATION#3 3,492 3,808 3,753 5,400 5,400 602 49454 01 219.00 Other Operating Supplies 0 0 0 100 100 602 49454 01 221.00 Equipment Parts 478 2,001 167 800 800 602 49454 01 229.00 Other Maintenance Supplies 0 0 0 200 200 602 49454 01 381.00 Electric Utilities 4,898 5,377 4,602 6,000 6,000 602 49454 01 403.00 Contracted R&M-Other Impr 3,195 0 1,582 10,000 2,000 Alarm Upgrades,SCADA,PLC 602 49454 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies (Hawkins) TOTAL-LIFT STATION#4 8,571 7,377 6,351 17,200 9,200 602 49455 01 219.00 Other Operating Supplies 0 0 0 100 100 602 49455 01 221.00 Equipment Parts 31,500 0 0 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,609 5,879 5,569 7,000 6,000 602 49455 01 403.00 Contracted R&M-Other Impr 0 0 0 200 200 _ 602 49455 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies (LeForet Add'n) TOTAL-LIFT STATION#5 37,108 5,879 5,569 8,400 7,400 602 49456 01 219.00 Other Operating Supplies 0 0 0 100 100 _ 602 49456 01 221.00 Equipment Parts 118 4,247 2,385 800 800 602 49456 01 229.00 Other Maintenance Supplies 0 0 0 200 200 602 49456 01 381.00 Electric Utilities 6,614 3,788 6,001 5,000 6,000 602 49456 01 403.00 Contracted R&M-Other lmpr 0 0 0 3,000 200 Alarm Upgrades 602 49456 01 439.00 Other Miscellaneous Charges 0 0 0 100 100 Contingencies (Drumcliffe) TOTAL-LIFT STATION#6 6,732 8,035 8,385 9,200 7,400 Page Three 2015 BUDGET WORKSHEETS SEWER UTILITY -EXPENDITURES- August 11,2014 2014 2015 Objecl 2015 2011 2012 2013 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,103 1,176 1,278 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 (Glenda lough 5th) TOTAL-LIFT STATION#9 1,103 1,176 1,278 2,300 2,300 602 49458 01 219.00 Other Operating Supplies 0 0 0 100 100 602 49458 01 221.00 Equipment Parts 6,612 353 1,269 500 500 602 49458 01 229.00 Other Maintenance Supplies 0 0 0 200 200 602 49458 01 381.00 Electric Utilities 552 522 633 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 7,164 875 1,902 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 497 294 725 500 500 602 49460 01 229.00 Other Maintenance Supplies 0 0 0 200 200 602 49460 01 381.00 Electric Utilities 295 251 252 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 793 545 977 1,500 1,500 GRAND TOTAL-ALL DEPTS. $1,707,744 $1,477,266 $1,676,886 $1,874,300 $1,952,800 Page One 2015 BUDGET WORKSHEETS STORM WATER UTILITY -REVENUES- August 11,2014 2014 2015 Object 2015 2011 2012 2013 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 603 33400.00 State Grants&Aids $0 $0 $0 $0 $0 603 33425.00 Other State Grants&Aids 0 0 0 0 0 603 34108.00 Administrative Fees-Other Funds 2,123 5,733 2,497 0 0 5%of 5%Fees-Const Projects 603 36101.00 Principal-Special Assessments 22,204 22,418 19,925 20,000 20,000 603 36102.00 Penalties&Interest-S/A 732 514 76 0 0 603 36210.00 Interest Earnings-Investments 45,136 24,205 21,458 20,000 20,000 603 36214.00 Net Change in FV-Investments 2,198 479 (48,916) 0 0 Annual Market Value Changes 603 36215.00 Interest Earnings 245 262 60 300 300 603 36260.00 Other Revenues 0 0 188,004 0 0 603 36265.00 Use of Reserve Funds 0 0 0 0 0 603 37300.00 Storm Water Utility Revenues 879,551 908,679 980,819 900,000 950,000 603 37360.00 Penalties-Storm Water Utility 3,690 5,416 5,956 4,700 5,000 603 39203.00 Transfer From 0 0 0 0 0 ---- --- ---------- ------------- FUND TOTALS $955,878 $967,705 $1,169,878 $945,000 $995,300 Page One 2015 BUDGET WORKSHEETS STORM WATER UTILITY -EXPENDITURES- August 11,2014 2014 2015 Object 2015 2011 2012 2013 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments All Salary Costs Inclusive of 603 49500 101.00 Salaries&Benefits $181,400 Salary,Taxes,PERA&Benefits 603 49500 77 101.00 Administrative 0 4,036 10,586 11,000 11,300 603 49500 78 101.00 Technical/Clerical 76,109 88,359 80,607 81,800 85,000 603 49500 79 101.00 Maintenance 69,358 73,294 78,581 84,600 85,100 603 49500 xx 101.00 Salary&Benefit Contingency 0 0 0 0 0 603 49500 102.00 Full-Time Overtime 4,568 3,958 7,836 6,000 6,000 603 49500 99 103.00 Part-Time Salaries&Benefits 9,334 6,824 5,157 8,000 8,000 603 49500 01 203.00 Printed Forms&Paper 1,195 1,726 1,613 1,500 1,500 603 49500 01 204.00 Envelopes&Letterhead 0 0 0 0 0 603 49500 01 208.00 Miscellaneous Supplies 0 352 1,090 500 500 Stakes,Ribbons,Level,etc. 603 49500 01 215.00 Shop Materials 0 0 0 0 0 603 49500 01 219.00 Other Operating Supplies 0 0 0 0 0 603 49500 01 221.00 Equipment Parts 0 0 0 0 0 603 49500 01 224.00 Street Maintenance Materials 406 1,199 515 2,000 2,000 Patching Material for Washouts 603 49500 01 225.00 Landscaping Materials 4,000 603 49500 01 225.01 Rip-Rap,Matting,Rock,etc. 1,751 1,386 898 2,000 2,000 603 49500 01 225.02 Black Dirt,Seed,Sod,etc. 1,962 1,370 150 2,000 2,000 603 49500 01 226.00 Sign Repair Materials 926 0 0 500 500 603 49500 01 230.00 Equipment Repair Material 534 881 1,754 1,000 1,000 603 49500 01 241.00 Small Tools 0 87 349 1,000 1,000 603 49500 01 242.00 Minor Equipment 332 221 2,659 2,000 2,000 Misc.Nozzles for Vac Truck 603 49500 01 303.00 Engineering Fees 75,000 603 49500 01 303.01 Problem Area Investigations 10,003 3,501 79 10,000 10,000 603 49500 01 303.02 NPDES Phase II 0 29,749 14,115 30,000 30,000 603 49500 01 303.03 CSMP Update 22,880 36 4,850 0 0 603 49500 01 303.04 Miscellaneous 29,866 4,186 14,108 30,000 30,000 603 49500 01 303.05 GIS 0 1,672 344 5,000 5,000 603 49500 01 304.00 Legal Fees 234 0 0 2,000 2,000 603 49500 01 310.00 Testing Services 0 0 0 1,000 1,000 Water Quality Tests(M) 603 49500 01 312.00 Gopher State One-Call 0 0 0 500 2,500 603 49500 01 313.00 Temporary Service Fees 9,706 0 0 0 0 603 49500 01 315.00 Special Programs(County Program) 4,500 3,850 4,815 5,000 5,000 Wetland Health&Evaluation Proj 603 49500 01 318.00 Contract Engineer 7,000 8,000 10,000 7,000 25,000 603 49500 01 319.00 Other Professional Services 3,356 0 6,802 5,000 10,600 603 49500 01 319.01 SCADA 0 0 0 0 5,000 603 49500 01 319.02 Buxton Project 0 0 0 0 5,600 603 49500 01 320.00 Credit Card Activity Fees 0 0 3,324 2,000 3,000 1/3 Cost of C/C Pymt Processing 603 49500 01 321.00 Telephone Costs 2,312 2,647 2,745 2,500 3,000 Cell Phones,Modems,GPS 603 49500 01 322.00 Postage Costs 4,504 4,678 4,556 5,000 5,000 Billings&Info Mailings 603 49500 01 323.00 Radio Units 1,210 1,116 1,045 1,500 1,500 24 Units*$300(Split 5 Ways) 603 49500 01 352.00 General Notices&Public Info 0 0 0 1,000 1,000 Public Info Brochure 603 49500 01 365.00 Workers Comp Insurance 2,875 2,654 2,925 3,500 3,500 Storm Water's Share of Premiums 603 49500 01 369.00 Other Insurance 2,393 2,362 1,278 4,000 4,000 Storm Waters Share of Premiums 603 49500 01 384.00 Refuse Disposal 0 0 0 0 0 603 49500 01 389.00 Other Utility Services 0 0 0 0 0 603 49500 01 391.00 P.C.Maintenance 491 2,700 603 49500 01 391.01 U/B Software Maintenance 0 1,827 2,081 2,000 2,000 Added to Utility Budgets in 2012 603 49500 01 391.02 Auto Read Software Support 0 585 585 700 700 Added to Utility Budgets in 2012 603 49500 01 393.00 P.C.Hardware Purchases 320 1,362 4,093 3,000 12,000 Replace SCADA Hardware/Software 603 49500 01 394.00 P.C.Software Purchases 4,574 7,200 603 49500 01 394.01 Licensing&Maintenance 0 4,779 4,279 6,500 6,200 Cartegraph,GIS 603 49500 01 394.02 Online Subscriptions 0 308 286 800 800 Pictometry 603 49500 01 394.03 New Software Purchases 0 7,772 2,271 500 200 603 49500 01 403.00 Contracted R&M-Other Impr 65,000 603 49500 01 403.01 Ditching 0 0 4,330 5,000 5,000 603 49500 01 403.02 Miscellaneous Repairs 22,899 17,830 32,838 50,000 50,000 Catch Basins,Manholes,Etc. 603 49500 01 403.03 Pond Inspection&Maintenance 0 0 0 0 10,000 603 49500 01 416.00 Machinery Rental 43 0 64 4,000 4,000 Pumps 603 49500 01 433.00 Dues&Subscriptions 140 140 140 200 200 SUSA(AJ,Dick)50%Split w/Storm 603 49500 01 435.00 Books&Pamphlets 0 0 0 500 500 Utility Information 603 49500 01 437.00 Conferences&Seminars 3,500 603 49500 01 437.01 Storm Water Management 875 965 112 1,200 1,200 Stormwater Collab,Flygt Training 603 49500 01 437.03 Wetlands Training 0 0 0 0 0 603 49500 01 437.04 Cartegraph,ESRI,GIS 157 270 120 1,500 1,300 User Group,Conference,Training 603 49500 01 437.05 Miscellaneous Training 0 0 0 1,000 1,000 603 49500 01 439.00 Other Miscellaneous Charges 144 153 908 0 0 603 49500 01 530.00 Improvements Other Than Bldgs 150,000 603 49500 01 530.01 CRP of Storm Sewer 2,669 597 6,523 150,000 150,000 Annual Pavement Management 603 49500 01 560.00 Furniture&Fixture Purchases 0 0 0 500 500 603 49500 01 580.00 Other Equipment Purchases 0 0 0 2,000 2,000 603 49500 01 586.00 Computer Equipment Purchases 0 0 0 500 500 PAGE TOTALS 299,624 284,731 321,410 548,800 598,100 Page Two 2015 BUDGET WORKSHEETS STORM WATER UTILITY -EXPENDITURES- August 11,2014 2014 2015 Object 2015 2011 2012 2013 Adopted Detail Proposed Account# Description Actual Actual Actual Budget Amount Budget Comments 603 49500 01 710.00 Transfers 50,000 603 49500 01 710.01 1/2 of 2011 P&I Payments(1996B) 0 0 0 0 0 Bonds Called 2/1/08 603 49500 01 710.02 1/2 of 2011 P&I Payments(1999C) 0 0 0 0 0 Bonds Called 2/1/08 603 49500 01 710.03 1/2 of 2011 P&I Payments(2001B) 0 0 0 0 0 Bonds Called 2/1/11 603 49500 01 710.04 1/2 of 2011 P&I Payments(2001D) 0 0 0 0 0 Bonds Paid off 2/1/08 603 49500 01 710.05 1/2 of 2011 P&I Payments(2002B) 8,000 0 0 0 0 Bonds Called 2/1/11 603 49500 01 710.06 1/2 of 2011 P&I Payments(2010A) 60,000 84,000 89,000 87,000 50,000 New Refunding Issue 12/10 603 49500 01 710.07 1/2 of 2011 P&I Payments(2003A) 90,000 0 0 0 0 Bonds Called 12/1/11 603 49500 01 710.10 Projects 233,607 68,296 81,225 0 0 --------------- ----- 603-49500-01 TOTALS 691,232 437,027 491,635 635,800 648,100 603 49511 01 221.00 Equipment Parts 0 0 410 500 500 603 49511 01 381.00 Electric Utilities 264 258 312 500 500 603 49511 01 403.00 Contracted Repair&Maintenance 0 0 0 0 1,000 (Copper Pond) TOTAL-LIFT STATION#1 264 258 722 1,000 2,000 603 49512 01 221.00 Equipment Parts 880 390 0 500 500 603 49512 01 381.00 Electric Utilities 0 0 0 500 500 603 49512 01 403.00 Contracted Repair&Maintenance 0 0 0 0 1,000 (Schwarz Pond) TOTAL-LIFT STATION#2 880 390 0 1,000 ��- 2,000 603 49513 01 221.00 Equipment Parts 375 0 0 500 500 603 49513 01 381.00 Electric Utilities 4,401 2,698 5,176 4,500 4,500 603 49513 01 403.00 Contracted Repair&Maintenance 0 0 0 0 1,000 (Birger Pond) TOTAL-LIFT STATION#3 4,776 2,698 5,176 5,000 6,000 603 49514 01 221.00 Equipment Parts 931 0 0 500 500 603 49514 01 381.00 Electric Utilities 1,653 947 1,500 2,000 2,000 603 49514 01 403.00 Contracted Repair&Maintenance 0 0 0 3,000 1,000 Alarm Upgrades (Marcotte Pond) TOTAL-LIFT STATION#4 2,585 947 1,500 5,500 3,500 603 49515 01 221.00 Equipment Parts 0 0 0 500 500 603 49515 01 381.00 Electric Utilities 0 0 0 500 500 603 49515 01 403.00 Contracted Repair&Maintenance 0 0 0 10,000 1,000 Alarm Upgrades,SCADA,PLC (Hawkins Pond) TOTAL-LIFT STATION#5 0 0 0 11,000 2,000 603 49516 01 221.00 Equipment Parts 0 0 0 500 500 603 49516 01 381.00 Electric Utilities 415 460 449 500 500 603 49516 01 403.00 Contracted Repair&Maintenance 0 0 0 0 1,000 (Glendalough 7th) TOTAL-LIFT STATION#6 415 460 449 1,000 2,000 GRAND TOTAL-ALL DEPTS. $700,152 $441,779 $499,484 $660,300 $665,600