FabTime Cycle Time Characteristic Curve Generator

The FabTime Cycle Time Characteristic Curve Generator is an Excel-based tool for exploring cycle time and utilization trade-offs for single tools with failures. You can enter parameters for process time, mean time between failures, downtime percentage, and system coefficients of variation for up to three scenarios. The calculator then displays characteristic curves for the scenarios, allowing you to get a quick visual impression of the impact of both downtime and variability attributes.

The curves are based on a queueing approximation that we first were shown several years ago by Ottmar Gihr of IBM Germany. The formula for system variation used in the spreadsheet was modified slightly on 11/12/01 to follow Equation 8.6 in the text Factory Physics, Second Edition, by W. J. Hopp and M. L. Spearman (with thanks to Mark Spearman for the suggestion!). The spreadsheet was modified again on 05/03/02 to allow coefficients of variation greater than 1. Please feel free to use this spreadsheet, and to pass it along to others — we only ask that you attribute the source, and maintain our copyright notice.

Download the spreadsheet. This will usually (depending on your system) open the Excel file from within your browser. You can then use the File > Save As command to save it to your computer. Alternatively, to save the file without opening it first, right-click on the link, and select Save Target As from the pop-up menu. The file is not password protected, however If you get a prompt for username and password, please email us for the file.