Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
GAS ADJUSTMENTS EFFECTIVE JUNE 1, 2017
CLEARWATER GAS SYSTEM Interoffice Correspondence Sheet TO: William B. Horne II, City Manager FROM: Chuck Warrington, Managing Director COPIES: RECEIVED JUN 02 2011 OFFICIAL RECORDS AND LEGISLATIVE SRVCS DEPT. Micah Maxwell, Assistant City Manager; Rosemarie Call, City Clerk; 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 JUNE 1, 2017 DATE: May 25, 2017 Natural Gas supply rates have risen somewhat recently while Propane (LP) supply rates thus far this year have remained lower than we had earlier projected. Therefore, we are recommending an increase in our Natural Gas Purchased Gas Adjustment (PGA) of 100 per therm and a decrease in our Propane (LP) PGA of 15¢ per gallon for June. We recommend that we continue our standard Contract LP PGA be set at 300 below our Standard LP PGA. Our Energy Conservation Adjustment (ECA) costs have increased this year; therefore, we are recommending an increase in our ECA of 2¢ per therm or gallon for June. Also, our Regulatory Imposition Adjustment (RIA) costs have increased this year; therefore, we are recommending an increase in our RIA of 5¢ per therm or gallon for June. We are not recommending any change in our Residential Usage & Inflation Adjustment (UTA) nor our Commercial UIA in June. The net effect of these recommended changes is a 17¢ per therm ( +11.1 %) increase in our typical Residential Natural Gas customer's rate but an 80 per gallon ( -2.9 %) decrease in our typical Residential LP customer's rate for June. Therefore, we are recommending your approval of the following rates to become effective for billings rendered on and after June 1, 2017: Natural Gas Firm Standard Rate Schedule PGA 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) $0.89 per therm (up 100 per therm) $0.80 per therm (up 10¢ per therm) $1.34 per gallon (down 15¢ per gallon) $1.04 per gallon (down 15¢ per gallon) $0.20 per therm or gallon (up 2¢) $0.14 per therm or gallon (up 5¢) Usage & Inflation Adjustment (UTA) - Residential .... $0.03 per therm or gallon (no change) - Commercial $0.05 per therm or gallon (no change) William B. Horne II, City Manager May 25, 2017 Page 2 Attachment #1 shows the status of our Adjustment Recovery Clause balances with actuals thru April. 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, Pages #1 and #2 shows our monthly rate history over the past 4+ years, and Pages #3 and #4 of this show our 15 year relationship to electric prices and average residential rates, respectively. Please note that Page #3 of this analysis shows that, over the past 15 years, our residential natural gas rates have risen just 3.0% as compared to a 46.4% increase for the Duke Energy (formerly Progress Energy Florida/FPC) residential rates. That's an average annual increase of 0.2% /year for natural gas vs. 3.1% /year for electric - -- our natural gas rates increased only 6% 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 55% lower than electric for Natural Gas and 22% 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 an increase in our standard posted price at our Natural Gas Vehicle (NGV) Fueling Station effective June 1, 2017, to $1.52 per gasoline gallon equivalent (GGE -- up 13¢) - -- still 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 is $1.34 /gge, as these fleets pay no Federal taxes on fuel - -- still an amazing price. This increase is needed as a result of the Congress not passing the Tax Extender package this year, which prior to January 1st gave us a 50¢ /gge Excise Tax Credit for NGV vehicle fuel. 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 June 1St billings. If you have any questions on this, please call me. CSW /cw Attachments Approved: William B. Horne II, City Manager U:WIy Documents \MSOFFICE \WINWORD\GASRATES \Gas Adjustments for June 2017.docx CLEARWATER GAS SYSTEM SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTIONS FOR FY 2016/2017 Attachment #1 Page 1 of 4 NATURAL GAS PURCHASED GAS ADJUSTMENT P A -NG Monthly Overage (Shortage) Cumulative YTD Overage (Shortage) NG PGA Rate/Therm Firm /Contr Budget Reservation Commodity Charges Interest Expense Cost Center Expenses Total NG Fuel Expenses - Total NG PGA Billed Month Char; es Prior Year $ (508,409.031 ; ' ;0.79/0.70 Oct -16 $ 4,077,993.95 1,331,140.38 $ 2,542.05 $ 33,532.42 1 $ 5,445,208.80 $ 1,236,815.88 $ (4,208,392.92) $ 482,546.04 $ (4,716,801.95) Nov -16 $ 180,313.78 634,641.58 $ 23,584.01 $ 33,589.61 $ 872,128.98 1,354,675.02 $ (4,234,255.n $ (3,773,761.75) 0.79/0.70 0.79/0.70 Dec -16 $ 195,972.73 796,012.80 $ 21,171.28 $ 39,305.68 $ 1,052,462.49 1,512,956.64 $ 460,494.15 Jan -17 $ 199,360.87 923,197.18 $ 18,868.81 $ 31,085.26 $ 1,172,512.12 1,625,985.43 $ 453,473.31 $ 519,547.64 $ (3,320,288.44) 0.76/0.07., Feb -17 $ 176,647.96 871,136.42 $ 16,601.44 $ 32,558.99 $ 1,096,944.81 1,616,492.45 $ (2,800,740.81) $ (2,296,335.931 0.76/0.67 0.76/0.67 Mar -17 $ 196,103.14 716,169.33 $ 14,003.70 $ 43,881.77 $ 970,157.94 1,474,562.82 $ 504,404.88 As r-17 $ 1,094,02625 847,097.69 $ 11,481.68 $ 35,147.47 2 $ 1,987,753.09 1,641,952.08 $ (345,801.01) $ 607,349.62 $ (2,642,136.94) $ (2,034,787.32)1 $ (1,351,357.01) $ j739,959.74)1 0/9/P0 0.79/0.70 0.89/0080'; 0.89/0.80 May -17 $ 95,000.00 750,000.00 $ 13,210.68 $ 35,000.00 $ 893,210.68 1,500,560.30 Jun -17 $ 92,000.00 725,000.00 $ 10,173.94 $ 35,000.00 $ 862,173.94 1,545,604.25 $ 683,430.31 Jul -17 $ 95,000.00 725,000.00 $ 6,756.79 $ 35,000.00 $ 861,756.79 1,473,154.05 $ 611,397.26 Aug -17 Sep -17 $ 95,000.00 $ 92,000.00 725,000.00 $ 3,699.80 $ 35,000.00 $ 858,699.80 1,473,154.05 $ 614,454.25 $ (125,505.49) 0.89/0.80 725,000.00 $ 627.53 $ 35,000.00 $ 852,627.53 1,473,154.05 $ 620,526.52 $ 495,021.03 0.89/0.80 Per13 - $ 1,277,665.39 4,5,7 $ 1,277,665.39 - $ (1,277,665.39) $ (782,644.36) Total YTD $ 6,589,418.68 $ 9,769,395.38 $ 142,721.70 $ 1,701,766.59 $ 18,203,302.35 $ 17,929,067.02 $ (274,235.33) $ - $ - (1) Includes Annual Admin Charge of $720,950 + UCS chg of $1,274,820 + Dividend $1,958,710 (5) (6) + FY 15/16 PGA write off of $8,183.02 + WNA $62.98 = $ 3,962,726.00 Pension Adjustment = Accrual = mil— (2) Additional Dividend based on FY 15/16 Net Income = $ 955,522.00 (3) Bulk mailing & printing 13 Adjustment $ - $ - (7) Commodity adjustment from FYE transfer NG Proportion = 98.5% x Total ECA Transfer of ECA Collected in PGA © Annual ECA Shortfall (4) OPEB liability & Period = $ 1,277,665.39 Net RC = $ 1,671,170.68 1 Average Annual PGA/Therm = $0.735 Avg Fuel Only = Delta/Therm = $0.400 $0.334 _ PROPANE (LP) GAS PURCHASED GAS ADJUSTMENT (PGA -LP) Cum ul Live YTD Overage (Shortage) $ 87,705.97 LP PGA Therm /Gal. 2.01/1.84 2.01/1.84 Monthly_ Overage (Shortage) Budget Gallons Monthly Interest Commodity Total LP Fuel Total LP PGA Month Sold WACOG Expense Charges Expenses Billed Prior Year Oct -16 33,154.7 $ 0.73568 $ - $ 24,391.25 1,2 $ 296,787.19 $ 57,690.22 $ (239,096.97) $ _(151,391.00 $ (120,482.31) Nov -16 29,149.6 $ 0.74743 $ 756.95 21,787.29 22,544.24 53,452.93 $ 30,908.69 Dec -16 30,859.5 $ 0.81239 $ 602.41 25,069.95 25,672.36 56,378.45 $ 30,706.09 $ (89,776.22) $ (55,319.88) 2.01/1.84 1.85/1.69 1.85/1.69 1.85/1.69 Jan -17 41,963.0 $ 0.89468 $ 448.88 37,543.46 37,992.34 72,448.68 $ 34,456.34 Feb -17 31,781.2 $ 0.93039 $ 276.60 29,568.91 29,845.51 53,566.94 $ 23,721.43 $ (31,598.45) $ (2,786.17) Mar -17 37,506.9 $ 0.90921 $ 157.99 34,101.65 34,259.64 63,071.92 $ 28,812.28 Apr -17 29,978.3 $ 0.86545 $ 13.93 25,944.72 25,958.65 45,977.93 $ 20,019.28 $ 17,233.11 1.63/1.49 1.63/1.49 1.46/1.34 May -17 29,000.0 $ 0.86000 $ - 24,940.00 24,940.00 — 43,077.06 $ 18,137.06 $ 35,370.171 $ 48,488.86 Jun -17 27,000.0 $ 0.85000 $ - 22,950.00 22,950.00 36,068.69 $ 13,118.69 Jul -17 26,000.0 $ 0.87000 $ - 22,620.00 22,620.00 34,732.81 $ 12,112.81 $ 60,601.67 1.46/1.34 Aug -17 26,000.0 $ 0.88000 $ - 22,880.00 22,880.00 34,732.81 $ 11,852.81 $ 72,454.48 1.46/1.34 Sep -17 26,000.0 $ 0.85000 $ - 22,100.00 22,100.00 34,732.81 $ 12,632.81 $ 85,087.29 1 .46/1.34_ P13 4 47,060.89 - $ (47,060.89) $ 38,026.39 Total YTD 368,393.2 $ 0.85207 $ 2,256.77 $ 313,897.22 $ 635,610.82 $ 585,931.25 $ (49,679.58) Cost Center Expenses CCS Chg, Admin & Dividend $ 162,220.00 1 (3) Accrual = $ - FY 15/16 Write off PGA & WNA $ 787.90 1 Fuel $ 15,000.00 1 Donations to events $ 12,002.51 1 LP Yard Vaporization /loss due to malfunctionin • meter $ 181.73 1 (4) Adjustment from FYE transfer of ECA in PGA © Annual ECA Shortfall LP PGA Event fuel cost $ 2,155.57 1 LP Proportion = 1.5% x Total ECA Transfer = $ 19,456.83 Suburban Software Systems $ 5,785.00 1 — De • reciation of LP tanks $ 34,414.23 1 Suburban Software Systems license $ - 1 Contribution to garage LP trk up grade $ - 1 Additional Dividend $ 39,849.00 2 _ t LP Holding Tank Restoration $ - Projected FYE Remainin • CLEARWATER GAS SYSTEM SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTIONS FOR FY 2016/2017 Attachment #1 Page 2 of 4 I $ 272,395.94 $ 300,000.00 $ 27,604.06 ENERGY CONSERVATI • N ADJUSTMENT ECA Monthly Overage Cumulative YTD Overage ECA _ NG/Therm_ LP /Gal. 0:15/0,15 0.15/0.15 0.15/6.15 Bud et Cost Center Interest Total ECA Total ECA Month Ex•enses Notes /Exceptional Items Expense NGV Station Expenses Billed (Shortage) (Shortage) $ 1,782,195.04)_ Prior Year - Oct -16 $ 1,469,018.10 Promo$70,807,Adv $1,040, Employ Costs$76,926 $ 8,910.98 $ 46,980.19 1 $ 1,524,909.27 $ 153,577.58 $ (1,371,331.69) $ (3,153,526.73) $ (3,183,062.04) $ (3,313,815.24)_ Nov -16 $ 119,981.15 Promo$48,390,Adv $3,496, Employ Costs$68,095 $ 15,767.63 $ 64,026.75 199,775.53 170,240.22 202,690.13 $ (29,535.31) $ (130,753.20) Dec-16 $ 238,683.96 Promo$147,888,Adv $1,870, Employ Costs$88,925.96 $ 15,91531 $ 78,844.06 333,443.33 Jan -17 $ 273,594.09 Promo$182,045,Adv $2,357, Employ Costs$89,222 $ 16,569.08 $ 50,219.69 340,382.86 228,986.49 $ (111,396.37) $ (11,953.69) _ $ (3,425,211.61) 0.15/0.15 $ (3,437,165.29) 0.15/0.15 Feb -17 $ 163,886.35 Promo$81,925,Adv $1,564, Employ Costs$70,390 $ 17,126.06 $ 53,757.30 234,769.71 222,816.02 Mar -17 $ 175,677.28 Promo$104,690,Adv $1,964, Employ Costs$69,293 $ 17,185.83 $ 50,492.91 243,356.02 204,136.99 $ (39,219.03) $ (3,476,384.32) 0.15/0.15 0.18/0.18 0.18/0.18 0.20 /0:20 ;, 0.20/0.20 0.20/0.20_ A.r -17 $ 245,159.45 Promo$70,648,Adv $1,963, Employ Costs$73,460 $ 17,381.92 $ 51,221.96 2 313,763.33 255,658.36 $ (58,104.97) $ (3,534,489.29) May -17 $ 150,000.00 $ 17,672.45 $ 60,000.00 227,672.45 234,890.66 $ 7318.21 $ (3,527,271.08) Jun -17 $ 150,000.00 $ 17,636.36 $ 60,000.00 227,636.36 238,67832 $ 11,042.27 $ (3,516,228.81) $ 53,516,286.83)___ $ 53,516,345.14) $ (3,516,403.75) $ (2,019,281.52 Jul -17 $ 150,000.00 $ 17,581.14 $ 60,000.00 227,581.14 227,523.12 $ (58.02) $ (58.31) $ (58.60) $ 1,497,122.22 $ (237,086.48) Au. -17 $ 150,000.00 $ 17,581.43 $ 60,000.00 227,581.43 227,523.12 Sep -17 $ 150,000.00 $ 17,581.73 $ 60,000.00 227,581.73 227,523.12 1,297,122.22 $ 3,891,366.66 0.20/0.20 P13 $ - $ (200,000.00) $ 495,542.86 4 -8 (200,000.002 $ 4,128,453.15 Total YTD $ 3,436,000.38 $ 196,909.91 Annual Shortfall 1) Incl. Annual Admin Charge of $47,260 + UCS chg of $67,740 (8) = Transfer of ECA Collected in PGA up to the ECA Collected for year (up to ECA $ 1,297,122.22 + Dividend $203,120 + FY 15/16 Write off of $2,124.95 = $ 320,244.95 Note: Maximum amount which can be transferred = 1 SNEP Transfer = 1 $ 1,000,000.00 (2) Additional Dividend = $ 99,088.00 3 FY17 loss on Installation WOs = $ - __ _ (4 Pension Adjustment NGV = ��:. �;:- NGV O&M $59,871.26 +PGA Recvy non -CGS $131,077.85 = $ 200,000.00 5) _ 6 OPEB Adjustment =E „arz , 44•) 7 ECA Accrual $ - Net ECA CCE = $ 2,016,667.43 Net NGV CCE = $ 295,542.86 REGULATORY IMPOSITION ADJUSTMENT (RIA) — _ (EIA) (ORA) Budget Environmental Regulatory Interest Total RIA Total RIA Overage YTD Overage (Shortage) NG/Therm LP /Gal. Month Expenses Notes /Exceptional Items Expenses Expense Expenses Billed (Shortage) Prior Year _ $ - $ 21,860.34 0.09/0,09 0.09/0.09 Oct -16 $ 171,462.19 99,109.68 $ - 1 $ 270,571.87 92,147.00 $ $ (156,564.53) Nov -16 $ 720.00 66,404.28 $ 782.82 67,907.10 102,134.18 _(178,424.87), $ 34,227.08 $ (122,337.45) $ (98,647.15) Dec -16 $ 720.00 96,581.19 $ 611.69 97,912.88 121,603.18 $ 23,690.30 0.09/0.09 Jan -17 $ 720.00 87,280.50 $ 493.24 88,493.74 137,377.67 $ 48,883.93 $ (49,763.22) 0.09/0.09 Feb -17 $ 720.00 136,239.03 $ 248.82 137,207.85 133,672.13 $ (3,535.72) $ (53,298.93) 0.09/0.09 $ (52,917.76) 0.09/0.09 Mar -17 $ 720.00 121,100.66 $ 266.49 122,087.15 122,468.33 $ 381.18 Apr -17 $ 77,056.00 124,060.55 $ 264.59 2 201,381.14 127,954.61 $ (73,426.53) $ (126,344.29) 0.09/0.09 May -17 $ 1,000.00 120,000.00 $ - 121,000.00 117,452.46 $ (3,547.54) $ (129,891.83) $ (83,80635) 0.09/0.09 0:14/0.14 0.14/0.14 0.14/0.14 Jun -17 $ 1,000.00 120,000.00 $ - 121,000.00 167,085.18 $ 46,085.18 Jul -17 $ 1,000.00 120,000.00 $ - 121,000.00 159,275.86 $ 38,275.86 $ (45,530.79) $ (7,254.93) Aug -17 $ 1,000.00 120,000.00 $ - 121,000.00 159,275.86 $ 38,275.86 Sep -17 $ 1,000.00 120,000.00 $ - 121,000.00 159,275.86 $ 38,275.86 $ 31,020.92 0.14/0.14 P13 $ - - 4,5 - - $ - $ 31,020.92 -- Total YTD $ 257,118.19 $ 1,330,775.89 $ 2,667.65 1,590,561.73 1,599,722.31 $ 9,160.58 (1) Includes annual charges for Admin Charge $12,660 + FY 15/16 Write off of $1,602.19 + Dividend $156,480 = $ 170,742.19 (5) Accrual $ - ___ ___ ___ (2) Additional Dividend $ 76,336.00 Net EIA = $ 10,040.00 (3) Credit from Council allocation from Added Dividend $ - Net ORA = $ 1,330,775.89 (4) CIP closed to Operating $ - _ CLEARWATER GAS SYSTEM SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTIONS FOR FY 2016/2017 Attachment #1 Page3of4 USAGE AND INFLATION ADJUSTMENT JUIA � Commercial Monthly_ Overage (Shortage) $ - Cumulative YTD Overage UTA _ NG/Ther_m_ • LP /Gal 0.01/0.01 Budget Interest Month LP Gallons Expense Rate /Gallon NG Therms Rate/Therm (Shortage) $ (387,898.82) Beg. Bal. Oct -16 6,769.4 $ 1,939.49 0.01 795,485.4 0.01 $ 4,934.31 $ (382,964.51) Nov -16 6,319.1 $ 1,914.82 0.01 864,123.4 0.01 $ 6,783.36 $ (376,181.15) $ 5368,072.63)_ $ (326,380.85) 0.01/0.01 Dec -16 7,086.2 $ 1,880.91 0.01 993,106.7 0.01 $ 8,108.52 0.01/0.01 0.04/0.04 0.04/0.04 0.04/0.04 005/0.05 0.05/0.05 0.05/0.05 Jan -17 6,643.8 $ 1,840.36 0.04 1 1,083,387.4 0.04 $ 41,691.78 Feb -17 7,594.7 $ 1,631.90 0.04 1,081,557.6 0.04 $ 41,897.93 $ (284,482.92) $ (245,745.81) Mar -17 8,058.0 $ 1,422.41 0.04 997,048.2 0.04 $ 38,737.11 Apr -17 8,555.0 $ 1,228.73 0.05 1,041,025.0 0.05 $ 51,180.50 $ (194,565.31) May -17 7,500.0 $ 972.83 0.05 900,000.0 0.05 0.05 $ 45,375.00 $ 42,875.00 $ (149,190.31) $ (106,315.31) Jun -17 7,500.0 $ 745.95 0.05 850,000.0 Jul -17 7,500.0 $ 531.58 0.05 825,000.0 0.05 $ 41,625.00 $ 40,350.00 $ (64,690.31) $ (24,340.31) _ _ 0.05/0.05 0.05/0.05 Aug -17 7,000.0 $ 323.45 0.05 800,000.0 0.05 Sep -17 7,000.0 $ 121.70 0.05 800,000.0 0.05 $ 40,350.00 $ 16,009.69 0.05/0.05 Per 13 $ - $ 16,009.69 _ Total YTD 87,526.2 14,554.14 11,030,733.7 $ 403,908.51 (1) Recomputed UTA in December for January application. Increased by 3 cents to recover $390,270.32 from FY 15/16 less overcollections in FY 15/16 of ($2,371.50) = $387,898.82. (2) Accrual = $ - _ __ _ USAGE AND INFLATION ADJUSTMENT (DIAL Residential Monthly Cumulative UTA_ NG/Therm _ LP/G_a_I_ _ 0.01/0.01 0.01/0.01 Budget Interest Overage YTD Overage (Shona e $ (79,116.66) Month LP Gallons Expense Rate /Gallon NG Therms Rate/Therm (Shortage) Beg. Bal. Oct -16 26,110.4 $ 395.58 0.01 195,970.9 0.01 $ 1,824.02 $ 2,265.87 $ (77,292.64) $ (75,026.77) Nov -16 22,797.9 $ 386.46 0.01 242,130.1 0.01 Dec -16 23,735.4 $ 375.13 0.01 328,366.1 0.01 $ 3,149.18 $ X71,877.59) $ (59,310.90) 0.01/0.01 0.03/0.03 0.03/0.03 Jan -17 35,292.1 $ 359.39 0.03 1 401,787.9 0.03 $ 12,566.69 Feb-17 24,159.4 $ 296.55 0.03 372,651.0 0.03 $ 11,619.26 $ (47,691.64) Mar -17 29,400.0 $ 238.46 0.03 327,177.5 0.03 $ 10,467.12 $ (37,224.52) 0.03/0.03 Apr -17 21,396.2 $ 186.12 0.03 351,088.2 0.03 $ 11,002.98 $ (26,221.54) 0.03/0.03 0.03/0.03 0.03/0.03- May -17 18,000.0 $ 131.11 0.03 250,000.0 0.03 $ 8,040.00 $ (18,181.54) $ (11,041.54) Jun -17 18,000.0 $ 90.91 0.03 220,000.0 0.03 $ 7,140.00 18,000.0 $ 55.21 0.03 185,000.0 0.03 $ 6,090.00 $ A951.54) $ 1,138.46 0.03/0.03 0.03/0.03 Aug -17 18,000.0 $ - 0.03 185,000.0 0.03 $ 6,090.00 Sep -17 18,000.0 $ - 0.03 185,000.0 0.03 $ 6,090.00 $ 7,228.46 0.03/0.03 Per 13 $ - $ 7,228.46 Total YTD 272,891.4 2,514.93 3,244,171.7 $ 86,345.12 (1) Recomputed UTA in December for January application. Increased by 2 cents to recover $93,716.36 from FY 15/16 less overcollections in FY 15/16 of ($14599.70) = $79,116.66. CLEARWATER GAS SYSTEM SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTIONS FOR FY 2016/2017 Attachment #1 Page 4 of 4 TOTAL ALL COST RECOVERY ADJUSTMENT CLAUSES Both PGAs + ECA + RIA + UTA Monthly Overage (Shortage) $ - Cumulative YTD Overage (Shortage) $ (2,648,053.24) $ (8,638,541.35) $ (8,111,345.63)1 $ (7,715,950.58) $ i7,236,274.891,. $ (6,654,978.04) Total Res' • NG/Thm (Firm) LP /Gal _ 1,04/2:09 1.04/2.09 _ 1.04/2.09 1,03/1.96 1.03/1.96 Budget Total All Expenses Total Recovery Billed Month Prior Year - - Oct 16 $ 7,537,477.12 $ 1,546,989.01 $ (5,990,488.11) $ 527,195.72 Nov -16 1,162,355.86 $ 1,689,551.58 Dec 16 1,509,491.06 $ 1,904,886.10 $ 395,395.04 Jan -17 1,639,381.05 $ 2,119,056.74 $ 479,675.69 Feb -17 1,498,767.88 $ 2,080,064.73 $ 581,296.85 Mar -17 1,369,860.76 $ 1,913,444.29 $ 543,583.53 $ (6,111,394.51) $ (6,506,524.261_ $ (5,823,951.91) 1.03/1.96 1.09/1.79 °' 1,26!1.71 1.26/1.71 Apr -17 2,528,856.21 $ 2,133,726.46 $ (395,129.75) Ma -17 1,266,823.13 $ 1,949,395.48 $ 682,572.35 Jun -17 1,233,760.29 $ 2,037,451.74 $ 803,691.45 $ (5,020,260.46 $ (4,310,817.55) Jul -17 1,232,957.93 $ 1,942,400.84 $ 709,442.91 Aug 17 1,230,161.23 $ 1,941,125.84 $ 710,964.61 $ (3,599,852.941_ $ (2,882,036.35) $ (2,709,640.41L _ 1.26/1.71 Sep -17 1,223,309.25 $ 1,941,125.84 $ 717,816.59 1.26/1.71 _ Per 13 1,124,726.28 $ 1,297,122.22 $ 172,395.94 Total YTD 24,557,928.05 24,496,340.87 $ (61,587.17) Last Updated 05/15/2017 R E S Oct -16 Nov-16 E Dec -16 R Jan -17 Feb -17 ✓ Mar -17 A Apr -17 May -17 T Jun -17 Jul -17 Aug -17 O Sep -17 N Total 0 M M 0 D T Oct -16 Nov -16 Dec -16 Jan -17 Feb -17 Mar -17 Apr -17 May -17 Jun -17 Jul-17 Aug -17 Sep-17 Total 4-774c(4 MEAl'r *Z CGS Natural Gas Summary Monthly Actual/Projections (FY17) Volume FTS-1 80.5518 Cost FTS -2 90.8518 Volume Cost No- Notice 50.0478 Volume Cost Capacity Relinquishment Volume Rate Cost Reservation Adjustments TOTAL RESERVATION COST Total Rate 170,438 $ 94,047.69 41.788 $ 27,237.42 15,500 $ 740.90 (25,166) $ 0.2433 $ (6,853.08) 595.02 $ 115,267.95 $0.5776 306,570 $ 169,165.33 53,430 $ 34,825.87 22,500 $ 1,075.50 (155,863) $ 0.1807 $ (25,052.94) 5300.22 $ 180,313.78 90.7956 316,789 $ 174,804.17 55,211 $ 35,988.53 31,000 $ 1,481.80 (105,030) $ 0.1571 $ (18,502.67) 1202.90 $ 195,972.73 90.6577 316,789 $ 174,804.17 55,211 $ 35,986.53 46,500 $ 2,222.70 (86,909) 1 0.1573 $ (13,673.91) 121.38 $ 199,360.87 10.6012 286,132 $ 157,887,64 49,8688 $ 32,503.96 42,000 $ 2,007.80 (124,645) $ 0.1267 $ (16,035.81) 9284.57 $ 176,647.96 10.8972 316,769 $ 174,504.17 55,211 $ 35,986,53 31,000 $ 1,481.80 (109,802) $ 0.1496 $ (18,425.13) $255.77 $ 198,103,14 80.6686 216,570 $ 119,503.33 53,430 $ 34,825.87 22,500 $ 1,075.50 (73,346) $ 0.2332 $ (17,107.12) $206.87 $ 138,504.25 $0.6320 144,212 $ 79,578.18 41,788 5 27,237.42 12,400 $ 592.72 (50,000) $ 0,2500 $ (12,500.00) 50.00 5 94,906.32 50.6395 139,560 $ 77,009.21 40,440 $ 26,358.79 10,500 $ 501.90 (50,000) 8 0.2500 $ (12,500.00) 50.00 5 91,389.90 90.8503 144,212 $ 79,578.18 41,788 5 27,237.42 10,850 $ 518.63 (50,000) $ 0.2500 $ (12,500.00) 90.00 $ 94,832.23 $0.6458 144,212 $ 79,576.18 41,788 $ 27,237.42 10,850 $ 518.63 (50.000) $ 0.2500 $ (12,500.00) 90.00 $ 94,832.23 90.6458 139,560 $ 77.009.21 40,440 $ 26,358,79 10,500 $ 501,90 (50,000) $ 0.2500 $ (12,500.00) 90,00 $ 91,369.90 50.8503 2,641,833 $ 1,457,763.48 570,393 $ 371,782.15 266,100 $ 12,719.58 (933,761) 41.788 $ 0.0154 (9174,150.66) $1,366.73 51,669,481.26 90.6561 50,5518 50.6518 $0.0478 as of 5/11/2017 Volume FTS -1 (Usage) Rate Cost Volume FTS -2 (Usage) Rate Cost Gas Supply (FGU & Peoples) Volume Rate Cost Fuel % FGU Management fee 90.065 No Notice Usage GTI Payment $0.020 Cashout Prior Month Adjustment COMMODITY COST 139,506 $ 0.0113 $ 1,576.43 41,788 $ 0.0113 $ 472.20 185,061 $ 3.5100 $ 649,555.42 3.10% $ 11,825.00 $ - $ 3,625.58 $ 1,064.83 $ 450.14 $ 668,569.90 149,370 $ 0.0113 $ 1,687.89 53,430 $ 0.0113 $ 603.76 207,558 $ 3.2568 $ 875,974.43 3.10% $ 14,190.00 $ - $ 4,058.00 $ 3,758.07 $ 3,399.13 $ 703,669.28 160,839 $ 0.0113 $ 1,817.49 55,211 $ 0.0113 1 623.88 220,357 $ 3.8645 $ 851,680.43 3.10% $ 15,542.00 $ - $ 4,321.00 $ 1,102.65 $ 19,302.54 $ 894,389.99 183,189 $ 0.0113 $ 2,070.05 55,211 $ 0.0113 $ 623.88 241,683 $ 3.8094 8 920,671.89 3.10% $ 15,542.00 $ - $ 4,768.00 $ (4,336.65) $ 653.18 $ 939,992.35 156,332 $ 0.0113 $ 1,766.56 49,868 $ 0.0113 $ 583.51 213,860 $ 3.5274 $ 754,361.55 3.10% $ 14,866.00 $ - 8 4,124.00 $ (7,740.35) $ 2,105.02 $ 770,046.29 181,531 8 0.0113 $ 2,051.31 55,211 $ 0.0113 $ 623.88 237,852 $ 3.3085 $ 786,935.20 3.10% $ 13,515.00 $ - $ 4,734.84 $ 1,554.71 $ 425.16 $ 809,840.10 142,655 8 0.0202 $ 2,881.63 53,430 $ 0.0202 8 1,079.29 197,967 $ 3.4656 $ 656,106.98 4.05% $ 12,183.00 $ - $ 3,921.70 $ (4,983.60) $ 6,805.72 $ 707,974.72 150,212 $ 0.0154 $ 2,313.26 41,788 $ 0.0154 $ 643.54 197,000 $ 3.7014 $ 729,188.00 3.50% $ 12,480.00 $ - $ 3.840.00 $ • $ - $ 748,444.80 142,560 $ 0.0154 $ 2,195.42 40,440 $ 0.0154 $ 622.78 187,000 8 3.8799 $ 888,140.00 3.50% $ 11,895.00 $ $ 3,660.00 $ - $ - $ 706,513.20 141.212 $ 0.0154 $ 2,174.66 41.788 $ 0.0154 $ 643.54 187,000 $ 3.7454 $ 700,388.00 3.50% $ 11,895.00 $ - $ 3,860,00 $ - $ - $ 718,761.20 141,212 $ 0.0154 $ 2,174.66 41,788 $ 0.0154 $ 643.54 187,000 $ 3.7454 $ 700,388.00 3.50% $ 11,895.00 $ • 5 3,660.00 $ - $ - $ 718,761.20 145,560 $ 0.0154 $ 2,241.62 40,440 $ 0.0154 $ 622.78 190,000 $ 3.7244 $ 707,640.00 3.50% $ 12,090.00 $ - 9 3,720.00 $ - 5 $ 726 314.40 $ 24,951.00 570,393 $ 7,766.56 2,452,367 ,�t<.'w k =3 }; $ 8,851,009.90 9157,898.00 80.00 948,091.42 (59,580.34) 033 140.89 59 113 277.43 1,834,178 , 9xt ;;;- Oct -16 Nov-16 Dee -16 Jan -17 Feb -17 Mar -17 Apr -17 May-17 Jun -17 Jul•17 Aug -17 Sep -17 TOTAL COST Resery & Comm RATE $ 783,837.85 $ 4.24 $ 883,983.06 $ 4.26 $ 1,090,362.72 8 4.95 $ 1,139,353.22 8 4.71 $ 946,694.25 $ 4.43 $ 1,005,943.24 $ 4.23 $ 846,478.97 $ 4.28 $ 843,351.12 $ 4.28 $ 797,883.10 $ 4.27 $ 813,593.43 $ 4.35 $ 813,593.43 $ 4.35 9 817,884.30 $ 4.30 $ 10,782,758.69 8 4.40 Total Projected DTH WACOO Total Reservation Total Commodity Cost Purchased 1st 6 Months $ 1,063,686.43 $ 4,786,507.91 $ 5,850,174.34 1,306,400 14.478 2nd 6 Months $ 605,814.83 $ 4.326,769.52 $ 4,932,584.3$ 1,145,967 54.304 TOTAL $ 1,669,481.26 $ 9,113,277.43 $ 10,782,758.69 2,452,367 94.397 Propane Weighted Average Cost of Gas (WACOG) FY 2016 -17 A7TAGI-44610 r 4.3 5(11/2017 Date Gallons Delivered TEIMI 10/13/16 10/14/16 10/31/16 16046684 16047012 8.858 MONTHLY INVENTORY ADJUSTMENT END OF MONTH ElEIEMMIMMI 11/30/16 11/30/16 12/08/16 12/09/16 MONTHLY INVENTORY ADJUSTMENT END OF MONTH 12/29/17 MIME 01/11/17 01/12/17 01/26/17 02/09/17 16056857 16057078 17060409 END OF MONTH TEM EL'! 02/10/17 02/23/17 17063047 17063282 17065456 8,756 9,026 8,715 215 Propane Rate Propane Cost Shipping Cost Total Cost FYTD Gallons Tank Withdrawl WACOG f 30,311.00 43,985 0.79070®'.'' 0.68912 0.70489 0.71709 0.72649 8,546 8,721 8,785 8 894 MONTHLY INVENTORY ADJUSTMENT END OF MONTH 02/24/17 03/15/17 03/16/17 17068632 17069027 17070538 17071066 9.139 18.198 200 8,702 9,001 0.76516 f 26,125.47 immthirmal .. 35,512 IMICIEEIIMZEIIIMIDEMENEEIHEINIMEMMEMI =1=1111111111=111111111M1•f 46,080.92 11111=111311111171M 70,619.0 49,486 0.87766 0.87266 $ 7 362.01 f 7519.12 443.89 456.11 0.95267 8,905 8.995 0.99892 1.01642 MONTHLY INVENTORY ADJUSTMENT END OF MONTH I IEWMICITEMI WINIMIEDMI 17074577 MONTHLY INVENTORY ADJUSTMENT ENO OF MONTH 04/06/17 17077056 04/30/17 MONTHLY INVENTORY ADJUSTMENT END OF MONTH I_- 8.991 9,005 9 000 9.192 146 1.04153 1.05904 INTER f 8 040.65 f 8,485.89 $ 8,640.07 S 8,884.81 f 1,063.00 $ 9 105.53 $ 9277.40 0.88279 9,001 9,204 259 moncra 17,958 48 0.82580 0.83580 0.89083 0.80055 $ 8 051.63 $ 7,849.96 f 180.00 f 7,495.58 $ 7,25621 S 421.84 $ 249.49 f 258.05 $ 255.30 f 257.89 f f 258.87 259.27 f 259.13 $ 264.65 $ 7.805.90 $ 7,975.23 $ 16,771.91 79.989.0 89.128.0 107 326.0 8,290.14 f 8,743.74 f 8,895.37 f 9,142.70 $ 1,063.00 116,228.0 125229.0 S 9,364.40 f 9,536.67 f 8,310.76 $ 8,114.61 ■ $ 180.00 $ 260.25 f 266.13 f $ 7,755.83 134,134.0 143,129.0 $ 36,987.56 f 44,793.46 $ 52,768.69 $ 69,540.60 $ 47,192.88 S 55,936.62 $ 64 831.99 f 73,974.69 58,380 0.73568 0.73568 t � 0.74606 21,551 0.74743 0.76727 67,519 0.78154 85.717 0.81128 85.917 56,589 0.81239 0.83396 f 65,590 0.85282 74.495 0.87029 83.490 0.88603 ®® lEntl=11111E213 152,501.0 161,506.0 170,506.0 179,698.0 188,845.0 f 51 991.42 $ 61,528.09 f 69 838.85 f 77,953.46 rIMITTEIM1 J r.i I f 63.483.12 f 7248.06 207,085.0 215,967.0 56,636 0.89468 0.89468 0.91799 65,641 0.93734 74,641 0.93566 83.833 0.92987 f 55,538.94 EIIIIIIMEM®1®E11112EIMI 60.359 0.93039 0.92014 f 14,032.09 251,501.0 69.563 0.90653 0.90921 0.90921 0.88882 0.87831 0.86543 0.86545 0.84367 '® Projections Delivered Delivered Delivered Month CGS Cost Gallons Cost Cost Total EOM Tank EOM Tank Projected of Inventory Gallons Gallons Cost WACOG Apr -17 May-17 $ Jun -17 $ Jul-17 $ Aug -17 $ Sep -17 $ Oct -17 $ Nov -17 $ Dec-17 $ Jan -18 $ 0.85 0.85 0.90 0.90 0.80 0.80 0.80 0.80 0.80 27,000 27,000 18,000 18,000 18,000 18,000 27,000 38,000 45,000 $ 22,950.00 $ 22,950.00 $ 16,200.00 $ 16,200.00 $ 14,400.00 $ 14,400.00 $ 21,600.00 $ 30,400.00 $ 36,000.00 $ 52,975.00 $ 52,740.82 $ 45,859.12 $ 46,393.88 $ 44,945.97 $ 43,992.66 $ 50,564.99 $ 58,835.53 $ 64,079.90 61,694 61,694 52,694 52,694 52,694 52,694 61,694 72,694 79,694 34,694 34,694 34,694 34,694 34,694 34,694 34,694 34,694 34,694 34,694 $ 30,025.00 $ 29,790.82 $ 29,659.12 $ 30,193.88 $ 30,545.97 $ 29,592.66 $ 28,964.99 $ 28,435.53 $ 28,079.90 $ 27,896.55 0.87 0.86 0.85 0.87 0.88 0.85 0.83 0.82 0.81 0.80 CSW:5/15/2017 CLEARWATER GAS SYSTEM Attachment #4 NATURAL GAS RATE BILLING FACTORS FOR JUNE 1, 2017 - SEPTEMBER 30, 2017 BASED ON APPROVED GAS ADJUSTMENT FACTORS Interr. Contract Firm Natural Gas Rate Schedules N Rate NG Ra e RS SMF MMF LME. SGS MGS LGS RAC GAC LAC SL SL w /M& NGV NSS IS CNS Relight (Non -Rest) (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 812.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 Charge/Therm 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.20 0.20 0.20 0.20 0.20 0.20 0.20 NA NA NA NA NA NA NA NA NA Regulatory Imposition Adj. (RIA) 0.14 0.14 0.14 0.14 0.14 0.14 0.14 NA NA NA NA NA NA NA NA NA Usage & Inflation Adj. (UIA) 0.03 0.03 0.03 0.03 0.05 0.05 0.05 NA NA NA NA NA NA NA NA NA Total Non -Fuel Energy Charge $0.81 $0.81 $0.81 $0.81 $0.81 $0.77 $0.73 $0.20 $0.15 $0.10 $0.20 $0.35 By Contract $0.42 $0.24 By Contract Purchased Gas Adjustment (PGA) 0.89 0.89 0.89 0.89 0.89 0.89 0.89 0.89 0.89 0.89 0.89 0.89 0.80 0.89 0.80 0.80 Total Energy Charge/Therm 1.70 1.70 1.70 1.70 1.70 1.66 1.62 1.09 1.04 0.99 1.09 1.24 0.80 1.31 1.04 0.80 + 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 @ 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.56 $ 1.56 $ 1.56 $ 1.56 $ 1.56 $ 1.52 $ 1.48 $ 1.00 $ 0.95 $ 0.91 $ 1.00 $ 1.13 $ 0.73 $ 1.20 $ 0.95 with 6.0% Franchise $ 1.65 $ 1.65 $ 1.65 $ 1.65 $ 1.65 $ 1.61 $ 1.57 $ 1.06 $ 1.01 $ 0.96 $ 1.06 $ 1.20 $ 0.78 $ 1.27 $ 1.01 Change from 9/2014 Therm Rate $ (0.05) $ (0.05) $ (0.05) $ (0.05) $ (0.01) $ 0.01 $ 0.03 $ (0.05) $ (0.05) $ (0.05) $ (0.05) $ (0.05) $ (0.05) $ (0.09) $ (0.09) $ (0.05) Change from 9/2014 Therm Rate -2.2% -2.2% -2.2% -2.2% -0.5% 0.5% 1.5% -2.7% -2.7% -2.8% -2.7% -2.5% -2.8% -42% -5.2% -3.4% Utility Tax Note: Fuel Rate per Therm 10/01/1973 $0.069 $0.069 $0.069 $0.069 $0.069 $0.069 $0.069 $0.069 $0.069 $0.069 $0.069 $0.069 Non - Utility Taxable Fuel/Therm $0.821 $0.821 $0.821 $0.821 $0.821 $0.821 $0.821 $0.821 $0.821 $0.821 $0.821 $0.821 BTU FACTOR = THERMS /100 CUBIC FEET (CCF) 10/2016 11/2016 12/2016 01/2017 02/2017 03/2017 04/2017 05/2017 06/2017 07/2017 08/2017 09/2017 Firm Service Rates 1.047 1.050 1.044 1.045 1.046 1.044 1.045 1.045 1.043 Interruptible Service Rates 1.027 1.030 1.024 1.025 1.025 1.024 1.024 1.024 1.023 $0.069 $0.069 $0.055 $0.069 $0.731 $0.821 $0.745 80.731 FY 16/17 Avg. 1.045 1.025 CSW:05/15/2017 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 Galion Range or Other Rate Determinant Monthly Customer Charge Non -Fuel Enerav Charaes/Gailon: Non -Fuel Energy Charge (NFE) /Gallor Energy Conservation Adj.(ECA) /Gallor Regulatory Imposition Adj.(RIA) /Gallon Usage & Inflation Adj. (UTA) /Gallon Total Non -Fuel Charges (NF)/Gal. Purchased Gas Adjustment(PGA) /Gal. Total Energy Charges /Gallon Minimum Monthly Bill 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 CLEARWATER GAS SYSTEM METERED PROPANE (LP) RATE BILLING FACTORS FOR JUNE 1, 2017 - SEPTEMBER 30, 2017 BASED ON APPROVED GAS ADJUSTMENT FACTORS RESIDENTIAL MULTI - FAMILY LOOP RESL. SMALL COML. LARGE COML. VEHICLE MRLP MMLP LRLP MGLP MLLP LPV NA NA (1 - 3 Units) (4 + Units) (Non -Rest. Only) NA 0 - 2,500 >2,501 NA $12.00 $25.00 $12.00 $25.00 $40.00 $40.00 For Each Meter $1.90 $1.90 $0.90 $0.30 $0.25 Set By Contract 0.20 0.20 0.20 0.20 0.20 NA 0.14 0.14 0.14 0.14 0.14 NA 0.03 0.03 0.03 0.05 0.05 NA $2.27 $2.27 $1.27 $0.69 $0.64 Set By Contract 1.34 114 1.34 1 34 Lail Set By Contract $3.61 $3.61 $2.61 $2.03 $1.98 Contract NFE + Contract PGA Customer Charge $12.00 $25.00 $12.00 $25.00 $40.00 Any Applicable Customer Charge + Any Applicable Facility Charges 0.161 $1.179 ($0.56) - 13.5% 0.161 $1.179 ($0.56) -13.4% 0.161 $1.179 ($0.56) -17.7% 0.161 $1.179 ($0.52) -20.4% 0.161 $1.179 ($0.52) -20.8% 0.161 Contract PGA - 0.161 NA NA Attachment #5 Page 1 of 2 STANDBY /GENERATOR CONTRACT MTRD LPSM CLP (Non -Rest. Only) NA NA (Closed for New Resl. Applications) $50.00 Set By Contract $1.00 NA NA NA $1.00 1.34 $2.34 $50.00 0.161 $1.179 ($0.60) -20.4% Set By Contract NA NA NA Set By Contract Contract NFE + $1.040 Customer Charge + Non -Fuel Energy Chg. for the Contracted # of Gallons/Mo. 0.161 Contract PGA - 0.161 NA NA CSW:05/15/2017 BTU Factor: 2.714 Gallons/100 cubic feet (CCF) BTU Factor: 2.483 Therms /100 cubic feet (CCF) Therm Factor: 0.915 Therms/Gallon CLEARWATER GAS SYSTEM BULK PROPANE (LP) RATE BILLING FACTORS FOR JUNE 1, 2017 - SEPTEMBER 30, 2017 BASED ON APPROVED GAS ADJUSTMENT FACTORS STANDARD RESIDENTIAL BULK LP SERVICE RESIDENTIAL "WILL CALL" (Rata Class is Based on Annual LP Gallon Usage Level) (Based on Annual Usage Level) BRLPO BRLP1 MO/ ARLP3 BRLP4 JNE LPO WRLP1 WRLP2 WRLP3 WRLP4 Applicable Annual Gallon Range 0 (No Fills in Yr.) 0.1 - 60 60.1 - 120 120.1 - 300 > 300 0 (No Fills in Yr.) 0.1 - 60 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 $ 350.00 $ 225.00 $ 180.00 $ 90.00 $ 75.00 $ 350.00 $ 210.00 $ 150.00 $ 75.00 $ 60.00 Non -Fuel Charges (NFVGallon: Non -Fuel Energy Charge (NFE)/Gal. $ 1.80 $ 1.80 $ 1.60 $ 1.00 $ 0.90 $ 1.80 $ 1.80 $ 1.60 $ 0.90 $ Energy Conservation Adj. (ECA)/Gal $ 0.20 $ 0.20 $ 0.20 0.20 0.20 0.20 0.20 0.20 0.20 Regulatory Imposition Adj. (RIA)fGal $ 0.14 $ 0.14 $ 0.14 0.14 0.14 0.14 0.14 0.14 0.14 Usage & Inflation Adj. (UTA) /Gallon 0.03 0.03 0.03 0.03 0.03 0,03 0.03 0.03 0.03 Total Non -Fuel Charges (NF)IGaI. $ 2.17 $ 2.17 $ 1.97 $ 1.37 $ 1.27 $ 2.17 $ 2.17 $ 1.97 $ 1.27 $ Purchased Gas Adj. (PGA) /Gallon $ 1.34 $ 1.34 $ 1.34 $ 1.34 $ 1.34 $ 1.34 $ 1.34 $ 1.34 $ 1.34 $ Total Energy Charges /Gallon $ 3.51 $ 3.51 $ 3.31 $ 2.71 $ 2.61 $ 3.51 $ 3.51 $ 3.31 $ 2.61 $ Note: No Monthly Minimum Bill Utility Tax Note: Fuel Rate per Gallon 10101/1973 $ Non - Utility Taxable FueVGallon $ COMMERCIAL BULK LP SERVICE (Based on Annual Usage Level) BCLP1 BCLP2 0 -2,500 >2,500 Customers In this Customers In this Range of Usage Range of Usage $ 90.00 $ 90.00 0.80 $ 0.25 $ 0.20 0.20 0.20 0.20 0.14 0.14 0.14 0.03 0.05 0.05 1.17 $ 0.64 $ 0.59 1.34 $ 1.34 $ 1.34 2.51 $ 1.98 $ 1.93 Attachment #5 Page 2 of 2 BULK STANDBY/ CONTRACT BULK GENERATOR LP SERVICE LPSB CCLP (Closed for New Resldental Any Contract Applications) Customers Who Requests Bulk Del. $ 420.00 Set by contract $ 1.00 Set By Contract NA NA NA NA NA Lib $ 1.00 Set By Contract $ 1.34 $ 2.34 Cotract NFE + 0.161 $ 0.161 $ 0.161 $ 0.161 $ 0.161 $ 0.161 $ 0.161 $ 0.161 $ 0.161 $ 0.161 $ 0.161 $ 0.181 $ 1.179 $ 1.179 $ 1.179 $ 1.179 $ 1.179 $ 1.179 $ 1.179 $ 1.179 $ 1.179 $ 1.179 $ 1.179 $ 1.179 $ 1.040 0.161 $ 0.161 1.179 Contract PGA - 0.161 Change from 9/2014 Gallon Rate $ (0.560) $ (0.580) $ (0.580) $ (0.58) $ (0.56) $ (0.36) $ (0.36) $ (0.56) $ (0.56) $ (0.88) $ (0.52) $ (0.52) $ (0.60) NA % Change from 9/2014 Gallon Rate -13.8% -13.8% -14.5% -17.1% -17.7% -9.3% -9.3% -14.5% -17.7% -20,8% -20.8% -21.2% -20.4% NA CS?*f:5/15/2017 i Attachment #6! ( 1 1 1 Page 1 of 4 Residential Rate History By Components Clearwater Gas System Contract LP t , Adiustments/Therm Tota Rate Month NG /therm LP /.allon * ECA RIA# WNA/UTA -Rest# UTA -Coml# PGA PGA PGA/.allon $ 0.01 $ 0.01 $ 0.79 $ 0.70 $ 1.84 r Oct -16 $ 1.48 $ 3.09 $ 0.15 $ 0.09 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.671 $ 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 Aug -17 Sep -17 FY 16/17 Avg. $ 1.512 $ 2.938 $ 0.162 $ 0.096 $ 0.023 $ 0.033 $ 0.791 $ 0.701 $ 1.657 2016 Avg. $ 1.452 $ 2.768 $ 0.167 $ 0.106 $ 0.010 $ 0.010 $ 0.729 $ 0.639 $ 1.486 Incr. Above $ 0.32 $ 0.14 $ 0.01 $ 0.02 $ 0.02 $ 0.04 $ 0.27 $ 0.27 $ 0.09 Last Year Same Month 23% 5% 5% 17% 200% 400% 44% 51% 7% Incr. Based $ 6.40 $ 3.06 on 20 Therms 23% 6% Equivalent Cents/KWH 5.8 10.1 for Gas vs. Duke Rate 13.0 13.0 Note: Duke Energy Florida's residential rate for usage >1,000 KWH in April 2017 is 12.971 cents /KWH. (Residential) Gas Cheaper by -55% -22% 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: 1 - RS NG Customer Charge increased $2 from $10 to $12/month & NFE rate droped 4 cents to 44 cents /therm. UTA decreased by 9 cents/therm to 0. - BRLP3 LP Customer Charge unchanged $90 /year, and NFE rate unchanged @ $1.00 /gallon. UTA decreased by 9 cents/gallon to 0. - RIA & ECA unchanged initially. 1 I I 1 I 1 1 I I CSW:04/28/2017 I Attachment #6 Page 2 of 4 Residential Rate History By Components Clearwater Gas System i r 1 1 _ Total Rate Ad justments/Therm Contract LP Month NG /therm LP /gallon'° ECA RIA# j WNA/UTA -Rest# UTA -Coml# PGA PGA PGA/gallon_ I Oct -12 $ 1.48 $ 3.26 $ 0.14 $ 0.05 $ 0.08 $ 0.06 $ 0.73 $ 0.63 $ 1.99 Nov -12 $ 1.48 $ 3.26 $ 0.14 j $ 0.05 $ 0.05 $ 0.08 $ 0.13 $ 0.06 $ 0.06 $ 0.73 $ 0.73 , $ 0.63 $ 0.63 $ 1.99 $ 1.99 Dec -12 $ 1.53 $ 3.31 $ 0.14 Jan -13 $ 1.53 $ 3.31 $ 0.14 $ 0.05 $ 0.13 $ 0.06 $ 0.73 $ 0.63 $ 1.99 _ Feb-13 $ 1.56 $ 3.29 $ 0.13 $ 0.08 $ 0.16 $ 0.06 $ 0.71 $ 0.61 $ 1.92 Mar -13 $ 1.56 $ 3.29 $ 0.13 $ 0.08 $ 0.16 $ 0.06 $ 0.71 $ 0.61 $ 1.92 Apr -13 $ 1.60 $ 3.22 $ 0.13 $ 0.08 $ 0.16 $ 0.06 $ 0.75 $ 0.65 $ 1.85 May -13 $ 1.60 $ 3.22 $ 0.13 $ 0.08 $ 0.16 $ 0.06 $ 0.75 $ 0.65 $ 1.85 Jun-13 $ 1.65 $ 3.23 $ 0.15 $ 0.10 $ 0.13 $ 0.06 $ 0.79 $ 0.69 $ 1.85 Jul -13 $ 1.65 $ 3.23 $ 0.15 $ 0.10 $ 0.13 $ 0.06 $ 0.79 $ 0.69 $ 1.85 _ Aug -13 $ 1.67 $ 3.23 $ 0.15 $ 0.10 $ 0.13 $ 0.06 $ 0.81 $ 0.71 $ 1.85 Sep-13 $ 1.67 $ 3.23 $ 0.15 $ 0.10 $ 0.13 $ 0.06 $ 0.81 $ 0.71 $ 1.85 FY 12/13 Avg. $ 1.582 $ 3.257 $ 0.140 $ 0.077 $ 0.132 $ 0.060 $ 0.753 $ 0.653 $ 1.908 2012 Avg. $ 1.501 I $ 3.548 $ 0.133 $ 0.031 $ 0.073 T $ 0.067 $ 0.785 $ 0.700 $ 2.312 Oct -13 $ 1.70 $ 3.45 $ 0.14 $ 0.10 $ 0.13 $ 0.06 $ 0.85 $ 0.76 $ 2.08 Nov -13 $ 1.70 $ 3.45 $ 0.14 $ 0.10 $ 0.13 $ 0.06 $ 0.85 $ 0.76 $ 2.08 Dec -13 $ 1.66 $ 3.41 $ 0.14 $ 0.10 $ 0.09 $ 0.07 $ 0.85 $ 0.76 $ 2.08 Jan -14 $ 1.69 $ 3.52 $ 0.14 $ 0.10 $ 0.09 $ 0.07 $ 0.88 $ 0.79 $ 2.19 Feb-14 $ 1.68 $ 3.70 $ 0.14 $ 0.10 $ 0.09 $ 0.07 $ 0.87 $ 0.78 $ 2.37 Mar -14 $ 1.70 $ 4.27 $ 0.14 $ 0.10 $ 0.09 $ 0.07 $ 0.89 $ 0.80 $ 2.94 Apr -14 $ 1.70 $ 4.27 $ 0.14 $ 0.10 $ 0.09 $ 0.07 $ 0.89 $ 0.80 $ 2.94 May -14 $ 1.75 $ 3.27 $ 0.14 $ 0.10 $ 0.09 $ 0.07 $ 0.94 $ 0.85 $ 1.94 Jun -14 $ 1.75 $ 3.27 $ 0.14 $ 0.10 $ 0.09 $ 0.07 $ 0.94 $ 0.85 $ 1.94 Jul-14 $ 1.75 $ 3.27 $ 0.14 $ 0.10 $ 0.09 $ 0.07 $ 0.94 $ 0.85 $ 1.94 Aug -14 $ 1.75 $ 3.27 $ 0.14 $ 0.10 $ 0.09 $ 0.07 $ 0.94 $ 0.85 $ 1.94 Sep-14 $ 1.75 $ 3.27 $ 0.14 $ 0.10 $ 0.09 $ 0.07 $ 0.94 $ 0.85 $ 1.94 FY 13/14 Avg. $ 1.715 $ 3.535 $ 0.140 $ 0.100 $ 0.097 $ 0.068 $ 0.898 $ 0.808 $ 2.198 2013 Avg. $ 1.629 $ 3.297 $ 0.140 $ 0.089 $ 0.137 1 $ 0.061 $ 0.783 $ 0.686 $ 1.931 Oct -14 $ 1.78 $ 3.47 $ 0.14 $ 0.12 $ 0.09 $ 0.07 $ 0.95 $ 0.85 $ 2.12 Nov -14 $ 1.65 $ 3.38 $ 0.14 $ 0.12 $ - $ - $ 0.95 $ 0.85 $ 2.12 Dec -14 $ 1.65 $ 3.38 $ 0.14 $ 0.12 $ - $ - $ 0.95 $ 0.85 $ 2.12 Jan -15 $ 1.65 $ 3.38 $ 0.14 $ 0.12 $ - $ - $ 0.95 $ 0.85 $ 2.12 Feb-15 $ 1.64 $ 3.21 $ 0.14 $ 0.12 $ 0.01 $ 0.02 $ 0.93 $ 0.83 $ 1.94 Mar -15 $ 1.57 $ 3.03 $ 0.13 $ 0.10 $ 0.01 $ 0.02 $ 0.89 $ 0.79 $ 1.79 Apr -15 $ 1.54 $ 3.03 $ 0.13 $ 0.10 $ 0.01 $ 0.02 $ 0.86 $ 0.76 $ 1.79 May -15 $ 1.54 $ 3.03 $ 0.13 $ 0.10 $ 0.01 $ 0.02 $ 0.86 $ 0.76 $ 1.79 Jun -15 $ 1.53 $ 2.98 $ 0.14 $ 0.10 $ 0.01 $ 0.02 $ 0.84 $ 0.74 $ 1.73 Jul-15 $ 1.53 $ 2.98 $ 0.14 $ 0.10 $ 0.01 $ 0.02 $ 0.84 $ 0.74 $ 1.73 Aug -15 $ 1.57 $ 2.86 $ 0.15 $ 0.10 $ 0.01 $ 0.02 $ 0.87 $ 0.77 $ 1.60 Sep -15 $ 1.57 $ 2.86 _ $ 0.15 $ 0.10 $ 0.01 $ 0.02 $ 0.87 $ 0.77 $ 1.60 FY 14/15 Avg. $ 1.602 $ 3.133 $ 0.139 $ 0.108 $ 0.014 $ 0.019 $ 0.897 $ 0.797 $ 1.871 2014 Avg. $ 1.717 $ 3.528 $ 0.140 $ 0.105 $ 0.075 $ 0.058 $ 0.923 $ 0.831 $ 2.208 Oct -15 $ 1.59 $ 2.89 $ 0.16 $ 0.10 $ 0.01 $ 0.02 $ 0.88 $ 0.79 $ 1.62 Nov -15 $ 1.59 $ 2.89 $ 0.16 $ 0.10 $ 0.01 $ 0.02 $ 0.88 $ 0.79 $ 1.62 Dec-15 $ 1.59 $ 2.89 $ 0.16 $ 0.10 $ 0.01 $ 0.02 $ 0.88 $ 0.79 $ 1.62 Jan -16 $ 1.59 $ 2.89 $ 0.16 $ 0.10 $ 0.01 $ 0.01 $ 0.88 $ 0.79 $ 1.62 Feb-16 $ 1.54 $ 2.77 $ 0.14 $ 0.10 $ 0.01 $ 0.01 $ 0.85 $ 0.76 $ 1.52 Mar -16 $ 1.54 $ 2.77 $ 0.14 $ 0.10 $ 0.01 $ 0.01 $ 0.85 $ 0.76 $ 1.52 Apr -16 $ 1.41 $ 2.67 $ 0.16 $ 0.10 $ 0.01 $ 0.01 $ 0.70 $ 0.61 $ 1.40 Maw $ 1.38 $ 2.57 $ 0.19 $ 0.12 $ 0.01 $ 0.01 $ 0.62 $ 0.53 $ 1.25 Jun -16 $ 1.38 $ 2.57 $ 0.19 $ 0.12 $ 0.01 $ 0.01 $ 0.62 $ 0.53 $ 1.25 Jul-16 $ 1.38 $ 2.57 $ 0.19 $ 0.12 $ 0.01 $ 0.01 $ 0.62 $ 0.53 $ 1.25 Aug -16 $ 1.38 $ 2.57 $ 0.19 $ 0.12 $ 0.01 $ 0.01 $ 0.62 $ 0.53 $ 1.25 Sep-16 $ 1.38 $ 2.57 $ 0.19 $ 0.12 $ 0.01 $ 0.01 $ 0.62 $ 0.53 $ 1.25 FY 15/16 Avg. $ 1.479 $ 2.718 $ 0.169 $ 0.108 $ 0.010 $ 0.013 $ 0.752 $ 0.662 $ 1.431 2015 Avg. $ 1.576 $ 3.003 $ 0.144 $ 0.103 $ 0.009 $ 0.018 $ 0.879 $ 0.782 $ 1.746 CSW:12/20/2016 Attachment #6 Page 3 of 4 Competitive History of NG vs. Electric Rates Month -Year NG Therm Cost September 2001 $ 1.34 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 $ $ Increase over Last 15 Years $ % Increase over Last 15 Years Avg. Annual Inc. Over Last 15 Yrs. NG Equivalent KWH Cost $ 0.046 0.046 0.053 0.058 0.067 0.065 0.063 0.072 0.047 0.047 0.048 0.051 0.047 0.047 0.047 0.047 1.36 $ 1.56 $ 1.69 $ 1.97 $ 1.89 $ 1.86 $ 2.12 $ 1.39 $ 1.39 $ 1.42 $ 1.48 $ 1.67 $ 1.75 $ 1.57 $ 1.38 $ 0.04 $ 3.0% 0.2% 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.001 $ 2.8% 0.2% 0.039 46.4% 3.1% NG vs. Electric - 46% -37% -37% -35% - 31% -46% -47% -40% - 64% -65% -62% - 62% -62% -62% -62% -62% CSW:12/20/2016 1 Attachment #6 Page 4 of 4 Annual Average CGS Residential Rates Calender Year Fiscal Year Year NG/Therm LP /Gallon * Year NG/Therm LP /Gallon * $ 1.199 * 1995 NA NA FY 95/96 $ 0.880 1996 $ 0.915 $ 1.239 * FY 96/97 $ 1.019 $ 1.370 * 1997 $ 1.049 $ 1.380 * FY 97/98 $ 1.054 $ 1.318 * 1998 $ 1.032 $ 1.288 * 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 Average $ 1.497 $ 2.360 $ 1.485 $ 2.324 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 CaII Lan nter Gas System L ' a Greener Fuel Use and Cost Comparison (Effective Rates for June 2017) Want to make the switch to natural gas? Call Clearwater Gas System, today at (727) 562 -4980. APPLIANCE ANNUAL THERMS USED NATURAL GAS PROPANE (LP) GAS ELECTRIC COOKING 45 $ 76.50 $133.20 $171.00 WATER HEATING -Gas Tank Style/Gas Tankless vs. Electric Tank Style 170 / 100 $289.00 / $170.00* $503.20/$296.00* $646.00 HEATING 150 $255.00 1 $444.00 1 $570.00 CLOTHES DRYING 1 50 $ 85.00 1 $148.00 1 $190.00 TOTAL APPLIANCE USAGE — with tank/tankless $705.50/ $586.50* $1,228.40/ $1,021.20* $1,577.00 1 I I GAS SAVINGS VS. ELECTRICITY 55% / 63 %* 22 %/ 35 %* 1 ' when using tankless 1 *when using tankless- LP OUTDOOR RECREATION: POOL HEATING* 1 375 ( $637.50 1 $1,110.00 $1,425.00 SPA/HOT TUB HEAT* 1 175 1 $297.50 1 $ 518.00 1 $ 665.00 *varies according to pool size, weather conditions, and temperature maintained 1 1 1 1 All other figures are annual average projections based upon the following: 1. 1 therm = 100,000 BTUs of energy 2. Natural Gas ( $1.70 1' per therm per gallon or 1 3. LP Gas per gallon (BRLP3) 1 $2.71 ( $2.96 per therm 1 4. Duke Energy per KWH (Based on >1000 KWH rate) $0.12971 Per KWH or $3.80 per therm 1. Notes: The above analysis is based on June 2017 residential energy and fuel charges and does not include applicable taxes or franchise fees. 2. Current monthly customer charges are: Duke Energy $8.76, Peoples Gas $12.00- $20.00 (varies by rate class), Clearwater Gas System $12.00 and $20.00 in Central Pasco. L.P. customers are billed annually, $75 -$210 (non - refundable) depending on program. 711 Maple Street • Clearwater, FL 33755 • (727) 562 -4980 www.clearwateraas.com