Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
GAS ADJUSTMENTS EFFECTIVE JANUARY 1, 2018
TO: FROM: COPIES: SUBJECT: DATE: CLEARWATER GAS SYSTEM Interoffice Correspondence Sheet William B. Home II, City Manager Chuck Warrington, Managing Director Rosemarie Call, City Clerk; Micah Maxwell, Assistant City Manager CGS & UCS Management Teams; Janet Dorrough, Sr. Accountant/CGS; Laura Damico, Sr. Accountant/UCS; Lynne Priester, Cust. Serv. Coord./UCS; Lindsey Bessette, Systems Analyst/UCS GAS ADJUSTMENTS EFFECTIVE JANUARY 1, 2018 December 22, 2017 Natural Gas supply prices have dropped a little from anticipated; therefore, we are recommending a decrease of 5¢ per therm in our Natural Gas Purchase Gas Adjustment (PGA) for January. But, Propane (LP) supply prices have remained fairly stable; therefore, we are recommending no change in our Propane (LP) PGA for January. We recommend that we continue our standard Contract LP PGA be set at 30¢ below our Standard LP PGA. We are recommending an increase in our Energy Conservation Adjustment (ECA) of 5¢ per therm or gallon in January to meet the higher demand for appliance rebates due to growth, but no change in our Regulatory Imposition Adjustment (RIA). We have reassessed our Usage & Inflation Adjustments (UTAs) based on last year's inflation and usage, and are recommending a 2¢ per therm or gallon increase for Residential UTA but a 2¢ per therm or gallon decrease in our Commercial UTA for January. The net effect of these recommended changes for January is a 2¢ per therm increase (+1.2%) in our typical Residential Natural Gas customer's rate and a 7¢ per gallon increase (+2.1%) 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 January 1, 2018: Natural Gas Firm Standard Rate Schedule PGA Natural Gas Interruptible and Contract (Non -Standard) Rate Schedule PGA Propane (LP) Gas Standard Rate Schedule PGA Propane (LP) Gas Contract Rate Schedule PGA Energy Conservation Adjustment (ECA) Regulatory Imposition Adjustment (EIA) Usage & Inflation Adjustment (UTA) - Residential - Commercial $0.86 per therm (down 5¢ per therm) $0.76 per therm (down 5¢ per therm) $1.99 per gallon (no change) $1.69 per gallon (no change) $0.25 per therm or gallon (up 5¢) $0.09 per therm or gallon (no change) . $0.05 per therm or gallon (up 2¢) $0.05 per therm or gallon (down 2¢) William B. Horne II, City Manager December 22, 2017 Page 2 Attachment #1 shows the status of our Adjustment Recovery Clause balances with actuals thru November. 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. Attachment #4 shows our projections for required UTAs for FY 17/18. Attachments #5 and #6 show the impact of these adjustment clause changes on our overall Natural and LP Gas rates, respectively. Attachment #7, Page #1, shows our monthly rate history over the past year and a quarter, and Pages #2 and #3 of this show our 16 -year relationship to electric prices and average residential rates, respectively. Please note that Page #2 of this analysis shows that, over the past 16 years, our residential natural gas rates have risen an average of just 1.7% annually as compared to a 3.4% average annual increase for the Duke Energy (formerly Progress Energy Florida/FPC) residential rates. That's half the inflation in our energy costs on average for natural gas vs. electric --- a remarkable difference! And, we expect Duke Florida's rates to increase in January even more. I should point out that the overall effect is that our typical Residential customer rates are now approximately 56% lower than electric for Natural Gas and 4% 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 increased our standard posted price at our Natural Gas Vehicle (NGV) Fueling Station effective September 18, 2017, to $1.67 per gasoline gallon equivalent (GGE --- up 8¢) --- still 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 new price effective October 1, 2017, is $1.49/gge (also up 8¢), as these fleets pay no Federal taxes on fuel --- still an amazing price. This increase is needed as a result of the Congress not passing the Tax Extender package this year, which prior to January 1, 2017, gave us a 50¢/gge Excise Tax Credit for NGV vehicle fuel. We are hopeful that this 50¢/gge Excise Tax Credit for NGV vehicle fuel will be reinstated by Congress early in 2018. There is a bill in the works now to hopefully accomplish this. 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 January 1' billings. If you have any questions on this, please call me. CSW/cw Attachments Approved: Will' Home II, City Manager ll c#I4 /1/04/( U:\My Documents\MSOFFICE\WINWORD\GASRATES\Gas Adjustments for January 2018.docx CLEARWATER GAS SYSTEM SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTIONS FOR FY 2017/2018 Attachment #1 Page 1 of 4 NATURAL GAS PURCHASED GAS ADJUSTMENT (PGA -NG) Month l ry Cumulative NG PGA Budget Reservation Commodity Interest Cost Center Total NG Fuel Total NG PGA Overage YTD Overage Rate/Therm r Month Charges Charges Expense Expenses Expenses Billed (Shortage) (Shortage) Firm/Contr____ Prior Year - $ (1,159,669.47) Oct -17 $ 4,136,207.24 853,186.28 $ 5,798.35 $ 35,545.69 1 $ 5,030,737.56 $ 1,323,029.28 $ (3,707,708.28) $ (4,867,377.75) 0.91/0.81 Nov -17 $ 188,582.81 696,640.41 $ 24,336.89 $ 31,975.76 $ 941,535.87 1,538,929.43 $ 597,393.56 $ (4,269,984.19) 0.91/0.81 Dec -17 $ 204,800.00 850,000.00 $ 21,349.92 $ 40,000.00 $ 1,116,149.92 1,880,079.89 $ 763,929.97 $ (3,506,054.22) 0.91/0.81 Jan -18 $ 205,500.00 1,100,000.00 $ 17,530.27 $ 40,000.00 $ 1,363,030.27 2,048435.06 $ 685,404.78 $ (2,820,649.44) 0.86/0.76 Feb -18 $ 184,900.00 1,000,000.00 $ 14,103.25 $ 40,000.00 $ 1,239,003.25 1,975,014.44 $ 736,011.20 $ (2,084,638.24) 0.86/0.76 Mar -18 $ 202,300.00 900,000.00 $ 10,423.19 $ 40,000.00 $ 1,152,723.19 1,886,909.71 $ 734,186.52 $ (1,350,451.72) 0.86/0.76 Apr -18 $ 147,400.00 850,000.00 $ 6,752.26 $ 40,000.00 2 $ 1,044,152.26 1,703,358.18 $ 659,205.92 $ (691,245.80) _ 0.86/0.76 May -18 $ 97,400.00 750,000.00 $ 3,456.23 $ 40,000.00 $ 890,856.23 1,585,885.20 $ 695,028.98 $ 3,783.18 0.86/0.76 Jun -18 $ 97,600.00 700,000.00 $ - $ 40,000.00 $ 837,600.00 1,483,096.35 $ 645,496.35 $ 649,279.53 0.86/0.76 Jul -18 $ 101,100.00 650,000.00 $ - $ 40,000.00 $ 791,100.00 1,343,597.19 $ 552,497.19 $ 1,201,776.71 0.86/0.76 Auu_ -18 $ 101,100.00 650,000.00 $ - $ 40,000.00 ' $ 791,100.00 1,336,255.13 $ 545,155.13 $ 1,746,931.84 0.86/0.76_ Sep-18 $ 97,600.00 650,000.00 $ - $ 40,000.00 $ 787,600.00 1,336,255.13 $ 548,655.13 $ 2,295,586.96 0.86/0.76 Per13 $ 1,871,264.89 4,5,7 $ 1,871,264.89 - $ (1,871,264.89) $ 424,322.08 _ Total YTD $ 5,764,490.05 $ 9,649,826.69 $ 103,750.35 $ 2,338,786.34 $ 17,856,853.43 $ 19,440,844.98 $ 1,583,991.55 (1) Includes Annual Admin Charge of $724,960 + UCS chg of $1,326,130 + Dividend $1 958,710 i + FY 16/17 PGA write off of $10,456.72 + WNA $304.98 = $ 4,020,561.70 (5) Pension Adjustment = $ - ___ _ (2) Additional Dividend based on FY 16/17 Net Income = $ - (6) Accrual = $ - _ __ (3) Bulk mailing & printing $ - (7) Commodity adjustment from FYE transfer of ECA Collected ----- ----- in PGA © Annual ECA Shortfall (4) OPEB liability & Period 13 Adjustment $ - NG Proportion = 98.5% x Total ECA Transfer = , $ 1,871-;-264.89- ,871 264.89Net NetRC = $ 1,743,928.35 Average Annual PGA/Therm = $0.744 Avg Fuel On iy = _ $0.369 DeltalTherm = $0.375 PROPANE (LP) GAS PURCHASED GAS ADJUSTMENT (PGA-LP1 __ __ _ -- Monthly Cumulative i —LP PGA-- — __Budget_ Gallons Monthly Interest Commodity Total LP Fuel Total LP PGA Overage YTD Overage Therm/Gal. Month Sold WACOG Expense Charges Expenses Billed (Shortage) (Shortage) Prior Year $ 32,602.71 Oct -17 28,383.1 $ 1.10762 $ - $ 31,437.69 1,2 $ 295,464.36 $ 52,921.65 $ 242,542.71 $ 209,940.00) 2.17/1.99 Nov -17 24,958.9 $ 1.18704 $ 1,049.70 29,627.21 30,676.91 49,627.18 $ 18,950.27 $ (190,989.74 2.17/1.99 Dec -17 38,000.0 $ 1.21000 $ 954.95 45,980.00 46,934.95 73,205.18 $ 26,270.23 7$ (164,719.51) 2.17/1.99 Jan -18 46,000.0 $ 1.21000 $ 823.60 55,660.00 56,483.60 88,616.79 $ 32,133.19 $ (132,586.31) 2.17/1.99 Feb -18 42,000.0 $ 1.16000 $ 662.93 48,720.00 49,382.93 80,910.98 $ 31,528.05 $ (101,058.26) 2.17/1.99 Mar -18 43,000.0 $ i 1.13000 $ 505.29 48,590.00 49,095.29 82,837.44 $ 33,742.14 __ $ (67,316.12) 2.17/1.99 Apr -18 May -18 32,000.0 28,000.0 $ 1.12000 $ 1.04000 $ 336.58 $ 209.23 35,840.00 29,120.00 36,176.58 29,329.23 61,646.46 53,940.66 $ 25,469.88 $ 24,611.42 $ (41,846.23) 2.17/1.99 _ $ (17,234.81) 2.17/1.99 Jun -18 28,000.0 $ 0.99000 $ 86.17 27,720.00 27,806.17 53,940.66 $ 26,134.48 _ _ $ 8,899.67 2.17/1.99 Jul -18 28,000.0 $ 0.97000 $ - 27,160.00 27,160.00 53,940.66 $ 26,780.66 $ 35,680.33 2.17/1.99 Aug -18 28,000.0 $ 0.95000 $ - 26,600.00 26,600.00 53,940.66 $ 27,340.66 _ $ 63,020.99 2.17/1.99 Sep -18 28,000.0 $ 0.93000 $ - 26,040.00 26,040.00 53,940.66 $ 27,900.66 $ 90,921.64 2_.17/1.99 P13 4 89,469.75 - $ (89,469.75) $ 1,451.89 Total YTD 394,342.0 $ 1.09675 $ 4,628.45 $ 432,494.90 $ 790,619.78 $ 759,468.96 $ (31,150.82) Cost Center Expenses —__ CCS Chg, Admin & Dividend $ 164,560.001 (4, Accrual = $ - FY 16/17 Write off PGA ($247.77) & WNA ($1.21) $ 248.98 1 Fuel $ 15,000.00 1 Donations to events $ 43,869.39 1 _ LP Yard V porization/loss due to malfunctionin meter $ 149.07 1 (4) Adjustment from FYE transfer of ECA in PGA CD Annual ECA Shortfall LP PGA Event fuel cost $ - 1 LP Proportion = 1.5% x Total ECA Transfer = $ 28,496.42 Suburban Software Systems $ 5,785.00 1 Depreciation of LP tanks $ 34,414.23 1 Suburban Software Systems license $ - 1 Contribution to garage LP trk up grade $ - 1 Additional Dividend $ - 2 LP Holding Tank Restoration $ - Pro ected FYE Remaining CLEARWATER GAS SYSTEM TE ADJUSTMENT CLAUSE COLLECTIONS FOR FY 2017/2018 Attachment #1 Page 2of4 $ 264,026.67 $ 325,000.00 $ 60,973.33 ECA ECA-� ENERGY CONSERVATION ADJUSTMENT Monthl Cumulative NG/Therm Interest Total ECA Total ECA Overa. e YTD Overa, e Bud, et Cost Center B II = • S • "r . =' (Shona s e LP/Gal. Notes/Exce tional Items NGV S - ti • E • _ Month Expenses • - $ 2,762,513.49 0.20/0.20 Prior Year Promo$167,631,Adv$929,Employ Costs$62,170 $ 13,812.57 $ 47,380.47 1 $ 1,615,756.75 $ 207,231.19 $ 1,408,525.56 $ (4,171,039.05 $ 4,109,579.66) 0.20/0.20 Oct -17 $ 1,554,563.71 103,833.92 Promo$20,158,Adv $720, Employ Costs$82,956 $ 20,855.20 $ 56,123.45 180,812.57 242,271.95 $ 61,459.38 19,995.20 $ 4,089,584.46 0.20/0.20 Nov -17 $ $ 20,547.90 $ 55,000.00 275,547.90 295,543.10 $ Dec -17 $ 200,000.00 $ 20,447,92 $ 55,000.00 275,447.92 426,240.96 $ 150,793.04 $ (3,938,791.43) 3,802,875.27 ;,,.02510:25 0.25/0.25 Jan -18 $ 200,000.00 $ 19,693.96 $ 55,000.00 274,693.96 410,610.12 $ 135,916.16 $ 3,684,164.81 0.25/0.25 Feb -18 $ 200,000.00 $ 19,014.38 $ 55,000.00 274,014.38 392,724.83 $ 118,710.46 $ $ 3,604,088.20) 0.25/0.25 Mar -18 $ 200,000.00 $ 18,420.82 $ 55,000.00 2 273,420.82 353,497.44 $ 80,076.61 3,548,259.83 0.25/0.25 Apr -18 $ 200,000.00 $ 18,020.44 $ 55,000.00 3 273,020.44 328,848.81 $ 55,828.37 $ 3,513,193.84 0.25/0.25 Ma -18 $ 200,000.00 $ 17,741.30 $ 55,000.00 272,741.30 307,807.29 $ 35,065.99 $ 3,506,508.85) 0.25/0.25 Jun -18 $ 200,000.00 $ 17,565.97 $ 55,000.00 4 272,565.97 279,250.95 $ 6,684.98 $ 0.25/0.25 Jul -18 $ 200,000.00 200,000.00 $ 17,532.54 $ 55,000.00 272,532.54 277,747.99 $ 5,215.44 $ (3,501,293.41) $ 3,496,051.89) 0.25/0.25 Au. -18 $ 200,000.00 $ 17,506.47 $ 55,000.00 272,506.47 277,747.99 $ 5,241.52 $ Se. -18 $ $ - $ 200,000.00 5-8 200,000.00 1,899,761.30 $ 2,099,761.30 1,366,222.90 (1,396,290.59) P13 $ 221,159.46 $ 453,503.92 $ 4,333,061.01 $ 5,699,283.91 $ Total YTD $ 3,658,397.63 for to ECA Annual Shortfall 1) Incl. Annual Admin Char.e of $47,520 + UCS ch of $70,460 8 = Transfer of ECA Collected in PGA u to the ECA Collected = ear u• $ 1,899,761,30 $203,120 + FY 16/17 Write off of $2,733.02 = $ 323,833.02 Note: Maximum amount which can be transferred + Dividend SNEP Transfer = I $ 1,000,000.00 (1) = $ - - -_ (2) Additional Dividend Sponsorship = $ 40,000 00 13) Fireworks $ (4) Morningside Gas A/C Differential Cost = (5) NGV O&M $?+PGA Recv non -CGS $? = $ 200,000.00 (6) OPEB Adjustment = _ I $ _ (7) ECA Accrual FY17 loss Installation WOs = $ = $ 253,503.92 (8 on Net ECA CCE = $ 2,294,564.61 Net NGV CCE ADJUSTMENT RIA REGULATORY IMPOSITION EIA (ORA _ YTD Overa e NG/Therm_ Re ulato Interest Total RIA Total RIA Overa, a s Shorta e LP/Gal. Bud ' et Environmental Expenses Notes/Exce • tional Items Ex • = nses Expense Ex • enses Billed Shorta e s $ 221,536.67 Month $ $ 139,455.54 0.09/0.09 Prior Year 172,197.65 3,292.01 $ - 1 $ 175,489.66 93,408.53 $ 82,081.13 $ 245,580.53 0.09/0.09 Oct -17 $ 916.67 • 1,963.28 $ - 2,879.95 109,004.94 $ 106,124.99 33,093.51 $ 278,674.04 y 0.09/0.09 Nov -17 $ 10,000.00 90,000.00 $ - 100,000.00 133,093.51 $ $ 332,235.15 0.09/0.09 Dec -17 $ 90,000.00 $ - 100,000.00 153,561.11 $ 53,561.11 Jan -18 $ 10,000.00 _ 90,000.00 $ - 100,000.00 147,929.81 $ 47,929.81 $ 380,164.97 421,651.28 0.09/0.09 0.09/0.09 Feb -18 $ 10,000.00 $ 10,000.00 90,000.00 $ - 100,000.00 141,486.31 $ 41,486.31 $ 27,353.92 $ $ 449,005.20 0.09/0.09 Mar -18 10,000.00 90,000.00 $ - 2 100,000.00 127,353.92 $ 467,479.00 0.09/0.09 Apr -18 $ 90,000.00 $ - 100,000.00 118,473.80 $ 18,473.80 478,372.22 0.09/0.09 Ma -18 $ 10,000.00 10,000.00 90,000.00 $ - 100,000.00 110,893.21 $ 10,893.21 $ 478,977.48 0.09/0.09 Jun -18 $ 90,000.00 $ - 100,000.00 100,605.27 $ 605.27 $ 479,041.28 0.09/0.09 -18 $ 10,000.00 90,000.00 $ - 100,000.00 100,063.80 $ 63.80 $ _Jul Aug -18 $ 10,000.00 100,000.00 100,063.80 $ 63.80 $ 479,105.08 0.09/0.09 90,000.00 $ $ 479,105.08 Sep -18 $ 10,000.00 4,5 $ P13 $ - $ 1,178,369.61 1,435,938.02 $ 257,568.41 Total YTD $ 273,114.32 $ 905,255.29 Includes annual chars for Admin Cha • e $13,170+ 1) FY 16/17 Write off of $1,630.98 + Dividend $156,480 = $ 171,280.98 5 AccrualNet Additional Dividend $ _ EIA = $ 101,833.34 905,255.29 (2) from Added Dividend $ Net ORA = $ e Credit from Council allocation $ 4 CIP closed to O•eratin• CLEARWATER GAS SYSTEM SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTIONS FOR FY 2017/2018 Attachment #1 Page 3 of 4 USAGE AND INFLATION ADJUSTMENT (UTAI Commercial Monthly Cumulative YTD Overage (Shortage) $ (400,066.48) UTA NG/Therm_ _ LP/Gal Budget Interest Overage Month LP Gallons Expense Rate/Gallon NG Therms Rate/Therm (Shortage) Beg. Bal. $ - Oct -17 6,455.1 $ 2,000.33 0.05 785,608.8 0.05 $ 37,460.60 $ (362,605.88) $ (317,684.18) $ (268,912.60) 0.05/0.05 0.05/0.05 0.05/0.05 Nov -17 6,489.4 $ 1,813.03 0.05 929,051.1 0.05 $ 44,921.70 Dec -17 7,200.0 $ 1,588.42 0.05 1,000,000.0 0.05 $ 48,771.58 Jan -18 7,200.0 $ 1,344.56 0.03 1 1,100,000.0 0.03 $ 31,871.44 $ (237,041.171` $ (205,010.37) 0.03/0.03 0.03/0.03 Feb -18 7,200.0 $ 1,185.21 0.03 1,100,000.0 0.03 $ 32,030.79 Mar -18 8,000.0 $ 1,025.05 0.03 1,000,000.0 0.03 $ 29,214.95 $ (175,795.42) $ (146,416.40) 0.03/0.03 _ 0.03/0.03 Apr -18 8,600.0 $ 878.98 0.03 1,000,000.0 0.03 $ 29,379.02 May -18 7,200.0 $ 732.08 0.03 950,000.0 0.03 $ 27,983.92 $ (118,432.48) 0.03/0.03 Jun -18 7,200.0 $ 592.16 0.03 900,000.0 0.03 $ 26,623.84 $ (91,808.64) $ (65,801.69) $ (42,664.70) $ (18,662.02) $ (18,662.021 0.03/0.03 0.03/0.03 0.03/0.03 _ _ 0.03/0.03 Jul -18 7,200.0 $ 459.04 0.03 875,000.0 0.03 $ 26,006.96 Aug -18 7,200.0 $ 329.01 0.03 775,000.0 0.03 $ 23,136.99 Sep -18 7,200.0 $ 213.32 0.03 800,000.0 0.03 $ 24,002.68 Per 13 $ - Total YTD 87,144.5 12,161.20 11,214,659.9 $ 381,404.46 (1) Recomputed UTA in December for January application. Decreased by 2 cents to 3 cents to recover $419,582.35 shortfall from FY 16/17 less overcollections _ in FY 16/17 of ($155,958.31) thru December = $263,624.04 net. (2) Accrual = $. - USAGE AND INFLATION ADJUSTMENT (UTAI__ Residential Monthly Cumulative YTD Overage (Shortage) $ (154,894.60) $ (146,692.79) $ (j39,112.93) $ (128,558.50) $ (107,701.29) UTA NG/Therm LP/Gal 0.03/0.03 0.03/0.03 0.03/0.03 - 0.05/0.05 Budget Interest Overage Month LP Gallons Expense Rate/Gallon NG Therms Rate/Therm (Shortage) Beg. Bal._ Oct -17 21,716.4 $ 774.47 0.03 225,191.5 0.03 $ 8,201.81 Nov -17 18,450.5 $ 733.46 0.03 258,102.6 0.03 $ 7,579.86 Dec -17 25,000.0 $ 695.56 0.03 350,000.0 0.03 $ 10,554.44 Jan -18 30,000.0 $ 642.79 0.05 1 400,000.0 0.05 $ 20,857.21 Feb -18 30,000.0 $ 538.51 0.05 375,000.0 0.05 $ 19,711.49 $ (87,989.79) $ X9,429.74) $ (52,426.89) $ (38,139.03) $ (25,079.72) $ (12,955.12) $ (1,769.90) $ 9,471.25 0.05/0.05 _ 0.05/0.05 _ 0.05/0.05_ 0.05/0.05 0.05/0.05 - 0.05/0.05 _ 0.05/0.05 0.05/0.05 Mar -18 30,000.0 $ 439.95 0.05 350,000.0 0.05 $ 18,560.05 Apr -18 22,000.0 $ 347.15 0.05 325,000.0 0.05 $ 17,002.85 May -18 16,000.0 $ 262.13 0.05 275,000.0 0.05 $ 14,287.87 Jun -18 15,000.0 $ 190.70 0.05 250,000.0 0.05 $ 13,059.30 Jul -18 20,000.0 $ 125.40 0.05 225,000.0 0.05 $ 12,124.60 Aug -18 25,000.0 $ 64.78 0.05 200,000.0 0.05 $ 11,185.22 Sep -18 25,000.0 $ 8.85 0.05 200,000.0 0.05 $ 11,241.15 Per 13 $ - $ 9,471.25 Total YTD 278,166.9 4,823.75 3,433,294.1 $ 164,365.85 (1) Recomputed UTA in December for January application. Increased by 2 cents to 3 cents to recover $165,790.35 shortfall from FY 16/17 less overcollections in FY 16/17 of ($37,913.02) thru December = $127,877.33 net. ,, CLEARWATER GAS SYSTEM OF RATE ADJUSTMENT CLAUSE COLLECTIONS FOR FY 2017/2018 Attachment #1 Page 4 of 4 RECOVERY ADJUSTMENT CLAUSES (Both PGAs + ECA + RIA + UTAL_ Total Res! TOTAL OST Total All Expenses - Total Recovery Billed - Monthly Overage (Shortage) $ - Cumulative YTD Overage NG/Thm (Firm) Budget (Shortage) _$ (4,223,004.662 $ (9,618,199.92) LP/Gal Month __ 1.23/2.31 Prior Year _$ 7,117,448.32 $ 1,722,253.06 $ (5,395,195.26) 1.23/2.31 Oct -17 1,155,905.30 $ 1,992,335.06 $ 836,429.76 $ (8,781,770.16) 1.23/2.31 1.25/2,38 1.25/2.38 Nov -17 1,538,632.77 1,794,961.79 1,663,080.14 $ 2,441,247.69 $ 2,769,582.56 $ 2,666,207.65 $ 902,614.92 $ 974,620.77 $ 1,003,127.51 $ (7,879,155.25) $ (6,904,534.48 $ (5,901,406.97) Dec -17 Jan -18 1.25/2.38 Feb -18 Mar 1,575,832.86 $ 2,551,733.29 $ 975,900.43 $ (4,925,506.54 1.25/2.38 1.25/2.38 -18 1,453,749.66 $ 2,292,237.88 $ 838,488.22 $ (4,087,018.32) Apr -18 P 1,293,205.90 $ 2,129,420.25 $ 836,214.35 $ (3,250,803.97 $ (2,493,530.79 1.25/2.38 May -18 1,238,147.47 $ 1,995,420.65 $ 757,273.18 Jun -18 1,190,825.97 $ 1,815,525.62 $ 624,699.65 $ 1,868,831.14) 1.25/2.38 1.25/2.38 Jul -181,190,232.54 $ 1,802,329.78 $ 612,097.24 $ (1,256,733.90) 1.25/2.38 Aug -18 Sep 1,186,146.47 $ 1,803,251.39 $ 617,104.93 $ (639,628.97 $ (500,602.30 -181,760,734.63 13 13 $ 1,899,761.30 $ 139,026.67 Per Total YTD 24,158,903.83 27,881,306.18 $ 3,722,402.36 12/22/2017 Last Updated R E S E R V A T 0 N Oct -17 Nov -17 Dec -17 Jan -18 Feb -18 Mar -18 Apr -18 May -18 Jun -18 Jul -18 Aug -18 Sep -18 Tota C O Oct -17 M Nov -17 Dec -17 M Jan -18 O Feb -18 Mar -18 D Apr -18 May -18 Jun -18 • Jul -18 Aug -18 Sep -18 Tota CGS Natural Gas Summary Monthly Actual/Projections (FY18) Art'A-c t‘141 -1 - FTS -1 E141- Volume FTS -1 30.5918 Cost FTS -2 $0.6518 Volume Cost No -Notice 90.0478 Volume Cost FTS -2 (Usage) Rate Capacity Relinquishment Volume Rate Cost Reservation Adiustments TOTAL RESERVATION COST Total Rate 170,438 $ 94,047.69 41,788 $ 27,237.42 15.500 $ 740,90 COMMODITY COST (25,002) $ 0.2576 (96,410.85) 960.38 $ 115,645.54 90.5705 306,570 $ 169,165.33 53,430 $ 34,825.67 22,500 $ 1,075.50 $ 3,721.00 (112,897) $ 0.1486 $ (16,771.64) 9287.85 $ 188,682.81 90.6995 316,789 $ 174,804.17 55,211 $ 35,988.53 31,000 $ 1,481.80 2.64% (50,000) $ 0.1500 $ (7,500.00) 90.00 $ 204,772.50 90.5801 316,789 3 174,804.17 55,211 $ 35,986.53 46,500 $ 2,222.70 287,960 (50.000) $ 0.1500 $ (7,500.00) 90.00 $ 205,513.40 $0.5577 286.132 $ 157,887.64 49.888 $ 32,503.96 42,000 $ 2,007.80 $ 0.0093 (50,000) $ 0.1500 $ (7,500.00) 30.00 $ 184,899.20 80.5637 316,789 $ 174,804.17 55,211 $ 35,988.53 31,000 $ 1,481.80 0.0094 (50,000) $ 0.2000 $ (10,000.00) 90.00 $ 202,272.50 S0.5730 216,570 $ 119,503.33 53,430 $ 34,825.67 22,500 $ 1,075,50 • (40,000) $ 0.2000 $ (8,000.00) 50.00 $ 147,404.50 90.5838 144,212 $ 79.576.18 41,788 $ 27,237.42 12,400 $ 592.72 $ - (40,000) $ 0.2500 $ (10,000.00) 90.00 $ 97,408.32 50.8149 139,560 $ 77,009,21 40,440 $ 26,358.79 10,500 $ 501.90 $ 781,384,40 (25,000) $ 0.2500 $ (6,250.00) 90.00 $ 97,619.90 90.5898 144,212 $ 79,576.18 41,788 $ 27,237.42 10,850 $ 518.63 388.63 (25,000) $ 0.2500 $ (6,250.00) 90.00 $ 101,082.23 90.5882 144,212 $ 79,578.18 41,788 $ 27,237.42 10,850 $ 518.83 40,440 (25,000) $ 0.2500 $ (6,250.00) 90.00 $ 101,082.23 90.5882 139,560 $ 77,009.21 40,440 $ 26,358.79 10,500 $ 501.90 140,212 $ (25,000) $ 0.2500 $ (6,250.00) 90.00 $ 97,819.90 90.5898 2,641,833 $ 1,457,763,48 570,393 3 371,782.18 266 100 S 12,719,58 $ - (517 899) $ 647,484.70 140,212 $ (998,712.39) 9348.23 91,743,901.03 80,5891 90.5518 90.6518 90.0478 as of 12/21/2017 Volume FT8-1 (Usage) Rate Cost Volume FTS -2 (Usage) Rate Cost Gas Supply (FGU & Interconnects) Volume Rate Cost Fuel % FGU Management fee 50.066 No Notice Usage GT( Payment 90.020 T Cashout Prior Month Adjustment COMMODITY COST 142,384 8 0.0094 $ 1,341.64 41,788 $ 0.0093 $ 388.63 192,988 $ 3.3209 $ 640,887.20 2.64% $ 11,164.00 1 - $ 3,721.00 9 (18.08) $ 19,436.97 $ 676,920.36 148,170 8 0.0093 $ 1,377.97 53,430 $ 0.0093 $ 495.90 206,696 $ 3.1432 $ 649,694.70 2.64% $ 12,672.00 9 - $ 4,032.00 9 9,711.99 $ 669.00 $ 678,664.56 223,789 $ 0.0094 $ 2,108.69 55211 $ 0.0093 $ 513.48 287,960 $ 3.6721 $ 1.057.419.81 2.64% $ 18,135.00 $ - $ 5,580.00 $ • $ - $ 1,083,756.97 212.789 $ 0.0094 $ 2,005.04 55,211 $ 0.0093 $ 513.46 277,600 $ 3.6498 $ 1,013,174.50 2.64% $ 17,420.00 $ - $ 5,360.00 $ - $ • $ 1,038,473.01 207.132 S 0.0094 $ 1,951.74 49,868 $ 0.0093 3 483.77 265,600 $ 3.8399 $ 966,762.00 2.64% $ 16,705.00 $ • $ 5,140.00 $ - $ - $ 991,022.51 176,789 5 0.0094 $ 1,665.83 55,211 $ 0.0093 $ 513.46 239,601 $ 3.4797 $ 833,728.80 2.64% $ 15,080.00 $ - $ 4,640.00 $ - $ - $ 855,628.09 182.570 $ 0.0094 $ 1,531.85 53,430 $ 0.0093 $ 496,90 223,601 $ 3.4945 $ 781,384,40 2.64% $ 14,040,00 $ - $ 4,320.00 $ - $ - $ 801,753.15 160,212 $ 0.0094 9 1,509.63 41,788 5 0.0093 $ 388.63 208,601 $ 3.3523 5 699,283.10 3.50% $ 13,130,00 $ - $ 4,040.00 5 - $ - $ 718,351.36 142,560 $ 0.0094 $ 1,343.30 40,440 5 0.0093 $ 376.09 188,601 $ 3.3520 $ 632,191.20 3.50% $ 11,895.00 $ - $ 3.660.00 $ • $ - S 649,465.59 140,212 $ 0.0094 $ 1,321.17 41,788 3 0.0093 $ 388.63 187,601 $ 3.3597 $ 630,284.90 3.50% $ 11,830.00 $ - $ 3,640.00 $ - $ • $ 647,484.70 140,212 $ 0.0094 $ 1,321.17 41,788 $ 0.0093 $ 388.63 187,601 $ 3.3543 $ 629,262.80 3.50% $ 11,830.00 $ - $ 3,640.00 $ - $ - 3 646,442.60 141,560 $ 0.0094 $ 1,333.68 40,440 $ 0.0093 $ 376.09 187,601 $ 3,3486 $ 628,203.90 3.50% $ 11,830.00 $ - $ 3,640.00 $ - $ - $ 645,383.87 1,998,379 SISIONSSIFIVI $ 18,811.91 570,393 9 5,304.68 2,654,049 111.111111111111111 $ 9,182,257.31 9185,731.00 90.00 551,413.00 $9,693.91 $20,104.97 39,433,316.78 TOTAL COST Resery & Comm RATE $ 792,666.90 $ 4.11 $ 867,237.37 $ 4.20 $ 1,288,529.47 $ 4.47 $ 1,243,986.41 $ 4.48 $ 1,175,921.71 $ 4.43 $ 1,057,900.59 $ 4.42 3 949,157.85 $ 4.24 $ 815,757.68 $ 3.91 $ 747,085.49 $ 3.96 $ 748,548.93 $ 3.99 $ 747,524.83 $ 3,98 $ 743,003.77 $ 3.96 $ 11,177,217.81 $ 4.21 Total Projected DTH WACOG Total Reservation Total Commodity Cost Purchased 1st6 Months 5 1,101,685.95 $ 5,324,455.50 $ 6,426,141.45 1,470,444 94.370 2nd 6 Months $ 642,215.08 $ 4,108,861.27 $ 4.751,076.35 1,183,605 54.014 TOTAL $ 1,743,901.03 9 9,433,316,78 $ 11,177,217.81 2,654,049 54.211 Propane Weighted Average Cost of Gas (WACOG) A rrAGMOtt►. r 413 12/21/2017 FY 2017-18 Date Company Invoice Targa L&L Shipping Gallons Delivered Propane Rate Propane Cost Shipping Cost Total Cost FYTD Gallons Cost of Inventory Tank Inventory Tank Withdrawl WACOG y 09130117 10/01/17 '1. '. s ^.. $ 28,761.18 28,791 0,99896 $ 28,761.18 28,826 (35) 0.99775 10/05/17 .�" Targa 17101252 17.532 1.15833 $ 19,380.78 $ 927.04 $ 20,307.82 17,532.0 $ 49,069.00 46,358 1.05848 10/09/17 Targa 17102497 8,702 8.996 8,923 701 1.16051 $ 9,638.59 $ 460.14 $ 10,098.73 26,234.0 $ 59,167.73 55,060 1.07460 10/25/17 Tara Targa 17104279 1.18301 $ 10,166.65 S 475.69 $ 10,642.34 35,230.0 $ 69,810.07 64,056 1.08983 15127/17 17104539 1.20051 $ 10,240.31 $ 471.83 $ 10,712.14 44,153.0 $ 80,522.21 72,979 1.10336 10/31/17 MONTHLY INVENTORY ADJUSTMENT 1.55128 S 1,087.45 $ 1,087.45 44,854.0 $ 81,609.66 73,680 1_10762 1,10762 10/31/17 END OF MONTH 'wi V I .a, , „ °t �'..s''' '•�`. $ 48,530.50 43,815 28,865 11/06/17 Targa 17106252 xw} 9,067 1.19551 $ 10,360.23 $ 479.44 $ 10,839.67 52,882.0 $ 59,370.17 52,882 1.12269 11/08/17 Targa 17106840 8,954 1.19363 $ 10,214.28 $ 473.46 $ 10,687.74 61,836.0 $ 70,057.91 61,836 1.13296 11/20/17 Targa 17108863 8,945 1.24801 $ 10,690.45 $ 472.99 $ 11,163.44 70,781.0 $ 81,221.35 70,781 1.14750 11/21/17 Targa 17109352 t >�, -ice 9,135 866 q4rFP: '°'..,�+ 1.23801 $ 10,826.17 $ 483.03 $ 11,309.20 79,916.0 $ 92,530.55 79,916 1.15785 11/30/17 MONTHLY INVENTORY ADJUSTMENT ,�.�',. �`+s,� '. 3.88133 se 9.tt : $ 3,361 23 Sa�4� c� � ,{"3 ,. � "•_ $ 3 361.23 �g �. w � .. at 80,782.0 T sap=r. ' $ 95,891.78 $ 59,942.16 80,782 50,497 30,285 1.18704 1.18704 11/30/17 END OF MONTH��' 12/07117 Targa 171/2413 . 18,201 1.24605 $ 21,712.89 S 966.40 $ 22,679.29 68,698.0 $ 82,621.45 68,698 1.20268 FYTD Totals 81 120 1.22192 94 879 $ 4 243.62 $ 99122.31 Projections Delivered Delivered Delivered Cost Month CGS Cost Gallons Cost of Inventory Nov -17 Dec -17 $ Jan -18 $ Feb -18 $ Mar -18 $ Apr -18 $ May -18 $ Jun -18 $ Jul -18 $ Aug -18 $ Sep -18 $ 1.25 1.20 1.10 1.10 1.10 0.90 0.90 0.90 0.90 0.90 36,000 45,000 45,000 36,000 36,000 27,000 27,000 18,000 18,000 27,000 $ 45,000.00 $ 54,000.00 $ 49,500.00 $ 39,600.00 $ 39,600.00 $ 24,300.00 $ 24,300.00 $ 16,200.00 $ 16,200.00 $ 24,300.00 Total EOM Tank EOM Tank Projected Gallons Gallons Cost WACOG $ 104,942.00 $ 115,265.20 $ 110,450.05 $ 98,003.89 $ 96,814.73 $ 80,820.50 $ 76,962.59 $ 66,348.78 $ 65,113.30 $ 72,302.49 86,497 95,497 95,497 86,497 86,497 77,497 77,497 68,497 68,497 77,497 50,497 50,497 50,497 50,497 50,497 50,497 50,497 50,497 50,497 50,497 50,497 $ 59,942.00 $ 61,265.20 $ 60,950.05 $ 58,403.89 $ 57,214.73 $ 56,520.50 $ 52,662.59 $ 50,148.78 $ 48,913.30 $ 48,002.49 $ 47,112.26 1.19 1.21 1.21 1.16 1.13 1.12 1.04 0.99 0.97 0.95 0.93 cSW:12/22/2017 ATTACHMENT #4 CALCULATION OF USAGE & INFLATION ADJUSTMENT (UTA) FOR FY 2016/2017 Collected in FY 2017/2018 for Billings Beginning January 1.2018 Usage Adjustment Calculations: 1. Residential Single -Family Natural Gas Use/Customer: Average Number of Total FY 16/17 Therms Used FY 16/17 Customers Therm Usage Per Customer 18,289 3,361,242 183.8 Threshhold for application of UTA per Rate Ordinance = Less Than 197 Therefore, Residential Single Family Usage Adjustment = 7.19% Applicable FY 16/17 Total Residential Non -Fuel Energy Revenues = $ 1,759,330.63 Added FY 17/18 UAI Residential Revenues from Usage Shortfall = $ 126,505.14 2. Commercial (Non -Interruptible) Natural Gas Use/Customer: Average Number of Total FY 15/16 Therms Used FY 16/17 Customers Therm Usage Per Customer 2,354 13,862,724 5,889.0 Threshhold for application of UTA per Rate Ordinance = Less Than 6,203 Therefore, Commercial Single Family Usage Adjustment = 5.33% Applicable FY 16/17 Total Commercial (Non -Inter.) Non -Fuel Revs = $ 5,546,508.11 Added FY 17/18 UAI Commercial Revenues from Usage Shortfall = $ 295,730.83 Inflation Adjustment Cakulations: Actual U. S. Dept. of Labor CPI -U for September 2016 = 241.428 Actual U. S. Dept. of Labor CPI -U for September 2017 = 246.819 CPI -U Inflation Increase Applicable to FY 16/17 Revenues = 2.233% Authorized UTA Recovery for FY 2017/2018: 1. Residential Single -Family Recovery for FY 2017/2018 Usage Portion = Inflation Portion = Subtotal = Less Proj. Over Rec. thru December 2017 = $ 126,505.14 $ 39,285.22 $ 165,790.35 $ (37,913.02) Total = I $ 127,877.33 Projected Therms & Gallons to Recover on for FY 17/18 = 2,813,000 Projected Residential UTA Recovery Required = $ 0.045 Recommend Round to = $ 0.05 2. Commercial (Non -Interruptible) Recovery for FY 2017/2018 Usage Portion = Inflation Portion = Subtotal = Less Proj. Over Rec. thru December 2017 = $ 295,730.83 $ 123,851.52 $ 419,582.35 $ (155,958.31) Total = I $ 263,624.04 Projected Therms & Gallons to Recover on for Remainder of FY 17/18 = 8,567,000 Projected Commercial UTA Recovery Required = 0.031 Recommend Round to = $ 0.03 CSW:12/22/2017 CLEARWATER GAS SYSTEM NATURAL GAS RATE BILLING FACTORS FOR JANUARY 1, 2018 - SEPTEMBER 30, 2018 BASED ON APPROVED GAS ADJUSTMENT FACTORS Attachment #5 Interr. Contract Firm Natural Gas Rate Schedules NG Rate NARgst RS SMF MMF LMF SGS MGS LGS RAC GAC AC SL SL Relight (N n NGV NSS IS CNS esl) (No 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 & 0,p000 NA or Other Rate Determinant 3 Units) Units) Units) Units) 17,999 99,999 & up 3 Units) 149 tons) tons & +) 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) ($t 0 if .00($40.00) 0enotf ($70.00) ($30.00) ($30.00) (By Contract) ($75.00) $400.00 (By Contract) if 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.25 0.25 0.25 0.25 0.25 0.25 0.25 NA NA NA NA NA NA NA NA NA Regulatory Imposition Adj. (RIA) 0.09 0.09 0.09 0.09 0.09 0.09 0.09 NA NA NA NA NA NA NA NA NA Usage & Inflation Adj. (UTA) 0.05 0.05 0.05 0.05 0.03 0.03 0.03 NA NA NA NA NA NA NA Ng NA Total Non -Fuel Energy Charge $0.83 $0.83 $0.83 $0.83 $0.79 $0.75 $0.71 $0.20 $0.15 $0.10 $0.20 $0.35 By Contract $0.42 $0.24 By Contract Purchased Gas Adjustment (PGA) 0.86 0.86 0.86 0.86 0.86 U.Q 0.86 0.86 0.86 0.86 0.86 0.86 0.76 0.86 Q.Z 0.76 0 76 Total Energy Charge/Therm 1.69 1.69 1.69 1.69 1.65 1.61 1.57 1.06 1.01 0.96 1.06 1.21 + N 0.7 -Fuel 76 1.28 1.00 + Non .76l Minimum Monthly Bill $12.00 325.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) (340.00) ($70.00) (3160.00) (340.00) ($70.00) ($160.00) ge + @ prem se) c p emise i i p0.00) rem se +70.00) $FAC) +$FAC) (By Contract) FAC ct) +$) 3400.00 FAC + Non -Fuel Therm Non -Fuel Therm Rate for Contract Rate for Contract # of Therms # of Therms Compares to LP/Gallon Rate of $ 1.55 $ 1.55 $ 1.55 $ 1.55 $ 1.51 $ 1.47 $ 1.44 $ 0.97 $ 0.92 $ 0.88 $ 0.97 $ 1.11 $ 0.70 $ 1.17 $ 0.92 with 6.0% Franchise $ 1.64 $ 1.64 $ 1.64 $ 1.64 $ 1.60 $ 1.56 $ 1.52 $ 1.03 $ 0.98 3 0.93 $ 1.03 $ 1.17 $ 0.74 $ 1.24 $ 0.97 Change from 9/2014 Therm Rate $ (0.06) $ (0.06) $ (0.06) $ (0.06) $ (0.06) $ (0.04) $ (0.02) $ (0.08) $ (0.08) $ (0.08) $ (0.08) $ (0.08) $ (0.09) $ (0.12) $ (0.13) $ (0.09) % Change from 9/2014 Therm Rate -2.7% -2.7% -2.7% -2.7% -2.8% -1.9% -1.0% -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 30.069 $0.055 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 BTU FACTOR = THERMS/100 CUBIC FEET ICCF) 10/2017 11/2017 12/2017 01/2018 02/2018 03/2018 04/2018 05/2018 06/2018 07/2018 08/2018 09/2018 Firm Service Rates 1.043 1.046 1.044 1.043 Interruptible Service Rates 1.022 1.025 1.024 1.022 FY 17/18 Avg. 1.044 1.023 $0.069 $0.691 CSW:12/22/2017 BTU Factor: 2.714 Gallons/100 cubic feet (CCF) BTU Factor: 2.483 Therms/100 cubic feet (CCF) Therm Factor: 0.915 Therms/Gallon Applicable Annual Gallon Range or Other Rate Determinant Monthly Customer Charge Non -Fuel Energy Charges/Gallon: Non -Fuel Energy Charge (NFE)/Gallor Energy Conservation Adj. (ECA)/Gallor Regulatory Imposition Adj.(RIA)/Gallon Usage & Inflation Adj. (UTA)/Gallon Total Non -Fuel Charges (NF)/Gal. Purchased Gas Adjustment(PGA)/Gal. Total Energy Charges/Gallon Minimum Monthly Bill Utility Tax Note: Fuel Rate per Gallon 10/01/1973 Non -Utility Taxable Fuel/Gallon Change from 9/2014 Gallon Rate Change from 9/2014 Gallon Rate RESIDENTIAL MULTI -FAMILY MRLP MMLP NA NA (1 - 3 Units) (4 + Units) $12.00 $25.00 $1.90 0.25 0.09 0.05 $2.29 1.99 $4.28 $12.00 0.161 $1.829 $0.11 2.7% $1.90 0.25 0.09 0.05 $2.29 1.99 $4.28 $25.00 0.161 $1.829 $0.11 2.6% CLEARWATER GAS SYSTEM METERED PROPANE (LP) RATE BILLING FACTORS FOR JANUARY 1, 2018 • SEPTEMBER 30, 2018 BASED ON APPROVED GAS ADJUSTMENT FACTORS LOOP RESL. LRLP NA $12.00 For Each Meter $0.90 0.25 0.09 0.05 $1.29 1,22 $3.28 $12.00 0.161 $1.829 $0.11 3.5% SMALL COML. LARGE COML. MGLP MLLP 0 - 2,500 $25.00 $0.30 0.25 0.09 0.03 $0.67 1 99 $2.66 $25.00 0.161 $1.829 $0.11 4.3% >2,501 $40.00 $0.25 0.25 0.09 0.03 $0.62 1.99 $2.61 $40.00 0.161 $1.829 $0.11 4.4% VEHICLE LPV (Non -Rest. Only) NA $40.00 Set By Contract NA NA NA Set By Contract Set By Contract Contract NFE + Contract PGA Customer Charge Any Applicable Customer Charge + Any Applicable Facility Charges 0.161 Contract PGA - 0.161 NA NA Attachment #6 Page 1 of 2 STANDBY/GENERATOR CONTRACT MTRD LPSM CLP (Non -Rest. Only) NA NA (Closed for New Resl. Applications) $50.00 Set By Contract $1.00 NA NA NA $1.00 1.99 $2.99 $50.00 0.161 $1.829 $0.05 1.7% Set By Contract NA NA NA Set By Contract 1.69 Contract NFE + $1.690 Customer Charge + Non -Fuel Energy Chg. for the Contracted # of Gallons/Mo. 0.161 Contract PGA - 0.161 NA NA CSW:12/22/2017 BTU Factor: BTU Factor: Therm Factor: 2.714 Gallons/100 cubic feet (CCF) CLEARWATER GAS SYSTEM 2.463 Therms/10Ocubic feet (CCF) BULK PROPANE (LP) RATE BILLING FACTORS 0.915 Therms/Gallon FOR JANUARY 1, 2018 - SEPTEMBER 30, 2018 BASED ON APPROVED GAS ADJUSTMENT FACTORS STANDARD RESIDENTIAL BULK LP SERVICE (Rate Class is Based on Annual LP Gallon Usage Level) BRLPO BRLP1 BRLP2 BRLP3 BRLP4 Applicable Annual Gallon Range 0 (No Fills in Yr.) 0.1 - 60 60.1 - 120 120.1 - 300 or Other Rate Determinant 1-3 UNITS 1-3 UNITS 1-3 UNITS 1-3 UNITS Annual Customer Charge $ 350.00 $ 225.00 $ 180.00 $ 90.00 $ RESIDENTIAL "WILL CALL" (Based on Annual Usage Level) WRLPO WRLP1 WRLP2 WRLP3 WRLP4 > 300 0 (No Fills in Yr.) 0.1 - 60 60.1 - 120 120.1 - 300 > 300 1-3 UNITS 1-3 UNITS 1-3 UNITS 1-3 UNITS 1-3 UNITS 1-3 UNITS 75.00 $ 350.00 $ 210.00 $ 150.00 $ 75,00 $ 60.00 Non -Fuel Charoes (NFI/Gallon: Non -Fuel Energy Charge (NFE)/Gal. $ 1.80 $ 1.80 $ 1.60 $ 1.00 $ 0.90 $ 1.80 $ 1.80 $ 1.60 $ 0.90 $ 0.80 Energy Conservation Adj. (ECA)/Gal $ 0.25 $ 0.25 $ 0.25 0.25 0.25 0.25 0.25 0.25 0.25 0.25 Regulatory Imposition Adj. (RIA)/Gal $ 0.09 $ 0.09 $ 0.09 0.09 0.09 0.09 0.09 0.09 0.09 0.09 Usage & Inflation Adj. (UTA)/Gallon 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 Total Non -Fuel Charges (NF)IGaI. $ 2.19 $ 2.19 $ 1.99 $ 1.39 $ 1,29 $ 2.19 $ 2.19 $ 1.99 $ 1.29 $ 1.19 Purchased Gas Adj. (PGA)/Gallon $ 1.99 5 1.99 $ 1.99 $ 1.99 $ 1.99 $ 1.99 $ 1.99 $ 1.99 $ 1.99 $ 1.99 Total Energy Charges/Gallon $ 4.18 $ 4.18 $ 3.98 $ 3.38 $ 3.28 $ 4.18 $ 4.18 $ 3.98 $ 3.28 $ 3.18 Note: No Monthly Minimum Bill Utility Tax Note. Fuel Rate per Gallon 10/01/1973 $ Non -Utility Taxable FueVGallon $ COMMERCIAL BULK LP SERVICC (Based on Annual Usage Level) BCLP1 f3CLP2 0 - 2,500 > 2,500 Customers in this Customers in this Range of Usage Range of Usage $ 90.00 $ 90.00 BULK STANDBY/ GENERATOR LPSB (Closed for New Residental Applications) $ 420.00 0.25 $ 0.20 $ 1.00 0.25 0.25 NA 0.09 0.09 NA 0.03 0.03 NA $ 0.62 $ 0.57 $ 1.00 1.99 $ 1.99 $ 1.99 2.61 $ 2.56 $ 2.99 0.161 $ 0.161 $ 0.161 $ 0.161 $ 0.161 $ 0.161 $ 0.161 $ 0.161 $ 0.161 $ 0.161 $ 0.161 $ 0.161 $ 1.829 $ 1.829 $ 1.829 $ 1.829 $ 1.829 $ 1.829 $ 1.829 $ 1.829 $ 1.829 $ 1.829 $ 1.829 $ 1.829 $ Attachment #6 Page 2 of 2 CONTRACT BULK LP SERVICE CLP Any Contract Customers Who Requests Bulk Del, Set by contract Set By Contract NA NA Set By Contract Cotract NFE 1.690 0.161 $ 0.161 1.829 Contract PGA - 0.161 Change from 9/2014 Gallon Rate $ 0.110 $ 0.110 $ 0.110 $ 0.11 $ 0.11 $ 0.31 $ 0.31 $ 0.11 $ 0,11 $ 0.01 $ 0.11 $ 0.11 $ 0.05 NA % Change from 9/2014 Gallon Rate 2.7% 2.7% 2.8% 3.4% 3.5% 8.0% 8.0% 2.8% 3.5% 0.3% 4.4% 4.5% 1.7% NA CSW:12nsno47 j 1 Attachment #7 j; Page 1 of 3 Residential Rate History By Components Clearwater Gas System Tota Rate Adiustments/Therm Contract LP Month NG/therm LP/, alion * ECA RIA# WNAIUTA-Rest# UTA-ComI# PGA PGA PGA/, anon Oct-16 $ 1.48 $ 3.09 $ 0.15 $ 0.09 $ 0.01 $ 0.01 $ 0.79 $ 0.70 $ 1.84 Nov-16 $ 1.48 $ 3.09 $ 0.15 $ 0.09 $ 0.01 $ 0.01 $ 0.79 $ 0.70 $ 1.84 Dec-16 $ 1.48 $ 3.09 $ 0.15 $ 0.09 $ 0.01 $ 0.01 $ 0.79 $ 0.70 $ 1.84 Jan-17 $ 1.47 $ 2.96 $ 0.15 $ 0.09 $ 0.03 $ 0.04 $ 0.76 $ 0.67 $ 1.69 Feb-17 $ 1.47 $ 2.96 $ 0.15 $ 0.09 $ 0.03 $ 0.04 $ 0.76 $ 0.67 $ 1.69 Mar-17 $ 1.47 $ 2.96 $ 0.15 $ 0.09 $ 0.03 $ 0.04 $ 0.76 $ 0.67 $ 1.69 Apr-17 $ 1.53 $ 2.79 $ 0.18 $ 0.09 $ 0.03 $ 0.05 $ 0.79 $ 0.70 $ 1.49 May-17 $ 1.53 $ 2.79 $ 0.18 $ 0.09 $ 0.03 $ 0.05 $ 0.79 $ 0.70 $ 1.49 Jun-17 $ 1.70 $ 2.71 $ 0.20 $ 0.14 $ 0.03 $ 0.05 $ 0.89 $ 0.80 $ 1.34 Jul-17 $ 1.70 $ 2.71 $ 0.20 $ 0.14 $ 0.03 $ 0.05 $ 0.89 $ 0.80 $ 1.34 Aug-17 $ 1.70 $ 2.71 $ 0.20 $ 0.14 $ 0.03 $ 0.05 $ 0.89 $ 0.80 $ 1.34 Sep-17 $ 1.70 $ 2.71 $ 0.20 $ 0.14 $ 0.03 $ 0.05 $ 0.89 $ 0.80 $ 1.34 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 1 $ 0.010 $ 0.010 $ 0.729 $ 0.639 $ 1.486 Oct-17 $ 1.67 $ 3.31 $ 0.20 $ 0.09 $ 0.03 $ 0.05 $ 0.91 $ 0.81 $ 1.99 Nov-17 $ 1.67 $ 3.31 $ 0.20 $ 0.09 $ 0.03 $ 0.05 $ 0.91 $ 0.81 $ 1.99 Dec-17 $ 1.67 $ 3.31 $ 0.20 $ 0.09 $ 0.03 $ 0.05 $ 0.91 $ 0.81 $ 1.99 Jan-18 $ 1.69 $ 3.38 $ 0.25 $ 0.09 $ 0.05 $ 0.03 $ 0.86 $ 0.76 $ 1.99 Feb-18 Mar-18 Apr-18 May-18 Jun-18 Jul-18 Aug-18 Sep-18 FYTD 17/18 Avg. $ 1.675 $ 3.328 $ 0.213 $ 0.090' $ 0.035 $ 0.045 $ 0.898 $ 0.798 $ 1.990 2017 Avg. $ 1.607 $ 2.936 $ 0.184 $ 0.107 $ 0.030 $ 0.048 $ 0.846 $ 0.753 $ 1.615 Incr. Above $ 0.22 $ 0.42 $ 0.10 $ - $ 0.02 $ (0.01) $ 0.10 $ 0.09 $ 0.30 Last Year Same Month 15% 14% 67% 0% 67% -25% 13% 13% 18% Incr. Based $ 9.90 $ 20.66 on 45 Therms 15% 31% Equivalent Cents/KWH 5.8 12.6 for Gas vs. Duke Rate 13.1 13.1 Note: Duke Energy Florida's residential rate for usage >1,000 KWH in October 2017 is 13.085 cents/KWH. (Residential) Gas Cheaper by -56% -4% Notes: * Based on Bulk LP (BRLP3) which is applicable for customers using 120.1 - 300 gallons/year & equal to Residential LP Will Cali (BRWCLP). # New rates implemented 11/1/2014, with fol owing changes: T - 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. - BRLP3 LP Customer Charge unchanged © $90/year, and NFE rate unchanged © $1.00/gallon. UTA decreased by 9 cents/gallon to 0. - RIA & ECA unchanged initially.) 1 1 1 1 1 I CSW:9/26/201 7 Attachment #7 Page 2 of 3 Competitive History of NG vs. Electric Rates Month -Year NG Therm Cost September 2001 $ 1.34 September 2002 $ 1.36 September 2003 $ 1.56 September 2004 $ 1.69 September 2005 $ 1.97 September 2006 $ 1.89 September 2007 $ 1.86 September 2008 $ 2.12 September 2009 $ 1.39 September 2010 $ 1.39 September 2011 $ 1.42 September 2012 $ 1.48 September 2013 $ 1.67 September 2014 $ 1.75 September 2015 $ 1.57 September 2016 $ 1.38 September 2017 $ 1.70 $ Increase over Last 16 Years $ % Increase over Last 16 Years NG Equivalent KWH Cost $ 0.046 0.36 $ 26.9% Avg. Annual Inc. Over Last 16 Yrs. 1.7% 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 Progress Energy NG vs. KWH Cost Electric $ 0.084 -46% $ 0.074 -37% $ 0.084 -37% $ 0.089 -35% $ 0.097 -31% $ 0.119 -46% $ 0.120 -47% $ 0.120 -40% $ 0.132 -64% $ 0.136 -65% $ 0.129 -62% $ 0.132 -62% $ 0.123 -62% $ 0.123 -62% $ 0.123 -62% $ 0.123 -62% $ 0.130 -55% 0.01 $ 26.8% 1.7% 0.05 54.8% 3.4% CSW:11/28/2017 Attachment #7 Page 3 of 3 Annual Average CGS Residential Rates 1 Calender Year Fiscal Year Year NG/Therm LP/Gallon * Year NG/Therm LP/Gallon * 1995 NA NA FY 95/96 $ 0.880 $ 1.199 * 1996 $ 0.915 $ 1.239 * FY 96/97 $ 1.019 $ 1.370 * 1997 $ 1.049 $ 1.380 * FY 97/98 $ 1.054 $ 1.318 * 1998 $ 1.032 $ 1.288 * FY 98/99 $ 1.052 $ 1.269 * 1999 $ 1.073 $ 1.311 FY 99/00 $ 1.152 $ 1.504 2000 $ 1.222 $ 1.584 FY 00/01 $ 1.551 $ 1.649 2001 $ 1.549 $ 1.586 FY 01/02 $ 1.352 $ 1.488 2002 •$ 1.342 $ 1.553 FY 02/03 $ 1.477 $ 1.817 2003 $ 1.534 $ 1.864 FY 03/04 $ 1.603 $ 1.913 2004 $ 1.652 $ 1.968 FY 04/05 $ 1.803 1 $ 2.162 2005 $ 1.925 $ 2.278 FY 05/06 $ 2.080 $ 2.480 2006 $ 2.012 $ 2.501 FY 06/07 $ 1.918 $ 2.742 2007 $ 1.893 $ 2.869 FY 07/08 $ 1.932 $ 3.183 2008 $ 1.965 $ 3.186 FY 08/09 $ 1.610 $ 2.524 2009 $ 1.464 $ 2.418 FY 09/10 $ 1.437 $ 2.865 2010 $ 1.457 $ 2.946 FY 10/11 $ 1.475 $ 3.282 2011 $ 1.487 $ 3.438 FY 11/12 $ 1.506 $ 3.639 2012 $ 1.501 $ 3.548 'FY 12/13 $ 1.582 $ 3.257 2013 $ 1.629 $ 3.297 FY 13/14 $ 1.629 $ 3.297 2014 $ 1.717 $ 3.528 FY 14/15 $ 1.602 $ 3.133 2015 $ 1.576 $ 3.003 FY 15/16 $ 1.479 $ 2.718 2016 $ 1.452 $ 2.768 FY 16/17 $ 1.700 $ 2.710 2017 $ 1.607 $ 2.936 Average $ 1.502 $ 2.360 $ 1.495 $ 2.342 Notes: * Based on the Residential Metered Propane schedule which was closed for new customers effective March 8, 1999. For 1999 & FY 99/00 and beyond based on Bulk LP (BRLP3) which is applicable for customers using 120.1 - 300 gallons/year & is equal to Residential LP Will Call