What is a Facility Management Master Dashboard?

 Facility Management (FM) is a strategic discipline that combines maintenance, engineering, energy management, financial control, safety, service quality, and customer satisfaction. For a complex facility such as a hospital, the dashboard must also measure clinical-service continuity, critical utility reliability, and patient safety.

The objective is to move from simply reporting completed work orders to measuring whether the facility is safe, reliable, efficient, and delivering value.

1. What is a Facility Management Master Dashboard?

A Facility Management Master Dashboard is a centralized reporting system that consolidates operational data from the Computerized Maintenance Management System (CMMS), Building Management System (BMS), energy meters, finance records, safety inspections, and customer feedback.

12

It allows senior management, facility managers, maintenance managers, and engineering teams to answer questions such as:

• Are critical assets available when required?

• Are preventive maintenance activities completed on time?

• Are SLA commitments being achieved?

• Which equipment is repeatedly failing?

• Are electricity, water, and fuel consumption increasing?

• Are operating costs within budget?

• Are safety risks and customer complaints being resolved?

• Which assets require repair, replacement, or capital investment?

A dashboard should not merely display numbers. It should help managers identify deviations, investigate root causes, assign corrective actions, and verify results.

2. The eight main KPI categories

1. Operational performance

Measures service availability, response time, restoration time, SLA achievement, and reliability of building systems.

Examples: SLA compliance, MTTR, MTBF, asset availability.

2. Maintenance and asset reliability

Measures preventive maintenance completion, breakdown frequency, repeat failures, backlog, and maintenance quality.

Examples: PM compliance, planned maintenance percentage, repeat-failure rate.

3. Financial management

Monitors operating expenditure, capital expenditure, budget variance, maintenance costs, and financial benefits from improvement projects.

Examples: OPEX variance, maintenance cost per square metre, energy cost.

4. Work-order management

Tracks work requests from receipt through assignment, attendance, repair, testing, verification, and closure.

Examples: overdue work orders, response time, work-order backlog.

5. Customer experience

Evaluates service quality, communication, complaint resolution, satisfaction, and compliance with contractual commitments.

Examples: customer satisfaction, complaint recurrence, first-time fix rate.

6. Energy and sustainability

Measures electricity, fuel, water, energy intensity, carbon emissions, and efficiency improvement.

Examples: kWh/m², kWh per bed-day, water consumption, CO₂ emissions.

7. HSE and compliance

Tracks safety inspections, incidents, permit-to-work compliance, statutory testing, and corrective actions.

Examples: inspection compliance, overdue safety actions, statutory maintenance compliance.

8. Smart building and digital performance

Uses BMS, sensors, analytics, alarms, and predictive maintenance to identify abnormalities and improve operating decisions.

Examples: actionable alarms, sensor availability, fault-detection rate, predictive alerts.

3. Essential Facility Management KPIs: formulas, targets and examples

The following KPIs are suitable for a hospital, hotel, commercial building, or facilities-management contract. Targets are illustrative starting points; they should be approved according to the contract, asset criticality, applicable standards, and organizational policy.

A. Operational performance KPIs

KPI Formula Illustrative target SLA compliance Work orders meeting SLA ÷ eligible completed work orders × 100 ≥95% MTTR Total corrective repair time ÷ number of failures Trending downward MTBF Total operating time ÷ number of relevant failures Trending upward Asset availability Available time ÷ required service time × 100 Critical assets often ≥99%, where justified Response time Attendance time − request receipt time According to SLA Restoration time Service restoration time − failure notification time According to criticality and SLA

1. SLA compliance

The Service Level Agreement (SLA) defines the service commitment between the FM provider and the customer.

For example, a hospital may define different response requirements for a critical medical-gas alarm, a failed operating-room air-handling unit, a leaking washroom tap, and a routine painting request.

Formula:

\[ \text{SLA Compliance}= \frac{\text{Eligible work orders completed within SLA}} {\text{Total eligible completed work orders}}\times100 \]

Suppose 950 eligible work orders were completed within their specified SLA out of 1,000 completed work orders.

\[ \frac{950}{1000}\times100=95\% \]

The SLA compliance is 95%.

Managerial action: Examine the 50 non-compliant jobs by priority, trade, shift, location, material availability, contractor dependency, and delay reason. Do not simply instruct technicians to close jobs faster.

2. Mean Time to Repair (MTTR)

MTTR measures the average time taken to repair equipment after a failure. Organizations must define whether this means active repair time or elapsed time until restoration, including waiting periods.

\[ \text{MTTR}= \frac{\text{Total defined repair time}} {\text{Number of qualifying failures}} \]

Example: Four pump failures required 2, 3, 4, and 5 hours of repair time.

\[ MTTR=\frac{2+3+4+5}{4}=3.5\text{ hours} \]

A lower MTTR can indicate improved troubleshooting, technician competency, spare-parts availability, and repair procedures. However, a low MTTR is not automatically good if repairs are temporary or repeat failures increase.

3. Mean Time Between Failures (MTBF)

MTBF estimates the operating time between qualifying failures of a repairable asset.

\[ \text{MTBF}= \frac{\text{Total operating time}} {\text{Number of qualifying failures}} \]

If a pump operates for 720 hours and experiences three qualifying failures:

\[ MTBF=\frac{720}{3}=240\text{ hours} \]

The average operating time between failures is 240 hours.

Interpretation: An increasing MTBF, alongside stable safety and performance, may indicate that preventive maintenance, condition monitoring, and root-cause corrective actions are working.

MTBF is meaningful only when the asset population, failure definition, and operating-time calculation remain consistent.

4. Asset availability

Availability measures the proportion of required service time during which an asset is available to perform its intended function.

\[ \text{Availability}= \frac{\text{Available required service time}} {\text{Total required service time}}\times100 \]

If a critical pump is required for 720 hours and is unavailable for 7.2 hours:

\[ \text{Availability}= \frac{720-7.2}{720}\times100=99\% \]

For critical hospital equipment, evaluate availability together with redundancy, capacity, actual performance, and whether the standby equipment is ready to operate. A nominally available chiller that cannot meet its required cooling load should not be counted as fully functional.

B. Maintenance and asset reliability KPIs

KPI Formula or measurement Why it matters Preventive maintenance compliance PM tasks completed on time ÷ PM tasks due × 100 Prevents overdue maintenance Planned maintenance percentage Planned maintenance labor hours ÷ total maintenance labor hours × 100 Measures maintenance planning Reactive maintenance percentage Reactive maintenance labor hours ÷ total maintenance labor hours × 100 Shows dependence on breakdown response Repeat-failure rate Defined repeat failures ÷ relevant failures × 100 Identifies unresolved root causes Maintenance backlog Overdue work or estimated labor hours, grouped by priority and age Shows outstanding maintenance risk Critical asset PM compliance Critical PM tasks completed on time ÷ critical PM tasks due × 100 Protects essential services

Example: Preventive maintenance compliance

Suppose 500 PM tasks are due in a month and 475 are completed by their approved due dates.

\[ \text{PM Compliance}=\frac{475}{500}\times100=95\% \]

The compliance rate is 95%.

However, the dashboard must also report the 25 overdue tasks, their risk classifications, and the reason for the delay. A 95% aggregate score can hide a serious failure if the remaining 5% includes critical medical-gas equipment or emergency power systems.

What is the difference between PM compliance and planned maintenance?

• PM compliance measures whether scheduled preventive maintenance tasks were completed on time.

• Planned maintenance percentage measures how much maintenance work was planned before execution, rather than initiated reactively.

• Reactive maintenance percentage measures the proportion of maintenance effort consumed by unplanned failures.

These metrics answer different questions and should not be treated as interchangeable.

A useful maturity goal is to increase effective planned maintenance and reduce avoidable reactive maintenance without performing unnecessary maintenance on healthy assets.

C. Financial management KPIs

KPI Formula Management use OPEX budget variance Actual OPEX − budgeted OPEX Identifies overspending or underspending Budget variance % (Actual − budget) ÷ budget × 100 Compares deviations proportionally Maintenance cost per m² Maintenance cost ÷ maintained floor area Compares similar buildings Energy cost per m² Energy expenditure ÷ maintained floor area Tracks cost intensity CAPEX utilization Actual eligible CAPEX expenditure ÷ approved CAPEX budget × 100 Tracks investment delivery Cost avoidance Estimated cost without intervention − cost with intervention Quantifies supported savings Asset lifecycle cost Acquisition + installation + operating + maintenance + disposal costs Supports replacement decisions

Monthly maintenance budget = PKR 10 million.

Actual expenditure = PKR 11 million.

\[ \text{Variance}=11-10=1\text{ million PKR} \]

\[ \text{Variance \%}=\frac{11-10}{10}\times100=10\% \]

The department is 10% over budget.

The next step is to separate the variance into energy, spare parts, contractors, overtime, emergency repairs, and other costs.

Underspending also needs investigation: it might indicate efficiency, or it might mean preventive maintenance and essential replacements have been postponed.

OPEX versus CAPEX

• OPEX: Recurring operating costs such as maintenance labor, spare parts, electricity, fuel, and service contracts.

• CAPEX: Qualifying investments in equipment or infrastructure, such as chiller replacement, major plant upgrades, or building automation improvements.

Accounting policies determine whether a particular expenditure is classified as OPEX or CAPEX.

D. Work-order management KPIs

An effective CMMS dashboard should track the entire work-order lifecycle, not just the number of jobs closed.

KPI What to monitor Work orders received Demand for maintenance services Work orders completed Delivered maintenance output Open work orders Outstanding workload Overdue work orders Work exceeding its approved due date First-time fix rate Jobs resolved without a repeat visit for the same problem Work-order aging Outstanding work grouped by age and priority Work-order data quality Jobs with complete fault, action, labor, material and closure records

Example: Work-order backlog

If 120 work orders are open, report them by age and criticality rather than displaying only the total.

• Critical: 3

• High priority: 17

• Medium priority: 40

• Low priority: 60

These numbers are illustrative. The three critical work orders need immediate risk-based review even if the overall backlog is small.

A useful backlog report includes the assigned technician, responsible supervisor, required material, planned completion date, and reason for delay.

E. Customer satisfaction KPIs

Facilities management is a service function. Technical completion is important, but the customer must also receive a safe, timely, and satisfactory service.

KPI Measurement Customer satisfaction score Average score from a defined feedback survey Complaint resolution within SLA Eligible complaints resolved within SLA ÷ eligible resolved complaints × 100 First-time fix rate Jobs resolved successfully without repeat attendance ÷ qualifying jobs × 100 Repeat complaint rate Repeat complaints for the same issue ÷ defined complaint population × 100 Communication compliance Cases with required customer updates completed ÷ cases requiring updates × 100

For a hospital, customer feedback may come from clinical departments, nursing units, administration, patients, and other service users. These groups have different needs, so results should be segmented.

For example, an operating-room cooling complaint needs to be assessed not only by response time but also by restoration of required environmental conditions and confirmation from the relevant clinical team.

F. Energy and sustainability KPIs

Energy dashboards are particularly valuable in facilities with chillers, cooling towers, AHUs, boilers, generators, compressed-air systems, and large electrical loads.

KPI Formula or measurement Electricity intensity kWh ÷ floor area, with consistent area boundaries Chiller efficiency kW of chiller electrical input ÷ refrigeration capacity in kW Water intensity Water consumption ÷ selected activity measure Generator fuel intensity Fuel consumption ÷ kWh generated Energy cost Electricity, fuel and other relevant energy costs Carbon emissions Energy consumption × applicable emissions factor Energy-saving achievement Verified baseline energy − adjusted actual energy

Example: Chiller efficiency

Suppose a chiller provides 1,000 kW of cooling and consumes 200 kW of electrical power.

\[ COP=\frac{\text{Cooling output}}{\text{Electrical input}} =\frac{1000}{200}=5.0 \]

The coefficient of performance is 5.0.

If the electrical input rises to 250 kW at the same cooling output:

\[ COP=\frac{1000}{250}=4.0 \]

The chiller's efficiency has declined. Investigate condenser-water temperature, chilled-water conditions, heat-exchanger cleanliness, refrigerant-system performance, loading, and measurement accuracy before concluding that the chiller requires replacement.

Important: Compare COP at comparable operating conditions and distinguish chiller-only performance from total plant efficiency, which includes pumps and cooling towers.

4. Hospital Facility Management: critical utility KPIs

For a tertiary-care hospital such as Aga Khan University Hospital, a general FM dashboard is not sufficient. It should include a dedicated Critical Utilities and Clinical-Service Continuity dashboard.

10

The following KPIs are particularly relevant to hospital MEP, HVAC, medical gases, and operations and maintenance.

System Priority KPIs Recommended management focus Chillers and chilled-water pumps Availability, failures, COP, CHW supply/return temperatures Maintain required cooling and redundancy AHUs and FAHUs Availability, filter differential pressure, temperature, humidity, airflow where monitored Maintain specified clinical environmental conditions Electrical distribution Outages, voltage deviations, protection trips, restoration time Maintain safe and reliable power Emergency generators Start-test success, readiness, failures, fuel availability Ensure emergency power readiness Medical oxygen Pressure alarms, source availability, reserve duration, purity where monitored Maintain compliant supply and escalation procedures Medical air and vacuum Pressure, vacuum level, alarms, compressor availability Maintain required clinical utility conditions Boilers and hot water Availability, efficiency, water temperature, safety compliance Ensure safe and continuous service Fire and life safety System availability, impairment duration, overdue inspections Protect occupants and maintain compliance BMS and alarms Critical alarm acknowledgment, response time, communication failures Improve fault detection and response

For medical gas systems, alarm status alone is not enough. The dashboard should show source condition, active alarms, reserve arrangements, maintenance status, and verified escalation. Applicable requirements must be established from the relevant medical-gas standards and hospital policies.

For cooling systems serving operating rooms, intensive care units, radiology, laboratories, and other critical areas, monitor both equipment performance and the environmental conditions actually required in each space.

5. What should the master dashboard look like?

A practical dashboard can be divided into three levels.

Level 1 — Executive dashboard

For the Director of Facilities, Chief Engineer, senior management and contract owner

SLA compliance

95%

Illustrative

PM compliance

95%

Illustrative

OPEX variance

+10%

Over budget

Critical utility status

Review

Illustrative status

Demonstration figures only, not actual hospital performance data. Status colors should follow approved targets and risk rules.

Level 2 — Departmental dashboard

Separate views for HVAC, electrical, mechanical, medical gases, plumbing, civil works, fire and life safety, housekeeping, and energy management.

Level 3 — Technical dashboard

Detailed asset trends, alarms, CMMS work orders, repeat failures, maintenance history, energy consumption, operating parameters, and corrective-action tracking.

The executive dashboard highlights exceptions and decisions. Departmental dashboards identify ownership and performance gaps. Technical dashboards provide the evidence required to diagnose and correct problems.

6. Dashboard traffic-light system

A traffic-light system helps managers quickly identify deviations.

Green — On target

KPI meets the approved target. Continue routine monitoring.

Amber — Warning

Performance is approaching a threshold or shows an adverse trend. Assign an investigation and preventive action.

Red — Action required

KPI has breached its approved threshold or a critical risk exists. Escalate according to the severity and required response time.

Do not use the same thresholds for every KPI. For example, 95% PM compliance may be an acceptable general performance indicator in a particular contract, but overdue safety-critical maintenance may require immediate escalation regardless of the aggregate score.

A critical medical-gas alarm or loss of an essential utility should trigger the appropriate emergency procedure immediately, not wait for a dashboard's daily or monthly review.

7. Moving from reactive to predictive maintenance

The real value of the dashboard comes when it changes maintenance decisions.

Stage 1 — Reactive maintenance

Equipment fails → complaint received → technician dispatched → repair completed.

Focus: restoring service after failure.

Stage 2 — Preventive maintenance

Scheduled inspections, lubrication, calibration, servicing, and component replacement.

Focus: reducing avoidable failures.

Stage 3 — Condition-based maintenance

Use vibration, temperature, pressure, differential pressure, electrical current, and other measured conditions to identify deterioration.

Focus: intervening when evidence indicates a need.

Stage 4 — Predictive maintenance

Analyze historical failures, sensor trends, equipment loading, and operating patterns to estimate failure risk and plan interventions.

Focus: anticipating failures and reducing their operational impact.

Example: predictive maintenance for a hospital chiller

Suppose the chiller's electrical consumption increases while its cooling output remains approximately constant.

A dashboard might identify:

1. Increasing kW per refrigeration ton or declining COP.

2. Rising condenser-water temperature or abnormal pressure readings.

3. Increasing vibration in a compressor or pump.

4. Repeated alarms or a pattern of reduced cooling performance.

5. A maintenance requirement based on the combined evidence.

The engineering team investigates the cause, validates instrument accuracy, assesses operational risk, and schedules corrective work where appropriate.

An alert is not proof that a component will fail. Predictive models need reliable data, appropriate alarm thresholds, and engineering validation.

8. How to implement a Master Dashboard using CMMS, BMS and Power BI

A practical digital architecture has four layers.

Data sources

CMMS work orders · BMS trends · Energy meters · Finance · HSE · Customer feedback

Data validation and integration

Asset IDs · timestamps · failure codes · SLA definitions · units · data-quality checks

KPI calculation and analytics

MTTR · MTBF · SLA · PM compliance · cost variance · energy intensity · risk trends

Management dashboard

Power BI or equivalent reporting · exception alerts · action owners · deadlines · verified results

Recommended implementation plan

Phase Main activity Deliverable 1. Define Select business objectives and critical assets Approved KPI dictionary 2. Validate Review CMMS, BMS and finance data Reliable baseline dataset 3. Standardize Agree formulas, exclusions, owners and reporting periods Consistent KPI definitions 4. Build Configure dashboards and trend reports Working prototype 5. Pilot Test one building, plant room or department Validated results 6. Deploy Train staff and establish review meetings Operational dashboard 7. Improve Analyze trends and verify corrective actions Continuous-improvement cycle

A dashboard should have one accountable owner for each KPI, an identified data source, a reporting frequency, an approved target, and a documented action when performance deviates.

9. Suggested management review frequency

• Real time or continuous: Critical BMS alarms, medical-gas alarms, major electrical faults, and other essential utility abnormalities.

• Every shift: Outstanding critical complaints, plant status, utility interruptions, and handover actions.

• Daily: High-priority work orders, breakdowns, critical PM deviations, and overdue corrective actions.

• Weekly: Maintenance backlog, repeat failures, staffing, contractor performance, and energy anomalies.

• Monthly: SLA, MTTR, MTBF, PM compliance, OPEX, customer satisfaction, energy performance, and safety trends.

• Quarterly: Asset lifecycle risks, CAPEX prioritization, contract performance, energy-saving verification, and improvement-project benefits.

10. Recommended priority KPIs for an FM contract

If I were setting up a master dashboard for a large hospital, I would begin with these 12 core measures:

1

Critical utility availability

Continuity of essential services

2

Critical incident response and restoration

Time to respond and restore service

3

SLA compliance

Contractual service delivery

4

Critical PM compliance

Completion of critical maintenance

5

Overall PM compliance

Maintenance schedule performance

6

MTTR and MTBF

Repair performance and reliability

7

Repeat-failure rate

Quality of corrective maintenance

8

Overdue work-order backlog

Outstanding maintenance risk

9

OPEX and budget variance

Financial control

10

Energy intensity and cost

Resource efficiency

11

HSE and statutory compliance

Safety and regulatory obligations

12

Customer satisfaction

Quality of service

These are the core measures, not a complete list. Additional KPIs should be added when they support a specific operational or contractual decision.

11. Interactive KPI prioritization

Use this selector to identify which KPI categories to prioritize for your own facility or contract.

Facility type

Hospital / healthcare

Hotel / hospitality

Commercial building

Industrial / manufacturing

Primary management objective

Asset reliability and service continuity

Energy efficiency and cost reduction

OPEX, CAPEX and contract control

SLA and customer satisfaction

Current digital maturity

Manual logs and spreadsheets

CMMS work orders

Integrated CMMS and BMS

Integrated monitoring and predictive analytics

Build my KPI framework

Final recommendation

The strongest Facility Management Master Dashboard combines reliability, service delivery, financial performance, safety, energy efficiency, and customer outcomes. It should help the FM team anticipate risks, make evidence-based decisions, and demonstrate measurable improvement.

For hospital MEP operations, I would give the highest priority to critical utility continuity, medical-gas reliability, HVAC performance in critical clinical areas, emergency power readiness, critical PM compliance, and timely restoration of essential services. These should be reviewed alongside SLA performance, maintenance cost, and energy KPIs so that cost reductions never compromise patient safety or operational resilience.