Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
GAS ADJUSTMENTS EFFECTIVE JUNE 1, 2019
TO: FROM: COPIES: CLEARWA TER GAS SYSTEM Interoffice Correspondence Sheet William B. Horne II, City Manager Chuck Warrington, Managing Director Rosemarie Call, City Clerk; Micah Maxwell, Assistant City Manager CGS & UCS Management Teams; Janet Dorrough, Controller/CGS; Laura Damico, Sr. Systems Analyst/UCS; Lynne Priester, Cust. Serv. Coord./UCS; Kristina Simi, Cust. Serv. Coord./UCS RECEIVED JUti 03 2019 OFFICIAL RECORDS AND LEGISLATIVE SRVCS DEPT. SUBJECT: GAS ADJUSTMENTS EFFECTIVE JUNE 1, 2019 DATE: May 29, 2019 Natural Gas supply prices have remained fairly stable this winter; however, we have fallen behind on Natural Gas PGA collections and are recommending that we increase our Natural Gas Purchase Gas Adjustment (PGA) by 7¢ per therm for June. Propane (LP) supply prices have dropped this Spring; therefore, we are recommending that we decrease our LP PGA by 20¢ per gallon for June. We recommend that we continue our standard Contract LP PGA at 30¢ below our Standard LP PGA. We are not recommending any changes in our Energy Conservation Adjustment (ECA), our Regulatory Imposition Adjustment (RIA), nor our Usage & Inflation Adjustments (UTAs) for June. The net effect of these recommended changes for June is a 7¢ per therm increase (+4.4%) in our typical Residential Natural Gas customer's rate and a 20¢ per gallon decrease (-6.1%) 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 June 1, 2019: Natural Gas Firm Standard Rate Schedule PGA $0.89 per therm (up 7¢) 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 (UTA) - Residential - Commercial $0.79 per therm (up 7¢) $1.75 per gallon (down 20¢) $1.45 per gallon (down 20¢) $0.29 per therm or gallon (no change) $0.00 per therm or gallon (no change) $0.03 per therm or gallon (no change) $0.04 per therm or gallon (no change) William B. Horne II, City Manager June 29, 2019 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, Page #1, shows our monthly rate history over the past year and a quarter, and Pages #2 and #3 of this show our 17 -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.1% annually as compared to a 3.5% average annual increase for the Duke Energy (formerly Progress Energy Florida/FPC) residential rates. That's 1/3 the inflation in our energy costs on average for natural gas vs. electric --- a remarkable difference! And, 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 60% lower than electric for Natural Gas and 19% 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 a 30¢ per gasoline gallon equivalent (GGE) increase in our Natural Gas Vehicle (NGV) Fueling Station prices effective June 1" to $1.67/GGE --- 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 price will be $1.49/GGE, as these fleets pay no Federal taxes on fuel --- still a remarkable price. The reason for this increase is that Congress has not passed the Tax Extender package since 2017 and we have run out of these funds to reduce our rate. We are closely monitoring this and are hopeful that Congress will in the near future extend the 50¢/GGE Excise Tax Credit for NGV vehicle fuel for 2018 and beyond, which would allow us to reduce our pricing by this amount. There is a bill in the works now to hopefully accomplish this, but we are concerned that this may be delayed by Congress. 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 June 1" billings. If you have any questions on this, please call me. CSW/cw Attachments i Approved: U:\My Documents\MSOFFICE\WINWORD\GASRATES\Gas Adjustments for June 2019.docx A 1 B 1 NATURAL GAS PURCHASED GAS ADJUSTMENT (PGA-NGj 2 CLEARWATER GAS SYSTEM SUMMARY OF RATE ADJUSTMENT CLAUSE CO,LECTIONS FOR FY 2018/2 C D E F G 19 Attachment #1 Page 1 of 4 J 3 4 5 Budget Month Prior Year Reservation Charges Commodity Charges Monthly Cumulative NG PGA' Interest Cost Center Total NG Fuel Total NG PGA Expense Expenses Expenses Billed Overage (Shortage) 4,190,811.56 YTD Overage (Shortage) $ 88,009.36 Rate/Therm Firm/Contr 4,102,802.20) 0.82/0.72 6 Oct -18 7 Nov -18 5 4,222,656.82 $ 183,380.75 I 11.1.9.W...7%0 817,260.60 4. - $ 20,514.01 v. .............. $ 50,209.48 -, .--,- --•• - $ 1,071,364.84 •---•_ 1,381,124.95 $ 309,760.11 $ (3,793,042.09) 8 Dec -18 $ 197,819.20 1,199,887.67 $ 18,985.21 $ 26,333.19 $ 756,000.00 $ 1,442,805.27 1,663,437.07 $ 220,631.80 $ (3,572,410.29) $ (2,864,190.28) $ (2,202,967.86) 9 Jan -19 $ 199,631.40 874,473.64 $ 17,862.05 $ 86,637.05 1,501,911.40 $ 1,178,804.14 1,886,824.15 2,033,835.35 $ 708,220.01 $ 661,222.42 10 Feb $ 166,964.33 1,147,027.70 $ 14,320.95 $ 42,299.95 2 $ 1,372,612.93 -19 11 Mar -19 $ 186,153.80 1,200,474.72 $ 11,014.84 $ 26,573.58 2 2,4 $ 1,424,216.94 $ 1,630,844.69 1,652,532.66 1,685,863.02 $ 228,315.72 $ 55,018.33 $ (1,974,652.14) $ (1,919,633.81) 12 Apr -19 $ 792,494.04 780,368.02 $ 9,873.26 $ 48,109.37 $ (1,200,853.88) 5 13-077-291 13 May -19 $ 100,000.00 700,000.00 - --- _ $ 9,598.17 $ 50,000.00 n AAA nn Ultimate CNG (Feb.$99,982.50, Mar.$364,600, Apr.$125,800) _ $ 859,598.17 c aria ane 97 1,578,378.10 1 aoa 7Rn RR $ 718,779.93 R 7R7 77R A()(4 0.82/0.72 0.82/0.72 0.82/0.72 0.82/0.72 0.82/0.72 0.82/0.72 14 Jun -19 15 Jul a. 5 102,00u.uo $ 106,000.00 v u u,uv.vv 600,000.00 v %.,..,.-,..%.,..,.-,%.,..,.-,....,v, $ 2,065.39 • _--__ ,•.• $ 50,000.00 - - --,-- - $ 758,065.39 1,501,911.40 $ 743,846.02 $ 330,768.73 -19 16 Aug -19 $ 106,000.00 600,000.00 $ - $ 50,000.00 $ 756,000.00 1,501,911.40 $ 745,911.40 $ 1,076,680.13 17 Sep $ 102,000.00 600,000.00 - $ - $ 50,000.00 $ 2,291,345.99 4,5,7 $ 752,000.00 $ 2,291,345.99 1,501,911.40 $ 749,911.40 $ 1,826,591.53 $ (2,291,345.991 $ (464,754.46) -19 18 Per13 $ 110,218.15 $ 2,868,729.28 $ 19,825,803.42 19,273,039.60 $ (552,763.82) 19 Total YTD $ 6,467,100.34 $ 10,379,755.65 + Dividend 51,958,710 _$ 20 (1) Includes Annual Admin Charge of 5739,210 + UCS chg of 51,401,550 21 + FY 17/18 PGA write off of 510,224.53 + WNA $345.96 = $ 4,110,040.49 (51 Pension Adjustment = Ultimate CNG (Feb.$99,982.50, Mar.$364,600, Apr.$125,800) _ $ 590,382.50 (6) i‘ Accrual = r....,,..,...aadluefmanf from FVP trannfar of FCA Cnllantarl in PGA 0 Annual 22 (2) 3 De eciation = Additional Dividend = $ 1,699,850.85 $ 657,209.00 NG Pro • •rtion = 98.5% x Total ECA Transfer = 11111 11111 mi 29 Bud • et Gallons Month! = IIIII liEl MIll Ell MI Ell $ MN $ -1111 4V $ - = CO $ IIIII $V - COIII $ 51 ELI$ $ $ — 46 Cost Center Ex.enses IIIII Oil1 ‚111, , dim Etura:i4m(Rmf jim' $ 48 7/1: ante o' ' . F,b ; . E1tj� $ 0 49 _ Fuel $ MI ®- _ ® El 51 El NM Ell $ - 0 .13,iss.itivaL111111111 NM NEM QA ____ - Month WACOG Prior Year Oct -18 Nov -18 Dec -18 Jan -19 Feb -19 Mar -19 A•r-19 Ma -19 Jun -19 Jul -19 Au -19 Se • 19 32,756.6 30,194.8 31,716.1 55,703.5 37,817.1 39,094.7 42,245.7 28,000.0 28,000.0 1.19508 1.11103 1.00231 0.89309 0.97856 0.91590 0.86000 0.84000 1,091.76 971.73 833.00 574.14 377.91 191.51 39,148.10 33,547.33 32,966.98 55,832.18 33,774.07 38,256.51 38,692.84 24,080.00 23,520.00 Total YTD 28,000.0 28,000.0 28,000.0 409,528.5 0.86000 0.87000 0.88000 0.88514 4,040.04 24,080.00 24,360.00 24,640.00 30,404.91 362,491.10 170,870.00 864.79 Donations to events LP Yard Va • • rization/loss due to malfunctionin meter LP PGA Event fuel cost Suburban Software S stems De • reciation of LP tanks Suburban Software S stems license Additional Dividend LP Holding Tank Restoration 59 15,000.00 30,643.82 5,419.07 5,785.00 34,414.23 27,408.00 290 404.91 Total LP Fuel 329,551.01 34,639.09 33,938.72 56,665.17 34,348.21 38,634.42 38,884.34 24,080.00 23,520.00 24,080.00 24,360.00 24,640.00 34,893.59 722,234.55 $0.740 0.82/0.72 0.89/0.79 0.89/0.79 0.89/0.79 0.89/0.79 Av. Fuel Onl = Delta/Therm = Total LP PGA 63,927.64 58,644.13 61,685.68 108,437.10 73,594.37 75,914.25 82,190.97 54,475.27 48,888.06 48,888.06 48,888.06 48,888.06 774,421.64 Accrual = Overs e Shorta , e) $ (265,623.37J $ 24,005.04 $ 27,746.96 $ 51,771.93 $ 39,246.16 $ 37,279.83 $ 43,306.63 $ 30,395.27 $ 25,368.06 $ 24,808.06 $ 24,528.06 $ 24,248.06 $ 34 893.59 $ 52,187.09 CA Shortfall $ 2,291,345.99 $0.398 $0.341 umu a ve YTD Overa • e (Shorta, e) $ 47,271.90 $ (218,351.47) $ (194,346.43) $ (166,599.46 $ (114,827.54) $ 75,581.38 —LP- PGA Therm/Gal. $ (38,301.54) 5,005.08 35,400.35 60,768.41 85,576.47 110,104.52 134,352.58 99,458.99 2.13/1.95 2.13/1.95 2.13/1.95 2.13/1.95 2.13/1.95 2.13/1.95 2.13/1.95 2.13/1.95 1.91/1.75 1.91/1.75 1.91/1.75 1.91/1.75 Projected FYE Ad ustment from FYE transfer of ECA in PGA LP Pro • • rtion = 1.5% x Total ECA Transfer = Annual ECA Shortfall $ 34,893.59 Remaining 260,000.00 (30,404.91) CLEARWATER GAS SYSTEM SUMMARY OF RATE ADJUSTMENT CLAUSE, COLLECTIONS FOR FY 2018/291Q H A B C D E F G Attachment #1 Page 2 of 4 J K 60 ENERGY CONSERVATION ADJUSTMENT (ECA) 61 Monthly Cumulative ECA 62 63 Month 64 Prior Year Rfi rlrf-1 R Budget Cost Center Expenses Interest Total ECA Total ECA Overage YTD Overage NG/Therm Notes/Exceptional Items x.=nse NGV Station Expenses Billed (Shortage) (Shortage) $ (1,985,563.19) 1,550,921.49 268,926.84 1,281,994.65) $ 3,267,557.84) 66 Nov -18 $ 206,122.44 Promo$114,097,Adv $0, Employ Costs$94,023 $ 16,337.79 $ 51,831.97 274,292.20 286,165.83 $ 11,873.63 $ (3,255,684.21) 67 Dec -18 $ 356,682.15 Promo$77,537,Adv $189, Employ Costs$285,742 $ 16,278.42 $ 42,659.87 415,820.44 370,404.44 $ (45,416.00) $ (3,301,100.21) 68 Jan -19 $ 819,548.49 Promo$202,933,Adv $0, Employ Costs$116,615.49 $ 16,505.50 $ 37,620.29 7 873,674.28 445,970.20 $ (427,704.08) $ (3,728,804.29) 69 Feb -19 $ 157,082.56 Promo$77,750,Adv 5378, Employ Costs$78,955 18,644.02 $ 33,162.9 70 Mar -19 $ 357,379.24 Promo$270,855,Adv 5189, Employ Costs$86,335 $ 16,954.22 $ 39,295.63 413,629.09 439,334.27 $ 25,705.18 LP/Gal. 0.25/0.25 0.25/0.25 0.25/0.25 0.25/0.25 ,390,844.68) • 0.29/0.29 0.29/0.29 0.29/0.29___ 0.29/0.29 0.29/0.29 0.29/0.29 00 858.74 0.29/0.29 $ (3,365,139.50) 71 72 73 Apr -19 $ 310,191.55 Promo$166,772,Adv 50, Employ Costs$75,267 $ 16,825.70 $ 80,412.44 2,3 407,429.69 437,826.10 $ 30,396.41 $ (3,334,743.09) May -19 Jun -19 $ 300,000.00 $ 16,673.72 $ 50,000.00 366,673.72 406,597.36 $ 39,923.65 $ (3,294,819.44) $ 300,000.00 $ 16,474.10 $ 50,000.00 366,474.10 379,099.80 $ 12,625.70 $ (3,282,193.74) 74 Jul -19 $ 300,000.00 $ 16,410.97 $ 50,000.00 366,410.97 357,101.74 $ (9,309.23) $ (3,291,502.97) 75 76 Aug -19 77 Sep -19 P13 $ 300,000.00 $ 16,457.51 $ 50,000.00 366,457.51 357,101.74 $ (9,355.77) $ (3,300,858.74) $ 300,000.00 $ 16,504.29 $ 50,000.00 366,504.29 357,101.74 5-8 2,326,239.59 $ (9,402.55_ $ 2,326,239.59 $ (3,310,261.29) $ (984,021.70) 0.29/0.29 78 Total YTD $ 5,201,766.05 $ 193,994.06 $ 581,417.17 $ 5,977,177.28 $ 6,978,718.77 $ 1,001,541.49 79 80 81 (1) Incl. Annual Admin Charge of $46,630 + UCS chg of $74,470 + Dividend $203,120 + FY 17/18 Write off of $3,003.46 = (8) = Transfer of ECA Collected in PGA up to the ECA Collected for year (up to ECA Annual Shortfall) $ 327,223.46 Note: Maximum amount which can be transferred = $ 2,326,239.59 82 83 84 85 (1) (2) (3) 86 87 88 89 90 91 (4) (5) SNEP Transfer = j Additional Dividend = Countryside Roof Repair $30,730 & Universal Air $29,533.50 = Depreciation = $ 1,000,000.00 $ 68,153.00 $ 60,263.50 NGV O&M $?+PGA Recvy non -CGS $? = (6) (7) (8) OPEB Adjustment = Additional SNEP = Pension Adjustment = $ 500,000.00 Net ECA CCE $ 3,246,126.09 Net NGV CCE $ 581,417.17 92 93 REGULATQRY IMPOSITION ADJUSTMENT (RIA1 (EIA) (ORA) 94 95 Budget Month Environmental Expenses Notes/Exceptional Items Regulatory Expenses Interest Expense Total RIA Expenses Total RIA Billed Overage (Shortage) 96 Prior Year YTD Overage NG/Therm (Shortage) $ 1,071,297.62 1 175,523.98 43,022.96 $ (132,501.02) $ LP/Gal. 938,796.60 0.04/0.04 0.04/0.04 ___ 0.04/0.04 0.04/0.04 0.00/0.00 0.00/0.00__ __ 0.00/0.00 _ 0.00/0.00 0.00/0.00 _ 0.00/0.00 0.00/0.00 0.00/0.00 98 Nov -18 $ 1,235.00 8,016.23 $ - 9,251.23 45,781.33 $ 36,530.10 $ 975,326.70 99 Dec -18 $ 1,235.00 2,778.29 $ - 4,013.29 59,247.31 $ 55,234.02 $ 1,030,560.72 100 Jan -19 $ 1,235.00 1,491.71 $ - 2,726.71 71,342.75 $ 68,616.04 $ 1,099,176.76 101 Feb -19 $ 1,235.00 4,053.16 $ 102 103 104 Mar -19 Apr -19 $ 1,235.00 743.49 $ 1,978.49 23.52 $ (1,954.97) $ 1,092,276.30 May -19 $ 53,739.00 $ 1,235.00 744.54 2 54,483.54 (1.98) $ (54,485.52) $ 1,037,790.78 2,778.29 4,013.29 $ (4,013.29) $ 1,033,777.49 105 Jun -19 $ 1,235.00 2,778.29 4,013.29 $ (4,013.29) $ 1,029,764.20 106 Jul -19 $ 1,235.00 2,778.29 $ 4,013.29 $ (4,013.29) $ 1,025,750.91 107 108 Aug -19 Sep -19 $ 1,235.00 2,778.29 3 4,013.29 $ (4,013.29) $ 1,021,737.62 $ 1,235.00 2,778.29 4,013.29 $ (4,013.29) $ 1,017,724.33 109 P13 4,5 $ 1,017,724.33 110 Total YTD $ 239,207.47 $ 34,124.38 273,331.85 219,758.56 $ (53,573.29) 111 112 113 (1) Includes annual charges for Admin Charge $13,920 + FY 17/18 Write off of $1,483.47 + Dividend $156,480 = $ 171,883.47 (5) Accrual 114 (2) Additional Dividend $ 52,504.00 Net EIA = 14,820.00 115 116 117 (3) (4) Black & Veatch 1 Net ORA = $ 34,124.38 OPEB ($?) & Pension Adjustment ($?) = A B CLEARWATER GAS SYSTEM SUMMARY OF RATE ADJUSTMENT CLAUSE CO _LECTIONS FOR FY2018/211,Q c D E F G Attachment #1 Page 3 of 4 J K 118 USAGE AND INFLATION ADJUSTMENT (UTA) 119 Commercial Monthly Cumulative UTA 120 121 Budget Month LP Gallons Interest Expense Rate/Gallon NG Therms Rate/Therm Overage YTD Overage Shorts a Shorts e $ (424,074.96) 122 Beg. Bal. NG/Therm LP/Gal 0.03 831,469.4 0.03 $ 22,855.78 $ (401,219.18) 124 Nov -18 7,270.0 $ 2,006.10 0.03 864,803.4 0.03 $ 24,133.29 $ (377,085.89) 125 Dec -18 7,326.4 $ 1,885.43 0.03 1,062,187.4 0.03 $ 30,185.23 $ (346,900.66) 126 Jan -19 7,847.1 $ 1,734.50 0.03 1,226,931.3 0.03 $ 35,291.37 $ (311,609.29) 127 Feb -19 7,837.5 $ 1,558.05 .04 1 128 Mar -19 8,479.3 1,308.20 0.04 1,086,917.6 0.04 $ 42,465.62 $ 129 130 131 Apr -19 May -19 Jun -19 7,376.2 7,500.0 $ 1,095.88 $ 877.70 0.04 1,086,517.9 0.04 43,635.43 0.04 1,000,000.0 0.04 37,463.45 $ $ 7,500.0 $ 690.38 0.04 950,000.0 0.04 $ 35,747.98 $ 132 Jul -19 7,500.0 $ 511.64 0.04 850,000.0 0.04 $ 32,121.15 133 134 135 Aug -19 Sep -19 Per 13 7,500.0 $ 351.04 0.04 850,000.0 0.04 $ 32,281.75 7,500.0 189.63 0.04 850,000.0 0.04 $ 32,443.16 0.03/0.03 0.03/0.03 0.03/0.03 0.03/0.03 coi,o4u.au1 0.04/0.04 (219,175.18) 0.04/0.04 (175,539.75) 0.04/0.04 (138,076.30) 0.04/0.04 (102,328.32) 0.04/0.04 (70,207.17) 0.04/0.04 (37,925.42) 0.04/0.04 (5,482.25) 0.04/0.04 $ (5,482.25) 136 137 138 139 140 Total YTD 90,189.4 14,328.91 11,941,133.8 $ 418,592.71 (1) Recomputed UTA in January for February application. Increased b) in FY 17/18 of $25,775.50 = $424,074.96 net. 8,016,935.3 1 cents to 4 cents to recover $449,850.46 shortfall from FY 17/18 less overcollections (2) Accrual = $ 141 USAGE A ND INFLATION ADJUSTMENT (UTA) 142 Residentia Budget 143 144 145 146 147 148 149 150 151 Month Beg. Bal. Oct -18 Nov -18 Dec -18 Jan -19 Feb -19 Mar -19 Monthly Cumulative LP Gallons 26,655.8 22,911.3 24,387.0 47,851.0 29,974.2 30,610.0 Interest Expense $ 608.33 $ 550.39 $ 484.62 $ 383.71 $ 248.01 Rate/Gallon 0.05 $ 159.19 0.05 0.05 0.05 0.03 0.03 NG Therms 216,343.0 1 250,256.7 388,020.6 501,637.7 567,556.8 390,009.0 Rate/Therm 0.05 0.05 0.05 0.05 0.03 0.03 Overage (Shortage) $ 11,587.08 $ 13,154.02 $ 20,183.39 $ 27,140.19 YTD Overage (Shortage) $ (121,665.97) UTA NG/Therm LP/Gal (110,078.89) 0.05/0.05 (96,924.87) 0.05/0.05 (76,741.48) 0.05/0.05 (49,601.29) 0.05/0.05 $ 17,763.77 (31,837.52) ` 0.03/0.03 $ 12,485.76 152 153 154 Apr -19 34,866.8 $ 96.76 0.03 381,520.8 0.03 $ 12,412.84 May -19 Jun -19 20,000.0 $ 34.69 0.03 300,000.0 0.03 $ 9,369.89 20,000.0 $ 0.03 275,000.0 0.03 $ 8,669.85 (19,351.76) 0.03/0.03 (6,938.92) 0.03/0.03 2,430.97 0.03/0.03 11100.82 0.03/0.03 155 Jul -19 20,000.0 0.03 250,000.0 0.03 $ 7,935.12 $ 19,035.94 0.03/0.03 156 157 Aug -19 20,000.0 0.03 220,000.0 0.03 $ 7,053.44 $ 26,089.38 0.03/0.03 Sep -19 20,000.0 0.03 220,000.0 0.03 $ 7,053.44 158 Per 13 $ 33,142.82 $ 33,142.82 0.03/0.03 159 Total YTD 317,256.1 2,565.70 3,960,344.6 $ 154,808.79 160 161 162 (1) Recomputed UTA in January for February application. Decreased by 2 cent to 3 cents to recover ($153,053.21) shortfall from FY 17/18 less overcollections 163 in FY 17/18 of $31,387.24 = ($121,665.97) net. 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 CLEARWATER GAS SYSTEM SUMMARY OF RATE ADJUSTMgNT CLAUSE CO 4LECTIONS FOR FY 2018/2Q12 C D A 1 l TOTAL ALL COST RECOVERY ADJUSTMENT CLAUSES 1Both PGAs + ECA + RIA + UTA) B E F G Attachment #1 Page 4 of 4 J K Monthly Cumulative Total Rest 179 Budget 180 Month 181 Prior Year Total All Expenses Total Recovery Overage YTD Overage Billed (Shortage) (Shortage) NG/Thm (Firm) LP/Gal 5,836,487.74 $ (1,324,725.24) 7.161.212.98) ltfd UM -10 - .,---.-----_ $ 2,222,756.08 $ 2,261,926.38 $ 2,086,284.07 c n nal 1 OR CC $ 344,297.14 $ 130,284.12 $ 831,918.89 t ARA 47A an $ (4,524,343.83) $ (4,394,059.71) $ (3,562,140.82) t 17 AQri QRR Q7\ 183 Nov -18 189 1,389,547.36 $ 1,809,003.55 $ 419,456.19 $ (6,741,756.78) 184 Dec -18 1,254,365.17 . nnn n• 4 en 1,896,577.72 $ 2,205,143.12 $ 308,565.40 $ (6,433,191.38) 185 Jan -19 2,111,670.30 . en4 Ono on $ 2,575,005.76 c o 709 aa•2 7R $ 463,335.46 t 1 1A1 0 I d QR $ (5,969,855.93) t Id AAA Adm Q71 leo 187 rep -1u Mar -19 -'-- , - - 1,878,458.94 2,131,642.26 $ 2,222,756.08 $ 2,261,926.38 $ 2,086,284.07 c n nal 1 OR CC $ 344,297.14 $ 130,284.12 $ 831,918.89 t ARA 47A an $ (4,524,343.83) $ (4,394,059.71) $ (3,562,140.82) t 17 AQri QRR Q7\ 188 Apr -19 189 May -19 1,254,365.17 . nnn n• 4 en 190 191 192 193 194 195 196 197 Jun -19 Jul -19 1,152,569.65 Aug -19 Sep -19 Per 13 1,150,830.80 1,147,157.58 2,326,239.59 1,947,957.47 $ 795,387.82 $ (1,900,578.10) 1,947,236.40 $ 796,405.59 $ (1,104,172.51) 1,947,397.80 $ 800,240.22 $ (303,932.29) 2 326 239.59 $ $ (303,932.29) 116/2.29 1.16/2.29 1.16/2.29 1.16/2.29 1.14/2.27 1.14/2.27 1.14/2.27 j 1.14/2.27 1.21/2.07 1.21/2.07 1.21/2.07 1.21/2.07 Total YTD 26,798,547.11 27,819,340.06 $ 1,020,792.95 198 Last Updated 5/29/2019 as of 52912019 9 9 FTS -1 FTS -1 FTS -2 90.6518 Volume Cost No -Notice $0.0478 Volume Cost Capacity Relinquishment Volume Rate Cost Reservat1on Aivatrnenh TOTAL RESERVATION COST Total Rate Prior Month COMMODITY 41,788 63,430 66,211 55,211 49,988 55,211 63,430 41,788 40,440 41,788 41,788 40,440 FTS-1(Uaags) Volume FTS -2 (Usage) Rale Cost Gas Supply (FGU & Mbrconnecb) Volans Rate Coat Fuel % FGU Management fee 80.063- No Notice Usage G7I Payment 80.020 Ca.han Adjustment 21,262.19 COST $ 712250.00 Volume 147,187 151,717 194,739 220,082 180,132 166,389 154,870 180,212 142,560 140,212 140,212 Rate Cost $ 0.0439 S 6.460.63 S 0.0439 1 6,660.35 $ 0.0439 $ 5,549.05 8 0.0439 1 9,690.72 8 0.0439 8 7,029.79 8 0.0439 8 6,138.67 $ 0.0415 8 6,427.08 $ 0.0439 $ 7,033.31 $ 0.0439 $ 6,258.38 $ 0.0439 $ 6,155.31 5 0.0439 8 6,155.31 41,788 58,995 55,199 55,188 49,958 55,211 53,430 41,788 40,440 41,768 41,788 40,440 $ 0.0439 $ 1234.49 $ 0.0439 8 2,58928 $ 0.0439 $ 2,423.24 8 02439 8 2,422.67 $ 0.0439 8 2,18921 1 0.6439 $ 2,423.78 $ 0.0415 $ 2,211.36 $ 0.0439 $ 1,834.49 $ 0.0439 $ 1,775.32 $ 0.0439 $ 1,834.49 $ 0.0439 8 1,834.49 8 0.0439 8 1,775.32 192224 216,927 251,876 289,221 217,011 248,693 189,919 209,231 189,000 187,500 187,500 185.000 1 3.4426 $ 663,130.92 8 3.8521 1 835,633.96 $ 4.2007 8 1,055,056.72 $ 3.4967 $ 1,006,438.32 $ 3.1915 $ 592284.83 8 3.2281 8 802,472.88 8 3.4794 S 860,805.52 $ 3.1293 $ 654,745.18 $ 3,1108 S 567,944.50 $ 3.0673 $ 575,117.15 8 3.0504 8 571,955.15 8 2.9360 8 551,969.50 2.41% 2.41% 2.41% 2.41% 2.41% 2.41% 2.78% 3.50% 3.50% 3.50% 3.50% 3.50% $ 11,794.00 $ 12,702.00 $ 14,516.00 $ 16,331.00 8 13,306.00 $ 15,121.00 $ 12,702.00 S 12,625.00 $ 11,437.50 $ 11,375.00 5 11,375.00 9 11,375.00 $ $ • 8 _ 8 8 - 8 • 5 - S • S - S - 8 - 9 - $ 3,779.10 $ 4,21424 $ 4,998.76 8 5,804.96 8 4,200.00 8 4,812.00 S 4,166.00 $ 4,040.00 $ 3,860.00 $ 3,640.00 5 3,640.00 S 3,840.00 $ 3,988.67 $ 14,60121 $ 4,063.74 8 (21,245.25) $ 8279.98 $ 1,698.15 8 5,283.47 8 - $ - $ - 9 - S - $ $ 842.54 $ 297.72 8 707.73 8 (1,096.15) $ 19,104.49 $ 1,611.35 S - $ - S • $ - S - $ 877,244.19 $ 1,093,20523 8 1,021,820.14 $ 728,793.64 8 853,770.85 $ 693,192.77 $ 680,277.98 $ 611,075.70 $ 598,121.95 $ 594,959.95 $ 574 974.30 141.560 1.938.832 $ 0.0439 8 6,214.48 - $ 84,742.99 575,921 2 587,403 - $ 8,882,854.83 8154,859.50 50.00 550,295.08 518,949.94 $43,029.87 $9,037,886.70 - $ 25,154.71 _ Oe619 Nov -18 Dec -18 Jan•19 Feb -19 Mar -19 APr-19 May -19 Jun -19 Jul•19 Aug -19 Sep -19 R E Oc618 Nov -18 E Dec -18 Jan -19 Feb -19 ✓ Mar -19 A Apr -1 May -1 T Jun -1 Jul -1 Aug -1 O Sept N T CGS Rotund Gas Summary Monthly Actua9Pto(eCtlons (FY19) A-f'fk(h Muer ah 2 - 10.5618 8 9 B 9 9 FTS -1 FTS -1 FTS -2 90.6518 Volume Cost No -Notice $0.0478 Volume Cost Capacity Relinquishment Volume Rate Cost Reservat1on Aivatrnenh TOTAL RESERVATION COST Total Rate Volume 170,438 306,570 316.789 316,789 286,132 318,789 216,570 144,212 139,560 144,212 144,212 Cost $ 94047.69 1 169,165.33 8 174204.17 1 174,804.17 1 152,186.00 8 168,468.39 $ 115,171.93 8 79,576.18 $ 77,009.21 $ 79,576.18 $ 79,578.18 41,788 63,430 66,211 55,211 49,988 55,211 63,430 41,788 40,440 41,788 41,788 40,440 $ 27,237.42 $ 34825.67 $ 35,986.53 $ 35,986.53 $ 31,506,60 $ 34,682.31 $ 33,757.07 $ 27,237.42 $ 26,358.79 8 27,237.42 8 27,237.42 8 28,358.79 15,600 22,600 .31,000 46,500 42,000 31,000 22,600 12,400 10,500 10,850 10,850 10,500 8 740.90 $ 1,075.50 $ 1,481.80 8 2,222.70 1 2,007.60 $ 1,48120 1 1,07620 $ 592.72 $ 501.90 $ 518.63 $ ' 518.83 $ 501.90 (21,919) (95,534) (40,813) (65,914) (110,516) (131,372) (6120 (40,000) (10,000) (10,000) (10,000) (10,000) $ 0.4321 4 0.2293 $ 0.3597 $ 02408 $ 0.1632 8 0.1425 8 0.2402 $ 0.2000 $ 0.2000 $ 0.2000 $ 0.2000 $ 0.2000 $ (9,470.82) $ (21,903.80) $ (14,607.80) $ (13.456.16) $ (16,925.50) $ (18,736.18) $ (14,817.37) $ (8,000.00) $ (2,000.00) $ (2,000.00) $ (2,000.00) $ (2,000.00) 861.14 8218.06 1154.50 184.16 1210.73 867.48 897.91 80.00 50.00 80.00 80.00 80.00 8 112,616.33 $ 183,380.75 1 197,819.20 $ 199,831.40 $ 186,964.33 5 185,153.80 1 135,285.04 $ 99,406.32 $ 101,869.90 8 105,932.23 $ 105,332.23 3 101,869.90 80.6472 80.6390 10.5469 80.6606 80.6317 80.6863 10.5861 80.6276 80.5644 80.5637 80.5637 50.5644 139.580 2,641,833 $ 77,009.21 $ 1,441,373.84 570,393 $ 388,811.97 288,100 $ 12,719.58 N na711 (597,564) (8125,927.73) 8883.97 51,897,081.43 80.5893 C O Oct -18 Nov -18 • Dec•18 M Jan -19 Feb -19 O Mar -19 D Apr -19 ( May -19 Jun -19 • Jul -19 Aug -1 Y sept T TOTAL COST Resin & Comm RATE $ 82426633 1 428 1 1,080224.94 8 4.89 $ 1,291,024.43 8 613 $ 1,221,451.54 $ 422 $ 895,757.97 $ 4.13 $ 1,039.924.65 8 4.18 $ 826,477.61 $ 4.36 $ 779,684.90 $ 3.73 8 712,945.80 $ 3.77 $ 703,454.18 8 3.75 5 700,292.18 $ 3.73 $ 878,844.20 $ 3.60 $ 10,736,348.13 8 4.18 Total Projected DIN WACOG Told Resonation Total Commodity Cost Purchased tate Months $ 1,048,585.81 8 5,285,084.05 $ 8,333,849.86 1,418,253 $4.472 2nd 8 Months $ 649,095.82 $ 3,752,602.85 $ 4,401,89827 1,151,150 93.824 TOTAL $ 1,897,881.43 1 9,037,688.70 S 10,735,348.13 2,587,403 84.181 /471-AcMA1 ¢,4ffa� Propane Weighted Average Cost of Gas (WACOG) FY 2018-19 5/29/2019 Date Invoice Company Targa L&L Shipping Gallons Delivered Propane Rate Propane Coat Shipping Cost Total Cost FYTD Gallons Cost of Inventory Tank Inventory Tank Wlthdrawl WACOG 09/30/16 10/26/18 ".., `,. Targa 18052211 8,888776� _ 1.12145` . $ 9,453.54 _. $ 513.92 $ 9,967.46 8,888.0 S 48,602.94 40,044 -�1.218L -� 21 40,0 $ 58,770.40 48.931 1.20109 10129/18 Ta ,a 18052351 _ 8,881 132 1.13645 $ 9,579.32 $ 513.51 $ 10,092.83 17,769.0 $ 68,863.23 57.812 - 1.19116 MONTHLY INVENTORY ADJUSTMENT 2.90311 $ 383.21 3 383.21 17,901.0 $ 69,246.44 57,944 1.11�9T570�67 END OF MONTH 18053775- 17.708 1.10782 S 18,585.26 ....... $ 1,032.03 - $ 19.617.29 40,641.0 _., . . �®' �i:+u 11101118 Targa $ 47.023.55 40.641 1.15705 11/05/18 Targa 18054184 8,974 1.10691 $ 9,410.36 $ 523.01 $ 9,933.37 49,615.0 $ 56,956.92 49,615 1.14798 11/19/18 Ta 'a 18056558 17,956 1.04307 $ 17,682.93 S 1,046.48 S 18729.41 67.571.0 $ 75,686.33 87,571 1.12010 11/30/18 MONTHLY INVENTORY ADJUSTMENT END OF MONTH 574 8.805 0.04286 1.03500 $ 24.60 $ 7,545.01 $ 1,568.17 $ 24.60 $ 9,113.18 68,145.0 41,841.0 $ 75.710.93 $ 36,703.89 68,145 33,036 35,109 1.11103 1.11103 1.09503 12/14/18 Targa 18061078 $ 45,817,07 41,841 12/17/18 Targa 18061253 8.902 1.02500 $ 7,539.11 S 1,585.44 $ 9.124.55 50,743.0 $ 54.941.62 50,743 1.08274 12/18/18 Targa 18061643 9,200 1.02500 $ 7,791.48 S 1,638.52 $ 9,430.00 59,943.0 S 64,371.62 59,943 1.07388 12/19/18 Targa 18061825 8805 1.00500 S 7,280.86 9 1,568.17 $ 8,849.03 68748.0 $ 73,220.65 68,748 1.06506 12/27/18 Targa 16062745 9,111 0.92418 $ 7,891.27 $ 528.90 $ 8,420.17 77,859.0 $ 81,640.82 77.859 1.04857 12/28/18 T •a 19000533 8,930 453 8,975 0.91855 $ 7,684.27 $ 518.40 $ 8,202.67 86.789.0 $ 89,843.49 86.789 1.03519 01/11/19 MONTHLY END OF MONTH Targa INVENTORY ADJUSTMENT 19003094 1.85269 0.95701 $ 839.27 $ 8,076.39 $ 512.77 $ 839.27 $ 8,589.16 87.242.0 56,192.0 $ 90.682.76 $ 57,668.36 87,242 47,217 40,025 1.03944 1.03944 1.02627 56,192 01/14/19 Targa 19003760 9,031 0.97138 $ 8,256.59 $ 515.97 3 8,772.56 65,223.0 S 66,440.92 65.223 1.01867 01/26/19 Targe 19005779 8.497 0.94138 S 7,513.48 $ 485.46 $ 7,998.94 73,720.0 $ 74,439.86 73,720 1.00976 01/30/19 Targa 19006283 9,288 0.95951 $ 8,381.26 $ 530.66 $ 8,911.92 83,008.0 $ 83,351.78 83,008 1.00414 01/31/19 Ta .a 19007156 9.370 333 8,908 0.96763 $ 8,531.39 $ 535.34 $ 8066.73 92,378.0 $ 92,418.51 92,378 1.00044 02/04/19 MONTHLY END OF MONTH Terga INVENTORY ADJUSTMENT 19007325 1.52108 0.96070 8 506.52 $ 8,053.25 $ 502.70 $ 506.52 $ 8,555.95 92,711.0 47,422.0 $ 92,925.03 $ 47,160.87 92,711 SIN 1.00231 Yl 0.99449 47,422 02/05/19 arga 19008322 9,035 0.94132 $ 7,994.86 $ 509.98 $ 8,504.84 56,457.0 S 55,665.71. 56.457 0.98598 02/22/19 Targa 19011388 9.070 1.00069 S 8,564.35 $ 511.95 $ 9,076.30 65,527.0 $ 64,742.01 65,527 0.98802 02/25/19 Ta ,a 19011580 18.013 379 8,835 0.98129 $ 16,659.25 $ 1,016.73 $ 17,675.96 83,540.0 S 62,417.99 83,540 0.98657 MONTHLY INVENTORY ADJUSTMENT END OF MONTH 1.91892 0.96882 S 727.27 1 6,060.84 S 498.69 $ 727.27 S 8,559.53 83,919.0 57,462.0 S 83,145.26 $ 56,738.18 83819 48,627 57,462 35,292 0.99078 0.99078 03/11/19 Terga 19014425 0.98740 03/12/19 Terga 19014842 8,899 0.96382 S 8,074.74 $ 502.31 $ 8.57705 66.361.0 S 65,315.23 68,361 0.98424 03/25/19 Ta • 19016289 18,218 684 8,833 0.91312 $ 15,606.95 S 1,028.31 $ 16,635.26 84,579.0 $ 81,950.49 84.579 0.96892 Era=MONTHLY 03/31/19 END OF MONTH 10' INVENTORY ADJUSTMENT -® 2.17026 0.82178 $ 1,484.46 $ 6,756.15 $ 502.63 $ 1,484.46 S 7,258.78 65,283.0 51,672.0 Sr 83,434.95 $ 49,179.31 85,263 0.97856 0.97856 0.95176 51,672 =MEET= 19019430 8,860 0.84553 S 6,987.26 S 504.17 S 7,491.43 60,532.0 $ 56.670.74 60,532 0.93621 =MIMIOnl. 19020568 8,785 0.84490 S 6,922.59 $ 499.89 $ 7,422.48 69,317.0 S 64,093.22 69,317 0.92464 19020698 8,855 917 8.181 0.82428 $ 6,795.12 S 503.89 S 7,299.01 78,172.0 8 71,39223 78,172 0.91327 =3EINIIETIMIMIIEMS MONTHLY END OF MONTHIIME12111111:3E3 INVENTORY ADJUSTMENT 1.14032 0.77201 S 1,045.87 $ 5,848.39 S 467.41 S 1,045.67 S 8,315.80 79,089.0 43,494.0 $ 72.437.90 79,089 0.91590 0.88884 $ 38,659.10 43,494 [2:521111.10M 222' 19021902 8,685 0.78386 8 6,138.13 $ 496.20 S 8,634.33 52,179.0 $ 45,293.43 52.179 0.86804 8,525 0.74263 $ 5,843.90 3 487.06 $ 6,330.96 60,704.0 $ 51.624.39 80,704 0.85043 M. FYTD Totals 303,938 0.96139 $ 270,653.97 $ 21,648.67 $ 292,202.64 Delivered Month CGS Cost Apr -19 May -19 $ Jun -19 $ Jul -19 $ Aug -19 $ Sep -19 $ Oct -19 $ Nov -19 $ Dec -19 $ 0.80 0.80 0.90 0.90 0.90 0.90 0.90 0.90 Delivered Gallons 36,000 18,000 18,000 18,000 27,000 27,000 36,000 45,000 Delivered Cost $ 28,800.00 $ 14,400.00 $ 16,200.00 $ 16,200.00 $ 24,300.00 $ 24,300.00 $ 32,400.00 $ 40,500.00 Projections Cost of Inventory $ 61,143.00 $ 44,676.99 $ 45,792.75 $ 46,531.80 $ 55,121.33 $ 55,537.46 $ 63,873.27 $ 72,128.97 Total Gallons 71,313 53,313 53,313 53,313 62,313 62,313 71,313 80,313 EOM Tank EOM Tank Projected Gallons Cost WACOG 35,313 $ 32,343.00 0.92 35,313 $ 30,276.99 0.86 35,313 $ 29,592.75 0.84 35,313 $ 30,331.80 0.86 35,313 $ 30,821.33 0.87 35,313 $ 31,237.46 0.88 35,313 $ 31,473.27 0.89 35,313 $ 31,628.97 0.90 35,313 $ 31,714.55 0.90 CSW: 05/29/2019 CLEARWATER GAS SYSTEM NATURAL GAS RATE BILLING FACTORS FOR JUNE 1, 2019 - SEPTEMBER 30, 2019 BASED ON APPROVED GAS ADJUSTMENT FACTORS Attachment #4 Intern. Contract Finn Natural Gas Rate Schedules NG Rate NG _RD_ SMF MMF LMF SGS MOS LGSRSC GAC _LAC AL_ SL w/M& NGV NSS 1_ CN Relight (Non -Rest) (Non -Res!) 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 312.00 325.00 340.00 395.00 $25.00 $40.00 $95.00 $12.00 $25.00 $40.00 $20.00 $20.00 By Contract 350.00 $250.00 By Contract (For Central Pasco Territory) (320.00) (340.00) ($70.00) ($160.00) (340.00) (370.00) (3160.00) ($20.00) (340.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 Enemy Charm/Therm billed billed billed Non -Fuel Energy Charge 30.44 30.44 30.44 30.44 30.42 $0.38 30.34 30.20 30.15 30.10 30.20 30.35 By Contract 30.42 $0.24 By Contract Energy Conservation Adj. (ECA) 0.29 0.29 0.29 0.29 0.29 0.29 0.29 NA NA NA NA NA NA NA NA NA Regulatory Imposition Adj. (RIA) 0.00 0.00 0.00 0.00 0.00 0.00 0.00 NA NA NA NA NA NA NA NA NA Usage & Inflation Adj. (UTA) 9.2$ QQ Q4 12,0 QQ4 QQ4 10 ISA NA N9 NA NA m M NA 1,16 Total Non -Fuel Energy Charge $0.76 $0.76 $0.76 $0.76 30.75 30.71 30.67 30.20 $0.15 30.10 $0.20 $0.35 By Contract 30.42 30.24 By Contract Purchased Gas Adjustment (PGA) Q,$2 QM 9,$2 Qe9 Q.9 212 Q•2 Mt Q•9 QA2 Q$9 Q.$$ 0.79 QM 0 79 0.79 Total Energy Charge/Thenn 1.65 1.65 1.65 1.65 1.64 1.60 1.56 1.09 1.04 0.99 1.09 1.24 0.79 1.31 1.03 0.79 + Non -Fuel + Non -Fuel Minimum Monthly Bill 312.00 $25.00 340.00 395.00 325.00 340.00 395.00 312.00 325.00 340.00 320.00 $20.00 By Contract 350.00 $250.00 Customer (For Central Pasco Territory) (320.00) (340.00) ($70.00) ($160.00) (340.00) ($70.00) ($160.00) (320.00) ($40.00) ($70.00) (330.00) ($30.00) (By Contract) ($75.00) 3400.00 Charge + © premise (11 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.51 $ 1.51 $ 1.51 $ 1.51 $ 1.50 $ 1.46 $ 1.43 $ 1.00 $ 0.95 $ 0.91 $ 1.00 $ 1.13 $ 0.72 $ 1.20 $ 0.94 with 6.0% Franchise $ 1.60 $ 1.60 $ 1.60 $ 1.60 $ 1.59 $ 1.55 $ 1.51 $ 1.06 $ 1.01 $ 0.96 $ 1.08 $ 1.20 $ 0.77 $ 1.27 $ 1.00 Change from 9/2014 Therm Rate $ (0.10) $ (0.10) $ (0.10) $ (0.10) $ (0.07) $ (0.05) $ (0.03) $ (0.05) $ (0.05) $ (0.05) $ (0.05) $ (0.05) $ (0.06) $ (0.09) $ (0.10) $ (0.06) % Change from 9/2014 Therm Rate -4.4% -4.4% -4.4% -4.4% -3.3% -2.4% -1.5% -2.7% -2.7% -2.8% -2.7% -2.5% -3.4% -4.2% -5.7% -4.1% Utility Tax Note: Fuel Rate per Therm 10/01/1973 30.069 $0.069 30.069 30.069 30.069 30.069 30.069 30.069 30.069 30.069 30.069 30.069 30.069 30.069 $0.055 $0.069 Non -Utility Taxable Fuel/Therm 30.821 30.821 $0.821 $0.821 30.821 $0.821 30.821 $0.821 $0.821 $0.821 $0.821 $0.821 30.721 $0.821 $0.735 $0.721 BTU FACTOR = THERMS/100 CUBIC FEET (CCF) 10/2018 11/2018 12/2018 01/2019 02/2019 03/2019 04/2019 05/2019 96/2019 07/2019 08/2019 09/2019 Firm Service Rates 1.044 1.044 1.046 1.047 1.044 1.044 1.043 1.042 1.043 Interruptible Service Rates 1.023 1.024 1.025 1.026 1.023 1.024 1.023 1.021 1.022 FY 17/18 Ava. 1.044 1.023 CSW:05/29/2019 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 Charaes/Gallon: Non -Fuel Energy Charge (NFE)/Gailor $1.90 Energy Conservation Adj.(ECA)/Gailor 0.29 Regulatory Imposition Adj.(RIA)/Gallon 0.00 Usage & Inflation Adj. (UTA)/Gallon Q CLEARWATER GAS SYSTEM METERED PROPANE (LP) RATE BILLING FACTORS FOR JUNE 1, 2019 - SEPTEMBER 30, 2019 BASED ON APPROVED GAS ADJUSTMENT FACTORS RESIDENTIAL MULTI -FAMILY LOOP RESL. SMALL COML. LARGE COML. VEHICLE MRLP MMLP LRLP MGLP MLLP LPV (Non -Rest. Only) NA NA NA 0 - 2,500 >2,501 NA (1 - 3 Units) (4 + Units) $12.00 $25.00 $12.00 $25.00 $40.00 $40.00 For Each Meter Total Non -Fuel Charges (NF)/Gal. $2.22 Purchased Gas Adjustment(PGA)/Gal. 1.75 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 $1.90 $0.90 $0.30 $0.25 0.29 0.29 0.29 0.29 0.00 0.00 0.00 0.00 QQ2 0.03 0_,Q4 Q2 $2.22 $1.22 $0.63 $0.58 1_.75 1.75 1.75 1.75 $3.97 $3.97 $2.97 $2.38 $2.33 $12.00 $25.00 $12.00 $25.00 $40.00 0.161 $1.589 ($0.20) -4.8% 0.161 $1.589 ($0.20) -4.8% 0.161 $1.589 ($0.20) -6.3% 0.161 $1.589 ($0.17) -6.7% 0.161 $1.589 ($0.17) -6.8% Attachment #5 Page 1 of 2 STANDBY/GENERATOR CONTRACT MTRD LPSM CLP (Non -Rest. Only) NA NA (Closed for New Res!. Applications) $50.00 Set By Contract Set By Contract $1.00 NA NA NA NA NA Set By Contract $1.00 Set By Contract 1 $2.75 $50.00 Contract NFE + Contract PGA Customer Charge Any Applicable Customer Charge + Any Applicable Facility Charges 0.161 0.161 Contract PGA - 0.161 $1.589 NA ($0.19) NA -6.5% Set By Contract NA NA NA Set By Contract 1.45 Contract NFE + $1.450 Customer Charge + Non -Fuel Energy Chg. for the Contracted # of Gallons/Mo. 0.161 Contract PGA - 0.161 NA NA CSW:05/29/2019 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. 2019 - SEPTEMBER 30, 2019 BASED ON APPROVED GAS ADJUSTMENT FACTORS Attachment #5 Page 2 of 2 STANDARD RESIDENTIAL. BULK LP SERVICE RESIDENTIAL "WILL CALL" COMMERCIAL BULK LP SERVICE SULK STANDBY/ CONTRACT BULK (Rate Class Is Based on Annual LP Gallon Usage Level) (Based on Annual Usage Level) (Based on Annual Usage Level) GENERATOR )_P SERVICE AMU )I, Mel LEVI j;a4 WRLPO WRLP1 WRLP2 _MEL Jogal BCLP2 PSBIIP (Closed for 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 - 80 60.1 • 120 120.1 - 300 > 300 0.2,500 > 2,500 New Residental Any Contract 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 Customers in this Customers in this Applications) Customers Who Range of Usage Range of Usage Requests Bulk Del. Annual Customer Charge $ 350.00 S 225.00 $ 180.00 $ 90.00 $ 75.00 $ 350.00 $ 210.00 $ 150.00 $ 75.00 $ 60.00 $ 90.00 $ 90.00 $ 420.00 Set by contract Non -Fuel Chartres (NFYGallon; Non -Fuel Energy Charge (NFE)/Gel. $ 1.80 $ 1.80 $ 1.60 $ 1.00 $ 0.90 $ 1.80 $ 1.80 $ 1.60 $ 0.90 $ 0.80 $ 0.25 $ 0.20 $ 1.00 Set By Contract Energy Conservation Adj. (ECAyGaI $ 0.29 $ 0.29 $ 0.29 0.29 0.29 0.29 0.29 0.29 0.29 0.29 0.29 0.29 NA NA Regulatory Imposition Adj. (RIA)Gal $ • $ $ NA NA Usage & Inflation Adj. (UTA)/Gallon 0.03 0.03 0.03 0.03 0.03 0.03 0.03 0.03 0.03 0.03 0.04 0.04 NA N.9 Total Non -Fuel Charges (NF)Gal. $ 2.12 $ 2.12 $ 1.92 $ 1.32 8 1.22 $ 2.12 $ 2.12 $ 1.92 8 1.22 81.12 $ 0.58 $ 0.53 $ 1.00 Set By Contract Purchased Gas Adj. (PGA)/Gallon $ 1.75 $ 1.75 $ 1.75 $ 1.75 $ 1.75 $ 1.75 $ 1.75 $ 1.75 $ 1.75 $ 1.75 $ 1.75 $ 1.75 $ 1.75 1.4 Total Energy Charges/Gallon $ 3.87 $ 3.87 $ 3.67 8 3.07 $ 2.97 $ 3.87 $ 3.87 $ 3.67 $ 2.97 8 2.87 8 2.33 $ 2.28 $ 2.75 Cotract NFE 4. 1.450 Note: No Monthly Minimum Bill Utility Tax Note: Fuel Rate per Gallon 10/01/1973 S 0.161 S 0.161 $ 0.161 $ 0.161 $ 0.161 $ 0.161 $ 0.161 S 0.161 $ 0,161 $ 0.161 $ 0.161 $ 0.161 $ 0.161 $ 0.161 Non -Utility Taxable Fuel/Gallon $ 1.589 $ 1.589 $ 1.589 $ 1.589 $ 1.589 $ 1.589 $ 1.589 $ 1.589 $ 1,589 $ 1.589 $ 1.589 $ 1.589 $ 1.589 Contract PGA - 0.161 Change from 9/2014 Gallon Rate $ (0.200) $ (0.200) $ (0.200) $ (0.20) $ (0.20) $ - $ - S (0.20) $ (0.20) $ (0.30) 8 (0.17) $ (0.17) $ (0.19) NA % Change from 9/2014 Gallon Rate -4.9% -4.9% -5.2% -6.1% -6.3% 0.0% 0.0% -5.2% -8.3% -9.5% 4.8% -8.9% -6.5% NA 'CSW.05rzsno1e Attachment #61 I I Page 1 of 3 Residential Rate History By Components Clearwater Gas System 1 Tota Rate Ad justments/Therm Contract LP Month NG/therm LP/gallon' ECA RIA# WNAIUTA-Resl#rUTA-Coml# PGA PGA PGA/aallon 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 $ 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 $ 025 $ 0.09 $ 0.05 $ 0.03 $ 0.86 $ 0.76 $ 1.99 Feb -18 $ 1.69 $ 3.38 $ 025 $ 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 $ 1.60 $ 3.29 $ 0.25 $ 0.04 $ 0.05 $ 0.03 $ 0.82 $ 0.72 $ 1.95 Jul -18 $ 1.60 $ 3.29 $ 0.25 $ 0.04 $ 0.05 $ 0.03 $ 0.82 $ 0.72 $ 1.95 Aug -18 $ 1.60 $ 3.29 $ 0.25 $ 0.04 $ 0.05 $ 0.03 $ 0.82 $ 0.72 $ 1.95 Sep -18 $ 1.60 $ 3.29 $ 0.25 $ 0.04 $ 0.05 $ 0.03 $ 0.82 $ 0.72 $ 1.95 FYTD 17118 Avg. $ 1.648 $ 3.325 $ 0.238 ' $ 0.069 $ 0.045 $ 0.035 $ 0.856 $ 0.756 $ 1.973 2017 Avg. $ 1.607 ' $ 2.936 $ 0.184 $ 0.107 $ 0.030 $ 0.048 $ 0.846 $ 0.753 $ 1.615 Oct -18 $ 1.60 $ 3.29 $ 0.25 $ 0.04 $ 0.05 $ 0.03 $ 0.82 $ 0.72 $ 1.95 Nov -18 $ 1.60 $ 3.29 $ 0.25 $ 0.04 $ 0.05 $ 0.03 $ 0.82 $ 0.72 $ 1.95 Dec -18 $ 1.60 $ 3.29 $ 0.25 $ 0.04 $ 0.05 $ 0.03 $ 0.82 $ 0.72 $ 1.95 Jan -19 $ 1.60 $ 3.29 $ 025 $ 0.04 $ 0.05 $ 0.03 $ 0.82 $ 0.72 $ 1.95 Feb -19 $ 1.58 $ 3.27 $ 0.29 $ - $ 0.03 $ 0.04 $ 0.82 $ 0.72 $ 1.95 Mar -19 $ 1.58 $ 3.27 $ 0.29 $ - $ 0.03 $ 0.04 $ 0.82 $ 0.72 $ 1.95 Apr -19 $ 1.58 $ 3.27 $ 0.29 $ - $ 0.03 $ 0.04 $ 0.82 $ 0.72 $ 1.95 May -19 $ 1.58 $ 3.27 $ 0.29 $ - $ 0.03 $ 0.04 $ 0.82 $ 0.72 $ 1.95 Jun -19 $ 1.65 $ 3.07 $ 0.29 $ - $ 0.03 $ 0.04 $ 0.89 $ 0.79 $ 1.75 Jul -19 Aug -19 , Sep -19 FYTD 18/19 Avg. $ 1.597 $ 3.257 $ 0.272 $ 0.018 $ 0.039 $ 0.036 $ 0.828 $ 0.728 $ 1.928 2018 Avg. $ 1.630 $ 3.320 $ 0.250 $ 0.057 $ 0.050 $ 0.030 $ 0.833 $ 0.733 $ 1.963 Incr. Above $ 0.05 $ (0.221 $ 0.04 $ (0.04) $ (0.02) $ 0.01 $ 0.07 $ 0.07 $ (0.20) Last Year Same Month 3% -7% 16% -100% 40% 33% 9% 10% -10% Incr. Based $ 1.00 $ (4.81) on 20 Therms 3% -7% Equivalent Cents/KWH 5.6 11.5 for Gas vs. Duke Rate 14.1 14.1 Note: Duke Energy Florida's residential rate for usage >1,000 KWH in January 2019 is 14.113 cents/KWH. (Residential) _ Gas Cheaper by -60% -19% 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 unchan ed $90/year, and NFE rate unchanged @ $1.00/gallon. UTA decreased by 9 cents/gallon to 0. - RIA & ECA unchanged initially 1 1 1 i 1 CSW:11 /28/2018 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 $ 1.34 $ 0.046 $ 0.084 -46% September 2002 $ 1.36 $ 0.046 $ 0.074 -37% September 2003 $ 1.56 $ 0.053 $ 0.084 -37% September 2004 $ 1.69 $ 0.058 $ 0.089 -35% September 2005 $ 1.97 $ 0.067 $ • 0.097 -31 % September 2006 $ 1.89 $ 0.065 $ 0.119 -46% September 2007 $ 1.86 $ 0.063 $ 0.120 -47% September 2008 $ 2.12 $ 0.072 $ 0.120 -40% September 2009 $ 1.39 $ 0.047 $ 0.132 -64% September 2010 $ 1.39 $ 0.047 $ 0.136 -65% September 2011 $ 1.42 $ 0.048 $ 0.129 -62% September 2012 $ 1.48 $ 0.051 $ 0.132 -62% September 2013 $ 1.67 $ 0.047 $ 0.123 -62% September 2014 $ 1.75 $ 0.047 $ 0.123 -62% September 2015 $ 1.57 $ 0.047 $ 0.123 -62% September 2016 $ 1.38 $ 0.047 $ 0.123 -62% September 2017 $ 1.70 $ 0.058 $ 0.130 -55% September 2018 $ 1.60 $ 0.055 $ 0.134 -59% $ Increase over Last 17 Years $ 0.26 $ 0.01 $ 0.05 % Increase over Last 17 Years Avg. Annual Inc. Over Last 17 Yrs. 19.4% 20.3% 59.5% 1.1% 1.2% 3.5% Csw:1 1/28/2018 Attachment #6 Page 3 of 3 Annual Average CGS Residential Rates Calender Year Fiscal Year Year NG/Therm LP/Gallon * Year NG/Therm LP/Gallon * 1995 NA NA FY 95196 $ 0.880 $ 1.199 * 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 FY 16/17 $ 1.700 $ 2.710 2017 $ 1.607 $ 2.936 FY 17/18 $ 1.607 $ 2.936 2018 $ 1.630 $ 3.320 Average $ 1.508 $ 2.426 $ 1.500 $ 2.368 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 eGr Greener Clearwater Gas System JithGas a Greener Fuel Use and Cost Comparison (Effective Rates for June 2019) 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 $ 74.25 $151.20 $186.30 WATER HEATING -Gas Tank Style/Gas Tankless vs. Electric Tank Style 170 / 100 $280.50/$165.00* $571.20/$307.00* $703.80 HEATING ( 150 $247.50 $504.00 $621.00 CLOTHES DRYING 50 $ 82.50 $168.00 $207.00 TOTAL APPLIANCE USAGE — with tank/tankless $684.70/ $569.25* $1,394.40/ $1,130.20* $1,718.10 GAS SAVINGS VS. ELECTRICITY 60% / 67%* 19%/ 34%* I*when using tankless *when using tankless- LP OUTDOOR RECREATION: POOL HEATING* ( 375 $618.75 ( $1,260.00 1 $1,552.50 SPA/HOT TUB HEAT* I 175 1 $288.75 1 $ 588.00 1 $ 724.50 *varies according to pool 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 ' $1.65 per therm 3. LP Gas per gallon (BRLP3) $3.07 per gallon or Per KWH or I $3.36 per therm $4.14 per therm 4. Duke Energy per KWH (Based on >1000 KWH rate) $0.14113 1. Notes: The above analysis is based on June 2019 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.82, Peoples $20.00 in Central Pasco. 711 Maple Street • Clearwater, FL 33755 • (727) 562-4980 www.clearwatergas.com