apter $15$ Excel Activity: Sequencing

Stion $1$

Use the shortest$-$processing$-$time $($SPT$)$ sequencing rules to sequence the jobs. Compute the flow time, tardiness, and lateness for each job, and the average flow time, average tardiness, and average lateness for all jobs. Use minus sign to enter negative lateness values, if any. If your answer is zero, enter $"0".$ Round the average values to two decimal places.

$\backslash$table$[[$Sequence Job,Processing Time,Due Date,Flow Time,Lateness$],[1,,,,],[2,,,,],[3,,,,],[4,,,,],[5,,,,],[,,,,],[,,,,]]$

Use the earliest$-$due$-$date $($EDD$)$ sequencing rules to sequence the jobs. Compute the flow time, tardiness, and lateness for each job, and the average flow time, average tardiness, and average lateness for all jobs. Use minus sign to enter negative lateness values, if any. If your answer is zero, enter $"0".$ Round the average values to two decimal places.

$\backslash$table$[[$Sequence$,$Job,Processing Time,Due Date,Flow Time,Lateness,Tardiness$],[1,,,,,,],[2,,,,,,],[3,,,,,,],[4,,,,,,],[5,,,,,,]]$