Atom AI

AI built inside your CMMS to make your FM operations smarter and easier

Explore Atom Assistants
Reporting & KPI

Maintenance KPIs

A maintenance KPI template carrying the metric set with its formulas and, more usefully, with what a good number on each one hides. Compliance at a hundred percent, a falling backlog and a short mean time to repair can all be symptoms rather than achievements, and the point of this document is that it says when, which is what separates it from a list of metric names.

  • Sixteen metrics, each with its formula and what it excludes
  • What a good number may actually mean, metric by metric
  • Backlog reported in crew weeks rather than job count
  • Time between failures and time to repair read separately
maintenance-kpis.xlsx

Maintenance KPIs

And what a good number hides

Per metric
Formula, source, cadence
Per metric
What a good number may mean
Per period
Target, result, gap, RAG
Reported as
Crew weeks, never job count
#WHAT A GOOD NUMBER HIDESLOOKS LIKEMAY MEANCHECK
1PM completion on time
2Backlog in crew weeks
3Mean time to repair (MTTR)
plus seven more read the same way across planned work ratio, emergency work ratio, PM yield, asset availability, cost as a percentage of RAV, schedule attainment and repeat failure rate, then the sixteen definitions with their formulas and data sources, the RAG scorecard, and the headline position that converts backlog hours into crew weeks.

The document you will get. Download for the full, editable file.

Who this maintenance KPI template is for

One metric set, four readers, and each of them can be misled by a different line.

  • The maintenance manager

    Section three above all. It is the difference between a function that is good and one that has been managed into looking good.

  • The planner

    Schedule attainment, PM yield and backlog in crew weeks, which together say whether the plan is realistic or merely published.

  • The operations director

    Backlog in crew weeks and planned work ratio. Two numbers that say whether this is under control, without needing the other fourteen.

  • The reliability engineer

    Time between failures, repeat failure rate and PM yield, read as a set rather than as separate lines on a scorecard.

Where the metric set has to survive scrutiny

The structure suits any maintenance function reporting upward to people who did not do the work. What changes is the asset base and which metric gets challenged first. If you run one of these, the sector page goes further than the template does.

What a maintenance KPI dashboard should contain

Maintenance KPIs are the measures used to judge whether a maintenance function is working. They cover reliability, schedule performance, backlog, labor and cost, each with a stated formula and data source. This set pairs every metric with what a good result on it may actually be hiding, so the scorecard cannot be improved by doing the wrong thing.

A. Definitions, the trap, the scorecard, the position

FieldWhat goes in itWhy it earns its place
What is being measuredScope, period, replacement asset value, crew hours, system of recordIt also asks whether the data is trusted, which is the most important line in the document and the one most often left blank.
Replacement asset valueEstimated rather than omittedIt is the denominator for cost as a percentage of RAV, and an estimate is far more useful than leaving the only cost benchmark out entirely.
Definitions and formulasSixteen metrics with formula, data source and cadenceWritten out including what is excluded. Two sites reporting PM compliance can mean entirely different things, and nobody notices until the numbers are compared.
What a good number hidesTen metrics, each with what a good result may actually meanThe reason to use this rather than a list of metric names. Every number here can be improved by doing the wrong thing.
PM completion on timeAgainst a schedule, with exclusions statedA hundred percent every month usually means the schedule is undemanding or jobs are being signed off unseen. The check is to audit a sample against the asset.
Backlog in crew weeksBacklog hours divided by crew hours availableThe number to report upward. Job count is unreadable: two hundred jobs could be two weeks of work or a year of it depending on what they are.
Schedule attainmentWork completed as scheduled, not merely completedDistinct from PM compliance, and the pair of them is how you tell a realistic plan from a published one.
PM yieldFindings raised per preventive taskA PM regime that never finds anything is either preventing everything or inspecting nothing, and yield is the only way to tell which.
Wrench timeMeasured, as a share of available hoursThe metric most resisted and most revealing. It is usually far lower than anyone expects, and the causes are rarely the technicians.
Cost as a percentage of RAVMaintenance spend against replacement asset valueThe one cost metric that compares across sites of different sizes, which is why the denominator is asked for at the top.
RAG scorecardTarget, result, gap, direction and a comment per metricGreen, Amber or Red, spelled exactly that way. Direction matters more than the gap on most of these.
Reading these togetherWhich metrics moved for reasons other than performanceHeadcount, system and definition changes all move a scorecard without anything improving or deteriorating, and that line prevents the wrong conclusion.

Any maintenance metric can be improved by doing the wrong thing, and a function measured without that in view will eventually be managed into looking good rather than into being good. This is not cynicism about maintenance teams; it is a structural property of measurement. PM compliance rises if the schedule is made less demanding, or if jobs are closed without the asset being visited. Backlog falls if work is canceled rather than completed. Mean time to repair shortens if only the straightforward failures get logged and the awkward ones are handled informally. Planned work ratio improves if reactive jobs are retrospectively reclassified. Each of these is a rational local response to being measured, and none of them involves anybody behaving dishonestly; they are what happens when a number becomes a target and nobody has written down what a good version of that number would also be consistent with. That is the whole function of section three. It pairs every metric with the uncomfortable alternative reading and, more usefully, with a specific check: audit a sample of completed preventive tasks against the asset, look at what proportion of the backlog is being closed as canceled, compare logged repair times against the jobs people actually remember. The second structural decision worth protecting is reporting backlog in crew weeks. Backlog expressed as a job count is genuinely unreadable, because two hundred jobs might be two weeks of work or a year of it, and the figure moves when job sizes change without the workload changing at all. Expressed as crew weeks it becomes immediately legible and, set beside the rate at which new work arrives, it answers the only question anybody actually has: is this clearing, holding, or quietly growing.

B. What it looks like filled in

One period on one site. Nothing here is alarming, and two lines deserve a question.

LineValue
Time between failures, time to repair412 hours, 3.8 hours
PM compliance, schedule compliance91 percent, 88 percent
Planned work, emergency work74 percent planned, 9 percent emergency
Backlog, overdue PMs186 hours, so 4.1 crew weeks, 12 overdue
Wrench time, rework31 percent, 6 percent
Availability, spend as a share of RAV97.2 percent, 0.6 percent

This is a competent maintenance function having an ordinary period, which is exactly the condition under which a scorecard is most likely to be misread. Ninety one percent PM compliance against a target of ninety five is amber and worsening, and the comment against it on the scorecard is two technicians on long-term absence, which is the right way to use that column: the number explains itself and nobody needs to invent a theory. Availability at ninety seven point two and emergency work at nine percent are both healthy. The two lines worth a question are wrench time and backlog. Thirty one percent wrench time means roughly two thirds of available hours go somewhere other than tools-on-task, and while that figure is typical it is typical for reasons that are fixable: travel between sites, waiting for parts, waiting for access, and the paperwork around a job rather than the job. It is the single largest capacity opportunity on this sheet and it does not involve anybody working harder. Backlog at four point one crew weeks is only meaningful alongside the rate at which new work arrives, which is why the headline section asks for crew hours available rather than backlog alone; four weeks of work with three weeks of new work arriving every month is a backlog that will never clear, and four weeks with two is one that will. Note what is not here: nothing about the building itself, its running cost per unit of floor, or how the people in it feel about it. That is a facility management KPI scorecard, which is a different document for a different reader. The stoppage data behind time between failures and time to repair is captured on the downtime log, and the completion record behind PM compliance is the preventive maintenance log. For the question of which of these metrics are worth tracking in the first place, there is a guide on how to choose which maintenance metrics to track.

Download the maintenance KPI template

Word for the version circulated before a review, Excel for the one that converts backlog hours into crew weeks and holds a Trend tab across periods, and PDF for the copy that goes into the pack. Free, and yours to rebrand.

Get the template

How do you report maintenance KPIs?

Say whether the data is trusted, then define before you measure. Six steps.

  1. Write down whether the underlying data is trusted

    Half the maintenance metrics in circulation come from a system people do not close jobs in properly, and a metric built on bad data is worse than none because somebody will act on it.

  2. Write each formula out, including the exclusions

    Whether canceled, skipped and not-accessed jobs count as completed changes PM compliance entirely, and nobody notices until two sites are compared.

  3. Estimate replacement asset value rather than omitting it

    It is the denominator for the only cost metric that compares across sites of different sizes. An estimate beats leaving the benchmark out.

  4. Convert backlog hours into crew weeks

    And put the rate of new work beside it. That pair answers whether the backlog is clearing, holding or growing, which the job count cannot.

  5. Read each metric against what a good number hides

    Then run the check in the third column. A sample of completed preventive tasks audited against the asset is worth more than another month of compliance figures.

  6. Read time between failures and time to repair separately

    They are fixed by different people. Falling time between failures is an asset problem; rising time to repair is spares, access or resourcing.

Compliance at a hundred percent is not always good news. See how Atom AI assistants produce these metrics from the work itself rather than from a monthly spreadsheet.
See Atom AI assistants

A good number versus a number being managed

The same figure, read two ways. The second reading is the one a scorecard alone will never give you.

MetricThe good readingThe other reading
PM completion at 100%The regime is under controlThe schedule is undemanding, or closed unseen
Backlog fallingThe team is catching upWork is being canceled, not done
Short time to repairRepairs are efficientOnly the easy failures are logged
High planned work ratioReactive work is reducingReactive jobs reclassified afterward
PM yield near zeroNothing is going wrongThe inspections are not really happening
High availabilityThe assets are reliableDowntime is recorded against something else

Nothing in the right-hand column requires anybody to act dishonestly, which is precisely why it is so common. Each of those readings is the predictable consequence of measuring something and attaching consequences to it, and the people closest to the number are usually the last to notice the drift because every individual decision was locally reasonable. A planner who removes an unachievable task from the schedule has improved the schedule. A supervisor who closes a job that was attended but not fully completed has recorded what substantially happened. A technician who fixes something quickly and informally, without raising a work order, has solved the problem faster than the process would have. Repeat those decisions for a year and the scorecard is green and the asset base is deteriorating. The defense is not tighter policing, which produces its own distortions; it is pairing each metric with a specific check that looks at the thing rather than at the record. Audit a sample of completed preventive tasks against the asset itself. Look at what share of the closed backlog was closed as canceled. Compare logged repair durations against the jobs people actually remember from the period. Three checks of that kind are worth more than another month of compliance reporting, and they take a morning. The other reason this page exists separately from a general facilities scorecard is vocabulary. Schedule attainment, PM yield, wrench time and cost as a percentage of replacement asset value are reliability-engineering terms with precise meanings, and softening them into general facilities language loses the precision that makes them worth measuring. The broader scorecard that measures the building rather than the maintenance function is the facility management KPI scorecard, and it is deliberately a different document for a different reader.

When the template starts to feel limiting

The file reports one period cleanly, and a single period tells you almost nothing. Four things get difficult.

  • One period is noise

    Most of these metrics only become readable on the fourth or fifth reading, when direction is visible, and on paper that means collating months by hand.

  • The definitions drift

    A formula agreed once is quietly reinterpreted as people change, and the number moves without anything about the work changing.

  • Everything is retrospective

    The scorecard is compiled after the period it describes, so the first time anybody sees a problem it is already a month old.

  • The checks in section three need doing

    Nothing on the sheet forces the sample audit that would reveal whether a good number is real, and it is the first thing dropped when the period is busy.

What running this in Facilio looks like

The metric set does not change. What changes is that it is produced from the work rather than assembled from it.

  • Ops Performance Intelligence

    The metrics are continuous

    Compliance, backlog and attainment move as work moves, so a problem is visible during the period rather than described after it.

  • Work Order Intelligence

    The formula is applied once

    Exclusions defined in one place and applied everywhere, which is what stops two sites reporting the same metric and meaning different things.

  • Asset Intelligence

    Repeat failures surface by asset

    Three failures on one asset in a quarter reads as a reliability problem rather than three closed jobs and a healthy time to repair.

  • Audit Report Intelligence

    The sample audit is evidenced

    Completed preventive tasks checked against the asset, which is the check section three asks for and the one most often skipped.

Hallucination-free by design. Atom AI answers from the records in your tenant rather than generating plausible text, so an empty field reads as empty rather than filled in for you.

Frequently asked questions

What are maintenance KPIs?

They are the measures used to judge whether a maintenance function is working: reliability, schedule performance, backlog, labor and cost, each with a stated formula and data source.

This template carries sixteen of them, and pairs ten with what a good result on that metric may actually be hiding.

What should a maintenance KPI dashboard contain?

A target, a result, a gap, a direction and a comment for each metric, with the formula and its exclusions written down somewhere the reader can reach.

Direction matters more than the gap on most of these, and the comment field is what stops a reader inventing an explanation for a number that already has one.

Why is PM compliance at a hundred percent a warning sign?

Because it usually means the schedule is undemanding, or that jobs are being signed off without the asset being visited.

The check is to audit a sample of completed preventive tasks against the asset itself. A morning of that is worth more than another month of compliance reporting.

Why report backlog in crew weeks instead of job count?

Because a job count is unreadable. Two hundred outstanding jobs might be two weeks of work or a year of it, and the figure moves when job sizes change without the workload changing.

Four weeks of work for a crew receiving three weeks of new work every month is a backlog that will never clear. The job count cannot tell you that.

What is wrench time and why does it matter?

It is the share of available hours spent with tools on task, measured rather than estimated. It is usually far lower than anyone expects.

It is the largest capacity opportunity on most scorecards, and the causes are travel, waiting for parts, waiting for access and paperwork rather than the technicians.

Should time between failures and time to repair be managed together?

No, and treating them as one problem fixes neither. They move for different reasons and are fixed by different people.

Falling time between failures is an asset or maintenance regime problem. Rising time to repair is almost always spares, access or resourcing.

What is cost as a percentage of RAV?

Maintenance spend expressed against the replacement asset value of what is being maintained. It is the one cost metric that compares meaningfully across sites of different sizes.

Estimate the replacement value rather than omitting it, because an estimated denominator is far more useful than having no cost benchmark at all.

How is this different from a facility management KPI scorecard?

This one is the maintenance function measured in reliability-engineering terms: schedule attainment, PM yield, wrench time, cost against replacement asset value.

The wider facilities scorecard measures the building and its occupants rather than the maintenance function, and it is written for a different reader.

In one paragraph

A maintenance KPI set works when every metric is paired with what a good number on it would also be consistent with, because each of them can be improved by doing the wrong thing and a function measured without that in view gets managed into looking good. Write each formula out including its exclusions, say plainly whether the underlying data is trusted, report backlog in crew weeks beside the rate of new work rather than as a job count, and read time between failures and time to repair separately because different people fix them.

Good, or managed to look good

State whether the data is trusted, define before you measure, convert backlog into crew weeks and run the checks in the third column. Once a single period is all you can see, or the definitions have drifted between the people reporting them, the spreadsheet version has reached its limit.

Maintenance KPIs Word · Excel · PDF