# Production Scheduling KPI Formula Reference (Schedule Adherence, Utilization, Flow Time)

> Source: https://netray.co/tools/scheduling-kpi-formula-reference
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Every scheduling KPI a planner is asked for, with its formula, unit and the usual way it is misread.

## Category

mes-shop-floor

## Audience

- Production scheduler
- Plant manager
- Continuous improvement lead

## Tool

**Kind:** worksheet

**Mode:** reference

**Columns:**

#### KPI

**Key:** kpi

**Type:** text

#### Formula

**Key:** formula

**Type:** text

#### Unit

**Key:** unit

**Type:** text

#### What it tells you

**Key:** use

**Type:** text

#### Common misreading

**Key:** trap

**Type:** text

**Rows:**

**Kpi:** Schedule adherence (by quantity)

**Formula:** Units produced as planned / units planned x 100

**Unit:** %

**Use:** Did the floor make what was scheduled

**Trap:** Overproduction can hide a miss on other items

**Kpi:** Schedule adherence (by job)

**Formula:** Jobs completed in the planned window / jobs planned x 100

**Unit:** %

**Use:** How reliable the plan is job by job

**Trap:** A job one hour late counts the same as one three weeks late

**Kpi:** Plan attainment

**Formula:** Planned hours earned / planned hours scheduled x 100

**Unit:** %

**Use:** Weighted view of attainment by labor or machine hours

**Trap:** Depends on credible standard hours

**Kpi:** On time delivery (OTD)

**Formula:** Orders shipped on or before the promise date / orders shipped x 100

**Unit:** %

**Use:** Customer facing delivery performance

**Trap:** Date definition: promise date vs request date changes the result

**Kpi:** On time in full (OTIF)

**Formula:** Orders on time and complete / orders due x 100

**Unit:** %

**Use:** Delivery with correct quantity

**Trap:** Partial shipments need a clear tolerance rule

**Kpi:** Capacity utilization

**Formula:** Actual output hours / available hours x 100

**Unit:** %

**Use:** How much of available time was used

**Trap:** High utilization on a non-bottleneck often means overproduction

**Kpi:** Load percent

**Formula:** Scheduled hours / available capacity hours x 100

**Unit:** %

**Use:** Forward looking load vs capacity for a period

**Trap:** Over 100% means the plan cannot be met without action

**Kpi:** Efficiency

**Formula:** Earned standard hours / actual hours worked x 100

**Unit:** %

**Use:** Labor or machine performance vs standard

**Trap:** Standards that are stale make it meaningless

**Kpi:** OEE

**Formula:** Availability x performance x quality

**Unit:** %

**Use:** Equipment effectiveness during planned production time

**Trap:** Excludes planned downtime, so it is not TEEP

**Kpi:** TEEP

**Formula:** OEE x utilization of calendar time

**Unit:** %

**Use:** Effectiveness against all calendar time

**Trap:** Rarely comparable between plants with different shift patterns

**Kpi:** Availability

**Formula:** Run time / planned production time

**Unit:** ratio

**Use:** Loss from stops and breakdowns

**Trap:** Short stops often go unrecorded

**Kpi:** Performance rate

**Formula:** (Ideal cycle time x total count) / run time

**Unit:** ratio

**Use:** Loss from slow cycles

**Trap:** Wrong ideal cycle time distorts the result

**Kpi:** Quality rate

**Formula:** Good count / total count

**Unit:** ratio

**Use:** Loss from scrap and rework

**Trap:** Rework counted as good hides the loss

**Kpi:** Takt time

**Formula:** Available production time / customer demand

**Unit:** time per unit

**Use:** Pace needed to meet demand

**Trap:** Uses demand rate, not the production rate achieved

**Kpi:** Cycle time

**Formula:** Time from start of one unit to start of the next unit at a station

**Unit:** time per unit

**Use:** Pace of a process step

**Trap:** Not the same as lead time

**Kpi:** Manufacturing lead time

**Formula:** Queue + setup + run + wait + move time

**Unit:** days

**Use:** Total elapsed time through the routing

**Trap:** Queue time is usually the largest part and the least measured

**Kpi:** Work in process (Little's law)

**Formula:** Throughput rate x average flow time

**Unit:** units

**Use:** Links WIP, flow time and output

**Trap:** Throughput and flow time must use the same time unit

**Kpi:** Average flow time

**Formula:** WIP / throughput rate

**Unit:** days

**Use:** Estimated time a unit spends in the system

**Trap:** Assumes a stable system, not a surge period

**Kpi:** Flow efficiency

**Formula:** Value adding time / total lead time x 100

**Unit:** %

**Use:** Share of lead time spent actually working

**Trap:** Often below 10% in job shops, which is normal to see

**Kpi:** Setup time ratio

**Formula:** Total setup time / (setup + run time) x 100

**Unit:** %

**Use:** Share of capacity lost to changeover

**Trap:** Look at the bottleneck first, not the plant average

**Kpi:** Backlog in weeks

**Formula:** Open order hours / weekly available capacity hours

**Unit:** weeks

**Use:** How long the order book would take to clear

**Trap:** Ignores mix: backlog can sit on one resource

**Kpi:** Past due backlog

**Formula:** Open operations with due date before today, count or hours

**Unit:** count or hours

**Use:** Size of the late queue

**Trap:** Counting only jobs hides the hours

**Kpi:** Schedule stability

**Formula:** Operations unchanged inside the freeze window / operations scheduled in the window x 100

**Unit:** %

**Use:** How often the plan is reshuffled

**Trap:** Low stability often comes from late material, not from planners

**Kpi:** Changeover frequency

**Formula:** Number of setups / scheduled production days

**Unit:** setups per day

**Use:** Effect of batching and sequencing choices

**Trap:** Fewer setups can mean larger WIP

**Kpi:** First pass yield

**Formula:** Units passing first time / units started x 100

**Unit:** %

**Use:** Process quality at a step

**Trap:** Rolled throughput yield is the product of step yields

**Notes:** Formulas are the common textbook and shop floor definitions. Agree an exact definition with your management before you publish numbers, especially for adherence and on time delivery.

## Content

**Intro:** Scheduling KPIs sound simple until two people calculate them differently. This table lists the standard formulas with their units and the usual misreadings, so a scheduler can agree one definition and defend it.

**Sections:**

#### How to use this reference

**Body:** Search for the KPI name, then copy the formula into your report specification or BI model. Check the unit column before you chart anything: Little's law only works when throughput and flow time use the same time unit, and takt time is a time per unit, not a rate. Export the filtered rows to Excel to build a KPI dictionary your team can sign off. A one page dictionary prevents most arguments about whose number is right.

#### Adherence versus attainment versus OTD

**Body:** Schedule adherence looks inward: did the floor follow the plan. On time delivery looks outward: did the customer get the order by the promise date. A plant can have high adherence and poor delivery if the plan was wrong, and the reverse if the team recovers through overtime. Track both, and add schedule stability to see how often the plan changes after it was frozen. Together the three show whether problems come from planning, execution or demand.

#### Worked example with Little's law

**Body:** Suppose a cell completes 40 units a day and holds 200 units of WIP. Average flow time is WIP divided by throughput, so 200 / 40 equals 5 days. If you cut WIP to 120 with the same throughput, flow time falls to 3 days. This is why WIP caps such as CONWIP or kanban shorten lead time without any speed change. If throughput also falls after the cut, you removed WIP from the bottleneck, which is the mistake to avoid.

#### Common mistakes

**Body:** Reporting average utilization across all resources hides the bottleneck, whose utilization is the only one that limits output. Measuring adherence against a plan that was rewritten daily gives a flattering number. Mixing planned and unplanned downtime inside availability makes OEE look worse than the equipment really is. Define the plan snapshot date, the time basis and the exclusions in writing, and apply them the same way every period.

**Cta:** If your ERP holds the data but the KPIs live in spreadsheets, we can build these measures over live ERP tables with the query visible and read-only access.

**Faq:**

#### How do I calculate schedule adherence?

**Answer:** Divide units, jobs or hours completed as planned by those planned in the same period and multiply by 100. State whether you measure by quantity, by job or by earned hours, because the three give different answers for the same week.

#### What is the difference between OEE and TEEP?

**Answer:** OEE measures effectiveness during planned production time using availability, performance and quality. TEEP multiplies OEE by the share of calendar time you plan to run, so it shows the loss from idle shifts as well.

#### What is a good capacity utilization target?

**Answer:** It depends on variability. A bottleneck is often planned near 85 to 95 percent, while resources with high variability need more spare time. Running every resource at 100 percent normally lengthens queues and lead times sharply.

#### How does Little's law help a scheduler?

**Answer:** It links WIP, throughput and flow time: WIP equals throughput times flow time. If you need shorter lead time without more output, you reduce WIP through release control, which is the idea behind CONWIP and kanban.

## Search terms

schedule adherence formula, production scheduling KPIs, capacity utilization formula manufacturing, schedule attainment calculation, manufacturing throughput time formula, Little's law WIP formula, OEE formula availability performance quality, on time delivery calculation

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json