Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
GAS ADJUSTMENTS EFFECTIVE APRIL 1, 2016
CLEARWATER GAS SYSTEM Interoffice Correspondence Sheet TO: William B. Home II, City Manager FROM: Chuck Warrington, Managing Director COPIES: Rosemarie Call, City Clerk; 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 SUBJECT: GAS ADJUSTMENTS EFFECTIVE APRIL 1, 2016 DATE: March 17, 2016 Gas supply prices have fallen somewhat over the past few months; therefore, we are recommending a decrease of 150 per therm in our Natural Gas Purchase Gas Adjustment (PGA) and a decrease of 12¢ per gallon in our Propane (LP) PGA for April. We recommend that we continue our standard Contract LP PGA be set at 30¢ below our Standard LP PGA. We are recommending a 2¢ per therm or gallon increase in our Energy Conservation Adjustment (ECA). We are recommending no change in our Regulatory Imposition Adjustment (RIA) nor our Usage & Inflation Adjustment (UTA) for April. The net effect of these recommended changes for April is a 13¢ per therm ( -8.4 %) reduction in our typical Residential Natural Gas customer's rate and a 100 per gallon reduction ( -3.6 %) in our typical Residential LP customer's rate. Therefore, we are recommending your approval of the following rates to become effective for billings rendered on and after April 1, 2016: eftv) Natural Gas Finn 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 50.70 per therm (down 15¢ per therm) 50.61 per therm (down 15¢ per therm) S 1.40 per gallon (down 12¢ per gallon) $1.10 per gallon (down 12¢ per gallon) S0.16 per therm or gallon (up 2¢) ....... S0.10 per therm or gallon (no change) . S0.01 per therm or gallon (no change) 50.01 per therm or gallon (no change) William B. Horne 1I, City Manager March 17, 2016 Page 2 Attachment #1 shows the status of our Adjustment Recovery Clause balances with actuals thru February. Our objective is to be as close as practical to balance by FY ending. Attachments #2 and #3 show our annual projections for Natural Gas and LP supply costs, respectively. Attachments #4 and #5 show the impact of these adjustment clause changes on our overall Natural and LP Gas rates, respectively. Attachment #6, Page #1 shows our monthly rate history over the past 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 14 years, our residential natural gas rates have risen just 17.2% as compared to a 58.8% increase for the Duke Energy (formerly Progress Energy Florida/FPC) residential rates. That's an average annual increase of 1.2% /year for natural gas vs. 4.2% /year for electric - -- our natural gas rates increased only 29% 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 62% lower than electric for Natural Gas and 21% lower than electric for our typical LP Residential rates. This is a very attractive competitive position vs. electric rates for our Natural Gas customers and these numbers are even lower if the customer uses a 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 $0.98 /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. We had previously been applying only a 20¢ /gge credit from past credits, so we are now able to pass along an additional 300/gge credit. Bill, I would appreciate your approval of these revised adjustment rates so we can get this information to liCS in order to make the appropriate adjustments in the billing formulas in time for the April 1' billings. If you have any questions on this, please call me. CSW /csw Attachments Approved: William B. Home II, City Manager U: \My Documents \MSOFFICE \WINWORD \GASRATES \Gas Adjustments for April 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) I NG PGA Rate /Then /Con1 Monthly Cumulative Budget Reservation • Commodity Interest Cost Center Total NG Fuel Total NG PGA Overage YTD Overage Month . Charges Prior Year' 1 Charges Expense Expenses Expenses Billed (Shortage) (Shortage) Firm 0.88/0.79 0.88/0.79 0.88/0.79 0.88/0.79 0.85/0.76 0.85/0.76 0.70/0.61 0.70/0.61 0.70/0.61 - $ (27,300.76) $ (4,272,228.33) $ (3,854,739.20) $ (3,180,485.61) $ (2,319,749.43) $ (1,454,194.20) Oct -15 $ 4,258,968.39 1,394,849.81 $ 136.50 $ 21,361.14 $ 30,980.02 $ 38,824.42 1 $ 5,684,934.72 $ 828,303.87 $ 1,440,007.15 1,245,793.01 $ (4,244,927.57) $ 417,489.14 Nov -15 ! $ 143,902.27 ' Dec -15 $ 164,606.17 ` 624,216.04 636,906.60 $ 19,273.70 $ 38,408.72 $ 859,195.19 1,533,448.77 $ 674,253.58 Jan -16 ! $ 159,338.19: 669,592.22 $ 15,902.43 $ 38,899.07 $ 883,731.91 1,744,468.09 $ 860,736.18 Feb -16 '' $ 168,766.72 775,681.55 $ 11,598.75 $ 42,584.88 $ 998,631.90 1,864,187.13 $ 865,555.23 Mar -16 ! $ 200,000.00 ~ 700,000.00 $ 7,270.97 $ 45,000.00 2 $ 952,270.97 1,842,112.63 $ 889,841.66 $ (564,352.54) $ (30,969.99) Apr -16 ; $ 145,000.00 625,000.00 $ 2,821.76 $ 45,000.00 $ 817,821.76 1,351,204.31 $ 533,382.55 M -16 $ 100,000.00 600,000.00 $ - $ 45,000.00 $ 745,000.00 1,222,225.72 $ 477,225.72 $ 446,255.73 Jun -16 1 $ 95,000.00 550,000.00 $ - $ 45,000.00 $ 690,000.00 1,142,381.83 $ 452,381.83 $ 898,637.56 Jul JT 95,000.00 550,000.00 550,000.00 $ - $ - $ 45,000.00 $ 45,000.00 $ 690,000.00 $ 690,000.00 1,111,672.64 1,093,247.12 $ 421,672.64 $ 403,247.12 $ 1,320,310.19, 0.70/0.61 0.70/0.6.1 -16 Aug -16 1 $ 95,000.00 $ 1,723,557.32_47 $ 2,126,804.44 Sep -16 ' $ 95,000.00 550,000.00 $ - $ 45,000.00 $ 690,000.00 1,093,247.12 $ 403,247.12 i - $ 1,138,461.44 4 -7 $ 1,138,461.44 - $ (1,138,461.44) $ 1,015,643.77 $ 988,343.01.- $ 5,720,581.74 $ 8,226,246.22 $ 78,365.25 $ 1,643,158.55 $ 15,668,351.76 $ 16,683,995.52 ,1 oterYTD (1)Includes Annual Admin Charge of $713,080 + CCS chg of $1,225,960 + Dividend $2 203,550 ) i+ FY 14/15 PGA write off of $11,582.91 + WNA $313.27 = $ 4,154,486.18 (5) (6) Pension Adjustment = Accrual = $ - $ - 2 Additional Dividend based on FY 15/16 Net Income = $ - (3) Bulk mailing 8_ printing $ - 3 (7) Commodity adjustment from FYE transfer of ECA Collected in PGA @ Annual ECA Shortfall i $ 1,138,46' I LP PGA T herm /Ga 1.77/1.62 1 77/1.62 (4). OPEB liability & Period Net RC = $ 1,566,095.56: PROPANE (LP) GAS PURCHASED 13 Adjustment $ - NG Proportion = 98.5% x Total ECA Transfer = $0.342 $0.352 Cumulative YTD Overage (Shortage) $ 33 525.60 $ (139 525.60) S (11n 447 141 Average Annual PGA/Therm = ' $0.694 Avg Fuel Only = Delta/Therm = _�_ GAS ADJUSTMENT (PGA -LP) 1 -- - - - - -- -Th Budget Gallons TVlonthiy Overage (Shortage) Monthly Interest Commodity ( T Total LP Fuel I Expenses Total LP PGA Billed Month Sold WACOG +_ Expense Charges Prior 1 ', $ 273,746.55 17 anR 9n Oct-15 38 021.1 $ 0.66815 ' $ - $ 25,403.80 G nn7 .o $ 60,945.08 $ (212,801.47) nn RRQ RA G 99 r17R 4A Nov -15 Dec -15 Jan -16 Feb -16 Mar -16 Apr -16 May -16 Jun -16 25,500.01 $ Jul -16 25,500.0 $ Aug -16 25,500.0 $ Sep -16 25,500.0 ! $ P13 Total YTD 371,282.2 $ LO, IOO.J ,P 28,115.6 $ 34,825.9 $ 45,153.3 $ 41,000.0; $ 31,000.0 $ 26,000.0 $ Cost Center Expenses CCS Chg, Admin & Dividend FY 14/15 Write off PGA & WNA Fuel :Donations to events LP Yard Vaporization /loss due to malfunctioning 'LP PGA Event fuel cost ,Suburban Software Systems Depreciation of LP tanks ;Suburban Software Systems license !Contribution to garage LP trk up grade LP Holding Tank Restoration .44 11.O /IOJ J u� /.VJ iv,aV, .-ry ,r,vvv•,.. � ........ ...... - -,- - _ - - - -- , 0.65512 $ 582.24 18,419.09 19,001.331 45,188.55 $ 26,187.22 ' $ (90,259.92):, 0.62029 . $ 451.30 21,602.16 ! 22,053.46 56,143.17 $ 34,089.71 $ (56,170.21).. 0.62107 $ 280.85 28,043.36 28,324.21 68,759.92 $ 40,435.71 $ (15,734.50) 0.64000 $ 78.67 26,240.00 i i 26,318.67 61,255.77 $ 34,937.10 $ 19,202.61 0.64000, $ - 19,840.00 19,840.00 42,658.87 $ 22,818.87 $ 42,021.47 0.65000 $ 16,900.00 16,900.00 35,778.41 $ 18,878.41 $ 60,899.88 i 1.53/1.40 0.65000 , $ 16,575.00 16,575.00 , 35,090.36 $ 18,515.36 $ 79,415.24 i 1.53/1.40 0.68000 $ 17,340.00 17,340.00 35,090.36 $ 17,750.36 $ 97,165.60 1.53/1.40 0.71000 1 $ 18,105.00 18,105.00 35,090.36 $ 16,985.36 $ 114,150.95 ' 1.53/1.40 0.73000 i $ 18,615.00 18,615.00 35,090.36 $ 16,475.36 $ 130,626.31 t 1.53/1.40 • 4 93,994.23 - $ (93,994.23) $ 36,632.09 0.65716 ! $ 2,090.69 $ 243,990.88 $ 588,418.55 $ 551,774.76 $ (36,643.78) ■ r $ 182,710.00 i 1 $ 571.71 1 $ 15,000.00 1 , $ 8,324.69 1 meter $ 460.83 i 1 _ (4) Adjustment from FYE transfer of ECA in PGA @ Annual ECA Shortfall $ 1,076.29 1 LP Proportion = 1.5% x Total ECA Transfer = $ 17,336.98 $ 5,785.00 1 34,414.23 1 - 1 - ' 1 - Projected for FY Proj. Remaining I $ 248,342.75 I $ 325,000.00 i $ 76,657.25 1.77/1.62 1.77/1.62 1.66/ 1.52 1.66/1 52 1.53/1.40 CLEARWATER GAS SYSTEM SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTIONS FOR FY 2015/2016 Attachment #1 Page 2 of 4 ECA 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.16/0.16 0.16/0.16 0.16/0.16 0.16/0.16 ENERGY CONSERVATION ADJUSTMENT (ECA) T Monthly Cumulative Budget , Cost Center Interest Total ECA Expenses Total ECA Overage 1 YTD Overage Billed (Shortage) (Shortage) - I J $ (62,399.01) Month' Expenses ' Notes /Exceptional Items Expense NGV Station Prior Year: ' Oct -15 $ 1,302,486.96 I'romo$116,717,Adv$1,807, Employ Costs$91,167.45 $ 312.00 $ 67,449.06 1 $ 1,370,248.02 $ 186,093.87 4$ (1,184,154.15) } $ (1,246,553.16) Nov -15 , $ 99,380.25 !Promo$33, 351 ,Adv$1,505, Employ Costs$64,524 $ 6,232.77 $ 55,608.05 1 161,221.07 152,067.98 i $ (9,153.09) $ (1,255,706.24)1 Dec -15 $ 164,554.68 (Promo$ 106, 954 ,Adv$2,784, Employ Costs$54,817 $ 6,278.53 $ 67,221.04 238,054.25 192,830.70 I $ (45,223.55) $ (1,300,929.79)1 $ (1,346,024.18)1 $ (1,336,661.74) Jan -16 ' $ 208,713.96 1Promo$144,310,Adv$3,025, EmployCosts$61,379 $ 6,504.65 $ 57,196.21 $ 35,613.47 272,414.82 222,200.64 227,320.43 231,563.08 i $ (45,094.39) $ 9,362.44 Feb -16 $ 179,857.05 ( Promo$ 107, 865 ,Adv$3,420, Employ Costs$68,572 ; $ 6,730.12 Mar -16 $ 1,100,000.00 ; ■ $ 6,683.31 $ 60,000.00 2 1,166,683.31 210,798.45 $ (955,884.86) $ (2,292,546.61)', Apr -16. $ 150,000.00 ' $ 11,462.73 $ 60,000.00 221,462.73 214,048.51 $ (7,414.22) $ (2,299,960.83) $ (2,328,039.84)j $ (2,368,779.78)' $ (2,414,520.57)1 $ (2,463,368.35); May -16 ! $ 150,000.00 $ 11,499.80 $ 60,000.00 221,499.80 193,420.80 $ (28,079.01) Jun -16 $ 150,000.00 $ 11,640.20 $ 60,000.00 221,640.20 180,900.25 $ (40,739.95) Jul -16 1 $ 150,000.00 ! $ 11,843.90 $ 60,000.00 3y 221,843.90 176,103.11 I $ (45,740.79) Aug -16 $ 150,000.00 $ 12,072.60 $ 60,000.00 222,072.60 173,224.82 ' $ (48,847.78) Sep -16 i $ 150,000.00 $ 12,316.84 $ $ 103,577.45 $ 60,000.00 $ (300,000.00) $ 403,087.83 222,316.84 4 -8 (300,000.00) $ 4,461,658.18 173,224.82 $ (49,092.02) 855,798.41 ( $ 1,155,798.41 $ 3,167,395.24 I $ (1,294,262.94) $ (2,512,460.37)' $ (1,356,661.95): 0.16/0.16 - _ Total YTD', $ 3,954,992.90! , 1 Charge of $46,740 + CCS chg of $65,140 () 8 Transfer of ECA Collected in PGA u ECA Collected for (up to ECA O Annual Shortfall NG /Therm I LP /Gal. 0.10/0.10 0.10/0.10 $228,510 + FY 14/15 Write off of $2, 05.51 = $ 342,795.51 +nDivldend $228 5 ,15r be transferred = $ 1,155,798.41 Note: Maximum amount which cane e ran (1) SNEP Transfer = I $ 750,000.00 I , (2) IAddl Dividend (OK) + TECO Pay (329.8K) + Asturia (600K)= $ 929,800.00 (3)Additional SNEP Transfer = $ - - (4)!rPension Adjustment NGV = $ - (5)' NGV O &M $50,000 +PGA Recvy non -CGS $250,000 = $ (300,000.00) (6)' Adjustment $ - ,= (7). ECA Accrual ' $ Net ECA CCE _ $ 1,932,397.39 Net NGV CCE = $ 703,087.83; REGULATORY IMPOSITION ADJUSTMENT (RIA) (EIA) (ORA) Regulatory Interest Total RIA Total RIA Budget Environmental i Overage YTD Overage (Shortage) (Shortage) Month ' Expenses ;Notes /Exceptional Items Expenses Expense Expenses Billed Prior Year' 1 $ - I $ (299,118.53)! $ (413,229.12)!! r $ (374,643.81)' Oct -15 $ 190,920.14 38,007.93 $ 1,495.59 1,2 $ 230,423.66 116,313.07 $ (114,110.59) Nov -15 1 $ 723.33 53,701.23 $ 2,066.15 56,490.71 95,076.02 $ 38,585.31 Dec-15 $ 723.33 I 122,262.34 $ 1,873.22 124,858.89 120,061.30 $ (4,797.59) $ (379,441.40), $ (270,833.34)- 0.10/0.10 Jan -16 $ 723.33 I 30,763.25 $ 1,897.21 33,383.79 141,991.84 $ 108,608.05 0.10/0.10 Feb -16 $ 423.33 ; 138,190.79 $ 1,354.17 139,968.29 165,301.33 $ 25,333.04 $ (245,500.30) 0.10/0.10 Mar -16 ; $ 60,000.00 1 (710,000.00) 100,000.00 $ - $ - $ - 2 3 I (650,000.00) (700,000.00) 110,000.00 128,830.12 114,464.36 103,433.50 $ 778,830.12 $ 814,464.36 $ (6,566.50) $ 533,329.82 $ 1,347,794.18 $ 1,341,227.68 0.10/0.10 0.10/0.10 0.10/0.10 Apr -16 $ (800,000.00);_ 00,000.00) May -16 $ 10,000.00 , 100,000.00 Jun -16 $ 10,000.001 100,000.00 $ - 110,000.00 96,738.03 $ (13,261.97) $ 1,327,965.71 0.10/0.10 Jul -16 $ 10,000.00 , 100,000.00 $ - 110,000.00 94,172.72 $ (15,827.28) $ 1,312,138.43 0.10/0.10 Aug -16 $ 10,000.00 I 100,000.00 $ - 110,000.00 92,633.53 $ (17,366.47) $ 1,294,771.96 0.10/0.10 S ep -16 $ 10,000.00 + 100,000.00 $ - 110,000.00 I 92,633.53 $ (17,366.47) $ 1,277,405.48 0.10/0.10 P13 $ 50,000.00( 4,5 50,000.00 - $ (50,000.00) $ 1,227,405.48 Total YTD( $ (446,486.54); $ 272,925.54 $ 8,686.33 (164,874.67) 1,361,649.35 $ 1,526,524.01 (1),Inciudes annual charges for Admin Charge $12,170 $ 190,196.81 (5) Accrual $ - 1+ FY 14/15 Write off of $1,986.81 + Dividend $176,040 = (2) Additional Dividend $ 50,000.00 Net EIA = $ (736,683.35) _ (3)!Credit from Council allocation from Added Dividend $ (810,000.00) Net ORA = $ 1,082,925.54 (4)rCIP closed to Operating $ 50,000.00 - CLEARWATER GAS SYSTEM SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTIONS FOR FY 2015/2016 Attachment #1 Page 3 of 4 USAGE AND INFLATION ADJUSTMENT (UTA) Commercial NG Therms Rate /Therm Monthly Overage (Shortage) Cumulative YTD Overage (Shortage) WA ' NG /Therm LP /Gal 0.02/0.02 Budget ! Interest Month ! LP Gallons Expense Rate /Gallon Beg. Bal. 0.02 $ - $ 17,773.24 $ (125,739.87) $ (107,966.63)' Oct -15 ' 8,794.5 $ 628.70 0.02 914,466.2 Nov -15 . 5,503.7 $ 539.83 0.02 723,384.7 0.02 0.02 0.01 $ 14,032.19 $ 17,497.21 $ 9,954.93 $ (93,934.44) $ (76,437.23) $ (66,482.30) $ (55,571.90) $ (44,774.76) 0.02/0.02 0.02/0.02 0.01/0.01 0.01/0.01 0.01/0.01 Dec -15 i 7,245.0 $ 469.67 0.02 1 949,118.3 1,046,106.1 Jan -16 i 6,932.1 $ 382.19 0.01 Feb -16 • 8,413.5 $ 332.41 0.01 0.01 1,117,295.3 1,100,000.0 ' 0.01 0.01 $ 10,910.40 $ 10,797.14 Mar -16 1 7,500.0 $ 277.86 Apr -16 I- 7,500.0 $ 223.87 0.01 1,100,000.0 0.01 $ 10,851.13 $ (33,923.63) 0.01/0.01 0.01/0.01 May -16 7,200.0 $ 169.62 0.01 L 950,000.0 0.01 $ 9,402.38 $ (24,521.25)1 Jun -16 6,500.0 $ 122.61 0.01 825,000.0 0.01 $ 8,192.39 $ (16,328.86) $ (8,095.50) $ 179.02 0.01/0.01 0.01/0.01 0.01/0.01 Jul -16 6,500.0 $ 81.64 0.01 825,000.0 0.01 $ 8,233.36 Aug -16^ 6,500.0 ' $ 40.48 I 0.01 825,000.0 0.01 $ 8,274.52 Sep -16 ! 6,500.0 $ 0.01 1 825,000.0 0.01 $ 8,315.00 $ 8,494.02 0.01/0.01 • WA NG /Therm LP /Gal 0 01/0.01 0.01/0.01 0.01/0.01 Per 13 $ - $ 8,494.02 Total YTD ' 85,088.8 3,268.88 11,200,370.6 $ 134,233.89 (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. 1 • Cumulative YTD Overage t (Shortage) $ (20,750.81) $ (20,750.12)1 $ (16,303.45)1 $ (13,358.30)1 USAGE AND INFLATION ADJUSTMENT (UTA1 1 ' Residential Budget - Beg. 9 Monthly ; Overage ! (Shortage) $ 2,323.69 Interest 1 Rate/Therm 0.01 I - L Expense Rate /Gallon NG Th 214s01g 9 $ .75 0.01 Nov -15 Dec -15 Jan -16 - ----- Feb -16 Mar -16 Apr -16 May -16 Jun -16 Jul -16 Aug -16 Se -16 Se p-16 p Per 13 29,023.6 19,632.8 $ 92.14 0.01 202,519.0 0.01 i $ 2,123.67 20,840.8 $ 81.52 0.01 281,496.3 _ _ 0.01 , $ 2,945.15 1 27,869.5 - - - - -- 36,710.0 $ 66.79 0.01 ; 351,334.8 0.01 I $ 3,731.58 $ (9,626.72)4 $ (4,384.44)t $ 443.64 $ 3,693.64 $ 6,393.64 0.01/0.01_ 0.01/0.01 0.01/0.01 0.01/0.01 0.01/0.01 0.01/0.01 0.01/0.01 0.01/0.01 0.01/0.01 $ 48.13 $ 21.92 -1 0.01 491,635.9 0.01 $ 5,242.28 35,000.0 0.01 0.01 450,000.0 0.01 0.01 $ 4,828.08 $ 3,250.00 25,000.0 20,000.0 $ - 300,000.0 $ - 0.01 ! 250,000.0 0.01 $ 2,700.00 20,000.0 15,000.0 ' 15,000.0 ! $ - $ - 0.01 200,000.0. 0.01 , $ 2,200.00 $ 8,593.64 $ 10,743.64 $ 12,893.64 0.01 200,000.0 0.01 1 $ 2,150.00 $ - 0.01 200,000.0 0.01 $ 2,150.00 15,000A • $ 0.01 ' 200,000.0 0.01 $ 2,150.00 t $ 15,043.64 ' $ $ 15,043.64 Total YTD 279,076.7 • 414.25 3,341,004.9 • • $ 35,794.45 • 1- 1 (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. , I I 1 ■ T CLEARWATER GAS SYSTEM SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTIONS FOR FY 2015/2016 Attachment #1 Page 4 of 4 TOTAL ALL COST RECOVERY ADJUSTMENT CLAUSES (Both PGAs + ECA + RIA + UTA 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 r Monthly + Cumulative Total Res' Total All Total Recovery Overage YTD Overage NG /Thm (Firm) Expenses Billed (Shortage) (Shortage) LP /Gal 1 - - $ - $ (462,033.11), $ 7,559,352.95 $ 1,823,456.10 $ (5,735,896.85)1$ (6,197,929.96) 1.15/1.89 j 1,063,620.75 $ 1,549,776.43 $ 486,155.691 $ (5,711,774.28). 1.15/1.89 1,241,109.65 $ 1,911,971.68 $ 670,862.03 $ (5,040,912.25) 1.15/1.89 1,211,583.97 $ 2,183,610.04 $ 972,026.07 $ (4,068,886.18); 1.15/1.89 1,389,125.04 $ 2,345,964.14 $ 956,839.10 $ (3,112,047.07) 1.10/1.77 1 1,495,272.95 $ 2,258,622.19 $ 763,349.24 $ (2,348,697.83)', 1.10/1.77 359,124.50 $ 1,736,477.17 $ 1,377,352.68 $ (971,345.16) 0.97/1.67 1,093,399.80 $ 1,566,960.80 $ 473,561.00 $ (497,78410 0.97/1.67 f 1,038,215.20 $ 1,465,502.86 $ 427,287.66 $ (70,49649) 097/1.67 1,039,183.90 $ 1,427,422.18 $ 388,238.28 $ 317,741.79 0.97/1.67 1,040,177.60 $ 1,404,620.36 $ 364,442.75 $ 682,184.54 j 0.97/1.67 $ 1,404,660.84 $ 363,728.99 $ 1,045,913.54:. 0.97/1.67 982,455.66 $ 855,798.41 $ (126,657.25) $ 919,256.29 20,553,553.81 I 21,934,843.21 $ 1,381,289.40 Last Updated 03/16/2016 R E S E R V A T 0 N Oct -15 Nov -15 Dec -15 Jan -16 Feb -16 Mar -16 Apr -16 May -16 Jun -16 Jul -16 Aug -16 Sep -16 !Mal C 0 Oct -15 M Nov -15 Dec -15 M Jan -16 Feb -16 Mar -16 D Apr -16 May -16 Jun -16 T Jul -16 Aug -16 Sep -16 Iota A trh udixtN r ' 2_ CGS Natural Gas Summary Monthly Actual /Projections (FY16) /olumo FTS -1 $0.5518 Cost FTS $0.6518 Volume -2 Cost No- Notice 90.0478 Volume Cost Capacity Relinquishment Volume Rate Cost Reservation TOTAL RESERVATION COST Total Rate 170,438 $ 80,003.60 41,788 $ 30,024.68 15,500 $ 602.95 (31,636) $ 0.1987 $ (6,285.10) ,Adustments $136.08 $ 104,482.21 $0.5328 308,570 $ 143,903.96 53,430 $ 38,389.46 22,500 $ 875.25 (172,803) $ 0.2299 $ (39,721.85) $455.45 $ 143,902.27 50.6862 316,789 $ 148,700.76 55,211 $ 39,669.10 31,000 $ 1,205.90 (171,743) $ 0.1487 $ (25.538.75) $589.16 $ 164,606.17 $0.7118 316,789 $ 148,700.76 55,211 $ 39,869.10 46,500 $ 1,808.85 (118,795) $ 0.2679 $ (31,294.89) $454.37 $ 159,338.19 $0.5281 296,351 $ 163,526.48 51,649 $ 33,684.82 42,000 $ 2,079.30 (113,521) $ 0.2714 $ (30,814.61) $310.73 $ 168,766.72 $0.6104 316,789 $ 174,804.17 55,211 $ 35,988.53 31,000 $ 1,481.80 (80,000) $ 0.1500 $ (12,000.00) $0.00 $ 200,272.50 $0.6200 216,570 $ 119,503.33 53,430 $ 34,825.67 22,500 $ 1,075.50 (80,000) $ 0.1500 $ (12,000.00) $0.00 $ 143,404.50 $0.6748 144,212 $ 79576.18 41,788 S 27,237.42 12,400 $ 592.72 (80,000) $ 0.1500 $ (12,000.00) 00.00 $ 95,406.32 90.8056 139,560 $ 77,009.21 40,440 $ 26,358.79 10,500 $ 501.90 (80,000) $ 0.1500 $ (12,000.00) $0.00 $ 91,869.90 $0.8314 144,212 $ 79,576.18 41,788 $ 27,237.42 10,850 $ 518.63 (80,000) $ 0.1500 $ (12,000.00) $0.00 $ 95,332.23 50.8159 144,212 $ 79,576.18 41,768 $ 27,237.42 10,850 $ 518.63 (80,000) $ 0.1500 $ (12,000.00) $0.00 $ 95,332.23 $0.8159 13960 $ 77.009.21 40,440 $ 26,358.79 10,500 $ 501.90 (80,000) $ 0.1500 $ (12,000.00) $0.00 $ 91,869.90 $0.8314 ?,652,052 $ 1,371,890.02 572,174 $ 388,659.20 266,100 $ 11,763.33 (1,166,498) 0217,855.20) $1,925.79 $1,554,583.14 50.6690 .51 FTS -1 (Usage) Volume Rate Cost 138,609 $ 0.0463 $ 6,417.61 132,420 $ 0.0463 $ 6,131.03 144,039 $ 0.0463 $ 8,668.99 198,939 $ 0.0463 $ 9,210.88 181,451 $ 0.0363 $ 6,586.68 154,789 $ 0.0156 $ 2,414.71 134,570 $ 0.0156 $ 2,099.29 130,212 $ 0.0156 $ 2,124.91 126,560 $ 0.0156 $ 1,9/4.34 125,212 $ 0.0156 $ 1,953.31 125,212 5 0.0156 $ 1,953.31 126560 $ 0.0156 $ 1974.34 1,724 573 5 49,509.38 0.6758 $0.0442 FTS -2 (Usage) Volume Rate Cost 41,786 $ 0.0281 $ 1,174.24 53,430 $ 0.0281 $ 1,501.38 55,211 $ 0.0281 $ 1,551.43 55,211 $ 0.0281 $ 1,551.43 51,649 $ 0.0363 $ 1,874.86 55,211 $ 0.0156 $ 861.29 53,430 $ 0.0156 $ 833.51 41,788 $ 0.0156 $ 651.89 40,440 $ 0.0156 $ 630.86 41,788 $ 0.0156 $ 651.89 41,788 $ 0.0156 $ 651.89 40,440 $ 0.0156 S 630.86 Gas Supply (FGU & Peoples) Volume Rate Cost 185,134 $ 3.4099 $ 631,280.20 186,309 $ 3.0376 $ 565,928.23 201,188 $ 2.9368 $ 590,837.74 255,469 $ 3.0489 $ 778,910.58 241,917 $ 2.9044 $ 702,632.08 214,500 $ 2.8725 $ 816,151.00 192,000 $ 2.9304 $ 562,630.00 181,000 $ 2.9760 $ 538,651.00 169,500 $ 2.9919 $ 507,130.00 169,500 $ 3.0798 $ 522,031.00 169,500 $ 2.9597 $ 501,664.00 170 000_J 2.9531 $ 502,020.00 Fuel 3.33% 3.33% 3.33% 3.33% 3.33% 3.33% 3.50% 3.50;0 3.50% 3.50% 3.50% 3.50% FOU No Notice Ci t Management fee Usage Payment 50.075 50.020 $ 13,023.00 $ - $ 3,607.94 $ 15,704.00 $ - $ 3,717.00 S 16,854.00 $ - $ 3,985.00 $ 17,620.00 $ - $ 5,083.00 $ 16,471.00 $ - $ 4,662.00 S 15,750.00 $ $ 4,200.00 $ 14,100.00 $ - 5 3,760,00 5 13,350.00 $ - $ 3,560.00 S 12,525.00 $ - $ 3.340.00 S 12,525.00 $ - $ 3.340.00 $ 12,525.00 $ - $ 3.340.00 $ 12,525.00 $ - $ 3.340.00 572,174 $ 12,565.55 2,336016:.'.. $ 7,019,865,83 $172,972.00 $0.00 545,93494 Oct -15 Nov -15 Doc-15 Jan -16 Feb -16 Mar -16 Apr -t6 May -16 Jun -16 Jul -16 Aug -16 Sep -16 TOTAL COST Resort/ & Comm RATE $ 779,853.00 $ 4.21 $ 739,473.64 $ 3.97 $ 785,104.66 $ 3.90 $ 970,759.15 $ 3.80 $ 902,558.73 $ 3.73 $ 839,649.50 S 3.91 $ 726,827.30 $ 3.79 $ 653,744.12 $ 3.61 $ 617,470.10 5 3.64 $ 635,633.43 $ 3.75 5 615,466.43 $ 3.63 $ 612,360 10 $ 3.60 $ 8,879,100,16 $ 3.80 Total Projected DTH WACOG Total Reservation Total Commodity Cost Purchased 1st6 Months $ 941,368.08 $ 4,076,030.62 $ 5,017,398.68 1,284,516 $3.906 2nd 6 Months $ 613,215.08 $ 3,248,486.40 $ 3,861,701.48 1,051,500 $3.673 TOTAI. $ 1,554,583.14 $ 7,324,517.02 $ 8,879,100.16 2,336,016 $3.801 as of 3/11/2016 Prior Month Cashout Adjustment $ (750.31) $ 20,618.11 $ 1,847.19 $ 742.54 $ (4,469.80) $ 5,071.13 $ (1,754.99) $ 800.06 $ (7,832.24) 5 9,397.63 $ - $ - $ - S 5 - S $ - S 5 - S 5 - $ ($12,960.15) $36,629 47 COMMODITY COST $ 675,370.79 $ 595,571.37 $ 620,498.49 S 811,420.96 $ 733,792.01 $ 639,3/7.00 $ 583.42280 $ 558,33/.80 $ 526600.20 $ 540,501.20 $ 520,134 20 $ 520,490.20 $7,324,517.02 Propane Weighted Average Cost of Gas (WACOG) FY 2015 -16 14 r r4 co m•pl Jk3 3/11/2016 Date Invoice Company Targa I L&L Shipping Gallons Delivered Propane Rate Propane Cost Shipping I Total Cost Cost FYTD Gallons Cost of Inventor Tank Inventory Tank I WACOG Withdraw) 1 09130115 �1 Year. Totals ! ;: $ 33,452.86 ! 50,024 0.66874 I 10/19/15 ITa'ga I 15050170 18,0041 0.67188 5 11,233.42 S 863.12 S 12,096.54 18,004.0 $ 45,549401 68,028 0.66957 10/26/15 ,Tartia I 15051086 8,992 8.849 620 0.66694 5 5,566.05 S 431.07 S 5,997.12 26,996.0 5 51,546.52 1 77,020 0.66926 10/27(15 ; Targa 1505'249 0.66694 S 5,477.54 5 424.22 5 5,931.76 35,845.0 S 57,448.281 85,869 0.66902 10/31/15 MONTHLY INVENTORY ADJUSTMENT 0.54742 S 339.20 5 - S 339.40 36,465.0 S 57,787.68 1 86,489 0.66815 10/31/15 END OF MONTH z,�, ;. w „ , t° vs,,•> ;�ra�'- : - • > -- _ _ - ° - • ;` $ 30,764.33 ( 46,044 40,445 0.66815 11(05/15 Targa 1 15052871 8.723 0.69924 5 5,683.04 S 41640 5 6 ,099.44 45,188..0 S 36,863.771 54,767 I 0.67310 11/06/15 ! Targa I 15054019 8,784 8,850 0.69174 5 5,656.90 5 419.32 S 6,076.22 53,972.0 $ 42,939.991 63,551 0.67568 11/23115 Targa '5355637 0.64424 S 5,279.03 S 222.46 S 5,70149 62,822.0 $ 48,641.48 ; 72.401 0.67183 11/30/15 MONTHLY INVENTORY ADJUSTMENT $ - S - $ - 62,822.0 S 48,621.48 I 72,401 0.67183 ' 11/30/15 END OF MONTH "`� P' •,^max; '�x ' $ ' `? $ .- S " "% $ 32,063.97 I 47,726 24,675 0.67183 11/24/15 Targa 1 15056023 8.857 0.65174 I S 5.349.63 5 422.80 5 5,772.43 71,679.0 1 5 37,836.40 56,583 0.66869 12/18/15 Targa 1 15060311 9,051 0.59403 S 4.946.37 S 430.21 5 5,376.58 80,730.0 $ 43,212.98 65,634 0.65839 12131115 MONTHLY INVENTORY ADJUSTMENT 1,519 0.51364 5 780.22 S - S 780.22 82,249.0 $ 43,993.20 67,153 0.65512 12/31/15 'END OF MONTH ,r,;^ ,,.v�, rss , °a =rots, ,,�, a `,�, „, ;.-. $ 24,173.89 36,900 30,253 0.65512 01/07/16 Ta •a /600/833 17,977 0.59829 5 9,915.71 S 839.82 5 10.755.53 S 34,929.42 0.63650 01/25/16 Targa 16004875 9,372 0.56322 $ 4,840.64 5 437.82 5 5.278.46 109,598.0 5 40,207.88 64,249 0.62581 01/27/16 Targa I 16006315 9,205 0.55821 5 4.708.36 S 429.92 5 5,138.28 118,803.0 S 45,346.'6 73,454 0.61734 ^1/28/16 Ta •a I 16006316 9,101 850 0.56822 S 4,746.17 5 425.16 S 5,171.33 127,904.0 S 50,517.49 82,555 0.61193 01/31/16 MONTHLY INVENTORY ADJUSTMENT 143236 5 1.217.51 5 I S 1,217.51 128,754.0 $ 51,735.00 83,405 -. 46,960 I _._ - -- --- ' 36,445 0.62029_ - - - - -- 0.62029 01/31(16 END OF MONTH <':"`; „f,w, , t . .��, kya,._ ;ti,,x ,, at;; °?g' ,. ,a. 11,S - $ 29,128.65 02/11 /16 MESIMMERIE IMMUMErlin 02/29/16 Tara 1 1/6039818 18,119 0.60896 $ 10,128.52 S 905.31 5 11 33.83 146,873.0 5 40,162.48 65,079 0.61713 160/1747 9,003 064260 S 5.370.29 5 415.07 S 5,785.36 5 45.947.84 74.082 0.62023 16011972 9.128 456 MIMI 5 5,513.31 S 420.83 S 5,934.14 S 51,881.98 ! 0.62351 MONTHLY INVENTORY ADJUSTMENT 0.17618 5 80.34 S - 5 80.34 165,460 .,3 5 51,962.32 83,666 0.62107 02/29/16 t. END OF MONTH v «.�g ,° *�y,adbTra,,,,t -„ ;i S 21,369.11 34,407 49,259 0.62107 -- Projections Month Delivered Delivered Delivered Cost Total EOM Tank EOM Tank Projected CGS Cost Gallons Cost of Inventory Gallons Gallons Cost WACOG Feb -16 Mar -16 Apr -16 May -16 Jun -16 Jul -16 Aug -16 Sep -16 Oct -16 Nov -16 34,407 $ 21,369.00 0.62 $ 0.65 45,000 $ 29,250.00 $ 50,619.00 79,407 34,407 $ 21,933.18 0.64 $ 0.65 27,000 $ 17,550.00 $ 39,483.18 61,407 34,407 $ 22,122.85 0.64 $ 0.65 27,000 $ 17,550.00 $ 39,672.85 61,407 34,407 $ 22,229.12 0.65 $ 0.65 18,000 $ 11,700.00 $ 33,929.12 52,407 34,407 $ 22,275.64 0.65 $ 0.75 18,000 $ 13,500.00 $ 35,775.64 52,407 34,407 $ 23,487.94 0.68 $ 0.75 18,000 $ 13,500.00 $ 36,987.94 52,407 34,407 $ 24,283.85 0.71 $ 0.75 27,000 $ 20,250.00 $ 44,533.85 61,407 34,407 $ 24,952.80 0.73 $ 0.75 27,000 $ 20,250.00 $ 45,202.80 61,407 34,407 $ 25,327.61 0.74 $ 0.75 36,000 $ 27,000.00 $ 52,327.61 70,407 34,407 $ 25,571.83 0.74 CSW:03116/2016 CLEARWATER GAS SYSTEM Attachment #4 NATURAL GAS RATE BILLING FACTORS FOR APRIL 1, 2016 - SEPTEMBER 30, 2016 BASED ON APPROVED GAS ADJUSTMENT FACTORS lnterr. Contract Firm Natural Gas Rate Schedules NG Rate NG Rate RS SMF MMF LMF SGS MGS LGS RAC GAC LAC SL SL w /Mb. NGV NSS IS CNS Relight (Non -Real) (Non -Real) Applicable Annual Therm Range NA (1 - NA (4 + NA (4 + NA (4 + 0 - 18,000- 100,000 NA (1 - NA (0 - NA (150 NA NA NA NA 100,000 NA or Other Rate Determinant 3 Units) Units) Units) Units) 17,999 99,999 & up 3 Units) 149 tons) tons & +) & up Monthly Customer Charge $12.00 $25.00 $40.00 $95.00 $25.00 $40.00 $95.00 $12.00 $25.00 $40.00 $20.00 $20.00 By Contract $50.00 $250.00 By Contract (For Central Pasco Territory) ($20.00) ($40.00) ($70.00) ($160.00) ($40.00) ($70.00) ($160.00) ($20.00) ($40.00) ($70.00) ($30.00) ($30.00) (By Contract) ($75.00) $400.00 (By Contract) if not prey. if not prey. if not prey. Non -Fuel Energy Charge /Therm billed billed billed Non -Fuel Energy Charge $0.44 $0.44 $0.44 $0.44 $0.42 $0.38 $0.34 $0.20 $0.15 $0.10 $0.20 $0.35 By Contract $0.42 $0.24 By Contract Energy Conservation Adj. (ECA) 0.16 0.16 0.16 0.16 0.16 0.16 0.16 NA NA NA NA NA NA NA NA NA Regulatory Imposition Adj. (RIA) 0.10 0.10 0.10 0.10 0.10 0.10 0.10 NA NA NA NA NA NA NA NA NA Usage & Inflation Adj. (UTA) 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.71 $0.71 $0.71 $0.71 $0.69 $0.65 $0.61 $0.20 $0.15 $0.10 $0.20 $0.35 By Contract $0.42 $0.24 By Contract Purchased Gas Adjustment (PGA) 0.70 0.70 0.70 0/0 070 0.70 0.70 an 0/0 0.70 070 0/0 0.61 0.70 0.61 261 Total Energy Charge /Therm 1.41 1.41 1.41 1.41 1.39 1.35 1.31 0.90 0.85 0.80 0.90 1.05 0.61 1.12 0.85 0.61 + Non -Fuel + Non -Fuel Minimum Monthly Bill $12.00 $25.00 $40.00 $95.00 $25.00 $40.00 $95.00 $12.00 $25.00 $40.00 $20.00 $20.00 By Contract $50.00 $250.00 Customer (For Central Pasco Territory) ($20.00) ($40.00) ($70.00) ($160.00) ($40.00) ($70.00) ($160.00) ($20.00) ($40.00) ($70.00) ($30.00) ($30.00) (By Contract) ($75.00) $400.00 Charge + @ 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.29 $ 1.29 $ 1.29 $ 1.29 $ 1.27 $ 1.24 $ 1.20 $ 0.82 $ 0.78 $ 0.73 $ 0.82 $ 0.96 $ 0.56 $ 1.02 $ 0.78 with 6.0% Franchise $ 1.37 $ 1.37 $ 1.37 $ 1.37 $ 1.35 $ 1.31 $ 1.27 $ 0.87 $ 0.82 $ 0.78 $ 0.87 $ 1.02 $ 0.59 $ 1.09 $ 0.82 Change from 9/2014 Therm Rate $ (0.34) $ (0.34) $ (0.34) $ (0.34) $ (0.32) $ (0.30) $ (0.28) $ (0.24) $ (0.24) $ (0.24) $ (0.24) $ (0.24) $ (0.24) $ (0.28) $ (0.28) $ (0.24) % Change from 9/2014 Therm Rate -15.0% -15.0% -15.0% -15.0% -14.9% -14.4% -13.8% -12.8% - 13.1% -13.5% -12.8% -12.1% -13.5% -13.0% -16.1% -16.4% Utility Tax Note: Fuel Rate per Therm 10/01/1973 $0.069 $0.069 $0.069 $0.069 $0.069 $0.069 $0.069 $0.069 $0.069 $0.069 $0.069 $0.069 $0.069 $0.069 $0.055 Non - Utility Taxable Fuel /Therm $0.631 $0.631 $0.631 $0.631 $0.631 $0.631 $0.631 $0.631 $0.631 $0.631 $0.631 $0.631 $0.541 $0.631 $0.555 BTU FACTOR = THERMS /100 CUBIC FEET (CCF) 10/2015 11/2015 12/2015 01/2016 02/2016 03/2016 04/2016 05/2016 06/2016 07/2016 08/2016 09/2016 Firm Service Rates 1.042 1.044 1.042 1.042 1.042 1.045 1.046 Interruptible Service Rates 1.022 1.023 1.021 1.021 1.022 1.025 1.025 FY 15/18 Avg. 1.043 1.023 $0.069 $0.541 CSW:03/16/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 Gallon Range or Other Rate Determinant Monthly Customer Charge Non -Fuel Energy Charges /Gallon: Non -Fuel Energy Charge (NFE) /Gallor Energy Conservation Adj.(ECA) /Gallor Regulatory Imposition Adj.(RIA)/Gallor Usage & Inflation Adj. (UTA) /Gallon RESIDENTIAL MULTI - FAMILY MRLP MMLP NA NA (1 - 3 Units) (4 + Units) $12.00 $25.00 $1.90 0.16 0.10 0.01 Total Non -Fuel Charges (NF) /Gat. $2.17 Purchased Gas Adjustment(PGA) /Gal. 140 Total Energy Charges /Gallon $3.57 Minimum Monthly Bill $12.00 Utility Tax Note: Fuel Rate per Gallon 10/01/1973 0.161 Non - Utility Taxable Fuel /Gallon $1.239 Change from 9/2014 Gallon Rate ($0.60) % Change from 9/2014 Gallon Rate -14.5% $1.90 0.16 0.10 0.01 $2.17 1.40 $3.57 $25.00 0.161 $1.239 ($0.60) - 14.4% CLEARWATER GAS SYSTEM METERED PROPANE (LP) RATE BILLING FACTORS FOR APRIL 1, 2016 - SEPTEMBER 30, 2016 BASED ON APPROVED GAS ADJUSTMENT FACTORS LOOP RESL. LRLP NA $12.00 For Each Meter $0.90 0.16 0.10 0.01 $1.17 1.40 $2.57 $12.00 0.161 $1.239 ($0.60) -18.9% SMALL COML. LARGE COML. MGLP MLLP 0 - 2,500 >2,501 $25.00 $40.00 $0.30 $0.25 0.16 0.16 0.10 0.10 0.01 0.01 $0.57 $0.52 1.40 1,40 $1.97 $1.92 $25.00 $40.00 0.161 $1.239 ($0.58) -22.7% 0.161 $1.239 ($0.58) -23.2% 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 #5 Page 1 of 2 STANDBY /GENERATOR CONTRACT MTRD LPSM CLP (Non -Resl. Only) NA NA (Closed for New Resl. Applications) $50.00 Set By Contract $1.00 NA NA NA $1.00 1_40 $2.40 $50.00 0.161 Contract PGA - 0.161 $1.239 NA NA ($0.54) -18.4% Set By Contract NA NA NA Set By Contract 110 Contract NFE + $1.100 Customer Charge + Non -Fuel Energy Chg. for the Contracted # of Gallons /Mo. 0.161 Contract PGA - 0.161 NA NA CSW:03/16/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 Lovol) BRLPO BRLP1 - BRLP2 BRLP3 BRLP4 CLEARWATER GAS SYSTEM BULK PROPANE (LP) RATE BILLING FACTORS FOR APRIL 1, 2016 - SEPTEMBER 30, 2016 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 UNI15 1 -3 UNITS 1 -3 UNITS 1 -3 UNITS 1 -3 UNITS 1 -3 UNITS 1 -3 UNITS 1 -3 UNITS 1 -3 UNITS 1 -3 UNITS Annual Customer Charge $ 350.00 $ 225.00 $ 180.00 $ 90.00 $ 75.00 $ 350.00 $ 210.00 $ 150.00 $ 75.00 $ 80.00 Non -Fuel Charges (NF) /Gallon: Non -Fuel Energy Charge (NEI) /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)lGal $ 0.16 $ 0.16 $ 0.18 0.16 0.16 0.16 0.16 0.18 0.16 0.16 Regulatory Imposition Adj. (121A)lGal $ 0.10 $ 0.10 $ 0.10 0.10 0.10 0.10 0.10 0.10 0.10 0.10 :;sage & Inflation Adj. (UTA) /Gallon 0.01 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.07 $ 2.07 $ 1.87 $ 1.27 S 1.17 $ 2.07 S 2.07 $ 1.87 $ 1.17 $ 1.07 Purchased Gas Adj. (PGA)/Gallon $ 1.40 1 1.40 S 1.40 $ 1.40 $ 1.40 $ 1.40 $ 1.40 $ 1.40 $ 1.40 $ 1.40 Total Energy Charges /Gallon $ 3.47 $ 3.47 $ 3.27 $ 2.67 $ 2.57 5 3.47 $ 3.47 $ 3.27 $ 2.57 5 2.47 Note: No Monthly Minimum Bill Utility Tax Note: Fuel Rate per Gallon 10/01/1973 $ COMMERCIAL BULK LP SERVICE (Based on Annual Usage Lovol) BCLP1 BCLP2 0 - 2,500 > 2,500 Customers in this Customers in this Range of usage Range of Usage $ 90.00 5 90.00 Attachment #5 Page 2 of 2 BULK STANDBY/ CONTRACT BULK GENERATOR LP SERVICE LPSB CLP (Closed for New Resldental Any Contract Applications) Customers Who Requests Bulk Del. $ 420.00 Set by contract $ 0.25 $ 0.20 $ 1.00 0.16 0.16 NA 0.10 0.10 NA 0.01 0.01 NA $ 0.52 $ 0.47 $ 1.00 $ 1.40 $ 1.40 $ 1.40 $ 1.92 5 1.87 $ 2.40 0.161 8 0.161 $ 0.161 $ 0.161 S 0.181 $ 0.161 $ 0.161 $ 0.161 $ 0.161 $ 0.161 1 0.161 $ 0.161 $ Non - Utility - Taxable Fuel /Gallon $ 1.239 $ 1.239 $ 1.239 S 1.239 $ 1.239 $ 1.239 $ 1.239 $ 1.239 $ 1.239 $ 1.239 $ 1.239 $ 1.239 $ Change from 9/2014 Gallon Rate $ (0.600) $ (0.600) $ (0.600) $ (0.60) $ (0.60) 5 (0.40) $ (0.40) $ (0.60) $ (0.60) $ (0.70) $ (0.58) $ (0.58) $ Change from 9/2014 Gallon Rate -14.7% -14.7% -15.5% -18.3% -18.9% -10.3% -10.3% -15.5% -18.9% -22.1% -23.2% -23.7% Sot By Contract NA NA NA Set By Contract 1.10 Cotract NFE * 1.100 0.161 $ 0.161 1.239 Contract PGA - 0.161 (0.54) -18.4% NA NA CSW:03/16/206 ' • Residential - - ---- -- ---- - -- - r , Rate History By Components Clearwater Gas System - - , Contract PGA ' _ PGA Attachment #6 Page 1 of 3 LP PGA/gallon - , 1 1- _ ECA„! RIA# , Adjustments/Therm Total Rate Month, NG/therm, LP/gallon • WNA/U1A-Resl# UIA-Coml# , L Oct-12, Nov-12 , . $ 0.05 S 0.05 S 0.05 L $ 0.08 S 0.08 $ 0.13 $ 0.13 $ 0.16 S 0.16 S 0.16 S 0.16 S 0.13 5 0.13 S 0.13 5 0.13 S 0.06 S 0.06 S 0.06 S 0.06 S 0.06 $ 0.06 S 0.06 S 0.06 5 0.06 $ 0.06 S 1.99 5 1.99 $ 1.48 $ 1.48 S 3.26 5 3.26 , I -1-$ 5 0.14 1 5 0.14 5 0.14 S 0.73 _._ S 0.73 5 0.73 S 0.73 $ 0.71 $ 0.71 S 0.63 5 0.63 S 0.63 Ls 0.63 5 0.61 , S 0.61 Dec-12 $ 1.53 S 3.31 i S 1.99 Jan-13 5 1.53 5 3.31 5 0.1445 Ts 0.13 0.13 0.05 5 0.08 S 0.08 5 1.99 5 1.92 S 1.92 Feb-13 Mar-13 $ 1.56 $ 3.29 S 1.56 $ 3.29 A_p_ii-13 May-13 Jun-13 $ 1.60 S 1.60 ' 5 1.65 $ 3.22 $ 3.22 S 3.23 5 0.13 5 0.13 S 0.15 $ 0.08 5 0.08 $ 0.104 5 0.75 $ 0.75 5 0.65 5 1 85 S 0.65 S 1.85 5 0.79 $ 0.69 S 1.85 I 5 1.85 Jul-1315 Aug-13F Sep-13r$ 1.65 5 3.23 -1 5 0.15 S 0.10 $ 0.79 S 0.69 5 1.67 5 3.23 $ 0.15 S 0.10 5 0.10 S 0.06 S 0.81 S 0.71 S 1.85 1.67 S 3.23 5 0.15 5 0.06 S 0.81 $ 0.71 5 1.85 FY 12/13 Avg. $ 1.582 $ 3.257 I $ 0.140 $ 0.077 S 0.132 ' $ 0.060 $ 0.753 $ 0.653 S 1.908 2012 Avg. S 1.501 5 3.548 I s 0.133 5 0.031 $ 0.073 S 0.067 5 0.785 S 0.700 I $ 2.312 S 0.13 $ 0.13 S 0.09 Oct-13 S 1.70 5 3.45 5 0.14 S 0.10 S 0.06 S 0.85 5 0.76 5 2.08 ,_ Nov-13 S 1.70 S 3.45 5 0.14 S 0.14 5 0.10 S 0.10 S 0.06 5 0.07 S 0.85 5 0.76 5 2.08 Dec-13 $ 1.66 S 3.41 S 0.85 S 0.76 5 2.08 Jan-14 5 1.69 5 3.52 5 0.14 5 0.10 $ 0.09 S 0.09 S 0.07 $ 0.07 5 0.88 5 0.87 S 0.79 S 0.78 5 2.19 5 2.37 Feb-14 S 1.68 5 3.70 S 0.14 S 0.10 Mar-14 5 1.70 S 4.27 S 0.14 5 0.10 5 _ 0.09 5 0.07 S 0.89 5 0.80 S 2.94 A.r-14 5 1.70 5 4.27 $ 0.14 5 0.10 $ 0.09 5 0.07 S 0.07 5 0.89 S 0.94 S 0.80_, 5 2.94 5 0.85 $ 1.94 May-14 $ 1.75 S 3.27 5 0.14 5 0.10 $ 0.09 Jun-14 S 1.75 S 3.27 S 0.14 5 0.10 5 0.09 5 0.07 S 0.07 S 0.94 S 0.85 S 1.94 Jul-14 5 1.75 S 3.27 5 0.14 $ 0.10 S 0.09 S 0.94 5 0.85 S 1.94 Au.-14 S 1.75 S 3.27 S 0.14 5 0.10 S 0.09 S 0.07 5 0.94 $ 0.85 S 1.94 Sep-14 5 1.75 S 3.27 S 0.14 5 0.10 S 0.09 S 0.07 5 0.94 S 0.85 5 1.94 FY 13/14 Avg. $ 1.715 $ 3.535 $ 0.140 S 0.100 $ 0.097 $ 0.068 $ 0.898 S 0.808 $ 2.198 2013 Avg. $ 1.629 5 3.297 S 0.140 I $ 0.089 $ 0.137 $ 0.061 S 0.783 5 0.686 5 1.931 $ 0.14 1 S 0.14 $ 0.12 5 0.12 $ 0.09 A - Ls - 5 - 5 0.01 , S 0.07 S - Oct-14 5 1.78 5 3.47 S 0.95 s 0.95 $ 0.85 4$ 2.12 S 0.85 ' 5 2.12 Nov-14 S 1.65 5 3.38 Dec-14 $ 1.65 t $ 3.38 5 0.14 5 0.12 S - S - t 5 0.02 t S 0.02 5 0.95 S 0.95 $ 0.85 $ 0.85 $ 2.12 S 2.12 S 1.94 Jan-15 S 1.65 5 3.38 4 5 0.14 5 0.14 S 0.12 $ 0.12 Feb-15 5 1.64 $ 3.21 5 0.93 5 0.83 Mar-15 $ 1.57 $ 3.03 5 0.13 5 0.13 $ 0.10 5 0.01 $ 0.10 S 0.01 5 0.10 S 0.01 5 0.89 5 0.79 5 1.79 Apr-15 5 1.54 $ 3.03 S 0.02 S 0.02 5 0.02 1,_5 0.02 5 0.02 $ 0.86 S 0.86 $ 0.84 S 0.76 $ 0.76 S 0.74 5 1.79 $ 1.79 5 1.73 S 1.73 5 1.60 May:15 Jun-15 S 1.54 S 3.03 5 0.13 5 1.53 5 2.98 S 2.98 5 0.14 $ 0.10 5 0.01 S 0.01 Jul-15 S 1.53 S 0.14 5 0.10 S 0.84 5 0.87 5 0.74 5 0.77 Au. 15 5 1.57 5 2.86 S 0.15 5 0.10 5 0.01 Sep-15 S 1.57 $ 2.86 S 0.15 S 0.10 S 0.01 5 0.02 S 0.87 5 0.77 S 1.60 FY 14115 Avg. 5 1.602 $ 3.133 S 0.139 5 0.108 $ 0.014 $ 0.019 5 0.897 S 0.797 $ 1.871 2014 Avg. 5 1.717 $ 3.528 5 0.140 $ 0.105 I 5 0.075 $ 0.058 $ 0.923 $ 0.831 I $ 2.208 S 0.16 5 0.10 5 0.01 5 0.02 5 0.88 $ 0.79 5 1.62 Oct-15 S 1.59 5 2.89 Nov-15 S 1.59 5 2.89 5 0.16 S 0.10 5 0.01 S 0.02 5 0.02 4 S 0.88S 0.79 S 0.79 5 1.62 5 1.62 t- - Dec-15, S 1.59 5 2.89 $ 0.16 $ 0.10 S 0.01 ' 5 0.88 Jan-16 5 1.59 $ 2.89 5 0.16 S 0.14 $ 0.10 5 0.01 5 0.10 5 0.01 S 0.01 5 0.01 S 0.88 5 0.85 5 0.79 $ 0.76 S 1.62 5 1.52 Feb-16 5 1.54 S 2.77 Mar-16 $ 1.54 $ 2.77 IS 0.14 S 0.16 5 0.10 $ 0.01 5 0.10 5 0.01 5 0.01 I 5 0.01 50.855 $ 0.70 0.76 5 0.61 1- $ 1.52 T s 1.40 t A.r-16 S 1.41 S 2.67 Maj-16 4 Jun-16 --E Jul-16 , I Aug-16 Sep-16 FY 15/16 Av . $ 1.550 5 2.824 5 0.154 $ 0.100 i $ 0.010 I S 0.014 $ 0.846 S 0.756 $ 1.560 2015 Avg. I $ 1.576 I $ 3.003 5 0.144 S 0.103 I S 0.009 I 5 0.018 $ 0.879 I $ 0.782 $ 1.746 $ 0.03 $ - S - 0% 0% , , ' residential rate for usage >1,000 1 . 300 gallons/year & equal & NFE rate droped 4 cents and NFE rate unchanged @, $1.00/gallon. , (0.01)r 5 (0.16)±$ -19% KWH in January 2016 1 to Residential LP Will Call to 44 cents/therm. UlA decreased (0.15) $ (0.39) -20% -22% is 12.616 cents/KWH. (BRWCLP). UlA decreased by 9 cents/therm by 9 cents/gallon too. to 0. Incr. Above Last Year Same Month 5 (0.13) , I -8% $ (0.36)1 -12% -I- 1 Note: following increased unchanged 4 --- ' Duke Energy I, f 1 for customers changes: 52 from i 23% Flondia's using 120.1- S10 to S12/month $90/year, i 5 _(2.60) -8%1 $ ..(7.87) -13% 10.01 12.6 -21% which is applicable with Charge Customer Charge unchanged initially. Incr. Based on 20 Therms Equivalent Cents/KWH for Gas vs. Duke Rate (Residential) Gas Cheaper by Notes: 1 4.8 116 -62% LP (BRLP3) 11/1/2014, - RS NG Customer - BRLP3 LP - RIA & ECA Based on Bulk # New rates implemented CSW.11/24/2015 - CGS Residential L Rates 1 2,_•, 'Attachment #6 , - -- -- Page 3 of 3 - i : Annual Average Ca lender Year Fiscal Year Year NG/Therm 1 LP /Gallon * Year NG/Therm ' LP/Gallon * 1995 NA NA FY 95/96 S 0.880 S 1.199 * 1996 $ 0.915 S 1.239t* FY 96/97 $ 1.019 S 1.370 * 1997 S 1.049 S 1.380 * FY 97/98 S 1.054 $ 1.318 * 1998 S 1.032 S 1.288 * FY 98/99 S 1.052 $ 1.269 * _ 1999 S 1.073 S 1.311 FY 99/00 S 1.152 $ 1.504 $ 1.649 2000 $ 1.222 $ 1.584 FY 00/01 S 1.551 2001 S 1.549 $ 1.586 FY 01/02 S 1.352 S 1.488 2002 S 1.342 $ 1.553 FY 02/03 S 1.477 $ 1.817 2003 $ 1.534 $ 1.864 FY 03/04 $ 1.603 $ 1.913 2004 S 1.652 $ 1.968 FY 04/05 S 1.803 $ 2.162 2005 $ 1.925 S 2.278 FY 05/06 $ 2.080 $ 2.480 2006 S 2.012 $ 2.501 FY 06/07 $ 1.918 $ 2.742 2007 $ 1.893 $ 2.869 FY 07/08 $ 1.932 1 $ 3.183 2008 $ 1.965 S 3.186 i FY 08/09 S 1.610 S 2.524 2009 $ 1.464 T $ 2.418 FY 09/10 S 1.437 S 1.475 S 1.506 $ 2.865 $ 3.282 S 3.639 ' 2010 S 1.457 $ 2.946 FY 10/11 2011 $ 1.487 S 3.438 FY 11/12 2012 $ 1.501 $ 3.548 FY 12/13 S 1.582 S 1.629 S 1.602 $ 3.257 S 3.297 S 3.133 2013 S 1.629 $ 3.297 FY 13/14 FY 14/15 2014 $ 1.717 S 3.528 $ 3.003i 2015 S 1.576 Average $ 1.500 $ 2.339 $ 1.486 $ 2.304 for , . , . which was closed Notes: * Based on the Residential Metered Propane schedule 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 1 2,\ Clearwater Gas System Live Greener stn Fuel Use and Cost Comparison (Effective Rates for April 2016) APPLIANCE ANNUAL THERMS USED COOKING 45 WATER HEATING -Gas Tank Style/Gas Tankless vs. Electric Tank Style HEATING NATURAL GAS PROPANE (LP) GAS ! ELECTRIC S 63.45 S131.40 E � i 1 170 / 100 j $239.70 / $141.00* ! $496.40/$292.00* $629.00 S 166.50 150 S211.50 S438.00 S555.00 CLOTHES DRYING 50 i S 70.50 a S 146.00 ; S 185.00 TOTAL APPLIANCE USAGE — with tank/tankless ' i $585.15/ S486.45* $1,211.80/ S 1,007.40* i $1,535.50 i I GAS SAVINGS VS. ELECTRICITY 62% / 68 %* 21%/33%* *when using tankless J *when using tankless- LP OUTDOOR RECREATION: POOL HEATING* 375 S577.50 S1,136.25 S1,387.50 SPA/HOT TUB HEAT* 175 S269.50 [ S 530.25 j S 647.50 *varies according to pool size, weather conditions, and temperature maintained j All other figures are annual average projections based upon the following: 1. 1 therm = 100,000 BTUs of energy 2. Natural Gas S1.41 per therm 3. LP Gas per gallon (BRLP3) S2.67 I per gallon or S2.92 per therm 4. Duke Energy per KWH S0.12616 1 Per KWH or "Based on >1000 KWH rate) 1. Notes: The above analysis is based on April 2016 residential energy and fuel charges and does not include applicable taxes or franchise fees. 2. Current monthly customer charges are: Duke Energy S8.76, Peoples Gas S12.00-$20.00 (varies by rate class), Clearwater Gas System S 12.00 and S20.00 in Central Pasco. L.P. customers are billed annually, S75 -S210 (non - refundable) depending on program. 711 Maple Street • Clearwater, FL 33755 • (727) 562 -4980 www.clearwatergas.com