Column 2 should be the processing times to be inputted by the user, and column 3 the due dates also inputted by the user. Column 4

should be the tardiness and column 5 the flow time. Develop the logic to compute the mean flow time, the average tardiness, and the number of tardy jobs. (When computing the average of a column, be sure that your spreadsheet does not treat blanks as zeros.)

a. Use your template to find the mean flow time, average tardiness, and number of tardy jobs for Problem 7 (Section 8.6), assuming FCFS sequencing.

b. Find the mean flow time, average tardiness, and number of tardy jobs for Problem 8, assuming FCFS sequencing.

c. Find the mean flow time, average tardiness, and number of tardy jobs assuming FCFS sequencing for the following 20-job problem:

Job Processing Time D ue Date Job Processing Time D ue Date 1 10 34 11 17 140 2 24 38 12 8 120 3 16 60 13 23 110 4 8 52 14 25 160 5 14 25 15 40 180 6 19 95 16 19 140 7 26 92 17 6 130 8 24 61 18 23 190 9 4 42 19 25 220 10 12 170 20 14 110