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 using the factor rating method to analyze the problem. The scale used for each factor scoring is 1 through 5.| Factor | Factor Description | Weight | Site Scores ||--------|------------------------|--------|-------------|| | | | A | B | C | D || 1 | Quality of labor | 10 | 5 | 4 | 5 | 3 || 2 | Construction cost | 7 | 3 | 2 | 4 | 1 || 3 | Transportation costs | 6 | 2 | 5 | 2 | 4 || 4 | Proximity to Markets | 5 | 2 | 2 | 4 | 4 || 5 | Taxes | 8 | 3 | 2 | 3 | 2 || 6 | Weather | 5 | 5 | 3 | 4 | 4 || 7 | Energy costs | 3 | 4 | 2 | 4 | 3 |a) Based on the given information, the best site for Daniel Tracy is **C**, with a total weighted score of **197**.b) If site D's score for Energy costs increases from 3 to a 5, its total weighted score will be **144**.Then, the best site for Daniel Tracy will be **C**, with a total weighted score of **197**.c) If site A's Weather score is adjusted to a 5, its total weighted score will be _____ (Enter your response as an integer).

Initial calculation:(c) Weather factor of A increasing to 5 instead of 2, New calculation: New weighted score will be 199

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

10.determine which location has the highest composite score.
b. A food manufacturer wants to locate a warehouse to serve its major customers. The customers, annual volume and the X and Y coordinates are shown in the table below. Customer Annual Volume X-Coordinate Y-Coordinate Judy inc 25 3 7 Zac Supermarket 13 5 2 Harry Inc. 6 8 4 Sky Productions 4 1 5 i. Using the centre of gravity location technique, determine the location coordinates that will minimize the transportation costs for their family of products
The Giant Farmer Company processes food for sale in discount food stores. It has two plants: one in Chicago and one in Houston. The company also operates warehouses in Miami, Florida; Denver, Colorado; Lincoln, Nebraska; and Jackson, Mississippi. Forecasts indicate that demand soon will exceed supply and that a new plant with a capacity of 8,000 cases per week is needed. The question is where to locate the new plant. Three potential sites are Buffalo, Atlanta, and Memphis. The two tables below give data on capacities, forecasted demand, and shipping costs that have been gathered. Plant Chicago Houston Capacity (cases per week) New plant Warehouse Plant Chicago Houston Buffalo (alternative 1) Atlanta (alternative 2) Memphis (alternative 3) For each alternative new plant location, determine the total cost of the shipping pattern that will minimize total transportation costs. Where should the new plant be located? If the new plant is located in Buffalo, the optimal cost is $ (Enter your…
Problem 8-10 Factor Initial cost Traffic Maintenance Dock space Neighborhood Location East #1 East #2 West Weight East #1 100 60 20 24 15 0 00 00 N West East #1 East #2 8 8 4 4 2 East #2 110 35 25 24 9 a. Using the above factor ratings, calculate the composite score for each location. West 110 35 Composite Score 25 13 11 b. Determine which location has the highest composite score:
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. Assuming that the factor weights must sum to 100, what range of weights would make Blake the superior location? E Click the icon to view the factors table. The total weighted factor scores are the same for the following weights: Factor A=O and Factor B =D. As the weight of Factor B becomes Blake will be the superior location. (Enter your responses as whole numbers.) More Info Factor Score for Each Location Factor City Factor Weight Blake Irmo A. Availability of resources B. Availability of customers Total 8 10 9 6. 100 Print Don
c. 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. Management-supplied the factor weights and the consultant team scores as seen in the table below. Scores are based on 50 = best. Location Factor Weight A B C Labor Climate 10 35 45 20 Taxes 30 30 40 40 Utilities 20 25 20 45 Wages 40 10 25 25 i. Which location should be selected and why?
Marilyn Helm Retailers is attempting to decide on a location for a new retail outlet. At the moment, the firm has three alternatives: stay where it is but enlarge the facility; locate along the main street in nearby Newbury; or locate in a new shopping mall in Hyde Park. The company has selected the four factors listed in the following table as the basis for evaluation and has assigned weights as shown: Factor Description Hyde Park Factor Weight Present Newbury Location 1 Average community 0.30 40 60 50 income Community growth potential 2 0.15 20 20 80 Availability of public transportation 0.20 30 60 50 Labor availability, attitude, and cost 4 0.35 80 50 50 a) Based on the given information, the best location for Marilyn Helm Retailers is to open the new retail outlet in with a total weighted score of 3.
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 Taxes 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.)
A car manufacturing company wants to start its manufacturing unit in Malaysia. For this, it selects three appropriate cities. Choose the best location for its manufacturing plant. Factors Factor Rating | Location 1 Location 2 Location 3 Labor availability 6. Facility of transportation 4 Closeness to supplies 4 3 4. 3 Basic amenities 8. 7 6. Land availability 3 4 Tax benefits 3 Preference of the owner 4. 3 4. 4. Climate conditions 4. No attempt
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
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?
7

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