How is equipment availability calculated?

Availability equals operating time divided by planned production time. Operating time is planned production time minus total downtime. If a machine is scheduled for 160 hours and loses 16 to breakdowns and setups, operating time is 144 and availability is 144 / 160, or 90 percent. This template computes it per row once you enter planned production time and your planned and unplanned downtime figures.

What is the difference between planned and unplanned downtime?

Planned downtime is scheduled and expected: PM, changeovers, and known no-demand periods. Unplanned downtime is failures, jams, and material stoppages you did not schedule. Keeping them separate matters because only unplanned downtime signals reliability problems. A machine losing 20 hours to planned PM is fine; losing 20 hours to breakdowns is not. This template logs them in separate columns so your availability trend isolates the losses you can fix.

What is a good equipment availability percentage?

For OEE purposes, world-class availability sits around 90 percent, meaning roughly 10 percent of scheduled time is lost to downtime and stops. Many plants run in the 80 to 85 percent range. The right target depends on process type: continuous flow lines often exceed 95 percent, while high-changeover job shops run lower. Compare against your own target column rather than a generic benchmark to judge performance fairly.

How does availability feed into OEE?

OEE is availability multiplied by performance multiplied by quality. Availability is the first of the three factors. If availability is 90 percent, performance 95 percent, and quality 99 percent, OEE is 0.90 by 0.95 by 0.99, or about 85 percent. A low availability caps OEE no matter how good the other two are, which is why this template isolates and trends it separately from speed and defect losses.

Should planned downtime be subtracted from availability?

It depends on your definition. In classic OEE, availability is measured against planned production time, so scheduled PM and breaks are already excluded from the denominator and do not count against you. Only downtime during scheduled run time hurts availability. This template lets you enter planned downtime separately so you can either exclude it or report total asset utilization, matching whichever standard your plant uses.

How do I track availability across multiple machines?

Give each machine its own row per period and log downtime consistently so the percentages are comparable. Roll up a fleet average by weighting each machine's availability by its planned production hours, not a simple average, so a rarely used asset does not skew the number. The month-over-month trend column then shows whether the fleet is improving, and the target comparison flags which specific machines are dragging the group down.

Maintenance and Reliability

Equipment Availability Spreadsheet Template

Track equipment availability by calculating the ratio of uptime to planned production time across machines, shifts, and periods.

Overview

This template calculates equipment availability as the ratio of actual uptime to planned production time, broken out by machine, shift, and period. It is built for maintenance and operations teams who report KPIs monthly and need a defensible number rather than a rough estimate. Guessing availability from memory hides small daily losses that add up to weeks per year. A spreadsheet captures planned and unplanned downtime separately, so you can see exactly where the hours go and act on the real cause.

You enter planned production time for the period, then log planned downtime and unplanned downtime in separate columns. Availability equals operating time divided by planned production time, where operating time is planned production time minus all downtime. Separating planned from unplanned matters because only unplanned downtime reflects reliability problems. The month-over-month trend and the target-versus-actual comparison connect these inputs to a single percentage, and the comments column captures major events that explain any dip.

In practice you fill this in at month close, compare actual availability to your target, and flag any machine that missed. If a line targets 92 percent and hits 87, the unplanned downtime column and comments tell you whether a breakdown or a changeover caused it. Track the trend after an overhaul to prove the fix held. Availability is the first pillar of OEE, so pair it with the live Equipment Availability Calculator to check a single shift, then use this sheet for the running KPI record.

What this template includes

Planned production time per period
Planned downtime input
Unplanned downtime from event log
Equipment availability percentage
Month-over-month availability trend
Target availability vs. actual comparison
Comments column for major events

Suggested use case

Use this for a monthly maintenance KPI report, to monitor availability after a machine overhaul, or to track a fleet of equipment against targets.

How to use it

Enter planned production hours for the period.
Enter planned and unplanned downtime separately.
Availability calculates automatically.
Compare to your target to see if the machine is meeting expectations.
Track month-over-month to see if the trend is improving.

Frequently Asked Questions

How is equipment availability calculated?: Availability equals operating time divided by planned production time. Operating time is planned production time minus total downtime. If a machine is scheduled for 160 hours and loses 16 to breakdowns and setups, operating time is 144 and availability is 144 / 160, or 90 percent. This template computes it per row once you enter planned production time and your planned and unplanned downtime figures.
What is the difference between planned and unplanned downtime?: Planned downtime is scheduled and expected: PM, changeovers, and known no-demand periods. Unplanned downtime is failures, jams, and material stoppages you did not schedule. Keeping them separate matters because only unplanned downtime signals reliability problems. A machine losing 20 hours to planned PM is fine; losing 20 hours to breakdowns is not. This template logs them in separate columns so your availability trend isolates the losses you can fix.
What is a good equipment availability percentage?: For OEE purposes, world-class availability sits around 90 percent, meaning roughly 10 percent of scheduled time is lost to downtime and stops. Many plants run in the 80 to 85 percent range. The right target depends on process type: continuous flow lines often exceed 95 percent, while high-changeover job shops run lower. Compare against your own target column rather than a generic benchmark to judge performance fairly.
How does availability feed into OEE?: OEE is availability multiplied by performance multiplied by quality. Availability is the first of the three factors. If availability is 90 percent, performance 95 percent, and quality 99 percent, OEE is 0.90 by 0.95 by 0.99, or about 85 percent. A low availability caps OEE no matter how good the other two are, which is why this template isolates and trends it separately from speed and defect losses.
Should planned downtime be subtracted from availability?: It depends on your definition. In classic OEE, availability is measured against planned production time, so scheduled PM and breaks are already excluded from the denominator and do not count against you. Only downtime during scheduled run time hurts availability. This template lets you enter planned downtime separately so you can either exclude it or report total asset utilization, matching whichever standard your plant uses.
How do I track availability across multiple machines?: Give each machine its own row per period and log downtime consistently so the percentages are comparable. Roll up a fleet average by weighting each machine's availability by its planned production hours, not a simple average, so a rarely used asset does not skew the number. The month-over-month trend column then shows whether the fleet is improving, and the target comparison flags which specific machines are dragging the group down.