Loading...
HomeMy WebLinkAbout20220831July 2022 PGA Report.pdf Avista Corp. 1411 East Mission P.O. Box 3727 Spokane, Washington 99220-0500 Telephone 509-489-0500 Toll Free 800-727-9170 August 31, 2022 State of Idaho Idaho Public Utilities Commission 11331 W. Chinden Blvd., Bldg 8 Suite 201-A Boise, Idaho 83714 RE: Monthly Deferred Cost Report Attached is the PGA monthly report of activity in the Gas Deferral Accounts for the month of July 2022. This information is submitted in compliance with Order Number 35151 issued in the Company’s Purchase Gas Cost Adjustment filing (Case No. AVU-G-21-04). This report is being filed in electronic format only per approval from the filing center. For the month, commodity costs were lower than the embedded PGA commodity WACOG, resulting in a rebate deferral in the amount of $551,413. Demand costs were higher than the PGA demand WACOG, resulting in a surcharge deferral in the amount of $541,206. The cumulative balance in the deferral account (including both commodity and demand) is a surcharge of $9,439,095 (including interest). The amount of amortization recorded for the month is $29,212 for a total surcharge balance of $3,250,937 (including interest). If you have any questions regarding this information, please feel free to contact Marcus Garbarino via email at marcus.garbarino@avistacorp.com or via telephone at (509) 495-2567. Thank you! Sincerely, /S/Joe Miller Joe Miller Senior Manager of Rates and Tariffs Regulatory Affairs Enclosures RECEIVED 2022 August 31, AM 11:37 IDAHO PUBLIC UTILITIES COMMISSION Explanation: To record the monthly deferral of unrecovered commodity and demand costs related to WA and ID. Also to record the amortization of recoverable costs for WA and ID. Se . Co. FERC Ser. Jur. S.I.Debit Credit Comment 10 001 419600 - INTEREST ON ENERGY DEFERRALS GD WA DL 0.00 52,387.59 Interest 20 001 191010 - CURR UNRECOV PGA DEFERRED GD WA DL 275,690.62 0.00 Deferral 30 001 805120 - DEFER CURRENT UNRECOVERED GAS COSTS GD WA DL 0.00 223,303.03 Deferral Expense 40 001 419600 - INTEREST ON ENERGY DEFERRALS GD WA DL 0.00 17,302.36 Interest 50 001 191000 - RECOVERABLE GAS COSTS AMORTIZED GD WA DL 0.00 84,543.64 Amortization 60 001 805110 - AMORTIZE RECOVERABLE GAS COSTS GD W D 101,846.00 0.00 Amortization Expense 70 001 419600 - INTEREST ON ENERGY DEFERRALS GD ID DL 0.00 7,863.61 Interest 80 001 191010 - CURR UNRECOV PGA DEFERRED GD ID DL 0.00 2,343.70 Deferral 90 001 805120 - DEFER CURRENT UNRECOVERED GAS COSTS GD ID DL 10,207.31 0.00 Deferral Expense 100 001 419600 - INTEREST ON ENERGY DEFERRALS GD ID DL 0.00 2,719.57 Interest 110 001 191000 - RECOVERABLE GAS COSTS AMORTIZED GD ID DL 0.00 29,212.16 Amortization 120 001 805110 - AMORTIZE RECOVERABLE GAS COSTS GD ID DL 31,931.73 0.00 Amortization Expense Totals:419,675.66 419,675.66 Page 1 of 2 Avista Corporation Journal Entry Journal: Team: Type: Category: Currency: 431-D&A WA/ID Last Saved by: Submitted by: Approved by: Keri Meister Keri Meister Printed 08/04/2022 at 10:19 AM Last Update: 08/04/2022 10:14 AM Approval Requested: 08/04/2022 10:19 AM Resource Accounting C DJ USD Effective Date: 202207 ID PGA July 2022 Page 1 of 12 Prepared by Keri Meister Reviewed by Approved for Entry Corporate Accounting use Only Date Date Date Page 2 of 2 Avista Corporation Journal Entry Journal: Team: Type: Category: Currency: 431-D&A WA/ID Last Saved by: Submitted by: Approved by: Keri Meister Keri Meister Printed 08/04/2022 at 10:19 AM Last Update: 08/04/2022 10:14 AM Approval Requested: 08/04/2022 10:19 AM Resource Accounting C DJ USD Effective Date: 202207 8/4/2022 ID PGA July 2022 Page 2 of 12 WASHINGTON / IDAHO GAS COSTS 202207 KEY:Manual Input GLWand Total Expense Calculation System Cost Demand Commodity Demand Commodity Balance Sheet PGA PGA PGA Balance Sheet PGA PGA PGA Def Rev Calc Volumes Rate Revenue Def Rev Calc Volumes Rate Revenue 100%68.33%66.01%31.67%33.99% DEMAND DEMAND GAS COSTS-DEMAND 804001 GD.AN 2,343,543.09 Schedule 101 2,224,703 0.09373 208,521.41 Schedule 101 1,197,969 0.09203 110,249.09 TRANSPORT VARIABLE CHARGES 804002 GD.AN 20,224.35 Schedule 102 5,190 0.09373 486.46 Schedule 111 933,655 0.09203 85,924.27 Total Demand Costs 2,363,767.44$ Schedule 111 1,968,103 0.08732 171,854.75 Schedule 112 52,381 0.09203 4,820.62 less variable costs charged to Commodit (20,224.35) Schedule 112 0 0.08732 - Schedule 131 0 0.09203 - Total Current Demand Costs 2,343,543.09$ 1,601,342.99 742,200.10 Schedule 131 0 0.05443 - Schedule 132 0 0.09203 - Schedule 132 43,650 0.05443 2,375.87 Total Demand 2,184,005 200,993.98$ Schedule 146 2,120,903 0.00054 1,145.29 2,184,005GAS COSTS-COMMODIT 804000 GD.AN 20,395,325.77 Total Demand 6,362,549 384,383.78$ - check GAS COSTS - FX HEDGE 804010 GD.AN (101,905.24) 6,362,549 GAS COSTS-TRANSACTION FEE 804017 GD.AN 48,228.30 - check Gas Costs - Merchandise Processing Fee 804018 GD.AN 17,239.94 GAS PURCHASES - FINANCIAL 804600 GD.AN (2,388,206.29) GAS COSTS-INTRACO LDC GAS 804730 GD.AN 959,122.23 COMMODITY COMMODITY GAS STORAGE WITHDRAWALS 808100 GD.AN 97,028.92 Schedule 101 2,224,703 pro rated 770,483.00 Schedule 101 1,197,969 pro rated 434,521.00 GAS STORAGE INJECTIONS 808200 GD.AN (11,282,821.47) Schedule 102 5,190 pro rated 1,875.00 Schedule 111 933,655 pro rated 324,896.00 GAS USED FOR PRODUCTS EXTRACTION 811000 GD.AN (55,052.13) Schedule 111 1,968,103 pro rated 645,580.00 Schedule 112 52,381 pro rated 17,153.00 SALES FOR RESALE PHYSICAL-GAS 483000 GD.AN (1,977,646.18) Schedule 112 0 pro rated - Schedule 131 0 pro rated - SALES FOR RESALE-FINANCIAL GAS 483600 GD.AN 898,449.75 Schedule 131 0 pro rated - Schedule 132 0 pro rated - SALES FOR RESALE-INTRACO LDC GAS 483730 GD.AN (5,269,743.13) Schedule 132 43,650 pro rated 12,903.00 Total Commodity 2,184,005 776,570.00$ DEFERRED EXCHANGE RESERVATION FEE 495028 GD.AN (468,750.00) Total Commodity 4,241,646 1,430,841.00$ 2,184,005 AN Entitlement Penalty 495100 GD.AN -4,241,646 - check plus variable costs from Demand 20,224.35 - checkTotal Commodity Costs to be Allocated 891,494.82$ 588,475.73 303,019.09 WA Entitlement Penalty 495100 GD.WA -- Deferral Calculation Washington Washington Idaho Idaho ID Entitlement Penalt 495100 GD.ID -- Demand Commodity Demand Commodity check: WA Imbalance Costs 804000 GD.WA (151,290.91) (151,290.91) Deferral Expenses 1,601,342.99 437,184.82 742,200.10 225,156.57 - ID Imbalance Costs 804000 GD.ID (77,862.52) (77,862.52) Deferral Revenue (384,383.78) (1,430,841.00) (200,993.98) (776,570.00) - Total Commodity Costs 662,341.39$ Total Deferred 1,216,959.21$ (993,656.18)$ 541,206.12$ (551,413.43)$ Total Demand and Commodity 3,005,884.48$ 1,601,342.99$ 437,184.82$ 742,200.10$ 225,156.57$ WA Total 223,303.03 ID Total (10,207.31) 804%,808%,811000,483%,495028,495100 Total per GL 3,005,884.48 Check - Debits Credits 419,675.66 (419,675.66) JET Entry - check WASHINGTON IDAHO WASHINGTON IDAHO H:\Natural Gas Accounting\Gas Deferrals\2022 WA-ID Deferrals\2022 WA-ID Deferral Amort.xlsx ID PGA July 2022 Page 3 of 12 Avista Corporation State of Idaho Current Unrecovered PGA Deferral Account 191010 Month  Ending Interest  Rate Annual xfer of  balance per PGA  to 191000 Beginning  Balance Commodity Demand Interest Ending Balance GL WAND  BALANCES MONTHLY  RECON 202101 1.00% ‐ (183,332.60)          366,652.00           (512,323.13)           (213.47)            (329,217.20)            (329,217.20)          0.00 202102 1.00%‐ (329,217.20)          1,586,993.68        (600,400.35)           136.73              657,512.86              657,534.03           21.17  202103 1.00%‐ 657,512.86           (194,092.67)          (191,210.93)           387.38              272,596.64              272,707.10           110.46  202104 1.00%‐ 272,596.64           88,602.52             102,251.86            306.69              463,757.71              463,757.71           0.00 202105 1.00%‐ 463,757.71           89,170.71             335,929.46            563.59              889,421.47              889,421.47           0.00 202106 1.00%‐ 889,421.47           (28,910.22)            448,795.82            916.14              1,310,223.21          1,310,223.22        0.01 202107 1.00%‐ 1,310,223.21        107,283.33           518,312.99            1,352.52          1,937,172.05          1,937,172.06        0.01 202108 1.00%‐ 1,937,172.05        (352,261.84)          477,060.29            1,666.31          2,063,636.81          2,063,636.82        0.01 202109 1.00% (889,421.47)        1,174,215.35        (11,837.28)            411,386.30            1,144.99          1,574,909.35          1,574,909.36        0.01 202110 1.00%‐ 1,574,909.35        558,393.25           112,650.36            1,592.03          2,247,544.99          2,247,544.99        0.00 202111 1.00%‐ 2,247,544.99        1,476,923.73        (229,203.24)           2,392.84          3,497,658.31          3,497,658.32        0.01 202112 1.00%‐ 3,497,658.31        1,389,801.54        (673,335.44)           3,213.24          4,217,337.65          4,217,337.65        0.00 202201 1.00%‐ 4,217,337.65        2,376,513.93        (659,706.56)           4,229.78          5,938,374.80          5,938,374.80        (0.00)  202202 1.00%‐ 5,938,374.80        753,378.97           (527,109.37)           5,042.92          6,169,687.32          6,169,687.32        (0.00)  202203 1.00%‐ 6,169,687.32        255,875.73           (167,260.95)           5,178.33          6,263,480.44          6,263,480.44        0.00 202204 1.00%‐ 6,263,480.44        1,626,160.73        (98,189.84)             5,856.22          7,797,307.55          7,797,307.55        0.00 202205 1.00%‐ 7,797,307.55        932,484.96           207,648.42            6,972.81          8,944,413.74          8,944,413.74        (0.00)  202206 1.00%‐ 8,944,413.74        62,114.53             427,252.78            7,657.58          9,441,438.63          9,441,438.62        (0.01)  202207 1.00%‐ 9,441,438.63        (551,413.43)          541,206.12            7,863.61          9,439,094.92          9,441,438.62        2,343.70               202208 ‐ 9,439,094.92        ‐ 9,439,094.92           202209 9,439,094.92        ‐ 9,439,094.92           202210 ‐ 9,439,094.92        ‐ 9,439,094.92           202211 ‐ 9,439,094.92        ‐ 9,439,094.92           202212 ‐ 9,439,094.92        ‐ 9,439,094.92           ‐(551,413.43)         541,206.12           7,863.61          THIS ROW USED TO CALC JET ENTRY D A B C 202207 UPDATE DATE MONTHLY TO CALC JET ENTRY JET ENTRY: DR CR Interest Income 419600.GD.ID 7,863.61 C Interest Expense 431600.GD.ID C Demand+Comm Def 191010.GD.ID 2,343.70 A+B+C Deferral Expense 805120.GD.ID 10,207.31 (A+B) 0.00 check s/b 0 SEPTEMBER ENTRY TO XFER PGA BALANCES: 191010.GD.ID D 191000.GD.ID ID PGA July 2022 Page 4 of 12 Avista Corporation State of Idaho Recoverable Gas Costs Amortized Accounts 191000 Month  Ending Interest  Rate Annual xfer of  balance per PGA  from 191010 Tax Reform /  Large Customer  Refund Beginning  Balance Schedule 101  Volumes Amort Rate Amort Schedule 111  Volumes Amort Rate Amort Interest Ending Balance GL WAND  BALANCES MONTHLY  RECON 202101 1.00% ‐‐1,659,858.80       10,486,334 0.03732 391,349.98        3,100,340 0.03732 115,704.69        1,594.49                2,168,507.97        2,168,507.96       (0.01)  202102 1.00%‐‐2,168,507.97       10,870,325 0.03732 405,680.53        3,329,528 0.03732 124,257.98        2,027.90                2,700,474.38        2,700,474.37       (0.01)  202103 1.00%‐‐2,700,474.38       7,153,037 0.03732 266,951.34        2,841,316 0.03732 106,037.91        2,405.81                3,075,869.45        3,075,869.43       (0.02)  202104 1.00%‐‐3,075,869.45       4,746,418 0.03732 177,136.32        1,826,242 0.03732 68,155.35          2,665.43                3,323,826.55        3,323,826.53       (0.02)  202105 1.00%‐‐3,323,826.55       2,518,275 0.03732 93,982.02          1,443,773 0.03732 53,881.61          2,831.47                3,474,521.65        3,474,521.63       (0.02)  202106 1.00%‐‐3,474,521.65       1,493,810 0.03732 55,748.99          1,110,268 0.03732 41,435.20          2,935.93                3,574,641.77        3,574,641.75       (0.02)  202107 1.00%‐‐3,574,641.77       1,033,761 0.03732 38,579.96          933,986 0.03732 34,856.36          3,009.47                3,651,087.56        3,651,087.54       (0.02)  202108 1.00%‐‐3,651,087.56       1,138,852 0.03732 42,501.96          1,042,627 0.03732 38,910.84          3,076.49                3,735,576.84        3,735,576.83       (0.01)  202109 1.00%889,421.47           2,177.86            4,627,176.17       1,659,697 pro‐rated (27,122.00)         1,206,728 pro‐rated (22,384.00)       3,835.35                4,581,505.52        4,581,505.51       (0.01)  202110 1.00%‐‐4,581,505.52       4,725,522 pro‐rated (70,796.00)         1,889,697 pro‐rated (28,086.00)       3,776.72                4,486,400.24        4,486,400.23       (0.01)  202111 1.00%‐‐4,486,400.24       7,688,686 (0.01498)(115,176.52)       2,395,749 (0.01498)(35,888.32)        3,675.72                4,339,011.12        4,339,011.11       (0.01)  202112 1.00%‐‐4,339,011.12       11,680,297 (0.01498)(174,970.85)       3,528,688 (0.01498)(52,859.75)        3,520.91                4,114,701.44        4,114,701.42       (0.02)  202201 1.00%‐‐4,114,701.44       11,983,473 (0.01498)(179,512.43)       3,429,612 (0.01498)(51,375.59)        3,332.71                3,887,146.13        3,887,146.12       (0.01)  202202 1.00%‐‐3,887,146.13       10,247,431 (0.01498)(153,506.52)       3,348,762 (0.01498)(50,164.45)        3,154.43                3,686,629.59        3,686,629.58       (0.01)  202203 1.00%‐‐3,686,629.59       7,426,725 (0.01498)(111,252.34)       2,721,000 (0.01498)(40,760.58)        3,008.85                3,537,625.52        3,537,625.51       (0.01)  202204 1.00%‐‐3,537,625.52       6,663,215 (0.01498)(99,814.96)         2,320,122 (0.01498)(34,755.43)        2,891.95                3,405,947.08        3,405,947.07       (0.01)  202205 1.00%‐‐3,405,947.08       4,002,566 (0.01498)(59,958.44)         1,773,056 (0.01498)(26,560.38)        2,802.24                3,322,230.51        3,322,230.49       (0.02)  202206 1.00%‐‐3,322,230.51       1,848,959 (0.01498)(27,697.41)         1,190,481 (0.01498)(17,833.41)        2,749.55                3,279,449.25        3,279,449.23       (0.02)  202207 1.00%‐‐3,279,449.25       1,197,969 (0.01498)(17,945.58)         933,655 (0.01498)(13,986.15)        2,719.57                3,250,237.09        3,279,449.23       29,212.14            202208 ‐‐3,250,237.09       ‐ ‐‐ 3,250,237.09        202209 3,250,237.09       pro‐rated pro‐rated ‐3,250,237.09        202210 ‐‐3,250,237.09       pro‐rated pro‐rated ‐3,250,237.09        202211 ‐‐3,250,237.09       ‐ ‐‐3,250,237.09        202212 ‐‐3,250,237.09       ‐ ‐‐3,250,237.09        ‐(17,945.58)        (13,986.15)       2,719.57              THIS ROW USED TO CALC JET ENTRY C A A B 202207 UPDATE DATE MONTHLY TO CALC JET ENTRY JET ENTRY: DR CR Interest Income 419600.GD.ID 2,719.57 B Interest Expense 431600.GD.ID (B) Amortization 191000.GD.ID 29,212.16 A+B Amort Expense 805110.GD.ID 31,931.73 A 0.00 check s/b 0 SEPTEMBER ENTRY ‐ LARGE CUSTOMER REFUND 191000.GD.ID C 805110.GD.ID ID PGA July 2022 Page 5 of 12 Idaho Sales Volumes Consolidated Volumes July/22 Schedule July/22 June/22 July/22 July/22 Total Notes Description Billed Unbilled Unbilled Net Unbilled Schedule Summary for Commodity Deferral : Firm 101 1,461,304 760,654 497,319 (263,335) 1,197,969 Firm 111 989,402 370,330 314,583 (55,747) 933,655 Firm 112 52,381 0 0 0 52,381 Interruptible 131 0 0 0 0 0 Notify Rates Dept if used Interruptible 132 0 0 0 0 0 Interruptible 132J 0 0 0 0 0 Total Retail Sales for GTI 2,503,087 1,130,984 811,902 (319,082)2,184,005 Total sales for PGA commodity deferral, includes interruptible rate schedules Transportation 146 325,808 327,850 243,823 (84,027) 241,781 Transportation 147 152,935 154,203 143,128 (11,075) 141,860 Transportation 159 2,988,721 0 0 0 2,988,721 Transportation 169 0 0 0 0 0 Total transportation 3,467,464 482,053 386,951 (95,102) 3,372,362 Total sales 5,970,551 1,613,037 1,198,853 (414,184) 5,556,367 Schedule Summary for Demand Deferral: Firm 101 1,461,304 760,654 497,319 (263,335) 1,197,969 Firm 111 989,402 370,330 314,583 (55,747) 933,655 Firm 112 52,381 0 0 0 52,381 Firm 131 0 0 0 0 0 Firm 132 0 0 0 0 0 Total Firm Sales 2,503,087 1,130,984 811,902 (319,082)2,184,005 Total sales for PGA demand deferral, excludes interruptible rate schedules Schedule Summary for Commodity and Demand Amortization: Firm 101 1,461,304 760,654 497,319 (263,335) 1,197,969 Firm 111 989,402 370,330 314,583 (55,747) 933,655 Interruptible 131 0 0 0 0 0 Notify Rates Dept if used Interruptible 132J 0 0 0 0 0 Special amortization rate 2,450,706 1,130,984 811,902 (319,082)2,131,624 Volumes for PGA Commodity & Demand Amortization Firm 112 52,381 0 0 0 52,381 Annual lump sum amortization Firm 131 0 0 0 0 0 Annual lump sum amortization Interruptible 132 0 0 0 0 0 Annual lump sum amortization Total Firm Sales 2,503,087 1,130,984 811,902 319,082 2,184,005 Total Interruptible Sales 0 0 0 0 0 Total Transportation Sales (Schedule 146 - 169) 3,467,464 482,053 386,951 (95,102) 3,372,362 Check total sales 5,970,551 1,613,037 1,198,853 (414,184) 5,556,367 5,970,551 1,613,037 1,198,853 5,556,367 ---- H:\Natural Gas Accounting\Calendar Sales\WAID Calendar sales\2022 ID Calendar Sales Volumes.xlsx for pro rating - reverse June unbilled ID PGA July 2022 Page 6 of 12 WASHINGTON GL Account Rate Schedule Interest Rates Notes WASHINGTON INTEREST RATE: FERC Natural Gas Interest Rate 3.60%Updated for Q3'22 - DONE https://ferc.gov/enforcement-legal/enforcement/interest-rates PREVIOUS PREVIOUS NEW WASHINGTON DEFERRAL RATES:Nov'20-Oct'21 Nov'21-Jun'22 Jul'22-Oct'22 Commodity Rate 191010 GD WA 101 - 132 $0.16167 $0.22319 $0.33449 Off-cycle PGA filing effect 7.1.22 - WA Commodity onl Demand Rates 191010 GD WA 101/102 $0.09822 $0.09373 $0.09373 WA PGA filing effective 11.1.21 111/112 $0.08835 $0.08732 $0.08732 WA PGA filing effective 11.1.21 131/132 $0.05640 $0.05443 $0.05443 WA PGA filing effective 11.1.21 146/116 $0.00054 $0.00054 $0.00054 WA PGA filing effective 11.1.21 WASHINGTON AMORTIZATION RATES: Commodity & Demand (Sch 155)191000 GD WA 101/102 $0.00699 ($0.02006)($0.02006)WA PGA filing effective 11.1.21 111 $0.00013 ($0.02902)($0.02902)WA PGA filing effective 11.1.21 131 $0.00000 $0.00000 $0.00000 WA PGA filing effective 11.1.21 146 $0.00000 $0.00000 $0.00000 WA PGA filing effective 11.1.21 IDAHO GL Account Rate Schedule Interest Rates Notes IDAHO INTEREST RATE: Customer Deposit Rate changes annually 1.00%UPDATED ANNUALLY IN JANUARY puc.idaho.gov (Year 2022 Order # 35246) PREVIOUS PREVIOUS PREVIOUS NEW IDAHO DEFERRAL RATES:Nov'20-Aug'21 Sep'21-Jan'22 Feb'22-Jun'22 Jul'22-Oct'22 Commodity Rate (Without GTI)191010 GD ID 101 - 132 $0.16148 $0.20177 $0.26384 $0.34988 Off-cycle PGA filing effect 7.1.22 - ID Commodity onl Demand Rate 191010 GD ID 101/111/112 $0.08952 $0.09203 $0.09203 $0.09203 Idaho only PGA filing effective 9.1.21 IDAHO AMORTIZATION RATES: Commodity & Demand (Sch 155)191000 GD ID 101 $0.03732 ($0.01498) ($0.01498)($0.01498)Idaho only PGA filing effective 9.1.21 111 $0.03732 ($0.01498) ($0.01498)($0.01498)Idaho only PGA filing effective 9.1.21 112 $0.00000 $0.00000 $0.00000 $0.00000 Idaho only PGA filing effective 9.1.21 146 $0.00000 $0.00000 $0.00000 $0.00000 Idaho only PGA filing effective 9.1.21 202207 Regulatory Information Monthly Review.xlsx WA_ID PGA Deferral-Amort 8/3/2022 1:16 PM ID PGA July 2022 Page 7 of 12 1 Meister, Keri From:Garbarino, Marcus Sent:Thursday, July 28, 2022 1:37 PM To:Meister, Keri; Schultz, Kaylene Subject:RE: Rate Review - July 2022 Everything looks good, thanks Keri!      From: Meister, Keri <Keri.Meister@avistacorp.com>   Sent: Thursday, July 28, 2022 11:39 AM  To: Schultz, Kaylene <Kaylene.Schultz@avistacorp.com>; Garbarino, Marcus <Marcus.Garbarino@avistacorp.com>  Subject: FW: Rate Review ‐ July 2022    Would it be possible to get this back by tomorrow morning? I’ve got some prep work to do for the journals.    Thank you,  Keri  Keri Meister|AVISTA UTILITIES Resource Accounting Analyst|MSC 17 PO Box 3727|Spokane, WA 99220 Direct 509.495.2102|Fax 509.777.5217  keri.meister@avistacorp.com   From: Meister, Keri   Sent: Thursday, July 14, 2022 12:50 PM  To: Schultz, Kaylene <Kaylene.Schultz@avistacorp.com>; Garbarino, Marcus <Marcus.Garbarino@avistacorp.com>  Subject: Rate Review ‐ July 2022    Please review the attached rates review workbook for July 2022.    I updated the following:  WA_ID Jurisdictional tab                              monthly rate  GTI tab                                                              cell K20, ID Commodity Rate with GTI  WA_ID PGA Deferral‐Amort tab                 WA Commodity Rate, WA quarterly Interest Rate, ID Commodity Rate    Thanks!  Keri    Keri Meister|AVISTA UTILITIES Resource Accounting Analyst|MSC 7 PO Box 3727|Spokane, WA 99220 Direct 509.495.2102|Fax 509.777.5217  keri.meister@avistacorp.com   CONFIDENTIALITY NOTICE: The contents of this email message and any attachments are intended solely for the addressee(s) and may contain confidential and/or privileged information and may be legally protected from disclosure. If you are not the intended recipient of this message or an agent ID PGA July 2022 Page 8 of 12 JULY 2022 OFF-CYCLE PGA FILING BACKUP WASHINGTON AND IDAHO COMMODITY ONLY ID PGA July 2022 Page 9 of 12 AVISTA CORPORATION manual inputs Off-cycle PGA filing effect 7.1.22 - ID Commodity only JULY 2022 IDAHO PGA ‐ 150 Actual Billed Schedule Revenue Rider 150 Remove RCF Total PGA Cost Percentage Commodity Percentage Demand Commodity Cost Demand Cost (a)(b)(c)(d)(e)(f)(g)(h) [b*c][d*e][d*f] 0101 585,113$            0.99563 582,55$             79.17%20.83% 461,21$             121,34$            0111 396,501$            0.99563 394,768$              79.17% 20.83% 312,538$              82,230$              0112 21,761$              0.99563 21,666$                79.17% 20.83% 17,153$                4,513$                Schedule Totals 1,003,375$          998,99$             790,901$             208,089$           ‐                      July Unbilled Billed July Unbilled June Unbilled Reversal Total Commodity (g) (m) (s)[g+m+s] Schedule Therms Commodity Rate Demand Rate Commodity Cost Demand Cost 0101 461,21$           174,002$                     (200,691)$                       434,52$                            (i) (j) (k) (l) (m) (n)0111 312,538$            110,06$                     (97,708)$                         324,89$                            [j*k] [j*l]0112 17,153$              ‐$                               ‐$                                  17,153$                              0101 497,319 0.3498 0.09203 174,002$                                 na 790,901$           284,068$                     (298,399)$                       776,57$                            0111 314,583 0.3498 0.09203 110,06$                                 na TRUE TRUE TRUE Acct 19101 0112 0 0.3498 0.09203 ‐$                                         na 811,902 284,068$                                ‐$                                  Billed July Unbilled June Unbilled Reversal Total Demand (h)(n)(t)[h+n+t] June Unbilled Reversal 0101 ‐$                    ‐$                               ‐$                                  ‐$                                    Schedule Therms Commodity Rate Demand Rate Commodity Cost Demand Cost 0111 ‐$                    ‐$                               ‐$                                  ‐$                                    (o) (p) (q) (r) (s) (t)0112 ‐$                    ‐$                               ‐$                                  ‐$                                    [p*q] [p*r] ‐$                    ‐$                               ‐$                                  ‐$                                    0101 ‐760,65 0.2638 0.09203 (200,691)$                               na Acct 19101 0111 ‐370,33 0.2638 0.09203 (97,708)$                                  na 0112 0 0.2638 0.09203 ‐$                                         na ‐1,130,98 (298,399)$                               ‐$                                  H:\Natural Gas Accounting\Gas Cost Data Bases\PGA Rate Changes\2022\ID_07-2022 - PGA Rate Changes_COMMODITY ONLY.xlsxPGA Idaho 8/4/2022 ID PGA July 2022 Page 10 of 12 Revenue By Rate Schedule Data Source: Financial Reporting Gas for ID Data Updated Daily Accounting Period: 202207 Rate Schedule Desc Billing Determinant Meter Qty Usage Qty Revenue Amt YTD Average Meters YTD Usage YTD Revenue Amt 0101 - FIRM AND GENERAL SER RIDER 150 0 -55 585,113 0 -671 16,718,074 0111 - FIRM-LARGE GEN SERV RIDER 150 0 0 396,501 0 -88 5,923,922 0112 - FIRM-LARGE GEN SERV RIDER 150 0 0 21,761 0 0 80,298 Overall - Total 0 -55 1,003,375 0 -759 22,722,293 Page 3 of 4 Run Date: Aug 4, 2022 For Internal Use Only Rider 150 = PGA ID PGA July 2022 Page 11 of 12 Avista Utilities State of Idaho Gas Cost Calculation (per Therm) Variable Charges Deferred Exchange Total Estimated  Commodity Costs Sales Volumes (to  customers)WACOG Volumes Dollars Volumes Dollars Volumes Dollars Dollars Dollars Dollars (a)(b)(c)(d)(a) + (c) = (e) (b) + (d) = (f)(g)(h)(i)(j)(k) Jul‐22 1,842,969 480,278$               107,400 46,019$            1,950,369 526,297$                 4,265$   (165,141)$  365,421$                1,921,527 0.1902$                Aug‐22 1,842,969 480,278$               282,346 116,823$          2,125,315 597,101$                 4,258$   (165,141)$  436,218$                2,093,886 0.2083$                Sep‐22 1,803,769 470,062$               1,191,842 500,514$          2,995,611 970,576$                 1,984$   (167,016)$  805,544$                2,951,311 0.2729$                Oct‐22 2,542,678 708,019$               4,801,207 2,018,619$       7,343,885 2,726,638$              3,747$   (157,734)$  2,572,651$             7,235,284 0.3556$                Nov‐22 6,366,938 1,915,184$           5,522,130 2,483,247$       11,889,068 4,398,431$              4,334$   (151,594)$  4,251,171$             11,713,252 0.3629$                Dec‐22 6,375,731 1,917,829$           10,131,320 4,728,186$       16,507,051 6,646,015$              5,251$   (146,906)$  6,504,360$             16,262,944 0.3999$                Jan‐23 6,540,516 1,967,396$           9,155,589 4,328,579$       15,696,105 6,295,975$              5,978$   (150,703)$  6,151,250$             15,463,990 0.3978$                Feb‐23 5,710,950 1,717,862$           7,248,241 3,423,417$       12,959,191 5,141,279$              5,022$   (145,688)$  5,000,613$             12,767,550 0.3917$                Mar‐23 6,731,747 2,024,919$           4,548,984 1,912,165$       11,280,731 3,937,084$              4,270$   (155,109)$  3,786,245$             11,113,911 0.3407$                Apr‐23 959,063 233,100$               6,485,183 2,000,679$       7,444,246 2,233,779$              5,801$   (159,844)$  2,079,736$             7,334,161 0.2836$                May‐23 1,039,856 252,737$               3,365,405 979,198$          4,405,261 1,231,935$              5,355$   (167,719)$  1,069,571$             4,340,116 0.2464$                Jun‐23 1,114,313 270,834$               2,203,091 639,469$          3,317,404 910,303$                 4,293$   (185,719)$  728,877$                3,268,346 0.2230$                42,871,499 12,438,498$         55,042,738 23,176,915$    97,914,237 35,615,413$           54,558$  (1,918,314)$                 33,751,657$          96,466,278 0.34988$              Acct 19101 Commodity New without  GTI: Use for  deferrals Average 0.29013$                0.4211$             0.3637$    43.8% 56.2% GRI Funding (no change)0.00040                TOTAL Rate 0.35028 RCF: 1.004373 0.99563 Proposed Rate Proposed WACOG without RCF 0.35028$              New with GTI Proposed WACOG with RCF 0.35181$              Present Rate Present WACOG without RCF 0.26424$              Old with GTI Present WACOG with RCF 0.26540$              Change Change WACOG without RCF 0.08604$              Change WACOG with RCF 0.08641$              Proposed Demand Total 155 Proposed 0.10045$           0.10045$              Proposed 0.10089$           0.10089$              Proposed Proposed Demand Total 155 Proposed 0.08952$           0.08952$              Proposed 0.09005$           0.09005$              Proposed Proposed Proposed 0.01093$           0.01093$              Proposed 0.01084$           0.01084$              Proposed Proposed Index Cost Total Cost to Serve Average Load  (including fuel)Executed Hedges Tab: Commodity Page: 1 of 1 ID PGA July 2022 Page 12 of 12