UCalgary

Residence Facilities — Performance & Financial Overview

University of Calgary · Residence & Conference Services · Zone 3

Data refreshed
GL · OL excluded only from FCA & Capital (demolition 2027)
Building
Year

About this Dashboard

Live data from Archibus, satisfaction survey & FCA reports. All visuals respond to the filter bar above.

How to Interact

Filter the whole dashboard using the building chips and year selectors above.

Click a bar in any chart to drill into that building.

Hover for exact values, counts, and percentages.

Reset returns to all residences, full date range.

Time context: Data spans 2020–present. Demand is seasonal with predictable peaks before academic terms. Cycle time should be read relative to demand volume.

Financial notes: Forecasts are projections, not final actuals. Variance changes as invoices arrive. Insurance recoveries reduce net exposure once settled. Negative variance = over budget.

Glossary

WR — Work Request (resident-initiated or system-generated maintenance from Archibus)

PM — Preventive Maintenance (scheduled, non-reactive work)

Problem Type — Categorized issue (Plumbing, Electrical, HVAC…)

Work Team — Trade or group assigned

Cycle Time — Days from WR created to closed

Zone 3 — Residence Facilities

FCI — Facility Condition Index (>0.15 = Poor)

D / E rating — Auditor-assigned: D=Marginal, E=Poor

Building Portfolio

Residence Halls (Zone 3)
CodeNameBuiltGross Area (m²)FCICategoryNotes
Total Work Requests
all buildings, all time
Total Cost
labor + parts + other
Avg Cycle Time
days, request → close
Customer Satisfaction
satisfied / very satisfied

Activity & Spend

Click bars in any chart to filter the whole page to that building.

Work Requests by Building click to drill
Annual Cost Trend UCalgary stacked by system

Where the Work Goes

Top Problem Types
Top Work Teams
Filtered WR Count
Filtered Cost
Avg per WR
Top 100 high-cost WRs
share of total spend

Cost Trend by Building (2020 → 2025)

% change in annual cost. CR is the standout — 99% increase despite 'Good' FCI condition.

Annual Cost Trend % red = up · green = down

Team × Problem Type Drilldown

Which teams handle which problem categories — the structural view of how work is distributed.

Work Request Type & Distribution stacked by problem

Cost Heatmap — Building × Year

Building × Year Cost ($) — Color-scaled

Top High-Cost Work Requests

The 100 WRs with ≥$5K total cost — drives most of your line-item exposure.

Top 100 by Cost filtered
DateBldgTeamProblemCost
Total Responses
Satisfaction Rate
satisfied + very satisfied
Average Rating
out of 5
Lowest Building Avg

Trend & Distribution

Monthly Satisfaction % % rated 4★ or higher
Rating Mix

By Building & Recent Notes

Avg Rating by Building
Recent Customer Notes latest 20
Peak Month
Quietest Month
Avg Monthly Volume
Sep avg vs other months
academic year spike

Monthly Demand

Predictable peaks before each academic term. Plan staffing accordingly.

WR Volume by Year–Month

Seasonal Pattern

Average by Month of Year (all years)
Budget
Zone 3 · Total Expenses
Actuals
— % of budget
Net Surplus/(Deficit)
before forecasted exposure
True Budget Position
worst case — see notes

True Position Bridge

Current net + forecasted variance items + open insurance claims = projected end-of-year position.

Bridge: Current → True Position
Budget vs Forecast by Category

Where the Money Actually Goes

Real GL account spend from budget actuals — Zone 3 (Dept 62143). UCalgary FY runs April → March.

Fiscal Year
FY Total Spend
all GL accounts
YTD through latest month
Avg Monthly Burn
months with data
Peak Month
Monthly Burn Apr → Mar
Spend by Category
Top GL Accounts — Selected FY

Maintenance Spend by Category — REAL GL

From GL 66xxx maintenance accounts (selected FY). Elevators paid as contract = visible here, not in WR Total Cost.

Maintenance $$ by Category

Variance Forecast

Status = Forecasted. Final variance subject to remaining invoices.

Current Forecasted Variances to Budget
TitleDisciplineDateCost

Open Insurance Claims

Status = Open Claim
WR / Claim #BuildingTitleCauseCost
Replacement Value
7 in-scope residences
5-Year Need
FCA-flagged within 5 yrs
Poor Condition Bldgs
FCI > 0.15
D–E Findings
marginal / poor systems

Condition vs Age

Bubble size = replacement cost. Red dashed line = industry "Poor" threshold (FCI 0.15).

Building Age vs FCI

E-Poor Requirements

All E-rated (Poor) Findings
BldgSystemRequirementRatingTargetCost
Buildings in Scope
7
Total Recommended Range
$124–188M
Near-Term Priorities
3
2026–2040 window
Mid-Life Renewals
4
2045–2065 window

Near-Term: 5–15 Year Window (2026–2040)

Long-Term: 20–40 Year Window (2045–2065)