Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
GAS ADJUSTMENTS EFFECTIVE FEBRUARY 1, 2020
TO: 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, Controller/CGS; Laura Damico, Sr. Systems Analyst/UCS; Kristina Simi, Cust. Serv. Coord./UCS FEB 04 202U OFFICIAL RECORDS AN" LE.G!SLAT!VE SRVCS E.E?;. SUBJECT: GAS ADJUSTMENTS EFFECTIVE FEBRUARY 1, 2020 DATE: January 30, 2020 Natural Gas supply prices have remained fairly stable this winter such that we are able to recommend that we decrease our Natural Gas Purchase Gas Adjustment (PGA) by 3¢ per therm for February. Propane (LP) supply prices have dropped a little this winter such that we are also recommending that we decrease our LP PGA by 3¢ per gallon for February. We recommend that we continue our standard Contract LP PGA at 30¢ below our Standard LP PGA. We are recommending a 3¢ per therm and gallon decrease in our Energy Conservation Adjustment (ECA), but no change in our Regulatory Imposition Adjustment (RIA) for February. We have calculated our Usage & Inflation Adjustments (UIAs) for February and are recommending an increase of 6¢ per therm and gallon for our Residential UIA and an increase of 4¢ per therm and gallon for our Commercial UIA. The net effect of these recommended changes for February is no net change in our typical Residential Natural Gas customer's rate nor 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 February 1, 2020: Natural Gas Firm Standard Rate Schedule PGA Natural Gas Interruptible and Contract (Non -Standard) Rate Schedule PGA Propane (LP) Gas Standard Rate Schedule PGA Propane (LP) Gas Contract Rate Schedule PGA Energy Conservation Adjustment (ECA) Regulatory Imposition Adjustment (EIA) Usage & Inflation Adjustment (UIA) - Residential - Commercial $0.86 per therm (down 3¢) $0.76 per therm (down 3¢) $1.72 per gallon (down 3¢) $1.42 per gallon (down 3¢) $0.26 per therm or gallon (down 3¢) $0.00 per therm or gallon (no change) .... $0.09 per therm or gallon (up 60) $0.08 per therm or gallon (up 40) William B. Horne II, City Manager January 30, 2020 Page 2 Attachment #1 shows the status of our Adjustment Recovery Clause balances with actuals thru December. 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 1/2 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 59% lower than electric for Natural Gas and 16% 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 recommending a 50¢ per gasoline gallon equivalent (GGE) decrease in our Natural Gas Vehicle (NGV) Fueling Station prices effective February 1 St to $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 recommended price will be $0.99/GGE, as these fleets pay no Federal taxes on fuel --- an even more remarkable price. The reason for this decrease is that Congress has finally 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 February 1g billings. If you have any questions on this, please call me. CSW/cw Attachments Approved: m . tik4A.tAs 3 illiam B. Horne II, City Manager U:\My Documents\MSOFFICE\WINWORD\GASRATES\Gas Adjustments for February 2020.docx CLEARWATER GAS SYSTEM SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTIONa Trqr-d-fivICePr # 1 NATURAL GAS PURCHASED GAS ADJUSTMENT (PGA -NGL Total NG PGA Billed Monthly Overage (Shortage) Cumulative YTD Overage (Shortage) NG PWA Rate/Therfi Firm/Contr Budget Reservation Commodity interest Expense Cost Center Expenses Total NG Fuel Expenses Month Charges Charges _ .gin Prior Year- Oct -19 $ 113,776.17 617,386.56 $ 148.53 $ 233,172.66 1 $ 964,483.92 $ 1,440,660.11 $ 476,176.19 $� 416,762.64 0.89/0.79 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,59432 $ 1,090,818.28 0.89/0.79 Jan -20 , $ - $ - $ 1,090,818.28 Feb -20 $- $ - $ 1,090,818.28 Mar -20 $- $ - $ 1,090,818.28 Apr -20 $- $ - $ 1,090,818.28 May -20 $- $ - $ 1,090,818.28 Jun -20 $ - $ - $ 1,090,818.28 Jul -20 $ - $ - $ 1,090,818.28 Aug -20 $- $ - $ 1,090,818.28 Sep -20 $- $ - $ 1,090,818.28 $ - $ 1,090,818.28 Per13 $ - $- Total YTD $ 481,224.46 $ 1,985,455.85 $ (3,041.43) $ 1,237,408.09 $ 3,701,048.97 $ 4,851,280.80 $ 1,150,231.83 (1) FY 18/19 Write off of (PGA) $10,389.22 (375.14)WNA) 2 Dividend $525,000 PROPANE (LP) GAS PURCHASED GAS ADJUSTMENT PGA -LP Cost Center Monthly Cumulative LP PGA Budget Gallons Monttlly Interest Expense Commodity Charges Center Expenses Total LP Fuel Expenses Total LP PGA Billed Overage (Shortage)(Shortage) YTD Overage Therm/Gal. Month Sold WACOG . $ (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 $ 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 $ 29,505.97 49,149.97 $ 20,729.37 $ (67,251.08) 1.91/1.75 Dec -19 29,819.8 $ 0.78992 $ 219.95 23,555.26 7,561.72 $ 31,336.93 52,066.30 $ - $ (67,251.08) Jan -20 - $ - Feb -20 - $ - $ - $ (67,251.08) Mar -20 - $- $ - $ (67,251.08) Apr -20 - $- $ - $ (67,251.08) May -20 - $- $ - $ (67,251.08) Jun -20 - $- $ - $ - $ (67,251.08) $ (67,251.08) Jul -20 - $- Aug -20 - $ - $ - $ (67,251.08) Sep -20 - $ - $ - $ (67,251.08) P13 ' $ - $ (67,251.08)_ Total YTD 84,812.3 $ 0.76307 $ 724.08 $ 64,718.06 $ 88,074.30 $ 121,345.35 $ 148,122.55 $ 26,777.20 Cost Center Expenses FY 18/19 Write off PGA (531.18) & WNA (13.82) 544.80 2,600.00 1 1 Suburban Software Systems Support Suburban Software Systems Cloud Rental 3,300.00 1 Depreciation of LP tanks 34,414.23 1 40,859.03 CLEARWATER GAS SYSTEM SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTION$ ENERGY CONSERVATION ADJUSTMENT (ECA) Total ECA Monthly Overage Cumulative YTD Overage ECA NG/Therm Budget Cost Center Interest Total ECA Month Expenses Notes/Exceptional Items Expense Expenses BilledShorts a Shorts e) LP/Gal. - Prior Year $ 328,925.77 347,483.35 $ 104,910.39 $ (10,144.31) $ 467,478.82 $ 457,332.51 0.029/0.029 0.029/0.029 Oct -19 $ 224,921.80 Promo$97,558,Adv $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 357,627.66 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) 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 $ (25,276.57) $ 432,055.94 0.029/0.029 Jan -20 - $ - $ 432,055.94 Feb -20 _ - $ - $ 432,055.94 $ - $ 432,055.94 Mar -20 - Apr -20 - $ - $ 432,055.94 May -20 - $ - $ 432,055.94 Jun -20 - $ - $ 432,055.94 Jul -20 - $ - $ 432,055.94 Aug -20 - $ - $ 432,055.94 Sep -20 - $ - $ 432,055.94 P13 - $ - $ 432,055.94 Total YTD $ 1,083,508.94 $ (3,218.44) $ - $ 1,080,290.50 $ 1,149,780.01 $ 69,489.51 (1) FY 18/19 Write off of $3,830.11 REGULATO [ • - l • , _DJ TMENT RIA Budget Interest Total RIA Total RIA Overage YTD Overage NG/Therm Month Notes/Exceptional Items Expense Expenses Billed (Shortage) (Shortage) LP/Gal. $ - $ 996,944.27 Prior Year- (16.48) $ (9,687.98) $ 987,256.29 0.00/0.00 Oct -19 $ (2,492.36) 1 $ 9,671.50 Nov -19 $ (2,468.14) 20,812.77 (6.92) $ (20,819.69) $ 966,436.60 0.00/0.00 Dec -19 $ (2,416.09) 84,264.04 (9.65) $ (84,273.69) _$ 882,162.91 0.00/0.00 Jan -20 - $ - $ 882,162.91 Feb -20- $ - $ 882,162.91 Mar -20- $ - $ 882,162.91 Apr -20- $ - $ 882,162.91 May -20 - $ - $ 882,162.91 Jun -20 - $ - $ 882,162.91 Jul -20 - $ - $ 882,162.91 Aug -20- $ - $ 882,162.91 Sep -20- $ - $ 882,162.91 P13 - $ - $ 882,162.91 $ - - $ - $ 882,162.91 Total YTD $ (7,376.59) 114,748.31 (33.05) $ (114,781.36) (1) , FY 18/19 Write off of $370.27 CLEARWATER GAS SYSTEM UMMARY OF RATE ADJUSTMENT CLAUSE COLLECTIONq USAGE AND INFLATION ADJUSTMENT (UTA! Cow, Monthly Cumulative UTA Budget Interest Overage YTD Overage NG/Therni Month LP Gallons Expense Rate/Gallon NG Therms Rate/Therm Shorta • e Shortage) LP/Gal Beg. Bal. 885,440.60 $ - .;',.0; :' Oct -19 5,412.6 $ (16.30) 0.04 0.04 34,669.70 $ 37,930.50 0.04/0.04 Nov -19 6,542.9 $ (189.65) 0.04 898,725.40 0.04 36,342.93 $ 74,273.44 0.04/0.04 Dec -19 6,463.2 $ (371.37) 0.04 1,166,312.80 0.04 46,801.43 $ 121,074.86 0.04/0.04 Jan -20 $ 121,074.86 Feb -20 $ 121,074.86 Mar -20 $ 121,074.86 Apr -20 $ 121,074.86 May -20 $ 121,074.86 Jun -20 $ 121,074.86 Jul -20 $ 121,074.86 Aug -20 $ 121,074.86 Sep -20 $ 121,074.86 Per 13 Total YTD 18,418.7 (577.32) 2,950,478.80 $ 117,814.06 USAGE AND INFLATION ADJUSTMENT UTA Monthly Cumulative UTA Budget Interest NG Therms Rate/Therm Overage (Shortage) YTD Overage Shortage) NG/Therm LP/Gal Month LP Gallons Expense Rate/Gallon Beg. Bal. $ - 9 Oct -19 21,439.1 $ (166.58) 0.03 246,226.50 0.03 $ 8,187.65 $ 41,503.04 0.03/0.03 Nov -19 21,584.4 $ (207.52) 0.03 350,402.20 448,007.60 0.03 0.03 $ 9,052.70 $ 50,555.73 $ 14,402.32 $ 64,958.05 0.03/0.03 0.03/0.03 Dec -19 23,351.2 $ (252.78) 0.03 Jan -20 $ 64,958.05 Feb -20 $ 64,958.05 Mar -20 $ 64,958.05 Apr -20 $ 64,958.05 May -20 $ 64,958.05 Jun -20 $ 64,958.05 Jul -20 $ 64,958.05 Aug -20 $ 64,958.05 Sep -20 $ 64,958.05 Per13 Total YTD 66,374.7 (626.87) 1,044,636.30 $ 31,642.66 (1) Per Calculation of UTA Attachment #4 less FY18 under/over collection ($) CLEARWATER GAS SYSTEM SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTION$ TOTAL ALL COST RECOVERY ADJUSTMENT CLAUSES (Both PGAs + ECA + RIA+UIA) Month! Cumulative Total ' Total All Ex . - nses Total Recove Billed Overa , e Shorta, e YTD Overa e Shorta e NG/TH (Firth) NO/LP Budget Month Prior Year - $ - ,.: . $ 1,843,304.83 Oct -19 $ 1,258,673.26 $ 1,859,333.03 $ 600,659.77 1.21/2.07 Nov -19 $ 1,471,180.81 $ 1,947,717.77 $ 476,536.96 $ 2,319,841.79 1.21/2.07 Dec -19 $ 2,287,579.05 $ 2,491,556.24 $ 203,977.18 $ 2,523,818.97 1.21/2.07 Jan -20 $ - $ 2,523,818.97 Feb -20 $ - $ 2,523,818.97 Mar -20 $ - $ 2,523,818.97 Apr -20 $ - $ 2,523,818.97 May -20 $ - $ 2,523,818.97 Jun -20 $ - $ 2,523,818.97 Jul -20 $ - $ 2,523,818.97 Aug -20 $ - $ 2,523,818.97 Sep -20 $ - $ - , $ 2,523,818.97 Per 13 - $ - $ 2,337,786.06 Total YTD 5,017,433.12 6,298,607.03 $ 1,281,173.91 NG NFE TRACKING Actual Actual Actual Annual Bud, et Therms NFE YTD Total Strat Plan Amt. Month B . Bal. Oct -19 1,934,808.7 976,548.14 . 4 Ffl____ Nov -19 2,038,380.0 1,006,459.71 1,006,459.71 1,983,005.85 Dec -19 2,465,044.1 1,198,851.42 KliE:SR:uIu1l Jan -20 - 3,181,857.27 Feb -20 i Mar -20 ' • r-20 i Ma -20 - 3,181,857.27 Jun -20 - 3,181,857.27 Jul -20 - 3,181,857.27 Au -20 - 3,181,857.27 Se. 20 - 3,181,857.27 Total YTD Avera.e NFE Rate .er therm 0.49 6,438,232.8 3,181,857.27 �- LP NFE TRACKING Actual Actual Actual Annual Budget Gallons NFE YTD Total Strat Plan Amt. Month --..Bal. Oct -19 26,859.8 41,984.23 41,984 41,984.23 Nov -19 28,132.7 39,517.40 39,517 81,501.63 Dec -19 29,819.8 58,032.23 58,032 139,533.86 -� Jan -20 - 139,533.86 Feb -20 - 139,533.86 Mar -20 ' • i Apr -20 - f ____k___ May -20 - 139,533.86 Jun -20 - 139,533.86 Jul -20 - 139,533.86 Au. -20 - 139,533.86 Sep -20 - thi___ _[:_il Avera. a NFE Rate • - r Ballon Total YTD 1.65 84,812.3 139,533.86 CLEARWATER GAS SYSTEM SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTION% Central Pasco County Natural Gas Sales (PGA -NG) Budget Commodity Interest Cost Center Total NG Fuel Total NG PGA Overage YTD Overage Rate/Therm Month Charges Expense Expenses Expenses Billed (Shortage) (Shortage) Firm/Contr Prior Year - J 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,968.10 $ 56,724.92 ' 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) Jan -20 $ - $ - $ 76,001.43 Feb -20 $ - $ - $ 76,001.43 Mar -20 $ - $ - $ 76,001.43 Apr -20 $ - $ - $ 76,001.43 May -20 $- $ - $ 76,001.43 Jun -20 $ - $ - $ 76,001.43 Jul -20 $ - $ - $ 76,001.43 Aug -20 $ - $ - $ 76,001.43 Sep -20 $ - $ - $ 76,001.43 Total YTD $ - $ 132,721.18 $ (321.55) $ - $ 132,399.63 $ 208,401.06 $ 76,001.43 Excise Tax Recoup YTD Balance Month Gallons Sol 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) Mar -15 17,118.00 16,892.32 17,450.74 0.50 $ 8,559.00 $ (63,494.05) Apr -15 16,578.00 16,359.44 18,900.25 0.50 $ 8,289.00 $ (55,205.05) $ (46,958.55) --, May -15 16,493.00 16,275.56 16,813.59 0.50 $ 8,246.50 Jun -15 26,247.00 25,900.96 26,757.19 0.50 $ 13,123.50 $ (33,835.05) Jul -15 32,772.00 32,339.94 33,409.03 0.50 $ 16,386.00 $ (17,449.05) Aug -15 29,561.00 29,171.27 30,135.61 0.50 $ 14,780.50 $ (2,668.55) $ 11,417.45 Sep -15 28,172.00 27,800.58 28,719.61 0.50 $ 14,086.00 Oct -15 29,813.80 29,420.74 30,393.33 0.50 $ 14,906.90 $ 26,324.35 Nov -15 31,458.10 31,043.36 32,069.59 0.50 $ 15,729.05 $ 42,053.40 Dec -15 30,415.70 30,014.70 31,006.93 0.50 $ 15,207.85 $ 57,261.25 Jan -16 21,728.80 21,980.25 22,234.62 0.50 $ 10,864.40 $ 68,125.65 Feb -16 23,067.00 23,333.94 23,603.97 0.50 $ 11,533.50 $ 79,659.15 Mar -16 24,260.90 24,541.66 24,825.66 0.50 $ 12,130.45 $ 91,789.60 Apr -16 20,553.70 20,791.56 21,032.16 0.50 (150,263.27) $ (139,986.42) $ (48,196.82) $ (71,192.37) May -16 22,777.90 23,041.49 23,308.14 0.50 (34,384.50) $ (22,995.55) Jun -16 23,037.20 23,303.80 23,573.48 0.50 $ 11,518.60 $ (59,673.77) 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) Sep -16 25,450.40 25,744.92 26,042.85 0.50 $ 12,725.20 $ (60,561.57) Oct -16 25,771.80 26,070.04 26,371.73 0.50 $ 12,685.90 $ 39,210.25 Nov -16 26,867.40 27,178.32 27,492.84 0.50 $ 13,433.70 $ 52,643.95 Dec -16 27,406.70 27,723.86 28,044.69 0.50 (40,486.11) $ (26,782.76) $ 25,861.19 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 H 26,775.72 0.50 $ 13,083.30 $ 52,853.69 Mar -17 29,555.00 29,897.02 30,243.00 0.50 (79,516.51) $ (64,739.01) $ (11,885.32) Apr -17 25,729.20 26,026.95 26,328.14 $ - $ (11,885.32) May -17 29,053.40 29,389.62 29,729.73 $ - $ (11,885.32) Jun -17 30,545.00 30,898.48 31,256.05 $ - $ (11,885.32) 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) 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 $ - $ (11,885.32) Nov -17 40,323.00 40,789.63 41,261.67 $ - $ (11,885.32) $ (11,885.32) Dec -17 39,742.30 40,202.21 40,667.45 $ - Jan -18 43,197.80 43,697.70 37,826.43 44,203.39 38,264.18 $ - $ - $ (11,885.32) $ (11,885.32) $ (11,885.32) Feb -18 37,393.70 Mar -18 44,017.00 44.526.38 45.041.66 $ - CLEARWATER GAS SYSTEM SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTION Apr -18 43,912.00 44,420.17 46,434.01 44,934.21 46,971.36 0.30 $ - $ 13,770.84 $ (11,885.32) $ 1,885.52 May -18 45,902.80 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 $ 31,058.70 Aug -18 55,970.39 56,618.10 57,273.31 0.30 ' $ 16,791.12 $ 47,849.81 • 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 $ 112,531.37 Feb -19 38,647.08 39,094.32 39,546.73 0.30 $ 11,594.12 $ 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 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 Jut -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 $ - $ 164,850.46 Oct -19 41,463.00 41,942.83 42,428.20 (198,007.91) $ (198,007.91) $ (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) $ - $ (33,157.45) Total YTD $ - $ 1,992,548.07 $ 2,008,795.11 $ 2,037,875.30 $ (541,688.70) $ (39,733.32) CLEARWATER GAS SYSTEM SUMMARY QF RATE ADJUSTMENT CLAUSE COLLECTION 10Atagaingnatallalt P1 P2 P3 P4 P5 P6 P7 P8 P9 P10 P11 P12 Total Salaries 15,541.97 24,804.27 16,723.28 57,069.52 Special Pay 475.00 35.00 405.00 915.00 Overtime 2,118.05 6,639.26 2,477.12 11,234.43 Life Ins (520100) Life 1% (520200) 0.88 22.00 0.88 22.00 0.88 22.00 2.64 66.00 Life SAMP 45.05 45.34 46.72 137.11 Maj Medical 1,688.56 1,787.01 1,745.51 5,221.08 Social Security 388.91 649.96 384.77 1,423.64 Pension 2,714.54 4,568.05 2,984.99 10,267.58 Workers Comp 95.83 95.83 95.83 287.49 Disability 7.82 11.73 7.82 27.37 Life Ins CWA 13.39 15.69 14.72 43.80 Personal Svc 23,112.00 38,675.02 24,908.64 - - - -- - - - 86,695.66 Professional Svc 11,550.00 11,550.00 Contractual 4.49 419.49 518.49 942.47 Garage 1,406.35 1,378.98 1,352.01 4,137.34 Telephone-Var 211.53 233.62 445.15 Telephone -Fixed 16.67 16.67 16.67 50.01 Postal IT 1,381.67 1,381.67 1,381.67 4,145.01 Utilities -Telephone 30.47 113.66 144.13 Utilities -Electric 274.75 215.84 293.04 783.63 Utilities-Gas/Water 544.21 279.61 274.31 1,098.13 Interfund Svc 180.00 180.00 180.00 540.00 Interfund-Gen Fd Ops 367.50 367.50 367.50 1,102.50 Insurance 180.00 180.00 180.00 540.00 Uniforms 107.32 107.32 Travel 4,262.20 1,487.88 910.57 6,660.65 Mileage 5.24 0.90 6.14 Meals 6.00 5.60 2.80 14.40 Other Charges 2,325.00 587.24 2,912.24 Operating Supplies 5,637.22 2,656.96 12,704.64 20,998.82 Memberships 1,224.00 8,715.00 9,939.00 Training 716.13 716.13 Other Charges 16,591.30 10,624.34 39,617.43 - - - - -- - - - 66,833.07 Adm Svc Fxd Chgs UCS 62,545.83 62,545.83 62,545.83 187,637.49 Interfund Svc Chgs-Gen 120,159.17 120,159.17 120,159.17 360,477.51 Dividend 525,000.00 525,000.00 P1 P2 P3 P4 P5 P6 P7 P8 P9 P10 P11 Total Salaries 37,782.18 57,791.44 39,242.74 134,816.36 Special Pay - Overtime 388.64 5,842.30 182.12 6,413.06 Commissions 19,256.60 28,453.79 23,943.47 71,653.86 Life Ins (520100) 5.14 5.14 5.14 15.42 Life 1% (520200) 24.82 24.82 24.82 74.46 Life SAMP 143.94 144.76 149.34 438.04 Maj Medical 8,262.22 9,056.75 8,257.69 25,576.66 Social Security 1,265.62 2,030.14 1,381.03 4,676.79 Pension 6,937.83 11,289.94 7,199.18 25,426.95 Workers Comp 287.50 287.50 287.50 862.50 Disability 33.04 49.56 34.08 116.68 Life Ins CWA 18.12 34.53 18.26 70.91 Personal SVC 74,405.65 115,010.67 80,725.37 , - , - -- - - - - 270,141.69 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 191,586.90 Res ECA 51,625.00 31,875.00 74,250.00 157,750.00 Bldr ECA 3,500.00 8,400.00 33,440.00 - 45,340.00 Promotional ' 97,557.53 134,027.96 163,091.41 - •= - - - 394,676.90 Contractual 2.25 2.25 2.25 6.75 Garage 1,059.43 998.31 2,057.74 Tele pho ne-Va r 924.35 163.90 185.99 1,274.24 Telephone -Fixed 1,850.00 1,850.00 1,850.00 5,550.00 Postal 5,069.13 6,320.00 5.12 11,394.25 IT 1,381.67 1,381.67 1,381.67 4,145.01 Utilities-Gas/Water 26.50 26.50 26.50 79.50 Printing 2,158.97 2,524.00 862.02 5,544.99 Insurance 70.83 70.83 70.83 212.49 Uniforms - Travel 30.00 30.00 Mileage 64.86 65.47 28.77 159.10 Meals 3.00 2.80 1.40 7.20 Cell Phone Stipend Operating Supplies 71.97 435.40 111.86 - 619.23 Memberships 14,429.04 6,065.00 9,000.00 29,494.04 Training 340.12 122.13 462.25 Other Svc . 26,052.57 20,307.37 14,676.85 - - - - - - - - - - 61,036.79 Adm Svc Fxd Chgs UCS 4,100.00 4,100.00 4,100.00 12,300.00 Interfund Svc Chgs-Gen 6,384.17 6,384.17 6,384.17 19,152.51 Dividend - - SNEP 12,591.77 78,966.18 230,736.24 FF 322,294.19 RIA 2079 P1 P2 P3 P4 P5 P6 P7 P8 P9 P10 P11 P12 Total Interfund Svc Chgs-Gen Insurance 1,193.33 1,193.33 1,193.33 3,579.99 - Dividend f( - 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 25,786.72 Vacation Leave - Life Ins CWA 0.68 0.68 0.68 2.04 Life Ins SAMP 30.40 30.40 31.36 92.16 Medical Ins 1,519.07 1,519.07 1,519.07 4,557.21 Social Security - Pension 1,662.86 2,494.29 1,721.06 5,878.21 Workers Comp 36.67 36.67 36.67 110.01 Insurance 8.33 8.33 8.33 24.99 Postage - CLEARWATER GAS SYSTEM UMMARY OF RATE ADJUSTMENT CLAUSE COLLECTIONS Travel Other Charges 1,013.17 74,058.11 75,071.28 Operating Supplies 39.51 71.03 66.49 177.03 Memberships - Trainin! 5990 :,..-Liz...:-.: 484.99 - . E... .. i_. .. _ -. _.. .. _ ., ..:. .� _... ,; .t L _. ... ... [[ Yom.... [[6,474,9g � 1 p�'ti!' 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 6,755.01 Interfund Svc Chqs-Gen 5,144.17 5,144.17 5,144.17 15,432.51 Dividend - Festivals & fuel 24,387.96 LP and va.onzation 387.30 86.61 165.88 R E 5 Oct -19 Nov -19 E Dec -19 Jan -20 R Feb -20 ✓ Mar -20 Apr -20 A May -20 T Jun -20 Jul -20 ( Aug -20 Sep -20 0 Total C O Oet-19 Nov -19 M Dec -19 M Jan -20 Feb -20 O Mar -20 p Apr -20 May -20 Jun -20 r Jul -20 Aug -20 y Sep -20 Total 4Tr4G/finom r * Z CGS Natural Gas Summary Monthly Actual/Projections (FY20) 9 Volume FTS -1 $0.5316 Cost FTS -2 $0.8318 Volume Cost No -Notice $0.0478 Volume Cost Capacity Relinquishment Volume Rate Cost Reservation Adjustments TOTAL RESERVATION COST Total Rate 170,438 $ 90,638.93 41,788 $ 26,401.86 15,500 $ 740.90 (13,860) $ 0.2914 $ (4,038.98) $33.66 $ 113,776.17 $0.5320 306,570 $ 183,033.93 53,430 8 33,757.07 22,500 $ 1,078.50 (78,211) $ 0.2325 $ (18,187.11) 5123.90 $ 179,803.29 50.5909 318,789 $ 168,468.39 55,211 $ 34,882.31 31,000 $ 1,481.80 (85,031) $ 0.2667 $ (17,346.58) $159.08 $ 187,845.00 50.5552 316,789 $ 168,468.39 55.211 5 34882.31 46,500 $ 2,222.70 (40.000) $ 0.2000 $ (8,000 00) $0.00 $ 197,573.40 $0.5220 286,132 $ 152,165.00 49,868 $ 31,506.60 42.000 $ 2,007.60 (40,000) $ 0.2000 $ (8.000 00) $0.00 $ 177,679.20 50.5257 316,789 $ 168,468.39 55,211 5 34,882.31 31,000 $ 1,481.80 (40.000) $ 02000 $ (8.000.00) $0.00 $ 196,83250 SO 5422 216.570 $ 115,171 93 53430 $ 33 757 07 22.500 5 1,075 50 (40 000) $ 0 2000 S (8,000 00) 50 00 $ 142.004 50 $0 5624 144,212 $ 76,691.94 41,788 $ 26.40166 12,400 $ 592.72 (40,000) S 0.2000 $ (8.000.00) $0.00 $ 95,686.32 $0.6041 139,560 5 74,218.01 40.440 $ 25,54999 10.500 $ 501.90 (10,000) $ 0.2000 $ (2,00000) $0.00 $ 98.269.90 50.5444 144,212 $ 76,691 94 41.788 $ 26401.66 10,850 $ 518.63 (10,000) $ 02000 $ (2.000.00) $0.00 $ 101,61223 505438 144,212 $ 76,691.94 41,788 $ 26.40166 10.850 $ 518.83 (10.000) $ 02000 $ (2,000.00) 50,00 $ 101,612.23 $0.5438 139,560 $ 74,218.01 40440 $ 25,549.99 10,500 $ 501.90 (10,0001 $ 02000 $ (2,000 00) $0.00 $ 98,269 90 50.5444 2,641,833 $ 1,404,926.79 570,393 $ 360,374.30 266,100 $ 12,719.58 (397,102) 241,000 ($87,572.65) $316.62 $1,690,764.64 80.5487 60.5318 $0.6318 80.0478 as of 1/29/2020 Volume FTS -1 (Usage) Rate Cost Volume FTS -2 (Usage) Rate Cost Gas Supply (FGU & Interconnects) Volume Rate Cost Fuel % FGU Management fee $0.060 No Notice Usage GTI Payment $0.020 Cashout Prior Month Adjustment COMMODITY COST 152,982 $ 0.0539 $ 8,248.28 41,788 $ 0.0533 $ 2,227.30 281,840 $ 2.1238 $ 598,563.20 2.44% $ 12,161.00 $ - $ 3,930.80 $ (2,236.55) $ 40,158.90 $ 663,052.93 179,670 $ 0.0533 $ 9,576.40 53,430 $ 0.0533 $ 2,847.82 341,988 $ 2.0711 $ 708,284.74 2.44% $ 13,097.00 $ - $ 4,662.00 $ 2,792.73 $ (2,003.25) $ 739,257.44 191,019 $ 0.0533 $ 10,181.29 55,211 $ 0.0533 $ 2,942.75 270,972 $ 2.6435 $ 718,310.13 2.44% $ 14,967.00 $ - $ 4,924.60 $ (3,692.24) $ 452.10 $ 746,085.63 212,789 5 0.0418 $ 8,894.58 55,211 5 00415 $ 2,291.26 381,335 $ 2.1241 S 810,01299 3.00% 5 16,080.00 5 - 5 5.36000 $ - 5 - $ 842,638.83 207,132 $ 0.0418 $ 8,658.12 49,868 $ 0.0415 $ 2,069.52 362,000 $ 2.2880 $ 821 023.30 3.00% S 15.42000 5 - 5 5,140.00 S - 5 - $ 852,310.94 176,789 5 0.0418 $ 7,389.78 55,211 5 00415 $ 2,291.26 302,000 $ 2.4973 $ 754.173 70 3.00% S 13,92000 $ - 5 4.640.00 S - S $ 782,414.74 162,570 $ 00418 $ 6,795.43 53,430 $ 0.0415 $ 2,217.35 286,000 $ 2.3417 $ 669.731.00 300% S 12,960.00 5 - 5 4,320.00 5 - S - $ 696,023.77 160,212 $ 0.0418 $ 6,696.86 41.788 S 0.0415 $ 1,734.20 260,000 $ 2.3789 S 617,988.70 3 00% $ 12 120 00 $ - $ 4,040 00 5 - 5 - $ 642,579.76 142 560 $ 0 0418 $ 5,959.01 40,440 5 0.0415 $ 1,678.26 241,000 $ 2.2281 $ 536.981 00 3 00% 5 10 980 00 $ - 5 3 660 00 5 - 5 $ 559,258.27 140.212 $ 0 0418 $ 5,880.86 41,788 5 0 0415 $ 1,734.20 238,000 $ 2.2387 $ 532.803.70 3.00 % $ 10,920.00 5 - $ 3.640 00 $ -. 5 - $ 554,958.76 140.212 $ 0.0418 $ 5,860.88 41.788 S 0 0415 $ 1,734.20 238,000 $ 2.2243 S 529,376 65 3 00% S 10,920 00 $ - 5 3,640 00 5 5 - $ 551,531.71 141.560 S 0 0418 § 5,917.21 40,440 $ 0.0415 $ 1,678.26 243,000 $ 2.1994 5 534.464.50 3 00% $ 10.920 00 5 - 5 3,640 00 S - 5 - $ 556,819.97 2,007,707 ," .., ,t ..:.;- $ 90,038.67 570,393 .; ,-, -'- $ 25,448.38 3,446,135 ..;; ,;. y>: $ 7,829,713.61 $154,465.00 50.00 551.597.40 ($3,138.08) $38,607.75 58,186,732.75 TOTAL COST Resery & Comm RATE $ 776,829.10 $ 2.76 $ 919,080.73 $ 2.89 $ 933,730.63 $ 3.45 $ 1,040,212.23 $ 2.73 $ 1,029,990.14 $ 2.85 $ 979,247.24 $ 3.24 $ 838,028.27 S 2.93 $ 738,266.08 $ 2.84 $ 657, 528.17 $ 2.73 $ 656,570.99 $ 2.78 $ 653,143.94 $ 2.74 $ 654,889.87 $ 2.70 $ 9,877,497.39 $ 2.87 Total Projected DTH WACOG Total Reservation Total Commodity Cost Purchased 1616 Months $ 1,053,309.56 $ 4,625,760.50 $ 5,679,070.08 1,940,135 22.927 2nd 8 Months $ 637,455.08 $ 3,560,972.25 $ 4,198,427.33 1,508,000 $2.788 TOTAL $ 1,690,764.84 $ 8,188,732.75 $ 9677,497.39 3,446,135 $2.866 4-7irRei►9z3c i3 Propane Weighted Average Cost of Gas (WACOG) FY 2019-20 1/29/2020 Date Company Invoice Targa I Shipping Gallons Delivered Propane Rate Propane Cost Shipping Cost Total Cost FYTO Gallons Cost of Inventory Tank Inventory Tank Withdraw) WACOG 109/30/19 : . - `-. ' :at.- . . 5 .r;;^ .^ r° (: , <y' -'- NV EBt1:EotsJu .' -' ,- s. ' • ,. >: .:..., $ 31,355.87 46,277 0.67757 110/09/19 Targa 190437691 8,722 0.77445 $ 6,262.40 $ 492.31 $ 6,754.71 8,722.0 $ 38,110.58 54,999 0.69293 10/28/19 Targa 19045855 j 18,308 1.325 0.75414 S 12,773.32 $ 1,033.40 $ 13,808.72 27,030.0 $ 51,917.30 73,307 0.70822 110/31/19 MONTHLY INVENTORY ADJUSTMENT 1.51739 S 2,010.54 $ 2,010.54 28,355.0 $ 53,927.84 74,632 0.72258 10/31/19 END OF MONTH f.`,,...' '�` ./ ,a•i;', ;.r» - - ,.-= :-;'4., - - . - - ... - ' S 31,836.30 44,059 30,573 0.72258 11/07/19 Targa 190475131 8,817 0.80592 $ 6,606.14 $ 499.69 $ 7.105.83 37,172.0 $ 38,942.13 52.876 0.73648 111/08/19 Targa 19047738, 8,849 0.80093 $ 6,585.88 $ 501.51 S 7,087.39 46,021.0 S 46,029.52 61.725 0.74572 11/19/19 Targa 19050156' 17,397 431 0.82332 $ 13,337.31 $ 985.97 S 14,323.28 63,418.0 $ 60,352.80 79,122 0.76278 11/30/19 MONTHLY INVENTORY ADJUSTMENT 2.70097 S 1.164.12 $ 1,164.12 63,849.0 $ 61,516.92 79,553 0.77328 11/30/19 END OF MONTH -.. " . .. .. , . - $ 39,657.78 51,285 28.268 0.77328 12/10/19 Targa 19053996: 17,990 0.80760 6 13,51329 S 1,015.44 $ 14,528.73 81,839.0 S 54,186.51 69,275 0.78219 12/18/19 Targe 19055273, 8.973 490 0.79257 $ 6,605.26 $ 506.48 $ 7,111.74 90,812.0 $ 61,29825 78,248 0.78338 12/31/19 MONTHLY INVENTORY ADJUSTMENT 1.83373 $ 898.53 $ 898.53 91,302.0 $ 62,196.78 78,738 0.78992 12/31/19 END OF MONTH (, '� . `. .. .. . -, _ _ ;; $ 31,619.74 40,029 38,709 0.78992 01/13/20 Targa 200029191 I 9,391 0.71842 S 6,214.50 $ 532.22 $ 6,746.72 100,693.0 $ 38,366.46 49.420 0.77633 01/14/20 Targa 20003452` 9,118 0.71092 S 5,965.45 $ 516.76 $ 6.48221 109.811.0 $ 44,848.67 58,538 0.76615 I 1 , FYTD Totals1 27.030 0.76069 $ 19,035.72 $ 1,525.71 $ 20,561.43 Delivered Month CGS Cost Dec -19 Jan -20 $ Feb -20 $ Mar -20 $ Apr -20 $ May -20 $ Jun -20 $ Jul -20 $ Aug -20 $ Sep -20 $ 0.75 0.85 0.85 0.85 0.85 0.85 0.85 0.85 0.85 Delivered Gallons 35,000 35,000 45,000 45,000 35,000 28,000 28,000 28,000 28,000 Delivered Cost 26,250.00 29, 750.00 38,250.00 38,250.00 29,750.00 23,800.00 23, 800.00 23,800.00 23,800.00 Projections Cost of Inventory $ 57,870.00 $ 60,624.44 $ 70,593.97 $ 71,483.44 $ 63,402.17 $ 57,625.93 $ 57,707.72 $ 57,755.85 $ 57,784.17 Total EOM Tank EOM Tank Projected Gallons Gallons Cost WACOG 40,029 $ 31,620.00 0.79 75,029 40,029 $ 30,874.44 0.77 75,029 40,029 $ 32,343.97 0.81 85,029 40,029 $ 33,233.44 0.83 85,029 40,029 $ 33,652.17 0.84 75,029 40,029 $ 33,825.93 0.85 68,029 40,029 $ 33,907.72 0.85 68,029 40,029 $ 33,955.85 0.85 68,029 40,029 $ 33,984.17 0.85 68,029 40,029 $ 34,000.83 0.85 CSW: 1/29/2020 CLEARWATER GAS SYSTEM NATURAL GAS RATE BILLING FACTORS FOR FEBRUARY 1, 2020 - SEPTEMBER 30, 2020 BASED ON APPROVED GAS ADJUSTMENT FACTORS Attachment #4 Interr. Contract Firm Natural Gas Rate Schedules NG Rate NG Rate RS SMF MMF LMF SGS MGS LGS RAC GAC LAC SL SL wIM& NGV NSS IS CNS Relight (Non -Real) (Non -Res!) Applicable Annual Therm Range NA (1 - NA (4 + NA (4 + NA (4 + 0 - 18,000- 100,000 NA (1 - NA (0 - NA (150 NA NA NA NA 100,000 NA or Other Rate Determinant 3 Units) Units) Units) Units) 17,999 99,999 & up 3 Units) 149 tons) tons & +) & up Monthly Customer Charge $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 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) ($75.00) $400.00 (By Contract) if not prey. if not prey. if not prey. Non -Fuel Energy Charge/Therm billed billed billed Non -Fuel Energy Charge $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 By Contract Energy Conservation Adj. (ECA) 0.26 0.26 0.26 0.26 0.26 0.26 0.26 NA NA NA NA NA NA NA NA NA Regulatory Imposition Adj. (RIA) 0.00 0.00 0.00 0.00 0.00 0.00 0.00 NA NA NA NA NA NA NA NA NA Usage & Inflation Adj. (UTA) 0.09 0.09 0_09 0,09 0.08 Q.0$ 0.08 NA NA NA NA NA NA NA NA NA Total Non -Fuel Energy Charge $0.79 $0.79 $0.79 $0.79 $0.76 $0.72 $0.68 $0.20 $0.15 $0.10 $0.20 $0.35 By Contract $0.42 $0.24 By Contract Purchased Gas Adjustment (PGA) 0.86 am 0_86 0.86 0_86 0$$ Q,$$ 0_86 0.86 Q$$ Q,M 1.0. 0.76 0.86 0.76 0.76 Total Energy Charge/Therm 1.65 1.65 1.65 1.65 1.62 1.58 1.54 1.06 1.01 0.96 1.06 1.21 0.76 1.28 1.00 0.76 + Non -Fuel + 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 $50.00 $250.00 Customer (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) ($75.00) $400.00 Charge + (a premise © premise Oa premise + FAC + FAC + FAC + FAC + Non -Fuel Therm Non -Fuel Therm Rate for Contract Rate for Contract # of Therms # of Therms Compares to LP/Gallon Rate of $ 1.51 $ 1.51 $ 1.51 $ 1.51 $ 1.48 $ 1.45 $ 1.41 $ 0.97 $ 0.92 $ 0.88 $ 0.97 $ 1.11 $ with 8.0% Franchise $ 1.60 $ 1.60 $ 1.60 $ 1.60 $ 1.57 $ 1.53 $ 1.49 $ 1.03 $ 0.98 $ 0.93 $ 1.03 $ 1.17 $ 0.70 $ 1.17 $ 0.92 0.74 $ 1.24 $ 0.97 Change from 9/2014 Therm Rate $ (0.10) $ (0.10) $ (0.10) $ (0.10) $ (0.09) $ (0.07) $ (0.05) $ (0.08) $ (0.08) $ (0.08) $ (0.08) $ (0.08) $ (0.09) $ (0.12) $ (0.13) $ (0.09) % Change from 9/2014 Therm Rate -4.4% -4.4% -4.4% -4.4% -4.2% -3.3% -2.5% -4.3% -4.4% -4.5% -4.3% -4.0% -5.1% -5.6% -7.5% -6.2% Utility Tax Note: Fuel Rate per Therm 10/01/1973 $0.069 $0.069 $0.069 $0.069 $0.069 $0.069 $0.069 $0.069 $0.069 $0.069 $0.069 $0.069 $0.069 $0.069 $0.055 $0.069 Non -Utility Taxable Fuel/Therm $0.791 $0.791 $0.791 $0.791 $0.791 $0.791 $0.791 $0.791 $0.791 $0.791 $0.791 $0.791 $0.691 $0.791 $0.705 $0.691 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 Interruptible Service Rates 1.025 1.026 1.026 1.024 1.024 FY 19120 Avg. 1.046 1.025 CSW:1/29/2020 BTU Factor: BTU Factor: Therm Factor: 2.714 Gallons/100 cubic feet (CCF) 2.483 Therms/100 cubic feet (CCF) 0.915 Therms/Gallon CLEARWATER GAS SYSTEM METERED PROPANE (LP) RATE BILLING FACTORS FOR FEBRUARY 1, 2020 - SEPTEMBER 30, 2020 BASED ON APPROVED GAS ADJUSTMENT FACTORS Attachment #5 Page 1 of 2 RESIDENTIAL MULTI -FAMILY LOOP RESL. SMALL COML. LARGE COML. VEHICLE STANDBY/GENERATOR CONTRACT MTRD MRLP MMLP LRLP MGLP MLLP LPV LPSM CLP (Non -Real. Only) (Non -Real. Only) Applicable Annual Gallon Range NA NA NA 0 - 2,500 >2,501 NA NA NA or Other Rate Determinant (1 - 3 Units) (4 + Units) (Closed for New Resl. Applications) Monthly Customer Charge $12.00 $25.00 $12.00 $25.00 $40.00 $40.00 $50.00 Set By Contract For Each Meter Non -Fuel Energy Charges/Gallon: Non -Fuel Energy Charge (NFE)/Gallon $1.90 $1.90 $0.90 $0.30 $0.25 Set By Contract $1.00 Set By Contract Energy Conservation Adj.(ECA)/Gallon 0.26 0.26 0.26 0.26 0.26 NA NA NA Regulatory Imposition Adj.(RIA)/Gallon 0.00 0.00 0.00 0.00 0.00 NA NA NA Usage & Inflation Adj. (UTA)/Gallon 0.09 0.09 0.09 0.08 gm NA NA NA Total Non -Fuel Charges (NF)/Gal. $2.25 $2.25 $1.25 $0.64 $0.59 Set By Contract $1.00 Set By Contract Purchased Gas Adjustment(PGA)/Gal. 1.72 1.72 1.72 1.72 1.72 Set By Contract 1.72 1.42 Total Energy Charges/Gallon $3.97 $3.97 $2.97 $2.36 $2.31 Contract NFE $2.72 Contract NFE + + Contract PGA $1.420 Customer Charge Customer Charge + Minimum Monthly Bill $12.00 $25.00 $12.00 $25.00 $40.00 Any Applicable $50.00 Non -Fuel Energy Chg. Customer Charge for the Contracted + Any Applicable # of Gallons/Mo. Facility Charges Utility Tax Note: Fuel Rate per Gallon 10/01/1973 0.161 0.161 0.161 0.161 0.161 0.161 0.161 0.161 Non -Utility Taxable FueVGallon $1.559 $1.559 $1.559 $1.559 $1.559 Contract PGA - 0.161 $1.559 Contract PGA - 0.161 Change from 9/2014 Gallon Rate ($0.20) ($0.20) ($0.20) ($0.19) ($0.19) NA ($0.22) ' NA % Change from 9/2014 Gallon Rate -4.8% -4.8% -6.3% -7.5% -7.6% NA -7.5% NA CSW:1/29/2020 Attachment #5 Page 2 of 2 BTU Factor: 2.714 Gallons/100 cubic feet (CCF) CLEARWATER GAS SYSTEM BTU Factor: 2.483 Therms/100 cubic feet (CCF) BULK PROPANE (LP) RATE BILLING FACTORS Therm Factor: 0.915 Therms/Gallon FOR FEBRUARY 1, 2020 - SEPTEMBER 30, 2020 BASED ON APPROVED GAS ADJUSTMENT FACTORS STANDARD RESIDENTIAL BULK LP SERVICE RESIDENTIAL "WILL CALL" (Rate Class is Based on Annual LP Gallon Usage Level) (Based on Annual Usage Level) BRLPO BRLP1 j3RLP2 BRLE2 pR WRLPO., WRLPL WRLP2 WRLP3 WRLP4 Applicable Annual Gallon Range 0 (No Fills in Yr.) 0.1 - 60 60.1 - 120 120.1 - 300 > 300 0 (No Fills In Yr.) 0.1 - 80 80.1 - 120 120.1 - 300 > 300 or Other Rate Determinant 1-3 UNITS 1-3 UNITS 1-3 UNITS 1-3 UNITS 1-3 UNITS 1-3 UNITS 1-3 UNITS 1-3 UNITS 1-3 UNITS 1-3 UNITS Annual Customer Charge $ 350.00 $ 225.00 $ 180.00 $ 90.00 $ 75.00 $ 350.00 $ 210.00 $ 150.00 $ 75.00 $ 60.00 Non -Fuel Charges INFYGallon: Non -Fuel Energy Charge (NFE)/Gal. $ 1.80 $ 1.80 $ 1.60 $ 1.00 $ 0.90 $ 1.80 $ Energy Conservation Adj. (ECA)/Gal $ 0.26 $ 0.26 $ 0.26 0.26 0.26 0.28 Regulatory Imposition Adj. (RIA)IGaI $ $ $ Usage A Inflation Adj. (UTA)/Gallon 0.09 0.09 0.09 0.09 0.09 0.09 Total Non -Fuel Charges (NF))GaI. $ 2.15 3 2.15 $ 1.95 S 1.35 $ 1.25 8 2.15 $ Purchased Gas Adj. (PGA)/Gallon $ 1.72 $ 1.72 $ 1.72 $ 1.72 $ 1.72 $ 1.72 $ Total Energy Charges/Gallon $ 3.87 3 3.87 $ 3.67 $ 3.07 $ 2.97 $ 3.87 $ Note: No Monthly Minimum Bill Utility Tax Note: Fuel Rate per Gallon 10101/1973 S Non -Utility Taxable Fuel/Gallon $ COMMERCIAL BULK LP SERVICE (Based on Annual Usage Level) Mat BCLPg 0-2,500 '2,500 Customers in this Customers in this Range of Usage Range of Usage $ 90.00 S 90.00 1,80 $ 1.60 S 0.90 $ 0.80 S 0.25 $ 0.20 0.26 0.28 0.26 0.26 0.26 0.26 0.09 0.09 0.09 0.09 0.08 0.08 2.15 $ 1.95 $ 1.25 3 1.15 $ 0.59 $ 0.54 1.72 $ 1.72 S 1.72 S 1.72 $ 1.72 S 1.72 3.87 $ 3.67 $ 2.97 $ 2.87 S 2.31 $ 2.26 BULK STANDBY/ GENERATOR LPSB (Closed for New Residental Applications) $ 420.00 $ 1.00 NA NA NA $ $ 1.00 1.72 S 0.161 3 0.161 3 0.181 $ 0.161 $ 0.161 $ 0.161 $ 0.161 3 0.161 $ 0.161 3 0.161 $ 0.181 5 0.161 $ 1.559 $ 1.559 S 1.559 $ 1.559 $ 1.559 $ 1.559 $ 1.559 $ 1.559 $ 1.559 $ 1.559 $ 1.559 5 1.559 $ 2.72 CONTRACT BULK LP SERVICE CLP Any Contract Customers Who Requests Bulk Del. Set by contract Set By Contract NA NA LL9 Set By Contract 1.42 Cotract NFE • 1.420 0.161 $ 0.161 1.559 Contract PGA - 0.161 Change from 9/2014 Gallon Rate $ (0.200) $ (0.200) $ (0.200) $ (0.20) $ (0.20) $ - $ • $ (0.20) $ (0.20) $ (0.30) S (0.19) $ (0.19) $ (0.22) NA % Change from 9/2014 Gallon Rate -4.9% -4.9% -5.2% -6.1% -8.3% 0.0% 0.0% -5.2% -6.3% -9.5% -7.6% -7.8% -7.5% NA CSW:1r29 2O2o ___ _- --t � 4_ Residential RateAdlustmentslTherm `ECA j Rate History By Components Clearwater Gas System UTA-Coml# PGA Attachment #6 t 4 Contract t PGA Page 1 of 3 - LP PGAlaallon Total $ 0.15 Month NG/therm RIMWNAIUTA-Rest# I- mLPloallon $ 0.09 $ 0.014 $ 0.01 $ 0.79 $ 0.70 Oct -16 $ 1A8 $ 3.09 $ 1.84 $ 1.84 j $ _ 1.84 $ 1.69 $ 1.69 T_ t Nov -16 $ 1.48 $ 3.09$ - 0.15 , $ 0.15 $ 0.15 $ 0.15 $ 0.09 $ 0.01 + $ 0.01 $ 0.79 $ 0.70 Dec -16 16 $ 1.48 $ 3.09 ? $ 2.96 - $ 2.96 r $ 0.09 $ 0.01 $ 0.09 $ 0.03 $ 0.09 ' $ 0.03 $ 0.01 $ 0.79 $ 0.70 $ 0.67 $ 0.67 $ 0.67 t $ 0.70 $ 0.70 $ 0.80 $ 0.80 1 $ 0.80 $ 0.80 Jan -17 Feb -171-$ Mar -17' Apr -17 $ 1.47 1.47 $ 0.04 $ 0.76 7 $ 0.04 $ 0.76 r$ 0.04 $ 0.76 0.05-$ 0.79 $ 0.05 $ 0.79 $ 0.05 $ 0.89 $ 0.05 $ 0.89 $ 0.05 $ 0.89 $ 0.05 $ 0.89 $ 1.47 $ 2.96 $ 1.53 T $ 2.79 $ 0.15 $ 0.18 $ 0.09 $ 0.03 $ 0.09 $ 0.03i$ $ 0.09 $ 0.03 $ 1.69 $ 1.49 $ 1.49 $ 1.34 May -17 $ 1.53 $ 2.79 $ 0.18 Jun -17,4$ Jul -17 1.70 $ 2.71 _ - $ 0.20 $ 0.14 $ 0.03-1- $ 1.70 $ 2.71 $ 0.20 _ $ 0.14 $ 0.03 $ 0.20 i $ 0.14 4 $ 0.03 $ 0.20 $ 0.14 $ 0.03 $ 1.34 $ 1.34 $ 1.34 Aug -17 $ 1.70 t$ 2.71+ Sep -17T $ 1.70 I $ 2.71 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 1 $ 0.010 $ 0.729 $ 0.639 $ 1.486 $ 1.67 $ 3.31 1 1 $ 0.20 $ 0.05 $ 0.05 ' $ 0.05 $ 0.91 $ 0.81 $ 0.91 $ 0.81 t $ 1.99 $ 1.99 $ 1.997 $ 1.99 $ 1.99 Oct -17 $ 0.09 $ 0.03 + Nov -17 $ 1.67 $ 3.31 -1 r $ 0.20 $ 0.09 ? S 0.03 Dec -17 $ 1.67 $ 3.31 $ 0.20+$ 0.09 $ 0.03 $ 0.257 $ 0.09 $ 0.05 $ 0.91 $ 0.81 0.86 $ 0.76 Jan -18 $ 1.69 $ 3.38 $ 0.03--E$ $ 0.03 Feb -18 $ 1.69 $ 3.38 $ 0.25 $ 0.09 $ 0.05 $ 0.86 $ 0.76 Mar -18 $ 1.69 $ 3.38 $ 0.25 $ 0.09 $ 0.05 $ 0.03 $ 0.86 $ 0.76 $ 0.76 $ 0.72 $ 0.72 $ 1.99 r-18 $ 1.69 $ 3.38 $ 0.25 $ 0.09 ' $ 0.05 $ 0.03I $ 0.86 $ 0.82 $ 0.82 $ 1.99 $ 1.95 ' May -18 $ 1.60 $ 3.29 $ 0.25 $ 0.04 $ 0.05 �$ 0.03 I $ 0.03 Jun -18 $ 1.60 $ 3.29 $ 0.25 $ 0.04 $ 0.05 $ 1.95 Jul -18 $ 1.60 $ 3.29 $ 0.25 $ 0.04 $ 0.05 $ 0.03 $ 0.82 5 0.72 $ 1.95 Aug -18 $ 1.60 $ 1.60 $ 3.29 $ 3.29 $ 0.25 $ 0.25 $ 0.04 $ 0.05 $ 0.04 $ 0.057-$ $ 0.03 $ 0.82 $ 0.72 $ 1.95 Sep -18 0.03 $ 0.82 $ 0.72 $ 1.95 FYTD 17/18 Avg. $ 1.648 $ 3.325 I $ 0.238 $ 0.069 ; $ 0.04$ $ 0.035 $ 0.836 $ 0.756 ' $ 1.973 2017 Avg. 1 $ 1.607 $ 2.936 I j $ 0.184 $ 0.107 $ 0.030 $ 0.048 j $ 0.846 $ 0.753 $ 1.615 Oct -18 $ 1.60 $ 3.29 1 $ 0.25 $ 0.04 $ 0.05 $ 0.03 $ 0.03 $ 0.03 $ 0.82 $ 0.82 $ 0.72 $ 1.95 Nov -18 $ 1.60 $ 3.29 $ 0.25 $ 0.04 ' $ 0.05 $ 0.72 $ 1.95 Dec -18 $ 1.60 $ 3.29 $ 0.25 $ 0.04 r $ 0.05 $ 0.82 $ 0.72 $ 1.95 Jan -19' $ 1.60 $ 3.29 $ 0.25 i $ 0.04 ! $ 0.05 $ 0.03 $ 0.82 $ 0.72 S 1.95 Feb -19 $ 1.58 $ 3.27 $ 0.29 - $ - $ 0.03 $ 0.04$ 0.82 $ 0.72 $ 1.95 Mar -19 $ 1.58 $ 3.27 $ 0.29 $ - j $ 0.03 $ 0.04 1 $ 0.82 $ 0.72 $ 1.95 Apr -19 May -19 $ 1.58 $ 3.27 $ 0.29 $ - $ 0.03 $ 0.04 $ 0.82 $ 0.72 $ 1.95 $ 1.95 $ 1.58 $ 3.27 $ 0.29 $ - $ 0.03 $ 0.04 $ 0.82 $ 0.72 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 $ - $ 0.03 $ 0.04 $ 0.04 $ 0.89 $ 0.79 $ 0.89 $ 0.79 $ 1.75 Aug -19 $ 1.65 $ 3.07 $ 0.29 $ - $ 0.03 $ 1.75 Sep -19 $ 1.65 $ 3.07 $ 0.29 $ - $ 0.03 $ 0.04 $ 0.89 $ 0.79 $ 1.75 FYTD 18/19 Avg. 1 $ 1.610 $ 3.210 $ 0.277 $ 0.013 $ 0.037 $ 0.037 $ 0.843 $ 0.743 $ 1.883 2018 Avg. 1 $ 1.630 $ 3.320 $ 0.250 $ 0.057 $ 0.050 $ 0.030 $ 0.833 $ 0.733 5 1.963 _ ~ 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.04 $ 0.89 $ 0.79 $ 0.89 $ 0.79 $ 1.75 $ 1,75 Dec -19 $ 1.85 $ 3.07 $ 0.29 $ - $ 0.03T$ Jan -20 $ 1.65 $ 3.07 $ 0.29 $ - $ 0.03 $ 0.04 $ 0.89 $ 0.79 $ 1.75 Feb -20 $ 1.65 $ 3.07 $ 0.26. $ - $ 0.09 $ 0.084 + t $ 0.86 $ 0.76 * $ 1.72 Mar -20 r Apr 20 M20 Mm -20 Jun -20 Jul -20 Aug -20 Sep 20 FYTD 19120 Avg. $ 1.650 $ 3.070 I $ 0.284 $ $ 0.042 $ 0,048 $ 0.884 $ 0.784 $ 1.744 2019 Avg. $ 1.623 $ 3.155 I $ 0.287 I $ 0.003 $ 0.032 $ 0.039 1 $ 0.861 $ 0.761 5 1.833 _ $ 0.04 $ 0.04+$ 0.04 5% 6% $ (0.23) -12% Incr. Above $ 0.07 $ (0.20) $ (0.03). $ - $ 0.06E Last Year -10%� NA 200% 100% Same Month 4% -6% -r Incr. Based $ 2.80 $ (8.74) r on 40 Therms 4% -6% t Equivalent + Cents/KWH 5.6 11.5 rt KWH in February cents/KWH. for Gas } Florida's L 2020 is 13.708 vs. Duke Rate 13.7 13.7 Note: Duke Energy residential rate for usage >1.000 (Residential) T rt r t - T 7 +I - - Gas Cheaper t i- r 1 by -59% -16% t + for customers using changes: 1 LP Will ] 4 t t 1- Notes. 120.1 - 300 gallons/year & equal to Residential I • Based on Bulk LP (BRLP3) which is applicable Call (BRWCLP). f # New rates implemented 11/1/2014, with following L - RS NG Customer Charge increased $2 from $10 to $12/month & NFE rate droped 4 cents to 44 cents/therm. UTA decreased by 9 cents/therm to 0. T - BRLP3 LP Customer Charge unchanged © $90/year, and NFE rate unchanged @ $1.00/gallon. UTA decreased by 9 cents/gallon to 0. -T-1 1 I t- RIA & ECA unchanged initially. CSW:08/26/201 9 Attachment #6 Page 2 of 3 Competitive History of NG vs. Electric Rates Month -Year September 2001 September 2002 September 2003 September 2004 September 2005 September 2006 September 2007 September 2008 September 2009 September 2010 September 2011 September 2012 September 2013 September 2014 September 2015 September 2016 September 2017 September 2018 September 2019 NG Therm Cost $ 1.34 $ $ 1.36 $ $ 1.56 $ $ 1.69 $ $ 1.97 $ $ 1.89 $ $ 1.86 $ $ 2.12 $ $ 1.39 $ $ 1.39 $ $ 1.42 $ $ 1.48 $ $ 1.67 $ $ 1.75 $ $ 1.57 $ $ 1.38 $ $ 1.70 $ $ 1.60 $ $ 1.65 $ $ Increase over Last 18 Years $ 0.31 $ % Increase over Last 18 Years 23.1% Avg. Annual Inc. Over Last 18 Yrs. 1.3% NG Equivalent KWH Cost 0.046 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% CSW:08/26/2019 L Residential Attachment #6 Page 3 of 3 Rates CGS Annual Average I Calender Year _ Fiscal Year Year NG/Therm LP/Gallon * Year NG/Therm i LP/Gallon * 1995 1996 NA NA FY 95/96 'FY 96/97 $ 0.880-'-$ 1.199 $ 1.019 i $ 1.370 t* , * $ 0.915 $ 1.239 * 1997 $ 1.049 $ 1.380 ' * FY 97/98 1.FY 98/99 -FY 99/00 $ 1.054+ $ 1.318_1-* $ 1.052 $ 1.269-* $ 1.152 $ 1.504 1998 1999 $ 1.032 $ 1.288 T* r $_ - 1.073 $ 1.311 2000 $ 1.222 $ 1.584 FY 00/01 $ 1.551, $ 1.649 i 2001 $ 1.549 $ 1.586 FY 01/02 $ 1.352 $ 1.488 2002 $ 1.342 $ 1.553 FY 02/03 $ 1.477{ $ 1.817 2003 $ 1.534 $ 1.864 FY 03/04 $ 1.603 $ 1.913 2004 $ 1.652 $ 1.968 FY 04/05 $ 1.803 T $ 2.162 2005 $ 1.925 $ 2.278 FY 05/06 $ 2.080 1--$ 2.480 2006 $ 2.012 $ 2.501 FY 06/07 $ 1.918 t $ 2.742 2007 $ 1.893 $ 2.869 FY 07/08 $ 1.932 1 $ 3.183 2008 $ 1.965 $ 3.186 FY 08/09 $ 1.610 $ 2.524 2009 $ 1.464 $ 2.418 FY 09/10 $ 1.437 t $ 2.865 2010 $ 1.457 $ 2.946 FY 10/11 $ 1.475 $ 3.282 2011$ 2012 1 1.487 $ 3.438 FY 11/12 $ 1.506 ; $ 3.639 $ 1.501 $ 3.548 FY 12/13 $ 1.582 $ 3.257 2013 $ 1.629 $ 3.297 FY 13/14 $ 1.629 I $ 3.297 2014 $ 1.717 $ 3.528 FY 14/15 $ 1.602 j $ 3.133 2015 $ 1.576 $ 3.003 FY 15/16 $ 1.479 1 $ 2.718 2016 $ 1.452 $ 2.768 FY 16/17 $ 1.700 1 $ 2.710 2017 $ 1.607 $ 2.936 FY 17/18 $ 1.607$ 2.936 $ 1.610T$ 3.210 2018 $ 1.630 $ 3.320 FY 18/19 2019 $ 1.623 $ 3.155 t t r Average $ 1.513 $ 2.457 $ 1.500 $ 2.368 --r A Notes: t * Based on the Residential Metered Propane schedule which was closed for FY 99/00 and beyond using new customers effective March 8, 1999. For 1999 & based on Bulk LP (BRLP3) which is applicable for customers 120.1 - 300 gallons/year & is equal to Residential LP Will Call CSW:1/9/2020 ATTACHMENT #7 CALCULATION OF USAGE & INFLATION ADJUSTMENT (UTA) FOR FY 2018/2019 Collected in FY 2019/2020 for Billings Beginning February 1.2019 Usage Adjustment Calculations: 1. Residential Single -Family Natural Gas Use/Customer: Average Number of Total FY 18/19 Therms Used FY 18/19 Customers Therm Usage Per Customer 21,053 3,802,055 180.6 Threshhold for application of UTA per Rate Ordinance = Less Than 197 Therefore, Residential Single Family Usage Adjustment = 9.08% Applicable FY 18/19 Total Residential Non -Fuel Energy Revenues = $ 2,033,674.01 Added FY 19/20 UAI Residential Revenues from Usage Shortfall = $ 184,742.86 2. Commercial (Non -Interruptible) Natural Gas Use/Customer: Average Number of Total FY 18/19 Therms Used FY 18/19 Customers Therm Usage Per Customer 2,447 14,325,622 5,854.4 Threshhold for application of UTA per Rate Ordinance = Less Than 6,203 Therefore, Commercial Usage Adjustment = 5.96% Applicable FY 18/19 Total Commercial (Non -Inter.) Non -Fuel Revs = $ 5,704,538.14 Added FY 19/20 UAI Commercial Revenues from Usage Shortfall = $ 339,716.48 Inflation Adiustment Calculations: Actual U. S. Dept. of Labor CPI -U for September 2014 = 239.702 Actual U. S. Dept. of Labor CPI -U for September 2019 = 256.759 CPI -U Inflation Increase Applicable to FY 18/19 Revenues = 7.116% Authorized UTA Recovery for FY 2018/2019: 1. Residential Single -Family Recovery for FY 2019/2020 Usage Portion = Inflation Portion = Subtotal = Less Proj. Over Rec. thru January 2020 = $ 184,742.86 $ 144,714.59 $ 329,457.46 $ (70,000.00) Total = $ 259,457.46 Projected Therms & Gallons to Recover on for Feb - Sept of FY 19/20 = 3,000,000 Projected Residential UTA Recovery Required = $ 0.086 Recommend Round to = $ 0.09 2. Commercial (Non -Interruptible) Recovery for FY 2018/2019 Usage Portion = Inflation Portion = Subtotal = Less Proj. Over Rec. thru January 2020 = $ 339,716.48 $ 405,930.31 $ 745,646.79 $ (140,000.00) Total = 1 $ 605,646.79 Projected Therms & Gallons to Recover for Feb - Sept of FY 19/20 = 8,000,000 Projected Commercial UTA Recovery Required = $ 0.076 Recommend Round to = $ 0.08 ‚.. \ Clearwater Gas System Live Greener )IthGas Fuel Use and Cost Comparison (Effective Rates for February 2020) Want to make the switch to natural gas? Call Clearwater Gas System, today at (727) 562-4980. APPLIANCE ANNUAL THERMS USED NATURAL GAS PROPANE (LP) GAS I ELECTRIC COOKING 35 $ 57.75 $117.60 $140.70 WATER HEATING -Gas Tank Style/Gas Tankless vs. Electric Tank Style 150/100 $247.50/$165.00* $504.00/$336.00* $603.00 HEATING 130 $214.50 $436.80 $522.60 CLOTHES DRYING 50 $ 82.50 - $168.00 $201.00 TOTAL APPLIANCE USAGE — with tank/tankless $602.25/ $519.75* $1,226.40/ $1,058.40* $1,467.30 GAS SAVINGS VS. ELECTRICITY 59% / 65%* 16%/ 28%* *when using tankless *when using tankless- LP OUTDOOR RECREATION POOL HEATING* I 250 I $412.50 $840.00 I $1,005.00 SPA/HOT TUB HEAT* I 125 I $206.25 $420.00 I $ 502.50 *varies according to pool size, weather conditions, and temperature maintained I All other figures are annual average projections based upon the following: 1. 1 therm = 100,000 BTUs of energy 2. Natural Gas $1.65 , per therm I per gallon or , $3.36 per therm 3. LP Gas per gallon (BRLP3) $3.07 4. Duke Energy per KWH (Based on >1000 KWH rate) $0.13708 Per KWH or $4.02 per therm 1. Notes: The above analysis is based on or franchise fees. Maple Street February 2020 residential energy and fuel charges • Clearwater, FL 33756 • (727) 562-4980 www.clearwatergas.com and does not ystem $12.00 and Amnanrlina nn include applicable taxes 2. Current mon 777 Duke Energ; con nn ,n r, -