Y = 5, DO NOT use excel

6. The following table contains information concerning 5 jobs that are waiting processing at a work centre. Job time (days) Job Due date (days) 3 A 8 B 5 10 2 13 D y+10 20 E 10 16 (y is the second last numeric digit of your student ID number. For example, if your student ID number is 20012345S, then y=4, and y+10=14) a) Sequence the jobs using first-come, first-served (FCFS), shortest processing time (SPT) and earliest due date (EDD). Assume the list is by order of arrival. (2 marks) 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 centre. (3 marks) c) Which method is the least preferred in this case? Explain. (1 mark) d) Suggest two scheduling difficulties managers may face. How can managers overcome those difficulties? (2 marks)