# Yamazumi Line Balancing Worksheet

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

## Short answer

Record station times by value-add, necessary and waste, compare each to takt time and see how balanced the line is.

## Category

manufacturing

## Audience

- Industrial engineer
- Lean practitioner
- Production manager

## Tool

**Kind:** worksheet

**Mode:** editable

**Columns:**

#### Station

**Key:** station

**Type:** text

#### Operator or role

**Key:** operator

**Type:** text

#### Value-add

**Key:** va_s

**Type:** number

**Unit:** s

#### Necessary non-value-add

**Key:** nnva_s

**Type:** number

**Unit:** s

#### Waste

**Key:** waste_s

**Type:** number

**Unit:** s

#### Total cycle

**Key:** total_s

**Type:** number

**Expr:** va_s + nnva_s + waste_s

**Format:** number

**Unit:** s

#### Takt time

**Key:** takt_s

**Type:** number

**Unit:** s

#### Load vs takt

**Key:** load_pct

**Type:** number

**Expr:** total_s / takt_s * 100

**Format:** percent

#### Spare time to takt

**Key:** gap_s

**Type:** number

**Expr:** takt_s - total_s

**Format:** number

**Unit:** s

**Rows:**

**Station:** 10 Kit and stage

**Operator:** Material handler

**Va s:** 22

**Nnva s:** 18

**Waste s:** 6

**Takt s:** 60

**Station:** 20 Sub-assembly

**Operator:** Assembler 1

**Va s:** 41

**Nnva s:** 9

**Waste s:** 8

**Takt s:** 60

**Station:** 30 Fastening

**Operator:** Assembler 2

**Va s:** 38

**Nnva s:** 12

**Waste s:** 15

**Takt s:** 60

**Station:** 40 Test

**Operator:** Tester

**Va s:** 30

**Nnva s:** 14

**Waste s:** 4

**Takt s:** 60

**Station:** 50 Pack and label

**Operator:** Packer

**Va s:** 20

**Nnva s:** 16

**Waste s:** 5

**Takt s:** 60

**Totals:**

#### Total value-add

**Key:** va_s

**Agg:** sum

**Format:** number

#### Total necessary NVA

**Key:** nnva_s

**Agg:** sum

**Format:** number

#### Total waste

**Key:** waste_s

**Agg:** sum

**Format:** number

#### Total work content

**Key:** total_s

**Agg:** sum

**Format:** number

**Summary:**

#### Line balance efficiency

**Key:** balance_eff

**Expr:** sum_total_s / (count * max_total_s) * 100

**Format:** percent

**Primary:** true

**Description:** Total work content divided by stations times the slowest station.

#### Waste share of work content

**Key:** waste_share

**Expr:** sum_waste_s / sum_total_s * 100

**Format:** percent

#### Theoretical minimum stations at takt

**Key:** min_ops

**Expr:** ceil(sum_total_s / avg_takt_s)

**Format:** integer

**Notes:** Time each station over several cycles and use the repeatable value. Takt time is the same for every station on a single line; keep the column to allow different products.

## Content

**Intro:** A Yamazumi chart stacks each operator's time into value-add, necessary non-value-add and waste, then compares the stack to takt. This worksheet gives you the data table and the balance numbers, ready to paste into a stacked bar chart.

**Sections:**

#### How to use the worksheet

**Body:** Observe each station for at least ten cycles with a stopwatch. For every element classify the seconds as value-add (the customer would pay for it), necessary non-value-add (walking to get a part, scanning, a required inspection) or waste (waiting, rework, searching). Enter the three numbers per station and the takt time. The sheet adds the total cycle, the load as a percentage of takt and the spare time. Any station above 100 percent will cause a bottleneck, and one far below takt is a candidate for absorbing work from its neighbors.

**Bullets:**

- Observe real work, not the standard on the routing
- Classify every second, even tiny walks
- Run the worksheet again after each rebalancing trial

#### Balance efficiency explained

**Body:** Balance efficiency is total work content divided by the number of stations times the longest station time. A perfectly balanced line scores 100 percent. The theoretical minimum number of stations is total work content divided by takt, rounded up. If you have more stations than that figure, you may be able to rebalance rather than add people. Removing waste first, then moving the necessary non-value-add work, is usually better than simply moving all elements around.

#### Common mistakes

**Body:** Do not average one slow and one fast cycle and call it the station time; use the repeatable, achievable time. Do not hide waste inside value-add to make the chart look better. Remember that takt comes from demand and available time, not from what the line can do today. Feed the new work content and station assignments back to your ERP routing only after the change has been validated for stability and quality.

**Cta:** Netray can pull routing times and actual labor reporting from your ERP so the Yamazumi baseline starts from data rather than a stopwatch alone.

**Faq:**

#### What does a Yamazumi chart show?

**Answer:** It is a stacked bar chart of each operator's or station's cycle time, split into value-add, necessary non-value-add and waste, with takt time drawn as a line. It shows who is over takt, who has spare time and how much of the work is waste.

#### How is it different from a line balance chart?

**Answer:** A basic line balance chart shows total time per station against takt. A Yamazumi adds the split by work type, so you can see whether a station is slow because of real work or because of waste that can be removed.

#### What takt time should I enter?

**Answer:** Use available production time per shift divided by customer demand per shift. Do not use the current cycle time of the line. If demand varies, balance for the planned rate and recheck when the rate changes.

#### Can I chart this in Excel?

**Answer:** Yes. Export the table to Excel, select the station, value-add, necessary and waste columns and insert a stacked column chart. Add takt as a line series for the usual Yamazumi view.

## Search terms

yamazumi chart excel, line balancing worksheet, yamazumi template, operator balance chart, cycle time vs takt worksheet, line balance efficiency, stacked cycle time chart, assembly line balancing excel

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