# SMT Line Balancing Worksheet: Find the Bottleneck Station

> Source: https://netray.co/tools/smt-line-balancing-worksheet
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

List each SMT line station with its cycle time and see the bottleneck, line UPH and balance efficiency.

## Category

mes-shop-floor

## Industry

Electronics Manufacturing

## Audience

- SMT engineer
- Industrial engineer
- Production supervisor

## Tool

**Kind:** worksheet

**Mode:** editable

**Columns:**

#### Seq

**Key:** seq

**Type:** number

#### Station

**Key:** station

**Type:** text

#### Type

**Key:** kind

**Type:** select

**Options:**

- Print
- Inspect
- Place
- Reflow
- Test
- Handling

#### Cycle time (s)

**Key:** ct

**Type:** number

**Unit:** s

**Help:** Seconds per board or per array.

#### Station UPH

**Key:** uph

**Type:** number

**Expr:** 3600 / max(ct, 0.1)

**Format:** integer

**Help:** Boards per hour this station could deliver alone.

#### Boards per cycle

**Key:** boards

**Type:** number

**Help:** Boards in an array or carrier.

**Rows:**

**Seq:** 1

**Station:** Stencil printer

**Kind:** Print

**Ct:** 24

**Boards:** 1

**Seq:** 2

**Station:** SPI

**Kind:** Inspect

**Ct:** 20

**Boards:** 1

**Seq:** 3

**Station:** Chip shooter

**Kind:** Place

**Ct:** 31

**Boards:** 1

**Seq:** 4

**Station:** Multi-function placer

**Kind:** Place

**Ct:** 38

**Boards:** 1

**Seq:** 5

**Station:** Reflow oven

**Kind:** Reflow

**Ct:** 27

**Boards:** 1

**Seq:** 6

**Station:** AOI

**Kind:** Inspect

**Ct:** 29

**Boards:** 1

**Totals:**

#### Total station cycle time

**Key:** ct

**Agg:** sum

**Format:** number

#### Fastest station UPH

**Key:** uph

**Agg:** max

**Format:** integer

**Summary:**

#### Line cycle time (bottleneck)

**Key:** line_ct

**Expr:** max_ct

**Format:** decimal

**Primary:** true

**Description:** In seconds, set by the slowest station.

#### Line UPH

**Key:** line_uph

**Expr:** 3600 / max(max_ct, 0.1)

**Format:** decimal

**Primary:** true

#### Balance efficiency

**Key:** bal_eff

**Expr:** avg_ct / max(max_ct, 0.1) * 100

**Format:** percent

**Description:** Average station time divided by bottleneck time.

#### Balance loss

**Key:** bal_loss

**Expr:** 100 - bal_eff

**Format:** percent

#### Slack at fastest station

**Key:** slack

**Expr:** max_ct - min_ct

**Format:** decimal

**Description:** In seconds per board.

**Notes:** Station UPH is a stand-alone figure. The line runs at the bottleneck's rate. If a station processes a multi-board array, enter its cycle time per array and divide by boards per cycle to compare per board.

## Content

**Intro:** An SMT line is a chain, and the slowest link sets the speed. This worksheet lists every station with its cycle time and shows the bottleneck, line UPH and how balanced the line is.

**Sections:**

#### How to use it

**Body:** Add one row per station in process order. Use measured cycle times from the machine logs or a stopwatch study, not nameplate values. Enter the station type so you can filter or sort. The station UPH is calculated for each row and the summary shows the line cycle time, line UPH, balance efficiency and slack. Edit values to simulate moving components between placement machines and see the effect.

**Bullets:**

- Measure over at least 20 consecutive cycles
- Convert array cycle time to per-board time before comparing
- Record the product and program version the times belong to

#### The metrics

**Body:** Line cycle time equals the longest station cycle time. Line UPH is 3600 divided by that. Balance efficiency is the average station time divided by the maximum, so a perfectly balanced line scores 100 percent. Balance loss is the remainder. A low score means stations are idle waiting for the bottleneck, which is often the best place to shift work, for example moving parts from a slow placer to the chip shooter.

#### Common mistakes

**Body:** Do not confuse machine rated speed with achieved cycle time, which includes board transfer, vision and nozzle changes. Reflow conveyor pitch limits throughput and is easy to forget. Dual-lane machines and buffer conveyors change the effective cycle, so model them carefully. Finally, a balanced line that is still slow means the whole line needs more capacity, not more balancing. Use the placement rate calculator to size machine counts.

**Cta:** Netray can collect station cycle times from your MES or machine logs and surface bottleneck trends against ERP work orders.

**Faq:**

#### What is line balancing in SMT?

**Answer:** It means distributing work across machines so cycle times are as even as possible, reducing idle time at faster stations. In SMT this usually means reassigning component placements between machines to equalize each machine's program time.

#### How do I find the bottleneck station?

**Answer:** It is the station with the longest cycle time per board. In this worksheet it is the row with the highest cycle time, and the summary reports it as the line cycle time.

#### What is a good balance efficiency?

**Answer:** Above 85 to 90 percent is generally considered well balanced for a placement section, though printers, ovens and inspection machines rarely match placement time exactly. Use the number as a trend, not a single target.

#### How does array size affect cycle time?

**Answer:** Arrays raise the per-cycle time but spread the transfer and fiducial overhead over several boards. Enter the cycle time for the whole array and compare stations on a per-board basis to find the real constraint.

## Search terms

smt line balancing, smt line balancing worksheet, line balancing excel template, smt bottleneck analysis, smt line cycle time per station, pcba line efficiency, balance efficiency formula, smt line uph calculation

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