What is the difference between plan attainment and line efficiency?

Plan attainment compares good units with what the schedule asked for; line efficiency compares them with what the line could make at rated speed in its planned time. A line rated at 2,400 units per hour, planned for 450 minutes, has a capacity of 18,000 units. If the plan was 15,300 and it made 15,000 good, attainment is 98.0 percent but efficiency is 83.3 percent: the plan was met, but the line ran well below its speed.

How is line efficiency calculated?

Good units divided by rated speed times planned minutes over 60. For 850 good units on a line rated at 125 units per hour planned for 480 minutes, capacity is 1,000 units and line efficiency is 85.0 percent, 5 points below a 90 percent target and 150 units short, the same answer as the Line Efficiency calculator.

Why record only the main loss reason?

A shift report has to take a supervisor two minutes. One main reason per row, with the total downtime minutes, is enough to show which reasons cost the most over a week or a month, and the Pareto adds them up. If you need every stop with its own reason, use the OEE Tracker template, which logs each stop separately.

Why does the dashboard not average the percentages?

Because a short shift and a full shift would then count the same. The workbook adds good units, scheduled units, capacity, made units and labour hours over the rows in view and divides the sums. Two rows at 100 percent of a 1,000 unit plan and 50 percent of a 200 unit plan give 91.7 percent attainment, not 75 percent.

Where do the targets come from?

You set them on Setup: attainment, line efficiency, first-pass yield and units per labour hour. The workbook does not assume an industry benchmark. Near target means within 5 percent below the target, so against a 95 percent attainment target, 90.25 to 95 percent shows Near target.

Production and Throughput

Shift Production Report Excel Template

Record each line's shift in one row and see plan attainment, line efficiency, first-pass yield, units per labour hour and the main stop reasons by day, line and shift.

Overview

This shift production report is a working Excel log and dashboard for shift supervisors and production managers. Each line's shift is one row: what the schedule asked for, how long the line was planned to run and was stopped, the main reason it stopped, how many units it made and how many were good, the labour hours and a handover note. It ships with two weeks of example data for a fictional three-line filling plant, so the dashboard is populated the moment you open it.

From each row the workbook works out four numbers. Plan attainment is good units over the scheduled quantity. Line efficiency is good units over the capacity at rated speed for the planned time, the same ratio as the Line Efficiency calculator on this site. First-pass yield is good over made, and units per labour hour is good units over paid labour hours. Every summary adds the quantities first and divides last, so a big shift counts for more than a short one and the totals agree with the rows.

In practice, the attainment chart shows which days missed the plan, the plan-versus-good chart shows which line fell short, and the downtime Pareto shows what to fix first. In the example, line L2's capper jams make it the weakest line on efficiency and the late shift runs a few points below the early shift, the kind of pattern that a stack of paper reports hides. For stop-by-stop downtime and the full OEE breakdown, pair it with the OEE Tracker template.

What this template includes

Shift Log table, one row per line per shift: product, scheduled quantity, planned minutes, downtime with its main loss reason, units made, good units, labour hours and a handover note
Per-row capacity at rated speed, scrap, plan attainment, line efficiency, first-pass yield and units per labour hour, with a status word against your attainment target
Check column that names problems in words: good above made, downtime without a reason, output above rated speed, a duplicate line-shift row, a product missing from the list
Dashboard with line and date filters, eight KPI tiles against Setup targets, and the biggest loss reason
Four native charts: plan attainment by day, scheduled vs good units by line, a downtime Pareto by main loss reason, and attainment and efficiency by shift
Daily, by-line and by-shift summary tables that add quantities first and divide last
Method sheet with every formula, and a Verify sheet that re-checks the formulas against an independent reference (Self-check: PASS)

Suggested use case

Use it to replace the paper or whiteboard shift report: supervisors fill one row per line at the end of each shift, and the morning meeting reads yesterday's attainment, efficiency, scrap and stops straight from the Dashboard.

How to use it

On Setup, enter your plant name and targets, then replace the example lines, shifts, products with their rated speeds, and loss reasons.
At the end of each shift, add one row per line with the scheduled quantity, planned minutes, downtime and its main reason, units made, good units, labour hours and a handover note.
Fix anything the Check column flags.
In the morning meeting, open the Dashboard; set From and To to yesterday for one day's report, or filter by line for a weekly review.

Frequently Asked Questions

What is the difference between plan attainment and line efficiency?: Plan attainment compares good units with what the schedule asked for; line efficiency compares them with what the line could make at rated speed in its planned time. A line rated at 2,400 units per hour, planned for 450 minutes, has a capacity of 18,000 units. If the plan was 15,300 and it made 15,000 good, attainment is 98.0 percent but efficiency is 83.3 percent: the plan was met, but the line ran well below its speed.
How is line efficiency calculated?: Good units divided by rated speed times planned minutes over 60. For 850 good units on a line rated at 125 units per hour planned for 480 minutes, capacity is 1,000 units and line efficiency is 85.0 percent, 5 points below a 90 percent target and 150 units short, the same answer as the Line Efficiency calculator.
Why record only the main loss reason?: A shift report has to take a supervisor two minutes. One main reason per row, with the total downtime minutes, is enough to show which reasons cost the most over a week or a month, and the Pareto adds them up. If you need every stop with its own reason, use the OEE Tracker template, which logs each stop separately.
Why does the dashboard not average the percentages?: Because a short shift and a full shift would then count the same. The workbook adds good units, scheduled units, capacity, made units and labour hours over the rows in view and divides the sums. Two rows at 100 percent of a 1,000 unit plan and 50 percent of a 200 unit plan give 91.7 percent attainment, not 75 percent.
Where do the targets come from?: You set them on Setup: attainment, line efficiency, first-pass yield and units per labour hour. The workbook does not assume an industry benchmark. Near target means within 5 percent below the target, so against a 95 percent attainment target, 90.25 to 95 percent shows Near target.