Loading...
GAS ADJUSTMENTS EFFECTIVE JANUARY 1, 2017CLEARWATER GAS SYSTEM Interoffice Correspondence Sheet TO: William B. Home II, City Manager FROM: Chuck Warrington, Managing Director COPIES: SUBJECT: DATE: RECEIVED DEC 2 3 2016 OFFICIAL RECORDS AND LEGISLAT►yE SRYCS DEPT 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 GAS ADJUSTMENTS EFFECTIVE JANUARY 1, 2017 December 20, 2016 This is the time of year when we re- assess our Usage & Inflation Adjustments (UTAs) based on the FYE 2015 /16 usages and based on inflation thru September 2016. Based on the attached analysis (Attachment #4), we are recommending an increase in our Residential UTA of 2¢ per therm or gallon and we are recommending an increase in our Commercial UIA of 3¢ per therm or gallon for January. Gas supply rates have remained fairly stable thus far this year and have actually remained lower than we had earlier projected. Therefore, we are recommending a decrease in our Natural Gas Purchased Gas Adjustment (PGA) of 3¢ per therm and a decrease in our Propane (LP) PGA of 15¢ per gallon for January. We recommend that we continue our standard Contract LP PGA be set at 30¢ below our Standard LP PGA. We are recommending no change in our Energy Conservation Adjustment (ECA) nor our Regulatory Imposition Adjustment (RIA) for January. The net effect of these recommended changes for January is a 1¢ per therm ( -0.7 %) decrease in our typical Residential Natural Gas customer's rate and a 13¢ per gallon ( -4.2 %) decrease in our typical Residential LP customer's rate. Therefore, we are recommending your approval of the following rates to become effective for billings rendered on and after January 1, 2017: Natural Gas Firm Standard Rate Schedule PGA S0.76 per therm (down 3¢ per therm) Natural Gas Interruptible and Contract (Non- Standard) Rate Schedule PGA Propane (LP) Gas Standard Rate Schedule PGA Propane (LP) Gas Contract Rate Schedule PGA Energy Conservation Adjustment (ECA) Regulatory Imposition Adjustment (EIA) Usage & Inflation Adjustment (UTA) - Residential - Commercial $0.67 per therm (down 3¢ per therm) $ 1.69 per gallon (down 15¢ per gallon) S1.39 per gallon (down 15¢ per gallon) S0.15 per therm or gallon (no change) 50.09 per therm or gallon (no change) $0.03 per therm or gallon (up 2¢) S0.04 per therm or gallon (up 3¢) William B. Horne II, City Manager December 20, 2016 Page 2 Attachment #1 shows the status of our Adjustment Recovery Clause balances with actuals thru November, but prior to closing the audited financials. 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 calculation of the updated Usage & Inflation Adjustments (UTAs) thru September 2016. Attachments #5 and #6 show the impact of these adjustment clause changes on our overall Natural and LP Gas rates, respectively. Attachment #7, Pages #1 and #2 shows our monthly rate history over the past 4+ years, and Pages #3 and #4 of this show our 15 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 10% 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 last January 1, 2016, to S1.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.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 January 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 January 2017.docx CLEARWATER GAS SYSTEM SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTIONS FOR FY 2016/2017 Attachment #1 Page 1 of 4 NATURAL GAS PURCHASED GAS ADJUSTMENT (PGA -NGl Monthly Cumulative NG PGA Commodity Interest Cost Center Total NG Fuel Total NG PGA Overage YTD Overage Rate /Therm Charges Expense Expenses Expenses Billed , (Shortage) (Shortage) Firm /Contr Budget Reservation Month Charges Prior Year Oct -16 $ 4,077,993.95 Nov -16 $ 180,313.78 Dec -16 $ 197,300.00 Jan -17 $ 198,000.00 Feb -17 $ 178,000.00 Mar -17 $ 197,000.00 Apr -17 $ 143,000.00 May -17 $ 95 000.00 Jun -17 $ 92,000.00 Jul -17 $ 95,000.00 Aug -17 $ 95,000.00 Sep -17 $ 92,000.00 P 1 Total YTD $ 5,640 607.73 , $ (1) Includes A nnual Admin Charge of $720,950 + UCS chg of $1,274,820 + Dividend $1,958,71 + FY 15/16 PGA write off of $8,183.02 + WNA $62.98 = $ 3,962,726.00 (2) Additional Dividend based on FY 15/16 Net Income = $ - (3) Bulk mailing & printing (4) OPEB liability & Period 13 Adjustment $ - Net RC = $ 1,677,881.73 PROPANE (LP) GAS PURCHASED GAS ADJUSTMENT (PGA -LP) $ (497,398.03) 1,331,140.38 $ 2,486.99 $ 33,532.42 1 $ 5,445,153.74 $ 1,236,815.88_$ (4,208,337.86): $ (4,705,735.89) 0.79/0.70 634,641.58 $ 23,528.68 ' $ 33,589.61 -- $ 872,073.65 1,354,675.02 $ 482,601.37' $ (4,223,134.52)', 0.79/0.70 850,000.00 $ 21,115.67 I $ 40,000.00 $ 1,108,415.67 1,694,704.22 _L$ 586,288.55 1 $ (3,636,845.97) 0.79/0.70 950,000.00 1 $ 18,184.23 $ 40,000.00 $ 1,206,184.23 1,876,955.68 $ 670,771.45 $ (2,966,074.52) 0.76/0.67 950,000.00 $ 14,830.37$ 40,000.00 $ 1,182,830.37 1,712,550.81 $ 529,720.43 $ (2,436,354.08) 0.76/0.67 875,000.00 ! $ 12,181.77 $ 40,000.00 ! $ 1,124,181.77 1,829,004.26 '', $ 704,822.49 $ (1,731,531.59) 0.76/0.67 775,000.00 $ 8,657.66 $ 40,000.00 $ 966,657.66 1,602,947.55 j $ 636,289.90 $ (1,095,241.70) 0.76/0.67 750,000.00 $ 5,476.21 $ 40,000.00 ! $ 890,476.21 1,438,542.68 $ 548,066.47 $ (547,175.23) 0.76/0.67 700 000 00 $ 2 735.88 , $ 40 000.00 $ 834,735.88 I 1,315,239.02 $ 480,503.14 i $ (66,672.09) 0.76/0.67 675,000.00 $ - $ 40,000.00 $ 810,000.00 1,253,587.19 $ 675,000.00 $ - $ 40,000.00 $ 810,000.00 1,253,587.19 I $ 675,000.00 $ - $ 40,000.00 i i $ 807,000.00 1,253,587.19 $ - $ 1,127,611.04 ',4,5,7' $ 1,127,611.04 - $ 6 $ 109,197.46 $ 1,594,733.07 $ 17 185 320.22 $ 17,822,196.69 I $ 443,587.19 $ 376,915.10 0.76/0.67 443,587.19 $ 820,502.29 0.76/0.67 446,587.19 $ 1,267,089.48 0.76/0.67 (1,127,611.04)', $ 139,478.44 636,876.47 9,840,781.9 (5) Pension Adjustment = Budget Month Prior Yea_ r Oct -16 Nov -16 Dec -16 _ Jan -17 Feb -17 Mar -17 Apr -17 May -17 Jun -17 Jul -17 Aug -17 Sep -17 P13 Total YTD Gallons Monthly Sold WACOG 33,154.7 $ 29,149.6 $ 38,000.0 $ 49,000.0 $ 43,000.0 $ 43,000.0 $ 32,000.0 $ 29,000.0 $ 27,000.0 $ 26,000.0 $ 26,000.0 $ 26,000.0 $ $ (6) Accrual = $ (7) Commodity adjustment from FYE transfer of ECA Collected in PGA @ Annual ECA Shortfall NG Proportion = 98.5% x Total ECA Transfer = $ 1,127,611.04 Average Annual PGA/Therm = $0.691 Avg Fuel Only = Interest Commodity Expense Charges 0.73568 $ : $ 24,391.25 0.74743 $ 486.01 21,787.29 0.76000 $ 330.11 28,880.00 0.78000 $ 136.65 38,220.00 0.76000 $ - 0.76000 $ 0.75000 $ - 0.77000 $ 0.78000 $ - 0.80000 $ 0.82000 $ 0.83000 $ 401,304.3 $ Cost Center Expenses CCS Chg, Admin & Dividend_ FY 15/16 Write off PGA & WNA Fuel Donations to events LP Yard Vaporization /loss due to malfunctioning meter 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 0.77180 $ 952.78 $ 32,680.00 32,680.00 24,000.00 22,330.00 21,060.00 20,800.00 21,320.00 21,580.00 4 309,728.54 Total LP Fuel Total LP PGA Expenses Billed 162,220.00 787.90 15, 000.00 1 5,785.00 34,414.23 $0.382 Delta /Therm = $0.310 242,598.38 $ 57,690.22 $ 22,273.30 53,452.93 $ 29,210.11 67,901.75 $ 38,356.65" 80,419.68 $ 32,680.00 j 70,572.37 1 $ 32,680.00 70,572.37 '11 $ 24,000.00 52,518.97 $ 22,330.00 47,595.32 $ 21,060.00 44,312.88 $ 20,800.00 42,671.67 $ 21,320.00 42,671.67 $ 0 21,580.00 42,671.67 $ 98,964.61 $ 627 853 06 $ 673 051.50 $ • (3) Accrual = 218,207.13 VITonth� Overage (Shortage) (184,908.16) $ 31,179.63 $ 38,691.64 $ 42,063.02 $ 37,892.37 $ 37,892.37 $ 28,518.97 $ 25,265.32 $ 23,252.88 $ 21,871.67 $ 21,351.67 $ 21,091.67 $ (98,964.61) $ 45,198.44 Cumulative LP PGA YTD Overage Therm /Gal. (Shortage) 87,705.97 (97,202.19) 2.01/1.84 (66,022.56) 2.01 /1.84 (27,330.92) 2.01/1.84 14,732.10 1.85/1.69 52,624.48 1.85/1.69 90,516.85 1.85/1.69 119,035.82 1.85/1.69 144,301.14 1.85/1.69 167,554.02 1.85/1.69 189,425.69 1.85/1.69 210,777.36 1.85/1.69 231,869.02 1.85/1.69 132,904.41 (4)' Adjustment from FYE transfer of ECA in PGA @ Annual ECA Shortfall LP Proportion = 1.5% x Total ECA Transfer = $ 17,171.74 Projected FYE Remaining $ 300,000.00 $ 81,792.87 CLEARWATER GAS SYSTEM SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTIONS FOR FY 2016/2017 Attachment #1 Page 2 of 4 ENERGY CONSERVATION ADJUSTMENT (ECA) Monthly Cumulative Budget Cost Center Interest Total ECA Total ECA Overage YTD Overage Month Expenses Notes /Exceptional Items Expense NGV Station Expenses Billed Prior Year Oct -16 $ Nov -16 $ Dec -16 $ Jan -17 $ Feb 17 $ Mar -17 $ Apr -17 $ May -17 $ Jun -17 $ Jul -17 $ Aug -17 $ Sep -17 $ P13 $ Total YTD $ - 1,469,018.10 'Promo$70,607,Adv$1,040, EmployCosts$76,926 $ 8,718.05 $ 46,980.19 1 $ 1,524,716.34 $ 153,577.58$ (1,371,138.76), $ (3,114,748.80) 0.15/0.15 119,981.15 Promo$48,390,Adv $3,496, Employ Costs$68,095 $ 15,573.74 $ 64,026.75 199,581.64 170,240.22 , $ (29,341.42) $ (3,144,090.22)', 0,15/0.15 150,000.00 $ 15,720.45 1 67,221.04 ! 232,941.49 ' 211,449.71 ' $ (21,491.78)' $ (3,165,582.00) 0.15/0.15 150,000.00 $ 15,827.91 $ 57,196.21 223,024.12 243,892.99 $ 20,868.87 $ (3,144,713.13) 0.15/0.15 150,000.00 $ 15,723.57 $ 35,613.47 201,337.04 222,380.74 $ 21,043.70 $ (3,123,669.43) 0.15/0.15 150,000.00. $ 15,618.35 $ 50,046.26 215,664.61 237,246.93 $ 21,582.32 $ (3,102,087.11); 0.15/0.15 150,000.00 $ 15,510.44 $ 212,980.48 207,427.10 1 $ (5,553.38): +$ (3,107,640.49)! 0.15/0.15 150,000.00 $ 15,538.20 $ 48,9477.778 214,485.98' 186,177.19 � $ (28,308.79) $ (3,135,949.28), 0.15/0.15 150,000.00 _ $ 15,679.75 $ 43,799.79 2 i 209,479.54 i 170,261.62 , $ (39,217.92): $ (3,175,167.20) 0.15/0.15 150,000.00 $ 15,875.84 $ 52,640.66 2&3 218,516.50 162,303.83 $ (56,212.66)] $ (3,231,379.86) 0.15/0.15 150,000.00 $ 16,156.90 , $ 48,247.76 214,404.66 162,303.83 $ (52,100.83)1 $ (3,283,480.69)' 0.15/0.15 150,000.00 $ 16,417.40 $ 50,522.44 216,939.84 162,303.83 1 $ (54,636.01), $ (3,338,116.70) 0.15/0.15 $ (200,000.00)14 -8 (200,000.00- 1,144,782.79 $ 1,344,782.79 $ (1,993,333.92); 3,088,999.25 $ 182,360.59 $ 412,712.39 $ 3,684,072.23 1 $ 3,434,348.36 $ (249,723.88) = Transfer of ECA Collected in PGA up to the ECA Collected for year (up to ECA Annual Shortfall 320,244.95 Note: Maximum amount which can be transferred = $ 1,144,782.79 $ 1,000,000.00 ECA NG /Therm (Shortage) (Shortage) LP /Gal. (1) Incl. Annual Admin Charge of $47,260 + UCS chg of $67,740 + Dividend $203,120 + FY 15/16 Write off of $2,124.95 = (1) SNEP Transfer = (2) Additional SNEP Transfer ($400K in 1Q + $500K in 3Q)= (3) FY17 loss on Installation WOs = (4) Pension Adjustment NGV = (5) NGV O &M $59,871.26 +PGA Recvy non -CGS $131,077.85 = (6)OPEB Adjustment = (7) ECA Accrual REGULATORY IMPOSITION ADJUSTMENT (RIA) (EIA) Environmental Expenses Notes /Exceptional Items Budget Month Prior Year Oct -16 $ Nov -16 $ Dec -16 $ Jan -17 $ Feb -17 $ Mar -17 $ Apr 17 $ May -17 $ Jun -17 $ Jul -17 $ Aug -17 $ Sep -17 $ P13 $ Total YTD $ 171,462.19 720.00 1,000.00 1,000.00 1,000.00 1,000 00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 200,000.00 Net ECA CCE = $ 1,768,754.30 Net NGV CCE = 212,712.39 (ORA) Regulatory Interest Expenses Expense 182,182.19 (1) Includes annual charges for Admin Charge $12,660 + FY 15/16 Write off of $1,602.19 + Dividend $156,480 = (2) Additional Dividend (3) Credit from Council allocation from Added Dividend (4) CIP closed to Operating 99,109.68 $ - 1,2 $ 66,404.28 $ 875.66 100,000.00 $ 704.99 100,000.00 $ 555.22 100,000.00 $ 303.69 100,000.00 $ 117.87 100,000.00 $ - 100, 000.00 $ - 100,000.00 $ - 100,000.00 $ - 100,000.00 $ - 100,000.00 $ - 45' $ 1,165,513.96 $ 2,557.43 (5) Accr Total RIA Expenses 270,571.87 67,999.94 101, 704.99 101,555.22 101,303.69 101,117.87 101,000.00 101,000.00 µ 101,000.00 101,000.00 101,000.00 101,000.00 1,350,253.58 Total RIA Overage YTD Overage Billed (Shortage) (Shortage) - $ 92,412.80 3,026.40 $ (267,545.47): $ (175,132.67) 102,134.18 $ 34,134.24 $ (140,998.43) 131,660.10 $ 29,955.11 $ (111,043.33) 151,861.05 ' $ 50,305.83 $ (60,737.49) 138,466.35 $ 37,162.66 $ (23,574.83) 147,722.85 $ 46,604.98 $ 23,030.15 129,155.40 !, $ 28,155.40 $ 51,185.55 115,924.05 $ 14,924.05 $ 66,109.60 106,014.15 r$ 5,014.15 $ 71,123.75 0.09/0.09 101,059.20 1 $ 59.20 $ 71,182.95 0.09/0.09 101,059.20 ! $ 59.20 $ 71,242.15 0.09/0.09 101,059.20 j $ 59.20 $ 71,301.35 0.09/0.09 - $ - $ 71,301.35 1,329,142.13 $ (21,111.45)' NG /Therm LP /Gal. 0.09/0.09 0.09/0.09 0.09/0.09 0.09/0.09 0.09/0.09 0.09/0.09 0.09/0.09 0.09/0.09 ua_ I $ Net EIA = ' $ NetORA= $ 11 440.00 1,165,513.96 CLEARWATER GAS SYSTEM SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTIONS FOR FY 2016/2017 Attachment #1 Page 3 of 4 USAGE AND INFLATION ADJUSTMENT (UTA) Commercial Budget . Month Beg. Bal. Oct-16__ Nov -16 Dec 16 Jan -17 Feb 17 _ Mar 17 Apr 17 May 17 _ Jun -17 Jul -17 Aug -17 Sep -17 Per 13 Total YTD 1 Monthly Cumulative UTA Interest Overage YTD Overage NG /Therm = LP Gallons' Expense ! Rate /Gallon NG Therms Rate /Therm (Shortage) (Shortage) LP /Gal $ - $ (387 898 82) I 6,769.4 $ 1,939.49 0.01 ; 795,485.4 1 0.01 $ 6,074.76 $ (381,824.06), 0.01/0.01 6,319.1 $ 1,909.12 0.01 864,123.4 i- 0.01 $ 6,789.06 I $ (375,035.00), 0.01/0.01 7,000.C-$ 1,875.18 0.01 950,000.0 0.01 $ 9,570.00 $ (365,465.00), 0.01/0.01 7,000.0' $ 1,827.33 0.04 1 1,050,000.0 0.04' $ 42,280.00 $ (323,185.00) 0.04/0.04 8,500.0 $ 1,615.93 0.04 1,150,000.0 I 0.04 $ 46,340.00 $ (276,845.00) 0.04/0.04 9,000.0 $ 1,384.23 0.04 1,100,000.0 i 0.04 $ 44,360.00 - $ (232,485.00), 0.04/0.04 8,000.0 $ 1,162.43 0.04 1,050,000.0 0.04 $ 42,320.00 $ (190,165.00)! 0.04/0.04 7,500.0 $ 950.83 0.04 900,000.0 0.04 $ 36,300.00 $ (153,865.00), 0.04/0.04 7,500.0 ; $ 769.33 0.04 850,000.0 I 0.04 ! $ 34,300.00 $ (119,565.00) 0.04/0.04 7,500.0 I $ 597.83 ' 0.04 825,000.0 0.04 1 $ 33,300.00 ' $ (86,265.00)' 0.04/0.04 7,000.0 L $ 431.33 0.04 T 800,000.0 ; 0.04 i $ 32,280.00 1 $ (53,985.00)', 0.04/0.04 7,000.0 $ 269.93 0.04 800,000.01 0.04 $ 32,280.00 $ (21,705.00)', 0.04/0.04 $ - $ (21,705.00) 89,088.5 14,732.91 11,134,608.8 $ 366,193.82 (1)', Recomputed UTA in December for January application. Increased by 3 cents to recover $390,270.32 from FY 15/16 less overcollections in FY 15/16 of ($2,371.50) = $387,898.82. i (2) Accrual = USAGE AND INFLATION ADJUSTMENT (UIA) Residential Budget Month Beg. Bal. Oct -16 Nov -16 Dec -16 Jan -17 Feb -17 Mar -17 Apr -17 May -17 Jun -17 Jul -17 Aug -17 Sep -17 Per 13 Total YTD Interest LP Gallons Expense Rate /Gallon Monthly Cumulative UTA Overage YTD Overage NG /Therm NG Therms ■ Rate /Therm (Shortage) (Shortage) LP /Gal $ (79,116.66) 26,110.4 $ 395.58 0.01 195,970.9 0.01. $ 1,824.02 $ (77,292.64) 0.01/0.01 22,797.9 $ 386.46 0.01 242,130.1 1 0.01 ! $ 2,265.87 $ (75,026.77) 0.01/0.01 22,000.0 $ 375.13 0.01 280,000.0 0.01 I $ 3,020.00 $ (72,006.77)' 28,000.0 $ 360.03 0.03 350,000.0 0.03 $ 11,340.00 $ (60,666.77) 0.01/0.01 37,000.0 $ 303.33 0.03 ! 490,000.0 0.03 ' $ 15,810.00 $ (44,856.77) 0.01/0.01 30,000.0 $ 224.28 0.03 410,000.0 ! 0.03 $ 13,200.00 $ (31,656.77) 0.01/0.01 20,000.0 $ 158.28 r 0.03 330,000.0 0.03 $ 10,500.00 $ (21,156.77) 0.01 /0.01 18,000.0 $ 105.78 0.03 250,000.0 0.03 $ 8,040.00 $ (13,116.77) 0.01/0.01 18,000.0 $ 65.58 0.03 220,000.0 0.03 $ 7,140.00 $ (5,976.77) 0.01/0.01 18,000.0 $ 29.88 0.03 185,000.0 0.03 $ 6,090.00 '.,$ 113.23 0.01/0.01 18,000.0 $ - 0.03 185,000.0 0.03 $ 6,090.00 $ 6,203.23 0.01/0.01 - 18,000.0 $ - 0.03 185,000.0 r1 0.03 $ 6,090.00 $ 12,293.23 0.01/0.01 $ - $ 12,293.23 275,908.3 2,404.37 3,323,101.0 $ 91,409.89 (1) p e y by FY 15/16 less overcollections in FY 15/16 of ($14599.70) = $79,116.66. 1 Recomputed UTA in December for January application. Increased b 2 cents to recover $93,716.36 from F CLEARWATER GAS SYSTEM SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTIONS FOR FY 2016/2017 Attachment #1 Page 4 of 4 TOTAL ALL COST RECOVERY ADJUSTMENT CLAUSES (Both PGAs + ECA + RIA + UTA), _ Budget Month Prior Yea_ r Oct -16 Nov -16 Dec -16 Jan -17 Feb -17 Mar -17 Apr -17 May -17 Jun -17 Jul -17 Aug -17 Sep -17 Per 13 Total YTD Total All Total Recovery Expenses Billed - $ 7,483,040.33 $ 1,459,008.86 $ 1,161,928.53 $ 1,689,557.28 $ 1,472,272.27 $ 2,118,305.79 $ 1,569,120.22 $ 2,406,749.40 $ 1,518,151.10 $ 2,206,120.26 $ 1,473,644.25 i $ 2,342,106.41 $ 1,304,638.13 $ 2,044,869.02 !, $ 1,228,292.19 $ 1,832,579.23 $ Monthly Cumulative Total Resl '- Overage ' YTD Overage NG /Thm (Firm) (Shortage) ' (Shortage) LP /Gal $ (2,527,904.78) (6,024,031 47)+ $ (8,551,936.25) 1.04/2.09 527,628.75 1 $ (8,024,307.50) 1.04/2.09 646,033.52 $ (7,378,273.99) 1.04/2.09 837,629.18 F$ (6,540,644.80) 1.03/1.96 687,969.17 r $ (5,852,675.64) 1.03/1.96 868,462.16 I $ (4,984,213.48) 1.03/1.96 740,230.89 l $ (4,243,982.59) 1.03/1.96 604,287.04 1 $ (3,639,695.55) 1.03/1.96 510,992.26 I $ (3,128,703.29) 1.03/1.96 448,695.39 $ (2,680,007.90), 1.03/1.96 451,267.23' $ (2,228,740.67) 1.03/1.96 451,472.05 $ (1,777,268.62), 1.03/1.96 1,166,275.41 $ 1,677,267.67 $ 1,150,316.50 $ 1,599,011.89 $ 1,146,724.66 $ 1,597,991.89 $ 1,146,519.84 $ 1,597,991.89 $ 1,026,575.66 , $ 1,144,782.79 $ 118,207.13 $ (1,659,061.49)' 22,847,499.09 23,716 342.38 $ 868,843.29 Last Updated 12/20/2016 E S R V T 0 Oct -16 Nov -16 Dec -16 Jan -17 Feb -17 Mar -17 Apr -17 May -1- Jan -1 Jul -1' Aug -1 Sep -1 Iota ArTAc /inn E'Jr ik 2. CGS Natural Gas Summary Monthly Actual /Projections (FY17) / 144,212 $ 79,576.18 41,788 S 2723742 12,400 $ 592.72 (50,000) $ 0.2500 $ (12,500.00) $0.00 $ 94,906.32 $0.6395 7 139.560 5 77,00921 40.440 5 26.358.79 10,500 $ 501.90 (50,000) $ 0.2500 $ (12,500.00) $0.00 5 91,369.90 $0.6503 1 144,212 $ 79,576.18 41.788 5 27,237.42 10,850 $ 518.63 (50,000) $ 0.2500 $ (12,500.00) 50.00 $ 94,832.23 50.6458 144,212 $ 79,57518 41,788 5 27,23742 10.850 $ 518.63 (50,000) $ 0.2500 $ (12,500.00) $0.00 $ 94,832.23 90.6458 7 139.560 $ 77.00921 40,440 $ 26,358.79 10,500 $ 501.90 (50,000) $ 0.2500 $ (12,500.00) 50.00 $ 91,369.90 50.6503 i 2641.833 $ 1457,76346 570,393 $ 371,782.16 266,100 $ 12,719.58 (684029) ($166,906,02) $395.24 $1,675,754.41 $0.5997 C 0 Oct -16 M Nov -16 Dec -16 M .tan -17 Feb -17 0 Mar -17 D Apr -1 May -1 1 n -1 T Jul -1 Sug -1 Y Sep -1 I ota $0.5518 $0.6518 as of 12119/2016 FGU No Notice GTI Prior Month COMMODITY FTS -2 (Usage) Gas Supply (FGU & Peoples) Management fee Usage Payment Ceshout Adjustment COST FTS -1 (Usage) --- - -- V1lume Rate Cost Volume Rate Cost Volume Rate Cost Fuel . f0 ,085 0.0 __ 139,506 E 0.0113 S 1,576.43 41,788 $ 0.0113 $ 472.20 185,061 $ 3.3899 E 627,336,60 3.10% $ 11,825.00 S - E 3,625.88 E 1,064.83 E 450.14 E 646,351.08 149,370 $ 0.0113 $ 1,687.89 53,430 $ 0.0113 $ 603.76 207,265 $ 3.0754 $ 637,413.14 3.10% $ 14,190.00 $ - $ 4,056.00 $ 3,758.07 $ 3,399.13 $ 665,107.99 369.35 55,211 $ 0.0154 $ 850.25 280,000 $ 3.4302 $ 960,454.00 3.50% 5 17,810.00 9 - $ 5480.00 S - $ - $ 987,963.60 294,789 $ 0.0154 $ 2, 850.25 256,000 $ 3.4916 $ 893,848.00 3.50% $ 16.250.00 $ - $ 5.000.00 S - S - $ 918,948.00 217,132 $ 0.0154 $ 3,349.83 55,211 $ 0.0154 $ - - - 21 ?,132 $ 0.0154 $ 3,343.83 49.868 $ 0.0154 $ 767.97 272,500 $ 3.4194 $ 931,774.00 3.50% S 17,355.00 $ $ 5.340.00 S $ $ 958,580.80 178.789 $ 0.0154 $ 2,75135 55211 $ 00154 $ 850.25 239.500 $ 3.3367 $ 799,148.00 3.50% 5 15.210.00 $ - $ 4,680.00 5 - S 5 822,64160 156,570 $ 0.0154 $ 2,411.18 53430 5 00154 $ 822.82 215,500 $ 3.3874 $ 729,990.00 3.50% 5 13,650.00 $ - $ 4,200.00 5 - $ - $ 751,074.00 150.212 $ 0.0154 $ 2,31126 41.788 $ 0.0154 $ 643.54 197,000 $ 3.5145 $ 692,348.00 3.50% 5 12,480.00 $ - $ 3,840,00 $ - $ - $ 711,624.80 142.560 6 0.0154 $ 2,19542 40.440 $ 0.0154 $ 62278 187,000 $ 3.4946 $ 653,490.00 3.50% 5 11,895.00 $ - $ 3,660,00 $ - $ - $ 671,863.20 141.212 $ 0.0154 $ 2,17466 41,788 $ 0.0154 $ 643.54 187,000 $ 3.5139 $ 657,098.00 3.50% S 11,895.00 $ - $ 3,660.00 $ - $ - $ 675,471.20 141212 $ 0.0154 $ 2,174.66 41.788 $ 0.0154 $ 643.54 187,000 $ 3.5396 $ 661,908.00 3.50% 5 11,895.00 $ - $ 3,660.00 $ - S - $ 680,281.20 145 560 $ 0 0154 5 2,24162 40440 $ 0.0154 $ 622.78 190,000 $ 3.5097 $ 666,840.00 3.50% $ 12,090.00 $ - $ 3.720.00 5 - S - $ 685,51440 I 1,9(5,701 500148'. 5 29,241,43 570,393 $Q:0147 ' $ 8,393.66 2,603.826 `:' '- ' "$3 =427: $ 8,911,647.74 $166,545.00 $0.00 550.921.88 $4,822.90 $3,849.27 $9,175421.87 TOTAL COST Resery &Comm RATE $ 761,619.03 $ 4.12 $ 845,421.77 $ 4.08 $ 1,185,236.10 $ 4.23 $ 1,116,961.40 5 4.36 $ 1,135,980.00 $ 4.17 $ 1,019,914.10 $ 4.26 $ 893,978.50 $ 4.15 $ 806,531.12 $ 4.09 $ 763,233.10 $ 4.08 $ 770,303.43 $ 4.12 $ 775,113.43 $ 4.14 $ 776 884.30 $ 4.09 $ 10,851,176.28 $ 4 .17 Total Projected DTH WACOG 1 otal Reservation Total Commodity Cost Purchased 1st6 Months $ 1,065,539.33 5 4,999,59307 $ 6,065.13240 1,440,326 $4.211 2nd6 Months $ 610,215.08 $ 4,175,828.80 $ 4,786,043.88 1,163,500 54.113 TOTAL $ 1,675,754.41 $ 9,175,421 87 $ 10,851,176.28 2,603,826 $4.167 TOTAL RESERVATION FT S-1 F FTS-2 N No-Notice Capacity Relinquishment R Reservation C COST Volume R Volume C 41,788 $ 27,237.42 1 15,500 E 740.90 ( (28,166) $ 0.2433 $ C 0 Oct -16 M Nov -16 Dec -16 M .tan -17 Feb -17 0 Mar -17 D Apr -1 May -1 1 n -1 T Jul -1 Sug -1 Y Sep -1 I ota $0.5518 $0.6518 as of 12119/2016 FGU No Notice GTI Prior Month COMMODITY FTS -2 (Usage) Gas Supply (FGU & Peoples) Management fee Usage Payment Ceshout Adjustment COST FTS -1 (Usage) --- - -- V1lume Rate Cost Volume Rate Cost Volume Rate Cost Fuel . f0 ,085 0.0 __ 139,506 E 0.0113 S 1,576.43 41,788 $ 0.0113 $ 472.20 185,061 $ 3.3899 E 627,336,60 3.10% $ 11,825.00 S - E 3,625.88 E 1,064.83 E 450.14 E 646,351.08 149,370 $ 0.0113 $ 1,687.89 53,430 $ 0.0113 $ 603.76 207,265 $ 3.0754 $ 637,413.14 3.10% $ 14,190.00 $ - $ 4,056.00 $ 3,758.07 $ 3,399.13 $ 665,107.99 369.35 55,211 $ 0.0154 $ 850.25 280,000 $ 3.4302 $ 960,454.00 3.50% 5 17,810.00 9 - $ 5480.00 S - $ - $ 987,963.60 294,789 $ 0.0154 $ 2, 850.25 256,000 $ 3.4916 $ 893,848.00 3.50% $ 16.250.00 $ - $ 5.000.00 S - S - $ 918,948.00 217,132 $ 0.0154 $ 3,349.83 55,211 $ 0.0154 $ - - - 21 ?,132 $ 0.0154 $ 3,343.83 49.868 $ 0.0154 $ 767.97 272,500 $ 3.4194 $ 931,774.00 3.50% S 17,355.00 $ $ 5.340.00 S $ $ 958,580.80 178.789 $ 0.0154 $ 2,75135 55211 $ 00154 $ 850.25 239.500 $ 3.3367 $ 799,148.00 3.50% 5 15.210.00 $ - $ 4,680.00 5 - S 5 822,64160 156,570 $ 0.0154 $ 2,411.18 53430 5 00154 $ 822.82 215,500 $ 3.3874 $ 729,990.00 3.50% 5 13,650.00 $ - $ 4,200.00 5 - $ - $ 751,074.00 150.212 $ 0.0154 $ 2,31126 41.788 $ 0.0154 $ 643.54 197,000 $ 3.5145 $ 692,348.00 3.50% 5 12,480.00 $ - $ 3,840,00 $ - $ - $ 711,624.80 142.560 6 0.0154 $ 2,19542 40.440 $ 0.0154 $ 62278 187,000 $ 3.4946 $ 653,490.00 3.50% 5 11,895.00 $ - $ 3,660,00 $ - $ - $ 671,863.20 141.212 $ 0.0154 $ 2,17466 41,788 $ 0.0154 $ 643.54 187,000 $ 3.5139 $ 657,098.00 3.50% S 11,895.00 $ - $ 3,660.00 $ - $ - $ 675,471.20 141212 $ 0.0154 $ 2,174.66 41.788 $ 0.0154 $ 643.54 187,000 $ 3.5396 $ 661,908.00 3.50% 5 11,895.00 $ - $ 3,660.00 $ - S - $ 680,281.20 145 560 $ 0 0154 5 2,24162 40440 $ 0.0154 $ 622.78 190,000 $ 3.5097 $ 666,840.00 3.50% $ 12,090.00 $ - $ 3.720.00 5 - S - $ 685,51440 I 1,9(5,701 500148'. 5 29,241,43 570,393 $Q:0147 ' $ 8,393.66 2,603.826 `:' '- ' "$3 =427: $ 8,911,647.74 $166,545.00 $0.00 550.921.88 $4,822.90 $3,849.27 $9,175421.87 TOTAL COST Resery &Comm RATE $ 761,619.03 $ 4.12 $ 845,421.77 $ 4.08 $ 1,185,236.10 $ 4.23 $ 1,116,961.40 5 4.36 $ 1,135,980.00 $ 4.17 $ 1,019,914.10 $ 4.26 $ 893,978.50 $ 4.15 $ 806,531.12 $ 4.09 $ 763,233.10 $ 4.08 $ 770,303.43 $ 4.12 $ 775,113.43 $ 4.14 $ 776 884.30 $ 4.09 $ 10,851,176.28 $ 4 .17 Total Projected DTH WACOG 1 otal Reservation Total Commodity Cost Purchased 1st6 Months $ 1,065,539.33 5 4,999,59307 $ 6,065.13240 1,440,326 $4.211 2nd6 Months $ 610,215.08 $ 4,175,828.80 $ 4,786,043.88 1,163,500 54.113 TOTAL $ 1,675,754.41 $ 9,175,421 87 $ 10,851,176.28 2,603,826 $4.167 TOTAL COST Resery &Comm RATE $ 761,619.03 $ 4.12 $ 845,421.77 $ 4.08 $ 1,185,236.10 $ 4.23 $ 1,116,961.40 5 4.36 $ 1,135,980.00 $ 4.17 $ 1,019,914.10 $ 4.26 $ 893,978.50 $ 4.15 $ 806,531.12 $ 4.09 $ 763,233.10 $ 4.08 $ 770,303.43 $ 4.12 $ 775,113.43 $ 4.14 $ 776 884.30 $ 4.09 $ 10,851,176.28 $ 4 .17 Total Projected DTH WACOG 1 otal Reservation Total Commodity Cost Purchased 1st6 Months $ 1,065,539.33 5 4,999,59307 $ 6,065.13240 1,440,326 $4.211 2nd6 Months $ 610,215.08 $ 4,175,828.80 $ 4,786,043.88 1,163,500 54.113 TOTAL $ 1,675,754.41 $ 9,175,421 87 $ 10,851,176.28 2,603,826 $4.167 Propane Weighted Average Cost of Gas (WACOG) FY 2016 -17 rrA- cponciOr ' 3 12/19/2016 Date Company Invoice Taroa Gallons L &L Shining Delivered Propane Rate Propane Shipping Cost Cost Total Cost FYTD Gallons Cost of Inventory Tank Inventory Tank Withdraw/ WACOG 09/30/16 8.858 I :. -Year End, 078320 Totals S 6,497 35 5 44020 5 6,93755 r> 8,8580 5 30,311.00 5 37.248 55 43,985 52.843 0.68912 10/13/16 Targa 16046684 0.70489 10/14/16 Targa /6047012 8,756 9,026 8,715 215 0.79069 S 6,488.19 S 435.13 5 6,923.32 17,614.0 $ 44,171.87 61,599 0.71709 10/27/16 Targa '6048725 0.79069 3 6,688.26 $ 448.54 S 7,136.80 26.640.0 5 51,308.67 70,625 0.72649 10/31/16 Targa 16049282 0.79070 S 6457.82 $ 433.09 $ 6,890.91 35,355.0 S 56199.58 79,340 0.73355 10/31/16 MONTHLY INVENTORY ADJUSTMENT 1.52302 S 327.45 $ - S 32745 35,570.0 S 58627.03 79,555 0.73568 10/31/16 END OF MONTH . j $ 26,125.47 35,512 44,043 0.73568 11/07/16 Targa 8,997 0.76891 S 6,468.84 S 449.03 5 6,917.87 44,5670 S 33,043.34 44,509 0.74240 11/08/16 Targa 16051534 8,546 8,721 8,785 0.76516 S 6,112.53 S 426.52 $ 6539.05 53.1130 S 39,582.39 53.055 0.74606 11/21/16 Targa 16053045 0.74516 5 6,:63.27 5 435.26 5 6498.53 61,8340 5 46,080.92 61,776 0.74594 11/30/16 Targa 16054623 0.75766 S 6.217.58 S 438.45 S 6,656.03 70,619.0 5 52,736.95 70,561 0.74740 11/30/16 MONTHLY INVENTORY ADJUSTMENT 476 0.75330 S 358.57 5 $ 358.57 71,095.0 5 53.095.52 71,037 0.74743 11/30/16 END OF MONTH '-c „,,.. S " � "' `' S 36,987.56 49,486 21.551 0.74743 12/08/16 Targa 16056857 8,894 0.87766 5 7,362.01 S 443.89 S 7,80590 79,989.0 5 44,793.46 58,380 0.76727 12/09/16 Targa 16057078 9,139 0.87266 5 7,519.12 $ 456.11 5 7,975.23 89,128.0 S 5276869 67.519 0.78154 FYTD Totals 35,355 0.78882 E 26,131.62 S 1,756.96 5 27,888.58 Projections Delivered Delivered !; Delivered Cost Total EOM Tank EOM Tank Projected Month CGS Cost Gallons Cost of Inventory Gallons Gallons Cost WACOG Nov-16 36,911 $ 25,036.00 0.68 Dec -16 $ 0.85 32,000 $ 27,200.00 $ 52,236.00 68,911 36,911 $ 27,979.32 0.76 Jan -17 $ 0.80 45,000 ; $ 36,000.00 $ 63,979.32 81,911 36,911 $ 28,830.57 0.78 Feb -17 $ 0.75 40,000 $ 30,000.00 $ 58,830.57 76,911 36,911 $ 28,233.87 0.76 Mar -17 $ 0.75 32,000 $ 24,000.00 $ 52,233.87 68,911 36,911 $ 27,978.18 0.76 Apr -17 $ 0.75 27,000 $ 20,250.00 $ 48,228.18 63,911 36,911 $ 27,853.58 0.75 May -17 $ 0.80 18,000 $ 14,400.00 $ 42,253.58 54,911 36,911 $ 28,402.72 0.77 Jun -17 $ 0.80 18,000 $ 14,400.00 $ 42,802.72 54,911 36,911 $ 28,771.86 0.78 Jul -17 $ 0.85 18,000 $ 15,300.00 $ 44,071.86 54,911 36,911 $ 29,624.96 0.80 Aug -17 $ 0.85 18,000 $ 15,300.00 $ 44,924.96 54,911 36,911 $ 30,198.42 0.82 Sep -17 $ 0.85 27,000 $ 22,950.00 $ 53,148.42 63,911 36,911 $ 30,695.20 0.83 Csw:12/20/2C16 ATTACHMENT #4 CALCULATION OF USAGE & INFLATION ADJUSTMENT (UIA) FOR FY 2015/2016 Collected in FY 2016/2017 for Billings Beginning January 1, 2017 Usage Adjustment Calculations: 1. Residential Single- Family Natural Gas Use /Customer: Average Number of Total FY 15/16 Therms Used FY 15/16 Customers Therm Usage Per Customer 17,419 3,300,530 189.5 Threshhold for application of UIA per Rate Ordinance = Less Than 197 Therefore, Residential Single Family Usage Adjustment = 3.97% Applicable FY 15/16 Total Residential Non -Fuel Energy Revenues = $ 1,724,871.46 Added FY 16/17 UAI Residential Revenues from Usage Shortfall = $ 68,467.97 2. Commercial (Non - Interruptible] Natural Gas Use /Customer: Average Number of Total FY 15/16 Therms Used FY 15 /16 Customers Therm Usage Per Customer 2,314 13,577,630 5867.6 Threshhold for application of UIA per Rate Ordinance = Less Than 6,203 Therefore, Commercial Single Family Usage Adjustment = 5.72% Applicable FY 15/16 Total Commercial (Non- Inter.) Non -Fuel Revs = $ 5,435,601.74 Added FY 16/17 UAI Commercial Revenues from Usage Shortfall = $ 310,704.87 Inflation Adjustment Calculations: Actual U. S. Dept. of Labor CPI -U for September 2015 = 237.945 Actual U. S. Dept. of Labor CPI -U for September 2015 = 241.428 CPI -U Inflation Increase Applicable to FY 16/17 Revenues = 1.464% Authorized UIA Recovery for FY 2016/2017: 1. Residential Single- Family Recovery for FY 2016/2017 Usage Portion = Inflation Portion = Subtotal = Less Proj. Over Rec. thru December 2016 = Total = 1 $ 72,006.36 I $ 68,467.97 S 25,248.39 $ 93,716.36 5 (21,710.00) Projected Therms & Gallons to Recover on for FY 16/17 = 2,810,000 Projected Residential UIA Recovery Required = 0.026 Recommend Round to = 0.03 2. Commercial (Non - Interruptible) Recovery for FY 2016/2017 Usage Portion = Inflation Portion = Subtotal = Less Proj. Over Rec. thru December 2016 = Total = I $ 365,465.32 1 S 310,704.87 79,565.45 390,270.32 (24,805.00) Projected Therms & Gallons to Recover on for Remainder of FY 16/17 = 8,594,000 Projected Commercial UIA Recovery Required = 0.043 Recommend Round to = $ 0.04 CSW:12/20/2016 Applicable Annual Therm Range or Other Rate Determinant Monthly Customer Charge (For Central Pasco Territory) Non -Fuel Energy ChargelTherm Non -Fuel Energy Charge Energy Conservation Adj. (ECA) Regulatory Imposition Adj. (RIA) Usage & Inflation Adj. (UTA) Total Non -Fuel Energy Charge Purchased Gas Adjustment (PGA) Total Energy ChargelTherm Minimum Monthly Bill (For Central Pasco Territory) Compares to LP /Gallon Rate of with 6.0% Franchise Change from 9/2014 Therm Rate % Change from 9/2014 Therm Rate Utility Tax Note: Fuel Rate per Therm 10/01/1973 Non - Utility Taxable Fuel /Therm CLEARWATER GAS SYSTEM NATURAL GAS RATE BILLING FACTORS FOR JANUARY 1, 2017 - SEPTEMBER 30, 2017 BASED ON APPROVED GAS ADJUSTMENT FACTORS Firm Natural Gas Rate Schedules RS SMF MMF LMF SGS MGS LGS RAC NA (1 - NA (4 + NA (4 + NA (4 + 3 Units) Units) Units) Units) $12.00 ($20.00) ($40.00) ($70.00) ($160.00) ($40.00) ($70.00) ($160.00) 0 - 18,000- 100,000 NA (1 - 17,999 99,999 & up 3 Units) $25.00 $40.00 $95.00 $25.00 $40.00 $95.00 $0.44 $0.44 0.15 0.15 0.09 0.09 0.03 0.03 $0.71 $0.71 0 76 0.76 1.47 1.47 $0.44 $0.44 $0.42 $0.38 0.15 0.15 0.15 0.15 0.09 0.09 0.09 0.09 0.03 0.03 0.04 0.04 $0.71 $0.71 $0.70 $0.66 0.76 0.76 0.76 0.76 1.47 1.47 1.46 1.42 $0.34 0.15 0.09 0.04 $0.62 0.76 1.38 GAC LAC SL SL w/M& Relight NA (0 - NA (150 NA NA 149 tons) tons & +) NGV (Non -Rest) NA Interr. NG Rate NSS IS (Non -Resl) NA 100.000 & up $12.00 $25.00 $40.00 $20.00 $20.00 By Contract $50.00 $250.00 ($20.00) ($40.00) ($70.00) ($30.00) ($30.00) (By Contract) ($75.00) $400.00 if not prey. if not prey. if not prey. billed billed billed $0.20 NA NA NA $0.20 0.76 $0.15 $0.10 NA NA NA NA NA NA $0.15 $0.10 0.76 0.76 0.96 0.91 0.86 $12.00 $25.00 $40.00 $95.00 $25.00 $40.00 $95.00 $12.00 $25.00 $40.00 ($20.00) ($40.00) ($70.00) ($160.00) ($40.00) ($70.00) (S160.00) ($20.00) ($40.00) ($70.00) @ premise @ premise @ premise $ 1.35 S 1.35 $ 1.35 $ 1.35 $ 1.34 $ 1.30 $ 1.26 $ 0.88 $ $ 1.43 $ 1.43 $ 1.43 $ 1.43 $ 1.42 $ 1.38 $ 1.34 $ 0.93 $ $0.20 $0.35 By Contract $0.24 NA NA NA NA NA NA NA NA NA NA NA NA $0.20 $0.35 By Contract $0.24 0.76 0.76 0.67 0.76 0.67 0.96 1.11 0.67 1.18 0.91 + Non -Fuel $20.00 $20.00 By Contract $50.00 $250.00 ($30.00) ($30.00) (By Contract) ($75.00) $400.00 + FAC + FAC + FAC + FAC + Non -Fuel Therm Rate for Contract # of Therms 0.83 $ 0.79 $ 0.88 $ 0.88 $ 0.83 $ 0.93 $ 1.02 $ 1.08 $ $0.42 NA NA NA $0.42 0.61 $ 1.08 $ 0.83 0.65 $ 1.14 $ 0.88 $ (0.28) $ (0.28) $ (0.28) $ (0.28) $ (0.25) $ (0.23) $ (0.21) $ (0.18) $ (0.18) $ (0.18) $ (0.18) $ (0.18) $ (0.18) $ (0.22) $ (0.22) -12.4% -12.4% -12.4% -12.4% - 11.6% -11.0% -10.3% -9.6% -9.8% -10.1% -9.6% -9.1% -10.1% -10.2% -12.6% $0.069 $0.069 $0.069 $0.069 $0.069 $0.069 $0.069 $0.069 $0.069 $0.069 50.069 50.069 $0.691 50.691 $0.691 $0.691 $0.691 $0.691 $0.691 $0.691 $0.691 $0.691 $0.691 $0.691 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 1.050 1.044 1.045 Interruptible Service Rates 1 .027 1.030 1.024 1.025 $0.069 $0.069 50.055 $0.601 $0.691 $0.615 FY 16/17 Avg. 1.047 1.027 Attachment #5 Contract NG Rate CNS NA By Contract (By Contract) By Contract NA NA NA By Contract 0.67 0.67 + Non -Fuel Customer Charge + Non -Fuel Therm Rate for Contract # of Therms $ (0.18) -123% $0.069 $0.601 C S W:12/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 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.15 0.09 0.03 Total Non -Fuel Charges (NF) /Gal. $2.17 Purchased Gas Adjustment(PGA) /Gal. 1.69 Total Energy Charges /Gallon $3.86 Minimum Monthly Bit $12.00 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 0.161 $1.529 ($0.31) -7.5% $1.90 0.15 0.09 0.03 $2.17 1.69 $3.86 $25.00 0.161 $1.529 ($0.31) -7.4% CLEARWATER GAS SYSTEM METERED PROPANE (LP) RATE BILLING FACTORS FOR JANUARY 1, 2017 - 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.03 $1.17 1.69 $2.86 $12.00 0.161 $1.529 ($0.31) -9.8% SMALL COML. LARGE COML. MGLP MLLP 0 - 2,500 $25.00 $0.30 0.15 0.09 0.04 $0.58 1.69 $2.27 $25.00 0.161 $1.529 >2,501 $40.00 $0.25 0.15 0.09 0.04 $0.53 1.69 $2.22 $40.00 0.161 $1.529 ($0.28) ($0.28) -11.0% - 11.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 Contract PGA - 0.161 NA NA Attachment #6 Page 1 of 2 STANDBY /GENERATOR CONTRACT MTRD LPSM CLP (Non -Rest. Only) NA NA (Closed for New Resl. Applications) $50.00 Set By Contract $1.00 NA NA NA $1.00 1.69 $2.69 $50.00 0.161 $1.529 ($0.25) -8.5% Set By Contract NA NA NA Set By Contract 1.39 Contract NFE + $1.390 Customer Charge + Non -Fuel Energy Chg. for the Contracted # of Gallons /Mo. 0.161 Contract PGA - 0.161 NA NA CS W:12/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 CLEARWATER GAS SYSTEM BULK PROPANE (LP) RATE BILLING FACTORS FOR JANUARY 1, 2017 - SEPTEMBER 30, 2017 BASED ON APPROVED GAS ADJUSTMENT FACTORS STANDARD RESIDENTIAL BULK LP SERVICE RESIDENTIAL "WILL CALL" (Rate Class is Ilased on Annual LP Gallon Usage Level) (Based on Annual Usage Level) BRLPO BRLP1 BRLP2 BRLP3 BRLP4 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 13 UN11S 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 6 350.00 $ 210.00 $ 150.00 $ 75.00 $ 60.00 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 BULK STANDBY/ GENERATOR LPSB (Closed for New Residental Applications) $ 420.00 Non -Fuel Charges (NF)/Gallon: Non Fuel Energy Charge (NH I) /Gal. $ 1.80 $ 1.80 $ 1.60 $ 1.00 $ 0.90 $ 1.80 $ 1.80 $ 1,60 $ 0.90 $ 0.80 $ 0.25 $ 0.20 $ I Inergy Conservation Adj. (I CA)IGaI $ 0,15 $ 0.15 $ 0.15 0.15 0.15 0.15 0.15 0.15 0.15 0,15 0.15 0.15 Regulatory Imposition Adj. (RIA) /Gal S 0.09 $ 0.09 $ 0.09 0.09 0.09 0.09 0.09 0.09 0.09 0.09 0.09 0.09 Usage & Inflation Adj. (UTA) /Gabon 0.03 0.03 0_03 0.03 0.03 0.03 0.03 0.03 0.03 0.03 0.04 0.04 Total Non -Fuel Charges (NF) /Gal. $ 2.07 $ 2.07 5 1.87 $ 1.27 $ 1.17 $ 2.07 $ 2.07 $ 1.87 $ 1.17 $ 1.07 $ 0.53 $ 0.48 $ Purchased Gas Adj. (PGA)/Gallon $ 1.69 $ 1.69 $ 1.69 $ 1.69 $ 1.69 $ 1,69 $ 1.69 $ 1.69 $ 1.69 $ 1.69 $ 1.69 $ 1.69 Total Energy Charges /Gallon $ 3.76 $ 3.76 $ 3.56 $ 2.96 $ 2.86 $ 3.76 $ 3.76 $ 3.56 $ 2.86 $ 2.76 $ 2.22 $ 2.17 $ Note: No Monthly Minimum 13i11 Utility Tax Note: I aol Rate per Gallon 10 /01/1973 $ 0.161 $ 0.161 $ 0.161 $ 0.161 $ 0.161 $ 0.161 $ 0.161 $ 0.161 $ 0.161 $ 0.161 $ 0.161 $ 0.161 $ Non Utility Taxable Fuel /Gallon $ 1.529 $ 1.529 $ 1.529 $ 1.529 $ 1.529 $ 1.529 $ 1,529 $ 1.529 $ 1.529 $ 1.529 $ 1.529 $ 1.529 $ Change from 9/2014 Gallon Rate $ (0.310) $ (0.310) $ (0.310) $ (0.31) $ (0.31) $ (0.11) $ (0.11) $ (0.31) $ (0.31) $ (0.41) $ (0.28) $ (0.28) $ % Change. from 9/2014 Gallon Rale -7.6% -76% -8.0% -9.5% -9.8% -2.8% -2.8% -8.0% -9.8% -12.9% -11.2% -11.4% 1.00 NA NA NA 1.00 $ 1.69 2.69 Attachment 96 Page 2 of 2 CONTRACT BULK LP SERVICE CLP Any Contract Customers Who Requests Bulk Del. Set by contract Sot Ily Contract NA NA NA Set By Contract 1.39 Cotract NFE+ 1.390 0.161 $ 0.161 1.529 Contract PGA 0.161 (0.25) -8.5% NA NA CSW:S 2/20/2C"6 Attachment #7 Page 1 of 4 Residential Rate History By Components Clearwater Gas System Total Rate Adiustments/Therm Contract LP Month NG /therm LP /gallon * ECA RIA# WNA/UTA -Rest# UTA -Coml# PGA PGA PGA/gallon Oct -16 S 1.48 $ 3.09 Nov -16 $ 1.48 $ 3.09 Dec -16 $ 1.48 $ 3.09 Jan -17 $ 1.47 $ 2.96 Feb -17 Mar -17 Apr -17 May -17 J_ un -17 Jul -17 Aug -17 Sep -17 $ 0.15 $ 0.09 S $ 0.15 S 0.09 $ $ 0.15 $ 0.09 $ $ 0.15 $ 0.09 $ 0.01 S 0.01 $ 0.79 $ 0.70 $ 0.01 S 0.01 S 0.79 $ 0.70 $ 0.01 $ 0.01 $ 0.79 $ 0.70 $ 0.03 $ 0.04 $ 0.76 $ 0.67 $ 1.84 1.84 1.84 1.69 FY 16117 Avg. $ 1.478 1 $ 3.058 2016 Avg. $ 1.452 1 $ 2.768 Incr. Above $ (0.12) $ 0.07 Last Year Same Month -8 %0 2% Incr. Based $ (4.80) $ 3.06 on 40 Therms -8 %1 3% Equivalent- Cents /KWH 5.0 11.0 for Gas vs. Duke Rate (Residential) $ 0.783 $ 0.693 1 $ 1 $ 0.150 1 $ 0.090 1 $ $ 0.167 11 $ 0.106 1 $ 0.010 1 $ 0.010 $ 0.729 1 $ 0.639 $ 0.015 1 $ 0.018 $ (0.01)1 $ (0.01) $ 0.02 $ 0.03 r $ (0.12)1 $ (0.12) $ -6 %' -10% 200% 300 %I -14 %1 l -15% 1 1.803 1.486 0.07 12.3 12.3 Note: Duke Energy Florida's residential rate for usage >1,000 KWH in August 2016 is 12 334 cents /KWH. Gas Cheaper by -59% -10% Notes: Based on Bulk LP (BRLP3) which is applicable for customers using 120..1 - 300 gallons /year & equal to Residential LP Will Call (BRWCLP). # New rates implemented 11/1/2014, with following changes: i , i 1 I - RS NG Customer Charge increased $2 from $10 to $12 /month & NFE rate droped 4 cents to 44 cents /therm. UTA decreased by 9 cents /therm to 0. 9 ey n9 @ Y unchanged @ -- g decreased by 9 cents /gallon to 0. 1- _BRLp3_LP.Cu.stom. RIA & ECA unchanged unchanged $90/ earl and NFE rate unchan ed S1 00/ allon. UTA decrea CSW. 2/X12616 Residential Rate History By Components Clearwater Gas System Attachment #7 Page 2 of 4 Total Rate AdiustmentslTherm Contract LP Month NG /therm LP /gallon ECA RIA# , WNA/UTA -Rest# UTA -Coml# PGA PGA PGA/gallon 1.99 1.99 1.99 1.99 1.92 1 92 1.85 1.85 1.85 1.85 1.85 1.85 $ 0.14 , $ 0.05 $ 0.08 $ 0.06 $ 0.73 $ 0.63 $ $ 0.14$ 0.05I$ 0.08;$ 0.06 $ 0.73 $ 0.63'$ $ 0.14 $ 0.05 $ 0.13 $ 0.06 $ 0.73 $ 0.63 S S 0.14I$ 0.051I$ 0.13 5 0.06 $ 0.73 $ 0.63,$ $ 0.13 { $ 0.08 f $ 0.16 5 0.06 $ 0.71 $ 0.61 $ S 0.13 1 $ 0.08 $ 0.16 $ 0.06 $ 0.71 $ 0.61 i $ $ 0.13 1 $ 0.08 1 5 0.16 $ 0.06 $ 0.75____$ 0.65 1 $ } $ 0.06 $ 0.75 5 0.65 ! $ $ 0.151$ 0.110 5 0.131$ 0.06 _$ 0.79 $ 0.6911$ $ 0.15I$ 0.10 $ 0.13!$ 0.06 $ 0.79 $ 0.691$ $ 0.15i$ 0_101$ 0.13j$ 0.06 $ 0.81 $ 0.71 $ $ 0.077 $ 0.132 5 0.06 $ 0.81 $ 0.71 $ $ 0.15 1 $ 0.10 1 $ 0.13 FY 12/13 Avg. $ 1.582 $ 3.257 I $ 0.140 $ 0.060 1 $ 0.753 $ 0.653 $ 0.073 $ 0.067 1 $ 0.785 $ 0.700 I $ 2.312 Oct -12 $ 1.48 $ 3.26 Nov -12 $ 1.48 $ 3.26 Dec -12 $ 1.53 $ 3.31 Jan -13 $ 1.53 j 5 3.31 Feb -13 $ 1.56 $ 3.29_ Mar -13 $ 1.56 1 $ 3.29 Apr -13 $ 1.60 $ 3.22 May -13 $ 1.60 $ 3.22 Jun -13 $ 1.65 $ 3.23 Jul 13 $ 1.65 $ 3 23 Aug -13 $ 1.67 $ 3.23 Sep -131 $ 1.67 $ 3.23 1 2012 Avg. $ 1.501 $ 3.548 $ 0.133 $ 0.031 $ 1.908 Oct 13 $ 1.70 I_ $ 3.45 Nov -13 $ 1.70 $ 3.45 Dec -13 $ 1.66 j $ 3.41 Jan 14 $ 1.69 I $ 3.52 Feb 14i $ 1.68 $ 3.70 Mar -14 $ 1.70 $ 4.27 Apr -14, $ 1.70 $ 4.27 May -14 $ 1.75 I $ 3.27 Jun -14 $ 1.75 $ 3.27 Jul -14 $ 1.75 $ 3.27 Aug -14 $ 1.75 $ 3.27 4 S 0.14 $ 0.10 $ 0.13 $ 0.06 5 0.85 $ 0.76 $ 2.08 $ 0.14 5 0 10 $ 0.13 $ 0.06 $ 0.85 $ 0.76 $ 2.08 $ 0.14 $ 0.10 $ 0.09 1 $ 0.07 $ 0.85 $ 0.76 $ 2.08 $ 0.14 $ 0.10 $ 0.09 ! $ 0.07 $ 0.88 $ 0.79 $ 2.19 0.10 $ 0.14 $ 0 10 $ 0.09 $ 0.07 $ 0.87 $ 0.78 $ 2.37 $ 0 :07 $ 0 _89 $ 0.80 $ 2.94 $ 0.14 $ 0.10 $ 0.09 r $ 0.07 $ 0.89 1 $ 0.80 $ 2.94 $ 0.14 I $ 0.10 $ 0.09 $ 0.07 t $ 0.94 $ 0.85 $ 1.94 $ 0.14 $ 0.10 $ 0.09 $ 0.07 $ 0.94 $ 0.85 $ 1.94 $ 0.14 1 $ 0.10 $ 0.09 $ 0.07 $ 0.94 i $ 0.85 $ 1.94 $ 0.14 $ 0.10 $ 0.09 $ 0.07 $ 0.94 $ 0.85 $ 1.94 $ 0 14 S 0 10 S 0 09 $ 0.07 $ 0.94 $ 0.85 $ 1.94 ep -141 a 1.13 ! a a.ci FY 13/14 Avg. j $ 1.715 1 $ 3.535 $ 0.140 !1 $ 0.100 $ 0.097 $ 0.068 1 $ 0.898 $ 0.808 1 $ 2.198 2013 Avg. $ 1.629 $ 3.297 1 $ 0.140 $ 0.089 $ 0.137 $ 0.061 { $ 0.783 1 $ 0.686 1 $ 1.931 _- Nov-14 $ 1.65 S 3.38__., r 1. Dec -14 $ 1.65 � $ 3.38 Jan 15 $ 1.65 $ 3.38 Mar -15 $ 1.57 i $ 3 03 Apr-15 $ 1.54 $ 3.03 May -15 $ 1.54 1 $ 3.03 Jun -15 $ 1.53 $ 2.98_ Jul -15 $ 1.53 $ 2.98 Au 15 $ 1.57 1 $ 2.86 Aug-15 Sep -15 $ 1.57 j $ 2.86 I � 04 $ 0.12 0.12 0.14 0.12. $ S _ $ 0.12 0.14 S 0.10 $ 0.14 $ 0.12 $ 0 14 $ 0.13 $ 0.10 $ 0.135 0.105 $ 0.14 - $ 0.10 $ 0.14 } $ 0.10 $ 0.15 $ 0.10 -- $ 0.15 ',S 0.10 $ .0 $ 0.07. $ 0.95 . $ 0.85 1 $ 2.12 $ 0.09 � $ I $ 0 95 5 0.85 �. S 2.12 - 1 $ - $ 0.95 $ 0.85 $ 2.12 $ 1- _ - - . $ I$ $ o. $ 0.02 $ 0.93$ 0.85 $ 2.12 $ 0.01 $ 0.83 $ 1.94 $ 0.01 S 0.02 S 0.89 $ 0.79 $ 1.79 1 $ 0.01 $ 0.02 $ 0.86 $ 0.76 $ 1.79 0.015 0.025 0.86 $ 0.76 1 $ 1.79 $ 0.01 $ 0.02 $ 0.84 $ 0.74 • $ 1.73 $ 0.01 $ 0.02 ' $ 0.84 $ 0.74 $ 1.73 $ 0.01 $ 0.02 $ 0.87 : $ 0.77 $ 1.60 - 1.60 5 0.01 5 0.02 0.87 0.77 FY 14/15 Avg. j $ 1.602 $ 3.133 1 $ 0.139 $ 0.108 $ 0.014 ' $ 0.019 $ 0.897 1 $ 0.797 j $ 1.871 2014 Avg. $ 1.717 ! $ 3.528 $ 0.140 $ 0.105 $ 0.075 $ 0.058 $ 0.923 $ 0.831 $ 2.208 Oct -15' $ 1.59 $ 2.89 Nov-15 $ 1.59 $ 2.89 Dec-151 $ 1.59 $ 2.89 Jan -161 $ 1.59 $ 2.89 Feb -161 S 1.54 $ 2.77 1 Aar -16 i $ 1.41 $ 2.67 p May -16 $ 1.38 $ 2.57 Jun 16 $ 1.38 $ 2.57 Jul 16 $ 1.38 $ 2.57 Aug-16; $ 1.38 9 Sep -16, 5 1.38 , $ 2.57 ' 5 0.16 0.10 $ 0.01 $ 0.02 $ 0 88 $ 0.79 $ 1.62 S 0.01 $ 0.02 $ 0.16 , $ 0.10 $ 0.79 I, $ 1.62 5 0.16 $ 0.105 0.01 $ 0.02 $ 0.885 0.79 , 5 _ 1.62 $ 0.16 1 5 0.10 1_ S 0.01 $ 0.01 $ 0.88 $ 0.79 ! 5 1.62 $ 0.14: $ 0.10 $ 0.01 $ 0.01 $ 0.85 $ 0.76 I $ 1.52 $ 0.70 $ 0.61 $ 1.52 S 0.16 $ 0 102 $ 0.01 $ 0 01 $ 0.85 $ 0.76 0.01 0.62 $ 0.53 $ 1.40 $ 0.10 0.01 $ 0.01 $ $ 1.25 $ 0.19 , $ - $ 0.01 $ 0.01 $ 0.62 $ 0.5 S 0.19 $ 0.12 $ 0.01 $ 0.01 $ 0.62 $ 0.53 1 5 1.25 � $ 0.19 . 5 0.12 0.01 $ 0.53 $ 1.25 $ 0.19 _ $ 0.12 5 0.01 $ ,$ 0.62 ,S 1.25 S 0.62 $ 0.53 ' $ 1.25 ',$ FY 15/16 Avg. 1 $ 1.479 $ 2.718. $ 0.169 $ 0.108 $ 0.010 $ 0.013 $ 0.752 $ 0.662 1.431 9 2015 Avg. $ 1.576 $ 3.003 1 � $ 0.144 $ 0.103 $ 0.009 $ 0.018 $ 0.879 $ 0.782 $ 1.746 CSW:12/20/2016 Attachment #7 Page 3 of 4 Competitive History of NG vs. Electric Rates NG Equivalent Progress Energy NG vs. Month -Year NG Therm Cost KWH Cost KWH Cost Electric September 2001 $ 1.34 $ 0.046 $ 0.084 -46% September 2002 $ 1.36 $ 0.046 $ 0.074 -37% September 2003 $ 1.56 $ 0.053 $ 0.084 -37% September 2004 $ 1.69 $ 0.058 $ 0.089 -35% September 2005 $ 1.97 $ 0.067 $ 0.097 _31% September 2006 $ 1.89 $ 0.065 $ 0.119 -46% September 2007 $ 1.86 $ 0.063 $ 0.120 -47% September 2008 $ 2.12 $ 0.072 $ 0.120 -40% September 2009 $ 1.39 $ 0.047 $ 0.132 -64% September 2010 $ 1.39 $ 0.047 $ 0.136 -65% September 2011 $ 1.42 $ 0.048 $ 0.129 -62% September 2012 $ 1.48 $ 0.051 $ 0.132 -62% September 2013 $ 1.67 $ 0.047 $ 0.123 -62% September 2014 S 1.75 $ 0.047 $ 0.123 -62% September 2015 $ 1.57 $ 0.047 $ 0.123 -62% September 2016 $ 1.38 $ 0.047 $ 0.123 -62% $ Increase over Last 15 Years S 0.04 $ 0.001 $ 0.039 % Increase over Last 15 Years 3.0% 2.8% 46.4% Avg. Annual Inc. Over Last 15 Yrs. 0.2% 0.2% 3.1% CSW:12/20/2016 Attachment #7 Page 4 of 4 Annual Average CGS Residential Rates Calender Year Year 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 Fiscal Year NG/Therm LP /Gallon * t Year NG /Therm LP /Gallon * NA NA FY 95/96 $ 0.880 f $ 1.199 " $ 0.915 $ 1.239 * FY 96/97 $ 1.019 $ 1.370 * 1.049 $ 1.23 * FY 97/98 $ 1.054 $ 1.318 * $ 1.032 $ 1.288 1* FY 98/99 $ 1.052 $ 1.269 $ 1.073 $ 1.311 FY 99/00 $ 1.152 $ 1.504 $ 1.222 $ 1.584 FY 00/01 $ 1.551 $ 1.649 $ 1.549 1,$ 1.586 FY 01/02 $ 1.352 $ 1.488 $ 1.342 1 $ 1.553 FY 02/03 $ 1.477 $ 1.817 $ 1.534 $ 1.864 FY 03/04 $ 1.603 $ 1.913 1.652 $ 1.968 FY 04/05 $ 1.803 $ 2.162 !, 1.925 $ 2.278 1 FY 05/06 $ 2.080 $ 2.480 2.012 $ 2.501 FY 06/07 $ 1.918 $ 2.742 $ 1.893 $ 2.869 FY 07/08 $ 1.932 $ 3.183 $ 1.965 $ 3.186 FY 08/09 $ 1.610 $ 2.524 2009 $ 1.464 $ 2.418 1FY 09/10 $ 1.437 $ 2.865 2010 $ 1.457 $ 2.946 ; FY 10/11 $ 1.475 $ 3.282 2011 $ 1.487 $ 3.438 I FY 11/12 $ 1.506 $ 3.639 2012 $ 1.501 $ 3.548 1 FY 12/13 $ 1.582 $ 3.257 2013 $ 1.629 $ 3.297 FY 13/14 $ 1.629 S 3.297 2014 $ 1.717 $ 3.528 1FY 14/15 S 1.602 ? $ 3.133 2015 $ 1.576 $ 3.003 I FY 15/16 $ 1.479 $ 2.718 2016 $ 1.452 $ 2.768 I 9 I Average 1.497 $ 2 $ .360 $ 1.485 $ 2.324 Notes: * Based on the Residential Metered Propane schedule which was closed for new customers effective March 8, 1999. For 1999 & FY 99/00 and beyond based on Bulk LP (BRLP3) which is applicable for customers using r 120.1 - 300 gallons /year & is equal to Residential LP Will Call