Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
GAS ADJUSTMENTS EFFECTIVE JUNE 1, 2022
CLEARWATER GAS SYSTEM Interoffice Correspondence Sheet RECEIVED JUN 012022 OFF C!AI. RECORDS AND TO: Mr. Jon Jennings, City Manager LEGISLATIVE SRVCS DEPT. FROM: Chuck Warrington, Executive Director COPIES: Rosemarie Call, City Clerk; CGS & UCS Management Teams; UCS Billing Team; Micah Maxwell, Assistant City Manager SUBJECT: GAS ADJUSTMENTS EFFECTIVE JUNE 1, 2022 DATE: May 26, 2022 Natural Gas supply prices have been rising steadily this Winter/Spring; therefore, we are recommending an 8¢/therm increase in our Natural Gas Purchase Gas Adjustments (PGA) in June. Propane supply prices have actually dropped somewhat; therefore, we are recommending a 25¢/gallon decrease at this time for our Propane (LP) PGA for June. We recommend that we continue our Contract LP PGA at 30¢ below our standard LP PGA. We are not recommending any changes in our Energy Conservation Adjustment (ECA), our Usage & Inflation Adjustments, nor our Regulatory Imposition Adjustment (RIA) for June. Therefore, the net effect of these recommended changes for June is an 8¢ per therm increase (+5.3%) in our typical Residential Natural Gas customer's therm rate and a 25¢ per gallon decrease (-7.4%) 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 June 1, 2022: 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) Usage & Inflation Adjustment (UTA) - Residential - Commercial $1.03 per therm (up 8¢) $0.94 per therm (up 8¢) $2.00 per gallon (down 25¢) $1.70 per gallon (down 25¢) $0.13 per therm or gallon (no change) $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 May 26, 2022 Page 2 Attachment #1 shows the status of our Adjustment Recovery Clause balances with actuals thru April 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 63% lower than electric for Natural Gas and 21% 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 30% 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, we are recommending a 67¢ per gasoline gallon equivalent (GGE) increase in our Natural Gas Vehicle (NGV) Fueling Station pump price to $2.19/GGE --- still 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 recommended to be $2.01/GGE, as these fleets pay no Federal taxes on fuel --- an even more remarkable price. You can see the breakdown of this charge on Attachment #8. One of the reasons for this low rate is that Congress passed the Tax Extender package thru 2021 which provided 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 June 1st billings. If you have any questions on this, please call me. CSW/cw Attachments •r Approved: J(/..- •' `e — Jon Jennings, City Manager U:\My Documents\WORD\GASRATES\FY 21-22\Gas Adjustments for June 1, 2022.docx CLEARWATER GAS SYSTEM SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTIOya AH - NATURAL GAS • UR HASED G._ ; ' • ME P ' -NG Monthly Cumulative NG PGA Budget Reservation Commodity Personal Interfund Prior YEAR Interest Cost Center Total NG Fuel Total NG PGA Overage YTD Overage Rate/Therm - Month Charges Charges Services Svc she • Dividend OSter Write off Ex • nee • nses Ex • naes Billed Shortage) (Shortage) Firm/CoMr Therms Billed Rec/Therm Prior Year - $ (125,461.12) Oct -21 $ 135,111.47 1,097,913.43 $ 31,869.35 $ 123,163.33 $ $ 5,976.81 9,559.39 5 313.85 $ 170,568.88 $ 1,403,907.43 $ 1,260,249.86 $ (143,657.57) $ (269,118.69) 0.73/0.64 1,950,000. 0 65 Nov -21 $ 225,434.85 1,460,071.57 $ 22,971.06 $ 123,163.33 $ - $ 15 781.23 5 - 5 672.80 $ 181 915.82 5 1,849,094.84 1,347,738.67 $ 501,356.17 $ (770,474.88)1 0.73/0.64 2,080,000 0.65 Dee -21 $ 231,062.53 ' 1,051,408.67 $ 25,015.61 $ 123,163.33 $ - $ 8,216.11 $ 5 1,926.19 $ 156,395.05 $ 1 440,792.44 1,670,948.17 $ 230,155.73 $ (540,319.131 0.7600.67 2,440,000 0.68 Jan -22 $ 235,885.21 2,069055.81 $ 22,987.92 $ 123,163.33 $ 525,000.00 $ 18,314.01 $ - $ 1,350.80 $ 687465.26 $ 2,993757.08 1 730 138.38 $ 1,263618.72 $ 1,803937.841 0.7610.67 2,516,981 0.68 Feb -22 $ 212,380.00 1,356,235.10 $ 23116.87 $ 123 163.33 $ 862420.00 $ 8139.30 $ $ 4,509.84 5 5,534.15 $ 1,016,839.50 $ 665269.79 $ (2,469,207.64)1 0.76/0.67 1 2,799,025 0.68 Mar -22 $ 223,374.41 1,237,267.94 $ 26,015.00 $ - ] $ - 1889,024.43 $ 255547.10 $ 2,213,660.54) 0.9310,74 2,497,837 0.75 Apr -22 $ 37,387.30 887,875.07 $ 25,301.30 $ 123,163.33 $ $ 20,827.65 $ - $ 169,292.28 $ 1,100,088.80 1,846,563.80 $ 748,475.00 5 (1,467,185.54)j 0.83/0.74 r 2,464,188 0.75 Me -22 $ 114,20000 ' 1,365,000.00 $ 25000.00 $ 125,000.00 $ - $ 10,000.00 $ - $ 3,667.96 $ 160,000.00 $ 1,642,867.96 1,931 400.00 $ 288,532.04 5 1,178,653.50 0.188.68 2,220,000 0.87 Jun -22 $ 91300.00 1,360,000.00 $ 25,000.00 $ 125,000.00 $ $ 10,000.00 $ - $ 2,946.63 $ 160,000.00 2,023,500.00 $ 409,253.37 $ 769,400.14) 1.0000.94 2,130,000 0.95 Jul -22 $ 94,400.00 1,355,000.00 $ 25,000.00 $ 125,000.00 $ $ 10,000.00 $ - $ 1,923.50 $ 160,000.00 S 1,611,323.50 1,957,000.00 $ 345,676.50 $ (423,723.64) 1.03/0.94 2,060,000 0.95 Aug -22 $ 94,400 00 1,460,000.00 S 25,000.00 $ 125,000.00 $ - $ 10,000.00 $ • $ 1,059.31 $ 160,000.00 $ 1,715,459.31 1,957,000.00 $ 241,540.69 $ 182,182.95 1.03/0.94 2,060,000 0.95 S p 22 $ 89.300 00 1,535,000.00 $ 25,000.00 $ 125,000.00 $ - $ 10,000.00 $ • $ 455.46 $ 180,000.00 1,976,000.00 $ 191,244 54 $ 9,061 60 1.03/0.94 2,080.000 'i` 0.95 Total YTO 5 1,785,235.77 $ 16,234,827.59 $ 302,277.11 $ 1,487,143.31 $ 1,387,420.00 $ 142,738.74 $ 9,559.39 $ 30,533.31 $ 3,329,138.55 $ 21,379,735.22 $ 21,514,257.94 $ 134,522 72 Budget Gallons - 111011='.1=III-111M70111111111ESZ31111111 Prior YEAR ✓^ Monthly Cumulative -LPTYGA- Interest Commod Center Total LP Fuel Total LP PGA Overage YTD Overage Therm/Gal. Month Sold WACOG Svc cha • e Dividend Fuel Eva • • risation Software Write off Ex • - nae Cha • $ Ex • *as Ex • rises Billed (Shortage) (Shortage) Prior Year -- $ (74,717.16) $ 135.25 $ 186.79 45,614.43 5,513.00 $ 51314.22 $ 55,584.40 $ 4,270.18 $ (70,446.981E82/1.99 Oct -21 I 29,289.1 $ 1.55845 $ 5,273.33 $ - $ $ 104.42 5 - Nov -21 36,892.3 $ 1.57136 $ 5,273.33 $ - $ 882.03 $ 8 $ - $ 176.12 57,971.06 6,155.36 $ 64,302.56 713 183.46 $ 8,880.90 $ (61,566.08) 1.82/1.99 Dec -21 34,460.5 $ 1.47593 $ 5 273.33 $ - $ 126.80 $ 44.28 $ - $ - $ 153.92 50 881.29 5,444.41 $ 56,459.61 76,098.66 $ 19,639.05 $ (41,927.03) 2.06/2.25 Jan -22 44,042.7 $ 1.47224 ®® $ - $ 8 - $ - $ 104.82 1111111111313 5 295.41 $ 70 241.65 99,019.09 $ 28,777.44 $ (13,149.60)' 2,06/2.25 $ - $ 32.87 $ 120 968.78 82,602.44 $ (38,368.34) $ (51,515.93) 2.06/2.25 Feb -22 36,623.5 $ 1.57821 $ 5,273.33 $ 57,863.00 $ - $ - $ - Mar -22 51,518.1 $ 1.67506 $ 5,273.33 $ - $ 839.15 $ 33.50 $ - $ - $ 128.79 86,295.91 5,945.98 $ 92,370.68 115,665.49 S 23,294.81 $ (28,221.12) 2.06/2.25 Apr -22 38,107.4 S 1.58014 $ 5,273.33 5 - $ 640.20 $ 151.69 5 - $ - $ 70.55 60,215.03 8,065.22 $ 66,350.80 85,716.87 $ 19,366.07 $ (8,855.0) 2.06/2.25 May -22 27,000.0 $ 1.59000 $ 5,300.00 $ - S 400.00 $ 50.00 $ 5,000.00 $ - $ 22.14 42,930.00 10,750.00 $ 53,702.14 60,750.00 $ 7,047.86 $ (1,80719) 2.06/2 25 Jun -22 18,000.0 5 1.60000 $ 5,300.00 $ - $ 400.00 $ 50.00 5• $ - $ 4.52 28,800.00 5,750.00 $ 34,554.52 36,000.00 $ 1,445.48 $ (361 71) 1.83/2.00 Jul -22 18,000.0 $ 1.60000 S 5,300.00 5 - $ 400.00 S 50.00 $ S - $ 0.90 28,800.00 5,750.00 $ 34,550.90 36,000.00 5 1,449 10 $ 1,087 39 1 83/2.00 Aug -22 27,000 .0 $ 1.55000 $ 5,300.00 $ - $ 400.00 $ 50.00 S • $ S 2.72 41 850.00 5,750 00 $ 47,597.28 54,000.00 $ 6,402.72 $ 7,49011 1.63/2.00 Sep -22 27,000.0 $ 1.52000 $ 5,300.00 $ $ 400.00 $ 50.00 $ $ - S (18.73)1 41,040.00 5,750.00 $ 46,771.27 54,00000 $ 7,228.73 $ 14,718.83 1.83/2.00 P13 Total YTD $ 387,913.60 $ 1.56 $ 83,413.31 $ 57,863.00 $ 4,288.18 $ 605.97 $ 5,000.00 $ 135.25 $ 859.98 5 607,018.73 $ 131,305.71 $ 739,184.42 $ 828,620.41 $ 89,435.99 fi _ ENERGY CONSERVATION ADJUSTMENT (ECA), rt- � T + Budget H Month Personal Services Advertising Residential IL Builder ECA and Other Promotional Interfund Svc charge Dividend Other Operating Expenses SNEP Prior Year write off Interest Expense Total ECA Expenses t Monthly 1 Cumulative YTD Overage �� Overage Total ECA Billed (Shortage)_j (Shortage) t ECA NG/Therm LP/Gal. Prior Year - $ 30,665.77 L t Oct -21 $ 109,883.488 280.00 $ 50,625.00 $ 6,544.17 $ - $ 4,833.01 $ 9,933.48 S 3,153.86 $ 8.66 $ 185 176.32 5 229,321.78 $ 44,145.46_1 $ 74,811,23 0.20/0.20 Nov -21 $ 79,789.33 $ 11,169.00 $ 55,125.00 $ 6,544.17 $ - $ 3,848.76 $ 13,894.61 $ - $ - $ - $ $ ' 187.03 $ 170 163.84 248,137.38 $ 77,973.54 I 3 152,784.77 I 0.20/0.20 Dec -21 $ 82,885.37 $ 8,189.00 $ 96,675.00 $ 6,544.17 $ - $ 3,886.44 $ 44,825.44 $ 381.96 InillECEM3 274 928.92 $ 32,703.48 ' $ 185488.23 0.178.17 i-- Jan-22$ 73,545.63 S 9,598.00$ 72,650.00 $ 6,544.17 $ - $ 11,228.77 $ 26,426.02 $ 483.72 113110=11111111111131=1 $ 304,904.60 $ 97,280.36 327,647.36 $ 22,742.76 $ 282 768.60011 $ 305,511.36 0.17/0.17 I 0.17/0.17 f Feb -22 $ 75,386.74 $ 1,248.00 $ 39,450.00 $ 8,544.17 $ 143,877.00 $ 10,087.78 5 29,017.83 Mar -22 $ 70,176.46 $ 2,372.00 $ 235,350.00 $ 6,544.17 $ - $ 3,256.08 $ 18,298.38 $ - -] $ 335231.27 229479.38 $ 105751.89 $ 199759.46 0.138.13 11111111EarlINEEMEEIMMEMEM $ 110428.34 $ 89,331.12 0.13/0.13 � Apr -22 $ 73,154.89 5 469.00 $ 175,475.00 $ 6,544.17 $ $ 3,748.61 $ 65,678.00 $ - $ 223.33 1101111=1 222,000.00 $ 5,376.67 $ 83,954.45 0.13/0.13 May -22 $ 80,000.00 $ 9.000.00 $ 80,000.00 $ 6,600.00 5 - $ 7,000.00 $ 45,000.00 $ - Jun -22 $ 80,000.00 $ 9,000.00 $ 80,000.00 $ 6,600.00 $ $ 7,000.00 S 45000.00 S - $ (209.89) $ 227,390.11 213,000.00 $ (14390.11) $ 69,564.34 0.13/0.13 Jul -22 $ 80,000.00 $ 9,000.00 $ 80,000.00 5 6,800.00 $ $ 7,000.00 $ 45,000.00 $ - $ (173.91) $ 227,426.09 206,000.00 $ (21,426 09) $ 48,138.25 0.13/0.13 f- + Aug -22 $ 80,000.00 $ 9,000.00 $ 80,000.00 $ 6,600..00 $ $ 7,000.00 $ 45,00000 $ - $ 120.35 $ 227,479.65 206,000.00 $ (21,479.65) $ 26,658.59 0.13/0.13 • Sep -22 $ 80,000.00 5 9,000.00 $ 80,000.00 9 6,600.00 $ - $ 7,000.00 $ 45,000.00 $ - $ 66.85 $ 227,533.35 208,000.00 $ (19,533.35) $ 7,125.24 0.13/013 Total YTD $ 964,801.90 $ 78,323.00 S 1,125,350.00 $ 78,809.19 S 143,877.00 S 75,687.43 $ 432,871 72 S 3.153.86 S (3,873.59) 5 2,899,000.51 S 2,875,459.98 S (23,540.53) 4 REGULATORY IMPOSITION ADJUST ENT (RIA - T- (EIA) (EIA) (EIA) ORA ORA (ORAS Interest Expense Total RIA Expenses Total RIA Billed Overage YTD Overage (Shortage) (Shortage)` NG/Therm LP/Gal. t Interfund Svc Budget charge Dividend Insurance Prior Year write off Personal Sve OIMr Regulatory Month Expenses Expenses - $ - • $ 30,376.86 + Prior Year Oct -21 $ 1,223.33 $ - $ - $ 973.83 $ 11,118.35 $ - 13,315.51 5 (75.95) $ 13,239.56 34,256.13 $ 21,018.57 $ 51,395.43 r 0.03/0.03 Nov -21 $ 1,223.33 $ - $ - $ - $ 8,054.28 $- 9,277.61 $ (128.49) $ 9,149.121 37,226.48 $ 28,077.36 $ 79,472.79 0.03/0.03 Dec-21 $ 1,223.33 $ - $ • $ - $ 8,125.23 $• 9,348.56 $ (198.68) 5 9,149.88 16,328.53 $ 7,176.65 -i--- $ 86,849.44: 0.018.01 Jan -22 $ 1,223.33 $ $• $ - $ 8,182.82 $ - 9,406.15 $ (216.62) 5 9,189.53 17,462.51 $ 8,272.985 94,922.42 0,01/0.01 ! I Feb -22 $ 1,223.33 I $ 110,840.00 ,$ - $ - $ 81,989.96_ $ - 120,253.29 $ (237.31) $ 120,015.98 19,266.80 $ (100,749.18) $ 15,826.76), 0.01/0.01 CLEARWATER GAS SYSTEM SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTION' Mar -22 $ 1,223.33 $ $ - $ •$ 8,189.97 $ - 9,413.30 $ 14.57 $ 9,427.87 17,628.08 $ 8,200.21 $ 2,373.45 0.01/0.01 Apr -22 $ 1,223.33 ... $ $ - $ 10,885.61 $ 12,109.94 $ (5.93) $ 12,104.01 16,476.78 $ 4,372.77 $ 6,746.22 0.01/0.01 May -22 $ 1,300.00 $ $ 5 5 15,000.00 $ 5,000.00 21,300.00 5 (16.87) $ 21,283.13 22,200.00 $ 916.87 $ 7,683.09 0.01/0.01_ - Jun -22 $ 1,300.00 $ $ - $ - $ 15,000.00 $ 5,000.00 21,300.00 $ (19.16) S 21,280.84 21,300.00 $ 19.16 $ 7,682.25 0.01/0.01 Jul -22 $ 1,300.00 $ - $ • $ $ 15,000.00 5 5,000.00 21,300.00 $ (19.21) $ 21,280.79 20,800.00 $ (680.79) $ 7,001.45 0.01/0.01 Aug -22 $ 1,300.00 $ - $ - 5 - $ 15,000.00 $ 5,000.00 21,300.00 $ (17.50) $ 21,282.50 20,600.00 $ (682.50) $ 6,318.96 $ 5,834.75 0.01/0.01 001/0.01 4- Sep -22 $ 1,300.00 $ S • $ •$ 15,000.00 $ 5,000.00 21,300.00 $ (15 80) $ 21,284.20 20,800.00 $ (484 20) P13 P13 Total YTD $ 15,063.31 $ 110,840.00 $ - $ 211,547.22 $ 25,000.00 S 289,624.36 $ (936.94) 288,687.42 264,143.31 $ (24,544.11) USAGE AND INFLATION ADJUSTMENT IUIAI Commercial Monthly Cumulative UTA Bud et ' Interest Overage YTD Overage NO/Therm Month LP Gallons Expense Rate/Gallon NG Therms Rate/TMrm (Shortage) (Shortage) LP/Gal $ - $ (1160.51325) 4 Beg. Bal. Oct -21 6,646.0 $ 3,402.57 0.13 821,469.80 0.13 104,201.98 5 (576,311.28) 0.13/0.13 Nov -21 6,902.2 $ 2,881.56 0.13 858,000.50 0.13 109,548.76 $ (488,764.52) 0.13/0.13 Dee -21 7,111.3 $ 2,333.82 0.05 1,071,048.40 0.05 51,900.15 $ (414,884.37) 0.06/0,06 Jan -22 Feb -22 6,490.3 8,731.3 $ 2 074.32 0.05 1,132,515.20 0.05 54 867.74 $ (359,998.83) 0.05/0.05 1 I ' $ 1,799.98 0.05 1,171,989.30 0.05 57,414.34 $ (302,582.29) 0.05/0.05 Mar -22 8,608.6 $ 1,512.91 0.05 1,130,801.80 0.05 55,452.16 $ (247,130.11) 0.05/0.05 Apr -22 7,707.9 $ 1,235.85 $ 965.53 0.05 0.05 1,097,440.40 1,000,000.00 0.05 0.05 54,023.93 49,434.47 $ (193,106.18) $ (143,671.71) 0.05/0.05 0.05/0.05 I 1 , May -22 8,000.0 Jun -22 7,500.0 $ 718.36 0.05 900,000.00 005 44,656.64 $ (99,015.07) 0.05/0.05 I L Jul -22 7,000.0 $ 495.08 0.05 900,000.00 0.05 44,854.92 $ (54,160.14) 0.05/0.05 Au -22 6.000.0 $ 270.80 0.05 850,000.00 0.05 42,529.20 $ (11,630.95)_ 0.05/0.05 l i Sep -22 6,500.0 $ 58.15 0.05 850,000.00 0.05 42,768.85 $ 31,135.90 0.05/0.05 Per 13 I Total YTD --....... (1). USAGE AND 85,197.8 Pr Calculation of INFLATION ADJMENT 17,748.73 11,783,245.40 $ 711,649.16 ! UAttachment •77 FY21 due b be oaleoled n 5612,740,24 & FY21 ended the year owt(undet) cok olt of $(07,773,112) r (U AIMr Monthly Cumulative UTA -I , -1--- Residential Budget 1 Interest Overige YTD Overage NG/Therm Month LP Gallons Expense Rate/Gallon NG Therms Rate/Therm (Shortage) , (Shortage) LP/Gal f Beg. Bal. $ • 1 88.804.21 $ (283.42) - 297,240.70 - $ 276.03 ' $ 56,962.24 0.00/0.00 ' -, Oct -21 22,609.8 $ (284.81) $ (286.19) - (0.01) 345,937.50 510,883.80 • (0.01) $ 274.78 5 (5,086.41) $ 57,237.02 $ 52,150.61 0.00/0.00 -0.01/-0.01 t Nov -21 29,984.7 _L -1- . Dee-21 Dee -21 27,338.4 Jan -22 37,541.6 $ (280.75) (0.01) 569,410.90 (0.01) (5,834.38) $ 48 316.23 •0.01/-0.01 i t Feb -22 29,878.7 $ (231.58) $ (195.25) (0.01) (0.01) 718,553.80 578,913.80 (0.01) (0.01) (7,285.52) (6,034.10) 5 39,050.71 5 33,018.61 -0.01/-0.01 -0.01/-0.01 Mar -22 42,901.2 Apr -22 30,383.3 $ (165.08) $ (138.79) $ (117.98) (0.01) (0.01) (0.01) 511,581.10 400,000.00 350,000.00 (0.01) (0.01) (0.01) (5,25902) (4,181,21) (3,582.02) $ 27,757.59 $ 23,596.38 $ 20,014.36 -0.01/-0.01 -0.01/-0.01 -0.01/-0.01 May -22 Jun -22 30,000 .0 20,000.0 +L -�-- Jul -22 I 20,000.0 3 (10007) (001) 300,000.00 (0.01) (3,099.93) $ 16,914.43 -0.01/-0.01 Aug -22.4 20,000.0 $ (84.57) (0.01) 300,000.00 (0.01) (3,115.43) $ 13,799.00 -0.01/-0.01 Sep -22 , 20,000.0 $ (69 00) (0.01) 300,000.00 (0.01) (3,131.00) 5 10,668.00 -001/-0.01 Per 13 1, Total YTD.i 330,637.5 (2,217.50) 5,182,301.60 $ (46,016.21) W1 Attachment 07 P121 due le be eelsoled a (527.192A4) a P121 ended the yarded' oved(under) oeledlon of $26,4$1.27 (1) Per Calculation o( TOTAL ALL COST RECOVERY ADJUSTMENT CLAUSES LBoth PGAs + ECA + RIA+U)) Budget Total All Total Recovery Billed - Monthly Overage (Shortage) $ - Cumulative YTD Overage (Shortage) $ (762,962.70) Total NGITH (Firm) NG/LP , Month Expenses Prior Year' - Oct -21 $ 1,653,637.53 $ 1,683,892.18 $ 30,254.65 $ (732,708.05) 0.96/2.22 Nov -21 $ 2,092,710.36 $ 1,816,107.53 $ (276,602.83) S (1,009,310.89) 0.96/2.22 $ (872,822.25) 0.931242 Dec -21 $ 1,748,625.38 $ 2,085,114.02 $ 336,488.64 $ (1,753,078.83) 0.93/2.42 $ (2,484,570.56) 0.93/2.42 '. Jan -22 $ 3,272,715.13 $ 2,192,460.55 $ 2,404,380.07 $ (1,080,254.58) $ (731,493.73) Feb -22 $ 3,135,853.80 $ (2,253,862.25) 0.01412$ I Mar -22 $ 2,070,507.15 $ 2,301,215.48 8 230,708.31 $ (1,545,311.84) 0.96/2.38 1 1 i Apr -22 $ 1,503,111.88 $ 2,211,862.29 $ 708,550.41 S (1,208,918.49) 5.$12 $8 May -22 $ 1,945.229.91 $ 2,281,623.28 $ 336 393.35 $ (771,515.97).--1.S1Q.IS, Jun -22 $ 1,897,472.11 $ 2,334,874.62 $ 437,402.52 $ (404,742.26) 1.16/2.13 ' Jul -22 3 1,894,581.29 $ 2,261,355.00 5 366,773.71 Aug -22 $ 2,011,818.74 $ 2,277,013.77 $ 285,195.03 $ (139,547.23) 1.18/2.13 Sep-22 Sep -22 5 2,080,344.29 $ 2,298,435.84 $ 218,091 55 $ 78,544.32 1.16/2.13 r -4--- rt f Per 13 Total YTD 25,306,607.57 26,148,114.59 $ 841,507.02 NG NFE TRACKING t y Actual Actual Actual Annual _ Budget Therms NFE YTD Total Strat Plan Amt Month -}-- Beg. Bal. R E S Oct -21 Nov -21 E Dee -21 Jan -22 R Feb -22 V Mar -22 Apr -22 A May -22 Jun -22 Jul -22 1 Aug -22 Sep -22 0 Tota C O Oct -21 Nov -21 M Dee -21 M Jan -22 Feb -22 O Mar -22 D Apr -22 May -22 1 Jun -22 T Jul -22 Aug -22 Sep -22 Tota COS Natural Gas Summary Monthly AetuallProjectlons (FY22) Volume FTS -1 $0.6332 Cost Cost FTS•2 50.6332 Volume Coat No-Notlee $0.0478 Volume Cost Capacity Relinquishment Volume Rate Cost Reservation Adjustments TOTAL RESERVATION COST Total Rate 170,438 $ 107,921.34 Cashout 41,786 $ 26,460.16 16,600 $ 848.30 (3,689) 1 0.0318 $ (117.36) 11.03 $ 135,111.47 $0.6031 306,570 $ 194,120.12 $ - 53,430 $ 33131.88 22,800 $ 1,226.50 (99,909) $ 0.0278 $ (2,791.88) 13633 $ 226,434.85 20.8013 316,789 $ 200,590.79 2.3314 55,211 $ 34,959.61 31,000 1 1,692.60 (100,230) 1$ 0.0624 $ (6,255.47) 175.00 $ 231,062.63 $0.7632 316,789 $ 200,590.79 $ 5.0791 55,211 $ 34,959.61 46,600 8 2,638.90 (19,579) 1 0.1139 $ (2,230.91) 1128.82 $ 235,885.21 80.3013 286,132 $ 181,178.78 $ 0.0683 $ 3,216.60 49,688 $ 31,876.42 42,000 $ 2,293.20 (34,292) $ 0.0789 $ (2,705.60) 837.20 $ 212,360.00 80.6179 316,789 $ 200,690.79 8 10,685.34 55,211 $ 34,959.61 31,000 $ 1,692.60 (77,147) 8 0.1816 $ (14,011.91) 1143.32 8 223,374.41 $0.6855 216,570 $ 137,132.12 176,889 83,430 8 33,631.88 22,600 8 1,2211.50 (21,633) 8 0.0912 8 (1,972.37) $(1322512„1113 5 37,387.30 80.1350 144212 $ 91315.04 $ (86,129.92) 41,788 $ 28,460.16 12,400 $ 592.72 (20,000) $ 0.2000 $ (4,000.00) 50.00 $ 114,387.92 50.6411 $ 13,095.00 $ - $ 4,162.00 $ 5,389.60 $ (85,576.20) 10.500 $ 501.90 (10.000) $ 0.2000 $ (2,000.00) 50.00 $ 91,201.90 $0.5053 $ 1,333,939.25 000% I " $ - $ 3,973.53 10,850 $ 518.63 (10,000) $ 0.2000 $ (2,000.00) 50.00 $ 94.308.63 50.5047 201.000 $ 6.6303 $ 1,332,686.00 • 0.00% $ 12,119.58 10,850 $ 518.63 (10.000) 3 0.2000 $ (2,000 00) 5000 $ 94,308 63 60 5047 a, .. .. $ 0.0500 $ 2,08940 - $ 6.5599 .. 10,500 6 501,90 (20,000) S 0.2000 $ (4,000.00) $0.00 $ 89,201.90 $0.5232 2,641,833 $ 1,605,724.93 41,788 570,393 $ 341,734.17 268,100 $ 14,154.38 (426,479) $ 12,184.58 (544,075.50) (5132,513.23) 81,785,024.75 50.5849 50.6078 .5991 50.0532 as of 5126/2022 Volume FTS -1 (Usage) Rate Cost Volume FTS -2 (Usage) Rate Coat Gas Supply (FOU & Interconnects) Volume Rate Cost Fuel% FGU Management fee $0.066 No Notice Usage GTI Payment $0.020 Cashout Prior Month Adjustment COMMODITY COST Fou. Peoples 163,712 $ 0.0583 $ 8,961.41 41,788 $ 0.0683 8 2,438.24 209,001 1 5.7013 $ 1,191,675.21 2.33% 8 11,607.00 $ - $ 3,910.00 $ 4,179.96 $ (31,260.93) $ 1,191,408.94 190,710 $ 0.0583 1 11,118.41 40,440 $ 0.0583 $ 2,367.65 253,093 8 5.8061 $ 1,489,234.90 2.3314 8 12,500.00 $ • $ 4,623.00 8 9,534.89 8 (33,667.34) 8 1,475,701.51 171,323 $ 0.0663 $ 9,988.14 56,211 $ 0.0563 $ 3,218.80 248,379 $ 5.0791 8 1,281,647.65 2.33% $ 14,861.00 $ $ 4,530.68 $ (5,049.84) $ (28,449.33) $ 1,260,667.10 220,207 $ 0.0583 $ 12,836.07 55,211 $ 0.0683 $ 3,216.60 298,977 $ 4.9048 $ 1,466,433.48 ' 2.33% 8 15,476.00 $ - $ 5,508.36 $ (2,809.39) $ (27,393.75) 8 1,473,221.57 183,282 $ 0.0553 8 10,685.34 49,868 $ 0.0583 6 2,907.30 252,399 $ 5.6865 $ 1,435,275.43 2.33% 8 13,690.00 $ - 5 4,683.00 $ (8,809.18) $ (181,568.40) $ 1,299,023.49 176,889 $ 0.0553 $ 10,417.57 65,211 $ 0.0583 $ 3,218.80 253,007 8 5.2197 $ 1,320,614.46 2.33% 8 13,965.00 $ $ 4,679.00 $ (14.32) $ (86,129.92) $ 1,266,772.59 155,670 $ 0.0563 $ 8,764.22 63,430 $ 0.0563 $ 3,008.11 222,413 8 6.0613 $ 1,348,101.73 2.12% $ 13,095.00 $ - $ 4,162.00 $ 5,389.60 $ (85,576.20) 8 1,288,964.64 156,888 $ 0.0563 $ 8,832.82 41,788 $ 0.0500 $ 2,089.40 213,000 S 6.2626 $ 1,333,939.25 000% $ 12,913.97 $ - $ 3,973.53 $ - $ - $ 1,361,748.97 146,015 $ 0.0563 $ 8,22064 40,440 $ 0.0500 $ 2,022.00 201.000 $ 6.6303 $ 1,332,686.00 • 0.00% $ 12,119.58 $ - $ 3.729.10 $ - $ - $ 1,358,777.32 146.167 $ 00563 $ 8,229.20 41,788 $ 0.0500 $ 2,08940 202,000 $ 6.5599 $ 1,325,108.20 1 0.00% $ 12,217.08 $ - $ 3,759.10 $ - 6 - $ 1.351.40298 145.667 $ 0.0563 S 8,201.05 41,788 $ 0.0500 S 2,089.40 202,000 $ 7.0779 $ 1,429,728.20 0.00% $ 12,184.58 $ - $ 3.749.10 $ - $ - $ 1,455,952.33 154,515 $ 0.0563 $ 8,699.19 40,440 $ 0.0500 $ 2,022.00 210,000 $ 7.1716 $ 1,506,038.00 0.00% $ 12,872.08 $ - $ 3,899.10 $ - $ - $ 1,533,328.37 2,002,845 *,.11 ., ----- 9 $ 114,956.07 557,403 !/ !.412/2(antl $ 30,677.90 2,765,268 55.94 $ 16,420,280.56 6157,344.27 50.00 551,204.97 54,571.92 ($464,065.89) $16,314,969.80 Oct -21 Nov -21 Dee -21 Jan -22 Feb -22 Mar -22 Apr -22 May -22 Jun -22 Jul -22 Aug -22 Sep -22 TOTAL COST Resery R Comm RATE $ 1,326,520.41 $ 6.35 $ 1,702,136.36 $ 6.73 $ 1,491,729.63 $ 6.01 $ 1,709,108.78 $ 5.72 8 1,511,403.49 8 5.99 $ 1,490,147.00 8 5.89 $ 1,324,351.94 $ 5.95 $ 1.476.116.89 $ 6.93 $ 1,449,979.22 $ 7.21 $ 1,445,711.61 $ 7.16 $ 1,550,260.96 $ 7.67 $ 1,622,530.27 $ 773 $ 18,099,994.55 $ 6.55 Total Projected DTH WACOO Total Reservation Total Commodity Cost Purchased 1st 8Months $ 1,264,248.47 $ 7,966,795.20 $ 9,231,043.67 1,514,856 56.094 2nd8Months $ 520,776.28 $ 8,348,174.60 $ 8,888,950.88 1,250,413 57.093 TOTAL $ 1,785,024.75 $ 16,314,969.80 $ 18,099,994.55 2.765,268 66.545 $ 13,483,952.90 FOU Only $ 2,831,018.90 Interconnects Propane Weighted Average Cost of Gas (WACOG) LPWacog FY22 5/25/2022 Date Company Invoice Targa Shipping Gallons Delivered Propane Rate Propane Cost Shipping Cost Total Cost FYTD Gallons Cost of Inventory Tank Inventory Tank Withdraw! WACOG 09730/21 E.: ' • , a t. '�' r '''-22::::;7-.. L�'}«. ` '� Cf�lk-. _ . , ., r �,:,.:i: '' •.� ...-. q;,�,,;.. $ 58,366.80 43,864 1.35023 10/06/21 T= 21041434 8,787 1.83026 5 15,568.37 9 514.13 $ 16,082.50 8,787.0 $ 75,471.10 $ 91,385.62 52,771 61,502 1.43016 1.48590 10/07/21 Targa 21042091 8,731 1.82276 $ 15,403.67 $ 510.85 $ 15,914.52 17518.0 1020/21 Targa 21043630 17,594 1.80214 $ 30,677.35 $ 1,029.42 $ 31,706.77 35,112.0 $ 123,092.39 79,096 1.55624 10/3121 MONTHLY INVENTORY ADJUSTMENT 90 3.50289 $ 315.26 $ 315.26 35,202.0 $ 123,407.65 79,186 1.55845 10/3121 END OF MONTH •,' .- "=x a �'^..-� ^F. • .. , . .= -' s � s-��- #�'�- S 78,12$.75 48,647 30,339 1.55845 11/09/21 Targa 21046700 9,202 1.70190 $ 15,055.63 $ 605.23 $ 15,660.86 44,404.0 $ 91,786.61 58,049 1.58119 11/1721 Ta •a 21047618 18,361 322 1.52715 $ 26,832.32 $ 1,207.65 $ 28.039.97 62,765.0 $ 119,826.58 76,410 1.56821 11/30/21 MONTHLY INVENTORY ADJUSTMENT 2.32053 $ 747.21 $ 747.21 63,087.0 $ 120,573.79 76,732 35.362 41,370 1.57136 1.57136 11/30/21 OF MONTH �.r .�.�.ti �=_. . .;,_b,� „�._, a 'R.`t.. � ... -�. ,'"`-'._ ;:;.;P :'1yA; $ 88,866.52 !E�N1rDr 12/06/21 ITMME ai ' " 9,150 1.32953 8,944 1.32453 9,118 1.42828 9,102 1.44742 26 1.98154 $ 11556.45 $ 608.73 $ 12,165.18 72237.0 $ 67,731.70 44,512 1.52165 12/07/21 Ta • ®" ` $ 11,251.55 $ 595.03 $ 11,846.58 81,181.0 $ 79,578.28 53,456 1.48867 12/30/21 Ta ,a 22000405 $ 12,416.43 $ 606.61 $ 13,023.04 90,299.0 $ 92,601.32 62,574 1.47987 12/30/21 22000554 $ 12,394.65 $ 779.75 $ 13,174.40 99,401.0 $ 105,775.72 71,676 1.47575 12/31/21 MONTHLY INVENTORY ADJUSTMENT $ 51.52 $ 51.52 99,427.0 $ 105,827.24 71,702 1.47593 12/3121 END OF MONTH ' 1 .;_7r- :1: -,�.:, � . ° 1` ,?`', ^ -. '. +- - 4.,k'` `: ' $ 44,829.94 30,374 41,328 1.47593 01/04/22 T • 22000912 8,542 1.42127 1.43752 1.44127 $ 11,578.69 $ 561.83 $ 12,110.52 107,969.0 $ 56,970.48 38,916 1.46393 01/05/22 MI 22001539 9,141 $ 12539.17 $ 601.23 $ 13,140.40 117,110.0 $ 70,110.86 48,057 1.45891 01/11/22r��r1t�'�� 9,036 3 12,429.02 $ 594.31 $ 13,023.33 126,146.0 $ 83,134.19 57,093 1.45612 01/25/22at.9' :J� 22004446 18,616 1.47002 2.95588 $ 26,141.53 $ 1,224.40 $ 27,365.93 144,762.0 1 110,500.12 75,709 1.45954 01/31/22 MONTHLY INVENTORY ADJUSTMENT 648 $ 1,915.41 $ 1,915.41;�m 145,410.0 $ 112,415.53 76,357 1.47224 01/31/22 END OF MONTH ' r • • " : °` " $1 1k-:_._ ., 1 °, tia; {i ;�a'y,;:- $ 54,536.04 37,043 39,314 1.47224 02/07/22 T- •: 22006824 18,822 - $ 1,252.19 $ 29,854.15 164,232.0 $ 84,390.19 55,865 1.51061 '® M 02/23/22 T • - 22009272 ..1111MMI . -� _ 18,113 $ 610.26 S 15,062.33 173,405.0 $ 99,452.52 65,038 1.52914 a $ 1,205.02 $ 31,474.88 191,518.0 $ 130,927.40 83,151 1.57457 0228/2.1 MONTHLY INVENTORY ADJUSTMENT 206 $ 627.59 191,724.0 $ 131554.99 83,357 1.57821 02/28/22 END OF MONTH R-... .......-.r ..,. ... '...!...",7r...:Zi »:S .e,4.... 1 65.315.87 41.366 41,971 1.57821 03/10/22 Targa 2201253/ 9.144 1.81930 $ 16,006.57 $ 829.07 $ 16,635.64 200,868.0 $ 81,951.51 50,530 1.62184 03/11/22 Targa 22012997 9,018 1.77805 S 15,414.01 S 620.41 S 16,034.42 209,886.0 S 97,985.93 59,548 1.64549 0325/22 Targa 22014345 9,178 1.78430 $ 15,744.86 $ 631.41 $ 16,376.27 219,084.0 1 114,362.20 68.726 1.66403 03/29/22 Targa 22014791 9.092 1.72742 S 15,080.22 $ 625.50 $ 15,705.72 228,156.0 $ 130,067.92 77,818 1.67144 03/3122 MONTHLY INVENTORY ADJUSTMENT 168 3.35256 $ 563.23 $ 563.23 228,324.0 $ 130,631.15 77 986 1.67506 03/3122 END OF MONTH 04/11/22 Targa 22017284 ... _..•....... 8,956 1.50510 . 1:-.:„;',7,;-..= I,W,, ,, $ 12,800.37 $ 679.33 _ ;`t,"� `. M "t $ 13,479.70 ;" "r`":; 237,280.0 8 47,789.43 S 61,289.13 28,530 37,486 49,456 1.67506 1.63445 04/12/22 Targa 22017444 9.070 1.49260 $ 12,849.92 $ 687.98 $ 13,537.90 246,350.0 $ 74,807.03 46,556 1.60682 04/25/22 Targa 22018468 9,252 1.52635 $ 13,420.03 $ 701.78 $ 14,121.81 255,602.0 S 88,928.84 55,808 1.59348 04/27/22 Targa 22019128 8,947 1.50885 S 12,821.06 $ 678.65 $ 13,499.71 264,549.0 $ 102,428.55 64,755 1.58179 04/30/22 MONTHLY INVENTORY ADJUSTMENT 387 1.30506 $ 505.06 $ 505.06 284,936.0 $ 102,933.61 65.142 1.58014 04/30/22 END OF MONTH 4``u... '; . 2..+,,"s`"F-. 'ki,;;5.. �.. ,d.Y: . 4. .: 8 33,935.13 21,476 43,666 1.58014 05/09/22 Targa 22022190 18,058 1.51989 $ 25,868.61 1 1,576.03 $ 27,442.64 282,994.0 S 61,377.77 39,534 1.55253 05/11/22 Targa 22022300 9,028 1.49028 $ 12,666.28 $ 787.93 $ 13,454.21 292,022.0 $ 74,831.98 48,562 1.54096 05/12/22 Tarya 22022522 9,127 1.50465 1 12,936.39 $ 796.57 $ 13,732.96 301,149.0 $ 88,564.94 57,689 1.53521 FYTD Totals 263,089 1.59287 $ 401,305.76 $ 17,760.77 $ 419,066.53 Projections Delivered Delivered Delivered Cost Total EOM Tank EOM Tank Projected Month CGS Cost Gallons Cost of Inventory Gallons Gallons Cost WACOG Apr -22 21,476 $ 33,935.00 1.58 May -22 $ 1.60 27,000 $ 43,200.00 $ 77,135.00 48,476 21,476 $ 34,172.61 1.59 Jun -22 $ 1.60 27,000 $ 43,200.00 $ 77,372.61 48,476 21,476 $ 34,277.87 1.60 Jul -22 $ 1.60 27,000 $ 43,200.00 $ 77,477.87 48,476 21,476 $ 34,324.51 1.60 Aug -22 $ 1.50 18,000 $ 27,000.00 $ 61,324.51 39,476 21,476 $ 33,362.17 1.55 Sep -22 $ 1.50 27,000 $ 40,500.00 $ 73,862.17 48,476 21,476 $ 32,722.67 1.52 Oct -22 $ 1.50 27,000 $ 40,500.00 $ 73,222.67 48,476 21,476 $ 32,439.35 1.51 Nov -22 $ 1.75 36,000 $ 63,000.00 $ 95,439.35 57,476 21,476 $ 35,661.07 1.66 Dec -22 $ 1.75 36,000 $ 63, 000.00 $ 98, 661.07 57,476 21,476 $ 36, 864.87 1.72 Jan -23 $ 1.75 48,000 $ 84,000.00 $ 120,864.87 69,476 21,476 $ 37,361.02 1.74 Feb -23 $ 1.75 48,000 $ 84,000.00 $ 121,361.02 69,476 21,476 $ 37,514.38 1.75 Mar -23 $ 1.75 36,000 $ 63,000.00 $ 100,514.38 57,476 21,476 $ 37,557.36 1.75 CSW: 5/26/2022 CLEARWATER GAS SYSTEM Attachment #4 NATURAL GAS RATE BILLING FACTORS FOR JUNE 1, 2022 - SEPTEMBER 30, 2022 BASED ON APPROVED GAS ADJUSTMENT FACTORS Interr. Contract Firm Natural Gas Rate Schedules NG Rate NG Rate RS SMF MMF LMF SGS MGS _tat_ gl►C GAC l�Al� _ SL w/M& NGV NSS IS CNS Reliah( (Non -Rest) (Non -Rest) Applicable Annual Them, 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 318.00 525.00 540.00 $95.00 325.00 $40.00 595.00 Rate Rate Rate $20.00 $20.00 By Contract 350.00 3250.00 By Contract (For Central Pasco Territory) (524.00) (340.00) (370.00) (3160.00) (340.00) (570.00) (3160.00) Suspended Suspended Suspended ($30.00) ($30.00) (By Contract) (575.00) ($400.00) (By Contract) Reserved for Reserved for Reserved for Non -Fuel Enemy Charae/Thenn Future Use Future Use Future Use Non -Fuel Energy Charge $0.44 30.44 $0.44 $0.44 $0.38 $0.34 $0.30 NA NA NA 30.20 30.35 By Contract $0.38 $0.24 By Contract Energy Conservation Adj. (ECA) 0.13 0.13 0.13 0.13 0.13 0.13 0.13 NA NA NA NA NA NA NA NA NA Regulatory Imposition Adj. (RIA) 0.01 0.01 0.01 0.01 0.01 0.01 0.01 NA NA NA NA NA NA NA NA NA Usage & Inflation Adj. (UTA) -0.01 ;QQ1 A9.1 &,.Q1 QQS 1.01 Q,Q;i NA NA N6 NA N.6 10-6 NA NA NA Total Non -Fuel Energy Charge $0.57 $0.57 $0.57 $0.57 30.57 $0.53 30.49 NA NA NA 30.20 $0.35 By Contract $0.38 $0.24 By Contract Purchased Gas Adjustment (PGA) lin 1.42 1St ISO lid j.1# N6 NA NA 1.42 1,0 By Contract ISM Q, 4 Q,$4 Total Energy Charge/Therm 1.60 1.60 1.60 1.60 1.60 1.56 1.52 NA NA NA 1.23 1.38 By Contract 1.41 1.18 0.94 + Non -Fuel Minimum Monthly Bill 518.00 325.00 $40.00 $95.00 $25.00 $40.00 $95.00 NA NA NA 320.00 $20.00 By Contract 550.00 3250.00 Customer (For Central Pasco Territory) (524.00) (540.00) ($70.00) (5160.00) ($40.00) (570.00) (3160.00) (330.00) ($30.00) (By Contract) (575.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.46 $ 1.46 $ 1.46 $ 1.46 $ 1.46 $ 1.43 $ 1.39 NA NA NA $ 1.13 $ 1.26 NA $ 1.29 $ 1.08 with 6.0% Franchise $ 1.55 $ 1.55 $ 1.55 $ 1.55 $ 1.55 $ 1.51 $ 1.47 NA NA NA $ 1.19 $ 1.34 NA $ 1.37 $ 1.14 Utility Tax Note: Fuel Rate perThenn 10/01/1973 $0.069 $0.069 30.069 $0.069 50.069 $0.069 $0.069 NA NA NA $0.069 $0.069 $0.069 $0.069 $0.055 $0.069 Non -Utility Taxable FuelfTherm $0.961 50.961 $0.961 50.961 $0.961 30.961 $0.961 NA NA NA $0.961 50.981 ($0.069) $0.961 $0.885 $0.871 BTU FACTOR = THERMS/100 CUBIC FEET ICCFI 10/2021 11/2021 12/2021 01/2022 02/2022 03/2022 04/2022 1)5/2022 06/2022 07/2022 08/2022 09/2022 Firm Service Rates 1.045 1.048 1.046 1.044 1.045 1.045 1.043 1.041 1.041 Interruptible Service Rates 1.025 1.025 1.025 1.024 1.024 1.024 1.022 1.021 1.020 FY 21/22 Avg. 1.044 1.023 CSW: 2/26/2022 BTU Factor: BTU Factor: Therm Factor: 2.714 Gallons/100 cubic feet (CCF) x,483 Therms/100 cubic feet (CCF) 0.915 Therms/Gallon Applicable Annual Gallon Range or Other Rate Determinant Monthly Customer Charge Non -Fuel Enerav Charges/Gallon: Non -Fuel Energy Charge (NFE)/Gallon 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 RESIDENTIAL MULTI -FAMILY MRLP MMLP NA NA (1 - 3 Units) (4 + Units) $16.00 $25.00 CLEARWATER GAS SYSTEM METERED PROPANE (LP) RATE BILLING FACTORS FOR JUNE 1, 2022 - SEPTEMBER 30, 2022 BASED ON APPROVED GAS ADJUSTMENT FACTORS LOOP RESL. SMALL COML. LRLP MGLP LARGE COML. MLLP NA 0 - 2,500 >2,501 $16.00 $25.00 $40.00 For Each Meter $1.90 $1.90 $0.90 $0.30 $0.25 0.13 0.13 0.13 0.13 0.13 0.01 0.01 0.01 0.01 0.01 QQ1 mi 1,01 O Q$ 0.05 $2.03 $2.03 $1.03 $0.49 $0.44 222 2:44 222 2.44 2.44 $4.03 $4.03 $3.03 $2.49 $2.44 $16.00 $25.00 $16.00 $25.00 $40.00 0.161 0.161 0.161 0.161 0.161 $1.839 $1.839 $1.839 $1.839 $1.839 VEHICLE LPV (Non -Rest. Only) NA $40.00 Set By Contract NA NA NA Set By Contract Set By Contract Contract NFE + Contract PGA Customer Charge Any Applicable Customer Charge + Any Applicable Facility Charges 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.44 $3.00 $50.00 0.161 0.161 Contract PGA - 0.161 $1.839 Set By Contract NA NA NA Set By Contract Contract NFE + $1.700 Customer Charge + Non -Fuel Energy Chg. for the Contracted # of Gallons/Mo. 0.161 Contract PGA - 0.161 CSW: 2/26/2022 BTU Factor: 2714 Gallons/100 cubic feet (CCF) BTU Factor: 2.483 Therms/100 cubic feet (CCF) Therm Factor: 0.915 Therms/Galbn CLEARWATER GAS SYSTEM BULK PROPANE (LP) RATE BILLING FACTORS FOR JUNE 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 Level) (Based on Annual Usage Level) GENERATOR BRLPO )3RLP1 BRLP2 BRLP3 BRLP4 WRLPO WRLP1 WRLP2 WRLP3 W LPIR j3CLP1 pCLP2 LPSB (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 - 60 60.1 -120 120.1 - 300 > 300 0 - 2,500 > 2,500 New Residents) 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) Range of Usage Range of Usage Annual Customer Charge $ 395.00 $ 270.00 $ 225.00 $ 135.00 $ 120.00 $ 395.00 $ 255.00 $ 195.00 $ 120.00 $ 105.00 $ 90.00 $ 90.00 $ 420.00 Non -Fuel Charges INFI/Gallon; Non -Fuel Energy Charge (NFE)/Gal. $ 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. (ECA)/Gal $ 0.13 $ 0.13 $ 0.13 0.13 0.13 0.13 0.13 0.13 0.13 0.13 0.13 0.13 NA Regulatory Imposition AdJ. (RIA)/Gal $ 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 8Inflation Adj. (UTA)/Gallon (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.83 $ 1.93 $ 1.73 $ 1.13 $ 1.03 $ 1.83 $ 1.93 $ 1.73 $ 1.03 $ 0.93 8 0.44 $ 0.39 $ 1.00 Purchased Gas Adj. (PGA)/Gallon $ 2.00 $ 2.00 $ 2.00 8 2.00 $ 2.00 $ 2.00 $ 2.00 Z 00 $ 2.00 8 2.00 $ 2.00 $ 2.00 $ 2.00 Total Energy Charges/Gallon $ 3.93 $ 3.93 $ 3.73 $ 3.13 $ 3.03 $ 3.93 $ 3.93 $ 3.73 $ 3.03 $ 2.93 $ 2.44 $ 2.39 $ 3.00 Note: No Monthly Minimum Bill Utility Tax Note: Fuel Rate per Gallon 10/01/1973 $ 0.181 $ 0.161 $ 0.161 $ 0.161 $ 0.161 $ 0.181 $ 0.161 $ 0.181 $ 0.181 $ 0.161 $ 0.161 $ 0.161 $ Non -Utility Taxable FueVGallon $ 1.839 $ 1.839 $ 1.839 $ 1.839 $ 1.839 $ 1.839 $ 1.839 $ 1.839 $ 1.839 $ 1.839 $ 1.839 $ Attachment #5 Page 2 of 2 CONTRACT BULK LP SERVICE CLP Any Contract Customers Who Requests Bulk Del. Set by contract Set By Contract NA NA I19A Set By Contract 1 Cotract NFE 1.700 0.161 $ 0.161 1.839 $ 1.839 Contract PGA - 0.161 CSW:5rz6/2022 Rate History By Components 1 Attachment #6 1- Contract Page 1 of3 LP Residential 1 Clearwater Gas System Tota Rate +- Adjustments/Therm Month NG/therm LP/gallon * ECA RIA# WNA/UTA-Rest# UIA-Coml# PGA PGA f PGA/`,gallon t -I- Oct-20 $ 1.44 $ 2.75 1 $ 0.20 $ 0.18 $ 0.18 $ - $ - t $ - $ 0.09 $ 0.08 $ 0.71 $ 0.61 $ 0.59 $ 0.59 1 $ 1.46 Nov -20 $ 1.38 $ 2.70 { $ 0.07 $ 0.13 $ 0.69 $ 1.45 $ 1.45 $ 1.39 - $ 1.39 $ 1.39 $ 1.39 - Dec -20 $ 1.38 $ 2.70 rt $ 0.07 $ 0.13 $ 0.69 Jan -21 $ 1.32 $ 2.64 $ 0.18 $ - 11 - $ 0.07 $ 0.13 $ 0.63 $ 0.63 $ 0.53 $ 0.53 $ 0.53 $ 0.53 Feb -21 $ 1.32 $ 2.64 $ 0.18 $ 0.07 $ 0.07 $ 0.13 Mar -21 $ 1.32 $ 2.64 * } $ 0.18 $ $ 0.13 $ 0.63 Apr -21 $ 1.32 $ 2.64 $ 0.18 $ - 1$ 0.07 $ 0.13 $ 0.63 May -21 $ 1.32 $ 2.64 $ 0.18 $ - $ 0.07 $ 0.13 $ 0.63 $ 0.63 $ 0.53 $ 0.53 $ 1.39 - $ 1.39 - $ 1.59 Jun -21 $ 1.32 $ 2.64 $ 0.18 $ 0.18 $ - $ - $ 0.07 $ 0.13 Jul -21 $ 1.25 $ 2.77 $ - $ 0.13 $ 0.63 $ 0.63 $ 0.53 $ 0.53 Aug -21 $ 1.25 $ 2.77 $ 0.18 $ - $ - $ 0.13 $ 1.59 Sep -21 $ 1.25 $ 2.77 $ 0.18 $ - ' $ - $ 0.13 $ 0.63 $ 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. I $ 1.503 $ 2.850 1 $ 0.221 $ - I $ 0.082 $ 0.085 $ 0.760 $ 0.660 $ 1.548 $ 1.99 Oct -21 $ 1.40 $ 3.22 $ 0.20 $ 0.03 $ - $ 0.13 $ 0.73 $ 0.64 Nov -21 $ 1.40 $ 3.22 $ 0.20 $ 0.03 $ - $ 0.13 $ 0.73 $ 0.64 $ 1.99 Dec -21 $ 1.37 $ 3.42 $ 0.17 $ 0.01 $ (0.01) $ 0.05 $ 0.76 $ 0.67 $ 2.25 Jan -22 $ 1.37 $ 3.42 $ 0.17 $ 0.01 $ (0.01) $ 0.05 $ 0.76 $ 0.76 $ 0.67_, $ 2.25 $ 0.67 $ 2.25 Feb -22 $ 1.37 $ 3.42 $ 0.17 $ 0.01 $ (0.01) $ 0.05 Mar -22 $ 1.40 $ 3.38 $ 0.13 $ 0.01 $ (0.01) $ 0.05 $ 0.83 $ 0.74 $ 2.25 Apr -22 $ 1.40 $ 3.38 $ 0.13 $ 0.01 $ (0.01) $ 0.05 $ 0.83 $ 0.74 $ 2.25 May -22 $ 1.52 $ 3.38 $ 0.13 $ 0.01 $ (0.01) $ 0.05 $ 0.95 $ 0.86 $ 2.25 Jun -22 $ 1.60 $ 3.13 $ 0.13 $ 0.01 $ (0.01) $ 0.05 $ 1.03 $ 0.94 $ 2.00 Jul -22 Aug -22 Sep -22 FYTD 21/22 Av $ 1.426. $ 3.330 $ 0.159 $ 0.014 $ (0.008) $ 0.068 $ 0.820 $ 0.730 $ 2.164 2021 Avg. $ 1.320 $ 2.834 $ 0.183 $ 0.006 $ 0.034 $ 0.123 $ 0.658 $ 0.560 $ 1.612 Incr. Above $ 0.28 $ 0.49 $ (0.05) $ 0.01 $ (0.08) $ (0.08) $ 0.40 $ 0.41 $ 0.61 Last Year Same Month 21% 19% -28% NA -114% -62%. 63% 77% 44% Incr. Based $ 5.60 $ 10.71 on 20 Therms 21%. 19% Equivalent Cents/KWH 5.5 11.7 for Gas vs. Duke Rate 14.8 14.8 Note: Duke Energy Florida's residential rate for usage >1,000 KWH in April 2022 is 14.805 cents/KWH. (Residential) Gas Cheaper by -63% -21% 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:9/27/2021 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% 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 + t Page 3 of 3 * * , 1 Annual Average CGS Residential Rates Calender Year Fiscal Year Year NG/Therm LP/Gallon * Year NG/Therm LP/Gallon * 1995 -I 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 $ 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 L,rrs, Li`e Greener torhGas ANNUAL ENERGY USAGE AND COST ANALYSIS June 2022 /f -7r 4cii l ."Pr- ite. 7 Natural Gas Appliance Type Therms Electric Natural Propane Electric Savings Savings Usage Gas (LP) Gas Cost Natural Gas Propane Kwh COOKING 35 $ 56.00 $ 119.73 $ 116.79 $ 60.79 $ ( 2.94) 789 WATER HEATING (Tankless) 100 $ 160.00 $ 342.08 $ 355.70 $ 195.70 $ 13.63 2,403 WATER HEATING (Tank) 150 $ 240.00 $ 513.11 $ 445.57 $ 205.57 $ ( 67.54) 3,010 CLOTHES DRYING 50 $ 80.00 $ 171.04 $ 190.86 $ 110.86 $ 19.83 1,289 TOTAL (TANKLESS water heater) $ 296.00 $ 632.84 $ 663.35 $ 367.35 $ 30.51 TOTAL (TANK water heater) $ 376.00 $ 803.88 $ 753.22 $ 377.22 $ ( 50.66) CGS Customer charge $ (168.00) $ (115.00) Net Savings (Tankless Gas & Electric) $ 199.35 $ ( 84.49) 30% •13% Net Savings (Tankless Gas vs. Tank Electric) $ 289.22 $ 5.38 38% 1% Furnace & Outside Recreation HOME HEATING POOL HEATING** SPA/HOT TUB HEAT** 130 $ 208.00 $ 444.70 $ 196.77 250 $ 400.00 $ 855.19 $ 222.31 125 $ 200.00 $ 427.60 $ 111.16 * 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 Therm =100,000 BTUs of energy 2. Natural Gas Rate $ 1.60 3. LP Gas per gallon (Bulk Bill level 3 or Will Call) $ 3.13 4. Duke Energy Rate (per kwh) 0.14805 per Therm per Gallon per KWH or or $ 3.42 per Therm Equivalent $ 4.34 per Therm Equivalent Costs based on June 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). CNG Station price - June 2022 /4 ff ec)..r+4-u1— It13 Clearwater Gas System ___ Le Greener $ 0.30 Non -Fuel rate $ 0.75 Fuel (PGA) rate $ 0.39 Capital recovery (FY22-24) $ 0.90 O&M recovery $ 2.34 per GGE+ $ 0.166 10% Utility Tax++ ($0.069/gge) $ 0.183 Federal excise tax $ (0.50) Excise tax credit $ 2.19 per GGE (Posted price) $ 2.01 per GGE' (City fleet only) + GGE: Gasoline Gallon Equivalent ++ Utility tax conversion: $0.055/therm (Interrupt rate) x 1.25 = $0.069/gge * Posted CNG price: [ $2.34 (base price) + 10% Utility Tax + Federal Excise tax + Fed Excise Credits] ** City/Tax exempt vehicles: [ $1.42 (base price) + 10% Utility Tax + Fed Excise Credits]