Requirements Planning > Reports > Average Queue Times

Average Queue Times

You use this program to generate a report indicating suggested work center queue times and highlighting potential bottleneck work centers.

Report Options

Field Description
Print options  
Include suggested jobs Select this to include operations for suggested jobs.
Print standard deviation Select this to print the standard deviation for the queue time. The standard deviation is a measure of the dispersion of data or of a variable.
[Note]

Printing the standard deviation will slow the program down because of the processing required.

Selection criteria

Field Description
Work center selection Indicate the work center(s) for which to generate the report.
Queue date selection Indicate the queue date(s) for which to generate the report.

Output Options

These options enable you to apply a theme to the report and to define multiple output destinations for the report once it has been compiled (SRS Output Options).

Report Details

The program reads through the snapshot operations for jobs (suggested and existing). Any non-started operation, for a range of work centers and queue dates, are output to the temporary file as follows:

  • A temporary record is created for the work center (if one does not already exist).

  • The number of days from the expected queue date to the expected start date of the operation is counted, (excluding non-working days).

  • The day count is updated with the number of queue days and the operation count is incremented by one.

  • If the number of queue days is greater than the maximum held on the record, this figure is used as the maximum for the work center.

    If the number of queue days is less than the minimum held on record, this figure is used as the minimum for the work center.

Calculating the Standard Deviation

  1. For each work center, add the number of queue days for each operation and divide by the number of operations to obtain the average number of queue days.

  2. Find the difference between the average and actual operation queue days for each operation.

  3. Square each difference.

  4. Sum the squared differences.

  5. Find the average squared difference (i.e. variance).

  6. Find the square root of the result.