X AutoSave Off Assignment7c (1) - Protected View v Search (Alt+Q) A Deric Jo Paul DJ X File Home Insert Page Layout Formulas Data Review View Automate Help Comments Share i PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing X L66 vixfx B C D E F G H I J K L M N O P Q R S T U V W Q1 Priority Rules UT The following table contains information concerning four jobs that are waiting for processing at a machine. a) Sequnce the jobs using priority rules 1) EDD, 2) SPT 3) MST 4) CR b) For each of the priority rules in part a) determine 10 the average flow time, average days late and average WIP. Is one priority rule 11 superior to the others? Explain . You must use formulas for all of your calculations. (12) Job Time Due Date 8 11 Note that Completion time is the same as Flow time! na D 15 10 21 16 22 23 24 25 EDD SPT Proc Comp Due Days Proc Comp Due Days Job Job 26 Time Time Date Late Time Time Date Late 27 Aver Flow: Aver Flow: 28 Aver Days Late: Aver Days Late: 29 Aver WIP Aver WIP 30 31 32 33 Sheet1 + Ready + 100% O P Rain coming 1 8 7 1) 0 ENG 7:27 PM Type here to search 2022-12-02Search (Alt+Q) A Deric Jo Paul DJ X X AutoSave Off Assignment7c (1) - Protected View v Comments Share File Home Insert Page Layout Formulas Data Review View Automate Help X i PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing L66 vix fx G H I K L M N O P Q R S T U V W A B C D E F 24 25 EDD SPT Proc Comp Due Days Proc Comp Due Days Job Job Time Time Date Late Time Time Date Late 26 Aver Flow: 27 Aver Flow: Aver Days Late: Aver Days Late: 28 Aver WIP Aver WIP 29 30 31 32 33 34 35 36 MST CR Proc Comp Due Days Proc Comp Due Days Job Job Time Time CR Date Late 37 Aver Flow: 38 Aver Flow: 39 Aver Days Late: Aver Days Late: Aver WIP 40 Aver WIP 41 42 43 44 45 Aver Flow Aver Days 46 Rule Time Late Aver WIP 47 48 49 50 51 Sheet1 + + 100% Ready 7:28 PM Type here to search O P X Rain coming ~ 9 74) 0 ENG 2022-12-02Assignment7c (1) - Protected View v Search (Alt+Q) A Deric Jo Paul DJ X X AutoSave Off Comments Share File Home Insert Page Layout Formulas Data Review View Automate Help X i PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing L66 VIX f F G H K L M N O P Q R S T U V W B C D E 52 Q 2 Johnson's Rule 53 54 Given the Operation times in the two-work centre flow shop below: 55 56 Develop a job sequence that minimizes total idle time at work centre #2. 57 Construct a load Gantt chart for the activities at the two work centres, and determine work centre 2's idle 58 time. Use colour for each job. Include a text box that indicates your Make-span and where and how much 59 60 idle time are at work Centre #2. (6) 61 62 Job Times ( days) 63 A B C D E F 64 W Centre #1 10 13 12 65 W Centre #2 2 5 3 11 66 67 A) 68 Sequence: 69 70 B) Complete your load Gantt Chart here 71 72 73 74 75 76 77 78 79 80 81 82 Sheet1 + 100% Ready 7:28 PM Rain coming 1 0 ( 1) 0 ENG Type here to search O P X 2022-12-02