A clothing chain is considering two different locations for a new retail outlet. They have identified the four factors listed in thefollowing table as the basis for evaluation, and have assigned weights as shown. The manager has rated each location on eachfactor, on a 100-point basis, as shown under the respective columns for Barclay and Chester.Factor DescriptionAverage community incomeCommunity growth potentialAvailability of public transportationFactorWeight.40BarclayChester3020.254030.152020Labor costWhat is the score for Barclay?4.20103024.5010.00100.0027.0025.75

Answered: A clothing chain is considering two…

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

Accel Express, Inc., collected the following information onwhere to locate a warehouse (1 = poor, 10 = excellent): a. Which location, A or B, should be chosen on the basis ofthe total weighted score? b. If the factors were weighted equally, would the choicechange?
What r ole does real estate market analysis play in determining the feasibility of specific locations for businesses?
Let us assume that a new medical facility, Health-care, is to be located in ABC city. The location factors, weights, and scores (1 = poor, 5 = excellent) for three potential sites are shown in the following table. What is the weighted score for these sites? Which is the best location Sr. Location factor Weight Scores Location 1 Location 2 Location 3 1 Facility utilization 25 3 5 6 2 Total patient per month 25 4 3 5 3 Average time per emergency trip 20 4 3 5 4 Land and construction costs 15 1 4 2 5 Employee preferences 25 5 3 5
~m8h5q2~
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
Calculate the weighted score for each location (A, B, C, D) shown in the table below: Factor Score for Each Location в Location Factor Factor Weight A D 1. Labor climate 2. Quality of Life 3. Transportation systems 4. Proximity to markets 5. Proximity to materials 6. Тахes 5 30 5 25 5 15 15 1 2 3 3 3 5 2 4 5 2 5 5 4 3 7. Utilities Total 100 The weighted score for location A is (Enter your response as an integer.) The weighted score for location B is. (Enter your response as an integer.) The weighted score for location C is s . (Enter your response as an integer.) The weighted score for location D isD. (Enter your response as an integer.) Which location would you recommend? O33 1243 +514 3 532t52
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
Identify and clarify seven key factors affecting decision on the location?
3. Consolidated 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 weights from 1 to 5 on each factor: Factor 1 2 3 4 5 6 Factor Name Proximity to port facilities Power source availability and cost Workforce attitude and cost Distance from Houston Community desirability Equipment suppliers in area Rating Weight 5 3 4 2 2 3 Management has rated each location for each factor on a 1- to 100-point basis. Factor Location A Location B Location C 1 100 80 80 2 80 70 100 3 30 60 70 4 10 80 60 5 90 60 80 6 50 60 90 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? c. What score would location B need on Proximity to port facilities to change its ranking?
Accel Express, Inc., collected the following information on where to locate a warehouse (1 = poor, 10 = excellent): %3D Location Score Location Factor Factor Weight A В Construction costs 10 Utilities available 10 1 2 Business services 20 8 10 Real estate cost 20 1 Quality of life Transportation 20 6. 2 20 6. a. Which location, A or B, should be chosen on the basis of the total weighted score? The total weighted score for location A is and the total weighted score for location B is so location should be chosen on the basis of the total weighted score. (Enter your responses as integers.)
Location Score Factor (100 points each) Weight A B C Convenience 0.15 87 92 84 Parking facilities 0.20 73 83 93 Display area 0.18 90 89 96 Shopper traffic 0.27 90 90 93 Operating costs 0.10 85 89 88 Neighborhood 0.10 95 87 94 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 A Composite Score B C b. Determine which location alternative (A, B, or C) should be chosen on the basis of maximum composite score. Oc OB OA 13
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

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