Collect marginal distribution costs per utility

[jpvelez]

What

Collect $/kW-year marginal distribution costs for each utility.

Why

To get the data we need to run the bill alignment test on every utility.

How

We could try to get the same numbers that Brattle used:

• ConEd: fish out a single number out of their massive MCOS (coned_2018MarginalCost_2018)… maybe Table 13 on page 26?
• NiMo: table 2, page 4 of their 2023 EV Commercial Managed Charging Implementation Plan (nimo_EVCommercialManaged_2023)… easy peasy.
• LIPA/PSEG-LI: make sense of their 2025 MCOS (pseg-li_2025MarginalCost_2025)… it's somewhere in the exhibits, which are somewhat cryptic.
• NYSEG / RG&E: table 9-3 on page 97 of BCA Handbook (nysegrg&e_BenefitCostAnalysis_2023 lists transmission, primary distribution, and secondary distribution marginal costs as of a 2015 MCOS study, which is not longer on PSC website.
  • Although, I just found an excel model in this docket (NYSEG-RGE MCOS Study) that seems to have annual marginal costs by feeder??
• CenHud: TK of 2018 MCOS (cenhud_2018MarginalCost_2018)
• O&R: figure 10 on page 15 of O&R's 2018 MCOS seems to contain transmission, substation and sub-transmission, and primary feeder costs (o&r_2018MarginalCost_2019)

Or, better yet, we should use the latest round of MCOS studies that were filed in summer 2025 in the MCOS Docket (19-E-0283)… I haven't inspected these yet.

• CenHud: study (cenhud_Docket19E02832025_2025) and workpaper (cenhud_Docket19E02832025_2025a)
• ConEd: study (coned_Docket19E02832025_2025) and workpaper (coned_Docket19E02832025_2025a)
• NiMo: study (nimo_Docket19E02832025_2025) and workpaper (nimo_Docket19E02832025_2025a)
• NYSEG: study (nyseg_Docket19E02832025_2025) and workpaper (nyseg_Docket19E02832025_2025a)
• O&R: study (o&r_Docket19E02832025_2025) and workpaper (o&r_Docket19E02832025_2025a)
• RG&E: study (rg&e_Docket19E02832025_2025) and workpaper (rg&e_Docket19E02832025_2025a)

Deliverables

• A table of $/kW-year marginal distribution costs per utility in a comment
• Same table in a small CSV we can import into a notebook

[linear]

R2-84

[jpvelez]

Central Hudson figures, from p. 15 of 2025 MCOS Study (cenhud_Docket19E02832025_2025):

Interestingly, the PSC seems to have ordered that they calculate these marginal costs at substation level:

[jpvelez]

ConEd figures from p. 10 of 2025 MCOS Study (con_Docket19E02832025_2025).

System-wide figures:

"Segment-level" figures:

They also have substation-level MCs!