### Site Selection for Pan American RefineriesPan American Refineries, headquartered in Houston, is evaluating three potential sites for constructing a new oil processing center. The decision process involves assessing six key factors, each assigned a different rating weight from 1 to 5. These factors and their weights are:| **Factor** | **Factor Name** | **Rating Weight** ||------------|-----------------------------------|-------------------|| 1 | Proximity to port facilities | 5 || 2 | Power-source availability and cost| 3 || 3 | Workforce attitude and cost | 4 || 4 | Distance from Houston | 2 || 5 | Community desirability | 2 || 6 | Equipment suppliers in area | 3 |**Location Ratings**Subhajit Chakraborty, the CEO, provided ratings for each location based on each factor (scores from 1 to 100):| **Factor** | **Location A** | **Location B** | **Location C** ||------------|----------------|----------------|----------------|| 1 | 100 | 80 | 80 || 2 | 80 | 70 | 100 || 3 | 30 | 60 | 70 || 4 | 10 | 80 | 80 || 5 | 10 | 80 | 90 || 6 | 50 | 60 | 90 |**Questions**a) **Which site will be recommended based on total weighted scores?**b) **If location B’s score for Proximity to port facilities was reset to 90, how would the result change?**c) **What score would location B need on Proximity to port facilities to change its ranking?**This evaluation involves calculating the total weighted scores based on the given ratings and weights to determine the best location for the new center.

(a) Based on the weighted score, Location C is recommended. (b) If Factor 1 for B changes to 90,…

Answered: ...8.10 Pan American Refineries,…

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...

See similar textbooks

Similar questions

A manager has received an analysis of several cities being considered for a new officecomplex. The data (10 pts maximum) are as follows:Location AlternativesFactors A B CBusiness Service 7 6 6Community Services 5 6 7Real Estate Cost 5 8 7Construction Cost 6 7 6Cost of Living 2 7 8Taxes 6 5 4Transportation 7 7 8a. If the manager weights the factors equally, how would the locations stack up in terms of their composite factor rating scores?b. If business services and construction costs are given weights that are double the weights of the other factors, how would the locations stack up
Can someone help me to fully solve the following problem showing all work. Thank you
3. Consolidated 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 basis for evaluation and has assigned rating weights from 1 to 5 on each factor: Factor 1 2 3 4 5 6 Factor Name Proximity to port facilities Power source availability and cost Workforce attitude and cost Distance from Houston Community desirability Equipment suppliers in area Rating Weight 5 3 4 2 2 3 Management has rated each location for each factor on a 1- to 100-point basis. Factor Location A Location B Location C 1 100 80 80 2 80 70 100 3 30 60 70 4 10 80 60 5 90 60 80 6 50 60 90 a. Which site will be recommended based on total weighted scores? b. If location B's score for Proximity to port facilities was reset at 90, how would the result change? c. What score would location B need on Proximity to port facilities to change its ranking?
In location planning, environmental regulations, cost and availability of utilities, and taxes are: Question 15Answer A. regional/community factors. B. irrelevant. C. site-related factors. D. global factors. E. country factors.
c. A manufacturing firm is considering three potential locations for a new parts manufacturing facility. A consulting firm has assessed three sites based on the four factors supplied by management as critical to the location's success. Management-supplied the factor weights and the consultant team scores as seen in the table below. Scores are based on 50 = best. Location Factor Weight A B C Labor Climate 10 35 45 20 Taxes 30 30 40 40 Utilities 20 25 20 45 Wages 40 10 25 25 i. Which location should be selected and why?
Scenario You are a consultant who specializes in helping U.S.-based businesses expand into new international locations. You have a new client who’s looking to outsource their company’s manufacturing of hard drives and computer memory, and it’s your job to assist in selecting the new locations. The company is very focused on quality, sustainability, and equality, and your client would like these attributes upheld in the new manufacturing locations. Evaluate two of the following countries: India Mexico Thailand Then, recommend one country you believe would be the most suitable for the company’s new manufacturing facility, and one country that would be considered the least suitable. Sustainability Measures and Environmental Regulation: Briefly describe sustainability measures and regulations in each country, and analyze how they may work well with or create conflict or tension with your U.S.-based company. Examples of items to consider include regulations around pollution, waster, and…
In the table below, scores are based on 50=best Location Factor Weight A B C Labour climate 10 35 45 20 taxes 30 30 40 40 utilities 20 25 20 45 wages 40 10 25 25 Which location should be selected and why?
7
A manufacturing firm is considering three potential locations for a new parts manufacturing facility. A consulting firm has assessed three sites based on the four factors supplied by management as critical to the location's success in the table below. Scores are based on 50 = best. Location Factor Weight A B C Labor Climate 10 35 45 20 Taxes 30 30 40 40 Utilities 20 25 20 45 Wages 40 10 25 25 Which location should be selected and why?

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

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

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

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

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.

SEE MORE TEXTBOOKS