A Detroit seafood restaurant is considering opening asecond facil ity in the suburb of West Bloomfield. The followingtable shows its ratings of five factors at each of four potentialsites. Which site should the owner, Lucy Lyu. select? SITEFACTORWEIGHT13Affluence of localpopulation1070608590Construction andland cost1085908060Traffic flow2570608590Parking availabilityGrowth potential20809090801590809075

SITE FACTOR WEIGHT 1 3 Affluence of local population 10 70 60 85 90 Construction and land cost 10 85 90 80 60 Traffic flow 25 70 60 85 90 Parking availability Growth potential 20 80 90 90 80 15 90 80 90 75

SITE FACTOR WEIGHT 1 3 Affluence of local population 10 70 60 85 90 Construction and land cost 10 85 90 80 60 Traffic flow 25 70 60 85 90 Parking availability Growth potential 20 80 90 90 80 15 90 80 90 75

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 plastic manufacturing company is considering 2 alternative locations for a new facility. The management considered 2 alternatives: Sta. Rosa and Sta. Rita. The fixed costs for Sta. Rosa is Php1M and variable cost is Php25 per unit. On the other hand, the fixed costs for Sta. Rita is Php1.5M and variable cost is Php23 per unit. 1. If the company plans on producing 50,000 units which location would be more attractive? 2. At what volume the two alternatives equal in cost?
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.
How is FedEx’s location a competitive advantage? Discuss.
Subway, with more than 25,000 outlets in the U.S., is planning for a new restaurant in Buffalo, New York. Three loca-tions are being considered. The following table gives the factors for each site.FACTOR WEIGHT MAITLANDBAPTISTCHURCHNORTHSIDEMALLSpace .30 60 70 80Costs .25 40 80 30Traffi c density .20 50 80 60Neighborhoodincome .15 50 70 40Zoning laws .10 80 20 90a) At which site should Subway open the new restaurant?b) If the weights for Space and Traffic density are reversed, howwould this affect the decision?
Silky Industries is looking for a location for its second telephone remanufacturing facility. Two cities are under consideration. The two most important location factors are: Factor A "availability of resources" and Factor B "availability of customers." However, the company is having great difficulty assigning relative weights to these factors. Assuming that the factor weights must sum to 100, what range of weights would make Blake the superior location? E Click the icon to view the factors table. The total weighted factor scores are the same for the following weights: Factor A=O and Factor B =D. As the weight of Factor B becomes Blake will be the superior location. (Enter your responses as whole numbers.) More Info Factor Score for Each Location Factor City Factor Weight Blake Irmo A. Availability of resources B. Availability of customers Total 8 10 9 6. 100 Print Don
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?
Please do not give solution in image formate thanku.
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?