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 resultsthus 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.Factor123456Factor DescriptionQuality of laborConstruction costTransportation costsProximity to MarketsTaxes7Weight10778565A5345224B3253254(Enter your response as an integer.)Site ScoresWeatherEnergy costsa) Based on the given information, the best site for Daniel Tracy is Cwith a total weighted score of 197. (Enter your response as an integer.)b) If site D's score for Energy costs increases from a 3 to a 5, its a total weighted score will be 144. (Enter your response as an integer.)Then, the best site for Daniel Tracy will be C with a total weighted score of197. (Enter your response as an integer.)c) If site A's Weather score is adjusted to a 5, its total weighted score will beC54443444312343D

Answered: Daniel Tracy, owner of Martin…

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

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
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
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
Harden College is contemplating opening a Europeancampus where students from the main campus could go to take courses for 1 of the 4 college years. At the moment, it is con-sidering five countries: The Netherlands, Great Britain, Italy, Belgium, and Greece. The college wishes to consider eight factorsin its decision. The first two factors are given weights of 0.2, whilethe rest are assigned weights of 0.1. The following table illustratesits assessment of each factor for each country (5 is best). issue
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)
← 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 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
Sap Manufacturing, a manufacturing company that manufactures football jerseys and located in Port Antonio, Jamaica, is preparing to build a new plant. J’s is considering three potential locations that are suitable for the construction of the plant. The fixed and variable costs for the three alternative locations are presented in the table below. Costs A B C Fixed Costs ($) 700,000 1,000,000 1,100,000 Variable ($ per unit) 28 20 18 Identify the range over which each alternative (A, B and C) is best. A manufacturing firm is considering three potential locations for a new parts manufacturing facility. A consulting firm has assessed three sites based on the four factors supplied by management as critical to the location's success. The factor weights and the consultant team scores are given in table 5 below. Scores are based on 50 = best. Locations Factors Weights A B C Labor Climate 10 35 45 20 Taxes 30 30 40 40 Utilities 20 25 20…
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 40 90 Computer support 0.20 85 75 Rental costs 0.15 90 55 Labor costs 0.10 80 50 Таxes 0.10 90 50 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 as a whole number.)
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.

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