KPI Library / Production

Schedule Attainment

Formula: Units produced ÷ units scheduled (per line, per week)
Typical range: 85% is the most common target; 95%+ sustained suggests soft schedules

Schedule attainment answers one question: did the plant build what it said it would build? It compares actual output to the committed schedule at line-week grain. Where OEE measures the machine, attainment measures the promise, which is why it is usually the number an ops director reads first on Monday morning.

Why the target is usually 85%

A schedule loaded to 100% of demonstrated capacity leaves zero room for the normal chaos of a plant: absenteeism, material shorts, quality holds. Most operations set the bar at 85% and treat anything below it as a trigger for a structured line-by-line review. Consistently exceeding 95% is its own warning sign: schedules are probably sandbagged, and capacity is quietly going unsold.

Attainment vs OEE vs utilization

Metric	Question it answers	Owner
Schedule attainment	Did we build what we committed?	Ops / scheduling
OEE	How well did the equipment run?	Maintenance / engineering
Utilization	How much of the clock did we use?	Finance / capacity planning

A line can post 90% OEE and 60% attainment in the same week. It ran beautifully on the wrong parts.

Schedule attainment in Power BI (DAX)

With a weekly schedule fact (scheduled_units, produced_units at line-week grain):

Schedule Attainment % =
DIVIDE (
    SUM ( fact_weekly_schedule[produced_units] ),
    SUM ( fact_weekly_schedule[scheduled_units] )
)

Attainment Status =
SWITCH (
    TRUE (),
    [Schedule Attainment %] >= 0.85, 1,    -- green
    [Schedule Attainment %] >= 0.75, 0,    -- amber
    -1                                     -- red
)

Compute the ratio from summed units, never as an average of weekly percentages, or small lines will distort the plant number. Plot it weekly with a constant 85% target line; the trend against target matters more than any single week.

Common mistakes

Counting early production as attainment. Building next week’s schedule early still counts as a miss on this week’s committed mix.
Restating the schedule mid-week. Lock the schedule at week start; measure against the lock, not the latest revision.
Ignoring mix. 100% of units on 80% of part numbers can still strand a customer order. Pair attainment with past-due and OTD.