Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
Water and Watewater Rate Advisory Committee Agenda Packet - October 12, 2016
City of Colleyville Page 1 Water and Wastewater Rate Advisory Committee Agenda City Hall 100 Main Street Colleyville, Texas 76034 817.503.1000 www.colleyville.com Wednesday, October 12, 2016 5:30 p.m. Executive Conference Room Third Floor – City Hall CALL TO ORDER 1. APPROVAL OF MINUTES October 6, 2016 2.REGULAR AGENDA ITEMS 2a Presentation and discussion of Committee recommendations to the City Council 3.ADJOURNMENT I hereby certify this agenda was posted on City Hall bulletin boards Friday, October 7, 2016 by 5:00 p.m. Amy Shelley, TRMC City Secretary A quorum of the City Council or any Colleyville Board, Commission, or Committee may be in attendance at this meeting. Any matter on this agenda may, at the discretion of the governing body, be opened for public comment and discussion. If you plan to attend this public meeting and have a disability that requires special accommodations, please advise the City Secretary at least 48 hours in advance at 817.503.1130, and reasonable accommodations will be made to assist you. City of Colleyville, Texas Water Rate Scenarios Water Scenario A Meter Interim Equivalents Rate $20.00 $21.00 $22.00 $23.00 $24.00 $24.75 RATES Meter Charge 1" and Less 1.00 $13.55 $20.00 $21.00 $22.00 $23.00 $24.00 $24.75 1 1/2"2.00 15.57 40.00 42.00 44.00 46.00 48.00 49.50 2"3.20 20.29 64.00 67.20 70.40 73.60 76.80 79.20 3"6.00 33.20 120.00 126.00 132.00 138.00 144.00 148.50 4"10.00 51.27 200.00 210.00 220.00 230.00 240.00 247.51 Volumetric Charge Per 1,000 gallons $4.36 $4.45 $4.39 $4.33 $4.27 $4.21 $4.17 BILLING DETERMINANTS Connections (Excluding Government) 1" and Less 9,542 9,542 9,542 9,542 9,542 9,542 1 1/2"154 154 154 154 154 154 2"110 110 110 110 110 110 3"3 3 3 3 3 3 4"12 12 12 12 12 12 Subtotal 9,821 9,821 9,821 9,821 9,821 9,821 Volumes (000's)2,152,978 2,152,978 2,152,978 2,152,978 2,152,978 2,152,978 REVENUES Revenues 1" and Less $2,290,080 $2,404,584 $2,519,088 $2,633,592 $2,748,096 $2,834,042 1 1/2"73,920 77,616 81,312 85,008 88,704 91,478 2"84,480 88,704 92,928 97,152 101,376 104,547 3"4,320 4,536 4,752 4,968 5,184 5,346 4"28,800 30,240 31,680 33,120 34,560 35,641 Subtotal $2,481,600 $2,605,680 $2,729,760 $2,853,840 $2,977,920 $3,071,054 Volumetric Revenues $9,570,221 $9,446,141 $9,322,061 $9,197,981 $9,073,901 $8,980,767 Total Revenues $12,051,821 $12,051,821 $12,051,821 $12,051,821 $12,051,821 $12,051,821 Base Charge of: Page 1 of 8 City of Colleyville, Texas Water Rate Scenarios Water Scenario A Meter Interim Equivalents Rate $20.00 $21.00 $22.00 $23.00 $24.00 $24.75 Base Charge of: Distribution Cost $3,071,054 $3,071,054 $3,071,054 $3,071,054 $3,071,054 $3,071,054 Over / (Under) Recovery (589,454) (465,374) (341,294) (217,214) (93,134) - Purchased Water Cost $8,980,767 $8,980,767 $8,980,767 $8,980,767 $8,980,767 $8,980,767 Over / (Under) Recovery 589,454 465,374 341,294 217,214 93,134 - Total Cost $12,051,821 $12,051,821 $12,051,821 $12,051,821 $12,051,821 $12,051,821 Over / (Under) Recovery 0 0 0 0 - - Distribution (Fixed Cost) Recovery in Min Bill 80.8%84.8%88.9%92.9%97.0%100.0% Page 2 of 8 $20.00 $21.00 $22.00 $23.00 $24.00 $24.75 $4.45 $4.39 $4.33 $4.27 $4.21 $4.17 $4.10 $4.15 $4.20 $4.25 $4.30 $4.35 $4.40 $4.45 $4.50 $18.00 $20.00 $22.00 $24.00 $26.00 80.8%84.8%88.9%92.9%97.0%100.0% Water Rate Options Scenario A Minimum Bill Volumetric Charge OPTIMAL REVENUE RECOVERY City of Colleyville, Texas Water Rate Scenarios Water Scenario A Total % of Cumulative Customers Customers % of Customers $20.00 $21.00 $22.00 $23.00 $24.00 $24.75 - - 1,138 1.09%1.09%$20.00 $21.00 $22.00 $23.00 $24.00 $24.75 - 1,000 1,186 1.14%2.23%24.45 25.39 26.33 27.27 28.21 28.92 1,000 2,000 3,899 3.73%5.96%28.89 29.77 30.66 31.54 32.43 33.09 2,000 3,000 5,696 5.45%11.41%33.34 34.16 34.99 35.82 36.64 37.26 3,000 4,000 6,996 6.70%18.11%37.78 38.55 39.32 40.09 40.86 41.44 4,000 5,000 7,048 6.75%24.86%42.23 42.94 43.65 44.36 45.07 45.61 5,000 6,000 6,429 6.16%31.02%46.67 47.32 47.98 48.63 49.29 49.78 6,000 7,000 5,606 5.37%36.39%51.12 51.71 52.31 52.91 53.50 53.95 7,000 8,000 4,660 4.46%40.85%55.56 56.10 56.64 57.18 57.72 58.12 8,000 9,000 3,856 3.69%44.54%60.01 60.49 60.97 61.45 61.93 62.29 9,000 10,000 3,467 3.32%47.86%64.45 64.87 65.30 65.72 66.15 66.46 10,000 11,000 2,972 2.85%50.71%68.90 69.26 69.63 69.99 70.36 70.64 11,000 12,000 2,788 2.67%53.38%73.34 73.65 73.96 74.27 74.57 74.81 12,000 13,000 2,470 2.37%55.75%77.79 78.04 78.29 78.54 78.79 78.98 13,000 14,000 2,327 2.23%57.97%82.23 82.42 82.62 82.81 83.00 83.15 14,000 15,000 2,268 2.17%60.15%86.68 86.81 86.95 87.08 87.22 87.32 15,000 16,000 2,013 1.93%62.07%91.12 91.20 91.28 91.36 91.43 91.49 16,000 17,000 1,854 1.78%63.85%95.57 95.59 95.61 95.63 95.65 95.66 17,000 18,000 1,749 1.67%65.52%100.01 99.97 99.94 99.90 99.86 99.83 18,000 19,000 1,671 1.60%67.12%104.46 104.36 104.27 104.17 104.08 104.01 19,000 20,000 1,591 1.52%68.65%108.90 108.75 108.60 108.44 108.29 108.18 20,000 21,000 1,429 1.37%70.02%113.35 113.14 112.93 112.72 112.51 112.35 21,000 22,000 1,336 1.28%71.30%117.79 117.52 117.26 116.99 116.72 116.52 22,000 23,000 1,343 1.29%72.58%122.24 121.91 121.59 121.26 120.94 120.69 23,000 24,000 1,254 1.20%73.78%126.68 126.30 125.92 125.53 125.15 124.86 24,000 25,000 1,241 1.19%74.97%131.13 130.69 130.25 129.81 129.36 129.03 25,000 26,000 1,149 1.10%76.07%135.57 135.07 134.58 134.08 133.58 133.21 26,000 27,000 1,107 1.06%77.13%140.02 139.46 138.91 138.35 137.79 137.38 27,000 28,000 1,118 1.07%78.20%144.46 143.85 143.24 142.62 142.01 141.55 Monthly Customer Bills at Base Charge of: Page 4 of 8 City of Colleyville, Texas Water Rate Scenarios Water Scenario A Total % of Cumulative Customers Customers % of Customers $20.00 $21.00 $22.00 $23.00 $24.00 $24.75 Monthly Customer Bills at Base Charge of: 28,000 29,000 1,030 0.99%79.19%148.91 148.24 147.57 146.89 146.22 145.72 29,000 30,000 1,025 0.98%80.17%153.35 152.62 151.90 151.17 150.44 149.89 30,000 31,000 946 0.91%81.08%157.80 157.01 156.23 155.44 154.65 154.06 31,000 32,000 951 0.91%81.99%162.24 161.40 160.56 159.71 158.87 158.23 32,000 33,000 888 0.85%82.84%166.69 165.79 164.88 163.98 163.08 162.40 33,000 34,000 858 0.82%83.66%171.13 170.17 169.21 168.26 167.30 166.58 34,000 35,000 799 0.77%84.42%175.58 174.56 173.54 172.53 171.51 170.75 35,000 36,000 777 0.74%85.17%180.02 178.95 177.87 176.80 175.72 174.92 36,000 37,000 749 0.72%85.89%184.47 183.34 182.20 181.07 179.94 179.09 37,000 38,000 707 0.68%86.56%188.91 187.72 186.53 185.34 184.15 183.26 38,000 39,000 639 0.61%87.17%193.36 192.11 190.86 189.62 188.37 187.43 39,000 40,000 662 0.63%87.81%197.80 196.50 195.19 193.89 192.58 191.60 40,000 41,000 636 0.61%88.42%202.25 200.89 199.52 198.16 196.80 195.77 41,000 42,000 593 0.57%88.99%206.69 205.27 203.85 202.43 201.01 199.95 42,000 43,000 530 0.51%89.49%211.14 209.66 208.18 206.71 205.23 204.12 43,000 44,000 551 0.53%90.02%215.58 214.05 212.51 210.98 209.44 208.29 44,000 45,000 523 0.50%90.52%220.03 218.44 216.84 215.25 213.66 212.46 45,000 46,000 496 0.47%91.00%224.48 222.82 221.17 219.52 217.87 216.63 46,000 47,000 483 0.46%91.46%228.92 227.21 225.50 223.79 222.09 220.80 47,000 48,000 439 0.42%91.88%233.37 231.60 229.83 228.07 226.30 224.97 48,000 49,000 445 0.43%92.31%237.81 235.99 234.16 232.34 230.51 229.15 49,000 50,000 413 0.40%92.70%242.26 240.37 238.49 236.61 234.73 233.32 50,000 +7,622 7.30%100.00% Page 5 of 8 City of Colleyville, Texas Water Rate Scenarios Normalization of Tiered Rate Prior to:TRA Adjusted 8/1/2016 Normalization Rates RATES Meter Charge 1" and Less 13.55$ 0.42$ 13.97$ 1 1/2"15.57 0.42 15.99 2"20.29 0.42 20.71 3"33.20 0.42 33.62 4"51.27 0.42 51.69 Volumetric Charge 1,500 - 20,000 4.30$ 0.28$ 4.58$ 20,001 - 30,000 4.86 0.28 5.14 30,001 - 40,000 5.42 0.28 5.70 40,001 - 50,000 5.98 0.28 6.26 50,001 +6.54 0.28 6.82 TRA Rate (2016)3.89$ TRA Rate (2017)4.17 Variance 0.28$ Page 6 of 8 City of Colleyville, Texas Water Rate Scenarios Water Scenario A Customer Total % of Cumulative Bills Customers Customers % of Customers Normalized $20.00 $21.00 $22.00 $23.00 $24.00 $24.75 - - 1,138 1.09%1.09%13.97$ $6.03 $7.03 $8.03 $9.03 $10.03 $10.78 - 1,000 1,186 1.14%2.23%13.97 10.48 11.42 12.36 13.30 14.24 14.95 1,000 2,000 3,899 3.73%5.96%16.26 12.63 13.51 14.40 15.28 16.17 16.83 2,000 3,000 5,696 5.45%11.41%20.84 12.50 13.32 14.15 14.98 15.80 16.42 3,000 4,000 6,996 6.70%18.11%25.42 12.36 13.13 13.90 14.67 15.44 16.02 4,000 5,000 7,048 6.75%24.86%30.00 12.23 12.94 13.65 14.36 15.07 15.61 5,000 6,000 6,429 6.16%31.02%34.58 12.09 12.74 13.40 14.05 14.71 15.20 6,000 7,000 5,606 5.37%36.39%39.16 11.96 12.55 13.15 13.75 14.34 14.79 7,000 8,000 4,660 4.46%40.85%43.74 11.82 12.36 12.90 13.44 13.98 14.38 8,000 9,000 3,856 3.69%44.54%48.32 11.69 12.17 12.65 13.13 13.61 13.97 9,000 10,000 3,467 3.32%47.86%52.90 11.55 11.97 12.40 12.82 13.25 13.56 10,000 11,000 2,972 2.85%50.71%57.48 11.42 11.78 12.15 12.51 12.88 13.16 11,000 12,000 2,788 2.67%53.38%62.06 11.28 11.59 11.90 12.21 12.51 12.75 12,000 13,000 2,470 2.37%55.75%66.64 11.15 11.40 11.65 11.90 12.15 12.34 13,000 14,000 2,327 2.23%57.97%71.22 11.01 11.20 11.40 11.59 11.78 11.93 14,000 15,000 2,268 2.17%60.15%75.80 10.88 11.01 11.15 11.28 11.42 11.52 15,000 16,000 2,013 1.93%62.07%80.38 10.74 10.82 10.90 10.98 11.05 11.11 16,000 17,000 1,854 1.78%63.85%84.96 10.61 10.63 10.65 10.67 10.69 10.70 17,000 18,000 1,749 1.67%65.52%89.54 10.47 10.43 10.40 10.36 10.32 10.29 18,000 19,000 1,671 1.60%67.12%94.12 10.34 10.24 10.15 10.05 9.96 9.89 19,000 20,000 1,591 1.52%68.65%98.70 10.20 10.05 9.90 9.74 9.59 9.48 20,000 21,000 1,429 1.37%70.02%103.84 9.51 9.30 9.09 8.88 8.67 8.51 21,000 22,000 1,336 1.28%71.30%108.98 8.81 8.54 8.28 8.01 7.74 7.54 22,000 23,000 1,343 1.29%72.58%114.12 8.12 7.79 7.47 7.14 6.82 6.57 23,000 24,000 1,254 1.20%73.78%119.26 7.42 7.04 6.66 6.27 5.89 5.60 24,000 25,000 1,241 1.19%74.97%124.40 6.73 6.29 5.85 5.41 4.96 4.63 25,000 26,000 1,149 1.10%76.07%129.54 6.03 5.53 5.04 4.54 4.04 3.67 26,000 27,000 1,107 1.06%77.13%134.68 5.34 4.78 4.23 3.67 3.11 2.70 27,000 28,000 1,118 1.07%78.20%139.82 4.64 4.03 3.42 2.80 2.19 1.73 28,000 29,000 1,030 0.99%79.19%144.96 3.95 3.28 2.61 1.93 1.26 0.76 29,000 30,000 1,025 0.98%80.17%150.10 3.25 2.52 1.80 1.07 0.34 (0.21) 30,000 31,000 946 0.91%81.08%155.80 2.00 1.21 0.43 (0.36) (1.15) (1.74) 31,000 32,000 951 0.91%81.99%161.50 0.74 (0.10) (0.94) (1.79) (2.63) (3.27) Variance in Monthly Customer Bill: Page 7 of 8 City of Colleyville, Texas Water Rate Scenarios Water Scenario A Customer Total % of Cumulative Bills Customers Customers % of Customers Normalized $20.00 $21.00 $22.00 $23.00 $24.00 $24.75 Variance in Monthly Customer Bill: 32,000 33,000 888 0.85%82.84%167.20 (0.51) (1.41) (2.32) (3.22) (4.12) (4.80) 33,000 34,000 858 0.82%83.66%172.90 (1.77) (2.73) (3.69) (4.64) (5.60) (6.32) 34,000 35,000 799 0.77%84.42%178.60 (3.02) (4.04) (5.06) (6.07) (7.09) (7.85) 35,000 36,000 777 0.74%85.17%184.30 (4.28) (5.35) (6.43) (7.50) (8.58) (9.38) 36,000 37,000 749 0.72%85.89%190.00 (5.53) (6.66) (7.80) (8.93) (10.06) (10.91) 37,000 38,000 707 0.68%86.56%195.70 (6.79) (7.98) (9.17) (10.36) (11.55) (12.44) 38,000 39,000 639 0.61%87.17%201.40 (8.04) (9.29) (10.54) (11.78) (13.03) (13.97) 39,000 40,000 662 0.63%87.81%207.10 (9.30) (10.60) (11.91) (13.21) (14.52) (15.50) 40,000 41,000 636 0.61%88.42%213.36 (11.11) (12.47) (13.84) (15.20) (16.56) (17.59) 41,000 42,000 593 0.57%88.99%219.62 (12.93) (14.35) (15.77) (17.19) (18.61) (19.67) 42,000 43,000 530 0.51%89.49%225.88 (14.74) (16.22) (17.70) (19.17) (20.65) (21.76) 43,000 44,000 551 0.53%90.02%232.14 (16.56) (18.09) (19.63) (21.16) (22.70) (23.85) 44,000 45,000 523 0.50%90.52%238.40 (18.37) (19.96) (21.56) (23.15) (24.74) (25.94) 45,000 46,000 496 0.47%91.00%244.66 (20.18) (21.84) (23.49) (25.14) (26.79) (28.03) 46,000 47,000 483 0.46%91.46%250.92 (22.00) (23.71) (25.42) (27.13) (28.83) (30.12) 47,000 48,000 439 0.42%91.88%257.18 (23.81) (25.58) (27.35) (29.11) (30.88) (32.21) 48,000 49,000 445 0.43%92.31%263.44 (25.63) (27.45) (29.28) (31.10) (32.93) (34.29) 49,000 50,000 413 0.40%92.70%269.70 (27.44) (29.33) (31.21) (33.09) (34.97) (36.38) 50,000 +7,622 7.30%100.00% Page 8 of 8 City of Colleyville, Texas Water Rate Scenarios Water Scenario B Meter Interim Equivalents Rate $20.00 $21.00 $22.00 $23.00 $24.00 $24.75 RATES Meter Charge 1" and Less 1.00 $13.55 $20.00 $21.00 $22.00 $23.00 $24.00 $24.75 1 1/2"2.00 15.57 40.00 42.00 44.00 46.00 48.00 49.50 2"3.20 20.29 64.00 67.20 70.40 73.60 76.80 79.20 3"6.00 33.20 120.00 126.00 132.00 138.00 144.00 148.50 4"10.00 51.27 200.00 210.00 220.00 230.00 240.00 247.51 Volumetric Charge (per 1,000 gallons) Over 1,000 gallons $4.36 $4.69 $4.63 $4.57 $4.51 $4.45 $4.40 BILLING DETERMINANTS Connections 1" and Less 9,542 9,542 9,542 9,542 9,542 9,542 1 1/2"154 154 154 154 154 154 2"110 110 110 110 110 110 3"3 3 3 3 3 3 4"12 12 12 12 12 12 Subtotal 9,821 9,821 9,821 9,821 9,821 9,821 Volumes over 1,000 gallons (000's)2,041,237 2,041,237 2,041,237 2,041,237 2,041,237 2,041,237 REVENUES Revenues 1" and Less $2,290,080 $2,404,584 $2,519,088 $2,633,592 $2,748,096 $2,834,042 1 1/2"73,920 77,616 81,312 85,008 88,704 91,478 2"84,480 88,704 92,928 97,152 101,376 104,547 3"4,320 4,536 4,752 4,968 5,184 5,346 4"28,800 30,240 31,680 33,120 34,560 35,641 Subtotal $2,481,600 $2,605,680 $2,729,760 $2,853,840 $2,977,920 $3,071,054 Volumetric Revenues $9,570,221 $9,446,141 $9,322,061 $9,197,981 $9,073,901 $8,980,767 Total Revenues $12,051,821 $12,051,821 $12,051,821 $12,051,821 $12,051,821 $12,051,821 Base Charge of: Page 1 of 8 City of Colleyville, Texas Water Rate Scenarios Water Scenario B Meter Interim Equivalents Rate $20.00 $21.00 $22.00 $23.00 $24.00 $24.75 Base Charge of: Distribution Cost $3,071,054 $3,071,054 $3,071,054 $3,071,054 $3,071,054 $3,071,054 Over / (Under) Recovery (589,454) (465,374) (341,294) (217,214) (93,134) - Purchased Water Cost $8,980,767 $8,980,767 $8,980,767 $8,980,767 $8,980,767 $8,980,767 Over / (Under) Recovery 589,454 465,374 341,294 217,214 93,134 - Total Cost $12,051,821 $12,051,821 $12,051,821 $12,051,821 $12,051,821 $12,051,821 Over / (Under) Recovery - - - - - - Distribution (Fixed Cost) Recovery in Min Bill 80.8%84.8%88.9%92.9%97.0%100.0% Page 2 of 8 $20.00 $21.00 $22.00 $23.00 $24.00 $24.75 $4.69 $4.63 $4.57 $4.51 $4.45 $4.40 $4.30 $4.35 $4.40 $4.45 $4.50 $4.55 $4.60 $4.65 $4.70 $4.75 $18.00 $20.00 $22.00 $24.00 $26.00 80.8%84.8%88.9%92.9%97.0%100.0% Water Rate Options Scenario B Minimum Bill Volumetric Charge OPTIMAL REVENUE RECOVERY City of Colleyville, Texas Water Rate Scenarios Water Scenario B Total % of Cumulative Customers Customers % of Customers $20.00 $21.00 $22.00 $23.00 $24.00 $24.75 - - 1,138 1.09%1.09%$20.00 $21.00 $22.00 $23.00 $24.00 $24.75 - 1,000 1,186 1.14%2.23%20.00 21.00 22.00 23.00 24.00 24.75 1,000 2,000 3,899 3.73%5.96%24.69 25.63 26.57 27.51 28.45 29.15 2,000 3,000 5,696 5.45%11.41%29.38 30.26 31.13 32.01 32.89 33.55 3,000 4,000 6,996 6.70%18.11%34.07 34.88 35.70 36.52 37.34 37.95 4,000 5,000 7,048 6.75%24.86%38.75 39.51 40.27 41.02 41.78 42.35 5,000 6,000 6,429 6.16%31.02%43.44 44.14 44.83 45.53 46.23 46.75 6,000 7,000 5,606 5.37%36.39%48.13 48.77 49.40 50.04 50.67 51.15 7,000 8,000 4,660 4.46%40.85%52.82 53.39 53.97 54.54 55.12 55.55 8,000 9,000 3,856 3.69%44.54%57.51 58.02 58.53 59.05 59.56 59.95 9,000 10,000 3,467 3.32%47.86%62.20 62.65 63.10 63.55 64.01 64.35 10,000 11,000 2,972 2.85%50.71%66.88 67.28 67.67 68.06 68.45 68.75 11,000 12,000 2,788 2.67%53.38%71.57 71.90 72.24 72.57 72.90 73.15 12,000 13,000 2,470 2.37%55.75%76.26 76.53 76.80 77.07 77.34 77.55 13,000 14,000 2,327 2.23%57.97%80.95 81.16 81.37 81.58 81.79 81.95 14,000 15,000 2,268 2.17%60.15%85.64 85.79 85.94 86.09 86.23 86.35 15,000 16,000 2,013 1.93%62.07%90.33 90.41 90.50 90.59 90.68 90.75 16,000 17,000 1,854 1.78%63.85%95.02 95.04 95.07 95.10 95.12 95.15 17,000 18,000 1,749 1.67%65.52%99.70 99.67 99.64 99.60 99.57 99.54 18,000 19,000 1,671 1.60%67.12%104.39 104.30 104.20 104.11 104.02 103.94 19,000 20,000 1,591 1.52%68.65%109.08 108.93 108.77 108.62 108.46 108.34 20,000 21,000 1,429 1.37%70.02%113.77 113.55 113.34 113.12 112.91 112.74 21,000 22,000 1,336 1.28%71.30%118.46 118.18 117.90 117.63 117.35 117.14 22,000 23,000 1,343 1.29%72.58%123.15 122.81 122.47 122.13 121.80 121.54 23,000 24,000 1,254 1.20%73.78%127.83 127.44 127.04 126.64 126.24 125.94 24,000 25,000 1,241 1.19%74.97%132.52 132.06 131.60 131.15 130.69 130.34 25,000 26,000 1,149 1.10%76.07%137.21 136.69 136.17 135.65 135.13 134.74 26,000 27,000 1,107 1.06%77.13%141.90 141.32 140.74 140.16 139.58 139.14 27,000 28,000 1,118 1.07%78.20%146.59 145.95 145.31 144.66 144.02 143.54 Monthly Customer Bills at Base Charge of: Page 4 of 8 City of Colleyville, Texas Water Rate Scenarios Water Scenario B Total % of Cumulative Customers Customers % of Customers $20.00 $21.00 $22.00 $23.00 $24.00 $24.75 Monthly Customer Bills at Base Charge of: 28,000 29,000 1,030 0.99%79.19%151.28 150.57 149.87 149.17 148.47 147.94 29,000 30,000 1,025 0.98%80.17%155.96 155.20 154.44 153.68 152.91 152.34 30,000 31,000 946 0.91%81.08%160.65 159.83 159.01 158.18 157.36 156.74 31,000 32,000 951 0.91%81.99%165.34 164.46 163.57 162.69 161.80 161.14 32,000 33,000 888 0.85%82.84%170.03 169.08 168.14 167.19 166.25 165.54 33,000 34,000 858 0.82%83.66%174.72 173.71 172.71 171.70 170.69 169.94 34,000 35,000 799 0.77%84.42%179.41 178.34 177.27 176.21 175.14 174.34 35,000 36,000 777 0.74%85.17%184.10 182.97 181.84 180.71 179.59 178.74 36,000 37,000 749 0.72%85.89%188.78 187.60 186.41 185.22 184.03 183.14 37,000 38,000 707 0.68%86.56%193.47 192.22 190.97 189.73 188.48 187.54 38,000 39,000 639 0.61%87.17%198.16 196.85 195.54 194.23 192.92 191.94 39,000 40,000 662 0.63%87.81%202.85 201.48 200.11 198.74 197.37 196.34 40,000 41,000 636 0.61%88.42%207.54 206.11 204.67 203.24 201.81 200.74 41,000 42,000 593 0.57%88.99%212.23 210.73 209.24 207.75 206.26 205.14 42,000 43,000 530 0.51%89.49%216.91 215.36 213.81 212.26 210.70 209.54 43,000 44,000 551 0.53%90.02%221.60 219.99 218.38 216.76 215.15 213.94 44,000 45,000 523 0.50%90.52%226.29 224.62 222.94 221.27 219.59 218.34 45,000 46,000 496 0.47%91.00%230.98 229.24 227.51 225.77 224.04 222.74 46,000 47,000 483 0.46%91.46%235.67 233.87 232.08 230.28 228.48 227.14 47,000 48,000 439 0.42%91.88%240.36 238.50 236.64 234.79 232.93 231.54 48,000 49,000 445 0.43%92.31%245.05 243.13 241.21 239.29 237.37 235.93 49,000 50,000 413 0.40%92.70%249.73 247.76 245.78 243.80 241.82 240.33 50,000 +7,622 7.30%100.00% Page 5 of 8 City of Colleyville, Texas Water Rate Scenarios Normalization of Tiered Rate Prior to:TRA Adjusted 8/1/2016 Normalization Rates RATES Meter Charge 1" and Less 13.55$ 0.42$ 13.97$ 1 1/2"15.57 0.42 15.99 2"20.29 0.42 20.71 3"33.20 0.42 33.62 4"51.27 0.42 51.69 Volumetric Charge 1,500 - 20,000 4.30$ 0.28$ 4.58$ 20,001 - 30,000 4.86 0.28 5.14 30,001 - 40,000 5.42 0.28 5.70 40,001 - 50,000 5.98 0.28 6.26 50,001 +6.54 0.28 6.82 TRA Rate (2016)3.89$ TRA Rate (2017)4.17 Variance 0.28$ Page 6 of 8 City of Colleyville, Texas Water Rate Scenarios Water Scenario B Customer Total % of Cumulative Bills Customers Customers % of Customers Normalized $20.00 $21.00 $22.00 $23.00 $24.00 $24.75 - - 1,138 1.09%1.09%13.97$ $6.03 $7.03 $8.03 $9.03 $10.03 $10.78 - 1,000 1,186 1.14%2.23%13.97 6.03 7.03 8.03 9.03 10.03 10.78 1,000 2,000 3,899 3.73%5.96%16.26 8.43 9.37 10.31 11.25 12.19 12.89 2,000 3,000 5,696 5.45%11.41%20.84 8.54 9.42 10.29 11.17 12.05 12.71 3,000 4,000 6,996 6.70%18.11%25.42 8.65 9.46 10.28 11.10 11.92 12.53 4,000 5,000 7,048 6.75%24.86%30.00 8.75 9.51 10.27 11.02 11.78 12.35 5,000 6,000 6,429 6.16%31.02%34.58 8.86 9.56 10.25 10.95 11.65 12.17 6,000 7,000 5,606 5.37%36.39%39.16 8.97 9.61 10.24 10.88 11.51 11.99 7,000 8,000 4,660 4.46%40.85%43.74 9.08 9.65 10.23 10.80 11.38 11.81 8,000 9,000 3,856 3.69%44.54%48.32 9.19 9.70 10.21 10.73 11.24 11.63 9,000 10,000 3,467 3.32%47.86%52.90 9.30 9.75 10.20 10.65 11.11 11.45 10,000 11,000 2,972 2.85%50.71%57.48 9.40 9.80 10.19 10.58 10.97 11.27 11,000 12,000 2,788 2.67%53.38%62.06 9.51 9.84 10.18 10.51 10.84 11.09 12,000 13,000 2,470 2.37%55.75%66.64 9.62 9.89 10.16 10.43 10.70 10.91 13,000 14,000 2,327 2.23%57.97%71.22 9.73 9.94 10.15 10.36 10.57 10.73 14,000 15,000 2,268 2.17%60.15%75.80 9.84 9.99 10.14 10.29 10.43 10.55 15,000 16,000 2,013 1.93%62.07%80.38 9.95 10.03 10.12 10.21 10.30 10.37 16,000 17,000 1,854 1.78%63.85%84.96 10.06 10.08 10.11 10.14 10.16 10.19 17,000 18,000 1,749 1.67%65.52%89.54 10.16 10.13 10.10 10.06 10.03 10.00 18,000 19,000 1,671 1.60%67.12%94.12 10.27 10.18 10.08 9.99 9.90 9.82 19,000 20,000 1,591 1.52%68.65%98.70 10.38 10.23 10.07 9.92 9.76 9.64 20,000 21,000 1,429 1.37%70.02%103.84 9.93 9.71 9.50 9.28 9.07 8.90 21,000 22,000 1,336 1.28%71.30%108.98 9.48 9.20 8.92 8.65 8.37 8.16 22,000 23,000 1,343 1.29%72.58%114.12 9.03 8.69 8.35 8.01 7.68 7.42 23,000 24,000 1,254 1.20%73.78%119.26 8.57 8.18 7.78 7.38 6.98 6.68 24,000 25,000 1,241 1.19%74.97%124.40 8.12 7.66 7.20 6.75 6.29 5.94 25,000 26,000 1,149 1.10%76.07%129.54 7.67 7.15 6.63 6.11 5.59 5.20 26,000 27,000 1,107 1.06%77.13%134.68 7.22 6.64 6.06 5.48 4.90 4.46 Variance in Monthly Customer Bill: Page 7 of 8 City of Colleyville, Texas Water Rate Scenarios Water Scenario B Customer Total % of Cumulative Bills Customers Customers % of Customers Normalized $20.00 $21.00 $22.00 $23.00 $24.00 $24.75 Variance in Monthly Customer Bill: 27,000 28,000 1,118 1.07%78.20%139.82 6.77 6.13 5.49 4.84 4.20 3.72 28,000 29,000 1,030 0.99%79.19%144.96 6.32 5.61 4.91 4.21 3.51 2.98 29,000 30,000 1,025 0.98%80.17%150.10 5.86 5.10 4.34 3.58 2.81 2.24 30,000 31,000 946 0.91%81.08%155.80 4.85 4.03 3.21 2.38 1.56 0.94 31,000 32,000 951 0.91%81.99%161.50 3.84 2.96 2.07 1.19 0.30 (0.36) 32,000 33,000 888 0.85%82.84%167.20 2.83 1.88 0.94 (0.01) (0.95) (1.66) 33,000 34,000 858 0.82%83.66%172.90 1.82 0.81 (0.19) (1.20) (2.21) (2.96) 34,000 35,000 799 0.77%84.42%178.60 0.81 (0.26) (1.33) (2.39) (3.46) (4.26) 35,000 36,000 777 0.74%85.17%184.30 (0.20) (1.33) (2.46) (3.59) (4.71) (5.56) 36,000 37,000 749 0.72%85.89%190.00 (1.22) (2.40) (3.59) (4.78) (5.97) (6.86) 37,000 38,000 707 0.68%86.56%195.70 (2.23) (3.48) (4.73) (5.97) (7.22) (8.16) 38,000 39,000 639 0.61%87.17%201.40 (3.24) (4.55) (5.86) (7.17) (8.48) (9.46) 39,000 40,000 662 0.63%87.81%207.10 (4.25) (5.62) (6.99) (8.36) (9.73) (10.76) 40,000 41,000 636 0.61%88.42%213.36 (5.82) (7.25) (8.69) (10.12) (11.55) (12.62) 41,000 42,000 593 0.57%88.99%219.62 (7.39) (8.89) (10.38) (11.87) (13.36) (14.48) 42,000 43,000 530 0.51%89.49%225.88 (8.97) (10.52) (12.07) (13.62) (15.18) (16.34) 43,000 44,000 551 0.53%90.02%232.14 (10.54) (12.15) (13.76) (15.38) (16.99) (18.20) 44,000 45,000 523 0.50%90.52%238.40 (12.11) (13.78) (15.46) (17.13) (18.81) (20.06) 45,000 46,000 496 0.47%91.00%244.66 (13.68) (15.42) (17.15) (18.89) (20.62) (21.92) 46,000 47,000 483 0.46%91.46%250.92 (15.25) (17.05) (18.84) (20.64) (22.44) (23.78) 47,000 48,000 439 0.42%91.88%257.18 (16.82) (18.68) (20.54) (22.39) (24.25) (25.64) 48,000 49,000 445 0.43%92.31%263.44 (18.39) (20.31) (22.23) (24.15) (26.07) (27.51) 49,000 50,000 413 0.40%92.70%269.70 (19.97) (21.94) (23.92) (25.90) (27.88) (29.37) 50,000 +7,622 7.30%100.00% Page 8 of 8