Mendril Utilities
Utility billing, outages, field service, and asset reliability
About Mendril Utilities
Industry
Electric utility
Company size
Large regional regulated distribution utility
Operating scale represented
185,000 fictional customer accounts, 155,000 premises, 170,000 installed meters, 32,000 grid assets, 3.08 million monthly bills, 2.94 million bill settlements, 1.18 million sampled daily meter reads, 18,000 outage events, 360,000 service orders, and 95,000 maintenance work records
Planning note
Enterprise-tier BI kit focused on meter-to-cash performance, outage reliability, field service workload, meter-read quality, and asset condition
Mendril Utilities is a fictional electric distribution utility built for BI teams that want credible customer, billing, collections, outage, field-service, sampled meter-read, and asset-maintenance analysis without exposing real account holders, municipalities, grid equipment, or operational records. The kit is intentionally shaped around a large regulated distribution operator, so customers can model meter-to-cash performance, arrears exposure, restoration burden, crew workload, and condition-driven maintenance tradeoffs in one coherent utility story.
Operating Profile
- Serves residential, commercial, industrial, municipal, and public-service customers across eight fictional electric-distribution territories.
- Owns and maintains substations, feeders, transformer banks, switchgear, and service-line groups with territory-based operating districts and crew coverage.
- Manages billing, collections, outage restoration, reconnects, meter programs, and field service through a mix of internal crews and contractor support.
- Keeps the scope on electric distribution operations rather than wholesale markets, generation dispatch, or SCADA telemetry.
Recent Business Events
- 1Mendril unified outage-cause coding and restoration reporting so reliability teams compare districts on one scorecard.
- 2Billing expanded paperless and autopay enrollment while adding clearer tracking for delinquent and collections balances.
- 3Field operations split service orders into five work families to surface backlog drivers more clearly.
- 4Asset teams began scoring condition and criticality explicitly, putting outage-prone equipment in one planning view.
These are the operating questions this kit is optimized to answer first.
Billed kWh, billed revenue, balance due, and arrears mix by class and territory
Meter-read actual versus estimated mix, exceptions, and sampled daily usage
Outage count, affected customers, restoration minutes, and cause mix
Service-order backlog, timeliness, reconnect workload, and crew utilization
Asset condition, risk score, maintenance cost, and outage association
Embedded Analytical Stories
Meter to cash
Follow usage into monthly bills, then settle each bill against its payment so cash collected, open balance and billed amount tie out.
Storm to restoration
Compare outage severity, cause, and restoration duration by service territory, municipality, and asset hierarchy.
Premise to field work
Track how meter issues, move/connect requests, reconnects, and vegetation work create service-order workload by district and crew.
Condition to failure risk
Connect asset condition bands and maintenance activity back to outage-prone equipment and customer interruption burden.
Sampled reads to billing trust
Show read quality, estimated-bill exposure, and customer-class seasonality from sampled reads.