# Fab Step Cycle Time and X-Factor Worksheet

> Source: https://netray.co/tools/fab-step-cycle-time-and-x-factor-worksheet
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

An editable route worksheet that adds queue, process and move time per step, calculates X-factor and flags the steps where lots wait longest.

## Category

mes-shop-floor

## Industry

Semiconductors

## Audience

- Industrial engineer
- Fab planner
- Manufacturing manager

## Tool

**Kind:** worksheet

**Mode:** editable

**Columns:**

#### Step

**Key:** step

**Type:** text

#### Area

**Key:** area

**Type:** select

**Options:**

- Lithography
- Etch
- Thin films
- Diffusion
- Implant
- CMP
- Wet clean
- Metrology

#### Queue time

**Key:** queue_h

**Type:** number

**Unit:** h

**Format:** hours

#### Process time

**Key:** process_h

**Type:** number

**Unit:** h

**Format:** hours

#### Move / wait for transport

**Key:** move_h

**Type:** number

**Unit:** h

**Format:** hours

#### Step cycle time

**Key:** total_h

**Type:** number

**Expr:** queue_h + process_h + move_h

**Format:** hours

#### X-factor

**Key:** xf

**Type:** number

**Expr:** total_h / process_h

**Format:** decimal

#### Waiting share

**Key:** wait_share

**Type:** number

**Expr:** (queue_h + move_h) / total_h * 100

**Format:** percent

**Rows:**

#### Pre-clean

**Area:** Wet clean

**Queue h:** 1.5

**Process h:** 0.8

**Move h:** 0.3

#### Oxidation

**Area:** Diffusion

**Queue h:** 6

**Process h:** 3.5

**Move h:** 0.4

#### Photo coat/expose/develop

**Area:** Lithography

**Queue h:** 5.2

**Process h:** 1.2

**Move h:** 0.3

#### Poly etch

**Area:** Etch

**Queue h:** 3.1

**Process h:** 0.9

**Move h:** 0.3

#### CD measurement

**Area:** Metrology

**Queue h:** 1.2

**Process h:** 0.4

**Move h:** 0.2

#### Implant

**Area:** Implant

**Queue h:** 8.5

**Process h:** 1.1

**Move h:** 0.4

**Totals:**

#### Total queue time

**Key:** queue_h

**Agg:** sum

**Format:** hours

#### Total process time

**Key:** process_h

**Agg:** sum

**Format:** hours

#### Total cycle time

**Key:** total_h

**Agg:** sum

**Format:** hours

#### Worst step X-factor

**Key:** xf

**Agg:** max

**Format:** decimal

**Summary:**

#### Route X-factor

**Key:** route_xf

**Expr:** sum_total_h / sum_process_h

**Format:** decimal

**Primary:** true

**Description:** Total cycle time divided by total raw process time across the listed steps.

#### Route cycle time in days

**Key:** route_days

**Expr:** sum_total_h / 24

**Format:** days

#### Share of time spent waiting

**Key:** wait_pct

**Expr:** (sum_queue_h + sum_move_h) / sum_total_h * 100

**Format:** percent

**Notes:** Use data from your MES lot history: track-in minus previous track-out for queue, and track-out minus track-in for process (including batch dwell where relevant). Define raw process time consistently, for example without hold time, so X-factor compares properly across periods.

## Content

**Intro:** Cycle time drives fab output, inventory and customer delivery. This worksheet breaks a route into queue, process and move time per step so you can calculate X-factor and see where lots actually wait.

**Sections:**

#### How to use the worksheet

**Body:** List route steps in the order lots see them. For each step enter the average queue time, process time and move or transport wait from MES lot history over a recent window such as the past four weeks. The worksheet computes the total time per step, the X-factor and the share of time spent waiting. The summary reports route X-factor, route cycle time in days and the overall waiting percentage. Sort steps by X-factor in Excel to find the bottlenecks, and export the table for planning meetings.

**Bullets:**

- Use averages from the same time window
- Keep process time definition consistent
- Include batch steps with dwell
- Re-run weekly to track change

#### X-factor explained

**Body:** X-factor, also called flow factor, is cycle time divided by raw process time. An X-factor of 1 would mean lots never wait. In real fabs it is well above 1, and logic and specialty fabs often run in the range of two to several times raw time on average, with bottleneck steps far higher. It matters because queue time is where work in process sits, and by Little's law, WIP equals throughput times cycle time. Reducing the X-factor at constrained tools shortens delivery and cuts inventory without any capital spend.

#### Reading the results

**Body:** Look for steps where the waiting share is highest, not just the longest steps. A high X-factor on a short step like implant usually means a constrained tool with insufficient capacity or poor dispatching. High waiting shares at metrology steps point to sampling plans or too few tools. If many steps show a moderate wait but one area dominates total time, focus on batch formation rules, preventive maintenance scheduling and lot priority. Compare against the planned cycle time in your ERP to see where reality departs from the plan.

#### Common mistakes

**Body:** Averages hide variability, so also check the 90th percentile of queue time where you have data. Another mistake is including hold time in queue time, which mixes engineering decisions with capacity waiting. Steps with rework loops should count the extra passes. Do not compare X-factor between products with different process time definitions. Finally, remember hot lots, which move faster at the cost of everyone else, and keep their data separate when measuring standard cycle time.

**Cta:** If your cycle times live in MES and your planning parameters in ERP, Netray can help you compare plan and actual by asking questions in plain language, on your own servers.

**Faq:**

#### What is a good X-factor for a fab?

**Answer:** It varies widely by product mix and fab type. Leading-edge logic fabs often see overall X-factors well above two, while specialty and mature-node fabs differ. Track your own trend and compare bottleneck steps rather than chasing an industry number.

#### Is queue time the same as WIP?

**Answer:** No. WIP counts the lots or wafers in the line. Queue time is how long each lot waits before processing. They are linked through Little's law, since average WIP equals throughput times average cycle time.

#### How do I handle batch tools like furnaces?

**Answer:** Count the wait to form the batch as queue time and the full recipe duration as process time. Batch formation rules often cause hidden waiting, so review how long lots sit waiting for a full load.

#### Can I use it for assembly and test flows?

**Answer:** Yes. Replace area values with die attach, wire bond, mold, singulation and test, and use hours or minutes consistently. The X-factor logic is the same for any routed manufacturing flow.

## Search terms

fab cycle time worksheet, x-factor cycle time semiconductor, wafer fab queue time analysis, cycle time by step excel, wip cycle time template, queue time per operation worksheet, semiconductor flow factor, route cycle time breakdown

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