KPI for production planning and control: a worked example

A KPI for production planning and control should show whether the plant made the planned quantity, finished the right orders on time and used the capacity available. Start with output attainment, on-time completion, capacity utilization and downtime. A percentage becomes useful only when everyone agrees which orders, units and minutes belong in it.

Choose measures that answer different questions

Production control needs more than a count of finished units. Extra output can sit in inventory while a priority order misses its due time. A busy line can also consume its entire schedule without producing the expected usable quantity.

NIST's research on production KPIs describes relationships among measures of efficiency, throughput and availability. That is a reason to read the measures together, rather than reward a single percentage in isolation.

Use these definitions for the worked example. They are documented plant measures, not a claim that every manufacturer uses identical definitions.

The KPI glossary explains the general distinction between a measure and a performance indicator. The broader KPI examples page covers other teams; here the focus is the production plan and the factory records that prove its execution.

Start with the exports and one reporting cutoff

A US industrial components manufacturer reviews a closed production week across three lines. All lines make interchangeable units from the same product family, so adding their quantities is meaningful. For different products, retain separate unit measures or convert them to a consistently defined standard workload before aggregation.

The planner freezes the planned quantities and original order due times before the week starts. Production records include good completions through the week's closing cutoff. The due-order cohort includes every order whose original due time falls in the week, including orders still open at the cutoff.

Bring these files to the review:

• The frozen production plan, with line, order, item, planned quantity and due timestamp.
• The completion export, with order, accepted quantity and completion timestamp.
• The line calendar and stoppage log, with scheduled production minutes and stopped intervals.
• The approved capacity assumptions for the same line, product mix and reporting window.

Aggregate each export to its correct level before comparing totals. Attaching a line's entire weekly plan to every completion transaction would repeat the denominator. Keep an order-level comparison for timing and a line-level comparison for output and capacity.

A worked example across three lines

The first table contains the frozen quantities and the completion counts. Good output includes all accepted production completed in the week; the timing test considers only the orders due in that week.

The second table adds operating time and sustainable output capability. Scheduled production minutes exclude time that the calendar did not designate for production. Stopped minutes cover the remaining nonrunning time within that window, with overlapping stoppages counted once.

Capacity is the output the plant can reasonably sustain under the specified operating conditions. The Federal Reserve's capacity notes describe sustainable maximum output using a realistic schedule and normal downtime. The capacity assumptions here follow that concept; they are not machine nameplate speeds multiplied by every calendar minute.

Calculate the ratios from these inputs, rounding percentages to one decimal place only for display:

The Census Bureau's plant capacity survey also defines utilization using actual production relative to full production capability. Its published industry statistics use production values and survey weights; the plant table here uses comparable physical units. Do not compare those percentages as if their underlying populations and methods were identical.

Prove the totals before assigning actions

Three checks make the report auditable. First, the quantity bridge is 2,400 - 80 + 40 - 60 = 2,300 units. Second, the time bridge is 6,150 + 1,050 = 7,200 scheduled minutes. Third, the due cohort contains 20 on-time orders and 24 - 20 = 4 orders that were late or still open.

Plant ratios divide plant totals. They do not average line percentages. Capacity utilization, for example, weights each line by its sustainable capacity, while on-time completion weights each line by its due-order count.

Line B needs a sequencing review: it beat its quantity plan but missed more due orders than the other lines. Line C needs a stoppage review before the planner assumes that unused capacity can support extra demand. The production supervisor owns the stoppage explanations; the planner owns order priorities and the frozen plan; finance checks the relationship to cost outcomes.

Labor efficiency variance tests whether labor hours matched the output actually produced. If the financial question is what the factory paid per hour, use labor rate variance separately.

Change one input and see what moves

Suppose Line C completes 60 additional good units on an order that was already late. Change only its good-unit total from 540 to 600. Keep the plan, available capacity, operating minutes and on-time order count fixed.

More usable output improves quantity attainment and capacity utilization. It does not erase an earlier missed promise. The unchanged downtime also shows why output and running time should remain separate measures.

Where it goes wrong

• Moving the plan after production. Compare against the frozen version and report approved changes separately.
• Dropping unfinished orders. The denominator must include all orders due, not just completed orders.
• Mixing quality bases. Accepted output divided by gross-unit capacity understates performance if the capacity assumption includes normal rejects.
• Counting downtime twice. Overlapping maintenance and material-shortage intervals cannot both consume the same minute.
• Adding unlike products. Unit totals can improve simply because the mix shifts toward smaller, faster items.

Compare your production exports in Covirage

Bring a sample of your own production plan, completion export and capacity worksheet to Covirage. Covirage maps the columns, and its tools compute and check the figures; the external AI model explains the result with every figure traced to its rows. Create a free Covirage account and start with a sample of your own data.

See Covirage for industrial manufacturers for the supporting industry context.