Chapter 9, Problem 4

Please provide step by step directions in excel format as pictured below

4. Requests for solutions to billing-related IT problems have been received. Six of those jobs were assigned to Joel Williams, one of the support specialists. Joel has latitude in deciding the order in evaluated in terms of turnaround times or flow times. All posate which these requests will be processed, but his performance is equally important. Help Joel find the sequence that will minimize flow time based on the following data. Try the following rules. FCFS, SPT, EDD, and CR. Requests will start being processed after the last one's arrival, that is, 65 minutes. Request Arrival Time (min) 15 Due Date Processing Time (min) 100 150 60 B 20 200 300 150 30 D 40 120 250 E 55 30 400 F 65 90 350 D E F G H B M3-07 (Chapter 9, Problem 4) FCFS Job Sequence Start Due Date End Flow time Processing Time (min) 100 B 150 Arrival Time (min) 15 20 30 40 55 65 60 200 300 150 250 400 350 D 120 30 E F 90 Total SPT Job Sequence Arrival Time (min) Start Processing Time (min) Due Date End Flow time Total CNN Clipboard Font Alignment Number 1 B D F G H EDD Job Sequence Arrival Time (min) Start Processing Time (min) Due Date End Flow time Total CR Time now Job Sequence Due Date CR A B Processing Time (min) 100 150 60 120 30 90 200 300 150 250 400 350 D E F 42 43 44 Job Assigned Time now Job Sequence Processing Time (min) Due Date CR 45 46 47 48 49 50 51 52 53 Job Assigned Time now Job Sequence Processing Time (min) Due Date CR 54 55 56 57 58 59 60 61 Job Assigned Time now ob Sequence Processing Time (min) 62 Due Date CR 63 64 65 66 66 67 68 Job Assigned Time now Processing Time (min) Job Sequence Due Date CR 69 70 71 72 73 74 75 Job Assigned Time now 76 Final Order for CR Arrival Time Job Sequence (min) Start Processing Time (min) Due Date End Flow time 77 78 79 80 81 82 83 84 85 86 87 88 89 90 Total Decision: 4. Requests for solutions to billing-related IT problems have been received. Six of those jobs were assigned to Joel Williams, one of the support specialists. Joel has latitude in deciding the order in evaluated in terms of turnaround times or flow times. All posate which these requests will be processed, but his performance is equally important. Help Joel find the sequence that will minimize flow time based on the following data. Try the following rules. FCFS, SPT, EDD, and CR. Requests will start being processed after the last one's arrival, that is, 65 minutes. Request Arrival Time (min) 15 Due Date Processing Time (min) 100 150 60 B 20 200 300 150 30 D 40 120 250 E 55 30 400 F 65 90 350 D E F G H B M3-07 (Chapter 9, Problem 4) FCFS Job Sequence Start Due Date End Flow time Processing Time (min) 100 B 150 Arrival Time (min) 15 20 30 40 55 65 60 200 300 150 250 400 350 D 120 30 E F 90 Total SPT Job Sequence Arrival Time (min) Start Processing Time (min) Due Date End Flow time Total CNN Clipboard Font Alignment Number 1 B D F G H EDD Job Sequence Arrival Time (min) Start Processing Time (min) Due Date End Flow time Total CR Time now Job Sequence Due Date CR A B Processing Time (min) 100 150 60 120 30 90 200 300 150 250 400 350 D E F 42 43 44 Job Assigned Time now Job Sequence Processing Time (min) Due Date CR 45 46 47 48 49 50 51 52 53 Job Assigned Time now Job Sequence Processing Time (min) Due Date CR 54 55 56 57 58 59 60 61 Job Assigned Time now ob Sequence Processing Time (min) 62 Due Date CR 63 64 65 66 66 67 68 Job Assigned Time now Processing Time (min) Job Sequence Due Date CR 69 70 71 72 73 74 75 Job Assigned Time now 76 Final Order for CR Arrival Time Job Sequence (min) Start Processing Time (min) Due Date End Flow time 77 78 79 80 81 82 83 84 85 86 87 88 89 90 Total Decision