Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
GAS ADJUSTMENTS EFFECTIVE MAY 1, 2018
CLEARWATER GAS SYSTEM Interoffice Correspondence Sheet TO: William B. Horne II, City Manager FROM: Chuck Warrington, Managing Director COPIES: Rosemarie Call, City Clerk; Micah Maxwell, Assistant City Manager CGS & UCS Management Teams; Janet Dorrough, Sr. Accountant/CGS; Laura Damico, Sr. Accountant/UCS; Lynne Priester, Cust. Serv. Coord./UCS; Lindsey Bessette, Systems Analyst/UCS SUBJECT: GAS ADJUSTMENTS EFFECTIVE MAY 1, 2018 DATE: April 26, 2018 Natural Gas supply prices have dropped a little from anticipated; therefore, we are recommending a decrease of 4¢ per therm in our Natural Gas Purchase Gas Adjustment (PGA) for May. And, Propane (LP) supply prices have also reduced; therefore, we are recommending a 4¢ 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 no change in our Energy Conservation Adjustment (ECA) for May. We are recommending a 5¢ per therm or gallon reduction in our Regulatory Imposition Adjustment (RIA) for May, as we are currently over collected for the year. We are recommending no changes in either of our Usage & Inflation Adjustments (UIAs) for May. The net effect of these recommended changes for May is a 9¢ per therm decrease (-5.3%) in our typical Residential Natural Gas customer's rate and a 9¢ per gallon decrease (-2.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, 2018: Natural Gas Firm Standard Rate Schedule PGA $0.82 per therm (down 4¢ per therm) Natural Gas Interruptible and Contract (Non -Standard) Rate Schedule PGA $0.72 per therm (down 4¢ per therm) Propane (LP) Gas Standard Rate Schedule PGA $1.95 per gallon (down 4¢) Propane (LP) Gas Contract Rate Schedule PGA $1.65 per gallon (down 4¢) Energy Conservation Adjustment (ECA) $0.25 per therm or gallon (no change) Regulatory Imposition Adjustment (EIA) $0.04 per therm or gallon (down 5¢) Usage & Inflation Adjustment (UTA) - Residential .... $0.05 per therm or gallon (no change) - Commercial $0.03 per therm or gallon (no change) William B. Horne II, City Manager April 26, 2018 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 year and a quarter, and Pages #2 and #3 of this show our 16 -year relationship to electric prices and average residential rates, respectively. Please note that Page #2 of this analysis shows that, over the past 16 years, our residential natural gas rates have risen an average of just 1.7% annually as compared to a 3.4% average annual increase for the Duke Energy (formerly Progress Energy Florida/FPC) residential rates. That's half the inflation in our energy costs on average for natural gas vs. electric --- a remarkable difference! And, we Duke Florida's rates increased in January even more. I should point out that the overall effect is that our typical Residential customer rates are now approximately 59% lower than electric for Natural Gas and 8% 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 are recommending that we decrease our standard posted price at our Natural Gas Vehicle (NGV) Fueling Station effective May 1, 2018, to $1.37 per gasoline gallon equivalent (GGE --- down 30¢) --- a remarkable savings from the gas station prices around town and the lowest posted NGV price in the State, and we believe the Southeast U.S. For our City and other governmental fleet vehicles, our recommended new price effective May 1, 2018, will be $1.19/gge (also down 300), as these fleets pay no Federal taxes on fuel --- a remarkable price. This decrease is a result of the Congress passing the Tax Extender package this year retroactive for 2017. We are hopeful that this 50¢/gge Excise Tax Credit for NGV vehicle fuel will be reinstated by Congress for 2018 and beyond, which would allow us to reduce our pricing even more. There is a bill in the works now to hopefully accomplish this. Bill, I would appreciate your approval of these revised adjustment rates so that we can get this information to UCS so that they may 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/cw Attachments Approved: 1/L4 -44.w 6/(444AA.TIC William B. Home II, City Manager U:\My Documents\MSOFFICE\WINWORD\GASRATES\Gas Adjustments for May 2018.docx CLEARWATER GAS SYSTEM SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTIONS FOR FY 2017/2018 Attachment #1 Page 1 of 4 NA URAL GAS PURCHASED GAS AD USTMEN PGA -NG Monthly Cumulative NG PGA . ' Bud. et Month Reservation Char es Commodi Char, es Interest Ex • ense Cost Center ■ Total NG Fuel E+ • : Total NG PGA Overage YTD Overage Rate/Therm Shorta, e) Shorta.e Firm/Contr $ (1,259,797.68) - i Nov -17 , $ 188,582.81 696,640.41 $ 24,840.03 $ 31,975.76 e ' , $ 942,039.01 , (3,708,208.92 $ (4,968,006.60 0.91/0.81 $ 596,890.42 $ 4,371,116.18 0.91/0.81 Dec -17 $ 190,254.85 806,101.46 $ 21,855.58 $ 58,962.32 $ 1,077,174.218 $ 53,659,471.95 0.91/0.81 Jan -18 $ 440,164.12 �] $ 18,297.36 $ 38,739.61 2 $ 1,571,553.42 8 $ 3,245,983.16 0.:86/0.76 Feb -18 $ 16,229.92 $ 39,553.14 $ 1,096,528.24 1,975,938.93 $ 879,410.69 $ 2,366,572.47 0.86/0.76 Mar -18 $ 197,279.80 737,506.93 $ 11,832.86 $ 42,321.34 $ 988,940.93 1,685,693.61 $ 696,752.68 $ 1,669,819.79 0.86/0.76 Apr -18 $ (873,683.44) 0.86!0.76 May -18 $ (169,126.92) Yir1%0.72• Jun -18 • • $ 488,527.62 0.82/0.72 Jul -18 $ 101,100.00 650,000.0040,000.00 1,310,080.85 • : r : $ 1,007,508.46 0.82/0.72 Au• -18 $ 101,100.00 650,000.00 $ - $ 40,000.00 $ 791,100.00 1,302,921.94 $ 511,821.94 $ 1,519,330.40 0.82/0.72 Sep $ 97,600.00 650,000.00 $ - $ 40,000.00 NI $ 787,600.00 $ 2,034,652.34 0.82!0.72 Per13 $ 100,008.64 Total YTD$ 5,963,480.839,089,740.58 17,587,880.85 $ 1,359,806.32 Includes Annual Admin Char e of $724,960 + UCS ch. of $1,326,130 + Dividend $1,958,710 + FY 16/17 PGA write off of $10,456.72 +WNA $304.98 = (5) Pension Adjustment = $ - (2) Additional Dividend based on FY 16/17 Net Income =$ 243,633.00 (6) Accrual = $ - (3) Bulk mailing & printing (7) Commodity adjustment from FYE transfer of ECA Collected in PGA Annual ECA Shortfall 4 OPEB liabili &Period 13 Ad'ustment NG Pro •ortion = 98.5% x Total ECA Transfer = $ 1,934,643.69 Net RC = $ 1,699,286.13 Avera • e Annual PGA/Therm =Av• . Fuel Onl = $0.359 - PROPANE Delta/Therm = $0.389 LP GAS PURCHASED GAS ADJUSTMENT (PGA -LP MN on y Cumulative LP PSA ■Total LP Fuel Total LP PGA ge YTD Overage Therm/Gal. Budget Gallons Monthly InterestCommodity Month Prior Year Sold WACOG Char, es Shorts, e) (Shortage) Oct -17 I • $ - $ 983.20 $ 31,437.69 29,627.21 1,2 $ 280,364.46 30,610.41 $ 52,921.65 49,627.18 $ (227,442.81 $ 19,016.77 $ (196,640.10) $ (177,623.33) 2.17/1.99 2.17/1.99 Nov -17 1.18704 Dec -17 :.® Jan -18 • 07.4 $ 1.20'0.18 63,187.32 10 • $ (114,145.49) 2.17/1.99 : • r $ 31,382.08 $ (82,763.41 2.17/1.99 Feb 18 Mar -186• ■ ; : $ 48,728.35) ( 2.17/1.99 Apr -18 ''I 04000 .. 33,280.00 9 $ 19,320.84 $ 5,98.49 2.17/1.99 x.1.95 May -18 0 00 Iflulill_iE1IJ1 $ 30,25.42 2.1.95 $ 55,37.35 2.1.95$ 80,774.27 2.13/1.95 Se -18 28,000.0 $ 0.96000 $ - 26,880.00 26,880.00 53,957.93 $ 27,077.93 $ 107,852.20 2.13/1.95 P13 4 105,534.81 - $ (105,534.81) $ 2,317.39 Total$ 1.10019 424,928.08 $ 783,352.90 $ 754,867.58 $ (28,485.32) Cost Center Expenses CCS Ch., Admin & Dividend $ 174,719.00Accrual = $ FY 16/17 Write off PGA ($247.77) & WNA ($1.21] : - - Fuel$ 15,000.00 Donations to events$ 14,592.041 LP Yard Va onzatioMoss due to malfunctionin meter$ 1,025.95 1 4Ad'ustment from FYE transfer of ECA in PGA Annual ECA Shortfall 3,141.57 1 LP Pro •ortion = 1.5°� x Total ECA Transfer = $ 29,461.58 LP PGA Event fuel cost$ Suburban Software Sr $ 5,785.001 De • reciation of LP tanks$ 34,414.23 -�_ Suburban Software S • tems license Contribution to • era • e LP trk u • • rade $ - $ - 1 1 -� -��- Additional Dividend $ - 2 LP Holding Tank Restoration $ - Pro ected FYE Remainin CLEARWATER GAS SYSTEM SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTIONS FOR FY 2017/2018 Attachment #1 Page 2 of 4 I I $ 248,926.77 $ 325,000.00 $ 76,073.23 ENERGY CONSERVATION A 0 JUSTMENT ECA Total ECA Monthly Overage Cumulative YTD Overage ECA NG/Therm Budget Cost Center Interest Total ECA Month Expenses Notes/Exceptional Items Expense NGV Station Expenses Billed (Shortage) (Shortage) LP/Gal. Prior Year - $ (2,829,335.09) Oct -17 $ 1,554,563.71 Promo$167,631,Adv $929, Employ Costs$62,170 $ 14,146.68 $ 47,380.47 1 $ 1,616,090.86 $ 207,231.19 $ (1,408,859.67) $ (4,238,194.76) 0.20/0.20 Nov -17 $ 103,833.92 Promo$20,158,Adv$720,EmployCosts$82,956 $ 21,190.97 $ 56,123.45 181,148.34 242,271.95 $ 61,123.61 $ (4,177,071.15) 0.20/0.20 Dec -17 $ 178,611.75 Promo$86,001,Adv $14,054, Employ Costs$98,557 $ 20,885.36 $ 49,560.89 249,058.00 284,878.90 $ 35,820.90 $ (4,141,250.24) 0.20/0.20 Jan -18 $ 239,968.31 Promo$139,392, Adv $7,975, EmployCosts$92,601 $ 20,706.25 $ 51,805.16 2 312,479.72 462,180.64 $ 149,700.92 $ (3,991,549.33) , ;0.25/0.25 Feb -18 $ 296,725.13 Promo$209,535,Adv$2,246,Employ Costs$84,944 $ 19,957.75 $ 45,360.73 362,043.61 434,888.81 $ 72,845.20 $ (3,918,704.12) 0.25/0.25 Mar -18 $ 220,354.83 Promo$136,320,Adv$460,EmployCosts$83,575 $ 19,593.52 $ 49,823.84 289,772.19 361,572.47 $ 71,800.28 $ 100,626.20 $ (3,846,903.84) $ (3,746,277.64) 0.25/0.25 0.25/0.25 Apr -18 $ 200,000.00 $ 19,234.52 $ 55,000.00 274,234.52 374,860.72 May -18 $ 200,000.00 $ 18,731.39 $ 55,000.00 3 273,731.39 348,722.47 $ 74,991.08 $ (3,671,286.56) 0.25/0.25 Jun -18 $ 200,000.00 $ 18,356.43 $ 55,000.00 273,356.43 326,409.33 $ 53,052.90 $ (3,618,233.66) 0.25/0.25 Jul -18 $ 200,000.00 $ 18,091.17 $ 55,000.00 4 273,091.17 296,127.22 $ 23,036.05 $ (3,595,197.61) 0.25/0.25 Aug -18 $ 200,000.00 $ 17,975.99 $ 55,000.00 272,975.99 294,533.42 $ 21,557.43 $ (3,573,640.18) 0.25/0.25 Sep -18 $ 200,000.00 $ 17,868.20 $ 55,000.00 272,868.20 294,533.42 $ 21,665.22 $ 2,164,105.27 $ (3,551,974.96) $ (1,387,869.68) 0.25/0.25 P13 $ - $ (200,000.00), 5-8 1200,000.00). 1,964,105.27 Total YTD $ 3,794,057.65 $ 226,738.22 $ 430,054.54 $ 4,450,850.41 $ 5,892,315.82 $ 1,441,465.41 (1) Incl. Annual Admin Charge of $47,520 + UCS chg of $70,460 (8) = Transfer of ECA Collected in PGA up to the ECA Collected for year (up to ECA Annual Shortfall + Dividend $203,120 + FY 16/17 Write off of $2,733.02 = $ 323,833.02 Note: Maximum amount which can be transferred = $ 1,964,105.27 (1) SNEPTransfer= I $ 1,000,000.00 (2) Additional Dividend = $ 25,265.00 (3) Fireworks Sponsorship = $ 40,000.00 (4) Momingside Gas A/C Differential Cost = $ - NGV O&M $?+PGA Recvy non -CGS $? = $ 200,000.00 (5) (6) OPEB Adjustment = (7) ECA Accrual I $ - (8) FY17 loss on Installation WOs = $ - Net ECA CCE = $ 2,404,959.63 Net NGV CCE = $ 230,054.54 REGULATORY IMPOSITION ADJUSTMENT (RIM (EIA) (ORA) Overage YTD Overage NG/Therm Budget Environmental Regulatory Interest Total RIA Total RIA Month Expenses Notes/Exceptional Items Expenses Expense Expenses Billed (Shortage) (Shortage) LP/Gal. Prior Year $ - $ 180,389.23 Oct -17 $ 172,197.65 3,292.01 $- 1 $ 175,489.66 93,408.53 $ (82,081.13) $ 98,308.10 0.09/0.09 Nov -17 $ 916.67 1,963.28 $ - 2,879.95 109,004.94 $ 106,124.99 $ 204,433.09 0.09/0.09 Dec -17 $ 916.67 10,064.64 $- 10,981.31 127,934.58 $ 116,953.27 $ 321,386.36 0.09/0.09 Jan -18 $ 20,380.67 1,324.19 $- 21,704.86 166,135.84 $ 144,430.98 $ 465,817.34 0.09/0.09 Feb -18 $ 916.67 1,191.68 $- 2,108.35 156,566.96 $ 154,458.61 $ 620,275.95 0.09/0.09 Mar -18 $ 916.67 1,423.50 $- 2,340.17 130,311.48 $ 127,971.31 $ 748,247.26 0.09/0.09 Apr -18 $ 10,000.00 90,000.00 $- 2 100,000.00 134,925.37 $ 34,925.37 $ 783,172.63 0.09/0.09 May -18 $ 10,000.00 90,000.00 90,000.00 $- $- 100,000.00 100,000.00 100,000.00 55,785.47 52,216.02 47,371.76 $ (44214.53) $ (47,783.98) $ (52,628.24) $ 738,958.10 $ 691,174.12 $ 638,545.88 b04/004 0.04/0.04 0.04/0.04 Jun -18 $ 10,000.00 Jul -18 $ 10,000.00 90,000.00 $ - Aug -18 $ 10,000.00 90,000.00 $- 100,000.00 47,116.80 $ (52,883.20) $ 585,662.68 0.04/0.04 Sep -18 $ 10,000.00 90,000.00 $- 100,000.00 47,116.80 $ (52,883.20) $ - $ 532,779.47 $ 532,779.47 0.04/0.04 P13 $ 4,5 - - Total YTD $ 256,245.00 $ 559,259.30 $ - 815,504.30 1,167,894.54 $ 352,390.24 (1) Includes annual charges for Admin Charge $13,170 $ 171,280.98 (5) Accrual $ - - + FY 16/17 Write off of $1,630.98 + Dividend $156,480 = (2) Additional Dividend $ 19,464.00 Net EIA = $ 65,500.02 (3) Credit from Council allocation from Added Dividend $ - Net ORA = $ 559,259.30 (4) CIP closed to Operating $ - CLEARWATER GAS SYSTEM SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTIONS FOR FY 2017/2018 Attachment #1 Page 3 of 4 USAGE AND INFLATION ADJUSTMENT UTA Commercial Monthly Cumulative y UTA Budget Interest Overage YTD Overage NG/Therm Month LP Gallons Expense Rate/Gallon NG Therms Rate/Therm (Shortage) (Shortage) LP/Gal Beg. Bal. $ - $ (378,066.49) Oct -17 6,455.1 $ 1,890.33 $ 1,702.48 0.05 0.05 785,608.8 929,051.1 0.05 0.05 $ 37,570.60 $ 45,032.25 $ (340,495.89) $ (295,463.64) $ (244,656.09) $ (209,741.73) $ (174,829.701 $ (143,502.74) 0.05/0.05 0.05/0.05 0.05/0.05 0.03/0.03 0.03/0.03 0.03/0.03 Nov -17 6,489.4 Dec -17 7,452.8 $ 1,477.32 0.05 1,089,383.2 0.05 $ 50,807.55 Jan -18 6,004.7 $ 1223.28 0.03 1 1,252,602.6 0.03 $ 34,914.36 Feb -18 9,624.4 $ 1,048.71 0.03 1,189,483.5 0.03 $ 34,912.03 $ 31,326.96 Mar -18 6,797.8 $ 874.15 0.03 1,078,021.3 0.03 Apr -18 8,600.0 $ 717.51 0.03 1,000,000.0 0.03 $ 29,540.49 $ (113,962.25) 0.03/0.03 May -18 7,200.0 $ 569.81 0.03 950,000.0 0.03 $ 28,146.19 $ (85,816.06) 0.03/0.03 Jun -18 7,200.0 $ 429.08 0.03 900,000.0 0.03 $ 26,786.92 $ (59,029.15) 0.03/0.03 Jul -18 7,200.0 $ 295.15 0.03 875,000.0 0.03 $ 26,170.85 $ (32,858.29) 0.03/0.03 Aug -18 7,200.0 $ 164.29 0.03 775,000.0 0.03 $ 23,301.71 $ (9,556.58) 0.03/0.03 ___ $ 14,611.63 0.03/0.03 - Sep -18 7,200.0 $ 47.78 0.03 800,000.0 0.03 $ 24,168.22 Per 13 $ - $ 14,611.63 Total YTD 87,424.2 10,439.89 11,624,150.5 $ 392,678.12 - (1) Recomputed UTA in December for January application. Decreasedy 2 cents to 3 cents to recover $419,582.35 shortfall from FY 16/17 less overcollections _ __ _ __ in FY 16/17 of ($155,958.31) thru December = $263,624.04 net. (2) Accrual = $ - USAGE AND INFLATION ADJUSTMENT (UTA) Residential Monthly CumulativeUTA__ YTD Overagee NG/Therm_ _ Budget Interest Overage (Shortage) LP/Gal $ (154,894.60) $ (148,241,73) 0.03/0.03 $ (140,669.62) 0.03/0.03 Month LP Gallons Expense RatelGallon NG Therms Rate/Therm (Shortage) Beg. Bal. Oct -17 21,716.4 $ 774.47 0.03 225,191.5 0.03 $ 6,652.87 Nov -17 18,450.5 $ 741.21 0.03 258,102.6 0.03 $ 7,572.11 Dec -17 24,505.1 $ 703.35 0.03 354,258.2 0.03 $ 10,669.42 $ (130,000.20) 0.03/0.03 Jan -18 45,591.9 $ 650.00 0.05 1 580,957.3 0.05 $ 30,535.25 $ (99,464.95) 0,05/0.05 $ (72,860.32)_ 0.05/0.05 $ (54,437.65) 0.05/0.05 $ (37,359.84) 0.05/0.05 $ (22,996.64) 0.05/0.05 Feb -18 29,348.1 $ 497.32 0.05 511,676.0 0.05 $ 26,604.63 Mar -18 32,260.5 $ 364.30 0.05 342,616.1 0.05 $ 18,422.67 Apr -18 22,000.0 $ 272.19 0.05 325,000.0 0.05 $ 17,077.81 May -18 V 16,000.0 $ 186.80 0.05 275,000.0 0.05 $ 14,363.20 Jun -18 15,000.0 $ 114.98 0.05 250,000.0 0.05 $ 13,135.02 $ (9,861.62) 0.05/0.05 Jul -18 20,000.0 $ 49.31 0.05 225,000.0 0.05 $ 12,200.69 $ 2,339.07 0.05/0.05 Aug -18 25,000.0 $ (11.701 0.05 200,000.0 0.05 $ 11,261.70 $ 13,600.77 0.05/0.05 Sep -18 25,000.0 $ (68.001 0.05 200,000.0 0.05 $ 11,318.00 $ 24,918.77 0.05/0.05 Per 13 $ - $ 24,918.77 Total YTD 294,872.5 4,274.24 3,747,801.7 $ 179,813.37 (1) Recomputed UTA in December for January application. Increased by 2 cents to 3 cents to recover $165,790.35 shortfall from FY 16/17 less overcollections in FY 16/17 of ($37,913.02) thru December = $127,877.33 net. CLEARWATER GAS SYSTEM SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTIONS FOR FY 2017/2018 Attachment #1 Page 4 of 4 OTAL ALL COST RECOVERY ADJUSTMENT CLAUSES (Both PGAs + ECA + RIA + UTA) Monthly Cumulative Total Res! Budget Total All Total Recovery Overage YTD Overage NGIThm (Firm) Month Expenses Billed (Shortage) (Shortage) LP/Gal Prior Year - $ - $ (4,410,901.92) Oct -17 $ 7,103,183.17 $ 1,720,814.12 $ (5,382,369.05) $ (9,793,270.97) $ (8,957,510.83) $ (8,007,419.17) 1.23/2.31 1.23/2.31 1.23/2.31 Nov -17 1,156,677.72 $ 1,992,437.86 $ 835,760.14 $ 950,091.66 Dec -17 1,376,631.12 $ 2,326,722.78 Jan -18 1,968,925.32 $ 2,781,277.17 $ 812,351.85 $ (7,195,067.32), 1.25/2.38 1.25/2.38 Feb -18 1,505,359.51 $ 2,704,972.76 $ 1,199,613.25 $ (5,995,454.07) Mar -18 1,324,472.03 1,353,507.26 $ 2,304,780.99 $ 2,361,220.99 $ 980,308.96 $ 1,007,713.73 $ (5,015,145.11) 1.25/2.38 $ (4,007,431.38) 1.25/2.38 Apr -18 May -18 1244,156.41 $ 2,047,300.20 $ 803,143.79 $ (3,204287.59) . 1,16/2.29 1.16/2.29 Jun -18 Jun -18 1,191,482.07 $ 1,918,605.39 $ 727,123.32 $ (2,477,164.27) Jul -18 1,193,031.17 $ 1,745,909.30 $ 552,878.13 $ (1,924,286.14) 1.16/2.29 1.16/2.29 Aug -18 1,192,635.99 $ 1,733,093.49 $ 540,457.50 $ (1,383,828.64) Sep -18 _ 1,187,348.20 $ 1,734,016.30 $ 546,668.10 $ (837,160.54) 1.16/2.29 Per 13 1,840,178.50 $ 1,964,105.27 $ 123,926.77 $ (713,233.77) Total YTD 23,637,588.47 27,335,256.62 $ 3,697,668.15 Last Updated 4/22/2018 E S E R Oct -17 Nov -17 Dec -17 Jan -18 Feb -18 Mar -18 Apr -18 May -18 Jun -18 Jul -18 Aug -18 Sep -18 Total Oct -17 Nov -17 Dee -17 Jan -18 Feb -18 Mar -18 Apr -18 May -18 Jun -18 Jul -18 Aug -18 Sep -18 Total CGS Natural Gas Summary Monthly Actual/Projections (FY78) Arno cNnlE/Vr 2 Volume FTS -1 50.6518 Cost FTS -2 $0,6618 Volume Cost NO-MotIce 50.0478 Volume Cost Capacity Relinquhhment Volume Rate Cost Reservation Adjustments TOTAL RESERVATION COST TOW Rate 170,438 306,570 $ 94,047.69 $ 169,166.33 41,788 55,430 $ 27,237.42 $ 34,826.67 15,500 22,600 $ 740.90 $ 1,075.60(6,771.64) (25,002) (112,687) $ 0.2576 $ 0.1466 $ (11.316,771.64) $60.388 $2875 $ 118,542.6 $ 188,582.811 $0.69 $0.68985 316,788 $ 174,804,17 55,211 3 36,988.83 31,000 $ 1,481.80 (115,447) $ 0.1934 $ (22,330.81) $313.18 $ 190,254.85 50.6616 316,789 $ 174,804.17 55,211 $ 35,986.63 46,600 $ 2,222.70 (40,623) $ 0,8100 $ (16,617.71) $135.43 $ 196,531.12 30.6200 286,132 $ 167,687.64 49,868 S 32,603.96 42,000 5 2,007.40 (116,616) $ 0.2071 $ (23,922.27) 8315.08 $ 166,792.01 $0.6431 316,789 5 174,804,17 65,211 $ 36,986.63 31,000 $ 1.481.80 (61,169) $ 0.2490 $ (16,226.98) $233.28 $ 197,279.80 $0.5771 218,570 $ 119,503.33 53,430 $ 34,825.67 22,500 $ 1,075,50 (40,000) $ 0.2000 $ (8,000.00) $0.00 $ 147,404.50 50.5838 144,212 $ 79,576.18 41,788 $ 27,237.42 12,400 $ 592.72 (40,000) $ 0.2500 $ (10,000.00) $0.00 $ 97,406.32 50.8149 139,580 $ 77,009.21 40,440 $ 26,358.79 10,500 S 501.90 (25,000) 5 0.2500 $ (8,250.00) $0.00 $ 97,819.90 50.5898 144,211 $ 79,578.18 41,788 $ 27,237.42 10,850 $ 518.83 (25,000) $ 0.2500 $ (8,250.00) $0.00 $ 101,082.23 50.5882 144,212 $ 79,576.18 41.788 $ 27,237.42 10,850 $ 518.83 (25,000) $ 0.2500 $ (6,250.00) 30.00 3 101,082.23 $0.5882 139,560 $ 77,009.21 40.440 3 28,358.79 10,500 $ 501.90 (25.000) $ 0.2500 $ (4250.00) $0.00 $ 97,819.90 50.5888 2,641,833 $ 1,457,783.46 570,393 $ 371,782.15 288,100 $ 12,710.58 (650,654) 378.09 ($144,309.16) $1,345.18 $1,699,301.21 50.6009 as of 4/18/2018 Volume FTS -1 (Usage) Rate Cost Volume FTS.2 (Usage) Rate Cost Gait Supply (FGU & Interconnects) Volume Rate Cost Fuel % FOU Management tee $0.065 No Notice Usage OTt Payment 80.020 Cashout Prior Month Adjustment COMMODITY COST 142,384 $ 0.0094 $ 1,341.64 41,788 $ 0.0093 $ 388.63 192,988 $ 3.3209 $ 640,887.20 2.64% $ 11,164.00 $ $ 3,721.00 $ (18.08) $ 19,436.97 $ 676,920,36 148,170 $ 0,0093 $ 1,377.97 53,430 3 0.0093 $ 496.90 206,695 $ 3.3625 $ 696,008.82 2.64% $ 12,672.00 $ • $ 4,032.00 $ 9,711.99 $ 669.00 $ 723,966.68 170,488 $ 0.0083 $ 1,566.54 65,314 $ 0.0083 $ 514,42 238,720 $ 3.8616 $ 626,352.86 2.64% $ 13,578.00 $ - $ 4,616.06 8 2,326.02 $ (2,864.33) $ 846,218.67 233,254 $ 0.993 $ 2,18225 65,211 $ 0.0093 $ 613,88 299,160 3 3.8382 $ 1,146,226.46 2.64% $ 14,483.00 3 - $ 5,769.30 $ 8,994.14 $ 2,690.06 $ 1,182,845.69 161,930 $ 0.0093 $ 1,412.83 49,068 $ 0.0093 $ 163.77 201,671 5 3.1663 $ 637,156.89 2.84% $ 13,278.00 $ - $ 4,035.96 $ 18,376.16 $ 666.84 $ 675,388.35 194,088 $ 0.0093 $ 1,805.01 65,211 $ 0.0093 $ 613.46 267,061 $ 2.8693 $ - 737,697,19 2.64% $ 13,276.00 $ • $ 4,986.00 $ (1,658.33) $ 3,463.65 $ 769,972.98 182,570 $ 0.0094 $ 1,531.85 53,430 $ 0.0093 5 498.90 223,801 $ 3.2087 5 717,014.40 2.64% $ 14,040.00 $ - 5 4,320.00 $ - $ - $ 737,403,15 180,212 $ 0.0094 $ 1,509.83 41,788. $ 0.0093 $ 388.63 208,801 $ 3.2183 $ 671,335.60 3.50% $ 13,130.00 $ - $ 4,040.00 $ - $ • $ 690,403.86 142,580 $ 0.0094 $ 1,343.30 40,440 $ 0.0093 $ 378.09 188,801 $ 3.3013 $ 622,621.20 3.50% $ 11,895.00 $ - $ 3,660.00 $ $ $ 639,895.59 140,212 $ 0.0094 $ 1,321.17 41,788 $ 0.0093 $ 388.83 187,801 3 3.3108 $ 621,105.90 3.50% $ 11,830.00 $ - $ 3,640.00 $ - $ - $ 638,285.70 140,212 $ 0.0094 $ 1,321.17 41,788 $ 0.0093 8 388.63 187,801 $ 3.3543 $ 829,262.80 3.50% $ 11,830.00 $ - 5 3,640,00 $ - $ - $ 646,442.60 141,560 $ 0.0094 $ 1,333.88 40,440 $ 0.0093 $ 376.09 187.601 $ 3 3486 $ 628 203 90 3.50% $ 11 830.00 $ - $ 3 640.00 $ • $ $ 645,383.87 1,927842 - $ 18,053.34 570,496 3 5,305.82 2,580,100 $ 8 574,771.04 $153,004.00 $0.00 $50 000.32 $37,731.90 $24 261.19 $8,863,127,40 Oct -17 Nov -17 Dee -17 Jan -18 Feb -18 Mar•18 Apr -18 May -18 Jun -18 Jul -18 Aug -18 Sep -18 TOTAL COST Resery a Comm RATE $ 792,618.90 $ 4.11 $ 912,6/9.49 $ 4.41 $ 1,036,473,82 $ 4.34 $ 1,378 .81 $ 4.61 $ 844,1 0.36 $ 4.18 $ 967,2E238 $ 3.72 $ 884,807.85 $ 3.96 5 785.9 $ 3.78 S 737 5.448 S 3.91 $ 73 7.93 S 3.94 $ 747¢24.83 $ 3.98 $ 743 3.77 $ 3.96 S 10,562,428.61 $ 4.09 Total Projected DTH WACOG Total Reservation Total Commodity Cost Purchased 1416 Months $ 1,057,088.13 $ 4.865,312.83 $ 5,922,398.76 1,396,495 $4.241 2nd6 Months $ 642,215.06 $ 3,997,814.77 $ 4,640,029.85 1,183,605 33.920 TOTAL $ 1,899,301.21 $ 8,863,127.40 $ 10,562,428.81 2,580,100 $4.094 4 `t`1A C 1{ M6t1 Propane Weighted Average Cost of Gas (WACOG) FY 2017-18 4/18/2018 Date PRIIIIMNINEMI Gallons Deleered Propane Rate Propane Cost Shipping Cost Total Cost FYTD Gallons Cost of Invento Tank Withdraw) WACOG 1=111111, � � y »�, �. � �,,, ®" ®' $ 28,761.18 $ 28761.18 $ 49069.00 28,781 (35) 0.99896 0.99775 1.05848 28.826 MEM ®6=11.<me® ®llffn3t..lnna . 1=EIM !EIMINTIMEI 8.702 '_ � 1.07460 8.996 �El t I I 1.08983 Iij�MM- MONTHLY INVENTORY ADJUSTMENT 8.923®' 701 ®' -+'-MEM $ 81509.66 71680 1.10762 1.55128 S 1087.45 -®MM END OF MONTH,w � :r,�s :... °`. S 46.570,50 43.815 1.10762 r i'®-� c I [.J I 'UI 1.12269 MEMMEEMIIIIIMMIS=1 iEUIMEMEIIi■i 111101E13 MEIGIIIIIMEMIIIE1=1 MINIMMINIIICEIls 10,690.45 S 472.99 IEMEIMEI EM7REIMEMM�' 1�.147T5T0� ®Qe'i-� "' �- 9,135 ® S 483-03 1i' • ' ®' 1 'r3 -�e✓;1a� '® INVENTORY VENTORY ADJUSTMENT 866 3.88133 S 3361 23 - S 3361.23 80 782.0 $ 95,891.78 80,782 - 1.18704 =MEND M END OF MONTH IMITErimir=irminanniimirmrimnommTianzmanmorrm • 'er ' = " S 59,942.16 50,497 30,285 1.18704 1.20268 EMIIIMMEZEM IMIIIIIIII 18001045 _ 9.185 111111EMININEEM1131111E12313111111MIIIII=IENIIMMIIMM311- 1.20902 ® MONTHLY INVENTORY ADJUSTMENT 296 MEM $ $ - 1.20492 ® END OF MONTH <- ' - . $ 57,200.05 47,472 39,767 1.20492 01/10/18 18003345 8.996 1.17635 $ 10,104.76 $ 477.65 $ 10,582.41 56,468.0 $ 67,782.46 56,468 1.20037 01/11/18IrEIMI 18003783 9,066 1.16197 S 10,053.06 $ 481.36 $ 10,534.42 65.534.0 $ 78.316.88 65.534 1.19506 01/22/18 inilM 18005308- 8,704 1.17135 $ 9,733.25 $ 462.14 $ 10,195.39 74,238.0 $ 88,512.27 74,238 - 1.19228 01/23/18 EMI 18005463 9,085 1,083 1.12385 $ 9,727.77 $ 482.37 $ 10210.14 83623.0 $ 98,722.41 83,323 1.18482 01/31/18 MONTHLY INVENTORY ADJUSTMENT $ 3,368.36 _rIMIKSMnllEEEI S 102,090.77 84.406 120952 END OF MONTH 17,646 1.07425 .. .,. $ 18007.75 „. .. $ 948.48 ,. S 18.95623 r s 49,925.0 $ 39,042.11 $ 57,998.34 32,279 49,925 52,127 1.20952 1.6171 02/05/18 MilIMI 18008963- 02/08/18 MEI 180/0086 8680 1.07263 $ 9,047.61 $ 477.31 5 9524.92 58605.0 $ 67,523.26 58,805 1.14826 02/22/18 am 18012513 8.985 1.14513 $ 9,806.01 $ 482.95 $ 10,288.96 67,790.0 $ 77.812.22 67,790 - 1.14784 02122/18 OrM 18012657 9,085 1.16888 S 10130.96 $ 488.32 $ 10.619.28 76,875.0 $ 88,431.50 76,875 - 1.15033 MONTHLY INVENTORY ADJUSTMENT 349 liarilt11311MIMEI-I �- +' END OF MONTH 18015016 ... . 6,937 0.99347 $ 8.396.31 . S 482.33 $ 8,878.64 47,769.0 $ 44,796.78 $ 53675.42 47,769 �, - 1.12365 03/08118 Ini.= 03/09/18 relill 18016014 9,220 1.00910 $ 8,806.30 $ 497.59 $ 9,303.89 56,989.0 $ 62.979.31 56,889 1,10511 03/22/18 reill 18017566. 8,887 1.07910 $ 9,110.29 S 479.63 $ 0589.92 65,876.0 5 72,56923 65,876 - 1.10160 03/23/18 IN 18017839 9,104 1.08160 $ 9,355.55 $ 491.33 $ 9.846.88 74.980.0 $ 82.416.11 74.980 - 1.09917 5111121.11 MONTHLY INVENTORY ADJUSTMENT 90 EMMIIMIIIBEEI-13111111.1373 75.070.0 E S ®" . 0381/18 END OF MONTH . 9,237 0.94450 9 8227.86 S 496.50 ., S 8.724.36 39,219.0 $ 33,002.40 $ 41.726.76 mom 39,219 45,086 - 1.10074 1.06394 04/09/18 ME 18020556 04/10/18t IM 18020669 9,011 0.95138 $ 8,088.55 $ 484.35 $ 8,572.90 48,230.0 $ 50,299.66 48,230 - 1.04291 ---I W 111 E1111111EXIMI .,'lr T7 Projections Delivered Delivered Delivered Cost Total EOM Tank EOM Tank Projected Month CGS Cost Gallons Cost of Inventory Gallons Gallons Cost WACOG Mar 18 Apr -18 $ May -18 $ Jun -18 $ Jul -18 $ Aug -18 $ Sep -18 $ 1.00 45,000 $ 45,000.00 $ 78,002.40 1.00 36,000 $ 36,000.00 $ 67,189.72 1.10 36,000 $ 39,600.00 $ 70,130.79 1.00 27,000 $ 27,000.00 $ 58,867.19 1.00 27,000 $ 27,000.00 $ 57,973.93 0.90 27,000 $ 24,300.00 $ 54,803.92 74,982 65,982 65,982 56,982 56,982 56,982 29,982 $ 33,002.40 29,982 $ 31,189.72 29,982 $ 30,530.79 29,982 $ 31,867.19 29,982 $ 30,973.93 29,982 $ 30,503.92 29,982 $ 28,835.97 1.10 1.04 1.02 1.06 1.03 1.02 0.96 CSW: 04/22/2018 CLEARWATER GAS SYSTEM NATURAL GAS RATE BILLING FACTORS FOR MAY 1, 2018 - SEPTEMBER 30, 2018 BASED ON APPROVED GAS ADJUSTMENT FACTORS Attachment #4 Interr. Contract Firm Natural Gas Rate Schedules NG to NG jigt2 R_ SMF MMF LMF SGS MGL LOS RAC GAC LAC 8L SL w/M& NGV NSS IS CNS Relish( (Non -Real) (Non -Real) Applicable Annual Therm Range 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 or Other Rate Determinant 3 Units) Units) Units) Units) 17,999 99,999 & up 3 Units) 149 tons) tons & +) & up Monthly Customer Charge $12.00 $25.00 $40.00 $95.00 $25.00 $40.00 $95.00 $12.00 $25.00 $40.00 $20.00 $20.00 By Contract $50.00 $250.00 By Contract (For Central Pasco Territory) ($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) ($75.00) $400.00 (By Contract) if not prey. if not prey. if not prey. Non -Fuel Energy CharaelTherm billed billed billed Non -Fuel Energy 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 Contract Energy Conservation Adj. (ECA) 0.25 0.25 0.25 0.25 0.25 0.25 0.25 NA NA NA NA NA NA NA NA NA Regulatory Imposition Adj. (RIA) 0.04 0.04 0.04 0.04 0.04 0.04 0.04 NA NA NA NA NA NA NA NA NA Usage & Inflation Adj. (UTA) 0.05 Q ,Q 0.05 0 QS 0.03 0.03 0.03 tib. NA NA NA NA NA NA NA NA Total Non -Fuel Energy Charge $0.78 $0.78 $0.78 $0.78 $0.74 $0.70 $0.66 $0.20 $0.15 $0.10 $0.20 $0.35 By Contract $0.42 $0.24 By Contract Purchased Gas Adjustment (PGA) Q,$7 0.82 Q QM 0,82 QS/ 0.82 0.82 Q, 0.82 0.82 0.82 0.72 0.82 0.72 0.72 Total Energy Charge/Therm 1.60 1.60 1.60 1.60 1.56 1.52 1.48 1.02 0.97 0.92 1.02 1.17 0.72 1.24 0.96 0.72 + Non -Fuel + Non -Fuel Minimum Monthly Bill $12.00 $25.00 $40.00 $95.00 $25.00 $40.00 $95.00 $12.00 $25.00 $40.00 $20.00 $20.00 By Contract $50.00 $250.00 Customer (For Central Pasco Territory) ($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) ($75.00) $400.00 Charge + @ premise © premise t premise + FAC + FAC + FAC + FAC + Non -Fuel Therm Non -Fuel Therm Rate for Contract Rate for Contract # of Therms # of Therms Compares to LP/Gallon Rate of $ 1.46 $ 1.46 $ 1.46 $ 1.46 $ 1.43 $ 1.39 $ 1.35 $ 0.93 $ 0.89 $ 0.84 $ 0.93 $ 1.07 $ 0.66 $ 1.13 $ 0.88 with 6.0% Franchise $ 1.55 $ 1.55 $ 1.55 $ 1.55 $ 1.51 $ 1.47 $ 1,44 $ 0.99 $ 0.94 $ 0.89 $ 0.99 $ 1.13 $ 0.70 $ 1.20 $ 0.93 Change from 9/2014 Therm Rate $ (0.15) $ (0.15) $ (0.15) $ (0.15) $ (0.15) $ (0.13) $ (0.11) $ (0.12) $ (0.12) $ (0.12) $ (0.12) $ (0.12) $ (0.13) $ (0.16) $ (0.17) $ (0.13) % Change from 9/2014 Therm Rate -6.6% -6.6% -6.6% -6.6% -7.0% -6.2% -5.4% -6.4% -8.6% -6.7% -6.4% -6.1% -7.3% -7.4% -9.8% -8.9% Utility Tax Note: Fuel Rate per Therm 10/01/1973 $0,069 $0.069 $0069 $0.069 $0.069 $0.069 $0.089 $0,069 $0.069 $0.069 $0.069 $0,069 $0.069 $0.069 $0.055 $0.069 Non -Utility Taxable Fuel/Therm $0.751 $0.751 $0.751 $0.751 $0,751 $0.751 $0.751 $0.751 $0.751 $0.751 $0.751 $0751 $0,651 $0.751 $0,665 $0.651 BTU FACTOR = THERMS/100 CUBIC FEET (CCF) 10/2017 11/2017 12/2017 01/2018 02/2018 03/2018 04/2018 05/2018 06/2018 07/2018 08/2018 09/2018 Firm Service Rates 1.043 1.046 1.044 1.043 1.042 1.044 1.045 1.045 Interruptible Service Rates 1.022 1.025 1.024 1.022 1.022 1.024 1.024 1.025 FY 17/18 Ava. 1.044 1.024 CSW:04/22/2018 BTU Factor: 2.714 Gallons/100 cubic feet (CCF) BTU Factor: 2.483 Therms/100 cubic feet (CCF) Therm Factor: 0.915 Therms/Gallon Applicable Annual Gallon Range or Other Rate Determinant Monthly Customer Charge Non -Fuel Energy Charges/Gallon: Non -Fuel Energy Charge (NFE)/Gallor $1.90 Energy Conservation Adj.(ECA)/Gallor 0.25 Regulatory Imposition Adj.(RIA)/Gallon 0.04 Usage & Inflation Adj. (UTA)/Gallon Q 0� RESIDENTIAL MULTI -FAMILY MRLP MMLP NA NA (1 - 3 Units) (4 + Units) CLEARWATER GAS SYSTEM METERED PROPANE (LP) RATE BILLING FACTORS FOR MAY 1, 2018 - SEPTEMBER 30, 2018 BASED ON APPROVED GAS ADJUSTMENT FACTORS LOOP RESL. LRLP NA $12.00 $25.00 $12.00 For Each Meter Total Non -Fuel Charges (NF)/Gal. $2.24 Purchased Gas Adjustment(PGA)/Gal. 1.95 Total Energy Charges/Gallon $4.19 Minimum Monthly Bill $12.00 Utility Tax Note: Fuel Rate per Gallon 10/01/1973 Non -Utility Taxable Fuel/Gallon Change from 9/2014 Gallon Rate % Change from 9/2014 Gallon Rate 0.161 $1.789 $0.02 0.5% $1.90 0.25 0.04 2,0 $2.24 1,25 $4.19 $25.00 0.161 $1.789 $0.02 0.5% $0.90 0.25 0.04 ICA $1.24 1.95 $3.19 $12.00 0.161 $1.789 $0.02 0.6% SMALL COML. LARGE COML. MGLP MLLP 0-2,500 $25.00 $0.30 0.25 0.04 $0.62 1.95 $2.57 $25.00 0.161 $1.789 $0.02 0.8% >2,501 $40.00 $0.25 0.25 0.04 0.03 $0.57 1.95 $2.52 $40.00 0.161 $1.789 $0.02 0.8% VEHICLE LPV (Non-Resl. Only) NA $40.00 Set By Contract NA NA NA Set By Contract Set By Contract Contract NFE + Contract PGA Customer Charge Any Applicable Customer Charge + Any Applicable Facility Charges 0.161 Contract PGA - 0.161 NA NA Attachment #5 Page 1 of 2 STANDBY/GENERATOR CONTRACT MTRD LPSM CLP (Non -Real. Only) NA NA (Closed for New Resl. Applications) $50.00 Set By Contract $1.00 NA NA $1.00 1.9* $2.95 $50.00 0.161 $1.789 $0.01 0.3% Set By Contract NA NA NA Set By Contract 1.65 Contract NFE + $1.650 Customer Charge + Non -Fuel Energy Chg. for the Contracted # of Gallons/Mo. 0.161 Contract PGA - 0.161 NA NA CSW:04/22/2018 BTU Factor: BTU Factor: Therm Factor: 2.714 Galions/100 cubic feet (CCF) 2.483 Therms/100 cubic feet (CCF) 0 915 Thenns/Gallon STANDARD RESIDENTIAL BULK LP SERVICE (Rate Class Is Based on Annual LP Gallon Usage Level) BRLP2 SW..2 BRl.P2 i9M2 BRLP4 CLEARWATER GAS SYSTEM BULK PROPANE (LP) RATE BILLING FACTORS FOR MAY 1, 2018 - SEPTEMBER 30, 2018 BASED ON APPROVED GAS ADJUSTMENT FACTORS RESIDENTIAL "WILL CALL" (Based on Annual Usage Level) WRLP1 - WRLP3 WRLP4 Applicable Annual Gallon Range 0 (No Fills in Yr.) 0.1 -60 80.1 - 120 120.1 - 300 > 300 0 (No Fills In Yr.) 0.1 - 80 60.1 - 120 120.1 -300 > 300 or Other Rate Determinant 1-3 UNITS 1-3 UNITS 1-3 UNITS 1-3 UNITS 1-3 UNITS 1-3 UNITS 1-3 UNITS 1-3 UNITS 1-3 UNITS 1-3 UNITS Annual Customer Charge S 350.00 $ 225.00 $ 180.00 $ 90.00 $ 75.00 $ 350.00 $ 210.00 $ 150.00 S 75.00 $ 60.00 Non -Fuel Chorines (NFifGellon- Non-Fuel Energy Charge (NFEyGal. $ 1.80 $ 1.80 $ 1.60 $ 1.00 $ 0.90 $ 1.80 $ 1,80 $ 1.60 $ 0.90 $ Energy Conservation Adj. (ECA)/Gal $ 0.25 $ 0.25 $ 0.25 0.25 0.25 0.25 0.25 0.25 0.25 Regulatory Imposition Adj. (RIAyGaI $ 0.04 $ 0.04 S 0.04 0.04 0.04 0.04 0,04 0.04 0.04 Usage & Inflation Adj. (UTA)IGallon 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 Total Non -Fuel Charges (NFyGaL $ 2.14 $ 2.14 $ 1.94 $ 1.34 $ 1.24 $ 2.14 $ 2,14 $ 1.94 $ 1.24 $ Purchased Gas Adj. (PGAyGallon $ 1.95 $ 1.95 $ 1.95 $ 1.95 $ 1.95 $ 1.95 $ 1.95 $ 1.95 $ 1.95 $ Total Energy Charges/Gallon S 4.09 $ 4.09 $ 3.89 S 3.29 $ 3.19 $ 4.09 $ 4.09 $ 3.89 $ 3.19 $ Note: No Monthly Minimum Bill Utility Tax Note; Fuel Rate per Gallon 10/01/1973 $ 0.161 $ 0.161 $ 0.161 $ 0.161 $ 0.161 $ 0.161 $ 0.161 $ 0.181 $ 0.181 S Non -Utility Taxable Fuel/Gallon $ 1.789 S 1.789 S 1.789 $ 1.789 $ 1.789 $ 1.789 $ 1.789 $ 1.789 $ 1.789 $ Change from 9/2014 Gallon Rate $ 0.020 $ 0.020 $ 0.020 $ 0.02 $ 0.02 $ 0.22 $ 0.22 $ 0.02 $ 0.02 5 % Change from 9/2014 Gallon Rate 0.5% 0.5% 0.5% 0.6% 0.8% 5.7% 5.7% 0.5% 0.6% COMMERCIAL BULK LP SERVICE (Based on Annual Usage Level) BCLP1 BCLPA 0-2,500 '2,500 Customers In this Customers in this Range of Usage Range of Usage $ 90.00 $ 90.00 BULK STANDBY! GENERATOR LPSB (Closed for New Residental Applications) $ 420.00 0.80 $ 0.25 $ 0.20 $ 1.00 0.25 0.25 0.25 NA 0.04 0.04 0.04 NA 0.05 0.03 0.03 NA 1A4 $ 0.57 $ 0.52 $ 1.00 1.95 $ 1.95 $ 1.95 $ 1.95 3.09 $ 2.52 $ 2.47 $ 2.95 0.161 $ 0.161 $ 0.161 $ 1.789 $ 1.789 $ Attachment #6 Page 2 of 2 CONTRACT BULK LP SERVICE Any Contract Customers Who Requests Bulk Del. Set by contract Set By Contract NA NA Set By Contract 1,65 Cotract NFE 1.650 0.161 $ 0.161 1.789 $ 1.789 Contract PGA - 0.161 (0.08) $ 0.02 $ 0.02 $ 0.01 NA -2.5% 0.8% 0.8% 0.3% NA Attachment #61 :CSW.4/22/ )1e ( I Page 1 of 3 1 Residential Rate History By Components Clearwater Gas System Tota Rate Ad ustments/Therm Contract LP LP/aallon * ECA _ RIA# WNA/UTA-Rest# UTA-Coml# PGA_ PGA PGA/ allon Month' NG/therm I Oct-16 $ 1.48 $ 3.09 $ 0.15 $ 0.09 $ 0.01 $ 0.01 $ 0.79 $ 0.70 $ 1.84 Nov-16 $ 1.48 $ 3.09 $ 0.15 $ 0.09 $ 0.01 $ 0.01 $ 0.79 $ 0.70 $ 1.84 Dec-16 $ 1.48 $ 3.09 $ 0.15 $ 0.09 $ 0.01 $ 0.01 $ 0.79 $ 0.70 $ 1.84 Jan-17 $ 1.47 $ 2.96 $ 0.15 $ 0.09 $ 0.03 $ 0.04 $ 0.76 $ 0.67 $ 1.69 Feb-17 $ 1.47 $ 2.96 $ 0.15 $ 0.09 $ 0.03 $ 0.04 $ 0.76 $ 0.67 $ 1.69 Mar-17 $ 1.47 $ 2.96 $ 0.15 $ 0.09 $ 0.03 $ 0.04 $ 0.76 $ 0.67 $ 1.69 Apr-17 $ 1.53 $ 2.79 $ 0.18 $ 0.09 $ 0.03 $ 0.05 $ 0.79 $ 0.70 $ 1.49 May-17 $ 1.53 $ 2.79 $ 0.18 $ 0.09 $ 0.03 $ 0.05 $ 0.79 $ 0.70 $ 1.49 Jun-17 $ 1.70 $ 2.71 $ 0.20 $ 0.14 $ 0.03 $ 0.05 $ 0.89 $ 0.80 $ 1.34 Jul-17 $ 1.70 $ 2.71 $ 0.20 $ 0.14 $ 0.03 $ 0.05 $ 0.89 $ 0.80 $ 1.34 Aug-17 $ 1.70 $ 2.71 $ 0.20 $ 0.14 $ 0.03 $ 0.05 $ 0.89 $ 0.80 $ 1.34 Sep-17 $ 1.70 $ 2.71 $ 0.20 $ 0.14 $ 0.03 , $ 0.05 $ 0.89 $ 0.80 $ 1.34 FY 16117 Avg. $ 1.559 $ 2.881 $ 0.172 $ 0.107 $ 0.025 $ 0.038 $ 0.816 $ 0.726 $ 1.578 2016 Avg. $ 1.452 $ 2.768 $ 0.167 $ 0.106 $ 0.010 $ 0.010 $ 0.729 I $ 0.639 $ 1.486 Oct-17 $ 1.67 $ 3.31 $ 0.20 $ 0.09 $ 0.03 $ 0.05 $ 0.91 $ 0.81 $ 1.99 Nov-17 $ 1.67 $ 3.31 $ 0.20 $ 0.09 $ 0.03 $ 0.05 $ 0.91 $ 0.81 $ 1.99 Dec-17 $ 1.67 $ 3.31 $ 0.20 $ 0.09 $ 0.03 $ 0.05 $ 0.91 $ 0.81 $ 1.99 Jan-18 $ 1.69 $ 3.38 $ 0.25 $ 0.09 $ 0.05 $ 0.03 $ 0.86 $ 0.76 $ 1.99 Feb-18 $ 1.69 $ 3.38 $ 0.25 $ 0.09 $ 0.05 $ 0.03 $ 0.86 $ 0.76 $ 1.99 Mar-18 $ 1.69 $ 3.38 $ 0.25 $ 0.09 $ 0.05 $ 0.03 $ 0.86 $ 0.76 $ 1.99 Apr-18 $ 1.69 $ 3.38 $ 0.25 $ 0.09 $ 0.05 $ 0.03 $ 0.86 $ 0.76 $ 1.99 May-18 $ 1.60 $ 3.29 $ 0.25 $ 0.04 $ 0.05 $ 0.03 $ 0.82 $ 0.72 $ 1.95 Jun-18 Jul-18 Aug-18 Sep-18 FYTD 17/18 Avg. $ 1.671 $ 3.343 $ 0.231 $ 0.084 $ 0.043 $ 0.038 $ 0.874 $ 0.774 $ 1.985 2017 Avg. $ 1.607 $ 2.936 $ 0.184 $ 0.107 $ 0.030 $ 0.048 $ 0.846 $ 0.753, $ 1.615 incr. Above $ 0.07 $ 0.50 $ 0.07 $ (0.05) $ 0.02 $ (0.02) $ 0.03 $ 0.02 $ 0.46 Last Year Same Month 5% 18% 39% -56% 67% -40% 4% 3% 31% Incr. Based $ 1.40 $ 10.93 on 20 Therms 5% 36% Equivalent Cents/KWH 5.5 12.3 for Gas vs. Duke Rate 13.4 13.4 Note: Duke Energy Florida's residential rate for usage >1,000 KWH in January 2018 is 13.397 cents/KWH. (Residential) Gas Cheaper by -59% -8% Notes: * Based on Bulk LP (BRLP3) which is applicable for customers using 120.1 - 300 gallons/year & equal to Residential LP Will Call (BRWCLP). # New rates implemented 11/1/2014, with following changes: - RS NG Customer Charge increased $2 from $10 to $12/month & NFE rate draped 4 cents to 44 cents/therm. UTA decreased by 9 cents/therm to O. - BRLP3 LP Customer Charge unchanged ed $90/year, and NFE rate unchanged @ $1.00/gallon. UTA decreased by 9 cents/gallon to O. - RIA & ECA unchanged initially.' I f I I r CSW:9/26/201 7 Attachment #6 Page 2 of 3 Competitive History of NG vs. Electric Rates Month -Year September 2001 September 2002 September 2003 September 2004 September 2005 September 2006 September 2007 September 2008 September 2009 September 2010 September 2011 September 2012 September 2013 September 2014 September 2015 September 2016 September 2017 $ Increase over Last 16 Years % Increase over Last 16 Years Avg. Annual Inc. Over Last 16 Yrs. NG Equivalent NG Therm Cost KWH Cost $ 1.34 $ 0.046 $ $ 1.36 $ 0.046 $ $ 1.56 $ 0.053 $ $ 1.69 $ 0.058 $ $ 1.97 $ 0.067 $ $ 1.89 $ 0.065 $ $ 1.86 $ 0.063 $ $ 2.12 $ 0.072 $ $ 1.39 $ 0.047 $ $ 1.39 $ 0.047 $ $ 1.42 $ 0.048 $ $ 1.48 $ 0.051 $ $ 1.67 $ 0.047 $ $ 1.75 $ 0.047 $ $ 1.57 $ 0.047 $ $ 1.38 $ 0.047 $ $ 1.70 $ 0.058 $ $ 0.36 $ 0.01 $ 26.9% 26.8% 1.7% 1.7% Progress Energy KWH Cost 0.084 0.074 0.084 0.089 0.097 0.119 0.120 0.120 0.132 0.136 0.129 0.132 0.123 0.123 0.123 0.123 0.130 0.05 54.8% 3.4% NG vs. Electric -46% -37% -37% -35% -31% -46% -47% - 40% -64% -65% - 62% - 62% - 62% -62% -62% -62% -55% CSW:11/2812017 ;Attachment #6 +-- I Page 3 of 3 j I 1 i Annual Average CGS Residential Rates Calender Year Fiscal Year Year NG/Therm LP/Gallon * Year NG/Therm LP/Gallon * 1995 NA NA FY 95/96 $ 0.880 $ 1.199 * 1996 $ 0.915 $ 1.239 * FY 96/97 $ 1.019 $ 1.370 * 1997 $ 1.049 $ 1.380 * i FY 97/98 $ 1.054 $ 1.318 * 1998 $ 1.032 $ 1.288 * I FY 98/99 $ 1.052 $ 1.269 * 1999 $ 1.073 $ 1.311 FY 99/00 $ 1.152 $ 1.504 2000 $ 1.222 $ 1.584 , FY 00/01 $ 1.551 $ 1.649 2001 $ 1.549 $ 1.586 FY 01/02 $ 1.352 $ 1.488 2002 $ 1.342 $ 1.553 FY 02/03 $ 1.477 $ 1.817 2003 $ 1.534 $ 1.864 FY 03/04 $ 1.603 $ 1.913 2004 $ 1.652 $ 1.968 FY 04/05 $ 1.803 $ 2.162 2005 $ 1.925 $ 2.278 FY 05/06 $ 2.080 $ 2.480 2006 $ 2.012 $ 2.501 FY 06/07 $ 1.918 $ 2.742 2007 $ 1.893 $ 2.869 FY 07/08 $ 1.932 $ 3.183 2008 $ 1.965 $ 3.186 FY 08/09 $ 1.610 $ 2.524 2009 $ 1.464 $ 2.418 FY 09/10 $ 1.437 $ 2.865 2010 $ 1.457 $ 2.946 FY 10/11 $ 1.475 $ 3.282 2011 $ 1.487 $ 3.438 FY 11/12 $ 1.506 $ 3.639 2012 $ 1.501 $ 3.548 FY 12/13 $ 1.582 $ 3.257 2013 $ 1.629 $ 3.297 FY 13/14 $ 1.629 $ 3.297 2014 $ 1.717 $ 3.528 FY 14/15 $ 1.602 $ 3.133 2015 $ 1.576 $ 3.003 FY 15/16 $ 1.479 $ 2.718 2016 $ 1.452 $ 2.768 FY 16/17 $ 1.700 $ 2.710 2017 $ 1.607 $ 2.936 Average $ 1.502 $ 2.360 $ 1.495 $ 2.342 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 ►eve Greener thGas Fuel Use and Cost Comparison (Effective Rates for May 2018) Want to make the switch to naturalgas? CallClearwater Gas System, today at (727) 562-4980. APPLIANCE ANNUAL THERMS USED NATURAL GAS PROPANE (LP) GAS ELECTRIC COOKING 45 $ 72.00 $162.00 $176.85 WATER HEATING -Gas Tank Style/Gas Tankless vs. Electric Tank Style 170 / 100 $272.00 /1160.00* $559.30 / $360.00* $668.10 HEATING 150 $240.00 $540.00 j $589.50 I CLOTHES DRYING 50 $ 80.00 $180.00 $196.50 I TOTAL APPLIANCE USAGE - with tank/tankless $664.00/ $552.00* $1,441.30/ $1,242.00* $1,630.95 GAS SAVINGS VS. ELECTRICITY 59% / 66%* 12% / 24%* when using tankless *when using tankless- LP OUTDOOR RECREATION: POOL HEATING* I 375 $600.00 I $1,350.00 I $1,473.75 SPA/HOT TUB HEAT* I 175 I $280.00 I $ 630.00 [ $ 687.75 *varies according to pool size, conditions, and temperature maintained weather I I I All other figures are annual average projections based upon the following: 1. 1 therm =100,000 BTUs of energy 2. Natural Gas $1.60 per therm per gallon or Per KWH or $3.60 per therm $3.93 per therm I 3. LP Gas per gallon (BRLP3) 1 $3.29 4. Duke Energy per KWH (Based on >1000 KWH rate) $0.13397 1. Notes: The above analysis is based on May 2018 residential energy and fuel charges and does not include fees. charges are: Gas $12.00-$20.00 (varies by rate class), Clearwater Gas System $12.00 and L.P. customers are billed annually, $75-$210 (non-refundable) depending on program. applicable taxes or franchise 2. Current monthly customer Duke Energy $8.76, Peoples $20.00 in Central Pasco. 711 Maple Street • Clearwater, FL 33755 • (727) 562-4980 www.clearwatereas.com