ity #1: Sequencing Video Excel Online Activity: Sequencing The data for five tax analysis jobs waiting to be processed by Martha at T. R. Accounting Service has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. Open spreadsheet Questions 1. Use the shortest-processing-time (SPT) sequencing rules to sequence the jobs. Compute the flow time, tardiness, and lateness for each job, and t average flow time, average tardiness, and average lateness for all jobs. Use minus sign to enter negative lateness values, if any, Round the average values to two decimal places. Sequence Job Processing Time Due Date Flow Time Lateness Tardiness 1 2 3 4 5 Average 2. Use the earliest-due-date (EDD) sequencing rules to sequence the jobs. Compute the flow time, tardiness, and lateness for each job, and the average Now time, average tardiness, and average lateness for all jobs. Use minus sign to enter negative lateness values, if any. Round the average values to tw decimal place Sequence Job Processing Time Due Date Flow Time Lateness Tardiness Ariel 10 B A General D E Sequencing (SPT) Number of Jobs 6 Formulas Prosong Time Job 1 2 Processing Time Due Date Pow Time Les Tardiness Due Date 11 19 5 Due Date NA 4 SA Processing Time ANIA UNA NA IN ANCA howtime NA NA NA NA NA 4 NA ANA NA 2 6 16 1 Average 4 Bequencing (ED) Number of doo 500 Processing Time Se job Duer 11 16 Procong Time Due Date Time Line Prome ANA NA NA ANA WO Due Date RA ANA WA NA NA Powe NA ANA NA NA 2 3 5 16 5 ERROR Average 2. Use the earliest-due-date (EDD) sequencing rules to sequence the jobs. Compute the flow time, tardiness, and lateness for each fob, and the average flow time, average tardiness, and average lateness for all jobs. Use minus sign to enter negative lateness values, if any, Round the average values to two decimal places Sequence Processing Time Due Date Tardiness Job Flow Time Lateness 1 2 3 4 5 Average YR 7 Fing Arial FS B H 1 H N Sending (PT) Number of Jobs Formula Prooving Time Sequo Prang Time De Talents in CA Jhb 1 2 11 4 Due Date 11 10 5 6 1 LA 2 6 PUA ENIA Average Bequencing (D Heuer - Proming Time 4 Due Date 11 10 5 NIR 4 5 50 A ARRERA