A foreman has determined processing times at a work center for a set of jobs and now wants to sequence them, Given the information shown, do the following Glick. here for the Exceldata File a-1. Determine the processing sequence using (1) First come, first served, (2) Shortest processing time, (3) Earliest due date, and (4) Critical ratio. Gick here for the Excel Data File a-1. Determine the processing sequence using (1) First come, first served, (2) Shortest processing time, (3) Earliest due date, and (4) Critical ratio. a-2. For each sequence, compute the average job tardiness, the average flow time, and the average number of jobs at the work center. The list is in First come, first served order. (Round your intermediate calculations and final answers to 2 decimal places.) b. Using the results of your caiculations in part a, show that the average flow time and the average number of jobs measures are equivalent for all four sequencing rules. (Hint. Calculate the ratio of average flow time and the average number of jobs for each rule) (Round your answer to 2 decimal places.) c. Determine the processing sequence that would result using the Slack per operation rule. A foreman has determined processing times at a work center for a set of jobs and now wants to sequence them, Given the information shown, do the following Glick. here for the Exceldata File a-1. Determine the processing sequence using (1) First come, first served, (2) Shortest processing time, (3) Earliest due date, and (4) Critical ratio. Gick here for the Excel Data File a-1. Determine the processing sequence using (1) First come, first served, (2) Shortest processing time, (3) Earliest due date, and (4) Critical ratio. a-2. For each sequence, compute the average job tardiness, the average flow time, and the average number of jobs at the work center. The list is in First come, first served order. (Round your intermediate calculations and final answers to 2 decimal places.) b. Using the results of your caiculations in part a, show that the average flow time and the average number of jobs measures are equivalent for all four sequencing rules. (Hint. Calculate the ratio of average flow time and the average number of jobs for each rule) (Round your answer to 2 decimal places.) c. Determine the processing sequence that would result using the Slack per operation rule