a) Based on the given information, the best location for Pan American Refineries is with a total weighted score of. (Enter your response as an integer) b) If Location B's score for Proximity to port facilities was reset at 80, it will have a new total weighted score of. (Enter your response as an integer) c) Location B will lower its ranking as soon as its score (within the confines of the 1 to 100 point basis) on Proximity to port facilities is less than (Enter your response as an interger)
a) Based on the given information, the best location for Pan American Refineries is with a total weighted score of. (Enter your response as an integer) b) If Location B's score for Proximity to port facilities was reset at 80, it will have a new total weighted score of. (Enter your response as an integer) c) Location B will lower its ranking as soon as its score (within the confines of the 1 to 100 point basis) on Proximity to port facilities is less than (Enter your response as an interger)
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
![basis
K-
Pan American Refineries, headquartered in Houston, must decide among three sites for the construction of a new oil-processing center. The firm has selected the six factors listed below as a
for evaluation and has assigned rating weights from 1 to 5 on each factor. Subhajit Chakraborty, the CEO, has rated each location for each factor on a 1 to 100 point basis. In the table below, the
rating weights and the rating value for each of the locations on the factor are presented:
Factor
1
2
3
4
5
6
Factor Description
Proximity to port facilities
Power-source availability and cost
Workforce attitude and cost
Distance from Houston
Rating Weight
5
3
3
3
1
2
Location A Location B
70
70
85
75
50
65
75
60
55
10
100
50
Location C
80
100
75
60
85
90
Community desirability
Equipment suppliers in area
a) Based on the given information, the best location for Pan American Refineries is
, with a total weighted score of. (Enter your response as an integer)
b) If Location B's score for Proximity to port facilities was reset at 80, it will have a new total weighted score of. (Enter your response as an integer)
c) Location B will lower its ranking as soon as its score (within the confines of the 1 to 100 point basis) on Proximity to port facilities is less than (Enter your response as an interger)
Time Remaining: 02:00.20](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F8a2e9018-6ef7-49be-821f-0ff43f4b9b5d%2F8630e90a-3f3d-468f-a337-82030c9dadd8%2Frkov13_processed.jpeg&w=3840&q=75)
Transcribed Image Text:basis
K-
Pan American Refineries, headquartered in Houston, must decide among three sites for the construction of a new oil-processing center. The firm has selected the six factors listed below as a
for evaluation and has assigned rating weights from 1 to 5 on each factor. Subhajit Chakraborty, the CEO, has rated each location for each factor on a 1 to 100 point basis. In the table below, the
rating weights and the rating value for each of the locations on the factor are presented:
Factor
1
2
3
4
5
6
Factor Description
Proximity to port facilities
Power-source availability and cost
Workforce attitude and cost
Distance from Houston
Rating Weight
5
3
3
3
1
2
Location A Location B
70
70
85
75
50
65
75
60
55
10
100
50
Location C
80
100
75
60
85
90
Community desirability
Equipment suppliers in area
a) Based on the given information, the best location for Pan American Refineries is
, with a total weighted score of. (Enter your response as an integer)
b) If Location B's score for Proximity to port facilities was reset at 80, it will have a new total weighted score of. (Enter your response as an integer)
c) Location B will lower its ranking as soon as its score (within the confines of the 1 to 100 point basis) on Proximity to port facilities is less than (Enter your response as an interger)
Time Remaining: 02:00.20
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
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 3 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Recommended textbooks for you
![Practical Management Science](https://www.bartleby.com/isbn_cover_images/9781337406659/9781337406659_smallCoverImage.gif)
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
![Operations Management](https://www.bartleby.com/isbn_cover_images/9781259667473/9781259667473_smallCoverImage.gif)
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
![Operations and Supply Chain Management (Mcgraw-hi…](https://www.bartleby.com/isbn_cover_images/9781259666100/9781259666100_smallCoverImage.gif)
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](https://www.bartleby.com/isbn_cover_images/9781337406659/9781337406659_smallCoverImage.gif)
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
![Operations Management](https://www.bartleby.com/isbn_cover_images/9781259667473/9781259667473_smallCoverImage.gif)
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
![Operations and Supply Chain Management (Mcgraw-hi…](https://www.bartleby.com/isbn_cover_images/9781259666100/9781259666100_smallCoverImage.gif)
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](https://www.bartleby.com/isbn_cover_images/9780135198100/9780135198100_smallCoverImage.gif)
![Purchasing and Supply Chain Management](https://www.bartleby.com/isbn_cover_images/9781285869681/9781285869681_smallCoverImage.gif)
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…](https://www.bartleby.com/isbn_cover_images/9781478623069/9781478623069_smallCoverImage.gif)
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.