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.Factor Factor DescriptionQuality of labor23456Construction costTransportation costsProximity to MarketsTaxes7Weight10778565WeatherEnergy costsa) Based on the given information, the best site for Daniel Tracy is Cb) If site D's score for Energy costs increases from a 3 to a 5, its a total weighted score will beA5345224B3253254Site ScoresC5434with a total weighted score of 197 (Enter your response as an integer.)(Enter your response as an integer.)D312343

Find the Calculation methods below: Total Weighted Score = ∑ (Weight * Site Scores) Part-a…

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

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…
K Subway, with more than 27,000 outlets in the U.S., is planning for a new restaurant in Buffalo, New York. Three locations are being considered. The following table gives the factors for each site. Factor Space Costs Traffic density Neighborhood income Zoning laws a) Based on the given information, the best location in Buffalo for Subway to open the new restaurant is Weight 0.25 0.25 0.20 0.15 0.15 Maitland 65 40 55 45 85 Baptist Church 75 85 85 70 20 Northside Mall 80 25 55 35 85 with a
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.)
Please do not give solution in image formate thanku.
7
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 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 Which location should be selected and why?

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