Solve on EXCEL spreadsheets Using the factor ratings shown below, determine which location alternative should be chosen on the basis of maximum composite score.LocationFactorEasy accessParking facilitiesDisplay areaShopper (walking) trafficNeighborhood wealthNeighborhood safetyWeight0.150.20.180.210.160.1A867286949996B 72 7 90 85 89 857786C909190808175

Given are the factors that affect the decision to select a location. The composite score will be…

Using the factor ratings shown below, determine which location alternative should be chosen on the basis of maximum composite score. Location B Factor Easy access Parking facilities Display area Shopper (walking) traffic Neighborhood wealth Neighborhood safety Weight 0.15 0.2 0.18 0.21 0.16 0.1 A 86 72 86 94 99 96 2 7 80 86 89 85 72 77 90 C 90 91 90 80 81 75

Using the factor ratings shown below, determine which location alternative should be chosen on the basis of maximum composite score. Location B Factor Easy access Parking facilities Display area Shopper (walking) traffic Neighborhood wealth Neighborhood safety Weight 0.15 0.2 0.18 0.21 0.16 0.1 A 86 72 86 94 99 96 2 7 80 86 89 85 72 77 90 C 90 91 90 80 81 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

Location Score Factor (100 points each) Weight A B Convenience 0.15 89 82 87 Parking facilities 0.20 85 97 94 Display area 0.18 85 92 86 Shopper traffic 0.27 94 88 90 Operating costs 0.10 96 90 85 Neighborhood 0.10 80 91 89 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 Composite Score A B C
Problem 8-9 (Static) Location Score Factor (100 points each) Weight A B Convenience 0.15 80 70 Parking facilities 0.20 72 76 Display area 0.18 88 90 90 Shopper traffic 0.27 94 86 Operating costs 0.10 98 90 Neighborhood 0.10 96 85 182820 C 60 92 80 82 75 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 Composite Score A B 0
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.
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. Location Total Points 1 2 3 4 -Select- Criteria Raw material availability Infrastructure Transportation costs is the best location and -Select- Labor relations Quality of life Weight 0.09 0.08 0.35 0.11 0.37 Using this information, determine the best and the worst location. Round your answers to two decimal places. 1 P G VG OK OK is the worst location. Location 2 OK G G VG VG 3 G VG OK P P VG = Very good 5 pts; G = Good 4 pts; OK = Acceptable 3 pts ; P = Poor 1 pt. 4 G OK VG P OK
Factor(100 points each) Weight A B C Convenience 0.15 86 75 80 Parking facilities 0.2 70 86 96 Display area 0.18 88 90 91 Shopper traffic 0.27 86 90 95 Operating costs 0.1 95 91 96 Neighborhood 0.1 88 88 91 1.00 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 Composite score A ______________ B ________________ C ________________
A company is constructing a new hostel facility. The company has hired you as part of the team to identify the best potential sites for the new facility. Your team identified four sites and have rated the important location factors for each site as follows: LOCATION FACTOR SCORES (out of 100) WEIGHT A B C D Proximity to Campus 0.23 70 90 65 85 Student traffic 0.22 75 80 60 85 Parking availability 0.16 90 60 80 70 Plot size, terrain 0.12 80 70 90 75 Infrastructure 0.10 50 60 40 60 Off-campus accessibility 0.06 90 70 70 70 Proximity to dining facilities 0.05 60 80 70 90 Visitor traffic 0.04 70 80 65 55 Landscape/aesthetics 0.02 50 40 60 70 Required: c) If the location C has its score for infrastructure to be 80. Will the choice in (b) be the same? d) Explain two (2) benefits for the best location selected for the hostel in…
A company is constructing a new hostel facility. The company has hired you as part of the team to identify the best potential sites for the new facility. Your team identified four sites and have rated the important location factors for each site as follows: LOCATION FACTOR SCORES (out of 100) WEIGHT A B C D Proximity to Campus 0.23 70 90 65 85 Student traffic 0.22 75 80 60 85 Parking availability 0.16 90 60 80 70 Plot size, terrain 0.12 80 70 90 75 Infrastructure 0.10 50 60 40 60 Off-campus accessibility 0.06 90 70 70 70Proximity to dining facilities 0.05 60 80 70 90 Visitor traffic 0.04 70 80 65 55 Landscape/aesthetics 0.02 50 40 60 70 Required: a) What is the weighted score for the each location? b) Which location will you recommend for the new hostel? Justify your choice. c) If the location C has its score for infrastructure to be 80. Will the choice in (b) be the same? d) Explain two (2) benefits for the best location selected for the hostel in (b).
A company is constructing a new hostel facility. The company has hired you as part of the team to identify the best potential sites for the new facility. Your team identified four sites and have rated the important location factors for each site as follows: LOCATION FACTOR SCORES (out of 100) WEIGHT A B C D Proximity to Campus 0.23 70 90 65 85 Student traffic 0.22 75 80 60 85 Parking availability 0.16 90 60 80 70 Plot size, terrain 0.12 80 70 90 75 Infrastructure 0.10 50 60 40 60 Off-campus accessibility 0.06 90 70 70 70 Proximity to dining facilities 0.05 60 80 70 90 Visitor traffic 0.04 70 80 65 55 Landscape/aesthetics 0.02 50 40 60 70 Required: a) What is the weighted score for the each location? b) Which location will you recommend for the new hostel? Justify your choice.
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
Considering the following summarized hybrid analysis for a discrete location problem, which one of the following location alternative is the best alternative location? Weights 0.032 0.968 Alternatives CFM, SFM, OFM, A 1 0.346 0.311 B 1 0.558 0.504 1 0.564 0.416 D 1 0.900 0.470 Select one: a. D b. A с. С d. B
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?
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