16-6

please show work

Problem 16-6 (Static) The following table contains information concerning four jobs that are awaiting processing at a work center Job B C D Job Time (days) 14 10 7 6 Due Date (days) 20 16 15 17 Click here for the Excel Data File a. Sequence the jobs using (1) FCFS, (2) SPT, (3) EDD, and (4) CR. Assume the list is by order of arrival. Sequence for First come first served Sequence for Shortest processing time Sequence for Earliest due date Sequence for Critical ratio b. For each of the methods in part a, determine (1) the average job flow time, (2) the average tardiness, and (3) the average number of jobs at the work center. (Round your intermediate calculations and final answers to 2 decimal places.) First Come, First Served Shortest Processing Time Earliest Due Date Critical Ratio Average job flow time Average tardiness Average number of jobs c. Which method is superior to the others? O First come, first served O Shortest processing time Earliest due date O Critical ratio O None are superior