I really need help with this question, if you could please upload the formulas you used on excel with a screenshot or a picture. thank you for your help

Q 1 Scheduling The following table contains information concerning four jobs that are waiting for processing at a machine. a) Sequnce the jobs using priority rules 1) SPT, 2) EDD 3) CR 4) MST b) For each of the priority rules in part a) determine the average flow time, and the average days late. Is one priority rule superior to the others? Explain . You must use formulas for all of your calculations. Job Time Due Date A 12 19 B 5 14 Note that Completion time is the same as Flow time! C 15 7 3 D 8 E 7 20 22 23 SPT EDD Job Proc Time Comp Time Due Date Days Late Job Comp Proc Time Time Due Date Days Late 24 25 26 27 28 29 30 31 32 33 34 CR MST Job Proc Time Comp Time Due Date Days Late Job Comp Proc Time Time Due Date Days Late 35 36 37 38 39 40 41 42 43 Aver Flow Time Aver Days Late 44 45 SPT 46 EDD 47 CR 48 MST 49