Loading...
GAS ADJUSTMENTS EFFECTIVE APRIL 1, 2020TO: FROM: COPIES: CLEARWATER GAS SYSTEM Interoffice Correspondence Sheet William B. Horne II, City Manager Chuck Warrington, Executive Director Rosemarie Call, City Clerk; Micah Maxwell, Assistant City Manager CGS & UCS Management Teams; Janet Dorrough, Division Controller/CGS; Laura Damico, Senior Systems Analyst/UCS; Kristina Simi, Business Systems Analyst / UCS; Chris Barber, Assistant Customer Service Manager SUBJECT: GAS ADJUSTMENTS EFFECTIVE APRIL 1, 2020 DATE: March 26, 2020 Natural Gas supply prices have dropped this winter such that we are able to recommend that we decrease our Natural Gas Purchase Gas Adjustment (PGA) by 7¢ per therm for April. Propane (LP) supply prices have also dropped this winter such that we are also recommending that we decrease our LP PGA by 13¢ per gallon for March. We recommend that we continue our standard Contract LP PGA at 30¢ below our Standard LP PGA. We are recommending a 2¢ per therm and gallon decrease in our Energy Conservation Adjustment (ECA), but no change in our Regulatory Imposition Adjustment (RIA) nor our Usage & Inflation Adjustments (UIAs) for April. The net effect of these recommended changes for April is a 9¢ reduction (-5.5%) in our typical Residential Natural Gas customer's rate and a 15¢ reduction (-4.9%) in our typical Residential LP customer's rate. Therefore, we are recommending your approval of the following rates to become effective for billings rendered on and after April 1, 2020: Natural Gas Firm Standard Rate Schedule PGA $0.79 per therm (down 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.69 per therm (down 7¢) $1.59 per gallon (down 130) $1.29 per gallon (down 130) $0.24 per therm or gallon (down 20) $0.00 per therm or gallon (no change) $0.09 per therm or gallon (no change) $0.08 per therm or gallon (no change) William B. Horne II, City Manager March 26, 2020 Page 2 Attachment #1 shows the status of our Adjustment Recovery Clause balances with actuals thru February. Our objective is to be as close as practical to balance by FY ending. Attachments #2 and #3 show our annual projections for Natural Gas and LP supply costs, respectively. Attachments #4 and #5 show the impact of these adjustment clause changes on our overall Natural and LP Gas rates, respectively. Attachment #6, Page #1, shows our monthly rate history over the past 3 Y2 years, and Pages #2 and #3 of this show our 18 -year relationship to electric prices and average residential rates, respectively. Please note that Page #2 of this analysis shows that, over the past 18 years, our residential natural gas rates have risen an average of just 1.3% annually as compared to a 3.8% average annual increase for the Duke Energy (formerly Progress Energy Florida/FPC) residential rates. That's 1/3 the inflation in our energy costs on average for natural gas vs. electric --- a remarkable difference! I should point out that the overall effect is that our typical Residential customer rates are now approximately 61% lower than electric for Natural Gas and 21% lower than electric for our typical LP Residential rates. This is a very attractive competitive position vs. electric rates for our Natural Gas customers and these numbers are even lower if the customer uses a tanldess gas water heater, which is what most of our customers are electing. We will continue to track these balances each month, make monthly projections of these factors based on market conditions, and let you know if any of these get significantly out of balance. Additionally, we are making no change in our per gasoline gallon equivalent (GGE) Natural Gas Vehicle (NGV) Fueling Station prices which remain $1.17/GGE --- a remarkable savings from the gas station prices around town and the lowest posted NGV price in the State, and we believe the Southeast U.S. For our City and other governmental fleet vehicles, our price remains $0.99/GGE, as these fleets pay no Federal taxes on fuel --- an even more remarkable price. One of the reason for this low rate is that Congress passed the Tax Extender package thru 2020 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 2020 to provide economic security for NGV conversions. Bill, I would appreciate your approval of these revised adjustment rates so that we can get this information to UCS so that they may make the appropriate adjustments in the billing formulas in time for the April l billings. If you have any questions on this, please call me. CSW/cw Attachments Approved: William B. Horne II, City Manager U:UVIy Documents\MSOFFICE\WINWORD\GASRATES\Gas Adjustments for April 2020.docx CLEARWATER GAS SYSTEM SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTIONS ATTfied /mfiJ r *-! NATURAL GAS PURCHASED GAS ADJUSTMENT (PGA -NG) Monthly Cumulative NG PGA Total NG Fuel Total NG PGA Overage YTD Overage 1 Rate/Therm Cost Center Budget Reservation Commodity Interest Month Charges Charges Expense Expenses Expenses Billed (Shortage) (Shortage) FirmlContr . - $ (59.413.55) Prior Year $ 964,483.92 $ 1,440,660.11 $ 476,176.19 1 $ 416,762.64 0.89/0.79 Oct -19 $ 113,776.17 617,386.56 $ 148.53 $ 233,172.66 1 Nov -19 $ 179,803.29 652,468.67 $ (1,041.91) $ 232,004.36 $ 1,063,234.41 1,505,695.74 $ 442,461.33 $ 859,223.96 0.89/0.79 Dec -19 $ 187,645.00 715,600.62 $ (2,148.06) $ 772,231.07 2 $ 1,673,330.63 1,904,924.95 $ 231,594.32 L$ 1,090,818.28 0.89/0.79 Jan -20 $ 188,894.01 887,096.83 $ (2,727.05) $ 1,181,061.85 3 $ 2,254,325.64 2,038,750.93 $ 1215,574.71) $ 875,243.57 0.89/0.79 Feb -20 $ 176,095.96 689,457.54 $ (2,186.11) $ 221,387.781 $ 1,084,753.17 1,918,308.56 $ 833,555.39 $ 1,708,798.96 0.86/0.76 $ - $ - $ 1,708,798.96 0.86/0.76 Mar -20 Apr -20 $ - $ - $ 1,708,798.96 0.79/0.69 May -20 $ - $ - ~ $ 1,708,798.96 Jun -20 $ - $ - $ 1,708,798.96 $ - $ - $ 1,708,798.96 Jul -20 Aug -20 $ - $ - +$ 1,708,798.96 $ - $ - $ 1,708,798.96 Sep -20 $ - $ - $ 1,708,798.96 t Per13 $ - Total YTD $ 846,214.43 $ 3,562,010.22 $ (7,956.59) $ 2,639,857.72 $ 7,040,127.78 $ 8,808,340.29 $ 1,768,212.51 (1) FY 18/19 Write off of (PGA) $10,389.22 (375.14)WNA) (2) Dividend $525,000 (3) Dividend $950,000 1 PROPANE (LP) GAS PURCHASED GAS ADJUSTMENT (PGA -LPI Cost Center —MonthlyCumulative ` LV FGA Budget Gallons Monthly Interest Commodity Center Total LP Fuel Total LP PGA Overage YTD Overage Therm/Gal. Month Sold WACOG Expense Charges Expenses Expenses Billed (Shortage) (Shortage) $ (94,028.28) Prior Year Oct -19 26,859.8 $ 0.72258 $ 235.07 19,408.35 73,030.13 $ 60,502.45 $ 46,906.28 $ (13,596.17)+ $ (107,624.45)' 1.91/1.75 $ 29,505.97 49,149.97 $ 19,644.00 (87,980.45) 1.91/1.75 Nov -19 28,132.7 $ 0.77328 $ 269.06 21,754.45 7,482.45 Dec -19 29,819.8 $ 0.78992 $ 219.95 23,555.26 7,561.72 $ 31,336.93 52,066.30 $ 20,729.371-$ (67,251.08) 1.91/1.75 Jan -20 45,942.0 $ 0.73044 $ 168.13 33,557.87 22,791.56 7,795.49 7,567.85 $ 41,521.49 80,124.51 $ 38,603.02 $ (28,648.06) 1.91/1.75 $ 30,431.03 56,083.75 $ 25,652.72 �$ 1 (2,995.34) 1.89/1.72 Feb -20 32,331.2+$ 0.70494 $ 71.62 Mar -20 - $ - - $ (2,995.34)4 1.89/1.72 $ - i- $ - $ (2,995.34) 1.74/1.59 Apr -20 - $ - $ - $ (2,995.34), May -20 -4- - Jun -20 1 - $ - _ - $ - $ (2,995.34)i Jul -20 - $ - $ -$ (2,995.34) - - $ - $ - $ (2,995.34)1_ Aug -20 Sep -20 - $ - $ - I $ (2,995.34)+ P13 $ - 1 $ (2,995.34), Total YTD 163,085.5 $ 0.74236 I $ 963.83 $ 121,067.50 $ 103,437.64 $ 193,297.87 $ 284,330.81 $ 91,032.94 _ Cost Center Expenses FY 18/19 Write off PGA (531.18) & WNA (13.82) 544.80 1 --,- iSuburban SuburbanSoftware Systems Support 2,600.00 1 Suburban Software Systems Cloud Rental 3,300.00 1 Depreciation of LP tanks 34,414.23 1 + 1 40,859.03 r CLEARWATER GAS SYSTEM §UMMARY OF RATE ADJUSTMENT CLAUSE COLLECTIONS ENERGY CONSERVATION ADJUSTMENT (ECA) Monthly Cumulative ECA YTD Overage NG/Therm, Budget Cost Center Interest Total ECA Total ECA Overage Month Expenses Notes/Exceptional Items Expense Expenses Billed (Shortage) (Shortage) L LP/Gal. - $ 382,566.43 Prior Year - $ 104,910.39 $ 467,476.82 r . 0.29/0.29 Oct -19 $ 224,921.80 Promo$97,5538;A $0, Employ$74,406, Other $26,053 UCS-4,100,Admin-6,384, SNEP-12,592, Write off -$3,830 $ (906.42) (1) $ 224,015.38 $ 328,925.77 Nov -19 $ 358,796.35 Promo$134,027,Adv $0, Employ$115,010, Other $20,307 UCS-4,100,Admin-6,384, SNEP-78,966 $ (1,168.69) 357,627.66 347,483.35 $ (10,144.31) $ 457,332.51 0.29/0.29 Dec -19 $ 499,790.79 Promo$163,091,Adv $77, Employ$80,725, Other $14,675 UCS-4,100,Admin-6,384, SNEP-230,736 $ (1,143.33) 498,647.46 473,370.89 i $ (25,276.57) $ 432,055.944 0.29/0.29 Jan -20 $ 478,653.69 Promo$246,767,Adv $0, Employ$79,992, Other $30,905 UCS-4,100,Admin-6,384, SNEP-110,506 $ (1,080.14) 477,573.55 525,783.64 $ 48,210.09 $ 480,266.03 0.29/0.29 Feb -20 $ 213,073.72 Promo$74,607,Adv $0, Employ$69,832, Other 56,874 IUCS $4,100 -,Admin $6,384, SNEP $51,277 $ (1,200.67) 211,873.05 433,938.76 $ 222,065.71 $ 702,331.73 0.26/0.26 $ - $ 702,331.73 0.26/0.26 Mar -20 i - Apr -20 - $ - $ 702,331.73 0.24/0.24 May -20 - , $ - $ 702,331.73 $ - $ 702,331.73 3 Jun -20 - - I $ - -$702,331.73 Jul -20 - $ - $ 702,331.73 } Aug -20 Sep -20 - $ - $ 702,331.73 $ - $ 702,331.73 P13 - Total YTD $ 1,775,236.35 $ (5,499.24) $ - $ 1,769,737.11 $ 2,109,502.41 $ 339,765.30 J (1)IFY 18/19 Writeoffrof$3,830.11 REGULATORY IMPOSITION ADJUSTMENT (RIA) (EIA) (ORA) Budget Environmental Regulatory Interest Total RIA Total RIA Overage YTD Overage NG/Therm Expenses Billed(Shortage) (Shortage) LP/Gal. 1-$ Month Expenses Notes/Exceptional Items Expenses Expense Prior Year - - $ 996,944.27 Oct -19 $ 1,563.60 10,600.26 $ (2,492.36) 1 $ 9,671.50 (16.48) $ (9,687.98)+ $ 987,256.29 0.00/0.00 20,812.77 (6.92) $ (20,819.69) $ 966,436.60 0.00/0.00 Nov -19 $ 1,193.33 22,087.58 $ (2,468.14) Dec -19 $ 1,193.33 85,486.80 $ (2,416.09) 84,264.04 (9.65), $ (84,273.69) $ 882,162.91 j 0.00/0.00 113,745.21 (5.76) ' $ (113,750.97) $ 768,411.94 0.00/0.00 Jan -20 $ 1,193.33 114,757.29 $ (2,205.41) Feb -20 $ 1,193.33 1,820.80 $ (1,921.03) 893.10 - i $ (893.10) $ 767,518.84_, 0.00/0.00 - - - $ 767,518.84 0.00/0.00 ' Mar -20 _I$ - $ - $ 767,518.84 0.00/0.00 Apr -20 T - t $ $ 767,518.84 May 20 -- — — — — - $ - $ 767,518.84 Jun -20 - $ -$ 767,518.84 Jul -20 Aug -20 - $ - I $ 767,518.84 Sep -20 - $ - J $ 767,518.84 - $ - 1 $ 767,518.84 P13 $ - - $- $ 767,518.84 229,386.62 (38.81), $ (229,425.43)1 Total YTD $ 6,336.92 $ 234,552.73 $ (11,503.03) t , , r (1) FY 18/19 Write off of $370.27 CLEARWATER GAS SYSTEM SUMMARY OF RATE ADJUSTMENT CLAUSE COLLE$TION4 USAGE AND INFLATION ADJUSTMENT (UTA► Commercial '— Monthly Cumulative UTA YTD Overage ; NG/Therm Budget Interest Overage Month LP Gallons Expense Rate/Gallon NG Therms Rate/Therm (Shortage) (Shortage) LP/Gal $ (742,385.99) Beg. Bal. $ - $ (711,444.52) 0.04/9.04 Oct -19 5,412.6 $ 3,711.93 0.04 885,440.60 0.04 30,941.47 Nov -19 6,542.9 $ 3,557.22 0.04 898,725.40 0.04 32,596.06 $ (678,848.46)4_ 0.04/0.04 $ (635,812.64) 0.04/0.04 Dec -19 6,463.2 $ 3,394.24 0.04 1,166,312.80 0.04 43,035.82 Jan -20 7,050.9 $ 3,179.06 0.04 1,251,256.50 0.04 47,282.98 $ (588,529.67) 0.04/0.04 $ 2,942.65 0.08 1,148,707.80 0.08 86,492.82 $ (502,036.85) 0.08/0.08 Feb -20 6,723.1 $ (502,036.85) 0.08/0.08 Mar -20 Apr -20 $ (502,036.85) 0.08/0.08 May -20 $ (502,036.8 Jun -20 $ (502,036.85) Jul -20 $ (502,036.85)4 $ (502,036.85)+ $ (502,036.85)1 Aug -20 Sep -20 Per 13 Total YTD 32,192.7 16,785.11 5,350,443.10 $ 240,349.14 USAGE AND INFLATION ADJUSTMENT (UTA) Monthly Cumulative UTA ' Residential Budget Interest Overage YTD Overage NG/Therm Expense Rate/Gallon NG Therms RatelTherm (Shortage) (Shortage) _ LPIGa1 Month LP Gallons Beg. Bal. $ - $ (296,142.07) $ 1,480.71 0.03 246,226.50 0.03 $ 6,540.361 $ (289,601.71) 0.03/0.03 Oct -19 21,439.1 $ 1,448.01 0.03 350,402.20 0.03 $ 7,397.17 ' $ (282,204.54) 0.03/0.03_ Nov -19 21,584.4 $ 1,411.02 0.03 448,007.60 0.03 $ 12,738.52 $ (269,466.02f 0.0310.03 Dec-19 23,351.2 Jan -20 f 38,885.7 $ 1,347.33 0.03 516,721.40 0.03 $ 15,338.77 $ (254,127.25) 0.03/0.03 $ 1,270.64 0.09 476,242.10 0.09 $ 42,182.71 $ (211,944.54) 0.09/0.09 Feb -20 25,602.7 $ (211,944.54) 0.09/0.09 Mar -20 $ (211,944.54) 0.09/0.09 Apr -20 _$_._ (211,944.54) May -20 $ (211,944.54) Jun -20 Jul -20 $ (211,944.54) T$ (211,944.54) Aug -20 Sep -20 , $ (211,944.54) Per 13 Total YTD 130,863.1 6,957.71 2,037,599.80 $ 84,197.53 t, Residential $329,457.46, Comerdal $745,646.79 (1 Per Calculation of UM Attachment #7 less FY19 undedover comem -- ----�- CLEARWATER GAS SYSTEM §UMMARY OF RATE ADJUSTMENT CLAUSE COLLECTION4 TOTAL ALL COST RECOVERY ADJUSTMENT CLAUSES (Both PGAs + ECA + RIA+UIA) Monthly Cumulative Total Total Recovery Overage YTD Overage NG/TH (Firm) Total All Budget Month Expenses Billed (Shortage) (Shortage) NG/LP - $ - $ 167,540.81 Prior Year- $ 1,853,957.51 $ 595,284.25 $ 762,825.06 1.21/2.07 Oct -19 $ 1,258,673.26 $ 1,942,315.37 $ 471,134.56 $ 1,233,959.62 1.21/2.07 Nov -19 $ 1,471,180.81 Dec -19 $ 2,287,579.05 $ 2,486,126.82 $ 198,547.77 $ 1,432,507.39 1.21/2.07 Jan -20 $ 2,887,165.90 $ 2,707,275.07 $ (179,890.83) $ 1,252,616.56 1.21/2.07 Feb -20 $ 1,327,950.35 $ 2,537,006.61 $ 1,209,056.25 $ 2,461,672.81 1.21/2.07 $ - $ 2,461,672.81 1.21/2.07 Mar -20 Apr -20 $ - $ 2,461,672.811.12/1.92 $ - $ 2,461,672.81 � May -20 $ - _ $ 2,461,672.81 L Jun -20 $ - _ $ 2,461,672.81 Jul -20 Aug -20 $ - $ 2,461,672.81 $- $ 2,461,672.81 L Sep 20 $ - $ - $ 3,175,654.20 Per 13 - Total YTD 9,232,549.37 11,526,681.38 $ 2,294,132.00 NG NFE TRACKING Actual Actual Actual Annual Strat. Plan Amt. -1-- Budget Therms NFE YTD Total Month Month Beg. Bal. Oct -19 1,934,808.7 976,546.14 976,546.14 (976,546.14) (1,983,005.85) Nov -19 2,038,380.0 1,006,459.71 1,006,459.71 (3,181,857.27) .. Dec -19 2,465,044.1 1,198,851.42 1,198,851.42 1 Jan -20 2,584,097.4 1,267,919.48 1,267,919.48 (4,449,776.75) Feb -20 2,586,292.5 1,232,691.71 1,232,691.71 (5,682,468.46) 4 - Mar -20 Mar -20 - (5,682,468.46) Apr -20 - (5,682,468.46) May -20 - (5,682,468.46) , (5,682,468.46) Jun -20- (5,682,468.46) Jul -20- t (5,682,468.46) Aug -20 - (5,682,468.46, Sep -20 - j Average NFE Rate per therm Total YTD 0.49 11,608,622.7 5,682,468.46 1 i LP NFE TRACKING Actual Actual Actual Annual Budget Gallons NFE YTD Total Strat. Plan Amt. } Month Beg. Bal. Oct -19 26,859.8 41,984.23 ! 41,984 (41,984.23)4 (81,501.63) , Nov -19 28,132.7 39,517.40 r 39,517 Dec -19 29,819.8 58,032.23 58,032 (139,533.86) (195,008.51) 55,475 Jan -20 45,942.0 55,474.65 Feb -20 32,331.2 44,894.88 44,895 (239,903.39) - (239,903.39) Mar -20 Apr -20 - (239,903.39) + May -20 - (239,903.39) (239,903.39) _ Y Jun -20 - (239,903.39) Jul -20 _ _ _ (239,903.39) Aug -20 - (239,903.39) T Sep -20 - Average NFE Rate per gallon 239,903.39 Total YTD 1.47 163,085.5 - CLEARWATER GAS SYSTEM SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTIONS Central Pasco County Natural Gas Sales (PGA -NG) Total NG Fuel Total NG PGA Overage YTD Overage Rate/Therm Budget Commodity Interest Cost Center Month Charges Expense Expenses Expenses Billed (Shortage) (Shortage) Firm/Contr Prior Year - Oct -19 32,708.61 $ - $ 32,708.61 $ 56,613.13 $ 23,904.52 $ 23,904.52 0.89 Nov -19 43,085.62 $ (119.52) $ 42,966.10 $ 56,724.92 $ 71,757.22 59,467.54 92,320.39 $ 16,501.44 $ 35,595.47 $ 40,405.96 $ 76,001.43 0.89 0.89 Dec -19 56,926.95 $ (202.03) 97,964.57 $ 26,207.35 $ 102,208.78 0.89 Jan -20 72,137.23 $ (380.01) Feb -20 72,328.45 $ (511.04) $ 71,817.41 $ - 97,153.37 $ 25,335.96 $ - $ 127,544.74 $ 127,544.74 0.86 0.86 Mar -20 Apr -20 $ - $ - $ 127,544.74 0.79 May -20 $ - $ - $ 127,544.74 Jun -20 $ - $ - $ 127,544.74 Jul -20 $ - $ - $ 127,544.74 Aug -20 $ - $ - $ 127,544.74 + Sep -20 $ - $ - $ 127,544.74 Total YTD $ - $ 277,186.86 $ (1,212.60) $ - $ 275,974.26 $ 403,519.00 j $ 127,544.74 4 Excise Tax Recoup YTD Balance Month Gallons So Revised Gallons Credit Gallons $ (80,310.05)} Feb -15 16,514.00 16,296.28 16,835.00 0.50 $ 8,257.00 $ (72,053.05) _ $8,559.00 $ (63,494.05)) Mar -15 17,118.00 T 16,892.32 17,450.74 0.50 0.50 $ 8,289.00 $ (55,205.05)1 Apr -15 16,578.00 16,359.44 16,900.25 May -15 16,493.00 16,275.56 16,813.59 0.50 $ 8,246.50 ' $ (46,958.55)i_ $ 13,123.50 $ (33,835.05)1 Jun -15 26,247.00 25,900.96 26,757.19 0.50 $ 16,386.00 $ (17,449.05) Jul -15 32,772.00 32,339.94 33,409.03 0.50 Aug -15 29,561.00 29,171.27 30,135.61 0.50 $ 14,780.50 $ (2,668.55) 0.50 $ 14,086.00 $ 11,417.45 Sep -15 28,172.00 27,800.58 28,719.61 $ 14,906.90 $ 26,324.35 Oct -15 29,813.80 29,420.74 30,393.33 0.50 Nov -15 31,458.10 31,043.36 32,069.59 0.50 } $ 15,729.05 1 $ 42,053.40 1 $ 15,207.85 $ 57,261.25 0.50 Dec -15 30,415.70 30,014.70 31,006.93 ,864.40 $ 5 $ 11,533.50 $ 79,659.15 Feb -16 23,067.00 23,333.94 23,603.97 0.50 Mar -16 24,260.90 24,541.66 i 24,825.66 0.50 0.50 0.50 $ 12,130.45 (150,263.27) $ (139,986.42) (34,384.50) $ (22,995.55) $ 91,789.60 $ (48,196.82)' $ (71,192.37)' Apr -16 20,553.70 20,791.56T 21,032.16 May -16 22,777.90 23,041.49' 23,308.14 $ 11,518.60 $ (59,673.77)' Jun -16 23,037.20 23,303.80 23,573.48 0.50 Jul -16 24,123.30 24,402.46 24,684.86 0.50 $ 12,061.65 $ (47,612.12) Aug -16 26,711.50 27,020.62 27,333.31 0.50 (39,030.40) $ (25,674.65) $ (73,286.77) $ 12,725.20 $ (60,561.57) Sep -16 25,450.40 25,744.92 26,042.85 0.50 Oct -16 25,771.80 26,070.04 26,371.73 0.50 $ 12,885.90 ' $ 39,210.25 Nov -16 26,867.40 27,178.32 27,492.84 0.50 $ 13,433.70 $ 52,643.95 (40,486.11) $ (26,782.76) $ 25,861.19 Dec -16 27,406.70 27,723.86 28,044.69 0.50 Jan -17 27,818.40 ' 28,140.33 28,465.98 0.50 $ 13,909.20 $ 39,770.39 Feb -17 26,166.60 26,469.41 26,775.72 0.50 $ 13,083.30 $ 52,853.69 (79,516.51) $ (64,739.01) $ (11,885.32) Mar -17 29,555.00 i 29,897.02 30,243.00 0.50 $ - $ (11,885.32) Apr -17 25,729.20 26,026.95 26,328.14 r$ - $ - $ (11,885.32) $ (11,885.32)* May -17 29,053.40 29,389.62 29,729.73 Jun -17 30,545.00 30,898.48 31,256.05 Jul -17 29,214.60 29,552.68 29,894.68 $ - $ (11,885.32) Aug -17 32,371.00 32,745.61 33,124.55 $ - $ (11,885.32) $ - $ (11,885.32) Sep -17 37,115.60 37,545.12 37,979.60 $ - $ (11,885.32) Oct -17 43,898.10 44,406.11 44,919.99 Nov -17 40,323.00 40,789.63 41,261.67 � $ - 1 $ (11,885.32) t $ (11,885.32)+ Dec -17 39,742.30 40,202.21 40,667.45 �$ $ $ (11,885.32) Jan -18 43,197.80 43,697.70 44,203.39 Feb -18 37,393.70 37,826.43 38,264.18 r $ - $ (11,885.32) $ - 7 $ (11,885.32)1 Mar -18 44,017.00 44,526.38 45,041.66 CLEARWATER GAS SYSTEM ;UMMARY OF RATE ADJUSTMENT CLAUSE COLLECTIONS Apr -18 43,912.00 44,420.17 44,934.21 $- $ (11,885.32) May -18 45,902.80 46,434.01 46,971.36 0.30 $ 13,770.84 $ 1,885.52 - Jun -18 45,346.80 45,871.57 46,402.41 0.30 $ 13,604.04 $ 15,489.56 Jul -18 51,897.12 52,497.69 53,105.22 0.30 $ 15,569.14 $ 16,791.12 $ 31,058.70 $ 47,849 18 Aug -18 • 55,970.39 56,618.10 57,273.31 0.30 Sep -18 46,507.22 47,045.42 47,589.85 0.30 $ 13,952.17 $ 61,801.98 . Oct -18 44,427.86 44,942.00 45,462.08 0.30 $ 13,328.36 $ 75,130.34 Nov -18 39,301.84 39,756.66 40,216.74 0.30 $ 11,790.55 $ 86,920.89 Dec -18 38,048.27 38,488.58 38,933.98 0.30 $ 11,414.48 $ 98,335.37 Jan -19 47,320.00 47,867.61 48,421.55 0.30 $ 14,196.00 $ 11,594.12 $ 112,531.37 Feb -19 38,647.08 39,094.32 39,546.73 0.30 $ 124,125.49 Mar -19 46,514.69 47,052.98 47,597.49 0.30 $ 13,954.41 $ 138,079.90 Apr -19 44,811.95 45,330.53 45,855.11 135,998 0.30 $ 13,443.59 $ 151,523.49 May -19 44,423.25 44,937.33 45,457.37 0.30 $ 13,326.98 $ 164,850.46 Jun -19 37,053.20 37,481.99 37,915.75 $ - $ 164,850.46 Jul -19 45,642.80 46,171.00 46,705.30 $ - $ 164,850.46 Aug -19 43,882.00 44,389.82 44,903.52 $ - $ 164,850.46 Sep -19 39,773.60 40,233.88 40,699.48$ - $ (198,007.91) $ 164,850.46 Oct -19 41,463.00 41,942.83 42,428.20 (198,007.91)1 $ (33,157.45) Nov -19 27,983.90 28,307.74 28,635.33 $ - $ (33,157.45) Dec -19 40,678.40 41,149.15 41,625.34 $ - $ (33,157.45) _ Jan -20 43,094.30 43,593.00 44,097.48 $ - $ (33,157.45), Feb -20 37,063.80 37,492.72 37,926.60 $ - $ (33,157.45)4 $ (33,157.45)} $ - $ (39,733.32j Total YTD $ - $ 2,072,706.17 $ 2,089,880.83 $ 2,119,899.37 $ (541,688.70) 1 CLEARWATER GAS SYSTEM JMMARY OF RATE ADJUSTMENT CLAUSE COLLECTION$ P1 P2 P3 P4 P5 P6 P7 P8 P9 P10 P11 P12 Total Salaries 15,541.97 24,804.27 16,723.28 16,723.98 16,724.14 90,517.64 Special Pay 475.00 35.00 405.00 510.00 1,425.00 Overtime 2,118.05 6,639.26 2,477.12 2,763.56 2,997.88 16,995.87 Life Ins (520100) 0.88 0.88 0.88 0.88 0.88 4.40 Life 1% (520200) 22.00 22.00 22.00 22.00 22.00 110.00 Life SAMP 45.05 45.34 46.72 46.72 46.72 230.55 Maj Medical 1,688.56 1,787.01 1,745.51 1,929.82 1,993.41 9,144.31 Social Security 388.91 649.96 384.77 415.42 422.60 2,261.66 Pension 2,714.54 4,568.05 2,984.99 3,143.09 3,239.74 16,650.41 Workers Comp 95.83 95.83 95.83 95.83 95.83 479.15 Disability 7.82 11.73 7.82 7.82 7.82 43.01 Life Ins CWA 13.39 15.69 14.72 17.03 18.44 79.27 Personal Svc 23,112.00 38,675.02 24,908.64 25,166.15 26,079.46 - - - - - - - 137,941.27 Professional Svc 11,550.00 3,850.00 3,850.00 19,250.00 Contractual 4.49 419.49 518.49 120.49 304.49 1,367.45 Garage 1,406.35 1,378.98 1,352.01 1,351.34 1,181.79 6,670.47 Telephone-Var 211.53 233.62 539.99 290.88 1,276.02 Telephone -Fixed 16.67 16.67 16.67 16.67 16.67 83.35 Postal IT 1,381.67 1,381.67 1,381.67 1,381.67 1,381.67 6,908.35 Utilities -Telephone 30.47 113.66 80.56 195.53 420.22 Utilities -Electric 274.75 215.84 293.04 298.32 378.39 1,460.34 Utilities-Gas/Water 544.21 279.61 274.31 297.79 245.32 1,641.24 Interfund Svc 180.00 180.00 180.00 180.00 180.00 900.00 Interfund-Gen Fd Ops 367.50 367.50 367.50 367.50 367.50 1,837.50 Insurance 180.00 180.00 180.00 180.00 180.00 900.00 Uniforms 107.32 107.32 Travel 4,262.20 1,487.88 910.57 923.31 1,129.38 8,713.34 Mileage 5.24 0.90 6.14 Meals 6.00 5.60 2.80 80.00 94.40 Other Charges 2,325.00 587.24 2,200.00 5,112.24 Operating Supplies 5,637.22 2,656.96 12,704.64 10,343.06 1,281.70 32,623.58 Memberships 1,224.00 8,715.00 1,025.00 1,265.00 12,229.00 Training 716.13 35.00 275.00 1,026.13 Other Charges 16,591.30 10,624.34 39,617.43 23,190.70 12,603.32 - - - - - - - 102,627.09 Svc Fxd Chgs UCS 62,545.83 62,545.83 62,545.83 62,545.83 62,545.83 312,729.15 _,Adm Interfund Svc Chgs-Gen 120,159.17 120,159.17 120,159.17 120,159.17 120,159.17 600,795.85 Dividend 525,000.00 950,000.00 1,475,000.00 MEW" 222,408.30 232.004.38.,,47/2111111111111=11021;387;78 ;'` <: 4 ,' "; 1,,,,...' - - 2,629,083.36 11112Q77,. •. ,, P1 P2 P3 P4 P5 P6 P7 P8 P9 P10 P11 Total Salaries 37,782.18 57,791.44 39,242.74 39,213.49 39,252.13 213,281.98 Special Pay - Overtime 388.64 5,842.30 182.12 249.04 263.85 6,925.95 Commissions 19,256.60 28,453.79 23,943.47 22,779.86 12,778.53 107,212.25 Life Ins (520100) 5.14 5.14 5.14 5.14 5.14 25.70 Life 1% (520200) 24.82 24.82 24.82 24.82 24.82 124.10 Life SAMP 143.94 144.76 149.34 149.34 149.34 736.72 Maj Medical 8,262.22 9,056.75 8,257.69 8,638.67 8,638.67 42,854.00 Social Security 1,265.62 2,030.14 1,381.03 1,371.80 1,160.25 7,208.84 Pension 6,937.83 11,289.94 7,199.18 7,199.18 7,199.18 39,825.31 Workers Comp 287.50 287.50 287.50 287.50 287.50 1,437.50 Disability 33.04 49.56 34.08 54.54 54.54 225.76 Life Ins CWA 18.12 34.53 18.26 18.26 18.26 107.43 Personal Svc 74,405.65 115,010.67 80,725.37 79,991.64 69,832.21 - - - - - - - 419,965.54 Advertising 76.75 - 76.75 CLEARWATER GAS SYSTEM SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTION$ Other Promo 42,432.53 93,752.96 55,401.41 120,966.69 11,381.77 323,935.36 Res ECA 51,625.00 31,875.00 74,250.00 31,600.00 31,225.00 220,575.00 Bldr ECA 3,500.00 8,400.00 33,440.00 94,200.00 32,000.00 171,540.00 Promotional 97,557.53 134,027.96 163,091.41 246,766.69 74,606.77 - - - -- - - 716,050.36 Contractual 2.25 2.25 2.25 2.25 2.25 11.25 Garage 1,059.43 998.31 947.61 2,423.56 5,428.91 Telephone-Var 924.35 163.90 185.99 348.00 (722.29) 899.95 Telephone -Fixed 1,850.00 1,850.00 1,850.00 1,850.00 1,850.00 9,250.00 Postal 5,069.13 6,320.00 5.12 10.84 2.60 11,407.69 IT 1,381.67 1,381.67 1,381.67 1,381.67 1,381.67 6,908.35 Utilities-Gas/Water 26.50 26.50 26.50 26.50 26.50 132.50 Printing 2,158.97 2,524.00 862.02 169.60 1,487.67 7,202.26 Insurance 70.83 70.83 70.83 70.83 70.83 354.15 Uniforms - Travel 30.00 800.04 40.37 870.41 Mileage 64.86 65.47 28.77 80.01 52.90 292.01 Meals 3.00 2.80 1.40 7.20 Other Charges 192.70 192.70 Operating Supplies 71.97 435.40 111.86 25.12 66.94 711.29 Memberships 14,429.04 6,065.00 9,000.00 25,000.00 (9.09) 54,484.95 Training 340.12 122.13 200.00 662.25 Other Svc 26,052.57 20,307.37 14,676.85 30,905.17 6,873.91 -- - - - - - 98,815.87 Adm Svc Fxd Chgs UCS 4,100.00 4,100.00 4,100.00 4,100.00 4,100.00 20,500.00 Interfund Svc Chgs-Gen 6,384.17 6,384.17 6,384.17 6,384.17 6,384.17 31,920.85 Dividend - - SNEP 12,591.77 78,966.18 230,736.24 110,506.02 51,276.66 484,076.87 ,..:atep'.'> ...W.,:3 a -e ¢«M,. "MITA h ��� RIA 2079 P1 P2 P3 P4 P5 P6 P7 P8 P9 P10 P11 P12 Total Interfund Svc Chgs-Gen 1,193.33 1,193.33 1,193.33 1,193.33 1,193.33 5,966.65 Insurance - Dividend - i 5 ._. ORA 2179 P1 P2 P3 P4 P5 P6 P7 P8 P9 P10 P11 P12 Total Salaries 7,302.74 10,923.94 7,560.04 102,116.62 127,903.34 Pay 374.79 374.79 __Special Vacation Leave - Life Ins CWA 0.68 0.68 0.68 0.34 2.38 Life Ins SAMP 30.40 30.40 31.36 15.60 107.76 Medical Ins 1,519.07 1,519.07 1,519.07 1,580.08 144.67 6,281.96 Social Security - Pension 1,662.86 2,494.29 1,721.06 2,139.83 8,018.04 Workers Comp 36.67 36.67 36.67 36.67 36.67 183.35 Insurance 8.33 8.33 8.33 8.33 8.33 41.65 CLEARWATER GAS SYSTEM SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTION* Postage - Travel 1,637.56 1,637.56 Other Charges 1,013.17 74,058.11 8,300.02 (1,013.17) 82,3513.13 Operating Supplies 39.51 71.03 66.49 95.01 806.74 1,078.78 — Memberships - Trainin. r 5990 :i. 484.99 e .;"r w..:. 90 ., ` .+'Sl 1 !+i E': t`r .''} &6''" 6 kz=xg3.�6.4. 1 , -, * 6,564 99 .4-1:7--- ....;.... , 2065 P1 P2 P3 P4 P5 P6 P7 P8 P9 P10 P11 P12 Total Adm Svc Fxd Chgs UCS 2,251.67 2,251.67 2,251.67 2,251.67 2,251.67 11,258.35 Interfund Svc Chgs-Gen 5,144.17 5,144.17 5,144.17 5,144.17 5,144.17 25,720.85 Dividend - .. . 172.01 36,979.20 as of 3/25/2020 0 FTS -1 (Usage) Cost Volume FT8-2 (Usage) Rate Coat Gas Supply (FGU i Interconnects) Volume Rate Cost Fuel 16 FGU Management fee $0.060 No Notice Usage GTI Payment 50.020 Cashout Prior Month Adjustment COMMODITY COST Volume 152,982 179.670 191,019 203,889 159,451 178.789 162.570 160,212 142,580 140,212 140212 Rate $ 0.0539 6 0.0533 5 0.0533 $ 0.0533 $ 0.0533 S 0.0418 S 0 0418 S 0 0418 $ 00418 5 0.0418 S 0 0418 $ 8,248.28 $ 9,576.40 5 10,181.29 $ 10,867.28 $ 10,097.72 $ 7,389.78 5 6,795.43 5 6,698.86 S 5,959.01 S 5,860.86 5 5,860.86 5,917.21 41,788 53,430 55,211 55.211 51,649 55,211 53,430 41.788 40,440 41,788 41,788 40,440 $ 0.0533 $ 2,227.30 $ 0.0533 $ 2,847.82 $ 0.0533 $ 2,942.75 $ 0.0533 S 2,942.75 $ 0.0533 $ 2,752.88 S 0.0415 $ 2,291.26 S 0.0415 $ 2,217.35 S 0 0415 $ 1,734.20 S 00415 S 1,67826 5 0.0415 $ 1,73420 5 0 0415 8 1,734.20 5 0.0415 $ 1,87826 206,768 242,729 254.185 277,331 256,521 239,000 223,000 207,800 188,800 187,600 187,600 188,100 $ 2.8688 5 2.9180 $ 2.8187 $ 2.6318 $ 2.5357 $ 2.4780 S 2.5046 5 2.4978 S 2.5391 $ 2.5418 S 24962 $ 2.5115 $ 596,563.20 $ 706,284.74 5 716,425.55 $ 729,890.80 $ 850.455.90 $ 592,233.70 1 558,581.00 $ 519,033.70 5 479,38100 $ 478,83370 S 488.291 65 S 472.41450 2.44% 2.44% 2.44% 2.44% 2.44% 300% 300% 300% 300% 300% 300% 300% S 12,161.00 $ 13,097.00 $ 14,967.00 8 16,838.00 $ 13,720.00 S 13,92000 S 12.960 00 5 12.120 00 S 10.98000 S 10.92000 S 10,920 00 S 10.92000 5 - $ - S - $ - $ • $ • S - S - S • 5 - $ - S - $ 3,930.80 $ 4,662.00 $ 4,924.60 $ 5,182.00 $ 4,822.00 S 4.64000 5 4,320 00 S 4.040 00 S 3 660 00 5 3,64000 S 3 640 00 5 3.64000 $ (2,236.55) $ 2,792.73 $ (3,692.24) S (8,487.14) $ 2,236.81 5 - S - S S - 5 - 5 - S - 6 40,158.90 S (2,003.25) $ 452.10 $ (14,292.74) $ 2,166.58 S - 5 5 - 5 - S - 5 - 5 - S 663,052.93 $ 739,257.44 $ 746,201.05 $ 742,940.95 $ 686,251.70 S 820,474.74 S 584,873.77 5 543,824.76 $ 501,858.27 5 498,988.78 $ 490446,71 $ 494569.97 141,560 S 00418 'V '1. $ S 93450.98 572,174)Fv�/lK T S 26,78124 2,861134' .*+-.z-`.4.),'714 $ 6,970,38944_ $153,523.00 $0.00 551.10140 (59,386.59) $26,481.59 $7 312,341.05 I 1 981 126 Oct -19 Nov -19 Dec -19 Jan -20 Feb -20 Mar -20 Apr -20 May -20 Jun -20 Jul -20 Aug -20 Sep -20 R E Oct -19 Nov -19 E Dec -19 Jan -20 • Feb -20 ✓ Mar•20 A Apr 2 May -2 j Jun -2 ( Jul - Aug -2 O Sep -2 N To C O Oct -1 ATrj c4M (A) r � CGS Natural Gas Summary Monthly Actual/Projections (FY20) $0.5319 FTS -1 Cost FTS -2 $0.6316 Volume Cost Ne -Notice $0.0479 Volume Cost Capacity RellnquIshment Volume Rate Cost Reservation Adjustments TOTAL RESERVATION COST Total Rate Volume 170,438 306,570 318,789 318,789 296,351 318,789 216.570 144,212 139,560 144,212 144,212 $ 90.636.93 $ 163,033.93 $ 168,468.39 $ 168,468.39 $ 157,599.46 5 168 488.39 5 115.171 93 5 76.691.94 S 74.218.01 S 76,591.94 S 76.69194 74,218.01 41,768 53,430 55,211 55,211 51,849 55,211 53,430 41,788 40,440 41,788 41,788 40,440 $ 26,401.66 $ 33,757.07 $ 34,682.31 $ 34,882.31 $ 32,631.84 S 34.682 31 S 33.757.07 5 26401.68 S 25,549.99 $ 28401.66 5 2640166 3 25,54999 15,500 22,500 31,000 46,500 42,000 31,000 22,500 12,400 10,500 10,850 10,850 10,500 $ 740.90 $ 1,075.50 $ 1,481.80 5 2,222.70 8 2,019.30 S 1,481 000 S 1,07550 S 59272 S 501.90 5 518.63 S 518.63 S 501.90 (13,660) (76,211) (65,031) (91,397) (106,036) (40.000) (40,000) (40,000) (10,000) (10,000) (10.000) (10000) 5 0.2914 5 0.2325 $ 0.2667 8 0.1838 $ 0.1541 S 0 2000 $ 0.2000 5 0.2000 5 0.2000 S 0.2000 S 0.2000 5 02000 $ (4,038.96) 8 (18,167.11) $ (17,348.58) $ (16,794.55) $ (16,338.11) 5 (8.000 00) $ (8,000 00) S (8,000.00) 5 (2,000.00) 5 (2,00000) S (2.000 00) $ (2,000 00). $33.88 $123.90 5159.06 5115.19 $123.47 $000 5000 5000 5000 $000 50.00 $0.00 $ 113,778.17 5 179,603.29 $ 187,645.00 $ 188,894.01 $ 176,095.93 S 198,832.50 S 142,004 50 S 9568632 S 98,28990 $ 101,812.23 S 101,812 23 5 98,28990 60.5320 $0.5909 50.5552 50.5775 60.6201 SO 5422 SO 5624 508041 505444 50.5438 $05438 $05444 139,560 2,652,052 $ $ 1,410,38126 572,174 $ 361499.53 266,100 S 12,79128 Nff.. (514,535) ($104,705.31) $555.25 $1,880,502.01 60.5647 M Nov -19 Dec -19 M Jan -20 O Feb -20 Mar -20 p Apr -2 May -2 ( Jun -2 T Jul -2 Aug -2 Y Sep -2 Iota TOTAL COST Revery & Comm RATE $ 776,829.10 $ 3.72 $ 919,080.73 $ 3.79 $ 933.846.05 5 3.67 8 931,834.96 $ 3.38 $ 862,347.66 5 3.36 $ 817,307.24 $ 3.42 $ 725,875.27 $ 3.28 S 839,311.08 $ 3.08 $ 599,928.17 $ 3.18 $ 800,800.99 $ 3.20 $ 592,058.94 $ 3.16 $ 592,839.87 $ 3.15 $ 8,992,843.06 $ 3.38 Total Projected DTH WACOG Total Reservation Total Commodity Cost Purchased 1st 6Months $ 1,043,048.93 $ 4,198,178.81 $ 5,241,225.74 1,478,534 $3.545 2nd 6 Months S 637,455.08 $ 3,114,18225 $ 3,751.817.33 1,182,900 53.172 TOTAL $ 1,680,502.01 $ 7,312,341.05 $ 8,992,843.06 2,661,434 $3.379 • Propane Weighted Average Cost of Gas (WACOG) FY 2019-20 Arr4c ,Jr 3 325/2020 Date Company Invoice Targe ) Shipping Gallons Delivered Propane Rate Propane Cost Shipping Cost Total Cost FYTD Gallons Cost of Inventory Tank Inventory Tank Wlthdrawl WACOG . 09/30/19 , ,.. '"`. x't_ , °� ,, -, ,- '';."4Y'iii'EW.Tower ... . , of, . $ 31,355.87 46,277 0.67757 10/09/19 Targa 190437691 8,722 0.77445 $ 6,262.40 $ 492.31 $ 6,754.71 8 722.0 S 38 110.58 54 999 0.69293 10/28/19 Terga 190458551 18,308 1,325 0.75414 5 12,773.32 $ 1,033.40 $ 13,806.72 27 030.0 $ 51 917.30 73 307 0.70822 10/31/19 MONTHLY INVENTORY ADJUSTMENT 1.51739 5 2,010.54 $ 2,010.54 28,___355.0. $ 53,927.84 74,832 0.72258 10/31/19 END OF MONTH ["',Wo.•"r:,t • ' 4r(: 4M'-��'f 1 f .f!.;T6 7 'Z;,:. ;;.r. - " µ $ 31,836.30 44,059 30,573 0.72258 11/07/19 Targa 19047513' 8,817 0.80592 $ 6,606.14 $ 499.69 5 7,105834 37 172.0 $ 38 942.13 52 876_ 0.73648 11/08/19 Terga 190477381 8 849 0.80093 $ 8,585.88 S 501.51 $ 7 087.39 46 021.0 $ 48,029.52 61,725 0.74572 11/19/19 Targa 19050156] 17,397 431 0.82332 $ 13,337.31 $ 985.97 $ 14,323.28 63,418.0 3 60,352.80 79,122 0.76278 11/30/19 MONTHLY INVENTORY ADJUSTMENT 2.70097 S 1,164.12 $ 118412 63849.0, S 61,516.92 79.553 0.77328 11/30/19 END OF MONTH 1 ... a% ' �"":;: f54/'''-)' +« `-fir... ' ' "= .' .. ?:..4 � �;'-h' "5' 't` -"i $ 39,657.78 51,285 28.268 0.77328 12/10/19 Targa 190539961 17,990 0.80760 $ 13,51329 S 1,015.44 $ 14.528.73 81,839.0 S 54,186.51 69,275 0.78219 12/18/19 Targa 19055273 8,973 490 0.79257 5 8,605.26 5 508.48 $ 7,111.74 90,812.0 $ 81,298.25 78 248 0.78338 12/31/19 MONTHLY INVENTORY ADJUSTMENT 1.8.3373 S 898.53 $ 898.53 91 302.0 $ 82,196.78 78,738 0.78992 12/31/19 END OF MONTH ;`1; ;� 1}4,0 _ ..* . ' fl' ,. ..,,.e;'-41$* ,+41y:N'Ri S 31.619.74 40,029 38,709 0,78992 01/13/20 Targa 20002919, 9,391 0.71842 S 6,214.50 $ 532.22 S 6,746.72 100,699.0 S 38366.46 49,420 0.77633 01/14/20 Targa 200034521 9.118 0.71092 S 5,965.45 5 516.76 $ 8,482.21 109,811.0 $ 44,848.67 58,538 0.76615 01/27/20 Targa 200051721 9,561 0.63217 S 5,502.36 5 541.86 $ 6,044.22 119,372.0 5 50,892.89 68,099 0.74734 01/28/20 Targa 20005665! 9,180 787 0.64092 $ 6,363.42 $ 520.27 $ 5,883.69 128,552.0 S 58,776.58 77,279 0.73470 01/31/20 MONTHLY INVENTORY ADJUSTMENT 0.31271 S 246.10 $ 246.10 129339.0 3 57,022.68 78,066 0.73044 01/31120 "•". „i, END OF MONTH "lv'Fu11' 1 •>"",t iil,l r. 4-:1�? <„.;'4hi . - r ..-, % t " .* . ,, . ` 4="),'.' S 26,32546 36,041 42,025 0.73044 02/04/20 Targe 20006818 9,129 0.65865 $ 5,493.38 $ 519.47 $ 6 012.85 138,468.0 $ 32,338.71 45,170 0.71593 02/05/20 Tara 20007238 8,916 0.65990 5 5,376.35 $ 507.36 $ 5 883.71 147,384.0 $ 38 222.42 54.086 0.70670 02/1820 Targe 200/0324 16.056 208 0.69301 $ 11,485.52 $ 1,027.45 $ 12512.97 165,440.0 $ 50,735.39 72,142 0.70327 02/29/20 MONTHLY INVENTORY ADJUSTMENT 1.29068 $ 265.88 S 265.88165 848.0 S 51,001.27 72,348 0.70494 02/29/20 END OF MONTH t'* :: sa. « 'r % .4," • 'Q., 7,iai-_ . $ 27,349.70 38.797 33,551 0.70494 03/10/20 Targa 20014260 9,238 0.62399 $ 5,247.18 $ 517.20 $ 5,764.38 174,884.0 $ 33,114.08 48.035 0.68937 03/11/20 Terga 20014737 9,055 0.64899 $ 5,369.63 $ 506.95 S 5,876.58 183,939.0 S 38,990.66 57,090 0.68297 03/23/20 Tama 20018059 17,917 0.53900 S 8,654.13 $ 1,003.10 S 9,657.23 201 858.0 S 48,647.89 75,007 0.64858 FYTO Toab 27.030 0.76066 S 19.035.72 $ 1,626.71 , 9 20.581.43 Projections Delivered Delivered Delivered Cost Total EOM Tank EOM Tank Projected Month CGS Cost Gallons Cost of Inventory Gallons Gallons Cost WACOG Feb -20 , E _ ; , = f., " 38,797 $ 27,349.00 0.70 Mar -20 $ 0.60 35,000 $ 21,000.00 $ 48,349.00 73,797 38,797 $ 25,418.33 0.66 Apr -20 $ 0.65 35,000 $ 22,750.00 $ 48,168.33 73,797 38,797 $ 25,323.34 0.65 May -20 $ 0.65 27,000 $ 17,550.00 $ 42,873.34 65,797 38,797 $ 25,280.13 0.65 Jun -20 $ 0.70 27,000 $ 18,900.00 $ 44,180.13 65,797 38,797 $ 26,050.68 0.67 Jul -20 $ 0.70 27,000 $ 18,900.00 $ 44,950.68 65,797 38,797 $ 26,505.03 0.68 Aug -20 $ 0.70 27,000 $ 18,900.00 $ 45,405.03 65,797 38,797 $ 26,772.94 0.69 Sep -20 $ 0.80 27,000 $ 21,600.00 $ 48,372.94 65,797 38,797 $ 28,522.96 0.74 Oct -20 $ 0.80 36,000 $ 28,800.00 $ 57,322.96 74,797 38,797 $ 29,733.26 0.77 Nov -20 $ 0.80 36,000 $ 28,800.00 $ 58,533.26 74,797 38,797 $ 30,361.04 0.78 Dec -20 $ 0.80 42,000 $ 33,600.00 $ 63,961.04 80,797 38,797 $ 30,712.73 0.79 CSW: 3/26/2020 Applicable Annual Therm Range or Other Rate Determinant Monthly Customer Charge (For Central Pasco Territory) Non -Fuel Energy Charge/Therm 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) CLEARWATER GAS SYSTEM NATURAL GAS RATE BILLING FACTORS FOR APRIL 1, 2020 - SEPTEMBER 30, 2020 BASED ON APPROVED GAS ADJUSTMENT FACTORS Firm Natural Gas Rate Schedules RS SMF MMF LMF SGS MGS LGS RAC GAC LAC SL SL w/M8, NGV NSS Relight (Non -Real) (Non -Real) NA (1 - NA (4 + NA (4 + NA (4 + 0 - 18,000- 100,000 NA (1 - NA (0 - NA (150 NA NA NA NA 3 Units) Units) Units) Units) 17,999 99,999 & up 3 Units) 149 tons) tons & +) Interr. NG Rate IS 100,000 & up $12.00 $25.00 $40.00 $95.00 $25.00 $40.00 $95.00 $12.00 $25.00 $40.00 $20.00 $20.00 By Contract $50.00 $250.00 ($20.00) ($40.00) ($70.00) ($160.00) ($40.00) ($70.00) ($160.00) ($20.00) ($40.00) ($70.00) ($30.00) ($30.00) (By Contract) ($75.00) $400.00 if not prey. if not prey. if not prey. billed billed billed $0.44 $0.44 $0.44 $0.44 $0.42 $0.38 $0.34 $0.20 $0.15 $0.10 $0.20 $0.35 By Contract $0.42 $0.24 0.24 0.24 0.24 0.24 0.24 0.24 0.24 NA NA NA NA NA NA NA NA 0.00 0.00 0.00 0.00 0.00 0.00 0.00 NA NA NA NA NA NA NA 0.09 0.09 0.09 0.09 2.01 0 Q$ 0.08 NA NA NA NA NA NA NA $0.77 $0.77 $0.77 $0.77 $0.74 $0.70 $0.66 $0.20 $0.15 $0.10 $0.20 $0.35 By Contract $0.42 0.79 0.79 0.79 0/9 0.79 0.79 0.79 0.79 0/9 0.79 0/9 0.79 0.69 0.79 Total Energy Charga/Therm 1.56 1.56 1.56 1.56 1.53 1.49 1.45 0.99 0.94 0.89 0.99 1.14 0.69 + Non -Fuel Minimum Monthly Bill $12.00 $25.00 $40.00 $95.00 $25.00 $40.00 $95.00 $12.00 $25.00 $40.00 $20.00 $20.00 By Contract (For Central Pasco Territory) ($20.00) ($40.00) ($70.00) ($160.00) ($40.00) ($70.00) ($160.00) ($20.00) ($40.00) ($70.00) ($30.00) ($30.00) (By Contract) @ premise @ premise @ premise + FAC + FAC + FAC Compares to LP/Gallon Rate of $ 1.43 $ 1.43 $ 1.43 $ 1.43 $ 1.40 $ 1.36 $ 1.33 $ 0.91 $ 0.86 $ 0.81 $ 0.91 $ 1.04 $ with 6.0% Franchise $ 1.51 $ 1.51 $ 1.51 $ 1.51 $ 1.48 $ 1.45 $ 1.41 $ 0.96 $ 0.91 $ 0.86 $ 0.96 $ 1.11 $ Change from 9/2014 Therm Rate $ (0.19) $ (0.19) $ (0.19) $ (0.19) $ (0.18) $ (0.16) $ (0.14) $ (0.15) $ (0.15) $ (0.15) $ (0.15) $ (0.15) $ % Change from 9/2014 Therm Rate -8.4% -8.4% -8.4% -8.4% -8.4% -7.7% -6.9% -8.0% -8.2% -8.4% -8.0% -7.6% Utility Tax Note: Fuel Rate per Therm 10101/1973 50.069 $0.069 $0.069 $0.069 $0.069 $0.069 $0.069 $0.069 $0.069 $0.069 $0.069 $0.069 Non -Utility Taxable Fuel/Therm $0.721 $0.721 $0.721 $0.721 $0.721 $0.721 $0.721 $0.721 $0.721 $0.721 $0.721 $0.721 BTU FACTOR = THERMS/100 CUBIC FEET (CCF) 10/2019 11/2019 12/2019 01/2020 02/2020 03/2020 04/2020 05/2020 06/2020 07/2020 08/2020 09/2020 Firm Service Rates 1.045 1.046 1.047 1.045 1.045 1.047 1.046 Interruptible Service Rates 1.025 1.026 1.026 1.024 1.024 1.027 1.025 NA NA $0.24 0.69 Attachment #4 Contract NG Rate CNS NA By Contract (By Contract) By Contract NA NA NA By Contract 0.69 1.21 0.93 0.69 + Non -Fuel $50.00 $250.00 Customer ($75.00) $400.00 Charge + + FAC + Non -Fuel Therm Non -Fuel Therm Rate for Contract Rate for Contract # of Therms # of Therms 0.63 $ 1.11 $ 0.85 0.67 $ 1.17 $ 0.90 (0.16) $ (0.19) $ (0.20) -9.0% -8.8% -11.5% $0.069 $0.069 $0.055 $0.621 $0.721 $0.635 FY 19/20 Avg. 1.046 1.025 $ (0.16) -11.0% $0.069 $0.621 CSW:3/26/2020 BTU Factor: 2 714 Gallons/100 cubic feet (CCF) BTU Factor: 2483 Therms/100 cubic feet (CCF) Therm Factor: 0.915 Therms/Gallon Applicable Annual Gallon Range or Other Rate Determinant Monthly Customer Charge Non -Fuel Energy Charges/Gallon: Non -Fuel Energy Charge (NFE)/Gallor Energy Conservation Adj.(ECA)/Gallor Regulatory Imposition Adj.(RIA)/Gallor Usage & Inflation Adj. (UTA)/Gallon RESIDENTIAL MULTI -FAMILY MRLP MMLP NA NA (1 - 3 Units) (4 + Units) $12.00 $25.00 $1.90 0.24 0.00 0.09 Total Non -Fuel Charges (NF)/Gal. $2.23 Purchased Gas Adjustment(PGA)/Gal. j Total Energy Charges/Gallon $3.82 Minimum Monthly Bill $12.00 Utility Tax Note: Fuel Rate per Gallon 10/01/1973 Non -Utility Taxable Fuel/Gallon Change from 9/2014 Gallon Rate % Change from 9/2014 Gallon Rate 0.161 $1.429 ($0.35) -8.5% $1.90 0.24 0.00 0.09 $2.23 1.59 $3.82 $25.00 0.161 $1.429 ($0.35) -8.4% CLEARWATER GAS SYSTEM METERED PROPANE (LP) RATE BILLING FACTORS FOR APRIL 1, 2020 - SEPTEMBER 30, 2020 BASED ON APPROVED GAS ADJUSTMENT FACTORS LOOP RESL. LRLP NA $12.00 For Each Meter $0.90 0.24 0.00 $1.23 1.59 $2.82 $12.00 0.161 $1.429 ($0.35) -11.0% SMALL COML. LARGE COML. MGLP MLLP 0 - 2,500 >2,501 $25.00 $40.00 $0.30 $0.25 0.24 0.24 0.00 0.00 0.08 0.08 $0.62 $0.57 7 $2.21 $2.16 $25.00 $40.00 0.161 $1.429 ($0.34) -13.3% 0.161 $1.429 ($0.34) -13.6% 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 1.59 $2.59 $50.00 0.161 0.161 Contract PGA - 0.161 $1.429 NA NA ($0.35) -11.9% Set By Contract NA NA NA Set By Contract 1.29 Contract NFE + $1.290 Customer Charge + Non -Fuel Energy Chg. for the Contracted # of Gallons/Mo. 0.161 Contract PGA - 0.161 NA NA CSW:3126/2020 BTU Factor: BTU Factor: Therm Factor: 2/14 Gallons/1O0 cubic feet (CCF) 2.483 Therms/1O0 cubic feet (CCF) 0.915 Therms/Gallon CLEARWATER GAS SYSTEM BULK PROPANE (LP) RATE BILLING FACTORS FOR APRIL 1, 2020 - SEPTEMBER 30, 2020 BASED ON APPROVED GAS ADJUSTMENT FACTORS Attachment #5 Page 2 of 2 STANDARD RESIDENTIAL BULK LP SERVICE RESIDENTIAL "WILL CALL" COMMERCIAL BULK LP SERVICE BULK STANDBY/ CONTRACT BULK (Rate Class Is Based on Annual LP Gallon Usage Level) (Based on Annual Usage Level) (Based on Annual Usage Level) GENERATOR LP SERVICE 8RLP0 BRLP1 BRLP2 BRLP3 BRLP4 WRLPO WRLP1 WRLP2 WRLP3 WRLP4 BCLP1 BCLPg LPSB CLP (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 80.1 - 120 120.1 - 300 > 300 0 - 2,500 > 2,500 New Residental Any Contract or Other Rate Determinant 1-3 UNITS 1-3 UNITS 1-3 UNITS 1-3 UNITS 1-3 UNITS 1-3 UNITS 1-3 UNITS 1-3 UNITS 1-3 UNITS 1-3 UNITS Customers in this Customers in this Applications) Customers Who Range of Usage Range of Usage Requests Bulk Del. Annual Customer Charge $ 350.00 $ 225.00 $ 180.00 3 90.00 $ 75.00 S 350.00 S 210.00 $ 150.O0 S 75.00 S 60.00 $ 90.00 $ 90.00 $ 420.00 Set by contrail Non -Fuel Charges (NEI/Gallon: Non -Fuel Energy Charge (NFE)/Gal. $ 1.80 $ 1.80 S 1.80 $ 1.00 $ 0.90 $ 1.80 $ 1.80 S 1.60 $ 0.90 $ 0.80 5 0.25 S 0.20 $ 1.00 Set By Contract Energy Conservation Adj. (ECA)/Gal $ 0.24 S 0.24 S 0.24 0.24 0.24 0.24 0.24 0.24 0.24 0.24 0.24 0.24 NA NA Regulatory Imposition Adj. (RIA)/Gal $ $ - $ NA NA Usage & Inflation Adj. (UTA)/Gallon 0.09 0.09 0.09 0.09 0.09 0.09 0.09 0.09 0.09 0.09 0.08 0.08 NA Total Non -Fuel Charges (NF)IGaI. $ 2.13 $ 2.13 $ 1.93 $ 1.33 $ 1.23 $ 2.13 $ 2.13 $ 1.93 $ 1.23 f 1.139 $ 0.57 $ 0.52 $ 1.00 Set By Contract Purchased Gas Adj. (PGA)/Gallon $ 1.59 $ 1.59 $ 1.59 $ 1.59 $ 1.59 S 1.59 $ 1.59 $ 1.59 $ 1.59 $ 1.59 S 1.59 $ 1.59 $ 1.59 1.29 Total Energy Charges/Gallon $ 3.72 $ 3.72 $ 3.52 $ 2.92 $ 2.62 $ 3.72 $ 3.72 $ 3.52 $ 2.82 $ 2.72 $ 2.16 $ 2.11 $ 2.59 Cotract NFE + 1.290 Note: No Monthly Minimum Bill Utility Tax Note: Fuel Rate per Gallon 10/01/1973 $ 0.161 $ 0.161 $ 0.161 $ 0.161 $ 0.181 $ 0.161 $ 0.161 $ 0.161 S 0.181 S 0.181 $ 0.161 $ 0.161 S 0.161 $ 0.161 Non -Utility Taxable Fuel/Gallon S 1.429 $ 1.429 $ 1.429 $ 1.429 S 1.429 $ 1.429 $ 1.429 $ 1.429 $ 1.429 S 1,429 $ 1.429 $ 1.429 S 1.429 Contract PGA -0.181 (0.35) $(0.35) 5 (0.45) $ -14.2%Change from 9/2014 Gallon Rate $ (0.350) 5 (0.350) $ (0.350) S (0.35) S (0.34) $ (0.34) $ (0.35) NA % Change from 9/2014 Gallon Rate -8.6% -8.6% -9.0% -10.7% -11.0% -3.9% -3.9% -9.0% -11.0% -13.6%-13.9% -11.9% NA csw:3/26/2o2o I Attachment #6 i Page 1 of 3 - Residential Rate History By Components System PGA $ 0.79 i Contract PGA $ 0.70 Clearwater Gas i i - -.- 1 Adjustments/Therm Month Total Rate P al on `t LP NG/therm ECA RIA# WNA/UTA-Resl# U1A-Coml#1 $ 0.01 $ 0.01 PGA/ allon _ $ 0.01 $ 1.84 $ 1.84 $ 1.84 ------- -- -- $ 1.69 - - Oct -16 $ 1.48 $ 3.09 $ 0.15 $ 0.09 I Nov -16 $ 1.48 $ 3.09 r $ 0.15$ 0.09 $ 0.01 $ 0.79 $ 0.79 $ 0.76 $ 0.76 $-__0.70 $ 0.70 $ 0.67 $ 0.67 Dec -16 $ 1.48 $ 3.09 $ 0.15 $ 0.09 $ 0.01 $ 0.03 $ 0.03 $ 0.01 $ 0.04 $ 0.04 Jan -17 $ 1.47 $ 2.96 $ 0.15 $ 0.09 $ 0.15-I-3 0.09 Feb -17 $ 1.47 $ 2.96 --r $ 1.69 Mar -17 $ 1.47 $ 2.96 $ 0.15 ' $ 0.09 $ 0.03 $ 0.03 $ 0.04 $ 0.05 $ 0.76 $ 0.79 $ 0.79 $ 0.67 $ 0.70 $ 0.70 $ 1.69 Air -17 $ 1.53 $ 2.79 $ 0.18 t $ 0.09 $ 1.49 May -17 $ 1.53 $ 1.70 $ 2.79 $ 2.71 $ 0.18 $ 0.09 $ 0.20 $ 0.14 $ 0.03 $ 0.03 $ 0.05 $ 0.05 $ 1.49 Jun -17 $ 0.89 $ 0.80 $ 1.34 $ 1.34 Jul -17 $ 1.70 $ 2.71 $ 0.20 $ 0.14 $ 0.03 $ 0.05 $ 0.89 $ 0.80 Aug -17 $ 1.70 $ 2.71 $ 0.20 $ 0.14 $ 0.03 $ 0.05 $ 0.89 $ 0.80 $ 1.34 $ 1.34 Sep -17 $ 1.70 $ 2.71 $ 0.20 $ 0.14 $ 0.03 $ 0.05 $ 0.89 $ 0.80 FY 16/17 Avg. $ 1.559 $ 2.881 $ 0.172 $ 0.107 $ 0.025 $ 0.038 $ 0.816 $ 0.726 $ 1.578 2016 Avg. $ 1.452 $ 2.768 $ 0.167 $ 0.106 $ 0.010 $ 0.010 $ 0.729 $ 0.639 S 1.486 $ 1.99 Oct -17 $ 1.67 $ 3.31 $ 0.20 $ 0.09 $ 0.03 $ 0.05 $ 0.91 $ 0.81 Nov -17 $ 1.67 $ 3.31 $ 0.20 $ 0.09 $ 0.03 i $ 0.05 $ 0.91 $ 0.81 $ 1.99 Dec -17 $ 1.67 $ 3.31 $ 0.20 $ 0.09 $ 0.03 $ 0.05 $ 0.91 $ 0.81 $ 1.99 Jan -18 $ 1.69 $ 3.38 $ 0.25 $ 0.09 $ 0.05 $ 0.03 $ 0.86 $ 0.76 $ 1.99 Feb -18 $ 1.69 $ 3.38 $ 0.25 $ 0.09 $ 0.05 $ 0.03 $ 0.86 $ 0.76 $ 1.99 Mar -18 $ 1.69 5 3.38 $ 0.25 $ 0.09 $ 0.05 $ 0.03 $ 0.86 $ 0.76 $ 1.99 Apr -18 $ 1.69 $ 3.38 $ 0.25 $ 0.09 $ 0.05 $ 0.03 $ 0.86 $ 0.76 $ 1.99 May -18 $ 1.60 $ 1.60 5 3.29 $ 3.29 $ 0.25 $ 0.25 $ 0.04 $ 0.04 $ 0.05 $ 0.05 $ 0.03 $ 0.03 $ 0.82 $ 0.72 $ 0.82 $ 0.72 $ 1.95 5 1.95 Jun -18 Jul -18 $ 1.60 $ 3.29 $ 0.25 $ 0.04 $ 0.05 $ 0.03 $ 0.82 $ 0.72 $ 1.95 Aug -18 $ 1.60 $ 3.29 $ 0.25 S 0.04 $ 0.05 $ 0.03 $ 0.82 $ 0.72 $ 1.95 Sep -18 $ 1.60 $ 3.29 $ 0.25 $ 0.04 $ 0.05 $ 0.03 $ 0.82 $ 0.72 $ 1.95 _ .. FYTD 17/18 Avg. 5 1.648 $ 3.325 * $ 0.238 5 0.069 $ 0.045 $ 0.035 5 0.856 5 0.756 5 1.973 _ 2017 Avg. $ 1.607 $ 2.936 $ 0.184 $ 0.107 $ 0.030 $ 0.048 S 0.846 5 0.753 $ 1.615 Oct -18 $ 1.60 $ 3.29 $ 0.25 5 0.04 $ 0.05 $ 0.03 $ 0.82 $ 0.72 $ 1.95 Nov -18 $ 1.60 5 3.29 S 0.25 $ 0.04 $ 0.05 $ 0.03 5 0.82 $ 0.72 $ 1.95 Dec -18 5 1.60 $ 3.29 $ 0.25 $ 0.04 $ 0.05 $ 0.03 $ 0.82 5 0.72 $ 1.95 Jan -19 $ 1.60 $ 3.29 $ 0.25 $ 0.04 $ 0.05 $ 0.03 $ 0.82 $ 0.72 $ 1.95 Feb -19 $ 1.58 5 3.27 S 0.29 $ - $ 0.03 $ 0.04 $ 0.82 $ 0.72 $ 1.95 Mar -19 $ 1.58 $ 3.27 S 0.29 $ - $ 0.03 $ 0.04 $ 0.82 $ 0.72 $ 1.95 Apr -19 5 1.58 $ 3.27 $ 0.29 $ - $ 0.03 $ 0.04 $ 0.82 $ 0.72 $ 1.95 May -19 $ 1.58 $ 3.27 $ 0.29 $ - $ 0.03 $ 0.04 $ 0.82 5 0.72 5 1.95 Jun -19 $ 1.65 $ 3.07 $ 0.29 $ - $ 0.03 $ 0.04 $ 0.89 $ 0.79 $ 1.75 Jul -19 $ 1.65 $ 3.07 $ 0.29 5 - $ 0.03 $ 0.04 S 0.89 $ 0.79 $ 1.75 Aug -19 $ 1.65 $ 3.07 $ 0.29 $ - $ 0.03 $ 0.04 $ 0.89 $ 0.79 S 1.75 Sep -19 $ 1.65 $ 3.07 $ 0.29 $ - S 0.03 $ 0.04 S 0.89 $ 0.79 5 1.75 J FYTD 18/19 Avg. $ 1.610 $ 3.210 $ 0.277 $ 0.013 $ 0.037 $ 0.037 $ 0.843 $ 0.743 $ 1.883 '----_ _ 2018 Avg. $ 1.630 5 3.320 1 $ 0.250 5 0.057 $ 0.050 5 0.030 5 0.833 $ 0.733 5 1.983 Oct -19 $ 1.65 $ 3.07 $ 0.29 $ - $ 0.03 $ 0.04 $ 0.89 $ 0.79 $ 1.75 Nov -19 $ 1.65 $ 3.07 $ 0.29 $ - $ 0.03 $ 0.04 $ 0.89 $ 0.79 $ 1.75 Dec -19 $ 1.65 $ 3.07 5 0.29 5 - 5 0.03 $ 0.04 $ 0.89 $ 0.79 $ 1.75 Jan -20 $ 1.65 $ 3.07 $ 0.29 $ - $ 0.03 5 0.04 $ 0.89 $ 0.79 $ 1.75 Feb -20 5 1.65 $ 3.07 5 0.26 5 - 5 0.09 5 0.08 $ 0.86 $ 0.76 $ 1.72 Mar -20 $ 1.65 $ 3.07 $ 0.26 $ - S 0.09 $ 0.08 5 0.86 $ 0.76 $ 1.72 Apr -20 $ 1.56 $ 2.92 $ 0.24 $ - $ 0.09 S 0.08 $ 0.79 $ 0.69 $ 1.59 May -20 Jun -20 Jul -20 Aug -20 Sep -20 FYTD 19/20 Avg. $ 1.637 � $ 3.049 5 0.274 5 - 5 0.056 $ 0.057 $ 0.867 $ 0.767 $ 1.719 2019 Avg. $ 1.623 $ 3.155 $ 0.287 $ 0.003 $ 0.032 $ 0.039 $ 0.861 S 0.761 $ 1.833 Incr. Above $ (0.02) $ (0.35) 5 (0.05) 5 - 5 0.06 $ 0.04 $ (0.03) $ (0.03) -4%' 5 (0.36) -18% Last Year Same Month -1% -11% -17% NA 200% 100% -4% Incr. Based S (0.40) $ (7.65) on 20 Therms -1% -11% Equivalent Cents/KWH 5.3 10.9 } for Gas - vs. Duke Rate 13.7 13.7 Note: Duke Energy Florida's residential rate for usage >1,000 KWH in February 2020 is 13.708 cents/KWH. r(Residential) Gas Cheaper � by -61% -21% Notes: Based on Bulk LP (BRLP3) which is applicable for customers us • 120.1 - 300 , allons//ear & equal to Residential LP T _______ Will Call (BRWCLP). _li UTA decreased decreased by 9 cents/gallon I # New rates im ed 11/1/2014, with fol owi , cha , es: - RS NG Customer Charge increased - BRLP3 LP Customer Cha a unchan $2 from $10 to $12/month & NFE rate droped 4 cents to 44 cents/therm. ed $ ear, and NFE rate changed 0 $1.0Wallon�. UlA_ by 9 cents/therm to O. to O. i I- RIA & ECA unchanged initially., Csw:08/26/2019 l (Attachment #6 Page 3 of 3 1 L Rates Residential Annual Average CGS L Fiscal Year Calender Year Year NG/Therm LP/Gallon * Year NG/Therm LP/Gallon * 1995 NA NA FY 95/96 $ 0.880 $ 1.199 $ 1.019 1.370 * * 1996 $ 0.915 $ 1.239 * FY 96/97 1997 $ 1.049 $ 1.380 * FY 97/98 _41-$ $ 1.054 $ 1.318 * * 1998 $ 1.032 $ 1.288 * FY 98/99 $ 1.052 $ 1.152 $ 1.269 $ 1.504 1999 $ 1.073 $ 1.311 FY 99/00 2000 $ 1.222 $ 1.584 FY 00/01 $ 1.551 $ 1.649 2001 $ 1.549 $ 1.586 FY 01/02 $ 1.352 $ 1.488 4_ 2002 $ 1.342 $ 1.553 FY 02/03 $ 1.477 $ 1.817 2003 $ 1.534 $ 1.864 FY 03/04 $ 1.603 $ 1.913 $ 2.162 '- 2004 $ 1.652 $ 1.968 FY 04/05 $ 1.8031 2005 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 1' 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 Average $ 1.513 $ 2.457 $ 1.500 $ 2.368 Notes: * Based on the Residential Metered Propane schedule which was closed for new customers effective March 8, 1999. For 1999 & FY 99/00 and beyond based on Bulk LP (BRLP3) which is applicable for customers using; 120.1 - 300 gallons/year & is equal to Residential LP Will Call CSW:08/26/201 9 Attachment #6 Page 2 of 3 Competitive History of NG vs. Electric Rates Month -Year NG Therm Cost September 2001 $ 1.34 September 2002 $ 1.36 September 2003 $ 1.56 September 2004 $ 1.69 September 2005 $ 1.97 September 2006 $ 1.89 September 2007 $ 1.86 September 2008 $ 2.12 September 2009 $ 1.39 September 2010 $ 1.39 September 2011 $ 1.42 September 2012 $ 1.48 September 2013 $ 1.67 September 2014 $ 1.75 September 2015 $ 1.57 September 2016 $ 1.38 September 2017 $ 1.70 September 2018 $ 1.60 September 2019 $ 1.65 $ Increase over Last 18 Years $ % Increase over Last 18 Years Avg. Annual Inc. Over Last 18 Yrs. NG Equivalent KWH Cost $ 0.046 0.31 $ 23.1% 1.3% 0.046 0.053 0.058 0.067 0.065 0.063 0.072 0.047 0.047 0.048 0.051 0.047 0.047 0.047 0.047 0.058 0.055 0.056 Progress Energy KWH Cost $ 0.084 $ 0.074 $ 0.084 $ 0.089 $ 0.097 $ 0.119 $ 0.120 $ 0.120 $ 0.132 $ 0.136 $ 0.129 $ 0.132 $ 0.123 $ 0.123 $ 0.123 $ 0.123 $ 0.130 $ 0.134 $ 0.142 0.010 $ 22.4% 1.2% 0.058 69.0% 3.8% NG vs. Electric -46% - 37% -37% - 35% -31% -46% -47% -40% - 64% - 65% - 62% -62% -62% - 62% -62% - 62% - 55% - 59% -61% ' \ Clearwater Gas System L=ive Greener with as Fuel Use and Cost Comparison (Effective Rates for April 2020) Want to make the switch to natural gas? Call Clearwater Gas System, today at (727) 562-4980. APPLIANCE ANNUAL THERMS USED NATURAL GAS j PROPANE (LP) GAS ELECTRIC COOKING 35 $ 54.60 $111.65 $140.70 WATER HEATING -Gas Tank Style/Gas Tankless vs. Electric Tank Style 150 / 100 $234.00/$156.00* $478.50/$319.00* $603.00 HEATING 130 $202.80 $414.70 $522.60 CLOTHES DRYING 50 $ 78.00 $159.50 $201.00 TOTAL APPLIANCE USAGE — with tank/tankless $569.40/ $491.40* $1,164.35/ $1,004.85* $1,467.30 GAS SAVINGS VS. ELECTRICITY 61% / 51%* 21%/ 32%* *when using tankless *when using tankless- LP OUTDOOR RECREATION: POOL HEATING* I 250 I $390.00 j $797.50 1 $1,005.00 SPA/HOT TUB HEAT* 1 125 1 $195.00 1 $398.75 *varies according to pool size, weather conditions, and temperature maintained $ 502.50 I I i All other figures are annual average projections based upon the following: 1. 1 therm =100,000 BTUs of energy 2. Natural Gas I $1.56 per therm 3. LP Gas per gallon (BRI -P3) $2.92 per gallon or Per KWH or $3.19 per therm $4.02 per therm 4. Duke Energy per KWH (Based on >1000 KWH rate) $0.13708 1. Notes: The above analysis is based on April 2020 residential energy and fuel charges and does not include applicable taxes or franchise fees. 2. Current monthly customer charges are: Duke Energy $9.66, Peoples Gas $12.00-$20.00 (varies by rate class), Clearwater Gas System $12.00 and $20.00 in Central Pasco. L.P. customers are billed annually, $75-$210 (non-refundable) depending on program. 777 Maple Street • Clearwater, FL 33756 • (727) 562-4980