Prepared for

DTM+ Commercial & Industrial
Reliability ROI Calculator

Quantify avoided interruption cost for DTM+ deployments serving commercial and industrial customers. Uses the Berkeley Lab / DOE Interruption Cost Estimate (ICE) Calculator 2.0 non-residential cost functions (LBNL Phase 1 final report, 29 May 2025), with preset rate tables by utility ownership type. For regulatory submissions, validate against the live ICE 2.0 tool with utility-specific customer-mix data.

01 C&I Deployment Inputs

Deployment scope

DTM+ units deployed

Reliability baseline

Utility lookup Auto-fill SAIDI/SAIFI from EIA-861 (2023 detailed data files, released Oct 2024) and utility annual reports. IEEE 1366 standard, excluding major-event days. Override any value after selection.

SAIDI (baseline)Customer-minutes of interruption per customer per year. EIA-861 (2023 release, Oct 2024): IOU mean ≈140 min excl. ME / 335 min incl. ME. EIA-861 →

min/yr

SAIFI (baseline)Sustained interruptions per customer per year

events/yr

CAIDI (implied avg duration) 145 min Suburban mix

Outage duration profileApplies the selected distribution to avoided SAIDI minutes, not event counts. Use Suburban when the utility does not have feeder-level duration data.

Suburban baseline. Mixed overhead/underground feeders with moderate vegetation exposure. CAIDI sanity range: 120-180 min. Use when utility-specific duration data is not available.

Momentary <5 min

1-2 hour

4-8 hour

24+ hour

Rate source

Investor-owned utility. Per-CMI rates from ICE 2.0 non-residential functions.

Momentary $/CMI

2-hour $/CMI

8-hour $/CMI

24-hour $/CMI

DTM+ expected improvement

SAIDI reductionCustomer-minutes avoided via early-fault detection & faster restoration 15%

0→50

O&M — Avoided truck rolls

Truck rolls per transformer / yrAnnual site visits per monitored transformer (diagnosis, inspections, no-power calls). Set to your utility baseline.

Cost per truck rollS&C Electric cites $250–$1,000+; TSIA ~$1,000. Labor-dominated, distance-dependent

Truck rolls avoided by DTM+Remote diagnosis, eliminated no-fault-found visits, correct-crew-first-time dispatch 30%

Annual rolls avoided —

Risk avoidanceOptional. Enter only utility-specific values from rate orders or SLA schedules.

Annual regulatory exposurePBR / PIM penalty exposure for missing SAIDI or SAIFI targets (e.g., Hawaii PBR, Massachusetts SQ penalties). Enter the full downside amount

$/yr

SLA / credit exposureC&I service-level agreement credits paid when outages exceed contractual thresholds

$/yr

% of exposure avoided by DTM+Share of penalty / credit exposure preventable via early detection and faster restoration 40%

0→80

Revenue protection & enablementOptional. Industrial, data-center, or hospital revenue at risk + new-service enablement.

Revenue at risk per outage-hourAggregate C&I revenue impact per hour of major service disruption. Brattle/ERCOT 2024 interim VOLL: $25K–$50K/MWh. Enter $0 if N/A. Brattle VOLL →

$/hr

Avoided outage-hours / yrDTM+ early detection and faster restoration. Typically 5–30 hours / yr for a mid-size C&I fleet

hr/yr

New-service enablementIncremental revenue unlocked by better transformer visibility — safely connecting new C&I loads, EV chargers, DERs without oversizing

$/yr

Avoided equipment failureConverts catastrophic failures into planned replacements via DTM+ early detection (up to 27 days pre-failure). Per Ubicquia internal analysis.

Fleet-age preset (sets baseline failure rate)

Baseline annual failure rate% of fleet failing catastrophically per year. IEEE 493 baseline ≈0.41%; multi-utility studies 0.35–0.46%; aged-fleet utility averages 1–2%.

%/yr

Replacement-cost preset

Catastrophic replacement costUnit + expedite + emergency install + collateral damage. Newton-Evans Mid-2024 + current vendor data: 3-phase pad-mount $25K–$60K installed (60–80% inflation since 2020); 100 kVA single-phase $22K–$36K installed.

$/event

Planned replacement costScheduled end-of-life swap: no expedite premium, standard-time crew, no collateral damage. ≈40–50% of catastrophic.

$/event

% of failures converted to plannedShare of would-be catastrophic failures caught by DTM+ early warning. Default 50% reflects the 27-day detection signal converting to scheduled replacement before breakdown. 50%

0→90

DTM+ investmentHardware purchase. Utility purchases the DTM+ fleet outright. Unit cost covers hardware & platform license; install handled by utility crew or contractor.

Hardware + platform3-phase pad-mount DTM+ unit (Ubicquia list: $3,000). Covers device & platform license, not install

$/unit

Install costUtility crew or contractor labor to mount & commission. Typical $150–$500/unit

$/unit

Recurring software + connectivityOngoing platform, data, and support cost. Enter 0 for a pure capex assumption.

$/unit/yr

Total program cost (Year 1) —

Financial parameters

Analysis horizon

yrs

Discount rate

Benefit inflationAnnual escalation applied to benefits (payroll, cost indices). DTE model default 3%

Annual benefit

$—

Reliability + O&M

Per-transformer / yr

$—

Net benefit / DTM+ unit

Capex

$—

—

Payback

—

Time to recover capex

Net PV

$—

10-yr · 6% discount

Lifetime ROI

—

Undiscounted, over horizon

03 Cumulative net present value

Cumulative net present-value (Benefit - Cost), years 1-10

02 Benefit breakdown IOU

Stream / Metric	Value
Reliability — avoided customer-interruption cost	—
# of transformers monitored	—
Avoided customer-minutes / year	—
Blended $ / CMI rate Suburban	—
Annual reliability benefit	—
O&M — avoided truck rolls	—
Baseline truck rolls / year —	—
Truck rolls avoided (% × baseline)	—
Applied $ / truck roll	—
Annual O&M benefit	—
Risk avoidance — regulatory & SLA	—
Total annual exposure (reg + SLA)	—
Annual risk-avoidance benefit	—
Revenue protection & enablement	—
C&I revenue protected (hours × $/hr)	—
New-service enablement	—
Annual revenue benefit	—
Avoided equipment failure	—
Baseline catastrophic failures / yr	—
Failures converted to planned	—
Savings per converted failure	—
Annual equipment-failure benefit	—
Total annual benefit (all streams)	—
Cost — DTM+ investment Capex	—
Upfront cost (capex)	—
Recurring cost / year	—
Year 1 total cost	—
Lifetime cost (horizon)	—
Net annual (Benefit − Recurring cost)	—
Net NPV (horizon · discount)	—
Payback / Lifetime ROI	—

04 Sources & assumptions

Every default in this calculator traces back to a published source listed below. Refresh quarterly. Verified May 2026.

Assumption	Default in model	Industry source	Date
Reliability $/CMI rates (IOU non-residential)	$110 mom · $30 (2hr) · $16 (8hr) · $10 (24hr)	Berkeley Lab — ICE Calculator 2.0 Phase 1 final report (24-utility survey 2022–2024). Refresh against the live ICE 2.0 tool for regulatory submissions.	29 May 2025
US national SAIDI baseline	335 min incl. ME / 140 min excl. ME	EIA Form 861 2023 detailed data files (released Oct 2024); EIA Today in Energy 2022 reliability summary.	2023 data, Oct 2024
Truck-roll cost	$750 / roll	S&C Electric — "The Real Cost of a Truck Roll" ($250–$1,000+); TSIA ~$1,000 fully loaded.	2017 (re-cited 2022)
Distribution transformer annual failure rate	0.5% / yr (mid-life default)	IEEE 493 baseline ≈0.41%; multi-utility studies 0.35–0.46% (2018–2019); ComEd <0.5%; aged fleet 1–2%.	IEEE 493; peer-reviewed 2018–2019
Replacement cost (3-phase pad-mount)	$25K catastrophic / $12K planned	Newton-Evans — A Mid-2024 Assessment of the U.S. Distribution Transformer Industry; vendor pricing 2024–2025; DOE LPT Resilience Report for context.	Mid-2024
Value of lost load (revenue at risk)	$0 / hr (utility-specific input)	Brattle / ERCOT — Review of VOLL (interim $25K–$50K/MWh C&I); MISO Scarcity Pricing white paper (Apr 2024); literature range $11K–$67.78K/MWh.	Sep 2024
Discount rate (IOU / Muni / Coop)	7.0% / 4.0% / 3.5%	IOU WACC 6.5–8% range; muni tax-exempt bond rates 3–4%; CFC / RUS coop loan rates 3–4%; CPI ~3% (BLS).	Generally accepted finance practice