A manufacturing firm is considering three potential locations for a new partsmanufacturing facility. A consulting firm has assessed three sites based on the fourfactors supplied by management as critical to the location's success. The factorweights and the consultant team scores are given in table 5 below. Scores are based on50 = best.ii.Table 5LocationFactorsLabor ClimateWeights10AВC354520Таxes30304040Utilities20252045Wages40102525a. Which location should be selected?iii. Describe two factors that will affect the location decision of a supermarket and explainwhy these factors are important to the decision.

Answered: nufacturin, considerin potential…

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 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.
Imagine that Mary is planning a vacation and has to choose between two vacation spots. Based onthe information, if asked to choose the best spot, which would Mary choose? If asked to reject achoice, which vacation spot would Mary reject? Why?Spot Aaverage weatheraverage beachesmedium-quality hotelmedium-temperature wateraverage nightlifeSpot Blots of sunshinegorgeous beaches and coral reefsultra-modern hotelvery cold watervery strong windsno nightlife
A company is choosing an outside firm to provide its payroll services. It has chosen four comparative categories of interest: client reviews, financial condition, IT capabilities, and government stability. These categories have been assigned weights of 20%, 10%, 40%, and 30%, respectively. Two potential providers were scored on each of those factors (see table below) using a scale of 1-10, with a score of 1 meaning worst possible and 10 meaning best possible. Using the factor-rating method, which provider should be chosen? Provider A Provider B Client reviews 2 6 Financial condition 8 4 IT capabilities 5 8 Government stability 3 1
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. The factor weights and the consultant team scores are given in table 5 below. Scores are based on 50 = best. Which location should be selected?
The owner of a food truck implemented a new location strategy so that they would be better positioned near a crowded office park during the lunch hour. How should they evaluate the new location strategy?
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
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 Taxes 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.)
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
please answer in excel format showing formulas
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
ABC is a small chain of stores specializing in casual cotton clothing. The co. currently has 5 stores and wants to open a new one in one of 3 locations. Five factors are being considered for this decision. The weights and scores assigned by a hired consultant are as follows; Location factor College proximity Median income Vehicle traffic Mall quality & size Proximity to shopping Weight 0.30 0.25 0.25 0.10 0.10 Scores (0 to 100) Mall 1 Mall 2 Mall 3 90 65 79 80 50 40 60 75 80 60 90 90 100 80 30 Required Given that all the sites have basically the same leasing costs and labor and operating costs, advice ABC on where to locate the new store.
An electronics manufacturer must expand by building a second facility. The search is narrowed to four locations, all of which are acceptable to management in terms of dominant factors. Assessment of these sites in terms of seven location factors is shown in Table. For example, location A has a factor score of 5 (excellent) for labor climate; the weight for this factor (20) is the highest of any. Calculate the weighted score for each location. Which location should be recommended?

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