Beartooth Electric Cooperative Residential and Irrigation Bill - - PowerPoint PPT Presentation
Beartooth Electric Cooperative Residential and Irrigation Bill Impacts Analysis December 16, 2019 Russ Schneider, Senior Financial Analyst schneider@eesconsulting.com A registered professional engineering corporation with offices in Kirkland,
December 16, 2019
Russ Schneider, Senior Financial Analyst schneider@eesconsulting.com
A registered professional engineering corporation with
Telephone: (425) 889-2700 Facsimile: (425) 889-2725 www.eesconsulting.com
2
Select rate designs for specific analysis
Look at Irrigation Bill Impacts
3
4 RESIDENTIAL RATE DESIGNS Description Base Demand Energy ($/month) ($/kw) ($/kwh) 2-part Current Rates $33.50 $0.00 $0.08877 1-part All Energy $0.00 $0.00 $0.13001 2-part All Non-Energy Costs in Base $73.32 $0.00 $0.03976 3-part COSA 100% Demand $23.09 $9.64 $0.03976 3-part COSA 100% Demand w/ 60% Ratchet $23.09 $8.40 $0.03976 3-part $1/kw Demand $31.75 $1.00 $0.08451 3-part $2/kw Demand $30.00 $2.00 $0.08025 3-part $1/kw Demand w/ 60% Ratchet $31.75 $1.00 $0.08356 3-part $2/kw Demand w/ 60% Ratchet $30.00 $2.00 $0.07835
With a large part of revenue collection in the energy charge, there is
more variability both for members and for the cooperative from month- to-month based on changes in heating and cooling demands from weather events.
their annual average.
annual average.
revenues
5
The following slides show examples of twelve months of billing under
current and the four alternative rate designs under consideration.
Results show that overall bill variability narrows with a demand charge
for most members
This provides increase bill and revenue stability from both the Member
and Utility Steward Perspectives
6 3-part $1/kw Demand 3-part $2/kw Demand 3-part $1/kw Demand w/ 60% Ratchet 3-part $2/kw Demand w/ 60% Ratchet
7
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec RES #6 Current Bill $154.85 $187.52 $145.79 $112.86 $98.39 $63.15 $52.41 $42.38 $51.52 $86.58 $134.70 $155.29 RES #6 3-Part $1/kw Demand $152.03 $183.88 $143.41 $111.80 $98.03 $64.23 $55.50 $43.45 $53.16 $86.54 $133.59 $152.70 RES #6 3-Part $2/kw Demand $149.20 $180.24 $141.02 $110.75 $97.66 $65.30 $58.59 $44.53 $54.79 $86.49 $132.49 $150.11 RES #6 3-Part $1/kw Demand w/ 60% Ratchet $150.73 $182.23 $142.21 $110.95 $97.33 $63.91 $55.30 $43.56 $52.96 $85.97 $132.51 $151.40 RES #6 3-Part $2/kw Demand w/ 60% Ratchet $146.61 $176.94 $138.62 $109.05 $96.28 $64.67 $58.19 $44.74 $54.41 $85.36 $130.32 $147.50 $- $20.00 $40.00 $60.00 $80.00 $100.00 $120.00 $140.00 $160.00 $180.00 $200.00
Res #6 Bill Comp
Residential Sample Avg kWh Avg kW Avg Ratchet kW #6 829 4.7 4.7
8
Residential Sample Avg kWh Avg kW Avg Ratchet kW #7 919 7.2 7.2
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec RES #7 Current Bill $111.08 $181.04 $146.33 $111.08 $118.90 $103.10 $101.85 $88.00 $76.02 $80.37 $127.51 $135.23 RES #7 3-Part $1/kw Demand $112.86 $181.71 $147.16 $112.86 $120.55 $104.76 $103.07 $90.14 $78.48 $82.37 $128.75 $136.35 RES #7 3-Part $2/kw Demand $114.64 $182.38 $148.00 $114.64 $122.20 $106.42 $104.29 $92.27 $80.94 $84.37 $129.99 $137.47 RES #7 3-Part $1/kw Demand w/ 60% Ratchet $112.03 $180.13 $145.96 $112.03 $119.64 $104.01 $102.34 $89.56 $78.03 $81.87 $127.74 $135.26 RES #7 3-Part $2/kw Demand w/ 60% Ratchet $112.98 $179.22 $145.59 $112.98 $120.38 $104.93 $102.83 $91.11 $80.03 $83.37 $127.98 $135.29 $60.00 $80.00 $100.00 $120.00 $140.00 $160.00 $180.00 $200.00
Res #7 Bill Comp
9 $(80.00) $(60.00) $(40.00) $(20.00) $- $20.00 $40.00
3-Part $1/kw Demand $ 3-Part $2/kw Demand $ 3-Part $1/kw Demand w/ 60% Ratchet $ 3-Part $2/kw Demand w/ 60% Ratchet $
10 Average Bill Avg of Max Avg of Min Avg Spread Reduced Bill Spread to Current Bill ($) Reduced Bill Spread to Current Bill (%) Current Rate $149.33 $213.40 $88.82 $124.58
3-Part $1/kw Demand $150.02 $211.34 $89.54 $121.80 $(2.78)
3-Part $2/kw Demand $150.71 $209.84 $90.06 $119.78 $(4.80)
3-Part $1/kw Demand w/ 60% Ratchet $149.17 $209.79 $90.92 $118.87 $(5.71)
3-Part $2/kw Demand w/ 60% Ratchet $149.00 $206.37 $92.82 $113.56 $(11.02)
Ratchet Demand Charge of $2/kW reduces the average overall spread
the most, by 7.4%
All options for the sampled accounts result in similar bills overall
Monthly spread of bills (difference between highest bill and lowest bill)
goes down with each of the four alternative rate designs
A higher demand charge with a ratchet provides more monthly
consistency of than a simple demand charge
The reason for this is that the current 2-part rate collects more revenue
the bill
11
12 IRRIGATION RATE DESIGNS Description Base Demand Energy 6 Month Billing* ($/month) ($/kw) ($/kwh) 3-part Current Rates $121.80 $12.40 $0.05071 3-part Power & NWC Tx in Energy $121.80 $13.21 $0.04752 3-part Power & NWC Tx in Energy w/ 60% Ratchet $121.80 $10.46 $0.04752 12 Month Billing* 3-part Current Rates $60.90 $12.40 $0.05071 3-part Power & NWC Tx in Energy $60.90 $13.21 $0.04752 3-part Power & NWC Tx in Energy w/ 60% Ratchet $60.90 $6.09 $0.04752
Currently Irrigation pays for energy and demand in off-season on April
billing.
12-month and 6-month billing comparisons provided for each of the
irrigation member examples
*Demand Charge adjusted for 12 Month billing to be revenue neutral based on this sample
13
Description Base Demand Energy 6 Month Billing ($/month) ($/kw) ($/kwh)
3-part Power & NWC Tx in Energy
$121.80 $13.21 $0.04752
0.5%
0.4% 1.1% 0.0% 1.0%
0.0% 5.0% 10.0% 15.0% IRRIGATION #1 IRRIGATION #2 IRRIGATION #3 IRRIGATION #4 IRRIGATION #5 IRRIGATION #6 IRRIGATION #7 IRRIGATION #8
Irr Bill Impacts - Pow & Trans in Energy - 6 Month Billing
Power & NWE Tx in Energy 10%
14
Description Base Demand Energy 6 Month Billing ($/month) ($/kw) ($/kwh)
3-part Power & NWC Tx in Energy
w/ 60% Ratchet $121.80 $10.46 $0.04752
2.6% 25.8% 9.0% 0.0% 1.4%
10.3%
0.0% 5.0% 10.0% 15.0% 20.0% 25.0% 30.0% IRRIGATION #1 IRRIGATION #2 IRRIGATION #3 IRRIGATION #4 IRRIGATION #5 IRRIGATION #6 IRRIGATION #7 IRRIGATION #8
Irr Bill Impacts - Pow & Trans in Energy w/Ratchet - 6 Month Billing
Power & NWE Tx in Energy w/ 60% Ratchet 10%
15
Description Base Demand Energy 12 Month Billing ($/month) ($/kw) ($/kwh) 3-partPower & NWC Tx in Energy $60.90 $13.21 $0.04752
0.5%
0.4% 1.1% 0.0% 1.0%
0.0% 5.0% 10.0% 15.0% IRRIGATION #1 IRRIGATION #2 IRRIGATION #3 IRRIGATION #4 IRRIGATION #5 IRRIGATION #6 IRRIGATION #7 IRRIGATION #8
Irr Bill Impacts - Pow & Trans in Energy - 12 Month Billing
Power & NWE Tx in Energy 10%
16
Description Base Demand Energy
12 Month Billing ($/month) ($/kw) ($/kwh)
3-part Power & NWC Tx in Energy
w/ 60% Ratchet $60.90 $6.09 $0.04752
3.5% 29.3% 10.2%
0.7%
11.4%
0.0% 5.0% 10.0% 15.0% 20.0% 25.0% 30.0% 35.0% IRRIGATION #1 IRRIGATION #2 IRRIGATION #3 IRRIGATION #4 IRRIGATION #5 IRRIGATION #6 IRRIGATION #7 IRRIGATION #8
Irr Bill Impacts - Pow & Trans in Energy w/Ratchet - 12 Month Billing
Power & NWE Tx in Energy w/ 60% Ratchet 10%
17
18
Monthly Energy (kWh) Monthly Average Demand (kW) Monthly Average Ratchet Demand (kW) kWh Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec RES #0 128 0.2 0.2 124.00 134.00 144.00 131.00 132.00 119.00 119.00 117.00 115.00 131.00 128.00 138.00 RES #1 138 1.6 1.6 95.00 94.00 168.00 140.00 153.00 141.00 151.00 207.00 103.00 139.00 151.00 113.00 RES #2 171 5.3 5.3 238.00 253.00 227.00 144.00 158.00 93.00 110.00 110.00 112.00 161.00 213.00 230.00 RES #3 244 4.0 4.6 333.00 364.00 348.00 311.00 324.00 226.00 276.00 265.00 75.00 62.00 51.00 296.00 RES #4 357 4.3 6.7 362.00 226.00 447.00 484.00 550.00 492.00 148.00 75.00 284.00 377.00 420.00 416.00 RES #5 438 6.6 6.6 382.00 490.00 592.00 357.00 638.00 549.00 368.00 358.00 360.00 193.00 322.00 647.00 RES #6 829 4.7 4.7 1,367.00 1,735.00 1,265.00 894.00 731.00 334.00 213.00 100.00 203.00 598.00 1,140.00 1,372.00 RES #7 919 7.2 7.2 874.00 1,662.00 1,271.00 874.00 962.00 784.00 770.00 614.00 479.00 528.00 1,059.00 1,146.00 RES #8 1,106 7.0 7.0 1,828.00 1,174.00 1,084.00 1,159.00 1,102.00 888.00 865.00 936.00 827.00 964.00 1,137.00 1,309.00 RES #9 1,286 11.4 12.2 1,750.00 2,216.00 1,822.00 1,384.00 1,199.00 1,328.00 301.00 38.00 1,082.00 1,287.00 1,339.00 1,682.00 RES #10 1,974 9.8 9.9 3,338.00 3,437.00 3,183.00 1,936.00 1,265.00 969.00 665.00 650.00 891.00 1,342.00 2,547.00 3,469.00 RES #11 8,069 33.9 34.6 7,976.00 6,334.00 6,581.00 4,763.00 6,415.00 8,800.00 8,847.00 6,770.00 9,406.00 11,244.00 8,715.00 10,980.00 kW Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec RES #0
0.21 0.21 0.20 0.30 0.30 0.17 0.24 0.21 0.24 0.24 0.25 RES #1
1.00 1.50 1.95 2.02 2.02 1.42 1.73 1.00 1.00 2.00 1.75 RES #2
6.21 5.30 4.78 6.21 6.21 4.96 4.97 5.25 5.25 4.50 5.00 RES #3
4.00 5.50 5.25 0.75 5.25 6.00 5.25 1.75 3.50 1.00 5.25 RES #4
8.25 1.00 1.00 1.00 0.75 0.75 0.46 6.50 9.25 8.50 8.25 RES #5
7.00 6.75 5.75 7.50 5.75 5.75 5.50 7.25 7.25 7.25 6.50 RES #6
5.50 4.75 4.50 4.50 4.25 5.75 3.25 4.25 4.25 5.50 5.00 RES #7
9.50 8.00 7.25 7.50 6.75 6.25 6.50 6.25 6.00 7.50 7.75 RES #8
6.76 6.52 6.06 7.24 7.24 6.68 5.88 6.50 6.00 8.43 7.38 RES #9
11.75 13.25 12.75 11.00 12.75 9.25 0.37 11.50 15.25 11.75 14.25 RES #10
9.00 7.00 9.25 9.75 10.00 8.00 9.25 8.25 9.00 12.50 12.25 RES #11
30.00 33.00 19.75 44.25 36.50 24.25 31.00 36.75 32.00 40.50 39.75 kW Ratchet Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec RES #0
0.21 0.21 0.20 0.30 0.30 0.18 0.24 0.21 0.24 0.24 0.25 RES #1
1.21 1.50 1.95 2.02 2.02 1.42 1.73 1.21 1.21 2.00 1.75 RES #2
6.21 5.30 4.78 6.21 6.21 4.96 4.97 5.25 5.25 4.50 5.00 RES #3
4.00 5.50 5.25 3.60 5.25 6.00 5.25 3.60 3.60 3.60 5.25 RES #4
8.25 5.55 5.55 5.55 5.55 5.55 5.55 6.50 9.25 8.50 8.25
Part 4: $ Change in Bill Spread (High/Low) Compared to Current Billing
BEC Residential Monthly Bill Impacts Appendix
BEC Bill Impacts Draft 121119.xlsx
RES #5
7.00 6.75 5.75 7.50 5.75 5.75 5.50 7.25 7.25 7.25 6.50 RES #6
5.50 4.75 4.50 4.50 4.25 5.75 3.45 4.25 4.25 5.50 5.00 RES #7
9.50 8.00 7.25 7.50 6.75 6.25 6.50 6.25 6.00 7.50 7.75 RES #8
6.76 6.52 6.06 7.24 7.24 6.68 5.88 6.50 6.00 8.43 7.38 RES #9
11.75 13.25 12.75 11.00 12.75 9.25 9.15 11.50 15.25 11.75 14.25 RES #10
9.00 7.95 9.25 9.75 10.00 8.00 9.25 8.25 9.00 12.50 12.25 RES #11
30.00 33.00 26.55 44.25 36.50 26.55 31.00 36.75 32.00 40.50 39.75 Current Rate Average Avg of Max Avg of Min Avg Spread Reduced Bill Spread to Current Bill ($) Reduced Bill Spread to Current Bill (%) Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Current Bill 149.33 $ 213.40 $ 88.82 $ 124.58 $ RES #0 44.83 $ 46.28 $ 43.71 $ 2.57 $ 44.51 $ 45.40 $ 46.28 $ 45.13 $ 45.22 $ 44.06 $ 44.06 $ 43.89 $ 43.71 $ 45.13 $ 44.86 $ 45.75 $ RES #1 45.74 $ 51.88 $ 41.84 $ 10.03 $ 41.93 $ 41.84 $ 48.41 $ 45.93 $ 47.08 $ 46.02 $ 46.90 $ 51.88 $ 42.64 $ 45.84 $ 46.90 $ 43.53 $ RES #2 48.66 $ 55.96 $ 41.76 $ 14.20 $ 54.63 $ 55.96 $ 53.65 $ 46.28 $ 47.53 $ 41.76 $ 43.26 $ 43.26 $ 43.44 $ 47.79 $ 52.41 $ 53.92 $ RES #3 55.18 $ 65.81 $ 38.03 $ 27.79 $ 63.06 $ 65.81 $ 64.39 $ 61.11 $ 62.26 $ 53.56 $ 58.00 $ 57.02 $ 40.16 $ 39.00 $ 38.03 $ 59.78 $ RES #4 65.17 $ 82.32 $ 40.16 $ 42.17 $ 65.63 $ 53.56 $ 73.18 $ 76.46 $ 82.32 $ 77.17 $ 46.64 $ 40.16 $ 58.71 $ 66.97 $ 70.78 $ 70.43 $ RES #5 72.38 $ 90.93 $ 50.63 $ 40.30 $ 67.41 $ 77.00 $ 86.05 $ 65.19 $ 90.14 $ 82.23 $ 66.17 $ 65.28 $ 65.46 $ 50.63 $ 62.08 $ 90.93 $ RES #6 107.12 $ 187.52 $ 42.38 $ 145.14 $ 154.85 $ 187.52 $ 145.79 $ 112.86 $ 98.39 $ 63.15 $ 52.41 $ 42.38 $ 51.52 $ 86.58 $ 134.70 $ 155.29 $ RES #7 115.04 $ 181.04 $ 76.02 $ 105.01 $ 111.08 $ 181.04 $ 146.33 $ 111.08 $ 118.90 $ 103.10 $ 101.85 $ 88.00 $ 76.02 $ 80.37 $ 127.51 $ 135.23 $ RES #8 131.69 $ 195.77 $ 106.91 $ 88.86 $ 195.77 $ 137.72 $ 129.73 $ 136.38 $ 131.32 $ 112.33 $ 110.29 $ 116.59 $ 106.91 $ 119.07 $ 134.43 $ 149.70 $ RES #9 147.63 $ 230.21 $ 36.87 $ 193.34 $ 188.85 $ 230.21 $ 195.24 $ 156.36 $ 139.94 $ 151.39 $ 60.22 $ 36.87 $ 129.55 $ 147.75 $ 152.36 $ 182.81 $ RES #10 208.76 $ 341.44 $ 91.20 $ 250.24 $ 329.81 $ 338.60 $ 316.05 $ 205.36 $ 145.79 $ 119.52 $ 92.53 $ 91.20 $ 112.59 $ 152.63 $ 259.60 $ 341.44 $ RES #11 749.81 $ 1,031.63 $ 456.31 $ 575.32 $ 741.53 $ 595.77 $ 617.70 $ 456.31 $ 602.96 $ 814.68 $ 818.85 $ 634.47 $ 868.47 $ 1,031.63 $ 807.13 $ 1,008.19 $ Rate Option Rate Option Averages 3-Part $1/kw Demand 150.02 $ 211.34 $ 89.54 $ 121.80 $ (2.78) $
RES #0 42.77 $ 44.13 $ 41.68 $ 2.45 $ (0.13) $
42.47 $ 43.28 $ 44.13 $ 43.02 $ 43.21 $ 42.11 $ 41.98 $ 41.88 $ 41.68 $ 43.06 $ 42.80 $ 43.67 $ RES #1 44.96 $ 50.97 $ 40.69 $ 10.28 $ 0.25 $ 0.55% 41.03 $ 40.69 $ 47.45 $ 45.53 $ 46.70 $ 45.69 $ 45.93 $ 50.97 $ 41.45 $ 44.50 $ 46.51 $ 43.05 $ RES #2 51.43 $ 59.34 $ 45.82 $ 13.52 $ (0.68) $
56.22 $ 59.34 $ 56.23 $ 48.70 $ 51.31 $ 45.82 $ 46.01 $ 46.02 $ 46.47 $ 50.61 $ 54.25 $ 56.19 $ RES #3 56.41 $ 66.66 $ 37.06 $ 29.60 $ 1.81 $ 3.22% 64.64 $ 66.51 $ 66.66 $ 63.28 $ 59.88 $ 56.10 $ 61.08 $ 59.40 $ 39.84 $ 40.49 $ 37.06 $ 62.02 $ RES #4 66.19 $ 79.23 $ 38.55 $ 40.68 $ (1.48) $
68.09 $ 59.10 $ 70.53 $ 73.65 $ 79.23 $ 74.08 $ 45.01 $ 38.55 $ 62.25 $ 72.86 $ 75.74 $ 75.16 $ RES #5 75.39 $ 93.17 $ 55.31 $ 37.86 $ (2.44) $
71.28 $ 80.16 $ 88.53 $ 67.67 $ 93.17 $ 83.90 $ 68.60 $ 67.50 $ 69.42 $ 55.31 $ 66.21 $ 92.93 $ RES #6 106.53 $ 183.88 $ 43.45 $ 140.43 $ (4.71) $
152.03 $ 183.88 $ 143.41 $ 111.80 $ 98.03 $ 64.23 $ 55.50 $ 43.45 $ 53.16 $ 86.54 $ 133.59 $ 152.70 $ RES #7 116.59 $ 181.71 $ 78.48 $ 103.23 $ (1.79) $
112.86 $ 181.71 $ 147.16 $ 112.86 $ 120.55 $ 104.76 $ 103.07 $ 90.14 $ 78.48 $ 82.37 $ 128.75 $ 136.35 $ RES #8 132.18 $ 195.02 $ 108.14 $ 86.88 $ (1.98) $
195.02 $ 137.73 $ 129.88 $ 135.76 $ 132.12 $ 114.04 $ 111.53 $ 116.73 $ 108.14 $ 119.22 $ 136.27 $ 149.75 $ RES #9 151.85 $ 230.78 $ 35.33 $ 195.44 $ 2.10 $ 1.39% 193.14 $ 230.78 $ 198.98 $ 161.46 $ 144.08 $ 156.73 $ 66.44 $ 35.33 $ 134.69 $ 155.77 $ 156.66 $ 188.15 $ RES #10 208.39 $ 337.17 $ 95.93 $ 241.24 $ (9.01) $
327.10 $ 331.21 $ 307.75 $ 204.61 $ 148.41 $ 123.64 $ 95.95 $ 95.93 $ 115.30 $ 154.16 $ 259.50 $ 337.17 $ RES #11 747.56 $ 1,013.99 $ 454.03 $ 559.97 $ (15.35) $
744.56 $ 597.04 $ 620.92 $ 454.03 $ 618.14 $ 811.95 $ 803.67 $ 634.89 $ 863.41 $ 1,013.99 $ 808.76 $ 999.43 $ Rate Option Rate Option Averages 3-Part $2/kw Demand 150.71 $ 209.84 $ 90.06 $ 119.78 $ (4.80) $
RES #0 40.71 $ 41.98 $ 39.65 $ 2.32 $ (0.25) $
40.43 $ 41.17 $ 41.98 $ 40.91 $ 41.19 $ 40.15 $ 39.89 $ 39.87 $ 39.65 $ 41.00 $ 40.74 $ 41.58 $ BEC Bill Impacts Draft 121119.xlsx
RES #1 44.17 $ 50.07 $ 39.54 $ 10.53 $ 0.50 $ 1.13% 40.12 $ 39.54 $ 46.48 $ 45.14 $ 46.32 $ 45.36 $ 44.96 $ 50.07 $ 40.27 $ 43.16 $ 46.12 $ 42.57 $ RES #2 54.20 $ 62.72 $ 48.75 $ 13.98 $ (0.23) $
57.82 $ 62.72 $ 58.82 $ 51.12 $ 55.10 $ 49.88 $ 48.75 $ 48.77 $ 49.49 $ 53.42 $ 56.09 $ 58.46 $ RES #3 57.64 $ 68.93 $ 36.09 $ 32.83 $ 5.05 $ 8.76% 66.22 $ 67.21 $ 68.93 $ 65.46 $ 57.50 $ 58.64 $ 64.15 $ 61.77 $ 39.52 $ 41.98 $ 36.09 $ 64.25 $ RES #4 67.21 $ 80.71 $ 36.94 $ 43.77 $ 1.60 $ 2.38% 70.55 $ 64.64 $ 67.87 $ 70.84 $ 76.14 $ 70.98 $ 43.38 $ 36.94 $ 65.79 $ 78.75 $ 80.71 $ 79.88 $ RES #5 78.40 $ 96.20 $ 59.99 $ 36.21 $ (4.09) $
75.16 $ 83.32 $ 91.01 $ 70.15 $ 96.20 $ 85.56 $ 71.03 $ 69.73 $ 73.39 $ 59.99 $ 70.34 $ 94.92 $ RES #6 105.93 $ 180.24 $ 44.53 $ 135.71 $ (9.43) $
149.20 $ 180.24 $ 141.02 $ 110.75 $ 97.66 $ 65.30 $ 58.59 $ 44.53 $ 54.79 $ 86.49 $ 132.49 $ 150.11 $ RES #7 118.13 $ 182.38 $ 80.94 $ 101.44 $ (3.58) $
114.64 $ 182.38 $ 148.00 $ 114.64 $ 122.20 $ 106.42 $ 104.29 $ 92.27 $ 80.94 $ 84.37 $ 129.99 $ 137.47 $ RES #8 132.68 $ 194.26 $ 109.37 $ 84.89 $ (3.97) $
194.26 $ 137.74 $ 130.03 $ 135.13 $ 132.92 $ 115.74 $ 112.78 $ 116.88 $ 109.37 $ 119.36 $ 138.11 $ 149.81 $ RES #9 156.07 $ 231.34 $ 33.79 $ 197.55 $ 4.21 $ 2.70% 197.44 $ 231.34 $ 202.72 $ 166.57 $ 148.22 $ 162.07 $ 72.66 $ 33.79 $ 139.83 $ 163.78 $ 160.96 $ 193.48 $ RES #10 208.03 $ 332.89 $ 99.37 $ 233.53 $ (16.72) $
324.38 $ 323.83 $ 299.44 $ 203.87 $ 151.02 $ 127.76 $ 99.37 $ 100.66 $ 118.00 $ 155.70 $ 259.40 $ 332.89 $ RES #11 745.32 $ 996.35 $ 451.74 $ 544.61 $ (30.71) $
747.59 $ 598.32 $ 624.14 $ 451.74 $ 633.32 $ 809.22 $ 788.49 $ 635.31 $ 858.35 $ 996.35 $ 810.40 $ 990.67 $ Rate Option Rate Option Averages 3-Part $1/kw Demand w/ 60% Ratchet 149.17 $ 209.79 $ 90.92 $ 118.87 $ (5.71) $
RES #0 42.65 $ 43.99 $ 41.57 $ 2.42 $ (0.15) $
42.35 $ 43.16 $ 43.99 $ 42.90 $ 43.08 $ 41.99 $ 41.87 $ 41.77 $ 41.57 $ 42.94 $ 42.68 $ 43.54 $ RES #1 44.88 $ 50.78 $ 40.82 $ 9.96 $ (0.07) $
40.94 $ 40.82 $ 47.29 $ 45.40 $ 46.55 $ 45.55 $ 45.79 $ 50.78 $ 41.57 $ 44.58 $ 46.37 $ 42.94 $ RES #2 51.27 $ 59.10 $ 45.73 $ 13.37 $ (0.83) $
56.00 $ 59.10 $ 56.02 $ 48.56 $ 51.16 $ 45.73 $ 45.90 $ 45.91 $ 46.36 $ 50.45 $ 54.05 $ 55.97 $ RES #3 56.80 $ 66.33 $ 39.61 $ 26.72 $ (1.07) $
64.33 $ 66.17 $ 66.33 $ 62.99 $ 62.42 $ 55.88 $ 60.81 $ 59.14 $ 41.62 $ 40.53 $ 39.61 $ 61.73 $ RES #4 68.21 $ 83.26 $ 43.57 $ 39.69 $ (2.47) $
67.75 $ 58.88 $ 74.65 $ 77.74 $ 83.26 $ 78.41 $ 49.67 $ 43.57 $ 61.98 $ 72.50 $ 75.35 $ 74.76 $ RES #5 74.98 $ 92.56 $ 55.13 $ 37.43 $ (2.87) $
70.92 $ 79.70 $ 87.97 $ 67.33 $ 92.56 $ 83.38 $ 68.25 $ 67.17 $ 69.08 $ 55.13 $ 65.91 $ 92.31 $ RES #6 105.75 $ 182.23 $ 43.56 $ 138.67 $ (6.47) $
150.73 $ 182.23 $ 142.21 $ 110.95 $ 97.33 $ 63.91 $ 55.30 $ 43.56 $ 52.96 $ 85.97 $ 132.51 $ 151.40 $ RES #7 115.72 $ 180.13 $ 78.03 $ 102.10 $ (2.91) $
112.03 $ 180.13 $ 145.96 $ 112.03 $ 119.64 $ 104.01 $ 102.34 $ 89.56 $ 78.03 $ 81.87 $ 127.74 $ 135.26 $ RES #8 131.13 $ 193.28 $ 107.36 $ 85.93 $ (2.93) $
193.28 $ 136.61 $ 128.85 $ 134.66 $ 131.08 $ 113.19 $ 110.71 $ 115.84 $ 107.36 $ 118.30 $ 135.19 $ 148.51 $ RES #9 151.36 $ 228.67 $ 44.08 $ 184.60 $ (8.74) $
191.48 $ 228.67 $ 197.25 $ 160.15 $ 142.94 $ 155.47 $ 66.15 $ 44.08 $ 133.66 $ 154.54 $ 155.39 $ 186.55 $ RES #10 206.60 $ 333.88 $ 95.32 $ 238.56 $ (11.68) $
323.93 $ 327.95 $ 305.68 $ 202.78 $ 147.21 $ 122.72 $ 95.32 $ 95.32 $ 114.45 $ 152.89 $ 257.08 $ 333.88 $ RES #11 740.66 $ 1,003.32 $ 456.30 $ 547.01 $ (28.30) $
736.99 $ 591.03 $ 614.67 $ 456.30 $ 612.05 $ 803.59 $ 797.57 $ 628.46 $ 854.48 $ 1,003.32 $ 800.49 $ 989.01 $ Rate Option Rate Option Averages 3-Part $2/kw Demand w/ 60% Ratchet 149.00 $ 206.37 $ 92.82 $ 113.56 $ (11.02) $
RES #0 40.47 $ 41.70 $ 39.44 $ 2.27 $ (0.31) $
40.20 $ 40.92 $ 41.70 $ 40.66 $ 40.94 $ 39.92 $ 39.68 $ 39.65 $ 39.44 $ 40.75 $ 40.50 $ 41.32 $ RES #1 44.02 $ 49.68 $ 39.79 $ 9.89 $ (0.14) $
39.94 $ 39.79 $ 46.16 $ 44.87 $ 46.03 $ 45.09 $ 44.67 $ 49.68 $ 40.49 $ 43.32 $ 45.83 $ 42.35 $ RES #2 53.88 $ 62.24 $ 48.54 $ 13.70 $ (0.50) $
57.37 $ 62.24 $ 58.39 $ 50.84 $ 54.80 $ 49.71 $ 48.54 $ 48.56 $ 49.28 $ 53.11 $ 55.69 $ 58.02 $ RES #3 58.41 $ 68.27 $ 41.20 $ 27.07 $ (0.71) $
65.59 $ 66.52 $ 68.27 $ 64.87 $ 62.59 $ 58.21 $ 63.63 $ 61.26 $ 43.08 $ 42.06 $ 41.20 $ 63.69 $ RES #4 71.25 $ 84.19 $ 46.98 $ 37.22 $ (4.95) $
69.86 $ 64.21 $ 76.12 $ 79.02 $ 84.19 $ 79.65 $ 52.70 $ 46.98 $ 65.25 $ 78.04 $ 79.91 $ 79.10 $ RES #5 77.57 $ 94.99 $ 59.62 $ 35.37 $ (4.93) $
74.43 $ 82.39 $ 89.89 $ 69.47 $ 94.99 $ 84.52 $ 70.33 $ 69.05 $ 72.71 $ 59.62 $ 69.73 $ 93.69 $ RES #6 104.39 $ 176.94 $ 44.74 $ 132.21 $ (12.93) $
146.61 $ 176.94 $ 138.62 $ 109.05 $ 96.28 $ 64.67 $ 58.19 $ 44.74 $ 54.41 $ 85.36 $ 130.32 $ 147.50 $ RES #7 116.39 $ 179.22 $ 80.03 $ 99.19 $ (5.82) $
112.98 $ 179.22 $ 145.59 $ 112.98 $ 120.38 $ 104.93 $ 102.83 $ 91.11 $ 80.03 $ 83.37 $ 127.98 $ 135.29 $ RES #8 130.58 $ 190.79 $ 107.80 $ 82.99 $ (5.87) $
190.79 $ 135.51 $ 127.98 $ 132.93 $ 130.83 $ 114.06 $ 111.14 $ 115.10 $ 107.80 $ 117.53 $ 135.95 $ 147.32 $ RES #9 155.09 $ 227.13 $ 51.28 $ 175.85 $ (17.49) $
194.12 $ 227.13 $ 199.26 $ 163.94 $ 145.95 $ 159.55 $ 72.08 $ 51.28 $ 137.78 $ 161.34 $ 158.42 $ 190.29 $ RES #10 204.44 $ 326.31 $ 98.11 $ 228.20 $ (22.04) $
318.04 $ 317.30 $ 295.30 $ 200.19 $ 148.62 $ 125.92 $ 98.11 $ 99.43 $ 116.31 $ 153.15 $ 254.57 $ 326.31 $ RES #11 731.52 $ 975.01 $ 456.30 $ 518.71 $ (56.61) $
732.45 $ 586.29 $ 611.64 $ 456.30 $ 621.14 $ 792.51 $ 776.29 $ 622.45 $ 840.49 $ 975.01 $ 793.85 $ 969.82 $ BEC Bill Impacts Draft 121119.xlsx
12-Monthly Energy (kWh) 12-Monthly Average Demand (kW) 12-Monthly Average Ratchet Demand (kW) 6-Monthly Energy (kWh) 6-Monthly Average Demand (kW) 6-Monthly Average Ratchet Demand (kW) Load Factor Current Rates Power & NWE Tx in Energy Power & NWE Tx in Energy w/ 60% Ratchet 12-month billing Current Rates Power & NWE Tx in Energy Power & NWE Tx in Energy w/ 60% Ratchet Facilities Charge $121.80 $121.80 $121.80 $ 60.90 $ 60.90 $ 60.90 Demand Charge (/kW) $12.40 $13.21 $10.46 $12.40 $13.21 $6.09 Energy Charge (/kwh) $ 0.05071 $ 0.04752 $ 0.04752 $ 0.05071 $ 0.04752 $ 0.04752 IRRIGATION #1 815 4.15 9.75 1,630 8.29 11.09 27% 1,843.69 $ 1,852.76 $ 1,891.93 $ 1,843.69 $ 1,852.76 $ 1,907.80 $ IRRIGATION #2 1,294 4.96 19.83 2,588 9.92 21.82 36% 2,256.08 $ 2,254.70 $ 2,838.39 $ 2,256.08 $ 2,254.70 $ 2,918.12 $ IRRIGATION #3 1,919 8.76 23.30 3,839 17.51 26.51 30% 3,201.74 $ 3,213.32 $ 3,489.48 $ 3,201.74 $ 3,213.32 $ 3,528.30 $ IRRIGATION #4 2,290 14.00 29.29 4,579 28.00 34.58 22% 4,207.21 $ 4,255.54 $ 4,207.51 $ 4,207.21 $ 4,255.54 $ 4,176.94 $ IRRIGATION #5 5,357 21.25 46.75 10,714 42.50 55.25 35% 7,152.69 $ 7,154.02 $ 7,254.23 $ 7,152.69 $ 7,154.02 $ 7,202.02 $ IRRIGATION #6 8,810 48.00 89.83 17,620 96.00 103.33 25% 13,234.26 $ 13,363.22 $ 12,241.90 $ 13,234.26 $ 13,363.22 $ 12,319.46 $ IRRIGATION #7 16,897 62.93 109.23 33,793 125.87 132.07 37% 20,377.24 $ 20,341.69 $ 18,657.12 $ 20,377.24 $ 20,341.69 $ 18,348.52 $ IRRIGATION #8 15,193 43.17 121.47 30,387 86.33 138.53 48% 16,399.45 $ 16,237.11 $ 18,091.79 $ 16,399.45 $ 16,237.11 $ 18,271.20 $ Total 68,672.36 $ 68,672.36 $ 68,672.36 $ 68,672.36 $ 68,672.36 $ 68,672.36 $ 0.00% 0.00% 0.00% 0.00% 0.00% 10%
Power & NWE Tx in Energy Power & NWE Tx in Energy w/ 60% Ratchet 12-month billing Current Rates Power & NWE Tx in Energy Power & NWE Tx in Energy w/ 60% Ratchet IRRIGATION #1 10%
0.5% 2.6% 0.0% 0.5% 3.5% IRRIGATION #2 10%
25.8% 0.0%
29.3% IRRIGATION #3 10%
0.4% 9.0% 0.0% 0.4% 10.2% IRRIGATION #4 10%
1.1% 0.0% 0.0% 1.1%
IRRIGATION #5 10%
0.0% 1.4% 0.0% 0.0% 0.7% IRRIGATION #6 10%
1.0%
0.0% 1.0%
IRRIGATION #7 10%
0.0%
IRRIGATION #8 10%
10.3% 0.0%
11.4%
BEC Irrigation Bill Impacts Appendix
Part 1: Monthly Loads and Annual Bills
BEC Irrigation Bill Impacts Appendix
Part 2: % Change Annual Bills
BEC Bill Impacts Draft 121119.xlsx Page 1
Average change 10%
0.2% 4.2% 0.0% 0.2% 4.7% Max change 10%
1.1% 25.8% 0.0% 1.1% 29.3% Min change 10%
0.0%
Power & NWE Tx in Energy Power & NWE Tx in Energy w/ 60% Ratchet 12-month billing Current Rates Power & NWE Tx in Energy Power & NWE Tx in Energy w/ 60% Ratchet IRRIGATION #1 9.07 $ 48.24 $
9.07 $ 64.11 $ IRRIGATION #2 (1.38) $ 582.32 $
(1.38) $ 662.04 $ IRRIGATION #3 11.58 $ 287.73 $
11.58 $ 326.56 $ IRRIGATION #4 48.34 $ 0.31 $
48.34 $ (30.26) $ IRRIGATION #5 1.33 $ 101.54 $
1.33 $ 49.33 $ IRRIGATION #6 128.96 $ (992.36) $
128.96 $ (914.80) $ IRRIGATION #7 (35.55) $ (1,720.11) $
(35.55) $ (2,028.72) $ IRRIGATION #8 (162.34) $ 1,692.35 $
(162.34) $ 1,871.75 $ Average change 0.00 $ 0.00 $
0.00 $ (0.00) $ Max change 128.96 $ 1,692.35 $
128.96 $ 1,871.75 $ Min change (162.34) $ (1,720.11) $
(162.34) $ (2,028.72) $
Part 3: $ Change Annual Bills
BEC Irrigation Bill Impacts Appendix
BEC Bill Impacts Draft 121119.xlsx Page 2