Mercy Ships deploys hospital ships to combat several overwhelming statistics. The first statistic is that over 5 billion people lack access to safe surgery. The second key stats is over 50 percent of the world's population lives near a coast, so Mercy Ships are the best way to reach them with state-of-the-art medical care. Typical surgeries include cleft lips and palates, facial tumors, dental surgery, sight corrections, and clubfoot and orthopedic surgeries. Ship crews, nurses, and medical professionals volunteer their time to help children and adults from their devastating medical conditions. Two private hospital ships in their fleet are the Global Mercy and the Africa Mercy. Given that the Africa Mercy ship will visit five seaports (jobs) located close to one another with the processing time and due date estimates provided in the table below, how would you sequence (route) the ships to each job/location-in numerical order, shortest processing time, or earliest due date rules? Due Date Average Flow Time Shortest processing time The SPT sequence is -Select-- Average Assume the set of jobs is processed on a single processor-the ship, and the ship can sail late at night to each location along the coast. Find and compare the performance measures for the following sequencing rules using the Excel Sequencing template in MindTap. Round your answers to two decimal places. Process in the order they have arrived Flow Time Lateness Job 1 2 3 4 5 Lateness Tardiness -Select- ✓ -Select- ✓- -Select- ✓- Processing Time 23 7 13 10 5 Tardiness 22 28 26 15 13 -Select-v

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
icon
Related questions
Question
Enter data only in yellow-shaded cells. Up to 10 jobs may be sequenced Average Average Average Number o Maximum
Flowtime Lateness Tardines: Tardy Job: Tardiness
14.40 4.20 5.00
5
3
12.00
Number of Jobs
Job
1
2
3
4
5
6
7
8
9
10
'rocessing Tim
7
3
5
2
6
Due Dat iequence Processing Time Due Date Flowtime Lateness Tardiness
1
7
-4
0
2
10
0
0
3
7
7
4
12
12
5
6
6
11
10
8
5
17
7
3
5
2
6
11
10
8
5
17
15
17
23
Transcribed Image Text:Enter data only in yellow-shaded cells. Up to 10 jobs may be sequenced Average Average Average Number o Maximum Flowtime Lateness Tardines: Tardy Job: Tardiness 14.40 4.20 5.00 5 3 12.00 Number of Jobs Job 1 2 3 4 5 6 7 8 9 10 'rocessing Tim 7 3 5 2 6 Due Dat iequence Processing Time Due Date Flowtime Lateness Tardiness 1 7 -4 0 2 10 0 0 3 7 7 4 12 12 5 6 6 11 10 8 5 17 7 3 5 2 6 11 10 8 5 17 15 17 23
Mercy Ships deploys hospital ships to combat several overwhelming statistics. The first statistic is that over 5 billion people lack access to safe surgery. The second key stats is
over 50 percent of the world's population lives near a coast, so Mercy Ships are the best way to reach them with state-of-the-art medical care. Typical surgeries include cleft
lips and palates, facial tumors, dental surgery, sight corrections, and clubfoot and orthopedic surgeries. Ship crews, nurses, and medical professionals volunteer their time to
help children and adults from their devastating medical conditions. Two private hospital ships in their fleet are the Global Mercy and the Africa Mercy.
Given that the Africa Mercy ship will visit five seaports (jobs) located close to one another with the processing time and due date estimates provided in the table below, how
would you sequence (route) the ships to each job/location-in numerical order, shortest processing time, or earliest due date rules?
Average
Flow Time
Shortest processing time
The SPT sequence is -Select- ✓
Average
Flow Time
Lateness
Processing Time
23
7
ITT
13
10
5
Job
Lateness
2
1
5
Assume the set of jobs is processed on a single processor-the ship, and the ship can sail late at night to each location along the coast. Find and compare the performance
measures for the following sequencing rules using the Excel Sequencing template in MindTap. Round your answers to two decimal places.
Process in the order they have arrived
Tardiness
3
Tardiness
4
-Select- ✓ -Select- ✓ -Select--
Due Date
-Select- ✓
22
28
26
15
13
Transcribed Image Text:Mercy Ships deploys hospital ships to combat several overwhelming statistics. The first statistic is that over 5 billion people lack access to safe surgery. The second key stats is over 50 percent of the world's population lives near a coast, so Mercy Ships are the best way to reach them with state-of-the-art medical care. Typical surgeries include cleft lips and palates, facial tumors, dental surgery, sight corrections, and clubfoot and orthopedic surgeries. Ship crews, nurses, and medical professionals volunteer their time to help children and adults from their devastating medical conditions. Two private hospital ships in their fleet are the Global Mercy and the Africa Mercy. Given that the Africa Mercy ship will visit five seaports (jobs) located close to one another with the processing time and due date estimates provided in the table below, how would you sequence (route) the ships to each job/location-in numerical order, shortest processing time, or earliest due date rules? Average Flow Time Shortest processing time The SPT sequence is -Select- ✓ Average Flow Time Lateness Processing Time 23 7 ITT 13 10 5 Job Lateness 2 1 5 Assume the set of jobs is processed on a single processor-the ship, and the ship can sail late at night to each location along the coast. Find and compare the performance measures for the following sequencing rules using the Excel Sequencing template in MindTap. Round your answers to two decimal places. Process in the order they have arrived Tardiness 3 Tardiness 4 -Select- ✓ -Select- ✓ -Select-- Due Date -Select- ✓ 22 28 26 15 13
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Follow-up Questions
Read through expert solutions to related follow-up questions below.
Follow-up Question

Please correct 

Average
Shortest processing time
The SPT sequence is 5
Average
Earliest due date
Flow Time
26.40
Average
The EDD sequence is 5
The SPT sequence
The SPT sequence
The SPT sequence
Flow Time
33.40
Flow Time
2
4
Lateness
5.60
Lateness
12.60
Lateness
1
Tardiness
10.40
Tardiness
14.20
Tardiness
has the smallest average flow time.
has the smallest average lateness.
has the smallest average tardiness.
3
3
1
2
Transcribed Image Text:Average Shortest processing time The SPT sequence is 5 Average Earliest due date Flow Time 26.40 Average The EDD sequence is 5 The SPT sequence The SPT sequence The SPT sequence Flow Time 33.40 Flow Time 2 4 Lateness 5.60 Lateness 12.60 Lateness 1 Tardiness 10.40 Tardiness 14.20 Tardiness has the smallest average flow time. has the smallest average lateness. has the smallest average tardiness. 3 3 1 2
Solution
Bartleby Expert
SEE SOLUTION
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.