Please use excel and show the formulas you used in order to reach your final answer.

6. Big Dan's Machine Shop is considering the use of a priority scheduling rule in the fabrication shop and must decide whether to use: (1) critical ratio (CR); (2) earliest due date (EDD), (3) shortest operation next (SON), or (4) order slack. The current shop status of the company is given here: Time Remaining until Due Date 12 15 14 18 19 Current Operation Total Remaining Manufacturing Time 15 12 10 15 20 Order Number Processing Time 8 4 4 a. Using the four sequencing rules, compute the scheduling priority for each order given in the table above. b. What order should be run first under each of these scheduling rules