How do I calculate line balance efficiency in this template?

Line efficiency equals total work content divided by the bottleneck cycle time times the number of stations, expressed as a percent. If five stations total 200 seconds of work content and the slowest station runs 48 seconds, efficiency is 200 / (48 x 5) = 83.3 percent. Balance delay is the remainder, 16.7 percent, which represents idle time spread across the line. Target 85 to 95 percent for a well balanced line.

What is the difference between takt time and cycle time here?

Takt time is the demand rate, available production time divided by units required, so it sets how fast each station must finish to hit the customer pull. Cycle time is the actual measured time a station takes. Enter takt as your target and cycle time as measured. Any station whose cycle time exceeds takt cannot keep up and becomes the constraint. Idle time per station is takt minus that station's cycle time.

How many cycles should I time per station before entering a value?

Time 20 to 30 consecutive cycles per station to smooth out operator variation and micro stoppages. Discard the fastest and slowest readings, then enter the median rather than the average so one fumbled cycle does not distort the number. For high variation manual operations, push to 30 or more cycles. Consistent low variation stations can be captured reliably in 10 to 15 timed cycles.

Which station is the bottleneck and how do I fix it?

The bottleneck is the station with the longest cycle time, since it sets the pace of the whole line regardless of how fast others run. The summary flags it as bottleneck cycle time. Rebalance by moving 3 to 10 seconds of work content to an adjacent under loaded station, splitting the operation, or adding a parallel station. Each shift raises efficiency and lowers balance delay until stations sit near takt.

What line balance efficiency should I target?

Aim for 85 to 95 percent on a manual assembly line. Below 80 percent means significant idle time and usually one or two stations far above the rest. Reaching 100 percent is unrealistic because work content rarely divides evenly across whole stations. If you are stuck near 75 percent, the fix is often reducing station count or splitting the single dominant operation rather than trimming seconds everywhere.

How do I rebalance after a takt time change?

When demand rises, takt drops, so recompute takt as available time divided by the new unit target and enter it. Every station above the new takt is now overloaded. Redistribute work content, and if the bottleneck still exceeds takt after balancing, you need an added station or a faster method. Log the before and after efficiency in the shift log so you can prove the rebalance held across shifts.

Production and Throughput

Line Balance Spreadsheet Template

Map cycle times across all workstations and calculate line balance efficiency to find bottlenecks and idle time.

Overview

This template helps production engineers, line supervisors, and industrial engineers map cycle time at every workstation against takt time so a mixed line runs to a single beat. It is for anyone setting up or rebalancing an assembly or conveyor line. Doing this by eye hides the real bottleneck. A spreadsheet forces you to record actual cycle times per station and compare them to demand, which is where 5 or 10 seconds of hidden idle time per unit shows up.

You list up to 10 stations with operator and operation, then enter measured cycle time in seconds and your takt time. The sheet feeds a summary that sums total work content, flags the bottleneck cycle time, and computes line efficiency as total work content divided by bottleneck time times station count. Idle time per station is takt minus that station's cycle time. Balance delay is simply 100 percent minus efficiency, so every second you shift between stations moves both numbers.

In a real rebalance, measure 20 to 30 cycles per station, drop outliers, and enter the median. Any station above 100 percent of takt is your constraint, so move work content off it until efficiency climbs toward 85 to 95 percent. Log each attempt in the shift log to track efficiency over time. Pair it with the live Line Balance Calculator to test a rebalance instantly before you commit floor space or retrain operators.

What this template includes

Workstation list with operation descriptions
Cycle time per station
Takt time target
Station loading percentage
Bottleneck identification
Line balance efficiency calculation
Idle time per station

Suggested use case

Use this when setting up a new line, after a product engineering change, or when rebalancing after a takt time shift.

How to use it

List each workstation and its assigned operations.
Enter cycle time per station.
Enter takt time from the takt time calculation.
Review station loading to find stations over 100% of takt.
Rebalance work content across stations to reduce the gap.

Frequently Asked Questions

How do I calculate line balance efficiency in this template?: Line efficiency equals total work content divided by the bottleneck cycle time times the number of stations, expressed as a percent. If five stations total 200 seconds of work content and the slowest station runs 48 seconds, efficiency is 200 / (48 x 5) = 83.3 percent. Balance delay is the remainder, 16.7 percent, which represents idle time spread across the line. Target 85 to 95 percent for a well balanced line.
What is the difference between takt time and cycle time here?: Takt time is the demand rate, available production time divided by units required, so it sets how fast each station must finish to hit the customer pull. Cycle time is the actual measured time a station takes. Enter takt as your target and cycle time as measured. Any station whose cycle time exceeds takt cannot keep up and becomes the constraint. Idle time per station is takt minus that station's cycle time.
How many cycles should I time per station before entering a value?: Time 20 to 30 consecutive cycles per station to smooth out operator variation and micro stoppages. Discard the fastest and slowest readings, then enter the median rather than the average so one fumbled cycle does not distort the number. For high variation manual operations, push to 30 or more cycles. Consistent low variation stations can be captured reliably in 10 to 15 timed cycles.
Which station is the bottleneck and how do I fix it?: The bottleneck is the station with the longest cycle time, since it sets the pace of the whole line regardless of how fast others run. The summary flags it as bottleneck cycle time. Rebalance by moving 3 to 10 seconds of work content to an adjacent under loaded station, splitting the operation, or adding a parallel station. Each shift raises efficiency and lowers balance delay until stations sit near takt.
What line balance efficiency should I target?: Aim for 85 to 95 percent on a manual assembly line. Below 80 percent means significant idle time and usually one or two stations far above the rest. Reaching 100 percent is unrealistic because work content rarely divides evenly across whole stations. If you are stuck near 75 percent, the fix is often reducing station count or splitting the single dominant operation rather than trimming seconds everywhere.
How do I rebalance after a takt time change?: When demand rises, takt drops, so recompute takt as available time divided by the new unit target and enter it. Every station above the new takt is now overloaded. Redistribute work content, and if the bottleneck still exceeds takt after balancing, you need an added station or a faster method. Log the before and after efficiency in the shift log so you can prove the rebalance held across shifts.