Loading...
GAS ADJUSTMENTS EFFECTIVE OCTOBER 1, 2016TO: FROM: COPIES: CLEARWATER GAS SYSTEM Interoffice Correspondence Sheet William B. Home II, City Manager Chuck Warrington, Managing Director Rosemarie Call, City Clerk; CGS & UCS Management Teams; Janet Dorrough, Sr. Accountant/CGS; Laura Damico, Sr. Accountant/UCS; Lynne Priester, Cust. Serv. CoordJUCS; Lindsey Bessette, Systems AnalystIUCS SUBJECT: GAS ADJUSTMENTS EFFECTIVE OCTOBER 1, 2016 DATE: September 23, 2016 This is the time of year when we re -assess our gas adjustment clauses based on the market and our projections for the new fiscal year. Gas supply prices are anticipated to increase somewhat as winter approaches. Therefore, we are recommending an increase of 170 per therm in our Natural Gas Purchase Gas Adjustment (PGA) and an increase of 59¢ per gallon in our Propane (LP) PGA for October. We recommend that we continue our standard Contract LP PGA be set at 30¢ below our Standard LP PGA. We are recommending a 4¢ per therm or gallon decrease in our Energy Conservation Adjustment (ECA) and a 3¢ per therm or gallon decrease in our Regulatory Imposition Adjustment (RIA). We are recommending no change in our Usage & Inflation Adjustments (UTAs) for October. The net effect of these recommended changes for October is a 100 per therm ( +7.2 %) increase in our typical Residential Natural Gas customer's rate and a 52¢ per gallon increase ( +20.2 %) 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 October 1, 2016: 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 (IAA) - Residential - Commercial S0.79 per therm (up 170 per therm) S0.70 per therm (up 170 per therm) S1.84 per gallon (up 590 per gallon) S1.54 per gallon (up 590 per gallon) S0.15 per theiui or gallon (down 40) S0.09 per therm or gallon (down 30) _ S0.01 per thetm or gallon (no change) S0.01 per therm or gallon (no change) William B. Horne II, City Manager September 23, 2016 Page 2 Attachment #1 shows the status of our Adjustment Recovery Clause balances with actuals thru August. 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 PGAs for FY 16/17. Attachment #5 shows our projections for ECA and RIA for FY 16/17. Attachments #6 and #7 show the impact of these adjustment clause changes on our overall Natural and LP Gas rates, respectively. Attachment #8, Page #1 shows our monthly rate history over the past 2+ years, and Pages #2 and #3 of this show our 14 year relationship to electric prices and average residential rates, respectively. Please note that Page #2 of this analysis shows that, over the past 15 years, our residential natural gas rates have risen just 3.0% as compared to a 46.4% increase for the Duke Energy (formerly Progress Energy Florida/FPC) residential rates. That's an average annual increase of 0.2% /year for natural gas vs. 3.1% /year for electric - -- our natural gas rates increased only 6% of the electric growth rate -- - 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 7% lower than electric for our typical LP Residential rates. This is a very attractive competitive position vs. electric rates for our Natural Gas customers and these numbers are even lower if the customer uses a tankless gas water heater, which is what most of our customers are electing. We will continue to track these balances each month, make monthly projections of these factors based on market conditions, and let you know if any of these get significantly out of balance. Additionally, we lowered our standard posted price at our Natural Gas Vehicle (NGV) Fueling Station effective January 1, 2016, to $1.17 per gasoline gallon equivalent (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 new price is S0.99/gge, as these fleets pay no Federal taxes on fuel - -- an amazing price. This is as a result of the Congress passing the Tax Extender package, which re- enacted the 50¢ /gge Excise Tax Credit for NGV vehicle fuel. Bill, I would appreciate your approval of these revised adjustment rates so we can get this information to UCS in order to make the appropriate adjustments in the billing formulas in time for the October 1st billings. If you have any questions on this, please call me. CSW /cw Attachments Approved: William B. Horne II, City Manager U: \My Documents \MSOFFICE \WINWORD \GASRATES \Gas Adjustments for October 2016.docx CLEARWATER GAS SYSTEM SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTIONS FOR FY 2015/2016 Attachment #1' Page 1 of 4 NATURAL GAS PURCHASED GAS ADJUSTMENT (PGA -NG) 4 Budget Reservation Month Charges _ Prior Year` Oct 15 $ 4,258,968 39 - Nov 15 $ 143,902 27 Dec 15 _$ 164,606 17 Jan -16 $ 159,338.19 Feb 16 $ 168,766.72 Mar -16 $ 168,766.72 Apr -16 $ 132,578 64 May -16 $ 105,492.51 Jun -16 $ 98,556.12 Jul -16 $ 99,129 09 Aug -16 $ 101,241 72 Sep -16 $ 99,000.00? Per13 Monthly Cumulative NG PGA Commodity Interest Cost Center Total NG Fuel Total NG PGA Overage YTD Overage Rate /Therm Charges i Expense 1 Expenses Expenses Billed (Shortage) g) (Shortage) Firm /Contr' I_ $ (223,203.76) 1,394,849.81 $ 1,116.02 i $ 30,980.02 ' 1 : $ 5,685,914.24 $ 1,440,007.15 $ (4,245,907.09) $ (4,469,110.85) 0.88/0.79 624,216.04 ! $ 22,345.55 $ 829,288.28 1,533,448.77 $ 673,264.25 $ (4,052,601.12)t 0.88/0.79 $ 38,824.42 � 1,245,793.01 $ 416,504.73 $ (4,052,606.12 ' 636,906.60 $ 20,263.03 1 $ 38,408.72 $ 860,184.52 0.88/0.79 669,592.22 1 $ 16 896.71 $ 38,899.07 . ; $ 884,726.19 1,744,468.09 $ 859,741.90 $ (2,519,599.97); 0.88/0.79 775,681.55 $ 12 598.00 $ 42,584.88 ' i $ 999,631.15 1,864,187.13 $ 864,555.98 $ (1,655,043.99) 0.85/0.76 774,882.52 $ 8,275.22 - $ 39,544.88 ' $ 991,469.34 , 1,834,177.25 $ 842,707.91 $ (812,336.08)';, 0.85/0.76 569,208.09 $ 4,061.68 $ 37,108 83 $ 742,957.24 1,421,099.21 $ 678,141.97 $ (134,194.11) 0.70/0.61 597,395.55 7-$ 670.97 575,972.51 $ $ 28,071.64 ' ; $ 731,630.67 1,143,555.61 $ 411,924.94 $ 277,730.83 0.62/0.53 $ ±33,819.61 $ 0 $ 380,370.19 $ 658,101.02 0.62/0.53 t + 638,334.53 $ $ 35,746.58 773,210.20 1,043,144.93 I $ 269,934.73 $ 928,035.75 0.62/0.53 668,436.96 ' $ - ; $ 40,078.74 j $ 809,757.42 1,004,513.17 $ 194,755.75 $ 1,122,791.50 I 0.62/0.53 650,000.00 $ - $ 45,000.00 $ I, $ 1,203,945.34 4 -7 ; $ Total YFD $ 5,700,346.54 $ 8,575,476.38 $ 86,227.18 $ 1,653,012.73 $ (1) Includes Annual Admin Charge of $713,080 + CCS chg of $1,225,960 + Dividend $2,203,550 + FY 14/15 PGA write off of $11,582.91 + WNA $313.27 = $ 4,154,486.18: 4 (5) i Pension Adjustment = $ - (2) Additional Dividend based on FY 15/16 Net Income = $ - (6) Accrual = $ - (3) Bulk mailing & printing i $ - (7) Commodity adjustment from FYE transfer of ECA Collected in PGA @ Annual ECA Shortfall (4) OPEB liability & Period 13 Adjustment $ Average Annual Proportion = 98.5% x Total ECA Transfer = $ 1,203,945.34 Net RC = $ 1,545,860.36 ual PGA/Therm = 7 $0.692 ! Avg Fuel Only = l $0.362 ! Delta /Therm = $0.331 794,000.00 1,048,420.00 $ 254,420.00 $ 1,377,211.50 0.62/0.53 1,203,945.34 $ (1,203,945.34) $ 173,266.15 16,015,062.84 $ 16,411,532.75 $ 396,469.91 PROPANE (LP) GAS PURCHASED GAS ADJUSTMENT (PGA -LPZ f Monthly C ii uftTve " -LP PGA Budget Gallons Monthly Interest Commodity ■ - Total LP Fuel 1 Total LP PGA - Overage YTD Overage ) Therm /Gal. Month Sold WACOG Expense Charges Expenses Billed (Shortage) 4 (Shortage) Prior Oct-15 ar 38,021.1 $ 0.66815 4 $ - $ 25,403.80 1 t ( )� $ (145,620.30) 73,275.87)` $ 279,841.25 $ 60,945.08 i $ 218,896.17 r $ (122,572.31), 0 1.77/1.62 Dec 15 28,115.6 $ 0.65512 $ — 612.86 18,419.09 19,031.95 45,188.55 $ 34,058.93 ! $ (96,415.72), 1.77/1.62 1.77/1.62 Nov 15 25,166.3 $ 0.67183 $ 482.08 26,602.16 22,084.24 Jan -16 34,825 9 $ 0 62029 56,143.17 $ $ (62,356.78) 1.77/1.62 Feb 16 45,153.3 $ 0.62107 $ 311.78 28,043.36 28,355.14 I 68,759.92 ; $ 40,404.78 $ (21,952.01) 1.66/1.52 Mar-16 39,650.8 $ 0.64976 $ 109.76 25,763.50 25,873.26 60,037.54 $ 34,164.28 . $ 12,212.27 1.66/1.52 May 16 24,8669 $ 0.67868 $ - 16,876.67 16,876.671 30565.40 $ 22,145.28 ! $ 49,046.28 1.53/1.40 Apr-16 28,093.3 $ 0.65135 $ 18,298.57 Jul -16 25,19 4.0 $ 0.68009 $ 17,489.67 , $ 14,688.73 $ 49,046.28 1.37/1.25 17,189.61 31,150.32 $ 13,960.71 ' $ 63,006.98 A 1.37/1.25 15,451.17 28,260.66 $ 12,809.49 $ 75,816.48 1.37/1.25 Aug -16 25,499.5 $ 0.67830 $ - 17,296.31 ! 17,296.31 31,557.47 $ 14,261.16 $ 90,077.64 1.37/1.25 P13 , $ - 17,595.00 17,595.00 !r 31,556.25 1 $ 13,961.25 $ 104,038.89 1.37/1.25 4 $ 584,425.50 $ 526,291 77 ! $ (581833.73) Se 16 25,500.0 $ 0.69000 Total YTD 362,806.0 $ 0.65833 $ 2,244.59 '' $ 238,846.72 ' (58,133.73)i $ 15,142.14 Cost Center Expenses CCS Chg, Admin & Dividend : $ 182,710.004 1 , FY 14/15 Write off PGA & WNA $ 571.71 1 Fuel $ 15,000.00 1 ' ' Donations to events $ 10,495.17 1 I rt LP Yard Vaporization /loss due to malfunctioning meter $ 1,164.53 ' 1 (4) Adjustment from FYE transfer of ECA in PGA @Annual ECA Shortfall LP PGA Event fuel cost $ 4,296.81 1 LP Proportion = 1.5% x Total ECA Transfer = $ 18 334 19 $ 5,785.00 1 $ 34,414.231 ,. - — — $ - . 1 $ 1 $ - , Projected for FY Proj. Remaining $ 254,437.45 $ 325,000.00 $ 70,562.55 Suburban Software Systems Depreciation of LP tanks Suburban Software Systems license Contribution to garage LP trk up grade LP Holding Tank Restoration 1 CLEARWATER GAS SYSTEM SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTIONS FOR FY 2015/2016 Attachment #1 Page 2 of 4 ENERGY CONSERVATION ADJUSTMENT (ECA) Budget Cost Center Interest Total ECA Total ECA Month Expenses Notes /Exceptional Items Expense NGV Station Expenses Billed 'rior Year - $ Oct 15 $ 1,302,486.96 _ 'Promo$116,717,Adv$1,B07,Employ Costs$91,167.45 $ 2,969.17 $ 67,449.06 1 $ 1,372,905.19 $ 186,093.87 $ (1,186,811.32) $ Nov -15 $ 99,380.25 Promo$33,351,Adv $1,505, Employ Costs$64,524 $ 8,903.23$ 55,608.05 I 163,891.53 152,067.98 $ (11,823.55) $ Dec -15 $ 164,554.68 Promo$106,954,Adv $2,784, Employ Costs$54,817 I $ 8,962.34 $ 67,221.04 a 240,738.06 192,830.70 $ (47,907.36) $ Jan -16 $ 208,713.96 _ Promo$ 144, 310 ,Adv$3,025,IimployCosts$61,379 r$ 9,201.88 $ 57,196.21 ! ! 275,112.05 227,320.43 $ (47,791.62) $ Feb -16 $ 179,857.05 Promo$107,865,Adv $3,420, Employ Costs$68,572 $ 9,440.84 $ 35,613.47 224,911.36 231,563.08 $ 6,651.72 Mar -16 $ 157,046.00 Promo$80,895,Adv $7,333, Employ Costs$68,818 $ 9,407.58 $ 50,046.26 ! 216,499.84 219,243.47 $ 2,743.63 $ Apr -16 $ 129,241.92 Promo$61,256,Adv $1,160, Employ Costs$66,826 $ 9,393.86 $ 47,470.04 i 186,105.82 224,900.38 $ 38,794.56 $ May -16 $ 162,004.26 Promo$95,892,Adv $1,604, Employ Costs$64,508 ! $ 9,199.89 $ 48,947.78 I 220,151.93 224,594.04 $ 4,442.11 $ Jun -16 $ 551,372.03 Promo$68,651,Adv $4,874, Employ Costs$77,847 1 $ 9,177.68 $ 43,799.79 ; 2 I 604,349.50 206,497.82 $ (397,851.68) $ Jul -16 $ 968,943.56 I'romo$167,280,Adv $255, Employ Costs$89,888 $ 11,166.94 $ 52,640.66 12 &3 i 1,032,751.16 196,164.98 $ (836,586.18) $ Aug -16 S 159,271.94 Promo$96,624,Adv $1,517, Employ Costs$59,131 I $ 15,349.87 $ 48,247.76 1 — 222,869.57 184,316.22 $ (38,553.35) $ Sep -16 $ 150,000.00 $ 15,542.64 $ 60,000.00 225,542.64 198,966.10 $ (26,576.54) $ P13 $ - $ $ (300,000.00)! 4-8 (300 000 00), 922,279.54 $ 1,222,279.54 Month Cumulative ECA Overage YTD Overage (Shortage) (Shortage) (593,834.01); (1,780,645.33) (1,792,468.88) (1,840,376.24) (1,888,167.86) $ (1,881,516.14) (1,878,772.51) (1,839,977.95) (1,835,535.84) (2,233,387.52) , (3,069,973.70)i__ (3,108,527.05) (3,135,103.59)1 (1,912,824.05)' Fetal YTD $ 4,232,872.61 $ 118,715.92 $ 334,240.12 t ! $ 4,685,828.651 $ 3,366,838.61 $ (1,318,990.04) (1) Incl. Annual Admin Charge of $46,740 + CCS chg of $65,140 + Dividend $228,510 + FY 14/15 Write off of $2,405.51 = $ 342,795.51 (1) SNEP Transfer = _$ 750,000.00 (2) Additional SNEP Transfer ($400K in 1Q + $500Kin 3Q)= $ 900,000.00 (3) FY16 Toss on Installation Wos = $ 211,520.95 (4) Pension Adjustment NGV = $ - (5) NGV O &M $50,000 +PGA Recvy non -CGS $250,000 = ' $ (300,000.00) (6) OPEB Adjustment = $ - (7) ECA Accrual +$ 1- NG /Therm - LP /Gal. 0.16/0.16 0.16/0.16 0.16/0.16 0.16/0.16 0.14/0.14 0.14/0.14 0.16/0.16 0.19/0.19 0.19/0.19 0.19/0.19 0.19/0.19 0.19/0.19 (8) , = Transfer of ECA Collected in PGA up to the ECA Collected for year (up to ECA Annual Shortfall Note: Maximum amount which can be transferred = $ 1,222,279.54 REGULATORY IMPOSITION ADJUSTMENT (RIA) (EIA) Budget Environmental Month Expenses Notes /Exceptional items Prior Year Oct 15 $ Nov -15 Dec -15 Jan -16 Feb -16 Mar -16 Apr -16 May 16 Jun 16 Jul -16 Aug -16 Sep -16 P13 $ Total YTD $ 190, 920.14 723.33 723.33 723.33 423.33 1,023 33 723.33 723.33 723.33 723.33 723.33 10, 000.00 50,000.00 258,153.44 Net ECA CCE = $ 1,817,035.20 ' Net NGV CCE = + $ 634,240.12 (ORA) Regulatory Interest Expenses Expense (1) Includes annual charges for Admin Charge $12,170 + FY 14/15 Write off of $1,986.81 + Dividend $176,040 = (2) Additional Dividend (3) Credit from Council allocation from Added Dividend (4) CIP closed to Operating Total RIA Total RIA 1 Overage ,_ YTD Overage NG /Therm Expenses Billed (Shortage) (Shortage) LP /Gal. $ - $ (299,118.53) 38,007.93 $ 1,495.59 1,2 $ 230,423.66 116,313.07 $ (114,110.59) $ (413,229.12)'7 0.10/0.10 53,701.23 $ 2,066.15 ; 56,490.71 95,076.02 ', $ 38,585.31 $ (374,643.81) 0.10/0.10 122,262.34 $ 1,873.22 ! 124,858.89 120,061.30 $ (4,797.59) $ (379,441.40) 0.10/0.10 30,763.25 $ 1,897.21 33,383.791- 141,991.84 $ 108,608.05 $ (270,833.34) 0.10/0.10 138,190.79 $ 1,354.17 i I 139,968.29 165,301.33 ' $ 25,333.04 $ (245,500.30) 0.10/0.10 96,547.97 $ 1,227.50 98,798.80 156,601.91 1 $ 57,803.11 $ (187,697.19) 0.10/0.10 32,672.82 $ 938.49 34,334.64 140,463.34 $ 106,128.70 $ (81,568.49), 0.10/0.10 133,526.02 $ 407.84 134,657.19 141,839.35 I $ 7,182.16 $ (74,386.33) ` 0.12/0.12 47,162.69 $ 371.93 48,257.95 130,405.95 $ 82,148.00 $ 7,761.67 0.12/0.12 50,526.75 $ - 51,250.08 123,867.08 1 $ 72,617.00 $ 80,378.67 i 0.12/0.12 15,068.07 $ 15,791.40 116,380.65 $ 100,589.25 $ 180,967.92 0.12/0.12 100,000.00 $ - I 110,000.00 125,662.80 $ 15,662.80 $ 196,630.72 0.12/0.12 4,5 50,000.00 - ~$ (50,000.00) $ 146,630.72 858,429.86 $ 11,632.09 1,128,215.39 1,573,964.64 $ 445,749.25 190,196.81 (5)' Accrual $ - Net EIA =i $ 17,956.62 $ - Net ORA = $ 858,429.86 I $ 50,000.00 CLEARWATER GAS SYSTEM SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTIONS FOR FY 2015/2016 Attachment #1 Page 3of4 USAGE AND INFLATION ADJUSTMENT (UTA) Commercial Monthly + Cumulative UTA Budget Interest 1 Overage YTD Overage ! NG /Therm Month LP Gallons Expense Rate /Gallon ' NG Therms Rate /Therm (Shortage) (Shortage) I LP /Gal Beg. Bal. j $ - $ (125,739.87); Oct -15 8,794.5 $ 628.70 0.02 l 914,466.2 0.02 $ 17,773.24 $ (107,966.63); 0.02/0.02 Nov -15 5,503.7. $ 539.83 0.02 T 723,384.7 0.02 $ 14,032.19 $ (93,934.44); 0.02/0.02 Dec -15 7,245.0 i $ 469.67 0.02 949,118.3 0.02 $ 17,497.21 $ (76,437.23) 0.02/0.02 Jan -16 6,932.1 ; $ 382.19 0.01 1 1,046,106.1 0.01 $ 9,954.93 $ 66,482.30) 0.01/0.01 Feb -16 8,413.5 $ 332.41 0.01 1,117,295.3 0.01 $ 10,910.40 $ (55,571.90 0.01/0.01 Mar -16 9,083.4 ! $ 277.86 0.01 1,119,403.7 0.01 $ 10,999.84 $ (44,572.06)1 0.01/0.01 Apr -16 7 970.3 $ 222.86 0.01 1,044,213.9 0.01 $ 10,571.99 $ (34,000.07): 0.01/0.01 May-16 7,472.6 $ 170.00 0.01 908,996.3 0.01 $ 8,988.95 $ (25,011.12)', 0.01/0.01 Y Jun -16 7,742.4: $ 125.06 0.01 I i 845,759.6 0.01 $ 8,398.52 $ (16,612.60)' 0.01/0.01 Jul -16 6,219.8 i $ 83.06 ! 0.01 823,140.1 0.01 $ 8,206.48 $ (8,406.12); 0.01/0.01 Aug -16 7,271.1 I $ 42.03 ( 0.01 1 J 770,995.7 0.01 $ 7,731.63 $ (674.49): 0.01/0.01 Sep -16 6,500.0 i $ 3.37: 0.01 ! 825,000.0 1 0.01 $ 8,311.63 $ 7,637.14 0.01/0.01 Per 13 I I $ - $ 7,637.14 Total YTD 89,148.4 , 3,277.04 i ' r 11,087,879.9 $ 133,377.01 1 l 1 (1) Recomputed UTA in December for January application. Decreased by 1 cents to recover $167,673.08 from FY 14/15 less overcollections in FY 14/15 of ($41,933.21) = $125,739.87. USAGE AND INFLATION ADJUSTMENT (UIA1 Residential Budget Month Beg. Bal. -. Oct -15 Nov -15 Dec -15 Jan -16 Feb -16 Mar 16 Apr -16 May -16 Jun 16 Jul -16 Aug -16 Per 13 _ Total YTD Monthly Cumulative UTA Interest Overage YTD Overage NG /Therm LP Gallons Expense Rate /Gallon NG Therms Rate /Therm (Shortage) (Shortage) LP /Gal $ (20, 750.81)1 29,023.6 � $ 103.75 0.01 214,018.9 0.01 $ 2,323.69 $ (18,427.12)j 0.01/0.01 19,632.0 $ 92.14 0.01 ! I 202,519.0 0.01 $ 2,123.67 $ (16,303.45)(_ 0.01/0.01 20,840.8 $ 81.52 0.01 i 281,496.3 0.01 $ 2,945.15 $ (13,358.30)1 0.01/0.01 27,869.5 $ 66.79 0.01 351,334.8 0.01 $ 3,731.58' $ (9,626.72)1 0.01/0.01 36,710.0 $ 48.13 0.01 491,635.9 0.01 $ 5,242.28 $ (4,384.44), 30,537.6 I $ 21.92 0.01 I 407,739.1 0.01 $ 4,369.95 $ (14.49)♦ 0.01/0.01 20,079.7 ' $ 0.07 0.01 329,791.4 0.01 $ 3,520.26 $ 3,505.77 0.01/0.01 17,364.4 $ - 0.01 247,922.2 0.01 $ 2,656.06 $ 6,161.83 , 0.01/0.01 16,955.2 $ - 0.01 217,487.6 0.01 $ 2,341.05 $ 8,502.88 0.01/0.01 16,469.7 $ - 0.01 ! 186,972.7 0.01+$ 2,029.32 $ 10,532.20 j 0.01/0.01 18,094.0_, ' $ - 0.01 174,458.1 0.01 $ 1,911.89 $ 12,444.09 0.01/0.01 15,000. $ - 0.01 ! 200,000.0 0.01 $ 2,150.00 $ 14,594.09 i 0.01/0.01 $ - $ 14,594.09 268,577.3 414.33 3,305,376.0 l $ 35,344.90 L_ i (1) Recomputed UTA in December for January application. No change in rate of 1 cents. Need to recover $22,562.83 from FY 14/15 less overcollections in FY 14/15 of ($1,812.02) = $20,750.81. l CLEARWATER GAS SYSTEM SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTIONS FOR FY 2015/2016 Attachment #1 Page 4of4 TOTAL ALL COST RECOVERY - Budget _ Month Prior Year Oct 15 Nov -15 Dec -15 Jan -16 Feb -16 Mar -16 Apr -16 May -16 Jun -16 Jul -16 Aug -16 Sep -16 Per 13 Total YTD Monthly Cumulative Total Res! Total All Total Recovery Overage YTD Overage 4 NG /Thm (Firm) Expenses Billed (Shortage) (Shortage) — LP /Gal - - $ - $ (1,189,371.11).! $ 7,569,084.34 $ 1,823,456.10 1 $ (5,745,628.24) $ (6,934,999.35) 1.15/1.89 1,067,306.09 $ 1,549,776.43 1 $ 482,470.34 $ (6,452,529.01)! 1.15/1.89 1,244,813.43 $ 1,911,971.68 -1 667,158.26 $ (5,785,370.76), 1.15/1.89 1,215,306.26 $ 2,183,610.04 $ 968,303.78 $ (4,817,066.98)1 1.15/1.89 1,392,865.94 $ 2,345,964.14 1 $ 953,098.20 $ (3,863,968.78) 1.10/1.77 i 1,332,641.25 $ 2,285,429.96 952,788.71 $ (2,911,180.07)1 1.10/1.77 981,696.27 , $ 1,840,999.03 ! $ 859,302.76 $ (2,051,877.31) 0.97/1.67 1,103,316.46 $ 1,553,199.41 $ 449,882.95 $ (1,601,994.36) 0.94/1.57 1,378,145.31 $ 1,467,512.09 1 $ 89,366.78 $ (1,512,627.57)1 0.94/1.57 1,872,662.61 $ 1,401,673.45 , $ (470,989.16) $ (1,983,616.73 )1 0.94/1.57 1,065,714.70 $ 1,346,411.03 t $ 280,696.33 $ (1,702,920.40)i 0.94/1.57 , 1,147,137.64 $ 1,415,066.78: $ 267,929.14 $ (1,434,991.26) 0.94/1.57 1,042,842.09 $ 922,279.54 i $ (120,562.55) $ (1,555,553.81) 22,047,349.68 $ (366,182.70) Last Updated 09/20/2016 R E s E R V A T 0 N C 0 M M 0 0 T Y Oct -16 Nov -16 Dec -16 Jan -17 Feb -17 Mar -17 Apr -17 May -17 Jun -17 Jul-17 Aug -17 Sep.17 FTS -1 50.5518 Volume Cost 170,438 $ 94,047.69 306.570 S 169.165.33 316,789 $ 174.804.17 316.789 $ 174.804.17 286.132 5 157,887.64 316.789 $ 174.804.17 215.570 $ 119,50333 144.212 $ 79.576.18 139.560 $ 77,009.21 144.212 5 79,576.18 144.212 $ 79,576.18 139,560 i 77,009.21 Iota) 2641,833 $ 1,457,163.45 $0.5518 FTS -2 50.6518 Volume Cost 41788 5 27.237.42 53.430 $ 34,825.67 55,211 $ 35,98653 55,211 $ 35,986.53 49,868 $ 32,503.96 55,211 $ 35,986.53 53,430 $ 34,825.57 41,788 $ 27,237.42 40,440 S 26,358.79 41,788 8 27,237.42 41,788 $ 27,237.42 40,440 5 26.358.79 570,393 $ 371,782.16 CGS Natural Gas Summary Monthly Actual /Projections (FY17) No- Notice $0.0478 Volume Cost__ 15.500 $ 740.90 22.500 $ 1,075.50 31,000 $ 1,481.80 46,500 $ 2,222.70 42,000 $ 2,00760 31,000 $ 1,481.80 22,500 $ 1,075.50 12,400 $ 592.72 10,500 $ 501.90 10,850 $ 518,63 10,850 $ 518.63 10.500 $ 501.90 266,100 $ 12,719.58 Capacity Relinquishmont Reservation Volume Rate Cost Adjustments (50,000) $ 0.25 $ (12,50000) 50.00 (50,000) $ 0.25 $ (12,500.00) $0.00 (50,000) $ 0.30 $ (15,000.00) 50.00 (50,000) $ 0.30 $ (15,000.00) 50.00 (50,000) $ 0.30 $ (15,00000) $0.00 (50,000) $ 0.30 $ (15,000.00) 50.00 (50,000) $ 0.25 $ (12,500.00) 50.00 (50,000) $ 0.25 $ (12,50000) 50.00 (50,000) $ 0.25 $ (12,50000) $0.00 (50,000) $ 0.25 $ (12,500.00) 50.00 (50,000) $ 0.25 $ (12,500.00) 30.00 (50.000) $ 0.25 $ (12,500.00) $0.00 (600,000) ($160,000.00) 50.00 TOTAL RESERVATION COST Total Rate 5 109,526.01 50.6163 $ 192,566.50 $0.5791 $ 197,272,50 80.5588 5 198,013.40 $0.5373 $ 177,399.20 50.5409 $ 197,272.50 80.5588 $ 142,904 50 $0.5893 5 94,906.32 50.6395 5 91,369.90 $0.6503 $ 94,832.23 $0.6458 5 94,832.23 $0.6458 $ 91,369.90 50.6503 $1,682,265.19 $0.5845 $0.6518 50.0478 as of 9/19/2016 FGU No Notice GTI Prior Month FTS -1 (Usage) FTS -2 (Usage) Gas Supply (FGU & Peoples) Management fee Usage Payment Cashout Adjustment Volume Rate Cost Volume Rate Cost Volume Rate Cost Fuel % $0.065 80.020 Oct -16 158,212 $ 0.0154 5 2,436.46 41,788 $ 0.0154 $ 643.54 204,000 $ 3.3786 5 689,234.00 150% $ 13,000.00 $ - $ 4,000.00 $ - 5 - Nov -16 184.570 $ 0.0154 5 2,842.38 53430 $ 00154 $ 822.82 242,000 $ 3.2761 $ 792.820.00 3.50% 5 15,470.00 $ - $ 4,760.00 3 - $ Dec -10 218,789 5 0.0154 5 3,369.35 55,211 $ 0.0154 $ 850.25 280,000 $ 3.4302 $ 960,454.00 3.50% 5 17,810.00 $ $ 5,480.00 5 - $ Jan -17 194,789 5 0.0154 5 2,99935 55,211 $ 0.0154 $ 850.25 256,000 $ 3,4916 $ 893,848.00 3.50% $ 16,250.00 $ - $ 5,000.00 $ - 5 - Feb -17 217,132 5 0.0154 5 3,343.83 49,868 $ 0.0154 $ 767.97 272,500 $ 3.4194 $ 931,774.00 3.50% $ 17.355.00 $ - $ 5,340.00 $ - $ Mar-17 178,789 5 0.0154 $ 2,753.35 55,211 $ 0,0154 $ 850.25 239,500 $ 3.3367 $ 799,148.00 3.50% $ 15,210.00 $ - $ 4,680.00 $ - $ Apr -17 156.570 5 0.0154 $ 2,411.18 53,430 $ 0.0154 $ 822.82 215,500 $ 3.3874 $ 729,990.00 3.50% S 13,650.00 $ - $ 4,200.00 $ - 5 May -17 150,212 5 0.0154 $ 2.313.26 41,788 $ 0.0154 $ 643.54 197,000 $ 3.5145 $ 692,348.00 3.50% $ 12,480.00 $ $ 3,840.00 $ - 5 - Jun -17 142.560 5 0.0154 $ 2,195.42 40.440 $ 0.0154 $ 622.78 187,000 $ 3.4946 $ 653,490.00 3.50% 5 11,895.00 $ $ 3,660.00 $ - $ - Jul -17 141,212 5 0.0154 $ 2,174.66 41.788 $ 00154 $ 643.54 187,000 $ 3.5139 $ 657,098.00 3.50/6 $ 11,895.00 $ - 5 3,66000 $ - S - Aug -17 141.212 5 0.0154 5 2,1/4.66 41.788 $ 0.0154 $ 643.54 187,000 $ 3,5396 $ 661,908.00 3.50% $ 11,895,00 $ - $ 3,660.00 $ - 5 - Sep -17 145.560 0 0.0154 5 2,241.62 40,440 $ 00154 $ 622.78 190000 $ 3.5097 $ 666840.00 3.5056 $ 12090.00 5 - $ 3,720.00 $ $ - COMMODITY COST lolal 2,029,607 50.0154 $ 31,255.95 5/0,393 $0,0154 i, $ 8,784.05 2,657,500 $3.44': $ 9,128,952.00 $169,000.00 $0.00 552,000.00 50.00 $0.00 TOTAL COST Resory & Comm RATE $ 818,840.01 $ 4.01 5 1,009,281./0 $ 4.17 $ 1,185,236.10 $ 423 $ 1,116,961.40 5 4.36 5 1,135,980.00 $ 4.17 $ 1,019,914.10 $ 4.26 893,9/8.50 $ 4.15 $ 806,531.12 $ 4.09 $ 763,233.10 $ 4.08 $ //0,303.43 $ 4.12 5 776,113.43 $ 4.14 5 //6,884.30 $ 4.09 $ 11,072,257.19 $ 4.1/ Total Projected OTH WACOG Total Reservation Total Commodity Cost Purchased 1st Months $ 1,072,050.11 $ 5,214,163.20 $ 6,286,213.31 1,494,000 $4.208 2nd 6 Months $ 610,215.08 $ 4,175,828.80 $ 4,786,043.88 1,163,500 $4.113 T01'AI. $ 1,682,265.19 $ 9,389,992.00 $ 11,072,257.19 2,657,500 $4.166 $ 709,314.00 $ 816,71520 $ 987,963.60 $ 918,948.00 $ 958,580.80 $ 822,641.60 $ /51,074.00 $ 711,624.80 $ 611,863.20 $ 675,471.20 $ 680,281.20 $ 685 514.40 59,389,992.00 AriAcH mg'4 r 43 ?ropaae Weig"teo Average Cost of Gas (WACOG) 7V20'516 9/19/20'6 Projections Delivered Delivered Delivered Cost Total EOM Tank EOM Tank Projected Month CGS Cost Gallons Cost of Inventory Gallons Gallons Cost WACOG Aug -16 36,911 S 25,036.00 0.68 Sep -16 S 0.70 35,000 S 24,500.00 $ 49,536.00 71,911 36,911 S 25,426.20 0.69 Oct -16 $ 0.75 27,000 S 20,250.00 $ 45,676.20 63,911 36,911 $ 26,379.72 0.71 Nov -16 S 0.75 40,000 S 30,000.00 S 56,379.72 76,911 36,911 S 27,057.66 0.73 Dec -16 S 0.75 45,000 S 33,750.00 S 60,807.66 81,911 36,911 S 27,401.35 0.74 Jan -17 S 0.75 45,000 S 33,750.00 S 61,151.35 81,911 36,911 S 27,556.22 0.75 Feb -17 S 0.80 40,000 S 32,000.00 S 59,556.22 76,911 36,911 S 28,582.12 0.77 Mar -17 S 0.80 27,000 S 21,600.00 S 50,182.12 63,911 36,911 S 28,982.06 0.79 Apr -17 S 0.90 27,000 S 24,300.00 S 53,282.06 63,911 36,911 S 30,772.39 0.83 May -17 S 0.90 18,000 S 16,200.00 S 46,972.39 54,911 36,911 S 31,574.69 0.86 Jun -17 S 0.90 18,000 S 16,200.00 S 47,774.69 54,911 36,911 S 32,113.99 0.87 Jul -17 S 0.90 18,000 S 16,200.00 S 48,313.99 54,911 36,911 S 32,476.51 0.88 Aug -17 S 0.90 27,000 S 24,300.00 S 56,776.51 63,911 36,911 S 32,790.57 0.89 Sep -17 S 0.90 27,000 S 24,300.00 S 57,090.57 63,911 36,911 S 32,971.94 0.89 II Invoice Gallons Compan•/� Tanga 1 L8.1 Shipping_ Delivered Propane Propane Rate Cost Shipping Cost Total Cost FYTD Gallons Cost of Inventory Tank Inventory Tank Withdraw) WACOG II --Date 09/30/15 .., l'etsawl Totals ... 5 33,452.86 50,0241 0.66874 ■10/19/15 Targa /5050170 18,004 0.67188 $ 11,233.42 $ 863.12 S 12,096.54' 18,094.0 S 45,549.40 68.028 0.669571 '110/26/15 Targa I 15051086 8,992 8849 620 0.66694 $ 5,566.05 5 43107 $ 5,997.12 26,996.0 $ 51,546.52 77,020 0.66926 '10/27/15 + Targa 15051249 066694 0 5,477.54 S 424.22 $ 5,901.76 35,845.0 S 57,44828 85,869 0.66902 0.66815 10/31/15 MONTHLY INVENTORY ADJUSTMENT 0.54742 5 339.40 $ - 5 339.40 36 465.0 S 57 787.68 86,489 110/31/15 11/05/15 END OF MONTH Targa 15052871 '- , - , $ 30,764.33 46,044 54,767 40,445 0.66815 0.67310 8,723 0.69924 $ 5,683.04 5 41640 5 6,099.44 45,188.0 9 36,863.77 11/06/15 Targa 15054019 8,784 8,850 - 0.69174 5 5,656.90 1 $ 419.32 $ 6,076.22 53,9720 1 S 42,939.99 63,551 0.67568 11/23/15 Targa 15055637 0.64424 $ 5,27903 $ 422.46 5 5,701.49 62,822.0 5 48,641.48 72,401 067183. 11/30/15 MONTHLY INVENTORY ADJUSTMENT $ - $ - 5 - 62,822.0 S 48,64148 72,401 0.67183 11/30/15 END OF MONTH , . 4i01VN! $ •: , , ,�, $ - .8 -• .; ;' 5 32,063.97 47,726 24,675 0.67183 11/24/15 Targa 15056023 8,857 0.65174 5 5.349.63 $ 42280 $ 5,772.43 71.679.0 $ 37,836.40 56,583 0.66869 12/18/15 Targa I. 15060311 9,051 0.59403 $ 4,946.37 $ 430.21 $ 5,376.58 80,730.0 $ 43,212.98 65,634 _ 0.65839 12/31/15 MONTHLY INVENTORY ADJUSTMENT 1,519 0.51364 S 780.22 $ - $ 780.22 82,249.0 $ 43,993.20 67,153 0.65512 12/31/15 END OF MONTH M $ 24,173.89 36,900 30,253 0.65512 01/07/16 Ta .a 16001833 17,977 0.59829 $ 9,915.71 $ 839.82 5 10,755.53 100,226.0 5 34,929.42 54,677 0.63650 EMENIMEM IMEIMIN Ih 16004875 9,372 MEM 5 4.84064 0 437.82 5 5,278.46 109 598.0 $ 40,207.88 64,249 I 062581 16006315 16006316 9,205 9,101 850 =Mil IMIEM $ 4,708.36 5 429.92 $ 5,13828 118,803.0 5 45,346.16 73,454 0.61734 S 4,746.17 5 425.16 $ 5,171.33 127,904.0 $ 50,517.49 ■ 82,555 061193 MONTHLY INVENTORY ADJUSTMENT $ 1,217.51 5 - $ 1,217.51 128,754.0 5 51,735.00 83,405 1 0.62029 388111111END OF MONTH 02/11/16 Targa 16009818_ 18.119 , , 1; • _ •.., 060896 0 ,. .:10,128.52 5 905 31 .,: - „ „ , :`, $ 29,128.65 46,960 36,445 0.62029 S 11,033.83 146,873.0 5 40.162.48 65,079 0.61713 02/24/16 Tara 16011747 02/25/16 Targa /60/1972 9,003 9,128 456 064260 0.65010 9 5,370.29 9 415.07 $ 5,785.36 155,876.0 5 45,947.84 74,082 0.62023 $ 5,513.31 5 42083 $ 5,934.14 165,004.0 $ 51,88198 83,210 0.62351 02/29/16 MONTHLY INVENTORY ADJUSTMENT 0.17618 0 80.34 $ - $ 83.34 165,460.0 5 51,962.32 83,666 0.62107 02/29/16 END OF MONTH ,Y; .,.,,, ., ... , . . , ° ° $ 21,369.11 34,407 49,259 0.62107 03/10/16 Targa i 16015000 8,788 0.71179 $ 5,857.20 5 39799 $ 6,255.19 174,248.0 $ 27,624.30 43,195 0.63953 03/17/16 Targa 16015860 9,187 067179 0 5,755.65 S 416.06 0 6,171.71 183,435.0 $ 33,796.01 52,382 0.64518 03/18/16 Targa 16016108 8,683 0.68179 $ 5,526.73 5 393.24 5 5,919.97 192,118.0 $ 39,715.98 61,065 0.65039 03/28/16 Tar•4 16017016 8,841 0.65679 $ 5,406.27 $ 400.39 5 5,806.66 200,959.0 0 45,522.64 69,906 0.65120 aMMIMIMEM 16017192 8,649 559 $ 5,288.87 $ 391.70 5 5,680.57 209,608.0 5 51,203.21 78,555 0.65181 MONTHLY INVENTORY ADJUSTMENT 0.36152 $ 202.09 5 - 0 202.09 210,167.0 $ 51,405.30 79,114 0.64976 03/31/16 END OF MONTH o ", :,',14, , , ;:. "c,..,?. ... , . .. ,..;: $ 25,873.54 39,820 39,294 0.64976 04/11/16 Targa 16019445 9,149 0.64240 5 5457.38 $ 419.94 $ 5,877.32 219,316.0 $ 31.750.86 48,969 0.64839 04/13/16 Tar 16019860 8,887 0.64740 S 5,345.53 5 407.91 S 5,753.44 228,203.0 $ 37,504.30 57856 C.64824 0425/16 04/26/16 I.. EMMI41ER6I MONTHLY 16020993 8,814 - 8,721 INVENTORY ADJUSTMENT 559 0.65990 0.65990 $ 5,411.80 5 404.56 $ 5,816.36 237 017 0 5 43,320.66 66,670 0.64978 5 5,354.69 5 400.30 5 5,754.99 245,738.0 $ 49,075.65 75,391 0.65095 i 04/30/16 0.70487 $ 394.02 5 - 1 $ 394.02 246,297 .,0 $ 49,469.67 75.950 0.65135 04/30/16 END OF MONTH „. $ 31,467.79 48,312 27,638 0.65135 05/11/16 Targa 1 16024041 9,047 0.68491 S 5,758.41 5 437.95 $ 6,196.36 255,344.0 $ 37,664.15 57,359 0.65664 05/25/16 Targa /6025522 8,773 0.73116 $ 5,989.77 $ 424.70 5 6,414.47 264,117.0 $ 44,078.62 66,132 0.66652 05/31/16 Tega 16026307 9,020 538 0.77116 0.62301 S 6,519.21 5 436.65 $ 6,955.86 273,1370 $ 51,034.48 75,152 0 -67908 05/3'/16 MONTHLY INVENTORY ADJUSTMENT $ 335.18 S - I5 335.18 273,6750 5 51,369.66 75,690 0.67868 :05/31/16 END OF MONTH =, .j -; • °': S 5,903.95 d: 282,,3000 $ 34,340.78 $ 400,244.73 50,599 59,224 25,091 0.67868 0.67953 06/06/16 Targa 1 160273231 8,625 0.68452 5 5479.03 $ 424.92 06/10/16 Targa 16328646 8,558 _ -_ 0.70452 5 5,607.63 5 421.61 $ 6,029.24 290,858.0 $ 46,273.97 67,782 0.68269 06/28/16 Targa 1 8,673 544 C.72202 $ 5,834.76 $ 42728 $ 6,262.04 299,531.0 $ 52,536.01 76,455 0.68715 06/30/16 MONTHLY INVENTORY ADJUSTMENT S - 5 $ - 303,075.0 5 52,536.01 76,999 0.68229 06/30/16 END OF MONTH n,.. _� ,s : 5 35,647.17 52,246 24,7531 0.68229 0725/16 Targa 1 116034228 17,883 221 0.67097 0.89584 $ 11,106.45 $ 892.51 $ 11,99896 317,958.0 $ 47,646.13 70,129 1 06794' 07/31/16 MONTHLY INVENTORY ADJUSTMENT $ 197.98'', $ - $ 197.98 318,179.0 5 47,844.11 70,350 1, 0.68009 '.07/31/16 END OF MONTH $ 31,264.95 45,972 24,378 0.68009 98/'6/16 Tara ' 16037762 17.440 395 065317 1.57957 $ 10,524.70 $ 666.67 $ 11,391.37 335.619.3 $ 42,656.32I 63,412 ! 0.67269 38/31/16 MONTHLY INVENTORY ADJUSTMENT $ 623 93 1 5 5 623.93 336,314.3 5 43,280.25 63,807 1 0.67830 108/31/16 END OF MONTH , ; $ 25,036.71 36,911 28,896 0.67830 09/12/16 Targa 1 /6041700 8,628 0.68277 $ 5,465.84 $ 425.06 $ 5,890 93 344,642.0 $ 30,927.61 45,539 0 _67915 09/13/16 Targa /604/775 8,739 0.67777 5 5,492.47 $ 430.54 $ 5 92301. 353,3810 $ 36,850.62 54,278 1 0.67892. ■ FYTO Totals ! 277 199 0.65161 5 167 565.52 5 13,059.84 1 $ 180,625.36 Projections Delivered Delivered Delivered Cost Total EOM Tank EOM Tank Projected Month CGS Cost Gallons Cost of Inventory Gallons Gallons Cost WACOG Aug -16 36,911 S 25,036.00 0.68 Sep -16 S 0.70 35,000 S 24,500.00 $ 49,536.00 71,911 36,911 S 25,426.20 0.69 Oct -16 $ 0.75 27,000 S 20,250.00 $ 45,676.20 63,911 36,911 $ 26,379.72 0.71 Nov -16 S 0.75 40,000 S 30,000.00 S 56,379.72 76,911 36,911 S 27,057.66 0.73 Dec -16 S 0.75 45,000 S 33,750.00 S 60,807.66 81,911 36,911 S 27,401.35 0.74 Jan -17 S 0.75 45,000 S 33,750.00 S 61,151.35 81,911 36,911 S 27,556.22 0.75 Feb -17 S 0.80 40,000 S 32,000.00 S 59,556.22 76,911 36,911 S 28,582.12 0.77 Mar -17 S 0.80 27,000 S 21,600.00 S 50,182.12 63,911 36,911 S 28,982.06 0.79 Apr -17 S 0.90 27,000 S 24,300.00 S 53,282.06 63,911 36,911 S 30,772.39 0.83 May -17 S 0.90 18,000 S 16,200.00 S 46,972.39 54,911 36,911 S 31,574.69 0.86 Jun -17 S 0.90 18,000 S 16,200.00 S 47,774.69 54,911 36,911 S 32,113.99 0.87 Jul -17 S 0.90 18,000 S 16,200.00 S 48,313.99 54,911 36,911 S 32,476.51 0.88 Aug -17 S 0.90 27,000 S 24,300.00 S 56,776.51 63,911 36,911 S 32,790.57 0.89 Sep -17 S 0.90 27,000 S 24,300.00 S 57,090.57 63,911 36,911 S 32,971.94 0.89 CSW:09/20/2016 PURCHASED GAS ADJUSTMENT (PGA) CALCULATIONS FOR THE BILLING PERIOD OF 10/01/2016 - 09/30/2017 I. Differential between the Natural Gas Firm Standard Rate Schedule PGA and the Natural Gas Interruptible & Contract (Non- Standard) Rate Schedule PGA (See attached Page 2) _ $0.09 II. Calculation of the Required Natural Gas PGA WACOG for FY 16/17 A. Therm Sales Projection for 10/1/16 - 9/30/17 = 26,000,000 B. Projected NG Reservation Cost 10/1/16 - 9/30/17 = $ 1,700,000 Projected NG Commodity Cost 10/1/16 - 9/30/17 = $ 9,400,000 Budgeted Other Supply Related Expenses = $ 4,950,000 Total Recovery Needed for FY 16/17 only = $ 16,050,000 Plus Projected Under Recovery of FYTD PGA thru 9i $ Total Annualized Recovery Needed for FY 16/17 = $ 16,050,000 C. Required Weighted Average Recovery Cost/Therm = $ 0.617 Currently overall PGA Recovery is: 96.0% of Firm Rate Therefore, Firm PGA needs to be: $ 0.64 Which makes Contract PGA: $ 0.55 D. Projected NG PGA Annual Revenue = Pinellas NG PGA = Pasco NG PGA = Total NG PGA = ATTACHMENT #4 Page 1 of 2 $ 13,093,400 S 2,956,600 $ 16,050,000 III. Proposed Natural Gas PGA Billing Factors for 10/1/16 - 9/30/17 PGA Only ECA in PGA Total PGA A. Proposed Standard Rate PGA Billing Factor $ 0.64 $ 0.15 S 0.79 B. Less Non - Standard Differential for Reservation Cost $ (0.09) 5 - S (0.09) C. Proposed Non - Standard PGA Billing Factor $ 0.55 $ 0.15 $ 0.70 PGA Only' ECA in PGA Total PGA IV. Proposed LP Gas Billing Factors for 10/1/16 - 9/30/17 S 1.69 S 0.15 S 1.84 (Assumes current LP market conditions persist) Note: Includes 0 cents /gallon credit to balance the SO projected under - recovery from 400,000 gallons over the year & 88 cents /gallon to recoup the $350,000 of Admin & CCS projected charges. Base est. was $0.81 /gallon. \ \^•lasers- '.\.sets\ Gas \c.::ek.war- ^g'cr\.Vy Jcc..r•.erts \EXCE. \GASRATES \FY ",6-17\:PGA 'for =Y 16- '7.xsx:PGACA..0 Csw. 09/20/2016 CLEARWATER GAS SYSTEM ANALYSIS OF STANDARD VS. NON - STANDARD THERMS & RESERVATION CHARGES FOR 09/01/2015 - 08/31/2016 ATTACHMENT #4 Page 2 of 2 Subtotal Subtotal Net Net Charge Per Charge Per Billing Total Interruptible % Contract % Non - Standard % Non- Standard % Reservation Standard Non - Interruptible Month Therms Therms Interruptible Therms Contract Therms Standard Therms Standard Charges Therm Therm Sep 2015 1,699,885 549,751 32.3% 139,907 8.2% 689,658 40.6% 1,010,227 59.4% $ 90,112.63 $ 0.089 $ 0.078 Oct 2015 1,729,514 517,934 29.9% 161,900 9.4% 679,834 39.3% 1,049,680 60.7% $ 104,482.21 $ 0.100 $ 0.086 Nov 2015 1,762,021 553,282 31.4% 114,629 6.5% 667,911 37.9% 1,094,110 62.1% $ 143,902.27 $ 0.132 $ 0.119 Dec 2015 1,982,230 535,856 27.0% 165,154 8.3% 701,010 35.4% 1,281,220 64.6% $ 164,606.17 $ 0.128 $ 0.114 Jan 2016 2,215,006 582,763 26.3% 187,557 8.5% 770,320 34.8% 1,444,686 65.2% $ 159,338.19 $ 0.110 $ 0.098 Feb 2016 2,479,222 673,169 27.2% 196,852 7.9% 870,021 35.1% 1,609,201 64.9% $ 168,766.72 $ 0.105 $ 0.093 Mar 2016 2,403,215 611,392 25.4% 196,346 8.2% 807,738 33.6% 1,595,477 66.4% $ 168,766.72 $ 0.106 $ 0.094 Apr 2016 2,177,556 580,092 26.6% 184,993 8.5% 765,085 35.1% 1,412,471 64.9% $ 132,578.64 $ 0.094 $ 0.083 May 2016 1,919.976 543,000 28.3% 187,568 9.8% 730,568 38.1% 1,189,408 61.9% $ 105,492.51 $ 0.089 $ 0.077 Jun 2016 1,843,082 581,117 31.5% 161,848 8.8% 742,965 40.3% 1,100,117 59.7% $ 98,556.12 $ 0.090 $ 0.078 Jul 2016 1,757,927 561,289 31.9% 149,168 8.5% 710,457 40.4% 1,047,470 59.6% $ 99,129.09 $ 0.095 $ 0.083 Aug 2016 1,686,176 551,232 32.7% 150,081 8.9% 701,313 41.6% 984,863 58.4% $ 101,241.72 $ 0.103 $ 0.089 Total 9/15 -8/16 23,655,810 6,840,877 • of Total 100.0% 28.9% For Comparison 28.9% 1,996,003 8.4% 8,836,880 37.4% 14,818,930 62.6% $ 1,536,972.99 $ 0.104 $ 0.0914 # 8.4% 37.4% 62.6% Total 9/14 -8/15 24,227,149 7,308,548 30.2% 1,886,698 7.8% 9,195,246 38.0% 15,031,903 62.0% $ 1,567,303.52 $ 0.104 $ 0.0926 • of Total 100.0% 30.2% 7.8% 38.0% 62.0% Change (571,339) (467,671) -1.2% 109,305 0.7% (358,366) -0.6% (212,973) 0.6% $ (30,330.53) $ (0.001) $ (0.0012) • Change -2.4% -6.4% 5.8% -3.9% -1.4% -1.9% Note: # It is recommended that the "Charge Per Non - Interruptible Therm" differential be rounded to $0.09 for the FY 16/17 annual cycle. \ \msb- users- 1 \Users\Gas \chuck.warrington\My Documents \EXCEL \GASRATES \FY 16 -17 \(PGA for FY 16- 17.0Isx)PGACALC CSW:09/20/2016 ATTACHMENT #5 ENERGY CONSERVATION ADJUSTMENT (ECA) & REGULARORY IMPOSITION ADJUSTMENT (RIA) CALCULATIONS FOR THE BILLING PERIOD OF 10/01/2016 - 9/30/2017 1. Calculation of the Energy Conservation Adjustment (ECA) Required for FY 16/17: Projected ECA Requirements for FY 16/17 only = $ 3,100,000 Projected Administrative & CCS Charges to ECA for FY 15/16 = $ 600,000 Projected Current FYE 15/16 (Over) Under Recovery of ECA = $ 1,200,000 Total Annualized ECA Recovery Needed during FY 16/17 = $ 4,900,000 Less Projected ECA Recovery within PGA @ $0.15/Therm or Gal = $ (2,500,000) Total ECA Recovery Needed from Standard Rate Customers = $ 2,400,000 Projected Therm Sales for FY 16/17 Applicable to ECA Recovery = (Natural Gas @ 63% Standard = 16,400,000 therms & LP @ 100% Standard = 400,000 gal. or 16,800,000 Total Applicable Therms) 15,875,000 Computed ECA Recovery Factor Necessary = $ 0.1512 Propose Rounding ECA Recovery Rate to $ 0.150 Annual ECA Revenue Projection @ Proposed Recovery Rate = $ 4,881,250 II. Calculation of the Regulatory Imposition Adjustment (RIA) Required for FY 16/17: The RIA is actually a combination of the Environmental Imposition Adjustment (EIA) and an adjustment factor for new regulatory impositions (ORA). Budgeted RIA Requirements * for FY 16/17 only = Projected Current FYE 15/16 (Over) Under Recovery of RIA = Projected Other Expenses = Total Annualized RIA Recovery Needed during FY 16/17 = Therefore, RIA needs for FY 16/17 to fully Recover Expenses = Round Proposed RIA Recovery Rate to Annual RIA Revenue Projection @ Proposed Recovery Rate = Projected End of FY Remainder to Collect = $ 1,550,000 $ (145,000) $ 20,000 $ 1,425,000 $ 0.090 $ 0.09 $ 1,428,750 $ (3,750) Note: Budget based on $350,000 projected EIA requirements + $1,200,000 projected ORA requirements = $ 1,550,000 \ \msb- users -1 \Users \Gas \chuck.warrington11y Documents \EXCEL \GASRATES \FY 16 -17 \[ECA & RIA for FY 16- 17.xisx]Sheet1 C S W 09/20/2016 CLEARWATER GAS SYSTEM NATURAL GAS RATE BILLING FACTORS FOR October 1, 2016 - SEPTEMBER 30, 2017 BASED ON APPROVED GAS ADJUSTMENT FACTORS Attachment #6 Interr. Contract Firm Natural Gas Rate Schedules NG Rate NG Rate RS SMF MMF LMF SGS MGS LGS RAC_ GAC LAC SL SL w /M& NGV NSS IS CNS Relight (Non -Rest) (Non -Rest) Applicable Annual Therm Range NA (1 - NA (4 + NA (4 + NA (4 + 0 - 18,000- 100,000 NA (1 - NA (0 - NA (150 NA NA NA NA 100,000 NA or Other Rate Determinant 3 Units) Units) Units) Units) 17,999 99,999 & up 3 Units) 149 tons) tons & +) & up Monthly Customer Charge $12.00 $25.00 $40.00 $95.00 $25.00 $40.00 $95.00 $12.00 $25.00 $40.00 520.00 $20.00 By Contract $50.00 5250.00 By Contract (For Central Pasco Territory) (520.00) ($40.00) (570.00) ($160.00) (540.00) ($70.00) ($160.00) ($20.00) ($40.00) ($70.00) ($30.00) ($30.00) (By Contract) (575.00) $400.00 (By Contract) if not prey. if not prey. 4 not prey. Non•Fuel Energy Charge /Therm billed billed billed Non -Fuel Energy Charge 50.44 $0.44 $0.44 50.44 50.42 $0.38 $0.34 $0.20 $0.15 $0.10 $0.20 $0.35 By Contract $0.42 50.24 By Contract Energy Conservation Adj. (ECA) 0.15 0.15 0.15 0.15 0.15 0.15 0.15 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. (UIA) 0.01 0.01 0.01 0.01 0.01 0.01 0.01 NA NA NA NA NA NA NA NA NA Total Non -Fuel Energy Charge $0.69 $0.69 $0.69 50.69 $0.67 $0.63 $0.59 50.20 50.15 $0.10 $0.20 $0.35 By Contract 50.42 $0.24 By Contract Purchased Gas Adjustment (PGA) 0.79 0.79 0.79 0.79 0.79 0.79 0.79 0.79 0.79 0.79 0.79 0.79 0.70 0.79 0.70 0.70 Total Energy Charge /Therm 1.48 1.48 1.48 1.48 1.46 1.42 1.38 0.99 0.94 0.89 0.99 1.14 0.70 1.21 0.94 0.70 + Non -Fuel + Non -Fuel Minimum Monthly Bill $12.00 $25.00 $40.00 $95.00 $25.00 540.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) (5160.00) (540.00) ($70.00) ($160.00) ($20.00) ($40.00) ($70.00) ($30.00) (530.00) (By Contract) ($75.00) $400.00 Charge + @ premise @ premise @ 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.35 $ 1.35 $ 1.35 $ 1.35 $ 1.34 $ 1.30 $ 1.26 $ 0.91 $ 0.86 $ 0,81 $ 0.91 $ 1.04 $ 0.64 $ 1.11 $ 0.86 with 6.0% Franchise $ 1.44 $ 1.44 $ 1.44 $ 1.44 $ 1.42 $ 1.38 $ 1.34 $ 0.96 $ 0.91 $ 0.86 $ 0.96 $ 1.11 $ 0.68 $ 1.17 $ 0.91 Change from 9/2014 Therm Rate $ (0.27) $ (0.27) $ (0.27) $ (0.27) $ (0.25) $ (0.23) $ (0.21) $ (0.15) $ (0.15) $ (0.15) $ (0.15) $ (0.15) $ (0.15) $ (0.19) $ (0.19) $ (0.15) % Change from 9/2014 Therm Rate -11.9% -11.9% -11.9% -11.9% -11.6% -11.0% -10.3% -8.0% -8.2% -8.4% -8.0% -7.6% -8.4% -8.8% -10.9% -10.3% Utility Tax Note: Fuel Rate per Therm 10/01/1973 50.069 $0.069 $0.069 $0.069 $0.069 $0.069 $0.069 $0.069 $0.069 50.069 $0.069 $0.069 $0.069 $0.069 $0.055 50.069 Non - Utility Taxable Fuel /Therm 50.721 $0.721 50.721 50.721 $0.721 $0.721 50.721 $0.721 $0.721 $0.721 $0.721 $0,721 $0.631 $0.721 50.645 $0.631 BTU FACTOR = THERMS /100 CUBIC FEET (CCF) 10/2016 11/2016 12/2016 01/2017 02/2017 03/2017 04/2017 05/2017 06/2017 07/2017 08/2017 09/2017 Firm Service Rates 1.047 Interruptible Service Rates 1.027 FY 16/17 Avg. 1.047 1.027 CSW:09/20/2016 BTU Factor: BTU Factor: Therm Factor: 2.714 Gallons /100 cubic feet (CCF) 2.483 Therms /100 cubic feet (CCF) 0.915 Therms /Gallon Applicable Annual Galion Range or Other Rate Determinant Monthly Customer Charge Non -Fuel Energy Charges /Gallon: Non -Fuel Energy Charge (NFE) /Gallor Energy Conservation Adj.(ECA) /Gallor Regulatory Imposition Adj.(RIA) /Gallor Usage & Inflation Adj. (UTA) /Gallon 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 MRLP MULTI - FAMILY MMLP NA NA (1 - 3 Units) (4 + Units) $12.00 $25.00 $1.90 $1.90 0.15 0.15 0.09 0.09 0.01 0.01 $2.15 $2.15 1.84. 1.84 $3.99 $3.99 $12.00 $25.00 0.161 $1.679 ($0.18) -4 3% 0.161 $1.679 ($0.18) -4.3% CLEARWATER GAS SYSTEM METERED PROPANE (LP) RATE BILLING FACTORS FOR OCTOBER 1, 2016 - SEPTEMBER 30, 2017 BASED ON APPROVED GAS ADJUSTMENT FACTORS LOOP RESL. LRLP NA $12.00 For Each Meter $0.90 0.15 0.09 0.01 $1.15 1.84 $2.99 $12.00 0.161 $1.679 ($0.18) -5.7% SMALL COML. LARGE COML. MGLP MLLP 0 - 2,500 $25.00 $0.30 0.15 0.09 0.01 $0.55 1.84 $2.39 $25.00 0.161 $1.679 ($0.16) -6.3% >2,501 $40.00 $0.25 0.15 0.09 0.01 $0.50 1.84 $2.34 $40.00 0.161 $1.679 ($0.16) -6.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 Attachment #7 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.84 $2.84 $50.00 0.161 Contract PGA - 0.161 $1.679 NA NA ($0.10) -3.4% Set By Contract NA NA NA Set By Contract 1.54 Contract NFE + $1.540 Customer Charge + Non -Fuel Energy Chg . for the Contracted # of Gallons /Mo. 0.161 Contract PGA - 0.161 NA NA CSW:09/20/2016 BTU Factor: BTU Factor: Therm Factor: 2.714 Gallons /100 cubic feet (CCF) 2.483_ Therms /100 cubic feet (CCF) 0.915 Therms /Gallon STANDARD RESIDENTIAL BULK LP SERVICE (Rate Class is Based on Annual LP Gallon Usage Level) BRLPO BRLP1 BRLP2 BRLP3 BRLP4 CLEARWATER GAS SYSTEM BULK PROPANE (LP) RATE BILLING FACTORS FOR OCTOBER 1, 2016 - SEPTEMBER 30, 2017 BASED ON APPROVED GAS ADJUSTMENT FACTORS RESIDENTIAL "WILL CALL" (Based on Annual Usage Level) WRLPO WRLP1 WRLP2 WRLP3 WRLP4 Applicable Annual Gallon Range 0 (No Fills in Yr.) 0.1 - 60 60.1 - 120 120.1 - 300 > 300 0 (No Fills in Yr.) 0.1 - 60 60.1 - 120 120.1 - 300 > 300 or Other Rate Determinant 1 -3 UNITS 1 -3 UNITS 1 -3 UN!FS 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 5 90.00 $ 75.00 $ 350.00 $ 210.00 $ 150.00 $ 75.00 $ 60.00 Non -Fuel Charges (NF) /Gallon: Nom l vet l nergy Charge (NFE) /Gal. $ 1.80 $ 1.80 $ 160 $ 1.00 $ 0.90 $ 1.80 $ 1.80 $ 1.60 $ 0.90 $ I ncrgy Conservation Adj. (I lCA) /Gal $ 0.15 $ 0.15 $ 0.15 0.15 0.15 0.15 0.15 0.15 0.15 Regulatory Imposition Adj. (121A)/Gal $ 0.09 $ 0.09 $ 0.09 0.09 0.09 0.09 0.09 0.09 0.09 Usage & Inflation Adj. (U1A) /Galion 0.01 0.01 0.01 0.01 0.01 0.01 0.01 0.01 0.01 Total Non -Fuel Charges (NF) /Gal. $ 2.05 $ 2.05 $ 1.85 $ 1.25 $ 1.15 $ 2.05 $ 2.05 $ 1.85 $ 1.15 $ ;'urchased Gas Adj. (PGA) /Gallon $ _ 1.84 $ 1.84 $ 1.84 $ 1.84 $ 1.84 $ 1.84 $ 1.84 $ 1.84 $ 1.84 $ Total Energy Charges /Gallon $ 3.89 $ 3.89 $ 3.69 $ 3.09 $ 2.99 $ 3.89 $ 3.89 $ 3.69 $ 2.99 $ Note. No Monthly Minimum 1511 Utility Tax Note: uel Rate par Gallon 10/01/19/3 Nor ^Jtility- Taxable / uel /Gallon 0.80 0.15 0.09 0.01 COMMERCIAL BULK LP SERVICE (Based on Annual Usage Level) BCLP1 BCLP2 0 -2,500 >2,500 Customers in this Customers in this Range of Usage Range of Usage $ 90.00 $ 90.00 0.25 $ 0.15 0.09 0.01 0.20 0.15 0.09 0.01 BULK STANDBY/ GENERATOR LPSB (Closed for New Residental Applications) 420,00 1,00 NA NA NA 1.05 1.84 2.89 0.50 $ 1.84 $ 2.34 $ 0.45 1.84 $ $ 1.00 1.84 2.29 $ 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.6'/9 $ 1.6/9 $ 1.679 $ 1.679 $ 1.679 $ 1.679 $ 1.679 $ 1.679 $ 1.679 $ 1.679 $ 1.679 $ 1.679 $ Change from 9/2014 Gallon Rate $ (0.180) S (0,180) $ (0.180) $ (0.18) $ (0.18) $ 0.02 $ 0.02 $ (0.18) $ (0.18) $ (0.28) $ (0.16) $ (0.16) $ % Change from 9/2014 Gallon Rate -4.4% -4.4% -4.7% -5.5% -5.7% 0.5% 0.5% -4.7% -5.7% -8.8% -6.4% -6.5% 2.84 Attachment #7 Page 2 of 2 CONTRACT BULK LP SERVICE CLP Any Contract Customers Who Requests Bulk Del. Set by contract Set By Contract NA NA NA Set By Contract 1.54 Cotract NFE + 1.540 0,161 $ 0.161 1.679 Contract PGA - 0.161 (0.10) -3.4% NA NA CSW09/20/2016 Residential Rate History By Components Clearwater Gas System Attachment #8 Page 1 of 3 Total Rate Adiustments/Therm Contract LP Month NG/therm LP/qallon * ECA1 RIA# WNA/U1A-Resl# UIA-Coml# . PGA PGA PGA/qallon Oct-16 $ 1.48 $ 3.09 $ 0.15 1 $ 0.09 $ 0.01 $ 0.01 $ 0.79 $ 0.70 $ 1.84 Nov-16 — 1 ' Dec-16 ---- Jen-:17-1 - ---t- Feb-171 f Mar-17 -i I -I1 _I 1- - _ Apr-17 -t May-17 1 4 -f Jun-17 Jul-17 Aug-17 Sep-17 FY 16/17 Avg. 1 $ 1.480 $ 3.090 1 $ 0.150 $ 0.090 $ 0.010 1 $ 0.010 $ 0.790 $ 0.700 1 $ 1.840 -4 2016 Avg. i -1 Incr. Above $ (0.111. $ 0.20 $ (0.01) $ (0.014 $ (0•01)f $ (0.09) $ (0.09) $ 0.22 Last Year 1 Same Month , -7%T 7% -6% -10% 0% -50%t -10% -11% 14% t + , i 1 Incr. Based „.$ (2.20) $ 4.37 on 20 Therms 1 -7% 8% Equivalent 1 1 Cents/KWH 5.1 11.5 for Gas vs. Duke Rate 12.3 ▪ 12.3 Note: Duke Energy Florida's residential rate for usage >1,000 KWH in August 2016 is 12.334 cents/KWH (Residential) 7— I Gas Cheaper by Notes: i _I " Based on Bulk LP (BRLI53) which is applicable ▪ for customers using 120.1 - 300 gallons/year & equal to Residential LP Will Call (BRWCLP). I-- -- # New rates implemented 11/1/2014, with following changes: i 1 1 [ I I I-- RS NG Customer Charge increased $2 from $10 to $12/month 8,NFE rate droped 4 cents to 44 cents/therm. UlA decreased by 9 cents/therm to 0. BRLP3 LP Customer Charge unchanged @ $90/year, and NFE rate unchanged @ $1.00/gallon. UlA decreased by 9 cents/gallon to 0. 1- RIA & EGA unchanged initially. 1 ■ 111 1 1I 1 7 CSW:08/29/201 6 Attachment #6 Page 2of3 Competitive History of NG vs. Electric Rates Month -Year NG Therm Cost 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 $ 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 $ S 1.75 $ $ 1.57 $ $ 1.38 $ $ Increase over Last 15 Years $ 0.04 $ % Increase over Last 15 Years 3.0% Avg. Annual Inc. Over Last 15 Yrs. 0.2% 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 Progress Energy KWH Cost $ 0.084 $ 0.074 $ 0.084 $ 0.089 $ 0.097 S 0.119 $ 0.120 $ 0.120 $ 0.132 $ 0.136 $ 0.129 $ 0.132 $ 0.123 $ 0.123 $ 0.123 $ 0.123 0.001 $ 3.0% 0.2% 0.039 46.8% 3.1% NG vs. Electric - 46% - 37% -37% -35% - 31% - 46% - 47% -40% -64% -65% -62% - 62% - 62% - 62% -62% - 62% CSW:08/29/201 6 - -- -- ----F - , 1 1 -t- - - , 1 r 1 1 _1 1 • 1 - Attachment #8 - - - ------ --- -- 1 Page 3 of - - 3 , - - --. Annual Average CGS Residential Rates 1 , T 1 Calender Year Fiscal Year Year NG/Therm LP /Gallon * Year NG/Therm LP/Gallon * 1995 NA 1 NA FY 95/96 $ 0.880 $ 1.199 * 1996 S 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 $ 2.162 4 2005 $ 1.925 $ 2.278 1FY 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 t 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 $ 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 - $ 1.500 Average $ 2.339 $ 1.485 $ 2.324 4 - Notes: T T . * 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 I 120.1 - 300 gallons/year & is equal to Residential LP Will Call Clearwater Gas System Ave Greener �w'th Fuel Use and Cost Comparison (Effective Rates for October 2016) Want to make the switch to natural gas? Call Clearwater Gas System, today at (727) 562 -4980. APPLIANCE COOKING WATER HEATING ANNUAL THERMS USED 45 NATURAL GAS I PROPANE (LP) GAS I ELECTRIC $ 66.60 J $152.10 $162.45 -Gas Tank Style/Gas Tankless vs. Electric Tank Style HEATING 170 / 100 $251.60 / $148.00* $574.60/$338.00* ! $613.70 CLOTHES DRYING TOTAL APPLIANCE USAGE — with tank/tankless 150 $222.00 50 I $ 74.00 ( $614.20/ 5510.60* GAS SAVINGS VS. ELECTRICITY $507.00 j $541.50 $169.00 $180.50 $1,402.70/ $1,498.15 51166.10* 59% 1 66 %* 6%123%* OUTDOOR RECREATION: *when using tankless j *when using tankless- LP POOL HEATING* i 375 $555.00 S1,353.75 SPA/HOT TUB HEAT* 175 $259.00 $ 591.50 *varies according to pool size, weather conditions, and temperature maintained All other figures are annual average projections based upon the following: 1. 1 therm = 100,000 BTUs of energy 2. Natural Gas S1.48 per therm 3. LP Gas per gallon (BRLP3) S3.09 per gallon or 4. Duke Energy per KWH ! S0.12334 Per KWH or (Based on >1000 KWH rate) 3.38 per therm 53.61 per therm S 631.75 1. Notes: The above analysis is based on October 2016 residential energy and fuel charges and does not include applicable taxes or franchise fees. 2. Current monthly customer charges are: Duke Energy $8.76, Peoples Gas $12.00- S20.00 (varies by rate class), Clearwater Gas System S12.00 and S20.00 in Central Pasco. L.P. customers are billed annually, S75 -$210 (non - refundable) depending on program. 711 Maple Street • Clearwater, FL 33755 • (727) 562 -4980 www.clearwatergas.com