What inputs are required for OEE?

This worksheet requires planned busy time, actual production time, planned run time per item, produced quantity and good quantity for the same work unit, interval and product basis.

Is 85 percent a universal world-class OEE limit?

No universal acceptance limit is assigned here. Targets depend on the process, loss/state model, product mix, measurement rules and organizational objective.

Can performance exceed 100 percent?

The arithmetic effectiveness factor can exceed 100 percent when actual output relative to production time is faster than the entered planned run time. The worksheet reports this as a reference-data diagnostic and does not clamp it.

Is OEE the same as calendar utilization or TEEP?

No. This OEE basis uses planned busy time. Calendar-time utilization and TEEP require additional time classifications and are outside this worksheet.

Manufacturing KPI worksheet

OEE Input-Traceability Worksheet

Calculate Availability, Effectiveness, Quality Rate and OEE from one consistent work-unit interval. No universal score, grade or “world-class” acceptance threshold is assigned.

OPC 40501-1 Annex C basisNo benchmark gradingSame time base required

KPI result

OEE = A × E × Q

—

Availability A = APT/PBT

—

Effectiveness E = PRI×PQ/APT

—

Quality rate Q = GQ/PQ

—

Fully productive time PRI×GQ

—

No benchmark, ranking, target compliance, root cause or recommended action is assessed.

Public equation basis

Availability = APT / PBT

Effectiveness = PRI × PQ / APT

Quality rate = GQ / PQ

OEE = Availability × Effectiveness × Quality rate = PRI × GQ / PBT

The algebraic identity is a cross-check only. Each factor still requires a non-zero denominator and traceable input definitions.

Why no 85% grade is shown

The former 85% “world-class” line and poor/average presets were not tied to a controlling standard or process scope. A target is an organizational comparison basis, not a universal physical or ISO acceptance limit.

Effectiveness above 100%: the arithmetic is not clamped. It indicates that output relative to APT exceeded the entered planned run time per item. Review PRI, product mix, time-state classification and counter boundaries before interpreting the KPI.

Excluded

Calendar utilization, TEEP and capacity utilization.
Automatic state classification, planned/unplanned downtime decisions or line aggregation.
Root-cause attribution such as assuming availability is usually the largest or fastest improvement.
Target compliance, financial impact, maintenance action or production acceptance.

Primary sources

OPC UA for Machine Tools, Part 1, Annex C.2.4 publishes these equations and states that planned data normally come from MES/ERP. ISO 22400-2:2014 is published with Amendment 1:2017 and marked “to be revised”; exact closed KPI clauses and alignment remain NEEDS_LICENSED_SOURCE.