job	processing time	due date(Di)
1	27	37
2	30	38
3	29	40
4	20	30
5	19	43

An insurance claims work area has five claims waiting for processing as follows:

Use the Excel Sequencing template to find the average flowtime, average and maximum tardiness, and average lateness for the following sequences: SPT sequence, EDD sequence, and the sequence 2-1-4-3-5. Round your answers for the average values to two decimal places.

The SPT sequence is ____ - ____ - ____ - ____ - ____

Average Flow time ____

Average tardiness ____

Maximum tardiness ____

Average Lateness ____

The EDD sequence is ____ - ____ - ____ - ____ - ____

Average Flow time ____

Average tardiness ____

Maximum tardiness ____

Average Lateness ____

2-1-4-3-5 sequence

Average Flow time ____

Average tardiness ____

Maximum tardiness ____

Average Lateness ____

What sequencing rule do you recommend?

The -Select-(SPT, EDD or 2-1-4-3-5) is recommended as it minimizes average flow time and number of jobs in system.