Utility data for multi-site retail portfolios
Hundreds of stores across many utilities and rate structures. How to standardize, benchmark, and allocate energy cost, spot outlier stores, and support ESG for a chain.
A retail chain with a few hundred stores is really a few hundred separate utility relationships, spread across many providers, dozens of rate structures, and every data format a utility can produce. The head office question is simple: which stores are wasting energy, and how much is each one really costing us? Answering it means pulling order out of data that arrives in as many shapes as there are utilities on the map.
Why retail portfolios are hard
- Many utilities: stores in different service territories mean different bill formats, billing cycles, and portals.
- Many rate structures: time-of-use, tiered, demand-based, and seasonal rates vary store to store, so cost per kWh is never one number.
- Mixed formats: PDFs, spreadsheets, portal exports, and interval files all describing the same commodity.
- Site churn: remodels, meter swaps, and openings and closures break naive year-over-year comparisons.
- Ownership mix: corporate, franchise, and leased locations may not all report the same way.
Standardize before you benchmark
Comparing raw bills across stores is meaningless until units and rates are normalized and multiple meters per site are rolled up correctly. Once the data is standardized, benchmark on intensity, not raw spend. The national median site energy use intensity for a retail store is about 51.4 kBtu per square foot, while supermarkets sit far higher near 196 kBtu per square foot because of refrigeration load. Grouping stores by format before you benchmark keeps the comparison fair.
Spotting outlier stores
With normalized intensity in hand you can rank stores and pull the tail. Because refrigeration, lighting, and cooling are among the largest electricity end uses in commercial buildings, an outlier grocery usually points at refrigeration, and an outlier big-box store often points at lighting schedules or HVAC running outside hours. Interval data sharpens this further by showing whether the excess is a raised overnight baseload or a demand spike during trading hours.
Allocating cost across the chain
Finance needs cost broken down by store, region, and cost driver, not one portfolio total. Clean, per-site data is what makes utility cost allocation and internal chargebacks defensible, and it lets you separate energy from demand and delivery so a store manager sees the levers they actually control. When bills, meters, and sites all map cleanly, allocation becomes a query rather than a month-end spreadsheet exercise.
Supporting ESG for the whole banner
Retail ESG reporting rolls hundreds of stores into one corporate footprint. Scope 2 emissions come straight from purchased-electricity data on the bills, so a standardized portfolio feeds disclosure without re-keying. The same clean per-store data supports benchmarking: an ENERGY STAR score needs 12 full months of energy data per store, with 75 or above marking top-quartile performance you can point to in a sustainability report.
| Task | What you need from the data |
|---|---|
| Benchmark stores | Normalized EUI, grouped by store format |
| Spot outliers | Ranked intensity plus interval load shape |
| Allocate cost | Per-site bills split into energy, demand, delivery |
| Report ESG | 12 months per store, mapped to Scope 2 factors |
The data foundation
All of this rests on the same groundwork facility managers rely on at a single site, scaled to a fleet: consistent accounts, meters, and sites, standardized units and rates, and a clean history that survives remodels. Build that foundation once, in a warehouse the whole banner shares, and benchmarking, allocation, and ESG stop being separate projects and become views on one clean dataset.
Frequently asked questions
How do I compare stores fairly when they are different sizes?
Benchmark on energy use intensity, energy per square foot, not raw spend, and group stores by format. The national median site EUI for a retail store is about 51.4 kBtu per square foot, so store-format-aware comparison keeps a grocery from being judged against a clothing store.
What usually makes a store an energy outlier?
It depends on format. Refrigeration, lighting, and cooling are among the largest electricity end uses in commercial buildings, so a high-intensity grocery often points at refrigeration, while a big-box outlier tends to be lighting or HVAC running outside operating hours.
How do I allocate utility cost across hundreds of stores?
Map every bill, meter, and site cleanly, then split each bill into energy, demand, and delivery components. That lets you allocate by store, region, and cost driver instead of dividing one portfolio total, which makes chargebacks defensible.
How does clean portfolio data help ESG reporting?
Scope 2 emissions derive directly from purchased-electricity data on the bills, so a standardized portfolio feeds disclosure without re-keying. The same data supports ENERGY STAR benchmarking, which needs 12 months of energy per store.
A facility manager's guide to utility data
Energy is the largest controllable operating cost in most buildings. This guide shows facility managers how to turn scattered utility data into decisions that cut it.
Normalizing Multi-Meter Energy Data: One Common Basis Across Sites and Commodities
Mixed units, ragged billing periods, and multi-meter buildings break comparisons. Here is how to build one common basis for energy data.