Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
GAS ADJUSTMENTS EFFECTIVE AUGUST 1, 2022
Clearwater Gas System Lwe Greener with as TO: Mr. Jon Jennings, City Manager FROM: Brian Langille, Interim Directo COPIES: Micah Maxwell, Assistant City Manager; Rosemarie Call, City Clerk; CGS & UCS Management Teams; UCS Billing Team SUBJECT: GAS ADJUSTMENTS EFFECTIVE AUGUST 1, 2022 DATE: July 27, 2022 JUL 29 2022 Natural Gas supply prices have been trending higher over the past 12 months; therefore, I'm recommending a 5¢/therm increase in our Natural Gas Purchase Gas Adjustments (PGA) in August. In contrast, our Propane (LP) supply prices have continued to drop; therefore, I'm recommending a 15¢/gallon decrease for our Propane (LP) PGA for August. We are continuing our Contract LP PGA at 30¢ below our standard LP PGA. We are not recommending any changes in our Energy Conservation Adjustment (ECA), our Usage & Inflation Adjustments (UTA), nor our Regulatory Imposition Adjustment (RIA) for August. Therefore, the net effect of these recommended changes for August is a 5¢ per therm increase (+3.3%) in our typical Residential Natural Gas customer's therm rate and a 15¢ per gallon decrease (-5.1%) in our typical Residential LP customer's energy rate. Therefore, we are recommending your approval of the following rates to become effective for billings rendered on and after August 1, 2022: Natural Gas Firm Standard Rate Schedule PGA Natural Gas Interruptible and Contract (Non -Standard) Rate Schedule PGA Propane (LP) Gas Standard Rate Schedule PGA Propane (LP) Gas Contract Rate Schedule PGA Energy Conservation Adjustment (ECA) Regulatory Imposition Adjustment (EIA) Usage & Inflation Adjustment (UTA) - Residential - Commercial $0.98 per therm (up 5¢) $0.89 per therm (up 5¢) $1.65 per gallon (down 15¢) $1.35 per gallon (down 15¢) $0.16 per therm or gallon (no change) $0.01 per therm or gallon (no change) -$0.01 per therm or gallon (no change) $0.05 per therm or gallon (no change) Mr. Jon Jennings, City Manager July 27, 2022 Page 2 Attachment #1 shows the status of our Adjustment Recovery Clause balances with actuals thru June and projections thru FYE 22. 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. We will continue to track these balances each month, make monthly projections of these factors based on market conditions, and let you know if any of these get significantly out of balance. Additionally, we are recommending no change to our Natural Gas Vehicle (NGV) Fueling Station pump price, which is currently $2.19/GGE. Jon, I recommend your approval of these revised adjustment rates so that we can get this information to Utility Customer Service (UCS) so that they may make the appropriate adjustments in the billing formulas in time for the August 1 billings. If you have any questions on this, please let me know. Attachments Approved: BDUbI Jon Jennings, City Manager er CLEARWATER GAS SYSTEM SUMMARY OF RAT ADJUSTMENT CLAUSE.COLLECTIOIQ5 Attachment 81 NATURAL GAS PURCHASE9 GAS ADJUSTMENT (PGA -NG), I Monthty Overage AShortaga) 1 Cumulative YTD Overage (Shortage) $ (125,481.12) $ (289,118.89) NG PGA Rate/Therm Firm/Conti Therms Billed Rec/Therm Budget Reservation Commodity Personal Services Interfund Svc charge Dividend Other Prior YEAR Write off Interest Ex. nse Cost Center Expenses Total NG Fuel Expenses - Total NO PGA Billed Month Charm Charges Prior Year 0.73/0.84 0.73/0.64 0.76/0.87 0.76/0.87 0.78/0.87 0.83/0.74 0.83/0.74 1,950,000 0.85 Oct -21 $ 135,111.47 1,097,913.43 $ 31,869.35 $ 123,183.33 $ - $ 5,976.81 9,559.39 $ 313.85 $ 170,568.88 $ 1,403,907.43 $ 1,280,249.86 $ (143,657.57) Nov -21 $ 226,434.85 1,480,071.57 $ 22,971.06 $ 123,163.33 $ - $ 15,781.23 $ 872.80 $ 161,915.62 $ 1,849,094.84 1,347,738.67 1,870,948.17 $ (501,356.1n, $ 230,155.73 $ 1770,474.8SL $ (540,319.13) $ (1,803,937.84) $ (2,469,207.84) $ (2,213,860.54) 2,080,000 2,440,000 2,516,981 2,799,025 2,497,837 2,484,188 0.85 0.88 0.88 0.88 0.75 0.75 Dec -21 $ 231,062.53 1,051,408.67 $ 25,015.81 $ 123,183.33 $ - $ 8,216.11 $ 1,928.19 $ 156,395.05 $ 1,440,792.44 Jan -22 $ 235.885.21 2,089,055.81 $ 22,987.92 $ 123,183.33 $ 525,000.00 $ 18,314.01 $ 1,350.80 $ 887,485.26 $ 2,993,757.08 1,730,138.36 $ (1,283,818.72) $ (665,289.79) Feb -22 $ 212,380.00 1,356,235.10 $ 23,118.87 $ 123,183.33 $ 882,420.00 $ 8,139.30 $ 4,509.84 $ 1,016,839.50 $ 2,589,964.44 1,924,894.85 Mar -22 $ 223,374.41 1,237,267.94 $ 28,015.00 $ 123,183.33 $ - $ 17,483.83 $ 6,173.02 $ 166,681.96 $ 1,833,477.33 1,889,024.43 $ 255,547.10 Apr -22 $ 37,387.30 887,875.07 $ 25,301.30 $ 123,183.33 $ - $ 20,827.85 $ 5,534.15 $ 189,292.28 $ 1,100,088.80 1,846,563.80 $ 748,475.00 $ (1,4137,185.54) May -22 $ 118,996.54 1,417,347.82 $ 14,411.10 $ 123,163.33 $ - $ 15,064.24 $ 3,667.96 $ 152,838.67 $ 1,892,650.99 1,787,261.88 $ 94,610.89 $ (1,372,574.85) 0.95/0.86 1.03/0.94 0.93/0.84 0.900049 .0.88)0.139 2,159,299 2,027,036 +Z _ ,. 0.87 0.95 0.85 Jun -22 $ 111,910.92 1,178,943.40 $ 9,992.69 $ 123,183.33 $ - $ 20,560.82 $ 3,431.44 $ 153,716.84 $ 1,448,002.40 1,808,869.14 $ 380,8688.74 $ 211,225.49 $ (1,011,90791) $ (800,682 42) 5 (579.71824) Jul -22 $ 94,400.00 1,231,844.74 $ 25000.00 $ 125,000.00 $ - $ 10,000.00 $ - $ 2,529.77 $ 160000.00 $ 1,488,774.51 1,700,000.00 Aug -22 5 94A00 00 1,322634.11 $ 25,000.00 $ 125000.00 S - $ 10000.00 $ • $ 2.001.71 $ 160,000.00 S 1,579,035.82 1,800,000.00 $ 220,964.18 Sep -22 S 89,30000 1,389,565.81 S 25,000. 00 $ 125,00000 $ - $ 10,000.00 $ - $ 144930 $ 160,000.00 $ 1640,315.11 1,800,000.00 $ 159,684.89 $ (420,03335) $ - $ (420,033.35) Total YTD $ 1,810,643.23 $ 15,700.163.48 I $ 276,680.90 $ 1,463,489.97 $ 1,387,420.00 $ 158,383.80 $ 9,559.39 $ 33,560.62 $ 3,315,493.88 $ 20,859,881.19 $ 20,585,288.96 $ (294,572.23) PROPANE tLP1 GAS PURE1ASED GAS ADJUSTMENT (PGA -LP) --(:os-E Cumuli -Wye YTD Overage -LP-PGA- P PGABudget Therm/Gal. Monthty Overage (Shortage) Budget Gallons Monthly Interfund Festivals & LP Yard Suburban Prior YEAR Interest Commodity Center Total LP Fuel Total LP PGA Month Sold WACOG Svc charge Dividend Fuel Evaporization Software Write off Ex • nse Charges Expenses Expenses Billed 7 (Shortage) 'l j,. $ (70,446.98) Prior Year 1.82/1.99 1.82/1.99 2.06/2.25 2.06/2.25 2.08/2.25 2.06/2.25 2.06/2.25 Oct -21 29,269.1 $ 1.55845 $ 5,273.33 $ - $ - $ 104.42 $ - $ 135.25 $ 188.79 45,814.43 5,513.00 $ 51,314.22 $ 55,584.40 $ 4,270.18 Nov -21 38,892.3 $ 1.57138 $ 5,273.33 $ - $ 882.03 $ - ' $ - $ 178.12 57,971.08 6,155.38 $ 84,302.58 73,183.48 $ 8,880.90 $ 19,639.05 $ (81,566.08) $ (41,927.03) $ (13,149.60) $ (51,515.931 $ (28,221.12) $ (8,855.05) Dec -21 34,480.5 $ 1.47593 $ 5273.33 $ - $ 128.80 $ 44.28 $ - $ 153.92 50,881.29 5,444.41 $ 58,459.61 76,098.88 Jan -22 44,042.7 $ 1.47224 $ 5,273.33 $ - $ - $ 22.08 $ - $ 104.82 84,841.42 5,295.41 $ 70,241.65 99,019.09 $ 28,777.44 Feb -22 38,623.5 $ 1.57821 $ 5,273.33 $ 57,863.00 $ - $ - $ - $ 32.87 57,799.57 63,136.33 $ 120,988.78" 82,602.44 $ (38,368.34) $ 23,294.81 Mar -22 51,518.1 $ 1.67506 $ 5,273.33 $ - $ 639.15 $ 33.50 $ - $ 128.79 86,295.91 5,945.98 $ 92,370.68 115,885.49 Apr -22 38,107.4 $ 1.58014 $ 5,273.33 $ $-_ 640.20 $ 151.89 $ - $ 70.55 80,215.03 6,065.22 $ 88,350.80 85,716.87 $ 19,368.07 May -22 44,143.0 $ 1.51683 $ 5,273.33 $ - $ 109.23 $ 27.30 $ - $ 22.14 68,948.60 5,409.88 $ 72,380.80 99,019.93 $ 26,839.33 $ 17,784.28 2.06/2.25 Jun -22 39,283.4 $ 1.50388 $ 5,273.33 $ - $ - $ 338.37 ! $ - $ (44.48) 59,077.52 40,500.00 5,811.70 5.750.00 $ 64,644.78 79,978.40 $ 46,167.21 48,60000 $ 15,331.64 $ 33,115.92 S 2.43279 S 35,548.71 1.83/2.00_, 1.65/1.80 ,415' ,-..`_ 1,OSi . Jul -22 27,000.0 S 1.50000 5 5,300.00 $ - $ 400.00 $ 50.00 5 S - $ (82.79) Aug -22 18,000 .0 5 1.50000 $ 5,300.00 $ - $ 400.00 $ 50.00 5 - $ - $ (88.87) 27,000.00 5,750.00 $ 32,661.13 29,70000 $ (2,961 13) S 32,587.581- Sep -22 27.000.0 $ 150000 5 5.300.00 $ - $ 40000 5 50.00 5 - $ - S (81 47) 40,500.00 5.75000 $ 46,168.53 44.550.00 5 (1,618.53) 5 30.969.05 P13 ' $ - $ 30,969.05 Total YTD $ 428,340.00 $ 1.54 $ 63,359.97 $ 57,883.00 $ 3,597.41 $ 871.64 $ - $ 135.25 $ 578.41 $ 857,624.85 $ 125,827.27 $ 784,030.53 t $ 889,716.74 f $ 105,686.21 ENERGY CONSERVATION DJUSTMENT MCI) ECA NG/Therm j 4 LP/Gal. 0.20/0.20 0.17/0.17 y Bud et 9 L Cumulative YTD Overage (Shortage) $ 3005.71 $ 74,811.23 $ 152,784.770.20/0.20 $ 185,488.23 I ! Month Personal Services Advertisln� Residential tt Builder ECA and Other Promotional Interfund Svc charge Dividend Other Operating Expenses SNEP Prior Year write off Interest Expense Total ECA Expenses Total ECA Billed Monthly Overage; (Shortage) 1 Prior Year - Oct -21 $ 109,883.48 $ 280.00 $ 50,625.00 ' $ 6,544.17 $ - $ 4,833.01 $ 9,933.46 8 3,153.88 $ (76.68) $ 185,178.32 $ 170,183.84 $ 242,223.48 $ 229,321.78 248,137.38 274,926.92 $ 44,145.48 $ 77,973.54 1 $ 32,703.46 I Nov -21 $ 79,769.33 $ 11,169.00 $ 55,125.00 $ 6,544.17 $ - $ 3,848.76 $ 13,894.61 $ X87.03) L Dec -21 $ 82,885.37 $ 8,189.00 $ 98,675.00 $ 6,544.17 $ - 8 3,688.44 $ 44,625.44 $ (381.96) Jan -22 $ 73,545.63 $ 9,596.00 $ 72,650.00 $ 6,544.17 $ - $ 11,228.77 $ 28,426.02 $ (463.72) $ 199,526.87 298,807.23 $ 97,280.38 1$ 282,788.80 0.17/0.17 ' Feb -22 $ 75,386.74 $ 1,248.00 $ 39,450.00 $ 8,544.17 $ 143,877.00 $ 10,087.78 $ 29,017.83 $ (706.92) $ 304,904.60 $ 335,231.27 $ 324,588.27 $ 291,922.30 $ 128,420.83 327,847.38 229,479.38 214,139.93 180,439.70 164,001.18 $ 22,742.76 ! $ 305,511.36 $ (105,751.89)).. $ 199,759.48 t- $ (110,428.34)1 $ 89,331.12 $ (111,482.80,) $ (22,151.48)} $ 35,580.33 1 $ 13,428.85 1 0.17/0.17 0.13/0.13 0.13/0.13 0.13/0.13 0.13/0.13 0:1880.10 016/0,18 Mar -22 $ 70,178.46 $ 2,372.00 $ 235,350.00 $ 8,544.17 $ - $ 3,256.06 8 18,296.38 $ (783.78) Apr -22 $ 73,154.89 $ 489.00 $ 175,475.00 $ 8,544.17 $ - $ 3,746.61 8 85,678.00 $ (499.40) May -22 $ 67,595.46 $ 474.00 $ 178,100.00 $ 6,544.17 $ - $ 17,595.80 $ 21,838.20 $ (223.33) Jun -22 $ 46,725.08 $ 8,510.00 $ 42,150.00 $ 6,544.17 $ - $ 7,613.84 $ 18,822.56 $ 55.38 Jul -22 $ 70,000.00 $ 2,000.00 S 150,000.00 S 6.800.00 S - ' S 7,000.00 5 30,000.00 S - $ (33.57) S 285,586.43 $ 265,530.34 280,000.00 $ 14,433.57' $ 27,862.42 Aug -22 $ 70,000.00 $ 2,000.00 $ 150,00000' $ 6,600.00 $ - $ 7,000.00 $ 30,000.00 $ - $ (6966) 280,000.00 $ 14,469.66 LS $ 14,505.83 i 42,33208) Sep -22 $ 70,000.00 $ 2,000.00 $ 150,000.00 $ 8,600.00 $ - $ 7,000.00 $ 30,000.00 $ - $ (105.83) $ 265,494.17 280,000.00 $ 56,837.91 r 0..16/0.16 $ - ; $ 56,837.911 Total YTD $ 889,122.44 $ 48,307.00 $ 1,395,600.004. $ 78,697.53 $ 143,877.00 $ 86,896.87 $ 338,530.48 $ 3,153.88 $ (3,458.48) $ 2,978,728.70 $ 3,004,900.84 $ 28,172.141 $ 3,004,900.84 ,_ t REGULATORY IMPOSITION ADJUSTMENT (RIA), ,EIA) (EIA) (EIA) • Prior Year write Insurance off { ORA Personal Svs ORA Other (ORA) Regulatory Interest Total RIA Total RIA Overage (Shortag _, $ - I i YTD Overage ' NG/Therm Interfund Svc Budget 1 charge Dividend Month Eap_enses , Expenses Expense Expenses - i Billed (Shortage) LP/Gal..-_ $ ., ---$8$7'0.811 PriorZear 1 $ 1,223.33 $ - $ - $ 973.83 $ 11,118.35 $ - 13,315.51 $ (75.95) $ 13,239.58 34,256.13 $ 21,016.57 $ 51,395.43 0.03/0.03 Nov -21 I $ 1,223.33 $ • $ - $ 8,054.28 $ - 9,277.51 $ (128.49) $ 9,149.12 37,226.48 $ 28,077.38 $ 79,472.79 1 0.03/0.03 t Dec -21 1 $ 1,223.33 $ - $ - 4 $ 8,125.23 $ - 9,348.56 $ (198.68) $ 9,149.88 16,326.53 $ 7,176.85$ 88,649.44 0.01/0.01 0.01/0.01 Jan -22 !, $ 1,223.33 $ - $ - $ 8,182.82 $ - 9,406.15 $ (216.62) $ 9,189.53 17,462.51 $ 8,272.98 1 $ 94,922.42 CLEARWATER OAS SYSTEM SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTION$ Attachment 81 Feb -22 I $ 1,223.33 I $ 110,840.00 $ - $ 8,189.96 $ - 120,253.29 , $ (237.31) $ 120,015.98 19,266.80 $ (100,749.18) $ (5,826.76)1 0.01/0.01 _ ; Mar -22 ;_$ 1,223.33 $ - $ - $ 8,189.97 $ - 9,413.30 $ 14.57 $ 9,427.87 17,828.08 $ 8,200.21 $ 2,373.451 S 8,748.22 0.01/0.01 0.01/0.01 t ! Apr -22 1,223.33 $ - $ - ' $ 10,886.61 $ - 12,109.94 $ (5.93) $ 12,104.01 16,476.78 $ 4,372.77 May -22 V$ $ 1,223.33 $ - ' $ I $ 7,401.61 $ - 8,624.94 $ (18.87) $ 8,808.07 13,881.40 +• $ 5,273.33 $ 12,019.55 ' 0.01/0.01 Jun -22 $ 1,223.33 t $ - $ $ 7,391.19 $ - 1 8,614.52 $ (30.05) $ 8,584.47 12,613.24 $ 4,028.77 $ 16,048.32. 0.01/0.01 Jul -22 $ 1,300.00 $ - +$ - $ - $ 15,000.00 $ 5,000.00 21,300.00'$ (40.12) $ 21,259.88 20,000.00 $ (1.259.88) $ 14,78844 0.01/0.01 i 1 1 Aug -22 $ 1,300.00 $ - , $ - $ - $ 15,000.00 $ 5,000.00 I 21,300.00 $ (38.97) $ 21,263.03 20,000.00 5 (1,263.03) $ 13,525.41 0.01/0.01 Sep -22 P13 $ 1,300.00 $ - $ - $ - $ 15,000.00 $ 5,000.00 21,300.004 5 (33 81) $ 21,266.19 ' 20,000.00 $ (1,266 19)4 $ - $ 12,259.22 ' $ 12,259.22 0 01/0.01 $ - - $ - $ 12,259.22 Total YTD $ 14,909.97 8 110,840.00 4$ - $ 122,540.02: S 15,000.00 I $ 264,263.82 $ (1,008.23) -401499.23 263,257.59 245,137.95 $ (18,119.84) ' _, 1 + USAGE AND INFLATION ADaJUSTMENT /UTA), Commercial >- _ _ _ _ _ _ Monthly Cumulative UTA Budget Interest Overage YTD Overage (Shortage) $ . `{080,018.28)' $ (576,311.28) NG/Therm LP/Gal Month LP Gallons Expense Rate/Gallon j NG Therms ate/Therm (Shortage) $ - Beg. Bal. . Oct -21 6,646.0 $ 3,402.57 0.13 821,489.80 0.13 104,201.98 0.13/0.13 L r 1 Nov -21 6,902.2 8 2,881.56 0.131 858,000.501 0.13 1,071,048.40 t" 0.05 109,546.76 51,900.15 $ (468,764.51) $ 5414,884.37) $ 5359,998.63) $ 5302,582.29) $ (247,130.11) $ (193,108.18) 0.13/0.13 0.05/0.05 j-, 0.05/0.05 II 0.05/0.05 0.05/0.05 0.05/0,05 1 Dec -21 7,111.3 $ 2,333.82 0.05 Jan -22 8,490.3 $ 2,074.32 0.05 1,132,515.20{1 1,171,969.301 1,130,801.80 1,097,440.40 0.05 0.05 0.05 0.05 54,887.74 57,414.34 55,452.18 54,023.93 Feb -22 8,731.3 $ 1,799.98 0.054 -1 Mar -22 8,608.8 $ 1,512.91 0.05 0.051 Apr -22 7,707.9 $ 1,235.65 Ma_ '22 Jun -22 Jul -22 Jul -22 7,352.7 $ 865.53 0.05 927,608.80 0.05 45,492.74 $ (147,613.44) 0.05/0.05 _r 8,487.4 $ 738.07 0.05 880,975.801 0.05 43,840.61 $ (103,972.83) 0.05/0.05 ! 4 1- - 7,000.0 $ 519.86 0.05 900,000.00 r 005 44,830.14 $ (59,142.69) 0.05/0.05 - Aug -22 8,0000 $ 295.71 0.05 850,000.001 0.05 42.504 29 $ (16,638 41) 0.05/0.05 Sep -22 6,500.0 $ 83.19 0 05 850,000 00 1 0.05 42,741.81 $ 26.103.40 0.05/0.05 •4 1- 1 , + l _- Per 13 _ _ f$ 26,103.40 ___„-- _ Total YTD (1) 83,537.9 Per CalculaSon,of INFLATION ADT)US 17,843.18 VIA Att.chmM!171aaFY21undeftover TM NT IA E (U collection 8012 11,691,829.60 I 40.24, FY21 sndsti the year wl()i$Q)T.77$.02) $ 706,616.66 Monthly 4 , i - USAGE AND Cumulative YTD Overage UTA NG/Therm 1 LP/Gal _ 0.00/0.00 0.00/0.00 -0.01/-0.01 -0.01/-0.01 -0.01/-0.01 -0.01/-0.01 4 _ _ Residential I Budget Month 11 Interest 1 Overage LP Gallons Expense Rate/Gallon i NG Therms Rate/Therm Shortage) (Shortage) 8 ` 68,884.21 ' $ 56,962.24 Beg. Bal.$ Oct -21 22,609.8 $ (283.42) - 1_ _ 297,240.70 - t $ 278.03 Nov -21 29,984.7 $ (284.81) (0. 01) 345,937.50 510,883.801 569,410.90 - 718,553.80 578,913.80 - (0.01) (-0.01) (0.01) (0.01) $ 274.78 S (5,088.41) $ (5,834.38) $ )7,285.52) $ (6,034.10) $ 57,237.02 $ 52,150.81 $ 48,316.23 $ 39,050.71 $ 33,018.82 f l , -1- j 1f _ Dec -21 27,338.4 $ (286.19) Jan -22 37,541.6 $ (280.75) (0.01)' (0.01) (0.01) Feb -22 29,878.7 $ (231.58) Mar -22 42,901,2 $ (195.25)1 Apr-22 30,383.3 $ (185.08) (0.01) $ (138.79) (011) 511,581.10 (0.01)1 $ (5,259.02) 418,185.50 (0.01) $ (4,387.32) $ 27,757_60 $ 23,370.28 •0.01/•0.01 I May -22 38,779.5 -0.01/•0.01 ; _i Jun -22 32,782.5 20,0000 $ (116.8),, (0.01) $ (98.68) (0.0)) 341,205.401 (0.01) $ (3,839.13) $ 19,731.15 -0.01/-0.01 1 _ Jul -22 300,000.00 1 (0.01) (3,101.34) $ 16,629.80 -0,01/-0.01 i 1 Au�22 Sep -22 20,000.0 $ (8315)f (0.01) --- 300,00000 (0.01) (3,118.85) $ 13,512.95 -0.01/-0.01 20,000.0 $ (67.56) (0.01) 300,000.00 (0.01) (3,13244L$ 10,38052 $ 10,380.52 -0011-0.01 ! l - Per 13 t TotalYTJ (1) 350,199.5 Por Calcu Bon of (2,212.10) VIA Ailechinant O bis FY21 undsdovsrcokcton 5,189,872.50 j $ (48,30369) 8127,192.94), FY21 ends d the year with (2128,191.2? : - ! 1 } TTA L ALL COST RECOVIRY ADJUSTMENT CLAUSES /both GAs Monthly + ECA + RIA+AIA) Cumulative YTD Overage Total NG/TH (Firm) Budget Month Total All Total Recovery Overage Expenses Billed - (Shortage". $ - (Shortage) $ (762,982.70) $ (732,708.05) NG/LP 0.96/2.22 t Prior Year - Oct -21 $ 1,853,837.53 $ 1,683,892.18 $ 30,254.65 Nov -21 $ 2,092,710.36 $ 1,818,107.53 $ 2,085,114.01 $ (278,802.83) $ 338,488.83 $ (1,080,254.57) $ (731,493.74) $ 230,708.32 $ (1,009,310.88) $ (872,822.25) $ (1,753,076.82) $ (2,484,570.58) $ (2,253,882.24) 0.98/2.22 0.93/2.42 0.93/2.42 0.93/2.42 0.98/2.38 Dec -21 $ 1,748,625.38 Jan -22 $ 3,272,715.13 $ 2,192,460.55 $ 2,404,360.07 Feb -22- $ 3,135,853.80 Mar -22 $ 2,070,507.15 $ 2,301,215.48 Apr -22 $ 1,503,111.88 $ 2,211,662.29 $ 708,550.41 $ (1,545,311.83) 0.98/2.38 May -22 Jun -22 $ 2,085,561.97 $ 2,121,708.33 8 58,148.38 8(1,489, 165.4,) 1.08/2.38 $ 1,649,652.46 $ 2,105,261.42 $ 455,808.97 $ (1,033,558.50); 1.16/2.13 5 (764,995.74) r Jul -22 $ 1,821,788.03 $ 2,090,328.79 $ 268,560.78 Av-22 Sep -22 $ 1,898,490.32 $ 1,973,24399 $ 2.169.087 44 $ 270,597 12 $ (494,398 82) - ' $ 2,184,159.37 $ 210915.38 $ (283,483.24) I Per 13 - $ - $ - $ (283,483.24) Total YTD 24,885,878.00 25,385,357.48 $ 479,479.46 NG NFE TRACKING Actual Actual Actual Annual CLEARWATER GAS SYSTEM SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTION$ Attachment 81 Budget Month Therms NFE YTD Total Strat. Plan Amt. -' Beg_ Bal. Oct -21 } Y , 1,954,418.5 1,044,396.74 1,044,396.74 (1,044,396.74) Nov -21 2,078,550.7 1,085,254.93 1,085,254.93 (2,129,851.67) (3,372,898.77) (4,859,603.88) (6,042,468.45) (7,383,569.83) (8,692,134.52) (9,885,324.43) (11,029,923.31) (11,029,923.31) (11,029,923.31) (11,028,923.31)_ Dec -21 2,435,248.2 1,243,247.10 1,243,247.10 1,286,705.11 1,382,864.57 Jan -22 2,516,981.1 1,286,705.11 Feb -22 2,799,025.0 1,382,864.57 Mar -22 2,497,838.9 1,341,101.38 1,341,101.38 1,308,564.89 1,193,189.91 1,144,598.88 - - Apr -22 2,464,188.1 1,308,584.69 May -22 2,159,298.8 1,193,189,91 Jun -22 2,027,035.7 1,144,598.88 Jul -22 Aug -22 -22 - _Sep Total YTD Average NFE Rate 0.53 rtheml 20,932,583.0 11,029,923.31 LP NFE TRACKING i • Budget Actual Actual Actual Annual t Month Gallons NFE YTD Total Strat. Plan Amt. 1 , Beg_3al. r 1 $__.______._.-.}.-.__-____..___ . Oct -21 29,269.1 46,454.28 46,454 (48,454.26), Nov -21 36,892.3 52,966.46 52,968 (99,420.72) (156,883.53) Dec -21 34,460.5 57,482.81 57,483 - Jan -22 44,042.7 _ 58,508.26 - 58,508 (213,391.79) Feb -22 38,823.5 56,688.86 56,887 (270,078.45) Mar-22 51,518.1 71,331.87 71,332 67,747 (341,410.32) (409,157.20) Apr -22 38,107.4 87,746.88 M22 44,143.0 78,500.10 76,500 (485,857.30) Jun -22 39,283.4 63,535.92 83,538 - (549,193.22) (549,193.22), (549,193.22) Jut -22 Aug -22 Sep-22 TotalYTD ' - t -. _ -- _ -. ___ ]_ - (549,193.22) �— t --- Average NFE Rate 1.55 •er gallon- 354,340.0 549,193.22 4 4 y Central Pasco Counter Natural Gas Sales (PGA -NG) Budget Commodity Interest Expense Total NG Fuel Expenses Total NG PGA Billed Overage (Shortage) $ (1,998.40) YTD Overage (Shortage) $ (108,790.01) $ (110,788.41) Rate/Therm I Flrm/Contr 0.73 _ _ + Month Charges I Prior Year rt Oct -21 73,198.00 $ 543.95 $ 73,198.00 $ 71,199.80 Nov -21 55,362.89 $ 553.94 $ 55,362.89 78,744.20 $ 23,381.31 $ (87,407.10) $ (31,022.34) $ (254,760.97) $ (220,143.22) $ (212,428.28) $ (188,872.81) $ (151,448.03) 0.73 0.78 0.76 0.76 0.83 0.83 0.95 Dec -21 45,814.97 $ 437.04 $ 45,814.97 102,199.73 $ 56,384.78 $ (223,738.83) $ 34,617.75 $ 7,714.94 $ 43,555.47 $ 17,424.78 Jan -22 333,088.65 $ 155.11 $ 1,273.80 $ 333,088.65 $ 120,460.13 109,350.02 155,077.88 Feb -22 120,460.13 Mar -22 112,589.87 $ 1,100.72 $ 1,082.14 $ 112,589.87 $ 87,038.23 120,304.81 110,593.70 Apr -22 ,. May -22 Jun -22 67,038.23 + 84,824.06 $ 844.36 $ 84,624.06 102,048.84 71,031.12 $ 757.24_,_$ 71,031.12 $ - 102,025.90 $ 30,984.78 $ (120,453.25) 1.03 Jul -22 $ - $ (120,453.25) Aug -22 $ - $ - $ (120,453.25) Sep -22 i $ - $ - $ (120,453.25) 1- Total YTD $ 963,207.92 $ 6,728.31 I $ 983,207.92 $ 951,544.68 $ (11,863.24) t t CLEARWATER GAS SYSTEM )SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTIONI Salaries (101) P1 P2 P3 P4 P5 P6 P7 P8 P9 P10 P11 P12 Total 26,840.44 18,251.45 20,872.90 18,236.77 18,337.51 20,519.44 21,319.37 12,041.39 8,708.97 184,928.24 Special Pay (104) 4.50 4.50 4.50 4.50 4.50 44.50 2.25 2.25 225 73.75 Overtime (105) 129.60 - - - - 239.19 212.81 - 581.40 Lite Ins (201) 1.92 1.92 1.78 1.72 1.78 1.82 1.18 1.00 0.38 13.28 Life 1% (202) 20.18 21.31 10.55 21.43 21.97 15.60 17.45 11.00 11.00 157.49 Life SAMP (203) 76.87 79.03 72.93 71.37 72.03 06.89 48.19 38.11 18.80 540.22 Maj Medical (204) 2,123.85 2,134.24 1,968.07 2,174.95 2,191.43 2,505.15 1,940.84 1,790.57 982.40 17511.30 Social Security (208) 587.28 393.47 304.62 406.07 403.37 398,07 465.82 240.85 195.74 3,39527 Pension (207) 2,013.35 2,013.38 1,904.19 2,000.35 2,013.38 2,354.24 1,159.82 - - 13,518.75 Workers Comp (209) 64.17 84.17 64.17 64.17 64.17 64.17 04.17 64.17 64.17 577.53 Disability (210) 7.18 7.59 5.90 6.58 6.75 5.10 5.36 3.38 3.38 51.22 Life Ins CWA (220) - - - - - 9.22 7.88 7.77 7.80 32.45 Personal Svc 31,869.35 22,971.06 25,015.61 22687.92 23,115.87 26,015.00 25,301.30 14,411.10 9,992.69 - - - 201,880.90 Professional Svc (301) - 8,270.96 4,135.48 6,270.96 - 4,135.48 4,135.48 4,135.48 4,135.48 37,219.32 Contractual (303) 66.00 224.00 580.00 - 65.00 245.00 310.00 550.00 2,040.00 Garage (401) 527.75 921.17 802.79 927.79 952.56 728.05 1,069.56 1,076.83 2,047.10 9,053.60 Telephone-Var (403) - 371.92 - 371.92 683.72 663.80 311.40 - - 2,382.56 Telephone -Fixed (408) 19.17 19.17 19.17 19.17 19.17 19.17 19.17 19.17 19.17 172.53 Postal (407) - - - - - - 95.31 - - 95.31 IT (410) 1,632.50 1,632.50 1,632.50 1,632.50 1,632.50 1,632.50 1,632.50 1,632.50 1,632.50 14,692.50 Gar Ver (415) - - - - - - - - - - Bld & Maint Var (418) - - - - - - - - - - Utilities -Telephone (421) - 11120 100.52 107.30 - 223.23 97.53 109.91 109.87 859.56 Utilities -Electric (422) 262.05 28.32 20.19 20.19 976.08 444.02 404.14 458.18 427.80 3,040.97 Utilities-Gaslwater(423) 1,031.60 1,017.62 792.06 672.88 986.43 736.18 779.06 898.33 1,096.48 8,210.42 Interfund Svc (427) 183.33 183.33 183.33 183.33 , 183.33 183.33 183.33 183.33 183.33 1,649.97 Interfund-Gen Fd Ops (428; 1,758.33 1,758.33 1,758.33 1.758.33 1,758.33 1,758.33 1.75533 1,758.33 1,758.33 15,824.97 Insurance (451) 191.87 191.67 191.87 191.67 191.87 191.87 191.67 191.67 191.67 1,725.03 Repairs (482) - - 1,875.00 - - - - - - 1,875.00 Uniforms (471) - - - - - - - 219.95 - 219.95 Travel (472) - - 160.00 189.00 - 1,65862 1,044.72 1,679.01 51.26 5,352.81 Mileage (473) - - - - - - - - - - Meals (474) - - - - 18.00 - - 16.00 Other Charges (480) - 701.42 - - - - - - - 701.42 Operating Supplies (504) 109.41 899.62 (4,034.93) 1,789.19 366.65 2,675.95 7,065.45 1,468.55 8,257.83 18,597.52 Mach & Equip (525) - - - - - - - - Memberships(571) 170.00 - - - 90.86 195.00 - - 100.00 555.88 Training (573). $ 25.00 S (550.00) 0 - $ - $ 300.00 $ 2,173.50 $ 1,195.00 $ 925.00 $ - $ 4,068.50 Other C -es '.. „, . Interfund Svc Chgs-Gen Fd _ 6 21 123,163.33 1 76128 123,163.33 .. -. 11 123,163.33 ;-:: 4.01 123,163.33 , .:_ 139.30' 123,153.33 C,,.17• ., _. 123,163.33 ' 26 . _ 123,163.33 ., 45,. 24 123,163.33 ^ 20.. •.62 123,163.33 - 128 _: 86 1,108,469.97 Dividend 902 - - - 525,000.00 862,420.00 - - - - 1,387,420.00 Salaries (101) P1 P2 P3P4 P5 ' P6 P7 42,439.18 P8 19,707.55 P9 18,504.34 P10 P11 P12 Total 62,996.75 40.843.94 44,790.14 38,891.03 38,253.77 38,562.84 344,789.54 Special Pay (104) 225 225 225 225 225 225 225 2.25 2.25 20.25 Overtime (105) 239.13 34.56 77.74 100.67 86.17 46.04 1728 628.51 1,878.28 3,085.38 Commissions (115) 31,198.18 24,971.84 23,943.21 20,952.26 23,548.08 18,114.25 20,425.95 41,081.89 20,617.32 224,852.81 Life Ins (201) 8.47 6.50 6.50 5.82 5.80 5.76 4.79 3.63 3.60 48.87 Life 116 (202) 23.96 24.50 22.11 24.66 24.83 22.14 1928 14.42 14.46 190.36 Life SAMP(203) 167.51 171.62 189.91 155.42 15528 153.93 123.29 86.88 84.51 1,268.35 Maj Medical (204) 8,42619 8,083.22 8,061.80 7,882.63 7,883.93 7,837.14 8,600.73 4,818.76 4,773.58 64,350.98 Social Security (206) 2,105.30 1,443.64 1,431.79 1,364.13 1,384.10 1,261.83 1,325.87 1,051.78 850.88 12.019.30 Pension (207) 4,470.40 4,150.91 4,144.01 3,943.87 3,859.66 3,848.23 1,978.45 - - 26,498.13 Workers Comp (209) 192.50 192.50 192.50 192.50 192.50 192.50 192.50 192.50 192.50 1,732.50 Disability (210) 35.08 35.87 34.43 30.39 30.37 29.55 21.49 7.31 3.38 227.67 Life Ins CWA (220) 16.70 8.38 8.38 - - - 3.80 - - 37.32 PN!lOIIN 26Y8 ...,:.. . 169.18 )'-"':78.73 3i '.,"-'i2d1V417, .. 73645J9 .; 71.385.74 :", 74170,48 MAW -'.67.69618 - 44725.05 • ; ..-. - 679.122.44 Ad1.999742021) 21001 !1'11.16Yd1$ r:Y`'8 6 C0 '-4100.05• 424.08 ...2.373.00 85168 • ..' 47466 :..4610.00 42.307,08. Other Promo (43212) - - - - - - - - - - Res ECA (43210) 50,825.00 55,125.00 64,975.00 43,050.00 39150.00 53,450.00 187,525.00 87,000.00 42,150.00 803,350.00 BIdr ECA 43211 - 31,700.00 29,600.00 - 181,900.00 7,950.00 91,100.00 - 342,250.00 �Ri a �. :„ Contractual (303) ..'.... _ ,; - ... .:. � ;#:: _12. ` m" 's." i "7', Y.. -.:a,, � ' ..Yt' 1. 4zi 1 9A X00:08 uru� 936+116 . 4 .s.... ,,: : r-r � �,, ,; ;.,,�-' 000.08. - - - - - - - - - Garage (401) 1,339.34 1,225.49 1,179.41 2.075.04 2,896.83 1,052.78 1,306.30 1,878.56 1,324.08 14,077.83 Telephone -Ver (403) - 280.82 36.07 286.82 457.54 421.44 262.49 36.07 36.07 1,823.32 Telephone -Fixed (408) 19.17 19.17 19.17 19.17 19.17 19.17 19.17 19.17 19.17 172.53 Postal (407) - - - ® 10,239.58 - • 13,577.06 - 25,711.15 Attachment 81 CLEARWATER OAS SYSTEM SUMMARY OF RATE ADJUSTMENT CLAUSE COLLECTIO IT (410) 1,632.50 1,632.50 1,632.50 1,832.50 1,632.50 1,632.50 1,632.50 1,632.50 1,632.50 14,692.50 Bldg & Maint Var (418) - - - - - - - - - - Utili6es-Gas/Water (423) 26.50 26.50 28.50 28.50 28.50 28.50 26.50 523.41 26.50 735.41 Printing (434) - 623.45 42.87 (5,246.01) 15.00 2e6.76 - 4,495.40 4,820.03 Insurance (451) 61.67 81.87 61.67 81.67 81.67 61.87 61.67 81.87 61.87 555.03 Uniforms (4711 135.99 - - - - - - 42.50 - 178.49 Travel (472) - 91.00 - - - - 89.00 - - 160.00 Mileage (473) - - - 5.85 22.23 - - 28.06 Meals (474) - - - - - - - - - - Other Charges (480) - - - - - - - - - Operating Supplies (504) 117.84 (117.84) 8825 - - 21.15 79.99 24.88 18.25 232.50 Memberships (571) 1,500.00 800.00 610.00 - - 2,710.00 Training (573) - - - - - - - - - - Moran.:',at.,, Interfund Svc Chgs-Gen Fd 8,544.17 8,544.17 8,544.17 8,544.17 6,544.17 6,544.17 6,544.17 6,544.17 3.64 6,544.17 - - - 0589617 58,897.53 Dividend (902) - - - 143,877.00 - - 143,877.00 SNEP (96386) 9,933.46 13,894.61 44,625.44 26,426.02 29,017.83 18,296.36 65,678.00 21,836.20 16,822.58 246,530.49 Prior Year write off 3,153.88 - - - - - - - - RIA 2079 P1 P2 P3 P4 P5 P6 P7 P8 P9 P10 P11 P12 Total Interfund Svc Chgs-Gen Fd 1223.33 1,223.33 1,223.33 1,223.33 1,223.33 1,223.33 1,223.33 1,223.33 1,223.33 11,009.97 Insurance (451) - Prior Year write off 973.83 - - - - - - - 973.83 Dividend 902 - - - 110 840.00 - - - - 110 840.00 ORA 2179 P1 P2 P3 P4 P5 P8 P7 P8 P9 P10 P11 P12 Total Salaries (101) 9,021.83 6,028.34 6,074.53 6,101.91 6,101.91 8,10122 9,152.86 6,101.92 6,101.93 60,787.15 Special Pay (104) - - - - - - - - - Overtime (105) - - - - - - : - - - Vacation Leave (106) - - - - - - • - - - Life Ins CWA (201) 0.92 0.91 0.92 0.84 0.84 0.84 0.84 0.84 0.83 7.78 Life Ins SAMP (203) 26.21 28.55 28.78 24.30 24.38 24.38 24.32 24.38 24.09 225.37 Medical Ins (204) 1,126.79 1,108.81 1,126.71 1,153.04 1,162.47 1,162.47 1,155.86 1,162.47 1,152.32 10,310.94 Social Security (206) 131.01 85.82 86.49 89.37 97.00 87.00 133.55 87.00 87.02 874.26 Pension (207) 758.59 778.85 784.82 785.35 758.38 785.38 394.18 - - 5,109.52 Workers Comp (209) 25.00 25.00 25.00 25.00 25.00 25.00 25.00 25.00 25.00 225.00 Life Ins CWA (220) - - - - - - - - - Personal Sec 11.1111.35 8,054.28 6,12513 11,162.62 8,1119.96 LION 10666.61 7A01.61 7,391.19 - - - 77,540.02 Cont Svc (303) Garage (401) 810.12 40.78 58.80 108.32 721.53 18.38 18.38 62.70 80.50 1,897.49 Postage (425) - - - 1I'I (3,589.54) 925.85 20.00 - - 20.00 • 26.50 20.00 - - 20.00 - - 20.00 199.48 5,352.35 180.00 Printing (434) Insurance (451) 20.00 20.00 2020 Uniforms (471) - - - - - - - Travel (472) - - - 138.00 513.20 536.70 1242.92 885.36 1,187.34 4,507.52 Other Charges (480) - - - - - - - - Operating Supplies (504) 10.54 t62.69 23.09 - 10.54 759.07 16.37 15.39 - 997.89 Memberships (571) - 420.00 - - 980.86 - 922.50 - 2,323.36 Training (573) 7,063.25 - 561.00 1,846.44 485.13 870.75 921.75 - 950.00 12,678.32 Overtime 105 - - - - - - - - - 2065 Interfund Svc Chgs-Gen F. P1 5,273.33 P2 5,273.33 P3 5,273.33 P4 5.273.33 P5 5,273.33 P6 5,273.33 P7 5,273.33 P8 5,273.33 P9 5,273.33 P10 P11 P12 Total 47,459.97 Cont Svc(303) Suburban Sc - - . - - Dividend (902) - - - - 57,863.00 - - - 57,86100 Festivals & fuel - 882.03 128.80 - - 839.15 33.50 640.20 151.69 109.23 27.30 - 335.37 2,397.41 721.64 LP ard va • • rization 104.42 - 4426 22.0e - --i-. i --. t --- t ..- Attachment 81 R Oct -21 Nov -21 E Dec -21 Jan -22 R Feb -22 ✓ Mar -22 Apr -22 A May -22 T Jun -22 Jul -22 I Aug -22 O Sep -22 Total C O Oct -21 Nov -21 M Dec -21 M Jan -22 Feb -22 O Mar -22 D Apr -22 May -22 1 Jun -22 T Ju422 Aug -22 y Sep -22 Tota COS Natural Gas Summary Monthly ActuallProjec0ons (FY22) Volume FTS -1 $0.6332 Cost FTS -2 50.6332 Volume Cost No -Notice 50.0478 Volume Cost Capacity Relinquishment Volume Rate Cost Reservation Adjustments TOTAL RESERVATION COST Total Rate 170,438 $ 107,921.34 41,788 $ 26,460.16 15,500 $ 846.30 (3,689) $ 0.0318 $ (117.36) 51.03 $ 135,111.47 50.6031 306,570 $ 194120.12 63,430 $ 33,831.88 22,500 $ 1,228.50 (99,909) $ 0.0278 $ (2,781.88) 536.23 $ 226,434.85 50.8013 316,789 $ 200,590.79 55,211 $ 34,959,61 31,000 $ 1,692.60 (100,230) $ 0.0624 $ (6,255.47) 575.00 $ 231,082.53 50.7632 316,789 $ 200,590.79 55,211 $ 34,959.81 46,500 $ 2,538.90 (19,579) $ 0.1139 $ (2,230.91) 528.82 $ 235,885.21 50.5913 286,132 $ 181,178.78 49,868 $ 31,576.42 42,000 $ 2,293.20 (34,292) $ 0.0769 $ (2,705.60) 537.20 $ 212,380.00 50.6179 318,789 $ 200,590.79 55,211 $ 34,959.81 31,000 $ 1,692.60 (77,147) $ 0.1816 $ (14,011.91) 5143.32 $ 223,374.41 50.6855 216,570 $ 137,132.12 53,430 5 33,831.88 22,500 $ 1,226.50 (21,833) 5 0.0912 $ (1,972.37).$(132,852.$3), 55,211 $ 0.0583 $ 37,357.30 50.1380 144,212 $ 91,315.04 41,788 $ 26,460.16 12,400 $ 877.04 6,019 5 0.0901 $ 542.38 51.92 $ 118,996.64 50.5821 139,560 $ 88,369.39 40,440 $ 25,806.61 10,500 $ 655.20 (3.565) $ 0.7680 8 (2,737.91) 517.63 $ 111,910.92 50.5987 149,662 $ 0.0563 $ 8,425.98 41,788 5 0.0563 10.850 $ 518.63 (10,000) $ 0.2000 5 (2 000 00) 50.00 $ 94.308.63 50.5047 8 3,648.03 $ (218,423.97) $ 1,342,302.53 130,660 10,850 S 518.63 (10,000) $ 0.2000 $ (2.000.00) 50.00 5 94,30863 50.5047 $ 10,714.00 $ - $ 3,427.00 $ (15,325.66) 10,500 5 501.90 (20,000) 5 0.2000 5 (4,000 00) 5000 $ 89,201.90 50.5232 2,641,833 $ 1,822,220.92 570,393 $ 346,514.18 286,100 $ 14,392.00 (394.025) $ - $ 1,231 844 74 ($40,271.03) ($132,493.68) 91,810,362.39 50.5870 50.6141 50.6075 1:40.8150'. IIEW:RATEIr:;11ARMIScp 50.0541 as of 7/25/2022 Attachment 82 Volume FTS -1 (Usage) Rate Cost FTS -2 (Usage) Volume Rate Cost Gas Supply (FOU i Interconnects) Volume Rate Cost Fuel % FGU Management fee $0.065 No Notice Usage GTI Payment 50.020 Cashout Prior Month Adjustment COMMODITY COST Fou. Peoples 153,712 $ 0.0563 $ 8,981.41 41,768 $ 0.0583 $ 2,436.24 209,001 $ 5.7013 $ 1,191,575.26 2.33% $ 11,607.00 $ - $ 3,910.00 $ 4,179.96 $ (31,260.93) 5 1,191,408.94 190,710 $ 0.0563 $ 11,118.41 40,440 $ 0.0583 $ 2,367.65 253,093 $ 5.8051 $ 1,469,234.90 2,335), $ 12,500.00 $ - $ 4,623.00 $ 9,534.99 $ (33,667.34) $ 1,475,701.51 171,323 5 0.0583 $ 9,988.14 55,211 $ 0.0583 $ 3,218.80 248,379 $ 5.0791 $ 1,261,547.65 2.33% $ 14,881.00 $ - S 4,530.68 $ (5,049.64) $ (28,449.33) $ 1,260,667.10 220,207 $ 0.0583 $ 12,838.07 55,211 $ 0.0583 $ 3,218,80 298,977 $ 4.9048 5 1,466,433.46 2.33% $ 15,476.00 $ - 5 5,508.36 $ (2,859.39) $ (27,393.75) $ 1,473,221.57 183,262 $ 0.0583 5 10,685.34 49,668 $ 0.0583 $ 2,907.30 252,399 $ 5.6965 5 1,435,275.43 2.33% $ 13,690.00 $ - $ 4,663.00 $ (6,609.18) $ (161,588.40) $ 1,299,023.49 178,669 $ 0.0583 $ 10,417.57 55,211 $ 0.0583 $ 3,218.80 253,007 5 5.2197 $ 1,320,614.46 2.33% $ 13,998,00 $ • $ 4,678.00 5 (14.32) $ (86,129.92) $ 1,266,772.59 155,670 5 0.0563 $ 8,784.22 53,430 $ 0.0563 $ 3,008.11 222,413 5 6.0613 $ 1,348,101.73 2.1255 $ 13,095.00 $ - 5 4,182.00 $ 5,389.80 5 (95,876.22) $ 1,288,964.84 149,662 $ 0.0563 $ 8,425.98 41,788 5 0.0563 $ 2,352.66 203,663 $ 7.5152 $ 1,530,565.83 2.12% $ 11,903.00 5 5 3,829.00 8 3,648.03 $ (218,423.97) $ 1,342,302.53 130,660 $ 0,0564 $ 7,370.24 40.440 $ 0.0563 $ 2,278.77 150,016 $ 8.3140 $ 1,496,648.19 2.131). $ 10,714.00 $ - $ 3,427.00 $ (15,325.66) $ (304,153.60) $ 1,200,958.94 150.580 $ 0.0564 $ 8.493.88 41,788 $ 0.0500 $ 2.089.40 202.000 $ 5 9649 $ 1.204 910 20 0.00% $ 12,503.91 $ - $ 3,847.36 5 - $ - $ 1,231 844 74 150.167 5 00564 $ 8,470.59 41.788 $ 0.0500 $ 2,089.40 202.000 $ 6.4146 $ 1.295,757.95 0.00% $ 12,477.08 $ - $ 3,83910 $ - 5 - $ 1.322,63411 159,515 $ 0.0564 $ 8997.89 40,440 $ 0.0500 $ 2,022.00 210,000 $ 6.4836 $ 1,361,54975 0.0015 $ 12,997.08 $ - 5 3.999.10 5 - 5 - $ 1,389,565.81 1,994,177 f,' :,...,4 :,jeii. F:" $ 114,531.73 557,403 "yz4t'1e,�ti'o $ 31,195.93 2,734,948 55 99 $ 18,382,214.83 5155,834.06 50.00 $51.036.60 (57,105.71 (5986,643.46) 815,741.063.98 Oct -21 Nov -21 Dec -21 Jan -22 Feb -22 Mer -22 Apr -22 May -22 Jun -22 Jul -22 Aug -22 Sep -22 TOTAL. COST Resery 8 Comm RATE $ 1,326,520.41 $ 6.35 $ 1,702,136.36 $ 6.73 $ 1,491,729.63 $ 6.01 $ 1,709,106.78 $ 5.72 $ 1,511,403.49 $ 5.99 $ 1,490,147.00 $ 5.89 $ 1,324,361.94 8 5.95 $ 1,461,299.07 $ 7.18 $ 1,312,867.86 $ 7.29 $ 1.326,153.37 $ 6.57 $ 1,416 942 74 $ 7.01 $ 1.478.767.71 $ 7.04 $ 17,551,426-37 $ 6.42 Total Projected DTH WACOO Total Reservation Total Commodity Cost Purchased 1st 6 Months $ 1,264,248.47 $ 7,966,795.20 $ 9,231,043.67 1,514,856 56.094 2nd6 Months $ 546,113.92 S 7,774,26878 $ 8,320.382.70 1,220,092 56.819 TOTAL $ 1,810,362.39 S 15,741,063.98 $ 17,551.426.37 2.734.948 56417 f 13,230,308 29 FGU Only $ 2,501,757.89 Interconnects Propane Weighted Average Cost of Gas (WACOG) LPWacog FY22 Attachment 43 7/25/2022 Date Company Invoice Targa Shipping Gallons Propane Delivered Rata Propane Cost Shipping Cost Total Cost FYTD Gallons Cost of Inventory Tank Inventory Tank Withdraw) WACOG 09/30/21 i �:; t-'° _''.;.A-: 'dwSr^. �s''f z'u...':-* °,. ,v s .T:. f 59,336.60 43,984 ; 1.35023 10/0621 Targa 21041434 8,787 1.83026 $ 15,568.37 $ 514.13 S 16,082.50 8,787.0 S 75.471.10 52,771 1.43016 10/07/21 Targa 21042091 8,731 1.82276 $ 15,403.67 S 510.85 $ 15,914.52 17,518.0 f 91,385.62 61502 1.48590 102021 Targa 21043630 17 594 1.80214 $ 30,677.35 $ 1,029.42 S 31,706.77 35.112.0 $ 123,092.39 79,096 ' 1.55624 10/3121 MONTHLY INVENTORY ADJUSTMENT 90 3.50289 $ 315.26 $ 315.26 35202.0 f 123,407.85 79,186 ' 1.55845 10/3121 END OF MONTH :;-_" - a. z`.`;..- �• ' ' �'-� {•9,202 .,'r' a+,;m �� - � ��-.. _�4_'.S xR'e-,..„ty: �- . ' -:4 ;� $ 76,125.75 46,647 30,378 1.55845 11/0921 Targa 21046700 1.70190 $ 15355.63 $ 605.23 S 15,660.86 44,404.0 $ 91,786.61 58,049 , 1 1.58119 11/17/21 Targa 21047618 18.361 322 1.52715 $ 26832.32 $ 1,207.65 $ 28,039.97 62,765.0 $ 119,828.58 76,410 1.56821 11/30/21 MONTHLYINVENTORY ADJUSTMENT 2.32053 S 747.21 $ 747.21 63,087.0 $ 120,573.79 76,732 1.57136 11/30/21 END OF MONTH 'J.k 4i ...�"4", , rs.::J''w»u"..av's. w`a t" 1 . 1 ,> dt^ 3 *+° t,� €-4 .'�. '? 3-_ T t'",J-'ten �sasr- --�'s. s'a.•,x4 +,_,-,�- f 55,566.52 35,362 47,370 1.57136 x12/06121 Tarya 21049913 9,150 8.944 9,118 9,102 26 1.32953 1.32453 1.42828 1.44742 1.98154 S 11,556.45 $ 60673 S 12,165.18 72,237.0 S 67.731.70 44,512 1.52165 12/07/21 Targa 21050074 $ 11,251.55 S 595.03 $ 11,846.58 81,181.0 S 79,578.28 53,456 1.48867 12/30/21 Targa 22000405 S 12,416.43 $ 606.61 $ 13,023.04 90,299.0 f 92,601.32 62574 1.47987 12/3021 Targa 22000554 $ 12,394.65 $ 779.75 $ 13,174.40 99,401.0 $ 105775.72 71,678 1.47575 12/31/21 MONTHLY INVENTORY ADJUSTMENT $ 51.52 S 51.52 99 427.0 $ 105 82724 71 702 1.47593 1213121 END OF MONTH i-litrADEItAIIT! `� si',7j„ 2'- - S v , , f 44,629.94 30,374 41,323 1.47593 01/04/22 Targa 22000912 8,542 1.42127 $ 11,578.69 S 561.83 S 12,140.52 107,969.0 S 56,970.46 38,918 1.46393 01/05/22 Targa 22001539 9,141 1.43752 1.44127 $ 12,539.17 $ 601.23 S 13,140.40 117,110.0 $ 70,110.86 48057 1.45891 01/1122 Targa 22002451 9,036 $ 12,429.02 $ 594.31 $ 13,023.33 126,146.0 S 83,134.19 57,093 1.45612 012522 Targa 22004446 18,616 1.47002 2.95588 $ 26,141.53 $ 1,224.40 $ 27,365.93 144,762.0 $ 110,500.12 75,709 1.45954 01/3122 MONTHLY INVENTORY ADJUSTMENT 648 $ 1,915.41 $ 1,915.41 145410.0 $ 112415.53 76,357 1.47224 01/31/22 END OF MONTH - 'S.` u Ck,"�,, .;_": _ -. q. �.< .,. $ 54,536.04 37343 39,314 1.47224 02/07/22 Targa 22006824 18,822 1.58613 $ 25,601.96 S 1,252.19 $ 29,854.15 164,232.0 $ 84,390.19 55,865 1.51061 02/2222 Targe 22009272 9,173 1.64203 $ 14,452.07 $ 610.28 $ 15,062.33 173,405.0 S 99,452.52 65,038 1.52914 022322 Targa 22009520 18,113 1.73770 3.04655 f 30,269.86 $ 1,205.02 $ 31,474.88 191,518.0 $ 130,927.40 83.151 1.57457 022822 MONTHLY INVENTORY ADJUSTMENT 206 $ 627.59 $ 627.59 191,724.0 $ 131,554.99 83,357 1.57821 022822 END OF MONTH ;. u y, _ ,yS 65,315.87 41,386 41,971 1.57821 03/10/22 Targe 22012531 9,144 1.81930 $ 16,006.57 $ 82907 S 16,635.64 200,868.0 $ 61,951.51 50,530 1.62184 03/11/22 Targa 22012997 9,018 1.77805 $ 15,414.01 S 620.41 5 16,034.42 209,888.0 S 97,985.93 59,548 1.64549 032822 Toga 22014345 9,178 1.78430 S 15,744.86 $ 631.41 $ 16,378.27 219 064.0 $ 114 36220 68,726 1.66403 03/29/22 Taiga 22014791 9,092 1.72742 $ 15,080.22 $ 625.50 $ 15,705.72 228,158.0 $ 130087.92 77818 1.67144 03/3122 MONTHLY INVENTORY ADJUSTMENT 168 3.35256 f 563.23 $ 563.23 228 324.0 S 130,631.15 77,986 1.67506 03/3122 END OF MONTH "a. f 47,789.43 28,630 490456 1.67506 04/11/22 Targa 22017284 8,956 1.50510 $ 12,800.37 $ 679.33 S 13,479.70 237,280.0 $ 61,269.13 37,486 1.63445 04/1222 Targa 22017444 9,070 1.49280 $ 12,849.92 $ 687.98 S 13,537.90 246,350.0 S 74,807.03 46,556 1.60682 042522 Targa 22018468 9,252 1.52635 $ 13,420.03 S 701.78 S 14,121.61 255,802.0 $ 88,928.84 55,808 1.59348 04/2722 Targe 22019128 8,947 1.50885 $ 12,821.06 S 678.65 f 13,499.71 264,549.0 S 102,428.55 64,755 1.58179 04/3022 MONTHLY INVENTORYADJUSTMENT 387 1.30506 S 505.06 S 505.06 264,936.0 $ 102,933.81 65,142 1.58014 04/3022 END OF MONTH ,.. .,-.� : ` `.„".t..*s* ''- f 33.936.13 21,476 13,666 1.58014 05/00/22 Targa 22022190 18.058 1.51969 $ 25,866.61 $ 1,576.03 S 27,442.84 262,994.0 $ 81,377.77 39,534 1.55253 05/11/22 Targa 22022300 9,028 1.49028 S 12,666.28 $ 787.93 S 13,45421 292,022.0 $ 74,831.98 48,562 1.54096 05/1222 Targa 22022522 9,127 1.50465 $ 12,936.39 $ 796.57 $ 13,732.98 301,149.0 $ 88,584.94 57,689 1.53521 052522 Targa 22023497 17,416 1.44559 $ 23,656.43 $ 1,519.99 S 25,176.42 318,565.0 $ 113741.36 75,105 1.51443 05/31/22 MONTHLY INVENTORY ADJUSTMENT 96 3.24010 $ 311.05 $ 311.05 318,661.0 S 114,052.41 75,201 1.51663 05/31/22 END OF MONTH - 4 - t a .� "e t __- - ;' S7t -' r. 1 ;': S i','.-;':".11; -' '''r Y "; • n F 5 46,163.75 31,757 43,444 1,51663 06/03/22 Targa 22024848 9,108 1.48823 $ 12,676.06 $ 878.77 S 13,554.83 327,769,0 5 61,718.58 40,865 1.51030 06/14/22 Taiga 22026265 8,878 1.48386 $ 12,317.11 f 856.58 $ 13,173.69 336,647.0 $ 74,89227 49,743 1.50558 06/1322 Targa 22028849 9,000 1.49948 $ 12,627.00 S 868.36 $ 13,495.36 345,647.0 $ 88,387.63 58,743 1.50465 062422 Tarya 22027168 8,883 1.47448 $ 12213.22 $ 855.14 $ 13,068.38 354,510.0 f 101,455.99 67,606 1.50070 062722 Targa 22027393 8,621 358 1.48781 $ 11,820.47 S 831.79 $ 12,652.26 363,131.0 $ 114,10825 76,717 1.49695 06/3022 MONTHLYINVENTORY ADJUSTMENT 2.97771 $ 1086.02 $ 1066.02 383 489.0 f 115,17427 76,585 1.50388 06/30/22 ENO OF MONTH .' . ,' .. , x- : " .. �. , -�� ' ", ' � - � ' •r'- S 64,315.44 36,117 40446 1.50388 07/05/22 Targa 22028805 8 783 1.48841 $ 12,212.77 f 859.95 5 13 072.72 372 272.0 $ 67,388.18 44 900 1.50085 07/12/22 Targe 22029567 8,601 9,314 1.45154 $ 11,642.53 S 842.13 $ 12 464.66 380 873.0 f 79 872.84 53 501 1.49292 07/18/22 Targa 22030246 1.40567 S 11,973.15 $ 1,11925 $ 13,092.40 390,167.0 $ 9296524 62,815 1.47998 FYTD Totals 369,971 1.56196 $ 550,298.10 5 27,591.86 f 577,689.98 Projections Delivered Delivered Delivered Cost Total EOM Tank EOM Tank Projected Month CGS Cost Gallons Cost of Inventory Gallons Gallons Cost WACOG Jun -22 36,117 $ 54,315.00 1.50 Jul -22 $ 1.50 27,000 $ 40, 500.00 $ 94, 815.00 63,117 36,117 $ 54, 255.33 1.50 Aug -22 $ 1.50 18,000 $ 27, 000.00 $ 81, 255.33 54,117 36,117 $ 54, 228.77 1.50 Sep -22 $ 1.50 27,000 $ 40, 500.00 $ 94, 728.77 63,117 36,117 $ 54, 205.98 1.50 Oct -22 $ 1.50 27,000 $ 40, 500.00 $ 94, 705.98 63,117 36,117 $ 54,192.94 1.50 Nov -22 $ 1.60 36,000 $ 57, 600.00 $ 111, 792.94 72,117 36,117 $ 55, 987.16 1.55 Dec -22 $ 1.60 36,000 $ 57, 600.00 $ 113, 587.16 72,117 36,117 $ 56, 885.72 1.58 Jan -23 $ 1.75 48,000 $ 84, 000.00 $ 140, 885.72 84,117 36,117 $ 60, 491.57 1.67 Feb -23 $ 1.75 48,000 $ 84, 000.00 $ 144, 491.57 84,117 36,117 $ 62, 039.80 1.72 Mar -23 $ 1.75 36,000 $ 63, 000.00 $ 125, 039.80 72,117 36,117 $ 62, 621.33 1.73 Apr -23 $ 1.75 27,000 $ 47, 250.00 $ 109, 871.33 63,117 36,117 $ 62, 870.90 1.74 May -23 $ 1.75 27,000 $ 47, 250.00 $ 110,120.90 63,117 36,117 $ 63, 013.72 1.74 CSW: 6/22/2022 Applicable Annual Therm Range or Other Rate Determinant Monthly Customer Charge (For Central Pasco Territory) Non -Fuel Enerav Charae/Therm 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 Charge/Therm Minimum Monthly Bill (For Central Pasco Territory) Compares to LP/Gallon Rate of with 6.0% Franchise Utility Tax Note: Fuel Rate per Therm 10/01/1973 Non -Utility Taxable Fuel/Therm CLEARWATER GAS SYSTEM NATURAL GAS RATE BILLING FACTORS FOR AUGUST 1, 2022 - SEPTEMBER 30, 2022 BASED ON APPROVED GAS ADJUSTMENT FACTORS Interr. Firm Natural Gas Rate Schedules NG Rate RS AME.. MME JIA E_ SGS _MO_ LGS _MC GAC LAC S_ SL w/M& NGV ALL ReIIaht; (Non -Real) (Non -Real) 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 3 Units) Units) Units) Units) 17,999 99,999 & up 3 Units) 149 tons) tons & +) & up Attachment #4 Contract NG Rate CNS NA $16.00 $25.00 $40.00 $95.00 $25.00 $40.00 $95.00 Rate Rate Rate $20.00 $20.00 By Contract $50.00 $250.00 By Contract ($24.00) ($40.00) ($70.00) ($160.00) ($40.00) ($70.00) ($160.00) Suspended Suspended Suspended ($30.00) ($30.00) (By Contract) ($75.00) ($400.00) (By Contract) Reserved for Reserved for Reserved for Future Use Future Use Future Use $0.44 $0.44 $0.44 $0.44 $0.38 $0.34 $0.30 NA NA NA $0.20 $0.35 By Contract $0.38 $0.24 By Contract 0.16 0.16 0.16 0.16 0.16 0.18 0.16 NA NA NA NA NA NA NA NA NA 0.01 0.01 0.01 0.01 0.01 0.01 0.01 NA NA NA NA NA NA NA NA NA Q1 &i A:41 441 4 4.43 4.44 NA &N NA 116 N9 !`!A LA NAA NA $0.60 $0.60 $0.60 $0.60 $0.60 $0.56 $0.52 NA NA NA $0.20 $0.35 By Contract $0.38 $0.24 By Contract Q.$4 Q.94 Q&4 Q.$4 Dia IN QM NA !9 NA QM cm By Contract Q.$4 UR 4e2 1.58 1.58 1.58 1.58 1.58 1.54 1.50 NA NA NA 1.18 1.33 By Contract 1.36 1.13 0.89 + Non -Fuel $16.00 $25.00 $40.00 $95.00 $25.00 $40.00 $95.00 NA NA NA $20.00 $20.00 By Contract $50.00 $250.00 Customer ($24.00) ($40.00) ($70.00) ($160.00) ($40.00) ($70.00) ($160.00) ($30.00) ($30.00) (By Contract) ($75.00) ($400.00) Charge + + FAC + FAC + FAC + FAC + Non -Fuel Therm Non -Fuel Therm Rate for Contract Rate for Contract # of Therms # of Therms $ 1.45 $ 1.45 $ 1.45 $ 1.45 $ 1.45 $ 1.41 $ 1.37 $ 1.53 $ 1.53 $ 1.53 $ 1.53 $ 1.53 $ 1.49 $ 1,45 $0.069 $0.069 $0.069 $0.069 $0.069 $0.069 $0.069 $0.911 $0.911 $0.911 $0.911 $0.911 $0.911 $0.911 BTU FACTOR - THERMS/100 CUBIC FEET (CCF) 10/2021 11/2021 Firm Service Rates 1.045 1.046 Interruptible Service Rates 1.025 1.025 12/202( 1.046 1.025 01/2022 1.044 1.024 02/2022 1.045 1.024 03/2022 1.045 1.024 94/202Z 1.043 1.022 NA NA NA NA NA $ 1.08 $ 1.22 NA $ 1.14 $ 1.29 NA NA NA $0.069 $0.069 NA NA NA $0.911 $0.911 05/2022 06/2022 07/202Z 08/2022 09/2022 1.041 1.041 1.042 1.042 1.021 1.020 1.021 1.022 NA $ 1.24 $ 1.03 NA $ 1.32 $ 1.10 $0.069 $0.069 $0.055 ($0.069) $0.911 $0.835 FY 21/22 Ava. 1.044 1.023 $0.069 $0.821 BTU Factor: 2.714 Gallons/100 cubic feet (CCF) BTU Factor. 2.483 Therms/100 cubic feet (CCF) Therm Factor: 0.915 Therms/Gallon CLEARWATER GAS SYSTEM METERED PROPANE (LP) RATE BILLING FACTORS FOR AUGUST 1, 2022 - SEPTEMBER 30, 2022 BASED ON APPROVED GAS ADJUSTMENT FACTORS Attachment #5 Page 1 of 2 RESIDENTIAL MULTI -FAMILY LOOP RESL. SMALL COML. LARGE COML. VEHICLE STANDBY/GENERATOR CONTRACT MTRD MRLP _ MMLP LRLP MGLP MLLP LPV LPSM CLP (Non -Rest. Only) (Non -Rest. Only) Applicable Annual Gallon Range NA NA NA 0 - 2,500 >2,501 NA NA NA or Other Rate Determinant (1 - 3 Units) (4 + Units) (Closed for New Real. Applications) Monthly Customer Charge $16.00 $25.00 $16.00 $25.00 $40.00 $40.00 $50.00 Set By Contract For Each Meter Non -Fuel Energy Charges/Gallon: Non -Fuel Energy Charge (NFE)/Gallor $1.90 $1.90 $0.90 $0.30 $0.25 Set By Contract $1.00 Set By Contract Energy Conservation Adj.(ECA)/Gallor 0.16 0.16 0.16 0.16 0.16 NA NA NA Regulatory Imposition Adj.(RIA)/Gallon 0.01 0.01 0.01 0.01 0.01 NA NA NA Usage & Inflation Adj. (UTA)/Gallon -0_01 -0_01 -0_01 Q.Oi Q05 NA NA NA Total Non -Fuel Charges (NF)/Gal. $2.06 $2.06 $1.06 $0.52 $0.47 Set By Contract $1.00 Set By Contract Purchased Gas Adjustment(PGA)/Gal. j 1St 1.1/¢ 1,0.2 Set By Contract 1 1.31 Total Energy Charges/Gallon $3.71 $3.71 $2.71 $2.17 $2.12 Contract NFE $2.65 Contract NFE + + Contract PGA $1.350 Customer Charge Customer Charge + Minimum Monthly Bill $16.00 $25.00 $16.00 $25.00 $40.00 Any Applicable $50.00 Non -Fuel Energy Chg. Customer Charge for the Contracted + Any Applicable # of Gallons/Mo. Facility Charges Utility Tax Note: Fuel Rate per Gallon 10/01/1973 0.161 0.161 0.161 0.161 0.161 0.161 0.161 0.161 Non -Utility Taxable Fuel/Gallon $1.489 $1.489 $1.489 $1.489 $1.489 Contract PGA - 0.161 $1.489 Contract PGA - 0.161 0.000 BTU Factor: BTU Factor: Therm Factor: 2.714 Gallons/100 cubic feet (CCF) CLEARWATER GAS SYSTEM 2783 Therms/100 cubic feet (CCF) BULK PROPANE (LP) RATE BILLING FACTORS 0.915 Therms/Gallon FOR AUGUST 1, 2022 - SEPTEMBER 30, 2022 BASED ON APPROVED GAS ADJUSTMENT FACTORS STANDARD RESIDENTIAL BULK LP SERVICE (Rate Class is Based on Annual LP Gallon Usage Level) BRLPO BRLP1 BRLP2 BRLP3 ¢RLP4 RESIDENTIAL "WILL CALL" (Based on Annual Usage Level) WRLPO WRLP1 WRLP2 WRLP3 WRLP4 COMMERCIAL BULK LP SERVICE (Based on Annual Usage Level) 13CLP1 BCLP2 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 0 - 2,500 > 2,500 or Other Rate Determinant 1-3 UNITS 1-3 UNITS 1-3 UNITS 1-3 UNITS 1-3 UNITS 1-3 UNITS 1-3 UMTS 1-3 UNITS 1-3 UNITS 1-3 UNITS Customers in this Customers in this Range of Usage Range of Usage Annual Customer Charge $ 395.00 $ 270.00 $ 225.00 $ 135.00 $ 120.00 $ 395.00 $ 255.00 $ 195.00 $ 120.00 $ 105.00 8 90.00 $ 90.00 Non -Fuel Charges INF(IGallom Non -Fuel Energy Charge (NFE)/Gal. $ 1.80 $ 1.80 $ 1.60 $ 1.00 $ 0.90 $ 1.80 $ 1.80 $ 1.60 $ 0.90 $ 0.80 $ 0.25 $ 0.20 Energy Conservation Adj. (ECA)IGaI $ 0.16 $ 0.16 $ 0,16 0.16 0.16 0.16 0.16 0.16 0.16 0.16 0.16 0.16 Regulatory Imposition Adj. (RIA)IGaI $ 0.01 $ 0.01 $ 0.01 0.01 0.01 0.01 0.01 0.01 0.01 0.01 0.01 0.01 Usage & Inflation Adj. (UTA)/Gallon (0.01) (0.01) (0.01) (0.01) (0.01) (0.01) (0.01) (0.01) (0.01) (0.01) 0.05 0.05 Total Non -Fuel Charges (NF)/Gal. $ 1.96 $ 1.96 $ 1.76 $ 1.16 $ 1.06 $ 1.96 $ 1.66 $ 1.76 $ 1.06 $ 0.96 $ 0.47 $ 0.42 Purchased Gas Adj. (PGA)/Gallon $ 1.85 $ 1,65 $ 1.85 $ 1.65 $ 1.65 1 1.85 $ 1.65 $ 1.66 1______114 1_______L__85 f______1131 $ 1.65 Total Energy Charges/Gallon $ 3.61 $ 3.61 $ 3.41 $ 2.81 $ 2.71 $ 3.61 $ 3.61 $ 3.41 6 2.71 $ 2.61 $ 2.12 $ 2.07 Note: No Monthly Minimum Bill Utility Tax Note: Fuel Rate per Gallon 10/01/1973 $ 0.161 $ 0.161 $ 0.161 $ 0.161 $ 0.161 $ 0.161 $ 0.161 $ 0.161 $ 0.161 $ 0.161 $ 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 $ 1.00 Set By Contract NA NA NA NA NA NA $ 1.00 Set By Contract $ 1.05 IAA $ 2.66 Cotract NFE + 1.360 0.161 $ 0.161 $ 0.161 $ 0.161 Non -Utility Taxable Fuel/Gallon $ 1.489 $ 1.489 $ 1.489 $ 1.489 $ 1.489 $ 1.489 $ 1.489 $ 1.489 $ 1.489 $ 1.489 $ 1.489 $ 1.489 $ 1.489 Contract PGA - 0.161