Eight jobs have arrived in the following order:JobProcessing TimeDue Date1723239358421156166918714408431 Find and compare the performance measures for the following sequencing rules using the Excel Sequencing template. Round your answers to two decimal places.Process in the order they have arrived Flow TimeLatenessTardinessAverage # Job Sequencing and Performance Measures### IntroductionIn this exercise, we will explore how to determine performance measures for different sequencing rules using the Excel Sequencing template. We will focus on three key sequencing strategies: processing in order of arrival, shortest processing time, and earliest due date. Please round your answers to two decimal places.### Job DetailsThe table below lists eight jobs, along with their processing times and due dates:| Job | Processing Time | Due Date ||-----|-----------------|----------|| 1 | 7 | 23 || 2 | 3 | 9 || 3 | 5 | 8 || 4 | 2 | 11 || 5 | 6 | 16 || 6 | 9 | 18 || 7 | 14 | 40 || 8 | 4 | 31 |### Sequencing Strategies#### a. Process in the Order of Arrival- Measure and compare Flow Time, Lateness, and Tardiness.- Calculate the average for each performance measure.**Inputs:**- Flow Time: ______- Lateness: ______- Tardiness: ______#### b. Shortest Processing Time (SPT)- Arrange the jobs in order based on the shortest processing time.- The SPT sequence is: [Select appropriate sequence from options].**Inputs:**- Flow Time: ______- Lateness: ______- Tardiness: ______#### c. Earliest Due Date (EDD)- Arrange the jobs in order based on the earliest due date.- The EDD sequence is: [Select appropriate sequence from options].**Inputs:**- Flow Time: ______- Lateness: ______- Tardiness: ______### Conclusions- Identify which sequence strategy results in the smallest average flow time.- Identify which sequence strategy results in the smallest average lateness.- Identify which sequence strategy results in the smallest average tardiness.**Select the appropriate sequencing strategies with the smallest averages for each performance measure:**- The [Select] has the smallest average flow time.- The [Select] has the smallest average lateness.- The [Select] has the smallest average tardiness.Use these strategies to optimize job sequencing and improve performance outcomes in various operational settings.

Scheduling is the process of arranging production activities in order to complete the manufacturing process. Project sequencing defines the starting ending and the duration of each activity in the process. Activities are arranged in a set sequence. This process helps achieve the production targets with the best decision, the least time, the lowest cost, and the best use of resources. Scheduling helps in reducing the waiting time in the production cycle.a) Formulas:- Outcome:- b) Formulas:- Outcome:- c) Formulas:- Outcome:- The Shortest processing time has the smallest average flow time. All methods have the smallest average flow time. The earliest due date has the smallest average tardiness.