17. A company has established a project team to identify a location for a new manufacturingfacility. Use a weighted scoring model to analyze three candidate locations (A, B, C) forsetting up the new factory. The relative weights for each criterion are shown in thefollowing table. A score of 1 represents unfavorable, 2 satisfactory, and 3 favorable.LocationCategoryWeightAВLabor costsLabor productivityLabor supplyUnion relationsMaterial supplyTransport costsInfrastructure202010101025512331213332211123222889

Given - Category Weight Location A Location B Location C Labor Cost 20 1 2 3 Labor…

Answered: 17. A company has established a project…

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

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
basis K- Pan American 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 for evaluation and has assigned rating weights from 1 to 5 on each factor. Subhajit Chakraborty, the CEO, has rated each location for each factor on a 1 to 100 point basis. In the table below, the rating weights and the rating value for each of the locations on the factor are presented: Factor 1 2 3 4 5 6 Factor Description Proximity to port facilities Power-source availability and cost Workforce attitude and cost Distance from Houston Rating Weight 5 3 3 3 1 2 Location A Location B 70 70 85 75 50 65 75 60 55 10 100 50 Location C 80 100 75 60 85 90 Community desirability Equipment suppliers in area a) Based on the given information, the best location for Pan American Refineries is , with a total weighted score of. (Enter your response as an integer) b) If Location B's score for Proximity to…
don't use ai answer,i will 5 upvotes
Questions i. Calculate the weighted score for each alternative location. ii. Which location should be chosen?
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?
b. An operations manager has narrowed down the search for a new King Kola plant to three locations. Fixed and variable costs follow. Location Fixed Cost Variable Cost A $100,000 $10 B $150,000 $7 C $200,000 $5 600 Annual 500 Cost ($000) 400 300 200 100 6 8 10 14 16 18 20 0 (000s of units) i. Plot the total cost curves in the chart provided above and identify the range over which each location would be best. ii. Use break-even analysis to calculate exactly the break-even quantity that defines each range.
A manager has received an analysis of several cities being considered for a new officecomplex. The data (10 pts maximum) are as follows:Location AlternativesFactors A B CBusiness Service 7 6 6Community Services 5 6 7Real Estate Cost 5 8 7Construction Cost 6 7 6Cost of Living 2 7 8Taxes 6 5 4Transportation 7 7 8a. If the manager weights the factors equally, how would the locations stack up in terms of their composite factor rating scores?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
A full-service restaurant is considering opening a new facility in a specific city. The table below shows its ratings of four factors at each of two potential sites. Weight 20 Belt Line 30 20 Factor Affluence of local population Traffic flow Parking availability Growth potential The score for Gary Mall is O 90; 100 Gary Mall 30 40 20 20 30 20 30 and the score for Belt Line is 20 10 O 18, 120 O 34, 28 O 22; 24 O.none of these
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?
Answer choices: A: 67, 0, 250 67, 0, 250 67, 0, 250 B: SIte 1, Site 2, Site 3 Note:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Answer completely. You will get up vote for sure.
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.)
Explain why shouldn't low wage rates alone be sufficient to select a location ?

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