{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Selected Data","Authorized Rev Req","Incremental Rev Req"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":199,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Selected Data","index":0,"n_rows":50,"n_cols":20,"rows_kept":50,"cut":false,"hidden":false,"merged":[[30,1,30,15],[37,1,37,14]]}
["SDGE Revenue Requirement List"]
[{"$f":"'Authorized Rev Req'!A2","v":"Annual Period 2024"}]
[{"$f":"'Authorized Rev Req'!A3","v":"Reporting Date: Quarter Ended March 31"}]
["Summary of Selected Data",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Revenue"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," Requirement"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"$000"]
[1,"Current total system-level revenue requirement that is used for defining the reporting threshold:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Authorized Rev Req'!H93","v":1053552.6615547123}]
[null,"A","One-percent reporting threshold",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q7*0.01","v":10535.526615547124}]
[]
[2,"List of currently open proceedings that exceed the threshold for use of the affordability metrics (proceedings shaded gray filed prior to D.22-08-023):"]
[null,"A",{"$f":"'Incremental Rev Req'!B85","v":"A.22-05-016"},{"$f":"'Incremental Rev Req'!A85","v":"2024 GRC Application"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Incremental Rev Req'!D85","v":1033004.8084318247}]
[null,"B",{"$f":"'Incremental Rev Req'!B87","v":"A.22-05-016"},{"$f":"'Incremental Rev Req'!A87","v":"Pipeline Safety Enhancement Plan (PSEP) - High Pressure Distribution"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Incremental Rev Req'!D87","v":151571.916}]
[]
[]
[]
[]
[]
[]
[3,"List of currently open proceedings for which affordability metrics have been filed:"]
[null,"A",{"$f":"'Incremental Rev Req'!B85","v":"A.22-05-016"},{"$f":"'Incremental Rev Req'!A85","v":"2024 GRC Application"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q11","v":1033004.8084318247}]
[]
[]
[4,"List of currently open proceedings that do not exceed the threshold for use of the affordability metrics (proceedings shaded gray filed prior to D.22-08-023):"]
[null,"A",{"$f":"'Incremental Rev Req'!B86","v":"A.22-05-016"},{"$f":"'Incremental Rev Req'!A86","v":"Pipeline Safety Enhancement Plan (PSEP) -Local T"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Incremental Rev Req'!D86","v":5960.2346400000024}]
[null,"B",{"$f":"'Incremental Rev Req'!B88","v":"SoCalGas AL 6060"},{"$f":"'Incremental Rev Req'!A88","v":"TIMPBA"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Incremental Rev Req'!D88","v":8044.9585039999993}]
[null,"C",{"$f":"'Incremental Rev Req'!B89","v":"A.22-10-021"},{"$f":"'Incremental Rev Req'!A89","v":"Catastrophic Event Memorandum Account (CEMA)"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Incremental Rev Req'!D89","v":7122.202581999999}]
[]
[]
[]
[]
[5,"Total system-level revenue requirement if all pending revenue were granted in full:\nrequests were granted in full",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total"]
[null,"A","YE 2024",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Incremental Rev Req'!O100","v":1251521.6545130019}]
[null,"B","YE 2025",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Incremental Rev Req'!P100","v":1013660.4007814897}]
[null,"C","YE 2026",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Incremental Rev Req'!Q100","v":1105271.4938814177}]
[null,"D","YE 2027",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Incremental Rev Req'!R100","v":1127315.0841127592}]
[null,"E","YE 2028",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Incremental Rev Req'!S100","v":285641.50084714376}]
[]
[6,"Bundled residential average rate (RAR) if all pending revenue were granted in full (from Cost and Rate Tracker (CRT) as submitted by utility):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"cents/Therm"]
[null,"A","YE 2024",null,null,null,null,null,null,null,null,null,null,null,null,null,null,277.14294100965219]
[null,"B","YE 2025",null,null,null,null,null,null,null,null,null,null,null,null,null,null,238.50262633071912]
[null,"C","YE 2026",null,null,null,null,null,null,null,null,null,null,null,null,null,null,264.24929647402274]
[null,"D","YE 2027",null,null,null,null,null,null,null,null,null,null,null,null,null,null,272.18675088609132]
[null,"E","YE 2028",null,null,null,null,null,null,null,null,null,null,null,null,null,null,53.071398792572928]
[]
[7,"Bundled residential average monthly bill corresponding to RAR above for typical customer using a Typical 5-year average usage (from CRT as submitted by utility):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non-CARE","CARE"]
[null,"A","YE 2024",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,70.363527492227263,45.078581993327013]
[null,"B","YE 2025",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60.544135207052051,38.788418951707101]
[null,"C","YE 2026",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,67.086955996033453,42.979656893888865]
[null,"D","YE 2027",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,69.104045641017365,44.271775832417006]
[null,"E","YE 2028",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13.421797300436644,8.6025194859715821]

{"sheet":"Authorized Rev Req","index":1,"n_rows":93,"n_cols":10,"rows_kept":93,"cut":false,"hidden":false,"merged":[]}
["SDGE Revenue Requirement List"]
["Annual Period 2024"]
["Reporting Date: Quarter Ended March 31"]
[]
[null,"Revenue Requirement Date:","2022-01-01","2023-01-01","2023-03-01","2023-08-01","2023-11-01","2024-01-01"]
[null,"Advice Letter:","AL 3046-G","AL 3149-G","AL 3163-G","AL 3213-G","AL 3244-G","AL 3261-G"]
["Filing Description","Authority for Revenue Requirement as of 11/1/2023","Authorized Revenue Requirement       ($000) ","Authorized Revenue Requirement       ($000) ","Authorized Revenue Requirement       ($000) ","Authorized Revenue Requirement       ($000) ","Authorized Revenue Requirement       ($000) ","Authorized Revenue Requirement       ($000) ","Revenue Recovery Mechanism","Balancing Account "]
["Safety Affordability Reliability Proceedings"]
["Total Allocated Base Margin","D.19-09-051, A.22-05-016",412393.92784195661,412992.27437904326,412992.27437904326,412992.27437904326,412992.27437904326,417772.13947090023,"Allocated Base Margin","N"]
["SCG Transport excl Core Storge & Load Balance $000","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B",10101.5487258045,18927.301506775031,18927.301506775031,19163.89443334132,16390.059073287463,59110.52142599332,"ECPT","N"]
["SCG Core Seasonal Storage","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B",14374.700920168953,18907.657128629489,18907.657128629489,18907.657128629489,17001.410111315246,17001.410111315254,"Seasonal Storage","N"]
["SCG Load Balancing Allocated to ALL SDGE $000","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B",9102.0837826634306,11569.318977706102,11569.318977706102,11569.318977706102,11389.102717475975,11389.102717475971,"ECPT","N"]
["Pipeline Safety Enhancement Plan (PSEP) -Local T (subtracted from Base Margin and allocated here)","D.19-09-051",2576.6109000000001,2698.4483999999993,2698.4483999999993,2698.4483999999993,2698.4483999999993,2698.4483999999993,"Local Transmission","N"]
["LUAF","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B",3180.2303217247427,4359.515855476232,4359.515855476232,4359.515855476232,4359.515855476232,3607.5249270959521,"46% Res (LUAF, Other)","N"]
["Company Use Gas: Other","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B",234.78660051758473,321.84961592802711,321.84961592802711,321.84961592802711,321.84961592802711,266.3324439520315,"ECPT","N"]
["SDG&E NGLAPBA","AL 3149-G, AL 3071-G-B, 3247-G-B",983.22148920005588,734.78317488009657,734.78317488009657,143.91573455627505,143.91573455627505,666.38432929558826,"EPAM","N"]
["SDG&ENERBA - NGLAP Subacct","AL 3149-G,  AL 3071-G-B,3247-G-B",1620.0351328756483,5725.6373585236443,5725.6373585236443,6792.859113609511,6792.859113609511,4950.4356988439195,"EPAM","N"]
["SDG&E PSEP - 2017 Forecast Application RevReq Capital Cost  - Local Transmission","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B",52.108015617715203,47.131684850968078,47.131684850968078,47.131684850968078,47.131684850968078,48.348788764696145,"Local Transmission","N"]
["CFCA","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B",37541.479619999998,55563.797728400001,55563.797728400001,55563.797728400001,55563.797728400001,25794.189268400005,"CFCA","Y"]
["CFCA -NGV only","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B",-210.72329159999998,3011.7432064000004,3011.7432064000004,3011.7432064000004,3011.7432064000004,2805.0950652000001,"Non-Residential","Y"]
["CFCA - C&I shortfall only","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B",5444.0260091999999,40.920424000000004,40.920424000000004,40.920424000000004,40.920424000000004,37.851392200000006,"Non-Residential","Y"]
["Hazardous Substance Cleanup Cost Acct HSCCA","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B",290.51172240000005,122.76127200000001,122.76127200000001,122.76127200000001,122.76127200000001,72.633752600000008,"ECPT","Y"]
["Master Meter Balancing Account  (MMBA)","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B",10311.120288,11907.843384,11907.843384,11907.843384,11907.843384,15931.344073800004,"EPAM","Y"]
["PBOPBA","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B",-623.51692177259997,-531.23917447400004,-531.23917447400004,-531.23917447400004,-531.23917447400004,-354.98467820000002,"EPAM","Y"]
["Pension BA","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B",-575.93130622920012,-298.79172895260001,-298.79172895260001,-298.79172895260001,-298.79172895260001,51.15053000000001,"EPAM","Y"]
["Safety Enhancement Balancing Account - Local Transmission","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B",3036.4630647777644,3084.2385558959263,3084.2385558959263,3084.2385558959263,3084.2385558959263,3321.4404759571516,"Local Transmission","Y"]
["Safety Enhancement Balancing Account - Distribution","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B",38688.933410192403,39079.214628479465,39079.214628479465,39079.214628479465,39079.214628479465,48957.417309766293,"Distribution","Y"]
["Rewards & Penalties Bal Acct  RPBA","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B",-127.86607500000001,310.99522240000005,310.99522240000005,310.99522240000005,310.99522240000005,-119.69224020000003,"EPAM","Y"]
["SGPMA - Rev Req for NEXT Year","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B",1545.2359431600003,1545.3598123600002,1545.3598123600002,1545.3598123600002,1545.3598123600002,1696.1515748000002,"ECPT","Y"]
["Integrated Transmission  Margin ITBA","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B",24.550286399999997,704.35051671497718,704.35051671497718,704.35051671497718,704.35051671497718,-289.51199980000001,"ECPT","Y"]
["Liability Insurance Premium Balancing Account (LIPBA)","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B",3038.0979420000003,4285.3914033999999,4285.3914033999999,4285.3914033999999,4285.3914033999999,4093.0654106000011,"EPAM","Y"]
["Residential Uncollectible Balancing Account","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B",5629.1760858000007,10487.904671200002,10487.904671200002,10487.904671200002,10487.904671200002,26260.682102000006,"EPAM","Y"]
["NFCA -Margin Only","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B",-7128.7894133999998,3046.5255668000004,3046.5255668000004,3046.5255668000004,3046.5255668000004,4377.4623573999997,"Non-Residential","Y"]
["NFCA -Nonmargin Other","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B",1705.2219761999997,794.87923620000004,794.87923620000004,794.87923620000004,794.87923620000004,6588.1882640000003,"Non-Residential","Y"]
["NFCA -Nonmargin SCG","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B",-100.24700279999999,132.991378,132.991378,132.991378,132.991378,-1020.9645788,"Non-Residential","Y"]
["Minimum Bil/Customer Charge Revenue ","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B",1816.4409600000001,1816.4409600000001,1816.4409600000001,1816.4409600000001,1816.4409600000001,1816.4409600000001,"All Residential","N"]
["Borrego Revenue","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B",64.571742326140509,64.571742326140509,64.571742326140509,64.571742326140509,64.571742326140509,64.571742326140509,"All Residential","N"]
["Employee Discount (Schd GR)","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B",-367.20946999999097,-367.20946999999097,-367.20946999999097,-367.20946999999097,-367.20946999999097,-367.20946999999097,"All Residential","N"]
["SDFFD","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B",1986.9012193223789,2243.52579553028,2243.52579553028,2243.52579553028,2235.2764847903877,2098.3340670427324,"All Residential","N"]
["Customer Information System  Account - CISBA","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B",0,28619.672934858001,28619.672934858001,28619.672934858001,28619.672934858001,0,"EPAM","Y"]
["Transition, Stabilization and OCM Balancing Account - TSOBA-G ","AL 3039-G, 3247-G-B",0,10830.843399584999,10830.843399584999,10830.843399584999,10830.843399584999,0,"EPAM","Y"]
["Percentage of Income Payment Plan Balancing Account (PIPPBA)","D. 21-10-012, 3247-G-B",0,0,0,0,0,113.55417660000001,"ECPT","Y"]
["GRC 2024 Track 2-Wildfire Mitigation Plan Memo Acct","D.24-02-010",0,0,0,0,0,0,"ECPT","Y"]
["Gain/Loss on Sale Memo Acct GLOSMA","D.20-02-045, 3247-G-B",0,0,0,0,0,-1.0230106000000003,"EPAM","Y"]
[]
[]
["   Subtotal Safety Affordability Reliability",null,556607.70051950624,652780.64954693615,652780.64954693615,653493.59678826446,648625.04883992637,659436.83485872927]
[]
[]
[]
["Public Policy Proceedings"]
["  Green House Gas Balancing Account (GHGBA) - End User Revenue Requirement","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G , 3247-G-B",62728.323235565404,62672.954086711361,62672.954086711361,62672.954086711361,62672.954086711361,86283.785928646161,"GHG End User","N"]
["  Green House Gas Balancing Account (GHGBA) - LUAF Revenue Requirement","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G , 3247-G-B",830.72849948880003,809.23321752201855,809.23321752201855,809.23321752201855,809.23321752201855,1046.1279719769354,"46% Res (LUAF, Other)","N"]
["AB32 Fees (subtracted from base margin and allocated here)","D.19-09-051",528.8540862000001,528.89648020000016,528.89648020000016,528.89648020000016,528.89648020000016,528.89648020000016,"46% Res (LUAF, Other)","N"]
["Green House Gas Balancing Account (GHGBA) - Company Gas Compressor","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G , 3247-G-B",-138.095361,1354.208041356786,1354.208041356786,1354.208041356786,1354.208041356786,-27046.354242800004,"ECPT","Y"]
["Green House Gas Balancing Account (GHGBA) - End User","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G , 3247-G-B",-5290.5867191999996,-7069.4727362546482,-7069.4727362546482,-7069.4727362546482,-7069.4727362546482,17577.156816130475,"GHG End User","Y"]
["Green House Gas Balancing Account (GHGBA) - LUAF","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G , 3247-G-B",-11.252214599999999,-248.04164622186403,-248.04164622186403,-248.04164622186403,-248.04164622186403,-899.22631739999997,"46% Res (LUAF, Other)","Y"]
["FERC Settlement Proceeds MA","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G , 3247-G-B",1.0229286000000002,0,0,0,0,0,"Non-Residential","Y"]
["New Environmental Regulation Balancing Account (NERBA) - Admin Fees Subaccount","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G , 3071-G-B, 3247-G-B",413.26315440000002,2305.8658924000006,2305.8658924000006,2305.8658924000006,2305.8658924000006,-801.01729980000027,"46% Res (LUAF, Other)","Y"]
["New Environmental Regulation Balancing Account (NERBA) - EPAM","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G ,AL 3071-G-B,  3247-G-B",105.36164580000001,864.44395699999995,864.44395699999995,864.44395699999995,864.44395699999995,2678.2417508000008,"EPAM","Y"]
["  TLS Adjustment","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G , 3247-G-B",6681.9931823319448,-10406.77744459657,-10437.810558367659,-10411.005461001434,-10207.828179601249,-9118.6142854368882,"Non-Residential","N"]
["CSI Thermal Program memoradum Account","D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G , 3247-G-B",806.06773680000003,333.50145560000004,333.50145560000004,333.50145560000004,333.50145560000004,95.139985800000005,"46% Res (LUAF, Other)","Y"]
["Biomethane Cost Incentive Pgm Balancing Acct  (BCIPBA)  ","D. 16-12-043, AL 3129-G-A and AL 3129-G , 3247-G-B",0,2813.2791500000003,2813.2791500000003,2813.2791500000003,2813.2791500000003,37.851392200000006,"ECPT","Y"]
["Biomethane Procurement and Pilot Costs Balancing Account (BPPCBA) - Program Admin Subaccount (EPAM)","D.22-02-025, 3247-G-B",0,0,0,0,0,29.667307400000009,"EPAM","y"]
[]
[]
[]
["PPPS Programs"]
["California Alternate Rates for Energy (CARE) - Funding","AL 3137-G, D.21-06-015, 3245-G",25613.072,22795.559000000001,22795.559000000001,22795.559000000001,22795.559000000001,21383.37754112266,"Public Purpose Programs","N"]
["California Alternate Rates for Energy (CARE) - Admin Expenses","AL 3137-G, D.21-06-015, 3245-G",727.2829999999999,761.47,761.47,761.47,761.47,771.47047999999995,"Public Purpose Programs","N"]
["California Alternate Rates for Energy (CARE) - Amortization","AL 3137-G, AL 3245-G, AL 3247-G-B",1000,-1000,-1000,-1000,-1000,7000,"Public Purpose Programs","Y"]
["Energy Savings Assistance (ESA/LIEE/DAP)","AL 3137-G, D.21-06-015, AL 3247-G-B",8041.1949999999997,10315.642,10315.642,10315.642,10315.642,7005.5879999999997,"Public Purpose Programs","N"]
["Energy Efficiency","D.23-06-055 AL 3137-G, AL 3035-G, AL 3245-G",15368.681745714286,12089.109,12089.109,12089.109,12089.109,25981.63,"Public Purpose Programs","N"]
["RD&D ","AL 3137-G, AL 3245-G",1929.78072,2278.9604600000002,2278.9604600000002,2278.9604600000002,2278.9604600000002,2183.7319900000002,"Public Purpose Programs","N"]
["Bureau Of Equalization BOE","AL 3137-G, AL 3245-G",56.159990000000001,55.36833,55.36833,55.36833,55.36833,47.053350000000002,"Public Purpose Programs","N"]
[]
[]
[]
[]
[]
["   Subtotal Public Policy ",null,119391.85263010046,101254.1992437171,101223.16612994601,101249.97122731223,101453.14850871242,134784.50684883934]
[]
[]
["Procurement"]
["Procurement","D.97-07-061",372042.57581360283,475248.57632622559,475248.57632622559,475248.57632622559,475248.57632622559,259331.31984714375,"Core Procurement"]
[]
[]
[]
[]
[]
["   Subtotal Procurement",null,372042.57581360283,475248.57632622559,475248.57632622559,475248.57632622559,475248.57632622559,259331.31984714375]
[]
["Total Authorized Revenue",null,1048042.1289632095,1229283.4251168789,1229252.3920031078,1229992.1443418022,1225326.7736748643,{"$f":"H47+H81+H91","v":1053552.6615547123}]

{"sheet":"Incremental Rev Req","index":2,"n_rows":123,"n_cols":19,"rows_kept":123,"cut":false,"hidden":false,"merged":[[115,0,115,10],[116,5,116,9],[82,5,82,9],[5,13,5,18],[83,13,83,18],[5,0,5,10],[81,0,81,10]]}
["Annual Period 2024"]
["Reporting Date: Quarter Ended March 31"]
[]
["Current Revenue Requirement ($000):",1053552.6615547123]
["Current Revenue Requirement Effective:","2024-01-01"]
["Approved Application(s), Implemented Since Jan 1 or To Be Implemented",null,null,null,null,null,null,null,null,null,null,null,null,"Authorized"]
["Filing Description","Proceeding","Authority for Revenue Requirement","Authorized Revenue Requirement with FF&U ($000)","Revenue Recovery Mechanism","Authorized Revenue Requirement with FF&U ($000) - Breakout by Year",null,null,null,null,"Existing or New Item (if existing, use delta from prior for rate impact)",null,null,null,2024,2025,2026,2027,2028]
["Safety Affordability Reliability Proceedings",null,null,"2024-01-01",null,2024,2025,2026,2027,2028,null,null,null,"Core Procurement",259331.31984714375,259331.31984714375,259331.31984714375,259331.31984714375,259331.31984714375]
["Total Allocated Base Margin",null,"D.19-09-051, A.22-05-016",417772.13947090023,"Allocated Base Margin",417772.13947090023,417772.13947090023,417772.13947090023,417772.13947090023,0,"Existing",null,null,"Allocated Base Margin",417772.13947090023,417772.13947090023,417772.13947090023,417772.13947090023,0]
["SCG Transport excl Core Storge & Load Balance $000",null,"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B",59110.52142599332,"ECPT",59110.52142599332,0,0,0,0,"Existing",null,null,"Distribution",48957.417309766293,0,0,0,0]
["SCG Core Seasonal Storage",null,"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B",17001.410111315254,"Seasonal Storage",17001.410111315254,0,0,0,0,"Existing",null,null,"All Residential",3612.1372993688819,0,0,0,0]
["SCG Load Balancing Allocated to ALL SDGE $000",null,"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B",11389.102717475971,"ECPT",11389.102717475971,0,0,0,0,"Existing",null,null,"Local Transmission",6068.2376647218471,0,0,0,0]
["Pipeline Safety Enhancement Plan (PSEP) -Local T (subtracted from Base Margin and allocated here)",null,"D.19-09-051",2698.4483999999993,"Local Transmission",2698.4483999999993,0,0,0,0,"Existing",null,null,"Seasonal Storage",17001.410111315254,0,0,0,0]
["LUAF",null,"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B",3607.5249270959521,"46% Res (LUAF, Other)",3607.5249270959521,0,0,0,0,"Existing",null,null,"GHG End User",103860.94274477664,0,0,0,0]
["Company Use Gas: Other",null,"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B",266.3324439520315,"ECPT",266.3324439520315,0,0,0,0,"Existing",null,null,"Public Purpose Programs",64372.851361122666,52461.612999999998,53377.255000000005,37424.365000000005,26310.181]
["SDG&E NGLAPBA",null,"AL 3149-G, AL 3071-G-B, 3247-G-B",666.38432929558826,"EPAM",666.38432929558826,0,0,0,0,"Existing",null,null,"-",0,0,0,0,0]
["SDG&ENERBA - NGLAP Subacct",null,"AL 3149-G,  AL 3071-G-B,3247-G-B",4950.4356988439195,"EPAM",4950.4356988439195,0,0,0,0,"Existing",null,null,"46% Res (LUAF, Other)",3577.4457478728873,0,0,0,0]
["SDG&E PSEP - 2017 Forecast Application RevReq Capital Cost  - Local Transmission",null,"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B",48.348788764696145,"Local Transmission",48.348788764696145,0,0,0,0,"Existing",null,null,"ECPT",45350.281241021308,12271.016944999999,3233.7377709999996,1786.1772059999998,0]
["CFCA",null,"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B",25794.189268400005,"CFCA",25794.189268400005,0,0,0,0,"Existing",null,null,"EPAM",54185.271273739512,21791.861599999997,24855.447099999998,0,0]
["CFCA -NGV only",null,"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B",2805.0950652000001,"Non-Residential",2805.0950652000001,0,0,0,0,"Existing",null,null,"CFCA",25794.189268400005,0,0,0,0]
["CFCA - C&I shortfall only",null,"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B",37.851392200000006,"Non-Residential",37.851392200000006,0,0,0,0,"Existing",null,null,"Non-Residential",3669.0182145631134,0,0,0,0]
["Hazardous Substance Cleanup Cost Acct HSCCA",null,"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B",72.633752600000008,"ECPT",72.633752600000008,0,0,0,0,"Existing",null,null,"Total",1053552.6615547123,763627.95086304401,758569.89918904402,716314.00152404397,285641.50084714376]
["Master Meter Balancing Account  (MMBA)",null,"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B",15931.344073800004,"EPAM",15931.344073800004,21791.861599999997,24855.447099999998,0,0,"Existing",null,null,"CPUC Fee",1E-3]
["PBOPBA",null,"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B",-354.98467820000002,"EPAM",-354.98467820000002,0,0,0,0,"Existing",null,null,"Check",0,0,0,0,0]
["Pension BA",null,"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B",51.15053000000001,"EPAM",51.15053000000001,0,0,0,0,"Existing"]
["Safety Enhancement Balancing Account - Local Transmission",null,"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B",3321.4404759571516,"Local Transmission",3321.4404759571516,0,0,0,0,"Existing"]
["Safety Enhancement Balancing Account - Distribution",null,"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B",48957.417309766293,"Distribution",48957.417309766293,0,0,0,0,"Existing"]
["Rewards & Penalties Bal Acct  RPBA",null,"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B",-119.69224020000003,"EPAM",-119.69224020000003,0,0,0,0,"Existing"]
["SGPMA - Rev Req for NEXT Year",null,"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B",1696.1515748000002,"ECPT",1696.1515748000002,0,0,0,0,"Existing"]
["Integrated Transmission  Margin ITBA",null,"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B",-289.51199980000001,"ECPT",-289.51199980000001,0,0,0,0,"Existing"]
["Liability Insurance Premium Balancing Account (LIPBA)",null,"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B",4093.0654106000011,"EPAM",4093.0654106000011,0,0,0,0,"Existing"]
["Residential Uncollectible Balancing Account",null,"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B",26260.682102000006,"EPAM",26260.682102000006,0,0,0,0,"Existing"]
["NFCA -Margin Only",null,"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B",4377.4623573999997,"Non-Residential",4377.4623573999997,0,0,0,0,"Existing"]
["NFCA -Nonmargin Other",null,"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B",6588.1882640000003,"Non-Residential",6588.1882640000003,0,0,0,0,"Existing"]
["NFCA -Nonmargin SCG",null,"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B",-1020.9645788,"Non-Residential",-1020.9645788,0,0,0,0,"Existing"]
["Minimum Bil/Customer Charge Revenue ",null,"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B",1816.4409600000001,"All Residential",1816.4409600000001,0,0,0,0,"Existing"]
["Borrego Revenue",null,"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B",64.571742326140509,"All Residential",64.571742326140509,0,0,0,0,"Existing"]
["Employee Discount (Schd GR)",null,"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B",-367.20946999999097,"All Residential",-367.20946999999097,0,0,0,0,"Existing"]
["SDFFD",null,"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B",2098.3340670427324,"All Residential",2098.3340670427324,0,0,0,0,"Existing"]
["Customer Information System  Account - CISBA",null,"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G, 3247-G-B",0,"EPAM",0,0,0,0,0,"Existing"]
["Transition, Stabilization and OCM Balancing Account - TSOBA-G ",null,"AL 3039-G, 3247-G-B",0,"EPAM",0,0,0,0,0,"Existing"]
["GRC 2024 Track 2-Wildfire Mitigation Plan Memo Acct",null,"D.24-02-010",0,"ECPT",0,12271.016944999999,3233.7377709999996,1786.1772059999998,0,"New"]
["Percentage of Income Payment Plan Balancing Account (PIPPBA)",null,"D. 21-10-012, 3247-G-B",113.55417660000001,"ECPT",113.55417660000001,0,0,0,0,"New"]
["Gain/Loss on Sale Memo Acct GLOSMA",null,"D.20-02-045, 3247-G-B",-1.0230106000000003,"EPAM",-1.0230106000000003,0,0,0,0,"New"]
[]
["Public Policy Proceedings"]
["  Green House Gas Balancing Account (GHGBA) - End User Revenue Requirement",null,"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G , 3247-G-B",86283.785928646161,"GHG End User",86283.785928646161,0,0,0,0,"Existing"]
["  Green House Gas Balancing Account (GHGBA) - LUAF Revenue Requirement",null,"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G , 3247-G-B",1046.1279719769354,"46% Res (LUAF, Other)",1046.1279719769354,0,0,0,0,"Existing"]
["AB32 Fees (subtracted from base margin and allocated here)",null,"D.19-09-051",528.89648020000016,"46% Res (LUAF, Other)",528.89648020000016,0,0,0,0,"Existing"]
["Green House Gas Balancing Account (GHGBA) - Company Gas Compressor",null,"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G , 3247-G-B",-27046.354242800004,"ECPT",-27046.354242800004,0,0,0,0,"Existing"]
["Green House Gas Balancing Account (GHGBA) - End User",null,"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G , 3247-G-B",17577.156816130475,"GHG End User",17577.156816130475,0,0,0,0,"Existing"]
["Green House Gas Balancing Account (GHGBA) - LUAF",null,"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G , 3247-G-B",-899.22631739999997,"46% Res (LUAF, Other)",-899.22631739999997,0,0,0,0,"Existing"]
["FERC Settlement Proceeds MA",null,"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G , 3247-G-B",0,"Non-Residential",0,0,0,0,0,"Existing"]
["New Environmental Regulation Balancing Account (NERBA) - Admin Fees Subaccount",null,"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G , 3071-G-B, 3247-G-B",-801.01729980000027,"46% Res (LUAF, Other)",-801.01729980000027,0,0,0,0,"Existing"]
["New Environmental Regulation Balancing Account (NERBA) - EPAM",null,"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G ,AL 3071-G-B,  3247-G-B",2678.2417508000008,"EPAM",2678.2417508000008,0,0,0,0,"Existing"]
["  TLS Adjustment",null,"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G , 3247-G-B",-9118.6142854368882,"Non-Residential",-9118.6142854368882,0,0,0,0,"Existing"]
["CSI Thermal Program memoradum Account",null,"D.20-02-045, AL 3149-G, AL 3129-G-A and AL 3129-G , 3247-G-B",95.139985800000005,"46% Res (LUAF, Other)",95.139985800000005,0,0,0,0,"Existing"]
["Biomethane Cost Incentive Pgm Balancing Acct  (BCIPBA)  ",null,"D. 16-12-043, AL 3129-G-A and AL 3129-G , 3247-G-B",37.851392200000006,"ECPT",37.851392200000006,0,0,0,0,"Existing"]
["Biomethane Procurement and Pilot Costs Balancing Account (BPPCBA) - Program Admin Subaccount (EPAM)",null,"D.22-02-025, 3247-G-B",29.667307400000009,"EPAM",29.667307400000009,0,0,0,0,"New"]
[]
[]
["PPPS Programs"]
["California Alternate Rates for Energy (CARE) - Funding",null,"AL 3137-G, D.21-06-015, 3245-G",21383.37754112266,"Public Purpose Programs",21383.37754112266,11769.36,11887.054,11887.054,0,"Existing"]
["California Alternate Rates for Energy (CARE) - Admin Expenses",null,"AL 3137-G, D.21-06-015, 3245-G",771.47047999999995,"Public Purpose Programs",771.47047999999995,813.95299999999997,814.18100000000004,0,0,"Existing"]
["California Alternate Rates for Energy (CARE) - Amortization",null,"AL 3137-G, AL 3245-G, AL 3247-G-B",7000,"Public Purpose Programs",7000,0,0,0,0,"Existing"]
["Energy Savings Assistance (ESA/LIEE/DAP)",null,"AL 3137-G, D.21-06-015, AL 3247-G-B",7005.5879999999997,"Public Purpose Programs",7005.5879999999997,14340.989,15138.709000000001,0,0,"Existing"]
["Energy Efficiency",null,"D.23-06-055 AL 3137-G, AL 3035-G, AL 3245-G",25981.63,"Public Purpose Programs",25981.63,25537.311000000002,25537.311000000002,25537.311000000002,26310.181,"Existing"]
["RD&D ",null,"AL 3137-G, AL 3245-G",2183.7319900000002,"Public Purpose Programs",2183.7319900000002,0,0,0,0,"Existing"]
["Bureau Of Equalization BOE",null,"AL 3137-G, AL 3245-G",47.053350000000002,"Public Purpose Programs",47.053350000000002,0,0,0,0,"Existing"]
[]
[]
[]
["Procurement",null,"D.97-07-061",259331.31984714375,"Core Procurement",259331.31984714375,259331.31984714375,259331.31984714375,259331.31984714375,259331.31984714375,"Existing"]
[]
[]
[]
["Total Approved, Implemented Since Jan 1 or To Be Implemented",null,null,1053552.6615547123,null,1053552.6615547123,763627.95086304389,758569.89918904391,716314.00152404397,285641.50084714376]
[]
["CPUC Fee",null,null,null,"CPUC Fee",1E-3]
[]
[]
["Pending Application(s) Not Yet Approved"]
["Filing Description","Proceeding","Basis of Revenue Requirement Forecast:  Application, Amended Application , Amended Testimony,  Proposed Settlement Agreement, Proposed Decision","Proposed Revenue Requirement with FF&U ($000)","Proposed Revenue Recovery Mechanism","Incremental Revenue Requirement with FF&U ($000) - Breakout by Year",null,null,null,null,"Existing or New Item (if existing, use delta from prior for rate impact)"]
["Safety Affordability Reliability Proceedings",null,null,null,null,2024,2025,2026,2027,2028,null,"Include in Impact",null,"Authorized + Pending"]
["2024 GRC Application","A.22-05-016","Application",1033004.8084318247,"Allocated Base Margin",143957.86507228977,209067.78559844574,307133.79413237382,372845.36362871522,null,"Existing","Y",null,null,2024,2025,2026,2027,2028]
["Pipeline Safety Enhancement Plan (PSEP) -Local T","A.22-05-016","Application",5960.2346400000024,"Local Transmission",-515.59919999999875,2100.6073200000001,2158.3665600000004,2216.8599600000002,null,"Existing","Y",null,"Core Procurement",259331.31984714375,259331.31984714375,259331.31984714375,259331.31984714375,259331.31984714375]
["Pipeline Safety Enhancement Plan (PSEP) - High Pressure Distribution","A.22-05-016","Application",151571.916,"Distribution",39359.565999999999,38864.057000000001,37409.434000000001,35938.858999999997,null,"Existing","Y",null,"Allocated Base Margin",561730.00454319001,626839.92506934598,724905.93360327405,790617.50309961545,0]
["TIMPBA","SoCalGas AL 6060","Advice Letter",8044.9585039999993,"Local Transmission",8044.9585039999993,null,null,null,null,"New","Y",null,"Distribution",88316.983309766292,38864.057000000001,37409.434000000001,35938.858999999997,0]
["Catastrophic Event Memorandum Account (CEMA)","A.22-10-021","Application",7122.202581999999,"EPAM",7122.202581999999,null,null,null,null,"New","Y",null,"All Residential",3612.1372993688819,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,"-",null,"Local Transmission",13597.596968721848,2100.6073200000001,2158.3665600000004,2216.8599600000002,0]
[null,null,null,null,null,null,null,null,null,null,null,"-",null,"Seasonal Storage",17001.410111315254,0,0,0,0]
["Public Policy Proceedings",null,null,null,null,null,null,null,null,null,null,"-",null,"GHG End User",103860.94274477664,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,"-",null,"Public Purpose Programs",64372.851361122666,52461.612999999998,53377.255000000005,37424.365000000005,26310.181]
[" Cost Allocation Proceeding","A. 22-09-015","Application",0,"EPAM",0,0,0,0,null,"Existing","Y",null,"-",0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,"-",null,"46% Res (LUAF, Other)",3577.4457478728873,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,"-",null,"ECPT",45350.281241021308,12271.016944999999,3233.7377709999996,1786.1772059999998,0]
[null,null,null,null,null,null,null,null,null,null,null,"-",null,"EPAM",61307.47385573951,21791.861599999997,24855.447099999998,0,0]
[null,null,null,0,null,null,null,null,null,null,null,"-",null,"CFCA",25794.189268400005,0,0,0,0]
[null,null,null,0,null,null,null,null,null,null,null,"-",null,"Non-Residential",3669.0182145631134,0,0,0,0]
[null,null,null,0,null,null,null,null,null,null,null,"-",null,"Total",1251521.6545130019,1013660.4007814897,1105271.4938814177,1127315.0841127592,285641.50084714376]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Incremental Revenues",197968.99295828957,250032.44991844567,346701.59469237365,411001.08258871525,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"CPUC Fee",1E-3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Check Figure",0,-4.457542672753334E-7,-3.7380959838628769E-7,2.8481008484959602E-7,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,0,null,null,null,null,null,null,null,"-"]
["Total Pending, Filed but not Approved",null,null,1205704.1201578248,null,197968.99295828977,250032.44991844575,346701.59469237382,411001.08258871519,0]
[]
["Applications Projected to be Filed, Next 12 Months"]
["Filing Description","Estimated Filing Date","Filing Basis","Proposed Revenue Requirement ($000)","Proposed Revenue Recovery Mechanism","Projected Authorized Revenue Requirement ($000) - Breakout by Year",null,null,null,null,"Existing or New Item (if existing, use delta from prior for rate impact)"]
["Safety Affordability Reliability Proceedings",null,null,null,null,2024,2025,2026,2027,2028]
[]
[]
[]
[]
["Public Policy Proceedings"]