←Daniel Tracy, owner of Martin Manufacturing, must expand by building a new factory. The search for a location for this factory has been narrowed to four sites: A, B, C, or D. The following table shows the resultsthus far obtained by Tracy by using the factor-rating method to analyze the problem. The scale used for each factor scoring is 1 through 5.Factor123467Factor DescriptionQuality of laborConstruction costTransportation costsProximity to MarketsTaxesWeatherEnergy costsa) Based on the given information, the best site for Daniel Tracy isDwith a total weighted score ofBWeight10778A65A5342B253254Site ScoresC5444344(Enter your response as an integer.)D312343

Find the Calculations methods below: Total Weighted Score = ∑ (Weights * Site Scores) Given details:…

Answered: Daniel Tracy, owner of Martin…

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

John and Jane Darling are newlyweds trying to decide amongseveral available rentals. Alternatives were scored on a scaleof 1 to 5 (5 = best) against weighted performance criteria,as shown in Table 13.7. The criteria included rent, proximity to work and recreational opportunities, security, and otherneighborhood characteristics associated with the couple’svalues and lifestyle. Alternative A is an apartment, B is abungalow, C is a condo, and D is a downstairs apartment inJane’s parents’ home.Which location is indicated by the preference matrix? Whatqualitative factors might cause this preference to change?
The Zhao family of Atlanta, Georgia, is planning its annual summer vacation. Three vacation locations along with criteria weights and location ratings follow. What is the recommended vacation location? Criteria Travel distance Vacation Entertainment available Outdoor activities Unique experience Family fun O Myrtle Beach, South Carolina OSmoky Mountains Branson, Missouri Weight 2 5 3 2 4 5 Myrtle Beach, South Carolina 5 5 7 9 5 8 Ratings Smoky Mountains 9 6 4 6 9 9 Branson, Missouri 3 8 4 5 9 8
Northeastern Insurance Company is considering opening an office in the U.S. The two cities under consideration are Philadelphia and New York. The factor ratings (higher scores are better) for the two cities are given in the following table. Factor Weight Philadelphia New York Customer convenience 0.25 70 80 Bank accessibility 0.20 40 90 Computer support 0.20 85 75 Rental costs 0.15 90 55 Labor costs 0.10 80 50 Таxes 0.10 90 50 Based on the given information, the best location for Northeastern Insurance Company to open the office is with a total weighted score of. (Enter your response as a whole number.)
A location analysis has been narrowed down to three locations. The management needs to select the best location. The critical success factors, their weights, and the ratings for each location are shown below: Location Location Location Factor Wt. A B C Labor Cost 0.3 80 85 75 Transportation Cost 0.2 85 85 60 Market Access 0.2 90 70 90 Raw Materials Cost 0.1 80 90 90 Utility Cost 0.2 75 90 75 a) The composite score for location A is ( )b) The best location is ( )
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
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
Accel Express, Inc., collected the following information on where to locate a warehouse (1 = poor, 10 = excellent): Location Score Location Factor Factor Weight A B Construction costs 10 8 5 Utilities available 10 7 7 Business services 10 4 7 Real estate cost 20 7 4 Quality of life 20 4 8 Transportation 30 7 6 a. Which location, A or B, should be chosen on the basis of the total weighted score?b. If the factors were weighted equally, would the choice change?
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? The weighted score for location A is The weighted score for location B is The weighted score for location C is The weighted score for location D is Location Factor 1. Rent 2. Quality of Life 3. Schools 4. Proximity to work 5. Proximity to recreation 6. Neighborhood security 7. Utilities Total Factor Weight 25 20 5 10 15 15 10 100 (Enter your response as an integer.) (Enter your response as an integer.) (Enter your response as an…
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.)
Harden College is contemplating opening a Europeancampus where students from the main campus could go to take courses for 1 of the 4 college years. At the moment, it is con-sidering five countries: The Netherlands, Great Britain, Italy, Belgium, and Greece. The college wishes to consider eight factorsin its decision. The first two factors are given weights of 0.2, whilethe rest are assigned weights of 0.1. The following table illustratesits assessment of each factor for each country (5 is best). issue
A manager received an analysis of several cities being considered for a new office complex. The data (10 points maximum) are as follows: Factor Business services Community services Real estate cost Construction costs Cost of living Taxes Transportation A с Thus, Location Score A A B с Thus, 17 17 17 8 6 4 3 2 8 9 B 6 6 Click here for the Excel Data File a. If the manager weights the factors equally, how would the locations stack up in terms of their composite factor rating scores? 8 7 7 19 19 19 5 7 is/are the best. C 6 7 7 6 8 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? is/are best and 4 8 is/are least desirable.
Northeastern Insurance Company is considering opening an office in the U.S. The two cities under consideration are Philadelphia and New York. The factor ratings (higher scores are better) for the two cities are given in the following table. Factor Weight Philadelphia New York Customer convenience 0.25 70 80 Bank accessibility 0.20 35 85 Computer support 0.20 90 75 Rental costs 0.15 95 55 Labor costs 0.10 85 45 Taxes 0.10 95 55 Based on the given information, the best location for Northeastern Insurance Company to open the office is with a total weighted score of (Enter your response rounded to two decimal places.) 3

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