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
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...
Related questions
Question

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

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

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 2 images

Follow-up Questions
Read through expert solutions to related follow-up questions below.
Follow-up Question
Please correct

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
Recommended textbooks for you

Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,

Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education

Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,

Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education


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…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.