The radiology department of Sunshine Health System currently uses FCFS to determine the order in which patients are processed through their system. Management is not sure this is the most efficient way to schedule patients in radiology. The attached data related to patient processing in radiology were collected on a typical day. Using these data, please compare the various sequencing rules (FCFS, SPT, EDD, STR, and CR). You will need to resequence the data in the order patients will be processed to determine the different results under each of the different sequencing rules. You'll want to include the following columns in each spreadsheet: Patient Sequence, Start Time, Processing Time, Completion Time, Due Time, Tardiness.

Please submit a separate Excel worksheet for each sequencing rule.

Transcribed Image Text:

Paste 015 1 4 2 AutoSave Off BS File 3 4 5 6 7 18 19 20 21 Home Cut Be Copy Format Painter 8 9 10 11 J 12 K 13 L 14 M 15 N 16 0 17 P Q R S A B C D E F G H I Clipboard Font G Alignment ✪ UPDATES AVAILABLE Updates for Office are ready to be installed, but first we need to close some apps. fx C Due Time (minutes) [minutes from now) 35 140 15 35 25 30 25 A B Patient Processing Time 35 30 20 25 25 15 Insert Draw Page Layout 30 20 20 10 10 15 20 Calibri G 2 = BIU. 180 360 290 420 20 180 290 110 290 150 270 ¤******* 390 220 400 330 230 370 Formulas Data 11 A A - A D Review E Wrap Text === =+ Merge & Center - F View G Radiology Sequence Data (1) - Excel Tell me what you want to do H G General $%, I Number Update now J K *.0 G Conditional Format as Cell Formatting Table Styles Styles L M N 22 D U 8.8 88 Insert Delete Format 0 Cells P Q Σ AutoSum Fill- ✓Clear R AT O Sort & Find & Filter Select Editing - S T U Share X Paste 015 1 4 2 AutoSave Off BS File 3 4 5 6 7 18 19 20 21 Home Cut Be Copy Format Painter 8 9 10 11 J 12 K 13 L 14 M 15 N 16 0 17 P Q R S A B C D E F G H I Clipboard Font G Alignment ✪ UPDATES AVAILABLE Updates for Office are ready to be installed, but first we need to close some apps. fx C Due Time (minutes) [minutes from now) 35 140 15 35 25 30 25 A B Patient Processing Time 35 30 20 25 25 15 Insert Draw Page Layout 30 20 20 10 10 15 20 Calibri G 2 = BIU. 180 360 290 420 20 180 290 110 290 150 270 ¤******* 390 220 400 330 230 370 Formulas Data 11 A A - A D Review E Wrap Text === =+ Merge & Center - F View G Radiology Sequence Data (1) - Excel Tell me what you want to do H G General $%, I Number Update now J K *.0 G Conditional Format as Cell Formatting Table Styles Styles L M N 22 D U 8.8 88 Insert Delete Format 0 Cells P Q Σ AutoSum Fill- ✓Clear R AT O Sort & Find & Filter Select Editing - S T U Share X

Answer rating: 100% (QA)

It seems that you are asking for help with creating Excel worksheets to compare various sequencing rules for patient processing in a radiology departm... View the full answer