Daniel Tracy, owner of Martin Manufacturing, must expand by building a new factory. The search for a locationfor this factory has been narrowed to four sites: A, B, C, or D. The following table shows the results thus farobtained by Tracy by using the factor-rating method to analyze the problem. The scale used for each factorscoring is 1 through 5.Factor Factor DescriptionQuality of labor123562 Construction cost3 Transportation costsProximity to Markets4567TaxesWeatherEnergy costsWeight10A53277765635363513a) Based on the given information, the best site for Daniel Tracy is(Enter your response as an integer.)B150373433Site Scoresс5345242with a total weighted score of4D523444b) If site D's score for Energy costs increases from a 2 to a 5, D's weighted score will be (Enter your response as a whole number)Then the best site for Daniel Tracy will be with a weighted score ofc) If site B's Weather score is adiusted to a 5. B's weighted score will beClick to select your answer(s).(Enter your response as a whole number.)(Enter your response as a whole number.)

FactorWeightABCDQuality of labor105555Construction cost73332Transportation cost73443Proximity to…

Answered: a) Based on the given information, the…

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

ABC is a small chain of stores specializing in casual cotton clothing. The co. currently has 5 stores and wants to open a new one in one of 3 locations. Five factors are being considered for this decision. The weights and scores assigned by a hired consultant are as follows; Location factor College proximity Median income Vehicle traffic Mall quality & size Proximity to shopping Weight 0.30 0.25 0.25 0.10 0.10 Scores (0 to 100) Mall 1 Mall 2 Mall 3 90 65 79 80 50 40 60 75 80 60 90 90 100 80 30 Required Given that all the sites have basically the same leasing costs and labor and operating costs, advice ABC on where to locate the new store.
← Daniel Tracy, owner of Martin Manufacturing, must expand by building a new factory. The search for a location for this factory has been narrowed to four sites: A, B, C, or D. The following table shows the results thus far obtained by Tracy by using the factor-rating method to analyze the problem. The scale used for each factor scoring is 1 through 5. Factor 1 2 3 4 6 7 Factor Description Quality of labor Construction cost Transportation costs Proximity to Markets Taxes Weather Energy costs a) Based on the given information, the best site for Daniel Tracy is D with a total weighted score of B Weight 10 7 7 8 A 6 5 A 5 3 4 2 B 2 5 3 2 5 4 Site Scores C 5 4 4 4 3 4 4 (Enter your response as an integer.) D 3 1 2 3 4 3
A location analysis has been narrowed down to three locations. The management needs to select the best location. The critical success factors, their weights, and the ratings for each location are shown below: Location Location Location Factor Wt. A B C Labor Cost 0.3 80 85 75 Transportation Cost 0.2 85 85 60 Market Access 0.2 90 70 90 Raw Materials Cost 0.1 80 90 90 Utility Cost 0.2 75 90 75 a) The composite score for location A is ( )b) The best location is ( )
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
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. Location Factor Factor Weight Factor Scorefor Each City Blake Irmo A. Availability of resources 5 6 B. Availability of customers 10 7 Total 100 Assuming that the factor weights must sum to 100, what range of weights would make Blake the superior location?
Let us assume that a new medical facility, Health-care, is to be located in XYZ city. The location factors, factor rating and scores for two potential sites are shown in the following table. Which is the best location based on factor rating method? in the following table. Which is the best location based on factor rating method? Sr Location factor Factor Rating Rating Location 1 Location 2 1 Facility utilization 10 5 4 2 Total patient per month 8 4 2 3 Average time per emergency trip 5 4 5 4 Land and construction costs 6 3 4 5 Employee preferences 7 4 4 6 Operations Facility 8 4 3
Alternative locations for a new drinking water treatment plant are being evaluated using four attributes identified as A, B, C, and D with weightsof 0.4, 0.3, 0.2, and 0.1, respectively. If the value rating scale is from 1 to 10, the evaluation measure of the weighted attribute method for ratings of 3,7, 2 and 10 for attributes A, B, C, and D, respectively, is closest to:a. 3.3b. 3.9c. 4.1d. 4.7
Problem 8-11 A manager has received an analysis of several cities being considered for a new office complex. The data (10 points maximum) are as follows: Location Score Factor A B C Business services 8 6 6 Community services 7 6 7 Real estate cost 3 8 7 Construction costs 5 8 7 Cost of living 3 7 8 Taxes 5 5 4 Transportation 6 7 8 a. If the manager weights the factors equally, how would the locations stack up in terms of their composite factor rating scores? A / 7 B / 7 C / 7 Thus, (Click to select) A B C B and C A and B is the best. 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 / 9 B / 9 C / 9 Thus, (Click to select) A B C A and B B and C is best and (Click to select) A B C A and B B and C…
Northeastern Insurance Company is considering opening an office in the U.S. The two cities under consideration are Philadelphia and New York. The factor ratings (higher scores are better) for the two cities are given in the following table. Factor Weight Philadelphia New York Customer convenience 0.25 70 80 Bank accessibility 0.20 35 85 Computer support 0.20 90 75 Rental costs 0.15 95 55 Labor costs 0.10 85 45 Taxes 0.10 95 55 Based on the given information, the best location for Northeastern Insurance Company to open the office is with a total weighted score of (Enter your response rounded to two decimal places.) 3
A company wants to enter into the business of manufacturing medical consumable items such as Mask, Gloves, Disposable Caps, Face shield, PPE Kits etc. It is looking for an appropriate site to set up the plant. Suggest the factors that may affect the set-up of manufacturing plant for medical consumable items. Give reason for each suggested factor that a company needs to consider while selecting a particular site.
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 basis for evaluation and has assigned rating weightsfrom 1 to 5 on each factor:FACTOR FACTOR NAME RATING WEIGHT1 Proximity to port facilities 52 Power-source availability and cost 33 Workforce attitude and cost 44 Distance from Houston 25 Community desirability 26 Equipment suppliers in area 3Subhajit Chakraborty, the CEO, has rated each location for eachfactor on a 1- to 100-point basis.FACTOR LOCATION A LOCATION B LOCATION C1 100 80 802 80 70 1003 30 60 704 10 80 605 90 60 806 50 60 90a) Which site will be recommended based on total weightedscores?b) If location B’s score for Proximity to port facilities was resetat 90, how would the result change? c) What score would location B need on Proximity to port facili-ties to change its ranking?
Northeastern Insurance Company is considering opening an office in the US The two cites under consideration are Philadelphia and New York. The factor ratings (higher scores are better) for the two cities are given in the following table Factor Customer convenience Bank accessibility Computer support Rental costs Labor costs Taxes Based on the given information, the best location for Northeastern Insurance Company to open the office is Weight 025. 020 0.20 0.15 0.10 0.10 Philadelphia 65 45 85 90 50 00 New York 75 90 80 50 50 45 with a total weighted score of Enter your response rounded to two decimal places)

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