MES & Shop FloorFree worksheetPDF, Excel, Word exportSemiconductors

Fab Step Cycle Time and X-Factor Worksheet

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.

Download:
StepAreaQueue time (h)Process time (h)Move / wait for transport (h)Step cycle timeX-factorWaiting share
3 hrs
3.25
69.2%
10 hrs
2.8286
64.6%
7 hrs
5.5833
82.1%
4 hrs
4.7778
79.1%
2 hrs
4.5
77.8%
10 hrs
9.0909
89%
Total queue time
26 hrs
Total process time
8 hrs
Total cycle time
35 hrs
Worst step X-factor
9.0909
Route X-factor
4.4684
Total cycle time divided by total raw process time across the listed steps.
Route cycle time in days
1 days
Share of time spent waiting
77.6%

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.

Compare MES cycle times to ERP lead times

Optional: discuss reconciling planned and actual cycle time across systems.

Optional. The tool and every export work without this. No spam.

How to use the worksheet

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.

  • 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

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

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

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.

Frequently Asked Questions

What is a good X-factor for a fab?

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?

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?

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?

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.

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.

Talk to an ExpertExplore More Free Tools

Related Tools

Quality & Inspection

Wafer Probe Bin Yield Log Worksheet

An editable wafer sort log that totals bin counts per wafer and calculates probe yield and loss percentages, ready for Excel.

Quality & Inspection

Semiconductor Lot Hold and Release Form Template

A fill-in lot hold and release record for wafer fabs and assembly and test houses, covering hold reason, affected wafers, disposition and sign-off.

Quality & Inspection

Cleanroom Particle Count Log Worksheet

Editable log that converts raw particle counts and sample volume to particles per cubic meter and flags results over your limit.

Quality & Inspection

Rolled Throughput Yield Calculator

Multiply first pass yield across process steps to find true rolled throughput yield and the units that never pass first time.

More MES & Shop Floor tools

See all
Back to All Tools