Calculate the weighted score for each location (A, B, C, D) shown in the table below:Factor Score for Each LocationвLocation FactorFactor WeightAD1. Labor climate2. Quality of Life3. Transportation systems4. Proximity to markets5. Proximity to materials6. Тахes53052551515123335245255437. UtilitiesTotal100The 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 iss . (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 3532t52

Answered: Calculate the weighted score for each…

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

The Davis national drugstore chain prefers to operate one outlet in a town that has four major market segments. The number of potential customers in each segment, along with the coordinates are as follows: Location Market Coordinates Number of Segment x y Customers 1 5 22 2,200 2 17 20 300 3 5 3 1,400 4 10 3 3,000 Find the best location using the Center of Gravity Excel template. Round your answers to two decimal places. Cx: ____________Cy: ______________
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
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
The Davis national drugstore chain prefers to operate one outlet in a town that has four major market segments. The number of potential customers in each segment along with the coordinates are as follows: Location Coordinates Market Segment 1 2 3 4 Find the best location using the Center-of-Gravity Excel template. Round your answers to two decimal places. Cx: Cy: Choose the correct graph representing the center of gravity. The correct graph is-Select- A. 25 20 15 -10 5 Center of Gravity y- Coordinate L 5 10 15 20 x- Coordinate 25 B. 25+ 20+ 15 -10- 5- Center of Gravity y- Coordinate 5 8 10 15 20 x- Coordinate X 1 13 1 11 25 Y 14 21 1 1 Number of Customers 1,600 400 1,200 3,700
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
1. Using the center-of-gravity method, compute the centralized coordinates among the following locations, which are indicated via black cells with white text in LOCATION.xlsx: 7,1 10,1 4,2 2,5 6,6 9,6 2,8 6,10 2. Using the weighted average center-of-gravity, which accounts for quantities to be shipped from locations, compute the centralized coordinates among the following locations: 7,1 10,1 4,2 2,5 6,6 9,6 2,8 6,10 *Quantities to be shipped are listed within the existing locations (i.e. Location 7,1 ships 17 units) in LOCATION.xlsx
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.
Calculate the weighted score for each location (A, B, C, and D) shown in Table. Which location would you recommend? Factor Score for Each Location Location Factor Factor Weight A B C D 1. Labor climate 2. Quality of life 3. Transportation system 4. Proximity to markets 5. Proximity to materials 6. Taxes 7. Utilities Total 5 30 5 25 5 15 15 100 5 2 3 5 3 2 5 4 3 4 3 2 5 4 3 5 3 4 3 5 2 5 1 5 4 5 4 1
Your company is planning to move to a new location, and have asked your 200 employees, what factors are the most important to them in the new location. For each of the factors given below the number next to the factor is the number of employees that put the factors first, or second in importance. After this evaluation, you asked each person to rank the location first for the given factor. Location Factors A B Personal Safety (150) 80 70 50 Proximity to the Day Care (100) 50 80 70 Access to public transportation (100) 100 40 60 Parking (150) 90 60 50 The above ratings were then used to develop a score from 0 to 1 for each location with 1 being the best. On this scale determine the best location.
A company desires to locate a new facility. Based on preliminary analysis, thechoice has been reduced to four locations: A, B, C, and D. These four locationswere rated on a scale from 1 worst to 10 best on each of four criteria. Eachcriterion was also weighted to indicate its importance (i.e., the higher theweight, the more important). The list of ratings and weights follows THE TABLE ATTACHED b- If the wights of weather and regulation be divided that the weatherwould be double of the regulations, what would be the best location. Please can you give me an answer with explanation.

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