Blog · Board and management reporting
A facility dashboard compares commercial site occupancy, maintenance backlog and operating costs. This worked example reconciles three offices from space, work-order and expense exports, then changes one occupancy input.
A facility dashboard puts occupied space, maintenance backlog and operating costs into one commercial site comparison. It helps managers decide where to review space allocation, schedule work or investigate expense differences. Every ratio needs its underlying area, work-order count or cost beside it.
The example here concerns commercial offices operated by a US business. The review has three owners: the workplace manager owns the space register, maintenance owns work-order status, and finance owns the expense boundary.
Occupancy means usable area assigned to active business use at the reporting cutoff. It does not count employee attendance, lease commitments or meeting-room bookings. Those can be useful separate measures, but switching among them makes site comparisons unstable.
Maintenance backlog means open work orders at the cutoff. Count requests, not tasks or invoices, and preserve the original request ID when work changes hands. A closed order should have a completion record. The companion guide to asset maintenance KPIs covers the broader equipment-level review; this dashboard stays at the site level.
For costs, define the included accounts before calculating a ratio. Compare September maintenance, utilities and other site services below. Rent, depreciation, taxes and capital projects are excluded from this example. These are selected operating costs, not the entire economic cost of owning or leasing the buildings.
Red Oak Business Services, a fictional Texas company, reviews September 2026 across its Austin, Dallas and San Antonio offices. The space and backlog snapshots are as of September 30; expense and work-order movements cover September.
| Export | Required columns | Validation |
|---|---|---|
| Space register | Site ID, usable area, occupied area, effective date | Occupied area cannot exceed usable area under this definition |
| Work-order history | Site ID, request ID, opened date, closed date, due date, status | One request contributes once to the opening or new population |
| Site expense detail | Site ID, posting period, account, amount, document ID | Each posting belongs to one included cost category |
In this example, orders can only be opened or closed during the month. There are no canceled, transferred or reopened orders. Real exports with those movements need additional reconciliation columns; silently dropping them breaks the opening-to-ending bridge.
Keep overdue work inside the open backlog. It is a subset, not an additional population to add to the total. Missing due dates should remain a visible exception rather than being treated as evidence that a request is on time.
First assemble the space and maintenance inputs. Work-order counts are whole requests, and the space units are square feet throughout.
| Site | Usable area (sq ft) | Occupied area (sq ft) | Opening backlog | New orders | Closed orders | Overdue open orders |
|---|---|---|---|---|---|---|
| Austin | 30,000 | 21,000 | 20 | 30 | 35 | 6 |
| Dallas | 20,000 | 16,000 | 10 | 25 | 20 | 9 |
| San Antonio | 10,000 | 5,000 | 8 | 12 | 10 | 4 |
| Total | 60,000 | 42,000 | 38 | 67 | 65 | 19 |
The expense export supplies the following monthly totals. Other site services include the company's selected cleaning and security accounts, using the same classification at every site.
| Site | Maintenance (USD) | Utilities (USD) | Other site services (USD) | Total included cost (USD) |
|---|---|---|---|---|
| Austin | 9,000 | 6,000 | 5,000 | 20,000 |
| Dallas | 12,000 | 4,500 | 3,500 | 20,000 |
| San Antonio | 6,000 | 2,500 | 2,500 | 11,000 |
| Total | 27,000 | 13,000 | 11,000 | 51,000 |
Area occupancy = Occupied square feet / Usable square feet
Ending backlog = Opening backlog + New orders - Closed orders
Monthly cost per usable square foot = Included monthly cost / Usable square feet
Monthly cost per occupied square foot = Included monthly cost / Occupied square feet
| Site | Area occupancy | Ending backlog | Overdue within backlog | Cost per usable sq ft (USD/month) | Cost per occupied sq ft (USD/month) |
|---|---|---|---|---|---|
| Austin | 70.00% | 15 | 6 | 0.67 | 0.95 |
| Dallas | 80.00% | 15 | 9 | 1.00 | 1.25 |
| San Antonio | 50.00% | 10 | 4 | 1.10 | 2.20 |
| Total | 70.00% | 40 | 19 | 0.85 | 1.21 |
Ratios are rounded to two decimals after calculation. Dallas occupancy is 16,000 / 20,000 = 80.00%. Its ending backlog is 10 + 25 - 20 = 15. Its monthly cost per occupied square foot is 20,000 / 16,000 = $1.25.
The company backlog must reconcile as 38 + 67 - 65 = 40. It must also equal the site sum, 15 + 15 + 10 = 40. Overdue orders must appear among those open IDs, and the overdue count at each site must not exceed its ending backlog.
Costs reconcile as 27,000 + 13,000 + 11,000 = $51,000, and independently as 20,000 + 20,000 + 11,000 = $51,000. Tie that result to the selected site expense accounts. The operating expense analysis explains how to investigate account and period differences without losing the ledger tie.
Company occupancy is 42,000 / 60,000 = 70.00%. Company cost per usable square foot is 51,000 / 60,000 = $0.85. Divide total cost by total area; averaging the displayed site ratios would give small sites the wrong weight.
San Antonio warrants a space-use review because its occupancy is lower and its cost per occupied square foot is higher than the other sites in this example. Dallas warrants a maintenance scheduling review because it has more overdue open orders than either peer. Neither finding establishes waste or inadequate service: inspect building use, order priority and required coverage first.
Building types also matter when comparing utilities. The EIA commercial buildings survey reports building characteristics alongside energy consumption and expenditures, and explains that building types have different energy-use patterns. For a separate energy-efficiency measure, EPA's energy use intensity definition divides annual energy consumption by gross floor area. That is a different numerator, area basis and period from this monthly cost comparison.
Suppose the space register changes Dallas occupied area from 16,000 to 18,000 square feet after an internal team move. Hold usable area, every cost and every work-order count constant.
| Measure | Original | Changed-input result |
|---|---|---|
| Dallas occupied area (sq ft) | 16,000 | 18,000 |
| Dallas occupancy | 80.00% | 18,000 / 20,000 = 90.00% |
| Dallas cost per occupied sq ft (USD/month) | 1.25 | 20,000 / 18,000 = 1.11 |
| Company occupied area (sq ft) | 42,000 | 44,000 |
| Company occupancy | 70.00% | 44,000 / 60,000 = 73.33% |
| Company cost per occupied sq ft (USD/month) | 1.21 | 51,000 / 44,000 = 1.16 |
| Company included cost (USD) | 51,000 | 51,000 |
The lower cost per occupied square foot comes entirely from the denominator. There is no dollar saving in this variation. A later claim about avoided space cost would need an actual changed expense or documented commitment.
Once like-for-like costs are confirmed, standardization opportunities can guide a purchasing review across sites. Keep that action tied to equivalent requirements rather than choosing the lowest invoice in isolation.
Bring your site register, work-order export and expense detail. Covirage maps the columns, and its tools compute and check the site figures; the external AI model explains the results with every figure traced to its rows. Create a free Covirage account, which takes about a minute, then set up your business and bring a sample of your own data.
See self-service analytics in Covirage for the business-file approach.
Start with usable and occupied area, opening and ending maintenance backlog, overdue work and operating costs by site. Keep the cost boundary and occupancy definition visible. Add detail only when a manager can use it to change scheduling, space allocation or purchasing.
No. Occupancy can mean assigned or occupied floor area, while attendance counts people or visits during a period. State which meaning you use. A site can have assigned space and low daily attendance, so the two measures answer different management questions.
Use the same cost categories and period, then show both total dollars and cost per consistently defined square foot. Compare similar building uses and service requirements. A low cost ratio can reflect a larger denominator or deferred work rather than better operating performance.