Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
GAS ADJUSTMENTS EFFECTIVE JUNE 1, 2020
TO: FROM: COPIES: CLEARWATER GAS SYSTEM Interoffice Correspondence Sheet William B. Home II, City Manager Chuck Warrington, Executive Director Rosemarie Call, City Clerk; Micah Maxwell, Assistant City Manage k CGS & UCS Management Teams; Janet Dorrough, Division Controller/CGS; Laura Damico, Senior Systems Analyst/UCS; Kristina Simi, Business Systems Analyst /UCS; Daniel Johnson, Customer Service Manager/UCS; Chris Barber, Assistant Customer Service Manager/UCS RECEIVED JUN 04 2020 OFFICIAL RECORDS AND LEGISLATIVE SRVCS DEPT. SUBJECT: GAS ADJUSTMENTS EFFECTIVE JUNE 1, 2020 DATE: May 27, 2020 Natural Gas supply prices have continued to drop this Spring such that we are able to recommend that we decrease our Natural Gas Purchase Gas Adjustment (PGA) by 8¢ per therm for June. Propane (LP) supply prices have also continued to drop this Spring such that we are also recommending that we decrease our LP PGA by 13¢ per gallon for June. We recommend that we continue our standard Contract LP PGA at 30¢ below our Standard LP PGA. We are also recommending a 4¢ per therm and gallon decrease in our Energy Conservation Adjustment (ECA) based on our current balance, but no change in our Regulatory Imposition Adjustment (RIA) nor our Usage & Inflation Adjustments (UTAs) for June. The net effect of these recommended changes for June is a 12¢ reduction (-7.7%) in our typical Residential Natural Gas customer's rate and a 17¢ reduction (-5.8%) in our typical Residential LP customer's rate. Therefore, we are recommending your approval of the following rates to become effective for billings rendered on and after June 1, 2020: Natural Gas Firm Standard Rate Schedule PGA $0.71 per therm (down 8¢) 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 (ULA) - Residential ... - Commercial $0.61 per therm (down 80) $1.46 per gallon (down 130) $1.16 per gallon (down 130) $0.20 per therm or gallon (down 40) $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 May 27 2020 Page 2 Attachment #1 shows the status of our Adjustment Recovery Clause balances with actuals thru April. Our objective is to be as close as practical to balance by FY ending. Attachments #2 and #3 show our annual projections for Natural Gas and LP supply costs, respectively. Attachments #4 and #5 show the impact of these adjustment clause changes on our overall Natural and LP Gas rates, respectively. Attachment #6, Page #1, shows our monthly rate history over the past 3 3/4 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 1$ years, our residential natural gas rates have risen an average of lust 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 tvnical Residential customer rates are now approximately 65% lower than electric for Natural Gas and 27% lower than electric for our typical LP Residential rates. This is a very attractive competitive position vs. electric rates for our Natural Gas customers and these numbers are even lower if the customer uses a tankless gas water heater, which is what most of our customers are electing. We will continue to track these balances each month, make monthly projections of these factors based on market conditions, and let you know if any of these get significantly out of balance. Additionally, we are 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 June 1't billings. If you have any questions on this, please call me. CSW/cw Attachments Approved: William B. Home II, City Manager U:WIy Documents\MSOFFICE\WINWORIy GASRATES\Gas Adjustments for June 2020.docx CLEARWATER GAS SYSTEM 8UIM1ARY OF RATE ADJUSTMENT CLAUSE COLLECTION NATURAL GAS PURCHASED GAS ADJUSTMENT (P9A-N(31 Budget 1 Resewation Commodity Month _ Charges _ Charges Prior Year Oct -19 $ 113,776.17 Nov -19 i ----179,803.29- Dec-19 $ 187,645.00 Jan -20 $ 188,894.01 Feb 20 $ 176,095.96 Mar -20 $ 184,414.08 $ 130,197.03 APr-20 May -20 Jun -20 Jul -20 -x$-20. Sep -20 Per13 $ Interest ; Cost Center Expense Expenses ; 617,386.56 $ 240.14 $ 233,172.66 852,468.67 $ .-- (950.07) S 232,00438 715,600 82 $ (2.055.99); $ 772,231 07 887,096.83 $ (2,834.75): $ 1,181,081.85 689,457.54 $ (2,095.58) $ 221,387,78 647,368.45 $ (4,179.24) $ 1,167,103.39 493,378.91 $ (3,811.84) $ 216,823.34 l_10_91.111Y - Total NG Fuel 4— Total NG PGA Overage Expenses ; BIU d ( bortagv) i_ __.__ -- ----------'--- ----- $ $ 964,575.53 ! $ 1,440,860.11 $ 476,084.58 $ 1,505,895.74 $ .__442,389.49 $ Cumulative YTD Overage $ 1,063,326.251 $ 1,873,422.70 1,904,924.95. $ 231,502.25 $ 2,254,417.94 1 2,038,750.93 $ (215,867.01); 8 $ 1,084,84570 i 1,918,308.56$ 833,462.88 $ $ 1,994,71068: 1,847,753.66 ' 8 (148, $ 836,587.44 1,382,891.64 $ 546,104.20 $ :$ S - i 2,070,841.42 $ - $ - s 2,070,841.42 (Shoetag.) (98,057.92) 380,028.66 822,396.14 1,053,8898.39 838 231.38 1,671694.24 957.02) $ 1,524,737.21 2,070,841.42 $ - $ 2,070,841.42 . $ - $ 2,070,841.42 .1 $ ! .$ - $ 2,070841.42 .$ Total YTD $ 1,160,825.54 $ 4,702,757.58 $ (15,487.32) $ 4,023,784.45 (1) FY 18!19 Write off of (PGA) $10,389.22 (375.14)WNA) (2)Dividend $525,000 (3)Dividend8950,000 (4) Dividend 8950,000 PROPANE, LP) GAS PURCHASED GAS ADJUSTMENT (PGA -LP) Month Prior Year Oct -19 26,859.8 $ Nov -19 28,132.7 $ Dec -19 29,819.8 $ __Gallons Sold Jan -20 45,942.0 $ 32,331.2 $ 45,439.4 $ 40,041.0 F $ Feb -20 Mar 20 APr20 May -20 Jun -20 Jul -20 Aug -20 S P13 Total YTD__ Monthly WACOG ' $ - $ 2,070,841.42 $ 9,871,886.25 ! $ 12,038,785.59 $ 2,166,899.34 ! Interest Expense Commodity Charges -Cost c$rltbr — Center ' Total LP Fuel Expenses Expenses 0.72258 $ 235.07 + 19,408.35 73,030.13 $ __. 60,50245 ' $ 0.77328 $ 269.06 , 21,754.45 7,482.45 $ 29,505-97 0.78992 $ 219.95 23,555.28 , 7,581.72 $ 31.338.93 0.73044 $ 188.13 0.70494 $ 71.82 0.60352 $ 7.49 i 0.62835 $ 59.07 33,557.87 7,795.49 ' $ 41,521.49 22,791.56 7,567.85 $ 30,431.03 27,423.59 71,28929 $ 98.720.37 25,079.68 i 17,173.81 $ 42,312.38 a $ Monthly : _ CumUtative Total LP PGA Overage YTD Overage BUISd$ (9r4ta.0g28. 28) 4690628 (So1193,644698)..0017)(S(h1o8077,9062e4)4) 49,149.97 52,068.30 $ 20,729.37 $ (67,251.08) 80124.51 - $ _ 38,603.02 $ (28 648.06) 56,083.75 $ 25,652.72 $ ---52,995.34) 78,087.08 $ (20 633.31). $ (23 628.64) 6.8,844.9.0 1 $ 26,332.54 $ 2,703.90 $ - $ 2,703.90 $ - $ 2,703.90 $ . $ 2,703.90 $ - $ 2,703.90 .. - $ .... 2,703.90 ' $ - $ 2,703.90- 248,565.9 $ 0.69829 $ 1,030.39 $ 173,570.76 S 191,900.54 $ 334,330.59 $ Cost Center Expenses FY 18J19 Write off PGA (531.18) 8 WNA (13 829 544.80 1 } P8 -Dividend $63,741 Suburban Software Systems Support 2,600:00_._ . 1 Suburban Software Systems Cloud Rental 3,300.00 1 Depreciation of LP tanks 34,414.23 1 40,859.03 431,062.77.44_ 96,732.18 CLEARWATER GAS SYSTEM _ :i • . _ 1 _ 11. z, -.'11. r„ : ENERGY CONSERYA1ION ADJUSTMENT (ECAI Budget Coat Center Month i Expenses NotesExceptionalItems Prior Year! intinest Expense Promo397 558,Adv S0. Employ$74,406 Other 628,053 , Oct -19 $ 224921.80 IUCS-44100 Asn ,384, $NEP-12,592, Write orr33,a3o j $ (894.73)1 1K0no$134,02r,Adv M. Emplay$115,010, Other 420,307 Nov -19 ' $ 358,796.35 uCS-4,100,Adm1n-6,384. SNEP-78.986 $ (1,158.98) 1Praoi m183.091,Adr S77. EmployS80,725, Other 114.675 Dec -19 $ 499,790.79 !UCS.4,100,Aamin-8.384. SNEP-230,738 ' $ (1,131.59) :Prdno$246,767,Adv S0. Employ$79,992 Other $30$05 Jan -20 $ 478,853.69 UCS4,100,A m:+.8,384, seep -110,506 $ (1,088.37). Promo$74,607,Adv 10, EmployS69,832, Other 56,874 UCS . _ Feb -20 i $ 213,073.72 $4,100 -Admin $6,364, SNEP ss1,2n $ (1,188.86). Plomo$281,912,Adv S0 Erneloy$31,088, Other $7,022 Mar -20 $ 508 989.44 UCS $4,100 -,Admin 16364 SNEP 1147.704 -1 1 (1,744.00); .Pramo$39,035 Adv 10, Employ$68,066. Other 35,426 UCS Apr -20 1 $ 304 317.70 14,100-.Admth 56,384, MEP S181.287 $ (1,531.66); May -20 i Jun -20 1_. Jul -20 .__ Atg-20 Sep -20 P13 } — — Monthly Cumulative Total ECA Total ECA Overage YTD Overage Expanses Bided (Shortage! ' (Shortage) $ 357,892.38 (1) $ 224,027.07 1 $ 328,925.77 $ 104,898.70 $ 462,791.08 357,839.37 347,483.35 $ (10.158.02). $ 452,835.06 498,659.20 r 473,370.89 $ (25,288.314$ 427,348.75 477,585.32 525,783.64 $ 48,198.32 $ 475,545.06 211,884.86 ' 433,938.76 $ 222,053.90 $ 697,598.97 507,245.44 , 422,310.85 $ (84,934.59), $ 812,664.37 302,786.04.'. 293718.13. $ (.9,067.91) $ 803,598.46 — - — ' $ - $ 603,596.46 - $ 803,596.46 I $ - $ 803.596.46 $ $ 6x3,598.46 $ S - $ 803,598A8 - $ 603,596.48 Total YTD, $ 2,588,543.49 (1)JFY 18!19 Write off of $3,830.11 (8,716.18) $.- $ 2,579,827.31 $ 2,825,531.39 $ 245,704.08 F REGULATORY IMPOSITIONWWJUSTMENT (RIA) (E4+) Budget Environmental Month Expenses Notes/Exceptional items Prior Year Oct -19 $ 1,563.60 Nov -19 $ 1,193.33 Dec 19 $ 1,193.33 Jan -20 $ 1.193.33 Feb -20 S 1,193.33 Mar -20 $ 1,193.33 /4)1.4o $ 1,193.33 May -20 Jun -20 Jul -20 Aug -20 Sep -20 P13 (ORA) —.. Regulatory Interest Expenses Expense 10,600.26 $ (2.343.32), 22,087.58 $ (2,318.73) 85,486.80 $ (2,266.31) 114,757.29 $ (2,055.25) 1,620.80 $ (1,770.50)', 1,289.67 $ (1,767.89) 1,324.61 $ (1,788.08) Total RIA Expenses Total RIA Overage YTD Overage Billed (8b iBe) (Shortage) $ - 1 9137,329.78 (1}I $ 9,820.54 ' (18.48) $ (9,837.02) $ 927,492.76 20,962.18 (6.92)l $ (20,969.10)1 $ 908,523.87_ 84,413.82 (9.85) $ (84,423.47) $ 822,100.20 113,895.37 , (5.76) $ (113,901.13), $ 708,199.07 1,043.63 -- - $ (1,043.83) $ 707,155.43 (2) 715.11 (8.68) $ (723.79)' $ 708,431.84 751.88 - $ (751.86) $ k 705,679.78 s - , $ 705,679.78 705,679.78 - $ 705,879.78 - $ 705,879.78 ; $ 705,679.78 $ 705,879.78 Total YTD $ 8,723.58 (1),FY 18/19 Write off of $370.27 $ ._ .. J E { $ 705,879.78 $ 237,167.01 $ _(14,288.08) 231802 51 (47.49) $ (231,650,00): (2) Dividend -$239,844 CLEARWATER GAS SYSTEM USAGE AND INFLATION ADJUSTMENT RBA) Commercial Montle Beg. BaL Oct -19 Nov -19 C Dec -19 Jan -20 Feb -20 Mar -20 Apr -20 May -20 Jun -20 Jul -20 1_ Aag-20 Per 13 Monthly j Cumulative interest iOverage YTD Overage 1 NO Therms Rate/Them (Shortage) (Shortage) i$ - $ (742,385.99) 5,412.6 i $ 3,711.93 0.04 885,440.80 0.04 ' 30,941.47 $ (711,444.52) 6,542.9 F $ 3,557.22 t 0.04 1 898,72540 0.04 1- 32,596.06 $ (678,848.46) 6,483.2 $ 3,394.24 ; 0.04 ' 1,166,312.80 _ 0.04 ,035.. 7,050.9 $ 3,179.06 0.04 + 1,251,25850 _ 0.04 4743,282.9882 i $$ _(58(8358,529.67)81264) 8,723.1 $ 2,942.65 0.08 1,148,707.80 0.08 86,492.82 L $ (502,038.85) 6,541.7 , $ 2,510.18 0.08 1,131,643.60 0.08 F 88,226.154 (413,810.701 6,021.64 $ 2,069.05 0.08 747,562.10 0.08 4 58,179.581 $ 1355,631.12) 1 $ (355,831.12} S-- - (358,831.12) $ _ (355,631.12)_ . $ - ---(-355831.12) $ (355,631.12) LP Gallons' Expense Rate/Gallon Total YTD 44,756.0 21,364.34 1 USAGE AND INFLATION ADJUSTMENT (UTA( Resld4ntlal Budget Month Beg. Bal. Oct -19 Nov -19 Dec -19 Jan -20 Feb -20 Mar 20 Apr -20 May -20 -Jun-20 Jul -20 Aug-i0 Y _ Per 13 1 Interest LP Gallons{Expense Rate/Galion 21,439.1 $ 1,480.71 21,584.4 $ 1,448.01 ',- 23,351.2 23,351.2 $ 1,411.02 38,885.7 $ 1,347.33 25,602.7 $ 1,27064 38,892.3 $ 1,055.93 36,996.1 $ 843.94 0.03 0.03 0.03 0.03 009; 0.09 1 009 7,229,648.80 388,754.87 NG Therms 246,226.50 350,40220 448,007.60 518,721.40 476,242.10 451,949.90 433,792.20 Monthly cumulative Ovsrapa YTD Overage (Shortage) (Shortage) $ $ (298,142.07) 0.03 $ 6,540.36 $ 5289.601.71) 0.03 $ 7,397.17 $ (282,204.54) 0.03 $ _--12,738.52 $ (269.488.02) 0.03 , $ 15 338.77 $ (254,127.25) 0.09 LS 42941.80 $ (211 185.45) 0.09 $ 42 397.42 $ _(188 788.03) 0.09 1 $ 41 554.77 I $ (127,233.28) 1 $ s ((11:77;3333.2266)) 7,23333.26).26) " $ (127,233.261 S _. _(127,233.28) $ (127,233.26) Total YTD206,751.5 8,857.58 2,923,341.90 $ 168,908.81 , (1) Per Calculation of UTA Attachment 87 less FY19 under/over collection, Residential $329,457.46,Commercial S745,646.79 CLEARWATER GAS SYSTEM NNW OF RATE ADJUSTMENT CLAUSE COLLECTION TOTAL ALL COST RECOVERY ADJUSTMENT CLAUSES (Both PGAs + ECA + RIA+UIA) ; Monthly , Cumulative - r Total All Totaleltecineery Oversee i YTD Ovens)* Budtrot 1 Month ' i Expenses (Shanage) (Shortage) Prior Year!, - - $ - $ 66,8W.90 Oct -19 $ 1,258,925.59 $ 1,853,957.51 $ 595,031.92 : $ 661,839.82 Nov -19 i $ 1,47143177 $ 1,942,315 37 5 470,881.60' $ 113252142 Dec -19 I • 5 Z287,832.85 $ Z486126.82 $ 198,294.17 $ 1,330,8{5:5e _ ._•..._ ..... . .. Jan -20 , tI ' $ 2,887420.13 $ 2,707275.07 $ (180,145.06). $ 1,150.670,53 • ________ .._ • Feb -20 _ $ 1,328205.22 $ 2,537,76570 $ 1,209,560A8 $ 2.3812k:01 Mar -20$ 2601,391.60 $ 247176648 $ (122,62514) $ 2237,605.88 ; + . Apr -20$ 1,182,437.70 , $ 1,844,789.02 $ 662,351.32 $ 2,899,957.18 Mat_20 $ - $.. 2,899,957.18 --- Jun -20 1 $ - $ 2,899.957.18 Jul -20 $ - $ 2,899,957.18 I . A49-28 $ - $ 2,899,957.18 Sep -20 . 1 $ Per 13 - $ - $ 2,809,957.18 - $ 3,382,821.56 Total YTOL NG NFE TRACKING Budipt Month Seg,13al. Oct -19 Nov -19 Dec -19 Jan -20 Feb -20 Mar -20 Apr -2Q4 May -20 Jun -20 Jul -20 At_51-20 Sep -20 Total YID 13,017,848.66 15,850,995.94 $ 2,833,349.28 1 Actual 1 Actual Actual Annual Therms NFE YTD Total Stmt. Plan Amt. 1,934,808.7 978,546.14 976.548.14 (976,548.14) 2,038,380.0 1,008,459.71., 1,006,459.71 (1,983,005.85) 2,465,044.1 1.198,851.421,198,851.42 (3.181,857.27) • 1 2,584,097.4 1,287,919.48 1,267,919.48 (4,449,776.75) 2,588,292.5 1,232,891,71 2,491,840.4 1,204,703.62 2,058,479.2 1,028,163.20 't • 1,232,891.71 (5,682,488.46) • 1,204,703.62 (8,887,172.08) 1,028.16120 (7,915,335.28) (7,915,335.28) (7,915,335.28) (7,915,335.28), - _(7,918,335.28) (7,915,335.28) Averogo NFE Rate per therm 0.49 . 16,158,942.3 , 7,915,335.28 • i 1 . i . . LP NFE TRACKING Actual Actual Actual Annual El I A I 6 f_ Gallons , NFE YTD Total StraL Plan Amt. Month L_ Beg. Bal• L___ 41,984.23 41,964 Oct -19 26859.8 (41,984.23)r Nov -19 : 25.132.7 39,517.40 39,517 (51 501 63) Dec -19 1 , 29,819.8 58032.23 58032 (139,533.86y Jan -20 45,942.0474 55475 (195,008.51)4 Feb -20 , 32,3312 55,.65 44,894.88 44,895 g39•903 -3.9i Mar -20 45,439.4 58,714,1558,714 (298,617.54): Apr -20 43,023.1 May -20 Jun -20 Jul -20 Aug -20 Sep -20 59,716.92 59,717 (356,334.46) - (351334.46)_ - (356,334.48) (358,33448). • t (358,334.46), - T (358,334.48)1 Average NFE Rale per gallon Total YTD - 1.42 251,548.0 356,334.46 01000 010000'0 ZL1100160011 $ 09'00x•L91'L t 219LZ1991 $ 1V101 901'00 &Vett', SL'x0t'C99C t 1,415,5000 f 19,04/29 0 041UO0 9 PLZ 01S'P.t 40 0$P1 L69011'90111 t 991Lt9114 0 19'500 001 $ 0111011 9 401 paenpind 1000 91y0410O31001 110100000110101 000VM 1413 P09/911d 11001 oto t zt•6$1801 1 CWC $ L9'6C•t►9 t ICC t 1961e01,9 t 9006 f e6 019'909 t 100 t 41'999.419 $ 910 t ►1'400'119 t 110 t ert08'yP $ U't $ 6$1180411 t 001 $ 00.000C1 f 1800 $ 18.1-0'10 $ tae t 00.00008 $ 1101 s trot0'010 9 a4Y t ol'/CM/ t 3LV41 9..03lmmom% 1909W101 00-19V WAIN 60.9.9 to -••1' 91-000 9r0oN 10100 09010111/0 9111CL'Crt (699Lr000) (0001(4111) 0800 00'4010011 60'114.04 s 001'990 0999813911 1 0961/09, LYL0012 t 041149 9900016 0 90'6101 11111061141 $ S i t .. i i 1 990['0 1 009161 90'849'1 $ '.: s: 1 ' r= . > ItLLB S t .., - 1 .. 109091109 $ 523 ., _ d ,., s +rat • a , 1 ti,, ,. win , 11690 1 000161 00$0411 f ,-. e,_ _ 900004 $ - 1.: 9L'86'9ZS f kw § .-a s . i 00Y90'Ot1 $ trout (»t49Y1) t:: :, 1 0811'x f 000'061 0'011111 1 '. t -.. 99000'9 $ =- 10010810 0 000011 (1199060) $ 601.9 1 1111011a0 091191 t 000010 4001811 r 1 0Z99'0 f 009164 99919'1 $ : r; *.._ , 10.616'1 S $ (18010/) 001.19'LS 1 $ 0900* k ,.�. *. Wssoi0 1 11(960 < ,., .. .'•>., 1 Neat 1 090'010 0x'011'1 f .;_-: . ,.,... ,, 999699 t 4 09119y, 09991000 t 1r114191 $ t»•94910 f Knows s - s 09'118.04 1 %W0 er01.00 1 90000 t 09(001 10'066.0 1 0901 $ 00"0 191990 t 0990-0 9 609180 1816,104 0 1810`01 0 (1891001) $ 500100 t - $ 0018901 f %W0 000440tH t 00180 1 100100 1110181 1 004004 $ 11(19 194111 $ 0001 t 800'011 11./0'0►/ 0 61911 $ 11,00.0 $ 10 01 t - t 00lOttI $ %WC 00000010 $ 4111,0 s 00(900 901911 1 00901 1 609.10 0t00004 t 06.0 t 10(901 18.0.11,1 t (1-801-1) 1 (01.490,) 0 901911 t - s 001064 f %rya menu s inert $ 400.110 900001 $ cram $ turn 60'01101 1 00011 0 80,00 00000'94 1 01191, $ (ra'ouY) 1 11-1-0^* s - s 00.118.00 $ %WZ 61:9010 $ UM $ ONS utast $ 0000'O 1 140/9 0010.04 $ 00990 $ 818111 00040101 $ (900001) $ 011111 $ 0000 t • t 0048001 $ %Win 0114001 $ MOT 1 601000 0,1001 $ 1C0900 $ 00909 009161 t 0000 f 010901 0.090'011 $ 0094.00 $ (91-!001) $ M•Otso $ - $ 00.16101 $ %W0 60'06180 $ 18/00 $ 61100 60'11-1 $ 01900 $ MIS WOWS $ 6118.0 $ 0/1st 60011 010.01 011000 4900 1)641 /u.10A 1003 WV OWONA 1903 9141 .10110A 1909 91a10.11011V Mono 10111094 96000 9.luaus/9u.11 (fpow0w160) l ne.l W00o 960 (.09.41 z -91d 1960.0) t•sLO AL100111900 00018 mod 110 0040NON 0004 009060/9100 191-0' 910-0 100L 99990 0491(91910 10'196 (0001(4111) (999190) 60'114.04 s 001'990 WSW? LOC $ PLIOZS 9040(010.1 $ 1990991 S 1 - s1‘, vd.' R aSr x ,.., ,•19 .a. 523 ., _ d ,., s +rat • a , 1 ti,, ,. win '=x a.>• i :*0 S nh kw § .-a b• . 90106 00Y90'Ot1 $ trout (»t49Y1) t LOPS 0 (1011011 994101 $ ' LMLUY4 39104411 $ 0189u 1&0909 09009001 $ 000011 (1199060) $ 601.9 1 1111011a0 091191 t 000010 4001811 14'99 6099961 1 taste 199109 1116'911 t 401011 (411011) $ 01911 $ (18010/) I0u0a $ 0900* twits 60909 Wssoi0 1 11(960 000909 199111181 9 191111 (618111) 1 9414.0 0 (49(160 01001 s 660 4001100 119.6 09119y, 1 *este 06.0 18'91011 1 18.611 (18lWz0 $ taro f (410001 .1-10(1 9 00010 100611 14'6 61119111 s 011010 swot 010801 1 Brats 11,,1/11) $ taro 0 (11ru) 901001 $ 60600 oo get 0011 0,110'41, 1 006/6 oaeret 119ets41 t o -o (18.1801) $ 01601 $(181'!1) 18101$ 00091 um 9,100'18 18['11 Mali919014 919014 016 001 N 1010 V 4100 0406 9WMoA 1003 wow 00010/11100 O10610A 1000 1100109/0 10001111190110910104,3 .0011t M1 MS 1199141 NOLLVA41343411V101 09109.96 01114 1-100 (NA401919990.1/410900v N109.N Al AMI IWO 11,01.11 SOO 1 A 1 a O w O 3 N 0 ( 1 OL -4001 V 60 -an A Oa -8•3 10 true' 01-990 3 61-01 01-400 3 N Propene weighted Average cost of Gas (WACOG) FY 2019-20 5126/2020 01144 Invoke Oamoeni Tarr, I 164135/15 O.bw Oa9vaa9 Propane Rab Protan. Cast 59114040 Coil TMi Cat PITO Gallons Cast a/ Tank Invanpry Inventory Tank 9Ia M1Wa1 WAcOG 1 $ 31,355.171 40,277 0.57707 110111 10106119 Taro. 19043769 8722 077445 $ 8,282.40 1 492.31 1 8.754.71 4722.0 8 31,110,58: 54599 0.89293 101281/9 Tarp 15045855 15,305 0.75414 f 12.77632 8 1.033.40 5 13.50072 27,030.0 $ 51.917.30 73,307 0.70522 19131/19... _.. t10/31/19 MONTHLY INVENTORY ADJUSTMENT GDOF/10NTN 1,325 1.517393 2 010.54 $ 2010.84 26,355.0 $ 53,927.4 74,832 $ 41,131.20: 44,980 .... . _ 719.617 0,72268, , 0.722;155 11187/19 Tang 19047513 0017 0.80512 9 8,000.14 $ 459.59 $ 7,105.85 37.1735 $ 35,542,13 , 629176 0.73648 11105/19 TNT. 19047738 4849 0.10019 $ 9,505.05 $ 501.51 $ 7.057,39 46,021.0 5 46.029,52 i 61,725 0/4572 11119/19 Tam. 19050156 17,397 431 0.52332 1 13.337.31 1 915.97 $ 14.324.28 53418.0 5 60.352.50 ; 79,122 11/30119 MONTHLY INVENTORYADJUSTMENT 2,70097 1 1,164.12 3 1104,12 63,4400 1 61,516.92 79,553 0.78278 0.77928 11430119 FPD Oa MONTH 5 1 35,457,78 81,316 20258 0.77328 13l/0115 Tama 19053095 17900 8,973 0.80750 5 12,513.29 079257 5 060520 $ 1,015.44 5 500.46 $ 14,52073 $ 7.111.74 51,539.0 90112.0 5 $4.156,51 59.275 1 6129625 70245 0.79219 0. 12/14/10 Tap 19065273 12131/19 MONTHLY NVENTORYADJUSTMENT 490 1.83373 1 595.53 0 NIA 91,302.0 1 52,199,781 76,735 0.78002 12/3159 MID OF MONTH $ 31819.74 40.020 31,705 0.78862 01113120 Tarps 30002019 9,391 0.71642 $ 0214.50 3 532.22 $ 4740.72 100.60.3.0 , $ 36.356.40 4.420 0.77839 01114/20 Taiga 20003452 9,115 071092 $ 5,005.45 $ 515.78 5 6.45021 100511.0 $ 4464057 51538 0.78615 0127120 Tama 20005172 9.551 0.53217 8 5,502.38 1 541.4¢_ $ J.04422,, 11(372.0 $ 50,882.09 1 84090 0.74734 01125120 Tap. 20005063 9,180 054002 $ 5,303.42 8 120.27 9 c59059 125,552.0 $ 56,770.581 77279 0.73470 01/31/20 MONIILY INVENTORY ADJUSTMENT 707 031271 $ 245.10 248.10!... 129.330.0 $ 5702200 1 70006 0.73044 11131020 END OF 64144744 $ $ 25,311.59 38,041 42,591 0.73044 02404120 7.,95 2000581/ 0.129 0.15955 f 5.493.38 f 11047 5 0,012.5 135.468.0 I 1 32,338.71 I 45970 0.71593 0935120 Tap. 20007238 5.915 0.059901 3,376.35 $ 507.35 1 5,803.71 147.304.0 $ 38,222.42 54.059 0.70670 02/11/20 TM9a 20010324 15.066 0.69301 $ 11,488.52 8 1,027.45 $ 12.512.97 185,440.0 8 30735.591 72.142 0.70327 02129120 510447119 071151705Y ADJUSTMENT 208 1 88te 8 265.88 $ 246.65 159,645.0 $ 51,001.27 i 72.348 0.70494 02129/20 BO OFMONTN $ 2.345.70' 35,797 33,861 0.70494 03/10120 Ta . 001 9,236 0.52359 8 5,247.18 8 517.20 8 5.744.38 174,904,0 5 33,114.06: 40.035 0,88937 03111/20 7a198 9055, 064596 $ 5,3119.63 $ 505.05 $ 5,87.51 /9339.0 8 38990.05 57.000 0.88297 03/23020 T 20016059 17,917 0.53800 8 8154.13 8 1,003.10 3 9,597.23 201,856.0 1 46.04769 75,007 0.64858 03/31/10 MONTHLY INVENTORY ADJUSTMENT 852 1.07943 $ 930.47 $ 930.47 200,7100 $ 49,578.35 i 76.559 0.85347 03131420 END OF MONTH ` :. $ 14,67158 ? 22.398 53,181 0.88347 041031200 Tarp 20018275 8,157 0,48182 3 3,907.75 1 504.25 8 4.412.00 211,875.0 8 16.90E66 ; 31,456 0.80352 04113/20 Taro. 20019482 0,702 062336 8 3954.19 8 1,470.18 1 5,424.37 220.577.0 $ 24,41465 ; 40.187 280781 04/14120 TIM 20919029 0.700 0.64835 8 4,170.78 8 1,460.54 $ 0849.52 229377,0 3 30054.67. 44,557 0,31503 04/23020 Tars. 20020617 5,799 055335 8 410224 $ 1,46.57 8 5,74081 235 070.0 1 36,503.48 , 57,559 0.82088 04/3740 Tape 20020645 0,505 0.65335 $ 4.205,63 3 1,457.76 8 0753.39 246182.0 8 41,516.57: 59,472 0.82518 04/30110 MONTHLY ONEMVORYADJUSTMENT 30 32290 I 9063 1 50.63 240,912.0 8 41,853.50? 00.502 0.82635 04/30120 510 OF MONTH $ 15,673!64 25,451 40,041 0,82536 0511E20 Tarn 20033300 0601 017903 3 4.2724 8 1.455.93 8 0913.17 255,713.0 4 22,557.01.' 35,222 0.83970 05/13/20 Tarty 20023591 8,101 08733 8 4,841.95 8 1,430.39 6 0010.44 204,414.0 $ 24537.4 1 43,063 0.84912 FV7D Totals 242.791 059430 8 180,94011 8 17.945.04 8 100519.10 Delivered Delivered Delivered Month CGS Cost Gallons Cost Apr -20 May -20 $ 0.70 35,000 $ 24,500.00 Jun -20 $ 0.70 27,000 $ 18,900.00 Jul -20 $ 0.70 18,000 $ 12,600.00 Aug -20 $ 0.70 18,000 $ 12,600.00 Sep -20 $ 0.70 27,000 $ 18,900.00 Oct -20 $ 0.70 36,000 $ 25,200.00 Nov -20 $ 0.80 36,000 $ 28,800.00 Dec -20 $ 0.80 48,000 $ 38,400.00 Projections Cost of Inventory $ 41,073.00 $ 36,583.29 $ 30,707.23 $ 30,875.43 $ 37,275.54 $ 43,649.86 $ 47,291.84 $ 58,434.73 Total Gallons 61,481 53,461 44,481 44,461 53,461 62,461 62,461 74,461 EOM Tank Gallons 26,461 26,461 26,461 26,461 26,461 26,461 26,461 26,461 26,461 EOM Tank Cost $ 16,573.00 $ 17,683.29 $ 18,107.23 $ 18,275.43 $ 18,375.54 $ 18,449.86 $ 18,491.84 $ 20,034.73 $ 20,765.79 Projected WACOG 0.63 0.67 0.68 0.69 0.69 0.70 0.70 0.76 0.78 CSW: 5/27/2020' CLEARWATER GAS. SYSTEM NATURAL GAS RATE BILLING FACTORS FOR JUNE 1, 2020 - SEPTEMBER 30, 2020 BASED ON APPROVED GAS ADJUSTMENT FACTORS Atteehment V4 Interr. Cantract. Firm Natural Gas -Rate Schedules Naaate NG Ra$ _BE jalE AIME JAL SGS MOS LOS RAC ._O_Ag__ 'LAC SL SL WM& ARV_ NS& IS CNS Retioht (Non -Real) .(14ort-Rail) Applicable Annual Therm Range NA (1 - NA (4 + NA (4 + NA (4 0 - '10,000- 100.00Q NA (1 - NA (0 - NA (150 NA NA NA NA 100,000 NA or bther-Rate.Detenninant 3 Units) Unit) Unite) Units) 17,999 99,999. & up 3 Units) 149 tons) tenS & 4-) & uri MonthlyOustorner Chortle 5.1,00 .35.00 $4000 595.00 52500 -540.00 595.00 5(2.00 525:00. $40.00 .5200 520.00- By Contract 55000 $250.00 By Contrail (Ft*. Central Pasco TerritOry) (22om) ($40.00) ($7000)(S16000) (54000) (570.00). ($160,00). (520-00) (540,00) (570.90 (530.00) ($30.00) (By Contract) (575.00) $400.00 /By Contract) if not.mev. if not prey, it.not pray. Nox-ttiol Eiterav Chinn/Shaun trilled Wert .bilked Non -Fuel- Energytharge 50.44. 5044 '50.44 .80:44 50.42 ‘50.38 $0.34 $020 S0:5 $0.10 50;20 - 50.35 Ely Cantract. 50.42 50:24 By Contract Energy Conservation Adj. (ECA) 13:20' 0:23 0.20 020 0,20 0:20 '020 144 NA NA NA NA NA 'NA NA NA RegUlatory IrripOsition Adj._ (RIA) 0.00 '0.00 0.00 0:00 0.00 0.00 0.00 NA NA .NA NA 44A IstA NA NA NA Usage & inflatiOn Adj.,(UiA) 009 0.09 0.09 0.09 0' of; .0.08 o 08 M .12/6 NA: IA NA WA .NA .NA IL& Total Non -Fuel EnergrCharge 50:73 -$0.73 .50.13 $0.73 50:70 .50.66 .50:62 2020 $0:16 $0.10 5020 50.35' By Contract. '50:42 50.24 By Contract. POrshaSe0 Gas- Adjustment(pGA) 0.71 0.71 011 .0.l1 '0.11 0:71 .0.71 0:71 In 211 P21. 01 0:61, 0.11. 0.61 0,91 Total Energy Charge/Therm 1,44 1.44 '1.44 144 1.41 '1.37 '1,33 0.91 0.86 0.81 0.91 1.06 0.6.1 1.13 0.85 0.51 + Non -Fuel + Noh-Fual Minimum Monthly BE. .51200 .05.00 sAbto 395:00 Pstoo 54009 595.00 512.00 526,00. 540.00- 529.00. 52000. EY COntract 550.00 • $25010 Customer (For-Central.Pasto Territory) (22000) (540.00) (570.00)(5160.00) (540.00) ($70.00) ($16600) (520.00) (540.00) (57000) (530.00) (536.00) (By Contract) (575,00) 540000 Charge + 0 pranks' a premise • (4) premise t. FAC +FAC + FAC. + FAC ' + Non:Fuel Therm Non:Fuei Therm Rate for 'Contract Rate tor Contract:. it of Therms #.0 Therms t ouip.ares to LO/Galion.Rate.of $ • 1.32 'S 1.32 S 1.32 $ 1.32 5 1.29 $ 1.25 5 1.22 $ 083. $ 0.79. S- 0.74 6 0.83 5 0.97 4' 0.55 $ 1.03 S 0.78 .with 6.0%. Franchise $• 1.40 5 140 S 7140 $ 1.40 5 1:37 '5 1.33 5 129 S 0.88 5 0.83 $ 0.79 $ 008' .-$ 1.03 $ 0:59 $ 1.10 $ 0.82 Change from 9/2014 Therm Rale $ (9,31) $ :0):,31) 5: (0.31): $ (0;31) 5 A0,39). $ (0.28) $ (028) 5 0.23) $ (0.23) '3 (0:23) $ (0.23) 1 (0.23) $' (0.24) $ (0.27) 5 (0.25) 5 (0.24) %Change torn 9/2014 Therm Rate -13.7% -13.7% -134% -13.7% 440% -13.4% -12:8% -12.gy. 425% -129V:i -12.2% -11.85 -13,57,, -12.654 ;18,1% -16.4% URN. TerNotez Fuel Rate per Therm 10411/1973 50.069 .50.069 50069 $0.069 $Q.069 .50,049 50-069 50.069 :50.069 $0-009- 50065. $0.069' 50.089 $0.069 50:055 Non -Utility Taxable Fuel/Them 50.641 .50.641 50.641 $3,641 50.641 50.641 10441 50.641 50.641- $0:641 00.841 50.641 50.541 $0.641 50:555 BTU FACTOR = TNERM§/100'CUBIC FEET (CCF) 1012019 1112019' 1212019 0112020 02/2020 03/2020 04/2020 05)2020 00/2020 07/2020 0842020 MOO Finn ServiCe Rates .1'045- '1.046 1:047 1.045 1.045 1.047 1.1140 1.047 1.046 Interruptible Senrice.Reica .1.025 1.626 4.026 1.024. 1024 1.027 1.025 1.027. '1.026 FY 19/20 AM; 1.046 1.026 513o66 $0.541 C$W:5/2712020 BTU Factor: 2.714 Gallons/100'cubic feet (CCF) BTU Factor: 2.483 Therms/100 cubic feet (CCF) Therm Factor: 0.915 Therms/Gallon ApjplicableAnnual Gallon Range or. Other Rate Determinant Monthly :Customat1Charge Non -Fuel Enerav Charaes&Gallon: Non -Fuel Energy Charge (NFE)70aIIor Energy Conservation. Adj.(ECA)/Gatlor. Regulatory Imposition Adj:(RIA)/G2Nor Usage & Inflation Ad. (UTA)IGallon Total Non -Fuel Charges (NF)IGat. Purchased Gas Adjustment(PGA)/Gal. Total Energy .Charges/Gallon Minimum Monthly Bit Utilitv'Tax Note: Fuel Rate per Gallon 1.0/01/1973 Non -Utility Taxable Fuel/Gallon Change from W.2014;Geilon Rata % Change from 912014 Galon:Rate RESIDENTIAL MRLP NA. (1- 3 Units) 512.00 CLEARWATER GAS SYSTEM METERED PROPANE (LP) RATE BILLING FACTORS FOR JUNE 1, 2020 - SEPTEMBER 30, 2020 BASED. ON APPROVED GAS ADJUSTMENT FACTORS MULTI -FAMILY LOOP RESL SMALL COML. LARGE COML. VEHICLE' MMLP LRLP MGLP Mt,LP LPV NA (4.+ Units) (Non -Rest. Only) NA 0 - 2,500 >2,501 NA 525:00 $12.00 525.00 $40.00 $40.00 For Each Meter 51.90 51.90 50.90. 0.20 0.20 0.20 0.00 0:00 0.00 0.4 fig. bdak 5219 52.19' 51.19 '$3.65 53.65 52.65 $12:00 525.00 51200 0,161 51.299 (50:52) .12.6% 0.161 '51.299 (50.52) -12.5% 0.161 51:299 (50.52) -16.4% 50.30 50.25 Set By.Contradt 0:20 0.20 NA' 0,00 0.00 NA Q:.Q$ 0.11$.. cgs 50.58 '$0.53 Seta i Contract _4g 1:46 .Set By.Contract $2:04 $1..99 Contract NFE + Contract PGA .Customer Charge 525:00 .540.00 Any Applicable Customer Charge + Any Applicable Facility Charges .0.181 51.299 (50.51) -20.0%' 0.161 51:299 (50.51) -20.4% 0.161 Contract PGA -0.161 NA NA Attachment #5 Page'l of 2 STANDBY/GENERATOR CONTRACT MTRD LPSM CLP (Non -Rest: Only) NA NA (Closed for New Rest Applications) $50.00 Set By Contract 51,00 NA NA 119 51.00 $2.46 550.00 0.161 51.299 (50.48) -16.3%. Set By Contract NA NA Set By Contract 1:16 Contract NFE + 51.150 Customer Charge'+ Non=Fuel Energy Chg. for the Contracted, #'of Gallons/Mo. 0.161 Cordradt POA NA .NA CSWr47/2020. Attachment OS Page 2 of 2 BTU Factcir; Gallons/1.00 cutic fest (CCF) . BTU Facia; 4.440 TheensIi00.cub1cieet (CCF) • Therm Factor 0:915 Therms/Gallon STANDARD RESIDENTIAL BULK LP SERVICE (Fats Class is Based as Asnusl LP GaSsn.Usiorldisiel) Meg ' BRLP1. BRLP2 Oatan 15I1P4, CLEARWATER GAS SYSTEM. BULK PROPANE(LP) RATE BILLING.FACTORS Fpn..airm 1.2520. SEPTEMBER Ss, 20$40.01ASED ON. APPROVED GAS ADJUSTMENT FACTORS REINDENTIAL V. cALL6 .commERCIALinsue CP SEPNICZ (Based co Nous! ')4691_4486 (Based on Anstalt )tagel:oval) MUD MILD )593113._ 4409caNe Anaus5159114e R4n911 0 (Nu Fili in Yi.). .0.1 - 00. 60.1 - 120 120.1 - 300 500. 0*(No Pas16Y(:) 0.1.80 ' 60.1 - 120 120.1 ., 300 '300. '0 • 2,600 ortithei RN* DeNiMitiutnt 1:4 ion 14 UNITS 141.INfra 14 UNLTS t-3 UNITS • 14 UNITS 14 UNITS 1-3 UNITS 1..3 UNITS 14 UNITS' CU4tomers'in this Rasp! at Usa90 AnnorA Cinsarnet Cfncoe 3 39000 6 . 220004 labap 5- Mao 's 15.00. 1 ato.ao 1: .510.00 5 199006 75.00 1 :80.00 5 '90.00 Nen-Fust Shared' !NM/Gallon: Noo.Firei EnianyOharie.iNFEYGal, S' 1.69 .3 1.130 A 1.60 S. 140 i ,09.0 5 1.80 '5. 1,80 5 tea s Also 5 0:90 5 9.25 t 9:20 Frowsy ConservatiOn At5..iEcAr3s1 5 0.20 3 010 5 cm aka 0.20 0.20 020' 0.20 0:20 0.20 6.20 .0.20 Pewees!, inspostase AO. (R)A)/Gal .0 - 5. - $ .- Uiege & Inflation A4 (1114.yeaion 0.09 0.09. 0.09 0:09 '0.09 :. 0.99 .0.09 Sas cob 0.09 0.04 aka- rMil Nee•FastCheraes MF)11411. $ 2.06 $ 209 6 1..69 1 1:29 '3 1.19' $ 2.50 5'. ..2.09 $ 1.19 S 1.19 S 1.09 $ 0.53 $ Purchased Gis A41. (FIGA)fdagon 5 148 -0* 1.46 .5 1.46 3 tits 5'. lm . 6 1.40 5 1..46 $ 1.46 5 146 5 148 5 1.46 5' Tots tEningy Choreal:deem 5 .346 0. 5.56 $ 3.35 S 2.713 2.95 0 a.ss S 3.55 s 3:35 s .353 S 5 t.99 .s• . >2.500 Customers 01 9101 Range of Usage 50:00 Nolo: No Monthly Plinirsom 1911 MAW Tax'Nottu FINIRelo par Gallon 10/1911973 5. Nor-uiffin T. rNeVGallect 5.: 0.49 1.45' 1.94' BULK STANDS* GENERATOR . (Closed .fOr New Residents! Applications) a '420.00 1:00 NA NA NA 5 1:00 1.46 4 2.45 CONTRACT BILI SIWR VLE. AnyCormtracl . CuNemers Wbo RetNesIS Bulk by'SrinIracl Set By Congeal NA NA lib Set By Contract iii Comm 61FE 1.160. 0:161 . 5 0.161 s 0.161 S. 0.161 s 0.181 3 0.161 $ 0.161 $ 0.161 $ 0.101 5 0.161 $ .0.161 $ 0.161 $ 0.161. 5 0151 1299 $ 1.290' a 1299 .5 1.299 $ 1.299 5 1.299 'S. 1.299 6 1199 9 1.299 $ . 1.299 :5' 1 299 5 1.299 5 1.299 Contract PGA 0.161 Change Alit 14014 Gilico. Rils .1. (0.520) 0 (0:520) $ (0.520) ..$ (0.62) '5 10.52) 4 )0.32) 5 (0.32) 0 3154 .S (0.62) 5 Pm). S. (0.51 5' (0.51) 5 (0.48) NA % Ctiinge Frani 9.2014 Gellon Rale .42.916 -12.91$ -134 -1.930 ...19465 -8.5%. .8310 -15.4% 16:416 ;19665 ..20.41. .-20.01 -16354 NA _..........icSW:547nau 9144i bi..._ilaPlaaljarl:..._....._.:..._.. 0at-16' ,..-......................,_...__;.................:..,_......_........:..:....i............._.._..._ �16+.3.......,.t:..:.5........3_................__!.__.....iS._Q:15.�5_..._OQ9.._$.._.... Dec -16i ..Ian -17y5......_147 Feb -171_$...._.....1.47. Mar -171 ••171. '-6.........1.53 May -17: 'Jun -1718 J14-$ Au917.$...... See -171 ........_....................,_.._._...,., 1.1. Residential TotarRate 1 Y .......:._........,�,.......,... Rate History •_.._..._............_.._._._....._..__._..._........_..__._._....__._.._........_ Clearwater Gas: #6 ' .._.._......_..._Attachment P} ..:. :,. __.: ._ ._ By Components System : t i ......... ........,.. pP6 ... . RU4# R@gltr.i.U.t_... _.:.............-aaa�w. ; $ 1 46 $ 3.09 • 09 3 $ 1.48: $ 3:09: $.. :296 ................._..:_......1:.S $_.........2:96.3._..........,- S 1.47 i $ • 2.06 1 t 5 ..._2.79.._.__....=_....._.._j........_.IS;_..011! $ 1.53 .._5_....._278'.._..._._ 1.70 $ :2711.._...'._..... 170.x S 271 1 tT$._ $........2.7? .................{...... $ 1.70=$ 2.71, ...!....,...... _.. . • ...,.?...YYN!VIJiA . I. , _.. ._..,..F._............_.0.1...._.._.......-__._..._._..--- 1.._......;.$_ :0:?�-5..----0-09;�: ....0.01 ; Y� 0.01 t S 0.79 � 1_ 0:7Qa..�_.,............. 1.� .i. ..... .._.. _......_ 0.01. ?$' _0.01!8 0.7@_........_0:7,0!$.........._ii........_._..,.,...... I .$. 0:15 1.1 0.09 1.$ ........001, ;;:. 0.01 '; $ _0.79 i S.---.0.70 i.$ 1.84 ! b15'_.s,.. _QQ9-?.=_.....- ....._Q,03}=.._......._004'30701 $• 0;671 $ 1.893 ......... _ ... ..._.... -' 3 0:15 I'S _....._Q.09-i:a........... _ 0.03 .'.S.' 0.04! $ '0:79' 1.5 0.67 i $..,._...... 1.89"i. ........ 1 S: 0.15 ;1 109.1-$ 0.03 ' $: 0.04 L $ 0.76T-1- 0.67? ;_...... _._..._1.69 S. -__029,x.5:......,..._...._., .°° y..$:,..:....4.055.1.$.....0.79 ..$..,.. U_70 $ 1.49 ! _......_._.........1:5..._0.16!$.._....0.09.x, $ _.._....... 003 •!'5 0.05 ' 3 0.79 I $ 0.70'1 i 1.49.1......_ _$....0.20!1.....0.14.;$ 0.0315 0.05'•3 0.89'5 0,80;4.._...,....-1:34' ._......_...... : I S .0:20 : $ 0.143' 0.03 $ 005 5 089 5 0:8611 .•1.34'......_._....__.. _.....-.. 0.03 i$_.:.-.. 0.05 5_..689[3.. _ 060.1~8._. ._..11 0.. i 5 :020 1 • ......0.141 $ 1}' 0.201$ -0.14;5 0.03 i. O.OS-5:18911 0.80x3 5,341 FY 16117 Avg. ! 1 1.569 1 5 2201 1 i I I 1 4.172 1 5. 0.107 i 1 0.021; S. 0.038 10.858 1.1 0.728 's S' 1.870 2016 Avg. $ 1,452 i $ 2.168 ': IS 0.157 i $ 0.105 1 $ 0.019 1 $ 0.040 ! $ 9.728•1$ 0.539 i 5 x.486 ; • Oct -17: $ 1.67`; Nov -17.i i.......... 1,67.L Oec-171..$.....:....167..,5..._,..3.31...:...... Jan-las.,$..- 1.69 Feb -18% $ 1:69 Mar=18 S 1.89 X1855......._t:69 M -18 $ 160 Jun -1811 1.60: Jul -181 $ 160 Aug -1813.._._..1:60+ Sep -16':.1 1.80 S 321l,.........,.>..,.,._i........:1...,020yi....0.09i$,..:._........_.,._0.03!_5......_-0+05'8_.091..:$.._ 5 _.._. 3:31...;. $ 3.38 ! $ 3.38 ; $ 3, 38 t $.........3.3Bs,`.....................:._.......4.:$:,.0221 ' 1. 3.29 I $._ _.... 3:29x..._.__. S 329 > g ......::3:29 I_..._. $ 3.29 i .._.__.....___... O8i. $ ................. !...._ 1.! ...._. r5' 0.20 ! .r 0.09_Lt $ 0.081 $. 0:06 1 S 0,91 ! S 0.81 1 •.'....... f..........i.1..'0:20.j.a.,.._'0.09..ia...__.. :......0.03ii:.._ 0.05 S 0:91 1$0.81 I 1.99 1 1........ .._ ! 1'$'.. 0�:11....,..0.09 i. i...__....... 0.05 $ .0.03 ` $ 0.86 !$......O.a6,..$1.99 •5 0.25 $ 0.09 i 5 006 0.03 t S 0:86 $ 0:76, I $ 1.99 1' ;........._._a :0:25:..1 ±_._.:0..09 1..± ....................... 0.05.' $ 0:03 :3...:0.86...1 5..._....076 1 5 -199 • *.-.. .................. $ 0.09 ! $ 0.05 i 0:03 ' 5 086 T3 0.70 1 5 1:99 i I $ 0.26 1,:..•..0.04. 0.05 ' $' 0,03 1 •0.82 1.$ 0.72,5 1.95 ' _.. ! ; $ '0,25 ' S" 0.04 i-3- 0.06 15' :0:03 5 0.82..5 072.11 1.-954 ....._..._.._.._.._. : 5 S .023!8' '0.04!8 0.05:5 0.03:5 .0.82'E 0.72.1E 1 95 1 ["r$ 025 j..$ 0:04 < 3 0.05 ! 5 _.. 11.031$ . 3 '0.26 i1 0.04 1 5. 0.05.,.S 0.03 i S 0.82 i 3 0.72 1 3 1:95 FY713 17118•Av9. 1 1 1.848 1 3 3.325 1 1 1 1 3 :0.238 .1 5 0.069 I S 0.0411 5 0.035 1 5 0.850 1$ 0.758 1: S. 1.873 1 2017.Avg. 1 $ 1'.807: $ 2.936 1 1 1.$ 0184' i S. 0.107 1 $ 0.030 'S. 0.048: $.0.848 11. 0:753 , 1 1.616 1. 'Oct -.18; 5 1.60 Nov -181S 1.60 Dec -181 $ 1.00 ,_....__............Jg1 19 $ 1.60 Feb -191 1.68 Mar -191 5 1.58 91x1913.._.......1:58 Msiy-19 5._......1.58' Jtat-19:......-_._7.65 Ju1n191._$-.......1.65 4[9-19:3.........1.6515_..._..107 Sep -13; 3 1.65: $ 3.29 ; i .3 0:25 1'$ • .,...O: .. ` $ 3:29 S 0:26 ?'$ 0'.04';.5 $ 329 ! 1 5 0.25 i :$ 0.04 1 $ 3.29 i 1 r....... _r 5.._0.25 ' $ 0.04 ;• $ 3.27 j : •I.._..... L$ 0,29 5 ....._._....__ '• $ '3.27 1 1 '.. ; 5 0.291 $ - : $ 3.27 ! •i.........:.`S- .....019.:` 5:..........-.......:'S $ '3.27 1 "? ,0.29.........- $.........1307..!_:.. 1._........• 021.1 .; $.........=........5_....._....._.....003 15...__._3.07 ..._._.... 1 S 0.29 $ - ' $ 028 r.$ ..................$ . 0:2 $ • 3,07 ; '. f I S 9 1 S.._ ........a S:..,.........._...... 4.05 ; S 0.03 1 S 0:82 ; . 0.71...$ ..._....._-1:95 1.. ,..._......_.... 0.05'+'S 103: $ 0.82 S i & 172' .--._...._. 1. 5 1 S. 0.05 ± S• 0,03' - $ 0.82 ' 5 0:72 5 1.95 I $ 005.,. $_..._...0:03 ' $ 0.82 ! 5 0.72'1...3_......_.... 1.95 i, S ............_._.._. 0031. 0_04 ."i 0.82_1$ 07.2-13 1.95 1 $• .0.03 i'$ 0.04 1 5 0:82 1 $ 0.7-21 $ 1.95 1 0.03 1 S' 0:04-1.5 .0.32 1a _.... 07212............,.1.assi..................._ 3 0.031 S' 0.6414 o_s2't3._ 072 " ,. !.3........__....._195! _ ............ 1.5 C04LS._0:89.'..5'_..._079{8_.........._-1:7S ...._._..._........... $ 0.03 8-........0.04 5;•0.89..!_.......0,79 i 5 175 1 _ 0.03'.,, ,....._._0141 S-0,89.;::$:_...__ 07$�?....._......._.1:.75 ._._....•..• 0.03 i S 13:04. i $ 0-69 1 3 0.79 $ 1.711- ... FYTD 18119 Avg. 1 $ 1210 1 $ 3.210 1 i i `'S 9277'1 5 0.013 1 1 0.037 j '$ 0.037 ,,$ 0.843 i $ 0.743 ! 0 1.888 - 2048 Avg. 1 S 1.830 ; $ 3.320 i ! $ 0.250 1 $ 0.057 '. $ 0.150. ! $ 0.030 1.1 0.833 1 1' 0.733 I S 1.983 I :._- - •--- 4d-19!4.........1.66:.�,... Nov -1915........_ Dcc-195 Jan -20 Feb -20 Mar -20 AEr.-20 -20 Jun -20 Jul -301 Sep -201 • 3:07..i..__.f.-........._....._.::8...029 �5 -. _.i..$:.._ .............0:01 ;$....._._.0.04:?-.:0.89..'5:.......0.79..:s._...........__1174!..:...._.....,..._ 1.65...:5........_:307 ''' I ! S 0.29 : S - i $ 0:031;$......_..0; _` S 11.89 t 5 .0.79 $ 1.75 ! .._.._ 165 1 $ ... 3.07 ; I .t:S_.:0.29_1_ 5.:...... - ��._.._...-._..._...0.03 I's 0.0415_..0..:69 .$...- 0.79' s 115. i $...._,:.._165..'._$..._. 307 '` ...._.....! -.-. _.;.....,..-• 3..._029_:._$ ........: s ......................0.03 :.$ 0.04 1 S 0:89 !'S 0.79 1,S_. _... -._.._1:75 ; $ 165 ' $ 3.07 1 r ' 3 '0.26' r - $ 0:09.''.$' 0.08 '• $ 0.66 1 $ 0.78•j 3 1,72 ' 1...- 165 =$ _..307 ..... _._.. : •$ 0:28.! $ _ 8;-......__.........009 ,,$ .....0�..:_5...588._! S._ _0t!8 ..?.._.,.._.. 1.72' s.,.....:7.03 ............,....'.... ,._ .5.: 06.24-rt241 1 - 3 0.09 S • 0.08 4.1 0.79 i $ 0:69 1 S - - 1.59 ._$._..,...1.556..".5 5..._...._1 ;4:2.92 ._. __. _.._.....i...........i._5_. _...........-......:6 0.09 •,•L:s. _ 0.08 ? S 0.79 j 5- ...0.654 $........_.....1.16?.' $ 1,44 '• $ 2754..., 1 5-02(111.. - $ ._._.._...._....:0.09 0,08 5 0.71 1 3: 0.6142 140 ....' ' i 1 : i T.._ i �..•i.... +... FYTD'19f20 Avg. $ 1.607 ! $ 3,001 i ! 1 i $ 0.282.15. - i $ 0.083 i.$ 0.063.1 $ 0.841 t $ 0.741 ! $ 1.670 ! _.._.._....,...... 2019 Avg. ' 5 1.623:5 3.155 € 1 5.0.287 i 3 0.003 ; $ 0.032 1 5 0.039i'50.8511$ 0:781 i .$ 1.835 ; Incr. Above - ._........__...__.._ LaslYeaC Same Mono' .... ` Incr. Based on 20Thernrs Equlvalent. cents/KWH for Gas 4. vs. Duke Rate ................: (RasldonQ56......_. Gas Chea r ......_._.._..,..._. ' [3°300.n Bulk LP # • New rates implemented _.._...__..._ i __.,..... _.._..._. ;$.......__00.21);.$..._..:{0,321:._........:...$....(0.09)1.i...._....:........s ..................0.08 1 ! 0.04, $.._�0: 8� ..$:,..... ,18)i..._..__....y(O ).. 1 : I"' 1 , ........._....... ..-13',41........_.. ?0'h •....__.....a.......... _.._.._.1....._..: 1941 ................ ! ._... ............_._200%1. ... 100y..... -205'5 ......._..._:23°JLI ...._............. -17% _._...._.._...; ......._.._...- i ._....._._. ii I $ .,..0.394./(1991._. _ t! I_ ` .._. ...._.._... ..._....._..._..,F . .13k; 1071 I s k- , : i .. i i F._. ;._. 4.91 10.3 i • -.., i.. ... : 11 t ; ' 14.0 ! ............:14:0 Note. Disks Energy,Fbfida's (aspdanUat (at for usage >1,000 KWH tri April, 20201114.038 centafl6Afa..,,..- ....., I. „--„.,-„.•, , ,-„•- .._.. _.. .... • I I j.:. I..._.. `.... ... : I i . ............_..._..._.._._....;.__..... .......1.._........._..__.. r _._..._.._.-:_... __._...._. ...1 _...._..... _.__....._..........a_......_ _.._.....___......,._.:............_......... �._......._... _..__.._..a......_.._..... iBRLp3) whirl Is appikable for customers,09 120.1 -.300 gellongyear &equal to Rsaider4Ta1 LF.W81 Call:[HRWCLP)_ i . -.. _.-...__.... 11/112014 with following changes: ' i ;._...____.. �. RS NG Customer Cha ctncrea .•_..$1 ....... _...,..._ ._ ..._ ._- .......__._..,._.__..._._.__. _._......,........1&............. Increased W S(ZhnpM,h,B NFE,rated{gped4oeMsto;44genlsJtherm,. UlA, Geaeased•by 3.cerngl6w[mto'0..,,......... BRLP3'LP Customer. Charge unchanged O 6901Year, atd NFE rate unchanged _ 1.OWgaRon. _U1A ilecreased.by 9 centslga!Ion to 1 ; R1A& ECA unchanged Malady;i 1 i I I C&V:68/26/201s Attachrrient #6 Page 2 of 3 • Competitive History of NG vw, Electric Rates: Month -Year September 2001 Septernbet 2002' 'September2003 'September 2004 September 2005 September 2006 Septerriber 2007 September'2006 September 2009 September 2010 SePteinber2011 September '2012 September 2013 Septernber2014 September 2015 September 2016 September 2017 aeptember2018 September 2019 NG Therm Cost 1:34. $ $ 1 1 $ .$ .1 $ Increase over Last 18 Years $ %. Increase over Last 18'Years Avg. Annual Inc. Over Last 18 Yrs. NG .Equivalent KWH.Cost $. 0.046 1.36 $ '0.046 1.56 1 0.053 1.69 8. 0,05; 1.97 $ 0.067 1.89 $ 0.065 1.86 1 .0.063 2.12: 1 0.072 1.39 $ .a.047 1.39 $ 0:047 1.42 $ 0.048 1.48. 1 0:051 1.67 $ 0.047 1..75 $ 0:047 1.57 $ 0.047 1.38. 1 0.047 1.70 1 '0.058. 1.50. $ 0,055 1.65 $ '0.056 0.010 $ 22.4% 1.2% Progress Energy KWH Cost 0.084 0.074 0.084 0.089 0.097 0.119 0.120 0:120 0.132 0.1.36 0,129 0.132 0.123' 0.123 0.123 (1123 0.130 0.1.34 0.142. 0.058 69.0% 3:8% NG vs. Electric .-46%. -p794, -35% -31% -46% -47% -64%. -65% - 62% -62% -62% -62% -62% -62% - 55% -59% - 61% CSW:0W2612o19 ,Attachment.#6: Page S Of -3- , r ,........_Annual Average-�CGS Residential Rates__.....__._......._._........_... Calender Year Fiscal Year ! Year _._...__....._NG/The_ rrq ! LP/Gall.on.* f......._ Ye _.,. i. N:_l. * LP!Gallon 1995 ! NA NA 1 !--Y 95/96 $ 0.880 I $. 1..199 1* 1996 I $ 0.915 $ 1.239. * FY 96197 t $ 1.019 $ 1.370 " 1997 .............._;.._$--..._._....1.049 i...$._........._1:380..:*..._._.FY 97/98...'$..__...._.._1:.054... '._..._._........1:318 1` 1998 ! $ 1,032 i $ 1.2881* ;FY 98/99 I $ 1._052 $ 1.269 t* 1999 :.$: 1..073 $ 1.,311 ' `: FY 99700 $ 1.152 , $ 1.594 € 2000 ' $ 1.222 1 $ 1.584 j t FY 00101 1.551 1 $ 1.649 2001. $ 1.549 1 $ 1.586 t iFY 01102 $ 1.352 ..... $.:..... 1.488 2002 $ 1.342 `: $ _.....1-5531._._....: FY 02/03.... -.$ .__ _.._1477 i $..._...... 1.817x -i s. _... 2003 $ 1.534: 1 1.864 i 1FY 03/04 $ 1.603 $ 1.913 2004 $ ... 1.652: $_............_._..1.968 '._........'FY 0.4/05._.,..:$.._.... 1..803: $ 2.162 2005 '_........._..:1,.925$.................__2.278...E...._......;FY 05106,...'..$..........._2,080-.. ...._........_..:2.480 2006 $ 2:012 1 $ ............._..._2.501'.........` FY 06/07..._;..$.........._._.1.918 ; $ 2.742 2007 $ ..... 1.893. < $.:......._.. 2.869 ..._... !FY 07/08.._. ...._.......1.932 1 .........._.._.31 ........... 2008 $ 1.965: $ 3.1:86 ! FY 08/09 $ 1,610 ; $ 2.524 i 20N $ 1.464: $ 2.418 .,, FY 09/10 $.._.......__1.437 i $ 2.85.5 2010! $ 1.457 $ 2.946 ; FY 10/11 $ 1.475 $ 3.282 2011..:........_...,...$................._.........__..........._..........._.......__.....................,........._......_......E..:•......._..._..........-.................. ............. ... 1487 $' 3.438 1 !FY 11/12 1 $ 1.506.1 $ 3:639 f 2012 $ 1.501 1 $ 3.548 1 ; FY 12/1.3 I $ 1:.582: $ 3.25.7 2013 1 $ 1.629 ; $ 3.297 [FY 13/14 I $ t.629 ! $ 3297 2014 ,...._...:..$ .............1:717 1 ...._.... _._3.52$...'.........!FY 14/15......1 $............1,602+..$... .3.133 ;...... ........... 2015.........__._....::.....-......_1.516 $ 3.003 FY 15/16 $ 1..479 ; $ 2.718 2016 $. 11.4521 $ 2.768 FY 16/17 , $ 1.700 i $ 2.71:© 2017._.... _..._$... .1.607 1 $...._......:2.936._: --....__._'FY 17/18....! $..........__1.607._x.._........._.._.2936 i.__... 201.8 $ 1.630 $ a320 FY 18119 r.$ 1.6101.$ 3.210 2019 $ 1..823 ` $ 3.155 : 1 ... Average $ 1.513 $ 2.45.7 ! 1.800 2.368 Notes: ! i * Based. on the Residential Metered Propane schedule which was closed for new customers effective March 8, 1999_ For 1999 & FY 99/00 and beyond 4 based on Bulk LP (BRLP3) which is applicable for customers using ` ! ! 120.1 - 300 gallons/year. & is equal to Residential LP Will Call; Carwater Gas System eve Greener Oh. f"' :. APPLIANCE Want to make the switch to natural gas? Cali Clearwater Gas System, today at (727) 562-4980. Fuel Use and. Cost Comparison (Effective Rates for June 2020) ANNUAL NATURAL GAS PROPANE (LP) GAS' ELECTRIC THERMS USED COOKING 35 , $ 5.0.40 i WATER HEATING: •• 3 -Gas Tank-Style/Gas .Tankless 150/100 $216.00/$1.44.00* _ $45 1 vs. Electric Tank Style HEATING. 130 $.187.20 CLOTHES DRYING 50 $' 72.00 TOTAL .APPLIANCE $525.60/ USAGE --with tank/tankless $453:60* $105..35 $148.05 1.50/$301.00* S634.50 $1,098.651 $948.15* GAS SAVINGS VS. ELECTRICITY OUTDOOR RECREATION: $391.:30 $549.90 $150.50. $211.50 $1.,543.95 Cis% / 52%* 27%139%* j f '�lvhen u.Ting tanklers - *when using iankless-LP POOL HEATING*.._.._......_.._......._..? .._..._.250 1 $360.00........................._�.........._:$.752.54......._.._.._...._?......_..,.$1,057__. .500 SPA/HOT TUB HEAT* 125 $185.00 $376.25 $ 528.75 *varies according to pool size, weather conditions, and temperature maintained All other f ures are annual average. p :Aections,based upon the following: 1. 1 therm — 100,000 BTUs of energy_....._.._...........__.................._.._......._-_..........__...__..._ 2. Natural Gas € °$1.44 _per therm 3. LP Gas per gallon (BF03) $2.75 _.... -_per gallon or __.___....... 3.01 per therm 4. Duke Energy per .KWH 1 $0,14038 Per KWH. or $4.23 per therm (Based. on >1000 K W H rate) ......... _.. _._...�_.. 1. Notes: The above analysis is based on. June 2020 residential energy and fuel charges and does not include. applicable taxes or franchise fees. 2.. Current: monthly customer charges are: Duke Energy $10.58, Peoples Gas $.I2.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, Pt. 13756 (727.) 582-4980