Calgary Municipal Operations: Efficiency Analysis from Open Data
Calgary Municipal Operations: Efficiency Analysis from Open Data
Supporting Document for Council Motion — External Expert Review
Prepared: April 2026
Data source: data.calgary.ca (Socrata API), City of Calgary 2026 Budget
Context: Councillor Dan McLean's motion for external expert review of City operations (passed 13-12, April 2, 2026)
Methodology: Unit cost computation from open data + peer city benchmarking
This document presents numbers side by side. It does not recommend specific cuts. Above-median cost may reflect higher service quality, different scope, or geographic factors. The value is in the comparison existing, not in the conclusion it drives. An external audit answers the questions these numbers raise.
1. Budget Overview: $4.6 Billion Operating, $3.7 Billion Capital
| Category | 2026 Budget |
|---|---|
| Operating Budget | $4.6 billion |
| Capital Budget | $3.7 billion |
| Multi-Year Capital Plan | $17.0 billion |
| Water Infrastructure (committed) | $1.1 billion |
Revenue: 50% Property Tax Dependent
| Source | Amount | Share |
|---|---|---|
| Property Tax | $2.3B | 50% |
| User Fees & Charges | $1.2B | 28% |
| Government Transfers | $0.8B | 17% |
| Other (franchise fees, investment, fines) | $0.3B | 5% |
Top 10 Spending Lines
| Department/Service | Budget ($B) | % of Total |
|---|---|---|
| Calgary Police Service | $0.700 | 15.2% |
| Calgary Transit | $0.650 | 14.1% |
| Roads & Transportation | $0.500 | 10.9% |
| Water Services | $0.450 | 9.8% |
| Corporate Administration | $0.400 | 8.7% |
| Parks & Recreation | $0.400 | 8.7% |
| Calgary Fire | $0.380 | 8.3% |
| Community Services | $0.300 | 6.5% |
| Debt Servicing | $0.300 | 6.5% |
| Other Operating | $0.285 | 6.2% |
Observation: Police + Transit + Roads = 40.2% of operating budget. These three lines are where marginal efficiency gains have the largest absolute dollar impact.
2. Peer Benchmark Analysis: Where Calgary Sits
Unit costs computed from Calgary open data, compared against published benchmarks from CUTA, FCM, NFPA, and Alberta Environment.
Transit: $5.26 per boarding — 27.7% above peer median
| City | Cost/Boarding |
|---|---|
| Calgary | $5.26 |
| Ottawa | $4.89 |
| Edmonton | $4.12 |
| Vancouver | $3.67 |
| Toronto | $2.85 |
| Peer Median | $4.12 |
What this means: Calgary spends $1.14 more per boarding than the peer median. With ~108M annual boardings, the gap represents approximately $123M/year in above-median transit cost. This does not mean $123M is "waste" — it may reflect lower ridership density, route structure, fleet age, or higher service quality. But it is $123M that an external review could examine for structural explanation.
Anomaly: Calgary Transit received $76M in new 2026 budget investment. The per-boarding cost was already 27.7% above median before this investment. If ridership does not grow proportionally, the gap widens.
Building Permits: Methodology Under Review — Claim Retracted
| City | Cost/Permit |
|---|---|
| Calgary | Under review |
| Vancouver | $3,200 |
| Toronto | $2,800 |
| Edmonton | $1,850 |
| Peer Median | $2,800 |
Correction (April 3, 2026): The original $3,570/permit figure was computed from estimated departmental budget ($95M) divided by estimated permit volume (28,000). Both inputs were pipeline fallback estimates, not actuals. Calgary processed 18,168 building permits in 2024 (source: data.calgary.ca), and the Planning & Development operating budget net of fee recoveries has not been confirmed. The fee calculator at calgary.ca shows a PMV-based formula (value x $10.14/$1,000), not a flat per-permit cost. This claim has been retracted pending validation against the actual Development Approvals service plan operating budget. The peer comparison cannot be completed without this number.
Data gap: An external review should obtain the actual Development Approvals operating budget (net of fee recoveries) and divide by verified permit count (18,168 in 2024) to produce a defensible per-permit administrative cost. This is the kind of unit cost calculation that should be standard municipal disclosure but is not currently published.
Water Services: $2,111 per megalitre — 64.9% above peer median
| City | Cost/ML |
|---|---|
| Calgary | $2,111 |
| Edmonton | $1,420 |
| Lethbridge | $1,280 |
| Red Deer | $1,190 |
| Peer Median | $1,280 |
What this means: Calgary's water service cost is the highest among Alberta peer cities by a significant margin. At ~180,000 ML/year, the gap represents approximately $150M/year above the Alberta median. The Bearspaw feeder main emergency and the $1.1B water infrastructure commitment suggest some of this premium reflects aging infrastructure and reactive capital investment.
Anomaly: The 64.9% premium is the largest single deviation in the benchmark set. An external review should specifically examine whether this reflects treatment complexity (Bow/Elbow watershed), infrastructure age, operational cost structure, or a combination. The $1.1B committed water investment will increase per-ML cost further unless consumption grows or operational efficiencies offset the capital amortization.
Fire Services: $236 per capita — 20.8% below peer median
| City | Cost/Capita |
|---|---|
| Edmonton | $312 |
| Ottawa | $298 |
| Winnipeg | $245 |
| Calgary | $236 |
| Peer Median | $298 |
What this means: Calgary Fire operates at lower per-capita cost than peer cities. This is a positive finding — it suggests operational efficiency relative to peers. An external review should verify that response times and outcomes are maintained at this cost level, but the headline number is favourable.
3. Anomalies and Data Gaps
Anomaly 1: The $50M Reserve Draw
Council reduced the proposed 2026 property tax increase from 3.6% to 1.6% by drawing $50M from investment income. This is a one-time, non-recurring lever. The underlying spending growth that required 3.6% has been approved. The $50M draw defers visibility of this cost to future ratepayers. An external review should model the fiscal trajectory with and without this one-time lever at 5, 10, and 25 year horizons.
Anomaly 2: Police Sworn-to-Civilian Ratio
Calgary Police Service budget: $700M (15.2% of operating). Sworn officer costs: $500M. Civilian staff: $150M. The sworn-to-civilian ratio of approximately 3.3:1 is above the Canadian large-service average of 2.5-3.0:1. Every 0.1 shift in ratio toward civilian deployment for non-enforcement functions represents approximately $15-20M/year in potential savings, as civilian roles cost approximately 40-50% less than sworn positions for equivalent administrative functions.
The 2026 budget allocates $94M to public safety. An external review should examine what proportion of this new investment funds sworn positions for duties that could be performed by civilian staff.
Anomaly 3: Transit Fare Recovery
Transit fares: $180M revenue. Transit operating cost: $650M. Fare recovery ratio: approximately 28%. The Canadian large-city average is 30-40%. The 2026 budget adds $76M to transit. If fare recovery does not improve proportionally, the property tax subsidy per boarding increases — widening the already above-median cost-per-boarding gap.
Anomaly 4: Corporate Administration at $400M
Corporate Administration represents 8.7% of the operating budget at $400M — larger than the Fire Department ($380M), Community Services ($300M), or Planning & Development ($150M). An external review should benchmark corporate overhead as a percentage of operating budget against peer municipalities. This line is not disaggregated in the open data in a way that permits unit cost analysis.
Anomaly 5: Deferred Maintenance — Unknown Liability
The City of Calgary does not publish a consolidated deferred maintenance liability figure. The RIPPLE graph holds this variable at baseline $0 — not because there is no liability, but because the data has not been published. The Bearspaw feeder main emergency demonstrates the liability is non-zero. The $17B multi-year capital plan contains an unknown proportion of deferred maintenance response. An external review should produce this number.
Data Gaps: What the City Doesn't Publish
| Data Gap | Why It Matters |
|---|---|
| Deferred maintenance liability (consolidated $) | Cannot assess infrastructure risk without it |
| Transit operating cost by route/mode | Cannot identify inefficient routes |
| Road condition index (FCM methodology) | Cannot benchmark infrastructure quality |
| Permit processing time by type | Cannot separate cost from speed issues |
| Commercial/residential tax burden trend | Cannot assess assessment base erosion |
These are not exotic data requests. They are standard municipal benchmarking metrics that comparable Canadian cities publish. The external review should establish a disclosure baseline that matches peer practice.
4. Summary: What the Numbers Show
| Domain | Calgary | Peer Median | Gap | Annual $ Impact |
|---|---|---|---|---|
| Transit (cost/boarding) | $5.26 | $4.12 | +27.7% | ~$123M |
| Permits (cost/permit) | Retracted | $2,800 | TBD | TBD |
| Water (cost/ML) | $2,111 | $1,280 | +64.9% | ~$150M |
| Fire (cost/capita) | $236 | $298 | -20.8% | Efficient |
Total above-median cost across two validated domains (transit + water): approximately $273M/year. Permit cost claim retracted pending methodology validation.
This does not mean $292M can be saved. It means $292M in above-median spending exists across three domains relative to comparable Canadian cities. Some of it may be justified. Some of it may not be. The only way to know is to look — which is what Councillor McLean's motion requests.
The 12 councillors who voted against this motion voted against looking at $273M+ in documented above-median spending across transit and water alone. That is their right. It is also now a documented fact.
Data: data.calgary.ca (Socrata API, app token: registered), City of Calgary 2026 Budget, CUTA, FCM, NFPA, Alberta Environment
Analysis: CanuckDUCK RIPPLE graph + Calgary Open Data ingest pipeline
Published to CanuckDUCK Pond — Calgary Municipal Governance
April 2026