basisK-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 afor 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, therating weights and the rating value for each of the locations on the factor are presented:Factor123456Factor DescriptionProximity to port facilitiesPower-source availability and costWorkforce attitude and costDistance from HoustonRating Weight533312Location A Location B7070857550657560551010050Location C8010075608590Community desirabilityEquipment suppliers in areaa) 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

Here, each factor is given with a description, the alternatives are location A, location B, and…

Answered: a) Based on the given information, the…

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

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?
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?
Q2k Audi is considering three locations A, B and C for the production of its new model SUV XL500. The objective is to choose the location with the lowest costs. The costs are measured as annual fixed costs plus the variable costs of the product. The following data has been collected for the three locations.< Region Fixed costs per year A B C 10 000 000 20 000 000 25 000 000 Variable cost per unit 1. at what level of production will C be the best choice? 2. at what production rate will A be the best choice? 3. at what level of production will B be the best choice? 2500 2000< 1000< The company's projected annual production in the new plant is 0-60 000 units.< Ask
In deciding on where to locate their next grocery store, Publix narrowed it down to 3 locations (St. Augustine, the Airport area, or the Westside). They are using 2 criteria to make their decisions costs (with a weight of 70%) and customer base (with a weight of 30%). Each item was scored on a 10-point scale with 10 being the highest. St. Augustine rated a score of 4 for cost and 10 for customer base; the Airport area rated a score of 6 for cost and 5 for the customer base, and the Westside rated a score of 8 for cost and 2 for the customer base. __________ 2a. What is the computed mean score for each of the 3 locations? __________ 2b. Which location should be chosen based on the highest score?
Pan American Refineries, headquartered in Houston, must decide among three sites for the construction of a new oilprocessing center. T he firm has selected the six fac tors listedbelow as a basis for evaluation and has assigned rating weights from I to 5 on each factor: Subhajit Chakraborty, the CEO, has rated each location for each factor on a 1- to I 00-point basis a) Which si te 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) Wha t score would location B need on Proximity to port faci lities 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
Alternative locations for a new drinking water treatment plant are being evaluated using four attributes identified as A, B, C, and D with weightsof 0.4, 0.3, 0.2, and 0.1, respectively. If the value rating scale is from 1 to 10, the evaluation measure of the weighted attribute method for ratings of 3,7, 2 and 10 for attributes A, B, C, and D, respectively, is closest to:a. 3.3b. 3.9c. 4.1d. 4.7
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.
Tolkien Transport is currently based in Leeds but has plans to expand its operations by setting up another depot in the south of England. The management team has identified four possible locations for the depot and these are listed in the decision matrix below. As a first step they have decided to use a multi-criteria analysis (MCA) to rank the options. After much discussion, the team have decided on three key criteria (Cost, Accessibility and Environmental Impact) against which to judge the options and have agreed on the ratings shown in the matrix, below (running from 4 for the best to 1 for worst under each criterion). The criteria have been weighted as follows: Cost (0.45), Accessibility (0.35) and Environmental Impact (0.2). Option Cost Accessibility Environmental Impact Bristol 4 2 1 Reading 3 3 2 Swindon 1 4 3 Chelmsford 2 1 4 Required: Given the information above, which location would you advise Tolkien Transport to…
ABC Wants to choose the best location for its new aluminium plant. The manager of productions and operations has three possible locations to choose from. His assistant recommends that he use break-even analysis location technique to help determine which location is best based on costs. Design a numerical example in order to demonstrate to the Productions and Operations Manager how break-even analysis can be used in this Demonstrate to the OM manager how to go about choosing the best location using the numerical example you designed
Wang Lei and Li Mei Cai are newlyweds trying to decide among several available rentals. Alternatives were scored on a scale of 1 to 5 (5 = Best) against weighted performance criteria, as shown in the table below. The criteria included rent, proximity to work and recreational opportunities, security and other neighborhood characteristics associated with the couple values and lifestyle. Alternative A is an apartment, B is a bungalow, C is a condo and D is a downstairs apartment in Liİ Mei's parents' home. Which location is indicated by the performance matrix? Factor Score for Each Location Location Factor Factor Weight A B C 1. Rent 2. Quality of Life 3. Schools 25 3 5 2 20 3 4 1 5 5 2 4. Proximity to work 5. Proximity to recreation 6. Neighborhood security 7. Utilities 10 4 1 15 4 5. 2 4. 15 4 2 10 1 Total 100 The weighted score for location A is - (Enter your response as an integer.)
A clothing chain is considering two different locations for a new retail outlet. The organization has identified the four factors listed in the following table as the basis for evaluation, and it has assigned weights as shown. The manager has rated each location on each factor, on a 100-point basis (higher scores are better), as shown under the respective columns for Georgetown and Biabou. Calculate the weighted score for each alternative location. Which location should be chosen?

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