How to Conduct a Natural Gas Spend Analysis Across Multiple Business Locations

If your business operates across multiple locations — whether you're a franchise operator, a regional healthcare system, a property management company, or a multi-site manufacturer — your natural gas costs are almost certainly higher than they need to be.

That's not an assumption. It's a statistically reliable observation. Multi-location businesses systematically overpay for natural gas because they manage it with approaches designed for single-location businesses: one-off supplier conversations, reactive renewals, limited data visibility, and no portfolio-level strategy.

The solution is a natural gas spend analysis — a systematic process of collecting, organizing, and analyzing energy data across your entire portfolio to identify exactly where you're overpaying and what you can do about it. Done correctly, a spend analysis turns a scattered collection of monthly utility bills into a strategic roadmap for cost reduction.

This guide walks you through exactly how to conduct a multi-location natural gas spend analysis: how to collect and organize data, how to identify hidden cost drivers, and how to convert your findings into an actionable cost reduction strategy that delivers measurable results.

Why Multi-Location Businesses Are Overpaying for Natural Gas (And How a Spend Analysis Fixes It)

The Visibility Problem at Scale

Single-location businesses at least know what they're paying for natural gas — there's one bill, from one utility, for one location. The spend is visible, even if it's not optimized.

Multi-location businesses often lack even basic visibility. Utility bills go to different addresses, different property managers, different departments. Some locations are on competitive supply contracts with varying expiration dates; others are on utility default service. Some are in Nicor Gas territory; others in Peoples Gas or Ameren. The aggregate natural gas spend for the portfolio exists somewhere in the accounting system — but the detailed, location-level picture needed for strategic management typically doesn't.

This visibility gap creates several types of overpayment:

Unknown auto-renewals: Contracts that expire and auto-renew at unfavorable rates — common across multi-location portfolios where no one is tracking expiration dates systematically.

Utility default service remnants: Locations that were always on utility default service and have never been considered for competitive supply. Sometimes these represent significant spend going unoptimized.

Incorrect rate classification: Locations classified under wrong tariff rate schedules, potentially paying more than they should under the correct classification.

Volume fragmentation: Locations being procured individually, missing the volume leverage that portfolio aggregation would provide.

Billing errors: In large portfolios, billing errors affecting individual locations often go undetected because no one is checking. Industry estimates suggest 10–15% of commercial energy bills contain errors.

What a Spend Analysis Reveals

A well-executed multi-location natural gas spend analysis provides answers to:

What is our total annual natural gas spend across all locations?
What is our cost per therm at each location — and why does it vary?
Which locations are on competitive supply vs. utility default service?
What are the contract terms (rates, expiration dates, auto-renewal provisions) at each location?
Which locations are paying above-market rates?
Where are the greatest absolute dollar savings opportunities?
What is our total annual volume, and does it qualify us for better pricing tiers?

These answers form the foundation of a strategic cost reduction plan.

Step-by-Step: How to Collect and Organize Natural Gas Usage Data Across All Your Business Locations

Step 1: Create a Complete Location Inventory

Start by documenting every location in your portfolio that uses natural gas. For each location, record:

Complete address (including city, state, ZIP)
Utility company serving the location (Nicor Gas, Peoples Gas, Ameren Illinois, or utility in other states)
Utility account number(s) — note that some locations have multiple meters and multiple accounts
Current supply status: Utility default service, or competitive supplier (if supplier, which one?)
Current supply rate: Available from your most recent bill (look for the "supply charge" or "commodity charge" per therm)
Contract expiration date: If with a competitive supplier, when does the current contract expire?
Annual consumption estimate: Order-of-magnitude estimate from recent bills

This location inventory becomes the master reference document for your spend analysis. Keep it current as contracts change, new locations open, and old ones close.

Step 2: Gather 24 Months of Bill Data for Every Location

For each location in your inventory, collect utility bills covering the most recent 24 months. You need both:

Usage data: Monthly therms or CCF consumed at each location — the key input for volume analysis

Cost data: Monthly spend, broken down into components where available:

Supply/commodity charge
Distribution/delivery charge
Taxes and fees
Any other line items

Where to get the data:

Online utility portals: Most Illinois utilities provide business account portals with downloadable usage and bill history. Nicor Gas, Peoples Gas, and Ameren all offer this.
Utility automated data services: Larger portfolios may qualify for automated electronic data transfer
Accounts payable records: If bills are scanned and stored, AP departments often have historical images accessible
Energy management software: If you're already using energy management software, historical data may already be captured

The data collection step is often the most time-consuming part of a spend analysis for large portfolios. For 50+ location portfolios, consider whether third-party data aggregation services can accelerate this process.

Step 3: Build Your Spend Analysis Database

With usage and cost data collected, organize it into a structured analysis database. The minimum required structure:

Location	Month	Therms Used	Total Bill	Supply Charge	Distribution	Supply Rate ($/therm)	Supplier
Location A	Jan 2025	28,500	$18,200	$11,400	$5,800	$0.40	Competitive Co.
Location B	Jan 2025	14,200	$10,600	$6,800	$3,100	$0.48	Utility Default

This tabular structure enables the cross-location, cross-time comparisons that reveal where your money is going and where the optimization opportunities are.

How to Identify Hidden Cost Drivers and Savings Opportunities in Your Commercial Natural Gas Bills

Analysis 1: Supply Rate Comparison Across Locations

Sort your database by supply rate (cost per therm for the supply/commodity portion of the bill) across all locations. Immediately, you'll see the range of rates your portfolio is actually paying.

If Location A is paying $0.38/therm for supply and Location B is paying $0.55/therm, and both are in the same utility territory, that $0.17/therm gap represents a clear savings opportunity. The question is: why does the gap exist, and can it be closed?

Common explanations for supply rate gaps:

Different contract vintages (a contract signed 3 years ago vs. one signed recently may have very different rates)
Utility default service (typically more expensive than competitive supply during most market periods)
Different contract structures (fixed vs. index)
Supplier margin differences

Analysis 2: Utility Default Service Identification

Flag every location that's on utility default service. These are typically the highest-priority candidates for switching to competitive supply, since they have no contract to navigate and are almost certainly paying above-market rates for the supply portion of their bill.

For each flagged location, calculate the potential annual savings from switching to competitive supply using current market rates. This creates a prioritized list of switching opportunities ranked by absolute dollar savings potential.

Analysis 3: Contract Expiration Timeline

Map all contract expiration dates on a timeline. This reveals:

Locations expiring within 90 days: Immediate action required — begin renewal bidding now
Locations in auto-renewal risk windows: Locations within 30–60 days of auto-renewal triggers need immediate attention
Clusters of simultaneous expirations: If 10 locations expire in the same month, you're creating concentrated market timing risk that should be addressed through staggered renewal

Analysis 4: Volume by Utility Territory for Aggregation Analysis

Group your locations by utility territory and calculate aggregate annual volume for each group. This analysis reveals:

Whether you qualify for better pricing tiers through volume aggregation
Which utility territories have sufficient volume to warrant dedicated competitive bid processes
Whether portfolio contracts that cover multiple locations with a single supplier are viable

For a multi-location Illinois portfolio, aggregating Nicor Gas territory locations together can meaningfully improve pricing versus individual location procurement. See our guide on natural gas aggregation for multi-site businesses for detailed methodology.

Analysis 5: Usage Intensity Benchmarking

Calculate usage intensity (therms per square foot per year) for each location and compare against industry benchmarks. Locations with usage intensity significantly above the benchmark may have:

Inefficient heating equipment
Building envelope deficiencies
Equipment malfunctions (continuous pilot lights, stuck open valves, improperly calibrated controls)
Unusual operational patterns that warrant investigation

Our guide on commercial gas usage benchmarks provides sector-level intensity benchmarks for common commercial building types.

Analysis 6: Billing Error Detection

Compare the charges on each bill to your contract terms. Common billing errors that affect multi-location portfolios:

Incorrect rate application: Being billed at a rate higher than your contracted rate
Pass-through charge overstatement: Variable pass-through charges billed above market levels
Meter misreading: Consumption errors that inflate usage-based charges
Tariff misclassification: Being billed under the wrong utility tariff schedule

For locations where total bill per therm is inconsistent with contract terms, flag for detailed investigation.

Turn Your Natural Gas Spend Analysis Into an Actionable Cost Reduction Strategy for Your Business

Prioritization Framework: Focus Where the Money Is

Not all findings from your spend analysis deserve equal attention. Prioritize action items using this framework:

Tier 1 — Immediate action (highest dollar impact):

Locations on utility default service with annual spend above $15,000
Locations within 90 days of contract expiration without renewal process underway
Any location with identified billing errors (immediate correction)

Tier 2 — Near-term action (significant savings opportunity):

Locations with contract expirations in 3–12 months — begin competitive bidding process
Utility territory volume aggregation analysis — quantify potential savings and develop portfolio bid strategy

Tier 3 — Medium-term optimization:

Usage efficiency improvements at high-intensity locations
Contract structure optimization (fixed vs. index, contract length) for upcoming renewals
Sub-metering investments at multi-use facilities where granular allocation would improve management

Building Your Cost Reduction Roadmap

Convert your prioritized findings into a time-bound action plan with assigned ownership:

Action	Location(s)	Responsible	Deadline	Estimated Savings
Switch to competitive supply	Locations A, B, C (default service)	Energy Manager	30 days	$18,000/yr
Renew Location D contract	Location D	Energy Manager	45 days (exp. in 60)	Lock in current market
Correct billing error	Location E	AP Team	10 days	$2,400 back-billed
Aggregate renewal bid	Locations F-L	Energy Manager	90 days	Est. $12,000/yr

This roadmap transforms the analysis from an interesting intellectual exercise into an operational plan with clear accountability and measurable outcomes.

Working with Natural Gas Advisors on Your Spend Analysis

Many multi-location businesses find that partnering with Natural Gas Advisors for their spend analysis — rather than doing it entirely in-house — accelerates the process and generates better results. We bring:

Established data collection processes that work across all Illinois utilities
Market pricing benchmarks that contextualize what you should be paying
Supplier relationship access that converts your findings into competitive bids immediately
Ongoing monitoring after the initial analysis to ensure savings persist

Our free service provides spend analysis support alongside procurement strategy and competitive bid management.

Frequently Asked Questions: Natural Gas Spend Analysis for Multi-Location Businesses

How long does a multi-location natural gas spend analysis typically take? For a 5–20 location portfolio, a well-organized spend analysis can be completed in 2–4 weeks once data collection is complete. Larger portfolios (50+ locations) may take 4–8 weeks. Partnering with an advisor who has data collection infrastructure can significantly accelerate the timeline.

What if some locations are in different states with different utilities? Multi-state analysis requires understanding each state's market structure separately. Not all states are deregulated, so the savings opportunities vary. Your analysis should map each location to its state's regulatory environment. Natural Gas Advisors is experienced in multi-state portfolio analysis.

Can we do this analysis ourselves or do we need an outside advisor? You can absolutely do it yourself if you have data management capabilities and time. The value an advisor adds is: (1) market pricing benchmarks that contextualize your findings, (2) supplier access that converts findings into competitive bids faster, and (3) regulatory knowledge across multiple states.

What's the minimum portfolio size that makes a spend analysis worthwhile? A formal spend analysis is generally worthwhile for portfolios with total annual natural gas spend above $100,000 across 3+ locations. Below that threshold, the analysis effort may exceed the savings potential. For very small multi-site portfolios, a simpler procurement review with competitive bidding provides most of the value more efficiently.

How often should we repeat the spend analysis process? A formal full-portfolio analysis should be conducted annually. Between formal analyses, ongoing contract expiration monitoring and regular procurement reviews at each renewal cycle provide continuous optimization.

What should we do with the data after the analysis? Don't let it sit in a spreadsheet. Assign ownership for each action item, set deadlines, and track completion. The analysis has value only if it drives action. Build a procurement calendar that schedules regular check-ins on contract status and upcoming renewals.

Conclusion: Visibility Creates Savings — Start Your Analysis Today

Multi-location natural gas management doesn't have to be a black box. With the right data collection process, analytical framework, and action prioritization, even large and complex portfolios can achieve meaningful cost reduction — typically 10–20% of total natural gas spend — through a systematic spend analysis.

The businesses that generate sustainable energy cost advantages aren't those with the most sophisticated trading strategies. They're the ones with the most complete visibility into where they're spending, what they're getting for it, and what they could be getting instead.

A natural gas spend analysis is how you build that visibility — and how you convert it into dollars saved.

Natural Gas Advisors provides multi-location spend analysis support to Illinois commercial businesses at no cost. Our analysis tools, market benchmarks, and supplier relationships turn data collection into actionable savings strategies.

Start your spend analysis today. Contact Natural Gas Advisors at 833-264-7776 or request a free multi-location portfolio review.

Word count: 2,553