The Zhao family of Atlanta, Georgia, is planning its annual summer vacation. Three vacation locations along with criteria weightsand location ratings follow. What is the recommended vacation location?CriteriaTravel distanceVacationEntertainment availableOutdoor activitiesUnique experienceFamily funO Myrtle Beach, South CarolinaOSmoky MountainsBranson, MissouriWeight253245Myrtle Beach,South Carolina557958RatingsSmokyMountains964699Branson,Missouri384598

Answered: Image /qna-images/answer/7d54a233-7762-444e-8dcd-663b624299ff.jpg

Answered: The Zhao family of Atlanta, Georgia, is…

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

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 Plot the total cost curves in a line chart and identify the range over which each location would be best.
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 received an analysis of several cities being considered for a new office complex. The data (10 points maximum) are as follows: Factor Business services Community services Real estate cost Construction costs Cost of living Taxes Transportation A с Thus, Location Score A A B с Thus, 17 17 17 8 6 4 3 2 8 9 B 6 6 Click here for the Excel Data File a. If the manager weights the factors equally, how would the locations stack up in terms of their composite factor rating scores? 8 7 7 19 19 19 5 7 is/are the best. C 6 7 7 6 8 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? is/are best and 4 8 is/are least desirable.
Identify and clarify seven key factors affecting decision on the location?
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?
Wagner Remodelers Inc. is looking for a new city in whichto relocate their home remodeling business. The companyemploys highly skilled craftspeople who rehabilitate oldhousing. Most of their current craftspeople will relocate withthe company; however, additional works at the new locationwill be hired. The most important location factors for thecompany were weighted and three target cities were scoredagainst these factors a. Which location is indicated by the preference matrix?b. Would the best location change if the company decidednot to relocate any of its current craftspeople but insteadhire only from the population at their new location?Assume that factors 8 and 9 are now given no weight andfactor 5 is twice as important.
How can the transportation method address production costs in addition to transportation costs?
Location Score Factor (100 points each) Weight A B C Convenience 0.15 87 92 84 Parking facilities 0.20 73 83 93 Display area 0.18 90 89 96 Shopper traffic 0.27 90 90 93 Operating costs 0.10 85 89 88 Neighborhood 0.10 95 87 94 1.00 Click here for the Excel Data File a. Using the above factor ratings, calculate the composite score for each location. (Do not round Intermediate calculations. Round your final answers to 2 decimal places.) Location A Composite Score B C b. Determine which location alternative (A, B, or C) should be chosen on the basis of maximum composite score. Oc OB OA 13
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
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:
Describe Strategic Importance of Location Decisions?

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

The Zhao family of Atlanta, Georgia, is planning its annual summer vacation. Three vacation locations along with criteria and location ratings follow. What is the recommended vacation location? Criteria Weight Ratings Myrtle Beach, Smoky Branson, South Carolina Mountains Missouri