GAS ADJUSTMENTS EFFECTIVE MAY 1, 2016CLEARWATER GAS SYSTEM
Interoffice Correspondence Sheet
TO: William B. Horne II, City Manager
FROM: Chuck Warrington, Managing Director
COPIES: Rosemarie Call, City Clerk;
CGS & UCS Management Teams; Janet Dorrough, Sr. Accountant/CGS;
Laura Damico, Sr. Accountant/CCS; Lynne Priester, Cust. Serv_ Coord./UCS;
Lindsey Bessette, Systems Analyst/UCS
SUBJECT: GAS ADJLSTMENTS EFFECTIVE MAY 1, 2016
DATE: April 19, 2016
Gas supply prices have continued to fall over the past few months; therefore, we are recommending
another decrease of 8¢ per therm in our Natural Gas Purchase Gas Adjustment (PGA) and another
decrease of 15¢ per gallon in our Propane (LP) PGA for May. We recommend that we continue our
standard Contract LP PGA be set at 30¢ below our Standard LP PGA.
We are recommending a 3¢ per therm or gallon increase in our Energy Conservation Adjustment
(ECA) and a 2¢ per therm or gallon increase in our Regulatory Imposition Adjustment (RIA). We are
recommending no change in our Usage & Inflation Adjustments (UTAs) for May.
The net effect of these recommended changes for May is another 3¢ per therm ( -2.1 %) reduction
in our typical Residential Natural Gas customer's rate and another 10¢ per gallon reduction (-
3.7%) in our typical Residential LP customer's rate.
Therefore, we are recommending your approval of the following rates to become effective for billings
rendered on and after May 1, 2016:
Natural Gas Firm Standard Rate Schedule PGA S0.62 per therm (down 8¢ per them)
Natural Gas Interruptible and Contract
(Non- Standard) Rate Schedule PGA
Propane (LP) Gas Standard Rate Schedule PGA
Propane (LP) Gas Contract Rate Schedule PGA
Energy Conservation Adjustment (ECA)
Regulatory Imposition Adjustment (EIA)
Usage & Inflation Adjustment (CIA) - Residential
- Commercial
S0.53 per theiin (down 8¢ per therm)
$1.25 per gallon (down 15¢ per gallon)
50.95 per gallon (down 15¢ per gallon)
S0.19 per theini or gallon (up 30)
S0.12 per therm or gallon (up 2¢)
S0.01 per therm or gallon (no change)
S0.01 per therm or gallon (no change)
William B. Horne 11, City Manager April 18, 2016
Page 2
Attachment #1 shows the status of our Adjustment Recovery Clause balances with actuals thru March.
Our objective is to be as close as practical to balance by FY ending. Attachments #2 and #3 show our
annual projections for Natural Gas and LP supply costs, respectively. Attachments #4 and #5 show
the impact of these adjustment clause changes on our overall Natural and LP Gas rates, respectively.
Attachment #6, Page #1 shows our monthly rate history over the past 2- years, and Pages #2 and #3
of this show our 14 year relationship to electric prices and average residential rates, respectively.
Please note that Page #2 of this analysis shows that, over the past 14 years, our residential
natural gas rates have risen just 17.2% as compared to a 58.8% increase for the Duke Energy
(formerly Progress Energy Florida /FPC) residential rates. That's an average annual increase
of 1.2% /year for natural gas vs. 4.2% /year for electric - -- our natural gas rates increased only
29% of the electric growth rate - -- a remarkable difference!
I should point out that the overall effect is that our typical Residential customer rates are now
approximately 61% lower than electric for Natural Gas and 20% lower than electric for our
typical LP Residential rates. This is a very attractive competitive position vs. electric rates for our
Natural Gas customers and these numbers are even lower if the customer uses a tankless gas water
heater, which is what most of our customers are electing.
We will continue to track these balances each month, make monthly projections of these factors based
on market conditions, and let you know if any of these get significantly out of balance.
Additionally, we lowered our standard posted price at our Natural Gas Vehicle (NGV) Fueling
Station effective January 1, 2016, to S1.17 per gasoline gallon equivalent (GGE) - -- a remarkable
savings from the gas station prices around town and the lowest posted NGV price in the State and
we believe the Southeast L.S. For our City and other governmental fleet vehicles, our new price is
S0.98 /gge, as these fleets pay no Federal taxes on fuel - -- an amazing price. This is as a result of
the Congress passing the Tax Extender package, which re- enacted the 50¢ /gge Excise Tax Credit
for NGV vehicle fuel. We had previously been applying only a 20¢ /gge credit from past credits, so
we are now able to pass along an additional 30¢ /gge credit.
Bill, I would appreciate your approval of these revised adjustment rates so we can get this information
to UCS in order to make the appropriate adjustments in the billing formulas in time for the May 1st
billings. If you have any questions on this, please call me.
CSW /csw
Attachments
Approved:
WALLA; A, 6, I44Lw,L-
William 13. Home II, City Manager
U:AMy Documents \MSOFFICE \VVINWORC'..GASRATES \Gas Adjustments for May 2016.docx
CLEARWATER GAS SYSTEM
SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTIONS FOR FY 2015/2016
Attachment #1
Page 1 of 4
NATURAL GAS PURCHASED GAS ADJUSTMENT (PGA -NG)
Budget Reservation Commodity Interest Cost Center
Month Charges Charges Expense Expenses
Prior Year
Oct 15 $ 4,258,968.39 1,394,849.81 r- 849.81 S 1,116.02 $ 30,980.02
Nov 15 $ 143,902.27 624,216.04 ; $ 22,345.55 $ 38,824.42
Dec -15 $ 164,606.17 636,906.60 . $ 20,263.03 $ - 38,408.72 '
'0 S 159,338.19 669,592.22 $ 16,896.71 $ 38;899.07
i eb -16 S 168,766.72 775,681.55 $ 12,598.00 I $ 42,584.88
Mar -16 S 168,766 72 774 882.52 $ 8 275.22 $ 39,544.88
Apr -16 S 145,000.00 625,000.00 $ 4,061.68 $ 45,000.00. $ 819,061 68 1,364,310.89 7 $ 545,249.21 $ (267,086.88)
May 16 S 100,000.00 600,000.00 ' $ - : $ 45,000.00 $ 745,000.00 1,093 043.36 $ 348 043.36 ' $ 80,956.48
Jun -1(3 S 95,000.00 550 000.00 $ - $ 45,000.00 $ 690,000.00 1,021 638.52 S 331 638.52 S 412,595.00
Jui -16 S 95,000.00 550,000.00 5 _ $ 45,000.00 $ 690,000.00 994,175.11 $ 304175.11 5 716,770.11
Aug -16 $ 95,000.00 525,000.00 $ - $ 45,000.00 $ 665,000.00 977,697.07 ' $ 312,697.07 $ 1,029,467.19
$ 45,000 00 $ 665,000.00 977 697.07 $ 312,697.07 $ 1,342,164.26
Sep-16 S 95,000.00 525,000.00 ' S - $ 1,247,224.37 4 -7 $ 1,247,224.37 $ (1,247,224.37) $ 94,939.89
eta! Yl1) S 5.689,348.46 S 8,251,128.74 $ 85,556.21 1 $ 1,746,466.36 I, $ 15,772,499.77 $ 16,090,643.42 i $ 318,143.65
(1) Includes Annual Admin Charge of $713,080 + CCS chg of $1,225,960 + Dividend $2,203,550
f NY 14/15 PGA write off of $11,582.91 + WNA $313.27 = $ 4,154,486.18 (5) Pension Adjustment = $
(2) Additional Dividend based on FY 15/16 Net Income = . $ - i (6) , Accrual = $
(3) Bulk mailing & printing
Monthly Cumulative
Total NG Fuel Total NG PGA Overage YTD Overage
Expenses Billed (Shortage) (Shortage)
$ (223,203.76)
5,685,914.24 ; $ 7 (4 829,288.28 1,245,793.01 $ 416,504.773)' $ (4,052,606.12)
860,184.52 ! 1,533,448.77 $ 673,264.25 $ (3,379,341.87)
884,726.19 1,744,468.09 $ 859,741.90 $ (2,519,599.97)
999,631.15 1,864,187.13 $ 864,555.98 $ (1,655,043.99)
$ 991,469.34 I 1,834,177.25 $ 842,707.91 ' $ (812,336.08)
NG PGA
Rate /Therm
Firm /Contr
0.88/0.79
0.88/0.79
0.88/0.79
0.88/0.79
0.85/0.76
0.85/0.76
0.70/0.61
0.62/0.53
0.62/0.53
0.62_/0.53
0.62/0.53
0.62/0.53
$ - (7) Commodity adjustment from FYE transfer of ECA Collected in PGA @ Annual ECA Shortfall
(4) OPE3 liability & Period 13 Adjustment S NG Proportion = 98.5% x Total ECA Transfer = $ 1,247,224.37
Net RC = S 1,534,862.28 Average Annual PGA/Therm = $0.672 - Avg Fuel Only = $0.344
Delta /Therm = 50.327
PROPANE (LP) GAS PURCHASED GAS ADJUSTMENT (PGA -LP)
Gallons Monthly
Sold WACOG
Lsudget
Month
Prior Year
flu; 15
)..C15
an 16
(30 16
Mar -16
Apr -16
May 15
Jun -16
,i -16
Aug -? 6
Sep-16
;'13
T eta! Y 1 )
38,021.1
25,166.3
28,1 15.6
34,825.9
45,153.3
39,650.8
31,000.0
26,000.0
25,500.0
2.5,500.0
25.500.0
25,500.0
S
S
S
S
S_
S
$
S
S
Interest
Expense
0.66815 S
0.67183 S 697.63
0.65512 $ 582.2.4
0.62029 S 451.30
0.62107 S 280.85
0.64976 $ 78.67
0.65000 $
0.65000 $
0.67000 $
0.68000 $
0.68000 S
0.71000 $
Commodity
Charges
5 25,403.80
16,907.48
18,419.09
21,602.16
28,043.36
25,763.50
20,150.00
16, 900.00
17, 085.00
17, 340.00
17,340.00
18,105.00
LP Fuel
Expenses
273,746.55 S
17,605.10
19,001.33
22,053.46
28,324.21
25,842.18
20,1 50.00
16,900.00
17, 085.00
17,340 00
17,340.00
18,105.00
95,650.51
Total LP PGA
Billed
60,945.08 $
40,683.56 _ $
45,188.55 $
56,143.17 $
68,759.92 $
60,037.54 $
43,201.91 $
32,351.66 $
31,729.52 $
31,729.52 S
31,729.52 $
31,729.52 $
$
Monthly
Overage
(Shortage)
S
(212,801.47) S
23,078.46 S
26,187.22 S
34,089.71 S
40,435.71 $
34,195.36 $
23,051.91 $
15,451.66 S
14,644.52 $
14,389.52 $
14,389.52 $
13 624.52 r $
(95,650.51) S
Cumulative LP PGA
YTD Overage Therm /Gal.
(Shortage)
73,275.87
(139,525.60) 1.77/1.62
(116,447.14) 1.77/1.62
(90,259.92) 1 77/1 62
(56,170.21) 1.77/1.62
(15,734.50) 1.66/1.52
18,460.87 1.66/1.52
41,512.78 1.53/1.40
56,964.44 1.37/1.25
71,608.96 1.37/1.25
85,998.47 1.37/1.25
100,387.99 1.37/1.25
114,012.50 1.37/1.25
18,361.99
369,933.0 $
Cost Center Expenses
•CCS Chg, Admin & Dividend
IY 14/15 Write off PGA & WNA
Fuel
Donations to events
LP Yard Vaporization /loss due to malfunctioning meter
LP PGA Event fuel cost
Suburban Software Systems
_ Depreciation of LP tanks
Suburban Software Systems license
Contribution to garage LP trk up grade
LP Holding Tank Restoration
0.65704 $ 2,090.69 $
243,059.39
$ 182,710.00 1
$ 571.71 1
$ 15,000.00 1
8,324.69 1
460.83 1
1,076.29
5,785.00
34,414.23
589,143.34 $
534,229.45 $
(54,913.88),
(4) Adjustment from FYE transfer of ECA in PGA @ Annual ECA Shortfall
LP Proportion = 1.5% x Total ECA Transfer = S 18,993.26
248,342.75
Projected for FY Proj. Remaining
$ 325,000.00 - $ 76,657.25
CLEARWATER GAS SYSTEM
SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTIONS FOR FY 2015/2016
Attachment #1
Page 2 of 4
ENERGY CONSERVATION ADJUSTMENT (ECA)
Budget C_ ost Center
Month Expenses Notes /Exceptional Items
Prior Year
Oct -15 S
Nov 15 S
.;an -16 $
Feb -16 S
Mar -16 S
Apr -16 S
May -16 S
Jun -16 S
Jul -15 S
Aug -16 S
Sep -16 $
P1:3 S
1,302,486.96 Promo$116,717,Adv $1,807, f mploy Costs$91,167.45
99,380.25 Promo$33,351,Adv $1,505, Imploy Costs$64,524
104,554.68 I'm •noSrC6,954,Adv $2,784, Ilrnploy CostsS54,817
208,713.96 Promo$144,310,Adv $3,025, Ilrnploy Costs$61,379
179,857.05 Promo$107,865,Adv $3,420, Ilrnploy Costs$68,572
157,046.00 Promo$80,895,Adv $7,333, Imploy Costs$68,818
1,150,000.00
150,000.00
150,000.00
150,000.00
150,000.00
150,000.00
otal YID S 4,012,038.90
Interest
Expense
$
S
NGV Station
Total ECA
Expenses
2,969.17 $ 67,449.06 1
8,903.23: $ 55,608.05
8,962.34 $ 67,221.04
9,201.88 $ 57,196.21
9,440.84 $ 35,613.47
9,407.58 5 50,046.26
9,393.86 $ 60,000.00 2
14,383 58 5 60,000.00
14,317.35 $ 60,000.00
14,327.70 $ 60,000.00 3
14,367.57 S 60,000.00
14,425.32 $ 60,000.00
S (300,000.00) 4 -8
130 100.43 S 393,134.09 $
(1) Incl. Annual Admin Charge of $46,740 + CCS chg of $65,140
i Dividend $228,510 + FY 14/15 Write off of $2,405.51 = $ 342,795.51
(1) SNEP Transfer = : $ 750,000.00
(2) Addl Dividend (OK) .I. TECO Pay (329.8K) + Asturia (600K)= $ 929,800.00
(3) Additional SNEP Transfer = $ -
(4) Pension Adjustment NGV = $ - ,
(51 NGV O&M S50,0004 PGA Recvy non -CGS $250,000 = S (300,000.00)
(6) OPEi3 Adjustment =
(7) FDA Accrual
$
REGULATORY IMPOSITION ADJUSTMENT (RIA)
(EIA)
Environmental
Expenses Notes /Exceptional Items
Budget
Month
!'nor Year
Oct 15
Nov -15
Dec 15
Jan-16
rob
Mar -10
Apr 16
May -16
Jun -16
Aug -16
Sep -16
P13
'ola :YID
S
S
S
S
S
S
S
S
S
S
S
S
S
190,920.14
723.33
723.33
723.33
423.33
1,023.33
10,000.00
10,000.00
10,000.00
10,080. CO
10,000.00
10,000.00-
50,000.00
304,536.79
(ORA)
1,372,905.19 $
163, 891.53
240,738.06
275,112.05
224,911.36
216,499.84
1,219,393.86
224,383.58
224,317.35
224, 327.70
224, 367.57
224,425.32
(300,000.00)
4,535,273.42 $
Total ECA
Billed
Monthly
Overage
(Shortage)
186,093.87 $ (1,186,811.32)
152,067.98 $ (11,823.55)
192,830.70 $ (47,907.36)
227,320.43 $ (47,791.62)
231,563.08 $ 6,651.72
219,243.47 $ 2,743.63
221,450.10 ' $ (997,943.76)
237,629.56 ' $ 13,245.98
222,247.29 $ (2,070.06)
216,353.70 $ (7,974.00)
212,817.54 $ (11,550.03).
212,817.54 $ (11,607.78),
966,217.63 $ 1,266,217.63
3,498,652.90 !, $ (1,036,620.53)
Cumulative
YTD Overage
(Shortage)
$ (593,834.01)
$ (1,780,645.33)
$ (1,792,468.88)
S (1,840,376.24)
$ (1,888,167.86)
$ (1,881,516.14)
$ (1,878,772.51)
$ (2,876,716.27)
$ (2,863,470.30)
5 (2,865,540.36)
S (2,873,514.36)
$ (2,885,064.39)
$ (2,896,672.17)
$ (1,630,454.54)
ECA
NG /Therm
LP /Gal.
0.16/0.16
0.16/0.16
0.16/0.16
0.16/0.16
0.14/0.14
0.14/0.14
0.16/0.16
0.19/0.19
0.19/0.19
0.19/0.19
0.19/0.19
0.19/0.19
(8) = Transfer of ECA Collected in PGA up to the ECA Collected for year (up to ECA Annual Shortfal
Note: Maximum amount which can be transferred = $ 1,266,217.63
Regulatory Interest
Expenses Expense
Total RIA
Expenses
Net NOV CCE =
693,134.09
Total RIA Overage YTD Overage
Billed (Shortage) (Shortage)
S - • $ (299,118.53)
38,007.93 $ 1,495.59 1,2 $ 230,423.66' 116,313.07Y$ (114,110.59): $ (413,229.12)
53,701.23 $ 2,066.15 56,490.71 95,076.02 $ 38,585.31 !, $ (374,643.81),
122,262.341 $ 1,873.22 124,858.89 120,061.30 $ (4,797.59) $ (379,441 40)
30,763.25 $ 1,897.21 33,383.79 j 141,991.84 $ 108,608.05 $ (270,833.34)
138,190.797 $ 1,354.17 139,968.29 165,301.33 $ 25,333.04 $ (245,500.30),
96,547.97 $ 1_ ,227.50 98,798.80 156,601.91 $ 57,803.11 $ (187,697.19)
100,000.00^ $ 938.49 110,938.49 115,250.87 $ 4,312.38 $ (183,384.81)
100,000.00 $ 916.92 110,916.92 124,973.06 $ 14,056.14 $ (169,328.68)
100,000.00 $ 846.64 110,846.64 116 883.29 $ 6,036.64 5 (163,292.03)
100,000.00 $ 816.46 110,816.46 113,783.76 $ 2,967.30 $ (160,324.74)
100,000.00 $ 801.62 110,801.62 111,924.04 $ 1,122.41 $ (159,202.32)
100,00000 5 796.01 1.10,796.01 111,924.04 I $ 1,128.03 $ (158,074.30)
4,5 50,000.00 - $ (50,000.00) S (208,074 30)
S 1,079,473.51 ' $ 15,029.98 1,399,040.28 1,490,084.51 S 91,044.23
(1) Includes annual charges for Admin Charge $12,170
FY 14/15 Write off of $1,986.81 + Dividend $176,040 = $
(2) Additional Dividend I $
(3) Credit from Council allocation from Added Dividend $
(4) CIP closed to Operating $
190,196.81 (5) Accrual S -
- Net EIA = $ 64,339.98
Net ORA = $ 1,079,473.51
50,000.00
NG /Therm
LP /Gal.
0.10/0.10
0.10/0.10
0.10/0.10
0.10/0.10
0.10/0.10
0.10/0.10
0.10/0.10
0.12/0.12
0.12/0.12
0.12/0.12
0.12/0.12
0.12/0.12
CLEARWATER GAS SYSTEM
SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTIONS FOR FY 2015/2016
Attachment #1
Page 3 of 4
USAGE AND INFLATION ADJUSTMENT (UTA)
Commercial
Budget
Month
3co Bal.
Oct 15
Nov 15
Dec.15
Jan -16
ch -16
^tar 16
Apr -16
May. 16
Jun -16
Jul -16
Aug -16
Seo -16
Per 13
I otal YTD
Monthly Cumulative UTA
Interest Overage YTD Overage NG /Therm
NG Therms Rate /Therm (Shortage) (Shortage) LPIGaI
$ $ (125,739.87)
6,932.1 $ 382.19 0.01
8,794.5 $ 628.70 0.02 914,466.2, 0.02' $ 17,773.24 $ (107,966.63) 0.02/0.02
5,503.7 $ 539.83 0.02 723,384.7 0.02 $ 14,032.19 $ (93,934.44) 0.02/0.02
7,245.0 $ 469.67 0.02 949,118.3 ' 0.02 $ 17,497.21 $ (76,437.23) 0.02/0.02
1 1,046,106.1 0.01 ', $ 9,954.93 ' $ (66,482.30) 0.01/0.01
8,413.5 , $ 332.41 0.01 1,117,295.3 ' 0.01 $ 10,910.40 $ (55,571.90) 0.01/0.01
9,083.4 $ 277.86 0.01 1,119,403.7 0.01 $ 10,999.84 ' $ (44,572.06) 0.01/0.01
7,500.0 $ 222.86' 0.01 1 100,000.0 0.01 $ 10,852.14 $ (33,719.92) 0.01/0.01
7,200.0 $ 168.60 0.01 950,000.0 ! 0.01 $ 9,403.40 $ (24,316.52) 0.01/0.01
6,500.0 ' $ 121.58T 0.01 825,000.0 ' 0.01 ! $ 8,193.42 $ (16,123.10)' 0.01/0.01
6,500.0 $ 80.62 0.01 825,000.0 0.01 $ 8,234.38 $
(7,888.72) 0.01/0.01
6,500.0 $ 39.44 0.01 825,000.0 0000....00001111
.01 $ 8,275.56 $ 386.84 0.01/0.01
6,500.0 $ 0,01 825,000.0 ! 0.01 $$$$
8,315.00 $ 8,701.84 0.01/0.01
$ - $ 8,701.84
LP Gallons' Expense
Rate /Gallon
86,672.2. 3,263.76
11,219,774.3 $ 134,441.71
(1) January pp by 14/15 less overcollections in FY 14/15 of($41 933.21) = $125,739.87.
Recomputed UTA in December for Janua application. Decreased b 1 cents to recover $167 673.08 from FY 1
USAGE AND INFLATION ADJUSTMENT (UIA)
Residential
Budget
Month
ilea. ital.
Oct -15
No -^r
Mar -16
Aar, 16
May -16
Jan -16
a:1-16
,top -1 6
Per 13 _ --
lottlY D
Interest
LP Gallons Expense Rate /Gallon
29,023.6 $ 103.75
19,632.8 $ 92.14
20,840.8 $ 81.52
27,869.5 $ 66.79
36,710.0 $ 48.13
30,537.6 $ 21.92
25,000.0 $ 0.07
20 000.0 $
20,000.0 S
15,000.0 $
15,000.0 5
15,000.0 $
274,614.3
414.33
0.01
0.01
0.01
0.01
0.01
0.01
0.01
0.01
0.01
0.01
0.01
0.01
Monthly Cumulative UTA
Overage YTD Overage NG /Therm
NG Therms Rate /Therm (Shortage) (Shortage) LP /Gal
S (20,750.81). _
214,018.9 0.01 $ 2,323.69 $ (18,427.12) 0.01/0.01
202,519.0 0.01 $ 2,123.67 5 (16,303.45). 0.01/0.01
281,496.3 0.01 $ 2,945.1 $ (13,358.30); 0.01/0 01
351,334.8 0.01 $ 3,731.58 $ (9,626.72)' 0.01/0.01
491,635.9 0.01 $ 5,242.28 $ (4,384.44) 001/0.0'
407,739.1 0.01 ! $ 4,369.95 $ (14.49) 0.01/0.01
300,000.0 0.01 $ 3,249.93. $ 3,235.44 0.01/0.01
250,000.0 0.01 $ 2,700.00 $ 5,935.44 0.01 /001
200,000.0 0.01 $ 2,200.00 $ 8,135.44 0.01/0.01
200,000.0 0.01 $ 2,150.00 5 10,285.44 0.01/0.01
200,000.0 0.01 $ 2,150.00 5 12,435.44 0.01/0.01
200,000.0 0.01 $ 2,150.00 $ 14,585.44 0.01/0.01
$ $ 14,585.44
3,298,744.0
$ 35,336.25
(1) Recomputed UTA in December for January application. No change in rate of 1 cents. Need to recover $22,562.83 from FY 14/15 less overcollections in FY 14/15 of ($1,812.02) = $20,750.81.
CLEARWATER GAS SYSTEM
SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTIONS FOR FY 2015/2016
Attachment #1
Page 4 of 4
TOTAL ALL COST RECOVERY ADJUSTMENT CLAUSES (Both PGAs + ECA + RIA + UTA)
Budget
Month
Prior Year
Oct_ 15
Nov -15
Doc. ;5
Jan 16
ob 16
Mar 16
Apr -16
May -16
Jun -16
Jul- 16
Aug -16
Sep -16
Per 13
Total 71 U
Total All T otal Recovery
Expenses Billed
7,562,989.64
1,067,275.62
1,244,782.80
1,215,275.48
1,392,835.01
1,332,610.16 $ 2,285,429.96 $
2,169,544.03 $ 1,758,315.84 $
1,097,200.51 $ 1,500,101.04 $
1,042,248.99 $ 1,402,892.02 $
1,042,484.16 $ 1,366,426.47 $
1,017,509.20 $ 1,344,593.73 $
1,018,326.33 $ 1,344,633.17 $
1,092,874.88 $ 966,217.63 $
22,295,956.81 21,783,388.25 $
Monthly Cumulative
Overage YTD Overage
(Shortage) (Shortage)
- $ $ (1,189,371.11)
$ 1.823,456.10 $ (5,739,533.54) $ (6,928,904.65)
$ 1,549,776.43 $ 482,500.81 $ (6,446,403.84)
$ 1,911,971.68 $ 667,188.88 S (5,779,214.96)
2,183,610.04 $ 968,334.56 $ (4,810,880.40)
$ 2,345,964.14 $ 953,129.13 S (3,857,751.27)
952,819.80 $ (2,904,931.47)
(411,228.19) $ (3,316,159.66)
402,900.53 $ (2,913,259.13)
360,643.03 $ (2,552,616.10)
323,942.31 $ (2,228,673.79)
327,084.53 $ (1,901,589.26)
326,306.84 $ (1,575,282.43)
(126,657.25) S (1,701,939.68)
(512,568.57)
Total Res'
NG /Thm (Firm)
L P/G a I
1.15/1.89
1.15/1.89
1.15/1.89
1.15/1.89
1.10/1 77
1.10/1.77
0.97/1.67
0.94/1.57
0.94/1.57
0.94/1.57
0.94/1.57
0.94/1.57
Last Updated 04/14/2016
,-;
.7:!WX:AWS7R7
qar,SIGAR“
URRRSURRR288.
Foggs2g
28;
c'''EfUF,“fWg88
662FEEffiM 88 8
E66AE.16ps
............
;;EUREME;§
6EEEIi6;
2,1nn2gggF,,,8
g6gg4U6;66P
8
572.174 S 386.65820
n..EFkkra E
g6;11;;VAAAF E
8
gr,22PRR8 8
>0
18888q8RRR38
'R'ZIV4RMMi
5y
sqqR1F,E88
v.6.U656866n
uwa
› ............
44“0-',MM
3
5
g2,7-.2,788S8,g8S
151iTanai
mrsevmerv,,,
............
Elgg2,z2gg
ro-8:.70,1R.E,iAA
s:;":=2:716::EnE66
............
2QM:;212:il'M
gg3gRR58656
.6666:7;i70
'224;*;;Rgg48,8K
uo22oen—,>-
8
2
8
8
8
0
83,1rPg2;1'FQV..2
24%4E41WFM.;
N.M.M.VINN194..
g3Ninn-rOn.
Date 1Comoany Targa Invoice
icLeaL Shipping
Gallons
Delivered
09/30/15
12/19/15
'2/26/15
2/27/15
12/3'115
- a-ga 153521701
- arga 1525' 286
15251249
MONTHLY INVENTORY ADJUSTMENT
ArfAe4r4W-tr-
Propane VVe]grlted Average Cos: of Gas (WACOG)
Y 2015-16
4/13/2016
Propane Propane 1 Shipping
Rate Cost I Cost Total
Cost FYTO 1 Cost of I Tank I Tank
WACOG
Gallons i Inventory Inventory Withdrawl •
Year End Totals 1 5 33,452.86 50,024 0.66874
'8.204 2.67'88 S ",233 42 ' 5 863 '2 5 ' 2,096 54 '8 204 2 S 45,549 42 ; 68,028 0.66957
8.992 266692 S 5,56635 5 43. 07 5 5,95712 26.5562 S 5' .546.52 77 225 0.66926
8.849 066694 5 5,477 54 5 424 22 S 5 9-' 76 35,845 2 5 57.44828
, ... 85,869 0.66902
622 052742 5 329.43 ; S - 5 339 40 36,4652 5 57,787 68 ' 86,489 0.66815
'2/3'1" 5
;END OF MONTH
:=-
I
LS 30,764.33
46,044 '
40,445 ,
0.66815
''1051'S
-a-ga '5252871
8,723
269924 $ 5,683.24 , 5 41620
S 6,29944
45,188.2
S 36,863 77
54,767
,
0.67310
' '/26115
-arga '50542'91
-a-ga 152556371
8,784
8,850
-
, 2 69'. 74 S 5,656 90 S 219.32
S 6,276 22
53.9722
S 42.939 99 :
63,551
0.67568
' ' /23/15
2.64424
S 5 279 03 . S 422 46
5 5.72'.49
62,822.2
5 46,64-.48
72.421
0.67183
' '132/15
MONTHLY INVENTORY ADJUSTMENT
1
5 -
5 -
S - I
62,8222
$ 48,64'48
72,43.. 1
0.67183
0.67183
" '/30/' 5
END OF MONTH
I
, frOlV/Ol
$ . -
-5 -
5 -
$ 32,063.97
47,726 '
24,675 ,
''/221'S
Targa 15256223
8.857
2.65'74
S 534663
I S 42262
S 5.77243
71.679.2
S 37,836.42
56,583
0.66869
' 21' 8/' 5
Targa 1506031'
9,251
2.59423
S 4,946 37
I 5 4322'
5 5 376 58
82,732.2
$ 43 212 98
65,634
I
0.65839
'2/31/15
MONTHLY INVENTORY ADJUSTMENT
1,5'9
' 251362
5 780.22 S -
S 782 22
82,248.2
5 43,993 23 '
67.'53
1
0.65512
' 2/31/' 5
END OF MONTH
'
I. ' .;".•
' ••., . , ' ' 1
1
,
I 5 24,173.89
36,900 •
30,253 ,
..,
0.6*512
2' /07/' 6
Targa 1620'833
17,977
259828 S 99'5.71 $ 839 82
S '2,755.53
123.2262
5 34,929.42 1
54,877 ,
0.63650
01/25/16
Targa 16234875
9,372
0.56322
S 4,842.64 5 437.82
S 5,278.46
'09.598.2
''8.8232
5 42,207.88
64,249
0.62581
Targa 163263'51
9.225
2.58821
S 4,728 36 5 429 92
S 5.13828
5 45,346.16 I
73,454
0.61734
,2"/27/16
'C'/28/16
Targa 163263161
9,12'
852
1 3.56822
5 4,746.17 S 425 16
S 5.'7' 33
127,9242
$ 52,517.49 ;
82,555
'
0.61193
2'/3'/'6
2'/311'6
'MONTHLY INVENTORY ADJUSTMENT ,
;END OF MONTH I , .
„ .,,,.
1 -
1.43236
T•rl..... ,
5 ,...., '217.51., i..5 „ -
' . " 1 1
S 1.217 5'
I
'28,7543
$ 5',735.20
Js 29,128.65 •
83.425
46,960
36,445
0.62029
0.62029
02/1"/- 6
-a,5a 163098181
.
'8.119
• 0.60896
• S '0.12852 , S 9253'
S ''.333.83
146,873.2
, S 42,162 48 I
65,279 ,
0.61713
22)2/2'6
Ta-ga '60'17471
9,233
' 262263
• 5 5,37229 i S 415.07
S 5,785 36
'55,876,2
S 45 947.84 ;
74,082 1
0.62023
'22/25/16
102/29/16
F22/29/16
I 23/10/16
;23/17/16
231' 8/16
23/28/16
03/29/16
I23/31/16
23/31/16
"a•-ga 162' ' 972
MONTHLY INVENTORY ADJUSTMENT
END OF MONTH 2, 1'1
wga '60'5202
-arga 162'58601
;-a•ga 16016128
•-a.ga 160'7216
7arga '60'7'92
MONTHLY INVENTORY ADJUSTMENT
END OF MONTH
, 9,128 1 2.65013 1 S 5,5'S 31 1 S 422.83 S 5.934 '4 '65,234.2 5 51,881 98 , 83,210 1 0.62351
456 I 2.176'8 5 8.2.34 ■ 5 - S 82.32 '65,262.2 S 51,962 32 83,666 0.62107
' 1' 1' L 1 , I $ 21,369.11 1 34,407 49,259 0.62107
8,788 ' 3.71'79 5 5,857.20 , 5 397 99 S 6255'S 174,2480 5 27,624 32 I 43.'95 0.63953
9,187 ' 2.67179 ; 5 5,755 65 , 5 416.06 5 6 '7' 7' '83,435 0 5 33,796 01 I 52,382 0.64518
8.683 ' 0.68'79 • S 5,526.73 i S 393 24 S 5,9'9.97 192,1'8 2 5 39,715.98 I 61,265 ' I 0.65039
8.84, 0.65679 I 5 5,406.27 1 5 402.39 S 5.82666 222,959.0 5 45,522 64 I 69,926 T ' 0.65120
8,649 2.65679 I 5 5,288,87 S 39,.73 5 5.682 57 225,608.2 5 51,223.21 ' 78,555 0.65181
559
= .- . ; : ' 771. ; ;T:; F77-- ___[ I Is 25,873.54 • 39,820 , 39,294 • 0.64976
FYTD Totals
0.36'52 I 5 202.09 S - : S 202.29 ; 2'2.167.0 S 51,425.33 79,114 ; 0.64976
206,163 0.64004 1
122,249.70 5 9 702.91
131,952.61
Delivered Delivered Delivered
Month CGS Cost Gallons Cost
of Inventory
eno r
Cost
Total EOM Tank EOM Tank Projected
Gallons Gallons Cost WACOG
Mar-16
Apr-16
May-16
Jun-16
Jul-16
Aug-16
Sep-16
Oct-16
Nov-16
Dec-16
S
S
S
S
S
S
S
S
S
0.65
0.65
0.70
0.70
0.70
0.75
0.75
0.75
0.75
38,000
27,000
18,000
18,000
18,000
27,000
27,000
38,000
50,000
S
S
S
S
S
S
S
S
24,700.00
17,550.00
12,600.00
12,600.00
12,600.00
20,250.00
20,250.00
28,500.00
37,500.00
S
S
S
S
S
S
S
S
S
50,573.00
43,427.88
38,479.95
39,100.72
39,528.24
47,472.66
48,540.35
57,426.62
66,884.84
77,820
66,820
57,820
57,820
57,820
66,820
66,820
77,820
89,820
39,820
39,820
39,820
39,820
39,820
39,820
39,820
39,820
39,820
39,820
S 25,873.00
S 25,877.88
S 25,879.95
S 26,500.72
S 26,928.24
S 27,222.66
S 28,290.35
S 28,926.62
S 29,384.84
S 29,652.13
0.65
0.65
0.65
0.67
0.68
0.68
0.71
0.73
0.74
0.74
.;aide Annual Therm Range
or Other Rate Determinant
. ,rner Charge
,F Centro; Pasco Territory)
,J,,,,- F,,,,.I Fncrav Charge/Therm
r.,. , uel l-" rgy Charge $0.44 $0.44 $0.44 $0.44 $0.42 $0.38 $0.34 $0.20 $0.15 $0.10 $0.20 $0.35 By Contract $0.42 $0.24 By Coat: aor
r :ton Adj. (ECA) 0.19 0.19 0.19 0.19 0.19 0.19 0.19 NA NA NA NA NA NA NA NA MA
- i_ (71A) 0.12 0.12 0.12 0.12 0.12 0.12 0.12 NA NA NA NA NA NA NA NA Nis
, , rI ll; %) 0 01 0.01 0.01 0.01 0.01 0.01 0.01 NA NA NA NA NA NA NA NA N'1
','n! Ecrrgy C'rr qe $0.76 $0.76 $0.76 $0.76 $0.74 $0.70 $0.66 $0.20 $0.15 $0.10 $0.20 $0.35 By Contract $0.42 $0.24 By Contract
',cent ( °GA; 012 0 62 0_62 0.62 0 62 0.62 0.62 0.62 0.62 0.62 0 62 0.62 0.53 0.62 0.53 0.59
r,t,l r „„r,,.,, Ct ,rqr' /Thenn 1.38 1 38 1.38 1.38 1.36 1.32 1.28 0.82 0.77 0.72 0.82 0.97 0.53 1.04 0.77 0.53
+ Non -Fuel , Nora -1 real
„
17.,II 512.00 S25.00 540.00 595.00 $25.00 $40.00 595.00 512.00 525.00 540.00 $20.00 $20.00 By Contract $50.00 S250.00 C. ?'c
r or n!, Pasco Territory) (S20. 00) ($40.00) ($70.00) ($160.00) ($40.00) ($70.00) ($160.00) ($20.00) (940.00) ($70.00) ($30.00) ($30.00) (By Contract) ($75.00) $400.00 Chard
@ premise @, premise @ premise + FAC + FAC + FAC + FAC + Non -Fuel Therm Non ! ! h,.r
Rate forControct ,.:'.c
it of Therein 1 of I' rmn-
;,
CLEARWATER GAS SYSTEM
NATURAL GAS RATE BILLING FACTORS
FOR May 1, 2016 - SEPTEMBER 30, 2016 BASED ON APPROVED GAS ADJUSTMENT FACTORS
Attachment a-
Intern Contract
Firm Natural Gas Rate Schedules NG Rate NG Rate
RS SMF MMF LMF SGS MGS LGS RAC GAC LAC SL SL w /M& NGV NSS IS CNS
Relight (Non -Rest) (Non -Rest)
NA (1 - NA (4 + NA (4 + NA (4 + 0 - 18,000- 100,000 NA (1 - NA (0 - NA (150 NA NA NA NA 100,000 NA
3 Units) Units) Units) Units) 17,999 99.999 & up 3 Units) 149 tons) tons & +) & up
$12 CO $25.00 $40.00 $95.00 $25.00 $40.00 $95.00 $12.00 $25.00 $40.00 $20.00 $20.00 By Contract 550 00 5250.00 By Coin',,..'
($20.00) ($40.00) ($70.00) ($160.00) ($40.00) ($70.00) ($160.00) ($20.00) ($40.00) ($70.00) ($30.00) ($30.00) (By Contract) (575.00) $400.00 (By Con r,0t)
if not prey. if not prey. if not prey.
bitted billed billed
$ 1.26; 126 $ 1.26 $ 1.26 $ 1.24 $ 1.21 $ 117 $ 0.75 5 0.70 5 0.66 $ 0.75 $ 0.89 $
;'h 5.0% Franchise S 1.34 S 1.34 $ 1.34 $ 1.34 $ 1.32 $ 1.28 $ 1.24 $ 0.80 $ 0.75 $ 0.70 $ 0.80 $ 0.94 $
Therm Pate S (0.37) 5 (0.37) S (0.37) $ (0.37) $ (0.35) $ (0.33) $ (0.31) $ (0.32) $ (0.32) S (0.32) $ (0.32) $ (0.32) $
..4 nnpr i Rate -16 4% -16.4% -16.4% -16.4% -16.3% -15.8% -15.3% - 17.0% -17.5% -18.0% -17.0% -16.2%
0.48 S 0.95 $ 0.70
0.51 $ 1.01 $ 0.75
(0.32) 5 (0.36) $ (0.36)
-18.0% -16.7% -20 7%
5 (2
-21
90.009 50.069 90 009 90.069 50.069 $0.069 S0.069 $0.069 90.069 $0.069 $0.069 $0.069 $0.069 90.069 $0.055. 00 050
S0.551 $0.551 50.551 $0.551 $0,551 $0.551 $0.551 S0.551 90.551 $0.551 $0.551 $0 551 $0.461 50.551 50.475 00 40.1
h P2 FP.CTOR = THERMS /100 CUBIC FEET (CCU
10/2015 11/2015 12/2015 01/2016 02/2016 03/2016 04/2016 05/2016 06/2016 07/2016 08/2016 09/2016
'or a,vh o Bates 1.042 1.044 1.042 1.042 1.042 1.045 1.046 1.046
Int ^rr ,ruble Service Rates 1.022 1.023 1.021 1.021 1.022 1.025 1.025 1.025
FY 15/16 Avq.
1.044
1.023
C S W:04 / ". tI /20'. 6
13l l; Factor: 2.714 Gallons /100 cubic feet (CCF)
13 ;,Factor.
"e-rn Factor:
2.483 Therms /100 cubic feet (CCF)
0.915 Therms /Gallon
CLEARWATER GAS SYSTEM
METERED PROPANE (LP) RATE BILLING FACTORS
FOR May 1, 2016 - SEPTEMBER 30, 2016 BASED ON APPROVED GAS ADJUSTMENT FACTORS
Attachment Its
Page 1 o' 7
RESIDENTIAL MULTI - FAMILY LOOP RESL. SMALL COML. LARGE COML. VEHICLE STANDBY /GENERATOR CONTRACT MTRD
MRLP MMLP LRLP MGLP MLLP LPV LPSM CLP
(Non -Rest. Only) (Non -Rest. Only)
AooIcable Annual Ga "on Range NA NA NA 0 - 2,500 >2,501 NA NA NA
or Other Rate Determinant (1 - 3 Units) (4 + Units) (Closed for New
Resl. Applications)
Corny Customer Charge $12.00 $25.00 $12.00 $25.00 $40.00 $40.00 $50.00 Set By Contract
For Each Meter
Non -Fuel Energy Charges /Gallon:
won reel Energy Charge (NFE) /Gallor $1.90 $1.90 $0.90 $0.30 $0.25 Set By Contract $1.00 Set By Contract
! rergy Conservation Adj.(ECA) /Gallor 0.19 0.19 0.19 0.19 0.19 NA NA NA
Regulatory Imposition Adj.(RIA)/Gallor 0.12 0.12 0.12 0.12 0.12 NA NA NA
'Usage & 'E anon Ad. (UTA) /Galion 0.01 0.01 0.01 0.01 0.01 NA NA NA
Total Non -Fuel Charges (NF) /Gal. $2.22 $2.22 $1.22 $0.62 $0.57 Set By Contract $1.00 Set By Contract
P.:•c"asec Gas Adt,:stment(PGA) /Ga- 1.25 1.25 1.25 1.25 1.25 Set By Contract 1.25 0.95
Total Energy Charges /Gallon $3.47 $3.47 $2.47 $1.87 $1.82 Contract NFE $2.25 Contract NFF
+ Contract PGA $0.950
Customer Charge Customer Charge
Minimum Monthly Bill $12.00 $25.00 $12.00 $25.00 $40.00 Any Applicable $50.00 Non -Fuel Energy Chg.
Customer Charge for the Contractor,'
+ Any Applicable li of Gallons /Mo.
Facility Charges
Utility Tax Note:
.-e' Date per Ga'ion 10/01/1973 0.161 0.161 0.161 0.161 0.161 0.161 0.161 0.161
Non - Utility Taxable Fuel /Gallon $1.089 $1.089 $1.089 $1.089 $1.089 Contract PGA - 0.161 $1.089 Contract PGA - 0.161
Change I-or' 9/2014 Gallon Rate ($0.70) ($0.70) ($0.70) ($0.68) ($0.68) NA ($0.69) NA
C ^ange ` ^;r, 9/20'4 Gallon Rate -16.9% - 16.8% -22.1% -26.7% -27.2% NA -23.5% NA
CSW:C4 /18/2016
., ado•: 2714 Ga!!on•s /100 cubic feet (CCF)
2.483 Therms /100 cubic feet (CCF)
0.915 Therms /Gallon
STANDARD RESIDENTIAL BULK LP SERVICE
(Rate Class is !lased on Annual LP Gallon Usage 1 ovel)
❑REPO l3f!LP1 DRLP2 13RLP3 BRLP4
CLEARWATER GAS SYSTEM
BULK PROPANE (LP) RATE BILLING FACTORS
FOR May 1, 2016 - SEPTEMBER 30, 2016 BASED ON
APPROVED GAS ADJUSTMENT FACTORS
RESIDENTIAL WILL CALL"
(Eased on Annual Usage Level)
WRLPO WI9LP1 WRLP2 WRLP3 WRLP4
Acc: "c A° G::'.'c- fia °•c 0 (No ".!'.s :^ Yr.) 0.1 60 60.1 - 120 120.1 300 > 300 0 (No Pills in Yr.) Cl . - 60 60,1 - 120 120.1 300 > 300
U." 6!0J ..act 13::NiiS 131NI IS 1.3 UNITS I3UNIIS 13UNI(S 13UNiIS 1- 3UNIIS 1.3 UNITS 13UNIIS 1 -3 UNITS
S 353.30 $ 775.00 $ 160.00 0 90.00 $ /9.00 $ 350.00 $ 210.00 $ 150.00 $ 75.00 $ 60.00
3o -Fuc! Cna yes ( NF) /Gallon:
■::° ! ..O i rergy C;: ^age (52 ! )!Oal. $ 180 $ 1.80 $ 1.60 S 1.00 S 0.90 $ 1.80 $ 1.80 $ 1 60 $ 0.90 $ 0.80
rcy „c- scrve• 09 . Ac,. (! CA)/Co _ S .,.'9 5 C.'9 5 0.19 0.19 0.19 0.19 0.19 0.19 0.19 0.19
'h:c2a'cy :macs ..cr. Ac'. ('r2A( /Ca'. $ 0.12 S 0.12 S 0.12 0.12 0.12 0.12 0.12 9,12 0.12 0.12
1. A :.. , .:A)/00.... 0 01 0.01 0.01 0 01 0,01 C 01 001 0.01
c..a. Noel uel Charges (NF) /Gal. $ 2.12 $ 2.12 $ 1.92 $ 1.32 $ 1.22 $ 2.12 S 2.12 $ 1.92 $ 1.22 $ 1.12
_ ;.see C as \ 'CA)/Ca..o $ 1.25 0 1.25 $ 1.25 $ 1.25 $ 125 $ 1-25 $ 1.25 $ 125 5 1.25 5 1.25
I Si:' I-- -.ccrgy Char yes /Gallon 3.37 $ 3.37 $ 3.17 $ 2.57 $ 2.47 $ 3.37 $ 3.37 $ 3.17 $ 2.47 $ 2.37
COMMERCIAL BULK LP SERVICE
(Based on Annual Usage I evel)
BCLP1 DCLP2
0 - 2,500 > 2,500
Customers in this Customers in this
Range of Usage !tango of Usage
$ 90.00 $ 90.00
S
S
S
0.25 $
0.19
0.17
0.01
0.57 $
1.25 $
1.82 $
0.20
0.' 9
Attacbmort (IS
Page 2et2
BULK STANDBY/ CONTRACT BULK
GENERATOR I LP SERVICE
L SO CLP
(Closed for
New Residents! I Any Contract
Applications) Customers Who
!lequcsts /1 :6 I>c'.
$ 420.00 I Set by contract
5 1.09 Set ity Contra::'
R.1 \A
NA: NA
NA NA
1.00 Set fly Contract
$ 1.751 0.95
0.52 S
1.25
1.77
$ 2.25 Cotract :NFL
0.950
ct•tty x Note
_,. <.i.,. _,_ ,a 012'1'913 S 0.161 S 0.161 $ 0.161 5 0.151 $ 0.161 5 0.161 5 0.161 $ 0.161 5 0.161 5 0.161 $ 0.161 $ 0.161 $ 0.'6'. $ 0 16"
36^. '.ly tonic c!`:e'fCd.o.. $ 1.089 S 1.089 $ 1.009 5 1.089 S 1.089 S 1.089 $ 1.089 $ 1.089 $ 1.089 5 1.089 $ 1.089 S 1.089 $ 1.089 Co ^tract 'CA- 0.161
.,-'s-.ce!•om 9/2014 Caro ^Gate $ (0. /00) $ (0. /00) $ (0.100) $ (010) 5 (0.70) $ (0.50) 5 (0,50) $ (0.70) S (0. /0) $ (0.80) $ (0.68) $ (0.68) $ (0.69) NA
% Cmmge 'ro^ 912014 Gal'on !tate 1 /.2% - 172% -18.1% -21.4% -22.1% -12.9% -12.9% 18.1% 22.1% -25.2% 2/.2% -2/.8% 23.5% NA
CSWO / 912C'E
Residential Rate History By Components
Clearwater Gas System
Total Rate
Month NG /therm LP /gallon'
Oct -12 $ 1.48 S 3.26
Nov -12 $ 1.48 S 3.26
Dec 12 S 1.53 S 3.31
Jan -13. $ 1.53 S 3.31
Feb -13 5 1.56 S 3.29
Mar -13, $ 1.56 $ 3.29
Apr-13 $ 1.60 $ 3.22
May -131 S 1.60 S 3.22
Jun -13' $ 1.65 S 3.23 '
Jul -13, S 1.65 $ 3.23
Aug -13, S 1.67 S 3.23
Sep -131 $ 1.67 S 3.23
FY 12113 Avg. I $ 1.582 $ 3.257
2012 Avg. $ 1.501 $ 3.548
Attachment #6
Page 1 of 3
Adjustments /Therm Contract LP
ECA RIA# WNA/UTA- Rest# UTA_Coml# PGA PGA PGA/gallon
S 0.14 S 0.05 5
S 0.14 S 0 -05 S
S 0.14 S 0.05 S
$ 0.14 S 0.05 S
S 0.13 5 0.08 S
S 013 S 0.08 S
$ 0.135 0.08 S
S 0.13 S 0.08' $
$
0.15 5 0.10 $
$ 0.15!S 0.10 S
S_
0.15 S 0.10 $
$ 0.15 1 5 0.10 S
$ 0.140 I $ 0.077 $
$0.1331$ 0.031 $
Oct-131 $ 1.70 S 3.45
Nov -13 5 1.70 S 3.45
Dec -13 $ 1.66 1 S 3.41
Jan -141 $ 1.69 S 3.52
Feb -14t $ 1.68 $ 3.70
Mar -141 $ 1.70 S 4.27
Apr -14 $ 1.70.5 4.27
May-14 $ 1.75 S 3.27
Jun -14' $ 1.75 $ 3.27
Jul-14 $ 1.75 S 3.27
Aug -141 S 1.75 $ 3.27 _
Sep -14 $ 1.75 $ 3.27
FY 13114 Avg. I $ 1.715 $ 3.535
2013 Avg. 1 $ 1.629 $ 3.297
Oct-141 5 1.78 $ 3.47
Nov -14 $ 1.65 $ 3.38
Dec-14i S 1.65 $ 3.38
Jan-15 , S 1.65 S 3.38
Feb -15! $ 1.64 S 3.21
Mar -151 $ 1.57 $ 3.03
Apr -151 S 1.54 S 3.03
May 15 5 1.54 $ 3.03
Jun -15 $ 1.53 S 2.98
Jul -15 $ 1.53 $ 2.98
Aug -15 $ 1.57 ` $ 2.86
Sep -151 , $ 1.57 I $ 2.86
FY 14/15 Avg. $ 1.602 I $ 3.133
2014 Avg. $ 1.717 $ 3.528
S 0.14 $ 0.10 S
S 0.14 $ 0.10 S
$ 014,5 0.10
$ 0.14 S 0.10 1 5
5 0.14 5 010'$
5 0.14 S 0.10 j S
$ 0.14'',$ 0.101$
S 0.14 I $ 0.10 $
$ 0.14 S 0.10
S 0.14 1 $ 0.10, $
5 0.14 $ 0.10 $ _
S 0.14 S 0.101 S
$ 0.140 $ 0.100 $
$ 0.140 $ 0.089 S
, S 0.14 5 0.12 $
$ 0.14 S 0.12 j $
S 0.14 $ 0.12 !S
$ 0.14 $ 0.12 S
S 0 14 5 0.12 S
$ 0.13 $ 0.10 !, $
S 0.13$ 010 ';S
S 0.13 ! $ 0.10 { $
$ 0.14 ; $ 0.10 1 S
$ 0.14 $ 0.10 $
S 0.15 1 5 0.10 S
$ 0.15 1 $ 0.10 ' $
$ 0.139 I $ 0.108 $
$0.14015 0.105 $
S 0.16 S 0.10 1 S
5 0.161$ 0.10 S
$ 0.16 ! $ 0.10 $
S 0.16 S C.10 S
$ 0.14 $ 0.10 S
$ 0.14 $ 0.10 1 $
5 0.16 $ 0.10 $
5 419 f $ 0.12 5
Oct-15 $ 1.59 $ 2.89
Nov-151 $ 1.59 S 2.89
Dec -15 $ 1.59 $ 2.89
Jan -161 5 1.59 S 2.89 ,-
Feb -161 5 1.54 $ 2.77
Mar -16 5 1.54 S 2.77
Apr -16 $ 1.41 , S 2.67
May -16 S 1.38 i $ 2.57
Jun -16
Jul -16
Aug -16
Sep -16
0.08 5 006 S 0.73 S 0.63 S 1.99
0.08 5 0.06 S 0.73 _ S 0.63 5 1.99
0.13 S 0.06 5 0.73 5 0.63 S 1.99
0.13 S 0.06 $ 0.73 $ 0.63 S 1.99
0.16 5 0.06 5 0.71 S 0.61 $ 1.92
0.16 S 0.06 S 0.71 S 0.61 S 1.92
0.16 $ 0.06 5 0.75 5 0.65 S 1.85
0.16 5 0.06 S 0.75 S 0.65 $ 1.85
0.13 5 0.06 5 0.79 1 $ 0.69 ' S 1.85
0.13 $ 0.06. 5 0.79 S 0.69 S 1.85
0.13 S 0.06 S 0.81 S 0.71 I5 1.85
0.13,S 0.06 5 0.81 i $ 0.71 $ 1.85
0.132 $ 0.060 S 0.753 $ 0.653 I $ 1.908
0.073 $ 0.067 5 0.785 $ 0.700 I $ 2.312
■
0.13 $ 0.06 $ 0.85 i $ 0.76 1- $ 2.08
0.13 S 0.06 S 0.85 4 $ 0.76 ' $ 2.08
0.09 $ 0.07 S 0.85 * S 0.76 5 2.08
0.09 $ 0.07 $ 0.88 S 0.79 j $ 2.19
0.09 S 0.07 $ 0.87 1 5 0.78 $ 2.37
0 09 5 0.07 $ 0.89 1 S 0.80 $ 2.94 I-
0.09 $ 0.07 5 0.89 S 0.80 $ 2.94
0.09 S 0.07 5 0.94 S 0.85 $ 1.94
0.09 $ 0.07 $ 0.94 ' $ 0.85 $ 1.94
0.09 $ 0.07 $ 094 I $ 0.85 S 1.94
0.09 S 0.07 5 0.94 1 $ 0.85 $ 1.94
0.09 S 0.07 ; S 0.94 1 $ 0.85 ' S 1.94
0.097 $ 0.068 $ 0.898 I $ 0.808 $ 2.198
0.137 I $ 0.061 $ 0.783 ; $ 0.686 $ 1.931
0.09 S 0.07 5 0.95 1 5 0.85 $ 2.12
S S 0.95 S 0.85 $ 2.12
S 5 0.95 I $ 0.85 S 2.12
S $ 0.951S 0.85 $ 2.12
0.01 S 0.02 S 0.935 0.83 $ 1.94
0.01 $ 0.02 1 $ 0.89 $ 0.79 5 1.79
0.01 S 0.02 $ 0.86 $ 0.76 $ 1.79
0.01 S 0.02 $ 0.86 ' S 0.76 ' $ 1.79
0.01 5 0.02 $ 0.84 1 $ 0.74 I S 1.73
0.01 S 0.02 $ 0.84 S 0.74 5 1.73
0.01 _ S 0.02 S 0.87 S 0.77 S 1.60
0.01 5 0.02 $ 0.871$ 0.775 1.60
0.014 $ 0.019 ! $ 0.897 ' $ 0.797 I $ 1.871
0.075 5 0.058 5 0.923 I $ 0.831 1 $ 2.208
0.01 $ 0.02 S 0.88 !; S 0.79 j $ 1.62
0.01 S 0.02 $ 0.88 $ 0.79 S 1.62
0.01 S 0.02 ,5 0.88,$ 0.79 $ 1.62
0.01 5 0.01 S 0.79 1.62
5 1,
0.01 5 088'
0.01 $ S 0.85 $ 0.76 $ 1.52
0.01 S 0.01 $ 0.85 - S 0.76 i S 1.52 11
001 ($ 0.01 $ 0.70 1 $ 0.61 $ 1.40
0.01 1 S 0.01 $ 0.62 5 0.53 S 1.25
FY 15116 Avg. $ 1.529 j $
2.793
$0.159 $ 0.103 S
0.010 1 $
0.014 1 S 0.818 5
0.728 $
1.521
2015 Avg. $ 1.576 I $ 3.003
$ 0.144 $ 0.103 S 0.009 $ 0.018 S 0.879 S 0.782 $
1.746
Incr. Above I $ (0.16)_ $ (0.46)
Last Year
Same Month
Incr. Based $
on 20 Therms
Equivalent
Cents /KWH
for Gas
-10%
-15%
(3.20) $ (10.05)
-10% -17%
vs. Duke Rate
(Residential)
9.6
$ 0.06 $ 0.02.5
46% 20 %'
0%
(0.01).5 (0.24)''. S (0.23). S (0.54)
-50% -28% -30% -30%
12.0 12.0 Note: Duke Energy Florida's residential rate for usa;;e .1,000 KWH in April 2016 is 12.047 cents /KWH.
Gas Cheaper
by -61% -20%
Notes:
Based on 3u!9 LP (38L03) whlcn is appf.uaoe tor c.as:o-.ers .;sang 120 -1 - 300 ga'ons /year & c.:ual to Res c.- ..,:.c i Wil! Ca . (I3RWOLP).
9 New rates implemented 11/1/2014, witn In•low'ng changes'
- RS NC Cus :o„ ... Charge ,creased S2 trcht 510 :c S' 2 / -,on:r & N rate c c0c: 4 cents cc 44 ce't s /t^,e ". l;'n p creased by 9 ce ^:s / :nerr- to O.
- 301.P3 LP Cus : :rmer C harge :1 ;lcrance S90/yca -, an.. \ rate ,._c^iangec .:. S1.00 /_..,,.. A : C.. case.: by 9 cents /ga'.
R!n & E.CA rr a ^qed In' o y.
CSW:08/26/201 5
Attachment #6
Page 2 of 3
Competitive History of NG vs. Electric Rates
NG Equivalent Progress Energy NG vs.
Month -Year NG Therm Cost KWH Cost KWH Cost Electric
September 2001 S 1.34 S 0.046 S 0.084 -46%
September 2002 S 1.36 S 0.046 S 0.074 -37%
September 2003 S 1.56 S 0.053 S 0.084 -37%
September 2004 S 1.69 S 0.058 S 0.089 -35%
September 2005 S 1.97 S 0.067 S 0.097 -31%
September 2006 S 1.89 S 0.065 S 0.119 -46%
September 2007 S 1.86 S 0.063 S 0.120 -47%
September 2008 S 2.12 S 0.072 S 0.120 -40%
September 2009 S 1.39 S 0.047 S 0.132 -64%
September 2010 S 1.39 S 0.047 S 0.136 -65%
September 2011 S 1.42 S 0.048 S 0.129 -62%
September 2012 S 1.48 S 0.051 S 0.132 -62%
September 2013 S 1.67 S 0.047 S 0.126 -63%
September 2014 S 1.75 S 0.047 S 0.126 -63%
September 2015 S 1.57 S 0.047 S 0.126 -63%
S Increase over
Last 14 Years S 0.23 S 0.001 S 0.042
% Increase over
Last 14 Years 17.2% 3.0% 50.2%
Avg. Annual Inc.
Over Last 14 Yrs. 1.2% 0.2% 3.6%
CSW:1 /24/2015
Attachment #6
Page 3 of 3
Annual Average CGS Residential Rates
Calender Year
Year
1995
1996
1997
1998
1999
2000
2001
2002
2003
2004
2005
2006
2007
2008
2009
2010
2011
2012
2013
2014
2015
NG /Therm LP /Gallon
Fiscal Year
Year NG /Therm LP /Gallon *
NA
NA FY 95/96 S 0.880 S 1.199 *
0.915 S 1.239 * FY 96/97 S 1.019 S 1.370 i *
1.049 S 1.380 '* FY 97/98 S 1.054. S
1.032 S 1.288 1.318 1 *
'* FY 98/99 S 1.052 S 1.269 !*
1.073 S 1.311 FY 99/00 S 1.152 ! S 1.504
1.222 i S 1.584 FY 00/01 S 1.551 S 1.649
$ 1.549 I S 1.586 FY 01/02 S 1.352 S 1.488
1.342 S 1.553 FY 02/03 S 1.477 S 1.817 ;
1.534 S 1.864 FY 03/04 S 1.603 ' S 1.913
1.652 S 1.968 FY 04/05 S 1.803 S 2.162
1.925 S 2.278 FY 05/06 S 2.080 S 2.480 j
2.012 S 2.501 FY 06/07 S 1.918 S 2.742 +
1.893 S 2.869 FY 07/08 I S 1.932 S 3.183 �
1.965 S 3.186 FY 08/09 S 1.610 S 2.524
1.464 S 2.418 FY 09/10 S 1.437 S 2 865
1.457 S 2.946 FY 10/11 S 1.475 . S 3.282
1.487 S 3.438 FY 11/12 S 1.506 S 3.639
1.501 S 3.548 FY 12/13 I S 1.582 S 3.257
1.629 S 3.297 FY 13/14 S 1.629 S 3.297
FY 14/15 5 1.602 S 3.133
1.576 S 3.003
Average $ 1.500 r $ 2.339
1.486,$ 2.3041
Notes:
* Based on the Residential Metered Propane schedule which was closed for
new customers effective March 8, 1999. For 1999 & FY 99/00 and beyond
based on Bulk LP (BRLP3) which is applicable for customers using
120.1 - 300 gallons /year & is equal to Residential LP Will Call
Clearwater Gas System
Live Greener
e
Fuel Use and Cost Comparison
(Effective Rates for May 2016)
•
APPLIANCE ANNUAL NATURAL GAS PROPANE (LP) GAS 1 ELECTRIC
THERMS
USED
COOKING ; 45 : S 62.10 S126.45 ; S158.85
WATER HEATING
-Gas Tank Style/Gas Tankless 170 / 100 ' $234.60 / $138.00* $477.70/$281.00* $600.10
vs. Electric Tank Style
HEATING ; 150 ; S207.00 ' S421.50 S529.50
CLOTHES DRYING 50 S 69.00 ; S140.50 ' S176.50
TOTAL APPLIANCE S572.70/ ; S1,166.15/ , S1,464.95 !
USAGE — with tank/tankless ; S476.10* S969.45*
GAS SAVINGS VS. 61% / 67%* 20%/ 34%*
ELECTRICITY
OUTDOOR RECREATION:
*when using tankless , *when using tankless- LP
POOL HEATING* 375 S517.50 ; S1,053.75 I S1,323.75
SPA/HOT TUB HEAT* 175 S241.50 ; S 491.75 S 617.75
*varies according to_Rool size, weather conditions, and temperature maintained
All other figures are annual average projections based upon the following:
1. 1 therm = 100,000 BTUs of energy
2. Natural Gas S1.38
per therm
3. LP Gas per gallon (BRLP3) S2.57 per gallon or S2.81 per therm
4. Duke Energy per KWH S0.12047 Per KWH or S3.53 per therm
(Based on >1000 KWII rate)
1. Notes: The above analysis is based on May 2016 residential energy and fuel charges and does not include
applicable taxes or franchise fees.
2. Current monthly customer charges are:
Duke Energy S8.76, Peoples Gas S12.00-S20.00 (varies by rate class), Clearwater Gas System S12.00 and
S20.00 in Central Pasco. LP. customers are billed annually, S75-S210 (non-refundable) depending on program.
711 Maple Street • Clearwater, FL 33755 • (727) 562-4980
www.clearwatercias.com