Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
GAS ADJUSTMENTS EFFECTIVE MARCH 1, 2022
CLEARWATER GAS SYSTEM Interoffice Correspondence Sheet TO: Mr. Jon Jennings, City Manager FROM: Chuck Warrington, Executive Director COPIES: Rosemarie Call, City Clerk; CGS & UCS Management Teams; UCS Billing Team; Micah Maxwell, Assistant City Manager 4'f SUBJECT: GAS ADJUSTMENTS EFFECTIVE MARCH 1, 2022 DATE: February 23, 2022 RECEIVED MAR 0 2 2022 OFFICIAL RECORDS AND LEGISLATIVE SRVCS DEPT. In March we are implementing the 2nd phase of our 2021 Rate Changes, which increase our Residential Metered Customer Charges by $2/Month and increase our Residential Bulk & Will -Call Propane Annual Customer Charges by $20/year effective for billings on and after March 1st. Natural Gas supply prices have been rising this Fall/Winter; therefore, we are recommending a 7¢/therm increase in our Natural Gas Purchase Gas Adjustments (PGA) in March. Propane supply prices have not risen substantially; therefore, we are not recommending any changes at this time for our Propane (LP) PGA for March. We recommend that we continue our Contract LP PGA at 30¢ below our standard LP PGA. We have reduced our projections for our Energy Conservation Adjustment (ECA) such that we are recommending a reduction of 4¢/therm or gallon for March. We are recommending no changes in our Usage & Inflation Adjustments nor our Regulatory Imposition Adjustment (RIA) for March. The net effect of these recommended changes for March is a 3¢ per therm increase (+2.2%) in our typical Residential Natural Gas customer's therm rate but a 4¢ per gallon decrease (--1.2%) in our typical Residential LP customer's energy rate. Therefore, we are recommending your approval of the following rates to become effective for billings rendered on and after March 1, 2022: Natural Gas Firm Standard Rate Schedule PGA $0.83 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.74 per therm (up 7¢) $2.25 per gallon (no change) $1.95 per gallon (no change) $0.13 per therm or gallon (down 4¢) $0.01 per therm or gallon (no change) -$0.01 per therm or gallon (no change) $0.05 per therm or gallon (no change) Mr. Jon Jennings, City Manager February 23, 2022 Page 2 Attachment #1 shows the status of our Adjustment Recovery Clause balances with actuals thru January and projections thru FYE 22. 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 this year, and Pages #2 our 21 -year relationship to electric prices and average residential rates, respectively. and #3 of this show Please note that Page #2 of this analysis shows that, over the past 21 years, our residential natural gas rates have dropped an average of 0.3% annually as compared to a 3.2% average annual increase for the Duke Energy (formerly Progress Energy Florida/FPC) residential rates. That's a remarkable difference! I should point out that the overall effect of these proposed changes is that our typical Residential customer energy rates are now approximately 68% lower than electric for Natural Gas and 14% lower than electric for our typical LP Residential energy rates. Even when you add in the NG Customer Charge, the typical 3 -appliance customer home would see a 43% savings for NG as opposed to electric (see Attachment #7). This is a very attractive competitive position vs. electric rates for our Natural Gas customers. 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, our per gasoline gallon equivalent (GGE) Natural Gas Vehicle (NGV) Fueling Station pump price is $1.52/GGE --- a remarkable savings from the gas station prices around town, and we believe the lowest posted NGV price in the State. For governmental fleet vehicles, our price is $1.34/GGE, as these fleets pay no Federal taxes on fuel --- an even more remarkable price. One of the reasons for this low rate is that Congress passed the Tax Extender package thru 2021 which provides for a 50¢/GGE reduction in the Excise Tax Credit for NGV vehicle fuel such that we are able to reflect this by reducing our rate at the pump. There is a bill in the works now to hopefully extend this beyond 2021 to provide economic security for NGV conversions. Jon, 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 March 1' billings. If you have any questions on this, please call me. CSW/cw Attachments c.41 0 Approved: 06.1110^` Jon Jennings, City Manager U:\My Documents\WORD\GASRATES\FY 21-22\Gas Adjustments for March 1, 2022.docx CLIARWATIR OAS SYSTIM SUMMARY OR RATS ADJUITM 4T CLAUSE COLLECTIONS MTTAcNM I NATURAt,GAS PURCHASED GAS ADJUSTMENT (PGA -NG) Monthly Cumulative NG PGA Budget Month Reservation Charges Commodity Charges Personal Services Int Bund Svc charge Dividend Other Prior YEAR Writs off Interest Expense Cost Center Expenses Total NG Fuel Expenses Total NG PGA Billed Overage (Shortage) YTD Overage (Shortage) $ (126.461.12) $ (269.118.69) Rats/Therm Firm/Contr Therms Billed Rec/Therm Prior Year Oct -21 $ 135,111.47 1,097,913.43 $ 31,869.35 $ 123.163.33 $ - $ 5,976.81 9,559.39 $ 313.65 $ 170,568.88 - $ 1,403,907.43 $ 1,260.249.86 $ (143.657.57) 0.73/0.84 0.13/0.64 0.76/0.87 0.76/0,67 0766/0.6; 0.830.74 0 81/0 74 1,950,000 0.65 Nov -21 Dec -21 $ 226,434.85 $ 231,062.53 1,460,071.57 1,051,408.67 $ 22,971.06 $ 25,015.61 $ 123,163.33 $ 123,163.33 $ - $ - $ 15,781.23 $ 8.218.11 $ - $ - $ 872.80 $ 1,926.19 $ 161,915.62 $ 156,395.05 $ 1.849,094.84 $ 1.440,792.44 1,347.738.67 1,670.948.17 $ (501,356.17) $ 230,155.73 $ (770,474.86)1 $ (540,319.13) 2,080.000 2,440.000 0.65 0.68 Jan -22 Feb -22 $ 235.885.21 3 208300 00 1,735,967.16 1.500.00000 $ 22,987.92 5 30.00000 $ 123,163.33 5 '25 000 00 $ 525.000.00 5 525.00000 $ 16.314.01 $ 10 000 00 $ - 3 - $ 1.350.80 3 3 677 12 $ 687,465.26 3 690.00000 $ 2.660,668.43 $ 2.401.977.12 1,730,138.36 1.815.60000 $ (930,530.07) 0 '58637712, $ (1,470,849.19) 5,2.05722632, 2.516.981 2670.000 0.68 0.673 Mar -22 4pr-22 $ 232 600 00 3 167 700 00 1 200.000 00 1,100000 00 5 30 000.00 0 30..000 00 5 125 000 00 5 125.000 00 $ 450 000 00 $ - 3 10.000 00 S 10.000 00 9 - $ - 3 5.14 3 07 $ 5 549 92 $ 615 000 00 $ 165 000 00 i 2 052.743 07 3 1 438 249 32 1 690 000 30 1 807 500 00 5 )' 62 /4'3 37 : 0 Y9 5•0 08 5 i 2.219 969 36 5 . 1 850 7 19 ..1 i 2 520 000 2.410 00.2 075 0 06.•• May -22 Ju'.22 $ 114.200 00 $ 112.300.00 1000 000 00 900 000 00 S. 30.000 00 $ 30 000 00 5 125 000.00 5 125.00000 $ - $ - 3 10 C00 OO 8 10.5/3000 3 - $ - 5 4 626 80 3 367387 3 165.000 00 5 16500000 3 1 283 820 80 3 1 180 973 87 1 065 000 30 1.597500.00 - '61 1 7; 20 3 416.52619 g , 1 409 546 1 1 1 3,1053.019.97) 0 83/0 74 0 83/0 74 2.220 002. _-130.000 - :75 075 31,1-22 Aug 22 8 116.100 00 5 116 100 00 850.000.00 850.000.00 $ 30 00000 $ 30 000.00 $ 125 000 00 $ 125 000 00 $ - 5 - 5 10.000 00 $ 10 00000 $ - $ - 3 2 532 55 $ 1 604 38 3 165.000 00 3 165.000.00 $ 1 133 732 55 $ 1.132.704 38 1 515 000 00 1 545 000 00 9 411 .267 45 $ 412 295 62 5 i 641.752 .,',2 } 5 29 456 90; 0.93/0.74 0 8310 74 2.060 0002 2.060 000 0 75 0 75. Sep -32 $ 110.30000 850 000 00 5 30.00000 3 125.000 00 5 - 5 10.000 00 5 5 `.73 64 5 165,000.00 3 1 .125.87 3 64 1 560 000 00 9 434 1; 6 34 5 254 069 417, 0 8310 74 2 080 000 „ 75 Total YTD 5 2.006.094 06 5 13.595 360 83 3 342.843 94 3 1.492653 32 3 1 500.000 00 $ 126.288 16 $ 9.559 39 $ 31 744 78 5 3.471 344 81 $ 19.104 544 49 3 19.4:34 675 76 $ 3.30 '30 58 FROPANI (LPI GAS PURCHASED GAS ADJUSTMENT (PGA -LP) Cost Monthly Cumulative LP PGA Budget Month Gallons Sold Monthly WACDG Interlund Svc charge Dividend Festivals & Fuel LP Yard Eveportzetion Suburban Software Prior YEAR Write off Interest Expense Commodity Charges Center Ex ' nee' Total LP Fuel Ex • - noes Total LP PGA Billed Overage (Shortage) YTD Overage (Shortage) $ (74.717.18) $ (70.446.98) Therm/Gal. Prior Year Oct -21 29,269.1 $ 1.55845 $ 5,273.33 $ - $ - $ 104.42 $ - $ 135.25 $ 188.79 45,614.43 r r i r $ 4.270.18 1.82/1.99 Nov -21 Dee -21 36,892,3 34,460.5 $ 1.57136 5 1.47593 6 5,273.33 $ 5,273.33 $ - $ - $ 882.03 $ 126.80 $ - $ 44.28 $ - $ - $ - $ - $ 176.12 $ 153.92 57,971.08 50,861.29 r < • r • • $ 8.880.90 $ 19,639.06 $ (61,566.08) $ (41,927.03) 1.82/1.99 2.061226 2.06/2.25 2 56/2 25 Jan -22 F et..?2 44,042.7 48.000 0 $ 1.47224 $ '.54000 6 5,27 3.33 $ 5 300 00 $ - 3 - $ - 3 400 00 $ 22.08 3 50 CO 6 - _ 5 000 0(3 $ - 5 - $ 104.82 5 32 87 64,841.42 73 910 30 5,295.41 $ 70,241.65r $ 28,777.44 3 21 377 13 $ (13,149.60) 3 8 227 E. Ni.x-.22 4,3,-22 48 0000 36 000 0 S 1 57 000 3 1 56000 $ 5.300 00 3 5 300 00 3 70.000 00 $ - 3 400 00 $ 400 00 3 500`7 'a 50 C!,:! 3 5 _ 5 5 ! 20 57) - 31 95 75 760 00 50 160.00 5 , 45.009 4:1 3 • 556 05 9 -0 . - 30,2."....*.,.'. 2. 5 3-.; 2 0,!•1J2 7. May -22 Jun -22 2 7.000 0 18 000 .0 3 1 54000 3 1.51000 3 5 30000 5 5,300100 3 $ - 5 400 00 3 400 00 3 50 00 3 50 60 5 5 5 - 5 48 06 $ 17 33 41 680.00 27 180.00 5 777 00 5.76230 $ 413763/-. 5 :2 .947 37 5/ 4 -C- W 39 700 00 5 .. 291 94 3 6 832 57 3 0 , 3 >,. 5 ,93 /, 2 ,J6.12 2 5 2 06/2 25 44l-32 A,r4 :2. •30000 27000 0 $ 1.49000 3 1 48000 $ 5.300.00 3 5 300.00 5 - 3 - 3 400.00 3 40000 $ 5000 $ 50 00 S 5 $ - 5 025 3 117 78) 26 820 00 29 960.00 -,5000 ., 750 30 $ .. 57025 5 45 092 :7 5/773:�a `=1.670 5. 5 7 209 75 $ 13.97 7 78 $ 71,'9,-, 3 21 388 28 2 50/22`., 2 06.12 25 Sep- .'2. 412 27000.0 5 144000 5 5 300 00 5 - $ 40000 $ 5000 3 -. - 5 ;52721 3788000 -`0.00 5 44`-7,:6 A %.,,O. ..;:13 5 /5/5/272 0>71 1 . 72 0.117/.2-'. Tota:710 5 393 644 60 5 1.52 3 63493:32 $ 70./X10.00 3 4.,0883 5 57018 0 5.0002.0 9 1362.. 3 721(4 5 599148,22 5 4.L4;:u ,- 5. 74:3'_ „_ _4, ' 511563316 ENERGY CONSERVATION ADJUSTMENT (ECA) Budget Month Prior Veer Oct -21 Personal Services $ 109,883.48 Advertising $ 280.00 Residential S. Builder ECA end Other Promotional $ 50,625.00 Interfund Svc charge $ 6,544.17 Dividend $ - Other Operating Expenses $ 4.833.01 SNEP $ 9.933.46 Prior Year write off $ 3.153.86 Interest Expense $ (76.66) Total ECA Expenses $ 185,176.32 Total ECA Billed - $ 229,321.78 Monthly Overage (Shortage) $ 44,145.46 Cumulative YTD Overage (Shortage) $ 30160.77 $ 74,811.23 ECA NG/Therm LP/GeL 0.20/0.20 0.20/0.20 0.17/0.17 0.17/0.17 0 17 /0 17 0.13/0.13 0 1 5'0 1:'. 0 13:'0 13 Nov -21 $ 79.769.33 $ 11,189.00 $ 55,125.00 $ 6,544.17 $ - $ 3,848.76 $ 13.894.61 $ - $ (187.03) $ 170,163.84 248,137.38 $ 77,973.54 $ 152,784.77 Dec -21 $ 82.885.37 $ 8,189.00 $ 96,675.00 $ 6,544.17 $ - $ 3,686.44 $ 44,626.44 $ - $ (381.96) $ 242,223.46 274.926.92 $ 32703.46 $ 185,488.23 Jan -22 Feb -22 Mar -22 Apr -22 May -22 $ 73,545.63 $ 80 000 00 $ 8000000 3 80 000 00 $ 80.000 CO $ 9.596.00 $ 9 000 00 3 9000.70 $ 9000 00 $ 9 004.00 $ 72,650.00 $ 80-000 00 $ 80 000 00 0 80 00000 $ 90 00000 $ 6,544.17 9 6 600 00 3 6.60000 $ 6 60000 5 6 600 00 $ - 3 - 3 70.03000 5 - 3 - $ 22,417.79 9 6 000 C3 3 8000CYO 5 8 003 50 3 8,300 00 $ 26,426.02 3 80.000 00 3 80 000 00 _ 30 050 0.7 3 80 000 53 $ - 0 - 9 5 5 - $ (463.72) 5 ,676 95: 5 ;956.15) a [ 754 54 r 0 0199.921 $ 210,715.89 $ 262 921.05 $ 332643.85 5 262 845 46 5 262 900.03 296,807.23 373.803 53 25200000/ 24' 000 50 222 007 00 $ 86,091.34 0 115 - 3 95 5 • 626435), 5 .2' 0.41 45 5 ,4':630 08) $ 271,579.58 5 78= 45» '72 9 31J1 8 3 9 969 21 5 94 269 '3 .Fun -22 441-22 3 80 000 010 $ 8000000 3 9 006 00 5 9.000 03 5 80 000 00 $ 80.000 OG $ 6.600 00 $ 6.600.00 $ - $ - $ 8 000 00 9 8 00700 0 80 000 03 9 80 000 00 i - $ - 5 , 597 671 5 i 472 67) 5 263 552 33 5 2030272): 213 000 00 206 000.00 $ . 9 5 K.':7..,02 3 57 105/2/, 5 82 C.'(-(:.- 5 1.1:1 535 4:- 0 13/0 13 0.1 13 049-22 asp -22 $ ' 8000000 5 60 000 00 $ 9 000 00 $ 5 000 00 8 80.000 00 $ 80.000.00 $ 6 600.00 $ 6 600.00 $ - $ - 9 9 000 05 5 8.000 00 9 80 000 W - 80.000.00 5 - $ - 3 1329 85.1 5 113667, $ 263,270 :5 3 253 413 -3 25/3 000 00 2 33.003 r 5 .57 270 15, 0 , 55 4 .. 5 '4 669 22 a 9 255 93 0 13'0 13 0 13,0 17 TotalYTO $ 986.083.81 5 101.234 00 $ 915.07500 $ ;8976.68 $ 70.000.00 5 987867- 5 734.87953 $ 3'5386 $ 25.78579) $ 2982.40309 $ 2.970.99331 1 :1409 0. CLOARWATelt OAS SYSTEM 1UMMARY OF RATS ADJtJ$TMINT CLAMS COLLICTIONI REGULATORY IMPOSITION ADJUSTMENT (RIA) ORA ORA (ORA) (EIA) (EIA) (EIA) Budget Interfund Svc charge Dividend Insurance Prior Year write off Personal Sys Other Regulatory Interest Total RIA Total RIA Overage YTD Overage NG/Therm - Month Prior Year Expenses Expenses Expense Expenses - Billed (Shortage) $ - (Shortage) $ 30,378.88 LP/Gal Oct -21 Nov -21 $ 1,223.33 $ - $ - $ 1,223.33 $ - $ • $ 973.83 $ - $ 11,118.35 $ 8,054.28 $ - $ - 13,315.51 9,277.61 $ (75.95) $ (128.49) $ 13.239.56 $ 9,149.12 34,256.13 37,226.48 $ 21.016.57 $ 28,077.36 $ 51,395.43 $ 79,472.79 0.03/0.03 0.03/0.03 0.01/0.01 0.01/0.01 Dee -21 Jan -22 $ 1.223.33 $ - $ - $ 1,223.33 $ • $ - $ - $ • $ 8,125.23 $ 8,182.82 $ - $ - 9,348.56 9,406.15 $ (198.68) $ (216.62) $ 9,149.88 $ 9,189.53 16,326.53 17,462.51 $ 7.176.65 $ 8.272.98 $ 86,649.44 $ 94,922.42 fret'22 Mat -22 5 1.30000 $ - $ - 5 1300.00 $ 60,000.0 $ 5 - 5 10,000.00 $ 10.000.00 $ 7,1,00-00 5 7,50000 18,800.03 78.800.03 S .:237 31, 5 .257.65, 3 18.562 69 $ 78.54235 26 700 00 _5260.00 S 8 ,37 ,..1 $ .8'..342 s3, 5 100 059 73 3 49-1%;5 0 0 "0 01 001,00,, Apr -22 638y-22 5 1300-0 5 - 5 - 5 1,300 00 5 - $ - 5 - 5 - $ 10.000.00 5 20,000.00 5 7,9:.)0 00 5 7.50000 18,800.00 18.800.00 5 ;124 29, 5 1 l37 851 3 18.675 71 $ 18 662.15 24 100.00 22200.00 $ 5 424 20 $ 3_`37 85 3 55 141 67 3 58 679 52 0 01, 01 0000 07 Jun -22 uu1-22 3 3300 00 5 $ $ 1.300.0.- $ - 5 - 5 - $ - 5 10000 00 5 10.000 00 $ 7,50.00 5 7.500.05. 18,80003 18.80060 .3 ,14670/ 5 115332, 3 18.65330 3 18-E45.68 2130005 20 600 00 3 2 546.73 $ 1.95332 , 61 3^_6.22 5 5327054 001700' 3C1/07o 3.ug-22 S€ -22 5 1.300 00 5 - $ 5 1,30.0 $ 5 - 5 - $ 5 10030.00 5 10.00.00 5 7.5000 5 7.500.00 18.,00.00 18,800.0 5 ,158 20, 3 063 3 03, 3 18 641 80 5 18.636 91 20,60000 20 800 00 5 1950,20 0 2.163 39 5 45 21' 74 5 67 400 83 90'..1'1 0 01,3 01 613 ,,,u, YID $ 15293.32 5 60.0000 $ - 3 17543066 $ /0000000 52;1.-14733 5 ,1998151 249.74968 281:7155 S '2'9- USAGE AND INFLATION ADJUSTMENT (004) Commerc Budget el Interest Monthly Overage Cumulative YTD Overage UA NG/Thenn Month Beg. Bal. LP Galion* Expense Rate/Gallon NGT erne Rate/Therm (Shortage) 5 - (Shortage) $ (680,613.28) $ (569,506.14) $ (453.120.22) LP/Gal Oct -21 Nov -21 6,646.0 $ 3,402.57 0.13 6.902.2 $ 2847.53 0.13 821,469.80 858,000.50 0.13 0.13 111,007.12 116.385.92 0.13/0.13 0.13/0.13 Dec -21 Jan -22 7,111.3 $ 2265.60 0.05 6,490.3 $ 1,971.73 0.05 1.071,048.40 1,132,515.20 0.05 0.05 58,773.50 61,775.48 $ (394.346.72) $ (332.571.26) 0.081006 0.05/0.05 5ec, 22 Mar -22 7 500.0 5 1.5'62 86 0 05 8.500.0 0 1 394 30 0.05 1.100.000 00 1 10,0 000 00 0 05 ....105 53.712 14 54 030 70 0 .278 859 121 $ 224 328 41 0 05/0 05 0 0510 05 A{'4-22 May -22 8.0000 3 1 124 14 005 8.000.0 $ 85276 0 05 1 100.000 1, 000 000 0 005 n 05 54.27536 49 547.24 - ..1705-205, 3 1121 345 32 i 0 05/0 05 0 05/0 05 .,1r,-22 Iv I-77 7.500 0 $ 605 03 0 05 7 00 0 3 381.18 005 900.000 03 900 00000 0 35 0 05 44 769 97 44968 32 3 - - 3'/' 341 3 13' 266 523 0 050 00 0 05/0 05 Aug.. 22 3/9 22 6 000 0 5 136 33 0 05 6 500 0 5 156 891 0 u5 350 030 0 810 000 00 0 0. 0 35 42.643 67 42.381 30 3 + 1 .377 15 3 `4 259 01 0 05)0 05 0 05/0 X75 er 13 ,0.a; '7 0 551496 16 607 14 Per Oeln6tion el UTA Attachment N7 FY21 due to be cotlxted INFLATION ADJUSTMENT (1110) 11. G8°033'-1'1 • $812.740.2411 FY21 ended the year rah over4undell ';µ1'i_'.2/ collection d $(67,773.02) (1) USAGE AND Residential Budget Interest Monthly Overage Cumulative YTD Overage UA NG/Therm Month Beg. Bal. LP Gallons Expense Rate/Gallon NG Therms Rate/ herrn (Shortage) $ - (Shortage) $ 68,884.21 $ 56,395.40 LP/Gel Oct -21 22.609.6 $ (283.42) - 297.240.70 - $ (288.81) 0.0010.00 Nov -21 29,984.7 $ (281.98) - 345,937.50 - $ (294.90) $ 56,100.50 0.00/0.00 Dec -21 Jen -22 27,338.4 $ (280.50) (0.01) 37,541.6 $ (252.21) (0.01) 510.663.80 569,410.90 (0.01) (0.01) $ (5,658.94) (6,409.76) $ 50,441.56 $ 44,031.80 -0.011-0.01 -0.011-0.01 Fet-23 Mar 72 35.030 0 $ 1220 16, '.2 21, 420000 5 118951, ;001/ 6600 03000 50000000 ,0 01, ;0.311 .6 129 941 .,521049, 3 37 901 96 3 .12.69147 0 0160 01 -0017.031 Apr -22 Mai -22 35.0000 3 '16 46, .0011 30000.0 5 ;137 52, :0.01, 500000.0 400.00500 .0 01, 1001, 518554, ;416248; 3 7'5045-,. 3 _334245 701/.001 -0017-001 10^-22 Jul -22 20 000 0 S ;116711 ;0-21, 20.COO .0 $ ,9880; i 001, 35000000 300.00000 '001;3.58320; ,001, 13101 20, 3 19 '59 15 0 15.657.96 -0011-001 -0017-0.01 Aug -22 Seo --22 20 000 0 3 i 8379, '0011 20.0000 3 X6771, !001, 300.00000 300.00000 .001, ,001; ,'.-11671, 1313229, $ 15`-4125 5 10.40895 -0013001 -091!-001 Per 13 231a1 520 337 474 3 ;22175751 Par Ce lnielon of UTA Alledment Id FY21 due to be collected 4,973 12 90 • ($27,192.91) 8 FY21 ended 110 1 year Mei aver(under) x '45 273 25, collection of $29,491.27 (1) CLIARWATIR OA$ mirror SUMMARY Or RATS ADJUSTMENT CLAUSE COLLECTIO4 TOTAL ALL COST RECOVERY ADJUSTMENT CLAUSES (Both PG ♦ ECA + RIA+UTA) Cumulative Total Monthly Budget Mon h Total All Total Recovery Overage Expenses Billed (Shortage) YTD Overage NGITH (Firm) (Shortage) NG/LP - RIO! Year Oct -21 - - $ - $ 1,653,637.53 $ 1.890,130.48 $ 36,492.95 $ (762.962.70) $ (726,469.75) 0.96/2.22 • Nov -21 Dec -21 $ 2092.710.36 $ 1,822,377.01 $ (270,333,35) $ 1,748,625.38 $ 2,091.414.84 $ 342,789.46 $ (996.803.11) 0.98/2.22 $ (864.013.65) 0,93/2.42 Jan -22 t o+. ,:.. $ 2,950.815.50 $ 2.198,792.89 $ (752,022.61) . -.. �.t, ,,.. , . 2.369.762 30 5 (398.401 .14', $ (1.406.038.26) 0.93/2.42 $ 11.804,41( 69) 0 743/; 42 Meg 22 Apr 22 3 2 015 (.0 (3 ,u 5 2.322.100 21 3 /22.91 8 491 5 1 781 773 35 $ 2 201 249 32 3 419.476 27 $ (2 097 356 181 0,9612.38 5 (1.617.879 91) 0.96/2 38 Ma1-22 4un-22 5 '.61276708 5 2.01425476 5 401 487 68 5 1 495 576 82 5 1.912 766 63 S 417 189 86 5i' 27639223) 096/2'78 5 (859 202 37) 0 56/2.38 Jul -22 A(4-22 5 1.448.07682 S 1853.24762 5 405.17030 5 1.460.308 56 $ 1.870 706 96 1 410.43040 S ( 454 031 57) 0 9612 38 3 03.543 17) 0.9612 .38 3' -22 Per 13 3 1 452.501 10 5 1 888:19 59 $ 475' , 3 44 S 392 175 27 0 96/3 1 , Mel YTt, NG NFE ..3.079.97470 224.235.1'2'; S 1 ^'.5( -97 TRACKING Actual Annual Actual Actual Budget Month Therms NFE YTD Total Stmt Plan Amt. Beg. Bel. Oct -21 1,954,418.5 1.044,396.74 1,044,396.74 (1,044.396.74) Nov -21 Dec -21 2,078.550.7 1685,254.93 2,435,248.2 1.243,247.10 1.085.254.93 1243,247.10 (2.129.651.67) (3,372,898.77) Jan -22 Feb -22 - - (3,372,898.77) (3,372.898.77) Mer -22 Apr -22 - - (3.372.898.77) (3,372.898.77) May -22 Jun -22 - (3.372,898.77) (3,372,898.77) Jul -22 Aug -22 - - (3,372.898.77) (3,372.898.77) Sep -22 - (3,372.898.77) Average NFE Rate per therm Total YTD 0.52 6,488,217.4 3.372,898.77 LP NFE TRACKING Actual Annual Budget Actual Actual Month Beg. Bal. Gal one NFE YTD Total Strat Plan Amt. Oct -21 Nov -21 29,269.1 46,454.26 36,892.3 52,966.46 46,454 52,966 (46.454.26) (99.420.72) Dec -21 Jen -22 34.460.5 57.462.81 57.463 - (156,883.53) (158.883.53) Feb -22 Mar -22 - - (156.883.53) (156.883.53) Apr -22 May -22 - (156,883.53) (156.883.53) Jun -22 Jul -22 Aug -22 Sep -22 - - - - (156,883.53) (156,883.53) (156,883.53) (156,883.53) Total YTD Average NFE Rate per gallon 1.56 100,621.9 156,883.53 Central Paseo County Natural Gas Sales (POA -NO) Budget Commodity Interest Total NG Fuel Total NG PGA Overage YID Overage Rate/Therm Month Pea' Yeer Charges Expense Expenses Billed (Shortage) (Shortage) $ (108,790.01) Firm)Contr Oct -21 Nov -21 73,198.03 $ 543.95 $ 73,198.00 55,362.89 $ 553.94 $ 55,362.89 $ 71,199.60 $ (1.998.40) 78,744.20 $ 23,381.31 $ (110,788.41) $ (87,407.10) 0.73 0.73 Dec -21 Jen -22 45,814.97 $ 437.04 $ 45,814.97 $ - 102199,73 $ 66.384.76 $ - $ (31,022.34) $ (31,022.34) 0.76 Feb -22 Mer -22 $ - $ - $ - $ - $ (31,022.34) $ (31,022.34) Apr -22 May -22 $ - $ - $ - $ - $ (31,022.34) $ (31.022.34) Jun -22 Jul -22 $ - $ - $ - $ - $ (31,022.34) $ (31,022.34) Aug -22 $ - $ - $ (31.022.34) CLEARWATER OAS SYSTEM ;UM NARY OF RATE ADJUSTMENT CLAUSE COLLECTION( Sep -22 Total YTO $ - $ - $ (31,022.34) ' $ 174.375.86 $ 1,534.93 $ 174.375.86 $ 252,143.53 $ 77.767.67 R E S E R V A T 1 O Oct -21 Nov21 Dec -21 Jan -22 Feb -22 Mar -22 466-22 May 22 Jun -22 Jui-22 Aug -22 Sep. 22 Total C p Oct•21 Nov -21 M Dec -21 M Jan -22 Feb -2- O Mar -22 D Apr_22 M30 72 ( Jur.-22 J0622 T Aug -22 Sep -22 Total A7740f/1EA i 1°,C ! oZ CGS Natural Gas Summary Monthly Achu1/ProJedfons (FY22) Volume FTS -1 50.6318 Cot FTS -2 90.6318 Vdume Cost No-Notlee 50.0478 Vdume Cost Capedty Relinquishment Vdume Rate Cost Reservdlon 64ustrnents TOTAL RESERVATION COST Total Rete 170,438 5 107,921.34 41,788 $ 26,46019 15,500 $ 846.30 (3,689) $ 0.0318 $ (117.36) $1.03 $ 135,111.47 $0.6031 306,570 $ 194,120.12 53,430 $ 33,831.88 22,500 $ 1,228.50 (99,808) 8 0.0278 5 (2,781.88) 536.23 $ 226,434.85 50.8013 316,789 $ 200,590.79 55,211 $ 34,959.61 31,000 $ 1,692.60 (100,230) $ 0.0624 $ (6,255.47) 575.00 $ 231,062.53 60.7632 316,789 $ 200,590.79 55,211 $ 34,959.61 46,500 $ 2,538.90 (19,579) $ 0.1139 $ (2,230.91) 526.82 5 235,885.21 50.5913 286.132 $ 180.778 20 49.868 $ 31.506 60 42 000 5 2007 0!0 .80 000, 5 0 1000 5 +6.000.00, 50 00 S 208.292 40 50 ,;550 316.789 S 200147.29 55.211 $ 34.88231 3100X! 5 1 481 30 140.0001 5 0'000 $ 14.00000, 5000 $ 232 511 41; 570805 216.570 $ 136 828 93 53 430 $ 53.757 07 22 500 5 1 075 50 +40 000, $ 0 1000 $ 74 000.001 50 00 $ 167 651 50 556645 144,212 $ 91 113 14 41 750 $ 26.401.56 12400 $ 592.72 +20000, 5 0.2000 $ +4000001 5000 0 114100752 506298 139.560 $ 8817401 40.440 $ 25 549 99 1050,7 5 501 141. :.10000, 5 21,50 5 +2000.00i 5000 5 11222500 006213 144.212 $ 91.113 14 41.788 5 26 401 66 10 850 $ 518.63 15000, $ 0 2500 5 t2 000.`.)0, 50 00 S 116 033 43 5r. 621' 0 144.212 5 91 113 14 41788 $ 26 401 66 100`•0 5 51063 .10000. 5 0,7006. 5 700600, 0300 S 11533/43 505110 133 560 5 08.174.01 40.440 5 25 549 99 10 540 c 501 90 120-000, $ 0 2000 5 ;4.000 00! 55 00 5 110 225 05. 50 6405 2,641.833 $ 1,670.664.89 570,393 $ 360,862.21 286,100 $ 13,504.98 (433,407) (539.385.82) $139.08 52,005,585.54 50.6587 90.6324 .6323 90.0508 as d 2/72022 FTS -1 (Usage) Volume Rate Cost Vdume FTS•2 (Usage) Rate Cost Gas Supply (FGU &Interconnects) Vdume Rate Cost Fuel% FGU Management fee 50.065 No Whet: Usage GTI Payment 50.020 Cashcut Ria Month A4ustment COMMODITY COST MU 41404414 153,712 $ 0.0583 $ 8,961.41 190,710 $ 0.0593 $ 11,11441 171,323 $ 0.0583 $ 9,988.14 220,207 5 0.0583 $ 12,838.07 177 057 9 0 05,83 $ 10 322 4;' 164 214 .5 0 0583 5 4 573 68 151.495 5 0 0583 5 8 632 16 168.637 5 0 0583 S 3 248 54 147 985 5 0 0583 $ 5527 53 147 637 .5 0.0583 5 8 607.24 147 637 5 0 0583 5 8 657 24 154 985 5 0.5553 $ 9.152 23 41,788 40,440 55,211 55,211 49.868 55 211 53 430 41708 40 440 41 758 41 788 40 440 5 0.0583 5 2,436.24 $ 0.0583 9 2,357.65 $ 0.0583 $ 3,218.80 8 0.0583 $ 3,218.80 5 3.0500 5. 2 49'. 4'; 0 0500 5 'J 0506 5 2 675 97 5 0 0509 5 2.049 40 $ 0 0500 5 2 023 709 5 0 0500 $ 3 069 40 0 0 0500 5 2.089 411 5 0 0500 5 2 022 00 209,001 245,660 240,124 302,490 252 ,+100 241 45' 222.005 211 5011 231 090 til 2.007) 202 900 210.900 $ 5.7013 $ 5.6134 $ 4.7837 5 4.8674 S S 29:: S 4 76 5 4 649+1 4.7141 5 4 3245 5 4 01 X06 5 4 1442 5 3.9749 $ 1,191,575.28 $ 1,378,99641 $ 1,148,686.44 $ 1,472,324.61 5 1 447, 751 60., 5 1 14 7 709 45 1 031 539 75 3 918 898 73 5 659 21850 5 910 150.27 5 337 120 20 5 834.729 75 2.33% 2.33% 2.33% 2.33% O1tt044 0 05'5 0 0046 7 00% 0 0793 093 9 _ 0 9053 0 1036 5 11,607.00 $ 12,500.00 $ 14,881.00 $ 15,476.00 .. +4 950 1 5 14.252 63 5 13.720.13 5 13 027 63 5 12 247 63 5 17 312 5^, 5 13 317 53 S 12 832 63 $ • $ • $ • $ • 5 5 5 5 c 5 5 - $ 3,910.00 $ 4,623.00 $ 4,530.66 $ 5,508.36 .- 5 4 .' - •s 50 5 470530 5 4 ('C:8 00 5 f / 0') 5. 7 ;, ..•.i.:, 3,347 - 5 4,179.96 $ 9,534.89 $ (5,049.84) $ (2,859.39) - 7, 1 - 5 . 5 (31,260.93) $ (33,667.34) $ (28,449.33) $ (27,393.75) - - $ - 5 0 - - 5 - $ 1,191,408.94 $ 1,385,463,02 $ 1,147,805.89 $ 1,479,112.70 S 1 475 366 5 1 178.604 5J S 1.060.402.03 $ 947.273.75 95 854 10 5 836647 55 7 563 {.1, c, - $ _b 5 862 685 10 1,987,599 "a,,tv "• •A 8 115,877.06 557.403 ' ' r-'h!2kik 5 29,469.14 2.740.274 54 73 $ 13,084,710.87 5159,530.00 50.00 551 000 04 55,805.82 (5120.771.35) 913.325021.38 000-21 Nov21 Dec -21 Jan•22 Feb -22 Mar -22 Apr -22 May -22 Jun -22 -22 Aug -22 Seg22 TOTAL COST Resery & Comm RATE $ 1,328,520.41 9 6.35 $ 1,611,897.87 $ 6.56 5 1,378,868.42 5 5.74 f 1,714,997.91 $ 5.67 b 1 684.158 45 5 5.54 S 1 411 206 20 S 5.86 0 1 228 123 53 L 5 53 0 1 061 380 28 S 493 0 1 958 115 05 5 5.72 5 952 981 29 5 4.72 b 979.951.39 5 4 85 $ 972 911 00 5 463 5 15,331,106.92 $ 5.59 Total Projected DTH WACOG Total Reservation Total Commodity Cost Purchased tate Mmlbe 5 1,259 297 86 5 7307351.40 5 9 127 640 26 +.495774 56120 2nd 6 Mordns $ 736 2/760 3, 5 469 159 35 c 0 ..!,j3 457 u5 260 x00 94 953 10767 5 203+_.504 1 .._`•5.1139 $ 15 .1.1059? 2740.214 05.555 $10,J41,20810 FGU Only Natural Gas 12 month rolling forcast 4-773-c-+1 r 2- u� a o i 2_ Total Rate Month Dth Demand Commodity Commodity Rate Total 2/1/2022 252,000 $ 208,292 $ 1,475,866 $ 5.86 $ 1,684,158 $ 6.68 3/1/2022 241,000 $ 232.511 $ 1,178,695 $ 4 89 $ 1,411,206 $ 5.86 4/1/2022 222,000 $ 167.662 $ 1,060,462 $ 4.78 $ 1,228,124 $ 5.53 5/1/2022 213,000 $ 114.108 $ 947.223 $ 4.45 $ 1,061,380 $ 4 98 6/1/2022 201,000 $ 112226 $ 895,884 S 446 $ 1,008,110 $ 5.02 7/1/2022 202,000 $ 116,033 $ 836.948 S 4 14 $ 952,981 $ 4 72 8/1/2022 202,000 $ 116,033 $ 863.918 c 4.28 $ 979,951 $ 4.85 9/1/2022 210,000 $ 110,226 $ 862,685 3 4.11 $ 972,911 $ 4.63 10/1/2022 225,000 $ 135,111 $ 945,000 $ 4.20 $ 1,080,111 $ 4 80 1.1/1/2022 240,000 $ 226,435 $ 1,008,000 $ 4.20 $ 1,234,435 $ 5.14 12/1/2022 250,000 $ 231,063 $ 1,125,000 $ 4.50 $ 1,356,063 $ 5.42 1/1/2023 275,000 $ 235,885 $ 1,237,500 $ 4.50 $ 1,473,385 $ 5.36 $ TOTAL 2,733,000 $ 2,005,586 $ 12,437,231 $ 4.53 $ 14,442,816 $ 5.28 Propene Weighted Average Cost of Gas (WACOG) LPWacog FY22 4-T7ACff/n e4Y! ? 2/18/2022 Date Company Invoice Targa Shlppng Gallons Delivered Propane Rate Propane Cost Shipping Cost Total FYTD Cost Gallons Cost of Inventory Tank Inventory Tank IMthdravi WACOG 0913021;.,. z' A'. aa$70.= fir . Z M .w.-: -' V'y S 15,568.37 n $ 514.13 ° '. ln.4-.a.. ' . 8,787.0 EMI= 43,984 - 1.35023 10/0621 S 16,082.50 5 75,471.10 52.771 1.43016 10/07/21 Tar 21042091. S 15.403.67 S 510.85 5 15.914.52 17.518.0 5 91.385.62 61.502 1.48590 10120/21 Tar 21043630 17,594 1.80214 S 30.677.35 S 1.029.42 S 31.706.77 35.112.0 $ 123.092.39 79.096 1.55624 10/31/21 MONTHLY INVENTORY ADJUSTMENT 90 3.50289 S 315.26 S 31526 35.202.0 5 123.407.65 79.186 1.55845 10/31/21 ? ,::4,,, •-4,,,:f.,-"4.3::„..-74.47-4;,‘., 1:471V--''.1 ' $:"'1, $ 76,125.75 48,647 30,339 1.55845 1110921 T 21046700 9.2021.70190 $ 15.055.63 $ 605.23 S 15,660.88 44.404.0 $ 91.786.61 58.049 1.58119 11/1721 Ta 21047618 18,3611.52715 322 S 26.832.32 9 1.207.65 S 28.03997 62.765.0 5 119.826.58 76.410 1.56821 ItIVENTORY ADJUSTMENT 2END S 747.21 S 74721 83 087.0 76.732 1.57136 OF MONTH�.320x5�3� E ran`1:x:.3' 3�:3i�'s•?3:`€"::r 1Q,. ''`.-. .3... �.. '= a+'Gr.�.�,?`:o-. .i5'i�::s.'i:, 35,362 41,370 1.57136 ,�MON114LY 4W0 9.1021.44742 1.32953 1.32153 1.42828 S 11.556.45 S 608.73 5 12.165.18 72,237.0 5 67,731.70 44.512 1.52165 kG S 11.251.55 S 595.03 $ 11,846.58 81,181.0 . 53.456 1.48867 �1E27/�0777211 sc:r.;,4 ' 22000405 S 12,416.43 S 606.61 $ 13.023.04 90.299.0 • i 62.574 1.47987 '®k 22000554 5 12.394.65 S 779.75 S 13.174.40 99.401.0 $ 105,775.72 71.676 1.47575 12/3i/21 NioltniLY INVENTORY 3TMEN 261.98154 5 51.52 6 51.52 99.427.0 5 105,827.24 71.702 1.47593 22000912 ., e 1.42127 1.43752 2.95588 ": c� ''t S 11.578.69 . 4'W S 561.83 S.. a-1%-..tn...,, S 12.140.52 "-...1W,,,s 107.969.0 44,829.94 5 56,970.46 30,374 38,916 41,321 1A7593 1.46393 01/05/222� I ' 22001539 S 12.539.17 5 601.23 6 13.140.40 117,110.070.110.86 48.057 1.45891 uraa>[i 22002451 111111112311.44127 $ 12.429.02 S 594.31 S 13.023.33 126.146.0 5 83.134.19 57.093 1.45612 9C 22004446 MINEEll1.47002 $ 26.141.53 $ 1.224.40 $ 27.365.93 144,762.0 , 75,709 1.45954 MONTHLY INVENTORY01/31/22 S 1.915.41 S 1,915.41 145 410 0 76.357 1.47224 01/31/Z2 END OF MONTHv ;,;-,+ ��' ', r 5'tc n<:': Y. ,'^ ✓ r. r`4"a.Ff'.r: ".s �. iJ*{1<. : , 37,043 3.9,314 1A7224 •.• • • i 18.8221.58613 $ 28.601,96 S 1,252.19 5 29.854.15 164232.0 $ 84.390.19 55.865 1.51061 FYTD Totals 62,875 1.71368 $ 103,537.34 S 3.867.28 $ 107,404.82 Projections Delivered Delivered Delivered Cost Total EOM Tank EOM Tank Projected Month CGS Cost Gallons Cost of Inventory Gallons Gallons Cost WACOG Jan -22 37,043 $ 54,556.00 1.47 Feb -22 $ 1.60 36,000 $ 57,600.00 $ 112,156.00 73,043 37,043 $ 56,878.75 1.54 Mar -22 $ 1.60 48,000 $ 76,800.00 $ 133,678.75 85,043 37,043 $ 58,227.74 1.57 Apr -22 $ 1.55 36,000 $ 55,800.00 $ 114,027.74 73,043 37,043 $ 57,827.99 1.56 May -22 $ 1.50 27,000 $ 40,500.00 $ 98,327.99 64,043 37,043 $ 56,873.72 1.54 Jun -22 $ 1.45 18,000 $ 26,100.00 $ 82,973.72 55,043 37,043 $ 55,839.90 1.51 Jul -22 $ 1.45 18,000 $ 26,100.00 $ 81,939.90 55,043 37,043 $ 55,144.15 1.49 Aug -22 $ 1.45 18,000 $ 26,100.00 $ 81,244.15 55,043 37,043 $ 54,675.93 1.48 Sep -22 $ 1.40 27,000 $ 37,800.00 $ 92,475.93 64,043 37,043 $ 53,488.84 1.44 Oct -22 $ 1.40 27,000 $ 37,800.00 $ 91,288.84 64,043 37,043 $ 52,802.22 1.43 Nov -22 $ 1.40 27,000 $ 37,800.00 $ 90,602.22 64,043 37,043 $ 52,405.07 1.41 Dec -22 $ 1.40 36,000 $ 50,400.00 $ 102,805.07 73,043 37,043 $ 52,136.53 1.41 Jan -23 $ 1.40 48,000 $ 67,200.00 $ 119,336.53 85,043 37,043 $ 51,980.56 1.40 CSW: 2/18/2022 Applicable Annual Therm Range or Other Rate Deterinant Monthly Customer Charge (For Central Pasco Territory) Non -Fuel Enerav Charae/Thenn Non -Fuel Energy Charge Energy Conservation Adj. (ECA) Regulatory Imposition Adj. (RIA) Usage & Inflation Adj. (UTA) Total Non -Fuel Energy Charge Purchased Gas Adjustment (PGA) Total Energy Charge/Therm Minimum Monthly Bill (For Central Pasco Territory) CLEARWATER GAS SYSTEM NATURAL GAS RATE BILLING FACTORS FOR MARCH 1, 2022 - SEPTEMBER 30, 2022 BASED ON APPROVED GAS ADJUSTMENT FACTORS Finn Natural Gas Rate Schedules RSR. SMF MMF LMF SGS MGS LOS RAC GAC IAC SL SL wIM& NOV Reliaht (Non -Real) NA (1 - NA (4 + NA (4 + NA (4 + 0 - 18,000- 100,000 NA (1 - NA (0 - NA (150 NA NA NA 3 Units) Units) Units) Units) 17,999 99,999 & up 3 Units) 149 tons) tons & +) Interr. NG Rate _NO_ IS (Non -Rest) NA 100,000 & up $$,00' 325.00 340.00 395.00 325.00 340.00 $95.00 Rate Rate Rate $20.00 320.00 By Contract $50.00 $250.00 4,00 (340.00) (370.00) (3160.00) ($40.00) ($70.00) ($160.00) Suspended Suspended Suspended (330.00) ($30.00) (By Contract) ($75.00) ($400.00) Reserved for Reserved for Reserved for Future Use Future Use Future Use $0.44 $0.44 $0.44 $0.44 $0.38 $0.34 $0.30 NA NA NA $0.20 $0.35 By Contract $0.38 1.13 0,13 0.13 0,13 0.13 0.13 0.13 NA NA NA NA NA NA NA 0.01 0.01 0.01 0.01 0.01 0.01 0.01 NA NA NA NA NA NA NA $0.24 NA NA Q Q1 -0.01 $L :,Qi 9,05 0.05 QQ NA NA NA Ng N3 Nom/ (yg A3 30.57 $0.57 $0.57 $0.57 $0.57 $0.53 $0.49 NA NA NA $0.20 $0.35 By Contract $0.38 $0.24 011 010 011 9.11 0,11 013 4d51' NA jyA NA am By Contract Q M Q24. Attachment *4 Contract NG Rate NA By Contract (By Contract) By Contract NA NA By Contract 0 1.40 1.40 1.40 1.40 1.40 1.36 1.32 NA NA NA 1.03 1.18 By Contract 1.21 0.98 0.74 + Non -Fuel 316.00 $25.00 $40.00 395.00 325.00 $40.00 $95.00 NA NA NA 320.00 $20.00 By Contract $50.00 3250.00 Customer (324.00) (340.00) (370.00) (3160.00) ($40.00) ($70.00) ($160.00) ($30.00) ($30.00) (By Contract) ($75.00) ($400.00) Charge + + 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.28 $ 1.28 $ 1.28 $ 1.28 $ 1.28 $ 1.24 $ 1.21 with 8.0% Franchise $ 1.38 $ 1.36 $ 1.36 $ 1.36 $ 1.38 $ 1.32 $ 1.28 Utility Tax Note: Fuel Rate per Ther 10/01/1973 30.069 $0.069 $0.069 $0.069 $0.069 30.089 30.069 Non -Utility Taxable Fuel/Ther $0.781 30.781 $0.761 $0.761 $0.761 $0.781 $0.781 BTU FACTOR • THERMS/100 CUBIC FEET ICCF) 10/2021 11/2021 1212021 Firm Service Rates 1.045 1.046 1.046 Interruptible Service Rates 1.025 1.025 1.025 01/202Z 1.044 1.024 02/2022 1.045 1.024 NA NA NA NA NA NA NA NA NA $ 0.94 $ 1.08 NA $ 1.00 $ 1.14 NA 30.069 30.069 NA 30.761 $0.761 03/2022 04/2022 05/2022 06/2022 07/2022 08/2022 09/2022 1.045 1.024 NA $ 1.11 $ 0.90 NA $ 1.17 $ 0.95 30.069 30.069 $0.055 (30.069) $0.761 $0.685 FY 21122 Ave. 1.045 1.025 30.069 30.671 CSW: 2/18/2022 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 Enerav Charaes/Galion: Non -Fuel Energy Charge (NFE)/Gallon Energy Conservation Adj.(ECA)/Gallon Regulatory Imposition Adj.(RIA)/Gallon Usage & Inflation Adj. (UTA)/Gallon Total Non -Fuel Charges (NF)IGaI. 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 FuelGallon RESIDENTIAL MULTI -FAMILY MRLP MMLP CLEARWATER GAS SYSTEM METERED PROPANE (LP) RATE BILLING FACTORS FOR MARCH 1, 2022 - SEPTEMBER 30, 2022 BASED ON APPROVED GAS ADJUSTMENT FACTORS LOOP RESL. LRLP NA NA NA (1 - 3 Units) (4 + Units) $16.00 $25.00 $16.00 For Each Meter SMALL COML. LARGE COML. MGLP MLLP 0-2,500 $25.00 $1.90 $1.90 $0.90 $0.30 0.13 0.13 0.13 0.13 0.01 0.01 0.01 0.01 -0 01 -0.01 -0.01 0.05 $2.03 $2.03 $1.03 $0.49 2.25 2.25 2.25 Z $4.28 $4.28 $3.28 $2.74 $16.00 $25.00 $16.00 $25.00 0.161 0.161 0.161 0.161 $2.089 $2.089 $2.089 $2.089 >2,501 $40.00 $0.25 0.13 0.01 0.05 $0.44 2,25 $2.69 $40.00 VEHICLE LPV (Non -Rest. Only) NA $40.00 Set By Contract NA NA NA Set By Contract Set By Contracts Contract NFE + Contract PGA Customer Charge Any Applicable Customer Charge + Any Applicable Facility Charges 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 2.25 $3.25 $50.00 0.161 0.161 0.161 $2.089 Contract PGA - 0.161 $2.089 Set By Contract NA NA NA Set By Contract 1.95 Contract NFE + $1.950 Customer Charge + Non -Fuel Energy Chg. for the Contracted # of Gallons/Mo. 0.161 Contract PGA - 0.161 CSW: 2/18/2022 Attachment #C Page 2of2 BTU Factor: x.714 Gallons/100 cubic feet (CCF) CLEARWATER GAS SYSTEM BTU Factor: 2.483 Therms/100 cubic feet (CCF) BULK PROPANE (LP) RATE BILLING FACTORS Therm Factor: 0 915 Therms/Gallon FOR MARCH 1, 2022 -SEPTEMBER 30, 2022 BASED ON APPROVED GAS ADJUSTMENT FACTORS STANDARD RESIDENTIAL BULK LP SERVICE RESIDENTIAL 'WILL CALL" COMMERCIAL BULK LP SERVICE BULK STANDBY/ (Rate Class Is Based on Annual LP Gallon Usage Level) (Based on Annual Usage Levet) (Based on Annual Usage Level) GENERATOR SEM 118121 13RLP2 HELM BRLP4 WRLPO WRLP1 WRLP2 WRLP3 WRLP4 BCLP1 j3CLP2 LPSB (Closed for Applicable Annual Gallon Range 0 (No Fibs In Yr.) 0.1 - 60 60.1 - 120 120.1 - 300 > 300 0 (No Flls In Yr.) 0.1 - 60 60.1- 120 120.1 - 300 > 300 0 - 2,500 > 2,500 New Residental or Other Rate Determinant 1-3 UNITS 1-3 UNITS 1-3 UNITS 1-3 UNITS 1-3 UNITS 1-3 UNfTS 1-3 UNITS 1-3 UNITS 1-3 UNITS 1-3 UNITS Customers in this Customers In this Applications) Range of Usage Range of Usage Annual Customer Charge $ 395.00 $ 27000 $ 225.00 $ 136.00 $ 120.00 $ 396.00 $ 266.00 $ 196.00 $ 120.00 $ 106.00 $ 90.00 $ 90.00 $ 420.00 Non -Fuel Cherries (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 Energy Conservation Adj. (ECAyGeI $ 0.13 $ 013 $ 0.13 013 0.13 0.13 0.13 0.13 0.13 0.13 0.13 0.13 NA Regulatory Imposition Adj. (RIAyOal. $ 0.01 $ 0.01 $ 0.01 0.01 0.01 0.01 0.01 0.01 0.01 0.01 0.01 0.01 NA Usage & Inflation Adj. (UTAyGdlon (0.01) (0.01) (0.01) (0.01) (0.01) (0.01) (0.01) (0.01) (0.01) (0.01) 0.05 0.05 NA Total Non -Fuel Charges (NF)/GaL $ 1.93 $ 1.93 $ 1.73 $ 1.13 3 1.03 $ 1.93 3 1.93 $ 1.73 $ 1.03 $ 0.93 $ 0.44 $0.39 $ 1.00 Purchased Gas Adj. (PGAWGdlon $ 225 $ 2.25 $ 2.25 $ 2.25 $ 2.25 $ 2.25 $ 2.25 $ 2.25 $ 2.25 $ 2.25 $ 2.25 $ 2.25 $ 2.25 Total Energy Charges/O'5°n $ 4.18 $ 4.18 3 3.99 $ 3.38 $ 3.28 $ 4.18 $ 4.18 $ 3.98 $ 3.28 $ 3.18 $ 2.89 $ 2.64 $ 3.25 Note: No Monthly Minimum BB Utility Tax Note: Fuel Rate per Gallon 10/01/1973 $ 0.161 $ 0.161 $ 0.161 $ 0.161 $ 0.161 $ 0.161 $ 0.161 $ 0.161 $ 0.161 $ 0.161 $ 0.161 $ 0.161 $ Non-UtietyTaxable Fuel/Gallon $ 2089 $ 2.089 $ 2.089 $ 2089 $ 2.089 $ 2.089 $ 2089 $ 2.089 $ 2089 $ 2.089 $ 2.089 $ 2.089 $ CONTRACT BULK j,P SERVICE Any Contract Customers Who Requests Bu9c Del. Set by contract Set By Contract NA NA !9A Set By Contract Cotract NFE + 1.950 0.161 $ 0.161 2.089 Contract PGA - 0.161 CSW y'8/2022 Attachment #6 Page 1 of9 Residential Rate History By Components Clearwater Gas System Tota Rate Adjustments/Therm Contract LE Month NG/therm LP/aalion * ECA RIA# WNA UTA-Rest# UTA-Com/# PGA PGGi PGA/aallon, Oct-20 Nov-20 $ 1.44 $ 1.38 $ 2.75 $ 2.70 $ 0.20 $ 0.18 $ - $ 0.09 $ 0.08 $ - $ 0.07 $ 0.13 $ 0.71 $ 0.69 $ 0.61 $ 1.46 $ 0.59 $ 1.45 Dec-20 Jan-21 $ 1.38 $ 1.32 $ 2.70 $ 2.64 $ 0.18 $ 0.18 $ - $ 0.07 $ 0.13 $ - $ 0.07 $ 0.13 $ 0.69 $ 0.63 $ 0.59 $ 1.45 $ 0.53 $ 1.39 Feb-21 Mar-21 $ 1.32 $ 1.32 $ 2.64 $ 2.64 $ 0.18 $ 0.18 $ - $ 0.07 $ 0.13 $ - $ 0.07 $ 0.13 $ 0.63 $ 0.63 $ 0.53 $ 1.39 $ 0.53 $ 1.39 Apr-21 May-21 $ 1.32 $ 1.32 $ 2.64 $ 2.64 $ 0.18 $ 0.18 $ - $ 0.07 $ 0.13 $ - $ 0.07 $ 0.13 $ 0.63 $ 0.63 $ 0.53 $ 1.39 $ 0.53 $ 1.39 Jun-21 Jul-21 $ 1.32 $ 1.25 $ 2.64 $ 2.77 $ 0.18 $ 0.18 $ - $ 0.07 $ 0.13 $ - $ - $ 0.13 $ 0.63 $ 0.63 $ 0.53 $ 1.39 $ 0.53 $ 1.59 Aug-21 Sep-21 $ 1.25 $ 1.25 $ 2.77 k $ 2.77 $ 0.18 $ 0.18 $ - $ - $ 0.13 $ - $ - $ 0.13 $ 0.63 $ 0.63 $ 0.53 $ 1.59 $ 0.53 $ 1.59 FYTD 20/21 Av $ 1.323 $ 2.692 $ 0.182 $ - $ 0.054 $ 0.126 $ 0.647 $ 0.547 $ 1.456 2020 Avg. $ 1.603 $ 2.$50 ' $ 0.221 $ - $ 0.082 $ 0.085 $ 0.760 $ 0.660 $ 1.648 Oct-21 $ 1.40 $ 3.22 $ 0.20 $ 0.03 $ - $ 0.13 $ 0.73 $ 0.64 $ 1.99 Nov-21 Dec-21 $ 1.40 $ 1.37 $ 3.22 $ 3.42 $ 0.20 $ 0.17 $ 0.03 $ - $ 0.13 $ 0.01 $ (0.01) $ 0.05 $ 0.73 $ 0.76 $ 0.64 $ 1.99 $ 0.67 $ 2.25 Jan-22 Feb-22 $ 1.37 $ 1.37 $ 3.42 $ 3.42 $ 0.17 $ 0.17 $ 0.01 $ (0.01) $ 0.05 $ 0.01 $ (0.01) $ 0.05 $ 0.76 $ 0.76 $ 0.67 $ 2.25 $ 0.67 $ 225 Mar-22 Apr-22 $ 1.40 $ 3.38 $ 0.13 $ 0.01 $ (0.01) $ 0.05 $ 0.83 $ 0.74 $ 2.25 May-22 Jun-22 Jul-22 Aug-22 Sep-22 FYTD 21/22 Av $ 1.385 ' $ 3.347 $ 0.173 $ 0.017 $ (0.007) $ 0.077 $ 0.762 $ 0.672 $ 2.163 2021 Avg. $ 1.320 $ 2.834 $ 0.183 $ 0.006 $ 0.034 $ 0.123 $ 0.65$ $ 0.660 $ 1.612 Incr. Above Last Year $ 0.08 $ 0.74 $ (0.05) $ 0.01 $ (0.08) $ (0.08) $ 0.20 S 0.21 $ 0.86 Same Month 6% 28% -28% NA -114% 42% 32% 40% 62% Incr. Based on 40 Therms $ 3.20 6% $ 32.35 28% Equivalent Cents/KWH for Gas 4.8 12.6 vs. Duke Rate 14.7 14.7 Note: Duke Energy Florida's residential rate for usage >1,000 KWH in March 2022 is 14.727 cents/KWH. (Residential) Gas Cheaper by -68% -14% Notes: * Based on Bulk LP (BRLP3) which is applicable for customers using 120.1 - 300 gallons/year & equal to Residential LP Will Call (BRWCLP). csW:9127t2021 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 $ 0.084! Electric -46% September 2001 $ 1.34 $ 0.046 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% September 2019 $ 1.65 $ 0.056 $ 0.142 -61% September 2020 $ 1.44 $ 0.049 $ 0.140 -65% September 2021 $ 1.25 $ 0.041 $ 0.140 -71% $ Increase over Last 21 Years $ (0.09) $ (0.005) $ 0.06 % Increase over Last 21 Years -6.7% -10.1% 67.1% Avg. Annual Inc. Over Last 21 Yrs. -0.3% -0.5% 3.2% CSW:11/17/2021 Attachment #6 Page 3of3 Annual Average CGS Residential Rates Calender Year_ Fiscal Year . Year NG/Therm LP/Gallon * Year NG/Therm LP/Gallon * 1995 NA NA FY 95/96 $ 0.880 $ 1.199 * 1996 $ 0.915 $ 1.239 * FY 96/97 $ 1.019 $ 1.370 * 1997 $ 1.049 $ 1.380 * 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 FY 18/19 $ 1.610 $ 3.210 2019 $ 1.623 $ 3.155 FY 19/20 $ 1.565 $ 2.938 2020 $ 1.503 $ 2.850 FY 20/21 $ 1.323 $ 2.692 2021 $ 1.320 $ 2.834 Average $ 1.505 $ 2.486 $ 1.500 $ 2.434 Notes: * Based on the Residential Metered Propane schedule which was closed for new customers effective March 8, 1999. For 1999 & FY 99/00 and beyond based on Bulk LP (BRLP3) which is applicable for customers using 120.1 - 300 gallons/year & is equal to Residential LP Will Call as;awake' a Greener II "Gas ANNUAL ENERGY USAGE AND COST ANALYSIS AT T4ciFOISAIrt7 March 2022 Natural Gas Natural Propane Electric Savings Savings Appliance Type Therms Gas (LP) Gas Cost Natural Gas Propane Electric Usage Kwh COOKING 35 $ 49.00 $ 129.29 $ 116.17 $ 67.17 $ (13.12) 789 WATER HEATING (Tankless) 100 $ 140.00 $ 369.40 $ 353.83 $ 213.83 $ (15.57) 2,403 WATER HEATING (Tank) 150 $ 210.00 $ 554.10 $ 443.22 $ 233.22 $ (110.88) 3,010 CLOTHES DRYING 50 $ 70.00 $ 184.70 $ 189.86 $ 119.86 $ 5.16 1,289 TOTAL (TANKLESS water heater) $ 259.00 $ 683.39 $ 659.86 $ 400.86 $ (23.53) TOTAL (TANK water heater) $ 329.00 $ 868.09 $ 749.25 $ 420.25 $ (118.83) CGS Customer charge $ (168.00) $ (115.00) Net Savings (Tankless Gas & Electric) $ 232.86 $ (138.53) 35% -21% Net Savings (Tankless Gas vs. Tank Electric) $ 322.25 $ (49.13) 43% -7% Furnace & Outside Recreation HOME HEATING POOL HEATING** SPA/HOT TUB HEAT** 130 $ 182.00 $ 480.22 $ 195.73 250 $ 350.00 $ 923.50 $ 221.14 125 $ 175.00 $ 461.75 $ 110.57 Water heater is based on 100 therms (gas tankless) and 3,500kwh (electric tank) ** Varies according to pool size, weather conditions, and temperature maintained. All other figures are annual average projections based upon the following: 1. 1 Thenn =100,000 BTUs of energy 2. Natural Gas Rate 3. LP Gas per gallon (Bulk Bill level 3 or WiII Call) 4. Duke Energy Rate (per kwh) $ 1.40 $ 3.38 0.14727 per Therm per Gallon per KWH or $ 3.69 per Therm Equivalent or $ 4.31 per Therm Equivalent Costs based on February 2022 energy charges. Current monthly customer charges are: Duke - $12.45; Peoples Gas - $30-82; Clearwater Gas - $16 (natural gas only) and $24 in Central Pasco. L.P. customers are billed annually - $95 to $230 (non-refundable depending on program).