A bank's mortgage department must process the following six jobs to maximize client satisfaction.MortgageProcessing Time (days)Due Date117502131932477412245183062359What sequencing rule should you use? For the rule you selected, find the best sequence using the Excel Sequencing template.The most appropriate sequence rule is .The best sequence is - - - **Mortgage Processing Task Overview**The bank’s mortgage department needs to process six jobs to maximize client satisfaction. Below is a table detailing each mortgage, the associated processing time in days, and the due date for each job.| Mortgage | Processing Time (days) | Due Date ||----------|-----------------------|----------|| 1 | 17 | 50 || 2 | 13 | 19 || 3 | 24 | 77 || 4 | 12 | 24 || 5 | 18 | 30 || 6 | 23 | 59 |**Task: Determining the Optimal Sequence**You are tasked with selecting the most appropriate sequencing rule to process these jobs. After selecting the rule, use it to determine the best sequence using the Excel Sequencing template provided.- The most appropriate sequence rule is [Dropdown Menu for Selection].- The best sequence is [Dropdown Menu for Selection] - [Dropdown Menu for Selection] - [Dropdown Menu for Selection] - [Dropdown Menu for Selection] - [Dropdown Menu for Selection] - [Dropdown Menu for Selection].Consider factors such as processing time, due dates, and prioritization rules when determining the sequence to enhance client satisfaction.

Kindly find the detailed solution is Step 2. SPT PROCESSING TIME COMPLETED TIME DUE DATE 4 12 12 24 2 13 25 19 1 17 42 50 5 18 60 30 6 23 83 59 3 24 107 77 AVERAGE COMPLETE TIME 54.8333 Days The most appropriate rule is : Shortest Sequencing Time The best sequence will be : 4,2,1,5,6,3