Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
GAS ADJUSTMENTS EFFECTIVE DECEMBER 1, 2021
CLEARWATER GAS SYSTEM Interoffice Correspondence Sheet TO: Jon Jennings, City Manager FROM: Chuck Warrington, Executive Director V, COPIES: Rosemarie Call, City Clerk; CGS & UCS Management Teams; UCS Billing Team; Micah Maxwell, Assistant City Manager SUBJECT: GAS ADJUSTMENTS EFFECTIVE DECEMBER 1, 2021 DATE: November 18, 2021 Gas supply prices have been rising this Fall; therefore, we are recommending a 3¢/therm increase in our Natural Gas Purchase Gas Adjustments (PGAs) and a 26¢/gallon increase in our Propane (LP) PGA for December. We recommend that we continue our Contract LP PGA at 30¢ below our standard LP PGA. This is the time of year when we reevaluate our Usage & Inflation Adjustments; therefore we are recommending a 10/therm or gallon decrease for our Residential UTA and an 8¢/therm or gallon decrease for our Commercial UTA for December. We are recommending a 3¢/therm or gallon decrease in our Energy Conservation Adjustment (ECA) for December as we have shifted some of these expenses to base rates. We are also recommending a 2¢/therm or gallon decrease in our Regulatory Imposition Adjustment (RIA) for December as this balance is running ahead of plan. The net effect of these recommended changes for December is a 3¢ per therm decrease (-2.1%) in our typical Residential Natural Gas customer's therm rate and a 20¢ per gallon increase (+6.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 December 1, 2021: Natural Gas Firm Standard Rate Schedule PGA $0.76 per therm (up 3¢) Natural Gas Interruptible and Contract (Non -Standard) Rate Schedule PGA $0.67 per therm (up 3¢) Propane (LP) Gas Standard Rate Schedule PGA $2.25 per gallon (up 26¢) Propane (LP) Gas Contract Rate Schedule PGA $1.95 per gallon (up 26¢) Energy Conservation Adjustment (ECA) $0.17 per therm or gallon (down 3¢) Regulatory Imposition Adjustment (EIA) $0.01 per therm or gallon (down 2¢) Usage & Inflation Adjustment (UTA) - Residential .... -$0.01 per therm or gallon (down 1 ¢) - Commercial $0.05 per therm or gallon (down 8¢) Jon Jennings, City Manager November 18, 2021 Page 2 Attachment #1 shows the status of our Adjustment Recovery Clause balances with actuals thru October 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 shows the calculation of UTA for FY22. Attachment #7, Page #1, shows our monthly rate history this year, and Pages #2 and #3 of this show our 19 -year relationship to electric prices and average residential rates, respectively. 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 67% lower than electric for Natural Gas and 10% 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 42% savings for NG as opposed to electric (see Attachment M. 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 December 1St billings. If you have any questions on this, please call me. CSW/cw Attachments Approved:.....� G.. . ..j *...... Jon Jennings, City Manager U:1My Documents\WORD1GASRATESIFY 21-22\Gas Adjustments for December 2021.docx CLEARWATER GAS SYSTEM SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTIONS for FY 21/32 ATTACHMENT #1 Page 1 of 3 NATURAL GAS PURCHASED GAS ADJUSTMENT (PGA -NG) Monthly Cumulative NG PGA Overage YTD Overage Rate/Therm Budget Reservation Commodity Personal Interfund Prior YEAR Interest Coat Center Total NG Fuel Total NG PGA (Shortage) (Shortage) Firm/Contr Therms Billed Month Charges Charges Services Svc charge Dividend Other Write off Expense Expenses Expenses Billed $ (103,106.42) Prior Year - $ (237,859.54) 0.73/0.64 1,950,000 0.68 Oct -21 $ 135,111.47 •• 60 • •• - 8 $ (452,917.51) 0.73/0.64 2,040,000 .0.68 Nov -21 $ 222,500.001,200,000.00 $ 50,000.00 6,000.00 •• 1,387,200.00 $ (1,101,413.14) 0.76/0.67 2,430,000 '0.71 Dec -21 $ 230,500.001,400,000.00 $ 50,000.00 $ 123,163.33 $ 550,000.00 $ 6,000.00 ••• •• - 1,725,300.00 • • $ (1,505,330.00) 0.76/0.87 2,830,000 0.71 Jan -22 $ 231,300.00 1,450,000.00 $ 50,000.00 $ 123,163.33 $ 550,000.00 6,000.00 •• • •• • • $ 1,950,856.66) 0.76/0.67 2,870,000 0.71 Feb -22 $ 208,300.00 1,400,000.00 $ 5• • • r • •2,341,226.66 • • • • - $ (1,828,197.13) 0.76/0.67 2,520,000 0.71 Mar -22 $ 232,500.00 • ••• •• • ••• ••6,000.00• •• 1,666,540.47 1,789,200.00 � • ••- = $ (1,588,530.95 ) 0.76/0.67 2,410,000 0.71 Apr -22 $ 167,700.00 •• �•• •� � • ••• •• � � � � ••..• � � • � � •• •• $ 379,015.34$ (1,189,515.61) 0.76/0.67 2,220,000 0.71 Ma -22 $ 114,100.00 • • • • • • • • • • • • • • $ 123,163.33 $ - $ 6,000.00 - $ 3,921.33 $ 179,163.33 $ 1,197,184.66 1,576,200.00 8 $ (821,552.73) 0.78/0.87 2,130,000 0.71 Jun -22 $ 112,200.00 : r • • • • • • • 3 • • r • $ (481,169.94) 0.76/0.67 2,060,000 0.71 Jul -22 $ 116,000.00 825,000.00 $ 50,000.006,000.00- • 1,462,600.00 $ 336,233.75 $ (144,936.19) 0.76/0.67 2,060,000 0.71 Au. 22 $ 116,000.00 830,000.00 50,000.00 6,000.00 • - ••• •• $ 336,974.33 $ 192,038.14 0.76/0,67 2,080,000 0.71 Sep -22 $ 110,300.00 850,000.00 $ 50,000.00 $ 123,163.33 $ - $ 8,000.00 $ 362.34 $ 179,163.33 $ 1,139,825.67 1,476,800.00 $ 192,038.14 Total YTD $ 1,996,511.47 $ 13,152,913.43 $ 582,580.17 $ 1,477,959.96 $ 1,650,000.00 $ 71,976.81 $ 13,000.00 $ 28,463.46 $ 3,795,516.94 $ 18,973,40530 $ 19,268,549.86 $ 295,144.56 27,400,000 PROPANE (LP) GAS PURCHASED GAS ADJUSTMENT (PGA -LP) Cost -Monthly Cumulative LP PGA Budget Gallons Monthly Interfund Festivals & LP Yard Suburban Prior YEAR Interest Commodity Center Total LP Fuel Total LP PGA Overage YTD Overage Therm/Gal. Month Sold WACOG Svc charge Dividend Fuel Evaporixation Software Write off Expense Charges Expenses Expenses Billed (Shortage) (Shortage) $ (74,717.1M Prior Year $ 51,141.55 $ 55,584.40 $ 4,442.85 $ (70,274.31) 1.82/1.99 Oct -21 29,269.1 $ 1.55845 $ 5,273.33 $ - $ - $ 67.00 $ - $ 186.79 45,614.43 5,340.33 Nov -21 32,000.0 $ 1.63000 $ 5,273.33 $ - $ 200.00 $ 75.00 $ - $ 200.00 52,160.00 5,548.33 $ 57908.33 63,680.00 $ 5,771.67 $ (64,502.64) 1.82/1.99 Dec -21 36,000.0 $ 1.68000 $ 5,273.33 $ 23,000.00 $ 200.00 $ 75.00 $ 5,000.00 $ 600.00 $ 200.00 60,480.00 34,148.33 $ 94,828.33 81,000.00 $ (13,828.33) $ (78,330.97) 2.06/2.25 Jan -22 38,000.0 $ 1.71000 $ 5,273.33 $ 23,000.00 $ 200.00 $ 75.00 $ - $ 200.00 64,980.00 28,548.33 $ 93,728.33 85,500.00 $ (8,228.33) $ (86,559.30) 2.06/2.25 Feb -22 35,000.0 $ 1.73000 $ 5,273.33 $ 23,000.00 $ 200.00 $ 75.00 $ - $ 200.00 60,550.00 28,548.33 $ 89,298.33 78,750.00 $ (10,548.33) $ (97,107.63) 2.08/2.25 Mar -22 38,000.0 $ 1.62000 $ 5,273.33 $ - $ 200.00 $ 75.00 $ - $ 200.00 61,560.00 5,548.33 $ 67,308.33 85,500.00 $ 18,191.67 $ (78,915.96) 2.06/2.25 Apr -22 37,000.0 $ 1.57000 $ 5,273.33 $ - $ 200.00 $ 75.00 $ - $ 200.00 . 58,090.00 5,548.33 $ 83,838.33 83,250.00 $ 19,411.67 $ (59,504.29) 2.06/2.25 May -22 30,000.0 $ 1.54000 $ 5,273.33 $ - $ 200.00 $ 75.00 $ - $ 200.00 46,200.00 5,548.33 $ 51,948.33 67,500.00 $ 15,551.67 $ (43,952.62) 2.06/2.25 Jun -22 23,000.0 $ 1.52000 $ 5,273.33 $ - $ 200.00 $ 75.00 $ - $ 200.00 34,960.00 5,548.33 $ 40,708.33 51,750.00 $ 11,041.67 $ (32,910.95) 2.06/2.25 Jul -22 23,000.0 $ 1.52000 $ 5,273.33 $ - $ 200.00 $ 75.00 $ - $ 200.00 34,960.00 5,548.33 $ 40,708.33 51,750.00 $ 11,041.67 $ (21,869.28) 2.06/2.25 Aug -22 23,000.0 $ 1.51000 $ 5,273.33 $ - $ 200.00 $ 75.00 $ - $ 200.00 34,730.00 5,548.33 $ 40,478.33 51,750.00 $ 11,271.67 $ (10,597.61) 2.06/2.25 Sep -22 25,000.0 $ 1.51000 $ 5,273.33 $ - $ 200.00 $ 75.00 $ - $ 200.00 37,750.00 5,548.33 $ 43,498.33 56,250.00 $ 12,751.67 $ 2,154.06 2.06/2.25 P13 $ - $ 2,154.06 Total YTD $ 369,269.10 $ 1.60 $ 63,279.96 $ 69,000.00 $ 2,200.00 $ 892.00 $ 5,000.00 $ 600.00 $ 2,386.79 $ 592,034.43 $ 140,971.96 $ 735,393.18 $ 812,264.40 $ 76,871.22 ENERGY CONSERVATION ADJUSTMENT (ECA) Budget Month Personal Services Advertising Residential & Builder ECA and Other Promotional Interfund Svc charge Dividend Other Operating Expenses SNEP Prior Year write off Interest Expense Total ECA Expenses Total ECA Billed Monthly Overage (Shortage) Cumulative YTD Overage (Shortage) ECA NG/Therm LP/Gel. $ 97,601.10 Prior Year - $ 47,466.66 $ 145,067.76 0.20/0.20 Oct -21 $ 109,883.48 $ 280.00 $ 50,625.00 $ 6,544.17 $ - $ 4,833.01 $ 9,933.46 $ - $ (244.00) $ 181,855.12 $ 229,321.78 Nov -21 $ 110,000.00 $ 5,500.00 $ 150,000.00 $ 6,544.17 $ - $ 5,000.00 $ 150,000.00 $ - $ (362.67) $ 426,681.50 412,096.00 $ (14,585.50) $ 130,482.26 0.20/0.20 Dec -21 $ 80,000.00 $ 5,500.00 $ 150,000.00 $ 6,544.17 $ 57,000.00 $ 5,000.00 $ 150,000.00 $ 5,000.00 $ (326.21) $ 458,717.96 417,016.80 $ (41,701.18) $ 88,781.10 0.17/0.17 1 Jan -22 $ 80,000.00 $ 5,500.00 $ 150,000.00 $ 6,544.17 $ 57,000.00 $ 5,000.00 $ 150,000.00 $ - $ (221.95) $ 453,822.22 485,234.40 $ 31,412.18 $ 120,193.28 0.17/0.17 Feb -22 $ 80,000.00 $ 5,500.00 $ 150,000.00 $ 6,544.17 $ 57,000.00 $ 5,000.00 $ 150,000.00 $ - $ (300.48) $ 453,743.69 457,708.00 $ 3,964.31 $ 124,157.59 0.17/0.17 Mar -22 $ 80,000.00 $ 5,500.00 $ 150,000.00 $ 6,544.17 $ - $ 5,000.00 $ 150,000.00 $ - $ (310.39) $ 396,733.78 432,534.40 $ 35,800.62 $ 159,958.22 0.17/0.17 Apr -22 $ 80,000.00 $ 5,500.00 $ 150,000.00 $ 8,544.17 $ - $ 5,000.00 $ 150,000.00 $ - $ (399.90) $ 396,644.27 413,725.60 $ 17,081.33 $ 177,039.54 0.17/0.17 May -22 $ 80,000.00 $ 5,500.00 $ 150,000.00 $ 6,544.17 $ - $ 5,000.00 $ 150,000.00 $ - $ (442.60) $ 396601.57 380664.00 $ (15,937.57) $ 161 101.97 0.17/0.17 Jun -22 $ 80,000.00 $ 5,500.00 $ 150,000.00 $ 6,544.17 $ - $ 5,000.00 $ 150,000.00 $ - $ (402.75) $ 396,641.42 364,602.40 $ (32,039.02) $ 129,062.96 _ 0.17/0.17 Jul -22 $ 80,000.00 $ 5,500.00 $ 150,000.00 $ 6,544.17 $ - $ 5,000.00 $ 150,000.00 $ - $ (322.66) $ 396,721.51 352,702.40 $ (44,019.11) $ 85,043.84 0.17/0.17 Aug -22 $ 80,000.00 $ 5,500.00 $ 150,000.00 $ 6,544.17 $ - $ 5,000.00 $ 150,000.00 $ - $ (212.61) $ 396,831.56 352,702.40 $ (44,129.16) $ 40,914.68 0.17/0.17 Sep -22 $ 80,000.00 $ 5,500.00 $ 150,000.00 $ 6,544.17 $ - $ 5,000.00 $ 150,000.00 $ - $ (102.29) $ 396,941.88 356,320.00 $ (40,621.88) $ 292.80 0.17/0.17 $ - $ 292.80 Total YTD $ 1,019,883.48 $ 60,780.00 $ 1,700,625.00 $ 78,530.04 $ 171,000.00 $ 59,833.01 $ 1,659,933.46 $ 5,000.00 $ (3,648.51) $ 4,751,936.48 $ 4,654,628.18 $ (97,308.30) CLEARWATER GAS SYSTEM SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTIONS for FY 21/22 ATTACHMENT #1 Page 2 of 3 REGULATORY IMPOSITION ADJUSTMENT (RIA (EIA) (EIA) (EIA) ORA ORA (ORA) Budget Interfund Svc charge Dividend Insurance Personal Svs Other Regulatory Interest Total RIA Total RIA Overage YTD Overage NGITherm Month Expenses Expenses Expense Expenses Billed (Shortage) (Shortage) LP/Gal. - $ - $ 47,961.84 Prior Year $ (118.48) $ 20,127.11 34,256.13 $ 14,129.02 $ 61,520.86 0.03/0.03 -_ Oct -21 $ 1,223.33 $ - $ - $ 11,118.35 $ 7,903.91 20,245.59 Nov -21 $ 1,300.00 $ - $ - $ 12,000.00 $ 8,000.00 21,300.00 $ (153.80) $ 21,146.20 61,814.40 $ 40,668.20 $ 102,189.06 0.03/0.03 Dec -21 $ 1,300.00 $ 43,000.00 $ - $ 12,000.00 $ 8,000.00 64,300.00 $ (255.47) $ 64,044.53 24,530.40 $ (39,514.13) $ 62,674.93 0.01/0.01 Jan -22 $ 1,300.00 $ 43,000.00 $ - $ 12,000.00 $ 8,000.00 64,300.00 $ (156.69) $ 64,143.31 28,543.20 $ (35,600.11) $ 27,074.82 0.01/0.01 Feb -22 $ 1,300.00 $ 43,000.00 $ - $ 12,000.00 $ 8,000.00 64,300.00 $ (67.69) $ 64,232.31 26,924.00 $ (37,308.31) $ (10,233.49) 0.01/0.01 Mar -22 $ 1,300.00 $ - $ - $ 12,000.00 $ 8,000.00 21,300.00 $ 25.58 $ 21,325.58 25,443.20 $ 4,117.82 $ (6,115.87) 0.01/0.01 Apr -22 $ 1,300.00 $ - $ - $ 12,000.00 $ 8,000.00 21,300.00 $ 15.29 $ 21,315.29 24,336.80 $ 3,021.51 $ (3,094.36) 0.01/0.01 May -22 $ 1,300.00 $ - $ - $ 12,000.00 $ 8,000.00 21,300.00 $ 7.74 $ 21,307.74 22,392.00 $ 1,084.26 $ (2,010.10) 0.01/0.01 Jun -22 $ 1,300.00 $ - $ - $ 12,000.00 $ 8,000.00 21,300.00 $ 5.03 $ 21,305.03 21,447.20 $ 142.17 $ (1,867.93) 0.01/0.01 Jul -22 $ 1,300.00 $ - $ - $ 12,000.00 $ 8,000.00 21,300.00 $ 4.67 $ 21,304.67 20,747.20 $ (557.47) $ (2,425.40) 0.01/0.01 Aug -22 $ 1,300.00 $ - $ - $ 12,000.00 $ 8,000.00 21,300.00 $ 6.06 $ 21,306.06 20,747.20 $ (558.86) $ (2,984.26) 0.01/0.01 Sep -22 $ 1,300.00 $ - $ - $ 12,000.00 $ 8,000.00 21,300.00 $ 7.46 $ 21,307.46 20,960.00 $ (347.46) $ (3,331.72) 0.01/0.01 P13 $ - $ (3,331.72) $ - - $ - $ (3,331.72) Total YTD $ 15,523.33 $ 129,000.00 $ - $ 143,118.35 $ 95,903.91 $ 383,545.59 $ (680.30) 382,865.29 332,141.73 $ (50,723.56) USAGE AND INFLATION ADJUSTMENT (UTA) Monthly Cumulative UTA Commercial Budget Interest Overage YTD Overage NG/Therm Month LP Gallons Expense Rate/Gallon NG Therms Rate/Therm (Shortage) (Shortage) LP/Gal $ - $ (696,61918) Beg. Bal. 104,926.98 $ (430,586.28) 0.13/0.13 Oct -21 6,646.0 $ 2,677.57 0.13 821,469.80 0.13 Nov -21 6,500.0 $ 2,152.93 0.13 800,000.00 0.13 106,997.93 $ (323,588.34) 0.13/0.13 Dec -21 6,500.0 $ 1,617.94 0.05 1,000,000.00 0.05 51,942.94 $ (271,645.40) 0.05/0.05 Jan -22 7,000.0 $ 1,358.23 0.05 1,200,000.00 0.05 61,708.23 $ (209,937.18) 0.05/0.05 Feb -22 7,500.0 $ 1,049.89 0.05 1,100,000.00 0.05 56,424.69 $ (153,512.49) 0.05/0.05 Mar -22 8,500.0 $ 787.56 0.05 1,100,000.00 0.05 56,192.56 $ (97,319.93) 0.05/0.05 Apr -22 8,000.0 $ 486.60 0.05 1,100,000.00 0.05 55,886.60 $ (41,433.33) 0.05/0.05 May -22 8,000.0 $ 207.17 0.05 1,000,000.00 0.05 50,607.17 $ 9,173.84 0.05/0.05 Jun -22 7,500.0 $ (45.87) - 900,000.00 - (45.87) $ 9,127.97 0.00/0.00 Jul -22 7,000.0 $ (45.64) - 900,000.00 - (45.64) $ 9,082.33 0.00/0.00 Aug -22 6,000.0 $ (45.41) - 850,000.00 - (45.41) $ 9,036.92 0.00/0.00 Sep -22 6,500.0 $ (45.18) - 850,000.00 - (45.18) $ 8,991.73 0.00/0.00 Per 13 $ 8,991.73 - Total YTD 85,648.0 10,135.58 11,621,469.80 $ 544,504.99 USAGE AND INFLATION ADJUSTMENT (UTA) Residential NG Therms Rate/Therm Monthly Overage (Shortage) Cumulative YTD Overage (Shortage) UTA NG/Therm LP/Gal Budget Interest Month LP Gallons Expense Rate/Gallon $ - $ 88,484.21 Beg. Bal. $ 427.03 $ 86,911.24 0.00/0.00 Oct -21 22,609.6 $ (432.42) - 297,240.70 - $ (434.56) $ 86,476.68 0.00/0.00 Nov -21 30,000.0 $ (434.56) - 300,000.00 - $ (5,832.38) $ 80,644.30 -0.01/-0.01 Dec -21 40,000.0 $ (432.38) - 500,000.00 - $ (7,803.22) $ 72,841.08 -0.01/-0.01 Jan -22 40,000.0 $ (403.22) - 700,000.00 - Feb -22 35,000.0 $ (364.21) - 600,000.00 - $ (6,714.21) $ 66,126.87 -0.01/-0.01 $ (5,730.63) $ 60,396.24 -0.01/-0.01 Mar -22 40,000.0 $ (330.63) - 500,000.00 - $ (5,651.98) $ 54,744.26 -0.01/-0.01 Apr -22 35,000.0 $ (301.98) - 500,000.00 - $ (4,573.72) $ 50,170.54 -0.01/-0.01 May -22 30,000.0 $ (273.72) - 400,000.00 - $ (3,950.85) $ 46,219.68 -0.01/-0.01 Jun -22 20,000.0 $ (250.85) - 350,000.00 - $ (3,431.10) $ 42,788.59 -0.01/-0.01 Jul -22 20,000.0 $ (231.10) - 300,000.00 - $ (3,413.94) $ 39,374.64 -0.01/-0.01 Aug -22 20,000.0 $ (213.94) - 300,000.00 - $ (3,396.87) $ 35,977.77 -0.01/-0.01 Sep -22 20,000.0 $ (196.87) - 300,000.00 - $ 35,977.77 Per 13 Total YTD 352,609.8 (3,865.89) 5,047,240.70 $ (50,506.44) CLEARWATER GAS SYSTEM SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTIONS for FY 21123 ATTACHMENT #1 Page 3 of 3 TOTAL ALL COST RECOVERY ADJUSTMENT CLAUSES (Both PGAs + ECA + RIA+UTA) Monthly Cumulative Total Budget Total All Total Recovery Overage YTD Overage NG/Th (Firm) Month Expenses Billed (Shortage) (Shortage) LP/Gal. Prior Year - - $ - $ (481,859.69) Oct -21 $ 1,648,126.76 $ 1,684,766.18 $ 36,639.43 $ (445,220.26) 0.96/2.22 Nov -21 $ 2,107,994.01 $ 2,031,353.78 $ (76,640.23) $ (521,860.49) 0.96/2.22 Dec -21 $ 2,991,386.45 $ 2,293,957.76 $ (697,428.69) $ (1,219,289.18) 0.93/2.42 Jan -22 $ 3,024,910.72 $ 2,662,482.61 $ (362,428.12) $ (1,581,717.30) 0.93/2.42 Feb -22 $ 2,948,500.98 $ 2,508,792.48 $ (439,708.50) $ (2,021,425.80) 0.93/2.42 Mar -22 $ 2,151,908.16 $ 2,383,139.53 $ 231,231.37 $ (1,790,194.43) 0.93/2.42 Apr -22 $ 1,933,231.72 $ 2,282,647.02 $ 349,415.30 $ (1,440,779.13) 0.93/2.42 May -22 $ 1,667,042.29 $ 2,092,789.45 $ 425,747.15 $ (1,015,031.98) 0.93/2.42 Jun -22 $ 1,602,991.89 $ 1,946,102.88 $ 343,110.99 $ (671,920.99) 0.93/2.42 Jul -22 $ 1,580,951.72 $ 1,884,322.86 $ 303,371.14 $ (368,549.86) 0.93/2.42 Aug -22 $ 1,584,982.21 $ 1,884,340.25 $ 299,358.04 $ (69,191.82) 0.93/2.42 Sep -22 $ 1,601,573.34 $ 1,906,887.94 $ 305,314.60 $ 236,122.78 0.93/2.42 Per 13 - $ - $ - $ 236,122.78 Total YTD 24,843,600.28 25,561,582.72 $ 717,982.47 Natural Gas 12 month rolling forcast ATT46//ktcer .0iZ A Month 12/1/2021 111/2022 Dth Demand Commodity Total Rate $ 6C 283 000 $ 230 511 5 1,472.620 $ 1 703 131 $ 1 664 065 267 000 $ 231 252 5 1 432 813 $ 6.23 2/1/2022 311/2022 4/1/2022 5/1/2022 6/1/2022 7/1/2022 252 000 5 208 292 S 1 347 959 S 1 556 252 5 6 18 241 000 S 232 511 5 1,209 117 S 974 909 $ 1 441 628 5 5.98 222.000 $ 167,662 S 114.108 S 1.142571 S 973 197 5 5.15 213.000 5 859 089 S 4.57 201 000 S 112,226 5 314 6965 926 922 $ 461 202 000 5 116.033 $ 816 263 5 932.296 5 954.616—$ 5 4.62 8/1/2022 202.000 $ 116.033 $ 838 583 4 73 9/1/2022 10/1/2022 11/172022 210.000 215.291 247 860 5 110226 5 871 336 $ 1 075 486 $ 1 391 493 S 981 562 5 467 $ 135.111 S 1 210 598 $ 5 62 S 6 51 $ 222.524 .... 5 1.614.017 TOTAL 2,756,151 1,996,490 13,104,364 15,100,8545 5.48 Note: 2% increase from previous year Dth purchased and 5% increase in Commodity price R E S OcMT1 21 E Dec 21 Jane R r4 -22 V Ma'.22 br 22 A May, 22 T dun -22. 7.7 ( A , 0 Total C 0 Oct -21 M M 0 D T Tote! COS Natural Gas 5umntary Monthly ActuatlPre)setlaes $0.6318 Volume FT0.1 Cost FTS -2 $0.8318 Volume Cost No.tdoUce $0.0470 Volume Cost Capadty Relinquishment Volume Rale Coad Reservation MjuslmeotsTS TOTAL RESERVATION COST I Rats 170,438 319. '94 316 109 250 132 316140 216 510 1443,2 (39 6b0 144313 '44 3`2 139563. $ 107,921.34 $ $ ;00 4: - 5 200 54 . 5 (80: ;7= . 0 400 1455 $ 136 601 $ 611''. -1 $ 86 + 4 5 91'' _ $ 91 '3' 5 98 "4 Y 41,788 53437 664:11 15 2'51 49 668 211 53 430 41765 41J 440 4+788 764 4)449 $ 26,460.16 ( _... $ 34 80, i; 3 34 68:' ,. , $ 31 554 ^:.. $ 34 640 5 33 76 - $ 2540'; 9 :'.`, 54,• , $ 79;4:' 5 - 5 15,500 $ M0,50 .,. t t 01150 i 4916 $ 1 481 00 49 500 $ 2 222 7O 42 000 5 2 00160 31 000 $ 1451 90 22 SOO $ 1 075 50 12400 $ 59272. 11590 $ 401 30 '0050 5 4'4x2, :, 660: S 01.01i 5 (3,669) rr- en; :00 000, '60 000i ,64 0001 (40.0001 144 0001 320(101 410 0001 ,10 004 ,,, 900 , ,Otro ,. $ $ $ $ 3 5 5 1 5 $ „ 0.0318 o. (1 1000 0 1000 0 1000 0 1030 0 1000 02000 0 20r13 ... $ (117.36) $ $ .6' :: _ J $ •'S :t;' $ . • : $ $ ^ $ $ , .. 5 ,. 1 $1.03 5, " '6 SO 02 50 00 5000 50 Uhl 5090 31300 $a 00 3000 3(3 OO $0`64$1 $ 156,111.47 1 .n2521 50 1 X30 611 40 $ :31 252 30 1 006 2501 40 s 332.611 40 $ '67 661 50 S 1(410752 $ l2220450 S 11603343 $ 1(6 033 43 $ `0229'3 $8,8031 50 0,9K41 50671,0 906451 SO 6656 $06406 100640 306317 $0 45319 1a:.,' -t. . 2,541,833 $ 1689,348.70 570,393 $ 360,432,80 266.100 $ 12.824.98 (393.889) $ 3.910.00 4 548 !:.. :38 ` 4 . 5 0.'8 :u 1 A 5311 °.•7 5 4 348 50 $ 4 054 Sot 5 4408 5t] 1 '3 768' 1171$+ '94a i.. $ 4,179.56 S 9 $ 9 1 s ($46,117.36) $103 $1.996.49015 $0,6472 A nr454 Jr& 26 as of 11/12/2021 Volume FTS -1 (Usage) Rote Cost Volume FTS -2 (Usage) Rate Cost Gas Supply (FOU i Intareonnecls( Volume Rate Cost Fuel % FGU Management fee $0.065 No Notice Usage OTI Payment $0.020 Casrloul Prior Month Mjuolmenl COMMODITY COST reu • Peoples 163,112 S 0.0153 383 " '03 4.444 "053 .013 's3 .403 +'•53 43 . $ 0,961.41 < .: 3 .. ; .. 3 $ iw' '„:` ;..,, $ . •:, . ,:.; 5 5 G '1,:. 'I $ b.:. $ ±�'.,.. s 41,750 � : ._ $ 0.0563 .. . $ 2,436.24 ,. .' .. .1 211,069 a :, .. . . $ � 4.6536 .. . : . $ 1.024,439.02 ,: -' .. .1 .. ,., : 2.33% .. $ 11,607.60 5 ., , .. .. •+ - $ 3.910.00 4 548 !:.. :38 ` 4 . 5 0.'8 :u 1 A 5311 °.•7 5 4 348 50 $ 4 054 Sot 5 4408 5t] 1 '3 768' 1171$+ '94a i.. $ 4,179.56 S 9 $ 9 1 s $ (31,260.93) S 1,024,272.70 1.969,282 S 114.809.15_ 570,393 $ 28,86649 2.747.069 $ 12.655,52215 5163,07835 $0.00 _°.d /453', 54.179.96 ($31,260.93) 312,958.88869 Oc1.21 TOTAL COST ROW., & Comm RATE $ 1,159,314.17 $ 6.49 $ 14,993,376.04 S 5.45 Total Projected DTH WACOG Total Reservation Toil Commodity Cost Purchased 110.6840M 69 70,3 013) i i frc44/1) gAi $3 Propane Weighted Average Cos' of Gas (WACOG) LPWacog FY22 11r1or2C21 Date Com • n Invoice Ta •- 59i •in- Gallons Oekvan4 Propane -ate Propane Coat Skipping Cost Taal Coat FYTD Gaeone Cost of In ,, •- Tank Invent 0 Tank Wid1,r WACOG I 09130121 Year End labile $ $5,386.66 5 75,471.10 5 91,385.62 $ 123,092.30 43,984 52,775 61,502 79,090 1.35023 1.43016 10/06121 Targe I 210414341 5757 1.83026 S 15,565.37 5 511.13 S 16,05250 9,757.o 17.516.0 35,112.0 10/0721 Targe 21042091 Targe 21043630 5,731 17.554 1$2276 1 50214 S 15.403.67 5 30,677.35 5 510.85 5 1.029.42,, 5 15.914.52 $ 31,706.77 1.48590 1.55824 1.55845 102021 1073121 MONTHLY INVENTORY ADJUSTMENT 60 i 3.50289 5 315.26 $ 31526 35.202.0 S 123.40755 79,186 1073121 END OF MONTH 3 76,135,75 48,847 30,339 1.55845 S - 35.202 0 35.202.0 S 76,125.71' ' 3 76,125.75 45,847 48,847 1.55845 S - 1.55845 s- 35,202.0 5 76,125.75 45.847 1.55845 $ 35,2020 5 76,125.75 46.841 1.55845 1 - 35,202.0 $ 76,125.75 45,847 1.55845 END OF MONTH $ 76.125.76 49,647 1.55345 FYTD Totals 36,112 1.61430 $ 61,949.39 $ 2,064.40 5 63,703.79 Projections Delivered Delivered Delivered Cost Total EOM Tank EOM Tank Projected Month CGS Cost Gallons Cost of Inventory Gallons Gallons Cost WACOG Oct -21 48,847 $ 76,125.00 1.56 Nov -21 $ 1.75 27,000 $ 47,250.00 $ 123,375.00 75,847 48,847 $ 79,455.99 1.63 Dec -21 $ 1.75 36,000 $ 63,000.00 $ 142,455.99 84,847 48,847 $ 82,012.89 1.68 Jan -22 $ 1.75 48,000 $ 84,000.00 $ 166,012.89 96,847 48,847 $ 83,732.40 1.71 Feb -22 $ 1.75 48,000 $ 84,000.00 $ 167,732.40 96,847 48,847 $ 84,599.67 1.73 Mar -22 $ 1.50 48,000 $ 72,000.00 $ 156,599.67 96,847 48,847 $ 78,984.63 1.62 Apr -22 $ 1.50 36,000 $ 54,000.00 $ 132,984.63 84,847 48,847 $ 76,560.16 1.57 May -22 $ 1.50 36,000 $ 54,000.00 $ 130,560.16 84,847 48,847 $ 75,164.38 1.54 Jun -22 $ 1.50 27,000 $ 40,500.00 $ 115,664.38 75,847 48,847 $ 74,490.20 1.52 Jul -22 $ 1.50 27,000 S 40,500.00 $ 114,990.20 75,847 48,847 $ 74,056.01 1.52 Aug -22 S 1.50 27,000 $ 40,500.00 $ 114,556.01 75,847 48,847 $ 73,776.38 1.51 Sep -22 $ 1.50 27,000 $ 40,500.00 $ 114,276.38 75,847 48,847 $ 73,596.30 1.51 Oct -22 $ 1.50 27,000 $ 40,500.00 $ 114,096.30 75,847 48,847 $ 73,480.32 1.50 Nov -22 $ 1.50 36,000 $ 54,000.00 $ 127,480.32 84,847 48,847 $ 73,391.30 1.50 CSW: 11/17/2021 CLEARWATER GAS SYSTEM NATURAL GAS RATE BILLING FACTORS FOR DECEMBER 1, 2021 - SEPTEMBER 30, 2022 BASED ON APPROVED GAS ADJUSTMENT FACTORS Attachment #4 Interr. Contract Firm Natural Gas Rate Schedules NG Rate NG Rate RS SMF MMF LMF SGS MGS LGS RAC GAC LAC SL SL w/M& NGV NSS IS CNS Relight (Non -Rest) (Non -Rest) 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 $14.00 $25.00 $40.00 $95.00 $25.00 $40.00 $95.00 Rate Rate Rate $20.00 $20.00 By Contract $50.00 $250.00 By Contract (For Central Pasco Territory) ($22.00) ($40.00) ($70.00) ($160.00) ($40.00) ($70.00) ($160.00) Suspended Suspended Suspended ($30.00) ($30.00) (By Contract) ($75.00) ($400.00) (By Contract) Reserved for Reserved for Reserved for Non -Fuel Energy Charge/Therm Future Use Future Use Future Use Non -Fuel Energy Charge $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 $0.24 By Contract Energy Conservation Adj. (ECA) 0.17 0.17 0.17 0.17 0.17 0.17 0.17 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 -0_01 -0_01 -0.01 0.05 0.05 0.05 NA NA NA NA NA NA NA NA NA Total Non -Fuel Energy Charge $0.61 $0.61 $0.61 $0.61 $0.61 $0.57 $0.53 NA NA NA $0.20 $0.35 By Contract $0.38 $0.24 By Contract Purchased Gas Adjustment (PGA) 0.76 0/6 0/6 0.76 0.76 0.76 0.76 NA NA NA 0.76 0.76 By Contract 0.76 0.67 0.67 Total Energy Charge/Therm 1.37 1.37 1.37 1.37 1.37 1.33 1.29 NA NA NA 0.96 1.11 By Contract 1.14 0.91 0.67 + Non -Fuel Minimum Monthly Bill $14.00 $25.00 $40.00 $95.00 $25.00 $40.00 $95.00 NA NA NA $20.00 $20.00 By Contract $50.00 $250.00 Customer (For Central Pasco Territory) ($22.00) ($40.00) ($70.00) ($160.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.25 $ 1.25 $ 1.25 $ 1.25 $ 1.25 $ 1.22 $ 1.18 NA NA NA $ 0.88 $ 1.02 NA $ 1.04 $ 0.83 with 6.0% Franchise $ 1.33 $ 1.33 $ 1.33 $ 1.33 $ 1.33 $ 1.29 $ 1.25 NA NA NA $ 0.93 $ 1.08 NA $ 1.11 $ 0.88 Utility Tax Note: Fuel Rate per Therm 10/01/1973 $0.069 $0.069 $0.069 $0.069 $0.069 $0.069 $0.069 NA NA NA $0.069 $0.069 $0.069 $0.069 $0.055 $0.069 Non -Utility Taxable Fuel/Therm $0.691 $0.691 $0.691 $0.691 $0.691 $0.691 $0.691 NA NA NA $0.691 $0.691 ($0.069) $0.691 $0.615 $0.601 BTU FACTOR = THERMS/100 CUBIC FEET (CCF) 10/2021 11/2021 12/2021 01/2022 02/2022 03/2022 04/2022 05/2022 06/2022 07/2022 08/2022 09/2022 Firm Service Rates 1.045 1.046 1.046 Interruptible Service Rates 1.025 1.025 1.025 FY 21/22 Avg. 1.046 1.025 CSW:11/17/2021 BTU Factor: BTU Factor: Therm Factor: 2.714 Gallons/100 cubic feet (CCF) 2.483 Therms/100 cubic feet (CCF) 0.915 Therms/Gallon RESIDENTIAL MRLP Applicable Annual Gallon Range NA or Other Rate Determinant (1 - 3 Units) Monthly Customer Charge Non -Fuel Energy 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 CLEARWATER GAS SYSTEM METERED PROPANE (LP) RATE BILLING FACTORS FOR DECEMBER 1, 2021 - SEPTEMBER 30, 2022 BASED ON APPROVED GAS ADJUSTMENT FACTORS MULTI -FAMILY LOOP RESL. MMLP LRLP NA NA (4 + Units) SMALL COML. LARGE COML. MGLP MLLP 0 - 2,500 $14.00 $25.00 $14.00 $25.00 For Each Meter $1.90 0.17 0.01 -0.01 $1.90 $0.90 $0.30 0.17 0.17 0.17 0.01 0.01 0.01 -0.01 -0.01 0.13 $2.07 $2.07 $1.07 $0.61 2.25 2.25 2.25 2.25 $4.32 $4.32 $3.32 $2.86 $14.00 $25.00 $14.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.17 0.01 0.13 $0.56 2.25 $2.81 $40.00 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.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:11/17/2021 BTU Factor: BTU Factor: Therm Factor: 2.714 Gallons/100 cubic feet (CCF) 2.483 Therms/100 cubic feet (CCF) 0.915 Therms/Gallon STANDARD RESIDENTIAL BULK LP SERVICE (Rate Class is Based on Annual LP Gallon Usage Level) BRLPO BRLP1 BRLP2 BRLP3 BRLP4 CLEARWATER GAS SYSTEM BULK PROPANE (LP) RATE BILLING FACTORS FOR DECEMBER 1, 2021 - SEPTEMBER 30, 2022 BASED ON APPROVED GAS ADJUSTMENT FACTORS RESIDENTIAL "WILL CALL" COMMERCIAL BULK LP SERVICE (Based on Annual Usage Level) (Based on Annual Usage Level) WRLPO WRLP1 WRLP2 WRLP3 WRLP4 BCLP1 BCLP2 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 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 Range of Usage Range of Usage Annual Customer Charge $ 375.00 $ 250.00 $ 205.00 $ 115.00 $ 100.00 $ 375.00 $ 235.00 $ 175.00 $ 100.00 $ 85.00 $ 90.00 $ 90.00 Non -Fuel Chartres INFVGailon: 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 $ Energy Conservation Adj. (ECA)/Gal $ 0.17 $ 0.17 $ 0.17 0.17 0.17 0.17 0.17 0.17 0.17 0.17 0.17 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 Usage & Inflation Adj. (UTA)/Gallon (0.01) (0.01) (0.01) (0.01) (0.01) (0.01) (0.01) (0.01) (0.01) (0.01) 0.13 Total Non -Fuel Charges (NF)IGaI. $ 1.97 $ 1.97 $ 1.77 $ 1.17 $ 1.07 $ 1.97 $ 1.97 $ 1.77 $ 1.07 $ 0.97 $ 0.66 $ Purchased Gas Adj. (PGA)/Gallon $ 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/Gallon $ 4.22 $ 4.22 $ 4.02 $ 3.42 $ 3.32 $ 4.22 $ 4.22 $ 4.02 $ 3.32 $ 3.22 $ 2.81 $ Note: No Monthly Minimum Bill Utility Tax Note: Fuel Rate per Gallon 10/01/1973 $ 0.161 $ 0.161 $ 0.161 $ 0.161 $ 0.161 $ 0.161 $ 0.161 $ 0.161 $ 0.161 $ 0.161 $ Non -Utility Taxable Fuel/Gallon $ 2.089 $ 2.089 $ 2.089 $ 2.089 $ 2.089 $ 2.089 $ 2.089 $ 2.089 $ 2.089 $ 2.089 $ 2.089 $ 0.20 0.17 0.01 0.13 BULK STANDBY/ GENERATOR LPSB (Closed for New Residental Applications) 420.00 1.00 NA NA NA 0.61 $ 1.00 2.25 $ 2.25 2.76 $ 3.26 0.161 $ 0.161 $ 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 NA Set By Contract 1.95 Cotract NFE + 1.960 0.161 $ 0.161 2.089 $ 2.089 Contract PGA - 0.161 CSW:11/17/2021 ATTACHMENT #6 CALCULATION OF USAGE & INFLATION ADJUSTMENT (UTA) FOR FY 2021/2022 Collected in FY 2021/2022 for Billings Beginning December 1, 2021 Usage Adjustment Calculations: 1. Residential Single -Family Natural Gas Use/Customer: Average Number of Total FY 19/20 Therms Used FY 20/21 Customers Therm Usage Per Customer 24,365 4,842,635.6 198.8 Threshhold for application of UTA per Rate Ordinance = More Than 185 Therefore, Residential Single Family Usage Adjustment = -6.92% Applicable FY 20/21 Total Residential SF Non -Fuel Energy Revenues = $ 2,130,682.38 Reduced FY 21/22 UAI SF Residential Revenues from Usage Overrun = $ (147,443.32) 2. Commercial (Non -Interruptible) Natural Gas Use/Customer: Average Number of Total FY 20/21 Therms Used FY 20/21 Customers Therm Usage Per Customer 2,535 14,086,077 5,556.6 Threshhold for application of UTA per Rate Ordinance = Less Than 5,877 Therefore, Commercial Usage Adjustment = 5.77% Applicable FY 20/21 Total Commercial (Non -Inter.) Non -Fuel Revs = $ 5,370,607.30 Added FY 21/22 UAI Commercial Revenues from Usage Shortfall = $ 309,636.61 Inflation Adjustment Calculations: Actual U. S. Dept. of Labor CPI -U for August 2021 = 263.728 Actual U. S. Dept. of Labor CPI -U for August 2020 = 249.639 CPI -U Inflation Increase Applicable to FY 21/22 Revenues = 5.644% Authorized UTA Recovery for FY 2021/2022: 1. Residential Single -Family Recovery for FY 2021/2022 Usage Portion = Inflation Portion = Subtotal = Less Proj. Over Rec. thru November 2021 = $ (147,443.32) $ 120,250.38 $ (27,192.94) $ (29,800.00) Total = I $ (56,992.94) Projected Therms & Gallons to Recover on for Dec - Sept of FY 21/22 = 4,500,000 Projected Residential UTA Recovery Required = $ (0.013) Recommend Round to = $ (0.01) 2. Commercial (Non -Interruptible) Recovery for FY 2021/2022 Usage Portion = Inflation Portion = Subtotal = Less Proj. Over Rec. thru November 2021 = $ 309,636.61 $ 303,103.63 $ 612,740.24 $ (145,000.00) Total = I $ 467,740.24 Projected Therms & Gallons to Recover on for Dec - Sept of FY 21/22 = 9,900,000 Projected Commercial UTA Recovery Required = $ 0.047 Recommend Round to = $ 0.05 CSW:11/17/2021 CSW:11/17/2021 Attachment #7 Page 1 of3 Residential Rate History By Components Clearwater Gas System Total Rate Adjustments/Therm Contract LP Month NG/therm LP/gallon' ECA RIA# WNA/UTA-Rest# UTA-Coml# PGA PGA PGA/gallon Oct -20 $ 1.44 $ 2.75 $ 0.20 $ - $ 0.09 $ 0.08 $ 0.71 $ 0.61 $ 1.46 Nov -20 $ 1.38 $ 2.70 $ 0.18 $ - $ 0.07 $ 0.13 $ 0.69 $ 0.59 $ 1.45 Dec -20 $ 1.38 $ 2.70 $ 0.18 $ - $ 0.07 $ 0.13 $ 0.69 $ 0.59 $ 1.45 Jan -21 $ 1.32 $ 2.64 $ 0.18 $ - $ 0.07 $ 0.13 $ 0.63 $ 0.53 $ 1.39 Feb -21 $ 1.32 $ 2.64 $ 0.18 $ - $ 0.07 $ 0.13 $ 0.63 $ 0.53 $ 1.39 Mar -21 $ 1.32 $ 2.64 $ 0.18 $ - $ 0.07 $ 0.13 $ 0.63 $ 0.53 $ 1.39 Apr -21 $ 1.32 $ 2.64 $ 0.18 $ - $ 0.07 $ 0.13 $ 0.63 $ 0.53 $ 1.39 May -21 $ 1.32 $ 2.64 $ 0.18 $ - $ 0.07 $ 0.13 $ 0.63 $ 0.53 $ 1.39 Jun -21 $ 1.32 $ 2.64 $ 0.18 $ - $ 0.07 $ 0.13 $ 0.63 $ 0.53 $ 1.39 Jul -21 $ 1.25 $ 2.77 $ 0.18 $ - $ - $ 0.13 $ 0.63 $ 0.53 $ 1.59 Aug -21 $ 1.25 $ 2.77 $ 0.18 $ - $ - $ 0.13 $ 0.63 $ 0.53 $ 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. $ 1.503 : $ 2.850 $ 0.221 $ - $ 0.082 $ 0.085 $ 0.760 $ 0.660 $ 1.548 $ 0.03 $ 0.03 $ - $ - $ 0.13 $ 0.13 $ 0.73 $ 0.73 $ 0.64 $ 0.64 $ 1.99 $ 1.99 Oct -21 $ 1.40 $ 3.22 $ 0.201 $ 0.20 Nov -21 $ 1.40 $ 3.22 Dec -21 $ 1.37 $ 3.42 $ 0.17 $ 0.01 $ (0.01) $ 0.05 $ 0.76 $ 0.67 $ 2.25 Jan -22 Feb -22 Mar -22 Apr -22 May -22 1 Jun -22 Jul -22 Aug -22 Sep -22 FYTD 21/22 Av $ 1.390 $ 3.287 $ 0.190 $ 0.023 $ (0.003) $ 0.103 $ 0.740 $ 0.650 $ 2.077 2021 Avg. $ 1.320 $ 2.834 $ 0.183 $ 0.006 $ 0.034 $ 0.123 $ 0.658 $ 0.560 $ 1.612 Incr. Above $ (0.01) $ 0.72 $ (0.01) $ 0.01 $ (0.08) $ (0.08) $ 0.07 $ 0.08 $ 0.80 Last Year Same Month -1% 27% -6% NA -114% -62% 10% 14% 55% Incr. Based $ (0.30) $ 23.61 on 30 Therms -1% 27% Equivalent Cents/KWH 4.7 12.8 for Gas vs. Duke Rate 14.2 14.2 Note: Duke Energy Florida's residential rate for usage >1,000 KWH in November 2021 is 14.226 cents/KWH. (Residential) Gas Cheaper by -67% -10% 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 1 decreased - RS NG Customer Charge increased $2 from $10 to $12/month & NFE rate droped 4 cents to 44 cents/therm. UTA by 9 cents/therm to 0. - BRLP3 LP Customer Charge unchanged @ $90/year, and NFE rate unchanged © $1.00/gallon. UTA decreased by 9 cents/gallon 7 to 0. - RIA & ECA unchanged initially. 1 1 I 1 CSW:9/27/2021 Attachment #7 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 #7 Page3of3 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 11 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 CaII Ceamater Gas System l' k Greener s ANNUAL ENERGY USAGE AND COST ANALYSIS December 2021 /T'tTAA0.41-- 0 Electric Natural Gas Natural Propane Electric Savings Savi Usage Appliance Type Therms Gas (LP) Gas Cost Natural Gas Kwh COOKING 35 $ 47.95 $ 126.99 $ 112.22 $ 64.27 $ (14.77) 789 WATER HEATING (Tankless) 100 $ 137.00 $ 362.84 $ 341.79 $ 204.79 $ (21.05) 2,403 WATER HEATING (Tank) 150 $ 205.50 $ 544.26 $ 428.14 $ 222.64 $ (116.12) 3,010 CLOTHES DRYING 50 $ 68.50 $ 181.42 $ 183.40 $ 114.90 $ 1.98 1,289 TOTAL (TANKLESS water heater) $ 253.45 $ 671.26 $ 637.41 $ 383.96 $ (33.85) TOTAL (TANK water heater) $ 321.95 $ 852.68 $ 723.76 $ 401.81 $ (128.91) CGS Customer charge $ (168.00) $ (115.00) Net Savings (Tankless Gas & Electric) $ 215.96 $ (148.85) 34% -23% Net Savings (Tankless Gas vs. Tank Electric) $ 302.31 $ (62.49 42% -9°% Furnace & Outside Recreation HOME HEATING POOL HEATING** SPA/HOT TUB HEAT** 130 $ 178.10 $ 471.69 $ 189.08 250 $ 342.50 $ 907.10 $ 213.62 125 $ 171.25 $ 453.55 $ 106.81 * 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 3. LP Gas per gallon (Bulk Bit level 3 or Will Call) 4. Duke Energy Rate (per kwh) $ 1.37 $ 3.32 0.14226 per Therm per Gallon per KWH or or $ 3.63 $ 4.17 per Therm Equivalent per Therm Equivalent Costs based on December 2021 energy charges. Current monthly customer charges are: Duke - $11.52; Peoples Gas - $30-82; Clearwater Gas - $14 (natural gas only) and $22 in Central Pasco. L.P. customers are billed annually - $75 to $210 (non-refundable depending on program). CSW:11/30/2021 BTU Factor: BTU Factor: Therm Factor: 2.714 Gallons/100 cubic feet (CCF) 2.483 Therms/100 cubic feet (CCF) 0.915 Therms/Gallon CLEARWATER GAS SYSTEM METERED PROPANE (LP) RATE BILLING FACTORS FOR DECEMBER 1, 2021 - SEPTEMBER 30, 2022 BASED ON APPROVED GAS ADJUSTMENT FACTORS Attachment #5 Page 1 of 2 RESIDENTIAL MULTI -FAMILY LOOP RESL. SMALL COML. LARGE COML. VEHICLE STANDBY/GENERATOR CONTRACT MTRD MRLP MMLP LRLP MGLP MLLP LPV LPSM CLP (Non -Rest. Only) (Non -Rest. Only) Applicable Annual Gallon Range NA NA NA 0 - 2,500 >2,501 NA NA NA or Other Rate Determinant (1 - 3 Units) (4 + Units) (Closed for New Resl. Applications) Monthly Customer Charge $14.00 $25.00 $14.00 $25.00 $40.00 $40.00 $50.00 Set By Contract For Each Meter Non -Fuel Energy Charges/Gallon: Non -Fuel Energy Charge (NFE)/Gallor $1.90 $1.90 $0.90 $0.30 $0.25 Set By Contract $1.00 Set By Contract Energy Conservation Adj.(ECA)/Gallor 0.17 0.17 0.17 0.17 0.17 NA NA NA Regulatory Imposition Adj.(RIA)/Gallor 0.01 0.01 0.01 0.01 0.01 NA NA NA Usage & Inflation Adj. (UTA)/Gallon -0_01 -0_01 -0_01 QQ Q,Q5 NA NA NA Total Non -Fuel Charges (NF)/Gal. $2.07 $2.07 $1.07 $0.53 $0.48 Set By Contract $1.00 Set By Contract Purchased Gas Adjustment(PGA)/Gal. 2.25 2.25 2.25 2.25 2.25 Set By Contract 2.25 1.95 Total Energy Charges/Gallon $4.32 $4.32 $3.32 $2.78 $2.73 Contract NFE $3.25 Contract NFE + + Contract PGA $1.950 Customer Charge Customer Charge + Minimum Monthly Bill $14.00 $25.00 $14.00 $25.00 $40.00 Any Applicable $50.00 Non -Fuel Energy Chg. Customer Charge for the Contracted + Any Applicable # of Gallons/Mo. Facility Charges Utility Tax Note: Fuel Rate per Gallon 10/01/1973 0.161 0.161 0.161 0.161 0.161 0.161 0.161 Non -Utility Taxable Fuel/Gallon $2.089 $2.089 $2.089 $2.089 $2.089 Contract PGA - 0.161 $2.089 0.161 Contract PGA - 0.161 CS W:11 /30/2021 BTU Factor: BTU Factor: Therm Factor: 2.714 Gallons/100 cubic feet (CCF) CLEARWATER GAS SYSTEM 2.483 Therms/1O0cubic feet (CCF) BULK PROPANE (LP) RATE BILLING FACTORS 0.915 Therms/Gallon FOR DECEMBER 1, 2021 - SEPTEMBER 30, 2022 BASED ON APPROVED GAS ADJUSTMENT FACTORS STANDARD RESIDENTIAL BULK LP SERVICE (Rate Class is Based on Annual LP Gallon Usage Level) BRLPO BRLP1 BRLP2 BRLP3 BRLP4 RESIDENTIAL "WILL CALL" (Based on Annual Usage Level) WRLPO WRLP1 WRLP2 WRLP3 WRLP4 Applicable Annual Gallon Range 0 (No Fills in Yr.) 0.1 - 60 60.1 - 120 120.1 - 300 > 300 0 (No Fills in Yr.) 0.1 - 60 60.1 - 120 120.1 - 300 > 300 or Other Rate Determinant 1-3 UNITS 1-3 UNITS 1-3 UNITS 1-3 UNITS 1-3 UNITS 1-3 UNITS 1-3 UNITS 1-3 UNITS 1-3 UNITS 1-3 UNITS Annual Customer Charge $ 375.00 $ 250.00 $ 205.00 $ 115.00 $ 100.00 $ 375.00 $ 235.00 $ 175.00 $ 100.00 $ 85.00 Non -Fuel Charges (NF)/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 Energy Conservation Adj. (ECA)/Gal $ 0.17 $ 0.17 $ 0.17 0.17 0.17 0.17 0.17 0.17 0.17 0.17 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 Usage & Inflation Adj. (UTA)/Gallon (0.01) (0.01) (0.01) (0.01) (0.01) (0.01) (0.01) (0.01) (0.01) (0.01) Total Non -Fuel Charges (NF)/Gal. $ 1.97 $ 1.97 $ 1.77 $ 1.17 $ 1.07 $ 1.97 $ 1.97 $ 1.77 $ 1.07 $ 0.97 Purchased Gas Adj. (PGA)/Gallon $ 2.25 $ 2.25 $ 2.25 $ 2.25 $ 2.25 $ 2.25 $ 2.25 $ 2.25 $ 2.25 $ 2.25 Total Energy Charges/Gallon $ 4.22 $ 4.22 $ 4.02 $ 3.42 $ 3.32 $ 4.22 $ 4.22 $ 4.02 $ 3.32 $ 3.22 Note: No Monthly Minimum Bill Utility Tax Note: Fuel Rate per Gallon 10/01/1973 $ 0.161 $ 0.161 $ 0.161 $ 0.161 $ 0.161 $ 0.161 $ 0.161 $ 0.161 $ 0.161 $ Non -Utility Taxable Fuel/Gallon $ 2.089 $ 2.089 $ 2.089 $ 2.089 $ 2.089 $ 2.089 $ 2.089 $ 2.089 $ 2.089 $ COMMERCIAL BULK LP SERVICE BULK STANDBY/ (Based on Annual Usage Level) GENERATOR BCLP1 BCLP2 LPSB (Closed for 0 - 2,500 > 2,500 New Residental Customers in this Customers in this Applications) Range of Usage Range of Usage $ 90.00 $ 90.00 $ 420.00 $ 0.25 $ 0.20 $ 1.00 0.17 0.17 NA 0.01 0.01 NA 0.05 0.05 NA $ 0.48 $ 0.43 $ 1.00 $ 2.25 $ 2.25 $ 2.25 $ 2.73 $ 2.68 $ 3.25 0.161 $ 0.161 $ 2.089 $ 2.089 $ Attachment #5 Page 2 of 2 CONTRACT BULK LP SERVICE CLP Any Contract Customers Who Requests Bulk Del. Set by contract 0.161 $ 0.161 $ Set By Contract NA NA NA Set By Contract 1.95 Cotract NFE 1.950 0.161 2.089 $ 2.089 Contract PGA - 0.161