...8.10 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 belowas a basis for evaluation and has assigned rating weights from 1 to5 on each factor:FACTOR123456FACTOR NAMEProximity to port facilitiesFACTOR123456Power-source availability and costWorkforce attitude and costDistance from HoustonCommunity desirabilityEquipment suppliers in areaSubhajit Chakraborty, the CEO, has rated each location for eachfactor on a 1- to 100-point basis.LOCATION A1008030109050RATING WEIGHTLOCATION B807060806060534223LOCATION C8010070608090a) Which site will be recommended based on total weightedscores?b) If location B's score for Proximity to port facilities was reset at90, how would the result change?c) What score would location B need on Proximity to port facili-ties to change its ranking? PX

(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

17. A company has established a project team to identify a location for a new manufacturing facility. Use a weighted scoring model to analyze three candidate locations (A, B, C) for setting up the new factory. The relative weights for each criterion are shown in the following table. A score of 1 represents unfavorable, 2 satisfactory, and 3 favorable. Location Category Weight A В Labor costs Labor productivity Labor supply Union relations Material supply Transport costs Infrastructure 20 20 10 10 10 25 5 1 2 3 3 1 2 1 3 3 3 2 2 1 1 1 2 3 2 2 2 889
Considering the following data:Location Alternatives(scored out of 100 pts each)Factors Weights A B CConvenience 0.15 86 85 78Parking Facilities 0.20 78 78 92Display Area 0.18 90 89 90Shopper Traffic 0.27 91 92 85Operating Costs 0.10 98 95 90Neighborhood 0.10 88 91 85a. Using the above factor ratings, calculate the composite score for each location.b. Determine which location alternative (A, B, or C) should be chosen on the basisof the maximum composite score.
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 basis for evaluation and has assigned rating weightsfrom 1 to 5 on each factor:FACTOR FACTOR NAME RATING WEIGHT1 Proximity to port facilities 52 Power-source availability and cost 33 Workforce attitude and cost 44 Distance from Houston 25 Community desirability 26 Equipment suppliers in area 3Subhajit Chakraborty, the CEO, has rated each location for eachfactor on a 1- to 100-point basis.FACTOR LOCATION A LOCATION B LOCATION C1 100 80 802 80 70 1003 30 60 704 10 80 605 90 60 806 50 60 90a) Which site will be recommended based on total weightedscores?b) If location B’s score for Proximity to port facilities was resetat 90, how would the result change? c) What score would location B need on Proximity to port facili-ties to change its ranking?
Voice International is deciding between 2 Philippine companies to provide its call center services. A factor-rating method is used to evaluate. The factors are rated on a scale of 1-10, with 10 being the best score. If the factors are weighted equally with respective weights of .3333, which of the firm is preferred? FIRM FACTOR 1 FACTOR 2 FACTOR 3 A 6 7 10 B 8 9 8
3. A company desires to locate a new facility. Based on preliminary analysis, the choice has been reduced to four locations: A, B, C, and D. These four locations were rated on a scale from 1 worst to 10 best on each of four criteria. Each criterion was also weighted to indicate its importance (i.e., the higher the weight, the more important). The list of ratings and weights follows. Location Weight A Factor Wages Labor climate B 0.40 7 3 5 0.35 9. Local regulation Weather 0.15 4 3 2 0.10 2 8 a- What would be the best location b- If the wights of weather and regulation be divided that the weather would be double of the regulations, what would be the best location LO
In location planning, environmental regulations, cost and availability of utilities, and taxes are: A. site-related factors. B. country factors. C. global factors. D. irrelevant. E. regional/community factors.
A supply chain manager faced with choosing among four possible locations has assessed each location according to the following criteria, where the weights reflect the importance of the criteria. 2 3 4 -Select- is the best location and -Select- -Select- Location 1 Location 2 Location 3 Location 4 Criteria Raw material availability Infrastructure Transportation costs Using this information, determine the best and the worst location. Round your answers to two decimal places. Location Total Points 1 is the worst location. Labor relations Quality of life Weight 0.11 0.13 0.23 0.23 0.30 1 VG G P G G W Location 2 OK OK OK P VG 3 OK VG OK VG G VG Very good 5 pts; G = Good 4 pts; OK = Acceptable 3 pts; P = Poor 1 pt. 4 OK OK G VG OK
Q) A discount store chain wants to build a new superstore in an area in Melbourne near four small towns with populations between 10,000 and 40,000. The coordinates (in miles) of these four towns and the market population in each are as follows: Coordinates Carlton St Kilda Ballarat Frankston 12 18 30 32 20 12 8 25 Population 18,000 17,000 10,300 10,000 a) Determine the best site using the center-of-gravity technique. b) Suppose the store is limited to two possible sites for locating a new superstore. The coordinates (in miles) of these two potential sites are site 1 (10, 30) and site 2 (20, 10). Using the load-distance technique, determine the best site for the new super store. c) Plot the four small towns and the proposed new distribution centers according to center of gravity method and load-distance method on a grid map. Give your own opinion about it.
2. You have been tasked by Corica Pastries, to setup a retail location anywhere inMalaysia, to introduce their world famous apple strudels to the Malaysian market.b. Store location analysisi. Alternate geographic trading areasii. Type of locationiii. Literacy of populationiv. Trading factorsv. Accessibilityvi. Amenities This is not a writting assignment, please don't reject. If don't know let others to answer. Thank you
A company is planning on expanding and building a new plant in one of three Southeast Asian countries. Chris Ellis, the manager charged with making the decision, has determined that five critical success factors (CSFs) can be used to evaluate the prospective countries Ellis used a rating system of 1 (least desirable country) to 5 (most desirable) to evaluate each CSF. a) Based on the given information, the best location for Chris Ellis is Factor Critical Success Factors 1 2 3 4 5 Technology Level of education Political and legal aspects Social and cultural aspects Economic factors with a total weighted score of b) Political unrest in Thailand results in a lower score, 2, for Political and legal aspects. The best location for Chris Ellis is c) If Thailand's score drops even further, to a 1, for Political and legal aspects, the best location for Chris Ellis is Weight 0.20 0.10 0.40 0.10 0.20 r Candidate Country Ratings Thailand 5 1 3 2 3 (Enter your response rounded to two decimal…
2. A Tema Oil Refinery (TOR) Ltd, must decide among three sites for the construction of a new oil storage facility. The firm has selected the six factors listed below in Table1 as a basis for evaluation and has assigned rating weights from 1 to 5 on each factor. Mr. Isaac Osei the Managing Director has rated each location for each factor on a 1 to 100-point basis. Table 1: Factor Description, Rating Weight and Location rating FACTOR FACTOR NAME RATING WEIGHT LOCATION A B C 1 Proximity to port facility 5 100 80 802 Power-source availability and cost 3 80 70 1003 Workforce attitude and cost 4 30 60 704 Distance from Tema 2 10 80 605 Community desirability 2 90 60 806 Equipment suppliers in area 3 90 60 90 Requirements (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?
Location Score Factor (100 points each) Weight A B Convenience 0.15 89 82 87 Parking facilities 0.20 85 97 94 Display area 0.18 85 92 86 Shopper traffic 0.27 94 88 90 Operating costs 0.10 96 90 85 Neighborhood 0.10 80 91 89 1.00 Click here for the Excel Data File a. Using the above factor ratings, calculate the composite score for each location. (Do not round intermediate calculations. Round your final answers to 2 decimal places.) Location Composite Score A B C

SEE MORE QUESTIONS

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